Search Results
https://dev.mysql.com/doc/internals/en/charsets.html
Character sets are used by MySQL when storing information, both to ensure that the information is stored (and returned) in the correct format, but also for the purposes of collation and sorting. Each character set supports one or more collations, ...
https://dev.mysql.com/doc/internals/en/event-data-for-specific-event-types.html
The following sections provide details about what appears in the fixed and variable parts of the event data for each event type. LOAD DATA INFILE statements have been associated over time with several different events. The event contents are ...
https://dev.mysql.com/doc/internals/en/event-header-fields.html
The value of this constant is 13 in MySQL 3.23 (v1 format), and 19 in MySQL 4.0 and up (v3 format and up). The first 19 bytes for v4 are the same as those for v3. Because the event header in a newer binary log format starts with the header of the ...
https://dev.mysql.com/doc/internals/en/extra.html
Purpose Passes hints from the server to the storage engine. Synopsis virtual int extra ( operation); enum ha_extra_function operation ; Description This is the extra method. extra() is called whenever the server wishes to send a hint to the storage ...
https://dev.mysql.com/doc/internals/en/getting-index-information.html
It is preferable for storage engines that support indexing to read the index information provided during a CREATE TABLE operation and store it for future use. The reasoning behind this is that the index information is most readily available during ...
https://dev.mysql.com/doc/internals/en/index-read-idx.html
Purpose Find a row based on a key and return. Synopsis virtual int index_read_idx ( buf, index, key, keypart_map, find_flag); byte * buf ; uint index ; const byte * key ; ulonglong keypart_map ; enum ha_rkey_function find_flag ; Description This is ...
https://dev.mysql.com/doc/internals/en/index-read.html
Purpose Find a row based on a key and return. Synopsis virtual int index_read ( buf, key, keypart_map, find_flag); byte * buf ; const byte * key ; ulonglong keypart_map ; enum ha_rkey_function find_flag ; Description This is the index_read method.
https://dev.mysql.com/doc/internals/en/myisam-introduction.html
MySQL creates files named Table1.MYD ("MySQL Data"), Table1.MYI ("MySQL Index"), and Table1.frm ("Format"). These files will be in the directory: /<datadir>/<database>/ For example, if you use Linux, you might find the files in the ...
https://dev.mysql.com/doc/internals/en/optimizer-determining-join-type.html
When evaluating a conditional expression, MySQL decides what join type the expression has. (Again: despite the word “join”, this applies for all conditional expressions, not just join expressions. index: a sequential scan on an index ALL: a ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-5-7.html
This section provides information about keywords and reserved words in MySQL 5.7. MySQL 5.7 Keywords and Reserved Words MySQL 5.7 New Keywords and Reserved Words MySQL 5.7 Removed Keywords and Reserved Words MySQL 5.7 Keywords and Reserved Words ...