MySQL Lock monitor

Are you still ashamed to read Ho Dengcheng's lock-processing analysis article?

Still in because of the master of the clerical error, into a deep confusion?

As long as you have more than 5.6.16 version of MySQL, lock monitor you deserve to have!

Quick Start

Open

Set global Innodb_status_output=on;set global innodb_status_output_locks=on;

Real:

Mysql> Show CREATE TABLE My_test1_0\g
1. Row ***************************
Table:my_test1_0
Create table:create Table ' My_test1_0 ' (
' id ' int (one) is not NULL,
' col2 ' int (one) DEFAULT NULL,
' col3 ' varchar (+) DEFAULT NULL,
' col4 ' varchar DEFAULT NULL,
' COL5 ' varchar (+) DEFAULT NULL,
PRIMARY KEY (' id '),
KEY ' idx_col2 ' (' col2 '),
KEY ' Idx_col3_col4 ' (' col3 ', ' col4 ')
) Engine=innodb DEFAULT charset=latin1
1 row in Set (0.08 sec)

INSERT into MY_TEST1_0 (ID) VALUES (1), (2), (3);

Update my_test1_0 set col5= ' Jiji ' where id=1;

View

Show Engine InnoDB Status\g

Everything at a glance.

MySQL Lock monitor