[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
Bacula-devel mailing list

This mailing list archive is a service of Copilot Consulting.