(mysql.info.gz) Optimizing Database Structure

Info Catalog

(mysql.info.gz) Locking Issues

(mysql.info.gz) MySQL Optimization

(mysql.info.gz) Optimizing the Server

 
 7.4 Optimizing Database Structure
 =================================
 

Menu

 
* Design                      Design Choices
* Data size                   Make Your Data as Small as Possible
* Indexes                     Column Indexes
* Multiple-column indexes     Multiple-Column Indexes
* MySQL indexes               How MySQL Uses Indexes
* MyISAM key cache            The `MyISAM' Key Cache
* Open tables                 How MySQL Counts Open Tables
* Table cache                 How MySQL Opens and Closes Tables
* Creating many tables        Drawbacks to Creating Many Tables in the Same Database
 

Info Catalog

(mysql.info.gz) Locking Issues

(mysql.info.gz) MySQL Optimization

(mysql.info.gz) Optimizing the Server