error.global

The error.global domain includes global server error metrics from error summary tables.

Usage

For example:

mysql> SELECT * FROM performance_schema.events_errors_summary_global_by_error WHERE error_number = 3024\G
*************************** 1. row ***************************
     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 and ERROR_NAME are used to group the metric.

Derived Metrics

None.

Options

`all`

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

`total`

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.

`truncate-table`

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.

`truncate-timeout`


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.

`truncate-on-startup`

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.

Group Keys

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 Policies

Name	MySQL Error
`truncate-timeout`	Error truncating table

MySQL Config

See

29.12.20.11 Error Summary Tables

and related pages in the MySQL manual.

Changelog

Blip Version	Change
TBD	Domain added