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/myisam-directory.html
They are: mi_cache.c --- for reading records from a cache mi_changed.c --- a single routine for setting a "changed" flag (very short) mi_check.c --- for checking and repairing tables. Can be used to exactly replay a set of changes to a table.
https://dev.mysql.com/doc/internals/en/other-unsafe-statements.html
Status of this subsection: not started 2009-10-21 INSERT DELAYED LIMIT System tables .
https://dev.mysql.com/doc/internals/en/replication-source-code-files.html
rpl_injector.h/.cc The injector class that allows external insertions into the binary log. Status of this section: up to date 2009-12-16 Files in the sql directory: File Description slave.h/.cc Contains the slave IO and SQL threads. This is the ...
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/scripts-directory.html
Linux programmers use it where Windows programmers would use a *.bat (batch filename extension). Can be safely run during any upgrade to get the newest MySQL privilege tables mysql_install_db.sh --- Create privilege tables and func table ...
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/sleep.html
send INSERT INTO t1 VALUES (1); --connection conn1 # Sleep until we can be sure that conn2 reached wait_for_lock(). In some cases race conditions can be repeated when all but one thread are blocked (for example waiting for an SQL lock). Then the ...
https://dev.mysql.com/doc/internals/en/source-files-related-to-the-binary-log.html
rpl_injector.h /rpl_injector.cc: Contains the injector class that allows external insertions into the binary log. This section describes the files in a MySQL source tree that are most relevent to binary log processing. sql directory: log.h /log.cc: ...
https://dev.mysql.com/doc/internals/en/sql-directory.html
Programs for handling SQL commands. The "core" of MySQL. These are the .c and .cc files in the sql directory: derror.cc --- read language-dependent message file des_key_file.cc --- load DES keys from plaintext file discover.cc --- Functions for ...