RE: Optimal value for 'max_connections'

2002-01-17 Thread Gary . Every
day, January 17, 2002 3:00 PM To: [EMAIL PROTECTED] Subject: Optimal value for 'max_connections' Hi, i've been googlizing for a while now and can't find a straight answer to this question: - what is the optimal setting for "max_connections" in mysql? - how do i start

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

Optimal value for 'max_connections'

2002-01-17 Thread Mitch Fournier
Hi, i've been googlizing for a while now and can't find a straight answer to this question: - what is the optimal setting for "max_connections" in mysql? - how do i start the server w a higher number? stats on my db setup: - database machine has 384MB of ram - clients are web browsers hittin