[
https://issues.apache.org/jira/browse/CASSANDRA-3511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13170811#comment-13170811
]
Radim Kolar commented on CASSANDRA-3511:
----------------------------------------
I currently have key cache saving problem again on all nodes in this Super CF.
I removed saved cache for this CF and restarted nodes, but it didnt helped at
this time.
Column Family: resultcache
SSTable count: 14
Space used (live): 6344039402
Space used (total): 6344039402
Number of Keys (estimate): 826540
Memtable Columns Count: 25420
Memtable Data Size: 26342659
Memtable Switch Count: 19
Read Count: 19899
Read Latency: 22.298 ms.
Write Count: 48841
Write Latency: 0.309 ms.
Pending Tasks: 0
Bloom Filter False Postives: 31
Bloom Filter False Ratio: 0.00161
Bloom Filter Space Used: 2348824
Key cache capacity: 200000
Key cache size: 19505
Key cache hit rate: 0.07171145685997171
Row cache capacity: 600
Row cache size: 600
Row cache hit rate: 0.21192019699482387
Compacted row minimum size: 51
Compacted row maximum size: 1131752
Compacted row mean size: 7542
create column family resultcache
with column_type = 'Super'
and comparator = 'LongType'
and subcomparator = 'AsciiType'
and default_validation_class = 'BytesType'
and key_validation_class = 'UTF8Type'
and rows_cached = 600.0
and row_cache_save_period = 0
and row_cache_keys_to_save = 2147483647
and keys_cached = 200000.0
and key_cache_save_period = 14400
and read_repair_chance = 1.0
and gc_grace = 864000
and min_compaction_threshold = 5
and max_compaction_threshold = 10
and replicate_on_write = false
and row_cache_provider = 'ConcurrentLinkedHashCacheProvider'
and compaction_strategy =
'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
and column_metadata = [
{column_name : 'crc32',
validation_class : LongType},
{column_name : 'id',
validation_class : LongType},
{column_name : 'name',
validation_class : AsciiType},
{column_name : 'size',
validation_class : LongType}];
> Supercolumn key caches are not saved
> ------------------------------------
>
> Key: CASSANDRA-3511
> URL: https://issues.apache.org/jira/browse/CASSANDRA-3511
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Affects Versions: 1.0.2, 1.0.3
> Reporter: Radim Kolar
> Priority: Minor
> Labels: supercolumns
> Attachments: failed-to-save-after-load-KeyCache,
> rapidshare-resultcache-KeyCache
>
>
> cache saving seems to be broken in 1.0.2 and 1.0.3 i have 2 CF in keyspace
> with enabled cache saving and only one gets its key cache saved. It worked
> perfectly in 0.8, both were saved.
> This one works:
> create column family query2
> with column_type = 'Standard'
> and comparator = 'AsciiType'
> and default_validation_class = 'BytesType'
> and key_validation_class = 'UTF8Type'
> and rows_cached = 500.0
> and row_cache_save_period = 0
> and row_cache_keys_to_save = 2147483647
> and keys_cached = 200000.0
> and key_cache_save_period = 14400
> and read_repair_chance = 1.0
> and gc_grace = 864000
> and min_compaction_threshold = 5
> and max_compaction_threshold = 10
> and replicate_on_write = false
> and row_cache_provider = 'ConcurrentLinkedHashCacheProvider'
> and compaction_strategy =
> 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
> This does not
> create column family dkb13
> with column_type = 'Super'
> and comparator = 'LongType'
> and subcomparator = 'AsciiType'
> and default_validation_class = 'BytesType'
> and key_validation_class = 'UTF8Type'
> and rows_cached = 600.0
> and row_cache_save_period = 0
> and row_cache_keys_to_save = 2147483647
> and keys_cached = 200000.0
> and key_cache_save_period = 14400
> and read_repair_chance = 1.0
> and gc_grace = 864000
> and min_compaction_threshold = 5
> and max_compaction_threshold = 10
> and replicate_on_write = false
> and row_cache_provider = 'ConcurrentLinkedHashCacheProvider'
> and compaction_strategy =
> 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
> in second test system i created these 2 column families and none of them got
> single cache key saved. Both have save period 30 seoonds - their cache should
> save often. Its not that standard column family works while super does not.
> create column family test1
> with column_type = 'Standard'
> and comparator = 'BytesType'
> and default_validation_class = 'BytesType'
> and key_validation_class = 'BytesType'
> and rows_cached = 0.0
> and row_cache_save_period = 0
> and row_cache_keys_to_save = 2147483647
> and keys_cached = 200000.0
> and key_cache_save_period = 30
> and read_repair_chance = 1.0
> and gc_grace = 864000
> and min_compaction_threshold = 4
> and max_compaction_threshold = 32
> and replicate_on_write = true
> and row_cache_provider = 'SerializingCacheProvider'
> and compaction_strategy =
> 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy';
> create column family test2
> with column_type = 'Standard'
> and comparator = 'BytesType'
> and default_validation_class = 'BytesType'
> and key_validation_class = 'BytesType'
> and rows_cached = 0.0
> and row_cache_save_period = 0
> and row_cache_keys_to_save = 2147483647
> and keys_cached = 200000.0
> and key_cache_save_period = 30
> and read_repair_chance = 1.0
> and gc_grace = 864000
> and min_compaction_threshold = 4
> and max_compaction_threshold = 32
> and replicate_on_write = true
> and row_cache_provider = 'SerializingCacheProvider'
> and compaction_strategy =
> 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy';
> If this is done on purpose for example cassandra 1.0 is doing some heuristic
> decision if cache should be saved or not then it should be removed. Saving
> cache is fast.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
