- Lab
-
Libraries: If you want this lab, consider one of these libraries.
- Data
Tune MySQL Query Performance with EXPLAIN and Indexes
In this lab, you’ll find a slow MySQL query, read its execution plan with `EXPLAIN`, and improve its performance with indexes. By the end of the lab, you’ll have a report query that reads a fraction of the rows it started with.
Lab Info
Table of Contents
-
Challenge
Identify resource-intensive queries
Run the merchandising team's payment report, then use the tools MySQL gives you to see what that one query costs the server.
-
Challenge
Analyze the query execution plan
Read the plan MySQL chose for that query, in both the form Workbench draws and the table EXPLAIN prints, and write down a baseline to improve on.
-
Challenge
Optimize query performance using indexes
Add indexes one at a time, checking with EXPLAIN after each one, until the report query is answered from an index instead of the table.
-
Challenge
The Final Objective
Welcome to the final objective! This is your last chance to experiment in the environment. Clicking End Lab will end this little world that flittered into existence just for you
Real skill practice before real-world application
Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.
Learn by doing
Engage hands-on with the tools and technologies you’re learning. You pick the skill, we provide the credentials and environment.
Follow your guide
All labs have detailed instructions and objectives, guiding you through the learning process and ensuring you understand every step.
Turn time into mastery
On average, you retain 75% more of your learning if you take time to practice. Hands-on labs set you up for success to make those skills stick.