Re: cassandra read latency help

2012-05-17 Thread Piavlo
On 05/18/2012 08:49 AM, Viktor Jevdokimov wrote: Row cache is ok until keys are not heavily updated, otherwise it frequently invalidates and pressures GC. According to http://www.datastax.com/docs/1.0/operat

Cassandra 1.0.6 multi data center read question

2012-05-17 Thread Roshan
Hi I have setup an Cassandra cluster in production and a separate cluster in our DR environment. The setup is basically 2 data center setup. I want to create a separate keyspace on production (production has some other keyspaces) and only that keyspace will sync the data with DR. If I do a read

RE: cassandra read latency help

2012-05-17 Thread Viktor Jevdokimov
Row cache is ok until keys are not heavily updated, otherwise it frequently invalidates and pressures GC. The high latency is from your batch of 100 keys. Review your data model to avoid such reads, if you need low latency. 500M rows on one node, or on the cluster? Reading 100 random rows at to

Re: Safely Disabling Compaction

2012-05-17 Thread Vijay
I would rather set the Keyspace setting min_compaction_threshold and max_compaction_threshold to be a higher number and once i am ready i will put the value back... This way i dont need to restart. Having said that why not set the compaction throughput to 1 (low enough to not have contention) and c

Re: unsubscribe

2012-05-17 Thread Dave Brosius
On 05/17/2012 09:49 PM, casablinca126.com wrote: unsubscribe send that message to user-unsubscr...@cassandra.apache.org

Re: Using EC2 ephemeral 4disk raid0 cause high iowait trouble

2012-05-17 Thread koji Lin
Hi We use amazon ami 3.2.12-3.2.4.amzn1.x86_64 and some of our data file are more than 10G thanks koji 2012-5-16 下午6:00 於 "aaron morton" 寫道: > On Ubuntu ? Sounds like http://wiki.apache.org/cassandra/FAQ#ubuntu_hangs > > Cheers > > > - > Aaron Morton > Freelance Developer > @a

Re: sstableloader 1.1 won't stream

2012-05-17 Thread sj.climber
Pieter, Aaron, Any further progress on this? I'm running into the same issue, although in my case I'm trying to stream from Ubuntu 10.10 to a 2-node cluster (also Cassandra 1.1.0, and running on separate Ubuntu 10.10 hosts). Thanks in advance! -- View this message in context: http://cassandra-

unsubscribe

2012-05-17 Thread casablinca126.com
unsubscribe

Re: row cache -- does it have data from other nodes?

2012-05-17 Thread Edward Capriolo
No cache can only have data from the local node since write operations need to be able to evict items. On Thu, May 17, 2012 at 4:42 PM, Maxim Potekhin wrote: > Hello, > > when I chose to have a rowcache -- will it contain data that is owned by > other nodes? > > Thanks > > Maxim >

row cache -- does it have data from other nodes?

2012-05-17 Thread Maxim Potekhin
Hello, when I chose to have a rowcache -- will it contain data that is owned by other nodes? Thanks Maxim

Re: 1.0.6 -> 1.1.0 nodetool ownership report, and other anomalies

2012-05-17 Thread Ron Siemens
>> >> Does the updated reporting in 1.1.0 include the replicated data and before >> it didn't? > > Yes. > Thanks for verifying that. Ron

Re: Exception when truncate

2012-05-17 Thread ruslan usifov
Its our test machine with one node in cluster:-) 2012/5/17 Jeremy Hanna : > when doing a truncate, it has to talk to all of the nodes in the ring to > perform the operation.  by the error, it looks like one of the nodes was > unreachable for some reason.  you might do a nodetool ring in the cli

Re: need some clarification on recommended memory size

2012-05-17 Thread Yiming Sun
Hi Aaron, Thank you for guiding us by breaking down the issue. Please see my answers embedded > Is this a single client ? Yes > How many columns is it asking for ? the client knows a list of all row keys, and it randomly picks 100, and loops 100 times. It first reads a metadata column to fig

Connection Reset By Peer (CQL over SSH Tunnel)

2012-05-17 Thread Montgomery Burns
Hi, I am trying to connect to a Cassandra (1.0.8 or 1.1.0) server with the standard Thrift/CQL client, over an SSH tunnel, but keep getting this exception: org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection reset by peer: socket write error The CQL query itself

Re: cassandra read latency help

2012-05-17 Thread Gurpreet Singh
Thanks Viktor for the advice. Right now, i just have 1 node that i am testing against and i am using CL one. Are you suggesting that the page cache might be doing better than the row cache? I am getting row cache hit of 0.66 right now. /G On Thu, May 17, 2012 at 12:26 AM, Viktor Jevdokimov < vikt

Re: Data modeling for read performance

2012-05-17 Thread Aaron Turner
On Thu, May 17, 2012 at 8:55 AM, jason kowalewski wrote: > We have been attempting to change our data model to provide more > performance in our cluster. > > Currently there are a couple ways to model the data and i was > wondering if some people out there could help us out. > > We are storing tim

