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

Percona Monitoring and Management (PMM)
1

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
image1915×923 62.8 KB

image
image1918×920 91.9 KB

2

Team, Can somebody help me on this issue?

1 Like
3

@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.

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

image
image1209×116 13.3 KB

1 Like
4

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 ?

1 Like
5

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 ...

2 Likes
6

Hi Puneet

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

2 Likes