Re: upgrade from 1.0.7 to 1.0.8

Check this out: http://www.datastax.com/docs/1.0/install/upgrading#upgrading-between-minor-releases-of-cassandra-1-0-x Cheers Am 11.03.2012 um 07:42 schrieb Tamar Fraenkel ta...@tok-media.com: Hi! I want to experiment with upgrading. Does anyone have a good link on how to upgrade Cassandra?

Re: CAn't bootstrap a new node to my cluster

After more than 9 hours, I've restart the node and reused the join command (data+cache+commitlog have not been erased) and now the node is in normal state in less than a second : nodetool -h localhost ring Address DC RackStatus State Load OwnsToken

data model question

Hi! I need some advise: I have user CF, which has a UUID key which is my internal user id. One of the column is facebook_id of the user (if exist). I need to have the reverse mapping from facebook_id to my UUID. My intention is to add a CF for the mapping from Facebook Id to my id: user_by_fbid

Re: upgrade from 1.0.7 to 1.0.8

Thanks! will check it in the following days :) *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Sun, Mar 11, 2012 at 10:00 AM, Marcel Steinbach mstei...@gmail.comwrote:

Re: data model question

Either you do that or you could think about using a secondary index on the fb user name in your primary cf. See http://www.datastax.com/docs/1.0/ddl/indexes Cheers Am 11.03.2012 um 09:51 schrieb Tamar Fraenkel ta...@tok-media.com: Hi! I need some advise: I have user CF, which has a UUID key

Re: data model question

Hi! Thanks for the response. From what I read, secondary indices are good only for columns with few possible values. Is this a good fit for my case? I have unique facebook id for every user. Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com

TTL 3 hours + GC grace 0

Hi All, I am using TTL 3 hours and GC grace 0 for a CF. I have a normal CF that has records with TTL 3 hours and I dont send any delete request. I just wonder if using GC grace 0 will cause any problem except extra Memory/IO/network load. I know that gc grace is for not transferring deleted

Re: LeveledCompaction and/or SnappyCompressor causing memory pressure during repair

One thing you may want to look at is the meanRowSize from nodetool cfstats and your compression block size. In our case the mean compacted size is 560 bytes and 64KB block size caused CPU tickets and a lot of short lived memory. I have brought by block size down to 16K. The result tables are not

OOM opening bloom filter

Using cassandra-1.0.6 one node fails to start. java.lang.OutOfMemoryError: Java heap space at org.apache.cassandra.utils.obs.OpenBitSet.init(OpenBitSet.java:104) at org.apache.cassandra.utils.obs.OpenBitSet.init(OpenBitSet.java:92) at

Re: TTL 3 hours + GC grace 0

I am using TTL 3 hours and GC grace 0 for a CF. I have a normal CF that has records with TTL 3 hours and I dont send any delete request. I just wonder if using GC grace 0 will cause any problem except extra Memory/IO/network load. I know that gc grace is for not transferring deleted records

Re: OOM opening bloom filter

How did this this bloom filter get too big? Bloom filters grow with the amount of row keys you have. It is natural that they grow bigger over time. The question is whether there is something wrong with this node (for example, lots of sstables and disk space used due to compaction not running,

Re: OOM opening bloom filter

On Sun, 2012-03-11 at 15:06 -0700, Peter Schuller wrote: If it is legitimate use of memory, you *may*, depending on your workload, want to adjust target bloom filter false positive rates: https://issues.apache.org/jira/browse/CASSANDRA-3497 This particular cf has up to ~10 billion rows

Re: OOM opening bloom filter

On Sun, 2012-03-11 at 15:36 -0700, Peter Schuller wrote: Are you doing RF=1? That is correct. So are you calculations then :-) very small, 1k. Data from this cf is only read via hadoop jobs in batch reads of 16k rows at a time. [snip] It's my understanding then for this use case that

how to increase compaction rate?

I'm having difficulties with leveled compaction, it's not making fast enough progress. I'm on a quad-core box and it only does one compaction at a time. Cassandra version: 1.0.6. Here's nodetool compaction stats: # nodetool -h localhost compactionstats pending tasks: 2568 compaction

Re: how to increase compaction rate?

multithreaded_compaction: false Set to true. -- / Peter Schuller (@scode, http://worldmodscode.wordpress.com)