max_connections

[Asad Habib]

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]