2024/11/22-18:44:00.094139 140024785397312 DEBG dcompact_worker.cpp:2214: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00: fork to child time = 0.012990 sec 2024/11/22-18:44:00.095639 140024785397312 DEBG dcompact_worker.cpp:1013: Beg SerDeRead: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00 2024/11/22-18:44:00.107990 140024785397312 DEBG dcompact_worker.cpp:1033: End SerDeRead: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00 2024/11/22-18:44:00.109495 140024785397312 TRAC dcompact_worker.cpp:1083: INFO_LOG_LEVEL: rpc = INFO_LEVEL, env_var = undefined 2024/11/22-18:44:00.109891 140024785397312 [WARN] [column_family.cc:386] multiple cf_paths/db_paths and level_compaction_dynamic_level_bytes can't be used together 2024/11/22-18:44:00.162092 140024785397312 [version_set.cc:6208] Recovering from manifest file: /worker/dcompact-log/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/2024-11-22T14.14.14/.rocksdb/job-07862/att-00/MANIFEST-206347 2024/11/22-18:44:00.194544 140024785397312 [version_set.cc:6251] Recovered from manifest file:/worker/dcompact-log/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/2024-11-22T14.14.14/.rocksdb/job-07862/att-00/MANIFEST-206347 succeeded,manifest_file_number is 206347, next_file_number is 221192, last_sequence is 3474995145, log_number is 0,prev_log_number is 0,max_column_family is 0,min_log_number_to_keep is 221045 2024/11/22-18:44:00.194558 140024785397312 [version_set.cc:6266] Column family [default] (ID 0), log number is 0 2024/11/22-18:44:00.194701 140024785397312 [version_set.cc:5721] Creating manifest 221192 2024/11/22-18:44:00.225266 140024785397312 DEBG dcompact_worker.cpp:1218: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00: bottommost_level: fake = 1, rpc = 0 2024/11/22-18:44:00.245846 140024785397312 [compaction_job.cc:2437] [default] [JOB 7862] Compacting 1@2 + 12@3 files to L3, score 0.96, subcompactions 1 : 1 2024/11/22-18:44:00.245875 140024785397312 [compaction_job.cc:2445] [default]: Compaction start summary: Base version 5975 Base level 2, inputs: [221190(27MB)], [221141(36MB) 221142(36MB) 221143(36MB) 221144(37MB) 221145(36MB) 221146(35MB) 221147(36MB) 221148(35MB) 221149(34MB) 221150(35MB) 221151(35MB) 221152(5300KB)] 2024/11/22-18:44:00.253826 140024785397312 [top_zip_table.cc:59] core git_version_hash_info_is:commit fc4ab4f2fbfdcdfa23a955d69e26d2fc533b902d Author: leipeng Date: 2024-04-16 20:29:43 +0800 test_sso.cpp: test swap g++ (GCC) 12.1.0 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/re2 -I3rdparty/zstd -Iboost-include CXXFLAGS = -D TOPLING_IO_WITH_URING=1 -fPIC -time -Wno-class-memaccess -fdiagnostics-color -Wformat=2 -Wcomment -Wall -Wextra -Wno-unused-parameter -Wno-alloc-size-larger-than -mcx16 -Wno-deprecated-declarations -Wstrict-aliasing=3 -DCLIENT_LICENSE_ID="public" -DNO_THREADS -ftls-model=initial-exec -DDIVSUFSORT_API= -fno-stack-protector RLS_FLAGS = -O3 -DNDEBUG -g3 WITH_BMI2 = 1 compile_cpu_flag: -march=haswell -mbmi -mbmi2 2024/11/22-18:44:00.253877 140024785397312 [top_zip_table.cc:60] fsa git_version_hash_info_is:commit fc4ab4f2fbfdcdfa23a955d69e26d2fc533b902d Author: leipeng Date: 2024-04-16 20:29:43 +0800 test_sso.cpp: test swap g++ (GCC) 12.1.0 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/re2 -I3rdparty/zstd -Iboost-include CXXFLAGS = -D TOPLING_IO_WITH_URING=1 -fPIC -time -Wno-class-memaccess -fdiagnostics-color -Wformat=2 -Wcomment -Wall -Wextra -Wno-unused-parameter -Wno-alloc-size-larger-than -mcx16 -Wno-deprecated-declarations -Wstrict-aliasing=3 -DCLIENT_LICENSE_ID="public" -DNO_THREADS -ftls-model=initial-exec -DDIVSUFSORT_API= -fno-stack-protector RLS_FLAGS = -O3 -DNDEBUG -g3 WITH_BMI2 = 1 compile_cpu_flag: -march=haswell -mbmi -mbmi2 2024/11/22-18:44:00.253905 140024785397312 [top_zip_table.cc:61] zbs git_version_hash_info_is:commit fc4ab4f2fbfdcdfa23a955d69e26d2fc533b902d Author: leipeng Date: 2024-04-16 20:29:43 +0800 test_sso.cpp: test swap g++ (GCC) 12.1.0 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/re2 -I3rdparty/zstd -Iboost-include CXXFLAGS = -D TOPLING_IO_WITH_URING=1 -fPIC -time -Wno-class-memaccess -fdiagnostics-color -Wformat=2 -Wcomment -Wall -Wextra -Wno-unused-parameter -Wno-alloc-size-larger-than -mcx16 -Wno-deprecated-declarations -Wstrict-aliasing=3 -DCLIENT_LICENSE_ID="public" -DNO_THREADS -ftls-model=initial-exec -DDIVSUFSORT_API= -fno-stack-protector RLS_FLAGS = -O3 -DNDEBUG -g3 WITH_BMI2 = 1 compile_cpu_flag: -march=haswell -mbmi -mbmi2 2024/11/22-18:44:00.253913 140024785397312 [top_zip_table.cc:62] topling-zip_table_reader: git_version_hash_info_is: commit a4a382006cb82713acf5b3425835f22711877681 Author: leipeng Date: 2024-04-11 19:44:14 +0800 fixed_len_hole_index.cc: Add env bool FixedLenHoleIndexUseAVX512 for ut & debug 1. FixedLenHoleIndexUseAVX512 is only in unit tests or debug 2. In release mode, use avx512 by compile options(-march=) g++ (GCC) 12.1.0 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/22-18:44:00.253929 140024785397312 [top_zip_table.cc:64] topling-rocks git_version_hash_info_is: commit feab587e468621ba0204d47b4ffacc52e7c4290d Author: leipeng Date: 2024-03-22 13:35:06 +0800 ToplingZipTableBuilder::Add: immediately return after error This function returns void, and caller does not check builder->status() after calling this function and graceful abandon. So immediately return after error, and return error status in Finish(). g++ (GCC) 12.1.0 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/22-18:44:00.851646 140024785397312 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221193.sst) /dev/shm/ToplingTemp/Topling-245159-BA9tiZ 2024/11/22-18:44:01.598577 140024785397312 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221193.sst): first pass time = 0.75's, 179.707'MB/sec 2024/11/22-18:44:03.457454 140024785397312 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221193.sst): old prealloc_size = 147639500, real_size = 34573456 2024/11/22-18:44:03.458057 140024785397312 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221193.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 928503 prefix = 4 raw-key = 0.0149 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.1082 GB zip-val = 0.0326 GB avg-val = 116.55 avg-zval = 35.08 2024/11/22-18:44:03.458812 140024785397312 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221193.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/22-18:44:04.669298 140024785397312 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221193.sst): second pass time = 1.86's, 58.261'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.21's, 31.724'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3021.166'MB/sec (index lex order gen) rebuild zvType time = 1.03's, 0.225'MB/sec write SST data time = 0.18's, 215.549'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.080'MB, throughput = 30042.741'MB/sec zip my value time = 1.86's, unzip length = 0.108'GB zip my value throughput = 58.261'MB/sec zip pipeline throughput = 122.228'MB/sec entries = 928503 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.55 avg-zval = 35.08 usrkeys = 928503 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.55 avg-zval = 35.08 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 928503 bytes = 3017648 } seq expand size = 6499521 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.0326 GB dict = 1.08 MB all = 0.0384 GB } UnZip/Zip{ index = 10.5129 value = 3.3222 dict = 1.00 all = 3.4912 } Zip/UnZip{ index = 0.0951 value = 0.3010 dict = 1.00 all = 0.2864 } ---------------------------- total value len = 0.114719 GB avg = 0.124 KB (by entry num) total key len = 0.025998 GB avg = 0.028 KB total ukey len = 0.018570 GB avg = 0.020 KB total ukey num = 0.000928503 Billion total entry num = 0.000928503 Billion write speed all = 0.003963691 MB/sec (with seq num) write speed all = 0.003754461 MB/sec (without seq num) 2024/11/22-18:44:04.704644 140024785397312 [compaction_job.cc:1948] [default] [JOB 7862] Generated table #221193: 928503 keys, 38444398 bytes, temperature: kWarm 2024/11/22-18:44:04.704821 140024785397312 EVENT_LOG_v1 {"time_micros": 1732272244704680, "cf_name": "default", "job": 7862, "event": "table_file_creation", "file_number": 221193, "file_size": 38444398, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3434038008, "largest_seqno": 3474946199, "table_properties": {"data_size": 32574720, "index_size": 1766400, "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": 25998084, "raw_average_key_size": 28, "raw_value_size": 108219674, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 928503, "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": 1732272240, "oldest_key_time": 0, "file_creation_time": 1732272240, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "U1ECJGOXSO4Y1P7ZZXV1", "orig_file_number": 221193, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/22-18:44:04.742833 140024785397312 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221194.sst) /dev/shm/ToplingTemp/Topling-245159-lhjpeW 2024/11/22-18:44:05.767164 140024785397312 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221194.sst): first pass time = 1.02's, 131.034'MB/sec 2024/11/22-18:44:09.874727 140024785397312 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221194.sst): old prealloc_size = 147639500, real_size = 34798848 2024/11/22-18:44:09.875373 140024785397312 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221194.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 928468 prefix = 4 raw-key = 0.0149 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.1082 GB zip-val = 0.0328 GB avg-val = 116.56 avg-zval = 35.33 2024/11/22-18:44:09.876171 140024785397312 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221194.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/22-18:44:11.229226 140024785397312 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221194.sst): second pass time = 4.11's, 26.361'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.35's, 28.550'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2973.659'MB/sec (index lex order gen) rebuild zvType time = 1.05's, 0.220'MB/sec write SST data time = 0.30's, 129.036'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.080'MB, throughput = 37633.100'MB/sec zip my value time = 4.11's, unzip length = 0.108'GB zip my value throughput = 26.361'MB/sec zip pipeline throughput = 134.112'MB/sec entries = 928468 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.56 avg-zval = 35.33 usrkeys = 928468 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.56 avg-zval = 35.33 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 928468 bytes = 3017536 } seq expand size = 6499276 multi value expand size = 0 cnt WriteAppend = 12 UnZipSize{ index = 0.0186 GB value = 0.1082 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0328 GB dict = 1.08 MB all = 0.0387 GB } UnZip/Zip{ index = 10.5145 value = 3.2994 dict = 1.00 all = 3.4709 } Zip/UnZip{ index = 0.0951 value = 0.3031 dict = 1.00 all = 0.2881 } ---------------------------- total value len = 0.229439 GB avg = 0.124 KB (by entry num) total key len = 0.051995 GB avg = 0.028 KB total ukey len = 0.037139 GB avg = 0.020 KB total ukey num = 0.001856971 Billion total entry num = 0.001856971 Billion write speed all = 0.007925911 MB/sec (with seq num) write speed all = 0.007507534 MB/sec (without seq num) 2024/11/22-18:44:11.265050 140024785397312 [compaction_job.cc:1948] [default] [JOB 7862] Generated table #221194: 928468 keys, 38669816 bytes, temperature: kWarm 2024/11/22-18:44:11.265127 140024785397312 EVENT_LOG_v1 {"time_micros": 1732272251265085, "cf_name": "default", "job": 7862, "event": "table_file_creation", "file_number": 221194, "file_size": 38669816, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3434038055, "largest_seqno": 3474946320, "table_properties": {"data_size": 32800496, "index_size": 1766080, "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": 25997104, "raw_average_key_size": 28, "raw_value_size": 108220636, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 928468, "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": 1732272244, "oldest_key_time": 0, "file_creation_time": 1732272244, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "U1ECJGOXSO4Y1P7ZZXV1", "orig_file_number": 221194, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/22-18:44:11.324281 140024785397312 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221195.sst) /dev/shm/ToplingTemp/Topling-245159-VBrYcY 2024/11/22-18:44:12.756180 140024785397312 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221195.sst): first pass time = 1.43's, 93.737'MB/sec 2024/11/22-18:44:15.754701 140024785397312 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221195.sst): old prealloc_size = 147639500, real_size = 34884432 2024/11/22-18:44:15.755334 140024785397312 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221195.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 928490 prefix = 4 raw-key = 0.0149 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.1082 GB zip-val = 0.0329 GB avg-val = 116.55 avg-zval = 35.42 2024/11/22-18:44:15.756109 140024785397312 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221195.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/22-18:44:17.010616 140024785397312 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221195.sst): second pass time = 3.00's, 36.099'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.26's, 30.859'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2899.974'MB/sec (index lex order gen) rebuild zvType time = 1.00's, 0.232'MB/sec write SST data time = 0.25's, 153.269'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.080'MB, throughput = 23635.647'MB/sec zip my value time = 3.00's, unzip length = 0.108'GB zip my value throughput = 36.099'MB/sec zip pipeline throughput = 105.798'MB/sec entries = 928490 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.55 avg-zval = 35.42 usrkeys = 928490 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.55 avg-zval = 35.42 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 928490 bytes = 3017600 } seq expand size = 6499430 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.0329 GB dict = 1.08 MB all = 0.0388 GB } UnZip/Zip{ index = 10.5120 value = 3.2908 dict = 1.00 all = 3.4632 } Zip/UnZip{ index = 0.0951 value = 0.3039 dict = 1.00 all = 0.2888 } ---------------------------- total value len = 0.344159 GB avg = 0.124 KB (by entry num) total key len = 0.077993 GB avg = 0.028 KB total ukey len = 0.055709 GB avg = 0.020 KB total ukey num = 0.002785461 Billion total entry num = 0.002785461 Billion write speed all = 0.011886931 MB/sec (with seq num) write speed all = 0.011259468 MB/sec (without seq num) 2024/11/22-18:44:17.046007 140024785397312 [compaction_job.cc:1948] [default] [JOB 7862] Generated table #221195: 928490 keys, 38755428 bytes, temperature: kWarm 2024/11/22-18:44:17.046086 140024785397312 EVENT_LOG_v1 {"time_micros": 1732272257046044, "cf_name": "default", "job": 7862, "event": "table_file_creation", "file_number": 221195, "file_size": 38755428, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3434038106, "largest_seqno": 3474945949, "table_properties": {"data_size": 32885568, "index_size": 1766528, "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": 25997720, "raw_average_key_size": 28, "raw_value_size": 108220016, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 928490, "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": 1732272251, "oldest_key_time": 0, "file_creation_time": 1732272251, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "U1ECJGOXSO4Y1P7ZZXV1", "orig_file_number": 221195, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/22-18:44:17.113614 140024785397312 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221196.sst) /dev/shm/ToplingTemp/Topling-245159-XZKTtZ 2024/11/22-18:44:18.555893 140024785397312 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221196.sst): first pass time = 1.44's, 93.062'MB/sec 2024/11/22-18:44:20.309495 140024785397312 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221196.sst): old prealloc_size = 147639500, real_size = 34824608 2024/11/22-18:44:20.310033 140024785397312 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221196.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 925669 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0017 GB avg-key = 16.00 avg-zkey = 1.89 raw-val = 0.1083 GB zip-val = 0.0328 GB avg-val = 117.00 avg-zval = 35.48 2024/11/22-18:44:20.310785 140024785397312 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221196.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/22-18:44:21.403800 140024785397312 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221196.sst): second pass time = 1.75's, 61.780'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.09's, 35.570'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3362.025'MB/sec (index lex order gen) rebuild zvType time = 0.86's, 0.270'MB/sec write SST data time = 0.24's, 164.211'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.080'MB, throughput = 28962.889'MB/sec zip my value time = 1.75's, unzip length = 0.108'GB zip my value throughput = 61.780'MB/sec zip pipeline throughput = 114.852'MB/sec entries = 925669 avg-key = 28.00 avg-zkey = 1.89 avg-val = 117.00 avg-zval = 35.48 usrkeys = 925669 avg-key = 20.00 avg-zkey = 1.89 avg-val = 124.00 avg-zval = 35.48 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 925669 bytes = 3239856 } seq expand size = 6479683 multi value expand size = 0 cnt WriteAppend = 12 UnZipSize{ index = 0.0185 GB value = 0.1083 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0017 GB value = 0.0328 GB dict = 1.08 MB all = 0.0389 GB } UnZip/Zip{ index = 10.5832 value = 3.2974 dict = 1.00 all = 3.4483 } Zip/UnZip{ index = 0.0945 value = 0.3033 dict = 1.00 all = 0.2900 } ---------------------------- total value len = 0.458937 GB avg = 0.124 KB (by entry num) total key len = 0.103912 GB avg = 0.028 KB total ukey len = 0.074223 GB avg = 0.020 KB total ukey num = 0.003711130 Billion total entry num = 0.003711130 Billion write speed all = 0.015846726 MB/sec (with seq num) write speed all = 0.015010846 MB/sec (without seq num) 2024/11/22-18:44:21.442436 140024785397312 [compaction_job.cc:1948] [default] [JOB 7862] Generated table #221196: 925669 keys, 38922654 bytes, temperature: kWarm 2024/11/22-18:44:21.442515 140024785397312 EVENT_LOG_v1 {"time_micros": 1732272261442472, "cf_name": "default", "job": 7862, "event": "table_file_creation", "file_number": 221196, "file_size": 38922654, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3237868609, "largest_seqno": 3474945794, "table_properties": {"data_size": 32843664, "index_size": 1749312, "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": 25918732, "raw_average_key_size": 28, "raw_value_size": 108299026, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 925669, "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": 1732272257, "oldest_key_time": 0, "file_creation_time": 1732272257, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "U1ECJGOXSO4Y1P7ZZXV1", "orig_file_number": 221196, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/22-18:44:21.511567 140024785397312 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221197.sst) /dev/shm/ToplingTemp/Topling-245159-ihmNYY 2024/11/22-18:44:22.691314 140024785397312 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221197.sst): first pass time = 1.18's, 113.773'MB/sec 2024/11/22-18:44:24.368424 140024785397312 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221197.sst): old prealloc_size = 147639500, real_size = 36830288 2024/11/22-18:44:24.369015 140024785397312 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221197.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 926492 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.0348 GB avg-val = 116.87 avg-zval = 37.59 2024/11/22-18:44:24.369239 140024785397312 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221197.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/22-18:44:25.498042 140024785397312 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221197.sst): second pass time = 1.68's, 64.606'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.13's, 33.865'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3114.459'MB/sec (index lex order gen) rebuild zvType time = 0.87's, 0.268'MB/sec write SST data time = 0.26's, 145.168'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.081'MB, throughput = 33592.540'MB/sec zip my value time = 1.68's, unzip length = 0.108'GB zip my value throughput = 64.606'MB/sec zip pipeline throughput = 64.606'MB/sec entries = 926492 avg-key = 28.00 avg-zkey = 1.91 avg-val = 116.87 avg-zval = 37.59 usrkeys = 926492 avg-key = 20.00 avg-zkey = 1.91 avg-val = 117.88 avg-zval = 37.59 TagRS{ kinds = RS_Key0_TagN bytes = 144880 } TagArray{ size = 134226 bytes = 419472 } seq expand size = 939582 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.0348 GB dict = 1.08 MB all = 0.0383 GB } UnZip/Zip{ index = 10.4455 value = 3.1092 dict = 1.00 all = 3.5087 } Zip/UnZip{ index = 0.0957 value = 0.3216 dict = 1.00 all = 0.2850 } ---------------------------- total value len = 0.568153 GB avg = 0.123 KB (by entry num) total key len = 0.129853 GB avg = 0.028 KB total ukey len = 0.092752 GB avg = 0.020 KB total ukey num = 0.004637622 Billion total entry num = 0.004637622 Billion write speed all = 0.019649749 MB/sec (with seq num) write speed all = 0.018605310 MB/sec (without seq num) 2024/11/22-18:44:25.534985 140024785397312 [compaction_job.cc:1948] [default] [JOB 7862] Generated table #221197: 926492 keys, 38253231 bytes, temperature: kWarm 2024/11/22-18:44:25.535233 140024785397312 EVENT_LOG_v1 {"time_micros": 1732272265535043, "cf_name": "default", "job": 7862, "event": "table_file_creation", "file_number": 221197, "file_size": 38253231, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 3273700833, "table_properties": {"data_size": 34824512, "index_size": 1773952, "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": 25941776, "raw_average_key_size": 28, "raw_value_size": 108276016, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 926492, "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": 1732272261, "oldest_key_time": 0, "file_creation_time": 1732272261, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "U1ECJGOXSO4Y1P7ZZXV1", "orig_file_number": 221197, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/22-18:44:25.606632 140024785397312 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221198.sst) /dev/shm/ToplingTemp/Topling-245159-3stJDX 2024/11/22-18:44:26.477256 140024785397312 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221198.sst): first pass time = 0.87's, 154.172'MB/sec 2024/11/22-18:44:28.385089 140024785397312 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221198.sst): old prealloc_size = 147639500, real_size = 36456624 2024/11/22-18:44:28.385667 140024785397312 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221198.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 927067 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.89 raw-val = 0.1083 GB zip-val = 0.0345 GB avg-val = 116.78 avg-zval = 37.18 2024/11/22-18:44:28.385708 140024785397312 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221198.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/22-18:44:29.026834 140024785397312 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221198.sst): second pass time = 1.91's, 56.782'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.64's, 58.148'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3157.463'MB/sec (index lex order gen) rebuild zvType time = 0.52's, 0.448'MB/sec write SST data time = 0.12's, 299.984'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.080'MB, throughput = 28312.520'MB/sec zip my value time = 1.91's, unzip length = 0.108'GB zip my value throughput = 56.782'MB/sec zip pipeline throughput = 86.815'MB/sec entries = 927067 avg-key = 28.00 avg-zkey = 1.89 avg-val = 116.78 avg-zval = 37.18 usrkeys = 927067 avg-key = 20.00 avg-zkey = 1.89 avg-val = 116.78 avg-zval = 37.18 TagRS{ kinds = LegacyZvType bytes = 0 } TagArray{ size = 0 bytes = 0 } seq expand size = 0 multi value expand size = 0 cnt WriteAppend = 9 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.0373 GB } UnZip/Zip{ index = 10.5814 value = 3.1405 dict = 1.00 all = 3.5969 } Zip/UnZip{ index = 0.0945 value = 0.3184 dict = 1.00 all = 0.2780 } ---------------------------- total value len = 0.676413 GB avg = 0.122 KB (by entry num) total key len = 0.155811 GB avg = 0.028 KB total ukey len = 0.111294 GB avg = 0.020 KB total ukey num = 0.005564689 Billion total entry num = 0.005564689 Billion write speed all = 0.023425820 MB/sec (with seq num) write speed all = 0.022172721 MB/sec (without seq num) 2024/11/22-18:44:29.063641 140024785397312 [compaction_job.cc:1948] [default] [JOB 7862] Generated table #221198: 927067 keys, 37314436 bytes, temperature: kWarm 2024/11/22-18:44:29.063706 140024785397312 EVENT_LOG_v1 {"time_micros": 1732272269063673, "cf_name": "default", "job": 7862, "event": "table_file_creation", "file_number": 221198, "file_size": 37314436, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 0, "table_properties": {"data_size": 34472416, "index_size": 1752256, "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": 25957876, "raw_average_key_size": 28, "raw_value_size": 108259898, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 927067, "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": "TooZip", "compression_options": "LegacyZvType-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732272265, "oldest_key_time": 0, "file_creation_time": 1732272265, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "U1ECJGOXSO4Y1P7ZZXV1", "orig_file_number": 221198, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/22-18:44:29.108729 140024785397312 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221199.sst) /dev/shm/ToplingTemp/Topling-245159-TzH46W 2024/11/22-18:44:29.933314 140024785397312 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221199.sst): first pass time = 0.82's, 162.779'MB/sec 2024/11/22-18:44:31.535484 140024785397312 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221199.sst): old prealloc_size = 147639500, real_size = 35545600 2024/11/22-18:44:31.536032 140024785397312 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221199.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 923155 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.0336 GB avg-val = 117.39 avg-zval = 36.35 2024/11/22-18:44:31.536492 140024785397312 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221199.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/22-18:44:32.334693 140024785397312 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221199.sst): second pass time = 1.60's, 67.691'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.80's, 47.698'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3346.620'MB/sec (index lex order gen) rebuild zvType time = 0.67's, 0.344'MB/sec write SST data time = 0.13's, 299.617'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.083'MB, throughput = 31338.446'MB/sec zip my value time = 1.60's, unzip length = 0.108'GB zip my value throughput = 67.691'MB/sec zip pipeline throughput = 107.549'MB/sec entries = 923155 avg-key = 28.00 avg-zkey = 1.90 avg-val = 117.39 avg-zval = 36.35 usrkeys = 923155 avg-key = 20.00 avg-zkey = 1.90 avg-val = 120.91 avg-zval = 36.35 TagRS{ kinds = RS_Key0_TagN bytes = 144360 } TagArray{ size = 464717 bytes = 1568432 } seq expand size = 3253019 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.0336 GB dict = 1.08 MB all = 0.0381 GB } UnZip/Zip{ index = 10.5110 value = 3.2293 dict = 1.00 all = 3.5209 } Zip/UnZip{ index = 0.0951 value = 0.3097 dict = 1.00 all = 0.2840 } ---------------------------- total value len = 0.788035 GB avg = 0.121 KB (by entry num) total key len = 0.181660 GB avg = 0.028 KB total ukey len = 0.129757 GB avg = 0.020 KB total ukey num = 0.006487844 Billion total entry num = 0.006487844 Billion write speed all = 0.027292871 MB/sec (with seq num) write speed all = 0.025832024 MB/sec (without seq num) 2024/11/22-18:44:32.369800 140024785397312 [compaction_job.cc:1948] [default] [JOB 7862] Generated table #221199: 923155 keys, 38120227 bytes, temperature: kWarm 2024/11/22-18:44:32.369869 140024785397312 EVENT_LOG_v1 {"time_micros": 1732272272369832, "cf_name": "default", "job": 7862, "event": "table_file_creation", "file_number": 221199, "file_size": 38120227, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 3400807253, "table_properties": {"data_size": 33558064, "index_size": 1756544, "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": 25848340, "raw_average_key_size": 28, "raw_value_size": 108369502, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 923155, "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": 1732272269, "oldest_key_time": 0, "file_creation_time": 1732272269, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "U1ECJGOXSO4Y1P7ZZXV1", "orig_file_number": 221199, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/22-18:44:32.405755 140024785397312 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221200.sst) /dev/shm/ToplingTemp/Topling-245159-tfzJTX 2024/11/22-18:44:33.264857 140024785397312 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221200.sst): first pass time = 0.86's, 156.248'MB/sec 2024/11/22-18:44:34.718875 140024785397312 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221200.sst): old prealloc_size = 147639500, real_size = 33785664 2024/11/22-18:44:34.719459 140024785397312 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221200.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 922824 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.0318 GB avg-val = 117.44 avg-zval = 34.46 2024/11/22-18:44:34.720196 140024785397312 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221200.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/22-18:44:35.648808 140024785397312 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221200.sst): second pass time = 1.45's, 74.575'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.93's, 40.604'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3106.617'MB/sec (index lex order gen) rebuild zvType time = 0.80's, 0.287'MB/sec write SST data time = 0.13's, 300.181'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.083'MB, throughput = 30252.779'MB/sec zip my value time = 1.45's, unzip length = 0.108'GB zip my value throughput = 74.575'MB/sec zip pipeline throughput = 74.575'MB/sec entries = 922824 avg-key = 28.00 avg-zkey = 1.90 avg-val = 117.44 avg-zval = 34.46 usrkeys = 922824 avg-key = 20.00 avg-zkey = 1.90 avg-val = 124.44 avg-zval = 34.46 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 922824 bytes = 3114544 } seq expand size = 6459768 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0185 GB value = 0.1084 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0318 GB dict = 1.08 MB all = 0.0378 GB } UnZip/Zip{ index = 10.5138 value = 3.4082 dict = 1.00 all = 3.5546 } Zip/UnZip{ index = 0.0951 value = 0.2934 dict = 1.00 all = 0.2813 } ---------------------------- total value len = 0.902874 GB avg = 0.122 KB (by entry num) total key len = 0.207499 GB avg = 0.028 KB total ukey len = 0.148213 GB avg = 0.020 KB total ukey num = 0.007410668 Billion total entry num = 0.007410668 Billion write speed all = 0.031249441 MB/sec (with seq num) write speed all = 0.029580961 MB/sec (without seq num) 2024/11/22-18:44:35.681941 140024785397312 [compaction_job.cc:1948] [default] [JOB 7862] Generated table #221200: 922824 keys, 37758454 bytes, temperature: kWarm 2024/11/22-18:44:35.682007 140024785397312 EVENT_LOG_v1 {"time_micros": 1732272275681974, "cf_name": "default", "job": 7862, "event": "table_file_creation", "file_number": 221200, "file_size": 37758454, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3373736573, "largest_seqno": 3474945765, "table_properties": {"data_size": 31799344, "index_size": 1755456, "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": 25839072, "raw_average_key_size": 28, "raw_value_size": 108378660, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 922824, "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": 1732272272, "oldest_key_time": 0, "file_creation_time": 1732272272, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "U1ECJGOXSO4Y1P7ZZXV1", "orig_file_number": 221200, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/22-18:44:35.718013 140024785397312 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221201.sst) /dev/shm/ToplingTemp/Topling-245159-LuEg0Y 2024/11/22-18:44:36.552506 140024785397312 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221201.sst): first pass time = 0.83's, 160.846'MB/sec 2024/11/22-18:44:38.024968 140024785397312 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221201.sst): old prealloc_size = 147639500, real_size = 32856992 2024/11/22-18:44:38.025546 140024785397312 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221201.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 922749 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1084 GB zip-val = 0.0309 GB avg-val = 117.45 avg-zval = 33.44 2024/11/22-18:44:38.026885 140024785397312 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221201.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/22-18:44:38.940965 140024785397312 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221201.sst): second pass time = 1.47's, 73.640'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.92's, 40.333'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3167.220'MB/sec (index lex order gen) rebuild zvType time = 0.79's, 0.293'MB/sec write SST data time = 0.13's, 286.390'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.083'MB, throughput = 26365.257'MB/sec zip my value time = 1.47's, unzip length = 0.108'GB zip my value throughput = 73.640'MB/sec zip pipeline throughput = 82.867'MB/sec entries = 922749 avg-key = 28.00 avg-zkey = 1.91 avg-val = 117.45 avg-zval = 33.44 usrkeys = 922749 avg-key = 20.00 avg-zkey = 1.91 avg-val = 124.45 avg-zval = 33.44 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 922749 bytes = 3229632 } seq expand size = 6459243 multi value expand size = 0 cnt WriteAppend = 14 UnZipSize{ index = 0.0185 GB value = 0.1084 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0309 GB dict = 1.08 MB all = 0.0369 GB } UnZip/Zip{ index = 10.4444 value = 3.5121 dict = 1.00 all = 3.6330 } Zip/UnZip{ index = 0.0957 value = 0.2847 dict = 1.00 all = 0.2753 } ---------------------------- total value len = 1.017714 GB avg = 0.122 KB (by entry num) total key len = 0.233336 GB avg = 0.028 KB total ukey len = 0.166668 GB avg = 0.020 KB total ukey num = 0.008333417 Billion total entry num = 0.008333417 Billion write speed all = 0.035205283 MB/sec (with seq num) write speed all = 0.033329224 MB/sec (without seq num) 2024/11/22-18:44:38.975615 140024785397312 [compaction_job.cc:1948] [default] [JOB 7862] Generated table #221201: 922749 keys, 36944390 bytes, temperature: kWarm 2024/11/22-18:44:38.975680 140024785397312 EVENT_LOG_v1 {"time_micros": 1732272278975647, "cf_name": "default", "job": 7862, "event": "table_file_creation", "file_number": 221201, "file_size": 36944390, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3303265604, "largest_seqno": 3474946295, "table_properties": {"data_size": 30859152, "index_size": 1766976, "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": 25836972, "raw_average_key_size": 28, "raw_value_size": 108380850, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 922749, "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": 1732272275, "oldest_key_time": 0, "file_creation_time": 1732272275, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "U1ECJGOXSO4Y1P7ZZXV1", "orig_file_number": 221201, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/22-18:44:39.015873 140024785397312 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221202.sst) /dev/shm/ToplingTemp/Topling-245159-1qjQvZ 2024/11/22-18:44:39.856424 140024785397312 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221202.sst): first pass time = 0.84's, 159.686'MB/sec 2024/11/22-18:44:41.300473 140024785397312 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221202.sst): old prealloc_size = 147639500, real_size = 33123920 2024/11/22-18:44:41.301056 140024785397312 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221202.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 924629 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.0311 GB avg-val = 117.16 avg-zval = 33.66 2024/11/22-18:44:41.301840 140024785397312 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221202.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/22-18:44:42.223800 140024785397312 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221202.sst): second pass time = 1.44's, 75.049'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.92's, 40.308'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3148.744'MB/sec (index lex order gen) rebuild zvType time = 0.80's, 0.291'MB/sec write SST data time = 0.13's, 291.574'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.081'MB, throughput = 32054.658'MB/sec zip my value time = 1.44's, unzip length = 0.108'GB zip my value throughput = 75.049'MB/sec zip pipeline throughput = 75.049'MB/sec entries = 924629 avg-key = 28.00 avg-zkey = 1.92 avg-val = 117.16 avg-zval = 33.66 usrkeys = 924629 avg-key = 20.00 avg-zkey = 1.92 avg-val = 124.16 avg-zval = 33.66 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 924629 bytes = 3236224 } seq expand size = 6472403 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.0311 GB dict = 1.08 MB all = 0.0372 GB } UnZip/Zip{ index = 10.4418 value = 3.4808 dict = 1.00 all = 3.6064 } Zip/UnZip{ index = 0.0958 value = 0.2873 dict = 1.00 all = 0.2773 } ---------------------------- total value len = 1.132514 GB avg = 0.122 KB (by entry num) total key len = 0.259225 GB avg = 0.028 KB total ukey len = 0.185161 GB avg = 0.020 KB total ukey num = 0.009258046 Billion total entry num = 0.009258046 Billion write speed all = 0.039160771 MB/sec (with seq num) write speed all = 0.037076747 MB/sec (without seq num) 2024/11/22-18:44:42.258920 140024785397312 [compaction_job.cc:1948] [default] [JOB 7862] Generated table #221202: 924629 keys, 37216228 bytes, temperature: kWarm 2024/11/22-18:44:42.258987 140024785397312 EVENT_LOG_v1 {"time_micros": 1732272282258954, "cf_name": "default", "job": 7862, "event": "table_file_creation", "file_number": 221202, "file_size": 37216228, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3273701386, "largest_seqno": 3474944818, "table_properties": {"data_size": 31121600, "index_size": 1771008, "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": 25889612, "raw_average_key_size": 28, "raw_value_size": 108328134, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 924629, "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": 1732272279, "oldest_key_time": 0, "file_creation_time": 1732272279, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "U1ECJGOXSO4Y1P7ZZXV1", "orig_file_number": 221202, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/22-18:44:42.300583 140024785397312 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221203.sst) /dev/shm/ToplingTemp/Topling-245159-zxRQOY 2024/11/22-18:44:43.129687 140024785397312 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221203.sst): first pass time = 0.83's, 161.890'MB/sec 2024/11/22-18:44:44.705868 140024785397312 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221203.sst): old prealloc_size = 147639500, real_size = 33656736 2024/11/22-18:44:44.706447 140024785397312 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221203.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 924129 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.0317 GB avg-val = 117.24 avg-zval = 34.27 2024/11/22-18:44:44.707209 140024785397312 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221203.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/22-18:44:45.617897 140024785397312 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221203.sst): second pass time = 1.57's, 68.790'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.91's, 41.263'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3138.515'MB/sec (index lex order gen) rebuild zvType time = 0.78's, 0.295'MB/sec write SST data time = 0.13's, 294.481'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.082'MB, throughput = 31212.198'MB/sec zip my value time = 1.57's, unzip length = 0.108'GB zip my value throughput = 68.790'MB/sec zip pipeline throughput = 123.063'MB/sec entries = 924129 avg-key = 28.00 avg-zkey = 1.90 avg-val = 117.24 avg-zval = 34.27 usrkeys = 924129 avg-key = 20.00 avg-zkey = 1.90 avg-val = 124.24 avg-zval = 34.27 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 924129 bytes = 3118944 } seq expand size = 6468903 multi value expand size = 0 cnt WriteAppend = 12 UnZipSize{ index = 0.0185 GB value = 0.1083 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0317 GB dict = 1.08 MB all = 0.0376 GB } UnZip/Zip{ index = 10.5129 value = 3.4213 dict = 1.00 all = 3.5666 } Zip/UnZip{ index = 0.0951 value = 0.2923 dict = 1.00 all = 0.2804 } ---------------------------- total value len = 1.247325 GB avg = 0.123 KB (by entry num) total key len = 0.285101 GB avg = 0.028 KB total ukey len = 0.203644 GB avg = 0.020 KB total ukey num = 0.010182175 Billion total entry num = 0.010182175 Billion write speed all = 0.043115294 MB/sec (with seq num) write speed all = 0.040823464 MB/sec (without seq num) 2024/11/22-18:44:45.651293 140024785397312 [compaction_job.cc:1948] [default] [JOB 7862] Generated table #221203: 924129 keys, 37632262 bytes, temperature: kWarm 2024/11/22-18:44:45.651356 140024785397312 EVENT_LOG_v1 {"time_micros": 1732272285651323, "cf_name": "default", "job": 7862, "event": "table_file_creation", "file_number": 221203, "file_size": 37632262, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3376774735, "largest_seqno": 3474945703, "table_properties": {"data_size": 31667408, "index_size": 1758080, "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": 25875612, "raw_average_key_size": 28, "raw_value_size": 108342130, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 924129, "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": 1732272282, "oldest_key_time": 0, "file_creation_time": 1732272282, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "U1ECJGOXSO4Y1P7ZZXV1", "orig_file_number": 221203, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/22-18:44:45.687290 140024785397312 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221204.sst) /dev/shm/ToplingTemp/Topling-245159-4nMO9Y 2024/11/22-18:44:45.893240 140024785397312 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221204.sst): first pass time = 0.21's, 169.059'MB/sec 2024/11/22-18:44:46.237283 140024785397312 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221204.sst): old prealloc_size = 147639500, real_size = 9633360 2024/11/22-18:44:46.237471 140024785397312 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221204.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 239442 prefix = 4 raw-key = 0.0038 GB zip-key = 0.0005 GB avg-key = 16.00 avg-zkey = 1.92 raw-val = 0.0281 GB zip-val = 0.0091 GB avg-val = 117.39 avg-zval = 38.06 2024/11/22-18:44:46.237683 140024785397312 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221204.sst: sumWaitingMem = 0.001 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0005 GB, waited 0.000 sec, Key+Value = 0.035 GB 2024/11/22-18:44:46.473973 140024785397312 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00/221204.sst): second pass time = 0.34's, 81.831'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.24's, 44.964'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2825.004'MB/sec (index lex order gen) rebuild zvType time = 0.20's, 0.296'MB/sec write SST data time = 0.03's, 310.117'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.289'MB, throughput = 9238.232'MB/sec zip my value time = 0.34's, unzip length = 0.028'GB zip my value throughput = 81.831'MB/sec zip pipeline throughput = 81.831'MB/sec entries = 239442 avg-key = 28.00 avg-zkey = 1.92 avg-val = 117.39 avg-zval = 38.06 usrkeys = 239442 avg-key = 20.00 avg-zkey = 1.92 avg-val = 124.39 avg-zval = 38.06 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 239442 bytes = 778208 } seq expand size = 1676094 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0048 GB value = 0.0281 GB dict = 0.29 MB all = 0.0348 GB } __ZipSize{ index = 0.0005 GB value = 0.0091 GB dict = 0.29 MB all = 0.0106 GB } UnZip/Zip{ index = 10.4185 value = 3.0841 dict = 1.00 all = 3.2712 } Zip/UnZip{ index = 0.0960 value = 0.3242 dict = 1.00 all = 0.3057 } ---------------------------- total value len = 1.277109 GB avg = 0.123 KB (by entry num) total key len = 0.291805 GB avg = 0.028 KB total ukey len = 0.208432 GB avg = 0.020 KB total ukey num = 0.010421617 Billion total entry num = 0.010421617 Billion write speed all = 0.044140823 MB/sec (with seq num) write speed all = 0.041795156 MB/sec (without seq num) 2024/11/22-18:44:46.490099 140024785397312 [compaction_job.cc:1948] [default] [JOB 7862] Generated table #221204: 239442 keys, 10641869 bytes, temperature: kWarm 2024/11/22-18:44:46.490161 140024785397312 EVENT_LOG_v1 {"time_micros": 1732272286490129, "cf_name": "default", "job": 7862, "event": "table_file_creation", "file_number": 221204, "file_size": 10641869, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3432691650, "largest_seqno": 3473946460, "table_properties": {"data_size": 9113664, "index_size": 459648, "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": 6704376, "raw_average_key_size": 28, "raw_value_size": 28107204, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 239442, "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": 1732272285, "oldest_key_time": 0, "file_creation_time": 1732272285, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "U1ECJGOXSO4Y1P7ZZXV1", "orig_file_number": 221204, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/22-18:44:46.506647 140024785397312 [compaction_job.cc:703] job-07862: subcompact[0], size: 0.428673 G, files: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-07862/att-00 [221193,221194,221195,221196,221197,221198,221199,221200,221201,221202,221203,221204] 2024/11/22-18:44:46.588116 140024785397312 (Original Log Time 2024/11/22-18:44:00.245959) EVENT_LOG_v1 {"time_micros": 1732272240245896, "job": 7862, "event": "compaction_started", "compaction_reason": "FilesMarkedForCompaction", "files_L2": [221190], "files_L3": [221141, 221142, 221143, 221144, 221145, 221146, 221147, 221148, 221149, 221150, 221151, 221152], "score": 0.955386, "input_data_size": 450189275, "oldest_snapshot_seqno": 3474995116} 2024/11/22-18:44:46.588120 140024785397312 (Original Log Time 2024/11/22-18:44:46.587439) [compaction_job.cc:2022] [default] [JOB 7862] Compacted 1@2 + 12@3 files to L3 => 428673393 bytes 2024/11/22-18:44:46.588121 140024785397312 (Original Log Time 2024/11/22-18:44:46.588040) [compaction_job.cc:1224] [default] compacted to: files[0 0 0 12 0 0 0] max score 0.02, MB/sec: 9.7 rd, 9.3 wr, level 3, files in(1, 12) out(12 +0 blob) MB in(27.2, 402.2 +0.0 blob) out(408.8 +0.0 blob), read-write-amplify(30.8) write-amplify(15.0) OK, records in: 10531690, records dropped: 110073 output_compression: Snappy 2024/11/22-18:44:46.588128 140024785397312 (Original Log Time 2024/11/22-18:44:46.588096) EVENT_LOG_v1 {"time_micros": 1732272286588075, "cf": "default", "job": 7862, "event": "compaction_finished", "compaction_time_micros": 46260696, "compaction_time_cpu_micros": 18584616, "output_level": 3, "num_output_files": 12, "total_output_size": 428673393, "num_input_records": 10531690, "num_output_records": 10421617, "num_subcompactions": 1, "output_compression": "Snappy", "num_single_delete_mismatches": 0, "num_single_delete_fallthrough": 0, "file_write_nanos": 313974489, "file_range_sync_nanos": 0, "file_fsync_nanos": 11976, "file_prepare_write_nanos": 29429, "lsm_state": [0, 0, 0, 12, 0, 0, 0]} 2024/11/22-18:44:46.729583 140024785397312 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":1732256054,"starts":1732272240,"executesMs":46488,"compactionJobId":7862,"attempt":0,"compactionInputRawBytes":1526837388,"compactionInputZipBytes":450189275,"compactionOutputRawBytes":0,"compactionOutputZipBytes":428673393,"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-7a866f149d0f6654b22cb4ba8b96927e-d5ed7275e42d5aaf-00"}}, response = 2024/11/22-18:44:46.729674 140024785397312 INFO dcompact_worker.cpp:1459: finish /worker/dcompact-log/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/2024-11-22T14.14.14/.rocksdb/job-07862/att-00: olev 3, work 46.488 s, result 4.985 ms, install 0.707 ms, input{raw 1.422 GiB zip 429.334 MiB}