MySQL 5.1 Reference Manual :: 7 Optimization :: 7.4 Optimizing Database Structure
Section Navigation [Toggle]
- 7 Optimization
- 7.1 Optimization Overview
- 7.2 Optimizing SELECT and Other Statements
- 7.3 Locking Issues
- 7.4 Optimizing Database Structure
- 7.4.1 Make Your Data as Small as Possible
- 7.4.2 Column Indexes
- 7.4.3 Multiple-Column Indexes
- 7.4.4 How MySQL Uses Indexes
- 7.4.5 The MyISAM Key Cache
- 7.4.6 The InnoDB Buffer Pool
- 7.4.7 MyISAM Index Statistics Collection
- 7.4.8 How MySQL Opens and Closes Tables
- 7.4.9 Disadvantages of Creating Many Tables in the Same Database
- 7.5 Optimizing the MySQL Server
- 7.6 Disk Issues
[+/-]
- 7.4.1. Make Your Data as Small as Possible
- 7.4.2. Column Indexes
- 7.4.3. Multiple-Column Indexes
- 7.4.4. How MySQL Uses Indexes
- 7.4.5. The
MyISAMKey Cache - 7.4.6. The
InnoDBBuffer Pool - 7.4.7.
MyISAMIndex Statistics Collection - 7.4.8. How MySQL Opens and Closes Tables
- 7.4.9. Disadvantages of Creating Many Tables in the Same Database
User Comments
Add your own comment.