Search Results
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-trace-testing.html
This feature is tested in mysql-test/suite/opt_trace and unittest/gunit/opt_trace-t. ...
https://dev.mysql.com/doc/internals/en/optimizer-union-queries.html
Therefore, for this query: SELECT * FROM Table1 WHERE column1 = 'x' UNION ALL SELECT * FROM TABLE1 WHERE column2 = 'y' if both column1 and column2 are indexed, then each SELECT is done using an indexed search, and the result sets are merged. Notice ...
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/public-key-retrieval.html
If the client doesn't have the public key it can ask for it by: sending 0x01 as auth response in the Protocol::HandshakeResponse41 server will send a Protocol::AuthMoreData with the keyfile client sends the encrypted password .
https://dev.mysql.com/doc/internals/en/select-simple.html
For performing single primary select, SELECT uses the mysql_select function, which does: allocate JOIN JOIN::prepare JOIN::optimize JOIN::exec JOIN::cleanup In previous versions of MySQL, all SELECT operations were performed with the help of this ...
https://dev.mysql.com/doc/internals/en/text-protocol.html
The old commands are supported for all MySQL Server versions from 3.20 upwards (and perhaps older). Additional commands implemented since then are described in sections following this one.
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 ...
https://dev.mysql.com/doc/internals/en/transaction-management.html
In each client connection, MySQL maintains two transactional states: A statement transaction A standard transaction, also called a normal transaction .
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-annotation-nullvalue.html
Enumeration of the "null-value" behavior values. This behavior is specified in the @Persistent annotation. 4.3.2.9.1 Synopsis public final class NullValue extends, Enum<NullValue> {// Public Static Fields public static final NullValue DEFAULT ; ...