Search Results
https://dev.mysql.com/doc/internals/en/caching.html
(Note that the some of the filenames contain an incorrect spelling of the word “cache.”) Key Cache A shared cache for all B-tree index blocks in the different NISAM files. (mysys/mf_keycash.c) Record Cache This is used for quick scanning of all ...Uses hashing and reverse linked lists for quick caching of the most recently used blocks and quick flushing of changed entries for a specific ...
https://dev.mysql.com/doc/internals/en/cmd-line-utils-directory.html
All the files here are "non-MySQL" files, in the sense that MySQL AB didn't produce them, it just uses them. It should be unnecessary to study the programs in these files unless you are writing or debugging a tty-like client for MySQL, such as ...
https://dev.mysql.com/doc/internals/en/fast-path.html
set --default-auth=sha256_password for the MySQL client, provide it with the servers public-key with --server-public-key=... set --default-authentication-plugin=sha256_password for the MySQL server: 46 00 00 00 0a 35 2e 36 2e 37 2d 6c 6f 67 00 02 ...
https://dev.mysql.com/doc/internals/en/frm-file-format.html
Regardless of the storage engine you choose, every MySQL table you create is represented on disk by a .frm file that describes the table's format (that is, the table definition). The file bears the same name as the table, with an .frm extension.
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 ...