For what it's worth I've created these two sql files that I use before 
and after every dbcheck:

::::::::::::::
extra_indexes.sql
::::::::::::::
create index File_PathId_idx on File(PathId);
create index File_FilenameId_idx on File(FilenameId);
::::::::::::::
remove_extra_indexes.sql
::::::::::::::
drop index File_FilenameId_idx on File;
drop index File_PathId_idx on File;


The create index commands take a while to work, but then the dbcheck 
goes much more quickly.  My catalog is about 500MB.  I was told if I 
didn't remove the extra indexes it would slow down insert operations.

Without these, the dbcheck will apparently never finish, with a dual 
xeon 3.2 Ghz and 10kRPM u320 disks...

If I've said this before pardon me for repeating myself, but this should 
be a explicitly addressed in the docs/FAQs.


Ryan Novosielski wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hello again, all:
>
> I've written about this before at least twice and it seems that everyone
> is either ignoring it or has no insights. I would really appreciate some
> help here if anyone has anything to offer. It looks like if not, I'm
> left to drop my database and scan back all the tapes because it really
> cannot continue like this.
>
> I am running Bacula 2.2.8 from the Blastwave packages on Solaris 9,
> which use MySQL 5.0.51. I have had this database awhile, so I figured I
> would go through and try to clean it up. I have clients that are no
> longer being backed up, maybe some old tapes -- the kind of stuff that
> dbcheck cleans up.
>
> The problem is, dbcheck never seems to finish. I'm not sure if it ever
> will, but it cannot be completed in the nearly 72 hours on the weekend
> that I can allow it to run before it starts to impact production
> backups. Here is what it's doing:
>
> | 187 | bacula | localhost | bacula | Query   | 198111 | Copying to tmp
> table | SELECT DISTINCT Path.PathId,File.PathId FROM Path LEFT OUTER
> JOIN File ON (Path.PathId=File.PathId)
>
> As far as I can tell, I have every index that is listed in the manual.
> If someone is interested to see them, I will paste them, though as I
> said I've done that before a number of times and no one has been
> interested. Before I dig them up, perhaps someone can offer some help.
>
> Thank you!
>
> - --
> ~ ---- _  _ _  _ ___  _  _  _
> ~ |Y#| |  | |\/| |  \ |\ |  | |Ryan Novosielski - Systems Programmer II
> ~ |$&| |__| |  | |__/ | \| _| |novosirj AT umdnj DOT edu - 973/972.0922 
> (2-0922)
> ~ \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.5 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFIqYS/mb+gadEcsb4RAv/OAJ0aij06NqEj4x8ZSawXoSgtJSBmFQCgjFsZ
> 6Sm1utw2gL4CAG7cad3Gttc=
> =2a7j
> -----END PGP SIGNATURE-----
>
> -------------------------------------------------------------------------
> 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-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>   

-------------------------------------------------------------------------
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-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users