MySQL Table Statistics dashboard no results

Percona Monitoring and Management (PMM) PMM 1.x
1

I can’t get the “MySQL Table Statistics” dashboard to display anything. Here is what I updated:

set global userstat=1;
set global innodb_stats_on_metadata = ON;
set global innodb_monitor_enable=all;

Anything else I should do to have the reporting live? Thanks

2

Does pmm-admin list show tablestats=OFF in Options column for that instance?

If yes, then it was automatically disabled because you have a significant number of tables and it won’t work.
By default, tablestats are disabled with 1000+ tables. You can, of course, force to enable them, but it may prevent the monitoring to work properly for all the stats due to timeouts of fetching metrics for all of those tables.