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

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 st

row cache hit is costlier for partiton with large rows

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

so, incomplete 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

Re: Cassandra fetches complete partition

19:28:35,423 | 10.76.214.80 |147 Row cache hit | 19:28:35,425 | 10.76.214.80 | 2530 Read 1 live and 0 tombstoned cells | 19:28:35,425 | 10.76.214.80 | 2574

Re: Cassandra fetches complete partition

rows_per_partition to 1002 then it is HIT for all. On Jan 19, 2015 2:17 PM, "nitin padalia" 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 pa

Cassandra fetches complete partition

'some_clustring_key'; Thanks! in advance. Nitin Padalia

Re: Tracing On, Partion Index 0 entries found

o 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 > wrote: > >> Hi, >> >> While Tracing is on, we see a trace

Tracing On, Partion Index 0 entries found

Hi, While Tracing is on, we see a trace message, Partition index with entries found for sstable 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.

Is merging costly operation with wide rows? On Dec 10, 2014 5:53 PM, "nitin padalia" wrote: > I am using a schema like below: > > CREATE TABLE user_location_map ( > store_id uuid, > location_id uuid, > user_serial_number text, > userobjectid uui

Reset cfhistograms

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]

Thanks! Michael. On Dec 17, 2014 8:02 PM, "Laing, Michael" wrote: > http://datastax.github.io/python-driver/api/cassandra.html > > On Wed, Dec 17, 2014 at 9:27 AM, nitin padalia > wrote: >> >> Thanks! Philip/Ryan, >> Ryan I am using single Datacenter. &

Re: [Consitency on cqlsh command prompt]

des 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 > wrote: >> >> Hi, >> >> When I s

[Consitency on cqlsh command prompt]

= 1)+1 = 2. 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.

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 bloom_filter_fp_ch