You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Edson Marquezani Filho <ed...@gmail.com> on 2015/01/20 14:51:29 UTC
How to know disk utilization by each row on a node
Hello, everybody.
Does anyone know a way to list, for an arbitrary column family, all
the rows owned (including replicas) by a given node and the data size
(real size or disk occupation) of each one of them on that node?
I would like to do that because I have data on one of my nodes growing
faster than the others, although rows (and replicas) seem evenly
distributed across the cluster. So, I would like to verify if I have
some specific rows growing too much.
Thank you.
Re: How to know disk utilization by each row on a node
Posted by nitin padalia <pa...@gmail.com>.
Did you use cfstats and cfhistograms?
On Jan 22, 2015 12:37 AM, "Edson Marquezani Filho" <
edsonmarquezani@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 sequential
> and sorted, a feature like that doesn't seem something very hard to
> implement, anyway. Wouldn't it be possible to calculate it only from
> index files, without even needing to read the actual table?
>
> On Tue, Jan 20, 2015 at 5:05 PM, Jens Rantil <je...@tink.se> wrote:
> > Hi,
> >
> > Datastax comes with sstablekeys that does that. You could also use
> > sstable2json script to find keys.
> >
> > Cheers,
> > Jens
> >
> >
> >
> > On Tue, Jan 20, 2015 at 2:53 PM, Edson Marquezani Filho
> > <ed...@gmail.com> wrote:
> >>
> >> Hello, everybody.
> >>
> >> Does anyone know a way to list, for an arbitrary column family, all
> >> the rows owned (including replicas) by a given node and the data size
> >> (real size or disk occupation) of each one of them on that node?
> >>
> >> I would like to do that because I have data on one of my nodes growing
> >> faster than the others, although rows (and replicas) seem evenly
> >> distributed across the cluster. So, I would like to verify if I have
> >> some specific rows growing too much.
> >>
> >> Thank you.
> >
> >
>
Re: How to know disk utilization by each row on a node
Posted by Edson Marquezani Filho <ed...@gmail.com>.
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 sequential
and sorted, a feature like that doesn't seem something very hard to
implement, anyway. Wouldn't it be possible to calculate it only from
index files, without even needing to read the actual table?
On Tue, Jan 20, 2015 at 5:05 PM, Jens Rantil <je...@tink.se> wrote:
> Hi,
>
> Datastax comes with sstablekeys that does that. You could also use
> sstable2json script to find keys.
>
> Cheers,
> Jens
>
>
>
> On Tue, Jan 20, 2015 at 2:53 PM, Edson Marquezani Filho
> <ed...@gmail.com> wrote:
>>
>> Hello, everybody.
>>
>> Does anyone know a way to list, for an arbitrary column family, all
>> the rows owned (including replicas) by a given node and the data size
>> (real size or disk occupation) of each one of them on that node?
>>
>> I would like to do that because I have data on one of my nodes growing
>> faster than the others, although rows (and replicas) seem evenly
>> distributed across the cluster. So, I would like to verify if I have
>> some specific rows growing too much.
>>
>> Thank you.
>
>
Re: How to know disk utilization by each row on a node
Posted by Jens Rantil <je...@tink.se>.
Hi,
Datastax comes with sstablekeys that does that. You could also use sstable2json script to find keys.
Cheers,
Jens
On Tue, Jan 20, 2015 at 2:53 PM, Edson Marquezani Filho
<ed...@gmail.com> wrote:
> Hello, everybody.
> Does anyone know a way to list, for an arbitrary column family, all
> the rows owned (including replicas) by a given node and the data size
> (real size or disk occupation) of each one of them on that node?
> I would like to do that because I have data on one of my nodes growing
> faster than the others, although rows (and replicas) seem evenly
> distributed across the cluster. So, I would like to verify if I have
> some specific rows growing too much.
> Thank you.