MariaDB 10.0 has SHOW EXPLAIN feature. It was coded by yours truly and first introduced about a year ago. Last release of MySQL 5.7 introduced EXPLAIN FOR CONNECTION, which looks rather similar to MariaDB’s SHOW EXPLAIN. I was wondering how these two compare.
The usage scenarios are similar. In both cases, you first need a
connection id of a running query. It is typically obtained by
MariaDB [(none)]> show processlist; …[Read more...]