Java Backend Technology

May 1, 2019 · Databases

Why MySQL COUNT(*) Is Slow on InnoDB but Instant on MyISAM – A Deep Dive

This article explains the mechanisms behind MySQL's SELECT COUNT(*) operation, comparing InnoDB's row‑by‑row scan with MyISAM's constant‑time meta count, and explores execution steps, visibility rules, data structures, and performance implications.