— Writing —
A plain-English guide to non-SARGable SQL: types of queries that suppress indexes, what you see in production (p99, CPU, pools), simple fixes, and EXPLAIN signals — plus a short real mistake I made.
Vector Search Explained: From KNN to HNSW — A Complete Guide
How similarity search works under the hood — and why naive brute-force collapses at scale.
MySQL Query Optimization: Real Lessons from a 36GB Index Disaster
What happens when your index outgrows your data — and how we fixed it without downtime in production.
| Article | Topic | Keywords | Read | Date |
|---|---|---|---|---|
Vector Search Explained: From KNN to HNSW — A Complete Guide↗ How similarity search works under the hood — and why naive brute-force collapses at scale. | Database · Query Optimization | Search · ML | 13 min read | |
MySQL Query Optimization: Real Lessons from a 36GB Index Disaster↗ What happens when your index outgrows your data — and how we fixed it without downtime in production. | Database · Query Optimization | MySQL · Production | 5 min read |