Re: Change the compression algorithm on a production table at runtime

2022-09-19 Thread C. Scott Andreas
Thanks for reaching out. Changing the compressor for a table is both safe and common. Future flushes / compactions will use the new codec as SSTables are written, and SSTables currently present on disk will remain readable with the previous codec. You may also want to take a look at the Zstanda

Change the compression algorithm on a production table at runtime

2022-09-19 Thread Eunsu Kim
Hi all According to https://docs.datastax.com/en/cql-oss/3.3/cql/cql_reference/cqlAlterTable.html , it can be very problematic to modify the Compaction strategy on a table running in production. Similarly, is it ri

Re: Cassandra GC tuning

2022-09-19 Thread Jeff Jirsa
https://issues.apache.org/jira/browse/CASSANDRA-13019 is in 4.0, you may find that tuning those thresholds On Mon, Sep 19, 2022 at 9:50 AM Jeff Jirsa wrote: > Snapshots are probably actually caused by a spike in disk IO and disk > latency, not GC (you'll see longer STW pauses as you get to a saf

Re: Cassandra GC tuning

2022-09-19 Thread Jeff Jirsa
Snapshots are probably actually caused by a spike in disk IO and disk latency, not GC (you'll see longer STW pauses as you get to a safepoint if that disk is hanging). This is especially problematic on SATA SSDs, or nVME SSDs with poor IO scheduler tuning. There's a patch somewhere to throttle har

Re: Cassandra GC tuning

2022-09-19 Thread Patrick McFadin
GC tuning may seem like it's the best move, but more than likely, that is just the smoke from the real fire. Can you go more into your configuration? Memory. CPU. DIsk. Many times, GC is what shows up when running out of disk bandwidth or some other process eating up resources. Patrick On Mon, Se

Cassandra GC tuning

2022-09-19 Thread Michail Kotsiouros via user
Hello community, I observe some GC pauses while trying to create snapshots of a keyspace. The GC pauses as such are not long, even though they are reported in logs. The problem is the CPU utilization which affects other applications deployed in my server. Do you have any articles or recommendatio

Re: Codec not found for list

2022-09-19 Thread Sébastien Rebecchi
Please ignore that message, I found my mistake, it was clear in the error message, I forgot to collect the Java stream as List... :) Sorry for the disturbance Le lun. 19 sept. 2022 à 11:08, Sébastien Rebecchi < sebastien.rebec...@gmail.com> a écrit : > Hello, > > I have a table where I store dat

Codec not found for list

2022-09-19 Thread Sébastien Rebecchi
Hello, I have a table where I store data in a column of type list I get that error when inserting data com.datastax.oss.driver.api.core.type.codec.CodecNotFoundException: Codec not found for requested operation: [List(BLOB, not frozen) <-> java.util.stream.ReferencePipeline$3] Do you know how I