AWS Aurora mysql 8.x version "Explain Plan" not working.
Answered
In mysql 8.x version, the explain expanded command deprecated, so Explain Plan does not work.
Is there any solution?
Please sign in to leave a comment.
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.