Search Results
https://dev.mysql.com/doc/internals/en/debug-sync-facility.html
MySQL supports a Debug Sync Facility, which - in spite of the "debug" in its name - is completely independent from the DBUG facility (except that it uses DBUG to trace its operation, if DBUG is also configured in the server). The documentation here ...
https://dev.mysql.com/doc/internals/en/error-flags.html
(This allows one to catch all error messages generated by a statement) thd->lex->current_select->no_error This is set to in case likes INSERT IGNORE ... thd->count_cuted_fields If set, we generate warning for field conversations (normal case for ...
https://dev.mysql.com/doc/internals/en/myisam-dynamic-data-file-layout.html
When a record is inserted after this, it reuses the old frame. The rest is inserted in other old frames, or, if non is available, in a new frame at end of file. A record can be put in one or more frames, also called the record "parts" or "blocks".
https://dev.mysql.com/doc/internals/en/myisam-introduction.html
MySQL creates files named Table1.MYD ("MySQL Data"), Table1.MYI ("MySQL Index"), and Table1.frm ("Format"). These files will be in the directory: /<datadir>/<database>/ For example, if you use Linux, you might find the files in the ...
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/packet-OK_Packet.html
An OK packet is sent from the server to the client to signal successful completion of a command. As of MySQL 5.7.5, OK packes are also used to indicate EOF, and EOF packets are deprecated. Consequently, the server does not send OK packets that ...
https://dev.mysql.com/doc/internals/en/rows-event.html
repeat rows until event-end Fields table_id (6) -- If the table id is 0x00ffffff it is a dummy event that should have the end of statement flag set that declares that all table maps can be freed. Note if the post_header_length in the ...
https://dev.mysql.com/doc/internals/en/starting-transaction-from-external-lock-method.html
That is, if an INSERT fires a trigger, which calls a stored procedure, that invokes a stored method, and so forth, all tables used in the trigger, stored procedure, method, etc., are locked in the beginning of the INSERT. MySQL calls ...
https://dev.mysql.com/doc/internals/en/tracing-example.html
The statement's execution is naturally made of "steps": "steps": [ { "join_preparation": { This is a join's preparation "select#": 1, for the first SELECT of the statement (which has only one, here). "rest_of_plan": [ { "database": "test", "table": ...
https://dev.mysql.com/doc/internals/en/unsafe-statements.html
INSERT DELAYED, since the rows inserted may interleave with concurrently executing statements. NOTE: the following list is incomplete; it does not take into account changes made in 2010 or later (roughly). An unsafe statement will be logged in row ...