[2024-12-16 04:51:31.225936] Starting SPDK v24.09.1-pre git sha1 b18e1bd62 / DPDK 22.11.4 initialization... [2024-12-16 04:51:31.226238] [ 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_pid1207037 ] Set seed to 1734321091219250 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-16 04:51:31.321671] app.c: 917:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-16 04:51:31.359782] app.c: 610:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-16 04:51:31.359826] app.c: 611:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1207037' to capture a snapshot of events at runtime. [2024-12-16 04:51:31.359837] app.c: 616:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-16 04:51:31.359863] app.c: 617:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-16 04:51:31.359871] app.c: 618:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1207037 for offline analysis/debug. [2024-12-16 04:51:31.359965] reactor.c: 990:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Mon Dec 16 04:51:35 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/16-04:51:38 ... thread 0: (1000000,1000000) ops and (356467.9,356467.9) ops/second in (2.805302,2.805302) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/6 504.02 MB 12.6 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 355.4 2.30 2.09 12 0.192 0 0 0.0 0.0 L1 1/0 2.49 MB 0.2 0.2 0.2 0.1 0.2 0.2 0.1 1.3 243.7 243.5 1.03 1.00 1 1.034 255K 189 0.0 0.0 L2 3/1 298.26 MB 2.5 0.1 0.1 0.0 0.1 0.1 0.3 1.8 216.9 216.8 0.51 0.48 1 0.514 113K 35 0.0 0.0 L3 19/12 1007.30 MB 0.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 194.5 194.5 0.32 0.26 1 0.321 63K 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 85.57 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 1187/19 96.94 GB 0.0 0.4 0.3 0.1 1.2 1.1 0.4 1.5 102.0 298.2 4.17 3.83 15 0.278 432K 224 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.2 1.1 0.4 1.5 102.0 298.2 4.17 3.83 15 0.278 432K 224 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.3 0.1 0.4 0.3 0.0 0.0 227.9 227.7 1.87 1.74 3 0.623 432K 224 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 355.4 2.30 2.09 12 0.192 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 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.22 GB write, 413.73 MB/s write, 0.42 GB read, 141.55 MB/s read, 4.2 seconds Interval compaction: 1.22 GB write, 443.41 MB/s write, 0.42 GB read, 151.70 MB/s read, 4.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 114865 Average: 1.8622 StdDev: 11.91 Min: 0 Median: 1.2294 Max: 2982 Percentiles: P50: 1.23 P75: 1.68 P99: 4.65 P99.9: 9.59 P99.99: 166.76 ------------------------------------------------------ [ 0, 1 ] 42702 37.176% 37.176% ####### ( 1, 2 ] 64209 55.900% 93.075% ########### ( 2, 3 ] 4786 4.167% 97.242% # ( 3, 4 ] 1668 1.452% 98.694% ( 4, 6 ] 1091 0.950% 99.644% ( 6, 10 ] 330 0.287% 99.931% ( 10, 15 ] 52 0.045% 99.976% ( 15, 22 ] 6 0.005% 99.982% ( 22, 34 ] 1 0.001% 99.983% ( 34, 51 ] 1 0.001% 99.983% ( 51, 76 ] 1 0.001% 99.984% ( 110, 170 ] 9 0.008% 99.992% ( 170, 250 ] 3 0.003% 99.995% ( 250, 380 ] 5 0.004% 99.999% ( 580, 870 ] 2 0.002% 100.001% ( 870, 1300 ] 3 0.003% 100.003% ( 1300, 1900 ] 1 0.001% 100.004% ( 2900, 4400 ] 1 0.001% 100.005% ** Level 1 read latency histogram (micros): Count: 12316 Average: 3.5102 StdDev: 28.93 Min: 1 Median: 1.2309 Max: 1057 Percentiles: P50: 1.23 P75: 1.73 P99: 10.97 P99.9: 485.26 P99.99: 1057.00 ------------------------------------------------------ [ 0, 1 ] 4747 38.543% 38.543% ######## ( 1, 2 ] 6112 49.627% 88.170% ########## ( 2, 3 ] 857 6.958% 95.128% # ( 3, 4 ] 193 1.567% 96.695% ( 4, 6 ] 165 1.340% 98.035% ( 6, 10 ] 114 0.926% 98.961% ( 10, 15 ] 25 0.203% 99.164% ( 15, 22 ] 6 0.049% 99.212% ( 22, 34 ] 1 0.008% 99.221% ( 34, 51 ] 17 0.138% 99.359% ( 51, 76 ] 29 0.235% 99.594% ( 76, 110 ] 7 0.057% 99.651% ( 110, 170 ] 4 0.032% 99.683% ( 170, 250 ] 10 0.081% 99.765% ( 250, 380 ] 13 0.106% 99.870% ( 380, 580 ] 7 0.057% 99.927% ( 580, 870 ] 4 0.032% 99.959% ( 870, 1300 ] 5 0.041% 100.000% ** Level 2 read latency histogram (micros): Count: 15855 Average: 1.7803 StdDev: 3.18 Min: 1 Median: 1.1984 Max: 306 Percentiles: P50: 1.20 P75: 1.66 P99: 4.98 P99.9: 9.86 P99.99: 203.16 ------------------------------------------------------ [ 0, 1 ] 6235 39.325% 39.325% ######## ( 1, 2 ] 8530 53.800% 93.125% ########### ( 2, 3 ] 632 3.986% 97.111% # ( 3, 4 ] 211 1.331% 98.442% ( 4, 6 ] 180 1.135% 99.577% ( 6, 10 ] 53 0.334% 99.912% ( 10, 15 ] 7 0.044% 99.956% ( 15, 22 ] 3 0.019% 99.975% ( 22, 34 ] 1 0.006% 99.981% ( 110, 170 ] 1 0.006% 99.987% ( 170, 250 ] 1 0.006% 99.994% ( 250, 380 ] 1 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 16757 Average: 9.4800 StdDev: 129.28 Min: 1 Median: 2.2478 Max: 6042 Percentiles: P50: 2.25 P75: 3.19 P99: 13.83 P99.9: 1009.45 P99.99: 2454.05 ------------------------------------------------------ [ 0, 1 ] 1134 6.767% 6.767% # ( 1, 2 ] 6009 35.860% 42.627% ####### ( 2, 3 ] 4986 29.755% 72.382% ###### ( 3, 4 ] 2295 13.696% 86.077% ### ( 4, 6 ] 1446 8.629% 94.707% ## ( 6, 10 ] 629 3.754% 98.460% # ( 10, 15 ] 118 0.704% 99.165% ( 15, 22 ] 21 0.125% 99.290% ( 22, 34 ] 6 0.036% 99.326% ( 34, 51 ] 3 0.018% 99.344% ( 110, 170 ] 29 0.173% 99.517% ( 170, 250 ] 19 0.113% 99.630% ( 250, 380 ] 12 0.072% 99.702% ( 380, 580 ] 22 0.131% 99.833% ( 580, 870 ] 8 0.048% 99.881% ( 870, 1300 ] 10 0.060% 99.940% ( 1300, 1900 ] 5 0.030% 99.970% ( 1900, 2900 ] 6 0.036% 100.006% ( 2900, 4400 ] 6 0.036% 100.042% ( 4400, 6600 ] 5 0.030% 100.072% ** Level 4 read latency histogram (micros): Count: 20 Average: 1778.7500 StdDev: 1527.72 Min: 353 Median: 1156.6667 Max: 5344 Percentiles: P50: 1156.67 P75: 2900.00 P99: 5344.00 P99.9: 5344.00 P99.99: 5344.00 ------------------------------------------------------ ( 250, 380 ] 2 10.000% 10.000% ## ( 380, 580 ] 2 10.000% 20.000% ## ( 580, 870 ] 4 20.000% 40.000% #### ( 870, 1300 ] 3 15.000% 55.000% ### ( 1300, 1900 ] 3 15.000% 70.000% ### ( 1900, 2900 ] 1 5.000% 75.000% # ( 2900, 4400 ] 3 15.000% 90.000% ### ( 4400, 6600 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 327.16 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.211 H:M:S, 7.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 350.53 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.211 H:M:S, 7.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/16-04:51:41 ... thread 0: (1000000,2000000) ops and (318244.6,336273.5) ops/second in (3.142237,5.947539) 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/9 1.48 GB 31.5 0.9 0.0 0.9 2.6 1.8 0.0 1.5 101.8 312.6 8.66 8.02 29 0.299 895K 1130 0.0 0.0 L1 1/1 2.49 MB 0.0 0.2 0.2 0.1 0.2 0.2 0.1 1.3 243.7 243.5 1.03 1.00 1 1.034 255K 189 0.0 0.0 L2 2/1 169.50 MB 1.2 0.1 0.1 0.0 0.1 0.1 0.3 1.8 216.9 216.8 0.51 0.48 1 0.514 113K 35 0.0 0.0 L3 19/11 1.05 GB 0.1 0.1 0.1 0.0 0.1 0.1 0.1 1.0 194.5 194.5 0.32 0.26 1 0.321 63K 0 0.0 0.0 L4 173/0 9.65 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 60.0 60.1 0.93 0.58 1 0.934 56K 0 0.0 0.0 L5 1040/0 85.57 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 1246/22 97.92 GB 0.0 1.3 0.4 1.0 3.1 2.1 0.5 1.7 119.0 278.2 11.46 10.33 33 0.347 1384K 1354 0.0 0.0 Int 0/0 0.00 KB 0.0 1.3 0.4 1.0 3.1 2.1 0.5 1.7 119.0 278.2 11.46 10.33 33 0.347 1384K 1354 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.3 0.4 1.0 1.3 0.4 0.0 0.0 217.9 217.7 6.26 5.68 7 0.894 1384K 1354 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 350.9 5.21 4.66 26 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.2 total, 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.11 GB write, 518.58 MB/s write, 1.33 GB read, 221.76 MB/s read, 11.5 seconds Interval compaction: 3.11 GB write, 536.13 MB/s write, 1.33 GB read, 229.27 MB/s read, 11.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 8, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 8, interval: 8 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 436064 Average: 2.2421 StdDev: 12.57 Min: 0 Median: 1.5115 Max: 3319 Percentiles: P50: 1.51 P75: 1.90 P99: 5.68 P99.9: 9.96 P99.99: 14.20 ------------------------------------------------------ [ 0, 1 ] 74628 17.114% 17.114% ### ( 1, 2 ] 280339 64.288% 81.403% ############# ( 2, 3 ] 49176 11.277% 92.680% ## ( 3, 4 ] 17695 4.058% 96.738% # ( 4, 6 ] 11739 2.692% 99.430% # ( 6, 10 ] 2075 0.476% 99.906% ( 10, 15 ] 441 0.101% 100.007% ( 15, 22 ] 37 0.008% 100.015% ( 22, 34 ] 4 0.001% 100.016% ( 34, 51 ] 2 0.000% 100.017% ( 51, 76 ] 3 0.001% 100.017% ( 76, 110 ] 1 0.000% 100.017% ( 110, 170 ] 14 0.003% 100.021% ( 170, 250 ] 10 0.002% 100.023% ( 250, 380 ] 13 0.003% 100.026% ( 380, 580 ] 1 0.000% 100.026% ( 580, 870 ] 5 0.001% 100.027% ( 870, 1300 ] 7 0.002% 100.029% ( 1300, 1900 ] 3 0.001% 100.030% ( 1900, 2900 ] 2 0.000% 100.030% ( 2900, 4400 ] 4 0.001% 100.031% ** Level 1 read latency histogram (micros): Count: 12317 Average: 3.5103 StdDev: 28.93 Min: 1 Median: 1.2309 Max: 1057 Percentiles: P50: 1.23 P75: 1.73 P99: 10.97 P99.9: 485.23 P99.99: 1057.00 ------------------------------------------------------ [ 0, 1 ] 4747 38.540% 38.540% ######## ( 1, 2 ] 6112 49.622% 88.163% ########## ( 2, 3 ] 857 6.958% 95.121% # ( 3, 4 ] 194 1.575% 96.696% ( 4, 6 ] 165 1.340% 98.035% ( 6, 10 ] 114 0.926% 98.961% ( 10, 15 ] 25 0.203% 99.164% ( 15, 22 ] 6 0.049% 99.212% ( 22, 34 ] 1 0.008% 99.221% ( 34, 51 ] 17 0.138% 99.359% ( 51, 76 ] 29 0.235% 99.594% ( 76, 110 ] 7 0.057% 99.651% ( 110, 170 ] 4 0.032% 99.683% ( 170, 250 ] 10 0.081% 99.765% ( 250, 380 ] 13 0.106% 99.870% ( 380, 580 ] 7 0.057% 99.927% ( 580, 870 ] 4 0.032% 99.959% ( 870, 1300 ] 5 0.041% 100.000% ** Level 2 read latency histogram (micros): Count: 15971 Average: 1.7882 StdDev: 3.17 Min: 1 Median: 1.2044 Max: 306 Percentiles: P50: 1.20 P75: 1.67 P99: 4.99 P99.9: 9.85 P99.99: 202.23 ------------------------------------------------------ [ 0, 1 ] 6235 39.040% 39.040% ######## ( 1, 2 ] 8565 53.628% 92.668% ########### ( 2, 3 ] 699 4.377% 97.045% # ( 3, 4 ] 222 1.390% 98.435% ( 4, 6 ] 182 1.140% 99.574% ( 6, 10 ] 54 0.338% 99.912% ( 10, 15 ] 7 0.044% 99.956% ( 15, 22 ] 3 0.019% 99.975% ( 22, 34 ] 1 0.006% 99.981% ( 110, 170 ] 1 0.006% 99.987% ( 170, 250 ] 1 0.006% 99.994% ( 250, 380 ] 1 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 213106 Average: 3.6254 StdDev: 39.67 Min: 1 Median: 1.6695 Max: 6042 Percentiles: P50: 1.67 P75: 2.31 P99: 9.33 P99.9: 245.21 P99.99: 810.97 ------------------------------------------------------ [ 0, 1 ] 21978 10.313% 10.313% ## ( 1, 2 ] 126319 59.275% 69.588% ############ ( 2, 3 ] 37135 17.426% 87.014% ### ( 3, 4 ] 12897 6.052% 93.066% # ( 4, 6 ] 8997 4.222% 97.288% # ( 6, 10 ] 4378 2.054% 99.342% ( 10, 15 ] 512 0.240% 99.582% ( 15, 22 ] 113 0.053% 99.635% ( 22, 34 ] 49 0.023% 99.658% ( 34, 51 ] 10 0.005% 99.663% ( 51, 76 ] 7 0.003% 99.666% ( 76, 110 ] 147 0.069% 99.735% ( 110, 170 ] 255 0.120% 99.855% ( 170, 250 ] 102 0.048% 99.903% ( 250, 380 ] 85 0.040% 99.943% ( 380, 580 ] 76 0.036% 99.978% ( 580, 870 ] 31 0.015% 99.993% ( 870, 1300 ] 19 0.009% 100.002% ( 1300, 1900 ] 7 0.003% 100.005% ( 1900, 2900 ] 6 0.003% 100.008% ( 2900, 4400 ] 6 0.003% 100.011% ( 4400, 6600 ] 5 0.002% 100.013% ** Level 4 read latency histogram (micros): Count: 305 Average: 122.7213 StdDev: 588.52 Min: 1 Median: 2.7325 Max: 5344 Percentiles: P50: 2.73 P75: 3.79 P99: 3875.00 P99.9: 5344.00 P99.99: 5344.00 ------------------------------------------------------ [ 0, 1 ] 13 4.262% 4.262% # ( 1, 2 ] 56 18.361% 22.623% #### ( 2, 3 ] 114 37.377% 60.000% ####### ( 3, 4 ] 58 19.016% 79.016% #### ( 4, 6 ] 28 9.180% 88.197% ## ( 6, 10 ] 10 3.279% 91.475% # ( 15, 22 ] 2 0.656% 92.131% ( 22, 34 ] 1 0.328% 92.459% ( 170, 250 ] 2 0.656% 93.115% ( 250, 380 ] 2 0.656% 93.770% ( 380, 580 ] 3 0.984% 94.754% ( 580, 870 ] 4 1.311% 96.066% ( 870, 1300 ] 3 0.984% 97.049% ( 1300, 1900 ] 3 0.984% 98.033% ( 1900, 2900 ] 1 0.328% 98.361% ( 2900, 4400 ] 3 0.984% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** DB Stats ** Uptime(secs): 6.2 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 320.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:0.628 H:M:S, 10.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 313.22 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.417 H:M:S, 13.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/16-04:51:44 ... thread 0: (1000000,3000000) ops and (324598.6,332289.7) ops/second in (3.080728,9.028267) 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/4 1.60 GB 138.5 1.7 0.0 1.7 4.5 2.8 0.0 1.6 117.3 305.7 15.03 13.95 46 0.327 1791K 2118 0.0 0.0 L1 4/0 431.77 MB 43.2 1.1 1.0 0.1 1.1 1.0 0.1 1.1 227.3 226.6 5.00 4.81 2 2.498 1152K 3110 0.0 0.0 L2 4/4 448.67 MB 0.0 0.1 0.1 0.0 0.1 0.1 0.7 1.8 216.9 216.8 0.51 0.48 1 0.514 113K 35 0.0 0.0 L3 20/1 991.33 MB 0.9 1.2 0.2 1.0 1.2 0.2 0.1 5.4 226.2 226.1 5.52 5.00 3 1.839 1267K 605 0.0 0.0 L4 173/0 9.53 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.3 1.0 60.0 60.1 0.93 0.58 1 0.934 56K 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1256/9 98.90 GB 0.0 4.2 1.4 2.8 7.0 4.2 1.6 2.5 159.8 264.6 26.99 24.82 53 0.509 4381K 5868 0.0 0.0 Int 0/0 0.00 KB 0.0 4.2 1.4 2.8 7.0 4.2 1.6 2.5 159.8 264.6 26.99 24.82 53 0.509 4381K 5868 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.2 1.4 2.8 4.2 1.4 0.0 0.0 228.1 227.8 18.92 17.63 13 1.455 4381K 5868 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 350.9 8.08 7.19 40 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.2 total, 9.0 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.98 GB write, 773.83 MB/s write, 4.21 GB read, 467.39 MB/s read, 27.0 seconds Interval compaction: 6.98 GB write, 791.09 MB/s write, 4.21 GB read, 477.81 MB/s read, 27.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 16, interval: 16 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 806285 Average: 2.3151 StdDev: 10.66 Min: 0 Median: 1.5502 Max: 3319 Percentiles: P50: 1.55 P75: 1.93 P99: 5.73 P99.9: 9.90 P99.99: 13.82 ------------------------------------------------------ [ 0, 1 ] 113929 14.130% 14.130% ### ( 1, 2 ] 525689 65.199% 79.329% ############# ( 2, 3 ] 100053 12.409% 91.738% ## ( 3, 4 ] 36735 4.556% 96.294% # ( 4, 6 ] 25195 3.125% 99.419% # ( 6, 10 ] 3982 0.494% 99.913% ( 10, 15 ] 814 0.101% 100.014% ( 15, 22 ] 65 0.008% 100.022% ( 22, 34 ] 7 0.001% 100.023% ( 34, 51 ] 3 0.000% 100.023% ( 51, 76 ] 9 0.001% 100.024% ( 76, 110 ] 71 0.009% 100.033% ( 110, 170 ] 51 0.006% 100.039% ( 170, 250 ] 27 0.003% 100.043% ( 250, 380 ] 31 0.004% 100.047% ( 380, 580 ] 13 0.002% 100.048% ( 580, 870 ] 14 0.002% 100.050% ( 870, 1300 ] 12 0.001% 100.051% ( 1300, 1900 ] 6 0.001% 100.052% ( 1900, 2900 ] 2 0.000% 100.052% ( 2900, 4400 ] 4 0.000% 100.053% ** Level 1 read latency histogram (micros): Count: 91487 Average: 3.0764 StdDev: 18.43 Min: 1 Median: 1.6298 Max: 1162 Percentiles: P50: 1.63 P75: 2.14 P99: 8.08 P99.9: 217.39 P99.99: 972.17 ------------------------------------------------------ [ 0, 1 ] 10309 11.268% 11.268% ## ( 1, 2 ] 56262 61.497% 72.766% ############ ( 2, 3 ] 15065 16.467% 89.232% ### ( 3, 4 ] 5108 5.583% 94.816% # ( 4, 6 ] 3314 3.622% 98.438% # ( 6, 10 ] 989 1.081% 99.519% ( 10, 15 ] 142 0.155% 99.674% ( 15, 22 ] 23 0.025% 99.699% ( 22, 34 ] 2 0.002% 99.702% ( 34, 51 ] 18 0.020% 99.721% ( 51, 76 ] 29 0.032% 99.753% ( 76, 110 ] 39 0.043% 99.796% ( 110, 170 ] 74 0.081% 99.876% ( 170, 250 ] 38 0.042% 99.918% ( 250, 380 ] 25 0.027% 99.945% ( 380, 580 ] 24 0.026% 99.972% ( 580, 870 ] 15 0.016% 99.988% ( 870, 1300 ] 12 0.013% 100.001% ** Level 2 read latency histogram (micros): Count: 28292 Average: 2.1111 StdDev: 2.52 Min: 1 Median: 1.4491 Max: 306 Percentiles: P50: 1.45 P75: 1.88 P99: 5.72 P99.9: 11.02 P99.99: 120.25 ------------------------------------------------------ [ 0, 1 ] 6828 24.134% 24.134% ##### ( 1, 2 ] 16294 57.592% 81.726% ############ ( 2, 3 ] 2880 10.180% 91.906% ## ( 3, 4 ] 1254 4.432% 96.338% # ( 4, 6 ] 874 3.089% 99.427% # ( 6, 10 ] 129 0.456% 99.883% ( 10, 15 ] 23 0.081% 99.965% ( 15, 22 ] 6 0.021% 99.986% ( 22, 34 ] 1 0.004% 99.989% ( 110, 170 ] 1 0.004% 99.993% ( 170, 250 ] 1 0.004% 99.996% ( 250, 380 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 272342 Average: 3.8788 StdDev: 38.43 Min: 1 Median: 1.6677 Max: 6042 Percentiles: P50: 1.67 P75: 2.29 P99: 9.53 P99.9: 327.13 P99.99: 947.48 ------------------------------------------------------ [ 0, 1 ] 26105 9.585% 9.585% ## ( 1, 2 ] 164843 60.528% 70.113% ############ ( 2, 3 ] 46286 16.996% 87.109% ### ( 3, 4 ] 16399 6.021% 93.130% # ( 4, 6 ] 11288 4.145% 97.275% # ( 6, 10 ] 5327 1.956% 99.231% ( 10, 15 ] 599 0.220% 99.451% ( 15, 22 ] 123 0.045% 99.496% ( 22, 34 ] 51 0.019% 99.515% ( 34, 51 ] 11 0.004% 99.519% ( 51, 76 ] 10 0.004% 99.523% ( 76, 110 ] 316 0.116% 99.639% ( 110, 170 ] 432 0.159% 99.797% ( 170, 250 ] 196 0.072% 99.869% ( 250, 380 ] 141 0.052% 99.921% ( 380, 580 ] 127 0.047% 99.968% ( 580, 870 ] 55 0.020% 99.988% ( 870, 1300 ] 32 0.012% 100.000% ( 1300, 1900 ] 11 0.004% 100.004% ( 1900, 2900 ] 7 0.003% 100.006% ( 2900, 4400 ] 6 0.002% 100.008% ( 4400, 6600 ] 5 0.002% 100.010% ** Level 4 read latency histogram (micros): Count: 305 Average: 122.7213 StdDev: 588.52 Min: 1 Median: 2.7325 Max: 5344 Percentiles: P50: 2.73 P75: 3.79 P99: 3875.00 P99.9: 5344.00 P99.99: 5344.00 ------------------------------------------------------ [ 0, 1 ] 13 4.262% 4.262% # ( 1, 2 ] 56 18.361% 22.623% #### ( 2, 3 ] 114 37.377% 60.000% ####### ( 3, 4 ] 58 19.016% 79.016% #### ( 4, 6 ] 28 9.180% 88.197% ## ( 6, 10 ] 10 3.279% 91.475% # ( 15, 22 ] 2 0.656% 92.131% ( 22, 34 ] 1 0.328% 92.459% ( 170, 250 ] 2 0.656% 93.115% ( 250, 380 ] 2 0.656% 93.770% ( 380, 580 ] 3 0.984% 94.754% ( 580, 870 ] 4 1.311% 96.066% ( 870, 1300 ] 3 0.984% 97.049% ( 1300, 1900 ] 3 0.984% 98.033% ( 1900, 2900 ] 1 0.328% 98.361% ( 2900, 4400 ] 3 0.984% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 939.4500 StdDev: 1150.71 Min: 98 Median: 293.3333 Max: 3534 Percentiles: P50: 293.33 P75: 1300.00 P99: 3534.00 P99.9: 3534.00 P99.99: 3534.00 ------------------------------------------------------ ( 76, 110 ] 2 10.000% 10.000% ## ( 110, 170 ] 5 25.000% 35.000% ##### ( 170, 250 ] 2 10.000% 45.000% ## ( 250, 380 ] 3 15.000% 60.000% ### ( 580, 870 ] 1 5.000% 65.000% # ( 870, 1300 ] 2 10.000% 75.000% ## ( 1900, 2900 ] 2 10.000% 85.000% ## ( 2900, 4400 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 9.2 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 319.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:1.055 H:M:S, 11.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.46 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.427 H:M:S, 13.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/16-04:51:47 ... thread 0: (1000000,4000000) ops and (329963.5,331705.1) ops/second in (3.030638,12.058905) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/13 2.52 GB 56.6 2.5 0.0 2.5 6.2 3.7 0.0 1.7 123.7 304.6 20.88 19.44 62 0.337 2622K 3003 0.0 0.0 L1 4/4 431.77 MB 0.0 1.1 1.0 0.1 1.1 1.0 0.1 1.1 227.3 226.6 5.00 4.81 2 2.498 1152K 3110 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.7 1.8 216.9 216.8 0.51 0.48 1 0.514 113K 35 0.0 0.0 L3 22/0 923.68 MB 0.9 1.8 0.7 1.1 1.8 0.7 0.1 2.7 225.4 225.2 8.10 7.46 4 2.024 1853K 1770 0.0 0.0 L4 177/0 9.73 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.8 1.0 60.0 60.1 0.93 0.58 1 0.934 56K 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1266/17 99.82 GB 0.0 5.6 1.8 3.8 9.3 5.5 2.4 2.5 161.3 267.8 35.41 32.77 70 0.506 5799K 7918 0.0 0.0 Int 0/0 0.00 KB 0.0 5.6 1.8 3.8 9.3 5.5 2.4 2.5 161.3 267.8 35.41 32.77 70 0.506 5799K 7918 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.6 1.8 3.8 5.6 1.8 0.0 0.0 231.5 231.2 24.67 23.19 17 1.451 5799K 7918 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 351.7 10.75 9.57 53 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.3 total, 12.1 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.26 GB write, 773.34 MB/s write, 5.58 GB read, 465.75 MB/s read, 35.4 seconds Interval compaction: 9.26 GB write, 786.25 MB/s write, 5.58 GB read, 473.53 MB/s read, 35.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 20, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 20, interval: 20 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1132001 Average: 2.3221 StdDev: 10.66 Min: 0 Median: 1.5507 Max: 3319 Percentiles: P50: 1.55 P75: 1.93 P99: 5.73 P99.9: 9.86 P99.99: 13.74 ------------------------------------------------------ [ 0, 1 ] 154281 13.629% 13.629% ### ( 1, 2 ] 747646 66.046% 79.675% ############# ( 2, 3 ] 140661 12.426% 92.101% ## ( 3, 4 ] 49748 4.395% 96.496% # ( 4, 6 ] 32694 2.888% 99.384% # ( 6, 10 ] 6048 0.534% 99.918% ( 10, 15 ] 1084 0.096% 100.014% ( 15, 22 ] 92 0.008% 100.022% ( 22, 34 ] 10 0.001% 100.023% ( 34, 51 ] 4 0.000% 100.024% ( 51, 76 ] 10 0.001% 100.024% ( 76, 110 ] 86 0.008% 100.032% ( 110, 170 ] 92 0.008% 100.040% ( 170, 250 ] 59 0.005% 100.045% ( 250, 380 ] 53 0.005% 100.050% ( 380, 580 ] 26 0.002% 100.052% ( 580, 870 ] 23 0.002% 100.054% ( 870, 1300 ] 16 0.001% 100.056% ( 1300, 1900 ] 11 0.001% 100.057% ( 1900, 2900 ] 2 0.000% 100.057% ( 2900, 4400 ] 5 0.000% 100.057% ** Level 1 read latency histogram (micros): Count: 190189 Average: 2.6812 StdDev: 13.21 Min: 1 Median: 1.5986 Max: 1162 Percentiles: P50: 1.60 P75: 1.98 P99: 7.57 P99.9: 121.87 P99.99: 750.27 ------------------------------------------------------ [ 0, 1 ] 21125 11.107% 11.107% ## ( 1, 2 ] 123581 64.978% 76.085% ############# ( 2, 3 ] 28008 14.726% 90.812% ### ( 3, 4 ] 8757 4.604% 95.416% # ( 4, 6 ] 5980 3.144% 98.560% # ( 6, 10 ] 2129 1.119% 99.680% ( 10, 15 ] 277 0.146% 99.825% ( 15, 22 ] 34 0.018% 99.843% ( 22, 34 ] 3 0.002% 99.845% ( 34, 51 ] 19 0.010% 99.855% ( 51, 76 ] 30 0.016% 99.871% ( 76, 110 ] 39 0.021% 99.891% ( 110, 170 ] 85 0.045% 99.936% ( 170, 250 ] 40 0.021% 99.957% ( 250, 380 ] 27 0.014% 99.971% ( 380, 580 ] 26 0.014% 99.985% ( 580, 870 ] 17 0.009% 99.994% ( 870, 1300 ] 12 0.006% 100.000% ** Level 2 read latency histogram (micros): Count: 28292 Average: 2.1111 StdDev: 2.52 Min: 1 Median: 1.4491 Max: 306 Percentiles: P50: 1.45 P75: 1.88 P99: 5.72 P99.9: 11.02 P99.99: 120.25 ------------------------------------------------------ [ 0, 1 ] 6828 24.134% 24.134% ##### ( 1, 2 ] 16294 57.592% 81.726% ############ ( 2, 3 ] 2880 10.180% 91.906% ## ( 3, 4 ] 1254 4.432% 96.338% # ( 4, 6 ] 874 3.089% 99.427% # ( 6, 10 ] 129 0.456% 99.883% ( 10, 15 ] 23 0.081% 99.965% ( 15, 22 ] 6 0.021% 99.986% ( 22, 34 ] 1 0.004% 99.989% ( 110, 170 ] 1 0.004% 99.993% ( 170, 250 ] 1 0.004% 99.996% ( 250, 380 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 272397 Average: 3.9045 StdDev: 38.58 Min: 0 Median: 1.6677 Max: 6042 Percentiles: P50: 1.67 P75: 2.29 P99: 9.54 P99.9: 334.50 P99.99: 958.09 ------------------------------------------------------ [ 0, 1 ] 26118 9.588% 9.588% ## ( 1, 2 ] 164857 60.521% 70.109% ############ ( 2, 3 ] 46292 16.994% 87.103% ### ( 3, 4 ] 16399 6.020% 93.124% # ( 4, 6 ] 11288 4.144% 97.268% # ( 6, 10 ] 5327 1.956% 99.223% ( 10, 15 ] 599 0.220% 99.443% ( 15, 22 ] 123 0.045% 99.488% ( 22, 34 ] 51 0.019% 99.507% ( 34, 51 ] 11 0.004% 99.511% ( 51, 76 ] 10 0.004% 99.515% ( 76, 110 ] 316 0.116% 99.631% ( 110, 170 ] 435 0.160% 99.790% ( 170, 250 ] 205 0.075% 99.866% ( 250, 380 ] 144 0.053% 99.919% ( 380, 580 ] 132 0.048% 99.967% ( 580, 870 ] 56 0.021% 99.988% ( 870, 1300 ] 33 0.012% 100.000% ( 1300, 1900 ] 11 0.004% 100.004% ( 1900, 2900 ] 7 0.003% 100.006% ( 2900, 4400 ] 6 0.002% 100.008% ( 4400, 6600 ] 5 0.002% 100.010% ** Level 4 read latency histogram (micros): Count: 305 Average: 122.7213 StdDev: 588.52 Min: 1 Median: 2.7325 Max: 5344 Percentiles: P50: 2.73 P75: 3.79 P99: 3875.00 P99.9: 5344.00 P99.99: 5344.00 ------------------------------------------------------ [ 0, 1 ] 13 4.262% 4.262% # ( 1, 2 ] 56 18.361% 22.623% #### ( 2, 3 ] 114 37.377% 60.000% ####### ( 3, 4 ] 58 19.016% 79.016% #### ( 4, 6 ] 28 9.180% 88.197% ## ( 6, 10 ] 10 3.279% 91.475% # ( 15, 22 ] 2 0.656% 92.131% ( 22, 34 ] 1 0.328% 92.459% ( 170, 250 ] 2 0.656% 93.115% ( 250, 380 ] 2 0.656% 93.770% ( 380, 580 ] 3 0.984% 94.754% ( 580, 870 ] 4 1.311% 96.066% ( 870, 1300 ] 3 0.984% 97.049% ( 1300, 1900 ] 3 0.984% 98.033% ( 1900, 2900 ] 1 0.328% 98.361% ( 2900, 4400 ] 3 0.984% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 887.2500 StdDev: 1032.37 Min: 98 Median: 354.0000 Max: 3534 Percentiles: P50: 354.00 P75: 1156.67 P99: 3534.00 P99.9: 3534.00 P99.99: 3534.00 ------------------------------------------------------ ( 76, 110 ] 3 7.500% 7.500% ## ( 110, 170 ] 9 22.500% 30.000% ##### ( 170, 250 ] 4 10.000% 40.000% ## ( 250, 380 ] 5 12.500% 52.500% ### ( 380, 580 ] 3 7.500% 60.000% ## ( 580, 870 ] 2 5.000% 65.000% # ( 870, 1300 ] 6 15.000% 80.000% ### ( 1900, 2900 ] 4 10.000% 90.000% ## ( 2900, 4400 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 12.3 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 321.06 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.462 H:M:S, 11.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.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.407 H:M:S, 13.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/16-04:51:51 ... thread 0: (1000000,5000000) ops and (256852.4,313436.6) ops/second in (3.893286,15.952191) 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/9 3.50 GB 188.8 3.6 0.0 3.6 8.3 4.7 0.0 1.8 132.7 303.4 28.01 26.20 81 0.346 3773K 4246 0.0 0.0 L1 4/4 431.77 MB 0.0 1.1 1.0 0.1 1.1 1.0 0.1 1.1 227.3 226.6 5.00 4.81 2 2.498 1152K 3110 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.7 1.8 216.9 216.8 0.51 0.48 1 0.514 113K 35 0.0 0.0 L3 22/0 923.68 MB 0.9 1.8 0.7 1.1 1.8 0.7 0.1 2.7 225.4 225.2 8.10 7.46 4 2.024 1853K 1770 0.0 0.0 L4 177/0 9.73 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.8 1.0 60.0 60.1 0.93 0.58 1 0.934 56K 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1269/13 100.80 GB 0.0 6.7 1.8 4.9 11.4 6.5 2.4 2.4 160.9 273.2 42.55 39.52 89 0.478 6950K 9161 0.0 0.0 Int 0/0 0.00 KB 0.0 6.7 1.8 4.9 11.4 6.5 2.4 2.4 160.9 273.2 42.55 39.52 89 0.478 6950K 9161 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.7 1.8 4.9 6.7 1.8 0.0 0.0 236.1 235.8 28.99 27.43 21 1.380 6950K 9161 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 353.0 13.56 12.09 68 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): 16.2 total, 16.0 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.35 GB write, 719.48 MB/s write, 6.68 GB read, 423.70 MB/s read, 42.6 seconds Interval compaction: 11.35 GB write, 728.56 MB/s write, 6.68 GB read, 429.05 MB/s read, 42.6 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: 22, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 6, total-stops: 22, interval: 28 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1574577 Average: 2.3211 StdDev: 11.77 Min: 0 Median: 1.5390 Max: 6685 Percentiles: P50: 1.54 P75: 1.91 P99: 5.74 P99.9: 9.99 P99.99: 14.40 ------------------------------------------------------ [ 0, 1 ] 222127 14.107% 14.107% ### ( 1, 2 ] 1048523 66.591% 80.698% ############# ( 2, 3 ] 187985 11.939% 92.637% ## ( 3, 4 ] 64751 4.112% 96.749% # ( 4, 6 ] 40761 2.589% 99.338% # ( 6, 10 ] 8883 0.564% 99.902% ( 10, 15 ] 1579 0.100% 100.002% ( 15, 22 ] 144 0.009% 100.011% ( 22, 34 ] 15 0.001% 100.012% ( 34, 51 ] 6 0.000% 100.013% ( 51, 76 ] 13 0.001% 100.013% ( 76, 110 ] 141 0.009% 100.022% ( 110, 170 ] 174 0.011% 100.033% ( 170, 250 ] 113 0.007% 100.041% ( 250, 380 ] 92 0.006% 100.046% ( 380, 580 ] 56 0.004% 100.050% ( 580, 870 ] 36 0.002% 100.052% ( 870, 1300 ] 25 0.002% 100.054% ( 1300, 1900 ] 13 0.001% 100.055% ( 1900, 2900 ] 2 0.000% 100.055% ( 2900, 4400 ] 6 0.000% 100.055% ( 6600, 9900 ] 1 0.000% 100.055% ** Level 1 read latency histogram (micros): Count: 246064 Average: 2.6649 StdDev: 13.00 Min: 1 Median: 1.5804 Max: 1318 Percentiles: P50: 1.58 P75: 1.96 P99: 7.72 P99.9: 131.67 P99.99: 708.11 ------------------------------------------------------ [ 0, 1 ] 29577 12.020% 12.020% ## ( 1, 2 ] 161027 65.441% 77.461% ############# ( 2, 3 ] 34234 13.913% 91.374% ### ( 3, 4 ] 10382 4.219% 95.593% # ( 4, 6 ] 7154 2.907% 98.500% # ( 6, 10 ] 2864 1.164% 99.664% ( 10, 15 ] 352 0.143% 99.807% ( 15, 22 ] 49 0.020% 99.827% ( 22, 34 ] 3 0.001% 99.828% ( 34, 51 ] 19 0.008% 99.836% ( 51, 76 ] 30 0.012% 99.848% ( 76, 110 ] 76 0.031% 99.879% ( 110, 170 ] 141 0.057% 99.937% ( 170, 250 ] 53 0.022% 99.958% ( 250, 380 ] 34 0.014% 99.972% ( 380, 580 ] 36 0.015% 99.987% ( 580, 870 ] 19 0.008% 99.994% ( 870, 1300 ] 13 0.005% 100.000% ( 1300, 1900 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28292 Average: 2.1111 StdDev: 2.52 Min: 1 Median: 1.4491 Max: 306 Percentiles: P50: 1.45 P75: 1.88 P99: 5.72 P99.9: 11.02 P99.99: 120.25 ------------------------------------------------------ [ 0, 1 ] 6828 24.134% 24.134% ##### ( 1, 2 ] 16294 57.592% 81.726% ############ ( 2, 3 ] 2880 10.180% 91.906% ## ( 3, 4 ] 1254 4.432% 96.338% # ( 4, 6 ] 874 3.089% 99.427% # ( 6, 10 ] 129 0.456% 99.883% ( 10, 15 ] 23 0.081% 99.965% ( 15, 22 ] 6 0.021% 99.986% ( 22, 34 ] 1 0.004% 99.989% ( 110, 170 ] 1 0.004% 99.993% ( 170, 250 ] 1 0.004% 99.996% ( 250, 380 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 272397 Average: 3.9045 StdDev: 38.58 Min: 0 Median: 1.6677 Max: 6042 Percentiles: P50: 1.67 P75: 2.29 P99: 9.54 P99.9: 334.50 P99.99: 958.09 ------------------------------------------------------ [ 0, 1 ] 26118 9.588% 9.588% ## ( 1, 2 ] 164857 60.521% 70.109% ############ ( 2, 3 ] 46292 16.994% 87.103% ### ( 3, 4 ] 16399 6.020% 93.124% # ( 4, 6 ] 11288 4.144% 97.268% # ( 6, 10 ] 5327 1.956% 99.223% ( 10, 15 ] 599 0.220% 99.443% ( 15, 22 ] 123 0.045% 99.488% ( 22, 34 ] 51 0.019% 99.507% ( 34, 51 ] 11 0.004% 99.511% ( 51, 76 ] 10 0.004% 99.515% ( 76, 110 ] 316 0.116% 99.631% ( 110, 170 ] 435 0.160% 99.790% ( 170, 250 ] 205 0.075% 99.866% ( 250, 380 ] 144 0.053% 99.919% ( 380, 580 ] 132 0.048% 99.967% ( 580, 870 ] 56 0.021% 99.988% ( 870, 1300 ] 33 0.012% 100.000% ( 1300, 1900 ] 11 0.004% 100.004% ( 1900, 2900 ] 7 0.003% 100.006% ( 2900, 4400 ] 6 0.002% 100.008% ( 4400, 6600 ] 5 0.002% 100.010% ** Level 4 read latency histogram (micros): Count: 305 Average: 122.7213 StdDev: 588.52 Min: 1 Median: 2.7325 Max: 5344 Percentiles: P50: 2.73 P75: 3.79 P99: 3875.00 P99.9: 5344.00 P99.99: 5344.00 ------------------------------------------------------ [ 0, 1 ] 13 4.262% 4.262% # ( 1, 2 ] 56 18.361% 22.623% #### ( 2, 3 ] 114 37.377% 60.000% ####### ( 3, 4 ] 58 19.016% 79.016% #### ( 4, 6 ] 28 9.180% 88.197% ## ( 6, 10 ] 10 3.279% 91.475% # ( 15, 22 ] 2 0.656% 92.131% ( 22, 34 ] 1 0.328% 92.459% ( 170, 250 ] 2 0.656% 93.115% ( 250, 380 ] 2 0.656% 93.770% ( 380, 580 ] 3 0.984% 94.754% ( 580, 870 ] 4 1.311% 96.066% ( 870, 1300 ] 3 0.984% 97.049% ( 1300, 1900 ] 3 0.984% 98.033% ( 1900, 2900 ] 1 0.328% 98.361% ( 2900, 4400 ] 3 0.984% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 887.2500 StdDev: 1032.37 Min: 98 Median: 354.0000 Max: 3534 Percentiles: P50: 354.00 P75: 1156.67 P99: 3534.00 P99.9: 3534.00 P99.99: 3534.00 ------------------------------------------------------ ( 76, 110 ] 3 7.500% 7.500% ## ( 110, 170 ] 9 22.500% 30.000% ##### ( 170, 250 ] 4 10.000% 40.000% ## ( 250, 380 ] 5 12.500% 52.500% ### ( 380, 580 ] 3 7.500% 60.000% ## ( 580, 870 ] 2 5.000% 65.000% # ( 870, 1300 ] 6 15.000% 80.000% ### ( 1900, 2900 ] 4 10.000% 90.000% ## ( 2900, 4400 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 16.2 total, 3.9 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 304.61 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.734 H:M:S, 16.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 252.79 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.272 H:M:S, 32.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/16-04:51:56 ... thread 0: (1000000,6000000) ops and (192224.7,283628.5) ops/second in (5.202245,21.154436) 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/9 2.83 GB 151.0 4.4 0.0 4.4 10.1 5.7 0.0 1.8 131.0 298.3 34.62 31.96 98 0.353 4605K 5119 0.0 0.0 L1 9/0 1.09 GB 112.0 3.2 2.7 0.5 3.2 2.7 0.1 1.2 225.9 224.2 14.46 13.96 3 4.821 3317K 23K 0.0 0.0 L2 3/3 356.03 MB 0.0 0.1 0.1 0.0 0.1 0.1 1.7 1.8 216.9 216.8 0.51 0.48 1 0.514 113K 35 0.0 0.0 L3 34/9 1.36 GB 0.9 2.9 1.3 1.6 2.9 1.3 0.1 2.2 206.6 206.0 14.23 12.58 9 1.582 2986K 8010 0.0 0.0 L4 176/0 9.57 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.9 1.0 60.0 60.1 0.93 0.58 1 0.934 56K 0 0.0 0.0 L5 1052/0 86.55 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 1288/21 101.76 GB 0.0 10.7 4.1 6.5 16.3 9.7 3.8 2.9 168.5 257.4 64.76 59.56 112 0.578 11M 36K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.7 4.1 6.5 16.3 9.7 3.8 2.9 168.5 257.4 64.76 59.56 112 0.578 11M 36K 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.7 4.1 6.5 10.6 4.1 0.0 0.0 228.3 227.5 47.78 44.81 30 1.593 11M 36K 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 341.4 16.98 14.75 82 0.207 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 21.4 total, 21.2 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 16.28 GB write, 780.49 MB/s write, 10.65 GB read, 510.85 MB/s read, 64.8 seconds Interval compaction: 16.28 GB write, 787.92 MB/s write, 10.65 GB read, 515.71 MB/s read, 64.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 27, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 10, total-stops: 27, interval: 37 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2070032 Average: 2.3601 StdDev: 11.81 Min: 0 Median: 1.5541 Max: 6685 Percentiles: P50: 1.55 P75: 1.93 P99: 5.83 P99.9: 10.28 P99.99: 14.62 ------------------------------------------------------ [ 0, 1 ] 281148 13.582% 13.582% ### ( 1, 2 ] 1360565 65.727% 79.309% ############# ( 2, 3 ] 255773 12.356% 91.665% ## ( 3, 4 ] 94071 4.544% 96.209% # ( 4, 6 ] 63040 3.045% 99.254% # ( 6, 10 ] 13249 0.640% 99.894% ( 10, 15 ] 2146 0.104% 99.998% ( 15, 22 ] 197 0.010% 100.008% ( 22, 34 ] 16 0.001% 100.008% ( 34, 51 ] 9 0.000% 100.009% ( 51, 76 ] 15 0.001% 100.010% ( 76, 110 ] 142 0.007% 100.016% ( 110, 170 ] 212 0.010% 100.027% ( 170, 250 ] 145 0.007% 100.034% ( 250, 380 ] 110 0.005% 100.039% ( 380, 580 ] 80 0.004% 100.043% ( 580, 870 ] 51 0.002% 100.045% ( 870, 1300 ] 33 0.002% 100.047% ( 1300, 1900 ] 20 0.001% 100.048% ( 1900, 2900 ] 5 0.000% 100.048% ( 2900, 4400 ] 7 0.000% 100.048% ( 6600, 9900 ] 1 0.000% 100.048% ** Level 1 read latency histogram (micros): Count: 547169 Average: 3.0703 StdDev: 21.24 Min: 1 Median: 1.7004 Max: 4451 Percentiles: P50: 1.70 P75: 2.40 P99: 8.22 P99.9: 14.95 P99.99: 137.44 ------------------------------------------------------ [ 0, 1 ] 43403 7.932% 7.932% ## ( 1, 2 ] 328627 60.060% 67.992% ############ ( 2, 3 ] 95605 17.473% 85.464% ### ( 3, 4 ] 36626 6.694% 92.158% # ( 4, 6 ] 32602 5.958% 98.116% # ( 6, 10 ] 8691 1.588% 99.705% ( 10, 15 ] 1078 0.197% 99.902% ( 15, 22 ] 145 0.027% 99.928% ( 22, 34 ] 11 0.002% 99.930% ( 34, 51 ] 19 0.003% 99.934% ( 51, 76 ] 43 0.008% 99.942% ( 76, 110 ] 160 0.029% 99.971% ( 110, 170 ] 228 0.042% 100.013% ( 170, 250 ] 137 0.025% 100.038% ( 250, 380 ] 111 0.020% 100.058% ( 380, 580 ] 100 0.018% 100.076% ( 580, 870 ] 58 0.011% 100.087% ( 870, 1300 ] 32 0.006% 100.093% ( 1300, 1900 ] 13 0.002% 100.095% ( 1900, 2900 ] 15 0.003% 100.098% ( 4400, 6600 ] 1 0.000% 100.098% ** Level 2 read latency histogram (micros): Count: 28292 Average: 2.1111 StdDev: 2.52 Min: 1 Median: 1.4491 Max: 306 Percentiles: P50: 1.45 P75: 1.88 P99: 5.72 P99.9: 11.02 P99.99: 120.25 ------------------------------------------------------ [ 0, 1 ] 6828 24.134% 24.134% ##### ( 1, 2 ] 16294 57.592% 81.726% ############ ( 2, 3 ] 2880 10.180% 91.906% ## ( 3, 4 ] 1254 4.432% 96.338% # ( 4, 6 ] 874 3.089% 99.427% # ( 6, 10 ] 129 0.456% 99.883% ( 10, 15 ] 23 0.081% 99.965% ( 15, 22 ] 6 0.021% 99.986% ( 22, 34 ] 1 0.004% 99.989% ( 110, 170 ] 1 0.004% 99.993% ( 170, 250 ] 1 0.004% 99.996% ( 250, 380 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 474757 Average: 4.3857 StdDev: 43.25 Min: 0 Median: 1.7661 Max: 6042 Percentiles: P50: 1.77 P75: 2.59 P99: 9.46 P99.9: 287.56 P99.99: 510.65 ------------------------------------------------------ [ 0, 1 ] 29560 6.226% 6.226% # ( 1, 2 ] 271265 57.138% 63.364% ########### ( 2, 3 ] 93176 19.626% 82.990% #### ( 3, 4 ] 36797 7.751% 90.741% ## ( 4, 6 ] 30635 6.453% 97.194% # ( 6, 10 ] 9926 2.091% 99.284% ( 10, 15 ] 1298 0.273% 99.558% ( 15, 22 ] 218 0.046% 99.604% ( 22, 34 ] 55 0.012% 99.615% ( 34, 51 ] 18 0.004% 99.619% ( 51, 76 ] 13 0.003% 99.622% ( 76, 110 ] 330 0.070% 99.691% ( 110, 170 ] 543 0.114% 99.806% ( 170, 250 ] 352 0.074% 99.880% ( 250, 380 ] 340 0.072% 99.951% ( 380, 580 ] 284 0.060% 100.011% ( 580, 870 ] 172 0.036% 100.047% ( 870, 1300 ] 81 0.017% 100.064% ( 1300, 1900 ] 28 0.006% 100.070% ( 1900, 2900 ] 32 0.007% 100.077% ( 2900, 4400 ] 15 0.003% 100.080% ( 4400, 6600 ] 5 0.001% 100.081% ** Level 4 read latency histogram (micros): Count: 305 Average: 122.7213 StdDev: 588.52 Min: 1 Median: 2.7325 Max: 5344 Percentiles: P50: 2.73 P75: 3.79 P99: 3875.00 P99.9: 5344.00 P99.99: 5344.00 ------------------------------------------------------ [ 0, 1 ] 13 4.262% 4.262% # ( 1, 2 ] 56 18.361% 22.623% #### ( 2, 3 ] 114 37.377% 60.000% ####### ( 3, 4 ] 58 19.016% 79.016% #### ( 4, 6 ] 28 9.180% 88.197% ## ( 6, 10 ] 10 3.279% 91.475% # ( 15, 22 ] 2 0.656% 92.131% ( 22, 34 ] 1 0.328% 92.459% ( 170, 250 ] 2 0.656% 93.115% ( 250, 380 ] 2 0.656% 93.770% ( 380, 580 ] 3 0.984% 94.754% ( 580, 870 ] 4 1.311% 96.066% ( 870, 1300 ] 3 0.984% 97.049% ( 1300, 1900 ] 3 0.984% 98.033% ( 1900, 2900 ] 1 0.328% 98.361% ( 2900, 4400 ] 3 0.984% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 972.6667 StdDev: 1138.11 Min: 98 Median: 361.4286 Max: 5032 Percentiles: P50: 361.43 P75: 1300.00 P99: 5032.00 P99.9: 5032.00 P99.99: 5032.00 ------------------------------------------------------ ( 76, 110 ] 4 6.667% 6.667% # ( 110, 170 ] 13 21.667% 28.333% #### ( 170, 250 ] 7 11.667% 40.000% ## ( 250, 380 ] 7 11.667% 51.667% ## ( 380, 580 ] 4 6.667% 58.333% # ( 580, 870 ] 4 6.667% 65.000% # ( 870, 1300 ] 6 10.000% 75.000% ## ( 1300, 1900 ] 1 1.667% 76.667% ( 1900, 2900 ] 9 15.000% 91.667% ### ( 2900, 4400 ] 4 6.667% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 21.4 total, 5.2 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 276.49 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:5.122 H:M:S, 24.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 189.18 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.387 H:M:S, 45.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 2024/12/16-04:52:00 ... thread 0: (1000000,7000000) ops and (292079.6,284805.7) ops/second in (3.423724,24.578160) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/12 3.74 GB 12.6 6.3 0.0 6.3 12.9 6.6 0.0 2.0 142.1 289.6 45.64 42.03 115 0.397 6587K 10K 0.0 0.0 L1 9/9 1.09 GB 0.0 3.2 2.7 0.5 3.2 2.7 0.1 1.2 225.9 224.2 14.46 13.96 3 4.821 3317K 23K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 1.7 1.8 216.9 216.8 0.51 0.48 1 0.514 113K 35 0.0 0.0 L3 26/0 962.63 MB 1.0 3.7 1.6 2.0 3.7 1.6 0.1 2.2 203.3 202.7 18.53 16.39 12 1.544 3826K 12K 0.0 0.0 L4 185/0 9.66 GB 1.0 0.8 0.8 0.0 0.8 0.8 0.9 1.0 111.6 111.5 7.70 4.34 19 0.405 864K 287 0.0 0.0 L5 1060/0 87.23 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1294/21 102.67 GB 0.0 14.2 5.2 8.9 20.7 11.8 4.5 3.1 166.9 243.9 86.85 77.20 150 0.579 14M 46K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.2 5.2 8.9 20.7 11.8 4.5 3.1 166.9 243.9 86.85 77.20 150 0.579 14M 46K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 14.2 5.2 8.9 14.1 5.2 0.0 0.0 217.2 216.5 66.74 60.00 55 1.213 14M 46K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.6 6.6 0.0 0.0 0.0 335.2 20.11 17.20 95 0.212 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 24.8 total, 24.6 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 20.69 GB write, 854.94 MB/s write, 14.15 GB read, 584.83 MB/s read, 86.8 seconds Interval compaction: 20.69 GB write, 861.94 MB/s write, 14.15 GB read, 589.62 MB/s read, 86.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 41, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 10, total-stops: 41, interval: 51 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2397456 Average: 2.3926 StdDev: 13.88 Min: 0 Median: 1.5541 Max: 6685 Percentiles: P50: 1.55 P75: 1.94 P99: 5.88 P99.9: 11.04 P99.99: 18.99 ------------------------------------------------------ [ 0, 1 ] 337360 14.072% 14.072% ### ( 1, 2 ] 1554580 64.843% 78.914% ############# ( 2, 3 ] 294655 12.290% 91.205% ## ( 3, 4 ] 112519 4.693% 95.898% # ( 4, 6 ] 79015 3.296% 99.194% # ( 6, 10 ] 16401 0.684% 99.878% ( 10, 15 ] 2550 0.106% 99.984% ( 15, 22 ] 239 0.010% 99.994% ( 22, 34 ] 19 0.001% 99.995% ( 34, 51 ] 13 0.001% 99.996% ( 51, 76 ] 17 0.001% 99.996% ( 76, 110 ] 336 0.014% 100.010% ( 110, 170 ] 304 0.013% 100.023% ( 170, 250 ] 168 0.007% 100.030% ( 250, 380 ] 126 0.005% 100.035% ( 380, 580 ] 96 0.004% 100.039% ( 580, 870 ] 55 0.002% 100.042% ( 870, 1300 ] 43 0.002% 100.043% ( 1300, 1900 ] 24 0.001% 100.044% ( 1900, 2900 ] 5 0.000% 100.045% ( 2900, 4400 ] 15 0.001% 100.045% ( 4400, 6600 ] 1 0.000% 100.045% ( 6600, 9900 ] 1 0.000% 100.045% ** Level 1 read latency histogram (micros): Count: 550556 Average: 3.0700 StdDev: 21.18 Min: 1 Median: 1.7018 Max: 4451 Percentiles: P50: 1.70 P75: 2.41 P99: 8.23 P99.9: 14.95 P99.99: 137.62 ------------------------------------------------------ [ 0, 1 ] 43448 7.892% 7.892% ## ( 1, 2 ] 330353 60.004% 67.895% ############ ( 2, 3 ] 96456 17.520% 85.415% #### ( 3, 4 ] 36979 6.717% 92.132% # ( 4, 6 ] 32914 5.978% 98.110% # ( 6, 10 ] 8775 1.594% 99.704% ( 10, 15 ] 1092 0.198% 99.902% ( 15, 22 ] 146 0.027% 99.929% ( 22, 34 ] 11 0.002% 99.931% ( 34, 51 ] 19 0.003% 99.934% ( 51, 76 ] 43 0.008% 99.942% ( 76, 110 ] 160 0.029% 99.971% ( 110, 170 ] 228 0.041% 100.012% ( 170, 250 ] 138 0.025% 100.037% ( 250, 380 ] 111 0.020% 100.058% ( 380, 580 ] 100 0.018% 100.076% ( 580, 870 ] 58 0.011% 100.086% ( 870, 1300 ] 32 0.006% 100.092% ( 1300, 1900 ] 13 0.002% 100.094% ( 1900, 2900 ] 15 0.003% 100.097% ( 4400, 6600 ] 1 0.000% 100.097% ** Level 2 read latency histogram (micros): Count: 28292 Average: 2.1111 StdDev: 2.52 Min: 1 Median: 1.4491 Max: 306 Percentiles: P50: 1.45 P75: 1.88 P99: 5.72 P99.9: 11.02 P99.99: 120.25 ------------------------------------------------------ [ 0, 1 ] 6828 24.134% 24.134% ##### ( 1, 2 ] 16294 57.592% 81.726% ############ ( 2, 3 ] 2880 10.180% 91.906% ## ( 3, 4 ] 1254 4.432% 96.338% # ( 4, 6 ] 874 3.089% 99.427% # ( 6, 10 ] 129 0.456% 99.883% ( 10, 15 ] 23 0.081% 99.965% ( 15, 22 ] 6 0.021% 99.986% ( 22, 34 ] 1 0.004% 99.989% ( 110, 170 ] 1 0.004% 99.993% ( 170, 250 ] 1 0.004% 99.996% ( 250, 380 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 711163 Average: 4.0856 StdDev: 43.30 Min: 0 Median: 1.8384 Max: 8774 Percentiles: P50: 1.84 P75: 2.75 P99: 8.77 P99.9: 103.39 P99.99: 173.38 ------------------------------------------------------ [ 0, 1 ] 31280 4.398% 4.398% # ( 1, 2 ] 386810 54.391% 58.790% ########### ( 2, 3 ] 153294 21.555% 80.345% #### ( 3, 4 ] 65131 9.158% 89.503% ## ( 4, 6 ] 58529 8.230% 97.733% ## ( 6, 10 ] 13004 1.829% 99.562% ( 10, 15 ] 1784 0.251% 99.813% ( 15, 22 ] 259 0.036% 99.849% ( 22, 34 ] 58 0.008% 99.857% ( 34, 51 ] 23 0.003% 99.861% ( 51, 76 ] 14 0.002% 99.863% ( 76, 110 ] 330 0.046% 99.909% ( 110, 170 ] 561 0.079% 99.988% ( 170, 250 ] 352 0.049% 100.037% ( 250, 380 ] 343 0.048% 100.086% ( 380, 580 ] 290 0.041% 100.126% ( 580, 870 ] 181 0.025% 100.152% ( 870, 1300 ] 93 0.013% 100.165% ( 1300, 1900 ] 34 0.005% 100.170% ( 1900, 2900 ] 39 0.005% 100.175% ( 2900, 4400 ] 27 0.004% 100.179% ( 4400, 6600 ] 7 0.001% 100.180% ( 6600, 9900 ] 2 0.000% 100.180% ** Level 4 read latency histogram (micros): Count: 4879 Average: 334.8733 StdDev: 855.56 Min: 0 Median: 2.7041 Max: 15532 Percentiles: P50: 2.70 P75: 14.77 P99: 4084.20 P99.9: 7887.41 P99.99: 9698.74 ------------------------------------------------------ [ 0, 1 ] 80 1.640% 1.640% ( 1, 2 ] 1611 33.019% 34.659% ####### ( 2, 3 ] 1063 21.787% 56.446% #### ( 3, 4 ] 510 10.453% 66.899% ## ( 4, 6 ] 295 6.046% 72.945% # ( 6, 10 ] 85 1.742% 74.687% ( 10, 15 ] 16 0.328% 75.015% ( 15, 22 ] 5 0.102% 75.118% ( 22, 34 ] 2 0.041% 75.159% ( 34, 51 ] 1 0.020% 75.179% ( 76, 110 ] 8 0.164% 75.343% ( 110, 170 ] 42 0.861% 76.204% ( 170, 250 ] 50 1.025% 77.229% ( 250, 380 ] 76 1.558% 78.787% ( 380, 580 ] 151 3.095% 81.882% # ( 580, 870 ] 217 4.448% 86.329% # ( 870, 1300 ] 249 5.104% 91.433% # ( 1300, 1900 ] 154 3.156% 94.589% # ( 1900, 2900 ] 156 3.197% 97.786% # ( 2900, 4400 ] 75 1.537% 99.324% ( 4400, 6600 ] 25 0.512% 99.836% ( 6600, 9900 ] 8 0.164% 100.000% ( 14000, 22000 ] 1 0.020% 100.020% ** Level 5 read latency histogram (micros): Count: 100 Average: 1032.5600 StdDev: 1148.52 Min: 98 Median: 480.0000 Max: 5032 Percentiles: P50: 480.00 P75: 1600.00 P99: 5032.00 P99.9: 5032.00 P99.99: 5032.00 ------------------------------------------------------ ( 76, 110 ] 4 4.000% 4.000% # ( 110, 170 ] 13 13.000% 17.000% ### ( 170, 250 ] 16 16.000% 33.000% ### ( 250, 380 ] 12 12.000% 45.000% ## ( 380, 580 ] 10 10.000% 55.000% ## ( 580, 870 ] 8 8.000% 63.000% ## ( 870, 1300 ] 10 10.000% 73.000% ## ( 1300, 1900 ] 4 4.000% 77.000% # ( 1900, 2900 ] 14 14.000% 91.000% ### ( 2900, 4400 ] 7 7.000% 98.000% # ( 4400, 6600 ] 2 2.000% 100.000% ** DB Stats ** Uptime(secs): 24.8 total, 3.4 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 278.01 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:5.869 H:M:S, 23.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 287.47 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.748 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/16-04:52:04 ... thread 0: (1000000,8000000) ops and (227657.7,276140.9) ops/second in (4.392560,28.970720) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/12 4.73 GB 113.3 7.1 0.0 7.1 14.7 7.6 0.0 1.9 141.6 291.5 51.60 47.62 132 0.391 7419K 11K 0.0 0.0 L1 9/9 1.09 GB 0.0 3.2 2.7 0.5 3.2 2.7 0.1 1.2 225.9 224.2 14.46 13.96 3 4.821 3317K 23K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 1.7 1.8 216.9 216.8 0.51 0.48 1 0.514 113K 35 0.0 0.0 L3 26/0 962.63 MB 1.0 3.7 1.6 2.0 3.7 1.6 0.1 2.2 203.3 202.7 18.53 16.39 12 1.544 3826K 12K 0.0 0.0 L4 185/0 9.66 GB 1.0 0.8 0.8 0.0 0.8 0.8 0.9 1.0 111.6 111.5 7.70 4.34 19 0.405 864K 287 0.0 0.0 L5 1060/0 87.23 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1299/21 103.66 GB 0.0 15.0 5.2 9.7 22.5 12.7 4.5 3.0 165.0 248.0 92.81 82.79 167 0.556 15M 47K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.0 5.2 9.7 22.5 12.7 4.5 3.0 165.0 248.0 92.81 82.79 167 0.556 15M 47K 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 15.0 5.2 9.7 14.9 5.2 0.0 0.0 219.2 218.5 69.84 63.04 58 1.204 15M 47K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.6 7.6 0.0 0.0 0.0 337.4 22.97 19.74 109 0.211 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 29.2 total, 29.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: 22.47 GB write, 788.81 MB/s write, 14.95 GB read, 524.85 MB/s read, 92.8 seconds Interval compaction: 22.47 GB write, 794.29 MB/s write, 14.95 GB read, 528.49 MB/s read, 92.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 45, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 14, total-stops: 45, interval: 59 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2854380 Average: 2.3572 StdDev: 13.77 Min: 0 Median: 1.5400 Max: 6685 Percentiles: P50: 1.54 P75: 1.92 P99: 5.87 P99.9: 10.95 P99.99: 18.40 ------------------------------------------------------ [ 0, 1 ] 419668 14.703% 14.703% ### ( 1, 2 ] 1865782 65.366% 80.068% ############# ( 2, 3 ] 335929 11.769% 91.837% ## ( 3, 4 ] 124620 4.366% 96.203% # ( 4, 6 ] 85488 2.995% 99.198% # ( 6, 10 ] 19471 0.682% 99.880% ( 10, 15 ] 3003 0.105% 99.985% ( 15, 22 ] 279 0.010% 99.995% ( 22, 34 ] 23 0.001% 99.996% ( 34, 51 ] 18 0.001% 99.997% ( 51, 76 ] 19 0.001% 99.997% ( 76, 110 ] 367 0.013% 100.010% ( 110, 170 ] 345 0.012% 100.022% ( 170, 250 ] 182 0.006% 100.029% ( 250, 380 ] 139 0.005% 100.033% ( 380, 580 ] 110 0.004% 100.037% ( 580, 870 ] 62 0.002% 100.039% ( 870, 1300 ] 47 0.002% 100.041% ( 1300, 1900 ] 27 0.001% 100.042% ( 1900, 2900 ] 7 0.000% 100.042% ( 2900, 4400 ] 17 0.001% 100.043% ( 4400, 6600 ] 2 0.000% 100.043% ( 6600, 9900 ] 1 0.000% 100.043% ** Level 1 read latency histogram (micros): Count: 550556 Average: 3.0700 StdDev: 21.18 Min: 1 Median: 1.7018 Max: 4451 Percentiles: P50: 1.70 P75: 2.41 P99: 8.23 P99.9: 14.95 P99.99: 137.62 ------------------------------------------------------ [ 0, 1 ] 43448 7.892% 7.892% ## ( 1, 2 ] 330353 60.004% 67.895% ############ ( 2, 3 ] 96456 17.520% 85.415% #### ( 3, 4 ] 36979 6.717% 92.132% # ( 4, 6 ] 32914 5.978% 98.110% # ( 6, 10 ] 8775 1.594% 99.704% ( 10, 15 ] 1092 0.198% 99.902% ( 15, 22 ] 146 0.027% 99.929% ( 22, 34 ] 11 0.002% 99.931% ( 34, 51 ] 19 0.003% 99.934% ( 51, 76 ] 43 0.008% 99.942% ( 76, 110 ] 160 0.029% 99.971% ( 110, 170 ] 228 0.041% 100.012% ( 170, 250 ] 138 0.025% 100.037% ( 250, 380 ] 111 0.020% 100.058% ( 380, 580 ] 100 0.018% 100.076% ( 580, 870 ] 58 0.011% 100.086% ( 870, 1300 ] 32 0.006% 100.092% ( 1300, 1900 ] 13 0.002% 100.094% ( 1900, 2900 ] 15 0.003% 100.097% ( 4400, 6600 ] 1 0.000% 100.097% ** Level 2 read latency histogram (micros): Count: 28292 Average: 2.1111 StdDev: 2.52 Min: 1 Median: 1.4491 Max: 306 Percentiles: P50: 1.45 P75: 1.88 P99: 5.72 P99.9: 11.02 P99.99: 120.25 ------------------------------------------------------ [ 0, 1 ] 6828 24.134% 24.134% ##### ( 1, 2 ] 16294 57.592% 81.726% ############ ( 2, 3 ] 2880 10.180% 91.906% ## ( 3, 4 ] 1254 4.432% 96.338% # ( 4, 6 ] 874 3.089% 99.427% # ( 6, 10 ] 129 0.456% 99.883% ( 10, 15 ] 23 0.081% 99.965% ( 15, 22 ] 6 0.021% 99.986% ( 22, 34 ] 1 0.004% 99.989% ( 110, 170 ] 1 0.004% 99.993% ( 170, 250 ] 1 0.004% 99.996% ( 250, 380 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 711163 Average: 4.0856 StdDev: 43.30 Min: 0 Median: 1.8384 Max: 8774 Percentiles: P50: 1.84 P75: 2.75 P99: 8.77 P99.9: 103.39 P99.99: 173.38 ------------------------------------------------------ [ 0, 1 ] 31280 4.398% 4.398% # ( 1, 2 ] 386810 54.391% 58.790% ########### ( 2, 3 ] 153294 21.555% 80.345% #### ( 3, 4 ] 65131 9.158% 89.503% ## ( 4, 6 ] 58529 8.230% 97.733% ## ( 6, 10 ] 13004 1.829% 99.562% ( 10, 15 ] 1784 0.251% 99.813% ( 15, 22 ] 259 0.036% 99.849% ( 22, 34 ] 58 0.008% 99.857% ( 34, 51 ] 23 0.003% 99.861% ( 51, 76 ] 14 0.002% 99.863% ( 76, 110 ] 330 0.046% 99.909% ( 110, 170 ] 561 0.079% 99.988% ( 170, 250 ] 352 0.049% 100.037% ( 250, 380 ] 343 0.048% 100.086% ( 380, 580 ] 290 0.041% 100.126% ( 580, 870 ] 181 0.025% 100.152% ( 870, 1300 ] 93 0.013% 100.165% ( 1300, 1900 ] 34 0.005% 100.170% ( 1900, 2900 ] 39 0.005% 100.175% ( 2900, 4400 ] 27 0.004% 100.179% ( 4400, 6600 ] 7 0.001% 100.180% ( 6600, 9900 ] 2 0.000% 100.180% ** Level 4 read latency histogram (micros): Count: 4879 Average: 334.8733 StdDev: 855.56 Min: 0 Median: 2.7041 Max: 15532 Percentiles: P50: 2.70 P75: 14.77 P99: 4084.20 P99.9: 7887.41 P99.99: 9698.74 ------------------------------------------------------ [ 0, 1 ] 80 1.640% 1.640% ( 1, 2 ] 1611 33.019% 34.659% ####### ( 2, 3 ] 1063 21.787% 56.446% #### ( 3, 4 ] 510 10.453% 66.899% ## ( 4, 6 ] 295 6.046% 72.945% # ( 6, 10 ] 85 1.742% 74.687% ( 10, 15 ] 16 0.328% 75.015% ( 15, 22 ] 5 0.102% 75.118% ( 22, 34 ] 2 0.041% 75.159% ( 34, 51 ] 1 0.020% 75.179% ( 76, 110 ] 8 0.164% 75.343% ( 110, 170 ] 42 0.861% 76.204% ( 170, 250 ] 50 1.025% 77.229% ( 250, 380 ] 76 1.558% 78.787% ( 380, 580 ] 151 3.095% 81.882% # ( 580, 870 ] 217 4.448% 86.329% # ( 870, 1300 ] 249 5.104% 91.433% # ( 1300, 1900 ] 154 3.156% 94.589% # ( 1900, 2900 ] 156 3.197% 97.786% # ( 2900, 4400 ] 75 1.537% 99.324% ( 4400, 6600 ] 25 0.512% 99.836% ( 6600, 9900 ] 8 0.164% 100.000% ( 14000, 22000 ] 1 0.020% 100.020% ** Level 5 read latency histogram (micros): Count: 100 Average: 1032.5600 StdDev: 1148.52 Min: 98 Median: 480.0000 Max: 5032 Percentiles: P50: 480.00 P75: 1600.00 P99: 5032.00 P99.9: 5032.00 P99.99: 5032.00 ------------------------------------------------------ ( 76, 110 ] 4 4.000% 4.000% # ( 110, 170 ] 13 13.000% 17.000% ### ( 170, 250 ] 16 16.000% 33.000% ### ( 250, 380 ] 12 12.000% 45.000% ## ( 380, 580 ] 10 10.000% 55.000% ## ( 580, 870 ] 8 8.000% 63.000% ## ( 870, 1300 ] 10 10.000% 73.000% ## ( 1300, 1900 ] 4 4.000% 77.000% # ( 1900, 2900 ] 14 14.000% 91.000% ### ( 2900, 4400 ] 7 7.000% 98.000% # ( 4400, 6600 ] 2 2.000% 100.000% ** DB Stats ** Uptime(secs): 29.2 total, 4.4 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 269.88 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.576 H:M:S, 26.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 224.06 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.706 H:M:S, 38.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/16-04:52:30 ... thread 0: (1000000,9000000) ops and (38408.1,163615.8) ops/second in (26.036206,55.006926) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/7 2.08 GB 44.1 8.9 0.0 8.9 17.5 8.5 0.0 2.0 145.6 284.9 62.73 57.20 149 0.421 9272K 18K 0.0 0.0 L1 10/10 891.88 MB 0.0 7.9 6.3 1.6 7.8 6.2 0.1 1.2 210.9 207.6 38.38 34.89 4 9.596 8219K 126K 0.0 0.0 L2 11/9 1.21 GB 1.0 0.1 0.1 0.0 0.1 0.1 5.4 1.8 216.9 216.8 0.51 0.48 1 0.514 113K 35 0.0 0.0 L3 17/1 1018.64 MB 1.0 5.9 3.2 2.8 5.9 3.1 1.1 1.9 162.8 161.7 37.35 27.35 29 1.288 5990K 35K 0.0 0.0 L4 178/0 9.46 GB 1.0 3.6 3.3 0.3 3.6 3.3 0.9 1.1 127.6 127.4 28.78 17.74 45 0.640 3705K 5426 0.0 0.0 L5 1092/0 89.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1318/27 104.50 GB 0.0 26.5 12.8 13.6 34.8 21.2 11.9 4.1 161.5 212.5 167.76 137.65 228 0.736 27M 185K 0.0 0.0 Int 0/0 0.00 KB 0.0 26.5 12.8 13.6 34.8 21.2 11.9 4.1 161.5 212.5 167.76 137.65 228 0.736 27M 185K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 26.5 12.8 13.6 26.3 12.6 0.0 0.0 192.3 191.0 140.86 115.23 105 1.342 27M 185K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 325.6 26.90 22.42 123 0.219 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): 55.2 total, 55.0 interval Flush(GB): cumulative 8.551, interval 8.551 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 34.82 GB write, 645.82 MB/s write, 26.46 GB read, 490.69 MB/s read, 167.8 seconds Interval compaction: 34.82 GB write, 648.18 MB/s write, 26.46 GB read, 492.48 MB/s read, 167.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 67, pending-compaction-bytes-delays: 32, pending-compaction-bytes-stops: 0, total-delays: 48, total-stops: 67, interval: 115 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4260280 Average: 3.1867 StdDev: 37.39 Min: 0 Median: 1.5388 Max: 9731 Percentiles: P50: 1.54 P75: 1.93 P99: 7.69 P99.9: 149.04 P99.99: 321.06 ------------------------------------------------------ [ 0, 1 ] 657639 15.437% 15.437% ### ( 1, 2 ] 2732764 64.145% 79.582% ############# ( 2, 3 ] 493212 11.577% 91.159% ## ( 3, 4 ] 181084 4.251% 95.409% # ( 4, 6 ] 138726 3.256% 98.665% # ( 6, 10 ] 33744 0.792% 99.458% ( 10, 15 ] 5225 0.123% 99.580% ( 15, 22 ] 660 0.015% 99.596% ( 22, 34 ] 40 0.001% 99.597% ( 34, 51 ] 26 0.001% 99.597% ( 51, 76 ] 175 0.004% 99.601% ( 76, 110 ] 8654 0.203% 99.804% ( 110, 170 ] 6257 0.147% 99.951% ( 170, 250 ] 1162 0.027% 99.979% ( 250, 380 ] 889 0.021% 99.999% ( 380, 580 ] 713 0.017% 100.016% ( 580, 870 ] 294 0.007% 100.023% ( 870, 1300 ] 163 0.004% 100.027% ( 1300, 1900 ] 102 0.002% 100.029% ( 1900, 2900 ] 98 0.002% 100.032% ( 2900, 4400 ] 152 0.004% 100.035% ( 4400, 6600 ] 42 0.001% 100.036% ( 6600, 9900 ] 21 0.000% 100.037% ** Level 1 read latency histogram (micros): Count: 1494565 Average: 5.5895 StdDev: 91.25 Min: 1 Median: 1.7312 Max: 21843 Percentiles: P50: 1.73 P75: 2.60 P99: 9.24 P99.9: 140.21 P99.99: 225.04 ------------------------------------------------------ [ 0, 1 ] 152753 10.221% 10.221% ## ( 1, 2 ] 813074 54.402% 64.623% ########### ( 2, 3 ] 260234 17.412% 82.035% ### ( 3, 4 ] 118059 7.899% 89.934% ## ( 4, 6 ] 113169 7.572% 97.506% ## ( 6, 10 ] 27608 1.847% 99.353% ( 10, 15 ] 4574 0.306% 99.659% ( 15, 22 ] 593 0.040% 99.699% ( 22, 34 ] 35 0.002% 99.701% ( 34, 51 ] 30 0.002% 99.703% ( 51, 76 ] 222 0.015% 99.718% ( 76, 110 ] 1721 0.115% 99.833% ( 110, 170 ] 1983 0.133% 99.966% ( 170, 250 ] 524 0.035% 100.001% ( 250, 380 ] 487 0.033% 100.034% ( 380, 580 ] 518 0.035% 100.068% ( 580, 870 ] 385 0.026% 100.094% ( 870, 1300 ] 248 0.017% 100.111% ( 1300, 1900 ] 194 0.013% 100.124% ( 1900, 2900 ] 235 0.016% 100.139% ( 2900, 4400 ] 360 0.024% 100.163% ( 4400, 6600 ] 107 0.007% 100.170% ( 6600, 9900 ] 33 0.002% 100.173% ( 14000, 22000 ] 1 0.000% 100.173% ** Level 2 read latency histogram (micros): Count: 28292 Average: 2.1111 StdDev: 2.52 Min: 1 Median: 1.4491 Max: 306 Percentiles: P50: 1.45 P75: 1.88 P99: 5.72 P99.9: 11.02 P99.99: 120.25 ------------------------------------------------------ [ 0, 1 ] 6828 24.134% 24.134% ##### ( 1, 2 ] 16294 57.592% 81.726% ############ ( 2, 3 ] 2880 10.180% 91.906% ## ( 3, 4 ] 1254 4.432% 96.338% # ( 4, 6 ] 874 3.089% 99.427% # ( 6, 10 ] 129 0.456% 99.883% ( 10, 15 ] 23 0.081% 99.965% ( 15, 22 ] 6 0.021% 99.986% ( 22, 34 ] 1 0.004% 99.989% ( 110, 170 ] 1 0.004% 99.993% ( 170, 250 ] 1 0.004% 99.996% ( 250, 380 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 1500642 Average: 5.0830 StdDev: 70.73 Min: 0 Median: 1.9416 Max: 10716 Percentiles: P50: 1.94 P75: 2.96 P99: 8.83 P99.9: 14.59 P99.99: 89.52 ------------------------------------------------------ [ 0, 1 ] 38054 2.536% 2.536% # ( 1, 2 ] 756455 50.409% 52.945% ########## ( 2, 3 ] 346453 23.087% 76.032% ##### ( 3, 4 ] 164949 10.992% 87.023% ## ( 4, 6 ] 158684 10.574% 97.598% ## ( 6, 10 ] 29737 1.982% 99.580% ( 10, 15 ] 5240 0.349% 99.929% ( 15, 22 ] 619 0.041% 99.970% ( 22, 34 ] 69 0.005% 99.975% ( 34, 51 ] 28 0.002% 99.976% ( 51, 76 ] 52 0.003% 99.980% ( 76, 110 ] 382 0.025% 100.005% ( 110, 170 ] 868 0.058% 100.063% ( 170, 250 ] 626 0.042% 100.105% ( 250, 380 ] 607 0.040% 100.145% ( 380, 580 ] 625 0.042% 100.187% ( 580, 870 ] 451 0.030% 100.217% ( 870, 1300 ] 275 0.018% 100.235% ( 1300, 1900 ] 160 0.011% 100.246% ( 1900, 2900 ] 190 0.013% 100.259% ( 2900, 4400 ] 226 0.015% 100.274% ( 4400, 6600 ] 48 0.003% 100.277% ( 6600, 9900 ] 15 0.001% 100.278% ( 9900, 14000 ] 2 0.000% 100.278% ** Level 4 read latency histogram (micros): Count: 83749 Average: 61.6639 StdDev: 408.39 Min: 0 Median: 1.9672 Max: 23005 Percentiles: P50: 1.97 P75: 3.02 P99: 1922.54 P99.9: 4329.82 P99.99: 5594.21 ------------------------------------------------------ [ 0, 1 ] 1192 1.423% 1.423% ( 1, 2 ] 42061 50.223% 51.646% ########## ( 2, 3 ] 19352 23.107% 74.753% ##### ( 3, 4 ] 8525 10.179% 84.932% ## ( 4, 6 ] 7551 9.016% 93.949% ## ( 6, 10 ] 1449 1.730% 95.679% ( 10, 15 ] 322 0.384% 96.063% ( 15, 22 ] 34 0.041% 96.104% ( 22, 34 ] 6 0.007% 96.111% ( 34, 51 ] 2 0.002% 96.113% ( 51, 76 ] 2 0.002% 96.116% ( 76, 110 ] 30 0.036% 96.152% ( 110, 170 ] 142 0.170% 96.321% ( 170, 250 ] 188 0.224% 96.546% ( 250, 380 ] 228 0.272% 96.818% ( 380, 580 ] 365 0.436% 97.254% ( 580, 870 ] 502 0.599% 97.853% ( 870, 1300 ] 519 0.620% 98.473% ( 1300, 1900 ] 432 0.516% 98.989% ( 1900, 2900 ] 422 0.504% 99.493% ( 2900, 4400 ] 358 0.427% 99.920% ( 4400, 6600 ] 108 0.129% 100.049% ( 6600, 9900 ] 19 0.023% 100.072% ( 9900, 14000 ] 1 0.001% 100.073% ( 14000, 22000 ] 3 0.004% 100.076% ( 22000, 33000 ] 1 0.001% 100.078% ** Level 5 read latency histogram (micros): Count: 260 Average: 1425.4346 StdDev: 1566.15 Min: 87 Median: 770.0000 Max: 9951 Percentiles: P50: 770.00 P75: 2305.41 P99: 7260.00 P99.9: 9951.00 P99.99: 9951.00 ------------------------------------------------------ ( 76, 110 ] 9 3.462% 3.462% # ( 110, 170 ] 31 11.923% 15.385% ## ( 170, 250 ] 23 8.846% 24.231% ## ( 250, 380 ] 27 10.385% 34.615% ## ( 380, 580 ] 21 8.077% 42.692% ## ( 580, 870 ] 29 11.154% 53.846% ## ( 870, 1300 ] 23 8.846% 62.692% ## ( 1300, 1900 ] 17 6.538% 69.231% # ( 1900, 2900 ] 37 14.231% 83.462% ### ( 2900, 4400 ] 31 11.923% 95.385% ## ( 4400, 6600 ] 9 3.462% 98.846% # ( 6600, 9900 ] 2 0.769% 99.615% ( 9900, 14000 ] 1 0.385% 100.000% ** DB Stats ** Uptime(secs): 55.2 total, 26.0 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 160.44 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:29.889 H:M:S, 54.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 37.80 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:22.313 H:M:S, 85.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/16-04:52:34 ... thread 0: (1000000,10000000) ops and (259907.1,169910.7) ops/second in (3.847528,58.854454) 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/7 3.07 GB 151.0 9.8 0.0 9.8 19.3 9.5 0.0 2.0 143.5 283.1 69.79 63.27 165 0.423 10M 19K 0.0 0.0 L1 10/10 891.88 MB 0.0 7.9 6.3 1.6 7.8 6.2 0.1 1.2 210.9 207.6 38.38 34.89 4 9.596 8219K 126K 0.0 0.0 L2 2/0 99.94 MB 1.0 0.1 0.1 0.0 0.1 0.1 5.4 1.8 216.9 216.8 0.51 0.48 1 0.514 113K 35 0.0 0.0 L3 16/0 970.20 MB 1.0 7.1 4.3 2.8 7.1 4.2 1.1 1.6 160.9 159.9 45.20 32.87 30 1.507 6414K 35K 0.0 0.0 L4 178/0 9.64 GB 1.0 4.8 4.4 0.3 4.7 4.4 0.9 1.1 126.1 125.9 38.64 23.45 57 0.678 4912K 5487 0.0 0.0 L5 1104/0 90.86 GB 0.9 0.0 0.0 0.0 0.0 0.0 5.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1324/17 105.48 GB 0.0 29.7 15.1 14.6 39.0 24.4 12.9 4.1 157.7 207.4 192.53 154.96 257 0.749 29M 186K 0.0 0.0 Int 0/0 0.00 KB 0.0 29.7 15.1 14.6 39.0 24.4 12.8 4.1 157.7 207.4 192.53 154.96 257 0.749 29M 186K 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.7 15.1 14.6 29.5 14.9 0.0 0.0 187.3 186.1 162.09 129.88 121 1.340 29M 186K 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 320.8 30.44 25.08 136 0.224 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.1 total, 58.9 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: 38.99 GB write, 676.12 MB/s write, 29.65 GB read, 514.11 MB/s read, 192.5 seconds Interval compaction: 38.99 GB write, 678.43 MB/s write, 29.65 GB read, 515.87 MB/s read, 192.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 83, pending-compaction-bytes-delays: 32, pending-compaction-bytes-stops: 0, total-delays: 48, total-stops: 83, interval: 131 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4580112 Average: 3.1465 StdDev: 36.20 Min: 0 Median: 1.5477 Max: 9731 Percentiles: P50: 1.55 P75: 1.94 P99: 7.57 P99.9: 144.72 P99.99: 291.28 ------------------------------------------------------ [ 0, 1 ] 683652 14.927% 14.927% ### ( 1, 2 ] 2933122 64.040% 78.967% ############# ( 2, 3 ] 548029 11.965% 90.932% ## ( 3, 4 ] 200371 4.375% 95.307% # ( 4, 6 ] 154605 3.376% 98.683% # ( 6, 10 ] 36931 0.806% 99.489% ( 10, 15 ] 5557 0.121% 99.610% ( 15, 22 ] 703 0.015% 99.626% ( 22, 34 ] 41 0.001% 99.627% ( 34, 51 ] 28 0.001% 99.627% ( 51, 76 ] 176 0.004% 99.631% ( 76, 110 ] 8677 0.189% 99.821% ( 110, 170 ] 6290 0.137% 99.958% ( 170, 250 ] 1184 0.026% 99.984% ( 250, 380 ] 907 0.020% 100.004% ( 380, 580 ] 733 0.016% 100.020% ( 580, 870 ] 307 0.007% 100.026% ( 870, 1300 ] 173 0.004% 100.030% ( 1300, 1900 ] 103 0.002% 100.032% ( 1900, 2900 ] 102 0.002% 100.034% ( 2900, 4400 ] 152 0.003% 100.038% ( 4400, 6600 ] 42 0.001% 100.039% ( 6600, 9900 ] 21 0.000% 100.039% ** Level 1 read latency histogram (micros): Count: 1664652 Average: 5.5058 StdDev: 89.76 Min: 1 Median: 1.7297 Max: 21843 Percentiles: P50: 1.73 P75: 2.57 P99: 9.22 P99.9: 146.08 P99.99: 263.98 ------------------------------------------------------ [ 0, 1 ] 161062 9.675% 9.675% ## ( 1, 2 ] 919976 55.265% 64.941% ########### ( 2, 3 ] 291429 17.507% 82.448% #### ( 3, 4 ] 128637 7.728% 90.175% ## ( 4, 6 ] 122051 7.332% 97.507% # ( 6, 10 ] 30893 1.856% 99.363% ( 10, 15 ] 4919 0.295% 99.658% ( 15, 22 ] 630 0.038% 99.696% ( 22, 34 ] 38 0.002% 99.699% ( 34, 51 ] 31 0.002% 99.700% ( 51, 76 ] 230 0.014% 99.714% ( 76, 110 ] 1796 0.108% 99.822% ( 110, 170 ] 2154 0.129% 99.952% ( 170, 250 ] 582 0.035% 99.987% ( 250, 380 ] 535 0.032% 100.019% ( 380, 580 ] 569 0.034% 100.053% ( 580, 870 ] 426 0.026% 100.078% ( 870, 1300 ] 273 0.016% 100.095% ( 1300, 1900 ] 206 0.012% 100.107% ( 1900, 2900 ] 255 0.015% 100.123% ( 2900, 4400 ] 391 0.023% 100.146% ( 4400, 6600 ] 115 0.007% 100.153% ( 6600, 9900 ] 36 0.002% 100.155% ( 14000, 22000 ] 1 0.000% 100.155% ** Level 2 read latency histogram (micros): Count: 28292 Average: 2.1111 StdDev: 2.52 Min: 1 Median: 1.4491 Max: 306 Percentiles: P50: 1.45 P75: 1.88 P99: 5.72 P99.9: 11.02 P99.99: 120.25 ------------------------------------------------------ [ 0, 1 ] 6828 24.134% 24.134% ##### ( 1, 2 ] 16294 57.592% 81.726% ############ ( 2, 3 ] 2880 10.180% 91.906% ## ( 3, 4 ] 1254 4.432% 96.338% # ( 4, 6 ] 874 3.089% 99.427% # ( 6, 10 ] 129 0.456% 99.883% ( 10, 15 ] 23 0.081% 99.965% ( 15, 22 ] 6 0.021% 99.986% ( 22, 34 ] 1 0.004% 99.989% ( 110, 170 ] 1 0.004% 99.993% ( 170, 250 ] 1 0.004% 99.996% ( 250, 380 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 1802009 Average: 5.8047 StdDev: 85.98 Min: 0 Median: 1.9506 Max: 10716 Percentiles: P50: 1.95 P75: 2.96 P99: 8.88 P99.9: 14.50 P99.99: 75.00 ------------------------------------------------------ [ 0, 1 ] 40157 2.228% 2.228% ( 1, 2 ] 905598 50.255% 52.483% ########## ( 2, 3 ] 422794 23.462% 75.946% ##### ( 3, 4 ] 199052 11.046% 86.992% ## ( 4, 6 ] 190414 10.567% 97.559% ## ( 6, 10 ] 36031 1.999% 99.558% ( 10, 15 ] 6848 0.380% 99.938% ( 15, 22 ] 772 0.043% 99.981% ( 22, 34 ] 78 0.004% 99.985% ( 34, 51 ] 32 0.002% 99.987% ( 51, 76 ] 55 0.003% 99.990% ( 76, 110 ] 410 0.023% 100.013% ( 110, 170 ] 971 0.054% 100.067% ( 170, 250 ] 699 0.039% 100.106% ( 250, 380 ] 705 0.039% 100.145% ( 380, 580 ] 731 0.041% 100.185% ( 580, 870 ] 571 0.032% 100.217% ( 870, 1300 ] 373 0.021% 100.238% ( 1300, 1900 ] 246 0.014% 100.251% ( 1900, 2900 ] 382 0.021% 100.272% ( 2900, 4400 ] 437 0.024% 100.297% ( 4400, 6600 ] 100 0.006% 100.302% ( 6600, 9900 ] 22 0.001% 100.303% ( 9900, 14000 ] 2 0.000% 100.304% ** Level 4 read latency histogram (micros): Count: 86865 Average: 74.0211 StdDev: 445.54 Min: 0 Median: 1.9825 Max: 23005 Percentiles: P50: 1.98 P75: 3.09 P99: 2357.16 P99.9: 4532.57 P99.99: 5806.59 ------------------------------------------------------ [ 0, 1 ] 1219 1.403% 1.403% ( 1, 2 ] 42966 49.463% 50.866% ########## ( 2, 3 ] 20193 23.246% 74.113% ##### ( 3, 4 ] 8851 10.189% 84.302% ## ( 4, 6 ] 7726 8.894% 93.196% ## ( 6, 10 ] 1505 1.733% 94.929% ( 10, 15 ] 334 0.385% 95.313% ( 15, 22 ] 37 0.043% 95.356% ( 22, 34 ] 8 0.009% 95.365% ( 34, 51 ] 2 0.002% 95.368% ( 51, 76 ] 2 0.002% 95.370% ( 76, 110 ] 38 0.044% 95.414% ( 110, 170 ] 172 0.198% 95.612% ( 170, 250 ] 227 0.261% 95.873% ( 250, 380 ] 265 0.305% 96.178% ( 380, 580 ] 457 0.526% 96.704% ( 580, 870 ] 591 0.680% 97.384% ( 870, 1300 ] 616 0.709% 98.094% ( 1300, 1900 ] 535 0.616% 98.709% ( 1900, 2900 ] 552 0.635% 99.345% ( 2900, 4400 ] 474 0.546% 99.891% ( 4400, 6600 ] 135 0.155% 100.046% ( 6600, 9900 ] 21 0.024% 100.070% ( 9900, 14000 ] 1 0.001% 100.071% ( 14000, 22000 ] 3 0.003% 100.075% ( 22000, 33000 ] 1 0.001% 100.076% ** Level 5 read latency histogram (micros): Count: 320 Average: 1384.6875 StdDev: 1510.60 Min: 87 Median: 755.5263 Max: 9951 Percentiles: P50: 755.53 P75: 2240.43 P99: 6556.00 P99.9: 9951.00 P99.99: 9951.00 ------------------------------------------------------ ( 76, 110 ] 14 4.375% 4.375% # ( 110, 170 ] 36 11.250% 15.625% ## ( 170, 250 ] 25 7.812% 23.438% ## ( 250, 380 ] 33 10.312% 33.750% ## ( 380, 580 ] 29 9.062% 42.812% ## ( 580, 870 ] 38 11.875% 54.688% ## ( 870, 1300 ] 29 9.062% 63.750% ## ( 1300, 1900 ] 20 6.250% 70.000% # ( 1900, 2900 ] 47 14.688% 84.688% ### ( 2900, 4400 ] 36 11.250% 95.938% ## ( 4400, 6600 ] 10 3.125% 99.062% # ( 6600, 9900 ] 2 0.625% 99.688% ( 9900, 14000 ] 1 0.312% 100.000% ** DB Stats ** Uptime(secs): 59.1 total, 3.8 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 166.65 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:30.999 H:M:S, 52.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 255.80 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.110 H:M:S, 28.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.792 micros/op 172656 ops/sec 60.044 seconds 10366999 operations; 167.3 MB/s Microseconds per write: Count: 10366999 Average: 5.7918 StdDev: 419.25 Min: 0 Median: 1.7496 Max: 581332 Percentiles: P50: 1.75 P75: 2.78 P99: 9.22 P99.9: 1131.64 P99.99: 2723.07 ------------------------------------------------------ [ 0, 1 ] 1346830 12.992% 12.992% ### ( 1, 2 ] 5118038 49.369% 62.360% ########## ( 2, 3 ] 1675112 16.158% 78.518% ### ( 3, 4 ] 1434750 13.840% 92.358% ### ( 4, 6 ] 593343 5.723% 98.081% # ( 6, 10 ] 118170 1.140% 99.221% ( 10, 15 ] 39954 0.385% 99.606% ( 15, 22 ] 9450 0.091% 99.698% ( 22, 34 ] 1825 0.018% 99.715% ( 34, 51 ] 250 0.002% 99.718% ( 51, 76 ] 38 0.000% 99.718% ( 76, 110 ] 6882 0.066% 99.784% ( 110, 170 ] 3150 0.030% 99.815% ( 170, 250 ] 283 0.003% 99.817% ( 250, 380 ] 172 0.002% 99.819% ( 380, 580 ] 26 0.000% 99.819% ( 580, 870 ] 32 0.000% 99.820% ( 870, 1300 ] 13685 0.132% 99.952% ( 1300, 1900 ] 108 0.001% 99.953% ( 1900, 2900 ] 4695 0.045% 99.998% ( 2900, 4400 ] 125 0.001% 99.999% ( 4400, 6600 ] 35 0.000% 100.000% ( 6600, 9900 ] 16 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 33000, 50000 ] 2 0.000% 100.000% ( 75000, 110000 ] 2 0.000% 100.000% ( 110000, 170000 ] 3 0.000% 100.000% ( 170000, 250000 ] 13 0.000% 100.000% ( 250000, 380000 ] 2 0.000% 100.000% ( 380000, 570000 ] 3 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 207812 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 : 10366999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10698742968 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 : 632 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31234254 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 : 34311265386 rocksdb.compact.write.bytes COUNT : 34103627131 rocksdb.flush.write.bytes COUNT : 10635139904 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 : 72 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 : 240 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 : 10549469184 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4165632 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 : 34416905202 rocksdb.non.last.level.read.count COUNT : 8314213 rocksdb.block.checksum.compute.count COUNT : 8313021 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.404061 P95 : 3.930989 P99 : 7.689207 P100 : 581327.000000 COUNT : 10366999 SUM : 55218392 rocksdb.compaction.times.micros P50 : 959166.666667 P95 : 4230000.000000 P99 : 9437000.000000 P100 : 23919431.000000 COUNT : 122 SUM : 163028561 rocksdb.compaction.times.cpu_micros P50 : 545217.391304 P95 : 3565000.000000 P99 : 9074000.000000 P100 : 20929019.000000 COUNT : 122 SUM : 130813193 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 : 715.000000 P95 : 2375.000000 P99 : 13159.500000 P100 : 16334.000000 COUNT : 141 SUM : 149005 rocksdb.compaction.outfile.sync.micros P50 : 1142.333333 P95 : 64444.444444 P99 : 234457.142857 P100 : 329436.000000 COUNT : 436 SUM : 5860850 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 : 105.112500 P95 : 1390.000000 P99 : 4127.000000 P100 : 16295.000000 COUNT : 291 SUM : 110573 rocksdb.table.open.io.micros P50 : 1434.831461 P95 : 8124.827586 P99 : 13508.000000 P100 : 21193.000000 COUNT : 632 SUM : 1427926 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.750235 P95 : 8.275093 P99 : 12.304857 P100 : 23011.000000 COUNT : 8311408 SUM : 59092501 rocksdb.read.block.get.micros P50 : 469.473684 P95 : 3668.181818 P99 : 6083.000000 P100 : 10110.000000 COUNT : 1264 SUM : 1157150 rocksdb.write.raw.block.micros P50 : 0.514869 P95 : 0.978251 P99 : 3.152126 P100 : 26761.000000 COUNT : 10836438 SUM : 22693656 rocksdb.numfiles.in.singlecompaction P50 : 2.333333 P95 : 5.133333 P99 : 13.800000 P100 : 21.000000 COUNT : 172 SUM : 565 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.558417 P95 : 1173.804484 P99 : 2554.680669 P100 : 581137.000000 COUNT : 178526 SUM : 31252361 rocksdb.sst.read.micros P50 : 1.660784 P95 : 4.959792 P99 : 9.025886 P100 : 23005.000000 COUNT : 8314753 SUM : 41481552 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 : 10366999 SUM : 10698742968 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 : 212173.913043 P95 : 425125.000000 P99 : 757775.000000 P100 : 792049.000000 COUNT : 141 SUM : 31543195 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 : 400 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