Post by arayappan » Thu Oct 24, 2013 9:37 pm Hi All, I want to delete all records in a set(table). is there any command in aerospike to delete all records in set like “DELETE FROM test.test-set”? Thanks & Regards, Rayappan A

You will find information on how to delete records in a set here .

I followed this exact set of instructions but as soon as there a service restart the data and the set gets restored. How to avoid this?

The following thread should provide you with the details for why this is happening: [image] Expired/Deleted data reappears after server is restarted Deletion Aerospike 3.3.19 In-Memory + Disk Persistence, single node. With conf: default-ttl 0 # Never expire/evict fsync-m…

Aerospike 3.10.0 introduces durable deletes for Aerospike Enterprise. Learn more about how they work here: www.aerospike.com/docs/guide/durable_deletes.html .

So, to clarify, community edition does not actually delete? Only marks stuff deleted without reclaiming disk?

Below applies to both CE and EE. If data storage is in RAM, both data and Primary Index are deleted, right away on delete. If data sotrage is on SSD, Primary Index (PI) is always on RAM, delete just deletes the Primary Index in RAM by default. The data on SSD is eventually overwritten by a new recor…

Thanks for this explanation, Piyush. Please could you (or someone) further clarify the following: what does “eventually” mean in your first paragraph? How does Aerospike decide when records should be overwritten on disk? Is there any defragmentation process that runs in the background, cassandra-…

eventually means when there is new data to be written and this space can be reclaimed. Aerospike writes in a log structured fashion in block size you decide, with as many records that will fit in a block. typical block size is 128KB for SSD, 1 MB max. So the max record size on SSD is 1MB (data + som…

OK, :slight_smile: . I wanted to keep it simple without introducing defrag-sleep! defrag-sleep [dynamic] Context: namespace Subcontext: storage-engine device Default: 1000 Introduced: 3.3.17 Number of microseconds to sleep after each wblock defragged.

Hello Mr. Gupta, Using Community for development, is there some way to force Aerospike to write changes out to SSD to simulate durable deletes? Something like a commit or flush operation? It is difficult to write or test logic that expects deleted to stay deleted when the data isn’t deleted in a p…

How to delete all records in set / Deleted set or records get restored on 'restart'

Feature Discussion Deletion

meher July 29, 2015, 8:11pm 4

The following thread should provide you with the details for why this is happening:

Topic		Replies	Views
What is the right way to delete sets completely? Deletion deletion , durable-deletion	16	7783	July 24, 2017
Expired/Deleted data reappears after server is restarted Deletion deletion , durable-deletion	55	22372	June 8, 2017
Found existence of deleted and expired records in Aerospike! Deletion deletion , durable-deletion	7	5599	December 29, 2016
How to ensure that deleted data from set does not come back? Deletion deletion , durable-deletion	3	4275	October 11, 2016
Delete record in aerospike Deletion deletion , durable-deletion	4	6109	October 11, 2016

How to delete all records in set / Deleted set or records get restored on 'restart'

Related topics