… have L2 cache on a database level, as an extension to InnoDB buffer pool. Fortunately, there is a project in progress Flash_Cache_For… on tpcc-mysql 2500W (250GB), I used data on RAID data on SSD (Intel SSD 910) data on RAID with L2 cache on Intel SSD 910, and size of cache is 150GB As we see the result…
Post: Level 2 Flash cache is there
April 27, 2010 By 5 Comments
… binaries for different platforms. And, I also see another idea implemented by David Jiang http://code.google.com/p/david-mysql-tools/wiki/innodb_secondary_buffer_pool, it allows to use a file on Flash partitions as L2 cache for InnoDB buffer pool. I see a lot of potential here, and I am going to evaluate it for including…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… any other caching for certain object or if you cache on different level (ie single object constructed from multiple query results) MySQL Query Cache may… layering may make sense. For example you might wish to use APC Cache as L1 cache and File cache as L2 cache if you have large…: 1) for file cache to work you need file named “test” containing “MyTestString” 2) You need to create table test.test for MySQL Cache to…
