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:28AM

you're welcome!

ANALYZE TABLE can also help in order to recompute table statistics.

If needed you can reach me by email:
<first name>.<last name>@oracle.com

Cheers,
Olivier

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.