per-user configuration

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.