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++ )
--
Bruno Friedmann
------------------------------------------------------------------------------
_______________________________________________
Bacula-devel mailing list
Bacula-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-devel
