metrics Sys Schema View
MariaDB starting with 10.6
The Sys Schema was introduced in MariaDB 10.6
Description
The metrics view contains global status variables (as found in the Performance Schema global_status Table), InnoDB metrics (as found in the Information Schema INNODB_METRICS Table, current and total memory allocation, based on the Performance Schema memory instrumentation, as well the current time in human readable and Unix timestamp formats.
It contains the following columns:
| Column | Description |
|---|---|
| Variable_name | The name of the metric. One of the VARIABLE_NAME column if a global_status table, the NAME column if an InnoDB metric, or a description for other metrics. |
| Variable_value | The metric value. One of the VARIABLE_VALUE column if a global status variable, the COUNT column for InnoDB metrics, the related column from the Performance Schema memory_summary_global_by_event_name table, the value of NOW(3) or UNIX_TIMESTAMP(NOW(3)). |
| Type | Metric type. One of Global Status, InnoDB Metrics - % (with % being the value of the SUBSYSTEM column in the INNODB_METRICS table, Performance Schema or System Time |
| Enabled | Whether the metric is enabled. Always YES for global status variables and the current time. For InnoDB metrics, YES only if the STATUS column of the INNODB_METRICS table, otherwise NO. For memory metrics: YES, NO or PARTIAL (for metrics where not all memory/% instruments are enabled). Performance Schema memory instruments are always enabled) |
Example
SELECT * FROM sys.metrics\G
*************************** 1. row ***************************
Variable_name: aborted_clients
Variable_value: 0
Type: Global Status
Enabled: YES
*************************** 2. row ***************************
Variable_name: aborted_connects
Variable_value: 0
Type: Global Status
Enabled: YES
...
*************************** 578. row ***************************
Variable_name: trx_undo_slots_used
Variable_value: 0
Type: InnoDB Metrics - transaction
Enabled: YES
*************************** 579. row ***************************
Variable_name: NOW()
Variable_value: 2024-09-09 16:16:08.745
Type: System Time
Enabled: YES
*************************** 580. row ***************************
Variable_name: UNIX_TIMESTAMP()
Variable_value: 1725891368.745
Type: System Time
Enabled: YES
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
