[Solved]Locked table in MySQL

  • 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.


Tags: , , , , , ,

Translate

Buy me a Caffè Latte

Thank you for the Caffè Latte

2013/02/15 saw art
2013/01/25 Parul Patel
2012/11/20 Barbara Nicholas $10
2012/10/08 Amy Stockman $5
2012/07/15 siewho chang $ 50
2012/06/08 Susan Hampton $10
2012/05/11 Chris Grima $10