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,
> > > 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)
---------------------------------------------------------------------
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