View statistics on client connections. This statement displays metrics like bytes sent/received and busy time for connected clients.
SHOW CLIENT_STATISTICSThe SHOW CLIENT_STATISTICS statement has effectively been replaced by the generic statement. The table holds statistics about client connections.
The SHOW CLIENT_STATISTICS statement is part of the feature. The table holds statistics about client connections.
The system variable must be set to 1 to activate this feature. See the and articles for more information.
This page is licensed: CC BY-SA / Gnu FDL
SHOW CLIENT_STATISTICS\G
*************************** 1. row ***************************
Client: localhost
Total_connections: 35
Concurrent_connections: 0
Connected_time: 708
Busy_time: 2.5557979999999985
Cpu_time: 0.04123740000000002
Bytes_received: 3883
Bytes_sent: 21595
Binlog_bytes_written: 0
Rows_read: 18
Rows_sent: 115
Rows_deleted: 0
Rows_inserted: 0
Rows_updated: 0
Select_commands: 70
Update_commands: 0
Other_commands: 0
Commit_transactions: 1
Rollback_transactions: 0
Denied_connections: 0
Lost_connections: 0
Access_denied: 0
Empty_queries: 35