# MySQL Table Statistics dashboard no results

**URL:** <https://forums.percona.com/t/mysql-table-statistics-dashboard-no-results/5217>\
**Category:** PMM 1.x\
**Created:** [November 17, 2016, 9:40pm UTC](https://forums.percona.com/t/mysql-table-statistics-dashboard-no-results/5217 "2016-11-17T21:40:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![johantan](https://avatars.discourse-cdn.com/v4/letter/j/a3d4f5/32.png) [@johantan](https://forums.percona.com/u/johantan)\
**Post date:** [November 17, 2016, 9:40pm UTC](https://forums.percona.com/t/mysql-table-statistics-dashboard-no-results/5217/1 "2016-11-17T21:40:27Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![weber](https://avatars.discourse-cdn.com/v4/letter/w/da6949/32.png) [@weber](https://forums.percona.com/u/weber)\
**Post date:** [November 18, 2016, 1:13am UTC](https://forums.percona.com/t/mysql-table-statistics-dashboard-no-results/5217/2 "2016-11-18T01:13:49Z")

</div>

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.