RE: Optimal value for 'max_connections'

2002-01-17 Thread Gary . Every
You can set your max_connections variable thusly: mysqld -O max_connections=1000 (That's an upper-case letter "O" and the above needs to be appended to the other options that start mysqld -Original Message- From: Mitch Fournier [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002

Re: Optimal value for 'max_connections'

2002-01-17 Thread John Kemp
Mitch, You need to set the max_connections variable to something in you my.cnf file. This number is really determined by your OS/Memory etc. but I think the MySQL manual says somewhere about 500 to 700 being possible with Solaris. Currently we use a figure of 220, but I got to that number by