Description
You’ll come across plenty of books that cover either the basics or the highly advanced aspects of MySQL performance—but very few that sit in the middle. That’s largely because it’s not easy to explain MySQL performance without diving into complex details. This hands-on guide fills that gap by helping software engineers build intermediate-level MySQL skills—going beyond the basics without requiring the deep internal knowledge expected of DBAs.
Daniel Nichter walks you through practical strategies and proven techniques that have a direct impact on MySQL performance. You’ll learn how to boost efficiency by evaluating query execution, designing effective indexes for common SQL patterns and joins, optimizing data access, and interpreting key MySQL metrics. The book also explains how factors like replication, transactions, row locking, and cloud environments affect overall performance.
Learn why query response time is the most critical indicator of MySQL performance
Understand query metrics, including how to aggregate, report, and analyze them
Build efficient indexes for common SQL clauses and join operations
Explore essential server metrics and what they reveal about system behavior
Gain practical insight into transactions and row-level locking
Improve MySQL performance effectively at any scale
Reviews
There are no reviews yet.