RE: mysql query returning slowly

Nathan, 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 [mailto:nrixham@gmail.com] Sent: Tuesday, April 06, 2010 6:35 PM To: David Murphy Cc: php-general@lists.php.net 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 are > 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