Hi there,
this problem was asked in this list before and i thought i solved it but i was wrong. Heres the description: I am running mysql 3.23.54 on Debian Linux with 2.4.20 Final System has 2 GB Ram. I compiled from source. Here are relevant passages from my.cnf port = 3306 socket = /var/run/mysql/mysql.sock set-variable = max_connections=1000 skip-locking set-variable = open_files_limit=8129 set-variable = max_tmp_tables=300 set-variable = key_buffer=512M set-variable = max_allowed_packet=5M set-variable = table_cache=3000 set-variable = sort_buffer=2M set-variable = record_buffer=2M set-variable = thread_cache=50 set-variable = myisam_sort_buffer_size=96M set-variable = thread_concurrency=512 set-variable = wait_timeout=60 Ulimits are raised to unlimted for user msql. I am executing this in safe_mysqld: ulimit -n $open_files ulimit -u unlimited ulimit -a >> /tmp/mysql.ulmit mysql.ulimit looks like this: core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited max locked memory (kbytes, -l) unlimited max memory size (kbytes, -m) unlimited open files (-n) 8129 pipe size (512 bytes, -p) 8 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) unlimited virtual memory (kbytes, -v) unlimited The System never runs out of Ram. There is lots of it available, but when Mysql created 750 threads it stops creating more. It then tells me something like in the Subject: Can't create thread, perhaps out of memoy, OS-depended bug, blah... Now finally, a question: Can someone please give me a hint what to do to make mysql create more threads ? Regards, Philipp --------------------------------------------------------------------- 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