Re: Matthew Dennis's "Cassandra On EC2"

2012-05-17 Thread Tamar Fraenkel
I think the topic is very interesting :) I can't attend the SF event (as I am in Israel) and will appreciate a video! Thanks, *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

Re: Matthew Dennis's "Cassandra On EC2"

2012-05-17 Thread Sasha Dolgy
Although, probably inappropriate, I would be willing to contribute some funds for someone to recreate it with animated stick-figures. thanks. ;) On Thu, May 17, 2012 at 6:02 PM, Jeremy Hanna wrote: > Sorry - it was at the austin cassandra meetup and we didn't record the > presentation. I wonder

Zurich / Swiss / Alps meetup

2012-05-17 Thread Sasha Dolgy
All, A year ago I made a simple query to see if there were any users based in and around Zurich, Switzerland or the Alps region, interested in participating in some form of Cassandra User Group / Meetup. At the time, 1-2 replies happened. I didn't do much with that. Let's try this again. Who a

Re: Matthew Dennis's "Cassandra On EC2"

2012-05-17 Thread Jeremy Hanna
Sorry - it was at the austin cassandra meetup and we didn't record the presentation. I wonder if this would be a popular topic to have at the upcoming Cassandra SF event which would be recorded... On May 17, 2012, at 6:51 AM, Tamar Fraenkel wrote: > Hi! > > I found the slides of the lecture

Re: Exception when truncate

2012-05-17 Thread Jeremy Hanna
when doing a truncate, it has to talk to all of the nodes in the ring to perform the operation. by the error, it looks like one of the nodes was unreachable for some reason. you might do a nodetool ring in the cli do a 'describe cluster;' and see if your ring is okay. So I think the operation

Re: 1.0.6 -> 1.1.0 nodetool ownership report, and other anomalies

2012-05-17 Thread Eric Evans
On Wed, May 16, 2012 at 5:08 PM, Ron Siemens wrote: > > I upgraded to 1.0.6 to 1.1.0, and I noticed the effective ownership report > changed. > > I have a 3-node cluster, with evenly divided tokens and RF=2.  The node tool > report on 1.0.6 was: > > 33.33%  0 > 33.33%  56713727820156410577229101

Re: Exception when truncate

2012-05-17 Thread ruslan usifov
Maybe, something changes in cassandra 1.0.x for truncate mechanism, because in cassandra 0.8 truncate executes much faster on the same data 2012/5/17 Viktor Jevdokimov : > Truncate flushes all memtables to free up commit logs, and that on all nodes. > So this takes time. Discussed on this list no

Matthew Dennis's "Cassandra On EC2"

2012-05-17 Thread Tamar Fraenkel
Hi! I found the slides of the lecture http://www.slideshare.net/mattdennis/cassandra-on-ec2 I wonder if there is a way to get a video of the lecture. Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 835

RE: Exception when truncate

2012-05-17 Thread Viktor Jevdokimov
Truncate flushes all memtables to free up commit logs, and that on all nodes. So this takes time. Discussed on this list not so long ago. Watch for: https://issues.apache.org/jira/browse/CASSANDRA-3651 https://issues.apache.org/jira/browse/CASSANDRA-4006 Best regards / Pagarbiai Viktor Jevdok

Re: Exception when truncate

2012-05-17 Thread ruslan usifov
Also i miss understand why on empty CF(no any SStable) truncate heavy loads disk?? 2012/5/17 ruslan usifov : > Hello > > I have follow situation on our test server: > > from cassandra-cli i try to use > > truncate purchase_history; > > 3 times i got: > > [default@township_6waves] truncate purchase

Exception when truncate

2012-05-17 Thread ruslan usifov
Hello I have follow situation on our test server: from cassandra-cli i try to use truncate purchase_history; 3 times i got: [default@township_6waves] truncate purchase_history; null UnavailableException() at org.apache.cassandra.thrift.Cassandra$truncate_result.read(Cassandra.java:202

Re: Inconsistent dependencies

2012-05-17 Thread Sylvain Lebresne
On Thu, May 17, 2012 at 2:14 AM, Rob Coli wrote: > On Tue, Apr 24, 2012 at 12:56 PM, Matthias Pfau wrote: >> we just noticed that cassandra is currently published with inconsistent >> dependencies. The inconsistencies exist between the published pom and the >> published distribution (tar.gz). I c

RE: cassandra read latency help

2012-05-17 Thread Viktor Jevdokimov
> Gurpreet Singh wrote: > Any ideas on what could help here bring down the read latency even more ? Avoid Cassandra forwarding request to other nodes: - Use consistency level ONE; - Create data model to do single request with single key, since different keys may belong to different nodes and requ

Re: Composite Column

2012-05-17 Thread samal
zCassandra data model is best known for demoralize data. You must have entry for column name in other column family. Example is just for posterity, you should not put everything in single row, very inefficient. I do not use composite column. The way I do and others do is use complex column. rowk