[2024-07-15 14:02:48.488944] Starting SPDK v24.01.1-pre git sha1 4b94202c6 / DPDK 23.11.0 initialization... [2024-07-15 14:02:48.489060] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid739306 ] Set seed to 1721044968486335 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-15 14:02:48.620580] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-15 14:02:48.663912] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-15 14:02:48.663963] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 739306' to capture a snapshot of events at runtime. [2024-07-15 14:02:48.663978] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid739306 for offline analysis/debug. [2024-07-15 14:02:48.664007] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Mon Jul 15 14:02:52 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/07/15-14:02:55 ... thread 0: (1000000,1000000) ops and (331354.6,331354.6) ops/second in (3.017915,3.017915) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 6/4 378.00 MB 12.6 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 335.4 2.44 2.21 12 0.203 0 0 0.0 0.0 L1 4/0 251.73 MB 25.2 0.2 0.2 0.0 0.2 0.2 0.2 1.0 230.1 229.8 1.10 1.05 1 1.095 255K 254 0.0 0.0 L2 3/2 188.84 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.1 1.5 235.9 235.8 0.80 0.77 1 0.801 191K 92 0.0 0.0 L3 11/0 930.12 MB 0.9 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.69 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 1184/6 96.94 GB 0.0 0.4 0.4 0.1 1.2 1.2 0.4 1.5 101.7 290.4 4.34 4.03 14 0.310 447K 346 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.4 0.1 1.2 1.2 0.2 1.5 101.7 290.4 4.34 4.03 14 0.310 447K 346 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.4 0.1 0.4 0.4 0.0 0.0 232.5 232.3 1.90 1.82 2 0.948 447K 346 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 335.4 2.44 2.21 12 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): 3.2 total, 3.0 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.23 GB write, 390.95 MB/s write, 0.43 GB read, 136.87 MB/s read, 4.3 seconds Interval compaction: 1.23 GB write, 417.15 MB/s write, 0.43 GB read, 146.04 MB/s read, 4.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 1, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 1, interval: 1 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 149135 Average: 1.9953 StdDev: 14.26 Min: 0 Median: 1.3058 Max: 2967 Percentiles: P50: 1.31 P75: 1.74 P99: 5.61 P99.9: 10.83 P99.99: 24.61 ------------------------------------------------------ [ 0, 1 ] 48187 32.311% 32.311% ###### ( 1, 2 ] 86274 57.850% 90.161% ############ ( 2, 3 ] 7810 5.237% 95.397% # ( 3, 4 ] 3600 2.414% 97.811% ( 4, 6 ] 2206 1.479% 99.291% ( 6, 10 ] 888 0.595% 99.886% ( 10, 15 ] 132 0.089% 99.975% ( 15, 22 ] 23 0.015% 99.990% ( 22, 34 ] 5 0.003% 99.993% ( 34, 51 ] 2 0.001% 99.995% ( 51, 76 ] 3 0.002% 99.997% ( 76, 110 ] 1 0.001% 99.997% ( 170, 250 ] 11 0.007% 100.005% ( 250, 380 ] 4 0.003% 100.007% ( 380, 580 ] 1 0.001% 100.008% ( 580, 870 ] 1 0.001% 100.009% ( 870, 1300 ] 3 0.002% 100.011% ( 1300, 1900 ] 1 0.001% 100.011% ( 1900, 2900 ] 2 0.001% 100.013% ( 2900, 4400 ] 1 0.001% 100.013% ** Level 1 read latency histogram (micros): Count: 20 Average: 132.5500 StdDev: 248.58 Min: 0 Median: 1.7143 Max: 988 Percentiles: P50: 1.71 P75: 170.00 P99: 988.00 P99.9: 988.00 P99.99: 988.00 ------------------------------------------------------ [ 0, 1 ] 5 25.000% 25.000% ##### ( 1, 2 ] 7 35.000% 60.000% ####### ( 2, 3 ] 2 10.000% 70.000% ## ( 110, 170 ] 1 5.000% 75.000% # ( 250, 380 ] 3 15.000% 90.000% ### ( 380, 580 ] 1 5.000% 95.000% # ( 870, 1300 ] 1 5.000% 100.000% # ** Level 2 read latency histogram (micros): Count: 34952 Average: 2.4482 StdDev: 27.79 Min: 1 Median: 1.4669 Max: 4403 Percentiles: P50: 1.47 P75: 1.85 P99: 6.70 P99.9: 14.17 P99.99: 798.18 ------------------------------------------------------ [ 0, 1 ] 6963 19.922% 19.922% #### ( 1, 2 ] 22518 64.425% 84.347% ############# ( 2, 3 ] 2408 6.889% 91.237% # ( 3, 4 ] 1607 4.598% 95.834% # ( 4, 6 ] 1057 3.024% 98.858% # ( 6, 10 ] 290 0.830% 99.688% ( 10, 15 ] 90 0.257% 99.946% ( 15, 22 ] 8 0.023% 99.969% ( 22, 34 ] 2 0.006% 99.974% ( 34, 51 ] 1 0.003% 99.977% ( 170, 250 ] 1 0.003% 99.980% ( 250, 380 ] 1 0.003% 99.983% ( 380, 580 ] 2 0.006% 99.989% ( 580, 870 ] 2 0.006% 99.994% ( 870, 1300 ] 1 0.003% 99.997% ( 1900, 2900 ] 1 0.003% 100.000% ( 4400, 6600 ] 1 0.003% 100.003% ** Level 3 read latency histogram (micros): Count: 50 Average: 1706.8200 StdDev: 1384.81 Min: 180 Median: 1214.0000 Max: 5685 Percentiles: P50: 1214.00 P75: 2837.50 P99: 5500.00 P99.9: 5685.00 P99.99: 5685.00 ------------------------------------------------------ ( 170, 250 ] 1 2.000% 2.000% ( 250, 380 ] 8 16.000% 18.000% ### ( 380, 580 ] 6 12.000% 30.000% ## ( 580, 870 ] 6 12.000% 42.000% ## ( 870, 1300 ] 5 10.000% 52.000% ## ( 1300, 1900 ] 4 8.000% 60.000% ## ( 1900, 2900 ] 8 16.000% 76.000% ### ( 2900, 4400 ] 11 22.000% 98.000% #### ( 4400, 6600 ] 1 2.000% 100.000% ** Level 4 read latency histogram (micros): Count: 25 Average: 2011.5200 StdDev: 1292.02 Min: 282 Median: 1971.4286 Max: 4529 Percentiles: P50: 1971.43 P75: 2864.29 P99: 4529.00 P99.9: 4529.00 P99.99: 4529.00 ------------------------------------------------------ ( 250, 380 ] 2 8.000% 8.000% ## ( 380, 580 ] 1 4.000% 12.000% # ( 580, 870 ] 3 12.000% 24.000% ## ( 870, 1300 ] 3 12.000% 36.000% ## ( 1300, 1900 ] 3 12.000% 48.000% ## ( 1900, 2900 ] 7 28.000% 76.000% ###### ( 2900, 4400 ] 4 16.000% 92.000% ### ( 4400, 6600 ] 2 8.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.2 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 305.46 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.212 H:M:S, 6.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 325.87 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.212 H:M:S, 7.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/15-14:02:59 ... thread 0: (1000000,2000000) ops and (300162.8,314988.4) ops/second in (3.331525,6.349440) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/4 1.41 GB 113.3 1.0 0.0 1.0 2.9 1.8 0.0 1.6 107.1 296.1 10.00 9.22 31 0.322 1087K 1126 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 230.1 229.8 1.10 1.05 1 1.095 255K 254 0.0 0.0 L2 2/1 81.38 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.3 1.5 228.8 228.7 0.84 0.80 2 0.422 196K 93 0.0 0.0 L3 20/11 1.09 GB 0.2 0.2 0.2 0.0 0.2 0.2 0.3 1.0 218.1 218.1 0.86 0.79 1 0.858 189K 0 0.0 0.0 L4 174/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 130.7 130.8 1.29 0.86 1 1.286 170K 0 0.0 0.0 L5 1044/0 85.69 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 1249/16 97.98 GB 0.0 1.8 0.7 1.1 3.7 2.6 0.8 2.0 132.9 267.0 14.08 12.72 36 0.391 1900K 1473 0.0 0.0 Int 0/0 0.00 KB 0.0 1.8 0.7 1.1 3.7 2.6 0.7 2.0 132.9 267.0 14.08 12.72 36 0.391 1900K 1473 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.8 0.7 1.1 1.8 0.7 0.0 0.0 221.8 221.6 8.44 7.71 9 0.937 1900K 1473 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 334.8 5.64 5.01 27 0.209 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.6 total, 6.4 interval Flush(GB): cumulative 1.846, interval 1.846 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.67 GB write, 573.72 MB/s write, 1.83 GB read, 285.56 MB/s read, 14.1 seconds Interval compaction: 3.67 GB write, 592.00 MB/s write, 1.83 GB read, 294.66 MB/s read, 14.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 398569 Average: 2.1768 StdDev: 14.60 Min: 0 Median: 1.4345 Max: 4116 Percentiles: P50: 1.43 P75: 1.83 P99: 5.90 P99.9: 12.82 P99.99: 20.80 ------------------------------------------------------ [ 0, 1 ] 90908 22.809% 22.809% ##### ( 1, 2 ] 249440 62.584% 85.392% ############# ( 2, 3 ] 31064 7.794% 93.186% ## ( 3, 4 ] 14861 3.729% 96.915% # ( 4, 6 ] 8735 2.192% 99.107% ( 6, 10 ] 2778 0.697% 99.804% ( 10, 15 ] 681 0.171% 99.974% ( 15, 22 ] 75 0.019% 99.993% ( 22, 34 ] 10 0.003% 99.996% ( 34, 51 ] 5 0.001% 99.997% ( 51, 76 ] 5 0.001% 99.998% ( 76, 110 ] 2 0.001% 99.999% ( 110, 170 ] 1 0.000% 99.999% ( 170, 250 ] 26 0.007% 100.006% ( 250, 380 ] 7 0.002% 100.007% ( 380, 580 ] 6 0.002% 100.009% ( 580, 870 ] 7 0.002% 100.011% ( 870, 1300 ] 9 0.002% 100.013% ( 1300, 1900 ] 1 0.000% 100.013% ( 1900, 2900 ] 4 0.001% 100.014% ( 2900, 4400 ] 3 0.001% 100.015% ** Level 1 read latency histogram (micros): Count: 622 Average: 7.5627 StdDev: 50.17 Min: 0 Median: 2.3077 Max: 988 Percentiles: P50: 2.31 P75: 3.24 P99: 70.50 P99.9: 988.00 P99.99: 988.00 ------------------------------------------------------ [ 0, 1 ] 32 5.145% 5.145% # ( 1, 2 ] 219 35.209% 40.354% ####### ( 2, 3 ] 195 31.350% 71.704% ###### ( 3, 4 ] 87 13.987% 85.691% ### ( 4, 6 ] 43 6.913% 92.605% # ( 6, 10 ] 26 4.180% 96.785% # ( 10, 15 ] 12 1.929% 98.714% ( 15, 22 ] 1 0.161% 98.875% ( 51, 76 ] 1 0.161% 99.035% ( 110, 170 ] 1 0.161% 99.196% ( 250, 380 ] 3 0.482% 99.678% ( 380, 580 ] 1 0.161% 99.839% ( 870, 1300 ] 1 0.161% 100.000% ** Level 2 read latency histogram (micros): Count: 48741 Average: 2.3671 StdDev: 23.54 Min: 1 Median: 1.4748 Max: 4403 Percentiles: P50: 1.47 P75: 1.86 P99: 6.64 P99.9: 14.22 P99.99: 492.59 ------------------------------------------------------ [ 0, 1 ] 9514 19.520% 19.520% #### ( 1, 2 ] 31291 64.199% 83.718% ############# ( 2, 3 ] 3802 7.800% 91.518% ## ( 3, 4 ] 2214 4.542% 96.061% # ( 4, 6 ] 1369 2.809% 98.870% # ( 6, 10 ] 395 0.810% 99.680% ( 10, 15 ] 127 0.261% 99.941% ( 15, 22 ] 15 0.031% 99.971% ( 22, 34 ] 5 0.010% 99.982% ( 34, 51 ] 1 0.002% 99.984% ( 170, 250 ] 1 0.002% 99.986% ( 250, 380 ] 1 0.002% 99.988% ( 380, 580 ] 2 0.004% 99.992% ( 580, 870 ] 2 0.004% 99.996% ( 870, 1300 ] 1 0.002% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ( 4400, 6600 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 219232 Average: 3.3998 StdDev: 37.21 Min: 0 Median: 1.5681 Max: 5685 Percentiles: P50: 1.57 P75: 1.98 P99: 9.70 P99.9: 186.53 P99.99: 554.85 ------------------------------------------------------ [ 0, 1 ] 33342 15.209% 15.209% ### ( 1, 2 ] 134266 61.244% 76.452% ############ ( 2, 3 ] 26132 11.920% 88.372% ## ( 3, 4 ] 12097 5.518% 93.890% # ( 4, 6 ] 7476 3.410% 97.300% # ( 6, 10 ] 4033 1.840% 99.140% ( 10, 15 ] 1012 0.462% 99.601% ( 15, 22 ] 113 0.052% 99.653% ( 22, 34 ] 73 0.033% 99.686% ( 34, 51 ] 15 0.007% 99.693% ( 51, 76 ] 9 0.004% 99.697% ( 76, 110 ] 154 0.070% 99.767% ( 110, 170 ] 274 0.125% 99.892% ( 170, 250 ] 86 0.039% 99.932% ( 250, 380 ] 74 0.034% 99.965% ( 380, 580 ] 63 0.029% 99.994% ( 580, 870 ] 19 0.009% 100.003% ( 870, 1300 ] 12 0.005% 100.008% ( 1300, 1900 ] 7 0.003% 100.011% ( 1900, 2900 ] 10 0.005% 100.016% ( 2900, 4400 ] 11 0.005% 100.021% ( 4400, 6600 ] 1 0.000% 100.021% ** Level 4 read latency histogram (micros): Count: 315 Average: 162.6730 StdDev: 653.64 Min: 0 Median: 1.2267 Max: 4529 Percentiles: P50: 1.23 P75: 5.70 P99: 3968.75 P99.9: 4529.00 P99.99: 4529.00 ------------------------------------------------------ [ 0, 1 ] 138 43.810% 43.810% ######### ( 1, 2 ] 86 27.302% 71.111% ##### ( 2, 3 ] 6 1.905% 73.016% ( 3, 4 ] 2 0.635% 73.651% ( 4, 6 ] 5 1.587% 75.238% ( 6, 10 ] 49 15.556% 90.794% ### ( 10, 15 ] 2 0.635% 91.429% ( 15, 22 ] 1 0.317% 91.746% ( 110, 170 ] 1 0.317% 92.063% ( 250, 380 ] 2 0.635% 92.698% ( 380, 580 ] 1 0.317% 93.016% ( 580, 870 ] 3 0.952% 93.968% ( 870, 1300 ] 3 0.952% 94.921% ( 1300, 1900 ] 3 0.952% 95.873% ( 1900, 2900 ] 7 2.222% 98.095% ( 2900, 4400 ] 4 1.270% 99.365% ( 4400, 6600 ] 2 0.635% 100.000% ** DB Stats ** Uptime(secs): 6.6 total, 3.3 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 300.36 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.581 H:M:S, 8.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 295.42 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.369 H:M:S, 11.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/15-14:03:02 ... thread 0: (1000000,3000000) ops and (332198.5,320523.5) ops/second in (3.010248,9.359688) 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/4 2.34 GB 207.7 1.8 0.0 1.8 4.6 2.8 0.0 1.7 119.2 297.8 15.86 14.74 48 0.330 1918K 1956 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 230.1 229.8 1.10 1.05 1 1.095 255K 254 0.0 0.0 L2 1/0 77.27 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.3 1.5 228.8 228.7 0.84 0.80 2 0.422 196K 93 0.0 0.0 L3 20/0 863.58 MB 0.9 1.1 0.2 0.9 1.1 0.2 0.3 5.8 229.3 228.4 4.89 4.51 2 2.445 1138K 4174 0.0 0.0 L4 174/0 9.58 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 130.7 130.8 1.29 0.86 1 1.286 170K 0 0.0 0.0 L5 1048/0 86.06 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 1257/4 98.90 GB 0.0 3.5 0.7 2.8 6.3 3.5 1.4 2.3 151.2 269.1 23.98 21.95 54 0.444 3680K 6477 0.0 0.0 Int 0/0 0.00 KB 0.0 3.5 0.7 2.8 6.3 3.5 1.3 2.3 151.2 269.1 23.98 21.95 54 0.444 3680K 6477 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.5 0.7 2.8 3.5 0.7 0.0 0.0 231.5 231.0 15.66 14.55 13 1.205 3680K 6477 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 340.9 8.32 7.40 41 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.6 total, 9.4 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.30 GB write, 674.74 MB/s write, 3.54 GB read, 379.00 MB/s read, 24.0 seconds Interval compaction: 6.30 GB write, 689.33 MB/s write, 3.54 GB read, 387.19 MB/s read, 24.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: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 638943 Average: 2.1126 StdDev: 12.66 Min: 0 Median: 1.4078 Max: 4116 Percentiles: P50: 1.41 P75: 1.81 P99: 5.78 P99.9: 12.55 P99.99: 21.00 ------------------------------------------------------ [ 0, 1 ] 157148 24.595% 24.595% ##### ( 1, 2 ] 398021 62.294% 86.889% ############ ( 2, 3 ] 45161 7.068% 93.957% # ( 3, 4 ] 21350 3.341% 97.298% # ( 4, 6 ] 12234 1.915% 99.213% ( 6, 10 ] 3890 0.609% 99.822% ( 10, 15 ] 980 0.153% 99.975% ( 15, 22 ] 111 0.017% 99.992% ( 22, 34 ] 16 0.003% 99.995% ( 34, 51 ] 5 0.001% 99.996% ( 51, 76 ] 6 0.001% 99.997% ( 76, 110 ] 3 0.000% 99.997% ( 110, 170 ] 1 0.000% 99.997% ( 170, 250 ] 40 0.006% 100.004% ( 250, 380 ] 12 0.002% 100.005% ( 380, 580 ] 10 0.002% 100.007% ( 580, 870 ] 11 0.002% 100.009% ( 870, 1300 ] 14 0.002% 100.011% ( 1300, 1900 ] 4 0.001% 100.012% ( 1900, 2900 ] 4 0.001% 100.012% ( 2900, 4400 ] 3 0.000% 100.013% ** Level 1 read latency histogram (micros): Count: 622 Average: 7.5627 StdDev: 50.17 Min: 0 Median: 2.3077 Max: 988 Percentiles: P50: 2.31 P75: 3.24 P99: 70.50 P99.9: 988.00 P99.99: 988.00 ------------------------------------------------------ [ 0, 1 ] 32 5.145% 5.145% # ( 1, 2 ] 219 35.209% 40.354% ####### ( 2, 3 ] 195 31.350% 71.704% ###### ( 3, 4 ] 87 13.987% 85.691% ### ( 4, 6 ] 43 6.913% 92.605% # ( 6, 10 ] 26 4.180% 96.785% # ( 10, 15 ] 12 1.929% 98.714% ( 15, 22 ] 1 0.161% 98.875% ( 51, 76 ] 1 0.161% 99.035% ( 110, 170 ] 1 0.161% 99.196% ( 250, 380 ] 3 0.482% 99.678% ( 380, 580 ] 1 0.161% 99.839% ( 870, 1300 ] 1 0.161% 100.000% ** Level 2 read latency histogram (micros): Count: 77249 Average: 2.5087 StdDev: 19.58 Min: 1 Median: 1.5092 Max: 4403 Percentiles: P50: 1.51 P75: 1.90 P99: 8.17 P99.9: 30.14 P99.99: 473.57 ------------------------------------------------------ [ 0, 1 ] 13434 17.391% 17.391% ### ( 1, 2 ] 49474 64.045% 81.435% ############# ( 2, 3 ] 6830 8.842% 90.277% ## ( 3, 4 ] 3880 5.023% 95.300% # ( 4, 6 ] 2342 3.032% 98.331% # ( 6, 10 ] 950 1.230% 99.561% ( 10, 15 ] 229 0.296% 99.858% ( 15, 22 ] 28 0.036% 99.894% ( 22, 34 ] 7 0.009% 99.903% ( 34, 51 ] 3 0.004% 99.907% ( 76, 110 ] 13 0.017% 99.924% ( 110, 170 ] 38 0.049% 99.973% ( 170, 250 ] 3 0.004% 99.977% ( 250, 380 ] 7 0.009% 99.986% ( 380, 580 ] 7 0.009% 99.995% ( 580, 870 ] 2 0.003% 99.997% ( 870, 1300 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ( 4400, 6600 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 250724 Average: 3.3473 StdDev: 35.46 Min: 0 Median: 1.5529 Max: 5685 Percentiles: P50: 1.55 P75: 1.96 P99: 9.61 P99.9: 200.21 P99.99: 597.47 ------------------------------------------------------ [ 0, 1 ] 39630 15.806% 15.806% ### ( 1, 2 ] 155062 61.846% 77.652% ############ ( 2, 3 ] 28270 11.275% 88.927% ## ( 3, 4 ] 13174 5.254% 94.182% # ( 4, 6 ] 7915 3.157% 97.339% # ( 6, 10 ] 4622 1.843% 99.182% ( 10, 15 ] 1067 0.426% 99.608% ( 15, 22 ] 127 0.051% 99.658% ( 22, 34 ] 74 0.030% 99.688% ( 34, 51 ] 15 0.006% 99.694% ( 51, 76 ] 9 0.004% 99.697% ( 76, 110 ] 154 0.061% 99.759% ( 110, 170 ] 315 0.126% 99.884% ( 170, 250 ] 104 0.041% 99.926% ( 250, 380 ] 88 0.035% 99.961% ( 380, 580 ] 71 0.028% 99.989% ( 580, 870 ] 32 0.013% 100.002% ( 870, 1300 ] 12 0.005% 100.007% ( 1300, 1900 ] 7 0.003% 100.010% ( 1900, 2900 ] 10 0.004% 100.014% ( 2900, 4400 ] 11 0.004% 100.018% ( 4400, 6600 ] 1 0.000% 100.018% ** Level 4 read latency histogram (micros): Count: 315 Average: 162.6730 StdDev: 653.64 Min: 0 Median: 1.2267 Max: 4529 Percentiles: P50: 1.23 P75: 5.70 P99: 3968.75 P99.9: 4529.00 P99.99: 4529.00 ------------------------------------------------------ [ 0, 1 ] 138 43.810% 43.810% ######### ( 1, 2 ] 86 27.302% 71.111% ##### ( 2, 3 ] 6 1.905% 73.016% ( 3, 4 ] 2 0.635% 73.651% ( 4, 6 ] 5 1.587% 75.238% ( 6, 10 ] 49 15.556% 90.794% ### ( 10, 15 ] 2 0.635% 91.429% ( 15, 22 ] 1 0.317% 91.746% ( 110, 170 ] 1 0.317% 92.063% ( 250, 380 ] 2 0.635% 92.698% ( 380, 580 ] 1 0.317% 93.016% ( 580, 870 ] 3 0.952% 93.968% ( 870, 1300 ] 3 0.952% 94.921% ( 1300, 1900 ] 3 0.952% 95.873% ( 1900, 2900 ] 7 2.222% 98.095% ( 2900, 4400 ] 4 1.270% 99.365% ( 4400, 6600 ] 2 0.635% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 886.3500 StdDev: 1054.01 Min: 114 Median: 358.3333 Max: 3655 Percentiles: P50: 358.33 P75: 1300.00 P99: 3655.00 P99.9: 3655.00 P99.99: 3655.00 ------------------------------------------------------ ( 110, 170 ] 3 15.000% 15.000% ### ( 170, 250 ] 2 10.000% 25.000% ## ( 250, 380 ] 6 30.000% 55.000% ###### ( 380, 580 ] 1 5.000% 60.000% # ( 580, 870 ] 2 10.000% 70.000% ## ( 870, 1300 ] 1 5.000% 75.000% # ( 1300, 1900 ] 2 10.000% 85.000% ## ( 1900, 2900 ] 1 5.000% 90.000% # ( 2900, 4400 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 9.6 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 308.73 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.751 H:M:S, 7.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 326.95 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.169 H:M:S, 5.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/15-14:03:05 ... thread 0: (1000000,4000000) ops and (302475.6,315812.6) ops/second in (3.306052,12.665740) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/16 3.32 GB 37.8 2.6 0.0 2.6 6.4 3.7 0.0 1.7 123.1 297.6 22.00 20.51 65 0.339 2750K 2816 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 230.1 229.8 1.10 1.05 1 1.095 255K 254 0.0 0.0 L2 1/0 77.27 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.3 1.5 228.8 228.7 0.84 0.80 2 0.422 196K 93 0.0 0.0 L3 20/0 863.58 MB 0.9 1.1 0.2 0.9 1.1 0.2 0.3 5.8 229.3 228.4 4.89 4.51 2 2.445 1138K 4174 0.0 0.0 L4 174/0 9.58 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 130.7 130.8 1.29 0.86 1 1.286 170K 0 0.0 0.0 L5 1048/0 86.06 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 1262/16 99.88 GB 0.0 4.3 0.7 3.6 8.1 4.5 1.4 2.2 147.5 274.9 30.12 27.73 71 0.424 4512K 7337 0.0 0.0 Int 0/0 0.00 KB 0.0 4.3 0.7 3.6 8.1 4.5 1.3 2.2 147.5 274.9 30.12 27.73 71 0.424 4512K 7337 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.3 0.7 3.6 4.3 0.7 0.0 0.0 236.3 236.0 18.80 17.63 16 1.175 4512K 7337 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 339.5 11.32 10.10 55 0.206 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.9 total, 12.7 interval Flush(GB): cumulative 3.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.08 GB write, 643.29 MB/s write, 4.34 GB read, 345.27 MB/s read, 30.1 seconds Interval compaction: 8.08 GB write, 653.57 MB/s write, 4.34 GB read, 350.79 MB/s read, 30.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 8, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 8, interval: 9 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 941868 Average: 2.1270 StdDev: 13.19 Min: 0 Median: 1.4102 Max: 4116 Percentiles: P50: 1.41 P75: 1.80 P99: 5.75 P99.9: 12.84 P99.99: 101.38 ------------------------------------------------------ [ 0, 1 ] 226145 24.010% 24.010% ##### ( 1, 2 ] 596708 63.354% 87.364% ############# ( 2, 3 ] 65865 6.993% 94.357% # ( 3, 4 ] 30013 3.187% 97.543% # ( 4, 6 ] 15679 1.665% 99.208% ( 6, 10 ] 5706 0.606% 99.814% ( 10, 15 ] 1427 0.152% 99.965% ( 15, 22 ] 153 0.016% 99.982% ( 22, 34 ] 25 0.003% 99.984% ( 34, 51 ] 6 0.001% 99.985% ( 51, 76 ] 9 0.001% 99.986% ( 76, 110 ] 52 0.006% 99.992% ( 110, 170 ] 63 0.007% 99.998% ( 170, 250 ] 66 0.007% 100.005% ( 250, 380 ] 21 0.002% 100.007% ( 380, 580 ] 21 0.002% 100.010% ( 580, 870 ] 16 0.002% 100.011% ( 870, 1300 ] 19 0.002% 100.013% ( 1300, 1900 ] 6 0.001% 100.014% ( 1900, 2900 ] 7 0.001% 100.015% ( 2900, 4400 ] 5 0.001% 100.015% ** Level 1 read latency histogram (micros): Count: 622 Average: 7.5627 StdDev: 50.17 Min: 0 Median: 2.3077 Max: 988 Percentiles: P50: 2.31 P75: 3.24 P99: 70.50 P99.9: 988.00 P99.99: 988.00 ------------------------------------------------------ [ 0, 1 ] 32 5.145% 5.145% # ( 1, 2 ] 219 35.209% 40.354% ####### ( 2, 3 ] 195 31.350% 71.704% ###### ( 3, 4 ] 87 13.987% 85.691% ### ( 4, 6 ] 43 6.913% 92.605% # ( 6, 10 ] 26 4.180% 96.785% # ( 10, 15 ] 12 1.929% 98.714% ( 15, 22 ] 1 0.161% 98.875% ( 51, 76 ] 1 0.161% 99.035% ( 110, 170 ] 1 0.161% 99.196% ( 250, 380 ] 3 0.482% 99.678% ( 380, 580 ] 1 0.161% 99.839% ( 870, 1300 ] 1 0.161% 100.000% ** Level 2 read latency histogram (micros): Count: 77249 Average: 2.5087 StdDev: 19.58 Min: 1 Median: 1.5092 Max: 4403 Percentiles: P50: 1.51 P75: 1.90 P99: 8.17 P99.9: 30.14 P99.99: 473.57 ------------------------------------------------------ [ 0, 1 ] 13434 17.391% 17.391% ### ( 1, 2 ] 49474 64.045% 81.435% ############# ( 2, 3 ] 6830 8.842% 90.277% ## ( 3, 4 ] 3880 5.023% 95.300% # ( 4, 6 ] 2342 3.032% 98.331% # ( 6, 10 ] 950 1.230% 99.561% ( 10, 15 ] 229 0.296% 99.858% ( 15, 22 ] 28 0.036% 99.894% ( 22, 34 ] 7 0.009% 99.903% ( 34, 51 ] 3 0.004% 99.907% ( 76, 110 ] 13 0.017% 99.924% ( 110, 170 ] 38 0.049% 99.973% ( 170, 250 ] 3 0.004% 99.977% ( 250, 380 ] 7 0.009% 99.986% ( 380, 580 ] 7 0.009% 99.995% ( 580, 870 ] 2 0.003% 99.997% ( 870, 1300 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ( 4400, 6600 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 250724 Average: 3.3473 StdDev: 35.46 Min: 0 Median: 1.5529 Max: 5685 Percentiles: P50: 1.55 P75: 1.96 P99: 9.61 P99.9: 200.21 P99.99: 597.47 ------------------------------------------------------ [ 0, 1 ] 39630 15.806% 15.806% ### ( 1, 2 ] 155062 61.846% 77.652% ############ ( 2, 3 ] 28270 11.275% 88.927% ## ( 3, 4 ] 13174 5.254% 94.182% # ( 4, 6 ] 7915 3.157% 97.339% # ( 6, 10 ] 4622 1.843% 99.182% ( 10, 15 ] 1067 0.426% 99.608% ( 15, 22 ] 127 0.051% 99.658% ( 22, 34 ] 74 0.030% 99.688% ( 34, 51 ] 15 0.006% 99.694% ( 51, 76 ] 9 0.004% 99.697% ( 76, 110 ] 154 0.061% 99.759% ( 110, 170 ] 315 0.126% 99.884% ( 170, 250 ] 104 0.041% 99.926% ( 250, 380 ] 88 0.035% 99.961% ( 380, 580 ] 71 0.028% 99.989% ( 580, 870 ] 32 0.013% 100.002% ( 870, 1300 ] 12 0.005% 100.007% ( 1300, 1900 ] 7 0.003% 100.010% ( 1900, 2900 ] 10 0.004% 100.014% ( 2900, 4400 ] 11 0.004% 100.018% ( 4400, 6600 ] 1 0.000% 100.018% ** Level 4 read latency histogram (micros): Count: 315 Average: 162.6730 StdDev: 653.64 Min: 0 Median: 1.2267 Max: 4529 Percentiles: P50: 1.23 P75: 5.70 P99: 3968.75 P99.9: 4529.00 P99.99: 4529.00 ------------------------------------------------------ [ 0, 1 ] 138 43.810% 43.810% ######### ( 1, 2 ] 86 27.302% 71.111% ##### ( 2, 3 ] 6 1.905% 73.016% ( 3, 4 ] 2 0.635% 73.651% ( 4, 6 ] 5 1.587% 75.238% ( 6, 10 ] 49 15.556% 90.794% ### ( 10, 15 ] 2 0.635% 91.429% ( 15, 22 ] 1 0.317% 91.746% ( 110, 170 ] 1 0.317% 92.063% ( 250, 380 ] 2 0.635% 92.698% ( 380, 580 ] 1 0.317% 93.016% ( 580, 870 ] 3 0.952% 93.968% ( 870, 1300 ] 3 0.952% 94.921% ( 1300, 1900 ] 3 0.952% 95.873% ( 1900, 2900 ] 7 2.222% 98.095% ( 2900, 4400 ] 4 1.270% 99.365% ( 4400, 6600 ] 2 0.635% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 886.3500 StdDev: 1054.01 Min: 114 Median: 358.3333 Max: 3655 Percentiles: P50: 358.33 P75: 1300.00 P99: 3655.00 P99.9: 3655.00 P99.99: 3655.00 ------------------------------------------------------ ( 110, 170 ] 3 15.000% 15.000% ### ( 170, 250 ] 2 10.000% 25.000% ## ( 250, 380 ] 6 30.000% 55.000% ###### ( 380, 580 ] 1 5.000% 60.000% # ( 580, 870 ] 2 10.000% 70.000% ## ( 870, 1300 ] 1 5.000% 75.000% # ( 1300, 1900 ] 2 10.000% 85.000% ## ( 1900, 2900 ] 1 5.000% 90.000% # ( 2900, 4400 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 12.9 total, 3.3 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 305.89 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.203 H:M:S, 9.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 297.69 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.453 H:M:S, 13.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/15-14:03:11 ... thread 0: (1000000,5000000) ops and (177157.0,273068.1) ops/second in (5.644711,18.310451) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/16 4.24 GB 138.2 4.6 0.0 4.6 9.2 4.7 0.0 2.0 144.4 292.4 32.29 30.39 85 0.380 4732K 6725 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 230.1 229.8 1.10 1.05 1 1.095 255K 254 0.0 0.0 L2 1/0 77.27 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.3 1.5 228.8 228.7 0.84 0.80 2 0.422 196K 93 0.0 0.0 L3 20/0 863.58 MB 0.9 1.1 0.2 0.9 1.1 0.2 0.3 5.8 229.3 228.4 4.89 4.51 2 2.445 1138K 4174 0.0 0.0 L4 174/0 9.58 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 130.7 130.8 1.29 0.86 1 1.286 170K 0 0.0 0.0 L5 1048/0 86.06 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 1262/16 100.80 GB 0.0 6.2 0.7 5.5 10.9 5.4 1.4 2.3 158.3 276.5 40.40 37.61 91 0.444 6494K 11K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.2 0.7 5.5 10.9 5.4 1.3 2.3 158.3 276.5 40.40 37.61 91 0.444 6494K 11K 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.2 0.7 5.5 6.2 0.7 0.0 0.0 242.1 241.7 26.42 25.12 21 1.258 6494K 11K 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 342.4 13.98 12.49 70 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): 18.5 total, 18.3 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: 10.91 GB write, 603.42 MB/s write, 6.25 GB read, 345.44 MB/s read, 40.4 seconds Interval compaction: 10.91 GB write, 610.09 MB/s write, 6.25 GB read, 349.26 MB/s read, 40.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 7, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 7, 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: 7, total-stops: 8, interval: 15 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1719981 Average: 2.2139 StdDev: 12.04 Min: 0 Median: 1.4590 Max: 4116 Percentiles: P50: 1.46 P75: 1.84 P99: 5.81 P99.9: 12.08 P99.99: 29.69 ------------------------------------------------------ [ 0, 1 ] 344563 20.033% 20.033% #### ( 1, 2 ] 1122869 65.284% 85.317% ############# ( 2, 3 ] 138374 8.045% 93.362% ## ( 3, 4 ] 64724 3.763% 97.125% # ( 4, 6 ] 35713 2.076% 99.201% ( 6, 10 ] 11091 0.645% 99.846% ( 10, 15 ] 2229 0.130% 99.976% ( 15, 22 ] 222 0.013% 99.989% ( 22, 34 ] 39 0.002% 99.991% ( 34, 51 ] 9 0.001% 99.991% ( 51, 76 ] 14 0.001% 99.992% ( 76, 110 ] 157 0.009% 100.001% ( 110, 170 ] 227 0.013% 100.015% ( 170, 250 ] 167 0.010% 100.024% ( 250, 380 ] 61 0.004% 100.028% ( 380, 580 ] 46 0.003% 100.030% ( 580, 870 ] 39 0.002% 100.033% ( 870, 1300 ] 29 0.002% 100.034% ( 1300, 1900 ] 10 0.001% 100.035% ( 1900, 2900 ] 8 0.000% 100.035% ( 2900, 4400 ] 7 0.000% 100.036% ** Level 1 read latency histogram (micros): Count: 622 Average: 7.5627 StdDev: 50.17 Min: 0 Median: 2.3077 Max: 988 Percentiles: P50: 2.31 P75: 3.24 P99: 70.50 P99.9: 988.00 P99.99: 988.00 ------------------------------------------------------ [ 0, 1 ] 32 5.145% 5.145% # ( 1, 2 ] 219 35.209% 40.354% ####### ( 2, 3 ] 195 31.350% 71.704% ###### ( 3, 4 ] 87 13.987% 85.691% ### ( 4, 6 ] 43 6.913% 92.605% # ( 6, 10 ] 26 4.180% 96.785% # ( 10, 15 ] 12 1.929% 98.714% ( 15, 22 ] 1 0.161% 98.875% ( 51, 76 ] 1 0.161% 99.035% ( 110, 170 ] 1 0.161% 99.196% ( 250, 380 ] 3 0.482% 99.678% ( 380, 580 ] 1 0.161% 99.839% ( 870, 1300 ] 1 0.161% 100.000% ** Level 2 read latency histogram (micros): Count: 77249 Average: 2.5087 StdDev: 19.58 Min: 1 Median: 1.5092 Max: 4403 Percentiles: P50: 1.51 P75: 1.90 P99: 8.17 P99.9: 30.14 P99.99: 473.57 ------------------------------------------------------ [ 0, 1 ] 13434 17.391% 17.391% ### ( 1, 2 ] 49474 64.045% 81.435% ############# ( 2, 3 ] 6830 8.842% 90.277% ## ( 3, 4 ] 3880 5.023% 95.300% # ( 4, 6 ] 2342 3.032% 98.331% # ( 6, 10 ] 950 1.230% 99.561% ( 10, 15 ] 229 0.296% 99.858% ( 15, 22 ] 28 0.036% 99.894% ( 22, 34 ] 7 0.009% 99.903% ( 34, 51 ] 3 0.004% 99.907% ( 76, 110 ] 13 0.017% 99.924% ( 110, 170 ] 38 0.049% 99.973% ( 170, 250 ] 3 0.004% 99.977% ( 250, 380 ] 7 0.009% 99.986% ( 380, 580 ] 7 0.009% 99.995% ( 580, 870 ] 2 0.003% 99.997% ( 870, 1300 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ( 4400, 6600 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 250724 Average: 3.3473 StdDev: 35.46 Min: 0 Median: 1.5529 Max: 5685 Percentiles: P50: 1.55 P75: 1.96 P99: 9.61 P99.9: 200.21 P99.99: 597.47 ------------------------------------------------------ [ 0, 1 ] 39630 15.806% 15.806% ### ( 1, 2 ] 155062 61.846% 77.652% ############ ( 2, 3 ] 28270 11.275% 88.927% ## ( 3, 4 ] 13174 5.254% 94.182% # ( 4, 6 ] 7915 3.157% 97.339% # ( 6, 10 ] 4622 1.843% 99.182% ( 10, 15 ] 1067 0.426% 99.608% ( 15, 22 ] 127 0.051% 99.658% ( 22, 34 ] 74 0.030% 99.688% ( 34, 51 ] 15 0.006% 99.694% ( 51, 76 ] 9 0.004% 99.697% ( 76, 110 ] 154 0.061% 99.759% ( 110, 170 ] 315 0.126% 99.884% ( 170, 250 ] 104 0.041% 99.926% ( 250, 380 ] 88 0.035% 99.961% ( 380, 580 ] 71 0.028% 99.989% ( 580, 870 ] 32 0.013% 100.002% ( 870, 1300 ] 12 0.005% 100.007% ( 1300, 1900 ] 7 0.003% 100.010% ( 1900, 2900 ] 10 0.004% 100.014% ( 2900, 4400 ] 11 0.004% 100.018% ( 4400, 6600 ] 1 0.000% 100.018% ** Level 4 read latency histogram (micros): Count: 315 Average: 162.6730 StdDev: 653.64 Min: 0 Median: 1.2267 Max: 4529 Percentiles: P50: 1.23 P75: 5.70 P99: 3968.75 P99.9: 4529.00 P99.99: 4529.00 ------------------------------------------------------ [ 0, 1 ] 138 43.810% 43.810% ######### ( 1, 2 ] 86 27.302% 71.111% ##### ( 2, 3 ] 6 1.905% 73.016% ( 3, 4 ] 2 0.635% 73.651% ( 4, 6 ] 5 1.587% 75.238% ( 6, 10 ] 49 15.556% 90.794% ### ( 10, 15 ] 2 0.635% 91.429% ( 15, 22 ] 1 0.317% 91.746% ( 110, 170 ] 1 0.317% 92.063% ( 250, 380 ] 2 0.635% 92.698% ( 380, 580 ] 1 0.317% 93.016% ( 580, 870 ] 3 0.952% 93.968% ( 870, 1300 ] 3 0.952% 94.921% ( 1300, 1900 ] 3 0.952% 95.873% ( 1900, 2900 ] 7 2.222% 98.095% ( 2900, 4400 ] 4 1.270% 99.365% ( 4400, 6600 ] 2 0.635% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 886.3500 StdDev: 1054.01 Min: 114 Median: 358.3333 Max: 3655 Percentiles: P50: 358.33 P75: 1300.00 P99: 3655.00 P99.9: 3655.00 P99.99: 3655.00 ------------------------------------------------------ ( 110, 170 ] 3 15.000% 15.000% ### ( 170, 250 ] 2 10.000% 25.000% ## ( 250, 380 ] 6 30.000% 55.000% ###### ( 380, 580 ] 1 5.000% 60.000% # ( 580, 870 ] 2 10.000% 70.000% ## ( 870, 1300 ] 1 5.000% 75.000% # ( 1300, 1900 ] 2 10.000% 85.000% ## ( 1900, 2900 ] 1 5.000% 90.000% # ( 2900, 4400 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 18.5 total, 5.6 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 265.79 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:3.919 H:M:S, 21.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 174.36 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.716 H:M:S, 48.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/15-14:03:18 ... thread 0: (1000000,6000000) ops and (147180.1,238997.6) ops/second in (6.794399,25.104850) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/4 2.51 GB 232.1 6.3 0.0 6.3 11.9 5.6 0.0 2.1 152.9 287.7 42.44 39.98 104 0.408 6586K 12K 0.0 0.0 L1 8/0 869.15 MB 86.9 2.9 2.9 0.0 2.9 2.9 0.2 1.0 213.8 211.3 13.84 13.34 2 6.918 3003K 34K 0.0 0.0 L2 14/7 1.76 GB 9.0 0.2 0.1 0.1 0.2 0.1 2.1 1.5 228.8 228.7 0.84 0.80 2 0.422 196K 93 0.0 0.0 L3 20/2 940.81 MB 0.8 1.2 0.3 0.9 1.2 0.3 0.3 4.5 215.0 214.2 5.66 5.05 3 1.888 1236K 4220 0.0 0.0 L4 174/0 9.58 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 130.7 130.8 1.29 0.86 1 1.286 170K 0 0.0 0.0 L5 1048/0 86.06 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 1273/13 101.69 GB 0.0 10.8 3.4 7.3 16.3 9.0 3.1 2.9 172.1 260.8 64.07 60.04 112 0.572 11M 50K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.8 3.4 7.3 16.3 9.0 3.0 2.9 172.1 260.8 64.07 60.04 112 0.572 11M 50K 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.8 3.4 7.3 10.7 3.4 0.0 0.0 233.2 232.1 47.28 45.11 27 1.751 11M 50K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.6 5.6 0.0 0.0 0.0 341.4 16.79 14.94 85 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 25.3 total, 25.1 interval Flush(GB): cumulative 5.598, interval 5.598 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.31 GB write, 660.08 MB/s write, 10.77 GB read, 435.57 MB/s read, 64.1 seconds Interval compaction: 16.31 GB write, 665.40 MB/s write, 10.77 GB read, 439.09 MB/s read, 64.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, 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: 13, total-stops: 8, interval: 21 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2480733 Average: 2.2816 StdDev: 11.83 Min: 0 Median: 1.4730 Max: 4285 Percentiles: P50: 1.47 P75: 1.85 P99: 6.24 P99.9: 13.24 P99.99: 116.93 ------------------------------------------------------ [ 0, 1 ] 471744 19.016% 19.016% #### ( 1, 2 ] 1624861 65.499% 84.516% ############# ( 2, 3 ] 204388 8.239% 92.755% ## ( 3, 4 ] 96631 3.895% 96.650% # ( 4, 6 ] 57013 2.298% 98.948% ( 6, 10 ] 21174 0.854% 99.802% ( 10, 15 ] 3768 0.152% 99.953% ( 15, 22 ] 392 0.016% 99.969% ( 22, 34 ] 56 0.002% 99.972% ( 34, 51 ] 12 0.000% 99.972% ( 51, 76 ] 19 0.001% 99.973% ( 76, 110 ] 363 0.015% 99.987% ( 110, 170 ] 562 0.023% 100.010% ( 170, 250 ] 276 0.011% 100.021% ( 250, 380 ] 131 0.005% 100.026% ( 380, 580 ] 88 0.004% 100.030% ( 580, 870 ] 71 0.003% 100.033% ( 870, 1300 ] 44 0.002% 100.035% ( 1300, 1900 ] 12 0.000% 100.035% ( 1900, 2900 ] 10 0.000% 100.036% ( 2900, 4400 ] 8 0.000% 100.036% ** Level 1 read latency histogram (micros): Count: 196997 Average: 3.7635 StdDev: 24.28 Min: 0 Median: 1.7922 Max: 2312 Percentiles: P50: 1.79 P75: 2.67 P99: 9.87 P99.9: 196.44 P99.99: 370.56 ------------------------------------------------------ [ 0, 1 ] 7235 3.673% 3.673% # ( 1, 2 ] 115206 58.481% 62.154% ############ ( 2, 3 ] 37874 19.226% 81.379% #### ( 3, 4 ] 15808 8.024% 89.404% ## ( 4, 6 ] 15073 7.651% 97.055% ## ( 6, 10 ] 3961 2.011% 99.066% ( 10, 15 ] 1254 0.637% 99.703% ( 15, 22 ] 161 0.082% 99.784% ( 22, 34 ] 11 0.006% 99.790% ( 34, 51 ] 2 0.001% 99.791% ( 51, 76 ] 1 0.001% 99.791% ( 76, 110 ] 44 0.022% 99.814% ( 110, 170 ] 131 0.066% 99.880% ( 170, 250 ] 118 0.060% 99.940% ( 250, 380 ] 106 0.054% 99.994% ( 380, 580 ] 74 0.038% 100.031% ( 580, 870 ] 50 0.025% 100.057% ( 870, 1300 ] 34 0.017% 100.074% ( 1300, 1900 ] 7 0.004% 100.078% ( 1900, 2900 ] 1 0.001% 100.078% ** Level 2 read latency histogram (micros): Count: 77249 Average: 2.5087 StdDev: 19.58 Min: 1 Median: 1.5092 Max: 4403 Percentiles: P50: 1.51 P75: 1.90 P99: 8.17 P99.9: 30.14 P99.99: 473.57 ------------------------------------------------------ [ 0, 1 ] 13434 17.391% 17.391% ### ( 1, 2 ] 49474 64.045% 81.435% ############# ( 2, 3 ] 6830 8.842% 90.277% ## ( 3, 4 ] 3880 5.023% 95.300% # ( 4, 6 ] 2342 3.032% 98.331% # ( 6, 10 ] 950 1.230% 99.561% ( 10, 15 ] 229 0.296% 99.858% ( 15, 22 ] 28 0.036% 99.894% ( 22, 34 ] 7 0.009% 99.903% ( 34, 51 ] 3 0.004% 99.907% ( 76, 110 ] 13 0.017% 99.924% ( 110, 170 ] 38 0.049% 99.973% ( 170, 250 ] 3 0.004% 99.977% ( 250, 380 ] 7 0.009% 99.986% ( 380, 580 ] 7 0.009% 99.995% ( 580, 870 ] 2 0.003% 99.997% ( 870, 1300 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ( 4400, 6600 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 255568 Average: 3.9044 StdDev: 38.93 Min: 0 Median: 1.5621 Max: 5685 Percentiles: P50: 1.56 P75: 1.97 P99: 10.17 P99.9: 353.88 P99.99: 813.02 ------------------------------------------------------ [ 0, 1 ] 39702 15.535% 15.535% ### ( 1, 2 ] 156704 61.316% 76.851% ############ ( 2, 3 ] 29545 11.561% 88.411% ## ( 3, 4 ] 13722 5.369% 93.781% # ( 4, 6 ] 8479 3.318% 97.098% # ( 6, 10 ] 4822 1.887% 98.985% ( 10, 15 ] 1131 0.443% 99.428% ( 15, 22 ] 151 0.059% 99.487% ( 22, 34 ] 78 0.031% 99.517% ( 34, 51 ] 15 0.006% 99.523% ( 51, 76 ] 11 0.004% 99.527% ( 76, 110 ] 205 0.080% 99.608% ( 110, 170 ] 412 0.161% 99.769% ( 170, 250 ] 190 0.074% 99.843% ( 250, 380 ] 182 0.071% 99.914% ( 380, 580 ] 138 0.054% 99.968% ( 580, 870 ] 69 0.027% 99.995% ( 870, 1300 ] 25 0.010% 100.005% ( 1300, 1900 ] 10 0.004% 100.009% ( 1900, 2900 ] 11 0.004% 100.013% ( 2900, 4400 ] 11 0.004% 100.018% ( 4400, 6600 ] 1 0.000% 100.018% ** Level 4 read latency histogram (micros): Count: 315 Average: 162.6730 StdDev: 653.64 Min: 0 Median: 1.2267 Max: 4529 Percentiles: P50: 1.23 P75: 5.70 P99: 3968.75 P99.9: 4529.00 P99.99: 4529.00 ------------------------------------------------------ [ 0, 1 ] 138 43.810% 43.810% ######### ( 1, 2 ] 86 27.302% 71.111% ##### ( 2, 3 ] 6 1.905% 73.016% ( 3, 4 ] 2 0.635% 73.651% ( 4, 6 ] 5 1.587% 75.238% ( 6, 10 ] 49 15.556% 90.794% ### ( 10, 15 ] 2 0.635% 91.429% ( 15, 22 ] 1 0.317% 91.746% ( 110, 170 ] 1 0.317% 92.063% ( 250, 380 ] 2 0.635% 92.698% ( 380, 580 ] 1 0.317% 93.016% ( 580, 870 ] 3 0.952% 93.968% ( 870, 1300 ] 3 0.952% 94.921% ( 1300, 1900 ] 3 0.952% 95.873% ( 1900, 2900 ] 7 2.222% 98.095% ( 2900, 4400 ] 4 1.270% 99.365% ( 4400, 6600 ] 2 0.635% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 886.3500 StdDev: 1054.01 Min: 114 Median: 358.3333 Max: 3655 Percentiles: P50: 358.33 P75: 1300.00 P99: 3655.00 P99.9: 3655.00 P99.99: 3655.00 ------------------------------------------------------ ( 110, 170 ] 3 15.000% 15.000% ### ( 170, 250 ] 2 10.000% 25.000% ## ( 250, 380 ] 6 30.000% 55.000% ###### ( 380, 580 ] 1 5.000% 60.000% # ( 580, 870 ] 2 10.000% 70.000% ## ( 870, 1300 ] 1 5.000% 75.000% # ( 1300, 1900 ] 2 10.000% 85.000% ## ( 1900, 2900 ] 1 5.000% 90.000% # ( 2900, 4400 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 25.3 total, 6.8 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 233.32 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:7.658 H:M:S, 30.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 144.85 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:3.739 H:M:S, 55.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/15-14:03:21 ... thread 0: (1000000,7000000) ops and (273319.0,243363.3) ops/second in (3.658728,28.763578) 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.56 GB 37.8 7.1 0.0 7.1 13.7 6.6 0.0 2.1 148.1 286.9 48.91 45.90 121 0.404 7354K 12K 0.0 0.0 L1 8/8 869.15 MB 0.0 2.9 2.9 0.0 2.9 2.9 0.2 1.0 213.8 211.3 13.84 13.34 2 6.918 3003K 34K 0.0 0.0 L2 5/4 643.89 MB 1.3 0.2 0.1 0.1 0.2 0.1 2.1 1.5 228.8 228.7 0.84 0.80 2 0.422 196K 93 0.0 0.0 L3 30/3 1.12 GB 1.0 2.5 1.4 1.1 2.5 1.4 0.3 1.8 206.9 206.3 12.48 11.37 6 2.081 2622K 7195 0.0 0.0 L4 179/0 9.52 GB 1.0 0.4 0.4 0.0 0.4 0.4 0.9 1.0 141.4 141.2 3.25 2.33 7 0.465 464K 471 0.0 0.0 L5 1060/0 87.05 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1296/27 102.73 GB 0.0 13.1 4.8 8.3 19.7 11.4 4.8 3.0 169.4 254.4 79.33 73.76 138 0.575 13M 54K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.1 4.8 8.3 19.7 11.4 4.7 3.0 169.4 254.4 79.33 73.76 138 0.575 13M 54K 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 13.1 4.8 8.3 13.1 4.8 0.0 0.0 227.2 226.2 59.15 55.90 39 1.517 13M 54K 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 337.1 20.18 17.85 99 0.204 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 29.0 total, 28.8 interval Flush(GB): cumulative 6.644, interval 6.644 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 19.71 GB write, 696.82 MB/s write, 13.12 GB read, 463.85 MB/s read, 79.3 seconds Interval compaction: 19.71 GB write, 701.72 MB/s write, 13.12 GB read, 467.11 MB/s read, 79.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 15, interval: 28 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2756552 Average: 2.3388 StdDev: 13.75 Min: 0 Median: 1.4898 Max: 6336 Percentiles: P50: 1.49 P75: 1.87 P99: 6.48 P99.9: 13.61 P99.99: 129.53 ------------------------------------------------------ [ 0, 1 ] 497475 18.047% 18.047% #### ( 1, 2 ] 1798381 65.240% 83.287% ############# ( 2, 3 ] 243962 8.850% 92.137% ## ( 3, 4 ] 114757 4.163% 96.301% # ( 4, 6 ] 71459 2.592% 98.893% # ( 6, 10 ] 24419 0.886% 99.779% ( 10, 15 ] 4636 0.168% 99.947% ( 15, 22 ] 474 0.017% 99.964% ( 22, 34 ] 70 0.003% 99.967% ( 34, 51 ] 17 0.001% 99.967% ( 51, 76 ] 21 0.001% 99.968% ( 76, 110 ] 399 0.014% 99.983% ( 110, 170 ] 637 0.023% 100.006% ( 170, 250 ] 328 0.012% 100.018% ( 250, 380 ] 160 0.006% 100.023% ( 380, 580 ] 112 0.004% 100.027% ( 580, 870 ] 88 0.003% 100.031% ( 870, 1300 ] 55 0.002% 100.033% ( 1300, 1900 ] 17 0.001% 100.033% ( 1900, 2900 ] 13 0.000% 100.034% ( 2900, 4400 ] 13 0.000% 100.034% ( 4400, 6600 ] 1 0.000% 100.034% ** Level 1 read latency histogram (micros): Count: 483666 Average: 3.4446 StdDev: 25.08 Min: 0 Median: 1.7280 Max: 5182 Percentiles: P50: 1.73 P75: 2.48 P99: 9.64 P99.9: 160.74 P99.99: 374.51 ------------------------------------------------------ [ 0, 1 ] 24890 5.146% 5.146% # ( 1, 2 ] 297992 61.611% 66.757% ############ ( 2, 3 ] 82634 17.085% 83.842% ### ( 3, 4 ] 34240 7.079% 90.921% # ( 4, 6 ] 30444 6.294% 97.216% # ( 6, 10 ] 9493 1.963% 99.179% ( 10, 15 ] 2859 0.591% 99.770% ( 15, 22 ] 298 0.062% 99.831% ( 22, 34 ] 26 0.005% 99.837% ( 34, 51 ] 4 0.001% 99.837% ( 51, 76 ] 3 0.001% 99.838% ( 76, 110 ] 105 0.022% 99.860% ( 110, 170 ] 231 0.048% 99.908% ( 170, 250 ] 210 0.043% 99.951% ( 250, 380 ] 198 0.041% 99.992% ( 380, 580 ] 145 0.030% 100.022% ( 580, 870 ] 86 0.018% 100.040% ( 870, 1300 ] 52 0.011% 100.050% ( 1300, 1900 ] 14 0.003% 100.053% ( 1900, 2900 ] 5 0.001% 100.054% ( 2900, 4400 ] 3 0.001% 100.055% ( 4400, 6600 ] 2 0.000% 100.055% ** Level 2 read latency histogram (micros): Count: 77249 Average: 2.5087 StdDev: 19.58 Min: 1 Median: 1.5092 Max: 4403 Percentiles: P50: 1.51 P75: 1.90 P99: 8.17 P99.9: 30.14 P99.99: 473.57 ------------------------------------------------------ [ 0, 1 ] 13434 17.391% 17.391% ### ( 1, 2 ] 49474 64.045% 81.435% ############# ( 2, 3 ] 6830 8.842% 90.277% ## ( 3, 4 ] 3880 5.023% 95.300% # ( 4, 6 ] 2342 3.032% 98.331% # ( 6, 10 ] 950 1.230% 99.561% ( 10, 15 ] 229 0.296% 99.858% ( 15, 22 ] 28 0.036% 99.894% ( 22, 34 ] 7 0.009% 99.903% ( 34, 51 ] 3 0.004% 99.907% ( 76, 110 ] 13 0.017% 99.924% ( 110, 170 ] 38 0.049% 99.973% ( 170, 250 ] 3 0.004% 99.977% ( 250, 380 ] 7 0.009% 99.986% ( 380, 580 ] 7 0.009% 99.995% ( 580, 870 ] 2 0.003% 99.997% ( 870, 1300 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ( 4400, 6600 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 355644 Average: 3.7372 StdDev: 34.86 Min: 0 Median: 1.6400 Max: 5685 Percentiles: P50: 1.64 P75: 2.26 P99: 9.62 P99.9: 238.20 P99.99: 496.36 ------------------------------------------------------ [ 0, 1 ] 42744 12.019% 12.019% ## ( 1, 2 ] 211059 59.346% 71.364% ############ ( 2, 3 ] 50241 14.127% 85.491% ### ( 3, 4 ] 24120 6.782% 92.273% # ( 4, 6 ] 18073 5.082% 97.355% # ( 6, 10 ] 6469 1.819% 99.174% ( 10, 15 ] 1410 0.396% 99.570% ( 15, 22 ] 195 0.055% 99.625% ( 22, 34 ] 96 0.027% 99.652% ( 34, 51 ] 20 0.006% 99.658% ( 51, 76 ] 11 0.003% 99.661% ( 76, 110 ] 217 0.061% 99.722% ( 110, 170 ] 439 0.123% 99.845% ( 170, 250 ] 228 0.064% 99.909% ( 250, 380 ] 198 0.056% 99.965% ( 380, 580 ] 152 0.043% 100.008% ( 580, 870 ] 80 0.022% 100.030% ( 870, 1300 ] 31 0.009% 100.039% ( 1300, 1900 ] 10 0.003% 100.042% ( 1900, 2900 ] 15 0.004% 100.046% ( 2900, 4400 ] 11 0.003% 100.049% ( 4400, 6600 ] 1 0.000% 100.049% ** Level 4 read latency histogram (micros): Count: 4777 Average: 65.8715 StdDev: 312.93 Min: 0 Median: 1.8846 Max: 6016 Percentiles: P50: 1.88 P75: 3.33 P99: 1442.64 P99.9: 4133.45 P99.99: 6016.00 ------------------------------------------------------ [ 0, 1 ] 376 7.871% 7.871% ## ( 1, 2 ] 2275 47.624% 55.495% ########## ( 2, 3 ] 777 16.265% 71.761% ### ( 3, 4 ] 469 9.818% 81.578% ## ( 4, 6 ] 286 5.987% 87.565% # ( 6, 10 ] 134 2.805% 90.371% # ( 10, 15 ] 34 0.712% 91.082% ( 15, 22 ] 5 0.105% 91.187% ( 76, 110 ] 16 0.335% 91.522% ( 110, 170 ] 34 0.712% 92.234% ( 170, 250 ] 57 1.193% 93.427% ( 250, 380 ] 64 1.340% 94.767% ( 380, 580 ] 75 1.570% 96.337% ( 580, 870 ] 83 1.737% 98.074% ( 870, 1300 ] 39 0.816% 98.891% ( 1300, 1900 ] 22 0.461% 99.351% ( 1900, 2900 ] 18 0.377% 99.728% ( 2900, 4400 ] 10 0.209% 99.937% ( 4400, 6600 ] 3 0.063% 100.000% ** Level 5 read latency histogram (micros): Count: 80 Average: 863.1000 StdDev: 1027.50 Min: 98 Median: 380.0000 Max: 4769 Percentiles: P50: 380.00 P75: 1156.67 P99: 4769.00 P99.9: 4769.00 P99.99: 4769.00 ------------------------------------------------------ ( 76, 110 ] 2 2.500% 2.500% # ( 110, 170 ] 17 21.250% 23.750% #### ( 170, 250 ] 10 12.500% 36.250% ### ( 250, 380 ] 11 13.750% 50.000% ### ( 380, 580 ] 6 7.500% 57.500% ## ( 580, 870 ] 10 12.500% 70.000% ### ( 870, 1300 ] 6 7.500% 77.500% ## ( 1300, 1900 ] 5 6.250% 83.750% # ( 1900, 2900 ] 7 8.750% 92.500% ## ( 2900, 4400 ] 5 6.250% 98.750% # ( 4400, 6600 ] 1 1.250% 100.000% ** DB Stats ** Uptime(secs): 29.0 total, 3.7 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 237.83 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:8.285 H:M:S, 28.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 269.00 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.628 H:M:S, 17.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/07/15-14:03:25 ... thread 0: (1000000,8000000) ops and (233871.0,242134.9) ops/second in (4.275862,33.039440) 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/12 4.48 GB 138.4 8.0 0.0 8.0 15.5 7.6 0.0 2.1 145.4 282.8 56.31 52.24 137 0.411 8313K 13K 0.0 0.0 L1 8/8 869.15 MB 0.0 2.9 2.9 0.0 2.9 2.9 0.2 1.0 213.8 211.3 13.84 13.34 2 6.918 3003K 34K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 2.1 1.5 228.8 228.7 0.84 0.80 2 0.422 196K 93 0.0 0.0 L3 27/0 970.21 MB 1.0 3.4 2.0 1.4 3.4 2.0 0.3 1.7 197.1 196.6 17.67 15.55 9 1.963 3537K 8793 0.0 0.0 L4 189/0 9.71 GB 1.0 1.3 1.2 0.1 1.3 1.2 0.9 1.1 118.7 118.5 11.24 6.68 25 0.450 1320K 1097 0.0 0.0 L5 1068/0 87.66 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1310/20 103.65 GB 0.0 15.8 6.3 9.5 23.3 13.8 5.4 3.1 161.7 238.7 99.90 88.61 175 0.571 16M 57K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.8 6.3 9.5 23.3 13.8 5.3 3.1 161.7 238.7 99.90 88.61 175 0.571 16M 57K 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.8 6.3 9.5 15.7 6.2 0.0 0.0 211.7 210.9 76.31 68.19 63 1.211 16M 57K 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 328.5 23.59 20.42 112 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): 33.2 total, 33.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: 23.29 GB write, 717.30 MB/s write, 15.78 GB read, 486.00 MB/s read, 99.9 seconds Interval compaction: 23.29 GB write, 721.69 MB/s write, 15.78 GB read, 488.98 MB/s read, 99.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 27, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 15, total-stops: 27, interval: 42 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3246757 Average: 2.4058 StdDev: 16.56 Min: 0 Median: 1.5077 Max: 6336 Percentiles: P50: 1.51 P75: 1.89 P99: 6.78 P99.9: 13.72 P99.99: 129.69 ------------------------------------------------------ [ 0, 1 ] 552460 17.016% 17.016% ### ( 1, 2 ] 2109482 64.972% 81.988% ############# ( 2, 3 ] 308347 9.497% 91.485% ## ( 3, 4 ] 142928 4.402% 95.887% # ( 4, 6 ] 95102 2.929% 98.816% # ( 6, 10 ] 30740 0.947% 99.763% ( 10, 15 ] 5977 0.184% 99.947% ( 15, 22 ] 601 0.019% 99.966% ( 22, 34 ] 78 0.002% 99.968% ( 34, 51 ] 25 0.001% 99.969% ( 51, 76 ] 23 0.001% 99.969% ( 76, 110 ] 439 0.014% 99.983% ( 110, 170 ] 705 0.022% 100.005% ( 170, 250 ] 391 0.012% 100.017% ( 250, 380 ] 203 0.006% 100.023% ( 380, 580 ] 152 0.005% 100.028% ( 580, 870 ] 113 0.003% 100.031% ( 870, 1300 ] 73 0.002% 100.033% ( 1300, 1900 ] 26 0.001% 100.034% ( 1900, 2900 ] 20 0.001% 100.035% ( 2900, 4400 ] 26 0.001% 100.036% ( 4400, 6600 ] 4 0.000% 100.036% ** Level 1 read latency histogram (micros): Count: 521149 Average: 3.8592 StdDev: 54.03 Min: 0 Median: 1.7346 Max: 12299 Percentiles: P50: 1.73 P75: 2.51 P99: 9.70 P99.9: 181.98 P99.99: 461.38 ------------------------------------------------------ [ 0, 1 ] 26064 5.001% 5.001% # ( 1, 2 ] 319247 61.258% 66.260% ############ ( 2, 3 ] 89817 17.234% 83.494% ### ( 3, 4 ] 37497 7.195% 90.689% # ( 4, 6 ] 33853 6.496% 97.185% # ( 6, 10 ] 10214 1.960% 99.145% ( 10, 15 ] 3180 0.610% 99.755% ( 15, 22 ] 328 0.063% 99.818% ( 22, 34 ] 28 0.005% 99.823% ( 34, 51 ] 4 0.001% 99.824% ( 51, 76 ] 3 0.001% 99.825% ( 76, 110 ] 110 0.021% 99.846% ( 110, 170 ] 249 0.048% 99.894% ( 170, 250 ] 226 0.043% 99.937% ( 250, 380 ] 213 0.041% 99.978% ( 380, 580 ] 157 0.030% 100.008% ( 580, 870 ] 95 0.018% 100.026% ( 870, 1300 ] 59 0.011% 100.037% ( 1300, 1900 ] 20 0.004% 100.041% ( 1900, 2900 ] 14 0.003% 100.044% ( 2900, 4400 ] 24 0.005% 100.049% ( 4400, 6600 ] 5 0.001% 100.050% ( 6600, 9900 ] 7 0.001% 100.051% ( 9900, 14000 ] 2 0.000% 100.051% ** Level 2 read latency histogram (micros): Count: 77249 Average: 2.5087 StdDev: 19.58 Min: 1 Median: 1.5092 Max: 4403 Percentiles: P50: 1.51 P75: 1.90 P99: 8.17 P99.9: 30.14 P99.99: 473.57 ------------------------------------------------------ [ 0, 1 ] 13434 17.391% 17.391% ### ( 1, 2 ] 49474 64.045% 81.435% ############# ( 2, 3 ] 6830 8.842% 90.277% ## ( 3, 4 ] 3880 5.023% 95.300% # ( 4, 6 ] 2342 3.032% 98.331% # ( 6, 10 ] 950 1.230% 99.561% ( 10, 15 ] 229 0.296% 99.858% ( 15, 22 ] 28 0.036% 99.894% ( 22, 34 ] 7 0.009% 99.903% ( 34, 51 ] 3 0.004% 99.907% ( 76, 110 ] 13 0.017% 99.924% ( 110, 170 ] 38 0.049% 99.973% ( 170, 250 ] 3 0.004% 99.977% ( 250, 380 ] 7 0.009% 99.986% ( 380, 580 ] 7 0.009% 99.995% ( 580, 870 ] 2 0.003% 99.997% ( 870, 1300 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ( 4400, 6600 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 606519 Average: 4.7849 StdDev: 77.18 Min: 0 Median: 1.7514 Max: 15478 Percentiles: P50: 1.75 P75: 2.63 P99: 9.53 P99.9: 183.98 P99.99: 396.55 ------------------------------------------------------ [ 0, 1 ] 48853 8.055% 8.055% ## ( 1, 2 ] 338594 55.826% 63.880% ########### ( 2, 3 ] 106284 17.524% 81.404% #### ( 3, 4 ] 50911 8.394% 89.798% ## ( 4, 6 ] 45891 7.566% 97.364% ## ( 6, 10 ] 11237 1.853% 99.217% ( 10, 15 ] 2813 0.464% 99.681% ( 15, 22 ] 330 0.054% 99.735% ( 22, 34 ] 110 0.018% 99.753% ( 34, 51 ] 27 0.004% 99.758% ( 51, 76 ] 15 0.002% 99.760% ( 76, 110 ] 237 0.039% 99.799% ( 110, 170 ] 557 0.092% 99.891% ( 170, 250 ] 306 0.050% 99.942% ( 250, 380 ] 272 0.045% 99.986% ( 380, 580 ] 258 0.043% 100.029% ( 580, 870 ] 151 0.025% 100.054% ( 870, 1300 ] 74 0.012% 100.066% ( 1300, 1900 ] 36 0.006% 100.072% ( 1900, 2900 ] 46 0.008% 100.080% ( 2900, 4400 ] 89 0.015% 100.094% ( 4400, 6600 ] 23 0.004% 100.098% ( 6600, 9900 ] 12 0.002% 100.100% ( 9900, 14000 ] 1 0.000% 100.100% ( 14000, 22000 ] 1 0.000% 100.100% ** Level 4 read latency histogram (micros): Count: 18328 Average: 69.9105 StdDev: 320.57 Min: 0 Median: 1.9732 Max: 6750 Percentiles: P50: 1.97 P75: 3.40 P99: 1444.56 P99.9: 4046.00 P99.99: 5820.98 ------------------------------------------------------ [ 0, 1 ] 900 4.911% 4.911% # ( 1, 2 ] 8492 46.333% 51.244% ######### ( 2, 3 ] 3577 19.517% 70.761% #### ( 3, 4 ] 1933 10.547% 81.307% ## ( 4, 6 ] 1272 6.940% 88.247% # ( 6, 10 ] 368 2.008% 90.255% ( 10, 15 ] 147 0.802% 91.057% ( 15, 22 ] 20 0.109% 91.167% ( 22, 34 ] 3 0.016% 91.183% ( 34, 51 ] 1 0.005% 91.188% ( 76, 110 ] 34 0.186% 91.374% ( 110, 170 ] 114 0.622% 91.996% ( 170, 250 ] 178 0.971% 92.967% ( 250, 380 ] 245 1.337% 94.304% ( 380, 580 ] 314 1.713% 96.017% ( 580, 870 ] 310 1.691% 97.708% ( 870, 1300 ] 216 1.179% 98.887% ( 1300, 1900 ] 86 0.469% 99.356% ( 1900, 2900 ] 63 0.344% 99.700% ( 2900, 4400 ] 48 0.262% 99.962% ( 4400, 6600 ] 8 0.044% 100.005% ( 6600, 9900 ] 1 0.005% 100.011% ** Level 5 read latency histogram (micros): Count: 120 Average: 938.9167 StdDev: 1069.25 Min: 98 Median: 460.0000 Max: 4769 Percentiles: P50: 460.00 P75: 1300.00 P99: 4769.00 P99.9: 4769.00 P99.99: 4769.00 ------------------------------------------------------ ( 76, 110 ] 3 2.500% 2.500% # ( 110, 170 ] 22 18.333% 20.833% #### ( 170, 250 ] 15 12.500% 33.333% ### ( 250, 380 ] 16 13.333% 46.667% ### ( 380, 580 ] 10 8.333% 55.000% ## ( 580, 870 ] 15 12.500% 67.500% ### ( 870, 1300 ] 9 7.500% 75.000% ## ( 1300, 1900 ] 7 5.833% 80.833% # ( 1900, 2900 ] 13 10.833% 91.667% ## ( 2900, 4400 ] 8 6.667% 98.333% # ( 4400, 6600 ] 2 1.667% 100.000% ** DB Stats ** Uptime(secs): 33.2 total, 4.3 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 236.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:9.356 H:M:S, 28.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 230.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:1.071 H:M:S, 25.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/15-14:03:42 ... thread 0: (1000000,9000000) ops and (61497.6,182554.9) ops/second in (16.260801,49.300241) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/15 2.58 GB 6.3 8.7 0.0 8.7 17.3 8.5 0.0 2.0 142.4 281.6 62.80 57.82 155 0.405 9081K 14K 0.0 0.0 L1 16/16 1.91 GB 0.0 6.6 5.8 0.8 6.5 5.7 0.2 1.1 212.7 209.7 31.87 30.32 3 10.622 6784K 34K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 3.8 1.5 228.8 228.7 0.84 0.80 2 0.422 196K 93 0.0 0.0 L3 25/1 1019.66 MB 1.0 6.1 3.5 2.6 6.1 3.5 0.6 1.7 172.1 171.2 36.23 29.09 22 1.647 6332K 31K 0.0 0.0 L4 181/15 9.73 GB 1.0 3.2 2.9 0.3 3.2 2.9 0.9 1.1 127.1 126.8 25.83 16.04 45 0.574 3263K 2555 0.0 0.0 L5 1088/0 89.32 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1326/47 104.54 GB 0.0 24.8 12.3 12.5 33.2 20.7 9.1 3.9 161.4 216.0 157.57 134.07 227 0.694 25M 83K 0.0 0.0 Int 0/0 0.00 KB 0.0 24.8 12.3 12.5 33.2 20.7 9.0 3.9 161.4 216.0 157.57 134.07 227 0.694 25M 83K 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 24.8 12.3 12.5 24.7 12.2 0.0 0.0 195.0 193.9 130.42 110.94 100 1.304 25M 83K 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 322.6 27.15 23.13 127 0.214 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 49.5 total, 49.3 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: 33.24 GB write, 687.60 MB/s write, 24.84 GB read, 513.74 MB/s read, 157.6 seconds Interval compaction: 33.24 GB write, 690.42 MB/s write, 24.84 GB read, 515.85 MB/s read, 157.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 20, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 20, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 34, pending-compaction-bytes-delays: 26, pending-compaction-bytes-stops: 0, total-delays: 46, total-stops: 34, interval: 80 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4012310 Average: 2.6266 StdDev: 24.97 Min: 0 Median: 1.5059 Max: 6336 Percentiles: P50: 1.51 P75: 1.89 P99: 7.36 P99.9: 14.98 P99.99: 235.05 ------------------------------------------------------ [ 0, 1 ] 696587 17.361% 17.361% ### ( 1, 2 ] 2588599 64.516% 81.878% ############# ( 2, 3 ] 375853 9.367% 91.245% ## ( 3, 4 ] 174256 4.343% 95.588% # ( 4, 6 ] 122546 3.054% 98.642% # ( 6, 10 ] 42134 1.050% 99.693% ( 10, 15 ] 8349 0.208% 99.901% ( 15, 22 ] 884 0.022% 99.923% ( 22, 34 ] 93 0.002% 99.925% ( 34, 51 ] 33 0.001% 99.926% ( 51, 76 ] 30 0.001% 99.927% ( 76, 110 ] 940 0.023% 99.950% ( 110, 170 ] 1135 0.028% 99.978% ( 170, 250 ] 579 0.014% 99.993% ( 250, 380 ] 369 0.009% 100.002% ( 380, 580 ] 375 0.009% 100.011% ( 580, 870 ] 331 0.008% 100.020% ( 870, 1300 ] 230 0.006% 100.025% ( 1300, 1900 ] 91 0.002% 100.028% ( 1900, 2900 ] 53 0.001% 100.029% ( 2900, 4400 ] 73 0.002% 100.031% ( 4400, 6600 ] 14 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 1123699 Average: 4.6827 StdDev: 76.99 Min: 0 Median: 1.7154 Max: 14296 Percentiles: P50: 1.72 P75: 2.58 P99: 9.76 P99.9: 138.99 P99.99: 422.13 ------------------------------------------------------ [ 0, 1 ] 118266 10.525% 10.525% ## ( 1, 2 ] 620087 55.183% 65.707% ########### ( 2, 3 ] 179254 15.952% 81.660% ### ( 3, 4 ] 84492 7.519% 89.179% ## ( 4, 6 ] 88324 7.860% 97.039% ## ( 6, 10 ] 23449 2.087% 99.125% ( 10, 15 ] 7014 0.624% 99.750% ( 15, 22 ] 863 0.077% 99.826% ( 22, 34 ] 73 0.006% 99.833% ( 34, 51 ] 21 0.002% 99.835% ( 51, 76 ] 60 0.005% 99.840% ( 76, 110 ] 436 0.039% 99.879% ( 110, 170 ] 489 0.044% 99.922% ( 170, 250 ] 334 0.030% 99.952% ( 250, 380 ] 349 0.031% 99.983% ( 380, 580 ] 359 0.032% 100.015% ( 580, 870 ] 303 0.027% 100.042% ( 870, 1300 ] 235 0.021% 100.063% ( 1300, 1900 ] 76 0.007% 100.070% ( 1900, 2900 ] 103 0.009% 100.079% ( 2900, 4400 ] 142 0.013% 100.092% ( 4400, 6600 ] 53 0.005% 100.096% ( 6600, 9900 ] 15 0.001% 100.098% ( 9900, 14000 ] 6 0.001% 100.098% ( 14000, 22000 ] 1 0.000% 100.098% ** Level 2 read latency histogram (micros): Count: 77249 Average: 2.5087 StdDev: 19.58 Min: 1 Median: 1.5092 Max: 4403 Percentiles: P50: 1.51 P75: 1.90 P99: 8.17 P99.9: 30.14 P99.99: 473.57 ------------------------------------------------------ [ 0, 1 ] 13434 17.391% 17.391% ### ( 1, 2 ] 49474 64.045% 81.435% ############# ( 2, 3 ] 6830 8.842% 90.277% ## ( 3, 4 ] 3880 5.023% 95.300% # ( 4, 6 ] 2342 3.032% 98.331% # ( 6, 10 ] 950 1.230% 99.561% ( 10, 15 ] 229 0.296% 99.858% ( 15, 22 ] 28 0.036% 99.894% ( 22, 34 ] 7 0.009% 99.903% ( 34, 51 ] 3 0.004% 99.907% ( 76, 110 ] 13 0.017% 99.924% ( 110, 170 ] 38 0.049% 99.973% ( 170, 250 ] 3 0.004% 99.977% ( 250, 380 ] 7 0.009% 99.986% ( 380, 580 ] 7 0.009% 99.995% ( 580, 870 ] 2 0.003% 99.997% ( 870, 1300 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ( 4400, 6600 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 1371582 Average: 5.1715 StdDev: 76.32 Min: 0 Median: 1.8755 Max: 15478 Percentiles: P50: 1.88 P75: 2.92 P99: 9.37 P99.9: 78.64 P99.99: 216.05 ------------------------------------------------------ [ 0, 1 ] 64927 4.734% 4.734% # ( 1, 2 ] 709162 51.704% 56.438% ########## ( 2, 3 ] 277587 20.238% 76.676% #### ( 3, 4 ] 140173 10.220% 86.896% ## ( 4, 6 ] 143552 10.466% 97.362% ## ( 6, 10 ] 26655 1.943% 99.305% ( 10, 15 ] 6969 0.508% 99.814% ( 15, 22 ] 863 0.063% 99.876% ( 22, 34 ] 164 0.012% 99.888% ( 34, 51 ] 68 0.005% 99.893% ( 51, 76 ] 68 0.005% 99.898% ( 76, 110 ] 302 0.022% 99.920% ( 110, 170 ] 687 0.050% 99.970% ( 170, 250 ] 467 0.034% 100.005% ( 250, 380 ] 539 0.039% 100.044% ( 380, 580 ] 557 0.041% 100.084% ( 580, 870 ] 513 0.037% 100.122% ( 870, 1300 ] 320 0.023% 100.145% ( 1300, 1900 ] 166 0.012% 100.157% ( 1900, 2900 ] 131 0.010% 100.167% ( 2900, 4400 ] 207 0.015% 100.182% ( 4400, 6600 ] 58 0.004% 100.186% ( 6600, 9900 ] 19 0.001% 100.188% ( 9900, 14000 ] 2 0.000% 100.188% ( 14000, 22000 ] 1 0.000% 100.188% ** Level 4 read latency histogram (micros): Count: 86154 Average: 54.0805 StdDev: 339.84 Min: 0 Median: 1.9717 Max: 10742 Percentiles: P50: 1.97 P75: 3.29 P99: 1420.49 P99.9: 4377.59 P99.99: 6193.85 ------------------------------------------------------ [ 0, 1 ] 3461 4.017% 4.017% # ( 1, 2 ] 40768 47.320% 51.337% ######### ( 2, 3 ] 17816 20.679% 72.016% #### ( 3, 4 ] 8992 10.437% 82.454% ## ( 4, 6 ] 7849 9.110% 91.564% ## ( 6, 10 ] 1722 1.999% 93.563% ( 10, 15 ] 808 0.938% 94.501% ( 15, 22 ] 85 0.099% 94.599% ( 22, 34 ] 18 0.021% 94.620% ( 34, 51 ] 6 0.007% 94.627% ( 51, 76 ] 10 0.012% 94.639% ( 76, 110 ] 244 0.283% 94.922% ( 110, 170 ] 458 0.532% 95.453% ( 170, 250 ] 476 0.552% 96.006% ( 250, 380 ] 533 0.619% 96.625% ( 380, 580 ] 695 0.807% 97.431% ( 580, 870 ] 733 0.851% 98.282% ( 870, 1300 ] 554 0.643% 98.925% ( 1300, 1900 ] 321 0.373% 99.298% ( 1900, 2900 ] 245 0.284% 99.582% ( 2900, 4400 ] 278 0.323% 99.905% ( 4400, 6600 ] 90 0.104% 100.009% ( 6600, 9900 ] 10 0.012% 100.021% ( 9900, 14000 ] 2 0.002% 100.023% ** Level 5 read latency histogram (micros): Count: 220 Average: 1220.3727 StdDev: 1296.46 Min: 98 Median: 681.8919 Max: 5520 Percentiles: P50: 681.89 P75: 1940.00 P99: 5520.00 P99.9: 5520.00 P99.99: 5520.00 ------------------------------------------------------ ( 76, 110 ] 5 2.273% 2.273% ( 110, 170 ] 28 12.727% 15.000% ### ( 170, 250 ] 19 8.636% 23.636% ## ( 250, 380 ] 24 10.909% 34.545% ## ( 380, 580 ] 21 9.545% 44.091% ## ( 580, 870 ] 37 16.818% 60.909% ### ( 870, 1300 ] 17 7.727% 68.636% ## ( 1300, 1900 ] 13 5.909% 74.545% # ( 1900, 2900 ] 25 11.364% 85.909% ## ( 2900, 4400 ] 23 10.455% 96.364% ## ( 4400, 6600 ] 8 3.636% 100.000% # ** DB Stats ** Uptime(secs): 49.5 total, 16.3 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 178.93 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:21.924 H:M:S, 44.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 60.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:12.568 H:M:S, 77.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/15-14:03:46 ... thread 0: (1000000,10000000) ops and (233495.2,186626.4) ops/second in (4.282744,53.582985) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 21/15 3.63 GB 119.6 9.8 0.0 9.8 19.4 9.6 0.0 2.0 142.6 282.3 70.22 64.76 176 0.399 10M 15K 0.0 0.0 L1 16/16 1.91 GB 0.0 6.6 5.8 0.8 6.5 5.7 0.2 1.1 212.7 209.7 31.87 30.32 3 10.622 6784K 34K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 3.8 1.5 228.8 228.7 0.84 0.80 2 0.422 196K 93 0.0 0.0 L3 24/0 961.58 MB 1.0 6.1 3.5 2.6 6.1 3.5 0.6 1.7 172.1 171.2 36.23 29.09 22 1.647 6332K 31K 0.0 0.0 L4 177/0 9.48 GB 1.0 3.3 3.0 0.3 3.3 3.0 0.9 1.1 126.1 125.7 26.90 16.68 46 0.585 3334K 2555 0.0 0.0 L5 1092/0 89.63 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1330/31 105.59 GB 0.0 26.0 12.4 13.6 35.4 21.8 9.4 3.7 160.2 218.5 166.06 141.65 249 0.667 26M 84K 0.0 0.0 Int 0/0 0.00 KB 0.0 26.0 12.4 13.6 35.4 21.8 9.3 3.7 160.2 218.5 166.06 141.65 249 0.667 26M 84K 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.0 12.4 13.6 25.8 12.2 0.0 0.0 196.0 194.9 135.77 115.76 105 1.293 26M 84K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.6 9.6 0.0 0.0 0.0 324.4 30.29 25.90 144 0.210 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 53.8 total, 53.6 interval Flush(GB): cumulative 9.597, interval 9.597 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: 35.44 GB write, 674.65 MB/s write, 25.99 GB read, 494.75 MB/s read, 166.1 seconds Interval compaction: 35.44 GB write, 677.19 MB/s write, 25.99 GB read, 496.62 MB/s read, 166.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 29, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 29, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 34, pending-compaction-bytes-delays: 26, pending-compaction-bytes-stops: 0, total-delays: 55, total-stops: 34, interval: 89 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4507764 Average: 2.5821 StdDev: 23.78 Min: 0 Median: 1.5057 Max: 6336 Percentiles: P50: 1.51 P75: 1.89 P99: 7.27 P99.9: 14.70 P99.99: 208.75 ------------------------------------------------------ [ 0, 1 ] 774431 17.180% 17.180% ### ( 1, 2 ] 2925511 64.899% 82.079% ############# ( 2, 3 ] 421454 9.350% 91.429% ## ( 3, 4 ] 193394 4.290% 95.719% # ( 4, 6 ] 132968 2.950% 98.669% # ( 6, 10 ] 46891 1.040% 99.709% ( 10, 15 ] 9169 0.203% 99.912% ( 15, 22 ] 951 0.021% 99.934% ( 22, 34 ] 102 0.002% 99.936% ( 34, 51 ] 42 0.001% 99.937% ( 51, 76 ] 37 0.001% 99.938% ( 76, 110 ] 943 0.021% 99.958% ( 110, 170 ] 1136 0.025% 99.984% ( 170, 250 ] 595 0.013% 99.997% ( 250, 380 ] 374 0.008% 100.005% ( 380, 580 ] 380 0.008% 100.014% ( 580, 870 ] 337 0.007% 100.021% ( 870, 1300 ] 236 0.005% 100.026% ( 1300, 1900 ] 93 0.002% 100.028% ( 1900, 2900 ] 54 0.001% 100.030% ( 2900, 4400 ] 75 0.002% 100.031% ( 4400, 6600 ] 14 0.000% 100.032% ** Level 1 read latency histogram (micros): Count: 1155696 Average: 4.6170 StdDev: 75.93 Min: 0 Median: 1.7062 Max: 14296 Percentiles: P50: 1.71 P75: 2.55 P99: 9.73 P99.9: 136.95 P99.99: 421.24 ------------------------------------------------------ [ 0, 1 ] 124781 10.797% 10.797% ## ( 1, 2 ] 641523 55.510% 66.307% ########### ( 2, 3 ] 181404 15.697% 82.003% ### ( 3, 4 ] 85315 7.382% 89.385% # ( 4, 6 ] 88748 7.679% 97.065% ## ( 6, 10 ] 23997 2.076% 99.141% ( 10, 15 ] 7047 0.610% 99.751% ( 15, 22 ] 867 0.075% 99.826% ( 22, 34 ] 74 0.006% 99.832% ( 34, 51 ] 22 0.002% 99.834% ( 51, 76 ] 60 0.005% 99.839% ( 76, 110 ] 476 0.041% 99.880% ( 110, 170 ] 506 0.044% 99.924% ( 170, 250 ] 338 0.029% 99.953% ( 250, 380 ] 349 0.030% 99.984% ( 380, 580 ] 361 0.031% 100.015% ( 580, 870 ] 303 0.026% 100.041% ( 870, 1300 ] 235 0.020% 100.061% ( 1300, 1900 ] 76 0.007% 100.068% ( 1900, 2900 ] 103 0.009% 100.077% ( 2900, 4400 ] 142 0.012% 100.089% ( 4400, 6600 ] 53 0.005% 100.094% ( 6600, 9900 ] 15 0.001% 100.095% ( 9900, 14000 ] 6 0.001% 100.096% ( 14000, 22000 ] 1 0.000% 100.096% ** Level 2 read latency histogram (micros): Count: 77249 Average: 2.5087 StdDev: 19.58 Min: 1 Median: 1.5092 Max: 4403 Percentiles: P50: 1.51 P75: 1.90 P99: 8.17 P99.9: 30.14 P99.99: 473.57 ------------------------------------------------------ [ 0, 1 ] 13434 17.391% 17.391% ### ( 1, 2 ] 49474 64.045% 81.435% ############# ( 2, 3 ] 6830 8.842% 90.277% ## ( 3, 4 ] 3880 5.023% 95.300% # ( 4, 6 ] 2342 3.032% 98.331% # ( 6, 10 ] 950 1.230% 99.561% ( 10, 15 ] 229 0.296% 99.858% ( 15, 22 ] 28 0.036% 99.894% ( 22, 34 ] 7 0.009% 99.903% ( 34, 51 ] 3 0.004% 99.907% ( 76, 110 ] 13 0.017% 99.924% ( 110, 170 ] 38 0.049% 99.973% ( 170, 250 ] 3 0.004% 99.977% ( 250, 380 ] 7 0.009% 99.986% ( 380, 580 ] 7 0.009% 99.995% ( 580, 870 ] 2 0.003% 99.997% ( 870, 1300 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ( 4400, 6600 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 1371735 Average: 5.1712 StdDev: 76.32 Min: 0 Median: 1.8754 Max: 15478 Percentiles: P50: 1.88 P75: 2.92 P99: 9.37 P99.9: 78.62 P99.99: 216.05 ------------------------------------------------------ [ 0, 1 ] 64944 4.734% 4.734% # ( 1, 2 ] 709280 51.707% 56.441% ########## ( 2, 3 ] 277596 20.237% 76.678% #### ( 3, 4 ] 140175 10.219% 86.897% ## ( 4, 6 ] 143555 10.465% 97.362% ## ( 6, 10 ] 26657 1.943% 99.305% ( 10, 15 ] 6970 0.508% 99.814% ( 15, 22 ] 863 0.063% 99.876% ( 22, 34 ] 164 0.012% 99.888% ( 34, 51 ] 68 0.005% 99.893% ( 51, 76 ] 68 0.005% 99.898% ( 76, 110 ] 302 0.022% 99.920% ( 110, 170 ] 687 0.050% 99.970% ( 170, 250 ] 467 0.034% 100.004% ( 250, 380 ] 539 0.039% 100.044% ( 380, 580 ] 557 0.041% 100.084% ( 580, 870 ] 513 0.037% 100.122% ( 870, 1300 ] 320 0.023% 100.145% ( 1300, 1900 ] 166 0.012% 100.157% ( 1900, 2900 ] 131 0.010% 100.167% ( 2900, 4400 ] 207 0.015% 100.182% ( 4400, 6600 ] 58 0.004% 100.186% ( 6600, 9900 ] 19 0.001% 100.187% ( 9900, 14000 ] 2 0.000% 100.188% ( 14000, 22000 ] 1 0.000% 100.188% ** Level 4 read latency histogram (micros): Count: 86229 Average: 54.0613 StdDev: 339.72 Min: 0 Median: 1.9717 Max: 10742 Percentiles: P50: 1.97 P75: 3.29 P99: 1419.08 P99.9: 4377.18 P99.99: 6193.66 ------------------------------------------------------ [ 0, 1 ] 3485 4.042% 4.042% # ( 1, 2 ] 40785 47.298% 51.340% ######### ( 2, 3 ] 17826 20.673% 72.013% #### ( 3, 4 ] 8992 10.428% 82.441% ## ( 4, 6 ] 7851 9.105% 91.546% ## ( 6, 10 ] 1738 2.016% 93.561% ( 10, 15 ] 809 0.938% 94.500% ( 15, 22 ] 86 0.100% 94.599% ( 22, 34 ] 19 0.022% 94.621% ( 34, 51 ] 6 0.007% 94.628% ( 51, 76 ] 10 0.012% 94.640% ( 76, 110 ] 244 0.283% 94.923% ( 110, 170 ] 458 0.531% 95.454% ( 170, 250 ] 476 0.552% 96.006% ( 250, 380 ] 533 0.618% 96.624% ( 380, 580 ] 697 0.808% 97.432% ( 580, 870 ] 733 0.850% 98.282% ( 870, 1300 ] 555 0.644% 98.926% ( 1300, 1900 ] 321 0.372% 99.298% ( 1900, 2900 ] 245 0.284% 99.583% ( 2900, 4400 ] 278 0.322% 99.905% ( 4400, 6600 ] 90 0.104% 100.009% ( 6600, 9900 ] 10 0.012% 100.021% ( 9900, 14000 ] 2 0.002% 100.023% ** Level 5 read latency histogram (micros): Count: 240 Average: 1179.9958 StdDev: 1274.47 Min: 82 Median: 648.6842 Max: 5520 Percentiles: P50: 648.68 P75: 1860.00 P99: 5520.00 P99.9: 5520.00 P99.99: 5520.00 ------------------------------------------------------ ( 76, 110 ] 7 2.917% 2.917% # ( 110, 170 ] 34 14.167% 17.083% ### ( 170, 250 ] 21 8.750% 25.833% ## ( 250, 380 ] 25 10.417% 36.250% ## ( 380, 580 ] 24 10.000% 46.250% ## ( 580, 870 ] 38 15.833% 62.083% ### ( 870, 1300 ] 17 7.083% 69.167% # ( 1300, 1900 ] 15 6.250% 75.417% # ( 1900, 2900 ] 28 11.667% 87.083% ## ( 2900, 4400 ] 23 9.583% 96.667% ## ( 4400, 6600 ] 8 3.333% 100.000% # ** DB Stats ** Uptime(secs): 53.8 total, 4.3 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 182.98 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:23.317 H:M:S, 43.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 229.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:1.392 H:M:S, 32.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 0 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.768 micros/op 173364 ops/sec 60.024 seconds 10405999 operations; 168.0 MB/s Microseconds per write: Count: 10405999 Average: 5.7682 StdDev: 249.34 Min: 1 Median: 1.8370 Max: 347033 Percentiles: P50: 1.84 P75: 3.14 P99: 9.56 P99.9: 1127.27 P99.99: 2666.98 ------------------------------------------------------ [ 0, 1 ] 1105711 10.626% 10.626% ## ( 1, 2 ] 4895422 47.044% 57.670% ######### ( 2, 3 ] 1596512 15.342% 73.012% ### ( 3, 4 ] 1435543 13.795% 86.808% ### ( 4, 6 ] 1118796 10.751% 97.559% ## ( 6, 10 ] 168359 1.618% 99.177% ( 10, 15 ] 39315 0.378% 99.555% ( 15, 22 ] 11896 0.114% 99.669% ( 22, 34 ] 2939 0.028% 99.697% ( 34, 51 ] 441 0.004% 99.701% ( 51, 76 ] 89 0.001% 99.702% ( 76, 110 ] 17 0.000% 99.702% ( 110, 170 ] 9679 0.093% 99.796% ( 170, 250 ] 653 0.006% 99.802% ( 250, 380 ] 210 0.002% 99.804% ( 380, 580 ] 55 0.001% 99.804% ( 580, 870 ] 36 0.000% 99.805% ( 870, 1300 ] 16580 0.159% 99.964% ( 1300, 1900 ] 90 0.001% 99.965% ( 1900, 2900 ] 3410 0.033% 99.998% ( 2900, 4400 ] 171 0.002% 99.999% ( 4400, 6600 ] 45 0.000% 100.000% ( 6600, 9900 ] 11 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 75000, 110000 ] 2 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 9 0.000% 100.000% ( 250000, 380000 ] 2 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 : 203094 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 : 10405999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10738990968 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 : 595 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 28423042 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 : 32782816691 rocksdb.compact.write.bytes COUNT : 32586479951 rocksdb.flush.write.bytes COUNT : 10701449043 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 : 57 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 : 245 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 : 10614975488 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3971072 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 : 32881070111 rocksdb.non.last.level.read.count COUNT : 7946956 rocksdb.block.checksum.compute.count COUNT : 7945823 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.489537 P95 : 4.947690 P99 : 8.618780 P100 : 347026.000000 COUNT : 10405999 SUM : 54858964 rocksdb.compaction.times.micros P50 : 956333.333333 P95 : 3127500.000000 P99 : 13706000.000000 P100 : 18029814.000000 COUNT : 107 SUM : 137749937 rocksdb.compaction.times.cpu_micros P50 : 889750.000000 P95 : 3127500.000000 P99 : 13706000.000000 P100 : 16977459.000000 COUNT : 107 SUM : 117706461 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 : 689.176471 P95 : 1236.764706 P99 : 3650.000000 P100 : 10169.000000 COUNT : 150 SUM : 117591 rocksdb.compaction.outfile.sync.micros P50 : 1063.677686 P95 : 24429.166667 P99 : 54650.000000 P100 : 66131.000000 COUNT : 407 SUM : 1815190 rocksdb.wal.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.manifest.file.sync.micros P50 : 103.670213 P95 : 943.100000 P99 : 3338.750000 P100 : 3991.000000 COUNT : 283 SUM : 72268 rocksdb.table.open.io.micros P50 : 1240.592105 P95 : 7689.000000 P99 : 12308.750000 P100 : 14108.000000 COUNT : 595 SUM : 1184280 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.685029 P95 : 8.130800 P99 : 12.550351 P100 : 15485.000000 COUNT : 7944376 SUM : 48203023 rocksdb.read.block.get.micros P50 : 368.654545 P95 : 3360.526316 P99 : 5390.000000 P100 : 8358.000000 COUNT : 1190 SUM : 963649 rocksdb.write.raw.block.micros P50 : 0.518458 P95 : 0.985070 P99 : 3.600835 P100 : 21835.000000 COUNT : 10486542 SUM : 21965075 rocksdb.numfiles.in.singlecompaction P50 : 3.024590 P95 : 5.580000 P99 : 20.565000 P100 : 27.000000 COUNT : 141 SUM : 510 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.559397 P95 : 1145.815027 P99 : 2385.920897 P100 : 346742.000000 COUNT : 191570 SUM : 28440148 rocksdb.sst.read.micros P50 : 1.586864 P95 : 4.758363 P99 : 8.788926 P100 : 15478.000000 COUNT : 7947502 SUM : 31127986 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 : 10405999 SUM : 10738990968 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 : 214666.666667 P95 : 367812.500000 P99 : 551000.000000 P100 : 576688.000000 COUNT : 150 SUM : 31357321 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 : 380 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