… the database optimizer. The SSB benchmark consists of four sets of queries. Each set is known as a “flight”. I have labeled…_buffer_size=32M innodb_buffer_pool_instances=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…deployment has a massive data set size in relation to both the working set and the cache device size, the numbers are encouraging. …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
…_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… defaults, as I understand from documentation TokuDB comes with good settings out-of-box, but I am ready to tune something…
Post: How is join_buffer_size allocated?
July 5, 2010 By 9 Comments
… needed (key_buffer_size). There are many examples of this. What about join_buffer_size? I saw a my.cnf with a 128M join_buffer_size the other… join_buffer_size is indeed very bad! And this leads me to an interesting possibility to run the server out of memory: set session join_buffer_size = 1 << 30; # 1GB select * from (select 1 union select 1) as x1 join (select 1 union select 1) as x2 join…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… the join_buffer_size increased to 6M, the query time was ~300s while when both the join_buffer_size and the read_rnd_buffer_size/mrr_buffer_size were set to…/ join_buffer_size=6M & read_rnd_buffer_size=6M MariaDB 5.5 MariaDB 5.5 w/ join_buffer_size=6M & mrr_buffer_size=6M MariaDB 5.5 Hash Join Disabled w/ join_buffer_size…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…_buffer_size=32M optimizer_switch=’join_cache_incremental=on’ optimizer_switch=’join_cache_hashed=on’ optimizer_switch=’join_cache_bka=on’ join_cache_level=4 join_buffer_size=32M join_buffer…, which means that your effective join_buffer_size is not bigger than this value. Hence, the reason I have set join_buffer_space_limit=32M. Benchmark…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…set_connectionblogpercona.commanual character_set_databaseblogpercona.commanual character_set_filesystemblogpercona.commanual character_set_resultsblogpercona.commanual character_set_serverblogpercona.commanual character_set_systemblogpercona.commanual character_sets…commanual join_buffer_…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…-5.6.10-linux-glibc2. | | MAX_ALLOWED_PACKET | 1048576 | 4194304 | | JOIN_BUFFER_SIZE | 131072 | 262144 | | TMPDIR | /mnt/data/sandboxes/msb_5_5_30…_blocks_time now set to 1000 making Innodb Buffer Pool Size scan resistant by default. Very welcome change ! thread_cache_size is enabled by…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…. Note dates may not be in date_id order’; /*!40101 SET character_set_client = @saved_cs_client */; CREATE TABLE `dim_flight` ( `UniqueCarrier…-use-sys-stats-table innodb-write-io-threads=4 join-buffer-size=16M key-buffer-size=64M local-infile=on lock-wait-timeout=300 log… partition=ON port=3306 read-buffer-size=512K read-rnd-buffer-size=1M skip-host-cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
… freehold: [client] port=3323 socket=/tmp/mysqld_mdmp.sock character-sets-dir=/home/mysqld/sys/5.5.8/share/mysql/…_buffer_size = 8M read_buffer_size = 2M query_prealloc_size = 65536 read_rnd_buffer_size = 8M table_open_cache = 1024 thread_cache_size = 8 query_cache_size = 128M join_buffer_size…
