2024/11/23-14:13:25.354786 139957483730496 DEBG dcompact_worker.cpp:2214: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00: fork to child time = 0.021832 sec 2024/11/23-14:13:25.355764 139957483730496 DEBG dcompact_worker.cpp:1013: Beg SerDeRead: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00 2024/11/23-14:13:25.363194 139957483730496 DEBG dcompact_worker.cpp:1033: End SerDeRead: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00 2024/11/23-14:13:25.364531 139957483730496 TRAC dcompact_worker.cpp:1083: INFO_LOG_LEVEL: rpc = INFO_LEVEL, env_var = undefined 2024/11/23-14:13:25.364920 139957483730496 [WARN] [column_family.cc:386] multiple cf_paths/db_paths and level_compaction_dynamic_level_bytes can't be used together 2024/11/23-14:13:25.420380 139957483730496 [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-27417/att-00/MANIFEST-206347 2024/11/23-14:13:25.455311 139957483730496 [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-27417/att-00/MANIFEST-206347 succeeded,manifest_file_number is 206347, next_file_number is 262521, last_sequence is 4012453819, log_number is 0,prev_log_number is 0,max_column_family is 0,min_log_number_to_keep is 262359 2024/11/23-14:13:25.455328 139957483730496 [version_set.cc:6266] Column family [default] (ID 0), log number is 0 2024/11/23-14:13:25.455461 139957483730496 [version_set.cc:5721] Creating manifest 262521 2024/11/23-14:13:25.494569 139957483730496 DEBG dcompact_worker.cpp:1218: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00: bottommost_level: fake = 1, rpc = 0 2024/11/23-14:13:25.515776 139957483730496 [compaction_job.cc:2437] [default] [JOB 27417] Compacting 1@2 + 10@3 files to L3, score 0.99, subcompactions 1 : 1 2024/11/23-14:13:25.515799 139957483730496 [compaction_job.cc:2445] [default]: Compaction start summary: Base version 20536 Base level 2, inputs: [262517(27MB)], [262458(33MB) 262460(34MB) 262461(34MB) 262462(35MB) 262463(36MB) 262464(36MB) 262465(33MB) 262466(35MB) 262467(34MB) 262468(35MB)] 2024/11/23-14:13:25.524272 139957483730496 [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-14:13:25.524331 139957483730496 [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-14:13:25.524359 139957483730496 [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-14:13:25.524368 139957483730496 [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-14:13:25.524384 139957483730496 [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-14:13:26.087403 139957483730496 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262522.sst) /dev/shm/ToplingTemp/Topling-68989-I2HIjO 2024/11/23-14:13:27.307578 139957483730496 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262522.sst): first pass time = 1.22's, 110.004'MB/sec 2024/11/23-14:13:30.844803 139957483730496 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262522.sst): old prealloc_size = 147639500, real_size = 31181808 2024/11/23-14:13:30.845379 139957483730496 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262522.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 930747 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.0292 GB avg-val = 116.20 avg-zval = 31.35 2024/11/23-14:13:30.846163 139957483730496 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262522.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-14:13:31.896181 139957483730496 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262522.sst): second pass time = 3.53's, 30.646'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.05's, 33.456'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3163.726'MB/sec (index lex order gen) rebuild zvType time = 0.92's, 0.254'MB/sec write SST data time = 0.13's, 264.548'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 = 28285.887'MB/sec zip my value time = 3.53's, unzip length = 0.108'GB zip my value throughput = 30.646'MB/sec zip pipeline throughput = 114.953'MB/sec entries = 930747 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.20 avg-zval = 31.35 usrkeys = 930747 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.20 avg-zval = 31.35 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 930747 bytes = 3141280 } seq expand size = 6515229 multi value expand size = 0 cnt WriteAppend = 12 UnZipSize{ index = 0.0186 GB value = 0.1082 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0292 GB dict = 1.08 MB all = 0.0352 GB } UnZip/Zip{ index = 10.5117 value = 3.7068 dict = 1.00 all = 3.8157 } Zip/UnZip{ index = 0.0951 value = 0.2698 dict = 1.00 all = 0.2621 } ---------------------------- total value len = 8.963292 GB avg = 0.168 KB (by entry num) total key len = 1.466882 GB avg = 0.028 KB total ukey len = 1.016493 GB avg = 0.015 KB total ukey num = 0.066481182 Billion total entry num = 0.053288911 Billion write speed all = 0.546091510 MB/sec (with seq num) write speed all = 0.523771175 MB/sec (without seq num) 2024/11/23-14:13:31.945630 139957483730496 [compaction_job.cc:1948] [default] [JOB 27417] Generated table #262522: 930747 keys, 35174728 bytes, temperature: kWarm 2024/11/23-14:13:31.945723 139957483730496 EVENT_LOG_v1 {"time_micros": 1732342411945666, "cf_name": "default", "job": 27417, "event": "table_file_creation", "file_number": 262522, "file_size": 35174728, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3925603882, "largest_seqno": 4012411782, "table_properties": {"data_size": 29178080, "index_size": 1770880, "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": 26060916, "raw_average_key_size": 28, "raw_value_size": 108156910, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 930747, "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": 1732342406, "oldest_key_time": 0, "file_creation_time": 1732342406, "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": 262522, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-14:13:32.001425 139957483730496 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262523.sst) /dev/shm/ToplingTemp/Topling-68989-tUSopP 2024/11/23-14:13:33.267223 139957483730496 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262523.sst): first pass time = 1.27's, 106.037'MB/sec 2024/11/23-14:13:35.135273 139957483730496 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262523.sst): old prealloc_size = 147639500, real_size = 32064160 2024/11/23-14:13:35.135818 139957483730496 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262523.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 931337 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.0301 GB avg-val = 116.11 avg-zval = 32.27 2024/11/23-14:13:35.136689 139957483730496 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262523.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-14:13:35.996502 139957483730496 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262523.sst): second pass time = 1.87's, 57.910'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.86's, 42.005'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3452.875'MB/sec (index lex order gen) rebuild zvType time = 0.73's, 0.319'MB/sec write SST data time = 0.13's, 275.753'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 = 34622.532'MB/sec zip my value time = 1.87's, unzip length = 0.108'GB zip my value throughput = 57.910'MB/sec zip pipeline throughput = 59.946'MB/sec entries = 931337 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.11 avg-zval = 32.27 usrkeys = 931337 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.11 avg-zval = 32.27 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 931337 bytes = 3259696 } seq expand size = 6519359 multi value expand size = 0 cnt WriteAppend = 12 UnZipSize{ index = 0.0186 GB value = 0.1081 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0301 GB dict = 1.08 MB all = 0.0362 GB } UnZip/Zip{ index = 10.5100 value = 3.5976 dict = 1.00 all = 3.7102 } Zip/UnZip{ index = 0.0951 value = 0.2780 dict = 1.00 all = 0.2695 } ---------------------------- total value len = 9.077952 GB avg = 0.167 KB (by entry num) total key len = 1.492959 GB avg = 0.028 KB total ukey len = 1.035120 GB avg = 0.015 KB total ukey num = 0.067412519 Billion total entry num = 0.054220248 Billion write speed all = 0.553341278 MB/sec (with seq num) write speed all = 0.530635722 MB/sec (without seq num) 2024/11/23-14:13:36.043512 139957483730496 [compaction_job.cc:1948] [default] [JOB 27417] Generated table #262523: 931337 keys, 36175172 bytes, temperature: kWarm 2024/11/23-14:13:36.043604 139957483730496 EVENT_LOG_v1 {"time_micros": 1732342416043556, "cf_name": "default", "job": 27417, "event": "table_file_creation", "file_number": 262523, "file_size": 36175172, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3855348712, "largest_seqno": 4012411805, "table_properties": {"data_size": 30058832, "index_size": 1772288, "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": 26077436, "raw_average_key_size": 28, "raw_value_size": 108140346, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 931337, "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": 1732342411, "oldest_key_time": 0, "file_creation_time": 1732342411, "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": 262523, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-14:13:36.098365 139957483730496 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262524.sst) /dev/shm/ToplingTemp/Topling-68989-v0pY3P 2024/11/23-14:13:37.877649 139957483730496 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262524.sst): first pass time = 1.78's, 75.436'MB/sec 2024/11/23-14:13:39.688859 139957483730496 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262524.sst): old prealloc_size = 147639500, real_size = 31913296 2024/11/23-14:13:39.689575 139957483730496 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262524.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 927349 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.93 raw-val = 0.1083 GB zip-val = 0.0299 GB avg-val = 116.73 avg-zval = 32.24 2024/11/23-14:13:39.690429 139957483730496 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262524.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-14:13:40.860526 139957483730496 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262524.sst): second pass time = 1.81's, 59.826'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.17's, 30.638'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2568.290'MB/sec (index lex order gen) rebuild zvType time = 0.99's, 0.233'MB/sec write SST data time = 0.18's, 203.559'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 = 35433.360'MB/sec zip my value time = 1.81's, unzip length = 0.108'GB zip my value throughput = 59.826'MB/sec zip pipeline throughput = 102.950'MB/sec entries = 927349 avg-key = 28.00 avg-zkey = 1.93 avg-val = 116.73 avg-zval = 32.24 usrkeys = 927349 avg-key = 20.00 avg-zkey = 1.93 avg-val = 123.73 avg-zval = 32.24 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 927349 bytes = 3129824 } seq expand size = 6491443 multi value expand size = 0 cnt WriteAppend = 17 UnZipSize{ index = 0.0185 GB value = 0.1083 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0299 GB dict = 1.08 MB all = 0.0359 GB } UnZip/Zip{ index = 10.3754 value = 3.6212 dict = 1.00 all = 3.7389 } Zip/UnZip{ index = 0.0964 value = 0.2761 dict = 1.00 all = 0.2675 } ---------------------------- total value len = 9.192695 GB avg = 0.167 KB (by entry num) total key len = 1.518925 GB avg = 0.028 KB total ukey len = 1.053667 GB avg = 0.015 KB total ukey num = 0.068339868 Billion total entry num = 0.055147597 Billion write speed all = 0.560564073 MB/sec (with seq num) write speed all = 0.537476055 MB/sec (without seq num) 2024/11/23-14:13:40.908617 139957483730496 [compaction_job.cc:1948] [default] [JOB 27417] Generated table #262524: 927349 keys, 35897538 bytes, temperature: kWarm 2024/11/23-14:13:40.908682 139957483730496 EVENT_LOG_v1 {"time_micros": 1732342420908645, "cf_name": "default", "job": 27417, "event": "table_file_creation", "file_number": 262524, "file_size": 35897538, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3894391720, "largest_seqno": 4012412348, "table_properties": {"data_size": 29893696, "index_size": 1787584, "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": 25965772, "raw_average_key_size": 28, "raw_value_size": 108252094, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 927349, "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": 1732342416, "oldest_key_time": 0, "file_creation_time": 1732342416, "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": 262524, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-14:13:40.947502 139957483730496 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262525.sst) /dev/shm/ToplingTemp/Topling-68989-dawYfP 2024/11/23-14:13:41.943380 139957483730496 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262525.sst): first pass time = 1.00's, 134.782'MB/sec 2024/11/23-14:13:43.766594 139957483730496 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262525.sst): old prealloc_size = 147639500, real_size = 33101312 2024/11/23-14:13:43.767148 139957483730496 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262525.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 934068 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.0311 GB avg-val = 115.69 avg-zval = 33.29 2024/11/23-14:13:43.767908 139957483730496 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262525.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-14:13:44.825993 139957483730496 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262525.sst): second pass time = 1.82's, 59.310'MB/sec, value only(80.5% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.06's, 35.025'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3304.698'MB/sec (index lex order gen) rebuild zvType time = 0.93's, 0.250'MB/sec write SST data time = 0.13's, 295.372'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 = 36220.318'MB/sec zip my value time = 1.82's, unzip length = 0.108'GB zip my value throughput = 59.310'MB/sec zip pipeline throughput = 59.310'MB/sec entries = 934068 avg-key = 28.00 avg-zkey = 1.90 avg-val = 115.69 avg-zval = 33.29 usrkeys = 934068 avg-key = 20.00 avg-zkey = 1.90 avg-val = 122.69 avg-zval = 33.29 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 934068 bytes = 3152496 } seq expand size = 6538476 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.0311 GB dict = 1.08 MB all = 0.0371 GB } UnZip/Zip{ index = 10.5154 value = 3.4757 dict = 1.00 all = 3.6173 } Zip/UnZip{ index = 0.0951 value = 0.2877 dict = 1.00 all = 0.2764 } ---------------------------- total value len = 9.307298 GB avg = 0.166 KB (by entry num) total key len = 1.545079 GB avg = 0.028 KB total ukey len = 1.072348 GB avg = 0.015 KB total ukey num = 0.069273936 Billion total entry num = 0.056081665 Billion write speed all = 0.567812347 MB/sec (with seq num) write speed all = 0.544338144 MB/sec (without seq num) 2024/11/23-14:13:44.871628 139957483730496 [compaction_job.cc:1948] [default] [JOB 27417] Generated table #262525: 934068 keys, 37104326 bytes, temperature: kWarm 2024/11/23-14:13:44.871697 139957483730496 EVENT_LOG_v1 {"time_micros": 1732342424871662, "cf_name": "default", "job": 27417, "event": "table_file_creation", "file_number": 262525, "file_size": 37104326, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3898575090, "largest_seqno": 4012411845, "table_properties": {"data_size": 31091056, "index_size": 1776576, "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": 26153904, "raw_average_key_size": 28, "raw_value_size": 108063948, "raw_average_value_size": 115, "num_data_blocks": 1, "num_entries": 934068, "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": 1732342420, "oldest_key_time": 0, "file_creation_time": 1732342420, "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": 262525, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-14:13:44.909056 139957483730496 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262526.sst) /dev/shm/ToplingTemp/Topling-68989-2MhyAP 2024/11/23-14:13:45.860391 139957483730496 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262526.sst): first pass time = 0.95's, 141.089'MB/sec 2024/11/23-14:13:47.600843 139957483730496 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262526.sst): old prealloc_size = 147639500, real_size = 33117696 2024/11/23-14:13:47.601400 139957483730496 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262526.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 928757 prefix = 4 raw-key = 0.0149 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.1082 GB zip-val = 0.0311 GB avg-val = 116.51 avg-zval = 33.51 2024/11/23-14:13:47.602177 139957483730496 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262526.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-14:13:48.629742 139957483730496 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262526.sst): second pass time = 1.74's, 62.210'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.03's, 36.064'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3289.579'MB/sec (index lex order gen) rebuild zvType time = 0.90's, 0.257'MB/sec write SST data time = 0.13's, 296.093'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 = 43696.953'MB/sec zip my value time = 1.74's, unzip length = 0.108'GB zip my value throughput = 62.210'MB/sec zip pipeline throughput = 62.210'MB/sec entries = 928757 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.51 avg-zval = 33.51 usrkeys = 928757 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.51 avg-zval = 33.51 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 928757 bytes = 3134576 } seq expand size = 6501299 multi value expand size = 0 cnt WriteAppend = 12 UnZipSize{ index = 0.0186 GB value = 0.1082 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0311 GB dict = 1.08 MB all = 0.0371 GB } UnZip/Zip{ index = 10.5128 value = 3.4774 dict = 1.00 all = 3.6172 } Zip/UnZip{ index = 0.0951 value = 0.2876 dict = 1.00 all = 0.2765 } ---------------------------- total value len = 9.422011 GB avg = 0.165 KB (by entry num) total key len = 1.571084 GB avg = 0.028 KB total ukey len = 1.090923 GB avg = 0.016 KB total ukey num = 0.070202693 Billion total entry num = 0.057010422 Billion write speed all = 0.575060529 MB/sec (with seq num) write speed all = 0.551202322 MB/sec (without seq num) 2024/11/23-14:13:48.675927 139957483730496 [compaction_job.cc:1948] [default] [JOB 27417] Generated table #262526: 928757 keys, 37105580 bytes, temperature: kWarm 2024/11/23-14:13:48.676009 139957483730496 EVENT_LOG_v1 {"time_micros": 1732342428675961, "cf_name": "default", "job": 27417, "event": "table_file_creation", "file_number": 262526, "file_size": 37105580, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3913855938, "largest_seqno": 4012411869, "table_properties": {"data_size": 31118384, "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": 26005196, "raw_average_key_size": 28, "raw_value_size": 108212570, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 928757, "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": 1732342424, "oldest_key_time": 0, "file_creation_time": 1732342424, "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": 262526, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-14:13:48.718105 139957483730496 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262527.sst) /dev/shm/ToplingTemp/Topling-68989-3vhoZO 2024/11/23-14:13:49.742014 139957483730496 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262527.sst): first pass time = 1.02's, 131.089'MB/sec 2024/11/23-14:13:51.520206 139957483730496 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262527.sst): old prealloc_size = 147639500, real_size = 34223632 2024/11/23-14:13:51.520904 139957483730496 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262527.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 932330 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.0322 GB avg-val = 115.96 avg-zval = 34.56 2024/11/23-14:13:51.521754 139957483730496 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262527.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-14:13:52.534559 139957483730496 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262527.sst): second pass time = 1.78's, 60.852'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.01's, 37.685'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2617.710'MB/sec (index lex order gen) rebuild zvType time = 0.86's, 0.271'MB/sec write SST data time = 0.15's, 249.785'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 = 33907.739'MB/sec zip my value time = 1.78's, unzip length = 0.108'GB zip my value throughput = 60.852'MB/sec zip pipeline throughput = 72.863'MB/sec entries = 932330 avg-key = 28.00 avg-zkey = 1.90 avg-val = 115.96 avg-zval = 34.56 usrkeys = 932330 avg-key = 20.00 avg-zkey = 1.90 avg-val = 122.96 avg-zval = 34.56 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 932330 bytes = 3146624 } seq expand size = 6526310 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.0322 GB dict = 1.08 MB all = 0.0382 GB } UnZip/Zip{ index = 10.5132 value = 3.3558 dict = 1.00 all = 3.5113 } Zip/UnZip{ index = 0.0951 value = 0.2980 dict = 1.00 all = 0.2848 } ---------------------------- total value len = 9.536650 GB avg = 0.165 KB (by entry num) total key len = 1.597190 GB avg = 0.028 KB total ukey len = 1.109570 GB avg = 0.016 KB total ukey num = 0.071135023 Billion total entry num = 0.057942752 Billion write speed all = 0.582304056 MB/sec (with seq num) write speed all = 0.558060633 MB/sec (without seq num) 2024/11/23-14:13:52.582859 139957483730496 [compaction_job.cc:1948] [default] [JOB 27417] Generated table #262527: 932330 keys, 38225004 bytes, temperature: kWarm 2024/11/23-14:13:52.582930 139957483730496 EVENT_LOG_v1 {"time_micros": 1732342432582892, "cf_name": "default", "job": 27417, "event": "table_file_creation", "file_number": 262527, "file_size": 38225004, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3934475102, "largest_seqno": 4012412047, "table_properties": {"data_size": 32216704, "index_size": 1773632, "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": 26105240, "raw_average_key_size": 28, "raw_value_size": 108112516, "raw_average_value_size": 115, "num_data_blocks": 1, "num_entries": 932330, "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": 1732342428, "oldest_key_time": 0, "file_creation_time": 1732342428, "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": 262527, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-14:13:52.621725 139957483730496 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262528.sst) /dev/shm/ToplingTemp/Topling-68989-tYCatR 2024/11/23-14:13:53.731961 139957483730496 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262528.sst): first pass time = 1.11's, 120.895'MB/sec 2024/11/23-14:13:55.196741 139957483730496 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262528.sst): old prealloc_size = 147639500, real_size = 31279584 2024/11/23-14:13:55.197432 139957483730496 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262528.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 930850 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.0293 GB avg-val = 116.19 avg-zval = 31.45 2024/11/23-14:13:55.198296 139957483730496 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262528.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-14:13:56.204468 139957483730496 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262528.sst): second pass time = 1.46's, 73.877'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.01's, 35.234'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 2639.935'MB/sec (index lex order gen) rebuild zvType time = 0.85's, 0.273'MB/sec write SST data time = 0.15's, 229.168'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 = 37085.913'MB/sec zip my value time = 1.46's, unzip length = 0.108'GB zip my value throughput = 73.877'MB/sec zip pipeline throughput = 73.877'MB/sec entries = 930850 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.19 avg-zval = 31.45 usrkeys = 930850 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.19 avg-zval = 31.45 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 930850 bytes = 3374352 } seq expand size = 6515950 multi value expand size = 0 cnt WriteAppend = 12 UnZipSize{ index = 0.0186 GB value = 0.1082 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0293 GB dict = 1.08 MB all = 0.0355 GB } UnZip/Zip{ index = 10.5136 value = 3.6943 dict = 1.00 all = 3.7802 } Zip/UnZip{ index = 0.0951 value = 0.2707 dict = 1.00 all = 0.2645 } ---------------------------- total value len = 9.651320 GB avg = 0.164 KB (by entry num) total key len = 1.623253 GB avg = 0.028 KB total ukey len = 1.128187 GB avg = 0.016 KB total ukey num = 0.072065873 Billion total entry num = 0.058873602 Billion write speed all = 0.589551325 MB/sec (with seq num) write speed all = 0.564923158 MB/sec (without seq num) 2024/11/23-14:13:56.252413 139957483730496 [compaction_job.cc:1948] [default] [JOB 27417] Generated table #262528: 930850 keys, 35505334 bytes, temperature: kWarm 2024/11/23-14:13:56.252482 139957483730496 EVENT_LOG_v1 {"time_micros": 1732342436252446, "cf_name": "default", "job": 27417, "event": "table_file_creation", "file_number": 262528, "file_size": 35505334, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3509327862, "largest_seqno": 4012409787, "table_properties": {"data_size": 29275920, "index_size": 1770752, "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": 26063800, "raw_average_key_size": 28, "raw_value_size": 108153948, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 930850, "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": 1732342432, "oldest_key_time": 0, "file_creation_time": 1732342432, "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": 262528, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-14:13:56.291760 139957483730496 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262529.sst) /dev/shm/ToplingTemp/Topling-68989-JHlH2M 2024/11/23-14:13:57.204576 139957483730496 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262529.sst): first pass time = 0.91's, 147.043'MB/sec 2024/11/23-14:13:58.704603 139957483730496 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262529.sst): old prealloc_size = 147639500, real_size = 32357408 2024/11/23-14:13:58.705127 139957483730496 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262529.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 932468 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.0304 GB avg-val = 115.94 avg-zval = 32.55 2024/11/23-14:13:58.706012 139957483730496 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262529.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-14:13:59.556749 139957483730496 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262529.sst): second pass time = 1.50's, 72.107'MB/sec, value only(80.5% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.85's, 42.937'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3517.728'MB/sec (index lex order gen) rebuild zvType time = 0.72's, 0.323'MB/sec write SST data time = 0.13's, 283.204'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 = 32269.904'MB/sec zip my value time = 1.50's, unzip length = 0.108'GB zip my value throughput = 72.107'MB/sec zip pipeline throughput = 97.289'MB/sec entries = 932468 avg-key = 28.00 avg-zkey = 1.90 avg-val = 115.94 avg-zval = 32.55 usrkeys = 932468 avg-key = 20.00 avg-zkey = 1.90 avg-val = 122.94 avg-zval = 32.55 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 932468 bytes = 3380208 } seq expand size = 6527276 multi value expand size = 0 cnt WriteAppend = 12 UnZipSize{ index = 0.0186 GB value = 0.1081 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0304 GB dict = 1.08 MB all = 0.0366 GB } UnZip/Zip{ index = 10.5133 value = 3.5620 dict = 1.00 all = 3.6684 } Zip/UnZip{ index = 0.0951 value = 0.2807 dict = 1.00 all = 0.2726 } ---------------------------- total value len = 9.765956 GB avg = 0.163 KB (by entry num) total key len = 1.649362 GB avg = 0.028 KB total ukey len = 1.146836 GB avg = 0.016 KB total ukey num = 0.072998341 Billion total entry num = 0.059806070 Billion write speed all = 0.596806320 MB/sec (with seq num) write speed all = 0.571792465 MB/sec (without seq num) 2024/11/23-14:13:59.603066 139957483730496 [compaction_job.cc:1948] [default] [JOB 27417] Generated table #262529: 932468 keys, 36588006 bytes, temperature: kWarm 2024/11/23-14:13:59.603135 139957483730496 EVENT_LOG_v1 {"time_micros": 1732342439603099, "cf_name": "default", "job": 27417, "event": "table_file_creation", "file_number": 262529, "file_size": 36588006, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3631595348, "largest_seqno": 4012411738, "table_properties": {"data_size": 30350224, "index_size": 1773888, "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": 26109104, "raw_average_key_size": 28, "raw_value_size": 108108740, "raw_average_value_size": 115, "num_data_blocks": 1, "num_entries": 932468, "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": 1732342436, "oldest_key_time": 0, "file_creation_time": 1732342436, "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": 262529, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-14:13:59.652154 139957483730496 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262530.sst) /dev/shm/ToplingTemp/Topling-68989-vSgS0Q 2024/11/23-14:14:00.564254 139957483730496 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262530.sst): first pass time = 0.91's, 147.160'MB/sec 2024/11/23-14:14:02.126889 139957483730496 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262530.sst): old prealloc_size = 147639500, real_size = 33527744 2024/11/23-14:14:02.127491 139957483730496 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262530.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 922617 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.92 raw-val = 0.1084 GB zip-val = 0.0315 GB avg-val = 117.48 avg-zval = 34.17 2024/11/23-14:14:02.128358 139957483730496 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262530.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-14:14:02.990658 139957483730496 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262530.sst): second pass time = 1.56's, 69.398'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.86's, 43.682'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3060.722'MB/sec (index lex order gen) rebuild zvType time = 0.73's, 0.314'MB/sec write SST data time = 0.13's, 291.205'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.083'MB, throughput = 31541.709'MB/sec zip my value time = 1.56's, unzip length = 0.108'GB zip my value throughput = 69.398'MB/sec zip pipeline throughput = 103.872'MB/sec entries = 922617 avg-key = 28.00 avg-zkey = 1.92 avg-val = 117.48 avg-zval = 34.17 usrkeys = 922617 avg-key = 20.00 avg-zkey = 1.92 avg-val = 124.48 avg-zval = 34.17 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 922617 bytes = 3344496 } seq expand size = 6458319 multi value expand size = 0 cnt WriteAppend = 15 UnZipSize{ index = 0.0185 GB value = 0.1084 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0315 GB dict = 1.08 MB all = 0.0377 GB } UnZip/Zip{ index = 10.4429 value = 3.4375 dict = 1.00 all = 3.5573 } Zip/UnZip{ index = 0.0958 value = 0.2909 dict = 1.00 all = 0.2811 } ---------------------------- total value len = 9.880799 GB avg = 0.163 KB (by entry num) total key len = 1.675196 GB avg = 0.028 KB total ukey len = 1.165288 GB avg = 0.016 KB total ukey num = 0.073920958 Billion total entry num = 0.060728687 Billion write speed all = 0.604052590 MB/sec (with seq num) write speed all = 0.578657411 MB/sec (without seq num) 2024/11/23-14:14:03.037798 139957483730496 [compaction_job.cc:1948] [default] [JOB 27417] Generated table #262530: 922617 keys, 37730676 bytes, temperature: kWarm 2024/11/23-14:14:03.037867 139957483730496 EVENT_LOG_v1 {"time_micros": 1732342443037831, "cf_name": "default", "job": 27417, "event": "table_file_creation", "file_number": 262530, "file_size": 37730676, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3583362754, "largest_seqno": 4012411355, "table_properties": {"data_size": 31529904, "index_size": 1766976, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 25833276, "raw_average_key_size": 28, "raw_value_size": 108384554, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 922617, "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": 1732342439, "oldest_key_time": 0, "file_creation_time": 1732342439, "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": 262530, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-14:14:03.083734 139957483730496 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262531.sst) /dev/shm/ToplingTemp/Topling-68989-yD0yXP 2024/11/23-14:14:04.000899 139957483730496 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262531.sst): first pass time = 0.92's, 146.346'MB/sec 2024/11/23-14:14:05.482572 139957483730496 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262531.sst): old prealloc_size = 147639500, real_size = 32862624 2024/11/23-14:14:05.483100 139957483730496 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262531.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 931553 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.08 avg-zval = 33.11 2024/11/23-14:14:05.484960 139957483730496 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262531.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-14:14:06.354397 139957483730496 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262531.sst): second pass time = 1.48's, 73.068'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.87's, 42.545'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3532.009'MB/sec (index lex order gen) rebuild zvType time = 0.74's, 0.314'MB/sec write SST data time = 0.13's, 285.002'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 = 32450.619'MB/sec zip my value time = 1.48's, unzip length = 0.108'GB zip my value throughput = 73.068'MB/sec zip pipeline throughput = 105.867'MB/sec entries = 931553 avg-key = 28.00 avg-zkey = 1.91 avg-val = 116.08 avg-zval = 33.11 usrkeys = 931553 avg-key = 20.00 avg-zkey = 1.91 avg-val = 123.08 avg-zval = 33.11 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 931553 bytes = 3376896 } seq expand size = 6520871 multi value expand size = 0 cnt WriteAppend = 15 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.0371 GB } UnZip/Zip{ index = 10.4464 value = 3.5056 dict = 1.00 all = 3.6187 } Zip/UnZip{ index = 0.0957 value = 0.2853 dict = 1.00 all = 0.2763 } ---------------------------- total value len = 9.995454 GB avg = 0.162 KB (by entry num) total key len = 1.701279 GB avg = 0.028 KB total ukey len = 1.183920 GB avg = 0.016 KB total ukey num = 0.074852511 Billion total entry num = 0.061660240 Billion write speed all = 0.611301771 MB/sec (with seq num) write speed all = 0.585521573 MB/sec (without seq num) 2024/11/23-14:14:06.403401 139957483730496 [compaction_job.cc:1948] [default] [JOB 27417] Generated table #262531: 931553 keys, 37090538 bytes, temperature: kWarm 2024/11/23-14:14:06.403467 139957483730496 EVENT_LOG_v1 {"time_micros": 1732342446403433, "cf_name": "default", "job": 27417, "event": "table_file_creation", "file_number": 262531, "file_size": 37090538, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3621075956, "largest_seqno": 4012409825, "table_properties": {"data_size": 30846032, "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": 26083484, "raw_average_key_size": 28, "raw_value_size": 108134358, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 931553, "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": 1732342443, "oldest_key_time": 0, "file_creation_time": 1732342443, "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": 262531, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-14:14:06.447065 139957483730496 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262532.sst) /dev/shm/ToplingTemp/Topling-68989-1snnFN 2024/11/23-14:14:06.563396 139957483730496 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262532.sst): first pass time = 0.12's, 234.373'MB/sec 2024/11/23-14:14:06.812558 139957483730496 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262532.sst): old prealloc_size = 147639500, real_size = 7401488 2024/11/23-14:14:06.812857 139957483730496 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262532.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 190319 prefix = 4 raw-key = 0.0030 GB zip-key = 0.0004 GB avg-key = 16.00 avg-zkey = 1.92 raw-val = 0.0219 GB zip-val = 0.0070 GB avg-val = 115.22 avg-zval = 36.72 2024/11/23-14:14:06.813086 139957483730496 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262532.sst: sumWaitingMem = 0.000 GB, sumWorkingMem = 0.000 GB, reorder workingMem = 0.0004 GB, waited 0.000 sec, Key+Value = 0.027 GB 2024/11/23-14:14:06.999403 139957483730496 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00/262532.sst): second pass time = 0.25's, 88.250'MB/sec, value only(80.4% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.19's, 44.039'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 1327.922'MB/sec (index lex order gen) rebuild zvType time = 0.16's, 0.304'MB/sec write SST data time = 0.03's, 273.361'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.230'MB, throughput = 5938.057'MB/sec zip my value time = 0.25's, unzip length = 0.022'GB zip my value throughput = 88.250'MB/sec zip pipeline throughput = 88.250'MB/sec entries = 190319 avg-key = 28.00 avg-zkey = 1.92 avg-val = 115.22 avg-zval = 36.72 usrkeys = 190319 avg-key = 20.00 avg-zkey = 1.92 avg-val = 122.22 avg-zval = 36.72 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 190319 bytes = 642336 } seq expand size = 1332233 multi value expand size = 0 cnt WriteAppend = 12 UnZipSize{ index = 0.0038 GB value = 0.0219 GB dict = 0.23 MB all = 0.0273 GB } __ZipSize{ index = 0.0004 GB value = 0.0070 GB dict = 0.23 MB all = 0.0082 GB } UnZip/Zip{ index = 10.4141 value = 3.1378 dict = 1.00 all = 3.3128 } Zip/UnZip{ index = 0.0960 value = 0.3187 dict = 1.00 all = 0.3019 } ---------------------------- total value len = 10.018714 GB avg = 0.162 KB (by entry num) total key len = 1.706608 GB avg = 0.028 KB total ukey len = 1.187726 GB avg = 0.016 KB total ukey num = 0.075042830 Billion total entry num = 0.061850559 Billion write speed all = 0.612775248 MB/sec (with seq num) write speed all = 0.586916348 MB/sec (without seq num) 2024/11/23-14:14:07.018563 139957483730496 [compaction_job.cc:1948] [default] [JOB 27417] Generated table #262532: 190319 keys, 8227655 bytes, temperature: kWarm 2024/11/23-14:14:07.018628 139957483730496 EVENT_LOG_v1 {"time_micros": 1732342447018597, "cf_name": "default", "job": 27417, "event": "table_file_creation", "file_number": 262532, "file_size": 8227655, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 3931862908, "largest_seqno": 4010912621, "table_properties": {"data_size": 6988224, "index_size": 365504, "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": 5328932, "raw_average_key_size": 28, "raw_value_size": 21927782, "raw_average_value_size": 115, "num_data_blocks": 1, "num_entries": 190319, "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": 1732342446, "oldest_key_time": 0, "file_creation_time": 1732342446, "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": 262532, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/23-14:14:07.030321 139957483730496 [compaction_job.cc:703] job-27417: subcompact[0], size: 0.374825 G, files: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-27417/att-00 [262522,262523,262524,262525,262526,262527,262528,262529,262530,262531,262532] 2024/11/23-14:14:07.099144 139957483730496 (Original Log Time 2024/11/23-14:13:25.515870) EVENT_LOG_v1 {"time_micros": 1732342405515817, "job": 27417, "event": "compaction_started", "compaction_reason": "FilesMarkedForCompaction", "files_L2": [262517], "files_L3": [262458, 262460, 262461, 262462, 262463, 262464, 262465, 262466, 262467, 262468], "score": 0.992171, "input_data_size": 395279038, "oldest_snapshot_seqno": 4012453814} 2024/11/23-14:14:07.099147 139957483730496 (Original Log Time 2024/11/23-14:14:07.098119) [compaction_job.cc:2022] [default] [JOB 27417] Compacted 1@2 + 10@3 files to L3 => 374824557 bytes 2024/11/23-14:14:07.099149 139957483730496 (Original Log Time 2024/11/23-14:14:07.099076) [compaction_job.cc:1224] [default] compacted to: files[0 0 0 11 0 0 0] max score 0.01, MB/sec: 9.5 rd, 9.0 wr, level 3, files in(1, 10) out(11 +0 blob) MB in(27.1, 349.9 +0.0 blob) out(357.5 +0.0 blob), read-write-amplify(27.1) write-amplify(13.2) OK, records in: 9536552, records dropped: 44157 output_compression: Snappy 2024/11/23-14:14:07.099154 139957483730496 (Original Log Time 2024/11/23-14:14:07.099121) EVENT_LOG_v1 {"time_micros": 1732342447099101, "cf": "default", "job": 27417, "event": "compaction_finished", "compaction_time_micros": 41514461, "compaction_time_cpu_micros": 17237116, "output_level": 3, "num_output_files": 11, "total_output_size": 374824557, "num_input_records": 9536552, "num_output_records": 9492395, "num_subcompactions": 1, "output_compression": "Snappy", "num_single_delete_mismatches": 0, "num_single_delete_fallthrough": 0, "file_write_nanos": 260573836, "file_range_sync_nanos": 0, "file_fsync_nanos": 7508, "file_prepare_write_nanos": 26323, "lsm_state": [0, 0, 0, 11, 0, 0, 0]} 2024/11/23-14:14:07.243724 139957483730496 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":1732342405,"executesMs":41735,"compactionJobId":27417,"attempt":0,"compactionInputRawBytes":1375705120,"compactionInputZipBytes":395279038,"compactionOutputRawBytes":0,"compactionOutputZipBytes":374824557,"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-90813d4147985a0e21df07d420686148-fb4790eb596275c6-00"}}, response = 2024/11/23-14:14:07.243816 139957483730496 INFO dcompact_worker.cpp:1459: finish /worker/dcompact-log/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/2024-11-22T14.14.14/.rocksdb/job-27417/att-00: olev 3, work 41.735 s, result 7.983 ms, install 1.050 ms, input{raw 1.281 GiB zip 376.967 MiB}