OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: Solid State Drives and mySQL / RDBMS?

From: Jujitsu Lizard (jujitsu.lizardgmail.com)
Date: Sat Feb 07 2009 - 22:03:28 CST


On Fri, Feb 6, 2009 at 5:53 PM, Daevid Vincent <daeviddaevid.com> wrote:

> While SSD's (Solid State Disks) have traditionally not been the best
> hardware to use for rewrite-intensive operations like databases, over
> the last few months, some leading Linux kernel engineers have been
> raving about next generation Intel SSD's that are close to 20x faster
> than the fastest disk drives for random access. If robust enough, these
> next generation SSD's may greatly improve relational database
> performance.
>
You are confusing me here. What is an SSD by your definition? (I'll be on
Wikipedia right after I make this post.)

If you mean a purely RAM-based device, it should work fine with great
performance.

If you mean a FLASH/EEPROM-based device, you might have a RAM front end to
it, but there would be limits to how much data you can change how quickly.

What is your definition of an SSD?

Got a typical manufacturer and model number?