as somebody in the list already pointed out it all depends on the amount of RAM you have , the formula has been taken from Jeremy's book , high performance Mysql
Expressed mathematically, that is: min_memory_needed = global_buffers + (thread_buffers * max_connections) where thread_buffers includes the following: sort_buffer myisam_sort_buffer read_buffer join_buffer read_rnd_buffer and global_buffers includes: key_buffer innodb_buffer_pool innodb_log_buffer innodb_additional_mem_pool net_buffer and as far as I know mysql does not reserve system resources based on max_connections, it will use/release RAM based on the current connections .... Kishore Jalleda On 1/25/06, Asad Habib <[EMAIL PROTECTED]> wrote: > Are there any statistics that I can use to determine how high or low I > should set max_connections? I am using MySQL as the backend for a Java web > application that will need to accommodate a moderate amount of traffic. > Also, if max_connections is set too high relative to the needs of the > application, does this waste system resources? In other words, does MySQL > reserve system resources based on the value of max_connections or does it > dynamically reserve/release system resources based on what the > application's current needs are? The application itself uses a connection > pool and hence idle connections are recycled and reused. Any help would be > appreciated. Thanks. > > - Asad > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
