Hi

You can try http://wiki.mysqltuner.com/
to optimize your mysql settings.

Ulrich

On Mon, 2008-09-22 at 09:16 +0200, Adrian Moisey wrote:
> Hi
> 
> Does anyone have any bacula specific help wrt using a mysql backend for 
> bacula?
> 
> My DB is growing and getting very slow, can i add indecies or run a 
> cleanup to speed it up?
> 
> The only thing I've found on the bacula site is this:
> http://www.bacula.org/en/rel-manual/Catalog_Maintenance.html#SECTION002420000000000000000
> 
> Also, how long should I retain a job for in the database?
> Currently it is set to 6 months, but that may be a little long...
-- 
Ulrich Leodolter <ulrich.leodolter AT obvsg DOT at>
OBVSG


-------------------------------------------------------------------------
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