From: Martin Zaun
Date: February 22 2011 9:29pm
Subject: bzr commit into mysql-5.1-telco-7.1 branch (martin.zaun:4107)
List-Archive: http://lists.mysql.com/commits/131888
Message-Id: <201102222130.p1MK0U32009688@acsinet15.oracle.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============0405208312679093219=="

--===============0405208312679093219==
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

#At file:///Users/mz/mysql/ndb-7.1/ based on revid:martin.zaun@stripped

 4107 Martin Zaun	2011-02-22 [merge]
      merge from 7.0 to 7.1

    added:
      mysql-test/include/execute_with_statistics.inc
    modified:
      mysql-test/r/greedy_optimizer.result
      mysql-test/t/greedy_optimizer.test
      storage/ndb/src/kernel/vm/LongSignal.cpp
      storage/ndb/src/kernel/vm/TransporterCallback.cpp
      storage/ndb/src/mgmsrv/ConfigManager.cpp
      storage/ndb/src/mgmsrv/ConfigManager.hpp
      storage/ndb/test/ndbapi/testMgm.cpp
=== added file 'mysql-test/include/execute_with_statistics.inc'
--- a/mysql-test/include/execute_with_statistics.inc	1970-01-01 00:00:00 +0000
+++ b/mysql-test/include/execute_with_statistics.inc	2011-02-22 17:44:38 +0000
@@ -0,0 +1,28 @@
+# include/execute_with_statistics.inc
+#
+# SUMMARY
+#
+#    Explain and execute the select statment in $query.
+#    Then report 'Last_query_cost' estimate from the query
+#    optimizer and total number of 'Handler_read%' when the
+#    query was executed.
+#    Intended usage is to verify that there are not regressions
+#    in either calculated or actuall cost for $query.
+#
+# USAGE
+#
+#    let $query= <select statement>;
+#    --source include/execute_with_statistics.inc
+#
+# EXAMPLE
+#    t/greedy_optimizer.test
+#
+
+eval EXPLAIN $query;
+SHOW STATUS LIKE 'Last_query_cost';
+
+FLUSH STATUS;
+eval $query;
+SELECT SUM(variable_value) AS Total_handler_reads
+   FROM information_schema.session_status
+   WHERE variable_name LIKE 'Handler_read%';

=== modified file 'mysql-test/r/greedy_optimizer.result'
--- a/mysql-test/r/greedy_optimizer.result	2009-01-16 10:45:17 +0000
+++ b/mysql-test/r/greedy_optimizer.result	2011-02-22 18:43:37 +0000
@@ -198,7 +198,7 @@ set optimizer_search_depth=0;
 select @@optimizer_search_depth;
 @@optimizer_search_depth
 0
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+EXPLAIN select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
@@ -207,10 +207,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t4.c42	1	
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t6.c62	1	Using index
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	821.837037
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+FLUSH STATUS;
+select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+46
+EXPLAIN select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
@@ -219,10 +230,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t4.c42	1	
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t6.c62	1	Using index
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	821.837037
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+FLUSH STATUS;
+select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+46
+EXPLAIN select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	
 1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using join buffer
@@ -231,10 +253,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using index
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using index
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	289.418727
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+FLUSH STATUS;
+select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+114
+EXPLAIN select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	
 1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using join buffer
@@ -243,10 +276,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using index
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using index
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	289.418727
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+FLUSH STATUS;
+select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+114
+EXPLAIN select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	
 1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where; Using join buffer
@@ -255,10 +299,18 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using where
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using where
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	289.418727
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+FLUSH STATUS;
+select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+c11
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+20
+EXPLAIN select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	
 1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where; Using join buffer
@@ -267,14 +319,22 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using where
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using where
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	289.418727
+FLUSH STATUS;
+select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+c11
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+20
 set optimizer_search_depth=1;
 select @@optimizer_search_depth;
 @@optimizer_search_depth
 1
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+EXPLAIN select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
@@ -283,10 +343,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t4.c42	1	
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t6.c62	1	Using index
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	821.837037
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+FLUSH STATUS;
+select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+46
+EXPLAIN select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
@@ -295,10 +366,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t4.c42	1	
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t6.c62	1	Using index
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	821.837037
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+FLUSH STATUS;
+select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+46
+EXPLAIN select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	PRIMARY	NULL	NULL	NULL	3	
 1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t1.c12	1	Using index
@@ -307,10 +389,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
 1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where; Using join buffer
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	794.837037
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+FLUSH STATUS;
+select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+46
+EXPLAIN select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	PRIMARY	NULL	NULL	NULL	3	
 1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t1.c12	1	Using index
@@ -319,10 +412,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
 1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where; Using join buffer
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	794.837037
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+FLUSH STATUS;
+select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+46
+EXPLAIN select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	PRIMARY	NULL	NULL	NULL	3	
 1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t1.c12	1	
@@ -331,10 +435,18 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
 1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where; Using join buffer
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	794.837037
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+FLUSH STATUS;
+select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+c11
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+6
+EXPLAIN select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	PRIMARY	NULL	NULL	NULL	3	
 1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t1.c12	1	
@@ -343,14 +455,22 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
 1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where; Using join buffer
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	794.837037
+FLUSH STATUS;
+select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+c11
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+6
 set optimizer_search_depth=62;
 select @@optimizer_search_depth;
 @@optimizer_search_depth
 62
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+EXPLAIN select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
@@ -359,10 +479,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t4.c42	1	
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t6.c62	1	Using index
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	821.837037
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+FLUSH STATUS;
+select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+46
+EXPLAIN select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
@@ -371,10 +502,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t4.c42	1	
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t6.c62	1	Using index
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	821.837037
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+FLUSH STATUS;
+select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+46
+EXPLAIN select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	
 1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using join buffer
@@ -383,10 +525,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using index
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using index
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	289.418727
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+FLUSH STATUS;
+select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+114
+EXPLAIN select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	
 1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using join buffer
@@ -395,10 +548,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using index
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using index
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	289.418727
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+FLUSH STATUS;
+select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+114
+EXPLAIN select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	
 1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where; Using join buffer
@@ -407,10 +571,18 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using where
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using where
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	289.418727
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+FLUSH STATUS;
+select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+c11
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+20
+EXPLAIN select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	
 1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where; Using join buffer
@@ -419,9 +591,17 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using where
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using where
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	289.418727
+FLUSH STATUS;
+select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+c11
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+20
 set optimizer_prune_level=1;
 select @@optimizer_prune_level;
 @@optimizer_prune_level
