More resources, same root cause
Why upgrading CPU, RAM or IOPS rarely solves a mission-critical database slowdown — and what to check before signing the purchase order.
Performance-Tuning
5 tagged articles
Technical Leadership & Projects
MySQL
128 MB on a 32 GB machine: InnoDB buffer pool sizing in production
A MySQL 8.0 e-commerce with 32 GB RAM running on 128 MB buffer pool. How we diagnosed the issue, fixed it, and cut query latency from 45ms to 3ms.
Data Warehouse
ETL Oracle: from 4 hours to 25 minutes with staging tables, MERGE and parallel DML
A real Oracle 19c Data Warehouse case: how row-by-row inserts, missing indexes, and frequent COMMITs were killing a nightly ETL batch window.
Oracle
Research on millions of legal documents: how Oracle Text changed response times
How three Oracle Text indexes cut legal archive search times from 90 seconds to under 700ms. A real case with CONTEXT, CATSEARCH, and CTXXPATH.
MySQL
Swap at 100% on InnoDB Cluster: when join_buffer_size multiplies the problem
A MySQL InnoDB Cluster grinding to a halt due to join_buffer_size set to 2 GB per thread. Diagnosis, rolling restart, and the math behind per-thread buffers.