Re: Query on Performance Dip

knows more about it. Regards On Wed, Mar 27, 2024 at 10:43 PM Subroto Barua via user wrote: we are seeing similar perf issues with counter writes - to reproduce: cassandra-stress counter_write n=10 no-warmup cl=LOCAL_QUORUM -rate threads=50 -mode native cql3 user= passw

Re: Query on Performance Dip

we are seeing similar perf issues with counter writes - to reproduce: cassandra-stress counter_write n=10 no-warmup cl=LOCAL_QUORUM -rate threads=50 -mode native cql3 user= password= -name op rate: 39,260 ops (4.1) and 63,689 ops (4.0) latency 99th percentile: 7.7ms (4.1) and 1.8ms

Question on large partition key

I have a table --- create Table mytable ( Id text, cdate timestamp, Tk text, Primary key (id, cdate) ) with clustering order by (cdate desc); One of the partition key has 2,099,414 rows; using the following formula: row_size = sum_of_all_columns_ size_within_row + partition_key_size row_size

Re: unable to gossip with peers exception when internode encryption is set to any setting other than 'none'

b/c the gossiper is trying to start but doesn't. On Mon, Aug 26, 2019 at 6:51 PM Subroto Barua wrote: Michael, Are you able to connect to any c* node via OpenSSL? Openssl s_client -connect :9042 Cqlsh —ssl  Subroto  On Aug 26, 2019, at 2:47 PM, Marc Selwan wrote: which exact version of Open

Re: unable to gossip with peers exception when internode encryption is set to any setting other than 'none'

Michael, Are you able to connect to any c* node via OpenSSL? Openssl s_client -connect :9042 Cqlsh —ssl Subroto > On Aug 26, 2019, at 2:47 PM, Marc Selwan wrote: > > which exact version of OpenJDK are you using? Is it possible you don't have > JCE on those nodes? (I believe more recent

Re: Help with sudden spike in read requests

; happening? What changed since it started happening? > > Kenneth Brotman > > From: Subroto Barua [mailto:sbarua...@yahoo.com.INVALID] > Sent: Friday, February 01, 2019 10:13 AM > To: user@cassandra.apache.org > Subject: Re: Help with sudden spike in read requests > >

Re: Help with sudden spike in read requests

> On Feb 1, 2019, at 8:55 AM, Kenneth Brotman > wrote: > > If you had a query that went across the partitions and especially if you had > vNodes set high, that would do it. > > Kenneth Brotman > > From: Subroto Barua [mailto:sbarua...@yahoo.com.INVALID] > Sent: Fri

Help with sudden spike in read requests

In our production cluster, we observed sudden spike (over 160 MB/s) in read requests on *all* Cassandra nodes for a very short period (less than a min); this event happens few times a day. I am not able to get to the bottom of this issue, nothing interesting in system.log or from app level;

Re: snapshot strategy?

Lou, when taking snapshot, set tag like "uuidgen --time" and use this tag to clear out old snapshot. On Friday, November 2, 2018, 9:28:03 AM PDT, Oleksandr Shulgin wrote: On Fri, Nov 2, 2018 at 5:15 PM Lou DeGenaro wrote: I'm looking to hear how others are coping with snapshots.

Re: G1GC CPU Spike

Chris, What is the criteria for picking up the value for G1ReservePercent? Subroto > On Jun 13, 2018, at 6:52 AM, Chris Lohfink wrote: > > G1ReservePercent - To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org For

Re: Executing a check before replication / manual replication

turn on audit on tables in question, scan the audit logs (using tools like Splunk) and send alerts based on the activity... On Wednesday, November 15, 2017, 12:33:30 PM PST, Abdelkrim Fitouri wrote: Hi, I know that cassandra handel properly data replication

Re: running C* on AWS EFS storage ...

From our experience, the ebs remount process was quite painful Subroto > On Nov 12, 2017, at 4:18 PM, kurt greaves wrote: > > What's wrong with just detaching the EBS volume and then attaching it to the > new node?​ Assuming you have a separate mount for your C* data

Re: running C* on AWS EFS storage ...

