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, <[EMAIL PROTECTED]>
>> 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, [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
