You can often get significant performance improvements from relatively simple changes, such as indexing tables correctly or switching from MyISAM to the InnoDB storage engine. If you’re facing performance limitations now, one of the first things you should do is enable and analyze the slow query log. See Chapter 3 for more on this topic.
Note: Buying time before having to implement scaling strategy.
Share this highlighthttp://www.safaribooksonline.com/a/high-performance-mysql/16584293/