Re: cfhistograms InstanceNotFoundException EstimatePartitionSizeHistogram

2018-03-06 Thread Nicolas Guyomar
sandra > host. > > Chris > > Sent from my iPhone > > On Mar 6, 2018, at 3:29 AM, onmstester onmstester > wrote: > > Running this command: > nodetools cfhistograms keyspace1 table1 > > throws this exception in production server: > javax.management.Ins

Re: cfhistograms InstanceNotFoundException EstimatePartitionSizeHistogram

2018-03-06 Thread onmstester onmstester
t from my iPhone On Mar 6, 2018, at 3:29 AM, onmstester onmstester <onmstes...@zoho.com> wrote: Running this command: nodetools cfhistograms keyspace1 table1 throws this exception in production server: javax.management.InstanceNotFoundException: org.apache.cassandra.metri

Re: cfhistograms InstanceNotFoundException EstimatePartitionSizeHistogram

2018-03-06 Thread Chris Lohfink
. Chris Sent from my iPhone > On Mar 6, 2018, at 3:29 AM, onmstester onmstester wrote: > > Running this command: > nodetools cfhistograms keyspace1 table1 > > throws this exception in production server: > javax.management.InstanceNotFoundException: > org.apache.cass

cfhistograms InstanceNotFoundException EstimatePartitionSizeHistogram

2018-03-06 Thread onmstester onmstester
Running this command: nodetools cfhistograms keyspace1 table1 throws this exception in production server: javax.management.InstanceNotFoundException: org.apache.cassandra.metrics:type=Table,keyspace=keyspace1,scope=table1,name=EstimatePartitionSizeHistogram But i have no problem in a test

Re: metrics not resetting after running proxyhistograms or cfhistograms

2016-10-25 Thread Chris Lohfink
re running 3.6. Running "nodetool proxyhistograms" twice, we're seeing > the same data returned each time, but expecting the second run to be reset. > We're seeing the same behavior with "nodetool cfhistograms." > > I believe resetting after each call used to be

metrics not resetting after running proxyhistograms or cfhistograms

2016-10-25 Thread Andrew Bialecki
We're running 3.6. Running "nodetool proxyhistograms" twice, we're seeing the same data returned each time, but expecting the second run to be reset. We're seeing the same behavior with "nodetool cfhistograms." I believe resetting after each call used to be the

Re: nodetool cfhistograms

2016-10-04 Thread Sungju Hong
Sorry, I had a typing error. nodetool cfhistograms ouput shows like below. ks1/cf1 histograms Offset SSTables Write Latency Read Latency Row Size Column Count 1 0 0 0 0 35565129 2

nodetool cfhistograms

2016-10-04 Thread Sungju Hong
Hello, nodetool cfhistograms ouput shows like below. ks1/cf1 histograms Offset SSTables Write Latency Read Latency Row Size Column Count 1 0 0 0 0 35565129 2 0

Re: on-disk size vs partition-size in cfhistograms

2016-05-20 Thread Alain RODRIGUEZ
> and compact), and calculate the average size per row (total directory > size/count of rows). Can this be considered a valid approach to extrapolate > for future growth of data ? > > Related to this, is there any information we can gather from > partition-size of cfhistograms (s

on-disk size vs partition-size in cfhistograms

2016-05-06 Thread Joseph Tech
directory size/count of rows). Can this be considered a valid approach to extrapolate for future growth of data ? Related to this, is there any information we can gather from partition-size of cfhistograms (snipped output for my table below) : Partition Size (bytes) 642 bytes: 221 770 b

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: What time range does nodetool cfhistograms use?

2014-11-16 Thread Clint Kelly
e the read latencies shown the latencies within a single host, or are > they the end-to-end latencies from the coordinator node?" --> cfhistograms > shows metrics at table/node level, proxyhistograms shows metrics at > cluster/coordinator level > > On Sun, Nov 16, 2014 at 10:31

Re: What time range does nodetool cfhistograms use?

2014-11-16 Thread DuyHai Doan
"Does it show statistics for just the current node on which I am running, or for the entire cluster?" --> only current node. "Are the read latencies shown the latencies within a single host, or are they the end-to-end latencies from the coordinator node?" --> cfhistogr

Re: What time range does nodetool cfhistograms use?

2014-11-16 Thread Clint Kelly
? -Clint On Sun, Nov 16, 2014 at 10:05 AM, Mark Reddy wrote: > Hi Clint, > > The values of SSTables, Write Latency and Read Latency will be reset on node > start/restart and after running the cfhistograms command itself. > > The values of Row Size and Column Count are calculated a

Re: What time range does nodetool cfhistograms use?

