MySQL Forums
Forum List  »  Performance

MySQL 8.0: EXPLAIN ANALYZE
Posted by: Edwin Desouza
Date: October 17, 2019 07:16AM

MySQL 8.0: EXPLAIN ANALYZE
https://mysqlserverteam.com/mysql-explain-analyze/

MySQL EXPLAIN ANALYZE is an indispensable tool for understanding query execution because it breaks down the query execution stage of response time by measuring each step of the query execution plan. The information is illuminating, but the output is not intuitive: it requires practice and some understanding of how MySQL executes queries beyond the table join order shown by traditional EXPLAIN output. This blog post closely examines three different examples of EXPLAIN ANALYZE output.
https://hackmysql.com/post/book-2/



Edited 1 time(s). Last edit at 02/27/2022 10:36PM by Edwin Desouza.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL 8.0: EXPLAIN ANALYZE
1193
October 17, 2019 07:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.