Does C* (2.1) know to read just one SSTable given a skinny row w/frequently updated column(s) & STCS?

2017-02-16 Thread Richard Klancer
Hi all, My team is trying to determine whether to use size-tiered or leveled compaction for some tables in an app that will be moving to production soon. using C* 2.1. We have a few tables that look like this: CREATE TABLE ks.counters ( id timeuuid PRIMARY KEY, count counter ) The

Repair: huge boost on C* 2.1 with CASSANDRA-12580

2016-10-14 Thread Romain Hardouin
With CASSANDRA-12580: 16 hours (yes, hours!) The improvement is not always dramatic (e.g. 8 hours instead of 39 hours on another set) but still significant and valuable. Moreover, considering that: * repair is a mandatory operation in many use cases * Paulo already made the patch for 2.1 * C* 2.1

Re: Verify cassandra backup and restore in C * 2.1

2016-08-09 Thread Riccardo Ferrari
s does the trick. Best, On Tue, Aug 9, 2016 at 8:50 AM, INDRANIL BASU wrote: > Thanks Rajath. We have atleast 20 millions of records, so count(*) with > limit and token is getting cumbersome. > Yes using nodetool snapshot. I know there is a nodetool verify, but i m > using C

Re: Verify cassandra backup and restore in C * 2.1

2016-08-08 Thread INDRANIL BASU
Thanks Rajath. We have atleast 20 millions of records, so count(*) with limit and token is getting cumbersome.  Yes using nodetool snapshot. I know there is a nodetool verify, but i m using C * 2.1 Copy commands sometimes fails as well. So any better easy mechanism?  Thanks and regards

Re: Verify cassandra backup and restore in C * 2.1

2016-08-08 Thread Rajath Subramanyam
Hi Indranil, One approach is to do a row count on the original source table and the table that is restored from backup. How are you backing up data ? I am assuming you are issuing snapshot commands (either incremental or otherwise). I hope this helps. - Rajath Rajath Su

Verify cassandra backup and restore in C * 2.1

2016-08-08 Thread INDRANIL BASU
Hello,    How can we verify that cassandra data is backed up and restored correctly? -- IB

Gossip Behavioral Difference between C* 2.0 and C* 2.1

2016-06-06 Thread Michael Fong
Hi, We recently discovered that there are some differences in gossip behavior between C* 2.0 and C* 2.1. In some cases of network instability or a node reboot, we can observe some behavioral differences from Cassandra/system.log. 2.0.17 We can observe this log of similar pattern in log : DEBUG

C*2.1 using timestamp with same timestamp

2016-04-08 Thread aeljami.ext
YYY | | 999 | 1460088862025940 but with C*2.1 for the same insertions I get the row without TTL, therefore the first row. a| b | ttl(b) | writetime(b) ++-+---

RE: [C*2.1]memtable_allocation_type: offheap_objects

2016-03-10 Thread aeljami.ext
: user@cassandra.apache.org Objet : Re: [C*2.1]memtable_allocation_type: offheap_objects We use them. No signs of stability problems in 2.1 that we’ve attributed to offheap objects. From: "aeljami@orange.com<mailto:aeljami@orange.com>" Reply-To: "user@cassandra.a

Re: [C*2.1]memtable_allocation_type: offheap_objects

2016-03-09 Thread Jeff Jirsa
We use them. No signs of stability problems in 2.1 that we’ve attributed to offheap objects. From: "aeljami@orange.com" Reply-To: "user@cassandra.apache.org" Date: Wednesday, March 9, 2016 at 1:54 AM To: user Subject: [C*2.1]memtable_allocation_type:

Re: [C*2.1]memtable_allocation_type: offheap_objects

2016-03-09 Thread Jonathan Haddad
Check out Al's Tuning Guide. He discusses offheap objects. https://tobert.github.io/pages/als-cassandra-21-tuning-guide.html On Wed, Mar 9, 2016 at 1:54 AM wrote: > Hi, > > > > offheap_objects was removed in releases 3.2.x then reintroduced in > release 3.4: I vould like to know if someone ha

[C*2.1]memtable_allocation_type: offheap_objects

2016-03-09 Thread aeljami.ext
Hi, offheap_objects was removed in releases 3.2.x then reintroduced in release 3.4: I vould like to know if someone has used offheap_objects in Cassandra 2.1: stable or not, improvement observed or not... Thanks. Ahmed _

Re: C 2.1

2014-09-17 Thread Jack Krupansky
, September 17, 2014 5:25 PM To: user Subject: Re: C 2.1 Thanks Rob for pointing me to that link. I haven't gone through all the JIRAs but I guess it talks about adv & disadv of Secondary Index in Cassandra which I understand by now but doesn't really talk about why the default impl

Re: C 2.1

2014-09-17 Thread Ram N
ng queries across the cluster. And... Lucene (underneath Solr) is > optimal for queries that span multiple fields. DSE/Solr supports CQL3 wide > rows (clustering columns.) > > -- Jack Krupansky > > *From:* Ram N > *Sent:* Monday, September 15, 2014 4:34 PM > *To:* user > *

Re: C 2.1

2014-09-16 Thread Jack Krupansky
distributing queries across the cluster. And... Lucene (underneath Solr) is optimal for queries that span multiple fields. DSE/Solr supports CQL3 wide rows (clustering columns.) -- Jack Krupansky From: Ram N Sent: Monday, September 15, 2014 4:34 PM To: user Subject: Re: C 2.1 Jack, Using Solr

Re: C 2.1

