> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-status_by_account-table.md).

# Performance Schema status\_by\_account Table

{% hint style="info" %}
The `status_by_account` table is available from MariaDB 10.5.2.
{% endhint %}

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:

| Column          | Description                                     |
| --------------- | ----------------------------------------------- |
| 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                |

If [TRUNCATE TABLE](/docs/server/reference/sql-statements/table-statements/truncate-table.md) is run, will aggregate the status from terminated sessions to user and host status, then reset the account status.

If [FLUSH STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands.md) 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.

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}