when dropping or renaming a table using the myisam storage mechanism, I understand that waiting for the table metadata to lock, however, shows a complete list of processes, does not open an abusive request. any idea?
| 462 | root | xxx.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 |
source
share