… it gets unusable. And obviously the SSD card based on MLC NAND has a limited lifetime. There is a lot of misconceptions… we write, and in such way to calculate the potential lifetime. This will be only partially correct. There is such factor…) (writes) Having this info let’s take look what a lifetime we can expect under a tpcc-mysql workload. I put…
Post: Effect of adaptive_flushing
December 4, 2009 By 5 Comments
… is using 2 SSD‘s for the ZIL and L2ARC, and as everyone should know by now, SSD‘s lifetime is determined by the number of writes they can perform before failure. This means that more writes per second == shorter lifetime, and so a shorter SSD lifetime is a negative side effect of enabling adaptive…
Comment: Adaptive flushing in MySQL 5.6 - cont
September 11, 2012 By 13 Comments
… priority one – that’s things like reduced writes to increase SSD lifetimes or free up I/O operations on spinning disks for…
Post: SLC vs MLC
July 14, 2010 By Leave a Comment
… it is much easier to implement. This problem with handling lifetime and manage write cycle for MLC opened way for hardware… have the same lifetime as SLC 160GB cards. On this way interesting to see Intel announces enterprise line for SSD card will be based on eMLC ( enterprise MLC ), where each cell has 30,000 writes lifetime and with…
Comment: Measuring the amount of writes in InnoDB redo logs
October 8, 2012 By 4 Comments
… with SSDs who want to improve their drive lifetime should pay particular attention to this, ensuring that they optimise for lifetime with nice…
Comment: Review of Virident FlashMAX MLC cards
March 1, 2012 By 14 Comments
Sergey, I had a post on this topic http://www.mysqlperformanceblog.com/2011/11/15/mlc-ssd-card-lifetime-and-write-amplification/
Post: FlashCache: tpcc workload with FusionIO card as cache
June 2, 2010 By 20 Comments
This run is very similar what I had on Intel SSD X25-M card, but now I use FusionIO 80GB SLC… FlashCache for both reading and writing to/from disks, so lifetime could be short). Also Facebook team released WriteThrough module for…
