Search Results
https://dev.mysql.com/doc/internals/en/logging-transactions-rules-for-non-committing-statements.html
Let S be a logged statement that does not have an implicit commit, except CREATE TEMPORARY TABLE...SELECT (This includes all "pure DML": INSERT, UPDATE, DELETE, REPLACE, TRUNCATE, SELECT, DO, CALL, EXECUTE, LOAD DATA INFILE, and BINLOG. The ...
https://dev.mysql.com/doc/internals/en/miscellaneous-options.html
For Autotools MySQL build options that have CMake equivalents, the normal mapping from an Autotools option to the CMake option is to convert uppercase, remove leading dashes, replace dashes with underscores, and add a leading -D.
https://dev.mysql.com/doc/internals/en/os-specific-commands.html
Sometimes OS commands could be also replaced by SQL statement sequences writing to and reading from files and some SQL string functions. The exec and system commands enable tests to execute external commands. However, many of such commands are ...
https://dev.mysql.com/doc/internals/en/risky-handling-around-additional-sessions.html
How to prevent that this test harms the succeeding test? (5) should be replaced by connection con1; disconnect con1; --source include/wait_until_disconnected.inc connection default; Where is the "junk"? There should be a 'reap' for every preceeding ...This is most probably good for the throughput of usual application but has some annoying consequences for the development of ...
https://dev.mysql.com/doc/internals/en/support-for-update.html
Some storage engines will replace data in-place, while other implementations delete the existing row and append the new row at the end of the data file. Performing an update will depend on row format and storage implementation. Non-indexed storage ...
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/transaction-overview.html
If the preceding methods are called and a transaction already exists the transaction is not replaced. Transactions are not explicitly started on the storage engine level, but are instead implicitly started through calls to either start_stmt() or ...
https://dev.mysql.com/doc/internals/en/transformations-singlerow.html
The following will not be reduced: SELECT a; SELECT 1 UNION SELECT 2; SELECT 1 FROM t1; The following select will be reduced: SELECT 1; SELECT a+2; Such a subquery will be completely replaced by its expression from item list and its SELECT_LEX and ... Item_singlerow_subselect will be rewritten only if it contains no FROM clause, and it is not part of UNION, and it is a scalar ...
https://dev.mysql.com/doc/internals/en/vc-plus-plus-files-directory.html
VC++Files includes a complete environment to compile MySQL with the VC++ compiler. To use it, just copy the files on this directory; the make_win_src_distribution.sh script uses these files to create a Windows source installation. This directory has ...
https://dev.mysql.com/doc/internals/en/wait-condition.html
The "Debug Sync Facility" should be able to replace most of the "wait condition" uses. 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 ...