Issue Accessing Innodb_dict_tables Metric – Permissions or Configuration?

Percona Monitoring and Management (PMM) Database Monitoring and Management
1

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!

2

I cannot find reference to this table in any of the mysql documentation nor Percona documentation. Can you please point to some info on what is ‘Innodb_dict_tables’? Is this a table you are expecting to find?