On Fri, Sep 5, 2008 at 11:27 AM, Foo Bar <bfoo33 AT yahoo.co DOT uk> wrote:
> --- 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.
>
>

How are you calculating the database size? I am confused since you are
talking about 34MB and 11MB which seem fine to me than where did you
get the 4GB from? If it is really 4GB could this be mysql saving
binary logs?

John

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