Re: Automatic tombstone removal issue (STCS)

2014-05-06 Thread Yuki Morishita
Hi Paulo, The reason we check overlap is not to resurrect deleted data by only dropping tombstone marker from single SSTable. And we don't want to check row by row to determine if SSTable is droppable since it takes time, so we use token ranges to determine if it MAY have droppable columns. On Tu

Re: Automatic tombstone removal issue (STCS)

2014-05-06 Thread Robert Coli
On Tue, May 6, 2014 at 5:14 PM, Paulo Ricardo Motta Gomes < paulo.mo...@chaordicsystems.com> wrote: > Sorry for being persistent, but I'd love to clear my understanding on > this. Has anyone seen single sstable compaction being triggered for STCS > sstables with high tombstone ratio? > > Because i

Re: Automatic tombstone removal issue (STCS)

2014-05-06 Thread Paulo Ricardo Motta Gomes
Hello, Sorry for being persistent, but I'd love to clear my understanding on this. Has anyone seen single sstable compaction being triggered for STCS sstables with high tombstone ratio? Because if the above understanding is correct, the current implementation almost never triggers this kind of co

Re: Avoiding email duplicates when registering users

2014-05-06 Thread Tyler Hobbs
On Mon, May 5, 2014 at 10:27 AM, Ignacio Martin wrote: > > When a user registers, the server generates a UUID and performs an INSERT > ... IF NOT EXISTS into the email_to_UUID table. Immediately after, perform > a SELECT from the same table and see if the read UUID is the same that the > one we j

Re: error in cassandra log file under stress

2014-05-06 Thread Mohica Jasha
Thanks Robert, I understand that C* < 2.1 is probably not perfect for prod. But the choice to use C* 2.0.x was made long ago and we are trying to keep up. Anyway I filled a jira ticket: https://issues.apache.org/jira/browse/CASSANDRA-7176 On Mon, May 5, 2014 at 5:51 PM, Robert Coli wrote: >

Re: Is the updating compaction strategy from 'sized tiered' to 'leveled' automatic or need to be done manually? [heur]

2014-05-06 Thread Yatong Zhang
Thanks for the reply Viktor, but the whole cluster has been working all the time and I am sure the cf got writes every second. I still don't see the huge sstables being split into small ones On Tue, May 6, 2014 at 5:30 PM, Viktor Jevdokimov < viktor.jevdoki...@adform.com> wrote: > Enough to wri

Re: cassandra snapshots

2014-05-06 Thread Jonathan Lacefield
What version of Cassandra are you using? This could be from snapshot repairs in newer versions of Cassandra. CASSANDRA-5950 Also, check out the snapshot settings, other than incremental, in the .yaml file. There are several snapshot configura

RE: Is the updating compaction strategy from 'sized tiered' to 'leveled' automatic or need to be done manually? [heur]

2014-05-06 Thread Viktor Jevdokimov
Enough to write 1 column and run nodetool flush. From: Viktor Jevdokimov [mailto:viktor.jevdoki...@adform.com] Sent: Tuesday, May 6, 2014 12:00 PM To: user@cassandra.apache.org Subject: RE: Is the updating compaction strategy from 'sized tiered' to 'leveled' automatic or need to be done manually?

RE: Is the updating compaction strategy from 'sized tiered' to 'leveled' automatic or need to be done manually? [heur]

2014-05-06 Thread Viktor Jevdokimov
I mean insert/write data. When data fills memtable, memtable is flushed to disk as sstable, when new sstable is created, Cassandra will check if compaction is needed and triggers one. From: Yatong Zhang [mailto:bluefl...@gmail.com] Sent: Monday, May 5, 2014 9:54 AM To: user@cassandra.apache.org

Re: Frequent Full GC that take > 30s

2014-05-06 Thread Samuel CARRIERE
>>>Hello. >>> >>>I'm having problems with frequent Full GCs that take a long time, and cause a >>>burst of timeouts for the client application. But first, here is my >>>configuration: >>> >>>Cassandra: 1.1.5 >>>Key Cache: size 209715168 (bytes), capacity 209715168 (bytes), >>>1331992571

Ideal values for coreConnectionsForRemote and maxConnectionsForRemote : CQL Java Driver

2014-05-06 Thread Sourabh Agrawal
What are the ideal values for coreConnectionsForRemote and maxConnectionsForRemote in CQL Java Driver ( by Datastax). -- Sourabh Agrawal Bangalore +91 9945657973