Table of Contents
- 8.2.1 Optimizing SELECT Statements
- 8.2.2 Optimizing Subqueries, Derived Tables, and View References
- 8.2.3 Optimizing INFORMATION_SCHEMA Queries
- 8.2.4 Optimizing Data Change Statements
- 8.2.5 Optimizing Database Privileges
- 8.2.6 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. 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.
基于数据库的应用程序，其核心逻辑是通过SQL语句来执行的，不管是通过解释程序直接发出，还是通过API在后台提交。 本节介绍的调优指南，能有效提升基于MySQL的各种应用程序的执行速度。 内容涵盖了:
- SQL读写操作
- 常规SQL操作的隐形开销
- 在特定场景下使用的操作，例如数据库监控。
https://dev.mysql.com/doc/refman/5.7/en/statement-optimization.html