MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 11 to 16 of 16 total results

« Previous
1
2
Next »

https://dev.mysql.com/doc/refman/5.7/en/optimizer-tracing.html

The MySQL optimizer includes the capability to perform tracing; the interface is provided by a set of optimizer_trace_xxx system variables and the INFORMATION_SCHEMA.OPTIMIZER_TRACE table.

5.1.3 Server Option, System Variable, and Status Variable Reference

https://dev.mysql.com/doc/refman/5.7/en/server-option-variable-reference.html

The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...

5.1.4 Server System Variable Reference

https://dev.mysql.com/doc/refman/5.7/en/server-system-variable-reference.html

The following table lists all system variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in ...

2.8.7 MySQL Source-Configuration Options

https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html

The CMake program provides a great deal of control over how you configure a MySQL source distribution. Typically, you do this using options on the CMake command line. For information about options supported by CMake, run either of these commands in ...

8.15.3 Traceable Statements

https://dev.mysql.com/doc/refman/5.7/en/traceable-statements.html

Statements which are traceable are listed here: SELECT INSERT REPLACE UPDATE DELETE EXPLAIN with any of the preceding statements SET DO DECLARE, CASE, IF, and RETURN as used in stored routines CALL Tracing is supported for both INSERT and REPLACE ...

8.15.12 Example

https://dev.mysql.com/doc/refman/5.7/en/tracing-example.html

Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. The complete trace is shown here: mysql> ...