[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Bacula-devel] small dbcheck patch for mysql


2008/9/9 Dan Langille <dan@xxxxxxxxxxxx>:
>>
>> Algorithm:
>> - when you specify "9) Check for orphaned Path records" or "10) Check
>> for orphaned Filename records" :
>> - verified the existence of the "one-column" index on the column
>> PathId (or FilenameId)
>> - if the index does not exist, then asked : "Create temporary index?
>> (yes/no):"
>> - after that dbcheck working as usual
>> - temporary index removed.
>>
>> The patch is attached.
>>
>> What would you say?
>
> Separate from the patch: suggest running some large backups, with and
> without the index.  See the difference in the times for MySQL.  That may
> help some people decide whether or not they want to run with the index all
> the time.
>

Yes, and it is.
If you answer "No" to the question "Create temporary index? (Yes /
no):" it will not create indexes.

>
> --
> Dan Langille
>
> BSDCan - The Technical BSD Conference : http://www.bsdcan.org/
> PGCon  - The PostgreSQL Conference:     http://www.pgcon.org/
>



-- 
with best regards

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-devel mailing list
Bacula-devel@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/bacula-devel


This mailing list archive is a service of Copilot Consulting.