How to Collect Large Optimizer Traces
Optimizer traces can be large for some queries.
In order to collect a large trace, you need to perform the following steps (using 128 MB as an example):
set global max_allowed_packet=128*1024*1024;
--max-allowed-packet=128000000 for the client as well.
set optimizer_trace=1; set optimizer_trace_max_mem_size=127*1024*1024;
Now, one can run the query and save the large trace.
- optimizer_trace system variable
- optimizer_trace_max_mem_size system variable
- max_allowed_packet system variable
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.