-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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. 
> 2. How does one drop an index during inserts?

Make certain you've done all the optimizations you can before
undertaking something more severe like this, however. I know my copy of
MySQL was set to use very little system memory and I believe only a
single thread, even though the machine it was running on was 3 CPU with
4GB system RAM. my-huge.cnf is a good place to start, if this machine is
allowed to use a lot of resources for the DB. There are also scripts
that can give you some basic advice about how to tune your DB. I was
able to make plenty of gains through this avenue, as well as having the
proper indexes to begin with.

- --
 ---- _  _ _  _ ___  _  _  _
 |Y#| |  | |\/| |  \ |\ |  | |Ryan Novosielski - Systems Programmer II
 |$&| |__| |  | |__/ | \| _| |novosirj AT umdnj DOT edu - 973/972.0922 (2-0922)
 \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJMDowmb+gadEcsb4RAlBoAJ9ovtk59+aQ7OzdWH7cemGVOSbDWQCeN2DV
7WmaaBhPETbhG5TGO3Buxoc=
=QmNf
-----END PGP SIGNATURE-----

novosirj.vcf
Description: Vcard

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