Re: MySQL Spawning Tons of Processes

2001-09-17 Thread Jeremy Zawodny
On Mon, Sep 17, 2001 at 10:03:29AM -0700, Michael McConnell wrote: > It certainly does seem that 3.23.40+ take considerably more > resources to do the exact same thing, than MySQL 3.22.xx If that's the case, it's worth tracking down so that it can be fixed. > Is this correct? I hope not. Jere

Re: MySQL Spawning Tons of Processes

2001-09-17 Thread Michael McConnell
It certainly does seem that 3.23.40+ take considerably more resources to do the exact same thing, than MySQL 3.22.xx Is this correct? > On Sun, Sep 16, 2001 at 10:21:05PM -0700, Michael McConnell wrote: > > > > So what your saying is MySQL is supposed to fork a new processes for > > every conn

Re: MySQL Spawning Tons of Processes

2001-09-16 Thread Jeremy Zawodny
On Sun, Sep 16, 2001 at 10:21:05PM -0700, Michael McConnell wrote: > > So what your saying is MySQL is supposed to fork a new processes for > every connection? I don't think so... No. MySQL will spawn a new thread to handle each incoming connection. It's just that threads on a Linux bear a stri

Re: MySQL Spawning Tons of Processes

2001-09-16 Thread Paul DuBois
At 10:21 PM -0700 9/16/01, Michael McConnell wrote: >So what your saying is MySQL is supposed to fork a new processes for every >connection? I don't think so... ... based on? Lemme guess. Running Linux? > >> > > > I'm running MySQL 3.23.42 on a PIII 866 with 1 Gig of RAM. If I >> > > > conne

Re: MySQL Spawning Tons of Processes

2001-09-16 Thread Michael McConnell
So what your saying is MySQL is supposed to fork a new processes for every connection? I don't think so... > > > > I'm running MySQL 3.23.42 on a PIII 866 with 1 Gig of RAM. If I > > > > connect 400 requests and and ask for something all at the same time, > > > > MySQL spawns many child proccess

Re: MySQL Spawning Tons of Processes

2001-09-16 Thread Jeremy Zawodny
On Sun, Sep 16, 2001 at 06:58:05PM -0700, Michael McConnell wrote: > > > On Sun, Sep 16, 2001 at 04:44:05PM -0700, Michael McConnell wrote: > > > > > > I'm running MySQL 3.23.42 on a PIII 866 with 1 Gig of RAM. If I > > > connect 400 requests and and ask for something all at the same time, > > >

Re: MySQL Spawning Tons of Processes

2001-09-16 Thread Michael McConnell
> On Sun, Sep 16, 2001 at 04:44:05PM -0700, Michael McConnell wrote: > > > > I'm running MySQL 3.23.42 on a PIII 866 with 1 Gig of RAM. If I > > connect 400 requests and and ask for something all at the same time, > > MySQL spawns many child proccess (hundreds and hundreds). As a > > result of al

Re: MySQL Spawning Tons of Processes

2001-09-16 Thread Jeremy Zawodny
On Sun, Sep 16, 2001 at 04:44:05PM -0700, Michael McConnell wrote: > > I'm running MySQL 3.23.42 on a PIII 866 with 1 Gig of RAM. If I > connect 400 requests and and ask for something all at the same time, > MySQL spawns many child proccess (hundreds and hundreds). As a > result of all these proce

MySQL Spawning Tons of Processes

2001-09-16 Thread Michael McConnell
I'm running MySQL 3.23.42 on a PIII 866 with 1 Gig of RAM. If I connect 400 requests and and ask for something all at the same time, MySQL spawns many child proccess (hundreds and hundreds). As a result of all these processes the system essentailly hangs (Loadavg of 588 525 310) Does anyone know