如需转载请标明出处:http://blog.csdn.net/itas109
QQ技术交流群:129518033
MySQL check whether the table is locked or not
SHOW OPEN TABLES FROM db_name WHERE In_use > 0 AND `Table` = 'table_name';
db_name is your database name.
table_name is your table name which you want to check.
Reference:
https://dev.mysql.com/doc/refman/5.6/en/show-open-tables.html
觉得文章对你有帮助,可以用微信扫描二维码捐赠给博主,谢谢!
如需转载请标明出处:http://blog.csdn.net/itas109
QQ技术交流群:129518033