介绍

Optimization Overview 优化概述Optimizing SQL Statements 优化SQL语句Optimization and Indexes 优化和索引Optimizing Database Structure 优化数据库结构Optimizing for InnoDB Tables 优化InnoDB表Optimizing for MyISAM Tables 优化MyISAM表Optimizing for MEMORY Tables 优化MEMORY表Understanding the Query Execution Plan 了解查询执行计划Controlling the Query Optimizer 控制查询优化器Buffering and Caching 缓冲和缓存Optimizing Locking Operations 优化锁定操作Optimizing the MySQL Server 优化MySQL服务器Measuring Performance (Benchmarking) 衡量绩效（基准）Examining Thread Information 检查线程信息