8.2 Optimizing SQL Statements优化SQL语句

8.2.1 Optimizing SELECT Statements优化SELECT语句
8.2.2 Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions优化子查询、派生表、视图引用和公共表表达式
8.2.3 Optimizing INFORMATION_SCHEMA Queries用SCHEMA查询优化信息
8.2.4 Optimizing Performance Schema Queries优化性能架构查询
8.2.5 Optimizing Data Change Statements优化数据更改语句
8.2.6 Optimizing Database Privileges优化数据库权限
8.2.7 Other Optimization Tips其他优化提示

The core logic of a database application is performed through SQL statements, whether issued directly through an interpreter or submitted behind the scenes through an API. 数据库应用程序的核心逻辑是通过SQL语句执行的,无论是通过解释器直接发出的,还是通过API在后台提交的。The tuning guidelines in this section help to speed up all kinds of MySQL applications. 本节中的调优指南有助于提高各种MySQL应用程序的速度。The guidelines cover SQL operations that read and write data, the behind-the-scenes overhead for SQL operations in general, and operations used in specific scenarios such as database monitoring.这些指导方针包括读写数据的SQL操作、一般SQL操作的幕后开销,以及在特定场景(如数据库监视)中使用的操作。

8.2.1 Optimizing SELECT Statements优化SELECT语句
8.2.2 Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions优化子查询、派生表、视图引用和公共表表达式
8.2.3 Optimizing INFORMATION_SCHEMA Queries用SCHEMA查询优化信息
8.2.4 Optimizing Performance Schema Queries优化性能架构查询
8.2.5 Optimizing Data Change Statements优化数据更改语句
8.2.6 Optimizing Database Privileges优化数据库权限
8.2.7 Other Optimization Tips其他优化提示