Only a little over a week before the User conference and I am still burning the midnight oil to get as much information for my presentations as possible. I thought I would tease you a bit here. What do you get when you put 4 Intel X-25E’s ( Sun branded) SSD’s running RAID10 in a Sun 4450 and run the sysbench fileio test on it?
|
NO CTL, NO DRIVE Hardware |
NO CTL, W DRIVE Hardware |
W CTL, NO DRIVE Hardware |
W CTL, W DRIVE Hardware |
NO CTL, NO DRIVE Software |
|
| 50% Reads | 3449.25 | 7744.36 | 2585.44 | 8656.63 | 3714.53 |
| 67% Reads | 4460.67 | 8696.23 | 4169.18 | 9325.29 | 4646.03 |
| 75% Reads | 5538.94 | 10016.72 | 5233.61 | 9942.23 | 5930.73 |
| 80% Reads | 6886.81 | 12385.5 | 6194.27 | 10260.07 | 7378.55 |
| 83% Reads | 7067.62 | 12895.92 | 6958.61 | 10247.36 | 7911.37 |
| 100% Reads | 16608.69 | 16438.89 | 10814.62 | 11064.44 | 18050.14 |
| 100% Writes | 1983.76 | 6469.18 | 1904.77 | 4328.93 | 1939.74 |
*NO CTL or W CTL : No controller cache, or with controller cache
*NO DRIVE or W DRIVE : No onboard drive cache, or with drive cache
What does this mean? What about RAID 5 Numbers? What about actual MySQL Results? Come and see me talk about it in a week! Or wait for the post UC cliff notes if you can not attend. You know this is just a teaser:) Get this and more if you come and listen to me drone on and on about SSD’s! I will say this… A client I work with has a 16 disk raid 10 array ( 10K disks ) with 2GB of cache that scores around 2500 Requests per second in all of the above tests… just giving you some food for thought.
** Server has a Adaptec RAID Card with 256MB of battery backed cache. OS was Redhat 5.3, ext3 … 64K Stripe size
W CTL, NO DRIVE is the one I’m looking at
*sigh*
Why your better off with no ctl or no drive cache…
Whats the file system ?
http://venublog.com/2009/03/12/ssd-peformance-with-different-file-systems/
Have you thought about trying other file-systems as well? Or even some mount-time options (noatime, journal=writeback, etc.)?
a couple of things… i should say come to my presentation and see:) But no I have not tested with other FS… or even other options yet… trust me when I say their have been extenuating circumstances thus for which have limited my ability to test all the combination possible. So I have been testing stripe size, raid level, cache setting, hardware -v- software, etc… I have not had time to grab xfs and compile it, i could however try ext2 fairly easy.