diff options
| author | unknown <sanja@askmonty.org> | 2011-07-15 12:16:46 +0300 |
|---|---|---|
| committer | unknown <sanja@askmonty.org> | 2011-07-15 12:16:46 +0300 |
| commit | c1b6eb149056f39969b2bbcbfe5d07eb3e1fcd44 (patch) | |
| tree | 545606df5a6b86281c85e68dc86674b34de64b53 /sql | |
| parent | 06fb641c0b5f918e81172171df1325131619a0a3 (diff) | |
| parent | af284b55f0206d1b921692fa10a6374745d1d2eb (diff) | |
| download | mariadb-git-c1b6eb149056f39969b2bbcbfe5d07eb3e1fcd44.tar.gz | |
Merge of subquery cache off by default.
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/mysql_priv.h | 1 | ||||
| -rw-r--r-- | sql/mysqld.cc | 2 |
2 files changed, 1 insertions, 2 deletions
diff --git a/sql/mysql_priv.h b/sql/mysql_priv.h index e4bb0a670fb..68184a94666 100644 --- a/sql/mysql_priv.h +++ b/sql/mysql_priv.h @@ -610,7 +610,6 @@ enabled by default, add OPTIMIZER_SWITCH_MATERIALIZATION OPTIMIZER_SWITCH_IN_TO_EXISTS | \ OPTIMIZER_SWITCH_PARTIAL_MATCH_ROWID_MERGE|\ OPTIMIZER_SWITCH_PARTIAL_MATCH_TABLE_SCAN|\ - OPTIMIZER_SWITCH_SUBQUERY_CACHE|\ OPTIMIZER_SWITCH_JOIN_CACHE_INCREMENTAL | \ OPTIMIZER_SWITCH_JOIN_CACHE_HASHED | \ OPTIMIZER_SWITCH_JOIN_CACHE_BKA) diff --git a/sql/mysqld.cc b/sql/mysqld.cc index 0cd0e560730..f6cbf581627 100644 --- a/sql/mysqld.cc +++ b/sql/mysqld.cc @@ -491,7 +491,7 @@ static const char *optimizer_switch_str="index_merge=on,index_merge_union=on," "semijoin=off," "partial_match_rowid_merge=on," "partial_match_table_scan=on," - "subquery_cache=on," + "subquery_cache=off," "mrr=off," "mrr_cost_based=off," "mrr_sort_keys=off," |