Re: High IO and poor read performance on 3.11.2 cassandra cluster

2018-09-04 Thread Alexander Dejanovski
Don't forget to run "nodetool upgradesstables -a" after you ran the ALTER statement so that all SSTables get re-written with the new compression settings. Since you have a lot of tables in your cluster, be aware that lowering the chunk length will grow the offheap memory usage of Cassandra. You ca

Re: High IO and poor read performance on 3.11.2 cassandra cluster

2018-09-04 Thread CPC
Could you decrease chunk_length_in_kb to 16 or 8 and repeat the test. On Wed, Sep 5, 2018, 5:51 AM wxn...@zjqunshuo.com wrote: > How large is your row? You may meet reading wide row problem. > > -Simon > > *From:* Laxmikant Upadhyay > *Date:* 2018-09-05 01:01 > *To:* user > *Subject:* High IO

Re: High IO and poor read performance on 3.11.2 cassandra cluster

2018-09-04 Thread wxn...@zjqunshuo.com
How large is your row? You may meet reading wide row problem. -Simon From: Laxmikant Upadhyay Date: 2018-09-05 01:01 To: user Subject: High IO and poor read performance on 3.11.2 cassandra cluster We have 3 node cassandra cluster (3.11.2) in single dc. We have written 450 million records on the

Re: Datastax encryption with kms

2018-09-04 Thread Rahul Singh
This is a Cassandra user group — consider joining the Datastax Academy Slack group and asking there. Rahul Singh Chief Executive Officer m 202.905.2818 Anant Corporation 1010 Wisconsin Ave NW, Suite 250 Washington, D.C. 20007 We build and manage digital business technology platforms. On Sep 4,

Datastax encryption with kms

2018-09-04 Thread Rahul Reddy
Hello, Has anyone done the dse cassandra stable/ commitlog tde encryption saving the keys in kms or vault instead of kmip. If it's possible please do let me know

High IO and poor read performance on 3.11.2 cassandra cluster

2018-09-04 Thread Laxmikant Upadhyay
We have 3 node cassandra cluster (3.11.2) in single dc. We have written 450 million records on the table with LCS. The write latency is fine. After write we perform read and update operations. When we run read+update operations on newly inserted 1 million records (on top of 450 m records) then t

Amy Tobey's tuning guide for Cassandra 3 ?

2018-09-04 Thread Jeronimo de A. Barros
Hi guys, Does anyone know about a CAS3 tuning guide like the excellent Amy's Cassandra 2.1 tuning guide ? It would be much appreciated. Regards, Jero

RE: [EXTERNAL] Re: adding multiple node to a cluster, cleanup and num_tokens

2018-09-04 Thread Durity, Sean R
I would only run the clean-up (on all nodes) after all new nodes are added. I would also look at increasing RF to 3 (and running repair) once there are plenty of nodes. (This is assuming that availability matters and that your queries use QUORUM or LOCAL_QUORUM for consistency level. Longer ter

counter mutation not persisted

2018-09-04 Thread onmstester onmstester
My application updates a counter table with rate 50K per seconds in a cluster with 10 nodes. The problem is that counter value is less than what it should be in 20% of cases. dropped counter mutation in jmx is always equal to 0. I'm using batch statements to update counters and executeAsync.  I