[ale] MySQL amx connections

Keith Hopkins hne at hopnet.net
Fri Jun 17 20:20:14 EDT 2005


Assuming it is at least 4.x:

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

re: http://dev.mysql.com/doc/mysql/en/option-files.html

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


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

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




More information about the Ale mailing list