Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-change-buffer.html
The type of data cached in the change buffer is governed by the innodb_change_buffering variable. You can set the innodb_change_buffering variable in the MySQL option file (my.cnf or my.ini) or change it dynamically with the SET GLOBAL statement, ...
https://dev.mysql.com/doc/internals/en/innodb-page-directory.html
(Since the Page Directory does not have a slot for every record, binary search can only give a rough position and then InnoDB must follow the "next" record pointers. InnoDB's "sparse slots" policy also accounts for the n_owned field in the Extra ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablespaces-table.html
The INNODB_TABLESPACES table provides metadata about InnoDB file-per-table, general, and undo tablespaces. Note The INFORMATION_SCHEMA FILES table reports metadata for InnoDB tablespace types including file-per-table tablespaces, general ...The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-preload-buffer-pool.html
By default, tablespace ID and page ID data is saved in a file named ib_buffer_pool, which is saved to the InnoDB data directory. Even though a buffer pool can be many gigabytes in size, the buffer pool data that InnoDB saves to disk is tiny by ...
https://dev.mysql.com/doc/internals/en/innodb-infimum-and-supremum-records.html
InnoDB sets up an infimum record and a supremum record automatically in the root page when an index is first created, and never deletes them. The InnoDB code comments distinguish between “the infimum and supremum records” and the “user ...
https://dev.mysql.com/doc/internals/en/innodb-overview.html
The chart below shows the three parts of a physical record. Name Size Field Start Offsets (F*1) or (F*2) bytes Extra Bytes 6 bytes Field Contents depends on content Legend: The letter 'F' stands for 'Number Of Fields'. The meaning of the parts is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-acid.html
MySQL includes components such as the InnoDB storage engine that adhere closely to the ACID model so that data is not corrupted and results are not distorted by exceptional conditions such as software crashes and hardware malfunctions. Consistency ... The ACID model is a set of database design principles that emphasize aspects of reliability that are important for business data and mission-critical ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-flushing.html
Dirty pages are those that have been modified but are not yet written to the data files on disk. Before doing so, all dirty pages with redo entries in that portion of the log file must be flushed. Limiting Buffer Flushing During Idle Periods The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-reads.html
If you query data and then insert or update related data within the same transaction, the regular SELECT statement does not give enough protection. FOR SHARE, or from reading the data in certain transaction isolation levels. These clauses are ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-page-lru-table.html
For more information about how the InnoDB manages buffer pool data, see Section 17.5.1, “Buffer Pool”. The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the ...For related usage information and examples, see Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool ...It has LRU_POSITION ...