The users table tracks connection statistics aggregated by user name, including current active connections and total historical connections.
Each user that connects to the server is stored as a row in the users table, along with current and total connections.
The table size is determined at startup by the value of the performance_schema_users_size system variable. If this is set to 0, user statistics will be disabled.
This page is licensed: CC BY-SA / Gnu FDL
USER
The connection's client user name for the connection, or NULL if an internal thread.
CURRENT_CONNECTIONS
Current connections for the user.
TOTAL_CONNECTIONS
Total connections for the user.
SELECT * FROM performance_schema.users;
+------------------+---------------------+-------------------+
| USER | CURRENT_CONNECTIONS | TOTAL_CONNECTIONS |
+------------------+---------------------+-------------------+
| debian-sys-maint | 0 | 35 |
| NULL | 20 | 23 |
| root | 1 | 2 |
+------------------+---------------------+-------------------+