You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Abhinav Solan <ab...@gmail.com> on 2017/07/19 18:04:45 UTC
Nodetool tablehistograms
Hi Everyone,
Here is the result of my tablehistograms command on one of our tables.
Percentile SSTables Write Latency Read Latency Partition Size
Cell Count
(micros) (micros) (bytes)
50% 4.00 73.46 545.79 152321
8239
75% 10.00 88.15 2346.80 379022
20501
95% 10.00 152.32 4055.27 1358102
73457
98% 10.00 219.34 4866.32 1955666
88148
99% 10.00 315.85 5839.59 1955666
105778
Min 0.00 17.09 35.43 73
3
Max 10.00 36157.19 52066.35 2816159
152321
What does SSTables column represent here?
Does it mean how many SSTables the read is spanning to?
Thanks,
Abhinav
Re: Nodetool tablehistograms
Posted by Chris Lohfink <cl...@gmail.com>.
Its the number of sstables that may of been read from. This includes
sstables who had their bloom filters checked (which may hit disk). This
changes a bit in https://issues.apache.org/jira/browse/CASSANDRA-13120 to
be only the sstables that its actually reading from.
On Wed, Jul 19, 2017 at 11:04 AM, Abhinav Solan <ab...@gmail.com>
wrote:
> Hi Everyone,
>
> Here is the result of my tablehistograms command on one of our tables.
>
> Percentile SSTables Write Latency Read Latency Partition Size
> Cell Count
> (micros) (micros) (bytes)
> 50% 4.00 73.46 545.79 152321
> 8239
> 75% 10.00 88.15 2346.80 379022
> 20501
> 95% 10.00 152.32 4055.27 1358102
> 73457
> 98% 10.00 219.34 4866.32 1955666
> 88148
> 99% 10.00 315.85 5839.59 1955666
> 105778
> Min 0.00 17.09 35.43 73
> 3
> Max 10.00 36157.19 52066.35 2816159
> 152321
>
> What does SSTables column represent here?
> Does it mean how many SSTables the read is spanning to?
>
> Thanks,
> Abhinav
>