Hi Keith,
On 25/07/14 14:43, Keith Wright wrote:
Answers to your questions below but in the end I believe the root issue here is
that LCS is clearly not compacting away as it should resulting in reads across
many SSTables which as you noted is “fishy”. I’m considering filing a JIRA for
this, sound reasonable?
We are running OOTB JMV tuning (see below) and using the datastax client. When
we read from the table in question, we put a limit of 5000 to help reduce the
read volume but yes the standard scenario is: “select * from
global_user_event_skus_v2 where user_id = ? limit 5000”
does reducing the limit, eg to 500, help? I've had similar sounding problems
when many clients were doing wide row reads in parallel, with the reads
returning thousands of rows.
Ciao, Duncan.