@@ -430,7 +610,7 @@ set optimizer_search_depth=0;
 select @@optimizer_search_depth;
 @@optimizer_search_depth
 0
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+EXPLAIN select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
@@ -439,10 +619,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t4.c42	1	
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t6.c62	1	Using index
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	821.837037
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+FLUSH STATUS;
+select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+46
+EXPLAIN select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
@@ -451,10 +642,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t4.c42	1	
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t6.c62	1	Using index
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	821.837037
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+FLUSH STATUS;
+select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+46
+EXPLAIN select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	PRIMARY	NULL	NULL	NULL	3	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
@@ -463,10 +665,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using index
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using index
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	794.837037
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+FLUSH STATUS;
+select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+46
+EXPLAIN select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	PRIMARY	NULL	NULL	NULL	3	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
@@ -475,10 +688,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using index
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using index
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	794.837037
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+FLUSH STATUS;
+select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+46
+EXPLAIN select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	PRIMARY	NULL	NULL	NULL	3	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
@@ -487,10 +711,18 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using where
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using where
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	794.837037
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+FLUSH STATUS;
+select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+c11
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+25
+EXPLAIN select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	PRIMARY	NULL	NULL	NULL	3	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
@@ -499,14 +731,22 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using where
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using where
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	794.837037
+FLUSH STATUS;
+select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+c11
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+25
 set optimizer_search_depth=1;
 select @@optimizer_search_depth;
 @@optimizer_search_depth
 1
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+EXPLAIN select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
@@ -515,10 +755,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t4.c42	1	
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t6.c62	1	Using index
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	821.837037
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+FLUSH STATUS;
+select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+46
+EXPLAIN select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
@@ -527,10 +778,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t4.c42	1	
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t6.c62	1	Using index
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	821.837037
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+FLUSH STATUS;
+select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+46
+EXPLAIN select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	PRIMARY	NULL	NULL	NULL	3	
 1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t1.c12	1	Using index
@@ -539,10 +801,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
 1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where; Using join buffer
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	794.837037
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+FLUSH STATUS;
+select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+46
+EXPLAIN select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	PRIMARY	NULL	NULL	NULL	3	
 1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t1.c12	1	Using index
@@ -551,10 +824,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
 1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where; Using join buffer
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	794.837037
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+FLUSH STATUS;
+select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+46
+EXPLAIN select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	PRIMARY	NULL	NULL	NULL	3	
 1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t1.c12	1	
@@ -563,10 +847,18 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
 1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where; Using join buffer
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	794.837037
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+FLUSH STATUS;
+select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+c11
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+6
+EXPLAIN select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	PRIMARY	NULL	NULL	NULL	3	
 1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t1.c12	1	
@@ -575,14 +867,22 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
 1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where; Using join buffer
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	794.837037
+FLUSH STATUS;
+select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+c11
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+6
 set optimizer_search_depth=62;
 select @@optimizer_search_depth;
 @@optimizer_search_depth
 62
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+EXPLAIN select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
@@ -591,10 +891,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t4.c42	1	
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t6.c62	1	Using index
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	821.837037
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+FLUSH STATUS;
+select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+46
+EXPLAIN select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
@@ -603,10 +914,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t4.c42	1	
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t6.c62	1	Using index
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	821.837037
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+FLUSH STATUS;
+select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+46
+EXPLAIN select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	PRIMARY	NULL	NULL	NULL	3	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
@@ -615,10 +937,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using index
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using index
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	794.837037
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+FLUSH STATUS;
+select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+46
+EXPLAIN select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	PRIMARY	NULL	NULL	NULL	3	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
@@ -627,10 +960,21 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using index
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using index
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	794.837037
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+FLUSH STATUS;
+select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+c11
+1
+2
+3
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+46
+EXPLAIN select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	PRIMARY	NULL	NULL	NULL	3	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
@@ -639,10 +983,18 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using where
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using where
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	794.837037
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+FLUSH STATUS;
+select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+c11
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+25
+EXPLAIN select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	PRIMARY	NULL	NULL	NULL	3	
 1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where; Using join buffer
@@ -651,9 +1003,17 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using where
 1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where; Using join buffer
 1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using where
-show status like 'Last_query_cost';
+SHOW STATUS LIKE 'Last_query_cost';
 Variable_name	Value
 Last_query_cost	794.837037
+FLUSH STATUS;
+select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+c11
+SELECT SUM(variable_value) AS Total_handler_reads
+FROM information_schema.session_status
+WHERE variable_name LIKE 'Handler_read%';
+Total_handler_reads
+25
 drop table t1,t2,t3,t4,t5,t6,t7;
 CREATE TABLE t1 (a int, b int, d int, i int);
 INSERT INTO t1 VALUES (1,1,1,1);

=== modified file 'mysql-test/t/greedy_optimizer.test'
--- a/mysql-test/t/greedy_optimizer.test	2009-01-16 10:45:17 +0000
+++ b/mysql-test/t/greedy_optimizer.test	2011-02-22 14:49:03 +0000
@@ -196,58 +196,92 @@ set optimizer_search_depth=0;
 select @@optimizer_search_depth;
 
 # 6-table join, chain
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
-show status like 'Last_query_cost';
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
-show status like 'Last_query_cost';
-# 6-table join, star
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
-show status like 'Last_query_cost';
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
-show status like 'Last_query_cost';
-# 6-table join, clique
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
-show status like 'Last_query_cost';
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
-show status like 'Last_query_cost';
+let $query=
+ select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+--source include/execute_with_statistics.inc
+
+let $query=
+ select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+--source include/execute_with_statistics.inc
+
+# 6-table join, star
+let $query=
+ select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+--source include/execute_with_statistics.inc
+
+let $query=
+ select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+--source include/execute_with_statistics.inc
+
+# 6-table join, clique
+let $query=
+ select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+--source include/execute_with_statistics.inc
+
+let $query=
+ select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+--source include/execute_with_statistics.inc
+
 
 set optimizer_search_depth=1;
 select @@optimizer_search_depth;
 
 # 6-table join, chain
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
-show status like 'Last_query_cost';
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
-show status like 'Last_query_cost';
-# 6-table join, star
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
-show status like 'Last_query_cost';
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
-show status like 'Last_query_cost';
-# 6-table join, clique
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
-show status like 'Last_query_cost';
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
-show status like 'Last_query_cost';
+let $query=
+ select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+--source include/execute_with_statistics.inc
+
+let $query=
+ select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+--source include/execute_with_statistics.inc
+
+# 6-table join, star
+let $query=
+ select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+--source include/execute_with_statistics.inc
+
+let $query=
+ select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+--source include/execute_with_statistics.inc
+
+# 6-table join, clique
+let $query=
+ select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+--source include/execute_with_statistics.inc
+
+let $query=
+ select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+--source include/execute_with_statistics.inc
 
 set optimizer_search_depth=62;
 select @@optimizer_search_depth;
 
 # 6-table join, chain
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
-show status like 'Last_query_cost';
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
-show status like 'Last_query_cost';
-# 6-table join, star
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
-show status like 'Last_query_cost';
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
-show status like 'Last_query_cost';
-# 6-table join, clique
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
-show status like 'Last_query_cost';
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
-show status like 'Last_query_cost';
+let $query=
+ select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+--source include/execute_with_statistics.inc
+
+let $query=
+ select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+--source include/execute_with_statistics.inc
+
+# 6-table join, star
+let $query=
+ select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+--source include/execute_with_statistics.inc
+
+let $query=
+ select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+--source include/execute_with_statistics.inc
+
+# 6-table join, clique
+let $query=
+ select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+--source include/execute_with_statistics.inc
+
+let $query=
+ select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+--source include/execute_with_statistics.inc
 
 
 set optimizer_prune_level=1;
