Documentation Home
MySQL 9.2 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 259.7Kb
Man Pages (Zip) - 366.9Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


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

10.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.