2014-11-16 Thread Mark Reddy
Hi Clint, The values of SSTables, Write Latency and Read Latency will be reset on node start/restart and after running the cfhistograms command itself. The values of Row Size and Column Count are calculated at startup and then re-evaluated during compaction. Mark On 16 November 2014 17:12

What time range does nodetool cfhistograms use?

2014-11-16 Thread Clint Kelly
Hi all, Over what time range does "nodetool cfhistograms" operate? I am using Cassandra 2.0.8.39. I am trying to debug some very high 95th and 99th percentile read latencies in an application that I'm working on. I tried running nodetool cfhistograms to get a flavor for the

Re: nodetool cfhistograms refresh

2013-10-01 Thread Tyler Hobbs
On Tue, Oct 1, 2013 at 3:52 PM, Rene Kochen wrote: > Does that mean that cfhistograms scans all Statistics.db files in order to > populate the "Row Size" and "Column Count" values? On startup, yes. After that, it should be updated as new SSTables are created. --

Re: nodetool cfhistograms refresh

2013-10-01 Thread Rene Kochen
Thanks! Does that mean that cfhistograms scans all Statistics.db files in order to populate the "Row Size" and "Column Count" values? 2013/10/1 Tyler Hobbs > > On Tue, Oct 1, 2013 at 2:34 PM, Rene Kochen > wrote: > >> However, "Row Size" a

Re: nodetool cfhistograms refresh

2013-10-01 Thread Tyler Hobbs
On Tue, Oct 1, 2013 at 2:34 PM, Rene Kochen wrote: > However, "Row Size" and "Column Count" keep the values. When are they > re-evaluated? They are re-evaluated during compaction. -- Tyler Hobbs DataStax

Re: nodetool cfhistograms refresh

2013-10-01 Thread Rene Kochen
If I look at Read Latency I see indeed that they are reset during two runs of cfhistograms. However, "Row Size" and "Column Count" keep the values. When are they re-evaluated? Thanks! Rene 2013/10/1 Richard Low > On 1 October 2013 16:21, Rene Kochen wrote: > >

Re: nodetool cfhistograms refresh

