Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
Q1/2026 Server Development
Description
Store the following into the trace: -
1. optimizer system/session variables
- optimizer_prune_level
- optimizer_selectivity_sampling_limit
- optimizer_join_limit_pref_ratio
- optimizer_use_condition_selectivity
- optimizer_search_depth
- optimizer_extra_pruning_depth
- optimizer_switch
- optimizer_trace
- optimizer_trace_max_mem_size
- optimizer_adjust_secondary_key_costs
- optimizer_max_sel_arg_weight
- optimizer_max_sel_args
- optimizer_where_cost
- optimizer_scan_setup_cost
- optimizer_record_context
- use_stat_tables
- disk_read_ratio
- key_lookup_cost
- row_lookup_cost
- disk_read_cost
- key_copy_cost
- index_block_copy_cost
- row_next_find_cost
- key_next_find_cost
- row_copy_cost
- key_cmp_cost
- rowid_cmp_cost
- rowid_copy_cost
2. EITS statistics on the involved tables
Attachments
Issue Links
- split from
-
MDEV-36523 Optimizer Trace replay step #3: load basic statistics back
-
- In Progress
-