Search Results
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-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/innodb-fil-header.html
The word "space" is generic jargon for either "log" or "tablespace". -------- - root - -------- | ---------------------- | | | | -------- -------- - leaf - <--> - leaf - -------- -------- Everyone has seen a B-tree and knows that the entries in the ...
https://dev.mysql.com/doc/internals/en/innodb-page-directory.html
The slots track the records' logical order (the order by key rather than the order by placement on the heap). 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 ...
https://dev.mysql.com/doc/internals/en/join-buffer-size.html
This buffer is used only when the join is of type ALL or index (in other words, when no possible keys can be used). Basic information about the join buffer cache: The size of each join buffer is determined by the value of the join_buffer_size ...
https://dev.mysql.com/doc/internals/en/mysys-functions.html
int init_key_cache _A((ulong use_mem, ulong leave_this_much_mem)); Use caching of keys in MISAM, PISAM, and ISAM. Functions in mysys: (For flags see my_sys.h) int my_copy _A((const char *from, const char *to, myf MyFlags)); Copy file from from to ...
https://dev.mysql.com/doc/internals/en/optimizer-range-join-type.html
Some conditions can work with indexes, but over a (possibly wide) range of keys. The optimizer may change a Range to an ALL join type if a condition would examine too many index keys. The optimizer will use an index (range search) for column1 LIKE ...
https://dev.mysql.com/doc/mysql-installer/en/mysql-installer-setup.html
The following figure identifies and describes the key areas of this step. Template files contain keys and formulas to calculate some values dynamically. Choosing a Setup Type Path Conflicts Check Requirements MySQL Installer Configuration Files ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-annotation-persistent.html
4.3.2.13.1 Synopsis @Target(value={java.lang.annotation.ElementType.FIELD, java.lang.annotation.ElementType.METHOD}) @Retention(value=java.lang.annotation.RetentionPolicy.RUNTIME) public @interface Persistent { public NullValue nullValue ; public ...
https://dev.mysql.com/doc/ndbapi/en/mccj-using-clusterj-annotations.html
The annotations @PrimaryKey and @Index inform ClusterJ about indexes in the database table. ClusterJ automatically detects the primary keys of tables; while there is an annotation in ClusterJ to permit the user to describe the primary keys of a ...