当前位置：网站首页>MySQL check whether the table is locked

MySQL check whether the table is locked

2022-07-26 06:51:00 【Leon_ Jinhai_ Sun】 

mysql Look at the locked table 
 
 Check whether the table is locked 
show OPEN TABLES where In_use > 0;
 View all processes 
MySQL:
 
show processlist;
mariabd:
 
show full processlist;
 Query the corresponding process === then  kill id
 
 Kill the designated mysql The process number of the connection 
kill $pid
 View the transaction being locked 
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS; 
 View transactions waiting for locks 
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS; 
 see innodb Run time information for the engine 
show engine innodb status\G;
 See what caused the deadlock sql sentence , Analyze the index situation , And then optimize sql sentence ;
 
 View server status 
show status like '%lock%';
 Check the timeout ：
show variables like '%timeout%';

原网站

版权声明
本文为[Leon_ Jinhai_ Sun]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/201/202207181834113731.html

边栏推荐

猜你喜欢

随机推荐