error.account
The error.account domain includes server error metrics grouped by account from error summary tables.
For example:
mysql> SELECT * FROM performance_schema.events_errors_summary_by_account_by_error WHERE error_number = 3024 AND USER IN ('user')\G
*************************** 1. row ***************************
USER: user
HOST: localhost
ERROR_NUMBER: 3024
ERROR_NAME: ER_QUERY_TIMEOUT
SQL_STATE: HY000
SUM_ERROR_RAISED: 1
SUM_ERROR_HANDLED: 0
FIRST_SEEN: 2025-04-30 16:30:16
LAST_SEEN: 2025-04-30 16:30:16
The SUM_ERR_RAISED value is used for the Blip raised metric. ERROR_NUMBER, ERROR_NAME, USER, and HOST are used to group the metric.
None.
| Value | Default | Description |
|---|---|---|
| yes | ✓ | Collect metrics on all errors (not recommended) |
| no | Collect only metrics for the errors listed in the plan | |
| exclude | Collect metrics only for errors that are not listed in the plan |
| Value | Default | Description |
|---|---|---|
| yes | ✓ | Return the total number of errors raised |
| no | Do not return the total number of errors raised | |
| only | Only return the total number of errors raised |
If all is not set to yes the total will only reflect those errors that are specifically included or not excluded from collection.
| Value Type | CSV string of accounts |
| Default |
A comma-separated list of ids to include. Overrides option exclude. The values for the filter should be formatted as user@hostname. Wildcards are allowed for either user or hostname, but not both. Invalid values will be ignored.
| Value Type | CSV string of accounts |
| Default |
A comma-separated list of ids to exclude. Ignored if include is set. The values for the filter should be formatted as user@hostname. Wildcards are allowed for either user or hostname, but not both. Invalid values will be ignored.
| Value | Default | Description |
|---|---|---|
| yes | Truncate table after each successful collection | |
| no | ✓ | Do not truncate table |
If the table is truncated (default), the metrics are delta counters. Else, the values are cumulative counters.
| Value Type | Duration string |
| Default | 250ms |
Sets @@session.lock_wait_timeout to avoid waiting too long when truncating the table.
Normally, truncating a table is nearly instantaneous, but metadata locks can block the operation.
| Value | Default | Description |
|---|---|---|
| yes | ✓ | Truncate source table on start of metric collection |
| no | Do not truncate source table on startup |
Truncates the source table when Blip starts. The timeout use will be the same as specified by truncate-timeout.
| Key | Value |
|---|---|
error_nunmber | The error number or an empty string for a total |
error_name | The short error name or an empty string for a total |
error_user | The user name for the error |
error_host | The host for the error |
None.
| Name | MySQL Error |
|---|---|
truncate-timeout | Error truncating table |
See
and related pages in the MySQL manual.
| Blip Version | Change |
|---|---|
| TBD | Domain added |