No Picture
MinervaDB

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
MySQL Performance

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
MySQL Performance

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 [...]
No Picture
MySQL Performance

How slow queries affect MySQL performance?

How slow queries affect MySQL performance? Slow queries can have a significant impact on the performance of a MySQL server. When a query takes a long time to execute, it can consume a large amount [...]