NYCPHP Meetup

[Jon Baer]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20070715/15ca5e5d/attachment.html>