8.1 Optimization Overview

8.1.1 MySQL Design Limitations and Tradeoffs
8.1.2 Designing Applications for Portability
8.1.3 The MySQL Benchmark Suite
8.1.4 Using Your Own Benchmarks

The most important factor in making a system fast is its basic design. You must also know what kinds of processing your system is doing, and what its bottlenecks are. In most cases, system bottlenecks arise from these sources: