MySQL table lock-unlock

Encounter Problems ""

With the tool navicat open a table, sometimes you will find out how to open the table, close the Navicat tool, and then open, is the same state.

To view a table lock:

Show OPEN TABLES where In_use > 0;

Check to see if the table is locked.

--Check the process number show processlist; This is the table lock.

| 10664505 | Root | Ip:port | Tables |  Query | 5074 | Waiting for table Metadata Lock | ALTER TABLE ' Tables '

10664505 is the ID

Kill the lock table process ID

Kill 110664505;

Open it again with the tool, it's ready.

This article is from the "10093778" blog, please be sure to keep this source http://10103778.blog.51cto.com/10093778/1949554

MySQL table lock-unlock