Re: load distribution that I can't explain

2017-09-13 Thread kaveh minooie
I am using RoundRobin cluster = Cluster.builder()...( socket stuff, pool option stuff ... ) .withLoadBalancingPolicy( new RoundRobinPolicy() ) .addContactPoints( hosts ) .build(); On 09/13/2017 03:02 AM, kurt greaves wrote: Are you us

Re: load distribution that I can't explain

2017-09-13 Thread kurt greaves
Are you using a load balancing policy? That sounds like you are only using node2 as a coordinator.​

Re: load distribution that I can't explain

2017-09-12 Thread kaveh minooie
Hi kurt, thanks for responding. I understand that that query is very resource consuming. My question was why I only see its effect on the same node? considering that I have a replication factor of 2, I was hoping to see this load evenly distributed among those 2 nodes. That query runs hundreds

Re: load distribution that I can't explain

2017-09-11 Thread kurt greaves
Your first query will effectively have to perform table scans to satisfy what you are asking. If a query requires ALLOW FILTERING to be specified, it means that Cassandra can't really optimise that query in any way and it's going to have to query a lot of data (all of it...) to satisfy the result.

load distribution that I can't explain

2017-09-11 Thread kaveh minooie
Hi every one So I have a 2 node( node1, node2 ) cassandra 3.11 cluster on which I have a keyspace with a replication factor of 2. this keyspace has only this table: CREATE KEYSPACE myks WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '2'} AND durable_writes = true; CR