MySQL Manual
5 MySQL Optimisation
- 5.1 Optimisation Overview
- 5.2 Optimising
SELECTs and Other Queries - 5.3 Locking Issues
- 5.4 Optimising Database Structure
- 5.5 Optimising the MySQL Server
- 5.6 Disk Issues
5.4 Optimising Database Structure
Subsections
- 5.4.1 Design Choices
- 5.4.2 Get Your Data as Small as Possible
- 5.4.3 How MySQL Uses Indexes
- 5.4.4 Column Indexes
- 5.4.5 Multiple-Column Indexes
- 5.4.6 Why So Many Open tables?
- 5.4.7 How MySQL Opens and Closes Tables
- 5.4.8 Drawbacks to Creating Large Numbers of Tables in the Same Database
