8.8 Optimizing Database Structure

8.8.1 Make Your Data as Small as Possible
8.8.2 Using PROCEDURE ANALYSE
8.8.3 How MySQL Opens and Closes Tables
8.8.4 Disadvantages of Creating Many Tables in the Same Database
8.8.5 How MySQL Uses Internal Temporary Tables