本节讨论数据库服务器的优化技术,主要涉及系统配置,而不是调整 SQL 语句。本节的信息适用于希望确保其管理的服务器性能和可扩展性的数据库管理员;用于构建包含数据库设置的安装脚本的开发人员;以及希望最大化自身生产力的自行运行 MySQL 进行开发、测试等的人群。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.