Getting the Best MySQL Performance in Your Products: Part I, The Basics
This first presentation in a four-part series takes you through the basic steps of architecting your product's MySQL embedded or bundled database for higher performance.
You will learn the first steps to take when designing your product’s database for high performances, and how to spot and quickly resolve the most common performance bottlenecks.
The presentation covers the following topics:
- Critical performance-related server settings
- How to use Indexes
- How to use EXPLAIN to verify query execution plans
- How to identify and resolve common performance problems