Check if a table is locked in MySQL.

1 year ago
Ava Mitchell
1 minute

There are two methods to check if a table is locked in MySQL.

  1. Use the SHOW PROCESSLIST command to check the current MySQL process list and see if there are any processes locking tables. If there are processes locking tables, it indicates that MySQL is currently locking the tables.
SHOW PROCESSLIST;
  1. Query lock information in the current database using the INFORMATION_SCHEMA table.
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;

This will display the current locked tables and information about locked transactions.

If none of the above methods show that the table is locked, then the table is not locked.

bannerAds