Hi all,
We’re trying to monitor our Percona-XtraDB-Cluster using the LogicMonitor monitoring tool. While we are successfully receiving basic MySQL metrics, we’re having trouble accessing the Innodb_dict_tables metric.
LogicMonitor is returning a NaN (Not a Number) value for this metric and reports the following:
Innodb_dict_tables
NaN
NAN after processing with regex
(postProcessParam: Innodb_dict_tables,(?:variable_)*value=(\d+), reference=, useValue=output)
I understand this may relate to how the data is exposed by the Percona server rather than LogicMonitor itself. So my questions are:
-
Is access to Innodb_dict_tables restricted in any way?
-
Could this be related to a server variable or plugin/extension that must be enabled?
Has anyone encountered something similar when querying this data manually?
Thanks in advance for any guidance!