RocksDB for Tablet a4b137dc0c2e4277b64ce029b21d5333

Regular

[Version]
yugabyte_version=version 2.23.0.0 build 710 revision a31a4eba31527467192adc816e771ac09c28bb1a build_type RELEASE built at 30 Aug 2024 21:07:28 UTC

[DBOptions]
max_file_size_for_compaction=7192949369616
info_log_level=INFO_LEVEL
access_hint_on_compaction_start=NORMAL
write_thread_max_yield_usec=100
write_thread_slow_yield_usec=3
enable_write_thread_adaptive_yield=false
max_log_file_size=0
stats_dump_period_sec=600
max_manifest_file_size=18446744073709551615
bytes_per_sync=1048576
delayed_write_rate=2097152
WAL_ttl_seconds=0
allow_concurrent_memtable_write=false
paranoid_checks=true
writable_file_max_buffer_size=1048576
WAL_size_limit_MB=0
max_subcompactions=1
wal_dir=/root/yb01/data/yb-data/tserver/data/rocksdb/table-000033c300003000800000000000401d/tablet-a4b137dc0c2e4277b64ce029b21d5333
wal_bytes_per_sync=0
max_total_wal_size=0
db_write_buffer_size=0
keep_log_file_num=1000
table_cache_numshardbits=4
compaction_size_threshold_bytes=2147483648
max_file_opening_threads=1
initial_seqno=1125899906842624
recycle_log_file_num=0
num_reserved_small_compaction_threads=1
random_access_max_buffer_size=1048576
use_fsync=false
max_open_files=5000
skip_stats_update_on_db_open=false
max_background_compactions=2
error_if_exists=false
manifest_preallocation_size=65536
max_background_flushes=1
is_fd_close_on_exec=true
advise_random_on_open=true
create_missing_column_families=false
delete_obsolete_files_period_micros=21600000000
create_if_missing=true
disable_data_sync=false
log_file_time_to_roll=0
compaction_readahead_size=0
use_adaptive_mutex=false
enable_thread_tracking=false
disableDataSync=false
allow_fallocate=true
skip_log_error_on_recovery=false
allow_mmap_reads=false
fail_if_options_file_error=false
allow_os_buffer=true
wal_recovery_mode=kTolerateCorruptedTailRecords
db_log_dir=
new_table_reader_for_compaction_inputs=false
base_background_compactions=2
allow_mmap_writes=false

[CFOptions "default"]
compaction_style=kCompactionStyleUniversal
merge_operator=nullptr
compaction_filter=nullptr
num_levels=1
table_factory=BlockBasedTable
comparator=leveldb.BytewiseComparator
max_sequential_skip_in_iterations=8
soft_rate_limit=0
max_bytes_for_level_base=10485760
soft_pending_compaction_bytes_limit=0
memtable_prefix_bloom_probes=6
memtable_prefix_bloom_bits=0
memtable_prefix_bloom_huge_page_tlb_size=0
max_successive_merges=0
arena_block_size=65536
min_write_buffer_number_to_merge=1
target_file_size_multiplier=1
source_compaction_factor=1
compression_per_level=
max_bytes_for_level_multiplier=10
compaction_filter_factory=nullptr
max_write_buffer_number=100500
level0_stop_writes_trigger=2147483647
compression=kSnappyCompression
level0_file_num_compaction_trigger=5
purge_redundant_kvs_while_flush=true
max_write_buffer_number_to_maintain=0
memtable_factory=SkipListFactory
max_grandparent_overlap_factor=10
expanded_compaction_factor=25
hard_pending_compaction_bytes_limit=0
inplace_update_num_locks=10000
level0_slowdown_writes_trigger=2147483647
level_compaction_dynamic_level_bytes=false
filter_deletes=false
verify_checksums_in_compaction=true
min_partial_merge_operands=2
paranoid_file_checks=false
target_file_size_base=2097152
optimize_filters_for_hits=false
compaction_measure_io_stats=false
prefix_extractor=nullptr
bloom_locality=0
write_buffer_size=134217728
disable_auto_compactions=false
inplace_update_support=false
[TableOptions/BlockBasedTable "default"]
format_version=2
whole_key_filtering=true
index_block_size=32768
index_block_restart_interval=1
block_size_deviation=10
hash_index_allow_collision=true
filter_block_size=65536
min_keys_per_index_block=100
block_size=32768
block_restart_interval=16
skip_table_builder_flush=false
filter_policy=DocKeyV3Filter
no_block_cache=false
checksum=kCRC32c
cache_index_and_filter_blocks=true
index_type=kMultiLevelBinarySearch
flush_block_policy_factory=FlushBlockBySizePolicyFactory

Files

