Re: Crashing under high load

2002-08-04 Thread Gerald R. Jensen
gt;; "Georg Richter" <[EMAIL PROTECTED]> Sent: Saturday, August 03, 2002 7:14 PM Subject: Re: Crashing under high load Jeremy Zawodny wrote: >On Fri, Aug 02, 2002 at 05:41:09PM -0500, Shane Allen wrote: > > >>The gentleman on PHPBuilder (http://www.phpbuilder.com/c

Re: Crashing under high load

2002-08-04 Thread Mike Wexler
Jeremy Zawodny wrote: >On Fri, Aug 02, 2002 at 05:41:09PM -0500, Shane Allen wrote: > > >>The gentleman on PHPBuilder (http://www.phpbuilder.com/columns/tim2705.php3) >(again, I acknowledge this is an old article) says flat out that MySQL tends to die >under high load. Also, when I say

Re: Crashing under high load

2002-08-02 Thread Heikki Tuuri
Shane, - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, August 03, 2002 2:21 AM Subject: Re: Crashing under high load > On Fri, Aug 02, 2002 at 05:41:09PM -0500, Shane Allen wrote: > > > &

Re: Crashing under high load

2002-08-02 Thread Jeremy Zawodny
On Fri, Aug 02, 2002 at 05:41:09PM -0500, Shane Allen wrote: > > The gentleman on PHPBuilder (http://www.phpbuilder.com/columns/tim2705.php3) >(again, I acknowledge this is an old article) says flat out that MySQL tends to die >under high load. Also, when I say high load, I am talking 15-30

Re: Crashing under high load

2002-08-02 Thread Eric Anderson
> Well, most programs, in my experience, will keep running, even if load > is 200, they just run slowly since they aren't getting processor load. How's the memory? Typically things (especially Mysql) croak if they bonk on memory - if you're into the swap on high load, you're screwed. -- --

Re: Crashing under high load

2002-08-02 Thread Shane Allen
On Fri, Aug 02, 2002 at 10:59:18PM +0200, Georg Richter wrote: > On Friday, 2. August 2002 20:48, Shane Allen wrote: > > I digress... at this point, the question that plagues me is: Is it normal > > for MySQL to die under high load? > > you have a lot of programs, which prefer to die under heavy

Re: Crashing under high load

2002-08-02 Thread Georg Richter
On Friday, 2. August 2002 20:48, Shane Allen wrote: Hi, > I digress... at this point, the question that plagues me is: Is it normal > for MySQL to die under high load? you have a lot of programs, which prefer to die under heavy load. The main question is not why they die, the question is why is

Crashing under high load

2002-08-02 Thread Shane Allen
I recently read an article (on PHPBuilder; it's fairly old) that spoke of MySQL dying under high load. Recently (since I built 3.23.51 and on my test build of 4.0.2) I have had problems with MySQL dying (got signal 11, et al.) under extreme high load. For example, if I set up a 60-thread spide