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
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
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
>
>
>
> 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
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
*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 .
Well the problem still persists.
Giving cassandra 12G of heap and having a look at the table I saw that
caching='KEYS_ONLY' . Did not find how to disable caching for rows (I'm not
sure if setting to 0 will disable it)
On Friday, March 14, 2014 3:14 PM, Andras Szerdahelyi
wrote:
Is row
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
To add to this, if the 24G is the JVM limit, Cassandra will actually be
using even more than this for bloom filters etc. that are managed off-heap.
So the amount of page cache left is almost certainly inadequate.
On 14 March 2014 13:01, Andras Szerdahelyi <
andras.szerdahe...@ignitionone.com> wro
Is row cache enabled on this CF? Try disabling it. Seems like you might have a
very wide row there.
Can you grep for GCInspector in your Cassandra log? 24G might be a bit too much
for the Cassandra JVM, bogging down GC, and not leaving much to page cache (
32G -24G - Tomcat ). I don’t quite und
10 matches
Mail list logo
