O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The explain plan

How MySQL executes queries is one of the major factors of database performance. You can verify the MySQL execution plan using the EXPLAIN command. Starting from MySQL 5.7.2, you can use EXPLAIN to examine queries currently executing in other sessions. EXPLAIN FORMAT=JSON gives detailed information.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required