Search Results
https://dev.mysql.com/doc/internals/en/index-end.html
Synopsis virtual int index_end ( ); ; Description This is the index_end method. Purpose Indicates end of index scan, clean up any resources used. Generally it is used as a counterpart to the index_init method, cleaning up any resources allocated for ...
https://dev.mysql.com/doc/internals/en/innodb-page-example.html
For this example, I used Borland's TDUMP again, as I did for the earlier chapter on Record Format. This is what a page looked like: Address Values in Hexadecimal Values in ASCII 0D4000: 00 00 00 00 00 00 00 35 FF FF FF FF FF FF FF FF ...0D4010: 00 ...
https://dev.mysql.com/doc/internals/en/item-class.html
To us, the word Item means more than just “thingamabob”; it is a technical term with a precise definition in the context of our source code. In the function category we include operators such as + and ||, because operators are merely functions ...
https://dev.mysql.com/doc/internals/en/myisam-concurrent-insert.html
This, in turn, is called from ha_myisam::external_lock() from unlock_external() from mysql_unlock_tables(). To support concurrent inserts, every statement starts with copying MYISAM_SHARE::state.state to MI_INFO::save_state and lets MI_INFO::state ...
https://dev.mysql.com/doc/internals/en/myisam-introduction.html
(Reminder: This does not refer to BDB and InnoDB tables, which do use pages). So the file Table1.MYD looks like this: Hexadecimal Display of Table1.MYD file F1 61 62 63 00 F5 64 20 65 00 ... Here's how to read this hexadecimal-dump display: The ...
https://dev.mysql.com/doc/internals/en/myisampack.html
If there are more, it falls back to byte value compression for this column. This means also that myisampack may use different algorithms for different columns. This means that finally we may have less code trees than columns. This happens for ...
https://dev.mysql.com/doc/internals/en/rnd-pos.html
Synopsis virtual int rnd_pos ( buf, pos); byte * buf ; byte * pos ; Description This is the rnd_pos method. This is like rnd_next, but you are given a position to use to determine the row. Parameters buf pos Return Values This method has no return ...The position will be of the type that you stored in ...
https://dev.mysql.com/doc/internals/en/threads.html
Calls thr_setconcurrency() if it is available at compile time; this call is generally assumed to exist only on Solaris, its value should reflect the number of physical CPUs. The mysql_install_db script starts a server with an option telling it to ...
https://dev.mysql.com/doc/internals/en/transformations-singlerow.html
Also, if this expression is Item_fields or Item_ref, then the name of this new item will be the same as the name of this item (but not (SELECT ...)). This is done to prevent broken references on such items from more inner subqueries.
https://dev.mysql.com/doc/internals/en/tuning-trace-purging.html
This is done with SET optimizer_trace_offset=<OFFSET>, optimizer_trace_limit=<LIMIT> where OFFSET is a signed integer, and LIMIT is a positive integer. The default for optimizer_trace_offset is -1; the default for optimizer_trace_limit is 1. The ...