Search Results
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/implementing-extra-method.html
Implementation of the hints in the extra call is not mandatory, and most storage engines return 0: int ha_tina::extra(enum ha_extra_function operation) { DBUG_ENTER("ha_tina::extra"); DBUG_RETURN(0); } . Prior to some operations, the ...
https://dev.mysql.com/doc/internals/en/implementing-index-read-method.html
The [custom-engine.html#custom-engine-api-reference-index_read index_read()] method is used to retrieve a row based on a key: int ha_foo::index_read(byte * buf, const byte * key, ulonglong keypart_map, enum ha_rkey_function find_flag) The *buf ...
https://dev.mysql.com/doc/internals/en/implementing-records-in-range-method.html
The key_range structure looks like this: typedef struct st_key_range { const byte *key; uint length; key_part_map keypart_map; enum ha_rkey_function flag; } key_range; key_range members are used as follows: key is a pointer to the key buffer. The ...
https://dev.mysql.com/doc/internals/en/implementing-the-rnd-next-method.html
As with the index_read() method, the storage engine must return the row that matches the key according to the find_flag and set a cursor for future reads.
https://dev.mysql.com/doc/internals/en/index-read-idx.html
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 the index_read_idx method. Purpose Find a row ...
https://dev.mysql.com/doc/internals/en/index-read.html
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. Purpose Find a row based on a key and return.
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
index: a sequential scan on an index ALL: a sequential scan of the entire table See: /sql/sql_select.h, enum join_type{}. When evaluating a conditional expression, MySQL decides what join type the expression has. (Again: despite the word ...
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 ...