The writings of Merlin Moncure, professional database developer, about work, life, family, and everything else.

Friday, August 31, 2007

Dell md1000 bonnie++ benchmarks

Following are the results of our testing of the Dell MD1000 with two raid controllers (Perc 5/e). Server was dell 2950, 8gb ram. Pay close attention to the seeks figure, as this important figure for databases (the sequential rates are not all that important). We tried various combinations of software raid and hardware raid in both active/active and active passive configurations.

scroll
down
for
the
results!

:-)


























Sequential OutputSequential InputRandom
Seeks
DescriptionSize:Chunk SizeOutputRewriteInput
K/sec% CPUK/sec% CPUK/sec% CPUK/sec% CPUK/sec% CPU/ sec
single drive perc 5i ext2 wal16G566005320884903826444.9
dual controller 5 drive hardware raid 0 striped in software ext316G3617907517794833368836311115.2
singe controller 10 drive raid 0 hardware xfs16G4056024710953715510528341111.8
single controller 5 drive hardware raid 0 ext316G1624773411020319423957261062.0
dual controller 5 drive hardware raid 0 mirrored in software xfs16G2556603011053118379800321471.4
single controller 10 drive hardware raid 10 xfs16G2990393610469714402601271460.9
dual controller 10 drive hardware jbod software raid 0 xfs16G2430362512691316793798521081.5
dual controller 10 drive hardware jbod software raid 1016G244808279041012355593241509.9
RUN1 dual controller 5 drive raid 0 xfs separate volumes dual bonnie16G287469369540013423656311246.3
RUN216G291124371093731436703228755.4
RUN1 single controller 5 drive raid 0 xfs dual bonnie same volume16G140861215368381291449506.6
RUN216G137158216020691116468487.2
single controller 5 drive raid 5 xfs16G292219348342511262651171282.4
RUN 1 dual controller 2x4 drive hardware raid 516G24525931836471122956116767.0
RUN 216G248950327447210261117181025.7
dual controller 2x5 drive hardware raid 5 striped in software16G423363448040911195092121063.6
dual controller 2x5 drive hardware raid 5 mirrored in software16G409208265154759755375.0