Search Results
https://dev.mysql.com/doc/internals/en/non-client-plugin-auth-clients.html
This packet does not contain new authentication method name, which is implicitly assumed to be Secure Password Authentication, and it does not contain new authentication data. The only situation where server will request authentication method ...
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/null-bitmap.html
The binary protocol sends NULL values as bits inside a bitmap instead of a full byte as the ProtocolText::ResultsetRow does. If many NULL values are sent, it is more efficient than the old way. Caution For the Binary Protocol Resultset Row the ...
https://dev.mysql.com/doc/internals/en/old-password-authentication.html
Image description Warning The hashing algorithm used for this auth method is broken as shown at http://sqlhack.com/ and CVE-2000-0981 . Authentication::Old: auth_method_name is mysql_old_password client-side requires "8-byte random challenge" from ...
https://dev.mysql.com/doc/internals/en/optimizer-code-concepts.html
This section discusses key optimizer concepts, terminology, and how these are reflected in the MySQL server source code.
https://dev.mysql.com/doc/internals/en/optimizer-joins.html
This section discusses the various methods used to optimize joins.
https://dev.mysql.com/doc/internals/en/optimizer-late-nulls-filtering.html
This optimization reuses the null_rejecting attribute produced by the early NULLs filtering code (see Section 7.3.1.1, “Early NULLs Filtering”). Suppose we have a query plan with table tblX being accessed via the ref access method: ...
https://dev.mysql.com/doc/internals/en/optimizer-nulls-filtering.html
This section discusses the NULLs filtering optimization used for ref and eq_ref joins.
https://dev.mysql.com/doc/internals/en/optimizer-other-optimizations.html
In this section, we discuss other, more specialized optimizations performed in the MySQL server.
https://dev.mysql.com/doc/internals/en/optimizer-partitioning-related.html
See Partitioning for general information about the partitioning implementation in MySQL 5.1 and later.