优化数据库服务

MySQL :: MySQL 8.0 Reference Manual :: 8.12 Optimizing the MySQL Server

# 与服务有关的性能优化

# 与编程有关的性能优化

Optimization Overview
Optimizing SQL Statements
Optimization and Indexes
Optimizing Database Structure
Optimizing for InnoDB Tables
Optimizing for MyISAM Tables
Optimizing for MEMORY Tables
Understanding the Query Execution Plan
Controlling the Query Optimizer
Buffering and Caching
Optimizing Locking Operations
Valkey
Measuring Performance (Benchmarking)
Examining Thread Information

Index Merge Optimization
Full Table Scans
Opti-GROUP BY

Opti-ORDER BY
https://dev.mysql.com/doc/refman/5.7/en/order-by-optimization.html