@@ -257,58 +291,91 @@ set optimizer_search_depth=0;
 select @@optimizer_search_depth;
 
 # 6-table join, chain
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
-show status like 'Last_query_cost';
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
-show status like 'Last_query_cost';
-# 6-table join, star
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
-show status like 'Last_query_cost';
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
-show status like 'Last_query_cost';
-# 6-table join, clique
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
-show status like 'Last_query_cost';
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
-show status like 'Last_query_cost';
+let $query=
+ select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+--source include/execute_with_statistics.inc
+
+let $query=
+ select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+--source include/execute_with_statistics.inc
+
+# 6-table join, star
+let $query=
+ select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+--source include/execute_with_statistics.inc
+
+let $query=
+ select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+--source include/execute_with_statistics.inc
+
+# 6-table join, clique
+let $query=
+ select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+--source include/execute_with_statistics.inc
+
+let $query=
+ select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+--source include/execute_with_statistics.inc
 
 set optimizer_search_depth=1;
 select @@optimizer_search_depth;
 
 # 6-table join, chain
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
-show status like 'Last_query_cost';
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
-show status like 'Last_query_cost';
-# 6-table join, star
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
-show status like 'Last_query_cost';
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
-show status like 'Last_query_cost';
-# 6-table join, clique
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
-show status like 'Last_query_cost';
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
-show status like 'Last_query_cost';
+let $query=
+ select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+--source include/execute_with_statistics.inc
+
+let $query=
+ select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+--source include/execute_with_statistics.inc
+
+# 6-table join, star
+let $query=
+ select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+--source include/execute_with_statistics.inc
+
+let $query=
+ select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+--source include/execute_with_statistics.inc
+
+# 6-table join, clique
+let $query=
+ select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+--source include/execute_with_statistics.inc
+
+let $query=
+ select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+--source include/execute_with_statistics.inc
 
 set optimizer_search_depth=62;
 select @@optimizer_search_depth;
 
 # 6-table join, chain
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
-show status like 'Last_query_cost';
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
-show status like 'Last_query_cost';
-# 6-table join, star
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
-show status like 'Last_query_cost';
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
-show status like 'Last_query_cost';
-# 6-table join, clique
-explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
-show status like 'Last_query_cost';
-explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
-show status like 'Last_query_cost';
+let $query=
+ select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+--source include/execute_with_statistics.inc
+
+let $query=
+ select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;
+--source include/execute_with_statistics.inc
+
+# 6-table join, star
+let $query=
+ select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+--source include/execute_with_statistics.inc
+
+let $query=
+ select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;
+--source include/execute_with_statistics.inc
+
+# 6-table join, clique
+let $query=
+ select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+--source include/execute_with_statistics.inc
+
+let $query=
+ select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;
+--source include/execute_with_statistics.inc
 
 drop table t1,t2,t3,t4,t5,t6,t7;
 

=== modified file 'storage/ndb/src/kernel/vm/LongSignal.cpp'
--- a/storage/ndb/src/kernel/vm/LongSignal.cpp	2011-02-02 00:40:07 +0000
+++ b/storage/ndb/src/kernel/vm/LongSignal.cpp	2011-02-22 06:57:40 +0000
@@ -180,6 +180,7 @@ dupSection(SPC_ARG Uint32& copyFirstIVal
   return true;
 }
 
+bool ErrorImportActive = false;
 extern int ErrorSignalReceive;
 extern int ErrorMaxSegmentsToSeize;
 
