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

MySQL & MariaDB Percona Server for MySQL 5.7
1

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)

2

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

3

https://www.percona.com/software/pmm/quickstart

4

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

5

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.