:: DEVELOPER ZONE
MySQL Reference Manual :: 7 MySQL Optimization
Search the MySQL manual:
- Preface
- 1 General Information
- 2 Installing MySQL
- 3 MySQL Tutorial
- 4 Using MySQL Programs
- 5 Database Administration
- 6 Replication in MySQL
- 7 MySQL Optimization
- 8 MySQL Client and Utility Programs
- 9 Language Structure
- 10 Character Set Support
- 11 Column Types
- 12 Functions and Operators
- 13 SQL Statement Syntax
- 14 MySQL Storage Engines and Table Types
- 15 The InnoDB Storage Engine
- 16 MySQL Cluster
- 17 Introduction to MaxDB
- 18 Spatial Extensions in MySQL
- 19 Stored Procedures and Functions
- 20 Triggers
- 21 Views
- 22 The INFORMATION_SCHEMA Information Database
- 23 Precision Math
- 24 MySQL APIs
- 25 MySQL Connectors
- 26 Error Handling in MySQL
- 27 Extending MySQL
- A Problems and Common Errors
- B Credits
- C MySQL and the Future (the TODO)
- D MySQL Change History
- E Porting to Other Systems
- F Environment Variables
- G MySQL Regular Expressions
- H GNU General Public License
- I MySQL FLOSS License Exception
- Index
Additional languages
Additional formats
Table of Contents
- 7.1. Optimization Overview
- 7.2. Optimizing
SELECTStatements and Other Queries - 7.2.1.
EXPLAINSyntax (Get Information About aSELECT) - 7.2.2. Estimating Query Performance
- 7.2.3. Speed of
SELECTQueries - 7.2.4. How MySQL Optimizes
WHEREClauses - 7.2.5. Range Optimization
- 7.2.6. Index Merge Optimization
- 7.2.7. How MySQL Optimizes
IS NULL - 7.2.8. How MySQL Optimizes
DISTINCT - 7.2.9. How MySQL Optimizes
LEFT JOINandRIGHT JOIN - 7.2.10. How MySQL Optimizes
ORDER BY - 7.2.11. How MySQL Optimizes
GROUP BY - 7.2.12. How MySQL Optimizes
LIMIT - 7.2.13. How to Avoid Table Scans
- 7.2.14. Speed of
INSERTStatements - 7.2.15. Speed of
UPDATEStatements - 7.2.16. Speed of
DELETEStatements - 7.2.17. Other Optimization Tips
- 7.2.1.
- 7.3. Locking Issues
- 7.4. Optimizing Database Structure
- 7.4.1. Design Choices
- 7.4.2. Make Your Data as Small as Possible
- 7.4.3. Column Indexes
- 7.4.4. Multiple-Column Indexes
- 7.4.5. How MySQL Uses Indexes
- 7.4.6. The
MyISAMKey Cache - 7.4.7. How MySQL Counts Open Tables
- 7.4.8. How MySQL Opens and Closes Tables
- 7.4.9. Drawbacks to Creating Many Tables in the Same Database
- 7.5. Optimizing the MySQL Server
- 7.6. Disk Issues
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 have to know about it.
This chapter tries to explain and give some examples of different ways to optimize MySQL. Remember, however, that there are always additional ways to make the system even faster, although they may require increasing effort to achieve.
© 1995-2005 MySQL AB. All rights reserved.
User Comments
Warning: query failed: Unknown column 'user.firstname' in 'field list' in /data0/sites/live/web-main/lib/mysql-cxn.php on line 69
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data0/sites/live/web-main/lib/docbook.php on line 245
Add your own comment.