Knowledgebase
Portal Home > Knowledgebase > Articles Database > SQL on SSD?
SQL on SSD?
Posted by fog, 02-25-2008, 12:35 AM Has anyone here ever tried running MySQL on a solid-state drive? I'm writing an Intranet application that seems like the perfect use case for one--this thing won't need a lot of throughput, but it's going to be doing involved searches all over the database, making seek times relatively important. Obviously, gobs of RAM would be the best solution. But lacking that, I wonder if anyone has actually tried solid-state for an SQL server? Am I expecting too much? (My installation won't use more than a couple gigs of space, and isn't moving major traffic... I'm aware that SSD would be a terrible solution if I wanted to, say, host WHT.)
Posted by wKkaY, 02-25-2008, 01:19 AM I don't have experience MySQL on SSDs, but I was googling about a month ago about it. From what I gather, random read IOPS are very very fast, but random writes IOPS on the other hand are appalling. This is due to the block erase-write cycle process of SSD writes. If your application is read-heavy (mine wasn't), then it could be a good solution for you Apparently though there's patented technology that brings random write performance up to par by using journaled writes.. something to watch out for in the future.
Add to Favourites 
Print this Article
Also Read
