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
The idea with handler::store_lock() is the following: The statement decided which locks we should need for the table for updates/deletes/inserts we get WRITE locks, for SELECT... If TL_UNLOCK is set If we are not doing a LOCK TABLE or DISCARD/IMPORT ...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 ...
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 ...If ...
https://dev.mysql.com/doc/internals/en/transactions-roles-responsibilities.html
SELECT does, since handler::external_lock() is called for the table that is being selected from. 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.
https://dev.mysql.com/doc/internals/en/uncompressed-payload.html
with the uncompressed payload starting right after the 7 byte header: 09 00 00 00 03 53 45 4c 45 43 54 20 31 -- SELECT 1 . For small packets it may be to costly to compress the packet: compressing the packet may lead to more data and sending the ...
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 MySQL user accounts that you create in the next step will use the authentication method that you select in this step. If you are installing or upgrading to MySQL 8.0.4 or higher, select one of the following authentication methods: Use Strong ...
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
You can verify afterwards that the row was deleted by running the read example (Section 2.5.1.3, “NDB API Basic Reading Example”), or by executing SELECT * FROM basic in the mysql client. This example shows deleting a row from a table already ...