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 Consulting CELL: (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
