… have labeled each query as Q{FLIGHT_NUMBER}.{QUERY_NUMBER}. In general…mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size…cache=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT key_buffer_size=10G # Disabling symbolic-links is recommended…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there … been recommending for a while. innodb_stats_on_metadata = off Yet another change I actively recommended …would be good default. query_cache_size = 1M Query cache remains off by default but default size is raised to 1M …
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…queries that don’t use indexes and that do use some of the new optimizer features. query_cache_size RAM is allocated even if query_cache…/supportingmysql/entry/mysql_server_5_6_default . thread_cache_size is …recommend them after reading about how they work. I’m currently preparing our recommendations…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… Maybe you want us to analyze and present recommendations for your consideration, and take a look-… @ 2.00GHz stepping : 11 cpu MHz : 1995.022 cache size : 4096 KB physical id : 1 siblings : 4 core id…most expensive queries, in total execution time. By the way, the slow query logs in the stock MySQL …
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…_size = 8M bulk_insert_buffer_size = 8M query_cache_limit = 254M query_cache_size = 254M query_cache_type = 1 query_prealloc_size = 65536 query_alloc_block_size = …mysql 3.x # clients (those using the mysqlclient10 compatibility package). #old_passwords=1 # Disabling symbolic-links is recommended…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…you also have MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads, temporary …size choice. You do not want OS to cache what Innodb is caching already. Innodb cache is more efficient compared to OS cache… work better than 70-80% recommendation and of course you should…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…query-time=5 log-slow-queries=/apps/log/slow-query interactive_timeout=300 wait_timeout=300 thread_cache = 40 max_connections=500 query_cache_size…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…MySQL 5.5 and ~5 hours in case of MySQL 5.6 and MariaDB 5.5. Note that query cache…query execution plan, is not sufficiently tuned and it is recommended to turn this off. The query…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
…Cache Type Cache Gets/sec Array Cache 365000 APC Cache 98000 File Cache 27000 Memcached Cache (TCP/IP) 12200 MySQL Query Cache (TCP/IP) 9900 MySQL Query Cache…cached from query cache. Pretty impressive. So what my recommendations would be about using these caches for your application ? Cache…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: I tested MySQL…size=64M max_prepared_stmt_count=1000000 query_cache_size=0 skip_grant_tables skip_locking sort_buffer_size=64K table_cache=2048 thread_cache_size…rare already and recommendation to fit at…
