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.
Subject
Views
Written By
Posted
3145
April 26, 2005 02:49AM
Re: mysql connection issue when stress stesting
2074
April 27, 2005 01:45AM
2066
April 27, 2005 03:36AM
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.