No Picture
DBA

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
InnoDB

How is page compression implemented in InnoDB?

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
DBA

How partition pruning improved with MySQL 8?

In MySQL 8, partition pruning has been improved to make it more efficient and flexible. Partition pruning is a performance optimization technique that helps to minimize the amount of data that needs to be scanned […]

No Picture
DBA

How data files are managed in InnoDB?

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 [...]