Repair has now effect

2012-09-02 Thread Patricio Echagüe
Hey folks, perhaps a dumb question but I ran into this situation and it's a bit unclear what's going on. We are running a 3 nodes cluster with RF 3 (cass 1.0.11). We had one issue with one node and it was down for like 1 hour. I brought the node up again as soon as I realized it was down (and gan

Re: Repair has now effect

2012-09-02 Thread Jim Cistaro
What does "nt ring" show (on this node and on the other two)? That may provide some clues. From: Patricio Echagüe mailto:patric...@gmail.com>> Reply-To: mailto:user@cassandra.apache.org>> Date: Sun, 2 Sep 2012 15:50:31 -0700 To: mailto:cassandra-u...@incubator.apache.org>> Subject: Repair has no

Re: performance is drastically degraded after 0.7.8 --> 1.0.11 upgrade

2012-09-02 Thread aaron morton
The whole test run is taking longer ? So it could be slower queries or slower test setup / tear down? If you are creating and truncate the KS for each of the 500 tests is that taking longer ? (Schema code has changed a lot 0.7 > 1.0) Can you log the execution time for tests and find ones that ar

Re: force gc?

2012-09-02 Thread Alexander Shutyaev
Hi Jeffrey, I think I described the problem wrong :) I don't want to do Java's memory GC. I want to do cassandra's GC - that is I want to "really" remove deleted rows from a column family and get my disc space back. 2012/8/31 Jeffrey Kesselman > Cassandra at least used to do disc cleanup as a s

Re: Composite row keys with SSTableSimpleUnsortedWriter for Cassandra 1.0?

2012-09-02 Thread aaron morton
I think you want the o.a.c.db.marshal.TypeParser. You can pass a CLI format composite type to the parse() func. It's in 1.0X Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 1/09/2012, at 6:44 AM, Jeff Schmidt wrote: > Hello: > > I'm u

Re: force gc?

2012-09-02 Thread Peter Schuller
> I think I described the problem wrong :) I don't want to do Java's memory > GC. I want to do cassandra's GC - that is I want to "really" remove deleted > rows from a column family and get my disc space back. I think that was clear from your post. I don't see a problem with your process. Setting

Re: force gc?

2012-09-02 Thread Peter Schuller
> I think that was clear from your post. I don't see a problem with your > process. Setting gc grace to 0 and forcing compaction should indeed > return you to the smallest possible on-disk size. (But may be unsafe as documented; can cause deleted data to pop back up, etc.) -- / Peter Schuller (@

Re: force gc?

2012-09-02 Thread Alexander Shutyaev
Hi Peter, I don't compare it with PosgreSQL size, I just make some estimations.. This table / column family stores some xml documents with average raw size of 2Mb each and total size about 5Gb. However the space cassandra occupies on disc is 70Gb (after gc_grace was set to 0 and major compaction w

Re: force gc?

2012-09-02 Thread Peter Schuller
> Maybe there is some tool to analyze it? It would be great if I could somehow > export each row of a column family into a separate file - so I could see > their count and sizes. Is there any such tool? Or maybe you have some better > thoughts... Use something like pycassa to non-obnoxiously itera

Re: force gc?

2012-09-02 Thread Derek Williams
On Fri, Aug 31, 2012 at 7:03 AM, Alexander Shutyaev wrote: > Does anyone have any suggestions on how can I analyze my problem? Or maybe > I'm doing something wrong and there is another way to force gc on an > existing column family. > Are you using leveled compaction? I haven't looked into it too

Re: force gc?

2012-09-02 Thread Alexander Shutyaev
Hi Derek, I'm using size-tiered compaction. 2012/9/3 Derek Williams > On Fri, Aug 31, 2012 at 7:03 AM, Alexander Shutyaev wrote: > >> Does anyone have any suggestions on how can I analyze my problem? Or >> maybe I'm doing something wrong and there is another way to force gc on an >> existing co

Re: How to set LeveledCompactionStrategy for an existing table

2012-09-02 Thread Data Craftsman 木匠
We have same problem. On Friday, August 31, 2012, Jean-Armel Luce wrote: > Hello Aaron. > > Thanks for your answer > > Jira ticket 4597 created : https://issues.apache.org/jira/browse/CASSANDRA-4597 > > Jean-Armel > > 2012/8/31 aaron morton > > Looks like a bug. > Can you please create a ticket