How to determine queries per hour executed by a particular MySQL user?
1
vote
1
answer
3065
views
I am trying to implement user based quota system in MySQL to limit
MAX_QUERIES_PER_HOUR
for a particular user. I have an option to set this limit via MAX_UPDATES_PER_HOUR 10
.
But my problem is that I want know that how many queries a user has executed this hour. I followed this thread but this is for global statistics of dba. I want this information for every user of my database. I am sure that MySQL is storing this schema somewhere but after a lot of scrutinizing some of databases like information_schema
, performance_schema
, mysql
I can't figure out how it will be achieved.
Asked by salmanarshad1999
(11 rep)
Nov 23, 2018, 05:57 PM
Last activity: Aug 25, 2020, 09:14 AM
Last activity: Aug 25, 2020, 09:14 AM