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?
How many processes do you get? Significantly more than 400? (I hope
not.)
Have you run vmstat to see if the system is swapping like mad?
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,269,490 queries (215/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
