Re: Cassandra going OOM due to tombstones (heapdump screenshots provided)

2020-01-29 Thread Behroz Sikander
It doesn't seem to be the problem but I do not have deep knowledge of C* internals. When do memtable come into play? Only at startup? - To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org For additional commands, e-mai

Re: Cassandra going OOM due to tombstones (heapdump screenshots provided)

2020-01-29 Thread Behroz Sikander
>> If it's after the host comes online and it's hint replay from the other hosts, you probably want to throttle hint replay significantly on the rest of the cluster. Whatever your hinted handoff throttle is, consider dropping it by 50-90% to work around whichever of those two problems it is. This

Re: Cassandra going OOM due to tombstones (heapdump screenshots provided)

2020-01-29 Thread Behroz Sikander
>> Startup would replay commitlog, which would re-materialize all of those mutations and put them into the memtable. The memtable would flush over time to disk, and clear the commitlog. >From our observation, the node is already online and it seems to be happening >after the commit log replay has

Re: Cassandra going OOM due to tombstones (heapdump screenshots provided)

2020-01-29 Thread Behroz Sikander
>> Some environment details like Cassandra version, amount of physical RAM, JVM configs (heap and others), and any other non-default cassandra.yaaml configs would help. The amount of data, number of keyspaces & tables, since you mention "clients", would also be helpful for people to suggest tun

Cassandra going OOM due to tombstones (heapdump screenshots provided)

2020-01-24 Thread Behroz Sikander
We recently had a lot of OOM in C* and it was generally happening during startup. We took some heap dumps but still cannot pin point the exact reason. So, we need some help from experts. Our clients are not explicitly deleting data but they have TTL enabled. C* details: > show version [cqlsh 5.

Re: Cassandra filter with ordering query modeling

2018-03-01 Thread Behroz Sikander
latest/cql/dml.html#the-where-clause > > There are several Cassandra handbooks available on Amazon, maybe it would > be helpful for you to use some of them as starting point to understand > aspects of Cassandra data[query] modeling. > > > Regards, > > Kyrill > ---

Cassandra filter with ordering query modeling

2018-03-01 Thread Behroz Sikander
Hi,own vote favorite I am new to Cassandra and I am trying to model a table in Cassandra. My queries look like the following Query #1: select * from TableA where Id = "123"Query #2: select * from TableA