…_DIRECT when I tested) might not be from PCI-e flash card (cached etc..). But it might be from LinkBench. The LinkBench…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… to enable vCache on the PCIe flash card (a Virident FlashMAX II) and set up the cache device with the command-line…, requires building a separate kernel module in addition to whatever flash memory driver you’ve already had to install, and then… “1″ to the do_sync sysctl of the cache device triggers a cache flush, but it happens in the background, and while…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
… are a lot faster than regular spinning disk, a PCIe flash card is still massively faster than an SSD, both in… slower (and more CPU-intensive under high load) than PCIe flash For example, see http://www.ssdperformanceblog.com/2013/04/testing… Facebook FlashCache. I’d never even heard of the STEC caching solution prior to your comment. Maybe another Perconian will have…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… used a PowerEdge R720 box with a fast PCI-e flash card as storage. By default linkbench dataset has 10M ids…=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0 #56only…
Comment: MySQL and Percona Server in LinkBench benchmark
May 15, 2013 By 18 Comments
Some PCI-e flash card (e.g. FusionIO’s) driver seems to use main memory as data cache as much as possible…
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: L2 cache for MySQL
October 25, 2012 By 13 Comments
The idea to use SSD/Flash as a cache is not new, and there are different solutions for this, … L2 cache on a database level, as an extension to InnoDB buffer pool. Fortunately, there is a project in progress Flash_Cache_For… Server 5.5.28 I think that naming this as Flash_Cache is confusing due similarity to Flashcache from Facebook, so I…
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 64 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…
