Knowledge units

Blogs

Technical ideas, implementation notes, and the reasoning behind engineering decisions.

CategoryBackend Database Distributed Systems Full Stack DevOps

TagsArchitecture Caching Compatibility Docker Indexing Java MySQL Next.js Performance REST API Redis Resilience Spring Boot TypeScript Validation Clear filter

blogDatabaseUpdated Aug 10, 2026

MySQL Indexes: From a Slow Query to a Better B+ Tree

Tracing one slow query through execution plans, composite indexes, selectivity, and the tradeoffs behind faster reads.

MySQL Indexing Performance