PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-optimizer-trace-table.html
The OPTIMIZER_TRACE table provides information produced by the optimizer tracing capability for traced statements. The OPTIMIZER_TRACE table has these columns: QUERY The text of the traced statement. The optimizer_trace_max_mem_size variable sets a ...MISSING_BYTES_BEYOND_MAX_MEM_SIZE Each remembered trace is a string that is extended as optimization progresses and appends data to ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-trace-system-variable.html
The optimizer_trace system variable has these on/off switches: enabled: Enables (ON) or disables (OFF) tracing one_line: If set to ON, the trace contains no whitespace, thus conserving space. This renders the trace difficult to read for humans, ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-tracing-typical-usage.html
To perform optimizer tracing entails the following steps: Enable tracing by executing SET optimizer_trace="enabled=ON". See Section 8.15.3, “Traceable Statements”, for a listing of statements which can be traced. To examine traces for multiple ...
https://dev.mysql.com/doc/refman/5.7/en/tuning-trace-purging.html
This is done by setting the optimizer_trace_offset and optimizer_trace_limit system variables, like this: SET optimizer_trace_offset=offset, optimizer_trace_limit=limit; offset is a signed integer (default -1); limit is a positive integer (default ...Thus, if a statement contains substatements (such as invoking stored procedures, stored functions, or triggers), the topmost statement and substatements each generate one trace, but at the end of execution, the trace for only the last substatement is ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
optimizer_trace Command-Line Format --optimizer-trace=value System Variable optimizer_trace Scope Global, Session Dynamic Yes Type String This variable controls optimizer tracing. optimizer_trace_features Command-Line Format ... The MySQL server ...
https://dev.mysql.com/doc/refman/5.7/en/system-variables-controlling-tracing.html
The following system variables affect optimizer tracing: optimizer_trace: Enables or disables optimizer tracing. optimizer_trace_features: Enables or disables selected features of the MySQL Optimizer, using the syntax shown here: SET ...
https://dev.mysql.com/doc/refman/5.7/en/displaying-traces.html
Examining a trace in the mysql command-line client can be made less difficult using the pager less command (or your operating platform's equivalent). INTO DUMPFILE is preferable to INTO OUTFILE for this purpose, since the latter escapes newlines.
https://dev.mysql.com/doc/refman/5.7/en/dynamic-system-variables.html
Many server system variables are dynamic and can be set at runtime. For a description of the privilege requirements for setting system variables, see Section 5.1.8.1, “System Variable Privileges” The following table lists all dynamic system ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 24.2 INFORMATION_SCHEMA General Tables Table Name Description CHARACTER_SETS Available character sets ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 24.1 INFORMATION_SCHEMA Tables Table Name Description Introduced Deprecated CHARACTER_SETS Available character ...