[2024-11-27 15:28:03.667936] Starting SPDK v25.01-pre git sha1 35cd3e84d / DPDK 22.11.4 initialization... [2024-11-27 15:28:03.668204] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=lib.power:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid3127058 ] Set seed to 1732717683661316 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-27 15:28:03.771824] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-27 15:28:03.795192] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-27 15:28:03.795236] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 3127058' to capture a snapshot of events at runtime. [2024-11-27 15:28:03.795247] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-27 15:28:03.795258] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-27 15:28:03.795265] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid3127058 for offline analysis/debug. [2024-11-27 15:28:03.795829] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Wed Nov 27 15:28:08 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/27-15:28:11 ... thread 0: (1000000,1000000) ops and (331407.0,331407.0) ops/second in (3.017438,3.017438) 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 440.96 MB 18.9 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 348.5 2.53 2.30 12 0.211 0 0 0.0 0.0 L1 3/0 249.20 MB 24.9 0.2 0.2 0.0 0.2 0.2 0.2 1.0 252.3 252.0 1.00 0.96 1 0.999 255K 250 0.0 0.0 L2 3/2 191.42 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.1 1.5 254.0 253.9 0.76 0.72 2 0.381 196K 73 0.0 0.0 L3 12/0 993.23 MB 1.0 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 1040/0 85.63 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 1180/6 97.00 GB 0.0 0.4 0.4 0.1 1.3 1.2 0.4 1.5 103.8 309.2 4.29 3.99 15 0.286 452K 323 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.4 0.1 1.3 1.2 0.4 1.5 103.8 309.2 4.29 3.99 15 0.286 452K 323 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 253.0 252.8 1.76 1.69 3 0.587 452K 323 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 348.5 2.53 2.30 12 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): 3.2 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 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.30 GB write, 414.70 MB/s write, 0.43 GB read, 139.20 MB/s read, 4.3 seconds Interval compaction: 1.30 GB write, 439.60 MB/s write, 0.43 GB read, 147.56 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: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 157222 Average: 1.9104 StdDev: 9.44 Min: 0 Median: 1.2912 Max: 3166 Percentiles: P50: 1.29 P75: 1.72 P99: 5.26 P99.9: 10.99 P99.99: 20.06 ------------------------------------------------------ [ 0, 1 ] 52210 33.208% 33.208% ####### ( 1, 2 ] 90659 57.663% 90.871% ############ ( 2, 3 ] 8044 5.116% 95.987% # ( 3, 4 ] 3423 2.177% 98.164% ( 4, 6 ] 2090 1.329% 99.494% ( 6, 10 ] 607 0.386% 99.880% ( 10, 15 ] 161 0.102% 99.982% ( 15, 22 ] 17 0.011% 99.993% ( 22, 34 ] 1 0.001% 99.994% ( 34, 51 ] 2 0.001% 99.995% ( 51, 76 ] 2 0.001% 99.996% ( 110, 170 ] 7 0.004% 100.001% ( 170, 250 ] 3 0.002% 100.003% ( 250, 380 ] 8 0.005% 100.008% ( 380, 580 ] 1 0.001% 100.008% ( 580, 870 ] 3 0.002% 100.010% ( 870, 1300 ] 1 0.001% 100.011% ( 2900, 4400 ] 1 0.001% 100.011% ** Level 1 read latency histogram (micros): Count: 664 Average: 6.8855 StdDev: 63.06 Min: 1 Median: 1.5393 Max: 1371 Percentiles: P50: 1.54 P75: 1.90 P99: 11.80 P99.9: 1371.00 P99.99: 1371.00 ------------------------------------------------------ [ 0, 1 ] 85 12.801% 12.801% ### ( 1, 2 ] 458 68.976% 81.777% ############## ( 2, 3 ] 51 7.681% 89.458% ## ( 3, 4 ] 38 5.723% 95.181% # ( 4, 6 ] 18 2.711% 97.892% # ( 6, 10 ] 7 1.054% 98.946% ( 10, 15 ] 1 0.151% 99.096% ( 110, 170 ] 1 0.151% 99.247% ( 170, 250 ] 1 0.151% 99.398% ( 250, 380 ] 2 0.301% 99.699% ( 580, 870 ] 1 0.151% 99.849% ( 1300, 1900 ] 1 0.151% 100.000% ** Level 2 read latency histogram (micros): Count: 43205 Average: 2.4511 StdDev: 20.93 Min: 1 Median: 1.5429 Max: 3382 Percentiles: P50: 1.54 P75: 1.91 P99: 6.31 P99.9: 12.48 P99.99: 742.35 ------------------------------------------------------ [ 0, 1 ] 5713 13.223% 13.223% ### ( 1, 2 ] 29267 67.740% 80.963% ############## ( 2, 3 ] 4736 10.962% 91.925% ## ( 3, 4 ] 1679 3.886% 95.811% # ( 4, 6 ] 1347 3.118% 98.928% # ( 6, 10 ] 395 0.914% 99.843% ( 10, 15 ] 50 0.116% 99.958% ( 15, 22 ] 6 0.014% 99.972% ( 22, 34 ] 2 0.005% 99.977% ( 51, 76 ] 1 0.002% 99.979% ( 170, 250 ] 1 0.002% 99.981% ( 250, 380 ] 1 0.002% 99.984% ( 380, 580 ] 1 0.002% 99.986% ( 580, 870 ] 3 0.007% 99.993% ( 870, 1300 ] 1 0.002% 99.995% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 55 Average: 1792.1636 StdDev: 1387.56 Min: 51 Median: 1412.5000 Max: 6502 Percentiles: P50: 1412.50 P75: 2928.85 P99: 5390.00 P99.9: 6479.00 P99.99: 6502.00 ------------------------------------------------------ ( 34, 51 ] 1 1.818% 1.818% ( 76, 110 ] 1 1.818% 3.636% ( 110, 170 ] 1 1.818% 5.455% ( 170, 250 ] 3 5.455% 10.909% # ( 250, 380 ] 2 3.636% 14.545% # ( 380, 580 ] 3 5.455% 20.000% # ( 580, 870 ] 8 14.545% 34.545% ### ( 870, 1300 ] 7 12.727% 47.273% ### ( 1300, 1900 ] 8 14.545% 61.818% ### ( 1900, 2900 ] 7 12.727% 74.545% ### ( 2900, 4400 ] 13 23.636% 98.182% ##### ( 4400, 6600 ] 1 1.818% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 1766.8500 StdDev: 1391.57 Min: 242 Median: 1300.0000 Max: 4854 Percentiles: P50: 1300.00 P75: 2566.67 P99: 4854.00 P99.9: 4854.00 P99.99: 4854.00 ------------------------------------------------------ ( 170, 250 ] 1 5.000% 5.000% # ( 250, 380 ] 1 5.000% 10.000% # ( 380, 580 ] 2 10.000% 20.000% ## ( 580, 870 ] 2 10.000% 30.000% ## ( 870, 1300 ] 4 20.000% 50.000% #### ( 1300, 1900 ] 1 5.000% 55.000% # ( 1900, 2900 ] 6 30.000% 85.000% ###### ( 2900, 4400 ] 1 5.000% 90.000% # ( 4400, 6600 ] 2 10.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, 307.54 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.412 H:M:S, 12.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 325.91 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.412 H:M:S, 13.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/27-15:28:13 ... thread 0: (1000000,2000000) ops and (349094.0,340020.6) ops/second in (2.864558,5.881996) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/10 1.35 GB 6.3 0.8 0.0 0.8 2.6 1.8 0.0 1.4 97.6 315.3 8.39 7.78 29 0.289 831K 838 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 252.3 252.0 1.00 0.96 1 0.999 255K 250 0.0 0.0 L2 2/1 81.87 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.3 1.5 254.0 253.9 0.76 0.72 2 0.381 196K 73 0.0 0.0 L3 17/8 868.85 MB 0.2 0.2 0.2 0.0 0.2 0.2 0.3 1.0 224.5 224.5 0.83 0.77 1 0.833 189K 0 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 129.2 129.3 1.30 0.88 1 1.301 170K 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1247/19 97.92 GB 0.0 1.6 0.7 0.9 3.4 2.5 1.4 1.9 131.9 280.5 12.28 11.11 34 0.361 1644K 1161 0.0 0.0 Int 0/0 0.00 KB 0.0 1.6 0.7 0.9 3.4 2.5 1.4 1.9 131.9 280.5 12.28 11.11 34 0.361 1644K 1161 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.6 0.7 0.9 1.6 0.7 0.0 0.0 230.5 230.3 7.03 6.40 8 0.878 1644K 1161 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 347.5 5.26 4.71 26 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 total, 5.9 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.36 GB write, 568.10 MB/s write, 1.58 GB read, 267.05 MB/s read, 12.3 seconds Interval compaction: 3.36 GB write, 585.59 MB/s write, 1.58 GB read, 275.27 MB/s read, 12.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: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 384005 Average: 2.1658 StdDev: 11.24 Min: 0 Median: 1.4595 Max: 3425 Percentiles: P50: 1.46 P75: 1.86 P99: 5.72 P99.9: 11.47 P99.99: 16.18 ------------------------------------------------------ [ 0, 1 ] 82626 21.517% 21.517% #### ( 1, 2 ] 238037 61.988% 83.505% ############ ( 2, 3 ] 37630 9.799% 93.304% ## ( 3, 4 ] 13590 3.539% 96.843% # ( 4, 6 ] 9633 2.509% 99.352% # ( 6, 10 ] 1965 0.512% 99.864% ( 10, 15 ] 480 0.125% 99.989% ( 15, 22 ] 39 0.010% 99.999% ( 22, 34 ] 7 0.002% 100.001% ( 34, 51 ] 3 0.001% 100.001% ( 51, 76 ] 2 0.001% 100.002% ( 110, 170 ] 12 0.003% 100.005% ( 170, 250 ] 11 0.003% 100.008% ( 250, 380 ] 10 0.003% 100.010% ( 380, 580 ] 7 0.002% 100.012% ( 580, 870 ] 10 0.003% 100.015% ( 870, 1300 ] 3 0.001% 100.016% ( 1900, 2900 ] 3 0.001% 100.016% ( 2900, 4400 ] 2 0.001% 100.017% ** Level 1 read latency histogram (micros): Count: 664 Average: 6.8855 StdDev: 63.06 Min: 1 Median: 1.5393 Max: 1371 Percentiles: P50: 1.54 P75: 1.90 P99: 11.80 P99.9: 1371.00 P99.99: 1371.00 ------------------------------------------------------ [ 0, 1 ] 85 12.801% 12.801% ### ( 1, 2 ] 458 68.976% 81.777% ############## ( 2, 3 ] 51 7.681% 89.458% ## ( 3, 4 ] 38 5.723% 95.181% # ( 4, 6 ] 18 2.711% 97.892% # ( 6, 10 ] 7 1.054% 98.946% ( 10, 15 ] 1 0.151% 99.096% ( 110, 170 ] 1 0.151% 99.247% ( 170, 250 ] 1 0.151% 99.398% ( 250, 380 ] 2 0.301% 99.699% ( 580, 870 ] 1 0.151% 99.849% ( 1300, 1900 ] 1 0.151% 100.000% ** Level 2 read latency histogram (micros): Count: 51865 Average: 2.7485 StdDev: 21.52 Min: 1 Median: 1.5677 Max: 3382 Percentiles: P50: 1.57 P75: 1.94 P99: 6.99 P99.9: 152.27 P99.99: 764.32 ------------------------------------------------------ [ 0, 1 ] 6281 12.110% 12.110% ## ( 1, 2 ] 34616 66.743% 78.853% ############# ( 2, 3 ] 6618 12.760% 91.613% ### ( 3, 4 ] 2047 3.947% 95.560% # ( 4, 6 ] 1661 3.203% 98.762% # ( 6, 10 ] 497 0.958% 99.720% ( 10, 15 ] 61 0.118% 99.838% ( 15, 22 ] 8 0.015% 99.853% ( 22, 34 ] 2 0.004% 99.857% ( 51, 76 ] 1 0.002% 99.859% ( 110, 170 ] 30 0.058% 99.917% ( 170, 250 ] 13 0.025% 99.942% ( 250, 380 ] 11 0.021% 99.963% ( 380, 580 ] 10 0.019% 99.983% ( 580, 870 ] 6 0.012% 99.994% ( 870, 1300 ] 1 0.002% 99.996% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 186660 Average: 3.6377 StdDev: 42.84 Min: 1 Median: 1.7031 Max: 6502 Percentiles: P50: 1.70 P75: 2.35 P99: 8.94 P99.9: 190.09 P99.99: 641.87 ------------------------------------------------------ [ 0, 1 ] 14552 7.796% 7.796% ## ( 1, 2 ] 112045 60.026% 67.822% ############ ( 2, 3 ] 38435 20.591% 88.413% #### ( 3, 4 ] 8895 4.765% 93.179% # ( 4, 6 ] 8523 4.566% 97.745% # ( 6, 10 ] 3186 1.707% 99.451% ( 10, 15 ] 386 0.207% 99.658% ( 15, 22 ] 82 0.044% 99.702% ( 22, 34 ] 32 0.017% 99.719% ( 34, 51 ] 8 0.004% 99.724% ( 51, 76 ] 23 0.012% 99.736% ( 76, 110 ] 131 0.070% 99.806% ( 110, 170 ] 156 0.084% 99.890% ( 170, 250 ] 77 0.041% 99.931% ( 250, 380 ] 59 0.032% 99.962% ( 380, 580 ] 46 0.025% 99.987% ( 580, 870 ] 25 0.013% 100.001% ( 870, 1300 ] 13 0.007% 100.008% ( 1300, 1900 ] 8 0.004% 100.012% ( 1900, 2900 ] 9 0.005% 100.017% ( 2900, 4400 ] 14 0.008% 100.024% ( 4400, 6600 ] 1 0.001% 100.025% ** Level 4 read latency histogram (micros): Count: 305 Average: 119.4066 StdDev: 563.53 Min: 1 Median: 1.6500 Max: 4854 Percentiles: P50: 1.65 P75: 4.59 P99: 2891.67 P99.9: 4854.00 P99.99: 4854.00 ------------------------------------------------------ [ 0, 1 ] 68 22.295% 22.295% #### ( 1, 2 ] 130 42.623% 64.918% ######### ( 2, 3 ] 24 7.869% 72.787% ## ( 3, 4 ] 2 0.656% 73.443% ( 4, 6 ] 16 5.246% 78.689% # ( 6, 10 ] 39 12.787% 91.475% ### ( 10, 15 ] 4 1.311% 92.787% ( 15, 22 ] 1 0.328% 93.115% ( 170, 250 ] 2 0.656% 93.770% ( 250, 380 ] 1 0.328% 94.098% ( 380, 580 ] 2 0.656% 94.754% ( 580, 870 ] 2 0.656% 95.410% ( 870, 1300 ] 4 1.311% 96.721% ( 1300, 1900 ] 1 0.328% 97.049% ( 1900, 2900 ] 6 1.967% 99.016% ( 2900, 4400 ] 1 0.328% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 876.3500 StdDev: 901.03 Min: 107 Median: 513.3333 Max: 2972 Percentiles: P50: 513.33 P75: 870.00 P99: 2972.00 P99.9: 2972.00 P99.99: 2972.00 ------------------------------------------------------ ( 76, 110 ] 1 5.000% 5.000% # ( 110, 170 ] 2 10.000% 15.000% ## ( 170, 250 ] 5 25.000% 40.000% ##### ( 380, 580 ] 3 15.000% 55.000% ### ( 580, 870 ] 4 20.000% 75.000% #### ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 6.1 total, 2.9 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 324.56 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.619 H:M:S, 10.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 343.58 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.207 H:M:S, 7.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/27-15:28:16 ... thread 0: (1000000,3000000) ops and (328509.3,336094.9) ops/second in (3.044054,8.926050) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/10 2.27 GB 94.4 1.6 0.0 1.6 4.4 2.8 0.0 1.6 114.0 311.3 14.36 13.38 46 0.312 1663K 1706 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 252.3 252.0 1.00 0.96 1 0.999 255K 250 0.0 0.0 L2 1/0 77.40 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.3 1.5 254.0 253.9 0.76 0.72 2 0.381 196K 73 0.0 0.0 L3 15/0 870.29 MB 0.9 0.8 0.2 0.7 0.8 0.2 0.3 4.5 225.9 225.2 3.85 3.57 2 1.925 883K 3069 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 129.2 129.3 1.30 0.88 1 1.301 170K 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1248/10 98.84 GB 0.0 3.0 0.7 2.3 5.8 3.5 1.4 2.1 146.7 279.7 21.27 19.51 52 0.409 3169K 5098 0.0 0.0 Int 0/0 0.00 KB 0.0 3.0 0.7 2.3 5.8 3.5 1.4 2.1 146.7 279.7 21.27 19.51 52 0.409 3169K 5098 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.0 0.7 2.3 3.0 0.7 0.0 0.0 236.9 236.5 13.17 12.26 12 1.098 3169K 5098 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 350.0 8.10 7.26 40 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.1 total, 8.9 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: 5.81 GB write, 653.30 MB/s write, 3.05 GB read, 342.65 MB/s read, 21.3 seconds Interval compaction: 5.81 GB write, 666.56 MB/s write, 3.05 GB read, 349.61 MB/s read, 21.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: 10, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 10, interval: 10 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 800613 Average: 2.1931 StdDev: 8.64 Min: 0 Median: 1.5066 Max: 3425 Percentiles: P50: 1.51 P75: 1.89 P99: 5.65 P99.9: 10.11 P99.99: 14.35 ------------------------------------------------------ [ 0, 1 ] 138140 17.254% 17.254% ### ( 1, 2 ] 517465 64.634% 81.888% ############# ( 2, 3 ] 91471 11.425% 93.313% ## ( 3, 4 ] 28616 3.574% 96.887% # ( 4, 6 ] 20555 2.567% 99.455% # ( 6, 10 ] 3547 0.443% 99.898% ( 10, 15 ] 851 0.106% 100.004% ( 15, 22 ] 63 0.008% 100.012% ( 22, 34 ] 11 0.001% 100.013% ( 34, 51 ] 7 0.001% 100.014% ( 51, 76 ] 5 0.001% 100.015% ( 110, 170 ] 16 0.002% 100.017% ( 170, 250 ] 20 0.002% 100.019% ( 250, 380 ] 20 0.002% 100.022% ( 380, 580 ] 12 0.001% 100.023% ( 580, 870 ] 14 0.002% 100.025% ( 870, 1300 ] 5 0.001% 100.026% ( 1900, 2900 ] 4 0.000% 100.026% ( 2900, 4400 ] 2 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 664 Average: 6.8855 StdDev: 63.06 Min: 1 Median: 1.5393 Max: 1371 Percentiles: P50: 1.54 P75: 1.90 P99: 11.80 P99.9: 1371.00 P99.99: 1371.00 ------------------------------------------------------ [ 0, 1 ] 85 12.801% 12.801% ### ( 1, 2 ] 458 68.976% 81.777% ############## ( 2, 3 ] 51 7.681% 89.458% ## ( 3, 4 ] 38 5.723% 95.181% # ( 4, 6 ] 18 2.711% 97.892% # ( 6, 10 ] 7 1.054% 98.946% ( 10, 15 ] 1 0.151% 99.096% ( 110, 170 ] 1 0.151% 99.247% ( 170, 250 ] 1 0.151% 99.398% ( 250, 380 ] 2 0.301% 99.699% ( 580, 870 ] 1 0.151% 99.849% ( 1300, 1900 ] 1 0.151% 100.000% ** Level 2 read latency histogram (micros): Count: 77383 Average: 2.6776 StdDev: 17.65 Min: 1 Median: 1.6108 Max: 3382 Percentiles: P50: 1.61 P75: 1.99 P99: 7.63 P99.9: 24.47 P99.99: 640.98 ------------------------------------------------------ [ 0, 1 ] 7521 9.719% 9.719% ## ( 1, 2 ] 51032 65.947% 75.666% ############# ( 2, 3 ] 11428 14.768% 90.435% ### ( 3, 4 ] 3315 4.284% 94.718% # ( 4, 6 ] 2910 3.761% 98.479% # ( 6, 10 ] 992 1.282% 99.761% ( 10, 15 ] 97 0.125% 99.886% ( 15, 22 ] 10 0.013% 99.899% ( 22, 34 ] 3 0.004% 99.903% ( 51, 76 ] 1 0.001% 99.904% ( 110, 170 ] 30 0.039% 99.943% ( 170, 250 ] 14 0.018% 99.961% ( 250, 380 ] 11 0.014% 99.975% ( 380, 580 ] 10 0.013% 99.988% ( 580, 870 ] 6 0.008% 99.996% ( 870, 1300 ] 1 0.001% 99.997% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 186690 Average: 3.6838 StdDev: 43.43 Min: 1 Median: 1.7031 Max: 6502 Percentiles: P50: 1.70 P75: 2.35 P99: 8.96 P99.9: 201.09 P99.99: 695.23 ------------------------------------------------------ [ 0, 1 ] 14561 7.800% 7.800% ## ( 1, 2 ] 112050 60.019% 67.819% ############ ( 2, 3 ] 38439 20.590% 88.409% #### ( 3, 4 ] 8895 4.765% 93.173% # ( 4, 6 ] 8523 4.565% 97.738% # ( 6, 10 ] 3186 1.707% 99.445% ( 10, 15 ] 386 0.207% 99.652% ( 15, 22 ] 82 0.044% 99.696% ( 22, 34 ] 32 0.017% 99.713% ( 34, 51 ] 8 0.004% 99.717% ( 51, 76 ] 23 0.012% 99.729% ( 76, 110 ] 131 0.070% 99.800% ( 110, 170 ] 157 0.084% 99.884% ( 170, 250 ] 78 0.042% 99.926% ( 250, 380 ] 60 0.032% 99.958% ( 380, 580 ] 50 0.027% 99.984% ( 580, 870 ] 26 0.014% 99.998% ( 870, 1300 ] 14 0.007% 100.006% ( 1300, 1900 ] 11 0.006% 100.012% ( 1900, 2900 ] 9 0.005% 100.017% ( 2900, 4400 ] 14 0.007% 100.024% ( 4400, 6600 ] 1 0.001% 100.025% ** Level 4 read latency histogram (micros): Count: 305 Average: 119.4066 StdDev: 563.53 Min: 1 Median: 1.6500 Max: 4854 Percentiles: P50: 1.65 P75: 4.59 P99: 2891.67 P99.9: 4854.00 P99.99: 4854.00 ------------------------------------------------------ [ 0, 1 ] 68 22.295% 22.295% #### ( 1, 2 ] 130 42.623% 64.918% ######### ( 2, 3 ] 24 7.869% 72.787% ## ( 3, 4 ] 2 0.656% 73.443% ( 4, 6 ] 16 5.246% 78.689% # ( 6, 10 ] 39 12.787% 91.475% ### ( 10, 15 ] 4 1.311% 92.787% ( 15, 22 ] 1 0.328% 93.115% ( 170, 250 ] 2 0.656% 93.770% ( 250, 380 ] 1 0.328% 94.098% ( 380, 580 ] 2 0.656% 94.754% ( 580, 870 ] 2 0.656% 95.410% ( 870, 1300 ] 4 1.311% 96.721% ( 1300, 1900 ] 1 0.328% 97.049% ( 1900, 2900 ] 6 1.967% 99.016% ( 2900, 4400 ] 1 0.328% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 876.3500 StdDev: 901.03 Min: 107 Median: 513.3333 Max: 2972 Percentiles: P50: 513.33 P75: 870.00 P99: 2972.00 P99.9: 2972.00 P99.99: 2972.00 ------------------------------------------------------ ( 76, 110 ] 1 5.000% 5.000% # ( 110, 170 ] 2 10.000% 15.000% ## ( 170, 250 ] 5 25.000% 40.000% ##### ( 380, 580 ] 3 15.000% 55.000% ### ( 580, 870 ] 4 20.000% 75.000% #### ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 9.1 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 324.13 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.004 H:M:S, 11.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 323.27 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.385 H:M:S, 12.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/27-15:28:19 ... thread 0: (1000000,4000000) ops and (330040.7,334560.6) ops/second in (3.029929,11.955979) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/9 2.21 GB 56.7 2.4 0.0 2.4 6.1 3.7 0.0 1.6 122.3 310.4 20.08 18.74 62 0.324 2494K 2626 0.0 0.0 L1 10/10 1.04 GB 0.0 1.3 1.3 0.0 1.3 1.3 0.2 1.0 236.1 235.2 5.60 5.42 2 2.799 1342K 4925 0.0 0.0 L2 1/0 77.40 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.3 1.5 254.0 253.9 0.76 0.72 2 0.381 196K 73 0.0 0.0 L3 15/0 870.29 MB 0.9 0.8 0.2 0.7 0.8 0.2 0.3 4.5 225.9 225.2 3.85 3.57 2 1.925 883K 3069 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 129.2 129.3 1.30 0.88 1 1.301 170K 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1257/19 99.82 GB 0.0 4.9 1.8 3.1 8.6 5.4 1.4 2.3 158.6 277.9 31.59 29.34 69 0.458 5087K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.9 1.8 3.1 8.6 5.4 1.4 2.3 158.6 277.9 31.59 29.34 69 0.458 5087K 10K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.9 1.8 3.1 4.9 1.8 0.0 0.0 240.6 240.0 20.83 19.72 16 1.302 5087K 10K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 351.0 10.77 9.61 53 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.1 total, 12.0 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.57 GB write, 723.24 MB/s write, 4.89 GB read, 412.76 MB/s read, 31.6 seconds Interval compaction: 8.57 GB write, 734.20 MB/s write, 4.89 GB read, 419.01 MB/s read, 31.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 13, interval: 13 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1072912 Average: 2.2087 StdDev: 9.90 Min: 0 Median: 1.4998 Max: 3618 Percentiles: P50: 1.50 P75: 1.89 P99: 5.63 P99.9: 10.56 P99.99: 14.77 ------------------------------------------------------ [ 0, 1 ] 189490 17.661% 17.661% #### ( 1, 2 ] 694159 64.699% 82.360% ############# ( 2, 3 ] 120019 11.186% 93.546% ## ( 3, 4 ] 37192 3.466% 97.013% # ( 4, 6 ] 26129 2.435% 99.448% ( 6, 10 ] 4722 0.440% 99.888% ( 10, 15 ] 1146 0.107% 99.995% ( 15, 22 ] 80 0.007% 100.002% ( 22, 34 ] 14 0.001% 100.004% ( 34, 51 ] 9 0.001% 100.004% ( 51, 76 ] 5 0.000% 100.005% ( 76, 110 ] 11 0.001% 100.006% ( 110, 170 ] 86 0.008% 100.014% ( 170, 250 ] 41 0.004% 100.018% ( 250, 380 ] 34 0.003% 100.021% ( 380, 580 ] 24 0.002% 100.023% ( 580, 870 ] 21 0.002% 100.025% ( 870, 1300 ] 10 0.001% 100.026% ( 1300, 1900 ] 4 0.000% 100.026% ( 1900, 2900 ] 6 0.001% 100.027% ( 2900, 4400 ] 3 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 42315 Average: 2.8776 StdDev: 27.99 Min: 1 Median: 1.4092 Max: 3215 Percentiles: P50: 1.41 P75: 1.80 P99: 6.86 P99.9: 243.81 P99.99: 1453.70 ------------------------------------------------------ [ 0, 1 ] 10119 23.914% 23.914% ##### ( 1, 2 ] 26975 63.748% 87.662% ############# ( 2, 3 ] 3301 7.801% 95.463% ## ( 3, 4 ] 854 2.018% 97.481% ( 4, 6 ] 569 1.345% 98.825% ( 6, 10 ] 342 0.808% 99.634% ( 10, 15 ] 30 0.071% 99.705% ( 15, 22 ] 4 0.009% 99.714% ( 51, 76 ] 2 0.005% 99.719% ( 76, 110 ] 24 0.057% 99.775% ( 110, 170 ] 37 0.087% 99.863% ( 170, 250 ] 17 0.040% 99.903% ( 250, 380 ] 16 0.038% 99.941% ( 380, 580 ] 9 0.021% 99.962% ( 580, 870 ] 7 0.017% 99.979% ( 870, 1300 ] 4 0.009% 99.988% ( 1300, 1900 ] 3 0.007% 99.995% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 77383 Average: 2.6776 StdDev: 17.65 Min: 1 Median: 1.6108 Max: 3382 Percentiles: P50: 1.61 P75: 1.99 P99: 7.63 P99.9: 24.47 P99.99: 640.98 ------------------------------------------------------ [ 0, 1 ] 7521 9.719% 9.719% ## ( 1, 2 ] 51032 65.947% 75.666% ############# ( 2, 3 ] 11428 14.768% 90.435% ### ( 3, 4 ] 3315 4.284% 94.718% # ( 4, 6 ] 2910 3.761% 98.479% # ( 6, 10 ] 992 1.282% 99.761% ( 10, 15 ] 97 0.125% 99.886% ( 15, 22 ] 10 0.013% 99.899% ( 22, 34 ] 3 0.004% 99.903% ( 51, 76 ] 1 0.001% 99.904% ( 110, 170 ] 30 0.039% 99.943% ( 170, 250 ] 14 0.018% 99.961% ( 250, 380 ] 11 0.014% 99.975% ( 380, 580 ] 10 0.013% 99.988% ( 580, 870 ] 6 0.008% 99.996% ( 870, 1300 ] 1 0.001% 99.997% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 186690 Average: 3.6838 StdDev: 43.43 Min: 1 Median: 1.7031 Max: 6502 Percentiles: P50: 1.70 P75: 2.35 P99: 8.96 P99.9: 201.09 P99.99: 695.23 ------------------------------------------------------ [ 0, 1 ] 14561 7.800% 7.800% ## ( 1, 2 ] 112050 60.019% 67.819% ############ ( 2, 3 ] 38439 20.590% 88.409% #### ( 3, 4 ] 8895 4.765% 93.173% # ( 4, 6 ] 8523 4.565% 97.738% # ( 6, 10 ] 3186 1.707% 99.445% ( 10, 15 ] 386 0.207% 99.652% ( 15, 22 ] 82 0.044% 99.696% ( 22, 34 ] 32 0.017% 99.713% ( 34, 51 ] 8 0.004% 99.717% ( 51, 76 ] 23 0.012% 99.729% ( 76, 110 ] 131 0.070% 99.800% ( 110, 170 ] 157 0.084% 99.884% ( 170, 250 ] 78 0.042% 99.926% ( 250, 380 ] 60 0.032% 99.958% ( 380, 580 ] 50 0.027% 99.984% ( 580, 870 ] 26 0.014% 99.998% ( 870, 1300 ] 14 0.007% 100.006% ( 1300, 1900 ] 11 0.006% 100.012% ( 1900, 2900 ] 9 0.005% 100.017% ( 2900, 4400 ] 14 0.007% 100.024% ( 4400, 6600 ] 1 0.001% 100.025% ** Level 4 read latency histogram (micros): Count: 305 Average: 119.4066 StdDev: 563.53 Min: 1 Median: 1.6500 Max: 4854 Percentiles: P50: 1.65 P75: 4.59 P99: 2891.67 P99.9: 4854.00 P99.99: 4854.00 ------------------------------------------------------ [ 0, 1 ] 68 22.295% 22.295% #### ( 1, 2 ] 130 42.623% 64.918% ######### ( 2, 3 ] 24 7.869% 72.787% ## ( 3, 4 ] 2 0.656% 73.443% ( 4, 6 ] 16 5.246% 78.689% # ( 6, 10 ] 39 12.787% 91.475% ### ( 10, 15 ] 4 1.311% 92.787% ( 15, 22 ] 1 0.328% 93.115% ( 170, 250 ] 2 0.656% 93.770% ( 250, 380 ] 1 0.328% 94.098% ( 380, 580 ] 2 0.656% 94.754% ( 580, 870 ] 2 0.656% 95.410% ( 870, 1300 ] 4 1.311% 96.721% ( 1300, 1900 ] 1 0.328% 97.049% ( 1900, 2900 ] 6 1.967% 99.016% ( 2900, 4400 ] 1 0.328% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 876.3500 StdDev: 901.03 Min: 107 Median: 513.3333 Max: 2972 Percentiles: P50: 513.33 P75: 870.00 P99: 2972.00 P99.9: 2972.00 P99.99: 2972.00 ------------------------------------------------------ ( 76, 110 ] 1 5.000% 5.000% # ( 110, 170 ] 2 10.000% 15.000% ## ( 170, 250 ] 5 25.000% 40.000% ##### ( 380, 580 ] 3 15.000% 55.000% ### ( 580, 870 ] 4 20.000% 75.000% #### ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 12.1 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 324.32 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.393 H:M:S, 11.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.87 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.389 H:M:S, 12.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/27-15:28:23 ... thread 0: (1000000,5000000) ops and (273616.8,320292.6) ops/second in (3.654746,15.610725) 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/13 3.20 GB 132.2 3.3 0.0 3.3 7.9 4.7 0.0 1.7 127.3 309.8 26.22 24.52 79 0.332 3390K 3563 0.0 0.0 L1 10/10 1.04 GB 0.0 1.3 1.3 0.0 1.3 1.3 0.2 1.0 236.1 235.2 5.60 5.42 2 2.799 1342K 4925 0.0 0.0 L2 1/0 77.40 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.3 1.5 254.0 253.9 0.76 0.72 2 0.381 196K 73 0.0 0.0 L3 15/0 870.29 MB 0.9 0.8 0.2 0.7 0.8 0.2 0.3 4.5 225.9 225.2 3.85 3.57 2 1.925 883K 3069 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 129.2 129.3 1.30 0.88 1 1.301 170K 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1262/23 100.80 GB 0.0 5.8 1.8 4.0 10.4 6.4 1.4 2.2 156.2 282.7 37.73 35.11 86 0.439 5982K 11K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.8 1.8 4.0 10.4 6.4 1.4 2.2 156.2 282.7 37.73 35.11 86 0.439 5982K 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 5.8 1.8 4.0 5.7 1.8 0.0 0.0 244.6 244.1 24.09 22.94 19 1.268 5982K 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 351.0 13.64 12.17 67 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): 15.8 total, 15.6 interval Flush(GB): cumulative 4.675, interval 4.675 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.42 GB write, 675.47 MB/s write, 5.75 GB read, 373.08 MB/s read, 37.7 seconds Interval compaction: 10.42 GB write, 683.31 MB/s write, 5.75 GB read, 377.41 MB/s read, 37.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 3, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 3, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 17, interval: 20 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1479525 Average: 2.2124 StdDev: 9.63 Min: 0 Median: 1.5043 Max: 3618 Percentiles: P50: 1.50 P75: 1.89 P99: 5.62 P99.9: 10.41 P99.99: 14.84 ------------------------------------------------------ [ 0, 1 ] 251179 16.977% 16.977% ### ( 1, 2 ] 968746 65.477% 82.454% ############# ( 2, 3 ] 166415 11.248% 93.702% ## ( 3, 4 ] 50710 3.427% 97.129% # ( 4, 6 ] 34086 2.304% 99.433% ( 6, 10 ] 6787 0.459% 99.892% ( 10, 15 ] 1502 0.102% 99.993% ( 15, 22 ] 98 0.007% 100.000% ( 22, 34 ] 21 0.001% 100.001% ( 34, 51 ] 10 0.001% 100.002% ( 51, 76 ] 8 0.001% 100.003% ( 76, 110 ] 29 0.002% 100.004% ( 110, 170 ] 111 0.008% 100.012% ( 170, 250 ] 65 0.004% 100.016% ( 250, 380 ] 42 0.003% 100.019% ( 380, 580 ] 34 0.002% 100.021% ( 580, 870 ] 32 0.002% 100.024% ( 870, 1300 ] 18 0.001% 100.025% ( 1300, 1900 ] 4 0.000% 100.025% ( 1900, 2900 ] 8 0.001% 100.026% ( 2900, 4400 ] 3 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 124982 Average: 2.6514 StdDev: 17.96 Min: 1 Median: 1.5215 Max: 3215 Percentiles: P50: 1.52 P75: 1.90 P99: 7.91 P99.9: 135.73 P99.99: 826.55 ------------------------------------------------------ [ 0, 1 ] 19404 15.525% 15.525% ### ( 1, 2 ] 82621 66.106% 81.632% ############# ( 2, 3 ] 14778 11.824% 93.456% ## ( 3, 4 ] 3525 2.820% 96.276% # ( 4, 6 ] 2607 2.086% 98.362% ( 6, 10 ] 1673 1.339% 99.701% ( 10, 15 ] 106 0.085% 99.786% ( 15, 22 ] 15 0.012% 99.798% ( 22, 34 ] 2 0.002% 99.799% ( 34, 51 ] 1 0.001% 99.800% ( 51, 76 ] 2 0.002% 99.802% ( 76, 110 ] 90 0.072% 99.874% ( 110, 170 ] 77 0.062% 99.935% ( 170, 250 ] 22 0.018% 99.953% ( 250, 380 ] 22 0.018% 99.970% ( 380, 580 ] 16 0.013% 99.983% ( 580, 870 ] 10 0.008% 99.991% ( 870, 1300 ] 6 0.005% 99.996% ( 1300, 1900 ] 3 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 77383 Average: 2.6776 StdDev: 17.65 Min: 1 Median: 1.6108 Max: 3382 Percentiles: P50: 1.61 P75: 1.99 P99: 7.63 P99.9: 24.47 P99.99: 640.98 ------------------------------------------------------ [ 0, 1 ] 7521 9.719% 9.719% ## ( 1, 2 ] 51032 65.947% 75.666% ############# ( 2, 3 ] 11428 14.768% 90.435% ### ( 3, 4 ] 3315 4.284% 94.718% # ( 4, 6 ] 2910 3.761% 98.479% # ( 6, 10 ] 992 1.282% 99.761% ( 10, 15 ] 97 0.125% 99.886% ( 15, 22 ] 10 0.013% 99.899% ( 22, 34 ] 3 0.004% 99.903% ( 51, 76 ] 1 0.001% 99.904% ( 110, 170 ] 30 0.039% 99.943% ( 170, 250 ] 14 0.018% 99.961% ( 250, 380 ] 11 0.014% 99.975% ( 380, 580 ] 10 0.013% 99.988% ( 580, 870 ] 6 0.008% 99.996% ( 870, 1300 ] 1 0.001% 99.997% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 186690 Average: 3.6838 StdDev: 43.43 Min: 1 Median: 1.7031 Max: 6502 Percentiles: P50: 1.70 P75: 2.35 P99: 8.96 P99.9: 201.09 P99.99: 695.23 ------------------------------------------------------ [ 0, 1 ] 14561 7.800% 7.800% ## ( 1, 2 ] 112050 60.019% 67.819% ############ ( 2, 3 ] 38439 20.590% 88.409% #### ( 3, 4 ] 8895 4.765% 93.173% # ( 4, 6 ] 8523 4.565% 97.738% # ( 6, 10 ] 3186 1.707% 99.445% ( 10, 15 ] 386 0.207% 99.652% ( 15, 22 ] 82 0.044% 99.696% ( 22, 34 ] 32 0.017% 99.713% ( 34, 51 ] 8 0.004% 99.717% ( 51, 76 ] 23 0.012% 99.729% ( 76, 110 ] 131 0.070% 99.800% ( 110, 170 ] 157 0.084% 99.884% ( 170, 250 ] 78 0.042% 99.926% ( 250, 380 ] 60 0.032% 99.958% ( 380, 580 ] 50 0.027% 99.984% ( 580, 870 ] 26 0.014% 99.998% ( 870, 1300 ] 14 0.007% 100.006% ( 1300, 1900 ] 11 0.006% 100.012% ( 1900, 2900 ] 9 0.005% 100.017% ( 2900, 4400 ] 14 0.007% 100.024% ( 4400, 6600 ] 1 0.001% 100.025% ** Level 4 read latency histogram (micros): Count: 305 Average: 119.4066 StdDev: 563.53 Min: 1 Median: 1.6500 Max: 4854 Percentiles: P50: 1.65 P75: 4.59 P99: 2891.67 P99.9: 4854.00 P99.99: 4854.00 ------------------------------------------------------ [ 0, 1 ] 68 22.295% 22.295% #### ( 1, 2 ] 130 42.623% 64.918% ######### ( 2, 3 ] 24 7.869% 72.787% ## ( 3, 4 ] 2 0.656% 73.443% ( 4, 6 ] 16 5.246% 78.689% # ( 6, 10 ] 39 12.787% 91.475% ### ( 10, 15 ] 4 1.311% 92.787% ( 15, 22 ] 1 0.328% 93.115% ( 170, 250 ] 2 0.656% 93.770% ( 250, 380 ] 1 0.328% 94.098% ( 380, 580 ] 2 0.656% 94.754% ( 580, 870 ] 2 0.656% 95.410% ( 870, 1300 ] 4 1.311% 96.721% ( 1300, 1900 ] 1 0.328% 97.049% ( 1900, 2900 ] 6 1.967% 99.016% ( 2900, 4400 ] 1 0.328% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 876.3500 StdDev: 901.03 Min: 107 Median: 513.3333 Max: 2972 Percentiles: P50: 513.33 P75: 870.00 P99: 2972.00 P99.9: 2972.00 P99.99: 2972.00 ------------------------------------------------------ ( 76, 110 ] 1 5.000% 5.000% # ( 110, 170 ] 2 10.000% 15.000% ## ( 170, 250 ] 5 25.000% 40.000% ##### ( 380, 580 ] 3 15.000% 55.000% ### ( 580, 870 ] 4 20.000% 75.000% #### ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 15.8 total, 3.7 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 311.58 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.373 H:M:S, 15.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 269.29 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.980 H:M:S, 26.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/27-15:28:30 ... thread 0: (1000000,6000000) ops and (136938.4,261856.9) ops/second in (7.302553,22.913278) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/4 2.52 GB 232.6 5.0 0.0 5.0 10.7 5.7 0.0 1.9 143.4 304.2 36.01 33.78 100 0.360 5244K 6936 0.0 0.0 L1 15/0 1.66 GB 170.3 4.0 3.0 1.0 4.0 2.9 0.2 1.3 229.4 227.4 17.81 17.09 3 5.937 4149K 36K 0.0 0.0 L2 9/5 1.08 GB 5.2 0.2 0.1 0.1 0.2 0.1 1.3 1.5 254.0 253.9 0.76 0.72 2 0.381 196K 73 0.0 0.0 L3 15/8 870.29 MB 0.7 0.8 0.2 0.7 0.8 0.2 0.3 4.5 225.9 225.2 3.85 3.57 2 1.925 883K 3069 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 129.2 129.3 1.30 0.88 1 1.301 170K 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1267/17 101.75 GB 0.0 10.2 3.4 6.8 15.9 9.0 2.4 2.8 175.5 271.7 59.73 56.04 108 0.553 10M 46K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.2 3.4 6.8 15.9 9.0 2.4 2.8 175.5 271.7 59.73 56.04 108 0.553 10M 46K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 10.2 3.4 6.8 10.2 3.4 0.0 0.0 242.8 241.7 43.17 41.30 25 1.727 10M 46K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 350.0 16.56 14.74 83 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 23.1 total, 22.9 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 15.85 GB write, 702.81 MB/s write, 10.24 GB read, 453.89 MB/s read, 59.7 seconds Interval compaction: 15.85 GB write, 708.36 MB/s write, 10.24 GB read, 457.47 MB/s read, 59.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 12, total-stops: 17, interval: 29 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2128461 Average: 2.2848 StdDev: 11.23 Min: 0 Median: 1.4964 Max: 3618 Percentiles: P50: 1.50 P75: 1.88 P99: 5.74 P99.9: 12.99 P99.99: 153.53 ------------------------------------------------------ [ 0, 1 ] 369889 17.378% 17.378% ### ( 1, 2 ] 1398650 65.712% 83.090% ############# ( 2, 3 ] 229821 10.798% 93.888% ## ( 3, 4 ] 68936 3.239% 97.126% # ( 4, 6 ] 45854 2.154% 99.281% ( 6, 10 ] 11902 0.559% 99.840% ( 10, 15 ] 2142 0.101% 99.940% ( 15, 22 ] 157 0.007% 99.948% ( 22, 34 ] 25 0.001% 99.949% ( 34, 51 ] 11 0.001% 99.950% ( 51, 76 ] 21 0.001% 99.951% ( 76, 110 ] 461 0.022% 99.972% ( 110, 170 ] 524 0.025% 99.997% ( 170, 250 ] 190 0.009% 100.006% ( 250, 380 ] 130 0.006% 100.012% ( 380, 580 ] 106 0.005% 100.017% ( 580, 870 ] 62 0.003% 100.020% ( 870, 1300 ] 30 0.001% 100.021% ( 1300, 1900 ] 6 0.000% 100.021% ( 1900, 2900 ] 12 0.001% 100.022% ( 2900, 4400 ] 7 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 318098 Average: 2.9070 StdDev: 19.63 Min: 0 Median: 1.5446 Max: 3215 Percentiles: P50: 1.54 P75: 1.93 P99: 8.38 P99.9: 168.26 P99.99: 577.84 ------------------------------------------------------ [ 0, 1 ] 46367 14.576% 14.576% ### ( 1, 2 ] 206911 65.046% 79.623% ############# ( 2, 3 ] 41076 12.913% 92.536% ### ( 3, 4 ] 9833 3.091% 95.627% # ( 4, 6 ] 8026 2.523% 98.150% # ( 6, 10 ] 4551 1.431% 99.581% ( 10, 15 ] 382 0.120% 99.701% ( 15, 22 ] 60 0.019% 99.720% ( 22, 34 ] 6 0.002% 99.721% ( 34, 51 ] 1 0.000% 99.722% ( 51, 76 ] 17 0.005% 99.727% ( 76, 110 ] 246 0.077% 99.804% ( 110, 170 ] 314 0.099% 99.903% ( 170, 250 ] 110 0.035% 99.938% ( 250, 380 ] 93 0.029% 99.967% ( 380, 580 ] 75 0.024% 99.991% ( 580, 870 ] 31 0.010% 100.000% ( 870, 1300 ] 20 0.006% 100.007% ( 1300, 1900 ] 10 0.003% 100.010% ( 1900, 2900 ] 2 0.001% 100.010% ( 2900, 4400 ] 2 0.001% 100.011% ** Level 2 read latency histogram (micros): Count: 77383 Average: 2.6776 StdDev: 17.65 Min: 1 Median: 1.6108 Max: 3382 Percentiles: P50: 1.61 P75: 1.99 P99: 7.63 P99.9: 24.47 P99.99: 640.98 ------------------------------------------------------ [ 0, 1 ] 7521 9.719% 9.719% ## ( 1, 2 ] 51032 65.947% 75.666% ############# ( 2, 3 ] 11428 14.768% 90.435% ### ( 3, 4 ] 3315 4.284% 94.718% # ( 4, 6 ] 2910 3.761% 98.479% # ( 6, 10 ] 992 1.282% 99.761% ( 10, 15 ] 97 0.125% 99.886% ( 15, 22 ] 10 0.013% 99.899% ( 22, 34 ] 3 0.004% 99.903% ( 51, 76 ] 1 0.001% 99.904% ( 110, 170 ] 30 0.039% 99.943% ( 170, 250 ] 14 0.018% 99.961% ( 250, 380 ] 11 0.014% 99.975% ( 380, 580 ] 10 0.013% 99.988% ( 580, 870 ] 6 0.008% 99.996% ( 870, 1300 ] 1 0.001% 99.997% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 190463 Average: 4.2024 StdDev: 46.05 Min: 1 Median: 1.7070 Max: 6502 Percentiles: P50: 1.71 P75: 2.36 P99: 9.38 P99.9: 346.75 P99.99: 840.13 ------------------------------------------------------ [ 0, 1 ] 14665 7.700% 7.700% ## ( 1, 2 ] 113955 59.831% 67.530% ############ ( 2, 3 ] 39435 20.705% 88.235% #### ( 3, 4 ] 9064 4.759% 92.994% # ( 4, 6 ] 8685 4.560% 97.554% # ( 6, 10 ] 3255 1.709% 99.263% ( 10, 15 ] 392 0.206% 99.469% ( 15, 22 ] 82 0.043% 99.512% ( 22, 34 ] 32 0.017% 99.529% ( 34, 51 ] 8 0.004% 99.533% ( 51, 76 ] 23 0.012% 99.545% ( 76, 110 ] 185 0.097% 99.642% ( 110, 170 ] 258 0.135% 99.777% ( 170, 250 ] 142 0.075% 99.852% ( 250, 380 ] 123 0.065% 99.917% ( 380, 580 ] 96 0.050% 99.967% ( 580, 870 ] 49 0.026% 99.993% ( 870, 1300 ] 23 0.012% 100.005% ( 1300, 1900 ] 12 0.006% 100.011% ( 1900, 2900 ] 10 0.005% 100.016% ( 2900, 4400 ] 14 0.007% 100.024% ( 4400, 6600 ] 1 0.001% 100.024% ** Level 4 read latency histogram (micros): Count: 305 Average: 119.4066 StdDev: 563.53 Min: 1 Median: 1.6500 Max: 4854 Percentiles: P50: 1.65 P75: 4.59 P99: 2891.67 P99.9: 4854.00 P99.99: 4854.00 ------------------------------------------------------ [ 0, 1 ] 68 22.295% 22.295% #### ( 1, 2 ] 130 42.623% 64.918% ######### ( 2, 3 ] 24 7.869% 72.787% ## ( 3, 4 ] 2 0.656% 73.443% ( 4, 6 ] 16 5.246% 78.689% # ( 6, 10 ] 39 12.787% 91.475% ### ( 10, 15 ] 4 1.311% 92.787% ( 15, 22 ] 1 0.328% 93.115% ( 170, 250 ] 2 0.656% 93.770% ( 250, 380 ] 1 0.328% 94.098% ( 380, 580 ] 2 0.656% 94.754% ( 580, 870 ] 2 0.656% 95.410% ( 870, 1300 ] 4 1.311% 96.721% ( 1300, 1900 ] 1 0.328% 97.049% ( 1900, 2900 ] 6 1.967% 99.016% ( 2900, 4400 ] 1 0.328% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 876.3500 StdDev: 901.03 Min: 107 Median: 513.3333 Max: 2972 Percentiles: P50: 513.33 P75: 870.00 P99: 2972.00 P99.9: 2972.00 P99.99: 2972.00 ------------------------------------------------------ ( 76, 110 ] 1 5.000% 5.000% # ( 110, 170 ] 2 10.000% 15.000% ## ( 170, 250 ] 5 25.000% 40.000% ##### ( 380, 580 ] 3 15.000% 55.000% ### ( 580, 870 ] 4 20.000% 75.000% #### ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 23.1 total, 7.3 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 255.68 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:6.788 H:M:S, 29.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 134.77 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:4.415 H:M:S, 60.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/27-15:28:36 ... thread 0: (1000000,7000000) ops and (174371.1,244343.7) ops/second in (5.734895,28.648173) 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/15 3.44 GB 44.1 5.5 0.0 5.5 12.1 6.6 0.0 1.8 138.7 303.5 40.86 38.14 115 0.355 5756K 7460 0.0 0.0 L1 15/15 1.66 GB 0.0 4.0 3.0 1.0 4.0 2.9 0.2 1.3 229.4 227.4 17.81 17.09 3 5.937 4149K 36K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 1.3 1.5 254.0 253.9 0.76 0.72 2 0.381 196K 73 0.0 0.0 L3 25/0 956.97 MB 1.0 2.1 1.3 0.9 2.1 1.3 0.3 1.7 219.7 219.1 9.95 9.14 5 1.990 2220K 5810 0.0 0.0 L4 176/0 9.71 GB 1.0 0.6 0.6 0.0 0.6 0.6 0.8 1.0 120.1 120.0 5.53 3.24 11 0.503 669K 715 0.0 0.0 L5 1056/0 86.92 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1290/30 102.67 GB 0.0 12.5 5.0 7.5 19.0 11.5 3.9 2.9 170.9 260.2 74.91 68.33 136 0.551 12M 50K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.5 5.0 7.5 19.0 11.5 3.9 2.9 170.9 260.2 74.91 68.33 136 0.551 12M 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 12.5 5.0 7.5 12.5 4.9 0.0 0.0 230.7 229.8 55.47 51.16 40 1.387 12M 50K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.6 6.6 0.0 0.0 0.0 346.7 19.44 17.17 96 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): 28.8 total, 28.6 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 19.03 GB write, 676.01 MB/s write, 12.50 GB read, 443.97 MB/s read, 74.9 seconds Interval compaction: 19.03 GB write, 680.28 MB/s write, 12.50 GB read, 446.78 MB/s read, 74.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 19, pending-compaction-bytes-delays: 7, pending-compaction-bytes-stops: 0, total-delays: 19, total-stops: 19, interval: 38 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2542036 Average: 2.3117 StdDev: 11.28 Min: 0 Median: 1.5089 Max: 3915 Percentiles: P50: 1.51 P75: 1.89 P99: 5.83 P99.9: 13.43 P99.99: 154.22 ------------------------------------------------------ [ 0, 1 ] 419294 16.494% 16.494% ### ( 1, 2 ] 1673805 65.845% 82.339% ############# ( 2, 3 ] 285682 11.238% 93.578% ## ( 3, 4 ] 85163 3.350% 96.928% # ( 4, 6 ] 57549 2.264% 99.192% ( 6, 10 ] 16151 0.635% 99.827% ( 10, 15 ] 2702 0.106% 99.934% ( 15, 22 ] 202 0.008% 99.941% ( 22, 34 ] 28 0.001% 99.943% ( 34, 51 ] 14 0.001% 99.943% ( 51, 76 ] 34 0.001% 99.944% ( 76, 110 ] 698 0.027% 99.972% ( 110, 170 ] 628 0.025% 99.997% ( 170, 250 ] 225 0.009% 100.005% ( 250, 380 ] 154 0.006% 100.012% ( 380, 580 ] 121 0.005% 100.016% ( 580, 870 ] 70 0.003% 100.019% ( 870, 1300 ] 33 0.001% 100.020% ( 1300, 1900 ] 7 0.000% 100.021% ( 1900, 2900 ] 15 0.001% 100.021% ( 2900, 4400 ] 8 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 591151 Average: 2.8065 StdDev: 16.75 Min: 0 Median: 1.5669 Max: 3215 Percentiles: P50: 1.57 P75: 1.95 P99: 8.43 P99.9: 155.04 P99.99: 576.01 ------------------------------------------------------ [ 0, 1 ] 74770 12.648% 12.648% ### ( 1, 2 ] 389463 65.882% 78.530% ############# ( 2, 3 ] 81766 13.832% 92.362% ### ( 3, 4 ] 18778 3.177% 95.539% # ( 4, 6 ] 14919 2.524% 98.062% # ( 6, 10 ] 9143 1.547% 99.609% ( 10, 15 ] 792 0.134% 99.743% ( 15, 22 ] 96 0.016% 99.759% ( 22, 34 ] 9 0.002% 99.761% ( 34, 51 ] 1 0.000% 99.761% ( 51, 76 ] 33 0.006% 99.766% ( 76, 110 ] 428 0.072% 99.839% ( 110, 170 ] 482 0.082% 99.920% ( 170, 250 ] 163 0.028% 99.948% ( 250, 380 ] 145 0.025% 99.972% ( 380, 580 ] 106 0.018% 99.990% ( 580, 870 ] 48 0.008% 99.998% ( 870, 1300 ] 27 0.005% 100.003% ( 1300, 1900 ] 14 0.002% 100.005% ( 1900, 2900 ] 2 0.000% 100.006% ( 2900, 4400 ] 2 0.000% 100.006% ** Level 2 read latency histogram (micros): Count: 77383 Average: 2.6776 StdDev: 17.65 Min: 1 Median: 1.6108 Max: 3382 Percentiles: P50: 1.61 P75: 1.99 P99: 7.63 P99.9: 24.47 P99.99: 640.98 ------------------------------------------------------ [ 0, 1 ] 7521 9.719% 9.719% ## ( 1, 2 ] 51032 65.947% 75.666% ############# ( 2, 3 ] 11428 14.768% 90.435% ### ( 3, 4 ] 3315 4.284% 94.718% # ( 4, 6 ] 2910 3.761% 98.479% # ( 6, 10 ] 992 1.282% 99.761% ( 10, 15 ] 97 0.125% 99.886% ( 15, 22 ] 10 0.013% 99.899% ( 22, 34 ] 3 0.004% 99.903% ( 51, 76 ] 1 0.001% 99.904% ( 110, 170 ] 30 0.039% 99.943% ( 170, 250 ] 14 0.018% 99.961% ( 250, 380 ] 11 0.014% 99.975% ( 380, 580 ] 10 0.013% 99.988% ( 580, 870 ] 6 0.008% 99.996% ( 870, 1300 ] 1 0.001% 99.997% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 325210 Average: 4.0927 StdDev: 51.94 Min: 0 Median: 1.7925 Max: 8014 Percentiles: P50: 1.79 P75: 2.61 P99: 8.83 P99.9: 151.57 P99.99: 278.92 ------------------------------------------------------ [ 0, 1 ] 18209 5.599% 5.599% # ( 1, 2 ] 182212 56.029% 61.628% ########### ( 2, 3 ] 71561 22.005% 83.633% #### ( 3, 4 ] 23271 7.156% 90.788% # ( 4, 6 ] 22986 7.068% 97.856% # ( 6, 10 ] 5261 1.618% 99.474% ( 10, 15 ] 779 0.240% 99.714% ( 15, 22 ] 114 0.035% 99.749% ( 22, 34 ] 34 0.010% 99.759% ( 34, 51 ] 9 0.003% 99.762% ( 51, 76 ] 23 0.007% 99.769% ( 76, 110 ] 211 0.065% 99.834% ( 110, 170 ] 310 0.095% 99.929% ( 170, 250 ] 165 0.051% 99.980% ( 250, 380 ] 146 0.045% 100.025% ( 380, 580 ] 112 0.034% 100.059% ( 580, 870 ] 57 0.018% 100.077% ( 870, 1300 ] 25 0.008% 100.085% ( 1300, 1900 ] 12 0.004% 100.088% ( 1900, 2900 ] 12 0.004% 100.092% ( 2900, 4400 ] 35 0.011% 100.103% ( 4400, 6600 ] 4 0.001% 100.104% ( 6600, 9900 ] 1 0.000% 100.104% ** Level 4 read latency histogram (micros): Count: 7782 Average: 49.0015 StdDev: 233.49 Min: 1 Median: 1.9744 Max: 4854 Percentiles: P50: 1.97 P75: 3.33 P99: 948.95 P99.9: 3603.00 P99.99: 4854.00 ------------------------------------------------------ [ 0, 1 ] 311 3.996% 3.996% # ( 1, 2 ] 3674 47.212% 51.208% ######### ( 2, 3 ] 1580 20.303% 71.511% #### ( 3, 4 ] 827 10.627% 82.138% ## ( 4, 6 ] 480 6.168% 88.306% # ( 6, 10 ] 192 2.467% 90.774% ( 10, 15 ] 31 0.398% 91.172% ( 15, 22 ] 6 0.077% 91.249% ( 22, 34 ] 1 0.013% 91.262% ( 76, 110 ] 32 0.411% 91.673% ( 110, 170 ] 100 1.285% 92.958% ( 170, 250 ] 98 1.259% 94.217% ( 250, 380 ] 118 1.516% 95.734% ( 380, 580 ] 142 1.825% 97.558% ( 580, 870 ] 103 1.324% 98.882% ( 870, 1300 ] 50 0.643% 99.525% ( 1300, 1900 ] 16 0.206% 99.730% ( 1900, 2900 ] 9 0.116% 99.846% ( 2900, 4400 ] 9 0.116% 99.961% ( 4400, 6600 ] 3 0.039% 100.000% ** Level 5 read latency histogram (micros): Count: 80 Average: 834.8500 StdDev: 974.83 Min: 81 Median: 405.0000 Max: 3978 Percentiles: P50: 405.00 P75: 870.00 P99: 3978.00 P99.9: 3978.00 P99.99: 3978.00 ------------------------------------------------------ ( 76, 110 ] 11 13.750% 13.750% ### ( 110, 170 ] 12 15.000% 28.750% ### ( 170, 250 ] 10 12.500% 41.250% ### ( 250, 380 ] 6 7.500% 48.750% ## ( 380, 580 ] 8 10.000% 58.750% ## ( 580, 870 ] 13 16.250% 75.000% ### ( 1300, 1900 ] 7 8.750% 83.750% ## ( 1900, 2900 ] 8 10.000% 93.750% ## ( 2900, 4400 ] 5 6.250% 100.000% # ** DB Stats ** Uptime(secs): 28.8 total, 5.7 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 238.96 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:9.662 H:M:S, 33.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 171.61 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.874 H:M:S, 50.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/27-15:28:56 ... thread 0: (1000000,8000000) ops and (50595.7,165245.9) ops/second in (19.764533,48.412706) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/8 1.78 GB 18.9 6.6 0.0 6.6 14.3 7.6 0.0 1.9 139.6 299.7 48.74 45.07 134 0.364 6907K 8665 0.0 0.0 L1 11/11 1.27 GB 0.0 8.4 5.7 2.7 8.2 5.5 0.2 1.5 223.9 220.8 38.21 35.80 4 9.554 8465K 36K 0.0 0.0 L2 11/9 1.38 GB 2.6 0.2 0.1 0.1 0.2 0.1 4.3 1.5 254.0 253.9 0.76 0.72 2 0.381 196K 73 0.0 0.0 L3 35/13 1.64 GB 0.9 4.2 2.8 1.5 4.2 2.8 0.4 1.5 173.3 172.5 25.01 19.03 13 1.924 4402K 18K 0.0 0.0 L4 175/2 9.64 GB 1.0 1.6 1.5 0.1 1.6 1.5 0.8 1.0 131.9 131.6 12.37 7.68 22 0.562 1627K 1230 0.0 0.0 L5 1068/0 87.91 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1310/43 103.62 GB 0.0 21.0 10.1 10.9 28.5 17.6 8.0 3.7 172.0 233.3 125.10 108.31 175 0.715 21M 64K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.0 10.1 10.9 28.5 17.6 8.0 3.7 172.0 233.3 125.10 108.31 175 0.715 21M 64K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 21.0 10.1 10.9 20.9 9.9 0.0 0.0 211.0 209.6 101.97 88.33 64 1.593 21M 64K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.6 7.6 0.0 0.0 0.0 337.8 23.12 19.98 111 0.208 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 48.6 total, 48.4 interval Flush(GB): cumulative 7.629, interval 7.629 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 28.50 GB write, 600.52 MB/s write, 21.01 GB read, 442.80 MB/s read, 125.1 seconds Interval compaction: 28.50 GB write, 602.76 MB/s write, 21.01 GB read, 444.46 MB/s read, 125.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 20, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 20, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 29, pending-compaction-bytes-delays: 23, pending-compaction-bytes-stops: 0, total-delays: 43, total-stops: 29, interval: 72 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3386023 Average: 2.7721 StdDev: 22.47 Min: 0 Median: 1.5009 Max: 7451 Percentiles: P50: 1.50 P75: 1.89 P99: 6.61 P99.9: 138.20 P99.99: 464.58 ------------------------------------------------------ [ 0, 1 ] 596818 17.626% 17.626% #### ( 1, 2 ] 2188650 64.638% 82.264% ############# ( 2, 3 ] 360851 10.657% 92.921% ## ( 3, 4 ] 117268 3.463% 96.384% # ( 4, 6 ] 84992 2.510% 98.894% # ( 6, 10 ] 23572 0.696% 99.590% ( 10, 15 ] 4300 0.127% 99.717% ( 15, 22 ] 462 0.014% 99.731% ( 22, 34 ] 38 0.001% 99.732% ( 34, 51 ] 18 0.001% 99.733% ( 51, 76 ] 82 0.002% 99.735% ( 76, 110 ] 4208 0.124% 99.859% ( 110, 170 ] 2934 0.087% 99.946% ( 170, 250 ] 686 0.020% 99.966% ( 250, 380 ] 559 0.017% 99.983% ( 380, 580 ] 585 0.017% 100.000% ( 580, 870 ] 334 0.010% 100.010% ( 870, 1300 ] 165 0.005% 100.015% ( 1300, 1900 ] 72 0.002% 100.017% ( 1900, 2900 ] 48 0.001% 100.018% ( 2900, 4400 ] 39 0.001% 100.019% ( 4400, 6600 ] 3 0.000% 100.020% ( 6600, 9900 ] 1 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 1629923 Average: 4.2823 StdDev: 57.71 Min: 0 Median: 1.6557 Max: 8189 Percentiles: P50: 1.66 P75: 2.36 P99: 9.10 P99.9: 146.36 P99.99: 403.96 ------------------------------------------------------ [ 0, 1 ] 213189 13.080% 13.080% ### ( 1, 2 ] 917791 56.309% 69.389% ########### ( 2, 3 ] 253839 15.574% 84.962% ### ( 3, 4 ] 103873 6.373% 91.335% # ( 4, 6 ] 101232 6.211% 97.546% # ( 6, 10 ] 30544 1.874% 99.420% ( 10, 15 ] 4483 0.275% 99.695% ( 15, 22 ] 623 0.038% 99.733% ( 22, 34 ] 36 0.002% 99.735% ( 34, 51 ] 16 0.001% 99.736% ( 51, 76 ] 204 0.013% 99.749% ( 76, 110 ] 1635 0.100% 99.849% ( 110, 170 ] 1368 0.084% 99.933% ( 170, 250 ] 383 0.023% 99.957% ( 250, 380 ] 482 0.030% 99.986% ( 380, 580 ] 526 0.032% 100.018% ( 580, 870 ] 507 0.031% 100.050% ( 870, 1300 ] 377 0.023% 100.073% ( 1300, 1900 ] 186 0.011% 100.084% ( 1900, 2900 ] 122 0.007% 100.092% ( 2900, 4400 ] 130 0.008% 100.100% ( 4400, 6600 ] 45 0.003% 100.102% ( 6600, 9900 ] 10 0.001% 100.103% ** Level 2 read latency histogram (micros): Count: 77383 Average: 2.6776 StdDev: 17.65 Min: 1 Median: 1.6108 Max: 3382 Percentiles: P50: 1.61 P75: 1.99 P99: 7.63 P99.9: 24.47 P99.99: 640.98 ------------------------------------------------------ [ 0, 1 ] 7521 9.719% 9.719% ## ( 1, 2 ] 51032 65.947% 75.666% ############# ( 2, 3 ] 11428 14.768% 90.435% ### ( 3, 4 ] 3315 4.284% 94.718% # ( 4, 6 ] 2910 3.761% 98.479% # ( 6, 10 ] 992 1.282% 99.761% ( 10, 15 ] 97 0.125% 99.886% ( 15, 22 ] 10 0.013% 99.899% ( 22, 34 ] 3 0.004% 99.903% ( 51, 76 ] 1 0.001% 99.904% ( 110, 170 ] 30 0.039% 99.943% ( 170, 250 ] 14 0.018% 99.961% ( 250, 380 ] 11 0.014% 99.975% ( 380, 580 ] 10 0.013% 99.988% ( 580, 870 ] 6 0.008% 99.996% ( 870, 1300 ] 1 0.001% 99.997% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 822126 Average: 4.9384 StdDev: 59.58 Min: 0 Median: 1.9478 Max: 8014 Percentiles: P50: 1.95 P75: 2.94 P99: 9.19 P99.9: 170.24 P99.99: 388.49 ------------------------------------------------------ [ 0, 1 ] 22454 2.731% 2.731% # ( 1, 2 ] 410020 49.873% 52.604% ########## ( 2, 3 ] 196881 23.948% 76.552% ##### ( 3, 4 ] 83463 10.152% 86.704% ## ( 4, 6 ] 87551 10.649% 97.354% ## ( 6, 10 ] 16975 2.065% 99.418% ( 10, 15 ] 2933 0.357% 99.775% ( 15, 22 ] 323 0.039% 99.814% ( 22, 34 ] 51 0.006% 99.821% ( 34, 51 ] 16 0.002% 99.823% ( 51, 76 ] 32 0.004% 99.826% ( 76, 110 ] 224 0.027% 99.854% ( 110, 170 ] 382 0.046% 99.900% ( 170, 250 ] 290 0.035% 99.935% ( 250, 380 ] 433 0.053% 99.988% ( 380, 580 ] 419 0.051% 100.039% ( 580, 870 ] 362 0.044% 100.083% ( 870, 1300 ] 211 0.026% 100.109% ( 1300, 1900 ] 94 0.011% 100.120% ( 1900, 2900 ] 70 0.009% 100.129% ( 2900, 4400 ] 81 0.010% 100.139% ( 4400, 6600 ] 19 0.002% 100.141% ( 6600, 9900 ] 2 0.000% 100.141% ** Level 4 read latency histogram (micros): Count: 17210 Average: 87.8918 StdDev: 412.97 Min: 1 Median: 2.1350 Max: 10645 Percentiles: P50: 2.14 P75: 3.52 P99: 2140.23 P99.9: 4863.22 P99.99: 8710.35 ------------------------------------------------------ [ 0, 1 ] 429 2.493% 2.493% ( 1, 2 ] 7667 44.550% 47.042% ######### ( 2, 3 ] 3770 21.906% 68.948% #### ( 3, 4 ] 1988 11.551% 80.500% ## ( 4, 6 ] 1268 7.368% 87.868% # ( 6, 10 ] 444 2.580% 90.447% # ( 10, 15 ] 78 0.453% 90.901% ( 15, 22 ] 11 0.064% 90.965% ( 22, 34 ] 5 0.029% 90.994% ( 76, 110 ] 42 0.244% 91.238% ( 110, 170 ] 120 0.697% 91.935% ( 170, 250 ] 140 0.813% 92.748% ( 250, 380 ] 195 1.133% 93.881% ( 380, 580 ] 260 1.511% 95.392% ( 580, 870 ] 264 1.534% 96.926% ( 870, 1300 ] 209 1.214% 98.141% ( 1300, 1900 ] 127 0.738% 98.879% ( 1900, 2900 ] 87 0.506% 99.384% ( 2900, 4400 ] 85 0.494% 99.878% ( 4400, 6600 ] 18 0.105% 99.983% ( 6600, 9900 ] 2 0.012% 99.994% ( 9900, 14000 ] 1 0.006% 100.000% ** Level 5 read latency histogram (micros): Count: 140 Average: 1088.1429 StdDev: 1198.42 Min: 81 Median: 628.3333 Max: 6072 Percentiles: P50: 628.33 P75: 1580.00 P99: 5060.00 P99.9: 6072.00 P99.99: 6072.00 ------------------------------------------------------ ( 76, 110 ] 11 7.857% 7.857% ## ( 110, 170 ] 14 10.000% 17.857% ## ( 170, 250 ] 12 8.571% 26.429% ## ( 250, 380 ] 14 10.000% 36.429% ## ( 380, 580 ] 15 10.714% 47.143% ## ( 580, 870 ] 24 17.143% 64.286% ### ( 870, 1300 ] 8 5.714% 70.000% # ( 1300, 1900 ] 15 10.714% 80.714% ## ( 1900, 2900 ] 14 10.000% 90.714% ## ( 2900, 4400 ] 11 7.857% 98.571% ## ( 4400, 6600 ] 2 1.429% 100.000% ** DB Stats ** Uptime(secs): 48.6 total, 19.8 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 162.02 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:25.998 H:M:S, 53.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 49.79 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:16.336 H:M:S, 82.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 6 num-running-flushes: 1 2024/11/27-15:29:00 ... thread 0: (1000000,9000000) ops and (223336.8,170163.7) ops/second in (4.477543,52.890249) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/12 2.70 GB 88.1 7.3 0.0 7.3 15.9 8.5 0.0 1.9 134.2 290.9 55.84 50.38 148 0.377 7611K 9532 0.0 0.0 L1 11/11 1.27 GB 0.0 8.4 5.7 2.7 8.2 5.5 0.2 1.5 223.9 220.8 38.21 35.80 4 9.554 8465K 36K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 4.3 1.5 254.0 253.9 0.76 0.72 2 0.381 196K 73 0.0 0.0 L3 20/0 983.88 MB 1.0 6.4 4.2 2.2 6.3 4.1 0.4 1.5 164.2 163.5 39.65 29.05 19 2.087 6613K 29K 0.0 0.0 L4 174/0 9.72 GB 1.0 3.7 3.6 0.1 3.7 3.6 0.9 1.0 134.4 134.2 28.37 17.69 46 0.617 3792K 2912 0.0 0.0 L5 1092/0 89.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1313/23 104.53 GB 0.0 25.9 13.5 12.4 34.3 21.9 10.0 4.0 163.2 215.9 162.84 133.64 219 0.744 26M 78K 0.0 0.0 Int 0/0 0.00 KB 0.0 25.9 13.5 12.4 34.3 21.9 10.0 4.0 163.2 215.9 162.84 133.64 219 0.744 26M 78K 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 25.9 13.5 12.4 25.8 13.4 0.0 0.0 195.8 194.6 135.70 111.14 96 1.414 26M 78K 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.7 27.13 22.51 123 0.221 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.1 total, 52.9 interval Flush(GB): cumulative 8.551, interval 8.551 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 34.34 GB write, 662.54 MB/s write, 25.95 GB read, 500.63 MB/s read, 162.8 seconds Interval compaction: 34.34 GB write, 664.81 MB/s write, 25.95 GB read, 502.34 MB/s read, 162.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 20, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 20, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 47, pending-compaction-bytes-delays: 23, pending-compaction-bytes-stops: 0, total-delays: 43, total-stops: 47, interval: 90 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3786895 Average: 2.8319 StdDev: 23.34 Min: 0 Median: 1.5290 Max: 7451 Percentiles: P50: 1.53 P75: 1.92 P99: 7.04 P99.9: 133.26 P99.99: 455.97 ------------------------------------------------------ [ 0, 1 ] 615674 16.258% 16.258% ### ( 1, 2 ] 2415508 63.786% 80.044% ############# ( 2, 3 ] 441060 11.647% 91.691% ## ( 3, 4 ] 151607 4.003% 95.694% # ( 4, 6 ] 117245 3.096% 98.791% # ( 6, 10 ] 30412 0.803% 99.594% ( 10, 15 ] 5494 0.145% 99.739% ( 15, 22 ] 584 0.015% 99.754% ( 22, 34 ] 45 0.001% 99.755% ( 34, 51 ] 20 0.001% 99.756% ( 51, 76 ] 84 0.002% 99.758% ( 76, 110 ] 4226 0.112% 99.870% ( 110, 170 ] 2969 0.078% 99.948% ( 170, 250 ] 731 0.019% 99.967% ( 250, 380 ] 609 0.016% 99.983% ( 380, 580 ] 659 0.017% 100.001% ( 580, 870 ] 398 0.011% 100.011% ( 870, 1300 ] 203 0.005% 100.017% ( 1300, 1900 ] 92 0.002% 100.019% ( 1900, 2900 ] 58 0.002% 100.021% ( 2900, 4400 ] 50 0.001% 100.022% ( 4400, 6600 ] 3 0.000% 100.022% ( 6600, 9900 ] 1 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 1808568 Average: 4.6712 StdDev: 70.27 Min: 0 Median: 1.6826 Max: 10583 Percentiles: P50: 1.68 P75: 2.44 P99: 9.20 P99.9: 158.06 P99.99: 517.78 ------------------------------------------------------ [ 0, 1 ] 215897 11.937% 11.937% ## ( 1, 2 ] 1008420 55.758% 67.695% ########### ( 2, 3 ] 297324 16.440% 84.135% ### ( 3, 4 ] 121890 6.740% 90.875% # ( 4, 6 ] 118800 6.569% 97.443% # ( 6, 10 ] 35206 1.947% 99.390% ( 10, 15 ] 5445 0.301% 99.691% ( 15, 22 ] 735 0.041% 99.732% ( 22, 34 ] 36 0.002% 99.734% ( 34, 51 ] 18 0.001% 99.735% ( 51, 76 ] 204 0.011% 99.746% ( 76, 110 ] 1655 0.092% 99.838% ( 110, 170 ] 1410 0.078% 99.916% ( 170, 250 ] 410 0.023% 99.938% ( 250, 380 ] 530 0.029% 99.967% ( 380, 580 ] 591 0.033% 100.000% ( 580, 870 ] 561 0.031% 100.031% ( 870, 1300 ] 436 0.024% 100.055% ( 1300, 1900 ] 234 0.013% 100.068% ( 1900, 2900 ] 181 0.010% 100.078% ( 2900, 4400 ] 210 0.012% 100.090% ( 4400, 6600 ] 70 0.004% 100.094% ( 6600, 9900 ] 26 0.001% 100.095% ( 9900, 14000 ] 3 0.000% 100.095% ** Level 2 read latency histogram (micros): Count: 77383 Average: 2.6776 StdDev: 17.65 Min: 1 Median: 1.6108 Max: 3382 Percentiles: P50: 1.61 P75: 1.99 P99: 7.63 P99.9: 24.47 P99.99: 640.98 ------------------------------------------------------ [ 0, 1 ] 7521 9.719% 9.719% ## ( 1, 2 ] 51032 65.947% 75.666% ############# ( 2, 3 ] 11428 14.768% 90.435% ### ( 3, 4 ] 3315 4.284% 94.718% # ( 4, 6 ] 2910 3.761% 98.479% # ( 6, 10 ] 992 1.282% 99.761% ( 10, 15 ] 97 0.125% 99.886% ( 15, 22 ] 10 0.013% 99.899% ( 22, 34 ] 3 0.004% 99.903% ( 51, 76 ] 1 0.001% 99.904% ( 110, 170 ] 30 0.039% 99.943% ( 170, 250 ] 14 0.018% 99.961% ( 250, 380 ] 11 0.014% 99.975% ( 380, 580 ] 10 0.013% 99.988% ( 580, 870 ] 6 0.008% 99.996% ( 870, 1300 ] 1 0.001% 99.997% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1426338 Average: 5.4058 StdDev: 77.24 Min: 0 Median: 1.9873 Max: 10784 Percentiles: P50: 1.99 P75: 2.98 P99: 9.13 P99.9: 85.18 P99.99: 313.64 ------------------------------------------------------ [ 0, 1 ] 26150 1.833% 1.833% ( 1, 2 ] 695855 48.786% 50.619% ########## ( 2, 3 ] 356461 24.991% 75.611% ##### ( 3, 4 ] 152463 10.689% 86.300% ## ( 4, 6 ] 157794 11.063% 97.363% ## ( 6, 10 ] 29798 2.089% 99.452% ( 10, 15 ] 5584 0.391% 99.843% ( 15, 22 ] 608 0.043% 99.886% ( 22, 34 ] 68 0.005% 99.891% ( 34, 51 ] 25 0.002% 99.893% ( 51, 76 ] 39 0.003% 99.895% ( 76, 110 ] 247 0.017% 99.913% ( 110, 170 ] 446 0.031% 99.944% ( 170, 250 ] 370 0.026% 99.970% ( 250, 380 ] 587 0.041% 100.011% ( 380, 580 ] 581 0.041% 100.052% ( 580, 870 ] 554 0.039% 100.091% ( 870, 1300 ] 350 0.025% 100.115% ( 1300, 1900 ] 188 0.013% 100.128% ( 1900, 2900 ] 209 0.015% 100.143% ( 2900, 4400 ] 229 0.016% 100.159% ( 4400, 6600 ] 67 0.005% 100.164% ( 6600, 9900 ] 17 0.001% 100.165% ( 9900, 14000 ] 2 0.000% 100.165% ** Level 4 read latency histogram (micros): Count: 37811 Average: 91.4277 StdDev: 439.23 Min: 0 Median: 2.1418 Max: 10645 Percentiles: P50: 2.14 P75: 3.49 P99: 2360.63 P99.9: 5603.17 P99.99: 8117.48 ------------------------------------------------------ [ 0, 1 ] 834 2.206% 2.206% ( 1, 2 ] 16867 44.609% 46.814% ######### ( 2, 3 ] 8492 22.459% 69.273% #### ( 3, 4 ] 4445 11.756% 81.029% ## ( 4, 6 ] 2778 7.347% 88.376% # ( 6, 10 ] 943 2.494% 90.870% ( 10, 15 ] 178 0.471% 91.341% ( 15, 22 ] 21 0.056% 91.397% ( 22, 34 ] 9 0.024% 91.420% ( 34, 51 ] 1 0.003% 91.423% ( 76, 110 ] 79 0.209% 91.632% ( 110, 170 ] 210 0.555% 92.187% ( 170, 250 ] 280 0.741% 92.928% ( 250, 380 ] 360 0.952% 93.880% ( 380, 580 ] 557 1.473% 95.353% ( 580, 870 ] 554 1.465% 96.818% ( 870, 1300 ] 460 1.217% 98.035% ( 1300, 1900 ] 270 0.714% 98.749% ( 1900, 2900 ] 206 0.545% 99.294% ( 2900, 4400 ] 192 0.508% 99.802% ( 4400, 6600 ] 68 0.180% 99.981% ( 6600, 9900 ] 7 0.019% 100.000% ( 9900, 14000 ] 1 0.003% 100.003% ** Level 5 read latency histogram (micros): Count: 260 Average: 1148.7192 StdDev: 1205.66 Min: 81 Median: 660.5556 Max: 6072 Percentiles: P50: 660.56 P75: 1672.41 P99: 5170.00 P99.9: 6072.00 P99.99: 6072.00 ------------------------------------------------------ ( 76, 110 ] 15 5.769% 5.769% # ( 110, 170 ] 21 8.077% 13.846% ## ( 170, 250 ] 25 9.615% 23.462% ## ( 250, 380 ] 27 10.385% 33.846% ## ( 380, 580 ] 32 12.308% 46.154% ## ( 580, 870 ] 36 13.846% 60.000% ### ( 870, 1300 ] 21 8.077% 68.077% ## ( 1300, 1900 ] 29 11.154% 79.231% ## ( 1900, 2900 ] 24 9.231% 88.462% ## ( 2900, 4400 ] 26 10.000% 98.462% ## ( 4400, 6600 ] 4 1.538% 100.000% ** DB Stats ** Uptime(secs): 53.1 total, 4.5 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 166.90 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:27.538 H:M:S, 51.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 219.82 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.539 H:M:S, 34.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/27-15:29:05 ... thread 0: (1000000,10000000) ops and (233985.2,174935.2) ops/second in (4.273775,57.164024) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/8 3.69 GB 214.0 8.4 0.0 8.4 17.9 9.5 0.0 1.9 136.6 292.2 62.71 56.88 166 0.378 8698K 10K 0.0 0.0 L1 11/11 1.27 GB 0.0 8.4 5.7 2.7 8.2 5.5 0.2 1.5 223.9 220.8 38.21 35.80 4 9.554 8465K 36K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 4.3 1.5 254.0 253.9 0.76 0.72 2 0.381 196K 73 0.0 0.0 L3 20/0 983.88 MB 1.0 6.4 4.2 2.2 6.3 4.1 0.4 1.5 164.2 163.5 39.65 29.05 19 2.087 6613K 29K 0.0 0.0 L4 174/0 9.72 GB 1.0 3.7 3.6 0.1 3.7 3.6 0.9 1.0 134.4 134.2 28.37 17.69 46 0.617 3792K 2912 0.0 0.0 L5 1092/0 89.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1315/19 105.51 GB 0.0 27.0 13.5 13.5 36.4 22.9 10.0 3.8 162.9 219.4 169.71 140.15 237 0.716 27M 79K 0.0 0.0 Int 0/0 0.00 KB 0.0 27.0 13.5 13.5 36.4 22.9 10.0 3.8 162.9 219.4 169.71 140.15 237 0.716 27M 79K 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 27.0 13.5 13.5 26.8 13.4 0.0 0.0 197.9 196.8 139.65 115.01 100 1.396 27M 79K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.5 9.5 0.0 0.0 0.0 324.9 30.06 25.14 137 0.219 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 57.3 total, 57.2 interval Flush(GB): cumulative 9.536, interval 9.536 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 36.37 GB write, 649.40 MB/s write, 26.99 GB read, 482.00 MB/s read, 169.7 seconds Interval compaction: 36.37 GB write, 651.45 MB/s write, 26.99 GB read, 483.52 MB/s read, 169.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 24, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 24, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 50, pending-compaction-bytes-delays: 23, pending-compaction-bytes-stops: 0, total-delays: 47, total-stops: 50, interval: 97 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4074359 Average: 2.7909 StdDev: 22.89 Min: 0 Median: 1.5240 Max: 7451 Percentiles: P50: 1.52 P75: 1.91 P99: 6.88 P99.9: 128.82 P99.99: 442.57 ------------------------------------------------------ [ 0, 1 ] 667100 16.373% 16.373% ### ( 1, 2 ] 2614746 64.176% 80.549% ############# ( 2, 3 ] 464248 11.394% 91.943% ## ( 3, 4 ] 159918 3.925% 95.868% # ( 4, 6 ] 120584 2.960% 98.828% # ( 6, 10 ] 31814 0.781% 99.609% ( 10, 15 ] 5861 0.144% 99.752% ( 15, 22 ] 638 0.016% 99.768% ( 22, 34 ] 49 0.001% 99.769% ( 34, 51 ] 20 0.000% 99.770% ( 51, 76 ] 86 0.002% 99.772% ( 76, 110 ] 4274 0.105% 99.877% ( 110, 170 ] 3018 0.074% 99.951% ( 170, 250 ] 762 0.019% 99.970% ( 250, 380 ] 623 0.015% 99.985% ( 380, 580 ] 673 0.017% 100.001% ( 580, 870 ] 410 0.010% 100.011% ( 870, 1300 ] 209 0.005% 100.017% ( 1300, 1900 ] 92 0.002% 100.019% ( 1900, 2900 ] 62 0.002% 100.020% ( 2900, 4400 ] 52 0.001% 100.022% ( 4400, 6600 ] 3 0.000% 100.022% ( 6600, 9900 ] 1 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 2002971 Average: 4.4581 StdDev: 66.84 Min: 0 Median: 1.6604 Max: 10583 Percentiles: P50: 1.66 P75: 2.36 P99: 9.12 P99.9: 155.98 P99.99: 516.37 ------------------------------------------------------ [ 0, 1 ] 248311 12.397% 12.397% ## ( 1, 2 ] 1140554 56.943% 69.340% ########### ( 2, 3 ] 315424 15.748% 85.088% ### ( 3, 4 ] 127206 6.351% 91.439% # ( 4, 6 ] 121846 6.083% 97.522% # ( 6, 10 ] 37974 1.896% 99.418% ( 10, 15 ] 5633 0.281% 99.699% ( 15, 22 ] 768 0.038% 99.738% ( 22, 34 ] 40 0.002% 99.740% ( 34, 51 ] 18 0.001% 99.741% ( 51, 76 ] 214 0.011% 99.751% ( 76, 110 ] 1747 0.087% 99.838% ( 110, 170 ] 1609 0.080% 99.919% ( 170, 250 ] 454 0.023% 99.941% ( 250, 380 ] 552 0.028% 99.969% ( 380, 580 ] 617 0.031% 100.000% ( 580, 870 ] 567 0.028% 100.028% ( 870, 1300 ] 437 0.022% 100.050% ( 1300, 1900 ] 234 0.012% 100.062% ( 1900, 2900 ] 181 0.009% 100.071% ( 2900, 4400 ] 210 0.010% 100.081% ( 4400, 6600 ] 70 0.003% 100.085% ( 6600, 9900 ] 26 0.001% 100.086% ( 9900, 14000 ] 3 0.000% 100.086% ** Level 2 read latency histogram (micros): Count: 77383 Average: 2.6776 StdDev: 17.65 Min: 1 Median: 1.6108 Max: 3382 Percentiles: P50: 1.61 P75: 1.99 P99: 7.63 P99.9: 24.47 P99.99: 640.98 ------------------------------------------------------ [ 0, 1 ] 7521 9.719% 9.719% ## ( 1, 2 ] 51032 65.947% 75.666% ############# ( 2, 3 ] 11428 14.768% 90.435% ### ( 3, 4 ] 3315 4.284% 94.718% # ( 4, 6 ] 2910 3.761% 98.479% # ( 6, 10 ] 992 1.282% 99.761% ( 10, 15 ] 97 0.125% 99.886% ( 15, 22 ] 10 0.013% 99.899% ( 22, 34 ] 3 0.004% 99.903% ( 51, 76 ] 1 0.001% 99.904% ( 110, 170 ] 30 0.039% 99.943% ( 170, 250 ] 14 0.018% 99.961% ( 250, 380 ] 11 0.014% 99.975% ( 380, 580 ] 10 0.013% 99.988% ( 580, 870 ] 6 0.008% 99.996% ( 870, 1300 ] 1 0.001% 99.997% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1426338 Average: 5.4058 StdDev: 77.24 Min: 0 Median: 1.9873 Max: 10784 Percentiles: P50: 1.99 P75: 2.98 P99: 9.13 P99.9: 85.18 P99.99: 313.64 ------------------------------------------------------ [ 0, 1 ] 26150 1.833% 1.833% ( 1, 2 ] 695855 48.786% 50.619% ########## ( 2, 3 ] 356461 24.991% 75.611% ##### ( 3, 4 ] 152463 10.689% 86.300% ## ( 4, 6 ] 157794 11.063% 97.363% ## ( 6, 10 ] 29798 2.089% 99.452% ( 10, 15 ] 5584 0.391% 99.843% ( 15, 22 ] 608 0.043% 99.886% ( 22, 34 ] 68 0.005% 99.891% ( 34, 51 ] 25 0.002% 99.893% ( 51, 76 ] 39 0.003% 99.895% ( 76, 110 ] 247 0.017% 99.913% ( 110, 170 ] 446 0.031% 99.944% ( 170, 250 ] 370 0.026% 99.970% ( 250, 380 ] 587 0.041% 100.011% ( 380, 580 ] 581 0.041% 100.052% ( 580, 870 ] 554 0.039% 100.091% ( 870, 1300 ] 350 0.025% 100.115% ( 1300, 1900 ] 188 0.013% 100.128% ( 1900, 2900 ] 209 0.015% 100.143% ( 2900, 4400 ] 229 0.016% 100.159% ( 4400, 6600 ] 67 0.005% 100.164% ( 6600, 9900 ] 17 0.001% 100.165% ( 9900, 14000 ] 2 0.000% 100.165% ** Level 4 read latency histogram (micros): Count: 37811 Average: 91.4277 StdDev: 439.23 Min: 0 Median: 2.1418 Max: 10645 Percentiles: P50: 2.14 P75: 3.49 P99: 2360.63 P99.9: 5603.17 P99.99: 8117.48 ------------------------------------------------------ [ 0, 1 ] 834 2.206% 2.206% ( 1, 2 ] 16867 44.609% 46.814% ######### ( 2, 3 ] 8492 22.459% 69.273% #### ( 3, 4 ] 4445 11.756% 81.029% ## ( 4, 6 ] 2778 7.347% 88.376% # ( 6, 10 ] 943 2.494% 90.870% ( 10, 15 ] 178 0.471% 91.341% ( 15, 22 ] 21 0.056% 91.397% ( 22, 34 ] 9 0.024% 91.420% ( 34, 51 ] 1 0.003% 91.423% ( 76, 110 ] 79 0.209% 91.632% ( 110, 170 ] 210 0.555% 92.187% ( 170, 250 ] 280 0.741% 92.928% ( 250, 380 ] 360 0.952% 93.880% ( 380, 580 ] 557 1.473% 95.353% ( 580, 870 ] 554 1.465% 96.818% ( 870, 1300 ] 460 1.217% 98.035% ( 1300, 1900 ] 270 0.714% 98.749% ( 1900, 2900 ] 206 0.545% 99.294% ( 2900, 4400 ] 192 0.508% 99.802% ( 4400, 6600 ] 68 0.180% 99.981% ( 6600, 9900 ] 7 0.019% 100.000% ( 9900, 14000 ] 1 0.003% 100.003% ** Level 5 read latency histogram (micros): Count: 260 Average: 1148.7192 StdDev: 1205.66 Min: 81 Median: 660.5556 Max: 6072 Percentiles: P50: 660.56 P75: 1672.41 P99: 5170.00 P99.9: 6072.00 P99.99: 6072.00 ------------------------------------------------------ ( 76, 110 ] 15 5.769% 5.769% # ( 110, 170 ] 21 8.077% 13.846% ## ( 170, 250 ] 25 9.615% 23.462% ## ( 250, 380 ] 27 10.385% 33.846% ## ( 380, 580 ] 32 12.308% 46.154% ## ( 580, 870 ] 36 13.846% 60.000% ### ( 870, 1300 ] 21 8.077% 68.077% ## ( 1300, 1900 ] 29 11.154% 79.231% ## ( 1900, 2900 ] 24 9.231% 88.462% ## ( 2900, 4400 ] 26 10.000% 98.462% ## ( 4400, 6600 ] 4 1.538% 100.000% ** DB Stats ** Uptime(secs): 57.3 total, 4.3 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 171.62 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:29.179 H:M:S, 50.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 230.29 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.641 H:M:S, 38.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.729 micros/op 174553 ops/sec 60.005 seconds 10473999 operations; 169.1 MB/s Microseconds per write: Count: 10473999 Average: 5.7286 StdDev: 355.08 Min: 1 Median: 1.7539 Max: 505935 Percentiles: P50: 1.75 P75: 2.78 P99: 9.39 P99.9: 1128.87 P99.99: 2639.92 ------------------------------------------------------ [ 0, 1 ] 1331184 12.709% 12.709% ### ( 1, 2 ] 5180705 49.463% 62.172% ########## ( 2, 3 ] 1719658 16.418% 78.590% ### ( 3, 4 ] 1445654 13.802% 92.393% ### ( 4, 6 ] 581864 5.555% 97.948% # ( 6, 10 ] 129943 1.241% 99.189% ( 10, 15 ] 41874 0.400% 99.588% ( 15, 22 ] 9563 0.091% 99.680% ( 22, 34 ] 1747 0.017% 99.696% ( 34, 51 ] 201 0.002% 99.698% ( 51, 76 ] 36 0.000% 99.699% ( 76, 110 ] 7312 0.070% 99.768% ( 110, 170 ] 2825 0.027% 99.795% ( 170, 250 ] 296 0.003% 99.798% ( 250, 380 ] 187 0.002% 99.800% ( 380, 580 ] 25 0.000% 99.800% ( 580, 870 ] 36 0.000% 99.801% ( 870, 1300 ] 17300 0.165% 99.966% ( 1300, 1900 ] 71 0.001% 99.966% ( 1900, 2900 ] 3339 0.032% 99.998% ( 2900, 4400 ] 124 0.001% 99.999% ( 4400, 6600 ] 22 0.000% 100.000% ( 6600, 9900 ] 6 0.000% 100.000% ( 9900, 14000 ] 4 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 50000, 75000 ] 1 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 13 0.000% 100.000% ( 250000, 380000 ] 3 0.000% 100.000% ( 380000, 570000 ] 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 : 202301 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 : 10473999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10809166968 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 : 607 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 30722471 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 : 33110354096 rocksdb.compact.write.bytes COUNT : 32893826934 rocksdb.flush.write.bytes COUNT : 10635175919 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 : 60 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 : 265 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 : 10549423104 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4097024 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 : 33213725034 rocksdb.non.last.level.read.count COUNT : 8022283 rocksdb.block.checksum.compute.count COUNT : 8021129 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.388985 P95 : 3.932882 P99 : 7.975286 P100 : 505932.000000 COUNT : 10473999 SUM : 54921008 rocksdb.compaction.times.micros P50 : 923750.000000 P95 : 4253333.333333 P99 : 17920000.000000 P100 : 20405016.000000 COUNT : 102 SUM : 155692225 rocksdb.compaction.times.cpu_micros P50 : 802000.000000 P95 : 3530000.000000 P99 : 13958000.000000 P100 : 18705171.000000 COUNT : 102 SUM : 128619726 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 : 692.965116 P95 : 1294.625000 P99 : 10505.000000 P100 : 10505.000000 COUNT : 143 SUM : 130789 rocksdb.compaction.outfile.sync.micros P50 : 1123.316832 P95 : 102513.888889 P99 : 237066.666667 P100 : 270085.000000 COUNT : 397 SUM : 7256136 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 : 102.890909 P95 : 1345.000000 P99 : 4030.000000 P100 : 5785.000000 COUNT : 274 SUM : 85053 rocksdb.table.open.io.micros P50 : 1471.875000 P95 : 7239.375000 P99 : 11737.545455 P100 : 11959.000000 COUNT : 607 SUM : 1245543 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.692423 P95 : 8.024395 P99 : 11.600275 P100 : 10790.000000 COUNT : 8019704 SUM : 50810443 rocksdb.read.block.get.micros P50 : 466.330935 P95 : 3177.868852 P99 : 4371.967213 P100 : 6652.000000 COUNT : 1214 SUM : 1015248 rocksdb.write.raw.block.micros P50 : 0.513675 P95 : 0.975982 P99 : 2.973083 P100 : 26301.000000 COUNT : 10555098 SUM : 21279539 rocksdb.numfiles.in.singlecompaction P50 : 3.037313 P95 : 6.200000 P99 : 20.075000 P100 : 26.000000 COUNT : 155 SUM : 551 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.562409 P95 : 1152.326886 P99 : 2369.239327 P100 : 505750.000000 COUNT : 188731 SUM : 30742665 rocksdb.sst.read.micros P50 : 1.631406 P95 : 4.840564 P99 : 8.756876 P100 : 10784.000000 COUNT : 8022953 SUM : 34284353 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 : 10473999 SUM : 10809166968 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 : 214485.981308 P95 : 371694.444444 P99 : 652650.000000 P100 : 699069.000000 COUNT : 143 SUM : 31154697 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 : 375 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