USER_STATISTICS
This page is part of MariaDB's Documentation.
The parent of this page is: Information Schema for MariaDB Enterprise Server
Topics on this page:
Overview
User Statistics
USAGE
DETAILS
SYNONYMS
SCHEMA
CREATE TEMPORARY TABLE `USER_STATISTICS` (
`USER` varchar(128) NOT NULL,
`TOTAL_CONNECTIONS` int(11) NOT NULL,
`CONCURRENT_CONNECTIONS` int(11) NOT NULL,
`CONNECTED_TIME` int(11) NOT NULL,
`BUSY_TIME` double NOT NULL,
`CPU_TIME` double NOT NULL,
`BYTES_RECEIVED` bigint(21) NOT NULL,
`BYTES_SENT` bigint(21) NOT NULL,
`BINLOG_BYTES_WRITTEN` bigint(21) NOT NULL,
`ROWS_READ` bigint(21) NOT NULL,
`ROWS_SENT` bigint(21) NOT NULL,
`ROWS_DELETED` bigint(21) NOT NULL,
`ROWS_INSERTED` bigint(21) NOT NULL,
`ROWS_UPDATED` bigint(21) NOT NULL,
`SELECT_COMMANDS` bigint(21) NOT NULL,
`UPDATE_COMMANDS` bigint(21) NOT NULL,
`OTHER_COMMANDS` bigint(21) NOT NULL,
`COMMIT_TRANSACTIONS` bigint(21) NOT NULL,
`ROLLBACK_TRANSACTIONS` bigint(21) NOT NULL,
`DENIED_CONNECTIONS` bigint(21) NOT NULL,
`LOST_CONNECTIONS` bigint(21) NOT NULL,
`ACCESS_DENIED` bigint(21) NOT NULL,
`EMPTY_QUERIES` bigint(21) NOT NULL,
`TOTAL_SSL_CONNECTIONS` bigint(21) unsigned NOT NULL,
`MAX_STATEMENT_TIME_EXCEEDED` bigint(21) NOT NULL
)
PARAMETERS
SKYSQL
PRIVILEGES
EXAMPLES
ERROR HANDLING
FEATURE INTERACTION
RESPONSES
DIAGNOSIS
ISO 9075:2016
CHANGE HISTORY
Release Series | History |
---|---|
11.4 Enterprise |
|
10.6 Enterprise |
|
10.6 Community |
|
10.5 Enterprise |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|
Release Series | History |
---|---|
11.4 Enterprise |
|
10.6 Enterprise |
|
10.5 Enterprise |
|
10.4 Enterprise |
|
RELATED TOPICS
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.