Sets number of connectons per user/host set-variable = max_user_connections = 100 Sets total number of connections. set-variable = max_connections = 500
Also see number of threads for FreeBSD at www.FreeBSD.org Also in MySQL log on and do a "show processlist" and see how many connocetons you have. Simon -----Original Message----- From: Varshavchick Alexander [mailto:[EMAIL PROTECTED]] Sent: 02 October 2002 09:31 To: [EMAIL PROTECTED] Subject: Can't create a new thread error Hi people, Why such a message appears at random times when connecting to mysql: ERROR 1135: Can't create a new thread (errno 35). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug The system is FreeBSD 4.5 with mysql 4.0.2, and there is a lot of available memory. May be mysql is not configured optimally, if so which options should I try tweaking in my.cnf? Any other suggestions? Thanks ---- Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) --------------------------------------------------------------------- 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