From 54caeee5d6bc06be4cc451aef49ee0a4f7655ce2 Mon Sep 17 00:00:00 2001 From: unknown Date: Wed, 5 Oct 2011 18:18:00 +0300 Subject: Making subquery cache on by default. --- sql/mysql_priv.h | 3 ++- sql/mysqld.cc | 2 +- 2 files changed, 3 insertions(+), 2 deletions(-) (limited to 'sql') diff --git a/sql/mysql_priv.h b/sql/mysql_priv.h index bccd5b189ff..903f8bd82ff 100644 --- a/sql/mysql_priv.h +++ b/sql/mysql_priv.h @@ -608,7 +608,8 @@ enabled by default, add OPTIMIZER_SWITCH_MATERIALIZATION OPTIMIZER_SWITCH_PARTIAL_MATCH_TABLE_SCAN|\ OPTIMIZER_SWITCH_JOIN_CACHE_INCREMENTAL | \ OPTIMIZER_SWITCH_JOIN_CACHE_HASHED | \ - OPTIMIZER_SWITCH_JOIN_CACHE_BKA) + OPTIMIZER_SWITCH_JOIN_CACHE_BKA | \ + OPTIMIZER_SWITCH_SUBQUERY_CACHE) /* Replication uses 8 bytes to store SQL_MODE in the binary log. The day you diff --git a/sql/mysqld.cc b/sql/mysqld.cc index be66aa957e9..41ec3cde556 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=off," + "subquery_cache=on," "mrr=off," "mrr_cost_based=off," "mrr_sort_keys=off," -- cgit v1.2.1