MySQL Performance

No Picture
InnoDB

InnoDB Process Global Area: How It Is Managed

  InnoDB: Management of the Process Global Area (PGA) In InnoDB, the Process Global Area (PGA) manages per-connection memory and data structures for each client connection, including query execution buffers, sort buffers, and join buffers. […]
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 Redo Performance: Troubleshooting Tips and Tricks

Troubleshooting redo performance in InnoDB involves identifying and addressing potential bottlenecks or issues that affect the efficiency of redo log processing. The redo log plays a critical role in ensuring data durability and crash recovery […]
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

MySQL UNDO Operations: Tuning Guide

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

MySQL Lock Contention: How to Reduce It

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