How to Optimize MySQL: Indexes, Slow Queries, Configuration

https://www.sitepoint.com/optimize-mysql-indexes-slow-queries-configuration/
Another article on MySQL optimization from the percona folks.