Shulou(Shulou.com)06/01 Report--

Mysql looks at locked tables

Query whether to lock table show OPEN TABLES where In_use > 0; view all processes

MySQL:

Show processlist

Mariabd:

Show full processlist

Query to the corresponding process = and then kill id

Kill the process number kill $pid of the specified mysql connection to view the transaction being locked SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS; view the transaction waiting for lock SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS; view the runtime information of the innodb engine show engine innodb status\ G

Look at the sql statement that caused the deadlock, analyze the index, and then optimize the sql statement

View server status show status like'% lock%'; View timeout: show variables like'% timeout%'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.