SHOW CLIENT_STATISTICS

View statistics on client connections. This statement displays metrics like bytes sent/received and busy time for connected clients.

Syntax

SHOW CLIENT_STATISTICS

Description

Current

The SHOW CLIENT_STATISTICS statement has effectively been replaced by the generic SHOW TABLE STATISTICS statement. The information_schema.CLIENT_STATISTICS table holds statistics about client connections.

< 10.1.1

The userstat system variable must be set to 1 to activate this feature. See the User Statistics and information_schema.CLIENT_STATISTICS articles for more information.

Example

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

_{This page is licensed: CC BY-SA / Gnu FDL}