How to Waiting for table metadata lock on Truncate Table
How to Waiting for table metadata lock on TRUNCATE TABLE? Problem: In MYSQL there is a long running session which is waiting for “TRUNCATE TABLE XXXXXXX” Cause: You can check the running active sessions by show full processlist; or using any explorer tools like MYSQL Workbench. To confirm which transaction is holding the truncate table. You can execute the followingRead More »