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/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 ...
https://dev.mysql.com/doc/internals/en/tests-directory.html
The files in this directory are test programs that can be used as a base to write a program to simulate problems in MySQL in various scenarios: forks, locks, big records, exporting, truncating, and so on.
https://dev.mysql.com/doc/internals/en/threads.html
Threads in mysqld can run at four different priorities, defined in mysql_priv.h: #define INTERRUPT_PRIOR 10 #define CONNECT_PRIOR 9 #define WAIT_PRIOR 8 #define QUERY_PRIOR 6 Some threads try to set their priority; others don't. These calls are ...
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/wait-condition.html
send INSERT INTO t1 VALUES (1); --connection conn1 # Specify the condition that shows if conn2 reached wait_for_lock(). 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 ...