Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
11.0(EOL)
-
None
Description
Range cost cost calculations does not take into account join_buffer.
When 11.0 optimizer was coded, the assumption was that RANGE queries will not use the join buffer (and join buffer flag was not set for these).
The optimizer would however decide later to use join buffer, which means that the cost
calculations for ranges did not match reality, which could mean that the optimizer could
use a worse plan.
The task is to fix that range + join_buffer cost is calculated correctly.
This is a bit complex to do as the 'range total cost' that best_access_plan() is not specific
enough to allow correct calculation of range + join_buffer.
Attachments
Issue Links
- causes
-
MDEV-31445 Server crashes in ha_partition::index_blocks / cost_for_index_read
- Closed
-
MDEV-31494 Server crashes in ha_partition::index_blocks / get_key_scans_params
- Closed