Search Results
https://dev.mysql.com/doc/internals/en/storage-engine-options.html
A shared module must be installed using the INSTALL PLUGIN statement or the --plugin-load option before it can be used. Storage engines are plugins, so the options that control plugin building specify which storage engines to build. The ...
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... Synopsis virtual THR_LOCK_DATA ** store_lock ( thd, to, lock_type); ...
https://dev.mysql.com/doc/internals/en/stored-procedures.html
In MySQL 5.0 the protocol was extended to handle: multi-resultset multi-statement .
https://dev.mysql.com/doc/internals/en/support-for-insert.html
Once you have read support in your storage engine, the next feature to implement is support for INSERT statements. With INSERT support in place, your storage engine can handle WORM (write once, read many) applications such as logging and archiving ...
https://dev.mysql.com/doc/internals/en/test-faults-usage.html
SET SESSION debug="+d,function_crash_return"; will crash the server while returning from function.
https://dev.mysql.com/doc/internals/en/traceable-queries.html
If one of those statements is prepared and executed in separate steps, preparation and execution are separately traced. They are: SELECT; INSERT or REPLACE (with VALUES or SELECT); UPDATE/DELETE and their multi-table variants; all the previous ones ...
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/internals/en/x-protocol-comparison-comparison-to-mysql-c-s-protocol.html
Feature MySQL C/S protocol X Protocol plaintext auth ✓ ✓ via SASL extentisible auth ✓ (5.6) ✓ via SASL TLS extension ✓ ✓ max message size >= 1Gb ✓ ✓ compression extension ✓ ✕ resettable sessions COM_RESET_CONNECTION Reset ...
https://dev.mysql.com/doc/internals/en/x-protocol-xplugin-implementation-of-the-x-protocol.html
Mysqlx.Sql::StmtExecute StmtExecute implements several namespaces: sql The SQL interface which expects: .stmt to be a string that the MySQL SQL parser understands Note As the SQL parser for non prepared statements doesn't understand wildcards, ...
https://dev.mysql.com/doc/mysqld-version-reference/en/optvar-changes-8-0.html
The following list details the changes to specific options and variables within MySQL 8.0.