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

Reply via email to