Documentation Home
MySQL 9.4 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 41.2Mb
PDF (A4) - 41.3Mb
Man Pages (TGZ) - 262.8Kb
Man Pages (Zip) - 368.8Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


10.15.1 Typical Usage

To perform optimizer tracing entails the following steps:

  1. Enable tracing by executingSEToptimizer_trace="enabled=ON".

  2. Execute the statement to be traced. SeeSection 10.15.3, “Traceable Statements”, for a listing of statements which can be traced.

  3. Examine the contents of theINFORMATION_SCHEMA.OPTIMIZER_TRACE table.

  4. To examine traces for multiple queries, repeat the previous two steps as needed.

  5. To disable tracing after you have finished, executeSET optimizer_trace="enabled=OFF".

You can trace only statements which are executed within the current session; you cannot see traces from other sessions.