# MariaDB: Unable to see the MySQL Table details Graphs in the PMM2 \[version 2.23.0\]

**URL:** https://forums.percona.com/t/mariadb-unable-to-see-the-mysql-table-details-graphs-in-the-pmm2-version-2-23-0/12893
**Category:** Percona Monitoring and Management (PMM)
**Created:** [November 8, 2021, 11:31am UTC](https://forums.percona.com/t/mariadb-unable-to-see-the-mysql-table-details-graphs-in-the-pmm2-version-2-23-0/12893 "2021-11-08T11:31:53Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Naresh9999](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/naresh9999/32/5568_2.png) [@Naresh9999](https://forums.percona.com/u/Naresh9999)
#### Post date: [November 8, 2021, 11:31am UTC](https://forums.percona.com/t/mariadb-unable-to-see-the-mysql-table-details-graphs-in-the-pmm2-version-2-23-0/12893/1 "2021-11-08T11:31:53Z")

</div>

Hi Team,

I am unable to see only the Table Details graphs and even I don’t see the servers in the servers list in the Table Details Graphs. But I can see the server list in the other graphs Mysql user details or Replication details grpahs.

Please help on this issue and help me if I missed anything to configure it.

GRANT SELECT, RELOAD, PROCESS, SHOW DATABASES, SUPER, REPLICATION SLAVE, REPLICATION CLIENT ON _._ TO `pmm_user`@`%`;

DB version: MariaDB 10.4.19

I can see the server in the servers list for other graphs like Mysql innodb compression details attached the screenshots.

 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/d/de090c2895616fa9b85e160279079ecc3c85223a.png)  
 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/d/da73dbbe68cdd3cf15e0640ff130e2a404586f14.png)

---

<div class="post-metadata">

### Author: ![Naresh9999](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/naresh9999/32/5568_2.png) [@Naresh9999](https://forums.percona.com/u/Naresh9999)
#### Post date: [November 9, 2021, 12:55pm UTC](https://forums.percona.com/t/mariadb-unable-to-see-the-mysql-table-details-graphs-in-the-pmm2-version-2-23-0/12893/2 "2021-11-09T12:55:13Z")

</div>

Team, Can somebody help me on this issue?

---

<div class="post-metadata">

### Author: ![Puneet](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/puneet/32/1331_2.png) [@Puneet](https://forums.percona.com/u/Puneet)
#### Post date: [November 9, 2021, 7:13pm UTC](https://forums.percona.com/t/mariadb-unable-to-see-the-mysql-table-details-graphs-in-the-pmm2-version-2-23-0/12893/3 "2021-11-09T19:13:43Z")

</div>

@Naresh9999 could you please check the number of tables, `select count(*) from information_schema.tables;` could you confirm if it is not disabled for your setup(if table count \> 1000). Read about this option on our official documentation.

> **[MySQL - Percona Monitoring and Management](https://docs.percona.com/percona-monitoring-and-management/setting-up/client/mysql.html)**
>
> Documentation

you can check it is set `tablestats_group_disabled: true` for the instance you added for monitoring.

 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/b/bda5edf0bc1f30cae34b24e86dc9eb5a5deff911.png)

---

<div class="post-metadata">

### Author: ![Naresh9999](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/naresh9999/32/5568_2.png) [@Naresh9999](https://forums.percona.com/u/Naresh9999)
#### Post date: [November 10, 2021, 7:09am UTC](https://forums.percona.com/t/mariadb-unable-to-see-the-mysql-table-details-graphs-in-the-pmm2-version-2-23-0/12893/4 "2021-11-10T07:09:50Z")

</div>

Hi Puneet,

Below is the output.

MariaDB [(none)]\> select count(_) from information\_schema.tables;  
±---------+  
| count(_) |  
±---------+  
| 3275 |  
±---------+  
1 row in set (0.022 sec)

MariaDB [(none)]\>

So, if I want Table details graphs, what I have to do? can you please help ?

---

<div class="post-metadata">

### Author: ![Puneet](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/puneet/32/1331_2.png) [@Puneet](https://forums.percona.com/u/Puneet)
#### Post date: [November 10, 2021, 8:05am UTC](https://forums.percona.com/t/mariadb-unable-to-see-the-mysql-table-details-graphs-in-the-pmm2-version-2-23-0/12893/5 "2021-11-10T08:05:28Z")

</div>

Naresh,

I think you should re-add instance (remove and add again with same name) but when you add this time, try using the parameter, `--disable-tablestats-limit` while adding this instance for monitoring, here you can set the value to higher, the current default is 1000. ex. `pmm-admin add mysql --disable-tablestats-limit=4000 ...`

---

<div class="post-metadata">

### Author: ![Naresh9999](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/naresh9999/32/5568_2.png) [@Naresh9999](https://forums.percona.com/u/Naresh9999)
#### Post date: [November 10, 2021, 8:43am UTC](https://forums.percona.com/t/mariadb-unable-to-see-the-mysql-table-details-graphs-in-the-pmm2-version-2-23-0/12893/6 "2021-11-10T08:43:54Z")

</div>

Hi Puneet

Thank you so much for the quick help. Its working fine and I am able to see the graphs.
