Ulrich Leodolter schrieb:
> Hi
>
> You can try http://wiki.mysqltuner.com/
>   
tuningprimer.sh is a good thing to check first.


> 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?
>>     
Second, you should check your mysql bin log. At our backup-sd, it 
pointed out, that bulk-inserts where disabled,
so despooling took ages to complete. After recompiling bacula everything 
works fine now.

regards,
steve
>> 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...
>>     



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