If you're serious about performance, the guys over at Percona are the definitive authority on such matters. They charge a premium rate, but they get the job done.
If you are insistent on doing it yourself, firstly you want to look at your slow query log. Enable slow query logging, check out...