In doing some research on some high powered raid systems, I was wondering what would be faster given the following machine and workload. I have heard reports that sas is actully slower that u320. What about the 3ware car is 12 independent channels better that the faster drives and a 2 channel scsi raid? What would guve me the best performance overall (queries per sec)? What about price/performance?
Machine
Dual Intel Xeon 5160
16GB DDR2 667 ( 8 x 2GB)
Supermicro X7DAE
Workload
MySQL MaxDB 7.6.00.27
Gentoo Linux
Possible Raid Cards
3ware 9590SE-12ML (SATA)
LSI Logic MegaRAID SAS 8408E (SAS)
LSI Logic MegaRAID SCSI 320-2X (Ultra 320)
Possible Hard Drives
Seagate Cheetah 15K.5 146GB
Seagate Cheetah 10K.7 146GB
Western Digital Raptor 150 GB WD1500ADFD
Machine
Dual Intel Xeon 5160
16GB DDR2 667 ( 8 x 2GB)
Supermicro X7DAE
Workload
MySQL MaxDB 7.6.00.27
Gentoo Linux
Possible Raid Cards
3ware 9590SE-12ML (SATA)
LSI Logic MegaRAID SAS 8408E (SAS)
LSI Logic MegaRAID SCSI 320-2X (Ultra 320)
Possible Hard Drives
Seagate Cheetah 15K.5 146GB
Seagate Cheetah 10K.7 146GB
Western Digital Raptor 150 GB WD1500ADFD