Our application (Win32) gives MySQL a real pounding, but we have never had it die on a server with proper resources.
On Win32 systems, you can not underestimate the importance of virtual memory (swap file) and drive defragmentation. On Win32 systems with SCSI RAID, we set the virtual memory to 20% or more of the total disk storage capacity. If the customer insists on cheaper EIDE drives, we install three ... two in a normal mirrored config, and a third drive that contains nothing more than a big swap file. We make the swap files static (same min and max) to reduce file fragmentation. We no longer support servers that are not running DisKeeper (full version ... not the crippled one in M$ distributions). Gerald Jensen ----- Original Message ----- From: "Mike Wexler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Shane Allen" <[EMAIL PROTECTED]>; "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/columns/tim20000705.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. I have yet to see an application (other than MySQL when it's loaded down with queries) die under this level of load. >> >> > >That's not normal at all. MySQL shouldn't care about the system load. >It may run *slower* but it shouldn't die. > Generally if it dies. Its because the operating system reached some limit. Often if you look at the <hostname>.err file in /var/lib/mysql there will be some clue as to what resource you ran out of. Some possibilities are o Virtual memory (swap space) o Open file descriptors o Address space o Stack space I think you need to examine your system when its underload and see if any of these resources are near exhaustion. > >Jeremy > > --------------------------------------------------------------------- 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
