MySQL 8.4 Release Notes
- 10.2.1 SELECT 语句优化10.2.1 Optimizing SELECT Statements
- 10.2.2 子查询、派生表、视图引用和公共表表达式优化10.2.2 Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions
- 10.2.3 INFORMATION_SCHEMA 查询优化10.2.3 Optimizing INFORMATION_SCHEMA Queries
- 10.2.4 性能模式查询优化10.2.4 Optimizing Performance Schema Queries
- 10.2.5 数据修改语句优化10.2.5 Optimizing Data Change Statements
- 10.2.6 优化数据库权限10.2.6 Optimizing Database Privileges
- 10.2.7 其他优化技巧10.2.7 Other Optimization Tips
数据库应用程序的核心逻辑是通过 SQL 语句执行的,无论是通过解释器直接发出还是通过 API 在后台提交。本节中的优化指南有助于加快各种 MySQL 应用程序的运行速度。指南涵盖了读取和写入数据的 SQL 操作、一般 SQL 操作的后台开销,以及用于特定场景(如数据库监控)的操作。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. The tuning guidelines in this section help to speed up all kinds of MySQL applications. 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.