Re: Slow DELETE-Statement since update on 5.7
In MySQL 5.7, derived tables (subqueries in FROM clause) is automatically merged into the outer query. It is not apparent to me why that should be a problem in your case, but you can turn off this feature by setting
optimizer_switch='derived_merge=off'
If that works, it would be interesting to see the EXPLAIN output both with and without this setting. That could tell us more about what is going on.
Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway
Subject
Views
Written By
Posted
1878
March 19, 2018 07:51AM
788
March 19, 2018 11:40AM
Re: Slow DELETE-Statement since update on 5.7
888
March 19, 2018 01:15PM
816
March 20, 2018 02:09AM
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.