Hi list, We have apps that try to open > 700 simultaneous connections to our 4.0.20-max mysql server running on RH7 (Linux kernel 2.4.20). We get many 'Can't create a new thread (errno 11)' errors returned by mysql_real_connect().
I'm trying to follow the directions given in the Linux Source Distribution Notes (section 2.12.1.3) about - increasing PTHREAD_THREADS_MAX in `sysdeps/unix/sysv/linux/bits/local_lim.h', - decreasing STACK_SIZE in `linuxthreads/internals.h', - recompiling LinuxThreads to produce a new `libpthread.a' library, and - relink MySQL against it. The first three steps are ok, downloaded glibc-2.2.5 (which is also running on my box), downloaded glibc-linuxthreads-2.2.5, hacked & compiled everything ok. Downloaded mysql-4.0.22 source (close enough to my 4.0.20 production system). Now i realize i haven't the faintest idea how to 'statically link MySQL against it'. I keep on running into all kinds of dynamic linker errors. The page http://www.volano.com/linuxnotes.html referred to in the manual don't exist. Exhaustive search of this list didn't help (i followed the recent discussion re 'MySQL 4.0.2 is topping out at 1024 threads' but that don't help me). Does anyone have any notes/pointers/info/idiot's guide in this regard? Thanks, ------ Willem Roos "Per sercas vi malkovri" - JS Bach (freely translated) Disclaimer http://www.shoprite.co.za/disclaimer.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
