Search Results
https://dev.mysql.com/doc/internals/en/binary-log-versions.html
post-header lengths The lengths for the fixed data part of each event. There are several versions of the binary log file format: v1: Used in MySQL 3.23 v3: Used in MySQL 4.0.2 though 4.1 v4: Used in MySQL 5.0 and up A v2 format was used briefly (in ...
https://dev.mysql.com/doc/internals/en/com-query-response.html
Image description If it is not a valid Protocol::LengthEncodedInteger it is either a ERR_Packet or a Protocol::LOCAL_INFILE_Request. Image description 14.6.4.1.1 Text Resultset A Text Resultset is a possible COM_QUERY Response. It is made up of two ...
https://dev.mysql.com/doc/internals/en/debug-sync-point.html
The behavior could be fixed easily if the method should find more use. They were part of the MySQL code until the 6.0.5 and 5.1.46 versions. Debug Sync Points have been removed from the code in favor of the Debug Sync Facility. Debug Sync Points ...
https://dev.mysql.com/doc/internals/en/event-content-writing-conventions.html
Strings are written in varying formats: A string may be written to a fixed-length field and null-padded (with 0x00 bytes) on the right. Event contents are written using these conventions: Numbers are written in little-endian format (least ...
https://dev.mysql.com/doc/internals/en/guided-tour-skeleton.html
And now we're going to walk through something harder, namely the server. WARNING WARNING WARNING: code changes constantly, so names and parameters may have changed by the time you read this. Important files we'll be walking through: /sql/mysqld.cc ...
https://dev.mysql.com/doc/internals/en/innodb-overview.html
The chart below shows the three parts of a physical record. Name Size Field Start Offsets (F*1) or (F*2) bytes Extra Bytes 6 bytes Field Contents depends on content Legend: The letter 'F' stands for 'Number Of Fields'. The meaning of the parts is ...
https://dev.mysql.com/doc/internals/en/innodb-page-directory.html
Because the slots are in key order, and each slot has a fixed size, it's easy to do a binary search of the records on the page via the slots. The Page Directory part of a page has a variable number of record pointers. Unlike other DBMSs, InnoDB ...
https://dev.mysql.com/doc/internals/en/innodb-page-structure.html
InnoDB stores all records inside a fixed-size unit which is commonly called a "page" (though InnoDB sometimes calls it a "block" instead). A page contains records, but it also contains headers and trailers. I'll start this description with a ...
https://dev.mysql.com/doc/internals/en/load-data-infile-events.html
The revised event sequence fixes the design flaw in the 4.0 format. LOAD DATA INFILE is not written to the binary log like other statements. It is written as one or more events in a packed format, not as a cleartext statement in the binary log. 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.