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

Jason Selwitz wrote:
>   Anyone have any tips on keeping the Bacula MySQL database to a
> manageable size, I'm fighting with a 36gb database right now and
> followed the info in the handbook to dump it and re-import it but it
> didn't really save any space, just wondering if anyone has any
> suggestions. thanks.

First thing you'd want to find out is what-all is in there? That 36GB
has to be getting taken up by something. Is it old jobs that you're
keeping forever? Is it orphaned jobs for orphaned clients that contain
file listings, etc? The database can really only get large when you fill
it with something. When you find out what, you can manage/prune that stuff.

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

iD8DBQFJPK/Vmb+gadEcsb4RAp+yAKC4OwNuEWGIL/2h8IKVCUcxoTg1fwCfTb/z
XFq2oZ4S13wDc7aCQxRxg+w=
=mpaQ
-----END PGP SIGNATURE-----

novosirj.vcf
Description: Vcard

------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you.  Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users