MySQLinnodb_monitor and Deadlock Detection

Show innodb status is only a direct display mode, and can only be turned on interactively. It cannot automatically capture information cyclically. innodb status information can be output to the err log library. We recommend that youTestCreate the following table in the database: mysql> create table innodb_monitor (a int) engine = innodb;
Query OK, 0 rows affected (0.09 sec)

Mysql> create table innodb_tablespace_monitor (a int) engine = innodb;
Query OK, 0 rows affected (0.12 sec)

Mysql> create table innodb_lock_monitor (a int) engine = innodb;
Query OK, 0 rows affected (0.13 sec)

Mysql> create table innodb_table_monitor (a int) engine = innodb;
Query OK, 0 rows affected (0.09 sec)

After a table is created, innodb outputs the innodb status informationError logTo stop the monitor function by deleting a table.

• Innodb_monitor: Actually show engine innodb status \ G

• Innodb_lock_monitor: similar to innodb_monitor, but there will be