Any reason you think EFS would be better than EBS? -- Jeff Jirsa On Nov 12, 2017, at 1:38 PM, Subroto Barua <sbarua...@yahoo.com.INVALID> wrote: Hi, We have a unique requirement to replace C* (3.0.x on RHEL) nodeswith a new AWS AMI image periodically. The current process (add node/dec

running C* on AWS EFS storage ...

Hi, We have a unique requirement to replace C* (3.0.x on RHEL) nodeswith a new AWS AMI image periodically. The current process (add node/decommissionetc) is a very manual and time consuming process. We currently use EBS andexploring EFS as an option to speed up the process. Does anybody have

Re: cassandra-stress w/ DC aware

I figured it out ... cassandra-stress user profile=myprofile.yaml cl=local_quorum node= ... On Wednesday, October 18, 2017, 12:07:35 PM PDT, Subroto Barua <sbarua...@yahoo.com.INVALID> wrote: is it possible to run cassandra-stress against a specific DC w/ user yaml

cassandra-stress w/ DC aware

is it possible to run cassandra-stress against a specific DC w/ user yaml file?  there is an option w/o yaml, but I am not sure i can do the same with USER option.. cassandra: 3.0.12 thanks! Subroto

Re: RE: Adding a new node with the double of disk space

Jeff, is it ok to have different values of num_tokens per node in a cluster? won't it create cluster imbalance? or it better to initiate it on a separate DC? Subroto On Friday, August 18, 2017, 5:34:11 AM PDT, Durity, Sean R wrote: #yiv5432100827 #yiv5432100827 --

Re: MUTATION messages were dropped in last 5000 ms for cross node timeout

In a cloud environment, cross_node_timeout = true can cause issues; we had this issue in our environment and it is set to false now. Dropped messages is an another issue Subroto > On Jul 20, 2017, at 8:27 AM, ZAIDI, ASAD A wrote: > > Hello Folks – > > I’m using

Re: write time for nulls is not consistent

Works fine either case on 3.0.12 Subroto > On Jul 18, 2017, at 2:41 PM, kurt greaves wrote: > > can you try select a, writetime(b) from test.t > I heard of an issue recently where cqlsh reports null incorrectly if you > query a column twice, wondering if it extends to

Re: Reversed read write performance.

Nodetool compactionstats Regarding cassandra-stress, make sure that you initiate load outside of database subnet Subroto > On Jul 14, 2017, at 3:02 PM, Roger Warner wrote: > > 30G java heap. The dataset is the usual Cassandra-test size > > How do I tell if

Re: nodetool removenode causing the schema out of sync

set streamthroughput higher than 200 on the source side and lower on the target node just curious, have you tried removenode force? On Thursday, July 13, 2017, 8:35:38 AM PDT, Jai Bheemsen Rao Dhanwada wrote: Thank you Sean, you mean setstreamthroughput to a lower value

Re: Starting Cassandrs after restore of Data - get error

Use "dos2unix" utility when editing/moving from windows to Linux -- could be a formatting issue Subroto > On Jul 7, 2017, at 9:47 AM, Jonathan Baynes > wrote: > > Yes both clusters match I've checked 3 Times and diff'd it as well. Would > file format have any

Re: Repair on system_auth

you can check the status via nodetool netstatsto kill the repair job, restart the instance On Thursday, July 6, 2017, 1:09:42 PM PDT, Mark Furlong wrote: I have started a repair on my system_auth keyspace. The repair has started and the process shows as running with

Re: need help tuning dropped mutation messages

c* version: 3.0.11 cross_node_timeout: truerange_request_timeout_in_ms: 1write_request_timeout_in_ms: 2000counter_write_request_timeout_in_ms: 5000cas_contention_timeout_in_ms: 1000 On Thursday, July 6, 2017, 11:43:44 AM PDT, Subroto Barua <sbarua...@yahoo.com.INVALID> wrote: I am

need help tuning dropped mutation messages

I am seeing these errors: MessagingService.java: 1013 -- MUTATION messages dropped in last 5000 ms: 0 for internal timeout and 4 for cross node timeout write consistency @ LOCAL_QUORUM is failing on a 3-node cluster and 18-node cluster..

Re: RE: Cassandra issue “Unable to gossip with any seeds”

check firewall rules to/from .152 to seed nodes (telnet On Tuesday, July 4, 2017, 6:38:16 AM PDT, Jonathan Baynes wrote: #yiv3228115995 #yiv3228115995 -- _filtered #yiv3228115995 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered

Re: nodetool repair failure

Balaji, Are you repairing a specific keyspace/table? if the failure is tied to a table, try 'verify' and 'scrub' options on .91...see if you get any errors. On Thursday, June 29, 2017, 12:12:14 PM PDT, Balaji Venkatesan wrote: Thanks. I tried with trace option

Re: Question: Behavior of inserting a list multiple times with same timestamp

is scores has less than 2 elements) UPDATE plays SET scores = scores - [ 12, 21 ] WHERE id = '123-afde'; // removes all occurrences of 12 and 21 from scores As with maps, TTLs if used only apply to the newly inserted/updated values. On 6/19/17, 1:12 AM, "Subroto Barua"

Re: Question: Behavior of inserting a list multiple times with same timestamp

This is an expected behavior. We learned this issue/feature at the current site (we use Dse 5.08) Subroto > On Jun 18, 2017, at 10:29 PM, Zhongxiang Zheng wrote: > > Hi all, > > I have a question about a behavior when insert a list with specifying > timestamp. > > It