Mysql count how many queries per second are executed, is there any way ?

Question

Hello, i have a busy web server with LAMP installed, and i was wondering, is there any way to count how many queries per second (mysql) are executed in the server ?

Thank you.

Answer 1

Try Jeremy Zawodny's excellent utility mytop.

If you have the Perl module Time::HiRes installed, mytop will automatically use it to generate high-resoution query per second information.

Answer 2

There's useful information to be mined from the SHOW GLOBAL STATUS; command, including the number of queries executed (if your MySQL is 5.0.76 or later).

See http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html

Answer 3

Could you try "mysqladmin status" ?