I found the article very interesting. It seems they couldn't trash
3ware cards enough.
We swear by 3ware cards -- other than the PCIX riser card issue, we
haven't a single problem with them. Our production database server is
running off of a RAID1 for the OS and a RAID10 for the data and every
time we are doing schema maintenance or database migration, we are
blown away by the speed of the machine.
BTW, never use Western Digital Raptor drives. Some people may
remember me posting about them around October. Out of 6 drives in the
machine, we've had 10 failures. We're currently replacing the drives
with Seagates. We'll take the 3K RPM hit for piece of mind.
On Wed, 9 Mar 2005 17:04:54 +1100, Richard Dale <richard@stripped> wrote:
> Tweakers.net has completed a comparison of 9 serial ATA RAID 0/1/5/10
> controllers at:
> There is a specific section on MySQL performance in the section:
> Just thought these articles would be of interest to some (it's interesting
> to see the difference between single drive operations and multiple drive
> operations - up to 12 drives, with the different RAID levels).
> Here's my rough speed comparison based upon eyeballing the graphs. Some
> controllers were better than others so this represents a rough average of
> the entire set of controllers:
> Single drive - 1.0
> RAID 1 - 2 disks - 1.4
> RAID5 - 3 disks - 1.7
> RAID5 - 4 disks - 2.0
> RAID10 - 4 disks - 2.0
> RAID5 - 6 disks - 2.3
> RAID5 - 8 disks - 2.4
> RAID5 - 10 disks - 2.9
> RAID5 - 12 disks - 3.1
> The article also highlighted the difference between the reliable
> write-through mode and the write-back mode. In write-through mode,
> performance is degraded by approximately 50%. Clearly if you want
> reliability, a controller with a battery backup is highly recommended.
> On the issue of SCSI version SATA performance, it would appear that SCSI
> still performas somewhat better (about 20% more transactions but the test
> was comparing 15K RPM SCSI drives to 10K RPM SATA drives) but the reduced
> cost of SATA drives allows you to add more drives to achieve the same
> performance levels at lesser cost. With Serial ATA II drives around the
> corner (with Native Command Queueing) then I think we'll find SATA will take
> a much bigger lead in database performance.
> Really nice work from tweakers.net - would have been interesting to see the
> Linux performance too though.
> Best regards,
> Richard Dale.
> Norgate Investor Services
> - Premium quality Stock, Futures and Foreign Exchange Data for
> markets in Australia, Asia, Canada, Europe, UK & USA -
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1