June 19, 2013

Post: Heikki Tuuri answers to Innodb questions, Part II

… file group and the SSD dynamic wear leveling algorithm. I’m also wondering if you would recommend using SSD for this purpose, and… writes themselves are much more a problem to the SDD wear leveling: if you commit 1000 transactions per second, then you write 1000 times per second! A smart wear leveling should be able to cope with writes to the…

Comment: FusionIO 320GB MLC benchmarks

These two sites have gobs of information about SSDs: — SSD news and history (some test reporting) http://www.storagesearch.com/ — ….com/storage/showdoc.aspx?i=3667&p=1 Points about SSD; – NAND is commodity; Samsung parts are good, others maybe less… (STEC, Texas, Fusion-io, and the like) have controllers which wear level the NAND such that one can write gigabytes/day…

Comment: Heikki Tuuri to answer your in depth Innodb questions

… file group and the SSD dynamic wear leveling algorithm. I’m also wondering if you would recommend using SSD for this purpose, and…

Comment: Why delayed flushing can result in less work

… well as SSDs (which also “cost” you per IO as more writes you do the more quickly it will wear out) may…

Comment: RAID vs SSD vs FusionIO

… memory for garbage collection, write coalescing, wear leveling, mapping”. So in other words, using SSD drives with a good RAID controller is…