Show engine InnoDB status display information not all how to solve _mysql

question :
When performing the show engine InnoDB Status\g, the information displayed is not complete, deadlock information is too much, the back is gone
Reason:
This is a bug:bug#19825 of the MySQL client, with the interactive client limiting the maximum output to 64KB, so more information cannot be displayed.

Solution :
There are two ways to fix this:
1. Enable Innodb_status_file
Modify MY.CNF to add a line similar to the following
Innodb_status_file = 1
It's OK.

2. Enable Innodb_monitor
Mysqld Online Runtime, create a innodb_monitor table, you can record the relevant information to the log file
Mysql> CREATE TABLE innodb_monitor (id int) engine = InnoDB;
The relevant information is exported to the. Err log file.