The record
Impact
Every figure is a real production result, a before and an after I can point to. Some link to the full story; more get written over time.
Fig. A
Query collapse
2,000,000→2408,000× fewer
A single request was firing millions of database queries. Reworked the access path down to a few hundred, same result.
Fig. B
DB CPU at peak
99%→45%zero alerts
Peak database CPU sat near 99% and paged on-call. Cut sustained peak load to 45%, with no alerts since.
Fig. C
Report build
60s→5s12× faster
Reports on a 4 GB MariaDB hit one-minute timeouts. Moved analytics to ClickHouse; they return in five seconds.
Read the storyFig. D
Order routing
manual→70% autohands-off
Order shipping was fully manual. Automated the routing pipeline so most orders now ship without a human in the loop.
Fig. E
Traffic at scale
2M visitors→100M req/mosteady on AWS
Ran a platform serving 2M visitors and nearly 100M requests a month on AWS, holding steady under load.
Fig. F
DDoS absorbed
7M req/min→0 downtimeattack blocked
A DDoS attack hit 7M requests in a single minute. Held the edge and blocked it with no downtime for real users.