Threads > 1024 & statically linking against linuxthreads library
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]
RE: Can't start server: Bind on TCP/IP port: Address already in use
You are only listing processes owned by you. ps -e will show all processes, add -f for a full listing. > -Original Message- > From: Tobias Bohlin [mailto:[EMAIL PROTECTED] > Sent: 07 June 2004 11:30 > To: [EMAIL PROTECTED] > Subject: Can't start server: Bind on TCP/IP port: Address > already in use > > > Hi! > > I have restarted the Linux server. Typing > >mysqld > result: > 040607 11:32:47 Can't start server: Bind on TCP/IP port: Address > already in use > 040607 11:32:47 Do you already have another mysqld server running on > port: 3306 ? > 040607 11:32:47 Aborting > > 040607 11:32:47 mysqld: Shutdown Complete > > This isn't correct I think, as > >ps > yields: >PID TTY TIME CMD > 9855 pts/100:00:00 bash > 10363 pts/100:00:00 ps > > No sign of another mysql daemon running there. > > What to do? It used to work flawlessly. Am I hacked? > > Cheers > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > 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]
RE: Losing some records
Losing some message body too :-? > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: 18 June 2004 13:11 > To: [EMAIL PROTECTED] > Subject: Losing some records > > > 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]
