Search Results
https://dev.mysql.com/doc/internals/en/implementing-rollback.html
Of the two major transactional operations, ROLLBACK is the more complicated to implement. All operations that occurred during the transaction must be reversed so that all rows are unchanged from before the transaction began. To support ROLLBACK, ...
https://dev.mysql.com/doc/internals/en/implementing-savepoint-set-method.html
The savepoint_set() method is called whenever a user issues the SAVEPOINT statement: int (*savepoint_set)(THD *thd, void *sv); The *sv parameter points to an uninitialized storage area of the size defined by savepoint_offset. When savepoint_set() ...
https://dev.mysql.com/doc/internals/en/in-memory-record-layout.html
null bits: One bit per column that can be NULL. The "null bits" are rounded up to the next byte boundary. Length (pack_length) and layout of the fields depend on the field type: -- to be added -- Note: The "in-memory record layout" is used by the ...
https://dev.mysql.com/doc/internals/en/include-directory.html
Header (*.h) files for most libraries; includes all header files distributed with the MySQL binary distribution. Note that each individual directory will also have its own *.h files, for including in its own *.c programs. The *.h files in the ...
https://dev.mysql.com/doc/internals/en/innodb-fil-trailer.html
The Fil Trailer has one part, as follows: Name Size Remarks FIL_PAGE_END_LSN 8 low 4 bytes = checksum of page, last 4 bytes = same as FIL_PAGE_LSN The final part of a page, the fil trailer (or File Page Trailer), exists because InnoDB's architect ...
https://dev.mysql.com/doc/internals/en/innodb-page-overview.html
An InnoDB page has seven parts: Fil Header Page Header Infimum + Supremum Records User Records Free Space Page Directory Fil Trailer As you can see, a page has two header/trailer pairs. The inner pair, "Page Header" and "Page Directory", are mostly ...
https://dev.mysql.com/doc/internals/en/logging-transactions-definitions.html
To reason about logging different table types, we make some preliminary definitions. (D-T-table) A table that has a transactional engine is called a T-table. (D-N-table) A table that has a nontransactional engine is called an N-table. (D-N-write) A ...
https://dev.mysql.com/doc/internals/en/logging-transactions-rules-for-commmitting-statements.html
(R-log-commit-statement) All other statements that have a pre-commit are written directly to the binlog. (Note: this is semantically equivalent to writing it to the SC and flushing the SC. However, due to requirements by NDB (which have not been ...
https://dev.mysql.com/doc/internals/en/logging-transactions.html
It is not always possible to log correctly in statement format when both transactional and nontransactional tables are used in the same transaction. Statements that do an implicit commit (that is, most but not all DDL, and some utility commands) are ...
https://dev.mysql.com/doc/internals/en/myisam-column-attributes.html
Next I'll describe the physical attributes of each column in a row. The format depends entirely on the data type and the size of the column, so, for every data type, I'll give a description and an example. All the types are defined within the ...