Re: Help on MMap of SSTables

2012-12-13 Thread Edward Capriolo
This issue has to be looked from a micro and macro level. On the microlevel
the best way is workload specific. On the macro level this mostly boils
down to data and memory size.

Companions are going to churn cache, this is unavoidable. Imho solid state
makes the micro optimization meanless in the big picture. Not that we
should not consider tweaking flags but just saying it is hard to believe
anything like that is a game change.

On Monday, December 10, 2012, Rob Coli rc...@palominodb.com wrote:
 On Thu, Dec 6, 2012 at 7:36 PM, aaron morton aa...@thelastpickle.com
wrote:
 So for memory mapped files, compaction can do a madvise SEQUENTIAL
instead
 of current DONTNEED flag after detecting appropriate OS versions. Will
this
 help?


 AFAIK Compaction does use memory mapped file access.

 The history :

 https://issues.apache.org/jira/browse/CASSANDRA-1470

 =Rob

 --
 =Robert Coli
 AIMGTALK - rc...@palominodb.com
 YAHOO - rcoli.palominob
 SKYPE - rcoli_palominodb



Re: Help on MMap of SSTables

2012-12-10 Thread Rob Coli
On Thu, Dec 6, 2012 at 7:36 PM, aaron morton aa...@thelastpickle.com wrote:
 So for memory mapped files, compaction can do a madvise SEQUENTIAL instead
 of current DONTNEED flag after detecting appropriate OS versions. Will this
 help?


 AFAIK Compaction does use memory mapped file access.

The history :

https://issues.apache.org/jira/browse/CASSANDRA-1470

=Rob

-- 
=Robert Coli
AIMGTALK - rc...@palominodb.com
YAHOO - rcoli.palominob
SKYPE - rcoli_palominodb


Re: Help on MMap of SSTables

2012-12-04 Thread aaron morton
 Will MMapping data files be detrimental for reads, in this case?
No. 

 In general, when should we opt for MMap data files and what are the factors 
 that need special attention when enabling the same?
mmapping is the default, so I would say use it until you have a reason not to. 

mmapping will map the entire file, but pages of data are read into memory on 
demand and purged when space is needed. 

Cheers

-
Aaron Morton
Freelance Cassandra Developer
New Zealand

@aaronmorton
http://www.thelastpickle.com

On 4/12/2012, at 11:59 PM, Ravikumar Govindarajan 
ravikumar.govindara...@gmail.com wrote:

 Our current SSTable sizes are far greater than RAM. {150 Gigs of data, 32GB 
 RAM}. Currently we run with mlockall and mmap_index_only options and don't 
 experience swapping at all.
 
 We use wide rows and size-tiered-compaction, so a given key will definitely 
 be spread across multiple sstables. Will MMapping data files be detrimental 
 for reads, in this case?
 
 In general, when should we opt for MMap data files and what are the factors 
 that need special attention when enabling the same?
 
 --
 Ravi