Re: [Bacula-users] Purge Log table - was: Re: Restore performance

2011-09-22 Thread Alexandre Chapellon
Le 22/09/2011 09:11, Eric Bollengier a écrit : Hello, Great information Chris , thank you! However Marcio setup seems to show that the Log table is not purged as expected. I have checked on my setup too and while I have almost 2000 rows in y Log tabl

Re: [Bacula-users] Purge Log table - was: Re: Restore performance

2011-09-22 Thread Jeremy Maes
Op 22/09/2011 8:38, Alexandre Chapellon schreef: Le 21/09/2011 21:25, Chris Shelton a écrit : 2011/9/21 Marcio Merlone > Em 21-09-2011 14 :45, Alexandre Chapellon escreveu: Le 21/09/2011 18:56, Marcio Merlone a écrit : Em 21-09-2011 13 :33, Ale

Re: [Bacula-users] Purge Log table - was: Re: Restore performance

2011-09-22 Thread Eric Bollengier
Hello, > Great information Chris , thank you! > However Marcio setup seems to show that the Log table is not purged as > expected. > I have checked on my setup too and while I have almost 2000 rows in y > Log table, I have only 150 entries in the Job table. Having 10 lines of log per job is not u

Re: [Bacula-users] Purge Log table - was: Re: Restore performance

2011-09-21 Thread Alexandre Chapellon
Le 21/09/2011 21:25, Chris Shelton a écrit : 2011/9/21 Marcio Merlone Em 21-09-2011 14:45, Alexandre Chapellon escreveu: Le 21/09/2011 18:56, Marcio Merlone a écrit :

Re: [Bacula-users] Purge Log table - was: Re: Restore performance

2011-09-21 Thread Chris Shelton
2011/9/21 Marcio Merlone > Em 21-09-2011 14:45, Alexandre Chapellon escreveu: > > Le 21/09/2011 18:56, Marcio Merlone a écrit : > > Em 21-09-2011 13:33, Alexandre Chapellon escreveu: > > As Gavin pointed out, a 150GB database is huuuge for only a dozen > client. > Unless you have billion

Re: [Bacula-users] Purge Log table - was: Re: Restore performance

2011-09-21 Thread Marcio Merlone
Em 21-09-2011 15:24, Alexandre Chapellon escreveu: maybe you could try this: http://dev.mysql.com/doc/refman/5.0/en/innodb-multiple-tablespaces.html However, I'd like to know if this table can be safely purged? As one day or another it will grow to an unacceptable size... (even more if I have t

Re: [Bacula-users] Purge Log table - was: Re: Restore performance

2011-09-21 Thread Alexandre Chapellon
Le 21/09/2011 20:03, Alexandre Chapellon a écrit : Le 21/09/2011 19:53, Marcio Merlone a écrit : Em 21-09-2011 14:45, Alexandre Chapellon escreveu: Le 21/09/2011 18:56, Marcio Merlone a écrit 

Re: [Bacula-users] Purge Log table - was: Re: Restore performance

2011-09-21 Thread Alexandre Chapellon
Le 21/09/2011 19:53, Marcio Merlone a écrit : Em 21-09-2011 14:45, Alexandre Chapellon escreveu: Le 21/09/2011 18:56, Marcio Merlone a écrit : Em 21-09-2011 13:33, Alexandre Chapellon escreveu:

[Bacula-users] Purge Log table - was: Re: Restore performance

2011-09-21 Thread Marcio Merlone
Em 21-09-2011 14:45, Alexandre Chapellon escreveu: Le 21/09/2011 18:56, Marcio Merlone a écrit : Em 21-09-2011 13:33, Alexandre Chapellon escreveu: As Gavin pointed out, a 150GB database is huuuge for only a dozen client. Unless you have billions of files on each client there is no reas