I'm trying to debug why I don't have INFORMATION_SCHEMA.INNODB_METRICS
. I'm uncertain because I see it in the MySQL 5.5 reference glossary: https://dev.mysql.com/doc/search/?d=10&p=1&q=innodb_metrics.
mysql --version
mysql Ver 15.1 Distrib 5.5.56-MariaDB, for Linux (x86_64) using readline 5.1
When I try to configure it through my.cnf I get:
mysqld: unknown variable "innodb_monitor_enable"
When I try to configure it through the MySQL CLI I get:
MariaDB [(none)]> SET GLOBAL innodb_monitor_enable = trx_rw_commits;
ERROR 1193 (HY000): Unknown system variable 'innodb_monitor_enable'
MariaDB [(none)]> SET GLOBAL innodb_monitor_enable = trx_nl_ro_commits;
ERROR 1193 (HY000): Unknown system variable 'innodb_monitor_enable'
MariaDB [(none)]> SET GLOBAL innodb_monitor_enable = trx_ro_commits;
ERROR 1193 (HY000): Unknown system variable 'innodb_monitor_enable'
MariaDB [(none)]> SET GLOBAL innodb_monitor_enable = trx_rollbacks;
ERROR 1193 (HY000): Unknown system variable 'innodb_monitor_enable'
My guess is that it was introduced in 5.6 because https://dev.mysql.com/doc/refman/5.5/en/innodb-information-schema-metrics-table.html redirects to 8.0 and 5.6 works.
Additional info
Turns out that, as shown below
SELECT VERSION()
-> ;
+----------------+
| VERSION() |
+----------------+
| 5.5.56-MariaDB |
+----------------+
...I was looking in the wrong place. I actually am using MariaDB as the database management system, and @danblack pointed out it was released in 10.