Compaction throughput vs. number of compaction threads?

Hello, most likely obvious and perhaps already answered in the past, but just want to be sure ... E.g. I have set: concurrent_compactors: 4 compaction_throughput_mb_per_sec: 16 I guess this will lead to ~ 4MB/s per Thread if I have 4 compactions running in parallel? So, in case of upscaling

Re: Compaction throughput vs. number of compaction threads?

Hi, The compaction throughput is indeed shared by all compactors. I would not advise to go below 8MB/s per compactor as slowing down compactions put more pressure on the heap. When tuning compaction, the first thing to do is evaluate the maximum throughput your disks can sustain without impacting

Single Host: Fix "Unknown CF" issue

Hi all! We're using cassandra since a couple of month to get familiar with it. We're currently using only 1-node. Yesterday our server had to be restarted and now cassandra does not start anymore. It reports: INFO [main] 2018-06-05 09:50:43,030 ColumnFamilyStore.java:406 - Initializing syst

Re: Single Host: Fix "Unknown CF" issue

Hey Michael, I have a hunch. If the system doesn’t recognise the column family which is stopping the node from starting perhaps try copying the column family directory to a backup then deleting it. Then restart Cassandra. If it starts I’ll assume the schema didn’t have the column family: * Cr

How to identify which table causing Maximum Memory usage limit

Hi, We see this message often, cluster has multiple keyspaces and column families;  How do I know which CF is causing this? Or it could be something else?Do we need to worry about this message? INFO  [CounterMutationStage-1] 2018-06-05 13:36:35,983 NoSpamLogger.java:91 - Maximum memory usage rea

Re: Single Host: Fix "Unknown CF" issue

Hello Evelyn, if we do what you say cassandra creates a new, empty column family directory on restart and the stops with the same exception. One point i forgot to mention is that we've still got data in the commit log. (99.9% for other keyspaces). Are there any tools which we can use to exami

apache-cassandra 2.2.8 rpm

Hi everybody, I am not able to find an RPM package for apache-cassandra 2.2.8 Is there anyone who can share a link I really couldn't find it. Thank you Ev - To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org For add

Re: apache-cassandra 2.2.8 rpm

Hi, I believe this rpm was built by Datastax right ? https://rpm.datastax.com/community/noarch/ is what you seem to be looking for Otherwise newest rpm are here : https://www.apache.org/dist/cassandra/redhat/22x/ On 5 June 2018 at 16:21, ukevg...@gmail.com wrote: > Hi everybody, > > I am not ab

Re: Log application Queries

I implemented an audit query handler that archives the queries in ES here: https://github.com/ltagliamonte/cassandra-audit PRs are welcome! On Mon, May 28, 2018 at 1:55 AM, Horia Mocioi wrote: > Hello, > > Another way to do it would be to create your own QueryHandler: > >- create a class tha

Re: apache-cassandra 2.2.8 rpm

On 2018/06/05 14:28:20, Nicolas Guyomar wrote: > Hi, > > I believe this rpm was built by Datastax right ? > https://rpm.datastax.com/community/noarch/ is what you seem to be looking > for > Otherwise newest rpm are here : > https://www.apache.org/dist/cassandra/redhat/22x/ > > On 5 June 2018

Re: apache-cassandra 2.2.8 rpm

I would recommend migrate to a higher version of Apache Cassandra. Since Datastax always push some extra patches in their distribution. So I would go 2.2.8 -> 2.2.9+ at least. Since it's a minor upgrade I would read this https://github.com/apache/cassandra/blob/cassandra-2.2/NEWS.txt and upgrade to

Re: apache-cassandra 2.2.8 rpm

On 2018/06/05 14:56:24, Carlos Rolo wrote: > I would recommend migrate to a higher version of Apache Cassandra. Since > Datastax always push some extra patches in their distribution. So I would > go 2.2.8 -> 2.2.9+ at least. Since it's a minor upgrade I would read this > https://github.com/apa

Repair slow, "Percent repaired" never updated

Hi, we're on cassandra 3.11.2, and we're having some issues with repairs. They take ages to complete, and some time ago the incremental repair stopped working - that is, SSTables are not being marked as repaired, even though the repair reports success. Running a full or incremental repair does not

Re: apache-cassandra 2.2.8 rpm

There is no Apache Cassandra RPM for 2.2.8. If there were, it would be basically identical to the Datastax package anyway. The differences would be package name and a dependency on python 2.7 in the spec for Apache Cassandra. (I used to maintain the Datastax Community packages and currently bui

Data Model for One To Many - Itemcontainer - Items

hi, i have two CFs "ItemContainer" and "Items". I used to have a secondary index in "Items" referring to the "Itemcontainer". Something like: CREATE table items (key uuid primary key, container uuid, slot int CREATE INDEX items_container ON items(container) i change the "container" cel