# PMM - Some Metrics (Checkpoints) are not shown with MySQL

**URL:** <https://forums.percona.com/t/pmm-some-metrics-checkpoints-are-not-shown-with-mysql/9097>\
**Category:** PMM 2.x\
**Created:** [February 4, 2021, 12:43pm UTC](https://forums.percona.com/t/pmm-some-metrics-checkpoints-are-not-shown-with-mysql/9097 "2021-02-04T12:43:49Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sbstnpl](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sbstnpl/32/2789_2.png) [@sbstnpl](https://forums.percona.com/u/sbstnpl)\
**Post date:** [February 4, 2021, 12:43pm UTC](https://forums.percona.com/t/pmm-some-metrics-checkpoints-are-not-shown-with-mysql/9097/1 "2021-02-04T12:43:49Z")

</div>

Hi Everyone!

we’ve had an Mysql Health audit with an Percona Cosultant and they recommended us to use PMM - so we do now. And we find it great so far!

Unfortunately we noticed, that some important metrics do not show up in PMM. For Example almost the entire “InnoDB Checkopoint & Flushing”-Metrics. Everything else for InnoDB works good so far.

 ![Bildschirmfoto 2021-02-04 um 13.39.36](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/4/40051934ad15a7ddad21b15d6b772fbf3cfffaf1.png)

I’ve installed PMM on Ubuntu and MySQL8 according to the following instructions:

> **[Install Percona Monitoring and Management](https://www.percona.com/software/pmm/quickstart)**
>
> Quickstart: Install Percona Monitoring and Management

Does anyone know this issue and knows how to solve it?  
or is there a Log file I could use for debugging this?

Thank you!  
Sebastian

---

<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:** [February 4, 2021, 1:35pm UTC](https://forums.percona.com/t/pmm-some-metrics-checkpoints-are-not-shown-with-mysql/9097/2 "2021-02-04T13:35:24Z")

</div>

Hello @sbstnpl, there are some metrics that PMM cannot see unless you enable `userstats=1` in your my.cnf file and restart MySQL. WARNING: Turning on userstats=1 can cause performance degradation because the stats generated by mysql need more CPU to compute compared to the basic stats provided by default.

---

<div class="post-metadata">

**Author:** ![sbstnpl](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sbstnpl/32/2789_2.png) [@sbstnpl](https://forums.percona.com/u/sbstnpl)\
**Post date:** [February 4, 2021, 1:50pm UTC](https://forums.percona.com/t/pmm-some-metrics-checkpoints-are-not-shown-with-mysql/9097/3 "2021-02-04T13:50:11Z")

</div>

Hi @matthewb !

thanks for your quick reply. 🙂  
Unfortunately I get this error message on mysql restart:  
[ERROR] [MY-000067] [Server] unknown variable ‘userstats=1’.

Should this option be available for MySQL 8 Community Server?

Thanks!

---

<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:** [February 4, 2021, 2:22pm UTC](https://forums.percona.com/t/pmm-some-metrics-checkpoints-are-not-shown-with-mysql/9097/4 "2021-02-04T14:22:32Z")

</div>

@sbstnpl Unfortunately, I believe userstats=1 is only available in Percona Server. Since you are using community, these graphs will always be empty. I suggest you look into replacing Community with Percona Server. It is a drop-in replacement.