I personally like PCIe based Flash, but from a pricing point our customers are looking for … threads): It seems that InnoDB is not alone with its flashing problems. You can see there periodical stalls in throughput (0… wild guess about drops – the drive periodically cleans an internal cache or something. To understand better what kind of response time…
Post: Level 2 Flash cache is there
April 27, 2010 By 5 Comments
… using Flash storage in Level 2 caching level. The price-capacity trade-off makes Flash as the very good fit for a cache layer… allows to use Flash as cache in front of regular hard drives. The implementation is based on dm-cache and introduces a new…_buffer_pool, it allows to use a file on Flash partitions as L2 cache for InnoDB buffer pool. I see a lot…
Post: Battery Learning still problem many years after
February 10, 2011 By 7 Comments
… instead and bundle 512MB cache with 512MB of Flash so when power goes down the cache is stored on Flash ? Or can’t one put batteries which can be moved independently ? It looks like H800 has “transportable non volatile cache… this is something where Facebook Flash Cache can be helpful – if it can act instead of hardware BBU cache. Would be interesting to…
Comment: FlashCache: more benchmarks
May 19, 2010 By 15 Comments
… Durability the Flash itself is not the only moving part – it is a good question whenever all changes to the cache become immediately durable. Did you try shutting off power while under load with Flash Cache and checking if… allow to use single SSD for the cache more or less safely as in writeback cache this is effectively as running on…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… think about Core idea of the MySQL Query Cache – it is great. The transparent cache which does not require any extra handling… used from query syntax may be hard. Query Cache Storage Engines MySQL Query Cache now stores queries in local memory, which is… one to use local memory, Memcache or for example local flash storage for storage. Compression You can see it as a…
Comment: Battery Learning still problem many years after
February 11, 2011 By 7 Comments
HP also has a flash-cache solution in their newer controllers I believe. I agree with … lack of multiple battery support, or an alternative option (capacitor + flash sounds like a neat idea) for a while. It’s…
Comment: FlashCache: tpcc workload
May 29, 2010 By 18 Comments
… indexes and have been debating using the second one for flash cache or to house MySQL directly. Our data set is about… currently. It looks like using the second drive as a cache might be the way to go. Was the setup difficult…
Comment: FlashCache: more benchmarks
May 19, 2010 By 15 Comments
oh, and also, I think that ‘special’ is flawed, as 1% will go to buffer pool, not flash cache. you need to test with distributions that have curved properties, as the middle part of the curve is what flashcache targets.
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… is why to use a flash memory at all, when a battery-backed disk controller write-back cache does the same thing. PZ: First Indeed writes are slower with Flash disks compared to Reads because Flash requires “erase… of 100MB/sec or more. This cache is DRAM based and so much faster than Flash. SSD Drives would be big win…
Post: Looking for RAID Controller without Battery Learning problems ?
January 5, 2012 By 7 Comments
… in this PDF ZMCP (Zero-Maintenance Cache Protection) does not use battery but instead Capacitor plus flash. Capacitor provides enough energy for… : 5.2-0 (18252) Driver : 1.1-5 (24702) Boot Flash : 5.2-0 (18252) ——————————————————– Controller ZMM Information ——————————————————– Status : ZMM Optimal…
