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 select SHOW GLOBAL STATUS LIKE 'Com_select'; #For update SHOW GLOBAL STATUS LIKE 'Com_update';
For INSERT and DELETE replace the query with 'Com_insert' ,'Com_delete' respectively.
More Related questions...