MySQL Forums
Forum List  »  Performance

Re: mysql connection issue when stress stesting
Posted by: James Day
Date: April 27, 2005 01:45AM

Silly questions first because they are easy to miss and can easily get you tearing your hair out if you don't check them: did you restart mysqld after changing the ulimit? Did you perhaps change PHP settings and not restart Apache? Maybe moved the sock file via change in my.cnf and not update PHP to go to the new place, or not restart Apache after changing PHP settings?

If none of those, this post might have something else which causes you to see the solution: http://forums.mysql.com/read.php?11,9127,19243#msg-19243 . More possibilities in the manual at http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html and in this thread if you're using SELinux: http://www.codecomments.com/PHP_SQL/message323526.html .

On Fedore Core 2 and 3 I've had 2,000 connections and non-persistent connection/query rates from PHP of more than 3,000 per second, so it's not a fundamental limit in MySQL.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: mysql connection issue when stress stesting
1899
April 27, 2005 01:45AM


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.