When the XPLAIN mode is set to 1, statements are compiled and optimized, but not executed; when the XPLAIN mode is set to 0 (the default), statements are compiled, optimized, and executed normally.
The XPLAIN mode only matters when XPLAIN style has been enabled. See the
See "Working with RunTimeStatistics" in
If authentication and SQL authorization are both enabled, only the
To let