MySQL table ‘in use’ fix

My wife blog got strange behaviour, in comment section no comment at all even she claim that she has around 4000 rows in column.

I inspect the tables in database using phpmyadmin to see this :

table_in_use

wp_comments table status show ‘in use‘ . This state made those behaviour in her blog.

To solve this problem :

1. Select table by put thick near the name

2. Choose action ‘repair table’ and execute it.

When it’s done you’ll see this page :

table_in_use2

Just ignore that message, it means everything get back to normal 🙂