MySQL Forums
Forum List  »  Performance

Re: Dropped/Slow connections to MySQL from PHP
Posted by: Ryan Paulson
Date: March 22, 2005 11:55AM

Slow connections could be any number of things.

We had to close/secure all unused ports on our Windows boxes to improve login times, but what really solved our connection problems was modifying our .ini file.

We lowered our wait_timeout to 60 seconds and increased our thread_cache_size to 90% of our max_connections. If we were using PHP like you, I would set my wait_timeout to around 10 seconds.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Dropped/Slow connections to MySQL from PHP
1744
March 22, 2005 11:55AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.