> 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
> How many processes do you get? Significantly more than 400? (I hope
> not.)
A few less than 400
> 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.
---------------------------------------------------------------------
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
