Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created March 11, 2021 01:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mdcallag/f7b085a5f9fd8303166740da62d25acb to your computer and use it in GitHub Desktop.
Save mdcallag/f7b085a5f9fd8303166740da62d25acb to your computer and use it in GitHub Desktop.
mysql> select * from information_schema.user_statistics limit 1\G
*************************** 1. row ***************************
USER_NAME: root
BINLOG_BYTES_WRITTEN: 1412
BINLOG_DISK_READS: 0
BYTES_RECEIVED: 756
BYTES_SENT: 37322
COMMANDS_DDL: 2
COMMANDS_DELETE: 1
COMMANDS_HANDLER: 0
COMMANDS_INSERT: 0
COMMANDS_OTHER: 16
COMMANDS_SELECT: 4
COMMANDS_TRANSACTION: 0
COMMANDS_UPDATE: 0
CONNECTIONS_CONCURRENT: 1
CONNECTIONS_DENIED_MAX_GLOBAL: 0
CONNECTIONS_DENIED_MAX_USER: 0
CONNECTIONS_LOST: 0
CONNECTIONS_TOTAL: 8
DISK_READ_BYTES: 0
DISK_READ_REQUESTS: 0
DISK_READ_SVC_USECS: 0
DISK_READ_WAIT_USECS: 0
DISK_READ_BYTES_BLOB: 0
DISK_READ_REQUESTS_BLOB: 0
DISK_READ_SVC_USECS_BLOB: 0
DISK_READ_WAIT_USECS_BLOB: 0
DISK_READ_BYTES_PRIMARY: 0
DISK_READ_REQUESTS_PRIMARY: 0
DISK_READ_SVC_USECS_PRIMARY: 0
DISK_READ_WAIT_USECS_PRIMARY: 0
DISK_READ_BYTES_SECONDARY: 0
DISK_READ_REQUESTS_SECONDARY: 0
DISK_READ_SVC_USECS_SECONDARY: 0
DISK_READ_WAIT_USECS_SECONDARY: 0
ERRORS_ACCESS_DENIED: 0
ERRORS_NET_TOTAL: 0
ERRORS_NET_ER_NET_ERROR_ON_WRITE: 0
ERRORS_NET_ER_NET_PACKETS_OUT_OF_ORDER: 0
ERRORS_NET_ER_NET_PACKET_TOO_LARGE: 0
ERRORS_net_ER_NET_READ_ERROR: 0
ERRORS_net_ER_NET_READ_INTERRUPTED: 0
ERRORS_net_ER_NET_UNCOMPRESS_ERROR: 0
ERRORS_net_ER_NET_WRITE_INTERRUPTED: 0
ERRORS_TOTAL: 2
MICROSECONDS_WALL: 5933
MICROSECONDS_DDL: 0
MICROSECONDS_DELETE: 211
MICROSECONDS_HANDLER: 0
MICROSECONDS_INSERT: 0
MICROSECONDS_OTHER: 3145
MICROSECONDS_SELECT: 2012
MICROSECONDS_TRANSACTION: 0
MICROSECONDS_UPDATE: 0
MICROSECONDS_CPU: 4779
MICROSECONDS_CPU_USER: 0
MICROSECONDS_CPU_SYS: 0
QUERIES_EMPTY: 0
QUERY_COMMENT_BYTES: 0
RELAY_LOG_BYTES_WRITTEN: 0
ROWS_DELETED: 5
ROWS_FETCHED: 27
ROWS_INSERTED: 1
ROWS_READ: 14
ROWS_UPDATED: 1
ROWS_INDEX_FIRST: 1
ROWS_INDEX_NEXT: 0
TRANSACTIONS_COMMIT: 1
TRANSACTIONS_ROLLBACK: 0
CONNECTIONS_SSL_TOTAL: 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment