System Variable optimizer_trace_limit Scope Global, Session Dynamic Yes SET_VAR  Hint Applies No Type Integer Default Value 1 Command-Line Format --optimizer-trace-max-mem-size=# System Variable optimizer_trace_max_mem_size Scope Global, Session Dynamic Yes SET_VAR  Hint Applies Yes Type Integer Default Value 1048576 Command-Line Format --optimizer-trace-offset=# System Variable optimizer_trace_offset Scope Global, Session Dynamic Yes SET_VAR  Hint Applies No Type Integer Default Value -1 Command-Line Format --parser-max-mem-size=# System Variable parser_max_mem_size Scope Global, Session Dynamic Yes SET_VAR  Hint Applies No 854 • parser_max_mem_size • performance_schema_ xxx The offset of optimizer traces to display. For details, see MySQL Internals: Tracing the Optimizer. Performance Schema system variables are listed in Section 27.15, “Performance Schema System Variables” . These variables may be used to configure Performance Schema operation. The maximum cumulative size of stored optimizer traces. For details, see MySQL Internals: Tracing the Optimizer. • optimizer_trace_offset • optimizer_trace_max_mem_size The maximum number of optimizer traces to display. For details, see MySQL Internals: Tracing the Optimizer. Server System Variables