Really high read latency

Hi! So I've got a table like this: CREATE TABLE "default".metrics (row_time int,attrs varchar,offset int,value double, PRIMARY KEY(row_time, attrs, offset)) WITH COMPACT STORAGE AND bloom_filter_fp_chance=0.01 AND caching='KEYS_ONLY' AND comment='' AND dclocal_read_repair_chance=0 AND gc_grace_sec

Re: Really high read latency

ote: > Also, two control questions: > >- Are you using EBS for data storage? It might introduce additional >latencies. >- Are you doing proper paging when querying the keyspace? > > Cheers, > Jens > > On Mon, Mar 23, 2015 at 5:56 AM, Dave Galbraith < > david92

Re: Really high read latency

ition over time?). > > On Mon, Mar 23, 2015 at 4:01 AM, Dave Galbraith < > david92galbra...@gmail.com> wrote: > >> Duncan: I'm thinking it might be something like that. I'm also seeing >> just a ton of garbage collection on the box, could it be pullin

Disastrous profusion of SSTables

Hey! So I'm running Cassandra 2.1.2 and using the SizeTieredCompactionStrategy. I'm doing about 3k writes/sec on a single node. My read performance is terrible, all my queries just time out. So I do nodetool cfstats: Read Count: 42071 Read Latency: 67.47804242827601 ms. Write Count: 13

Re: Disastrous profusion of SSTables

> setting coldReadsToOmit back to 0 which was the default in 2.0.x > > On Mar 26, 2015, at 3:56 AM, Anishek Agarwal wrote: > > Are you frequently updating same rows ? What is the memtable flush size ? > can you post the table create query here in please. > > On Thu,

How much data is bootstrapping supposed to send?

I had a one-node Cassandra 2.1.3 cluster, where the output of nodetool status looked like this: Datacenter: datacenter1 === Status=Up/Down |/ State=Normal/Leaving/Joining/Moving -- Address Load Tokens OwnsHost ID Rack UN 172.31.2