Performance Schema status_by_user Table
status_by_account table contains status variable information by user. The table does not collect statistics for
The table contains the following columns:
|USER||User for which the status variable is reported.|
|VARIABLE_NAME||Status variable name.|
|VARIABLE_VALUE||Aggregated status variable value|
If TRUNCATE TABLE is run, will reset the aggregated user status from terminated sessions.
If FLUSH STATUS is run, session status from all active sessions are added to the global status variables, the status of all active sessions are reset, and values aggregated from disconnected sessions are reset.