Search Results
https://dev.mysql.com/doc/internals/en/sql-statement-example.html
FROM mysqltest1.t5 WHERE (f2 BETWEEN 17 AND 25 OR f2 = 61) AND f3 IN (SELECT ....
https://dev.mysql.com/doc/internals/en/store-lock.html
Synopsis virtual THR_LOCK_DATA ** store_lock ( thd, to, lock_type); THD * thd ; THR_LOCK_DATA ** to ; enum thr_lock_type lock_type ; Description This is the store_lock method. The idea with handler::store_lock() is the following: The statement ...
https://dev.mysql.com/doc/internals/en/tests-directory.html
The files in this directory are test programs that can be used as a base to write a program to simulate problems in MySQL in various scenarios: forks, locks, big records, exporting, truncating, and so on.
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/transactions-roles-responsibilities.html
The server has only one way to know that an engine participates in the statement and a transaction has been started in an engine: the engine says so. So, in order to be a part of a transaction, an engine must "register" itself. Although ...
https://dev.mysql.com/doc/internals/en/uncompressed-payload.html
For small packets it may be to costly to compress the packet: compressing the packet may lead to more data and sending the data uncompressed CPU overhead may be not worth to compress the data Tip Usually payloads less than 50 bytes ...
https://dev.mysql.com/doc/mysql-installer/en/server-advanced-options.html
This step is available if the Show Advanced Configuration check box was selected during the Type and Networking step. To enable this step now, click Back to return to the Type and Networking step and select the check box. The advanced-configuration ...
https://dev.mysql.com/doc/mysql-installer/en/server-authentication-method.html
The Authentication Method step is visible only during the installation or upgrade of MySQL 8.0.4 or higher. The MySQL user accounts that you create in the next step will use the authentication method that you select in this step. MySQL 8.0 ...
https://dev.mysql.com/doc/mysql-installer/en/server-logging-options.html
This step is available if the Show Advanced Configuration check box was selected during the Type and Networking step. To enable this step now, click Back to return to the Type and Networking step and select the check box. Advanced configuration ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-basic-delete.html
This example shows deleting a row from a table already created and populated previously (see Section 2.5.1.2, “NDB API Basic Insertion Example”). It performs the deletion using a single NdbOperation within a transaction, and handles errors ...