The profiling I included proved that was not the case.

Mysql run the query and return the single column single  row result in under
1 second but  PHP's mysql->query waited much longer than that to return.  If
it was a big result set I could  see some slow down in parsing the results
into memory but  this wasn't the case. Updates/Deletes have similar random
timing  issues , and using mysql profiling, I can see its not transit or
lock or  clean up time from mysql <-> php , it is purely inside the php
mysql functions  the slow down seems to be occurs , but I can dive into
those as they are compiled modules not  userland functions.

-----Original Message-----

-----Original Message-----
From: Nathan Rixham [] 
Sent: Tuesday, April 06, 2010 6:35 PM
To: David Murphy
Subject: Re: mysql query returning slowly

David Murphy wrote:
> This is from our application 
> I enabled profile in mysql to determine why an update took 20seconds.  As
> you can see  MySQL reported no where near that amount of duration took
> place. 
> Is there any way I can dig into php and determine why  mysql client libs
> so slow (this is not using mysqlnd but  mysql-client-libs on CentOS using
> 5.3.2)
> 04/06/2010 14:54:54 20.6899s

maybe it was waiting to acquire a lock

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to