Not the answer you need?
Register and ask your own question!

MySQL Table Statistics dashboard no results

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

Comments

  • weberweber Advisor Inactive User Role Beginner
    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.
This discussion has been closed.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.