MySQL Documents by Rick James
Tips, Debugging, HowTos, Optimizations, etc...
Rick's RoTs (Rules of Thumb -- lots of tips)
Character Set and Collation problem solver
Memory Allocation (caching, etc)
Big DELETEs - how to optimize
Converting from MyISAM to InnoDB -- includes differences between them
Find the nearest 10 pizza parlors (efficient searching on Latitude + Longitude)
Alter of a Huge table
Compound INDEXes plus other insights into the mysteries of INDEXing
Entity-Attribute-Value -- a common, poorly performing, design patter; plus an alternative
Latest 10 news articles -- how to optimize the schema and code for such
Pagination, not with OFFSET, LIMIT
Techniques on efficiently finding a random row (On beyond ORDER BY RAND())
Partition Maintenance (DROP+REORG) for time series
GUID/UUID Performance
IP Range Table Performance
Best of MySQL Forum
