[2024-12-16 13:24:26.234696] Starting SPDK v25.01-pre git sha1 e01cb43b8 / DPDK 24.03.0 initialization... [2024-12-16 13:24:26.234838] [ 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_pid1657572 ] Set seed to 1734351866231142 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-16 13:24:26.351182] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-16 13:24:26.459323] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-16 13:24:26.459368] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1657572' to capture a snapshot of events at runtime. [2024-12-16 13:24:26.459378] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-16 13:24:26.459389] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-16 13:24:26.459397] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1657572 for offline analysis/debug. [2024-12-16 13:24:26.460838] reactor.c: 995:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Mon Dec 16 13:24:34 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/16-13:24:37 ... thread 0: (1000000,1000000) ops and (362484.6,362484.6) ops/second in (2.758738,2.758738) 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 8/8 504.02 MB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 359.6 2.28 2.04 12 0.190 0 0 0.0 0.0 L1 3/3 188.87 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 259.2 259.1 0.73 0.70 1 0.729 191K 86 0.0 0.0 L2 2/1 125.96 MB 0.0 0.1 0.1 0.1 0.1 0.1 0.2 2.0 245.0 245.0 0.51 0.49 1 0.514 127K 44 0.0 0.0 L3 8/0 678.44 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.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.4 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/12 96.94 GB 0.0 0.3 0.2 0.1 1.1 1.0 1.1 1.4 89.5 322.0 3.52 3.24 14 0.251 319K 130 0.0 0.0 Int 0/0 0.00 KB 0.0 0.3 0.2 0.1 1.1 1.0 1.0 1.4 89.5 322.0 3.52 3.24 14 0.251 319K 130 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.3 0.2 0.1 0.3 0.2 0.0 0.0 253.4 253.2 1.24 1.20 2 0.622 319K 130 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 359.6 2.28 2.04 12 0.190 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.11 GB write, 378.42 MB/s write, 0.31 GB read, 105.12 MB/s read, 3.5 seconds Interval compaction: 1.11 GB write, 410.56 MB/s write, 0.31 GB read, 114.05 MB/s read, 3.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 118614 Average: 1.9749 StdDev: 19.90 Min: 0 Median: 1.2797 Max: 3525 Percentiles: P50: 1.28 P75: 1.70 P99: 4.75 P99.9: 10.38 P99.99: 141.04 ------------------------------------------------------ [ 0, 1 ] 39358 33.182% 33.182% ####### ( 1, 2 ] 71315 60.124% 93.305% ############ ( 2, 3 ] 4436 3.740% 97.045% # ( 3, 4 ] 1892 1.595% 98.640% ( 4, 6 ] 1134 0.956% 99.596% ( 6, 10 ] 355 0.299% 99.895% ( 10, 15 ] 83 0.070% 99.965% ( 15, 22 ] 18 0.015% 99.981% ( 22, 34 ] 2 0.002% 99.982% ( 34, 51 ] 4 0.003% 99.986% ( 51, 76 ] 2 0.002% 99.987% ( 110, 170 ] 8 0.007% 99.994% ( 170, 250 ] 3 0.003% 99.997% ( 250, 380 ] 2 0.002% 99.998% ( 380, 580 ] 5 0.004% 100.003% ( 580, 870 ] 1 0.001% 100.003% ( 1300, 1900 ] 2 0.002% 100.005% ( 2900, 4400 ] 4 0.003% 100.008% ** Level 1 read latency histogram (micros): Count: 22484 Average: 2.2200 StdDev: 26.75 Min: 1 Median: 1.3209 Max: 2783 Percentiles: P50: 1.32 P75: 1.72 P99: 4.74 P99.9: 11.88 P99.99: 1246.59 ------------------------------------------------------ [ 0, 1 ] 6761 30.070% 30.070% ###### ( 1, 2 ] 13963 62.102% 92.172% ############ ( 2, 3 ] 1078 4.795% 96.967% # ( 3, 4 ] 370 1.646% 98.612% ( 4, 6 ] 234 1.041% 99.653% ( 6, 10 ] 48 0.213% 99.867% ( 10, 15 ] 20 0.089% 99.956% ( 15, 22 ] 1 0.004% 99.960% ( 76, 110 ] 1 0.004% 99.964% ( 170, 250 ] 1 0.004% 99.969% ( 250, 380 ] 2 0.009% 99.978% ( 380, 580 ] 1 0.004% 99.982% ( 870, 1300 ] 2 0.009% 99.991% ( 1900, 2900 ] 2 0.009% 100.000% ** Level 2 read latency histogram (micros): Count: 7441 Average: 2.7604 StdDev: 5.83 Min: 1 Median: 1.7512 Max: 388 Percentiles: P50: 1.75 P75: 2.54 P99: 8.69 P99.9: 14.85 P99.99: 388.00 ------------------------------------------------------ [ 0, 1 ] 373 5.013% 5.013% # ( 1, 2 ] 4458 59.911% 64.924% ############ ( 2, 3 ] 1391 18.694% 83.618% #### ( 3, 4 ] 503 6.760% 90.378% # ( 4, 6 ] 537 7.217% 97.594% # ( 6, 10 ] 160 2.150% 99.745% ( 10, 15 ] 15 0.202% 99.946% ( 15, 22 ] 3 0.040% 99.987% ( 22, 34 ] 1 0.013% 100.000% ( 51, 76 ] 1 0.013% 100.013% ( 250, 380 ] 1 0.013% 100.027% ( 380, 580 ] 1 0.013% 100.040% ** Level 3 read latency histogram (micros): Count: 55 Average: 3305.1455 StdDev: 2330.38 Min: 182 Median: 2556.2500 Max: 9543 Percentiles: P50: 2556.25 P75: 4950.00 P99: 9543.00 P99.9: 9543.00 P99.99: 9543.00 ------------------------------------------------------ ( 170, 250 ] 2 3.636% 3.636% # ( 250, 380 ] 1 1.818% 5.455% ( 380, 580 ] 2 3.636% 9.091% # ( 580, 870 ] 1 1.818% 10.909% ( 870, 1300 ] 3 5.455% 16.364% # ( 1300, 1900 ] 8 14.545% 30.909% ### ( 1900, 2900 ] 16 29.091% 60.000% ###### ( 2900, 4400 ] 6 10.909% 70.909% ## ( 4400, 6600 ] 9 16.364% 87.273% ### ( 6600, 9900 ] 7 12.727% 100.000% ### ** Level 4 read latency histogram (micros): Count: 20 Average: 4028.2500 StdDev: 2097.37 Min: 1166 Median: 3275.0000 Max: 8085 Percentiles: P50: 3275.00 P75: 6600.00 P99: 8085.00 P99.9: 8085.00 P99.99: 8085.00 ------------------------------------------------------ ( 870, 1300 ] 1 5.000% 5.000% # ( 1300, 1900 ] 1 5.000% 10.000% # ( 1900, 2900 ] 7 35.000% 45.000% ####### ( 2900, 4400 ] 4 20.000% 65.000% #### ( 4400, 6600 ] 2 10.000% 75.000% ## ( 6600, 9900 ] 5 25.000% 100.000% ##### ** Level 5 read latency histogram (micros): Count: 20 Average: 546.3500 StdDev: 704.47 Min: 77 Median: 130.0000 Max: 2261 Percentiles: P50: 130.00 P75: 725.00 P99: 2261.00 P99.9: 2261.00 P99.99: 2261.00 ------------------------------------------------------ ( 76, 110 ] 9 45.000% 45.000% ######### ( 110, 170 ] 3 15.000% 60.000% ### ( 380, 580 ] 2 10.000% 70.000% ## ( 580, 870 ] 2 10.000% 80.000% ## ( 1300, 1900 ] 2 10.000% 90.000% ## ( 1900, 2900 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 328.45 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.175 H:M:S, 5.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 356.30 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.175 H:M:S, 6.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/16-13:24:40 ... thread 0: (1000000,2000000) ops and (328742.0,344789.7) ops/second in (3.041899,5.800637) 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 1.23 GB 94.4 0.8 0.0 0.8 2.6 1.8 0.0 1.4 100.2 323.5 8.18 7.57 29 0.282 831K 826 0.0 0.0 L1 1/0 3.06 MB 0.3 0.6 0.4 0.2 0.6 0.4 0.1 1.4 246.0 245.7 2.56 2.49 2 1.280 639K 814 0.0 0.0 L2 5/3 437.89 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.6 2.0 245.0 245.0 0.51 0.49 1 0.514 127K 44 0.0 0.0 L3 16/1 803.55 MB 0.7 0.1 0.1 0.0 0.1 0.1 0.1 1.0 215.2 215.3 0.58 0.53 1 0.581 127K 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.4 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 1191/8 97.92 GB 0.0 1.7 0.6 1.0 3.4 2.4 1.5 1.9 143.7 297.9 11.83 11.08 33 0.359 1726K 1684 0.0 0.0 Int 0/0 0.00 KB 0.0 1.7 0.6 1.0 3.4 2.4 1.4 1.9 143.7 297.9 11.83 11.08 33 0.359 1726K 1684 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.7 0.6 1.0 1.7 0.6 0.0 0.0 252.1 251.8 6.74 6.54 7 0.963 1726K 1684 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 359.1 5.09 4.54 26 0.196 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.0 total, 5.8 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.44 GB write, 583.80 MB/s write, 1.66 GB read, 281.54 MB/s read, 11.8 seconds Interval compaction: 3.44 GB write, 607.40 MB/s write, 1.66 GB read, 292.91 MB/s read, 11.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 6, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 6, interval: 6 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 385669 Average: 2.1593 StdDev: 12.76 Min: 0 Median: 1.4615 Max: 3525 Percentiles: P50: 1.46 P75: 1.85 P99: 5.59 P99.9: 11.12 P99.99: 18.64 ------------------------------------------------------ [ 0, 1 ] 78912 20.461% 20.461% #### ( 1, 2 ] 246875 64.012% 84.473% ############# ( 2, 3 ] 39235 10.173% 94.646% ## ( 3, 4 ] 10666 2.766% 97.412% # ( 4, 6 ] 7702 1.997% 99.409% ( 6, 10 ] 1801 0.467% 99.876% ( 10, 15 ] 416 0.108% 99.984% ( 15, 22 ] 47 0.012% 99.996% ( 22, 34 ] 11 0.003% 99.999% ( 34, 51 ] 7 0.002% 100.001% ( 51, 76 ] 2 0.001% 100.001% ( 110, 170 ] 13 0.003% 100.005% ( 170, 250 ] 10 0.003% 100.007% ( 250, 380 ] 6 0.002% 100.009% ( 380, 580 ] 9 0.002% 100.011% ( 580, 870 ] 8 0.002% 100.013% ( 870, 1300 ] 6 0.002% 100.015% ( 1300, 1900 ] 2 0.001% 100.015% ( 1900, 2900 ] 1 0.000% 100.016% ( 2900, 4400 ] 4 0.001% 100.017% ** Level 1 read latency histogram (micros): Count: 102598 Average: 2.4007 StdDev: 14.64 Min: 1 Median: 1.5959 Max: 2783 Percentiles: P50: 1.60 P75: 1.99 P99: 5.82 P99.9: 13.14 P99.99: 339.06 ------------------------------------------------------ [ 0, 1 ] 12172 11.864% 11.864% ## ( 1, 2 ] 65663 64.000% 75.864% ############# ( 2, 3 ] 17560 17.115% 92.979% ### ( 3, 4 ] 3406 3.320% 96.299% # ( 4, 6 ] 3049 2.972% 99.271% # ( 6, 10 ] 553 0.539% 99.810% ( 10, 15 ] 147 0.143% 99.953% ( 15, 22 ] 23 0.022% 99.976% ( 22, 34 ] 8 0.008% 99.983% ( 76, 110 ] 1 0.001% 99.984% ( 110, 170 ] 2 0.002% 99.986% ( 170, 250 ] 1 0.001% 99.987% ( 250, 380 ] 4 0.004% 99.991% ( 380, 580 ] 2 0.002% 99.993% ( 580, 870 ] 1 0.001% 99.994% ( 870, 1300 ] 3 0.003% 99.997% ( 1300, 1900 ] 1 0.001% 99.998% ( 1900, 2900 ] 2 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 31769 Average: 2.5522 StdDev: 2.99 Min: 1 Median: 1.7171 Max: 388 Percentiles: P50: 1.72 P75: 2.36 P99: 7.16 P99.9: 12.47 P99.99: 31.88 ------------------------------------------------------ [ 0, 1 ] 1520 4.785% 4.785% # ( 1, 2 ] 20031 63.052% 67.837% ############# ( 2, 3 ] 6235 19.626% 87.463% #### ( 3, 4 ] 1745 5.493% 92.955% # ( 4, 6 ] 1812 5.704% 98.659% # ( 6, 10 ] 373 1.174% 99.833% ( 10, 15 ] 43 0.135% 99.969% ( 15, 22 ] 6 0.019% 99.987% ( 22, 34 ] 1 0.003% 99.991% ( 51, 76 ] 1 0.003% 99.994% ( 250, 380 ] 1 0.003% 99.997% ( 380, 580 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 15867 Average: 13.9227 StdDev: 237.86 Min: 1 Median: 1.6731 Max: 9543 Percentiles: P50: 1.67 P75: 2.21 P99: 7.67 P99.9: 4432.51 P99.99: 9151.98 ------------------------------------------------------ [ 0, 1 ] 1184 7.462% 7.462% # ( 1, 2 ] 10027 63.194% 70.656% ############# ( 2, 3 ] 3307 20.842% 91.498% #### ( 3, 4 ] 611 3.851% 95.349% # ( 4, 6 ] 525 3.309% 98.658% # ( 6, 10 ] 130 0.819% 99.477% ( 10, 15 ] 23 0.145% 99.622% ( 15, 22 ] 2 0.013% 99.634% ( 22, 34 ] 1 0.006% 99.641% ( 170, 250 ] 2 0.013% 99.653% ( 250, 380 ] 1 0.006% 99.660% ( 380, 580 ] 3 0.019% 99.679% ( 580, 870 ] 1 0.006% 99.685% ( 870, 1300 ] 4 0.025% 99.710% ( 1300, 1900 ] 8 0.050% 99.761% ( 1900, 2900 ] 16 0.101% 99.861% ( 2900, 4400 ] 6 0.038% 99.899% ( 4400, 6600 ] 9 0.057% 99.956% ( 6600, 9900 ] 7 0.044% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 4028.2500 StdDev: 2097.37 Min: 1166 Median: 3275.0000 Max: 8085 Percentiles: P50: 3275.00 P75: 6600.00 P99: 8085.00 P99.9: 8085.00 P99.99: 8085.00 ------------------------------------------------------ ( 870, 1300 ] 1 5.000% 5.000% # ( 1300, 1900 ] 1 5.000% 10.000% # ( 1900, 2900 ] 7 35.000% 45.000% ####### ( 2900, 4400 ] 4 20.000% 65.000% #### ( 4400, 6600 ] 2 10.000% 75.000% ## ( 6600, 9900 ] 5 25.000% 100.000% ##### ** Level 5 read latency histogram (micros): Count: 20 Average: 546.3500 StdDev: 704.47 Min: 77 Median: 130.0000 Max: 2261 Percentiles: P50: 130.00 P75: 725.00 P99: 2261.00 P99.9: 2261.00 P99.99: 2261.00 ------------------------------------------------------ ( 76, 110 ] 9 45.000% 45.000% ######### ( 110, 170 ] 3 15.000% 60.000% ### ( 380, 580 ] 2 10.000% 70.000% ## ( 580, 870 ] 2 10.000% 80.000% ## ( 1300, 1900 ] 2 10.000% 90.000% ## ( 1900, 2900 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 6.0 total, 3.0 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 325.98 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.559 H:M:S, 9.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 323.55 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.385 H:M:S, 12.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/16-13:24:43 ... thread 0: (1000000,3000000) ops and (350876.3,346795.0) ops/second in (2.850007,8.650644) 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/8 2.15 GB 169.9 1.7 0.0 1.7 4.4 2.7 0.0 1.6 120.3 316.3 14.13 13.17 46 0.307 1727K 1838 0.0 0.0 L1 1/0 3.06 MB 0.3 0.6 0.4 0.2 0.6 0.4 0.1 1.4 246.0 245.7 2.56 2.49 2 1.280 639K 814 0.0 0.0 L2 2/0 51.60 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.6 2.0 245.0 245.0 0.51 0.49 1 0.514 127K 44 0.0 0.0 L3 49/0 979.03 MB 1.0 0.6 0.5 0.1 0.6 0.5 0.1 1.2 195.8 195.7 3.19 2.77 2 1.593 633K 472 0.0 0.0 L4 136/0 9.49 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.18 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1250/8 98.84 GB 0.0 3.0 1.0 2.0 5.7 3.7 2.0 2.1 151.1 286.8 20.39 18.92 51 0.400 3128K 3168 0.0 0.0 Int 0/0 0.00 KB 0.0 3.0 1.0 2.0 5.7 3.7 1.9 2.1 151.1 286.8 20.39 18.92 51 0.400 3128K 3168 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 3.0 1.0 2.0 3.0 1.0 0.0 0.0 242.7 242.4 12.69 12.06 11 1.154 3128K 3168 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 360.0 7.70 6.86 40 0.192 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): 8.9 total, 8.7 interval Flush(GB): cumulative 2.707, interval 2.707 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.71 GB write, 658.12 MB/s write, 3.01 GB read, 346.63 MB/s read, 20.4 seconds Interval compaction: 5.71 GB write, 675.96 MB/s write, 3.01 GB read, 356.02 MB/s read, 20.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: 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: 645123 Average: 2.1608 StdDev: 12.11 Min: 0 Median: 1.4714 Max: 3691 Percentiles: P50: 1.47 P75: 1.86 P99: 5.55 P99.9: 10.71 P99.99: 16.06 ------------------------------------------------------ [ 0, 1 ] 125570 19.465% 19.465% #### ( 1, 2 ] 417913 64.780% 84.245% ############# ( 2, 3 ] 67744 10.501% 94.746% ## ( 3, 4 ] 17634 2.733% 97.479% # ( 4, 6 ] 12637 1.959% 99.438% ( 6, 10 ] 2887 0.448% 99.886% ( 10, 15 ] 664 0.103% 99.989% ( 15, 22 ] 69 0.011% 99.999% ( 22, 34 ] 12 0.002% 100.001% ( 34, 51 ] 11 0.002% 100.003% ( 51, 76 ] 5 0.001% 100.004% ( 110, 170 ] 17 0.003% 100.006% ( 170, 250 ] 19 0.003% 100.009% ( 250, 380 ] 9 0.001% 100.011% ( 380, 580 ] 14 0.002% 100.013% ( 580, 870 ] 14 0.002% 100.015% ( 870, 1300 ] 11 0.002% 100.017% ( 1300, 1900 ] 2 0.000% 100.017% ( 1900, 2900 ] 2 0.000% 100.017% ( 2900, 4400 ] 5 0.001% 100.018% ** Level 1 read latency histogram (micros): Count: 146065 Average: 2.4029 StdDev: 12.28 Min: 1 Median: 1.6261 Max: 2783 Percentiles: P50: 1.63 P75: 2.06 P99: 5.82 P99.9: 12.82 P99.99: 151.80 ------------------------------------------------------ [ 0, 1 ] 14701 10.065% 10.065% ## ( 1, 2 ] 93160 63.780% 73.845% ############# ( 2, 3 ] 27506 18.831% 92.676% #### ( 3, 4 ] 5069 3.470% 96.146% # ( 4, 6 ] 4586 3.140% 99.286% # ( 6, 10 ] 777 0.532% 99.818% ( 10, 15 ] 213 0.146% 99.964% ( 15, 22 ] 27 0.018% 99.982% ( 22, 34 ] 8 0.005% 99.988% ( 34, 51 ] 1 0.001% 99.988% ( 76, 110 ] 1 0.001% 99.989% ( 110, 170 ] 2 0.001% 99.990% ( 170, 250 ] 1 0.001% 99.991% ( 250, 380 ] 4 0.003% 99.994% ( 380, 580 ] 2 0.001% 99.995% ( 580, 870 ] 1 0.001% 99.996% ( 870, 1300 ] 3 0.002% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31769 Average: 2.5522 StdDev: 2.99 Min: 1 Median: 1.7171 Max: 388 Percentiles: P50: 1.72 P75: 2.36 P99: 7.16 P99.9: 12.47 P99.99: 31.88 ------------------------------------------------------ [ 0, 1 ] 1520 4.785% 4.785% # ( 1, 2 ] 20031 63.052% 67.837% ############# ( 2, 3 ] 6235 19.626% 87.463% #### ( 3, 4 ] 1745 5.493% 92.955% # ( 4, 6 ] 1812 5.704% 98.659% # ( 6, 10 ] 373 1.174% 99.833% ( 10, 15 ] 43 0.135% 99.969% ( 15, 22 ] 6 0.019% 99.987% ( 22, 34 ] 1 0.003% 99.991% ( 51, 76 ] 1 0.003% 99.994% ( 250, 380 ] 1 0.003% 99.997% ( 380, 580 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28992 Average: 8.8557 StdDev: 176.24 Min: 1 Median: 1.6786 Max: 9543 Percentiles: P50: 1.68 P75: 2.23 P99: 8.17 P99.9: 2463.00 P99.99: 8533.23 ------------------------------------------------------ [ 0, 1 ] 2132 7.354% 7.354% # ( 1, 2 ] 18221 62.848% 70.202% ############# ( 2, 3 ] 6175 21.299% 91.501% #### ( 3, 4 ] 1090 3.760% 95.261% # ( 4, 6 ] 957 3.301% 98.562% # ( 6, 10 ] 234 0.807% 99.369% ( 10, 15 ] 77 0.266% 99.634% ( 15, 22 ] 20 0.069% 99.703% ( 22, 34 ] 2 0.007% 99.710% ( 34, 51 ] 8 0.028% 99.738% ( 51, 76 ] 6 0.021% 99.759% ( 76, 110 ] 7 0.024% 99.783% ( 110, 170 ] 1 0.003% 99.786% ( 170, 250 ] 5 0.017% 99.803% ( 250, 380 ] 1 0.003% 99.807% ( 380, 580 ] 3 0.010% 99.817% ( 580, 870 ] 2 0.007% 99.824% ( 870, 1300 ] 5 0.017% 99.841% ( 1300, 1900 ] 8 0.028% 99.869% ( 1900, 2900 ] 16 0.055% 99.924% ( 2900, 4400 ] 6 0.021% 99.945% ( 4400, 6600 ] 9 0.031% 99.976% ( 6600, 9900 ] 7 0.024% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 4028.2500 StdDev: 2097.37 Min: 1166 Median: 3275.0000 Max: 8085 Percentiles: P50: 3275.00 P75: 6600.00 P99: 8085.00 P99.9: 8085.00 P99.99: 8085.00 ------------------------------------------------------ ( 870, 1300 ] 1 5.000% 5.000% # ( 1300, 1900 ] 1 5.000% 10.000% # ( 1900, 2900 ] 7 35.000% 45.000% ####### ( 2900, 4400 ] 4 20.000% 65.000% #### ( 4400, 6600 ] 2 10.000% 75.000% ## ( 6600, 9900 ] 5 25.000% 100.000% ##### ** Level 5 read latency histogram (micros): Count: 40 Average: 814.2750 StdDev: 1180.12 Min: 77 Median: 234.0000 Max: 4345 Percentiles: P50: 234.00 P75: 812.00 P99: 4250.00 P99.9: 4345.00 P99.99: 4345.00 ------------------------------------------------------ ( 76, 110 ] 11 27.500% 27.500% ###### ( 110, 170 ] 5 12.500% 40.000% ### ( 170, 250 ] 5 12.500% 52.500% ### ( 250, 380 ] 3 7.500% 60.000% ## ( 380, 580 ] 2 5.000% 65.000% # ( 580, 870 ] 5 12.500% 77.500% ### ( 870, 1300 ] 1 2.500% 80.000% # ( 1300, 1900 ] 2 5.000% 85.000% # ( 1900, 2900 ] 2 5.000% 90.000% # ( 2900, 4400 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 8.9 total, 2.9 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 332.19 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.773 H:M:S, 8.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 345.33 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.213 H:M:S, 7.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/16-13:24:46 ... thread 0: (1000000,4000000) ops and (332835.9,343196.6) ops/second in (3.004484,11.655128) 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/16 3.13 GB 44.1 2.4 0.0 2.4 6.1 3.7 0.0 1.6 124.4 315.6 19.75 18.40 63 0.314 2494K 2573 0.0 0.0 L1 1/1 3.06 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 246.0 245.7 2.56 2.49 2 1.280 639K 814 0.0 0.0 L2 2/0 51.60 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.6 2.0 245.0 245.0 0.51 0.49 1 0.514 127K 44 0.0 0.0 L3 49/0 979.03 MB 1.0 0.6 0.5 0.1 0.6 0.5 0.1 1.2 195.8 195.7 3.19 2.77 2 1.593 633K 472 0.0 0.0 L4 136/0 9.49 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.18 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1255/17 99.82 GB 0.0 3.7 1.0 2.8 7.4 4.7 2.0 2.0 147.5 292.6 26.01 24.15 68 0.383 3895K 3903 0.0 0.0 Int 0/0 0.00 KB 0.0 3.7 1.0 2.8 7.4 4.7 1.9 2.0 147.5 292.6 26.01 24.15 68 0.383 3895K 3903 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 3.7 1.0 2.8 3.7 1.0 0.0 0.0 247.1 246.9 15.52 14.83 14 1.109 3895K 3903 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 360.4 10.49 9.32 54 0.194 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 11.9 total, 11.7 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.43 GB write, 640.12 MB/s write, 3.75 GB read, 322.63 MB/s read, 26.0 seconds Interval compaction: 7.43 GB write, 653.00 MB/s write, 3.75 GB read, 329.12 MB/s read, 26.0 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: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 13, interval: 13 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 914034 Average: 2.1764 StdDev: 14.90 Min: 0 Median: 1.4703 Max: 6765 Percentiles: P50: 1.47 P75: 1.85 P99: 5.49 P99.9: 10.71 P99.99: 19.20 ------------------------------------------------------ [ 0, 1 ] 175962 19.251% 19.251% #### ( 1, 2 ] 597546 65.375% 84.626% ############# ( 2, 3 ] 96095 10.513% 95.139% ## ( 3, 4 ] 23222 2.541% 97.680% # ( 4, 6 ] 16169 1.769% 99.449% ( 6, 10 ] 4000 0.438% 99.886% ( 10, 15 ] 899 0.098% 99.985% ( 15, 22 ] 86 0.009% 99.994% ( 22, 34 ] 14 0.002% 99.996% ( 34, 51 ] 11 0.001% 99.997% ( 51, 76 ] 8 0.001% 99.998% ( 76, 110 ] 7 0.001% 99.998% ( 110, 170 ] 41 0.004% 100.003% ( 170, 250 ] 43 0.005% 100.008% ( 250, 380 ] 20 0.002% 100.010% ( 380, 580 ] 24 0.003% 100.012% ( 580, 870 ] 20 0.002% 100.015% ( 870, 1300 ] 14 0.002% 100.016% ( 1300, 1900 ] 6 0.001% 100.017% ( 1900, 2900 ] 2 0.000% 100.017% ( 2900, 4400 ] 8 0.001% 100.018% ( 6600, 9900 ] 1 0.000% 100.018% ** Level 1 read latency histogram (micros): Count: 146066 Average: 2.4029 StdDev: 12.28 Min: 1 Median: 1.6261 Max: 2783 Percentiles: P50: 1.63 P75: 2.06 P99: 5.82 P99.9: 12.82 P99.99: 151.80 ------------------------------------------------------ [ 0, 1 ] 14701 10.065% 10.065% ## ( 1, 2 ] 93160 63.779% 73.844% ############# ( 2, 3 ] 27506 18.831% 92.675% #### ( 3, 4 ] 5070 3.471% 96.146% # ( 4, 6 ] 4586 3.140% 99.286% # ( 6, 10 ] 777 0.532% 99.818% ( 10, 15 ] 213 0.146% 99.964% ( 15, 22 ] 27 0.018% 99.982% ( 22, 34 ] 8 0.005% 99.988% ( 34, 51 ] 1 0.001% 99.988% ( 76, 110 ] 1 0.001% 99.989% ( 110, 170 ] 2 0.001% 99.990% ( 170, 250 ] 1 0.001% 99.991% ( 250, 380 ] 4 0.003% 99.994% ( 380, 580 ] 2 0.001% 99.995% ( 580, 870 ] 1 0.001% 99.996% ( 870, 1300 ] 3 0.002% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31769 Average: 2.5522 StdDev: 2.99 Min: 1 Median: 1.7171 Max: 388 Percentiles: P50: 1.72 P75: 2.36 P99: 7.16 P99.9: 12.47 P99.99: 31.88 ------------------------------------------------------ [ 0, 1 ] 1520 4.785% 4.785% # ( 1, 2 ] 20031 63.052% 67.837% ############# ( 2, 3 ] 6235 19.626% 87.463% #### ( 3, 4 ] 1745 5.493% 92.955% # ( 4, 6 ] 1812 5.704% 98.659% # ( 6, 10 ] 373 1.174% 99.833% ( 10, 15 ] 43 0.135% 99.969% ( 15, 22 ] 6 0.019% 99.987% ( 22, 34 ] 1 0.003% 99.991% ( 51, 76 ] 1 0.003% 99.994% ( 250, 380 ] 1 0.003% 99.997% ( 380, 580 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28992 Average: 8.8557 StdDev: 176.24 Min: 1 Median: 1.6786 Max: 9543 Percentiles: P50: 1.68 P75: 2.23 P99: 8.17 P99.9: 2463.00 P99.99: 8533.23 ------------------------------------------------------ [ 0, 1 ] 2132 7.354% 7.354% # ( 1, 2 ] 18221 62.848% 70.202% ############# ( 2, 3 ] 6175 21.299% 91.501% #### ( 3, 4 ] 1090 3.760% 95.261% # ( 4, 6 ] 957 3.301% 98.562% # ( 6, 10 ] 234 0.807% 99.369% ( 10, 15 ] 77 0.266% 99.634% ( 15, 22 ] 20 0.069% 99.703% ( 22, 34 ] 2 0.007% 99.710% ( 34, 51 ] 8 0.028% 99.738% ( 51, 76 ] 6 0.021% 99.759% ( 76, 110 ] 7 0.024% 99.783% ( 110, 170 ] 1 0.003% 99.786% ( 170, 250 ] 5 0.017% 99.803% ( 250, 380 ] 1 0.003% 99.807% ( 380, 580 ] 3 0.010% 99.817% ( 580, 870 ] 2 0.007% 99.824% ( 870, 1300 ] 5 0.017% 99.841% ( 1300, 1900 ] 8 0.028% 99.869% ( 1900, 2900 ] 16 0.055% 99.924% ( 2900, 4400 ] 6 0.021% 99.945% ( 4400, 6600 ] 9 0.031% 99.976% ( 6600, 9900 ] 7 0.024% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 4028.2500 StdDev: 2097.37 Min: 1166 Median: 3275.0000 Max: 8085 Percentiles: P50: 3275.00 P75: 6600.00 P99: 8085.00 P99.9: 8085.00 P99.99: 8085.00 ------------------------------------------------------ ( 870, 1300 ] 1 5.000% 5.000% # ( 1300, 1900 ] 1 5.000% 10.000% # ( 1900, 2900 ] 7 35.000% 45.000% ####### ( 2900, 4400 ] 4 20.000% 65.000% #### ( 4400, 6600 ] 2 10.000% 75.000% ## ( 6600, 9900 ] 5 25.000% 100.000% ##### ** Level 5 read latency histogram (micros): Count: 40 Average: 814.2750 StdDev: 1180.12 Min: 77 Median: 234.0000 Max: 4345 Percentiles: P50: 234.00 P75: 812.00 P99: 4250.00 P99.9: 4345.00 P99.99: 4345.00 ------------------------------------------------------ ( 76, 110 ] 11 27.500% 27.500% ###### ( 110, 170 ] 5 12.500% 40.000% ### ( 170, 250 ] 5 12.500% 52.500% ### ( 250, 380 ] 3 7.500% 60.000% ## ( 380, 580 ] 2 5.000% 65.000% # ( 580, 870 ] 5 12.500% 77.500% ### ( 870, 1300 ] 1 2.500% 80.000% # ( 1300, 1900 ] 2 5.000% 85.000% # ( 1900, 2900 ] 2 5.000% 90.000% # ( 2900, 4400 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 11.9 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 331.02 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.151 H:M:S, 9.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 327.57 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.378 H:M:S, 12.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/16-13:24:55 ... thread 0: (1000000,5000000) ops and (105169.7,236255.0) ops/second in (9.508444,21.163572) 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 8/4 1.65 GB 144.1 4.4 0.0 4.4 9.1 4.7 0.0 1.9 148.7 305.3 30.50 28.50 82 0.372 4604K 9809 0.0 0.0 L1 9/0 945.29 MB 94.5 3.1 2.9 0.2 3.0 2.9 0.1 1.1 223.6 221.4 14.09 13.34 3 4.697 3198K 30K 0.0 0.0 L2 7/5 695.49 MB 2.6 0.1 0.1 0.1 0.1 0.1 2.1 2.0 245.0 245.0 0.51 0.49 1 0.514 127K 44 0.0 0.0 L3 44/29 1.73 GB 1.0 0.6 0.5 0.1 0.6 0.5 1.0 1.2 195.8 195.7 3.19 2.77 2 1.593 633K 472 0.0 0.0 L4 148/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.18 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1264/38 100.77 GB 0.0 8.2 3.5 4.8 12.9 8.1 4.5 2.8 174.7 273.0 48.29 45.11 88 0.549 8565K 40K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.2 3.5 4.8 12.9 8.1 4.4 2.8 174.7 273.0 48.29 45.11 88 0.549 8565K 40K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 8.2 3.5 4.8 8.2 3.4 0.0 0.0 241.2 240.0 34.98 33.28 19 1.841 8565K 40K 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 359.5 13.32 11.83 69 0.193 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): 21.4 total, 21.2 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 12.87 GB write, 615.94 MB/s write, 8.24 GB read, 394.15 MB/s read, 48.3 seconds Interval compaction: 12.87 GB write, 622.77 MB/s write, 8.24 GB read, 398.51 MB/s read, 48.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 9, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 9, 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: 9, total-stops: 14, interval: 23 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1982926 Average: 2.5561 StdDev: 15.16 Min: 0 Median: 1.5089 Max: 6765 Percentiles: P50: 1.51 P75: 1.88 P99: 5.96 P99.9: 131.98 P99.99: 240.01 ------------------------------------------------------ [ 0, 1 ] 319204 16.098% 16.098% ### ( 1, 2 ] 1321106 66.624% 82.722% ############# ( 2, 3 ] 234445 11.823% 94.545% ## ( 3, 4 ] 52112 2.628% 97.173% # ( 4, 6 ] 36912 1.861% 99.034% ( 6, 10 ] 12921 0.652% 99.686% ( 10, 15 ] 1880 0.095% 99.781% ( 15, 22 ] 194 0.010% 99.791% ( 22, 34 ] 23 0.001% 99.792% ( 34, 51 ] 12 0.001% 99.792% ( 51, 76 ] 14 0.001% 99.793% ( 76, 110 ] 1350 0.068% 99.861% ( 110, 170 ] 2105 0.106% 99.967% ( 170, 250 ] 515 0.026% 99.993% ( 250, 380 ] 271 0.014% 100.007% ( 380, 580 ] 224 0.011% 100.018% ( 580, 870 ] 96 0.005% 100.023% ( 870, 1300 ] 25 0.001% 100.024% ( 1300, 1900 ] 11 0.001% 100.025% ( 1900, 2900 ] 5 0.000% 100.025% ( 2900, 4400 ] 11 0.001% 100.026% ( 6600, 9900 ] 1 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 152742 Average: 3.0474 StdDev: 33.71 Min: 1 Median: 1.6355 Max: 3734 Percentiles: P50: 1.64 P75: 2.10 P99: 5.90 P99.9: 44.69 P99.99: 1586.29 ------------------------------------------------------ [ 0, 1 ] 14912 9.763% 9.763% ## ( 1, 2 ] 96712 63.317% 73.080% ############# ( 2, 3 ] 29245 19.147% 92.227% #### ( 3, 4 ] 5531 3.621% 95.848% # ( 4, 6 ] 5072 3.321% 99.169% # ( 6, 10 ] 854 0.559% 99.728% ( 10, 15 ] 227 0.149% 99.876% ( 15, 22 ] 28 0.018% 99.895% ( 22, 34 ] 8 0.005% 99.900% ( 34, 51 ] 2 0.001% 99.901% ( 76, 110 ] 8 0.005% 99.906% ( 110, 170 ] 47 0.031% 99.937% ( 170, 250 ] 13 0.009% 99.946% ( 250, 380 ] 14 0.009% 99.955% ( 380, 580 ] 15 0.010% 99.965% ( 580, 870 ] 17 0.011% 99.976% ( 870, 1300 ] 17 0.011% 99.987% ( 1300, 1900 ] 12 0.008% 99.995% ( 1900, 2900 ] 11 0.007% 100.002% ( 2900, 4400 ] 3 0.002% 100.004% ** Level 2 read latency histogram (micros): Count: 31771 Average: 2.5868 StdDev: 5.49 Min: 1 Median: 1.7172 Max: 739 Percentiles: P50: 1.72 P75: 2.37 P99: 7.18 P99.9: 12.70 P99.99: 303.49 ------------------------------------------------------ [ 0, 1 ] 1520 4.784% 4.784% # ( 1, 2 ] 20031 63.048% 67.832% ############# ( 2, 3 ] 6235 19.625% 87.457% #### ( 3, 4 ] 1745 5.492% 92.950% # ( 4, 6 ] 1812 5.703% 98.653% # ( 6, 10 ] 373 1.174% 99.827% ( 10, 15 ] 43 0.135% 99.962% ( 15, 22 ] 6 0.019% 99.981% ( 22, 34 ] 1 0.003% 99.984% ( 51, 76 ] 1 0.003% 99.987% ( 250, 380 ] 2 0.006% 99.994% ( 380, 580 ] 1 0.003% 99.997% ( 580, 870 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 35436 Average: 11.0242 StdDev: 165.60 Min: 1 Median: 1.7456 Max: 9543 Percentiles: P50: 1.75 P75: 2.46 P99: 15.35 P99.9: 1154.66 P99.99: 2691.55 ------------------------------------------------------ [ 0, 1 ] 2203 6.217% 6.217% # ( 1, 2 ] 20808 58.720% 64.937% ############ ( 2, 3 ] 7804 22.023% 86.960% #### ( 3, 4 ] 1880 5.305% 92.265% # ( 4, 6 ] 1738 4.905% 97.170% # ( 6, 10 ] 527 1.487% 98.657% ( 10, 15 ] 120 0.339% 98.995% ( 15, 22 ] 33 0.093% 99.088% ( 22, 34 ] 3 0.008% 99.097% ( 34, 51 ] 8 0.023% 99.120% ( 51, 76 ] 6 0.017% 99.136% ( 76, 110 ] 12 0.034% 99.170% ( 110, 170 ] 43 0.121% 99.292% ( 170, 250 ] 45 0.127% 99.419% ( 250, 380 ] 47 0.133% 99.551% ( 380, 580 ] 63 0.178% 99.729% ( 580, 870 ] 46 0.130% 99.859% ( 870, 1300 ] 22 0.062% 99.921% ( 1300, 1900 ] 11 0.031% 99.952% ( 1900, 2900 ] 17 0.048% 100.000% ( 2900, 4400 ] 6 0.017% 100.017% ( 4400, 6600 ] 9 0.025% 100.042% ( 6600, 9900 ] 7 0.020% 100.062% ** Level 4 read latency histogram (micros): Count: 20 Average: 4028.2500 StdDev: 2097.37 Min: 1166 Median: 3275.0000 Max: 8085 Percentiles: P50: 3275.00 P75: 6600.00 P99: 8085.00 P99.9: 8085.00 P99.99: 8085.00 ------------------------------------------------------ ( 870, 1300 ] 1 5.000% 5.000% # ( 1300, 1900 ] 1 5.000% 10.000% # ( 1900, 2900 ] 7 35.000% 45.000% ####### ( 2900, 4400 ] 4 20.000% 65.000% #### ( 4400, 6600 ] 2 10.000% 75.000% ## ( 6600, 9900 ] 5 25.000% 100.000% ##### ** Level 5 read latency histogram (micros): Count: 40 Average: 814.2750 StdDev: 1180.12 Min: 77 Median: 234.0000 Max: 4345 Percentiles: P50: 234.00 P75: 812.00 P99: 4250.00 P99.9: 4345.00 P99.99: 4345.00 ------------------------------------------------------ ( 76, 110 ] 11 27.500% 27.500% ###### ( 110, 170 ] 5 12.500% 40.000% ### ( 170, 250 ] 5 12.500% 52.500% ### ( 250, 380 ] 3 7.500% 60.000% ## ( 380, 580 ] 2 5.000% 65.000% # ( 580, 870 ] 5 12.500% 77.500% ### ( 870, 1300 ] 1 2.500% 80.000% # ( 1300, 1900 ] 2 5.000% 85.000% # ( 1900, 2900 ] 2 5.000% 90.000% # ( 2900, 4400 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 21.4 total, 9.5 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 229.94 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:7.658 H:M:S, 35.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 103.51 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.508 H:M:S, 68.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 6 num-running-flushes: 1 2024/12/16-13:24:59 ... thread 0: (1000000,6000000) ops and (281137.1,242713.0) ops/second in (3.556984,24.720556) 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 12/10 2.64 GB 44.1 5.2 0.0 5.2 10.9 5.6 0.0 1.9 144.3 300.2 37.11 34.29 98 0.379 5435K 10K 0.0 0.0 L1 9/9 945.29 MB 0.0 3.1 2.9 0.2 3.0 2.9 0.1 1.1 223.6 221.4 14.09 13.34 3 4.697 3198K 30K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 2.1 2.0 245.0 245.0 0.51 0.49 1 0.514 127K 44 0.0 0.0 L3 17/0 991.21 MB 1.0 2.1 1.2 0.9 2.1 1.2 1.0 1.8 185.4 185.0 11.64 9.43 9 1.293 2076K 1725 0.0 0.0 L4 168/0 9.68 GB 1.0 0.4 0.4 0.1 0.4 0.4 1.7 1.1 183.8 183.3 2.46 2.07 5 0.491 458K 1111 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 1270/19 101.75 GB 0.0 11.0 4.5 6.5 16.6 10.1 6.9 2.9 170.8 258.2 65.80 59.63 116 0.567 11M 43K 0.0 0.0 Int 0/0 0.00 KB 0.0 11.0 4.5 6.5 16.6 10.1 6.8 2.9 170.8 258.2 65.80 59.63 116 0.567 11M 43K 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 11.0 4.5 6.5 10.9 4.5 0.0 0.0 228.3 227.4 49.21 45.23 34 1.447 11M 43K 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 349.4 16.59 14.40 82 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): 25.0 total, 24.7 interval Flush(GB): cumulative 5.660, interval 5.660 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: 16.59 GB write, 680.62 MB/s write, 10.97 GB read, 450.27 MB/s read, 65.8 seconds Interval compaction: 16.59 GB write, 687.07 MB/s write, 10.97 GB read, 454.54 MB/s read, 65.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 9, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 9, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 32, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 9, total-stops: 32, interval: 41 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2313259 Average: 2.6077 StdDev: 15.65 Min: 0 Median: 1.5524 Max: 7768 Percentiles: P50: 1.55 P75: 1.94 P99: 6.43 P99.9: 120.58 P99.99: 219.26 ------------------------------------------------------ [ 0, 1 ] 328885 14.217% 14.217% ### ( 1, 2 ] 1498561 64.781% 78.999% ############# ( 2, 3 ] 324064 14.009% 93.008% ### ( 3, 4 ] 74429 3.217% 96.225% # ( 4, 6 ] 62282 2.692% 98.918% # ( 6, 10 ] 17723 0.766% 99.684% ( 10, 15 ] 2889 0.125% 99.809% ( 15, 22 ] 313 0.014% 99.822% ( 22, 34 ] 28 0.001% 99.823% ( 34, 51 ] 17 0.001% 99.824% ( 51, 76 ] 16 0.001% 99.825% ( 76, 110 ] 1365 0.059% 99.884% ( 110, 170 ] 2126 0.092% 99.976% ( 170, 250 ] 537 0.023% 99.999% ( 250, 380 ] 288 0.012% 100.011% ( 380, 580 ] 230 0.010% 100.021% ( 580, 870 ] 106 0.005% 100.026% ( 870, 1300 ] 33 0.001% 100.027% ( 1300, 1900 ] 15 0.001% 100.028% ( 1900, 2900 ] 7 0.000% 100.028% ( 2900, 4400 ] 12 0.001% 100.029% ( 6600, 9900 ] 2 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 383915 Average: 3.2368 StdDev: 27.83 Min: 1 Median: 1.8557 Max: 4381 Percentiles: P50: 1.86 P75: 2.66 P99: 8.17 P99.9: 14.38 P99.99: 122.98 ------------------------------------------------------ [ 0, 1 ] 17099 4.454% 4.454% # ( 1, 2 ] 204341 53.226% 57.679% ########### ( 2, 3 ] 100151 26.087% 83.766% ##### ( 3, 4 ] 26390 6.874% 90.640% # ( 4, 6 ] 29101 7.580% 98.220% ## ( 6, 10 ] 5530 1.440% 99.661% ( 10, 15 ] 1049 0.273% 99.934% ( 15, 22 ] 133 0.035% 99.968% ( 22, 34 ] 20 0.005% 99.974% ( 34, 51 ] 2 0.001% 99.974% ( 51, 76 ] 1 0.000% 99.974% ( 76, 110 ] 41 0.011% 99.985% ( 110, 170 ] 86 0.022% 100.008% ( 170, 250 ] 41 0.011% 100.018% ( 250, 380 ] 40 0.010% 100.029% ( 380, 580 ] 42 0.011% 100.040% ( 580, 870 ] 32 0.008% 100.048% ( 870, 1300 ] 25 0.007% 100.054% ( 1300, 1900 ] 16 0.004% 100.059% ( 1900, 2900 ] 17 0.004% 100.063% ( 2900, 4400 ] 7 0.002% 100.065% ** Level 2 read latency histogram (micros): Count: 31985 Average: 4.0327 StdDev: 45.31 Min: 1 Median: 1.7217 Max: 3672 Percentiles: P50: 1.72 P75: 2.38 P99: 7.87 P99.9: 517.69 P99.99: 2460.30 ------------------------------------------------------ [ 0, 1 ] 1520 4.752% 4.752% # ( 1, 2 ] 20054 62.698% 67.450% ############# ( 2, 3 ] 6323 19.769% 87.219% #### ( 3, 4 ] 1761 5.506% 92.725% # ( 4, 6 ] 1832 5.728% 98.452% # ( 6, 10 ] 375 1.172% 99.625% ( 10, 15 ] 43 0.134% 99.759% ( 15, 22 ] 9 0.028% 99.787% ( 22, 34 ] 1 0.003% 99.791% ( 51, 76 ] 1 0.003% 99.794% ( 110, 170 ] 4 0.013% 99.806% ( 170, 250 ] 5 0.016% 99.822% ( 250, 380 ] 14 0.044% 99.866% ( 380, 580 ] 16 0.050% 99.916% ( 580, 870 ] 11 0.034% 99.950% ( 870, 1300 ] 9 0.028% 99.978% ( 1300, 1900 ] 1 0.003% 99.981% ( 1900, 2900 ] 5 0.016% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 294642 Average: 7.8241 StdDev: 91.74 Min: 1 Median: 1.9561 Max: 9543 Percentiles: P50: 1.96 P75: 2.84 P99: 12.03 P99.9: 583.13 P99.99: 830.40 ------------------------------------------------------ [ 0, 1 ] 5835 1.980% 1.980% ( 1, 2 ] 147981 50.224% 52.204% ########## ( 2, 3 ] 80067 27.174% 79.379% ##### ( 3, 4 ] 24846 8.433% 87.811% ## ( 4, 6 ] 26140 8.872% 96.683% ## ( 6, 10 ] 6399 2.172% 98.855% ( 10, 15 ] 1053 0.357% 99.212% ( 15, 22 ] 186 0.063% 99.275% ( 22, 34 ] 13 0.004% 99.280% ( 34, 51 ] 12 0.004% 99.284% ( 51, 76 ] 9 0.003% 99.287% ( 76, 110 ] 71 0.024% 99.311% ( 110, 170 ] 395 0.134% 99.445% ( 170, 250 ] 423 0.144% 99.589% ( 250, 380 ] 439 0.149% 99.738% ( 380, 580 ] 475 0.161% 99.899% ( 580, 870 ] 311 0.106% 100.004% ( 870, 1300 ] 139 0.047% 100.052% ( 1300, 1900 ] 58 0.020% 100.071% ( 1900, 2900 ] 96 0.033% 100.104% ( 2900, 4400 ] 43 0.015% 100.118% ( 4400, 6600 ] 11 0.004% 100.122% ( 6600, 9900 ] 7 0.002% 100.125% ** Level 4 read latency histogram (micros): Count: 90 Average: 987.8000 StdDev: 1915.86 Min: 1 Median: 3.6667 Max: 8085 Percentiles: P50: 3.67 P75: 841.00 P99: 8085.00 P99.9: 8085.00 P99.99: 8085.00 ------------------------------------------------------ [ 0, 1 ] 10 11.111% 11.111% ## ( 1, 2 ] 27 30.000% 41.111% ###### ( 2, 3 ] 6 6.667% 47.778% # ( 3, 4 ] 3 3.333% 51.111% # ( 6, 10 ] 2 2.222% 53.333% ( 15, 22 ] 3 3.333% 56.667% # ( 76, 110 ] 1 1.111% 57.778% ( 110, 170 ] 8 8.889% 66.667% ## ( 170, 250 ] 1 1.111% 67.778% ( 250, 380 ] 1 1.111% 68.889% ( 380, 580 ] 1 1.111% 70.000% ( 580, 870 ] 5 5.556% 75.556% # ( 870, 1300 ] 3 3.333% 78.889% # ( 1300, 1900 ] 1 1.111% 80.000% ( 1900, 2900 ] 7 7.778% 87.778% ## ( 2900, 4400 ] 4 4.444% 92.222% # ( 4400, 6600 ] 2 2.222% 94.444% ( 6600, 9900 ] 5 5.556% 100.000% # ** Level 5 read latency histogram (micros): Count: 120 Average: 1057.5417 StdDev: 1243.53 Min: 77 Median: 535.5556 Max: 4616 Percentiles: P50: 535.56 P75: 1600.00 P99: 4616.00 P99.9: 4616.00 P99.99: 4616.00 ------------------------------------------------------ ( 76, 110 ] 16 13.333% 13.333% ### ( 110, 170 ] 17 14.167% 27.500% ### ( 170, 250 ] 12 10.000% 37.500% ## ( 250, 380 ] 8 6.667% 44.167% # ( 380, 580 ] 9 7.500% 51.667% ## ( 580, 870 ] 17 14.167% 65.833% ### ( 870, 1300 ] 8 6.667% 72.500% # ( 1300, 1900 ] 6 5.000% 77.500% # ( 1900, 2900 ] 14 11.667% 89.167% ## ( 2900, 4400 ] 10 8.333% 97.500% ## ( 4400, 6600 ] 3 2.500% 100.000% # ** DB Stats ** Uptime(secs): 25.0 total, 3.6 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 236.60 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.423 H:M:S, 33.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 276.69 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.764 H:M:S, 21.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/16-13:25:02 ... thread 0: (1000000,7000000) ops and (328594.9,252126.7) ops/second in (3.043261,27.763817) 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/10 3.62 GB 144.8 6.0 0.0 6.0 12.7 6.6 0.0 1.9 143.3 301.0 43.07 39.87 115 0.375 6267K 11K 0.0 0.0 L1 9/9 945.29 MB 0.0 3.1 2.9 0.2 3.0 2.9 0.1 1.1 223.6 221.4 14.09 13.34 3 4.697 3198K 30K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 2.1 2.0 245.0 245.0 0.51 0.49 1 0.514 127K 44 0.0 0.0 L3 17/0 991.21 MB 1.0 2.1 1.2 0.9 2.1 1.2 1.0 1.8 185.4 185.0 11.64 9.43 9 1.293 2076K 1725 0.0 0.0 L4 168/0 9.68 GB 1.0 0.4 0.4 0.1 0.4 0.4 1.7 1.1 183.8 183.3 2.46 2.07 5 0.491 458K 1111 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 1275/19 102.73 GB 0.0 11.8 4.5 7.3 18.4 11.1 6.9 2.8 168.0 262.1 71.77 65.20 133 0.540 12M 44K 0.0 0.0 Int 0/0 0.00 KB 0.0 11.8 4.5 7.3 18.4 11.1 6.8 2.8 168.0 262.1 71.77 65.20 133 0.540 12M 44K 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 11.8 4.5 7.3 11.7 4.5 0.0 0.0 230.4 229.5 52.33 48.28 37 1.414 12M 44K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.6 6.6 0.0 0.0 0.0 350.1 19.43 16.92 96 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): 28.0 total, 27.8 interval Flush(GB): cumulative 6.644, interval 6.644 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.37 GB write, 671.86 MB/s write, 11.77 GB read, 430.58 MB/s read, 71.8 seconds Interval compaction: 18.37 GB write, 677.53 MB/s write, 11.77 GB read, 434.22 MB/s read, 71.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 9, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 9, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 36, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 9, total-stops: 36, interval: 45 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2696163 Average: 2.5905 StdDev: 14.85 Min: 0 Median: 1.5646 Max: 7768 Percentiles: P50: 1.56 P75: 1.95 P99: 6.43 P99.9: 110.29 P99.99: 201.69 ------------------------------------------------------ [ 0, 1 ] 362474 13.444% 13.444% ### ( 1, 2 ] 1745621 64.745% 78.189% ############# ( 2, 3 ] 398877 14.794% 92.983% ### ( 3, 4 ] 86828 3.220% 96.203% # ( 4, 6 ] 73098 2.711% 98.915% # ( 6, 10 ] 21374 0.793% 99.707% ( 10, 15 ] 3349 0.124% 99.832% ( 15, 22 ] 349 0.013% 99.844% ( 22, 34 ] 33 0.001% 99.846% ( 34, 51 ] 20 0.001% 99.846% ( 51, 76 ] 17 0.001% 99.847% ( 76, 110 ] 1417 0.053% 99.900% ( 110, 170 ] 2208 0.082% 99.982% ( 170, 250 ] 579 0.021% 100.003% ( 250, 380 ] 311 0.012% 100.015% ( 380, 580 ] 251 0.009% 100.024% ( 580, 870 ] 120 0.004% 100.028% ( 870, 1300 ] 38 0.001% 100.030% ( 1300, 1900 ] 17 0.001% 100.030% ( 1900, 2900 ] 7 0.000% 100.031% ( 2900, 4400 ] 12 0.000% 100.031% ( 6600, 9900 ] 2 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 383915 Average: 3.2368 StdDev: 27.83 Min: 1 Median: 1.8557 Max: 4381 Percentiles: P50: 1.86 P75: 2.66 P99: 8.17 P99.9: 14.38 P99.99: 122.98 ------------------------------------------------------ [ 0, 1 ] 17099 4.454% 4.454% # ( 1, 2 ] 204341 53.226% 57.679% ########### ( 2, 3 ] 100151 26.087% 83.766% ##### ( 3, 4 ] 26390 6.874% 90.640% # ( 4, 6 ] 29101 7.580% 98.220% ## ( 6, 10 ] 5530 1.440% 99.661% ( 10, 15 ] 1049 0.273% 99.934% ( 15, 22 ] 133 0.035% 99.968% ( 22, 34 ] 20 0.005% 99.974% ( 34, 51 ] 2 0.001% 99.974% ( 51, 76 ] 1 0.000% 99.974% ( 76, 110 ] 41 0.011% 99.985% ( 110, 170 ] 86 0.022% 100.008% ( 170, 250 ] 41 0.011% 100.018% ( 250, 380 ] 40 0.010% 100.029% ( 380, 580 ] 42 0.011% 100.040% ( 580, 870 ] 32 0.008% 100.048% ( 870, 1300 ] 25 0.007% 100.054% ( 1300, 1900 ] 16 0.004% 100.059% ( 1900, 2900 ] 17 0.004% 100.063% ( 2900, 4400 ] 7 0.002% 100.065% ** Level 2 read latency histogram (micros): Count: 31985 Average: 4.0327 StdDev: 45.31 Min: 1 Median: 1.7217 Max: 3672 Percentiles: P50: 1.72 P75: 2.38 P99: 7.87 P99.9: 517.69 P99.99: 2460.30 ------------------------------------------------------ [ 0, 1 ] 1520 4.752% 4.752% # ( 1, 2 ] 20054 62.698% 67.450% ############# ( 2, 3 ] 6323 19.769% 87.219% #### ( 3, 4 ] 1761 5.506% 92.725% # ( 4, 6 ] 1832 5.728% 98.452% # ( 6, 10 ] 375 1.172% 99.625% ( 10, 15 ] 43 0.134% 99.759% ( 15, 22 ] 9 0.028% 99.787% ( 22, 34 ] 1 0.003% 99.791% ( 51, 76 ] 1 0.003% 99.794% ( 110, 170 ] 4 0.013% 99.806% ( 170, 250 ] 5 0.016% 99.822% ( 250, 380 ] 14 0.044% 99.866% ( 380, 580 ] 16 0.050% 99.916% ( 580, 870 ] 11 0.034% 99.950% ( 870, 1300 ] 9 0.028% 99.978% ( 1300, 1900 ] 1 0.003% 99.981% ( 1900, 2900 ] 5 0.016% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 294642 Average: 7.8241 StdDev: 91.74 Min: 1 Median: 1.9561 Max: 9543 Percentiles: P50: 1.96 P75: 2.84 P99: 12.03 P99.9: 583.13 P99.99: 830.40 ------------------------------------------------------ [ 0, 1 ] 5835 1.980% 1.980% ( 1, 2 ] 147981 50.224% 52.204% ########## ( 2, 3 ] 80067 27.174% 79.379% ##### ( 3, 4 ] 24846 8.433% 87.811% ## ( 4, 6 ] 26140 8.872% 96.683% ## ( 6, 10 ] 6399 2.172% 98.855% ( 10, 15 ] 1053 0.357% 99.212% ( 15, 22 ] 186 0.063% 99.275% ( 22, 34 ] 13 0.004% 99.280% ( 34, 51 ] 12 0.004% 99.284% ( 51, 76 ] 9 0.003% 99.287% ( 76, 110 ] 71 0.024% 99.311% ( 110, 170 ] 395 0.134% 99.445% ( 170, 250 ] 423 0.144% 99.589% ( 250, 380 ] 439 0.149% 99.738% ( 380, 580 ] 475 0.161% 99.899% ( 580, 870 ] 311 0.106% 100.004% ( 870, 1300 ] 139 0.047% 100.052% ( 1300, 1900 ] 58 0.020% 100.071% ( 1900, 2900 ] 96 0.033% 100.104% ( 2900, 4400 ] 43 0.015% 100.118% ( 4400, 6600 ] 11 0.004% 100.122% ( 6600, 9900 ] 7 0.002% 100.125% ** Level 4 read latency histogram (micros): Count: 90 Average: 987.8000 StdDev: 1915.86 Min: 1 Median: 3.6667 Max: 8085 Percentiles: P50: 3.67 P75: 841.00 P99: 8085.00 P99.9: 8085.00 P99.99: 8085.00 ------------------------------------------------------ [ 0, 1 ] 10 11.111% 11.111% ## ( 1, 2 ] 27 30.000% 41.111% ###### ( 2, 3 ] 6 6.667% 47.778% # ( 3, 4 ] 3 3.333% 51.111% # ( 6, 10 ] 2 2.222% 53.333% ( 15, 22 ] 3 3.333% 56.667% # ( 76, 110 ] 1 1.111% 57.778% ( 110, 170 ] 8 8.889% 66.667% ## ( 170, 250 ] 1 1.111% 67.778% ( 250, 380 ] 1 1.111% 68.889% ( 380, 580 ] 1 1.111% 70.000% ( 580, 870 ] 5 5.556% 75.556% # ( 870, 1300 ] 3 3.333% 78.889% # ( 1300, 1900 ] 1 1.111% 80.000% ( 1900, 2900 ] 7 7.778% 87.778% ## ( 2900, 4400 ] 4 4.444% 92.222% # ( 4400, 6600 ] 2 2.222% 94.444% ( 6600, 9900 ] 5 5.556% 100.000% # ** Level 5 read latency histogram (micros): Count: 120 Average: 1057.5417 StdDev: 1243.53 Min: 77 Median: 535.5556 Max: 4616 Percentiles: P50: 535.56 P75: 1600.00 P99: 4616.00 P99.9: 4616.00 P99.99: 4616.00 ------------------------------------------------------ ( 76, 110 ] 16 13.333% 13.333% ### ( 110, 170 ] 17 14.167% 27.500% ### ( 170, 250 ] 12 10.000% 37.500% ## ( 250, 380 ] 8 6.667% 44.167% # ( 380, 580 ] 9 7.500% 51.667% ## ( 580, 870 ] 17 14.167% 65.833% ### ( 870, 1300 ] 8 6.667% 72.500% # ( 1300, 1900 ] 6 5.000% 77.500% # ( 1900, 2900 ] 14 11.667% 89.167% ## ( 2900, 4400 ] 10 8.333% 97.500% ## ( 4400, 6600 ] 3 2.500% 100.000% # ** DB Stats ** Uptime(secs): 28.0 total, 3.0 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 246.03 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.800 H:M:S, 31.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 323.40 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.378 H:M:S, 12.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/16-13:25:06 ... thread 0: (1000000,8000000) ops and (226379.4,248592.5) ops/second in (4.417364,32.181181) 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/6 4.54 GB 264.3 7.1 0.0 7.1 14.6 7.6 0.0 1.9 145.5 300.8 49.79 46.21 133 0.374 7354K 12K 0.0 0.0 L1 9/9 945.29 MB 0.0 3.1 2.9 0.2 3.0 2.9 0.1 1.1 223.6 221.4 14.09 13.34 3 4.697 3198K 30K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 2.1 2.0 245.0 245.0 0.51 0.49 1 0.514 127K 44 0.0 0.0 L3 17/0 991.21 MB 1.0 2.1 1.2 0.9 2.1 1.2 1.0 1.8 185.4 185.0 11.64 9.43 9 1.293 2076K 1725 0.0 0.0 L4 168/0 9.68 GB 1.0 0.4 0.4 0.1 0.4 0.4 1.7 1.1 183.8 183.3 2.46 2.07 5 0.491 458K 1111 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 1277/15 103.66 GB 0.0 12.8 4.5 8.3 20.3 12.0 6.9 2.7 167.3 265.4 78.49 71.55 151 0.520 13M 45K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.8 4.5 8.3 20.3 12.0 6.8 2.7 167.3 265.4 78.49 71.55 151 0.520 13M 45K 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.8 4.5 8.3 12.8 4.5 0.0 0.0 232.8 232.0 56.38 52.26 41 1.375 13M 45K 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 350.6 22.10 19.29 110 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 32.4 total, 32.2 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: 20.34 GB write, 642.46 MB/s write, 12.82 GB read, 404.94 MB/s read, 78.5 seconds Interval compaction: 20.34 GB write, 647.14 MB/s write, 12.82 GB read, 407.90 MB/s read, 78.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 38, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 15, total-stops: 38, interval: 53 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3045859 Average: 2.5661 StdDev: 14.62 Min: 0 Median: 1.5641 Max: 7768 Percentiles: P50: 1.56 P75: 1.95 P99: 6.31 P99.9: 104.63 P99.99: 199.78 ------------------------------------------------------ [ 0, 1 ] 404682 13.286% 13.286% ### ( 1, 2 ] 1982369 65.084% 78.370% ############# ( 2, 3 ] 450321 14.785% 93.155% ### ( 3, 4 ] 96189 3.158% 96.313% # ( 4, 6 ] 80005 2.627% 98.940% # ( 6, 10 ] 23818 0.782% 99.722% ( 10, 15 ] 3767 0.124% 99.845% ( 15, 22 ] 370 0.012% 99.858% ( 22, 34 ] 36 0.001% 99.859% ( 34, 51 ] 23 0.001% 99.860% ( 51, 76 ] 19 0.001% 99.860% ( 76, 110 ] 1443 0.047% 99.908% ( 110, 170 ] 2283 0.075% 99.982% ( 170, 250 ] 619 0.020% 100.003% ( 250, 380 ] 329 0.011% 100.014% ( 380, 580 ] 276 0.009% 100.023% ( 580, 870 ] 134 0.004% 100.027% ( 870, 1300 ] 41 0.001% 100.028% ( 1300, 1900 ] 19 0.001% 100.029% ( 1900, 2900 ] 7 0.000% 100.029% ( 2900, 4400 ] 15 0.000% 100.030% ( 6600, 9900 ] 2 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 518643 Average: 3.0768 StdDev: 24.58 Min: 1 Median: 1.7638 Max: 4381 Percentiles: P50: 1.76 P75: 2.51 P99: 8.19 P99.9: 18.40 P99.99: 166.35 ------------------------------------------------------ [ 0, 1 ] 34626 6.676% 6.676% # ( 1, 2 ] 294172 56.720% 63.396% ########### ( 2, 3 ] 119038 22.952% 86.348% ##### ( 3, 4 ] 29479 5.684% 92.032% # ( 4, 6 ] 32004 6.171% 98.202% # ( 6, 10 ] 7557 1.457% 99.659% ( 10, 15 ] 1176 0.227% 99.886% ( 15, 22 ] 149 0.029% 99.915% ( 22, 34 ] 20 0.004% 99.919% ( 34, 51 ] 3 0.001% 99.919% ( 51, 76 ] 2 0.000% 99.920% ( 76, 110 ] 151 0.029% 99.949% ( 110, 170 ] 228 0.044% 99.993% ( 170, 250 ] 66 0.013% 100.005% ( 250, 380 ] 57 0.011% 100.016% ( 380, 580 ] 61 0.012% 100.028% ( 580, 870 ] 36 0.007% 100.035% ( 870, 1300 ] 26 0.005% 100.040% ( 1300, 1900 ] 17 0.003% 100.043% ( 1900, 2900 ] 17 0.003% 100.047% ( 2900, 4400 ] 7 0.001% 100.048% ** Level 2 read latency histogram (micros): Count: 31985 Average: 4.0327 StdDev: 45.31 Min: 1 Median: 1.7217 Max: 3672 Percentiles: P50: 1.72 P75: 2.38 P99: 7.87 P99.9: 517.69 P99.99: 2460.30 ------------------------------------------------------ [ 0, 1 ] 1520 4.752% 4.752% # ( 1, 2 ] 20054 62.698% 67.450% ############# ( 2, 3 ] 6323 19.769% 87.219% #### ( 3, 4 ] 1761 5.506% 92.725% # ( 4, 6 ] 1832 5.728% 98.452% # ( 6, 10 ] 375 1.172% 99.625% ( 10, 15 ] 43 0.134% 99.759% ( 15, 22 ] 9 0.028% 99.787% ( 22, 34 ] 1 0.003% 99.791% ( 51, 76 ] 1 0.003% 99.794% ( 110, 170 ] 4 0.013% 99.806% ( 170, 250 ] 5 0.016% 99.822% ( 250, 380 ] 14 0.044% 99.866% ( 380, 580 ] 16 0.050% 99.916% ( 580, 870 ] 11 0.034% 99.950% ( 870, 1300 ] 9 0.028% 99.978% ( 1300, 1900 ] 1 0.003% 99.981% ( 1900, 2900 ] 5 0.016% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 294642 Average: 7.8241 StdDev: 91.74 Min: 1 Median: 1.9561 Max: 9543 Percentiles: P50: 1.96 P75: 2.84 P99: 12.03 P99.9: 583.13 P99.99: 830.40 ------------------------------------------------------ [ 0, 1 ] 5835 1.980% 1.980% ( 1, 2 ] 147981 50.224% 52.204% ########## ( 2, 3 ] 80067 27.174% 79.379% ##### ( 3, 4 ] 24846 8.433% 87.811% ## ( 4, 6 ] 26140 8.872% 96.683% ## ( 6, 10 ] 6399 2.172% 98.855% ( 10, 15 ] 1053 0.357% 99.212% ( 15, 22 ] 186 0.063% 99.275% ( 22, 34 ] 13 0.004% 99.280% ( 34, 51 ] 12 0.004% 99.284% ( 51, 76 ] 9 0.003% 99.287% ( 76, 110 ] 71 0.024% 99.311% ( 110, 170 ] 395 0.134% 99.445% ( 170, 250 ] 423 0.144% 99.589% ( 250, 380 ] 439 0.149% 99.738% ( 380, 580 ] 475 0.161% 99.899% ( 580, 870 ] 311 0.106% 100.004% ( 870, 1300 ] 139 0.047% 100.052% ( 1300, 1900 ] 58 0.020% 100.071% ( 1900, 2900 ] 96 0.033% 100.104% ( 2900, 4400 ] 43 0.015% 100.118% ( 4400, 6600 ] 11 0.004% 100.122% ( 6600, 9900 ] 7 0.002% 100.125% ** Level 4 read latency histogram (micros): Count: 90 Average: 987.8000 StdDev: 1915.86 Min: 1 Median: 3.6667 Max: 8085 Percentiles: P50: 3.67 P75: 841.00 P99: 8085.00 P99.9: 8085.00 P99.99: 8085.00 ------------------------------------------------------ [ 0, 1 ] 10 11.111% 11.111% ## ( 1, 2 ] 27 30.000% 41.111% ###### ( 2, 3 ] 6 6.667% 47.778% # ( 3, 4 ] 3 3.333% 51.111% # ( 6, 10 ] 2 2.222% 53.333% ( 15, 22 ] 3 3.333% 56.667% # ( 76, 110 ] 1 1.111% 57.778% ( 110, 170 ] 8 8.889% 66.667% ## ( 170, 250 ] 1 1.111% 67.778% ( 250, 380 ] 1 1.111% 68.889% ( 380, 580 ] 1 1.111% 70.000% ( 580, 870 ] 5 5.556% 75.556% # ( 870, 1300 ] 3 3.333% 78.889% # ( 1300, 1900 ] 1 1.111% 80.000% ( 1900, 2900 ] 7 7.778% 87.778% ## ( 2900, 4400 ] 4 4.444% 92.222% # ( 4400, 6600 ] 2 2.222% 94.444% ( 6600, 9900 ] 5 5.556% 100.000% # ** Level 5 read latency histogram (micros): Count: 120 Average: 1057.5417 StdDev: 1243.53 Min: 77 Median: 535.5556 Max: 4616 Percentiles: P50: 535.56 P75: 1600.00 P99: 4616.00 P99.9: 4616.00 P99.99: 4616.00 ------------------------------------------------------ ( 76, 110 ] 16 13.333% 13.333% ### ( 110, 170 ] 17 14.167% 27.500% ### ( 170, 250 ] 12 10.000% 37.500% ## ( 250, 380 ] 8 6.667% 44.167% # ( 380, 580 ] 9 7.500% 51.667% ## ( 580, 870 ] 17 14.167% 65.833% ### ( 870, 1300 ] 8 6.667% 72.500% # ( 1300, 1900 ] 6 5.000% 77.500% # ( 1900, 2900 ] 14 11.667% 89.167% ## ( 2900, 4400 ] 10 8.333% 97.500% ## ( 4400, 6600 ] 3 2.500% 100.000% # ** DB Stats ** Uptime(secs): 32.4 total, 4.4 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 242.87 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.504 H:M:S, 32.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 222.80 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.703 H:M:S, 38.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/16-13:25:15 ... thread 0: (1000000,9000000) ops and (118935.9,221734.6) ops/second in (8.407891,40.589072) 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/10 3.50 GB 182.5 7.9 0.0 7.9 16.3 8.5 0.0 1.9 142.2 295.4 56.68 51.79 149 0.380 8186K 13K 0.0 0.0 L1 9/0 1014.06 MB 101.4 6.0 4.8 1.1 5.9 4.8 0.1 1.2 223.4 221.1 27.32 26.10 4 6.831 6197K 61K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 4.0 2.0 245.0 245.0 0.51 0.49 1 0.514 127K 44 0.0 0.0 L3 21/1 1.09 GB 1.0 3.8 2.0 1.8 3.8 2.0 2.0 1.9 177.4 176.7 21.94 17.55 16 1.371 3840K 14K 0.0 0.0 L4 171/3 9.74 GB 1.0 2.6 2.1 0.5 2.6 2.1 1.7 1.2 139.9 139.2 19.13 12.55 29 0.660 2718K 13K 0.0 0.0 L5 1084/0 89.20 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1302/14 104.52 GB 0.0 20.4 9.0 11.3 28.8 17.4 11.5 3.4 166.1 234.5 125.59 108.48 199 0.631 21M 103K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.4 9.0 11.3 28.8 17.4 11.4 3.4 166.1 234.5 125.59 108.48 199 0.631 21M 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 20.4 9.0 11.3 20.3 8.9 0.0 0.0 208.9 207.8 99.87 86.75 76 1.314 21M 103K 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 337.9 25.73 21.73 123 0.209 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): 40.8 total, 40.6 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: 28.76 GB write, 721.32 MB/s write, 20.37 GB read, 510.99 MB/s read, 125.6 seconds Interval compaction: 28.76 GB write, 725.49 MB/s write, 20.37 GB read, 513.94 MB/s read, 125.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 20, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 20, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 47, pending-compaction-bytes-delays: 19, pending-compaction-bytes-stops: 0, total-delays: 39, total-stops: 47, interval: 86 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3691812 Average: 2.6329 StdDev: 16.48 Min: 0 Median: 1.5928 Max: 7768 Percentiles: P50: 1.59 P75: 1.98 P99: 6.94 P99.9: 93.86 P99.99: 198.17 ------------------------------------------------------ [ 0, 1 ] 450131 12.193% 12.193% ## ( 1, 2 ] 2354456 63.775% 75.968% ############# ( 2, 3 ] 579762 15.704% 91.672% ### ( 3, 4 ] 136018 3.684% 95.356% # ( 4, 6 ] 126288 3.421% 98.777% # ( 6, 10 ] 34954 0.947% 99.724% ( 10, 15 ] 5119 0.139% 99.862% ( 15, 22 ] 499 0.014% 99.876% ( 22, 34 ] 46 0.001% 99.877% ( 34, 51 ] 25 0.001% 99.878% ( 51, 76 ] 21 0.001% 99.878% ( 76, 110 ] 1529 0.041% 99.920% ( 110, 170 ] 2363 0.064% 99.984% ( 170, 250 ] 664 0.018% 100.002% ( 250, 380 ] 373 0.010% 100.012% ( 380, 580 ] 315 0.009% 100.020% ( 580, 870 ] 189 0.005% 100.025% ( 870, 1300 ] 69 0.002% 100.027% ( 1300, 1900 ] 32 0.001% 100.028% ( 1900, 2900 ] 18 0.000% 100.029% ( 2900, 4400 ] 23 0.001% 100.029% ( 4400, 6600 ] 2 0.000% 100.029% ( 6600, 9900 ] 2 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 1146419 Average: 4.5999 StdDev: 67.22 Min: 1 Median: 1.8913 Max: 11605 Percentiles: P50: 1.89 P75: 2.78 P99: 9.09 P99.9: 14.88 P99.99: 113.54 ------------------------------------------------------ [ 0, 1 ] 52526 4.582% 4.582% # ( 1, 2 ] 584171 50.956% 55.538% ########## ( 2, 3 ] 287247 25.056% 80.594% ##### ( 3, 4 ] 86723 7.565% 88.159% ## ( 4, 6 ] 102887 8.975% 97.133% ## ( 6, 10 ] 27683 2.415% 99.548% ( 10, 15 ] 4132 0.360% 99.908% ( 15, 22 ] 568 0.050% 99.958% ( 22, 34 ] 48 0.004% 99.962% ( 34, 51 ] 7 0.001% 99.963% ( 51, 76 ] 19 0.002% 99.964% ( 76, 110 ] 270 0.024% 99.988% ( 110, 170 ] 396 0.035% 100.023% ( 170, 250 ] 235 0.020% 100.043% ( 250, 380 ] 277 0.024% 100.067% ( 380, 580 ] 385 0.034% 100.101% ( 580, 870 ] 320 0.028% 100.129% ( 870, 1300 ] 220 0.019% 100.148% ( 1300, 1900 ] 111 0.010% 100.158% ( 1900, 2900 ] 88 0.008% 100.165% ( 2900, 4400 ] 122 0.011% 100.176% ( 4400, 6600 ] 38 0.003% 100.179% ( 6600, 9900 ] 19 0.002% 100.181% ( 9900, 14000 ] 1 0.000% 100.181% ** Level 2 read latency histogram (micros): Count: 31985 Average: 4.0327 StdDev: 45.31 Min: 1 Median: 1.7217 Max: 3672 Percentiles: P50: 1.72 P75: 2.38 P99: 7.87 P99.9: 517.69 P99.99: 2460.30 ------------------------------------------------------ [ 0, 1 ] 1520 4.752% 4.752% # ( 1, 2 ] 20054 62.698% 67.450% ############# ( 2, 3 ] 6323 19.769% 87.219% #### ( 3, 4 ] 1761 5.506% 92.725% # ( 4, 6 ] 1832 5.728% 98.452% # ( 6, 10 ] 375 1.172% 99.625% ( 10, 15 ] 43 0.134% 99.759% ( 15, 22 ] 9 0.028% 99.787% ( 22, 34 ] 1 0.003% 99.791% ( 51, 76 ] 1 0.003% 99.794% ( 110, 170 ] 4 0.013% 99.806% ( 170, 250 ] 5 0.016% 99.822% ( 250, 380 ] 14 0.044% 99.866% ( 380, 580 ] 16 0.050% 99.916% ( 580, 870 ] 11 0.034% 99.950% ( 870, 1300 ] 9 0.028% 99.978% ( 1300, 1900 ] 1 0.003% 99.981% ( 1900, 2900 ] 5 0.016% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 741295 Average: 7.5135 StdDev: 89.95 Min: 1 Median: 2.1636 Max: 9543 Percentiles: P50: 2.16 P75: 3.04 P99: 9.87 P99.9: 416.67 P99.99: 551.32 ------------------------------------------------------ [ 0, 1 ] 8888 1.199% 1.199% ( 1, 2 ] 326092 43.990% 45.188% ######### ( 2, 3 ] 218079 29.419% 74.607% ###### ( 3, 4 ] 75318 10.160% 84.767% ## ( 4, 6 ] 87774 11.841% 96.608% ## ( 6, 10 ] 18329 2.473% 99.081% ( 10, 15 ] 3086 0.416% 99.497% ( 15, 22 ] 410 0.055% 99.552% ( 22, 34 ] 37 0.005% 99.557% ( 34, 51 ] 16 0.002% 99.559% ( 51, 76 ] 42 0.006% 99.565% ( 76, 110 ] 149 0.020% 99.585% ( 110, 170 ] 603 0.081% 99.667% ( 170, 250 ] 743 0.100% 99.767% ( 250, 380 ] 806 0.109% 99.875% ( 380, 580 ] 991 0.134% 100.009% ( 580, 870 ] 779 0.105% 100.114% ( 870, 1300 ] 420 0.057% 100.171% ( 1300, 1900 ] 156 0.021% 100.192% ( 1900, 2900 ] 157 0.021% 100.213% ( 2900, 4400 ] 117 0.016% 100.229% ( 4400, 6600 ] 43 0.006% 100.235% ( 6600, 9900 ] 16 0.002% 100.237% ** Level 4 read latency histogram (micros): Count: 51257 Average: 19.4481 StdDev: 249.74 Min: 0 Median: 2.2869 Max: 13143 Percentiles: P50: 2.29 P75: 3.35 P99: 27.15 P99.9: 3318.58 P99.99: 4751.30 ------------------------------------------------------ [ 0, 1 ] 453 0.884% 0.884% ( 1, 2 ] 20778 40.537% 41.421% ######## ( 2, 3 ] 15327 29.902% 71.323% ###### ( 3, 4 ] 5408 10.551% 81.874% ## ( 4, 6 ] 6956 13.571% 95.445% ### ( 6, 10 ] 1535 2.995% 98.439% # ( 10, 15 ] 250 0.488% 98.927% ( 15, 22 ] 34 0.066% 98.993% ( 22, 34 ] 8 0.016% 99.009% ( 34, 51 ] 6 0.012% 99.021% ( 51, 76 ] 3 0.006% 99.026% ( 76, 110 ] 2 0.004% 99.030% ( 110, 170 ] 28 0.055% 99.085% ( 170, 250 ] 53 0.103% 99.188% ( 250, 380 ] 47 0.092% 99.280% ( 380, 580 ] 72 0.140% 99.421% ( 580, 870 ] 89 0.174% 99.594% ( 870, 1300 ] 60 0.117% 99.711% ( 1300, 1900 ] 35 0.068% 99.780% ( 1900, 2900 ] 45 0.088% 99.867% ( 2900, 4400 ] 60 0.117% 99.984% ( 4400, 6600 ] 18 0.035% 100.020% ( 6600, 9900 ] 18 0.035% 100.055% ( 9900, 14000 ] 3 0.006% 100.060% ** Level 5 read latency histogram (micros): Count: 220 Average: 1167.7955 StdDev: 1332.78 Min: 77 Median: 580.0000 Max: 6587 Percentiles: P50: 580.00 P75: 1825.00 P99: 5995.00 P99.9: 6539.50 P99.99: 6587.00 ------------------------------------------------------ ( 76, 110 ] 24 10.909% 10.909% ## ( 110, 170 ] 30 13.636% 24.545% ### ( 170, 250 ] 17 7.727% 32.273% ## ( 250, 380 ] 22 10.000% 42.273% ## ( 380, 580 ] 17 7.727% 50.000% ## ( 580, 870 ] 26 11.818% 61.818% ## ( 870, 1300 ] 15 6.818% 68.636% # ( 1300, 1900 ] 16 7.273% 75.909% # ( 1900, 2900 ] 24 10.909% 86.818% ## ( 2900, 4400 ] 21 9.545% 96.364% ## ( 4400, 6600 ] 8 3.636% 100.000% # ** DB Stats ** Uptime(secs): 40.8 total, 8.4 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 216.96 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:15.873 H:M:S, 38.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 117.05 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:5.370 H:M:S, 63.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/16-13:25:18 ... thread 0: (1000000,10000000) ops and (330082.0,229259.9) ops/second in (3.029550,43.618622) 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/4 4.48 GB 427.0 10.1 0.0 10.1 19.6 9.5 0.0 2.1 150.5 290.7 69.05 63.40 167 0.413 10M 23K 0.0 0.0 L1 9/0 1014.06 MB 101.4 6.0 4.8 1.1 5.9 4.8 0.1 1.2 223.4 221.1 27.32 26.10 4 6.831 6197K 61K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 4.0 2.0 245.0 245.0 0.51 0.49 1 0.514 127K 44 0.0 0.0 L3 20/0 992.27 MB 1.0 3.8 2.0 1.8 3.8 2.0 2.0 1.9 177.4 176.7 21.94 17.55 16 1.371 3840K 14K 0.0 0.0 L4 167/0 9.55 GB 1.0 2.8 2.2 0.5 2.8 2.2 1.7 1.2 142.3 141.6 19.92 13.26 30 0.664 2879K 14K 0.0 0.0 L5 1088/0 89.51 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1301/4 105.50 GB 0.0 22.8 9.2 13.6 32.2 18.5 11.8 3.4 168.3 237.4 138.75 120.81 218 0.636 23M 114K 0.0 0.0 Int 0/0 0.00 KB 0.0 22.8 9.2 13.6 32.2 18.5 11.7 3.4 168.3 237.4 138.75 120.81 218 0.636 23M 114K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 22.8 9.2 13.6 22.7 9.0 0.0 0.0 211.9 210.9 110.18 96.56 81 1.360 23M 114K 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 339.6 28.57 24.25 137 0.209 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): 43.9 total, 43.6 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: 32.16 GB write, 750.96 MB/s write, 22.80 GB read, 532.41 MB/s read, 138.8 seconds Interval compaction: 32.16 GB write, 755.00 MB/s write, 22.80 GB read, 535.27 MB/s read, 138.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 21, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 21, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 52, pending-compaction-bytes-delays: 19, pending-compaction-bytes-stops: 0, total-delays: 40, total-stops: 52, interval: 92 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3961365 Average: 2.6005 StdDev: 16.41 Min: 0 Median: 1.5828 Max: 7768 Percentiles: P50: 1.58 P75: 1.97 P99: 6.78 P99.9: 87.96 P99.99: 193.92 ------------------------------------------------------ [ 0, 1 ] 505652 12.765% 12.765% ### ( 1, 2 ] 2530948 63.891% 76.655% ############# ( 2, 3 ] 604799 15.267% 91.923% ### ( 3, 4 ] 142501 3.597% 95.520% # ( 4, 6 ] 130839 3.303% 98.823% # ( 6, 10 ] 36092 0.911% 99.734% ( 10, 15 ] 5398 0.136% 99.870% ( 15, 22 ] 539 0.014% 99.884% ( 22, 34 ] 46 0.001% 99.885% ( 34, 51 ] 28 0.001% 99.886% ( 51, 76 ] 23 0.001% 99.886% ( 76, 110 ] 1534 0.039% 99.925% ( 110, 170 ] 2369 0.060% 99.985% ( 170, 250 ] 675 0.017% 100.002% ( 250, 380 ] 378 0.010% 100.012% ( 380, 580 ] 323 0.008% 100.020% ( 580, 870 ] 193 0.005% 100.025% ( 870, 1300 ] 75 0.002% 100.026% ( 1300, 1900 ] 35 0.001% 100.027% ( 1900, 2900 ] 20 0.001% 100.028% ( 2900, 4400 ] 25 0.001% 100.028% ( 4400, 6600 ] 2 0.000% 100.029% ( 6600, 9900 ] 2 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 1163807 Average: 4.5728 StdDev: 66.72 Min: 1 Median: 1.8918 Max: 11605 Percentiles: P50: 1.89 P75: 2.77 P99: 9.09 P99.9: 14.87 P99.99: 113.28 ------------------------------------------------------ [ 0, 1 ] 52816 4.538% 4.538% # ( 1, 2 ] 593275 50.977% 55.515% ########## ( 2, 3 ] 292802 25.159% 80.674% ##### ( 3, 4 ] 87677 7.534% 88.208% ## ( 4, 6 ] 103900 8.928% 97.136% ## ( 6, 10 ] 28072 2.412% 99.548% ( 10, 15 ] 4212 0.362% 99.910% ( 15, 22 ] 571 0.049% 99.959% ( 22, 34 ] 48 0.004% 99.963% ( 34, 51 ] 7 0.001% 99.963% ( 51, 76 ] 19 0.002% 99.965% ( 76, 110 ] 270 0.023% 99.988% ( 110, 170 ] 396 0.034% 100.022% ( 170, 250 ] 235 0.020% 100.042% ( 250, 380 ] 277 0.024% 100.066% ( 380, 580 ] 385 0.033% 100.099% ( 580, 870 ] 320 0.027% 100.127% ( 870, 1300 ] 220 0.019% 100.146% ( 1300, 1900 ] 111 0.010% 100.155% ( 1900, 2900 ] 88 0.008% 100.163% ( 2900, 4400 ] 122 0.010% 100.173% ( 4400, 6600 ] 38 0.003% 100.176% ( 6600, 9900 ] 19 0.002% 100.178% ( 9900, 14000 ] 1 0.000% 100.178% ** Level 2 read latency histogram (micros): Count: 31985 Average: 4.0327 StdDev: 45.31 Min: 1 Median: 1.7217 Max: 3672 Percentiles: P50: 1.72 P75: 2.38 P99: 7.87 P99.9: 517.69 P99.99: 2460.30 ------------------------------------------------------ [ 0, 1 ] 1520 4.752% 4.752% # ( 1, 2 ] 20054 62.698% 67.450% ############# ( 2, 3 ] 6323 19.769% 87.219% #### ( 3, 4 ] 1761 5.506% 92.725% # ( 4, 6 ] 1832 5.728% 98.452% # ( 6, 10 ] 375 1.172% 99.625% ( 10, 15 ] 43 0.134% 99.759% ( 15, 22 ] 9 0.028% 99.787% ( 22, 34 ] 1 0.003% 99.791% ( 51, 76 ] 1 0.003% 99.794% ( 110, 170 ] 4 0.013% 99.806% ( 170, 250 ] 5 0.016% 99.822% ( 250, 380 ] 14 0.044% 99.866% ( 380, 580 ] 16 0.050% 99.916% ( 580, 870 ] 11 0.034% 99.950% ( 870, 1300 ] 9 0.028% 99.978% ( 1300, 1900 ] 1 0.003% 99.981% ( 1900, 2900 ] 5 0.016% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 744406 Average: 7.5199 StdDev: 89.84 Min: 1 Median: 2.1606 Max: 9543 Percentiles: P50: 2.16 P75: 3.03 P99: 9.88 P99.9: 419.08 P99.99: 552.94 ------------------------------------------------------ [ 0, 1 ] 9086 1.221% 1.221% ( 1, 2 ] 327999 44.062% 45.282% ######### ( 2, 3 ] 218712 29.381% 74.663% ###### ( 3, 4 ] 75454 10.136% 84.799% ## ( 4, 6 ] 87870 11.804% 96.603% ## ( 6, 10 ] 18396 2.471% 99.075% ( 10, 15 ] 3095 0.416% 99.490% ( 15, 22 ] 411 0.055% 99.546% ( 22, 34 ] 37 0.005% 99.551% ( 34, 51 ] 16 0.002% 99.553% ( 51, 76 ] 43 0.006% 99.558% ( 76, 110 ] 149 0.020% 99.578% ( 110, 170 ] 615 0.083% 99.661% ( 170, 250 ] 766 0.103% 99.764% ( 250, 380 ] 817 0.110% 99.874% ( 380, 580 ] 1001 0.134% 100.008% ( 580, 870 ] 782 0.105% 100.113% ( 870, 1300 ] 424 0.057% 100.170% ( 1300, 1900 ] 156 0.021% 100.191% ( 1900, 2900 ] 157 0.021% 100.212% ( 2900, 4400 ] 117 0.016% 100.228% ( 4400, 6600 ] 43 0.006% 100.234% ( 6600, 9900 ] 16 0.002% 100.236% ** Level 4 read latency histogram (micros): Count: 51272 Average: 19.4807 StdDev: 249.74 Min: 0 Median: 2.2869 Max: 13143 Percentiles: P50: 2.29 P75: 3.35 P99: 34.79 P99.9: 3318.20 P99.99: 4751.12 ------------------------------------------------------ [ 0, 1 ] 456 0.889% 0.889% ( 1, 2 ] 20782 40.533% 41.422% ######## ( 2, 3 ] 15328 29.895% 71.318% ###### ( 3, 4 ] 5409 10.550% 81.867% ## ( 4, 6 ] 6956 13.567% 95.434% ### ( 6, 10 ] 1535 2.994% 98.428% # ( 10, 15 ] 251 0.490% 98.918% ( 15, 22 ] 34 0.066% 98.984% ( 22, 34 ] 8 0.016% 98.999% ( 34, 51 ] 6 0.012% 99.011% ( 51, 76 ] 3 0.006% 99.017% ( 76, 110 ] 3 0.006% 99.023% ( 110, 170 ] 28 0.055% 99.077% ( 170, 250 ] 55 0.107% 99.185% ( 250, 380 ] 47 0.092% 99.276% ( 380, 580 ] 73 0.142% 99.419% ( 580, 870 ] 90 0.176% 99.594% ( 870, 1300 ] 60 0.117% 99.711% ( 1300, 1900 ] 35 0.068% 99.780% ( 1900, 2900 ] 45 0.088% 99.867% ( 2900, 4400 ] 60 0.117% 99.984% ( 4400, 6600 ] 18 0.035% 100.020% ( 6600, 9900 ] 18 0.035% 100.055% ( 9900, 14000 ] 3 0.006% 100.060% ** Level 5 read latency histogram (micros): Count: 240 Average: 1144.7208 StdDev: 1313.85 Min: 77 Median: 558.9474 Max: 6587 Percentiles: P50: 558.95 P75: 1766.67 P99: 5940.00 P99.9: 6534.00 P99.99: 6587.00 ------------------------------------------------------ ( 76, 110 ] 26 10.833% 10.833% ## ( 110, 170 ] 35 14.583% 25.417% ### ( 170, 250 ] 19 7.917% 33.333% ## ( 250, 380 ] 23 9.583% 42.917% ## ( 380, 580 ] 19 7.917% 50.833% ## ( 580, 870 ] 28 11.667% 62.500% ## ( 870, 1300 ] 16 6.667% 69.167% # ( 1300, 1900 ] 18 7.500% 76.667% ## ( 1900, 2900 ] 25 10.417% 87.083% ## ( 2900, 4400 ] 23 9.583% 96.667% ## ( 4400, 6600 ] 8 3.333% 100.000% # ** DB Stats ** Uptime(secs): 43.9 total, 3.0 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 224.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:16.284 H:M:S, 37.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.87 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.410 H:M:S, 13.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.789 micros/op 172752 ops/sec 60.167 seconds 10393999 operations; 167.4 MB/s Microseconds per write: Count: 10393999 Average: 5.7886 StdDev: 310.41 Min: 1 Median: 1.7458 Max: 511759 Percentiles: P50: 1.75 P75: 2.79 P99: 9.56 P99.9: 1163.20 P99.99: 2740.74 ------------------------------------------------------ [ 0, 1 ] 1325418 12.752% 12.752% ### ( 1, 2 ] 5191488 49.947% 62.699% ########## ( 2, 3 ] 1618926 15.576% 78.274% ### ( 3, 4 ] 1448270 13.934% 92.208% ### ( 4, 6 ] 582229 5.602% 97.810% # ( 6, 10 ] 138847 1.336% 99.145% ( 10, 15 ] 47087 0.453% 99.598% ( 15, 22 ] 9811 0.094% 99.693% ( 22, 34 ] 1546 0.015% 99.708% ( 34, 51 ] 207 0.002% 99.710% ( 51, 76 ] 29 0.000% 99.710% ( 76, 110 ] 7233 0.070% 99.780% ( 110, 170 ] 2837 0.027% 99.807% ( 170, 250 ] 270 0.003% 99.809% ( 250, 380 ] 200 0.002% 99.811% ( 380, 580 ] 28 0.000% 99.812% ( 580, 870 ] 21 0.000% 99.812% ( 870, 1300 ] 13431 0.129% 99.941% ( 1300, 1900 ] 54 0.001% 99.942% ( 1900, 2900 ] 5980 0.058% 99.999% ( 2900, 4400 ] 40 0.000% 100.000% ( 4400, 6600 ] 12 0.000% 100.000% ( 6600, 9900 ] 8 0.000% 100.000% ( 9900, 14000 ] 4 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 3 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 13 0.000% 100.000% ( 250000, 380000 ] 2 0.000% 100.000% ( 380000, 570000 ] 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 : 196236 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 : 10393999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10726606968 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 : 507 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31227072 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 : 28796166445 rocksdb.compact.write.bytes COUNT : 28610658783 rocksdb.flush.write.bytes COUNT : 10701332504 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 : 56 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 : 309 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 : 10615066624 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4143104 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 : 28893896599 rocksdb.non.last.level.read.count COUNT : 6979883 rocksdb.block.checksum.compute.count COUNT : 6978925 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.393102 P95 : 3.942128 P99 : 8.148639 P100 : 511757.000000 COUNT : 10393999 SUM : 55167896 rocksdb.compaction.times.micros P50 : 991142.857143 P95 : 4090000.000000 P99 : 12257000.000000 P100 : 13231511.000000 COUNT : 83 SUM : 112339113 rocksdb.compaction.times.cpu_micros P50 : 877586.206897 P95 : 2825000.000000 P99 : 12257000.000000 P100 : 12763358.000000 COUNT : 83 SUM : 98684094 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 : 670.135135 P95 : 2700.000000 P99 : 28160.000000 P100 : 40776.000000 COUNT : 144 SUM : 196724 rocksdb.compaction.outfile.sync.micros P50 : 971.987179 P95 : 33956.250000 P99 : 73708.333333 P100 : 123927.000000 COUNT : 331 SUM : 1918802 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 : 103.155844 P95 : 481.428571 P99 : 1693.000000 P100 : 2503.000000 COUNT : 269 SUM : 49026 rocksdb.table.open.io.micros P50 : 1328.378378 P95 : 8723.000000 P99 : 20160.000000 P100 : 22868.000000 COUNT : 507 SUM : 1213853 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.674504 P95 : 7.759631 P99 : 10.791378 P100 : 13148.000000 COUNT : 6977630 SUM : 39048090 rocksdb.read.block.get.micros P50 : 464.210526 P95 : 3925.892857 P99 : 7326.000000 P100 : 9792.000000 COUNT : 1014 SUM : 968449 rocksdb.write.raw.block.micros P50 : 0.512343 P95 : 0.973451 P99 : 2.895054 P100 : 15177.000000 COUNT : 9521109 SUM : 18721904 rocksdb.numfiles.in.singlecompaction P50 : 3.253333 P95 : 5.733333 P99 : 14.100000 P100 : 25.000000 COUNT : 136 SUM : 503 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.561336 P95 : 1206.650420 P99 : 2610.015073 P100 : 511563.000000 COUNT : 179750 SUM : 31250803 rocksdb.sst.read.micros P50 : 1.633174 P95 : 4.689816 P99 : 8.379262 P100 : 13143.000000 COUNT : 6980187 SUM : 25103220 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 : 10393999 SUM : 10726606968 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 : 209183.673469 P95 : 363176.470588 P99 : 549100.000000 P100 : 688021.000000 COUNT : 144 SUM : 29949124 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 : 309 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