Rick's RoTs (Rules of Thumb)
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. Topics covered: 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.
Rick James worked for Yahoo for 14 years. A main task was rooting out slowness on hundreds of different MySQL systems and proposing ways to speed them up -- tuning, schema changes, adding indexes, reformulating queries, even rearchitecting. Rick has addressed over 15K questions on various forums. Rick now does MySQL consulting, mostly in scaling and performance.