Syntax\n------\n\nSHOW USER_STATISTICS\n\nDescription\n-----------\n\nThe SHOW USER_STATISTICS statement is part of the User Statistics feature. It was effectively replaced by the generic SHOW information_schema_table statement. The information_schema.USER_STATISTICS table holds statistics about user activity. You can use this table to find out such things as which user is causing the most load and which users are being abusive. You can also use this table to measure how close to capacity the server may be.\n\nThe SHOW USER_STATISTICS statement is part of the User Statistics feature. The information_schema.USER_STATISTICS table holds statistics about user activity. You can use this table to find out such things as which user is causing the most load and which users are being abusive. You can also use this table to measure how close to capacity the server may be.\n\nThe userstat system variable must be set to 1 to activate this feature. See the User Statistics and information_schema.USER_STATISTICS table for more information.\n\nExamples\n--------\n\nSHOW USER_STATISTICS\\G\n************************ 1. row ************************\n                  User: root\n     Total_connections: 1\nConcurrent_connections: 0\n        Connected_time: 3297\n             Busy_time: 0.14113400000000006\n              Cpu_time: 0.017637000000000003\n        Bytes_received: 969\n            Bytes_sent: 22355\n  Binlog_bytes_written: 0\n             Rows_read: 10\n             Rows_sent: 67\n          Rows_deleted: 0\n         Rows_inserted: 0\n          Rows_updated: 0\n       Select_commands: 7\n       Update_commands: 0\n        Other_commands: 0\n   Commit_transactions: 1\n Rollback_transactions: 0\n    Denied_connections: 0\n      Lost_connections: 0\n         Access_denied: 0\n         Empty_queries: 7\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-user-statistics