Search Results
https://dev.mysql.com/doc/internals/en/creating-index-keys.html
As part of every table-write operation (INSERT, UPDATE, DELETE), the storage engine is required to update its internal index information. The method used to update indexes will vary from storage engine to storage engine, depending on the method ...
https://dev.mysql.com/doc/internals/en/custom-engine-overview.html
Custom storage engines can be built in a progressive manner: Developers can start with a read-only storage engine and later add support for INSERT, UPDATE, and DELETE operations, and even later add support for indexing, transactions, and other ...
https://dev.mysql.com/doc/internals/en/dbug-directory.html
How it works: One inserts a function call that begins with DBUG_* in one of the regular MYSQL programs. Rather, it's a set of public-domain routines which are useful for debugging MySQL programs. The MySQL Server and all .c and .cc programs support ...
https://dev.mysql.com/doc/internals/en/delete-row.html
In sql_select it is used for removing duplicates, while in insert it is used for REPLACE calls. Synopsis virtual int delete_row ( buf); const byte * buf ; Description This is the delete_row method. buf will contain a copy of the row to be deleted.
https://dev.mysql.com/doc/internals/en/event-header-fields.html
The master/server relationships look like this: M1---->M2 ^ | | | +--M3<-+ A client sends an INSERT statement to M1. The value of this constant is 13 in MySQL 3.23 (v1 format), and 19 in MySQL 4.0 and up (v3 format and up). The first 19 bytes for v4 ...
https://dev.mysql.com/doc/internals/en/event-meanings.html
INTVAR_EVENT Written every time a statement uses an AUTO_INCREMENT column or the LAST_INSERT_ID() function; precedes other events for the statement. An INTVAR_EVENT is written with a "subtype" in the event data part: INSERT_ID_EVENT indicates the ...
https://dev.mysql.com/doc/internals/en/floating-point-types.html
The bugfix for http://bugs.mysql.com/4937 (INSERT + SELECT + UNION ALL + DATE to VARCHAR(8) conversion problem) produced a conversion function which was a promising approach to the conversion problems. The MySQL Reference Manual has a discussion of ...
https://dev.mysql.com/doc/internals/en/guided-tour-flow.html
The flow works like this: First, the client routines get an SQL statement from a user, allowing edit, performing initial checks, and so on. Then, via the vio routines, the somewhat-massaged statement goes off to the server. Next, the sql routines ...
https://dev.mysql.com/doc/internals/en/guided-tour-majordir-sql.html
If you remember your manual, you know that you must pronounce this: ess queue ell. The "parser" programs on mysql-5.0/sql: size name comment ---- ---- ------- 51326 sql_lex.cc lexer 230026 sql_yacc.yy parser + many more *.cc programs This is where ...
https://dev.mysql.com/doc/internals/en/heap-directory.html
All the MySQL table handlers (that is, the handlers that MySQL itself produces) have files with similar names and functions. Thus, this (heap) directory contains a lot of duplication of the myisam directory (for the MyISAM table handler). Such ...