On 2006-09-19 09:44, Masopust, Christian wrote: > Hello, > > maybe you also read the answer i got about changing the indexes in the > File - table. i followed this suggestion and dbcheck now runs many times > faster than before!! > > http://paramount.ind.wpi.edu/wiki/doku.php?id=faq#why_does_dbcheck_take_forever_to_run
That can be useful. > > but good to know that dbcheck could be run in parallel to normal work > (what i didn't know up to now). I must take that back :-) , I was just lucky , since I use disk spool, and bacula was using mysql only while dbcheck was doing delete of records. When I was doing the same at home my backup started BackupCatalog (was trying) while dbcheck was waiting for a query, and in that case the tables where locked, so there was a very long wait before the backup started, and the tray-monitor was hanging, waiting for the director. If the index help as much as the wiki say, you can run it while bacula is idle anyway. /birre ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
