Hi Ariel,
Thanks for replying.
Let me share the following FT.INFO output for our major index (DataCacheItemIndex):
Out for JAN-17:
[ “index_name”, “DataCacheItemIndex”, “index_options”, , “index_definition”, [ “key_type”, “HASH”, “prefixes”, [ “” ], “language_field”, “__language”, “default_score”, “1”, “score_field”, “__score”, “payload_field”, “__payload” ], “fields”, [ [ “DataCacheItem_SourcedKey”, “type”, “TEXT”, “WEIGHT”, “1” ], [ “DataCacheItem_DataVersion”, “type”, “NUMERIC” ], [ “DataCacheItem_ExpiryTimeInTicks”, “type”, “NUMERIC” ] ], “num_docs”, “63493”, “max_doc_id”, “83608”, “num_terms”, “11735”, “num_records”, “42730”, “inverted_sz_mb”, “0.37751007080078125”, “total_inverted_index_blocks”, “64546”, “offset_vectors_sz_mb”, “0.020109176635742188”, “doc_table_size_mb”, “427.868408203125”, “sortable_values_size_mb”, “0”, “key_table_size_mb”, “2.4975166320800781”, “records_per_doc_avg”, “0.67298758029937744”, “bytes_per_record_avg”, “9.2639360427856445”, “offsets_per_term_avg”, “0.49347063899040222”, “offset_bits_per_record_avg”, “8”, “hash_indexing_failures”, “0”, “indexing”, “0”, “percent_indexed”, “1”, “gc_stats”, [ “bytes_collected”, “156598”, “total_ms_run”, “1274”, “total_cycles”, “9”, “average_cycle_time_ms”, “141.55555555555554”, “last_run_time_ms”, “178”, “gc_numeric_trees_missed”, “0”, “gc_blocks_denied”, “36” ], “cursor_stats”, [ “global_idle”, 0, “global_total”, 0, “index_capacity”, 128, “index_total”, 0 ] ]
Output for JAN-18:
[ “index_name”, “DataCacheItemIndex”, “index_options”, , “index_definition”, [ “key_type”, “HASH”, “prefixes”, [ “” ], “language_field”, “__language”, “default_score”, “1”, “score_field”, “__score”, “payload_field”, “__payload” ], “fields”, [ [ “DataCacheItem_SourcedKey”, “type”, “TEXT”, “WEIGHT”, “1” ], [ “DataCacheItem_DataVersion”, “type”, “NUMERIC” ], [ “DataCacheItem_ExpiryTimeInTicks”, “type”, “NUMERIC” ] ], “num_docs”, “471328”, “max_doc_id”, “61385104”, “num_terms”, “110288”, “num_records”, “203689”, “inverted_sz_mb”, “15.912251472473145”, “total_inverted_index_blocks”, “1094435”, “offset_vectors_sz_mb”, “25.307598114013672”, “doc_table_size_mb”, “251475.265625”, “sortable_values_size_mb”, “0”, “key_table_size_mb”, “17.214992523193359”, “records_per_doc_avg”, “0.43215978145599365”, “bytes_per_record_avg”, “81.91510009765625”, “offsets_per_term_avg”, “130.28166198730469”, “offset_bits_per_record_avg”, “8”, “hash_indexing_failures”, “0”, “indexing”, “0”, “percent_indexed”, “1”, “gc_stats”, [ “bytes_collected”, “678119471”, “total_ms_run”, “796671”, “total_cycles”, “1854”, “average_cycle_time_ms”, “429.70388349514565”, “last_run_time_ms”, “479”, “gc_numeric_trees_missed”, “107”, “gc_blocks_denied”, “147980” ], “cursor_stats”, [ “global_idle”, 0, “global_total”, 0, “index_capacity”, 128, “index_total”, 0 ] ]
Output for JAN-19:
[ “index_name”, “DataCacheItemIndex”, “index_options”, , “index_definition”, [ “key_type”, “HASH”, “prefixes”, [ “” ], “language_field”, “__language”, “default_score”, “1”, “score_field”, “__score”, “payload_field”, “__payload” ], “fields”, [ [ “DataCacheItem_SourcedKey”, “type”, “TEXT”, “WEIGHT”, “1” ], [ “DataCacheItem_DataVersion”, “type”, “NUMERIC” ], [ “DataCacheItem_ExpiryTimeInTicks”, “type”, “NUMERIC” ] ], “num_docs”, “503564”, “max_doc_id”, “239324892”, “num_terms”, “202415”, “num_records”, “251137”, “inverted_sz_mb”, “96.928802490234375”, “total_inverted_index_blocks”, “2931850”, “offset_vectors_sz_mb”, “106.74593353271484”, “doc_table_size_mb”, “848671”, “sortable_values_size_mb”, “0”, “key_table_size_mb”, “18.325801849365234”, “records_per_doc_avg”, “0.49871912598609924”, “bytes_per_record_avg”, “404.708251953125”, “offsets_per_term_avg”, “445.6978759765625”, “offset_bits_per_record_avg”, “8”, “hash_indexing_failures”, “0”, “indexing”, “0”, “percent_indexed”, “1”, “gc_stats”, [ “bytes_collected”, “2629072389”, “total_ms_run”, “2700790”, “total_cycles”, “4555”, “average_cycle_time_ms”, “592.92864983534582”, “last_run_time_ms”, “573”, “gc_numeric_trees_missed”, “543”, “gc_blocks_denied”, “699433” ], “cursor_stats”, [ “global_idle”, 0, “global_total”, 0, “index_capacity”, 128, “index_total”, 0 ] ]
Can you please explain the meaning of the different GC stats (gc_blocks_denied, gc_numeric_trees_missed etc.)?
Thanks,
Itai