2013-10-01 Thread Richard Low
On 1 October 2013 16:21, Rene Kochen wrote: > Quick question. > > I am using Cassandra 1.0.11 > > When is nodetool cfhistograms output reset? I know that data is collected > during read requests. But I am wondering if it is data since the beginning > (start of Cassand

nodetool cfhistograms refresh

2013-10-01 Thread Rene Kochen
Quick question. I am using Cassandra 1.0.11 When is nodetool cfhistograms output reset? I know that data is collected during read requests. But I am wondering if it is data since the beginning (start of Cassandra) or if it is reset periodically? Thanks! Rene

Re: Row size in cfstats vs cfhistograms

2013-09-20 Thread Rene Kochen
Nice! Thats explains it. 2013/9/19 Robert Coli > On Thu, Sep 19, 2013 at 3:08 AM, Rene Kochen wrote: > >> And how does cfstats track the maximum size? What does "Compacted" mean >> in "Compacted row maximum size". >> > > That maximum size is "the largest row that I have encountered in the > cou

Re: Row size in cfstats vs cfhistograms

2013-09-19 Thread Robert Coli
On Thu, Sep 19, 2013 at 3:08 AM, Rene Kochen wrote: > And how does cfstats track the maximum size? What does "Compacted" mean in > "Compacted row maximum size". > That maximum size is "the largest row that I have encountered in the course of compaction, since I started." Hence "compacted," to tr

Re: Row size in cfstats vs cfhistograms

2013-09-19 Thread Rene Kochen
olumn family, I see a "Compacted row >> maximum size" of 43388628 >> >> However, when I do a cfhistograms I do not see such a big row in the Row >> Size column. The biggest row there is 126934. >> >> Can someone explain this? >> > > The 

Re: Row size in cfstats vs cfhistograms

2013-09-19 Thread Rene Kochen
And how does cfstats track the maximum size? What does "Compacted" mean in "Compacted row maximum size". Thanks again! Rene 2013/9/19 Michał Michalski > I believe the reason is that cfhistograms tells you about the sizes of the > rows returned by given node in a re

Re: Row size in cfstats vs cfhistograms

2013-09-19 Thread Richard Low
On 19 September 2013 10:31, Rene Kochen wrote: I use Cassandra 1.0.11 > > If I do cfstats for a particular column family, I see a "Compacted row > maximum size" of 43388628 > > However, when I do a cfhistograms I do not see such a big row in the Row > Size column. The

Re: Row size in cfstats vs cfhistograms

2013-09-19 Thread Michał Michalski
I believe the reason is that cfhistograms tells you about the sizes of the rows returned by given node in a response to the read request, while cfstats tracks the largest row stored on given node. M. W dniu 19.09.2013 11:31, Rene Kochen pisze: Hi all, I use Cassandra 1.0.11 If I do cfstats

Row size in cfstats vs cfhistograms

2013-09-19 Thread Rene Kochen
Hi all, I use Cassandra 1.0.11 If I do cfstats for a particular column family, I see a "Compacted row maximum size" of 43388628 However, when I do a cfhistograms I do not see such a big row in the Row Size column. The biggest row there is 126934. Can someone explain this? Thanks! Rene

Re: cfhistograms

2013-03-27 Thread aaron morton
> I think we all go through this learning curve. Here is the answer I gave > last time this question was asked: +1 > What I don't understand hete is "Row Size" column. Why is it always 0? Is it zero all the way down? What does cfstats say about the compacted max row size? Cheers ---

Re: cfhistograms

2013-03-25 Thread Derek Williams
On Mon, Mar 25, 2013 at 10:36 AM, Brian Tarbox wrote: > I think we all go through this learning curve. Here is the answer I gave > last time this question was asked: > > The output of this command seems to make no sense unless I think of it as > 5 completely separate histograms that just happen t

Re: cfhistograms

2013-03-25 Thread Andrey Ilinykh
255 > 20 0 7 163 > 0 0 > 24 019 1369 > 0 0 > > > On Mon, Mar 25, 201

Re: cfhistograms

2013-03-25 Thread Jabbar Azam
0 255 > 20 0 7 163 > 0 0 > 24 019 1369 > 0 0 > > > On Mon, Mar 25, 201

Re: cfhistograms

2013-03-25 Thread Brian Tarbox
0 0 24 019 1369 0 0 On Mon, Mar 25, 2013 at 11:52 AM, Kanwar Sangha wrote: > Can someone explain how to read the cfhistograms o/p ? > > ** ** > > [root@db4

cfhistograms

2013-03-25 Thread Kanwar Sangha
Can someone explain how to read the cfhistograms o/p ? [root@db4 ~]# nodetool cfhistograms usertable data usertable/data histograms Offset SSTables Write Latency Read Latency Row Size Column Count 12857444 4051 0

Re: Is this how to read the output of nodetool cfhistograms?

2013-01-23 Thread Derek Williams
> *3229500* 2299 0 91 683749 2759 0 77 202722 > > > On Tue, Jan 22, 2013 at 12:11 PM, Wei Zhu wrote: > >> I agree that Cassandra cfhistograms is probably the most bizarre metrics >> I have ever come across although it's extremely useful. >> >> I believe th

Re: Is this how to read the output of nodetool cfhistograms?

2013-01-23 Thread Brian Tarbox
at 12:11 PM, Wei Zhu wrote: > I agree that Cassandra cfhistograms is probably the most bizarre metrics I > have ever come across although it's extremely useful. > > I believe the offset is actually the metrics it has tracked (x-axis on the > traditional histogram) and the nu

Re: Is this how to read the output of nodetool cfhistograms?

2013-01-22 Thread Wei Zhu
I agree that Cassandra cfhistograms is probably the most bizarre metrics I have ever come across although it's extremely useful.  I believe the offset is actually the metrics it has tracked (x-axis on the traditional histogram) and the number under each column is how many times that valu

Re: Is this how to read the output of nodetool cfhistograms?

2013-01-22 Thread Brian Tarbox
Indeed, but how many Cassandra users have the good fortune to stumble across that page? Just saying that the explanation of the very powerful nodetool commands should be more front and center. Brian On Tue, Jan 22, 2013 at 10:03 AM, Edward Capriolo wrote: > This was described in good detail he

Re: Is this how to read the output of nodetool cfhistograms?

2013-01-22 Thread Edward Capriolo
This was described in good detail here: http://thelastpickle.com/2011/04/28/Forces-of-Write-and-Read/ On Tue, Jan 22, 2013 at 9:41 AM, Brian Tarbox wrote: > Thank you! Since this is a very non-standard way to display data it > might be worth a better explanation in the various online documenta

Re: Is this how to read the output of nodetool cfhistograms?

2013-01-22 Thread Brian Tarbox
Thank you! Since this is a very non-standard way to display data it might be worth a better explanation in the various online documentation sets. Thank you again. Brian On Tue, Jan 22, 2013 at 9:19 AM, Mina Naguib wrote: > > > On 2013-01-22, at 8:59 AM, Brian Tarbox wrote: > > > The output

Re: Is this how to read the output of nodetool cfhistograms?

2013-01-22 Thread Mina Naguib
On 2013-01-22, at 8:59 AM, Brian Tarbox wrote: > The output of this command seems to make no sense unless I think of it as 5 > completely separate histograms that just happen to be displayed together. > > Using this example output should I read it as: my reads all took either 1 or > 2 sstabl

Is this how to read the output of nodetool cfhistograms?

2013-01-22 Thread Brian Tarbox
The output of this command seems to make no sense unless I think of it as 5 completely separate histograms that just happen to be displayed together. Using this example output should I read it as: my reads all took either 1 or 2 sstable. And separately, I had write latencies of 3,7,19. And separ

Re: help needed interpreting Read/Write latency in cfstats and cfhistograms output

2011-10-04 Thread Brandon Williams
On Mon, Oct 3, 2011 at 3:57 PM, Ramesh Natarajan wrote: > Thanks Aaron. The ms in the latency is it microseconds or milliseconds? > I ran the 2 commands at the same time. I was expecting the values to be in > the some what similar but from my output earlier ,  you can see the median > in read late

Re: help needed interpreting Read/Write latency in cfstats and cfhistograms output

2011-10-04 Thread aaron morton
Developer > @aaronmorton > http://www.thelastpickle.com > > On 4/10/2011, at 4:58 AM, Ramesh Natarajan wrote: > > > I am running a cassandra 0.8.6 cluster. I started a clean test setup and > > run my tests for a while. Later when I run cfstats and cfhistograms ( both

Re: help needed interpreting Read/Write latency in cfstats and cfhistograms output

2011-10-03 Thread Ramesh Natarajan
> > I am running a cassandra 0.8.6 cluster. I started a clean test setup and > run my tests for a while. Later when I run cfstats and cfhistograms ( both > ran at the same time ) > > the values for Read/Write latency doesn't match. As per cfstats the > latency for read

Re: help needed interpreting Read/Write latency in cfstats and cfhistograms output

2011-10-03 Thread aaron morton
andra Developer @aaronmorton http://www.thelastpickle.com On 4/10/2011, at 4:58 AM, Ramesh Natarajan wrote: > I am running a cassandra 0.8.6 cluster. I started a clean test setup and run > my tests for a while. Later when I run cfstats and cfhistograms ( both ran at > the same time ) > the values f

help needed interpreting Read/Write latency in cfstats and cfhistograms output

2011-10-03 Thread Ramesh Natarajan
I am running a cassandra 0.8.6 cluster. I started a clean test setup and run my tests for a while. Later when I run cfstats and cfhistograms ( both ran at the same time ) the values for Read/Write latency doesn't match. As per cfstats the latency for read and write are 5.086 and 0.0

Re: Interpreting the output of cfhistograms

2011-07-25 Thread Maki Watanabe
ns, Offset represents micro seconds. 3711340 read operations completed in 2 ms. Most of your row is between 925 ~ 1331 bytes. Most of your row has 925 ~ 1331 columns. maki 2011/7/26 Aishwarya Venkataraman > > Hello, > > I need help understanding the output of cfhistograms option

Re: CFHistograms?

2011-05-08 Thread Subrahmanya Harve
; > > Josep M. > > > > On Fri, May 6, 2011 at 9:09 AM, Jonathan Ellis > wrote: > >> > >> Those are updated at compaction time. > >> > >> On Thu, May 5, 2011 at 11:38 PM, Xaero S wrote: > >> > > >>

Re: CFHistograms?

2011-05-08 Thread Jonathan Ellis
PM, Xaero S wrote: >> > >> > Can someone point me to a document that explains how to interpret >> > CFHistograms output? i went through >> > >> > http://narendrasharma.blogspot.com/2011/04/cassandra-07x-understanding-output-of.html >> >

Re: CFHistograms?

2011-05-07 Thread Josep Blanquer
at 9:09 AM, Jonathan Ellis wrote: > Those are updated at compaction time. > > On Thu, May 5, 2011 at 11:38 PM, Xaero S wrote: > > > > Can someone point me to a document that explains how to interpret > > CFHistograms output? i went through > > > http:/

Re: CFHistograms?

2011-05-06 Thread Jonathan Ellis
Those are updated at compaction time. On Thu, May 5, 2011 at 11:38 PM, Xaero S wrote: > > Can someone point me to a document that explains how to interpret > CFHistograms output? i went through > http://narendrasharma.blogspot.com/2011/04/cassandra-07x-understanding-output-of.html

CFHistograms?

2011-05-05 Thread Xaero S
Can someone point me to a document that explains how to interpret CFHistograms output? i went through http://narendrasharma.blogspot.com/2011/04/cassandra-07x-understanding-output-of.htmlwhich is a good beginning, but was wondering if there was anything more detailed. For e.g when i run