[2024-12-07 16:46:30.753183] Starting SPDK v24.09.1-pre git sha1 b18e1bd62 / DPDK 22.11.4 initialization... [2024-12-07 16:46:30.753449] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=lib.power:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid963395 ] Set seed to 1733586390746583 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-07 16:46:30.852201] app.c: 917:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-07 16:46:30.894202] app.c: 610:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-07 16:46:30.894244] app.c: 611:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 963395' to capture a snapshot of events at runtime. [2024-12-07 16:46:30.894254] app.c: 616:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-07 16:46:30.894265] app.c: 617:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-07 16:46:30.894272] app.c: 618:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid963395 for offline analysis/debug. [2024-12-07 16:46:30.894352] reactor.c: 990:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sat Dec 7 16:46:35 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/07-16:46:38 ... thread 0: (1000000,1000000) ops and (328301.7,328301.7) ops/second in (3.045979,3.045979) 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 6/4 440.95 MB 18.9 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 345.4 2.55 2.30 12 0.213 0 0 0.0 0.0 L1 3/0 249.86 MB 25.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 248.4 248.2 1.01 0.98 1 1.014 255K 239 0.0 0.0 L2 3/2 190.77 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.1 1.5 245.3 245.2 0.78 0.75 2 0.392 195K 86 0.0 0.0 L3 9/0 741.23 MB 0.7 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.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1181/6 97.00 GB 0.0 0.4 0.4 0.1 1.3 1.2 1.0 1.5 102.1 304.7 4.35 4.03 15 0.290 451K 325 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.4 0.1 1.3 1.2 0.9 1.5 102.1 304.7 4.35 4.03 15 0.290 451K 325 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.4 0.1 0.4 0.4 0.0 0.0 247.1 246.9 1.80 1.73 3 0.600 451K 325 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 345.4 2.55 2.30 12 0.213 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.2 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 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.29 GB write, 409.19 MB/s write, 0.43 GB read, 137.13 MB/s read, 4.4 seconds Interval compaction: 1.29 GB write, 435.11 MB/s write, 0.43 GB read, 145.82 MB/s read, 4.4 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: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 157022 Average: 1.9191 StdDev: 14.35 Min: 0 Median: 1.2974 Max: 4255 Percentiles: P50: 1.30 P75: 1.72 P99: 4.87 P99.9: 9.44 P99.99: 125.57 ------------------------------------------------------ [ 0, 1 ] 50899 32.415% 32.415% ###### ( 1, 2 ] 92841 59.126% 91.541% ############ ( 2, 3 ] 7607 4.845% 96.386% # ( 3, 4 ] 3317 2.112% 98.498% ( 4, 6 ] 1807 1.151% 99.649% ( 6, 10 ] 459 0.292% 99.941% ( 10, 15 ] 64 0.041% 99.982% ( 15, 22 ] 9 0.006% 99.988% ( 22, 34 ] 2 0.001% 99.989% ( 76, 110 ] 1 0.001% 99.990% ( 110, 170 ] 5 0.003% 99.993% ( 170, 250 ] 9 0.006% 99.999% ( 250, 380 ] 5 0.003% 100.002% ( 380, 580 ] 1 0.001% 100.003% ( 870, 1300 ] 1 0.001% 100.003% ( 1300, 1900 ] 1 0.001% 100.004% ( 2900, 4400 ] 2 0.001% 100.005% ** Level 1 read latency histogram (micros): Count: 501 Average: 7.9421 StdDev: 56.17 Min: 1 Median: 1.9072 Max: 818 Percentiles: P50: 1.91 P75: 2.63 P99: 169.40 P99.9: 797.36 P99.99: 818.00 ------------------------------------------------------ [ 0, 1 ] 11 2.196% 2.196% ( 1, 2 ] 264 52.695% 54.890% ########### ( 2, 3 ] 160 31.936% 86.826% ###### ( 3, 4 ] 22 4.391% 91.218% # ( 4, 6 ] 29 5.788% 97.006% # ( 6, 10 ] 7 1.397% 98.403% ( 10, 15 ] 2 0.399% 98.802% ( 110, 170 ] 1 0.200% 99.002% ( 170, 250 ] 1 0.200% 99.202% ( 250, 380 ] 1 0.200% 99.401% ( 380, 580 ] 1 0.200% 99.601% ( 580, 870 ] 2 0.399% 100.000% ** Level 2 read latency histogram (micros): Count: 43270 Average: 2.5221 StdDev: 30.31 Min: 1 Median: 1.5150 Max: 4570 Percentiles: P50: 1.52 P75: 1.87 P99: 5.72 P99.9: 10.38 P99.99: 1264.85 ------------------------------------------------------ [ 0, 1 ] 6061 14.007% 14.007% ### ( 1, 2 ] 30239 69.884% 83.892% ############## ( 2, 3 ] 3947 9.122% 93.014% ## ( 3, 4 ] 1683 3.890% 96.903% # ( 4, 6 ] 1053 2.434% 99.337% ( 6, 10 ] 242 0.559% 99.896% ( 10, 15 ] 23 0.053% 99.949% ( 15, 22 ] 6 0.014% 99.963% ( 22, 34 ] 2 0.005% 99.968% ( 51, 76 ] 2 0.005% 99.972% ( 170, 250 ] 1 0.002% 99.975% ( 380, 580 ] 2 0.005% 99.979% ( 580, 870 ] 1 0.002% 99.982% ( 870, 1300 ] 4 0.009% 99.991% ( 1300, 1900 ] 2 0.005% 99.995% ( 2900, 4400 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 55 Average: 1877.2545 StdDev: 1710.38 Min: 90 Median: 1063.5000 Max: 6343 Percentiles: P50: 1063.50 P75: 2750.00 P99: 6343.00 P99.9: 6343.00 P99.99: 6343.00 ------------------------------------------------------ ( 76, 110 ] 1 1.818% 1.818% ( 170, 250 ] 2 3.636% 5.455% # ( 250, 380 ] 3 5.455% 10.909% # ( 380, 580 ] 2 3.636% 14.545% # ( 580, 870 ] 15 27.273% 41.818% ##### ( 870, 1300 ] 10 18.182% 60.000% #### ( 1300, 1900 ] 4 7.273% 67.273% # ( 1900, 2900 ] 5 9.091% 76.364% ## ( 2900, 4400 ] 7 12.727% 89.091% ### ( 4400, 6600 ] 6 10.909% 100.000% ## ** Level 4 read latency histogram (micros): Count: 15 Average: 1647.9333 StdDev: 1576.98 Min: 202 Median: 999.0000 Max: 5943 Percentiles: P50: 999.00 P75: 2150.00 P99: 5943.00 P99.9: 5943.00 P99.99: 5943.00 ------------------------------------------------------ ( 170, 250 ] 1 6.667% 6.667% # ( 380, 580 ] 2 13.333% 20.000% ### ( 580, 870 ] 3 20.000% 40.000% #### ( 870, 1300 ] 5 33.333% 73.333% ####### ( 1900, 2900 ] 1 6.667% 80.000% # ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 488.2500 StdDev: 542.15 Min: 95 Median: 156.6667 Max: 1746 Percentiles: P50: 156.67 P75: 580.00 P99: 1746.00 P99.9: 1746.00 P99.99: 1746.00 ------------------------------------------------------ ( 76, 110 ] 3 15.000% 15.000% ### ( 110, 170 ] 9 45.000% 60.000% ######### ( 380, 580 ] 3 15.000% 75.000% ### ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 1 5.000% 85.000% # ( 1300, 1900 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 3.2 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 303.70 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.411 H:M:S, 12.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 322.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.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/07-16:46:41 ... thread 0: (1000000,2000000) ops and (346950.6,337368.6) ops/second in (2.882255,5.928234) 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 1.35 GB 6.3 0.8 0.0 0.8 2.6 1.8 0.0 1.4 97.9 316.2 8.36 7.76 29 0.288 831K 856 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 248.4 248.2 1.01 0.98 1 1.014 255K 239 0.0 0.0 L2 1/0 3.38 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.3 1.5 245.3 245.2 0.78 0.75 2 0.392 195K 86 0.0 0.0 L3 33/0 985.19 MB 1.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 201.2 201.0 3.10 2.73 3 1.035 634K 499 0.0 0.0 L4 144/0 9.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1233/10 97.92 GB 0.0 1.8 0.8 1.0 3.6 2.6 1.4 2.0 142.3 279.8 13.27 12.21 35 0.379 1916K 1680 0.0 0.0 Int 0/0 0.00 KB 0.0 1.8 0.8 1.0 3.6 2.6 1.3 2.0 142.3 279.8 13.27 12.21 35 0.379 1916K 1680 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.8 0.8 1.0 1.8 0.8 0.0 0.0 235.8 235.5 8.01 7.50 9 0.890 1916K 1680 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 347.3 5.26 4.71 26 0.202 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.63 GB write, 606.45 MB/s write, 1.84 GB read, 308.36 MB/s read, 13.3 seconds Interval compaction: 3.63 GB write, 626.19 MB/s write, 1.84 GB read, 318.39 MB/s read, 13.3 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: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 389766 Average: 2.0591 StdDev: 14.67 Min: 0 Median: 1.3884 Max: 4255 Percentiles: P50: 1.39 P75: 1.79 P99: 5.37 P99.9: 9.93 P99.99: 20.33 ------------------------------------------------------ [ 0, 1 ] 100550 25.798% 25.798% ##### ( 1, 2 ] 242860 62.309% 88.107% ############ ( 2, 3 ] 27666 7.098% 95.205% # ( 3, 4 ] 10418 2.673% 97.878% # ( 4, 6 ] 6395 1.641% 99.518% ( 6, 10 ] 1514 0.388% 99.907% ( 10, 15 ] 306 0.079% 99.985% ( 15, 22 ] 25 0.006% 99.992% ( 22, 34 ] 7 0.002% 99.994% ( 34, 51 ] 2 0.001% 99.994% ( 51, 76 ] 1 0.000% 99.994% ( 76, 110 ] 1 0.000% 99.995% ( 110, 170 ] 13 0.003% 99.998% ( 170, 250 ] 14 0.004% 100.002% ( 250, 380 ] 10 0.003% 100.004% ( 380, 580 ] 1 0.000% 100.004% ( 580, 870 ] 6 0.002% 100.006% ( 870, 1300 ] 5 0.001% 100.007% ( 1300, 1900 ] 3 0.001% 100.008% ( 1900, 2900 ] 2 0.001% 100.008% ( 2900, 4400 ] 4 0.001% 100.009% ** Level 1 read latency histogram (micros): Count: 63913 Average: 2.4011 StdDev: 5.12 Min: 1 Median: 1.6333 Max: 818 Percentiles: P50: 1.63 P75: 2.05 P99: 5.94 P99.9: 12.03 P99.99: 18.58 ------------------------------------------------------ [ 0, 1 ] 5342 8.358% 8.358% ## ( 1, 2 ] 42022 65.749% 74.107% ############# ( 2, 3 ] 10550 16.507% 90.614% ### ( 3, 4 ] 2986 4.672% 95.286% # ( 4, 6 ] 2441 3.819% 99.105% # ( 6, 10 ] 472 0.739% 99.844% ( 10, 15 ] 89 0.139% 99.983% ( 15, 22 ] 9 0.014% 99.997% ( 22, 34 ] 2 0.003% 100.000% ( 34, 51 ] 3 0.005% 100.005% ( 110, 170 ] 1 0.002% 100.006% ( 170, 250 ] 1 0.002% 100.008% ( 250, 380 ] 1 0.002% 100.009% ( 380, 580 ] 1 0.002% 100.011% ( 580, 870 ] 2 0.003% 100.014% ** Level 2 read latency histogram (micros): Count: 47978 Average: 2.4921 StdDev: 28.78 Min: 1 Median: 1.5214 Max: 4570 Percentiles: P50: 1.52 P75: 1.88 P99: 5.71 P99.9: 10.00 P99.99: 1214.24 ------------------------------------------------------ [ 0, 1 ] 6556 13.665% 13.665% ### ( 1, 2 ] 33434 69.686% 83.351% ############## ( 2, 3 ] 4699 9.794% 93.145% ## ( 3, 4 ] 1831 3.816% 96.961% # ( 4, 6 ] 1144 2.384% 99.346% ( 6, 10 ] 266 0.554% 99.900% ( 10, 15 ] 26 0.054% 99.954% ( 15, 22 ] 6 0.013% 99.967% ( 22, 34 ] 2 0.004% 99.971% ( 51, 76 ] 2 0.004% 99.975% ( 170, 250 ] 1 0.002% 99.977% ( 380, 580 ] 2 0.004% 99.981% ( 580, 870 ] 1 0.002% 99.983% ( 870, 1300 ] 4 0.008% 99.992% ( 1300, 1900 ] 2 0.004% 99.996% ( 2900, 4400 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 47922 Average: 4.6285 StdDev: 86.39 Min: 0 Median: 1.6182 Max: 6343 Percentiles: P50: 1.62 P75: 2.00 P99: 7.05 P99.9: 433.90 P99.99: 3801.67 ------------------------------------------------------ [ 0, 1 ] 4514 9.419% 9.419% ## ( 1, 2 ] 31455 65.638% 75.057% ############# ( 2, 3 ] 7411 15.465% 90.522% ### ( 3, 4 ] 2263 4.722% 95.244% # ( 4, 6 ] 1704 3.556% 98.800% # ( 6, 10 ] 364 0.760% 99.560% ( 10, 15 ] 88 0.184% 99.743% ( 15, 22 ] 40 0.083% 99.827% ( 22, 34 ] 14 0.029% 99.856% ( 76, 110 ] 2 0.004% 99.860% ( 110, 170 ] 7 0.015% 99.875% ( 170, 250 ] 6 0.013% 99.887% ( 250, 380 ] 5 0.010% 99.898% ( 380, 580 ] 4 0.008% 99.906% ( 580, 870 ] 15 0.031% 99.937% ( 870, 1300 ] 12 0.025% 99.962% ( 1300, 1900 ] 4 0.008% 99.971% ( 1900, 2900 ] 5 0.010% 99.981% ( 2900, 4400 ] 7 0.015% 99.996% ( 4400, 6600 ] 6 0.013% 100.008% ** Level 4 read latency histogram (micros): Count: 15 Average: 1647.9333 StdDev: 1576.98 Min: 202 Median: 999.0000 Max: 5943 Percentiles: P50: 999.00 P75: 2150.00 P99: 5943.00 P99.9: 5943.00 P99.99: 5943.00 ------------------------------------------------------ ( 170, 250 ] 1 6.667% 6.667% # ( 380, 580 ] 2 13.333% 20.000% ### ( 580, 870 ] 3 20.000% 40.000% #### ( 870, 1300 ] 5 33.333% 73.333% ####### ( 1900, 2900 ] 1 6.667% 80.000% # ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 488.2500 StdDev: 542.15 Min: 95 Median: 156.6667 Max: 1746 Percentiles: P50: 156.67 P75: 580.00 P99: 1746.00 P99.9: 1746.00 P99.99: 1746.00 ------------------------------------------------------ ( 76, 110 ] 3 15.000% 15.000% ### ( 110, 170 ] 9 45.000% 60.000% ######### ( 380, 580 ] 3 15.000% 75.000% ### ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 1 5.000% 85.000% # ( 1300, 1900 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 6.1 total, 2.9 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 321.48 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.628 H:M:S, 10.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 341.47 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.217 H:M:S, 7.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/07-16:46:44 ... thread 0: (1000000,3000000) ops and (328212.0,334260.2) ops/second in (3.046811,8.975045) 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/10 2.34 GB 100.7 1.6 0.0 1.6 4.4 2.8 0.0 1.6 114.9 313.6 14.26 13.31 46 0.310 1663K 1727 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 248.4 248.2 1.01 0.98 1 1.014 255K 239 0.0 0.0 L2 1/0 3.38 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.3 1.5 245.3 245.2 0.78 0.75 2 0.392 195K 86 0.0 0.0 L3 33/0 985.19 MB 1.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 201.2 201.0 3.10 2.73 3 1.035 634K 499 0.0 0.0 L4 144/0 9.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1238/10 98.90 GB 0.0 2.6 0.8 1.8 5.4 3.6 1.4 2.0 141.3 289.1 19.16 17.77 52 0.368 2748K 2551 0.0 0.0 Int 0/0 0.00 KB 0.0 2.6 0.8 1.8 5.4 3.6 1.3 2.0 141.3 289.1 19.16 17.77 52 0.368 2748K 2551 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 2.6 0.8 1.8 2.6 0.8 0.0 0.0 244.9 244.7 11.05 10.49 12 0.921 2748K 2551 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 349.6 8.11 7.27 40 0.203 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.2 total, 9.0 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: 5.41 GB write, 604.08 MB/s write, 2.64 GB read, 295.21 MB/s read, 19.2 seconds Interval compaction: 5.41 GB write, 617.06 MB/s write, 2.64 GB read, 301.56 MB/s read, 19.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: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 9, interval: 9 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 804477 Average: 2.1034 StdDev: 11.76 Min: 0 Median: 1.4497 Max: 4255 Percentiles: P50: 1.45 P75: 1.83 P99: 5.29 P99.9: 9.56 P99.99: 14.10 ------------------------------------------------------ [ 0, 1 ] 163319 20.301% 20.301% #### ( 1, 2 ] 531314 66.045% 86.346% ############# ( 2, 3 ] 69129 8.593% 94.939% ## ( 3, 4 ] 24077 2.993% 97.932% # ( 4, 6 ] 13371 1.662% 99.594% ( 6, 10 ] 2770 0.344% 99.938% ( 10, 15 ] 510 0.063% 100.002% ( 15, 22 ] 40 0.005% 100.007% ( 22, 34 ] 12 0.001% 100.008% ( 34, 51 ] 5 0.001% 100.009% ( 51, 76 ] 4 0.000% 100.009% ( 76, 110 ] 1 0.000% 100.009% ( 110, 170 ] 16 0.002% 100.011% ( 170, 250 ] 23 0.003% 100.014% ( 250, 380 ] 14 0.002% 100.016% ( 380, 580 ] 3 0.000% 100.016% ( 580, 870 ] 10 0.001% 100.018% ( 870, 1300 ] 12 0.001% 100.019% ( 1300, 1900 ] 6 0.001% 100.020% ( 1900, 2900 ] 4 0.000% 100.020% ( 2900, 4400 ] 4 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 63913 Average: 2.4011 StdDev: 5.12 Min: 1 Median: 1.6333 Max: 818 Percentiles: P50: 1.63 P75: 2.05 P99: 5.94 P99.9: 12.03 P99.99: 18.58 ------------------------------------------------------ [ 0, 1 ] 5342 8.358% 8.358% ## ( 1, 2 ] 42022 65.749% 74.107% ############# ( 2, 3 ] 10550 16.507% 90.614% ### ( 3, 4 ] 2986 4.672% 95.286% # ( 4, 6 ] 2441 3.819% 99.105% # ( 6, 10 ] 472 0.739% 99.844% ( 10, 15 ] 89 0.139% 99.983% ( 15, 22 ] 9 0.014% 99.997% ( 22, 34 ] 2 0.003% 100.000% ( 34, 51 ] 3 0.005% 100.005% ( 110, 170 ] 1 0.002% 100.006% ( 170, 250 ] 1 0.002% 100.008% ( 250, 380 ] 1 0.002% 100.009% ( 380, 580 ] 1 0.002% 100.011% ( 580, 870 ] 2 0.003% 100.014% ** Level 2 read latency histogram (micros): Count: 47978 Average: 2.4921 StdDev: 28.78 Min: 1 Median: 1.5214 Max: 4570 Percentiles: P50: 1.52 P75: 1.88 P99: 5.71 P99.9: 10.00 P99.99: 1214.24 ------------------------------------------------------ [ 0, 1 ] 6556 13.665% 13.665% ### ( 1, 2 ] 33434 69.686% 83.351% ############## ( 2, 3 ] 4699 9.794% 93.145% ## ( 3, 4 ] 1831 3.816% 96.961% # ( 4, 6 ] 1144 2.384% 99.346% ( 6, 10 ] 266 0.554% 99.900% ( 10, 15 ] 26 0.054% 99.954% ( 15, 22 ] 6 0.013% 99.967% ( 22, 34 ] 2 0.004% 99.971% ( 51, 76 ] 2 0.004% 99.975% ( 170, 250 ] 1 0.002% 99.977% ( 380, 580 ] 2 0.004% 99.981% ( 580, 870 ] 1 0.002% 99.983% ( 870, 1300 ] 4 0.008% 99.992% ( 1300, 1900 ] 2 0.004% 99.996% ( 2900, 4400 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 47922 Average: 4.6285 StdDev: 86.39 Min: 0 Median: 1.6182 Max: 6343 Percentiles: P50: 1.62 P75: 2.00 P99: 7.05 P99.9: 433.90 P99.99: 3801.67 ------------------------------------------------------ [ 0, 1 ] 4514 9.419% 9.419% ## ( 1, 2 ] 31455 65.638% 75.057% ############# ( 2, 3 ] 7411 15.465% 90.522% ### ( 3, 4 ] 2263 4.722% 95.244% # ( 4, 6 ] 1704 3.556% 98.800% # ( 6, 10 ] 364 0.760% 99.560% ( 10, 15 ] 88 0.184% 99.743% ( 15, 22 ] 40 0.083% 99.827% ( 22, 34 ] 14 0.029% 99.856% ( 76, 110 ] 2 0.004% 99.860% ( 110, 170 ] 7 0.015% 99.875% ( 170, 250 ] 6 0.013% 99.887% ( 250, 380 ] 5 0.010% 99.898% ( 380, 580 ] 4 0.008% 99.906% ( 580, 870 ] 15 0.031% 99.937% ( 870, 1300 ] 12 0.025% 99.962% ( 1300, 1900 ] 4 0.008% 99.971% ( 1900, 2900 ] 5 0.010% 99.981% ( 2900, 4400 ] 7 0.015% 99.996% ( 4400, 6600 ] 6 0.013% 100.008% ** Level 4 read latency histogram (micros): Count: 15 Average: 1647.9333 StdDev: 1576.98 Min: 202 Median: 999.0000 Max: 5943 Percentiles: P50: 999.00 P75: 2150.00 P99: 5943.00 P99.9: 5943.00 P99.99: 5943.00 ------------------------------------------------------ ( 170, 250 ] 1 6.667% 6.667% # ( 380, 580 ] 2 13.333% 20.000% ### ( 580, 870 ] 3 20.000% 40.000% #### ( 870, 1300 ] 5 33.333% 73.333% ####### ( 1900, 2900 ] 1 6.667% 80.000% # ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 488.2500 StdDev: 542.15 Min: 95 Median: 156.6667 Max: 1746 Percentiles: P50: 156.67 P75: 580.00 P99: 1746.00 P99.9: 1746.00 P99.99: 1746.00 ------------------------------------------------------ ( 76, 110 ] 3 15.000% 15.000% ### ( 110, 170 ] 9 45.000% 60.000% ######### ( 380, 580 ] 3 15.000% 75.000% ### ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 1 5.000% 85.000% # ( 1300, 1900 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 9.2 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 321.99 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.008 H:M:S, 11.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 323.01 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.380 H:M:S, 12.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/07-16:46:47 ... thread 0: (1000000,4000000) ops and (330401.5,333287.1) ops/second in (3.026621,12.001666) 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.21 GB 6.3 2.7 0.0 2.7 6.5 3.7 0.0 1.7 130.3 310.7 21.28 19.99 64 0.332 2814K 2946 0.0 0.0 L1 9/9 1.04 GB 0.0 1.3 1.3 0.0 1.3 1.3 0.2 1.0 237.9 237.1 5.56 5.42 2 2.778 1342K 4760 0.0 0.0 L2 1/0 3.38 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.3 1.5 245.3 245.2 0.78 0.75 2 0.392 195K 86 0.0 0.0 L3 33/0 985.19 MB 1.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 201.2 201.0 3.10 2.73 3 1.035 634K 499 0.0 0.0 L4 144/0 9.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1242/19 99.82 GB 0.0 4.8 1.8 3.0 8.5 5.6 1.4 2.3 159.8 284.6 30.72 28.88 71 0.433 4986K 8291 0.0 0.0 Int 0/0 0.00 KB 0.0 4.8 1.8 3.0 8.5 5.6 1.3 2.3 159.8 284.6 30.72 28.88 71 0.433 4986K 8291 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.8 1.8 3.0 4.8 1.8 0.0 0.0 247.7 247.3 19.83 19.09 17 1.166 4986K 8291 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 352.7 10.90 9.78 54 0.202 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.2 total, 12.0 interval Flush(GB): cumulative 3.753, interval 3.753 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: 8.54 GB write, 717.04 MB/s write, 4.80 GB read, 402.66 MB/s read, 30.7 seconds Interval compaction: 8.54 GB write, 728.57 MB/s write, 4.80 GB read, 409.14 MB/s read, 30.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: 1094815 Average: 2.0767 StdDev: 11.38 Min: 0 Median: 1.4331 Max: 4255 Percentiles: P50: 1.43 P75: 1.82 P99: 5.23 P99.9: 9.53 P99.99: 14.00 ------------------------------------------------------ [ 0, 1 ] 237502 21.693% 21.693% #### ( 1, 2 ] 715505 65.354% 87.047% ############# ( 2, 3 ] 88478 8.082% 95.129% ## ( 3, 4 ] 31723 2.898% 98.026% # ( 4, 6 ] 17378 1.587% 99.614% ( 6, 10 ] 3556 0.325% 99.939% ( 10, 15 ] 705 0.064% 100.003% ( 15, 22 ] 67 0.006% 100.009% ( 22, 34 ] 12 0.001% 100.010% ( 34, 51 ] 8 0.001% 100.011% ( 51, 76 ] 6 0.001% 100.011% ( 76, 110 ] 1 0.000% 100.012% ( 110, 170 ] 21 0.002% 100.013% ( 170, 250 ] 33 0.003% 100.016% ( 250, 380 ] 23 0.002% 100.019% ( 380, 580 ] 4 0.000% 100.019% ( 580, 870 ] 14 0.001% 100.020% ( 870, 1300 ] 16 0.001% 100.022% ( 1300, 1900 ] 7 0.001% 100.022% ( 1900, 2900 ] 5 0.000% 100.023% ( 2900, 4400 ] 5 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 67916 Average: 2.7083 StdDev: 17.55 Min: 1 Median: 1.6141 Max: 1901 Percentiles: P50: 1.61 P75: 2.00 P99: 6.17 P99.9: 87.08 P99.99: 451.30 ------------------------------------------------------ [ 0, 1 ] 6737 9.920% 9.920% ## ( 1, 2 ] 44327 65.267% 75.187% ############# ( 2, 3 ] 10637 15.662% 90.849% ### ( 3, 4 ] 3043 4.481% 95.330% # ( 4, 6 ] 2471 3.638% 98.968% # ( 6, 10 ] 513 0.755% 99.723% ( 10, 15 ] 95 0.140% 99.863% ( 15, 22 ] 9 0.013% 99.876% ( 22, 34 ] 2 0.003% 99.879% ( 34, 51 ] 3 0.004% 99.884% ( 76, 110 ] 34 0.050% 99.934% ( 110, 170 ] 22 0.032% 99.966% ( 170, 250 ] 7 0.010% 99.976% ( 250, 380 ] 6 0.009% 99.985% ( 380, 580 ] 9 0.013% 99.999% ( 580, 870 ] 4 0.006% 100.004% ( 870, 1300 ] 1 0.001% 100.006% ( 1300, 1900 ] 4 0.006% 100.012% ( 1900, 2900 ] 1 0.001% 100.013% ** Level 2 read latency histogram (micros): Count: 47978 Average: 2.4921 StdDev: 28.78 Min: 1 Median: 1.5214 Max: 4570 Percentiles: P50: 1.52 P75: 1.88 P99: 5.71 P99.9: 10.00 P99.99: 1214.24 ------------------------------------------------------ [ 0, 1 ] 6556 13.665% 13.665% ### ( 1, 2 ] 33434 69.686% 83.351% ############## ( 2, 3 ] 4699 9.794% 93.145% ## ( 3, 4 ] 1831 3.816% 96.961% # ( 4, 6 ] 1144 2.384% 99.346% ( 6, 10 ] 266 0.554% 99.900% ( 10, 15 ] 26 0.054% 99.954% ( 15, 22 ] 6 0.013% 99.967% ( 22, 34 ] 2 0.004% 99.971% ( 51, 76 ] 2 0.004% 99.975% ( 170, 250 ] 1 0.002% 99.977% ( 380, 580 ] 2 0.004% 99.981% ( 580, 870 ] 1 0.002% 99.983% ( 870, 1300 ] 4 0.008% 99.992% ( 1300, 1900 ] 2 0.004% 99.996% ( 2900, 4400 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 47922 Average: 4.6285 StdDev: 86.39 Min: 0 Median: 1.6182 Max: 6343 Percentiles: P50: 1.62 P75: 2.00 P99: 7.05 P99.9: 433.90 P99.99: 3801.67 ------------------------------------------------------ [ 0, 1 ] 4514 9.419% 9.419% ## ( 1, 2 ] 31455 65.638% 75.057% ############# ( 2, 3 ] 7411 15.465% 90.522% ### ( 3, 4 ] 2263 4.722% 95.244% # ( 4, 6 ] 1704 3.556% 98.800% # ( 6, 10 ] 364 0.760% 99.560% ( 10, 15 ] 88 0.184% 99.743% ( 15, 22 ] 40 0.083% 99.827% ( 22, 34 ] 14 0.029% 99.856% ( 76, 110 ] 2 0.004% 99.860% ( 110, 170 ] 7 0.015% 99.875% ( 170, 250 ] 6 0.013% 99.887% ( 250, 380 ] 5 0.010% 99.898% ( 380, 580 ] 4 0.008% 99.906% ( 580, 870 ] 15 0.031% 99.937% ( 870, 1300 ] 12 0.025% 99.962% ( 1300, 1900 ] 4 0.008% 99.971% ( 1900, 2900 ] 5 0.010% 99.981% ( 2900, 4400 ] 7 0.015% 99.996% ( 4400, 6600 ] 6 0.013% 100.008% ** Level 4 read latency histogram (micros): Count: 15 Average: 1647.9333 StdDev: 1576.98 Min: 202 Median: 999.0000 Max: 5943 Percentiles: P50: 999.00 P75: 2150.00 P99: 5943.00 P99.9: 5943.00 P99.99: 5943.00 ------------------------------------------------------ ( 170, 250 ] 1 6.667% 6.667% # ( 380, 580 ] 2 13.333% 20.000% ### ( 580, 870 ] 3 20.000% 40.000% #### ( 870, 1300 ] 5 33.333% 73.333% ####### ( 1900, 2900 ] 1 6.667% 80.000% # ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 488.2500 StdDev: 542.15 Min: 95 Median: 156.6667 Max: 1746 Percentiles: P50: 156.67 P75: 580.00 P99: 1746.00 P99.9: 1746.00 P99.99: 1746.00 ------------------------------------------------------ ( 76, 110 ] 3 15.000% 15.000% ### ( 110, 170 ] 9 45.000% 60.000% ######### ( 380, 580 ] 3 15.000% 75.000% ### ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 1 5.000% 85.000% # ( 1300, 1900 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 12.2 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 322.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.391 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, 325.20 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.383 H:M:S, 12.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/07-16:46:50 ... thread 0: (1000000,5000000) ops and (324793.3,331553.0) ops/second in (3.078881,15.080547) 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/14 3.20 GB 81.8 3.3 0.0 3.3 7.9 4.7 0.0 1.7 128.3 312.2 26.02 24.41 79 0.329 3390K 3580 0.0 0.0 L1 9/9 1.04 GB 0.0 1.3 1.3 0.0 1.3 1.3 0.2 1.0 237.9 237.1 5.56 5.42 2 2.778 1342K 4760 0.0 0.0 L2 1/0 3.38 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.3 1.5 245.3 245.2 0.78 0.75 2 0.392 195K 86 0.0 0.0 L3 33/0 985.19 MB 1.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 201.2 201.0 3.10 2.73 3 1.035 634K 499 0.0 0.0 L4 144/0 9.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1250/23 100.80 GB 0.0 5.3 1.8 3.5 10.0 6.5 1.4 2.1 154.5 289.2 35.46 33.31 86 0.412 5562K 8925 0.0 0.0 Int 0/0 0.00 KB 0.0 5.3 1.8 3.5 10.0 6.5 1.3 2.1 154.5 289.2 35.46 33.31 86 0.412 5562K 8925 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.3 1.8 3.5 5.3 1.8 0.0 0.0 249.9 249.4 21.92 21.15 19 1.154 5562K 8925 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 353.6 13.54 12.15 67 0.202 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): 15.3 total, 15.1 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: 10.02 GB write, 671.44 MB/s write, 5.35 GB read, 358.62 MB/s read, 35.5 seconds Interval compaction: 10.02 GB write, 680.03 MB/s write, 5.35 GB read, 363.21 MB/s read, 35.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 18, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 18, interval: 19 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1419753 Average: 2.1092 StdDev: 11.08 Min: 0 Median: 1.4477 Max: 4255 Percentiles: P50: 1.45 P75: 1.83 P99: 5.25 P99.9: 9.64 P99.99: 14.49 ------------------------------------------------------ [ 0, 1 ] 289112 20.364% 20.364% #### ( 1, 2 ] 939836 66.197% 86.561% ############# ( 2, 3 ] 120030 8.454% 95.015% ## ( 3, 4 ] 42490 2.993% 98.008% # ( 4, 6 ] 22498 1.585% 99.592% ( 6, 10 ] 4804 0.338% 99.931% ( 10, 15 ] 938 0.066% 99.997% ( 15, 22 ] 90 0.006% 100.003% ( 22, 34 ] 15 0.001% 100.004% ( 34, 51 ] 11 0.001% 100.005% ( 51, 76 ] 8 0.001% 100.006% ( 76, 110 ] 40 0.003% 100.008% ( 110, 170 ] 65 0.005% 100.013% ( 170, 250 ] 50 0.004% 100.016% ( 250, 380 ] 31 0.002% 100.019% ( 380, 580 ] 23 0.002% 100.020% ( 580, 870 ] 21 0.001% 100.022% ( 870, 1300 ] 22 0.002% 100.023% ( 1300, 1900 ] 11 0.001% 100.024% ( 1900, 2900 ] 6 0.000% 100.025% ( 2900, 4400 ] 5 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 125458 Average: 2.5387 StdDev: 13.60 Min: 1 Median: 1.5648 Max: 1901 Percentiles: P50: 1.56 P75: 1.94 P99: 7.26 P99.9: 85.78 P99.99: 387.57 ------------------------------------------------------ [ 0, 1 ] 15525 12.375% 12.375% ## ( 1, 2 ] 83577 66.618% 78.992% ############# ( 2, 3 ] 16418 13.086% 92.079% ### ( 3, 4 ] 4778 3.808% 95.887% # ( 4, 6 ] 3474 2.769% 98.656% # ( 6, 10 ] 1369 1.091% 99.747% ( 10, 15 ] 153 0.122% 99.869% ( 15, 22 ] 14 0.011% 99.880% ( 22, 34 ] 3 0.002% 99.883% ( 34, 51 ] 4 0.003% 99.886% ( 76, 110 ] 61 0.049% 99.935% ( 110, 170 ] 40 0.032% 99.967% ( 170, 250 ] 15 0.012% 99.978% ( 250, 380 ] 14 0.011% 99.990% ( 380, 580 ] 12 0.010% 99.999% ( 580, 870 ] 4 0.003% 100.002% ( 870, 1300 ] 1 0.001% 100.003% ( 1300, 1900 ] 4 0.003% 100.006% ( 1900, 2900 ] 1 0.001% 100.007% ** Level 2 read latency histogram (micros): Count: 47978 Average: 2.4921 StdDev: 28.78 Min: 1 Median: 1.5214 Max: 4570 Percentiles: P50: 1.52 P75: 1.88 P99: 5.71 P99.9: 10.00 P99.99: 1214.24 ------------------------------------------------------ [ 0, 1 ] 6556 13.665% 13.665% ### ( 1, 2 ] 33434 69.686% 83.351% ############## ( 2, 3 ] 4699 9.794% 93.145% ## ( 3, 4 ] 1831 3.816% 96.961% # ( 4, 6 ] 1144 2.384% 99.346% ( 6, 10 ] 266 0.554% 99.900% ( 10, 15 ] 26 0.054% 99.954% ( 15, 22 ] 6 0.013% 99.967% ( 22, 34 ] 2 0.004% 99.971% ( 51, 76 ] 2 0.004% 99.975% ( 170, 250 ] 1 0.002% 99.977% ( 380, 580 ] 2 0.004% 99.981% ( 580, 870 ] 1 0.002% 99.983% ( 870, 1300 ] 4 0.008% 99.992% ( 1300, 1900 ] 2 0.004% 99.996% ( 2900, 4400 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 47922 Average: 4.6285 StdDev: 86.39 Min: 0 Median: 1.6182 Max: 6343 Percentiles: P50: 1.62 P75: 2.00 P99: 7.05 P99.9: 433.90 P99.99: 3801.67 ------------------------------------------------------ [ 0, 1 ] 4514 9.419% 9.419% ## ( 1, 2 ] 31455 65.638% 75.057% ############# ( 2, 3 ] 7411 15.465% 90.522% ### ( 3, 4 ] 2263 4.722% 95.244% # ( 4, 6 ] 1704 3.556% 98.800% # ( 6, 10 ] 364 0.760% 99.560% ( 10, 15 ] 88 0.184% 99.743% ( 15, 22 ] 40 0.083% 99.827% ( 22, 34 ] 14 0.029% 99.856% ( 76, 110 ] 2 0.004% 99.860% ( 110, 170 ] 7 0.015% 99.875% ( 170, 250 ] 6 0.013% 99.887% ( 250, 380 ] 5 0.010% 99.898% ( 380, 580 ] 4 0.008% 99.906% ( 580, 870 ] 15 0.031% 99.937% ( 870, 1300 ] 12 0.025% 99.962% ( 1300, 1900 ] 4 0.008% 99.971% ( 1900, 2900 ] 5 0.010% 99.981% ( 2900, 4400 ] 7 0.015% 99.996% ( 4400, 6600 ] 6 0.013% 100.008% ** Level 4 read latency histogram (micros): Count: 15 Average: 1647.9333 StdDev: 1576.98 Min: 202 Median: 999.0000 Max: 5943 Percentiles: P50: 999.00 P75: 2150.00 P99: 5943.00 P99.9: 5943.00 P99.99: 5943.00 ------------------------------------------------------ ( 170, 250 ] 1 6.667% 6.667% # ( 380, 580 ] 2 13.333% 20.000% ### ( 580, 870 ] 3 20.000% 40.000% #### ( 870, 1300 ] 5 33.333% 73.333% ####### ( 1900, 2900 ] 1 6.667% 80.000% # ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 488.2500 StdDev: 542.15 Min: 95 Median: 156.6667 Max: 1746 Percentiles: P50: 156.67 P75: 580.00 P99: 1746.00 P99.9: 1746.00 P99.99: 1746.00 ------------------------------------------------------ ( 76, 110 ] 3 15.000% 15.000% ### ( 110, 170 ] 9 45.000% 60.000% ######### ( 380, 580 ] 3 15.000% 75.000% ### ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 1 5.000% 85.000% # ( 1300, 1900 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 15.3 total, 3.1 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 322.15 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.781 H:M:S, 11.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.65 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.390 H:M:S, 12.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/07-16:46:59 ... thread 0: (1000000,6000000) ops and (110210.3,248405.0) ops/second in (9.073558,24.154105) 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/10 4.24 GB 213.7 5.4 0.0 5.4 11.1 5.7 0.0 1.9 148.0 306.0 37.02 34.98 102 0.363 5564K 7377 0.0 0.0 L1 9/9 1.04 GB 0.0 1.3 1.3 0.0 1.3 1.3 0.2 1.0 237.9 237.1 5.56 5.42 2 2.778 1342K 4760 0.0 0.0 L2 1/0 3.38 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.3 1.5 245.3 245.2 0.78 0.75 2 0.392 195K 86 0.0 0.0 L3 33/0 985.19 MB 1.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 201.2 201.0 3.10 2.73 3 1.035 634K 499 0.0 0.0 L4 144/0 9.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1249/19 101.85 GB 0.0 7.4 1.8 5.6 13.1 7.6 1.4 2.3 164.0 289.8 46.47 43.87 109 0.426 7736K 12K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.4 1.8 5.6 13.1 7.6 1.3 2.3 164.0 289.8 46.47 43.87 109 0.426 7736K 12K 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 7.4 1.8 5.6 7.4 1.8 0.0 0.0 254.6 254.2 29.93 29.05 25 1.197 7736K 12K 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 354.1 16.54 14.82 84 0.197 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): 24.3 total, 24.2 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: 13.15 GB write, 552.99 MB/s write, 7.44 GB read, 312.91 MB/s read, 46.5 seconds Interval compaction: 13.15 GB write, 557.41 MB/s write, 7.44 GB read, 315.41 MB/s read, 46.5 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: 18, pending-compaction-bytes-delays: 1, pending-compaction-bytes-stops: 0, total-delays: 12, total-stops: 18, interval: 30 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2256474 Average: 2.1414 StdDev: 10.85 Min: 0 Median: 1.4490 Max: 4255 Percentiles: P50: 1.45 P75: 1.82 P99: 5.39 P99.9: 10.82 P99.99: 96.87 ------------------------------------------------------ [ 0, 1 ] 451297 20.000% 20.000% #### ( 1, 2 ] 1507522 66.809% 86.809% ############# ( 2, 3 ] 184155 8.161% 94.970% ## ( 3, 4 ] 66535 2.949% 97.919% # ( 4, 6 ] 35182 1.559% 99.478% ( 6, 10 ] 9245 0.410% 99.888% ( 10, 15 ] 1721 0.076% 99.964% ( 15, 22 ] 313 0.014% 99.978% ( 22, 34 ] 21 0.001% 99.979% ( 34, 51 ] 14 0.001% 99.979% ( 51, 76 ] 23 0.001% 99.980% ( 76, 110 ] 359 0.016% 99.996% ( 110, 170 ] 277 0.012% 100.008% ( 170, 250 ] 97 0.004% 100.013% ( 250, 380 ] 79 0.004% 100.016% ( 380, 580 ] 56 0.002% 100.019% ( 580, 870 ] 36 0.002% 100.020% ( 870, 1300 ] 32 0.001% 100.022% ( 1300, 1900 ] 15 0.001% 100.022% ( 1900, 2900 ] 8 0.000% 100.023% ( 2900, 4400 ] 8 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 297512 Average: 2.4633 StdDev: 12.79 Min: 1 Median: 1.4936 Max: 2620 Percentiles: P50: 1.49 P75: 1.87 P99: 7.30 P99.9: 114.07 P99.99: 429.99 ------------------------------------------------------ [ 0, 1 ] 50748 17.057% 17.057% ### ( 1, 2 ] 198566 66.742% 83.800% ############# ( 2, 3 ] 28482 9.573% 93.373% ## ( 3, 4 ] 9209 3.095% 96.468% # ( 4, 6 ] 6537 2.197% 98.666% ( 6, 10 ] 3070 1.032% 99.697% ( 10, 15 ] 306 0.103% 99.800% ( 15, 22 ] 59 0.020% 99.820% ( 22, 34 ] 4 0.001% 99.822% ( 34, 51 ] 4 0.001% 99.823% ( 51, 76 ] 4 0.001% 99.824% ( 76, 110 ] 212 0.071% 99.895% ( 110, 170 ] 199 0.067% 99.962% ( 170, 250 ] 41 0.014% 99.976% ( 250, 380 ] 34 0.011% 99.988% ( 380, 580 ] 29 0.010% 99.997% ( 580, 870 ] 8 0.003% 100.000% ( 870, 1300 ] 2 0.001% 100.001% ( 1300, 1900 ] 4 0.001% 100.002% ( 1900, 2900 ] 3 0.001% 100.003% ** Level 2 read latency histogram (micros): Count: 47978 Average: 2.4921 StdDev: 28.78 Min: 1 Median: 1.5214 Max: 4570 Percentiles: P50: 1.52 P75: 1.88 P99: 5.71 P99.9: 10.00 P99.99: 1214.24 ------------------------------------------------------ [ 0, 1 ] 6556 13.665% 13.665% ### ( 1, 2 ] 33434 69.686% 83.351% ############## ( 2, 3 ] 4699 9.794% 93.145% ## ( 3, 4 ] 1831 3.816% 96.961% # ( 4, 6 ] 1144 2.384% 99.346% ( 6, 10 ] 266 0.554% 99.900% ( 10, 15 ] 26 0.054% 99.954% ( 15, 22 ] 6 0.013% 99.967% ( 22, 34 ] 2 0.004% 99.971% ( 51, 76 ] 2 0.004% 99.975% ( 170, 250 ] 1 0.002% 99.977% ( 380, 580 ] 2 0.004% 99.981% ( 580, 870 ] 1 0.002% 99.983% ( 870, 1300 ] 4 0.008% 99.992% ( 1300, 1900 ] 2 0.004% 99.996% ( 2900, 4400 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 47922 Average: 4.6285 StdDev: 86.39 Min: 0 Median: 1.6182 Max: 6343 Percentiles: P50: 1.62 P75: 2.00 P99: 7.05 P99.9: 433.90 P99.99: 3801.67 ------------------------------------------------------ [ 0, 1 ] 4514 9.419% 9.419% ## ( 1, 2 ] 31455 65.638% 75.057% ############# ( 2, 3 ] 7411 15.465% 90.522% ### ( 3, 4 ] 2263 4.722% 95.244% # ( 4, 6 ] 1704 3.556% 98.800% # ( 6, 10 ] 364 0.760% 99.560% ( 10, 15 ] 88 0.184% 99.743% ( 15, 22 ] 40 0.083% 99.827% ( 22, 34 ] 14 0.029% 99.856% ( 76, 110 ] 2 0.004% 99.860% ( 110, 170 ] 7 0.015% 99.875% ( 170, 250 ] 6 0.013% 99.887% ( 250, 380 ] 5 0.010% 99.898% ( 380, 580 ] 4 0.008% 99.906% ( 580, 870 ] 15 0.031% 99.937% ( 870, 1300 ] 12 0.025% 99.962% ( 1300, 1900 ] 4 0.008% 99.971% ( 1900, 2900 ] 5 0.010% 99.981% ( 2900, 4400 ] 7 0.015% 99.996% ( 4400, 6600 ] 6 0.013% 100.008% ** Level 4 read latency histogram (micros): Count: 15 Average: 1647.9333 StdDev: 1576.98 Min: 202 Median: 999.0000 Max: 5943 Percentiles: P50: 999.00 P75: 2150.00 P99: 5943.00 P99.9: 5943.00 P99.99: 5943.00 ------------------------------------------------------ ( 170, 250 ] 1 6.667% 6.667% # ( 380, 580 ] 2 13.333% 20.000% ### ( 580, 870 ] 3 20.000% 40.000% #### ( 870, 1300 ] 5 33.333% 73.333% ####### ( 1900, 2900 ] 1 6.667% 80.000% # ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 488.2500 StdDev: 542.15 Min: 95 Median: 156.6667 Max: 1746 Percentiles: P50: 156.67 P75: 580.00 P99: 1746.00 P99.9: 1746.00 P99.99: 1746.00 ------------------------------------------------------ ( 76, 110 ] 3 15.000% 15.000% ### ( 110, 170 ] 9 45.000% 60.000% ######### ( 380, 580 ] 3 15.000% 75.000% ### ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 1 5.000% 85.000% # ( 1300, 1900 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 24.3 total, 9.1 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 242.52 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:8.142 H:M:S, 33.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 108.47 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:6.361 H:M:S, 70.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 2024/12/07-16:47:04 ... thread 0: (1000000,7000000) ops and (185717.5,236977.8) ops/second in (5.384523,29.538628) 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 17/16 2.95 GB 31.5 5.7 0.0 5.7 12.2 6.6 0.0 1.9 140.5 303.6 41.26 38.52 115 0.359 5883K 7728 0.0 0.0 L1 14/14 1.64 GB 0.0 4.5 3.4 1.0 4.4 3.4 0.2 1.3 231.8 229.2 19.80 19.18 3 6.601 4661K 50K 0.0 0.0 L2 1/1 3.38 MB 0.0 0.2 0.1 0.1 0.2 0.1 1.8 1.5 245.3 245.2 0.78 0.75 2 0.392 195K 86 0.0 0.0 L3 25/9 1.67 GB 1.0 0.9 0.7 0.2 0.9 0.7 1.4 1.3 194.6 194.4 4.64 3.97 5 0.928 909K 688 0.0 0.0 L4 165/0 9.54 GB 1.0 0.8 0.7 0.1 0.8 0.7 0.6 1.1 146.2 145.8 5.64 3.81 7 0.806 811K 2335 0.0 0.0 L5 1056/0 86.86 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1278/40 102.66 GB 0.0 12.0 5.0 7.1 18.5 11.5 5.2 2.8 170.6 263.2 72.12 66.21 132 0.546 12M 61K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.0 5.0 7.1 18.5 11.5 5.1 2.8 170.6 263.2 72.12 66.21 132 0.546 12M 61K 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 12.0 5.0 7.1 12.0 4.9 0.0 0.0 233.9 232.7 52.62 49.10 36 1.462 12M 61K 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 345.5 19.51 17.11 96 0.203 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): 29.7 total, 29.5 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: 18.54 GB write, 638.47 MB/s write, 12.02 GB read, 413.85 MB/s read, 72.1 seconds Interval compaction: 18.54 GB write, 642.64 MB/s write, 12.02 GB read, 416.56 MB/s read, 72.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: 28, pending-compaction-bytes-delays: 3, pending-compaction-bytes-stops: 0, total-delays: 14, total-stops: 28, interval: 42 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2648339 Average: 2.2736 StdDev: 15.58 Min: 0 Median: 1.4722 Max: 4255 Percentiles: P50: 1.47 P75: 1.85 P99: 5.67 P99.9: 12.15 P99.99: 123.55 ------------------------------------------------------ [ 0, 1 ] 498133 18.809% 18.809% #### ( 1, 2 ] 1749517 66.061% 84.870% ############# ( 2, 3 ] 240566 9.084% 93.954% ## ( 3, 4 ] 88842 3.355% 97.308% # ( 4, 6 ] 53664 2.026% 99.335% ( 6, 10 ] 13876 0.524% 99.859% ( 10, 15 ] 2549 0.096% 99.955% ( 15, 22 ] 407 0.015% 99.970% ( 22, 34 ] 32 0.001% 99.972% ( 34, 51 ] 16 0.001% 99.972% ( 51, 76 ] 25 0.001% 99.973% ( 76, 110 ] 373 0.014% 99.987% ( 110, 170 ] 346 0.013% 100.000% ( 170, 250 ] 167 0.006% 100.007% ( 250, 380 ] 159 0.006% 100.013% ( 380, 580 ] 134 0.005% 100.018% ( 580, 870 ] 92 0.003% 100.021% ( 870, 1300 ] 55 0.002% 100.023% ( 1300, 1900 ] 31 0.001% 100.024% ( 1900, 2900 ] 21 0.001% 100.025% ( 2900, 4400 ] 22 0.001% 100.026% ** Level 1 read latency histogram (micros): Count: 530240 Average: 3.1239 StdDev: 34.83 Min: 0 Median: 1.5981 Max: 7040 Percentiles: P50: 1.60 P75: 2.02 P99: 8.00 P99.9: 89.48 P99.99: 319.01 ------------------------------------------------------ [ 0, 1 ] 69614 13.129% 13.129% ### ( 1, 2 ] 326873 61.646% 74.775% ############ ( 2, 3 ] 73553 13.872% 88.647% ### ( 3, 4 ] 28052 5.290% 93.937% # ( 4, 6 ] 23515 4.435% 98.372% # ( 6, 10 ] 6664 1.257% 99.629% ( 10, 15 ] 1140 0.215% 99.844% ( 15, 22 ] 166 0.031% 99.875% ( 22, 34 ] 16 0.003% 99.878% ( 34, 51 ] 5 0.001% 99.879% ( 51, 76 ] 21 0.004% 99.883% ( 76, 110 ] 229 0.043% 99.926% ( 110, 170 ] 240 0.045% 99.971% ( 170, 250 ] 65 0.012% 99.984% ( 250, 380 ] 64 0.012% 99.996% ( 380, 580 ] 97 0.018% 100.014% ( 580, 870 ] 63 0.012% 100.026% ( 870, 1300 ] 44 0.008% 100.034% ( 1300, 1900 ] 24 0.005% 100.039% ( 1900, 2900 ] 31 0.006% 100.045% ( 2900, 4400 ] 17 0.003% 100.048% ( 4400, 6600 ] 1 0.000% 100.048% ( 6600, 9900 ] 1 0.000% 100.048% ** Level 2 read latency histogram (micros): Count: 59141 Average: 3.5706 StdDev: 39.19 Min: 1 Median: 1.5698 Max: 4570 Percentiles: P50: 1.57 P75: 1.94 P99: 7.12 P99.9: 450.87 P99.99: 1670.31 ------------------------------------------------------ [ 0, 1 ] 6749 11.412% 11.412% ## ( 1, 2 ] 40054 67.726% 79.138% ############## ( 2, 3 ] 7239 12.240% 91.378% ## ( 3, 4 ] 2621 4.432% 95.810% # ( 4, 6 ] 1744 2.949% 98.759% # ( 6, 10 ] 510 0.862% 99.621% ( 10, 15 ] 57 0.096% 99.718% ( 15, 22 ] 8 0.014% 99.731% ( 22, 34 ] 3 0.005% 99.736% ( 51, 76 ] 2 0.003% 99.740% ( 76, 110 ] 10 0.017% 99.757% ( 110, 170 ] 36 0.061% 99.817% ( 170, 250 ] 21 0.036% 99.853% ( 250, 380 ] 19 0.032% 99.885% ( 380, 580 ] 25 0.042% 99.927% ( 580, 870 ] 17 0.029% 99.956% ( 870, 1300 ] 17 0.029% 99.985% ( 1300, 1900 ] 5 0.008% 99.993% ( 1900, 2900 ] 2 0.003% 99.997% ( 2900, 4400 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 291524 Average: 6.8116 StdDev: 81.69 Min: 0 Median: 1.7914 Max: 6455 Percentiles: P50: 1.79 P75: 2.61 P99: 9.95 P99.9: 780.62 P99.99: 1447.02 ------------------------------------------------------ [ 0, 1 ] 10401 3.568% 3.568% # ( 1, 2 ] 171040 58.671% 62.239% ############ ( 2, 3 ] 60697 20.821% 83.059% #### ( 3, 4 ] 22660 7.773% 90.832% ## ( 4, 6 ] 18185 6.238% 97.070% # ( 6, 10 ] 5692 1.952% 99.023% ( 10, 15 ] 983 0.337% 99.360% ( 15, 22 ] 167 0.057% 99.417% ( 22, 34 ] 20 0.007% 99.424% ( 34, 51 ] 1 0.000% 99.424% ( 51, 76 ] 2 0.001% 99.425% ( 76, 110 ] 80 0.027% 99.453% ( 110, 170 ] 223 0.076% 99.529% ( 170, 250 ] 279 0.096% 99.625% ( 250, 380 ] 282 0.097% 99.721% ( 380, 580 ] 333 0.114% 99.836% ( 580, 870 ] 271 0.093% 99.929% ( 870, 1300 ] 159 0.055% 99.983% ( 1300, 1900 ] 81 0.028% 100.011% ( 1900, 2900 ] 62 0.021% 100.032% ( 2900, 4400 ] 48 0.016% 100.049% ( 4400, 6600 ] 11 0.004% 100.052% ** Level 4 read latency histogram (micros): Count: 185 Average: 248.3568 StdDev: 730.25 Min: 0 Median: 2.0882 Max: 5943 Percentiles: P50: 2.09 P75: 21.12 P99: 3975.00 P99.9: 5943.00 P99.99: 5943.00 ------------------------------------------------------ [ 0, 1 ] 44 23.784% 23.784% ##### ( 1, 2 ] 47 25.405% 49.189% ##### ( 2, 3 ] 17 9.189% 58.378% ## ( 3, 4 ] 5 2.703% 61.081% # ( 4, 6 ] 8 4.324% 65.405% # ( 6, 10 ] 9 4.865% 70.270% # ( 15, 22 ] 10 5.405% 75.676% # ( 22, 34 ] 1 0.541% 76.216% ( 110, 170 ] 8 4.324% 80.541% # ( 170, 250 ] 9 4.865% 85.405% # ( 380, 580 ] 4 2.162% 87.568% ( 580, 870 ] 4 2.162% 89.730% ( 870, 1300 ] 10 5.405% 95.135% # ( 1300, 1900 ] 2 1.081% 96.216% ( 1900, 2900 ] 3 1.622% 97.838% ( 2900, 4400 ] 3 1.622% 99.459% ( 4400, 6600 ] 1 0.541% 100.000% ** Level 5 read latency histogram (micros): Count: 80 Average: 1131.8375 StdDev: 1180.91 Min: 95 Median: 644.4444 Max: 4898 Percentiles: P50: 644.44 P75: 1800.00 P99: 4840.00 P99.9: 4898.00 P99.99: 4898.00 ------------------------------------------------------ ( 76, 110 ] 3 3.750% 3.750% # ( 110, 170 ] 14 17.500% 21.250% #### ( 170, 250 ] 7 8.750% 30.000% ## ( 250, 380 ] 7 8.750% 38.750% ## ( 380, 580 ] 7 8.750% 47.500% ## ( 580, 870 ] 9 11.250% 58.750% ## ( 870, 1300 ] 8 10.000% 68.750% ## ( 1300, 1900 ] 6 7.500% 76.250% ## ( 1900, 2900 ] 11 13.750% 90.000% ### ( 2900, 4400 ] 7 8.750% 98.750% ## ( 4400, 6600 ] 1 1.250% 100.000% ** DB Stats ** Uptime(secs): 29.7 total, 5.4 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 231.70 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:10.719 H:M:S, 36.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 182.78 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:2.577 H:M:S, 47.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/12/07-16:47:08 ... thread 0: (1000000,8000000) ops and (281827.6,241787.6) ops/second in (3.548269,33.086897) 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/12 3.93 GB 163.6 6.8 0.0 6.8 14.4 7.6 0.0 1.9 143.1 301.6 48.85 45.61 133 0.367 7099K 9111 0.0 0.0 L1 14/14 1.64 GB 0.0 4.5 3.4 1.0 4.4 3.4 0.2 1.3 231.8 229.2 19.80 19.18 3 6.601 4661K 50K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 1.8 1.5 245.3 245.2 0.78 0.75 2 0.392 195K 86 0.0 0.0 L3 15/0 919.41 MB 0.9 1.6 0.7 0.9 1.6 0.7 1.4 2.4 195.6 195.1 8.42 7.26 6 1.404 1665K 4117 0.0 0.0 L4 164/0 9.63 GB 1.0 1.0 0.9 0.1 1.0 0.9 1.2 1.1 153.3 152.8 6.74 4.78 9 0.749 1023K 3146 0.0 0.0 L5 1064/0 87.54 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1276/26 103.64 GB 0.0 14.1 5.1 9.0 21.6 12.6 6.5 2.9 170.9 261.7 84.60 77.57 153 0.553 14M 66K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.1 5.1 9.0 21.6 12.6 6.4 2.9 170.9 261.7 84.60 77.57 153 0.553 14M 66K 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 14.1 5.1 9.0 14.1 5.1 0.0 0.0 232.6 231.5 62.15 57.90 43 1.445 14M 66K 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 345.2 22.45 19.66 110 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): 33.3 total, 33.1 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: 21.62 GB write, 665.11 MB/s write, 14.12 GB read, 434.33 MB/s read, 84.6 seconds Interval compaction: 21.62 GB write, 668.99 MB/s write, 14.12 GB read, 436.86 MB/s read, 84.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 36, pending-compaction-bytes-delays: 3, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 36, interval: 53 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3074576 Average: 2.2929 StdDev: 14.89 Min: 0 Median: 1.4868 Max: 4255 Percentiles: P50: 1.49 P75: 1.86 P99: 5.72 P99.9: 12.02 P99.99: 107.99 ------------------------------------------------------ [ 0, 1 ] 545325 17.737% 17.737% #### ( 1, 2 ] 2037924 66.283% 84.020% ############# ( 2, 3 ] 295172 9.600% 93.620% ## ( 3, 4 ] 108353 3.524% 97.144% # ( 4, 6 ] 66161 2.152% 99.296% ( 6, 10 ] 17307 0.563% 99.859% ( 10, 15 ] 3117 0.101% 99.960% ( 15, 22 ] 460 0.015% 99.975% ( 22, 34 ] 36 0.001% 99.977% ( 34, 51 ] 18 0.001% 99.977% ( 51, 76 ] 25 0.001% 99.978% ( 76, 110 ] 396 0.013% 99.991% ( 110, 170 ] 389 0.013% 100.003% ( 170, 250 ] 214 0.007% 100.010% ( 250, 380 ] 192 0.006% 100.017% ( 380, 580 ] 155 0.005% 100.022% ( 580, 870 ] 110 0.004% 100.025% ( 870, 1300 ] 59 0.002% 100.027% ( 1300, 1900 ] 36 0.001% 100.028% ( 1900, 2900 ] 22 0.001% 100.029% ( 2900, 4400 ] 22 0.001% 100.030% ** Level 1 read latency histogram (micros): Count: 627119 Average: 3.0926 StdDev: 32.80 Min: 0 Median: 1.6045 Max: 7040 Percentiles: P50: 1.60 P75: 2.02 P99: 8.13 P99.9: 100.11 P99.99: 369.73 ------------------------------------------------------ [ 0, 1 ] 76509 12.200% 12.200% ## ( 1, 2 ] 392145 62.531% 74.731% ############# ( 2, 3 ] 88408 14.097% 88.829% ### ( 3, 4 ] 32567 5.193% 94.022% # ( 4, 6 ] 26714 4.260% 98.282% # ( 6, 10 ] 8455 1.348% 99.630% ( 10, 15 ] 1281 0.204% 99.834% ( 15, 22 ] 183 0.029% 99.863% ( 22, 34 ] 17 0.003% 99.866% ( 34, 51 ] 5 0.001% 99.867% ( 51, 76 ] 21 0.003% 99.870% ( 76, 110 ] 265 0.042% 99.912% ( 110, 170 ] 304 0.048% 99.961% ( 170, 250 ] 105 0.017% 99.978% ( 250, 380 ] 85 0.014% 99.991% ( 380, 580 ] 118 0.019% 100.010% ( 580, 870 ] 70 0.011% 100.021% ( 870, 1300 ] 45 0.007% 100.028% ( 1300, 1900 ] 27 0.004% 100.033% ( 1900, 2900 ] 31 0.005% 100.038% ( 2900, 4400 ] 18 0.003% 100.041% ( 4400, 6600 ] 1 0.000% 100.041% ( 6600, 9900 ] 1 0.000% 100.041% ** Level 2 read latency histogram (micros): Count: 77093 Average: 3.8107 StdDev: 37.47 Min: 1 Median: 1.6150 Max: 4570 Percentiles: P50: 1.61 P75: 1.99 P99: 8.30 P99.9: 482.33 P99.99: 1454.88 ------------------------------------------------------ [ 0, 1 ] 7087 9.193% 9.193% ## ( 1, 2 ] 51157 66.358% 75.550% ############# ( 2, 3 ] 10845 14.067% 89.618% ### ( 3, 4 ] 3920 5.085% 94.703% # ( 4, 6 ] 2806 3.640% 98.342% # ( 6, 10 ] 883 1.145% 99.488% ( 10, 15 ] 105 0.136% 99.624% ( 15, 22 ] 17 0.022% 99.646% ( 22, 34 ] 4 0.005% 99.651% ( 51, 76 ] 2 0.003% 99.654% ( 76, 110 ] 16 0.021% 99.674% ( 110, 170 ] 74 0.096% 99.770% ( 170, 250 ] 47 0.061% 99.831% ( 250, 380 ] 35 0.045% 99.877% ( 380, 580 ] 35 0.045% 99.922% ( 580, 870 ] 28 0.036% 99.958% ( 870, 1300 ] 23 0.030% 99.988% ( 1300, 1900 ] 5 0.006% 99.995% ( 1900, 2900 ] 2 0.003% 99.997% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 311758 Average: 6.7714 StdDev: 79.76 Min: 0 Median: 1.7865 Max: 6455 Percentiles: P50: 1.79 P75: 2.60 P99: 10.10 P99.9: 771.89 P99.99: 1425.82 ------------------------------------------------------ [ 0, 1 ] 11331 3.635% 3.635% # ( 1, 2 ] 183781 58.950% 62.584% ############ ( 2, 3 ] 64391 20.654% 83.239% #### ( 3, 4 ] 23999 7.698% 90.937% ## ( 4, 6 ] 19212 6.162% 97.099% # ( 6, 10 ] 5907 1.895% 98.994% ( 10, 15 ] 1003 0.322% 99.315% ( 15, 22 ] 171 0.055% 99.370% ( 22, 34 ] 20 0.006% 99.377% ( 34, 51 ] 1 0.000% 99.377% ( 51, 76 ] 2 0.001% 99.378% ( 76, 110 ] 117 0.038% 99.415% ( 110, 170 ] 305 0.098% 99.513% ( 170, 250 ] 332 0.106% 99.620% ( 250, 380 ] 323 0.104% 99.723% ( 380, 580 ] 362 0.116% 99.839% ( 580, 870 ] 286 0.092% 99.931% ( 870, 1300 ] 166 0.053% 99.984% ( 1300, 1900 ] 85 0.027% 100.012% ( 1900, 2900 ] 62 0.020% 100.031% ( 2900, 4400 ] 48 0.015% 100.047% ( 4400, 6600 ] 11 0.004% 100.050% ** Level 4 read latency histogram (micros): Count: 215 Average: 222.8233 StdDev: 682.02 Min: 0 Median: 1.9407 Max: 5943 Percentiles: P50: 1.94 P75: 20.89 P99: 3825.00 P99.9: 5943.00 P99.99: 5943.00 ------------------------------------------------------ [ 0, 1 ] 52 24.186% 24.186% ##### ( 1, 2 ] 59 27.442% 51.628% ##### ( 2, 3 ] 19 8.837% 60.465% ## ( 3, 4 ] 5 2.326% 62.791% ( 4, 6 ] 8 3.721% 66.512% # ( 6, 10 ] 9 4.186% 70.698% # ( 15, 22 ] 11 5.116% 75.814% # ( 22, 34 ] 1 0.465% 76.279% ( 110, 170 ] 9 4.186% 80.465% # ( 170, 250 ] 12 5.581% 86.047% # ( 250, 380 ] 2 0.930% 86.977% ( 380, 580 ] 5 2.326% 89.302% ( 580, 870 ] 4 1.860% 91.163% ( 870, 1300 ] 10 4.651% 95.814% # ( 1300, 1900 ] 2 0.930% 96.744% ( 1900, 2900 ] 3 1.395% 98.140% ( 2900, 4400 ] 3 1.395% 99.535% ( 4400, 6600 ] 1 0.465% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 1034.8833 StdDev: 1133.83 Min: 94 Median: 513.3333 Max: 4898 Percentiles: P50: 513.33 P75: 1600.00 P99: 4366.67 P99.9: 4898.00 P99.99: 4898.00 ------------------------------------------------------ ( 76, 110 ] 6 5.000% 5.000% # ( 110, 170 ] 24 20.000% 25.000% #### ( 170, 250 ] 12 10.000% 35.000% ## ( 250, 380 ] 12 10.000% 45.000% ## ( 380, 580 ] 9 7.500% 52.500% ## ( 580, 870 ] 12 10.000% 62.500% ## ( 870, 1300 ] 10 8.333% 70.833% ## ( 1300, 1900 ] 10 8.333% 79.167% ## ( 1900, 2900 ] 15 12.500% 91.667% ### ( 2900, 4400 ] 9 7.500% 99.167% ## ( 4400, 6600 ] 1 0.833% 100.000% ** DB Stats ** Uptime(secs): 33.3 total, 3.5 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 236.57 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:11.539 H:M:S, 34.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 277.37 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.820 H:M:S, 23.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/07-16:47:24 ... thread 0: (1000000,9000000) ops and (61104.0,181993.0) ops/second in (16.365545,49.452442) 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/4 2.76 GB 244.5 9.8 0.0 9.8 18.3 8.5 0.0 2.2 151.6 282.1 66.46 60.02 151 0.440 10M 19K 0.0 0.0 L1 7/0 682.95 MB 68.3 8.2 5.5 2.7 8.1 5.4 0.2 1.5 223.3 220.5 37.64 35.51 4 9.411 7877K 50K 0.0 0.0 L2 1/0 84.18 MB 0.8 0.2 0.1 0.1 0.2 0.1 4.8 1.5 245.3 245.2 0.78 0.75 2 0.392 195K 86 0.0 0.0 L3 19/1 1002.33 MB 0.9 2.7 1.2 1.5 2.7 1.2 3.8 2.3 159.1 158.1 17.44 12.45 12 1.453 2810K 17K 0.0 0.0 L4 157/4 9.80 GB 1.0 4.8 3.7 1.1 4.8 3.7 1.2 1.3 130.9 130.5 37.45 22.73 34 1.101 4932K 14K 0.0 0.0 L5 1096/0 90.18 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 1289/9 104.47 GB 0.0 25.7 10.5 15.2 34.1 18.9 14.6 4.0 164.9 218.3 159.77 131.47 203 0.787 26M 102K 0.0 0.0 Int 0/0 0.00 KB 0.0 25.7 10.5 15.2 34.1 18.9 14.5 4.0 164.9 218.3 159.77 131.47 203 0.787 26M 102K 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 25.7 10.5 15.2 25.6 10.4 0.0 0.0 198.2 197.1 132.90 109.22 80 1.661 26M 102K 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 323.5 26.87 22.25 123 0.218 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): 49.6 total, 49.5 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: 34.06 GB write, 702.61 MB/s write, 25.73 GB read, 530.70 MB/s read, 159.8 seconds Interval compaction: 34.06 GB write, 705.35 MB/s write, 25.73 GB read, 532.77 MB/s read, 159.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 18, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 18, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 57, pending-compaction-bytes-delays: 25, pending-compaction-bytes-stops: 0, total-delays: 43, total-stops: 57, interval: 100 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4065113 Average: 2.6595 StdDev: 27.02 Min: 0 Median: 1.4996 Max: 7956 Percentiles: P50: 1.50 P75: 1.88 P99: 5.99 P99.9: 106.05 P99.99: 304.53 ------------------------------------------------------ [ 0, 1 ] 702300 17.276% 17.276% ### ( 1, 2 ] 2662692 65.501% 82.777% ############# ( 2, 3 ] 401033 9.865% 92.643% ## ( 3, 4 ] 155905 3.835% 96.478% # ( 4, 6 ] 102981 2.533% 99.011% # ( 6, 10 ] 28252 0.695% 99.706% ( 10, 15 ] 4750 0.117% 99.823% ( 15, 22 ] 679 0.017% 99.840% ( 22, 34 ] 56 0.001% 99.841% ( 34, 51 ] 31 0.001% 99.842% ( 51, 76 ] 132 0.003% 99.845% ( 76, 110 ] 2532 0.062% 99.907% ( 110, 170 ] 2416 0.059% 99.967% ( 170, 250 ] 722 0.018% 99.984% ( 250, 380 ] 540 0.013% 99.998% ( 380, 580 ] 449 0.011% 100.009% ( 580, 870 ] 279 0.007% 100.016% ( 870, 1300 ] 139 0.003% 100.019% ( 1300, 1900 ] 68 0.002% 100.021% ( 1900, 2900 ] 75 0.002% 100.023% ( 2900, 4400 ] 77 0.002% 100.024% ( 4400, 6600 ] 18 0.000% 100.025% ( 6600, 9900 ] 8 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 1768143 Average: 5.1625 StdDev: 81.90 Min: 0 Median: 1.7158 Max: 11988 Percentiles: P50: 1.72 P75: 2.52 P99: 8.99 P99.9: 131.19 P99.99: 454.70 ------------------------------------------------------ [ 0, 1 ] 168600 9.535% 9.535% ## ( 1, 2 ] 999538 56.530% 66.066% ########### ( 2, 3 ] 302821 17.126% 83.192% ### ( 3, 4 ] 131382 7.431% 90.623% # ( 4, 6 ] 123080 6.961% 97.584% # ( 6, 10 ] 33543 1.897% 99.481% ( 10, 15 ] 5284 0.299% 99.780% ( 15, 22 ] 727 0.041% 99.821% ( 22, 34 ] 64 0.004% 99.824% ( 34, 51 ] 15 0.001% 99.825% ( 51, 76 ] 76 0.004% 99.830% ( 76, 110 ] 915 0.052% 99.881% ( 110, 170 ] 934 0.053% 99.934% ( 170, 250 ] 334 0.019% 99.953% ( 250, 380 ] 419 0.024% 99.977% ( 380, 580 ] 627 0.035% 100.012% ( 580, 870 ] 587 0.033% 100.045% ( 870, 1300 ] 437 0.025% 100.070% ( 1300, 1900 ] 238 0.013% 100.084% ( 1900, 2900 ] 275 0.016% 100.099% ( 2900, 4400 ] 338 0.019% 100.118% ( 4400, 6600 ] 104 0.006% 100.124% ( 6600, 9900 ] 24 0.001% 100.125% ( 9900, 14000 ] 2 0.000% 100.126% ** Level 2 read latency histogram (micros): Count: 77093 Average: 3.8107 StdDev: 37.47 Min: 1 Median: 1.6150 Max: 4570 Percentiles: P50: 1.61 P75: 1.99 P99: 8.30 P99.9: 482.33 P99.99: 1454.88 ------------------------------------------------------ [ 0, 1 ] 7087 9.193% 9.193% ## ( 1, 2 ] 51157 66.358% 75.550% ############# ( 2, 3 ] 10845 14.067% 89.618% ### ( 3, 4 ] 3920 5.085% 94.703% # ( 4, 6 ] 2806 3.640% 98.342% # ( 6, 10 ] 883 1.145% 99.488% ( 10, 15 ] 105 0.136% 99.624% ( 15, 22 ] 17 0.022% 99.646% ( 22, 34 ] 4 0.005% 99.651% ( 51, 76 ] 2 0.003% 99.654% ( 76, 110 ] 16 0.021% 99.674% ( 110, 170 ] 74 0.096% 99.770% ( 170, 250 ] 47 0.061% 99.831% ( 250, 380 ] 35 0.045% 99.877% ( 380, 580 ] 35 0.045% 99.922% ( 580, 870 ] 28 0.036% 99.958% ( 870, 1300 ] 23 0.030% 99.988% ( 1300, 1900 ] 5 0.006% 99.995% ( 1900, 2900 ] 2 0.003% 99.997% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 631473 Average: 8.2393 StdDev: 104.38 Min: 0 Median: 1.8755 Max: 8803 Percentiles: P50: 1.88 P75: 2.82 P99: 9.96 P99.9: 975.97 P99.99: 1829.18 ------------------------------------------------------ [ 0, 1 ] 15681 2.483% 2.483% ( 1, 2 ] 342737 54.276% 56.759% ########### ( 2, 3 ] 140463 22.244% 79.003% #### ( 3, 4 ] 60988 9.658% 88.661% ## ( 4, 6 ] 53297 8.440% 97.101% ## ( 6, 10 ] 12120 1.919% 99.020% ( 10, 15 ] 2194 0.347% 99.368% ( 15, 22 ] 331 0.052% 99.420% ( 22, 34 ] 36 0.006% 99.426% ( 34, 51 ] 4 0.001% 99.426% ( 51, 76 ] 4 0.001% 99.427% ( 76, 110 ] 130 0.021% 99.448% ( 110, 170 ] 353 0.056% 99.504% ( 170, 250 ] 419 0.066% 99.570% ( 250, 380 ] 558 0.088% 99.658% ( 380, 580 ] 719 0.114% 99.772% ( 580, 870 ] 688 0.109% 99.881% ( 870, 1300 ] 485 0.077% 99.958% ( 1300, 1900 ] 230 0.036% 99.994% ( 1900, 2900 ] 172 0.027% 100.022% ( 2900, 4400 ] 190 0.030% 100.052% ( 4400, 6600 ] 60 0.010% 100.061% ( 6600, 9900 ] 4 0.001% 100.062% ** Level 4 read latency histogram (micros): Count: 216185 Average: 12.9175 StdDev: 139.35 Min: 0 Median: 1.9497 Max: 11283 Percentiles: P50: 1.95 P75: 2.94 P99: 51.62 P99.9: 1609.49 P99.99: 2934.02 ------------------------------------------------------ [ 0, 1 ] 2816 1.303% 1.303% ( 1, 2 ] 110854 51.277% 52.580% ########## ( 2, 3 ] 51546 23.843% 76.423% ##### ( 3, 4 ] 23108 10.689% 87.112% ## ( 4, 6 ] 20123 9.308% 96.421% ## ( 6, 10 ] 4476 2.070% 98.491% ( 10, 15 ] 957 0.443% 98.934% ( 15, 22 ] 124 0.057% 98.991% ( 22, 34 ] 12 0.006% 98.997% ( 34, 51 ] 7 0.003% 99.000% ( 51, 76 ] 6 0.003% 99.003% ( 76, 110 ] 17 0.008% 99.011% ( 110, 170 ] 73 0.034% 99.044% ( 170, 250 ] 170 0.079% 99.123% ( 250, 380 ] 258 0.119% 99.242% ( 380, 580 ] 451 0.209% 99.451% ( 580, 870 ] 512 0.237% 99.688% ( 870, 1300 ] 367 0.170% 99.858% ( 1300, 1900 ] 178 0.082% 99.940% ( 1900, 2900 ] 106 0.049% 99.989% ( 2900, 4400 ] 105 0.049% 100.037% ( 4400, 6600 ] 28 0.013% 100.050% ( 6600, 9900 ] 2 0.001% 100.051% ( 9900, 14000 ] 1 0.000% 100.052% ** Level 5 read latency histogram (micros): Count: 280 Average: 1420.9286 StdDev: 1530.91 Min: 94 Median: 743.5897 Max: 7309 Percentiles: P50: 743.59 P75: 2166.67 P99: 7309.00 P99.9: 7309.00 P99.99: 7309.00 ------------------------------------------------------ ( 76, 110 ] 6 2.143% 2.143% ( 110, 170 ] 29 10.357% 12.500% ## ( 170, 250 ] 24 8.571% 21.071% ## ( 250, 380 ] 26 9.286% 30.357% ## ( 380, 580 ] 33 11.786% 42.143% ## ( 580, 870 ] 39 13.929% 56.071% ### ( 870, 1300 ] 21 7.500% 63.571% ## ( 1300, 1900 ] 24 8.571% 72.143% ## ( 1900, 2900 ] 30 10.714% 82.857% ## ( 2900, 4400 ] 33 11.786% 94.643% ## ( 4400, 6600 ] 11 3.929% 98.571% # ( 6600, 9900 ] 4 1.429% 100.000% ** DB Stats ** Uptime(secs): 49.6 total, 16.4 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 178.41 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:24.559 H:M:S, 49.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 60.14 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:13.020 H:M:S, 79.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/07-16:47:27 ... thread 0: (1000000,10000000) ops and (333553.5,190656.1) ops/second in (2.998020,52.450462) 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/14 3.74 GB 0.0 10.8 0.0 10.8 20.2 9.5 0.0 2.1 151.0 283.6 72.98 66.14 168 0.434 11M 20K 0.0 0.0 L1 7/7 682.95 MB 0.0 8.2 5.5 2.7 8.1 5.4 0.2 1.5 223.3 220.5 37.64 35.51 4 9.411 7877K 50K 0.0 0.0 L2 1/0 84.18 MB 0.8 0.2 0.1 0.1 0.2 0.1 4.8 1.5 245.3 245.2 0.78 0.75 2 0.392 195K 86 0.0 0.0 L3 18/0 873.55 MB 0.9 2.7 1.2 1.5 2.7 1.2 3.8 2.3 159.1 158.1 17.44 12.45 12 1.453 2810K 17K 0.0 0.0 L4 153/0 9.62 GB 1.0 5.0 3.8 1.2 5.0 3.8 1.2 1.3 132.0 131.6 38.83 23.75 35 1.110 5161K 15K 0.0 0.0 L5 1100/0 90.49 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1293/21 105.45 GB 0.0 26.9 10.7 16.2 36.2 20.0 14.9 3.8 164.1 221.0 167.68 138.60 221 0.759 27M 103K 0.0 0.0 Int 0/0 0.00 KB 0.0 26.9 10.7 16.2 36.2 20.0 14.8 3.8 164.1 221.0 167.68 138.60 221 0.759 27M 103K 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 26.9 10.7 16.2 26.7 10.5 0.0 0.0 199.4 198.3 137.98 113.81 84 1.643 27M 103K 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 326.7 29.70 24.79 137 0.217 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): 52.6 total, 52.5 interval Flush(GB): cumulative 9.474, interval 9.474 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: 36.19 GB write, 703.94 MB/s write, 26.87 GB read, 522.71 MB/s read, 167.7 seconds Interval compaction: 36.19 GB write, 706.53 MB/s write, 26.87 GB read, 524.63 MB/s read, 167.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 18, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 18, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 60, pending-compaction-bytes-delays: 25, pending-compaction-bytes-stops: 0, total-delays: 43, total-stops: 60, interval: 103 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4320400 Average: 2.6294 StdDev: 26.34 Min: 0 Median: 1.4925 Max: 7956 Percentiles: P50: 1.49 P75: 1.87 P99: 5.97 P99.9: 105.59 P99.99: 303.19 ------------------------------------------------------ [ 0, 1 ] 768086 17.778% 17.778% #### ( 1, 2 ] 2826689 65.427% 83.205% ############# ( 2, 3 ] 417376 9.661% 92.865% ## ( 3, 4 ] 161153 3.730% 96.595% # ( 4, 6 ] 105617 2.445% 99.040% ( 6, 10 ] 29103 0.674% 99.714% ( 10, 15 ] 4877 0.113% 99.826% ( 15, 22 ] 707 0.016% 99.843% ( 22, 34 ] 58 0.001% 99.844% ( 34, 51 ] 32 0.001% 99.845% ( 51, 76 ] 136 0.003% 99.848% ( 76, 110 ] 2583 0.060% 99.908% ( 110, 170 ] 2581 0.060% 99.968% ( 170, 250 ] 742 0.017% 99.985% ( 250, 380 ] 562 0.013% 99.998% ( 380, 580 ] 464 0.011% 100.008% ( 580, 870 ] 288 0.007% 100.015% ( 870, 1300 ] 144 0.003% 100.018% ( 1300, 1900 ] 70 0.002% 100.020% ( 1900, 2900 ] 76 0.002% 100.022% ( 2900, 4400 ] 77 0.002% 100.024% ( 4400, 6600 ] 18 0.000% 100.024% ( 6600, 9900 ] 8 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 1768144 Average: 5.1627 StdDev: 81.90 Min: 0 Median: 1.7158 Max: 11988 Percentiles: P50: 1.72 P75: 2.52 P99: 8.99 P99.9: 131.25 P99.99: 454.90 ------------------------------------------------------ [ 0, 1 ] 168600 9.535% 9.535% ## ( 1, 2 ] 999538 56.530% 66.066% ########### ( 2, 3 ] 302821 17.126% 83.192% ### ( 3, 4 ] 131382 7.431% 90.623% # ( 4, 6 ] 123080 6.961% 97.584% # ( 6, 10 ] 33543 1.897% 99.481% ( 10, 15 ] 5284 0.299% 99.780% ( 15, 22 ] 727 0.041% 99.821% ( 22, 34 ] 64 0.004% 99.824% ( 34, 51 ] 15 0.001% 99.825% ( 51, 76 ] 76 0.004% 99.830% ( 76, 110 ] 915 0.052% 99.881% ( 110, 170 ] 934 0.053% 99.934% ( 170, 250 ] 334 0.019% 99.953% ( 250, 380 ] 419 0.024% 99.977% ( 380, 580 ] 628 0.036% 100.012% ( 580, 870 ] 587 0.033% 100.045% ( 870, 1300 ] 437 0.025% 100.070% ( 1300, 1900 ] 238 0.013% 100.084% ( 1900, 2900 ] 275 0.016% 100.099% ( 2900, 4400 ] 338 0.019% 100.118% ( 4400, 6600 ] 104 0.006% 100.124% ( 6600, 9900 ] 24 0.001% 100.125% ( 9900, 14000 ] 2 0.000% 100.126% ** Level 2 read latency histogram (micros): Count: 77093 Average: 3.8107 StdDev: 37.47 Min: 1 Median: 1.6150 Max: 4570 Percentiles: P50: 1.61 P75: 1.99 P99: 8.30 P99.9: 482.33 P99.99: 1454.88 ------------------------------------------------------ [ 0, 1 ] 7087 9.193% 9.193% ## ( 1, 2 ] 51157 66.358% 75.550% ############# ( 2, 3 ] 10845 14.067% 89.618% ### ( 3, 4 ] 3920 5.085% 94.703% # ( 4, 6 ] 2806 3.640% 98.342% # ( 6, 10 ] 883 1.145% 99.488% ( 10, 15 ] 105 0.136% 99.624% ( 15, 22 ] 17 0.022% 99.646% ( 22, 34 ] 4 0.005% 99.651% ( 51, 76 ] 2 0.003% 99.654% ( 76, 110 ] 16 0.021% 99.674% ( 110, 170 ] 74 0.096% 99.770% ( 170, 250 ] 47 0.061% 99.831% ( 250, 380 ] 35 0.045% 99.877% ( 380, 580 ] 35 0.045% 99.922% ( 580, 870 ] 28 0.036% 99.958% ( 870, 1300 ] 23 0.030% 99.988% ( 1300, 1900 ] 5 0.006% 99.995% ( 1900, 2900 ] 2 0.003% 99.997% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 631473 Average: 8.2393 StdDev: 104.38 Min: 0 Median: 1.8755 Max: 8803 Percentiles: P50: 1.88 P75: 2.82 P99: 9.96 P99.9: 975.97 P99.99: 1829.18 ------------------------------------------------------ [ 0, 1 ] 15681 2.483% 2.483% ( 1, 2 ] 342737 54.276% 56.759% ########### ( 2, 3 ] 140463 22.244% 79.003% #### ( 3, 4 ] 60988 9.658% 88.661% ## ( 4, 6 ] 53297 8.440% 97.101% ## ( 6, 10 ] 12120 1.919% 99.020% ( 10, 15 ] 2194 0.347% 99.368% ( 15, 22 ] 331 0.052% 99.420% ( 22, 34 ] 36 0.006% 99.426% ( 34, 51 ] 4 0.001% 99.426% ( 51, 76 ] 4 0.001% 99.427% ( 76, 110 ] 130 0.021% 99.448% ( 110, 170 ] 353 0.056% 99.504% ( 170, 250 ] 419 0.066% 99.570% ( 250, 380 ] 558 0.088% 99.658% ( 380, 580 ] 719 0.114% 99.772% ( 580, 870 ] 688 0.109% 99.881% ( 870, 1300 ] 485 0.077% 99.958% ( 1300, 1900 ] 230 0.036% 99.994% ( 1900, 2900 ] 172 0.027% 100.022% ( 2900, 4400 ] 190 0.030% 100.052% ( 4400, 6600 ] 60 0.010% 100.061% ( 6600, 9900 ] 4 0.001% 100.062% ** Level 4 read latency histogram (micros): Count: 222761 Average: 12.6177 StdDev: 137.31 Min: 0 Median: 1.9349 Max: 11283 Percentiles: P50: 1.93 P75: 2.92 P99: 19.95 P99.9: 1587.32 P99.99: 2924.63 ------------------------------------------------------ [ 0, 1 ] 3361 1.509% 1.509% ( 1, 2 ] 115547 51.870% 53.379% ########## ( 2, 3 ] 52439 23.540% 76.920% ##### ( 3, 4 ] 23321 10.469% 87.389% ## ( 4, 6 ] 20228 9.081% 96.469% ## ( 6, 10 ] 4587 2.059% 98.528% ( 10, 15 ] 962 0.432% 98.960% ( 15, 22 ] 125 0.056% 99.016% ( 22, 34 ] 12 0.005% 99.022% ( 34, 51 ] 7 0.003% 99.025% ( 51, 76 ] 6 0.003% 99.028% ( 76, 110 ] 17 0.008% 99.035% ( 110, 170 ] 76 0.034% 99.069% ( 170, 250 ] 172 0.077% 99.147% ( 250, 380 ] 260 0.117% 99.263% ( 380, 580 ] 452 0.203% 99.466% ( 580, 870 ] 514 0.231% 99.697% ( 870, 1300 ] 367 0.165% 99.862% ( 1300, 1900 ] 178 0.080% 99.942% ( 1900, 2900 ] 106 0.048% 99.989% ( 2900, 4400 ] 105 0.047% 100.036% ( 4400, 6600 ] 28 0.013% 100.049% ( 6600, 9900 ] 2 0.001% 100.050% ( 9900, 14000 ] 1 0.000% 100.050% ** Level 5 read latency histogram (micros): Count: 300 Average: 1398.7900 StdDev: 1518.05 Min: 94 Median: 735.6098 Max: 7309 Percentiles: P50: 735.61 P75: 2093.55 P99: 7309.00 P99.9: 7309.00 P99.99: 7309.00 ------------------------------------------------------ ( 76, 110 ] 8 2.667% 2.667% # ( 110, 170 ] 31 10.333% 13.000% ## ( 170, 250 ] 26 8.667% 21.667% ## ( 250, 380 ] 29 9.667% 31.333% ## ( 380, 580 ] 34 11.333% 42.667% ## ( 580, 870 ] 41 13.667% 56.333% ### ( 870, 1300 ] 24 8.000% 64.333% ## ( 1300, 1900 ] 26 8.667% 73.000% ## ( 1900, 2900 ] 31 10.333% 83.333% ## ( 2900, 4400 ] 34 11.333% 94.667% ## ( 4400, 6600 ] 12 4.000% 98.667% # ( 6600, 9900 ] 4 1.333% 100.000% ** DB Stats ** Uptime(secs): 52.6 total, 3.0 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 186.95 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:24.929 H:M:S, 47.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 328.29 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.370 H:M:S, 12.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 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.599 micros/op 178605 ops/sec 60.121 seconds 10737999 operations; 173.1 MB/s Microseconds per write: Count: 10737999 Average: 5.5989 StdDev: 424.09 Min: 0 Median: 1.7549 Max: 867904 Percentiles: P50: 1.75 P75: 2.80 P99: 9.23 P99.9: 1109.75 P99.99: 2510.13 ------------------------------------------------------ [ 0, 1 ] 1336238 12.444% 12.444% ## ( 1, 2 ] 5342095 49.749% 62.193% ########## ( 2, 3 ] 1728305 16.095% 78.289% ### ( 3, 4 ] 1518216 14.139% 92.427% ### ( 4, 6 ] 606856 5.651% 98.079% # ( 6, 10 ] 122579 1.142% 99.220% ( 10, 15 ] 39838 0.371% 99.591% ( 15, 22 ] 9753 0.091% 99.682% ( 22, 34 ] 1944 0.018% 99.700% ( 34, 51 ] 217 0.002% 99.702% ( 51, 76 ] 36 0.000% 99.703% ( 76, 110 ] 7304 0.068% 99.771% ( 110, 170 ] 3092 0.029% 99.800% ( 170, 250 ] 322 0.003% 99.803% ( 250, 380 ] 185 0.002% 99.804% ( 380, 580 ] 24 0.000% 99.804% ( 580, 870 ] 19 0.000% 99.805% ( 870, 1300 ] 18362 0.171% 99.976% ( 1300, 1900 ] 35 0.000% 99.976% ( 1900, 2900 ] 2467 0.023% 99.999% ( 2900, 4400 ] 66 0.001% 100.000% ( 4400, 6600 ] 15 0.000% 100.000% ( 6600, 9900 ] 6 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 16 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% ( 860000, 1200000 ] 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 : 189140 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 : 10737999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 11081614968 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 : 547 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 30338863 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 : 31831054395 rocksdb.compact.write.bytes COUNT : 31642953013 rocksdb.flush.write.bytes COUNT : 11031418817 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 : 67 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 : 334 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 : 10942577664 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4354048 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 : 31936654125 rocksdb.non.last.level.read.count COUNT : 7712660 rocksdb.block.checksum.compute.count COUNT : 7711633 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.411696 P95 : 3.924877 P99 : 7.712629 P100 : 867902.000000 COUNT : 10737999 SUM : 55074871 rocksdb.compaction.times.micros P50 : 1129166.666667 P95 : 4136666.666667 P99 : 17842085.000000 P100 : 17842085.000000 COUNT : 87 SUM : 141311421 rocksdb.compaction.times.cpu_micros P50 : 932250.000000 P95 : 4136666.666667 P99 : 15040000.000000 P100 : 16334112.000000 COUNT : 87 SUM : 117083295 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 : 697.380952 P95 : 1780.000000 P99 : 41840.000000 P100 : 96613.000000 COUNT : 148 SUM : 290720 rocksdb.compaction.outfile.sync.micros P50 : 1165.625000 P95 : 134400.000000 P99 : 216200.000000 P100 : 219329.000000 COUNT : 338 SUM : 7031385 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 : 98.477778 P95 : 1367.500000 P99 : 3972.500000 P100 : 4624.000000 COUNT : 271 SUM : 83127 rocksdb.table.open.io.micros P50 : 1600.000000 P95 : 9142.031250 P99 : 13404.294118 P100 : 17102.000000 COUNT : 547 SUM : 1296260 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.621721 P95 : 7.368467 P99 : 10.197352 P100 : 11994.000000 COUNT : 7710031 SUM : 46210687 rocksdb.read.block.get.micros P50 : 503.913043 P95 : 3877.205882 P99 : 6097.384615 P100 : 7414.000000 COUNT : 1094 SUM : 1063152 rocksdb.write.raw.block.micros P50 : 0.512438 P95 : 0.973633 P99 : 2.863532 P100 : 12482.000000 COUNT : 10335222 SUM : 20431110 rocksdb.numfiles.in.singlecompaction P50 : 3.303191 P95 : 3.997340 P99 : 18.616667 P100 : 22.000000 COUNT : 145 SUM : 552 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.559179 P95 : 1127.592484 P99 : 2128.538776 P100 : 867719.000000 COUNT : 198608 SUM : 30356320 rocksdb.sst.read.micros P50 : 1.571257 P95 : 4.327506 P99 : 8.036230 P100 : 11988.000000 COUNT : 7712831 SUM : 30680118 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 : 10737999 SUM : 11081614968 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 : 210000.000000 P95 : 362666.666667 P99 : 720800.000000 P100 : 1013188.000000 COUNT : 148 SUM : 32041748 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 : 345 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