Cassandra 1.0.6 data flush query

2012-06-21 Thread Roshan
Hi I am using Cassandra 1.0.6 version in our production system and noticed that Cassandra flushing the data to SSTable and the file size is < 10MB. With under moderate write load, the Cassandra flushing lots of memtables with small sizes. With this compaction doing lots of compactions. O/S - Cent

Re: Much more native memory used by Cassandra then the configured JVM heap size

2012-06-21 Thread Terje Marthinussen
We run some fairly large and busy Cassandra setups. All of them without mmap. I have yet to see a benchmark which conclusively can say mmap is better (or worse for that matter) than standard ways of doing I/O and we have done many of them last 2 years by different people, with different tools an

Indexing JSON in Cassandra

2012-06-21 Thread Brian O'Neill
I know we had this conversation over on the dev list a while back: http://www.mail-archive.com/dev@cassandra.apache.org/msg03914.html I just wanted to let people know that we added the capability to our cassandra-indexing extension. http://brianoneill.blogspot.com/2012/06/indexing-json-in-cassandr

Re: Creating secondary index CQL3 cassandra 1.1.1

2012-06-21 Thread Stephen Powis
Ah yes that's it exactly, including the time outs/errors. I wonder why this didn't come up when I googled the error from my system logs. Thanks! Stephen On Thu, Jun 21, 2012 at 2:47 AM, Sylvain Lebresne wrote: > On Thu, Jun 21, 2012 at 5:11 AM, Stephen Powis > wrote: > > I have the following s

Re: When will CQL BATCH support binding variable (Query substitution use named parameters)?

2012-06-21 Thread Data Craftsman
Hi Sylvain, Thanks for the quick response. Yes. I don't know the difference from bind variable to "query substitution". I'm a little confused, I just try to use your language. :) In Oracle world, we called Binding Variable. Can you give me a concise example for bound variables supported by BA

RE: Much more native memory used by Cassandra then the configured JVM heap size

2012-06-21 Thread Poziombka, Wade L
Just to close this item: with CASSANDRA-4314 applied I see no memory errors (either Java heap or native heap). Cassandra appears to be a hog with its memory mapped files. This caused us to wrongly think it was the culprit in a severe native memory leak. However, our leaky process was a differ

Re: Unbalanced ring in Cassandra 0.8.4

2012-06-21 Thread aaron morton
> Does cleanup only cleanup keys that no longer belong to that node. Yes. I guess it could be an artefact of the bulk load. It's not been reported previously though. Try the cleanup and see how it goes. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelas

Re: Using row cache causes slowdown and unavailable reads

2012-06-21 Thread aaron morton
2300 * 5MB / 1024 = 11GB Check the logs for GC problems. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/06/2012, at 8:39 PM, Nury Redjepow wrote: > Good day, > > I'm load testing our cassandra instance. I have a column family with 2

Strange behavior ¿data corruption?

2012-06-21 Thread Juan Ezquerro
Hi I'm using version 1.1.1. I'm sorry about the lack of information, i don't have stacktraces, nothig crash, just return empty, i explain, i do login as usual, find in db if there is a user named X and who belongs to client Y, if that is true i return the hash of password from db and do my checks.

Re: cqlsh commands

2012-06-21 Thread paul cannon
What do you mean when you say you can't display the related documentations using the help command? What does cqlsh do instead? I don't know about any bugs in that area. p On Wed, Jun 20, 2012 at 6:47 AM, Thierry Templier < thierry.templ...@restlet.com> wrote: > Hello, > > I'm using cqlsh tool

Re: Starting cassandra with -D option

2012-06-21 Thread Flavio Baronti
The option must actually include also the name of the yaml file: Dcassandra.config=file:///Users/walmart/Downloads/Cassandra/Node2-Cassandra1.1.0/conf/cassandra.yaml Flavio Il 6/21/2012 13:16 PM, Roshni Rajagopal ha scritto: Hi Folks, We wanted to have a single cassandra installation, an

Starting cassandra with -D option

2012-06-21 Thread Roshni Rajagopal
Hi Folks, We wanted to have a single cassandra installation, and use it to start cassandra in other nodes by passing it the cassandra configuration directories as a parameter. Idea is to avoid having the copies of cassandra code in each node, and starting each node by getting into bin/cassand

Tiered compation on two disks

2012-06-21 Thread Flavio Baronti
Hi, I have a Cassandra installation where we plan to store 1Tb of data, split between two 1Tb disks. Tiered compation should be better suited for our workload (append-only, deletion of old data, few reads). I know that tiered compaction needs 50% free disk space for worst case situation. How do

Re: cqlsh commands

2012-06-21 Thread Thierry Templier
Thanks very much, Jeff. It's exactly what I looked for... Thierry You should be able to get most of this information from the datastax documentation, e.g. http://www.datastax.com/docs/1.0/references/cql/index for version 1.0. Jeff

Re: cqlsh commands

2012-06-21 Thread Jeff Williams
You should be able to get most of this information from the datastax documentation, e.g. http://www.datastax.com/docs/1.0/references/cql/index for version 1.0. Jeff On Jun 20, 2012, at 1:47 PM, Thierry Templier wrote: > Hello, > > I'm using cqlsh tool to create column families and it works fi