The status_by_account table aggregates session status variables by client account, showing cumulative counters for specific user-host combinations.
The status_by_account table contains status variable information by user/host account. The table does not collect statistics for Com_xxx variables.
The table contains the following columns:
If is run, will aggregate the status from terminated sessions to user and host status, then reset the account status.
If 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.
This page is licensed: CC BY-SA / Gnu FDL
USER
User for which the status variable is reported.
HOST
Host for which the status variable is reported.
VARIABLE_NAME
Status variable name.
VARIABLE_VALUE
Aggregated status variable value