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:nrix...@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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php