Sample Header Ad - 728x90

Mysql Connections are string when checking from SHOW STATUS LIKE '%onn%';

0 votes
1 answer
236 views
I have a Mysql db server which seems to be getting slow by time. When i am checking detail from SHOW STATUS LIKE '%onn%'; I get following details Variable_name Value --------------------------------------------- -------- Aborted_connects 2 Connection_errors_accept 0 Connection_errors_internal 0 Connection_errors_max_connections 0 Connection_errors_peer_address 0 Connection_errors_select 0 Connection_errors_tcpwrap 0 Connections 2327 Max_used_connections 7 Performance_schema_session_connect_attrs_lost 0 Ssl_client_connects 0 Ssl_connect_renegotiates 0 Ssl_finished_connects 0 Threads_connected 5 Is there anyway i can get the connections detail of the open connections? Like source ip, username e.t.c. Mysql version is 5.6
Asked by Kamran Shahid (111 rep)
Apr 30, 2019, 10:05 AM
Last activity: May 25, 2025, 04:02 PM