heavy load configuration
I have a Linux box running mysql and apache, and we are expecting quite a load on the 1st of June. We have an application form whose data will be written into a db on the same server and I would like to know what I can do to make sure things go smooth. The machine is an AMD 500, with 320MB RAM, 256MB SWAP a 20GB IDE with the OS on and a 18,2GB SCSI 1rpm for backup and location of /var/lib/mysql in order to facilitate high speed writes of the tables to disk. How will I know if my server is up to it, or should I rather say, how many consecutive users will this box be able to handle? The line shouldn't be a problem, I think it sits on a couple of 100 MB/s line. Thanks - 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
Re: heavy load configuration
You should get an identical 20gig IDE drive to 'mirror' the O/S partitions, and since you have a SCSI setup for the data areas, you should get at least 2 more of those, and 'stripe' the data across them (or at least get a second drive to 'mirror' those partitions as well).Though 'mirroring' will only give you a performance boost (up to 2 times) for 'reads', it will protect against a full failure (especially if you ARE going to be that busy) if one of the drives fails... A 3+ drive 'stripe' will give you a great 'write' performance increase, but won't protect the data against drive failure. (if you have a lot of money to spend, get 5 more drives, and stripe the data across 3 of them, and 'mirror' them to the other 3 drives... If you have a REAL lot of money to spend, put the 2nd 3 SCSI drives on a different SCSI controller) - Original Message - From: P.Agenbag [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, May 26, 2001 9:34 AM Subject: heavy load configuration I have a Linux box running mysql and apache, and we are expecting quite a load on the 1st of June. We have an application form whose data will be written into a db on the same server and I would like to know what I can do to make sure things go smooth. The machine is an AMD 500, with 320MB RAM, 256MB SWAP a 20GB IDE with the OS on and a 18,2GB SCSI 1rpm for backup and location of /var/lib/mysql in order to facilitate high speed writes of the tables to disk. How will I know if my server is up to it, or should I rather say, how many consecutive users will this box be able to handle? The line shouldn't be a problem, I think it sits on a couple of 100 MB/s line. Thanks - 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
Re: heavy load configuration
At 06:34 PM 5/26/2001 +0200, P.Agenbag wrote: How will I know if my server is up to it, or should I rather say, how many consecutive users will this box be able to handle? The line shouldn't be a problem, I think it sits on a couple of 100 MB/s line. Well.. this is one topic I sorta specialize in. Off the bat you look like you have a machine that should be able to handle quite a load without barfing. The two areas I'd be interested in getting more metrics on would be your RAM utilization and a profile of your I/O to and from the disks where you have your tablespace. Without those metrics any advise I would give you is just crystal gazing. In the area of RAM I normally put as much RAM in a machine that can until it is can't take any more if I am running a database that is expected to deal with large queries or lots of small ones. Again, without some sort of metric to work with in terms of what your queries look like and what you actually mean by high traffic. Disk drives I like to put on some sort of RAID when I am thinking of either high throughput or a need for reliablity. Hot swap drives in a hardware raid box are the best way to go. IMHO and AFAIR Raid-5 is to be avoided for databases with a high degree of read-modify-write transactions built into the application or even just high write. With RAID-5 you pay a write penalty in terms of performance because of the fact that parity calculations take some overhead. The exception to this rule is where you have large caches front ending your RAID box. Even here there is cause for concern in the reliability arena as there have been known to be problems with data getting corrupted in a database when cache was not properly destaged after a write. I could on forever on this subject, but I'll stop here. -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ Peter L. Berghold[EMAIL PROTECTED] Schooner Technology ConsultingCELL: (732) 539-7920 Unix Professional Services: Sun/Solaris, Perl, Perl/CGI, mod_perl - 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