{ total_size: 39608888 base_size: 1739355 uncompressed_size: 80829522 name_id: 13 db_path: /root/yb01/data/yb-data/tserver/data/rocksdb/table-000033c300003000800000000000401d/tablet-a4b137dc0c2e4277b64ce029b21d5333 imported: 0 being_compacted: 0 column_family_name: default level: 0 smallest: { seqno: 1125899910442661 user_frontier: 0x0000068ab5d575c0 -> { op_id: 1.1630 hybrid_time: { physical: 1729184006604399 } history_cutoff: { cotables cutoff: <invalid>, primary cutoff: <invalid> } max_value_level_ttl_expiration_time: <invalid> primary_schema_version: <nullopt> cotable_schema_versions: [] global_filter: <invalid> cotables_filter: [] } } largest: { seqno: 1125899911842675 user_frontier: 0x0000068abcfdb8c0 -> { op_id: 1.1630 hybrid_time: { physical: 1729184006604595 } history_cutoff: { cotables cutoff: <invalid>, primary cutoff: <invalid> } max_value_level_ttl_expiration_time: <invalid> primary_schema_version: <nullopt> cotable_schema_versions: [] global_filter: <invalid> cotables_filter: [] } } }
{ total_size: 51525553 base_size: 2207826 uncompressed_size: 102859408 name_id: 12 db_path: /root/yb01/data/yb-data/tserver/data/rocksdb/table-000033c300003000800000000000401d/tablet-a4b137dc0c2e4277b64ce029b21d5333 imported: 0 being_compacted: 0 column_family_name: default level: 0 smallest: { seqno: 1125899908642643 user_frontier: 0x0000068ab5d57200 -> { op_id: 1.1630 hybrid_time: { physical: 1729184006604399 } history_cutoff: { cotables cutoff: <invalid>, primary cutoff: <invalid> } max_value_level_ttl_expiration_time: <invalid> primary_schema_version: <nullopt> cotable_schema_versions: [] global_filter: <invalid> cotables_filter: [] } } largest: { seqno: 1125899910442660 user_frontier: 0x0000068ab5d56780 -> { op_id: 1.1630 hybrid_time: { physical: 1729184006604595 } history_cutoff: { cotables cutoff: <invalid>, primary cutoff: <invalid> } max_value_level_ttl_expiration_time: <invalid> primary_schema_version: <nullopt> cotable_schema_versions: [] global_filter: <invalid> cotables_filter: [] } } }
{ total_size: 51410458 base_size: 2207839 uncompressed_size: 102826383 name_id: 10 db_path: /root/yb01/data/yb-data/tserver/data/rocksdb/table-000033c300003000800000000000401d/tablet-a4b137dc0c2e4277b64ce029b21d5333 imported: 0 being_compacted: 0 column_family_name: default level: 0 smallest: { seqno: 1125899906842625 user_frontier: 0x0000068ab5d56900 -> { op_id: 1.1630 hybrid_time: { physical: 1729184006604399 } history_cutoff: { cotables cutoff: <invalid>, primary cutoff: <invalid> } max_value_level_ttl_expiration_time: <invalid> primary_schema_version: <nullopt> cotable_schema_versions: [] global_filter: <invalid> cotables_filter: [] } } largest: { seqno: 1125899908642642 user_frontier: 0x0000068ab5d56e40 -> { op_id: 1.1630 hybrid_time: { physical: 1729184006604595 } history_cutoff: { cotables cutoff: <invalid>, primary cutoff: <invalid> } max_value_level_ttl_expiration_time: <invalid> primary_schema_version: <nullopt> cotable_schema_versions: [] global_filter: <invalid> cotables_filter: [] } } }

/root/yb01/data/yb-data/tserver/data/rocksdb/table-000033c300003000800000000000401d/tablet-a4b137dc0c2e4277b64ce029b21d5333/000010.sst properties

# data blocks=2422
# data index blocks=4
# filter blocks=33
# entries=1800018
raw key size=57567697
raw average key size=31.9817340715482
raw value size=43050847
raw average value size=23.9168980532417
data blocks total size=49202619
data index size=68449
filter blocks total size=2160906
filter index block size=640
(estimated) table size=51431974
filter policy name=DocKeyV3Filter

/root/yb01/data/yb-data/tserver/data/rocksdb/table-000033c300003000800000000000401d/tablet-a4b137dc0c2e4277b64ce029b21d5333/000012.sst properties

# data blocks=2420
# data index blocks=4
# filter blocks=33
# entries=1800018
raw key size=57600720
raw average key size=32.0000799992
raw value size=43050862
raw average value size=23.9169063864917
data blocks total size=49317727
data index size=68411
filter blocks total size=2160906
filter index block size=641
(estimated) table size=51547044
filter policy name=DocKeyV3Filter

/root/yb01/data/yb-data/tserver/data/rocksdb/table-000033c300003000800000000000401d/tablet-a4b137dc0c2e4277b64ce029b21d5333/000013.sst properties

