#MySQL

6 articles

MySQL database management and optimization. Covers indexing, query optimization, replication, backup strategies, and performance tuning.

database sql indexing optimization replication

Database Read Replicas with Laravel: Optimizing Query Performance

Guide to setting up and using Database Read Replicas in Laravel with MySQL and PostgreSQL. Query routing, failover handling, and best practices.

laravel mysql postgresql +3 more

May 3, 2026

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.

mysql database performance +3 more

Apr 17, 2026

MySQL Indexing Strategies — Designing Effective Indexes for Every Use Case

A comprehensive guide to indexing strategies in MySQL: from B-Tree, Hash, Full-text to Composite Index, Covering Index, and anti-patterns to avoid.

mysql database performance +3 more

Apr 16, 2026

MySQL Query Optimization with EXPLAIN — Understanding and Tuning Queries from the Ground Up

A comprehensive guide to using EXPLAIN in MySQL to analyze execution plans, understand how MySQL processes queries, and systematically optimize query performance.

mysql database performance +3 more

Apr 15, 2026

Docker Dev Environment (Part 3): PHP-FPM, Multiple Databases & Dev Tools

Complete the Docker dev environment with multi-version PHP-FPM containers, MySQL 5.7/8.0/8.4, Adminer, Mailpit for email testing, and a Makefile workflow for daily development.

docker php mysql +4 more

Mar 25, 2026

Database Indexing 101 for Laravel Developers

Why is your query slow? It's probably missing an index. Learn the basics of database indexing within Laravel Migrations.

laravel database mysql +1 more

Feb 10, 2026

Articles List

Database Read Replicas with Laravel: Optimizing Query Performance

MySQL Slow Query Log — Finding and Optimizing Slow Queries in Production

MySQL Indexing Strategies — Designing Effective Indexes for Every Use Case

MySQL Query Optimization with EXPLAIN — Understanding and Tuning Queries from the Ground Up

Docker Dev Environment (Part 3): PHP-FPM, Multiple Databases & Dev Tools

Database Indexing 101 for Laravel Developers

Related Topics