Re: MySQL hangs due to large delete
To investigate further, please provide
SHOW ENGINE INNODB STATUS; -- when it is "hung".
SHOW CREATE TABLE -- for any relevant table(s).
The DELETE statement.
How many rows are being deleted at a time?
Are multiple DELETEs going on in parallel?
There will be row locks taken out, and the log will be busy. However, 10-20s may be unreasonable. We may be able to advise on a workaround.
Subject
Views
Written By
Posted
1567
June 13, 2014 01:24AM
846
June 13, 2014 01:25AM
Re: MySQL hangs due to large delete
784
June 26, 2014 05:08PM
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.