Here's an old-but-still-relevant (re)post from Major Hayen on improving MySQL performance. It's a neat, concise reference guide for MySQL emergencies!

Original post