Explain Show Set Output

Tools AQL
1

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.

2

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.