LEFT JOIN + 多表↓优化器选择 Hash Join(MySQL 8.0.18+)↓join_buffer_size 不足↓Hash Join 溢出到磁盘(spill to disk)↓行数据在 buffer 中被反复 Store/Load↓EQRefIterator 缓存的 record[0] 被 AggregateIterator 破坏↓NULL 行丢失 → 查询结果错误
SET optimizer_switch='block_nested_loop=off';
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback