Syntax
------

SHOW CLIENT_STATISTICS

Description
-----------

The SHOW CLIENT_STATISTICS statement is 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
-------

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/