Query time

Server NGINX
1

Greetings,

I am not really sure if this is the right place to ask something like
that but seeing all those available mods doing almost everything, here
it goes.

Is there any way (php-cgi mod?) that i can use to measure the time it
takes for a (sql) query to complete?

My setup uses nginx servers on a mysql cluster.

Thank you in advance and i am sorry also in advance if the subject is
irrelevant.

–

Alex

2

Look into the slow query log of mysql.

3

On Mar 29, Alexander Economou wrote:

I am not really sure if this is the right place to ask something like
that but seeing all those available mods doing almost everything, here
it goes.

Is there any way (php-cgi mod?) that i can use to measure the time it
takes for a (sql) query to complete?

nginx does not execute php scripts. Infact, it has no idea that the
proxy/fastcgi backend is even using php. So, the right place to look for
would be on a php forum.

4

Thanks both of you :slight_smile:

On 03/29/2011 08:27 PM, Ilan B. wrote:

 >Is there any way (php-cgi mod?) that i can use to measure the time it

nginx mailing list
[email protected]
nginx Info Page

–

Alexander Loukas Economou
Systems & Network
Administrator
gsm : 6986 298 859
email : [email protected]