On Wednesday 20 September 2006 11:34, Uwe Schuerkamp wrote: > On Wed, Sep 20, 2006 at 11:15:39AM +0200, Kern Sibbald wrote: > > > > For your performance problems: > > > > Please read the Catalog Maintenance chapter of the manual: > > > > http://www.bacula.org/dev-manual/Catalog_Maintenance.html > > > > In particular the Performance section in that chapter. It tells you how to > > resolve these kinds of problems. > > Hi Ken, > > thanks for your reply. I've gone over that section a couple of times > and have changed the my.cnf as mentioned. I guess I'll play with the > optimize table statement a bit then. > > Also, I've checked that all the necessary indices are there, and as > I've said write performance is excellent, so why shouldn't "prune" > performance be excellent, too? Is 10 GB database size too much for the > backup volume I mentioned in my first email?
10 GB is pretty big, but there are users with databases that large. Take a look at src/cats/make_mysql_tables. There are a few tips in that file for creating extra indexes if you have slow pruning. Once you have the indexes properly setup for your site requirements, pruning should run in a maximum of a couple of minutes. > > Cheers & thanks, uwe > > > > -- > Uwe Schuerkamp, NIONEX GmbH (http://www.nionex.com/) > [EMAIL PROTECTED] Tel: +49 (0)5241 / 80 10 66 FAX: / 806 23 38 > Avenwedder Str. 55, D-33311 Guetersloh, Germany > GnuPG KeyID: 5887047D, Fingerprint: 2E1320229A3F63 7F676FE9B1A836A461 > > ------------------------------------------------------------------------- > 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/bacula-users > ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
