InnoDB Monitor

The output of InnoDB Monitor goes to stderr every 15 seconds unless configured otherwise...

In practice this usually means that the output goes to mysqld.log 

under /var/log or a custom location like /mysql/data if installing from a tarball

Check

NOTE: Only works since 5.6.16. For earlier versions refer to the MySQL documentation.

To check whether Standard InnoDB Monitor and the InnoDB Lock Monitor  is enabled...

SHOW VARIABLES LIKE '%innodb_status_output%';

Enable

NOTE: When you shutd down the server, the innodb_status_output variable is set to OFF.NOTE: The PROCESS privilege is required to enable InnoDB Monitors.NOTE: Only works since 5.6.16. For earlier versions refer to the MySQL documentation.

To enable the Standard InnoDB Monitor...

SET GLOBAL innodb_status_output=ON;

To enable the InnoDB Lock Monitor...

SET GLOBAL innodb_status_output_locks=ON;

The Standard InnoDB Monitor must also be ON for this to be generated every 15 seconds. But you may wish to set it on independently for use with the On Demand output (see below).

Disable

NOTE: When you shutd down the server, the innodb_status_output variable is set to OFF.NOTE: The PROCESS privilege is required to disable InnoDB Monitors.NOTE: Only works since 5.6.16. For earlier versions refer to the MySQL documentation.

To disable the Standard InnoDB Monitor...

SET GLOBAL innodb_status_output=OFF;

To disable just the InnoDB Lock Monitor...

SET GLOBAL innodb_status_output_locks=OFF;

InnoDB Monitor Output On Demand

Use...

SHOW ENGINE INNODB STATUS\G

This will include InnoDB Lock Monitor data if it is enabled

Bibliography