[2024-11-28 14:18:25.109289] Starting SPDK v25.01-pre git sha1 35cd3e84d / DPDK 23.11.0 initialization... [2024-11-28 14:18:25.109580] [ 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_pid1963152 ] Set seed to 1732799905102475 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-28 14:18:25.225464] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-28 14:18:25.246595] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-28 14:18:25.246641] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1963152' to capture a snapshot of events at runtime. [2024-11-28 14:18:25.246651] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-28 14:18:25.246678] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-28 14:18:25.246686] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1963152 for offline analysis/debug. [2024-11-28 14:18:25.247223] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Thu Nov 28 14:18:29 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/28-14:18:32 ... thread 0: (1000000,1000000) ops and (357751.8,357751.8) ops/second in (2.795234,2.795234) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/6 566.97 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 351.1 2.33 2.11 12 0.194 0 0 0.0 0.0 L2 3/2 251.74 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.1 2.0 248.3 248.1 1.52 1.46 2 0.761 383K 201 0.0 0.0 L3 9/0 741.20 MB 0.7 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.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 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 1181/8 96.94 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.8 1.5 98.0 310.4 3.85 3.58 14 0.275 383K 201 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.7 1.5 98.0 310.4 3.85 3.58 14 0.275 383K 201 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.0 0.0 248.3 248.1 1.52 1.46 2 0.761 383K 201 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 351.1 2.33 2.11 12 0.194 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.17 GB write, 395.84 MB/s write, 0.37 GB read, 125.01 MB/s read, 3.9 seconds Interval compaction: 1.17 GB write, 427.83 MB/s write, 0.37 GB read, 135.11 MB/s read, 3.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 1, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 1, interval: 1 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 99825 Average: 1.8228 StdDev: 15.27 Min: 1 Median: 1.1764 Max: 3024 Percentiles: P50: 1.18 P75: 1.63 P99: 3.72 P99.9: 9.27 P99.99: 337.05 ------------------------------------------------------ [ 0, 1 ] 40232 40.303% 40.303% ######## ( 1, 2 ] 54891 54.987% 95.290% ########### ( 2, 3 ] 2981 2.986% 98.276% # ( 3, 4 ] 1004 1.006% 99.282% ( 4, 6 ] 488 0.489% 99.771% ( 6, 10 ] 158 0.158% 99.929% ( 10, 15 ] 34 0.034% 99.963% ( 15, 22 ] 12 0.012% 99.975% ( 34, 51 ] 1 0.001% 99.976% ( 110, 170 ] 7 0.007% 99.983% ( 170, 250 ] 3 0.003% 99.986% ( 250, 380 ] 6 0.006% 99.992% ( 380, 580 ] 2 0.002% 99.994% ( 580, 870 ] 2 0.002% 99.996% ( 870, 1300 ] 1 0.001% 99.997% ( 1300, 1900 ] 1 0.001% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 50677 Average: 2.0567 StdDev: 23.03 Min: 1 Median: 1.2370 Max: 2926 Percentiles: P50: 1.24 P75: 1.67 P99: 4.27 P99.9: 9.57 P99.99: 1270.89 ------------------------------------------------------ [ 0, 1 ] 18394 36.297% 36.297% ####### ( 1, 2 ] 29301 57.819% 94.116% ############ ( 2, 3 ] 1716 3.386% 97.502% # ( 3, 4 ] 707 1.395% 98.897% ( 4, 6 ] 396 0.781% 99.678% ( 6, 10 ] 127 0.251% 99.929% ( 10, 15 ] 13 0.026% 99.955% ( 15, 22 ] 5 0.010% 99.964% ( 22, 34 ] 1 0.002% 99.966% ( 51, 76 ] 2 0.004% 99.970% ( 170, 250 ] 1 0.002% 99.972% ( 250, 380 ] 2 0.004% 99.976% ( 380, 580 ] 5 0.010% 99.986% ( 580, 870 ] 2 0.004% 99.990% ( 870, 1300 ] 1 0.002% 99.992% ( 1300, 1900 ] 3 0.006% 99.998% ( 2900, 4400 ] 2 0.004% 100.002% ** Level 3 read latency histogram (micros): Count: 55 Average: 1635.7273 StdDev: 1346.10 Min: 182 Median: 1180.5556 Max: 5164 Percentiles: P50: 1180.56 P75: 2286.36 P99: 5164.00 P99.9: 5164.00 P99.99: 5164.00 ------------------------------------------------------ ( 170, 250 ] 5 9.091% 9.091% ## ( 250, 380 ] 2 3.636% 12.727% # ( 380, 580 ] 5 9.091% 21.818% ## ( 580, 870 ] 9 16.364% 38.182% ### ( 870, 1300 ] 9 16.364% 54.545% ### ( 1300, 1900 ] 7 12.727% 67.273% ### ( 1900, 2900 ] 11 20.000% 87.273% #### ( 2900, 4400 ] 3 5.455% 92.727% # ( 4400, 6600 ] 4 7.273% 100.000% # ** Level 4 read latency histogram (micros): Count: 15 Average: 1811.6000 StdDev: 1367.54 Min: 603 Median: 1228.3333 Max: 4721 Percentiles: P50: 1228.33 P75: 2525.00 P99: 4721.00 P99.9: 4721.00 P99.99: 4721.00 ------------------------------------------------------ ( 580, 870 ] 5 33.333% 33.333% ####### ( 870, 1300 ] 3 20.000% 53.333% #### ( 1300, 1900 ] 2 13.333% 66.667% ### ( 1900, 2900 ] 2 13.333% 80.000% ### ( 2900, 4400 ] 1 6.667% 86.667% # ( 4400, 6600 ] 2 13.333% 100.000% ### ** Level 5 read latency histogram (micros): Count: 20 Average: 529.3000 StdDev: 659.13 Min: 78 Median: 130.0000 Max: 1896 Percentiles: P50: 130.00 P75: 580.00 P99: 1870.00 P99.9: 1896.00 P99.99: 1896.00 ------------------------------------------------------ ( 76, 110 ] 9 45.000% 45.000% ######### ( 110, 170 ] 3 15.000% 60.000% ### ( 250, 380 ] 1 5.000% 65.000% # ( 380, 580 ] 2 10.000% 75.000% ## ( 870, 1300 ] 1 5.000% 80.000% # ( 1300, 1900 ] 4 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 325.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.216 H:M:S, 7.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 351.78 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.216 H:M:S, 7.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/28-14:18:35 ... thread 0: (1000000,2000000) ops and (322350.4,339129.7) ops/second in (3.102214,5.897448) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/6 1.17 GB 12.6 0.8 0.0 0.8 2.6 1.8 0.0 1.4 97.9 316.3 8.36 7.76 29 0.288 831K 881 0.0 0.0 L1 1/1 2.78 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 238.8 238.3 1.58 1.54 1 1.583 383K 615 0.0 0.0 L2 2/0 54.55 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 248.3 248.1 1.52 1.46 2 0.761 383K 201 0.0 0.0 L3 42/0 999.60 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 205.6 205.3 3.87 3.42 3 1.292 808K 813 0.0 0.0 L4 144/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1245/7 97.92 GB 0.0 2.3 1.1 1.2 4.1 2.9 2.1 2.3 154.6 273.5 15.34 14.18 35 0.438 2407K 2510 0.0 0.0 Int 0/0 0.00 KB 0.0 2.3 1.1 1.2 4.1 2.9 2.0 2.3 154.6 273.5 15.34 14.18 35 0.438 2407K 2510 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 2.3 1.1 1.2 2.3 1.1 0.0 0.0 233.6 233.3 10.15 9.53 9 1.128 2407K 2510 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.8 1.8 0.0 0.0 0.0 351.9 5.19 4.65 26 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.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: 4.10 GB write, 684.97 MB/s write, 2.32 GB read, 387.14 MB/s read, 15.3 seconds Interval compaction: 4.10 GB write, 711.21 MB/s write, 2.32 GB read, 401.97 MB/s read, 15.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: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 385451 Average: 2.1445 StdDev: 13.42 Min: 0 Median: 1.4427 Max: 4881 Percentiles: P50: 1.44 P75: 1.84 P99: 5.61 P99.9: 10.09 P99.99: 16.41 ------------------------------------------------------ [ 0, 1 ] 85249 22.117% 22.117% #### ( 1, 2 ] 242800 62.991% 85.108% ############# ( 2, 3 ] 32795 8.508% 93.616% ## ( 3, 4 ] 14031 3.640% 97.256% # ( 4, 6 ] 8352 2.167% 99.423% ( 6, 10 ] 1832 0.475% 99.898% ( 10, 15 ] 345 0.090% 99.988% ( 15, 22 ] 42 0.011% 99.999% ( 22, 34 ] 7 0.002% 100.001% ( 34, 51 ] 5 0.001% 100.002% ( 51, 76 ] 2 0.001% 100.002% ( 110, 170 ] 12 0.003% 100.005% ( 170, 250 ] 11 0.003% 100.008% ( 250, 380 ] 11 0.003% 100.011% ( 380, 580 ] 5 0.001% 100.012% ( 580, 870 ] 7 0.002% 100.014% ( 870, 1300 ] 6 0.002% 100.016% ( 1300, 1900 ] 2 0.001% 100.016% ( 1900, 2900 ] 1 0.000% 100.017% ( 2900, 4400 ] 2 0.001% 100.017% ( 4400, 6600 ] 1 0.000% 100.017% ** Level 1 read latency histogram (micros): Count: 81699 Average: 2.4387 StdDev: 7.77 Min: 1 Median: 1.6460 Max: 1833 Percentiles: P50: 1.65 P75: 2.10 P99: 5.87 P99.9: 12.07 P99.99: 17.52 ------------------------------------------------------ [ 0, 1 ] 6090 7.454% 7.454% # ( 1, 2 ] 53808 65.861% 73.315% ############# ( 2, 3 ] 13119 16.058% 89.373% ### ( 3, 4 ] 4639 5.678% 95.051% # ( 4, 6 ] 3455 4.229% 99.280% # ( 6, 10 ] 459 0.562% 99.842% ( 10, 15 ] 114 0.140% 99.982% ( 15, 22 ] 19 0.023% 100.005% ( 110, 170 ] 1 0.001% 100.006% ( 170, 250 ] 3 0.004% 100.010% ( 250, 380 ] 2 0.002% 100.012% ( 870, 1300 ] 1 0.001% 100.013% ( 1300, 1900 ] 1 0.001% 100.015% ** Level 2 read latency histogram (micros): Count: 95443 Average: 2.1113 StdDev: 16.79 Min: 1 Median: 1.3901 Max: 2926 Percentiles: P50: 1.39 P75: 1.78 P99: 5.25 P99.9: 9.87 P99.99: 518.23 ------------------------------------------------------ [ 0, 1 ] 24102 25.253% 25.253% ##### ( 1, 2 ] 60549 63.440% 88.693% ############# ( 2, 3 ] 6265 6.564% 95.257% # ( 3, 4 ] 2653 2.780% 98.037% # ( 4, 6 ] 1472 1.542% 99.579% ( 6, 10 ] 317 0.332% 99.911% ( 10, 15 ] 57 0.060% 99.971% ( 15, 22 ] 8 0.008% 99.979% ( 22, 34 ] 2 0.002% 99.981% ( 51, 76 ] 2 0.002% 99.983% ( 170, 250 ] 1 0.001% 99.984% ( 250, 380 ] 2 0.002% 99.986% ( 380, 580 ] 5 0.005% 99.992% ( 580, 870 ] 2 0.002% 99.994% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 3 0.003% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 57425 Average: 4.0460 StdDev: 65.81 Min: 0 Median: 1.6424 Max: 5164 Percentiles: P50: 1.64 P75: 2.10 P99: 5.98 P99.9: 163.63 P99.99: 2014.32 ------------------------------------------------------ [ 0, 1 ] 4494 7.826% 7.826% ## ( 1, 2 ] 37702 65.654% 73.480% ############# ( 2, 3 ] 9041 15.744% 89.224% ### ( 3, 4 ] 3312 5.768% 94.992% # ( 4, 6 ] 2326 4.051% 99.042% # ( 6, 10 ] 342 0.596% 99.638% ( 10, 15 ] 101 0.176% 99.814% ( 15, 22 ] 18 0.031% 99.845% ( 22, 34 ] 25 0.044% 99.889% ( 34, 51 ] 3 0.005% 99.894% ( 110, 170 ] 4 0.007% 99.901% ( 170, 250 ] 12 0.021% 99.922% ( 250, 380 ] 5 0.009% 99.930% ( 380, 580 ] 7 0.012% 99.943% ( 580, 870 ] 9 0.016% 99.958% ( 870, 1300 ] 10 0.017% 99.976% ( 1300, 1900 ] 7 0.012% 99.988% ( 1900, 2900 ] 11 0.019% 100.007% ( 2900, 4400 ] 3 0.005% 100.012% ( 4400, 6600 ] 4 0.007% 100.019% ** Level 4 read latency histogram (micros): Count: 15 Average: 1811.6000 StdDev: 1367.54 Min: 603 Median: 1228.3333 Max: 4721 Percentiles: P50: 1228.33 P75: 2525.00 P99: 4721.00 P99.9: 4721.00 P99.99: 4721.00 ------------------------------------------------------ ( 580, 870 ] 5 33.333% 33.333% ####### ( 870, 1300 ] 3 20.000% 53.333% #### ( 1300, 1900 ] 2 13.333% 66.667% ### ( 1900, 2900 ] 2 13.333% 80.000% ### ( 2900, 4400 ] 1 6.667% 86.667% # ( 4400, 6600 ] 2 13.333% 100.000% ### ** Level 5 read latency histogram (micros): Count: 40 Average: 568.2750 StdDev: 661.37 Min: 78 Median: 158.0000 Max: 1950 Percentiles: P50: 158.00 P75: 1013.33 P99: 1950.00 P99.9: 1950.00 P99.99: 1950.00 ------------------------------------------------------ ( 76, 110 ] 12 30.000% 30.000% ###### ( 110, 170 ] 10 25.000% 55.000% ##### ( 170, 250 ] 2 5.000% 60.000% # ( 250, 380 ] 1 2.500% 62.500% # ( 380, 580 ] 4 10.000% 72.500% ## ( 870, 1300 ] 3 7.500% 80.000% ## ( 1300, 1900 ] 6 15.000% 95.000% ### ( 1900, 2900 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 6.1 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 321.34 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.662 H:M:S, 10.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 317.25 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.446 H:M:S, 14.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/28-14:18:38 ... thread 0: (1000000,3000000) ops and (327780.9,335260.5) ops/second in (3.050818,8.948266) 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/14 2.15 GB 56.6 1.4 0.0 1.4 4.1 2.8 0.0 1.5 103.8 316.0 13.35 12.42 45 0.297 1407K 1484 0.0 0.0 L1 1/1 2.78 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 238.8 238.3 1.58 1.54 1 1.583 383K 615 0.0 0.0 L2 2/0 54.55 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 248.3 248.1 1.52 1.46 2 0.761 383K 201 0.0 0.0 L3 42/0 999.60 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 205.6 205.3 3.87 3.42 3 1.292 808K 813 0.0 0.0 L4 144/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1253/15 98.90 GB 0.0 2.9 1.1 1.8 5.6 3.9 2.1 2.0 144.5 283.8 20.33 18.84 51 0.399 2983K 3113 0.0 0.0 Int 0/0 0.00 KB 0.0 2.9 1.1 1.8 5.6 3.9 2.0 2.0 144.5 283.8 20.33 18.84 51 0.399 2983K 3113 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 2.9 1.1 1.8 2.9 1.1 0.0 0.0 239.0 238.7 12.29 11.64 11 1.118 2983K 3113 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 352.8 8.04 7.20 40 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.2 total, 9.0 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.63 GB write, 628.79 MB/s write, 2.87 GB read, 320.21 MB/s read, 20.3 seconds Interval compaction: 5.63 GB write, 644.67 MB/s write, 2.87 GB read, 328.30 MB/s read, 20.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: 8, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 8, interval: 8 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 769340 Average: 2.1416 StdDev: 10.89 Min: 0 Median: 1.4673 Max: 4881 Percentiles: P50: 1.47 P75: 1.85 P99: 5.54 P99.9: 9.89 P99.99: 14.27 ------------------------------------------------------ [ 0, 1 ] 149152 19.387% 19.387% #### ( 1, 2 ] 503983 65.508% 84.895% ############# ( 2, 3 ] 70466 9.159% 94.055% ## ( 3, 4 ] 26523 3.448% 97.502% # ( 4, 6 ] 14952 1.943% 99.446% ( 6, 10 ] 3597 0.468% 99.913% ( 10, 15 ] 696 0.090% 100.004% ( 15, 22 ] 75 0.010% 100.014% ( 22, 34 ] 16 0.002% 100.016% ( 34, 51 ] 8 0.001% 100.017% ( 51, 76 ] 7 0.001% 100.018% ( 110, 170 ] 17 0.002% 100.020% ( 170, 250 ] 18 0.002% 100.022% ( 250, 380 ] 16 0.002% 100.024% ( 380, 580 ] 8 0.001% 100.025% ( 580, 870 ] 12 0.002% 100.027% ( 870, 1300 ] 9 0.001% 100.028% ( 1300, 1900 ] 5 0.001% 100.029% ( 1900, 2900 ] 2 0.000% 100.029% ( 2900, 4400 ] 2 0.000% 100.029% ( 4400, 6600 ] 1 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 81699 Average: 2.4387 StdDev: 7.77 Min: 1 Median: 1.6460 Max: 1833 Percentiles: P50: 1.65 P75: 2.10 P99: 5.87 P99.9: 12.07 P99.99: 17.52 ------------------------------------------------------ [ 0, 1 ] 6090 7.454% 7.454% # ( 1, 2 ] 53808 65.861% 73.315% ############# ( 2, 3 ] 13119 16.058% 89.373% ### ( 3, 4 ] 4639 5.678% 95.051% # ( 4, 6 ] 3455 4.229% 99.280% # ( 6, 10 ] 459 0.562% 99.842% ( 10, 15 ] 114 0.140% 99.982% ( 15, 22 ] 19 0.023% 100.005% ( 110, 170 ] 1 0.001% 100.006% ( 170, 250 ] 3 0.004% 100.010% ( 250, 380 ] 2 0.002% 100.012% ( 870, 1300 ] 1 0.001% 100.013% ( 1300, 1900 ] 1 0.001% 100.015% ** Level 2 read latency histogram (micros): Count: 95443 Average: 2.1113 StdDev: 16.79 Min: 1 Median: 1.3901 Max: 2926 Percentiles: P50: 1.39 P75: 1.78 P99: 5.25 P99.9: 9.87 P99.99: 518.23 ------------------------------------------------------ [ 0, 1 ] 24102 25.253% 25.253% ##### ( 1, 2 ] 60549 63.440% 88.693% ############# ( 2, 3 ] 6265 6.564% 95.257% # ( 3, 4 ] 2653 2.780% 98.037% # ( 4, 6 ] 1472 1.542% 99.579% ( 6, 10 ] 317 0.332% 99.911% ( 10, 15 ] 57 0.060% 99.971% ( 15, 22 ] 8 0.008% 99.979% ( 22, 34 ] 2 0.002% 99.981% ( 51, 76 ] 2 0.002% 99.983% ( 170, 250 ] 1 0.001% 99.984% ( 250, 380 ] 2 0.002% 99.986% ( 380, 580 ] 5 0.005% 99.992% ( 580, 870 ] 2 0.002% 99.994% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 3 0.003% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 57425 Average: 4.0460 StdDev: 65.81 Min: 0 Median: 1.6424 Max: 5164 Percentiles: P50: 1.64 P75: 2.10 P99: 5.98 P99.9: 163.63 P99.99: 2014.32 ------------------------------------------------------ [ 0, 1 ] 4494 7.826% 7.826% ## ( 1, 2 ] 37702 65.654% 73.480% ############# ( 2, 3 ] 9041 15.744% 89.224% ### ( 3, 4 ] 3312 5.768% 94.992% # ( 4, 6 ] 2326 4.051% 99.042% # ( 6, 10 ] 342 0.596% 99.638% ( 10, 15 ] 101 0.176% 99.814% ( 15, 22 ] 18 0.031% 99.845% ( 22, 34 ] 25 0.044% 99.889% ( 34, 51 ] 3 0.005% 99.894% ( 110, 170 ] 4 0.007% 99.901% ( 170, 250 ] 12 0.021% 99.922% ( 250, 380 ] 5 0.009% 99.930% ( 380, 580 ] 7 0.012% 99.943% ( 580, 870 ] 9 0.016% 99.958% ( 870, 1300 ] 10 0.017% 99.976% ( 1300, 1900 ] 7 0.012% 99.988% ( 1900, 2900 ] 11 0.019% 100.007% ( 2900, 4400 ] 3 0.005% 100.012% ( 4400, 6600 ] 4 0.007% 100.019% ** Level 4 read latency histogram (micros): Count: 15 Average: 1811.6000 StdDev: 1367.54 Min: 603 Median: 1228.3333 Max: 4721 Percentiles: P50: 1228.33 P75: 2525.00 P99: 4721.00 P99.9: 4721.00 P99.99: 4721.00 ------------------------------------------------------ ( 580, 870 ] 5 33.333% 33.333% ####### ( 870, 1300 ] 3 20.000% 53.333% #### ( 1300, 1900 ] 2 13.333% 66.667% ### ( 1900, 2900 ] 2 13.333% 80.000% ### ( 2900, 4400 ] 1 6.667% 86.667% # ( 4400, 6600 ] 2 13.333% 100.000% ### ** Level 5 read latency histogram (micros): Count: 40 Average: 568.2750 StdDev: 661.37 Min: 78 Median: 158.0000 Max: 1950 Percentiles: P50: 158.00 P75: 1013.33 P99: 1950.00 P99.9: 1950.00 P99.99: 1950.00 ------------------------------------------------------ ( 76, 110 ] 12 30.000% 30.000% ###### ( 110, 170 ] 10 25.000% 55.000% ##### ( 170, 250 ] 2 5.000% 60.000% # ( 250, 380 ] 1 2.500% 62.500% # ( 380, 580 ] 4 10.000% 72.500% ## ( 870, 1300 ] 3 7.500% 80.000% ## ( 1300, 1900 ] 6 15.000% 95.000% ### ( 1900, 2900 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 9.2 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 321.76 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.085 H:M:S, 11.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 322.60 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.423 H:M:S, 13.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/28-14:18:41 ... thread 0: (1000000,4000000) ops and (330063.7,333946.0) ops/second in (3.029718,11.977984) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/10 2.03 GB 6.3 2.5 0.0 2.5 6.1 3.7 0.0 1.7 123.6 308.8 20.39 19.08 62 0.329 2558K 2693 0.0 0.0 L1 9/9 1.04 GB 0.0 1.4 1.4 0.0 1.4 1.4 0.2 1.0 237.8 236.9 6.10 5.96 2 3.051 1473K 5163 0.0 0.0 L2 2/0 54.55 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 248.3 248.1 1.52 1.46 2 0.761 383K 201 0.0 0.0 L3 42/0 999.60 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 205.6 205.3 3.87 3.42 3 1.292 808K 813 0.0 0.0 L4 144/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1256/19 99.82 GB 0.0 5.0 2.2 2.9 8.7 5.8 2.1 2.4 161.3 279.6 31.89 29.92 69 0.462 5224K 8870 0.0 0.0 Int 0/0 0.00 KB 0.0 5.0 2.2 2.9 8.7 5.8 2.0 2.4 161.3 279.6 31.89 29.92 69 0.462 5224K 8870 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.0 2.2 2.9 5.0 2.1 0.0 0.0 243.2 242.7 21.16 20.32 16 1.322 5224K 8870 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 352.2 10.73 9.61 53 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): 12.2 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.71 GB write, 730.43 MB/s write, 5.02 GB read, 421.52 MB/s read, 31.9 seconds Interval compaction: 8.71 GB write, 744.21 MB/s write, 5.02 GB read, 429.47 MB/s read, 31.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 12, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 12, interval: 12 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1081261 Average: 2.1297 StdDev: 10.48 Min: 0 Median: 1.4621 Max: 4881 Percentiles: P50: 1.46 P75: 1.84 P99: 5.49 P99.9: 9.93 P99.99: 14.20 ------------------------------------------------------ [ 0, 1 ] 213759 19.769% 19.769% #### ( 1, 2 ] 707306 65.415% 85.184% ############# ( 2, 3 ] 98663 9.125% 94.309% ## ( 3, 4 ] 35856 3.316% 97.625% # ( 4, 6 ] 20015 1.851% 99.476% ( 6, 10 ] 4667 0.432% 99.908% ( 10, 15 ] 1057 0.098% 100.006% ( 15, 22 ] 103 0.010% 100.015% ( 22, 34 ] 18 0.002% 100.017% ( 34, 51 ] 10 0.001% 100.018% ( 51, 76 ] 10 0.001% 100.019% ( 110, 170 ] 24 0.002% 100.021% ( 170, 250 ] 24 0.002% 100.023% ( 250, 380 ] 20 0.002% 100.025% ( 380, 580 ] 12 0.001% 100.026% ( 580, 870 ] 15 0.001% 100.028% ( 870, 1300 ] 14 0.001% 100.029% ( 1300, 1900 ] 8 0.001% 100.030% ( 1900, 2900 ] 4 0.000% 100.030% ( 2900, 4400 ] 2 0.000% 100.030% ( 4400, 6600 ] 1 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 88025 Average: 2.5388 StdDev: 14.32 Min: 0 Median: 1.6210 Max: 1833 Percentiles: P50: 1.62 P75: 2.02 P99: 5.87 P99.9: 12.75 P99.99: 255.13 ------------------------------------------------------ [ 0, 1 ] 8453 9.603% 9.603% ## ( 1, 2 ] 57264 65.054% 74.657% ############# ( 2, 3 ] 13377 15.197% 89.854% ### ( 3, 4 ] 4765 5.413% 95.267% # ( 4, 6 ] 3523 4.002% 99.270% # ( 6, 10 ] 490 0.557% 99.826% ( 10, 15 ] 120 0.136% 99.963% ( 15, 22 ] 20 0.023% 99.985% ( 110, 170 ] 2 0.002% 99.988% ( 170, 250 ] 3 0.003% 99.991% ( 250, 380 ] 5 0.006% 99.997% ( 380, 580 ] 6 0.007% 100.003% ( 580, 870 ] 2 0.002% 100.006% ( 870, 1300 ] 4 0.005% 100.010% ( 1300, 1900 ] 4 0.005% 100.015% ** Level 2 read latency histogram (micros): Count: 95443 Average: 2.1113 StdDev: 16.79 Min: 1 Median: 1.3901 Max: 2926 Percentiles: P50: 1.39 P75: 1.78 P99: 5.25 P99.9: 9.87 P99.99: 518.23 ------------------------------------------------------ [ 0, 1 ] 24102 25.253% 25.253% ##### ( 1, 2 ] 60549 63.440% 88.693% ############# ( 2, 3 ] 6265 6.564% 95.257% # ( 3, 4 ] 2653 2.780% 98.037% # ( 4, 6 ] 1472 1.542% 99.579% ( 6, 10 ] 317 0.332% 99.911% ( 10, 15 ] 57 0.060% 99.971% ( 15, 22 ] 8 0.008% 99.979% ( 22, 34 ] 2 0.002% 99.981% ( 51, 76 ] 2 0.002% 99.983% ( 170, 250 ] 1 0.001% 99.984% ( 250, 380 ] 2 0.002% 99.986% ( 380, 580 ] 5 0.005% 99.992% ( 580, 870 ] 2 0.002% 99.994% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 3 0.003% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 57425 Average: 4.0460 StdDev: 65.81 Min: 0 Median: 1.6424 Max: 5164 Percentiles: P50: 1.64 P75: 2.10 P99: 5.98 P99.9: 163.63 P99.99: 2014.32 ------------------------------------------------------ [ 0, 1 ] 4494 7.826% 7.826% ## ( 1, 2 ] 37702 65.654% 73.480% ############# ( 2, 3 ] 9041 15.744% 89.224% ### ( 3, 4 ] 3312 5.768% 94.992% # ( 4, 6 ] 2326 4.051% 99.042% # ( 6, 10 ] 342 0.596% 99.638% ( 10, 15 ] 101 0.176% 99.814% ( 15, 22 ] 18 0.031% 99.845% ( 22, 34 ] 25 0.044% 99.889% ( 34, 51 ] 3 0.005% 99.894% ( 110, 170 ] 4 0.007% 99.901% ( 170, 250 ] 12 0.021% 99.922% ( 250, 380 ] 5 0.009% 99.930% ( 380, 580 ] 7 0.012% 99.943% ( 580, 870 ] 9 0.016% 99.958% ( 870, 1300 ] 10 0.017% 99.976% ( 1300, 1900 ] 7 0.012% 99.988% ( 1900, 2900 ] 11 0.019% 100.007% ( 2900, 4400 ] 3 0.005% 100.012% ( 4400, 6600 ] 4 0.007% 100.019% ** Level 4 read latency histogram (micros): Count: 15 Average: 1811.6000 StdDev: 1367.54 Min: 603 Median: 1228.3333 Max: 4721 Percentiles: P50: 1228.33 P75: 2525.00 P99: 4721.00 P99.9: 4721.00 P99.99: 4721.00 ------------------------------------------------------ ( 580, 870 ] 5 33.333% 33.333% ####### ( 870, 1300 ] 3 20.000% 53.333% #### ( 1300, 1900 ] 2 13.333% 66.667% ### ( 1900, 2900 ] 2 13.333% 80.000% ### ( 2900, 4400 ] 1 6.667% 86.667% # ( 4400, 6600 ] 2 13.333% 100.000% ### ** Level 5 read latency histogram (micros): Count: 40 Average: 568.2750 StdDev: 661.37 Min: 78 Median: 158.0000 Max: 1950 Percentiles: P50: 158.00 P75: 1013.33 P99: 1950.00 P99.9: 1950.00 P99.99: 1950.00 ------------------------------------------------------ ( 76, 110 ] 12 30.000% 30.000% ###### ( 110, 170 ] 10 25.000% 55.000% ##### ( 170, 250 ] 2 5.000% 60.000% # ( 250, 380 ] 1 2.500% 62.500% # ( 380, 580 ] 4 10.000% 72.500% ## ( 870, 1300 ] 3 7.500% 80.000% ## ( 1300, 1900 ] 6 15.000% 95.000% ### ( 1900, 2900 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 12.2 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 322.53 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.501 H:M:S, 12.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.85 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.416 H:M:S, 13.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/28-14:18:44 ... thread 0: (1000000,5000000) ops and (318371.7,330710.4) ops/second in (3.140983,15.118967) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/14 3.07 GB 81.8 3.3 0.0 3.3 8.0 4.7 0.0 1.7 126.2 309.3 26.46 24.78 80 0.331 3390K 3546 0.0 0.0 L1 9/9 1.04 GB 0.0 1.4 1.4 0.0 1.4 1.4 0.2 1.0 237.8 236.9 6.10 5.96 2 3.051 1473K 5163 0.0 0.0 L2 2/0 54.55 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 248.3 248.1 1.52 1.46 2 0.761 383K 201 0.0 0.0 L3 42/0 999.60 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 205.6 205.3 3.87 3.42 3 1.292 808K 813 0.0 0.0 L4 144/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1262/23 100.86 GB 0.0 5.8 2.2 3.7 10.6 6.9 2.1 2.2 157.1 284.6 37.96 35.62 87 0.436 6055K 9723 0.0 0.0 Int 0/0 0.00 KB 0.0 5.8 2.2 3.7 10.6 6.9 2.0 2.2 157.1 284.6 37.96 35.62 87 0.436 6055K 9723 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 2.2 3.7 5.8 2.1 0.0 0.0 246.0 245.6 24.24 23.34 19 1.276 6055K 9723 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 353.6 13.72 12.28 68 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): 15.3 total, 15.1 interval Flush(GB): cumulative 4.737, interval 4.737 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.55 GB write, 704.02 MB/s write, 5.82 GB read, 388.61 MB/s read, 38.0 seconds Interval compaction: 10.55 GB write, 714.55 MB/s write, 5.82 GB read, 394.42 MB/s read, 38.0 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: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 15, interval: 18 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1407288 Average: 2.1599 StdDev: 10.87 Min: 0 Median: 1.4726 Max: 4881 Percentiles: P50: 1.47 P75: 1.85 P99: 5.49 P99.9: 9.94 P99.99: 14.37 ------------------------------------------------------ [ 0, 1 ] 265054 18.834% 18.834% #### ( 1, 2 ] 927977 65.941% 84.775% ############# ( 2, 3 ] 133501 9.486% 94.262% ## ( 3, 4 ] 47258 3.358% 97.620% # ( 4, 6 ] 26086 1.854% 99.473% ( 6, 10 ] 6101 0.434% 99.907% ( 10, 15 ] 1340 0.095% 100.002% ( 15, 22 ] 129 0.009% 100.011% ( 22, 34 ] 21 0.001% 100.013% ( 34, 51 ] 11 0.001% 100.014% ( 51, 76 ] 13 0.001% 100.014% ( 76, 110 ] 48 0.003% 100.018% ( 110, 170 ] 50 0.004% 100.021% ( 170, 250 ] 49 0.003% 100.025% ( 250, 380 ] 36 0.003% 100.027% ( 380, 580 ] 21 0.001% 100.029% ( 580, 870 ] 20 0.001% 100.030% ( 870, 1300 ] 22 0.002% 100.032% ( 1300, 1900 ] 12 0.001% 100.033% ( 1900, 2900 ] 6 0.000% 100.033% ( 2900, 4400 ] 3 0.000% 100.033% ( 4400, 6600 ] 1 0.000% 100.033% ** Level 1 read latency histogram (micros): Count: 150183 Average: 2.5881 StdDev: 13.35 Min: 0 Median: 1.5767 Max: 1833 Percentiles: P50: 1.58 P75: 1.96 P99: 7.02 P99.9: 90.00 P99.99: 461.65 ------------------------------------------------------ [ 0, 1 ] 18199 12.118% 12.118% ## ( 1, 2 ] 98648 65.685% 77.803% ############# ( 2, 3 ] 19945 13.280% 91.084% ### ( 3, 4 ] 6751 4.495% 95.579% # ( 4, 6 ] 4788 3.188% 98.767% # ( 6, 10 ] 1379 0.918% 99.685% ( 10, 15 ] 267 0.178% 99.863% ( 15, 22 ] 34 0.023% 99.885% ( 76, 110 ] 53 0.035% 99.921% ( 110, 170 ] 58 0.039% 99.959% ( 170, 250 ] 24 0.016% 99.975% ( 250, 380 ] 13 0.009% 99.984% ( 380, 580 ] 22 0.015% 99.999% ( 580, 870 ] 5 0.003% 100.002% ( 870, 1300 ] 5 0.003% 100.005% ( 1300, 1900 ] 4 0.003% 100.008% ** Level 2 read latency histogram (micros): Count: 95443 Average: 2.1113 StdDev: 16.79 Min: 1 Median: 1.3901 Max: 2926 Percentiles: P50: 1.39 P75: 1.78 P99: 5.25 P99.9: 9.87 P99.99: 518.23 ------------------------------------------------------ [ 0, 1 ] 24102 25.253% 25.253% ##### ( 1, 2 ] 60549 63.440% 88.693% ############# ( 2, 3 ] 6265 6.564% 95.257% # ( 3, 4 ] 2653 2.780% 98.037% # ( 4, 6 ] 1472 1.542% 99.579% ( 6, 10 ] 317 0.332% 99.911% ( 10, 15 ] 57 0.060% 99.971% ( 15, 22 ] 8 0.008% 99.979% ( 22, 34 ] 2 0.002% 99.981% ( 51, 76 ] 2 0.002% 99.983% ( 170, 250 ] 1 0.001% 99.984% ( 250, 380 ] 2 0.002% 99.986% ( 380, 580 ] 5 0.005% 99.992% ( 580, 870 ] 2 0.002% 99.994% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 3 0.003% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 57425 Average: 4.0460 StdDev: 65.81 Min: 0 Median: 1.6424 Max: 5164 Percentiles: P50: 1.64 P75: 2.10 P99: 5.98 P99.9: 163.63 P99.99: 2014.32 ------------------------------------------------------ [ 0, 1 ] 4494 7.826% 7.826% ## ( 1, 2 ] 37702 65.654% 73.480% ############# ( 2, 3 ] 9041 15.744% 89.224% ### ( 3, 4 ] 3312 5.768% 94.992% # ( 4, 6 ] 2326 4.051% 99.042% # ( 6, 10 ] 342 0.596% 99.638% ( 10, 15 ] 101 0.176% 99.814% ( 15, 22 ] 18 0.031% 99.845% ( 22, 34 ] 25 0.044% 99.889% ( 34, 51 ] 3 0.005% 99.894% ( 110, 170 ] 4 0.007% 99.901% ( 170, 250 ] 12 0.021% 99.922% ( 250, 380 ] 5 0.009% 99.930% ( 380, 580 ] 7 0.012% 99.943% ( 580, 870 ] 9 0.016% 99.958% ( 870, 1300 ] 10 0.017% 99.976% ( 1300, 1900 ] 7 0.012% 99.988% ( 1900, 2900 ] 11 0.019% 100.007% ( 2900, 4400 ] 3 0.005% 100.012% ( 4400, 6600 ] 4 0.007% 100.019% ** Level 4 read latency histogram (micros): Count: 15 Average: 1811.6000 StdDev: 1367.54 Min: 603 Median: 1228.3333 Max: 4721 Percentiles: P50: 1228.33 P75: 2525.00 P99: 4721.00 P99.9: 4721.00 P99.99: 4721.00 ------------------------------------------------------ ( 580, 870 ] 5 33.333% 33.333% ####### ( 870, 1300 ] 3 20.000% 53.333% #### ( 1300, 1900 ] 2 13.333% 66.667% ### ( 1900, 2900 ] 2 13.333% 80.000% ### ( 2900, 4400 ] 1 6.667% 86.667% # ( 4400, 6600 ] 2 13.333% 100.000% ### ** Level 5 read latency histogram (micros): Count: 40 Average: 568.2750 StdDev: 661.37 Min: 78 Median: 158.0000 Max: 1950 Percentiles: P50: 158.00 P75: 1013.33 P99: 1950.00 P99.9: 1950.00 P99.99: 1950.00 ------------------------------------------------------ ( 76, 110 ] 12 30.000% 30.000% ###### ( 110, 170 ] 10 25.000% 55.000% ##### ( 170, 250 ] 2 5.000% 60.000% # ( 250, 380 ] 1 2.500% 62.500% # ( 380, 580 ] 4 10.000% 72.500% ## ( 870, 1300 ] 3 7.500% 80.000% ## ( 1300, 1900 ] 6 15.000% 95.000% ### ( 1900, 2900 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 15.3 total, 3.1 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 320.65 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.999 H:M:S, 13.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 313.34 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.498 H:M:S, 15.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/28-14:18:52 ... thread 0: (1000000,6000000) ops and (135024.4,266370.3) ops/second in (7.406067,22.525034) 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/10 4.05 GB 213.7 5.1 0.0 5.1 10.8 5.7 0.0 1.9 143.9 305.0 36.32 34.21 101 0.360 5308K 7092 0.0 0.0 L1 9/9 1.04 GB 0.0 1.4 1.4 0.0 1.4 1.4 0.2 1.0 237.8 236.9 6.10 5.96 2 3.051 1473K 5163 0.0 0.0 L2 2/0 54.55 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 248.3 248.1 1.52 1.46 2 0.761 383K 201 0.0 0.0 L3 42/0 999.60 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 205.6 205.3 3.87 3.42 3 1.292 808K 813 0.0 0.0 L4 144/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1263/19 101.84 GB 0.0 7.7 2.2 5.5 13.4 7.9 2.1 2.3 164.2 286.4 47.82 45.06 108 0.443 7973K 13K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.7 2.2 5.5 13.4 7.9 2.0 2.3 164.2 286.4 47.82 45.06 108 0.443 7973K 13K 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 7.7 2.2 5.5 7.7 2.1 0.0 0.0 251.4 251.0 31.24 30.22 24 1.302 7973K 13K 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 353.3 16.58 14.84 84 0.197 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): 22.8 total, 22.5 interval Flush(GB): cumulative 5.721, interval 5.721 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: 13.38 GB write, 602.04 MB/s write, 7.67 GB read, 345.15 MB/s read, 47.8 seconds Interval compaction: 13.38 GB write, 608.08 MB/s write, 7.67 GB read, 348.61 MB/s read, 47.8 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: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 12, total-stops: 15, interval: 27 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2162526 Average: 2.1918 StdDev: 11.48 Min: 0 Median: 1.4727 Max: 4881 Percentiles: P50: 1.47 P75: 1.85 P99: 5.53 P99.9: 10.30 P99.99: 64.65 ------------------------------------------------------ [ 0, 1 ] 398327 18.420% 18.420% #### ( 1, 2 ] 1444688 66.806% 85.225% ############# ( 2, 3 ] 199385 9.220% 94.445% ## ( 3, 4 ] 70084 3.241% 97.686% # ( 4, 6 ] 37154 1.718% 99.404% ( 6, 10 ] 10616 0.491% 99.895% ( 10, 15 ] 1829 0.085% 99.980% ( 15, 22 ] 170 0.008% 99.987% ( 22, 34 ] 26 0.001% 99.989% ( 34, 51 ] 16 0.001% 99.989% ( 51, 76 ] 27 0.001% 99.991% ( 76, 110 ] 256 0.012% 100.002% ( 110, 170 ] 239 0.011% 100.013% ( 170, 250 ] 119 0.006% 100.019% ( 250, 380 ] 92 0.004% 100.023% ( 380, 580 ] 61 0.003% 100.026% ( 580, 870 ] 41 0.002% 100.028% ( 870, 1300 ] 29 0.001% 100.029% ( 1300, 1900 ] 15 0.001% 100.030% ( 1900, 2900 ] 12 0.001% 100.031% ( 2900, 4400 ] 6 0.000% 100.031% ( 4400, 6600 ] 1 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 296926 Average: 2.5219 StdDev: 11.39 Min: 0 Median: 1.5439 Max: 1833 Percentiles: P50: 1.54 P75: 1.92 P99: 7.33 P99.9: 106.32 P99.99: 461.54 ------------------------------------------------------ [ 0, 1 ] 39910 13.441% 13.441% ### ( 1, 2 ] 199574 67.213% 80.654% ############# ( 2, 3 ] 34664 11.674% 92.329% ## ( 3, 4 ] 11155 3.757% 96.086% # ( 4, 6 ] 7600 2.560% 98.645% # ( 6, 10 ] 3160 1.064% 99.709% ( 10, 15 ] 388 0.131% 99.840% ( 15, 22 ] 47 0.016% 99.856% ( 51, 76 ] 8 0.003% 99.859% ( 76, 110 ] 138 0.046% 99.905% ( 110, 170 ] 144 0.048% 99.954% ( 170, 250 ] 58 0.020% 99.973% ( 250, 380 ] 34 0.011% 99.985% ( 380, 580 ] 40 0.013% 99.998% ( 580, 870 ] 8 0.003% 100.001% ( 870, 1300 ] 6 0.002% 100.003% ( 1300, 1900 ] 4 0.001% 100.004% ** Level 2 read latency histogram (micros): Count: 95443 Average: 2.1113 StdDev: 16.79 Min: 1 Median: 1.3901 Max: 2926 Percentiles: P50: 1.39 P75: 1.78 P99: 5.25 P99.9: 9.87 P99.99: 518.23 ------------------------------------------------------ [ 0, 1 ] 24102 25.253% 25.253% ##### ( 1, 2 ] 60549 63.440% 88.693% ############# ( 2, 3 ] 6265 6.564% 95.257% # ( 3, 4 ] 2653 2.780% 98.037% # ( 4, 6 ] 1472 1.542% 99.579% ( 6, 10 ] 317 0.332% 99.911% ( 10, 15 ] 57 0.060% 99.971% ( 15, 22 ] 8 0.008% 99.979% ( 22, 34 ] 2 0.002% 99.981% ( 51, 76 ] 2 0.002% 99.983% ( 170, 250 ] 1 0.001% 99.984% ( 250, 380 ] 2 0.002% 99.986% ( 380, 580 ] 5 0.005% 99.992% ( 580, 870 ] 2 0.002% 99.994% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 3 0.003% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 57425 Average: 4.0460 StdDev: 65.81 Min: 0 Median: 1.6424 Max: 5164 Percentiles: P50: 1.64 P75: 2.10 P99: 5.98 P99.9: 163.63 P99.99: 2014.32 ------------------------------------------------------ [ 0, 1 ] 4494 7.826% 7.826% ## ( 1, 2 ] 37702 65.654% 73.480% ############# ( 2, 3 ] 9041 15.744% 89.224% ### ( 3, 4 ] 3312 5.768% 94.992% # ( 4, 6 ] 2326 4.051% 99.042% # ( 6, 10 ] 342 0.596% 99.638% ( 10, 15 ] 101 0.176% 99.814% ( 15, 22 ] 18 0.031% 99.845% ( 22, 34 ] 25 0.044% 99.889% ( 34, 51 ] 3 0.005% 99.894% ( 110, 170 ] 4 0.007% 99.901% ( 170, 250 ] 12 0.021% 99.922% ( 250, 380 ] 5 0.009% 99.930% ( 380, 580 ] 7 0.012% 99.943% ( 580, 870 ] 9 0.016% 99.958% ( 870, 1300 ] 10 0.017% 99.976% ( 1300, 1900 ] 7 0.012% 99.988% ( 1900, 2900 ] 11 0.019% 100.007% ( 2900, 4400 ] 3 0.005% 100.012% ( 4400, 6600 ] 4 0.007% 100.019% ** Level 4 read latency histogram (micros): Count: 15 Average: 1811.6000 StdDev: 1367.54 Min: 603 Median: 1228.3333 Max: 4721 Percentiles: P50: 1228.33 P75: 2525.00 P99: 4721.00 P99.9: 4721.00 P99.99: 4721.00 ------------------------------------------------------ ( 580, 870 ] 5 33.333% 33.333% ####### ( 870, 1300 ] 3 20.000% 53.333% #### ( 1300, 1900 ] 2 13.333% 66.667% ### ( 1900, 2900 ] 2 13.333% 80.000% ### ( 2900, 4400 ] 1 6.667% 86.667% # ( 4400, 6600 ] 2 13.333% 100.000% ### ** Level 5 read latency histogram (micros): Count: 40 Average: 568.2750 StdDev: 661.37 Min: 78 Median: 158.0000 Max: 1950 Percentiles: P50: 158.00 P75: 1013.33 P99: 1950.00 P99.9: 1950.00 P99.99: 1950.00 ------------------------------------------------------ ( 76, 110 ] 12 30.000% 30.000% ###### ( 110, 170 ] 10 25.000% 55.000% ##### ( 170, 250 ] 2 5.000% 60.000% # ( 250, 380 ] 1 2.500% 62.500% # ( 380, 580 ] 4 10.000% 72.500% ## ( 870, 1300 ] 3 7.500% 80.000% ## ( 1300, 1900 ] 6 15.000% 95.000% ### ( 1900, 2900 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 22.8 total, 7.4 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 259.53 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.526 H:M:S, 28.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 132.89 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.527 H:M:S, 61.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 2024/11/28-14:18:57 ... thread 0: (1000000,7000000) ops and (198672.2,254005.6) ops/second in (5.033418,27.558452) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/11 2.95 GB 25.2 5.8 0.0 5.8 12.4 6.6 0.0 1.9 143.5 304.9 41.71 39.25 117 0.357 6075K 7840 0.0 0.0 L1 17/17 1.96 GB 0.0 4.4 3.4 1.0 4.4 3.3 0.2 1.3 228.4 226.1 19.84 19.13 3 6.614 4602K 45K 0.0 0.0 L2 2/0 54.55 MB 0.5 0.4 0.2 0.2 0.4 0.2 1.4 2.0 248.3 248.1 1.52 1.46 2 0.761 383K 201 0.0 0.0 L3 14/0 926.61 MB 0.9 0.8 0.6 0.2 0.8 0.6 1.1 1.4 205.6 205.3 3.87 3.42 3 1.292 808K 813 0.0 0.0 L4 167/0 9.56 GB 1.0 0.2 0.1 0.0 0.2 0.1 1.6 1.2 198.4 197.3 0.79 0.71 1 0.795 160K 843 0.0 0.0 L5 1060/0 87.23 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1272/28 102.66 GB 0.0 11.6 4.2 7.3 18.1 10.8 6.0 2.7 174.9 273.6 67.75 63.97 126 0.538 12M 55K 0.0 0.0 Int 0/0 0.00 KB 0.0 11.6 4.2 7.3 18.1 10.8 5.9 2.7 174.9 273.6 67.75 63.97 126 0.538 12M 55K 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 11.6 4.2 7.3 11.5 4.2 0.0 0.0 243.8 242.6 48.61 46.84 29 1.676 12M 55K 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 352.2 19.14 17.12 97 0.197 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 27.8 total, 27.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: 18.10 GB write, 667.01 MB/s write, 11.57 GB read, 426.43 MB/s read, 67.7 seconds Interval compaction: 18.10 GB write, 672.48 MB/s write, 11.57 GB read, 429.93 MB/s read, 67.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 16, pending-compaction-bytes-delays: 4, pending-compaction-bytes-stops: 0, total-delays: 19, total-stops: 16, interval: 35 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2580392 Average: 2.2858 StdDev: 13.46 Min: 0 Median: 1.4726 Max: 4881 Percentiles: P50: 1.47 P75: 1.85 P99: 5.67 P99.9: 13.26 P99.99: 152.73 ------------------------------------------------------ [ 0, 1 ] 474662 18.395% 18.395% #### ( 1, 2 ] 1725491 66.869% 85.264% ############# ( 2, 3 ] 235637 9.132% 94.396% ## ( 3, 4 ] 82166 3.184% 97.580% # ( 4, 6 ] 43927 1.702% 99.283% ( 6, 10 ] 14447 0.560% 99.843% ( 10, 15 ] 2273 0.088% 99.931% ( 15, 22 ] 209 0.008% 99.939% ( 22, 34 ] 30 0.001% 99.940% ( 34, 51 ] 17 0.001% 99.941% ( 51, 76 ] 55 0.002% 99.943% ( 76, 110 ] 676 0.026% 99.969% ( 110, 170 ] 768 0.030% 99.999% ( 170, 250 ] 278 0.011% 100.009% ( 250, 380 ] 186 0.007% 100.017% ( 380, 580 ] 148 0.006% 100.022% ( 580, 870 ] 86 0.003% 100.026% ( 870, 1300 ] 39 0.002% 100.027% ( 1300, 1900 ] 17 0.001% 100.028% ( 1900, 2900 ] 18 0.001% 100.029% ( 2900, 4400 ] 10 0.000% 100.029% ( 4400, 6600 ] 2 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 386484 Average: 2.5600 StdDev: 13.63 Min: 0 Median: 1.5272 Max: 1833 Percentiles: P50: 1.53 P75: 1.90 P99: 7.20 P99.9: 114.41 P99.99: 583.52 ------------------------------------------------------ [ 0, 1 ] 56436 14.602% 14.602% ### ( 1, 2 ] 259486 67.140% 81.743% ############# ( 2, 3 ] 42847 11.086% 92.829% ## ( 3, 4 ] 13614 3.523% 96.351% # ( 4, 6 ] 9068 2.346% 98.698% ( 6, 10 ] 3890 1.007% 99.704% ( 10, 15 ] 475 0.123% 99.827% ( 15, 22 ] 61 0.016% 99.843% ( 34, 51 ] 1 0.000% 99.843% ( 51, 76 ] 9 0.002% 99.846% ( 76, 110 ] 197 0.051% 99.897% ( 110, 170 ] 184 0.048% 99.944% ( 170, 250 ] 73 0.019% 99.963% ( 250, 380 ] 46 0.012% 99.975% ( 380, 580 ] 58 0.015% 99.990% ( 580, 870 ] 29 0.008% 99.997% ( 870, 1300 ] 16 0.004% 100.002% ( 1300, 1900 ] 6 0.002% 100.003% ** Level 2 read latency histogram (micros): Count: 95443 Average: 2.1113 StdDev: 16.79 Min: 1 Median: 1.3901 Max: 2926 Percentiles: P50: 1.39 P75: 1.78 P99: 5.25 P99.9: 9.87 P99.99: 518.23 ------------------------------------------------------ [ 0, 1 ] 24102 25.253% 25.253% ##### ( 1, 2 ] 60549 63.440% 88.693% ############# ( 2, 3 ] 6265 6.564% 95.257% # ( 3, 4 ] 2653 2.780% 98.037% # ( 4, 6 ] 1472 1.542% 99.579% ( 6, 10 ] 317 0.332% 99.911% ( 10, 15 ] 57 0.060% 99.971% ( 15, 22 ] 8 0.008% 99.979% ( 22, 34 ] 2 0.002% 99.981% ( 51, 76 ] 2 0.002% 99.983% ( 170, 250 ] 1 0.001% 99.984% ( 250, 380 ] 2 0.002% 99.986% ( 380, 580 ] 5 0.005% 99.992% ( 580, 870 ] 2 0.002% 99.994% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 3 0.003% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 64770 Average: 4.5394 StdDev: 65.28 Min: 0 Median: 1.6204 Max: 5164 Percentiles: P50: 1.62 P75: 2.01 P99: 7.91 P99.9: 382.09 P99.99: 2038.45 ------------------------------------------------------ [ 0, 1 ] 6141 9.481% 9.481% ## ( 1, 2 ] 42303 65.313% 74.794% ############# ( 2, 3 ] 9575 14.783% 89.577% ### ( 3, 4 ] 3493 5.393% 94.970% # ( 4, 6 ] 2393 3.695% 98.665% # ( 6, 10 ] 455 0.702% 99.367% ( 10, 15 ] 109 0.168% 99.535% ( 15, 22 ] 19 0.029% 99.565% ( 22, 34 ] 26 0.040% 99.605% ( 34, 51 ] 3 0.005% 99.609% ( 76, 110 ] 47 0.073% 99.682% ( 110, 170 ] 51 0.079% 99.761% ( 170, 250 ] 53 0.082% 99.843% ( 250, 380 ] 37 0.057% 99.900% ( 380, 580 ] 22 0.034% 99.934% ( 580, 870 ] 14 0.022% 99.955% ( 870, 1300 ] 13 0.020% 99.975% ( 1300, 1900 ] 8 0.012% 99.988% ( 1900, 2900 ] 11 0.017% 100.005% ( 2900, 4400 ] 4 0.006% 100.011% ( 4400, 6600 ] 4 0.006% 100.017% ** Level 4 read latency histogram (micros): Count: 30 Average: 1012.6000 StdDev: 1297.22 Min: 1 Median: 638.0000 Max: 4721 Percentiles: P50: 638.00 P75: 1400.00 P99: 4721.00 P99.9: 4721.00 P99.99: 4721.00 ------------------------------------------------------ [ 0, 1 ] 7 23.333% 23.333% ##### ( 1, 2 ] 1 3.333% 26.667% # ( 2, 3 ] 1 3.333% 30.000% # ( 110, 170 ] 2 6.667% 36.667% # ( 170, 250 ] 1 3.333% 40.000% # ( 250, 380 ] 1 3.333% 43.333% # ( 380, 580 ] 1 3.333% 46.667% # ( 580, 870 ] 5 16.667% 63.333% ### ( 870, 1300 ] 3 10.000% 73.333% ## ( 1300, 1900 ] 3 10.000% 83.333% ## ( 1900, 2900 ] 2 6.667% 90.000% # ( 2900, 4400 ] 1 3.333% 93.333% # ( 4400, 6600 ] 2 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 100 Average: 723.1200 StdDev: 826.47 Min: 78 Median: 250.0000 Max: 3165 Percentiles: P50: 250.00 P75: 1177.14 P99: 3165.00 P99.9: 3165.00 P99.99: 3165.00 ------------------------------------------------------ ( 76, 110 ] 14 14.000% 14.000% ### ( 110, 170 ] 23 23.000% 37.000% ##### ( 170, 250 ] 13 13.000% 50.000% ### ( 250, 380 ] 6 6.000% 56.000% # ( 380, 580 ] 9 9.000% 65.000% ## ( 580, 870 ] 5 5.000% 70.000% # ( 870, 1300 ] 7 7.000% 77.000% # ( 1300, 1900 ] 11 11.000% 88.000% ## ( 1900, 2900 ] 8 8.000% 96.000% ## ( 2900, 4400 ] 4 4.000% 100.000% # ** DB Stats ** Uptime(secs): 27.8 total, 5.0 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 247.94 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:8.836 H:M:S, 31.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 195.53 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.310 H:M:S, 45.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/28-14:19:20 ... thread 0: (1000000,8000000) ops and (42872.7,157222.5) ops/second in (23.324853,50.883305) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/10 1.60 GB 18.9 6.5 0.0 6.5 14.1 7.6 0.0 1.8 132.3 288.3 50.01 44.47 132 0.379 6715K 8528 0.0 0.0 L1 10/9 989.66 MB 0.0 8.8 5.8 3.0 8.7 5.7 0.2 1.5 223.9 220.9 40.18 37.85 4 10.046 8662K 45K 0.0 0.0 L2 2/1 204.57 MB 1.0 0.4 0.2 0.2 0.4 0.2 4.8 2.0 248.3 248.1 1.52 1.46 2 0.761 383K 201 0.0 0.0 L3 22/7 1.79 GB 1.0 2.0 1.1 0.9 2.0 1.1 3.7 1.8 129.5 128.5 15.70 9.07 9 1.744 2065K 16K 0.0 0.0 L4 173/21 10.53 GB 1.0 2.8 2.4 0.4 2.8 2.4 1.6 1.2 121.0 120.4 23.50 13.18 24 0.979 2840K 13K 0.0 0.0 L5 1076/0 88.52 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1295/48 103.61 GB 0.0 20.4 9.5 10.9 27.8 16.9 13.2 3.7 159.4 217.8 130.92 106.04 171 0.766 20M 84K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.4 9.5 10.9 27.8 16.9 13.1 3.7 159.4 217.8 130.92 106.04 171 0.766 20M 84K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 20.4 9.5 10.9 20.2 9.3 0.0 0.0 197.1 195.6 105.84 86.01 61 1.735 20M 84K 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 311.5 25.08 20.03 110 0.228 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): 51.1 total, 50.9 interval Flush(GB): cumulative 7.628, interval 7.628 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: 27.85 GB write, 557.91 MB/s write, 20.38 GB read, 408.26 MB/s read, 130.9 seconds Interval compaction: 27.85 GB write, 560.39 MB/s write, 20.38 GB read, 410.07 MB/s read, 130.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 46, pending-compaction-bytes-delays: 12, pending-compaction-bytes-stops: 0, total-delays: 27, total-stops: 46, interval: 73 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3474541 Average: 2.7452 StdDev: 29.27 Min: 0 Median: 1.4748 Max: 11250 Percentiles: P50: 1.47 P75: 1.86 P99: 6.09 P99.9: 127.54 P99.99: 374.74 ------------------------------------------------------ [ 0, 1 ] 666414 19.180% 19.180% #### ( 1, 2 ] 2255388 64.912% 84.092% ############# ( 2, 3 ] 318297 9.161% 93.253% ## ( 3, 4 ] 120716 3.474% 96.727% # ( 4, 6 ] 78484 2.259% 98.986% ( 6, 10 ] 22829 0.657% 99.643% ( 10, 15 ] 3991 0.115% 99.758% ( 15, 22 ] 557 0.016% 99.774% ( 22, 34 ] 38 0.001% 99.775% ( 34, 51 ] 20 0.001% 99.775% ( 51, 76 ] 118 0.003% 99.779% ( 76, 110 ] 3363 0.097% 99.875% ( 110, 170 ] 2916 0.084% 99.959% ( 170, 250 ] 602 0.017% 99.977% ( 250, 380 ] 481 0.014% 99.991% ( 380, 580 ] 525 0.015% 100.006% ( 580, 870 ] 268 0.008% 100.013% ( 870, 1300 ] 150 0.004% 100.018% ( 1300, 1900 ] 73 0.002% 100.020% ( 1900, 2900 ] 77 0.002% 100.022% ( 2900, 4400 ] 67 0.002% 100.024% ( 4400, 6600 ] 23 0.001% 100.025% ( 6600, 9900 ] 3 0.000% 100.025% ( 9900, 14000 ] 1 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 1656209 Average: 5.2973 StdDev: 91.38 Min: 0 Median: 1.6098 Max: 13625 Percentiles: P50: 1.61 P75: 2.24 P99: 9.02 P99.9: 151.46 P99.99: 480.34 ------------------------------------------------------ [ 0, 1 ] 266600 16.097% 16.097% ### ( 1, 2 ] 920867 55.601% 71.698% ########### ( 2, 3 ] 231080 13.952% 85.650% ### ( 3, 4 ] 103236 6.233% 91.884% # ( 4, 6 ] 98102 5.923% 97.807% # ( 6, 10 ] 26177 1.581% 99.387% ( 10, 15 ] 4651 0.281% 99.668% ( 15, 22 ] 800 0.048% 99.716% ( 22, 34 ] 38 0.002% 99.719% ( 34, 51 ] 15 0.001% 99.720% ( 51, 76 ] 197 0.012% 99.732% ( 76, 110 ] 1772 0.107% 99.839% ( 110, 170 ] 1473 0.089% 99.927% ( 170, 250 ] 343 0.021% 99.948% ( 250, 380 ] 435 0.026% 99.974% ( 380, 580 ] 513 0.031% 100.005% ( 580, 870 ] 538 0.032% 100.038% ( 870, 1300 ] 390 0.024% 100.061% ( 1300, 1900 ] 209 0.013% 100.074% ( 1900, 2900 ] 266 0.016% 100.090% ( 2900, 4400 ] 316 0.019% 100.109% ( 4400, 6600 ] 135 0.008% 100.117% ( 6600, 9900 ] 41 0.002% 100.120% ( 9900, 14000 ] 6 0.000% 100.120% ** Level 2 read latency histogram (micros): Count: 95443 Average: 2.1113 StdDev: 16.79 Min: 1 Median: 1.3901 Max: 2926 Percentiles: P50: 1.39 P75: 1.78 P99: 5.25 P99.9: 9.87 P99.99: 518.23 ------------------------------------------------------ [ 0, 1 ] 24102 25.253% 25.253% ##### ( 1, 2 ] 60549 63.440% 88.693% ############# ( 2, 3 ] 6265 6.564% 95.257% # ( 3, 4 ] 2653 2.780% 98.037% # ( 4, 6 ] 1472 1.542% 99.579% ( 6, 10 ] 317 0.332% 99.911% ( 10, 15 ] 57 0.060% 99.971% ( 15, 22 ] 8 0.008% 99.979% ( 22, 34 ] 2 0.002% 99.981% ( 51, 76 ] 2 0.002% 99.983% ( 170, 250 ] 1 0.001% 99.984% ( 250, 380 ] 2 0.002% 99.986% ( 380, 580 ] 5 0.005% 99.992% ( 580, 870 ] 2 0.002% 99.994% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 3 0.003% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 447020 Average: 11.4695 StdDev: 136.71 Min: 0 Median: 1.9355 Max: 8516 Percentiles: P50: 1.94 P75: 2.94 P99: 9.79 P99.9: 671.04 P99.99: 832.42 ------------------------------------------------------ [ 0, 1 ] 11548 2.583% 2.583% # ( 1, 2 ] 226577 50.686% 53.269% ########## ( 2, 3 ] 103490 23.151% 76.421% ##### ( 3, 4 ] 49698 11.118% 87.538% ## ( 4, 6 ] 43844 9.808% 97.346% ## ( 6, 10 ] 7796 1.744% 99.090% ( 10, 15 ] 1695 0.379% 99.469% ( 15, 22 ] 190 0.043% 99.512% ( 22, 34 ] 37 0.008% 99.520% ( 34, 51 ] 8 0.002% 99.522% ( 51, 76 ] 4 0.001% 99.523% ( 76, 110 ] 62 0.014% 99.537% ( 110, 170 ] 127 0.028% 99.565% ( 170, 250 ] 226 0.051% 99.616% ( 250, 380 ] 404 0.090% 99.706% ( 380, 580 ] 640 0.143% 99.849% ( 580, 870 ] 723 0.162% 100.011% ( 870, 1300 ] 578 0.129% 100.140% ( 1300, 1900 ] 282 0.063% 100.203% ( 1900, 2900 ] 230 0.051% 100.255% ( 2900, 4400 ] 235 0.053% 100.307% ( 4400, 6600 ] 72 0.016% 100.323% ( 6600, 9900 ] 6 0.001% 100.325% ** Level 4 read latency histogram (micros): Count: 45914 Average: 12.0039 StdDev: 156.63 Min: 1 Median: 1.9955 Max: 6175 Percentiles: P50: 2.00 P75: 3.01 P99: 11.31 P99.9: 2361.92 P99.99: 4051.70 ------------------------------------------------------ [ 0, 1 ] 373 0.812% 0.812% ( 1, 2 ] 22685 49.408% 50.220% ########## ( 2, 3 ] 11328 24.672% 74.892% ##### ( 3, 4 ] 5234 11.400% 86.292% ## ( 4, 6 ] 4970 10.825% 97.116% ## ( 6, 10 ] 816 1.777% 98.894% ( 10, 15 ] 186 0.405% 99.299% ( 15, 22 ] 23 0.050% 99.349% ( 22, 34 ] 6 0.013% 99.362% ( 51, 76 ] 2 0.004% 99.366% ( 76, 110 ] 12 0.026% 99.392% ( 110, 170 ] 10 0.022% 99.414% ( 170, 250 ] 38 0.083% 99.497% ( 250, 380 ] 18 0.039% 99.536% ( 380, 580 ] 43 0.094% 99.630% ( 580, 870 ] 42 0.091% 99.721% ( 870, 1300 ] 42 0.091% 99.813% ( 1300, 1900 ] 29 0.063% 99.876% ( 1900, 2900 ] 24 0.052% 99.928% ( 2900, 4400 ] 37 0.081% 100.009% ( 4400, 6600 ] 13 0.028% 100.037% ** Level 5 read latency histogram (micros): Count: 194 Average: 1289.0825 StdDev: 1454.60 Min: 78 Median: 676.6667 Max: 9277 Percentiles: P50: 676.67 P75: 1859.09 P99: 6304.57 P99.9: 9259.80 P99.99: 9277.00 ------------------------------------------------------ ( 76, 110 ] 15 7.732% 7.732% ## ( 110, 170 ] 26 13.402% 21.134% ### ( 170, 250 ] 15 7.732% 28.866% ## ( 250, 380 ] 16 8.247% 37.113% ## ( 380, 580 ] 21 10.825% 47.938% ## ( 580, 870 ] 12 6.186% 54.124% # ( 870, 1300 ] 20 10.309% 64.433% ## ( 1300, 1900 ] 22 11.340% 75.773% ## ( 1900, 2900 ] 18 9.278% 85.052% ## ( 2900, 4400 ] 21 10.825% 95.876% ## ( 4400, 6600 ] 7 3.608% 99.485% # ( 6600, 9900 ] 1 0.515% 100.000% ** DB Stats ** Uptime(secs): 51.1 total, 23.3 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 154.05 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:28.480 H:M:S, 55.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 42.19 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:19.644 H:M:S, 84.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/11/28-14:19:23 ... thread 0: (1000000,9000000) ops and (295030.9,165829.0) ops/second in (3.389476,54.272781) 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.46 GB 113.2 7.4 0.0 7.4 15.9 8.5 0.0 1.9 132.1 282.6 57.70 50.70 147 0.392 7738K 9852 0.0 0.0 L1 10/9 989.66 MB 0.0 8.8 5.8 3.0 8.7 5.7 0.2 1.5 223.9 220.9 40.18 37.85 4 10.046 8662K 45K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 4.8 2.0 248.3 248.1 1.52 1.46 2 0.761 383K 201 0.0 0.0 L3 15/0 931.88 MB 0.9 2.2 1.2 1.0 2.2 1.2 3.8 1.8 129.2 128.1 17.52 10.10 10 1.752 2299K 20K 0.0 0.0 L4 157/0 9.63 GB 1.0 4.4 3.5 1.0 4.4 3.5 1.6 1.3 123.7 123.1 36.71 21.14 34 1.080 4517K 17K 0.0 0.0 L5 1100/0 90.49 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1297/19 104.46 GB 0.0 23.2 10.6 12.6 31.6 19.0 15.3 3.7 154.9 210.4 153.63 121.25 197 0.780 23M 93K 0.0 0.0 Int 0/0 0.00 KB 0.0 23.2 10.6 12.6 31.6 19.0 15.2 3.7 154.9 210.4 153.63 121.25 197 0.780 23M 93K 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 23.2 10.6 12.6 23.1 10.5 0.0 0.0 189.6 188.2 125.54 98.93 75 1.674 23M 93K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 0.0 0.0 0.0 309.5 28.09 22.32 122 0.230 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): 54.5 total, 54.3 interval Flush(GB): cumulative 8.490, interval 8.490 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 31.56 GB write, 593.02 MB/s write, 23.24 GB read, 436.70 MB/s read, 153.6 seconds Interval compaction: 31.56 GB write, 595.48 MB/s write, 23.24 GB read, 438.52 MB/s read, 153.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 57, pending-compaction-bytes-delays: 12, pending-compaction-bytes-stops: 0, total-delays: 27, total-stops: 57, interval: 84 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3769275 Average: 2.7426 StdDev: 28.57 Min: 0 Median: 1.4873 Max: 11250 Percentiles: P50: 1.49 P75: 1.87 P99: 6.30 P99.9: 123.94 P99.99: 365.21 ------------------------------------------------------ [ 0, 1 ] 693935 18.410% 18.410% #### ( 1, 2 ] 2443346 64.823% 83.233% ############# ( 2, 3 ] 363372 9.640% 92.873% ## ( 3, 4 ] 137566 3.650% 96.523% # ( 4, 6 ] 91392 2.425% 98.948% ( 6, 10 ] 26325 0.698% 99.646% ( 10, 15 ] 4670 0.124% 99.770% ( 15, 22 ] 620 0.016% 99.786% ( 22, 34 ] 43 0.001% 99.788% ( 34, 51 ] 25 0.001% 99.788% ( 51, 76 ] 120 0.003% 99.791% ( 76, 110 ] 3399 0.090% 99.882% ( 110, 170 ] 2990 0.079% 99.961% ( 170, 250 ] 646 0.017% 99.978% ( 250, 380 ] 509 0.014% 99.992% ( 380, 580 ] 557 0.015% 100.006% ( 580, 870 ] 278 0.007% 100.014% ( 870, 1300 ] 159 0.004% 100.018% ( 1300, 1900 ] 76 0.002% 100.020% ( 1900, 2900 ] 83 0.002% 100.022% ( 2900, 4400 ] 69 0.002% 100.024% ( 4400, 6600 ] 23 0.001% 100.025% ( 6600, 9900 ] 3 0.000% 100.025% ( 9900, 14000 ] 1 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 1861038 Average: 5.3603 StdDev: 90.97 Min: 0 Median: 1.6325 Max: 13625 Percentiles: P50: 1.63 P75: 2.30 P99: 9.08 P99.9: 157.60 P99.99: 539.21 ------------------------------------------------------ [ 0, 1 ] 273938 14.720% 14.720% ### ( 1, 2 ] 1038034 55.777% 70.497% ########### ( 2, 3 ] 274812 14.767% 85.263% ### ( 3, 4 ] 119333 6.412% 91.676% # ( 4, 6 ] 112510 6.046% 97.721% # ( 6, 10 ] 30940 1.663% 99.384% ( 10, 15 ] 5394 0.290% 99.673% ( 15, 22 ] 892 0.048% 99.721% ( 22, 34 ] 41 0.002% 99.724% ( 34, 51 ] 18 0.001% 99.725% ( 51, 76 ] 202 0.011% 99.735% ( 76, 110 ] 1828 0.098% 99.834% ( 110, 170 ] 1558 0.084% 99.917% ( 170, 250 ] 388 0.021% 99.938% ( 250, 380 ] 500 0.027% 99.965% ( 380, 580 ] 584 0.031% 99.996% ( 580, 870 ] 621 0.033% 100.030% ( 870, 1300 ] 456 0.025% 100.054% ( 1300, 1900 ] 239 0.013% 100.067% ( 1900, 2900 ] 318 0.017% 100.084% ( 2900, 4400 ] 372 0.020% 100.104% ( 4400, 6600 ] 146 0.008% 100.112% ( 6600, 9900 ] 42 0.002% 100.114% ( 9900, 14000 ] 6 0.000% 100.115% ** Level 2 read latency histogram (micros): Count: 95443 Average: 2.1113 StdDev: 16.79 Min: 1 Median: 1.3901 Max: 2926 Percentiles: P50: 1.39 P75: 1.78 P99: 5.25 P99.9: 9.87 P99.99: 518.23 ------------------------------------------------------ [ 0, 1 ] 24102 25.253% 25.253% ##### ( 1, 2 ] 60549 63.440% 88.693% ############# ( 2, 3 ] 6265 6.564% 95.257% # ( 3, 4 ] 2653 2.780% 98.037% # ( 4, 6 ] 1472 1.542% 99.579% ( 6, 10 ] 317 0.332% 99.911% ( 10, 15 ] 57 0.060% 99.971% ( 15, 22 ] 8 0.008% 99.979% ( 22, 34 ] 2 0.002% 99.981% ( 51, 76 ] 2 0.002% 99.983% ( 170, 250 ] 1 0.001% 99.984% ( 250, 380 ] 2 0.002% 99.986% ( 380, 580 ] 5 0.005% 99.992% ( 580, 870 ] 2 0.002% 99.994% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 3 0.003% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 531323 Average: 11.6791 StdDev: 137.87 Min: 0 Median: 1.9331 Max: 8516 Percentiles: P50: 1.93 P75: 2.93 P99: 9.87 P99.9: 745.84 P99.99: 934.24 ------------------------------------------------------ [ 0, 1 ] 12928 2.433% 2.433% ( 1, 2 ] 270856 50.978% 53.411% ########## ( 2, 3 ] 123193 23.186% 76.597% ##### ( 3, 4 ] 58481 11.007% 87.604% ## ( 4, 6 ] 51544 9.701% 97.305% ## ( 6, 10 ] 9313 1.753% 99.057% ( 10, 15 ] 2022 0.381% 99.438% ( 15, 22 ] 227 0.043% 99.481% ( 22, 34 ] 41 0.008% 99.488% ( 34, 51 ] 9 0.002% 99.490% ( 51, 76 ] 5 0.001% 99.491% ( 76, 110 ] 63 0.012% 99.503% ( 110, 170 ] 132 0.025% 99.528% ( 170, 250 ] 244 0.046% 99.574% ( 250, 380 ] 461 0.087% 99.660% ( 380, 580 ] 774 0.146% 99.806% ( 580, 870 ] 872 0.164% 99.970% ( 870, 1300 ] 702 0.132% 100.102% ( 1300, 1900 ] 360 0.068% 100.170% ( 1900, 2900 ] 290 0.055% 100.225% ( 2900, 4400 ] 290 0.055% 100.279% ( 4400, 6600 ] 82 0.015% 100.295% ( 6600, 9900 ] 7 0.001% 100.296% ** Level 4 read latency histogram (micros): Count: 126610 Average: 9.6539 StdDev: 123.88 Min: 0 Median: 1.9379 Max: 6175 Percentiles: P50: 1.94 P75: 2.90 P99: 10.77 P99.9: 1672.83 P99.99: 3634.01 ------------------------------------------------------ [ 0, 1 ] 1341 1.059% 1.059% ( 1, 2 ] 66065 52.180% 53.239% ########## ( 2, 3 ] 30504 24.093% 77.332% ##### ( 3, 4 ] 12821 10.126% 87.458% ## ( 4, 6 ] 11890 9.391% 96.849% ## ( 6, 10 ] 2641 2.086% 98.935% ( 10, 15 ] 535 0.423% 99.358% ( 15, 22 ] 70 0.055% 99.413% ( 22, 34 ] 15 0.012% 99.425% ( 34, 51 ] 1 0.001% 99.426% ( 51, 76 ] 3 0.002% 99.428% ( 76, 110 ] 16 0.013% 99.441% ( 110, 170 ] 30 0.024% 99.464% ( 170, 250 ] 86 0.068% 99.532% ( 250, 380 ] 63 0.050% 99.582% ( 380, 580 ] 131 0.103% 99.686% ( 580, 870 ] 123 0.097% 99.783% ( 870, 1300 ] 108 0.085% 99.868% ( 1300, 1900 ] 65 0.051% 99.919% ( 1900, 2900 ] 59 0.047% 99.966% ( 2900, 4400 ] 62 0.049% 100.015% ( 4400, 6600 ] 16 0.013% 100.028% ** Level 5 read latency histogram (micros): Count: 300 Average: 1358.6967 StdDev: 1492.09 Min: 78 Median: 740.0000 Max: 9277 Percentiles: P50: 740.00 P75: 2011.11 P99: 6430.77 P99.9: 9277.00 P99.99: 9277.00 ------------------------------------------------------ ( 76, 110 ] 15 5.000% 5.000% # ( 110, 170 ] 37 12.333% 17.333% ## ( 170, 250 ] 23 7.667% 25.000% ## ( 250, 380 ] 27 9.000% 34.000% ## ( 380, 580 ] 32 10.667% 44.667% ## ( 580, 870 ] 29 9.667% 54.333% ## ( 870, 1300 ] 29 9.667% 64.000% ## ( 1300, 1900 ] 30 10.000% 74.000% ## ( 1900, 2900 ] 27 9.000% 83.000% ## ( 2900, 4400 ] 36 12.000% 95.000% ## ( 4400, 6600 ] 13 4.333% 99.333% # ( 6600, 9900 ] 2 0.667% 100.000% ** DB Stats ** Uptime(secs): 54.5 total, 3.4 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 162.52 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.183 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, 290.36 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.703 H:M:S, 20.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/28-14:19:27 ... thread 0: (1000000,10000000) ops and (308027.1,173854.8) ops/second in (3.246468,57.519249) 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/6 3.44 GB 245.4 8.6 0.0 8.6 18.1 9.5 0.0 1.9 135.3 284.0 65.17 57.77 164 0.397 8954K 11K 0.0 0.0 L1 10/9 989.66 MB 0.0 8.8 5.8 3.0 8.7 5.7 0.2 1.5 223.9 220.9 40.18 37.85 4 10.046 8662K 45K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 4.8 2.0 248.3 248.1 1.52 1.46 2 0.761 383K 201 0.0 0.0 L3 15/0 931.88 MB 0.9 2.2 1.2 1.0 2.2 1.2 3.8 1.8 129.2 128.1 17.52 10.10 10 1.752 2299K 20K 0.0 0.0 L4 157/0 9.63 GB 1.0 4.4 3.5 1.0 4.4 3.5 1.6 1.3 123.7 123.1 36.71 21.14 34 1.080 4517K 17K 0.0 0.0 L5 1100/0 90.49 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1298/15 105.44 GB 0.0 24.4 10.6 13.8 33.7 19.9 15.3 3.6 155.2 214.3 161.10 128.33 214 0.753 24M 94K 0.0 0.0 Int 0/0 0.00 KB 0.0 24.4 10.6 13.8 33.7 19.9 15.2 3.6 155.2 214.3 161.10 128.33 214 0.753 24M 94K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 24.4 10.6 13.8 24.2 10.5 0.0 0.0 192.1 190.8 130.12 103.43 79 1.647 24M 94K 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 313.1 30.98 24.90 135 0.229 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.7 total, 57.5 interval Flush(GB): cumulative 9.474, interval 9.474 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 33.71 GB write, 597.83 MB/s write, 24.41 GB read, 432.88 MB/s read, 161.1 seconds Interval compaction: 33.71 GB write, 600.18 MB/s write, 24.41 GB read, 434.58 MB/s read, 161.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 61, pending-compaction-bytes-delays: 12, pending-compaction-bytes-stops: 0, total-delays: 28, total-stops: 61, interval: 89 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4070384 Average: 2.7059 StdDev: 27.72 Min: 0 Median: 1.4903 Max: 11250 Percentiles: P50: 1.49 P75: 1.87 P99: 6.09 P99.9: 117.21 P99.99: 345.66 ------------------------------------------------------ [ 0, 1 ] 735428 18.068% 18.068% #### ( 1, 2 ] 2651001 65.129% 83.197% ############# ( 2, 3 ] 396002 9.729% 92.926% ## ( 3, 4 ] 149156 3.664% 96.590% # ( 4, 6 ] 97484 2.395% 98.985% ( 6, 10 ] 27713 0.681% 99.666% ( 10, 15 ] 4929 0.121% 99.787% ( 15, 22 ] 646 0.016% 99.803% ( 22, 34 ] 49 0.001% 99.804% ( 34, 51 ] 25 0.001% 99.805% ( 51, 76 ] 120 0.003% 99.808% ( 76, 110 ] 3401 0.084% 99.891% ( 110, 170 ] 2992 0.074% 99.965% ( 170, 250 ] 652 0.016% 99.981% ( 250, 380 ] 515 0.013% 99.993% ( 380, 580 ] 561 0.014% 100.007% ( 580, 870 ] 281 0.007% 100.014% ( 870, 1300 ] 165 0.004% 100.018% ( 1300, 1900 ] 79 0.002% 100.020% ( 1900, 2900 ] 86 0.002% 100.022% ( 2900, 4400 ] 70 0.002% 100.024% ( 4400, 6600 ] 23 0.001% 100.024% ( 6600, 9900 ] 3 0.000% 100.024% ( 9900, 14000 ] 1 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 2017067 Average: 5.1565 StdDev: 87.44 Min: 0 Median: 1.6296 Max: 13625 Percentiles: P50: 1.63 P75: 2.27 P99: 9.02 P99.9: 157.22 P99.99: 538.40 ------------------------------------------------------ [ 0, 1 ] 286529 14.205% 14.205% ### ( 1, 2 ] 1146807 56.855% 71.060% ########### ( 2, 3 ] 296812 14.715% 85.775% ### ( 3, 4 ] 125092 6.202% 91.977% # ( 4, 6 ] 116334 5.767% 97.745% # ( 6, 10 ] 33494 1.661% 99.405% ( 10, 15 ] 5574 0.276% 99.681% ( 15, 22 ] 913 0.045% 99.727% ( 22, 34 ] 42 0.002% 99.729% ( 34, 51 ] 19 0.001% 99.730% ( 51, 76 ] 203 0.010% 99.740% ( 76, 110 ] 1872 0.093% 99.833% ( 110, 170 ] 1728 0.086% 99.918% ( 170, 250 ] 432 0.021% 99.940% ( 250, 380 ] 529 0.026% 99.966% ( 380, 580 ] 614 0.030% 99.996% ( 580, 870 ] 627 0.031% 100.027% ( 870, 1300 ] 457 0.023% 100.050% ( 1300, 1900 ] 239 0.012% 100.062% ( 1900, 2900 ] 318 0.016% 100.078% ( 2900, 4400 ] 372 0.018% 100.096% ( 4400, 6600 ] 146 0.007% 100.103% ( 6600, 9900 ] 42 0.002% 100.105% ( 9900, 14000 ] 6 0.000% 100.106% ** Level 2 read latency histogram (micros): Count: 95443 Average: 2.1113 StdDev: 16.79 Min: 1 Median: 1.3901 Max: 2926 Percentiles: P50: 1.39 P75: 1.78 P99: 5.25 P99.9: 9.87 P99.99: 518.23 ------------------------------------------------------ [ 0, 1 ] 24102 25.253% 25.253% ##### ( 1, 2 ] 60549 63.440% 88.693% ############# ( 2, 3 ] 6265 6.564% 95.257% # ( 3, 4 ] 2653 2.780% 98.037% # ( 4, 6 ] 1472 1.542% 99.579% ( 6, 10 ] 317 0.332% 99.911% ( 10, 15 ] 57 0.060% 99.971% ( 15, 22 ] 8 0.008% 99.979% ( 22, 34 ] 2 0.002% 99.981% ( 51, 76 ] 2 0.002% 99.983% ( 170, 250 ] 1 0.001% 99.984% ( 250, 380 ] 2 0.002% 99.986% ( 380, 580 ] 5 0.005% 99.992% ( 580, 870 ] 2 0.002% 99.994% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 3 0.003% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 531323 Average: 11.6791 StdDev: 137.87 Min: 0 Median: 1.9331 Max: 8516 Percentiles: P50: 1.93 P75: 2.93 P99: 9.87 P99.9: 745.84 P99.99: 934.24 ------------------------------------------------------ [ 0, 1 ] 12928 2.433% 2.433% ( 1, 2 ] 270856 50.978% 53.411% ########## ( 2, 3 ] 123193 23.186% 76.597% ##### ( 3, 4 ] 58481 11.007% 87.604% ## ( 4, 6 ] 51544 9.701% 97.305% ## ( 6, 10 ] 9313 1.753% 99.057% ( 10, 15 ] 2022 0.381% 99.438% ( 15, 22 ] 227 0.043% 99.481% ( 22, 34 ] 41 0.008% 99.488% ( 34, 51 ] 9 0.002% 99.490% ( 51, 76 ] 5 0.001% 99.491% ( 76, 110 ] 63 0.012% 99.503% ( 110, 170 ] 132 0.025% 99.528% ( 170, 250 ] 244 0.046% 99.574% ( 250, 380 ] 461 0.087% 99.660% ( 380, 580 ] 774 0.146% 99.806% ( 580, 870 ] 872 0.164% 99.970% ( 870, 1300 ] 702 0.132% 100.102% ( 1300, 1900 ] 360 0.068% 100.170% ( 1900, 2900 ] 290 0.055% 100.225% ( 2900, 4400 ] 290 0.055% 100.279% ( 4400, 6600 ] 82 0.015% 100.295% ( 6600, 9900 ] 7 0.001% 100.296% ** Level 4 read latency histogram (micros): Count: 126610 Average: 9.6539 StdDev: 123.88 Min: 0 Median: 1.9379 Max: 6175 Percentiles: P50: 1.94 P75: 2.90 P99: 10.77 P99.9: 1672.83 P99.99: 3634.01 ------------------------------------------------------ [ 0, 1 ] 1341 1.059% 1.059% ( 1, 2 ] 66065 52.180% 53.239% ########## ( 2, 3 ] 30504 24.093% 77.332% ##### ( 3, 4 ] 12821 10.126% 87.458% ## ( 4, 6 ] 11890 9.391% 96.849% ## ( 6, 10 ] 2641 2.086% 98.935% ( 10, 15 ] 535 0.423% 99.358% ( 15, 22 ] 70 0.055% 99.413% ( 22, 34 ] 15 0.012% 99.425% ( 34, 51 ] 1 0.001% 99.426% ( 51, 76 ] 3 0.002% 99.428% ( 76, 110 ] 16 0.013% 99.441% ( 110, 170 ] 30 0.024% 99.464% ( 170, 250 ] 86 0.068% 99.532% ( 250, 380 ] 63 0.050% 99.582% ( 380, 580 ] 131 0.103% 99.686% ( 580, 870 ] 123 0.097% 99.783% ( 870, 1300 ] 108 0.085% 99.868% ( 1300, 1900 ] 65 0.051% 99.919% ( 1900, 2900 ] 59 0.047% 99.966% ( 2900, 4400 ] 62 0.049% 100.015% ( 4400, 6600 ] 16 0.013% 100.028% ** Level 5 read latency histogram (micros): Count: 300 Average: 1358.6967 StdDev: 1492.09 Min: 78 Median: 740.0000 Max: 9277 Percentiles: P50: 740.00 P75: 2011.11 P99: 6430.77 P99.9: 9277.00 P99.99: 9277.00 ------------------------------------------------------ ( 76, 110 ] 15 5.000% 5.000% # ( 110, 170 ] 37 12.333% 17.333% ## ( 170, 250 ] 23 7.667% 25.000% ## ( 250, 380 ] 27 9.000% 34.000% ## ( 380, 580 ] 32 10.667% 44.667% ## ( 580, 870 ] 29 9.667% 54.333% ## ( 870, 1300 ] 29 9.667% 64.000% ## ( 1300, 1900 ] 30 10.000% 74.000% ## ( 1900, 2900 ] 27 9.000% 83.000% ## ( 2900, 4400 ] 36 12.000% 95.000% ## ( 4400, 6600 ] 13 4.333% 99.333% # ( 6600, 9900 ] 2 0.667% 100.000% ** DB Stats ** Uptime(secs): 57.7 total, 3.2 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 170.43 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.822 H:M:S, 51.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 303.16 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.639 H:M:S, 19.7 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.548 micros/op 180259 ops/sec 60.002 seconds 10815999 operations; 174.7 MB/s Microseconds per write: Count: 10815999 Average: 5.5476 StdDev: 563.46 Min: 0 Median: 1.7341 Max: 1059286 Percentiles: P50: 1.73 P75: 2.74 P99: 9.30 P99.9: 1092.19 P99.99: 2586.42 ------------------------------------------------------ [ 0, 1 ] 1471311 13.603% 13.603% ### ( 1, 2 ] 5362705 49.581% 63.184% ########## ( 2, 3 ] 1738687 16.075% 79.259% ### ( 3, 4 ] 1465463 13.549% 92.808% ### ( 4, 6 ] 562945 5.205% 98.013% # ( 6, 10 ] 129499 1.197% 99.211% ( 10, 15 ] 43900 0.406% 99.616% ( 15, 22 ] 9723 0.090% 99.706% ( 22, 34 ] 1690 0.016% 99.722% ( 34, 51 ] 242 0.002% 99.724% ( 51, 76 ] 28 0.000% 99.724% ( 76, 110 ] 7637 0.071% 99.795% ( 110, 170 ] 2747 0.025% 99.820% ( 170, 250 ] 372 0.003% 99.824% ( 250, 380 ] 180 0.002% 99.826% ( 380, 580 ] 17 0.000% 99.826% ( 580, 870 ] 17 0.000% 99.826% ( 870, 1300 ] 15521 0.144% 99.969% ( 1300, 1900 ] 30 0.000% 99.970% ( 1900, 2900 ] 3210 0.030% 99.999% ( 2900, 4400 ] 33 0.000% 100.000% ( 4400, 6600 ] 5 0.000% 100.000% ( 6600, 9900 ] 7 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 50000, 75000 ] 2 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 15 0.000% 100.000% ( 380000, 570000 ] 1 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% ( 860000, 1200000 ] 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 : 192034 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 : 10815999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 11162110968 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 : 552 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 30200607 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 : 29163821440 rocksdb.compact.write.bytes COUNT : 28961390883 rocksdb.flush.write.bytes COUNT : 11031306995 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 : 67 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 : 325 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 : 10942602240 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4474880 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 : 29269465981 rocksdb.non.last.level.read.count COUNT : 7064241 rocksdb.block.checksum.compute.count COUNT : 7063204 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.368671 P95 : 3.910209 P99 : 7.738206 P100 : 1059284.000000 COUNT : 10815999 SUM : 54895531 rocksdb.compaction.times.micros P50 : 1174814.814815 P95 : 4160000.000000 P99 : 15440000.000000 P100 : 20342437.000000 COUNT : 82 SUM : 144350915 rocksdb.compaction.times.cpu_micros P50 : 934634.146341 P95 : 4160000.000000 P99 : 15440000.000000 P100 : 18726674.000000 COUNT : 82 SUM : 114868682 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 : 667.349398 P95 : 3950.000000 P99 : 142400.000000 P100 : 483093.000000 COUNT : 146 SUM : 807196 rocksdb.compaction.outfile.sync.micros P50 : 1128.000000 P95 : 198571.428571 P99 : 363100.000000 P100 : 510913.000000 COUNT : 330 SUM : 10652885 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 : 108.827586 P95 : 2433.333333 P99 : 4092.500000 P100 : 5120.000000 COUNT : 264 SUM : 111129 rocksdb.table.open.io.micros P50 : 1695.744681 P95 : 8522.608696 P99 : 13836.000000 P100 : 20919.000000 COUNT : 552 SUM : 1307246 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.616127 P95 : 7.414949 P99 : 10.819591 P100 : 13630.000000 COUNT : 7061744 SUM : 44353589 rocksdb.read.block.get.micros P50 : 520.000000 P95 : 3681.967213 P99 : 5830.956522 P100 : 11318.000000 COUNT : 1104 SUM : 1050936 rocksdb.write.raw.block.micros P50 : 0.512804 P95 : 0.974327 P99 : 2.878971 P100 : 25580.000000 COUNT : 9695113 SUM : 20236413 rocksdb.numfiles.in.singlecompaction P50 : 3.288889 P95 : 3.998889 P99 : 19.060000 P100 : 24.000000 COUNT : 142 SUM : 541 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.566603 P95 : 1167.656202 P99 : 2408.654989 P100 : 1059094.000000 COUNT : 160283 SUM : 30219458 rocksdb.sst.read.micros P50 : 1.556626 P95 : 4.297235 P99 : 8.218063 P100 : 13625.000000 COUNT : 7064654 SUM : 30020031 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 : 10815999 SUM : 11162110968 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 : 213846.153846 P95 : 413250.000000 P99 : 1034533.333333 P100 : 1168365.000000 COUNT : 146 SUM : 33290501 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 : 329 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