2024/11/23-13:03:08.189392 139957651584576 DEBG dcompact_worker.cpp:2214: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00: fork to child time = 0.015068 sec 2024/11/23-13:03:08.190204 139957651584576 DEBG dcompact_worker.cpp:1013: Beg SerDeRead: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00 2024/11/23-13:03:08.197098 139957651584576 DEBG dcompact_worker.cpp:1033: End SerDeRead: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00 2024/11/23-13:03:08.198267 139957651584576 TRAC dcompact_worker.cpp:1083: INFO_LOG_LEVEL: rpc = INFO_LEVEL, env_var = undefined 2024/11/23-13:03:08.198596 139957651584576 [WARN] [column_family.cc:386] multiple cf_paths/db_paths and level_compaction_dynamic_level_bytes can't be used together 2024/11/23-13:03:08.250954 139957651584576 [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-26464/att-00/MANIFEST-206347 2024/11/23-13:03:08.285832 139957651584576 [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-26464/att-00/MANIFEST-206347 succeeded,manifest_file_number is 206347, next_file_number is 260486, last_sequence is 3987211129, log_number is 0,prev_log_number is 0,max_column_family is 0,min_log_number_to_keep is 260332 2024/11/23-13:03:08.285849 139957651584576 [version_set.cc:6266] Column family [default] (ID 0), log number is 0 2024/11/23-13:03:08.285990 139957651584576 [version_set.cc:5721] Creating manifest 260486 2024/11/23-13:03:08.319641 139957651584576 DEBG dcompact_worker.cpp:1218: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00: bottommost_level: fake = 1, rpc = 0 2024/11/23-13:03:08.339793 139957651584576 [compaction_job.cc:2437] [default] [JOB 26464] Compacting 1@2 + 8@3 files to L3, score 1.00, subcompactions 1 : 1 2024/11/23-13:03:08.339820 139957651584576 [compaction_job.cc:2445] [default]: Compaction start summary: Base version 19830 Base level 2, inputs: [260476(21MB)], [260418(35MB) 260419(34MB) 260420(35MB) 260421(36MB) 260422(35MB) 260423(36MB) 260424(36MB) 260425(35MB)] 2024/11/23-13:03:08.347606 139957651584576 [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-13:03:08.347656 139957651584576 [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-13:03:08.347684 139957651584576 [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-13:03:08.347693 139957651584576 [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-13:03:08.347710 139957651584576 [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-13:03:09.124045 139957651584576 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260487.sst) /dev/shm/ToplingTemp/Topling-55187-GO9Bpc 2024/11/23-13:03:10.142793 139957651584576 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260487.sst): first pass time = 1.02's, 131.756'MB/sec 2024/11/23-13:03:11.954580 139957651584576 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260487.sst): old prealloc_size = 147639500, real_size = 32715216 2024/11/23-13:03:11.955181 139957651584576 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260487.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 928651 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.0307 GB avg-val = 116.53 avg-zval = 33.08 2024/11/23-13:03:11.955916 139957651584576 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260487.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-13:03:13.122162 139957651584576 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260487.sst): second pass time = 1.80's, 60.101'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.17's, 31.336'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3045.429'MB/sec (index lex order gen) rebuild zvType time = 1.02's, 0.228'MB/sec write SST data time = 0.15's, 249.539'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 = 37586.968'MB/sec zip my value time = 1.80's, unzip length = 0.108'GB zip my value throughput = 60.101'MB/sec zip pipeline throughput = 60.101'MB/sec entries = 928651 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.53 avg-zval = 33.08 usrkeys = 928651 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.53 avg-zval = 33.08 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 928651 bytes = 3018128 } seq expand size = 6500557 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.0307 GB dict = 1.08 MB all = 0.0366 GB } UnZip/Zip{ index = 10.5116 value = 3.5231 dict = 1.00 all = 3.6685 } Zip/UnZip{ index = 0.0951 value = 0.2838 dict = 1.00 all = 0.2726 } ---------------------------- total value len = 8.963336 GB avg = 0.168 KB (by entry num) total key len = 1.466823 GB avg = 0.028 KB total ukey len = 1.016451 GB avg = 0.015 KB total ukey num = 0.066479086 Billion total entry num = 0.053286815 Billion write speed all = 0.700908811 MB/sec (with seq num) write speed all = 0.672261733 MB/sec (without seq num) 2024/11/23-13:03:13.167415 139957651584576 [compaction_job.cc:1948] [default] [JOB 26464] Generated table #260487: 928651 keys, 36586860 bytes, temperature: kWarm 2024/11/23-13:03:13.167504 139957651584576 EVENT_LOG_v1 {"time_micros": 1732338193167449, "cf_name": "default", "job": 26464, "event": "table_file_creation", "file_number": 260487, "file_size": 36586860, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3925603882, "largest_seqno": 3987177147, "table_properties": {"data_size": 30715968, "index_size": 1766912, "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": 26002228, "raw_average_key_size": 28, "raw_value_size": 108215530, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 928651, "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": 1732338189, "oldest_key_time": 0, "file_creation_time": 1732338189, "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": 260487, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-13:03:13.209555 139957651584576 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260488.sst) /dev/shm/ToplingTemp/Topling-55187-7JlCCd 2024/11/23-13:03:14.371784 139957651584576 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260488.sst): first pass time = 1.16's, 115.487'MB/sec 2024/11/23-13:03:19.376742 139957651584576 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260488.sst): old prealloc_size = 147639500, real_size = 32460688 2024/11/23-13:03:19.377513 139957651584576 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260488.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 933906 prefix = 4 raw-key = 0.0149 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.1081 GB zip-val = 0.0305 GB avg-val = 115.72 avg-zval = 32.61 2024/11/23-13:03:19.378527 139957651584576 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260488.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-13:03:20.469840 139957651584576 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260488.sst): second pass time = 5.00's, 21.619'MB/sec, value only(80.5% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.09's, 33.572'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2459.726'MB/sec (index lex order gen) rebuild zvType time = 0.95's, 0.247'MB/sec write SST data time = 0.15's, 251.526'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 = 37691.829'MB/sec zip my value time = 5.00's, unzip length = 0.108'GB zip my value throughput = 21.619'MB/sec zip pipeline throughput = 102.640'MB/sec entries = 933906 avg-key = 28.00 avg-zkey = 1.90 avg-val = 115.72 avg-zval = 32.61 usrkeys = 933906 avg-key = 20.00 avg-zkey = 1.90 avg-val = 122.72 avg-zval = 32.61 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 933906 bytes = 3385424 } seq expand size = 6537342 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0187 GB value = 0.1081 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0305 GB dict = 1.08 MB all = 0.0367 GB } UnZip/Zip{ index = 10.5124 value = 3.5490 dict = 1.00 all = 3.6575 } Zip/UnZip{ index = 0.0951 value = 0.2818 dict = 1.00 all = 0.2734 } ---------------------------- total value len = 9.077942 GB avg = 0.167 KB (by entry num) total key len = 1.492973 GB avg = 0.028 KB total ukey len = 1.035129 GB avg = 0.015 KB total ukey num = 0.067412992 Billion total entry num = 0.054220721 Billion write speed all = 0.710017004 MB/sec (with seq num) write speed all = 0.680882242 MB/sec (without seq num) 2024/11/23-13:03:20.524697 139957651584576 [compaction_job.cc:1948] [default] [JOB 26464] Generated table #260488: 933906 keys, 36696536 bytes, temperature: kWarm 2024/11/23-13:03:20.524797 139957651584576 EVENT_LOG_v1 {"time_micros": 1732338200524733, "cf_name": "default", "job": 26464, "event": "table_file_creation", "file_number": 260488, "file_size": 36696536, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3711387651, "largest_seqno": 3987175977, "table_properties": {"data_size": 30450240, "index_size": 1776768, "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": 26149368, "raw_average_key_size": 28, "raw_value_size": 108068444, "raw_average_value_size": 115, "num_data_blocks": 1, "num_entries": 933906, "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": 1732338193, "oldest_key_time": 0, "file_creation_time": 1732338193, "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": 260488, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-13:03:20.596517 139957651584576 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260489.sst) /dev/shm/ToplingTemp/Topling-55187-lbC7jc 2024/11/23-13:03:21.672279 139957651584576 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260489.sst): first pass time = 1.08's, 124.772'MB/sec 2024/11/23-13:03:25.116621 139957651584576 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260489.sst): old prealloc_size = 147639500, real_size = 32752240 2024/11/23-13:03:25.117192 139957651584576 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260489.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 929732 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.0307 GB avg-val = 116.36 avg-zval = 33.06 2024/11/23-13:03:25.117949 139957651584576 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260489.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-13:03:26.615794 139957651584576 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260489.sst): second pass time = 3.44's, 31.416'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.50's, 24.509'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3243.883'MB/sec (index lex order gen) rebuild zvType time = 1.27's, 0.184'MB/sec write SST data time = 0.23's, 158.034'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 = 36279.201'MB/sec zip my value time = 3.44's, unzip length = 0.108'GB zip my value throughput = 31.416'MB/sec zip pipeline throughput = 115.197'MB/sec entries = 929732 avg-key = 28.00 avg-zkey = 1.92 avg-val = 116.36 avg-zval = 33.06 usrkeys = 929732 avg-key = 20.00 avg-zkey = 1.92 avg-val = 123.36 avg-zval = 33.06 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 929732 bytes = 3137856 } seq expand size = 6508124 multi value expand size = 0 cnt WriteAppend = 15 UnZipSize{ index = 0.0186 GB value = 0.1082 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0307 GB dict = 1.08 MB all = 0.0367 GB } UnZip/Zip{ index = 10.4436 value = 3.5195 dict = 1.00 all = 3.6529 } Zip/UnZip{ index = 0.0958 value = 0.2841 dict = 1.00 all = 0.2738 } ---------------------------- total value len = 9.192635 GB avg = 0.167 KB (by entry num) total key len = 1.519005 GB avg = 0.028 KB total ukey len = 1.053724 GB avg = 0.015 KB total ukey num = 0.068342724 Billion total entry num = 0.055150453 Billion write speed all = 0.719172265 MB/sec (with seq num) write speed all = 0.689550153 MB/sec (without seq num) 2024/11/23-13:03:26.666178 139957651584576 [compaction_job.cc:1948] [default] [JOB 26464] Generated table #260489: 929732 keys, 36742520 bytes, temperature: kWarm 2024/11/23-13:03:26.666248 139957651584576 EVENT_LOG_v1 {"time_micros": 1732338206666210, "cf_name": "default", "job": 26464, "event": "table_file_creation", "file_number": 260489, "file_size": 36742520, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3855348712, "largest_seqno": 3987175994, "table_properties": {"data_size": 30739168, "index_size": 1780480, "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": 26032496, "raw_average_key_size": 28, "raw_value_size": 108185240, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 929732, "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": 1732338200, "oldest_key_time": 0, "file_creation_time": 1732338200, "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": 260489, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-13:03:26.708829 139957651584576 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260490.sst) /dev/shm/ToplingTemp/Topling-55187-KxMbPb 2024/11/23-13:03:28.311531 139957651584576 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260490.sst): first pass time = 1.60's, 83.747'MB/sec 2024/11/23-13:03:30.215351 139957651584576 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260490.sst): old prealloc_size = 147639500, real_size = 34750928 2024/11/23-13:03:30.215854 139957651584576 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260490.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 931609 prefix = 4 raw-key = 0.0149 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1081 GB zip-val = 0.0327 GB avg-val = 116.07 avg-zval = 35.14 2024/11/23-13:03:30.216649 139957651584576 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260490.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-13:03:31.221472 139957651584576 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260490.sst): second pass time = 1.89's, 57.066'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.01's, 38.511'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3699.854'MB/sec (index lex order gen) rebuild zvType time = 0.88's, 0.266'MB/sec write SST data time = 0.13's, 296.805'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 = 37192.383'MB/sec zip my value time = 1.89's, unzip length = 0.108'GB zip my value throughput = 57.066'MB/sec zip pipeline throughput = 63.334'MB/sec entries = 931609 avg-key = 28.00 avg-zkey = 1.91 avg-val = 116.07 avg-zval = 35.14 usrkeys = 931609 avg-key = 20.00 avg-zkey = 1.91 avg-val = 123.07 avg-zval = 35.14 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 931609 bytes = 3144192 } seq expand size = 6521263 multi value expand size = 0 cnt WriteAppend = 14 UnZipSize{ index = 0.0186 GB value = 0.1081 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0327 GB dict = 1.08 MB all = 0.0387 GB } UnZip/Zip{ index = 10.4455 value = 3.3034 dict = 1.00 all = 3.4640 } Zip/UnZip{ index = 0.0957 value = 0.3027 dict = 1.00 all = 0.2887 } ---------------------------- total value len = 9.307289 GB avg = 0.166 KB (by entry num) total key len = 1.545090 GB avg = 0.028 KB total ukey len = 1.072356 GB avg = 0.015 KB total ukey num = 0.069274333 Billion total entry num = 0.056082062 Billion write speed all = 0.728396152 MB/sec (with seq num) write speed all = 0.698282970 MB/sec (without seq num) 2024/11/23-13:03:31.271884 139957651584576 [compaction_job.cc:1948] [default] [JOB 26464] Generated table #260490: 931609 keys, 38746218 bytes, temperature: kWarm 2024/11/23-13:03:31.271941 139957651584576 EVENT_LOG_v1 {"time_micros": 1732338211271908, "cf_name": "default", "job": 26464, "event": "table_file_creation", "file_number": 260490, "file_size": 38746218, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3898575090, "largest_seqno": 3987176391, "table_properties": {"data_size": 32734080, "index_size": 1783744, "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": 26085052, "raw_average_key_size": 28, "raw_value_size": 108132726, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 931609, "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": 1732338206, "oldest_key_time": 0, "file_creation_time": 1732338206, "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": 260490, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-13:03:31.309628 139957651584576 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260491.sst) /dev/shm/ToplingTemp/Topling-55187-hvIdba 2024/11/23-13:03:32.333284 139957651584576 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260491.sst): first pass time = 1.02's, 131.121'MB/sec 2024/11/23-13:03:34.093796 139957651584576 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260491.sst): old prealloc_size = 147639500, real_size = 32974544 2024/11/23-13:03:34.094470 139957651584576 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260491.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 930530 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.0310 GB avg-val = 116.24 avg-zval = 33.28 2024/11/23-13:03:34.095318 139957651584576 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260491.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-13:03:35.152180 139957651584576 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260491.sst): second pass time = 1.76's, 61.467'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.06's, 34.928'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2739.249'MB/sec (index lex order gen) rebuild zvType time = 0.85's, 0.273'MB/sec write SST data time = 0.21's, 178.967'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 = 26771.343'MB/sec zip my value time = 1.76's, unzip length = 0.108'GB zip my value throughput = 61.467'MB/sec zip pipeline throughput = 69.209'MB/sec entries = 930530 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.24 avg-zval = 33.28 usrkeys = 930530 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.24 avg-zval = 33.28 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 930530 bytes = 3140560 } seq expand size = 6513710 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.0310 GB dict = 1.08 MB all = 0.0370 GB } UnZip/Zip{ index = 10.5111 value = 3.4924 dict = 1.00 all = 3.6308 } Zip/UnZip{ index = 0.0951 value = 0.2863 dict = 1.00 all = 0.2754 } ---------------------------- total value len = 9.421966 GB avg = 0.165 KB (by entry num) total key len = 1.571145 GB avg = 0.028 KB total ukey len = 1.090967 GB avg = 0.016 KB total ukey num = 0.070204863 Billion total entry num = 0.057012592 Billion write speed all = 0.737647238 MB/sec (with seq num) write speed all = 0.707042485 MB/sec (without seq num) 2024/11/23-13:03:35.204322 139957651584576 [compaction_job.cc:1948] [default] [JOB 26464] Generated table #260491: 930530 keys, 36966702 bytes, temperature: kWarm 2024/11/23-13:03:35.204398 139957651584576 EVENT_LOG_v1 {"time_micros": 1732338215204361, "cf_name": "default", "job": 26464, "event": "table_file_creation", "file_number": 260491, "file_size": 36966702, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3883658141, "largest_seqno": 3987176287, "table_properties": {"data_size": 30971136, "index_size": 1770560, "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": 26054840, "raw_average_key_size": 28, "raw_value_size": 108162920, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 930530, "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": 1732338211, "oldest_key_time": 0, "file_creation_time": 1732338211, "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": 260491, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-13:03:35.243381 139957651584576 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260492.sst) /dev/shm/ToplingTemp/Topling-55187-y8dqv9 2024/11/23-13:03:36.542691 139957651584576 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260492.sst): first pass time = 1.30's, 103.302'MB/sec 2024/11/23-13:03:38.187944 139957651584576 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260492.sst): old prealloc_size = 147639500, real_size = 34524400 2024/11/23-13:03:38.188678 139957651584576 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260492.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 934622 prefix = 4 raw-key = 0.0150 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1080 GB zip-val = 0.0325 GB avg-val = 115.61 avg-zval = 34.77 2024/11/23-13:03:38.189519 139957651584576 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260492.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-13:03:39.064061 139957651584576 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260492.sst): second pass time = 1.64's, 65.707'MB/sec, value only(80.5% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.88's, 44.006'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2597.399'MB/sec (index lex order gen) rebuild zvType time = 0.72's, 0.326'MB/sec write SST data time = 0.16's, 243.986'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 = 28416.880'MB/sec zip my value time = 1.64's, unzip length = 0.108'GB zip my value throughput = 65.707'MB/sec zip pipeline throughput = 65.707'MB/sec entries = 934622 avg-key = 28.00 avg-zkey = 1.91 avg-val = 115.61 avg-zval = 34.77 usrkeys = 934622 avg-key = 20.00 avg-zkey = 1.91 avg-val = 121.66 avg-zval = 34.77 TagRS{ kinds = RS_Key0_TagN bytes = 146120 } TagArray{ size = 807815 bytes = 3029328 } seq expand size = 5654705 multi value expand size = 0 cnt WriteAppend = 17 UnZipSize{ index = 0.0187 GB value = 0.1080 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0325 GB dict = 1.08 MB all = 0.0386 GB } UnZip/Zip{ index = 10.4456 value = 3.3245 dict = 1.00 all = 3.4813 } Zip/UnZip{ index = 0.0957 value = 0.3008 dict = 1.00 all = 0.2872 } ---------------------------- total value len = 9.535669 GB avg = 0.165 KB (by entry num) total key len = 1.597314 GB avg = 0.028 KB total ukey len = 1.109659 GB avg = 0.016 KB total ukey num = 0.071139485 Billion total entry num = 0.057947214 Billion write speed all = 0.746836768 MB/sec (with seq num) write speed all = 0.715738465 MB/sec (without seq num) 2024/11/23-13:03:39.111568 139957651584576 [compaction_job.cc:1948] [default] [JOB 26464] Generated table #260492: 934622 keys, 38553900 bytes, temperature: kWarm 2024/11/23-13:03:39.111633 139957651584576 EVENT_LOG_v1 {"time_micros": 1732338219111601, "cf_name": "default", "job": 26464, "event": "table_file_creation", "file_number": 260492, "file_size": 38553900, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 3987177065, "table_properties": {"data_size": 32501088, "index_size": 1789504, "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": 26169416, "raw_average_key_size": 28, "raw_value_size": 108048396, "raw_average_value_size": 115, "num_data_blocks": 1, "num_entries": 934622, "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": 1732338215, "oldest_key_time": 0, "file_creation_time": 1732338215, "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": 260492, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-13:03:39.149565 139957651584576 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260493.sst) /dev/shm/ToplingTemp/Topling-55187-PR0gNa 2024/11/23-13:03:40.054011 139957651584576 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260493.sst): first pass time = 0.90's, 148.403'MB/sec 2024/11/23-13:03:41.603984 139957651584576 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260493.sst): old prealloc_size = 147639500, real_size = 36450432 2024/11/23-13:03:41.604513 139957651584576 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260493.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 924138 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.0345 GB avg-val = 117.24 avg-zval = 37.29 2024/11/23-13:03:41.604903 139957651584576 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260493.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-13:03:42.356053 139957651584576 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260493.sst): second pass time = 1.55's, 69.933'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.75's, 51.468'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3544.602'MB/sec (index lex order gen) rebuild zvType time = 0.63's, 0.368'MB/sec write SST data time = 0.12's, 314.430'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 = 36474.004'MB/sec zip my value time = 1.55's, unzip length = 0.108'GB zip my value throughput = 69.933'MB/sec zip pipeline throughput = 69.933'MB/sec entries = 924138 avg-key = 28.00 avg-zkey = 1.90 avg-val = 117.24 avg-zval = 37.29 usrkeys = 924138 avg-key = 20.00 avg-zkey = 1.90 avg-val = 119.76 avg-zval = 37.29 TagRS{ kinds = RS_Key0_TagN bytes = 144480 } TagArray{ size = 333465 bytes = 1250512 } seq expand size = 2334255 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.0345 GB dict = 1.08 MB all = 0.0387 GB } UnZip/Zip{ index = 10.5127 value = 3.1439 dict = 1.00 all = 3.4677 } Zip/UnZip{ index = 0.0951 value = 0.3181 dict = 1.00 all = 0.2884 } ---------------------------- total value len = 9.646345 GB avg = 0.164 KB (by entry num) total key len = 1.623190 GB avg = 0.028 KB total ukey len = 1.128142 GB avg = 0.016 KB total ukey num = 0.072063623 Billion total entry num = 0.058871352 Billion write speed all = 0.755830214 MB/sec (with seq num) write speed all = 0.724242934 MB/sec (without seq num) 2024/11/23-13:03:42.403959 139957651584576 [compaction_job.cc:1948] [default] [JOB 26464] Generated table #260493: 924138 keys, 38705633 bytes, temperature: kWarm 2024/11/23-13:03:42.404040 139957651584576 EVENT_LOG_v1 {"time_micros": 1732338222404007, "cf_name": "default", "job": 26464, "event": "table_file_creation", "file_number": 260493, "file_size": 38705633, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 0, "largest_seqno": 3966471804, "table_properties": {"data_size": 34461040, "index_size": 1758144, "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": 25875864, "raw_average_key_size": 28, "raw_value_size": 108342004, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 924138, "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": 1732338219, "oldest_key_time": 0, "file_creation_time": 1732338219, "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": 260493, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-13:03:42.438803 139957651584576 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260494.sst) /dev/shm/ToplingTemp/Topling-55187-ZcaUYa 2024/11/23-13:03:43.331852 139957651584576 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260494.sst): first pass time = 0.89's, 150.297'MB/sec 2024/11/23-13:03:44.753945 139957651584576 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260494.sst): old prealloc_size = 147639500, real_size = 32808432 2024/11/23-13:03:44.754496 139957651584576 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260494.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 931463 prefix = 4 raw-key = 0.0149 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1081 GB zip-val = 0.0308 GB avg-val = 116.09 avg-zval = 33.06 2024/11/23-13:03:44.755316 139957651584576 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260494.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-13:03:45.623048 139957651584576 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260494.sst): second pass time = 1.42's, 76.079'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.87's, 42.615'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3540.296'MB/sec (index lex order gen) rebuild zvType time = 0.74's, 0.313'MB/sec write SST data time = 0.13's, 295.613'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 = 37854.309'MB/sec zip my value time = 1.42's, unzip length = 0.108'GB zip my value throughput = 76.079'MB/sec zip pipeline throughput = 84.525'MB/sec entries = 931463 avg-key = 28.00 avg-zkey = 1.91 avg-val = 116.09 avg-zval = 33.06 usrkeys = 931463 avg-key = 20.00 avg-zkey = 1.91 avg-val = 123.09 avg-zval = 33.06 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 931463 bytes = 3376576 } seq expand size = 6520241 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0186 GB value = 0.1081 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0308 GB dict = 1.08 MB all = 0.0370 GB } UnZip/Zip{ index = 10.4454 value = 3.5119 dict = 1.00 all = 3.6240 } Zip/UnZip{ index = 0.0957 value = 0.2847 dict = 1.00 all = 0.2759 } ---------------------------- total value len = 9.761002 GB avg = 0.163 KB (by entry num) total key len = 1.649271 GB avg = 0.028 KB total ukey len = 1.146771 GB avg = 0.016 KB total ukey num = 0.072995086 Billion total entry num = 0.059802815 Billion write speed all = 0.765101653 MB/sec (with seq num) write speed all = 0.733021627 MB/sec (without seq num) 2024/11/23-13:03:45.670158 139957651584576 [compaction_job.cc:1948] [default] [JOB 26464] Generated table #260494: 931463 keys, 37036312 bytes, temperature: kWarm 2024/11/23-13:03:45.670225 139957651584576 EVENT_LOG_v1 {"time_micros": 1732338225670190, "cf_name": "default", "job": 26464, "event": "table_file_creation", "file_number": 260494, "file_size": 37036312, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3509327862, "largest_seqno": 3987176807, "table_properties": {"data_size": 30791904, "index_size": 1783488, "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": 26080964, "raw_average_key_size": 28, "raw_value_size": 108136854, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 931463, "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": 1732338222, "oldest_key_time": 0, "file_creation_time": 1732338222, "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": 260494, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-13:03:45.705028 139957651584576 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260495.sst) /dev/shm/ToplingTemp/Topling-55187-neyjJd 2024/11/23-13:03:45.790300 139957651584576 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260495.sst): first pass time = 0.09's, 236.485'MB/sec 2024/11/23-13:03:45.977178 139957651584576 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260495.sst): old prealloc_size = 147639500, real_size = 5469104 2024/11/23-13:03:45.977335 139957651584576 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260495.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 141945 prefix = 4 raw-key = 0.0023 GB zip-key = 0.0003 GB avg-key = 16.00 avg-zkey = 1.94 raw-val = 0.0162 GB zip-val = 0.0052 GB avg-val = 114.00 avg-zval = 36.34 2024/11/23-13:03:45.977489 139957651584576 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260495.sst: sumWaitingMem = 0.000 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0003 GB, waited 0.000 sec, Key+Value = 0.020 GB 2024/11/23-13:03:46.107124 139957651584576 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00/260495.sst): second pass time = 0.19's, 86.952'MB/sec, value only(80.3% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.13's, 46.550'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2122.503'MB/sec (index lex order gen) rebuild zvType time = 0.11's, 0.326'MB/sec write SST data time = 0.02's, 287.353'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.170'MB, throughput = 6089.857'MB/sec zip my value time = 0.19's, unzip length = 0.016'GB zip my value throughput = 86.952'MB/sec zip pipeline throughput = 86.952'MB/sec entries = 141945 avg-key = 28.00 avg-zkey = 1.94 avg-val = 114.00 avg-zval = 36.34 usrkeys = 141945 avg-key = 20.00 avg-zkey = 1.94 avg-val = 121.00 avg-zval = 36.34 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 141945 bytes = 443600 } seq expand size = 993615 multi value expand size = 0 cnt WriteAppend = 14 UnZipSize{ index = 0.0028 GB value = 0.0162 GB dict = 0.17 MB all = 0.0202 GB } __ZipSize{ index = 0.0003 GB value = 0.0052 GB dict = 0.17 MB all = 0.0060 GB } UnZip/Zip{ index = 10.3350 value = 3.1368 dict = 1.00 all = 3.3323 } Zip/UnZip{ index = 0.0968 value = 0.3188 dict = 1.00 all = 0.3001 } ---------------------------- total value len = 9.778177 GB avg = 0.163 KB (by entry num) total key len = 1.653246 GB avg = 0.028 KB total ukey len = 1.149610 GB avg = 0.016 KB total ukey num = 0.073137031 Billion total entry num = 0.059944760 Billion write speed all = 0.766494946 MB/sec (with seq num) write speed all = 0.734339821 MB/sec (without seq num) 2024/11/23-13:03:46.122774 139957651584576 [compaction_job.cc:1948] [default] [JOB 26464] Generated table #260495: 141945 keys, 6048725 bytes, temperature: kWarm 2024/11/23-13:03:46.122838 139957651584576 EVENT_LOG_v1 {"time_micros": 1732338226122805, "cf_name": "default", "job": 26464, "event": "table_file_creation", "file_number": 260495, "file_size": 6048725, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3915813072, "largest_seqno": 3941450132, "table_properties": {"data_size": 5158752, "index_size": 274688, "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": 3974460, "raw_average_key_size": 28, "raw_value_size": 16181730, "raw_average_value_size": 114, "num_data_blocks": 1, "num_entries": 141945, "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": 114, "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": 1732338225, "oldest_key_time": 0, "file_creation_time": 1732338225, "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": 260495, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-13:03:46.137157 139957651584576 [compaction_job.cc:703] job-26464: subcompact[0], size: 0.306083 G, files: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-26464/att-00 [260487,260488,260489,260490,260491,260492,260493,260494,260495] 2024/11/23-13:03:46.198291 139957651584576 (Original Log Time 2024/11/23-13:03:08.339905) EVENT_LOG_v1 {"time_micros": 1732338188339841, "job": 26464, "event": "compaction_started", "compaction_reason": "FilesMarkedForCompaction", "files_L2": [260476], "files_L3": [260418, 260419, 260420, 260421, 260422, 260423, 260424, 260425], "score": 0.999809, "input_data_size": 321553805, "oldest_snapshot_seqno": 3987211037} 2024/11/23-13:03:46.198295 139957651584576 (Original Log Time 2024/11/23-13:03:46.197399) [compaction_job.cc:2022] [default] [JOB 26464] Compacted 1@2 + 8@3 files to L3 => 306083406 bytes 2024/11/23-13:03:46.198297 139957651584576 (Original Log Time 2024/11/23-13:03:46.198229) [compaction_job.cc:1224] [default] compacted to: files[0 0 0 9 0 0 0] max score 0.01, MB/sec: 8.5 rd, 8.1 wr, level 3, files in(1, 8) out(9 +0 blob) MB in(21.2, 285.5 +0.0 blob) out(291.9 +0.0 blob), read-write-amplify(28.3) write-amplify(13.8) OK, records in: 7628843, records dropped: 42247 output_compression: Snappy 2024/11/23-13:03:46.198303 139957651584576 (Original Log Time 2024/11/23-13:03:46.198271) EVENT_LOG_v1 {"time_micros": 1732338226198251, "cf": "default", "job": 26464, "event": "compaction_finished", "compaction_time_micros": 37797260, "compaction_time_cpu_micros": 13646244, "output_level": 3, "num_output_files": 9, "total_output_size": 306083406, "num_input_records": 7628843, "num_output_records": 7586596, "num_subcompactions": 1, "output_compression": "Snappy", "num_single_delete_mismatches": 0, "num_single_delete_fallthrough": 0, "file_write_nanos": 260815332, "file_range_sync_nanos": 0, "file_fsync_nanos": 6374, "file_prepare_write_nanos": 23687, "lsm_state": [0, 0, 0, 9, 0, 0, 0]} 2024/11/23-13:03:46.318500 139957651584576 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":1732338188,"executesMs":37999,"compactionJobId":26464,"attempt":0,"compactionInputRawBytes":1099897606,"compactionInputZipBytes":321553805,"compactionOutputRawBytes":0,"compactionOutputZipBytes":306083406,"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-b7bcfd8a8e3acd3e5f9f8f1c81235968-37585f7dbc34771b-00"}}, response = 2024/11/23-13:03:46.318592 139957651584576 INFO dcompact_worker.cpp:1459: finish /worker/dcompact-log/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/2024-11-22T14.14.14/.rocksdb/job-26464/att-00: olev 3, work 38.000 s, result 7.739 ms, install 0.921 ms, input{raw 1.024 GiB zip 306.658 MiB}