aerospike server throughput is very less. 45000 rows returns in minimum 7 seconds through aql. What may be the possible cause for such a low throughput? Near about 27 Million records are resided on EBS. Please help .
EBS throughput is limited to EBS IOPS. While during reads, we have seen reads TPS being same as EBS IOPS. Hence, the low throughput when using EBS only as a storage medium.
We suggest either using a bcache based setup or using data-in-memory true.
EBS is not a good for Aerospike using the SSD storage option. The throughput is directly tied to the storage and instance stores are much faster.
We can get 150k transactions per second on a cluster of 3 c3.8xlarge instances using local instance storage.