dump time progressively increasing with Innodb

2010-03-08 Thread Nico Sabbi
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=arch...@jab.org



Re: dump time progressively increasing with Innodb

2010-03-08 Thread Carsten Pedersen

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=arch...@jab.org