Memtable HIT ratio ?

2013-11-29 Thread Girish Kumar
Hi, Are there any stats/tools to know how much memtable hits v/s SSTable hits ? /Girish BK

Re: Nodetool cleanup

2013-11-29 Thread Julien Campan
Thanks a lot for yours answers. 2013/11/29 John Sanda john.sa...@gmail.com Couldn't another reason for doing cleanup sequentially be to avoid data loss? If data is being streamed from a node during bootstrap and cleanup is run too soon, couldn't you wind up in a situation with data loss if

Snappy Load Error

2013-11-29 Thread Nigel LEACH
Hi, I'm building a new cluster, and having problems starting Cassandra. RHEL 5.9 Java 1.7 U40 Cassandra 2.0.2 Previous clusters have started fine using the same methods, although the envoronments are a little different (new RHEL, older Java). I am installing from DataStax tarball, and after

Re: reads and compression

2013-11-29 Thread Artur Kronenberg
Hi John, I am trying again :) The way I understand it is that compression gives you the advantage of having to use way less IO and rather use CPU. The bottleneck of reads is usually the IO time you need to read the data from disk. As a figure, we had about 25 reads/s reading from disk, while

RE: Snappy Load Error

2013-11-29 Thread Nigel LEACH
Very many thanks for the swift response Jeremy, snappy 1.0.4 works perfectly. For information, we have working environment of RHEL 6.4, and Java 1.7 U25, with snappy 1.0.5. All the best, Nigel -Original Message- From: jeremy.hanna1...@gmail.com [mailto:jeremy.hanna1...@gmail.com]

Re: reads and compression

2013-11-29 Thread Edward Capriolo
The big * in the explanation: Smaller file size footprint leads to better disk cache, however decompression adds work for the JVM to do and increases the churn of objects in the JVM. Additionally compression block sizes might be 4KB while for some use cases a small row may be 200bytes. This means

Pig 0.12.0 and Cassandra 2.0.2

2013-11-29 Thread Jason Lewis
I sent this to the Pig list, but didn't get a response... I'm trying to get Pig running with Cassandra 2.0.2. The instructions I've been using are here: https://github.com/jeromatron/pygmalion/wiki/Getting-Started The cassandra 2.0.2 src does not have a contrib directory. Am I missing

sstable2json hangs for authenticated keyspace?

2013-11-29 Thread Josh Dzielak
Having an issue with sstable2json. It appears to hang when I run it against an SSTable that's part of a keyspace with authentication turned on. Running it against any other keyspace works, and as far as I can tell the only difference between the keyspaces is authentication. Has anyone run into

Cassandra issue on startup (2.0.1 +?)

2013-11-29 Thread Jacob Rhoden
I know I need to get around to upgrading. Is this (exception on startup) an issue fixed in 2.0.3? Caused by: java.lang.IndexOutOfBoundsException: index (1) must be less than size (1) at com.google.common.base.Preconditions.checkElementIndex(Preconditions.java:306) at

Re: Recommended amount of free disk space for compaction

2013-11-29 Thread Anthony Grasso
Hi Robert, We found having about 50% free disk space is a good rule of thumb. Cassandra will typically use less than that when running compactions, however it is good to have free space available just in case it compacts some of the larger SSTables in the keyspace. More information can be found

Re: Recommended amount of free disk space for compaction

2013-11-29 Thread Takenori Sato
Hi, If Cassandra only compacts one table at a time, then I should be safe if I keep as much free space as there is data in the largest table. If Cassandra can compact multiple tables simultaneously, then it seems that I need as much free space as all the tables put together, which means no more

Re: Data loss when swapping out cluster

2013-11-29 Thread Anthony Grasso
Hi Robert, In this case would it be possible to do the following to replace a seed node? nodetool disablethrift nodetool disablegossip nodetool drain stop Cassandra deep copy /var/lib/cassandra/* on old seed node to new seed node start Cassandra on new seed node Regards, Anthony On Wed,

datastax QueryBuilder update

2013-11-29 Thread Grga Pitich
Can someone please explain how to do update using datastax QueryBuilder java API 1.04. I've tried: Query update = QueryBuilder .update(demo, user) .with(set(col1, val1)) .and(set(col2,val2)) .where(eq(col3,val3)); but this doesn't

Re: Cassandra issue on startup (2.0.1 +?)

2013-11-29 Thread Mikhail Stepura
https://issues.apache.org/jira/browse/CASSANDRA-5905 looks identical to your case. It’s duplicated to https://issues.apache.org/jira/browse/CASSANDRA-5202, which is still open. -M Jacob Rhoden jacob.rho...@me.com wrote in message news:18cefb6f-6d85-4084-9b08-fcdd6d3a6...@me.com... I know I