> > 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 ?) > Check what ulimit -a returns (especially max user processes parameter). > -- > 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 >
-- _/ _/ _/_/_/ ----- Rafał Jank [EMAIL PROTECTED] ----- _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625 _/ _/ _/ --------==* http://szukaj.wp.pl *==---------- --------------------------------------------------------------------- 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
