Anemometer icon indicating copy to clipboard operation
Anemometer copied to clipboard

Published 20 hours ago • verified publisher icon box

Run EXPLAIN for INSERT/UPDATE/DELETE on MySQL 5.6

Open gtowey opened this issue 12 years ago • 2 comments

newer versions of mysql support explain on more than just select.

gtowey avatar Apr 21 '12 02:04 gtowey

You can also consider this fixed by #50, as we now rewrite those into select statements and can explain them

kormoc avatar Oct 03 '12 18:10 kormoc

I think it's still important to include support to detect if the target server is 5.6 and run EXPLAIN UPDATE ... ; instead of rewriting it. This is because of known issues where the query plan for and update/insert/delete query can be optimized differently than the corresponding select with the same WHERE clause.

gtowey avatar Oct 03 '12 19:10 gtowey