Daniel, I have a few things that you might want to check (in order of most likely):
1. What is the maximum number of file descriptors set? If this is too low you will be running into problems. Here is a paste from the MySQL manual that is very helpful: For more information you can read the full manual page here: http://dev.mysql.com/doc/mysql/en/Linux-post-install.html --PASTE-- If MySQL can't open enough files or connections, it may be that you haven't configured Linux to handle enough files. In Linux 2.2 and onward, you can check the number of allocated file handles as follows: shell> cat /proc/sys/fs/file-max shell> cat /proc/sys/fs/dquot-max shell> cat /proc/sys/fs/super-max If you have more than 16MB of memory, you should add something like the following to your init scripts (for example, `/etc/init.d/boot.local' on SuSE Linux): echo 65536 > /proc/sys/fs/file-max echo 8192 > /proc/sys/fs/dquot-max echo 1024 > /proc/sys/fs/super-max You can also run the echo commands from the command line as root, but these settings will be lost the next time your computer restarts. Alternatively, you can set these parameters on startup by using the sysctl tool, which is used by many Linux distributions (SuSE has added it as well, beginning with SuSE Linux 8.0). Just put the following values into a file named `/etc/sysctl.conf': # Increase some values for MySQL fs.file-max = 65536 fs.dquot-max = 8192 fs.super-max = 1024 You should also add the following to `/etc/my.cnf': [mysqld_safe] open-files-limit=8192 This should allow the server a limit of 8,192 for the combined number of connections and open files. --END PASTE-- The thread_stack and thread_cache_size variables aren't going to fix you're problem.. You can read exactly what they're for here: http://dev.mysql.com/doc/mysql/en/Server_system_variables.html Hope this helps Lachlan -----Original Message----- From: Daniel Eliav Sharvit [mailto:[EMAIL PROTECTED] Sent: Friday, 9 July 2004 5:16 AM To: [EMAIL PROTECTED] Subject: Handling threads Hi list, I'm having the following problem when I tried to connect to MySQL server through terminal mysql client it displayed "Can't create thread errno (11)" , I worked around the variables thread_stack and thread_cache_size, its initial value was 64KB for thread_stack and 20 for thread_cache_size; I read on different mysql lists and the official documentation about this variables and I guessed that incrementing the values of these variables could solve my problem, so I incremented the thread_stak to 128KB and the thread_cache_size to 50, after restarting MySQL worked pretty fine but it lasted 20 hours to displayed me the same error "Can't create thread errno (11)" the question is, do I have to increment those values or I'll have to increment other variables, or if you know any urls that I could use I really appreciate. The system features are: - MySQL server 3.23.55 - Linux version 2.4.22 - Red Hat Linux 7.3 2.96-110 #3 SMP - 4GB RAM - 4 Xeon processors Thanks in advance Daniel Eliav Sharvit _________________________________________________________________ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
