Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

发现soar对mysql 5.7.32不输出执行计划 #289

Open
czxin788 opened this issue Sep 2, 2021 · 1 comment
Open

发现soar对mysql 5.7.32不输出执行计划 #289

czxin788 opened this issue Sep 2, 2021 · 1 comment

Comments

@czxin788
Copy link

czxin788 commented Sep 2, 2021

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

@martianzhang
Copy link
Contributor

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

Explain信息

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

# for free to join this conversation on GitHub. Already have an account? # to comment
Projects
None yet
Development

No branches or pull requests

2 participants