Hi,
27.11.2008 18:04, Kelly, Brian wrote:
> Arno,
>
> I've been studying different options for improving my database performance.
>
> After reading your recommendations on improving catalog performance.
>
> "There are two rather simple solutions:
> - Don't keep file information for this job in the catalog. This makes
> restoring single mails difficult.
> - Tune your catalog database for faster inserts. That can mean moving
> it to a faster machine, assigning more memory for it, or dropping some
> indexes (during inserts). If you're not yet using batch inserts, try
> to recompile Bacula with batch-inserts enabled."
>
> Could you elaborate on how to:
>
> 1. Not keep file information for particular jobs in the catalog.
In the pool definition, use "Catalog files=No". I guess it's a good
idea to use a separate pool for this type of jobs :-)
> 2. How does one drop an index during inserts?
A bit more difficult... the simple solution is to simply drop the
index from the database.
Alternatively, you could use a run before job script to drop the
index, and a run after job script to re-create it (I never tried
this). Often, creating an index newly is much faster than adding the
data for it one by one, as table entries arrive...
Arno
> Thanks,
>
> Brian Kelly
>
>
>
> -------------------------------------------------------------------------
> 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
>
--
Arno Lehmann
IT-Service Lehmann
Sandstr. 6, 49080 Osnabrück
www.its-lehmann.de
-------------------------------------------------------------------------
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
|