[2024-12-14 14:26:18.215256] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 23.11.0 initialization... [2024-12-14 14:26:18.215514] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid1989950 ] Set seed to 1734182778208606 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-14 14:26:18.334657] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-14 14:26:18.542881] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-14 14:26:18.542927] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1989950' to capture a snapshot of events at runtime. [2024-12-14 14:26:18.542937] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1989950 for offline analysis/debug. [2024-12-14 14:26:18.542981] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sat Dec 14 14:26:27 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/14-14:26:29 ... thread 0: (1000000,1000000) ops and (356467.7,356467.7) ops/second in (2.805303,2.805303) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/6 567.01 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 351.8 2.33 2.09 12 0.194 0 0 0.0 0.0 L2 3/2 251.79 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.1 2.0 253.6 253.4 1.49 1.44 2 0.745 383K 177 0.0 0.0 L3 10/0 804.54 MB 0.8 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1182/8 96.94 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.5 99.0 313.4 3.82 3.54 14 0.273 383K 177 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.5 99.0 313.4 3.82 3.54 14 0.273 383K 177 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.0 0.0 253.6 253.4 1.49 1.44 2 0.745 383K 177 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 351.8 2.33 2.09 12 0.194 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.17 GB write, 397.63 MB/s write, 0.37 GB read, 125.58 MB/s read, 3.8 seconds Interval compaction: 1.17 GB write, 426.41 MB/s write, 0.37 GB read, 134.67 MB/s read, 3.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 101894 Average: 1.9371 StdDev: 17.42 Min: 1 Median: 1.2671 Max: 2816 Percentiles: P50: 1.27 P75: 1.68 P99: 3.93 P99.9: 9.27 P99.99: 371.79 ------------------------------------------------------ [ 0, 1 ] 34412 33.772% 33.772% ####### ( 1, 2 ] 61900 60.749% 94.522% ############ ( 2, 3 ] 3371 3.308% 97.830% # ( 3, 4 ] 1286 1.262% 99.092% ( 4, 6 ] 663 0.651% 99.743% ( 6, 10 ] 197 0.193% 99.936% ( 10, 15 ] 27 0.026% 99.963% ( 15, 22 ] 13 0.013% 99.975% ( 22, 34 ] 1 0.001% 99.976% ( 51, 76 ] 1 0.001% 99.977% ( 110, 170 ] 9 0.009% 99.986% ( 170, 250 ] 2 0.002% 99.988% ( 250, 380 ] 3 0.003% 99.991% ( 380, 580 ] 2 0.002% 99.993% ( 580, 870 ] 1 0.001% 99.994% ( 870, 1300 ] 2 0.002% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 1900, 2900 ] 3 0.003% 100.001% ** Level 1 read latency histogram (micros): Count: 5 Average: 727.6000 StdDev: 731.73 Min: 73 Median: 230.0000 Max: 1886 Percentiles: P50: 230.00 P75: 1192.50 P99: 1870.00 P99.9: 1886.00 P99.99: 1886.00 ------------------------------------------------------ ( 51, 76 ] 1 20.000% 20.000% #### ( 170, 250 ] 2 40.000% 60.000% ######## ( 870, 1300 ] 1 20.000% 80.000% #### ( 1300, 1900 ] 1 20.000% 100.000% #### ** Level 2 read latency histogram (micros): Count: 49958 Average: 2.0280 StdDev: 16.32 Min: 1 Median: 1.3070 Max: 2533 Percentiles: P50: 1.31 P75: 1.72 P99: 5.30 P99.9: 9.92 P99.99: 870.60 ------------------------------------------------------ [ 0, 1 ] 15588 31.202% 31.202% ###### ( 1, 2 ] 30591 61.233% 92.436% ############ ( 2, 3 ] 1966 3.935% 96.371% # ( 3, 4 ] 943 1.888% 98.259% ( 4, 6 ] 572 1.145% 99.403% ( 6, 10 ] 253 0.506% 99.910% ( 10, 15 ] 26 0.052% 99.962% ( 15, 22 ] 5 0.010% 99.972% ( 22, 34 ] 2 0.004% 99.976% ( 51, 76 ] 1 0.002% 99.978% ( 170, 250 ] 2 0.004% 99.982% ( 250, 380 ] 1 0.002% 99.984% ( 380, 580 ] 3 0.006% 99.990% ( 870, 1300 ] 3 0.006% 99.996% ( 1300, 1900 ] 1 0.002% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 40 Average: 3507.8750 StdDev: 2869.07 Min: 581 Median: 1800.0000 Max: 10535 Percentiles: P50: 1800.00 P75: 5500.00 P99: 10535.00 P99.9: 10535.00 P99.99: 10535.00 ------------------------------------------------------ ( 580, 870 ] 2 5.000% 5.000% # ( 870, 1300 ] 8 20.000% 25.000% #### ( 1300, 1900 ] 12 30.000% 55.000% ###### ( 1900, 2900 ] 1 2.500% 57.500% # ( 2900, 4400 ] 4 10.000% 67.500% ## ( 4400, 6600 ] 6 15.000% 82.500% ### ( 6600, 9900 ] 6 15.000% 97.500% ### ( 9900, 14000 ] 1 2.500% 100.000% # ** Level 4 read latency histogram (micros): Count: 30 Average: 4018.2333 StdDev: 2543.94 Min: 1068 Median: 3581.8182 Max: 9893 Percentiles: P50: 3581.82 P75: 5500.00 P99: 9735.00 P99.9: 9883.50 P99.99: 9893.00 ------------------------------------------------------ ( 870, 1300 ] 4 13.333% 13.333% ### ( 1300, 1900 ] 4 13.333% 26.667% ### ( 1900, 2900 ] 2 6.667% 33.333% # ( 2900, 4400 ] 11 36.667% 70.000% ####### ( 4400, 6600 ] 3 10.000% 80.000% ## ( 6600, 9900 ] 6 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 326.98 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.213 H:M:S, 7.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 350.55 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.213 H:M:S, 7.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/14-14:26:32 ... thread 0: (1000000,2000000) ops and (322955.8,338885.3) ops/second in (3.096399,5.901702) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/11 1.17 GB 18.9 0.2 0.0 0.2 2.0 1.8 0.0 1.1 40.8 336.6 6.18 5.58 27 0.229 255K 238 0.0 0.0 L1 1/1 3.08 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 233.8 233.4 1.62 1.56 1 1.617 383K 598 0.0 0.0 L2 2/1 53.98 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 253.6 253.4 1.49 1.44 2 0.745 383K 177 0.0 0.0 L3 20/10 1.12 GB 0.3 0.2 0.2 0.0 0.2 0.2 0.4 1.0 227.7 227.7 1.10 1.03 1 1.097 253K 0 0.0 0.0 L4 174/0 9.75 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 151.7 151.7 1.48 1.11 1 1.481 228K 0 0.0 0.0 L5 1044/0 85.82 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1255/23 97.92 GB 0.0 1.4 1.0 0.4 3.2 2.8 1.1 1.8 125.0 278.9 11.86 10.73 32 0.371 1505K 1013 0.0 0.0 Int 0/0 0.00 KB 0.0 1.4 1.0 0.4 3.2 2.8 1.1 1.8 125.0 278.9 11.86 10.73 32 0.371 1505K 1013 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.4 1.0 0.4 1.4 1.0 0.0 0.0 221.5 221.4 6.69 6.14 6 1.115 1505K 1013 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.8 1.8 0.0 0.0 0.0 353.5 5.17 4.60 26 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 total, 5.9 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.23 GB write, 541.79 MB/s write, 1.45 GB read, 242.76 MB/s read, 11.9 seconds Interval compaction: 3.23 GB write, 560.43 MB/s write, 1.45 GB read, 251.11 MB/s read, 11.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 369797 Average: 2.2551 StdDev: 13.73 Min: 0 Median: 1.5138 Max: 3687 Percentiles: P50: 1.51 P75: 1.90 P99: 5.66 P99.9: 9.55 P99.99: 14.15 ------------------------------------------------------ [ 0, 1 ] 61508 16.633% 16.633% ### ( 1, 2 ] 240137 64.938% 81.570% ############# ( 2, 3 ] 40879 11.054% 92.625% ## ( 3, 4 ] 14371 3.886% 96.511% # ( 4, 6 ] 11065 2.992% 99.503% # ( 6, 10 ] 1654 0.447% 99.951% ( 10, 15 ] 177 0.048% 99.998% ( 15, 22 ] 33 0.009% 100.007% ( 22, 34 ] 7 0.002% 100.009% ( 51, 76 ] 2 0.001% 100.010% ( 110, 170 ] 12 0.003% 100.013% ( 170, 250 ] 12 0.003% 100.016% ( 250, 380 ] 5 0.001% 100.018% ( 380, 580 ] 11 0.003% 100.021% ( 580, 870 ] 3 0.001% 100.021% ( 870, 1300 ] 3 0.001% 100.022% ( 1300, 1900 ] 2 0.001% 100.023% ( 1900, 2900 ] 5 0.001% 100.024% ( 2900, 4400 ] 2 0.001% 100.025% ** Level 1 read latency histogram (micros): Count: 31 Average: 337.2903 StdDev: 645.25 Min: 1 Median: 2.7500 Max: 2364 Percentiles: P50: 2.75 P75: 396.67 P99: 2364.00 P99.9: 2364.00 P99.99: 2364.00 ------------------------------------------------------ [ 0, 1 ] 9 29.032% 29.032% ###### ( 1, 2 ] 5 16.129% 45.161% ### ( 2, 3 ] 2 6.452% 51.613% # ( 4, 6 ] 2 6.452% 58.065% # ( 51, 76 ] 1 3.226% 61.290% # ( 170, 250 ] 4 12.903% 74.194% ### ( 380, 580 ] 3 9.677% 83.871% ## ( 580, 870 ] 1 3.226% 87.097% # ( 870, 1300 ] 1 3.226% 90.323% # ( 1300, 1900 ] 1 3.226% 93.548% # ( 1900, 2900 ] 2 6.452% 100.000% # ** Level 2 read latency histogram (micros): Count: 95721 Average: 2.1434 StdDev: 11.81 Min: 1 Median: 1.4438 Max: 2533 Percentiles: P50: 1.44 P75: 1.83 P99: 5.65 P99.9: 9.86 P99.99: 227.12 ------------------------------------------------------ [ 0, 1 ] 20531 21.449% 21.449% #### ( 1, 2 ] 61586 64.339% 85.788% ############# ( 2, 3 ] 7477 7.811% 93.599% ## ( 3, 4 ] 3264 3.410% 97.009% # ( 4, 6 ] 2315 2.418% 99.428% ( 6, 10 ] 469 0.490% 99.917% ( 10, 15 ] 58 0.061% 99.978% ( 15, 22 ] 7 0.007% 99.985% ( 22, 34 ] 2 0.002% 99.987% ( 51, 76 ] 1 0.001% 99.989% ( 170, 250 ] 2 0.002% 99.991% ( 250, 380 ] 1 0.001% 99.992% ( 380, 580 ] 3 0.003% 99.995% ( 870, 1300 ] 3 0.003% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 182491 Average: 3.6382 StdDev: 68.57 Min: 1 Median: 1.6085 Max: 10535 Percentiles: P50: 1.61 P75: 1.99 P99: 8.63 P99.9: 154.31 P99.99: 431.48 ------------------------------------------------------ [ 0, 1 ] 18886 10.349% 10.349% ## ( 1, 2 ] 118908 65.158% 75.507% ############# ( 2, 3 ] 26039 14.269% 89.776% ### ( 3, 4 ] 8154 4.468% 94.244% # ( 4, 6 ] 6924 3.794% 98.038% # ( 6, 10 ] 2674 1.465% 99.504% ( 10, 15 ] 473 0.259% 99.763% ( 15, 22 ] 51 0.028% 99.791% ( 22, 34 ] 4 0.002% 99.793% ( 34, 51 ] 1 0.001% 99.793% ( 51, 76 ] 1 0.001% 99.794% ( 76, 110 ] 66 0.036% 99.830% ( 110, 170 ] 174 0.095% 99.925% ( 170, 250 ] 72 0.039% 99.965% ( 250, 380 ] 38 0.021% 99.986% ( 380, 580 ] 34 0.019% 100.004% ( 580, 870 ] 16 0.009% 100.013% ( 870, 1300 ] 12 0.007% 100.020% ( 1300, 1900 ] 13 0.007% 100.027% ( 1900, 2900 ] 2 0.001% 100.028% ( 2900, 4400 ] 4 0.002% 100.030% ( 4400, 6600 ] 6 0.003% 100.033% ( 6600, 9900 ] 6 0.003% 100.037% ( 9900, 14000 ] 1 0.001% 100.037% ** Level 4 read latency histogram (micros): Count: 320 Average: 387.3188 StdDev: 1404.94 Min: 1 Median: 2.2787 Max: 9893 Percentiles: P50: 2.28 P75: 6.00 P99: 8140.00 P99.9: 9724.00 P99.99: 9882.40 ------------------------------------------------------ [ 0, 1 ] 41 12.812% 12.812% ### ( 1, 2 ] 102 31.875% 44.688% ###### ( 2, 3 ] 61 19.062% 63.750% #### ( 3, 4 ] 16 5.000% 68.750% # ( 4, 6 ] 20 6.250% 75.000% # ( 6, 10 ] 6 1.875% 76.875% ( 10, 15 ] 15 4.688% 81.562% # ( 15, 22 ] 17 5.312% 86.875% # ( 22, 34 ] 6 1.875% 88.750% ( 110, 170 ] 1 0.312% 89.062% ( 170, 250 ] 2 0.625% 89.688% ( 250, 380 ] 2 0.625% 90.312% ( 870, 1300 ] 5 1.562% 91.875% ( 1300, 1900 ] 4 1.250% 93.125% ( 1900, 2900 ] 2 0.625% 93.750% ( 2900, 4400 ] 11 3.438% 97.188% # ( 4400, 6600 ] 3 0.938% 98.125% ( 6600, 9900 ] 6 1.875% 100.000% ** DB Stats ** Uptime(secs): 6.1 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 322.35 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.611 H:M:S, 10.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 317.85 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.398 H:M:S, 12.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/14-14:26:36 ... thread 0: (1000000,3000000) ops and (311132.0,329099.9) ops/second in (3.214070,9.115772) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/7 1.48 GB 12.6 1.4 0.0 1.4 4.1 2.8 0.0 1.5 101.0 307.5 13.72 12.57 45 0.305 1407K 1466 0.0 0.0 L1 3/3 210.84 MB 0.0 1.0 1.0 0.0 1.0 1.0 0.2 1.0 226.5 225.9 4.74 4.60 2 2.370 1090K 2574 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 253.6 253.4 1.49 1.44 2 0.745 383K 177 0.0 0.0 L3 22/0 912.00 MB 0.9 1.9 0.8 1.1 1.9 0.8 0.4 2.5 222.0 221.5 8.73 8.13 6 1.455 1968K 4115 0.0 0.0 L4 174/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 151.7 151.7 1.48 1.11 1 1.481 228K 0 0.0 0.0 L5 1056/0 86.80 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1264/10 98.90 GB 0.0 4.9 2.2 2.7 7.6 5.0 3.4 2.8 165.8 259.5 30.16 27.85 56 0.539 5078K 8332 0.0 0.0 Int 0/0 0.00 KB 0.0 4.9 2.2 2.7 7.6 5.0 3.3 2.8 165.8 259.5 30.16 27.85 56 0.539 5078K 8332 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.9 2.2 2.7 4.9 2.2 0.0 0.0 227.4 227.0 21.99 20.72 16 1.374 5078K 8332 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 346.8 8.17 7.13 40 0.204 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.3 total, 9.1 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.64 GB write, 839.81 MB/s write, 4.88 GB read, 536.56 MB/s read, 30.2 seconds Interval compaction: 7.64 GB write, 858.52 MB/s write, 4.88 GB read, 548.52 MB/s read, 30.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 11, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 706526 Average: 2.3958 StdDev: 12.68 Min: 0 Median: 1.5917 Max: 4418 Percentiles: P50: 1.59 P75: 1.98 P99: 5.85 P99.9: 9.78 P99.99: 13.52 ------------------------------------------------------ [ 0, 1 ] 86629 12.261% 12.261% ## ( 1, 2 ] 450649 63.784% 76.045% ############# ( 2, 3 ] 97611 13.816% 89.861% ### ( 3, 4 ] 35795 5.066% 94.927% # ( 4, 6 ] 31139 4.407% 99.334% # ( 6, 10 ] 4225 0.598% 99.932% ( 10, 15 ] 579 0.082% 100.014% ( 15, 22 ] 56 0.008% 100.022% ( 22, 34 ] 9 0.001% 100.023% ( 34, 51 ] 2 0.000% 100.024% ( 51, 76 ] 4 0.001% 100.024% ( 110, 170 ] 13 0.002% 100.026% ( 170, 250 ] 22 0.003% 100.029% ( 250, 380 ] 8 0.001% 100.030% ( 380, 580 ] 15 0.002% 100.033% ( 580, 870 ] 10 0.001% 100.034% ( 870, 1300 ] 11 0.002% 100.036% ( 1300, 1900 ] 2 0.000% 100.036% ( 1900, 2900 ] 7 0.001% 100.037% ( 2900, 4400 ] 2 0.000% 100.037% ( 4400, 6600 ] 1 0.000% 100.037% ** Level 1 read latency histogram (micros): Count: 230111 Average: 2.9499 StdDev: 14.78 Min: 1 Median: 1.7777 Max: 2417 Percentiles: P50: 1.78 P75: 2.61 P99: 7.85 P99.9: 12.46 P99.99: 14.16 ------------------------------------------------------ [ 0, 1 ] 11296 4.909% 4.909% # ( 1, 2 ] 133420 57.981% 62.890% ############ ( 2, 3 ] 45857 19.928% 82.818% #### ( 3, 4 ] 17389 7.557% 90.375% ## ( 4, 6 ] 18322 7.962% 98.337% ## ( 6, 10 ] 3296 1.432% 99.769% ( 10, 15 ] 611 0.266% 100.035% ( 15, 22 ] 49 0.021% 100.056% ( 22, 34 ] 4 0.002% 100.058% ( 34, 51 ] 1 0.000% 100.058% ( 51, 76 ] 2 0.001% 100.059% ( 76, 110 ] 11 0.005% 100.064% ( 110, 170 ] 40 0.017% 100.081% ( 170, 250 ] 35 0.015% 100.096% ( 250, 380 ] 26 0.011% 100.108% ( 380, 580 ] 31 0.013% 100.121% ( 580, 870 ] 13 0.006% 100.127% ( 870, 1300 ] 6 0.003% 100.130% ( 1300, 1900 ] 3 0.001% 100.131% ( 1900, 2900 ] 3 0.001% 100.132% ** Level 2 read latency histogram (micros): Count: 111926 Average: 2.2907 StdDev: 12.13 Min: 1 Median: 1.4739 Max: 2533 Percentiles: P50: 1.47 P75: 1.86 P99: 5.89 P99.9: 13.65 P99.99: 440.25 ------------------------------------------------------ [ 0, 1 ] 21898 19.565% 19.565% #### ( 1, 2 ] 71889 64.229% 83.794% ############# ( 2, 3 ] 9954 8.893% 92.687% ## ( 3, 4 ] 4182 3.736% 96.424% # ( 4, 6 ] 3057 2.731% 99.155% # ( 6, 10 ] 767 0.685% 99.840% ( 10, 15 ] 92 0.082% 99.922% ( 15, 22 ] 9 0.008% 99.930% ( 22, 34 ] 2 0.002% 99.932% ( 51, 76 ] 1 0.001% 99.933% ( 76, 110 ] 26 0.023% 99.956% ( 110, 170 ] 19 0.017% 99.973% ( 170, 250 ] 9 0.008% 99.981% ( 250, 380 ] 8 0.007% 99.988% ( 380, 580 ] 6 0.005% 99.994% ( 580, 870 ] 2 0.002% 99.996% ( 870, 1300 ] 3 0.003% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 239473 Average: 3.6378 StdDev: 61.04 Min: 0 Median: 1.6263 Max: 10535 Percentiles: P50: 1.63 P75: 2.06 P99: 8.78 P99.9: 185.02 P99.99: 557.95 ------------------------------------------------------ [ 0, 1 ] 23041 9.622% 9.622% ## ( 1, 2 ] 154388 64.470% 74.091% ############# ( 2, 3 ] 34956 14.597% 88.688% ### ( 3, 4 ] 12099 5.052% 93.741% # ( 4, 6 ] 10025 4.186% 97.927% # ( 6, 10 ] 3693 1.542% 99.469% ( 10, 15 ] 626 0.261% 99.731% ( 15, 22 ] 59 0.025% 99.755% ( 22, 34 ] 9 0.004% 99.759% ( 34, 51 ] 3 0.001% 99.760% ( 51, 76 ] 1 0.000% 99.761% ( 76, 110 ] 80 0.033% 99.794% ( 110, 170 ] 231 0.096% 99.891% ( 170, 250 ] 120 0.050% 99.941% ( 250, 380 ] 62 0.026% 99.967% ( 380, 580 ] 63 0.026% 99.993% ( 580, 870 ] 29 0.012% 100.005% ( 870, 1300 ] 21 0.009% 100.014% ( 1300, 1900 ] 14 0.006% 100.020% ( 1900, 2900 ] 3 0.001% 100.021% ( 2900, 4400 ] 4 0.002% 100.023% ( 4400, 6600 ] 6 0.003% 100.025% ( 6600, 9900 ] 6 0.003% 100.028% ( 9900, 14000 ] 1 0.000% 100.028% ** Level 4 read latency histogram (micros): Count: 320 Average: 387.3188 StdDev: 1404.94 Min: 1 Median: 2.2787 Max: 9893 Percentiles: P50: 2.28 P75: 6.00 P99: 8140.00 P99.9: 9724.00 P99.99: 9882.40 ------------------------------------------------------ [ 0, 1 ] 41 12.812% 12.812% ### ( 1, 2 ] 102 31.875% 44.688% ###### ( 2, 3 ] 61 19.062% 63.750% #### ( 3, 4 ] 16 5.000% 68.750% # ( 4, 6 ] 20 6.250% 75.000% # ( 6, 10 ] 6 1.875% 76.875% ( 10, 15 ] 15 4.688% 81.562% # ( 15, 22 ] 17 5.312% 86.875% # ( 22, 34 ] 6 1.875% 88.750% ( 110, 170 ] 1 0.312% 89.062% ( 170, 250 ] 2 0.625% 89.688% ( 250, 380 ] 2 0.625% 90.312% ( 870, 1300 ] 5 1.562% 91.875% ( 1300, 1900 ] 4 1.250% 93.125% ( 1900, 2900 ] 2 0.625% 93.750% ( 2900, 4400 ] 11 3.438% 97.188% # ( 4400, 6600 ] 3 0.938% 98.125% ( 6600, 9900 ] 6 1.875% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 956.8333 StdDev: 1125.37 Min: 93 Median: 361.4286 Max: 4861 Percentiles: P50: 361.43 P75: 1300.00 P99: 4861.00 P99.9: 4861.00 P99.99: 4861.00 ------------------------------------------------------ ( 76, 110 ] 1 1.667% 1.667% ( 110, 170 ] 14 23.333% 25.000% ##### ( 170, 250 ] 9 15.000% 40.000% ### ( 250, 380 ] 7 11.667% 51.667% ## ( 380, 580 ] 4 6.667% 58.333% # ( 580, 870 ] 4 6.667% 65.000% # ( 870, 1300 ] 6 10.000% 75.000% ## ( 1300, 1900 ] 3 5.000% 80.000% # ( 1900, 2900 ] 7 11.667% 91.667% ## ( 2900, 4400 ] 4 6.667% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 9.3 total, 3.2 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 316.78 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.066 H:M:S, 11.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 306.21 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.455 H:M:S, 14.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/14-14:26:39 ... thread 0: (1000000,4000000) ops and (327526.4,328705.1) ops/second in (3.053189,12.168961) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/11 2.40 GB 81.8 1.8 0.0 1.8 5.5 3.7 0.0 1.5 103.3 309.8 18.29 16.84 60 0.305 1918K 1968 0.0 0.0 L1 3/3 210.84 MB 0.0 1.0 1.0 0.0 1.0 1.0 0.2 1.0 226.5 225.9 4.74 4.60 2 2.370 1090K 2574 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 253.6 253.4 1.49 1.44 2 0.745 383K 177 0.0 0.0 L3 22/0 912.00 MB 0.9 1.9 0.8 1.1 1.9 0.8 0.4 2.5 222.0 221.5 8.73 8.13 6 1.455 1968K 4115 0.0 0.0 L4 174/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 151.7 151.7 1.48 1.11 1 1.481 228K 0 0.0 0.0 L5 1056/0 86.80 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1271/14 99.82 GB 0.0 5.4 2.2 3.2 9.1 5.9 3.4 2.5 158.5 267.0 34.74 32.13 71 0.489 5589K 8834 0.0 0.0 Int 0/0 0.00 KB 0.0 5.4 2.2 3.2 9.1 5.9 3.3 2.5 158.5 267.0 34.74 32.13 71 0.489 5589K 8834 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.4 2.2 3.2 5.4 2.2 0.0 0.0 230.5 230.1 23.88 22.58 18 1.327 5589K 8834 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 348.2 10.86 9.55 53 0.205 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.4 total, 12.2 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.06 GB write, 749.64 MB/s write, 5.38 GB read, 444.90 MB/s read, 34.7 seconds Interval compaction: 9.06 GB write, 762.15 MB/s write, 5.38 GB read, 452.32 MB/s read, 34.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 14, interval: 14 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1027795 Average: 2.3425 StdDev: 12.04 Min: 0 Median: 1.5603 Max: 4418 Percentiles: P50: 1.56 P75: 1.94 P99: 5.81 P99.9: 9.88 P99.99: 14.39 ------------------------------------------------------ [ 0, 1 ] 136717 13.302% 13.302% ### ( 1, 2 ] 673163 65.496% 78.798% ############# ( 2, 3 ] 130163 12.664% 91.462% ### ( 3, 4 ] 44018 4.283% 95.745% # ( 4, 6 ] 36949 3.595% 99.340% # ( 6, 10 ] 5941 0.578% 99.918% ( 10, 15 ] 846 0.082% 100.000% ( 15, 22 ] 83 0.008% 100.008% ( 22, 34 ] 10 0.001% 100.009% ( 34, 51 ] 7 0.001% 100.010% ( 51, 76 ] 5 0.000% 100.010% ( 76, 110 ] 53 0.005% 100.016% ( 110, 170 ] 51 0.005% 100.021% ( 170, 250 ] 41 0.004% 100.025% ( 250, 380 ] 23 0.002% 100.027% ( 380, 580 ] 28 0.003% 100.029% ( 580, 870 ] 18 0.002% 100.031% ( 870, 1300 ] 13 0.001% 100.032% ( 1300, 1900 ] 5 0.000% 100.033% ( 1900, 2900 ] 7 0.001% 100.034% ( 2900, 4400 ] 3 0.000% 100.034% ( 4400, 6600 ] 1 0.000% 100.034% ** Level 1 read latency histogram (micros): Count: 230111 Average: 2.9499 StdDev: 14.78 Min: 1 Median: 1.7777 Max: 2417 Percentiles: P50: 1.78 P75: 2.61 P99: 7.85 P99.9: 12.46 P99.99: 14.16 ------------------------------------------------------ [ 0, 1 ] 11296 4.909% 4.909% # ( 1, 2 ] 133420 57.981% 62.890% ############ ( 2, 3 ] 45857 19.928% 82.818% #### ( 3, 4 ] 17389 7.557% 90.375% ## ( 4, 6 ] 18322 7.962% 98.337% ## ( 6, 10 ] 3296 1.432% 99.769% ( 10, 15 ] 611 0.266% 100.035% ( 15, 22 ] 49 0.021% 100.056% ( 22, 34 ] 4 0.002% 100.058% ( 34, 51 ] 1 0.000% 100.058% ( 51, 76 ] 2 0.001% 100.059% ( 76, 110 ] 11 0.005% 100.064% ( 110, 170 ] 40 0.017% 100.081% ( 170, 250 ] 35 0.015% 100.096% ( 250, 380 ] 26 0.011% 100.108% ( 380, 580 ] 31 0.013% 100.121% ( 580, 870 ] 13 0.006% 100.127% ( 870, 1300 ] 6 0.003% 100.130% ( 1300, 1900 ] 3 0.001% 100.131% ( 1900, 2900 ] 3 0.001% 100.132% ** Level 2 read latency histogram (micros): Count: 111926 Average: 2.2907 StdDev: 12.13 Min: 1 Median: 1.4739 Max: 2533 Percentiles: P50: 1.47 P75: 1.86 P99: 5.89 P99.9: 13.65 P99.99: 440.25 ------------------------------------------------------ [ 0, 1 ] 21898 19.565% 19.565% #### ( 1, 2 ] 71889 64.229% 83.794% ############# ( 2, 3 ] 9954 8.893% 92.687% ## ( 3, 4 ] 4182 3.736% 96.424% # ( 4, 6 ] 3057 2.731% 99.155% # ( 6, 10 ] 767 0.685% 99.840% ( 10, 15 ] 92 0.082% 99.922% ( 15, 22 ] 9 0.008% 99.930% ( 22, 34 ] 2 0.002% 99.932% ( 51, 76 ] 1 0.001% 99.933% ( 76, 110 ] 26 0.023% 99.956% ( 110, 170 ] 19 0.017% 99.973% ( 170, 250 ] 9 0.008% 99.981% ( 250, 380 ] 8 0.007% 99.988% ( 380, 580 ] 6 0.005% 99.994% ( 580, 870 ] 2 0.002% 99.996% ( 870, 1300 ] 3 0.003% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 239473 Average: 3.6378 StdDev: 61.04 Min: 0 Median: 1.6263 Max: 10535 Percentiles: P50: 1.63 P75: 2.06 P99: 8.78 P99.9: 185.02 P99.99: 557.95 ------------------------------------------------------ [ 0, 1 ] 23041 9.622% 9.622% ## ( 1, 2 ] 154388 64.470% 74.091% ############# ( 2, 3 ] 34956 14.597% 88.688% ### ( 3, 4 ] 12099 5.052% 93.741% # ( 4, 6 ] 10025 4.186% 97.927% # ( 6, 10 ] 3693 1.542% 99.469% ( 10, 15 ] 626 0.261% 99.731% ( 15, 22 ] 59 0.025% 99.755% ( 22, 34 ] 9 0.004% 99.759% ( 34, 51 ] 3 0.001% 99.760% ( 51, 76 ] 1 0.000% 99.761% ( 76, 110 ] 80 0.033% 99.794% ( 110, 170 ] 231 0.096% 99.891% ( 170, 250 ] 120 0.050% 99.941% ( 250, 380 ] 62 0.026% 99.967% ( 380, 580 ] 63 0.026% 99.993% ( 580, 870 ] 29 0.012% 100.005% ( 870, 1300 ] 21 0.009% 100.014% ( 1300, 1900 ] 14 0.006% 100.020% ( 1900, 2900 ] 3 0.001% 100.021% ( 2900, 4400 ] 4 0.002% 100.023% ( 4400, 6600 ] 6 0.003% 100.025% ( 6600, 9900 ] 6 0.003% 100.028% ( 9900, 14000 ] 1 0.000% 100.028% ** Level 4 read latency histogram (micros): Count: 320 Average: 387.3188 StdDev: 1404.94 Min: 1 Median: 2.2787 Max: 9893 Percentiles: P50: 2.28 P75: 6.00 P99: 8140.00 P99.9: 9724.00 P99.99: 9882.40 ------------------------------------------------------ [ 0, 1 ] 41 12.812% 12.812% ### ( 1, 2 ] 102 31.875% 44.688% ###### ( 2, 3 ] 61 19.062% 63.750% #### ( 3, 4 ] 16 5.000% 68.750% # ( 4, 6 ] 20 6.250% 75.000% # ( 6, 10 ] 6 1.875% 76.875% ( 10, 15 ] 15 4.688% 81.562% # ( 15, 22 ] 17 5.312% 86.875% # ( 22, 34 ] 6 1.875% 88.750% ( 110, 170 ] 1 0.312% 89.062% ( 170, 250 ] 2 0.625% 89.688% ( 250, 380 ] 2 0.625% 90.312% ( 870, 1300 ] 5 1.562% 91.875% ( 1300, 1900 ] 4 1.250% 93.125% ( 1900, 2900 ] 2 0.625% 93.750% ( 2900, 4400 ] 11 3.438% 97.188% # ( 4400, 6600 ] 3 0.938% 98.125% ( 6600, 9900 ] 6 1.875% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 956.8333 StdDev: 1125.37 Min: 93 Median: 361.4286 Max: 4861 Percentiles: P50: 361.43 P75: 1300.00 P99: 4861.00 P99.9: 4861.00 P99.99: 4861.00 ------------------------------------------------------ ( 76, 110 ] 1 1.667% 1.667% ( 110, 170 ] 14 23.333% 25.000% ##### ( 170, 250 ] 9 15.000% 40.000% ### ( 250, 380 ] 7 11.667% 51.667% ## ( 380, 580 ] 4 6.667% 58.333% # ( 580, 870 ] 4 6.667% 65.000% # ( 870, 1300 ] 6 10.000% 75.000% ## ( 1300, 1900 ] 3 5.000% 80.000% # ( 1900, 2900 ] 7 11.667% 91.667% ## ( 2900, 4400 ] 4 6.667% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 12.4 total, 3.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 318.16 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.476 H:M:S, 11.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 322.35 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.411 H:M:S, 13.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/14-14:26:43 ... thread 0: (1000000,5000000) ops and (245700.4,307901.5) ops/second in (4.069998,16.238959) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/11 2.03 GB 0.0 2.9 0.0 2.9 7.6 4.7 0.0 1.6 117.1 306.4 25.28 23.46 78 0.324 3006K 3080 0.0 0.0 L1 13/13 1.55 GB 0.0 2.6 2.4 0.2 2.6 2.4 0.2 1.1 224.0 222.9 11.91 11.51 3 3.971 2710K 13K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 253.6 253.4 1.49 1.44 2 0.745 383K 177 0.0 0.0 L3 22/0 912.00 MB 0.9 1.9 0.8 1.1 1.9 0.8 0.4 2.5 222.0 221.5 8.73 8.13 6 1.455 1968K 4115 0.0 0.0 L4 174/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 151.7 151.7 1.48 1.11 1 1.481 228K 0 0.0 0.0 L5 1056/0 86.80 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1276/24 100.79 GB 0.0 8.0 3.6 4.4 12.6 8.2 3.4 2.7 167.1 264.6 48.90 45.64 90 0.543 8297K 20K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.0 3.6 4.4 12.6 8.2 3.3 2.7 167.1 264.6 48.90 45.64 90 0.543 8297K 20K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 8.0 3.6 4.4 8.0 3.5 0.0 0.0 232.2 231.5 35.20 33.56 23 1.530 8297K 20K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 349.5 13.70 12.08 67 0.204 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 16.4 total, 16.2 interval Flush(GB): cumulative 4.675, interval 4.675 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 12.63 GB write, 786.80 MB/s write, 7.98 GB read, 496.94 MB/s read, 48.9 seconds Interval compaction: 12.63 GB write, 796.64 MB/s write, 7.98 GB read, 503.15 MB/s read, 48.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 5, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 5, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 5, total-stops: 16, interval: 21 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1444543 Average: 2.3493 StdDev: 11.94 Min: 0 Median: 1.5507 Max: 4418 Percentiles: P50: 1.55 P75: 1.93 P99: 5.82 P99.9: 9.93 P99.99: 17.80 ------------------------------------------------------ [ 0, 1 ] 193764 13.414% 13.414% ### ( 1, 2 ] 959733 66.439% 79.852% ############# ( 2, 3 ] 177836 12.311% 92.163% ## ( 3, 4 ] 56716 3.926% 96.089% # ( 4, 6 ] 46314 3.206% 99.295% # ( 6, 10 ] 8891 0.615% 99.911% ( 10, 15 ] 1099 0.076% 99.987% ( 15, 22 ] 114 0.008% 99.995% ( 22, 34 ] 11 0.001% 99.996% ( 34, 51 ] 9 0.001% 99.996% ( 51, 76 ] 6 0.000% 99.997% ( 76, 110 ] 93 0.006% 100.003% ( 110, 170 ] 170 0.012% 100.015% ( 170, 250 ] 79 0.005% 100.020% ( 250, 380 ] 55 0.004% 100.024% ( 380, 580 ] 63 0.004% 100.028% ( 580, 870 ] 43 0.003% 100.031% ( 870, 1300 ] 17 0.001% 100.033% ( 1300, 1900 ] 6 0.000% 100.033% ( 1900, 2900 ] 10 0.001% 100.034% ( 2900, 4400 ] 4 0.000% 100.034% ( 4400, 6600 ] 1 0.000% 100.034% ** Level 1 read latency histogram (micros): Count: 288221 Average: 3.0716 StdDev: 20.02 Min: 0 Median: 1.7215 Max: 5389 Percentiles: P50: 1.72 P75: 2.46 P99: 8.14 P99.9: 14.43 P99.99: 136.69 ------------------------------------------------------ [ 0, 1 ] 19343 6.711% 6.711% # ( 1, 2 ] 172924 59.997% 66.708% ############ ( 2, 3 ] 52135 18.089% 84.797% #### ( 3, 4 ] 18999 6.592% 91.389% # ( 4, 6 ] 19661 6.822% 98.210% # ( 6, 10 ] 4250 1.475% 99.685% ( 10, 15 ] 701 0.243% 99.928% ( 15, 22 ] 53 0.018% 99.946% ( 22, 34 ] 4 0.001% 99.948% ( 34, 51 ] 1 0.000% 99.948% ( 51, 76 ] 2 0.001% 99.949% ( 76, 110 ] 52 0.018% 99.967% ( 110, 170 ] 151 0.052% 100.019% ( 170, 250 ] 91 0.032% 100.051% ( 250, 380 ] 48 0.017% 100.067% ( 380, 580 ] 67 0.023% 100.091% ( 580, 870 ] 20 0.007% 100.097% ( 870, 1300 ] 12 0.004% 100.102% ( 1300, 1900 ] 6 0.002% 100.104% ( 1900, 2900 ] 4 0.001% 100.105% ( 4400, 6600 ] 1 0.000% 100.105% ** Level 2 read latency histogram (micros): Count: 111926 Average: 2.2907 StdDev: 12.13 Min: 1 Median: 1.4739 Max: 2533 Percentiles: P50: 1.47 P75: 1.86 P99: 5.89 P99.9: 13.65 P99.99: 440.25 ------------------------------------------------------ [ 0, 1 ] 21898 19.565% 19.565% #### ( 1, 2 ] 71889 64.229% 83.794% ############# ( 2, 3 ] 9954 8.893% 92.687% ## ( 3, 4 ] 4182 3.736% 96.424% # ( 4, 6 ] 3057 2.731% 99.155% # ( 6, 10 ] 767 0.685% 99.840% ( 10, 15 ] 92 0.082% 99.922% ( 15, 22 ] 9 0.008% 99.930% ( 22, 34 ] 2 0.002% 99.932% ( 51, 76 ] 1 0.001% 99.933% ( 76, 110 ] 26 0.023% 99.956% ( 110, 170 ] 19 0.017% 99.973% ( 170, 250 ] 9 0.008% 99.981% ( 250, 380 ] 8 0.007% 99.988% ( 380, 580 ] 6 0.005% 99.994% ( 580, 870 ] 2 0.002% 99.996% ( 870, 1300 ] 3 0.003% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 239473 Average: 3.6378 StdDev: 61.04 Min: 0 Median: 1.6263 Max: 10535 Percentiles: P50: 1.63 P75: 2.06 P99: 8.78 P99.9: 185.02 P99.99: 557.95 ------------------------------------------------------ [ 0, 1 ] 23041 9.622% 9.622% ## ( 1, 2 ] 154388 64.470% 74.091% ############# ( 2, 3 ] 34956 14.597% 88.688% ### ( 3, 4 ] 12099 5.052% 93.741% # ( 4, 6 ] 10025 4.186% 97.927% # ( 6, 10 ] 3693 1.542% 99.469% ( 10, 15 ] 626 0.261% 99.731% ( 15, 22 ] 59 0.025% 99.755% ( 22, 34 ] 9 0.004% 99.759% ( 34, 51 ] 3 0.001% 99.760% ( 51, 76 ] 1 0.000% 99.761% ( 76, 110 ] 80 0.033% 99.794% ( 110, 170 ] 231 0.096% 99.891% ( 170, 250 ] 120 0.050% 99.941% ( 250, 380 ] 62 0.026% 99.967% ( 380, 580 ] 63 0.026% 99.993% ( 580, 870 ] 29 0.012% 100.005% ( 870, 1300 ] 21 0.009% 100.014% ( 1300, 1900 ] 14 0.006% 100.020% ( 1900, 2900 ] 3 0.001% 100.021% ( 2900, 4400 ] 4 0.002% 100.023% ( 4400, 6600 ] 6 0.003% 100.025% ( 6600, 9900 ] 6 0.003% 100.028% ( 9900, 14000 ] 1 0.000% 100.028% ** Level 4 read latency histogram (micros): Count: 320 Average: 387.3188 StdDev: 1404.94 Min: 1 Median: 2.2787 Max: 9893 Percentiles: P50: 2.28 P75: 6.00 P99: 8140.00 P99.9: 9724.00 P99.99: 9882.40 ------------------------------------------------------ [ 0, 1 ] 41 12.812% 12.812% ### ( 1, 2 ] 102 31.875% 44.688% ###### ( 2, 3 ] 61 19.062% 63.750% #### ( 3, 4 ] 16 5.000% 68.750% # ( 4, 6 ] 20 6.250% 75.000% # ( 6, 10 ] 6 1.875% 76.875% ( 10, 15 ] 15 4.688% 81.562% # ( 15, 22 ] 17 5.312% 86.875% # ( 22, 34 ] 6 1.875% 88.750% ( 110, 170 ] 1 0.312% 89.062% ( 170, 250 ] 2 0.625% 89.688% ( 250, 380 ] 2 0.625% 90.312% ( 870, 1300 ] 5 1.562% 91.875% ( 1300, 1900 ] 4 1.250% 93.125% ( 1900, 2900 ] 2 0.625% 93.750% ( 2900, 4400 ] 11 3.438% 97.188% # ( 4400, 6600 ] 3 0.938% 98.125% ( 6600, 9900 ] 6 1.875% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 956.8333 StdDev: 1125.37 Min: 93 Median: 361.4286 Max: 4861 Percentiles: P50: 361.43 P75: 1300.00 P99: 4861.00 P99.9: 4861.00 P99.99: 4861.00 ------------------------------------------------------ ( 76, 110 ] 1 1.667% 1.667% ( 110, 170 ] 14 23.333% 25.000% ##### ( 170, 250 ] 9 15.000% 40.000% ### ( 250, 380 ] 7 11.667% 51.667% ## ( 380, 580 ] 4 6.667% 58.333% # ( 580, 870 ] 4 6.667% 65.000% # ( 870, 1300 ] 6 10.000% 75.000% ## ( 1300, 1900 ] 3 5.000% 80.000% # ( 1900, 2900 ] 7 11.667% 91.667% ## ( 2900, 4400 ] 4 6.667% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 16.4 total, 4.1 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 299.26 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.836 H:M:S, 17.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 241.82 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.359 H:M:S, 33.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/14-14:26:46 ... thread 0: (1000000,6000000) ops and (291598.0,305058.8) ops/second in (3.429379,19.668338) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/15 3.07 GB 81.8 3.7 0.0 3.7 9.4 5.7 0.0 1.6 120.1 306.1 31.48 29.27 97 0.325 3837K 3874 0.0 0.0 L1 13/13 1.55 GB 0.0 2.6 2.4 0.2 2.6 2.4 0.2 1.1 224.0 222.9 11.91 11.51 3 3.971 2710K 13K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 253.6 253.4 1.49 1.44 2 0.745 383K 177 0.0 0.0 L3 22/0 912.00 MB 0.9 1.9 0.8 1.1 1.9 0.8 0.4 2.5 222.0 221.5 8.73 8.13 6 1.455 1968K 4115 0.0 0.0 L4 174/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 151.7 151.7 1.48 1.11 1 1.481 228K 0 0.0 0.0 L5 1056/0 86.80 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1283/28 101.84 GB 0.0 8.8 3.6 5.2 14.5 9.3 3.4 2.5 163.2 269.1 55.10 51.46 109 0.505 9129K 21K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.8 3.6 5.2 14.5 9.3 3.3 2.5 163.2 269.1 55.10 51.46 109 0.505 9129K 21K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 8.8 3.6 5.2 8.8 3.5 0.0 0.0 234.2 233.6 38.39 36.70 26 1.477 9129K 21K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 350.7 16.71 14.76 83 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 19.9 total, 19.7 interval Flush(GB): cumulative 5.721, interval 5.721 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 14.48 GB write, 746.09 MB/s write, 8.78 GB read, 452.39 MB/s read, 55.1 seconds Interval compaction: 14.48 GB write, 753.79 MB/s write, 8.78 GB read, 457.07 MB/s read, 55.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 17, interval: 28 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1773937 Average: 2.3384 StdDev: 11.89 Min: 0 Median: 1.5462 Max: 4418 Percentiles: P50: 1.55 P75: 1.92 P99: 5.79 P99.9: 9.88 P99.99: 16.32 ------------------------------------------------------ [ 0, 1 ] 238809 13.462% 13.462% ### ( 1, 2 ] 1186714 66.897% 80.359% ############# ( 2, 3 ] 214667 12.101% 92.460% ## ( 3, 4 ] 67819 3.823% 96.284% # ( 4, 6 ] 53981 3.043% 99.327% # ( 6, 10 ] 10481 0.591% 99.917% ( 10, 15 ] 1266 0.071% 99.989% ( 15, 22 ] 130 0.007% 99.996% ( 22, 34 ] 18 0.001% 99.997% ( 34, 51 ] 9 0.001% 99.998% ( 51, 76 ] 7 0.000% 99.998% ( 76, 110 ] 111 0.006% 100.004% ( 110, 170 ] 209 0.012% 100.016% ( 170, 250 ] 97 0.005% 100.021% ( 250, 380 ] 64 0.004% 100.025% ( 380, 580 ] 82 0.005% 100.030% ( 580, 870 ] 49 0.003% 100.032% ( 870, 1300 ] 28 0.002% 100.034% ( 1300, 1900 ] 6 0.000% 100.034% ( 1900, 2900 ] 12 0.001% 100.035% ( 2900, 4400 ] 5 0.000% 100.035% ( 4400, 6600 ] 1 0.000% 100.035% ** Level 1 read latency histogram (micros): Count: 364732 Average: 2.9676 StdDev: 18.99 Min: 0 Median: 1.6785 Max: 5389 Percentiles: P50: 1.68 P75: 2.31 P99: 8.18 P99.9: 14.86 P99.99: 153.52 ------------------------------------------------------ [ 0, 1 ] 29290 8.031% 8.031% ## ( 1, 2 ] 225593 61.852% 69.882% ############ ( 2, 3 ] 60608 16.617% 86.499% ### ( 3, 4 ] 21199 5.812% 92.312% # ( 4, 6 ] 21397 5.866% 98.178% # ( 6, 10 ] 5508 1.510% 99.688% ( 10, 15 ] 794 0.218% 99.906% ( 15, 22 ] 59 0.016% 99.922% ( 22, 34 ] 4 0.001% 99.923% ( 34, 51 ] 2 0.001% 99.924% ( 51, 76 ] 2 0.001% 99.924% ( 76, 110 ] 93 0.025% 99.950% ( 110, 170 ] 202 0.055% 100.005% ( 170, 250 ] 102 0.028% 100.033% ( 250, 380 ] 60 0.016% 100.050% ( 380, 580 ] 74 0.020% 100.070% ( 580, 870 ] 24 0.007% 100.076% ( 870, 1300 ] 13 0.004% 100.080% ( 1300, 1900 ] 6 0.002% 100.082% ( 1900, 2900 ] 4 0.001% 100.083% ( 2900, 4400 ] 1 0.000% 100.083% ( 4400, 6600 ] 1 0.000% 100.083% ** Level 2 read latency histogram (micros): Count: 111926 Average: 2.2907 StdDev: 12.13 Min: 1 Median: 1.4739 Max: 2533 Percentiles: P50: 1.47 P75: 1.86 P99: 5.89 P99.9: 13.65 P99.99: 440.25 ------------------------------------------------------ [ 0, 1 ] 21898 19.565% 19.565% #### ( 1, 2 ] 71889 64.229% 83.794% ############# ( 2, 3 ] 9954 8.893% 92.687% ## ( 3, 4 ] 4182 3.736% 96.424% # ( 4, 6 ] 3057 2.731% 99.155% # ( 6, 10 ] 767 0.685% 99.840% ( 10, 15 ] 92 0.082% 99.922% ( 15, 22 ] 9 0.008% 99.930% ( 22, 34 ] 2 0.002% 99.932% ( 51, 76 ] 1 0.001% 99.933% ( 76, 110 ] 26 0.023% 99.956% ( 110, 170 ] 19 0.017% 99.973% ( 170, 250 ] 9 0.008% 99.981% ( 250, 380 ] 8 0.007% 99.988% ( 380, 580 ] 6 0.005% 99.994% ( 580, 870 ] 2 0.002% 99.996% ( 870, 1300 ] 3 0.003% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 239473 Average: 3.6378 StdDev: 61.04 Min: 0 Median: 1.6263 Max: 10535 Percentiles: P50: 1.63 P75: 2.06 P99: 8.78 P99.9: 185.02 P99.99: 557.95 ------------------------------------------------------ [ 0, 1 ] 23041 9.622% 9.622% ## ( 1, 2 ] 154388 64.470% 74.091% ############# ( 2, 3 ] 34956 14.597% 88.688% ### ( 3, 4 ] 12099 5.052% 93.741% # ( 4, 6 ] 10025 4.186% 97.927% # ( 6, 10 ] 3693 1.542% 99.469% ( 10, 15 ] 626 0.261% 99.731% ( 15, 22 ] 59 0.025% 99.755% ( 22, 34 ] 9 0.004% 99.759% ( 34, 51 ] 3 0.001% 99.760% ( 51, 76 ] 1 0.000% 99.761% ( 76, 110 ] 80 0.033% 99.794% ( 110, 170 ] 231 0.096% 99.891% ( 170, 250 ] 120 0.050% 99.941% ( 250, 380 ] 62 0.026% 99.967% ( 380, 580 ] 63 0.026% 99.993% ( 580, 870 ] 29 0.012% 100.005% ( 870, 1300 ] 21 0.009% 100.014% ( 1300, 1900 ] 14 0.006% 100.020% ( 1900, 2900 ] 3 0.001% 100.021% ( 2900, 4400 ] 4 0.002% 100.023% ( 4400, 6600 ] 6 0.003% 100.025% ( 6600, 9900 ] 6 0.003% 100.028% ( 9900, 14000 ] 1 0.000% 100.028% ** Level 4 read latency histogram (micros): Count: 320 Average: 387.3188 StdDev: 1404.94 Min: 1 Median: 2.2787 Max: 9893 Percentiles: P50: 2.28 P75: 6.00 P99: 8140.00 P99.9: 9724.00 P99.99: 9882.40 ------------------------------------------------------ [ 0, 1 ] 41 12.812% 12.812% ### ( 1, 2 ] 102 31.875% 44.688% ###### ( 2, 3 ] 61 19.062% 63.750% #### ( 3, 4 ] 16 5.000% 68.750% # ( 4, 6 ] 20 6.250% 75.000% # ( 6, 10 ] 6 1.875% 76.875% ( 10, 15 ] 15 4.688% 81.562% # ( 15, 22 ] 17 5.312% 86.875% # ( 22, 34 ] 6 1.875% 88.750% ( 110, 170 ] 1 0.312% 89.062% ( 170, 250 ] 2 0.625% 89.688% ( 250, 380 ] 2 0.625% 90.312% ( 870, 1300 ] 5 1.562% 91.875% ( 1300, 1900 ] 4 1.250% 93.125% ( 1900, 2900 ] 2 0.625% 93.750% ( 2900, 4400 ] 11 3.438% 97.188% # ( 4400, 6600 ] 3 0.938% 98.125% ( 6600, 9900 ] 6 1.875% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 956.8333 StdDev: 1125.37 Min: 93 Median: 361.4286 Max: 4861 Percentiles: P50: 361.43 P75: 1300.00 P99: 4861.00 P99.9: 4861.00 P99.99: 4861.00 ------------------------------------------------------ ( 76, 110 ] 1 1.667% 1.667% ( 110, 170 ] 14 23.333% 25.000% ##### ( 170, 250 ] 9 15.000% 40.000% ### ( 250, 380 ] 7 11.667% 51.667% ## ( 380, 580 ] 4 6.667% 58.333% # ( 580, 870 ] 4 6.667% 65.000% # ( 870, 1300 ] 6 10.000% 75.000% ## ( 1300, 1900 ] 3 5.000% 80.000% # ( 1900, 2900 ] 7 11.667% 91.667% ## ( 2900, 4400 ] 4 6.667% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 19.9 total, 3.4 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 297.14 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:3.671 H:M:S, 18.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 286.99 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.835 H:M:S, 24.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 0 2024/12/14-14:26:55 ... thread 0: (1000000,7000000) ops and (119493.6,249670.2) ops/second in (8.368646,28.036984) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/15 3.93 GB 169.5 5.5 0.0 5.5 12.0 6.6 0.0 1.8 136.6 300.7 41.03 38.37 115 0.357 5692K 9078 0.0 0.0 L1 13/13 1.55 GB 0.0 2.6 2.4 0.2 2.6 2.4 0.2 1.1 224.0 222.9 11.91 11.51 3 3.971 2710K 13K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 253.6 253.4 1.49 1.44 2 0.745 383K 177 0.0 0.0 L3 22/0 912.00 MB 0.9 1.9 0.8 1.1 1.9 0.8 0.4 2.5 222.0 221.5 8.73 8.13 6 1.455 1968K 4115 0.0 0.0 L4 174/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 151.7 151.7 1.48 1.11 1 1.481 228K 0 0.0 0.0 L5 1056/0 86.80 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1284/28 102.69 GB 0.0 10.6 3.6 7.0 17.1 10.1 3.4 2.6 167.3 271.1 64.65 60.56 127 0.509 10M 26K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.6 3.6 7.0 17.1 10.1 3.3 2.6 167.3 271.1 64.65 60.56 127 0.509 10M 26K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 10.6 3.6 7.0 10.5 3.5 0.0 0.0 238.2 237.6 45.41 43.55 30 1.514 10M 26K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.6 6.6 0.0 0.0 0.0 350.3 19.24 17.01 97 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 28.2 total, 28.0 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 17.12 GB write, 620.71 MB/s write, 10.56 GB read, 383.00 MB/s read, 64.7 seconds Interval compaction: 17.12 GB write, 625.21 MB/s write, 10.56 GB read, 385.77 MB/s read, 64.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 19, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 19, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 19, total-stops: 17, interval: 36 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2523432 Average: 2.4029 StdDev: 13.02 Min: 0 Median: 1.5302 Max: 4689 Percentiles: P50: 1.53 P75: 1.90 P99: 5.86 P99.9: 13.28 P99.99: 155.95 ------------------------------------------------------ [ 0, 1 ] 354683 14.056% 14.056% ### ( 1, 2 ] 1710713 67.793% 81.849% ############## ( 2, 3 ] 282122 11.180% 93.029% ## ( 3, 4 ] 88867 3.522% 96.550% # ( 4, 6 ] 66363 2.630% 99.180% # ( 6, 10 ] 16931 0.671% 99.851% ( 10, 15 ] 1875 0.074% 99.926% ( 15, 22 ] 273 0.011% 99.936% ( 22, 34 ] 22 0.001% 99.937% ( 34, 51 ] 12 0.000% 99.938% ( 51, 76 ] 9 0.000% 99.938% ( 76, 110 ] 567 0.022% 99.961% ( 110, 170 ] 971 0.038% 99.999% ( 170, 250 ] 300 0.012% 100.011% ( 250, 380 ] 180 0.007% 100.018% ( 380, 580 ] 179 0.007% 100.025% ( 580, 870 ] 85 0.003% 100.029% ( 870, 1300 ] 45 0.002% 100.030% ( 1300, 1900 ] 7 0.000% 100.031% ( 1900, 2900 ] 12 0.000% 100.031% ( 2900, 4400 ] 11 0.000% 100.032% ( 4400, 6600 ] 2 0.000% 100.032% ** Level 1 read latency histogram (micros): Count: 554465 Average: 2.8487 StdDev: 17.59 Min: 0 Median: 1.6167 Max: 5389 Percentiles: P50: 1.62 P75: 2.01 P99: 8.25 P99.9: 104.16 P99.99: 176.95 ------------------------------------------------------ [ 0, 1 ] 55902 10.082% 10.082% ## ( 1, 2 ] 358867 64.723% 74.805% ############# ( 2, 3 ] 78299 14.122% 88.927% ### ( 3, 4 ] 26231 4.731% 93.658% # ( 4, 6 ] 24803 4.473% 98.131% # ( 6, 10 ] 8551 1.542% 99.673% ( 10, 15 ] 932 0.168% 99.841% ( 15, 22 ] 97 0.017% 99.859% ( 22, 34 ] 6 0.001% 99.860% ( 34, 51 ] 3 0.001% 99.860% ( 51, 76 ] 5 0.001% 99.861% ( 76, 110 ] 259 0.047% 99.908% ( 110, 170 ] 443 0.080% 99.988% ( 170, 250 ] 133 0.024% 100.012% ( 250, 380 ] 90 0.016% 100.028% ( 380, 580 ] 89 0.016% 100.044% ( 580, 870 ] 29 0.005% 100.049% ( 870, 1300 ] 15 0.003% 100.052% ( 1300, 1900 ] 7 0.001% 100.053% ( 1900, 2900 ] 4 0.001% 100.054% ( 2900, 4400 ] 3 0.001% 100.055% ( 4400, 6600 ] 1 0.000% 100.055% ** Level 2 read latency histogram (micros): Count: 111926 Average: 2.2907 StdDev: 12.13 Min: 1 Median: 1.4739 Max: 2533 Percentiles: P50: 1.47 P75: 1.86 P99: 5.89 P99.9: 13.65 P99.99: 440.25 ------------------------------------------------------ [ 0, 1 ] 21898 19.565% 19.565% #### ( 1, 2 ] 71889 64.229% 83.794% ############# ( 2, 3 ] 9954 8.893% 92.687% ## ( 3, 4 ] 4182 3.736% 96.424% # ( 4, 6 ] 3057 2.731% 99.155% # ( 6, 10 ] 767 0.685% 99.840% ( 10, 15 ] 92 0.082% 99.922% ( 15, 22 ] 9 0.008% 99.930% ( 22, 34 ] 2 0.002% 99.932% ( 51, 76 ] 1 0.001% 99.933% ( 76, 110 ] 26 0.023% 99.956% ( 110, 170 ] 19 0.017% 99.973% ( 170, 250 ] 9 0.008% 99.981% ( 250, 380 ] 8 0.007% 99.988% ( 380, 580 ] 6 0.005% 99.994% ( 580, 870 ] 2 0.002% 99.996% ( 870, 1300 ] 3 0.003% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 239473 Average: 3.6378 StdDev: 61.04 Min: 0 Median: 1.6263 Max: 10535 Percentiles: P50: 1.63 P75: 2.06 P99: 8.78 P99.9: 185.02 P99.99: 557.95 ------------------------------------------------------ [ 0, 1 ] 23041 9.622% 9.622% ## ( 1, 2 ] 154388 64.470% 74.091% ############# ( 2, 3 ] 34956 14.597% 88.688% ### ( 3, 4 ] 12099 5.052% 93.741% # ( 4, 6 ] 10025 4.186% 97.927% # ( 6, 10 ] 3693 1.542% 99.469% ( 10, 15 ] 626 0.261% 99.731% ( 15, 22 ] 59 0.025% 99.755% ( 22, 34 ] 9 0.004% 99.759% ( 34, 51 ] 3 0.001% 99.760% ( 51, 76 ] 1 0.000% 99.761% ( 76, 110 ] 80 0.033% 99.794% ( 110, 170 ] 231 0.096% 99.891% ( 170, 250 ] 120 0.050% 99.941% ( 250, 380 ] 62 0.026% 99.967% ( 380, 580 ] 63 0.026% 99.993% ( 580, 870 ] 29 0.012% 100.005% ( 870, 1300 ] 21 0.009% 100.014% ( 1300, 1900 ] 14 0.006% 100.020% ( 1900, 2900 ] 3 0.001% 100.021% ( 2900, 4400 ] 4 0.002% 100.023% ( 4400, 6600 ] 6 0.003% 100.025% ( 6600, 9900 ] 6 0.003% 100.028% ( 9900, 14000 ] 1 0.000% 100.028% ** Level 4 read latency histogram (micros): Count: 320 Average: 387.3188 StdDev: 1404.94 Min: 1 Median: 2.2787 Max: 9893 Percentiles: P50: 2.28 P75: 6.00 P99: 8140.00 P99.9: 9724.00 P99.99: 9882.40 ------------------------------------------------------ [ 0, 1 ] 41 12.812% 12.812% ### ( 1, 2 ] 102 31.875% 44.688% ###### ( 2, 3 ] 61 19.062% 63.750% #### ( 3, 4 ] 16 5.000% 68.750% # ( 4, 6 ] 20 6.250% 75.000% # ( 6, 10 ] 6 1.875% 76.875% ( 10, 15 ] 15 4.688% 81.562% # ( 15, 22 ] 17 5.312% 86.875% # ( 22, 34 ] 6 1.875% 88.750% ( 110, 170 ] 1 0.312% 89.062% ( 170, 250 ] 2 0.625% 89.688% ( 250, 380 ] 2 0.625% 90.312% ( 870, 1300 ] 5 1.562% 91.875% ( 1300, 1900 ] 4 1.250% 93.125% ( 1900, 2900 ] 2 0.625% 93.750% ( 2900, 4400 ] 11 3.438% 97.188% # ( 4400, 6600 ] 3 0.938% 98.125% ( 6600, 9900 ] 6 1.875% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 956.8333 StdDev: 1125.37 Min: 93 Median: 361.4286 Max: 4861 Percentiles: P50: 361.43 P75: 1300.00 P99: 4861.00 P99.9: 4861.00 P99.99: 4861.00 ------------------------------------------------------ ( 76, 110 ] 1 1.667% 1.667% ( 110, 170 ] 14 23.333% 25.000% ##### ( 170, 250 ] 9 15.000% 40.000% ### ( 250, 380 ] 7 11.667% 51.667% ## ( 380, 580 ] 4 6.667% 58.333% # ( 580, 870 ] 4 6.667% 65.000% # ( 870, 1300 ] 6 10.000% 75.000% ## ( 1300, 1900 ] 3 5.000% 80.000% # ( 1900, 2900 ] 7 11.667% 91.667% ## ( 2900, 4400 ] 4 6.667% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 28.2 total, 8.4 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 243.94 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:9.240 H:M:S, 32.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 117.60 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:5.570 H:M:S, 66.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/14-14:27:06 ... thread 0: (1000000,8000000) ops and (90901.0,204928.8) ops/second in (11.000974,39.037958) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/10 2.88 GB 6.3 7.0 0.0 7.0 14.6 7.6 0.0 1.9 138.4 287.6 51.87 47.16 134 0.387 7290K 12K 0.0 0.0 L1 16/16 1.34 GB 0.0 6.2 4.4 1.8 6.1 4.4 0.2 1.4 216.9 214.6 29.19 27.53 4 7.297 6428K 66K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 3.1 2.0 253.6 253.4 1.49 1.44 2 0.745 383K 177 0.0 0.0 L3 27/4 1.21 GB 1.0 5.3 3.0 2.3 5.2 2.9 0.4 1.8 152.9 152.1 35.27 24.27 22 1.603 5476K 28K 0.0 0.0 L4 182/4 9.70 GB 1.0 2.1 2.0 0.1 2.1 2.0 0.8 1.0 151.1 150.8 14.44 10.44 28 0.516 2168K 2709 0.0 0.0 L5 1076/0 88.46 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1312/34 103.59 GB 0.0 21.0 9.6 11.4 28.4 17.0 7.2 3.8 162.3 220.0 132.26 110.83 190 0.696 21M 110K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.0 9.6 11.4 28.4 17.0 7.2 3.8 162.3 220.0 132.26 110.83 190 0.696 21M 110K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 21.0 9.6 11.4 20.8 9.5 0.0 0.0 195.3 194.3 109.90 91.22 78 1.409 21M 110K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.6 7.6 0.0 0.0 0.0 346.6 22.35 19.61 112 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 39.2 total, 39.0 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 28.42 GB write, 741.51 MB/s write, 20.96 GB read, 546.92 MB/s read, 132.3 seconds Interval compaction: 28.42 GB write, 745.37 MB/s write, 20.96 GB read, 549.77 MB/s read, 132.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 26, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 26, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 22, pending-compaction-bytes-delays: 36, pending-compaction-bytes-stops: 0, total-delays: 62, total-stops: 22, interval: 84 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3186961 Average: 2.7717 StdDev: 22.92 Min: 0 Median: 1.5488 Max: 8389 Percentiles: P50: 1.55 P75: 1.92 P99: 7.00 P99.9: 131.70 P99.99: 296.42 ------------------------------------------------------ [ 0, 1 ] 430050 13.494% 13.494% ### ( 1, 2 ] 2119863 66.517% 80.011% ############# ( 2, 3 ] 372565 11.690% 91.701% ## ( 3, 4 ] 124005 3.891% 95.592% # ( 4, 6 ] 101480 3.184% 98.776% # ( 6, 10 ] 28604 0.898% 99.674% ( 10, 15 ] 3632 0.114% 99.788% ( 15, 22 ] 438 0.014% 99.802% ( 22, 34 ] 31 0.001% 99.803% ( 34, 51 ] 21 0.001% 99.803% ( 51, 76 ] 190 0.006% 99.809% ( 76, 110 ] 1842 0.058% 99.867% ( 110, 170 ] 2914 0.091% 99.958% ( 170, 250 ] 823 0.026% 99.984% ( 250, 380 ] 519 0.016% 100.001% ( 380, 580 ] 422 0.013% 100.014% ( 580, 870 ] 246 0.008% 100.021% ( 870, 1300 ] 115 0.004% 100.025% ( 1300, 1900 ] 28 0.001% 100.026% ( 1900, 2900 ] 30 0.001% 100.027% ( 2900, 4400 ] 39 0.001% 100.028% ( 4400, 6600 ] 12 0.000% 100.028% ( 6600, 9900 ] 3 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 1250863 Average: 4.5228 StdDev: 65.25 Min: 0 Median: 1.7709 Max: 9516 Percentiles: P50: 1.77 P75: 2.66 P99: 9.32 P99.9: 95.68 P99.99: 209.46 ------------------------------------------------------ [ 0, 1 ] 83090 6.643% 6.643% # ( 1, 2 ] 703513 56.242% 62.885% ########### ( 2, 3 ] 229759 18.368% 81.253% #### ( 3, 4 ] 92992 7.434% 88.687% # ( 4, 6 ] 105301 8.418% 97.105% ## ( 6, 10 ] 28540 2.282% 99.387% ( 10, 15 ] 5481 0.438% 99.825% ( 15, 22 ] 521 0.042% 99.867% ( 22, 34 ] 49 0.004% 99.871% ( 34, 51 ] 10 0.001% 99.872% ( 51, 76 ] 76 0.006% 99.878% ( 76, 110 ] 484 0.039% 99.916% ( 110, 170 ] 770 0.062% 99.978% ( 170, 250 ] 308 0.025% 100.002% ( 250, 380 ] 332 0.027% 100.029% ( 380, 580 ] 427 0.034% 100.063% ( 580, 870 ] 350 0.028% 100.091% ( 870, 1300 ] 248 0.020% 100.111% ( 1300, 1900 ] 120 0.010% 100.121% ( 1900, 2900 ] 91 0.007% 100.128% ( 2900, 4400 ] 133 0.011% 100.138% ( 4400, 6600 ] 40 0.003% 100.142% ( 6600, 9900 ] 18 0.001% 100.143% ** Level 2 read latency histogram (micros): Count: 111926 Average: 2.2907 StdDev: 12.13 Min: 1 Median: 1.4739 Max: 2533 Percentiles: P50: 1.47 P75: 1.86 P99: 5.89 P99.9: 13.65 P99.99: 440.25 ------------------------------------------------------ [ 0, 1 ] 21898 19.565% 19.565% #### ( 1, 2 ] 71889 64.229% 83.794% ############# ( 2, 3 ] 9954 8.893% 92.687% ## ( 3, 4 ] 4182 3.736% 96.424% # ( 4, 6 ] 3057 2.731% 99.155% # ( 6, 10 ] 767 0.685% 99.840% ( 10, 15 ] 92 0.082% 99.922% ( 15, 22 ] 9 0.008% 99.930% ( 22, 34 ] 2 0.002% 99.932% ( 51, 76 ] 1 0.001% 99.933% ( 76, 110 ] 26 0.023% 99.956% ( 110, 170 ] 19 0.017% 99.973% ( 170, 250 ] 9 0.008% 99.981% ( 250, 380 ] 8 0.007% 99.988% ( 380, 580 ] 6 0.005% 99.994% ( 580, 870 ] 2 0.002% 99.996% ( 870, 1300 ] 3 0.003% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1072628 Average: 4.0519 StdDev: 51.97 Min: 0 Median: 1.9476 Max: 10535 Percentiles: P50: 1.95 P75: 2.97 P99: 8.90 P99.9: 13.98 P99.99: 16.82 ------------------------------------------------------ [ 0, 1 ] 33402 3.114% 3.114% # ( 1, 2 ] 530717 49.478% 52.592% ########## ( 2, 3 ] 248012 23.122% 75.714% ##### ( 3, 4 ] 108811 10.144% 85.858% ## ( 4, 6 ] 124181 11.577% 97.436% ## ( 6, 10 ] 23138 2.157% 99.593% ( 10, 15 ] 4144 0.386% 99.979% ( 15, 22 ] 449 0.042% 100.021% ( 22, 34 ] 52 0.005% 100.026% ( 34, 51 ] 13 0.001% 100.027% ( 51, 76 ] 51 0.005% 100.032% ( 76, 110 ] 119 0.011% 100.043% ( 110, 170 ] 285 0.027% 100.070% ( 170, 250 ] 269 0.025% 100.095% ( 250, 380 ] 268 0.025% 100.120% ( 380, 580 ] 249 0.023% 100.143% ( 580, 870 ] 217 0.020% 100.163% ( 870, 1300 ] 137 0.013% 100.176% ( 1300, 1900 ] 60 0.006% 100.181% ( 1900, 2900 ] 28 0.003% 100.184% ( 2900, 4400 ] 47 0.004% 100.188% ( 4400, 6600 ] 25 0.002% 100.191% ( 6600, 9900 ] 13 0.001% 100.192% ( 9900, 14000 ] 1 0.000% 100.192% ** Level 4 read latency histogram (micros): Count: 30478 Average: 60.2389 StdDev: 339.07 Min: 1 Median: 2.1549 Max: 9893 Percentiles: P50: 2.15 P75: 3.49 P99: 1244.74 P99.9: 4442.53 P99.99: 6885.66 ------------------------------------------------------ [ 0, 1 ] 790 2.592% 2.592% # ( 1, 2 ] 13380 43.901% 46.493% ######### ( 2, 3 ] 6902 22.646% 69.138% ##### ( 3, 4 ] 3627 11.900% 81.039% ## ( 4, 6 ] 2737 8.980% 90.019% ## ( 6, 10 ] 622 2.041% 92.060% ( 10, 15 ] 277 0.909% 92.969% ( 15, 22 ] 45 0.148% 93.116% ( 22, 34 ] 11 0.036% 93.152% ( 34, 51 ] 4 0.013% 93.166% ( 51, 76 ] 2 0.007% 93.172% ( 76, 110 ] 16 0.052% 93.225% ( 110, 170 ] 144 0.472% 93.697% ( 170, 250 ] 240 0.787% 94.485% ( 250, 380 ] 273 0.896% 95.380% ( 380, 580 ] 412 1.352% 96.732% ( 580, 870 ] 435 1.427% 98.159% ( 870, 1300 ] 294 0.965% 99.124% ( 1300, 1900 ] 108 0.354% 99.478% ( 1900, 2900 ] 60 0.197% 99.675% ( 2900, 4400 ] 68 0.223% 99.898% ( 4400, 6600 ] 27 0.089% 99.987% ( 6600, 9900 ] 11 0.036% 100.023% ** Level 5 read latency histogram (micros): Count: 160 Average: 1192.4938 StdDev: 1291.71 Min: 85 Median: 580.0000 Max: 5063 Percentiles: P50: 580.00 P75: 1962.50 P99: 5063.00 P99.9: 5063.00 P99.99: 5063.00 ------------------------------------------------------ ( 76, 110 ] 3 1.875% 1.875% ( 110, 170 ] 23 14.375% 16.250% ### ( 170, 250 ] 25 15.625% 31.875% ### ( 250, 380 ] 14 8.750% 40.625% ## ( 380, 580 ] 15 9.375% 50.000% ## ( 580, 870 ] 15 9.375% 59.375% ## ( 870, 1300 ] 15 9.375% 68.750% ## ( 1300, 1900 ] 9 5.625% 74.375% # ( 1900, 2900 ] 16 10.000% 84.375% ## ( 2900, 4400 ] 22 13.750% 98.125% ### ( 4400, 6600 ] 3 1.875% 100.000% ** DB Stats ** Uptime(secs): 39.2 total, 11.0 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 200.64 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:17.171 H:M:S, 43.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 89.46 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:7.931 H:M:S, 72.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 6 num-running-flushes: 1 2024/12/14-14:27:09 ... thread 0: (1000000,9000000) ops and (323790.8,213642.9) ops/second in (3.088414,42.126372) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/10 3.80 GB 100.7 7.9 0.0 7.9 16.3 8.5 0.0 1.9 138.6 287.9 58.16 52.97 150 0.388 8185K 13K 0.0 0.0 L1 16/16 1.34 GB 0.0 6.2 4.4 1.8 6.1 4.4 0.2 1.4 216.9 214.6 29.19 27.53 4 7.297 6428K 66K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 3.1 2.0 253.6 253.4 1.49 1.44 2 0.745 383K 177 0.0 0.0 L3 23/0 966.15 MB 1.0 5.3 3.0 2.3 5.2 2.9 0.4 1.8 152.9 152.1 35.27 24.27 22 1.603 5476K 28K 0.0 0.0 L4 182/0 9.66 GB 1.0 2.4 2.3 0.1 2.4 2.3 0.8 1.0 153.5 153.2 16.10 11.81 32 0.503 2447K 2709 0.0 0.0 L5 1080/0 88.77 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1316/26 104.51 GB 0.0 22.1 9.9 12.2 30.5 18.2 7.5 3.6 161.4 222.6 140.21 118.02 210 0.668 22M 111K 0.0 0.0 Int 0/0 0.00 KB 0.0 22.1 9.9 12.2 30.5 18.2 7.5 3.6 161.4 222.6 140.21 118.02 210 0.668 22M 111K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 22.1 9.9 12.2 22.0 9.7 0.0 0.0 196.8 195.8 115.04 95.99 85 1.353 22M 111K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 0.0 0.0 0.0 345.4 25.17 22.03 125 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 42.3 total, 42.1 interval Flush(GB): cumulative 8.490, interval 8.490 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 30.48 GB write, 737.38 MB/s write, 22.10 GB read, 534.71 MB/s read, 140.2 seconds Interval compaction: 30.48 GB write, 740.93 MB/s write, 22.10 GB read, 537.29 MB/s read, 140.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 26, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 26, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 25, pending-compaction-bytes-delays: 36, pending-compaction-bytes-stops: 0, total-delays: 62, total-stops: 25, interval: 87 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3592311 Average: 2.7355 StdDev: 22.10 Min: 0 Median: 1.5509 Max: 8389 Percentiles: P50: 1.55 P75: 1.93 P99: 6.92 P99.9: 123.46 P99.99: 253.29 ------------------------------------------------------ [ 0, 1 ] 475966 13.250% 13.250% ### ( 1, 2 ] 2396226 66.704% 79.954% ############# ( 2, 3 ] 425057 11.832% 91.786% ## ( 3, 4 ] 138660 3.860% 95.646% # ( 4, 6 ] 113012 3.146% 98.792% # ( 6, 10 ] 32413 0.902% 99.694% ( 10, 15 ] 4088 0.114% 99.808% ( 15, 22 ] 473 0.013% 99.821% ( 22, 34 ] 37 0.001% 99.822% ( 34, 51 ] 25 0.001% 99.823% ( 51, 76 ] 196 0.005% 99.829% ( 76, 110 ] 1892 0.053% 99.881% ( 110, 170 ] 3013 0.084% 99.965% ( 170, 250 ] 882 0.025% 99.990% ( 250, 380 ] 544 0.015% 100.005% ( 380, 580 ] 446 0.012% 100.017% ( 580, 870 ] 264 0.007% 100.025% ( 870, 1300 ] 120 0.003% 100.028% ( 1300, 1900 ] 30 0.001% 100.029% ( 1900, 2900 ] 32 0.001% 100.030% ( 2900, 4400 ] 40 0.001% 100.031% ( 4400, 6600 ] 13 0.000% 100.031% ( 6600, 9900 ] 3 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 1250863 Average: 4.5228 StdDev: 65.25 Min: 0 Median: 1.7709 Max: 9516 Percentiles: P50: 1.77 P75: 2.66 P99: 9.32 P99.9: 95.68 P99.99: 209.46 ------------------------------------------------------ [ 0, 1 ] 83090 6.643% 6.643% # ( 1, 2 ] 703513 56.242% 62.885% ########### ( 2, 3 ] 229759 18.368% 81.253% #### ( 3, 4 ] 92992 7.434% 88.687% # ( 4, 6 ] 105301 8.418% 97.105% ## ( 6, 10 ] 28540 2.282% 99.387% ( 10, 15 ] 5481 0.438% 99.825% ( 15, 22 ] 521 0.042% 99.867% ( 22, 34 ] 49 0.004% 99.871% ( 34, 51 ] 10 0.001% 99.872% ( 51, 76 ] 76 0.006% 99.878% ( 76, 110 ] 484 0.039% 99.916% ( 110, 170 ] 770 0.062% 99.978% ( 170, 250 ] 308 0.025% 100.002% ( 250, 380 ] 332 0.027% 100.029% ( 380, 580 ] 427 0.034% 100.063% ( 580, 870 ] 350 0.028% 100.091% ( 870, 1300 ] 248 0.020% 100.111% ( 1300, 1900 ] 120 0.010% 100.121% ( 1900, 2900 ] 91 0.007% 100.128% ( 2900, 4400 ] 133 0.011% 100.138% ( 4400, 6600 ] 40 0.003% 100.142% ( 6600, 9900 ] 18 0.001% 100.143% ** Level 2 read latency histogram (micros): Count: 111926 Average: 2.2907 StdDev: 12.13 Min: 1 Median: 1.4739 Max: 2533 Percentiles: P50: 1.47 P75: 1.86 P99: 5.89 P99.9: 13.65 P99.99: 440.25 ------------------------------------------------------ [ 0, 1 ] 21898 19.565% 19.565% #### ( 1, 2 ] 71889 64.229% 83.794% ############# ( 2, 3 ] 9954 8.893% 92.687% ## ( 3, 4 ] 4182 3.736% 96.424% # ( 4, 6 ] 3057 2.731% 99.155% # ( 6, 10 ] 767 0.685% 99.840% ( 10, 15 ] 92 0.082% 99.922% ( 15, 22 ] 9 0.008% 99.930% ( 22, 34 ] 2 0.002% 99.932% ( 51, 76 ] 1 0.001% 99.933% ( 76, 110 ] 26 0.023% 99.956% ( 110, 170 ] 19 0.017% 99.973% ( 170, 250 ] 9 0.008% 99.981% ( 250, 380 ] 8 0.007% 99.988% ( 380, 580 ] 6 0.005% 99.994% ( 580, 870 ] 2 0.002% 99.996% ( 870, 1300 ] 3 0.003% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1083643 Average: 4.0424 StdDev: 51.76 Min: 0 Median: 1.9478 Max: 10535 Percentiles: P50: 1.95 P75: 2.97 P99: 8.89 P99.9: 13.97 P99.99: 16.74 ------------------------------------------------------ [ 0, 1 ] 33536 3.095% 3.095% # ( 1, 2 ] 536295 49.490% 52.585% ########## ( 2, 3 ] 250938 23.157% 75.742% ##### ( 3, 4 ] 109852 10.137% 85.879% ## ( 4, 6 ] 125340 11.567% 97.445% ## ( 6, 10 ] 23285 2.149% 99.594% ( 10, 15 ] 4176 0.385% 99.980% ( 15, 22 ] 454 0.042% 100.022% ( 22, 34 ] 52 0.005% 100.026% ( 34, 51 ] 13 0.001% 100.027% ( 51, 76 ] 51 0.005% 100.032% ( 76, 110 ] 119 0.011% 100.043% ( 110, 170 ] 285 0.026% 100.069% ( 170, 250 ] 269 0.025% 100.094% ( 250, 380 ] 268 0.025% 100.119% ( 380, 580 ] 249 0.023% 100.142% ( 580, 870 ] 217 0.020% 100.162% ( 870, 1300 ] 137 0.013% 100.175% ( 1300, 1900 ] 60 0.006% 100.180% ( 1900, 2900 ] 29 0.003% 100.183% ( 2900, 4400 ] 47 0.004% 100.187% ( 4400, 6600 ] 25 0.002% 100.190% ( 6600, 9900 ] 13 0.001% 100.191% ( 9900, 14000 ] 1 0.000% 100.191% ** Level 4 read latency histogram (micros): Count: 31146 Average: 59.2067 StdDev: 335.83 Min: 1 Median: 2.1478 Max: 9893 Percentiles: P50: 2.15 P75: 3.48 P99: 1239.57 P99.9: 4396.78 P99.99: 6865.62 ------------------------------------------------------ [ 0, 1 ] 811 2.604% 2.604% # ( 1, 2 ] 13719 44.047% 46.651% ######### ( 2, 3 ] 7059 22.664% 69.315% ##### ( 3, 4 ] 3694 11.860% 81.176% ## ( 4, 6 ] 2791 8.961% 90.137% ## ( 6, 10 ] 631 2.026% 92.163% ( 10, 15 ] 285 0.915% 93.078% ( 15, 22 ] 49 0.157% 93.235% ( 22, 34 ] 11 0.035% 93.270% ( 34, 51 ] 5 0.016% 93.286% ( 51, 76 ] 2 0.006% 93.293% ( 76, 110 ] 16 0.051% 93.344% ( 110, 170 ] 144 0.462% 93.807% ( 170, 250 ] 244 0.783% 94.590% ( 250, 380 ] 273 0.877% 95.467% ( 380, 580 ] 412 1.323% 96.789% ( 580, 870 ] 435 1.397% 98.186% ( 870, 1300 ] 295 0.947% 99.133% ( 1300, 1900 ] 111 0.356% 99.490% ( 1900, 2900 ] 60 0.193% 99.682% ( 2900, 4400 ] 68 0.218% 99.900% ( 4400, 6600 ] 27 0.087% 99.987% ( 6600, 9900 ] 11 0.035% 100.022% ** Level 5 read latency histogram (micros): Count: 180 Average: 1154.8444 StdDev: 1270.19 Min: 85 Median: 566.6667 Max: 5063 Percentiles: P50: 566.67 P75: 1900.00 P99: 5063.00 P99.9: 5063.00 P99.99: 5063.00 ------------------------------------------------------ ( 76, 110 ] 5 2.778% 2.778% # ( 110, 170 ] 26 14.444% 17.222% ### ( 170, 250 ] 28 15.556% 32.778% ### ( 250, 380 ] 17 9.444% 42.222% ## ( 380, 580 ] 15 8.333% 50.556% ## ( 580, 870 ] 18 10.000% 60.556% ## ( 870, 1300 ] 17 9.444% 70.000% ## ( 1300, 1900 ] 9 5.000% 75.000% # ( 1900, 2900 ] 19 10.556% 85.556% ## ( 2900, 4400 ] 23 12.778% 98.333% ### ( 4400, 6600 ] 3 1.667% 100.000% ** DB Stats ** Uptime(secs): 42.3 total, 3.1 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 209.25 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:17.595 H:M:S, 41.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 318.67 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.424 H:M:S, 13.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/14-14:27:26 ... thread 0: (1000000,10000000) ops and (56578.5,167221.5) ops/second in (17.674546,59.800918) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 7/4 2.33 GB 25.2 10.5 0.0 10.5 20.0 9.5 0.0 2.1 148.3 283.3 72.18 65.82 169 0.427 10M 23K 0.0 0.0 L1 17/17 2.03 GB 0.0 10.0 6.9 3.1 9.9 6.8 0.2 1.4 215.1 212.4 47.78 44.61 5 9.556 9042K 66K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 4.9 2.0 253.6 253.4 1.49 1.44 2 0.745 383K 177 0.0 0.0 L3 19/0 984.03 MB 1.0 7.7 4.2 3.5 7.6 4.2 0.9 1.8 155.3 154.3 50.70 36.01 32 1.584 7996K 48K 0.0 0.0 L4 177/0 9.71 GB 1.0 5.0 4.0 0.9 4.9 4.0 0.8 1.2 143.1 142.4 35.50 24.20 52 0.683 5011K 17K 0.0 0.0 L5 1100/0 90.43 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1320/21 105.45 GB 0.0 33.5 15.4 18.1 42.8 24.7 11.5 4.5 165.3 211.2 207.65 172.09 260 0.799 33M 156K 0.0 0.0 Int 0/0 0.00 KB 0.0 33.5 15.4 18.1 42.8 24.7 11.4 4.5 165.3 211.2 207.65 172.09 260 0.799 33M 156K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 33.5 15.4 18.1 33.3 15.1 0.0 0.0 191.7 190.5 178.97 147.27 121 1.479 33M 156K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.5 9.5 0.0 0.0 0.0 340.5 28.67 24.82 139 0.206 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 60.0 total, 59.8 interval Flush(GB): cumulative 9.536, interval 9.536 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 42.83 GB write, 730.83 MB/s write, 33.51 GB read, 571.84 MB/s read, 207.6 seconds Interval compaction: 42.83 GB write, 733.31 MB/s write, 33.51 GB read, 573.78 MB/s read, 207.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 26, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 26, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 34, pending-compaction-bytes-delays: 68, pending-compaction-bytes-stops: 0, total-delays: 94, total-stops: 34, interval: 128 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4782004 Average: 2.9329 StdDev: 28.79 Min: 0 Median: 1.5578 Max: 11051 Percentiles: P50: 1.56 P75: 1.94 P99: 7.60 P99.9: 142.55 P99.99: 344.10 ------------------------------------------------------ [ 0, 1 ] 629090 13.155% 13.155% ### ( 1, 2 ] 3158428 66.048% 79.204% ############# ( 2, 3 ] 575755 12.040% 91.244% ## ( 3, 4 ] 188794 3.948% 95.192% # ( 4, 6 ] 162321 3.394% 98.586% # ( 6, 10 ] 49374 1.032% 99.619% ( 10, 15 ] 6504 0.136% 99.755% ( 15, 22 ] 736 0.015% 99.770% ( 22, 34 ] 56 0.001% 99.771% ( 34, 51 ] 30 0.001% 99.772% ( 51, 76 ] 208 0.004% 99.776% ( 76, 110 ] 3162 0.066% 99.842% ( 110, 170 ] 5096 0.107% 99.949% ( 170, 250 ] 1351 0.028% 99.977% ( 250, 380 ] 859 0.018% 99.995% ( 380, 580 ] 752 0.016% 100.011% ( 580, 870 ] 436 0.009% 100.020% ( 870, 1300 ] 193 0.004% 100.024% ( 1300, 1900 ] 75 0.002% 100.025% ( 1900, 2900 ] 80 0.002% 100.027% ( 2900, 4400 ] 95 0.002% 100.029% ( 4400, 6600 ] 22 0.000% 100.030% ( 6600, 9900 ] 8 0.000% 100.030% ( 9900, 14000 ] 2 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 1929272 Average: 4.5081 StdDev: 62.29 Min: 0 Median: 1.7462 Max: 11939 Percentiles: P50: 1.75 P75: 2.63 P99: 9.50 P99.9: 134.69 P99.99: 297.53 ------------------------------------------------------ [ 0, 1 ] 165128 8.559% 8.559% ## ( 1, 2 ] 1071387 55.533% 64.092% ########### ( 2, 3 ] 335133 17.371% 81.463% ### ( 3, 4 ] 141641 7.342% 88.805% # ( 4, 6 ] 157984 8.189% 96.994% ## ( 6, 10 ] 44286 2.295% 99.289% ( 10, 15 ] 8846 0.459% 99.748% ( 15, 22 ] 900 0.047% 99.794% ( 22, 34 ] 83 0.004% 99.799% ( 34, 51 ] 26 0.001% 99.800% ( 51, 76 ] 122 0.006% 99.806% ( 76, 110 ] 1098 0.057% 99.863% ( 110, 170 ] 1722 0.089% 99.953% ( 170, 250 ] 511 0.026% 99.979% ( 250, 380 ] 580 0.030% 100.009% ( 380, 580 ] 682 0.035% 100.044% ( 580, 870 ] 601 0.031% 100.076% ( 870, 1300 ] 421 0.022% 100.097% ( 1300, 1900 ] 190 0.010% 100.107% ( 1900, 2900 ] 128 0.007% 100.114% ( 2900, 4400 ] 187 0.010% 100.124% ( 4400, 6600 ] 50 0.003% 100.126% ( 6600, 9900 ] 20 0.001% 100.127% ( 9900, 14000 ] 2 0.000% 100.127% ** Level 2 read latency histogram (micros): Count: 111926 Average: 2.2907 StdDev: 12.13 Min: 1 Median: 1.4739 Max: 2533 Percentiles: P50: 1.47 P75: 1.86 P99: 5.89 P99.9: 13.65 P99.99: 440.25 ------------------------------------------------------ [ 0, 1 ] 21898 19.565% 19.565% #### ( 1, 2 ] 71889 64.229% 83.794% ############# ( 2, 3 ] 9954 8.893% 92.687% ## ( 3, 4 ] 4182 3.736% 96.424% # ( 4, 6 ] 3057 2.731% 99.155% # ( 6, 10 ] 767 0.685% 99.840% ( 10, 15 ] 92 0.082% 99.922% ( 15, 22 ] 9 0.008% 99.930% ( 22, 34 ] 2 0.002% 99.932% ( 51, 76 ] 1 0.001% 99.933% ( 76, 110 ] 26 0.023% 99.956% ( 110, 170 ] 19 0.017% 99.973% ( 170, 250 ] 9 0.008% 99.981% ( 250, 380 ] 8 0.007% 99.988% ( 380, 580 ] 6 0.005% 99.994% ( 580, 870 ] 2 0.002% 99.996% ( 870, 1300 ] 3 0.003% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1824835 Average: 4.4047 StdDev: 53.57 Min: 0 Median: 1.9992 Max: 11444 Percentiles: P50: 2.00 P75: 3.09 P99: 9.07 P99.9: 14.33 P99.99: 19.75 ------------------------------------------------------ [ 0, 1 ] 42740 2.342% 2.342% ( 1, 2 ] 870414 47.698% 50.040% ########## ( 2, 3 ] 437401 23.969% 74.010% ##### ( 3, 4 ] 197342 10.814% 84.824% ## ( 4, 6 ] 227336 12.458% 97.282% ## ( 6, 10 ] 40899 2.241% 99.523% ( 10, 15 ] 7944 0.435% 99.958% ( 15, 22 ] 850 0.047% 100.005% ( 22, 34 ] 84 0.005% 100.010% ( 34, 51 ] 31 0.002% 100.011% ( 51, 76 ] 94 0.005% 100.016% ( 76, 110 ] 138 0.008% 100.024% ( 110, 170 ] 340 0.019% 100.043% ( 170, 250 ] 392 0.021% 100.064% ( 250, 380 ] 497 0.027% 100.091% ( 380, 580 ] 572 0.031% 100.123% ( 580, 870 ] 594 0.033% 100.155% ( 870, 1300 ] 394 0.022% 100.177% ( 1300, 1900 ] 161 0.009% 100.186% ( 1900, 2900 ] 75 0.004% 100.190% ( 2900, 4400 ] 105 0.006% 100.196% ( 4400, 6600 ] 38 0.002% 100.198% ( 6600, 9900 ] 14 0.001% 100.198% ( 9900, 14000 ] 2 0.000% 100.198% ** Level 4 read latency histogram (micros): Count: 247093 Average: 25.9471 StdDev: 227.07 Min: 1 Median: 2.0943 Max: 11943 Percentiles: P50: 2.09 P75: 3.33 P99: 719.67 P99.9: 2971.93 P99.99: 4122.19 ------------------------------------------------------ [ 0, 1 ] 4978 2.015% 2.015% ( 1, 2 ] 113129 45.784% 47.799% ######### ( 2, 3 ] 57654 23.333% 71.132% ##### ( 3, 4 ] 28933 11.709% 82.841% ## ( 4, 6 ] 28642 11.592% 94.432% ## ( 6, 10 ] 6083 2.462% 96.894% ( 10, 15 ] 1985 0.803% 97.698% ( 15, 22 ] 185 0.075% 97.772% ( 22, 34 ] 43 0.017% 97.790% ( 34, 51 ] 10 0.004% 97.794% ( 51, 76 ] 17 0.007% 97.801% ( 76, 110 ] 36 0.015% 97.815% ( 110, 170 ] 210 0.085% 97.900% ( 170, 250 ] 411 0.166% 98.067% ( 250, 380 ] 611 0.247% 98.314% ( 380, 580 ] 1094 0.443% 98.757% ( 580, 870 ] 1248 0.505% 99.262% ( 870, 1300 ] 898 0.363% 99.625% ( 1300, 1900 ] 429 0.174% 99.799% ( 1900, 2900 ] 236 0.096% 99.894% ( 2900, 4400 ] 290 0.117% 100.012% ( 4400, 6600 ] 89 0.036% 100.048% ( 6600, 9900 ] 29 0.012% 100.059% ( 9900, 14000 ] 3 0.001% 100.061% ** Level 5 read latency histogram (micros): Count: 280 Average: 1489.2929 StdDev: 1648.93 Min: 85 Median: 714.6429 Max: 9120 Percentiles: P50: 714.64 P75: 2542.86 P99: 6820.00 P99.9: 9120.00 P99.99: 9120.00 ------------------------------------------------------ ( 76, 110 ] 6 2.143% 2.143% ( 110, 170 ] 30 10.714% 12.857% ## ( 170, 250 ] 35 12.500% 25.357% ### ( 250, 380 ] 29 10.357% 35.714% ## ( 380, 580 ] 27 9.643% 45.357% ## ( 580, 870 ] 28 10.000% 55.357% ## ( 870, 1300 ] 21 7.500% 62.857% ## ( 1300, 1900 ] 16 5.714% 68.571% # ( 1900, 2900 ] 28 10.000% 78.571% ## ( 2900, 4400 ] 41 14.643% 93.214% ### ( 4400, 6600 ] 16 5.714% 98.929% # ( 6600, 9900 ] 3 1.071% 100.000% ** DB Stats ** Uptime(secs): 60.0 total, 17.7 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 164.02 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:31.919 H:M:S, 53.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 55.68 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:14.324 H:M:S, 81.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.954 micros/op 167962 ops/sec 60.002 seconds 10077999 operations; 162.7 MB/s Microseconds per write: Count: 10077999 Average: 5.9537 StdDev: 275.82 Min: 0 Median: 1.7604 Max: 359796 Percentiles: P50: 1.76 P75: 2.78 P99: 9.50 P99.9: 1158.43 P99.99: 2709.35 ------------------------------------------------------ [ 0, 1 ] 1237514 12.279% 12.279% ## ( 1, 2 ] 4999466 49.608% 61.887% ########## ( 2, 3 ] 1685704 16.727% 78.614% ### ( 3, 4 ] 1387480 13.767% 92.381% ### ( 4, 6 ] 549968 5.457% 97.838% # ( 6, 10 ] 133805 1.328% 99.166% ( 10, 15 ] 40263 0.400% 99.565% ( 15, 22 ] 9316 0.092% 99.658% ( 22, 34 ] 1540 0.015% 99.673% ( 34, 51 ] 206 0.002% 99.675% ( 51, 76 ] 28 0.000% 99.675% ( 76, 110 ] 7143 0.071% 99.746% ( 110, 170 ] 2646 0.026% 99.773% ( 170, 250 ] 266 0.003% 99.775% ( 250, 380 ] 163 0.002% 99.777% ( 380, 580 ] 27 0.000% 99.777% ( 580, 870 ] 17 0.000% 99.777% ( 870, 1300 ] 18440 0.183% 99.960% ( 1300, 1900 ] 177 0.002% 99.962% ( 1900, 2900 ] 3487 0.035% 99.997% ( 2900, 4400 ] 236 0.002% 99.999% ( 4400, 6600 ] 68 0.001% 100.000% ( 6600, 9900 ] 18 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 50000, 75000 ] 2 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 13 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 229073 rocksdb.compaction.key.drop.obsolete COUNT : 0 rocksdb.compaction.key.drop.range_del COUNT : 0 rocksdb.compaction.key.drop.user COUNT : 0 rocksdb.compaction.range_del.drop.obsolete COUNT : 0 rocksdb.compaction.optimized.del.drop.obsolete COUNT : 0 rocksdb.compaction.cancelled COUNT : 0 rocksdb.number.keys.written COUNT : 10077999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10400494968 rocksdb.bytes.read COUNT : 0 rocksdb.number.db.seek COUNT : 0 rocksdb.number.db.next COUNT : 0 rocksdb.number.db.prev COUNT : 0 rocksdb.number.db.seek.found COUNT : 0 rocksdb.number.db.next.found COUNT : 0 rocksdb.number.db.prev.found COUNT : 0 rocksdb.db.iter.bytes.read COUNT : 0 rocksdb.no.file.opens COUNT : 652 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31919306 rocksdb.db.mutex.wait.micros COUNT : 0 rocksdb.number.multiget.get COUNT : 0 rocksdb.number.multiget.keys.read COUNT : 0 rocksdb.number.multiget.bytes.read COUNT : 0 rocksdb.number.merge.failures COUNT : 0 rocksdb.bloom.filter.prefix.checked COUNT : 0 rocksdb.bloom.filter.prefix.useful COUNT : 0 rocksdb.number.reseeks.iteration COUNT : 0 rocksdb.getupdatessince.calls COUNT : 0 rocksdb.wal.synced COUNT : 0 rocksdb.wal.bytes COUNT : 0 rocksdb.write.self COUNT : 0 rocksdb.write.other COUNT : 0 rocksdb.write.wal COUNT : 0 rocksdb.compact.read.bytes COUNT : 36843324398 rocksdb.compact.write.bytes COUNT : 36606369044 rocksdb.flush.write.bytes COUNT : 10305015837 rocksdb.compact.read.marked.bytes COUNT : 0 rocksdb.compact.read.periodic.bytes COUNT : 0 rocksdb.compact.read.ttl.bytes COUNT : 0 rocksdb.compact.write.marked.bytes COUNT : 0 rocksdb.compact.write.periodic.bytes COUNT : 0 rocksdb.compact.write.ttl.bytes COUNT : 0 rocksdb.number.direct.load.table.properties COUNT : 66 rocksdb.number.superversion_acquires COUNT : 0 rocksdb.number.superversion_releases COUNT : 0 rocksdb.number.superversion_cleanups COUNT : 0 rocksdb.number.block.compressed COUNT : 0 rocksdb.number.block.decompressed COUNT : 0 rocksdb.number.block.not_compressed COUNT : 0 rocksdb.merge.operation.time.nanos COUNT : 0 rocksdb.filter.operation.time.nanos COUNT : 0 rocksdb.row.cache.hit COUNT : 0 rocksdb.row.cache.miss COUNT : 0 rocksdb.read.amp.estimate.useful.bytes COUNT : 0 rocksdb.read.amp.total.read.bytes COUNT : 0 rocksdb.number.rate_limiter.drains COUNT : 0 rocksdb.number.iter.skip COUNT : 0 rocksdb.blobdb.num.put COUNT : 0 rocksdb.blobdb.num.write COUNT : 0 rocksdb.blobdb.num.get COUNT : 0 rocksdb.blobdb.num.multiget COUNT : 0 rocksdb.blobdb.num.seek COUNT : 0 rocksdb.blobdb.num.next COUNT : 0 rocksdb.blobdb.num.prev COUNT : 0 rocksdb.blobdb.num.keys.written COUNT : 0 rocksdb.blobdb.num.keys.read COUNT : 0 rocksdb.blobdb.bytes.written COUNT : 0 rocksdb.blobdb.bytes.read COUNT : 0 rocksdb.blobdb.write.inlined COUNT : 0 rocksdb.blobdb.write.inlined.ttl COUNT : 0 rocksdb.blobdb.write.blob COUNT : 0 rocksdb.blobdb.write.blob.ttl COUNT : 0 rocksdb.blobdb.blob.file.bytes.written COUNT : 0 rocksdb.blobdb.blob.file.bytes.read COUNT : 0 rocksdb.blobdb.blob.file.synced COUNT : 0 rocksdb.blobdb.blob.index.expired.count COUNT : 0 rocksdb.blobdb.blob.index.expired.size COUNT : 0 rocksdb.blobdb.blob.index.evicted.count COUNT : 0 rocksdb.blobdb.blob.index.evicted.size COUNT : 0 rocksdb.blobdb.gc.num.files COUNT : 0 rocksdb.blobdb.gc.num.new.files COUNT : 0 rocksdb.blobdb.gc.failures COUNT : 0 rocksdb.blobdb.gc.num.keys.relocated COUNT : 0 rocksdb.blobdb.gc.bytes.relocated COUNT : 0 rocksdb.blobdb.fifo.num.files.evicted COUNT : 0 rocksdb.blobdb.fifo.num.keys.evicted COUNT : 0 rocksdb.blobdb.fifo.bytes.evicted COUNT : 0 rocksdb.txn.overhead.mutex.prepare COUNT : 0 rocksdb.txn.overhead.mutex.old.commit.map COUNT : 0 rocksdb.txn.overhead.duplicate.key COUNT : 0 rocksdb.txn.overhead.mutex.snapshot COUNT : 0 rocksdb.txn.get.tryagain COUNT : 0 rocksdb.number.multiget.keys.found COUNT : 0 rocksdb.num.iterator.created COUNT : 0 rocksdb.num.iterator.deleted COUNT : 0 rocksdb.block.cache.compression.dict.miss COUNT : 0 rocksdb.block.cache.compression.dict.hit COUNT : 0 rocksdb.block.cache.compression.dict.add COUNT : 0 rocksdb.block.cache.compression.dict.bytes.insert COUNT : 0 rocksdb.block.cache.add.redundant COUNT : 0 rocksdb.block.cache.index.add.redundant COUNT : 0 rocksdb.block.cache.filter.add.redundant COUNT : 0 rocksdb.block.cache.data.add.redundant COUNT : 0 rocksdb.block.cache.compression.dict.add.redundant COUNT : 0 rocksdb.files.marked.trash COUNT : 0 rocksdb.files.deleted.immediately COUNT : 330 rocksdb.error.handler.bg.errro.count COUNT : 0 rocksdb.error.handler.bg.io.errro.count COUNT : 0 rocksdb.error.handler.bg.retryable.io.errro.count COUNT : 0 rocksdb.error.handler.autoresume.count COUNT : 0 rocksdb.error.handler.autoresume.retry.total.count COUNT : 0 rocksdb.error.handler.autoresume.success.count COUNT : 0 rocksdb.memtable.payload.bytes.at.flush COUNT : 10221859840 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3912704 rocksdb.secondary.cache.hits COUNT : 0 rocksdb.verify_checksum.read.bytes COUNT : 0 rocksdb.backup.read.bytes COUNT : 0 rocksdb.backup.write.bytes COUNT : 0 rocksdb.remote.compact.read.bytes COUNT : 0 rocksdb.remote.compact.write.bytes COUNT : 0 rocksdb.hot.file.read.bytes COUNT : 0 rocksdb.warm.file.read.bytes COUNT : 0 rocksdb.cold.file.read.bytes COUNT : 0 rocksdb.hot.file.read.count COUNT : 0 rocksdb.warm.file.read.count COUNT : 0 rocksdb.cold.file.read.count COUNT : 0 rocksdb.last.level.read.bytes COUNT : 0 rocksdb.last.level.read.count COUNT : 0 rocksdb.non.last.level.read.bytes COUNT : 36943044787 rocksdb.non.last.level.read.count COUNT : 8925517 rocksdb.block.checksum.compute.count COUNT : 8924279 rocksdb.multiget.coroutine.count COUNT : 0 rocksdb.blobdb.cache.miss COUNT : 0 rocksdb.blobdb.cache.hit COUNT : 0 rocksdb.blobdb.cache.add COUNT : 0 rocksdb.blobdb.cache.add.failures COUNT : 0 rocksdb.blobdb.cache.bytes.read COUNT : 0 rocksdb.blobdb.cache.bytes.write COUNT : 0 rocksdb.read.async.micros COUNT : 0 rocksdb.async.read.error.count COUNT : 0 rocksdb.secondary.cache.filter.hits COUNT : 0 rocksdb.secondary.cache.index.hits COUNT : 0 rocksdb.secondary.cache.data.hits COUNT : 0 rocksdb.table.open.prefetch.tail.miss COUNT : 0 rocksdb.table.open.prefetch.tail.hit COUNT : 0 rocksdb.db.get.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.db.write.micros P50 : 1.419587 P95 : 3.936160 P99 : 8.202195 P100 : 359791.000000 COUNT : 10077999 SUM : 55224263 rocksdb.compaction.times.micros P50 : 1075769.230769 P95 : 3810000.000000 P99 : 17160000.000000 P100 : 18592644.000000 COUNT : 121 SUM : 178970524 rocksdb.compaction.times.cpu_micros P50 : 906750.000000 P95 : 3582500.000000 P99 : 17080911.000000 P100 : 17080911.000000 COUNT : 121 SUM : 147267545 rocksdb.subcompaction.setup.times.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.table.sync.micros P50 : 701.395349 P95 : 1242.666667 P99 : 18800.000000 P100 : 76803.000000 COUNT : 140 SUM : 203068 rocksdb.compaction.outfile.sync.micros P50 : 1226.808511 P95 : 159800.000000 P99 : 234533.333333 P100 : 1128510.000000 COUNT : 448 SUM : 10907911 rocksdb.wal.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.manifest.file.sync.micros P50 : 106.518072 P95 : 1212.346154 P99 : 3301.250000 P100 : 4333.000000 COUNT : 293 SUM : 92157 rocksdb.table.open.io.micros P50 : 1507.079646 P95 : 8705.714286 P99 : 20656.000000 P100 : 23779.000000 COUNT : 652 SUM : 1625942 rocksdb.db.multiget.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.read.block.compaction.micros P50 : 3.766102 P95 : 8.449416 P99 : 12.427764 P100 : 11948.000000 COUNT : 8922408 SUM : 56310482 rocksdb.read.block.get.micros P50 : 498.367347 P95 : 3995.000000 P99 : 7756.941176 P100 : 10793.000000 COUNT : 1304 SUM : 1309511 rocksdb.write.raw.block.micros P50 : 0.515006 P95 : 0.978512 P99 : 2.967187 P100 : 15273.000000 COUNT : 11362198 SUM : 22544189 rocksdb.numfiles.in.singlecompaction P50 : 2.906250 P95 : 5.957143 P99 : 19.795000 P100 : 24.000000 COUNT : 163 SUM : 583 rocksdb.db.seek.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.db.write.stall P50 : 0.556561 P95 : 1134.017530 P99 : 2354.029294 P100 : 359543.000000 COUNT : 221507 SUM : 31939148 rocksdb.sst.read.micros P50 : 1.679512 P95 : 5.155833 P99 : 9.079573 P100 : 11943.000000 COUNT : 8925734 SUM : 38021926 rocksdb.num.subcompactions.scheduled P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.bytes.per.read P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.bytes.per.write P50 : 1032.000000 P95 : 1032.000000 P99 : 1032.000000 P100 : 1032.000000 COUNT : 10077999 SUM : 10400494968 rocksdb.bytes.per.multiget P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.bytes.compressed P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.bytes.decompressed P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.compression.times.nanos P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.decompression.times.nanos P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.read.num.merge_operands P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.key.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.value.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.write.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.get.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.multiget.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.seek.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.next.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.prev.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.blob.file.write.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.blob.file.read.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.blob.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.compression.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.decompression.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.db.flush.micros P50 : 210800.000000 P95 : 345789.473684 P99 : 437000.000000 P100 : 527292.000000 COUNT : 140 SUM : 28845868 rocksdb.sst.batch.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.num.index.and.filter.blocks.read.per.level P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.num.sst.read.per.level P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.error.handler.autoresume.retry.count P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.async.read.bytes P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.poll.wait.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.prefetched.bytes.discarded P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 429 SUM : 0 rocksdb.multiget.io.batch.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.num.level.read.per.multiget P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.async.prefetch.abort.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.table.open.prefetch.tail.read.bytes P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0