Tagged articles

index governance

3 articles · Page 1 of 1

Sep 19, 2026 · Databases

Beyond COUNT_STAR=0: Auditable MySQL Index Removal with performance_schema

This article presents a rigorous, production-ready framework for MySQL index governance that moves beyond simplistic zero-usage checks, using performance_schema observation windows, structural gatekeeping, invisible index canary testing, and quantified rollback metrics to safely identify and remove redundant indexes without risking query regressions.

MySQLObservabilitySQL Tuning

0 likes · 29 min read

Beyond COUNT_STAR=0: Auditable MySQL Index Removal with performance_schema

Cloud Architecture

Sep 18, 2026 · Databases

From Ad-Hoc Indexing to Verifiable Governance: MySQL Index Governance at Scale

This article details a production-grade MySQL index governance system for high-concurrency e-commerce, covering evidence collection, invisible index validation, automated change gates, regression detection, and a case study reducing order-list P99 from 2.3s to 170ms while preventing unsafe deletions.

High ConcurrencyMySQLe-commerce

0 likes · 38 min read

From Ad-Hoc Indexing to Verifiable Governance: MySQL Index Governance at Scale

Cloud Architecture

Sep 17, 2026 · Databases

Indexes Aren't Free: Production Index Governance for High-Write Order Systems

This article presents a comprehensive index governance methodology for high-write MySQL order systems, demonstrating through a real incident how a read-optimized index caused write latency, replica lag, and timeouts, and detailing a reusable process covering query-driven design, cost measurement, validation, change buffer limits, index convergence, safe deletion, read-write routing, sharding, transactional outbox, idempotent consumers, online DDL safeguards, gating, and long-term ownership.

Change BufferDescending IndexesHigh-Write Systems

0 likes · 29 min read

Indexes Aren't Free: Production Index Governance for High-Write Order Systems