OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: dump time progressively increasing with Innodb

From: Carsten Pedersen (carstenbitbybit.dk)
Date: Mon Mar 08 2010 - 03:59:01 CST


OPTIMIZE TABLE sometimes helps, ymmv.

http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html

/ Carsten

Nico Sabbi skrev:
> Hi,
> I noticed that over the months the dump of my databases (very
> subject to modifications, but not subject to increase significantly in
> size) gets progressively slower: from ~8 minutes to almost 15 in 6
> months.
>
> How can I avoid this degeneration?
>
> Thanks,
> Nico
>
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql