Hi Simon, here are the current values (from 'show variables'): max_connections: 5000 max_user_connections: 0
And looking at 'show extended-status': Max_used_connections: 945 Concerning freebsd threads mechanism, I'm using linux threads, and the maximum number of existing thread processes went even higher during the peak load times. So something else went wrong... ---- Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) On Wed, 2 Oct 2002, Simon Green wrote: > Date: Wed, 2 Oct 2002 10:45:07 +0100 > From: Simon Green <[EMAIL PROTECTED]> > To: 'Varshavchick Alexander' <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > Subject: RE: Can't create a new thread error > > 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 > --------------------------------------------------------------------- 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