@@ -217,11 +218,14 @@ appendToSection(SPC_ARG Uint32& firstSeg
   {
 #ifdef ERROR_INSERT
     /* Simulate running out of segments */
-    if ((ErrorSignalReceive == 1) && 
-        (ErrorMaxSegmentsToSeize == 0))
+    if (ErrorImportActive)
     {
-      ndbout_c("append exhausted on first segment");
-      return false;
+      if ((ErrorSignalReceive == 1) && 
+          (ErrorMaxSegmentsToSeize == 0))
+      {
+        ndbout_c("append exhausted on first segment");
+        return false;
+      }
     }
 #endif
     /* First data to be added to this section */
@@ -273,13 +277,16 @@ appendToSection(SPC_ARG Uint32& firstSeg
 
 #ifdef ERROR_INSERT
     /* Simulate running out of segments */
-    if ((ErrorSignalReceive == 1) && 
-        (0 == remainSegs--))
+    if (ErrorImportActive)
     {
-      ndbout_c("Append exhausted on segment %d", ErrorMaxSegmentsToSeize);
-      firstPtr.p->m_lastSegment= prevPtr.i;
-      firstPtr.p->m_sz-= len;
-      return false;
+      if ((ErrorSignalReceive == 1) && 
+          (0 == remainSegs--))
+      {
+        ndbout_c("Append exhausted on segment %d", ErrorMaxSegmentsToSeize);
+        firstPtr.p->m_lastSegment= prevPtr.i;
+        firstPtr.p->m_sz-= len;
+        return false;
+      }
     }
 #endif
     bool result = g_sectionSegmentPool.seize(SPC_SEIZE_ARG currPtr);
@@ -313,11 +320,14 @@ import(SPC_ARG Ptr<SectionSegment> & fir
 
 #ifdef ERROR_INSERT
   /* Simulate running out of segments */
-  if ((ErrorSignalReceive == 1) &&
-      (ErrorMaxSegmentsToSeize == 0))
+  if (ErrorImportActive)
   {
-    ndbout_c("Import exhausted on first segment");
-    return false;
+    if ((ErrorSignalReceive == 1) &&
+        (ErrorMaxSegmentsToSeize == 0))
+    {
+      ndbout_c("Import exhausted on first segment");
+      return false;
+    }
   }
 #endif
 
@@ -346,15 +356,18 @@ import(SPC_ARG Ptr<SectionSegment> & fir
 
 #ifdef ERROR_INSERT
     /* Simulate running out of segments */
-    if ((ErrorSignalReceive == 1) &&
-        (0 == remainSegs--))
+    if (ErrorImportActive)
     {
-      ndbout_c("Import exhausted on segment %d", 
-               ErrorMaxSegmentsToSeize);
-      first.p->m_lastSegment= prevPtr.i;
-      first.p->m_sz-= len;
-      prevPtr.p->m_nextSegment = RNIL;
-      return false;
+      if ((ErrorSignalReceive == 1) &&
+          (0 == remainSegs--))
+      {
+        ndbout_c("Import exhausted on segment %d", 
+                 ErrorMaxSegmentsToSeize);
+        first.p->m_lastSegment= prevPtr.i;
+        first.p->m_sz-= len;
+        prevPtr.p->m_nextSegment = RNIL;
+        return false;
+      }
     }
 #endif
 

=== modified file 'storage/ndb/src/kernel/vm/TransporterCallback.cpp'
--- a/storage/ndb/src/kernel/vm/TransporterCallback.cpp	2011-02-01 23:27:25 +0000
+++ b/storage/ndb/src/kernel/vm/TransporterCallback.cpp	2011-02-22 06:57:40 +0000
@@ -46,6 +46,13 @@ SectionSegmentPool g_sectionSegmentPool;
 int ErrorSignalReceive= 0;
 int ErrorMaxSegmentsToSeize= 0;
 
+/**
+ * This variable controls if ErrorSignalReceive/ErrorMaxSegmentsToSeize
+ *   is active...This to make sure only received signals are affected
+ *   and not long signals sent inside node
+ */
+extern bool ErrorImportActive;
+
 struct ConnectionError
 {
   enum TransporterError err;
@@ -140,6 +147,7 @@ TransporterCallbackKernel::deliver_signa
   bzero(secPtr, sizeof(secPtr));
   secPtr[0].p = secPtr[1].p = secPtr[2].p = 0;
 
+  ErrorImportActive = true;
   switch(secCount){
   case 3:
     ok &= import(SPC_CACHE_ARG secPtr[2], ptr[2].p, ptr[2].sz);
@@ -148,6 +156,7 @@ TransporterCallbackKernel::deliver_signa
   case 1:
     ok &= import(SPC_CACHE_ARG secPtr[0], ptr[0].p, ptr[0].sz);
   }
+  ErrorImportActive = false;
 
   /**
    * Check that we haven't received a too long signal

=== modified file 'storage/ndb/src/mgmsrv/ConfigManager.cpp'
--- a/storage/ndb/src/mgmsrv/ConfigManager.cpp	2011-02-22 21:27:30 +0000
+++ b/storage/ndb/src/mgmsrv/ConfigManager.cpp	2011-02-22 21:29:46 +0000
@@ -903,6 +903,7 @@ void ConfigManager::set_config_change_st
   {
     // Rebuild m_all_mgm so that each node in config is included
     // new mgm nodes might have been added
+    assert(m_config_change.m_error == ConfigChangeRef::OK);
     m_config->get_nodemask(m_all_mgm, NDB_MGM_NODE_TYPE_MGM);
   }
 
@@ -1113,7 +1114,7 @@ ConfigManager::sendConfigChangeConf(Sign
 
 
 void
-ConfigManager::startConfigChange(SignalSender& ss)
+ConfigManager::startConfigChange(SignalSender& ss, Uint32 ref)
 {
   if (m_config_state == CS_INITIAL)
   {
@@ -1126,7 +1127,7 @@ ConfigManager::startConfigChange(SignalS
                         m_config_change.m_new_config->getGeneration());
   }
   m_config_change.m_contacted_nodes.clear();
-  m_config_change.m_client_ref = ss.getOwnRef();
+  m_config_change.m_client_ref = ref;
   if (sendConfigChangeImplReq(ss, m_config_change.m_new_config) <= 0)
   {
     g_eventLogger->error("Failed to start configuration change!");
@@ -1152,16 +1153,30 @@ ConfigManager::startAbortConfigChange(Si
                                      MGM_CONFIG_MAN,
                                      GSN_CONFIG_CHANGE_IMPL_REQ,
                                      ConfigChangeImplReq::SignalLength);
-  if (m_waiting_for.isclear())
-    set_config_change_state(ConfigChangeState::IDLE);
-  else
-    set_config_change_state(ConfigChangeState::ABORTING);
 
   if (m_config_change.m_new_config)
   {
     delete m_config_change.m_new_config;
     m_config_change.m_new_config = 0;
   }
+
+  if (m_waiting_for.isclear())
+  {
+    /**
+     * Send CONFIG_CHANGE_IMPL_CONF (aborting) to self
+     */
+    m_waiting_for.set(ss.getOwnNodeId());
+    ConfigChangeImplConf* const conf =
+      CAST_PTR(ConfigChangeImplConf, ssig.getDataPtrSend());
+    conf->requestType = ConfigChangeImplReq::Abort;
+
+    ss.sendSignal(ss.getOwnNodeId(), ssig,
+                  MGM_CONFIG_MAN,
+                  GSN_CONFIG_CHANGE_IMPL_CONF,
+                  ConfigChangeImplConf::SignalLength);
+  }
+
+  set_config_change_state(ConfigChangeState::ABORTING);
 }
 
 int
@@ -1277,9 +1292,8 @@ ConfigManager::execCONFIG_CHANGE_REQ(Sig
     return;
   }
 
-  m_config_change.m_client_ref = from;
   m_config_change.m_new_config = new_config;
-  startConfigChange(ss);
+  startConfigChange(ss, from);
 
   return;
 }
@@ -1326,7 +1340,7 @@ ConfigManager::execCONFIG_CHECK_REQ(Sign
     other_checksum = checksum;
   }
 
-  if (m_prepared_config)
+  if (m_prepared_config || m_config_change.m_new_config)
   {
     g_eventLogger->debug("Got CONFIG_CHECK_REQ from node: %d while "
                          "config change in progress (m_prepared_config). "
@@ -1338,6 +1352,19 @@ ConfigManager::execCONFIG_CHECK_REQ(Sign
     return;
   }
 
+  if (m_config_change.m_loaded_config && ss.getOwnNodeId() < nodeId)
+  {
+    g_eventLogger->debug("Got CONFIG_CHECK_REQ from node: %d while "
+                         "having a loaded config (and my node is lower: %d). "
+                         "Returning incorrect state, causing it to be retried",
+                         nodeId,
+                         ss.getOwnNodeId());
+    sendConfigCheckRef(ss, from, ConfigCheckRef::WrongState,
+                       generation, other_generation,
+                       m_config_state, CS_UNINITIALIZED);
+    return;
+  }
+
   g_eventLogger->debug("Got CONFIG_CHECK_REQ from node: %d. "
                        "Our generation: %d, other generation: %d, "
                        "our state: %d, other state: %d, "
@@ -1812,7 +1839,7 @@ ConfigManager::run()
           Config* new_conf = m_config_change.m_initial_config;
           m_config_change.m_initial_config = 0;
           m_config_change.m_new_config = new_conf;
-          startConfigChange(ss);
+          startConfigChange(ss, ss.getOwnRef());
         }
         break;
 
@@ -1834,7 +1861,7 @@ ConfigManager::run()
             m_started.equal(m_all_mgm) &&   // All mgmd started
             m_checked.equal(m_started))     // All nodes checked
         {
-          startConfigChange(ss);
+          startConfigChange(ss, ss.getOwnRef());
         }
 
         break;

=== modified file 'storage/ndb/src/mgmsrv/ConfigManager.hpp'
--- a/storage/ndb/src/mgmsrv/ConfigManager.hpp	2011-02-01 08:52:56 +0000
+++ b/storage/ndb/src/mgmsrv/ConfigManager.hpp	2011-02-22 21:29:46 +0000
@@ -153,7 +153,7 @@ class ConfigManager : public MgmtThread 
   void abortConfigChange();
 
   /* Functions for starting config change from ConfigManager */
-  void startConfigChange(SignalSender& ss);
+  void startConfigChange(SignalSender& ss, Uint32 ref);
   void startAbortConfigChange(SignalSender&);
 
   /* CONFIG_CHANGE - controlling config change from other node */

=== modified file 'storage/ndb/test/ndbapi/testMgm.cpp'
--- a/storage/ndb/test/ndbapi/testMgm.cpp	2011-02-02 00:40:07 +0000
+++ b/storage/ndb/test/ndbapi/testMgm.cpp	2011-02-22 08:40:01 +0000
@@ -22,6 +22,7 @@
 #include <mgmapi_debug.h>
 #include <InputStream.hpp>
 #include <signaldata/EventReport.hpp>
+#include <NdbRestarter.hpp>
 
 /*
   Tests that only need the mgmd(s) started
@@ -1127,7 +1128,7 @@ int runTestGetNodeIdUntilStopped(NDBT_Co
 
 int runSleepAndStop(NDBT_Context* ctx, NDBT_Step* step)
 {
-  int counter= 10*ctx->getNumLoops();
+  int counter= 3*ctx->getNumLoops();
 
   while(!ctx->isTestStopped() && counter--)
     NdbSleep_SecSleep(1);;
@@ -1162,7 +1163,7 @@ check_transporter_connect(NdbMgmd& mgmd,
 
   // Send the 'hello'
   g_info << "Client hello: '" << hello << "'" << endl;
-  if (out.println(hello))
+  if (out.println("%s", hello))
   {
     g_err << "Send hello '" << hello << "' failed" << endl;
     return false;
@@ -2504,18 +2505,22 @@ int runTestStatusAfterStop(NDBT_Context*
     return NDBT_FAILED;
   }
 
+  int nodeId = 0;
   for(int i=0; i < cs->no_of_nodes; i++ )
   {
     ndb_mgm_node_state *ns = cs->node_states + i;
     printf("Node ID: %d  status:%d\n", ns->node_id, ns->node_status);
+    if (nodeId == 0 && ns->node_type == NDB_MGM_NODE_TYPE_NDB)
+      nodeId = ns->node_id;
   }
   free(cs);
   cs = NULL;
 
   printf("Stopping data node\n");
   // We only stop 1 data node, in this case NodeId=2
-  int nodes[1] =  { 2 };
-  int stopped = ndb_mgm_stop2(mgmd.handle(), NDB_ARRAY_SIZE(nodes), nodes, 0);
+  int nodes[1] =  { nodeId };
+  int stopped = ndb_mgm_restart2(mgmd.handle(), NDB_ARRAY_SIZE(nodes), nodes, 
+                                 0, 0, 1);
   if (stopped < 0)
   {
     printf("ndb_mgm_stop failed, '%s' (%d)\n",
@@ -2541,6 +2546,10 @@ int runTestStatusAfterStop(NDBT_Context*
   }
   free(cs);
 
+  NdbRestarter res;
+  res.startAll();
+  res.waitClusterStarted();
+
   return NDBT_OK;
 }
 


--===============0405208312679093219==
MIME-Version: 1.0
Content-Type: text/bzr-bundle; charset="us-ascii";
	name="bzr/martin.zaun@stripped"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

# Bazaar merge directive format 2 (Bazaar 0.90)
# revision_id: martin.zaun@stripped
# target_branch: file:///Users/mz/mysql/ndb-7.1/
# testament_sha1: e947ad9d653ea2ac61f0911463a3e542836f844f
# timestamp: 2011-02-22 13:30:03 -0800
# source_branch: file:///Users/mz/mysql/ndb-7.1-ndb_restore-test-\
#   cleanup/
# base_revision_id: martin.zaun@stripped\
#   tr1cr8tkq9n402iy
# 
# Begin bundle
IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWVwv334AS4//gHUzCgJf9///
f///+r////5gLX8D73z6++OnvMpdwAbj5PFNg3PnsZjzTXzzHxO2BSfY6HvZPWKqb3BwtY9e70dd
aFl0CjqeEvj64o2bJbGTE3rBLntwQ8mKvWi7dKUUF2NNKaelahHXQ6PWTtgBQAA8JKamgCYATRpG
iejRNlTyU9T0nqeUaaaaZMnhQA0A0YShDQEBIaAT0jRT9TUeKAep6hoAAAAANMg0xCChJDTaRiep
oAAAAAAAAAAAEmpCmgmmmU01H6psSBtTRkNHqaAGgA0ANAaAAiUiNGRMTE9UamyeiPTSU/Kn6myR
tUxpqaPUeptMp5TR6hoHpHlAqSICAgDQJqZoEaE0Twk9NGqY1PUNPU9EAPUaeoZ6eHB5SFEk9RJ6
x5kmBJYonzEsLEouLC5Lj7hD+Yok/uIkohYkwIYEMiZEKD+ZDISIzFEoUSQoiSg/kRJgSIYlCKMi
SiT4kP5ENonxE+cTMXJclybSH9CGRD/uQ2kP8SH4Cq1ghnBFgIfI/FeuDC7PQy34tEwVaL/oQMx4
5HZITCTQggkorkeTFNFqEQSbdyM2Cr1QtXvYORs2QMzJmZrZDMhnYWZApICsYpOTg/XxHWjtOQrw
H59T/L+Admhuai/b4qP0JxnPiIGk0ci77wX5SsEjH3qdHU31e+HvPs9uWMnqqM9RC0Q6LOwfWh0i
VzlzjevuoK0UlqNRY8vyr3Wgg7u7t0MpehituM0cC11e6UEHT5gS/2A4DyEbH/9SljAuWLFiiWFy
5YlxcoouWLlEuLi5Li5QuURoJvKEoewShKtX0LST3ev3enlnhhhbZX07oHf30e8gkKJYSIxYUIii
e5wQK5ggvzEOriQrIhhYQxIXyiNtFqjbUBaiFUiqglSmfC+27bqQyiTuS6P08LiOO0iSCuIEAcgI
Aa5dO0r5pV0ymiObLK+XABt0BAvuYaWCwphTBQszLTMzZb5aayBEEQRBEEQW45VCNGdNhDK0xwto
y2xRNUTo43mO22TebBRFG4ho7FKU7FlLKWUonMQ9kIe57SoSQObiGMBERikCcgllGAoHpTlt2/T/
7/j74h+dK8zy7/l7ohtIWzvELkLj+GOPLCOJv/mxrt+knT9EOEmxS0JVFUpERZBQiJJBQAFJDoub
9NHhkIJ4efx8PSuGMB6W8SKb6DgQGVRRVUUXAZ5fWe52eJ5PwXw5qR5pBOcAnPSDbYJzoE61jFZR
GSSKIE0+G8izpHKEndxG3ojRoystFmBtrKWQDRytUEljISW9iZmZCS3oJLWtZGBYFCbo6IYwgKvA
YFnINEXWnDNEKkyGYmlm6YZAyQNFnZkxsgmJmBAHLM0ThDZAkyc0taUUN3UiTRkxTWLp3ashCZal
Y2q4bG5shnZKWyyyGWWRgirUqtWTdE4y22TvROtSLE4KJlcWsmb29zdzZoo7IZZZ4By1KBqXna4F
HRGyjgGyEDo7iP483hNHiWWWWXoLJ0ePCXZWEhxKXFUoEELZkoxsgaKMIojdqijZBajO0sKEyMvB
wQzJpq1WcNOdyvRkumubl7k6pU3dbw45seKljG0CBqESOcQohQhwELEKEKIcBCiFCFyFiHOQqqqq
qqqqkpKFJRSFERgQuQuQ00ofBM5TOiGdpgy9zQTd17d0kr0217d51xEPGiGXFksu5Xd7/Xh/JEPa
iHR/ZENXUZkQuBCreOsBOchzdU7b9TRyvMcsvmCRPEIUQoh5EiWIUQ9QhYhRD5iFggKCBV+25fvB
A9z/L5DjrpBQQEbzPLhufahPKkGoy8W88S35vn6WPhHS+Ksq5fA8CoS10BIC5xr+jWE/fhX+PUC0
Hb+q9YIgix6B61tHNe9CcZrMoggct0E/6xDkQ6M9hnWyyqziEx6XtIYkDnoPCnzVz6dX1H2aWnvB
FbTO+uH0+7+zSE8Lb4+suSPhuxSi+DQtPYE8/09kzOzelrOeRPJTol0mfurjQEJlSvzD1jBgwYMG
DBgwYPDquyHB3q7a+49JfTDTdO0h7SFohwaJE7EiWELkiUQzESMCROokSwkSxIliRLEKIUELEiWJ
EsIUQohRCiFiRLEiWEKIUQoQsSJRIlhCghZImKQRgAQN/HnnzAJRuOnDDXlCtemsVlw8fk7HrKcN
eeGMeRCBfkvt18XRvAh2CewREREQRERASIiCREREBIkQiSgAnDr2al54WHuL/yjuXWOZmJkc9bXG
H0dla2AdBduR4xbHVgS9VDs++b1sxC2fzQ+3XD0VGs+OBosusSVluk9Nl11EqHKeyUgNIqHQobJs
QTezCIUDd+hOclQ+7jRFVVVVVVVVVVVVVVVVVVVVVVVhAQgVCEDh5tTLBo5Rm9ODr989DGQd+/GG
7BgOFm97TfWmNXTCBwBBDztjBuz+DJ93Z3hZIgQaoumbkOiFk6Zxw/lXXUU/1Y+d3VYOm9pRke90
/2EEBy+z15UcNU7sMSG99kI9xBn78GPHhKtGwUcwo3ij9Io1Cj4xRrFHqFGsUeoUaxRqFHW9M75k
OYEPVaObWzNRoUzK5F+48paMBsFXWREPUb5YGj5Jcn0GT4fgpKdj73b+vhHF0ZSOHNZ5yOE5hhkn
nl5DAdpPlDkeO35DF+s4H7B5xDQbgpqJgcbGMSY0s4UTux63X+wpgdvWSRcFTLLXWDDs68+6FkoU
mvRA3cJgII9BIjQgjMIjQgjaERvBDVw7KlBGAhBRgZ+B2MGozX4S/QN9iFFQrCOi6qqkv+MIW0vg
RJeLbhPk9vu8ybOe+AXbSIgDhXYYSUJLv2yWEkEkkuz3xzfY11x2OgoGeaBAXYzcwI6KbjoI0Yhk
BmOgwLt4zQF0kwmZlmS6SzMzhJhJfTUmGZ2LAzsmMUSQwhZKdKYZmSZmXZoYTtjvzXdIL4P+VYyL
7TRhvtswar66QUjElGF3XgTBcpZfOYqnvYNGgWITirLTSodLSzjE2bNKte12BspJI8W5NxMEejKL
mhJoTnHLe7WBJCE7XMUBTBkXkspisURLFnVUhCkSTzuPJwSz0gSUWRlguQiFaJciIlQgVREgE8qG
Fo7imbC1SCoiJRANC+ixBKDZj468MNfwhnGTnzGgtJs4/31i4HvT2I/kSbx5EnqJJJcSLDsyTa6o
OAmYlpEQK6nTrlw57Ws4rAiIYJZiIwwIUW66cgDnrThYWs7pMpWo7yszWlSVh7O4CrUBAmAgUCGo
hiIZiGBDUhiQxIYkMSGRIm9Im9NYskTdJOkraS4gjDK+xTW30jHeiilOrOzclb7oJdX24Ttb/eHb
p2DETIFE30RItnIJW+l6NmfWX76w3W0Ul9bfvq3QbxXAbhORDZmxwJEv38DbuzHpJuRnhc5sZlVx
XSBLt7ePBrxMcezp7X2LvecQH3N9OBABA3HFtEjFMmGcLml8Eu2b83HaJrobNm6rYiGhmSbZt4WN
pOHG+PyHYOLjgaczcreIYMxLTVYJpTaDmS8agJvVYwAQIG+QjCVmDSFlGnAjplurYM7+txCcUQVJ
K50ggQzH7uBruJYRc04XSgd0dVpZJSKgn6Uk9rVPWqQKhyCYEOsn9MG51mK7gt2X6DkTnMsVjpM9
rB59jRGWGPE+uR1yeDkTjJJ0nUSiYEoeshRDljbpY2w9YlOzcltZ43lssCHXlYhyHx4adZCoVTTy
wpl9Rk7Yb07snNPIEQJgIaEMRDUQ0ELkLkLkLkNSGEvhu3xBJvMdrfucBLd97yCVem+ZOTC8jptx
l5Jazk6xdgliROkl5cytLIuolunZeR81Qywv57WJGpNvXvstWAgXhJqhfUFiEMMgUQkMsswt3Fgm
vcTf0lONwQOJc0CzCqKsWRrbQS/TLCrWhDgjrmOknS5LroxwWuaW3u0wnM6G0hrhJtrcrwou6M7X
d7Saw0b6uQxVUX04bQKm8qLogofQBTFJ1aEXFDgFBni3ULyAzI2ia6DVSVQUDSLcBQKG/U/PJBE+
TIkpZap0nZDOSUkclWMI0BgvvVtT3a2xjhhKCvQu8EMGsmJ0iuqFOkETzAgbHVuoIDkxe0BNrvl2
Tm6s0tbYaZZY8+uumWmWtL6YiGpDIhgQyIUQohiQyIdOxu3kiaJuJsbMCCNuNUzam5qVisYZ6Z1j
udhImZfXajVaMRBeZKBAClagIGCM7CkcmSKBTp6Zo+OVDn0VsIbkwjmTgVEwvosQtvc6lm5mQgKp
NhJOCBPYqBPlAn18YFXRlsXzTAIHgmOW/bwKwda5JbRlk4w2sWBJhuXUWWm5lR1JisyBIaAyXjGN
h2FVxIyJkyz59vVQohKmXDFDNAsmIWM+jobmq63Gz08T5jqPd3AoL5kT0DJK4o2CpQeQK8BTAg3g
hKq2aXCe7bMhsg9frrNwKCdl4nrFTWeD1WUcTuXFTmUs5wWcL5LYCGRDIhoQ0IakMyG3eSJgzRSp
lqGARGlsK2aSKkmtbXaes4PVgjWTL05i0ojzlD9BM93NxpckTNz1HnuN6kpuHlmTdNm21XJErgzs
9dl2xm22+EYbssm/qbRDdnI2Qr2KaOaG7Nx1MTsCmjggc+tyKBAYg4JyK6PVYUddLntDhqZGWuUL
+kEM58IqysBIamxBIBCHo1puB1Kk1ZeKjbYu/MrNcYwppLn78yBUEcmqykARJgFaAhYHrx4ERZqc
XgFHBzMUgEoC1NuEeRTg6trT3G+/dh1Ny68k8m8ez4Rchjk1dazf1ih245SB1QBFggWAyanqMPJn
k23OkXJqRWDXDDAQxIaENCGwhbKU2kiaxGB1DkEpAgCFLu8IYwVGH4qxco8MmKNsCIJNxXMG0MCW
KvC1QRBJO/TMwc+2jlQEB0YNAbipPKnlXETbSEWwCBAcs1ifWnuTtR4A9Tbxw0Vw6bl6FNOJsMxi
UlYMraIaGLHOReDlARSPTXmxzqrXnsp5Fi9ei2KxXnFFqMKUO4xk1QP03D5ya/UXBSSgw7/8Dx0T
ra+87BkGo7+k5Hz9c8YPifON4noQsSe96m/xdPi7O+0jMEQOsLrMnqjpbnkwbCozt64Zd2E28Wc4
xbLvhpiIaEMyGutbyRNlxncIjDNfJNs2y+GnGMtWjtJEyF8/oYEvhouSJsjKp304Y7sPDRfjWpDR
rjchv5tWRjeoxIFPKSSRDlmTHwFm5RkZGy2OEyiwS+2DzES9ZT226nObTn422ONlaRc4dOL2DW9E
VEzIR3hM6c6u3rSoguJMfqMJjCkaOlM6nCaZ8qdg7V50a6T4bXvXqb2JDl5uNue07ilIpRSiXjpW
0JatB4au0dXlG9CjlHVh6NKMbiIJ1YBhEEgzkZzd7EVWGIIZTLdVaEzXiTkz4XU5yGeOOTjTyyEO
NZc19jAhkx11RszuPDZZfW1akLnb5Z7VuVm27lDmc3XW6qtuIXkeWq2q1QyeDpwzIbna5sHk1vaX
XplENzALutsTqU3CUWyXmgFJwDYi+kc8ZrCWZMOQA4LpLwRcB1j0JP4AWlxUYBeKqBFRKXxWlgSo
YlzzOwGVs4xWUSGpsA3JJ6S4G46V3lp6JnrDvDIEDo2x256q3SspMgnQFeatGKrCFWa0C1VbTloq
wheMYKpTioArVsnWCNDnQdjI8JwOcTlC5YEbFJquRI3CQSvmzsirDzAmCgWsqrRyxIhQcdiwaGo+
gIkyCOWMsyE7oiPfsGOyIZTmgS39ZKPDBmQWqjApO9rEsjK0YBeaX8xW5Ha4GkTIFGC6YCGCpnNw
zUnrOE2ZgNKqpwFKkoAY5AKxC5oQv6B+XChPb1OQk1dzhFodSIdYcDkFjG5XWyq3PGGXNOceE+fD
QWEauqtmd4WJm3du8itiGANayqGgI1A3AyOfApKq0rZAjIqRK0u8WeLkUUS4qblWRN/R6npJaTrf
NlaEgBwcMRVWQPICURSMjiG1ipV1nNM1CuO6xayq5Utcsbm6Il1cCEzdGcMEStcVZ5vZDIY42w8B
lPGWHX18zVt4eBgu6uLckxlyIXLl5a8cTV+34gTa4Y7gNe2/HPgAyIEtOUz3uzrqbF9JXXVpgKdI
qYjEVtGZFRaiZVcXIyl8GDCJkLElC4rAQy4ISZ88ggdOvf8c+l2YDAi2ui6ure10UUUUUUUUUUUU
UUUUUUUUUUUUUUUWmkUUWjnTMseuvZp9XwedfVj8OM5EgyCE7hrAgUBLBOFgsKFGpDeCej7CKRoQ
r/ZKUeF73VPnU7FXVEIhYZzYVKUlBk6sKGg2FMViKKqQKxIdgD3J47AqxW9QEQzApj7G5uFYiR7D
/YIcmv5kQq6wEDzAh8fR/Mw/EEPrrQVdSIfD3iIevevAk4cL6dI7FJGMCIyBJIB8EQqI/ti+7/1S
f5MQuc61niQdnNCq9icj6fr/zIN1tei/oo3NP/FV2YFV9s9oiHe4gQ7yIfLi2WIhyV3YfBEKvlEP
HpnQQ8+LaQ/zvjO0r5Wf0vYp4a+8h3JaIYUQxv7adbHy8Dx64h3T/KIWiH9SIbq5EPh1Zf8TsRDj
kJJMtSSLtNCIVYJK8OjjFzG0Dg1PO+DWIhrtAUFe/SkMqiSSfNEP4ELohz+YQKEHXEMnIhyRD3+5
0fZwiGyId3ESSdm8h44YY0SSTCnH2PinY5RwZbqIabIQSjxPebp4In7wBAGkn3fIE/TPTuZCChhS
be1EMLU4h+GfxIhXeqq5wFWmnTk9ZbJ6uSybTfoiHDj7gIcgCrZOVEKssQVbNid09Pvq/8Hp5coh
rEKSHuiFRCoh2kkirssSEEThIMqfHIPgiA/GiLhYR9m96OQ6DGhCDtEIOzTdj1QQ3CEGDZeHvu/I
hzwQOAQaZ+j/XqCBsSG32yIafoiHVZ3fMRLAlCCiFEN5D2xC9iFYe2SHaiJKma/Woy72ycuCrLtk
I+FkIIJ/VyfjrDpA8vN8XOTLXPOKjMB4eZFHavOyJYDRJ/EogBYaEK+WOMYwRbCMZFWCTSEkf7yJ
LXz5f47IQxEwk13YwjGEM2WVEMkQ3MLQj9zaQ8CzP8rZQhT9X9v7/8FzLPZwEoGYFvPj7jG5Ii+B
ES+499G3UUPGgITXcfWgnAtoD4Fh8EDGAYDWlbtRXa4jjKDm4i2zfaF+crazepmQ4yEPx8Ox16t9
93QeMSTPlW9EOvobP2MAk7+m2HVwsNZshtiHmHHLzWW9i68/WXcBfXiBqRRqrv91R5cIXD6wQtUQ
qRExgXWTpcgwgTbmArdHeiioB78H7hEIijCKlRhd/9o8xxp9vPY8iA6dQIQVHSTndAnVMyHF3S5I
69/6bfugb358uqn3pIm/dKH9dc0emVrjPktCF4R4VZUEPgCi/adgC7izUjF0p5szNHFZWqVwtfbx
PCmKE7wgJHHl7ZBX6NfZ7BiiSYPWsssx3h7TSJksIuJgueUAWhZXotm0ImvtJLqYArHeJVEPMyUh
usLboVqlbaceNGLr3uN/rjxdC3vyiGBCkIfluwn7ML1tPAb12BCc1cFZfOkNgRNtv0vzMZGJDeRI
7aIHYoIjsdXTicMSRJxoQ8WliGVmS5Ejmoh30SJ5dNiRDFRDZMmK5BHbewRGk9FiRPBwISI7Fcix
oQjgDJ1HFKu4jPNnCepzGBNGYBVSORCYmBgDPLCdCCssMdNnRIl+8qKKdh9I8y9WwV2PUKeEIV1R
gN6rJJPblmI/Caegm1cQmxRG54gJ1W0kIj7HyMIVGSsEKQRCd1cQB+pXgCvbkVDSIqbl1SHbo04h
IdoOwGc3oQL8U71JVAxU7LQkWXsJIFpVf+MbWbkQuwphWF7fT3nQTK/xabzv5SAa/MD+Mg/uHci/
wijC5VHaR41QoigNQUSMK9CO+J9gJQVD6PALissJgIh9bT1IAaGBziewp9UKTFpQYh85CkS4AwNK
ggJ7Ci8fDgEc89pZzw36QOMGSQXzPQv3TGV17dzDRJgBZakF+hoI4bQR7EltPEsNaoEJI40KpJIX
oyAlLNXhGqMXqhukX5yHMIe8ht7Pj7AeJC1hj1iGNTP6pootjNYhmQ56Xrbh2324xMetb7vXEODC
63z6NG2uK5Im6s9HLbe8cTnhDnYTfpjx0iSc3ZaBskxzSFyex2u/jL201fhPr4d+H16yNmxI6iRI
gHnPEX2avz0KT0NTw1XGiwsusPVu8SdzXLNESB4V7/ENW2SAVSwRIpTOjq8e/1cE8gT1E6yecDxT
xqlNaqlRSWlWq02I3pXYEtElQhULWhDGEVXxK+gEg2OSSFC6uQa+TTRpTDKnocbqjoDOQ+hFJaOr
EhIwPT6UJGPBxTFnvlfCjTM2yNHF2Rl4+nR8U+voxPSa0jYdWcPb9URz7ot9hZvrBcaAO6ODO7Lf
23ayThZthIeyU67LX3u17KUMKcB0+El44dSJK46+6LqvzAsx4cY82hiAc2UEeD3eADwCkwXUp2pE
j11nTo98ioQyZeRDVh7au7u5lbVahtPr4tjkll1CoDc0aqgd1VQDEqVeT94ItvaQnnzuNdS3W/Ln
C+UjCrDDC0y6oSR2oDB6BICk5F1lMdxuD1YzSE4EyQkFRslrtLze1tL9o9yN3QMoQyzn91Qkm+kx
GHc5sF6qdkQ/XrwFX0xTSp9CuGy3VSQ5RzhMsf1/ZSQq1/0SLRlzAw6yRN49YkOPYqQpHsbfCBDz
kO5iOJzeXSNJDy7/A5nCbk+Gjum1INK0ndnHrWuK5JlEFMaKXH0cz0xxAa2uCdJImfNbatzw5TRm
kVosQnXj0YLEavWQnzOpVM/4AzhBgv5BBw5CsEM538WEdndoh2AwhC71PaYtSFESccx5Of5Ni0/V
ZZUghXMparVt+RfuGBGKh9trfbI9sk+fqM2EWJQjQYiENX/eGsArzeSDjN2geYHwn2ftek6EU8ol
RYO5FcPDtj5KfTe+nQpTarpT7FPh9XeQvLXFmT7IvhCMRGfb3xIcB6EiwY5SxuTLeZ6x3nlxlDFj
QQ6+ywIJCqJCXt8ouvfB9R5Ijo0ohzyfV1vvj0fqPmfGTT6EiR4r7cEcYYJmnQ9OTi6obyIcsmwh
fyryHDajfCOJDq2DygLaAdJbtxATxfiw1yMjwIbUSzqAuIqHasoUZaiHTikPf5SN6H4VE00WY9BC
cML4CU7pIf9urGSHhElBODh2XhDn2edcKd9kkgsxT+LL+77h8RsG6GjUVRFUKhCkQ2vwjo7U3zjV
VWWRD69IRjLM/ZCPbe9QxlyoqqZmr/hR3NxjGINiOXm/YXrzeVveRAsCo6SilDjQDUCDrR5HinDA
4YHJhOGHMjavOhi3kksyn5OpmXdU9RTrVOenqTWSfpEO+bVQMd89GH5CFiGbs/BO4wiTwk9kl+ZP
kz3eh7OP4nFd02jlFrdcEqXB2M5BiOP6CcWQO+aGRVGhQ+whR7+o18tzgXFUCHD7GUiN2pGTogXJ
9fPSxMkiRj17EiRhsy3kODbCSPnIfVo/TJPi3XzEKeuG2jdI43/PaBlFeBXiYT2OO3jIkWDzSdZO
SoUATAWgIfEiet5EPv4ua7V73l8H0cBIV7ciF21KkE72Mo5o4MBl9HR9b1WtX44fiqKw22ZcoQai
kl5PGW+QQ9aGjAMMnDczFBE5AIrLymj6XVCHU8c6q5LYzvo40m5G0caHfk83ZUY/XMqFRN8i+4ak
f2GNI/J57446/KBuubWfEFKw3wQsMmWazxuGut1wEGySgbi1L2Vho92MjSBqyExwH2R+Jm5zY25E
1E80tsUiQ3B0B2QhzkwkkYkgYgMCDNCxCSQAWoSUbpgR25w/P8aZTMJoiSNiPfedM3VQrizbtsYk
TIRJVQgpWskfBdk3jTmweLZHHxo/foLWNrNZoA9HTc2GJbhlmMSREgc+VrAlYWgf1Jmz1+oe3QTJ
6fH7VdJKWnq7pLNBwpjQvPtSw3M3/mA9ARcNrzEyCajzax+T4kHPRCcHXwfS+qU90UsqxSyrH1Tm
kSDeUR+kinRnG8RUzO8ClVYGDyEkQihFC/TbQwmPAcfaWRs6sSlAOPTadfQpmTkshglIwQ8aK4kQ
qnH11CKWGf6AzQGTK9RjAfuKwQwqo+65wG1FGY6jNb6CbvCW8SI72v10cnS7ohZ2kPp6Uj745Dak
ffyPvOiR1jToOv9HuFiUSU/PcRyRDPsipsHI5Sbde6NTxXW30qh0T59v7SGx3VKqDgcO1Ue3Wdeo
9blsxAqJYzawlP4pZfmLQvQhLHQzebsgnjRePO0fHE2zfGDofl8f84R2pITZ0iECZ4K+e0h1mhDA
gG6CSyShzznXsUPyPKQsZRMqi0iSLELIJ8B892Dnkqd8Q7SxIb1aWwuSJV7AmjfCSOjb0tc9eyRb
MiT5iFZH7pTPMJ7Lv2estNmi11ft9J4aTCp6DmFyPn6T0cFBCl+WU4Ldz2lfivEU7SqxISoxHhEU
P63bRyI7yHhsPqNm27/BCuCexjOhWC1oVCpYWRLJxfNFnk4MrjhaWFKFREP3SnoQ+JDTDh3WELEK
IUQ24REDM+IYYiy2jJXhEEB2pKcUh+eecyImgwm1p3X25J1SQq7eTZ/avkQ0JGMXr6/ux0GU1p3U
EPP0BaoXabVdQ28gfZPACEGDAYMBgwGDAYMBgweMEJiNvPVzYu7LFEMejpIZvXUUpVCpVU6SZbiH
q60biG6ni3Rb7Qm6iEqhB1ELoQO93Q1hO7N0APG5Sc6LFFIoKKL2ZTWiHnB85CSSTfdqI9KYzKvK
m7elx9QVX9lWeftGTIhg7cEQuQphvtevoVZEMMV8FSRJS7vuWSRKkZq8/mu/yYOK6oRVQhQhnGsk
MJfKJOsXfYSpgQ/axs5TVveqIZxDmX24ccOa2GWLGsnwvdezNS2d8HymNBCsNObO2jPJSIYa2tU2
YDKpdnREnT8CHAEOoSiJFCUEKEoQsQ1sSJcUSJRKEiXIUEiZvkuQuJEwJQkT2rkLBIlEKEiXJQkT
6e/AhckE9cjXVzirQ4VHNwwpaSnpRzF8A1KCysBppBDFcCGpVGtA9MZCQSSMNdatGgtCNL1iW2Yb
O/lKmOmH6c3tF7a0x6pwprxIk6Hp3277TFeEsM+XXCMIVeWnMLb5IU3j5X6AtEuiZ5ZXXu6eqyEl
Q/It0522KbSWkhgJZmmf98cSuohZ2s2d92sTCN9Elxrmm2CH9a/WQ6ohpO8fBzvg1J3/RHR8cO+I
hs+loSQ4kJ938bPZ1p0+sdspRD9+5i3sFCb/EdOPhlkwiFnP1JuqEMFEM6IZ7CGlqi2KZRIvnGY6
Nse6Rf89XveMeEIdrgkPphD7nM4I80mlKNwme3gyfuc+aQ505Q2HF5m9h1G/VXT63Xu0iHk5mnKY
nx4bZo+S0I+0hSSE6oYwj0k8Xzj9qcTYQ8+LlDiE5J3Nn3Op4O1/qGyLNRJr7X43M1reBUC1UQvi
uQ1yoYPJaWe60hxJmWiIZkO2RunL1HwdAh+dZaTQhviJ+L2jXrVT1qPhsRwr2CeJ59CGdRMWcpUc
zLVwFaBn2mwzPxfMm+9wMQOb8BdyRThQkFwv334=


--===============0405208312679093219==--