DEVELOPER ZONE ::
Login
/
Register
Home
Products
Services
Partners
Community
Customers
News & Events
About
Why MySQL?
How to Buy
Documentation
MySQL 5.0 Reference Manual
5.1
5.0
3.23, 4.0, 4.1
Search manual:
Additional languages
French
Spanish
MySQL 5.0 Reference Manual
::
7 Optimization
:: 7.4 Optimizing Database Structure
« 7.3.4 External Locking
7.4.1 Design Choices »
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 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 MyISAM Key Cache
7.4.7 MyISAM Index Statistics Collection
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
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
MyISAM
Key Cache
7.4.7.
MyISAM
Index Statistics Collection
7.4.8. How MySQL Opens and Closes Tables
7.4.9. Drawbacks to Creating Many Tables in the Same Database
Previous
/
Next
/
Up
/
Table of Contents
User Comments
Add your own comment.
Top
/
Previous
/
Next
/
Up
/
Table of Contents
User Comments
Add your own comment.