MySQL :: MySQL Internals Manual :: 9.3 The INFORMATION_SCHEMA.OPTIMIZER

MySQL Internals Manual :: 9 Tracing the Optimizer :: 9.3 The INFORMATION_SCHEMA.OPTIMIZER_TRACE Table

Section Navigation [Toggle]

9.3. The `INFORMATION_SCHEMA.OPTIMIZER_TRACE` Table

The OPTIMIZER_TRACE table contains information about traced statements. The table has these columns:

QUERY: the statement text
TRACE: the trace, in JSON format (see json.org: basically it has scalars (number, string, bool) and structures (either arrays or associative arrays))
MISSING_BYTES_BEYOND_MAX_MEM_SIZE (explained further below)
MISSING_PRIVILEGES (explained further below).