 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
• |
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
|