8.2.1 Optimizing SELECT Statements
优化SELELCT 语句
8.2.2 Optimizing Subqueries, Derived Tables, and View References
优化子查询、派生表和视图引用
8.2.3 Optimizing INFORMATION_SCHEMA Queries
优化INFORMATION_SCHEMA查询
8.2.4 Optimizing Data Change Statements
优化数据变更语句
8.2.5 Optimizing Database Privileges
8.2.6 Other Optimization Tips8.2.1 Optimizing SELECT Statementsy
其他的优化技巧
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操作的幕后开销,以及在数据库监视等特定场景中使用的操作。