Hibernate / SQL
How do I find number of queries issued per hour in MySQL?
Using the show global status command we can determine the number of selects, updates since the last database restart. To find per day run the command now and after 24 hours and subtract the last count with the latest.
For INSERT and DELETE replace the query with 'Com_insert' ,'Com_delete' respectively.
More Related questions...