2024/11/24-06:47:20.118145 139957290698304 DEBG dcompact_worker.cpp:2214: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00: fork to child time = 0.007548 sec 2024/11/24-06:47:20.119004 139957290698304 DEBG dcompact_worker.cpp:1013: Beg SerDeRead: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00 2024/11/24-06:47:20.125108 139957290698304 DEBG dcompact_worker.cpp:1033: End SerDeRead: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00 2024/11/24-06:47:20.125998 139957290698304 TRAC dcompact_worker.cpp:1083: INFO_LOG_LEVEL: rpc = INFO_LEVEL, env_var = undefined 2024/11/24-06:47:20.126259 139957290698304 [WARN] [column_family.cc:386] multiple cf_paths/db_paths and level_compaction_dynamic_level_bytes can't be used together 2024/11/24-06:47:20.182712 139957290698304 [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-43019/att-00/MANIFEST-206347 2024/11/24-06:47:20.208195 139957290698304 [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-43019/att-00/MANIFEST-206347 succeeded,manifest_file_number is 206347, next_file_number is 295409, last_sequence is 4484766817, log_number is 0,prev_log_number is 0,max_column_family is 0,min_log_number_to_keep is 295216 2024/11/24-06:47:20.208201 139957290698304 [version_set.cc:6266] Column family [default] (ID 0), log number is 0 2024/11/24-06:47:20.208338 139957290698304 [version_set.cc:5721] Creating manifest 295409 2024/11/24-06:47:20.244565 139957290698304 DEBG dcompact_worker.cpp:1218: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00: bottommost_level: fake = 1, rpc = 0 2024/11/24-06:47:20.278890 139957290698304 [compaction_job.cc:2437] [default] [JOB 43019] Compacting 1@2 + 27@3 files to L3, score 0.99, subcompactions 1 : 1 2024/11/24-06:47:20.278910 139957290698304 [compaction_job.cc:2445] [default]: Compaction start summary: Base version 32248 Base level 2, inputs: [295349(27MB)], [295390(35MB) 295391(8811KB) 295306(34MB) 295307(33MB) 295308(35MB) 295309(33MB) 295310(35MB) 295311(33MB) 295312(35MB) 295313(33MB) 295314(33MB) 295315(35MB) 295316(33MB) 295317(35MB) 295318(33MB) 295319(35MB) 295320(31MB) 295321(30MB) 295322(12MB) 295278(33MB) 295279(32MB) 295280(34MB) 295281(33MB) 295282(32MB) 295283(35MB) 295284(33MB) 295392(34MB)] 2024/11/24-06:47:20.285678 139957290698304 [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/24-06:47:20.285708 139957290698304 [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/24-06:47:20.285727 139957290698304 [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/24-06:47:20.285733 139957290698304 [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/24-06:47:20.285744 139957290698304 [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/24-06:47:21.140097 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295410.sst) /dev/shm/ToplingTemp/Topling-291905-j0mr2F 2024/11/24-06:47:21.684588 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295410.sst): first pass time = 0.54's, 246.520'MB/sec 2024/11/24-06:47:23.034793 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295410.sst): old prealloc_size = 147639500, real_size = 33093584 2024/11/24-06:47:23.035360 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295410.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 925515 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.92 raw-val = 0.1083 GB zip-val = 0.0311 GB avg-val = 117.02 avg-zval = 33.59 2024/11/24-06:47:23.036163 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295410.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:47:23.878645 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295410.sst): second pass time = 1.35's, 80.298'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.84's, 44.070'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3246.531'MB/sec (index lex order gen) rebuild zvType time = 0.72's, 0.322'MB/sec write SST data time = 0.12's, 299.526'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 = 34126.161'MB/sec zip my value time = 1.35's, unzip length = 0.108'GB zip my value throughput = 80.298'MB/sec zip pipeline throughput = 80.298'MB/sec entries = 925515 avg-key = 28.00 avg-zkey = 1.92 avg-val = 117.02 avg-zval = 33.59 usrkeys = 925515 avg-key = 20.00 avg-zkey = 1.92 avg-val = 124.02 avg-zval = 33.59 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 925515 bytes = 3239312 } seq expand size = 6478605 multi value expand size = 0 cnt WriteAppend = 14 UnZipSize{ index = 0.0185 GB value = 0.1083 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0311 GB dict = 1.08 MB all = 0.0372 GB } UnZip/Zip{ index = 10.4428 value = 3.4836 dict = 1.00 all = 3.6092 } Zip/UnZip{ index = 0.0958 value = 0.2871 dict = 1.00 all = 0.2771 } ---------------------------- total value len = 2251.440355 GB avg = 0.200 KB (by entry num) total key len = 306.908877 GB avg = 0.027 KB total ukey len = 237.373238 GB avg = 0.015 KB total ukey num = 15.739586678 Billion total entry num = 11.280900626 Billion write speed all = 32.494540345 MB/sec (with seq num) write speed all = 31.348277197 MB/sec (without seq num) 2024/11/24-06:47:23.925506 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295410: 925515 keys, 37187646 bytes, temperature: kWarm 2024/11/24-06:47:23.925612 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402043925546, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295410, "file_size": 37187646, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4261178675, "largest_seqno": 4484448540, "table_properties": {"data_size": 31089472, "index_size": 1772544, "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": 25914420, "raw_average_key_size": 28, "raw_value_size": 108303318, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 925515, "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": 1732402041, "oldest_key_time": 0, "file_creation_time": 1732402041, "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": 295410, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:47:23.963912 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295411.sst) /dev/shm/ToplingTemp/Topling-291905-bVlUtE 2024/11/24-06:47:25.095769 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295411.sst): first pass time = 1.13's, 118.586'MB/sec 2024/11/24-06:47:26.392140 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295411.sst): old prealloc_size = 147639500, real_size = 30707856 2024/11/24-06:47:26.392675 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295411.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 926869 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1083 GB zip-val = 0.0287 GB avg-val = 116.81 avg-zval = 30.97 2024/11/24-06:47:26.393407 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295411.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:47:27.206363 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295411.sst): second pass time = 1.30's, 83.569'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.81's, 42.605'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3464.034'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.337'MB/sec write SST data time = 0.13's, 274.119'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 = 26121.606'MB/sec zip my value time = 1.30's, unzip length = 0.108'GB zip my value throughput = 83.569'MB/sec zip pipeline throughput = 83.569'MB/sec entries = 926869 avg-key = 28.00 avg-zkey = 1.91 avg-val = 116.81 avg-zval = 30.97 usrkeys = 926869 avg-key = 20.00 avg-zkey = 1.91 avg-val = 123.81 avg-zval = 30.97 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 926869 bytes = 3128192 } seq expand size = 6488083 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0185 GB value = 0.1083 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0287 GB dict = 1.08 MB all = 0.0347 GB } UnZip/Zip{ index = 10.4441 value = 3.7722 dict = 1.00 all = 3.8692 } Zip/UnZip{ index = 0.0957 value = 0.2651 dict = 1.00 all = 0.2585 } ---------------------------- total value len = 2251.555109 GB avg = 0.200 KB (by entry num) total key len = 306.934829 GB avg = 0.027 KB total ukey len = 237.391775 GB avg = 0.015 KB total ukey num = 15.740513547 Billion total entry num = 11.281827495 Billion write speed all = 32.494954053 MB/sec (with seq num) write speed all = 31.348645176 MB/sec (without seq num) 2024/11/24-06:47:27.249679 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295411: 926869 keys, 34688804 bytes, temperature: kWarm 2024/11/24-06:47:27.249752 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402047249715, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295411, "file_size": 34688804, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4378474055, "largest_seqno": 4484447099, "table_properties": {"data_size": 28701056, "index_size": 1774912, "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": 25952332, "raw_average_key_size": 28, "raw_value_size": 108265454, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 926869, "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": 1732402043, "oldest_key_time": 0, "file_creation_time": 1732402043, "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": 295411, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:47:27.288165 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295412.sst) /dev/shm/ToplingTemp/Topling-291905-vT6o5H 2024/11/24-06:47:28.287864 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295412.sst): first pass time = 1.00's, 134.264'MB/sec 2024/11/24-06:47:29.620873 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295412.sst): old prealloc_size = 147639500, real_size = 31914224 2024/11/24-06:47:29.621477 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295412.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 920293 prefix = 4 raw-key = 0.0147 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.1084 GB zip-val = 0.0299 GB avg-val = 117.84 avg-zval = 32.53 2024/11/24-06:47:29.622226 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295412.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:47:30.437243 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295412.sst): second pass time = 1.33's, 81.408'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 44.093'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3026.961'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.333'MB/sec write SST data time = 0.13's, 287.000'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.084'MB, throughput = 34331.856'MB/sec zip my value time = 1.33's, unzip length = 0.108'GB zip my value throughput = 81.408'MB/sec zip pipeline throughput = 81.408'MB/sec entries = 920293 avg-key = 28.00 avg-zkey = 1.90 avg-val = 117.84 avg-zval = 32.53 usrkeys = 920293 avg-key = 20.00 avg-zkey = 1.90 avg-val = 124.84 avg-zval = 32.53 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 920293 bytes = 3221040 } seq expand size = 6442051 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0184 GB value = 0.1084 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0299 GB dict = 1.08 MB all = 0.0360 GB } UnZip/Zip{ index = 10.5118 value = 3.6231 dict = 1.00 all = 3.7288 } Zip/UnZip{ index = 0.0951 value = 0.2760 dict = 1.00 all = 0.2682 } ---------------------------- total value len = 2251.670000 GB avg = 0.200 KB (by entry num) total key len = 306.960597 GB avg = 0.027 KB total ukey len = 237.410181 GB avg = 0.015 KB total ukey num = 15.741433840 Billion total entry num = 11.282747788 Billion write speed all = 32.495407104 MB/sec (with seq num) write speed all = 31.349051760 MB/sec (without seq num) 2024/11/24-06:47:30.483391 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295412: 920293 keys, 35995192 bytes, temperature: kWarm 2024/11/24-06:47:30.483468 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402050483432, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295412, "file_size": 35995192, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4261178686, "largest_seqno": 4484448851, "table_properties": {"data_size": 29932960, "index_size": 1750976, "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": 25768204, "raw_average_key_size": 28, "raw_value_size": 108449610, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 920293, "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": 1732402047, "oldest_key_time": 0, "file_creation_time": 1732402047, "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": 295412, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:47:30.522261 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295413.sst) /dev/shm/ToplingTemp/Topling-291905-WxnviH 2024/11/24-06:47:31.389526 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295413.sst): first pass time = 0.87's, 154.766'MB/sec 2024/11/24-06:47:32.727668 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295413.sst): old prealloc_size = 147639500, real_size = 32211808 2024/11/24-06:47:32.728216 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295413.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 927930 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.1082 GB zip-val = 0.0302 GB avg-val = 116.64 avg-zval = 32.56 2024/11/24-06:47:32.728983 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295413.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:47:33.562192 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295413.sst): second pass time = 1.34's, 80.961'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.83's, 43.515'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3347.531'MB/sec (index lex order gen) rebuild zvType time = 0.71's, 0.328'MB/sec write SST data time = 0.13's, 288.104'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 = 33169.359'MB/sec zip my value time = 1.34's, unzip length = 0.108'GB zip my value throughput = 80.961'MB/sec zip pipeline throughput = 80.961'MB/sec entries = 927930 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.64 avg-zval = 32.56 usrkeys = 927930 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.64 avg-zval = 32.56 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 927930 bytes = 3247776 } seq expand size = 6495510 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.0302 GB dict = 1.08 MB all = 0.0363 GB } UnZip/Zip{ index = 10.5145 value = 3.5822 dict = 1.00 all = 3.6961 } Zip/UnZip{ index = 0.0951 value = 0.2792 dict = 1.00 all = 0.2706 } ---------------------------- total value len = 2251.784732 GB avg = 0.200 KB (by entry num) total key len = 306.986579 GB avg = 0.027 KB total ukey len = 237.428739 GB avg = 0.015 KB total ukey num = 15.742361770 Billion total entry num = 11.283675718 Billion write speed all = 32.495904518 MB/sec (with seq num) write speed all = 31.349500391 MB/sec (without seq num) 2024/11/24-06:47:33.607696 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295413: 927930 keys, 36313352 bytes, temperature: kWarm 2024/11/24-06:47:33.607768 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402053607732, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295413, "file_size": 36313352, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4261178700, "largest_seqno": 4484447114, "table_properties": {"data_size": 30214608, "index_size": 1765056, "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": 25982040, "raw_average_key_size": 28, "raw_value_size": 108235828, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 927930, "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": 1732402050, "oldest_key_time": 0, "file_creation_time": 1732402050, "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": 295413, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:47:33.644214 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295414.sst) /dev/shm/ToplingTemp/Topling-291905-NbkQtI 2024/11/24-06:47:34.578708 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295414.sst): first pass time = 0.93's, 143.631'MB/sec 2024/11/24-06:47:35.923896 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295414.sst): old prealloc_size = 147639500, real_size = 31444656 2024/11/24-06:47:35.924447 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295414.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 919300 prefix = 4 raw-key = 0.0147 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1085 GB zip-val = 0.0295 GB avg-val = 118.00 avg-zval = 32.04 2024/11/24-06:47:35.925194 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295414.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:47:36.740368 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295414.sst): second pass time = 1.34's, 80.695'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 43.507'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3342.102'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.334'MB/sec write SST data time = 0.13's, 280.149'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.085'MB, throughput = 31801.688'MB/sec zip my value time = 1.34's, unzip length = 0.108'GB zip my value throughput = 80.695'MB/sec zip pipeline throughput = 80.695'MB/sec entries = 919300 avg-key = 28.00 avg-zkey = 1.91 avg-val = 118.00 avg-zval = 32.04 usrkeys = 919300 avg-key = 20.00 avg-zkey = 1.91 avg-val = 125.00 avg-zval = 32.04 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 919300 bytes = 3217568 } seq expand size = 6435100 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0184 GB value = 0.1085 GB dict = 1.09 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0295 GB dict = 1.09 MB all = 0.0355 GB } UnZip/Zip{ index = 10.4458 value = 3.6829 dict = 1.00 all = 3.7785 } Zip/UnZip{ index = 0.0957 value = 0.2715 dict = 1.00 all = 0.2647 } ---------------------------- total value len = 2251.899644 GB avg = 0.200 KB (by entry num) total key len = 307.012320 GB avg = 0.027 KB total ukey len = 237.447125 GB avg = 0.015 KB total ukey num = 15.743281070 Billion total entry num = 11.284595018 Billion write speed all = 32.496379157 MB/sec (with seq num) write speed all = 31.349927904 MB/sec (without seq num) 2024/11/24-06:47:36.784267 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295414: 919300 keys, 35521394 bytes, temperature: kWarm 2024/11/24-06:47:36.784339 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402056784304, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295414, "file_size": 35521394, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4286171530, "largest_seqno": 4438207395, "table_properties": {"data_size": 29454496, "index_size": 1760128, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 25740400, "raw_average_key_size": 28, "raw_value_size": 108477400, "raw_average_value_size": 118, "num_data_blocks": 1, "num_entries": 919300, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 118, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_Tag1-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732402053, "oldest_key_time": 0, "file_creation_time": 1732402053, "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": 295414, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:47:36.819929 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295415.sst) /dev/shm/ToplingTemp/Topling-291905-Ls9FdH 2024/11/24-06:47:37.777335 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295415.sst): first pass time = 0.96's, 140.195'MB/sec 2024/11/24-06:47:39.139406 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295415.sst): old prealloc_size = 147639500, real_size = 33319936 2024/11/24-06:47:39.139938 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295415.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 927958 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.1082 GB zip-val = 0.0313 GB avg-val = 116.64 avg-zval = 33.75 2024/11/24-06:47:39.140695 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295415.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:47:39.995401 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295415.sst): second pass time = 1.36's, 79.511'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.86's, 43.719'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3558.028'MB/sec (index lex order gen) rebuild zvType time = 0.73's, 0.318'MB/sec write SST data time = 0.13's, 295.252'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 = 34083.257'MB/sec zip my value time = 1.36's, unzip length = 0.108'GB zip my value throughput = 79.511'MB/sec zip pipeline throughput = 79.511'MB/sec entries = 927958 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.64 avg-zval = 33.75 usrkeys = 927958 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.64 avg-zval = 33.75 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 927958 bytes = 3247872 } seq expand size = 6495706 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0186 GB value = 0.1082 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0313 GB dict = 1.08 MB all = 0.0374 GB } UnZip/Zip{ index = 10.5121 value = 3.4555 dict = 1.00 all = 3.5866 } Zip/UnZip{ index = 0.0951 value = 0.2894 dict = 1.00 all = 0.2788 } ---------------------------- total value len = 2252.014375 GB avg = 0.200 KB (by entry num) total key len = 307.038303 GB avg = 0.027 KB total ukey len = 237.465685 GB avg = 0.015 KB total ukey num = 15.744209028 Billion total entry num = 11.285522976 Billion write speed all = 32.496822810 MB/sec (with seq num) write speed all = 31.350324674 MB/sec (without seq num) 2024/11/24-06:47:40.040999 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295415: 927958 keys, 37421640 bytes, temperature: kWarm 2024/11/24-06:47:40.041070 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402060041035, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295415, "file_size": 37421640, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4261178719, "largest_seqno": 4484447132, "table_properties": {"data_size": 31322288, "index_size": 1765504, "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": 25982824, "raw_average_key_size": 28, "raw_value_size": 108234960, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 927958, "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": 1732402056, "oldest_key_time": 0, "file_creation_time": 1732402056, "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": 295415, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:47:40.077425 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295416.sst) /dev/shm/ToplingTemp/Topling-291905-ALzwzG 2024/11/24-06:47:41.070212 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295416.sst): first pass time = 0.99's, 135.198'MB/sec 2024/11/24-06:47:42.423244 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295416.sst): old prealloc_size = 147639500, real_size = 31364080 2024/11/24-06:47:42.423780 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295416.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 919300 prefix = 4 raw-key = 0.0147 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.92 raw-val = 0.1085 GB zip-val = 0.0294 GB avg-val = 118.00 avg-zval = 31.95 2024/11/24-06:47:42.424541 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295416.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:47:43.237129 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295416.sst): second pass time = 1.35's, 80.248'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.81's, 43.546'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3440.127'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.335'MB/sec write SST data time = 0.13's, 280.286'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.085'MB, throughput = 35195.601'MB/sec zip my value time = 1.35's, unzip length = 0.108'GB zip my value throughput = 80.248'MB/sec zip pipeline throughput = 80.248'MB/sec entries = 919300 avg-key = 28.00 avg-zkey = 1.92 avg-val = 118.00 avg-zval = 31.95 usrkeys = 919300 avg-key = 20.00 avg-zkey = 1.92 avg-val = 125.00 avg-zval = 31.95 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 919300 bytes = 3217568 } seq expand size = 6435100 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0184 GB value = 0.1085 GB dict = 1.09 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0294 GB dict = 1.09 MB all = 0.0354 GB } UnZip/Zip{ index = 10.4428 value = 3.6930 dict = 1.00 all = 3.7871 } Zip/UnZip{ index = 0.0958 value = 0.2708 dict = 1.00 all = 0.2641 } ---------------------------- total value len = 2252.129287 GB avg = 0.200 KB (by entry num) total key len = 307.064043 GB avg = 0.027 KB total ukey len = 237.484071 GB avg = 0.015 KB total ukey num = 15.745128328 Billion total entry num = 11.286442276 Billion write speed all = 32.497271144 MB/sec (with seq num) write speed all = 31.350726815 MB/sec (without seq num) 2024/11/24-06:47:43.281254 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295416: 919300 keys, 35440818 bytes, temperature: kWarm 2024/11/24-06:47:43.281325 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402063281289, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295416, "file_size": 35440818, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4316662274, "largest_seqno": 4467860476, "table_properties": {"data_size": 29373408, "index_size": 1760640, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 25740400, "raw_average_key_size": 28, "raw_value_size": 108477400, "raw_average_value_size": 118, "num_data_blocks": 1, "num_entries": 919300, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 118, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_Tag1-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732402060, "oldest_key_time": 0, "file_creation_time": 1732402060, "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": 295416, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:47:43.319862 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295417.sst) /dev/shm/ToplingTemp/Topling-291905-gQ4TME 2024/11/24-06:47:44.295022 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295417.sst): first pass time = 0.98's, 137.642'MB/sec 2024/11/24-06:47:45.644280 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295417.sst): old prealloc_size = 147639500, real_size = 33282064 2024/11/24-06:47:45.644828 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295417.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 928259 prefix = 4 raw-key = 0.0149 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1082 GB zip-val = 0.0313 GB avg-val = 116.59 avg-zval = 33.69 2024/11/24-06:47:45.646364 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295417.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:47:46.502219 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295417.sst): second pass time = 1.35's, 80.264'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.86's, 43.576'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3366.845'MB/sec (index lex order gen) rebuild zvType time = 0.73's, 0.318'MB/sec write SST data time = 0.13's, 293.854'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 = 33364.982'MB/sec zip my value time = 1.35's, unzip length = 0.108'GB zip my value throughput = 80.264'MB/sec zip pipeline throughput = 80.264'MB/sec entries = 928259 avg-key = 28.00 avg-zkey = 1.91 avg-val = 116.59 avg-zval = 33.69 usrkeys = 928259 avg-key = 20.00 avg-zkey = 1.91 avg-val = 123.59 avg-zval = 33.69 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 928259 bytes = 3248928 } seq expand size = 6497813 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0186 GB value = 0.1082 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0313 GB dict = 1.08 MB all = 0.0374 GB } UnZip/Zip{ index = 10.4440 value = 3.4608 dict = 1.00 all = 3.5902 } Zip/UnZip{ index = 0.0957 value = 0.2890 dict = 1.00 all = 0.2785 } ---------------------------- total value len = 2252.244012 GB avg = 0.200 KB (by entry num) total key len = 307.090034 GB avg = 0.027 KB total ukey len = 237.502636 GB avg = 0.015 KB total ukey num = 15.746056587 Billion total entry num = 11.287370535 Billion write speed all = 32.497710605 MB/sec (with seq num) write speed all = 31.351119517 MB/sec (without seq num) 2024/11/24-06:47:46.546777 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295417: 928259 keys, 37384244 bytes, temperature: kWarm 2024/11/24-06:47:46.546848 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402066546812, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295417, "file_size": 37384244, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4261178730, "largest_seqno": 4484448384, "table_properties": {"data_size": 31272192, "index_size": 1777600, "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": 25991252, "raw_average_key_size": 28, "raw_value_size": 108226598, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 928259, "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": 1732402063, "oldest_key_time": 0, "file_creation_time": 1732402063, "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": 295417, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:47:46.583782 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295418.sst) /dev/shm/ToplingTemp/Topling-291905-d5x3lF 2024/11/24-06:47:47.444548 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295418.sst): first pass time = 0.86's, 155.935'MB/sec 2024/11/24-06:47:48.759362 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295418.sst): old prealloc_size = 147639500, real_size = 31194480 2024/11/24-06:47:48.759927 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295418.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 921149 prefix = 4 raw-key = 0.0147 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1084 GB zip-val = 0.0292 GB avg-val = 117.71 avg-zval = 31.70 2024/11/24-06:47:48.761728 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295418.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:47:49.576496 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295418.sst): second pass time = 1.31's, 82.514'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 43.172'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3269.427'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.334'MB/sec write SST data time = 0.13's, 277.799'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.084'MB, throughput = 26695.637'MB/sec zip my value time = 1.31's, unzip length = 0.108'GB zip my value throughput = 82.514'MB/sec zip pipeline throughput = 82.514'MB/sec entries = 921149 avg-key = 28.00 avg-zkey = 1.91 avg-val = 117.71 avg-zval = 31.70 usrkeys = 921149 avg-key = 20.00 avg-zkey = 1.91 avg-val = 124.71 avg-zval = 31.70 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 921149 bytes = 3224032 } seq expand size = 6448043 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0184 GB value = 0.1084 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0292 GB dict = 1.08 MB all = 0.0353 GB } UnZip/Zip{ index = 10.4456 value = 3.7132 dict = 1.00 all = 3.8048 } Zip/UnZip{ index = 0.0957 value = 0.2693 dict = 1.00 all = 0.2628 } ---------------------------- total value len = 2252.358885 GB avg = 0.200 KB (by entry num) total key len = 307.115827 GB avg = 0.027 KB total ukey len = 237.521059 GB avg = 0.015 KB total ukey num = 15.746977736 Billion total entry num = 11.288291684 Billion write speed all = 32.498228129 MB/sec (with seq num) write speed all = 31.351588229 MB/sec (without seq num) 2024/11/24-06:47:49.617928 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295418: 921149 keys, 35275864 bytes, temperature: kWarm 2024/11/24-06:47:49.618014 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402069617963, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295418, "file_size": 35275864, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4344908813, "largest_seqno": 4484447160, "table_properties": {"data_size": 29200288, "index_size": 1763712, "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": 25792172, "raw_average_key_size": 28, "raw_value_size": 108425618, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 921149, "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": 1732402066, "oldest_key_time": 0, "file_creation_time": 1732402066, "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": 295418, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:47:49.658514 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295419.sst) /dev/shm/ToplingTemp/Topling-291905-7DEulG 2024/11/24-06:47:50.470726 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295419.sst): first pass time = 0.81's, 165.256'MB/sec 2024/11/24-06:47:51.829564 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295419.sst): old prealloc_size = 147639500, real_size = 33067344 2024/11/24-06:47:51.830116 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295419.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 926012 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.1083 GB zip-val = 0.0311 GB avg-val = 116.94 avg-zval = 33.56 2024/11/24-06:47:51.831840 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295419.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:47:52.684683 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295419.sst): second pass time = 1.36's, 79.763'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.86's, 43.461'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3343.400'MB/sec (index lex order gen) rebuild zvType time = 0.73's, 0.319'MB/sec write SST data time = 0.13's, 289.014'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 = 33669.316'MB/sec zip my value time = 1.36's, unzip length = 0.108'GB zip my value throughput = 79.763'MB/sec zip pipeline throughput = 79.763'MB/sec entries = 926012 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.94 avg-zval = 33.56 usrkeys = 926012 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.94 avg-zval = 33.56 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 926012 bytes = 3241056 } seq expand size = 6482084 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0185 GB value = 0.1083 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0311 GB dict = 1.08 MB all = 0.0372 GB } UnZip/Zip{ index = 10.5129 value = 3.4849 dict = 1.00 all = 3.6116 } Zip/UnZip{ index = 0.0951 value = 0.2870 dict = 1.00 all = 0.2769 } ---------------------------- total value len = 2252.473657 GB avg = 0.200 KB (by entry num) total key len = 307.141755 GB avg = 0.027 KB total ukey len = 237.539579 GB avg = 0.015 KB total ukey num = 15.747903748 Billion total entry num = 11.289217696 Billion write speed all = 32.498732052 MB/sec (with seq num) write speed all = 31.352043345 MB/sec (without seq num) 2024/11/24-06:47:52.730197 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295419: 926012 keys, 37162984 bytes, temperature: kWarm 2024/11/24-06:47:52.730272 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402072730233, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295419, "file_size": 37162984, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4265680186, "largest_seqno": 4484448665, "table_properties": {"data_size": 31073984, "index_size": 1761664, "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": 25928336, "raw_average_key_size": 28, "raw_value_size": 108289392, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 926012, "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": 1732402069, "oldest_key_time": 0, "file_creation_time": 1732402069, "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": 295419, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:47:52.772898 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295420.sst) /dev/shm/ToplingTemp/Topling-291905-3emxDG 2024/11/24-06:47:53.793013 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295420.sst): first pass time = 1.02's, 131.577'MB/sec 2024/11/24-06:47:55.100312 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295420.sst): old prealloc_size = 147639500, real_size = 30667792 2024/11/24-06:47:55.100860 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295420.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 927036 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1083 GB zip-val = 0.0287 GB avg-val = 116.78 avg-zval = 30.92 2024/11/24-06:47:55.101636 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295420.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:47:55.918113 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295420.sst): second pass time = 1.31's, 82.862'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 42.370'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3399.716'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.337'MB/sec write SST data time = 0.13's, 266.172'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.081'MB, throughput = 34014.732'MB/sec zip my value time = 1.31's, unzip length = 0.108'GB zip my value throughput = 82.862'MB/sec zip pipeline throughput = 82.862'MB/sec entries = 927036 avg-key = 28.00 avg-zkey = 1.91 avg-val = 116.78 avg-zval = 30.92 usrkeys = 927036 avg-key = 20.00 avg-zkey = 1.91 avg-val = 123.78 avg-zval = 30.92 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 927036 bytes = 3128768 } seq expand size = 6489252 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0185 GB value = 0.1083 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0287 GB dict = 1.08 MB all = 0.0346 GB } UnZip/Zip{ index = 10.4471 value = 3.7773 dict = 1.00 all = 3.8736 } Zip/UnZip{ index = 0.0957 value = 0.2647 dict = 1.00 all = 0.2582 } ---------------------------- total value len = 2252.588407 GB avg = 0.200 KB (by entry num) total key len = 307.167712 GB avg = 0.027 KB total ukey len = 237.558120 GB avg = 0.015 KB total ukey num = 15.748830784 Billion total entry num = 11.290144732 Billion write speed all = 32.499184351 MB/sec (with seq num) write speed all = 31.352448559 MB/sec (without seq num) 2024/11/24-06:47:55.960989 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295420: 927036 keys, 34649330 bytes, temperature: kWarm 2024/11/24-06:47:55.961063 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402075961027, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295420, "file_size": 34649330, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4379725532, "largest_seqno": 4484447179, "table_properties": {"data_size": 28661120, "index_size": 1774720, "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": 25957008, "raw_average_key_size": 28, "raw_value_size": 108260804, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 927036, "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": 1732402072, "oldest_key_time": 0, "file_creation_time": 1732402072, "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": 295420, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:47:55.996644 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295421.sst) /dev/shm/ToplingTemp/Topling-291905-xcFnuF 2024/11/24-06:47:56.987126 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295421.sst): first pass time = 0.99's, 135.512'MB/sec 2024/11/24-06:47:58.333004 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295421.sst): old prealloc_size = 147639500, real_size = 31778128 2024/11/24-06:47:58.333537 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295421.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 920260 prefix = 4 raw-key = 0.0147 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.1085 GB zip-val = 0.0298 GB avg-val = 117.85 avg-zval = 32.38 2024/11/24-06:47:58.335260 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295421.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:47:59.151115 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295421.sst): second pass time = 1.35's, 80.632'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 43.832'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3459.436'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.334'MB/sec write SST data time = 0.13's, 276.544'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.084'MB, throughput = 30310.651'MB/sec zip my value time = 1.35's, unzip length = 0.108'GB zip my value throughput = 80.632'MB/sec zip pipeline throughput = 80.632'MB/sec entries = 920260 avg-key = 28.00 avg-zkey = 1.90 avg-val = 117.85 avg-zval = 32.38 usrkeys = 920260 avg-key = 20.00 avg-zkey = 1.90 avg-val = 124.85 avg-zval = 32.38 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 920260 bytes = 3220928 } seq expand size = 6441820 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0184 GB value = 0.1085 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0298 GB dict = 1.08 MB all = 0.0359 GB } UnZip/Zip{ index = 10.5114 value = 3.6397 dict = 1.00 all = 3.7429 } Zip/UnZip{ index = 0.0951 value = 0.2748 dict = 1.00 all = 0.2672 } ---------------------------- total value len = 2252.703299 GB avg = 0.200 KB (by entry num) total key len = 307.193479 GB avg = 0.027 KB total ukey len = 237.576525 GB avg = 0.015 KB total ukey num = 15.749751044 Billion total entry num = 11.291064992 Billion write speed all = 32.499636188 MB/sec (with seq num) write speed all = 31.352853997 MB/sec (without seq num) 2024/11/24-06:47:59.196924 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295421: 920260 keys, 35859076 bytes, temperature: kWarm 2024/11/24-06:47:59.197014 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402079196961, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295421, "file_size": 35859076, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4265680199, "largest_seqno": 4484446357, "table_properties": {"data_size": 29796928, "index_size": 1750976, "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": 25767280, "raw_average_key_size": 28, "raw_value_size": 108450552, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 920260, "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": 1732402075, "oldest_key_time": 0, "file_creation_time": 1732402075, "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": 295421, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:47:59.237183 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295422.sst) /dev/shm/ToplingTemp/Topling-291905-vMFUHI 2024/11/24-06:48:00.270337 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295422.sst): first pass time = 1.03's, 129.917'MB/sec 2024/11/24-06:48:01.616559 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295422.sst): old prealloc_size = 147639500, real_size = 32442352 2024/11/24-06:48:01.617136 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295422.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 927637 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.1082 GB zip-val = 0.0304 GB avg-val = 116.69 avg-zval = 32.82 2024/11/24-06:48:01.618756 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295422.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:48:02.457355 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295422.sst): second pass time = 1.34's, 80.495'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.84's, 43.464'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3187.098'MB/sec (index lex order gen) rebuild zvType time = 0.71's, 0.326'MB/sec write SST data time = 0.13's, 284.361'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 = 33367.000'MB/sec zip my value time = 1.34's, unzip length = 0.108'GB zip my value throughput = 80.495'MB/sec zip pipeline throughput = 80.495'MB/sec entries = 927637 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.69 avg-zval = 32.82 usrkeys = 927637 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.69 avg-zval = 32.82 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 927637 bytes = 3246752 } seq expand size = 6493459 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0186 GB value = 0.1082 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0304 GB dict = 1.08 MB all = 0.0365 GB } UnZip/Zip{ index = 10.5153 value = 3.5553 dict = 1.00 all = 3.6728 } Zip/UnZip{ index = 0.0951 value = 0.2813 dict = 1.00 all = 0.2723 } ---------------------------- total value len = 2252.818037 GB avg = 0.200 KB (by entry num) total key len = 307.219453 GB avg = 0.027 KB total ukey len = 237.595078 GB avg = 0.015 KB total ukey num = 15.750678681 Billion total entry num = 11.291992629 Billion write speed all = 32.500058423 MB/sec (with seq num) write speed all = 31.353230155 MB/sec (without seq num) 2024/11/24-06:48:02.502453 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295422: 927637 keys, 36543346 bytes, temperature: kWarm 2024/11/24-06:48:02.502526 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402082502490, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295422, "file_size": 36543346, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4265680212, "largest_seqno": 4484448811, "table_properties": {"data_size": 30445920, "index_size": 1764352, "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": 25973836, "raw_average_key_size": 28, "raw_value_size": 108243958, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 927637, "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": 1732402079, "oldest_key_time": 0, "file_creation_time": 1732402079, "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": 295422, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:48:02.539594 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295423.sst) /dev/shm/ToplingTemp/Topling-291905-5Y94UE 2024/11/24-06:48:03.532061 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295423.sst): first pass time = 0.99's, 135.241'MB/sec 2024/11/24-06:48:04.839041 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295423.sst): old prealloc_size = 147639500, real_size = 31410208 2024/11/24-06:48:04.839589 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295423.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 919300 prefix = 4 raw-key = 0.0147 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1085 GB zip-val = 0.0294 GB avg-val = 118.00 avg-zval = 32.00 2024/11/24-06:48:04.840703 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295423.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:48:05.655377 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295423.sst): second pass time = 1.31's, 83.074'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 43.472'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3364.281'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.334'MB/sec write SST data time = 0.13's, 277.112'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.085'MB, throughput = 34302.109'MB/sec zip my value time = 1.31's, unzip length = 0.108'GB zip my value throughput = 83.074'MB/sec zip pipeline throughput = 83.074'MB/sec entries = 919300 avg-key = 28.00 avg-zkey = 1.91 avg-val = 118.00 avg-zval = 32.00 usrkeys = 919300 avg-key = 20.00 avg-zkey = 1.91 avg-val = 125.00 avg-zval = 32.00 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 919300 bytes = 3217568 } seq expand size = 6435100 multi value expand size = 0 cnt WriteAppend = 12 UnZipSize{ index = 0.0184 GB value = 0.1085 GB dict = 1.09 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0294 GB dict = 1.09 MB all = 0.0355 GB } UnZip/Zip{ index = 10.4455 value = 3.6872 dict = 1.00 all = 3.7822 } Zip/UnZip{ index = 0.0957 value = 0.2712 dict = 1.00 all = 0.2644 } ---------------------------- total value len = 2252.932949 GB avg = 0.199 KB (by entry num) total key len = 307.245193 GB avg = 0.027 KB total ukey len = 237.613464 GB avg = 0.015 KB total ukey num = 15.751597981 Billion total entry num = 11.292911929 Billion write speed all = 32.500524530 MB/sec (with seq num) write speed all = 31.353649459 MB/sec (without seq num) 2024/11/24-06:48:05.698702 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295423: 919300 keys, 35486898 bytes, temperature: kWarm 2024/11/24-06:48:05.698770 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402085698734, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295423, "file_size": 35486898, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4296880857, "largest_seqno": 4448595734, "table_properties": {"data_size": 29419984, "index_size": 1760192, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 25740400, "raw_average_key_size": 28, "raw_value_size": 108477400, "raw_average_value_size": 118, "num_data_blocks": 1, "num_entries": 919300, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 118, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_Tag1-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732402082, "oldest_key_time": 0, "file_creation_time": 1732402082, "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": 295423, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:48:05.742867 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295424.sst) /dev/shm/ToplingTemp/Topling-291905-4NVnLF 2024/11/24-06:48:06.681785 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295424.sst): first pass time = 0.94's, 142.955'MB/sec 2024/11/24-06:48:08.027598 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295424.sst): old prealloc_size = 147639500, real_size = 33511152 2024/11/24-06:48:08.028145 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295424.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 928055 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1082 GB zip-val = 0.0315 GB avg-val = 116.62 avg-zval = 33.94 2024/11/24-06:48:08.028911 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295424.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:48:08.881889 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295424.sst): second pass time = 1.34's, 80.494'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.85's, 44.034'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3390.602'MB/sec (index lex order gen) rebuild zvType time = 0.73's, 0.320'MB/sec write SST data time = 0.13's, 292.769'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 = 29754.326'MB/sec zip my value time = 1.34's, unzip length = 0.108'GB zip my value throughput = 80.494'MB/sec zip pipeline throughput = 80.494'MB/sec entries = 928055 avg-key = 28.00 avg-zkey = 1.91 avg-val = 116.62 avg-zval = 33.94 usrkeys = 928055 avg-key = 20.00 avg-zkey = 1.91 avg-val = 123.62 avg-zval = 33.94 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 928055 bytes = 3248208 } seq expand size = 6496385 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0186 GB value = 0.1082 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0315 GB dict = 1.08 MB all = 0.0376 GB } UnZip/Zip{ index = 10.4454 value = 3.4357 dict = 1.00 all = 3.5680 } Zip/UnZip{ index = 0.0957 value = 0.2911 dict = 1.00 all = 0.2803 } ---------------------------- total value len = 2253.047678 GB avg = 0.199 KB (by entry num) total key len = 307.271179 GB avg = 0.027 KB total ukey len = 237.632025 GB avg = 0.015 KB total ukey num = 15.752526036 Billion total entry num = 11.293839984 Billion write speed all = 32.500979629 MB/sec (with seq num) write speed all = 31.354057284 MB/sec (without seq num) 2024/11/24-06:48:08.927080 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295424: 928055 keys, 37616692 bytes, temperature: kWarm 2024/11/24-06:48:08.927149 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402088927113, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295424, "file_size": 37616692, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4265679834, "largest_seqno": 4484447331, "table_properties": {"data_size": 31501984, "index_size": 1776960, "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": 25985540, "raw_average_key_size": 28, "raw_value_size": 108232318, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 928055, "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": 1732402085, "oldest_key_time": 0, "file_creation_time": 1732402085, "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": 295424, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:48:08.965815 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295425.sst) /dev/shm/ToplingTemp/Topling-291905-lEF5rE 2024/11/24-06:48:09.883615 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295425.sst): first pass time = 0.92's, 146.245'MB/sec 2024/11/24-06:48:11.195938 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295425.sst): old prealloc_size = 147639500, real_size = 29697744 2024/11/24-06:48:11.196516 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295425.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 933792 prefix = 4 raw-key = 0.0149 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.92 raw-val = 0.1081 GB zip-val = 0.0277 GB avg-val = 115.73 avg-zval = 29.64 2024/11/24-06:48:11.197566 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295425.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:48:12.014838 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295425.sst): second pass time = 1.31's, 82.404'MB/sec, value only(80.5% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 41.295'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3206.599'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.338'MB/sec write SST data time = 0.13's, 263.328'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.079'MB, throughput = 31502.044'MB/sec zip my value time = 1.31's, unzip length = 0.108'GB zip my value throughput = 82.404'MB/sec zip pipeline throughput = 82.404'MB/sec entries = 933792 avg-key = 28.00 avg-zkey = 1.92 avg-val = 115.73 avg-zval = 29.64 usrkeys = 933792 avg-key = 20.00 avg-zkey = 1.92 avg-val = 122.73 avg-zval = 29.64 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 933792 bytes = 3268288 } seq expand size = 6536544 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.0277 GB dict = 1.08 MB all = 0.0338 GB } UnZip/Zip{ index = 10.4438 value = 3.9049 dict = 1.00 all = 3.9692 } Zip/UnZip{ index = 0.0958 value = 0.2561 dict = 1.00 all = 0.2519 } ---------------------------- total value len = 2253.162286 GB avg = 0.199 KB (by entry num) total key len = 307.297325 GB avg = 0.027 KB total ukey len = 237.650701 GB avg = 0.015 KB total ukey num = 15.753459828 Billion total entry num = 11.294773776 Billion write speed all = 32.501473795 MB/sec (with seq num) write speed all = 31.354502236 MB/sec (without seq num) 2024/11/24-06:48:12.058300 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295425: 933792 keys, 33815222 bytes, temperature: kWarm 2024/11/24-06:48:12.058372 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402092058333, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295425, "file_size": 33815222, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4265680463, "largest_seqno": 4484446387, "table_properties": {"data_size": 27675904, "index_size": 1788224, "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": 26146176, "raw_average_key_size": 28, "raw_value_size": 108071636, "raw_average_value_size": 115, "num_data_blocks": 1, "num_entries": 933792, "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": 1732402088, "oldest_key_time": 0, "file_creation_time": 1732402088, "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": 295425, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:48:12.095064 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295426.sst) /dev/shm/ToplingTemp/Topling-291905-kuudrF 2024/11/24-06:48:13.037853 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295426.sst): first pass time = 0.94's, 142.369'MB/sec 2024/11/24-06:48:14.302274 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295426.sst): old prealloc_size = 147639500, real_size = 27733008 2024/11/24-06:48:14.302827 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295426.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 945196 prefix = 4 raw-key = 0.0151 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1078 GB zip-val = 0.0257 GB avg-val = 114.00 avg-zval = 27.18 2024/11/24-06:48:14.303625 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295426.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0024 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:48:15.141655 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295426.sst): second pass time = 1.26's, 85.305'MB/sec, value only(80.3% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.84's, 37.844'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3390.477'MB/sec (index lex order gen) rebuild zvType time = 0.71's, 0.334'MB/sec write SST data time = 0.13's, 242.931'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.073'MB, throughput = 31027.402'MB/sec zip my value time = 1.26's, unzip length = 0.108'GB zip my value throughput = 85.305'MB/sec zip pipeline throughput = 85.305'MB/sec entries = 945196 avg-key = 28.00 avg-zkey = 1.91 avg-val = 114.00 avg-zval = 27.18 usrkeys = 945196 avg-key = 20.00 avg-zkey = 1.91 avg-val = 121.00 avg-zval = 27.18 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 945196 bytes = 3190048 } seq expand size = 6616372 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0189 GB value = 0.1078 GB dict = 1.07 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0257 GB dict = 1.07 MB all = 0.0318 GB } UnZip/Zip{ index = 10.4457 value = 4.1949 dict = 1.00 all = 4.2254 } Zip/UnZip{ index = 0.0957 value = 0.2384 dict = 1.00 all = 0.2367 } ---------------------------- total value len = 2253.276655 GB avg = 0.199 KB (by entry num) total key len = 307.323791 GB avg = 0.027 KB total ukey len = 237.669605 GB avg = 0.015 KB total ukey num = 15.754405024 Billion total entry num = 11.295718972 Billion write speed all = 32.501971466 MB/sec (with seq num) write speed all = 31.354949450 MB/sec (without seq num) 2024/11/24-06:48:15.182224 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295426: 945196 keys, 31764208 bytes, temperature: kWarm 2024/11/24-06:48:15.182298 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402095182262, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295426, "file_size": 31764208, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4321045603, "largest_seqno": 4423058090, "table_properties": {"data_size": 25686784, "index_size": 1809728, "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": 26465488, "raw_average_key_size": 28, "raw_value_size": 107752344, "raw_average_value_size": 114, "num_data_blocks": 1, "num_entries": 945196, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 114, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_Tag1-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732402092, "oldest_key_time": 0, "file_creation_time": 1732402092, "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": 295426, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:48:15.220632 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295427.sst) /dev/shm/ToplingTemp/Topling-291905-DV1oKI 2024/11/24-06:48:16.290804 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295427.sst): first pass time = 1.07's, 125.422'MB/sec 2024/11/24-06:48:17.617331 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295427.sst): old prealloc_size = 147639500, real_size = 32355456 2024/11/24-06:48:17.617927 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295427.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 934437 prefix = 4 raw-key = 0.0150 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1081 GB zip-val = 0.0303 GB avg-val = 115.63 avg-zval = 32.46 2024/11/24-06:48:17.618754 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295427.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:48:18.480606 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295427.sst): second pass time = 1.33's, 81.501'MB/sec, value only(80.5% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.86's, 42.255'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3124.969'MB/sec (index lex order gen) rebuild zvType time = 0.73's, 0.319'MB/sec write SST data time = 0.13's, 280.542'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 = 34620.893'MB/sec zip my value time = 1.33's, unzip length = 0.108'GB zip my value throughput = 81.501'MB/sec zip pipeline throughput = 81.501'MB/sec entries = 934437 avg-key = 28.00 avg-zkey = 1.91 avg-val = 115.63 avg-zval = 32.46 usrkeys = 934437 avg-key = 20.00 avg-zkey = 1.91 avg-val = 122.63 avg-zval = 32.46 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 934437 bytes = 3270544 } seq expand size = 6541059 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.0303 GB dict = 1.08 MB all = 0.0365 GB } UnZip/Zip{ index = 10.4443 value = 3.5623 dict = 1.00 all = 3.6796 } Zip/UnZip{ index = 0.0957 value = 0.2807 dict = 1.00 all = 0.2718 } ---------------------------- total value len = 2253.391249 GB avg = 0.199 KB (by entry num) total key len = 307.349955 GB avg = 0.027 KB total ukey len = 237.688293 GB avg = 0.015 KB total ukey num = 15.755339461 Billion total entry num = 11.296653409 Billion write speed all = 32.502380629 MB/sec (with seq num) write speed all = 31.355312340 MB/sec (without seq num) 2024/11/24-06:48:18.525025 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295427: 934437 keys, 36476348 bytes, temperature: kWarm 2024/11/24-06:48:18.525097 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402098525061, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295427, "file_size": 36476348, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4265679848, "largest_seqno": 4484448933, "table_properties": {"data_size": 30332272, "index_size": 1789376, "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": 26164236, "raw_average_key_size": 28, "raw_value_size": 108053546, "raw_average_value_size": 115, "num_data_blocks": 1, "num_entries": 934437, "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": 1732402095, "oldest_key_time": 0, "file_creation_time": 1732402095, "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": 295427, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:48:18.563634 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295428.sst) /dev/shm/ToplingTemp/Topling-291905-8jzXuI 2024/11/24-06:48:19.540799 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295428.sst): first pass time = 0.98's, 137.360'MB/sec 2024/11/24-06:48:20.845873 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295428.sst): old prealloc_size = 147639500, real_size = 31438688 2024/11/24-06:48:20.846485 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295428.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 919300 prefix = 4 raw-key = 0.0147 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1085 GB zip-val = 0.0294 GB avg-val = 118.00 avg-zval = 32.03 2024/11/24-06:48:20.847282 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295428.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:48:21.664822 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295428.sst): second pass time = 1.30's, 83.166'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 43.368'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3001.425'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.334'MB/sec write SST data time = 0.13's, 273.344'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.085'MB, throughput = 26557.582'MB/sec zip my value time = 1.30's, unzip length = 0.108'GB zip my value throughput = 83.166'MB/sec zip pipeline throughput = 83.166'MB/sec entries = 919300 avg-key = 28.00 avg-zkey = 1.91 avg-val = 118.00 avg-zval = 32.03 usrkeys = 919300 avg-key = 20.00 avg-zkey = 1.91 avg-val = 125.00 avg-zval = 32.03 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 919300 bytes = 3217568 } seq expand size = 6435100 multi value expand size = 0 cnt WriteAppend = 12 UnZipSize{ index = 0.0184 GB value = 0.1085 GB dict = 1.09 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0294 GB dict = 1.09 MB all = 0.0355 GB } UnZip/Zip{ index = 10.4443 value = 3.6837 dict = 1.00 all = 3.7791 } Zip/UnZip{ index = 0.0957 value = 0.2715 dict = 1.00 all = 0.2646 } ---------------------------- total value len = 2253.506162 GB avg = 0.199 KB (by entry num) total key len = 307.375695 GB avg = 0.027 KB total ukey len = 237.706679 GB avg = 0.015 KB total ukey num = 15.756258761 Billion total entry num = 11.297572709 Billion write speed all = 32.502852244 MB/sec (with seq num) write speed all = 31.355736971 MB/sec (without seq num) 2024/11/24-06:48:21.708531 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295428: 919300 keys, 35515378 bytes, temperature: kWarm 2024/11/24-06:48:21.708602 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402101708565, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295428, "file_size": 35515378, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4322986915, "largest_seqno": 4472782729, "table_properties": {"data_size": 29448272, "index_size": 1760384, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 25740400, "raw_average_key_size": 28, "raw_value_size": 108477400, "raw_average_value_size": 118, "num_data_blocks": 1, "num_entries": 919300, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 118, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_Tag1-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732402098, "oldest_key_time": 0, "file_creation_time": 1732402098, "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": 295428, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:48:21.762166 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295429.sst) /dev/shm/ToplingTemp/Topling-291905-not8NF 2024/11/24-06:48:22.768815 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295429.sst): first pass time = 1.01's, 133.337'MB/sec 2024/11/24-06:48:24.043503 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295429.sst): old prealloc_size = 147639500, real_size = 28049728 2024/11/24-06:48:24.044110 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295429.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 943384 prefix = 4 raw-key = 0.0151 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1078 GB zip-val = 0.0260 GB avg-val = 114.27 avg-zval = 27.57 2024/11/24-06:48:24.044892 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295429.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0024 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:48:24.885593 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295429.sst): second pass time = 1.27's, 84.663'MB/sec, value only(80.3% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.84's, 38.093'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3084.291'MB/sec (index lex order gen) rebuild zvType time = 0.71's, 0.333'MB/sec write SST data time = 0.13's, 241.621'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.074'MB, throughput = 27244.181'MB/sec zip my value time = 1.27's, unzip length = 0.108'GB zip my value throughput = 84.663'MB/sec zip pipeline throughput = 84.663'MB/sec entries = 943384 avg-key = 28.00 avg-zkey = 1.91 avg-val = 114.27 avg-zval = 27.57 usrkeys = 943384 avg-key = 20.00 avg-zkey = 1.91 avg-val = 121.27 avg-zval = 27.57 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 943384 bytes = 3183936 } seq expand size = 6603688 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0189 GB value = 0.1078 GB dict = 1.07 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0260 GB dict = 1.07 MB all = 0.0321 GB } UnZip/Zip{ index = 10.4442 value = 4.1451 dict = 1.00 all = 4.1843 } Zip/UnZip{ index = 0.0957 value = 0.2412 dict = 1.00 all = 0.2390 } ---------------------------- total value len = 2253.620569 GB avg = 0.199 KB (by entry num) total key len = 307.402110 GB avg = 0.027 KB total ukey len = 237.725547 GB avg = 0.015 KB total ukey num = 15.757202145 Billion total entry num = 11.298516093 Billion write speed all = 32.503310882 MB/sec (with seq num) write speed all = 31.356146714 MB/sec (without seq num) 2024/11/24-06:48:24.925823 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295429: 943384 keys, 32076328 bytes, temperature: kWarm 2024/11/24-06:48:24.925894 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402104925859, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295429, "file_size": 32076328, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4352063919, "largest_seqno": 4484447871, "table_properties": {"data_size": 26007152, "index_size": 1806528, "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": 26414752, "raw_average_key_size": 28, "raw_value_size": 107803044, "raw_average_value_size": 114, "num_data_blocks": 1, "num_entries": 943384, "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": 1732402101, "oldest_key_time": 0, "file_creation_time": 1732402101, "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": 295429, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:48:24.964458 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295430.sst) /dev/shm/ToplingTemp/Topling-291905-eBtKKF 2024/11/24-06:48:25.949795 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295430.sst): first pass time = 0.99's, 136.220'MB/sec 2024/11/24-06:48:27.308969 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295430.sst): old prealloc_size = 147639500, real_size = 32960752 2024/11/24-06:48:27.309598 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295430.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 928380 prefix = 4 raw-key = 0.0149 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.1082 GB zip-val = 0.0310 GB avg-val = 116.57 avg-zval = 33.35 2024/11/24-06:48:27.310391 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295430.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:48:28.170099 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295430.sst): second pass time = 1.36's, 79.698'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.86's, 43.041'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3070.152'MB/sec (index lex order gen) rebuild zvType time = 0.73's, 0.318'MB/sec write SST data time = 0.13's, 285.208'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.079'MB, throughput = 30748.782'MB/sec zip my value time = 1.36's, unzip length = 0.108'GB zip my value throughput = 79.698'MB/sec zip pipeline throughput = 79.698'MB/sec entries = 928380 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.57 avg-zval = 33.35 usrkeys = 928380 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.57 avg-zval = 33.35 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 928380 bytes = 3249344 } seq expand size = 6498660 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0186 GB value = 0.1082 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0310 GB dict = 1.08 MB all = 0.0371 GB } UnZip/Zip{ index = 10.5138 value = 3.4953 dict = 1.00 all = 3.6213 } Zip/UnZip{ index = 0.0951 value = 0.2861 dict = 1.00 all = 0.2761 } ---------------------------- total value len = 2253.735290 GB avg = 0.199 KB (by entry num) total key len = 307.428105 GB avg = 0.027 KB total ukey len = 237.744115 GB avg = 0.015 KB total ukey num = 15.758130525 Billion total entry num = 11.299444473 Billion write speed all = 32.503741856 MB/sec (with seq num) write speed all = 31.356531250 MB/sec (without seq num) 2024/11/24-06:48:28.217133 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295430: 928380 keys, 37063078 bytes, temperature: kWarm 2024/11/24-06:48:28.217205 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402108217169, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295430, "file_size": 37063078, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4265679865, "largest_seqno": 4484448695, "table_properties": {"data_size": 30962464, "index_size": 1766016, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 25994640, "raw_average_key_size": 28, "raw_value_size": 108223100, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 928380, "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": 1732402104, "oldest_key_time": 0, "file_creation_time": 1732402104, "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": 295430, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:48:28.254390 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295431.sst) /dev/shm/ToplingTemp/Topling-291905-TSEaeH 2024/11/24-06:48:29.240958 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295431.sst): first pass time = 0.99's, 136.052'MB/sec 2024/11/24-06:48:30.579560 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295431.sst): old prealloc_size = 147639500, real_size = 31336800 2024/11/24-06:48:30.580170 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295431.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 919300 prefix = 4 raw-key = 0.0147 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1085 GB zip-val = 0.0293 GB avg-val = 118.00 avg-zval = 31.92 2024/11/24-06:48:30.581054 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295431.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:48:31.395897 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295431.sst): second pass time = 1.34's, 81.110'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 43.241'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3011.360'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.335'MB/sec write SST data time = 0.13's, 272.076'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.085'MB, throughput = 32196.142'MB/sec zip my value time = 1.34's, unzip length = 0.108'GB zip my value throughput = 81.110'MB/sec zip pipeline throughput = 81.110'MB/sec entries = 919300 avg-key = 28.00 avg-zkey = 1.91 avg-val = 118.00 avg-zval = 31.92 usrkeys = 919300 avg-key = 20.00 avg-zkey = 1.91 avg-val = 125.00 avg-zval = 31.92 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 919300 bytes = 3102656 } seq expand size = 6435100 multi value expand size = 0 cnt WriteAppend = 11 UnZipSize{ index = 0.0184 GB value = 0.1085 GB dict = 1.09 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0293 GB dict = 1.09 MB all = 0.0353 GB } UnZip/Zip{ index = 10.4443 value = 3.6964 dict = 1.00 all = 3.8024 } Zip/UnZip{ index = 0.0957 value = 0.2705 dict = 1.00 all = 0.2630 } ---------------------------- total value len = 2253.850203 GB avg = 0.199 KB (by entry num) total key len = 307.453845 GB avg = 0.027 KB total ukey len = 237.762501 GB avg = 0.015 KB total ukey num = 15.759049825 Billion total entry num = 11.300363773 Billion write speed all = 32.504196205 MB/sec (with seq num) write speed all = 31.356939231 MB/sec (without seq num) 2024/11/24-06:48:31.439783 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295431: 919300 keys, 35298610 bytes, temperature: kWarm 2024/11/24-06:48:31.439852 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402111439816, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295431, "file_size": 35298610, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4339829886, "largest_seqno": 4459865838, "table_properties": {"data_size": 29346384, "index_size": 1760384, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 25740400, "raw_average_key_size": 28, "raw_value_size": 108477400, "raw_average_value_size": 118, "num_data_blocks": 1, "num_entries": 919300, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 118, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_Tag1-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732402108, "oldest_key_time": 0, "file_creation_time": 1732402108, "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": 295431, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:48:31.476202 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295432.sst) /dev/shm/ToplingTemp/Topling-291905-dtdZCG 2024/11/24-06:48:32.506065 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295432.sst): first pass time = 1.03's, 130.330'MB/sec 2024/11/24-06:48:33.815290 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295432.sst): old prealloc_size = 147639500, real_size = 30235552 2024/11/24-06:48:33.815853 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295432.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 937851 prefix = 4 raw-key = 0.0150 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.92 raw-val = 0.1080 GB zip-val = 0.0282 GB avg-val = 115.11 avg-zval = 30.07 2024/11/24-06:48:33.816679 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295432.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:48:34.653556 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295432.sst): second pass time = 1.31's, 82.512'MB/sec, value only(80.4% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.84's, 40.999'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3339.506'MB/sec (index lex order gen) rebuild zvType time = 0.71's, 0.331'MB/sec write SST data time = 0.13's, 264.948'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.077'MB, throughput = 33335.912'MB/sec zip my value time = 1.31's, unzip length = 0.108'GB zip my value throughput = 82.512'MB/sec zip pipeline throughput = 82.512'MB/sec entries = 937851 avg-key = 28.00 avg-zkey = 1.92 avg-val = 115.11 avg-zval = 30.07 usrkeys = 937851 avg-key = 20.00 avg-zkey = 1.92 avg-val = 122.11 avg-zval = 30.07 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 937851 bytes = 3282496 } seq expand size = 6564957 multi value expand size = 0 cnt WriteAppend = 12 UnZipSize{ index = 0.0188 GB value = 0.1080 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0282 GB dict = 1.08 MB all = 0.0344 GB } UnZip/Zip{ index = 10.4428 value = 3.8277 dict = 1.00 all = 3.9055 } Zip/UnZip{ index = 0.0958 value = 0.2613 dict = 1.00 all = 0.2561 } ---------------------------- total value len = 2253.964726 GB avg = 0.199 KB (by entry num) total key len = 307.480105 GB avg = 0.027 KB total ukey len = 237.781258 GB avg = 0.015 KB total ukey num = 15.759987676 Billion total entry num = 11.301301624 Billion write speed all = 32.504639024 MB/sec (with seq num) write speed all = 31.357334267 MB/sec (without seq num) 2024/11/24-06:48:34.695904 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295432: 937851 keys, 34366638 bytes, temperature: kWarm 2024/11/24-06:48:34.695970 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402114695935, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295432, "file_size": 34366638, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4265679880, "largest_seqno": 4484448122, "table_properties": {"data_size": 28204752, "index_size": 1796160, "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": 26259828, "raw_average_key_size": 28, "raw_value_size": 107957930, "raw_average_value_size": 115, "num_data_blocks": 1, "num_entries": 937851, "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": 1732402111, "oldest_key_time": 0, "file_creation_time": 1732402111, "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": 295432, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:48:34.734853 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295433.sst) /dev/shm/ToplingTemp/Topling-291905-YCtusF 2024/11/24-06:48:35.569643 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295433.sst): first pass time = 0.83's, 160.787'MB/sec 2024/11/24-06:48:36.872174 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295433.sst): old prealloc_size = 147639500, real_size = 31381504 2024/11/24-06:48:36.872732 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295433.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 919300 prefix = 4 raw-key = 0.0147 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1085 GB zip-val = 0.0294 GB avg-val = 118.00 avg-zval = 31.97 2024/11/24-06:48:36.873506 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295433.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:48:37.689727 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295433.sst): second pass time = 1.30's, 83.334'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 43.232'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3291.409'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.334'MB/sec write SST data time = 0.13's, 273.070'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 1.085'MB, throughput = 35611.461'MB/sec zip my value time = 1.30's, unzip length = 0.108'GB zip my value throughput = 83.334'MB/sec zip pipeline throughput = 83.334'MB/sec entries = 919300 avg-key = 28.00 avg-zkey = 1.91 avg-val = 118.00 avg-zval = 31.97 usrkeys = 919300 avg-key = 20.00 avg-zkey = 1.91 avg-val = 125.00 avg-zval = 31.97 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 919300 bytes = 3102656 } seq expand size = 6435100 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0184 GB value = 0.1085 GB dict = 1.09 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0294 GB dict = 1.09 MB all = 0.0353 GB } UnZip/Zip{ index = 10.4443 value = 3.6908 dict = 1.00 all = 3.7975 } Zip/UnZip{ index = 0.0957 value = 0.2709 dict = 1.00 all = 0.2633 } ---------------------------- total value len = 2254.079638 GB avg = 0.199 KB (by entry num) total key len = 307.505845 GB avg = 0.027 KB total ukey len = 237.799644 GB avg = 0.015 KB total ukey num = 15.760906976 Billion total entry num = 11.302220924 Billion write speed all = 32.505171514 MB/sec (with seq num) write speed all = 31.357817637 MB/sec (without seq num) 2024/11/24-06:48:37.733435 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295433: 919300 keys, 35343346 bytes, temperature: kWarm 2024/11/24-06:48:37.733508 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402117733472, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295433, "file_size": 35343346, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4275002556, "largest_seqno": 4384796355, "table_properties": {"data_size": 29391088, "index_size": 1760384, "index_partitions": 0, "top_level_index_size": 0, "index_key_is_user_key": 0, "index_value_is_delta_encoded": 0, "filter_size": 0, "raw_key_size": 25740400, "raw_average_key_size": 28, "raw_value_size": 108477400, "raw_average_value_size": 118, "num_data_blocks": 1, "num_entries": 919300, "num_filter_entries": 0, "num_deletions": 0, "num_merge_operands": 0, "num_range_deletions": 0, "format_version": 0, "fixed_key_len": 28, "fixed_value_len": 118, "filter_policy": "", "column_family_name": "default", "column_family_id": 0, "comparator": "leveldb.BytewiseComparator", "merge_operator": "nullptr", "prefix_extractor_name": "nullptr", "property_collectors": "[Rdb_tbl_prop_coll_factory]", "compression": "FlatZip", "compression_options": "RS_Key0_Tag1-NestLoudsTrieDAWG_Mixed_XL_256_32_FL-DictZipBlobStore", "creation_time": 1732402114, "oldest_key_time": 0, "file_creation_time": 1732402114, "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": 295433, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:48:37.771482 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295434.sst) /dev/shm/ToplingTemp/Topling-291905-qSN8lI 2024/11/24-06:48:38.627573 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295434.sst): first pass time = 0.86's, 156.786'MB/sec 2024/11/24-06:48:39.930356 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295434.sst): old prealloc_size = 147639500, real_size = 31104720 2024/11/24-06:48:39.930909 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295434.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 922512 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1084 GB zip-val = 0.0291 GB avg-val = 117.49 avg-zval = 31.55 2024/11/24-06:48:39.931718 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295434.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0023 GB, waited 0.000 sec, Key+Value = 0.134 GB 2024/11/24-06:48:40.752219 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295434.sst): second pass time = 1.30's, 83.246'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 42.679'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3366.315'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.336'MB/sec write SST data time = 0.13's, 260.796'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 = 29213.095'MB/sec zip my value time = 1.30's, unzip length = 0.108'GB zip my value throughput = 83.246'MB/sec zip pipeline throughput = 83.246'MB/sec entries = 922512 avg-key = 28.00 avg-zkey = 1.91 avg-val = 117.49 avg-zval = 31.55 usrkeys = 922512 avg-key = 20.00 avg-zkey = 1.91 avg-val = 124.49 avg-zval = 31.55 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 922512 bytes = 3113488 } seq expand size = 6457584 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0185 GB value = 0.1084 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0291 GB dict = 1.08 MB all = 0.0351 GB } UnZip/Zip{ index = 10.4466 value = 3.7237 dict = 1.00 all = 3.8266 } Zip/UnZip{ index = 0.0957 value = 0.2686 dict = 1.00 all = 0.2613 } ---------------------------- total value len = 2254.194483 GB avg = 0.199 KB (by entry num) total key len = 307.531676 GB avg = 0.027 KB total ukey len = 237.818094 GB avg = 0.015 KB total ukey num = 15.761829488 Billion total entry num = 11.303143436 Billion write speed all = 32.505693395 MB/sec (with seq num) write speed all = 31.358290458 MB/sec (without seq num) 2024/11/24-06:48:40.795840 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295434: 922512 keys, 35074848 bytes, temperature: kWarm 2024/11/24-06:48:40.795913 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402120795876, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295434, "file_size": 35074848, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4384797175, "largest_seqno": 4484447903, "table_properties": {"data_size": 29107776, "index_size": 1766144, "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": 25830336, "raw_average_key_size": 28, "raw_value_size": 108387528, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 922512, "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": 1732402117, "oldest_key_time": 0, "file_creation_time": 1732402117, "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": 295434, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:48:40.831660 139957290698304 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295435.sst) /dev/shm/ToplingTemp/Topling-291905-myfTRG 2024/11/24-06:48:41.204919 139957290698304 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295435.sst): first pass time = 0.37's, 247.801'MB/sec 2024/11/24-06:48:42.145240 139957290698304 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295435.sst): old prealloc_size = 147639500, real_size = 23337632 2024/11/24-06:48:42.145672 139957290698304 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295435.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 644428 prefix = 4 raw-key = 0.0103 GB zip-key = 0.0012 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.0744 GB zip-val = 0.0219 GB avg-val = 115.51 avg-zval = 34.06 2024/11/24-06:48:42.146241 139957290698304 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295435.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0016 GB, waited 0.000 sec, Key+Value = 0.092 GB 2024/11/24-06:48:42.732052 139957290698304 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00/295435.sst): second pass time = 0.94's, 79.283'MB/sec, value only(80.5% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.59's, 44.623'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3021.222'MB/sec (index lex order gen) rebuild zvType time = 0.50's, 0.325'MB/sec write SST data time = 0.09's, 286.639'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.748'MB, throughput = 25392.573'MB/sec zip my value time = 0.94's, unzip length = 0.074'GB zip my value throughput = 79.283'MB/sec zip pipeline throughput = 79.283'MB/sec entries = 644428 avg-key = 28.00 avg-zkey = 1.90 avg-val = 115.51 avg-zval = 34.06 usrkeys = 644428 avg-key = 20.00 avg-zkey = 1.90 avg-val = 122.51 avg-zval = 34.06 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 644428 bytes = 2255520 } seq expand size = 4510996 multi value expand size = 0 cnt WriteAppend = 12 UnZipSize{ index = 0.0129 GB value = 0.0744 GB dict = 0.75 MB all = 0.0925 GB } __ZipSize{ index = 0.0012 GB value = 0.0219 GB dict = 0.75 MB all = 0.0262 GB } UnZip/Zip{ index = 10.5062 value = 3.3913 dict = 1.00 all = 3.5319 } Zip/UnZip{ index = 0.0952 value = 0.2949 dict = 1.00 all = 0.2831 } ---------------------------- total value len = 2254.273433 GB avg = 0.199 KB (by entry num) total key len = 307.549720 GB avg = 0.027 KB total ukey len = 237.830982 GB avg = 0.015 KB total ukey num = 15.762473916 Billion total entry num = 11.303787864 Billion write speed all = 32.506107517 MB/sec (with seq num) write speed all = 31.358667989 MB/sec (without seq num) 2024/11/24-06:48:42.766973 139957290698304 [compaction_job.cc:1948] [default] [JOB 43019] Generated table #295435: 644428 keys, 26184548 bytes, temperature: kWarm 2024/11/24-06:48:42.767059 139957290698304 EVENT_LOG_v1 {"time_micros": 1732402122767021, "cf_name": "default", "job": 43019, "event": "table_file_creation", "file_number": 295435, "file_size": 26184548, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4265679891, "largest_seqno": 4484448751, "table_properties": {"data_size": 21949584, "index_size": 1226752, "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": 18043984, "raw_average_key_size": 28, "raw_value_size": 74438160, "raw_average_value_size": 115, "num_data_blocks": 1, "num_entries": 644428, "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": 1732402120, "oldest_key_time": 0, "file_creation_time": 1732402120, "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": 295435, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-06:48:42.788080 139957290698304 [compaction_job.cc:703] job-43019: subcompact[0], size: 0.915526 G, files: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43019/att-00 [295410,295411,295412,295413,295414,295415,295416,295417,295418,295419,295420,295421,295422,295423,295424,295425,295426,295427,295428,295429,295430,295431,295432,295433,295434,295435] 2024/11/24-06:48:42.934221 139957290698304 (Original Log Time 2024/11/24-06:47:20.278965) EVENT_LOG_v1 {"time_micros": 1732402040278926, "job": 43019, "event": "compaction_started", "compaction_reason": "FilesMarkedForCompaction", "files_L2": [295349], "files_L3": [295390, 295391, 295306, 295307, 295308, 295309, 295310, 295311, 295312, 295313, 295314, 295315, 295316, 295317, 295318, 295319, 295320, 295321, 295322, 295278, 295279, 295280, 295281, 295282, 295283, 295284, 295392], "score": 0.986479, "input_data_size": 942777182, "oldest_snapshot_seqno": 4484766603} 2024/11/24-06:48:42.934224 139957290698304 (Original Log Time 2024/11/24-06:48:42.932620) [compaction_job.cc:2022] [default] [JOB 43019] Compacted 1@2 + 27@3 files to L3 => 915525832 bytes 2024/11/24-06:48:42.934225 139957290698304 (Original Log Time 2024/11/24-06:48:42.934143) [compaction_job.cc:1224] [default] compacted to: files[0 0 0 26 0 0 0] max score 0.03, MB/sec: 11.4 rd, 11.1 wr, level 3, files in(1, 27) out(26 +0 blob) MB in(27.1, 872.0 +0.0 blob) out(873.1 +0.0 blob), read-write-amplify(65.5) write-amplify(32.3) OK, records in: 23907953, records dropped: 95200 output_compression: Snappy 2024/11/24-06:48:42.934229 139957290698304 (Original Log Time 2024/11/24-06:48:42.934194) EVENT_LOG_v1 {"time_micros": 1732402122934168, "cf": "default", "job": 43019, "event": "compaction_finished", "compaction_time_micros": 82509123, "compaction_time_cpu_micros": 35466944, "output_level": 3, "num_output_files": 26, "total_output_size": 915525832, "num_input_records": 23907953, "num_output_records": 23812753, "num_subcompactions": 1, "output_compression": "Snappy", "num_single_delete_mismatches": 0, "num_single_delete_fallthrough": 0, "file_write_nanos": 625424446, "file_range_sync_nanos": 0, "file_fsync_nanos": 19309, "file_prepare_write_nanos": 62732, "lsm_state": [0, 0, 0, 26, 0, 0, 0]} 2024/11/24-06:48:43.065205 139957290698304 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":1732402040,"executesMs":82806,"compactionJobId":43019,"attempt":0,"compactionInputRawBytes":3461445582,"compactionInputZipBytes":942777182,"compactionOutputRawBytes":0,"compactionOutputZipBytes":915525832,"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-821d6be9d106bfa90d325c9c10da5457-cc799779853479f8-00"}}, response = 2024/11/24-06:48:43.065305 139957290698304 INFO dcompact_worker.cpp:1459: finish /worker/dcompact-log/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/2024-11-22T14.14.14/.rocksdb/job-43019/att-00: olev 3, work 82.806 s, result 7.776 ms, install 1.623 ms, input{raw 3.224 GiB zip 899.102 MiB}