# To know number of avg transactions and avg inserts hourly/daily in mysql database

**URL:** <https://forums.percona.com/t/to-know-number-of-avg-transactions-and-avg-inserts-hourly-daily-in-mysql-database/26507>\
**Category:** Percona Server for MySQL 5.7\
**Tags:** percona\
**Created:** [November 13, 2023, 1:03pm UTC](https://forums.percona.com/t/to-know-number-of-avg-transactions-and-avg-inserts-hourly-daily-in-mysql-database/26507 "2023-11-13T13:03:36Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![virin\_t](https://avatars.discourse-cdn.com/v4/letter/v/b38774/32.png) [@virin\_t](https://forums.percona.com/u/virin_t)\
**Post date:** [November 13, 2023, 1:03pm UTC](https://forums.percona.com/t/to-know-number-of-avg-transactions-and-avg-inserts-hourly-daily-in-mysql-database/26507/1 "2023-11-13T13:03:36Z")

</div>

Hi

I would like to get avg number of inserts hourly and also avgg number of transactions running in database

We have performace\_schema enabled but need confirmation of other possible ways to get , may triggers or using timestamp columns in tables ( not all tables have them)

---

<div class="post-metadata">

**Author:** ![Mughees\_Ahmed](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mughees_ahmed/32/9028_2.png) [@Mughees\_Ahmed](https://forums.percona.com/u/Mughees_Ahmed)\
**Post date:** [November 14, 2023, 11:15am UTC](https://forums.percona.com/t/to-know-number-of-avg-transactions-and-avg-inserts-hourly-daily-in-mysql-database/26507/2 "2023-11-14T11:15:23Z")

</div>

Please configure Percona monitoring and management, that is the best tool out there to give you exact information.

---

<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:** [November 14, 2023, 1:33pm UTC](https://forums.percona.com/t/to-know-number-of-avg-transactions-and-avg-inserts-hourly-daily-in-mysql-database/26507/3 "2023-11-14T13:33:04Z")

</div>

[https://www.percona.com/software/pmm/quickstart](https://www.percona.com/software/pmm/quickstart)

---

<div class="post-metadata">

**Author:** ![virin\_t](https://avatars.discourse-cdn.com/v4/letter/v/b38774/32.png) [@virin\_t](https://forums.percona.com/u/virin_t)\
**Post date:** [November 14, 2023, 4:21pm UTC](https://forums.percona.com/t/to-know-number-of-avg-transactions-and-avg-inserts-hourly-daily-in-mysql-database/26507/4 "2023-11-14T16:21:23Z")

</div>

I do have pmm2 configured and running, other than QPS, is there a way to get more granular details like , updates in a day

---

<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:** [November 14, 2023, 11:10pm UTC](https://forums.percona.com/t/to-know-number-of-avg-transactions-and-avg-inserts-hourly-daily-in-mysql-database/26507/5 "2023-11-14T23:10:46Z")

</div>

Yes, you’d have to create a new graph for that and write the appropriate PromQL query to do that. Look at other graph formulas in PMM for examples. There are a couple in InnoDB Details that do 24hr summaries of different data points.