Hi, i had a problem like this, too. in my case it wasnt mysql restricting the number of threads but my OS (Linux/Debian). Usually mysql does not run as root, but as user "mysql" or something else. Debian restricts normal users to a number of running processes to prevent an overloaded.
i solved my problem by raising this value, in my case with the tool "ulimit". i call it with the appopriate paramter in safe_mysqld. there is already a ulimit call in safe_mysqld to raise thie number of allowed open files. i added my ulimit right after that line... hope that helps... regards, philipp ----- Original Message ----- From: "my5ql _" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 28, 2003 3:04 PM Subject: 3.23 thread error - help/advice please > I tweaked my.cnf on a server. > Changed wait_timeout from 80 to 75 > and increased key_buffer to 1280M from 1024M > > max_connections is set to 500 > Max_used_connections was reported at 370 (from 'mysqladmin variables') > thread_cache is set to 48 > > I ran 'mysqladmin flush-hosts' as the mysql root user and got the following > output: > > /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed > error: 'Can't create a new thread (errno 11). If you are not out of > available memory, you can consult the manual for a possible OS-dependent > bug' > > Problem seems to have disappeared once I reverted back to my old settings > (and I don't get the regular [every 10min] php pconnect errors). > Max_used_connections is now at 439. > > System is MySQL 3.23.51 built from source, Rh 7.3, custom 2.4.19 kernel. > > What I'm unsure about is the errors from php pconnect and the inability to > flush hosts when I hadn't hit any connection limits. I have over 2GB RAM > free (as reported by 'top') > > Any ideas/suggestions? > > > > > > > > > > _________________________________________________________________ > Chat online in real time with MSN Messenger http://messenger.msn.co.uk > > > --------------------------------------------------------------------- > 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
