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

Editor to share with you mysql to check whether the data table is locked, I hope you will learn a lot after reading this article, let's discuss it together!

Mysql's way to see if the datasheet is locked: first open a command prompt, log in to mysql;, and then execute the [show engine innodb status\ G;] command from the command prompt.

Specific methods:

First open a command prompt and log in to mysql

Then execute the following command on the mysql command line:

Show engine innodb status\ G

View the sql statement that caused the deadlock

Show status like'% lock%'

View the current lock table status

Show OPEN TABLES where In_use > 0; after reading this article, I believe you have a certain understanding of mysql's method of checking whether the data table is locked. You want to know more about it. Welcome to follow the industry information channel. Thank you for your reading!

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.