…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: 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: 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
… use MySQL Command Line Client for any tests involving 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 VIEW as performance troublemaker
August 12, 2007 By 57 Comments
… and using MySQL VIEWs ? mysql> create view user_counts as select user_id,count(*) cnt from comments group by user_id; Query OK, 0… NULL ref: NULL rows: 1001 Extra: Using where; Using join cache *************************** 2. row *************************** id: 1 select_type: PRIMARY table: type: ALL…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
….004 cache size : 4096 KB 16GB of RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5… to show graphics with comments READ_PK_POINT Query: SELECT name FROM $tableName WHERE id = %d The very common query with access by… OS cache is not scaled. READ_KEY_POINT_LIMIT Query: SELECT name FROM $tableName WHERE country_id = %d LIMIT 5 The same query…
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: 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: mk-query-digest, query comments and the query cache
… is that MySQL treats identical queries with different comments as different queries. This essentially renders the query cache inoperative when this approach is taken. A cache that… 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 (0…