… = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
… model. As you properly describe for MariaDB model is to join SkySQL and then they have chances.
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
… order of the cloud and big data. If you can join us in Santa Clara for the Percona Live MySQL Conference…
Comment: 10 years of MySQL User Conferences
April 12, 2013 By 6 Comments
… to Sausalito, led by Tomas Ulin I was welcome to join although I worked for Monty at the time. Bernd Ocklin…
Post: Learn About MySQL 5.6 at the Percona Live MySQL Conference
April 3, 2013 By Leave a Comment
… be the liveliest, most engaging Percona Live event yet. Please join us in Santa Clara, April 22-25 for the Percona…
Comment: Why MySQL Performance at Low Concurrency is Important
March 29, 2013 By 8 Comments
… mysql currently has a bug in which concurrent queries with joins, especially those that examine a lot of the same data…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…_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_space_limit=32M Note that MariaDB includes a new variable ‘join… always uses the max values join algorithm. If join_cache_level=4 it always uses BNLH (hash join), if join_cache_level=8 it…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… one join algorithm and that is Nested Loop Join. MariaDB has introduced a new join algorithm Hash Join. This join algorithm only works with equi-joins. Now let me briefly explain how hash join…
Post: How is join_buffer_size allocated?
July 5, 2010 By 9 Comments
… allocated to cache rows from each table in a join when the join can’t use an index. This is because we… 14180 records 14181 ******************************************************************************/ 14182 14183 static int 14184 join_init_cache(THD *thd,JOIN_TAB *tables,uint table_count) 14185 { … snip … 14268…
