…query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer pool is sized…performance. Other then that, I have also disabled query cache to avoid contention caused by query cache…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…) with a Scale Factor of 2 (InnoDB dataset size ~5G). Note that query cache is disabled during these benchmark runs and that the… that, just increasing the join_buffer_size is not going to provide the best possible query performance. As I mentioned at the start… or MySQL, but you need to appropriately increase read_rnd_buffer_size/mrr_buffer_size because these have an impact on MRR performance, and…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… case of MySQL 5.5 and ~5 hours in case of MySQL 5.6 and MariaDB 5.5. Note that query cache is disabled… performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer_size… not actually mean that queries with MRR are performing badly. The interesting thing is that though both MariaDB and MySQL 5.6 are…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…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: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…) CPU L5335 @ 2.00GHz stepping : 11 cpu MHz : 1995.022 cache size : 4096 KB physical id : 1 siblings : 4 core id : 3… about the CPU, such as the model number and the cache size, etc. What else is important is the ‘lm’ flag, which… a high-performance system is virtually every query.) If it’s not possible to use a patched binary, we can use MySQL Proxy…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
…, with powerful hardware and heavy query workloads. Both have a key_buffer_size of 4GB. Now can you … in MySQL to guide your decisions. It is also not the be-all and end-all of MySQL performance, … expensive than hits, then you care about cache misses, not cache hits. A Key_read is not guaranteed …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… about how Shard-Query will perform on each database. To do the size comparison, I used the du utility: InnoDB file size on disk… table-definition-cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…size = 2M sort_buffer_size = 32k thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql…log for a little bit lless of performance. innodb_thread_concurrency = 0 Good! So Innodb performed best in this workload without …
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…_size, innodb_log_buffer_size, query_cache_size. If you’re using MyISAM seriously you can also add the size of Operation System cache you would like MySQL… will perform complex operations such as full table scans, sorts, or need temporary tables as much as read_buffer_size, sort_buffer_size…
