Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  / ...  / Optimization  / Tracing the Optimizer  /  Tracing Memory Usage

8.15.5 Tracing Memory Usage

Each stored trace is a string, which is extended (usingrealloc()) as optimization progresses by appending more data to it. Theoptimizer_trace_max_mem_size server system variable sets a limit on the total amount of memory used by all traces currently being stored. If this limit is reached, the current trace is not extended, which means the trace is incomplete; in this case theMISSING_BYTES_BEYOND_MAX_MEM_SIZE column shows the number of bytes missing from the trace.