8.11 Optimizing the MySQL Server

8.11.1 System Factors and Startup Parameter Tuning
8.11.2 Tuning Server Parameters
8.11.3 Optimizing Disk I/O
8.11.4 Optimizing Memory Use
8.11.5 Optimizing Network Use
8.11.6 The Thread Pool Plugin

This section discusses optimization techniques for the database server, primarily dealing with system configuration rather than tuning SQL statements. The information in this section is appropriate for DBAs who want to ensure performance and scalability across the servers they manage; for developers constructing installation scripts that include setting up the database; and people running MySQL themselves for development, testing, and so on who want to maximize their own productivity.