📄 greedy_optimizer.result

📁 这是linux下运行的mysql软件包,可用于linux 下安装 php + mysql + apach 的网络配置
💻 RESULT
📖 第 1 页 / 共 3 页
字号:
1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t6.c62	1	Using indexshow status like 'Last_query_cost';Variable_name	ValueLast_query_cost	821.837037explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	1	SIMPLE	t1	eq_ref	PRIMARY	PRIMARY	4	test.t2.c21	1	Using where1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t1.c12	1	Using index1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using index1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using indexshow status like 'Last_query_cost';Variable_name	ValueLast_query_cost	274.418727explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	1	SIMPLE	t1	eq_ref	PRIMARY	PRIMARY	4	test.t2.c21	1	Using where1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t1.c12	1	Using index1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using index1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using indexshow status like 'Last_query_cost';Variable_name	ValueLast_query_cost	274.418727explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where1	SIMPLE	t1	eq_ref	PRIMARY	PRIMARY	4	test.t2.c21	1	Using where1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t1.c12	1	Using where1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using where1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using whereshow status like 'Last_query_cost';Variable_name	ValueLast_query_cost	274.418727explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where1	SIMPLE	t1	eq_ref	PRIMARY	PRIMARY	4	test.t2.c21	1	Using where1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t1.c12	1	Using where1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using where1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using whereshow status like 'Last_query_cost';Variable_name	ValueLast_query_cost	274.418727set optimizer_search_depth=1;select @@optimizer_search_depth;@@optimizer_search_depth1explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t2.c22	1	1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t4.c42	1	1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t6.c62	1	Using indexshow status like 'Last_query_cost';Variable_name	ValueLast_query_cost	821.837037explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t2.c22	1	1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t4.c42	1	1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t6.c62	1	Using indexshow status like 'Last_query_cost';Variable_name	ValueLast_query_cost	821.837037explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra1	SIMPLE	t1	ALL	PRIMARY	NULL	NULL	NULL	3	1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t1.c12	1	Using index1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using index1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using index1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using whereshow status like 'Last_query_cost';Variable_name	ValueLast_query_cost	794.837037explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra1	SIMPLE	t1	ALL	PRIMARY	NULL	NULL	NULL	3	1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t1.c12	1	Using index1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using index1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using index1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using whereshow status like 'Last_query_cost';Variable_name	ValueLast_query_cost	794.837037explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra1	SIMPLE	t1	ALL	PRIMARY	NULL	NULL	NULL	3	1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t1.c12	1	1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using where1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using where1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using whereshow status like 'Last_query_cost';Variable_name	ValueLast_query_cost	794.837037explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra1	SIMPLE	t1	ALL	PRIMARY	NULL	NULL	NULL	3	1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t1.c12	1	1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using where1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using where1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using whereshow status like 'Last_query_cost';Variable_name	ValueLast_query_cost	794.837037set optimizer_search_depth=62;select @@optimizer_search_depth;@@optimizer_search_depth62explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t2.c22	1	1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t4.c42	1	1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t6.c62	1	Using indexshow status like 'Last_query_cost';Variable_name	ValueLast_query_cost	821.837037explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t2.c22	1	1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t4.c42	1	1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t6.c62	1	Using indexshow status like 'Last_query_cost';Variable_name	ValueLast_query_cost	821.837037explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	1	SIMPLE	t1	eq_ref	PRIMARY	PRIMARY	4	test.t2.c21	1	Using where1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t1.c12	1	Using index1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using index1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using indexshow status like 'Last_query_cost';Variable_name	ValueLast_query_cost	274.418727explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	1	SIMPLE	t1	eq_ref	PRIMARY	PRIMARY	4	test.t2.c21	1	Using where1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t1.c12	1	Using index1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using index1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using indexshow status like 'Last_query_cost';Variable_name	ValueLast_query_cost	274.418727explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where1	SIMPLE	t1	eq_ref	PRIMARY	PRIMARY	4	test.t2.c21	1	Using where1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t1.c12	1	Using where1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using where1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using whereshow status like 'Last_query_cost';Variable_name	ValueLast_query_cost	274.418727explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where1	SIMPLE	t1	eq_ref	PRIMARY	PRIMARY	4	test.t2.c21	1	Using where1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t1.c12	1	Using where1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t1.c14	1	Using where1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where1	SIMPLE	t7	eq_ref	PRIMARY	PRIMARY	4	test.t1.c16	1	Using whereshow status like 'Last_query_cost';Variable_name	ValueLast_query_cost	274.418727set optimizer_prune_level=1;select @@optimizer_prune_level;@@optimizer_prune_level1set optimizer_search_depth=0;select @@optimizer_search_depth;@@optimizer_search_depth0explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	6	Using where1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t2.c22	1	1	SIMPLE	t4	ALL	NULL	NULL	NULL	NULL	12	Using where1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	test.t4.c42	1	1	SIMPLE	t6	ALL	NULL	NULL	NULL	NULL	18	Using where
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -