From 5915a7d6ad347b09783968ca7a7b62cb21d73871 Mon Sep 17 00:00:00 2001 From: Varun Gupta Date: Thu, 31 May 2018 15:51:59 +0530 Subject: MDEV-15253: Default optimizer setting changes for MariaDB 10.4 --- sql/sys_vars.cc | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'sql/sys_vars.cc') diff --git a/sql/sys_vars.cc b/sql/sys_vars.cc index 6d2dbbf646e..6ace121b983 100644 --- a/sql/sys_vars.cc +++ b/sql/sys_vars.cc @@ -2456,7 +2456,7 @@ static Sys_var_ulong Sys_optimizer_use_condition_selectivity( "5 - additionally use selectivity of certain non-range predicates " "calculated on record samples", SESSION_VAR(optimizer_use_condition_selectivity), CMD_LINE(REQUIRED_ARG), - VALID_RANGE(1, 5), DEFAULT(1), BLOCK_SIZE(1)); + VALID_RANGE(1, 5), DEFAULT(4), BLOCK_SIZE(1)); static Sys_var_ulong Sys_optimizer_search_depth( "optimizer_search_depth", @@ -5846,7 +5846,7 @@ static Sys_var_enum Sys_optimizer_use_stat_tables( "use_stat_tables", "Specifies how to use system statistics tables", SESSION_VAR(use_stat_tables), CMD_LINE(REQUIRED_ARG), - use_stat_tables_modes, DEFAULT(0)); + use_stat_tables_modes, DEFAULT(2)); static Sys_var_ulong Sys_histogram_size( "histogram_size", -- cgit v1.2.1