# data blocks=1892
# data index blocks=3
# filter blocks=26
# entries=1400014
raw key size=45606266
raw average key size=32.575578529929
raw value size=33483901
raw average value size=23.9168329745274
data blocks total size=37869533
data index size=53400
filter blocks total size=1702532
filter index block size=496
(estimated) table size=39625465
filter policy name=DocKeyV3Filter

Intents

[Version]
yugabyte_version=version 2.23.0.0 build 710 revision a31a4eba31527467192adc816e771ac09c28bb1a build_type RELEASE built at 30 Aug 2024 21:07:28 UTC

[DBOptions]
max_file_size_for_compaction=7192949369616
info_log_level=INFO_LEVEL
access_hint_on_compaction_start=NORMAL
write_thread_max_yield_usec=100
write_thread_slow_yield_usec=3
enable_write_thread_adaptive_yield=false
max_log_file_size=0
stats_dump_period_sec=600
max_manifest_file_size=18446744073709551615
bytes_per_sync=1048576
delayed_write_rate=2097152
WAL_ttl_seconds=0
allow_concurrent_memtable_write=false
paranoid_checks=true
writable_file_max_buffer_size=1048576
WAL_size_limit_MB=0
max_subcompactions=1
wal_dir=/root/yb01/data/yb-data/tserver/data/rocksdb/table-000033c300003000800000000000401d/tablet-a4b137dc0c2e4277b64ce029b21d5333.intents
wal_bytes_per_sync=0
max_total_wal_size=0
db_write_buffer_size=0
keep_log_file_num=1000
table_cache_numshardbits=4
compaction_size_threshold_bytes=2147483648
max_file_opening_threads=1
initial_seqno=1125899906842624
recycle_log_file_num=0
num_reserved_small_compaction_threads=1
random_access_max_buffer_size=1048576
use_fsync=false
max_open_files=5000
skip_stats_update_on_db_open=false
max_background_compactions=2
error_if_exists=false
manifest_preallocation_size=65536
max_background_flushes=1
is_fd_close_on_exec=true
advise_random_on_open=true
create_missing_column_families=false
delete_obsolete_files_period_micros=21600000000
create_if_missing=true
disable_data_sync=false
log_file_time_to_roll=0
compaction_readahead_size=0
use_adaptive_mutex=false
enable_thread_tracking=false
disableDataSync=false
allow_fallocate=true
skip_log_error_on_recovery=false
allow_mmap_reads=false
fail_if_options_file_error=false
allow_os_buffer=true
wal_recovery_mode=kTolerateCorruptedTailRecords
db_log_dir=
new_table_reader_for_compaction_inputs=false
base_background_compactions=2
allow_mmap_writes=false

[CFOptions "default"]
compaction_style=kCompactionStyleUniversal
merge_operator=nullptr
compaction_filter=nullptr
num_levels=1
table_factory=BlockBasedTable
comparator=leveldb.BytewiseComparator
max_sequential_skip_in_iterations=8
soft_rate_limit=0
max_bytes_for_level_base=10485760
soft_pending_compaction_bytes_limit=0
memtable_prefix_bloom_probes=6
memtable_prefix_bloom_bits=0
memtable_prefix_bloom_huge_page_tlb_size=0
max_successive_merges=0
arena_block_size=65536
min_write_buffer_number_to_merge=1
target_file_size_multiplier=1
source_compaction_factor=1
compression_per_level=
max_bytes_for_level_multiplier=10
compaction_filter_factory=DocDBIntentsCompactionFilterFactory
max_write_buffer_number=100500
level0_stop_writes_trigger=2147483647
compression=kSnappyCompression
level0_file_num_compaction_trigger=5
purge_redundant_kvs_while_flush=true
max_write_buffer_number_to_maintain=0
memtable_factory=SkipListFactory
max_grandparent_overlap_factor=10
expanded_compaction_factor=25
hard_pending_compaction_bytes_limit=0
inplace_update_num_locks=10000
level0_slowdown_writes_trigger=2147483647
level_compaction_dynamic_level_bytes=false
filter_deletes=false
verify_checksums_in_compaction=true
min_partial_merge_operands=2
paranoid_file_checks=false
target_file_size_base=2097152
optimize_filters_for_hits=false
compaction_measure_io_stats=false
prefix_extractor=nullptr
bloom_locality=0
write_buffer_size=134217728
disable_auto_compactions=false
inplace_update_support=false
[TableOptions/BlockBasedTable "default"]
format_version=2
whole_key_filtering=true
index_block_size=32768
index_block_restart_interval=1
block_size_deviation=10
hash_index_allow_collision=true
filter_block_size=65536
min_keys_per_index_block=100
block_size=32768
block_restart_interval=16
skip_table_builder_flush=false
filter_policy=DocKeyV3Filter
no_block_cache=false
checksum=kCRC32c
cache_index_and_filter_blocks=true
index_type=kMultiLevelBinarySearch
flush_block_policy_factory=FlushBlockBySizePolicyFactory

Files