MySQL Bugs: #84223: performance_schema.socket

Bug #84223	performance_schema.socket_instances
Submitted:	16 Dec 2016 3:03	Modified:	17 Dec 2016 3:40
Reporter:	Erwan MAS	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Performance Schema	Severity:	S3 (Non-critical)
Version:	5.6.35	OS:	Debian
Assigned to:		CPU Architecture:	Any

Description:
the table  performance_schema.socket_instance  is always empy .

select * from performance_schema.socket_instances ;

=> empty on 5.6.35-1debian8

but on 5.7.17-1debian8 , i have some data .

How to repeat:
install mysql-community-server ( 5.6.35-1debian8 ) , on jessie amd64 .

do the select .

Hello Erwan MAS,

Thank you for the report.
Could you please check if socket instruments are enabled in your environment? Please see the manual page for more details on this here http://dev.mysql.com/doc/refman/5.6/en/socket-instances-table.html

- Without socket instruments enabled

root@localhost [test]> select * from performance_schema.socket_instances ;
Empty set (0.00 sec)

- Post enabling

root@localhost [(none)]> select * from performance_schema.setup_instruments where name like '%socket%';
+----------------------------------------+---------+-------+
| NAME                                   | ENABLED | TIMED |
+----------------------------------------+---------+-------+
| wait/io/socket/sql/server_tcpip_socket | YES     | NO    |
| wait/io/socket/sql/server_unix_socket  | YES     | NO    |
| wait/io/socket/sql/client_connection   | YES     | NO    |
+----------------------------------------+---------+-------+
3 rows in set (0.00 sec)

root@localhost [(none)]> select * from performance_schema.socket_instances ;
+--------------------------------------+-----------------------+-----------+-----------+----+------+--------+
| EVENT_NAME                           | OBJECT_INSTANCE_BEGIN | THREAD_ID | SOCKET_ID | IP | PORT | STATE  |
+--------------------------------------+-----------------------+-----------+-----------+----+------+--------+
| wait/io/socket/sql/client_connection |              46775808 |        23 |        29 |    |    0 | ACTIVE |
+--------------------------------------+-----------------------+-----------+-----------+----+------+--------+
1 row in set (0.00 sec)

Thanks,
Umesh

thanks