From: Ole John Aske Date: February 22 2011 6:43pm Subject: bzr commit into mysql-5.1-telco-7.0 branch (ole.john.aske:4219) List-Archive: http://lists.mysql.com/commits/131877 Message-Id: <20110222184341.772A8223@fimafeng09.norway.sun.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============8193905196386613221==" --===============8193905196386613221== MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline #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; --===============8193905196386613221== MIME-Version: 1.0 Content-Type: text/bzr-bundle; charset="us-ascii"; name="bzr/ole.john.aske@stripped" Content-Transfer-Encoding: 7bit Content-Disposition: inline # Bazaar merge directive format 2 (Bazaar 0.90) # revision_id: ole.john.aske@stripped\ # a5t991325ifdf3wz # target_branch: file:///net/fimafeng09/export/home/tmp/oleja/mysql\ # /mysql-5.1-telco-7.0/ # testament_sha1: 739a513d44742c175095ba0210175dbc7dbbd357 # timestamp: 2011-02-22 19:43:41 +0100 # base_revision_id: ole.john.aske@stripped\ # mvlio73dc0dwia76 # # Begin bundle IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWRE67OoAB0bfgAAQUuP//3t+ noC////wYAj/HHh07XGtAKBzAHEKBQHCSk01ND0Jom0yjyIGTRoNGymjRoADmEwCYATCYTTAAAJk 00DCU0JoRGEkaNRkyNNAAAAGgBqf6pKnmmpRkANAGgNAA0AAAcwmATACYTCaYAABMmmgYKkkTIAC aaJpp6Jpk1T01NqeRG1ND2kmnqaerplVCJ+78L+nc3a+FxD0IdBCxCxDTISX8rZiGTqqOVRVRaot UVRdYpRSilFKKUV1Y4Y9whjw+euoqoRP2/IYYPZNLVbLoStYEuKEq2IiIEt+wlnKxSvek8Ye0ju+ KHd74JmZkd3zkd3znOC5QWJoHl3RV3dFqd0ZRqDA75TOnTUi1O6miE02qk3Yqm5ddddqmmtN7Ghp gxuve9zOTOcXwuphlTZlTK66642ZU2ZU2ZUy2Uyuuuu1aNVNWio1bKWwtlS1Kba1o1Utotq2Uywp su9/QktJwVaWhrBBtsBBqBBsBBCCB27GQev9VfsBB9b66fBNM1OPu/jiktJwcO9XFw97tei1LTfk tJrxgAAAAAAAAAVVVVVVV5whwIY7SG/obUemzwT7Oerw0TZXOVZ8D9FEEaRiSQ5ewIJ4bzqZXCjj a3A2SPQ6FiTGpaphSY0FvfaRFqZamWpL6ZahjVrlw+Fxh2LEXE/EjFGi0JHNDoWfInsUQdtZMBlk o8zTH0VsMMEDMyKw60002p36bO94vN51rAvToH1IwdBj2jbb5KGZuBibQ2J437bHI3eqoY1Wjvl7 wvyjLpXLOOJJBjwaTwC4nxGnGYbhM9p4oH3t49ABlzM77wREuofSZHp7WSqm9YNjtZYrCocuWfR1 WqrYsEYosbc1LOrKyuN5cmx4QcCPSc94oDW3kcLHs683Bg4z1N8VmaqNpqovex0MhcQ2Bq5FBgbI 4XEWPI48mRoLUJM5bKScIjwLtprHxE+Ib1VgW72HjrmLaP1e8F72e82TT0PFYo7l6NS9yhGRGSRn LN3YOSS7dw5LnqLki2E56EWEEkuTRk6HAh385160GAGV0sqUtpp1Eq1o81jJgMOJyhHnLDh7KMmi JDeBOekPDkIDN+5J4PRkcIz/3duUNHunA3lL+KuuObWedd4i6qVez1PUo3Lj3KyHBTcpM/TiyL16 jQ1tGlV5wzzTJp78OFMunW/TerPVVxalVTeZkbvfU67GpDhpcchkHlas9BSZZDcNJ5sEhr1E5nlq NCjwH66TtERo/WXfjuVPVqV7TezdUILEuVe6TwJHgIo09vQbjJQz2O/tIruG1bXJYXOnbtJiVfry 7vGnE72h6mXtjByX6lyw1QYwJwotmruniwXENxVkoOTGkB4+xHrGk53X+Wxy2qrfiVblyUxUMqVi 8mMOTzoQhCEIQhCEIQhCEIQhCEIQhCEIpVKpVKr6NWvPtefKd3+PfkkZSH9hCrZ6VVfKIfYQ+ZC/ 0IbSH6EMRCxD9SFEN5DIIZ/sIaCFhD7EMhD7kP4IX6iGkh8NuYhmIYkPQhRDYQohRDMSJ9yGwQ+u AheQuIZhDaQ0ayGYh8yHuIer19MIvloh8hD6fXAheohgQ7CFXnN8O5808X95fj5vreIfTZIyQh1b bjaQw/8Q3RC6/uIboh+eiMQgs3JFFQIKDIxCCMEHdPsyzkRbZFMAguZkkhURLW+1tGUttK62ZXgg laxIopSHTfgIP0qKFdBBzyE8lOQnm4DEokxqhM20gXDJfE4dEAheQx/bGbJ9eXMhSushaRuoni4b 63eFv3591vLTqka+nwq2vEoQ0+rvIa6IWZfXjll/fhOO6nXtx4Vv+9mrWQzvKVLvxmnjV3AQ59nZ rXXEMzt9WBDLar0qW4uzo69aaetzY6U7FPH+fbbL2WeUAIOsbnhhyGOFDd/Yb8KpDUCCDQ+AEGbS dILv4JInseGE3Qh4Vu265WPNO12F0cvM1WIdH8+vjk90yGUhRDgeC1S/8vhI63FgTgb8OReZejov O0hwt8va1SOyRZ8BDKIb5m6PPRTZryEPVokZVayHrkhkIXV1a3JUvX3t8qr+nJUipEOkhsxyFCF9 khbDPF1Sp2auXXXTtYTb+PvI3Ho8FW9mGaR20zEh8b3FfyRgCZJBpgV0EFoIKKqpFSdpViYxbrhH ezFubCr5vc9Lc4EPZzq1J71CGWSeFrxD+kwjyb61+65jkEKxzSQ69N27JMhRDxIbyGNym3DEhfm0 6iFOWTN2mYhd+2WRomnZ399fFsiGO4hRCzOQ2Fvzpa/V7NlWIfl5pktdEP4aCFoha/o5cM2+Vky9 up1S8hhoNJTC015IhxzkO/mQ15mesdZC7oIUQ+JDTPLie2dLxccu6f1bk38s84y+iGEyanqY7d7o Mcf+LuSKcKEgInXZ1A== --===============8193905196386613221==--