Hi Lorraine,thank you for comming back to me. To your questions:- InnoDB storage engine.- Standalone DB (no replication)
- no partitioning- yes, currently I have to stcik with 5.7.- delete from blablab order by pimarykeycolum limit x;
In a second attempt I just throttled down the delete process.The thing I don’t understand: Why do I get completetly stuck without any chance to proceed. Only a complete shutdown seems to solve the problem. And the shutdown is fast because almost all dirty buffers are written. What is locking up the table?
So, why can’t I proceed as soon as the logs are flushed and cleaned up?