The Ultimate Guide to High Availability with MariaDB

SHOW EXPLAIN

You are viewing an old version of this article. View the current version here.

This is a preliminary documentation for SHOW EXPLAIN feature.

The code

The latest code is here:

https://code.launchpad.net/~maria-captains/maria/5.5-show-explain

Differences from EXPLAIN output

In MySQL, there are parts of code where EXPLAIN execution takes different route from actual query execution. When one runs SHOW EXPLAIN on a running SELECT query, it will examine diff

  • There can be "no matching row in const table". 
  1      SIMPLE  NULL    NULL    NULL    NULL    NULL    NULL    NULL    no matching row in const table
  • AAA he

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.