Explain Show Set Output


I have an aerospike cluster having 6 nodes. Now when I connect to one node using aql and use SHOW SETS to show existing sets, the results are printed in 6 seperate tables each table having different count for number of records for all sets.

Is this expected and how to interpret this result and why are there six different results.


AQL show sets shows 1 table each for 1 node. So, if it’s a 6 node cluster, it will show the sets for each node and the records that exist on each node.

You can get another view of the same data using asadm > info set which will also provide you with the total number of records in each set.