XiaoMi / soar

SQL Optimizer And Rewriter

Apache License 2.0

8.67k stars 1.32k forks source link

Open czxin788 opened 3 years ago

czxin788 commented 3 years ago

发现soar对mysql 5.7.32不输出执行计划，连接小于5.7.32版本的数据库可以输出执行计划

martianzhang commented 3 years ago

Not repeat with MySQL community version

MYSQL_VERSION=5.7.32 make docker

$ ./bin/soar -config etc/soar.yaml -query "select * from mysql.user" | head -n 20

Query: C06CF2AA23DD10DB

★ ★ ★ ☆ ☆ 75分


SELECT
  *
FROM
  mysql. USER

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	scalability	Extra
1	SIMPLE	user	NULL	ALL	NULL	NULL	NULL	NULL	4	☠️ 100.00%	☠️ O(n)	NULL