开发者

show mysql myisam locks

开发者 https://www.devze.com 2023-02-12 01:59 出处：网络

when dropping or renaming a table with myisam storage engine, I realize that it\'s waiting for table metadata lock, however, show full processlist doesn\'t reveal the offending query.any idea?

相关专题：

when dropping or renaming a table with myisam storage engine, I realize that it's waiting for table metadata lock, however, show full processlist doesn't reveal the offending query. any idea?

| 462 | root | x开发者_如何学JAVAxx.xxx.xxx.xx:54658 | mydb | Sleep   | 1162 |                                 | NULL                                                 |
| 465 | root | localhost           | mydb | Query   |    0 | NULL                            | show full processlist                                |
| 466 | root | localhost           | mydb | Query   |  125 | Waiting for table metadata lock | alter table mytable rename to mytable_junk |

Show processlist will only show connections for the current user. Login as root, or add "Process" permissions to your user.