diff options
| author | Varun Gupta <varunraiko1803@gmail.com> | 2018-05-31 15:51:59 +0530 |
|---|---|---|
| committer | Varun Gupta <varunraiko1803@gmail.com> | 2018-11-07 13:17:05 +0530 |
| commit | 5915a7d6ad347b09783968ca7a7b62cb21d73871 (patch) | |
| tree | ed4a535916ad46269c67644bbc487f04e03ad529 /sql/sys_vars.cc | |
| parent | 41e68e8e5b3ce89c61f19bf072b59cf13a6fdc16 (diff) | |
| download | mariadb-git-10.4-selectivty4.tar.gz | |
MDEV-15253: Default optimizer setting changes for MariaDB 10.410.4-selectivty4
Diffstat (limited to 'sql/sys_vars.cc')
| -rw-r--r-- | sql/sys_vars.cc | 4 |
1 files changed, 2 insertions, 2 deletions
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", |