Search Results
https://dev.mysql.com/doc/internals/en/row-based-binary-logging.html
Logging in this format can be done independent of whether the log is used for replication. That is, replication need not figure into the use of the binary log at all. Similar remarks apply to the terms "statement-based logging" (SBL) versus ...
https://dev.mysql.com/doc/internals/en/rows-event.html
repeat rows until event-end Fields table_id (6) -- If the table id is 0x00ffffff it is a dummy event that should have the end of statement flag set that declares that all table maps can be freed. Note if the post_header_length in the ...
https://dev.mysql.com/doc/internals/en/select-select-result.html
This class has a very important role in SELECT performance with select_result class and classes inherited from it (usually called with a select_ prefix). The key methods in this class are the following: send_fields sends given item list headers ...
https://dev.mysql.com/doc/internals/en/select-union.html
st_select_lex_unit::exec Delete rows from the temporary table if this is not the first call. We will need this object to store in every JOIN structure link on it, but we have not (yet) temporary table structure. Allocate JOIN structures and execute ...
https://dev.mysql.com/doc/internals/en/source-files-related-to-the-binary-log.html
This section describes the files in a MySQL source tree that are most relevent to binary log processing. sql directory: log.h /log.cc: The high-level binary logging mechanism for organizing events into a sequence so that it becomes a binary log.
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/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/transactions-notes-on-ddl-and-normal-transaction.html
DDL statements and operations with nontransactional engines do not "register" in thd->transaction lists, and thus do not modify the transaction state. Besides, each DDL statement in MySQL begins with an implicit normal transaction commit (a call to ...
https://dev.mysql.com/doc/internals/en/x-protocol-notices-notices.html
Global Notices Global Notices are sent by the server in case of events happen that are unrelated to the currently active message sequence: server is shutting down node disconnected from group schema or table dropped binlog events Server Shutting ...