Not taking new projects at the moment. New orders and diagnostic calls are paused.
4 articles

backend

Backend engineering articles on API design, database modelling, microservices, performance tuning, and the architectural trade-offs behind each choice.


8 read
MySQL Slow Query Log: Find and Fix Your Slowest Queries
Turn on the MySQL slow query log, read it properly, and turn the worst offenders into fast queries. The practical way to find what's dragging your database down.

8 read
Why Is MySQL Using 100% CPU? Causes and How to Fix It
MySQL pinned at 100% CPU? Find the queries causing it, fix the real cause instead of upsizing the server, and stop it coming back. A practical diagnosis guide.

9 read
Why Is MySQL So Slow? A Diagnosis Checklist That Finds the Cause
MySQL slow and you don't know why? Work through this checklist, from slow queries and missing indexes to locking, disk, and config, to find the real cause fast.

17 read
MySQL Optimization: Complete Performance Tuning Guide
A practical MySQL optimization guide for faster queries: indexing, EXPLAIN analysis, query tuning, configuration, and performance monitoring.