GNU Info

(mysql.info)Optimizing Database Structure

---

Next: Optimizing the Server Prev: Locking Issues Up: MySQL Optimization

---

Enter node , (file) or (file)node

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

Design

Design Choices

Data size

Get Your Data as Small as Possible

MySQL indexes

How MySQL Uses Indexes

Indexes

Column Indexes

Multiple-column indexes

Multiple-Column Indexes

Table cache

How MySQL Opens and Closes Tables

Creating many tables

Drawbacks to Creating Large Numbers of Tables in the Same Database

Open tables

Why So Many Open tables?