Search Results
https://dev.mysql.com/doc/internals/en/ndb-directory.html
We generally use the term "ndb" when referring to the storage engine, and the term "MySQL Cluster" when referring to the combination of the storage engine and the rest of the MySQL facilities.
https://dev.mysql.com/doc/internals/en/new-authentication-method-not-known-by-client.html
Even if client supports external authentication (CLIENT_PLUGIN_AUTH flag is set) the new authentication method indicated in the Authentication Method Switch Request Packet might be not know to it. the client connecting to the server the server ...
https://dev.mysql.com/doc/internals/en/non-client-plugin-auth-clients.html
The only situation where server will request authentication method change from a client which does not set CLIENT_PLUGIN_AUTH flag is when the following conditions hold: the client connects to an account which uses Old Password Authentication. the ...
https://dev.mysql.com/doc/internals/en/not-so-fast-path.html
If the servers default auth method doesn't match the clients or accounts auth method a extra round is needed as usual. server uses mysql_native_password as default: 4d 00 00 00 0a 35 2e 36 2e 37 2d 6c 6f 67 00 01 M....5.6.7-log.. 00 00 00 51 5f 5a ...
https://dev.mysql.com/doc/internals/en/optimizer-code.html
This diagram shows the structure of the function handle_select() in /sql/sql_select.cc (the server code that handles a query): handle_select() mysql_select() JOIN::prepare() setup_fields() JOIN::optimize() /* optimizer is from here ... */ ...
https://dev.mysql.com/doc/internals/en/optimizer-constants-constant-tables.html
A MySQL constant is something more than a mere literal in the query. unique_not_null_column INT NOT NULL UNIQUE then this expression FROM Table1 ... These rules mean that a constant table has at most one row value. MySQL will evaluate a constant ...
https://dev.mysql.com/doc/internals/en/optimizer-index-merge-join-type.html
7.2.2.5.1 Overview Index Merge is used when table condition can be converted to form: cond_1 OR cond_2 ... OR cond_N The conditions for conversion are that each cond_i can be used for a range scan, and no pair (cond_i, cond_j) uses the same index.
https://dev.mysql.com/doc/internals/en/optimizer-late-nulls-filtering.html
Suppose we have a query plan with table tblX being accessed via the ref access method: tblX.key_part1 = expr1 AND tblX.key_part2 = expr2 AND ... Before performing an index lookup, we determine whether any of the expri values is NULL. If it is, we ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-selection.html
If a partitioned table is accessed in a series of index lookups (that is, using the ref, eq_ref, or ref_or_null access methods), MySQL checks to see whether it needs to make index lookups in all partitions or that it can limit access to a ...
https://dev.mysql.com/doc/internals/en/optimizer-primary-optimizations.html
This section discusses the most important optimizations performed by the server.