Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

In MySQL :

This query allows us to have the total number of "select" on the server (query 1) :

mysql> SELECT VARIABLE_VALUE FROM information_schema.global_status WHERE variable_name like 'com_select';

and this query allows us to know the number of "select" for the current session :

mysql> show status like 'Com_select';

or

mysql> SHOW SESSION STATUS LIKE 'Com_select';

please, how to have the number of "select" for all current sessions (total) and a query like the first (query 1) , but by date. Thanks.

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.