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 (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
>
---------------------------------------------------------------------
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