InnoDB

No Picture
InnoDB

InnoDB Reading and Writing Blocks Explained

InnoDB, the default storage engine in MySQL, uses a buffer pool to manage the reading and writing of data blocks. The buffer pool is a cache that holds frequently accessed data pages in memory, reducing […]
No Picture
MySQL Internals

MySQL Streaming Versus Blocking Operators Explained

In MySQL, operators in a query execution plan can be classified as streaming or blocking. This classification is based on how they process and propagate rows during query execution. Let’s explore the differences between streaming […]
No Picture
MySQL Internals

InnoDB MVCC: How It Is Implemented

Multiversion Concurrency Control (MVCC) is a mechanism that is used by InnoDB, the default storage engine in MySQL, to provide transactional consistency and support for concurrent access to the same data. In InnoDB, MVCC is […]
No Picture
MinervaDB

InnoDB early lock release

InnoDB early lock release is a feature in MySQL 8 and higher that allows the database to release locks earlier in the transaction processing process. This helps to reduce lock contention and improve overall performance. […]
No Picture
MinervaDB

InnoDB Page Compression: How It Is Implemented

Page compression is implemented in InnoDB using the “Compressed InnoDB Tables” feature. This feature compresses the data stored in individual pages of the InnoDB tables, reducing their size and thus reducing the amount of disk […]
No Picture
MySQL Performance

InnoDB Data Files: How They Are Managed

How data files are managed in InnoDB? In InnoDB, data files are managed using a combination of data dictionary tables and system tablespace files. Data dictionary tables: InnoDB stores metadata about the database, such as [...]