Re: Cassandra slow on some reads

2014-03-15 Thread Batranut Bogdan
Whooops  On one of the nodes when running my tests I found an exception java FileNotFoundException : file -Data.db not found at org.apache.cassandra.io.compress.CompressedThrottledReader.open(CompressedThrottledReader.java:52 also got another one coming from java.io.RandomAccessFile.o

Re: Cassandra slow on some reads

2014-03-15 Thread Benedict Elliott Smith
Post the server logs and traces of one of the lengthy queries? On 15 Mar 2014 20:49, "Batranut Bogdan" wrote: > Hello, > > Yes for the first query the server can be slow but no matter what is > should not take 10 seconds to get one key from a column family. I can see > this happening if I have ti

Re: Cassandra slow on some reads

2014-03-15 Thread Batranut Bogdan
Hello, Yes for the first query the server can be slow but no matter what is should not take 10 seconds to get one key from a column family. I can see this happening if I have times like 20 ms for some queries and let's say 300 ms for uncached ones. But I have responses that take from 8 to 20 ms

Re: Cassandra slow on some reads

2014-03-14 Thread Manoj Khangaonkar
> > > > I have ~450 queries that are like this: SELECT * FROM table where key = > 'some string' and ts = some value; some value is close to present time. > > The problem: > > About 10 - 20 % of these queries take more than 5 seconds to execute, in > fact, the majority of those take around 10 second

Re: Cassandra slow on some reads

2014-03-14 Thread Batranut Bogdan
Hello, I can't go this way... this cf will be used for time ranges.  On Friday, March 14, 2014 5:10 PM, "Laing, Michael" wrote: If you do not need to do range queries on your 'timestam' (ts) column - and if you can change your schema (big if...), then you could move 'timestam' into the pa

Re: Cassandra slow on some reads

2014-03-14 Thread Laing, Michael
*If* you do not need to do range queries on your 'timestam' (ts) column - *and* if you can change your schema (big if...), then you could move 'timestam' into the partition key like this (using your notation): PK((key String , timestam int), column1 string, col2 string) , list1 , list 2, list 3 .

Re: Cassandra slow on some reads

2014-03-14 Thread Batranut Bogdan
tranut Bogdan Date: Friday 14 March 2014 13:50 To: "user@cassandra.apache.org" Subject: Cassandra slow on some reads Hello all, Here is the environment: I have a 6 node Cassandra cluster. On each node I have: - 32 G RAM - 24 G RAM for cassa - ~150 - 200 MB/s disk speed - tomcat 6 wit

Re: Cassandra slow on some reads

2014-03-14 Thread Batranut Bogdan
Ok will try to reduce heap and see what happens. Thanks guys. I' get back with conclusions.https://overview.mail.yahoo.com?.src=iOS";>Sent from Yahoo Mail for iPhone

Re: Cassandra slow on some reads

2014-03-14 Thread Benedict Elliott Smith
tranut Bogdan > Reply-To: "user@cassandra.apache.org" , > Batranut Bogdan > Date: Friday 14 March 2014 13:50 > To: "user@cassandra.apache.org" > Subject: Cassandra slow on some reads > > Hello all, > > Here is the environment: > > I have a 6

Re: Cassandra slow on some reads

2014-03-14 Thread Andras Szerdahelyi
sandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>>, Batranut Bogdan mailto:batra...@yahoo.com>> Date: Friday 14 March 2014 13:50 To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apach

Cassandra slow on some reads

2014-03-14 Thread Batranut Bogdan
Hello all, Here is the environment: I have a 6 node Cassandra cluster. On each node I have: - 32 G RAM - 24 G RAM for cassa - ~150 - 200 MB/s disk speed - tomcat 6 with axis2 webservice that uses the datastax java driver to make asynch reads / writes  - replication factor for the keyspace is 3 (