MySQL with Diagrams Part Three: The Life Story of the Writing Process

Sep 17, 2025 | Insight for DBAs, MySQL

When you run a simple write, …it may look simple, but under the hood, MySQL’s InnoDB engine kicks off a pretty complex sequence to ensure your data stays safe, consistent, and crash-recoverable. In the top-left corner of the diagram, we see exactly where this begins — the moment the query is executed:

The log […]

MySQL with Diagrams Part Two: How KILL Works

Jan 07, 2025 | Insight for DBAs, MySQL

Here is part two of my MySQL with Diagrams series (Here’s part one – MySQL with Diagrams Part One: Replication Architecture). We are going to explore how MySQL handles thread termination using the KILL command, as visualized in the provided diagram, and provide sample demonstrations to help you better understand. Many people think they know […]

MySQL with Diagrams Part One: Replication Architecture

Dec 12, 2024 | Insight for DBAs, MySQL

In this series, “MySQL with Diagrams,” I’ll use diagrams to explain internals, architectures, and structures as detailed as possible. In basic terms, here’s how replication works: the transactions are written into a binary log on the source side, carried into the replica, and applied. The replica’s connection metadata repository contains information that the replication receiver […]

Tracking Dual Passwords in MySQL

Oct 31, 2024 | Insight for DBAs, MySQL

We already have blog posts about Dual Password in MySQL from Brian Sumpter – Using MySQL 8 Dual Passwords, and from Marco Tusa – MySQL Dual Passwords – How To Manage Them Programmatically Let’s skip the details about dual passwords and focus on tracking password usage. How can we be sure that we are using […]

Dynamic SQL Workaround in MySQL: Prepared Statements

Jul 31, 2023 | Insight for DBAs, Insight for Developers, MySQL

Dynamic SQL is a desirable feature that allows developers to construct and execute SQL statements dynamically at runtime. While MySQL lacks built-in support for dynamic SQL, this article presents a workaround using prepared statements. We will explore leveraging prepared statements to achieve dynamic query execution, parameterized queries, and dynamic table and column selection. Understanding prepared […]