MySQL DBA

MySQL DBA Support and Remote DBA Services

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