MySQL table ‘in use’ fix

Posted at February 27, 2009

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 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 :-)

Related Reading:

Using DrupalUsing Drupal

With the recipes in this book, you can take full advantage of the vast collection of community-contributed modules that make the Drupal web framewo... Read More >

Drupal For DummiesDrupal For Dummies

Learn to set up, manage, and administer a Drupal Web site

Drupal offers unparalleled flexibility for content-managed Web sites, but most ... Read More >

Pro Drupal Development, Second EditionPro Drupal Development, Second Edition

Widely praised for its in–depth coverage of Drupal internals, bestselling Pro Drupal Development has been completely updated for Drupal 6 in thi... Read More >

Front End Drupal: Designing, Theming, ScriptingFront End Drupal: Designing, Theming, Scripting

“For Drupal to succeed, we need books like this.”

–Dries Buytaert, Drupal founder and project... Read More >

Cracking Drupal: A Drop in the BucketCracking Drupal: A Drop in the BucketThe first book to reveal the vulnerabilities and security issues that exist in the sites that have been built with Drupal?and how to prevent them from... Read More >

Thanks for reading, if you think this post help you please consider to buy me a beer

Search Terms :

  • mysql table in use
  • phpmyadmin table in use
  • mysql tables in use
  • phpmyadmin in use
  • table in use mysql
  • mysql in use
  • mysql table inuse
  • mysql table in use error
  • table in use how to fix
  • in use phpmyadmin
  • tables in use phpmyadmin
  • phpmyadmin table in use why
  • mysql tables phpmyadmin in use
  • phpmyadmin shows in use
  • phpmyadmin posts table in use wordpress
  • mysql tablle shows inuse
  • mysql why table in use
  • phpmyadmin in use tables
  • phpmyadmin in use problem
  • mysql repair error in use

    • Share/Bookmark
    Tips

    If you enjoyed this post, please consider to leave a comment or subscribe to the feed and get future articles delivered to your feed reader.

    Comments are closed.