… second, other ‘innocuous’ queries which perform small insert or updates into completely different table (unrelated to the select query) also get hang up… the query cache by set global query_cache_size = 0; All this on a fairly decent size server where I have 6GB innodb_buffer_pool_size split…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… the importance of performance at low concurrency. The SSB The SSB tests a database’s ability to optimize queries for a star… the queries in Flight #3 that are faster using MyISAM, Q4.3 examines very little data. It seems that InnoDB performs better…_hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size=8M default_tmp_storage…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…shows the most consistent performance. The others all have assorted performance drops scattered throughout the…cache = 10240 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…, and projected InnoDB performance on this size will be the same or worse, but will require 1TB in size. Now to…cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance…_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0 #56only loose-innodb_flush…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group…_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0 warmup To warmup server and load data and indices to the buffer pool we use following queries…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
…_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer pool is sized at 55G and I am… cause downward spikes in performance. Other then that, I have also disabled query cache to avoid contention caused by query cache on write heavy workload…
Post: Write contentions on the query cache
September 5, 2012 By 5 Comments
…, requiring the cache to be locked! More specifically, the size of the blocks is set by the value of the query_cache_min_res… of the cache and degrade performance for other queries. The best solution was simply to turn off the query cache. Conclusions: Once again, the query cache revealed…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… Pipes continues cache experiements and has compared performance of MySQL Query Cache and File Cache. Jay uses Apache Benchmark to compare full full stack, cached or… cache usage efficiency larger object size and other reason. So what my test does ? Simply we perform 10.000 of get requests from cache… Query Cache – It performs faster than Query Cache if TCP/IP socket is used, but if Unix Socket is used to connect to MySQL MySQL Query Cache…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
… – we’ve seen performance issues with large query_cache_size also sort_buffer_size and read_buffer_size may not give you better performance if you increase… well cached so the cost of table cache miss is not very high, you may be better of with significantly reduced table cache size…
