-----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
|$&| |__| | | |__/ | \| _| |[EMAIL PROTECTED] - 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-----
begin:vcard
fn:Ryan Novosielski
n:Novosielski;Ryan
org:UMDNJ;IST/AST
adr;dom:MSB C630;;185 South Orange Avenue;Newark;NJ;07103
email;internet:[EMAIL PROTECTED]
title:Systems Programmer II
tel;work:(973) 972-0922
tel;fax:(973) 972-7412
tel;pager:(866) 20-UMDNJ
x-mozilla-html:FALSE
version:2.1
end: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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