2014-09-15 Thread Robert Coli
On Mon, Sep 15, 2014 at 1:34 PM, Ram N wrote: > Would be great to understand the design decision to go with present > implementation on Secondary Index when the alternative is better? Looking > at JIRAs is still confusing to come up with the why :) > http://mail-archives.apache.org/mod_mbox/incu

Re: C 2.1

2014-09-15 Thread James Briggs
it's been done, but most of the apps written for C* are greenfield or v2.0 rewrites. Thanks, James Briggs -- Cassandra/MySQL DBA. Available in San Jose area or remote. From: Ram N To: user Sent: Monday, September 15, 2014 1:34 PM Subject: Re: C

Re: C 2.1

2014-09-15 Thread Ram N
ert Coli > *Sent:* Monday, September 15, 2014 11:07 AM > *To:* user@cassandra.apache.org > *Subject:* Re: C 2.1 > > On Sat, Sep 13, 2014 at 3:49 PM, Ram N wrote: > >> Is 2.1 a production ready release? >> > > https://engineering.eventbrite.com/what-version-of-cas

Re: C 2.1

2014-09-15 Thread Jack Krupansky
: Re: C 2.1 On Sat, Sep 13, 2014 at 3:49 PM, Ram N wrote: Is 2.1 a production ready release? https://engineering.eventbrite.com/what-version-of-cassandra-should-i-run/ Datastax Java driver - I get too confused with CQL and the underlying storage model. I am also not clear on the

Re: C 2.1

2014-09-15 Thread Robert Coli
On Sat, Sep 13, 2014 at 3:49 PM, Ram N wrote: > Is 2.1 a production ready release? > https://engineering.eventbrite.com/what-version-of-cassandra-should-i-run/ > Datastax Java driver - I get too confused with CQL and the underlying > storage model. I am also not clear on the indexing stru

Re: C 2.1

2014-09-15 Thread James Briggs
le in San Jose area or remote. From: Ram N To: user@cassandra.apache.org Sent: Saturday, September 13, 2014 3:49 PM Subject: C 2.1 Team, I am pretty new to cassandra (with just 2 weeks of playing around with it on and off) and planning a fresh deployment

C 2.1

2014-09-13 Thread Ram N
Team, I am pretty new to cassandra (with just 2 weeks of playing around with it on and off) and planning a fresh deployment with 2.1 release. The data-model is pretty simple for my use-case. Questions I have in mind are Is 2.1 a production ready release? Driver selection? I played around wit

Re: C* 2.1-rc2 gets unstable after a 'DROP KEYSPACE' command ?

2014-08-07 Thread Sylvain Lebresne
aemon.main(CassandraDaemon.java:544) > Exception encountered during startup: null > > I do not now if it can help. > > > Fabrice LARCHER > > > 2014-07-18 7:23 GMT+02:00 Fabrice Larcher : > > Hello, >> >> I still experience a similar issue after a 'D

Re: C* 2.1-rc2 gets unstable after a 'DROP KEYSPACE' command ?

2014-08-07 Thread Fabrice Larcher
brice LARCHER 2014-07-18 7:23 GMT+02:00 Fabrice Larcher : > Hello, > > I still experience a similar issue after a 'DROP KEYSPACE' command with C* > 2.1-rc3. Connection to the node may fail after a 'DROP'. > > But I did not see this issue with 2.1-rc1 (

Re: C* 2.1-rc2 gets unstable after a 'DROP KEYSPACE' command ?

2014-07-17 Thread Fabrice Larcher
Hello, I still experience a similar issue after a 'DROP KEYSPACE' command with C* 2.1-rc3. Connection to the node may fail after a 'DROP'. But I did not see this issue with 2.1-rc1 (-> it seems like to be a regression brought with 2.1-rc2). Fabrice LARCHER 2014-07-17

Re: C* 2.1-rc2 gets unstable after a 'DROP KEYSPACE' command ?

2014-07-17 Thread Benedict Elliott Smith
Also https://issues.apache.org/jira/browse/CASSANDRA-7437 and https://issues.apache.org/jira/browse/CASSANDRA-7465 for rc3, although the CounterCacheKey assertion looks like an independent (though comparatively benign) bug I will file a ticket for. Can you try this against rc3 to see if the proble

Re: C* 2.1-rc2 gets unstable after a 'DROP KEYSPACE' command ?

2014-07-16 Thread Tyler Hobbs
This looks like https://issues.apache.org/jira/browse/CASSANDRA-6959, but that was fixed for 2.1.0-rc1. Is there any chance you can put together a script to reproduce the issue? On Thu, Jul 10, 2014 at 8:51 AM, Pavel Kogan wrote: > It seems that memtable tries to flush itself to SSTable of not

Re: C* 2.1-rc2 gets unstable after a 'DROP KEYSPACE' command ?

2014-07-10 Thread Pavel Kogan
It seems that memtable tries to flush itself to SSTable of not existing keyspace. I don't know why it is happens, but probably running nodetool flush before drop should prevent this issue. Pavel On Thu, Jul 10, 2014 at 4:09 AM, Fabrice Larcher wrote: > ​Hello, > > I am using the 'development'

C* 2.1-rc2 gets unstable after a 'DROP KEYSPACE' command ?

2014-07-10 Thread Fabrice Larcher
​Hello, I am using the 'development' version 2.1-rc2. With one node (=localhost), I get timeouts trying to connect to C* after running a 'DROP KEYSPACE' command. I have following error messages in system.log : INFO [SharedPool-Worker-3] 2014-07-09 16:29:36,578 MigrationManager.java:319 - Drop K