[no subject]

It should be "max_connections=250" (drop the set-variable=)

re: <a  rel="nofollow" href="http://dev.mysql.com/doc/mysql/en/option-files.html";>http://dev.mysql.com/doc/mysql/en/option-files.html</a>

--
from Downunder (and a little to the left)
   Keith


Christopher Fowler wrote:
&gt; I'm trying to change the number of max connections for my MySQL
&gt; server
&gt; 
&gt; -- my.cnf --
&gt; [mysqld]
&gt; datadir=/usr/local/mysql/data
&gt; set-variable=max_connections=250
&gt;      
&gt; [mysql.server]
&gt; user=tomcat
&gt; basedir=/usr/local/mysql
&gt; 
&gt; 
&gt; [tomcat at sam-devel mysql]$ mysqladmin  -u root -p -h 127.0.0.1 variables
&gt; | grep max_connections
&gt; Enter password: 
&gt; | max_connections                 |
&gt; 100                                                                                                                                                     
&gt; Can someone tell me what I'm doing wrong?
&gt; 
&gt; Thanks,
&gt; Chris
&gt; 
&gt; 
&gt; 
&gt; _______________________________________________
&gt; Ale mailing list
&gt; Ale at ale.org
&gt; <a  rel="nofollow" href="http://www.ale.org/mailman/listinfo/ale";>http://www.ale.org/mailman/listinfo/ale</a>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3383 bytes
Desc: S/MIME Cryptographic Signature



</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<ul><li><strong>Follow-Ups</strong>:
<ul>
<li><strong><a name="00675" href="msg00675.html">[ale] MySQL amx connections</a></strong>
<ul><li><em>From:</em> cfowler at outpostsentinel.com (Christopher Fowler)</li></ul></li>
</ul></li></ul>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="00062" href="msg00062.html">[ale] MySQL amx connections</a></strong>
<ul><li><em>From:</em> cfowler at outpostsentinel.com (Christopher Fowler)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00673.html">[ale] SuSE OpenExchange vs. Scalix vs. ???</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00675.html">[ale] MySQL amx connections</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00062.html">[ale] MySQL amx connections</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00675.html">[ale] MySQL amx connections</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00674"><strong>Date</strong></a></li>
<li><a href="threads.html#00674"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>