Search Results
https://dev.mysql.com/doc/internals/en/good-tests.html
There are a lot of strict rules and rules of thumb which may increase the quality of tests written for the tool pair mysqltest/mysqltest-run.pl (MTR). See the Writing Test Cases section of the MySQL Server Doxygen documentation, available at ...
https://dev.mysql.com/doc/internals/en/guided-tour-majordir.html
BUILD client Docs myisam mysys sql vio The orderly approach is to look first at the most important directories, then we'll look at the whole list in our second pass. So, first, let's look at what you'll find in just seven of the directories: BUILD, ...
https://dev.mysql.com/doc/internals/en/innodb-field-start-offsets.html
The entries are in reverse order, that is, the first field's offset is at the end of the list. The Field Start Offsets is a list in which each entry is the position, relative to the Origin, of the start of the next field. The first column's length ...
https://dev.mysql.com/doc/internals/en/innodb-infimum-and-supremum-records.html
“Infimum” and “Supremum” are mathematical terms that refer to the outer bounds of an ordered set. An infimum is Greatest Lower Bound (GLB), so it is lower than the lowest possible key value. A supremum is the Least Upper Bound (LUB), so it ...
https://dev.mysql.com/doc/internals/en/innodb-page-example.html
00 0F PAGE_N_DIRECTION The last 15 (hexadecimal 0F) inserts were all done "to the right" because I was inserting in ascending order. For this example, I used Borland's TDUMP again, as I did for the earlier chapter on Record Format. This is what a ...
https://dev.mysql.com/doc/internals/en/miscellaneous-test-tips.html
Section 26.6.1, “Stability Checks for Random Timing Problems” Section 26.6.2, “Stability Checks for Hostname-Related Problems” Section 26.6.3, “Stability Checks for Unexpected Problems” Section 26.6.4, “Row Order Within Result Sets” ...
https://dev.mysql.com/doc/internals/en/myisam-concurrent-insert.html
To support concurrent inserts, every statement starts with copying MYISAM_SHARE::state.state to MI_INFO::save_state and lets MI_INFO::state point to the copy. The copy back is done in mi_update_status(), which is called from mi_lock_database() when ...
https://dev.mysql.com/doc/internals/en/optimizer-determining-join-type.html
When evaluating a conditional expression, MySQL decides what join type the expression has. (Again: despite the word “join”, this applies for all conditional expressions, not just join expressions. index: a sequential scan on an index ALL: a ...
https://dev.mysql.com/doc/internals/en/optimizer-index-join-type.html
(The order of the columns in the index does not matter.) Thus it might make sense to define a multiple-column index strictly for use as a covering index, regardless of search considerations. Consider this query: SELECT column1 FROM Table1; If ...
https://dev.mysql.com/doc/internals/en/optimizer-transpositions.html
MySQL supports transpositions (reversing the order of operands around a relational operator) for simple expressions only. In other words: WHERE - 5 = column1 becomes: WHERE column1 = -5 However, MySQL does not support transpositions where ...