Innodb_dict_tables metric - how to access it?

[Jiri Cieslar]

Hi everyone,

I'm currently working on monitoring our Percona XtraDB Cluster using LogicMonitor. Most of the basic MySQL metrics are being collected without any issues. However, I'm having trouble with the Innodb_dict_tables metric — LogicMonitor shows a NaN (Not a Number) value for it.

The tool gives this information:

Innodb_dict_tables: NaN

and the regex processing shows:

(postProcessParam: Innodb_dict_tables,(?:variable_)*value=(\d+), reference=, useValue=output)

I suspect this could be related to how the data is exposed by the Percona server, not necessarily an issue on the LogicMonitor side.

Does anyone know if access to Innodb_dict_tables is restricted somehow, or if it requires a specific server variable, plugin, or configuration to be enabled? I would really appreciate any insights or experience you can share.

Thank you so much in advance!