Help the world stop coronavirus! Stay home!

Prev Next

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.

❤Cash Back At Stores you Love !!!❤

Earn your $10 reward when you make your first purchase through Ebates by signing up with clicking below button.

Ebates Coupons and Cash Back

More Related questions...

Show more question and Answers...

Maven

Comments & Discussions