MySQL InnoDB Explained: Core Architecture & Performance
A practical guide to MySQL InnoDB internals: clustered indexes, the buffer pool, redo and undo logs, MVCC, row-level locking, and the tuning moves that matter most.
September 19, 2026 · 11 min read
Mobin Yazdanparast
MySQL Architecture Explained: Layers, InnoDB & Query Flow
Understand how MySQL handles connections, parses and optimizes SQL, delegates work to storage engines, and uses InnoDB memory and disk structures to manage data.
September 13, 2026 · 14 min read
Mobin Yazdanparast
What We Learned Building DBO Studio 1.1.0
DBO Studio 1.1.0 is about removing uncertainty: schema diagrams for unfamiliar databases, Safe Mode for the wrong connection, typed editors for real column types, and pagination so a SELECT without LIMIT no longer means fetch everything.
September 3, 2026 · 8 min read
Mobin Yazdanparast
What Is a Database Index? A Beginner's Guide
A clear explanation of what a database index is, how it improves data retrieval speed, and the structural trade-offs involved in SQL index creation.
August 4, 2026 · 9 min read
Mobin Yazdanparast