MySQL database housekeeping
As part of regular ongoing database housekeeping, you should repair and optimise your MySQL tables on a regular basis.
To repair one or more tables:
repair table table1, table2, table3, table4, table5;
To optimise one or more tables:
optimize table table1, table2, table3, table4, table5;
Depending on how dynamic your database is, you should probably aim to do both of the above at least once a month. And always repair your tables before your optimise them.
Due to the large volume of spam, comments are disabled. If you have anything relevant to say, you can leave a , or contact me directly.
About the author
I'm Ivan Lutrov and I'm the owner of Lutrov Interactive. I have 25 years of experience producing interactive work and I create cost effective business websites that are simple, engaging and easy to use. I practice what I preach and I say what I really think, even if it's sometimes not what you want to hear. Subscribe to the Lutrov Interactive feed via RSS and follow me on Twitter.