This stuff is defn in books ... check out the O Reilly book on MySQL. I think they have a few chapters on this topic.