Re: SSTable Index and Metadata - are they cached in RAM?

2012-08-17 Thread aaron morton
> 2) Rad from disk all row keys, in order to find one (binary search) No. At startup cassandra samples the -index.db component every index_interval keys. At worst index_interval keys must be read from disk. > As I understand, in the worst case, we can have three disk seeks (2, 4, 6) > pro SSTa

Re: SSTable Index and Metadata - are they cached in RAM?

2012-08-17 Thread Maciej Miklas
Great articles, I did not find those before ! * SSTable Index - yes I mean column Index. *I would like to understand, how many disk seeks might be required to find column in single SSTable. I am assuming positive bloom filter on row key. Now Cassandra needs to find out whenever given SSTable cont

Re: SSTable Index and Metadata - are they cached in RAM?

2012-08-16 Thread aaron morton
> What about SSTable index, Not sure what you are referring to there. Each row has a in a SStable has a bloom filter and may have an index of columns. This is not cached. See http://thelastpickle.com/2011/07/04/Cassandra-Query-Plans/ or http://www.slideshare.net/aaronmorton/cassandra-sf-2012-t

SSTable Index and Metadata - are they cached in RAM?

2012-08-16 Thread Maciej Miklas
Hi all, bloom filter for row keys is always in RAM. What about SSTable index, and Metadata? Is it cached by Cassandra, or it relays on memory mapped files? Thanks, Maciej