# Not Getting Data in Mysql "Table details"

**URL:** https://forums.percona.com/t/not-getting-data-in-mysql-table-details/24987
**Category:** MySQL & MariaDB
**Tags:** pmm, mysql
**Created:** [September 6, 2023, 11:44am UTC](https://forums.percona.com/t/not-getting-data-in-mysql-table-details/24987 "2023-09-06T11:44:23Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![Rajesh\_Gandhavarapu](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/rajesh_gandhavarapu/32/12526_2.png) [@Rajesh\_Gandhavarapu](https://forums.percona.com/u/Rajesh_Gandhavarapu)
#### Post date: [September 6, 2023, 11:44am UTC](https://forums.percona.com/t/not-getting-data-in-mysql-table-details/24987/1 "2023-09-06T11:44:23Z")

</div>

Hi,

I am facing difficulty retrieving data from the MySQL table labeled “Table Details.” I have attached screenshots illustrating the problem for your reference. Your assistance in resolving this matter would be highly appreciated.

 ![Screenshot (25)](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/1/1ed7a4789b31ff1f006ad9179f23286cd6d7685a.png)

 ![Screenshot 2023-09-06 164700](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/f/f70c2b3b74da0ada5c690087ebb27cb4c1063fc8.png)

---

<div class="post-metadata">

### Author: ![Vadim\_Yalovets](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadim_yalovets/32/43_2.png) [@Vadim\_Yalovets](https://forums.percona.com/u/Vadim_Yalovets)
#### Post date: [September 6, 2023, 12:23pm UTC](https://forums.percona.com/t/not-getting-data-in-mysql-table-details/24987/2 "2023-09-06T12:23:29Z")

</div>

Hi Rajesh,

Table statistics collection is disabled if there are more than 1000 tables.  
Could you try to increase this limit?

```auto
pmm-admin add mysql --disable-tablestats-limit=5000 ...

```

---

<div class="post-metadata">

### Author: ![Rajesh\_Gandhavarapu](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/rajesh_gandhavarapu/32/12526_2.png) [@Rajesh\_Gandhavarapu](https://forums.percona.com/u/Rajesh_Gandhavarapu)
#### Post date: [September 6, 2023, 12:38pm UTC](https://forums.percona.com/t/not-getting-data-in-mysql-table-details/24987/3 "2023-09-06T12:38:00Z")

</div>

Hi Vadim,

Thank you for your reply. where can I run this query in pmm server or client?  
To run it on the client. I got the below result.

> [root@Non-Prod ~]# pmm-admin add mysql --disable-tablestats-limit=5000  
> Service with name “Non-Prod-mysql” already exists.

---

<div class="post-metadata">

### Author: ![Vadim\_Yalovets](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadim_yalovets/32/43_2.png) [@Vadim\_Yalovets](https://forums.percona.com/u/Vadim_Yalovets)
#### Post date: [September 6, 2023, 1:06pm UTC](https://forums.percona.com/t/not-getting-data-in-mysql-table-details/24987/4 "2023-09-06T13:06:09Z")

</div>

Please remove this service from monitoring and then add it again with the additional flag.

```auto
pmm-admin remove mysql Non-Prod-mysql

```

---

<div class="post-metadata">

### Author: ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [September 7, 2023, 12:35am UTC](https://forums.percona.com/t/not-getting-data-in-mysql-table-details/24987/5 "2023-09-07T00:35:54Z")

</div>

@Rajesh_Gandhavarapu,  
Be aware that collecting stats/data on 5000 tables may cause performance issues. This is why we limit it to 1000 by default.

---

<div class="post-metadata">

### Author: ![Rajesh\_Gandhavarapu](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/rajesh_gandhavarapu/32/12526_2.png) [@Rajesh\_Gandhavarapu](https://forums.percona.com/u/Rajesh_Gandhavarapu)
#### Post date: [September 7, 2023, 7:30am UTC](https://forums.percona.com/t/not-getting-data-in-mysql-table-details/24987/6 "2023-09-07T07:30:48Z")

</div>

> [@Rajesh\_Gandhavarapu](#):
>
> –disable-tablestats-limit=5000

ok Thank you matthewb

---

<div class="post-metadata">

### Author: ![Rajesh\_Gandhavarapu](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/rajesh_gandhavarapu/32/12526_2.png) [@Rajesh\_Gandhavarapu](https://forums.percona.com/u/Rajesh_Gandhavarapu)
#### Post date: [September 7, 2023, 7:32am UTC](https://forums.percona.com/t/not-getting-data-in-mysql-table-details/24987/7 "2023-09-07T07:32:04Z")

</div>

Thank you Vadim this help me.