# How is PMM2 gathering information on table size?

**URL:** <https://forums.percona.com/t/how-is-pmm2-gathering-information-on-table-size/7989>\
**Category:** PMM 2.x\
**Tags:** pmm\
**Created:** [September 1, 2020, 3:29pm UTC](https://forums.percona.com/t/how-is-pmm2-gathering-information-on-table-size/7989 "2020-09-01T15:29:34Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jeff\_K](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jeff_k/32/1327_2.png) [@Jeff\_K](https://forums.percona.com/u/Jeff_K)\
**Post date:** [September 1, 2020, 3:29pm UTC](https://forums.percona.com/t/how-is-pmm2-gathering-information-on-table-size/7989/1 "2020-09-01T15:29:34Z")

</div>

Apologies if my terminology is a bit incorrect, I’m not coming from a DBA background. I’m curious how PMM2 is getting metrics on Table size (I’m specifically looking at the “MySQL Table Details” default dashboard), since we were looking at creating reports and alerts on the data.

The reasoning for the question: Currently we are getting this data by running an “analyze table” which is apparently so slow and taxing on the db servers that we have to wait until off hours on a weekend to do it (so only 1 datapoint per week). So, if PMM is able to accomplish this more efficiently, or more frequently, it might be desirable to switch to that method and use the built-in Grafana/Prometheus to do the reporting/alerting.

---

<div class="post-metadata">

**Author:** ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)\
**Post date:** [September 1, 2020, 4:04pm UTC](https://forums.percona.com/t/how-is-pmm2-gathering-information-on-table-size/7989/2 "2020-09-01T16:04:06Z")

</div>

What MySQL version are you running and how many tables do you have ?

PMM Queries data from Information Schema which is not as slow but may not be super fast either depending on MySQL version and configuration

---

<div class="post-metadata">

**Author:** ![Jeff\_K](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jeff_k/32/1327_2.png) [@Jeff\_K](https://forums.percona.com/u/Jeff_K)\
**Post date:** [September 2, 2020, 11:18am UTC](https://forums.percona.com/t/how-is-pmm2-gathering-information-on-table-size/7989/3 "2020-09-02T11:18:34Z")

</div>

We are running v5.7.28 and have about 2400 tables on a db give or take.

---

<div class="post-metadata">

**Author:** ![Jeff\_K](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jeff_k/32/1327_2.png) [@Jeff\_K](https://forums.percona.com/u/Jeff_K)\
**Post date:** [October 2, 2020, 3:28pm UTC](https://forums.percona.com/t/how-is-pmm2-gathering-information-on-table-size/7989/4 "2020-10-02T15:28:40Z")

</div>

Hey, catching back up on this one, I kind of forgot about it. The DBA was curious if it was information\_schema.tables or information\_schema.INNODB\_SYS\_TABLESPACES?

---

<div class="post-metadata">

**Author:** ![Jeff\_K](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jeff_k/32/1327_2.png) [@Jeff\_K](https://forums.percona.com/u/Jeff_K)\
**Post date:** [October 20, 2020, 10:05am UTC](https://forums.percona.com/t/how-is-pmm2-gathering-information-on-table-size/7989/5 "2020-10-20T10:05:03Z")

</div>

@Peter I realize this is a bit old, any chance you could answer my last question?

---

<div class="post-metadata">

**Author:** ![nurlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nurlan/32/1523_2.png) [@nurlan](https://forums.percona.com/u/nurlan)\
**Post date:** [October 20, 2020, 12:58pm UTC](https://forums.percona.com/t/how-is-pmm2-gathering-information-on-table-size/7989/6 "2020-10-20T12:58:57Z")

</div>

@Jeff_K we get data from information\_schema.tables.