Eric Bollengier wrote:
> Le Wednesday 01 July 2009 17:20:22 Bruno Friedmann, vous avez écrit :
>> This is just a question if the need exist
>> [ Y / N ]
>>
>> Insert the necessary command to dbcheck to optimize compact tables after a
>> full run.
>>
>> optimize for mysql / vaccum [whatever is not auto] / pack for sqlite.
>>
>> I've done a dbcheck ( half-year maintenance ) on a customer site yesterday
>> and I've made the optimize inside the mysql bacula tables.
>> We get half index size and 1/3 data length.
>>
>> A full restore on big jobs take now <3minutes to build the path opposite to
>> the 10 minutes before.
>>
>> Don't know if this could be a baby-dev job or not ? ( sql writing is ok for
>> me, not really c/c++ )
>
> Hello Bruno,
>
> I would say that optimize or vacuum should be run everyday or twice per week.
> dbcheck should be used one per month or twice per year and needs bacula to be
> stopped...
oups never stop bacula :-)
>
> So, i prefere having admin or crontab jobs for that.
>
> Bye
Seems also reasonable. This should be writted somewhere in the wiki under admin
task
(I really must learn how to do this. )
--
Bruno Friedmann
Ioda-Net Sàrl
2830 Vellerat - Switzerland
Tél : ++41 32 435 7171
Fax : ++41 32 435 7172
gsm : ++41 78 802 6760
www.ioda-net.ch
Centre de Formation et de Coaching En Ligne
www.cfcel.com
------------------------------------------------------------------------------
_______________________________________________
Bacula-devel mailing list
Bacula-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-devel
