Dropped request...

2011-11-16 Thread Jeesoo Shin
Hello. I'm using cassandra 0.8.6 with nodetool tpstats, dropped statistics are shown. when drop happens... what can I do? are there ways to turn on debug messages or to look into? thanks.

mmap I/O and shared memory

2011-11-16 Thread Jaesung Lee
I am running 7 nodes cassandra(v1.0.2) cluster. I am putting 20K rows per sec to the cluster. This cluster has 1 KS, 3CFs. Each CF has 4-5 secondary indices. After I'v run for 1 week, nodes use swap memory. I changed disk-access-mode to index_only or standard. I got strange memory results. > usin

About compile YCSB with Cassandra 1.02

2011-11-16 Thread Matsumoto, Miki | DU
Hi, I want to have performance measurement of Cassandra 1.02 using YCSB. But YCSB only supports Cassandra 0.7. If someone have knowledge about how to compile Cassandra 1.02 with YCSB or tips, could please share it with me? Thank you very much. Regards Miki

Re: Seeking advice on Schema and Caching

2011-11-16 Thread Aditya
On Thu, Nov 17, 2011 at 10:25 AM, samal wrote: > >> Edanuff + Beautiful People > > I think "row cache" could be the best fit but it can take resource > depending on row size. It will only touch disk once (first time) in case of > SST, rest of the req for that row will be served from memory. Try >

Re: Seeking advice on Schema and Caching

2011-11-16 Thread samal
>> Edanuff + Beautiful People I think "row cache" could be the best fit but it can take resource depending on row size. It will only touch disk once (first time) in case of SST, rest of the req for that row will be served from memory. Try increasing row cache size and decreasing save period to app

Re: Efficiency of Cross Data Center Replication...?

2011-11-16 Thread Jeremiah Jordan
Pretty sure data is sent to the coordinating node in DC2 at the same time it is sent to replicas in DC1, so I would think 10's of milliseconds after the transport time to DC2. On Nov 16, 2011, at 3:48 PM, ehers...@gmail.com wrote: > On a related note - assuming there are available resources acr

Re: Network traffic patterns

2011-11-16 Thread Todd Burruss
Are all of your machines equal hardware? Since those machines are sending data somewhere, maybe they are behind in replicating and are continuously catching up? Use a tool like tcpdump to find out where the data is going From: Philippe mailto:watche...@gmail.com>> Reply-To: "user@cassandra.apa

Re: Seeking advice on Schema and Caching

2011-11-16 Thread Aditya
Thanks to samal who pointed to look at the composite columns. I am now using composite columns names containing username+userId & valueless column. Thus column names are now unique even for users with same name as userId is also attached to the same composite col name. Thus the supercolumn issue is

Re: Efficiency of Cross Data Center Replication...?

2011-11-16 Thread ehers...@gmail.com
On a related note - assuming there are available resources across the board (cpu and memory on every node, low network latency, non-saturated nics/circuits/disks), what's a reasonable expectation for timing on replication? Sub-second? Less than five seconds? Ernie On Wed, Nov 16, 2011 at 4:00 PM,

Re: Efficiency of Cross Data Center Replication...?

