On Wednesday 14 February 2007 13:22, Gavin Conway wrote: > Kern Sibbald wrote: > > The problem is that your Catalog database is not well tuned (missing > > indexes), or you have a very large database. The performance problem > > comes from Bacula attempting to find the next volume that will be used > > for each scheduled job, and to do so, it must generally prune the > > database. > > Kern, > > Is there a job or SQL query that can be run that'll optimise the > catalogue?
Undoubtedly, (in fact I think it is OPTIMIZE at least on MySQL), but you will need to check with your DB vendor documentation as I am not a DBA. > Like the original poster I have issues with running st dir to > the extent that I try not to use the command. You mention missing > indexes. > What would cause these not to be created during the install > process? I am sorry, I have no idea. ------------------------------------------------------------------------- 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