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


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)

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

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

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.