# Unable to find few mysql prometheus metrics

**URL:** <https://forums.percona.com/t/unable-to-find-few-mysql-prometheus-metrics/9640>\
**Category:** MySQL & MariaDB\
**Created:** [March 12, 2021, 6:08pm UTC](https://forums.percona.com/t/unable-to-find-few-mysql-prometheus-metrics/9640 "2021-03-12T18:08:47Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ramyashree](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ramyashree/32/2633_2.png) [@Ramyashree](https://forums.percona.com/u/Ramyashree)\
**Post date:** [March 12, 2021, 6:08pm UTC](https://forums.percona.com/t/unable-to-find-few-mysql-prometheus-metrics/9640/1 "2021-03-12T18:08:47Z")

</div>

These metrics doesn’t exist in our prometheus engine, how can we enable these to our prometheus.  
mysql\_global\_status\_innodb\_max\_trx\_id  
mysql\_global\_status\_innodb\_oldest\_view\_low\_limit\_trx\_id  
mysql\_global\_status\_innodb\_purge\_trx\_id  
mysql\_global\_status\_innodb\_purge\_undo\_no  
mysql\_global\_status\_innodb\_deadlocks

---

<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:** [March 13, 2021, 1:33pm UTC](https://forums.percona.com/t/unable-to-find-few-mysql-prometheus-metrics/9640/2 "2021-03-13T13:33:09Z")

</div>

Hi @Ramyashree

Provided metrics are fetched by global\_status collector.  
Have you got any mysql\_global\_status\_innodb\_ metrics?

 ![Screenshot_20210313_152042](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/f/f4e66cf2c55a2e6445fd1bef565d36614654615f.png)

Please check errors in pmm-agent logs if collector is enabled and other metrics are fetched.

Also deadlocks value is provided by mysql\_info\_schema\_innodb\_metrics\_lock\_lock\_deadlocks\_total metric from another collector.

---

<div class="post-metadata">

**Author:** ![Ramyashree](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ramyashree/32/2633_2.png) [@Ramyashree](https://forums.percona.com/u/Ramyashree)\
**Post date:** [March 14, 2021, 4:30am UTC](https://forums.percona.com/t/unable-to-find-few-mysql-prometheus-metrics/9640/3 "2021-03-14T04:30:56Z")

</div>

Thank you @Vadim_Yalovets  
yes we have mysql\_global\_status\_innodb\_ metrics

 ![Screenshot 2021-03-14 at 9.57.48 AM](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/4/49f3f62c20d47bcdf202a4782c939b05c78ee7e1.png)  
 ![Screenshot 2021-03-14 at 9.58.40 AM](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/3/33e4af2b5ef3b9a1b4ac4cd4bfb8822ecb527925.png)  
**But above mentioned transaction metrics doesn’t exist.**

---

<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:** [March 16, 2021, 6:05pm UTC](https://forums.percona.com/t/unable-to-find-few-mysql-prometheus-metrics/9640/4 "2021-03-16T18:05:20Z")

</div>

> [@Ramyashree](#):
>
> But above mentioned transaction metrics doesn’t exist.

Please check if such metrics are collected by exporter.  
e.g.  
`curl -s -u pmm:/agent_id/0b1cf56a-52b0-4d56-bd47-86b6df2b1f3d localhost:42002/metrics | egrep '_trx_id|_purge_undo_no|_innodb_deadlocks'`

 ![Screenshot_20210316_200405](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/a/a44a1e76517f5e4104f4d27edbf881e1a47605ce.png)

---

<div class="post-metadata">

**Author:** ![Ramyashree](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ramyashree/32/2633_2.png) [@Ramyashree](https://forums.percona.com/u/Ramyashree)\
**Post date:** [June 3, 2021, 3:28am UTC](https://forums.percona.com/t/unable-to-find-few-mysql-prometheus-metrics/9640/5 "2021-06-03T03:28:10Z")

</div>

Hi @Vadim_Yalovets  
Sorry for delayed reply few servers am able to see the response after curl, few servers am unable to see, Mysql version are 5.6 and above. please let’s us know.

---

<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:** [June 3, 2021, 8:45am UTC](https://forums.percona.com/t/unable-to-find-few-mysql-prometheus-metrics/9640/6 "2021-06-03T08:45:06Z")

</div>

Hi Ramyashree,

Please check pmm-agent logs. It could have some information regarding failed scraping.