No Picture
InnoDB

Streaming versus blocking operators in MySQL

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

No Picture
MinervaDB

MySQL Scalar Subquery Unnesting transformation

Scalar subquery unnesting is a transformation technique used by the MySQL optimizer to optimize queries that involve scalar subqueries. Scalar subqueries are subqueries that return a single value, typically used in expressions or as part […]

No Picture
MinervaDB

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
MinervaDB

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