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