…(as memcached does for example). Query Cache is also one of the few cache implementations which I’d call an Active Cache …MySQL Query Cache is most useful for complex expensive queries, for which tracking exact rows used from query syntax may be hard. Query Cache Storage Engines MySQL Query Cache…
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
…MySQL Query Cache is – I’ve seen number of people being confused, thinking MySQL Query Cache is the same as Oracle Query Cache – meaning cache where execution plans are cached. MySQL Query Cache… memcached has it) It is not distributed If you have 10 slaves and use query cache on all of them cache …
Post: Beware large Query_Cache sizes
March 23, 2007 By 3 Comments
… had number of consulting projects with MySQL Query Cache being source of serious problems. One would see queries both for MyISAM and Innodb tables… many cases you may want to disable query cache at all and use external cache such as memcached which does not have this problem. You also can cause invalidations to happen more regularly but this also should affect query cache…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
… my envinronment are: Cache Type Cache Gets/sec Array Cache 365000 APC Cache 98000 File Cache 27000 Memcached Cache (TCP/IP) 12200 MySQL Query Cache (TCP/IP) 9900 MySQL Query Cache (Unix Socket… to MySQL Query Cache – It performs faster than Query Cache if TCP/IP socket is used, but if Unix Socket is used to connect to MySQL MySQL Query Cache…
Post: MySQL caching methods and tips
April 4, 2011 By 4 Comments
… for MySQL. Popular cache methods The MySQL query cache When the query cache is enabled, MySQL examines each query to see if the contents have been stored in the query cache…. Use what you need Both Memcached and the MySQL query cache are limited in size. If you try to cache more information than you can…
Post: Cache Miss Storm
September 10, 2010 By 29 Comments
… observed was a cache miss storm – situation which can happen with memcache (as in this case) as well as with query cache. If you… than starting populating it. For MySQL Query Cache the solution should have been to make queries wait on first query started to complete. Unfortunately this…
Post: Caching techinques
August 8, 2006 By 11 Comments
… is caching data long term – ie if you got it from some Web Service. For smaller short lived objects things like memcached… often. Cache Invalidate With this apporach you invalidate or remove objects in cache once underlying information is updated. This is how MySQL Query Cache works by removing all queries derived from the table…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…. This is similar to storing the results of a query in Memcache. When the cache “expires”, the contents must be fully recalculated.. An… view, making it available for querying: mysql> call flexviews.enable( -> flexviews.get_id(‘demo’,'dashboard_customer_sales’)); Query OK, 0 rows affected (41…
Comment: Caching could be the last thing you want to do
July 26, 2010 By 14 Comments
… operating with empty cache. The behavior of application in such case often comes as surprise. Best test it. – Disable caching (memcache, mysql query cache etc) for development so you can see performance of uncached execution path. You need to test things with caching too…
Post: Beyond great cache hit ratio
May 19, 2010 By 2 Comments
… 90 memcache gets (hits) to retrieve some data plus there are 10 more requests which resulted in misses and caused MySQL queries. The… multiple pages and multiple users this will maximize cache efficiency while reduce amount of cache space required. The importance of this advice… to cache data together which invalidates in about same time. Multi-Get Multi Get is truly nuclear option for caching with memcached both…
