[2024-11-18 16:42:33.283715] Starting SPDK v24.09.1-pre git sha1 b18e1bd62 / DPDK 22.11.4 initialization... [2024-11-18 16:42:33.283859] [ 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_pid1206663 ] Set seed to 1731944553280262 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-18 16:42:33.375423] app.c: 917:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-18 16:42:33.417406] app.c: 610:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-18 16:42:33.417454] app.c: 611:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1206663' to capture a snapshot of events at runtime. [2024-11-18 16:42:33.417464] app.c: 616:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-18 16:42:33.417475] app.c: 617:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-18 16:42:33.417483] app.c: 618:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1206663 for offline analysis/debug. [2024-11-18 16:42:33.417568] reactor.c: 990:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Mon Nov 18 16:42:37 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/18-16:42:40 ... thread 0: (1000000,1000000) ops and (357073.4,357073.4) ops/second in (2.800545,2.800545) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/6 567.04 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 353.0 2.32 2.09 12 0.193 0 0 0.0 0.0 L2 3/2 251.69 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.2 2.0 248.1 247.9 1.52 1.47 2 0.762 383K 238 0.0 0.0 L3 12/0 993.27 MB 1.0 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 85.57 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1180/8 96.94 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.3 1.5 98.3 311.3 3.84 3.56 14 0.275 383K 238 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.5 98.3 311.3 3.84 3.56 14 0.275 383K 238 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.1 247.9 1.52 1.47 2 0.762 383K 238 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 353.0 2.32 2.09 12 0.193 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, 401.83 MB/s write, 0.37 GB read, 126.90 MB/s read, 3.8 seconds Interval compaction: 1.17 GB write, 427.06 MB/s write, 0.37 GB read, 134.86 MB/s read, 3.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 100017 Average: 1.8537 StdDev: 19.97 Min: 0 Median: 1.1604 Max: 3290 Percentiles: P50: 1.16 P75: 1.62 P99: 3.69 P99.9: 9.30 P99.99: 249.97 ------------------------------------------------------ [ 0, 1 ] 41302 41.295% 41.295% ######## ( 1, 2 ] 54278 54.269% 95.564% ########### ( 2, 3 ] 2696 2.696% 98.259% # ( 3, 4 ] 1079 1.079% 99.338% ( 4, 6 ] 434 0.434% 99.772% ( 6, 10 ] 155 0.155% 99.927% ( 10, 15 ] 40 0.040% 99.967% ( 15, 22 ] 7 0.007% 99.974% ( 22, 34 ] 2 0.002% 99.976% ( 51, 76 ] 1 0.001% 99.977% ( 110, 170 ] 8 0.008% 99.985% ( 170, 250 ] 5 0.005% 99.990% ( 250, 380 ] 3 0.003% 99.993% ( 380, 580 ] 1 0.001% 99.994% ( 870, 1300 ] 2 0.002% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 2900, 4400 ] 3 0.003% 100.001% ** Level 1 read latency histogram (micros): Count: 5 Average: 1737.2000 StdDev: 1505.30 Min: 424 Median: 725.0000 Max: 3897 Percentiles: P50: 725.00 P75: 3462.50 P99: 3897.00 P99.9: 3897.00 P99.99: 3897.00 ------------------------------------------------------ ( 380, 580 ] 2 40.000% 40.000% ######## ( 580, 870 ] 1 20.000% 60.000% #### ( 2900, 4400 ] 2 40.000% 100.000% ######## ** Level 2 read latency histogram (micros): Count: 51046 Average: 1.8295 StdDev: 6.18 Min: 0 Median: 1.2426 Max: 865 Percentiles: P50: 1.24 P75: 1.68 P99: 4.78 P99.9: 9.78 P99.99: 308.19 ------------------------------------------------------ [ 0, 1 ] 18443 36.130% 36.130% ####### ( 1, 2 ] 29186 57.176% 93.306% ########### ( 2, 3 ] 1881 3.685% 96.991% # ( 3, 4 ] 832 1.630% 98.621% ( 4, 6 ] 500 0.980% 99.600% ( 6, 10 ] 163 0.319% 99.920% ( 10, 15 ] 30 0.059% 99.978% ( 15, 22 ] 4 0.008% 99.986% ( 22, 34 ] 1 0.002% 99.988% ( 34, 51 ] 1 0.002% 99.990% ( 250, 380 ] 2 0.004% 99.994% ( 380, 580 ] 1 0.002% 99.996% ( 580, 870 ] 3 0.006% 100.002% ** Level 3 read latency histogram (micros): Count: 55 Average: 1642.7636 StdDev: 1435.86 Min: 52 Median: 1063.5000 Max: 5634 Percentiles: P50: 1063.50 P75: 2792.86 P99: 5634.00 P99.9: 5634.00 P99.99: 5634.00 ------------------------------------------------------ ( 51, 76 ] 1 1.818% 1.818% ( 170, 250 ] 2 3.636% 5.455% # ( 250, 380 ] 7 12.727% 18.182% ### ( 380, 580 ] 6 10.909% 29.091% ## ( 580, 870 ] 7 12.727% 41.818% ### ( 870, 1300 ] 10 18.182% 60.000% #### ( 1300, 1900 ] 2 3.636% 63.636% # ( 1900, 2900 ] 7 12.727% 76.364% ### ( 2900, 4400 ] 9 16.364% 92.727% ### ( 4400, 6600 ] 4 7.273% 100.000% # ** Level 4 read latency histogram (micros): Count: 20 Average: 1757.3000 StdDev: 1264.63 Min: 291 Median: 1300.0000 Max: 5495 Percentiles: P50: 1300.00 P75: 2650.00 P99: 5495.00 P99.9: 5495.00 P99.99: 5495.00 ------------------------------------------------------ ( 250, 380 ] 1 5.000% 5.000% # ( 380, 580 ] 2 10.000% 15.000% ## ( 580, 870 ] 3 15.000% 30.000% ### ( 870, 1300 ] 4 20.000% 50.000% #### ( 1300, 1900 ] 2 10.000% 60.000% ## ( 1900, 2900 ] 4 20.000% 80.000% #### ( 2900, 4400 ] 3 15.000% 95.000% ### ( 4400, 6600 ] 1 5.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, 330.47 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.14 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/18-16:42:43 ... thread 0: (1000000,2000000) ops and (326507.9,341107.3) ops/second in (3.062713,5.863258) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/12 1.17 GB 12.6 0.2 0.0 0.2 2.0 1.8 0.0 1.1 40.9 337.3 6.16 5.56 27 0.228 255K 254 0.0 0.0 L1 1/1 3.88 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 239.0 238.5 1.58 1.53 1 1.582 383K 635 0.0 0.0 L2 2/1 55.63 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 248.1 247.9 1.52 1.47 2 0.762 383K 238 0.0 0.0 L3 18/8 1023.92 MB 0.3 0.2 0.2 0.0 0.2 0.2 0.4 1.0 228.4 228.4 1.09 1.01 1 1.091 252K 0 0.0 0.0 L4 169/0 9.45 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 157.5 157.5 1.42 1.03 1 1.422 227K 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 1252/22 97.92 GB 0.0 1.4 1.0 0.4 3.2 2.8 2.2 1.8 125.7 280.7 11.78 10.61 32 0.368 1503K 1127 0.0 0.0 Int 0/0 0.00 KB 0.0 1.4 1.0 0.4 3.2 2.8 2.1 1.8 125.7 280.7 11.78 10.61 32 0.368 1503K 1127 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.4 1.0 0.4 1.4 1.0 0.0 0.0 223.9 223.7 6.62 6.03 6 1.103 1503K 1127 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.8 1.8 0.0 0.0 0.0 353.7 5.16 4.59 26 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.0 total, 5.9 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.23 GB write, 547.41 MB/s write, 1.45 GB read, 245.17 MB/s read, 11.8 seconds Interval compaction: 3.23 GB write, 563.83 MB/s write, 1.45 GB read, 252.52 MB/s read, 11.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 339653 Average: 2.1633 StdDev: 12.50 Min: 0 Median: 1.4607 Max: 3290 Percentiles: P50: 1.46 P75: 1.85 P99: 5.57 P99.9: 11.18 P99.99: 20.26 ------------------------------------------------------ [ 0, 1 ] 69856 20.567% 20.567% #### ( 1, 2 ] 217006 63.891% 84.457% ############# ( 2, 3 ] 31346 9.229% 93.686% ## ( 3, 4 ] 12506 3.682% 97.368% # ( 4, 6 ] 7083 2.085% 99.454% ( 6, 10 ] 1430 0.421% 99.875% ( 10, 15 ] 369 0.109% 99.983% ( 15, 22 ] 32 0.009% 99.993% ( 22, 34 ] 8 0.002% 99.995% ( 51, 76 ] 5 0.001% 99.996% ( 76, 110 ] 1 0.000% 99.997% ( 110, 170 ] 10 0.003% 100.000% ( 170, 250 ] 15 0.004% 100.004% ( 250, 380 ] 8 0.002% 100.006% ( 380, 580 ] 6 0.002% 100.008% ( 580, 870 ] 5 0.001% 100.010% ( 870, 1300 ] 3 0.001% 100.011% ( 1300, 1900 ] 3 0.001% 100.011% ( 1900, 2900 ] 1 0.000% 100.012% ( 2900, 4400 ] 3 0.001% 100.013% ** Level 1 read latency histogram (micros): Count: 31 Average: 438.1613 StdDev: 890.07 Min: 1 Median: 2.5000 Max: 3897 Percentiles: P50: 2.50 P75: 505.00 P99: 3897.00 P99.9: 3897.00 P99.99: 3897.00 ------------------------------------------------------ [ 0, 1 ] 8 25.806% 25.806% ##### ( 1, 2 ] 7 22.581% 48.387% ##### ( 2, 3 ] 1 3.226% 51.613% # ( 4, 6 ] 1 3.226% 54.839% # ( 6, 10 ] 1 3.226% 58.065% # ( 110, 170 ] 1 3.226% 61.290% # ( 170, 250 ] 1 3.226% 64.516% # ( 250, 380 ] 2 6.452% 70.968% # ( 380, 580 ] 2 6.452% 77.419% # ( 580, 870 ] 2 6.452% 83.871% # ( 870, 1300 ] 3 9.677% 93.548% ## ( 2900, 4400 ] 2 6.452% 100.000% # ** Level 2 read latency histogram (micros): Count: 95741 Average: 2.0259 StdDev: 4.56 Min: 0 Median: 1.4114 Max: 865 Percentiles: P50: 1.41 P75: 1.81 P99: 5.48 P99.9: 9.81 P99.99: 20.16 ------------------------------------------------------ [ 0, 1 ] 23417 24.459% 24.459% ##### ( 1, 2 ] 59441 62.085% 86.544% ############ ( 2, 3 ] 7462 7.794% 94.338% ## ( 3, 4 ] 3079 3.216% 97.554% # ( 4, 6 ] 1868 1.951% 99.505% ( 6, 10 ] 397 0.415% 99.920% ( 10, 15 ] 63 0.066% 99.985% ( 15, 22 ] 6 0.006% 99.992% ( 22, 34 ] 1 0.001% 99.993% ( 34, 51 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.002% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 171301 Average: 3.4073 StdDev: 41.65 Min: 1 Median: 1.6045 Max: 5634 Percentiles: P50: 1.60 P75: 1.99 P99: 8.61 P99.9: 202.55 P99.99: 779.32 ------------------------------------------------------ [ 0, 1 ] 18557 10.833% 10.833% ## ( 1, 2 ] 110988 64.791% 75.624% ############# ( 2, 3 ] 26738 15.609% 91.233% ### ( 3, 4 ] 6943 4.053% 95.286% # ( 4, 6 ] 4815 2.811% 98.097% # ( 6, 10 ] 2369 1.383% 99.480% ( 10, 15 ] 336 0.196% 99.676% ( 15, 22 ] 74 0.043% 99.719% ( 22, 34 ] 19 0.011% 99.730% ( 34, 51 ] 3 0.002% 99.732% ( 51, 76 ] 5 0.003% 99.735% ( 76, 110 ] 97 0.057% 99.792% ( 110, 170 ] 156 0.091% 99.883% ( 170, 250 ] 73 0.043% 99.925% ( 250, 380 ] 52 0.030% 99.956% ( 380, 580 ] 41 0.024% 99.980% ( 580, 870 ] 26 0.015% 99.995% ( 870, 1300 ] 16 0.009% 100.004% ( 1300, 1900 ] 3 0.002% 100.006% ( 1900, 2900 ] 7 0.004% 100.010% ( 2900, 4400 ] 9 0.005% 100.015% ( 4400, 6600 ] 4 0.002% 100.018% ** Level 4 read latency histogram (micros): Count: 305 Average: 121.9311 StdDev: 541.65 Min: 0 Median: 1.3352 Max: 5495 Percentiles: P50: 1.34 P75: 5.50 P99: 3375.00 P99.9: 5495.00 P99.99: 5495.00 ------------------------------------------------------ [ 0, 1 ] 122 40.000% 40.000% ######## ( 1, 2 ] 91 29.836% 69.836% ###### ( 2, 3 ] 7 2.295% 72.131% ( 3, 4 ] 2 0.656% 72.787% ( 4, 6 ] 9 2.951% 75.738% # ( 6, 10 ] 37 12.131% 87.869% ## ( 10, 15 ] 11 3.607% 91.475% # ( 76, 110 ] 1 0.328% 91.803% ( 110, 170 ] 2 0.656% 92.459% ( 170, 250 ] 1 0.328% 92.787% ( 250, 380 ] 3 0.984% 93.770% ( 380, 580 ] 2 0.656% 94.426% ( 580, 870 ] 3 0.984% 95.410% ( 870, 1300 ] 4 1.311% 96.721% ( 1300, 1900 ] 2 0.656% 97.377% ( 1900, 2900 ] 4 1.311% 98.689% ( 2900, 4400 ] 3 0.984% 99.672% ( 4400, 6600 ] 1 0.328% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 743.7000 StdDev: 967.39 Min: 85 Median: 250.0000 Max: 4545 Percentiles: P50: 250.00 P75: 870.00 P99: 4545.00 P99.9: 4545.00 P99.99: 4545.00 ------------------------------------------------------ ( 76, 110 ] 5 12.500% 12.500% ### ( 110, 170 ] 11 27.500% 40.000% ###### ( 170, 250 ] 4 10.000% 50.000% ## ( 250, 380 ] 3 7.500% 57.500% ## ( 380, 580 ] 3 7.500% 65.000% ## ( 580, 870 ] 4 10.000% 75.000% ## ( 870, 1300 ] 1 2.500% 77.500% # ( 1300, 1900 ] 3 7.500% 85.000% ## ( 1900, 2900 ] 5 12.500% 97.500% ### ( 4400, 6600 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 6.0 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 325.84 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.603 H:M:S, 10.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.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.387 H:M:S, 12.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/18-16:42:46 ... thread 0: (1000000,3000000) ops and (322246.9,334579.9) ops/second in (3.103211,8.966469) 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/4 1.41 GB 113.3 1.4 0.0 1.4 4.1 2.8 0.0 1.5 103.7 315.6 13.37 12.36 45 0.297 1407K 1511 0.0 0.0 L1 3/0 244.22 MB 24.4 1.1 1.1 0.0 1.1 1.1 0.2 1.0 233.2 232.5 4.88 4.75 2 2.439 1155K 3148 0.0 0.0 L2 3/2 383.96 MB 1.3 0.4 0.2 0.2 0.4 0.2 1.0 2.0 248.1 247.9 1.52 1.47 2 0.762 383K 238 0.0 0.0 L3 15/1 690.86 MB 0.6 1.2 0.4 0.8 1.2 0.4 0.4 2.9 224.1 223.7 5.65 5.28 4 1.412 1285K 2347 0.0 0.0 L4 169/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 157.5 157.5 1.42 1.03 1 1.422 227K 0 0.0 0.0 L5 1052/0 86.55 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1250/7 98.90 GB 0.0 4.3 1.9 2.4 7.0 4.7 3.5 2.5 163.6 268.9 26.84 24.89 54 0.497 4459K 7244 0.0 0.0 Int 0/0 0.00 KB 0.0 4.3 1.9 2.4 7.0 4.7 3.4 2.5 163.6 268.9 26.84 24.89 54 0.497 4459K 7244 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.3 1.9 2.4 4.3 1.9 0.0 0.0 233.3 232.9 18.82 17.78 14 1.345 4459K 7244 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 353.6 8.02 7.11 40 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): 9.1 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: 7.05 GB write, 789.45 MB/s write, 4.29 GB read, 480.24 MB/s read, 26.8 seconds Interval compaction: 7.05 GB write, 804.94 MB/s write, 4.29 GB read, 489.66 MB/s read, 26.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 10, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 10, interval: 10 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 706718 Average: 2.2772 StdDev: 10.92 Min: 0 Median: 1.5360 Max: 3290 Percentiles: P50: 1.54 P75: 1.92 P99: 5.74 P99.9: 10.68 P99.99: 14.61 ------------------------------------------------------ [ 0, 1 ] 107782 15.251% 15.251% ### ( 1, 2 ] 458200 64.835% 80.086% ############# ( 2, 3 ] 81683 11.558% 91.644% ## ( 3, 4 ] 33309 4.713% 96.357% # ( 4, 6 ] 21456 3.036% 99.393% # ( 6, 10 ] 3473 0.491% 99.885% ( 10, 15 ] 808 0.114% 99.999% ( 15, 22 ] 97 0.014% 100.013% ( 22, 34 ] 11 0.002% 100.014% ( 34, 51 ] 4 0.001% 100.015% ( 51, 76 ] 7 0.001% 100.016% ( 76, 110 ] 1 0.000% 100.016% ( 110, 170 ] 11 0.002% 100.018% ( 170, 250 ] 26 0.004% 100.021% ( 250, 380 ] 16 0.002% 100.023% ( 380, 580 ] 9 0.001% 100.025% ( 580, 870 ] 12 0.002% 100.026% ( 870, 1300 ] 6 0.001% 100.027% ( 1300, 1900 ] 3 0.000% 100.028% ( 1900, 2900 ] 5 0.001% 100.028% ( 2900, 4400 ] 3 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 177069 Average: 2.8153 StdDev: 16.03 Min: 0 Median: 1.7279 Max: 3897 Percentiles: P50: 1.73 P75: 2.43 P99: 7.76 P99.9: 13.70 P99.99: 115.15 ------------------------------------------------------ [ 0, 1 ] 8260 4.665% 4.665% # ( 1, 2 ] 110284 62.283% 66.948% ############ ( 2, 3 ] 33146 18.719% 85.667% #### ( 3, 4 ] 12636 7.136% 92.803% # ( 4, 6 ] 9926 5.606% 98.409% # ( 6, 10 ] 2381 1.345% 99.754% ( 10, 15 ] 351 0.198% 99.952% ( 15, 22 ] 48 0.027% 99.979% ( 22, 34 ] 4 0.002% 99.981% ( 34, 51 ] 2 0.001% 99.982% ( 51, 76 ] 1 0.001% 99.983% ( 76, 110 ] 9 0.005% 99.988% ( 110, 170 ] 50 0.028% 100.016% ( 170, 250 ] 23 0.013% 100.029% ( 250, 380 ] 17 0.010% 100.039% ( 380, 580 ] 8 0.005% 100.043% ( 580, 870 ] 8 0.005% 100.048% ( 870, 1300 ] 9 0.005% 100.053% ( 2900, 4400 ] 2 0.001% 100.054% ** Level 2 read latency histogram (micros): Count: 95889 Average: 2.0273 StdDev: 4.56 Min: 0 Median: 1.4123 Max: 865 Percentiles: P50: 1.41 P75: 1.82 P99: 5.48 P99.9: 9.81 P99.99: 20.15 ------------------------------------------------------ [ 0, 1 ] 23417 24.421% 24.421% ##### ( 1, 2 ] 59495 62.046% 86.467% ############ ( 2, 3 ] 7533 7.856% 94.323% ## ( 3, 4 ] 3093 3.226% 97.548% # ( 4, 6 ] 1875 1.955% 99.504% ( 6, 10 ] 399 0.416% 99.920% ( 10, 15 ] 63 0.066% 99.985% ( 15, 22 ] 6 0.006% 99.992% ( 22, 34 ] 1 0.001% 99.993% ( 34, 51 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.002% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 207325 Average: 3.3794 StdDev: 38.73 Min: 1 Median: 1.6246 Max: 5634 Percentiles: P50: 1.62 P75: 2.05 P99: 8.65 P99.9: 202.85 P99.99: 797.66 ------------------------------------------------------ [ 0, 1 ] 20188 9.737% 9.737% ## ( 1, 2 ] 133637 64.458% 74.195% ############# ( 2, 3 ] 33389 16.105% 90.300% ### ( 3, 4 ] 9454 4.560% 94.860% # ( 4, 6 ] 6595 3.181% 98.041% # ( 6, 10 ] 2997 1.446% 99.486% ( 10, 15 ] 401 0.193% 99.680% ( 15, 22 ] 90 0.043% 99.723% ( 22, 34 ] 24 0.012% 99.735% ( 34, 51 ] 3 0.001% 99.736% ( 51, 76 ] 5 0.002% 99.739% ( 76, 110 ] 117 0.056% 99.795% ( 110, 170 ] 184 0.089% 99.884% ( 170, 250 ] 82 0.040% 99.923% ( 250, 380 ] 65 0.031% 99.955% ( 380, 580 ] 50 0.024% 99.979% ( 580, 870 ] 31 0.015% 99.994% ( 870, 1300 ] 18 0.009% 100.002% ( 1300, 1900 ] 5 0.002% 100.005% ( 1900, 2900 ] 7 0.003% 100.008% ( 2900, 4400 ] 9 0.004% 100.013% ( 4400, 6600 ] 4 0.002% 100.014% ** Level 4 read latency histogram (micros): Count: 305 Average: 121.9311 StdDev: 541.65 Min: 0 Median: 1.3352 Max: 5495 Percentiles: P50: 1.34 P75: 5.50 P99: 3375.00 P99.9: 5495.00 P99.99: 5495.00 ------------------------------------------------------ [ 0, 1 ] 122 40.000% 40.000% ######## ( 1, 2 ] 91 29.836% 69.836% ###### ( 2, 3 ] 7 2.295% 72.131% ( 3, 4 ] 2 0.656% 72.787% ( 4, 6 ] 9 2.951% 75.738% # ( 6, 10 ] 37 12.131% 87.869% ## ( 10, 15 ] 11 3.607% 91.475% # ( 76, 110 ] 1 0.328% 91.803% ( 110, 170 ] 2 0.656% 92.459% ( 170, 250 ] 1 0.328% 92.787% ( 250, 380 ] 3 0.984% 93.770% ( 380, 580 ] 2 0.656% 94.426% ( 580, 870 ] 3 0.984% 95.410% ( 870, 1300 ] 4 1.311% 96.721% ( 1300, 1900 ] 2 0.656% 97.377% ( 1900, 2900 ] 4 1.311% 98.689% ( 2900, 4400 ] 3 0.984% 99.672% ( 4400, 6600 ] 1 0.328% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 703.8167 StdDev: 887.37 Min: 80 Median: 236.6667 Max: 4545 Percentiles: P50: 236.67 P75: 870.00 P99: 4545.00 P99.9: 4545.00 P99.99: 4545.00 ------------------------------------------------------ ( 76, 110 ] 8 13.333% 13.333% ### ( 110, 170 ] 17 28.333% 41.667% ###### ( 170, 250 ] 6 10.000% 51.667% ## ( 250, 380 ] 3 5.000% 56.667% # ( 380, 580 ] 4 6.667% 63.333% # ( 580, 870 ] 7 11.667% 75.000% ## ( 870, 1300 ] 1 1.667% 76.667% ( 1300, 1900 ] 6 10.000% 86.667% ## ( 1900, 2900 ] 7 11.667% 98.333% ## ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 9.1 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 322.89 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.992 H:M:S, 10.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 317.15 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.390 H:M:S, 12.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/18-16:42:49 ... thread 0: (1000000,4000000) ops and (337260.5,335246.0) ops/second in (2.965067,11.931536) 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 2.34 GB 12.6 2.2 0.0 2.2 5.9 3.7 0.0 1.6 117.3 312.6 19.34 17.96 61 0.317 2302K 2477 0.0 0.0 L1 3/3 244.22 MB 0.0 1.1 1.1 0.0 1.1 1.1 0.2 1.0 233.2 232.5 4.88 4.75 2 2.439 1155K 3148 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 1.0 2.0 248.1 247.9 1.52 1.47 2 0.762 383K 238 0.0 0.0 L3 22/0 984.68 MB 1.0 1.8 0.8 1.0 1.8 0.8 0.4 2.3 224.5 224.0 8.27 7.79 6 1.379 1886K 3834 0.0 0.0 L4 171/0 9.73 GB 1.0 0.3 0.3 0.0 0.3 0.3 0.8 1.0 163.7 163.6 1.77 1.31 2 0.883 281K 0 0.0 0.0 L5 1052/0 86.55 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1260/13 99.82 GB 0.0 5.8 2.4 3.4 9.5 6.0 3.5 2.6 165.7 271.1 35.78 33.29 73 0.490 6009K 9697 0.0 0.0 Int 0/0 0.00 KB 0.0 5.8 2.4 3.4 9.5 6.0 3.4 2.6 165.7 271.1 35.78 33.29 73 0.490 6009K 9697 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.4 3.4 5.8 2.4 0.0 0.0 236.3 235.9 25.09 23.81 20 1.254 6009K 9697 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 353.6 10.69 9.48 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.1 total, 11.9 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.47 GB write, 801.02 MB/s write, 5.79 GB read, 489.71 MB/s read, 35.8 seconds Interval compaction: 9.47 GB write, 812.83 MB/s write, 5.79 GB read, 496.93 MB/s read, 35.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 945115 Average: 2.2453 StdDev: 11.83 Min: 0 Median: 1.5059 Max: 3567 Percentiles: P50: 1.51 P75: 1.89 P99: 5.68 P99.9: 10.97 P99.99: 17.71 ------------------------------------------------------ [ 0, 1 ] 162096 17.151% 17.151% ### ( 1, 2 ] 613663 64.930% 82.081% ############# ( 2, 3 ] 99308 10.508% 92.588% ## ( 3, 4 ] 39774 4.208% 96.797% # ( 4, 6 ] 24800 2.624% 99.421% # ( 6, 10 ] 4338 0.459% 99.880% ( 10, 15 ] 999 0.106% 99.986% ( 15, 22 ] 115 0.012% 99.998% ( 22, 34 ] 12 0.001% 99.999% ( 34, 51 ] 4 0.000% 99.999% ( 51, 76 ] 12 0.001% 100.001% ( 76, 110 ] 22 0.002% 100.003% ( 110, 170 ] 71 0.008% 100.010% ( 170, 250 ] 47 0.005% 100.015% ( 250, 380 ] 24 0.003% 100.018% ( 380, 580 ] 20 0.002% 100.020% ( 580, 870 ] 18 0.002% 100.022% ( 870, 1300 ] 10 0.001% 100.023% ( 1300, 1900 ] 4 0.000% 100.023% ( 1900, 2900 ] 5 0.001% 100.024% ( 2900, 4400 ] 6 0.001% 100.025% ** Level 1 read latency histogram (micros): Count: 254087 Average: 2.6873 StdDev: 14.00 Min: 0 Median: 1.6731 Max: 3897 Percentiles: P50: 1.67 P75: 2.23 P99: 7.43 P99.9: 13.98 P99.99: 151.11 ------------------------------------------------------ [ 0, 1 ] 16763 6.597% 6.597% # ( 1, 2 ] 163835 64.480% 71.077% ############# ( 2, 3 ] 43087 16.958% 88.035% ### ( 3, 4 ] 15250 6.002% 94.037% # ( 4, 6 ] 11542 4.543% 98.579% # ( 6, 10 ] 2996 1.179% 99.758% ( 10, 15 ] 452 0.178% 99.936% ( 15, 22 ] 57 0.022% 99.959% ( 22, 34 ] 6 0.002% 99.961% ( 34, 51 ] 3 0.001% 99.962% ( 51, 76 ] 1 0.000% 99.963% ( 76, 110 ] 23 0.009% 99.972% ( 110, 170 ] 68 0.027% 99.998% ( 170, 250 ] 40 0.016% 100.014% ( 250, 380 ] 23 0.009% 100.023% ( 380, 580 ] 15 0.006% 100.029% ( 580, 870 ] 10 0.004% 100.033% ( 870, 1300 ] 9 0.004% 100.037% ( 2900, 4400 ] 2 0.001% 100.037% ** Level 2 read latency histogram (micros): Count: 95889 Average: 2.0273 StdDev: 4.56 Min: 0 Median: 1.4123 Max: 865 Percentiles: P50: 1.41 P75: 1.82 P99: 5.48 P99.9: 9.81 P99.99: 20.15 ------------------------------------------------------ [ 0, 1 ] 23417 24.421% 24.421% ##### ( 1, 2 ] 59495 62.046% 86.467% ############ ( 2, 3 ] 7533 7.856% 94.323% ## ( 3, 4 ] 3093 3.226% 97.548% # ( 4, 6 ] 1875 1.955% 99.504% ( 6, 10 ] 399 0.416% 99.920% ( 10, 15 ] 63 0.066% 99.985% ( 15, 22 ] 6 0.006% 99.992% ( 22, 34 ] 1 0.001% 99.993% ( 34, 51 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.002% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 224975 Average: 3.3076 StdDev: 37.29 Min: 0 Median: 1.6173 Max: 5634 Percentiles: P50: 1.62 P75: 2.01 P99: 8.49 P99.9: 196.38 P99.99: 783.93 ------------------------------------------------------ [ 0, 1 ] 22194 9.865% 9.865% ## ( 1, 2 ] 146272 65.017% 74.882% ############# ( 2, 3 ] 35438 15.752% 90.634% ### ( 3, 4 ] 10022 4.455% 95.089% # ( 4, 6 ] 6910 3.071% 98.160% # ( 6, 10 ] 3035 1.349% 99.509% ( 10, 15 ] 414 0.184% 99.693% ( 15, 22 ] 93 0.041% 99.735% ( 22, 34 ] 25 0.011% 99.746% ( 34, 51 ] 4 0.002% 99.748% ( 51, 76 ] 5 0.002% 99.750% ( 76, 110 ] 117 0.052% 99.802% ( 110, 170 ] 193 0.086% 99.888% ( 170, 250 ] 85 0.038% 99.925% ( 250, 380 ] 70 0.031% 99.956% ( 380, 580 ] 53 0.024% 99.980% ( 580, 870 ] 32 0.014% 99.994% ( 870, 1300 ] 18 0.008% 100.002% ( 1300, 1900 ] 5 0.002% 100.004% ( 1900, 2900 ] 7 0.003% 100.008% ( 2900, 4400 ] 9 0.004% 100.012% ( 4400, 6600 ] 4 0.002% 100.013% ** Level 4 read latency histogram (micros): Count: 3325 Average: 23.2439 StdDev: 174.73 Min: 0 Median: 1.5125 Max: 5495 Percentiles: P50: 1.51 P75: 1.92 P99: 378.80 P99.9: 3237.50 P99.99: 5495.00 ------------------------------------------------------ [ 0, 1 ] 617 18.556% 18.556% #### ( 1, 2 ] 2040 61.353% 79.910% ############ ( 2, 3 ] 216 6.496% 86.406% # ( 3, 4 ] 85 2.556% 88.962% # ( 4, 6 ] 45 1.353% 90.316% ( 6, 10 ] 89 2.677% 92.992% # ( 10, 15 ] 11 0.331% 93.323% ( 15, 22 ] 1 0.030% 93.353% ( 51, 76 ] 7 0.211% 93.564% ( 76, 110 ] 70 2.105% 95.669% ( 110, 170 ] 60 1.805% 97.474% ( 170, 250 ] 24 0.722% 98.195% ( 250, 380 ] 27 0.812% 99.008% ( 380, 580 ] 11 0.331% 99.338% ( 580, 870 ] 8 0.241% 99.579% ( 870, 1300 ] 4 0.120% 99.699% ( 1300, 1900 ] 2 0.060% 99.759% ( 1900, 2900 ] 4 0.120% 99.880% ( 2900, 4400 ] 3 0.090% 99.970% ( 4400, 6600 ] 1 0.030% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 703.8167 StdDev: 887.37 Min: 80 Median: 236.6667 Max: 4545 Percentiles: P50: 236.67 P75: 870.00 P99: 4545.00 P99.9: 4545.00 P99.99: 4545.00 ------------------------------------------------------ ( 76, 110 ] 8 13.333% 13.333% ### ( 110, 170 ] 17 28.333% 41.667% ###### ( 170, 250 ] 6 10.000% 51.667% ## ( 250, 380 ] 3 5.000% 56.667% # ( 380, 580 ] 4 6.667% 63.333% # ( 580, 870 ] 7 11.667% 75.000% ## ( 870, 1300 ] 1 1.667% 76.667% ( 1300, 1900 ] 6 10.000% 86.667% ## ( 1900, 2900 ] 7 11.667% 98.333% ## ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 12.1 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 325.11 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.355 H:M:S, 11.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 331.93 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.362 H:M:S, 12.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/18-16:42:53 ... thread 0: (1000000,5000000) ops and (286539.4,324223.6) ops/second in (3.489922,15.421458) 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/14 3.38 GB 94.4 3.1 0.0 3.1 7.8 4.7 0.0 1.6 122.4 310.7 25.73 23.99 79 0.326 3198K 3488 0.0 0.0 L1 3/3 244.22 MB 0.0 1.1 1.1 0.0 1.1 1.1 0.2 1.0 233.2 232.5 4.88 4.75 2 2.439 1155K 3148 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 1.0 2.0 248.1 247.9 1.52 1.47 2 0.762 383K 238 0.0 0.0 L3 22/0 984.68 MB 1.0 1.8 0.8 1.0 1.8 0.8 0.4 2.3 224.5 224.0 8.27 7.79 6 1.379 1886K 3834 0.0 0.0 L4 171/0 9.73 GB 1.0 0.3 0.3 0.0 0.3 0.3 0.8 1.0 163.7 163.6 1.77 1.31 2 0.883 281K 0 0.0 0.0 L5 1052/0 86.55 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1266/17 100.86 GB 0.0 6.7 2.4 4.3 11.4 7.1 3.5 2.4 161.5 276.2 42.18 39.31 91 0.463 6904K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.7 2.4 4.3 11.4 7.1 3.4 2.4 161.5 276.2 42.18 39.31 91 0.463 6904K 10K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.7 2.4 4.3 6.6 2.3 0.0 0.0 239.4 239.0 28.46 27.11 23 1.237 6904K 10K 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.20 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.6 total, 15.4 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: 11.38 GB write, 746.94 MB/s write, 6.65 GB read, 436.69 MB/s read, 42.2 seconds Interval compaction: 11.38 GB write, 755.46 MB/s write, 6.65 GB read, 441.67 MB/s read, 42.2 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: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 16, interval: 19 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1401867 Average: 2.2279 StdDev: 10.18 Min: 0 Median: 1.5102 Max: 3567 Percentiles: P50: 1.51 P75: 1.89 P99: 5.68 P99.9: 10.76 P99.99: 14.77 ------------------------------------------------------ [ 0, 1 ] 230337 16.431% 16.431% ### ( 1, 2 ] 922421 65.799% 82.230% ############# ( 2, 3 ] 150530 10.738% 92.968% ## ( 3, 4 ] 56043 3.998% 96.966% # ( 4, 6 ] 33925 2.420% 99.386% ( 6, 10 ] 6970 0.497% 99.883% ( 10, 15 ] 1572 0.112% 99.995% ( 15, 22 ] 166 0.012% 100.007% ( 22, 34 ] 18 0.001% 100.008% ( 34, 51 ] 4 0.000% 100.008% ( 51, 76 ] 13 0.001% 100.009% ( 76, 110 ] 35 0.002% 100.012% ( 110, 170 ] 82 0.006% 100.018% ( 170, 250 ] 60 0.004% 100.022% ( 250, 380 ] 33 0.002% 100.024% ( 380, 580 ] 27 0.002% 100.026% ( 580, 870 ] 24 0.002% 100.028% ( 870, 1300 ] 16 0.001% 100.029% ( 1300, 1900 ] 4 0.000% 100.029% ( 1900, 2900 ] 5 0.000% 100.030% ( 2900, 4400 ] 6 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 254087 Average: 2.6873 StdDev: 14.00 Min: 0 Median: 1.6731 Max: 3897 Percentiles: P50: 1.67 P75: 2.23 P99: 7.43 P99.9: 13.98 P99.99: 151.11 ------------------------------------------------------ [ 0, 1 ] 16763 6.597% 6.597% # ( 1, 2 ] 163835 64.480% 71.077% ############# ( 2, 3 ] 43087 16.958% 88.035% ### ( 3, 4 ] 15250 6.002% 94.037% # ( 4, 6 ] 11542 4.543% 98.579% # ( 6, 10 ] 2996 1.179% 99.758% ( 10, 15 ] 452 0.178% 99.936% ( 15, 22 ] 57 0.022% 99.959% ( 22, 34 ] 6 0.002% 99.961% ( 34, 51 ] 3 0.001% 99.962% ( 51, 76 ] 1 0.000% 99.963% ( 76, 110 ] 23 0.009% 99.972% ( 110, 170 ] 68 0.027% 99.998% ( 170, 250 ] 40 0.016% 100.014% ( 250, 380 ] 23 0.009% 100.023% ( 380, 580 ] 15 0.006% 100.029% ( 580, 870 ] 10 0.004% 100.033% ( 870, 1300 ] 9 0.004% 100.037% ( 2900, 4400 ] 2 0.001% 100.037% ** Level 2 read latency histogram (micros): Count: 95889 Average: 2.0273 StdDev: 4.56 Min: 0 Median: 1.4123 Max: 865 Percentiles: P50: 1.41 P75: 1.82 P99: 5.48 P99.9: 9.81 P99.99: 20.15 ------------------------------------------------------ [ 0, 1 ] 23417 24.421% 24.421% ##### ( 1, 2 ] 59495 62.046% 86.467% ############ ( 2, 3 ] 7533 7.856% 94.323% ## ( 3, 4 ] 3093 3.226% 97.548% # ( 4, 6 ] 1875 1.955% 99.504% ( 6, 10 ] 399 0.416% 99.920% ( 10, 15 ] 63 0.066% 99.985% ( 15, 22 ] 6 0.006% 99.992% ( 22, 34 ] 1 0.001% 99.993% ( 34, 51 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.002% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 224975 Average: 3.3076 StdDev: 37.29 Min: 0 Median: 1.6173 Max: 5634 Percentiles: P50: 1.62 P75: 2.01 P99: 8.49 P99.9: 196.38 P99.99: 783.93 ------------------------------------------------------ [ 0, 1 ] 22194 9.865% 9.865% ## ( 1, 2 ] 146272 65.017% 74.882% ############# ( 2, 3 ] 35438 15.752% 90.634% ### ( 3, 4 ] 10022 4.455% 95.089% # ( 4, 6 ] 6910 3.071% 98.160% # ( 6, 10 ] 3035 1.349% 99.509% ( 10, 15 ] 414 0.184% 99.693% ( 15, 22 ] 93 0.041% 99.735% ( 22, 34 ] 25 0.011% 99.746% ( 34, 51 ] 4 0.002% 99.748% ( 51, 76 ] 5 0.002% 99.750% ( 76, 110 ] 117 0.052% 99.802% ( 110, 170 ] 193 0.086% 99.888% ( 170, 250 ] 85 0.038% 99.925% ( 250, 380 ] 70 0.031% 99.956% ( 380, 580 ] 53 0.024% 99.980% ( 580, 870 ] 32 0.014% 99.994% ( 870, 1300 ] 18 0.008% 100.002% ( 1300, 1900 ] 5 0.002% 100.004% ( 1900, 2900 ] 7 0.003% 100.008% ( 2900, 4400 ] 9 0.004% 100.012% ( 4400, 6600 ] 4 0.002% 100.013% ** Level 4 read latency histogram (micros): Count: 3325 Average: 23.2439 StdDev: 174.73 Min: 0 Median: 1.5125 Max: 5495 Percentiles: P50: 1.51 P75: 1.92 P99: 378.80 P99.9: 3237.50 P99.99: 5495.00 ------------------------------------------------------ [ 0, 1 ] 617 18.556% 18.556% #### ( 1, 2 ] 2040 61.353% 79.910% ############ ( 2, 3 ] 216 6.496% 86.406% # ( 3, 4 ] 85 2.556% 88.962% # ( 4, 6 ] 45 1.353% 90.316% ( 6, 10 ] 89 2.677% 92.992% # ( 10, 15 ] 11 0.331% 93.323% ( 15, 22 ] 1 0.030% 93.353% ( 51, 76 ] 7 0.211% 93.564% ( 76, 110 ] 70 2.105% 95.669% ( 110, 170 ] 60 1.805% 97.474% ( 170, 250 ] 24 0.722% 98.195% ( 250, 380 ] 27 0.812% 99.008% ( 380, 580 ] 11 0.331% 99.338% ( 580, 870 ] 8 0.241% 99.579% ( 870, 1300 ] 4 0.120% 99.699% ( 1300, 1900 ] 2 0.060% 99.759% ( 1900, 2900 ] 4 0.120% 99.880% ( 2900, 4400 ] 3 0.090% 99.970% ( 4400, 6600 ] 1 0.030% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 703.8167 StdDev: 887.37 Min: 80 Median: 236.6667 Max: 4545 Percentiles: P50: 236.67 P75: 870.00 P99: 4545.00 P99.9: 4545.00 P99.99: 4545.00 ------------------------------------------------------ ( 76, 110 ] 8 13.333% 13.333% ### ( 110, 170 ] 17 28.333% 41.667% ###### ( 170, 250 ] 6 10.000% 51.667% ## ( 250, 380 ] 3 5.000% 56.667% # ( 380, 580 ] 4 6.667% 63.333% # ( 580, 870 ] 7 11.667% 75.000% ## ( 870, 1300 ] 1 1.667% 76.667% ( 1300, 1900 ] 6 10.000% 86.667% ## ( 1900, 2900 ] 7 11.667% 98.333% ## ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 15.6 total, 3.5 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 315.46 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.196 H:M:S, 14.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 282.01 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.841 H:M:S, 24.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/18-16:43:00 ... thread 0: (1000000,6000000) ops and (132960.2,261523.3) ops/second in (7.521048,22.942506) 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/5 2.09 GB 107.0 4.1 0.0 4.1 9.7 5.7 0.0 1.7 129.2 309.1 32.18 30.08 98 0.328 4221K 4514 0.0 0.0 L1 11/0 747.78 MB 74.8 3.6 3.3 0.2 3.5 3.3 0.2 1.1 229.2 227.1 15.92 15.35 3 5.305 3703K 31K 0.0 0.0 L2 15/10 1.59 GB 5.2 0.4 0.2 0.2 0.4 0.2 2.7 2.0 248.1 247.9 1.52 1.47 2 0.762 383K 238 0.0 0.0 L3 23/9 1.07 GB 0.6 1.8 0.8 1.0 1.8 0.8 0.5 2.3 224.5 224.0 8.27 7.79 6 1.379 1886K 3834 0.0 0.0 L4 171/0 9.73 GB 1.0 0.3 0.3 0.0 0.3 0.3 0.8 1.0 163.7 163.6 1.77 1.31 2 0.883 281K 0 0.0 0.0 L5 1052/0 86.55 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1283/24 101.76 GB 0.0 10.1 4.6 5.5 15.7 10.2 5.3 2.8 173.1 269.6 59.66 56.01 111 0.538 10M 40K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.1 4.6 5.5 15.7 10.2 5.2 2.8 173.1 269.6 59.66 56.01 111 0.538 10M 40K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 10.1 4.6 5.5 10.0 4.5 0.0 0.0 238.8 237.9 43.26 41.41 28 1.545 10M 40K 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.2 16.41 14.60 83 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 23.1 total, 22.9 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 15.71 GB write, 695.68 MB/s write, 10.09 GB read, 446.78 MB/s read, 59.7 seconds Interval compaction: 15.71 GB write, 701.02 MB/s write, 10.09 GB read, 450.21 MB/s read, 59.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 12, total-stops: 16, interval: 28 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2208102 Average: 2.2470 StdDev: 11.58 Min: 0 Median: 1.4926 Max: 7529 Percentiles: P50: 1.49 P75: 1.87 P99: 5.74 P99.9: 12.58 P99.99: 107.97 ------------------------------------------------------ [ 0, 1 ] 382326 17.315% 17.315% ### ( 1, 2 ] 1465195 66.355% 83.670% ############# ( 2, 3 ] 219089 9.922% 93.592% ## ( 3, 4 ] 78881 3.572% 97.164% # ( 4, 6 ] 46647 2.113% 99.277% ( 6, 10 ] 12451 0.564% 99.841% ( 10, 15 ] 2532 0.115% 99.956% ( 15, 22 ] 427 0.019% 99.975% ( 22, 34 ] 24 0.001% 99.976% ( 34, 51 ] 8 0.000% 99.976% ( 51, 76 ] 22 0.001% 99.977% ( 76, 110 ] 298 0.013% 99.991% ( 110, 170 ] 426 0.019% 100.010% ( 170, 250 ] 130 0.006% 100.016% ( 250, 380 ] 102 0.005% 100.021% ( 380, 580 ] 73 0.003% 100.024% ( 580, 870 ] 51 0.002% 100.026% ( 870, 1300 ] 22 0.001% 100.027% ( 1300, 1900 ] 6 0.000% 100.028% ( 1900, 2900 ] 9 0.000% 100.028% ( 2900, 4400 ] 8 0.000% 100.028% ( 6600, 9900 ] 1 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 350424 Average: 3.5395 StdDev: 51.22 Min: 0 Median: 1.6698 Max: 8696 Percentiles: P50: 1.67 P75: 2.25 P99: 8.06 P99.9: 128.37 P99.99: 356.20 ------------------------------------------------------ [ 0, 1 ] 26445 7.547% 7.547% ## ( 1, 2 ] 222092 63.378% 70.925% ############# ( 2, 3 ] 58084 16.575% 87.500% ### ( 3, 4 ] 20972 5.985% 93.485% # ( 4, 6 ] 16991 4.849% 98.333% # ( 6, 10 ] 4534 1.294% 99.627% ( 10, 15 ] 685 0.195% 99.823% ( 15, 22 ] 93 0.027% 99.849% ( 22, 34 ] 12 0.003% 99.853% ( 34, 51 ] 6 0.002% 99.854% ( 51, 76 ] 21 0.006% 99.860% ( 76, 110 ] 89 0.025% 99.886% ( 110, 170 ] 175 0.050% 99.936% ( 170, 250 ] 109 0.031% 99.967% ( 250, 380 ] 104 0.030% 99.997% ( 380, 580 ] 68 0.019% 100.016% ( 580, 870 ] 52 0.015% 100.031% ( 870, 1300 ] 28 0.008% 100.039% ( 1300, 1900 ] 9 0.003% 100.041% ( 1900, 2900 ] 10 0.003% 100.044% ( 2900, 4400 ] 27 0.008% 100.052% ( 4400, 6600 ] 5 0.001% 100.053% ( 6600, 9900 ] 5 0.001% 100.055% ** Level 2 read latency histogram (micros): Count: 95889 Average: 2.0273 StdDev: 4.56 Min: 0 Median: 1.4123 Max: 865 Percentiles: P50: 1.41 P75: 1.82 P99: 5.48 P99.9: 9.81 P99.99: 20.15 ------------------------------------------------------ [ 0, 1 ] 23417 24.421% 24.421% ##### ( 1, 2 ] 59495 62.046% 86.467% ############ ( 2, 3 ] 7533 7.856% 94.323% ## ( 3, 4 ] 3093 3.226% 97.548% # ( 4, 6 ] 1875 1.955% 99.504% ( 6, 10 ] 399 0.416% 99.920% ( 10, 15 ] 63 0.066% 99.985% ( 15, 22 ] 6 0.006% 99.992% ( 22, 34 ] 1 0.001% 99.993% ( 34, 51 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.002% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 242119 Average: 4.4593 StdDev: 55.97 Min: 0 Median: 1.6408 Max: 5842 Percentiles: P50: 1.64 P75: 2.13 P99: 9.32 P99.9: 406.87 P99.99: 991.90 ------------------------------------------------------ [ 0, 1 ] 22444 9.270% 9.270% ## ( 1, 2 ] 153906 63.566% 72.836% ############# ( 2, 3 ] 39556 16.337% 89.174% ### ( 3, 4 ] 11992 4.953% 94.126% # ( 4, 6 ] 8847 3.654% 97.780% # ( 6, 10 ] 3564 1.472% 99.252% ( 10, 15 ] 531 0.219% 99.472% ( 15, 22 ] 110 0.045% 99.517% ( 22, 34 ] 26 0.011% 99.528% ( 34, 51 ] 5 0.002% 99.530% ( 51, 76 ] 6 0.002% 99.532% ( 76, 110 ] 138 0.057% 99.589% ( 110, 170 ] 296 0.122% 99.712% ( 170, 250 ] 227 0.094% 99.805% ( 250, 380 ] 210 0.087% 99.892% ( 380, 580 ] 148 0.061% 99.953% ( 580, 870 ] 81 0.033% 99.987% ( 870, 1300 ] 31 0.013% 100.000% ( 1300, 1900 ] 10 0.004% 100.004% ( 1900, 2900 ] 15 0.006% 100.010% ( 2900, 4400 ] 26 0.011% 100.021% ( 4400, 6600 ] 7 0.003% 100.024% ** Level 4 read latency histogram (micros): Count: 3325 Average: 23.2439 StdDev: 174.73 Min: 0 Median: 1.5125 Max: 5495 Percentiles: P50: 1.51 P75: 1.92 P99: 378.80 P99.9: 3237.50 P99.99: 5495.00 ------------------------------------------------------ [ 0, 1 ] 617 18.556% 18.556% #### ( 1, 2 ] 2040 61.353% 79.910% ############ ( 2, 3 ] 216 6.496% 86.406% # ( 3, 4 ] 85 2.556% 88.962% # ( 4, 6 ] 45 1.353% 90.316% ( 6, 10 ] 89 2.677% 92.992% # ( 10, 15 ] 11 0.331% 93.323% ( 15, 22 ] 1 0.030% 93.353% ( 51, 76 ] 7 0.211% 93.564% ( 76, 110 ] 70 2.105% 95.669% ( 110, 170 ] 60 1.805% 97.474% ( 170, 250 ] 24 0.722% 98.195% ( 250, 380 ] 27 0.812% 99.008% ( 380, 580 ] 11 0.331% 99.338% ( 580, 870 ] 8 0.241% 99.579% ( 870, 1300 ] 4 0.120% 99.699% ( 1300, 1900 ] 2 0.060% 99.759% ( 1900, 2900 ] 4 0.120% 99.880% ( 2900, 4400 ] 3 0.090% 99.970% ( 4400, 6600 ] 1 0.030% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 703.8167 StdDev: 887.37 Min: 80 Median: 236.6667 Max: 4545 Percentiles: P50: 236.67 P75: 870.00 P99: 4545.00 P99.9: 4545.00 P99.99: 4545.00 ------------------------------------------------------ ( 76, 110 ] 8 13.333% 13.333% ### ( 110, 170 ] 17 28.333% 41.667% ###### ( 170, 250 ] 6 10.000% 51.667% ## ( 250, 380 ] 3 5.000% 56.667% # ( 380, 580 ] 4 6.667% 63.333% # ( 580, 870 ] 7 11.667% 75.000% ## ( 870, 1300 ] 1 1.667% 76.667% ( 1300, 1900 ] 6 10.000% 86.667% ## ( 1900, 2900 ] 7 11.667% 98.333% ## ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 23.1 total, 7.5 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 255.41 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.983 H:M:S, 30.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 130.86 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.787 H:M:S, 63.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/11/18-16:43:05 ... thread 0: (1000000,7000000) ops and (186529.9,247318.6) ops/second in (5.361071,28.303577) 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/16 3.07 GB 0.0 5.4 0.0 5.4 12.0 6.6 0.0 1.8 125.8 281.7 43.57 37.88 112 0.389 5564K 9382 0.0 0.0 L1 11/11 747.78 MB 0.0 3.6 3.3 0.2 3.5 3.3 0.2 1.1 229.2 227.1 15.92 15.35 3 5.305 3703K 31K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 2.7 2.0 248.1 247.9 1.52 1.47 2 0.762 383K 238 0.0 0.0 L3 22/0 973.83 MB 1.0 4.1 2.4 1.7 4.1 2.4 0.5 1.7 145.2 144.5 29.13 18.78 20 1.456 4296K 20K 0.0 0.0 L4 184/0 9.75 GB 1.0 2.1 2.0 0.1 2.1 2.0 0.8 1.1 139.9 139.6 15.34 9.89 35 0.438 2091K 1871 0.0 0.0 L5 1072/0 88.22 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1305/27 102.71 GB 0.0 15.5 7.8 7.7 22.1 14.4 7.0 3.3 150.6 214.4 105.47 83.37 172 0.613 16M 64K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.5 7.8 7.7 22.1 14.4 6.9 3.3 150.6 214.4 105.47 83.37 172 0.613 16M 64K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 15.5 7.8 7.7 15.4 7.8 0.0 0.0 189.0 188.2 84.04 66.02 77 1.091 16M 64K 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 317.4 21.44 17.35 95 0.226 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 28.5 total, 28.3 interval Flush(GB): cumulative 6.644, interval 6.644 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 22.09 GB write, 794.13 MB/s write, 15.51 GB read, 557.62 MB/s read, 105.5 seconds Interval compaction: 22.09 GB write, 799.07 MB/s write, 15.51 GB read, 561.08 MB/s read, 105.5 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: 51, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 12, total-stops: 51, interval: 63 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2514023 Average: 2.4203 StdDev: 19.88 Min: 0 Median: 1.5172 Max: 7529 Percentiles: P50: 1.52 P75: 1.90 P99: 5.92 P99.9: 13.54 P99.99: 153.65 ------------------------------------------------------ [ 0, 1 ] 405711 16.138% 16.138% ### ( 1, 2 ] 1645833 65.466% 81.604% ############# ( 2, 3 ] 273394 10.875% 92.479% ## ( 3, 4 ] 100403 3.994% 96.473% # ( 4, 6 ] 66278 2.636% 99.109% # ( 6, 10 ] 17485 0.695% 99.804% ( 10, 15 ] 3396 0.135% 99.939% ( 15, 22 ] 511 0.020% 99.960% ( 22, 34 ] 30 0.001% 99.961% ( 34, 51 ] 9 0.000% 99.961% ( 51, 76 ] 24 0.001% 99.962% ( 76, 110 ] 338 0.013% 99.976% ( 110, 170 ] 497 0.020% 99.995% ( 170, 250 ] 215 0.009% 100.004% ( 250, 380 ] 187 0.007% 100.011% ( 380, 580 ] 152 0.006% 100.018% ( 580, 870 ] 112 0.004% 100.022% ( 870, 1300 ] 58 0.002% 100.024% ( 1300, 1900 ] 12 0.000% 100.025% ( 1900, 2900 ] 28 0.001% 100.026% ( 2900, 4400 ] 24 0.001% 100.027% ( 4400, 6600 ] 4 0.000% 100.027% ( 6600, 9900 ] 4 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 727337 Average: 6.6189 StdDev: 120.24 Min: 0 Median: 1.8095 Max: 11534 Percentiles: P50: 1.81 P75: 2.71 P99: 9.13 P99.9: 133.91 P99.99: 475.92 ------------------------------------------------------ [ 0, 1 ] 36031 4.954% 4.954% # ( 1, 2 ] 404739 55.647% 60.601% ########### ( 2, 3 ] 148117 20.364% 80.965% #### ( 3, 4 ] 61165 8.409% 89.374% ## ( 4, 6 ] 58510 8.044% 97.419% ## ( 6, 10 ] 14680 2.018% 99.437% ( 10, 15 ] 2785 0.383% 99.820% ( 15, 22 ] 333 0.046% 99.866% ( 22, 34 ] 29 0.004% 99.870% ( 34, 51 ] 10 0.001% 99.871% ( 51, 76 ] 24 0.003% 99.874% ( 76, 110 ] 95 0.013% 99.887% ( 110, 170 ] 230 0.032% 99.919% ( 170, 250 ] 187 0.026% 99.945% ( 250, 380 ] 218 0.030% 99.975% ( 380, 580 ] 232 0.032% 100.007% ( 580, 870 ] 218 0.030% 100.037% ( 870, 1300 ] 106 0.015% 100.051% ( 1300, 1900 ] 78 0.011% 100.062% ( 1900, 2900 ] 139 0.019% 100.081% ( 2900, 4400 ] 267 0.037% 100.118% ( 4400, 6600 ] 99 0.014% 100.131% ( 6600, 9900 ] 44 0.006% 100.137% ( 9900, 14000 ] 4 0.001% 100.138% ** Level 2 read latency histogram (micros): Count: 95889 Average: 2.0273 StdDev: 4.56 Min: 0 Median: 1.4123 Max: 865 Percentiles: P50: 1.41 P75: 1.82 P99: 5.48 P99.9: 9.81 P99.99: 20.15 ------------------------------------------------------ [ 0, 1 ] 23417 24.421% 24.421% ##### ( 1, 2 ] 59495 62.046% 86.467% ############ ( 2, 3 ] 7533 7.856% 94.323% ## ( 3, 4 ] 3093 3.226% 97.548% # ( 4, 6 ] 1875 1.955% 99.504% ( 6, 10 ] 399 0.416% 99.920% ( 10, 15 ] 63 0.066% 99.985% ( 15, 22 ] 6 0.006% 99.992% ( 22, 34 ] 1 0.001% 99.993% ( 34, 51 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.002% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 849931 Average: 3.9585 StdDev: 47.53 Min: 0 Median: 1.8738 Max: 10016 Percentiles: P50: 1.87 P75: 2.81 P99: 8.75 P99.9: 14.77 P99.99: 110.36 ------------------------------------------------------ [ 0, 1 ] 32007 3.766% 3.766% # ( 1, 2 ] 449698 52.910% 56.676% ########### ( 2, 3 ] 191946 22.584% 79.259% ##### ( 3, 4 ] 80529 9.475% 88.734% ## ( 4, 6 ] 76521 9.003% 97.737% ## ( 6, 10 ] 15587 1.834% 99.571% ( 10, 15 ] 2927 0.344% 99.916% ( 15, 22 ] 382 0.045% 99.961% ( 22, 34 ] 58 0.007% 99.968% ( 34, 51 ] 21 0.002% 99.970% ( 51, 76 ] 11 0.001% 99.971% ( 76, 110 ] 157 0.018% 99.990% ( 110, 170 ] 336 0.040% 100.029% ( 170, 250 ] 307 0.036% 100.065% ( 250, 380 ] 303 0.036% 100.101% ( 380, 580 ] 227 0.027% 100.128% ( 580, 870 ] 153 0.018% 100.146% ( 870, 1300 ] 86 0.010% 100.156% ( 1300, 1900 ] 30 0.004% 100.159% ( 1900, 2900 ] 37 0.004% 100.164% ( 2900, 4400 ] 64 0.008% 100.171% ( 4400, 6600 ] 13 0.002% 100.173% ( 9900, 14000 ] 1 0.000% 100.173% ** Level 4 read latency histogram (micros): Count: 36730 Average: 59.2838 StdDev: 335.93 Min: 0 Median: 1.9013 Max: 8264 Percentiles: P50: 1.90 P75: 3.01 P99: 1551.68 P99.9: 4260.04 P99.99: 6364.78 ------------------------------------------------------ [ 0, 1 ] 1587 4.321% 4.321% # ( 1, 2 ] 18616 50.683% 55.004% ########## ( 2, 3 ] 7319 19.926% 74.931% #### ( 3, 4 ] 3668 9.986% 84.917% ## ( 4, 6 ] 2144 5.837% 90.754% # ( 6, 10 ] 840 2.287% 93.041% ( 10, 15 ] 145 0.395% 93.436% ( 15, 22 ] 10 0.027% 93.463% ( 22, 34 ] 3 0.008% 93.471% ( 51, 76 ] 7 0.019% 93.490% ( 76, 110 ] 150 0.408% 93.899% ( 110, 170 ] 226 0.615% 94.514% ( 170, 250 ] 233 0.634% 95.148% ( 250, 380 ] 309 0.841% 95.990% ( 380, 580 ] 365 0.994% 96.983% ( 580, 870 ] 397 1.081% 98.064% ( 870, 1300 ] 264 0.719% 98.783% ( 1300, 1900 ] 190 0.517% 99.300% ( 1900, 2900 ] 116 0.316% 99.616% ( 2900, 4400 ] 115 0.313% 99.929% ( 4400, 6600 ] 25 0.068% 99.997% ( 6600, 9900 ] 7 0.019% 100.016% ** Level 5 read latency histogram (micros): Count: 160 Average: 1066.3125 StdDev: 1399.76 Min: 78 Median: 564.6154 Max: 11830 Percentiles: P50: 564.62 P75: 1550.00 P99: 6160.00 P99.9: 11830.00 P99.99: 11830.00 ------------------------------------------------------ ( 76, 110 ] 13 8.125% 8.125% ## ( 110, 170 ] 25 15.625% 23.750% ### ( 170, 250 ] 13 8.125% 31.875% ## ( 250, 380 ] 17 10.625% 42.500% ## ( 380, 580 ] 13 8.125% 50.625% ## ( 580, 870 ] 24 15.000% 65.625% ### ( 870, 1300 ] 10 6.250% 71.875% # ( 1300, 1900 ] 12 7.500% 79.375% ## ( 1900, 2900 ] 19 11.875% 91.250% ## ( 2900, 4400 ] 10 6.250% 97.500% # ( 4400, 6600 ] 3 1.875% 99.375% ( 9900, 14000 ] 1 0.625% 100.000% ** DB Stats ** Uptime(secs): 28.5 total, 5.4 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 241.89 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:9.423 H:M:S, 33.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 183.59 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.440 H:M:S, 45.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/18-16:43:08 ... thread 0: (1000000,8000000) ops and (331974.6,255461.6) ops/second in (3.012279,31.315856) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/12 3.99 GB 125.9 6.5 0.0 6.5 14.0 7.6 0.0 1.9 130.7 283.6 50.61 44.54 129 0.392 6715K 10K 0.0 0.0 L1 11/11 747.78 MB 0.0 3.6 3.3 0.2 3.5 3.3 0.2 1.1 229.2 227.1 15.92 15.35 3 5.305 3703K 31K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 2.7 2.0 248.1 247.9 1.52 1.47 2 0.762 383K 238 0.0 0.0 L3 22/0 973.83 MB 1.0 4.1 2.4 1.7 4.1 2.4 0.5 1.7 145.2 144.5 29.13 18.78 20 1.456 4296K 20K 0.0 0.0 L4 184/0 9.75 GB 1.0 2.1 2.0 0.1 2.1 2.0 0.8 1.1 139.9 139.6 15.34 9.89 35 0.438 2091K 1871 0.0 0.0 L5 1072/0 88.22 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1306/23 103.64 GB 0.0 16.6 7.8 8.8 24.1 15.3 7.0 3.2 151.2 219.5 112.51 90.03 189 0.595 17M 65K 0.0 0.0 Int 0/0 0.00 KB 0.0 16.6 7.8 8.8 24.1 15.3 6.9 3.2 151.2 219.5 112.51 90.03 189 0.595 17M 65K 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 16.6 7.8 8.8 16.5 7.8 0.0 0.0 192.6 191.8 88.36 70.27 81 1.091 17M 65K 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 320.8 24.15 19.76 108 0.224 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 31.5 total, 31.3 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 24.12 GB write, 784.15 MB/s write, 16.62 GB read, 540.29 MB/s read, 112.5 seconds Interval compaction: 24.12 GB write, 788.55 MB/s write, 16.62 GB read, 543.32 MB/s read, 112.5 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: 53, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 12, total-stops: 53, interval: 65 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2908574 Average: 2.4121 StdDev: 18.88 Min: 0 Median: 1.5214 Max: 7529 Percentiles: P50: 1.52 P75: 1.90 P99: 5.92 P99.9: 13.34 P99.99: 144.79 ------------------------------------------------------ [ 0, 1 ] 457683 15.736% 15.736% ### ( 1, 2 ] 1911502 65.720% 81.455% ############# ( 2, 3 ] 322797 11.098% 92.553% ## ( 3, 4 ] 114731 3.945% 96.498% # ( 4, 6 ] 75701 2.603% 99.101% # ( 6, 10 ] 20706 0.712% 99.812% ( 10, 15 ] 3817 0.131% 99.944% ( 15, 22 ] 558 0.019% 99.963% ( 22, 34 ] 33 0.001% 99.964% ( 34, 51 ] 10 0.000% 99.964% ( 51, 76 ] 29 0.001% 99.965% ( 76, 110 ] 382 0.013% 99.979% ( 110, 170 ] 578 0.020% 99.998% ( 170, 250 ] 251 0.009% 100.007% ( 250, 380 ] 209 0.007% 100.014% ( 380, 580 ] 173 0.006% 100.020% ( 580, 870 ] 123 0.004% 100.024% ( 870, 1300 ] 64 0.002% 100.027% ( 1300, 1900 ] 15 0.001% 100.027% ( 1900, 2900 ] 30 0.001% 100.028% ( 2900, 4400 ] 24 0.001% 100.029% ( 4400, 6600 ] 4 0.000% 100.029% ( 6600, 9900 ] 4 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 727337 Average: 6.6189 StdDev: 120.24 Min: 0 Median: 1.8095 Max: 11534 Percentiles: P50: 1.81 P75: 2.71 P99: 9.13 P99.9: 133.91 P99.99: 475.92 ------------------------------------------------------ [ 0, 1 ] 36031 4.954% 4.954% # ( 1, 2 ] 404739 55.647% 60.601% ########### ( 2, 3 ] 148117 20.364% 80.965% #### ( 3, 4 ] 61165 8.409% 89.374% ## ( 4, 6 ] 58510 8.044% 97.419% ## ( 6, 10 ] 14680 2.018% 99.437% ( 10, 15 ] 2785 0.383% 99.820% ( 15, 22 ] 333 0.046% 99.866% ( 22, 34 ] 29 0.004% 99.870% ( 34, 51 ] 10 0.001% 99.871% ( 51, 76 ] 24 0.003% 99.874% ( 76, 110 ] 95 0.013% 99.887% ( 110, 170 ] 230 0.032% 99.919% ( 170, 250 ] 187 0.026% 99.945% ( 250, 380 ] 218 0.030% 99.975% ( 380, 580 ] 232 0.032% 100.007% ( 580, 870 ] 218 0.030% 100.037% ( 870, 1300 ] 106 0.015% 100.051% ( 1300, 1900 ] 78 0.011% 100.062% ( 1900, 2900 ] 139 0.019% 100.081% ( 2900, 4400 ] 267 0.037% 100.118% ( 4400, 6600 ] 99 0.014% 100.131% ( 6600, 9900 ] 44 0.006% 100.137% ( 9900, 14000 ] 4 0.001% 100.138% ** Level 2 read latency histogram (micros): Count: 95889 Average: 2.0273 StdDev: 4.56 Min: 0 Median: 1.4123 Max: 865 Percentiles: P50: 1.41 P75: 1.82 P99: 5.48 P99.9: 9.81 P99.99: 20.15 ------------------------------------------------------ [ 0, 1 ] 23417 24.421% 24.421% ##### ( 1, 2 ] 59495 62.046% 86.467% ############ ( 2, 3 ] 7533 7.856% 94.323% ## ( 3, 4 ] 3093 3.226% 97.548% # ( 4, 6 ] 1875 1.955% 99.504% ( 6, 10 ] 399 0.416% 99.920% ( 10, 15 ] 63 0.066% 99.985% ( 15, 22 ] 6 0.006% 99.992% ( 22, 34 ] 1 0.001% 99.993% ( 34, 51 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.002% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 849931 Average: 3.9585 StdDev: 47.53 Min: 0 Median: 1.8738 Max: 10016 Percentiles: P50: 1.87 P75: 2.81 P99: 8.75 P99.9: 14.77 P99.99: 110.36 ------------------------------------------------------ [ 0, 1 ] 32007 3.766% 3.766% # ( 1, 2 ] 449698 52.910% 56.676% ########### ( 2, 3 ] 191946 22.584% 79.259% ##### ( 3, 4 ] 80529 9.475% 88.734% ## ( 4, 6 ] 76521 9.003% 97.737% ## ( 6, 10 ] 15587 1.834% 99.571% ( 10, 15 ] 2927 0.344% 99.916% ( 15, 22 ] 382 0.045% 99.961% ( 22, 34 ] 58 0.007% 99.968% ( 34, 51 ] 21 0.002% 99.970% ( 51, 76 ] 11 0.001% 99.971% ( 76, 110 ] 157 0.018% 99.990% ( 110, 170 ] 336 0.040% 100.029% ( 170, 250 ] 307 0.036% 100.065% ( 250, 380 ] 303 0.036% 100.101% ( 380, 580 ] 227 0.027% 100.128% ( 580, 870 ] 153 0.018% 100.146% ( 870, 1300 ] 86 0.010% 100.156% ( 1300, 1900 ] 30 0.004% 100.159% ( 1900, 2900 ] 37 0.004% 100.164% ( 2900, 4400 ] 64 0.008% 100.171% ( 4400, 6600 ] 13 0.002% 100.173% ( 9900, 14000 ] 1 0.000% 100.173% ** Level 4 read latency histogram (micros): Count: 36730 Average: 59.2838 StdDev: 335.93 Min: 0 Median: 1.9013 Max: 8264 Percentiles: P50: 1.90 P75: 3.01 P99: 1551.68 P99.9: 4260.04 P99.99: 6364.78 ------------------------------------------------------ [ 0, 1 ] 1587 4.321% 4.321% # ( 1, 2 ] 18616 50.683% 55.004% ########## ( 2, 3 ] 7319 19.926% 74.931% #### ( 3, 4 ] 3668 9.986% 84.917% ## ( 4, 6 ] 2144 5.837% 90.754% # ( 6, 10 ] 840 2.287% 93.041% ( 10, 15 ] 145 0.395% 93.436% ( 15, 22 ] 10 0.027% 93.463% ( 22, 34 ] 3 0.008% 93.471% ( 51, 76 ] 7 0.019% 93.490% ( 76, 110 ] 150 0.408% 93.899% ( 110, 170 ] 226 0.615% 94.514% ( 170, 250 ] 233 0.634% 95.148% ( 250, 380 ] 309 0.841% 95.990% ( 380, 580 ] 365 0.994% 96.983% ( 580, 870 ] 397 1.081% 98.064% ( 870, 1300 ] 264 0.719% 98.783% ( 1300, 1900 ] 190 0.517% 99.300% ( 1900, 2900 ] 116 0.316% 99.616% ( 2900, 4400 ] 115 0.313% 99.929% ( 4400, 6600 ] 25 0.068% 99.997% ( 6600, 9900 ] 7 0.019% 100.016% ** Level 5 read latency histogram (micros): Count: 160 Average: 1066.3125 StdDev: 1399.76 Min: 78 Median: 564.6154 Max: 11830 Percentiles: P50: 564.62 P75: 1550.00 P99: 6160.00 P99.9: 11830.00 P99.99: 11830.00 ------------------------------------------------------ ( 76, 110 ] 13 8.125% 8.125% ## ( 110, 170 ] 25 15.625% 23.750% ### ( 170, 250 ] 13 8.125% 31.875% ## ( 250, 380 ] 17 10.625% 42.500% ## ( 380, 580 ] 13 8.125% 50.625% ## ( 580, 870 ] 24 15.000% 65.625% ### ( 870, 1300 ] 10 6.250% 71.875% # ( 1300, 1900 ] 12 7.500% 79.375% ## ( 1900, 2900 ] 19 11.875% 91.250% ## ( 2900, 4400 ] 10 6.250% 97.500% # ( 4400, 6600 ] 3 1.875% 99.375% ( 9900, 14000 ] 1 0.625% 100.000% ** DB Stats ** Uptime(secs): 31.5 total, 3.0 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 250.00 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:9.831 H:M:S, 31.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 326.73 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.407 H:M:S, 13.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/18-16:43:17 ... thread 0: (1000000,9000000) ops and (121871.5,227725.8) ops/second in (8.205363,39.521219) 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/13 5.04 GB 125.9 7.8 0.0 7.8 16.4 8.6 0.0 1.9 136.2 286.1 58.74 52.30 150 0.392 8122K 12K 0.0 0.0 L1 11/11 747.78 MB 0.0 3.6 3.3 0.2 3.5 3.3 0.2 1.1 229.2 227.1 15.92 15.35 3 5.305 3703K 31K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 2.7 2.0 248.1 247.9 1.52 1.47 2 0.762 383K 238 0.0 0.0 L3 22/0 973.83 MB 1.0 4.1 2.4 1.7 4.1 2.4 0.5 1.7 145.2 144.5 29.13 18.78 20 1.456 4296K 20K 0.0 0.0 L4 184/0 9.75 GB 1.0 2.1 2.0 0.1 2.1 2.0 0.8 1.1 139.9 139.6 15.34 9.89 35 0.438 2091K 1871 0.0 0.0 L5 1072/0 88.22 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1307/24 104.68 GB 0.0 18.0 7.8 10.1 26.5 16.4 7.0 3.1 152.5 225.0 120.65 97.79 210 0.575 18M 66K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.0 7.8 10.1 26.5 16.4 6.9 3.1 152.5 225.0 120.65 97.79 210 0.575 18M 66K 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 18.0 7.8 10.1 17.9 7.8 0.0 0.0 196.8 196.1 93.48 75.32 86 1.087 18M 66K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 324.7 27.16 22.47 124 0.219 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 39.7 total, 39.5 interval Flush(GB): cumulative 8.613, interval 8.613 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: 26.51 GB write, 683.91 MB/s write, 17.97 GB read, 463.52 MB/s read, 120.6 seconds Interval compaction: 26.51 GB write, 686.96 MB/s write, 17.97 GB read, 465.58 MB/s read, 120.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 22, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 22, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 55, pending-compaction-bytes-delays: 1, pending-compaction-bytes-stops: 0, total-delays: 23, total-stops: 55, interval: 78 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3700802 Average: 2.3681 StdDev: 17.23 Min: 0 Median: 1.5128 Max: 7529 Percentiles: P50: 1.51 P75: 1.89 P99: 5.91 P99.9: 13.03 P99.99: 136.39 ------------------------------------------------------ [ 0, 1 ] 595952 16.103% 16.103% ### ( 1, 2 ] 2446148 66.098% 82.201% ############# ( 2, 3 ] 398262 10.762% 92.963% ## ( 3, 4 ] 138331 3.738% 96.700% # ( 4, 6 ] 89211 2.411% 99.111% ( 6, 10 ] 26481 0.716% 99.827% ( 10, 15 ] 4495 0.121% 99.948% ( 15, 22 ] 639 0.017% 99.965% ( 22, 34 ] 34 0.001% 99.966% ( 34, 51 ] 12 0.000% 99.967% ( 51, 76 ] 33 0.001% 99.967% ( 76, 110 ] 527 0.014% 99.982% ( 110, 170 ] 707 0.019% 100.001% ( 170, 250 ] 305 0.008% 100.009% ( 250, 380 ] 239 0.006% 100.016% ( 380, 580 ] 200 0.005% 100.021% ( 580, 870 ] 140 0.004% 100.025% ( 870, 1300 ] 71 0.002% 100.027% ( 1300, 1900 ] 18 0.000% 100.027% ( 1900, 2900 ] 33 0.001% 100.028% ( 2900, 4400 ] 25 0.001% 100.029% ( 4400, 6600 ] 4 0.000% 100.029% ( 6600, 9900 ] 4 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 892314 Average: 5.8667 StdDev: 108.65 Min: 0 Median: 1.7362 Max: 11534 Percentiles: P50: 1.74 P75: 2.54 P99: 9.01 P99.9: 136.91 P99.99: 475.40 ------------------------------------------------------ [ 0, 1 ] 66467 7.449% 7.449% # ( 1, 2 ] 515718 57.796% 65.244% ############ ( 2, 3 ] 162188 18.176% 83.421% #### ( 3, 4 ] 65410 7.330% 90.751% # ( 4, 6 ] 61122 6.850% 97.601% # ( 6, 10 ] 16576 1.858% 99.458% ( 10, 15 ] 2924 0.328% 99.786% ( 15, 22 ] 355 0.040% 99.826% ( 22, 34 ] 30 0.003% 99.829% ( 34, 51 ] 10 0.001% 99.830% ( 51, 76 ] 92 0.010% 99.841% ( 76, 110 ] 358 0.040% 99.881% ( 110, 170 ] 385 0.043% 99.924% ( 170, 250 ] 224 0.025% 99.949% ( 250, 380 ] 248 0.028% 99.977% ( 380, 580 ] 249 0.028% 100.005% ( 580, 870 ] 223 0.025% 100.030% ( 870, 1300 ] 108 0.012% 100.042% ( 1300, 1900 ] 78 0.009% 100.051% ( 1900, 2900 ] 139 0.016% 100.066% ( 2900, 4400 ] 267 0.030% 100.096% ( 4400, 6600 ] 99 0.011% 100.107% ( 6600, 9900 ] 44 0.005% 100.112% ( 9900, 14000 ] 4 0.000% 100.113% ** Level 2 read latency histogram (micros): Count: 95889 Average: 2.0273 StdDev: 4.56 Min: 0 Median: 1.4123 Max: 865 Percentiles: P50: 1.41 P75: 1.82 P99: 5.48 P99.9: 9.81 P99.99: 20.15 ------------------------------------------------------ [ 0, 1 ] 23417 24.421% 24.421% ##### ( 1, 2 ] 59495 62.046% 86.467% ############ ( 2, 3 ] 7533 7.856% 94.323% ## ( 3, 4 ] 3093 3.226% 97.548% # ( 4, 6 ] 1875 1.955% 99.504% ( 6, 10 ] 399 0.416% 99.920% ( 10, 15 ] 63 0.066% 99.985% ( 15, 22 ] 6 0.006% 99.992% ( 22, 34 ] 1 0.001% 99.993% ( 34, 51 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.002% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 849931 Average: 3.9585 StdDev: 47.53 Min: 0 Median: 1.8738 Max: 10016 Percentiles: P50: 1.87 P75: 2.81 P99: 8.75 P99.9: 14.77 P99.99: 110.36 ------------------------------------------------------ [ 0, 1 ] 32007 3.766% 3.766% # ( 1, 2 ] 449698 52.910% 56.676% ########### ( 2, 3 ] 191946 22.584% 79.259% ##### ( 3, 4 ] 80529 9.475% 88.734% ## ( 4, 6 ] 76521 9.003% 97.737% ## ( 6, 10 ] 15587 1.834% 99.571% ( 10, 15 ] 2927 0.344% 99.916% ( 15, 22 ] 382 0.045% 99.961% ( 22, 34 ] 58 0.007% 99.968% ( 34, 51 ] 21 0.002% 99.970% ( 51, 76 ] 11 0.001% 99.971% ( 76, 110 ] 157 0.018% 99.990% ( 110, 170 ] 336 0.040% 100.029% ( 170, 250 ] 307 0.036% 100.065% ( 250, 380 ] 303 0.036% 100.101% ( 380, 580 ] 227 0.027% 100.128% ( 580, 870 ] 153 0.018% 100.146% ( 870, 1300 ] 86 0.010% 100.156% ( 1300, 1900 ] 30 0.004% 100.159% ( 1900, 2900 ] 37 0.004% 100.164% ( 2900, 4400 ] 64 0.008% 100.171% ( 4400, 6600 ] 13 0.002% 100.173% ( 9900, 14000 ] 1 0.000% 100.173% ** Level 4 read latency histogram (micros): Count: 36730 Average: 59.2838 StdDev: 335.93 Min: 0 Median: 1.9013 Max: 8264 Percentiles: P50: 1.90 P75: 3.01 P99: 1551.68 P99.9: 4260.04 P99.99: 6364.78 ------------------------------------------------------ [ 0, 1 ] 1587 4.321% 4.321% # ( 1, 2 ] 18616 50.683% 55.004% ########## ( 2, 3 ] 7319 19.926% 74.931% #### ( 3, 4 ] 3668 9.986% 84.917% ## ( 4, 6 ] 2144 5.837% 90.754% # ( 6, 10 ] 840 2.287% 93.041% ( 10, 15 ] 145 0.395% 93.436% ( 15, 22 ] 10 0.027% 93.463% ( 22, 34 ] 3 0.008% 93.471% ( 51, 76 ] 7 0.019% 93.490% ( 76, 110 ] 150 0.408% 93.899% ( 110, 170 ] 226 0.615% 94.514% ( 170, 250 ] 233 0.634% 95.148% ( 250, 380 ] 309 0.841% 95.990% ( 380, 580 ] 365 0.994% 96.983% ( 580, 870 ] 397 1.081% 98.064% ( 870, 1300 ] 264 0.719% 98.783% ( 1300, 1900 ] 190 0.517% 99.300% ( 1900, 2900 ] 116 0.316% 99.616% ( 2900, 4400 ] 115 0.313% 99.929% ( 4400, 6600 ] 25 0.068% 99.997% ( 6600, 9900 ] 7 0.019% 100.016% ** Level 5 read latency histogram (micros): Count: 160 Average: 1066.3125 StdDev: 1399.76 Min: 78 Median: 564.6154 Max: 11830 Percentiles: P50: 564.62 P75: 1550.00 P99: 6160.00 P99.9: 11830.00 P99.99: 11830.00 ------------------------------------------------------ ( 76, 110 ] 13 8.125% 8.125% ## ( 110, 170 ] 25 15.625% 23.750% ### ( 170, 250 ] 13 8.125% 31.875% ## ( 250, 380 ] 17 10.625% 42.500% ## ( 380, 580 ] 13 8.125% 50.625% ## ( 580, 870 ] 24 15.000% 65.625% ### ( 870, 1300 ] 10 6.250% 71.875% # ( 1300, 1900 ] 12 7.500% 79.375% ## ( 1900, 2900 ] 19 11.875% 91.250% ## ( 2900, 4400 ] 10 6.250% 97.500% # ( 4400, 6600 ] 3 1.875% 99.375% ( 9900, 14000 ] 1 0.625% 100.000% ** DB Stats ** Uptime(secs): 39.7 total, 8.2 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 223.12 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:15.193 H:M:S, 38.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 119.93 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:5.363 H:M:S, 65.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 0 2024/11/18-16:43:25 ... thread 0: (1000000,10000000) ops and (123699.3,210060.5) ops/second in (8.084118,47.605337) 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/11 3.50 GB 62.9 9.5 0.0 9.5 19.0 9.5 0.0 2.0 138.9 277.5 70.29 61.52 164 0.429 9912K 20K 0.0 0.0 L1 9/9 1.13 GB 0.0 6.7 5.8 1.0 6.7 5.7 0.2 1.2 227.8 225.3 30.32 29.04 4 7.581 6691K 31K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 4.7 2.0 248.1 247.9 1.52 1.47 2 0.762 383K 238 0.0 0.0 L3 20/0 923.70 MB 0.9 7.2 4.3 2.9 7.1 4.2 0.7 1.7 145.5 144.8 50.33 33.10 33 1.525 7438K 38K 0.0 0.0 L4 163/0 9.43 GB 1.0 5.2 4.0 1.2 5.1 4.0 0.8 1.3 138.3 137.4 38.27 24.28 61 0.627 5228K 27K 0.0 0.0 L5 1100/0 90.55 GB 0.9 0.0 0.0 0.0 0.0 0.0 5.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1307/20 105.51 GB 0.0 29.0 14.2 14.7 38.3 23.6 11.5 4.0 155.5 205.8 190.73 149.40 264 0.722 29M 118K 0.0 0.0 Int 0/0 0.00 KB 0.0 29.0 14.2 14.7 38.3 23.6 11.4 4.0 155.5 205.8 190.73 149.40 264 0.722 29M 118K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 29.0 14.2 14.7 28.8 14.1 0.0 0.0 186.1 185.0 159.43 124.43 128 1.246 29M 118K 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 312.1 31.29 24.97 136 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): 47.8 total, 47.6 interval Flush(GB): cumulative 9.536, interval 9.536 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 38.34 GB write, 821.64 MB/s write, 28.97 GB read, 620.81 MB/s read, 190.7 seconds Interval compaction: 38.34 GB write, 824.68 MB/s write, 28.97 GB read, 623.11 MB/s read, 190.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 22, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 22, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 72, pending-compaction-bytes-delays: 19, pending-compaction-bytes-stops: 0, total-delays: 41, total-stops: 72, interval: 113 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4259892 Average: 2.6010 StdDev: 27.37 Min: 0 Median: 1.5365 Max: 9032 Percentiles: P50: 1.54 P75: 1.92 P99: 6.25 P99.9: 13.79 P99.99: 189.13 ------------------------------------------------------ [ 0, 1 ] 642120 15.074% 15.074% ### ( 1, 2 ] 2772954 65.094% 80.168% ############# ( 2, 3 ] 495027 11.621% 91.789% ## ( 3, 4 ] 178218 4.184% 95.972% # ( 4, 6 ] 126666 2.973% 98.946% # ( 6, 10 ] 36259 0.851% 99.797% ( 10, 15 ] 5797 0.136% 99.933% ( 15, 22 ] 784 0.018% 99.951% ( 22, 34 ] 39 0.001% 99.952% ( 34, 51 ] 18 0.000% 99.953% ( 51, 76 ] 48 0.001% 99.954% ( 76, 110 ] 655 0.015% 99.969% ( 110, 170 ] 794 0.019% 99.988% ( 170, 250 ] 368 0.009% 99.997% ( 250, 380 ] 334 0.008% 100.004% ( 380, 580 ] 307 0.007% 100.012% ( 580, 870 ] 269 0.006% 100.018% ( 870, 1300 ] 194 0.005% 100.023% ( 1300, 1900 ] 82 0.002% 100.024% ( 1900, 2900 ] 76 0.002% 100.026% ( 2900, 4400 ] 87 0.002% 100.028% ( 4400, 6600 ] 21 0.000% 100.029% ( 6600, 9900 ] 7 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 1432458 Average: 6.4658 StdDev: 107.42 Min: 0 Median: 1.8492 Max: 11534 Percentiles: P50: 1.85 P75: 2.82 P99: 9.34 P99.9: 157.20 P99.99: 507.51 ------------------------------------------------------ [ 0, 1 ] 73214 5.111% 5.111% # ( 1, 2 ] 757223 52.862% 57.973% ########### ( 2, 3 ] 298796 20.859% 78.832% #### ( 3, 4 ] 131489 9.179% 88.011% ## ( 4, 6 ] 130268 9.094% 97.105% ## ( 6, 10 ] 32481 2.268% 99.373% ( 10, 15 ] 5801 0.405% 99.778% ( 15, 22 ] 709 0.049% 99.827% ( 22, 34 ] 51 0.004% 99.831% ( 34, 51 ] 22 0.002% 99.832% ( 51, 76 ] 124 0.009% 99.841% ( 76, 110 ] 444 0.031% 99.872% ( 110, 170 ] 513 0.036% 99.908% ( 170, 250 ] 332 0.023% 99.931% ( 250, 380 ] 492 0.034% 99.965% ( 380, 580 ] 558 0.039% 100.004% ( 580, 870 ] 582 0.041% 100.045% ( 870, 1300 ] 369 0.026% 100.071% ( 1300, 1900 ] 233 0.016% 100.087% ( 1900, 2900 ] 278 0.019% 100.106% ( 2900, 4400 ] 436 0.030% 100.137% ( 4400, 6600 ] 155 0.011% 100.147% ( 6600, 9900 ] 56 0.004% 100.151% ( 9900, 14000 ] 4 0.000% 100.152% ** Level 2 read latency histogram (micros): Count: 95889 Average: 2.0273 StdDev: 4.56 Min: 0 Median: 1.4123 Max: 865 Percentiles: P50: 1.41 P75: 1.82 P99: 5.48 P99.9: 9.81 P99.99: 20.15 ------------------------------------------------------ [ 0, 1 ] 23417 24.421% 24.421% ##### ( 1, 2 ] 59495 62.046% 86.467% ############ ( 2, 3 ] 7533 7.856% 94.323% ## ( 3, 4 ] 3093 3.226% 97.548% # ( 4, 6 ] 1875 1.955% 99.504% ( 6, 10 ] 399 0.416% 99.920% ( 10, 15 ] 63 0.066% 99.985% ( 15, 22 ] 6 0.006% 99.992% ( 22, 34 ] 1 0.001% 99.993% ( 34, 51 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.002% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 1646497 Average: 4.7577 StdDev: 66.23 Min: 0 Median: 1.9492 Max: 10016 Percentiles: P50: 1.95 P75: 2.94 P99: 8.88 P99.9: 14.80 P99.99: 142.34 ------------------------------------------------------ [ 0, 1 ] 40054 2.433% 2.433% ( 1, 2 ] 825136 50.115% 52.547% ########## ( 2, 3 ] 392953 23.866% 76.413% ##### ( 3, 4 ] 175694 10.671% 87.084% ## ( 4, 6 ] 173369 10.530% 97.614% ## ( 6, 10 ] 31721 1.927% 99.540% ( 10, 15 ] 6168 0.375% 99.915% ( 15, 22 ] 720 0.044% 99.959% ( 22, 34 ] 82 0.005% 99.964% ( 34, 51 ] 35 0.002% 99.966% ( 51, 76 ] 30 0.002% 99.968% ( 76, 110 ] 172 0.010% 99.978% ( 110, 170 ] 368 0.022% 100.000% ( 170, 250 ] 404 0.025% 100.025% ( 250, 380 ] 514 0.031% 100.056% ( 380, 580 ] 508 0.031% 100.087% ( 580, 870 ] 486 0.030% 100.116% ( 870, 1300 ] 335 0.020% 100.137% ( 1300, 1900 ] 141 0.009% 100.145% ( 1900, 2900 ] 146 0.009% 100.154% ( 2900, 4400 ] 222 0.013% 100.168% ( 4400, 6600 ] 65 0.004% 100.172% ( 6600, 9900 ] 9 0.001% 100.172% ( 9900, 14000 ] 1 0.000% 100.172% ** Level 4 read latency histogram (micros): Count: 303883 Average: 24.4446 StdDev: 211.78 Min: 0 Median: 1.9755 Max: 10146 Percentiles: P50: 1.98 P75: 3.07 P99: 668.73 P99.9: 2721.56 P99.99: 3729.60 ------------------------------------------------------ [ 0, 1 ] 6457 2.125% 2.125% ( 1, 2 ] 149142 49.079% 51.204% ########## ( 2, 3 ] 69928 23.011% 74.215% ##### ( 3, 4 ] 32846 10.809% 85.024% ## ( 4, 6 ] 29668 9.763% 94.787% ## ( 6, 10 ] 7929 2.609% 97.396% # ( 10, 15 ] 1368 0.450% 97.846% ( 15, 22 ] 164 0.054% 97.900% ( 22, 34 ] 18 0.006% 97.906% ( 34, 51 ] 8 0.003% 97.909% ( 51, 76 ] 18 0.006% 97.915% ( 76, 110 ] 197 0.065% 97.979% ( 110, 170 ] 327 0.108% 98.087% ( 170, 250 ] 470 0.155% 98.242% ( 250, 380 ] 756 0.249% 98.491% ( 380, 580 ] 1129 0.372% 98.862% ( 580, 870 ] 1370 0.451% 99.313% ( 870, 1300 ] 968 0.319% 99.631% ( 1300, 1900 ] 522 0.172% 99.803% ( 1900, 2900 ] 358 0.118% 99.921% ( 2900, 4400 ] 379 0.125% 100.046% ( 4400, 6600 ] 95 0.031% 100.077% ( 6600, 9900 ] 17 0.006% 100.083% ( 9900, 14000 ] 1 0.000% 100.083% ** Level 5 read latency histogram (micros): Count: 300 Average: 1234.5267 StdDev: 1524.45 Min: 75 Median: 661.9565 Max: 11830 Percentiles: P50: 661.96 P75: 1773.68 P99: 7700.00 P99.9: 11830.00 P99.99: 11830.00 ------------------------------------------------------ ( 51, 76 ] 1 0.333% 0.333% ( 76, 110 ] 17 5.667% 6.000% # ( 110, 170 ] 45 15.000% 21.000% ### ( 170, 250 ] 18 6.000% 27.000% # ( 250, 380 ] 30 10.000% 37.000% ## ( 380, 580 ] 26 8.667% 45.667% ## ( 580, 870 ] 46 15.333% 61.000% ### ( 870, 1300 ] 27 9.000% 70.000% ## ( 1300, 1900 ] 19 6.333% 76.333% # ( 1900, 2900 ] 32 10.667% 87.000% ## ( 2900, 4400 ] 26 8.667% 95.667% ## ( 4400, 6600 ] 9 3.000% 98.667% # ( 6600, 9900 ] 3 1.000% 99.667% ( 9900, 14000 ] 1 0.333% 100.000% ** DB Stats ** Uptime(secs): 47.8 total, 8.1 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 205.97 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:20.273 H:M:S, 42.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 121.76 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:5.079 H:M:S, 62.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/18-16:43:28 ... thread 0: (1000000,11000000) ops and (324923.1,217035.3) ops/second in (3.077651,50.682988) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/11 4.42 GB 151.0 10.6 0.0 10.6 21.1 10.4 0.0 2.0 141.1 279.5 77.21 68.09 181 0.427 11M 21K 0.0 0.0 L1 9/9 1.13 GB 0.0 6.7 5.8 1.0 6.7 5.7 0.2 1.2 227.8 225.3 30.32 29.04 4 7.581 6691K 31K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 4.7 2.0 248.1 247.9 1.52 1.47 2 0.762 383K 238 0.0 0.0 L3 20/0 923.70 MB 0.9 7.2 4.3 2.9 7.1 4.2 0.7 1.7 145.5 144.8 50.33 33.10 33 1.525 7438K 38K 0.0 0.0 L4 163/0 9.43 GB 1.0 5.2 4.0 1.2 5.1 4.0 0.8 1.3 138.3 137.4 38.27 24.28 61 0.627 5228K 27K 0.0 0.0 L5 1100/0 90.55 GB 0.9 0.0 0.0 0.0 0.0 0.0 5.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1308/20 106.43 GB 0.0 30.1 14.2 15.8 40.4 24.5 11.5 3.9 155.8 209.1 197.65 155.98 281 0.703 30M 119K 0.0 0.0 Int 0/0 0.00 KB 0.0 30.1 14.2 15.8 40.4 24.5 11.4 3.9 155.8 209.1 197.65 155.98 281 0.703 30M 119K 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 30.1 14.2 15.8 29.9 14.1 0.0 0.0 188.1 187.1 163.70 128.62 132 1.240 30M 119K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 10.5 10.5 0.0 0.0 0.0 315.4 33.95 27.36 149 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): 50.9 total, 50.7 interval Flush(GB): cumulative 10.458, interval 10.458 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: 40.37 GB write, 812.77 MB/s write, 30.08 GB read, 605.54 MB/s read, 197.7 seconds Interval compaction: 40.37 GB write, 815.60 MB/s write, 30.08 GB read, 607.65 MB/s read, 197.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 23, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 23, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 76, pending-compaction-bytes-delays: 19, pending-compaction-bytes-stops: 0, total-delays: 42, total-stops: 76, interval: 118 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4682734 Average: 2.5777 StdDev: 26.24 Min: 0 Median: 1.5383 Max: 9032 Percentiles: P50: 1.54 P75: 1.92 P99: 6.25 P99.9: 13.58 P99.99: 164.83 ------------------------------------------------------ [ 0, 1 ] 696576 14.875% 14.875% ### ( 1, 2 ] 3055430 65.249% 80.124% ############# ( 2, 3 ] 550955 11.766% 91.890% ## ( 3, 4 ] 193562 4.134% 96.023% # ( 4, 6 ] 136933 2.924% 98.948% # ( 6, 10 ] 39980 0.854% 99.801% ( 10, 15 ] 6440 0.138% 99.939% ( 15, 22 ] 821 0.018% 99.956% ( 22, 34 ] 40 0.001% 99.957% ( 34, 51 ] 21 0.000% 99.958% ( 51, 76 ] 51 0.001% 99.959% ( 76, 110 ] 680 0.015% 99.973% ( 110, 170 ] 851 0.018% 99.992% ( 170, 250 ] 394 0.008% 100.000% ( 250, 380 ] 354 0.008% 100.008% ( 380, 580 ] 324 0.007% 100.014% ( 580, 870 ] 284 0.006% 100.021% ( 870, 1300 ] 202 0.004% 100.025% ( 1300, 1900 ] 83 0.002% 100.027% ( 1900, 2900 ] 77 0.002% 100.028% ( 2900, 4400 ] 87 0.002% 100.030% ( 4400, 6600 ] 21 0.000% 100.031% ( 6600, 9900 ] 7 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 1432458 Average: 6.4658 StdDev: 107.42 Min: 0 Median: 1.8492 Max: 11534 Percentiles: P50: 1.85 P75: 2.82 P99: 9.34 P99.9: 157.20 P99.99: 507.51 ------------------------------------------------------ [ 0, 1 ] 73214 5.111% 5.111% # ( 1, 2 ] 757223 52.862% 57.973% ########### ( 2, 3 ] 298796 20.859% 78.832% #### ( 3, 4 ] 131489 9.179% 88.011% ## ( 4, 6 ] 130268 9.094% 97.105% ## ( 6, 10 ] 32481 2.268% 99.373% ( 10, 15 ] 5801 0.405% 99.778% ( 15, 22 ] 709 0.049% 99.827% ( 22, 34 ] 51 0.004% 99.831% ( 34, 51 ] 22 0.002% 99.832% ( 51, 76 ] 124 0.009% 99.841% ( 76, 110 ] 444 0.031% 99.872% ( 110, 170 ] 513 0.036% 99.908% ( 170, 250 ] 332 0.023% 99.931% ( 250, 380 ] 492 0.034% 99.965% ( 380, 580 ] 558 0.039% 100.004% ( 580, 870 ] 582 0.041% 100.045% ( 870, 1300 ] 369 0.026% 100.071% ( 1300, 1900 ] 233 0.016% 100.087% ( 1900, 2900 ] 278 0.019% 100.106% ( 2900, 4400 ] 436 0.030% 100.137% ( 4400, 6600 ] 155 0.011% 100.147% ( 6600, 9900 ] 56 0.004% 100.151% ( 9900, 14000 ] 4 0.000% 100.152% ** Level 2 read latency histogram (micros): Count: 95889 Average: 2.0273 StdDev: 4.56 Min: 0 Median: 1.4123 Max: 865 Percentiles: P50: 1.41 P75: 1.82 P99: 5.48 P99.9: 9.81 P99.99: 20.15 ------------------------------------------------------ [ 0, 1 ] 23417 24.421% 24.421% ##### ( 1, 2 ] 59495 62.046% 86.467% ############ ( 2, 3 ] 7533 7.856% 94.323% ## ( 3, 4 ] 3093 3.226% 97.548% # ( 4, 6 ] 1875 1.955% 99.504% ( 6, 10 ] 399 0.416% 99.920% ( 10, 15 ] 63 0.066% 99.985% ( 15, 22 ] 6 0.006% 99.992% ( 22, 34 ] 1 0.001% 99.993% ( 34, 51 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.002% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 1646497 Average: 4.7577 StdDev: 66.23 Min: 0 Median: 1.9492 Max: 10016 Percentiles: P50: 1.95 P75: 2.94 P99: 8.88 P99.9: 14.80 P99.99: 142.34 ------------------------------------------------------ [ 0, 1 ] 40054 2.433% 2.433% ( 1, 2 ] 825136 50.115% 52.547% ########## ( 2, 3 ] 392953 23.866% 76.413% ##### ( 3, 4 ] 175694 10.671% 87.084% ## ( 4, 6 ] 173369 10.530% 97.614% ## ( 6, 10 ] 31721 1.927% 99.540% ( 10, 15 ] 6168 0.375% 99.915% ( 15, 22 ] 720 0.044% 99.959% ( 22, 34 ] 82 0.005% 99.964% ( 34, 51 ] 35 0.002% 99.966% ( 51, 76 ] 30 0.002% 99.968% ( 76, 110 ] 172 0.010% 99.978% ( 110, 170 ] 368 0.022% 100.000% ( 170, 250 ] 404 0.025% 100.025% ( 250, 380 ] 514 0.031% 100.056% ( 380, 580 ] 508 0.031% 100.087% ( 580, 870 ] 486 0.030% 100.116% ( 870, 1300 ] 335 0.020% 100.137% ( 1300, 1900 ] 141 0.009% 100.145% ( 1900, 2900 ] 146 0.009% 100.154% ( 2900, 4400 ] 222 0.013% 100.168% ( 4400, 6600 ] 65 0.004% 100.172% ( 6600, 9900 ] 9 0.001% 100.172% ( 9900, 14000 ] 1 0.000% 100.172% ** Level 4 read latency histogram (micros): Count: 303883 Average: 24.4446 StdDev: 211.78 Min: 0 Median: 1.9755 Max: 10146 Percentiles: P50: 1.98 P75: 3.07 P99: 668.73 P99.9: 2721.56 P99.99: 3729.60 ------------------------------------------------------ [ 0, 1 ] 6457 2.125% 2.125% ( 1, 2 ] 149142 49.079% 51.204% ########## ( 2, 3 ] 69928 23.011% 74.215% ##### ( 3, 4 ] 32846 10.809% 85.024% ## ( 4, 6 ] 29668 9.763% 94.787% ## ( 6, 10 ] 7929 2.609% 97.396% # ( 10, 15 ] 1368 0.450% 97.846% ( 15, 22 ] 164 0.054% 97.900% ( 22, 34 ] 18 0.006% 97.906% ( 34, 51 ] 8 0.003% 97.909% ( 51, 76 ] 18 0.006% 97.915% ( 76, 110 ] 197 0.065% 97.979% ( 110, 170 ] 327 0.108% 98.087% ( 170, 250 ] 470 0.155% 98.242% ( 250, 380 ] 756 0.249% 98.491% ( 380, 580 ] 1129 0.372% 98.862% ( 580, 870 ] 1370 0.451% 99.313% ( 870, 1300 ] 968 0.319% 99.631% ( 1300, 1900 ] 522 0.172% 99.803% ( 1900, 2900 ] 358 0.118% 99.921% ( 2900, 4400 ] 379 0.125% 100.046% ( 4400, 6600 ] 95 0.031% 100.077% ( 6600, 9900 ] 17 0.006% 100.083% ( 9900, 14000 ] 1 0.000% 100.083% ** Level 5 read latency histogram (micros): Count: 300 Average: 1234.5267 StdDev: 1524.45 Min: 75 Median: 661.9565 Max: 11830 Percentiles: P50: 661.96 P75: 1773.68 P99: 7700.00 P99.9: 11830.00 P99.99: 11830.00 ------------------------------------------------------ ( 51, 76 ] 1 0.333% 0.333% ( 76, 110 ] 17 5.667% 6.000% # ( 110, 170 ] 45 15.000% 21.000% ### ( 170, 250 ] 18 6.000% 27.000% # ( 250, 380 ] 30 10.000% 37.000% ## ( 380, 580 ] 26 8.667% 45.667% ## ( 580, 870 ] 46 15.333% 61.000% ### ( 870, 1300 ] 27 9.000% 70.000% ## ( 1300, 1900 ] 19 6.333% 76.333% # ( 1900, 2900 ] 32 10.667% 87.000% ## ( 2900, 4400 ] 26 8.667% 95.667% ## ( 4400, 6600 ] 9 3.000% 98.667% # ( 6600, 9900 ] 3 1.000% 99.667% ( 9900, 14000 ] 1 0.333% 100.000% ** DB Stats ** Uptime(secs): 50.9 total, 3.1 interval Cumulative writes: 0 writes, 11M keys, 0 commit groups, 0.0 writes per commit group, ingest: 10.57 GB, 212.86 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:20.700 H:M:S, 40.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.80 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.427 H:M:S, 13.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 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.262 micros/op 190040 ops/sec 60.003 seconds 11402999 operations; 184.1 MB/s Microseconds per write: Count: 11402999 Average: 5.2620 StdDev: 478.39 Min: 0 Median: 1.7418 Max: 741336 Percentiles: P50: 1.74 P75: 2.76 P99: 8.78 P99.9: 1054.84 P99.99: 2527.16 ------------------------------------------------------ [ 0, 1 ] 1523581 13.361% 13.361% ### ( 1, 2 ] 5632293 49.393% 62.754% ########## ( 2, 3 ] 1831646 16.063% 78.817% ### ( 3, 4 ] 1579166 13.849% 92.666% ### ( 4, 6 ] 639619 5.609% 98.275% # ( 6, 10 ] 118736 1.041% 99.316% ( 10, 15 ] 36770 0.322% 99.639% ( 15, 22 ] 9195 0.081% 99.719% ( 22, 34 ] 2025 0.018% 99.737% ( 34, 51 ] 248 0.002% 99.739% ( 51, 76 ] 47 0.000% 99.740% ( 76, 110 ] 7653 0.067% 99.807% ( 110, 170 ] 3436 0.030% 99.837% ( 170, 250 ] 358 0.003% 99.840% ( 250, 380 ] 206 0.002% 99.842% ( 380, 580 ] 44 0.000% 99.842% ( 580, 870 ] 30 0.000% 99.843% ( 870, 1300 ] 15221 0.133% 99.976% ( 1300, 1900 ] 72 0.001% 99.977% ( 1900, 2900 ] 2412 0.021% 99.998% ( 2900, 4400 ] 159 0.001% 99.999% ( 4400, 6600 ] 37 0.000% 100.000% ( 6600, 9900 ] 15 0.000% 100.000% ( 9900, 14000 ] 3 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 170000, 250000 ] 18 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 380000, 570000 ] 1 0.000% 100.000% ( 570000, 860000 ] 3 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 : 223626 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 : 11402999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 11767894968 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 : 659 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 28526566 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 : 37151561953 rocksdb.compact.write.bytes COUNT : 36936452534 rocksdb.flush.write.bytes COUNT : 11758226673 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 : 68 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 : 342 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 : 11663456256 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4560896 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 : 37262488244 rocksdb.non.last.level.read.count COUNT : 9004525 rocksdb.block.checksum.compute.count COUNT : 9003275 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.397067 P95 : 3.911239 P99 : 7.122646 P100 : 741333.000000 COUNT : 11402999 SUM : 54773618 rocksdb.compaction.times.micros P50 : 984054.054054 P95 : 2712500.000000 P99 : 12530000.000000 P100 : 14407194.000000 COUNT : 135 SUM : 166750740 rocksdb.compaction.times.cpu_micros P50 : 752826.086957 P95 : 1852272.727273 P99 : 11165000.000000 P100 : 13689754.000000 COUNT : 135 SUM : 131613863 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 : 711.666667 P95 : 1284.770833 P99 : 135800.000000 P100 : 179504.000000 COUNT : 157 SUM : 494569 rocksdb.compaction.outfile.sync.micros P50 : 1230.380952 P95 : 140750.000000 P99 : 243828.571429 P100 : 523393.000000 COUNT : 454 SUM : 10846722 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 : 104.876712 P95 : 1914.285714 P99 : 3991.250000 P100 : 4982.000000 COUNT : 318 SUM : 116826 rocksdb.table.open.io.micros P50 : 1297.556818 P95 : 7924.714286 P99 : 12364.555556 P100 : 19786.000000 COUNT : 659 SUM : 1350540 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.704213 P95 : 7.975853 P99 : 10.930941 P100 : 11542.000000 COUNT : 9001262 SUM : 57900998 rocksdb.read.block.get.micros P50 : 404.161074 P95 : 3402.500000 P99 : 5884.421053 P100 : 12255.000000 COUNT : 1318 SUM : 1121291 rocksdb.write.raw.block.micros P50 : 0.513400 P95 : 0.975461 P99 : 2.978556 P100 : 16217.000000 COUNT : 11794275 SUM : 24738439 rocksdb.numfiles.in.singlecompaction P50 : 2.761905 P95 : 5.400000 P99 : 15.910000 P100 : 19.000000 COUNT : 174 SUM : 585 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.557912 P95 : 1130.296103 P99 : 2254.907485 P100 : 741142.000000 COUNT : 172503 SUM : 28542692 rocksdb.sst.read.micros P50 : 1.644862 P95 : 4.828727 P99 : 8.422013 P100 : 11830.000000 COUNT : 9004570 SUM : 39225224 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 : 11402999 SUM : 11767894968 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 : 214561.403509 P95 : 434625.000000 P99 : 906957.000000 P100 : 906957.000000 COUNT : 157 SUM : 35458346 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 : 451 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