Re: [Bacula-users] Huge MySQL database file
2010-12-09 18:29:15
On 12/9/2010 6:51 AM, Bartosz.C wrote:
> On 9 December 2010 12:32, Dan Langille <dan AT langille DOT org
> <mailto:dan AT langille DOT org>> wrote:
>
> On 12/9/2010 6:15 AM, Bartosz.C wrote:
>
> Hi,
> I have Bacula backup + MySQL database for Bacula. It works about
> half year.
> I have noticed that file of database has 160GB. Is there any
> option to
> reduce this size.
> I think that most information in this file is useless - fe
> backup that
> no longer exist.
> How to reduce size of that database file?
> Can I configure Bacula that it can be deleted themselvs such no
> needed data?
> Bartosz.
>
>
> Look at the prune / auto prune directives.
>
> --
> In my config in every Client and Pool content is AutoPrune = yes
>
> Client {
> Name = waw-samba-fd
> Address = 192.168.201.5
> FDPort = 9102
> Catalog = MyCatalog
> Password = "xxx" # password for FileDaemon
> File Retention = 30 days # 30 days
> Job Retention = 6 months # six months
> AutoPrune = yes # Prune expired Jobs/Files
> }
>
> ################## end of clients ###################
>
>
> ################## Pools #####################
>
> Pool {
> Name = sys_waw_samba_codz
> Pool Type = Backup
> Recycle = yes
> AutoPrune = yes
> Volume Retention = 6 days
> Maximum Volume Jobs = 1
> Label Format = sys_waw_samba_codz-
> Maximum Volumes = 8
> }
>
> And so on, and so on on every Clients and Pools. But it not working
> like I think it should.
Replying at the bottom keeps everything in easily-read order.
According to this, everything older than 6 days will be pruned from the
database. Are your job emails showing something similar to this:
09-Dec 07:58 bacula-dir JobId 41183: Begin pruning Jobs older than 3 years .
09-Dec 07:58 bacula-dir JobId 41183: No Jobs found to prune.
09-Dec 07:58 bacula-dir JobId 41183: Begin pruning Jobs.
09-Dec 07:58 bacula-dir JobId 41183: No Files found to prune.
09-Dec 07:58 bacula-dir JobId 41183: End auto prune.
But, hopefully, finding something to prune.
--
Dan Langille - http://langille.org/
------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
|
|