Innodb RAID performance on 5.1

Submitted by jay on July 22, 2008 - 8:13am

I've been doing some benchmarking recently to satisfy the curiosity about 5.1's performance compared with 4.1.  The major question this time revolves around how much additional performance an external RAID array can provide (for us it's typically beyond the 6 drives a Dell 2950 can hold). 

These tests are done on using an MSA-30 drive enclosure with 15k-SCSI drives.  The testing framework is sysbench oltp.  The test names are hopefully fairly obvious:  selects = single selects, reads = range tests, xacts = transaction tests, etc.   Transaction tests are counting individual queries, not transactions.   The "Rdm" tests are using a uniform distribution, whereas the non-'Rdm' tests are 75% of queries are using 10% of the rows.  

Here are the results:
It's always hard, of course, to see what these numbers would look like on a real production database.  The numbers for the select queries look pretty decent, but a real database probably wouldn't just be doing those all day.  It seems clear that a lot of writes into the db will limit the I/O scalability pretty quickly, which shouldn't really be a big surprise.  

UPDATE:  I'm pretty sure these results are skewed by sysbench having it's own set of bottlenecks.

Trackback URL for this post:

One question, which always

One question, which always warrants more benchmarking is how Linux co-oeprates with the external RAID device with respect to scheduling. I'd like to see numbers based on the different types of schedulers. Also, what filesystem was used in this test?

jay's picture

Yeah, I've found good

Yeah, I've found good benchmarking tends to lead to more benchmarking. (Just like a good Science experiement answers some questions, but reveals more).

I'll double check, but I believe this test is using the deadline scheduler.  The filesystem is ext3.  The MSA-30 in this test is plugged into the second channel of the same RAID card doing the internal RAID... I wouldn't expect it to perform much differently as a result of that.  Oh, and battery-backed write cache is enabled.

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.

More information about formatting options

Mollom CAPTCHA (play audio CAPTCHA)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.


Comment abuse is not tolerated on this site, besides all the comments are moderated, so don't bother posting comments that are not on topic, only for increasing the SEO of your site, or are outright spam.  If you've got something intelligent to contribute, by all means, post a link to your blog.  

About Me

Jay Janssen
Yahoo!, Inc.
jayj at yahoo dash inc dot com
High Availability
Global Load Balancing
View Jay Janssen on Twitter  View Jay Janssen's LinkedIn profile View Jay Janssen's Facebook profile