mysql query returning slowly

------=_NextPart_000_002E_01CAD59D.1C62A8D0
Content-Type: text/plain;
charset="US-ASCII"


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 UPDATE `calls` SET `Result`='Busy' WHERE
`CallID`='144786'
| Status | Duration | CPU_user | CPU_system |
Context_voluntary | Context_involuntary | Block_ops_in | Block_ops_out |
Messages_sent | Messages_received | Page_faults_major | Page_faults_minor |
Swaps |

------------------------------------------------------------ ----------------
------------------------------------------------------------ ----------------
------------------------------------------------------------ ------
| starting | 0.000039 | 0.000000 | 0.000000 | 0
| 0 | 0 | 0 | 0 | 0
| 0 | 0 | 0 |
| checking permissions | 0.000008 | 0.000000 | 0.000000 | 0
| 0 | 0 | 0 | 0 | 0
| 0 | 0 | 0 |
| Opening tables | 0.000010 | 0.000000 | 0.000000 | 0
| 0 | 0 | 0 | 0 | 0
| 0 | 0 | 0 |
| System lock | 0.000005 | 0.000000 | 0.000000 | 0
| 0 | 0 | 0 | 0 | 0
| 0 | 0 | 0 |
| Table lock | 0.000006 | 0.000000 | 0.000000 | 0
| 0 | 0 | 0 | 0 | 0
| 0 | 0 | 0 |
| init | 0.000036 | 0.000000 | 0.000000 | 0
| 0 | 0 | 0 | 0 | 0
| 0 | 0 | 0 |
| Updating | 0.000099 | 0.001000 | 0.000000 | 0
| 0 | 0 | 0 | 0 | 0
| 0 | 0 | 0 |
| end | 0.000023 | 0.000000 | 0.000000 | 0
| 0 | 0 | 0 | 0 | 0
| 0 | 0 | 0 |
| query end | 0.000004 | 0.000000 | 0.000000 | 0
| 0 | 0 | 0 | 0 | 0
| 0 | 0 | 0 |
| freeing items | 0.007410 | 0.000000 | 0.000000 | 4
| 1 | 0 | 0 | 0 | 0
| 0 | 0 | 0 |
| logging slow query | 0.000004 | 0.000000 | 0.000000 | 0
| 0 | 0 | 0 | 0 | 0
| 0 | 0 | 0 |
| cleaning up | 0.000004 | 0.000000 | 0.000000 | 0
| 0 | 0 | 0 | 0 | 0
| 0 | 0 | 0 |





Thanks

David Murphy


------=_NextPart_000_002E_01CAD59D.1C62A8D0--

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

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


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php