--- On Fri, 5/9/08, Ryan Novosielski <novosirj AT umdnj DOT edu> wrote:

> > If nothing is actually wrong and the catalog is simply
> huge because
> > it's been running for a year or so, how do I keep
> its size down? This
> > will become a major problem when the system goes into
> production and
> > needs to handle a lot more machines.
> 
> The "files" portion of the catalog takes up a lot
> of space. As can the
> "messages" if you're sending them to the
> catalog (which is required for
> bweb if you want to see status of backup jobs).

I send messages by mail, not sure about catalog. But surely the catalog with 
job and filename info cannot possibly be as large as the actual files it points 
to? I mean, file retention limits are 3-7 days for the clients I defined and 
job retention 1-2 months, so the majority of the information should be gone in 
a week.

If I do a sudo du -sh /var/lib/mysql/bacula/ it returns
34M     /var/lib/mysql/bacula/

If I do sudo mysqldump -f --opt bacula > /tmp/bacula.sql
the file size is 11M. For 3 clients with daily backups that are kept at most 7 
days, this should be at most 230 MB or so, not 4 GB.

> dbcheck might help you here if you have a lot of orphaned
> computers/files/etc. in there. Sounds like you must,
> because none of
> your file retention stuff is out of what.

dbcheck (with modify database bit set) which I ran yesterday, reports some 
orphaned paths and files, but doesn't change anything in the catalog file after 
a new backup run either (well, the catalog actually grew 11 MB since yesterday).

> The data is NOT stored in the catalog.

Is there a quick check to make sure? What about the blocks of binary in it? 
(could be the catalog info is getting encrypted?)

Hm, come to think of it, growing by 11 MB of data daily for say one year should 
come close to the current catalog size. But that would mean my retention 
periods aren't working.


      

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