Explain and query analysis?

Question

MySQL

EXPLAIN SELECT works well, but I understand that this query is only performed with select and does not work with other types of queries. How, for example, to analyze a query like:
UPDATE `test` SET `num`=`num`+`num2` WHERE `id`=1
And somewhere else you can find out the time spent by the database on rebuilding the index (for example, if I had an index on the `num` field in the example above).

Answer 1

Have a look - stackoverflow.com/questions/11351804/mysql-explain...