Because it’s a lot cheaper to optimize queries than to upgrade hardware, the logical first step in MySQL optimization is query log analysis.