… In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings … “flight”. I have labeled each query as Q{FLIGHT_NUMBER}.{QUERY_NUMBER}. In general, each flight …_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT key_buffer_size=10G …
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0 #56only loose-innodb_flush_neighbors=0 loose-metadata_locks_hash_instances=256 innodb_buffer_pool_instances=16 # MySQL 5.5 and 5…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…-Server-5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql …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_type = 0…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… tool used was sysbench 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30.1-465….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_type = 0…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…-only transaction optimization in MySQL 5.6, because all SELECT queries in the AUTOCOMMIT mode are,… innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb…_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0 warmup To warmup server …
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… query_cache_type is now off by default with default size of 1MB while 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…
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 …0 which would mean limit disabled. Very few users actually need DOS prevention this variable strives to provide as MySQL…good default. query_cache_size = 1M Query cache remains off by default but default size is raised to…
Comment: Innodb Performance Optimization Basics
March 30, 2009 By 75 Comments
… and using MySQL 5.0. Query cache size is 156M and limit is 8M. All tables except one are INNO DB and its buffer pool size is 1024M. The end user client module is read-only so lots and lots of repeated queries therefore I think query cache… for few mins. I fear that if I disable the query cache it will slow down my system which already is just…
Comment: MySQL random freezes could be the query cache
March 27, 2009 By 23 Comments
… and using MySQL 5.0. Query cache size is 156M and limit is 8M. All tables except one are INNO DB and its buffer pool size is 1024M. The end user client module is read-only so lots and lots of repeated queries therefore I think query cache… for few mins. I fear that if I disable the query cache it will slow down my system which already is just…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
…size ~5G). Note that query cache is disabled during these benchmark runs and that the disks are 4 5…MySQL 5.5. MariaDB 5.5 is quite slow as compared to both MySQL 5.5 and MySQL 5.6. For MariaDB 5.5 the query time decreases when the join_buffer_size…
