#At file:///net/fimafeng09/export/home/tmp/oleja/mysql/mysql-5.1-telco-7.0/ based on revid:ole.john.aske@stripped
4219 Ole John Aske 2011-02-22
Updated MTR result file after last commit which changed some tests from using lower- to uppercase.
modified:
mysql-test/r/greedy_optimizer.result
=== modified file 'mysql-test/r/greedy_optimizer.result'
--- a/mysql-test/r/greedy_optimizer.result 2011-02-22 14:49:03 +0000
+++ b/mysql-test/r/greedy_optimizer.result 2011-02-22 18:43:37 +0000
@@ -207,18 +207,18 @@ 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
-flush status;
+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%';
+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;
@@ -230,18 +230,18 @@ 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
-flush status;
+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%';
+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;
@@ -253,18 +253,18 @@ 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
-flush status;
+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%';
+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;
@@ -276,18 +276,18 @@ 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
-flush status;
+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%';
+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;
@@ -299,15 +299,15 @@ 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;
+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%';
+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;
@@ -319,15 +319,15 @@ 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;
+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%';
+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;
@@ -343,18 +343,18 @@ 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
-flush status;
+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%';
+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;
@@ -366,18 +366,18 @@ 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
-flush status;
+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%';
+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;
@@ -389,18 +389,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
-flush status;
+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%';
+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;
@@ -412,18 +412,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
-flush status;
+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%';
+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;
@@ -435,15 +435,15 @@ 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;
+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%';
+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;
@@ -455,15 +455,15 @@ 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;
+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%';
+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;
@@ -479,18 +479,18 @@ 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
-flush status;
+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%';
+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;
@@ -502,18 +502,18 @@ 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
-flush status;
+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%';
+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;
@@ -525,18 +525,18 @@ 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
-flush status;
+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%';
+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;
@@ -548,18 +548,18 @@ 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
-flush status;
+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%';
+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;
@@ -571,15 +571,15 @@ 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;
+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%';
+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;
@@ -591,15 +591,15 @@ 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;
+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%';
+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;
@@ -619,18 +619,18 @@ 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
-flush status;
+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%';
+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;
@@ -642,18 +642,18 @@ 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
-flush status;
+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%';
+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;
@@ -665,18 +665,18 @@ 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
-flush status;
+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%';
+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;
@@ -688,18 +688,18 @@ 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
-flush status;
+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%';
+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;
@@ -711,15 +711,15 @@ 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;
+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%';
+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;
@@ -731,15 +731,15 @@ 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;
+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%';
+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;
@@ -755,18 +755,18 @@ 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
-flush status;
+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%';
+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;
@@ -778,18 +778,18 @@ 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
-flush status;
+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%';
+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;
@@ -801,18 +801,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
-flush status;
+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%';
+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;
@@ -824,18 +824,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
-flush status;
+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%';
+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;
@@ -847,15 +847,15 @@ 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;
+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%';
+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;
@@ -867,15 +867,15 @@ 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;
+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%';
+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;
@@ -891,18 +891,18 @@ 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
-flush status;
+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%';
+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;
@@ -914,18 +914,18 @@ 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
-flush status;
+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%';
+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;
@@ -937,18 +937,18 @@ 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
-flush status;
+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%';
+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;
@@ -960,18 +960,18 @@ 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
-flush status;
+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%';
+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;
@@ -983,15 +983,15 @@ 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;
+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%';
+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;
@@ -1003,15 +1003,15 @@ 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;
+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%';
+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;
Attachment: [text/bzr-bundle] bzr/ole.john.aske@oracle.com-20110222184337-a5t991325ifdf3wz.bundle
| Thread |
|---|
| • bzr commit into mysql-5.1-telco-7.0 branch (ole.john.aske:4219) | Ole John Aske | 22 Feb |
