You are here

Home

MySQL Queries

Thu, 2014-03-13 05:51 — kalasha
Please help me how to find the list of queries per second or how many (count) queries are executed per second in mysql 5.5

Kalasha,

mysqladmin tool would help you in this.
You can get the number of queries per second (since mysql server started) by simply executing the following terminal command:

mysql@ubuntu:~ [dev, 3306]> mysqladmin -u root status
Uptime: 100  Threads: 1  Questions: 26  Slow queries: 0  Opens: 72  Flush tables: 1  Open tables: 4 Queries per second avg: 0.260

The queries per second value = Questions / Uptime.

abdel-mawlacomment Thu, 2014-03-13 09:29