How to collect large optimizer trace
You are viewing an old version of this article. View
the current version here.
Optimizer Trace can be large for some queries.
In order to collect a large trace, you need to do the following steps (using 128 MB as an example):
set global max_allowed_packet=128*1024*1024;
Reconnect specifying --max-allowed-packet=128000000 for the client as well.
set optimizer_trace=1; set optimizer_trace_max_mem_size=127*1024*1024;
Now, can run the query save the large trace.
Comments
Comments loading...
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.
