Nov 1, 2019 · Databases

Understanding MySQL join_buffer_size and Join Algorithms (Nested Loop, Block Nested Loop, Hash Join)

This article explains the purpose and configuration of MySQL's join_buffer_size for INNER JOIN operations without indexed join keys, compares Nested Loop, Block Nested Loop, and the newly introduced Hash Join algorithms, and shows how each affects execution plans and query performance.

MySQLNested Loopblock nested loop

0 likes · 8 min read

Understanding MySQL join_buffer_size and Join Algorithms (Nested Loop, Block Nested Loop, Hash Join)

Java High-Performance Architecture

Sep 24, 2015 · Databases

Optimizing MySQL join_buffer_size and sort_buffer_size for Better Performance

This guide explains what join_buffer_size and sort_buffer_size do in MySQL, shows their default values, and provides practical recommendations for safely increasing them to improve query and sort performance without exhausting system memory.

DatabasesMySQLjoin_buffer_size

0 likes · 2 min read

Optimizing MySQL join_buffer_size and sort_buffer_size for Better Performance