2024/11/20-14:58:37.667144 140256904238656 DEBG dcompact_worker.cpp:2219: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00: fork to child time = 0.015635 sec 2024/11/20-14:58:37.667812 140256904238656 DEBG dcompact_worker.cpp:1013: Beg SerDeRead: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00 2024/11/20-14:58:37.675425 140256904238656 DEBG dcompact_worker.cpp:1033: End SerDeRead: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00 2024/11/20-14:58:37.677742 140256904238656 TRAC dcompact_worker.cpp:1083: INFO_LOG_LEVEL: rpc = INFO_LEVEL, env_var = undefined 2024/11/20-14:58:37.678094 140256904238656 [WARN] [column_family.cc:386] multiple cf_paths/db_paths and level_compaction_dynamic_level_bytes can't be used together 2024/11/20-14:58:37.729436 140256904238656 [version_set.cc:6211] Recovering from manifest file: /worker/dcompact-log/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/2024-11-20T12.20.00/.rocksdb/job-11360/att-00/MANIFEST-019309 2024/11/20-14:58:37.800030 140256904238656 [version_set.cc:6254] Recovered from manifest file:/worker/dcompact-log/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/2024-11-20T12.20.00/.rocksdb/job-11360/att-00/MANIFEST-019309 succeeded,manifest_file_number is 19309, next_file_number is 37449, last_sequence is 671973719, log_number is 0,prev_log_number is 0,max_column_family is 0,min_log_number_to_keep is 37216 2024/11/20-14:58:37.800039 140256904238656 [version_set.cc:6269] Column family [default] (ID 0), log number is 0 2024/11/20-14:58:37.800163 140256904238656 [version_set.cc:5724] Creating manifest 37449 2024/11/20-14:58:37.830508 140256904238656 DEBG dcompact_worker.cpp:1225: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00: bottommost_level: fake = 1, rpc = 0 2024/11/20-14:58:37.853243 140256904238656 [compaction_job.cc:2437] [default] [JOB 11360] Compacting 1@2 + 18@3 files to L3, score 0.88, subcompactions 1 : 1 2024/11/20-14:58:37.853264 140256904238656 [compaction_job.cc:2445] [default]: Compaction start summary: Base version 9463 Base level 2, inputs: [37415(54MB)], [37352(38MB) 37356(39MB) 37380(38MB) 37387(38MB) 37390(38MB) 37398(37MB) 37412(7073KB) 37253(37MB) 37254(38MB) 37255(38MB) 37256(37MB) 37257(35MB) 37258(35MB) 37259(37MB) 37260(39MB) 37261(11MB) 37219(540KB) 37175(37MB)] 2024/11/20-14:58:37.864611 140256904238656 [top_zip_table.cc:59] core git_version_hash_info_is:commit 81964c21ebbcc178d8e99dae0fbf61bded2729cc Author: rockeet Date: Mon Nov 11 21:28:46 2024 +0800 Makefile: fix gen git-version-*.cpp GIT_PATH_ARG = :!src/terark/fsa :!tools/fsa :!src/terark/zbs :!tools/zbs g++ (GCC) 12.2.1 20221121 (Red Hat 12.2.1-7) Copyright (C) 2022 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. INCS = -Isrc -I3rdparty/zstd -Iboost-include DEFS = -DTOPLING_IO_WITH_URING=1 -DDIVSUFSORT_API= CXXFLAGS = -fPIC -time -fdiagnostics-color -mcx16 -fno-stack-protector WARNINGS = -Wno-class-memaccess -Wformat=2 -Wcomment -Wall -Wextra -Wno-unused-parameter -Wno-alloc-size-larger-than -Wno-deprecated-declarations -Wstrict-aliasing=3 RLS_FLAGS = -O3 -DNDEBUG -g3 WITH_BMI2 = 1 compile_cpu_flag: -march=haswell -mbmi -mbmi2 LDFLAGS = -fPIC -rdynamic 2024/11/20-14:58:37.864637 140256904238656 [top_zip_table.cc:60] fsa git_version_hash_info_is:commit 5dfecb7d107196f044ff5bf78dc39d2e725b9d9b Author: leipeng Date: Thu Nov 7 15:22:45 2024 +0800 Makefile: fix for x86_64 CPU older than haswell GIT_PATH_ARG = src/terark/fsa tools/fsa g++ (GCC) 12.2.1 20221121 (Red Hat 12.2.1-7) Copyright (C) 2022 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. INCS = -Isrc -I3rdparty/zstd -Iboost-include DEFS = -DTOPLING_IO_WITH_URING=1 -DDIVSUFSORT_API= CXXFLAGS = -fPIC -time -fdiagnostics-color -mcx16 -fno-stack-protector WARNINGS = -Wno-class-memaccess -Wformat=2 -Wcomment -Wall -Wextra -Wno-unused-parameter -Wno-alloc-size-larger-than -Wno-deprecated-declarations -Wstrict-aliasing=3 RLS_FLAGS = -O3 -DNDEBUG -g3 WITH_BMI2 = 1 compile_cpu_flag: -march=haswell -mbmi -mbmi2 LDFLAGS = -fPIC -rdynamic 2024/11/20-14:58:37.864655 140256904238656 [top_zip_table.cc:61] zbs git_version_hash_info_is:commit d44dd5ff72707128fe3c916077b43d2093c01f7c Author: leipeng Date: Sun Oct 27 23:38:26 2024 +0800 Fix for msvc, when toplingdb on msvc GIT_PATH_ARG = src/terark/zbs tools/zbs g++ (GCC) 12.2.1 20221121 (Red Hat 12.2.1-7) Copyright (C) 2022 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. INCS = -Isrc -I3rdparty/zstd -Iboost-include DEFS = -DTOPLING_IO_WITH_URING=1 -DDIVSUFSORT_API= CXXFLAGS = -fPIC -time -fdiagnostics-color -mcx16 -fno-stack-protector WARNINGS = -Wno-class-memaccess -Wformat=2 -Wcomment -Wall -Wextra -Wno-unused-parameter -Wno-alloc-size-larger-than -Wno-deprecated-declarations -Wstrict-aliasing=3 RLS_FLAGS = -O3 -DNDEBUG -g3 WITH_BMI2 = 1 compile_cpu_flag: -march=haswell -mbmi -mbmi2 LDFLAGS = -fPIC -rdynamic 2024/11/20-14:58:37.864664 140256904238656 [top_zip_table.cc:62] topling-zip_table_reader: git_version_hash_info_is: commit 79614a7e7dc27362fc5151b0797eb7d83c674c7b Author: rockeet Date: Sun Nov 10 15:02:21 2024 +0800 cpu_has_bmi2.sh: detect by compile c++ code check __BMI2__ g++ (GCC) 12.2.1 20221121 (Red Hat 12.2.1-7) Copyright (C) 2022 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. cpu_flag: -march=native -mbmi -mbmi2 2024/11/20-14:58:37.864677 140256904238656 [top_zip_table.cc:64] topling-rocks git_version_hash_info_is: commit c46b65a52d9c74aa8b87aeb8438620ff2dbc669c Author: rockeet Date: Sun Nov 10 15:02:42 2024 +0800 cpu_has_bmi2.sh: detect by compile c++ code check __BMI2__ g++ (GCC) 12.2.1 20221121 (Red Hat 12.2.1-7) Copyright (C) 2022 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. cpu_flag: -march=native -mbmi -mbmi2 2024/11/20-14:58:38.693265 140256904238656 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037450.sst) /dev/shm/ToplingTemp/Topling-426367-RNY3g3 2024/11/20-14:58:39.434793 140256904238656 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037450.sst): first pass time = 0.74's, 181.011'MB/sec 2024/11/20-14:58:40.806979 140256904238656 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037450.sst): old prealloc_size = 147639500, real_size = 36412144 2024/11/20-14:58:40.807720 140256904238656 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037450.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 921708 prefix = 4 raw-key = 0.0147 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.94 raw-val = 0.1084 GB zip-val = 0.0344 GB avg-val = 117.62 avg-zval = 37.32 2024/11/20-14:58:40.808599 140256904238656 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037450.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-14:58:41.729696 140256904238656 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037450.sst): second pass time = 1.37's, 79.062'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.92's, 43.893'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2539.969'MB/sec (index lex order gen) rebuild zvType time = 0.76's, 0.302'MB/sec write SST data time = 0.16's, 255.565'MB/sec dict compress time = 4499786723.92's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.084'MB, throughput = 29220.694'MB/sec zip my value time = 1.37's, unzip length = 0.108'GB zip my value throughput = 79.062'MB/sec zip pipeline throughput = 79.062'MB/sec entries = 921708 avg-key = 28.00 avg-zkey = 1.94 avg-val = 117.62 avg-zval = 37.32 usrkeys = 921708 avg-key = 20.00 avg-zkey = 1.94 avg-val = 124.62 avg-zval = 37.32 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 921708 bytes = 3226000 } seq expand size = 6451956 multi value expand size = 0 cnt WriteAppend = 26 UnZipSize{ index = 0.0184 GB value = 0.1084 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0344 GB dict = 1.08 MB all = 0.0405 GB } UnZip/Zip{ index = 10.3101 value = 3.1520 dict = 1.00 all = 3.3139 } Zip/UnZip{ index = 0.0970 value = 0.3173 dict = 1.00 all = 0.3018 } ---------------------------- total value len = 0.114862 GB avg = 0.125 KB (by entry num) total key len = 0.025808 GB avg = 0.028 KB total ukey len = 0.018434 GB avg = 0.020 KB total ukey num = 0.000921708 Billion total entry num = 0.000921708 Billion write speed all = 0.006319427 MB/sec (with seq num) write speed all = 0.005988173 MB/sec (without seq num) 2024/11/20-14:58:41.781845 140256904238656 [compaction_job.cc:1948] [default] [JOB 11360] Generated table #37450: 921708 keys, 40501022 bytes, temperature: kWarm 2024/11/20-14:58:41.781932 140256904238656 EVENT_LOG_v1 {"time_micros": 1732085921781890, "cf_name": "default", "job": 11360, "event": "table_file_creation", "file_number": 37450, "file_size": 40501022, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 522320272, "largest_seqno": 670620526, "table_properties": {"data_size": 34393568, "index_size": 1787968, "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": 25807824, "raw_average_key_size": 28, "raw_value_size": 108409972, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 921708, "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": 1732085918, "oldest_key_time": 0, "file_creation_time": 1732085918, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "92E45FH6K6HCJOD41QCQ", "orig_file_number": 37450, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-14:58:41.819629 140256904238656 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037451.sst) /dev/shm/ToplingTemp/Topling-426367-bnT325 2024/11/20-14:58:42.659514 140256904238656 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037451.sst): first pass time = 0.84's, 159.811'MB/sec 2024/11/20-14:58:43.970952 140256904238656 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037451.sst): old prealloc_size = 147639500, real_size = 37354144 2024/11/20-14:58:43.971648 140256904238656 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037451.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 925960 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.94 raw-val = 0.1083 GB zip-val = 0.0353 GB avg-val = 116.95 avg-zval = 38.15 2024/11/20-14:58:43.972541 140256904238656 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037451.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-14:58:44.957299 140256904238656 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037451.sst): second pass time = 1.31's, 82.635'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.99's, 42.029'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2662.407'MB/sec (index lex order gen) rebuild zvType time = 0.76's, 0.305'MB/sec write SST data time = 0.23's, 182.669'MB/sec dict compress time = 40.26's, 0.027'MB/sec z-dict build time = 0.00's, sample length = 1.081'MB, throughput = 35384.394'MB/sec zip my value time = 1.31's, unzip length = 0.108'GB zip my value throughput = 82.635'MB/sec zip pipeline throughput = 82.635'MB/sec entries = 925960 avg-key = 28.00 avg-zkey = 1.94 avg-val = 116.95 avg-zval = 38.15 usrkeys = 925960 avg-key = 20.00 avg-zkey = 1.94 avg-val = 123.95 avg-zval = 38.15 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 925960 bytes = 3240880 } seq expand size = 6481720 multi value expand size = 0 cnt WriteAppend = 56 UnZipSize{ index = 0.0185 GB value = 0.1083 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0353 GB dict = 1.08 MB all = 0.0415 GB } UnZip/Zip{ index = 10.3071 value = 3.0655 dict = 1.00 all = 3.2378 } Zip/UnZip{ index = 0.0970 value = 0.3262 dict = 1.00 all = 0.3089 } ---------------------------- total value len = 0.229635 GB avg = 0.124 KB (by entry num) total key len = 0.051735 GB avg = 0.028 KB total ukey len = 0.036953 GB avg = 0.020 KB total ukey num = 0.001847668 Billion total entry num = 0.001847668 Billion write speed all = 0.012638359 MB/sec (with seq num) write speed all = 0.011974420 MB/sec (without seq num) 2024/11/20-14:58:45.011359 140256904238656 [compaction_job.cc:1948] [default] [JOB 11360] Generated table #37451: 925960 keys, 41453676 bytes, temperature: kWarm 2024/11/20-14:58:45.011451 140256904238656 EVENT_LOG_v1 {"time_micros": 1732085925011405, "cf_name": "default", "job": 11360, "event": "table_file_creation", "file_number": 37451, "file_size": 41453676, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 503040251, "largest_seqno": 670620627, "table_properties": {"data_size": 35325712, "index_size": 1796736, "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": 25926880, "raw_average_key_size": 28, "raw_value_size": 108290928, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 925960, "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": 1732085921, "oldest_key_time": 0, "file_creation_time": 1732085921, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "92E45FH6K6HCJOD41QCQ", "orig_file_number": 37451, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-14:58:45.071284 140256904238656 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037452.sst) /dev/shm/ToplingTemp/Topling-426367-AQPUS2 2024/11/20-14:58:46.413757 140256904238656 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037452.sst): first pass time = 1.34's, 99.982'MB/sec 2024/11/20-14:58:48.488998 140256904238656 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037452.sst): old prealloc_size = 147639500, real_size = 36981136 2024/11/20-14:58:48.489734 140256904238656 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037452.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 923370 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.0350 GB avg-val = 117.36 avg-zval = 37.90 2024/11/20-14:58:48.490605 140256904238656 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037452.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-14:58:49.959170 140256904238656 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037452.sst): second pass time = 2.07's, 52.242'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.47's, 27.858'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2558.654'MB/sec (index lex order gen) rebuild zvType time = 1.19's, 0.194'MB/sec write SST data time = 0.28's, 145.463'MB/sec dict compress time = 40.26's, 0.027'MB/sec z-dict build time = 0.00's, sample length = 1.083'MB, throughput = 27682.865'MB/sec zip my value time = 2.07's, unzip length = 0.108'GB zip my value throughput = 52.242'MB/sec zip pipeline throughput = 128.430'MB/sec entries = 923370 avg-key = 28.00 avg-zkey = 1.90 avg-val = 117.36 avg-zval = 37.90 usrkeys = 923370 avg-key = 20.00 avg-zkey = 1.90 avg-val = 124.36 avg-zval = 37.90 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 923370 bytes = 3116384 } seq expand size = 6463590 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.0350 GB dict = 1.08 MB all = 0.0410 GB } UnZip/Zip{ index = 10.5112 value = 3.0967 dict = 1.00 all = 3.2772 } Zip/UnZip{ index = 0.0951 value = 0.3229 dict = 1.00 all = 0.3051 } ---------------------------- total value len = 0.344462 GB avg = 0.124 KB (by entry num) total key len = 0.077589 GB avg = 0.028 KB total ukey len = 0.055421 GB avg = 0.020 KB total ukey num = 0.002771038 Billion total entry num = 0.002771038 Billion write speed all = 0.018953133 MB/sec (with seq num) write speed all = 0.017957615 MB/sec (without seq num) 2024/11/20-14:58:50.014350 140256904238656 [compaction_job.cc:1948] [default] [JOB 11360] Generated table #37452: 923370 keys, 40955390 bytes, temperature: kWarm 2024/11/20-14:58:50.014427 140256904238656 EVENT_LOG_v1 {"time_micros": 1732085930014383, "cf_name": "default", "job": 11360, "event": "table_file_creation", "file_number": 37452, "file_size": 40955390, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 591115808, "largest_seqno": 670620704, "table_properties": {"data_size": 34993152, "index_size": 1756928, "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": 25854360, "raw_average_key_size": 28, "raw_value_size": 108363416, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 923370, "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": 1732085925, "oldest_key_time": 0, "file_creation_time": 1732085925, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "92E45FH6K6HCJOD41QCQ", "orig_file_number": 37452, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-14:58:50.082207 140256904238656 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037453.sst) /dev/shm/ToplingTemp/Topling-426367-2hET22 2024/11/20-14:58:50.980790 140256904238656 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037453.sst): first pass time = 0.90's, 149.376'MB/sec 2024/11/20-14:58:53.034734 140256904238656 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037453.sst): old prealloc_size = 147639500, real_size = 36712336 2024/11/20-14:58:53.035369 140256904238656 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037453.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 923722 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.94 raw-val = 0.1084 GB zip-val = 0.0347 GB avg-val = 117.30 avg-zval = 37.55 2024/11/20-14:58:53.036179 140256904238656 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037453.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-14:58:53.871622 140256904238656 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037453.sst): second pass time = 2.05's, 52.774'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.84's, 48.760'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2910.092'MB/sec (index lex order gen) rebuild zvType time = 0.70's, 0.328'MB/sec write SST data time = 0.13's, 307.557'MB/sec dict compress time = 40.26's, 0.027'MB/sec z-dict build time = 0.00's, sample length = 1.083'MB, throughput = 33008.872'MB/sec zip my value time = 2.05's, unzip length = 0.108'GB zip my value throughput = 52.774'MB/sec zip pipeline throughput = 134.134'MB/sec entries = 923722 avg-key = 28.00 avg-zkey = 1.94 avg-val = 117.30 avg-zval = 37.55 usrkeys = 923722 avg-key = 20.00 avg-zkey = 1.94 avg-val = 124.30 avg-zval = 37.55 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 923722 bytes = 3233040 } seq expand size = 6466054 multi value expand size = 0 cnt WriteAppend = 64 UnZipSize{ index = 0.0185 GB value = 0.1084 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0347 GB dict = 1.08 MB all = 0.0408 GB } UnZip/Zip{ index = 10.3046 value = 3.1236 dict = 1.00 all = 3.2891 } Zip/UnZip{ index = 0.0970 value = 0.3201 dict = 1.00 all = 0.3040 } ---------------------------- total value len = 0.459281 GB avg = 0.124 KB (by entry num) total key len = 0.103453 GB avg = 0.028 KB total ukey len = 0.073895 GB avg = 0.020 KB total ukey num = 0.003694760 Billion total entry num = 0.003694760 Billion write speed all = 0.025266419 MB/sec (with seq num) write speed all = 0.023939280 MB/sec (without seq num) 2024/11/20-14:58:53.958594 140256904238656 [compaction_job.cc:1948] [default] [JOB 11360] Generated table #37453: 923722 keys, 40806706 bytes, temperature: kWarm 2024/11/20-14:58:53.958638 140256904238656 EVENT_LOG_v1 {"time_micros": 1732085933958615, "cf_name": "default", "job": 11360, "event": "table_file_creation", "file_number": 37453, "file_size": 40806706, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 431720469, "largest_seqno": 670619963, "table_properties": {"data_size": 34688384, "index_size": 1792832, "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": 25864216, "raw_average_key_size": 28, "raw_value_size": 108353596, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 923722, "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": 1732085930, "oldest_key_time": 0, "file_creation_time": 1732085930, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "92E45FH6K6HCJOD41QCQ", "orig_file_number": 37453, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-14:58:54.008372 140256904238656 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037454.sst) /dev/shm/ToplingTemp/Topling-426367-ezN873 2024/11/20-14:58:55.044696 140256904238656 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037454.sst): first pass time = 1.04's, 129.518'MB/sec 2024/11/20-14:58:56.219425 140256904238656 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037454.sst): old prealloc_size = 147639500, real_size = 36622736 2024/11/20-14:58:56.219957 140256904238656 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037454.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 927446 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.93 raw-val = 0.1082 GB zip-val = 0.0346 GB avg-val = 116.72 avg-zval = 37.31 2024/11/20-14:58:56.220746 140256904238656 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037454.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-14:58:57.032744 140256904238656 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037454.sst): second pass time = 1.17's, 92.199'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.81's, 49.929'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3502.866'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.338'MB/sec write SST data time = 0.13's, 321.926'MB/sec dict compress time = 0.00's, 1080104.000'MB/sec z-dict build time = 0.00's, sample length = 1.080'MB, throughput = 36808.342'MB/sec zip my value time = 1.17's, unzip length = 0.108'GB zip my value throughput = 92.199'MB/sec zip pipeline throughput = 92.199'MB/sec entries = 927446 avg-key = 28.00 avg-zkey = 1.93 avg-val = 116.72 avg-zval = 37.31 usrkeys = 927446 avg-key = 20.00 avg-zkey = 1.93 avg-val = 123.72 avg-zval = 37.31 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 927446 bytes = 3130144 } seq expand size = 6492122 multi value expand size = 0 cnt WriteAppend = 14 UnZipSize{ index = 0.0185 GB value = 0.1082 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0346 GB dict = 1.08 MB all = 0.0406 GB } UnZip/Zip{ index = 10.3799 value = 3.1283 dict = 1.00 all = 3.3053 } Zip/UnZip{ index = 0.0963 value = 0.3197 dict = 1.00 all = 0.3025 } ---------------------------- total value len = 0.574023 GB avg = 0.124 KB (by entry num) total key len = 0.129422 GB avg = 0.028 KB total ukey len = 0.092444 GB avg = 0.020 KB total ukey num = 0.004622206 Billion total entry num = 0.004622206 Billion write speed all = 0.031579719 MB/sec (with seq num) write speed all = 0.029919682 MB/sec (without seq num) 2024/11/20-14:58:57.084583 140256904238656 [compaction_job.cc:1948] [default] [JOB 11360] Generated table #37454: 927446 keys, 40606968 bytes, temperature: kWarm 2024/11/20-14:58:57.084641 140256904238656 EVENT_LOG_v1 {"time_micros": 1732085937084612, "cf_name": "default", "job": 11360, "event": "table_file_creation", "file_number": 37454, "file_size": 40606968, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 542657405, "largest_seqno": 670620852, "table_properties": {"data_size": 34603712, "index_size": 1787008, "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": 25968488, "raw_average_key_size": 28, "raw_value_size": 108249260, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 927446, "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": 1732085933, "oldest_key_time": 0, "file_creation_time": 1732085933, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "92E45FH6K6HCJOD41QCQ", "orig_file_number": 37454, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-14:58:57.124379 140256904238656 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037455.sst) /dev/shm/ToplingTemp/Topling-426367-RWSop4 2024/11/20-14:58:58.503695 140256904238656 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037455.sst): first pass time = 1.38's, 97.310'MB/sec 2024/11/20-14:58:59.775508 140256904238656 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037455.sst): old prealloc_size = 147639500, real_size = 35794864 2024/11/20-14:58:59.776344 140256904238656 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037455.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 925757 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.0338 GB avg-val = 116.98 avg-zval = 36.51 2024/11/20-14:58:59.777317 140256904238656 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037455.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-14:59:01.159249 140256904238656 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037455.sst): second pass time = 1.27's, 85.564'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.38's, 28.744'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2170.554'MB/sec (index lex order gen) rebuild zvType time = 1.13's, 0.204'MB/sec write SST data time = 0.25's, 159.622'MB/sec dict compress time = 140278.07's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.080'MB, throughput = 35529.640'MB/sec zip my value time = 1.27's, unzip length = 0.108'GB zip my value throughput = 85.564'MB/sec zip pipeline throughput = 85.564'MB/sec entries = 925757 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.98 avg-zval = 36.51 usrkeys = 925757 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.98 avg-zval = 36.51 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 925757 bytes = 3124448 } seq expand size = 6480299 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.0338 GB dict = 1.08 MB all = 0.0398 GB } UnZip/Zip{ index = 10.5119 value = 3.2039 dict = 1.00 all = 3.3745 } Zip/UnZip{ index = 0.0951 value = 0.3121 dict = 1.00 all = 0.2963 } ---------------------------- total value len = 0.688799 GB avg = 0.124 KB (by entry num) total key len = 0.155343 GB avg = 0.028 KB total ukey len = 0.110959 GB avg = 0.020 KB total ukey num = 0.005547963 Billion total entry num = 0.005547963 Billion write speed all = 0.037889057 MB/sec (with seq num) write speed all = 0.035896909 MB/sec (without seq num) 2024/11/20-14:59:01.211819 140256904238656 [compaction_job.cc:1948] [default] [JOB 11360] Generated table #37455: 925757 keys, 39773742 bytes, temperature: kWarm 2024/11/20-14:59:01.211906 140256904238656 EVENT_LOG_v1 {"time_micros": 1732085941211864, "cf_name": "default", "job": 11360, "event": "table_file_creation", "file_number": 37455, "file_size": 39773742, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 542657474, "largest_seqno": 670620911, "table_properties": {"data_size": 33801888, "index_size": 1761344, "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": 25921196, "raw_average_key_size": 28, "raw_value_size": 108296574, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 925757, "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": 1732085937, "oldest_key_time": 0, "file_creation_time": 1732085937, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "92E45FH6K6HCJOD41QCQ", "orig_file_number": 37455, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-14:59:01.281546 140256904238656 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037456.sst) /dev/shm/ToplingTemp/Topling-426367-vChb94 2024/11/20-14:59:02.842013 140256904238656 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037456.sst): first pass time = 1.56's, 86.015'MB/sec 2024/11/20-14:59:13.183667 140256904238656 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037456.sst): old prealloc_size = 147639500, real_size = 35637168 2024/11/20-14:59:13.184459 140256904238656 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037456.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 925060 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.94 raw-val = 0.1083 GB zip-val = 0.0336 GB avg-val = 117.09 avg-zval = 36.33 2024/11/20-14:59:13.185075 140256904238656 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037456.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-14:59:14.606020 140256904238656 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037456.sst): second pass time = 10.33's, 10.487'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.42's, 26.899'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2401.941'MB/sec (index lex order gen) rebuild zvType time = 1.09's, 0.211'MB/sec write SST data time = 0.33's, 117.083'MB/sec dict compress time = 140278.07's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.081'MB, throughput = 27649.364'MB/sec zip my value time = 10.33's, unzip length = 0.108'GB zip my value throughput = 10.487'MB/sec zip pipeline throughput = 311.757'MB/sec entries = 925060 avg-key = 28.00 avg-zkey = 1.94 avg-val = 117.09 avg-zval = 36.33 usrkeys = 925060 avg-key = 20.00 avg-zkey = 1.94 avg-val = 120.59 avg-zval = 36.33 TagRS{ kinds = RS_Key0_TagN bytes = 144640 } TagArray{ size = 462122 bytes = 1617440 } seq expand size = 3234854 multi value expand size = 0 cnt WriteAppend = 20 UnZipSize{ index = 0.0185 GB value = 0.1083 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0336 GB dict = 1.08 MB all = 0.0383 GB } UnZip/Zip{ index = 10.3085 value = 3.2226 dict = 1.00 all = 3.5082 } Zip/UnZip{ index = 0.0970 value = 0.3103 dict = 1.00 all = 0.2850 } ---------------------------- total value len = 0.800350 GB avg = 0.124 KB (by entry num) total key len = 0.181245 GB avg = 0.028 KB total ukey len = 0.129460 GB avg = 0.020 KB total ukey num = 0.006473023 Billion total entry num = 0.006473023 Billion write speed all = 0.044032000 MB/sec (with seq num) write speed all = 0.041709086 MB/sec (without seq num) 2024/11/20-14:59:14.658526 140256904238656 [compaction_job.cc:1948] [default] [JOB 11360] Generated table #37456: 925060 keys, 38258273 bytes, temperature: kWarm 2024/11/20-14:59:14.658616 140256904238656 EVENT_LOG_v1 {"time_micros": 1732085954658571, "cf_name": "default", "job": 11360, "event": "table_file_creation", "file_number": 37456, "file_size": 38258273, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 669117506, "table_properties": {"data_size": 33610976, "index_size": 1794752, "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": 25901680, "raw_average_key_size": 28, "raw_value_size": 108316152, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 925060, "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": 1732085941, "oldest_key_time": 0, "file_creation_time": 1732085941, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "92E45FH6K6HCJOD41QCQ", "orig_file_number": 37456, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-14:59:14.732981 140256904238656 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037457.sst) /dev/shm/ToplingTemp/Topling-426367-Xz7MN2 2024/11/20-14:59:16.198254 140256904238656 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037457.sst): first pass time = 1.47's, 91.605'MB/sec 2024/11/20-14:59:25.335925 140256904238656 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037457.sst): old prealloc_size = 147639500, real_size = 36547344 2024/11/20-14:59:25.336724 140256904238656 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037457.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 926399 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.94 raw-val = 0.1083 GB zip-val = 0.0345 GB avg-val = 116.88 avg-zval = 37.26 2024/11/20-14:59:25.337600 140256904238656 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037457.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-14:59:27.232318 140256904238656 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037457.sst): second pass time = 9.14's, 11.851'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.90's, 21.292'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2435.202'MB/sec (index lex order gen) rebuild zvType time = 1.49's, 0.155'MB/sec write SST data time = 0.41's, 99.591'MB/sec dict compress time = 140278.07's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.080'MB, throughput = 30411.968'MB/sec zip my value time = 9.14's, unzip length = 0.108'GB zip my value throughput = 11.851'MB/sec zip pipeline throughput = 299.072'MB/sec entries = 926399 avg-key = 28.00 avg-zkey = 1.94 avg-val = 116.88 avg-zval = 37.26 usrkeys = 926399 avg-key = 20.00 avg-zkey = 1.94 avg-val = 122.98 avg-zval = 37.26 TagRS{ kinds = RS_Key0_TagN bytes = 144840 } TagArray{ size = 807437 bytes = 2826048 } seq expand size = 5652059 multi value expand size = 0 cnt WriteAppend = 33 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.0404 GB } UnZip/Zip{ index = 10.3083 value = 3.1369 dict = 1.00 all = 3.3241 } Zip/UnZip{ index = 0.0970 value = 0.3188 dict = 1.00 all = 0.3008 } ---------------------------- total value len = 0.914281 GB avg = 0.124 KB (by entry num) total key len = 0.207184 GB avg = 0.028 KB total ukey len = 0.147988 GB avg = 0.020 KB total ukey num = 0.007399422 Billion total entry num = 0.007399422 Billion write speed all = 0.050277752 MB/sec (with seq num) write speed all = 0.047623893 MB/sec (without seq num) 2024/11/20-14:59:27.285874 140256904238656 [compaction_job.cc:1948] [default] [JOB 11360] Generated table #37457: 926399 keys, 40376718 bytes, temperature: kWarm 2024/11/20-14:59:27.285954 140256904238656 EVENT_LOG_v1 {"time_micros": 1732085967285913, "cf_name": "default", "job": 11360, "event": "table_file_creation", "file_number": 37457, "file_size": 40376718, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 669117712, "table_properties": {"data_size": 34518208, "index_size": 1797376, "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": 25939172, "raw_average_key_size": 28, "raw_value_size": 108278686, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 926399, "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": 1732085954, "oldest_key_time": 0, "file_creation_time": 1732085954, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "92E45FH6K6HCJOD41QCQ", "orig_file_number": 37457, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-14:59:27.346398 140256904238656 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037458.sst) /dev/shm/ToplingTemp/Topling-426367-OaTjO3 2024/11/20-14:59:28.922991 140256904238656 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037458.sst): first pass time = 1.58's, 85.135'MB/sec 2024/11/20-14:59:32.049384 140256904238656 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037458.sst): old prealloc_size = 147639500, real_size = 36752432 2024/11/20-14:59:32.050170 140256904238656 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037458.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 928208 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.0348 GB avg-val = 116.60 avg-zval = 37.44 2024/11/20-14:59:32.051060 140256904238656 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037458.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-14:59:34.051032 140256904238656 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037458.sst): second pass time = 3.11's, 34.766'MB/sec, value only(80.6% of KV) wait indexing time = 0.01's, remap KeyValue time = 2.00's, 20.353'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2337.982'MB/sec (index lex order gen) rebuild zvType time = 1.63's, 0.142'MB/sec write SST data time = 0.37's, 111.170'MB/sec dict compress time = 140278.07's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.080'MB, throughput = 26700.131'MB/sec zip my value time = 3.11's, unzip length = 0.108'GB zip my value throughput = 34.766'MB/sec zip pipeline throughput = 183.126'MB/sec entries = 928208 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.60 avg-zval = 37.44 usrkeys = 928208 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.60 avg-zval = 37.44 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 928208 bytes = 3132720 } seq expand size = 6497456 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.0348 GB dict = 1.08 MB all = 0.0407 GB } UnZip/Zip{ index = 10.5119 value = 3.1141 dict = 1.00 all = 3.2946 } Zip/UnZip{ index = 0.0951 value = 0.3211 dict = 1.00 all = 0.3035 } ---------------------------- total value len = 1.029007 GB avg = 0.124 KB (by entry num) total key len = 0.233174 GB avg = 0.028 KB total ukey len = 0.166553 GB avg = 0.020 KB total ukey num = 0.008327630 Billion total entry num = 0.008327630 Billion write speed all = 0.056569037 MB/sec (with seq num) write speed all = 0.053583182 MB/sec (without seq num) 2024/11/20-14:59:34.108645 140256904238656 [compaction_job.cc:1948] [default] [JOB 11360] Generated table #37458: 928208 keys, 40738740 bytes, temperature: kWarm 2024/11/20-14:59:34.108728 140256904238656 EVENT_LOG_v1 {"time_micros": 1732085974108687, "cf_name": "default", "job": 11360, "event": "table_file_creation", "file_number": 37458, "file_size": 40738740, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 599518704, "largest_seqno": 669117797, "table_properties": {"data_size": 34754208, "index_size": 1766016, "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": 25989824, "raw_average_key_size": 28, "raw_value_size": 108228044, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 928208, "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": 1732085967, "oldest_key_time": 0, "file_creation_time": 1732085967, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "92E45FH6K6HCJOD41QCQ", "orig_file_number": 37458, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-14:59:34.212913 140256904238656 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037459.sst) /dev/shm/ToplingTemp/Topling-426367-Qc1OY5 2024/11/20-14:59:35.617302 140256904238656 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037459.sst): first pass time = 1.40's, 95.575'MB/sec 2024/11/20-14:59:41.755640 140256904238656 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037459.sst): old prealloc_size = 147639500, real_size = 36711056 2024/11/20-14:59:41.756657 140256904238656 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037459.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 927568 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.97 raw-val = 0.1082 GB zip-val = 0.0347 GB avg-val = 116.70 avg-zval = 37.36 2024/11/20-14:59:41.757542 140256904238656 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037459.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-14:59:43.114146 140256904238656 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037459.sst): second pass time = 6.14's, 17.637'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.36's, 28.960'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 1886.137'MB/sec (index lex order gen) rebuild zvType time = 1.04's, 0.222'MB/sec write SST data time = 0.31's, 125.205'MB/sec dict compress time = 140278.07's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.080'MB, throughput = 26309.112'MB/sec zip my value time = 6.14's, unzip length = 0.108'GB zip my value throughput = 17.637'MB/sec zip pipeline throughput = 265.737'MB/sec entries = 927568 avg-key = 28.00 avg-zkey = 1.97 avg-val = 116.70 avg-zval = 37.36 usrkeys = 927568 avg-key = 20.00 avg-zkey = 1.97 avg-val = 120.21 avg-zval = 37.36 TagRS{ kinds = RS_Key0_TagN bytes = 145040 } TagArray{ size = 464669 bytes = 1626352 } seq expand size = 3252683 multi value expand size = 0 cnt WriteAppend = 30 UnZipSize{ index = 0.0186 GB value = 0.1082 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0347 GB dict = 1.08 MB all = 0.0393 GB } UnZip/Zip{ index = 10.1764 value = 3.1234 dict = 1.00 all = 3.4117 } Zip/UnZip{ index = 0.0983 value = 0.3202 dict = 1.00 all = 0.2931 } ---------------------------- total value len = 1.140505 GB avg = 0.123 KB (by entry num) total key len = 0.259146 GB avg = 0.028 KB total ukey len = 0.185104 GB avg = 0.020 KB total ukey num = 0.009255198 Billion total entry num = 0.009255198 Billion write speed all = 0.062704791 MB/sec (with seq num) write speed all = 0.059387705 MB/sec (without seq num) 2024/11/20-14:59:43.168420 140256904238656 [compaction_job.cc:1948] [default] [JOB 11360] Generated table #37459: 927568 keys, 39340713 bytes, temperature: kWarm 2024/11/20-14:59:43.168507 140256904238656 EVENT_LOG_v1 {"time_micros": 1732085983168462, "cf_name": "default", "job": 11360, "event": "table_file_creation", "file_number": 37459, "file_size": 39340713, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 669117809, "table_properties": {"data_size": 34656000, "index_size": 1822976, "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": 25971904, "raw_average_key_size": 28, "raw_value_size": 108245944, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 927568, "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": 1732085974, "oldest_key_time": 0, "file_creation_time": 1732085974, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "92E45FH6K6HCJOD41QCQ", "orig_file_number": 37459, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-14:59:43.235171 140256904238656 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037460.sst) /dev/shm/ToplingTemp/Topling-426367-TZXRH3 2024/11/20-14:59:44.733856 140256904238656 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037460.sst): first pass time = 1.50's, 89.561'MB/sec 2024/11/20-14:59:48.419420 140256904238656 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037460.sst): old prealloc_size = 147639500, real_size = 36522224 2024/11/20-14:59:48.420088 140256904238656 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037460.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 927124 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.94 raw-val = 0.1083 GB zip-val = 0.0345 GB avg-val = 116.77 avg-zval = 37.20 2024/11/20-14:59:48.420300 140256904238656 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037460.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-14:59:49.570512 140256904238656 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037460.sst): second pass time = 3.68's, 29.379'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.15's, 32.884'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2825.541'MB/sec (index lex order gen) rebuild zvType time = 0.72's, 0.320'MB/sec write SST data time = 0.43's, 88.806'MB/sec dict compress time = 140278.07's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.080'MB, throughput = 21435.544'MB/sec zip my value time = 3.68's, unzip length = 0.108'GB zip my value throughput = 29.379'MB/sec zip pipeline throughput = 154.396'MB/sec entries = 927124 avg-key = 28.00 avg-zkey = 1.94 avg-val = 116.77 avg-zval = 37.20 usrkeys = 927124 avg-key = 20.00 avg-zkey = 1.94 avg-val = 117.50 avg-zval = 37.20 TagRS{ kinds = RS_Key0_TagN bytes = 144960 } TagArray{ size = 96697 bytes = 326368 } seq expand size = 676879 multi value expand size = 0 cnt WriteAppend = 46 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.0379 GB } UnZip/Zip{ index = 10.3065 value = 3.1387 dict = 1.00 all = 3.5459 } Zip/UnZip{ index = 0.0970 value = 0.3186 dict = 1.00 all = 0.2820 } ---------------------------- total value len = 1.249441 GB avg = 0.123 KB (by entry num) total key len = 0.285105 GB avg = 0.028 KB total ukey len = 0.203646 GB avg = 0.020 KB total ukey num = 0.010182322 Billion total entry num = 0.010182322 Billion write speed all = 0.068728235 MB/sec (with seq num) write speed all = 0.065079921 MB/sec (without seq num) 2024/11/20-14:59:49.634209 140256904238656 [compaction_job.cc:1948] [default] [JOB 11360] Generated table #37460: 927124 keys, 37851545 bytes, temperature: kWarm 2024/11/20-14:59:49.634290 140256904238656 EVENT_LOG_v1 {"time_micros": 1732085989634245, "cf_name": "default", "job": 11360, "event": "table_file_creation", "file_number": 37460, "file_size": 37851545, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 535975517, "table_properties": {"data_size": 34491168, "index_size": 1799104, "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": 25959472, "raw_average_key_size": 28, "raw_value_size": 108258340, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 927124, "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": 1732085983, "oldest_key_time": 0, "file_creation_time": 1732085983, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "92E45FH6K6HCJOD41QCQ", "orig_file_number": 37460, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-14:59:49.713264 140256904238656 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037461.sst) /dev/shm/ToplingTemp/Topling-426367-ajVMb3 2024/11/20-14:59:51.353543 140256904238656 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037461.sst): first pass time = 1.64's, 81.830'MB/sec 2024/11/20-14:59:55.078168 140256904238656 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037461.sst): old prealloc_size = 147639500, real_size = 36386288 2024/11/20-14:59:55.078884 140256904238656 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037461.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 926868 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.94 raw-val = 0.1083 GB zip-val = 0.0344 GB avg-val = 116.81 avg-zval = 37.07 2024/11/20-14:59:55.079077 140256904238656 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037461.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-14:59:56.949515 140256904238656 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037461.sst): second pass time = 3.72's, 29.074'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.87's, 19.987'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2690.187'MB/sec (index lex order gen) rebuild zvType time = 1.46's, 0.159'MB/sec write SST data time = 0.41's, 91.427'MB/sec dict compress time = 140278.07's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.080'MB, throughput = 27830.487'MB/sec zip my value time = 3.72's, unzip length = 0.108'GB zip my value throughput = 29.074'MB/sec zip pipeline throughput = 187.170'MB/sec entries = 926868 avg-key = 28.00 avg-zkey = 1.94 avg-val = 116.81 avg-zval = 37.07 usrkeys = 926868 avg-key = 20.00 avg-zkey = 1.94 avg-val = 116.84 avg-zval = 37.07 TagRS{ kinds = RS_Key0_TagN bytes = 144920 } TagArray{ size = 3954 bytes = 12864 } seq expand size = 27678 multi value expand size = 0 cnt WriteAppend = 52 UnZipSize{ index = 0.0185 GB value = 0.1083 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0344 GB dict = 1.08 MB all = 0.0374 GB } UnZip/Zip{ index = 10.3066 value = 3.1513 dict = 1.00 all = 3.5885 } Zip/UnZip{ index = 0.0970 value = 0.3173 dict = 1.00 all = 0.2787 } ---------------------------- total value len = 1.357734 GB avg = 0.122 KB (by entry num) total key len = 0.311057 GB avg = 0.028 KB total ukey len = 0.222184 GB avg = 0.020 KB total ukey num = 0.011109190 Billion total entry num = 0.011109190 Billion write speed all = 0.074716043 MB/sec (with seq num) write speed all = 0.070736949 MB/sec (without seq num) 2024/11/20-14:59:56.999710 140256904238656 [compaction_job.cc:1948] [default] [JOB 11360] Generated table #37461: 926868 keys, 37402231 bytes, temperature: kWarm 2024/11/20-14:59:56.999798 140256904238656 EVENT_LOG_v1 {"time_micros": 1732085996999754, "cf_name": "default", "job": 11360, "event": "table_file_creation", "file_number": 37461, "file_size": 37402231, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 538604047, "table_properties": {"data_size": 34355808, "index_size": 1798592, "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": 25952304, "raw_average_key_size": 28, "raw_value_size": 108265532, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 926868, "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": 1732085989, "oldest_key_time": 0, "file_creation_time": 1732085989, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "92E45FH6K6HCJOD41QCQ", "orig_file_number": 37461, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-14:59:57.061588 140256904238656 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037462.sst) /dev/shm/ToplingTemp/Topling-426367-zFtf65 2024/11/20-14:59:58.870535 140256904238656 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037462.sst): first pass time = 1.81's, 74.199'MB/sec 2024/11/20-15:00:00.234441 140256904238656 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037462.sst): old prealloc_size = 147639500, real_size = 36508608 2024/11/20-15:00:00.234970 140256904238656 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037462.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 926840 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.94 raw-val = 0.1083 GB zip-val = 0.0345 GB avg-val = 116.81 avg-zval = 37.20 2024/11/20-15:00:00.235394 140256904238656 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037462.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-15:00:01.410456 140256904238656 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037462.sst): second pass time = 1.36's, 79.434'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.18's, 32.948'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3620.158'MB/sec (index lex order gen) rebuild zvType time = 0.92's, 0.253'MB/sec write SST data time = 0.26's, 149.332'MB/sec dict compress time = 140278.07's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.080'MB, throughput = 29492.560'MB/sec zip my value time = 1.36's, unzip length = 0.108'GB zip my value throughput = 79.434'MB/sec zip pipeline throughput = 79.434'MB/sec entries = 926840 avg-key = 28.00 avg-zkey = 1.94 avg-val = 116.81 avg-zval = 37.20 usrkeys = 926840 avg-key = 20.00 avg-zkey = 1.94 avg-val = 119.58 avg-zval = 37.20 TagRS{ kinds = RS_Key0_TagN bytes = 144920 } TagArray{ size = 365968 bytes = 1235152 } seq expand size = 2561776 multi value expand size = 0 cnt WriteAppend = 43 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.0387 GB } UnZip/Zip{ index = 10.3063 value = 3.1401 dict = 1.00 all = 3.4640 } Zip/UnZip{ index = 0.0970 value = 0.3185 dict = 1.00 all = 0.2887 } ---------------------------- total value len = 1.468562 GB avg = 0.122 KB (by entry num) total key len = 0.337009 GB avg = 0.028 KB total ukey len = 0.240721 GB avg = 0.020 KB total ukey num = 0.012036030 Billion total entry num = 0.012036030 Billion write speed all = 0.080823871 MB/sec (with seq num) write speed all = 0.076513661 MB/sec (without seq num) 2024/11/20-15:00:01.463232 140256904238656 [compaction_job.cc:1948] [default] [JOB 11360] Generated table #37462: 926840 keys, 38746735 bytes, temperature: kWarm 2024/11/20-15:00:01.463326 140256904238656 EVENT_LOG_v1 {"time_micros": 1732086001463279, "cf_name": "default", "job": 11360, "event": "table_file_creation", "file_number": 37462, "file_size": 38746735, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 541395865, "table_properties": {"data_size": 34478128, "index_size": 1798592, "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": 25951520, "raw_average_key_size": 28, "raw_value_size": 108266256, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 926840, "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": 1732085997, "oldest_key_time": 0, "file_creation_time": 1732085997, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "92E45FH6K6HCJOD41QCQ", "orig_file_number": 37462, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-15:00:01.525287 140256904238656 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037463.sst) /dev/shm/ToplingTemp/Topling-426367-2JSjI6 2024/11/20-15:00:03.115096 140256904238656 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037463.sst): first pass time = 1.59's, 84.428'MB/sec 2024/11/20-15:00:04.772559 140256904238656 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037463.sst): old prealloc_size = 147639500, real_size = 36871728 2024/11/20-15:00:04.773381 140256904238656 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037463.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 924424 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.97 raw-val = 0.1083 GB zip-val = 0.0348 GB avg-val = 117.19 avg-zval = 37.67 2024/11/20-15:00:04.774115 140256904238656 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037463.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-15:00:05.728495 140256904238656 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037463.sst): second pass time = 1.64's, 65.911'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.96's, 42.160'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2282.776'MB/sec (index lex order gen) rebuild zvType time = 0.80's, 0.290'MB/sec write SST data time = 0.16's, 252.581'MB/sec dict compress time = 140278.07's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.082'MB, throughput = 16097.873'MB/sec zip my value time = 1.64's, unzip length = 0.108'GB zip my value throughput = 65.911'MB/sec zip pipeline throughput = 96.127'MB/sec entries = 924424 avg-key = 28.00 avg-zkey = 1.97 avg-val = 117.19 avg-zval = 37.67 usrkeys = 924424 avg-key = 20.00 avg-zkey = 1.97 avg-val = 122.44 avg-zval = 37.67 TagRS{ kinds = RS_Key0_TagN bytes = 144560 } TagArray{ size = 692992 bytes = 2425488 } seq expand size = 4850944 multi value expand size = 0 cnt WriteAppend = 37 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.0403 GB } UnZip/Zip{ index = 10.1780 value = 3.1109 dict = 1.00 all = 3.3303 } Zip/UnZip{ index = 0.0983 value = 0.3214 dict = 1.00 all = 0.3003 } ---------------------------- total value len = 1.581747 GB avg = 0.122 KB (by entry num) total key len = 0.362893 GB avg = 0.028 KB total ukey len = 0.259209 GB avg = 0.020 KB total ukey num = 0.012960454 Billion total entry num = 0.012960454 Billion write speed all = 0.087032266 MB/sec (with seq num) write speed all = 0.082391909 MB/sec (without seq num) 2024/11/20-15:00:05.776839 140256904238656 [compaction_job.cc:1948] [default] [JOB 11360] Generated table #37463: 924424 keys, 40301904 bytes, temperature: kWarm 2024/11/20-15:00:05.776899 140256904238656 EVENT_LOG_v1 {"time_micros": 1732086005776869, "cf_name": "default", "job": 11360, "event": "table_file_creation", "file_number": 37463, "file_size": 40301904, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 669115942, "table_properties": {"data_size": 34823904, "index_size": 1816512, "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": 25883872, "raw_average_key_size": 28, "raw_value_size": 108333896, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 924424, "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": 1732086001, "oldest_key_time": 0, "file_creation_time": 1732086001, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "92E45FH6K6HCJOD41QCQ", "orig_file_number": 37463, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-15:00:05.814256 140256904238656 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037464.sst) /dev/shm/ToplingTemp/Topling-426367-TAZWs6 2024/11/20-15:00:06.764867 140256904238656 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037464.sst): first pass time = 0.95's, 141.196'MB/sec 2024/11/20-15:00:08.342867 140256904238656 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037464.sst): old prealloc_size = 147639500, real_size = 37320528 2024/11/20-15:00:08.343641 140256904238656 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037464.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 925719 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.0353 GB avg-val = 116.99 avg-zval = 38.15 2024/11/20-15:00:08.344541 140256904238656 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037464.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/20-15:00:09.903209 140256904238656 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037464.sst): second pass time = 1.58's, 68.670'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.56's, 26.543'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2360.435'MB/sec (index lex order gen) rebuild zvType time = 1.23's, 0.188'MB/sec write SST data time = 0.33's, 124.910'MB/sec dict compress time = 140278.07's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.080'MB, throughput = 28586.268'MB/sec zip my value time = 1.58's, unzip length = 0.108'GB zip my value throughput = 68.670'MB/sec zip pipeline throughput = 103.641'MB/sec entries = 925719 avg-key = 28.00 avg-zkey = 1.92 avg-val = 116.99 avg-zval = 38.15 usrkeys = 925719 avg-key = 20.00 avg-zkey = 1.92 avg-val = 123.99 avg-zval = 38.15 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 925719 bytes = 3240032 } seq expand size = 6480033 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.0353 GB dict = 1.08 MB all = 0.0414 GB } UnZip/Zip{ index = 10.4436 value = 3.0665 dict = 1.00 all = 3.2408 } Zip/UnZip{ index = 0.0958 value = 0.3261 dict = 1.00 all = 0.3086 } ---------------------------- total value len = 1.696524 GB avg = 0.122 KB (by entry num) total key len = 0.388813 GB avg = 0.028 KB total ukey len = 0.277723 GB avg = 0.020 KB total ukey num = 0.013886173 Billion total entry num = 0.013886173 Billion write speed all = 0.093311760 MB/sec (with seq num) write speed all = 0.088340887 MB/sec (without seq num) 2024/11/20-15:00:09.959879 140256904238656 [compaction_job.cc:1948] [default] [JOB 11360] Generated table #37464: 925719 keys, 41415346 bytes, temperature: kWarm 2024/11/20-15:00:09.959955 140256904238656 EVENT_LOG_v1 {"time_micros": 1732086009959912, "cf_name": "default", "job": 11360, "event": "table_file_creation", "file_number": 37464, "file_size": 41415346, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 487201374, "largest_seqno": 669117947, "table_properties": {"data_size": 35316096, "index_size": 1772800, "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": 25920132, "raw_average_key_size": 28, "raw_value_size": 108297690, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 925719, "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": 1732086005, "oldest_key_time": 0, "file_creation_time": 1732086005, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "92E45FH6K6HCJOD41QCQ", "orig_file_number": 37464, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-15:00:10.067809 140256904238656 [top_zip_table_builder.cc:960] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037465.sst) /dev/shm/ToplingTemp/Topling-426367-UDHn92 2024/11/20-15:00:11.429018 140256904238656 [top_zip_table_builder.cc:1378] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037465.sst): first pass time = 1.36's, 73.076'MB/sec 2024/11/20-15:00:19.073681 140256904238656 [top_zip_table_builder.cc:2798] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037465.sst): old prealloc_size = 147639500, real_size = 27397744 2024/11/20-15:00:19.074314 140256904238656 [top_zip_table_builder.cc:1799] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037465.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 686295 prefix = 4 raw-key = 0.0110 GB zip-key = 0.0013 GB avg-key = 16.00 avg-zkey = 1.94 raw-val = 0.0803 GB zip-val = 0.0259 GB avg-val = 116.93 avg-zval = 37.73 2024/11/20-15:00:19.074652 140256904238656 [top_zip_table_builder.cc:1325] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037465.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0017 GB, waited 0.000 sec, Key+Value = 0.099 GB 2024/11/20-15:00:20.106435 140256904238656 [top_zip_table_builder.cc:3129] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00/037465.sst): second pass time = 7.64's, 10.499'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.03's, 27.939'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2281.564'MB/sec (index lex order gen) rebuild zvType time = 0.82's, 0.208'MB/sec write SST data time = 0.21's, 138.604'MB/sec dict compress time = 140278.07's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.806'MB, throughput = 15676.029'MB/sec zip my value time = 7.64's, unzip length = 0.080'GB zip my value throughput = 10.499'MB/sec zip pipeline throughput = 279.957'MB/sec entries = 686295 avg-key = 28.00 avg-zkey = 1.94 avg-val = 116.93 avg-zval = 37.73 usrkeys = 686295 avg-key = 20.00 avg-zkey = 1.94 avg-val = 118.99 avg-zval = 37.73 TagRS{ kinds = RS_Key0_TagN bytes = 107320 } TagArray{ size = 201970 bytes = 706912 } seq expand size = 1413790 multi value expand size = 0 cnt WriteAppend = 21 UnZipSize{ index = 0.0137 GB value = 0.0803 GB dict = 0.81 MB all = 0.0995 GB } __ZipSize{ index = 0.0013 GB value = 0.0259 GB dict = 0.81 MB all = 0.0289 GB } UnZip/Zip{ index = 10.3050 value = 3.0992 dict = 1.00 all = 3.4473 } Zip/UnZip{ index = 0.0970 value = 0.3227 dict = 1.00 all = 0.2901 } ---------------------------- total value len = 1.778190 GB avg = 0.122 KB (by entry num) total key len = 0.408029 GB avg = 0.028 KB total ukey len = 0.291449 GB avg = 0.020 KB total ukey num = 0.014572468 Billion total entry num = 0.014572468 Billion write speed all = 0.097781218 MB/sec (with seq num) write speed all = 0.092567051 MB/sec (without seq num) 2024/11/20-15:00:20.148037 140256904238656 [compaction_job.cc:1948] [default] [JOB 11360] Generated table #37465: 686295 keys, 28853695 bytes, temperature: kWarm 2024/11/20-15:00:20.148143 140256904238656 EVENT_LOG_v1 {"time_micros": 1732086020148102, "cf_name": "default", "job": 11360, "event": "table_file_creation", "file_number": 37465, "file_size": 28853695, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 664577330, "table_properties": {"data_size": 25894048, "index_size": 1331968, "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": 19216260, "raw_average_key_size": 28, "raw_value_size": 80251386, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 686295, "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": 1732086010, "oldest_key_time": 0, "file_creation_time": 1732086010, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "d89b4006-2803-486e-b7a2-759bcf348921", "db_session_id": "92E45FH6K6HCJOD41QCQ", "orig_file_number": 37465, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/20-15:00:20.177934 140256904238656 [compaction_job.cc:703] job-11360: subcompact[0], size: 0.627383 G, files: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-11360/att-00 [037450,037451,037452,037453,037454,037455,037456,037457,037458,037459,037460,037461,037462,037463,037464,037465] 2024/11/20-15:00:20.428325 140256904238656 (Original Log Time 2024/11/20-14:58:37.853329) EVENT_LOG_v1 {"time_micros": 1732085917853282, "job": 11360, "event": "compaction_started", "compaction_reason": "FilesMarkedForCompaction", "files_L2": [37415], "files_L3": [37352, 37356, 37380, 37387, 37390, 37398, 37412, 37253, 37254, 37255, 37256, 37257, 37258, 37259, 37260, 37261, 37219, 37175], "score": 0.879224, "input_data_size": 672267476, "oldest_snapshot_seqno": 671973505} 2024/11/20-15:00:20.428332 140256904238656 (Original Log Time 2024/11/20-15:00:20.426317) [compaction_job.cc:2022] [default] [JOB 11360] Compacted 1@2 + 18@3 files to L3 => 627383404 bytes 2024/11/20-15:00:20.428334 140256904238656 (Original Log Time 2024/11/20-15:00:20.428204) [compaction_job.cc:1224] [default] compacted to: files[0 0 0 16 0 0 0] max score 0.02, MB/sec: 6.6 rd, 6.1 wr, level 3, files in(1, 18) out(16 +0 blob) MB in(54.4, 586.7 +0.0 blob) out(598.3 +0.0 blob), read-write-amplify(22.8) write-amplify(11.0) OK, records in: 14771799, records dropped: 199331 output_compression: Snappy 2024/11/20-15:00:20.428341 140256904238656 (Original Log Time 2024/11/20-15:00:20.428290) EVENT_LOG_v1 {"time_micros": 1732086020428241, "cf": "default", "job": 11360, "event": "compaction_finished", "compaction_time_micros": 102324622, "compaction_time_cpu_micros": 30980646, "output_level": 3, "num_output_files": 16, "total_output_size": 627383404, "num_input_records": 14771799, "num_output_records": 14572468, "num_subcompactions": 1, "output_compression": "Snappy", "num_single_delete_mismatches": 0, "num_single_delete_fallthrough": 0, "file_write_nanos": 632389785, "file_range_sync_nanos": 0, "file_fsync_nanos": 18435, "file_prepare_write_nanos": 64481, "lsm_state": [0, 0, 0, 16, 0, 0, 0]} 2024/11/20-15:00:20.576813 140256904238656 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":1732076400,"starts":1732085917,"executesMs":102742,"compactionJobId":11360,"attempt":0,"compactionInputRawBytes":2141039778,"compactionInputZipBytes":672267476,"compactionOutputRawBytes":0,"compactionOutputZipBytes":627383404,"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-06d2cf4835304dc1af2ee3baa7f03d19-46d575d393b6176d-00"}}, response = 2024/11/20-15:00:20.576935 140256904238656 INFO dcompact_worker.cpp:1464: finish /worker/dcompact-log/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/2024-11-20T12.20.00/.rocksdb/job-11360/att-00: olev 3, work 102.742 s, result 16.511 ms, install 2.067 ms, input{raw 1.994 GiB zip 641.124 MiB}