posted Sep 10, 2010, 10:13 PM by Ricardo Fonseca
[
updated Sep 15, 2010, 1:14 PM
]
(RAID 5 vs RAID 1E vs RAID 10 )
Every-time, as a consultant DBA, a customer ask me the question which
RAID and why will fit best their needs. I tend to provide my
experiences, my ideas and share but rarely it's enough.
In this blog entry I will try show exactly for one specific machine
what will be the efficiency for each and individual RAID setup in terms
of rough IO/S and MB/s.
Note that the tool that I have used is SQLIO, in a near future I plan
to also re-do the tests with the tool Iometer. What is important to
know is that the situation when I did the tests was ideal. The Raid
Setup had been done then re-done according to the needs and there were
no application and no user connected to the server during the tests.
The server used is a IBM x336 series with 16GB of RAM, windows 2003 x64
installed. The setup raid was local to the machine, the cache
controller was integrated to the machine and its size was 256MB.
Following is the legend table to help you to interpret the different
test cases scenario therefore will you find all the detail of each
scenario that has been tested :
Test Case | threads# | Block Size (KB) | Out. Request | Duration |
T1 | 2 | 64 | 1 | 120 seconds |
T2 | 2 | 64 | 2 | 120 seconds |
T3 | 2 | 64 | 4 | 120 seconds |
T4 | 2 | 64 | 8 | 120 seconds |
T5 | 2 | 64 | 16 | 120 seconds |
T6 | 2 | 64 | 32 | 120 seconds |
T7 | 2 | 64 | 64 | 120 seconds |
T8 | 2 | 64 | 128 | 120 seconds |
A. Result extracted for write performance :
|
|
| T1 | T2 | T3 | T4 | T5 | T6 | T7 | T8 |
1 | RAID5 - 4HD;145G;15k - | MB/S | 19.06 | 21.81 | 25.20 | 39.92 | 46.08 | 46.04 | 46.64 | 46.82 |
| RAID5 - 4HD;145G;15k - | IO/S | 305.02 | 349.08 | 408.14 | 638.73 | 737.38 | 736.64 | 746.35 | 749.15 |
2 | RAID1E - 4HD;300G;10k - | MB/S | 13.65 | 15.01 | 15.29 | 15.54 | 15.48 | 15.49 | 15.27 | 15.55 |
| RAID1E - 4HD;300G;10k - | IO/S | 218.40 | 240.30 | 244.76 | 248.76 | 247.72 | 247.91 | 244.35 | 248.95 |
3 | RAID10 - 4HD;300G;10k - | MB/S | 22.05 | 27.08 | 33.91 | 57.42 | 73.12 | 74.57 | 74.44 | 73.93 |
| RAID10 - 4HD;300G;10k - | IO/S | 352.91 | 433.41 | 542.56 | 918.76 | 1169.92 | 1193.24 | 1191.07 | 1182.93 |
B. Result extracted for write performance :
|
|
| T1 | T2 | T3 | T4 | T5 | T6 | T7 | T8 |
1 | RAID5 - 4HD;145G;15k | MB/S | 12.35 | 12.17 | 12.39 | 12.37 | 12.38 | 12.46 | 12.54 | 12.61 |
| RAID5 - 4HD;145G;15k | IO/S | 197.69 | 194.78 | 198.24 | 198.07 | 198.09 | 199.46 | 200.67 | 201.8 |
2 | RAID1E - 4HD;300G;10k | MB/S | 8.42 | 8.28 | 8.25 | 8.41 | 8.49 | 8.34 | 8.39 | 8.3 |
| RAID1E - 4HD;300G;10k | IO/S | 134.80 | 132.59 | 132.03 | 134.63 | 135.84 | 133.56 | 134.27 | 132.85 |
3 | RAID10 - 4HD;300G;10k | MB/S | 16.64 | 16.58 | 16.70 | 16.49 | 16.55 | 16.56 | 16.72 | 16.76 |
| RAID10 - 4HD;300G;10k | IO/S | 266.36 | 265.36 | 267.35 | 263.97 | 264.81 | 265.09 | 267.56 | 268.18 |
Result : As for the
interpretation of the output we can clearly see that setup in RAID 10
is far the most efficient in regards our tests scenarios. For read and
write instructions it has demonstraste to be faster quite significantly
and that even though in the RAID5 setup we had 15k drive rather than
the 10k when setup in RAID10. |
|