MySQL table ‘in use’ fix

 Tips
Feb 272009
 
  1. Guarantee Web site malware removal (joomla, drupal, wordpress etc) - don't let your business get down due to virus, malware and blacklist problem.
  2. Recommended Web Hosting to help you doing business online with high performance. : Support ioncube, zend and all other hosting by default.
  3. Get free wordpress website transfer : up to 4 domains Find out more .... Click here to see other user testimonial

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

sucuri long MySQL table in use fix

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

table in use MySQL table in use fix

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 MySQL table in use fix

Just ignore that message, it means everything get back to normal icon smile MySQL table in use fix

hg MySQL table in use fix

Sorry, the comment form is closed at this time.