Bug #75365 Com_show_slave_status_nonblocking is not described in the manual
Submitted: 31 Dec 2014 11:54 Modified: 22 Jan 2015 14:28
Reporter: Valeriy Kravchuk Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.7.5 OS:Any
Assigned to: Paul DuBois CPU Architecture:Any
Tags: Com_show_slave_status_nonblocking, missing manual

[31 Dec 2014 11:54] Valeriy Kravchuk 
Description:
Yet another status variable is NOT documented, even though 5.7.5 is released long time ago:

mysql> show status like '%nonblock%';
+-----------------------------------+-------+
| Variable_name                     | Value |
+-----------------------------------+-------+
| Com_show_slave_status_nonblocking | 0     |
+-----------------------------------+-------+
1 row in set (0,01 sec)

mysql> show variables like '%version%';
+-------------------------+------------------------------+
| Variable_name           | Value                        |
+-------------------------+------------------------------+
| innodb_version          | 5.7.5                        |
| protocol_version        | 10                           |
| slave_type_conversions  |                              |
| version                 | 5.7.5-m15                    |
| version_comment         | MySQL Community Server (GPL) |
| version_compile_machine | x86_64                       |
| version_compile_os      | Linux                        |
+-------------------------+------------------------------+
7 rows in set (0,00 sec)

How to repeat:
Try to find Com_show_slave_status_nonblocking at http://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html ...

Suggested fix:
Please, document all new status variables in MySQL 5.7.x
[31 Dec 2014 12:42] MySQL Verification Team 
Hello Valeriy,

Thank you for the report.

Thanks,
Umesh
[31 Dec 2014 12:45] MySQL Verification Team 
// 5.7.5

mysql> show variables like '%version%';
+-------------------------+------------------------------+
| Variable_name           | Value                        |
+-------------------------+------------------------------+
| innodb_version          | 5.7.5                        |
| protocol_version        | 10                           |
| slave_type_conversions  |                              |
| version                 | 5.7.5-m15                    |
| version_comment         | MySQL Community Server (GPL) |
| version_compile_machine | x86_64                       |
| version_compile_os      | linux-glibc2.5               |
+-------------------------+------------------------------+
7 rows in set (0.00 sec)

mysql> show status like '%nonblock%';
+-----------------------------------+-------+
| Variable_name                     | Value |
+-----------------------------------+-------+
| Com_show_slave_status_nonblocking | 0     |
+-----------------------------------+-------+
1 row in set (0.00 sec)

// Build details

md5sum mysql-5.7.5-m15-linux-glibc2.5-x86_64.tar.gz
b4c61a681b8a2d85527e7e2d2a595c84  mysql-5.7.5-m15-linux-glibc2.5-x86_64.tar.gz
[21 Jan 2015 15:27] Paul DuBois 
This was added in 5.7.0 and removed in 5.7.6.
[21 Jan 2015 15:58] Paul DuBois 
The status variable corresponds to SHOW SLAVE STATUS NONBLOCKING statements
(http://dev.mysql.com/doc/refman/5.7/en/show-slave-status.html)

The NONBLOCKING option was removed in 5.7.6; will update that page.
The status variable was removed along with it.
[22 Jan 2015 14:28] Paul DuBois 
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly.