Search Results
https://dev.mysql.com/doc/internals/en/filesort.html
This algorithm is described in the MySQL Reference manual; see ORDER BY Optimization.
https://dev.mysql.com/doc/internals/en/implementing-extra-method.html
Prior to some operations, the [custom-engine.html#custom-engine-api-reference-extra extra()] method is called to provide extra hints to the storage engine on how to perform certain operations. Implementation of the hints in the extra call is not ...
https://dev.mysql.com/doc/internals/en/implementing-index-first-method.html
The [custom-engine.html#custom-engine-api-reference-index_first index_first()] method is used for index scanning: int ha_foo::index_first(byte * buf) The *buf parameter is populated with the row that corresponds to the first key value in the index.
https://dev.mysql.com/doc/internals/en/implementing-index-last-method.html
The [custom-engine.html#custom-engine-api-reference-index_last index_last()] method is used for reverse index scanning: int ha_foo::index_last(byte * buf) The *buf parameter is populated with the row that corresponds to the last key value in the ...
https://dev.mysql.com/doc/internals/en/implementing-index-next-method.html
The [custom-engine.html#custom-engine-api-reference-index_next index_next()] method is used for index scanning: int ha_foo::index_next(byte * buf) The *buf parameter is populated with the row that corresponds to the next matching key value ...
https://dev.mysql.com/doc/internals/en/implementing-index-prev-method.html
The [custom-engine.html#custom-engine-api-reference-index_prev index_prev()] method is used for reverse index scanning: int ha_foo::index_prev(byte * buf) The *buf parameter is populated with the row that corresponds to the previous matching key ...
https://dev.mysql.com/doc/internals/en/implementing-index-read-last-method.html
The [custom-engine.html#custom-engine-api-reference-index_read_last index_read_last()] method works like [custom-engine.html#custom-engine-index-read index_read()] but finds the last row with the current key value or prefix: int ...
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-position-method.html
The [custom-engine.html#custom-engine-api-reference-position position()] method is called after every call to rnd_next() if the data needs to be reordered: void ha_foo::position(const byte *record) It stores a "position" of a record in this->ref.
https://dev.mysql.com/doc/internals/en/implementing-rnd-pos-method.html
The [custom-engine.html#custom-engine-api-reference-rnd_pos rnd_pos()] method behaves in a similar fashion to the rnd_next() method but takes an additional parameter: int ha_foo::rnd_pos(byte * buf, byte *pos) The *pos parameter contains ...