MySQL Performance

No Picture
InnoDB

Reading and Writing Blocks in InnoDB

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

Streaming versus blocking operators in MySQL

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

MySQL Scalar Subquery Unnesting transformation

Scalar subquery unnesting is a transformation technique that the MySQL optimizer uses to optimize queries involving scalar subqueries. Scalar subqueries return a single value. You typically use them in expressions or as part of the […]
No Picture
MySQL Performance

Tuning UNDO Operations in MySQL

In MySQL, undo operations are used to provide transactional consistency and to allow for rolling back changes made to the database during a transaction. Undo operations are implemented in the InnoDB storage engine, which is […]
No Picture
MySQL Performance

How can you reduce lock contention in MySQL?

Reducing lock contention in MySQL involves implementing various techniques and strategies that help minimize the occurrence of lock-related performance issues. Here are some of the ways to reduce lock contention in MySQL: By implementing these […]