I have a question about a mysql server under Debian GNU/Linux. debian version: woody mysql version: 3.23.49-8.2 libc6 version: 2.2.5-11.2 kernel: 2.4.20 CPU: bi-P3-1266 (Compaq Server proliant) Memory: 2 Go
I have often the error message "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".
Then I recompiled the libc6 package with these changes (debian use softs with shared libraries):
in linuxthreads/internals.h:
#define STACK_SIZE (2 * 128 * 1024)
in linuxthreads/sysdeps/unix/sysv/linux/bits/local_lim.h: #define PTHREAD_THREADS_MAX 4096
in /etc/sysctl.conf: fs/file-max=65536
in /etc/mysql/my.cnf: [safe_mysqld] err-log = /var/log/mysql/mysql.err open-files-limit = 8192 [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/mysql/data tmpdir = /tmp language = /usr/share/mysql/english skip-locking set-variable = key_buffer=128M set-variable = max_allowed_packet=4M set-variable = table_cache=512 set-variable = sort_buffer=2M set-variable = record_buffer=2M set-variable = thread_cache=8 set-variable = thread_stack=128K set-variable = max_connections=500 set-variable = max_connect_errors=100 set-variable = wait_timeout=10000 # Try number of CPU's*2 for thread_concurrency set-variable = thread_concurrency=4 set-variable = myisam_sort_buffer_size=64M
I receive the error message when I have more than 255 threads at the same moment (mytop report).
May be the kernel to tune? (ulimit ?)
-- Cedric Gavage <[EMAIL PROTECTED]> - Niddle http://unixtech.be - http://gavage.com - OpenPGP: 0xED325C64
--------------------------------------------------------------------- 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
