Thursday, October 23

Geek

I Know What I Want For Christmas

A few months ago, I wrote a quick note about the Fusion-IO ioDrive.  I said at the time:
80GB.  $2400.  9 watts. 120,000 IOPS.  600MB/second random writes.

If this thing really delivers, it's a silver bullet for mid-scale databases.  I want a silver bullet for mid-scale databases.
Now I've got one for testing at my day job.

But can it really do 120,000 IOPS?  Well, let's start with a 40GB random-write test.  Single threaded, with no optimisations.  And the envelope please...
random-write: (groupid=0, jobs=1): err= 0: pid=4626
  write: io=40,000MiB, bw=271MiB/s, iops=67,869, runt=150877msec
    clat (usec): min=4, max=37,767, avg=12.32, stdev=44.36
    bw (KiB/s) : min=    0, max=335749, per=99.90%, avg=277725.87, stdev=25273.96
  cpu          : usr=15.47%, sys=83.93%, ctx=5153, majf=1, minf=2152631
Whoa.

Okay, that's not 120,000.  But 67,000 without any tweaking at all is amazing.  I have the same test running on a standard SATA drive; it's sustaining a little over 300 IOPS, making the ioDrive easily 200 times faster.

I've got a lot more testing to do, but so far it looks like the ioDrive really delivers the goods.

Unfortunately, since June the Aussie dollar has drifted south by about 30% and I can no longer afford the card, at least not short of working every Sunday for two months.  But there are some cheaper, lower-end drives showing up, and I'd be very happy with a quarter of the ioDrive's performance for a quarter of the price.

Posted by: Pixy Misa at 01:23 PM | Comments (9) | Add Comment | Trackbacks (Suck)
Post contains 234 words, total size 2 kb.

1 Was it planned to hold the database entirely on the IO drive ?

That would be something. And using 9 watts !

Posted by: Andrew at Thursday, October 23 2008 03:52 PM (/uGTr)

2 Yep, that's what we're planning to do.  We might end up needing a 160GB card, or two 80GB cards striped together, but it's actually cheaper than a SCSI RAID array.

Posted by: Pixy Misa at Thursday, October 23 2008 04:00 PM (PiXy!)

3 And easier to manage than a SCSI raid array.

That alone is a plus.

Posted by: Andrew at Thursday, October 23 2008 05:04 PM (/uGTr)

4 How many PCIe slots does your server have?

Posted by: JV at Sunday, October 26 2008 10:24 AM (DpWT+)

5 THE ONLY THING YOU SHOULD WANT FOR CHRISTMAS IS EFFING SPIDERCIDE.

Dude....  smile




Posted by: The Brickmuppet at Sunday, October 26 2008 07:17 PM (73lWn)

6 Thanks Muppet.  May I e-mail my nightmares to you tonight?

Posted by: ubu at Thursday, October 30 2008 11:01 AM (ASksU)

7 Hi Pixy....Um....can I....I mean, may I ask for a Christmas present? I need help! I've been a very bad blogger, not updating stuff and junk, and now, there is so much spam that I have to close comments. Help for a wayward munu?

Posted by: Key at Sunday, November 02 2008 11:09 AM (EN2X1)

8 I'll see if I can do something about that, Key. smile

Posted by: Pixy Misa at Sunday, November 02 2008 04:02 PM (PiXy!)

9 Well, my first attempt blew up the server (or at least, pushed the load average up to 350), so I'll try doing something a little different there...

Posted by: Pixy Misa at Sunday, November 02 2008 05:03 PM (PiXy!)

Hide Comments | Add Comment

Comments are disabled. Post is locked.
45kb generated in CPU 0.1, elapsed 0.2651 seconds.
56 queries taking 0.1808 seconds, 272 records returned.
Powered by Minx 1.1.6c-pink.