Answers for "How to avoid table lock in MySQL"

how to unlock table in mysql

UNLOCK TABLES;

Posted by: Guest on July-01-2021

how to find table lock and row lock in mysql

SHOW OPEN TABLES WHERE `Table` LIKE '%[TABLE_NAME]%' AND `Database` LIKE '[DBNAME]' AND In_use > 0;

Posted by: Guest on June-26-2021

Code answers related to "How to avoid table lock in MySQL"