MySQL Slow Query Log — Finding and Optimizing Slow Queries in Production
A detailed guide to configuring and analyzing MySQL Slow Query Log, using tools like pt-query-digest, and building a comprehensive query performance monitoring workflow.
6 articles
A detailed guide to configuring and analyzing MySQL Slow Query Log, using tools like pt-query-digest, and building a comprehensive query performance monitoring workflow.
A comprehensive guide to indexing strategies in MySQL: from B-Tree, Hash, Full-text to Composite Index, Covering Index, and anti-patterns to avoid.
A comprehensive guide to using EXPLAIN in MySQL to analyze execution plans, understand how MySQL processes queries, and systematically optimize query performance.
Master Eloquent Subqueries. Sort by relationships, safe memory usage, composite indexes, and advanced scope optimization.
Techniques to speed up your Laravel database queries: Eager Loading, Chunking, and more.
Optimizing PHP-FPM and Nginx for high-performance web applications.