The number of all queries since the start of the MySQL server

Question

How do I know how many queries have been executed since the MySQL server started?

+1

Readonly May 07 '09 at 18:43

4 answers

If you want to do this in a request, instead of running an external program:

SHOW GLOBAL STATUS LIKE 'Questions';

+2

Chad birch May 07 '09 at 18:48

In MySQL 5.1.31 or newer, you can do show status

and check a line named "Queries"

If you don't have 5.1, use the "Questions" line. In 5.1 it will not include queries inside stored procedures.

0

Plutor May 07 '09 at 18:47

Just Status mysqladmin -p

should provide you with useful information and specific information.

0

Basu May 08 '09 at 10:43

Joe · Accepted Answer · 2009-05-07T18:46:33+0000

mysqladmin proc stat

This should give you the number of questions (among other information), which is the number of requests made by the server.

One handy piece of information returned is the slow request count. Hope it's 0. :)