Search Results
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 ...
https://dev.mysql.com/doc/internals/en/providing-index-information-to-optimizer.html
This information is used to choose whether to use an index, and if so, which index to use. In order for indexing to be used effectively, storage engines need to provide the optimizer with information about the table and its indexes.
https://dev.mysql.com/doc/internals/en/pstack-directory.html
This is a set of publicly-available debugging aids which all do pretty well the same thing: display the contents of the stack, along with symbolic information, for a running process. There are versions for various object file formats (such as ELF ...
https://dev.mysql.com/doc/internals/en/record-contents.html
This section is still to be written. ...