MariaDB 5.2 introduced the User Statistics feature.
SHOW CLIENT_STATISTICS
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.
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
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/show-client_statistics/