Tag

explain_format

0 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 8, 2023 · Databases

Customizing MySQL 8.0 Execution Plan Output per User with the explain_format Variable

This article explains how MySQL 8.0.32 introduces the @@explain_format system variable that allows administrators to set different execution‑plan output formats (tree, traditional, json, etc.) for individual users, and demonstrates the configuration steps with concrete SQL commands and examples.

Execution PlanMySQLMySQL8
0 likes · 5 min read
Customizing MySQL 8.0 Execution Plan Output per User with the explain_format Variable