BestHub
Sign in
Tagged articles

invisible index

5 articles · Page 1 of 1
Cloud Architecture
Cloud Architecture
Sep 16, 2026 · Databases

When Indexes Become Write Killers: MySQL Order Table Write Performance Collapse Postmortem

Adding three secondary indexes to a MySQL 8.0 orders table caused write P99 latency to jump from 15ms to 2.3s and TPS to drop from 4800 to 1100 during peak hours; the article details a reproducible forensic process using A/B testing, invisible indexes, and sysbench to prove the culprit index had zero read benefit and safely remove it.

A/B testingInnoDBMySQL 8.0
0 likes · 23 min read
When Indexes Become Write Killers: MySQL Order Table Write Performance Collapse Postmortem
Architect's Tech Stack
Architect's Tech Stack
Jan 22, 2026 · Databases

Unlock MySQL 8.0: 8 Hidden Optimization Tricks You Must Know

This article reveals eight powerful, lesser‑known MySQL 8.0 features—including window functions, descending indexes, generated columns, invisible indexes, optimizer hints, resource groups, LATERAL JOIN, and multi‑valued JSON indexes—showing how they dramatically improve query performance and simplify complex SQL tasks.

LATERAL JOINResource GroupSQL optimization
0 likes · 12 min read
Unlock MySQL 8.0: 8 Hidden Optimization Tricks You Must Know