MySQL Forums
Forum List  »  InnoDB

Locked tables showing "In use"
Posted by: Joost Schouten
Date: June 24, 2005 05:49AM

Hi,

I use InnoDB and experiance a problem. All my tables seem to be locked. They show up as "In use" on the PHPMyAdmin GUI.

A restart of my MySQL or my entire server does not release the lock. I would like to understand the folowing:

- How can I manually unlock?
- How do I unlock in batch (I have 30 databases with this problem all containing 25 tables)
- What could have caused this problem.

Some information on my enviroment.
- Linux Fedora 3
- MySQL 4.1.11-standard
- Running cPanel/WHM for managing my hosting accounts (currently two accounts run just for us interanlly, one production one beta)

Information on the changes made when:
After I changed the account name for one of my accounts in WHM the locking seemed to have occured. I am not sure this is the cause of the error but it did happen just therafter.

Thank you for your help,
Joost Schouten

Options: ReplyQuote


Subject
Views
Written By
Posted
Locked tables showing "In use"
2660
June 24, 2005 05:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.