MariaDB 5.2.0

The CLIENT_STATISTICS table was introduced in MariaDB 5.2.0 as part of the User Statistics feature.

The Information Schema CLIENT_STATISTICS table holds statistics about client connections. This is part of the User Statistics feature, which is not enabled by default.

It contains the following columns:

FieldTypeNotes
CLIENTvarchar(64)The IP address or hostname the connection originated from.
TOTAL_CONNECTIONSint(21)The number of connections created for this client.
CONCURRENT_CONNECTIONSint(21)The number of concurrent connections for this client.
CONNECTED_TIMEint(21)The cumulative number of seconds elapsed while there were connections from this client.
BUSY_TIMEdoubleThe cumulative number of seconds there was activity on connections from this client.
CPU_TIMEdoubleThe cumulative CPU time elapsed while servicing this client's connections. Note that this number may be wrong on SMP system if there was a CPU migration for the thread during the execution of the query.
BYTES_RECEIVEDint(21)The number of bytes received from this client's connections.
BYTES_SENTint(21)The number of bytes sent to this client's connections.
BINLOG_BYTES_WRITTENint(21)The number of bytes written to the binary log from this client's connections.
ROWS_READint(21)The number of rows read by this client's connections.
ROWS_SENTint(21)The number of rows sent by this client's connections.
ROWS_DELETEDint(21)The number of rows deleted by this client's connections.
ROWS_INSERTEDint(21)The number of rows inserted by this client's connections.
ROWS_UPDATEDint(21)The number of rows updated by this client's connections.
SELECT_COMMANDSint(21)The number of SELECT commands executed from this client's connections.
UPDATE_COMMANDSint(21)The number of UPDATE commands executed from this client's connections.
OTHER_COMMANDSint(21)The number of other commands executed from this client's connections.
COMMIT_TRANSACTIONSint(21)The number of COMMIT commands issued by this client's connections.
ROLLBACK_TRANSACTIONSint(21)The number of ROLLBACK commands issued by this client's connections.
DENIED_CONNECTIONSint(21)The number of connections denied to this client.
LOST_CONNECTIONSint(21)The number of this client's connections that were terminated uncleanly.
ACCESS_DENIEDint(21)The number of times this client's connections issued commands that were denied.
EMPTY_QUERIESint(21)The number of times this client's connections sent queries that returned no results to the server.
TOTAL_SSL_CONNECTIONSint(21)The number of TLS connections created for this client. (>= MariaDB 10.1.1)
MAX_STATEMENT_TIME_EXCEEDEDint(21)The number of times a statement was aborted, because it was executed longer than its MAX_STATEMENT_TIME threshold. (>= MariaDB 10.1.1)

Example

SELECT * FROM INFORMATION_SCHEMA.CLIENT_STATISTICS\G
*************************** 1. row ***************************
 CLIENT: localhost
 TOTAL_CONNECTIONS: 3
CONCURRENT_CONNECTIONS: 0
 CONNECTED_TIME: 4883
 BUSY_TIME: 0.009722
 CPU_TIME: 0.0102131
 BYTES_RECEIVED: 841
 BYTES_SENT: 13897
 BINLOG_BYTES_WRITTEN: 0
 ROWS_READ: 0
 ROWS_SENT: 214
 ROWS_DELETED: 0
 ROWS_INSERTED: 207
 ROWS_UPDATED: 0
 SELECT_COMMANDS: 10
 UPDATE_COMMANDS: 0
 OTHER_COMMANDS: 13
 COMMIT_TRANSACTIONS: 0
 ROLLBACK_TRANSACTIONS: 0
 DENIED_CONNECTIONS: 0
 LOST_CONNECTIONS: 0
 ACCESS_DENIED: 0
 EMPTY_QUERIES: 1

Comments

Comments loading...