You are here

MySQL Queries

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