6
MySQL Configuration Options
MySQL 5.5 supports more than 300 configurable system variables. Many system variables can have a significant effect on overall system performance when correctly tuned. System variables help to define how MySQL is configured, where important files and data reside, how to manage compatibility, interaction within a MySQL topology, and much more. In this chapter and for this book on optimizing SQL statements, we will focus on a small number of MySQL system variables that have a direct impact on the execution and optimization of individual SQL statements.
In this chapter we will discuss the following:
• Memory related ...
Get Effective MySQL Optimizing SQL Statements now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
