 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
• |
Select the right column types
|
|
|
|
– |
No bigger than you need
|
|
|
|
– |
MySQL provides a ton of column types
|
|
|
|
– |
Use NOT NULL where it makes sense
|
|
|
|
– |
Use fixed column sizes if you can
|
|
|
|
• |
MyISAM tables with fixed rows are faster
|
|
|
|
• |
Concurrency improvements
|
|
|
|
– |
Store compressed data when possible
|
|
|
|
See:
http://www.mysql.com/doc/S/t/Storage_requirements.html
|