Re: RAM-usage and hardware upgrade >10gb RAM

2004-07-23 Thread Jan Kirchhoff
David Griffiths wrote: We just put a new dual-Opteron server into our production environment. We ordered a Megaraid SCSI card and five 10k drives, and a 3Ware Escalade SATA card with six 7200 RPM drives (Maxtor) to see which ones were best. Our network guy did a bunch of benchmarking on the dri

Re: RAM-usage and hardware upgrade >10gb RAM

2004-07-20 Thread Marc Slemko
On Mon, 19 Jul 2004 18:13:36 +0200, Jan Kirchhoff <[EMAIL PROTECTED]> wrote: > Hi, > > We are currently using a 4.0.16-replication-setup (debian-linux, kernel > 2.4.21, xfs) of two 2.4ghz Intel-Pentium4 systems with 3gig RAM each > and SCSI-Hardware-Raid, connected via gigabit-ethernet. We are re

Re: RAM-usage and hardware upgrade >10gb RAM

2004-07-20 Thread David Griffiths
We just put a new dual-Opteron server into our production environment. We ordered a Megaraid SCSI card and five 10k drives, and a 3Ware Escalade SATA card with six 7200 RPM drives (Maxtor) to see which ones were best. Our network guy did a bunch of benchmarking on the drives and found that SCS

Re: RAM-usage and hardware upgrade >10gb RAM

2004-07-20 Thread Brent Baisley
The single biggest difference between SATA (or any IDE) and SCSI is command queuing. Command queuing allows the drive to intelligently reorder reads and writes to make things faster. An ATA drive executes a bunch of commands in the order it gets them, which can be slow if it needs to write data

Re: RAM-usage and hardware upgrade >10gb RAM

2004-07-20 Thread Jan Kirchhoff
Egor Egorov wrote: Money is not really an issue but of course we don't want to waste it for scsi-hardware if we can reach almost the same speed with hardware sata-raids. 'Almost' is a key word. Some SCSI disk are working at 15k RPM, which will give you a HUGE MySQL performance growth compare

Re: RAM-usage and hardware upgrade >10gb RAM

2004-07-20 Thread Egor Egorov
Jan Kirchhoff <[EMAIL PROTECTED]> wrote: > Money is not really an issue but of course we don't want to waste it for > scsi-hardware if we can reach almost the same speed with hardware > sata-raids. 'Almost' is a key word. Some SCSI disk are working at 15k RPM, which will give you a HUGE MySQL p

RAM-usage and hardware upgrade >10gb RAM

2004-07-19 Thread Jan Kirchhoff
Hi, We are currently using a 4.0.16-replication-setup (debian-linux, kernel 2.4.21, xfs) of two 2.4ghz Intel-Pentium4 systems with 3gig RAM each and SCSI-Hardware-Raid, connected via gigabit-ethernet. We are reaching the limit of those systems and are going to buy new hardware as well as upgra