MySQL Manual
5 MySQL Optimisation
- 5.4 Optimising Database Structure
- 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
5.4.8 Drawbacks to Creating Large Numbers of Tables in the Same Database
If you have many files in a directory, open, close, and create operations will
be slow. If you execute SELECT statements on many different tables,
there will be a little overhead when the table cache is full, because for
every table that has to be opened, another must be closed. You can reduce
this overhead by making the table cache larger.
