Re: how to delete data with level compaction

2012-01-28 Thread Peter Schuller
> I'm at 80%, so not quite panic yet ;-) > > I'm wondering, in the steady state, how much of the space used will > contain deleted data. That depends entirely on your workload, including: * How big the data that you are deleting is in relation to the size of tombstones * How long the average piec

Re: how to delete data with level compaction

2012-01-28 Thread Thorsten von Eicken
On 1/28/2012 9:34 AM, Peter Schuller wrote: >> I'm using level compaction and I have about 200GB compressed in my >> largest CFs. The disks are getting full. This is time-series data so I >> want to drop data that is a couple of months old. It's pretty easy for >> me to iterate through the relevant

Re: how to delete data with level compaction

2012-01-28 Thread Peter Schuller
> I'm using level compaction and I have about 200GB compressed in my > largest CFs. The disks are getting full. This is time-series data so I > want to drop data that is a couple of months old. It's pretty easy for > me to iterate through the relevant keys and delete the rows. But will > that do an

Re: Restart cassandra every X days?

2012-01-28 Thread Maxim Potekhin
Sorry if this has been covered, I was concentrating solely on 0.8x -- can I just d/l 1.0.x and continue using same data on same cluster? Maxim On 1/28/2012 7:53 AM, R. Verlangen wrote: Ok, seems that it's clear what I should do next ;-) 2012/1/28 aaron morton >

Re: Restart cassandra every X days?

2012-01-28 Thread R. Verlangen
Ok, seems that it's clear what I should do next ;-) 2012/1/28 aaron morton > There are no blockers to upgrading to 1.0.X. > > A > - > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 28/01/2012, at 7:48 AM, R. Verlangen wrote: > > Ok. Seems

Re: Thift vs. CQL

2012-01-28 Thread bxqdev
On 1/28/2012 12:41 PM, aaron morton wrote: Please disregard my "(both are supported now and that situation may not last for ever. )" comment. ok, but why did you change you mind? Aaron - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 28/01/

Re: Thift vs. CQL

2012-01-28 Thread bxqdev
i like thrift and i want to use it. i want to use procedure code, instead of query language. i just need to be sure it won't be dropped on day in favor to cql. in my opinion, they can't replace each other. they are different apis with different philosophies. On 1/28/2012 12:34 PM, aaron morton wr

Re: Thift vs. CQL

2012-01-28 Thread aaron morton
Please disregard my "(both are supported now and that situation may not last for ever. )" comment. Aaron - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 28/01/2012, at 9:34 PM, aaron morton wrote: > Use a higher level client for your language >

Re: Restart cassandra every X days?

2012-01-28 Thread aaron morton
There are no blockers to upgrading to 1.0.X. A - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 28/01/2012, at 7:48 AM, R. Verlangen wrote: > Ok. Seems that an upgrade might fix these problems. Is Cassandra 1.x.x stable > enough to upgrade for, or

Re: Thift vs. CQL

2012-01-28 Thread aaron morton
Use a higher level client for your language http://wiki.apache.org/cassandra/ClientOptions and avoid the question. The different is mostly of concern to client writers. (both are supported now and that situation may not last for ever. ) Cheers - Aaron Morton Freelance Develop

Re: How to create a table in Cassandra

2012-01-28 Thread aaron morton
Check the documentation here http://www.datastax.com/docs/1.0/index Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 28/01/2012, at 3:36 AM, anandbab...@polarisft.com wrote: > > Can anyone tell me how to create a table in the Cassandra