[MDEV-223] Encapsulate calculations of the table access cost and make them consistent and tunable Created: 2012-04-16  Updated: 2021-01-19

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Major
Reporter: Igor Babaev Assignee: Unassigned
Resolution: Unresolved Votes: 4
Labels: None

Issue Links:
Blocks
blocks MDEV-350 self-tuning cost coefficients Stalled
Duplicate
duplicates MDEV-9076 Make optimizer const constants config... Closed

 Description   

This task is mostly a re-engineering task.
Currently when calculating the cost of a ref table access method the function best_access_path makes an assumption that any index look-up is performed into a B-tree and the function uses engine independent code for this calculations.
The cost calculations also use some constants that should be done tunable through system variables tables since these constants may be different for different platform/environments.

This task is implemented in preparation for the development that will support more realistic cost model for query execution plans.

[1] http://askmonty.org/worklog/?tid=251

This is a prerequisite for MDEV-350 and similar to what MySQL 5.7 has under the name "Optimizer Cost Model"



 Comments   
Comment by Matias Sanchez [ 2021-01-19 ]

Hi guys! Any news here?

Generated at Thu Feb 08 06:27:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.