Innodb Storage engine Monitoring

Innodb storage engine monitoring is divided into four types, table monitoring, tablespace monitoring, lock monitoring, status monitoring. You can enable the monitoring option in the mysql client, and then the information will be output in the mysql error log. Innodb_monitor and innodb_lock_monitor will record InnoDB monitoring information in the error log every 15 seconds, innodb_table_monitor and innodb_tablespace_monitor every 64 seconds.

1. Monitor the status of innodb

Create table innodb_monitor (an int) engine=innodb;-enable monitoring

Drop table innodb_monitor;-turn off monitoring

two。 Monitor the innodb lock

Create table innodb_lock_monitor (an int) engine=innodb;-enable monitoring

Drop table innodb_lock_monitor;-turn off monitoring

3. Table monitoring of innodb

Create table innodb_table_monitor (an int) engine=innodb;-enable monitoring

Drop tables innodb_table_monitor;-turn off monitoring

4. Monitor innodb tablespace

Create table innodb_tablespace_monitor (an int) engine=innodb;-enable monitoring

Drop table innodb_tablespace_monitor;-turn off monitoring