SV: about insert benchmark

2010-09-02 Thread Thorvaldsson Justus
Batchmutate insert? Can be package size that differ if not nr threads sending data to Cassandra nodes. Från: ChingShen [mailto:chingshenc...@gmail.com] Skickat: den 2 september 2010 08:59 Till: user@cassandra.apache.org Ämne: Re: about insert benchmark Hi Daniel, I have 4 nodes in my cluster

Cassandra 0.7 example

2010-09-02 Thread Thorvaldsson Justus
<<< Courtney Robinson [sa...@live.co.uk] Hello everyone, I'm sorry if that has been asked already, i've just joined the list. can anyone provide a quick java example of connecting to cassandra and setting up a keyspace and a column family using thrift. I know my way around 0.6 and i

dont mind my last letter (server problem)

2010-09-01 Thread Thorvaldsson Justus
Or this one =) Server error was indeed an error but on my behalf. If you try to memlock more than available memory on server it will kernel crash Also If you use swap as ram it will be having a lot of trouble /J AB SVENSKA SPEL 106 10 Stockholm Sturegatan 11, Sundbyberg Växel +46 8 757 77 00 htt

Server problem C 0.6.5

2010-09-01 Thread Thorvaldsson Justus
Ok I have two test servers, they are RH and pretty nice. I have two problems with one of them and none with the other. Same configuration but the seed and listen address that is their opposites. Nothing fancy. RF=2 All info I can get is also here and some more like conf, 590 rows http://pastie.o

SV: SV: SV: Help with getting Key range with some column limitations

2010-08-20 Thread Thorvaldsson Justus
within last 5 minutes. Jone On 20/08/2010 10:05, Thorvaldsson Justus wrote: I think you should try to do it some other way than iterate, it sounds super suboptimal to me. Also the plugin option he was thinking of I think is changing Cassandra sourcecode, kind of hard when Cassandra is changi

SV: SV: Help with getting Key range with some column limitations

2010-08-20 Thread Thorvaldsson Justus
plugin exist? or do I have to develop it myself? Are there any documentation on plugin development for Cassandra? Best regards Jone On 19/08/2010 08:42, Thorvaldsson Justus wrote: You should iterate through them, get 200 then go get the next 200 and so on. Also if checking a bounding box to a

SV: Poor performance; PHP & Thrift to blame

2010-08-20 Thread Thorvaldsson Justus
Seach the mailing list http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/ This is already been addressed and is a php issue only The time 5 sec is a timeout because if I remember correctly packet size is too small or something like it You can config so it stops being a porblem but

SV: Replication factor and other schema changes in >= 0.7

2010-08-19 Thread Thorvaldsson Justus
KsDef CfDef <-has metadata And perhaps ColumnDef how to make a ksdef--- KsDef k = new KsDef(); k.setName(keyspacename); k.setReplication_factor(replicafactor); k.setStrategy_class("org.apache.cassandra.locator.RackUnawareStrategy"); List cfDefs = new ArrayList(); k.setCf_defs(cfDefs); c.syst

SV: Help with getting Key range with some column limitations

2010-08-18 Thread Thorvaldsson Justus
You should iterate through them, get 200 then go get the next 200 and so on. Also if checking a bounding box to another.. perhaps try sorting them so you could start looking at both ends, perhaps make the iteration smaller until match somehow? Just my simple coins, also upgrading will probably be

How to use Secondary Indices 0.7.0beta1

2010-08-17 Thread Thorvaldsson Justus
I figured some but I am stuck, would appreciate help a lot to understand how to use secondary indices. Create a Column family and define the secondary indices " CfDef cdef = new CfDef(); cdef.setColumn_type(columntype); cdef.setComment(comment); cdef.setComparator_type(comparatortype); cdef.s

SV: Cassandra gem

2010-08-16 Thread Thorvaldsson Justus
Using beta, made a describe_version(), got 10.0.0 as reply, aint using gem though, just thrift from java /Justus -Ursprungligt meddelande- Från: Benjamin Black [mailto:b...@b3k.us] Skickat: den 17 augusti 2010 08:37 Till: user@cassandra.apache.org Ämne: Re: Cassandra gem I'm testing wit

SV: The entry of Cassandra

2010-08-16 Thread Thorvaldsson Justus
e entry of Cassandra You mean list a few hosts and connect them in a round robin , like Tavory said? On Mon, Aug 16, 2010 at 8:36 PM, Thorvaldsson Justus mailto:justus.thorvalds...@svenskaspel.se>> wrote: http://wiki.apache.org/cassandra/ClientOptions but I prefer writing my own code,

SV: The entry of Cassandra

