Posted by Dan Tappin on 03/15/05 02:03

Just an update... on a hunch I changed my mysql_connect to
mysql_pconnect. As expected the first one still takes 5 to 10 seconds
and after that subsequent pages load instantly as expected.

Dan T

On Mar 14, 2005, at 3:07 PM, Dan Tappin wrote:

> I have a PHP5.x site under development with MySQL 4.1.x. I had the
> site running fine and there were no speed issues at all. Everything
> is on the same system (a dual G5 Xserve).
>
> Today however the PHP pages with MySQL calls started to take forever
> to load. Static html and php files still loaded instantly.
>
> I tracked the issue down to mysql_connect. Initial calls to this
> function are taking 5 to 10 seconds each. Subsequent calls missing a
> mysql_close call do not have the latency issue. Normally I try have
> each call to mysql_connect followed by a mysql_close to keep my mysql
> tales in order.
>
> I have tried:
>
> - loading the pages remotely and locally (both slow)
> - checked the Apache / MySQL logs
> - manually ran the mysql queries to check for slow queries (all 0.0x
> seconds duration)
> - restarted apache / mysql
>
> My next step is a hard restart (off hours later tonight) but until
> then I was wondering if anyone has any ideas? I am stumped.
>
> Thanks,
>
> Dan T
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

[Back to original message]