Mysql: Waiting for table metadata lock

In Mysql shell execute:

SHOW ENGINE INNODB STATUS \G

Look for the Section –

 TRANSACTIONS

Find transaction like:

---TRANSACTION 242390461, ACTIVE 11479 sec
1246 lock struct(s), heap size 139472, 86165 row lock(s), undo log entries 13100
MySQL thread id 55443, OS thread handle 139631267161856, query id 62644999 <IP> <user> cleaning up
Trx read view will not see trx with id >= 242378242, sees < 242341382

In my case Thread 55443 looks like:

| Id    | User | Host | db | Command | Time   | State  | Info |
| 55443 | <user> | <IP>:14925 | <database>  | Sleep | 0 | | NULL

Thread already dead with time=0 but lock table during 11479sec, so we kill them

mysql > kill 55443 ;

Добавить комментарий