-----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
|$&| |__| | | |__/ | \| _| |[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
iD8DBQFJPK/Vmb+gadEcsb4RAp+yAKC4OwNuEWGIL/2h8IKVCUcxoTg1fwCfTb/z
XFq2oZ4S13wDc7aCQxRxg+w=
=mpaQ
-----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
------------------------------------------------------------------------------
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
