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 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 the server w a higher number? stats on my db setup: - database machine has 384MB of ram - clients are web browsers hitting jsp pages which access the mysql db - one person can generate tens of threads moving around the site - current max connections is 100 - production server is red hat linux, dev server where i do all my development is win2k - Connections/Threads_Connected is currently 1:1 (cache problem?) i obviously need to do some optimization in my java code and jsp pages (who doesn't ;), but i also suspect the default 100 connections is too low. can i set this to 500 or 1000? also, i've been looking for a good site with mysql optimization tips, any suggestions? thanks a ton. -mitch --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php