2024/11/20-23:36:11.046483 140008005887552 DEBG dcompact_worker.cpp:2219: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00: fork to child time = 0.007629 sec 2024/11/20-23:36:11.046983 140008005887552 DEBG dcompact_worker.cpp:1013: Beg SerDeRead: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00 2024/11/20-23:36:11.053560 140008005887552 DEBG dcompact_worker.cpp:1033: End SerDeRead: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00 2024/11/20-23:36:11.055261 140008005887552 TRAC dcompact_worker.cpp:1083: INFO_LOG_LEVEL: rpc = INFO_LEVEL, env_var = undefined 2024/11/20-23:36:11.055515 140008005887552 [WARN] [column_family.cc:386] multiple cf_paths/db_paths and level_compaction_dynamic_level_bytes can't be used together 2024/11/20-23:36:11.106938 140008005887552 [version_set.cc:6211] Recovering from manifest file: /worker/dcompact-log/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/2024-11-20T17.53.03/.rocksdb/job-21255/att-00/MANIFEST-049091 2024/11/20-23:36:11.142194 140008005887552 [version_set.cc:6254] Recovered from manifest file:/worker/dcompact-log/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/2024-11-20T17.53.03/.rocksdb/job-21255/att-00/MANIFEST-049091 succeeded,manifest_file_number is 49091, next_file_number is 86151, last_sequence is 1321026243, log_number is 0,prev_log_number is 0,max_column_family is 0,min_log_number_to_keep is 85936 2024/11/20-23:36:11.142202 140008005887552 [version_set.cc:6269] Column family [default] (ID 0), log number is 0 2024/11/20-23:36:11.142309 140008005887552 [version_set.cc:5724] Creating manifest 86151 2024/11/20-23:36:11.174688 140008005887552 DEBG dcompact_worker.cpp:1225: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00: bottommost_level: fake = 1, rpc = 0 2024/11/20-23:36:11.191933 140008005887552 [compaction_job.cc:2437] [default] [JOB 21255] Compacting 1@2 + 18@3 files to L3, score 1.00, subcompactions 1 : 1 2024/11/20-23:36:11.191947 140008005887552 [compaction_job.cc:2445] [default]: Compaction start summary: Base version 15926 Base level 2, inputs: [86137(27MB)], [86148(40MB) 86149(4778KB) 86132(36MB) 86133(36MB) 86134(36MB) 86135(12MB) 86009(37MB) 86010(36MB) 86011(35MB) 86012(39MB) 86013(38MB) 86014(36MB) 86015(37MB) 86016(37MB) 86017(38MB) 86018(38MB) 86019(22MB) 86087(11MB)] 2024/11/20-23:36:11.198509 140008005887552 [top_zip_table.cc:59] core git_version_hash_info_is:commit 81964c21ebbcc178d8e99dae0fbf61bded2729cc Author: rockeet Date: Mon Nov 11 21:28:46 2024 +0800 Makefile: fix gen git-version-*.cpp GIT_PATH_ARG = :!src/terark/fsa :!tools/fsa :!src/terark/zbs :!tools/zbs g++ (GCC) 12.2.1 20221121 (Red Hat 12.2.1-7) Copyright (C) 2022 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. INCS = -Isrc -I3rdparty/zstd -Iboost-include DEFS = -DTOPLING_IO_WITH_URING=1 -DDIVSUFSORT_API= CXXFLAGS = -fPIC -time -fdiagnostics-color -mcx16 -fno-stack-protector WARNINGS = -Wno-class-memaccess -Wformat=2 -Wcomment -Wall -Wextra -Wno-unused-parameter -Wno-alloc-size-larger-than -Wno-deprecated-declarations -Wstrict-aliasing=3 RLS_FLAGS = -O3 -DNDEBUG -g3 WITH_BMI2 = 1 compile_cpu_flag: -march=haswell -mbmi -mbmi2 LDFLAGS = -fPIC -rdynamic 2024/11/20-23:36:11.198533 140008005887552 [top_zip_table.cc:60] fsa git_version_hash_info_is:commit 5dfecb7d107196f044ff5bf78dc39d2e725b9d9b Author: leipeng Date: Thu Nov 7 15:22:45 2024 +0800 Makefile: fix for x86_64 CPU older than haswell GIT_PATH_ARG = src/terark/fsa tools/fsa g++ (GCC) 12.2.1 20221121 (Red Hat 12.2.1-7) Copyright (C) 2022 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. INCS = -Isrc -I3rdparty/zstd -Iboost-include DEFS = -DTOPLING_IO_WITH_URING=1 -DDIVSUFSORT_API= CXXFLAGS = -fPIC -time -fdiagnostics-color -mcx16 -fno-stack-protector WARNINGS = -Wno-class-memaccess -Wformat=2 -Wcomment -Wall -Wextra -Wno-unused-parameter -Wno-alloc-size-larger-than -Wno-deprecated-declarations -Wstrict-aliasing=3 RLS_FLAGS = -O3 -DNDEBUG -g3 WITH_BMI2 = 1 compile_cpu_flag: -march=haswell -mbmi -mbmi2 LDFLAGS = -fPIC -rdynamic 2024/11/20-23:36:11.198553 140008005887552 [top_zip_table.cc:61] zbs git_version_hash_info_is:commit d44dd5ff72707128fe3c916077b43d2093c01f7c Author: leipeng Date: Sun Oct 27 23:38:26 2024 +0800 Fix for msvc, when toplingdb on msvc GIT_PATH_ARG = src/terark/zbs tools/zbs g++ (GCC) 12.2.1 20221121 (Red Hat 12.2.1-7) Copyright (C) 2022 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. INCS = -Isrc -I3rdparty/zstd -Iboost-include DEFS = -DTOPLING_IO_WITH_URING=1 -DDIVSUFSORT_API= CXXFLAGS = -fPIC -time -fdiagnostics-color -mcx16 -fno-stack-protector WARNINGS = -Wno-class-memaccess -Wformat=2 -Wcomment -Wall -Wextra -Wno-unused-parameter -Wno-alloc-size-larger-than -Wno-deprecated-declarations -Wstrict-aliasing=3 RLS_FLAGS = -O3 -DNDEBUG -g3 WITH_BMI2 = 1 compile_cpu_flag: -march=haswell -mbmi -mbmi2 LDFLAGS = -fPIC -rdynamic 2024/11/20-23:36:11.198561 140008005887552 [top_zip_table.cc:62] topling-zip_table_reader: git_version_hash_info_is: commit 79614a7e7dc27362fc5151b0797eb7d83c674c7b Author: rockeet Date: Sun Nov 10 15:02:21 2024 +0800 cpu_has_bmi2.sh: detect by compile c++ code check __BMI2__ g++ (GCC) 12.2.1 20221121 (Red Hat 12.2.1-7) Copyright (C) 2022 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. cpu_flag: -march=native -mbmi -mbmi2 2024/11/20-23:36:11.198571 140008005887552 [top_zip_table.cc:64] topling-rocks git_version_hash_info_is: commit c46b65a52d9c74aa8b87aeb8438620ff2dbc669c Author: rockeet Date: Sun Nov 10 15:02:42 2024 +0800 cpu_has_bmi2.sh: detect by compile c++ code check __BMI2__ g++ (GCC) 12.2.1 20221121 (Red Hat 12.2.1-7) Copyright (C) 2022 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. cpu_flag: -march=native -mbmi -mbmi2 2024/11/20-23:36:11.753484 140008005887552 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086152.sst) /dev/shm/ToplingTemp/Topling-1155549-Gdhcqn 2024/11/20-23:36:12.257949 140008005887552 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086152.sst): first pass time = 0.50's, 266.083'MB/sec 2024/11/20-23:36:13.587793 140008005887552 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086152.sst): old prealloc_size = 147639500, real_size = 38305728 2024/11/20-23:36:13.588401 140008005887552 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086152.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 926534 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1083 GB zip-val = 0.0363 GB avg-val = 116.86 avg-zval = 39.18 2024/11/20-23:36:13.589956 140008005887552 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086152.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-23:36:14.401464 140008005887552 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086152.sst): second pass time = 1.33's, 81.474'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.81's, 52.431'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3094.576'MB/sec (index lex order gen) rebuild zvType time = 0.67's, 0.345'MB/sec write SST data time = 0.14's, 301.528'MB/sec dict compress time = 2314885436.79's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.081'MB, throughput = 31507.843'MB/sec zip my value time = 1.33's, unzip length = 0.108'GB zip my value throughput = 81.474'MB/sec zip pipeline throughput = 162.976'MB/sec entries = 926534 avg-key = 28.00 avg-zkey = 1.91 avg-val = 116.86 avg-zval = 39.18 usrkeys = 926534 avg-key = 20.00 avg-zkey = 1.91 avg-val = 123.85 avg-zval = 39.18 TagRS{ kinds = RS_Key0_TagN bytes = 144880 } TagArray{ size = 924917 bytes = 3352832 } seq expand size = 6474419 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0185 GB value = 0.1083 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0363 GB dict = 1.08 MB all = 0.0427 GB } UnZip/Zip{ index = 10.4441 value = 2.9828 dict = 1.00 all = 3.1461 } Zip/UnZip{ index = 0.0957 value = 0.3353 dict = 1.00 all = 0.3179 } ---------------------------- total value len = 563.180482 GB avg = 0.331 KB (by entry num) total key len = 44.340349 GB avg = 0.026 KB total ukey len = 32.812672 GB avg = 0.014 KB total ukey num = 2.321941110 Billion total entry num = 1.701443132 Billion write speed all = 30.449038682 MB/sec (with seq num) write speed all = 29.766825924 MB/sec (without seq num) 2024/11/20-23:36:14.479189 140008005887552 [compaction_job.cc:1948] [default] [JOB 21255] Generated table #86152: 926534 keys, 42661920 bytes, temperature: kWarm 2024/11/20-23:36:14.479294 140008005887552 EVENT_LOG_v1 {"time_micros": 1732116974479244, "cf_name": "default", "job": 21255, "event": "table_file_creation", "file_number": 86152, "file_size": 42661920, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 1319566787, "table_properties": {"data_size": 36299632, "index_size": 1774272, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 25942952, "raw_average_key_size": 28, "raw_value_size": 108274916, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 926534, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 18446744073709551615, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_TagN-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732116971, "oldest_key_time": 0, "file_creation_time": 1732116971, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "6MZ3RU376XPAYLWHL32R", "orig_file_number": 86152, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-23:36:14.515705 140008005887552 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086153.sst) /dev/shm/ToplingTemp/Topling-1155549-bQBPIo 2024/11/20-23:36:15.465743 140008005887552 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086153.sst): first pass time = 0.95's, 141.281'MB/sec 2024/11/20-23:36:16.908885 140008005887552 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086153.sst): old prealloc_size = 147639500, real_size = 34214512 2024/11/20-23:36:16.909655 140008005887552 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086153.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 926276 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.1083 GB zip-val = 0.0322 GB avg-val = 116.90 avg-zval = 34.79 2024/11/20-23:36:16.910526 140008005887552 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086153.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-23:36:17.776466 140008005887552 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086153.sst): second pass time = 1.44's, 75.078'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.87's, 44.159'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2362.191'MB/sec (index lex order gen) rebuild zvType time = 0.73's, 0.319'MB/sec write SST data time = 0.14's, 271.108'MB/sec dict compress time = 432346115.21's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.080'MB, throughput = 27309.824'MB/sec zip my value time = 1.44's, unzip length = 0.108'GB zip my value throughput = 75.078'MB/sec zip pipeline throughput = 134.305'MB/sec entries = 926276 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.90 avg-zval = 34.79 usrkeys = 926276 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.90 avg-zval = 34.79 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 926276 bytes = 3241984 } seq expand size = 6483932 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0185 GB value = 0.1083 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0322 GB dict = 1.08 MB all = 0.0383 GB } UnZip/Zip{ index = 10.5140 value = 3.3606 dict = 1.00 all = 3.5034 } Zip/UnZip{ index = 0.0951 value = 0.2976 dict = 1.00 all = 0.2854 } ---------------------------- total value len = 563.295248 GB avg = 0.331 KB (by entry num) total key len = 44.366285 GB avg = 0.026 KB total ukey len = 32.831198 GB avg = 0.014 KB total ukey num = 2.322867386 Billion total entry num = 1.702369408 Billion write speed all = 30.450939731 MB/sec (with seq num) write speed all = 29.768471015 MB/sec (without seq num) 2024/11/20-23:36:17.834448 140008005887552 [compaction_job.cc:1948] [default] [JOB 21255] Generated table #86153: 926276 keys, 38311122 bytes, temperature: kWarm 2024/11/20-23:36:17.834539 140008005887552 EVENT_LOG_v1 {"time_micros": 1732116977834492, "cf_name": "default", "job": 21255, "event": "table_file_creation", "file_number": 86153, "file_size": 38311122, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 1119334417, "largest_seqno": 1319565911, "table_properties": {"data_size": 32220768, "index_size": 1761984, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 25935728, "raw_average_key_size": 28, "raw_value_size": 108282124, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 926276, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 18446744073709551615, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_Tag1-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732116974, "oldest_key_time": 0, "file_creation_time": 1732116974, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "6MZ3RU376XPAYLWHL32R", "orig_file_number": 86153, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-23:36:17.912920 140008005887552 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086154.sst) /dev/shm/ToplingTemp/Topling-1155549-OrlMop 2024/11/20-23:36:19.032516 140008005887552 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086154.sst): first pass time = 1.12's, 119.886'MB/sec 2024/11/20-23:36:20.448525 140008005887552 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086154.sst): old prealloc_size = 147639500, real_size = 34927440 2024/11/20-23:36:20.449128 140008005887552 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086154.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 928558 prefix = 4 raw-key = 0.0149 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.92 raw-val = 0.1082 GB zip-val = 0.0329 GB avg-val = 116.54 avg-zval = 35.45 2024/11/20-23:36:20.449939 140008005887552 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086154.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-23:36:21.396091 140008005887552 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086154.sst): second pass time = 1.41's, 76.890'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.95's, 41.193'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3032.200'MB/sec (index lex order gen) rebuild zvType time = 0.72's, 0.324'MB/sec write SST data time = 0.23's, 168.691'MB/sec dict compress time = 7515757311.84's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.080'MB, throughput = 26158.982'MB/sec zip my value time = 1.41's, unzip length = 0.108'GB zip my value throughput = 76.890'MB/sec zip pipeline throughput = 147.861'MB/sec entries = 928558 avg-key = 28.00 avg-zkey = 1.92 avg-val = 116.54 avg-zval = 35.45 usrkeys = 928558 avg-key = 20.00 avg-zkey = 1.92 avg-val = 123.54 avg-zval = 35.45 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 928558 bytes = 3249968 } seq expand size = 6499906 multi value expand size = 0 cnt WriteAppend = 15 UnZipSize{ index = 0.0186 GB value = 0.1082 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0329 GB dict = 1.08 MB all = 0.0390 GB } UnZip/Zip{ index = 10.4436 value = 3.2876 dict = 1.00 all = 3.4388 } Zip/UnZip{ index = 0.0958 value = 0.3042 dict = 1.00 all = 0.2908 } ---------------------------- total value len = 563.409966 GB avg = 0.331 KB (by entry num) total key len = 44.392285 GB avg = 0.026 KB total ukey len = 32.849769 GB avg = 0.014 KB total ukey num = 2.323795944 Billion total entry num = 1.703297966 Billion write speed all = 30.452467752 MB/sec (with seq num) write speed all = 29.769750617 MB/sec (without seq num) 2024/11/20-23:36:21.473064 140008005887552 [compaction_job.cc:1948] [default] [JOB 21255] Generated table #86154: 928558 keys, 39030832 bytes, temperature: kWarm 2024/11/20-23:36:21.473134 140008005887552 EVENT_LOG_v1 {"time_micros": 1732116981473093, "cf_name": "default", "job": 21255, "event": "table_file_creation", "file_number": 86154, "file_size": 39030832, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 1119334447, "largest_seqno": 1319566676, "table_properties": {"data_size": 32916864, "index_size": 1778240, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 25999624, "raw_average_key_size": 28, "raw_value_size": 108218112, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 928558, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 18446744073709551615, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_Tag1-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732116977, "oldest_key_time": 0, "file_creation_time": 1732116977, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "6MZ3RU376XPAYLWHL32R", "orig_file_number": 86154, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-23:36:21.535992 140008005887552 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086155.sst) /dev/shm/ToplingTemp/Topling-1155549-ddXByn 2024/11/20-23:36:22.434934 140008005887552 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086155.sst): first pass time = 0.90's, 149.313'MB/sec 2024/11/20-23:36:23.855531 140008005887552 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086155.sst): old prealloc_size = 147639500, real_size = 34403280 2024/11/20-23:36:23.856103 140008005887552 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086155.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 927695 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.1082 GB zip-val = 0.0324 GB avg-val = 116.68 avg-zval = 34.93 2024/11/20-23:36:23.856877 140008005887552 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086155.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-23:36:24.797570 140008005887552 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086155.sst): second pass time = 1.42's, 76.236'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.94's, 40.874'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3220.103'MB/sec (index lex order gen) rebuild zvType time = 0.81's, 0.288'MB/sec write SST data time = 0.14's, 282.294'MB/sec dict compress time = 7515757311.84's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.080'MB, throughput = 14527.522'MB/sec zip my value time = 1.42's, unzip length = 0.108'GB zip my value throughput = 76.236'MB/sec zip pipeline throughput = 152.471'MB/sec entries = 927695 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.68 avg-zval = 34.93 usrkeys = 927695 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.68 avg-zval = 34.93 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 927695 bytes = 3246944 } seq expand size = 6493865 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0186 GB value = 0.1082 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0324 GB dict = 1.08 MB all = 0.0385 GB } UnZip/Zip{ index = 10.5133 value = 3.3402 dict = 1.00 all = 3.4858 } Zip/UnZip{ index = 0.0951 value = 0.2994 dict = 1.00 all = 0.2869 } ---------------------------- total value len = 563.524702 GB avg = 0.331 KB (by entry num) total key len = 44.418260 GB avg = 0.026 KB total ukey len = 32.868323 GB avg = 0.014 KB total ukey num = 2.324723639 Billion total entry num = 1.704225661 Billion write speed all = 30.454327577 MB/sec (with seq num) write speed all = 29.771354998 MB/sec (without seq num) 2024/11/20-23:36:24.872633 140008005887552 [compaction_job.cc:1948] [default] [JOB 21255] Generated table #86155: 927695 keys, 38504120 bytes, temperature: kWarm 2024/11/20-23:36:24.872679 140008005887552 EVENT_LOG_v1 {"time_micros": 1732116984872654, "cf_name": "default", "job": 21255, "event": "table_file_creation", "file_number": 86155, "file_size": 38504120, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 1119334494, "largest_seqno": 1319566252, "table_properties": {"data_size": 32406400, "index_size": 1764800, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 25975460, "raw_average_key_size": 28, "raw_value_size": 108242298, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 927695, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 18446744073709551615, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_Tag1-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732116981, "oldest_key_time": 0, "file_creation_time": 1732116981, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "6MZ3RU376XPAYLWHL32R", "orig_file_number": 86155, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-23:36:24.917058 140008005887552 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086156.sst) /dev/shm/ToplingTemp/Topling-1155549-4WBzNn 2024/11/20-23:36:25.857303 140008005887552 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086156.sst): first pass time = 0.94's, 142.753'MB/sec 2024/11/20-23:36:27.185299 140008005887552 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086156.sst): old prealloc_size = 147639500, real_size = 35477376 2024/11/20-23:36:27.185896 140008005887552 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086156.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 926785 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.94 raw-val = 0.1083 GB zip-val = 0.0334 GB avg-val = 116.82 avg-zval = 36.09 2024/11/20-23:36:27.186679 140008005887552 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086156.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-23:36:27.962112 140008005887552 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086156.sst): second pass time = 1.33's, 81.573'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.78's, 51.101'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3123.665'MB/sec (index lex order gen) rebuild zvType time = 0.65's, 0.358'MB/sec write SST data time = 0.13's, 308.897'MB/sec dict compress time = 140029.08's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.080'MB, throughput = 15382.375'MB/sec zip my value time = 1.33's, unzip length = 0.108'GB zip my value throughput = 81.573'MB/sec zip pipeline throughput = 117.502'MB/sec entries = 926785 avg-key = 28.00 avg-zkey = 1.94 avg-val = 116.82 avg-zval = 36.09 usrkeys = 926785 avg-key = 20.00 avg-zkey = 1.94 avg-val = 123.82 avg-zval = 36.09 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 926785 bytes = 3359616 } seq expand size = 6487495 multi value expand size = 0 cnt WriteAppend = 45 UnZipSize{ index = 0.0185 GB value = 0.1083 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0334 GB dict = 1.08 MB all = 0.0397 GB } UnZip/Zip{ index = 10.3082 value = 3.2370 dict = 1.00 all = 3.3812 } Zip/UnZip{ index = 0.0970 value = 0.3089 dict = 1.00 all = 0.2958 } ---------------------------- total value len = 563.639457 GB avg = 0.331 KB (by entry num) total key len = 44.444210 GB avg = 0.026 KB total ukey len = 32.886859 GB avg = 0.014 KB total ukey num = 2.325650424 Billion total entry num = 1.705152446 Billion write speed all = 30.456547961 MB/sec (with seq num) write speed all = 29.773312281 MB/sec (without seq num) 2024/11/20-23:36:28.010142 140008005887552 [compaction_job.cc:1948] [default] [JOB 21255] Generated table #86156: 926785 keys, 39695386 bytes, temperature: kWarm 2024/11/20-23:36:28.010196 140008005887552 EVENT_LOG_v1 {"time_micros": 1732116988010167, "cf_name": "default", "job": 21255, "event": "table_file_creation", "file_number": 86156, "file_size": 39695386, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 919911853, "largest_seqno": 1319565327, "table_properties": {"data_size": 33447344, "index_size": 1798144, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 25949980, "raw_average_key_size": 28, "raw_value_size": 108267866, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 926785, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 18446744073709551615, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_Tag1-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732116984, "oldest_key_time": 0, "file_creation_time": 1732116984, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "6MZ3RU376XPAYLWHL32R", "orig_file_number": 86156, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-23:36:28.050248 140008005887552 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086157.sst) /dev/shm/ToplingTemp/Topling-1155549-z6bRWo 2024/11/20-23:36:28.819724 140008005887552 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086157.sst): first pass time = 0.77's, 174.435'MB/sec 2024/11/20-23:36:30.507579 140008005887552 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086157.sst): old prealloc_size = 147639500, real_size = 36502256 2024/11/20-23:36:30.508329 140008005887552 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086157.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 926957 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.94 raw-val = 0.1083 GB zip-val = 0.0345 GB avg-val = 116.79 avg-zval = 37.19 2024/11/20-23:36:30.508607 140008005887552 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086157.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-23:36:31.578031 140008005887552 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086157.sst): second pass time = 1.69's, 64.179'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.07's, 35.516'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2498.309'MB/sec (index lex order gen) rebuild zvType time = 0.88's, 0.262'MB/sec write SST data time = 0.19's, 204.878'MB/sec dict compress time = 140029.08's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.080'MB, throughput = 29156.562'MB/sec zip my value time = 1.69's, unzip length = 0.108'GB zip my value throughput = 64.179'MB/sec zip pipeline throughput = 116.196'MB/sec entries = 926957 avg-key = 28.00 avg-zkey = 1.94 avg-val = 116.79 avg-zval = 37.19 usrkeys = 926957 avg-key = 20.00 avg-zkey = 1.94 avg-val = 117.98 avg-zval = 37.19 TagRS{ kinds = RS_Key0_TagN bytes = 144920 } TagArray{ size = 157586 bytes = 512176 } seq expand size = 1103102 multi value expand size = 0 cnt WriteAppend = 39 UnZipSize{ index = 0.0185 GB value = 0.1083 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0345 GB dict = 1.08 MB all = 0.0380 GB } UnZip/Zip{ index = 10.3080 value = 3.1406 dict = 1.00 all = 3.5304 } Zip/UnZip{ index = 0.0970 value = 0.3184 dict = 1.00 all = 0.2833 } ---------------------------- total value len = 563.748823 GB avg = 0.330 KB (by entry num) total key len = 44.470165 GB avg = 0.026 KB total ukey len = 32.905398 GB avg = 0.014 KB total ukey num = 2.326577381 Billion total entry num = 1.706079403 Billion write speed all = 30.457809543 MB/sec (with seq num) write speed all = 29.774326225 MB/sec (without seq num) 2024/11/20-23:36:31.755031 140008005887552 [compaction_job.cc:1948] [default] [JOB 21255] Generated table #86157: 926957 keys, 38017429 bytes, temperature: kWarm 2024/11/20-23:36:31.755114 140008005887552 EVENT_LOG_v1 {"time_micros": 1732116991755081, "cf_name": "default", "job": 21255, "event": "table_file_creation", "file_number": 86157, "file_size": 38017429, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 973933750, "table_properties": {"data_size": 34471776, "index_size": 1798528, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 25954796, "raw_average_key_size": 28, "raw_value_size": 108263030, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 926957, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 18446744073709551615, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_TagN-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732116988, "oldest_key_time": 0, "file_creation_time": 1732116988, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "6MZ3RU376XPAYLWHL32R", "orig_file_number": 86157, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-23:36:31.812504 140008005887552 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086158.sst) /dev/shm/ToplingTemp/Topling-1155549-vlsShp 2024/11/20-23:36:32.605146 140008005887552 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086158.sst): first pass time = 0.79's, 169.339'MB/sec 2024/11/20-23:36:35.116377 140008005887552 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086158.sst): old prealloc_size = 147639500, real_size = 36428352 2024/11/20-23:36:35.117113 140008005887552 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086158.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 926842 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.92 raw-val = 0.1083 GB zip-val = 0.0344 GB avg-val = 116.81 avg-zval = 37.14 2024/11/20-23:36:35.117468 140008005887552 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086158.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-23:36:35.950782 140008005887552 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086158.sst): second pass time = 2.51's, 43.130'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.83's, 45.757'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2503.213'MB/sec (index lex order gen) rebuild zvType time = 0.68's, 0.343'MB/sec write SST data time = 0.16's, 242.344'MB/sec dict compress time = 140029.08's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.080'MB, throughput = 18036.201'MB/sec zip my value time = 2.51's, unzip length = 0.108'GB zip my value throughput = 43.130'MB/sec zip pipeline throughput = 115.863'MB/sec entries = 926842 avg-key = 28.00 avg-zkey = 1.92 avg-val = 116.81 avg-zval = 37.14 usrkeys = 926842 avg-key = 20.00 avg-zkey = 1.92 avg-val = 118.55 avg-zval = 37.14 TagRS{ kinds = RS_Key0_TagN bytes = 144920 } TagArray{ size = 230077 bytes = 747760 } seq expand size = 1610539 multi value expand size = 0 cnt WriteAppend = 19 UnZipSize{ index = 0.0185 GB value = 0.1083 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0344 GB dict = 1.08 MB all = 0.0382 GB } UnZip/Zip{ index = 10.4434 value = 3.1453 dict = 1.00 all = 3.5155 } Zip/UnZip{ index = 0.0958 value = 0.3179 dict = 1.00 all = 0.2845 } ---------------------------- total value len = 563.858700 GB avg = 0.330 KB (by entry num) total key len = 44.496116 GB avg = 0.026 KB total ukey len = 32.923935 GB avg = 0.014 KB total ukey num = 2.327504223 Billion total entry num = 1.707006245 Billion write speed all = 30.457941915 MB/sec (with seq num) write speed all = 29.774237003 MB/sec (without seq num) 2024/11/20-23:36:35.999472 140008005887552 [compaction_job.cc:1948] [default] [JOB 21255] Generated table #86158: 926842 keys, 38179047 bytes, temperature: kWarm 2024/11/20-23:36:35.999544 140008005887552 EVENT_LOG_v1 {"time_micros": 1732116995999511, "cf_name": "default", "job": 21255, "event": "table_file_creation", "file_number": 86158, "file_size": 38179047, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 973933812, "table_properties": {"data_size": 34421488, "index_size": 1774976, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 25951576, "raw_average_key_size": 28, "raw_value_size": 108266208, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 926842, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 18446744073709551615, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_TagN-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732116991, "oldest_key_time": 0, "file_creation_time": 1732116991, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "6MZ3RU376XPAYLWHL32R", "orig_file_number": 86158, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-23:36:36.037297 140008005887552 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086159.sst) /dev/shm/ToplingTemp/Topling-1155549-qYyyRo 2024/11/20-23:36:37.007992 140008005887552 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086159.sst): first pass time = 0.97's, 138.275'MB/sec 2024/11/20-23:36:38.664893 140008005887552 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086159.sst): old prealloc_size = 147639500, real_size = 37081440 2024/11/20-23:36:38.665663 140008005887552 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086159.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 925323 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.97 raw-val = 0.1083 GB zip-val = 0.0350 GB avg-val = 117.05 avg-zval = 37.86 2024/11/20-23:36:38.666081 140008005887552 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086159.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-23:36:39.429021 140008005887552 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086159.sst): second pass time = 1.66's, 65.407'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.76's, 51.186'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2480.224'MB/sec (index lex order gen) rebuild zvType time = 0.61's, 0.378'MB/sec write SST data time = 0.15's, 257.774'MB/sec dict compress time = 140029.08's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.081'MB, throughput = 22782.205'MB/sec zip my value time = 1.66's, unzip length = 0.108'GB zip my value throughput = 65.407'MB/sec zip pipeline throughput = 65.407'MB/sec entries = 925323 avg-key = 28.00 avg-zkey = 1.97 avg-val = 117.05 avg-zval = 37.86 usrkeys = 925323 avg-key = 20.00 avg-zkey = 1.97 avg-val = 119.19 avg-zval = 37.86 TagRS{ kinds = RS_Key0_TagN bytes = 144680 } TagArray{ size = 283264 bytes = 1026848 } seq expand size = 1982848 multi value expand size = 0 cnt WriteAppend = 29 UnZipSize{ index = 0.0185 GB value = 0.1083 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0350 GB dict = 1.08 MB all = 0.0391 GB } UnZip/Zip{ index = 10.1779 value = 3.0917 dict = 1.00 all = 3.4316 } Zip/UnZip{ index = 0.0983 value = 0.3234 dict = 1.00 all = 0.2914 } ---------------------------- total value len = 563.968992 GB avg = 0.330 KB (by entry num) total key len = 44.522025 GB avg = 0.026 KB total ukey len = 32.942441 GB avg = 0.014 KB total ukey num = 2.328429546 Billion total entry num = 1.707931568 Billion write speed all = 30.459456681 MB/sec (with seq num) write speed all = 29.775500256 MB/sec (without seq num) 2024/11/20-23:36:39.476324 140008005887552 [compaction_job.cc:1948] [default] [JOB 21255] Generated table #86159: 925323 keys, 39111743 bytes, temperature: kWarm 2024/11/20-23:36:39.476395 140008005887552 EVENT_LOG_v1 {"time_micros": 1732116999476361, "cf_name": "default", "job": 21255, "event": "table_file_creation", "file_number": 86159, "file_size": 39111743, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 1319563133, "table_properties": {"data_size": 35031632, "index_size": 1818304, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 25909044, "raw_average_key_size": 28, "raw_value_size": 108308746, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 925323, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 18446744073709551615, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_TagN-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732116996, "oldest_key_time": 0, "file_creation_time": 1732116996, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "6MZ3RU376XPAYLWHL32R", "orig_file_number": 86159, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-23:36:39.513023 140008005887552 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086160.sst) /dev/shm/ToplingTemp/Topling-1155549-J3nTbo 2024/11/20-23:36:40.376062 140008005887552 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086160.sst): first pass time = 0.86's, 155.527'MB/sec 2024/11/20-23:36:41.800502 140008005887552 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086160.sst): old prealloc_size = 147639500, real_size = 37958448 2024/11/20-23:36:41.801095 140008005887552 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086160.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 926194 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.1083 GB zip-val = 0.0360 GB avg-val = 116.91 avg-zval = 38.83 2024/11/20-23:36:41.802018 140008005887552 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086160.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-23:36:42.665233 140008005887552 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086160.sst): second pass time = 1.42's, 76.071'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.86's, 48.771'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3124.670'MB/sec (index lex order gen) rebuild zvType time = 0.71's, 0.328'MB/sec write SST data time = 0.16's, 265.605'MB/sec dict compress time = 140029.08's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.080'MB, throughput = 32237.243'MB/sec zip my value time = 1.42's, unzip length = 0.108'GB zip my value throughput = 76.071'MB/sec zip pipeline throughput = 79.565'MB/sec entries = 926194 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.91 avg-zval = 38.83 usrkeys = 926194 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.91 avg-zval = 38.83 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 926194 bytes = 3357472 } seq expand size = 6483358 multi value expand size = 0 cnt WriteAppend = 14 UnZipSize{ index = 0.0185 GB value = 0.1083 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0360 GB dict = 1.08 MB all = 0.0422 GB } UnZip/Zip{ index = 10.5135 value = 3.0108 dict = 1.00 all = 3.1825 } Zip/UnZip{ index = 0.0951 value = 0.3321 dict = 1.00 all = 0.3142 } ---------------------------- total value len = 564.083759 GB avg = 0.330 KB (by entry num) total key len = 44.547959 GB avg = 0.026 KB total ukey len = 32.960965 GB avg = 0.014 KB total ukey num = 2.329355740 Billion total entry num = 1.708857762 Billion write speed all = 30.461565165 MB/sec (with seq num) write speed all = 29.777348677 MB/sec (without seq num) 2024/11/20-23:36:42.717373 140008005887552 [compaction_job.cc:1948] [default] [JOB 21255] Generated table #86160: 926194 keys, 42174174 bytes, temperature: kWarm 2024/11/20-23:36:42.717445 140008005887552 EVENT_LOG_v1 {"time_micros": 1732117002717412, "cf_name": "default", "job": 21255, "event": "table_file_creation", "file_number": 86160, "file_size": 42174174, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 1015824598, "largest_seqno": 1319566062, "table_properties": {"data_size": 35964768, "index_size": 1761920, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 25933432, "raw_average_key_size": 28, "raw_value_size": 108284440, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 926194, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 18446744073709551615, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_Tag1-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732116999, "oldest_key_time": 0, "file_creation_time": 1732116999, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "6MZ3RU376XPAYLWHL32R", "orig_file_number": 86160, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-23:36:42.754541 140008005887552 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086161.sst) /dev/shm/ToplingTemp/Topling-1155549-ZhzR9m 2024/11/20-23:36:43.590074 140008005887552 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086161.sst): first pass time = 0.84's, 160.645'MB/sec 2024/11/20-23:36:44.980739 140008005887552 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086161.sst): old prealloc_size = 147639500, real_size = 34437360 2024/11/20-23:36:44.981362 140008005887552 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086161.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 925384 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.1083 GB zip-val = 0.0324 GB avg-val = 117.04 avg-zval = 35.06 2024/11/20-23:36:44.982892 140008005887552 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086161.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-23:36:45.939562 140008005887552 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086161.sst): second pass time = 1.39's, 77.930'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.96's, 40.307'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2982.322'MB/sec (index lex order gen) rebuild zvType time = 0.82's, 0.282'MB/sec write SST data time = 0.14's, 280.525'MB/sec dict compress time = 140029.08's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.081'MB, throughput = 30177.732'MB/sec zip my value time = 1.39's, unzip length = 0.108'GB zip my value throughput = 77.930'MB/sec zip pipeline throughput = 77.930'MB/sec entries = 925384 avg-key = 28.00 avg-zkey = 1.90 avg-val = 117.04 avg-zval = 35.06 usrkeys = 925384 avg-key = 20.00 avg-zkey = 1.90 avg-val = 124.04 avg-zval = 35.06 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 925384 bytes = 3354528 } seq expand size = 6477688 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0185 GB value = 0.1083 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0324 GB dict = 1.08 MB all = 0.0386 GB } UnZip/Zip{ index = 10.5100 value = 3.3382 dict = 1.00 all = 3.4729 } Zip/UnZip{ index = 0.0951 value = 0.2996 dict = 1.00 all = 0.2879 } ---------------------------- total value len = 564.198544 GB avg = 0.330 KB (by entry num) total key len = 44.573870 GB avg = 0.026 KB total ukey len = 32.979473 GB avg = 0.014 KB total ukey num = 2.330281124 Billion total entry num = 1.709783146 Billion write speed all = 30.463614549 MB/sec (with seq num) write speed all = 29.779139714 MB/sec (without seq num) 2024/11/20-23:36:45.986998 140008005887552 [compaction_job.cc:1948] [default] [JOB 21255] Generated table #86161: 925384 keys, 38647322 bytes, temperature: kWarm 2024/11/20-23:36:45.987083 140008005887552 EVENT_LOG_v1 {"time_micros": 1732117005987034, "cf_name": "default", "job": 21255, "event": "table_file_creation", "file_number": 86161, "file_size": 38647322, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 1033715575, "largest_seqno": 1319565845, "table_properties": {"data_size": 32444896, "index_size": 1760960, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 25910752, "raw_average_key_size": 28, "raw_value_size": 108307008, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 925384, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 18446744073709551615, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_Tag1-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732117002, "oldest_key_time": 0, "file_creation_time": 1732117002, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "6MZ3RU376XPAYLWHL32R", "orig_file_number": 86161, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-23:36:46.024169 140008005887552 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086162.sst) /dev/shm/ToplingTemp/Topling-1155549-LDzZ8m 2024/11/20-23:36:47.073349 140008005887552 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086162.sst): first pass time = 1.05's, 127.930'MB/sec 2024/11/20-23:36:48.438595 140008005887552 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086162.sst): old prealloc_size = 147639500, real_size = 35613504 2024/11/20-23:36:48.439332 140008005887552 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086162.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 930010 prefix = 4 raw-key = 0.0149 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.92 raw-val = 0.1082 GB zip-val = 0.0336 GB avg-val = 116.32 avg-zval = 36.13 2024/11/20-23:36:48.440175 140008005887552 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086162.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-23:36:49.291982 140008005887552 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086162.sst): second pass time = 1.36's, 79.295'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.85's, 46.546'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2502.331'MB/sec (index lex order gen) rebuild zvType time = 0.71's, 0.330'MB/sec write SST data time = 0.15's, 269.590'MB/sec dict compress time = 140029.08's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.079'MB, throughput = 16334.696'MB/sec zip my value time = 1.36's, unzip length = 0.108'GB zip my value throughput = 79.295'MB/sec zip pipeline throughput = 79.295'MB/sec entries = 930010 avg-key = 28.00 avg-zkey = 1.92 avg-val = 116.32 avg-zval = 36.13 usrkeys = 930010 avg-key = 20.00 avg-zkey = 1.92 avg-val = 123.32 avg-zval = 36.13 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 930010 bytes = 3255056 } seq expand size = 6510070 multi value expand size = 0 cnt WriteAppend = 15 UnZipSize{ index = 0.0186 GB value = 0.1082 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0336 GB dict = 1.08 MB all = 0.0397 GB } UnZip/Zip{ index = 10.4419 value = 3.2196 dict = 1.00 all = 3.3790 } Zip/UnZip{ index = 0.0958 value = 0.3106 dict = 1.00 all = 0.2959 } ---------------------------- total value len = 564.313232 GB avg = 0.330 KB (by entry num) total key len = 44.599910 GB avg = 0.026 KB total ukey len = 32.998073 GB avg = 0.014 KB total ukey num = 2.331211134 Billion total entry num = 1.710713156 Billion write speed all = 30.465545867 MB/sec (with seq num) write speed all = 29.780813592 MB/sec (without seq num) 2024/11/20-23:36:49.343916 140008005887552 [compaction_job.cc:1948] [default] [JOB 21255] Generated table #86162: 930010 keys, 39721104 bytes, temperature: kWarm 2024/11/20-23:36:49.343980 140008005887552 EVENT_LOG_v1 {"time_micros": 1732117009343949, "cf_name": "default", "job": 21255, "event": "table_file_creation", "file_number": 86162, "file_size": 39721104, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 1084741941, "largest_seqno": 1319566340, "table_properties": {"data_size": 33599536, "index_size": 1781312, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 26040280, "raw_average_key_size": 28, "raw_value_size": 108177576, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 930010, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 18446744073709551615, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_Tag1-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732117006, "oldest_key_time": 0, "file_creation_time": 1732117006, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "6MZ3RU376XPAYLWHL32R", "orig_file_number": 86162, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-23:36:49.375632 140008005887552 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086163.sst) /dev/shm/ToplingTemp/Topling-1155549-Hj92Bo 2024/11/20-23:36:50.233596 140008005887552 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086163.sst): first pass time = 0.86's, 156.444'MB/sec 2024/11/20-23:36:51.384359 140008005887552 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086163.sst): old prealloc_size = 147639500, real_size = 34754752 2024/11/20-23:36:51.385138 140008005887552 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086163.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 925236 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.93 raw-val = 0.1083 GB zip-val = 0.0327 GB avg-val = 117.06 avg-zval = 35.39 2024/11/20-23:36:51.386041 140008005887552 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086163.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-23:36:52.275466 140008005887552 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086163.sst): second pass time = 1.15's, 94.199'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.89's, 43.596'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2407.054'MB/sec (index lex order gen) rebuild zvType time = 0.74's, 0.314'MB/sec write SST data time = 0.15's, 254.653'MB/sec dict compress time = 140029.08's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.081'MB, throughput = 32815.499'MB/sec zip my value time = 1.15's, unzip length = 0.108'GB zip my value throughput = 94.199'MB/sec zip pipeline throughput = 94.199'MB/sec entries = 925236 avg-key = 28.00 avg-zkey = 1.93 avg-val = 117.06 avg-zval = 35.39 usrkeys = 925236 avg-key = 20.00 avg-zkey = 1.93 avg-val = 124.06 avg-zval = 35.39 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 925236 bytes = 3238336 } seq expand size = 6476652 multi value expand size = 0 cnt WriteAppend = 15 UnZipSize{ index = 0.0185 GB value = 0.1083 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0327 GB dict = 1.08 MB all = 0.0388 GB } UnZip/Zip{ index = 10.3782 value = 3.3082 dict = 1.00 all = 3.4549 } Zip/UnZip{ index = 0.0964 value = 0.3023 dict = 1.00 all = 0.2894 } ---------------------------- total value len = 564.428020 GB avg = 0.330 KB (by entry num) total key len = 44.625817 GB avg = 0.026 KB total ukey len = 33.016578 GB avg = 0.014 KB total ukey num = 2.332136370 Billion total entry num = 1.711638392 Billion write speed all = 30.468037165 MB/sec (with seq num) write speed all = 29.783036805 MB/sec (without seq num) 2024/11/20-23:36:52.326796 140008005887552 [compaction_job.cc:1948] [default] [JOB 21255] Generated table #86163: 925236 keys, 38848312 bytes, temperature: kWarm 2024/11/20-23:36:52.326867 140008005887552 EVENT_LOG_v1 {"time_micros": 1732117012326835, "cf_name": "default", "job": 21255, "event": "table_file_creation", "file_number": 86163, "file_size": 38848312, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 1084741998, "largest_seqno": 1319562920, "table_properties": {"data_size": 32740208, "index_size": 1783040, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 25906608, "raw_average_key_size": 28, "raw_value_size": 108311132, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 925236, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 18446744073709551615, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_Tag1-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732117009, "oldest_key_time": 0, "file_creation_time": 1732117009, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "6MZ3RU376XPAYLWHL32R", "orig_file_number": 86163, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-23:36:52.362736 140008005887552 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086164.sst) /dev/shm/ToplingTemp/Topling-1155549-uyMDOo 2024/11/20-23:36:53.222156 140008005887552 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086164.sst): first pass time = 0.86's, 156.182'MB/sec 2024/11/20-23:36:54.455412 140008005887552 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086164.sst): old prealloc_size = 147639500, real_size = 36007696 2024/11/20-23:36:54.456069 140008005887552 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086164.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 929352 prefix = 4 raw-key = 0.0149 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.95 raw-val = 0.1082 GB zip-val = 0.0340 GB avg-val = 116.42 avg-zval = 36.54 2024/11/20-23:36:54.456866 140008005887552 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086164.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-23:36:55.230417 140008005887552 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086164.sst): second pass time = 1.23's, 87.792'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.77's, 51.915'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2858.667'MB/sec (index lex order gen) rebuild zvType time = 0.64's, 0.362'MB/sec write SST data time = 0.13's, 304.069'MB/sec dict compress time = 140029.08's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.079'MB, throughput = 31412.521'MB/sec zip my value time = 1.23's, unzip length = 0.108'GB zip my value throughput = 87.792'MB/sec zip pipeline throughput = 87.792'MB/sec entries = 929352 avg-key = 28.00 avg-zkey = 1.95 avg-val = 116.42 avg-zval = 36.54 usrkeys = 929352 avg-key = 20.00 avg-zkey = 1.95 avg-val = 123.42 avg-zval = 36.54 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 929352 bytes = 3368912 } seq expand size = 6505464 multi value expand size = 0 cnt WriteAppend = 25 UnZipSize{ index = 0.0186 GB value = 0.1082 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0340 GB dict = 1.08 MB all = 0.0402 GB } UnZip/Zip{ index = 10.2409 value = 3.1860 dict = 1.00 all = 3.3359 } Zip/UnZip{ index = 0.0976 value = 0.3139 dict = 1.00 all = 0.2998 } ---------------------------- total value len = 564.542721 GB avg = 0.330 KB (by entry num) total key len = 44.651838 GB avg = 0.026 KB total ukey len = 33.035165 GB avg = 0.014 KB total ukey num = 2.333065722 Billion total entry num = 1.712567744 Billion write speed all = 30.470572639 MB/sec (with seq num) write speed all = 29.785301649 MB/sec (without seq num) 2024/11/20-23:36:55.283531 140008005887552 [compaction_job.cc:1948] [default] [JOB 21255] Generated table #86164: 929352 keys, 40233944 bytes, temperature: kWarm 2024/11/20-23:36:55.283591 140008005887552 EVENT_LOG_v1 {"time_micros": 1732117015283561, "cf_name": "default", "job": 21255, "event": "table_file_creation", "file_number": 86164, "file_size": 40233944, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 958816147, "largest_seqno": 1319566608, "table_properties": {"data_size": 33960192, "index_size": 1814976, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 26021856, "raw_average_key_size": 28, "raw_value_size": 108195980, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 929352, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 18446744073709551615, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_Tag1-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732117012, "oldest_key_time": 0, "file_creation_time": 1732117012, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "6MZ3RU376XPAYLWHL32R", "orig_file_number": 86164, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-23:36:55.321880 140008005887552 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086165.sst) /dev/shm/ToplingTemp/Topling-1155549-UbLAam 2024/11/20-23:36:56.151584 140008005887552 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086165.sst): first pass time = 0.83's, 161.773'MB/sec 2024/11/20-23:36:57.313488 140008005887552 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086165.sst): old prealloc_size = 147639500, real_size = 33983360 2024/11/20-23:36:57.314132 140008005887552 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086165.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 923456 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.1084 GB zip-val = 0.0320 GB avg-val = 117.34 avg-zval = 34.65 2024/11/20-23:36:57.314929 140008005887552 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086165.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-23:36:58.145970 140008005887552 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086165.sst): second pass time = 1.16's, 93.338'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.83's, 45.878'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2879.222'MB/sec (index lex order gen) rebuild zvType time = 0.70's, 0.330'MB/sec write SST data time = 0.13's, 289.281'MB/sec dict compress time = 140029.08's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.083'MB, throughput = 17293.419'MB/sec zip my value time = 1.16's, unzip length = 0.108'GB zip my value throughput = 93.338'MB/sec zip pipeline throughput = 93.338'MB/sec entries = 923456 avg-key = 28.00 avg-zkey = 1.90 avg-val = 117.34 avg-zval = 34.65 usrkeys = 923456 avg-key = 20.00 avg-zkey = 1.90 avg-val = 124.34 avg-zval = 34.65 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 923456 bytes = 3347536 } seq expand size = 6464192 multi value expand size = 0 cnt WriteAppend = 15 UnZipSize{ index = 0.0185 GB value = 0.1084 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0320 GB dict = 1.08 MB all = 0.0382 GB } UnZip/Zip{ index = 10.5125 value = 3.3868 dict = 1.00 all = 3.5142 } Zip/UnZip{ index = 0.0951 value = 0.2953 dict = 1.00 all = 0.2846 } ---------------------------- total value len = 564.657546 GB avg = 0.330 KB (by entry num) total key len = 44.677695 GB avg = 0.026 KB total ukey len = 33.053634 GB avg = 0.014 KB total ukey num = 2.333989178 Billion total entry num = 1.713491200 Billion write speed all = 30.473165374 MB/sec (with seq num) write speed all = 29.787624842 MB/sec (without seq num) 2024/11/20-23:36:58.198351 140008005887552 [compaction_job.cc:1948] [default] [JOB 21255] Generated table #86165: 923456 keys, 38192446 bytes, temperature: kWarm 2024/11/20-23:36:58.198424 140008005887552 EVENT_LOG_v1 {"time_micros": 1732117018198391, "cf_name": "default", "job": 21255, "event": "table_file_creation", "file_number": 86165, "file_size": 38192446, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 965477669, "largest_seqno": 1319564895, "table_properties": {"data_size": 31995440, "index_size": 1756864, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 25856768, "raw_average_key_size": 28, "raw_value_size": 108361008, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 923456, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 18446744073709551615, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_Tag1-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732117015, "oldest_key_time": 0, "file_creation_time": 1732117015, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "6MZ3RU376XPAYLWHL32R", "orig_file_number": 86165, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-23:36:58.237197 140008005887552 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086166.sst) /dev/shm/ToplingTemp/Topling-1155549-4mwOvm 2024/11/20-23:36:58.938489 140008005887552 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086166.sst): first pass time = 0.70's, 191.400'MB/sec 2024/11/20-23:37:00.086884 140008005887552 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086166.sst): old prealloc_size = 147639500, real_size = 36022720 2024/11/20-23:37:00.087508 140008005887552 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086166.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 929127 prefix = 4 raw-key = 0.0149 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.93 raw-val = 0.1082 GB zip-val = 0.0340 GB avg-val = 116.46 avg-zval = 36.59 2024/11/20-23:37:00.088308 140008005887552 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086166.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-23:37:00.910303 140008005887552 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086166.sst): second pass time = 1.15's, 94.297'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 48.733'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3050.853'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.336'MB/sec write SST data time = 0.13's, 306.002'MB/sec dict compress time = 140029.08's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.080'MB, throughput = 28648.835'MB/sec zip my value time = 1.15's, unzip length = 0.108'GB zip my value throughput = 94.297'MB/sec zip pipeline throughput = 94.297'MB/sec entries = 929127 avg-key = 28.00 avg-zkey = 1.93 avg-val = 116.46 avg-zval = 36.59 usrkeys = 929127 avg-key = 20.00 avg-zkey = 1.93 avg-val = 123.46 avg-zval = 36.59 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 929127 bytes = 3251952 } seq expand size = 6503889 multi value expand size = 0 cnt WriteAppend = 16 UnZipSize{ index = 0.0186 GB value = 0.1082 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0340 GB dict = 1.08 MB all = 0.0401 GB } UnZip/Zip{ index = 10.3753 value = 3.1825 dict = 1.00 all = 3.3447 } Zip/UnZip{ index = 0.0964 value = 0.3142 dict = 1.00 all = 0.2990 } ---------------------------- total value len = 564.772252 GB avg = 0.329 KB (by entry num) total key len = 44.703711 GB avg = 0.026 KB total ukey len = 33.072216 GB avg = 0.014 KB total ukey num = 2.334918305 Billion total entry num = 1.714420327 Billion write speed all = 30.475989761 MB/sec (with seq num) write speed all = 29.790172312 MB/sec (without seq num) 2024/11/20-23:37:00.962641 140008005887552 [compaction_job.cc:1948] [default] [JOB 21255] Generated table #86166: 929127 keys, 40127932 bytes, temperature: kWarm 2024/11/20-23:37:00.962714 140008005887552 EVENT_LOG_v1 {"time_micros": 1732117020962682, "cf_name": "default", "job": 21255, "event": "table_file_creation", "file_number": 86166, "file_size": 40127932, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 1181820642, "largest_seqno": 1319566643, "table_properties": {"data_size": 33999216, "index_size": 1791040, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 26015556, "raw_average_key_size": 28, "raw_value_size": 108202222, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 929127, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 18446744073709551615, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_Tag1-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732117018, "oldest_key_time": 0, "file_creation_time": 1732117018, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "6MZ3RU376XPAYLWHL32R", "orig_file_number": 86166, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-23:37:01.001313 140008005887552 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086167.sst) /dev/shm/ToplingTemp/Topling-1155549-buyPjn 2024/11/20-23:37:01.330276 140008005887552 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086167.sst): first pass time = 0.33's, 182.954'MB/sec 2024/11/20-23:37:01.864820 140008005887552 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086167.sst): old prealloc_size = 147639500, real_size = 16882224 2024/11/20-23:37:01.865228 140008005887552 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086167.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 417083 prefix = 4 raw-key = 0.0067 GB zip-key = 0.0008 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.0485 GB zip-val = 0.0160 GB avg-val = 116.28 avg-zval = 38.32 2024/11/20-23:37:01.865634 140008005887552 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086167.sst: sumWaitingMem = 0.001 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0010 GB, waited 0.000 sec, Key+Value = 0.060 GB 2024/11/20-23:37:02.231286 140008005887552 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00/086167.sst): second pass time = 0.53's, 90.877'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.37's, 51.121'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2162.300'MB/sec (index lex order gen) rebuild zvType time = 0.31's, 0.340'MB/sec write SST data time = 0.06's, 313.081'MB/sec dict compress time = 140029.08's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.493'MB, throughput = 15089.161'MB/sec zip my value time = 0.53's, unzip length = 0.048'GB zip my value throughput = 90.877'MB/sec zip pipeline throughput = 90.877'MB/sec entries = 417083 avg-key = 28.00 avg-zkey = 1.91 avg-val = 116.28 avg-zval = 38.32 usrkeys = 417083 avg-key = 20.00 avg-zkey = 1.91 avg-val = 123.28 avg-zval = 38.32 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 417083 bytes = 1459808 } seq expand size = 2919581 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0083 GB value = 0.0485 GB dict = 0.49 MB all = 0.0602 GB } __ZipSize{ index = 0.0008 GB value = 0.0160 GB dict = 0.49 MB all = 0.0187 GB } UnZip/Zip{ index = 10.4951 value = 3.0344 dict = 1.00 all = 3.2122 } Zip/UnZip{ index = 0.0953 value = 0.3296 dict = 1.00 all = 0.3113 } ---------------------------- total value len = 564.823670 GB avg = 0.329 KB (by entry num) total key len = 44.715389 GB avg = 0.026 KB total ukey len = 33.080558 GB avg = 0.014 KB total ukey num = 2.335335388 Billion total entry num = 1.714837410 Billion write speed all = 30.477131643 MB/sec (with seq num) write speed all = 29.791192657 MB/sec (without seq num) 2024/11/20-23:37:02.263881 140008005887552 [compaction_job.cc:1948] [default] [JOB 21255] Generated table #86167: 417083 keys, 18733851 bytes, temperature: kWarm 2024/11/20-23:37:02.263953 140008005887552 EVENT_LOG_v1 {"time_micros": 1732117022263921, "cf_name": "default", "job": 21255, "event": "table_file_creation", "file_number": 86167, "file_size": 18733851, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 1135912428, "largest_seqno": 1319566311, "table_properties": {"data_size": 15982944, "index_size": 794816, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 11678324, "raw_average_key_size": 28, "raw_value_size": 48497854, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 417083, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 18446744073709551615, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_Tag1-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732117020, "oldest_key_time": 0, "file_creation_time": 1732117020, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "6MZ3RU376XPAYLWHL32R", "orig_file_number": 86167, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-23:37:02.283267 140008005887552 [compaction_job.cc:703] job-21255: subcompact[0], size: 0.610191 G, files: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-21255/att-00 [086152,086153,086154,086155,086156,086157,086158,086159,086160,086161,086162,086163,086164,086165,086166,086167] 2024/11/20-23:37:02.408617 140008005887552 (Original Log Time 2024/11/20-23:36:11.192004) EVENT_LOG_v1 {"time_micros": 1732116971191964, "job": 21255, "event": "compaction_started", "compaction_reason": "FilesMarkedForCompaction", "files_L2": [86137], "files_L3": [86148, 86149, 86132, 86133, 86134, 86135, 86009, 86010, 86011, 86012, 86013, 86014, 86015, 86016, 86017, 86018, 86019, 86087], "score": 0.997702, "input_data_size": 634275442, "oldest_snapshot_seqno": 1321025431} 2024/11/20-23:37:02.408623 140008005887552 (Original Log Time 2024/11/20-23:37:02.407131) [compaction_job.cc:2022] [default] [JOB 21255] Compacted 1@2 + 18@3 files to L3 => 610190684 bytes 2024/11/20-23:37:02.408625 140008005887552 (Original Log Time 2024/11/20-23:37:02.408534) [compaction_job.cc:1224] [default] compacted to: files[0 0 0 16 0 0 0] max score 0.02, MB/sec: 12.4 rd, 11.9 wr, level 3, files in(1, 18) out(16 +0 blob) MB in(27.1, 577.8 +0.0 blob) out(581.9 +0.0 blob), read-write-amplify(43.8) write-amplify(21.5) OK, records in: 14416799, records dropped: 95987 output_compression: Snappy 2024/11/20-23:37:02.408631 140008005887552 (Original Log Time 2024/11/20-23:37:02.408590) EVENT_LOG_v1 {"time_micros": 1732117022408557, "cf": "default", "job": 21255, "event": "compaction_finished", "compaction_time_micros": 51091273, "compaction_time_cpu_micros": 21836162, "output_level": 3, "num_output_files": 16, "total_output_size": 610190684, "num_input_records": 14416799, "num_output_records": 14320812, "num_subcompactions": 1, "output_compression": "Snappy", "num_single_delete_mismatches": 0, "num_single_delete_fallthrough": 0, "file_write_nanos": 443310884, "file_range_sync_nanos": 0, "file_fsync_nanos": 13888, "file_prepare_write_nanos": 44270, "lsm_state": [0, 0, 0, 16, 0, 0, 0]} 2024/11/20-23:37:02.538187 140008005887552 DEBG dcompact_worker.cpp:240: HttpPost: 200 OK: url = http://nlb-7zny4kaa1poal01o64.cn-shenzhen.nlb.aliyuncs.com:8443, body = {"instanceId":"nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137","labourId":"","dbId":"d89b4006-2803-486e-b7a2-759bcf348921","dbStarts":1732096383,"starts":1732116971,"executesMs":51352,"compactionJobId":21255,"attempt":0,"compactionInputRawBytes":2087073410,"compactionInputZipBytes":634275442,"compactionOutputRawBytes":0,"compactionOutputZipBytes":610190684,"headers":{"Accept":"*/*","Connection":"close","Host":"aliyun-topling-saas.topling.cn:18443","RemoteIp":"120.24.192.169","X-Forwarded-For":"120.24.192.169","region":"cn-shenzhen","token":"e6474c481bd4415abc537135cc03626b","instance-token":"e6474c481bd4415abc537135cc03626b","provider":"aliyun","CloudMarketInstanceId":"si-59c0ae5c955845588903","MeteringAssit":"","Transfer-Encoding":"chunked","traceparent":"00-93b2c0ce64a6e9be30f39abcf09d9b01-90ef230759613f42-00"}}, response = 2024/11/20-23:37:02.538306 140008005887552 INFO dcompact_worker.cpp:1464: finish /worker/dcompact-log/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/2024-11-20T17.53.03/.rocksdb/job-21255/att-00: olev 3, work 51.353 s, result 7.846 ms, install 1.518 ms, input{raw 1.944 GiB zip 604.892 MiB}