# How can I turn on the tablestats option?

**URL:** https://forums.percona.com/t/how-can-i-turn-on-the-tablestats-option/7166
**Category:** PMM 1.x
**Created:** [August 21, 2019, 3:29am UTC](https://forums.percona.com/t/how-can-i-turn-on-the-tablestats-option/7166 "2019-08-21T03:29:50Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![peng19832](https://avatars.discourse-cdn.com/v4/letter/p/7993a0/32.png) [@peng19832](https://forums.percona.com/u/peng19832)
#### Post date: [August 21, 2019, 3:29am UTC](https://forums.percona.com/t/how-can-i-turn-on-the-tablestats-option/7166/1 "2019-08-21T03:29:50Z")

</div>

When I was using pmm-admin to add a monitoring instance(mysql 5.7) to the server, I found that the tablestats option was turned off by default. Why?  
And I did not find the option to force open tablestats.  
How can I turn on the tablestats option?

pmm-admin OUTPUT:

* * *

SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS

* * *

…  
mysql:metrics tms\_mysql\_8041\_prod 42002 YES root:\*\*\*@unix(/usr/local/mysql/mysql.sock) [COLOR=#FF0000]tablestats=OFF

 ![photoid=54506](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/1/13f60a40fff6a2429ab3d9eb0c0e5136f95609af.png)

---

<div class="post-metadata">

### Author: ![peng19832](https://avatars.discourse-cdn.com/v4/letter/p/7993a0/32.png) [@peng19832](https://forums.percona.com/u/peng19832)
#### Post date: [August 25, 2019, 3:43am UTC](https://forums.percona.com/t/how-can-i-turn-on-the-tablestats-option/7166/2 "2019-08-25T03:43:41Z")

</div>

I am using pmm 1.17.1  
I did not find a conditional description for the tablestats option.  
What are the conditions for opening this tablestats option?  
I used the same command to add PMM instances, but some instances have turned off tablestats by default.

---

<div class="post-metadata">

### Author: ![peng19832](https://avatars.discourse-cdn.com/v4/letter/p/7993a0/32.png) [@peng19832](https://forums.percona.com/u/peng19832)
#### Post date: [August 25, 2019, 9:48pm UTC](https://forums.percona.com/t/how-can-i-turn-on-the-tablestats-option/7166/3 "2019-08-25T21:48:04Z")

</div>

THX.  
I found the answer in the old post below：  
[url][https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management/46785-how-to-enable-tablestats-off-to-on[/url]](https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management/46785-how-to-enable-tablestats-off-to-on%5B/url%5D)

---

<div class="post-metadata">

### Author: ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)
#### Post date: [August 27, 2019, 2:29am UTC](https://forums.percona.com/t/how-can-i-turn-on-the-tablestats-option/7166/4 "2019-08-27T02:29:16Z")

</div>

Thanks for updating us, peng19832, it could help others in the future too!