2024/11/24-07:47:19.903266 139957231949376 DEBG dcompact_worker.cpp:2214: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00: fork to child time = 0.008686 sec 2024/11/24-07:47:19.904082 139957231949376 DEBG dcompact_worker.cpp:1013: Beg SerDeRead: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00 2024/11/24-07:47:19.910477 139957231949376 DEBG dcompact_worker.cpp:1033: End SerDeRead: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00 2024/11/24-07:47:19.911409 139957231949376 TRAC dcompact_worker.cpp:1083: INFO_LOG_LEVEL: rpc = INFO_LEVEL, env_var = undefined 2024/11/24-07:47:19.911665 139957231949376 [WARN] [column_family.cc:386] multiple cf_paths/db_paths and level_compaction_dynamic_level_bytes can't be used together 2024/11/24-07:47:19.975451 139957231949376 [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-43598/att-00/MANIFEST-206347 2024/11/24-07:47:20.001949 139957231949376 [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-43598/att-00/MANIFEST-206347 succeeded,manifest_file_number is 206347, next_file_number is 296716, last_sequence is 4502483751, log_number is 0,prev_log_number is 0,max_column_family is 0,min_log_number_to_keep is 296614 2024/11/24-07:47:20.001957 139957231949376 [version_set.cc:6266] Column family [default] (ID 0), log number is 0 2024/11/24-07:47:20.002097 139957231949376 [version_set.cc:5721] Creating manifest 296716 2024/11/24-07:47:20.037936 139957231949376 DEBG dcompact_worker.cpp:1218: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00: bottommost_level: fake = 1, rpc = 0 2024/11/24-07:47:20.059117 139957231949376 [compaction_job.cc:2437] [default] [JOB 43598] Compacting 1@2 + 28@3 files to L3, score 0.71, subcompactions 1 : 1 2024/11/24-07:47:20.059140 139957231949376 [compaction_job.cc:2445] [default]: Compaction start summary: Base version 32682 Base level 2, inputs: [296708(27MB)], [296664(35MB) 296665(30MB) 296666(30MB) 296667(35MB) 296668(33MB) 296669(30MB) 296670(21MB) 296627(33MB) 296628(32MB) 296629(35MB) 296630(33MB) 296631(32MB) 296632(34MB) 296633(33MB) 296634(34MB) 296635(33MB) 296636(33MB) 296637(35MB) 296638(33MB) 296639(32MB) 296640(34MB) 296641(33MB) 296642(34MB) 296643(33MB) 296644(33MB) 296645(35MB) 296646(33MB) 296647(32MB)] 2024/11/24-07:47:20.065967 139957231949376 [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-07:47:20.066002 139957231949376 [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-07:47:20.066019 139957231949376 [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-07:47:20.066024 139957231949376 [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-07:47:20.066036 139957231949376 [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-07:47:20.698973 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296717.sst) /dev/shm/ToplingTemp/Topling-300400-aMPJS0 2024/11/24-07:47:21.543664 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296717.sst): first pass time = 0.84's, 158.908'MB/sec 2024/11/24-07:47:24.218842 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296717.sst): old prealloc_size = 147639500, real_size = 32862224 2024/11/24-07:47:24.219380 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296717.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 923032 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.0309 GB avg-val = 117.41 avg-zval = 33.44 2024/11/24-07:47:24.220177 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296717.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-07:47:25.057210 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296717.sst): second pass time = 2.67's, 40.523'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.84's, 44.080'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3377.420'MB/sec (index lex order gen) rebuild zvType time = 0.71's, 0.324'MB/sec write SST data time = 0.13's, 293.811'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 = 32717.135'MB/sec zip my value time = 2.67's, unzip length = 0.108'GB zip my value throughput = 40.523'MB/sec zip pipeline throughput = 95.784'MB/sec entries = 923032 avg-key = 28.00 avg-zkey = 1.91 avg-val = 117.41 avg-zval = 33.44 usrkeys = 923032 avg-key = 20.00 avg-zkey = 1.91 avg-val = 124.41 avg-zval = 33.44 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 923032 bytes = 3230624 } seq expand size = 6461224 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.0309 GB dict = 1.08 MB all = 0.0370 GB } UnZip/Zip{ index = 10.4453 value = 3.5113 dict = 1.00 all = 3.6320 } Zip/UnZip{ index = 0.0957 value = 0.2848 dict = 1.00 all = 0.2753 } ---------------------------- total value len = 2251.440407 GB avg = 0.200 KB (by entry num) total key len = 306.908807 GB avg = 0.027 KB total ukey len = 237.373188 GB avg = 0.015 KB total ukey num = 15.739584195 Billion total entry num = 11.280898143 Billion write speed all = 31.073252607 MB/sec (with seq num) write speed all = 29.977126415 MB/sec (without seq num) 2024/11/24-07:47:25.103616 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296717: 923032 keys, 36954242 bytes, temperature: kWarm 2024/11/24-07:47:25.103719 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405645103652, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296717, "file_size": 36954242, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4265679834, "largest_seqno": 4502436796, "table_properties": {"data_size": 30863936, "index_size": 1767360, "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": 25844896, "raw_average_key_size": 28, "raw_value_size": 108372864, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 923032, "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": 1732405640, "oldest_key_time": 0, "file_creation_time": 1732405640, "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": 296717, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:47:25.139368 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296718.sst) /dev/shm/ToplingTemp/Topling-300400-fyT2Y2 2024/11/24-07:47:26.137627 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296718.sst): first pass time = 1.00's, 134.457'MB/sec 2024/11/24-07:47:27.416833 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296718.sst): old prealloc_size = 147639500, real_size = 28105696 2024/11/24-07:47:27.417427 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296718.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 943598 prefix = 4 raw-key = 0.0151 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.93 raw-val = 0.1078 GB zip-val = 0.0261 GB avg-val = 114.24 avg-zval = 27.61 2024/11/24-07:47:27.418389 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296718.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-07:47:28.501199 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296718.sst): second pass time = 1.28's, 84.341'MB/sec, value only(80.3% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.08's, 29.742'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3183.667'MB/sec (index lex order gen) rebuild zvType time = 0.93's, 0.254'MB/sec write SST data time = 0.15's, 210.381'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 = 39518.302'MB/sec zip my value time = 1.28's, unzip length = 0.108'GB zip my value throughput = 84.341'MB/sec zip pipeline throughput = 84.341'MB/sec entries = 943598 avg-key = 28.00 avg-zkey = 1.93 avg-val = 114.24 avg-zval = 27.61 usrkeys = 943598 avg-key = 20.00 avg-zkey = 1.93 avg-val = 121.24 avg-zval = 27.61 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 943598 bytes = 3302608 } seq expand size = 6605186 multi value expand size = 0 cnt WriteAppend = 12 UnZipSize{ index = 0.0189 GB value = 0.1078 GB dict = 1.07 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0261 GB dict = 1.07 MB all = 0.0323 GB } UnZip/Zip{ index = 10.3760 value = 4.1380 dict = 1.00 all = 4.1617 } Zip/UnZip{ index = 0.0964 value = 0.2417 dict = 1.00 all = 0.2403 } ---------------------------- total value len = 2251.554810 GB avg = 0.200 KB (by entry num) total key len = 306.935228 GB avg = 0.027 KB total ukey len = 237.392060 GB avg = 0.015 KB total ukey num = 15.740527793 Billion total entry num = 11.281841741 Billion write speed all = 31.073663202 MB/sec (with seq num) write speed all = 29.977491177 MB/sec (without seq num) 2024/11/24-07:47:28.549157 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296718: 943598 keys, 32250626 bytes, temperature: kWarm 2024/11/24-07:47:28.549226 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405648549190, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296718, "file_size": 32250626, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4265680463, "largest_seqno": 4502434760, "table_properties": {"data_size": 26050768, "index_size": 1818816, "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": 26420744, "raw_average_key_size": 28, "raw_value_size": 107797100, "raw_average_value_size": 114, "num_data_blocks": 1, "num_entries": 943598, "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": 1732405645, "oldest_key_time": 0, "file_creation_time": 1732405645, "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": 296718, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:47:28.586514 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296719.sst) /dev/shm/ToplingTemp/Topling-300400-QmehR1 2024/11/24-07:47:29.636830 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296719.sst): first pass time = 1.05's, 127.793'MB/sec 2024/11/24-07:47:31.234899 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296719.sst): old prealloc_size = 147639500, real_size = 27805440 2024/11/24-07:47:31.235518 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296719.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.0258 GB avg-val = 114.00 avg-zval = 27.25 2024/11/24-07:47:31.236327 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296719.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-07:47:32.235452 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296719.sst): second pass time = 1.60's, 67.481'MB/sec, value only(80.3% of KV) wait indexing time = 0.00's, remap KeyValue time = 1.00's, 31.819'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3026.326'MB/sec (index lex order gen) rebuild zvType time = 0.87's, 0.273'MB/sec write SST data time = 0.13's, 237.843'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 = 34587.530'MB/sec zip my value time = 1.60's, unzip length = 0.108'GB zip my value throughput = 67.481'MB/sec zip pipeline throughput = 67.481'MB/sec entries = 945196 avg-key = 28.00 avg-zkey = 1.91 avg-val = 114.00 avg-zval = 27.25 usrkeys = 945196 avg-key = 20.00 avg-zkey = 1.91 avg-val = 121.00 avg-zval = 27.25 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.0258 GB dict = 1.07 MB all = 0.0318 GB } UnZip/Zip{ index = 10.4457 value = 4.1831 dict = 1.00 all = 4.2158 } Zip/UnZip{ index = 0.0957 value = 0.2391 dict = 1.00 all = 0.2372 } ---------------------------- total value len = 2251.669178 GB avg = 0.200 KB (by entry num) total key len = 306.961694 GB avg = 0.027 KB total ukey len = 237.410964 GB avg = 0.015 KB total ukey num = 15.741472989 Billion total entry num = 11.282786937 Billion write speed all = 31.073964358 MB/sec (with seq num) write speed all = 29.977750213 MB/sec (without seq num) 2024/11/24-07:47:32.282946 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296719: 945196 keys, 31836656 bytes, temperature: kWarm 2024/11/24-07:47:32.283008 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405652282966, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296719, "file_size": 31836656, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4359200313, "largest_seqno": 4462878092, "table_properties": {"data_size": 25759216, "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": 1732405648, "oldest_key_time": 0, "file_creation_time": 1732405648, "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": 296719, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:47:32.319629 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296720.sst) /dev/shm/ToplingTemp/Topling-300400-oBsdN4 2024/11/24-07:47:33.469014 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296720.sst): first pass time = 1.15's, 116.777'MB/sec 2024/11/24-07:47:34.871511 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296720.sst): old prealloc_size = 147639500, real_size = 33094032 2024/11/24-07:47:34.872061 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296720.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 928983 prefix = 4 raw-key = 0.0149 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.1082 GB zip-val = 0.0311 GB avg-val = 116.48 avg-zval = 33.47 2024/11/24-07:47:34.872834 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296720.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-07:47:35.739999 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296720.sst): second pass time = 1.40's, 77.193'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.87's, 42.833'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3331.471'MB/sec (index lex order gen) rebuild zvType time = 0.74's, 0.314'MB/sec write SST data time = 0.13's, 289.630'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 = 32072.337'MB/sec zip my value time = 1.40's, unzip length = 0.108'GB zip my value throughput = 77.193'MB/sec zip pipeline throughput = 77.193'MB/sec entries = 928983 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.48 avg-zval = 33.47 usrkeys = 928983 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.48 avg-zval = 33.47 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 928983 bytes = 3251456 } seq expand size = 6502881 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.0311 GB dict = 1.08 MB all = 0.0372 GB } UnZip/Zip{ index = 10.5115 value = 3.4800 dict = 1.00 all = 3.6082 } Zip/UnZip{ index = 0.0951 value = 0.2874 dict = 1.00 all = 0.2771 } ---------------------------- total value len = 2251.783887 GB avg = 0.200 KB (by entry num) total key len = 306.987705 GB avg = 0.027 KB total ukey len = 237.429544 GB avg = 0.015 KB total ukey num = 15.742401972 Billion total entry num = 11.283715920 Billion write speed all = 31.074350805 MB/sec (with seq num) write speed all = 29.978093060 MB/sec (without seq num) 2024/11/24-07:47:35.785370 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296720: 928983 keys, 37198290 bytes, temperature: kWarm 2024/11/24-07:47:35.785429 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405655785398, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296720, "file_size": 37198290, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4265679848, "largest_seqno": 4502436755, "table_properties": {"data_size": 31094080, "index_size": 1767552, "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": 26011524, "raw_average_key_size": 28, "raw_value_size": 108206218, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 928983, "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": 1732405652, "oldest_key_time": 0, "file_creation_time": 1732405652, "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": 296720, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:47:35.835248 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296721.sst) /dev/shm/ToplingTemp/Topling-300400-TuUOp3 2024/11/24-07:47:36.994031 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296721.sst): first pass time = 1.16's, 115.832'MB/sec 2024/11/24-07:47:38.341579 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296721.sst): old prealloc_size = 147639500, real_size = 31308896 2024/11/24-07:47:38.342127 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296721.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 920284 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.0293 GB avg-val = 117.84 avg-zval = 31.86 2024/11/24-07:47:38.342902 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296721.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-07:47:39.158619 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296721.sst): second pass time = 1.35's, 80.543'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 43.314'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3360.052'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.333'MB/sec write SST data time = 0.13's, 280.287'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 = 34354.246'MB/sec zip my value time = 1.35's, unzip length = 0.108'GB zip my value throughput = 80.543'MB/sec zip pipeline throughput = 80.543'MB/sec entries = 920284 avg-key = 28.00 avg-zkey = 1.91 avg-val = 117.84 avg-zval = 31.86 usrkeys = 920284 avg-key = 20.00 avg-zkey = 1.91 avg-val = 124.84 avg-zval = 31.86 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 920284 bytes = 3221008 } seq expand size = 6441988 multi value expand size = 0 cnt WriteAppend = 12 UnZipSize{ index = 0.0184 GB value = 0.1084 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0293 GB dict = 1.08 MB all = 0.0354 GB } UnZip/Zip{ index = 10.4449 value = 3.6993 dict = 1.00 all = 3.7927 } Zip/UnZip{ index = 0.0957 value = 0.2703 dict = 1.00 all = 0.2637 } ---------------------------- total value len = 2251.898779 GB avg = 0.200 KB (by entry num) total key len = 307.013473 GB avg = 0.027 KB total ukey len = 237.447949 GB avg = 0.015 KB total ukey num = 15.743322256 Billion total entry num = 11.284636204 Billion write speed all = 31.074768887 MB/sec (with seq num) write speed all = 29.978467248 MB/sec (without seq num) 2024/11/24-07:47:39.202358 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296721: 920284 keys, 35388044 bytes, temperature: kWarm 2024/11/24-07:47:39.202427 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405659202391, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296721, "file_size": 35388044, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4353491484, "largest_seqno": 4502436186, "table_properties": {"data_size": 29316496, "index_size": 1762176, "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": 25767952, "raw_average_key_size": 28, "raw_value_size": 108449836, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 920284, "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": 1732405655, "oldest_key_time": 0, "file_creation_time": 1732405655, "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": 296721, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:47:39.235743 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296722.sst) /dev/shm/ToplingTemp/Topling-300400-EdGU72 2024/11/24-07:47:40.250496 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296722.sst): first pass time = 1.01's, 132.271'MB/sec 2024/11/24-07:47:41.521846 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296722.sst): old prealloc_size = 147639500, real_size = 27719280 2024/11/24-07:47:41.522436 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296722.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.16 2024/11/24-07:47:41.523224 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296722.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-07:47:42.373087 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296722.sst): second pass time = 1.27's, 84.802'MB/sec, value only(80.3% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.85's, 37.300'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3184.689'MB/sec (index lex order gen) rebuild zvType time = 0.72's, 0.327'MB/sec write SST data time = 0.13's, 248.379'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 = 35482.745'MB/sec zip my value time = 1.27's, unzip length = 0.108'GB zip my value throughput = 84.802'MB/sec zip pipeline throughput = 84.802'MB/sec entries = 945196 avg-key = 28.00 avg-zkey = 1.91 avg-val = 114.00 avg-zval = 27.16 usrkeys = 945196 avg-key = 20.00 avg-zkey = 1.91 avg-val = 121.00 avg-zval = 27.16 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.4454 value = 4.1971 dict = 1.00 all = 4.2273 } Zip/UnZip{ index = 0.0957 value = 0.2383 dict = 1.00 all = 0.2366 } ---------------------------- total value len = 2252.013148 GB avg = 0.200 KB (by entry num) total key len = 307.039939 GB avg = 0.027 KB total ukey len = 237.466853 GB avg = 0.015 KB total ukey num = 15.744267452 Billion total entry num = 11.285581400 Billion write speed all = 31.075266096 MB/sec (with seq num) write speed all = 29.978915428 MB/sec (without seq num) 2024/11/24-07:47:42.413228 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296722: 945196 keys, 31750512 bytes, temperature: kWarm 2024/11/24-07:47:42.413300 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405662413264, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296722, "file_size": 31750512, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4365935581, "largest_seqno": 4469535730, "table_properties": {"data_size": 25672992, "index_size": 1809792, "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": 1732405659, "oldest_key_time": 0, "file_creation_time": 1732405659, "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": 296722, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:47:42.451723 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296723.sst) /dev/shm/ToplingTemp/Topling-300400-V7IR02 2024/11/24-07:47:43.579791 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296723.sst): first pass time = 1.13's, 118.984'MB/sec 2024/11/24-07:47:44.932870 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296723.sst): old prealloc_size = 147639500, real_size = 32996768 2024/11/24-07:47:44.933428 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296723.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 927451 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.0310 GB avg-val = 116.72 avg-zval = 33.43 2024/11/24-07:47:44.934954 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296723.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-07:47:45.788064 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296723.sst): second pass time = 1.35's, 80.144'MB/sec, value only(80.7% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.86's, 43.380'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3296.986'MB/sec (index lex order gen) rebuild zvType time = 0.73's, 0.319'MB/sec write SST data time = 0.13's, 291.048'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 = 32989.859'MB/sec zip my value time = 1.35's, unzip length = 0.108'GB zip my value throughput = 80.144'MB/sec zip pipeline throughput = 80.144'MB/sec entries = 927451 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.72 avg-zval = 33.43 usrkeys = 927451 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.72 avg-zval = 33.43 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 927451 bytes = 3246096 } seq expand size = 6492157 multi value expand size = 0 cnt WriteAppend = 12 UnZipSize{ index = 0.0185 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.5140 value = 3.4919 dict = 1.00 all = 3.6180 } Zip/UnZip{ index = 0.0951 value = 0.2864 dict = 1.00 all = 0.2764 } ---------------------------- total value len = 2252.127889 GB avg = 0.200 KB (by entry num) total key len = 307.065907 GB avg = 0.027 KB total ukey len = 237.485402 GB avg = 0.015 KB total ukey num = 15.745194903 Billion total entry num = 11.286508851 Billion write speed all = 31.075686100 MB/sec (with seq num) write speed all = 29.979290800 MB/sec (without seq num) 2024/11/24-07:47:45.839377 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296723: 927451 keys, 37096936 bytes, temperature: kWarm 2024/11/24-07:47:45.839447 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405665839411, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296723, "file_size": 37096936, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4265679865, "largest_seqno": 4502436908, "table_properties": {"data_size": 31000528, "index_size": 1764224, "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": 25968628, "raw_average_key_size": 28, "raw_value_size": 108249222, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 927451, "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": 1732405662, "oldest_key_time": 0, "file_creation_time": 1732405662, "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": 296723, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:47:45.875035 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296724.sst) /dev/shm/ToplingTemp/Topling-300400-2Is763 2024/11/24-07:47:46.857797 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296724.sst): first pass time = 0.98's, 136.577'MB/sec 2024/11/24-07:47:48.180021 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296724.sst): old prealloc_size = 147639500, real_size = 31333296 2024/11/24-07:47:48.180594 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296724.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-07:47:48.181458 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296724.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-07:47:48.995424 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296724.sst): second pass time = 1.32's, 82.089'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 43.286'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3222.624'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.335'MB/sec write SST data time = 0.13's, 274.733'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 = 32376.761'MB/sec zip my value time = 1.32's, unzip length = 0.108'GB zip my value throughput = 82.089'MB/sec zip pipeline throughput = 82.089'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 = 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.0293 GB dict = 1.09 MB all = 0.0353 GB } UnZip/Zip{ index = 10.4443 value = 3.6969 dict = 1.00 all = 3.8027 } Zip/UnZip{ index = 0.0957 value = 0.2705 dict = 1.00 all = 0.2630 } ---------------------------- total value len = 2252.242802 GB avg = 0.200 KB (by entry num) total key len = 307.091648 GB avg = 0.027 KB total ukey len = 237.503788 GB avg = 0.015 KB total ukey num = 15.746114203 Billion total entry num = 11.287428151 Billion write speed all = 31.076183714 MB/sec (with seq num) write speed all = 29.979741814 MB/sec (without seq num) 2024/11/24-07:47:49.045028 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296724: 919300 keys, 35295154 bytes, temperature: kWarm 2024/11/24-07:47:49.045087 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405669045054, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296724, "file_size": 35295154, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4344009136, "largest_seqno": 4464343770, "table_properties": {"data_size": 29342880, "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": 1732405665, "oldest_key_time": 0, "file_creation_time": 1732405665, "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": 296724, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:47:49.083954 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296725.sst) /dev/shm/ToplingTemp/Topling-300400-MFlA12 2024/11/24-07:47:49.988009 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296725.sst): first pass time = 0.90's, 148.475'MB/sec 2024/11/24-07:47:51.267424 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296725.sst): old prealloc_size = 147639500, real_size = 29158896 2024/11/24-07:47:51.268018 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296725.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 937610 prefix = 4 raw-key = 0.0150 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.93 raw-val = 0.1080 GB zip-val = 0.0271 GB avg-val = 115.15 avg-zval = 28.92 2024/11/24-07:47:51.268767 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296725.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-07:47:52.092864 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296725.sst): second pass time = 1.28's, 84.439'MB/sec, value only(80.4% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.83's, 40.186'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3173.987'MB/sec (index lex order gen) rebuild zvType time = 0.70's, 0.337'MB/sec write SST data time = 0.13's, 256.658'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 = 32870.624'MB/sec zip my value time = 1.28's, unzip length = 0.108'GB zip my value throughput = 84.439'MB/sec zip pipeline throughput = 84.439'MB/sec entries = 937610 avg-key = 28.00 avg-zkey = 1.93 avg-val = 115.15 avg-zval = 28.92 usrkeys = 937610 avg-key = 20.00 avg-zkey = 1.93 avg-val = 122.15 avg-zval = 28.92 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 937610 bytes = 3164448 } seq expand size = 6563270 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0188 GB value = 0.1080 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0271 GB dict = 1.08 MB all = 0.0332 GB } UnZip/Zip{ index = 10.3755 value = 3.9814 dict = 1.00 all = 4.0464 } Zip/UnZip{ index = 0.0964 value = 0.2512 dict = 1.00 all = 0.2471 } ---------------------------- total value len = 2252.357330 GB avg = 0.200 KB (by entry num) total key len = 307.117901 GB avg = 0.027 KB total ukey len = 237.522540 GB avg = 0.015 KB total ukey num = 15.747051813 Billion total entry num = 11.288365761 Billion write speed all = 31.076724325 MB/sec (with seq num) write speed all = 29.980232586 MB/sec (without seq num) 2024/11/24-07:47:52.136536 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296725: 937610 keys, 33170014 bytes, temperature: kWarm 2024/11/24-07:47:52.136608 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405672136573, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296725, "file_size": 33170014, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4423804001, "largest_seqno": 4502436197, "table_properties": {"data_size": 27116960, "index_size": 1807360, "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": 26253080, "raw_average_key_size": 28, "raw_value_size": 107964764, "raw_average_value_size": 115, "num_data_blocks": 1, "num_entries": 937610, "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": 1732405669, "oldest_key_time": 0, "file_creation_time": 1732405669, "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": 296725, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:47:52.176845 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296726.sst) /dev/shm/ToplingTemp/Topling-300400-cMRb60 2024/11/24-07:47:53.173504 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296726.sst): first pass time = 1.00's, 134.675'MB/sec 2024/11/24-07:47:54.492107 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296726.sst): old prealloc_size = 147639500, real_size = 31838992 2024/11/24-07:47:54.492634 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296726.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 920483 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.81 avg-zval = 32.44 2024/11/24-07:47:54.494645 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296726.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-07:47:55.309313 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296726.sst): second pass time = 1.32's, 82.314'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 43.957'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3477.435'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.335'MB/sec write SST data time = 0.13's, 278.359'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 = 29375.979'MB/sec zip my value time = 1.32's, unzip length = 0.108'GB zip my value throughput = 82.314'MB/sec zip pipeline throughput = 82.314'MB/sec entries = 920483 avg-key = 28.00 avg-zkey = 1.90 avg-val = 117.81 avg-zval = 32.44 usrkeys = 920483 avg-key = 20.00 avg-zkey = 1.90 avg-val = 124.81 avg-zval = 32.44 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 920483 bytes = 3221712 } seq expand size = 6443381 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.0359 GB } UnZip/Zip{ index = 10.5132 value = 3.6320 dict = 1.00 all = 3.7365 } Zip/UnZip{ index = 0.0951 value = 0.2753 dict = 1.00 all = 0.2676 } ---------------------------- total value len = 2252.472218 GB avg = 0.200 KB (by entry num) total key len = 307.143674 GB avg = 0.027 KB total ukey len = 237.540950 GB avg = 0.015 KB total ukey num = 15.747972296 Billion total entry num = 11.289286244 Billion write speed all = 31.077218532 MB/sec (with seq num) write speed all = 29.980680206 MB/sec (without seq num) 2024/11/24-07:47:55.355023 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296726: 920483 keys, 35920670 bytes, temperature: kWarm 2024/11/24-07:47:55.355091 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405675355056, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296726, "file_size": 35920670, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4265679880, "largest_seqno": 4502432879, "table_properties": {"data_size": 29857600, "index_size": 1751104, "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": 25773524, "raw_average_key_size": 28, "raw_value_size": 108444282, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 920483, "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": 1732405672, "oldest_key_time": 0, "file_creation_time": 1732405672, "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": 296726, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:47:55.392115 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296727.sst) /dev/shm/ToplingTemp/Topling-300400-i7dWh2 2024/11/24-07:47:56.216695 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296727.sst): first pass time = 0.82's, 162.778'MB/sec 2024/11/24-07:47:57.533565 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296727.sst): old prealloc_size = 147639500, real_size = 31304832 2024/11/24-07:47:57.534160 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296727.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.89 2024/11/24-07:47:57.534942 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296727.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-07:47:58.361277 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296727.sst): second pass time = 1.32's, 82.490'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.83's, 42.609'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3101.476'MB/sec (index lex order gen) rebuild zvType time = 0.70's, 0.331'MB/sec write SST data time = 0.13's, 267.432'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 = 33031.235'MB/sec zip my value time = 1.32's, unzip length = 0.108'GB zip my value throughput = 82.490'MB/sec zip pipeline throughput = 82.490'MB/sec entries = 919300 avg-key = 28.00 avg-zkey = 1.91 avg-val = 118.00 avg-zval = 31.89 usrkeys = 919300 avg-key = 20.00 avg-zkey = 1.91 avg-val = 125.00 avg-zval = 31.89 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.0293 GB dict = 1.09 MB all = 0.0353 GB } UnZip/Zip{ index = 10.4458 value = 3.7004 dict = 1.00 all = 3.8058 } Zip/UnZip{ index = 0.0957 value = 0.2702 dict = 1.00 all = 0.2628 } ---------------------------- total value len = 2252.587130 GB avg = 0.200 KB (by entry num) total key len = 307.169415 GB avg = 0.027 KB total ukey len = 237.559336 GB avg = 0.015 KB total ukey num = 15.748891596 Billion total entry num = 11.290205544 Billion write speed all = 31.077774664 MB/sec (with seq num) write speed all = 29.981187680 MB/sec (without seq num) 2024/11/24-07:47:58.407518 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296727: 919300 keys, 35266674 bytes, temperature: kWarm 2024/11/24-07:47:58.407592 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405678407556, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296727, "file_size": 35266674, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4369547611, "largest_seqno": 4483056858, "table_properties": {"data_size": 29314672, "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": 1732405675, "oldest_key_time": 0, "file_creation_time": 1732405675, "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": 296727, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:47:58.447950 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296728.sst) /dev/shm/ToplingTemp/Topling-300400-poEU93 2024/11/24-07:47:59.308423 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296728.sst): first pass time = 0.86's, 155.996'MB/sec 2024/11/24-07:48:00.648217 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296728.sst): old prealloc_size = 147639500, real_size = 31922400 2024/11/24-07:48:00.648781 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296728.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 934050 prefix = 4 raw-key = 0.0149 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.1081 GB zip-val = 0.0299 GB avg-val = 115.69 avg-zval = 32.02 2024/11/24-07:48:00.650856 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296728.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-07:48:01.498436 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296728.sst): second pass time = 1.34's, 80.705'MB/sec, value only(80.5% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.85's, 42.393'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3288.093'MB/sec (index lex order gen) rebuild zvType time = 0.72's, 0.325'MB/sec write SST data time = 0.13's, 275.718'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 = 35068.362'MB/sec zip my value time = 1.34's, unzip length = 0.108'GB zip my value throughput = 80.705'MB/sec zip pipeline throughput = 80.705'MB/sec entries = 934050 avg-key = 28.00 avg-zkey = 1.90 avg-val = 115.69 avg-zval = 32.02 usrkeys = 934050 avg-key = 20.00 avg-zkey = 1.90 avg-val = 122.69 avg-zval = 32.02 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 934050 bytes = 3269184 } seq expand size = 6538350 multi value expand size = 0 cnt WriteAppend = 12 UnZipSize{ index = 0.0187 GB value = 0.1081 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.6128 dict = 1.00 all = 3.7239 } Zip/UnZip{ index = 0.0951 value = 0.2768 dict = 1.00 all = 0.2685 } ---------------------------- total value len = 2252.701733 GB avg = 0.200 KB (by entry num) total key len = 307.195568 GB avg = 0.027 KB total ukey len = 237.578017 GB avg = 0.015 KB total ukey num = 15.749825646 Billion total entry num = 11.291139594 Billion write speed all = 31.078299863 MB/sec (with seq num) write speed all = 29.981663925 MB/sec (without seq num) 2024/11/24-07:48:01.545548 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296728: 934050 keys, 36042266 bytes, temperature: kWarm 2024/11/24-07:48:01.545618 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405681545582, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296728, "file_size": 36042266, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4265679891, "largest_seqno": 4502437142, "table_properties": {"data_size": 29911568, "index_size": 1777152, "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": 26153400, "raw_average_key_size": 28, "raw_value_size": 108064436, "raw_average_value_size": 115, "num_data_blocks": 1, "num_entries": 934050, "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": 1732405678, "oldest_key_time": 0, "file_creation_time": 1732405678, "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": 296728, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:48:01.586214 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296729.sst) /dev/shm/ToplingTemp/Topling-300400-SRz390 2024/11/24-07:48:02.580948 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296729.sst): first pass time = 0.99's, 134.936'MB/sec 2024/11/24-07:48:03.864605 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296729.sst): old prealloc_size = 147639500, real_size = 31441600 2024/11/24-07:48:03.865186 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296729.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-07:48:03.865936 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296729.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-07:48:04.681284 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296729.sst): second pass time = 1.28's, 84.561'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 43.353'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3150.809'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.334'MB/sec write SST data time = 0.13's, 277.639'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 = 31917.691'MB/sec zip my value time = 1.28's, unzip length = 0.108'GB zip my value throughput = 84.561'MB/sec zip pipeline throughput = 84.561'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 = 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.0295 GB dict = 1.09 MB all = 0.0354 GB } UnZip/Zip{ index = 10.4462 value = 3.6833 dict = 1.00 all = 3.7911 } Zip/UnZip{ index = 0.0957 value = 0.2715 dict = 1.00 all = 0.2638 } ---------------------------- total value len = 2252.816645 GB avg = 0.200 KB (by entry num) total key len = 307.221308 GB avg = 0.027 KB total ukey len = 237.596403 GB avg = 0.015 KB total ukey num = 15.750744946 Billion total entry num = 11.292058894 Billion write speed all = 31.078806534 MB/sec (with seq num) write speed all = 29.982123688 MB/sec (without seq num) 2024/11/24-07:48:04.726641 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296729: 919300 keys, 35403442 bytes, temperature: kWarm 2024/11/24-07:48:04.726718 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405684726676, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296729, "file_size": 35403442, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4293424766, "largest_seqno": 4403215264, "table_properties": {"data_size": 29451504, "index_size": 1760064, "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": 1732405681, "oldest_key_time": 0, "file_creation_time": 1732405681, "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": 296729, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:48:04.770326 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296730.sst) /dev/shm/ToplingTemp/Topling-300400-0CEDo1 2024/11/24-07:48:05.774667 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296730.sst): first pass time = 1.00's, 133.643'MB/sec 2024/11/24-07:48:07.069161 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296730.sst): old prealloc_size = 147639500, real_size = 31154304 2024/11/24-07:48:07.069713 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296730.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 922530 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.0292 GB avg-val = 117.49 avg-zval = 31.61 2024/11/24-07:48:07.070607 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296730.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-07:48:07.880406 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296730.sst): second pass time = 1.29's, 83.809'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.81's, 43.298'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3323.426'MB/sec (index lex order gen) rebuild zvType time = 0.68's, 0.337'MB/sec write SST data time = 0.13's, 276.102'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 = 34887.214'MB/sec zip my value time = 1.29's, unzip length = 0.108'GB zip my value throughput = 83.809'MB/sec zip pipeline throughput = 83.809'MB/sec entries = 922530 avg-key = 28.00 avg-zkey = 1.91 avg-val = 117.49 avg-zval = 31.61 usrkeys = 922530 avg-key = 20.00 avg-zkey = 1.91 avg-val = 124.49 avg-zval = 31.61 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 922530 bytes = 3113552 } seq expand size = 6457710 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.0292 GB dict = 1.08 MB all = 0.0351 GB } UnZip/Zip{ index = 10.4449 value = 3.7174 dict = 1.00 all = 3.8212 } Zip/UnZip{ index = 0.0957 value = 0.2690 dict = 1.00 all = 0.2617 } ---------------------------- total value len = 2252.931490 GB avg = 0.199 KB (by entry num) total key len = 307.247139 GB avg = 0.027 KB total ukey len = 237.614854 GB avg = 0.015 KB total ukey num = 15.751667476 Billion total entry num = 11.292981424 Billion write speed all = 31.079307292 MB/sec (with seq num) write speed all = 29.982577444 MB/sec (without seq num) 2024/11/24-07:48:07.924317 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296730: 922530 keys, 35124480 bytes, temperature: kWarm 2024/11/24-07:48:07.924386 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405687924352, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296730, "file_size": 35124480, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4403215265, "largest_seqno": 4502436228, "table_properties": {"data_size": 29157040, "index_size": 1766464, "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": 25830840, "raw_average_key_size": 28, "raw_value_size": 108387028, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 922530, "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": 1732405684, "oldest_key_time": 0, "file_creation_time": 1732405684, "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": 296730, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:48:07.965779 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296731.sst) /dev/shm/ToplingTemp/Topling-300400-cIihY3 2024/11/24-07:48:08.963194 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296731.sst): first pass time = 1.00's, 134.571'MB/sec 2024/11/24-07:48:10.299877 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296731.sst): old prealloc_size = 147639500, real_size = 32857728 2024/11/24-07:48:10.300468 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296731.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 929671 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.0309 GB avg-val = 116.37 avg-zval = 33.19 2024/11/24-07:48:10.302443 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296731.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-07:48:11.159553 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296731.sst): second pass time = 1.34's, 80.984'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.86's, 42.999'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3117.639'MB/sec (index lex order gen) rebuild zvType time = 0.73's, 0.318'MB/sec write SST data time = 0.13's, 287.759'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 = 31988.616'MB/sec zip my value time = 1.34's, unzip length = 0.108'GB zip my value throughput = 80.984'MB/sec zip pipeline throughput = 80.984'MB/sec entries = 929671 avg-key = 28.00 avg-zkey = 1.90 avg-val = 116.37 avg-zval = 33.19 usrkeys = 929671 avg-key = 20.00 avg-zkey = 1.90 avg-val = 123.37 avg-zval = 33.19 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 929671 bytes = 3253856 } seq expand size = 6507697 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.0309 GB dict = 1.08 MB all = 0.0370 GB } UnZip/Zip{ index = 10.5128 value = 3.5061 dict = 1.00 all = 3.6310 } Zip/UnZip{ index = 0.0951 value = 0.2852 dict = 1.00 all = 0.2754 } ---------------------------- total value len = 2253.046185 GB avg = 0.199 KB (by entry num) total key len = 307.273170 GB avg = 0.027 KB total ukey len = 237.633447 GB avg = 0.015 KB total ukey num = 15.752597147 Billion total entry num = 11.293911095 Billion write speed all = 31.079778431 MB/sec (with seq num) write speed all = 29.983001957 MB/sec (without seq num) 2024/11/24-07:48:11.206054 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296731: 929671 keys, 36964016 bytes, temperature: kWarm 2024/11/24-07:48:11.206125 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405691206089, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296731, "file_size": 36964016, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4265679902, "largest_seqno": 4502437034, "table_properties": {"data_size": 30856496, "index_size": 1768640, "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": 26030788, "raw_average_key_size": 28, "raw_value_size": 108186954, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 929671, "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": 1732405687, "oldest_key_time": 0, "file_creation_time": 1732405687, "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": 296731, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:48:11.243295 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296732.sst) /dev/shm/ToplingTemp/Topling-300400-BXL213 2024/11/24-07:48:12.242287 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296732.sst): first pass time = 1.00's, 134.359'MB/sec 2024/11/24-07:48:13.512917 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296732.sst): old prealloc_size = 147639500, real_size = 31276592 2024/11/24-07:48:13.513462 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296732.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.86 2024/11/24-07:48:13.515380 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296732.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-07:48:14.323615 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296732.sst): second pass time = 1.27's, 85.428'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.81's, 43.468'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3379.357'MB/sec (index lex order gen) rebuild zvType time = 0.68's, 0.337'MB/sec write SST data time = 0.13's, 274.401'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 = 32751.064'MB/sec zip my value time = 1.27's, unzip length = 0.108'GB zip my value throughput = 85.428'MB/sec zip pipeline throughput = 85.428'MB/sec entries = 919300 avg-key = 28.00 avg-zkey = 1.91 avg-val = 118.00 avg-zval = 31.86 usrkeys = 919300 avg-key = 20.00 avg-zkey = 1.91 avg-val = 125.00 avg-zval = 31.86 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 919300 bytes = 3102656 } 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.0293 GB dict = 1.09 MB all = 0.0352 GB } UnZip/Zip{ index = 10.4455 value = 3.7040 dict = 1.00 all = 3.8088 } Zip/UnZip{ index = 0.0957 value = 0.2700 dict = 1.00 all = 0.2625 } ---------------------------- total value len = 2253.161097 GB avg = 0.199 KB (by entry num) total key len = 307.298910 GB avg = 0.027 KB total ukey len = 237.651833 GB avg = 0.015 KB total ukey num = 15.753516447 Billion total entry num = 11.294830395 Billion write speed all = 31.080292066 MB/sec (with seq num) write speed all = 29.983468444 MB/sec (without seq num) 2024/11/24-07:48:14.366968 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296732: 919300 keys, 35238450 bytes, temperature: kWarm 2024/11/24-07:48:14.367048 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405694367012, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296732, "file_size": 35238450, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4329577771, "largest_seqno": 4440840197, "table_properties": {"data_size": 29286368, "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": 1732405691, "oldest_key_time": 0, "file_creation_time": 1732405691, "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": 296732, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:48:14.403156 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296733.sst) /dev/shm/ToplingTemp/Topling-300400-Lmxpk3 2024/11/24-07:48:15.309367 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296733.sst): first pass time = 0.91's, 148.116'MB/sec 2024/11/24-07:48:16.584600 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296733.sst): old prealloc_size = 147639500, real_size = 30066096 2024/11/24-07:48:16.585198 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296733.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 931156 prefix = 4 raw-key = 0.0149 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.91 raw-val = 0.1081 GB zip-val = 0.0281 GB avg-val = 116.14 avg-zval = 30.12 2024/11/24-07:48:16.585927 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296733.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-07:48:17.396459 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296733.sst): second pass time = 1.27's, 84.879'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.81's, 41.809'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3088.396'MB/sec (index lex order gen) rebuild zvType time = 0.68's, 0.340'MB/sec write SST data time = 0.13's, 268.569'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 = 30085.644'MB/sec zip my value time = 1.27's, unzip length = 0.108'GB zip my value throughput = 84.879'MB/sec zip pipeline throughput = 84.879'MB/sec entries = 931156 avg-key = 28.00 avg-zkey = 1.91 avg-val = 116.14 avg-zval = 30.12 usrkeys = 931156 avg-key = 20.00 avg-zkey = 1.91 avg-val = 123.14 avg-zval = 30.12 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 931156 bytes = 3026272 } seq expand size = 6518092 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0186 GB value = 0.1081 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0281 GB dict = 1.08 MB all = 0.0339 GB } UnZip/Zip{ index = 10.4483 value = 3.8554 dict = 1.00 all = 3.9543 } Zip/UnZip{ index = 0.0957 value = 0.2594 dict = 1.00 all = 0.2529 } ---------------------------- total value len = 2253.275761 GB avg = 0.199 KB (by entry num) total key len = 307.324983 GB avg = 0.027 KB total ukey len = 237.670456 GB avg = 0.015 KB total ukey num = 15.754447603 Billion total entry num = 11.295761551 Billion write speed all = 31.080841087 MB/sec (with seq num) write speed all = 29.983967955 MB/sec (without seq num) 2024/11/24-07:48:17.439127 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296733: 931156 keys, 33942018 bytes, temperature: kWarm 2024/11/24-07:48:17.439196 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405697439160, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296733, "file_size": 33942018, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4440840198, "largest_seqno": 4502436248, "table_properties": {"data_size": 28050720, "index_size": 1782400, "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": 26072368, "raw_average_key_size": 28, "raw_value_size": 108145472, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 931156, "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": 1732405694, "oldest_key_time": 0, "file_creation_time": 1732405694, "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": 296733, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:48:17.475129 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296734.sst) /dev/shm/ToplingTemp/Topling-300400-cjbyD2 2024/11/24-07:48:18.450634 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296734.sst): first pass time = 0.98's, 137.592'MB/sec 2024/11/24-07:48:19.779280 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296734.sst): old prealloc_size = 147639500, real_size = 31933792 2024/11/24-07:48:19.779832 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296734.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 921033 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.0300 GB avg-val = 117.73 avg-zval = 32.52 2024/11/24-07:48:19.781840 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296734.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-07:48:20.594570 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296734.sst): second pass time = 1.33's, 81.656'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 44.178'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3322.580'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.335'MB/sec write SST data time = 0.13's, 283.945'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 = 26934.957'MB/sec zip my value time = 1.33's, unzip length = 0.108'GB zip my value throughput = 81.656'MB/sec zip pipeline throughput = 81.656'MB/sec entries = 921033 avg-key = 28.00 avg-zkey = 1.90 avg-val = 117.73 avg-zval = 32.52 usrkeys = 921033 avg-key = 20.00 avg-zkey = 1.90 avg-val = 124.73 avg-zval = 32.52 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 921033 bytes = 3223632 } seq expand size = 6447231 multi value expand size = 0 cnt WriteAppend = 12 UnZipSize{ index = 0.0184 GB value = 0.1084 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0300 GB dict = 1.08 MB all = 0.0360 GB } UnZip/Zip{ index = 10.5141 value = 3.6202 dict = 1.00 all = 3.7265 } Zip/UnZip{ index = 0.0951 value = 0.2762 dict = 1.00 all = 0.2683 } ---------------------------- total value len = 2253.390637 GB avg = 0.199 KB (by entry num) total key len = 307.350772 GB avg = 0.027 KB total ukey len = 237.688877 GB avg = 0.015 KB total ukey num = 15.755368636 Billion total entry num = 11.296682584 Billion write speed all = 31.081341948 MB/sec (with seq num) write speed all = 29.984421960 MB/sec (without seq num) 2024/11/24-07:48:20.638947 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296734: 921033 keys, 36016736 bytes, temperature: kWarm 2024/11/24-07:48:20.639031 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405700638994, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296734, "file_size": 36016736, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4265679921, "largest_seqno": 4502436812, "table_properties": {"data_size": 29951376, "index_size": 1752000, "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": 25788924, "raw_average_key_size": 28, "raw_value_size": 108428946, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 921033, "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": 1732405697, "oldest_key_time": 0, "file_creation_time": 1732405697, "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": 296734, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:48:20.676115 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296735.sst) /dev/shm/ToplingTemp/Topling-300400-O5Uoj0 2024/11/24-07:48:21.533505 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296735.sst): first pass time = 0.86's, 156.549'MB/sec 2024/11/24-07:48:22.822093 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296735.sst): old prealloc_size = 147639500, real_size = 31330912 2024/11/24-07:48:22.822602 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296735.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.0293 GB avg-val = 118.00 avg-zval = 31.92 2024/11/24-07:48:22.824551 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296735.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-07:48:23.640033 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296735.sst): second pass time = 1.29's, 84.244'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 43.151'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3624.444'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.334'MB/sec write SST data time = 0.13's, 272.903'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 = 36480.734'MB/sec zip my value time = 1.29's, unzip length = 0.108'GB zip my value throughput = 84.244'MB/sec zip pipeline throughput = 84.244'MB/sec entries = 919300 avg-key = 28.00 avg-zkey = 1.92 avg-val = 118.00 avg-zval = 31.92 usrkeys = 919300 avg-key = 20.00 avg-zkey = 1.92 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 = 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.0293 GB dict = 1.09 MB all = 0.0353 GB } UnZip/Zip{ index = 10.4436 value = 3.6972 dict = 1.00 all = 3.8030 } Zip/UnZip{ index = 0.0958 value = 0.2705 dict = 1.00 all = 0.2630 } ---------------------------- total value len = 2253.505549 GB avg = 0.199 KB (by entry num) total key len = 307.376512 GB avg = 0.027 KB total ukey len = 237.707263 GB avg = 0.015 KB total ukey num = 15.756287936 Billion total entry num = 11.297601884 Billion write speed all = 31.081900215 MB/sec (with seq num) write speed all = 29.984931512 MB/sec (without seq num) 2024/11/24-07:48:23.684090 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296735: 919300 keys, 35292722 bytes, temperature: kWarm 2024/11/24-07:48:23.684158 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405703684123, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296735, "file_size": 35292722, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4366026137, "largest_seqno": 4478717161, "table_properties": {"data_size": 29340368, "index_size": 1760512, "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": 1732405700, "oldest_key_time": 0, "file_creation_time": 1732405700, "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": 296735, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:48:23.722424 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296736.sst) /dev/shm/ToplingTemp/Topling-300400-I40Wg3 2024/11/24-07:48:24.726503 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296736.sst): first pass time = 1.00's, 133.677'MB/sec 2024/11/24-07:48:26.069223 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296736.sst): old prealloc_size = 147639500, real_size = 32075312 2024/11/24-07:48:26.069768 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296736.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 932875 prefix = 4 raw-key = 0.0149 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.90 raw-val = 0.1081 GB zip-val = 0.0301 GB avg-val = 115.88 avg-zval = 32.23 2024/11/24-07:48:26.070569 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296736.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-07:48:26.919522 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296736.sst): second pass time = 1.34's, 80.552'MB/sec, value only(80.5% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.85's, 42.564'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3416.045'MB/sec (index lex order gen) rebuild zvType time = 0.72's, 0.323'MB/sec write SST data time = 0.13's, 282.505'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 = 34991.430'MB/sec zip my value time = 1.34's, unzip length = 0.108'GB zip my value throughput = 80.552'MB/sec zip pipeline throughput = 80.552'MB/sec entries = 932875 avg-key = 28.00 avg-zkey = 1.90 avg-val = 115.88 avg-zval = 32.23 usrkeys = 932875 avg-key = 20.00 avg-zkey = 1.90 avg-val = 122.88 avg-zval = 32.23 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 932875 bytes = 3265072 } seq expand size = 6530125 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.0301 GB dict = 1.08 MB all = 0.0362 GB } UnZip/Zip{ index = 10.5118 value = 3.5952 dict = 1.00 all = 3.7086 } Zip/UnZip{ index = 0.0951 value = 0.2781 dict = 1.00 all = 0.2696 } ---------------------------- total value len = 2253.620177 GB avg = 0.199 KB (by entry num) total key len = 307.402633 GB avg = 0.027 KB total ukey len = 237.725920 GB avg = 0.015 KB total ukey num = 15.757220811 Billion total entry num = 11.298534759 Billion write speed all = 31.082371297 MB/sec (with seq num) write speed all = 29.985355679 MB/sec (without seq num) 2024/11/24-07:48:26.965198 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296736: 932875 keys, 36190922 bytes, temperature: kWarm 2024/11/24-07:48:26.965267 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405706965232, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296736, "file_size": 36190922, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4265679941, "largest_seqno": 4502436260, "table_properties": {"data_size": 30066976, "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": 26120500, "raw_average_key_size": 28, "raw_value_size": 108097350, "raw_average_value_size": 115, "num_data_blocks": 1, "num_entries": 932875, "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": 1732405703, "oldest_key_time": 0, "file_creation_time": 1732405703, "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": 296736, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:48:27.010811 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296737.sst) /dev/shm/ToplingTemp/Topling-300400-cwmTh1 2024/11/24-07:48:27.999620 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296737.sst): first pass time = 0.99's, 135.742'MB/sec 2024/11/24-07:48:29.278653 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296737.sst): old prealloc_size = 147639500, real_size = 31394416 2024/11/24-07:48:29.279199 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296737.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.99 2024/11/24-07:48:29.280071 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296737.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-07:48:30.096299 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296737.sst): second pass time = 1.28's, 84.865'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 43.243'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3429.963'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.333'MB/sec write SST data time = 0.13's, 278.524'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 = 27314.402'MB/sec zip my value time = 1.28's, unzip length = 0.108'GB zip my value throughput = 84.865'MB/sec zip pipeline throughput = 84.865'MB/sec entries = 919300 avg-key = 28.00 avg-zkey = 1.91 avg-val = 118.00 avg-zval = 31.99 usrkeys = 919300 avg-key = 20.00 avg-zkey = 1.91 avg-val = 125.00 avg-zval = 31.99 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.0354 GB } UnZip/Zip{ index = 10.4455 value = 3.6892 dict = 1.00 all = 3.7962 } Zip/UnZip{ index = 0.0957 value = 0.2711 dict = 1.00 all = 0.2634 } ---------------------------- total value len = 2253.735089 GB avg = 0.199 KB (by entry num) total key len = 307.428373 GB avg = 0.027 KB total ukey len = 237.744306 GB avg = 0.015 KB total ukey num = 15.758140111 Billion total entry num = 11.299454059 Billion write speed all = 31.082879941 MB/sec (with seq num) write speed all = 29.985817363 MB/sec (without seq num) 2024/11/24-07:48:30.139970 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296737: 919300 keys, 35356274 bytes, temperature: kWarm 2024/11/24-07:48:30.140048 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405710140012, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296737, "file_size": 35356274, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4293737382, "largest_seqno": 4403598314, "table_properties": {"data_size": 29404192, "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": 1732405706, "oldest_key_time": 0, "file_creation_time": 1732405706, "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": 296737, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:48:30.176169 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296738.sst) /dev/shm/ToplingTemp/Topling-300400-tr4M61 2024/11/24-07:48:31.094818 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296738.sst): first pass time = 0.92's, 146.110'MB/sec 2024/11/24-07:48:32.395901 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296738.sst): old prealloc_size = 147639500, real_size = 31209072 2024/11/24-07:48:32.396460 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296738.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 922581 prefix = 4 raw-key = 0.0148 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.93 raw-val = 0.1084 GB zip-val = 0.0292 GB avg-val = 117.48 avg-zval = 31.65 2024/11/24-07:48:32.397277 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296738.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-07:48:33.226247 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296738.sst): second pass time = 1.30's, 83.378'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.83's, 42.368'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3311.274'MB/sec (index lex order gen) rebuild zvType time = 0.70's, 0.329'MB/sec write SST data time = 0.13's, 273.558'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 = 27836.451'MB/sec zip my value time = 1.30's, unzip length = 0.108'GB zip my value throughput = 83.378'MB/sec zip pipeline throughput = 83.378'MB/sec entries = 922581 avg-key = 28.00 avg-zkey = 1.93 avg-val = 117.48 avg-zval = 31.65 usrkeys = 922581 avg-key = 20.00 avg-zkey = 1.93 avg-val = 124.48 avg-zval = 31.65 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 922581 bytes = 3113728 } seq expand size = 6458067 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.0292 GB dict = 1.08 MB all = 0.0352 GB } UnZip/Zip{ index = 10.3786 value = 3.7118 dict = 1.00 all = 3.8152 } Zip/UnZip{ index = 0.0964 value = 0.2694 dict = 1.00 all = 0.2621 } ---------------------------- total value len = 2253.849933 GB avg = 0.199 KB (by entry num) total key len = 307.454205 GB avg = 0.027 KB total ukey len = 237.762758 GB avg = 0.015 KB total ukey num = 15.759062692 Billion total entry num = 11.300376640 Billion write speed all = 31.083406486 MB/sec (with seq num) write speed all = 29.986296009 MB/sec (without seq num) 2024/11/24-07:48:33.269904 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296738: 922581 keys, 35179380 bytes, temperature: kWarm 2024/11/24-07:48:33.269984 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405713269937, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296738, "file_size": 35179380, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4403598315, "largest_seqno": 4502436270, "table_properties": {"data_size": 29200416, "index_size": 1777856, "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": 25832268, "raw_average_key_size": 28, "raw_value_size": 108385590, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 922581, "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": 1732405710, "oldest_key_time": 0, "file_creation_time": 1732405710, "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": 296738, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:48:33.305842 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296739.sst) /dev/shm/ToplingTemp/Topling-300400-lehrx4 2024/11/24-07:48:34.178811 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296739.sst): first pass time = 0.87's, 153.755'MB/sec 2024/11/24-07:48:35.521638 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296739.sst): old prealloc_size = 147639500, real_size = 32964048 2024/11/24-07:48:35.522219 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296739.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 929731 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.0310 GB avg-val = 116.36 avg-zval = 33.29 2024/11/24-07:48:35.523012 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296739.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-07:48:36.382413 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296739.sst): second pass time = 1.34's, 80.639'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.86's, 43.068'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3183.612'MB/sec (index lex order gen) rebuild zvType time = 0.73's, 0.317'MB/sec write SST data time = 0.13's, 289.660'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 = 34797.136'MB/sec zip my value time = 1.34's, unzip length = 0.108'GB zip my value throughput = 80.639'MB/sec zip pipeline throughput = 80.639'MB/sec entries = 929731 avg-key = 28.00 avg-zkey = 1.91 avg-val = 116.36 avg-zval = 33.29 usrkeys = 929731 avg-key = 20.00 avg-zkey = 1.91 avg-val = 123.36 avg-zval = 33.29 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 929731 bytes = 3254080 } seq expand size = 6508117 multi value expand size = 0 cnt WriteAppend = 14 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.4440 value = 3.4954 dict = 1.00 all = 3.6206 } Zip/UnZip{ index = 0.0957 value = 0.2861 dict = 1.00 all = 0.2762 } ---------------------------- total value len = 2253.964627 GB avg = 0.199 KB (by entry num) total key len = 307.480238 GB avg = 0.027 KB total ukey len = 237.781353 GB avg = 0.015 KB total ukey num = 15.759992423 Billion total entry num = 11.301306371 Billion write speed all = 31.083923714 MB/sec (with seq num) write speed all = 29.986764997 MB/sec (without seq num) 2024/11/24-07:48:36.429343 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296739: 929731 keys, 37070488 bytes, temperature: kWarm 2024/11/24-07:48:36.429414 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405716429379, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296739, "file_size": 37070488, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4265679961, "largest_seqno": 4502437223, "table_properties": {"data_size": 30951040, "index_size": 1780416, "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": 26032468, "raw_average_key_size": 28, "raw_value_size": 108185330, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 929731, "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": 1732405713, "oldest_key_time": 0, "file_creation_time": 1732405713, "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": 296739, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:48:36.467523 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296740.sst) /dev/shm/ToplingTemp/Topling-300400-TyvIj2 2024/11/24-07:48:37.458244 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296740.sst): first pass time = 0.99's, 135.480'MB/sec 2024/11/24-07:48:38.768597 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296740.sst): old prealloc_size = 147639500, real_size = 31404016 2024/11/24-07:48:38.769193 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296740.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-07:48:38.770071 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296740.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-07:48:39.591122 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296740.sst): second pass time = 1.31's, 82.861'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 42.998'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3069.079'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.331'MB/sec write SST data time = 0.13's, 274.955'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 = 36974.272'MB/sec zip my value time = 1.31's, unzip length = 0.108'GB zip my value throughput = 82.861'MB/sec zip pipeline throughput = 82.861'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 = 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.0354 GB } UnZip/Zip{ index = 10.4443 value = 3.6880 dict = 1.00 all = 3.7951 } Zip/UnZip{ index = 0.0957 value = 0.2711 dict = 1.00 all = 0.2635 } ---------------------------- total value len = 2254.079539 GB avg = 0.199 KB (by entry num) total key len = 307.505978 GB avg = 0.027 KB total ukey len = 237.799739 GB avg = 0.015 KB total ukey num = 15.760911723 Billion total entry num = 11.302225671 Billion write speed all = 31.084420193 MB/sec (with seq num) write speed all = 29.987214952 MB/sec (without seq num) 2024/11/24-07:48:39.634550 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296740: 919300 keys, 35365874 bytes, temperature: kWarm 2024/11/24-07:48:39.634620 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405719634583, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296740, "file_size": 35365874, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4329325663, "largest_seqno": 4440714407, "table_properties": {"data_size": 29413600, "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": 1732405716, "oldest_key_time": 0, "file_creation_time": 1732405716, "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": 296740, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:48:39.677362 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296741.sst) /dev/shm/ToplingTemp/Topling-300400-GSLp03 2024/11/24-07:48:40.710213 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296741.sst): first pass time = 1.03's, 129.954'MB/sec 2024/11/24-07:48:41.997809 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296741.sst): old prealloc_size = 147639500, real_size = 30199824 2024/11/24-07:48:41.998418 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296741.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 931145 prefix = 4 raw-key = 0.0149 GB zip-key = 0.0018 GB avg-key = 16.00 avg-zkey = 1.93 raw-val = 0.1081 GB zip-val = 0.0282 GB avg-val = 116.14 avg-zval = 30.26 2024/11/24-07:48:41.999191 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296741.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-07:48:42.825511 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296741.sst): second pass time = 1.29's, 84.041'MB/sec, value only(80.6% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.83's, 41.171'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3053.199'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.335'MB/sec write SST data time = 0.13's, 257.629'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 = 34596.157'MB/sec zip my value time = 1.29's, unzip length = 0.108'GB zip my value throughput = 84.041'MB/sec zip pipeline throughput = 84.041'MB/sec entries = 931145 avg-key = 28.00 avg-zkey = 1.93 avg-val = 116.14 avg-zval = 30.26 usrkeys = 931145 avg-key = 20.00 avg-zkey = 1.93 avg-val = 123.14 avg-zval = 30.26 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 931145 bytes = 3026240 } seq expand size = 6518015 multi value expand size = 0 cnt WriteAppend = 12 UnZipSize{ index = 0.0186 GB value = 0.1081 GB dict = 1.08 MB all = 0.1342 GB } __ZipSize{ index = 0.0018 GB value = 0.0282 GB dict = 1.08 MB all = 0.0341 GB } UnZip/Zip{ index = 10.3782 value = 3.8387 dict = 1.00 all = 3.9388 } Zip/UnZip{ index = 0.0964 value = 0.2605 dict = 1.00 all = 0.2539 } ---------------------------- total value len = 2254.194203 GB avg = 0.199 KB (by entry num) total key len = 307.532050 GB avg = 0.027 KB total ukey len = 237.818361 GB avg = 0.015 KB total ukey num = 15.761842868 Billion total entry num = 11.303156816 Billion write speed all = 31.084907956 MB/sec (with seq num) write speed all = 29.987655386 MB/sec (without seq num) 2024/11/24-07:48:42.867840 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296741: 931145 keys, 34075794 bytes, temperature: kWarm 2024/11/24-07:48:42.867910 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405722867875, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296741, "file_size": 34075794, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4440714408, "largest_seqno": 4502436281, "table_properties": {"data_size": 28172416, "index_size": 1794432, "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": 26072060, "raw_average_key_size": 28, "raw_value_size": 108145750, "raw_average_value_size": 116, "num_data_blocks": 1, "num_entries": 931145, "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": 1732405719, "oldest_key_time": 0, "file_creation_time": 1732405719, "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": 296741, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:48:42.905429 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296742.sst) /dev/shm/ToplingTemp/Topling-300400-Ev4390 2024/11/24-07:48:43.902895 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296742.sst): first pass time = 1.00's, 134.564'MB/sec 2024/11/24-07:48:45.213803 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296742.sst): old prealloc_size = 147639500, real_size = 32112640 2024/11/24-07:48:45.214408 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296742.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 921222 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.0301 GB avg-val = 117.70 avg-zval = 32.71 2024/11/24-07:48:45.215181 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296742.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-07:48:46.037106 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296742.sst): second pass time = 1.31's, 82.763'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 43.966'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3008.441'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.332'MB/sec write SST data time = 0.13's, 279.849'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 = 30909.687'MB/sec zip my value time = 1.31's, unzip length = 0.108'GB zip my value throughput = 82.763'MB/sec zip pipeline throughput = 82.763'MB/sec entries = 921222 avg-key = 28.00 avg-zkey = 1.90 avg-val = 117.70 avg-zval = 32.71 usrkeys = 921222 avg-key = 20.00 avg-zkey = 1.90 avg-val = 124.70 avg-zval = 32.71 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 921222 bytes = 3224288 } seq expand size = 6448554 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.0301 GB dict = 1.08 MB all = 0.0362 GB } UnZip/Zip{ index = 10.5139 value = 3.5986 dict = 1.00 all = 3.7081 } Zip/UnZip{ index = 0.0951 value = 0.2779 dict = 1.00 all = 0.2697 } ---------------------------- total value len = 2254.309075 GB avg = 0.199 KB (by entry num) total key len = 307.557844 GB avg = 0.027 KB total ukey len = 237.836786 GB avg = 0.015 KB total ukey num = 15.762764090 Billion total entry num = 11.304078038 Billion write speed all = 31.085403434 MB/sec (with seq num) write speed all = 29.988104200 MB/sec (without seq num) 2024/11/24-07:48:46.083899 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296742: 921222 keys, 36196034 bytes, temperature: kWarm 2024/11/24-07:48:46.083968 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405726083933, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296742, "file_size": 36196034, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4265679976, "largest_seqno": 4502435164, "table_properties": {"data_size": 30129776, "index_size": 1752384, "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": 25794216, "raw_average_key_size": 28, "raw_value_size": 108423656, "raw_average_value_size": 117, "num_data_blocks": 1, "num_entries": 921222, "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": 1732405722, "oldest_key_time": 0, "file_creation_time": 1732405722, "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": 296742, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:48:46.120589 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296743.sst) /dev/shm/ToplingTemp/Topling-300400-mKmB30 2024/11/24-07:48:46.978083 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296743.sst): first pass time = 0.86's, 156.531'MB/sec 2024/11/24-07:48:48.294717 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296743.sst): old prealloc_size = 147639500, real_size = 31371280 2024/11/24-07:48:48.295305 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296743.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.96 2024/11/24-07:48:48.296088 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296743.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-07:48:49.114633 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296743.sst): second pass time = 1.32's, 82.446'MB/sec, value only(80.8% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.82's, 43.095'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3123.546'MB/sec (index lex order gen) rebuild zvType time = 0.69's, 0.333'MB/sec write SST data time = 0.13's, 275.526'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 = 35084.072'MB/sec zip my value time = 1.32's, unzip length = 0.108'GB zip my value throughput = 82.446'MB/sec zip pipeline throughput = 82.446'MB/sec entries = 919300 avg-key = 28.00 avg-zkey = 1.92 avg-val = 118.00 avg-zval = 31.96 usrkeys = 919300 avg-key = 20.00 avg-zkey = 1.92 avg-val = 125.00 avg-zval = 31.96 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.4436 value = 3.6921 dict = 1.00 all = 3.7986 } Zip/UnZip{ index = 0.0958 value = 0.2708 dict = 1.00 all = 0.2633 } ---------------------------- total value len = 2254.423987 GB avg = 0.199 KB (by entry num) total key len = 307.583585 GB avg = 0.027 KB total ukey len = 237.855172 GB avg = 0.015 KB total ukey num = 15.763683390 Billion total entry num = 11.304997338 Billion write speed all = 31.085949278 MB/sec (with seq num) write speed all = 29.988601783 MB/sec (without seq num) 2024/11/24-07:48:49.159199 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296743: 919300 keys, 35333106 bytes, temperature: kWarm 2024/11/24-07:48:49.159270 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405729159233, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296743, "file_size": 35333106, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4365150114, "largest_seqno": 4477791583, "table_properties": {"data_size": 29380736, "index_size": 1760512, "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": 1732405726, "oldest_key_time": 0, "file_creation_time": 1732405726, "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": 296743, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:48:49.200290 139957231949376 [top_zip_table_builder.cc:934] ToplingZipTableBuilder(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296744.sst) /dev/shm/ToplingTemp/Topling-300400-HE2i01 2024/11/24-07:48:49.599166 139957231949376 [top_zip_table_builder.cc:1352] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296744.sst): first pass time = 0.40's, 243.964'MB/sec 2024/11/24-07:48:50.538264 139957231949376 [top_zip_table_builder.cc:2772] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296744.sst): old prealloc_size = 147639500, real_size = 22393360 2024/11/24-07:48:50.538716 139957231949376 [top_zip_table_builder.cc:1773] BuildReorderMap(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296744.sst): index type = NestLoudsTrieDAWG_Mixed_XL_256_32_FL, store type = DictZipBlobStore usrkeys = 679625 prefix = 4 raw-key = 0.0109 GB zip-key = 0.0013 GB avg-key = 16.00 avg-zkey = 1.92 raw-val = 0.0783 GB zip-val = 0.0209 GB avg-val = 115.17 avg-zval = 30.78 2024/11/24-07:48:50.539289 139957231949376 [top_zip_table_builder.cc:1299] /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296744.sst: sumWaitingMem = 0.002 GB, sumWorkingMem = 0.006 GB, reorder workingMem = 0.0017 GB, waited 0.000 sec, Key+Value = 0.097 GB 2024/11/24-07:48:51.162837 139957231949376 [top_zip_table_builder.cc:3100] ToplingZipTableBuilder::Finish(/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00/296744.sst): second pass time = 0.94's, 83.424'MB/sec, value only(80.4% of KV) wait indexing time = 0.00's, remap KeyValue time = 0.62's, 40.383'MB/sec (all stages of remap) Get OrderMap time = 0.00's, 3040.266'MB/sec (index lex order gen) rebuild zvType time = 0.53's, 0.320'MB/sec write SST data time = 0.09's, 269.993'MB/sec dict compress time = 4356233619.02's, 0.000'MB/sec z-dict build time = 0.00's, sample length = 0.786'MB, throughput = 25680.371'MB/sec zip my value time = 0.94's, unzip length = 0.078'GB zip my value throughput = 83.424'MB/sec zip pipeline throughput = 83.424'MB/sec entries = 679625 avg-key = 28.00 avg-zkey = 1.92 avg-val = 115.17 avg-zval = 30.78 usrkeys = 679625 avg-key = 20.00 avg-zkey = 1.92 avg-val = 122.17 avg-zval = 30.78 TagRS{ kinds = RS_Key0_Tag1 bytes = 0 } TagArray{ size = 679625 bytes = 2208800 } seq expand size = 4757375 multi value expand size = 0 cnt WriteAppend = 13 UnZipSize{ index = 0.0136 GB value = 0.0783 GB dict = 0.79 MB all = 0.0973 GB } __ZipSize{ index = 0.0013 GB value = 0.0209 GB dict = 0.79 MB all = 0.0252 GB } UnZip/Zip{ index = 10.4416 value = 3.7412 dict = 1.00 all = 3.8579 } Zip/UnZip{ index = 0.0958 value = 0.2673 dict = 1.00 all = 0.2592 } ---------------------------- total value len = 2254.507016 GB avg = 0.199 KB (by entry num) total key len = 307.602614 GB avg = 0.027 KB total ukey len = 237.868764 GB avg = 0.015 KB total ukey num = 15.764363015 Billion total entry num = 11.305676963 Billion write speed all = 31.086415036 MB/sec (with seq num) write speed all = 29.989028844 MB/sec (without seq num) 2024/11/24-07:48:51.199243 139957231949376 [compaction_job.cc:1948] [default] [JOB 43598] Generated table #296744: 679625 keys, 25221240 bytes, temperature: kWarm 2024/11/24-07:48:51.199310 139957231949376 EVENT_LOG_v1 {"time_micros": 1732405731199276, "cf_name": "default", "job": 43598, "event": "table_file_creation", "file_number": 296744, "file_size": 25221240, "file_checksum": "", "file_checksum_func_name": "Unknown", "smallest_seqno": 4448206462, "largest_seqno": 4502436299, "table_properties": {"data_size": 20921536, "index_size": 1301760, "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": 19029500, "raw_average_key_size": 28, "raw_value_size": 78270954, "raw_average_value_size": 115, "num_data_blocks": 1, "num_entries": 679625, "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": 1732405729, "oldest_key_time": 0, "file_creation_time": 1732405729, "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": 296744, "seqno_to_time_mapping": "N/A", "__indexstats__": "[...1 records...]"}} 2024/11/24-07:48:51.221588 139957231949376 [compaction_job.cc:703] job-43598: subcompact[0], size: 0.976141 G, files: /storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-43598/att-00 [296717,296718,296719,296720,296721,296722,296723,296724,296725,296726,296727,296728,296729,296730,296731,296732,296733,296734,296735,296736,296737,296738,296739,296740,296741,296742,296743,296744] 2024/11/24-07:48:51.428528 139957231949376 (Original Log Time 2024/11/24-07:47:20.059184) EVENT_LOG_v1 {"time_micros": 1732405640059152, "job": 43598, "event": "compaction_started", "compaction_reason": "FilesMarkedForCompaction", "files_L2": [296708], "files_L3": [296664, 296665, 296666, 296667, 296668, 296669, 296670, 296627, 296628, 296629, 296630, 296631, 296632, 296633, 296634, 296635, 296636, 296637, 296638, 296639, 296640, 296641, 296642, 296643, 296644, 296645, 296646, 296647], "score": 0.705687, "input_data_size": 1001586443, "oldest_snapshot_seqno": 4502483710} 2024/11/24-07:48:51.428531 139957231949376 (Original Log Time 2024/11/24-07:48:51.426242) [compaction_job.cc:2022] [default] [JOB 43598] Compacted 1@2 + 28@3 files to L3 => 976141060 bytes 2024/11/24-07:48:51.428532 139957231949376 (Original Log Time 2024/11/24-07:48:51.428445) [compaction_job.cc:1224] [default] compacted to: files[0 0 0 28 0 0 0] max score 0.04, MB/sec: 11.0 rd, 10.7 wr, level 3, files in(1, 28) out(28 +0 blob) MB in(27.1, 928.1 +0.0 blob) out(930.9 +0.0 blob), read-write-amplify(69.7) write-amplify(34.4) OK, records in: 25802631, records dropped: 100779 output_compression: Snappy 2024/11/24-07:48:51.428535 139957231949376 (Original Log Time 2024/11/24-07:48:51.428501) EVENT_LOG_v1 {"time_micros": 1732405731428476, "cf": "default", "job": 43598, "event": "compaction_finished", "compaction_time_micros": 91162415, "compaction_time_cpu_micros": 39410066, "output_level": 3, "num_output_files": 28, "total_output_size": 976141060, "num_input_records": 25802631, "num_output_records": 25701852, "num_subcompactions": 1, "output_compression": "Snappy", "num_single_delete_mismatches": 0, "num_single_delete_fallthrough": 0, "file_write_nanos": 675361244, "file_range_sync_nanos": 0, "file_fsync_nanos": 18795, "file_prepare_write_nanos": 65919, "lsm_state": [0, 0, 0, 28, 0, 0, 0]} 2024/11/24-07:48:51.544198 139957231949376 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":1732405639,"executesMs":91515,"compactionJobId":43598,"attempt":0,"compactionInputRawBytes":3735492114,"compactionInputZipBytes":1001586443,"compactionOutputRawBytes":0,"compactionOutputZipBytes":976141060,"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-7e3de709745219a9765eaa47998435c9-5aeb2bb2f415ecb1-00"}}, response = 2024/11/24-07:48:51.544291 139957231949376 INFO dcompact_worker.cpp:1459: finish /worker/dcompact-log/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/2024-11-22T14.14.14/.rocksdb/job-43598/att-00: olev 3, work 91.515 s, result 7.701 ms, install 2.307 ms, input{raw 3.479 GiB zip 955.187 MiB}