2024/11/20-21:17:00.918594 140008668911168 DEBG dcompact_worker.cpp:2219: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00: fork to child time = 0.009414 sec 2024/11/20-21:17:00.919115 140008668911168 DEBG dcompact_worker.cpp:1013: Beg SerDeRead: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00 2024/11/20-21:17:00.925534 140008668911168 DEBG dcompact_worker.cpp:1033: End SerDeRead: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00 2024/11/20-21:17:00.927146 140008668911168 TRAC dcompact_worker.cpp:1083: INFO_LOG_LEVEL: rpc = INFO_LEVEL, env_var = undefined 2024/11/20-21:17:00.927375 140008668911168 [WARN] [column_family.cc:386] multiple cf_paths/db_paths and level_compaction_dynamic_level_bytes can't be used together 2024/11/20-21:17:00.971892 140008668911168 [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-13661/att-00/MANIFEST-049091 2024/11/20-21:17:01.026346 140008668911168 [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-13661/att-00/MANIFEST-049091 succeeded,manifest_file_number is 49091, next_file_number is 72114, last_sequence is 1150021615, log_number is 0,prev_log_number is 0,max_column_family is 0,min_log_number_to_keep is 71926 2024/11/20-21:17:01.026358 140008668911168 [version_set.cc:6269] Column family [default] (ID 0), log number is 0 2024/11/20-21:17:01.026442 140008668911168 [version_set.cc:5724] Creating manifest 72114 2024/11/20-21:17:01.058342 140008668911168 DEBG dcompact_worker.cpp:1225: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00: bottommost_level: fake = 1, rpc = 0 2024/11/20-21:17:01.077230 140008668911168 [compaction_job.cc:2437] [default] [JOB 13661] Compacting 1@2 + 9@3 files to L3, score 0.91, subcompactions 1 : 1 2024/11/20-21:17:01.077241 140008668911168 [compaction_job.cc:2445] [default]: Compaction start summary: Base version 10967 Base level 2, inputs: [72093(28MB)], [72004(124MB) 72005(124MB) 72006(124MB) 72007(124MB) 72008(124MB) 72009(124MB) 72010(124MB) 72012(124MB) 72013(56MB)] 2024/11/20-21:17:01.083560 140008668911168 [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-21:17:01.083583 140008668911168 [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-21:17:01.083602 140008668911168 [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-21:17:01.083610 140008668911168 [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-21:17:01.083625 140008668911168 [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-21:17:02.360171 140008668911168 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072115.sst) /dev/shm/ToplingTemp/Topling-1001468-mbGgdx 2024/11/20-21:17:02.515542 140008668911168 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072115.sst): first pass time = 0.16's, 864.079'MB/sec 2024/11/20-21:17:03.607833 140008668911168 [top_zip_table_builder.cc:2752] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072115.sst): part-0: reject ZipStore ratio = 0.808 2024/11/20-21:17:03.918664 140008668911168 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072115.sst): old prealloc_size = 147639500, real_size = 130039616 2024/11/20-21:17:03.918817 140008668911168 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072115.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = ZipOffsetBlobStore usrkeys = 199577 prefix = 4 raw-key = 0.0024 GB zip-key = 0.0003 GB avg-key = 12.00 avg-zkey = 1.75 raw-val = 0.1294 GB zip-val = 0.1296 GB avg-val = 648.51 avg-zval = 649.58 2024/11/20-21:17:03.919036 140008668911168 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072115.sst: sumWaitingMem = 0.000 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0004 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-21:17:04.221297 140008668911168 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072115.sst): second pass time = 1.09's, 118.573'MB/sec, value only(96.4% of KV) wait indexing time = 0.31's, remap KeyValue time = 0.30's, 431.931'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2601.506'MB/sec (index lex order gen) rebuild zvType time = 0.25's, 0.201'MB/sec write SST data time = 0.05's, 2415.285'MB/sec dict compress time = 7813572898.70's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.000'MB, throughput = 0.000'MB/sec zip my value time = 1.09's, unzip length = 0.129'GB zip my value throughput = 118.573'MB/sec zip pipeline throughput = 132.052'MB/sec entries = 199577 avg-key = 24.00 avg-zkey = 1.75 avg-val = 648.51 avg-zval = 649.58 usrkeys = 199577 avg-key = 16.00 avg-zkey = 1.75 avg-val = 655.51 avg-zval = 649.58 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 199577 bytes = 723488 } seq expand size = 1397039 multi value expand size = 0 cnt WriteAppend = 15810 UnZipSize{ index = 0.0032 GB value = 0.1294 GB dict = 0.00 MB all = 0.1342 GB } __ZipSize{ index = 0.0003 GB value = 0.1296 GB dict = 0.00 MB all = 0.1307 GB } UnZip/Zip{ index = 9.1415 value = 0.9984 dict = 0.00 all = 1.0268 } Zip/UnZip{ index = 0.1094 value = 1.0016 dict = 0.00 all = 0.9739 } ---------------------------- total value len = 563.196558 GB avg = 0.331 KB (by entry num) total key len = 44.319196 GB avg = 0.026 KB total ukey len = 32.797335 GB avg = 0.014 KB total ukey num = 2.321214153 Billion total entry num = 1.700716175 Billion write speed all = 52.363593944 MB/sec (with seq num) write speed all = 51.190875566 MB/sec (without seq num) 2024/11/20-21:17:04.364348 140008668911168 [compaction_job.cc:1948] [default] [JOB 13661] Generated table #72115: 199577 keys, 130715999 bytes, temperature: kWarm 2024/11/20-21:17:04.364437 140008668911168 EVENT_LOG_v1 {"time_micros": 1732108624364395, "cf_name": "default", "job": 13661, "event": "table_file_creation", "file_number": 72115, "file_size": 130715999, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 856426320, "largest_seqno": 1149427393, "table_properties": {"data_size": 129640240, "index_size": 349312, "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": 4789848, "raw_average_key_size": 24, "raw_value_size": 129428502, "raw_average_value_size": 648, "num_data_blocks": 1, "num_entries": 199577, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 24, "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-ZipOffsetBlobStore", "creation_time": 1732108622, "oldest_key_time": 0, "file_creation_time": 1732108622, "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": 72115, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-21:17:04.417738 140008668911168 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072116.sst) /dev/shm/ToplingTemp/Topling-1001468-r1exAv 2024/11/20-21:17:05.600210 140008668911168 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072116.sst): first pass time = 1.18's, 113.510'MB/sec 2024/11/20-21:17:07.269494 140008668911168 [top_zip_table_builder.cc:2752] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072116.sst): part-0: reject ZipStore ratio = 0.807 2024/11/20-21:17:07.530410 140008668911168 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072116.sst): old prealloc_size = 147639500, real_size = 130029200 2024/11/20-21:17:07.530573 140008668911168 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072116.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = ZipOffsetBlobStore usrkeys = 199958 prefix = 4 raw-key = 0.0024 GB zip-key = 0.0003 GB avg-key = 12.00 avg-zkey = 1.74 raw-val = 0.1294 GB zip-val = 0.1296 GB avg-val = 647.23 avg-zval = 648.29 2024/11/20-21:17:07.530799 140008668911168 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072116.sst: sumWaitingMem = 0.000 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0004 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-21:17:07.836903 140008668911168 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072116.sst): second pass time = 1.67's, 77.570'MB/sec, value only(96.4% of KV) wait indexing time = 0.26's, remap KeyValue time = 0.31's, 426.506'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2464.711'MB/sec (index lex order gen) rebuild zvType time = 0.25's, 0.200'MB/sec write SST data time = 0.06's, 2307.311'MB/sec dict compress time = 7813572898.70's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.000'MB, throughput = 0.000'MB/sec zip my value time = 1.67's, unzip length = 0.129'GB zip my value throughput = 77.570'MB/sec zip pipeline throughput = 257.106'MB/sec entries = 199958 avg-key = 24.00 avg-zkey = 1.74 avg-val = 647.23 avg-zval = 648.29 usrkeys = 199958 avg-key = 16.00 avg-zkey = 1.74 avg-val = 653.95 avg-zval = 648.29 TagRS{ kinds = RS_Key0_TagN bytes = 31360 } TagArray{ size = 192081 bytes = 696304 } seq expand size = 1344567 multi value expand size = 0 cnt WriteAppend = 15808 UnZipSize{ index = 0.0032 GB value = 0.1294 GB dict = 0.00 MB all = 0.1342 GB } __ZipSize{ index = 0.0003 GB value = 0.1296 GB dict = 0.00 MB all = 0.1307 GB } UnZip/Zip{ index = 9.1926 value = 0.9984 dict = 0.00 all = 1.0268 } Zip/UnZip{ index = 0.1088 value = 1.0016 dict = 0.00 all = 0.9739 } ---------------------------- total value len = 563.327321 GB avg = 0.331 KB (by entry num) total key len = 44.323995 GB avg = 0.026 KB total ukey len = 32.800534 GB avg = 0.014 KB total ukey num = 2.321414111 Billion total entry num = 1.700916133 Billion write speed all = 52.358961435 MB/sec (with seq num) write speed all = 51.186470570 MB/sec (without seq num) 2024/11/20-21:17:07.993862 140008668911168 [compaction_job.cc:1948] [default] [JOB 13661] Generated table #72116: 199958 keys, 130709599 bytes, temperature: kWarm 2024/11/20-21:17:07.993944 140008668911168 EVENT_LOG_v1 {"time_micros": 1732108627993899, "cf_name": "default", "job": 13661, "event": "table_file_creation", "file_number": 72116, "file_size": 130709599, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 1149425226, "table_properties": {"data_size": 129630976, "index_size": 348032, "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": 4798992, "raw_average_key_size": 24, "raw_value_size": 129418845, "raw_average_value_size": 647, "num_data_blocks": 1, "num_entries": 199958, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 24, "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-ZipOffsetBlobStore", "creation_time": 1732108624, "oldest_key_time": 0, "file_creation_time": 1732108624, "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": 72116, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-21:17:08.119921 140008668911168 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072117.sst) /dev/shm/ToplingTemp/Topling-1001468-7a0Vhw 2024/11/20-21:17:09.408297 140008668911168 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072117.sst): first pass time = 1.29's, 104.181'MB/sec 2024/11/20-21:17:10.529522 140008668911168 [top_zip_table_builder.cc:2752] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072117.sst): part-0: reject ZipStore ratio = 0.805 2024/11/20-21:17:10.812804 140008668911168 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072117.sst): old prealloc_size = 147639500, real_size = 130026368 2024/11/20-21:17:10.812998 140008668911168 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072117.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = ZipOffsetBlobStore usrkeys = 199913 prefix = 4 raw-key = 0.0024 GB zip-key = 0.0003 GB avg-key = 12.00 avg-zkey = 1.72 raw-val = 0.1294 GB zip-val = 0.1296 GB avg-val = 647.38 avg-zval = 648.44 2024/11/20-21:17:10.813231 140008668911168 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072117.sst: sumWaitingMem = 0.000 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0004 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-21:17:11.164193 140008668911168 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072117.sst): second pass time = 1.12's, 115.521'MB/sec, value only(96.4% of KV) wait indexing time = 0.28's, remap KeyValue time = 0.35's, 371.487'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 1990.689'MB/sec (index lex order gen) rebuild zvType time = 0.29's, 0.173'MB/sec write SST data time = 0.06's, 2103.727'MB/sec dict compress time = 8602282254.15's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.000'MB, throughput = 0.000'MB/sec zip my value time = 1.12's, unzip length = 0.129'GB zip my value throughput = 115.521'MB/sec zip pipeline throughput = 115.521'MB/sec entries = 199913 avg-key = 24.00 avg-zkey = 1.72 avg-val = 647.38 avg-zval = 648.44 usrkeys = 199913 avg-key = 16.00 avg-zkey = 1.72 avg-val = 652.62 avg-zval = 648.44 TagRS{ kinds = RS_Key0_TagN bytes = 31320 } TagArray{ size = 149618 bytes = 523680 } seq expand size = 1047326 multi value expand size = 0 cnt WriteAppend = 15810 UnZipSize{ index = 0.0032 GB value = 0.1294 GB dict = 0.00 MB all = 0.1342 GB } __ZipSize{ index = 0.0003 GB value = 0.1296 GB dict = 0.00 MB all = 0.1305 GB } UnZip/Zip{ index = 9.3035 value = 0.9984 dict = 0.00 all = 1.0282 } Zip/UnZip{ index = 0.1075 value = 1.0016 dict = 0.00 all = 0.9726 } ---------------------------- total value len = 563.457789 GB avg = 0.331 KB (by entry num) total key len = 44.328793 GB avg = 0.026 KB total ukey len = 32.803733 GB avg = 0.014 KB total ukey num = 2.321614024 Billion total entry num = 1.701116046 Billion write speed all = 52.355606346 MB/sec (with seq num) write speed all = 51.183313772 MB/sec (without seq num) 2024/11/20-21:17:11.352444 140008668911168 [compaction_job.cc:1948] [default] [JOB 13661] Generated table #72117: 199913 keys, 130534175 bytes, temperature: kWarm 2024/11/20-21:17:11.352517 140008668911168 EVENT_LOG_v1 {"time_micros": 1732108631352480, "cf_name": "default", "job": 13661, "event": "table_file_creation", "file_number": 72117, "file_size": 130534175, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 1149427616, "table_properties": {"data_size": 129632368, "index_size": 343808, "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": 4797912, "raw_average_key_size": 24, "raw_value_size": 129420262, "raw_average_value_size": 647, "num_data_blocks": 1, "num_entries": 199913, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 24, "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-ZipOffsetBlobStore", "creation_time": 1732108628, "oldest_key_time": 0, "file_creation_time": 1732108628, "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": 72117, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-21:17:11.419343 140008668911168 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072118.sst) /dev/shm/ToplingTemp/Topling-1001468-CwgHAv 2024/11/20-21:17:12.639173 140008668911168 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072118.sst): first pass time = 1.22's, 110.034'MB/sec 2024/11/20-21:17:13.981584 140008668911168 [top_zip_table_builder.cc:2752] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072118.sst): part-0: reject ZipStore ratio = 0.801 2024/11/20-21:17:14.248367 140008668911168 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072118.sst): old prealloc_size = 147639500, real_size = 130035456 2024/11/20-21:17:14.248500 140008668911168 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072118.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = ZipOffsetBlobStore usrkeys = 199337 prefix = 4 raw-key = 0.0024 GB zip-key = 0.0003 GB avg-key = 12.00 avg-zkey = 1.71 raw-val = 0.1294 GB zip-val = 0.1296 GB avg-val = 649.32 avg-zval = 650.38 2024/11/20-21:17:14.248706 140008668911168 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072118.sst: sumWaitingMem = 0.000 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0004 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-21:17:14.552413 140008668911168 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072118.sst): second pass time = 1.34's, 96.473'MB/sec, value only(96.4% of KV) wait indexing time = 0.27's, remap KeyValue time = 0.30's, 429.863'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2811.000'MB/sec (index lex order gen) rebuild zvType time = 0.25's, 0.199'MB/sec write SST data time = 0.05's, 2441.045'MB/sec dict compress time = 8602282254.15's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.000'MB, throughput = 0.000'MB/sec zip my value time = 1.34's, unzip length = 0.129'GB zip my value throughput = 96.473'MB/sec zip pipeline throughput = 156.190'MB/sec entries = 199337 avg-key = 24.00 avg-zkey = 1.71 avg-val = 649.32 avg-zval = 650.38 usrkeys = 199337 avg-key = 16.00 avg-zkey = 1.71 avg-val = 656.03 avg-zval = 650.38 TagRS{ kinds = RS_Key0_TagN bytes = 31240 } TagArray{ size = 191148 bytes = 669040 } seq expand size = 1338036 multi value expand size = 0 cnt WriteAppend = 15812 UnZipSize{ index = 0.0032 GB value = 0.1294 GB dict = 0.00 MB all = 0.1342 GB } __ZipSize{ index = 0.0003 GB value = 0.1296 GB dict = 0.00 MB all = 0.1307 GB } UnZip/Zip{ index = 9.3814 value = 0.9984 dict = 0.00 all = 1.0270 } Zip/UnZip{ index = 0.1066 value = 1.0016 dict = 0.00 all = 0.9737 } ---------------------------- total value len = 563.588561 GB avg = 0.331 KB (by entry num) total key len = 44.333577 GB avg = 0.026 KB total ukey len = 32.806922 GB avg = 0.014 KB total ukey num = 2.321813361 Billion total entry num = 1.701315383 Billion write speed all = 52.352003573 MB/sec (with seq num) write speed all = 51.179915723 MB/sec (without seq num) 2024/11/20-21:17:14.691896 140008668911168 [compaction_job.cc:1948] [default] [JOB 13661] Generated table #72118: 199337 keys, 130688735 bytes, temperature: kWarm 2024/11/20-21:17:14.691965 140008668911168 EVENT_LOG_v1 {"time_micros": 1732108634691933, "cf_name": "default", "job": 13661, "event": "table_file_creation", "file_number": 72118, "file_size": 130688735, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 1149427505, "table_properties": {"data_size": 129645488, "index_size": 339968, "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": 4784088, "raw_average_key_size": 24, "raw_value_size": 129434010, "raw_average_value_size": 649, "num_data_blocks": 1, "num_entries": 199337, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 24, "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-ZipOffsetBlobStore", "creation_time": 1732108631, "oldest_key_time": 0, "file_creation_time": 1732108631, "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": 72118, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-21:17:14.746219 140008668911168 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072119.sst) /dev/shm/ToplingTemp/Topling-1001468-ruj2lx 2024/11/20-21:17:15.977958 140008668911168 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072119.sst): first pass time = 1.23's, 108.970'MB/sec 2024/11/20-21:17:17.134564 140008668911168 [top_zip_table_builder.cc:2752] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072119.sst): part-0: reject ZipStore ratio = 0.803 2024/11/20-21:17:17.391390 140008668911168 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072119.sst): old prealloc_size = 147639500, real_size = 130026544 2024/11/20-21:17:17.391543 140008668911168 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072119.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = ZipOffsetBlobStore usrkeys = 199868 prefix = 4 raw-key = 0.0024 GB zip-key = 0.0003 GB avg-key = 12.00 avg-zkey = 1.72 raw-val = 0.1294 GB zip-val = 0.1296 GB avg-val = 647.53 avg-zval = 648.60 2024/11/20-21:17:17.391750 140008668911168 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072119.sst: sumWaitingMem = 0.000 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0004 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-21:17:17.690604 140008668911168 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072119.sst): second pass time = 1.16's, 111.968'MB/sec, value only(96.4% of KV) wait indexing time = 0.26's, remap KeyValue time = 0.30's, 436.636'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2559.465'MB/sec (index lex order gen) rebuild zvType time = 0.24's, 0.205'MB/sec write SST data time = 0.06's, 2352.586'MB/sec dict compress time = 140029.08's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.000'MB, throughput = 0.000'MB/sec zip my value time = 1.16's, unzip length = 0.129'GB zip my value throughput = 111.968'MB/sec zip pipeline throughput = 111.968'MB/sec entries = 199868 avg-key = 24.00 avg-zkey = 1.72 avg-val = 647.53 avg-zval = 648.60 usrkeys = 199868 avg-key = 16.00 avg-zkey = 1.72 avg-val = 653.84 avg-zval = 648.60 TagRS{ kinds = RS_Key0_TagN bytes = 31320 } TagArray{ size = 179948 bytes = 629840 } seq expand size = 1259636 multi value expand size = 0 cnt WriteAppend = 15810 UnZipSize{ index = 0.0032 GB value = 0.1294 GB dict = 0.00 MB all = 0.1342 GB } __ZipSize{ index = 0.0003 GB value = 0.1296 GB dict = 0.00 MB all = 0.1306 GB } UnZip/Zip{ index = 9.3257 value = 0.9984 dict = 0.00 all = 1.0274 } Zip/UnZip{ index = 0.1072 value = 1.0016 dict = 0.00 all = 0.9733 } ---------------------------- total value len = 563.719242 GB avg = 0.331 KB (by entry num) total key len = 44.338374 GB avg = 0.026 KB total ukey len = 32.810120 GB avg = 0.014 KB total ukey num = 2.322013229 Billion total entry num = 1.701515251 Billion write speed all = 52.349523000 MB/sec (with seq num) write speed all = 51.177614162 MB/sec (without seq num) 2024/11/20-21:17:17.829651 140008668911168 [compaction_job.cc:1948] [default] [JOB 13661] Generated table #72119: 199868 keys, 130640543 bytes, temperature: kWarm 2024/11/20-21:17:17.829717 140008668911168 EVENT_LOG_v1 {"time_micros": 1732108637829685, "cf_name": "default", "job": 13661, "event": "table_file_creation", "file_number": 72119, "file_size": 130640543, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 1149427574, "table_properties": {"data_size": 129633504, "index_size": 342912, "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": 4796832, "raw_average_key_size": 24, "raw_value_size": 129421466, "raw_average_value_size": 647, "num_data_blocks": 1, "num_entries": 199868, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 24, "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-ZipOffsetBlobStore", "creation_time": 1732108634, "oldest_key_time": 0, "file_creation_time": 1732108634, "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": 72119, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-21:17:17.885339 140008668911168 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072120.sst) /dev/shm/ToplingTemp/Topling-1001468-5Agoru 2024/11/20-21:17:19.034553 140008668911168 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072120.sst): first pass time = 1.15's, 116.795'MB/sec 2024/11/20-21:17:19.948188 140008668911168 [top_zip_table_builder.cc:2752] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072120.sst): part-0: reject ZipStore ratio = 0.803 2024/11/20-21:17:20.233183 140008668911168 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072120.sst): old prealloc_size = 147639500, real_size = 130018240 2024/11/20-21:17:20.233338 140008668911168 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072120.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = ZipOffsetBlobStore usrkeys = 200230 prefix = 4 raw-key = 0.0024 GB zip-key = 0.0003 GB avg-key = 12.00 avg-zkey = 1.71 raw-val = 0.1294 GB zip-val = 0.1296 GB avg-val = 646.32 avg-zval = 647.38 2024/11/20-21:17:20.233483 140008668911168 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072120.sst: sumWaitingMem = 0.000 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0005 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-21:17:20.532004 140008668911168 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072120.sst): second pass time = 0.91's, 141.786'MB/sec, value only(96.4% of KV) wait indexing time = 0.29's, remap KeyValue time = 0.30's, 436.352'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2506.757'MB/sec (index lex order gen) rebuild zvType time = 0.24's, 0.205'MB/sec write SST data time = 0.05's, 2399.863'MB/sec dict compress time = 140029.08's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.000'MB, throughput = 0.000'MB/sec zip my value time = 0.91's, unzip length = 0.129'GB zip my value throughput = 141.786'MB/sec zip pipeline throughput = 141.786'MB/sec entries = 200230 avg-key = 24.00 avg-zkey = 1.71 avg-val = 646.32 avg-zval = 647.38 usrkeys = 200230 avg-key = 16.00 avg-zkey = 1.71 avg-val = 650.14 avg-zval = 647.38 TagRS{ kinds = RS_Key0_TagN bytes = 31400 } TagArray{ size = 109125 bytes = 381952 } seq expand size = 763875 multi value expand size = 0 cnt WriteAppend = 15809 UnZipSize{ index = 0.0032 GB value = 0.1294 GB dict = 0.00 MB all = 0.1342 GB } __ZipSize{ index = 0.0003 GB value = 0.1296 GB dict = 0.00 MB all = 0.1304 GB } UnZip/Zip{ index = 9.3461 value = 0.9984 dict = 0.00 all = 1.0294 } Zip/UnZip{ index = 0.1070 value = 1.0016 dict = 0.00 all = 0.9714 } ---------------------------- total value len = 563.849419 GB avg = 0.331 KB (by entry num) total key len = 44.343180 GB avg = 0.026 KB total ukey len = 32.813324 GB avg = 0.014 KB total ukey num = 2.322213459 Billion total entry num = 1.701715481 Billion write speed all = 52.348338307 MB/sec (with seq num) write speed all = 51.176578204 MB/sec (without seq num) 2024/11/20-21:17:20.678699 140008668911168 [compaction_job.cc:1948] [default] [JOB 13661] Generated table #72120: 200230 keys, 130384287 bytes, temperature: kWarm 2024/11/20-21:17:20.678766 140008668911168 EVENT_LOG_v1 {"time_micros": 1732108640678735, "cf_name": "default", "job": 13661, "event": "table_file_creation", "file_number": 72120, "file_size": 130384287, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 1149414105, "table_properties": {"data_size": 129625200, "index_size": 342784, "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": 4805520, "raw_average_key_size": 24, "raw_value_size": 129412755, "raw_average_value_size": 646, "num_data_blocks": 1, "num_entries": 200230, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 24, "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-ZipOffsetBlobStore", "creation_time": 1732108637, "oldest_key_time": 0, "file_creation_time": 1732108637, "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": 72120, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-21:17:20.737778 140008668911168 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072121.sst) /dev/shm/ToplingTemp/Topling-1001468-rMUtju 2024/11/20-21:17:21.921168 140008668911168 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072121.sst): first pass time = 1.18's, 113.421'MB/sec 2024/11/20-21:17:23.085804 140008668911168 [top_zip_table_builder.cc:2752] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072121.sst): part-0: reject ZipStore ratio = 0.803 2024/11/20-21:17:23.346297 140008668911168 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072121.sst): old prealloc_size = 147639500, real_size = 130017552 2024/11/20-21:17:23.346458 140008668911168 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072121.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = ZipOffsetBlobStore usrkeys = 200310 prefix = 4 raw-key = 0.0024 GB zip-key = 0.0003 GB avg-key = 12.00 avg-zkey = 1.72 raw-val = 0.1294 GB zip-val = 0.1296 GB avg-val = 646.05 avg-zval = 647.11 2024/11/20-21:17:23.346604 140008668911168 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072121.sst: sumWaitingMem = 0.000 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0005 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-21:17:23.645808 140008668911168 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072121.sst): second pass time = 1.16's, 111.193'MB/sec, value only(96.4% of KV) wait indexing time = 0.26's, remap KeyValue time = 0.30's, 435.469'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2299.411'MB/sec (index lex order gen) rebuild zvType time = 0.24's, 0.205'MB/sec write SST data time = 0.06's, 2370.117'MB/sec dict compress time = 140029.08's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.000'MB, throughput = 0.000'MB/sec zip my value time = 1.16's, unzip length = 0.129'GB zip my value throughput = 111.193'MB/sec zip pipeline throughput = 111.193'MB/sec entries = 200310 avg-key = 24.00 avg-zkey = 1.72 avg-val = 646.05 avg-zval = 647.11 usrkeys = 200310 avg-key = 16.00 avg-zkey = 1.72 avg-val = 650.24 avg-zval = 647.11 TagRS{ kinds = RS_Key0_TagN bytes = 31400 } TagArray{ size = 119768 bytes = 419200 } seq expand size = 838376 multi value expand size = 0 cnt WriteAppend = 15808 UnZipSize{ index = 0.0032 GB value = 0.1294 GB dict = 0.00 MB all = 0.1342 GB } __ZipSize{ index = 0.0003 GB value = 0.1296 GB dict = 0.00 MB all = 0.1304 GB } UnZip/Zip{ index = 9.3115 value = 0.9984 dict = 0.00 all = 1.0291 } Zip/UnZip{ index = 0.1074 value = 1.0016 dict = 0.00 all = 0.9717 } ---------------------------- total value len = 563.979668 GB avg = 0.331 KB (by entry num) total key len = 44.347987 GB avg = 0.026 KB total ukey len = 32.816529 GB avg = 0.014 KB total ukey num = 2.322413769 Billion total entry num = 1.701915791 Billion write speed all = 52.345933580 MB/sec (with seq num) write speed all = 51.174349546 MB/sec (without seq num) 2024/11/20-21:17:23.784342 140008668911168 [compaction_job.cc:1948] [default] [JOB 13661] Generated table #72121: 200310 keys, 130420831 bytes, temperature: kWarm 2024/11/20-21:17:23.784407 140008668911168 EVENT_LOG_v1 {"time_micros": 1732108643784377, "cf_name": "default", "job": 13661, "event": "table_file_creation", "file_number": 72121, "file_size": 130420831, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 1149421991, "table_properties": {"data_size": 129623104, "index_size": 344192, "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": 4807440, "raw_average_key_size": 24, "raw_value_size": 129410597, "raw_average_value_size": 646, "num_data_blocks": 1, "num_entries": 200310, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 24, "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-ZipOffsetBlobStore", "creation_time": 1732108640, "oldest_key_time": 0, "file_creation_time": 1732108640, "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": 72121, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-21:17:23.838884 140008668911168 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072122.sst) /dev/shm/ToplingTemp/Topling-1001468-2jchyu 2024/11/20-21:17:24.992086 140008668911168 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072122.sst): first pass time = 1.15's, 116.392'MB/sec 2024/11/20-21:17:26.080479 140008668911168 [top_zip_table_builder.cc:2752] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072122.sst): part-0: reject ZipStore ratio = 0.802 2024/11/20-21:17:26.342229 140008668911168 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072122.sst): old prealloc_size = 147639500, real_size = 130016672 2024/11/20-21:17:26.342384 140008668911168 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072122.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = ZipOffsetBlobStore usrkeys = 200258 prefix = 4 raw-key = 0.0024 GB zip-key = 0.0003 GB avg-key = 12.00 avg-zkey = 1.71 raw-val = 0.1294 GB zip-val = 0.1296 GB avg-val = 646.23 avg-zval = 647.29 2024/11/20-21:17:26.342545 140008668911168 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072122.sst: sumWaitingMem = 0.000 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0005 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-21:17:26.642262 140008668911168 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072122.sst): second pass time = 1.09's, 118.990'MB/sec, value only(96.4% of KV) wait indexing time = 0.26's, remap KeyValue time = 0.30's, 434.822'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2484.863'MB/sec (index lex order gen) rebuild zvType time = 0.25's, 0.204'MB/sec write SST data time = 0.05's, 2387.708'MB/sec dict compress time = 140029.08's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.000'MB, throughput = 0.000'MB/sec zip my value time = 1.09's, unzip length = 0.129'GB zip my value throughput = 118.990'MB/sec zip pipeline throughput = 118.990'MB/sec entries = 200258 avg-key = 24.00 avg-zkey = 1.71 avg-val = 646.23 avg-zval = 647.29 usrkeys = 200258 avg-key = 16.00 avg-zkey = 1.71 avg-val = 650.76 avg-zval = 647.29 TagRS{ kinds = RS_Key0_TagN bytes = 31400 } TagArray{ size = 129726 bytes = 454048 } seq expand size = 908082 multi value expand size = 0 cnt WriteAppend = 15809 UnZipSize{ index = 0.0032 GB value = 0.1294 GB dict = 0.00 MB all = 0.1342 GB } __ZipSize{ index = 0.0003 GB value = 0.1296 GB dict = 0.00 MB all = 0.1305 GB } UnZip/Zip{ index = 9.3771 value = 0.9984 dict = 0.00 all = 1.0288 } Zip/UnZip{ index = 0.1066 value = 1.0016 dict = 0.00 all = 0.9720 } ---------------------------- total value len = 564.109988 GB avg = 0.331 KB (by entry num) total key len = 44.352793 GB avg = 0.026 KB total ukey len = 32.819733 GB avg = 0.014 KB total ukey num = 2.322614027 Billion total entry num = 1.702116049 Billion write speed all = 52.344064601 MB/sec (with seq num) write speed all = 51.172644751 MB/sec (without seq num) 2024/11/20-21:17:26.782148 140008668911168 [compaction_job.cc:1948] [default] [JOB 13661] Generated table #72122: 200258 keys, 130455071 bytes, temperature: kWarm 2024/11/20-21:17:26.782208 140008668911168 EVENT_LOG_v1 {"time_micros": 1732108646782178, "cf_name": "default", "job": 13661, "event": "table_file_creation", "file_number": 72122, "file_size": 130455071, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 1149427510, "table_properties": {"data_size": 129624720, "index_size": 341696, "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": 4806192, "raw_average_key_size": 24, "raw_value_size": 129412180, "raw_average_value_size": 646, "num_data_blocks": 1, "num_entries": 200258, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 24, "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-ZipOffsetBlobStore", "creation_time": 1732108643, "oldest_key_time": 0, "file_creation_time": 1732108643, "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": 72122, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-21:17:26.837128 140008668911168 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072123.sst) /dev/shm/ToplingTemp/Topling-1001468-LvB21t 2024/11/20-21:17:27.428415 140008668911168 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072123.sst): first pass time = 0.59's, 112.941'MB/sec 2024/11/20-21:17:28.017518 140008668911168 [top_zip_table_builder.cc:2752] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072123.sst): part-0: reject ZipStore ratio = 0.810 2024/11/20-21:17:28.148464 140008668911168 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072123.sst): old prealloc_size = 147639500, real_size = 64699568 2024/11/20-21:17:28.148569 140008668911168 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072123.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = ZipOffsetBlobStore usrkeys = 99223 prefix = 4 raw-key = 0.0012 GB zip-key = 0.0002 GB avg-key = 12.00 avg-zkey = 1.76 raw-val = 0.0644 GB zip-val = 0.0645 GB avg-val = 648.99 avg-zval = 650.05 2024/11/20-21:17:28.148696 140008668911168 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072123.sst: sumWaitingMem = 0.000 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0002 GB, waited 0.000 sec, Key+Value = 0.067 GB 2024/11/20-21:17:28.302477 140008668911168 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00/072123.sst): second pass time = 0.59's, 109.435'MB/sec, value only(96.4% of KV) wait indexing time = 0.13's, remap KeyValue time = 0.15's, 422.275'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 1952.523'MB/sec (index lex order gen) rebuild zvType time = 0.13's, 0.198'MB/sec write SST data time = 0.03's, 2265.930'MB/sec dict compress time = 140029.08's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.000'MB, throughput = 0.000'MB/sec zip my value time = 0.59's, unzip length = 0.064'GB zip my value throughput = 109.435'MB/sec zip pipeline throughput = 109.435'MB/sec entries = 99223 avg-key = 24.00 avg-zkey = 1.76 avg-val = 648.99 avg-zval = 650.05 usrkeys = 99223 avg-key = 16.00 avg-zkey = 1.76 avg-val = 655.73 avg-zval = 650.05 TagRS{ kinds = RS_Key0_TagN bytes = 15600 } TagArray{ size = 95625 bytes = 334704 } seq expand size = 669375 multi value expand size = 0 cnt WriteAppend = 7871 UnZipSize{ index = 0.0016 GB value = 0.0644 GB dict = 0.00 MB all = 0.0668 GB } __ZipSize{ index = 0.0002 GB value = 0.0645 GB dict = 0.00 MB all = 0.0650 GB } UnZip/Zip{ index = 9.0830 value = 0.9984 dict = 0.00 all = 1.0269 } Zip/UnZip{ index = 0.1101 value = 1.0016 dict = 0.00 all = 0.9738 } ---------------------------- total value len = 564.175052 GB avg = 0.331 KB (by entry num) total key len = 44.355175 GB avg = 0.026 KB total ukey len = 32.821321 GB avg = 0.014 KB total ukey num = 2.322713250 Billion total entry num = 1.702215272 Billion write speed all = 52.342391022 MB/sec (with seq num) write speed all = 51.171070177 MB/sec (without seq num) 2024/11/20-21:17:28.374792 140008668911168 [compaction_job.cc:1948] [default] [JOB 13661] Generated table #72123: 99223 keys, 65027039 bytes, temperature: kWarm 2024/11/20-21:17:28.374859 140008668911168 EVENT_LOG_v1 {"time_micros": 1732108648374828, "cf_name": "default", "job": 13661, "event": "table_file_creation", "file_number": 72123, "file_size": 65027039, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 1149427579, "table_properties": {"data_size": 64499808, "index_size": 174784, "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": 2381352, "raw_average_key_size": 24, "raw_value_size": 64394601, "raw_average_value_size": 648, "num_data_blocks": 1, "num_entries": 99223, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 24, "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-ZipOffsetBlobStore", "creation_time": 1732108646, "oldest_key_time": 0, "file_creation_time": 1732108646, "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": 72123, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-21:17:28.405571 140008668911168 [compaction_job.cc:703] job-13661: subcompact[0], size: 1.109576 G, files: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-13661/att-00 [072115,072116,072117,072118,072119,072120,072121,072122,072123] 2024/11/20-21:17:28.517408 140008668911168 (Original Log Time 2024/11/20-21:17:01.077286) EVENT_LOG_v1 {"time_micros": 1732108621077250, "job": 13661, "event": "compaction_started", "compaction_reason": "FilesMarkedForCompaction", "files_L2": [72093], "files_L3": [72004, 72005, 72006, 72007, 72008, 72009, 72010, 72012, 72013], "score": 0.914918, "input_data_size": 1132671665, "oldest_snapshot_seqno": 1150021546} 2024/11/20-21:17:28.517412 140008668911168 (Original Log Time 2024/11/20-21:17:28.513130) [compaction_job.cc:2022] [default] [JOB 13661] Compacted 1@2 + 9@3 files to L3 => 1109576279 bytes 2024/11/20-21:17:28.517413 140008668911168 (Original Log Time 2024/11/20-21:17:28.517344) [compaction_job.cc:1224] [default] compacted to: files[0 0 0 9 0 0 0] max score 0.04, MB/sec: 41.4 rd, 40.6 wr, level 3, files in(1, 9) out(9 +0 blob) MB in(28.0, 1052.1 +0.0 blob) out(1058.2 +0.0 blob), read-write-amplify(76.2) write-amplify(37.7) OK, records in: 1733600, records dropped: 34926 output_compression: Snappy 2024/11/20-21:17:28.517417 140008668911168 (Original Log Time 2024/11/20-21:17:28.517390) EVENT_LOG_v1 {"time_micros": 1732108648517366, "cf": "default", "job": 13661, "event": "compaction_finished", "compaction_time_micros": 27328291, "compaction_time_cpu_micros": 6712756, "output_level": 3, "num_output_files": 9, "total_output_size": 1109576279, "num_input_records": 1733600, "num_output_records": 1698674, "num_subcompactions": 1, "output_compression": "Snappy", "num_single_delete_mismatches": 0, "num_single_delete_fallthrough": 0, "file_write_nanos": 675125039, "file_range_sync_nanos": 0, "file_fsync_nanos": 7895, "file_prepare_write_nanos": 4527218, "lsm_state": [0, 0, 0, 9, 0, 0, 0]} 2024/11/20-21:17:28.659872 140008668911168 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":1732108620,"executesMs":27588,"compactionJobId":13661,"attempt":0,"compactionInputRawBytes":1164177450,"compactionInputZipBytes":1132671665,"compactionOutputRawBytes":0,"compactionOutputZipBytes":1109576279,"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-1d8336f977ee33b19587361069e31621-47fe0bba3018184e-00"}}, response = 2024/11/20-21:17:28.659928 140008668911168 INFO dcompact_worker.cpp:1464: finish /worker/dcompact-log/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/2024-11-20T17.53.03/.rocksdb/job-13661/att-00: olev 3, work 27.588 s, result 5.973 ms, install 4.302 ms, input{raw 1.084 GiB zip 1.055 GiB}