… don’t miss this conference! Secondly, remember that our support contracts cover MariaDB as a first-class member of the MySQL family… Faster queries through speedier joins, faster subqueries, and elimination of useless tables in joins Thread pooling and a segmented key cache for improved scalability That’s really just a sampling. A good starting point for learning more is the MySQL versus…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… as 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… take significant hit for misses. This is especially the problem for very expensive queries. The good thing about MySQL Query Cache is it knows exactly…
Post: Return of the Query Cache, win a Percona Live ticket
August 26, 2011 By 4 Comments
… Live London ticket! But first, what’s new with the MySQL query cache? You may know that it still has the same fundamental… that’s gone. As of MySQL 5.5, the query cache mutex isn’t hit at all if query_cache_type is zero. We made…, now you get a screen full of query cache locks. It makes it impossible to miss serious contention when it happens. For example…
Post: MySQL Query Cache WhiteSpace and comments
March 20, 2008 By 9 Comments
… post on MySQL Query Cache Gerry pokes me as I’m all wrong and both comments and whitespace are fixed in MySQL 5.0… change whitespace a bit (see the last query has space after comment deleted) it causes query cache miss. If we look at process list output we can see the comments are actually skipped: | 798009298 | root | localhost | test | Query…
Post: Cache Miss Storm
September 10, 2010 By 29 Comments
… carefully watch frequently accessed cache items as well as cache items which take long to generate in case of cache miss. To find first… 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: 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… expensive queries very well may be the ones you have to run when the cache is empty. When talking about cache, the miss path…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… MySQL manual, especially the option and…query_alloc_block_sizeblogpercona.commanual query_cache_limitblogpercona.commanual query_cache_min_res_unitblogpercona.commanual query_cache_sizeblogpercona.commanual query_cache_typeblogpercona.commanual query_cache_wlock_invalidateblogpercona.commanual query…
Post: Caching techinques
August 8, 2006 By 11 Comments
… 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… of cache misses, while it also wastes resources by updating what might never be needed again. Another complication for this approach is – cache…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… to attack the right query in the right way. But vanilla MySQL does have its limitations, … as information about the queries‘ execution plan (which includes things like whether Query cache was used or not…query_time=0, because if you set it to some other value say 0.1 seconds, it will miss all queries…
Post: mk-query-digest, query comments and the query cache
… 1000 misses and then all hits from this test. You can enable query cache stripping in Percona Server at runtime: mysql> set global query_cache_strip_comments=’ON’; Query OK, 0 rows affected…