What strategies did you use to optimize MySQL queries, and how did you measure the performance improvements?

Technical