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 參考表
(用 MEDIUMINT 3bytes 比 INT 4bytes 好 , 若資料內容不可能有負值那加上 UNSIGNED , 則數值範圍可多一倍!)
Comments Off
Related URL:
- install oracle 11g steps
- 一些 memcache 的資料
- Protected: Oracle down time / problem records / 經典
- Database administrator
- 在 gentoo 裝 oracle sqlplus package
- Graphical Database Schema Metadata Browser – SchemaSpy
- wordpress 的 schema
- Oracle documentation library
- Protected: 規格表 schema
- mysql index 的建立/使用 , Multiple-Column Indexes
