… = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer… then that, I have also disabled query cache to avoid contention caused by query cache on write heavy workload. OK, so that… reduce chances of log flush storms and disabling the query cache.
Post: New distribution of random generator for sysbench - Zipf
May 9, 2012 By 3 Comments
… also does not allow effectively test caching solution, each row can be equally put into cache or removed. That’s why there… percentage of rows, which makes this distribution good to test cache, but it is hard to emulate high IO load. That…
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
May 1, 2012 By 10 Comments
… of the configuration go for example default_storage_engine, query_cache_size, e.t.c…. Is it something built in or…
Comment: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 27, 2012 By 10 Comments
… these issues are related to the GC or the internal cache issue..
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… wild guess about drops – the drive periodically cleans an internal cache or something. To understand better what kind of response time…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… the dataset does not fit into memory or if the caches are not warm, this also does not take into account… Factor of 2 (InnoDB dataset size ~5G). Note that query cache is disabled during these benchmark runs and that the disks…’ optimizer_switch=’join_cache_incremental=on’ optimizer_switch=’join_cache_hashed=on’ optimizer_switch=’join_cache_bka=on’ join_cache_level=8 join_buffer…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… might see instead is flushing tables regularly or reducing table cache reduces memory consumption to be withing the reason. Connection Related…) Adaptive hash index 4422068288 (2039977928 + 2382090360) Page hash 127499384 Dictionary cache 512619219 (509995888 + 2623331) File system 294352 (82672 + 211680) Lock system…
Comment: Too many connections? No problem!
March 15, 2012 By 28 Comments
… log-queries-not-using-indexes query_cache_type=1 query_cache_size=32M thread_cache_size=30 table_cache=4096 join_buffer_size=6M…
Comment: MySQL Query Cache
March 21, 2012 By 69 Comments
… that contains multiple joins with four tables uses “checking query cache” state even though the SQL SELECT statement does not contain SQL_CACHE in the begining. The strange thing is that it only…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
