Search Results
https://dev.mysql.com/doc/internals/en/optimizer-primary-optimizations.html
This section discusses the most important optimizations performed by the server.
https://dev.mysql.com/doc/internals/en/optimizer-trace-implementation.html
A trace is started by creating an instance of Opt_trace_start; information is added to this trace by creating instances of Opt_trace_object and Opt_trace_array, and by using the add() functions of those classes...
https://dev.mysql.com/doc/internals/en/optimizer-trace-testing.html
This feature is tested in mysql-test/suite/opt_trace and unittest/gunit/opt_trace-t. ...
https://dev.mysql.com/doc/internals/en/optimizer-transpositions.html
If an expression of this form refers to an indexed column, then MySQL always uses the index, regardless of the table size. MySQL supports transpositions (reversing the order of operands around a relational operator) for simple expressions only. In ...
https://dev.mysql.com/doc/internals/en/optimizer.html
This chapter describes the operation of the MySQL Query optimizer, which is used to determine the most efficient means for executing queries.
https://dev.mysql.com/doc/internals/en/other-unsafe-statements.html
Status of this subsection: not started 2009-10-21 INSERT DELAYED LIMIT System tables .
https://dev.mysql.com/doc/internals/en/packet-ERR_Packet.html
This packet signals that an error occurred. It contains a SQL state value if CLIENT_PROTOCOL_41 is enabled. Payload Type Name Description int<1> header [ff] header of the ERR packet int<2> error_code error-code if capabilities & CLIENT_PROTOCOL_41 ...
https://dev.mysql.com/doc/internals/en/parsing-key-information.html
If a bit in keypart_map is set, the value for this key part is present in the key buffer. Many of the index methods pass a byte array named *key that identifies the index entry to be read in a standard format. Your storage engine will need to ...
https://dev.mysql.com/doc/internals/en/perfect-cleanup.html
At the end of the test, you need to drop just this database. Cleaning up becomes much more comfortable and less error prone if you create your "own" database and create all tables there. Do not forget to remove all users you created and all ...
https://dev.mysql.com/doc/internals/en/plugins.html
This section describes the command-line options that are used to control which plugins get built, and the CMake/autotools macros that enable plugin configuration support to be described. Beginning with MySQL 5.1, the server supports a plugin ...