Posts tagged "MySQL"
Essays, field notes, and engineering write-ups by Al Amin Ahamed covering MySQL — practical patterns, gotchas from production code, and lessons learned shipping real systems. Topics include architecture decisions, performance tuning, debugging stories, and integration notes you can apply directly to your own MySQL work.
· 8 min read
Hunting N+1 Queries in Laravel: Tools, Strict Mode, and Fixes
How to find N+1 queries with Telescope, Debugbar, and preventLazyLoading() — and the eager-loading patterns that fix them, including the polymorphic gotcha.
· 9 min read
10 Eloquent Query Optimizations, in Order of Effectiveness
A systematic optimization checklist for Eloquent — select(), chunk(), chunkById(), withCount(), pluck(), subquery selects, and when to bypass the model layer entirely.
· 8 min read
Scaling WordPress: Redis Object Cache, Query Optimization, and Page Caching
A systematic guide to making WordPress fast — from Redis object caching and WP_Query optimization to FastCGI page cache and CDN asset delivery.