Something about Mysql server

[kkz]

Could anyone tell me How to modify the Max. Connection number in Mysql Server?<br />Because I have forum, when the connection exceed 200, a warning page will come up , something like this:"reached max. connection for SQL , refuse to connect"<br /><br />Thank you very much!!

[c-head]

</font><blockquote><font size="1" face="Verdana, Arial">quote:</font><hr /><font size="2" face="Verdana, Arial">Originally posted by kkz:<br /><strong>Could anyone tell me How to modify the Max. Connection number in Mysql Server?<br />Because I have forum, when the connection exceed 200, a warning page will come up , something like this:"reached max. connection for SQL , refuse to connect"<br /><br />Thank you very much!!</strong></font><hr /></blockquote><font size="2" face="Verdana, Arial">You need to create a /etc/my.cnf (on Linux ... prolly goes in the Win or system dir on NT/2000) and put the line:<br /><br />set-variable = max_connections=500<br /><br />... of course you can set the 500 to whatever you want for max connections...

[pornman7678]

Yup..that will do it. <img border="0" title="" alt="[Eek!]" src="eek.gif" />