Search Results
https://dev.mysql.com/doc/internals/en/implementing-rnd-next-method.html
In each format, the columns appear in the order in which they were defined by the CREATE TABLE statement. After the table is initialized, the MySQL server will call the handler's [custom-engine.html#custom-engine-api-reference-rnd_next rnd_next()] ...
https://dev.mysql.com/doc/internals/en/initialization-callback.html
The initialization callback is registered together with the procedure name in the sql_procs array in procedure.cc.
https://dev.mysql.com/doc/internals/en/load-data-infile-events.html
Several new event types were introduced: Create_file_log_event (type code CREATE_FILE_EVENT = 8), Append_block_log_event (type code APPEND_BLOCK_EVENT = 9), Execute_load_log_event (type code EXEC_LOAD_EVENT = 10), and Delete_file_log_event (type ...
https://dev.mysql.com/doc/internals/en/multi-resultset.html
01 31 00 0c 3f 00 01 00 00 00 08 81 00 00 00 00 .1..?........... 05 00 00 03 fe 00 00 0a 00 02 00 00 04 01 31 05 ..............1. see the EOF_Packet: 05 00 00 03 fe 00 00 0a 00 with its status-flag being 0a the 2nd resultset: 01 00 00 06 01 17 00 00 ...
https://dev.mysql.com/doc/internals/en/myisam-directory.html
They are: mi_cache.c --- for reading records from a cache mi_changed.c --- a single routine for setting a "changed" flag (very short) mi_check.c --- for checking and repairing tables. Can be used to exactly replay a set of changes to a table.
https://dev.mysql.com/doc/internals/en/negative-tests.html
Please be creative and imagine what could go wrong in rough reality. Maximum - 1, Maximum, Maximum + 1 Assume an SQL operation that affects the filesystem (LOAD DATA, CREATE SCHEMA or TABLE, backup/restore, ...). A "negative" test is a test for ...
https://dev.mysql.com/doc/internals/en/notes-on-mtr2.html
Very good for diagnosing random failures - set a high value for 'n', create a high load on your machine, and see if you can duplicate the failure. MTR2 has brought some new utility that can improve testing, but also some elements that can be ...
https://dev.mysql.com/doc/internals/en/optimizer-eliminating-dead-code.html
SELECT * FROM Table1 WHERE column1 = 'Canada'; The optimizer will not eliminate the condition in the query, even though the CREATE TABLE definition makes it an impossible condition. A transformation takes place for conditions that are always true, ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-selection.html
If a partitioned table is accessed in a series of index lookups (that is, using the ref, eq_ref, or ref_or_null access methods), MySQL checks to see whether it needs to make index lookups in all partitions or that it can limit access to a ...
https://dev.mysql.com/doc/internals/en/optimizer-trace-implementation.html
A trace is started by creating an instance of Opt_trace_start; information is added to this trace by creating instances of Opt_trace_object and Opt_trace_array, and by using the add() functions of those classes...