[Solved]Locked table in MySQL

Last updated on December 1st, 2010 at 12:36 am

  • InnoDB Supports transactions, row-level locking, and foreign keys
  • MyISAM Default engine as of MySQL 3.23 with great performance

I’m running phpwind with huge requests. I meet the problem is every time my database will be freeze and lockup.
I’ve been traced for few days, I found that the tables
pw_datastore and pw_threads always in status ‘Locked’

and the query keep que until the connections full, then have to wait the Locked to be unlocked then can go on. But it always won’t, maybe wait for an hour. I found the solution is converting your current MyISAM to InnoDB, so your database won’t be locked up anymore.

I’ve solved my current ‘Locked’ problem, if any more problem, I will post it up here.