[2024-12-15 22:01:06.577971] Starting SPDK v24.09.1-pre git sha1 b18e1bd62 / DPDK 22.11.4 initialization... [2024-12-15 22:01:06.578251] [ 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_pid1198360 ] Set seed to 1734296466571288 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-15 22:01:06.675707] app.c: 917:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-15 22:01:06.717513] app.c: 610:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-15 22:01:06.717565] app.c: 611:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1198360' to capture a snapshot of events at runtime. [2024-12-15 22:01:06.717576] app.c: 616:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-15 22:01:06.717587] app.c: 617:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-15 22:01:06.717594] app.c: 618:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1198360 for offline analysis/debug. [2024-12-15 22:01:06.717681] reactor.c: 990:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sun Dec 15 22:01:10 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/15-22:01:13 ... thread 0: (1000000,1000000) ops and (354041.0,354041.0) ops/second in (2.824532,2.824532) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/6 567.03 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 349.5 2.34 2.11 12 0.195 0 0 0.0 0.0 L2 3/2 251.76 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.1 2.0 248.7 248.6 1.52 1.47 2 0.760 383K 198 0.0 0.0 L3 10/0 804.19 MB 0.8 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.75 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1182/8 96.94 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.5 97.8 309.8 3.86 3.58 14 0.276 383K 198 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.1 1.5 97.8 309.8 3.86 3.58 14 0.276 383K 198 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.0 0.0 248.7 248.6 1.52 1.47 2 0.760 383K 198 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 349.5 2.34 2.11 12 0.195 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.1 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.17 GB write, 392.05 MB/s write, 0.37 GB read, 123.81 MB/s read, 3.9 seconds Interval compaction: 1.17 GB write, 423.40 MB/s write, 0.37 GB read, 133.71 MB/s read, 3.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 1, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 1, interval: 1 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 103375 Average: 1.8987 StdDev: 19.12 Min: 0 Median: 1.2260 Max: 3461 Percentiles: P50: 1.23 P75: 1.66 P99: 3.81 P99.9: 9.54 P99.99: 247.00 ------------------------------------------------------ [ 0, 1 ] 38193 36.946% 36.946% ####### ( 1, 2 ] 59698 57.749% 94.695% ############ ( 2, 3 ] 3519 3.404% 98.099% # ( 3, 4 ] 1157 1.119% 99.218% ( 4, 6 ] 524 0.507% 99.725% ( 6, 10 ] 205 0.198% 99.924% ( 10, 15 ] 50 0.048% 99.972% ( 15, 22 ] 5 0.005% 99.977% ( 34, 51 ] 1 0.001% 99.978% ( 110, 170 ] 5 0.005% 99.983% ( 170, 250 ] 9 0.009% 99.991% ( 250, 380 ] 2 0.002% 99.993% ( 580, 870 ] 1 0.001% 99.994% ( 870, 1300 ] 2 0.002% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 2 0.002% 100.001% ** Level 2 read latency histogram (micros): Count: 50586 Average: 2.1377 StdDev: 22.68 Min: 1 Median: 1.2892 Max: 3218 Percentiles: P50: 1.29 P75: 1.71 P99: 5.31 P99.9: 12.39 P99.99: 1078.70 ------------------------------------------------------ [ 0, 1 ] 16586 32.788% 32.788% ####### ( 1, 2 ] 30103 59.509% 92.296% ############ ( 2, 3 ] 2210 4.369% 96.665% # ( 3, 4 ] 835 1.651% 98.316% ( 4, 6 ] 531 1.050% 99.365% ( 6, 10 ] 247 0.488% 99.854% ( 10, 15 ] 51 0.101% 99.955% ( 15, 22 ] 6 0.012% 99.966% ( 22, 34 ] 1 0.002% 99.968% ( 51, 76 ] 1 0.002% 99.970% ( 76, 110 ] 1 0.002% 99.972% ( 170, 250 ] 1 0.002% 99.974% ( 250, 380 ] 2 0.004% 99.978% ( 380, 580 ] 2 0.004% 99.982% ( 580, 870 ] 3 0.006% 99.988% ( 870, 1300 ] 4 0.008% 99.996% ( 1900, 2900 ] 2 0.004% 100.000% ( 2900, 4400 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 40 Average: 1574.1750 StdDev: 1198.08 Min: 156 Median: 1300.0000 Max: 4368 Percentiles: P50: 1300.00 P75: 2400.00 P99: 4314.29 P99.9: 4368.00 P99.99: 4368.00 ------------------------------------------------------ ( 110, 170 ] 1 2.500% 2.500% # ( 170, 250 ] 1 2.500% 5.000% # ( 250, 380 ] 3 7.500% 12.500% ## ( 380, 580 ] 8 20.000% 32.500% #### ( 580, 870 ] 2 5.000% 37.500% # ( 870, 1300 ] 5 12.500% 50.000% ### ( 1300, 1900 ] 7 17.500% 67.500% #### ( 1900, 2900 ] 6 15.000% 82.500% ### ( 2900, 4400 ] 7 17.500% 100.000% #### ** Level 4 read latency histogram (micros): Count: 30 Average: 1769.9333 StdDev: 1121.26 Min: 300 Median: 1500.0000 Max: 4747 Percentiles: P50: 1500.00 P75: 2275.00 P99: 4747.00 P99.9: 4747.00 P99.99: 4747.00 ------------------------------------------------------ ( 250, 380 ] 3 10.000% 10.000% ## ( 380, 580 ] 1 3.333% 13.333% # ( 870, 1300 ] 8 26.667% 40.000% ##### ( 1300, 1900 ] 9 30.000% 70.000% ###### ( 1900, 2900 ] 4 13.333% 83.333% ### ( 2900, 4400 ] 4 13.333% 96.667% ### ( 4400, 6600 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 3.1 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 322.40 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.206 H:M:S, 6.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 348.10 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.206 H:M:S, 7.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/15-22:01:16 ... thread 0: (1000000,2000000) ops and (318327.1,335235.5) ops/second in (3.141423,5.965955) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/11 1.17 GB 25.2 0.2 0.0 0.2 2.0 1.8 0.0 1.1 40.8 336.7 6.17 5.61 27 0.229 255K 246 0.0 0.0 L1 1/1 3.12 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 241.0 240.6 1.57 1.52 1 1.568 383K 545 0.0 0.0 L2 2/1 54.61 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 248.7 248.6 1.52 1.47 2 0.760 383K 198 0.0 0.0 L3 20/10 1.12 GB 0.3 0.2 0.2 0.0 0.2 0.2 0.4 1.0 227.1 227.1 1.10 1.03 1 1.100 253K 0 0.0 0.0 L4 170/0 9.45 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 149.6 149.6 1.50 1.12 1 1.501 228K 0 0.0 0.0 L5 1048/0 86.12 GB 0.9 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 Sum 1255/23 97.92 GB 0.0 1.4 1.0 0.4 3.2 2.8 1.5 1.8 125.0 278.9 11.86 10.74 32 0.371 1505K 989 0.0 0.0 Int 0/0 0.00 KB 0.0 1.4 1.0 0.4 3.2 2.8 1.4 1.8 125.0 278.9 11.86 10.74 32 0.371 1505K 989 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.4 1.0 0.4 1.4 1.0 0.0 0.0 222.4 222.3 6.66 6.09 6 1.111 1505K 989 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 351.4 5.20 4.66 26 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.2 total, 6.0 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.23 GB write, 534.10 MB/s write, 1.45 GB read, 239.31 MB/s read, 11.9 seconds Interval compaction: 3.23 GB write, 554.33 MB/s write, 1.45 GB read, 248.37 MB/s read, 11.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 382278 Average: 2.2690 StdDev: 13.67 Min: 0 Median: 1.5238 Max: 3461 Percentiles: P50: 1.52 P75: 1.91 P99: 5.71 P99.9: 10.75 P99.99: 14.38 ------------------------------------------------------ [ 0, 1 ] 63001 16.480% 16.480% ### ( 1, 2 ] 244628 63.992% 80.473% ############# ( 2, 3 ] 46739 12.226% 92.699% ## ( 3, 4 ] 15559 4.070% 96.769% # ( 4, 6 ] 9977 2.610% 99.379% # ( 6, 10 ] 1924 0.503% 99.882% ( 10, 15 ] 474 0.124% 100.006% ( 15, 22 ] 39 0.010% 100.016% ( 22, 34 ] 1 0.000% 100.017% ( 34, 51 ] 4 0.001% 100.018% ( 110, 170 ] 8 0.002% 100.020% ( 170, 250 ] 19 0.005% 100.025% ( 250, 380 ] 7 0.002% 100.027% ( 380, 580 ] 1 0.000% 100.027% ( 580, 870 ] 3 0.001% 100.028% ( 870, 1300 ] 5 0.001% 100.029% ( 1300, 1900 ] 6 0.002% 100.031% ( 1900, 2900 ] 1 0.000% 100.031% ( 2900, 4400 ] 4 0.001% 100.032% ** Level 1 read latency histogram (micros): Count: 26 Average: 150.6923 StdDev: 268.14 Min: 1 Median: 1.6667 Max: 882 Percentiles: P50: 1.67 P75: 230.00 P99: 882.00 P99.9: 882.00 P99.99: 882.00 ------------------------------------------------------ [ 0, 1 ] 7 26.923% 26.923% ##### ( 1, 2 ] 9 34.615% 61.538% ####### ( 4, 6 ] 2 7.692% 69.231% ## ( 170, 250 ] 2 7.692% 76.923% ## ( 250, 380 ] 3 11.538% 88.462% ## ( 580, 870 ] 2 7.692% 96.154% ## ( 870, 1300 ] 1 3.846% 100.000% # ** Level 2 read latency histogram (micros): Count: 95725 Average: 2.2265 StdDev: 16.51 Min: 1 Median: 1.4541 Max: 3218 Percentiles: P50: 1.45 P75: 1.85 P99: 5.72 P99.9: 11.71 P99.99: 621.32 ------------------------------------------------------ [ 0, 1 ] 20370 21.280% 21.280% #### ( 1, 2 ] 60541 63.245% 84.524% ############# ( 2, 3 ] 9019 9.422% 93.946% ## ( 3, 4 ] 3024 3.159% 97.105% # ( 4, 6 ] 2110 2.204% 99.309% ( 6, 10 ] 531 0.555% 99.864% ( 10, 15 ] 100 0.104% 99.969% ( 15, 22 ] 11 0.011% 99.980% ( 22, 34 ] 2 0.002% 99.982% ( 51, 76 ] 1 0.001% 99.983% ( 76, 110 ] 1 0.001% 99.984% ( 170, 250 ] 1 0.001% 99.985% ( 250, 380 ] 2 0.002% 99.987% ( 380, 580 ] 2 0.002% 99.990% ( 580, 870 ] 3 0.003% 99.993% ( 870, 1300 ] 4 0.004% 99.997% ( 1900, 2900 ] 2 0.002% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 184033 Average: 3.3346 StdDev: 33.54 Min: 1 Median: 1.6618 Max: 4368 Percentiles: P50: 1.66 P75: 2.21 P99: 8.62 P99.9: 150.70 P99.99: 326.07 ------------------------------------------------------ [ 0, 1 ] 16156 8.779% 8.779% ## ( 1, 2 ] 114634 62.290% 71.069% ############ ( 2, 3 ] 33833 18.384% 89.453% #### ( 3, 4 ] 8929 4.852% 94.305% # ( 4, 6 ] 6827 3.710% 98.014% # ( 6, 10 ] 2771 1.506% 99.520% ( 10, 15 ] 431 0.234% 99.754% ( 15, 22 ] 86 0.047% 99.801% ( 22, 34 ] 15 0.008% 99.809% ( 34, 51 ] 5 0.003% 99.812% ( 51, 76 ] 4 0.002% 99.814% ( 76, 110 ] 26 0.014% 99.828% ( 110, 170 ] 196 0.107% 99.935% ( 170, 250 ] 71 0.039% 99.973% ( 250, 380 ] 54 0.029% 100.003% ( 380, 580 ] 39 0.021% 100.024% ( 580, 870 ] 22 0.012% 100.036% ( 870, 1300 ] 17 0.009% 100.045% ( 1300, 1900 ] 7 0.004% 100.049% ( 1900, 2900 ] 8 0.004% 100.053% ( 2900, 4400 ] 7 0.004% 100.057% ** Level 4 read latency histogram (micros): Count: 320 Average: 173.5813 StdDev: 621.03 Min: 1 Median: 1.8264 Max: 4747 Percentiles: P50: 1.83 P75: 7.23 P99: 3575.00 P99.9: 4747.00 P99.99: 4747.00 ------------------------------------------------------ [ 0, 1 ] 60 18.750% 18.750% #### ( 1, 2 ] 121 37.812% 56.562% ######## ( 2, 3 ] 34 10.625% 67.188% ## ( 3, 4 ] 10 3.125% 70.312% # ( 4, 6 ] 11 3.438% 73.750% # ( 6, 10 ] 13 4.062% 77.812% # ( 10, 15 ] 33 10.312% 88.125% ## ( 15, 22 ] 6 1.875% 90.000% ( 110, 170 ] 1 0.312% 90.312% ( 250, 380 ] 3 0.938% 91.250% ( 380, 580 ] 1 0.312% 91.562% ( 870, 1300 ] 9 2.812% 94.375% # ( 1300, 1900 ] 9 2.812% 97.188% # ( 1900, 2900 ] 4 1.250% 98.438% ( 2900, 4400 ] 4 1.250% 99.688% ( 4400, 6600 ] 1 0.312% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 805.7000 StdDev: 1021.08 Min: 76 Median: 380.0000 Max: 3639 Percentiles: P50: 380.00 P75: 1013.33 P99: 3639.00 P99.9: 3639.00 P99.99: 3639.00 ------------------------------------------------------ ( 51, 76 ] 1 5.000% 5.000% # ( 76, 110 ] 1 5.000% 10.000% # ( 110, 170 ] 5 25.000% 35.000% ##### ( 170, 250 ] 1 5.000% 40.000% # ( 250, 380 ] 2 10.000% 50.000% ## ( 380, 580 ] 3 15.000% 65.000% ### ( 580, 870 ] 1 5.000% 70.000% # ( 870, 1300 ] 3 15.000% 85.000% ### ( 1900, 2900 ] 1 5.000% 90.000% # ( 2900, 4400 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 6.2 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 317.78 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.598 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, 313.29 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.392 H:M:S, 12.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/15-22:01:20 ... thread 0: (1000000,3000000) ops and (320634.6,330223.0) ops/second in (3.118815,9.084770) 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/8 1.48 GB 6.3 1.3 0.0 1.3 4.1 2.8 0.0 1.5 99.3 311.9 13.33 12.32 45 0.296 1343K 1394 0.0 0.0 L1 3/3 212.40 MB 0.0 1.0 1.0 0.0 1.0 1.0 0.2 1.0 232.3 231.8 4.62 4.49 2 2.311 1090K 2458 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 248.7 248.6 1.52 1.47 2 0.760 383K 198 0.0 0.0 L3 21/0 910.33 MB 0.9 1.9 0.8 1.1 1.9 0.8 0.4 2.5 227.2 226.7 8.53 7.98 6 1.421 1967K 4058 0.0 0.0 L4 174/0 9.59 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 149.6 149.6 1.50 1.12 1 1.501 228K 0 0.0 0.0 L5 1056/0 86.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1263/11 98.90 GB 0.0 4.8 2.2 2.6 7.6 5.0 3.3 2.7 167.3 263.2 29.50 27.37 56 0.527 5012K 8108 0.0 0.0 Int 0/0 0.00 KB 0.0 4.8 2.2 2.6 7.6 5.0 3.2 2.7 167.3 263.2 29.50 27.37 56 0.527 5012K 8108 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.8 2.2 2.6 4.8 2.2 0.0 0.0 231.4 231.0 21.34 20.12 16 1.333 5012K 8108 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 347.4 8.16 7.26 40 0.204 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.3 total, 9.1 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.58 GB write, 833.57 MB/s write, 4.82 GB read, 530.05 MB/s read, 29.5 seconds Interval compaction: 7.58 GB write, 854.30 MB/s write, 4.82 GB read, 543.24 MB/s read, 29.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: 8, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 8, interval: 8 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 676025 Average: 2.3610 StdDev: 13.49 Min: 0 Median: 1.5765 Max: 3886 Percentiles: P50: 1.58 P75: 1.97 P99: 5.83 P99.9: 11.55 P99.99: 14.53 ------------------------------------------------------ [ 0, 1 ] 88152 13.040% 13.040% ### ( 1, 2 ] 433412 64.112% 77.152% ############# ( 2, 3 ] 94232 13.939% 91.091% ### ( 3, 4 ] 32568 4.818% 95.908% # ( 4, 6 ] 22858 3.381% 99.290% # ( 6, 10 ] 3813 0.564% 99.854% ( 10, 15 ] 1019 0.151% 100.004% ( 15, 22 ] 79 0.012% 100.016% ( 22, 34 ] 4 0.001% 100.017% ( 34, 51 ] 6 0.001% 100.017% ( 110, 170 ] 9 0.001% 100.019% ( 170, 250 ] 30 0.004% 100.023% ( 250, 380 ] 12 0.002% 100.025% ( 380, 580 ] 5 0.001% 100.026% ( 580, 870 ] 9 0.001% 100.027% ( 870, 1300 ] 11 0.002% 100.029% ( 1300, 1900 ] 6 0.001% 100.030% ( 1900, 2900 ] 1 0.000% 100.030% ( 2900, 4400 ] 7 0.001% 100.031% ** Level 1 read latency histogram (micros): Count: 217178 Average: 2.8338 StdDev: 9.30 Min: 0 Median: 1.7884 Max: 1310 Percentiles: P50: 1.79 P75: 2.61 P99: 7.52 P99.9: 10.78 P99.99: 12.44 ------------------------------------------------------ [ 0, 1 ] 8404 3.870% 3.870% # ( 1, 2 ] 127079 58.514% 62.383% ############ ( 2, 3 ] 44880 20.665% 83.048% #### ( 3, 4 ] 17561 8.086% 91.134% ## ( 4, 6 ] 15944 7.341% 98.476% # ( 6, 10 ] 3001 1.382% 99.858% ( 10, 15 ] 589 0.271% 100.129% ( 15, 22 ] 47 0.022% 100.151% ( 22, 34 ] 4 0.002% 100.152% ( 51, 76 ] 3 0.001% 100.154% ( 76, 110 ] 25 0.012% 100.165% ( 110, 170 ] 25 0.012% 100.177% ( 170, 250 ] 18 0.008% 100.185% ( 250, 380 ] 17 0.008% 100.193% ( 380, 580 ] 14 0.006% 100.199% ( 580, 870 ] 11 0.005% 100.204% ( 870, 1300 ] 3 0.001% 100.206% ( 1300, 1900 ] 2 0.001% 100.207% ** Level 2 read latency histogram (micros): Count: 124185 Average: 2.4773 StdDev: 16.62 Min: 1 Median: 1.5004 Max: 3218 Percentiles: P50: 1.50 P75: 1.89 P99: 6.54 P99.9: 94.40 P99.99: 709.83 ------------------------------------------------------ [ 0, 1 ] 22480 18.102% 18.102% #### ( 1, 2 ] 79157 63.741% 81.843% ############# ( 2, 3 ] 13573 10.930% 92.773% ## ( 3, 4 ] 4500 3.624% 96.397% # ( 4, 6 ] 3089 2.487% 98.884% ( 6, 10 ] 1073 0.864% 99.748% ( 10, 15 ] 142 0.114% 99.862% ( 15, 22 ] 18 0.014% 99.877% ( 22, 34 ] 2 0.002% 99.878% ( 34, 51 ] 1 0.001% 99.879% ( 51, 76 ] 2 0.002% 99.881% ( 76, 110 ] 44 0.035% 99.916% ( 110, 170 ] 46 0.037% 99.953% ( 170, 250 ] 17 0.014% 99.967% ( 250, 380 ] 17 0.014% 99.981% ( 380, 580 ] 8 0.006% 99.987% ( 580, 870 ] 8 0.006% 99.994% ( 870, 1300 ] 5 0.004% 99.998% ( 1900, 2900 ] 2 0.002% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 239484 Average: 3.3285 StdDev: 31.03 Min: 1 Median: 1.6519 Max: 4368 Percentiles: P50: 1.65 P75: 2.17 P99: 8.67 P99.9: 167.17 P99.99: 423.51 ------------------------------------------------------ [ 0, 1 ] 21382 8.928% 8.928% ## ( 1, 2 ] 150892 63.007% 71.935% ############# ( 2, 3 ] 41951 17.517% 89.453% #### ( 3, 4 ] 11799 4.927% 94.380% # ( 4, 6 ] 8583 3.584% 97.964% # ( 6, 10 ] 3713 1.550% 99.514% ( 10, 15 ] 512 0.214% 99.728% ( 15, 22 ] 93 0.039% 99.767% ( 22, 34 ] 18 0.008% 99.774% ( 34, 51 ] 8 0.003% 99.777% ( 51, 76 ] 4 0.002% 99.779% ( 76, 110 ] 37 0.015% 99.795% ( 110, 170 ] 265 0.111% 99.905% ( 170, 250 ] 118 0.049% 99.954% ( 250, 380 ] 72 0.030% 99.985% ( 380, 580 ] 60 0.025% 100.010% ( 580, 870 ] 37 0.015% 100.025% ( 870, 1300 ] 22 0.009% 100.034% ( 1300, 1900 ] 7 0.003% 100.037% ( 1900, 2900 ] 8 0.003% 100.041% ( 2900, 4400 ] 7 0.003% 100.043% ** Level 4 read latency histogram (micros): Count: 320 Average: 173.5813 StdDev: 621.03 Min: 1 Median: 1.8264 Max: 4747 Percentiles: P50: 1.83 P75: 7.23 P99: 3575.00 P99.9: 4747.00 P99.99: 4747.00 ------------------------------------------------------ [ 0, 1 ] 60 18.750% 18.750% #### ( 1, 2 ] 121 37.812% 56.562% ######## ( 2, 3 ] 34 10.625% 67.188% ## ( 3, 4 ] 10 3.125% 70.312% # ( 4, 6 ] 11 3.438% 73.750% # ( 6, 10 ] 13 4.062% 77.812% # ( 10, 15 ] 33 10.312% 88.125% ## ( 15, 22 ] 6 1.875% 90.000% ( 110, 170 ] 1 0.312% 90.312% ( 250, 380 ] 3 0.938% 91.250% ( 380, 580 ] 1 0.312% 91.562% ( 870, 1300 ] 9 2.812% 94.375% # ( 1300, 1900 ] 9 2.812% 97.188% # ( 1900, 2900 ] 4 1.250% 98.438% ( 2900, 4400 ] 4 1.250% 99.688% ( 4400, 6600 ] 1 0.312% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 795.4500 StdDev: 1002.20 Min: 76 Median: 240.0000 Max: 3818 Percentiles: P50: 240.00 P75: 1128.00 P99: 3818.00 P99.9: 3818.00 P99.99: 3818.00 ------------------------------------------------------ ( 51, 76 ] 1 1.667% 1.667% ( 76, 110 ] 10 16.667% 18.333% ### ( 110, 170 ] 12 20.000% 38.333% #### ( 170, 250 ] 8 13.333% 51.667% ### ( 250, 380 ] 3 5.000% 56.667% # ( 380, 580 ] 6 10.000% 66.667% ## ( 580, 870 ] 2 3.333% 70.000% # ( 870, 1300 ] 5 8.333% 78.333% ## ( 1300, 1900 ] 4 6.667% 85.000% # ( 1900, 2900 ] 5 8.333% 93.333% ## ( 2900, 4400 ] 4 6.667% 100.000% # ** DB Stats ** Uptime(secs): 9.3 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 317.04 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.002 H:M:S, 10.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 315.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.404 H:M:S, 13.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/15-22:01:23 ... thread 0: (1000000,4000000) ops and (322523.1,328263.8) ops/second in (3.100553,12.185323) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/12 2.40 GB 69.2 1.8 0.0 1.8 5.5 3.7 0.0 1.5 101.7 312.0 17.96 16.65 60 0.299 1855K 1887 0.0 0.0 L1 3/3 212.40 MB 0.0 1.0 1.0 0.0 1.0 1.0 0.2 1.0 232.3 231.8 4.62 4.49 2 2.311 1090K 2458 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 248.7 248.6 1.52 1.47 2 0.760 383K 198 0.0 0.0 L3 21/0 910.33 MB 0.9 1.9 0.8 1.1 1.9 0.8 0.4 2.5 227.2 226.7 8.53 7.98 6 1.421 1967K 4058 0.0 0.0 L4 174/0 9.59 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 149.6 149.6 1.50 1.12 1 1.501 228K 0 0.0 0.0 L5 1056/0 86.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1270/15 99.82 GB 0.0 5.3 2.2 3.1 9.0 5.9 3.3 2.4 159.4 269.9 34.13 31.69 71 0.481 5524K 8601 0.0 0.0 Int 0/0 0.00 KB 0.0 5.3 2.2 3.1 9.0 5.9 3.2 2.4 159.4 269.9 34.13 31.69 71 0.481 5524K 8601 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.3 2.2 3.1 5.3 2.2 0.0 0.0 233.9 233.5 23.26 22.00 18 1.292 5524K 8601 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 347.7 10.87 9.69 53 0.205 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.4 total, 12.2 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.00 GB write, 742.04 MB/s write, 5.31 GB read, 438.26 MB/s read, 34.1 seconds Interval compaction: 9.00 GB write, 755.80 MB/s write, 5.31 GB read, 446.39 MB/s read, 34.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 11, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1006838 Average: 2.2915 StdDev: 11.70 Min: 0 Median: 1.5428 Max: 3886 Percentiles: P50: 1.54 P75: 1.93 P99: 5.76 P99.9: 11.24 P99.99: 14.53 ------------------------------------------------------ [ 0, 1 ] 146679 14.568% 14.568% ### ( 1, 2 ] 657263 65.280% 79.848% ############# ( 2, 3 ] 127104 12.624% 92.472% ### ( 3, 4 ] 41024 4.075% 96.547% # ( 4, 6 ] 28013 2.782% 99.329% # ( 6, 10 ] 5412 0.538% 99.867% ( 10, 15 ] 1376 0.137% 100.003% ( 15, 22 ] 106 0.011% 100.014% ( 22, 34 ] 7 0.001% 100.015% ( 34, 51 ] 7 0.001% 100.015% ( 51, 76 ] 3 0.000% 100.015% ( 76, 110 ] 39 0.004% 100.019% ( 110, 170 ] 34 0.003% 100.023% ( 170, 250 ] 42 0.004% 100.027% ( 250, 380 ] 26 0.003% 100.029% ( 380, 580 ] 17 0.002% 100.031% ( 580, 870 ] 15 0.001% 100.033% ( 870, 1300 ] 15 0.001% 100.034% ( 1300, 1900 ] 7 0.001% 100.035% ( 1900, 2900 ] 1 0.000% 100.035% ( 2900, 4400 ] 7 0.001% 100.036% ** Level 1 read latency histogram (micros): Count: 217178 Average: 2.8338 StdDev: 9.30 Min: 0 Median: 1.7884 Max: 1310 Percentiles: P50: 1.79 P75: 2.61 P99: 7.52 P99.9: 10.78 P99.99: 12.44 ------------------------------------------------------ [ 0, 1 ] 8404 3.870% 3.870% # ( 1, 2 ] 127079 58.514% 62.383% ############ ( 2, 3 ] 44880 20.665% 83.048% #### ( 3, 4 ] 17561 8.086% 91.134% ## ( 4, 6 ] 15944 7.341% 98.476% # ( 6, 10 ] 3001 1.382% 99.858% ( 10, 15 ] 589 0.271% 100.129% ( 15, 22 ] 47 0.022% 100.151% ( 22, 34 ] 4 0.002% 100.152% ( 51, 76 ] 3 0.001% 100.154% ( 76, 110 ] 25 0.012% 100.165% ( 110, 170 ] 25 0.012% 100.177% ( 170, 250 ] 18 0.008% 100.185% ( 250, 380 ] 17 0.008% 100.193% ( 380, 580 ] 14 0.006% 100.199% ( 580, 870 ] 11 0.005% 100.204% ( 870, 1300 ] 3 0.001% 100.206% ( 1300, 1900 ] 2 0.001% 100.207% ** Level 2 read latency histogram (micros): Count: 124185 Average: 2.4773 StdDev: 16.62 Min: 1 Median: 1.5004 Max: 3218 Percentiles: P50: 1.50 P75: 1.89 P99: 6.54 P99.9: 94.40 P99.99: 709.83 ------------------------------------------------------ [ 0, 1 ] 22480 18.102% 18.102% #### ( 1, 2 ] 79157 63.741% 81.843% ############# ( 2, 3 ] 13573 10.930% 92.773% ## ( 3, 4 ] 4500 3.624% 96.397% # ( 4, 6 ] 3089 2.487% 98.884% ( 6, 10 ] 1073 0.864% 99.748% ( 10, 15 ] 142 0.114% 99.862% ( 15, 22 ] 18 0.014% 99.877% ( 22, 34 ] 2 0.002% 99.878% ( 34, 51 ] 1 0.001% 99.879% ( 51, 76 ] 2 0.002% 99.881% ( 76, 110 ] 44 0.035% 99.916% ( 110, 170 ] 46 0.037% 99.953% ( 170, 250 ] 17 0.014% 99.967% ( 250, 380 ] 17 0.014% 99.981% ( 380, 580 ] 8 0.006% 99.987% ( 580, 870 ] 8 0.006% 99.994% ( 870, 1300 ] 5 0.004% 99.998% ( 1900, 2900 ] 2 0.002% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 239484 Average: 3.3285 StdDev: 31.03 Min: 1 Median: 1.6519 Max: 4368 Percentiles: P50: 1.65 P75: 2.17 P99: 8.67 P99.9: 167.17 P99.99: 423.51 ------------------------------------------------------ [ 0, 1 ] 21382 8.928% 8.928% ## ( 1, 2 ] 150892 63.007% 71.935% ############# ( 2, 3 ] 41951 17.517% 89.453% #### ( 3, 4 ] 11799 4.927% 94.380% # ( 4, 6 ] 8583 3.584% 97.964% # ( 6, 10 ] 3713 1.550% 99.514% ( 10, 15 ] 512 0.214% 99.728% ( 15, 22 ] 93 0.039% 99.767% ( 22, 34 ] 18 0.008% 99.774% ( 34, 51 ] 8 0.003% 99.777% ( 51, 76 ] 4 0.002% 99.779% ( 76, 110 ] 37 0.015% 99.795% ( 110, 170 ] 265 0.111% 99.905% ( 170, 250 ] 118 0.049% 99.954% ( 250, 380 ] 72 0.030% 99.985% ( 380, 580 ] 60 0.025% 100.010% ( 580, 870 ] 37 0.015% 100.025% ( 870, 1300 ] 22 0.009% 100.034% ( 1300, 1900 ] 7 0.003% 100.037% ( 1900, 2900 ] 8 0.003% 100.041% ( 2900, 4400 ] 7 0.003% 100.043% ** Level 4 read latency histogram (micros): Count: 320 Average: 173.5813 StdDev: 621.03 Min: 1 Median: 1.8264 Max: 4747 Percentiles: P50: 1.83 P75: 7.23 P99: 3575.00 P99.9: 4747.00 P99.99: 4747.00 ------------------------------------------------------ [ 0, 1 ] 60 18.750% 18.750% #### ( 1, 2 ] 121 37.812% 56.562% ######## ( 2, 3 ] 34 10.625% 67.188% ## ( 3, 4 ] 10 3.125% 70.312% # ( 4, 6 ] 11 3.438% 73.750% # ( 6, 10 ] 13 4.062% 77.812% # ( 10, 15 ] 33 10.312% 88.125% ## ( 15, 22 ] 6 1.875% 90.000% ( 110, 170 ] 1 0.312% 90.312% ( 250, 380 ] 3 0.938% 91.250% ( 380, 580 ] 1 0.312% 91.562% ( 870, 1300 ] 9 2.812% 94.375% # ( 1300, 1900 ] 9 2.812% 97.188% # ( 1900, 2900 ] 4 1.250% 98.438% ( 2900, 4400 ] 4 1.250% 99.688% ( 4400, 6600 ] 1 0.312% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 795.4500 StdDev: 1002.20 Min: 76 Median: 240.0000 Max: 3818 Percentiles: P50: 240.00 P75: 1128.00 P99: 3818.00 P99.9: 3818.00 P99.99: 3818.00 ------------------------------------------------------ ( 51, 76 ] 1 1.667% 1.667% ( 76, 110 ] 10 16.667% 18.333% ### ( 110, 170 ] 12 20.000% 38.333% #### ( 170, 250 ] 8 13.333% 51.667% ### ( 250, 380 ] 3 5.000% 56.667% # ( 380, 580 ] 6 10.000% 66.667% ## ( 580, 870 ] 2 3.333% 70.000% # ( 870, 1300 ] 5 8.333% 78.333% ## ( 1300, 1900 ] 4 6.667% 85.000% # ( 1900, 2900 ] 5 8.333% 93.333% ## ( 2900, 4400 ] 4 6.667% 100.000% # ** DB Stats ** Uptime(secs): 12.4 total, 3.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 317.13 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.446 H:M:S, 11.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 317.42 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.444 H:M:S, 14.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/15-22:01:27 ... thread 0: (1000000,5000000) ops and (226879.3,301332.8) ops/second in (4.407629,16.592952) 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 10/10 1.97 GB 0.0 2.9 0.0 2.9 7.6 4.7 0.0 1.6 117.8 308.3 25.13 23.42 78 0.322 3006K 3164 0.0 0.0 L1 20/20 1.61 GB 0.0 2.7 2.5 0.2 2.7 2.4 0.2 1.1 227.6 226.4 12.01 11.58 3 4.004 2776K 14K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 248.7 248.6 1.52 1.47 2 0.760 383K 198 0.0 0.0 L3 21/0 910.33 MB 0.9 1.9 0.8 1.1 1.9 0.8 0.4 2.5 227.2 226.7 8.53 7.98 6 1.421 1967K 4058 0.0 0.0 L4 174/0 9.59 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 149.6 149.6 1.50 1.12 1 1.501 228K 0 0.0 0.0 L5 1056/0 86.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1281/30 100.79 GB 0.0 8.0 3.6 4.4 12.7 8.3 3.3 2.7 169.1 267.0 48.68 45.57 90 0.541 8361K 22K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.0 3.6 4.4 12.7 8.3 3.2 2.7 169.1 267.0 48.68 45.57 90 0.541 8361K 22K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 8.0 3.6 4.4 8.0 3.6 0.0 0.0 235.7 235.1 34.93 33.30 23 1.519 8361K 22K 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 348.1 13.75 12.27 67 0.205 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 16.8 total, 16.6 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.69 GB write, 772.82 MB/s write, 8.04 GB read, 489.53 MB/s read, 48.7 seconds Interval compaction: 12.69 GB write, 783.34 MB/s write, 8.04 GB read, 496.20 MB/s read, 48.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 5, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 5, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 5, total-stops: 14, interval: 19 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1458030 Average: 2.3088 StdDev: 11.57 Min: 0 Median: 1.5322 Max: 3886 Percentiles: P50: 1.53 P75: 1.91 P99: 5.77 P99.9: 11.55 P99.99: 16.96 ------------------------------------------------------ [ 0, 1 ] 216125 14.823% 14.823% ### ( 1, 2 ] 963757 66.100% 80.923% ############# ( 2, 3 ] 176111 12.079% 93.002% ## ( 3, 4 ] 55021 3.774% 96.775% # ( 4, 6 ] 36747 2.520% 99.296% # ( 6, 10 ] 8239 0.565% 99.861% ( 10, 15 ] 1842 0.126% 99.987% ( 15, 22 ] 151 0.010% 99.997% ( 22, 34 ] 9 0.001% 99.998% ( 34, 51 ] 9 0.001% 99.999% ( 51, 76 ] 6 0.000% 99.999% ( 76, 110 ] 145 0.010% 100.009% ( 110, 170 ] 207 0.014% 100.023% ( 170, 250 ] 104 0.007% 100.030% ( 250, 380 ] 66 0.005% 100.035% ( 380, 580 ] 48 0.003% 100.038% ( 580, 870 ] 36 0.002% 100.041% ( 870, 1300 ] 17 0.001% 100.042% ( 1300, 1900 ] 10 0.001% 100.043% ( 1900, 2900 ] 2 0.000% 100.043% ( 2900, 4400 ] 8 0.001% 100.043% ** Level 1 read latency histogram (micros): Count: 274069 Average: 2.8386 StdDev: 10.78 Min: 0 Median: 1.7181 Max: 1310 Percentiles: P50: 1.72 P75: 2.44 P99: 7.63 P99.9: 12.50 P99.99: 14.43 ------------------------------------------------------ [ 0, 1 ] 18729 6.834% 6.834% # ( 1, 2 ] 164748 60.112% 66.946% ############ ( 2, 3 ] 50305 18.355% 85.300% #### ( 3, 4 ] 19001 6.933% 92.233% # ( 4, 6 ] 17062 6.225% 98.459% # ( 6, 10 ] 3629 1.324% 99.783% ( 10, 15 ] 641 0.234% 100.017% ( 15, 22 ] 51 0.019% 100.035% ( 22, 34 ] 4 0.001% 100.037% ( 51, 76 ] 7 0.003% 100.039% ( 76, 110 ] 92 0.034% 100.073% ( 110, 170 ] 114 0.042% 100.115% ( 170, 250 ] 40 0.015% 100.129% ( 250, 380 ] 41 0.015% 100.144% ( 380, 580 ] 32 0.012% 100.156% ( 580, 870 ] 15 0.005% 100.161% ( 870, 1300 ] 5 0.002% 100.163% ( 1300, 1900 ] 2 0.001% 100.164% ** Level 2 read latency histogram (micros): Count: 124185 Average: 2.4773 StdDev: 16.62 Min: 1 Median: 1.5004 Max: 3218 Percentiles: P50: 1.50 P75: 1.89 P99: 6.54 P99.9: 94.40 P99.99: 709.83 ------------------------------------------------------ [ 0, 1 ] 22480 18.102% 18.102% #### ( 1, 2 ] 79157 63.741% 81.843% ############# ( 2, 3 ] 13573 10.930% 92.773% ## ( 3, 4 ] 4500 3.624% 96.397% # ( 4, 6 ] 3089 2.487% 98.884% ( 6, 10 ] 1073 0.864% 99.748% ( 10, 15 ] 142 0.114% 99.862% ( 15, 22 ] 18 0.014% 99.877% ( 22, 34 ] 2 0.002% 99.878% ( 34, 51 ] 1 0.001% 99.879% ( 51, 76 ] 2 0.002% 99.881% ( 76, 110 ] 44 0.035% 99.916% ( 110, 170 ] 46 0.037% 99.953% ( 170, 250 ] 17 0.014% 99.967% ( 250, 380 ] 17 0.014% 99.981% ( 380, 580 ] 8 0.006% 99.987% ( 580, 870 ] 8 0.006% 99.994% ( 870, 1300 ] 5 0.004% 99.998% ( 1900, 2900 ] 2 0.002% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 239484 Average: 3.3285 StdDev: 31.03 Min: 1 Median: 1.6519 Max: 4368 Percentiles: P50: 1.65 P75: 2.17 P99: 8.67 P99.9: 167.17 P99.99: 423.51 ------------------------------------------------------ [ 0, 1 ] 21382 8.928% 8.928% ## ( 1, 2 ] 150892 63.007% 71.935% ############# ( 2, 3 ] 41951 17.517% 89.453% #### ( 3, 4 ] 11799 4.927% 94.380% # ( 4, 6 ] 8583 3.584% 97.964% # ( 6, 10 ] 3713 1.550% 99.514% ( 10, 15 ] 512 0.214% 99.728% ( 15, 22 ] 93 0.039% 99.767% ( 22, 34 ] 18 0.008% 99.774% ( 34, 51 ] 8 0.003% 99.777% ( 51, 76 ] 4 0.002% 99.779% ( 76, 110 ] 37 0.015% 99.795% ( 110, 170 ] 265 0.111% 99.905% ( 170, 250 ] 118 0.049% 99.954% ( 250, 380 ] 72 0.030% 99.985% ( 380, 580 ] 60 0.025% 100.010% ( 580, 870 ] 37 0.015% 100.025% ( 870, 1300 ] 22 0.009% 100.034% ( 1300, 1900 ] 7 0.003% 100.037% ( 1900, 2900 ] 8 0.003% 100.041% ( 2900, 4400 ] 7 0.003% 100.043% ** Level 4 read latency histogram (micros): Count: 320 Average: 173.5813 StdDev: 621.03 Min: 1 Median: 1.8264 Max: 4747 Percentiles: P50: 1.83 P75: 7.23 P99: 3575.00 P99.9: 4747.00 P99.99: 4747.00 ------------------------------------------------------ [ 0, 1 ] 60 18.750% 18.750% #### ( 1, 2 ] 121 37.812% 56.562% ######## ( 2, 3 ] 34 10.625% 67.188% ## ( 3, 4 ] 10 3.125% 70.312% # ( 4, 6 ] 11 3.438% 73.750% # ( 6, 10 ] 13 4.062% 77.812% # ( 10, 15 ] 33 10.312% 88.125% ## ( 15, 22 ] 6 1.875% 90.000% ( 110, 170 ] 1 0.312% 90.312% ( 250, 380 ] 3 0.938% 91.250% ( 380, 580 ] 1 0.312% 91.562% ( 870, 1300 ] 9 2.812% 94.375% # ( 1300, 1900 ] 9 2.812% 97.188% # ( 1900, 2900 ] 4 1.250% 98.438% ( 2900, 4400 ] 4 1.250% 99.688% ( 4400, 6600 ] 1 0.312% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 795.4500 StdDev: 1002.20 Min: 76 Median: 240.0000 Max: 3818 Percentiles: P50: 240.00 P75: 1128.00 P99: 3818.00 P99.9: 3818.00 P99.99: 3818.00 ------------------------------------------------------ ( 51, 76 ] 1 1.667% 1.667% ( 76, 110 ] 10 16.667% 18.333% ### ( 110, 170 ] 12 20.000% 38.333% #### ( 170, 250 ] 8 13.333% 51.667% ### ( 250, 380 ] 3 5.000% 56.667% # ( 380, 580 ] 6 10.000% 66.667% ## ( 580, 870 ] 2 3.333% 70.000% # ( 870, 1300 ] 5 8.333% 78.333% ## ( 1300, 1900 ] 4 6.667% 85.000% # ( 1900, 2900 ] 5 8.333% 93.333% ## ( 2900, 4400 ] 4 6.667% 100.000% # ** DB Stats ** Uptime(secs): 16.8 total, 4.4 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 292.55 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:3.167 H:M:S, 18.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 223.29 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.721 H:M:S, 39.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/15-22:01:30 ... thread 0: (1000000,6000000) ops and (321521.2,304519.6) ops/second in (3.110215,19.703167) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/14 2.95 GB 69.2 3.4 0.0 3.4 9.0 5.7 0.0 1.6 115.7 309.1 29.94 27.89 94 0.319 3518K 3645 0.0 0.0 L1 20/20 1.61 GB 0.0 2.7 2.5 0.2 2.7 2.4 0.2 1.1 227.6 226.4 12.01 11.58 3 4.004 2776K 14K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 248.7 248.6 1.52 1.47 2 0.760 383K 198 0.0 0.0 L3 21/0 910.33 MB 0.9 1.9 0.8 1.1 1.9 0.8 0.4 2.5 227.2 226.7 8.53 7.98 6 1.421 1967K 4058 0.0 0.0 L4 174/0 9.59 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 149.6 149.6 1.50 1.12 1 1.501 228K 0 0.0 0.0 L5 1056/0 86.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1289/34 101.77 GB 0.0 8.5 3.6 4.9 14.2 9.3 3.3 2.5 163.3 271.2 53.50 50.03 106 0.505 8873K 22K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.5 3.6 4.9 14.2 9.3 3.2 2.5 163.3 271.2 53.50 50.03 106 0.505 8873K 22K 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.5 3.6 4.9 8.5 3.6 0.0 0.0 237.4 236.7 36.82 35.15 25 1.473 8873K 22K 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 347.3 16.69 14.89 81 0.206 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 19.9 total, 19.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: 14.17 GB write, 728.05 MB/s write, 8.53 GB read, 438.42 MB/s read, 53.5 seconds Interval compaction: 14.17 GB write, 736.40 MB/s write, 8.53 GB read, 443.45 MB/s read, 53.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 5, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 5, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 5, total-stops: 17, interval: 22 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1706825 Average: 2.2893 StdDev: 11.56 Min: 0 Median: 1.5246 Max: 3886 Percentiles: P50: 1.52 P75: 1.90 P99: 5.74 P99.9: 11.44 P99.99: 15.85 ------------------------------------------------------ [ 0, 1 ] 259622 15.211% 15.211% ### ( 1, 2 ] 1131941 66.319% 81.529% ############# ( 2, 3 ] 201157 11.785% 93.315% ## ( 3, 4 ] 61959 3.630% 96.945% # ( 4, 6 ] 40361 2.365% 99.310% ( 6, 10 ] 9470 0.555% 99.864% ( 10, 15 ] 2125 0.125% 99.989% ( 15, 22 ] 175 0.010% 99.999% ( 22, 34 ] 12 0.001% 100.000% ( 34, 51 ] 10 0.001% 100.000% ( 51, 76 ] 7 0.000% 100.001% ( 76, 110 ] 155 0.009% 100.010% ( 110, 170 ] 215 0.013% 100.022% ( 170, 250 ] 113 0.007% 100.029% ( 250, 380 ] 72 0.004% 100.033% ( 380, 580 ] 51 0.003% 100.036% ( 580, 870 ] 42 0.002% 100.039% ( 870, 1300 ] 20 0.001% 100.040% ( 1300, 1900 ] 14 0.001% 100.041% ( 1900, 2900 ] 4 0.000% 100.041% ( 2900, 4400 ] 8 0.000% 100.041% ** Level 1 read latency histogram (micros): Count: 349282 Average: 2.7839 StdDev: 11.14 Min: 0 Median: 1.6610 Max: 1310 Percentiles: P50: 1.66 P75: 2.26 P99: 7.70 P99.9: 13.78 P99.99: 89.00 ------------------------------------------------------ [ 0, 1 ] 33030 9.457% 9.457% ## ( 1, 2 ] 214246 61.339% 70.796% ############ ( 2, 3 ] 57565 16.481% 87.276% ### ( 3, 4 ] 20779 5.949% 93.226% # ( 4, 6 ] 18239 5.222% 98.447% # ( 6, 10 ] 4529 1.297% 99.744% ( 10, 15 ] 721 0.206% 99.950% ( 15, 22 ] 61 0.017% 99.968% ( 22, 34 ] 5 0.001% 99.969% ( 51, 76 ] 9 0.003% 99.972% ( 76, 110 ] 165 0.047% 100.019% ( 110, 170 ] 187 0.054% 100.073% ( 170, 250 ] 66 0.019% 100.092% ( 250, 380 ] 55 0.016% 100.107% ( 380, 580 ] 48 0.014% 100.121% ( 580, 870 ] 16 0.005% 100.126% ( 870, 1300 ] 8 0.002% 100.128% ( 1300, 1900 ] 2 0.001% 100.129% ** Level 2 read latency histogram (micros): Count: 124185 Average: 2.4773 StdDev: 16.62 Min: 1 Median: 1.5004 Max: 3218 Percentiles: P50: 1.50 P75: 1.89 P99: 6.54 P99.9: 94.40 P99.99: 709.83 ------------------------------------------------------ [ 0, 1 ] 22480 18.102% 18.102% #### ( 1, 2 ] 79157 63.741% 81.843% ############# ( 2, 3 ] 13573 10.930% 92.773% ## ( 3, 4 ] 4500 3.624% 96.397% # ( 4, 6 ] 3089 2.487% 98.884% ( 6, 10 ] 1073 0.864% 99.748% ( 10, 15 ] 142 0.114% 99.862% ( 15, 22 ] 18 0.014% 99.877% ( 22, 34 ] 2 0.002% 99.878% ( 34, 51 ] 1 0.001% 99.879% ( 51, 76 ] 2 0.002% 99.881% ( 76, 110 ] 44 0.035% 99.916% ( 110, 170 ] 46 0.037% 99.953% ( 170, 250 ] 17 0.014% 99.967% ( 250, 380 ] 17 0.014% 99.981% ( 380, 580 ] 8 0.006% 99.987% ( 580, 870 ] 8 0.006% 99.994% ( 870, 1300 ] 5 0.004% 99.998% ( 1900, 2900 ] 2 0.002% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 239484 Average: 3.3285 StdDev: 31.03 Min: 1 Median: 1.6519 Max: 4368 Percentiles: P50: 1.65 P75: 2.17 P99: 8.67 P99.9: 167.17 P99.99: 423.51 ------------------------------------------------------ [ 0, 1 ] 21382 8.928% 8.928% ## ( 1, 2 ] 150892 63.007% 71.935% ############# ( 2, 3 ] 41951 17.517% 89.453% #### ( 3, 4 ] 11799 4.927% 94.380% # ( 4, 6 ] 8583 3.584% 97.964% # ( 6, 10 ] 3713 1.550% 99.514% ( 10, 15 ] 512 0.214% 99.728% ( 15, 22 ] 93 0.039% 99.767% ( 22, 34 ] 18 0.008% 99.774% ( 34, 51 ] 8 0.003% 99.777% ( 51, 76 ] 4 0.002% 99.779% ( 76, 110 ] 37 0.015% 99.795% ( 110, 170 ] 265 0.111% 99.905% ( 170, 250 ] 118 0.049% 99.954% ( 250, 380 ] 72 0.030% 99.985% ( 380, 580 ] 60 0.025% 100.010% ( 580, 870 ] 37 0.015% 100.025% ( 870, 1300 ] 22 0.009% 100.034% ( 1300, 1900 ] 7 0.003% 100.037% ( 1900, 2900 ] 8 0.003% 100.041% ( 2900, 4400 ] 7 0.003% 100.043% ** Level 4 read latency histogram (micros): Count: 320 Average: 173.5813 StdDev: 621.03 Min: 1 Median: 1.8264 Max: 4747 Percentiles: P50: 1.83 P75: 7.23 P99: 3575.00 P99.9: 4747.00 P99.99: 4747.00 ------------------------------------------------------ [ 0, 1 ] 60 18.750% 18.750% #### ( 1, 2 ] 121 37.812% 56.562% ######## ( 2, 3 ] 34 10.625% 67.188% ## ( 3, 4 ] 10 3.125% 70.312% # ( 4, 6 ] 11 3.438% 73.750% # ( 6, 10 ] 13 4.062% 77.812% # ( 10, 15 ] 33 10.312% 88.125% ## ( 15, 22 ] 6 1.875% 90.000% ( 110, 170 ] 1 0.312% 90.312% ( 250, 380 ] 3 0.938% 91.250% ( 380, 580 ] 1 0.312% 91.562% ( 870, 1300 ] 9 2.812% 94.375% # ( 1300, 1900 ] 9 2.812% 97.188% # ( 1900, 2900 ] 4 1.250% 98.438% ( 2900, 4400 ] 4 1.250% 99.688% ( 4400, 6600 ] 1 0.312% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 795.4500 StdDev: 1002.20 Min: 76 Median: 240.0000 Max: 3818 Percentiles: P50: 240.00 P75: 1128.00 P99: 3818.00 P99.9: 3818.00 P99.99: 3818.00 ------------------------------------------------------ ( 51, 76 ] 1 1.667% 1.667% ( 76, 110 ] 10 16.667% 18.333% ### ( 110, 170 ] 12 20.000% 38.333% #### ( 170, 250 ] 8 13.333% 51.667% ### ( 250, 380 ] 3 5.000% 56.667% # ( 380, 580 ] 6 10.000% 66.667% ## ( 580, 870 ] 2 3.333% 70.000% # ( 870, 1300 ] 5 8.333% 78.333% ## ( 1300, 1900 ] 4 6.667% 85.000% # ( 1900, 2900 ] 5 8.333% 93.333% ## ( 2900, 4400 ] 4 6.667% 100.000% # ** DB Stats ** Uptime(secs): 19.9 total, 3.1 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 296.27 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:3.607 H:M:S, 18.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 316.43 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.440 H:M:S, 14.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/15-22:01:38 ... thread 0: (1000000,7000000) ops and (134240.4,257803.3) ops/second in (7.449322,27.152489) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/14 3.93 GB 176.0 5.2 0.0 5.2 11.9 6.6 0.0 1.8 134.4 305.1 39.83 37.36 115 0.346 5436K 7148 0.0 0.0 L1 20/20 1.61 GB 0.0 2.7 2.5 0.2 2.7 2.4 0.2 1.1 227.6 226.4 12.01 11.58 3 4.004 2776K 14K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 248.7 248.6 1.52 1.47 2 0.760 383K 198 0.0 0.0 L3 21/0 910.33 MB 0.9 1.9 0.8 1.1 1.9 0.8 0.4 2.5 227.2 226.7 8.53 7.98 6 1.421 1967K 4058 0.0 0.0 L4 174/0 9.59 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 149.6 149.6 1.50 1.12 1 1.501 228K 0 0.0 0.0 L5 1056/0 86.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1290/34 102.75 GB 0.0 10.4 3.6 6.7 17.0 10.2 3.3 2.6 167.7 274.6 63.39 59.50 127 0.499 10M 26K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.4 3.6 6.7 17.0 10.2 3.2 2.6 167.7 274.6 63.39 59.50 127 0.499 10M 26K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 10.4 3.6 6.7 10.4 3.6 0.0 0.0 242.9 242.3 43.75 41.98 30 1.458 10M 26K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.6 6.6 0.0 0.0 0.0 346.5 19.63 17.52 97 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): 27.4 total, 27.2 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: 17.00 GB write, 635.66 MB/s write, 10.38 GB read, 388.14 MB/s read, 63.4 seconds Interval compaction: 17.00 GB write, 640.95 MB/s write, 10.38 GB read, 391.38 MB/s read, 63.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 14, total-stops: 17, interval: 31 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2419998 Average: 2.2560 StdDev: 10.59 Min: 0 Median: 1.5118 Max: 3886 Percentiles: P50: 1.51 P75: 1.88 P99: 5.67 P99.9: 10.75 P99.99: 17.43 ------------------------------------------------------ [ 0, 1 ] 380082 15.706% 15.706% ### ( 1, 2 ] 1621477 67.003% 82.709% ############# ( 2, 3 ] 268229 11.084% 93.793% ## ( 3, 4 ] 83455 3.449% 97.242% # ( 4, 6 ] 50914 2.104% 99.345% ( 6, 10 ] 13050 0.539% 99.885% ( 10, 15 ] 2472 0.102% 99.987% ( 15, 22 ] 222 0.009% 99.996% ( 22, 34 ] 13 0.001% 99.997% ( 34, 51 ] 12 0.000% 99.997% ( 51, 76 ] 11 0.000% 99.997% ( 76, 110 ] 277 0.011% 100.009% ( 110, 170 ] 327 0.014% 100.022% ( 170, 250 ] 151 0.006% 100.029% ( 250, 380 ] 94 0.004% 100.033% ( 380, 580 ] 73 0.003% 100.036% ( 580, 870 ] 59 0.002% 100.038% ( 870, 1300 ] 27 0.001% 100.039% ( 1300, 1900 ] 15 0.001% 100.040% ( 1900, 2900 ] 7 0.000% 100.040% ( 2900, 4400 ] 8 0.000% 100.040% ** Level 1 read latency histogram (micros): Count: 527661 Average: 2.7254 StdDev: 10.98 Min: 0 Median: 1.6045 Max: 1310 Percentiles: P50: 1.60 P75: 2.00 P99: 7.77 P99.9: 85.88 P99.99: 136.29 ------------------------------------------------------ [ 0, 1 ] 60369 11.441% 11.441% ## ( 1, 2 ] 336563 63.784% 75.225% ############# ( 2, 3 ] 74973 14.209% 89.433% ### ( 3, 4 ] 25994 4.926% 94.360% # ( 4, 6 ] 21502 4.075% 98.435% # ( 6, 10 ] 6729 1.275% 99.710% ( 10, 15 ] 768 0.146% 99.855% ( 15, 22 ] 74 0.014% 99.869% ( 22, 34 ] 5 0.001% 99.870% ( 34, 51 ] 1 0.000% 99.871% ( 51, 76 ] 24 0.005% 99.875% ( 76, 110 ] 452 0.086% 99.961% ( 110, 170 ] 352 0.067% 100.027% ( 170, 250 ] 109 0.021% 100.048% ( 250, 380 ] 81 0.015% 100.063% ( 380, 580 ] 79 0.015% 100.078% ( 580, 870 ] 25 0.005% 100.083% ( 870, 1300 ] 8 0.002% 100.085% ( 1300, 1900 ] 2 0.000% 100.085% ** Level 2 read latency histogram (micros): Count: 124185 Average: 2.4773 StdDev: 16.62 Min: 1 Median: 1.5004 Max: 3218 Percentiles: P50: 1.50 P75: 1.89 P99: 6.54 P99.9: 94.40 P99.99: 709.83 ------------------------------------------------------ [ 0, 1 ] 22480 18.102% 18.102% #### ( 1, 2 ] 79157 63.741% 81.843% ############# ( 2, 3 ] 13573 10.930% 92.773% ## ( 3, 4 ] 4500 3.624% 96.397% # ( 4, 6 ] 3089 2.487% 98.884% ( 6, 10 ] 1073 0.864% 99.748% ( 10, 15 ] 142 0.114% 99.862% ( 15, 22 ] 18 0.014% 99.877% ( 22, 34 ] 2 0.002% 99.878% ( 34, 51 ] 1 0.001% 99.879% ( 51, 76 ] 2 0.002% 99.881% ( 76, 110 ] 44 0.035% 99.916% ( 110, 170 ] 46 0.037% 99.953% ( 170, 250 ] 17 0.014% 99.967% ( 250, 380 ] 17 0.014% 99.981% ( 380, 580 ] 8 0.006% 99.987% ( 580, 870 ] 8 0.006% 99.994% ( 870, 1300 ] 5 0.004% 99.998% ( 1900, 2900 ] 2 0.002% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 239484 Average: 3.3285 StdDev: 31.03 Min: 1 Median: 1.6519 Max: 4368 Percentiles: P50: 1.65 P75: 2.17 P99: 8.67 P99.9: 167.17 P99.99: 423.51 ------------------------------------------------------ [ 0, 1 ] 21382 8.928% 8.928% ## ( 1, 2 ] 150892 63.007% 71.935% ############# ( 2, 3 ] 41951 17.517% 89.453% #### ( 3, 4 ] 11799 4.927% 94.380% # ( 4, 6 ] 8583 3.584% 97.964% # ( 6, 10 ] 3713 1.550% 99.514% ( 10, 15 ] 512 0.214% 99.728% ( 15, 22 ] 93 0.039% 99.767% ( 22, 34 ] 18 0.008% 99.774% ( 34, 51 ] 8 0.003% 99.777% ( 51, 76 ] 4 0.002% 99.779% ( 76, 110 ] 37 0.015% 99.795% ( 110, 170 ] 265 0.111% 99.905% ( 170, 250 ] 118 0.049% 99.954% ( 250, 380 ] 72 0.030% 99.985% ( 380, 580 ] 60 0.025% 100.010% ( 580, 870 ] 37 0.015% 100.025% ( 870, 1300 ] 22 0.009% 100.034% ( 1300, 1900 ] 7 0.003% 100.037% ( 1900, 2900 ] 8 0.003% 100.041% ( 2900, 4400 ] 7 0.003% 100.043% ** Level 4 read latency histogram (micros): Count: 320 Average: 173.5813 StdDev: 621.03 Min: 1 Median: 1.8264 Max: 4747 Percentiles: P50: 1.83 P75: 7.23 P99: 3575.00 P99.9: 4747.00 P99.99: 4747.00 ------------------------------------------------------ [ 0, 1 ] 60 18.750% 18.750% #### ( 1, 2 ] 121 37.812% 56.562% ######## ( 2, 3 ] 34 10.625% 67.188% ## ( 3, 4 ] 10 3.125% 70.312% # ( 4, 6 ] 11 3.438% 73.750% # ( 6, 10 ] 13 4.062% 77.812% # ( 10, 15 ] 33 10.312% 88.125% ## ( 15, 22 ] 6 1.875% 90.000% ( 110, 170 ] 1 0.312% 90.312% ( 250, 380 ] 3 0.938% 91.250% ( 380, 580 ] 1 0.312% 91.562% ( 870, 1300 ] 9 2.812% 94.375% # ( 1300, 1900 ] 9 2.812% 97.188% # ( 1900, 2900 ] 4 1.250% 98.438% ( 2900, 4400 ] 4 1.250% 99.688% ( 4400, 6600 ] 1 0.312% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 795.4500 StdDev: 1002.20 Min: 76 Median: 240.0000 Max: 3818 Percentiles: P50: 240.00 P75: 1128.00 P99: 3818.00 P99.9: 3818.00 P99.99: 3818.00 ------------------------------------------------------ ( 51, 76 ] 1 1.667% 1.667% ( 76, 110 ] 10 16.667% 18.333% ### ( 110, 170 ] 12 20.000% 38.333% #### ( 170, 250 ] 8 13.333% 51.667% ### ( 250, 380 ] 3 5.000% 56.667% # ( 380, 580 ] 6 10.000% 66.667% ## ( 580, 870 ] 2 3.333% 70.000% # ( 870, 1300 ] 5 8.333% 78.333% ## ( 1300, 1900 ] 4 6.667% 85.000% # ( 1900, 2900 ] 5 8.333% 93.333% ## ( 2900, 4400 ] 4 6.667% 100.000% # ** DB Stats ** Uptime(secs): 27.4 total, 7.4 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 251.61 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.133 H:M:S, 29.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 132.12 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:4.526 H:M:S, 60.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/15-22:01:47 ... thread 0: (1000000,8000000) ops and (106866.1,219118.1) ops/second in (9.357503,36.509992) 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/12 2.89 GB 12.6 6.0 0.0 6.0 13.5 7.6 0.0 1.8 132.9 301.3 45.96 42.58 132 0.348 6204K 7909 0.0 0.0 L1 23/23 2.27 GB 0.0 6.2 4.4 1.8 6.2 4.4 0.2 1.4 227.0 224.6 28.18 27.03 4 7.045 6494K 67K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 2.2 2.0 248.7 248.6 1.52 1.47 2 0.760 383K 198 0.0 0.0 L3 21/0 982.07 MB 1.0 3.6 2.0 1.5 3.6 2.0 0.4 1.8 185.6 184.7 19.70 15.95 13 1.515 3714K 18K 0.0 0.0 L4 176/0 9.40 GB 1.0 1.4 1.4 0.1 1.4 1.4 0.8 1.0 136.5 136.2 10.72 6.94 18 0.595 1481K 2898 0.0 0.0 L5 1072/0 88.09 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1306/35 103.61 GB 0.0 17.6 8.0 9.6 25.1 15.5 5.9 3.3 169.7 241.8 106.08 93.97 169 0.628 18M 96K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.6 8.0 9.6 25.1 15.5 5.8 3.3 169.7 241.8 106.08 93.97 169 0.628 18M 96K 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 17.6 8.0 9.6 17.5 7.9 0.0 0.0 216.6 215.4 83.13 74.00 58 1.433 18M 96K 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 337.6 22.95 19.97 111 0.207 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): 36.7 total, 36.5 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: 25.05 GB write, 698.33 MB/s write, 17.58 GB read, 490.05 MB/s read, 106.1 seconds Interval compaction: 25.05 GB write, 702.65 MB/s write, 17.58 GB read, 493.09 MB/s read, 106.1 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: 31, pending-compaction-bytes-delays: 8, pending-compaction-bytes-stops: 0, total-delays: 28, total-stops: 31, interval: 59 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2952123 Average: 2.4101 StdDev: 17.76 Min: 0 Median: 1.5133 Max: 8827 Percentiles: P50: 1.51 P75: 1.89 P99: 5.81 P99.9: 12.70 P99.99: 137.41 ------------------------------------------------------ [ 0, 1 ] 471890 15.985% 15.985% ### ( 1, 2 ] 1956262 66.266% 82.251% ############# ( 2, 3 ] 326951 11.075% 93.326% ## ( 3, 4 ] 104599 3.543% 96.869% # ( 4, 6 ] 69317 2.348% 99.217% ( 6, 10 ] 18383 0.623% 99.840% ( 10, 15 ] 3279 0.111% 99.951% ( 15, 22 ] 319 0.011% 99.962% ( 22, 34 ] 20 0.001% 99.963% ( 34, 51 ] 15 0.001% 99.963% ( 51, 76 ] 19 0.001% 99.964% ( 76, 110 ] 513 0.017% 99.981% ( 110, 170 ] 573 0.019% 100.001% ( 170, 250 ] 266 0.009% 100.010% ( 250, 380 ] 231 0.008% 100.017% ( 380, 580 ] 221 0.007% 100.025% ( 580, 870 ] 172 0.006% 100.031% ( 870, 1300 ] 101 0.003% 100.034% ( 1300, 1900 ] 42 0.001% 100.036% ( 1900, 2900 ] 21 0.001% 100.036% ( 2900, 4400 ] 17 0.001% 100.037% ( 4400, 6600 ] 3 0.000% 100.037% ( 6600, 9900 ] 2 0.000% 100.037% ** Level 1 read latency histogram (micros): Count: 1013714 Average: 3.4775 StdDev: 32.95 Min: 0 Median: 1.6895 Max: 7220 Percentiles: P50: 1.69 P75: 2.43 P99: 8.54 P99.9: 14.81 P99.99: 96.27 ------------------------------------------------------ [ 0, 1 ] 104730 10.331% 10.331% ## ( 1, 2 ] 583249 57.536% 67.867% ############ ( 2, 3 ] 166231 16.398% 84.265% ### ( 3, 4 ] 69522 6.858% 91.124% # ( 4, 6 ] 68228 6.730% 97.854% # ( 6, 10 ] 18307 1.806% 99.660% ( 10, 15 ] 2527 0.249% 99.909% ( 15, 22 ] 279 0.028% 99.937% ( 22, 34 ] 27 0.003% 99.939% ( 34, 51 ] 15 0.001% 99.941% ( 51, 76 ] 119 0.012% 99.953% ( 76, 110 ] 635 0.063% 100.015% ( 110, 170 ] 616 0.061% 100.076% ( 170, 250 ] 212 0.021% 100.097% ( 250, 380 ] 225 0.022% 100.119% ( 380, 580 ] 259 0.026% 100.145% ( 580, 870 ] 188 0.019% 100.163% ( 870, 1300 ] 131 0.013% 100.176% ( 1300, 1900 ] 71 0.007% 100.183% ( 1900, 2900 ] 41 0.004% 100.187% ( 2900, 4400 ] 21 0.002% 100.189% ( 4400, 6600 ] 1 0.000% 100.189% ( 6600, 9900 ] 1 0.000% 100.190% ** Level 2 read latency histogram (micros): Count: 124185 Average: 2.4773 StdDev: 16.62 Min: 1 Median: 1.5004 Max: 3218 Percentiles: P50: 1.50 P75: 1.89 P99: 6.54 P99.9: 94.40 P99.99: 709.83 ------------------------------------------------------ [ 0, 1 ] 22480 18.102% 18.102% #### ( 1, 2 ] 79157 63.741% 81.843% ############# ( 2, 3 ] 13573 10.930% 92.773% ## ( 3, 4 ] 4500 3.624% 96.397% # ( 4, 6 ] 3089 2.487% 98.884% ( 6, 10 ] 1073 0.864% 99.748% ( 10, 15 ] 142 0.114% 99.862% ( 15, 22 ] 18 0.014% 99.877% ( 22, 34 ] 2 0.002% 99.878% ( 34, 51 ] 1 0.001% 99.879% ( 51, 76 ] 2 0.002% 99.881% ( 76, 110 ] 44 0.035% 99.916% ( 110, 170 ] 46 0.037% 99.953% ( 170, 250 ] 17 0.014% 99.967% ( 250, 380 ] 17 0.014% 99.981% ( 380, 580 ] 8 0.006% 99.987% ( 580, 870 ] 8 0.006% 99.994% ( 870, 1300 ] 5 0.004% 99.998% ( 1900, 2900 ] 2 0.002% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 641981 Average: 3.8224 StdDev: 43.99 Min: 1 Median: 1.8963 Max: 8017 Percentiles: P50: 1.90 P75: 2.84 P99: 8.54 P99.9: 12.51 P99.99: 13.67 ------------------------------------------------------ [ 0, 1 ] 24762 3.857% 3.857% # ( 1, 2 ] 330517 51.484% 55.341% ########## ( 2, 3 ] 150033 23.370% 78.711% ##### ( 3, 4 ] 61575 9.591% 88.303% ## ( 4, 6 ] 60838 9.477% 97.779% ## ( 6, 10 ] 12360 1.925% 99.705% ( 10, 15 ] 2494 0.388% 100.093% ( 15, 22 ] 277 0.043% 100.136% ( 22, 34 ] 29 0.005% 100.141% ( 34, 51 ] 10 0.002% 100.142% ( 51, 76 ] 21 0.003% 100.146% ( 76, 110 ] 54 0.008% 100.154% ( 110, 170 ] 331 0.052% 100.206% ( 170, 250 ] 271 0.042% 100.248% ( 250, 380 ] 206 0.032% 100.280% ( 380, 580 ] 161 0.025% 100.305% ( 580, 870 ] 83 0.013% 100.318% ( 870, 1300 ] 44 0.007% 100.325% ( 1300, 1900 ] 13 0.002% 100.327% ( 1900, 2900 ] 12 0.002% 100.329% ( 2900, 4400 ] 56 0.009% 100.337% ( 4400, 6600 ] 1 0.000% 100.338% ( 6600, 9900 ] 2 0.000% 100.338% ** Level 4 read latency histogram (micros): Count: 17493 Average: 58.6230 StdDev: 368.05 Min: 0 Median: 2.1224 Max: 14174 Percentiles: P50: 2.12 P75: 3.37 P99: 1205.08 P99.9: 4381.96 P99.99: 6737.88 ------------------------------------------------------ [ 0, 1 ] 317 1.812% 1.812% ( 1, 2 ] 7929 45.327% 47.139% ######### ( 2, 3 ] 4090 23.381% 70.520% ##### ( 3, 4 ] 2132 12.188% 82.707% ## ( 4, 6 ] 1321 7.552% 90.259% ## ( 6, 10 ] 413 2.361% 92.620% ( 10, 15 ] 110 0.629% 93.249% ( 15, 22 ] 22 0.126% 93.374% ( 22, 34 ] 3 0.017% 93.392% ( 34, 51 ] 3 0.017% 93.409% ( 76, 110 ] 25 0.143% 93.552% ( 110, 170 ] 86 0.492% 94.043% ( 170, 250 ] 127 0.726% 94.769% ( 250, 380 ] 196 1.120% 95.890% ( 380, 580 ] 233 1.332% 97.222% ( 580, 870 ] 216 1.235% 98.457% ( 870, 1300 ] 122 0.697% 99.154% ( 1300, 1900 ] 44 0.252% 99.405% ( 1900, 2900 ] 46 0.263% 99.668% ( 2900, 4400 ] 41 0.234% 99.903% ( 4400, 6600 ] 15 0.086% 99.989% ( 6600, 9900 ] 6 0.034% 100.023% ( 9900, 14000 ] 2 0.011% 100.034% ( 14000, 22000 ] 1 0.006% 100.040% ** Level 5 read latency histogram (micros): Count: 140 Average: 1142.1000 StdDev: 1411.20 Min: 76 Median: 532.9412 Max: 7591 Percentiles: P50: 532.94 P75: 1623.08 P99: 7590.00 P99.9: 7591.00 P99.99: 7591.00 ------------------------------------------------------ ( 51, 76 ] 1 0.714% 0.714% ( 76, 110 ] 15 10.714% 11.429% ## ( 110, 170 ] 19 13.571% 25.000% ### ( 170, 250 ] 12 8.571% 33.571% ## ( 250, 380 ] 10 7.143% 40.714% # ( 380, 580 ] 17 12.143% 52.857% ## ( 580, 870 ] 14 10.000% 62.857% ## ( 870, 1300 ] 10 7.143% 70.000% # ( 1300, 1900 ] 13 9.286% 79.286% ## ( 1900, 2900 ] 14 10.000% 89.286% ## ( 2900, 4400 ] 11 7.857% 97.143% ## ( 4400, 6600 ] 2 1.429% 98.571% ( 6600, 9900 ] 2 1.429% 100.000% ** DB Stats ** Uptime(secs): 36.7 total, 9.4 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 214.31 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:14.551 H:M:S, 39.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 105.18 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.417 H:M:S, 68.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/15-22:02:08 ... thread 0: (1000000,9000000) ops and (46995.0,155739.4) ops/second in (21.278849,57.788841) 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 2/2 1.47 GB 0.0 8.8 0.0 8.8 17.4 8.6 0.0 2.0 148.7 294.0 60.57 56.21 153 0.396 9144K 18K 0.0 0.0 L1 10/10 1.20 GB 0.0 11.0 6.9 4.1 10.8 6.7 0.2 1.6 220.1 217.1 51.03 47.49 5 10.206 9936K 67K 0.0 0.0 L2 20/15 2.33 GB 6.1 0.4 0.2 0.2 0.4 0.2 5.6 2.0 248.7 248.6 1.52 1.47 2 0.760 383K 198 0.0 0.0 L3 36/13 2.06 GB 1.2 4.6 2.7 1.8 4.6 2.7 0.8 1.7 173.7 172.7 27.04 20.83 18 1.502 4769K 27K 0.0 0.0 L4 176/0 9.40 GB 1.0 1.4 1.4 0.1 1.4 1.4 0.8 1.0 136.5 136.2 10.72 6.94 18 0.595 1481K 2898 0.0 0.0 L5 1072/0 88.09 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1316/40 104.55 GB 0.0 26.1 11.2 15.0 34.6 19.6 9.8 4.0 177.5 234.6 150.87 132.94 196 0.770 25M 115K 0.0 0.0 Int 0/0 0.00 KB 0.0 26.1 11.2 15.0 34.6 19.6 9.7 4.0 177.5 234.6 150.87 132.94 196 0.770 25M 115K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 26.1 11.2 15.0 26.0 11.0 0.0 0.0 214.5 212.9 124.80 110.19 70 1.783 25M 115K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 338.3 26.07 22.75 126 0.207 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): 58.0 total, 57.8 interval Flush(GB): cumulative 8.613, interval 8.613 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 34.56 GB write, 610.05 MB/s write, 26.15 GB read, 461.50 MB/s read, 150.9 seconds Interval compaction: 34.56 GB write, 612.43 MB/s write, 26.15 GB read, 463.31 MB/s read, 150.9 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: 34, pending-compaction-bytes-delays: 27, pending-compaction-bytes-stops: 0, total-delays: 47, total-stops: 34, interval: 81 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4208667 Average: 2.7480 StdDev: 23.90 Min: 0 Median: 1.5118 Max: 8827 Percentiles: P50: 1.51 P75: 1.89 P99: 6.45 P99.9: 128.27 P99.99: 297.02 ------------------------------------------------------ [ 0, 1 ] 687960 16.346% 16.346% ### ( 1, 2 ] 2767284 65.752% 82.098% ############# ( 2, 3 ] 458395 10.892% 92.990% ## ( 3, 4 ] 145349 3.454% 96.444% # ( 4, 6 ] 104148 2.475% 98.918% ( 6, 10 ] 30293 0.720% 99.638% ( 10, 15 ] 4912 0.117% 99.755% ( 15, 22 ] 582 0.014% 99.768% ( 22, 34 ] 34 0.001% 99.769% ( 34, 51 ] 25 0.001% 99.770% ( 51, 76 ] 52 0.001% 99.771% ( 76, 110 ] 4290 0.102% 99.873% ( 110, 170 ] 3725 0.089% 99.962% ( 170, 250 ] 919 0.022% 99.983% ( 250, 380 ] 769 0.018% 100.002% ( 380, 580 ] 599 0.014% 100.016% ( 580, 870 ] 338 0.008% 100.024% ( 870, 1300 ] 170 0.004% 100.028% ( 1300, 1900 ] 69 0.002% 100.030% ( 1900, 2900 ] 49 0.001% 100.031% ( 2900, 4400 ] 52 0.001% 100.032% ( 4400, 6600 ] 16 0.000% 100.032% ( 6600, 9900 ] 4 0.000% 100.032% ** Level 1 read latency histogram (micros): Count: 2041996 Average: 4.0399 StdDev: 53.04 Min: 0 Median: 1.6703 Max: 9427 Percentiles: P50: 1.67 P75: 2.42 P99: 8.65 P99.9: 85.66 P99.99: 132.63 ------------------------------------------------------ [ 0, 1 ] 252595 12.370% 12.370% ## ( 1, 2 ] 1146287 56.136% 68.506% ########### ( 2, 3 ] 318488 15.597% 84.103% ### ( 3, 4 ] 140958 6.903% 91.005% # ( 4, 6 ] 140084 6.860% 97.866% # ( 6, 10 ] 35012 1.715% 99.580% ( 10, 15 ] 5081 0.249% 99.829% ( 15, 22 ] 637 0.031% 99.860% ( 22, 34 ] 48 0.002% 99.863% ( 34, 51 ] 20 0.001% 99.864% ( 51, 76 ] 285 0.014% 99.878% ( 76, 110 ] 1623 0.079% 99.957% ( 110, 170 ] 1792 0.088% 100.045% ( 170, 250 ] 376 0.018% 100.063% ( 250, 380 ] 432 0.021% 100.084% ( 380, 580 ] 532 0.026% 100.110% ( 580, 870 ] 586 0.029% 100.139% ( 870, 1300 ] 402 0.020% 100.159% ( 1300, 1900 ] 200 0.010% 100.169% ( 1900, 2900 ] 137 0.007% 100.175% ( 2900, 4400 ] 149 0.007% 100.183% ( 4400, 6600 ] 31 0.002% 100.184% ( 6600, 9900 ] 14 0.001% 100.185% ** Level 2 read latency histogram (micros): Count: 124185 Average: 2.4773 StdDev: 16.62 Min: 1 Median: 1.5004 Max: 3218 Percentiles: P50: 1.50 P75: 1.89 P99: 6.54 P99.9: 94.40 P99.99: 709.83 ------------------------------------------------------ [ 0, 1 ] 22480 18.102% 18.102% #### ( 1, 2 ] 79157 63.741% 81.843% ############# ( 2, 3 ] 13573 10.930% 92.773% ## ( 3, 4 ] 4500 3.624% 96.397% # ( 4, 6 ] 3089 2.487% 98.884% ( 6, 10 ] 1073 0.864% 99.748% ( 10, 15 ] 142 0.114% 99.862% ( 15, 22 ] 18 0.014% 99.877% ( 22, 34 ] 2 0.002% 99.878% ( 34, 51 ] 1 0.001% 99.879% ( 51, 76 ] 2 0.002% 99.881% ( 76, 110 ] 44 0.035% 99.916% ( 110, 170 ] 46 0.037% 99.953% ( 170, 250 ] 17 0.014% 99.967% ( 250, 380 ] 17 0.014% 99.981% ( 380, 580 ] 8 0.006% 99.987% ( 580, 870 ] 8 0.006% 99.994% ( 870, 1300 ] 5 0.004% 99.998% ( 1900, 2900 ] 2 0.002% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 824618 Average: 4.4899 StdDev: 54.47 Min: 1 Median: 1.9471 Max: 8017 Percentiles: P50: 1.95 P75: 2.94 P99: 9.02 P99.9: 14.05 P99.99: 16.20 ------------------------------------------------------ [ 0, 1 ] 26374 3.198% 3.198% # ( 1, 2 ] 407476 49.414% 52.612% ########## ( 2, 3 ] 196780 23.863% 76.475% ##### ( 3, 4 ] 85101 10.320% 86.795% ## ( 4, 6 ] 86647 10.508% 97.303% ## ( 6, 10 ] 18557 2.250% 99.553% ( 10, 15 ] 3531 0.428% 99.982% ( 15, 22 ] 407 0.049% 100.031% ( 22, 34 ] 46 0.006% 100.037% ( 34, 51 ] 15 0.002% 100.038% ( 51, 76 ] 35 0.004% 100.043% ( 76, 110 ] 71 0.009% 100.051% ( 110, 170 ] 409 0.050% 100.101% ( 170, 250 ] 416 0.050% 100.151% ( 250, 380 ] 371 0.045% 100.196% ( 380, 580 ] 320 0.039% 100.235% ( 580, 870 ] 220 0.027% 100.262% ( 870, 1300 ] 134 0.016% 100.278% ( 1300, 1900 ] 50 0.006% 100.284% ( 1900, 2900 ] 42 0.005% 100.289% ( 2900, 4400 ] 88 0.011% 100.300% ( 4400, 6600 ] 12 0.001% 100.301% ( 6600, 9900 ] 2 0.000% 100.301% ** Level 4 read latency histogram (micros): Count: 17493 Average: 58.6230 StdDev: 368.05 Min: 0 Median: 2.1224 Max: 14174 Percentiles: P50: 2.12 P75: 3.37 P99: 1205.08 P99.9: 4381.96 P99.99: 6737.88 ------------------------------------------------------ [ 0, 1 ] 317 1.812% 1.812% ( 1, 2 ] 7929 45.327% 47.139% ######### ( 2, 3 ] 4090 23.381% 70.520% ##### ( 3, 4 ] 2132 12.188% 82.707% ## ( 4, 6 ] 1321 7.552% 90.259% ## ( 6, 10 ] 413 2.361% 92.620% ( 10, 15 ] 110 0.629% 93.249% ( 15, 22 ] 22 0.126% 93.374% ( 22, 34 ] 3 0.017% 93.392% ( 34, 51 ] 3 0.017% 93.409% ( 76, 110 ] 25 0.143% 93.552% ( 110, 170 ] 86 0.492% 94.043% ( 170, 250 ] 127 0.726% 94.769% ( 250, 380 ] 196 1.120% 95.890% ( 380, 580 ] 233 1.332% 97.222% ( 580, 870 ] 216 1.235% 98.457% ( 870, 1300 ] 122 0.697% 99.154% ( 1300, 1900 ] 44 0.252% 99.405% ( 1900, 2900 ] 46 0.263% 99.668% ( 2900, 4400 ] 41 0.234% 99.903% ( 4400, 6600 ] 15 0.086% 99.989% ( 6600, 9900 ] 6 0.034% 100.023% ( 9900, 14000 ] 2 0.011% 100.034% ( 14000, 22000 ] 1 0.006% 100.040% ** Level 5 read latency histogram (micros): Count: 140 Average: 1142.1000 StdDev: 1411.20 Min: 76 Median: 532.9412 Max: 7591 Percentiles: P50: 532.94 P75: 1623.08 P99: 7590.00 P99.9: 7591.00 P99.99: 7591.00 ------------------------------------------------------ ( 51, 76 ] 1 0.714% 0.714% ( 76, 110 ] 15 10.714% 11.429% ## ( 110, 170 ] 19 13.571% 25.000% ### ( 170, 250 ] 12 8.571% 33.571% ## ( 250, 380 ] 10 7.143% 40.714% # ( 380, 580 ] 17 12.143% 52.857% ## ( 580, 870 ] 14 10.000% 62.857% ## ( 870, 1300 ] 10 7.143% 70.000% # ( 1300, 1900 ] 13 9.286% 79.286% ## ( 1900, 2900 ] 14 10.000% 89.286% ## ( 2900, 4400 ] 11 7.857% 97.143% ## ( 4400, 6600 ] 2 1.429% 98.571% ( 6600, 9900 ] 2 1.429% 100.000% ** DB Stats ** Uptime(secs): 58.0 total, 21.3 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 152.67 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:32.362 H:M:S, 55.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 46.25 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:17.812 H:M:S, 83.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 0 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 : 6.654 micros/op 150286 ops/sec 60.005 seconds 9017999 operations; 145.6 MB/s Microseconds per write: Count: 9017999 Average: 6.6537 StdDev: 302.65 Min: 1 Median: 1.7697 Max: 473781 Percentiles: P50: 1.77 P75: 2.83 P99: 10.24 P99.9: 1203.20 P99.99: 2761.21 ------------------------------------------------------ [ 0, 1 ] 1013963 11.244% 11.244% ## ( 1, 2 ] 4540696 50.351% 61.595% ########## ( 2, 3 ] 1462663 16.219% 77.815% ### ( 3, 4 ] 1260002 13.972% 91.787% ### ( 4, 6 ] 511481 5.672% 97.458% # ( 6, 10 ] 136732 1.516% 98.975% ( 10, 15 ] 46672 0.518% 99.492% ( 15, 22 ] 9993 0.111% 99.603% ( 22, 34 ] 2018 0.022% 99.625% ( 34, 51 ] 259 0.003% 99.628% ( 51, 76 ] 17 0.000% 99.628% ( 76, 110 ] 6176 0.068% 99.697% ( 110, 170 ] 2548 0.028% 99.725% ( 170, 250 ] 235 0.003% 99.728% ( 250, 380 ] 190 0.002% 99.730% ( 380, 580 ] 13 0.000% 99.730% ( 580, 870 ] 13 0.000% 99.730% ( 870, 1300 ] 19758 0.219% 99.949% ( 1300, 1900 ] 120 0.001% 99.951% ( 1900, 2900 ] 4120 0.046% 99.996% ( 2900, 4400 ] 237 0.003% 99.999% ( 4400, 6600 ] 56 0.001% 100.000% ( 6600, 9900 ] 17 0.000% 100.000% ( 14000, 22000 ] 3 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 12 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 : 227199 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 : 9017999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 9306574968 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 : 511 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 34458826 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 : 32920794779 rocksdb.compact.write.bytes COUNT : 32688527983 rocksdb.flush.write.bytes COUNT : 9248153927 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 : 38 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 : 283 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 : 9173427200 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3415040 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 : 33004237283 rocksdb.non.last.level.read.count COUNT : 7978660 rocksdb.block.checksum.compute.count COUNT : 7977676 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.420923 P95 : 3.987784 P99 : 8.923153 P100 : 473779.000000 COUNT : 9017999 SUM : 55541797 rocksdb.compaction.times.micros P50 : 1084642.857143 P95 : 4276666.666667 P99 : 22849205.000000 P100 : 22849205.000000 COUNT : 81 SUM : 140636666 rocksdb.compaction.times.cpu_micros P50 : 978484.848485 P95 : 4276666.666667 P99 : 18760000.000000 P100 : 20460958.000000 COUNT : 81 SUM : 120343256 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 : 698.974359 P95 : 1157.562500 P99 : 1293.012500 P100 : 6858.000000 COUNT : 126 SUM : 91898 rocksdb.compaction.outfile.sync.micros P50 : 1073.186813 P95 : 109766.666667 P99 : 177600.000000 P100 : 188057.000000 COUNT : 362 SUM : 6767372 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 : 93.000000 P95 : 1550.000000 P99 : 3950.000000 P100 : 5206.000000 COUNT : 230 SUM : 64581 rocksdb.table.open.io.micros P50 : 1273.722222 P95 : 6111.875000 P99 : 11893.625000 P100 : 14874.000000 COUNT : 511 SUM : 937767 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.711895 P95 : 8.123210 P99 : 11.410518 P100 : 18284.000000 COUNT : 7976440 SUM : 49450501 rocksdb.read.block.get.micros P50 : 434.545455 P95 : 2806.818182 P99 : 4351.842105 P100 : 7678.000000 COUNT : 1022 SUM : 768961 rocksdb.write.raw.block.micros P50 : 0.513365 P95 : 0.975393 P99 : 2.953909 P100 : 21969.000000 COUNT : 10160479 SUM : 19298817 rocksdb.numfiles.in.singlecompaction P50 : 3.000000 P95 : 7.400000 P99 : 26.440000 P100 : 31.000000 COUNT : 126 SUM : 471 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.559333 P95 : 1147.892991 P99 : 2417.356657 P100 : 473571.000000 COUNT : 230556 SUM : 34483720 rocksdb.sst.read.micros P50 : 1.634740 P95 : 4.888841 P99 : 8.665931 P100 : 14174.000000 COUNT : 7979184 SUM : 32454549 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 : 9017999 SUM : 9306574968 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 : 212400.000000 P95 : 347000.000000 P99 : 545300.000000 P100 : 674108.000000 COUNT : 126 SUM : 26068521 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 : 335 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