MySQL Forums
Forum List  »  Performance

Re: MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock
Posted by: Olivier Dasini
Date: July 18, 2019 04:09AM

oh my bad! you're right.
Actually I was wondering why 1st explain was exactly the same than the second one... because it's the same index and I missed that (shame on me).

So the logic is the same, you don't need the new index (the one you created).
What you can do it's to force FK_CID_OPERATION_ENV_CASE and see if it's better

Options: ReplyQuote

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.