Deleting Row Store Table Data When at the Memory Limit
If you are running near the memory limit, you may get ERROR 1712 indicating that you have exceeded the
delete from tableName; in this situation may also cause an ERROR 1712 for a large table because deleting data takes memory for each row you delete, while the transaction containing the delete operation is running.
DELETE with a
LIMIT clause may be useful for the purpose of batching deletes.
Last modified: April 26, 2021