Re: MySQL, FreeBSD, LinuxThreads, and > 950 connections?

2003-07-16 Thread Jeremy Zawodny
On Wed, Jul 16, 2003 at 10:10:35PM -0500, Dan Nelson wrote: > > I don't know exactly how LT allocates its threads That, it turns out, is the key piece of info. :-) We figured it out and are now testing the solution. If it holds up, I'll post details soon. > A possibly more interesting question

Re: MySQL, FreeBSD, LinuxThreads, and > 950 connections?

2003-07-16 Thread Dan Nelson
In the last episode (Jul 16), Jeremy Zawodny said: > On Wed, Jul 16, 2003 at 03:16:26PM -0500, Dan Nelson wrote: > > In the last episode (Jul 16), Jeremy Zawodny said: > > > Does anyone have MySQL built with LinuxThreads running on FreeBSD > > > 4.x and handling more than 950 connections? > > > >

Re: MySQL, FreeBSD, LinuxThreads, and > 950 connections?

2003-07-16 Thread Jeremy Zawodny
On Wed, Jul 16, 2003 at 03:16:26PM -0500, Dan Nelson wrote: > In the last episode (Jul 16), Jeremy Zawodny said: > > Does anyone have MySQL built with LinuxThreads running on FreeBSD 4.x > > and handling more than 950 connections? > > > > If so, did you need to do anything special to make it work?

Re: MySQL, FreeBSD, LinuxThreads, and > 950 connections?

2003-07-16 Thread Dan Nelson
In the last episode (Jul 16), Jeremy Zawodny said: > Does anyone have MySQL built with LinuxThreads running on FreeBSD 4.x > and handling more than 950 connections? > > If so, did you need to do anything special to make it work? I'm > seeing this: > > Can't create a new thread (errno 35). If you

MySQL, FreeBSD, LinuxThreads, and > 950 connections?

2003-07-16 Thread Jeremy Zawodny
Does anyone have MySQL built with LinuxThreads running on FreeBSD 4.x and handling more than 950 connections? If so, did you need to do anything special to make it work? I'm seeing this: Can't create a new thread (errno 35). If you are not out of available memory, you can consult the manual for

RE: MySQL FreeBSD LinuxThreads

2002-07-17 Thread Simon Green
To: Oleg Borodkin; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: MySQL FreeBSD LinuxThreads Hi Oleg, I have similar problems on FreeBSD with one or two slow queries hogging the CPU. I am running native threads. I am looking at a parameter in the kernel (/usr/src/sys/i386/conf/LINT). It

Re: MySQL FreeBSD LinuxThreads

2002-07-16 Thread Ken Menzel
MAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, July 15, 2002 3:24 PM Subject: MySQL FreeBSD LinuxThreads > Hello, > > I have noticed that MySQL server almost hangs up the system while > processing a big table (perl script using fetchrow). > I didn't experienced t

MySQL FreeBSD LinuxThreads

2002-07-15 Thread Oleg Borodkin
Hello, I have noticed that MySQL server almost hangs up the system while processing a big table (perl script using fetchrow). I didn't experienced this before - may be it's because of LinuxThreads? MySQL launches 38 running processes, but shows only 10 mysql query threads (they are all sleeping