Search Results
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/transformation-in.html
Item_in_subselect::select_transformer is divided into two parts, one for the scalar left part and one for the row left part.
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/internals/en/unsafe-statements.html
NOTE: the following list is incomplete; it does not take into account changes made in 2010 or later (roughly). An unsafe statement will be logged in row format if binlog_format=MIXED and will generate a warning if binlog_format=STATEMENT. The ...
https://dev.mysql.com/doc/internals/en/user-level-locks.html
User-level locks are controlled with the SQL functions GET_LOCK(str,timeout) IS_FREE_LOCK(str) IS_USED_LOCK(str) RELEASE_LOCK(str) They can be used at places where SQL statements accept SQL functions. Depending on their appearance in the select ...
https://dev.mysql.com/doc/internals/en/variation-of-protocol-option.html
It is usual to run tests with and without the mysql-test-run.pl startup option "--ps-protocol". And there are also attempts of System QA to run the other protocols. Effect of the "--ps-protocol" option: mysqltest will run as many SQL statements as ...
https://dev.mysql.com/doc/internals/en/wait-condition.html
Like 'sleep', this method can also be used, when all but one thread reach a blocked state. If you are able to detect that the threads are in their blocked state by using SQL statements, then you can use this method. The remaining thread runs the ...
https://dev.mysql.com/doc/internals/en/x-protocol-implementation-implementation-notes.html
Topics in this section: Client Server Client and Server implementations of the protocol should make use of the following: vectorized IO pipelining to reduce the latency and CPU usage. Client Out-of-Band Messages The client should decode the ...
https://dev.mysql.com/doc/mysql-installer/en/mysql-installer-workflow.html
MySQL Installer provides a wizard-like tool to install and configure new MySQL products for Windows. Unlike the initial setup, which runs only once, MySQL Installer invokes the wizard each time you download or install a new product. For first-time ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-5-7.html
This section provides information about keywords and reserved words in MySQL 5.7. MySQL 5.7 Keywords and Reserved Words MySQL 5.7 New Keywords and Reserved Words MySQL 5.7 Removed Keywords and Reserved Words MySQL 5.7 Keywords and Reserved Words ...