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';


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


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

Browse other questions tagged or ask your own question.