Bug #44556 Status variable named wrong in documentation
Submitted: 29 Apr 2009 18:44 Modified: 30 Apr 2009 16:11
Reporter: Sheeri Cabral (Candidate Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S2 (Serious)
Version:5.1 OS:Any
Assigned to: Paul DuBois CPU Architecture:Any
Tags: aborted_connections, aborted_connects, qc, show status

[29 Apr 2009 18:44] Sheeri Cabral
Description:
http://dev.mysql.com/doc/refman/5.1/en/error-lost-connection.html states:

"You can determine whether you are experiencing this more uncommon cause by using SHOW STATUS LIKE 'aborted_connections'."

However, that is not a valid status variable.

How to repeat:
mysql> SHOW STATUS LIKE 'aborted_connections';
Empty set (0.00 sec)

Suggested fix:
Change to SHOW GLOBAL STATUS LIKE 'aborted_connects'

mysql> SHOW GLOBAL STATUS LIKE 'aborted_connects';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| Aborted_connects | 2     | 
+------------------+-------+
1 row in set (0.00 sec)

(It's important to get users in the habit of using the GLOBAL/SESSION keywords with SHOW STATUS)
[29 Apr 2009 18:46] Valeriy Kravchuk
Thank you for the bug report.
[30 Apr 2009 16:11] 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, and will be included in the next release of the relevant products.