[prev in list] [next in list] [prev in thread] [next in thread]
List: cassandra-user
Subject: Re: Not seeing keyspace in nodetool compactionhistory
From: Ali Akhtar <ali.rac200 () gmail ! com>
Date: 2015-03-25 20:58:13
Message-ID: CAKiMtbeuCXfBF8o71bHdvvLaNdR9j6RMo878=sVathBLY661-g () mail ! gmail ! com
[Download RAW message or body]
Only one, because I ran nodetool compact on the db earlier.
Actually, does nodetool compactionhistory only show the compactions within
the last 24 hours or so? Because I had run nodetool compact about 24 hrs
before i checked compactionhistory, so perhaps the earlier compactions were
just not shown.
On Thu, Mar 26, 2015 at 1:04 AM, Tyler Hobbs <tyler@datastax.com> wrote:
> How many sstables (*-Data.db files) do each of your two tables have?
>
> On Wed, Mar 25, 2015 at 2:54 PM, Ali Akhtar <ali.rac200@gmail.com> wrote:
>
>> I also just inserted, didn't do any updates.
>>
>> On Thu, Mar 26, 2015 at 12:54 AM, Ali Akhtar <ali.rac200@gmail.com>
>> wrote:
>>
>>> I'm on 2.0.12
>>>
>>> I'm not sure if that's issue, since the size isn't growing. The size is
>>> about what i'd expect.
>>>
>>> On Thu, Mar 26, 2015 at 12:44 AM, Tyler Hobbs <tyler@datastax.com>
>>> wrote:
>>>
>>>> What version of Cassandra are you using? Since it sounds like you
>>>> aren't doing any reads, it could be
>>>> https://issues.apache.org/jira/browse/CASSANDRA-8635.
>>>>
>>>> On Wed, Mar 18, 2015 at 9:37 AM, Ali Akhtar <ali.rac200@gmail.com>
>>>> wrote:
>>>>
>>>>> When I run nodetool compactionhistory , I'm only seeing the system
>>>>> keyspace, and OpsCenter keyspace in the compactions. I only see one mention
>>>>> of my own keyspace, but its only for the smallest table within that
>>>>> keyspace (containing only about 1k rows). My two other tables, containing
>>>>> 1.1m and 100k rows respectively, weren't to be seen.
>>>>>
>>>>> Any reason why that is?
>>>>>
>>>>> I did fill up the data in those two tables within the span of about 4
>>>>> hours (I ran a script to migrate existing data from legacy rdbms dbs).
>>>>> Could that have something to do with it?
>>>>>
>>>>> I'm using SizeTieredCompactionStrategy for all tables.
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Tyler Hobbs
>>>> DataStax <http://datastax.com/>
>>>>
>>>
>>>
>>
>
>
> --
> Tyler Hobbs
> DataStax <http://datastax.com/>
>
[Attachment #3 (text/html)]
<div dir="ltr">Only one, because I ran nodetool compact on the db \
earlier.<div><br></div><div>Actually, does nodetool compactionhistory only show the \
compactions within the last 24 hours or so? Because I had run nodetool compact about \
24 hrs before i checked compactionhistory, so perhaps the earlier compactions were \
just not shown.</div></div><div class="gmail_extra"><br><div class="gmail_quote">On \
Thu, Mar 26, 2015 at 1:04 AM, Tyler Hobbs <span dir="ltr"><<a \
href="mailto:tyler@datastax.com" target="_blank">tyler@datastax.com</a>></span> \
wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex"><div dir="ltr">How many sstables (*-Data.db files) do \
each of your two tables have?<br></div><div class="gmail_extra"><br><div \
class="gmail_quote">On Wed, Mar 25, 2015 at 2:54 PM, Ali Akhtar <span \
dir="ltr"><<a href="mailto:ali.rac200@gmail.com" \
target="_blank">ali.rac200@gmail.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr">I also just inserted, didn't do any \
updates.</div><div><div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, \
Mar 26, 2015 at 12:54 AM, Ali Akhtar <span dir="ltr"><<a \
href="mailto:ali.rac200@gmail.com" \
target="_blank">ali.rac200@gmail.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr">I'm on 2.0.12<div><br></div><div>I'm \
not sure if that's issue, since the size isn't growing. The size is about \
what i'd expect.</div></div><div><div><div class="gmail_extra"><br><div \
class="gmail_quote">On Thu, Mar 26, 2015 at 12:44 AM, Tyler Hobbs <span \
dir="ltr"><<a href="mailto:tyler@datastax.com" \
target="_blank">tyler@datastax.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr">What version of Cassandra are you using? \
Since it sounds like you aren't doing any reads, it could be <a \
href="https://issues.apache.org/jira/browse/CASSANDRA-8635" \
target="_blank">https://issues.apache.org/jira/browse/CASSANDRA-8635</a>.<br></div><div \
class="gmail_extra"><div><div><br><div class="gmail_quote">On Wed, Mar 18, 2015 at \
9:37 AM, Ali Akhtar <span dir="ltr"><<a href="mailto:ali.rac200@gmail.com" \
target="_blank">ali.rac200@gmail.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr">When I run nodetool compactionhistory , \
I'm only seeing the system keyspace, and OpsCenter keyspace in the compactions. I \
only see one mention of my own keyspace, but its only for the smallest table within \
that keyspace (containing only about 1k rows). My two other tables, containing 1.1m \
and 100k rows respectively, weren't to be seen.<div><br></div><div>Any reason why \
that is?</div><div><br></div><div>I did fill up the data in those two tables within \
the span of about 4 hours (I ran a script to migrate existing data from legacy rdbms \
dbs). Could that have something to do with it?</div><div><br></div><div>I'm using \
SizeTieredCompactionStrategy for all tables.</div></div> </blockquote></div><br><br \
clear="all"><span class="HOEnZb"><font \
color="#888888"><br></font></span></div></div><span class="HOEnZb"><font \
color="#888888"><span><font color="#888888">-- <br><div><font color="#888888">Tyler \
Hobbs<span></span><br> <a href="http://datastax.com/" \
target="_blank">DataStax</a><br></font></div> </font></span></font></span></div><span \
class="HOEnZb"><font color="#888888"> </font></span></blockquote></div><span \
class="HOEnZb"><font color="#888888"><br></font></span></div><span \
class="HOEnZb"><font color="#888888"> \
</font></span></div></div></blockquote></div><span class="HOEnZb"><font \
color="#888888"><br></font></span></div><span class="HOEnZb"><font color="#888888"> \
</font></span></div></div></blockquote></div><span class="HOEnZb"><font \
color="#888888"><br><br clear="all"><br>-- <br><div><font color="#888888">Tyler \
Hobbs<span></span><br> <a href="http://datastax.com/" \
target="_blank">DataStax</a><br></font></div> </font></span></div>
</blockquote></div><br></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic