You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by rohit reddy <ro...@gmail.com> on 2012/09/18 20:15:11 UTC
Row caches
Hi,
Is it possible to enable row cache per column family after the column
family is created.
*nodetool setcachecapacity* does not take the column family as input.
Thanks
Rohit
Re: Row caches
Posted by Tyler Hobbs <ty...@datastax.com>.
The cache metrics for Cassandra 1.1 are currently broken in OpsCenter, but
it's something we should be able to fix soon. You can also use nodetool
cfstats to check the cache hit rates.
On Fri, Sep 21, 2012 at 5:34 AM, rohit reddy <ro...@gmail.com>wrote:
> Hi,
>
> I have enabled the row caches by the using
> nodetool setcachecapacity <keyspace> <cfname> <keycachecapacity>
> <rowcachecapacity>.
>
> But when i look at the cfstats.. i'm not getting any cache stats like
>
> Row cache capacity:
> Row cache size:
>
> These properties are not reflected nor i'm getting any cache hit rates in OPS center.
>
> Do i need to restart the server or am i missing anything?
>
> Thanks
> Rohit
>
> On Fri, Sep 21, 2012 at 11:29 AM, rohit reddy <ro...@gmail.com>wrote:
>
>> Got it. Thanks for the replies
>>
>>
>> On Fri, Sep 21, 2012 at 6:30 AM, aaron morton <aa...@thelastpickle.com>wrote:
>>
>>> Set the caching attribute for the CF. It defaults to keys_only, other
>>> values are both or rows_only.
>>>
>>> See http://www.datastax.com/dev/blog/caching-in-cassandra-1-1
>>>
>>> Cheers
>>>
>>> -----------------
>>> Aaron Morton
>>> Freelance Developer
>>> @aaronmorton
>>> http://www.thelastpickle.com
>>>
>>> On 19/09/2012, at 1:34 PM, Jason Wee <pe...@gmail.com> wrote:
>>>
>>> which version is that? in version, 1.1.2 , nodetool does take the column
>>> family.
>>>
>>> setcachecapacity <keyspace> <cfname> <keycachecapacity>
>>> <rowcachecapacity> - Set the key and row cache capacities of a given column
>>> family
>>>
>>> On Wed, Sep 19, 2012 at 2:15 AM, rohit reddy <rohit.kommareddy@gmail.com
>>> > wrote:
>>>
>>>> Hi,
>>>>
>>>> Is it possible to enable row cache per column family after the column
>>>> family is created.
>>>>
>>>> *nodetool setcachecapacity* does not take the column family as input.
>>>>
>>>> Thanks
>>>> Rohit
>>>>
>>>
>>>
>>>
>>
>
--
Tyler Hobbs
DataStax <http://datastax.com/>
Re: Row caches
Posted by rohit reddy <ro...@gmail.com>.
Hi,
I have enabled the row caches by the using
nodetool setcachecapacity <keyspace> <cfname> <keycachecapacity>
<rowcachecapacity>.
But when i look at the cfstats.. i'm not getting any cache stats like
Row cache capacity:
Row cache size:
These properties are not reflected nor i'm getting any cache hit rates
in OPS center.
Do i need to restart the server or am i missing anything?
Thanks
Rohit
On Fri, Sep 21, 2012 at 11:29 AM, rohit reddy <ro...@gmail.com>wrote:
> Got it. Thanks for the replies
>
>
> On Fri, Sep 21, 2012 at 6:30 AM, aaron morton <aa...@thelastpickle.com>wrote:
>
>> Set the caching attribute for the CF. It defaults to keys_only, other
>> values are both or rows_only.
>>
>> See http://www.datastax.com/dev/blog/caching-in-cassandra-1-1
>>
>> Cheers
>>
>> -----------------
>> Aaron Morton
>> Freelance Developer
>> @aaronmorton
>> http://www.thelastpickle.com
>>
>> On 19/09/2012, at 1:34 PM, Jason Wee <pe...@gmail.com> wrote:
>>
>> which version is that? in version, 1.1.2 , nodetool does take the column
>> family.
>>
>> setcachecapacity <keyspace> <cfname> <keycachecapacity>
>> <rowcachecapacity> - Set the key and row cache capacities of a given column
>> family
>>
>> On Wed, Sep 19, 2012 at 2:15 AM, rohit reddy <ro...@gmail.com>wrote:
>>
>>> Hi,
>>>
>>> Is it possible to enable row cache per column family after the column
>>> family is created.
>>>
>>> *nodetool setcachecapacity* does not take the column family as input.
>>>
>>> Thanks
>>> Rohit
>>>
>>
>>
>>
>
Re: Row caches
Posted by rohit reddy <ro...@gmail.com>.
Got it. Thanks for the replies
On Fri, Sep 21, 2012 at 6:30 AM, aaron morton <aa...@thelastpickle.com>wrote:
> Set the caching attribute for the CF. It defaults to keys_only, other
> values are both or rows_only.
>
> See http://www.datastax.com/dev/blog/caching-in-cassandra-1-1
>
> Cheers
>
> -----------------
> Aaron Morton
> Freelance Developer
> @aaronmorton
> http://www.thelastpickle.com
>
> On 19/09/2012, at 1:34 PM, Jason Wee <pe...@gmail.com> wrote:
>
> which version is that? in version, 1.1.2 , nodetool does take the column
> family.
>
> setcachecapacity <keyspace> <cfname> <keycachecapacity> <rowcachecapacity>
> - Set the key and row cache capacities of a given column family
>
> On Wed, Sep 19, 2012 at 2:15 AM, rohit reddy <ro...@gmail.com>wrote:
>
>> Hi,
>>
>> Is it possible to enable row cache per column family after the column
>> family is created.
>>
>> *nodetool setcachecapacity* does not take the column family as input.
>>
>> Thanks
>> Rohit
>>
>
>
>
Re: Row caches
Posted by aaron morton <aa...@thelastpickle.com>.
Set the caching attribute for the CF. It defaults to keys_only, other values are both or rows_only.
See http://www.datastax.com/dev/blog/caching-in-cassandra-1-1
Cheers
-----------------
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 19/09/2012, at 1:34 PM, Jason Wee <pe...@gmail.com> wrote:
> which version is that? in version, 1.1.2 , nodetool does take the column family.
>
> setcachecapacity <keyspace> <cfname> <keycachecapacity> <rowcachecapacity> - Set the key and row cache capacities of a given column family
>
> On Wed, Sep 19, 2012 at 2:15 AM, rohit reddy <ro...@gmail.com> wrote:
> Hi,
>
> Is it possible to enable row cache per column family after the column family is created.
>
> nodetool setcachecapacity does not take the column family as input.
>
> Thanks
> Rohit
>
Re: Row caches
Posted by Jason Wee <pe...@gmail.com>.
which version is that? in version, 1.1.2 , nodetool does take the column
family.
setcachecapacity <keyspace> <cfname> <keycachecapacity> <rowcachecapacity>
- Set the key and row cache capacities of a given column family
On Wed, Sep 19, 2012 at 2:15 AM, rohit reddy <ro...@gmail.com>wrote:
> Hi,
>
> Is it possible to enable row cache per column family after the column
> family is created.
>
> *nodetool setcachecapacity* does not take the column family as input.
>
> Thanks
> Rohit
>