Re: Nodes frozen in GC

2011-03-06 Thread ruslan usifov
2011/3/6 aaron morton aa...@thelastpickle.com Your node is under memory pressure, after the GC there is still 5.7GB in use. In fact it looks like memory usage went up during the GC process. Can you reduce the memtable size, caches or the number of CF's or increase the JVM size? Also is this

Re: cant seem to figure out secondary index definition

2011-03-06 Thread Jürgen Link
Hi Roshan, could you please post a small sample from your yaml file? As documentation of indexes is quite sparse, we're grateful for any working example. Cheers Jürgen Am 04.03.2011 19:27, schrieb Roshan Dawrani: On Fri, Mar 4, 2011 at 11:52 PM, Jürgen Link juergen.l...@googlemail.com

Re: cant seem to figure out secondary index definition

2011-03-06 Thread Roshan Dawrani
Hi, Sure. Here is a sample of how we define it at the end of cassandra.yaml. In the keyspace MyApp, it defines a column family MyUser, that has secondary indexes on 2 String columns - firstname, and lastname. Does it help?

Re: cant seem to figure out secondary index definition

2011-03-06 Thread Roshan Dawrani
On Sun, Mar 6, 2011 at 4:54 PM, Roshan Dawrani roshandawr...@gmail.comwrote: -- keyspaces: - name: firstname validator_class: UTF8Type

Re: confirm unsubscribe from user@cassandra.apache.org

2011-03-06 Thread Thomas cmdln Gideon
On 03/06/2011 08:08 AM, user-h...@cassandra.apache.org wrote: Hi! This is the ezmlm program. I'm managing the user@cassandra.apache.org mailing list. To confirm that you would like cm...@thecommandline.net removed from the user mailing list, please send a short reply to this

Re: Nodes frozen in GC

2011-03-06 Thread Peter Schuller
Do you have row cache enabled? Disable it. If it fixes it and you want it, re-enable but consider row sizes and the cap on the cache size.. -- / Peter Schuller

Re: OOM exceptions

2011-03-06 Thread Mark
If its determined that this is due to a very large row, what are my options? Thanks On 3/5/11 7:11 PM, aaron morton wrote: First question is which version are you running ? Am guessing 0.6 something If you have OOM in the compaction thread it may be because of a very large row. The CF

What would be a good strategy for Storing the large text contents like blog posts in Cassandra.

2011-03-06 Thread Aditya Narayan
What would be a good strategy to store large text content/(blog posts of around 1500-3000 characters) in cassandra? I need to store these blog posts along with their metadata like bloggerId, blogTags. I am looking forward to store this data in a single row giving each attribute a single column.

Re: how large can a cluster over the WAN be?

2011-03-06 Thread Mimi Aluminium
Hi, Please, can you help with the following? it will lead us in some design decisions. Are you familiar with Cassandra cluster that is installed in datacenters that are spread across the WAN? can you comment on the perfromance of such installation? What is the largest size of of such a cluster

Re: cant seem to figure out secondary index definition

2011-03-06 Thread Jürgen Link
Hi Roshan, thanks for your post. I quickly ran over it, and the only difference I can actually see is the compare_with type (we use TimeUUIDType). Any other suggestions, anyone? Am 06.03.2011 12:24, schrieb Roshan Dawrani: Hi, Sure. Here is a sample of how we define it at the end of

Re: OOM exceptions

2011-03-06 Thread Aaron Morton
Under 0.6 am not sure off the top of my head. Would need to dig into it, its probably been discussed here though. Check the row size and let us know what version you are using first. Aaron On 7/03/2011, at 5:50 AM, Mark static.void@gmail.com wrote: If its determined that this is due to a

Re: What would be a good strategy for Storing the large text contents like blog posts in Cassandra.

2011-03-06 Thread Aaron Morton
Sounds reasonable, one CF for the blog post one CF for the comments. You could also use a single CF if you will often read the blog and the comments at the same time. The best design is the one that suits how your app works, try one and be prepared to change. Note that counters are only in the

Re: OOM exceptions

2011-03-06 Thread Mark
Sorry, I forgot to mention. I am running 0.6.6 On 3/6/11 3:27 PM, Aaron Morton wrote: Under 0.6 am not sure off the top of my head. Would need to dig into it, its probably been discussed here though. Check the row size and let us know what version you are using first. Aaron On 7/03/2011, at

Re: cant seem to figure out secondary index definition

2011-03-06 Thread Tyler Hobbs
On Sun, Mar 6, 2011 at 4:49 PM, Jürgen Link juergen.l...@googlemail.comwrote: Hi Roshan, thanks for your post. I quickly ran over it, and the only difference I can actually see is the compare_with type (we use TimeUUIDType). Any other suggestions, anyone? You want to add an index on a CF

Designing a decent data model for an online music shop...confused/stuck on decisions

2011-03-06 Thread Courtney
We're in a bit of a predicament, we have an e-music store currently built in PHP using codeigniter/mysql... The current system has 100+K users and a decent song collection. Over the last few months I've been playing with Cassandra... needless to say I'm impressed but I have a few questions.

Re: Designing a decent data model for an online music shop...confused/stuck on decisions

2011-03-06 Thread Tyler Hobbs
Regarding PHP performance with Cassandra, THRIFT-638https://issues.apache.org/jira/browse/THRIFT-638was recently resolved and it shows some big performance improvements. I'll be upgrading the Thrift package that ships with phpcassa soon to include this fix, so you may want to compare performance

Re: question about replicas dynamic response to load

2011-03-06 Thread Shaun Cutts
Thanks for the answers, Dan, Aaron. ... Ok, so one question is, if I haven't made any writes at all, can I decommission without delay? (Is there a force drop option or something, or will the cluster recognize the lack of writes)? I may be able to segregate writes to the reference collection

Re: Secondary indexes

2011-03-06 Thread aaron morton
Info on secondary indexes http://www.datastax.com/dev/blog/whats-new-cassandra-07-secondary-indexes Some answers to your other questions are also in there as well as a discussion about the limitations. Hope that helps. Aaron On 7/03/2011, at 3:54 PM, Mark wrote: I haven't looked at

Re: What would be a good strategy for Storing the large text contents like blog posts in Cassandra.

2011-03-06 Thread Aditya Narayan
Thanks Aaron!! I didnt knew about the upcoming facility for inbuilt counters. This sounds really great for my use-case!! Could you let me know where can I read more about this, if this had been blogged about, somewhere ? I'll go forward with the one (entire)blog per column design. Thanks On