5.5G of ram isn't very much for a jvm based database. Having fewer instances with more ram will likely give you better performance.
Also, this is probably a better question for the user list than the Dev list -- Jeff Jirsa > On Mar 11, 2017, at 1:20 PM, S G <sg.online.em...@gmail.com> wrote: > > Hi, > > I have a 9 node cassandra cluster, each node has: > RAM: 5.5gb > Disk: 64gb > C* version: 3.3 > Java: 1.8.0_51 > > The cluster stores about 2 million rows and partition keys for all these > rows are unique. > > I am stress-reading it from a 12-node client cluster. > Each read-client has 50 threads, so total 600 read-threads from 12 machines. > Each read query is get-by-primary-key where keys are read randomly from a > file having all primary-keys. > > > I am able to get only 15,000 reads/second from the entire system. > Is this the best read performance I can expect? > Are there any benchmarks I can compare against? > > > I tried setting bloom_filter_fp_chance from 0.01 to 0.0001 and caching to > {'keys': 'ALL', 'rows_per_partition': 'ALL'} but it had no effect. > > Thx, > SG