2010-08-16 Thread Thorvaldsson Justus
http://wiki.apache.org/cassandra/ClientOptions but I prefer writing my own code, trying to write something simple API working with 0.7.0beta1 amt though am I the only one that thinks NOT using clients like hector is simpler (in a way, to feel in control at least)? Från: Ying Tang [mailto:ivytan

SV: how to retrieve data from supercolumns by phpcassa ?

2010-08-12 Thread Thorvaldsson Justus
I don't use php so I don't know the method but http://wiki.apache.org/cassandra/API "get ColumnOrSuperColumn get(string keyspace, string key, ColumnPath column_path, ConsistencyLevel consistency_level) Get the Column or SuperColumn at the given column_path. If no value is present, NotFoundExcep

SV: Using Cassandra for storing measurement data

2010-08-03 Thread Thorvaldsson Justus
It sounds to me that it's an good idea to use Cassandra in your case, I figure I help you as we Europeans need to cooperate some even though I only worked with Cassandra for a month. =) 1: What is the query you want to use when charting the data? Use it to decide how to storage and sort your da

Differencing test results

2010-07-28 Thread Thorvaldsson Justus
I am testing on one node only right now and simply adding data and reading it. There is no real problem but I feel I get differencing results from the tests depending on something I would like to know what it is. What is happening between two "points in time" -->Here is a point with Slower result

SV: Consequences of Cassandra key NOT unique

2010-07-28 Thread Thorvaldsson Justus
You insert 500 rows with key "x" And 1000 rows with key "y" You make a query getting all rows. It will only show two rows, the ones with the latest timestamps. /Justus Från: Rana Aich [mailto:aichr...@gmail.com] Skickat: den 29 juli 2010 08:23 Till: user@cassandra.apache.org Ämne: Re: Consequences

SV: Key Caching

2010-07-27 Thread Thorvaldsson Justus
I can test on 3 servers and I can test using up to 86gb on each, is there anything specific you want to test in this case? I am using Cassandra 6.3 and running a much smaller amount of RAM but if you think it is interesting I will add it to my ToDo list. I don’t know if I will have more servers

SV: Help! Cassandra Data Loader threads are getting stuck

2010-07-27 Thread Thorvaldsson Justus
I made one program doing just this with Java Basically I read with one thread from file into an array stopping when size is 20k and w8 until it is less than 20k and continue reading the datafile. (this is the raw data I want to move) I have n number of threads Each with one batch of their own an

SV: what causes MESSAGE-DESERIALIZER-POOL to spike

2010-07-27 Thread Thorvaldsson Justus
AFAIK You could use more nodes and read in parallel from them making your read rate go up. Also don't write and read to the same disk may help some. It's not so much about "Cassandra's" read rate but what your hardware can manage. /Justus Från: Dathan Pattishall [mailto:datha...@gmail.com] Skic

SV: How to stop cassandra server, installed from debian/ubuntu package

2010-07-26 Thread Thorvaldsson Justus
I use standard close, CTRL C, I don't run it as deamon Dunno but think it works fine =) -Ursprungligt meddelande- Från: o...@notrly.com [mailto:o...@notrly.com] Skickat: den 26 juli 2010 15:52 Till: user@cassandra.apache.org Ämne: How to stop cassandra server, installed from debian/ubuntu

SV: SV: What is consuming the heap?

2010-07-20 Thread Thorvaldsson Justus
not using supercolumn and size of a column will not exceed 1M 2010-07-20 发件人: Thorvaldsson Justus 发送时间: 2010-07-20 14:52:22 收件人: 'user@cassandra.apache.org' 抄送: 主题: SV: What is consuming the heap? Supercolumn/column must fit

SV: What is consuming the heap?

2010-07-19 Thread Thorvaldsson Justus
Supercolumn/column must fit into node memory It could be? /Justus Från: 王一锋 [mailto:wangyif...@aspire-tech.com] Skickat: den 20 juli 2010 08:48 Till: user Ämne: What is consuming the heap? In my cluster, I have set both KeysCached and RowsCached of my column family on all nodes to "0", but it sti

SV: key types and grouping related rows together

2010-07-14 Thread Thorvaldsson Justus
Dont forget you can make your own sorting algorithm. Here is a nice tutorial for that. http://www.sodeso.nl/?p=421 Justus Från: Schubert Zhang [mailto:zson...@gmail.com] Skickat: den 15 juli 2010 04:20 Till: user@cassandra.apache.org Ämne: Re: key types and grouping related rows together for you

SV: Query on delete a column inside a super column

2010-07-07 Thread Thorvaldsson Justus
This is my first email, just started with Cassandra, I think you want to use Mutate object or something like it "The Mutation object can also be used to create new Columns or to delete a Column, if you supply it with a key that doesn't exist in the database it will create it, if it detects that