MySQL – Optimizing Database Structure

參考: http://dev.mysql.com/doc/refman/5.0/en/optimizing-database-structure.html 7.4.1. Make Your Data as Small as Possible 7.4.2. Column Indexes 7.4.3. Multiple-Column Indexes 7.4.4. How MySQL Uses Indexes 7.4.5. The MyISAM Key Cache 7.4.6. MyISAM Index Statistics Collection 7.4.7. How MySQL Opens and Closes Tables 7.4.8. Disadvantages of Creating Many Tables in the Same Database 減少 record structure 的大小 – Numeric Types […]