Nodetool clearsnapshot does not delete snapshot for dropped column_family

2020-04-30 Thread Sergio Bilello
Hi guys! I am running cassandra 3.11.4. I dropped a column_family but I am able to see the disk space occupied by that column_family in the disk. I understood that since I have the auto_snapshot flag = true this behavior is expected. However, I would like to avoid to write a dummy script that

IN OPERATOR VS BATCH QUERY

2020-02-20 Thread Sergio Bilello
Hi guys! Let's say we have a KEY-VALUE schema The goal is to delete the KEYS in batches without burning the cluster and be efficient as soon as possible I would like to know if it is better to run the query with DELETE FROM KEY_VALUE_COLUMN_FAMILY WHERE KEY IN ('A','B','C'); At most 10 KEYS

nodetool load does not match du

2020-02-03 Thread Sergio Bilello
Hello! I was trying to understand the below differences: Cassandra 3.11.4 i3xlarge aws nodes $ du -sh /mnt 123G/mnt $ nodetool info ID : 3647fcca-688a-4851-ab15-df36819910f4 Gossip active : true Thrift active : true Native Transport active: true Load

JMX Metrics [Cassandra-Stress-Tool VS JMX]

2019-11-22 Thread Sergio Bilello
Hi everyone! Which function has to be used with each JMX Metric Type? https://cassandra.apache.org/doc/latest/operating/metrics.html https://www.datadoghq.com/blog/how-to-collect-cassandra-metrics/ For example: to compute the read latency I did a ratio between ReadTotalLatency_Count JMX

Re: Find large partition https://github.com/tolbertam/sstable-tools

2019-11-22 Thread Sergio Bilello
riting large partitions > during compaction. > > > > > > On Thu, Nov 21, 2019 at 6:33 PM Sergio Bilello > wrote: > > > Hi guys! > > Just for curiosity do you know anything beside > > https://github.com/tolbertam/sstable-

Find large partition https://github.com/tolbertam/sstable-tools

2019-11-21 Thread Sergio Bilello
Hi guys! Just for curiosity do you know anything beside https://github.com/tolbertam/sstable-tools to find a large partition? Best, Sergio - To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org For additional commands,

Re: Cassandra 3.11.4 Node the load starts to increase after few minutes to 40 on 4 CPU machine

2019-10-30 Thread Sergio Bilello
02:46:01, Sergio Bilello wrote: > Hello guys! > > I performed a thread dump > https://fastthread.io/my-thread-report.jsp?p=c2hhcmVkLzIwMTkvMTAvMTcvLS1kdW1wLnR4dC0tMC0zMC00MA==; > while try to join the node with > > -Dcassandra.join_ring=false > > OR &g

Re: Keyspace Clone in Existing Cluster

2019-10-29 Thread Sergio Bilello
Rolling bounce = Rolling repair per node? Would not it be easy to be scheduled with Cassandra Reaper? On 2019/10/29 15:35:42, Paul Carlucci wrote: > Copy the schema from your source keyspace to your new target keyspace, > nodetool snapshot on your source keyspace, copy the SSTable files over,

Re: Decommissioned Node UNREACHABLE in describecluster but LEFT in gossipinfo

2019-10-26 Thread Sergio Bilello
It disappeared from describecluster after 1 day. It is only in gossipinfo now and this looks to be ok :) On 2019/10/25 04:01:03, Sergio wrote: > Hi guys, > > Cassandra 3.11.4 > > nodetool gossipinfo > /10.1.20.49 > generation:1571694191 > heartbeat:279800 >

Cassandra Rack - Datacenter Load Balancing relations

2019-10-23 Thread Sergio Bilello
Hello guys! I was reading about https://cassandra.apache.org/doc/latest/architecture/dynamo.html#networktopologystrategy I would like to understand a concept related to the node load balancing. I know that Jon recommends Vnodes = 4 but right now I found a cluster with vnodes = 256 replication

GC Tuning https://thelastpickle.com/blog/2018/04/11/gc-tuning.html

2019-10-18 Thread Sergio Bilello
Hello! Is it still better to use ParNew + CMS Is it still better than G1GC these days? Any recommendation for i3.xlarge nodes read-heavy workload? Thanks, Sergio - To unsubscribe, e-mail:

Cassandra Recommended System Settings

2019-10-18 Thread Sergio Bilello
Hello everyone! Do you have any setting that you would change or tweak from the below list? sudo cat /proc/4379/limits Limit Soft Limit Hard Limit Units Max cpu time unlimitedunlimitedseconds Max file size

Cassandra 3.11.4 Node the load starts to increase after few minutes to 40 on 4 CPU machine

2019-10-16 Thread Sergio Bilello
Hello guys! I performed a thread dump https://fastthread.io/my-thread-report.jsp?p=c2hhcmVkLzIwMTkvMTAvMTcvLS1kdW1wLnR4dC0tMC0zMC00MA==; while try to join the node with -Dcassandra.join_ring=false OR -Dcassandra.join.ring=false OR -Djoin.ring=false because the node spiked in load and

Cassadra node join problem

2019-10-14 Thread Sergio Bilello
Problem: The cassandra node does not work even after restart throwing this exception: WARN [Thread-83069] 2019-10-11 16:13:23,713 CustomTThreadPoolServer.java:125 - Transport error occurred during acceptance of message. org.apache.thrift.transport.TTransportException: java.net.SocketException: