MySQL Forums
Forum List  »  InnoDB

Re: DELETE from table does not delete rows
Posted by: Alexandru Badulescu
Date: April 24, 2019 08:05AM

Thank you for the answer James!
Managed to figure out what was happening: this was part of a big cron job, calculating some reports, making the inserts, moving older data to other tables and deleting these old records. The logs were indicating the same result as the slow-query log.
What was actually happening is that the dev had set autocommit=0 somewhere upper in the script. So this was running and remaining not committed until the connection dropped - time when it was actually rolling it back...

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: DELETE from table does not delete rows
200
April 24, 2019 08:05AM


Sorry, only registered users may post in this forum.

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.