… All OS caches are dropped at this time as well. These set of queries were tested…performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance…/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…bounds case 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_…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…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
…performance on this size will be the same or worse, but will require 1TB in size…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: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M …max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0 warmup To …percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp…
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: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…data/dpe0 | | TABLE_DEFINITION_CACHE | 400 | 1400 | | PORT | 5530 | 5610 | | QUERY_CACHE_TYPE | ON | OFF | | REPORT_PORT | 5530 | 5610 | | PERFORMANCE_SCHEMA_MAX_FILE_…in MySQL 5.5 and before it was “ON” by default with query cache size of 0 which makes it disabled. I wish query_cache_size though…
Post: Write contentions on the query cache
September 5, 2012 By 5 Comments
…MySQL need so many accesses to the query cache lock? The answer is in the way the query cache…cache and degrade performance for other queries. The best solution was simply to turn off the query cache. Conclusions: Once again, the query cache…
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 28 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 …
