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