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
Last activity: May 25, 2025, 04:02 PM