Mysql explain update

When there are multiple loops, this figure shows the average time per loop. The query execution information is displayed using the TREE output format, in which nodes represent iterators.

Beginning with MySQL 8. The tables used in the example output were created by the statements shown here:. Values shown for actual time in the output of this statement are expressed in milliseconds. Data Definition Statements. Atomic Data Definition Statement Support. LIKE Statement. Silent Column Specification Changes.

Secondary Indexes and Generated Columns. Data Manipulation Statements. Parenthesized Query Expressions. The Subquery as Scalar Operand. Comparisons Using Subqueries. Restrictions on Subqueries. Transactional and Locking Statements. Statements That Cause an Implicit Commit. Restrictions on XA Transactions. Active Oldest Votes. Raymond Tau Raymond Tau 3, 23 23 silver badges 28 28 bronze badges. I don't have the option of moving to 5.

What's the recommended way to figure out why a MySQL 5. Explain plan works in 5. If you really want to see why update is slow, assuming it is the where clause in the update is slow, try to do an explain plan on a select statement with the where clause should give you some hint.

Also, you may clone the db and upgrade to 5. You may refer to this question's comment as well. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. Rewriting Subqueries as Joins. Restrictions on Subqueries. Transactional and Locking Statements. Statements That Cause an Implicit Commit. Restrictions on XA Transactions. Replication Statements. Variables in Stored Programs.

Local Variable Scope and Resolution. Flow Control Statements. Restrictions on Server-Side Cursors. Restrictions on Condition Handling.