List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 17 2001 5:20am
Subject:Re: MySQL Spawning Tons of Processes
View as plain text  
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
>>  > > > 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 how I can stop this from happening?
>>  > > Is what you're asking for an "easy" query?
>>  > A very simple select statement
>>  Good.
>
>
>
>>  > > How many processes do you get?  Significantly more than 400?  (I hope
>>  > > not.)
>>  >
>>  > A few less than 400
>>
>>  That's expected, then.  You get one thread per connection, so this
>>  makes sense.
>>
>>  > > Have you run vmstat to see if the system is swapping like mad?
>>  >
>>  > 0 Swapping just a CPU Idle of 0 and almost all my ram eaten up.
>>
>>  Very good.  No swapping.  And the CPU ought to be busy.
>>
>>  How long does the situation persist?  Are you using MyISAM tables?
>>
>>  Jeremy
>>  --
>>  Jeremy D. Zawodny, <jzawodn@stripped>
>>  Technical Yahoo - Yahoo Finance
>>  Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936
>>
>>  MySQL 3.23.41-max: up 10 days, processed 201,979,372 queries (214/sec.
>avg)


-- 
Paul DuBois, paul@stripped
Thread
MySQL Spawning Tons of ProcessesMichael McConnell17 Sep
  • Re: MySQL Spawning Tons of ProcessesJeremy Zawodny17 Sep
  • Re: MySQL Spawning Tons of ProcessesMichael McConnell17 Sep
    • Re: MySQL Spawning Tons of ProcessesJeremy Zawodny17 Sep
  • Re: MySQL Spawning Tons of ProcessesMichael McConnell17 Sep
    • Re: MySQL Spawning Tons of ProcessesPaul DuBois17 Sep
    • Re: MySQL Spawning Tons of ProcessesJeremy Zawodny17 Sep
  • Re: MySQL Spawning Tons of ProcessesMichael McConnell17 Sep
    • Re: MySQL Spawning Tons of ProcessesJeremy Zawodny17 Sep