MySQL Bugs: #69725: P_S.socket_instances doesn't include named pipe or shared memory connections

Bug #69725	P_S.socket_instances doesn't include named pipe or shared memory connections
Submitted:	11 Jul 2013 17:15
Reporter:	Todd Farmer (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Performance Schema	Severity:	S4 (Feature request)
Version:	5.6.11	OS:	Windows
Assigned to:	Marc ALFF	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
The PERFORMANCE_SCHEMA.SOCKET_INSTANCES table contains information about connections made via TCP or Unix sockets, but not named pipes or shared memory on Microsoft Windows:

http://dev.mysql.com/doc/refman/5.6/en/socket-instances-table.html

That's unfortunate, as it is currently the best mechanism to identify the mechanism used for a given connection.

How to repeat:
1.  Enable wait/io/socket/sql/% instruments.
2.  Connect using named pipe or shared memory on Windows.
3.  Note that nothing shows in P_S.SOCKET_INSTANCES table for such connections.

Suggested fix:
Add instrumentation for named pipe and shared memory connections to SETUP_INSTRUMENTS table.