James Cort a écrit : > Many thanks for your patch. I compiled it, and it's been running > against my database since last Thursday. > > It's still going. I've long since lost count of how many records it's > cleared out, but the database backup is slowly shrinking. > > > Hi,
Personnaly I resolved this problem by creating indexes before dbchecking. This solution was given on this list some month ago. Without them, dbchecking was taking hours (or days ? I don't know, I stopped the dbcheck before its end :-) ). With them, it just takes minutes, even with very huge databases (40 GB) ! Here are they : $ mysql -u bacula database_name mysql> create index File_PathId_idx on File(PathId); mysql> create index File_FilenameId_idx on File(FilenameId); And then just run dbcheck (in batch mode here) : /usr/sbin/dbcheck -f -b -C CatalogName <http://www2.univ-pau.fr/wikiciuppa/wakka.php?wiki=ImapCatalog/edit> -c /etc/bacula/bacula-dir.conf Than don't forget to remove the indexes, cause it will slow down insertions when backing up : mysql> drop index File_FilenameId_idx on File; mysql> drop index File_PathId_idx on File; Personnaly, I then run an OPTIMIZE : mysql> OPTIMIZE TABLE File, Path, Filename; Hope this will help you to clean your bases faster ! Cheers, -- Yann Cézard Centre des Ressources Informatiques - Université de Pau et des Pays de l'Adour Bat IFR, rue Jules Ferry, 64000 PAU ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier. Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
