…the benchmark. There was some discussion in the comments and I promised to follow up with more…test. All OS caches are dropped at this time as well. These set of queries were tested on…datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
…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 WhiteSpace and comments
March 20, 2008 By 9 Comments
Commenting on my previous post on MySQL Query Cache Gerry pokes me as I’m all wrong and both comments and whitespace are fixed in MySQL… comments Repeating queries from PHP instead we can learn the following about MySQL 5.0 Query Cache: Whitespace at the start of query does not block query…
Post: MySQL Query Cache
July 27, 2006 By 70 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…
Post: Caching techinques
August 8, 2006 By 11 Comments
… comments about Jays article. First – caching in files should be used with caution. It may be very efficient especially if number of cached… 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: 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: Distro Packages, Pre-built Binaries or Compile Your Own MySQL
September 4, 2012 By 7 Comments
… patches, need to alter MySQL‘s default behavior i.e. disabling and totally disallowing use of query cache or increasing maximum total number…, how do you prefer your MySQL server installed? UPDATE: Peter and Sergei suggested on the comments that 3rd party specialized repositories might…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…COMMENT=’Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql…query command, called pivot_results cd shard-query/ $ ./run_query < queries…
Post: Recall of Percona Server 5.1.47-11.0
June 29, 2010 By 10 Comments
… if query is starting from SEL or comment. After Query is parsed and executed MySQL stores results for SELECT queries in Query Cache. There are cases when queries will not be considered as cachable query…
Post: mk-query-digest, query comments and the query cache
…. You can enable query cache stripping in Percona Server at runtime: mysql> set global query_cache_strip_comments=’ON’; Query OK, 0 rows … query cache, but would like better instrumentation in your queries, consider using Percona Server and turning on the –strip-query-cache-comments feature. …