2024/08/20-19:34:33.743064 140466387236416 DEBG dcompact_worker.cpp:2211: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00: fork to child time = 0.008849 sec 2024/08/20-19:34:33.743994 140466387236416 DEBG dcompact_worker.cpp:1011: Beg SerDeRead: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00 2024/08/20-19:34:33.749223 140466387236416 DEBG dcompact_worker.cpp:1031: End SerDeRead: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00 2024/08/20-19:34:33.750620 140466387236416 TRAC dcompact_worker.cpp:1081: INFO_LOG_LEVEL: rpc = INFO_LEVEL, env_var = undefined 2024/08/20-19:34:33.750955 140466387236416 [WARN] [column_family.cc:386] multiple cf_paths/db_paths and level_compaction_dynamic_level_bytes can't be used together 2024/08/20-19:34:33.807185 140466387236416 [version_set.cc:6139] Recovering from manifest file: /worker/dcompact-log/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/2024-08-20T02.42.00/.rocksdb/job-46690/att-00/MANIFEST-14629260 2024/08/20-19:34:33.862901 140466387236416 [version_set.cc:6182] Recovered from manifest file:/worker/dcompact-log/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/2024-08-20T02.42.00/.rocksdb/job-46690/att-00/MANIFEST-14629260 succeeded,manifest_file_number is 14629260, next_file_number is 14683031, last_sequence is 190964129233, log_number is 0,prev_log_number is 0,max_column_family is 0,min_log_number_to_keep is 14682873 2024/08/20-19:34:33.862915 140466387236416 [version_set.cc:6197] Column family [default] (ID 0), log number is 0 2024/08/20-19:34:33.863035 140466387236416 [version_set.cc:5652] Creating manifest 14683031 2024/08/20-19:34:33.896291 140466387236416 DEBG dcompact_worker.cpp:1215: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00: bottommost_level: fake = 1, rpc = 0 2024/08/20-19:34:33.915331 140466387236416 [compaction_job.cc:2433] [default] [JOB 46690] Compacting 1@1 + 8@2 files to L2, score 0.99, subcompactions 1 : 1 2024/08/20-19:34:33.915351 140466387236416 [compaction_job.cc:2441] [default]: Compaction start summary: Base version 23762 Base level 1, inputs: [14683024(23MB)], [14682987(20MB) 14682979(19MB) 14682980(20MB) 14682981(20MB) 14682982(20MB) 14682983(10005KB) 14682948(19MB) 14682949(19MB)] 2024/08/20-19:34:34.107601 140466387236416 [top_zip_table.cc:59] core git_version_hash_info_is:commit 7517bad5c1a147474c3830831b9a22c996321ae8 Author: leipeng Date: 2024-01-08 19:18:17 +0800 vfork_cmd: call close before wait_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. 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/08/20-19:34:34.107629 140466387236416 [top_zip_table.cc:60] fsa git_version_hash_info_is:commit 7517bad5c1a147474c3830831b9a22c996321ae8 Author: leipeng Date: 2024-01-08 19:18:17 +0800 vfork_cmd: call close before wait_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. 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/08/20-19:34:34.107649 140466387236416 [top_zip_table.cc:61] zbs git_version_hash_info_is:commit 7517bad5c1a147474c3830831b9a22c996321ae8 Author: leipeng Date: 2024-01-08 19:18:17 +0800 vfork_cmd: call close before wait_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. 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/08/20-19:34:34.107660 140466387236416 [top_zip_table.cc:62] topling-zip_table_reader: git_version_hash_info_is: commit 7f80399bfbd2071b6e0f5683e8ab7225b8e6e394 Author: leipeng Date: 2024-01-19 14:52:30 +0800 Change ToplingZipTableOptions::sampleRatio to vector 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/08/20-19:34:34.107670 140466387236416 [top_zip_table.cc:64] topling-rocks git_version_hash_info_is: commit 1240987ca13d0fe562c9b9c037155079f0877840 Author: leipeng Date: 2024-01-19 15:07:04 +0800 Change ToplingZipTableOptions::sampleRatio to vector 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/08/20-19:34:34.275743 140466387236416 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683032.sst) /dev/shm/ToplingTemp/Topling-42023-Sv2JyL 2024/08/20-19:34:34.536374 140466387236416 [top_zip_table_builder.cc:1344] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683032.sst): first pass time = 0.26's, 257.543'MB/sec 2024/08/20-19:34:35.210867 140466387236416 [top_zip_table_builder.cc:2764] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683032.sst): old prealloc_size = 73819750, real_size = 19371376 2024/08/20-19:34:35.211217 140466387236416 [top_zip_table_builder.cc:1765] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683032.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 466936 prefix = 4 raw-key = 0.0075 GB zip-key = 0.0009 GB avg-key = 16.00 avg-zkey = 1.89 raw-val = 0.0540 GB zip-val = 0.0184 GB avg-val = 115.72 avg-zval = 39.34 2024/08/20-19:34:35.211674 140466387236416 [top_zip_table_builder.cc:1295] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683032.sst: sumWaitingMem = 0.001 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0011 GB, waited 0.000 sec, Key+Value = 0.067 GB 2024/08/20-19:34:35.579488 140466387236416 [top_zip_table_builder.cc:3092] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683032.sst): second pass time = 0.67's, 80.218'MB/sec, value only(80.5% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.37's, 57.995'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2716.411'MB/sec (index lex order gen) rebuild zvType time = 0.30's, 0.389'MB/sec write SST data time = 0.07's, 313.250'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.542'MB, throughput = 13016.274'MB/sec zip my value time = 0.67's, unzip length = 0.054'GB zip my value throughput = 80.218'MB/sec zip pipeline throughput = 80.218'MB/sec entries = 466936 avg-key = 28.00 avg-zkey = 1.89 avg-val = 115.72 avg-zval = 39.34 usrkeys = 466936 avg-key = 20.00 avg-zkey = 1.89 avg-val = 122.72 avg-zval = 39.34 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 466936 bytes = 1575920 } seq expand size = 3268552 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0093 GB value = 0.0540 GB dict = 0.54 MB all = 0.0671 GB } __ZipSize{ index = 0.0009 GB value = 0.0184 GB dict = 0.54 MB all = 0.0214 GB } UnZip/Zip{ index = 10.5722 value = 2.9413 dict = 1.00 all = 3.1391 } Zip/UnZip{ index = 0.0946 value = 0.3400 dict = 1.00 all = 0.3186 } ---------------------------- total value len = 0.057303 GB avg = 0.123 KB (by entry num) total key len = 0.013074 GB avg = 0.028 KB total ukey len = 0.009339 GB avg = 0.020 KB total ukey num = 0.000466936 Billion total entry num = 0.000466936 Billion write speed all = 0.009447316 MB/sec (with seq num) write speed all = 0.008945873 MB/sec (without seq num) 2024/08/20-19:34:35.611109 140466387236416 [compaction_job.cc:1944] [default] [JOB 46690] Generated table #14683032: 466936 keys, 21378204 bytes, temperature: kWarm 2024/08/20-19:34:35.611196 140466387236416 EVENT_LOG_v1 {"time_micros": 1724153675611148, "cf_name": "default", "job": 46690, "event": "table_file_creation", "file_number": 14683032, "file_size": 21378204, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 190888803993, "largest_seqno": 190964103249, "table_properties": {"data_size": 18371104, "index_size": 883328, "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": 13074208, "raw_average_key_size": 28, "raw_value_size": 54034760, "raw_average_value_size": 115, "num_data_blocks": 1, "num_entries": 466936, "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": 1724153674, "oldest_key_time": 0, "file_creation_time": 1724153674, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "a007a635-5c0a-4b4a-be96-b9c695cb016b", "db_session_id": "90ZT1ZM5QNL093I8HHQG", "orig_file_number": 14683032, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/08/20-19:34:35.637687 140466387236416 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683033.sst) /dev/shm/ToplingTemp/Topling-42023-9P9oZN 2024/08/20-19:34:36.043283 140466387236416 [top_zip_table_builder.cc:1344] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683033.sst): first pass time = 0.41's, 165.475'MB/sec 2024/08/20-19:34:36.716851 140466387236416 [top_zip_table_builder.cc:2764] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683033.sst): old prealloc_size = 73819750, real_size = 18835360 2024/08/20-19:34:36.717205 140466387236416 [top_zip_table_builder.cc:1765] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683033.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 465519 prefix = 4 raw-key = 0.0074 GB zip-key = 0.0009 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.0541 GB zip-val = 0.0178 GB avg-val = 116.16 avg-zval = 38.31 2024/08/20-19:34:36.717655 140466387236416 [top_zip_table_builder.cc:1295] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683033.sst: sumWaitingMem = 0.001 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0011 GB, waited 0.000 sec, Key+Value = 0.067 GB 2024/08/20-19:34:37.090124 140466387236416 [top_zip_table_builder.cc:3092] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683033.sst): second pass time = 0.67's, 80.373'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.37's, 55.984'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2754.640'MB/sec (index lex order gen) rebuild zvType time = 0.31's, 0.381'MB/sec write SST data time = 0.07's, 310.588'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.544'MB, throughput = 12838.510'MB/sec zip my value time = 0.67's, unzip length = 0.054'GB zip my value throughput = 80.373'MB/sec zip pipeline throughput = 80.373'MB/sec entries = 465519 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.16 avg-zval = 38.31 usrkeys = 465519 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.16 avg-zval = 38.31 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 465519 bytes = 1629328 } seq expand size = 3258633 multi value expand size = 0 cnt WriteAppend = 14 UnZipSize{ index = 0.0093 GB value = 0.0541 GB dict = 0.54 MB all = 0.0671 GB } __ZipSize{ index = 0.0009 GB value = 0.0178 GB dict = 0.54 MB all = 0.0209 GB } UnZip/Zip{ index = 10.5013 value = 3.0324 dict = 1.00 all = 3.2114 } Zip/UnZip{ index = 0.0952 value = 0.3298 dict = 1.00 all = 0.3114 } ---------------------------- total value len = 0.114636 GB avg = 0.123 KB (by entry num) total key len = 0.026109 GB avg = 0.028 KB total ukey len = 0.018649 GB avg = 0.020 KB total ukey num = 0.000932455 Billion total entry num = 0.000932455 Billion write speed all = 0.018889463 MB/sec (with seq num) write speed all = 0.017888301 MB/sec (without seq num) 2024/08/20-19:34:37.121340 140466387236416 [compaction_job.cc:1944] [default] [JOB 46690] Generated table #14683033: 465519 keys, 20897224 bytes, temperature: kWarm 2024/08/20-19:34:37.121411 140466387236416 EVENT_LOG_v1 {"time_micros": 1724153677121377, "cf_name": "default", "job": 46690, "event": "table_file_creation", "file_number": 14683033, "file_size": 20897224, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 190828498134, "largest_seqno": 190964106475, "table_properties": {"data_size": 17832208, "index_size": 886592, "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": 13034532, "raw_average_key_size": 28, "raw_value_size": 54074378, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 465519, "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": 1724153675, "oldest_key_time": 0, "file_creation_time": 1724153675, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "a007a635-5c0a-4b4a-be96-b9c695cb016b", "db_session_id": "90ZT1ZM5QNL093I8HHQG", "orig_file_number": 14683033, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/08/20-19:34:37.150706 140466387236416 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683034.sst) /dev/shm/ToplingTemp/Topling-42023-ivVE6M 2024/08/20-19:34:37.566016 140466387236416 [top_zip_table_builder.cc:1344] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683034.sst): first pass time = 0.42's, 161.610'MB/sec 2024/08/20-19:34:38.239348 140466387236416 [top_zip_table_builder.cc:2764] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683034.sst): old prealloc_size = 73819750, real_size = 19116208 2024/08/20-19:34:38.239729 140466387236416 [top_zip_table_builder.cc:1765] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683034.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 466450 prefix = 4 raw-key = 0.0075 GB zip-key = 0.0009 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.0540 GB zip-val = 0.0181 GB avg-val = 115.87 avg-zval = 38.83 2024/08/20-19:34:38.240134 140466387236416 [top_zip_table_builder.cc:1295] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683034.sst: sumWaitingMem = 0.001 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0011 GB, waited 0.000 sec, Key+Value = 0.067 GB 2024/08/20-19:34:38.607384 140466387236416 [top_zip_table_builder.cc:3092] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683034.sst): second pass time = 0.67's, 80.370'MB/sec, value only(80.5% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.37's, 57.228'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2495.648'MB/sec (index lex order gen) rebuild zvType time = 0.30's, 0.388'MB/sec write SST data time = 0.07's, 312.387'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.542'MB, throughput = 15582.306'MB/sec zip my value time = 0.67's, unzip length = 0.054'GB zip my value throughput = 80.370'MB/sec zip pipeline throughput = 80.370'MB/sec entries = 466450 avg-key = 28.00 avg-zkey = 1.90 avg-val = 115.87 avg-zval = 38.83 usrkeys = 466450 avg-key = 20.00 avg-zkey = 1.90 avg-val = 122.87 avg-zval = 38.83 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 466450 bytes = 1515984 } seq expand size = 3265150 multi value expand size = 0 cnt WriteAppend = 12 UnZipSize{ index = 0.0093 GB value = 0.0540 GB dict = 0.54 MB all = 0.0671 GB } __ZipSize{ index = 0.0009 GB value = 0.0181 GB dict = 0.54 MB all = 0.0211 GB } UnZip/Zip{ index = 10.5026 value = 2.9843 dict = 1.00 all = 3.1863 } Zip/UnZip{ index = 0.0952 value = 0.3351 dict = 1.00 all = 0.3138 } ---------------------------- total value len = 0.171950 GB avg = 0.123 KB (by entry num) total key len = 0.039169 GB avg = 0.028 KB total ukey len = 0.027978 GB avg = 0.020 KB total ukey num = 0.001398905 Billion total entry num = 0.001398905 Billion write speed all = 0.028328637 MB/sec (with seq num) write speed all = 0.026826961 MB/sec (without seq num) 2024/08/20-19:34:38.638024 140466387236416 [compaction_job.cc:1944] [default] [JOB 46690] Generated table #14683034: 466450 keys, 21061618 bytes, temperature: kWarm 2024/08/20-19:34:38.638095 140466387236416 EVENT_LOG_v1 {"time_micros": 1724153678638060, "cf_name": "default", "job": 46690, "event": "table_file_creation", "file_number": 14683034, "file_size": 21061618, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 190905322099, "largest_seqno": 190964108116, "table_properties": {"data_size": 18111136, "index_size": 888256, "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": 13060600, "raw_average_key_size": 28, "raw_value_size": 54048356, "raw_average_value_size": 115, "num_data_blocks": 1, "num_entries": 466450, "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": 1724153677, "oldest_key_time": 0, "file_creation_time": 1724153677, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "a007a635-5c0a-4b4a-be96-b9c695cb016b", "db_session_id": "90ZT1ZM5QNL093I8HHQG", "orig_file_number": 14683034, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/08/20-19:34:38.671608 140466387236416 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683035.sst) /dev/shm/ToplingTemp/Topling-42023-ksEMnN 2024/08/20-19:34:39.086746 140466387236416 [top_zip_table_builder.cc:1344] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683035.sst): first pass time = 0.42's, 161.674'MB/sec 2024/08/20-19:34:39.785299 140466387236416 [top_zip_table_builder.cc:2764] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683035.sst): old prealloc_size = 73819750, real_size = 19763680 2024/08/20-19:34:39.785694 140466387236416 [top_zip_table_builder.cc:1765] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683035.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 466434 prefix = 4 raw-key = 0.0075 GB zip-key = 0.0009 GB avg-key = 16.00 avg-zkey = 1.89 raw-val = 0.0540 GB zip-val = 0.0188 GB avg-val = 115.88 avg-zval = 40.23 2024/08/20-19:34:39.786091 140466387236416 [top_zip_table_builder.cc:1295] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683035.sst: sumWaitingMem = 0.001 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0011 GB, waited 0.000 sec, Key+Value = 0.067 GB 2024/08/20-19:34:40.150924 140466387236416 [top_zip_table_builder.cc:3092] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683035.sst): second pass time = 0.70's, 77.460'MB/sec, value only(80.5% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.37's, 59.541'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2432.322'MB/sec (index lex order gen) rebuild zvType time = 0.30's, 0.392'MB/sec write SST data time = 0.07's, 321.471'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.543'MB, throughput = 14133.622'MB/sec zip my value time = 0.70's, unzip length = 0.054'GB zip my value throughput = 77.460'MB/sec zip pipeline throughput = 77.460'MB/sec entries = 466434 avg-key = 28.00 avg-zkey = 1.89 avg-val = 115.88 avg-zval = 40.23 usrkeys = 466434 avg-key = 20.00 avg-zkey = 1.89 avg-val = 122.88 avg-zval = 40.23 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 466434 bytes = 1574224 } seq expand size = 3265038 multi value expand size = 0 cnt WriteAppend = 12 UnZipSize{ index = 0.0093 GB value = 0.0540 GB dict = 0.54 MB all = 0.0671 GB } __ZipSize{ index = 0.0009 GB value = 0.0188 GB dict = 0.54 MB all = 0.0218 GB } UnZip/Zip{ index = 10.5716 value = 2.8804 dict = 1.00 all = 3.0827 } Zip/UnZip{ index = 0.0946 value = 0.3472 dict = 1.00 all = 0.3244 } ---------------------------- total value len = 0.229264 GB avg = 0.123 KB (by entry num) total key len = 0.052229 GB avg = 0.028 KB total ukey len = 0.037307 GB avg = 0.020 KB total ukey num = 0.001865339 Billion total entry num = 0.001865339 Billion write speed all = 0.037763818 MB/sec (with seq num) write speed all = 0.035761856 MB/sec (without seq num) 2024/08/20-19:34:40.182553 140466387236416 [compaction_job.cc:1944] [default] [JOB 46690] Generated table #14683035: 466434 keys, 21769258 bytes, temperature: kWarm 2024/08/20-19:34:40.182648 140466387236416 EVENT_LOG_v1 {"time_micros": 1724153680182611, "cf_name": "default", "job": 46690, "event": "table_file_creation", "file_number": 14683035, "file_size": 21769258, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 190852267535, "largest_seqno": 190964108423, "table_properties": {"data_size": 18764432, "index_size": 882432, "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": 13060152, "raw_average_key_size": 28, "raw_value_size": 54048788, "raw_average_value_size": 115, "num_data_blocks": 1, "num_entries": 466434, "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": 1724153678, "oldest_key_time": 0, "file_creation_time": 1724153678, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "a007a635-5c0a-4b4a-be96-b9c695cb016b", "db_session_id": "90ZT1ZM5QNL093I8HHQG", "orig_file_number": 14683035, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/08/20-19:34:40.208587 140466387236416 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683036.sst) /dev/shm/ToplingTemp/Topling-42023-HPjKQN 2024/08/20-19:34:40.620063 140466387236416 [top_zip_table_builder.cc:1344] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683036.sst): first pass time = 0.41's, 163.115'MB/sec 2024/08/20-19:34:41.298058 140466387236416 [top_zip_table_builder.cc:2764] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683036.sst): old prealloc_size = 73819750, real_size = 19284336 2024/08/20-19:34:41.298389 140466387236416 [top_zip_table_builder.cc:1765] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683036.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 466987 prefix = 4 raw-key = 0.0075 GB zip-key = 0.0009 GB avg-key = 16.00 avg-zkey = 1.93 raw-val = 0.0540 GB zip-val = 0.0183 GB avg-val = 115.71 avg-zval = 39.12 2024/08/20-19:34:41.298815 140466387236416 [top_zip_table_builder.cc:1295] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683036.sst: sumWaitingMem = 0.001 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0011 GB, waited 0.000 sec, Key+Value = 0.067 GB 2024/08/20-19:34:41.661620 140466387236416 [top_zip_table_builder.cc:3092] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683036.sst): second pass time = 0.68's, 79.789'MB/sec, value only(80.5% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.36's, 58.569'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2985.830'MB/sec (index lex order gen) rebuild zvType time = 0.30's, 0.394'MB/sec write SST data time = 0.07's, 317.238'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.542'MB, throughput = 12915.210'MB/sec zip my value time = 0.68's, unzip length = 0.054'GB zip my value throughput = 79.789'MB/sec zip pipeline throughput = 79.789'MB/sec entries = 466987 avg-key = 28.00 avg-zkey = 1.93 avg-val = 115.71 avg-zval = 39.12 usrkeys = 466987 avg-key = 20.00 avg-zkey = 1.93 avg-val = 122.71 avg-zval = 39.12 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 466987 bytes = 1576096 } seq expand size = 3268909 multi value expand size = 0 cnt WriteAppend = 15 UnZipSize{ index = 0.0093 GB value = 0.0540 GB dict = 0.54 MB all = 0.0671 GB } __ZipSize{ index = 0.0009 GB value = 0.0183 GB dict = 0.54 MB all = 0.0213 GB } UnZip/Zip{ index = 10.3661 value = 2.9581 dict = 1.00 all = 3.1519 } Zip/UnZip{ index = 0.0965 value = 0.3381 dict = 1.00 all = 0.3173 } ---------------------------- total value len = 0.286566 GB avg = 0.123 KB (by entry num) total key len = 0.065305 GB avg = 0.028 KB total ukey len = 0.046647 GB avg = 0.020 KB total ukey num = 0.002332326 Billion total entry num = 0.002332326 Billion write speed all = 0.047195825 MB/sec (with seq num) write speed all = 0.044693180 MB/sec (without seq num) 2024/08/20-19:34:41.694523 140466387236416 [compaction_job.cc:1944] [default] [JOB 46690] Generated table #14683036: 466987 keys, 21291842 bytes, temperature: kWarm 2024/08/20-19:34:41.694614 140466387236416 EVENT_LOG_v1 {"time_micros": 1724153681694560, "cf_name": "default", "job": 46690, "event": "table_file_creation", "file_number": 14683036, "file_size": 21291842, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 190852248476, "largest_seqno": 190964095134, "table_properties": {"data_size": 18266400, "index_size": 900992, "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": 13075636, "raw_average_key_size": 28, "raw_value_size": 54033342, "raw_average_value_size": 115, "num_data_blocks": 1, "num_entries": 466987, "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": 1724153680, "oldest_key_time": 0, "file_creation_time": 1724153680, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "a007a635-5c0a-4b4a-be96-b9c695cb016b", "db_session_id": "90ZT1ZM5QNL093I8HHQG", "orig_file_number": 14683036, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/08/20-19:34:41.721709 140466387236416 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683037.sst) /dev/shm/ToplingTemp/Topling-42023-skuWqM 2024/08/20-19:34:42.200569 140466387236416 [top_zip_table_builder.cc:1344] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683037.sst): first pass time = 0.48's, 140.160'MB/sec 2024/08/20-19:34:42.860957 140466387236416 [top_zip_table_builder.cc:2764] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683037.sst): old prealloc_size = 73819750, real_size = 18006128 2024/08/20-19:34:42.861292 140466387236416 [top_zip_table_builder.cc:1765] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683037.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 464371 prefix = 4 raw-key = 0.0074 GB zip-key = 0.0009 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.0541 GB zip-val = 0.0170 GB avg-val = 116.52 avg-zval = 36.62 2024/08/20-19:34:42.861745 140466387236416 [top_zip_table_builder.cc:1295] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683037.sst: sumWaitingMem = 0.001 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0011 GB, waited 0.000 sec, Key+Value = 0.067 GB 2024/08/20-19:34:43.243197 140466387236416 [top_zip_table_builder.cc:3092] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683037.sst): second pass time = 0.66's, 82.112'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.38's, 52.337'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2874.079'MB/sec (index lex order gen) rebuild zvType time = 0.32's, 0.368'MB/sec write SST data time = 0.07's, 299.814'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.544'MB, throughput = 13768.795'MB/sec zip my value time = 0.66's, unzip length = 0.054'GB zip my value throughput = 82.112'MB/sec zip pipeline throughput = 82.112'MB/sec entries = 464371 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.52 avg-zval = 36.62 usrkeys = 464371 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.52 avg-zval = 36.62 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 464371 bytes = 1567264 } seq expand size = 3250597 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0093 GB value = 0.0541 GB dict = 0.54 MB all = 0.0671 GB } __ZipSize{ index = 0.0009 GB value = 0.0170 GB dict = 0.54 MB all = 0.0200 GB } UnZip/Zip{ index = 10.5027 value = 3.1817 dict = 1.00 all = 3.3546 } Zip/UnZip{ index = 0.0952 value = 0.3143 dict = 1.00 all = 0.2981 } ---------------------------- total value len = 0.343923 GB avg = 0.123 KB (by entry num) total key len = 0.078308 GB avg = 0.028 KB total ukey len = 0.055934 GB avg = 0.020 KB total ukey num = 0.002796697 Billion total entry num = 0.002796697 Billion write speed all = 0.056621009 MB/sec (with seq num) write speed all = 0.053620719 MB/sec (without seq num) 2024/08/20-19:34:43.273007 140466387236416 [compaction_job.cc:1944] [default] [JOB 46690] Generated table #14683037: 464371 keys, 20005124 bytes, temperature: kWarm 2024/08/20-19:34:43.273076 140466387236416 EVENT_LOG_v1 {"time_micros": 1724153683273042, "cf_name": "default", "job": 46690, "event": "table_file_creation", "file_number": 14683037, "file_size": 20005124, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 190867428234, "largest_seqno": 190964107661, "table_properties": {"data_size": 17005536, "index_size": 884288, "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": 13002388, "raw_average_key_size": 28, "raw_value_size": 54106542, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 464371, "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": 1724153681, "oldest_key_time": 0, "file_creation_time": 1724153681, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "a007a635-5c0a-4b4a-be96-b9c695cb016b", "db_session_id": "90ZT1ZM5QNL093I8HHQG", "orig_file_number": 14683037, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/08/20-19:34:43.301043 140466387236416 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683038.sst) /dev/shm/ToplingTemp/Topling-42023-RseAXM 2024/08/20-19:34:43.705652 140466387236416 [top_zip_table_builder.cc:1344] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683038.sst): first pass time = 0.40's, 165.879'MB/sec 2024/08/20-19:34:44.378748 140466387236416 [top_zip_table_builder.cc:2764] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683038.sst): old prealloc_size = 73819750, real_size = 18288896 2024/08/20-19:34:44.379090 140466387236416 [top_zip_table_builder.cc:1765] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683038.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 467557 prefix = 4 raw-key = 0.0075 GB zip-key = 0.0009 GB avg-key = 16.00 avg-zkey = 1.92 raw-val = 0.0540 GB zip-val = 0.0173 GB avg-val = 115.53 avg-zval = 36.95 2024/08/20-19:34:44.379504 140466387236416 [top_zip_table_builder.cc:1295] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683038.sst: sumWaitingMem = 0.001 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0011 GB, waited 0.000 sec, Key+Value = 0.067 GB 2024/08/20-19:34:44.755424 140466387236416 [top_zip_table_builder.cc:3092] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683038.sst): second pass time = 0.67's, 80.357'MB/sec, value only(80.5% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.38's, 53.882'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2848.481'MB/sec (index lex order gen) rebuild zvType time = 0.31's, 0.378'MB/sec write SST data time = 0.07's, 301.723'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.542'MB, throughput = 12941.151'MB/sec zip my value time = 0.67's, unzip length = 0.054'GB zip my value throughput = 80.357'MB/sec zip pipeline throughput = 80.357'MB/sec entries = 467557 avg-key = 28.00 avg-zkey = 1.92 avg-val = 115.53 avg-zval = 36.95 usrkeys = 467557 avg-key = 20.00 avg-zkey = 1.92 avg-val = 122.53 avg-zval = 36.95 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 467557 bytes = 1578016 } seq expand size = 3272899 multi value expand size = 0 cnt WriteAppend = 14 UnZipSize{ index = 0.0094 GB value = 0.0540 GB dict = 0.54 MB all = 0.0671 GB } __ZipSize{ index = 0.0009 GB value = 0.0173 GB dict = 0.54 MB all = 0.0203 GB } UnZip/Zip{ index = 10.4328 value = 3.1268 dict = 1.00 all = 3.3066 } Zip/UnZip{ index = 0.0959 value = 0.3198 dict = 1.00 all = 0.3024 } ---------------------------- total value len = 0.401213 GB avg = 0.123 KB (by entry num) total key len = 0.091399 GB avg = 0.028 KB total ukey len = 0.065285 GB avg = 0.020 KB total ukey num = 0.003264254 Billion total entry num = 0.003264254 Billion write speed all = 0.066045805 MB/sec (with seq num) write speed all = 0.062544630 MB/sec (without seq num) 2024/08/20-19:34:44.784828 140466387236416 [compaction_job.cc:1944] [default] [JOB 46690] Generated table #14683038: 467557 keys, 20295526 bytes, temperature: kWarm 2024/08/20-19:34:44.784898 140466387236416 EVENT_LOG_v1 {"time_micros": 1724153684784864, "cf_name": "default", "job": 46690, "event": "table_file_creation", "file_number": 14683038, "file_size": 20295526, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 190884497713, "largest_seqno": 190964107685, "table_properties": {"data_size": 17275504, "index_size": 896320, "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": 13091596, "raw_average_key_size": 28, "raw_value_size": 54017362, "raw_average_value_size": 115, "num_data_blocks": 1, "num_entries": 467557, "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": 1724153683, "oldest_key_time": 0, "file_creation_time": 1724153683, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "a007a635-5c0a-4b4a-be96-b9c695cb016b", "db_session_id": "90ZT1ZM5QNL093I8HHQG", "orig_file_number": 14683038, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/08/20-19:34:44.811251 140466387236416 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683039.sst) /dev/shm/ToplingTemp/Topling-42023-bL6QPO 2024/08/20-19:34:45.027974 140466387236416 [top_zip_table_builder.cc:1344] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683039.sst): first pass time = 0.22's, 269.128'MB/sec 2024/08/20-19:34:45.603742 140466387236416 [top_zip_table_builder.cc:2764] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683039.sst): old prealloc_size = 73819750, real_size = 16317584 2024/08/20-19:34:45.604034 140466387236416 [top_zip_table_builder.cc:1765] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683039.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 405044 prefix = 4 raw-key = 0.0065 GB zip-key = 0.0008 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.0470 GB zip-val = 0.0154 GB avg-val = 115.97 avg-zval = 38.13 2024/08/20-19:34:45.604378 140466387236416 [top_zip_table_builder.cc:1295] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683039.sst: sumWaitingMem = 0.001 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0010 GB, waited 0.000 sec, Key+Value = 0.058 GB 2024/08/20-19:34:45.926370 140466387236416 [top_zip_table_builder.cc:3092] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00/14683039.sst): second pass time = 0.58's, 81.690'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.32's, 55.838'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2929.186'MB/sec (index lex order gen) rebuild zvType time = 0.26's, 0.383'MB/sec write SST data time = 0.06's, 309.584'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.479'MB, throughput = 11906.696'MB/sec zip my value time = 0.58's, unzip length = 0.047'GB zip my value throughput = 81.690'MB/sec zip pipeline throughput = 81.690'MB/sec entries = 405044 avg-key = 28.00 avg-zkey = 1.90 avg-val = 115.97 avg-zval = 38.13 usrkeys = 405044 avg-key = 20.00 avg-zkey = 1.90 avg-val = 122.97 avg-zval = 38.13 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 405044 bytes = 1316400 } seq expand size = 2835308 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0081 GB value = 0.0470 GB dict = 0.48 MB all = 0.0583 GB } __ZipSize{ index = 0.0008 GB value = 0.0154 GB dict = 0.48 MB all = 0.0180 GB } UnZip/Zip{ index = 10.5025 value = 3.0413 dict = 1.00 all = 3.2371 } Zip/UnZip{ index = 0.0952 value = 0.3288 dict = 1.00 all = 0.3089 } ---------------------------- total value len = 0.451021 GB avg = 0.123 KB (by entry num) total key len = 0.102740 GB avg = 0.028 KB total ukey len = 0.073386 GB avg = 0.020 KB total ukey num = 0.003669298 Billion total entry num = 0.003669298 Billion write speed all = 0.074232603 MB/sec (with seq num) write speed all = 0.070297603 MB/sec (without seq num) 2024/08/20-19:34:45.952791 140466387236416 [compaction_job.cc:1944] [default] [JOB 46690] Generated table #14683039: 405044 keys, 18014430 bytes, temperature: kWarm 2024/08/20-19:34:45.952857 140466387236416 EVENT_LOG_v1 {"time_micros": 1724153685952825, "cf_name": "default", "job": 46690, "event": "table_file_creation", "file_number": 14683039, "file_size": 18014430, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 190922514744, "largest_seqno": 190964108348, "table_properties": {"data_size": 15444800, "index_size": 771328, "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": 11341232, "raw_average_key_size": 28, "raw_value_size": 46972828, "raw_average_value_size": 115, "num_data_blocks": 1, "num_entries": 405044, "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": 1724153684, "oldest_key_time": 0, "file_creation_time": 1724153684, "slow_compression_estimated_data_size": 0, "fast_compression_estimated_data_size": 0, "db_id": "a007a635-5c0a-4b4a-be96-b9c695cb016b", "db_session_id": "90ZT1ZM5QNL093I8HHQG", "orig_file_number": 14683039, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/08/20-19:34:45.971262 140466387236416 [compaction_job.cc:699] job-46690: subcompact[0], size: 0.164713 G, files: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-46690/att-00 [14683032,14683033,14683034,14683035,14683036,14683037,14683038,14683039] 2024/08/20-19:34:46.013375 140466387236416 (Original Log Time 2024/08/20-19:34:33.915419) EVENT_LOG_v1 {"time_micros": 1724153673915369, "job": 46690, "event": "compaction_started", "compaction_reason": "FilesMarkedForCompaction", "files_L1": [14683024], "files_L2": [14682987, 14682979, 14682980, 14682981, 14682982, 14682983, 14682948, 14682949], "score": 0.994621, "input_data_size": 182297473, "oldest_snapshot_seqno": 190964128743} 2024/08/20-19:34:46.013379 140466387236416 (Original Log Time 2024/08/20-19:34:46.012620) [compaction_job.cc:2018] [default] [JOB 46690] Compacted 1@1 + 8@2 files to L2 => 164713226 bytes 2024/08/20-19:34:46.013380 140466387236416 (Original Log Time 2024/08/20-19:34:46.013304) [compaction_job.cc:1220] [default] compacted to: files[0 0 8 0 0 0 0] max score 0.06, MB/sec: 15.1 rd, 13.7 wr, level 2, files in(1, 8) out(8 +0 blob) MB in(23.7, 150.2 +0.0 blob) out(157.1 +0.0 blob), read-write-amplify(14.0) write-amplify(6.6) OK, records in: 3669298, records dropped: 0 output_compression: Snappy 2024/08/20-19:34:46.013386 140466387236416 (Original Log Time 2024/08/20-19:34:46.013351) EVENT_LOG_v1 {"time_micros": 1724153686013329, "cf": "default", "job": 46690, "event": "compaction_finished", "compaction_time_micros": 12055854, "compaction_time_cpu_micros": 4922051, "output_level": 2, "num_output_files": 8, "total_output_size": 164713226, "num_input_records": 3669298, "num_output_records": 3669298, "num_subcompactions": 1, "output_compression": "Snappy", "num_single_delete_mismatches": 0, "num_single_delete_fallthrough": 0, "file_write_nanos": 110979965, "file_range_sync_nanos": 0, "file_fsync_nanos": 7428, "file_prepare_write_nanos": 21197, "lsm_state": [0, 0, 8, 0, 0, 0, 0]} 2024/08/20-19:34:46.157375 140466387236416 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":"a007a635-5c0a-4b4a-be96-b9c695cb016b","dbStarts":1724092920,"starts":1724153673,"executesMs":12263,"compactionJobId":46690,"attempt":0,"compactionInputRawBytes":528076700,"compactionInputZipBytes":182297473,"compactionOutputRawBytes":0,"compactionOutputZipBytes":164713226,"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-285c9643118802c5f2fe155004f4849a-de9b37dba20df2d6-00"}}, response = 2024/08/20-19:34:46.157478 140466387236416 INFO dcompact_worker.cpp:1456: finish /worker/dcompact-log/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/2024-08-20T02.42.00/.rocksdb/job-46690/att-00: olev 2, work 12.263 s, result 5.799 ms, install 0.794 ms, input{raw 503.613 MiB zip 173.852 MiB}