Re: row caching for frequently updated column

2014-05-14 Thread Chris Burroughs
You are close. On 04/30/2014 12:41 AM, Jimmy Lin wrote: thanks all for the pointers. let' me see if I can put the sequences of event together 1.2 people mis-understand/mis-use row cache, that cassandra cached the entire row of data even if you are only looking for small subset of the row

Re: row caching for frequently updated column

2014-04-29 Thread Jimmy Lin
thanks all for the pointers. let' me see if I can put the sequences of event together 1.2 people mis-understand/mis-use row cache, that cassandra cached the entire row of data even if you are only looking for small subset of the row data. e.g select single_column from a_wide_row_table will r

Re: row caching for frequently updated column

2014-04-29 Thread Robert Coli
On Tue, Apr 29, 2014 at 1:53 PM, Brian Lam wrote: > Are these issues 'resolved' only in 2.0 or later release? > > What about 1.2 version? > As I understand it : 1.2 version has the on-heap row cache and off-heap row cache. It does not have the new "partition" cache. 2.0 version has only the off

Re: row caching for frequently updated column

2014-04-29 Thread Brian Lam
Are these issues 'resolved' only in 2.0 or later release? What about 1.2 version? On Apr 29, 2014, at 9:40 AM, Robert Coli wrote: On Tue, Apr 29, 2014 at 9:30 AM, Jimmy Lin wrote: > if Cassandra invalidate the row cache upon a single column update to that > row, that seems very inefficient

Re: row caching for frequently updated column

2014-04-29 Thread Robert Coli
On Tue, Apr 29, 2014 at 9:30 AM, Jimmy Lin wrote: > if Cassandra invalidate the row cache upon a single column update to that > row, that seems very inefficient. > https://issues.apache.org/jira/browse/CASSANDRA-5348?focusedCommentId=13794634&page=com.atlassian.jira.plugin.system.issuetabpanels

Re: row caching for frequently updated column

2014-04-29 Thread Nate McCall
> > > if Cassandra invalidate the row cache upon a single column update to that > row, that seems very inefficient. > > > Yes. For the most recent direction, take a look at: https://issues.apache.org/jira/browse/CASSANDRA-5357 -- - Nate McCall Austin, TX @zznate Co-Founder &

Re: row caching for frequently updated column

2014-04-29 Thread Jimmy Lin
hi, >>> writing a new value to a row will invalidate the row cache for that value do you mean the entire row will be invalidate ? or just the column it was being updated ? I was reading through http://planetcassandra.org/blog/post/cassandra-11-tuning-for-frequent-column-updates/ that seems to indi

Re: row caching for frequently updated column

2014-04-29 Thread Jonathan Lacefield
Hello, Iirc writing a new value to a row will invalidate the row cache for that value. Row cache is only populated after a read operation. http://www.datastax.com/documentation/cassandra/2.0/cassandra/operations/ops_configuring_caches_c.html?scroll=concept_ds_n35_nnr_ck Cassandra provides t

row caching for frequently updated column

2014-04-28 Thread Jimmy Lin
I am wondering if there is any negative impact on Cassandra write operation, if I turn on row caching for a table that has mostly 'static columns' but few frequently write columns (like timestamp). The application will frequently write to a few columns, and the application will also frequently que