Archive for the 'SSD' Category

Has anyone done any more work on recompiling InnoDB with 4k pages and benchmarking under SSD?
We’re building out a new DB that uses very small records (around 32-64 bytes) so reading a whole 16k for this record should have a performance difference.
I haven’t seen any benchmarks on 16k random read IOPS on the Intel [...]

Here’s the problem I currently have.
We’re looking at deploying the Intel X-25M MLC SSD in production.
The problem being that this drive has a lower number of erase cycles but is much cheaper. Than the Intel X-25E SLC drive.
However, in our situation we’re write once, read many. I’m 99% certain that we will [...]

The Sun Fishworks guys were nice enough to invite me for a demo of their new 7000 series storage device.
We bang the heck out of our IO systems here at Spinn3r so having more options is always welcome.
Bryan Cantrill, one of the original DTrace developers, worked on this bad boy so there’s obviously going to [...]

This makes two vendors shipping NAND on PCI-E …
Fusion IO has a competitor. Hopefully this leads to a price war.
Intel’s X-25 card looks pale by comparison.

EMC thinks that flash disks are going to replace HDDs in two years:
Dave Donatelli, a senior exec at EMC – the largest data storage vendor – predicted that high-end flash drives will replace high-end hard drives in 2 years. Is this the beginning of the end for disk drives?
Which had me thinking about the STEC [...]

When I started looking at SSDs I compared the various Mtron models and they have a 32GB drive (vs 64GB) that prices out at $15/GB.
That’s a sweet spot so I decided to go with that model.
Well now it looks like that specific model is being discontinued in favor of the higher end mode [...]

This seems interesting:
Flash memory has become the most important storage media in mobile devices, and is beginning to replace hard disks in desktop systems. However, its relatively poor random write performance may cause problems in the desktop environment, which has much more complicated requirements than mobile devices. While a RAM buffer has been quite successful [...]

Fully RAM based databases are being used in more and more places. For a lot of use cases throwing ALL of your data into memory will have a major performance benefit.
But when should you use RAM vs SSD?
RAM is about $100/GB. SSD is about $30/GB.
SSDs have a finite performance of about 100MB/s [...]

Benchmark Reviews has published details about the MemoRight GT and Mtron high performance SSDs.
Here’s what I can gather. The MemoRight is 2x more the price of the Mtron. $32 per GB vs $16 per GB. I’m looking at NeoStore’s pricing to compute these numbers.
However, the MemoRight is 20% faster for reads and [...]

Engadget is reporting even more enterprise SSDs hitting the market.
32 and 64GB capacities aren’t all that impressive when it comes to SATA II 2.5-inch solid state drives, but OCZ’s new devices do claim 120MBps read and 100MBps write speeds which would put it up there on the ranks. Unfortunately, OCZ neglected to clue anyone in [...]

I need to give it a bit more thought but it looks like we’re going forward with deploying Spinn3r on SSD. Specifically, machines with 3 SSDs on Linux software RAID.
The performance of SSDs is nothing short of astounding. When tuned correctly these drives were nearly 10x the performance of the same box running RAID. [...]

The other day I blogged about running RAID performance tests and being disappointed by random write speeds.
The clear loser here is rndwr (random writes). I’m pretty sure this has to with the 64k stripe/chunk size. I’m willing to be the RAID controller is deciding to write the entire chunk for small updates which would [...]

I just spend a few hours today setting up RAID on SSD to see what the performance boost would look like.
I’m very happy with the results but they’re not perfect.
Here’s the results from comparing a single Mtron SSD vs a RAID 0 array running with a 64k chunk size.

Figure 1: Mtron SSD performance advantages with [...]

It looks like Fusion IO has published more numbers about their SSD flash storage devices.
For starters, the price is totally reasonable. $2400 for an 80G device. This is $30/GB which puts it roughly 2x the price of the Mtron at $/GB. Not to bad.
The raw performance numbers seem amazing:

However, these can be [...]

Big DBA Head has run some independent MySQL benchmarks with the Mtron SSD drives that I’ve been playing with.
Great to see that we’re coming to the same conclusions. It’s nice to have your research validated.
Run time dropped from 1979 seconds on a single raptor drive to 379 Seconds on the standalone Mtron drive. [...]

I spent some more time today computing numbers on MyISAM thread scalability running on MyISAM.
This was JUST a random read test. No INSERTs, UPDATEs, or DELETEs.
I wanted to see if MyISAM could saturate the SSD to the point where it was faster than an all in memory InnoDB database running on a conventional HDD.
Some good [...]

I spent some more time today comparing InnoDB and MyISAM on SSD.
I increased the data/cache ratio by about 5X. I allocated 1G of memory for MyISAM or InnoDB (restating MySQL after each test). Resulting on disk images are 6G for MyISAM and 7G for InnoDB.
This is on a 30M row DB which stores [...]

Yesterday, HarrisonF noted in one of my comments that PBXT uses a log structure internally to represent its on disk format.
This prompted me to test it out to verify if it would boost performance of MySQL on SSD.
I’m somewhat impressed. Not blown away but this is very interesting.
Bulk inserting 1M rows into the DB [...]

I’ve been reviewing the random write performance with SSDs over the last few days and have a few updates on their performance numbers.
It turns out that SSDs themselves need to handle random write IO to obtain ideal performance numbers. Due to the erase block latency on NAND flash, performance can start to suffer when [...]

I’ve now had about 24 hours to play with the Mtron SSDs and had some time to benchmark them.
The good news is that the benchmarks look really solid. The drive is very competitive in terms of performance. I’m seeing about 100MB/s sequential read throughput and 80MB/s sequential write throughput.
I’ve had some time to [...]