MySQL 调优（视野二 都可优化什么）

• 8.1 Optimization Overview
• 8.2 Optimizing SQL Statements
  • 8.2.1 Optimizing SELECT Statements
  • 8.2.2 Optimizing Subqueries and Derived Tables
  • 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
• 8.3 Optimization and Indexes
  • 8.3.1 How MySQL Uses Indexes
  • 8.3.2 Primary Key Optimization
  • 8.3.3 Foreign Key Optimization
  • 8.3.4 Column Indexes
  • 8.3.5 Multiple-Column Indexes
  • 8.3.6 Verifying Index Usage
  • 8.3.7 InnoDB and MyISAM Index Statistics Collection
  • 8.3.8 Comparison of B-Tree and Hash Indexes
  • 8.3.9 Use of Index Extensions
  • 8.3.10 Indexed Lookups from TIMESTAMP Columns
• 8.4 Optimizing Database Structure
  • 8.4.1 Optimizing Data Size
  • 8.4.2 Optimizing MySQL Data Types
  • 8.4.3 Optimizing for Many Tables
  • 8.4.4 Internal Temporary Table Use in MySQL
  • 8.4.5 Limits on Number of Databases and Tables
  • 8.4.6 Limits on Table Size
  • 8.4.7 Limits on Table Column Count and Row Size
• 8.5 Optimizing for InnoDB Tables
  • 8.5.1 Optimizing Storage Layout for InnoDB Tables
  • 8.5.2 Optimizing InnoDB Transaction Management
  • 8.5.3 Optimizing InnoDB Read-Only Transactions
  • 8.5.4 Optimizing InnoDB Redo Logging
  • 8.5.5 Bulk Data Loading for InnoDB Tables
  • 8.5.6 Optimizing InnoDB Queries
  • 8.5.7 Optimizing InnoDB DDL Operations
  • 8.5.8 Optimizing InnoDB Disk I/O
  • 8.5.9 Optimizing InnoDB Configuration Variables
  • 8.5.10 Optimizing InnoDB for Systems with Many Tables
• 8.6 Optimizing for MyISAM Tables
  • 8.6.1 Optimizing MyISAM Queries
  • 8.6.2 Bulk Data Loading for MyISAM Tables
  • 8.6.3 Optimizing REPAIR TABLE Statements
• 8.7 Optimizing for MEMORY Tables
• 8.8 Understanding the Query Execution Plan
  • 8.8.1 Optimizing Queries with EXPLAIN
  • 8.8.2 EXPLAIN Output Format
  • 8.8.3 Extended EXPLAIN Output Format
  • 8.8.4 Estimating Query Performance
• 8.9 Controlling the Query Optimizer
  • 8.9.1 Controlling Query Plan Evaluation
  • 8.9.2 Switchable Optimizations
  • 8.9.3 Index Hints
• 8.10 Buffering and Caching
  • 8.10.1 InnoDB Buffer Pool Optimization
  • 8.10.2 The MyISAM Key Cache
  • 8.10.3 The MySQL Query Cache
  • 8.10.4 Caching of Prepared Statements and Stored Programs
• 8.11 Optimizing Locking Operations
  • 8.11.1 Internal Locking Methods
  • 8.11.2 Table Locking Issues
  • 8.11.3 Concurrent Inserts
  • 8.11.4 Metadata Locking
  • 8.11.5 External Locking
• 8.12 Optimizing the MySQL Server
  • 8.12.1 System Factors
  • 8.12.2 Optimizing Disk I/O
  • 8.12.3 Using Symbolic Links
  • 8.12.4 Optimizing Memory Use
• 8.13 Measuring Performance (Benchmarking)
  • 8.13.1 Measuring the Speed of Expressions and Functions
  • 8.13.2 The MySQL Benchmark Suite
  • 8.13.3 Using Your Own Benchmarks
  • 8.13.4 Measuring Performance with performance_schema
• 8.14 Examining Server Thread (Process) Information
  • 8.14.1 Accessing the Process List
  • 8.14.2 Thread Command Values
  • 8.14.3 General Thread States
  • 8.14.4 Delayed-Insert Thread States
  • 8.14.5 Query Cache Thread States
  • 8.14.6 Replication Source Thread States
  • 8.14.7 Replication Replica I/O Thread States
  • 8.14.8 Replication Replica SQL Thread States
  • 8.14.9 Replication Replica Connection Thread States
  • 8.14.10 NDB Cluster Thread States
  • 8.14.11 Event Scheduler Thread States