2024/11/23-09:15:04.275912 139957542479424 DEBG dcompact_worker.cpp:2214: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00: fork to child time = 0.007199 sec 2024/11/23-09:15:04.276441 139957542479424 DEBG dcompact_worker.cpp:1013: Beg SerDeRead: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00 2024/11/23-09:15:04.283362 139957542479424 DEBG dcompact_worker.cpp:1033: End SerDeRead: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00 2024/11/23-09:15:04.284236 139957542479424 TRAC dcompact_worker.cpp:1083: INFO_LOG_LEVEL: rpc = INFO_LEVEL, env_var = undefined 2024/11/23-09:15:04.284470 139957542479424 [WARN] [column_family.cc:386] multiple cf_paths/db_paths and level_compaction_dynamic_level_bytes can't be used together 2024/11/23-09:15:04.331014 139957542479424 [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-23345/att-00/MANIFEST-206347 2024/11/23-09:15:04.363099 139957542479424 [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-23345/att-00/MANIFEST-206347 succeeded,manifest_file_number is 206347, next_file_number is 253817, last_sequence is 3901920594, log_number is 0,prev_log_number is 0,max_column_family is 0,min_log_number_to_keep is 253604 2024/11/23-09:15:04.363105 139957542479424 [version_set.cc:6266] Column family [default] (ID 0), log number is 0 2024/11/23-09:15:04.363226 139957542479424 [version_set.cc:5721] Creating manifest 253817 2024/11/23-09:15:04.393563 139957542479424 DEBG dcompact_worker.cpp:1218: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00: bottommost_level: fake = 1, rpc = 0 2024/11/23-09:15:04.413683 139957542479424 [compaction_job.cc:2437] [default] [JOB 23345] Compacting 1@2 + 16@3 files to L3, score 1.00, subcompactions 1 : 1 2024/11/23-09:15:04.413696 139957542479424 [compaction_job.cc:2445] [default]: Compaction start summary: Base version 17528 Base level 2, inputs: [253750(27MB)], [253803(35MB) 253804(15MB) 253678(34MB) 253679(33MB) 253680(33MB) 253681(33MB) 253682(34MB) 253683(35MB) 253684(35MB) 253685(35MB) 253686(35MB) 253687(35MB) 253688(35MB) 253689(34MB) 253701(34MB) 253702(34MB)] 2024/11/23-09:15:04.419471 139957542479424 [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/23-09:15:04.419498 139957542479424 [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/23-09:15:04.419517 139957542479424 [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/23-09:15:04.419522 139957542479424 [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/23-09:15:04.419532 139957542479424 [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/23-09:15:05.263484 139957542479424 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253818.sst) /dev/shm/ToplingTemp/Topling-10392-uveYtZ 2024/11/23-09:15:05.812833 139957542479424 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253818.sst): first pass time = 0.55's, 244.341'MB/sec 2024/11/23-09:15:07.092296 139957542479424 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253818.sst): old prealloc_size = 147639500, real_size = 32910944 2024/11/23-09:15:07.092805 139957542479424 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253818.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 929769 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.0309 GB avg-val = 116.36 avg-zval = 33.24 2024/11/23-09:15:07.093635 139957542479424 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253818.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/23-09:15:07.934620 139957542479424 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253818.sst): second pass time = 1.28's, 84.622'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.84's, 44.086'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3626.730'MB/sec (index lex order gen) rebuild zvType time = 0.72's, 0.322'MB/sec write SST data time = 0.12's, 311.889'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.079'MB, throughput = 34643.724'MB/sec zip my value time = 1.28's, unzip length = 0.108'GB zip my value throughput = 84.622'MB/sec zip pipeline throughput = 84.622'MB/sec entries = 929769 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.36 avg-zval = 33.24 usrkeys = 929769 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.36 avg-zval = 33.24 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 929769 bytes = 3370432 } seq expand size = 6508383 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.0309 GB dict = 1.08 MB all = 0.0371 GB } UnZip/Zip{ index = 10.5139 value = 3.5000 dict = 1.00 all = 3.6144 } Zip/UnZip{ index = 0.0951 value = 0.2857 dict = 1.00 all = 0.2767 } ---------------------------- total value len = 8.963312 GB avg = 0.168 KB (by entry num) total key len = 1.466855 GB avg = 0.028 KB total ukey len = 1.016473 GB avg = 0.015 KB total ukey num = 0.066480204 Billion total entry num = 0.053287933 Billion write speed all = 8.722917767 MB/sec (with seq num) write speed all = 8.366393268 MB/sec (without seq num) 2024/11/23-09:15:07.979054 139957542479424 [compaction_job.cc:1948] [default] [JOB 23345] Generated table #253818: 929769 keys, 37133888 bytes, temperature: kWarm 2024/11/23-09:15:07.979151 139957542479424 EVENT_LOG_v1 {"time_micros": 1732324507979091, "cf_name": "default", "job": 23345, "event": "table_file_creation", "file_number": 253818, "file_size": 37133888, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3621075956, "largest_seqno": 3901580143, "table_properties": {"data_size": 30909648, "index_size": 1768640, "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": 26033532, "raw_average_key_size": 28, "raw_value_size": 108184222, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 929769, "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": 1732324505, "oldest_key_time": 0, "file_creation_time": 1732324505, "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": 253818, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-09:15:08.013450 139957542479424 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253819.sst) /dev/shm/ToplingTemp/Topling-10392-Jze310 2024/11/23-09:15:09.087343 139957542479424 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253819.sst): first pass time = 1.07's, 124.986'MB/sec 2024/11/23-09:15:10.361346 139957542479424 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253819.sst): old prealloc_size = 147639500, real_size = 32018816 2024/11/23-09:15:10.361876 139957542479424 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253819.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 929564 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.0300 GB avg-val = 116.39 avg-zval = 32.29 2024/11/23-09:15:10.362686 139957542479424 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253819.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/23-09:15:11.192959 139957542479424 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253819.sst): second pass time = 1.27's, 84.973'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.83's, 43.581'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3500.321'MB/sec (index lex order gen) rebuild zvType time = 0.71's, 0.327'MB/sec write SST data time = 0.12's, 302.744'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 = 29390.504'MB/sec zip my value time = 1.27's, unzip length = 0.108'GB zip my value throughput = 84.973'MB/sec zip pipeline throughput = 84.973'MB/sec entries = 929564 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.39 avg-zval = 32.29 usrkeys = 929564 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.39 avg-zval = 32.29 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 929564 bytes = 3369680 } seq expand size = 6506948 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.0300 GB dict = 1.08 MB all = 0.0362 GB } UnZip/Zip{ index = 10.5135 value = 3.6042 dict = 1.00 all = 3.7034 } Zip/UnZip{ index = 0.0951 value = 0.2775 dict = 1.00 all = 0.2700 } ---------------------------- total value len = 9.078009 GB avg = 0.167 KB (by entry num) total key len = 1.492882 GB avg = 0.028 KB total ukey len = 1.035065 GB avg = 0.015 KB total ukey num = 0.067409768 Billion total entry num = 0.054217497 Billion write speed all = 8.816582991 MB/sec (with seq num) write speed all = 8.454825005 MB/sec (without seq num) 2024/11/23-09:15:11.236571 139957542479424 [compaction_job.cc:1948] [default] [JOB 23345] Generated table #253819: 929564 keys, 36241508 bytes, temperature: kWarm 2024/11/23-09:15:11.236640 139957542479424 EVENT_LOG_v1 {"time_micros": 1732324511236603, "cf_name": "default", "job": 23345, "event": "table_file_creation", "file_number": 253819, "file_size": 36241508, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3376774746, "largest_seqno": 3901580470, "table_properties": {"data_size": 30017904, "index_size": 1768320, "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": 26027792, "raw_average_key_size": 28, "raw_value_size": 108189972, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 929564, "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": 1732324507, "oldest_key_time": 0, "file_creation_time": 1732324507, "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": 253819, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-09:15:11.274446 139957542479424 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253820.sst) /dev/shm/ToplingTemp/Topling-10392-jRfl7X 2024/11/23-09:15:12.223076 139957542479424 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253820.sst): first pass time = 0.95's, 141.491'MB/sec 2024/11/23-09:15:13.506740 139957542479424 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253820.sst): old prealloc_size = 147639500, real_size = 33624592 2024/11/23-09:15:13.507282 139957542479424 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253820.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 926013 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.0316 GB avg-val = 116.94 avg-zval = 34.15 2024/11/23-09:15:13.508101 139957542479424 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253820.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/23-09:15:14.354041 139957542479424 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253820.sst): second pass time = 1.28's, 84.414'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.85's, 44.656'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3396.789'MB/sec (index lex order gen) rebuild zvType time = 0.73's, 0.319'MB/sec write SST data time = 0.12's, 315.111'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 = 35006.090'MB/sec zip my value time = 1.28's, unzip length = 0.108'GB zip my value throughput = 84.414'MB/sec zip pipeline throughput = 84.414'MB/sec entries = 926013 avg-key = 28.00 avg-zkey = 1.92 avg-val = 116.94 avg-zval = 34.15 usrkeys = 926013 avg-key = 20.00 avg-zkey = 1.92 avg-val = 123.94 avg-zval = 34.15 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 926013 bytes = 3356816 } seq expand size = 6482091 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0185 GB value = 0.1083 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0316 GB dict = 1.08 MB all = 0.0378 GB } UnZip/Zip{ index = 10.4431 value = 3.4248 dict = 1.00 all = 3.5473 } Zip/UnZip{ index = 0.0958 value = 0.2920 dict = 1.00 all = 0.2819 } ---------------------------- total value len = 9.192781 GB avg = 0.167 KB (by entry num) total key len = 1.518811 GB avg = 0.028 KB total ukey len = 1.053585 GB avg = 0.015 KB total ukey num = 0.068335781 Billion total entry num = 0.055143510 Billion write speed all = 8.910440532 MB/sec (with seq num) write speed all = 8.543471373 MB/sec (without seq num) 2024/11/23-09:15:14.399239 139957542479424 [compaction_job.cc:1948] [default] [JOB 23345] Generated table #253820: 926013 keys, 37836436 bytes, temperature: kWarm 2024/11/23-09:15:14.399308 139957542479424 EVENT_LOG_v1 {"time_micros": 1732324514399272, "cf_name": "default", "job": 23345, "event": "table_file_creation", "file_number": 253820, "file_size": 37836436, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3563652023, "largest_seqno": 3901579665, "table_properties": {"data_size": 31619456, "index_size": 1773440, "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": 25928364, "raw_average_key_size": 28, "raw_value_size": 108289366, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 926013, "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": 1732324511, "oldest_key_time": 0, "file_creation_time": 1732324511, "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": 253820, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-09:15:14.432787 139957542479424 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253821.sst) /dev/shm/ToplingTemp/Topling-10392-1aA6fY 2024/11/23-09:15:15.432959 139957542479424 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253821.sst): first pass time = 1.00's, 134.199'MB/sec 2024/11/23-09:15:16.766679 139957542479424 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253821.sst): old prealloc_size = 147639500, real_size = 33134912 2024/11/23-09:15:16.767216 139957542479424 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253821.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 929779 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.0311 GB avg-val = 116.35 avg-zval = 33.48 2024/11/23-09:15:16.768020 139957542479424 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253821.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/23-09:15:17.623423 139957542479424 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253821.sst): second pass time = 1.33's, 81.181'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.86's, 43.470'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3422.797'MB/sec (index lex order gen) rebuild zvType time = 0.74's, 0.316'MB/sec write SST data time = 0.12's, 309.184'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.079'MB, throughput = 36071.424'MB/sec zip my value time = 1.33's, unzip length = 0.108'GB zip my value throughput = 81.181'MB/sec zip pipeline throughput = 81.181'MB/sec entries = 929779 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.35 avg-zval = 33.48 usrkeys = 929779 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.35 avg-zval = 33.48 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 929779 bytes = 3254240 } seq expand size = 6508453 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.0311 GB dict = 1.08 MB all = 0.0372 GB } UnZip/Zip{ index = 10.5133 value = 3.4748 dict = 1.00 all = 3.6040 } Zip/UnZip{ index = 0.0951 value = 0.2878 dict = 1.00 all = 0.2775 } ---------------------------- total value len = 9.307473 GB avg = 0.166 KB (by entry num) total key len = 1.544845 GB avg = 0.028 KB total ukey len = 1.072181 GB avg = 0.015 KB total ukey num = 0.069265560 Billion total entry num = 0.056073289 Billion write speed all = 9.003018815 MB/sec (with seq num) write speed all = 8.630874259 MB/sec (without seq num) 2024/11/23-09:15:17.667851 139957542479424 [compaction_job.cc:1948] [default] [JOB 23345] Generated table #253821: 929779 keys, 37241264 bytes, temperature: kWarm 2024/11/23-09:15:17.667920 139957542479424 EVENT_LOG_v1 {"time_micros": 1732324517667884, "cf_name": "default", "job": 23345, "event": "table_file_creation", "file_number": 253821, "file_size": 37241264, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3759280178, "largest_seqno": 3901580243, "table_properties": {"data_size": 31133488, "index_size": 1768768, "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": 26033812, "raw_average_key_size": 28, "raw_value_size": 108184026, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 929779, "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": 1732324514, "oldest_key_time": 0, "file_creation_time": 1732324514, "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": 253821, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-09:15:17.700231 139957542479424 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253822.sst) /dev/shm/ToplingTemp/Topling-10392-8oMmiY 2024/11/23-09:15:18.555890 139957542479424 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253822.sst): first pass time = 0.86's, 156.866'MB/sec 2024/11/23-09:15:19.860531 139957542479424 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253822.sst): old prealloc_size = 147639500, real_size = 32951312 2024/11/23-09:15:19.861054 139957542479424 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253822.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 930655 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.0309 GB avg-val = 116.22 avg-zval = 33.25 2024/11/23-09:15:19.861800 139957542479424 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253822.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/23-09:15:20.714816 139957542479424 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253822.sst): second pass time = 1.30's, 82.952'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.85's, 43.246'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3608.296'MB/sec (index lex order gen) rebuild zvType time = 0.73's, 0.317'MB/sec write SST data time = 0.12's, 305.819'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.078'MB, throughput = 38093.081'MB/sec zip my value time = 1.30's, unzip length = 0.108'GB zip my value throughput = 82.952'MB/sec zip pipeline throughput = 82.952'MB/sec entries = 930655 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.22 avg-zval = 33.25 usrkeys = 930655 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.22 avg-zval = 33.25 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 930655 bytes = 3140976 } seq expand size = 6514585 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.0309 GB dict = 1.08 MB all = 0.0369 GB } UnZip/Zip{ index = 10.5148 value = 3.4948 dict = 1.00 all = 3.6331 } Zip/UnZip{ index = 0.0951 value = 0.2861 dict = 1.00 all = 0.2752 } ---------------------------- total value len = 9.422147 GB avg = 0.165 KB (by entry num) total key len = 1.570903 GB avg = 0.028 KB total ukey len = 1.090794 GB avg = 0.016 KB total ukey num = 0.070196215 Billion total entry num = 0.057003944 Billion write speed all = 9.096440805 MB/sec (with seq num) write speed all = 8.719087482 MB/sec (without seq num) 2024/11/23-09:15:20.760252 139957542479424 [compaction_job.cc:1948] [default] [JOB 23345] Generated table #253822: 930655 keys, 36943382 bytes, temperature: kWarm 2024/11/23-09:15:20.760319 139957542479424 EVENT_LOG_v1 {"time_micros": 1732324520760283, "cf_name": "default", "job": 23345, "event": "table_file_creation", "file_number": 253822, "file_size": 36943382, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3801926538, "largest_seqno": 3901579164, "table_properties": {"data_size": 30948288, "index_size": 1770176, "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": 26058340, "raw_average_key_size": 28, "raw_value_size": 108159438, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 930655, "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": 1732324517, "oldest_key_time": 0, "file_creation_time": 1732324517, "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": 253822, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-09:15:20.792330 139957542479424 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253823.sst) /dev/shm/ToplingTemp/Topling-10392-8VDUg1 2024/11/23-09:15:21.832855 139957542479424 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253823.sst): first pass time = 1.04's, 128.996'MB/sec 2024/11/23-09:15:23.098592 139957542479424 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253823.sst): old prealloc_size = 147639500, real_size = 33610464 2024/11/23-09:15:23.099199 139957542479424 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253823.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 1088254 prefix = 4 raw-key = 0.0174 GB zip-key = 0.0021 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1037 GB zip-val = 0.0313 GB avg-val = 95.33 avg-zval = 28.72 2024/11/23-09:15:23.099578 139957542479424 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253823.sst: sumWaitingMem = 0.003 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0029 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/23-09:15:23.826904 139957542479424 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253823.sst): second pass time = 1.26's, 82.042'MB/sec, value only(77.3% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.73's, 48.963'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3571.012'MB/sec (index lex order gen) rebuild zvType time = 0.59's, 0.458'MB/sec write SST data time = 0.13's, 267.543'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.034'MB, throughput = 28354.871'MB/sec zip my value time = 1.26's, unzip length = 0.104'GB zip my value throughput = 82.042'MB/sec zip pipeline throughput = 82.042'MB/sec entries = 1088254 avg-key = 28.00 avg-zkey = 1.91 avg-val = 95.33 avg-zval = 28.72 usrkeys = 1088254 avg-key = 20.00 avg-zkey = 1.91 avg-val = 97.52 avg-zval = 28.72 TagRS{ kinds = RS_Key0_TagN bytes = 170120 } TagArray{ size = 339996 bytes = 1105008 } seq expand size = 2379972 multi value expand size = 0 cnt WriteAppend = 17 UnZipSize{ index = 0.0218 GB value = 0.1037 GB dict = 1.03 MB all = 0.1342 GB } __ZipSize{ index = 0.0021 GB value = 0.0313 GB dict = 1.03 MB all = 0.0357 GB } UnZip/Zip{ index = 10.4476 value = 3.3194 dict = 1.00 all = 3.7639 } Zip/UnZip{ index = 0.0957 value = 0.3013 dict = 1.00 all = 0.2657 } ---------------------------- total value len = 9.528274 GB avg = 0.164 KB (by entry num) total key len = 1.601374 GB avg = 0.028 KB total ukey len = 1.112559 GB avg = 0.016 KB total ukey num = 0.071284469 Billion total entry num = 0.058092198 Billion write speed all = 9.185816657 MB/sec (with seq num) write speed all = 8.802247092 MB/sec (without seq num) 2024/11/23-09:15:23.870807 139957542479424 [compaction_job.cc:1948] [default] [JOB 23345] Generated table #253823: 1088254 keys, 35658856 bytes, temperature: kWarm 2024/11/23-09:15:23.870874 139957542479424 EVENT_LOG_v1 {"time_micros": 1732324523870839, "cf_name": "default", "job": 23345, "event": "table_file_creation", "file_number": 253823, "file_size": 35658856, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 3901579420, "table_properties": {"data_size": 31254928, "index_size": 2083264, "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": 30471112, "raw_average_key_size": 28, "raw_value_size": 103746741, "raw_average_value_size": 95, "num_data_blocks": 1, "num_entries": 1088254, "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": 1732324520, "oldest_key_time": 0, "file_creation_time": 1732324520, "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": 253823, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-09:15:23.903674 139957542479424 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253824.sst) /dev/shm/ToplingTemp/Topling-10392-dlpSEY 2024/11/23-09:15:24.731477 139957542479424 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253824.sst): first pass time = 0.83's, 162.144'MB/sec 2024/11/23-09:15:26.175015 139957542479424 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253824.sst): old prealloc_size = 147639500, real_size = 36579936 2024/11/23-09:15:26.175506 139957542479424 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253824.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 924482 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.0346 GB avg-val = 117.18 avg-zval = 37.42 2024/11/23-09:15:26.175846 139957542479424 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253824.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/23-09:15:26.905857 139957542479424 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253824.sst): second pass time = 1.44's, 75.087'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.73's, 52.788'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3792.881'MB/sec (index lex order gen) rebuild zvType time = 0.61's, 0.380'MB/sec write SST data time = 0.12's, 317.073'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 = 34785.025'MB/sec zip my value time = 1.44's, unzip length = 0.108'GB zip my value throughput = 75.087'MB/sec zip pipeline throughput = 75.087'MB/sec entries = 924482 avg-key = 28.00 avg-zkey = 1.90 avg-val = 117.18 avg-zval = 37.42 usrkeys = 924482 avg-key = 20.00 avg-zkey = 1.90 avg-val = 119.33 avg-zval = 37.42 TagRS{ kinds = RS_Key0_TagN bytes = 144560 } TagArray{ size = 284337 bytes = 995200 } seq expand size = 1990359 multi value expand size = 0 cnt WriteAppend = 14 UnZipSize{ index = 0.0185 GB value = 0.1083 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0346 GB dict = 1.08 MB all = 0.0386 GB } UnZip/Zip{ index = 10.5139 value = 3.1319 dict = 1.00 all = 3.4790 } Zip/UnZip{ index = 0.0951 value = 0.3193 dict = 1.00 all = 0.2874 } ---------------------------- total value len = 9.638597 GB avg = 0.163 KB (by entry num) total key len = 1.627260 GB avg = 0.028 KB total ukey len = 1.131048 GB avg = 0.016 KB total ukey num = 0.072208951 Billion total entry num = 0.059016680 Billion write speed all = 9.274666744 MB/sec (with seq num) write speed all = 8.885980765 MB/sec (without seq num) 2024/11/23-09:15:26.952595 139957542479424 [compaction_job.cc:1948] [default] [JOB 23345] Generated table #253824: 924482 keys, 38579727 bytes, temperature: kWarm 2024/11/23-09:15:26.952664 139957542479424 EVENT_LOG_v1 {"time_micros": 1732324526952629, "cf_name": "default", "job": 23345, "event": "table_file_creation", "file_number": 253824, "file_size": 38579727, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 3436103047, "table_properties": {"data_size": 34590032, "index_size": 1758592, "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": 25885496, "raw_average_key_size": 28, "raw_value_size": 108332240, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 924482, "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": 1732324523, "oldest_key_time": 0, "file_creation_time": 1732324523, "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": 253824, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-09:15:26.987808 139957542479424 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253825.sst) /dev/shm/ToplingTemp/Topling-10392-jNvyyZ 2024/11/23-09:15:27.985185 139957542479424 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253825.sst): first pass time = 1.00's, 134.575'MB/sec 2024/11/23-09:15:29.284258 139957542479424 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253825.sst): old prealloc_size = 147639500, real_size = 30430176 2024/11/23-09:15:29.284771 139957542479424 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253825.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 929132 prefix = 4 raw-key = 0.0149 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.92 raw-val = 0.1082 GB zip-val = 0.0284 GB avg-val = 116.46 avg-zval = 30.59 2024/11/23-09:15:29.286402 139957542479424 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253825.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/23-09:15:30.095074 139957542479424 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253825.sst): second pass time = 1.30's, 83.357'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.81's, 42.736'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3604.644'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.338'MB/sec write SST data time = 0.12's, 280.515'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 = 27678.683'MB/sec zip my value time = 1.30's, unzip length = 0.108'GB zip my value throughput = 83.357'MB/sec zip pipeline throughput = 83.357'MB/sec entries = 929132 avg-key = 28.00 avg-zkey = 1.92 avg-val = 116.46 avg-zval = 30.59 usrkeys = 929132 avg-key = 20.00 avg-zkey = 1.92 avg-val = 123.46 avg-zval = 30.59 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 929132 bytes = 3368112 } seq expand size = 6503924 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.0284 GB dict = 1.08 MB all = 0.0346 GB } UnZip/Zip{ index = 10.4436 value = 3.8075 dict = 1.00 all = 3.8736 } Zip/UnZip{ index = 0.0958 value = 0.2626 dict = 1.00 all = 0.2582 } ---------------------------- total value len = 9.753303 GB avg = 0.163 KB (by entry num) total key len = 1.653275 GB avg = 0.028 KB total ukey len = 1.149631 GB avg = 0.016 KB total ukey num = 0.073138083 Billion total entry num = 0.059945812 Billion write speed all = 9.365925938 MB/sec (with seq num) write speed all = 8.972154523 MB/sec (without seq num) 2024/11/23-09:15:30.138892 139957542479424 [compaction_job.cc:1948] [default] [JOB 23345] Generated table #253825: 929132 keys, 34649460 bytes, temperature: kWarm 2024/11/23-09:15:30.138959 139957542479424 EVENT_LOG_v1 {"time_micros": 1732324530138922, "cf_name": "default", "job": 23345, "event": "table_file_creation", "file_number": 253825, "file_size": 34649460, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3436103048, "largest_seqno": 3901579684, "table_properties": {"data_size": 28418384, "index_size": 1779328, "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": 26015696, "raw_average_key_size": 28, "raw_value_size": 108202084, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 929132, "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": 1732324526, "oldest_key_time": 0, "file_creation_time": 1732324526, "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": 253825, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-09:15:30.172078 139957542479424 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253826.sst) /dev/shm/ToplingTemp/Topling-10392-29FHA0 2024/11/23-09:15:31.205098 139957542479424 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253826.sst): first pass time = 1.03's, 129.933'MB/sec 2024/11/23-09:15:32.465884 139957542479424 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253826.sst): old prealloc_size = 147639500, real_size = 30613872 2024/11/23-09:15:32.466459 139957542479424 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253826.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 929249 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.0286 GB avg-val = 116.44 avg-zval = 30.79 2024/11/23-09:15:32.468159 139957542479424 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253826.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/23-09:15:33.283361 139957542479424 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253826.sst): second pass time = 1.26's, 85.897'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 42.614'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3191.617'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.335'MB/sec write SST data time = 0.12's, 280.097'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.079'MB, throughput = 33945.720'MB/sec zip my value time = 1.26's, unzip length = 0.108'GB zip my value throughput = 85.897'MB/sec zip pipeline throughput = 85.897'MB/sec entries = 929249 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.44 avg-zval = 30.79 usrkeys = 929249 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.44 avg-zval = 30.79 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 929249 bytes = 3368544 } seq expand size = 6504743 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.0286 GB dict = 1.08 MB all = 0.0348 GB } UnZip/Zip{ index = 10.5126 value = 3.7814 dict = 1.00 all = 3.8529 } Zip/UnZip{ index = 0.0951 value = 0.2645 dict = 1.00 all = 0.2595 } ---------------------------- total value len = 9.868006 GB avg = 0.162 KB (by entry num) total key len = 1.679294 GB avg = 0.028 KB total ukey len = 1.168216 GB avg = 0.016 KB total ukey num = 0.074067332 Billion total entry num = 0.060875061 Billion write speed all = 9.456716241 MB/sec (with seq num) write speed all = 9.057884887 MB/sec (without seq num) 2024/11/23-09:15:33.325207 139957542479424 [compaction_job.cc:1948] [default] [JOB 23345] Generated table #253826: 929249 keys, 34835326 bytes, temperature: kWarm 2024/11/23-09:15:33.325277 139957542479424 EVENT_LOG_v1 {"time_micros": 1732324533325241, "cf_name": "default", "job": 23345, "event": "table_file_creation", "file_number": 253826, "file_size": 34835326, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3487497056, "largest_seqno": 3901580364, "table_properties": {"data_size": 28613472, "index_size": 1767872, "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": 26018972, "raw_average_key_size": 28, "raw_value_size": 108198778, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 929249, "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": 1732324530, "oldest_key_time": 0, "file_creation_time": 1732324530, "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": 253826, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-09:15:33.358334 139957542479424 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253827.sst) /dev/shm/ToplingTemp/Topling-10392-HojPPY 2024/11/23-09:15:34.380199 139957542479424 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253827.sst): first pass time = 1.02's, 131.351'MB/sec 2024/11/23-09:15:35.642959 139957542479424 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253827.sst): old prealloc_size = 147639500, real_size = 31373392 2024/11/23-09:15:35.643489 139957542479424 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253827.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 929942 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.0294 GB avg-val = 116.33 avg-zval = 31.58 2024/11/23-09:15:35.645218 139957542479424 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253827.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/23-09:15:36.472187 139957542479424 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253827.sst): second pass time = 1.26's, 85.722'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.83's, 43.069'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3682.175'MB/sec (index lex order gen) rebuild zvType time = 0.70's, 0.330'MB/sec write SST data time = 0.12's, 287.940'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.079'MB, throughput = 34241.884'MB/sec zip my value time = 1.26's, unzip length = 0.108'GB zip my value throughput = 85.722'MB/sec zip pipeline throughput = 85.722'MB/sec entries = 929942 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.33 avg-zval = 31.58 usrkeys = 929942 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.33 avg-zval = 31.58 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 929942 bytes = 3487296 } seq expand size = 6509594 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.0294 GB dict = 1.08 MB all = 0.0357 GB } UnZip/Zip{ index = 10.5117 value = 3.6832 dict = 1.00 all = 3.7582 } Zip/UnZip{ index = 0.0951 value = 0.2715 dict = 1.00 all = 0.2661 } ---------------------------- total value len = 9.982695 GB avg = 0.162 KB (by entry num) total key len = 1.705333 GB avg = 0.028 KB total ukey len = 1.186815 GB avg = 0.016 KB total ukey num = 0.074997274 Billion total entry num = 0.061805003 Billion write speed all = 9.547033514 MB/sec (with seq num) write speed all = 9.143164221 MB/sec (without seq num) 2024/11/23-09:15:36.516523 139957542479424 [compaction_job.cc:1948] [default] [JOB 23345] Generated table #253827: 929942 keys, 35713060 bytes, temperature: kWarm 2024/11/23-09:15:36.516601 139957542479424 EVENT_LOG_v1 {"time_micros": 1732324536516563, "cf_name": "default", "job": 23345, "event": "table_file_creation", "file_number": 253827, "file_size": 35713060, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3273701103, "largest_seqno": 3901580294, "table_properties": {"data_size": 29371392, "index_size": 1769344, "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": 26038376, "raw_average_key_size": 28, "raw_value_size": 108179420, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 929942, "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": 1732324533, "oldest_key_time": 0, "file_creation_time": 1732324533, "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": 253827, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-09:15:36.553745 139957542479424 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253828.sst) /dev/shm/ToplingTemp/Topling-10392-54RrGZ 2024/11/23-09:15:37.566638 139957542479424 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253828.sst): first pass time = 1.01's, 132.515'MB/sec 2024/11/23-09:15:38.843763 139957542479424 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253828.sst): old prealloc_size = 147639500, real_size = 30521856 2024/11/23-09:15:38.844308 139957542479424 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253828.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 928708 prefix = 4 raw-key = 0.0149 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1082 GB zip-val = 0.0285 GB avg-val = 116.52 avg-zval = 30.70 2024/11/23-09:15:38.846046 139957542479424 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253828.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/23-09:15:39.662209 139957542479424 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253828.sst): second pass time = 1.28's, 84.823'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 42.589'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3396.995'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.335'MB/sec write SST data time = 0.12's, 280.581'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 = 33123.593'MB/sec zip my value time = 1.28's, unzip length = 0.108'GB zip my value throughput = 84.823'MB/sec zip pipeline throughput = 84.823'MB/sec entries = 928708 avg-key = 28.00 avg-zkey = 1.91 avg-val = 116.52 avg-zval = 30.70 usrkeys = 928708 avg-key = 20.00 avg-zkey = 1.91 avg-val = 123.52 avg-zval = 30.70 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 928708 bytes = 3482672 } seq expand size = 6500956 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.0285 GB dict = 1.08 MB all = 0.0349 GB } UnZip/Zip{ index = 10.4441 value = 3.7955 dict = 1.00 all = 3.8506 } Zip/UnZip{ index = 0.0957 value = 0.2635 dict = 1.00 all = 0.2597 } ---------------------------- total value len = 10.097410 GB avg = 0.161 KB (by entry num) total key len = 1.731336 GB avg = 0.028 KB total ukey len = 1.205389 GB avg = 0.016 KB total ukey num = 0.075925982 Billion total entry num = 0.062733711 Billion write speed all = 9.636865052 MB/sec (with seq num) write speed all = 9.227992440 MB/sec (without seq num) 2024/11/23-09:15:39.704463 139957542479424 [compaction_job.cc:1948] [default] [JOB 23345] Generated table #253828: 928708 keys, 34856132 bytes, temperature: kWarm 2024/11/23-09:15:39.704541 139957542479424 EVENT_LOG_v1 {"time_micros": 1732324539704497, "cf_name": "default", "job": 23345, "event": "table_file_creation", "file_number": 253828, "file_size": 34856132, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3284320399, "largest_seqno": 3901579725, "table_properties": {"data_size": 28511088, "index_size": 1778432, "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": 26003824, "raw_average_key_size": 28, "raw_value_size": 108213956, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 928708, "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": 1732324536, "oldest_key_time": 0, "file_creation_time": 1732324536, "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": 253828, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-09:15:39.737926 139957542479424 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253829.sst) /dev/shm/ToplingTemp/Topling-10392-pI6jX0 2024/11/23-09:15:40.773117 139957542479424 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253829.sst): first pass time = 1.04's, 129.660'MB/sec 2024/11/23-09:15:42.047919 139957542479424 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253829.sst): old prealloc_size = 147639500, real_size = 30826016 2024/11/23-09:15:42.048507 139957542479424 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253829.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 930545 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.0288 GB avg-val = 116.24 avg-zval = 30.97 2024/11/23-09:15:42.050223 139957542479424 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253829.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/23-09:15:42.869487 139957542479424 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253829.sst): second pass time = 1.27's, 84.902'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 42.665'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3155.500'MB/sec (index lex order gen) rebuild zvType time = 0.70's, 0.334'MB/sec write SST data time = 0.12's, 281.787'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.078'MB, throughput = 29873.518'MB/sec zip my value time = 1.27's, unzip length = 0.108'GB zip my value throughput = 84.902'MB/sec zip pipeline throughput = 84.902'MB/sec entries = 930545 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.24 avg-zval = 30.97 usrkeys = 930545 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.24 avg-zval = 30.97 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 930545 bytes = 3373248 } seq expand size = 6513815 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.0288 GB dict = 1.08 MB all = 0.0351 GB } UnZip/Zip{ index = 10.5124 value = 3.7527 dict = 1.00 all = 3.8292 } Zip/UnZip{ index = 0.0951 value = 0.2665 dict = 1.00 all = 0.2611 } ---------------------------- total value len = 10.212086 GB avg = 0.160 KB (by entry num) total key len = 1.757392 GB avg = 0.028 KB total ukey len = 1.224000 GB avg = 0.016 KB total ukey num = 0.076856527 Billion total entry num = 0.063664256 Billion write speed all = 9.726104890 MB/sec (with seq num) write speed all = 9.312248759 MB/sec (without seq num) 2024/11/23-09:15:42.913247 139957542479424 [compaction_job.cc:1948] [default] [JOB 23345] Generated table #253829: 930545 keys, 35050866 bytes, temperature: kWarm 2024/11/23-09:15:42.913315 139957542479424 EVENT_LOG_v1 {"time_micros": 1732324542913279, "cf_name": "default", "job": 23345, "event": "table_file_creation", "file_number": 253829, "file_size": 35050866, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3369194706, "largest_seqno": 3901579737, "table_properties": {"data_size": 28822800, "index_size": 1770368, "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": 26055260, "raw_average_key_size": 28, "raw_value_size": 108162470, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 930545, "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": 1732324539, "oldest_key_time": 0, "file_creation_time": 1732324539, "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": 253829, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-09:15:42.948041 139957542479424 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253830.sst) /dev/shm/ToplingTemp/Topling-10392-aLW6LZ 2024/11/23-09:15:43.877017 139957542479424 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253830.sst): first pass time = 0.93's, 144.485'MB/sec 2024/11/23-09:15:45.144938 139957542479424 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253830.sst): old prealloc_size = 147639500, real_size = 31448624 2024/11/23-09:15:45.145474 139957542479424 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253830.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 919300 prefix = 4 raw-key = 0.0147 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1085 GB zip-val = 0.0295 GB avg-val = 118.00 avg-zval = 32.04 2024/11/23-09:15:45.147175 139957542479424 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253830.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/23-09:15:45.958816 139957542479424 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253830.sst): second pass time = 1.27's, 85.609'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.81's, 43.792'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3593.206'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.334'MB/sec write SST data time = 0.12's, 286.338'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.085'MB, throughput = 34838.492'MB/sec zip my value time = 1.27's, unzip length = 0.108'GB zip my value throughput = 85.609'MB/sec zip pipeline throughput = 85.609'MB/sec entries = 919300 avg-key = 28.00 avg-zkey = 1.91 avg-val = 118.00 avg-zval = 32.04 usrkeys = 919300 avg-key = 20.00 avg-zkey = 1.91 avg-val = 125.00 avg-zval = 32.04 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 919300 bytes = 3332480 } seq expand size = 6435100 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0184 GB value = 0.1085 GB dict = 1.09 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0295 GB dict = 1.09 MB all = 0.0356 GB } UnZip/Zip{ index = 10.4439 value = 3.6824 dict = 1.00 all = 3.7659 } Zip/UnZip{ index = 0.0957 value = 0.2716 dict = 1.00 all = 0.2655 } ---------------------------- total value len = 10.326999 GB avg = 0.160 KB (by entry num) total key len = 1.783132 GB avg = 0.028 KB total ukey len = 1.242386 GB avg = 0.016 KB total ukey num = 0.077775827 Billion total entry num = 0.064583556 Billion write speed all = 9.815755374 MB/sec (with seq num) write speed all = 9.396974509 MB/sec (without seq num) 2024/11/23-09:15:46.001217 139957542479424 [compaction_job.cc:1948] [default] [JOB 23345] Generated table #253830: 919300 keys, 35640306 bytes, temperature: kWarm 2024/11/23-09:15:46.001285 139957542479424 EVENT_LOG_v1 {"time_micros": 1732324546001250, "cf_name": "default", "job": 23345, "event": "table_file_creation", "file_number": 253830, "file_size": 35640306, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3370459838, "largest_seqno": 3898843727, "table_properties": {"data_size": 29458144, "index_size": 1760448, "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": 25740400, "raw_average_key_size": 28, "raw_value_size": 108477400, "raw_average_value_size": 118, "num_data_blocks": 1, "num_entries": 919300, "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": 118, "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": 1732324542, "oldest_key_time": 0, "file_creation_time": 1732324542, "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": 253830, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-09:15:46.036955 139957542479424 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253831.sst) /dev/shm/ToplingTemp/Topling-10392-V5amg1 2024/11/23-09:15:47.060115 139957542479424 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253831.sst): first pass time = 1.02's, 131.188'MB/sec 2024/11/23-09:15:48.378188 139957542479424 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253831.sst): old prealloc_size = 147639500, real_size = 32861072 2024/11/23-09:15:48.378722 139957542479424 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253831.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 938239 prefix = 4 raw-key = 0.0150 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1079 GB zip-val = 0.0308 GB avg-val = 115.05 avg-zval = 32.86 2024/11/23-09:15:48.380521 139957542479424 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253831.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/23-09:15:49.228075 139957542479424 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253831.sst): second pass time = 1.32's, 81.945'MB/sec, value only(80.4% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.85's, 43.666'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3507.522'MB/sec (index lex order gen) rebuild zvType time = 0.72's, 0.324'MB/sec write SST data time = 0.12's, 297.274'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.077'MB, throughput = 37248.772'MB/sec zip my value time = 1.32's, unzip length = 0.108'GB zip my value throughput = 81.945'MB/sec zip pipeline throughput = 81.945'MB/sec entries = 938239 avg-key = 28.00 avg-zkey = 1.91 avg-val = 115.05 avg-zval = 32.86 usrkeys = 938239 avg-key = 20.00 avg-zkey = 1.91 avg-val = 122.05 avg-zval = 32.86 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 938239 bytes = 3401136 } seq expand size = 6567673 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0188 GB value = 0.1079 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0308 GB dict = 1.08 MB all = 0.0371 GB } UnZip/Zip{ index = 10.4457 value = 3.5014 dict = 1.00 all = 3.6167 } Zip/UnZip{ index = 0.0957 value = 0.2856 dict = 1.00 all = 0.2765 } ---------------------------- total value len = 10.441514 GB avg = 0.159 KB (by entry num) total key len = 1.809403 GB avg = 0.028 KB total ukey len = 1.261151 GB avg = 0.016 KB total ukey num = 0.078714066 Billion total entry num = 0.065521795 Billion write speed all = 9.903624446 MB/sec (with seq num) write speed all = 9.479882593 MB/sec (without seq num) 2024/11/23-09:15:49.273606 139957542479424 [compaction_job.cc:1948] [default] [JOB 23345] Generated table #253831: 938239 keys, 37110116 bytes, temperature: kWarm 2024/11/23-09:15:49.273674 139957542479424 EVENT_LOG_v1 {"time_micros": 1732324549273638, "cf_name": "default", "job": 23345, "event": "table_file_creation", "file_number": 253831, "file_size": 37110116, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3514720078, "largest_seqno": 3901580616, "table_properties": {"data_size": 30829888, "index_size": 1796416, "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": 26270692, "raw_average_key_size": 28, "raw_value_size": 107947126, "raw_average_value_size": 115, "num_data_blocks": 1, "num_entries": 938239, "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": 1732324546, "oldest_key_time": 0, "file_creation_time": 1732324546, "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": 253831, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-09:15:49.311137 139957542479424 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253832.sst) /dev/shm/ToplingTemp/Topling-10392-QvMiU0 2024/11/23-09:15:50.200925 139957542479424 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253832.sst): first pass time = 0.89's, 150.848'MB/sec 2024/11/23-09:15:51.529095 139957542479424 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253832.sst): old prealloc_size = 147639500, real_size = 33151920 2024/11/23-09:15:51.529622 139957542479424 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253832.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 929536 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.0312 GB avg-val = 116.39 avg-zval = 33.51 2024/11/23-09:15:51.531688 139957542479424 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253832.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/23-09:15:52.386323 139957542479424 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253832.sst): second pass time = 1.33's, 81.505'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.86's, 43.601'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3491.185'MB/sec (index lex order gen) rebuild zvType time = 0.73's, 0.318'MB/sec write SST data time = 0.13's, 298.278'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 = 34895.165'MB/sec zip my value time = 1.33's, unzip length = 0.108'GB zip my value throughput = 81.505'MB/sec zip pipeline throughput = 81.505'MB/sec entries = 929536 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.39 avg-zval = 33.51 usrkeys = 929536 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.39 avg-zval = 33.51 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 929536 bytes = 3369584 } seq expand size = 6506752 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.0312 GB dict = 1.08 MB all = 0.0374 GB } UnZip/Zip{ index = 10.5132 value = 3.4731 dict = 1.00 all = 3.5911 } Zip/UnZip{ index = 0.0951 value = 0.2879 dict = 1.00 all = 0.2785 } ---------------------------- total value len = 10.556211 GB avg = 0.159 KB (by entry num) total key len = 1.835430 GB avg = 0.028 KB total ukey len = 1.279741 GB avg = 0.016 KB total ukey num = 0.079643602 Billion total entry num = 0.066451331 Billion write speed all = 9.991875489 MB/sec (with seq num) write speed all = 9.563216570 MB/sec (without seq num) 2024/11/23-09:15:52.436612 139957542479424 [compaction_job.cc:1948] [default] [JOB 23345] Generated table #253832: 929536 keys, 37374724 bytes, temperature: kWarm 2024/11/23-09:15:52.436679 139957542479424 EVENT_LOG_v1 {"time_micros": 1732324552436641, "cf_name": "default", "job": 23345, "event": "table_file_creation", "file_number": 253832, "file_size": 37374724, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3516470397, "largest_seqno": 3901580658, "table_properties": {"data_size": 31151008, "index_size": 1768320, "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": 26027008, "raw_average_key_size": 28, "raw_value_size": 108190772, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 929536, "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": 1732324549, "oldest_key_time": 0, "file_creation_time": 1732324549, "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": 253832, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-09:15:52.468051 139957542479424 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253833.sst) /dev/shm/ToplingTemp/Topling-10392-yZ0ALX 2024/11/23-09:15:52.783380 139957542479424 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253833.sst): first pass time = 0.32's, 241.427'MB/sec 2024/11/23-09:15:53.579182 139957542479424 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253833.sst): old prealloc_size = 147639500, real_size = 19704272 2024/11/23-09:15:53.579495 139957542479424 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253833.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 530340 prefix = 4 raw-key = 0.0085 GB zip-key = 0.0010 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.0613 GB zip-val = 0.0186 GB avg-val = 115.53 avg-zval = 35.00 2024/11/23-09:15:53.580011 139957542479424 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253833.sst: sumWaitingMem = 0.001 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0013 GB, waited 0.000 sec, Key+Value = 0.076 GB 2024/11/23-09:15:54.054962 139957542479424 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00/253833.sst): second pass time = 0.79's, 77.088'MB/sec, value only(80.5% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.48's, 46.479'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3471.969'MB/sec (index lex order gen) rebuild zvType time = 0.40's, 0.329'MB/sec write SST data time = 0.07's, 307.668'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.615'MB, throughput = 19079.005'MB/sec zip my value time = 0.79's, unzip length = 0.061'GB zip my value throughput = 77.088'MB/sec zip pipeline throughput = 77.088'MB/sec entries = 530340 avg-key = 28.00 avg-zkey = 1.90 avg-val = 115.53 avg-zval = 35.00 usrkeys = 530340 avg-key = 20.00 avg-zkey = 1.90 avg-val = 122.53 avg-zval = 35.00 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 530340 bytes = 1922496 } seq expand size = 3712380 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0106 GB value = 0.0613 GB dict = 0.61 MB all = 0.0761 GB } __ZipSize{ index = 0.0010 GB value = 0.0186 GB dict = 0.61 MB all = 0.0221 GB } UnZip/Zip{ index = 10.5013 value = 3.3010 dict = 1.00 all = 3.4424 } Zip/UnZip{ index = 0.0952 value = 0.3029 dict = 1.00 all = 0.2905 } ---------------------------- total value len = 10.621195 GB avg = 0.159 KB (by entry num) total key len = 1.850279 GB avg = 0.028 KB total ukey len = 1.290348 GB avg = 0.016 KB total ukey num = 0.080173942 Billion total entry num = 0.066981671 Billion write speed all = 10.042735761 MB/sec (with seq num) write speed all = 9.611236344 MB/sec (without seq num) 2024/11/23-09:15:54.087673 139957542479424 [compaction_job.cc:1948] [default] [JOB 23345] Generated table #253833: 530340 keys, 22112655 bytes, temperature: kWarm 2024/11/23-09:15:54.087742 139957542479424 EVENT_LOG_v1 {"time_micros": 1732324554087706, "cf_name": "default", "job": 23345, "event": "table_file_creation", "file_number": 253833, "file_size": 22112655, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3369353416, "largest_seqno": 3901578686, "table_properties": {"data_size": 18561472, "index_size": 1010048, "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": 14849520, "raw_average_key_size": 28, "raw_value_size": 61271244, "raw_average_value_size": 115, "num_data_blocks": 1, "num_entries": 530340, "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": 1732324552, "oldest_key_time": 0, "file_creation_time": 1732324552, "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": 253833, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-09:15:54.105636 139957542479424 [compaction_job.cc:703] job-23345: subcompact[0], size: 0.566978 G, files: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-23345/att-00 [253818,253819,253820,253821,253822,253823,253824,253825,253826,253827,253828,253829,253830,253831,253832,253833] 2024/11/23-09:15:54.191547 139957542479424 (Original Log Time 2024/11/23-09:15:04.413741) EVENT_LOG_v1 {"time_micros": 1732324504413704, "job": 23345, "event": "compaction_started", "compaction_reason": "FilesMarkedForCompaction", "files_L2": [253750], "files_L3": [253803, 253804, 253678, 253679, 253680, 253681, 253682, 253683, 253684, 253685, 253686, 253687, 253688, 253689, 253701, 253702], "score": 0.995384, "input_data_size": 592230479, "oldest_snapshot_seqno": 3901920589} 2024/11/23-09:15:54.191551 139957542479424 (Original Log Time 2024/11/23-09:15:54.190228) [compaction_job.cc:2022] [default] [JOB 23345] Compacted 1@2 + 16@3 files to L3 => 566977706 bytes 2024/11/23-09:15:54.191553 139957542479424 (Original Log Time 2024/11/23-09:15:54.191473) [compaction_job.cc:1224] [default] compacted to: files[0 0 0 16 0 0 0] max score 0.02, MB/sec: 11.9 rd, 11.4 wr, level 3, files in(1, 16) out(16 +0 blob) MB in(27.1, 537.7 +0.0 blob) out(540.7 +0.0 blob), read-write-amplify(40.8) write-amplify(20.0) OK, records in: 14708029, records dropped: 84522 output_compression: Snappy 2024/11/23-09:15:54.191558 139957542479424 (Original Log Time 2024/11/23-09:15:54.191515) EVENT_LOG_v1 {"time_micros": 1732324554191496, "cf": "default", "job": 23345, "event": "compaction_finished", "compaction_time_micros": 49691905, "compaction_time_cpu_micros": 21356934, "output_level": 3, "num_output_files": 16, "total_output_size": 566977706, "num_input_records": 14708029, "num_output_records": 14623507, "num_subcompactions": 1, "output_compression": "Snappy", "num_single_delete_mismatches": 0, "num_single_delete_fallthrough": 0, "file_write_nanos": 381608490, "file_range_sync_nanos": 0, "file_fsync_nanos": 10083, "file_prepare_write_nanos": 43179, "lsm_state": [0, 0, 0, 16, 0, 0, 0]} 2024/11/23-09:15:54.320101 139957542479424 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":1732324504,"executesMs":49906,"compactionJobId":23345,"attempt":0,"compactionInputRawBytes":2101389575,"compactionInputZipBytes":592230479,"compactionOutputRawBytes":0,"compactionOutputZipBytes":566977706,"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-25c1de75bf3596c77be06ddc3c201f56-e8ab44d52c0c8876-00"}}, response = 2024/11/23-09:15:54.320192 139957542479424 INFO dcompact_worker.cpp:1459: finish /worker/dcompact-log/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/2024-11-22T14.14.14/.rocksdb/job-23345/att-00: olev 3, work 49.906 s, result 7.793 ms, install 1.347 ms, input{raw 1.957 GiB zip 564.795 MiB}