Sys Scheme metrics View
You are viewing an old version of this article. View
the current version here.
MariaDB starting with 10.6
The Sys Schema view 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 information-schema-innodb_metrics-table/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 | |
| Enabled |
Example
Comments
Comments loading...
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.
