Search Results
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 ) ) ) .
https://dev.mysql.com/doc/internals/en/select-select-result.html
send_data sends given item list values as row of table of result. This class has a very important role in SELECT performance with select_result class and classes inherited from it (usually called with a select_ prefix). The key methods in this ...
https://dev.mysql.com/doc/internals/en/start-stmt.html
When table is locked a statement is started by calling start_stmt instead of external_lock Parameters thd lock_type Return Values This method has no return values. Purpose Called at the beginning of a statement for transaction purposes. Synopsis ...
https://dev.mysql.com/doc/internals/en/strings-directory.html
Many of the files in this subdirectory are equivalent to well-known functions that appear in most C string libraries. On the other hand, some of the files are MySQL additions or improvements. Often the MySQL changes are attempts to optimize the ...
https://dev.mysql.com/doc/internals/en/subtests.html
At least in cases where your file contains many subtests Mark these subtests for better readability of the script Write also a message into the protocol. And please explain what each subtest checks, unless it is obvious.
https://dev.mysql.com/doc/internals/en/traceable-queries.html
They are: SELECT; INSERT or REPLACE (with VALUES or SELECT); UPDATE/DELETE and their multi-table variants; all the previous ones prefixed by EXPLAIN; SET (unless it manipulates the optimizer_trace system variable); DO; DECLARE/CASE/IF/RETURN ...If ...
https://dev.mysql.com/doc/internals/en/transactions-life-cycle.html
When a new connection is established, thd->transaction members are initialized to an empty state. If a statement uses any tables, all affected engines are registered in the statement engine list. The remaining rare cases, when the server explicitly ...In non-autocommit mode, the same engines are registered in the normal transaction ...