For example, if select commands dominate, you should optimize the server for faster reads, create indexes, and especially increase its query cache.

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