MySQL Internals Manual  /  Tracing the Optimizer  /  The INFORMATION_SCHEMA.OPTIMIZER_TRACE Table

8.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).


User Comments
Sign Up Login You must be logged in to post a comment.