… any server-grade SSD, and at Micron’s request, I recently took some time to put the card through its paces, and… peak capacity somewhere between 32 and 64 threads, and synchronous write tops out somewhere between 64 and 128 threads. The latency… MySQL? Exact results vary, depending upon the usual factors (read/write ratio, working set size, buffer pool size, etc.) but overall…
Post: Looking for RAID Controller without Battery Learning problems ?
January 5, 2012 By 11 Comments
… connections they provide. Some Newer Adaptec Controllers also offer using SSD as a cache with technology called MaxIQ. Namely Adaptec 5805ZQ… setting : Disabled MaxIQ cache setting : Disabled Write-cache mode : Enabled (write-back) Write-cache setting : Enabled (write-back) when protected by battery/ZMM Partitioned… to have as you want to ensure it goes to write through mode if ZMM fails. If you have any experience with…
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… on FusionIO in 20% dirty page, 80% dirty pages and write-through modes. I used full 80GB for caching ( total size of… to RAID). Write-through mode is about 2x gain, but remember that load is very write intensive and all benefits in write-through mode come…
Comment: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
…), or with controler configured for write-through, or with a cheaper controler, and perhaps with a more write costly RAID discipline (ie. RAID 5). A setup with storage accessible through multiple LUNs and/or multiple…, results may be even more favouring noop if you used SSD drives. I mean, chances are that those results are somehow…
Comment: FlashCache: more benchmarks
May 19, 2010 By 15 Comments
… Cache and checking if database recover completely ? Also is there write through mode available ? I believe for some workloads it will be… a lot safer. It also would allow to use single SSD for the cache more or less safely as in writeback…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… interaction between these always occurring writes to the first file in the log file group and the SSD dynamic wear leveling algorithm… I think Log files is not something SSD can give the main benefit to – writes to log files are small and sequential… searches/s HT: Strange, primary key equality searches should work through the adaptive hash index! What is your database like? Do…
Comment: Benchmarks of new innodb_flush_neighbor_pages
July 3, 2012 By 8 Comments
…scale-inserts.html [Quote] “However, you can reach better through put (inserts per second) with less threads. So …threads to 10-10 sessions, the problem disappeared!” “Also writing the redo logs, binary logs, data files in … was recommended for ext4. If they made an SSD as fast as Ram or if one was …
Comment: MLC SSD card lifetime and write amplification
November 15, 2011 By 8 Comments
…, Edmar In my above post the formatting didn’t come through. But the key things you may want to focus on…. Remaining Life : 99.60% 4. Writes as mentioned by Vadim. As you may already know all SSDs come with over provisioning. As… definitely possible to use the card after EOL of warrantied writes, specially if the application is read mostly. TWe have another…
Comment: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… worded, so no surprise it was confusing. As for the SSDs, I’ve been wondering for a few years now if… optimized for an SSD makes sense. A lot of the nasty complexity and tricks that modern databases go through is all designed… sure there are subltties I’m not thinking through well like whole cell writes and whatnot, but it does strike me as…
Comment: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… worded, so no surprise it was confusing. As for the SSDs, I’ve been wondering for a few years now if… optimized for an SSD makes sense. A lot of the nasty complexity and tricks that modern databases go through is all designed… sure there are subltties I’m not thinking through well like whole cell writes and whatnot, but it does strike me as…
