Search Results
https://dev.mysql.com/doc/internals/en/delete-table.html
You will need to remove any files you have created at this point. Only used during create if the table_flagHA_DROP_BEFORE_CREATE was specified for the storage engine. Synopsis virtual int delete_table ( name); const char * name ; Description This is ...
https://dev.mysql.com/doc/internals/en/event-header-fields.html
The ID of the mysqld server that originally created the event. The event is sent to M2, which executes it and writes it to its binary log; the event is still written with server ID 1 because that is the ID of the server that originally created the ...The value of this constant is 13 in MySQL 3.23 (v1 format), and 19 in MySQL 4.0 and up (v3 format and ...
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, ...