# How to monitor the thread commit times

**URL:** <https://forums.percona.com/t/how-to-monitor-the-thread-commit-times/29530>\
**Category:** PMM 2.x\
**Tags:** pmm, percona\
**Created:** [April 3, 2024, 1:13pm UTC](https://forums.percona.com/t/how-to-monitor-the-thread-commit-times/29530 "2024-04-03T13:13:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sven](https://avatars.discourse-cdn.com/v4/letter/s/e47c2d/32.png) [@sven](https://forums.percona.com/u/sven)\
**Post date:** [April 3, 2024, 1:13pm UTC](https://forums.percona.com/t/how-to-monitor-the-thread-commit-times/29530/1 "2024-04-03T13:13:13Z")

</div>

Hi all,

Excuse my ignorance but is there an easy way to monitor the thread commit times as this is critical for our app ? For example when a thread is in COMMIT state for more than X seconds. We are running Percona XtraDB Cluster 5.6.51-91.0-56-log.

Can I use _mysql\_info\_schema\_write\_query\_response\_time\_seconds\_bucket_ for that purpose given that the query response time plugin is enabled ?

Having said that, are you aware of what’s the impact of the _query response time plugin_ on the cluster ? I have 5 nodes cluster with two active nodes and the plugin works just fine on non-prod but I’m a bit hesitant to enable it on prod.

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![Agustin\_G](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/agustin_g/32/14111_2.png) [@Agustin\_G](https://forums.percona.com/u/Agustin_G)\
**Post date:** [April 4, 2024, 10:19pm UTC](https://forums.percona.com/t/how-to-monitor-the-thread-commit-times/29530/2 "2024-04-04T22:19:52Z")

</div>

Hi Sven,

You can get commit-related information in QAN:

 ![qan-commit](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/3/3b834388144a1ab52811599e4cc1dfb192ba8c21.jpeg)

> We are running Percona XtraDB Cluster 5.6.51-91.0-56-log.

Note that 5.6 and 5.7 have already reached EOL (end of life), and the query response time plugin has not been ported to 8.0. PMM does offer a dashboard to view data gathered with this plugin, though:  
MySQL Query Response Time Details.

> Having said that, are you aware of what’s the impact of the _query response time plugin_ on the cluster ? I have 5 nodes cluster with two active nodes and the plugin works just fine on non-prod but I’m a bit hesitant to enable it on prod.

I suggest you to test this in a similar environment, because it will depend on your workload and hardware specs. Having said this, you should have COMMIT information already, so I would first check if that is enough.

---

<div class="post-metadata">

**Author:** ![sven](https://avatars.discourse-cdn.com/v4/letter/s/e47c2d/32.png) [@sven](https://forums.percona.com/u/sven)\
**Post date:** [April 18, 2024, 1:04pm UTC](https://forums.percona.com/t/how-to-monitor-the-thread-commit-times/29530/3 "2024-04-18T13:04:49Z")

</div>

Hi Augustin,

Thanks for your reply.

I can’t find an easier way to do that and decided to use the active threads instead. So that when there is an issue or flow control the number of active threads will start rising (we have a predictable number if active connections) will raise an alert. Thanks for your time.

Regards