From: Ole John Aske Date: February 22 2011 6:44pm Subject: bzr push into mysql-5.1-telco-7.0 branch (ole.john.aske:4218 to 4219) List-Archive: http://lists.mysql.com/commits/131878 Message-Id: <20110222184402.B1934223@fimafeng09.norway.sun.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 4218 Ole John Aske 2011-02-22 Added missing file from previous commit. added: mysql-test/include/execute_with_statistics.inc === 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; No bundle (reason: useless for push emails).