MariaDB 5.2 introduced the User Statistics feature.
 
Syntax
------ 
SHOW CLIENT_STATISTICS
 
Description
----------- 
The SHOW CLIENT_STATISTICS statement was introduced in
MariaDB 5.2 as part of the User Statistics feature. It was
removed as a separate statement in MariaDB 10.1.1, but
effectively replaced by the generic SHOW
information_schema_table statement. The
information_schema.CLIENT_STATISTICS table holds statistics
about client connections.
 
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
 
From MariaDB 10.0:
 
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
 

 
 
 
 
 
 
 

URL: https://mariadb.com/kb/en/show-client-statistics/