I can do a bit..... set-variable = max_user_connections = 100 set-variable = max_connections = 500 So if you change max_connections to = 1000..... Then set max_user_ connections to the max you what any one IP/host/user to have this will help. The number of simultaneous connections will also be down to your OS so check with that. Another thing to check is that all the connections are dropped after use and so do not hang about and use up threads. Simon
-----Original Message----- From: Amadou Toure [mailto:[EMAIL PROTECTED]] Sent: 14 October 2002 11:13 To: [EMAIL PROTECTED] Subject: performance et tuning question HELLO, we 're using mysql 3.23.49 on a dedicated server (dual processor 933Mhz) with 1,5Gb of RAM and another web server access to the database for dynamic web pages. Our problem is "too many connections" message, i thing that the mysql daemon is overload because we have up to 40000 pages visited and this number grow daily. does someone cant tell me how in details process to do the following things : * tuning mysql * improve performances * configure to allow mysql to hit up to 1000 simultaneous connections thanks Amadou Toure http://www.sentoo.sn --------------------------------------------------------------------- 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