List:General Discussion« Previous MessageNext Message »
From:Carsten Pedersen Date:March 8 2010 9:59am
Subject:Re: dump time progressively increasing with Innodb
View as plain text  
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
> 
> 
> 
Thread
dump time progressively increasing with InnodbNico Sabbi8 Mar
  • Re: dump time progressively increasing with InnodbCarsten Pedersen8 Mar