Search Results
https://dev.mysql.com/doc/internals/en/multi-resultset.html
01 31 00 0c 3f 00 01 00 00 00 08 81 00 00 00 00 .1..?........... 05 00 00 03 fe 00 00 0a 00 02 00 00 04 01 31 05 ..............1. see the EOF_Packet: 05 00 00 03 fe 00 00 0a 00 with its status-flag being 0a the 2nd resultset: 01 00 00 06 01 17 00 00 ...
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/negative-tests.html
Please be creative and imagine what could go wrong in rough reality. Maximum - 1, Maximum, Maximum + 1 Assume an SQL operation that affects the filesystem (LOAD DATA, CREATE SCHEMA or TABLE, backup/restore, ...). A "negative" test is a test for ...
https://dev.mysql.com/doc/internals/en/notes-on-mtr2.html
Very good for diagnosing random failures - set a high value for 'n', create a high load on your machine, and see if you can duplicate the failure. MTR2 has brought some new utility that can improve testing, but also some elements that can be ...
https://dev.mysql.com/doc/internals/en/optimizer-eliminating-dead-code.html
SELECT * FROM Table1 WHERE column1 = 'Canada'; The optimizer will not eliminate the condition in the query, even though the CREATE TABLE definition makes it an impossible condition. A transformation takes place for conditions that are always true, ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-selection.html
If a partitioned table is accessed in a series of index lookups (that is, using the ref, eq_ref, or ref_or_null access methods), MySQL checks to see whether it needs to make index lookups in all partitions or that it can limit access to a ...
https://dev.mysql.com/doc/internals/en/optimizer-trace-implementation.html
A trace is started by creating an instance of Opt_trace_start; information is added to this trace by creating instances of Opt_trace_object and Opt_trace_array, and by using the add() functions of those classes...
https://dev.mysql.com/doc/internals/en/replication-source-code-files.html
log_event.h/.cc The Log_event class and subclasses, for creating, writing, reading, printing, and applying events of every event type. Status of this section: up to date 2009-12-16 Files in the sql directory: File Description slave.h/.cc Contains ...
https://dev.mysql.com/doc/internals/en/required-server-code-patches.html
The build system is not too clever about creating these symlinks for files added after the first compile ... Currently procedures can only be compiled into the server staticly. There is no dynamic procedure for loading them dynamicly yet like we ...
https://dev.mysql.com/doc/internals/en/source-files-related-to-the-binary-log.html
The Log_event class and subclasses, for creating, writing, reading, printing, and applying events of every event type. This section describes the files in a MySQL source tree that are most relevent to binary log processing. sql directory: log.h ...