MySQL 5.0 Reference Manual :: 7 Optimization
Section Navigation [Toggle]
- Preface and Legal Notice
- 1 General Information
- 2 Installing and Upgrading MySQL
- 3 Tutorial
- 4 MySQL Programs
- 5 MySQL Server Administration
- 6 Backup and Recovery
- 7 Optimization
- 7.1 Optimization Overview
- 7.2 Obtaining Query Execution Plan Information
- 7.3 Optimizing SQL Statements
- 7.4 Controlling the Query Optimizer
- 7.5 Optimization and Indexes
- 7.6 Buffering and Caching
- 7.7 Locking Issues
- 7.8 Optimizing Database Structure
- 7.9 Optimizing the MySQL Server
- 7.10 Examining Thread Information
- 8 Language Structure
- 9 Globalization
- 10 Data Types
- 11 Functions and Operators
- 12 SQL Statement Syntax
- 13 Storage Engines
- 14 High Availability and Scalability
- 15 Replication
- 16 MySQL Cluster
- 17 Stored Programs and Views
- 18 INFORMATION_SCHEMA Tables
- 19 Connectors and APIs
- 20 Extending MySQL
- 21 MySQL Enterprise Monitor
- 22 MySQL Enterprise Backup
- A Licenses for Third-Party Components
- B MySQL 5.0 Frequently Asked Questions
- C Errors, Error Codes, and Common Problems
- D MySQL Change History
- E Restrictions and Limits
- Index
- Standard Index
- C Function Index
- Command Index
- Function Index
- INFORMATION_SCHEMA Index
- Transaction Isolation Level Index
- JOIN Types Index
- Operator Index
- Option Index
- Privileges Index
- SQL Modes Index
- Status Variable Index
- Statement/Syntax Index
- System Variable Index
Table of Contents [+/-]
- 7.1. Optimization Overview [+/-]
- 7.2. Obtaining Query Execution Plan Information [+/-]
- 7.3. Optimizing SQL Statements [+/-]
- 7.4. Controlling the Query Optimizer
- 7.5. Optimization and Indexes [+/-]
- 7.6. Buffering and Caching [+/-]
- 7.7. Locking Issues [+/-]
- 7.8. Optimizing Database Structure [+/-]
- 7.9. Optimizing the MySQL Server [+/-]
- 7.10. Examining Thread Information [+/-]
- 7.10.1. Thread Command Values
- 7.10.2. General Thread States
- 7.10.3. Delayed-Insert Thread States
- 7.10.4. Query Cache Thread States
- 7.10.5. Replication Master Thread States
- 7.10.6. Replication Slave I/O Thread States
- 7.10.7. Replication Slave SQL Thread States
- 7.10.8. Replication Slave Connection Thread States
- 7.10.9. MySQL Cluster Thread States
This chapter explains different ways to optimize MySQL and provides examples. Optimization is a complex task because ultimately it requires understanding of the entire system to be optimized. Although it may be possible to perform some local optimizations with little knowledge of your system or application, the more optimal you want your system to become, the more you must know about it.
Copyright © 1997, 2012, Oracle and/or its affiliates. All
rights reserved.
Legal Notices
User Comments
Add your own comment.