Rick's RoTs (Rules of Thumb)
A fast-paced list of one-liners -- MySQL Tips, RoTs, Hints, and Best Practice.
These are distilled from watching MySQL users -- from newbies to experts -- successfully (or unsuccessfully) tune, index, optimize, and query.
Some you already know; some you have been wondering about; and some will surprise you.
SELECTs-do's & don'ts; INDEXing; ENGINE diffs; Optimizations (or not); PARTITIONing; Memory Usage; Character sets; Datatypes - internal and artificial; Hardware; and Data Warehousing.
Your takeaways include a dozen tidbits you did not know; some of them directly applicable to development, tuning, DBAing, optimizing, etc.