Simplify your business
Friday, 29 August 2008 9:15 am

MySQL database housekeeping

Wednesday, 11 April 2007  

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.

Posted in Database, SQL, Tips by Ivan
Blinklist icon Del.iocio.us icon Furl icon Reddit icon Technorati icon Yahoo! icon

Got something to say?

To protect your privacy, your email address will not be displayed.





Some basic rules for commenting:

  • Watch your language.
  • Keep comments on-topic and relevant.
  • You can use basic XHTML tags for formatting and linking but not bbcode.
  • Comments are moderated, so don't double post if your comment doesn't appear immediately.
  • Please proof-read your comments for spelling and grammar mistakes.
  • Watch your language.