2011-11-16 Thread Brian Fleming
Great - thanks Jake B. On Wed, Nov 16, 2011 at 8:40 PM, Jake Luciani wrote: > the former > > > On Wed, Nov 16, 2011 at 3:33 PM, Brian Fleming > wrote: > >> >> Hi All, >> >> I have a question about inter-data centre replication : if you have 2 >> Data Centers, each with a local RF of 2 (i.e. to

Re: Efficiency of Cross Data Center Replication...?

2011-11-16 Thread Sylvain Lebresne
To be complete, https://issues.apache.org/jira/browse/CASSANDRA-3472 is relevant. -- Sylvain On Wed, Nov 16, 2011 at 9:40 PM, Jake Luciani wrote: > the former > > On Wed, Nov 16, 2011 at 3:33 PM, Brian Fleming > wrote: >> >> Hi All, >> >> I have a question about inter-data centre replication :

Re: Efficiency of Cross Data Center Replication...?

2011-11-16 Thread Jake Luciani
the former On Wed, Nov 16, 2011 at 3:33 PM, Brian Fleming wrote: > > Hi All, > > I have a question about inter-data centre replication : if you have 2 Data > Centers, each with a local RF of 2 (i.e. total RF of 4) and write to a node > in DC1, how efficient is the replication to DC2 - i.e. is tha

Efficiency of Cross Data Center Replication...?

2011-11-16 Thread Brian Fleming
Hi All, I have a question about inter-data centre replication : if you have 2 Data Centers, each with a local RF of 2 (i.e. total RF of 4) and write to a node in DC1, how efficient is the replication to DC2 - i.e. is that data : - replicated over to a single node in DC2 once and internally replic

Re: BulkLoader

2011-11-16 Thread Brandon Williams
On Mon, Nov 14, 2011 at 2:49 PM, Giannis Neokleous wrote: > Hello everyone, > > We're using the bulk loader to load data every day to Cassandra. The > machines that use the bulkloader are diferent every day so their IP > addresses change. When I do "describe cluster" i see all the unreachable > no

sstableloader issue

2011-11-16 Thread mike.li
Hello , I need to load an external SSTABLEs to a cluster with 4 nodes. So I shutdown one of the node , and created a separate folder on this node as a temporary staging place for the external sstables, and run the sstableloader command like: ./bin/sstableloader /cassandra/bulk_load/Timeseries

Re: Thanks for CQL

2011-11-16 Thread Cass Costello
+1 Sent from my iPhone On Nov 16, 2011, at 8:09 AM, Peter Lin wrote: > I just wanted to say thanks to the entire Cassandra Team and Hector > client team for CQL. > > I've been using it this week and it makes life easier. At first I had > mixed feelings on CQL, but after using it the last few d

Thanks for CQL

2011-11-16 Thread Peter Lin
I just wanted to say thanks to the entire Cassandra Team and Hector client team for CQL. I've been using it this week and it makes life easier. At first I had mixed feelings on CQL, but after using it the last few days, the "user friendly" factor makes a huge difference. peter

CQL and subcolumns

2011-11-16 Thread Jone Lura
Hi, I am trying to find out how to use CQL to be able to use cassandra-jdbc in my application, and I have some questions. I have tried to find the answers int the documentation of Cassandra Query Language (CQL) v2.0, but I did not find the answers to my following questions. How do I create a c

Re: Fast lookups for userId to username and vice versa

2011-11-16 Thread Boris Yen
I think secondary index could do the trick. However, if you need to provide the pagination function, I will go for Konstantin's solution. On Wed, Nov 16, 2011 at 10:27 PM, Konstantin Naryshkin wrote: > Or just have two column families to do it: A CF idToName that has the > userIds as keys and

Re: Fast lookups for userId to username and vice versa

2011-11-16 Thread Konstantin Naryshkin
Or just have two column families to do it: A CF idToName that has the userIds as keys and the userName as the only column and a CF nameToId that has the userNames as keys and the userId as the only column On Mon, Nov 14, 2011 at 03:50, chovatia jaydeep wrote: > Check if Cassandra secondary index

Re: Cassandra JDBC

2011-11-16 Thread Nilabja Banerjee
Try this it should work.. import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class InsertData { public static void main(String[] args) throws ClassNotFoundException, SQLException{ Cl

Re: memory problems still post- CASSANDRA-3492

2011-11-16 Thread Radim Kolar
Dne 15.11.2011 22:04, Mick Semb Wever napsal(a): But another node (on the same machine but different cluster), even after an upgrade to the staging 1.0.3 and a `nodetool scrub`, always soaks all available memory (up to and plateau at 30G). In fact no cf there use compression anymore. I had simila

Cassandra JDBC

2011-11-16 Thread Jone Lura
Hi, I downloaded the cassandra-jdbc and built with maven. And when I am trying to use it in my application I get an exception on the following code: java.sql.Connection conn = DriverManager.getConnection("jdbc:cassandra://localhost:9160/MyKeyspace"); java.lang.IncompatibleClassChangeError: Im