Search Results
https://dev.mysql.com/doc/internals/en/implementing-commit.html
During a commit operation, all changes made during a transaction are made permanent and a rollback operation is not possible after that. Depending on the transaction isolation used, this may be the first time such changes are visible to other ...
https://dev.mysql.com/doc/internals/en/implementing-external-lock-method.html
The [custom-engine.html#custom-engine-api-reference-external_lock external_lock()] method is called at the start of a statement or when a LOCK TABLES statement is issued. Examples of using external_lock() can be found in the sql/ha_innodb.cc file, ...
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-info-method.html
Prior to commencing a table scan, the [custom-engine.html#custom-engine-api-reference-info info()] method is called to provide extra table information to the optimizer. The information required by the optimizer is not given through return values ...
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-records-in-range-method.html
The [custom-engine.html#custom-engine-api-reference-records_in_range records_in_range()] method is called by the optimizer to assist in choosing which index on a table to use for a query or join. It is defined as follows: ha_rows ...