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

In this tutorial, we will access MySQL from the local machine through the popular MySQL Workbench. First, let us make sure that the MySQL data service is provisioned for us.