Deleting Row Store Table Data When at the Memory Limit
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
If you are running near the memory limit, you may get ERROR 1712 indicating that you have exceeded the maximum_
setting.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