Search Results
https://dev.mysql.com/doc/internals/en/optimizer-order-by-clauses.html
For the query: SELECT column1 FROM Table1 ORDER BY 'x'; the optimizer will throw out the ORDER BY clause. For the query: SELECT column1 FROM Table1 ORDER BY column1; the optimizer will use an index on column1, if it exists. For the query: SELECT ...
https://dev.mysql.com/doc/internals/en/optimizer-tracing.html
The interface is provided by a set of optimizer_trace_xxx system variables and the INFORMATION_SCHEMA.OPTIMIZER_TRACE table, but is subject to change. In MySQL 5.6, a new tracing capability was added to the MySQL optimizer.
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
The information in the key is obtained by iterating through the key, which is formatted the same as the definition in table->key_info[index]->key_part[part_num]. Many of the index methods pass a byte array named *key that identifies the index entry ...
https://dev.mysql.com/doc/internals/en/protocoltext-resultset.html
A query like SELECT @@version_comment returns: 01 00 00 01 01|27 00 00 02 03 64 65 66 00 00 00 .....'....def... 11 40 40 76 65 72 73 69 6f 6e 5f 63 6f 6d 6d 65 .@@version_comme 6e 74 00 0c 08 00 1c 00 00 00 fd 00 00 1f 00 00| nt..............
https://dev.mysql.com/doc/internals/en/providing-index-information-to-optimizer.html
In order for indexing to be used effectively, storage engines need to provide the optimizer with information about the table and its indexes. This information is used to choose whether to use an index, and if so, which index to use.
https://dev.mysql.com/doc/internals/en/query-event.html
Note only written if code > 0 (aka "en_US") Q_CHARSET_DATABASE_CODE characterset and collation of the schema Q_TABLE_MAP_FOR_UPDATE_CODE a 64bit-field ... should only be used in Row Based Replication and multi-table updates ... Binlog::QUERY_EVENT: ...
https://dev.mysql.com/doc/internals/en/replication-organization.html
An example of a rule is "at ROLLBACK when the transaction cache only contains updates to transactional tables, clear the transaction cache and do not write to the binlog". We distinguish between two levels of the architecture: principles, and ...
https://dev.mysql.com/doc/internals/en/secure-password-authentication.html
The password is calculated by: SHA1( password ) XOR SHA1( "20-bytes random data from server" <concat> SHA1( SHA1( password ) ) ) .