How to repair MySQL Tables
By Madhur Kapoor on Feb 4, 2008 in Blogging, Tutorials, Wordpress
Sometimes it is possible that your Wordpress database can become overburdened in the process of fetching so much requests and because of it, it will create overhead. As time progresses, overhead values of some tables can become very high and it might cause the database to crash, like what happened to me recently. It is similar to the concept of defragmentation in windows. To keep your database healthy and free of any overheads, just follow the steps shown below
1) Open phpMyAdmin client and select your wordpress database and click on its name
2) You will now see all the tables of the database as shown below.
3) Select the checkbox of each table which have an overhead value
4) Go to the drop down menu “with selected” and select repair table
5) An sql query will now be executed and if everything works fine, you will see a screen similar to the one shown below.
This way all the overhead value will be cleared. If the overhead values is under a kilobyte, it isn’t much of a problem but sometimes the overhead value can become very large. So it is better to perform these steps once every few days so as to keep your database healthy.
Great it worked for you. I had seen this isssue at some more places. This post will be a great help to them
Ashish Mohta | Feb 5, 2008 | Reply
How much was your overhead when your database got corrupted?
Binny V A | Feb 5, 2008 | Reply
@Binny
around 3 MB
Madhur Kapoor | Feb 5, 2008 | Reply
Very cool post Madhur… I can’t begin to tell you how helpful this will be for many WordPress bloggers.
Garry Conn | Feb 5, 2008 | Reply
Interesting Madhur, You wont have to worry about this unless you receive a large influx of traffic over a short period of time though right.
SauceTheGame | Feb 5, 2008 | Reply
Good to see that everything is back to normal for you. Nice tutorial.
Nirmal | Feb 6, 2008 | Reply
Thank you for sharing the steps. This is very useful. Anyway the steps are very clean and easy to understand.
Jacklin | Feb 7, 2008 | Reply
Great write up!
Bookmarked for future reference
Kyle Eslick | Feb 7, 2008 | Reply
Great tips for bloggers Madhur. Learning from experience is the best.
Syahid A. | Feb 8, 2008 | Reply
This is cool although I am afraid to work in Mysql
Dexter | Techathand.net | Feb 9, 2008 | Reply