Bug #71291 Manual page for socket_instances table mentions information it does not provide
Submitted: 4 Jan 2014 17:32 Modified: 22 Jan 2014 13:15
Reporter: Valeriy Kravchuk Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.6 OS:Any
Assigned to: Paul DuBois CPU Architecture:Any
Tags: performance_schema, socket_instances

[4 Jan 2014 17:32] Valeriy Kravchuk 
Description:
Manual, http://dev.mysql.com/doc/refman/5.6/en/socket-instances-table.html, says:

"Information available in this table includes network activity such as socket instances, socket operations, and number of bytes transmitted and received."

But I do not see any columns in this table for "bytes transmitted and received"...

How to repeat:
mysql> select * from performance_schema.socket_instances\G
*************************** 1. row ***************************
           EVENT_NAME: wait/io/socket/sql/client_connection
OBJECT_INSTANCE_BEGIN: 345440448
            THREAD_ID: 26
            SOCKET_ID: 212
                   IP: ::1
                 PORT: 63952
                STATE: ACTIVE
1 row in set (0.00 sec)

I wonder where any number of bytes is tracked in the above?

Suggested fix:
Fix the manual to describe real content of the table.
[4 Jan 2014 19:11] MySQL Verification Team 
Valeriy, i already betted on this :)

(17:58:31) sbester|weekend: what's the bet valeriy will file a bug about "and number of bytes transmitted and received."  not being there...
(17:58:50) sbester|weekend: performance_schema.socket_instances has no such info but docs say it does!
[4 Jan 2014 19:27] Valeriy Kravchuk 
Probably I should bet that I'll be able to file a valid bug report (at least one) for every single manual page on PERFORMANCE_SCHEMA? Sometimes I think that only few people in the world actually tried to read these pages with some clear intentions (related to P_S use) in their minds...
[22 Jan 2014 13:15] 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.

The byte counts are available in the socket summary tables,
http://dev.mysql.com/doc/refman/5.6/en/socket-summary-tables.html

Fixed the socket_instance page to point that out.