AWS Aurora mysql 8.x version "Explain Plan" not working.
已回答
In mysql 8.x version, the explain expanded command deprecated, so Explain Plan does not work.
Is there any solution?
请先登录再写评论。
Hello,
Issue should be fixed already: https://youtrack.jetbrains.com/issue/DBE-15616/Explain-Plan-uses-EXTENDED-statement-in-EXPLAIN-command-for-Amazon-Aurora-SQL
What driver do you use?
I don't keep working.
I am sharing the driver information below.
Thank you.
---
DBMS: MySQL (ver. 8.0.23)
Case sensitivity: plain=exact, delimited=exact
Driver: Amazon Web Services (AWS) JDBC Driver for MySQL (ver. aws-mysql-connector-java-1.1.4 (Revision: 0df986668a29fc700350e005dae40f74396dd337), JDBC4.2)
Effective version: Amazon Aurora MySQL (ver. 3.2.1)
Ping: 224 ms
SSL: yes
The "explain command" does not work even if I use the v1.0.0 driver you shared in the link
-----
DBMS: MySQL (ver. 8.0.23)
Case sensitivity: plain=exact, delimited=exact
Driver: Amazon Web Services (AWS) JDBC Driver for MySQL (ver. aws-mysql-connector-java-1.0.0-SNAPSHOT (Revision: a5d550d801b933c7918501b5dcb23b67b1ce58e4), JDBC4.2)
Effective version: Amazon Aurora MySQL (ver. 3.2.1)
Ping: 224 ms
SSL: yes
We'll check the issue on our side. Please follow https://youtrack.jetbrains.com/issue/DBE-17466/Explain-Plan-uses-EXTENDED-statement-in-EXPLAIN-command-for-Amazon-Aurora-SQL for updates.