Re: How to know disk utilization by each row on a node

2015-01-21 Thread nitin padalia
Did you use cfstats and cfhistograms? On Jan 22, 2015 12:37 AM, Edson Marquezani Filho edsonmarquez...@gmail.com wrote: Ok, nice tool, but I still can't see how much data each row occupies on the SSTable (or am I missing something?). Obs: considering SSTables format, where rows are strictly

row cache hit is costlier for partiton with large rows

2015-01-21 Thread nitin padalia
If for both cases data is in memory why its not same? Can someone point me what wrong here? Nitin Padalia

Why Cassandra 2.1.2 couldn't populate row cache in between

2015-01-20 Thread nitin padalia
partition can't reside in row cache. However in new version since we could resize the cache, so why not we populate from other than the start? Nitin Padalia

Cassandra fetches complete partition

2015-01-19 Thread nitin padalia
'; Thanks! in advance. Nitin Padalia

Re: Cassandra fetches complete partition

2015-01-19 Thread nitin padalia
Read 1 live and 0 tombstoned cells | 19:28:35,425 | 10.76.214.80 | 2574 Request complete | 19:28:35,425 | 10.76.214.80 | 2943 On Mon, Jan 19, 2015 at 6:25 PM, nitin padalia padalia.ni

Re: Cassandra fetches complete partition

2015-01-19 Thread nitin padalia
rows_per_partition to 1002 then it is HIT for all. On Jan 19, 2015 2:17 PM, nitin padalia padalia.ni...@gmail.com wrote: Hi, Does Cassandra fetches complete partition if I include Cluster key in where clause. Or What is the difference in: 1. Select * from column_family where partition_key

Re: Tracing On, Partion Index 0 entries found

2015-01-14 Thread nitin padalia
to an index of the cells within the partition (in a single sstable). It can have zero entries when there are very few cells in the partition. On Wed, Jan 14, 2015 at 5:48 AM, nitin padalia padalia.ni...@gmail.com wrote: Hi, While Tracing is on, we see a trace message, Partition index with X

Tracing On, Partion Index 0 entries found

2015-01-14 Thread nitin padalia
Hi, While Tracing is on, we see a trace message, Partition index with X entries found for sstable Y What does it actually means? Does it mean in 'Partion Index' file has X partion key:offset entries for SSTable Y? If so then when could X be 0? -- Nitin Padalia

Re: [Merging data from memtables and 1 sstables] takes too much time.

2014-12-24 Thread nitin padalia
Is merging costly operation with wide rows? On Dec 10, 2014 5:53 PM, nitin padalia padalia.ni...@gmail.com wrote: I am using a schema like below: CREATE TABLE user_location_map ( store_id uuid, location_id uuid, user_serial_number text, userobjectid uuid, PRIMARY KEY

Reset cfhistograms

2014-12-19 Thread nitin padalia
Hi, I am using cassandra 2.1.2 with 5 node cluster single DC. I've read that histograms are reset after node restart or rerun of command. But in my case it's not resetting by running every time. Could someone point what could be the issue or how could I reset it without restarting node. Thanks! in

Re: [Consitency on cqlsh command prompt]

2014-12-17 Thread nitin padalia
is not the number of nodes that need to respond, but the enum value that corresponds to QUORUM internally. If you would like, you can file an improvement request on the Apache Cassandra Jira. On Wed, Dec 17, 2014 at 12:47 AM, nitin padalia padalia.ni...@gmail.com wrote: Hi, When I set Consistency

Re: [Consitency on cqlsh command prompt]

2014-12-17 Thread nitin padalia
Thanks! Michael. On Dec 17, 2014 8:02 PM, Laing, Michael michael.la...@nytimes.com wrote: http://datastax.github.io/python-driver/api/cassandra.html On Wed, Dec 17, 2014 at 9:27 AM, nitin padalia padalia.ni...@gmail.com wrote: Thanks! Philip/Ryan, Ryan I am using single Datacenter. Philip

[Consitency on cqlsh command prompt]

2014-12-16 Thread nitin padalia
. I am using Casssandra version 2.1.2 and cqlsh 5.0.1 and CQL spec 3.2.0 Thanks! in advance. Nitin Padalia

[Merging data from memtables and 1 sstables] takes too much time.

2014-12-10 Thread nitin padalia
I am using a schema like below: CREATE TABLE user_location_map ( store_id uuid, location_id uuid, user_serial_number text, userobjectid uuid, PRIMARY KEY ((store_id, location_id), user_serial_number) ) WITH CLUSTERING ORDER BY (user_serial_number ASC) AND