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

[11 Jul 2013 17:15] Todd Farmer 
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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.