Database Design
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
Copyright 2003, Jeremy Zawodny