Tagged articles

invisible indexes

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.

MySQLOnline DDLe-commerce

0 likes · 38 min read

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

Aikesheng Open Source Community

Aug 7, 2023 · Databases

Understanding Invisible Columns, Generated Invisible Primary Keys, and Invisible Indexes in MySQL 8.0

This article explains three relatively new MySQL 8.0 features—hidden (invisible) columns, generated invisible primary keys, and invisible indexes—detailing their purpose, how to create and use them, and practical scenarios where they can help avoid schema‑change issues or test query performance.

Generated Primary KeyInvisible ColumnsMySQL

0 likes · 11 min read

Understanding Invisible Columns, Generated Invisible Primary Keys, and Invisible Indexes in MySQL 8.0