MySQL Bugs: #71639: Manual does NOT describe innodb_status

Bug #71639	Manual does NOT describe innodb_status_output* server variables
Submitted:	9 Feb 2014 15:35	Modified:	13 Feb 2014 14:54
Reporter:	Valeriy Kravchuk	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S2 (Serious)
Version:	5.6	OS:	Any
Assigned to:	Daniel Price	CPU Architecture:	Any
Tags:	. innodb_status_output_locks, innodb_status_output, missing manual

Description:
MySQL 5.6 supports innodb_status_output and innodb_status_output_locks server variables:

mysql> show variables like 'innodb_status%';
+----------------------------+-------+
| Variable_name              | Value |
+----------------------------+-------+
| innodb_status_output       | OFF   |
| innodb_status_output_locks | OFF   |
+----------------------------+-------+
2 rows in set (0.08 sec)

mysql> select version();
+------------+
| version()  |
+------------+
| 5.6.16-log |
+------------+
1 row in set (0.07 sec)

mysql> set global innodb_status_output=ON;
Query OK, 0 rows affected (0.04 sec)

mysql> set global innodb_status_output_locks=ON;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like 'innodb_status%';
+----------------------------+-------+
| Variable_name              | Value |
+----------------------------+-------+
| innodb_status_output       | ON    |
| innodb_status_output_locks | ON    |
+----------------------------+-------+
2 rows in set (0.00 sec)

Moreover, it suggests to use one of them instead of creating innodb_lock_monitor table:

mysql> create table innodb_lock_monitor(c1 int) engine=InnoDB\G
Query OK, 0 rows affected, 1 warning (0.74 sec)

mysql> show warnings\G
*************************** 1. row ***************************
  Level: Warning
   Code: 131
Message: Using the table name innodb_lock_monitor to enable diagnostic output is
 deprecated and may be removed in future releases. Use INFORMATION_SCHEMA or PER
FORMANCE_SCHEMA tables or SET GLOBAL innodb_status_output=ON.
1 row in set (0.00 sec)

But manual (neither https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html nor https://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html) does not describe them or their effects.

How to repeat:
Try to find out any information about innodb_status_output or innodb_status_output_locks server variables in the manual.

Suggested fix:
Add missing items to the manual. Make sure to have these documented and explained in details before deprecating innodb_lock_monitor.

Hello Valeriy,

Thank you for the report.
Confirmed on 5.6 latest builds that  innodb_status_output* server variables can be set dynamically. 

//

mysql> show variables like 'innodb_status%';
+----------------------------+-------+
| Variable_name              | Value |
+----------------------------+-------+
| innodb_status_output       | OFF   |
| innodb_status_output_locks | OFF   |
+----------------------------+-------+
2 rows in set (0.00 sec)

mysql> set global innodb_status_output=ON;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like 'innodb_status%';
+----------------------------+-------+
| Variable_name              | Value |
+----------------------------+-------+
| innodb_status_output       | ON    |
| innodb_status_output_locks | OFF   |
+----------------------------+-------+
2 rows in set (0.00 sec)

mysql> set global innodb_status_output_locks=ON;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like 'innodb_status%';
+----------------------------+-------+
| Variable_name              | Value |
+----------------------------+-------+
| innodb_status_output       | ON    |
| innodb_status_output_locks | ON    |
+----------------------------+-------+
2 rows in set (0.00 sec)

mysql> select version();
+-------------------------------------------+
| version()                                 |
+-------------------------------------------+
| 5.6.17-enterprise-commercial-advanced-log |
+-------------------------------------------+
1 row in set (0.00 sec)

Thanks,
Umesh

Posted by developer:
 
Documentation for innodb_status_output and innodb_status_output_locks has been added to the MySQL 5.6 Reference Manual. The content will appear soon, with the next published documentation build.

http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_status_output
http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_status_output_...

Thank you for the bug report.