Case StudiesIn addition to tools, I wrote a number of case studies that are now too out of date to reprint: case1/ Indexing Basic MySQL Queriescase2/ Table Design and MySQL Index Detailscase3/ MySQL ORDER BY With LIMIT and ANALYZEcase4/ How To Index For Joins With MySQLcase5/ How To Look At MySQL Joins and More ORDER BY With LIMITInstead, read my book: Efficient MySQL Performance. It’s up to date,
