dump time progressively increasing with Innodb

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
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: dump time progressively increasing with Innodb

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
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org