The slow query log only shows you part of the picture. Learn to use MySQL Performance Schema to uncover lock waits, I/O lag, and query patterns your logs miss.
JSON columns in MySQL are powerful but misunderstood. Here's a practical guide for PHP developers on when JSON makes sense, how to query it efficiently, and the indexing tricks that keep things fast.