After deletion of a row I still find info about them through aql > show bins


#1

We have a a namespace “ssd-store” where we have a set “user_events”.

We have removed all rows from “user_events” set, but when we run “aql > show bins” we still see “buy”, “bin10k”, “binlist”.

By the way all bins consist LDT Large Ordered List

Please explain. Kindly find attached the pic.


#2

This is a common problem, the bin name table grows monotonically and is somewhat difficult to remove unused bin names from it.

Since you currently only have 11 bin names this isn’t a problem, but the server is limited to 32K unique bin names, so it could become a problem at some point.

Instructions for purging bin names can be found here: https://discuss.aerospike.com/t/bin-names-deletion/731