number of queries executed in mysql

[oppiniated]

Hi;
I am back with another (wierd) question…
Is there any method (in mysql) by which I can find out the number of queries that have been executed in MySQL for a particular day.
If not any php script that someone knows which could give the desired results.

Thanks in advance…

[peg110]

In the MySQL Server itself, have you tried to run SHOW STATUS ?

http://dev.mysql.com/doc/refman/5.0/en/show-status.html