Sounds like you might want something like mytop ...
http://jeremy.zawodny.com/mysql/mytop/
Or
SHOW PROCESSLIST
http://dev.mysql.com/doc/refman/5.1/en/show-processlist.html
Or
mysql_stat()
http://us2.php.net/manual/en/function.mysql-stat.php
However the fact that you want # of queries made in a single page
might be better to just do a query log dump and view it.
- Jon
On Jul 15, 2007, at 8:55 PM, shaiju davis wrote:
hi All,
How can I get the mysql server status, no. of queries executed in a
single
page and the time to execute total queries in the index.php page.
I would like to get the output like this.
[ Execution time: 0.92 secs ] [ Memory usage: Unknown ] [ 50
database
queries used ] [ GZIP Disabled ] [ Server load: 0.05 ]
If anyone has the idea please reply to this mail.
Thanks in advance
Shaiju
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
