[2024-12-06 13:42:35.237269] Starting SPDK v24.09.1-pre git sha1 b18e1bd62 / DPDK 23.11.0 initialization... [2024-12-06 13:42:35.237534] [ 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_pid1560593 ] Set seed to 1733488955230609 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-06 13:42:35.350457] app.c: 917:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-06 13:42:35.391699] app.c: 610:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-06 13:42:35.391746] app.c: 611:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1560593' to capture a snapshot of events at runtime. [2024-12-06 13:42:35.391756] app.c: 616:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-06 13:42:35.391766] app.c: 617:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-06 13:42:35.391774] app.c: 618:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1560593 for offline analysis/debug. [2024-12-06 13:42:35.391865] reactor.c: 990:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Dec 6 13:42:39 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/06-13:42:42 ... thread 0: (1000000,1000000) ops and (355118.7,355118.7) ops/second in (2.815960,2.815960) 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.05 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 350.0 2.34 2.12 12 0.195 0 0 0.0 0.0 L2 3/2 251.74 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.2 2.0 249.0 248.9 1.52 1.46 2 0.759 383K 204 0.0 0.0 L3 10/0 867.35 MB 0.9 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.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.3 1.5 98.0 310.2 3.86 3.58 14 0.276 383K 204 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.5 98.0 310.2 3.86 3.58 14 0.276 383K 204 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 249.0 248.9 1.52 1.46 2 0.759 383K 204 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 350.0 2.34 2.12 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.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.17 GB write, 394.38 MB/s write, 0.37 GB read, 124.54 MB/s read, 3.9 seconds Interval compaction: 1.17 GB write, 424.68 MB/s write, 0.37 GB read, 134.11 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: 101182 Average: 1.8139 StdDev: 10.93 Min: 0 Median: 1.1929 Max: 2467 Percentiles: P50: 1.19 P75: 1.65 P99: 3.90 P99.9: 10.00 P99.99: 303.52 ------------------------------------------------------ [ 0, 1 ] 39828 39.363% 39.363% ######## ( 1, 2 ] 55796 55.144% 94.507% ########### ( 2, 3 ] 3257 3.219% 97.726% # ( 3, 4 ] 1430 1.413% 99.139% ( 4, 6 ] 578 0.571% 99.710% ( 6, 10 ] 193 0.191% 99.901% ( 10, 15 ] 62 0.061% 99.962% ( 15, 22 ] 13 0.013% 99.975% ( 34, 51 ] 2 0.002% 99.977% ( 110, 170 ] 10 0.010% 99.987% ( 170, 250 ] 1 0.001% 99.988% ( 250, 380 ] 7 0.007% 99.995% ( 380, 580 ] 1 0.001% 99.996% ( 580, 870 ] 2 0.002% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ( 1900, 2900 ] 1 0.001% 100.001% ** Level 1 read latency histogram (micros): Count: 5 Average: 1377.4000 StdDev: 1196.39 Min: 282 Median: 725.0000 Max: 3186 Percentiles: P50: 725.00 P75: 2650.00 P99: 3186.00 P99.9: 3186.00 P99.99: 3186.00 ------------------------------------------------------ ( 250, 380 ] 2 40.000% 40.000% ######## ( 580, 870 ] 1 20.000% 60.000% #### ( 1900, 2900 ] 1 20.000% 80.000% #### ( 2900, 4400 ] 1 20.000% 100.000% #### ** Level 2 read latency histogram (micros): Count: 50895 Average: 2.0040 StdDev: 20.15 Min: 1 Median: 1.2457 Max: 2868 Percentiles: P50: 1.25 P75: 1.68 P99: 4.97 P99.9: 9.90 P99.99: 764.68 ------------------------------------------------------ [ 0, 1 ] 18310 35.976% 35.976% ####### ( 1, 2 ] 29047 57.072% 93.048% ########### ( 2, 3 ] 1829 3.594% 96.642% # ( 3, 4 ] 951 1.869% 98.511% ( 4, 6 ] 513 1.008% 99.519% ( 6, 10 ] 200 0.393% 99.912% ( 10, 15 ] 27 0.053% 99.965% ( 15, 22 ] 2 0.004% 99.969% ( 22, 34 ] 4 0.008% 99.976% ( 34, 51 ] 1 0.002% 99.978% ( 51, 76 ] 1 0.002% 99.980% ( 250, 380 ] 1 0.002% 99.982% ( 380, 580 ] 3 0.006% 99.988% ( 580, 870 ] 3 0.006% 99.994% ( 870, 1300 ] 2 0.004% 99.998% ( 1900, 2900 ] 2 0.004% 100.002% ** Level 3 read latency histogram (micros): Count: 40 Average: 1656.8750 StdDev: 1162.44 Min: 64 Median: 1252.2222 Max: 4002 Percentiles: P50: 1252.22 P75: 2500.00 P99: 4002.00 P99.9: 4002.00 P99.99: 4002.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 110, 170 ] 2 5.000% 7.500% # ( 380, 580 ] 2 5.000% 12.500% # ( 580, 870 ] 7 17.500% 30.000% #### ( 870, 1300 ] 9 22.500% 52.500% ##### ( 1300, 1900 ] 6 15.000% 67.500% ### ( 1900, 2900 ] 5 12.500% 80.000% ### ( 2900, 4400 ] 8 20.000% 100.000% #### ** Level 4 read latency histogram (micros): Count: 30 Average: 1936.3667 StdDev: 1237.07 Min: 250 Median: 1557.1429 Max: 4399 Percentiles: P50: 1557.14 P75: 2775.00 P99: 4335.71 P99.9: 4393.57 P99.99: 4399.00 ------------------------------------------------------ ( 170, 250 ] 1 3.333% 3.333% # ( 380, 580 ] 2 6.667% 10.000% # ( 580, 870 ] 4 13.333% 23.333% ### ( 870, 1300 ] 5 16.667% 40.000% ### ( 1300, 1900 ] 7 23.333% 63.333% ##### ( 1900, 2900 ] 4 13.333% 76.667% ### ( 2900, 4400 ] 7 23.333% 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, 324.32 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.215 H:M:S, 7.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 349.20 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.215 H:M:S, 7.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/06-13:42:45 ... thread 0: (1000000,2000000) ops and (324517.7,339129.3) ops/second in (3.081496,5.897456) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/14 1.17 GB 0.0 0.2 0.0 0.2 2.0 1.8 0.0 1.1 41.0 337.9 6.15 5.59 27 0.228 255K 230 0.0 0.0 L1 1/1 3.42 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 234.1 233.7 1.61 1.57 1 1.615 383K 580 0.0 0.0 L2 2/1 54.37 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 249.0 248.9 1.52 1.46 2 0.759 383K 204 0.0 0.0 L3 20/10 1.19 GB 0.3 0.2 0.2 0.0 0.2 0.2 0.5 1.0 232.6 232.6 1.07 1.01 1 1.073 253K 0 0.0 0.0 L4 174/0 9.75 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 149.6 149.6 1.50 1.11 1 1.502 228K 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 1255/26 97.92 GB 0.0 1.4 1.0 0.4 3.2 2.8 1.3 1.8 125.0 278.9 11.86 10.73 32 0.371 1505K 1014 0.0 0.0 Int 0/0 0.00 KB 0.0 1.4 1.0 0.4 3.2 2.8 1.2 1.8 125.0 278.9 11.86 10.73 32 0.371 1505K 1014 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.4 1.0 0.4 1.4 1.0 0.0 0.0 221.8 221.6 6.68 6.10 6 1.114 1505K 1014 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.8 1.8 0.0 0.0 0.0 353.0 5.18 4.63 26 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 total, 5.9 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.23 GB write, 540.90 MB/s write, 1.45 GB read, 242.36 MB/s read, 11.9 seconds Interval compaction: 3.23 GB write, 560.76 MB/s write, 1.45 GB read, 251.25 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: 395098 Average: 2.2392 StdDev: 9.96 Min: 0 Median: 1.5160 Max: 3355 Percentiles: P50: 1.52 P75: 1.91 P99: 5.78 P99.9: 11.67 P99.99: 14.84 ------------------------------------------------------ [ 0, 1 ] 67815 17.164% 17.164% ### ( 1, 2 ] 251423 63.636% 80.800% ############# ( 2, 3 ] 45002 11.390% 92.190% ## ( 3, 4 ] 16550 4.189% 96.379% # ( 4, 6 ] 11613 2.939% 99.318% # ( 6, 10 ] 2113 0.535% 99.853% ( 10, 15 ] 562 0.142% 99.995% ( 15, 22 ] 60 0.015% 100.010% ( 22, 34 ] 6 0.002% 100.012% ( 34, 51 ] 4 0.001% 100.013% ( 51, 76 ] 3 0.001% 100.013% ( 110, 170 ] 12 0.003% 100.016% ( 170, 250 ] 12 0.003% 100.019% ( 250, 380 ] 15 0.004% 100.023% ( 380, 580 ] 4 0.001% 100.024% ( 580, 870 ] 6 0.002% 100.026% ( 870, 1300 ] 1 0.000% 100.026% ( 1300, 1900 ] 2 0.001% 100.027% ( 1900, 2900 ] 1 0.000% 100.027% ( 2900, 4400 ] 2 0.001% 100.027% ** Level 1 read latency histogram (micros): Count: 31 Average: 382.7742 StdDev: 795.52 Min: 1 Median: 2.5000 Max: 3186 Percentiles: P50: 2.50 P75: 290.62 P99: 3186.00 P99.9: 3186.00 P99.99: 3186.00 ------------------------------------------------------ [ 0, 1 ] 11 35.484% 35.484% ####### ( 1, 2 ] 4 12.903% 48.387% ### ( 2, 3 ] 1 3.226% 51.613% # ( 4, 6 ] 1 3.226% 54.839% # ( 6, 10 ] 1 3.226% 58.065% # ( 110, 170 ] 1 3.226% 61.290% # ( 170, 250 ] 3 9.677% 70.968% ## ( 250, 380 ] 4 12.903% 83.871% ### ( 580, 870 ] 1 3.226% 87.097% # ( 870, 1300 ] 1 3.226% 90.323% # ( 1900, 2900 ] 2 6.452% 96.774% # ( 2900, 4400 ] 1 3.226% 100.000% # ** Level 2 read latency histogram (micros): Count: 95670 Average: 2.1296 StdDev: 14.72 Min: 1 Median: 1.4171 Max: 2868 Percentiles: P50: 1.42 P75: 1.82 P99: 5.62 P99.9: 9.99 P99.99: 408.87 ------------------------------------------------------ [ 0, 1 ] 23126 24.173% 24.173% ##### ( 1, 2 ] 59237 61.918% 86.091% ############ ( 2, 3 ] 7641 7.987% 94.078% ## ( 3, 4 ] 3113 3.254% 97.331% # ( 4, 6 ] 1969 2.058% 99.390% ( 6, 10 ] 490 0.512% 99.902% ( 10, 15 ] 70 0.073% 99.975% ( 15, 22 ] 6 0.006% 99.981% ( 22, 34 ] 5 0.005% 99.986% ( 34, 51 ] 1 0.001% 99.987% ( 51, 76 ] 1 0.001% 99.989% ( 250, 380 ] 1 0.001% 99.990% ( 380, 580 ] 3 0.003% 99.993% ( 580, 870 ] 3 0.003% 99.996% ( 870, 1300 ] 2 0.002% 99.998% ( 1900, 2900 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 181873 Average: 3.2775 StdDev: 33.61 Min: 0 Median: 1.6464 Max: 4002 Percentiles: P50: 1.65 P75: 2.15 P99: 8.51 P99.9: 142.21 P99.99: 385.80 ------------------------------------------------------ [ 0, 1 ] 16342 8.985% 8.985% ## ( 1, 2 ] 115408 63.455% 72.441% ############# ( 2, 3 ] 30786 16.927% 89.368% ### ( 3, 4 ] 8813 4.846% 94.214% # ( 4, 6 ] 6986 3.841% 98.055% # ( 6, 10 ] 2745 1.509% 99.564% ( 10, 15 ] 300 0.165% 99.729% ( 15, 22 ] 80 0.044% 99.773% ( 22, 34 ] 25 0.014% 99.787% ( 34, 51 ] 4 0.002% 99.789% ( 51, 76 ] 16 0.009% 99.798% ( 76, 110 ] 98 0.054% 99.852% ( 110, 170 ] 166 0.091% 99.943% ( 170, 250 ] 47 0.026% 99.969% ( 250, 380 ] 39 0.021% 99.990% ( 380, 580 ] 28 0.015% 100.005% ( 580, 870 ] 27 0.015% 100.020% ( 870, 1300 ] 18 0.010% 100.030% ( 1300, 1900 ] 6 0.003% 100.034% ( 1900, 2900 ] 6 0.003% 100.037% ( 2900, 4400 ] 8 0.004% 100.041% ** Level 4 read latency histogram (micros): Count: 320 Average: 184.9938 StdDev: 678.82 Min: 1 Median: 1.7785 Max: 4399 Percentiles: P50: 1.78 P75: 6.44 P99: 3714.29 P99.9: 4331.43 P99.99: 4393.14 ------------------------------------------------------ [ 0, 1 ] 44 13.750% 13.750% ### ( 1, 2 ] 149 46.562% 60.312% ######### ( 2, 3 ] 28 8.750% 69.062% ## ( 3, 4 ] 7 2.188% 71.250% ( 4, 6 ] 11 3.438% 74.688% # ( 6, 10 ] 9 2.812% 77.500% # ( 10, 15 ] 41 12.812% 90.312% ### ( 15, 22 ] 1 0.312% 90.625% ( 170, 250 ] 1 0.312% 90.938% ( 380, 580 ] 2 0.625% 91.562% ( 580, 870 ] 4 1.250% 92.812% ( 870, 1300 ] 5 1.562% 94.375% ( 1300, 1900 ] 7 2.188% 96.562% ( 1900, 2900 ] 4 1.250% 97.812% ( 2900, 4400 ] 7 2.188% 100.000% ** DB Stats ** Uptime(secs): 6.1 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 321.83 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.618 H:M:S, 10.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.38 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.403 H:M:S, 13.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/12/06-13:42:48 ... thread 0: (1000000,3000000) ops and (299679.0,324873.6) ops/second in (3.336904,9.234360) 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.54 GB 132.1 1.4 0.0 1.4 4.2 2.8 0.0 1.5 104.8 309.7 13.82 12.68 44 0.314 1471K 1599 0.0 0.0 L1 3/0 181.30 MB 18.1 1.0 1.0 0.0 1.0 1.0 0.2 1.0 229.1 228.5 4.41 4.28 2 2.207 1026K 2154 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 1.0 2.0 249.0 248.9 1.52 1.46 2 0.759 383K 204 0.0 0.0 L3 23/0 941.72 MB 0.9 1.9 0.7 1.2 1.9 0.7 0.5 2.6 222.4 221.9 8.85 8.09 6 1.475 1998K 4102 0.0 0.0 L4 174/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 149.6 149.6 1.50 1.11 1 1.502 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 1265/4 98.90 GB 0.0 4.9 2.1 2.8 7.7 4.9 3.4 2.8 167.1 261.0 30.11 27.62 55 0.547 5108K 8059 0.0 0.0 Int 0/0 0.00 KB 0.0 4.9 2.1 2.8 7.7 4.9 3.3 2.8 167.1 261.0 30.11 27.62 55 0.547 5108K 8059 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.9 2.1 2.8 4.9 2.1 0.0 0.0 229.5 229.1 21.92 20.46 16 1.370 5108K 8059 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 346.1 8.19 7.16 39 0.210 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.5 total, 9.2 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.67 GB write, 831.23 MB/s write, 4.91 GB read, 532.20 MB/s read, 30.1 seconds Interval compaction: 7.67 GB write, 850.71 MB/s write, 4.91 GB read, 544.68 MB/s read, 30.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: 12, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 12, interval: 12 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 722418 Average: 2.3194 StdDev: 10.52 Min: 0 Median: 1.5538 Max: 3793 Percentiles: P50: 1.55 P75: 1.95 P99: 5.88 P99.9: 11.83 P99.99: 14.62 ------------------------------------------------------ [ 0, 1 ] 108596 15.032% 15.032% ### ( 1, 2 ] 456124 63.139% 78.171% ############# ( 2, 3 ] 90677 12.552% 90.723% ### ( 3, 4 ] 34627 4.793% 95.516% # ( 4, 6 ] 26816 3.712% 99.228% # ( 6, 10 ] 4431 0.613% 99.841% ( 10, 15 ] 1163 0.161% 100.002% ( 15, 22 ] 91 0.013% 100.015% ( 22, 34 ] 11 0.002% 100.016% ( 34, 51 ] 6 0.001% 100.017% ( 51, 76 ] 5 0.001% 100.018% ( 110, 170 ] 15 0.002% 100.020% ( 170, 250 ] 19 0.003% 100.023% ( 250, 380 ] 22 0.003% 100.026% ( 380, 580 ] 6 0.001% 100.026% ( 580, 870 ] 12 0.002% 100.028% ( 870, 1300 ] 6 0.001% 100.029% ( 1300, 1900 ] 3 0.000% 100.029% ( 1900, 2900 ] 4 0.001% 100.030% ( 2900, 4400 ] 3 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 237413 Average: 3.1456 StdDev: 30.53 Min: 1 Median: 1.7949 Max: 6263 Percentiles: P50: 1.79 P75: 2.67 P99: 7.66 P99.9: 10.44 P99.99: 12.32 ------------------------------------------------------ [ 0, 1 ] 9399 3.959% 3.959% # ( 1, 2 ] 137513 57.921% 61.880% ############ ( 2, 3 ] 46502 19.587% 81.467% #### ( 3, 4 ] 20417 8.600% 90.067% ## ( 4, 6 ] 19720 8.306% 98.373% ## ( 6, 10 ] 3575 1.506% 99.879% ( 10, 15 ] 567 0.239% 100.118% ( 15, 22 ] 47 0.020% 100.138% ( 22, 34 ] 9 0.004% 100.142% ( 34, 51 ] 1 0.000% 100.142% ( 76, 110 ] 25 0.011% 100.152% ( 110, 170 ] 23 0.010% 100.162% ( 170, 250 ] 20 0.008% 100.171% ( 250, 380 ] 28 0.012% 100.182% ( 380, 580 ] 14 0.006% 100.188% ( 580, 870 ] 15 0.006% 100.195% ( 870, 1300 ] 9 0.004% 100.198% ( 1300, 1900 ] 6 0.003% 100.201% ( 1900, 2900 ] 9 0.004% 100.205% ( 2900, 4400 ] 5 0.002% 100.207% ( 4400, 6600 ] 2 0.001% 100.208% ** Level 2 read latency histogram (micros): Count: 111907 Average: 2.3707 StdDev: 18.36 Min: 1 Median: 1.4619 Max: 2868 Percentiles: P50: 1.46 P75: 1.87 P99: 5.96 P99.9: 13.93 P99.99: 638.67 ------------------------------------------------------ [ 0, 1 ] 24204 21.629% 21.629% #### ( 1, 2 ] 68732 61.419% 83.048% ############ ( 2, 3 ] 10319 9.221% 92.269% ## ( 3, 4 ] 4412 3.943% 96.211% # ( 4, 6 ] 3180 2.842% 99.053% # ( 6, 10 ] 871 0.778% 99.831% ( 10, 15 ] 98 0.088% 99.919% ( 15, 22 ] 6 0.005% 99.924% ( 22, 34 ] 6 0.005% 99.929% ( 34, 51 ] 1 0.001% 99.930% ( 51, 76 ] 1 0.001% 99.931% ( 76, 110 ] 5 0.004% 99.936% ( 110, 170 ] 37 0.033% 99.969% ( 170, 250 ] 9 0.008% 99.977% ( 250, 380 ] 6 0.005% 99.982% ( 380, 580 ] 8 0.007% 99.989% ( 580, 870 ] 4 0.004% 99.993% ( 870, 1300 ] 4 0.004% 99.996% ( 1900, 2900 ] 4 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 239446 Average: 3.3248 StdDev: 31.25 Min: 0 Median: 1.6513 Max: 4002 Percentiles: P50: 1.65 P75: 2.17 P99: 8.67 P99.9: 163.33 P99.99: 562.47 ------------------------------------------------------ [ 0, 1 ] 20579 8.594% 8.594% ## ( 1, 2 ] 152214 63.569% 72.164% ############# ( 2, 3 ] 39103 16.331% 88.494% ### ( 3, 4 ] 12734 5.318% 93.812% # ( 4, 6 ] 9877 4.125% 97.937% # ( 6, 10 ] 3814 1.593% 99.530% ( 10, 15 ] 411 0.172% 99.702% ( 15, 22 ] 96 0.040% 99.742% ( 22, 34 ] 30 0.013% 99.754% ( 34, 51 ] 5 0.002% 99.757% ( 51, 76 ] 16 0.007% 99.763% ( 76, 110 ] 148 0.062% 99.825% ( 110, 170 ] 202 0.084% 99.909% ( 170, 250 ] 91 0.038% 99.947% ( 250, 380 ] 61 0.025% 99.973% ( 380, 580 ] 45 0.019% 99.992% ( 580, 870 ] 44 0.018% 100.010% ( 870, 1300 ] 29 0.012% 100.022% ( 1300, 1900 ] 7 0.003% 100.025% ( 1900, 2900 ] 6 0.003% 100.028% ( 2900, 4400 ] 8 0.003% 100.031% ** Level 4 read latency histogram (micros): Count: 320 Average: 184.9938 StdDev: 678.82 Min: 1 Median: 1.7785 Max: 4399 Percentiles: P50: 1.78 P75: 6.44 P99: 3714.29 P99.9: 4331.43 P99.99: 4393.14 ------------------------------------------------------ [ 0, 1 ] 44 13.750% 13.750% ### ( 1, 2 ] 149 46.562% 60.312% ######### ( 2, 3 ] 28 8.750% 69.062% ## ( 3, 4 ] 7 2.188% 71.250% ( 4, 6 ] 11 3.438% 74.688% # ( 6, 10 ] 9 2.812% 77.500% # ( 10, 15 ] 41 12.812% 90.312% ### ( 15, 22 ] 1 0.312% 90.625% ( 170, 250 ] 1 0.312% 90.938% ( 380, 580 ] 2 0.625% 91.562% ( 580, 870 ] 4 1.250% 92.812% ( 870, 1300 ] 5 1.562% 94.375% ( 1300, 1900 ] 7 2.188% 96.562% ( 1900, 2900 ] 4 1.250% 97.812% ( 2900, 4400 ] 7 2.188% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 853.2167 StdDev: 1039.93 Min: 81 Median: 298.7500 Max: 4716 Percentiles: P50: 298.75 P75: 1214.00 P99: 4716.00 P99.9: 4716.00 P99.99: 4716.00 ------------------------------------------------------ ( 76, 110 ] 10 16.667% 16.667% ### ( 110, 170 ] 8 13.333% 30.000% ### ( 170, 250 ] 9 15.000% 45.000% ### ( 250, 380 ] 8 13.333% 58.333% ### ( 380, 580 ] 2 3.333% 61.667% # ( 580, 870 ] 4 6.667% 68.333% # ( 870, 1300 ] 5 8.333% 76.667% ## ( 1300, 1900 ] 4 6.667% 83.333% # ( 1900, 2900 ] 6 10.000% 93.333% ## ( 2900, 4400 ] 3 5.000% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 9.5 total, 3.3 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 312.34 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.201 H:M:S, 12.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 294.94 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.583 H:M:S, 17.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/06-13:42:51 ... thread 0: (1000000,4000000) ops and (328566.0,325788.9) ops/second in (3.043529,12.277889) 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/12 2.52 GB 63.0 1.9 0.0 1.9 5.7 3.8 0.0 1.5 105.6 313.2 18.50 17.04 60 0.308 1982K 2080 0.0 0.0 L1 3/3 181.30 MB 0.0 1.0 1.0 0.0 1.0 1.0 0.2 1.0 229.1 228.5 4.41 4.28 2 2.207 1026K 2154 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 1.0 2.0 249.0 248.9 1.52 1.46 2 0.759 383K 204 0.0 0.0 L3 23/0 941.72 MB 0.9 1.9 0.7 1.2 1.9 0.7 0.5 2.6 222.4 221.9 8.85 8.09 6 1.475 1998K 4102 0.0 0.0 L4 174/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 149.6 149.6 1.50 1.11 1 1.502 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 1273/15 99.88 GB 0.0 5.4 2.1 3.3 9.1 5.9 3.4 2.4 159.1 269.3 34.78 31.98 71 0.490 5620K 8540 0.0 0.0 Int 0/0 0.00 KB 0.0 5.4 2.1 3.3 9.1 5.9 3.3 2.4 159.1 269.3 34.78 31.98 71 0.490 5620K 8540 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.4 2.1 3.3 5.4 2.1 0.0 0.0 232.8 232.5 23.77 22.28 18 1.321 5620K 8540 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 349.0 11.01 9.70 53 0.208 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.5 total, 12.3 interval Flush(GB): cumulative 3.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.15 GB write, 749.73 MB/s write, 5.41 GB read, 442.92 MB/s read, 34.8 seconds Interval compaction: 9.15 GB write, 762.95 MB/s write, 5.41 GB read, 450.73 MB/s read, 34.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: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 15, interval: 15 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1028561 Average: 2.2562 StdDev: 10.63 Min: 0 Median: 1.5136 Max: 3793 Percentiles: P50: 1.51 P75: 1.91 P99: 5.79 P99.9: 11.65 P99.99: 16.61 ------------------------------------------------------ [ 0, 1 ] 176972 17.206% 17.206% ### ( 1, 2 ] 656814 63.858% 81.063% ############# ( 2, 3 ] 114920 11.173% 92.236% ## ( 3, 4 ] 42332 4.116% 96.352% # ( 4, 6 ] 30442 2.960% 99.312% # ( 6, 10 ] 5614 0.546% 99.857% ( 10, 15 ] 1342 0.130% 99.988% ( 15, 22 ] 114 0.011% 99.999% ( 22, 34 ] 14 0.001% 100.000% ( 34, 51 ] 8 0.001% 100.001% ( 51, 76 ] 9 0.001% 100.002% ( 76, 110 ] 45 0.004% 100.006% ( 110, 170 ] 74 0.007% 100.014% ( 170, 250 ] 41 0.004% 100.018% ( 250, 380 ] 35 0.003% 100.021% ( 380, 580 ] 11 0.001% 100.022% ( 580, 870 ] 21 0.002% 100.024% ( 870, 1300 ] 8 0.001% 100.025% ( 1300, 1900 ] 5 0.000% 100.025% ( 1900, 2900 ] 4 0.000% 100.026% ( 2900, 4400 ] 5 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 237414 Average: 3.1456 StdDev: 30.53 Min: 1 Median: 1.7949 Max: 6263 Percentiles: P50: 1.79 P75: 2.67 P99: 7.66 P99.9: 10.44 P99.99: 12.32 ------------------------------------------------------ [ 0, 1 ] 9399 3.959% 3.959% # ( 1, 2 ] 137513 57.921% 61.880% ############ ( 2, 3 ] 46503 19.587% 81.467% #### ( 3, 4 ] 20417 8.600% 90.067% ## ( 4, 6 ] 19720 8.306% 98.373% ## ( 6, 10 ] 3575 1.506% 99.879% ( 10, 15 ] 567 0.239% 100.118% ( 15, 22 ] 47 0.020% 100.138% ( 22, 34 ] 9 0.004% 100.142% ( 34, 51 ] 1 0.000% 100.142% ( 76, 110 ] 25 0.011% 100.152% ( 110, 170 ] 23 0.010% 100.162% ( 170, 250 ] 20 0.008% 100.171% ( 250, 380 ] 28 0.012% 100.182% ( 380, 580 ] 14 0.006% 100.188% ( 580, 870 ] 15 0.006% 100.195% ( 870, 1300 ] 9 0.004% 100.198% ( 1300, 1900 ] 6 0.003% 100.201% ( 1900, 2900 ] 9 0.004% 100.205% ( 2900, 4400 ] 5 0.002% 100.207% ( 4400, 6600 ] 2 0.001% 100.208% ** Level 2 read latency histogram (micros): Count: 111907 Average: 2.3707 StdDev: 18.36 Min: 1 Median: 1.4619 Max: 2868 Percentiles: P50: 1.46 P75: 1.87 P99: 5.96 P99.9: 13.93 P99.99: 638.67 ------------------------------------------------------ [ 0, 1 ] 24204 21.629% 21.629% #### ( 1, 2 ] 68732 61.419% 83.048% ############ ( 2, 3 ] 10319 9.221% 92.269% ## ( 3, 4 ] 4412 3.943% 96.211% # ( 4, 6 ] 3180 2.842% 99.053% # ( 6, 10 ] 871 0.778% 99.831% ( 10, 15 ] 98 0.088% 99.919% ( 15, 22 ] 6 0.005% 99.924% ( 22, 34 ] 6 0.005% 99.929% ( 34, 51 ] 1 0.001% 99.930% ( 51, 76 ] 1 0.001% 99.931% ( 76, 110 ] 5 0.004% 99.936% ( 110, 170 ] 37 0.033% 99.969% ( 170, 250 ] 9 0.008% 99.977% ( 250, 380 ] 6 0.005% 99.982% ( 380, 580 ] 8 0.007% 99.989% ( 580, 870 ] 4 0.004% 99.993% ( 870, 1300 ] 4 0.004% 99.996% ( 1900, 2900 ] 4 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 239446 Average: 3.3248 StdDev: 31.25 Min: 0 Median: 1.6513 Max: 4002 Percentiles: P50: 1.65 P75: 2.17 P99: 8.67 P99.9: 163.33 P99.99: 562.47 ------------------------------------------------------ [ 0, 1 ] 20579 8.594% 8.594% ## ( 1, 2 ] 152214 63.569% 72.164% ############# ( 2, 3 ] 39103 16.331% 88.494% ### ( 3, 4 ] 12734 5.318% 93.812% # ( 4, 6 ] 9877 4.125% 97.937% # ( 6, 10 ] 3814 1.593% 99.530% ( 10, 15 ] 411 0.172% 99.702% ( 15, 22 ] 96 0.040% 99.742% ( 22, 34 ] 30 0.013% 99.754% ( 34, 51 ] 5 0.002% 99.757% ( 51, 76 ] 16 0.007% 99.763% ( 76, 110 ] 148 0.062% 99.825% ( 110, 170 ] 202 0.084% 99.909% ( 170, 250 ] 91 0.038% 99.947% ( 250, 380 ] 61 0.025% 99.973% ( 380, 580 ] 45 0.019% 99.992% ( 580, 870 ] 44 0.018% 100.010% ( 870, 1300 ] 29 0.012% 100.022% ( 1300, 1900 ] 7 0.003% 100.025% ( 1900, 2900 ] 6 0.003% 100.028% ( 2900, 4400 ] 8 0.003% 100.031% ** Level 4 read latency histogram (micros): Count: 320 Average: 184.9938 StdDev: 678.82 Min: 1 Median: 1.7785 Max: 4399 Percentiles: P50: 1.78 P75: 6.44 P99: 3714.29 P99.9: 4331.43 P99.99: 4393.14 ------------------------------------------------------ [ 0, 1 ] 44 13.750% 13.750% ### ( 1, 2 ] 149 46.562% 60.312% ######### ( 2, 3 ] 28 8.750% 69.062% ## ( 3, 4 ] 7 2.188% 71.250% ( 4, 6 ] 11 3.438% 74.688% # ( 6, 10 ] 9 2.812% 77.500% # ( 10, 15 ] 41 12.812% 90.312% ### ( 15, 22 ] 1 0.312% 90.625% ( 170, 250 ] 1 0.312% 90.938% ( 380, 580 ] 2 0.625% 91.562% ( 580, 870 ] 4 1.250% 92.812% ( 870, 1300 ] 5 1.562% 94.375% ( 1300, 1900 ] 7 2.188% 96.562% ( 1900, 2900 ] 4 1.250% 97.812% ( 2900, 4400 ] 7 2.188% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 853.2167 StdDev: 1039.93 Min: 81 Median: 298.7500 Max: 4716 Percentiles: P50: 298.75 P75: 1214.00 P99: 4716.00 P99.9: 4716.00 P99.99: 4716.00 ------------------------------------------------------ ( 76, 110 ] 10 16.667% 16.667% ### ( 110, 170 ] 8 13.333% 30.000% ### ( 170, 250 ] 9 15.000% 45.000% ### ( 250, 380 ] 8 13.333% 58.333% ### ( 380, 580 ] 2 3.333% 61.667% # ( 580, 870 ] 4 6.667% 68.333% # ( 870, 1300 ] 5 8.333% 76.667% ## ( 1300, 1900 ] 4 6.667% 83.333% # ( 1900, 2900 ] 6 10.000% 93.333% ## ( 2900, 4400 ] 3 5.000% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 12.5 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 315.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:1.629 H:M:S, 13.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 323.37 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.428 H:M:S, 14.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/06-13:42:55 ... thread 0: (1000000,5000000) ops and (294428.0,318993.4) ops/second in (3.396416,15.674305) 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/8 3.44 GB 182.5 3.0 0.0 3.0 7.6 4.7 0.0 1.6 120.2 310.3 25.17 23.37 77 0.327 3070K 3208 0.0 0.0 L1 3/3 181.30 MB 0.0 1.0 1.0 0.0 1.0 1.0 0.2 1.0 229.1 228.5 4.41 4.28 2 2.207 1026K 2154 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 1.0 2.0 249.0 248.9 1.52 1.46 2 0.759 383K 204 0.0 0.0 L3 23/0 941.72 MB 0.9 1.9 0.7 1.2 1.9 0.7 0.5 2.6 222.4 221.9 8.85 8.09 6 1.475 1998K 4102 0.0 0.0 L4 174/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 149.6 149.6 1.50 1.11 1 1.502 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 1274/11 100.80 GB 0.0 6.5 2.1 4.3 11.1 6.8 3.4 2.4 159.4 274.6 41.45 38.31 88 0.471 6707K 9668 0.0 0.0 Int 0/0 0.00 KB 0.0 6.5 2.1 4.3 11.1 6.8 3.3 2.4 159.4 274.6 41.45 38.31 88 0.471 6707K 9668 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 6.5 2.1 4.3 6.4 2.1 0.0 0.0 238.5 238.2 27.69 26.13 22 1.259 6707K 9668 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 347.9 13.76 12.17 66 0.208 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.9 total, 15.7 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: 11.12 GB write, 716.28 MB/s write, 6.45 GB read, 415.65 MB/s read, 41.5 seconds Interval compaction: 11.12 GB write, 726.17 MB/s write, 6.45 GB read, 421.39 MB/s read, 41.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 2, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 2, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 20, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 2, total-stops: 20, interval: 22 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1426973 Average: 2.2387 StdDev: 10.65 Min: 0 Median: 1.5029 Max: 3793 Percentiles: P50: 1.50 P75: 1.89 P99: 5.74 P99.9: 11.30 P99.99: 18.36 ------------------------------------------------------ [ 0, 1 ] 245175 17.181% 17.181% ### ( 1, 2 ] 931197 65.257% 82.438% ############# ( 2, 3 ] 149773 10.496% 92.934% ## ( 3, 4 ] 54964 3.852% 96.786% # ( 4, 6 ] 36231 2.539% 99.325% # ( 6, 10 ] 7778 0.545% 99.870% ( 10, 15 ] 1649 0.116% 99.986% ( 15, 22 ] 132 0.009% 99.995% ( 22, 34 ] 14 0.001% 99.996% ( 34, 51 ] 10 0.001% 99.996% ( 51, 76 ] 14 0.001% 99.997% ( 76, 110 ] 109 0.008% 100.005% ( 110, 170 ] 126 0.009% 100.014% ( 170, 250 ] 55 0.004% 100.018% ( 250, 380 ] 47 0.003% 100.021% ( 380, 580 ] 29 0.002% 100.023% ( 580, 870 ] 36 0.003% 100.026% ( 870, 1300 ] 11 0.001% 100.026% ( 1300, 1900 ] 6 0.000% 100.027% ( 1900, 2900 ] 6 0.000% 100.027% ( 2900, 4400 ] 6 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 249022 Average: 3.1388 StdDev: 30.06 Min: 1 Median: 1.7744 Max: 6263 Percentiles: P50: 1.77 P75: 2.63 P99: 7.68 P99.9: 10.91 P99.99: 12.88 ------------------------------------------------------ [ 0, 1 ] 12231 4.912% 4.912% # ( 1, 2 ] 144986 58.222% 63.134% ############ ( 2, 3 ] 47223 18.963% 82.097% #### ( 3, 4 ] 20651 8.293% 90.390% ## ( 4, 6 ] 19886 7.986% 98.376% ## ( 6, 10 ] 3693 1.483% 99.859% ( 10, 15 ] 568 0.228% 100.087% ( 15, 22 ] 48 0.019% 100.106% ( 22, 34 ] 9 0.004% 100.110% ( 34, 51 ] 1 0.000% 100.110% ( 51, 76 ] 2 0.001% 100.111% ( 76, 110 ] 34 0.014% 100.124% ( 110, 170 ] 53 0.021% 100.146% ( 170, 250 ] 34 0.014% 100.159% ( 250, 380 ] 30 0.012% 100.171% ( 380, 580 ] 17 0.007% 100.178% ( 580, 870 ] 17 0.007% 100.185% ( 870, 1300 ] 10 0.004% 100.189% ( 1300, 1900 ] 6 0.002% 100.192% ( 1900, 2900 ] 9 0.004% 100.195% ( 2900, 4400 ] 5 0.002% 100.197% ( 4400, 6600 ] 2 0.001% 100.198% ** Level 2 read latency histogram (micros): Count: 111907 Average: 2.3707 StdDev: 18.36 Min: 1 Median: 1.4619 Max: 2868 Percentiles: P50: 1.46 P75: 1.87 P99: 5.96 P99.9: 13.93 P99.99: 638.67 ------------------------------------------------------ [ 0, 1 ] 24204 21.629% 21.629% #### ( 1, 2 ] 68732 61.419% 83.048% ############ ( 2, 3 ] 10319 9.221% 92.269% ## ( 3, 4 ] 4412 3.943% 96.211% # ( 4, 6 ] 3180 2.842% 99.053% # ( 6, 10 ] 871 0.778% 99.831% ( 10, 15 ] 98 0.088% 99.919% ( 15, 22 ] 6 0.005% 99.924% ( 22, 34 ] 6 0.005% 99.929% ( 34, 51 ] 1 0.001% 99.930% ( 51, 76 ] 1 0.001% 99.931% ( 76, 110 ] 5 0.004% 99.936% ( 110, 170 ] 37 0.033% 99.969% ( 170, 250 ] 9 0.008% 99.977% ( 250, 380 ] 6 0.005% 99.982% ( 380, 580 ] 8 0.007% 99.989% ( 580, 870 ] 4 0.004% 99.993% ( 870, 1300 ] 4 0.004% 99.996% ( 1900, 2900 ] 4 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 239446 Average: 3.3248 StdDev: 31.25 Min: 0 Median: 1.6513 Max: 4002 Percentiles: P50: 1.65 P75: 2.17 P99: 8.67 P99.9: 163.33 P99.99: 562.47 ------------------------------------------------------ [ 0, 1 ] 20579 8.594% 8.594% ## ( 1, 2 ] 152214 63.569% 72.164% ############# ( 2, 3 ] 39103 16.331% 88.494% ### ( 3, 4 ] 12734 5.318% 93.812% # ( 4, 6 ] 9877 4.125% 97.937% # ( 6, 10 ] 3814 1.593% 99.530% ( 10, 15 ] 411 0.172% 99.702% ( 15, 22 ] 96 0.040% 99.742% ( 22, 34 ] 30 0.013% 99.754% ( 34, 51 ] 5 0.002% 99.757% ( 51, 76 ] 16 0.007% 99.763% ( 76, 110 ] 148 0.062% 99.825% ( 110, 170 ] 202 0.084% 99.909% ( 170, 250 ] 91 0.038% 99.947% ( 250, 380 ] 61 0.025% 99.973% ( 380, 580 ] 45 0.019% 99.992% ( 580, 870 ] 44 0.018% 100.010% ( 870, 1300 ] 29 0.012% 100.022% ( 1300, 1900 ] 7 0.003% 100.025% ( 1900, 2900 ] 6 0.003% 100.028% ( 2900, 4400 ] 8 0.003% 100.031% ** Level 4 read latency histogram (micros): Count: 320 Average: 184.9938 StdDev: 678.82 Min: 1 Median: 1.7785 Max: 4399 Percentiles: P50: 1.78 P75: 6.44 P99: 3714.29 P99.9: 4331.43 P99.99: 4393.14 ------------------------------------------------------ [ 0, 1 ] 44 13.750% 13.750% ### ( 1, 2 ] 149 46.562% 60.312% ######### ( 2, 3 ] 28 8.750% 69.062% ## ( 3, 4 ] 7 2.188% 71.250% ( 4, 6 ] 11 3.438% 74.688% # ( 6, 10 ] 9 2.812% 77.500% # ( 10, 15 ] 41 12.812% 90.312% ### ( 15, 22 ] 1 0.312% 90.625% ( 170, 250 ] 1 0.312% 90.938% ( 380, 580 ] 2 0.625% 91.562% ( 580, 870 ] 4 1.250% 92.812% ( 870, 1300 ] 5 1.562% 94.375% ( 1300, 1900 ] 7 2.188% 96.562% ( 1900, 2900 ] 4 1.250% 97.812% ( 2900, 4400 ] 7 2.188% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 853.2167 StdDev: 1039.93 Min: 81 Median: 298.7500 Max: 4716 Percentiles: P50: 298.75 P75: 1214.00 P99: 4716.00 P99.9: 4716.00 P99.99: 4716.00 ------------------------------------------------------ ( 76, 110 ] 10 16.667% 16.667% ### ( 110, 170 ] 8 13.333% 30.000% ### ( 170, 250 ] 9 15.000% 45.000% ### ( 250, 380 ] 8 13.333% 58.333% ### ( 380, 580 ] 2 3.333% 61.667% # ( 580, 870 ] 4 6.667% 68.333% # ( 870, 1300 ] 5 8.333% 76.667% ## ( 1300, 1900 ] 4 6.667% 83.333% # ( 1900, 2900 ] 6 10.000% 93.333% ## ( 2900, 4400 ] 3 5.000% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 15.9 total, 3.4 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 309.63 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.368 H:M:S, 14.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 289.77 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.739 H:M:S, 21.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/06-13:42:59 ... thread 0: (1000000,6000000) ops and (234066.9,300803.3) ops/second in (4.272283,19.946588) 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 2.77 GB 18.9 3.4 0.0 3.4 9.1 5.7 0.0 1.6 118.3 312.4 29.83 27.71 94 0.317 3582K 3700 0.0 0.0 L1 20/20 1.82 GB 0.0 2.8 2.6 0.2 2.8 2.6 0.2 1.1 229.6 228.1 12.59 12.15 3 4.198 2936K 17K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 1.0 2.0 249.0 248.9 1.52 1.46 2 0.759 383K 204 0.0 0.0 L3 23/0 941.72 MB 0.9 1.9 0.7 1.2 1.9 0.7 0.5 2.6 222.4 221.9 8.85 8.09 6 1.475 1998K 4102 0.0 0.0 L4 174/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 149.6 149.6 1.50 1.11 1 1.502 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 1292/36 101.77 GB 0.0 8.8 3.8 5.0 14.4 9.4 3.4 2.5 165.6 271.8 54.29 50.51 106 0.512 9129K 25K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.8 3.8 5.0 14.4 9.4 3.3 2.5 165.6 271.8 54.29 50.51 106 0.512 9129K 25K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 8.8 3.8 5.0 8.8 3.8 0.0 0.0 238.5 237.8 37.69 35.80 25 1.508 9129K 25K 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.1 16.60 14.72 81 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): 20.2 total, 19.9 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.41 GB write, 731.94 MB/s write, 8.78 GB read, 445.84 MB/s read, 54.3 seconds Interval compaction: 14.41 GB write, 739.88 MB/s write, 8.78 GB read, 450.68 MB/s read, 54.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 6, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 6, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 21, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 6, total-stops: 21, interval: 27 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1742281 Average: 2.2274 StdDev: 11.05 Min: 0 Median: 1.4816 Max: 3793 Percentiles: P50: 1.48 P75: 1.87 P99: 5.71 P99.9: 11.59 P99.99: 96.90 ------------------------------------------------------ [ 0, 1 ] 324861 18.646% 18.646% #### ( 1, 2 ] 1134309 65.105% 83.751% ############# ( 2, 3 ] 169515 9.729% 93.480% ## ( 3, 4 ] 62066 3.562% 97.042% # ( 4, 6 ] 39948 2.293% 99.335% ( 6, 10 ] 9268 0.532% 99.867% ( 10, 15 ] 1793 0.103% 99.970% ( 15, 22 ] 163 0.009% 99.979% ( 22, 34 ] 15 0.001% 99.980% ( 34, 51 ] 13 0.001% 99.981% ( 51, 76 ] 15 0.001% 99.982% ( 76, 110 ] 229 0.013% 99.995% ( 110, 170 ] 228 0.013% 100.008% ( 170, 250 ] 85 0.005% 100.013% ( 250, 380 ] 71 0.004% 100.017% ( 380, 580 ] 59 0.003% 100.020% ( 580, 870 ] 53 0.003% 100.024% ( 870, 1300 ] 14 0.001% 100.024% ( 1300, 1900 ] 8 0.000% 100.025% ( 1900, 2900 ] 9 0.001% 100.025% ( 2900, 4400 ] 6 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 321164 Average: 3.0351 StdDev: 27.82 Min: 1 Median: 1.6797 Max: 6263 Percentiles: P50: 1.68 P75: 2.38 P99: 7.70 P99.9: 12.64 P99.99: 15.50 ------------------------------------------------------ [ 0, 1 ] 31222 9.722% 9.722% ## ( 1, 2 ] 190330 59.263% 68.984% ############ ( 2, 3 ] 51402 16.005% 84.989% ### ( 3, 4 ] 22133 6.891% 91.880% # ( 4, 6 ] 20975 6.531% 98.411% # ( 6, 10 ] 4463 1.390% 99.801% ( 10, 15 ] 604 0.188% 99.989% ( 15, 22 ] 54 0.017% 100.006% ( 22, 34 ] 10 0.003% 100.009% ( 34, 51 ] 2 0.001% 100.010% ( 51, 76 ] 3 0.001% 100.011% ( 76, 110 ] 129 0.040% 100.051% ( 110, 170 ] 121 0.038% 100.088% ( 170, 250 ] 54 0.017% 100.105% ( 250, 380 ] 57 0.018% 100.123% ( 380, 580 ] 34 0.011% 100.134% ( 580, 870 ] 26 0.008% 100.142% ( 870, 1300 ] 15 0.005% 100.146% ( 1300, 1900 ] 8 0.002% 100.149% ( 1900, 2900 ] 9 0.003% 100.152% ( 2900, 4400 ] 5 0.002% 100.153% ( 4400, 6600 ] 2 0.001% 100.154% ** Level 2 read latency histogram (micros): Count: 111907 Average: 2.3707 StdDev: 18.36 Min: 1 Median: 1.4619 Max: 2868 Percentiles: P50: 1.46 P75: 1.87 P99: 5.96 P99.9: 13.93 P99.99: 638.67 ------------------------------------------------------ [ 0, 1 ] 24204 21.629% 21.629% #### ( 1, 2 ] 68732 61.419% 83.048% ############ ( 2, 3 ] 10319 9.221% 92.269% ## ( 3, 4 ] 4412 3.943% 96.211% # ( 4, 6 ] 3180 2.842% 99.053% # ( 6, 10 ] 871 0.778% 99.831% ( 10, 15 ] 98 0.088% 99.919% ( 15, 22 ] 6 0.005% 99.924% ( 22, 34 ] 6 0.005% 99.929% ( 34, 51 ] 1 0.001% 99.930% ( 51, 76 ] 1 0.001% 99.931% ( 76, 110 ] 5 0.004% 99.936% ( 110, 170 ] 37 0.033% 99.969% ( 170, 250 ] 9 0.008% 99.977% ( 250, 380 ] 6 0.005% 99.982% ( 380, 580 ] 8 0.007% 99.989% ( 580, 870 ] 4 0.004% 99.993% ( 870, 1300 ] 4 0.004% 99.996% ( 1900, 2900 ] 4 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 239446 Average: 3.3248 StdDev: 31.25 Min: 0 Median: 1.6513 Max: 4002 Percentiles: P50: 1.65 P75: 2.17 P99: 8.67 P99.9: 163.33 P99.99: 562.47 ------------------------------------------------------ [ 0, 1 ] 20579 8.594% 8.594% ## ( 1, 2 ] 152214 63.569% 72.164% ############# ( 2, 3 ] 39103 16.331% 88.494% ### ( 3, 4 ] 12734 5.318% 93.812% # ( 4, 6 ] 9877 4.125% 97.937% # ( 6, 10 ] 3814 1.593% 99.530% ( 10, 15 ] 411 0.172% 99.702% ( 15, 22 ] 96 0.040% 99.742% ( 22, 34 ] 30 0.013% 99.754% ( 34, 51 ] 5 0.002% 99.757% ( 51, 76 ] 16 0.007% 99.763% ( 76, 110 ] 148 0.062% 99.825% ( 110, 170 ] 202 0.084% 99.909% ( 170, 250 ] 91 0.038% 99.947% ( 250, 380 ] 61 0.025% 99.973% ( 380, 580 ] 45 0.019% 99.992% ( 580, 870 ] 44 0.018% 100.010% ( 870, 1300 ] 29 0.012% 100.022% ( 1300, 1900 ] 7 0.003% 100.025% ( 1900, 2900 ] 6 0.003% 100.028% ( 2900, 4400 ] 8 0.003% 100.031% ** Level 4 read latency histogram (micros): Count: 320 Average: 184.9938 StdDev: 678.82 Min: 1 Median: 1.7785 Max: 4399 Percentiles: P50: 1.78 P75: 6.44 P99: 3714.29 P99.9: 4331.43 P99.99: 4393.14 ------------------------------------------------------ [ 0, 1 ] 44 13.750% 13.750% ### ( 1, 2 ] 149 46.562% 60.312% ######### ( 2, 3 ] 28 8.750% 69.062% ## ( 3, 4 ] 7 2.188% 71.250% ( 4, 6 ] 11 3.438% 74.688% # ( 6, 10 ] 9 2.812% 77.500% # ( 10, 15 ] 41 12.812% 90.312% ### ( 15, 22 ] 1 0.312% 90.625% ( 170, 250 ] 1 0.312% 90.938% ( 380, 580 ] 2 0.625% 91.562% ( 580, 870 ] 4 1.250% 92.812% ( 870, 1300 ] 5 1.562% 94.375% ( 1300, 1900 ] 7 2.188% 96.562% ( 1900, 2900 ] 4 1.250% 97.812% ( 2900, 4400 ] 7 2.188% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 853.2167 StdDev: 1039.93 Min: 81 Median: 298.7500 Max: 4716 Percentiles: P50: 298.75 P75: 1214.00 P99: 4716.00 P99.9: 4716.00 P99.99: 4716.00 ------------------------------------------------------ ( 76, 110 ] 10 16.667% 16.667% ### ( 110, 170 ] 8 13.333% 30.000% ### ( 170, 250 ] 9 15.000% 45.000% ### ( 250, 380 ] 8 13.333% 58.333% ### ( 380, 580 ] 2 3.333% 61.667% # ( 580, 870 ] 4 6.667% 68.333% # ( 870, 1300 ] 5 8.333% 76.667% ## ( 1300, 1900 ] 4 6.667% 83.333% # ( 1900, 2900 ] 6 10.000% 93.333% ## ( 2900, 4400 ] 3 5.000% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 20.2 total, 4.3 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 292.84 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.979 H:M:S, 19.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 230.37 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.611 H:M:S, 37.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/06-13:43:05 ... thread 0: (1000000,7000000) ops and (160181.7,267282.7) ops/second in (6.242912,26.189500) 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 21/17 3.81 GB 50.4 4.7 0.0 4.7 11.4 6.7 0.0 1.7 128.6 310.4 37.73 35.19 116 0.325 4925K 5035 0.0 0.0 L1 20/20 1.82 GB 0.0 2.8 2.6 0.2 2.8 2.6 0.2 1.1 229.6 228.1 12.59 12.15 3 4.198 2936K 17K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 1.0 2.0 249.0 248.9 1.52 1.46 2 0.759 383K 204 0.0 0.0 L3 23/0 941.72 MB 0.9 1.9 0.7 1.2 1.9 0.7 0.5 2.6 222.4 221.9 8.85 8.09 6 1.475 1998K 4102 0.0 0.0 L4 174/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 149.6 149.6 1.50 1.11 1 1.502 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 1294/37 102.82 GB 0.0 10.1 3.8 6.3 16.8 10.5 3.4 2.5 165.8 275.8 62.20 58.00 128 0.486 10M 27K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.1 3.8 6.3 16.8 10.5 3.3 2.5 165.8 275.8 62.20 58.00 128 0.486 10M 27K 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.1 3.8 6.3 10.0 3.8 0.0 0.0 242.1 241.5 42.59 40.61 30 1.420 10M 27K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.7 6.7 0.0 0.0 0.0 350.2 19.61 17.39 98 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): 26.4 total, 26.2 interval Flush(GB): cumulative 6.706, interval 6.706 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.75 GB write, 649.49 MB/s write, 10.07 GB read, 390.53 MB/s read, 62.2 seconds Interval compaction: 16.75 GB write, 654.86 MB/s write, 10.07 GB read, 393.76 MB/s read, 62.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 17, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 17, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 21, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 21, interval: 38 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2338297 Average: 2.2369 StdDev: 11.54 Min: 0 Median: 1.4790 Max: 4188 Percentiles: P50: 1.48 P75: 1.86 P99: 5.67 P99.9: 11.82 P99.99: 122.50 ------------------------------------------------------ [ 0, 1 ] 432254 18.486% 18.486% #### ( 1, 2 ] 1538428 65.793% 84.279% ############# ( 2, 3 ] 222837 9.530% 93.808% ## ( 3, 4 ] 79973 3.420% 97.229% # ( 4, 6 ] 49483 2.116% 99.345% ( 6, 10 ] 12178 0.521% 99.866% ( 10, 15 ] 2220 0.095% 99.960% ( 15, 22 ] 206 0.009% 99.969% ( 22, 34 ] 22 0.001% 99.970% ( 34, 51 ] 16 0.001% 99.971% ( 51, 76 ] 16 0.001% 99.972% ( 76, 110 ] 340 0.015% 99.986% ( 110, 170 ] 452 0.019% 100.005% ( 170, 250 ] 135 0.006% 100.011% ( 250, 380 ] 111 0.005% 100.016% ( 380, 580 ] 103 0.004% 100.020% ( 580, 870 ] 73 0.003% 100.024% ( 870, 1300 ] 20 0.001% 100.024% ( 1300, 1900 ] 11 0.000% 100.025% ( 1900, 2900 ] 11 0.000% 100.025% ( 2900, 4400 ] 9 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 470742 Average: 2.8763 StdDev: 23.81 Min: 1 Median: 1.6128 Max: 6263 Percentiles: P50: 1.61 P75: 2.07 P99: 7.73 P99.9: 14.76 P99.99: 110.46 ------------------------------------------------------ [ 0, 1 ] 56650 12.034% 12.034% ## ( 1, 2 ] 291635 61.952% 73.986% ############ ( 2, 3 ] 64658 13.735% 87.722% ### ( 3, 4 ] 26390 5.606% 93.328% # ( 4, 6 ] 23962 5.090% 98.418% # ( 6, 10 ] 6324 1.343% 99.761% ( 10, 15 ] 685 0.146% 99.907% ( 15, 22 ] 72 0.015% 99.922% ( 22, 34 ] 10 0.002% 99.924% ( 34, 51 ] 2 0.000% 99.925% ( 51, 76 ] 5 0.001% 99.926% ( 76, 110 ] 300 0.064% 99.990% ( 110, 170 ] 253 0.054% 100.043% ( 170, 250 ] 81 0.017% 100.061% ( 250, 380 ] 78 0.017% 100.077% ( 380, 580 ] 56 0.012% 100.089% ( 580, 870 ] 33 0.007% 100.096% ( 870, 1300 ] 17 0.004% 100.100% ( 1300, 1900 ] 8 0.002% 100.101% ( 1900, 2900 ] 9 0.002% 100.103% ( 2900, 4400 ] 5 0.001% 100.104% ( 4400, 6600 ] 2 0.000% 100.105% ** Level 2 read latency histogram (micros): Count: 111907 Average: 2.3707 StdDev: 18.36 Min: 1 Median: 1.4619 Max: 2868 Percentiles: P50: 1.46 P75: 1.87 P99: 5.96 P99.9: 13.93 P99.99: 638.67 ------------------------------------------------------ [ 0, 1 ] 24204 21.629% 21.629% #### ( 1, 2 ] 68732 61.419% 83.048% ############ ( 2, 3 ] 10319 9.221% 92.269% ## ( 3, 4 ] 4412 3.943% 96.211% # ( 4, 6 ] 3180 2.842% 99.053% # ( 6, 10 ] 871 0.778% 99.831% ( 10, 15 ] 98 0.088% 99.919% ( 15, 22 ] 6 0.005% 99.924% ( 22, 34 ] 6 0.005% 99.929% ( 34, 51 ] 1 0.001% 99.930% ( 51, 76 ] 1 0.001% 99.931% ( 76, 110 ] 5 0.004% 99.936% ( 110, 170 ] 37 0.033% 99.969% ( 170, 250 ] 9 0.008% 99.977% ( 250, 380 ] 6 0.005% 99.982% ( 380, 580 ] 8 0.007% 99.989% ( 580, 870 ] 4 0.004% 99.993% ( 870, 1300 ] 4 0.004% 99.996% ( 1900, 2900 ] 4 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 239446 Average: 3.3248 StdDev: 31.25 Min: 0 Median: 1.6513 Max: 4002 Percentiles: P50: 1.65 P75: 2.17 P99: 8.67 P99.9: 163.33 P99.99: 562.47 ------------------------------------------------------ [ 0, 1 ] 20579 8.594% 8.594% ## ( 1, 2 ] 152214 63.569% 72.164% ############# ( 2, 3 ] 39103 16.331% 88.494% ### ( 3, 4 ] 12734 5.318% 93.812% # ( 4, 6 ] 9877 4.125% 97.937% # ( 6, 10 ] 3814 1.593% 99.530% ( 10, 15 ] 411 0.172% 99.702% ( 15, 22 ] 96 0.040% 99.742% ( 22, 34 ] 30 0.013% 99.754% ( 34, 51 ] 5 0.002% 99.757% ( 51, 76 ] 16 0.007% 99.763% ( 76, 110 ] 148 0.062% 99.825% ( 110, 170 ] 202 0.084% 99.909% ( 170, 250 ] 91 0.038% 99.947% ( 250, 380 ] 61 0.025% 99.973% ( 380, 580 ] 45 0.019% 99.992% ( 580, 870 ] 44 0.018% 100.010% ( 870, 1300 ] 29 0.012% 100.022% ( 1300, 1900 ] 7 0.003% 100.025% ( 1900, 2900 ] 6 0.003% 100.028% ( 2900, 4400 ] 8 0.003% 100.031% ** Level 4 read latency histogram (micros): Count: 320 Average: 184.9938 StdDev: 678.82 Min: 1 Median: 1.7785 Max: 4399 Percentiles: P50: 1.78 P75: 6.44 P99: 3714.29 P99.9: 4331.43 P99.99: 4393.14 ------------------------------------------------------ [ 0, 1 ] 44 13.750% 13.750% ### ( 1, 2 ] 149 46.562% 60.312% ######### ( 2, 3 ] 28 8.750% 69.062% ## ( 3, 4 ] 7 2.188% 71.250% ( 4, 6 ] 11 3.438% 74.688% # ( 6, 10 ] 9 2.812% 77.500% # ( 10, 15 ] 41 12.812% 90.312% ### ( 15, 22 ] 1 0.312% 90.625% ( 170, 250 ] 1 0.312% 90.938% ( 380, 580 ] 2 0.625% 91.562% ( 580, 870 ] 4 1.250% 92.812% ( 870, 1300 ] 5 1.562% 94.375% ( 1300, 1900 ] 7 2.188% 96.562% ( 1900, 2900 ] 4 1.250% 97.812% ( 2900, 4400 ] 7 2.188% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 853.2167 StdDev: 1039.93 Min: 81 Median: 298.7500 Max: 4716 Percentiles: P50: 298.75 P75: 1214.00 P99: 4716.00 P99.9: 4716.00 P99.99: 4716.00 ------------------------------------------------------ ( 76, 110 ] 10 16.667% 16.667% ### ( 110, 170 ] 8 13.333% 30.000% ### ( 170, 250 ] 9 15.000% 45.000% ### ( 250, 380 ] 8 13.333% 58.333% ### ( 380, 580 ] 2 3.333% 61.667% # ( 580, 870 ] 4 6.667% 68.333% # ( 870, 1300 ] 5 8.333% 76.667% ## ( 1300, 1900 ] 4 6.667% 83.333% # ( 1900, 2900 ] 6 10.000% 93.333% ## ( 2900, 4400 ] 3 5.000% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 26.4 total, 6.2 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 260.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:7.373 H:M:S, 27.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 157.62 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:3.394 H:M:S, 54.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 0 2024/12/06-13:43:22 ... thread 0: (1000000,8000000) ops and (59595.3,186179.2) ops/second in (16.779854,42.969354) 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/11 2.39 GB 6.3 6.3 0.0 6.3 13.8 7.6 0.0 1.8 137.7 303.5 46.67 43.21 132 0.354 6523K 10K 0.0 0.0 L1 18/18 1.68 GB 0.0 6.9 4.9 2.0 6.8 4.8 0.2 1.4 224.8 222.1 31.51 29.56 4 7.878 7194K 87K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 3.3 2.0 249.0 248.9 1.52 1.46 2 0.759 383K 204 0.0 0.0 L3 20/0 935.62 MB 0.9 4.9 3.1 1.8 4.9 3.1 0.5 1.6 158.0 157.1 31.69 22.15 17 1.864 5085K 28K 0.0 0.0 L4 178/0 9.51 GB 1.0 2.6 2.5 0.1 2.6 2.4 0.8 1.0 138.1 137.8 19.04 12.13 31 0.614 2619K 3485 0.0 0.0 L5 1084/0 89.08 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1312/29 103.57 GB 0.0 21.0 10.6 10.4 28.5 18.1 8.2 3.8 165.0 223.4 130.43 108.51 186 0.701 21M 130K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.0 10.6 10.4 28.5 18.1 8.1 3.8 165.0 223.4 130.43 108.51 186 0.701 21M 130K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 21.0 10.6 10.4 20.9 10.5 0.0 0.0 199.7 198.5 107.77 88.83 75 1.437 21M 130K 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 341.9 22.66 19.68 111 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): 43.2 total, 43.0 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 28.46 GB write, 674.73 MB/s write, 21.02 GB read, 498.39 MB/s read, 130.4 seconds Interval compaction: 28.46 GB write, 678.13 MB/s write, 21.02 GB read, 500.90 MB/s read, 130.4 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: 29, pending-compaction-bytes-delays: 29, pending-compaction-bytes-stops: 0, total-delays: 50, total-stops: 29, interval: 79 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3194664 Average: 2.7363 StdDev: 38.65 Min: 0 Median: 1.4856 Max: 41559 Percentiles: P50: 1.49 P75: 1.87 P99: 6.30 P99.9: 124.73 P99.99: 369.66 ------------------------------------------------------ [ 0, 1 ] 597027 18.688% 18.688% #### ( 1, 2 ] 2059844 64.478% 83.166% ############# ( 2, 3 ] 307724 9.632% 92.798% ## ( 3, 4 ] 113883 3.565% 96.363% # ( 4, 6 ] 82552 2.584% 98.947% # ( 6, 10 ] 22434 0.702% 99.649% ( 10, 15 ] 3417 0.107% 99.756% ( 15, 22 ] 361 0.011% 99.768% ( 22, 34 ] 33 0.001% 99.769% ( 34, 51 ] 20 0.001% 99.769% ( 51, 76 ] 479 0.015% 99.784% ( 76, 110 ] 3101 0.097% 99.881% ( 110, 170 ] 2425 0.076% 99.957% ( 170, 250 ] 612 0.019% 99.976% ( 250, 380 ] 471 0.015% 99.991% ( 380, 580 ] 428 0.013% 100.005% ( 580, 870 ] 240 0.008% 100.012% ( 870, 1300 ] 128 0.004% 100.016% ( 1300, 1900 ] 63 0.002% 100.018% ( 1900, 2900 ] 49 0.002% 100.020% ( 2900, 4400 ] 55 0.002% 100.021% ( 4400, 6600 ] 11 0.000% 100.022% ( 6600, 9900 ] 3 0.000% 100.022% ( 9900, 14000 ] 1 0.000% 100.022% ( 14000, 22000 ] 1 0.000% 100.022% ( 22000, 33000 ] 1 0.000% 100.022% ( 33000, 50000 ] 1 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 1362435 Average: 4.7548 StdDev: 101.93 Min: 0 Median: 1.6976 Max: 43567 Percentiles: P50: 1.70 P75: 2.53 P99: 8.90 P99.9: 88.75 P99.99: 147.69 ------------------------------------------------------ [ 0, 1 ] 158868 11.661% 11.661% ## ( 1, 2 ] 748824 54.962% 66.623% ########### ( 2, 3 ] 214500 15.744% 82.367% ### ( 3, 4 ] 103081 7.566% 89.933% ## ( 4, 6 ] 104605 7.678% 97.610% ## ( 6, 10 ] 26112 1.917% 99.527% ( 10, 15 ] 4015 0.295% 99.822% ( 15, 22 ] 459 0.034% 99.855% ( 22, 34 ] 34 0.002% 99.858% ( 34, 51 ] 19 0.001% 99.859% ( 51, 76 ] 200 0.015% 99.874% ( 76, 110 ] 948 0.070% 99.943% ( 110, 170 ] 1009 0.074% 100.018% ( 170, 250 ] 290 0.021% 100.039% ( 250, 380 ] 375 0.028% 100.066% ( 380, 580 ] 419 0.031% 100.097% ( 580, 870 ] 402 0.030% 100.127% ( 870, 1300 ] 297 0.022% 100.148% ( 1300, 1900 ] 144 0.011% 100.159% ( 1900, 2900 ] 129 0.009% 100.168% ( 2900, 4400 ] 191 0.014% 100.182% ( 4400, 6600 ] 49 0.004% 100.186% ( 6600, 9900 ] 15 0.001% 100.187% ( 22000, 33000 ] 3 0.000% 100.187% ( 33000, 50000 ] 3 0.000% 100.188% ** Level 2 read latency histogram (micros): Count: 111907 Average: 2.3707 StdDev: 18.36 Min: 1 Median: 1.4619 Max: 2868 Percentiles: P50: 1.46 P75: 1.87 P99: 5.96 P99.9: 13.93 P99.99: 638.67 ------------------------------------------------------ [ 0, 1 ] 24204 21.629% 21.629% #### ( 1, 2 ] 68732 61.419% 83.048% ############ ( 2, 3 ] 10319 9.221% 92.269% ## ( 3, 4 ] 4412 3.943% 96.211% # ( 4, 6 ] 3180 2.842% 99.053% # ( 6, 10 ] 871 0.778% 99.831% ( 10, 15 ] 98 0.088% 99.919% ( 15, 22 ] 6 0.005% 99.924% ( 22, 34 ] 6 0.005% 99.929% ( 34, 51 ] 1 0.001% 99.930% ( 51, 76 ] 1 0.001% 99.931% ( 76, 110 ] 5 0.004% 99.936% ( 110, 170 ] 37 0.033% 99.969% ( 170, 250 ] 9 0.008% 99.977% ( 250, 380 ] 6 0.005% 99.982% ( 380, 580 ] 8 0.007% 99.989% ( 580, 870 ] 4 0.004% 99.993% ( 870, 1300 ] 4 0.004% 99.996% ( 1900, 2900 ] 4 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 977061 Average: 4.2794 StdDev: 60.52 Min: 0 Median: 1.8948 Max: 10478 Percentiles: P50: 1.89 P75: 2.90 P99: 8.38 P99.9: 12.70 P99.99: 14.37 ------------------------------------------------------ [ 0, 1 ] 29883 3.058% 3.058% # ( 1, 2 ] 512544 52.458% 55.516% ########## ( 2, 3 ] 211841 21.681% 77.198% #### ( 3, 4 ] 102844 10.526% 87.723% ## ( 4, 6 ] 99353 10.169% 97.892% ## ( 6, 10 ] 18204 1.863% 99.755% ( 10, 15 ] 2625 0.269% 100.024% ( 15, 22 ] 379 0.039% 100.063% ( 22, 34 ] 51 0.005% 100.068% ( 34, 51 ] 11 0.001% 100.069% ( 51, 76 ] 30 0.003% 100.072% ( 76, 110 ] 175 0.018% 100.090% ( 110, 170 ] 282 0.029% 100.119% ( 170, 250 ] 254 0.026% 100.145% ( 250, 380 ] 299 0.031% 100.175% ( 380, 580 ] 222 0.023% 100.198% ( 580, 870 ] 176 0.018% 100.216% ( 870, 1300 ] 128 0.013% 100.229% ( 1300, 1900 ] 52 0.005% 100.235% ( 1900, 2900 ] 53 0.005% 100.240% ( 2900, 4400 ] 112 0.011% 100.251% ( 4400, 6600 ] 24 0.002% 100.254% ( 6600, 9900 ] 10 0.001% 100.255% ( 9900, 14000 ] 1 0.000% 100.255% ** Level 4 read latency histogram (micros): Count: 30535 Average: 75.2465 StdDev: 484.17 Min: 1 Median: 1.9691 Max: 43247 Percentiles: P50: 1.97 P75: 3.24 P99: 1764.12 P99.9: 5364.33 P99.99: 9060.29 ------------------------------------------------------ [ 0, 1 ] 755 2.473% 2.473% ( 1, 2 ] 14976 49.045% 51.518% ########## ( 2, 3 ] 6328 20.724% 72.242% #### ( 3, 4 ] 3570 11.692% 83.933% ## ( 4, 6 ] 2049 6.710% 90.644% # ( 6, 10 ] 637 2.086% 92.730% ( 10, 15 ] 144 0.472% 93.201% ( 15, 22 ] 20 0.065% 93.267% ( 22, 34 ] 12 0.039% 93.306% ( 51, 76 ] 18 0.059% 93.365% ( 76, 110 ] 36 0.118% 93.483% ( 110, 170 ] 65 0.213% 93.696% ( 170, 250 ] 144 0.472% 94.167% ( 250, 380 ] 223 0.730% 94.898% ( 380, 580 ] 360 1.179% 96.077% ( 580, 870 ] 416 1.362% 97.439% ( 870, 1300 ] 332 1.087% 98.526% ( 1300, 1900 ] 187 0.612% 99.139% ( 1900, 2900 ] 113 0.370% 99.509% ( 2900, 4400 ] 105 0.344% 99.853% ( 4400, 6600 ] 33 0.108% 99.961% ( 6600, 9900 ] 12 0.039% 100.000% ( 14000, 22000 ] 3 0.010% 100.010% ( 33000, 50000 ] 1 0.003% 100.013% ** Level 5 read latency histogram (micros): Count: 200 Average: 1531.6750 StdDev: 1758.20 Min: 81 Median: 604.1667 Max: 9703 Percentiles: P50: 604.17 P75: 2566.67 P99: 6600.00 P99.9: 9570.00 P99.99: 9703.00 ------------------------------------------------------ ( 76, 110 ] 10 5.000% 5.000% # ( 110, 170 ] 23 11.500% 16.500% ## ( 170, 250 ] 21 10.500% 27.000% ## ( 250, 380 ] 27 13.500% 40.500% ### ( 380, 580 ] 18 9.000% 49.500% ## ( 580, 870 ] 12 6.000% 55.500% # ( 870, 1300 ] 13 6.500% 62.000% # ( 1300, 1900 ] 12 6.000% 68.000% # ( 1900, 2900 ] 21 10.500% 78.500% ## ( 2900, 4400 ] 29 14.500% 93.000% ### ( 4400, 6600 ] 12 6.000% 99.000% # ( 6600, 9900 ] 2 1.000% 100.000% ** DB Stats ** Uptime(secs): 43.2 total, 16.8 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 182.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:20.633 H:M:S, 47.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 58.66 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:13.261 H:M:S, 79.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/06-13:43:25 ... thread 0: (1000000,9000000) ops and (330984.7,195692.0) ops/second in (3.021288,45.990642) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/11 3.31 GB 100.7 7.1 0.0 7.1 15.6 8.5 0.0 1.8 138.7 303.6 52.67 48.87 148 0.356 7419K 10K 0.0 0.0 L1 18/18 1.68 GB 0.0 6.9 4.9 2.0 6.8 4.8 0.2 1.4 224.8 222.1 31.51 29.56 4 7.878 7194K 87K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 3.3 2.0 249.0 248.9 1.52 1.46 2 0.759 383K 204 0.0 0.0 L3 20/0 935.62 MB 0.9 4.9 3.1 1.8 4.9 3.1 0.5 1.6 158.0 157.1 31.69 22.15 17 1.864 5085K 28K 0.0 0.0 L4 178/0 9.51 GB 1.0 2.6 2.5 0.1 2.6 2.4 0.8 1.0 138.1 137.8 19.04 12.13 31 0.614 2619K 3485 0.0 0.0 L5 1084/0 89.08 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1316/29 104.50 GB 0.0 21.9 10.6 11.2 30.2 19.0 8.2 3.6 164.2 227.0 136.43 114.17 202 0.675 22M 130K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.9 10.6 11.2 30.2 19.0 8.1 3.6 164.2 227.0 136.43 114.17 202 0.675 22M 130K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 21.9 10.6 11.2 21.8 10.5 0.0 0.0 201.7 200.5 111.07 92.08 78 1.424 22M 130K 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 342.8 25.36 22.09 124 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): 46.2 total, 46.0 interval Flush(GB): cumulative 8.490, interval 8.490 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 30.24 GB write, 670.13 MB/s write, 21.88 GB read, 484.89 MB/s read, 136.4 seconds Interval compaction: 30.24 GB write, 673.28 MB/s write, 21.88 GB read, 487.17 MB/s read, 136.4 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: 31, pending-compaction-bytes-delays: 29, pending-compaction-bytes-stops: 0, total-delays: 50, total-stops: 31, interval: 81 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3568912 Average: 2.7006 StdDev: 36.89 Min: 0 Median: 1.4918 Max: 41559 Percentiles: P50: 1.49 P75: 1.88 P99: 6.20 P99.9: 116.57 P99.99: 335.30 ------------------------------------------------------ [ 0, 1 ] 646629 18.118% 18.118% #### ( 1, 2 ] 2313629 64.827% 82.946% ############# ( 2, 3 ] 353057 9.893% 92.838% ## ( 3, 4 ] 127564 3.574% 96.413% # ( 4, 6 ] 91102 2.553% 98.965% # ( 6, 10 ] 25307 0.709% 99.674% ( 10, 15 ] 3717 0.104% 99.778% ( 15, 22 ] 388 0.011% 99.789% ( 22, 34 ] 34 0.001% 99.790% ( 34, 51 ] 22 0.001% 99.791% ( 51, 76 ] 482 0.014% 99.804% ( 76, 110 ] 3137 0.088% 99.892% ( 110, 170 ] 2521 0.071% 99.963% ( 170, 250 ] 641 0.018% 99.981% ( 250, 380 ] 497 0.014% 99.995% ( 380, 580 ] 452 0.013% 100.007% ( 580, 870 ] 252 0.007% 100.015% ( 870, 1300 ] 134 0.004% 100.018% ( 1300, 1900 ] 65 0.002% 100.020% ( 1900, 2900 ] 52 0.001% 100.022% ( 2900, 4400 ] 57 0.002% 100.023% ( 4400, 6600 ] 12 0.000% 100.024% ( 6600, 9900 ] 3 0.000% 100.024% ( 9900, 14000 ] 1 0.000% 100.024% ( 14000, 22000 ] 1 0.000% 100.024% ( 22000, 33000 ] 1 0.000% 100.024% ( 33000, 50000 ] 1 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 1399465 Average: 4.7019 StdDev: 100.59 Min: 0 Median: 1.6934 Max: 43567 Percentiles: P50: 1.69 P75: 2.51 P99: 8.89 P99.9: 90.88 P99.99: 149.58 ------------------------------------------------------ [ 0, 1 ] 163146 11.658% 11.658% ## ( 1, 2 ] 773878 55.298% 66.956% ########### ( 2, 3 ] 219599 15.692% 82.648% ### ( 3, 4 ] 104211 7.446% 90.094% # ( 4, 6 ] 105348 7.528% 97.622% ## ( 6, 10 ] 26664 1.905% 99.527% ( 10, 15 ] 4059 0.290% 99.817% ( 15, 22 ] 461 0.033% 99.850% ( 22, 34 ] 34 0.002% 99.852% ( 34, 51 ] 20 0.001% 99.854% ( 51, 76 ] 201 0.014% 99.868% ( 76, 110 ] 1016 0.073% 99.941% ( 110, 170 ] 1043 0.075% 100.015% ( 170, 250 ] 299 0.021% 100.037% ( 250, 380 ] 381 0.027% 100.064% ( 380, 580 ] 426 0.030% 100.094% ( 580, 870 ] 404 0.029% 100.123% ( 870, 1300 ] 297 0.021% 100.144% ( 1300, 1900 ] 144 0.010% 100.155% ( 1900, 2900 ] 129 0.009% 100.164% ( 2900, 4400 ] 191 0.014% 100.178% ( 4400, 6600 ] 49 0.004% 100.181% ( 6600, 9900 ] 15 0.001% 100.182% ( 22000, 33000 ] 3 0.000% 100.182% ( 33000, 50000 ] 3 0.000% 100.183% ** Level 2 read latency histogram (micros): Count: 111907 Average: 2.3707 StdDev: 18.36 Min: 1 Median: 1.4619 Max: 2868 Percentiles: P50: 1.46 P75: 1.87 P99: 5.96 P99.9: 13.93 P99.99: 638.67 ------------------------------------------------------ [ 0, 1 ] 24204 21.629% 21.629% #### ( 1, 2 ] 68732 61.419% 83.048% ############ ( 2, 3 ] 10319 9.221% 92.269% ## ( 3, 4 ] 4412 3.943% 96.211% # ( 4, 6 ] 3180 2.842% 99.053% # ( 6, 10 ] 871 0.778% 99.831% ( 10, 15 ] 98 0.088% 99.919% ( 15, 22 ] 6 0.005% 99.924% ( 22, 34 ] 6 0.005% 99.929% ( 34, 51 ] 1 0.001% 99.930% ( 51, 76 ] 1 0.001% 99.931% ( 76, 110 ] 5 0.004% 99.936% ( 110, 170 ] 37 0.033% 99.969% ( 170, 250 ] 9 0.008% 99.977% ( 250, 380 ] 6 0.005% 99.982% ( 380, 580 ] 8 0.007% 99.989% ( 580, 870 ] 4 0.004% 99.993% ( 870, 1300 ] 4 0.004% 99.996% ( 1900, 2900 ] 4 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 977061 Average: 4.2794 StdDev: 60.52 Min: 0 Median: 1.8948 Max: 10478 Percentiles: P50: 1.89 P75: 2.90 P99: 8.38 P99.9: 12.70 P99.99: 14.37 ------------------------------------------------------ [ 0, 1 ] 29883 3.058% 3.058% # ( 1, 2 ] 512544 52.458% 55.516% ########## ( 2, 3 ] 211841 21.681% 77.198% #### ( 3, 4 ] 102844 10.526% 87.723% ## ( 4, 6 ] 99353 10.169% 97.892% ## ( 6, 10 ] 18204 1.863% 99.755% ( 10, 15 ] 2625 0.269% 100.024% ( 15, 22 ] 379 0.039% 100.063% ( 22, 34 ] 51 0.005% 100.068% ( 34, 51 ] 11 0.001% 100.069% ( 51, 76 ] 30 0.003% 100.072% ( 76, 110 ] 175 0.018% 100.090% ( 110, 170 ] 282 0.029% 100.119% ( 170, 250 ] 254 0.026% 100.145% ( 250, 380 ] 299 0.031% 100.175% ( 380, 580 ] 222 0.023% 100.198% ( 580, 870 ] 176 0.018% 100.216% ( 870, 1300 ] 128 0.013% 100.229% ( 1300, 1900 ] 52 0.005% 100.235% ( 1900, 2900 ] 53 0.005% 100.240% ( 2900, 4400 ] 112 0.011% 100.251% ( 4400, 6600 ] 24 0.002% 100.254% ( 6600, 9900 ] 10 0.001% 100.255% ( 9900, 14000 ] 1 0.000% 100.255% ** Level 4 read latency histogram (micros): Count: 30535 Average: 75.2465 StdDev: 484.17 Min: 1 Median: 1.9691 Max: 43247 Percentiles: P50: 1.97 P75: 3.24 P99: 1764.12 P99.9: 5364.33 P99.99: 9060.29 ------------------------------------------------------ [ 0, 1 ] 755 2.473% 2.473% ( 1, 2 ] 14976 49.045% 51.518% ########## ( 2, 3 ] 6328 20.724% 72.242% #### ( 3, 4 ] 3570 11.692% 83.933% ## ( 4, 6 ] 2049 6.710% 90.644% # ( 6, 10 ] 637 2.086% 92.730% ( 10, 15 ] 144 0.472% 93.201% ( 15, 22 ] 20 0.065% 93.267% ( 22, 34 ] 12 0.039% 93.306% ( 51, 76 ] 18 0.059% 93.365% ( 76, 110 ] 36 0.118% 93.483% ( 110, 170 ] 65 0.213% 93.696% ( 170, 250 ] 144 0.472% 94.167% ( 250, 380 ] 223 0.730% 94.898% ( 380, 580 ] 360 1.179% 96.077% ( 580, 870 ] 416 1.362% 97.439% ( 870, 1300 ] 332 1.087% 98.526% ( 1300, 1900 ] 187 0.612% 99.139% ( 1900, 2900 ] 113 0.370% 99.509% ( 2900, 4400 ] 105 0.344% 99.853% ( 4400, 6600 ] 33 0.108% 99.961% ( 6600, 9900 ] 12 0.039% 100.000% ( 14000, 22000 ] 3 0.010% 100.010% ( 33000, 50000 ] 1 0.003% 100.013% ** Level 5 read latency histogram (micros): Count: 200 Average: 1531.6750 StdDev: 1758.20 Min: 81 Median: 604.1667 Max: 9703 Percentiles: P50: 604.17 P75: 2566.67 P99: 6600.00 P99.9: 9570.00 P99.99: 9703.00 ------------------------------------------------------ ( 76, 110 ] 10 5.000% 5.000% # ( 110, 170 ] 23 11.500% 16.500% ## ( 170, 250 ] 21 10.500% 27.000% ## ( 250, 380 ] 27 13.500% 40.500% ### ( 380, 580 ] 18 9.000% 49.500% ## ( 580, 870 ] 12 6.000% 55.500% # ( 870, 1300 ] 13 6.500% 62.000% # ( 1300, 1900 ] 12 6.000% 68.000% # ( 1900, 2900 ] 21 10.500% 78.500% ## ( 2900, 4400 ] 29 14.500% 93.000% ### ( 4400, 6600 ] 12 6.000% 99.000% # ( 6600, 9900 ] 2 1.000% 100.000% ** DB Stats ** Uptime(secs): 46.2 total, 3.0 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 191.69 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:21.048 H:M:S, 45.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 325.75 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.414 H:M:S, 13.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/06-13:43:38 ... thread 0: (1000000,10000000) ops and (77878.1,169977.8) ops/second in (12.840578,58.831220) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/10 2.34 GB 6.3 8.2 0.0 8.2 17.8 9.5 0.0 1.9 139.8 301.3 60.39 55.89 166 0.364 8570K 12K 0.0 0.0 L1 15/15 1.81 GB 0.0 10.6 6.9 3.7 10.5 6.8 0.2 1.5 218.8 216.0 49.73 45.38 5 9.945 9299K 87K 0.0 0.0 L2 2/1 257.56 MB 1.3 0.4 0.2 0.2 0.4 0.2 5.2 2.0 249.0 248.9 1.52 1.46 2 0.759 383K 204 0.0 0.0 L3 28/6 1.46 GB 0.9 6.7 4.1 2.7 6.7 4.0 1.1 1.6 156.7 155.7 44.06 31.11 28 1.574 7014K 47K 0.0 0.0 L4 182/17 9.93 GB 1.0 3.8 3.5 0.3 3.8 3.5 0.9 1.1 138.1 137.8 28.03 17.91 43 0.652 3831K 4334 0.0 0.0 L5 1092/0 89.69 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 1330/49 105.47 GB 0.0 29.8 14.7 15.1 39.1 24.0 11.3 4.1 165.9 217.9 183.72 151.75 244 0.753 29M 151K 0.0 0.0 Int 0/0 0.00 KB 0.0 29.8 14.7 15.1 39.1 24.0 11.2 4.1 165.9 217.9 183.72 151.75 244 0.753 29M 151K 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 29.8 14.7 15.1 29.6 14.5 0.0 0.0 196.7 195.4 154.94 126.85 106 1.462 29M 151K 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.3 28.78 24.91 138 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): 59.0 total, 58.8 interval Flush(GB): cumulative 9.536, interval 9.536 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 39.10 GB write, 677.99 MB/s write, 29.76 GB read, 516.14 MB/s read, 183.7 seconds Interval compaction: 39.10 GB write, 680.48 MB/s write, 29.76 GB read, 518.04 MB/s read, 183.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 23, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 23, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 35, pending-compaction-bytes-delays: 61, pending-compaction-bytes-stops: 0, total-delays: 84, total-stops: 35, interval: 119 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4127504 Average: 2.8082 StdDev: 38.48 Min: 0 Median: 1.5003 Max: 41559 Percentiles: P50: 1.50 P75: 1.89 P99: 6.45 P99.9: 118.94 P99.99: 448.18 ------------------------------------------------------ [ 0, 1 ] 732680 17.751% 17.751% #### ( 1, 2 ] 2660704 64.463% 82.214% ############# ( 2, 3 ] 419653 10.167% 92.381% ## ( 3, 4 ] 154215 3.736% 96.117% # ( 4, 6 ] 115518 2.799% 98.916% # ( 6, 10 ] 31093 0.753% 99.670% ( 10, 15 ] 4812 0.117% 99.786% ( 15, 22 ] 516 0.013% 99.799% ( 22, 34 ] 44 0.001% 99.800% ( 34, 51 ] 23 0.001% 99.800% ( 51, 76 ] 489 0.012% 99.812% ( 76, 110 ] 3238 0.078% 99.891% ( 110, 170 ] 2633 0.064% 99.954% ( 170, 250 ] 698 0.017% 99.971% ( 250, 380 ] 585 0.014% 99.985% ( 380, 580 ] 561 0.014% 99.999% ( 580, 870 ] 422 0.010% 100.009% ( 870, 1300 ] 258 0.006% 100.015% ( 1300, 1900 ] 119 0.003% 100.018% ( 1900, 2900 ] 83 0.002% 100.020% ( 2900, 4400 ] 86 0.002% 100.022% ( 4400, 6600 ] 20 0.000% 100.023% ( 6600, 9900 ] 3 0.000% 100.023% ( 9900, 14000 ] 2 0.000% 100.023% ( 14000, 22000 ] 1 0.000% 100.023% ( 22000, 33000 ] 1 0.000% 100.023% ( 33000, 50000 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 2087957 Average: 4.5668 StdDev: 90.78 Min: 0 Median: 1.6578 Max: 43567 Percentiles: P50: 1.66 P75: 2.43 P99: 8.86 P99.9: 102.14 P99.99: 182.09 ------------------------------------------------------ [ 0, 1 ] 293829 14.073% 14.073% ### ( 1, 2 ] 1140401 54.618% 68.691% ########### ( 2, 3 ] 308501 14.775% 83.466% ### ( 3, 4 ] 147362 7.058% 90.524% # ( 4, 6 ] 150411 7.204% 97.727% # ( 6, 10 ] 37200 1.782% 99.509% ( 10, 15 ] 5911 0.283% 99.792% ( 15, 22 ] 731 0.035% 99.827% ( 22, 34 ] 53 0.003% 99.830% ( 34, 51 ] 33 0.002% 99.831% ( 51, 76 ] 320 0.015% 99.847% ( 76, 110 ] 1453 0.070% 99.916% ( 110, 170 ] 1479 0.071% 99.987% ( 170, 250 ] 425 0.020% 100.007% ( 250, 380 ] 550 0.026% 100.034% ( 380, 580 ] 649 0.031% 100.065% ( 580, 870 ] 630 0.030% 100.095% ( 870, 1300 ] 481 0.023% 100.118% ( 1300, 1900 ] 208 0.010% 100.128% ( 1900, 2900 ] 183 0.009% 100.137% ( 2900, 4400 ] 262 0.013% 100.149% ( 4400, 6600 ] 66 0.003% 100.152% ( 6600, 9900 ] 24 0.001% 100.153% ( 9900, 14000 ] 3 0.000% 100.154% ( 22000, 33000 ] 3 0.000% 100.154% ( 33000, 50000 ] 3 0.000% 100.154% ** Level 2 read latency histogram (micros): Count: 111907 Average: 2.3707 StdDev: 18.36 Min: 1 Median: 1.4619 Max: 2868 Percentiles: P50: 1.46 P75: 1.87 P99: 5.96 P99.9: 13.93 P99.99: 638.67 ------------------------------------------------------ [ 0, 1 ] 24204 21.629% 21.629% #### ( 1, 2 ] 68732 61.419% 83.048% ############ ( 2, 3 ] 10319 9.221% 92.269% ## ( 3, 4 ] 4412 3.943% 96.211% # ( 4, 6 ] 3180 2.842% 99.053% # ( 6, 10 ] 871 0.778% 99.831% ( 10, 15 ] 98 0.088% 99.919% ( 15, 22 ] 6 0.005% 99.924% ( 22, 34 ] 6 0.005% 99.929% ( 34, 51 ] 1 0.001% 99.930% ( 51, 76 ] 1 0.001% 99.931% ( 76, 110 ] 5 0.004% 99.936% ( 110, 170 ] 37 0.033% 99.969% ( 170, 250 ] 9 0.008% 99.977% ( 250, 380 ] 6 0.005% 99.982% ( 380, 580 ] 8 0.007% 99.989% ( 580, 870 ] 4 0.004% 99.993% ( 870, 1300 ] 4 0.004% 99.996% ( 1900, 2900 ] 4 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 1527470 Average: 4.7297 StdDev: 69.06 Min: 0 Median: 1.9546 Max: 13343 Percentiles: P50: 1.95 P75: 3.00 P99: 8.65 P99.9: 13.07 P99.99: 14.35 ------------------------------------------------------ [ 0, 1 ] 34366 2.250% 2.250% ( 1, 2 ] 764061 50.021% 52.271% ########## ( 2, 3 ] 346448 22.681% 74.952% ##### ( 3, 4 ] 174125 11.400% 86.352% ## ( 4, 6 ] 172742 11.309% 97.661% ## ( 6, 10 ] 30909 2.024% 99.685% ( 10, 15 ] 5364 0.351% 100.036% ( 15, 22 ] 684 0.045% 100.080% ( 22, 34 ] 75 0.005% 100.085% ( 34, 51 ] 25 0.002% 100.087% ( 51, 76 ] 62 0.004% 100.091% ( 76, 110 ] 213 0.014% 100.105% ( 110, 170 ] 374 0.024% 100.129% ( 170, 250 ] 376 0.025% 100.154% ( 250, 380 ] 477 0.031% 100.185% ( 380, 580 ] 444 0.029% 100.214% ( 580, 870 ] 378 0.025% 100.239% ( 870, 1300 ] 282 0.018% 100.258% ( 1300, 1900 ] 129 0.008% 100.266% ( 1900, 2900 ] 121 0.008% 100.274% ( 2900, 4400 ] 190 0.012% 100.286% ( 4400, 6600 ] 56 0.004% 100.290% ( 6600, 9900 ] 19 0.001% 100.291% ( 9900, 14000 ] 4 0.000% 100.292% ** Level 4 read latency histogram (micros): Count: 117096 Average: 44.7044 StdDev: 336.76 Min: 1 Median: 2.1020 Max: 43247 Percentiles: P50: 2.10 P75: 3.39 P99: 1181.91 P99.9: 4043.64 P99.99: 5566.30 ------------------------------------------------------ [ 0, 1 ] 1747 1.492% 1.492% ( 1, 2 ] 54115 46.214% 47.706% ######### ( 2, 3 ] 26334 22.489% 70.195% #### ( 3, 4 ] 14506 12.388% 82.584% ## ( 4, 6 ] 12148 10.374% 92.958% ## ( 6, 10 ] 3057 2.611% 95.569% # ( 10, 15 ] 623 0.532% 96.101% ( 15, 22 ] 76 0.065% 96.166% ( 22, 34 ] 24 0.020% 96.186% ( 34, 51 ] 12 0.010% 96.196% ( 51, 76 ] 33 0.028% 96.224% ( 76, 110 ] 62 0.053% 96.277% ( 110, 170 ] 164 0.140% 96.417% ( 170, 250 ] 313 0.267% 96.685% ( 250, 380 ] 506 0.432% 97.117% ( 380, 580 ] 771 0.658% 97.775% ( 580, 870 ] 927 0.792% 98.567% ( 870, 1300 ] 699 0.597% 99.164% ( 1300, 1900 ] 393 0.336% 99.500% ( 1900, 2900 ] 260 0.222% 99.722% ( 2900, 4400 ] 274 0.234% 99.956% ( 4400, 6600 ] 76 0.065% 100.020% ( 6600, 9900 ] 21 0.018% 100.038% ( 9900, 14000 ] 1 0.001% 100.039% ( 14000, 22000 ] 3 0.003% 100.042% ( 33000, 50000 ] 1 0.001% 100.043% ** Level 5 read latency histogram (micros): Count: 240 Average: 1523.1875 StdDev: 1714.98 Min: 81 Median: 652.5000 Max: 9703 Percentiles: P50: 652.50 P75: 2566.67 P99: 6537.14 P99.9: 9504.00 P99.99: 9703.00 ------------------------------------------------------ ( 76, 110 ] 11 4.583% 4.583% # ( 110, 170 ] 27 11.250% 15.833% ## ( 170, 250 ] 23 9.583% 25.417% ## ( 250, 380 ] 30 12.500% 37.917% ### ( 380, 580 ] 25 10.417% 48.333% ## ( 580, 870 ] 16 6.667% 55.000% # ( 870, 1300 ] 18 7.500% 62.500% ## ( 1300, 1900 ] 14 5.833% 68.333% # ( 1900, 2900 ] 24 10.000% 78.333% ## ( 2900, 4400 ] 36 15.000% 93.333% ### ( 4400, 6600 ] 14 5.833% 99.167% # ( 6600, 9900 ] 2 0.833% 100.000% ** DB Stats ** Uptime(secs): 59.1 total, 12.8 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 166.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:31.133 H:M:S, 52.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 76.65 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:10.085 H:M:S, 78.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 7 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.820 micros/op 171829 ops/sec 60.001 seconds 10309999 operations; 166.5 MB/s Microseconds per write: Count: 10309999 Average: 5.8197 StdDev: 281.76 Min: 0 Median: 1.7403 Max: 238985 Percentiles: P50: 1.74 P75: 2.76 P99: 9.33 P99.9: 1145.60 P99.99: 2716.71 ------------------------------------------------------ [ 0, 1 ] 1366767 13.257% 13.257% ### ( 1, 2 ] 5117065 49.632% 62.889% ########## ( 2, 3 ] 1634051 15.849% 78.738% ### ( 3, 4 ] 1424919 13.821% 92.559% ### ( 4, 6 ] 566396 5.494% 98.052% # ( 6, 10 ] 117296 1.138% 99.190% ( 10, 15 ] 39011 0.378% 99.568% ( 15, 22 ] 10055 0.098% 99.666% ( 22, 34 ] 2091 0.020% 99.686% ( 34, 51 ] 219 0.002% 99.688% ( 51, 76 ] 36 0.000% 99.689% ( 76, 110 ] 6869 0.067% 99.755% ( 110, 170 ] 3112 0.030% 99.786% ( 170, 250 ] 344 0.003% 99.789% ( 250, 380 ] 180 0.002% 99.791% ( 380, 580 ] 39 0.000% 99.791% ( 580, 870 ] 26 0.000% 99.791% ( 870, 1300 ] 17495 0.170% 99.961% ( 1300, 1900 ] 181 0.002% 99.963% ( 1900, 2900 ] 3448 0.033% 99.996% ( 2900, 4400 ] 272 0.003% 99.999% ( 4400, 6600 ] 74 0.001% 99.999% ( 6600, 9900 ] 24 0.000% 100.000% ( 9900, 14000 ] 4 0.000% 100.000% ( 14000, 22000 ] 3 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 17 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 : 223315 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 : 10309999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10639918968 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 : 651 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31345178 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 : 34222139226 rocksdb.compact.write.bytes COUNT : 33990586975 rocksdb.flush.write.bytes COUNT : 10569216716 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 : 70 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 : 320 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 : 10484041728 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4116480 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 : 34325514454 rocksdb.non.last.level.read.count COUNT : 8290808 rocksdb.block.checksum.compute.count COUNT : 8289576 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.386262 P95 : 3.918550 P99 : 7.838923 P100 : 238982.000000 COUNT : 10309999 SUM : 55132791 rocksdb.compaction.times.micros P50 : 972045.454545 P95 : 2825000.000000 P99 : 17400000.000000 P100 : 18916428.000000 COUNT : 115 SUM : 163402588 rocksdb.compaction.times.cpu_micros P50 : 809250.000000 P95 : 2150000.000000 P99 : 17400000.000000 P100 : 17406359.000000 COUNT : 115 SUM : 133146479 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 : 700.000000 P95 : 1266.214286 P99 : 5676.000000 P100 : 7571.000000 COUNT : 142 SUM : 112819 rocksdb.compaction.outfile.sync.micros P50 : 1188.020833 P95 : 118769.230769 P99 : 228488.888889 P100 : 285976.000000 COUNT : 442 SUM : 8153230 rocksdb.wal.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.manifest.file.sync.micros P50 : 98.173913 P95 : 1085.000000 P99 : 2600.000000 P100 : 4060.000000 COUNT : 290 SUM : 74477 rocksdb.table.open.io.micros P50 : 1347.727273 P95 : 7717.500000 P99 : 13264.928571 P100 : 21955.000000 COUNT : 651 SUM : 1363380 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.666538 P95 : 8.068888 P99 : 11.165110 P100 : 43574.000000 COUNT : 8287952 SUM : 52722280 rocksdb.read.block.get.micros P50 : 430.314465 P95 : 3578.000000 P99 : 5498.000000 P100 : 9852.000000 COUNT : 1302 SUM : 1102331 rocksdb.write.raw.block.micros P50 : 0.513098 P95 : 0.974886 P99 : 2.940087 P100 : 12655.000000 COUNT : 10793139 SUM : 21005758 rocksdb.numfiles.in.singlecompaction P50 : 2.604167 P95 : 5.833333 P99 : 27.400000 P100 : 32.000000 COUNT : 165 SUM : 588 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.555244 P95 : 1130.294447 P99 : 2364.884739 P100 : 238761.000000 COUNT : 216684 SUM : 31363475 rocksdb.sst.read.micros P50 : 1.628284 P95 : 4.920950 P99 : 8.595234 P100 : 43567.000000 COUNT : 8291404 SUM : 35875969 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 : 10309999 SUM : 10639918968 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 : 214528.301887 P95 : 359850.000000 P99 : 483348.000000 P100 : 483348.000000 COUNT : 142 SUM : 29863482 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 : 411 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