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.

  • INSUFFICIENT_PRIVILEGES: Explained further below.


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