The BUFFER or USING JOIN BUFFER join type indicates that the results of the query are being buffered for use further up the plan
using_join_buffer operation indicates that an input for this step have been buffered from a previous step. Using a join buffer reduces I/O operations. Join Buffers are seen in
Block Nested Loop,
Batched Key Access, and
hash join operations.
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.
- Google Search for mysql - join_buffer
- Ecosia Search for mysql - join_buffer
- Bing Search for mysql - join_buffer