Some time ago I came across this post at Nettuts+ on the Top 20+ MySQL Best Practices. The ideas are simple, effective, and clearly explained. Well worth checking out if you use MySQL on a regular basis.
Top 20+ MySQL Best Practices | Nettuts+
Translating Geek Into English