MySQL Performance Tuning

Hi. I am curious if anyone knows a good course or manual that could grow my expertise in administering and tuning MySQL databases. I have a decent amount of experience in SQL - but not in the administration and performance tuning side.

There are a lot of things that can be done for MySQL performance tuning. You can optimize the MySQL queries to be executed faster. This can be done by

Avoid using functions in predicates
Avoid using wildcard (%) in the beginning of a predicate
Avoid unnecessary columns in SELECT clause
Use inner join, instead of outer join if possible
Use DISTINCT and UNION only if it is necessary