Re: mysql query returning slowly
| From: | Nathan Rixham | Date: | Tue, 06 Apr 2010 23:34:30 +0000 |
| Subject: | Re: mysql query returning slowly | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-303861@lists.php.net to get a copy of this message | ||
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