[2024-12-05 18:52:07.370065] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 23.11.0 initialization... [2024-12-05 18:52:07.370210] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid2306482 ] Set seed to 1733421127366564 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-05 18:52:07.472511] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-05 18:52:07.690157] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-05 18:52:07.690212] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 2306482' to capture a snapshot of events at runtime. [2024-12-05 18:52:07.690222] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid2306482 for offline analysis/debug. [2024-12-05 18:52:07.690247] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Thu Dec 5 18:52:16 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/05-18:52:18 ... thread 0: (1000000,1000000) ops and (364421.9,364421.9) ops/second in (2.744072,2.744072) 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.05 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 356.3 2.30 2.05 12 0.192 0 0 0.0 0.0 L2 3/2 251.73 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.1 2.0 250.6 250.4 1.51 1.45 2 0.754 383K 209 0.0 0.0 L3 11/0 930.22 MB 0.9 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.72 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 1036/0 85.51 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 1175/8 96.94 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.5 99.3 314.3 3.81 3.50 14 0.272 383K 209 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.1 1.5 99.3 314.3 3.81 3.50 14 0.272 383K 209 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 250.6 250.4 1.51 1.45 2 0.754 383K 209 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 356.3 2.30 2.05 12 0.192 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 2.9 total, 2.7 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, 405.70 MB/s write, 0.37 GB read, 128.12 MB/s read, 3.8 seconds Interval compaction: 1.17 GB write, 435.87 MB/s write, 0.37 GB read, 137.65 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: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 98547 Average: 1.9749 StdDev: 22.33 Min: 0 Median: 1.2605 Max: 3684 Percentiles: P50: 1.26 P75: 1.68 P99: 3.89 P99.9: 9.55 P99.99: 487.26 ------------------------------------------------------ [ 0, 1 ] 33799 34.297% 34.297% ####### ( 1, 2 ] 59398 60.274% 94.571% ############ ( 2, 3 ] 3299 3.348% 97.919% # ( 3, 4 ] 1204 1.222% 99.141% ( 4, 6 ] 546 0.554% 99.695% ( 6, 10 ] 229 0.232% 99.927% ( 10, 15 ] 42 0.043% 99.970% ( 15, 22 ] 5 0.005% 99.975% ( 22, 34 ] 2 0.002% 99.977% ( 110, 170 ] 8 0.008% 99.985% ( 170, 250 ] 3 0.003% 99.988% ( 250, 380 ] 1 0.001% 99.989% ( 380, 580 ] 4 0.004% 99.993% ( 580, 870 ] 1 0.001% 99.994% ( 1300, 1900 ] 2 0.002% 99.996% ( 1900, 2900 ] 2 0.002% 99.998% ( 2900, 4400 ] 3 0.003% 100.001% ** Level 2 read latency histogram (micros): Count: 49603 Average: 2.0170 StdDev: 20.81 Min: 0 Median: 1.2871 Max: 3560 Percentiles: P50: 1.29 P75: 1.70 P99: 4.91 P99.9: 9.85 P99.99: 591.51 ------------------------------------------------------ [ 0, 1 ] 16167 32.593% 32.593% ####### ( 1, 2 ] 30077 60.635% 93.228% ############ ( 2, 3 ] 1823 3.675% 96.903% # ( 3, 4 ] 830 1.673% 98.577% ( 4, 6 ] 460 0.927% 99.504% ( 6, 10 ] 204 0.411% 99.915% ( 10, 15 ] 23 0.046% 99.962% ( 15, 22 ] 5 0.010% 99.972% ( 22, 34 ] 3 0.006% 99.978% ( 110, 170 ] 1 0.002% 99.980% ( 170, 250 ] 2 0.004% 99.984% ( 250, 380 ] 2 0.004% 99.988% ( 380, 580 ] 1 0.002% 99.990% ( 580, 870 ] 1 0.002% 99.992% ( 870, 1300 ] 2 0.004% 99.996% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 50 Average: 2974.3400 StdDev: 1950.98 Min: 86 Median: 2515.3846 Max: 7458 Percentiles: P50: 2515.38 P75: 3922.73 P99: 7458.00 P99.9: 7458.00 P99.99: 7458.00 ------------------------------------------------------ ( 76, 110 ] 2 4.000% 4.000% # ( 170, 250 ] 1 2.000% 6.000% ( 380, 580 ] 2 4.000% 10.000% # ( 580, 870 ] 1 2.000% 12.000% ( 870, 1300 ] 1 2.000% 14.000% ( 1300, 1900 ] 10 20.000% 34.000% #### ( 1900, 2900 ] 13 26.000% 60.000% ##### ( 2900, 4400 ] 11 22.000% 82.000% #### ( 4400, 6600 ] 4 8.000% 90.000% ## ( 6600, 9900 ] 5 10.000% 100.000% ## ** Level 4 read latency histogram (micros): Count: 25 Average: 3297.6800 StdDev: 2484.53 Min: 85 Median: 2685.7143 Max: 9566 Percentiles: P50: 2685.71 P75: 4087.50 P99: 9566.00 P99.9: 9566.00 P99.99: 9566.00 ------------------------------------------------------ ( 76, 110 ] 1 4.000% 4.000% # ( 250, 380 ] 2 8.000% 12.000% ## ( 1300, 1900 ] 4 16.000% 28.000% ### ( 1900, 2900 ] 7 28.000% 56.000% ###### ( 2900, 4400 ] 6 24.000% 80.000% ##### ( 4400, 6600 ] 1 4.000% 84.000% # ( 6600, 9900 ] 4 16.000% 100.000% ### ** DB Stats ** Uptime(secs): 2.9 total, 2.7 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 333.63 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.205 H:M:S, 6.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 358.36 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.205 H:M:S, 7.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/05-18:52:22 ... thread 0: (1000000,2000000) ops and (306730.6,333096.7) ops/second in (3.260190,6.004262) 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.23 GB 100.7 0.9 0.0 0.9 2.7 1.8 0.0 1.5 100.4 315.4 8.79 8.10 29 0.303 895K 1009 0.0 0.0 L1 1/0 3.46 MB 0.3 0.4 0.4 0.0 0.4 0.4 0.2 1.0 233.2 232.8 1.62 1.56 1 1.621 383K 591 0.0 0.0 L2 2/1 54.05 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 250.6 250.4 1.51 1.45 2 0.754 383K 209 0.0 0.0 L3 21/11 1.25 GB 0.3 0.2 0.2 0.0 0.2 0.2 0.4 1.0 230.7 230.7 1.08 1.02 1 1.081 253K 0 0.0 0.0 L4 169/0 9.57 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 150.5 150.5 1.49 1.13 1 1.488 227K 0 0.0 0.0 L5 1040/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1241/16 97.98 GB 0.0 2.1 1.0 1.0 3.9 2.9 1.5 2.1 145.8 276.1 14.48 13.26 34 0.426 2143K 1809 0.0 0.0 Int 0/0 0.00 KB 0.0 2.1 1.0 1.0 3.9 2.9 1.4 2.1 145.8 276.1 14.48 13.26 34 0.426 2143K 1809 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 2.1 1.0 1.0 2.1 1.0 0.0 0.0 231.5 231.3 9.12 8.51 8 1.140 2143K 1809 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 352.1 5.37 4.76 26 0.206 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.2 total, 6.0 interval Flush(GB): cumulative 1.846, interval 1.846 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.91 GB write, 644.01 MB/s write, 2.06 GB read, 339.97 MB/s read, 14.5 seconds Interval compaction: 3.91 GB write, 665.90 MB/s write, 2.06 GB read, 351.53 MB/s read, 14.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 8, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 8, interval: 8 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 410274 Average: 2.3006 StdDev: 14.48 Min: 0 Median: 1.5249 Max: 3684 Percentiles: P50: 1.52 P75: 1.91 P99: 5.82 P99.9: 11.09 P99.99: 14.97 ------------------------------------------------------ [ 0, 1 ] 66492 16.207% 16.207% ### ( 1, 2 ] 264151 64.384% 80.591% ############# ( 2, 3 ] 46092 11.234% 91.825% ## ( 3, 4 ] 17348 4.228% 96.054% # ( 4, 6 ] 13307 3.243% 99.297% # ( 6, 10 ] 2371 0.578% 99.875% ( 10, 15 ] 476 0.116% 99.991% ( 15, 22 ] 45 0.011% 100.002% ( 22, 34 ] 9 0.002% 100.004% ( 34, 51 ] 1 0.000% 100.004% ( 51, 76 ] 3 0.001% 100.005% ( 110, 170 ] 10 0.002% 100.008% ( 170, 250 ] 12 0.003% 100.010% ( 250, 380 ] 7 0.002% 100.012% ( 380, 580 ] 6 0.001% 100.014% ( 580, 870 ] 4 0.001% 100.015% ( 870, 1300 ] 7 0.002% 100.016% ( 1300, 1900 ] 5 0.001% 100.018% ( 1900, 2900 ] 3 0.001% 100.018% ( 2900, 4400 ] 4 0.001% 100.019% ** Level 1 read latency histogram (micros): Count: 25 Average: 175.4800 StdDev: 314.40 Min: 1 Median: 2.5000 Max: 1132 Percentiles: P50: 2.50 P75: 230.00 P99: 1132.00 P99.9: 1132.00 P99.99: 1132.00 ------------------------------------------------------ [ 0, 1 ] 5 20.000% 20.000% #### ( 1, 2 ] 6 24.000% 44.000% ##### ( 2, 3 ] 3 12.000% 56.000% ## ( 3, 4 ] 2 8.000% 64.000% ## ( 4, 6 ] 1 4.000% 68.000% # ( 110, 170 ] 1 4.000% 72.000% # ( 170, 250 ] 1 4.000% 76.000% # ( 380, 580 ] 3 12.000% 88.000% ## ( 580, 870 ] 1 4.000% 92.000% # ( 870, 1300 ] 2 8.000% 100.000% ## ** Level 2 read latency histogram (micros): Count: 95656 Average: 2.1119 StdDev: 15.00 Min: 0 Median: 1.4164 Max: 3560 Percentiles: P50: 1.42 P75: 1.81 P99: 5.63 P99.9: 9.96 P99.99: 187.38 ------------------------------------------------------ [ 0, 1 ] 22561 23.586% 23.586% ##### ( 1, 2 ] 60684 63.440% 87.025% ############# ( 2, 3 ] 6984 7.301% 94.327% # ( 3, 4 ] 2880 3.011% 97.337% # ( 4, 6 ] 1952 2.041% 99.378% ( 6, 10 ] 504 0.527% 99.905% ( 10, 15 ] 69 0.072% 99.977% ( 15, 22 ] 7 0.007% 99.984% ( 22, 34 ] 4 0.004% 99.989% ( 110, 170 ] 1 0.001% 99.990% ( 170, 250 ] 2 0.002% 99.992% ( 250, 380 ] 2 0.002% 99.994% ( 380, 580 ] 1 0.001% 99.995% ( 580, 870 ] 1 0.001% 99.996% ( 870, 1300 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 189843 Average: 3.8798 StdDev: 60.12 Min: 0 Median: 1.6480 Max: 7458 Percentiles: P50: 1.65 P75: 2.18 P99: 9.02 P99.9: 220.48 P99.99: 1043.35 ------------------------------------------------------ [ 0, 1 ] 17745 9.347% 9.347% ## ( 1, 2 ] 119104 62.738% 72.085% ############# ( 2, 3 ] 30028 15.817% 87.903% ### ( 3, 4 ] 9953 5.243% 93.145% # ( 4, 6 ] 8870 4.672% 97.818% # ( 6, 10 ] 2975 1.567% 99.385% ( 10, 15 ] 582 0.307% 99.691% ( 15, 22 ] 63 0.033% 99.725% ( 22, 34 ] 11 0.006% 99.730% ( 34, 51 ] 3 0.002% 99.732% ( 76, 110 ] 77 0.041% 99.772% ( 110, 170 ] 187 0.099% 99.871% ( 170, 250 ] 89 0.047% 99.918% ( 250, 380 ] 57 0.030% 99.948% ( 380, 580 ] 50 0.026% 99.974% ( 580, 870 ] 29 0.015% 99.989% ( 870, 1300 ] 5 0.003% 99.992% ( 1300, 1900 ] 13 0.007% 99.999% ( 1900, 2900 ] 14 0.007% 100.006% ( 2900, 4400 ] 11 0.006% 100.012% ( 4400, 6600 ] 4 0.002% 100.014% ( 6600, 9900 ] 5 0.003% 100.017% ** Level 4 read latency histogram (micros): Count: 310 Average: 275.4097 StdDev: 1141.01 Min: 0 Median: 1.9703 Max: 9566 Percentiles: P50: 1.97 P75: 7.25 P99: 7342.50 P99.9: 9566.00 P99.99: 9566.00 ------------------------------------------------------ [ 0, 1 ] 57 18.387% 18.387% #### ( 1, 2 ] 101 32.581% 50.968% ####### ( 2, 3 ] 45 14.516% 65.484% ### ( 3, 4 ] 14 4.516% 70.000% # ( 4, 6 ] 13 4.194% 74.194% # ( 6, 10 ] 8 2.581% 76.774% # ( 10, 15 ] 21 6.774% 83.548% # ( 15, 22 ] 20 6.452% 90.000% # ( 76, 110 ] 2 0.645% 90.645% ( 110, 170 ] 2 0.645% 91.290% ( 170, 250 ] 2 0.645% 91.935% ( 250, 380 ] 2 0.645% 92.581% ( 580, 870 ] 1 0.323% 92.903% ( 1300, 1900 ] 4 1.290% 94.194% ( 1900, 2900 ] 7 2.258% 96.452% ( 2900, 4400 ] 6 1.935% 98.387% ( 4400, 6600 ] 1 0.323% 98.710% ( 6600, 9900 ] 4 1.290% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 928.2000 StdDev: 979.83 Min: 139 Median: 480.0000 Max: 3662 Percentiles: P50: 480.00 P75: 1500.00 P99: 3662.00 P99.9: 3662.00 P99.99: 3662.00 ------------------------------------------------------ ( 110, 170 ] 5 25.000% 25.000% ##### ( 170, 250 ] 3 15.000% 40.000% ### ( 250, 380 ] 1 5.000% 45.000% # ( 380, 580 ] 2 10.000% 55.000% ## ( 580, 870 ] 1 5.000% 60.000% # ( 870, 1300 ] 2 10.000% 70.000% ## ( 1300, 1900 ] 3 15.000% 85.000% ### ( 1900, 2900 ] 2 10.000% 95.000% ## ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 6.2 total, 3.3 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 316.96 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.827 H:M:S, 13.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 301.88 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.622 H:M:S, 19.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/05-18:52:25 ... thread 0: (1000000,3000000) ops and (332620.4,332937.8) ops/second in (3.006430,9.010692) 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 2.15 GB 56.7 1.4 0.0 1.4 4.2 2.8 0.0 1.5 105.6 312.0 13.73 12.68 44 0.312 1471K 1625 0.0 0.0 L1 1/1 3.46 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 233.2 232.8 1.62 1.56 1 1.621 383K 591 0.0 0.0 L2 1/0 51.72 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 250.6 250.4 1.51 1.45 2 0.754 383K 209 0.0 0.0 L3 17/0 762.83 MB 0.8 1.2 0.2 0.9 1.2 0.2 0.4 4.7 239.4 239.0 4.94 4.55 2 2.468 1200K 2364 0.0 0.0 L4 173/0 9.76 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 150.5 150.5 1.49 1.13 1 1.488 227K 0 0.0 0.0 L5 1044/0 86.19 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 1251/12 98.90 GB 0.0 3.5 1.0 2.5 6.3 3.8 2.3 2.3 155.1 276.7 23.28 21.37 50 0.466 3666K 4789 0.0 0.0 Int 0/0 0.00 KB 0.0 3.5 1.0 2.5 6.3 3.8 2.2 2.3 155.1 276.7 23.28 21.37 50 0.466 3666K 4789 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.5 1.0 2.5 3.5 1.0 0.0 0.0 237.7 237.4 15.19 14.22 11 1.381 3666K 4789 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 350.4 8.09 7.16 39 0.207 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.2 total, 9.0 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.29 GB write, 698.84 MB/s write, 3.53 GB read, 391.78 MB/s read, 23.3 seconds Interval compaction: 6.29 GB write, 714.67 MB/s write, 3.53 GB read, 400.65 MB/s read, 23.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 728171 Average: 2.3183 StdDev: 15.18 Min: 0 Median: 1.5401 Max: 4328 Percentiles: P50: 1.54 P75: 1.92 P99: 5.76 P99.9: 11.19 P99.99: 14.80 ------------------------------------------------------ [ 0, 1 ] 103849 14.262% 14.262% ### ( 1, 2 ] 481839 66.171% 80.433% ############# ( 2, 3 ] 86098 11.824% 92.257% ## ( 3, 4 ] 29647 4.071% 96.328% # ( 4, 6 ] 22083 3.033% 99.361% # ( 6, 10 ] 3713 0.510% 99.871% ( 10, 15 ] 907 0.125% 99.995% ( 15, 22 ] 72 0.010% 100.005% ( 22, 34 ] 13 0.002% 100.007% ( 34, 51 ] 3 0.000% 100.007% ( 51, 76 ] 3 0.000% 100.008% ( 76, 110 ] 19 0.003% 100.010% ( 110, 170 ] 21 0.003% 100.013% ( 170, 250 ] 22 0.003% 100.016% ( 250, 380 ] 15 0.002% 100.018% ( 380, 580 ] 12 0.002% 100.020% ( 580, 870 ] 8 0.001% 100.021% ( 870, 1300 ] 8 0.001% 100.022% ( 1300, 1900 ] 11 0.002% 100.024% ( 1900, 2900 ] 5 0.001% 100.024% ( 2900, 4400 ] 7 0.001% 100.025% ** Level 1 read latency histogram (micros): Count: 26 Average: 168.8846 StdDev: 310.06 Min: 1 Median: 2.6667 Max: 1132 Percentiles: P50: 2.67 P75: 210.00 P99: 1132.00 P99.9: 1132.00 P99.99: 1132.00 ------------------------------------------------------ [ 0, 1 ] 5 19.231% 19.231% #### ( 1, 2 ] 6 23.077% 42.308% ##### ( 2, 3 ] 3 11.538% 53.846% ## ( 3, 4 ] 3 11.538% 65.385% ## ( 4, 6 ] 1 3.846% 69.231% # ( 110, 170 ] 1 3.846% 73.077% # ( 170, 250 ] 1 3.846% 76.923% # ( 380, 580 ] 3 11.538% 88.462% ## ( 580, 870 ] 1 3.846% 92.308% # ( 870, 1300 ] 2 7.692% 100.000% ## ** Level 2 read latency histogram (micros): Count: 124183 Average: 2.4196 StdDev: 17.15 Min: 0 Median: 1.4598 Max: 3560 Percentiles: P50: 1.46 P75: 1.85 P99: 6.34 P99.9: 100.73 P99.99: 604.10 ------------------------------------------------------ [ 0, 1 ] 25687 20.685% 20.685% #### ( 1, 2 ] 79175 63.757% 84.442% ############# ( 2, 3 ] 10855 8.741% 93.183% ## ( 3, 4 ] 4117 3.315% 96.498% # ( 4, 6 ] 3020 2.432% 98.930% ( 6, 10 ] 1011 0.814% 99.744% ( 10, 15 ] 155 0.125% 99.869% ( 15, 22 ] 12 0.010% 99.878% ( 22, 34 ] 4 0.003% 99.882% ( 34, 51 ] 1 0.001% 99.882% ( 76, 110 ] 30 0.024% 99.907% ( 110, 170 ] 59 0.048% 99.954% ( 170, 250 ] 21 0.017% 99.971% ( 250, 380 ] 10 0.008% 99.979% ( 380, 580 ] 13 0.010% 99.990% ( 580, 870 ] 7 0.006% 99.995% ( 870, 1300 ] 3 0.002% 99.998% ( 1900, 2900 ] 2 0.002% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 264867 Average: 3.5878 StdDev: 51.74 Min: 0 Median: 1.5968 Max: 7458 Percentiles: P50: 1.60 P75: 1.99 P99: 8.93 P99.9: 215.45 P99.99: 858.35 ------------------------------------------------------ [ 0, 1 ] 31033 11.716% 11.716% ## ( 1, 2 ] 169920 64.153% 75.869% ############# ( 2, 3 ] 35844 13.533% 89.402% ### ( 3, 4 ] 12065 4.555% 93.957% # ( 4, 6 ] 10248 3.869% 97.826% # ( 6, 10 ] 4247 1.603% 99.430% ( 10, 15 ] 676 0.255% 99.685% ( 15, 22 ] 68 0.026% 99.711% ( 22, 34 ] 11 0.004% 99.715% ( 34, 51 ] 3 0.001% 99.716% ( 51, 76 ] 1 0.000% 99.716% ( 76, 110 ] 131 0.049% 99.766% ( 110, 170 ] 279 0.105% 99.871% ( 170, 250 ] 134 0.051% 99.922% ( 250, 380 ] 73 0.028% 99.949% ( 380, 580 ] 72 0.027% 99.977% ( 580, 870 ] 37 0.014% 99.991% ( 870, 1300 ] 6 0.002% 99.993% ( 1300, 1900 ] 16 0.006% 99.999% ( 1900, 2900 ] 14 0.005% 100.004% ( 2900, 4400 ] 11 0.004% 100.008% ( 4400, 6600 ] 4 0.002% 100.010% ( 6600, 9900 ] 5 0.002% 100.012% ** Level 4 read latency histogram (micros): Count: 310 Average: 275.4097 StdDev: 1141.01 Min: 0 Median: 1.9703 Max: 9566 Percentiles: P50: 1.97 P75: 7.25 P99: 7342.50 P99.9: 9566.00 P99.99: 9566.00 ------------------------------------------------------ [ 0, 1 ] 57 18.387% 18.387% #### ( 1, 2 ] 101 32.581% 50.968% ####### ( 2, 3 ] 45 14.516% 65.484% ### ( 3, 4 ] 14 4.516% 70.000% # ( 4, 6 ] 13 4.194% 74.194% # ( 6, 10 ] 8 2.581% 76.774% # ( 10, 15 ] 21 6.774% 83.548% # ( 15, 22 ] 20 6.452% 90.000% # ( 76, 110 ] 2 0.645% 90.645% ( 110, 170 ] 2 0.645% 91.290% ( 170, 250 ] 2 0.645% 91.935% ( 250, 380 ] 2 0.645% 92.581% ( 580, 870 ] 1 0.323% 92.903% ( 1300, 1900 ] 4 1.290% 94.194% ( 1900, 2900 ] 7 2.258% 96.452% ( 2900, 4400 ] 6 1.935% 98.387% ( 4400, 6600 ] 1 0.323% 98.710% ( 6600, 9900 ] 4 1.290% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 915.1250 StdDev: 1012.71 Min: 113 Median: 380.0000 Max: 3662 Percentiles: P50: 380.00 P75: 1420.00 P99: 3662.00 P99.9: 3662.00 P99.99: 3662.00 ------------------------------------------------------ ( 110, 170 ] 9 22.500% 22.500% ##### ( 170, 250 ] 5 12.500% 35.000% ### ( 250, 380 ] 6 15.000% 50.000% ### ( 380, 580 ] 2 5.000% 55.000% # ( 580, 870 ] 4 10.000% 65.000% ## ( 870, 1300 ] 3 7.500% 72.500% ## ( 1300, 1900 ] 5 12.500% 85.000% ### ( 1900, 2900 ] 3 7.500% 92.500% ## ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 9.2 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 320.36 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.260 H:M:S, 13.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 327.36 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.433 H:M:S, 14.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/05-18:52:28 ... thread 0: (1000000,4000000) ops and (316270.1,328608.3) ops/second in (3.161854,12.172546) 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 20/15 3.13 GB 125.9 2.2 0.0 2.2 6.0 3.8 0.0 1.6 115.1 310.1 19.70 18.29 61 0.323 2302K 2462 0.0 0.0 L1 1/1 3.46 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 233.2 232.8 1.62 1.56 1 1.621 383K 591 0.0 0.0 L2 1/0 51.72 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 250.6 250.4 1.51 1.45 2 0.754 383K 209 0.0 0.0 L3 17/0 762.83 MB 0.8 1.2 0.2 0.9 1.2 0.2 0.4 4.7 239.4 239.0 4.94 4.55 2 2.468 1200K 2364 0.0 0.0 L4 173/0 9.76 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 150.5 150.5 1.49 1.13 1 1.488 227K 0 0.0 0.0 L5 1044/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1256/16 99.88 GB 0.0 4.3 1.0 3.3 8.1 4.8 2.3 2.2 151.4 282.6 29.25 26.99 67 0.437 4498K 5626 0.0 0.0 Int 0/0 0.00 KB 0.0 4.3 1.0 3.3 8.1 4.8 2.2 2.2 151.4 282.6 29.25 26.99 67 0.437 4498K 5626 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.0 3.3 4.3 1.0 0.0 0.0 242.1 241.7 18.30 17.27 14 1.307 4498K 5626 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 350.9 10.95 9.72 53 0.207 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.4 total, 12.2 interval Flush(GB): cumulative 3.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.07 GB write, 667.82 MB/s write, 4.33 GB read, 357.85 MB/s read, 29.3 seconds Interval compaction: 8.07 GB write, 679.02 MB/s write, 4.33 GB read, 363.85 MB/s read, 29.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 2, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 2, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 2, total-stops: 15, interval: 17 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1124793 Average: 2.3337 StdDev: 13.93 Min: 0 Median: 1.5362 Max: 4328 Percentiles: P50: 1.54 P75: 1.91 P99: 5.85 P99.9: 11.72 P99.99: 16.70 ------------------------------------------------------ [ 0, 1 ] 159147 14.149% 14.149% ### ( 1, 2 ] 752104 66.866% 81.015% ############# ( 2, 3 ] 130732 11.623% 92.638% ## ( 3, 4 ] 42092 3.742% 96.380% # ( 4, 6 ] 31887 2.835% 99.215% # ( 6, 10 ] 7195 0.640% 99.855% ( 10, 15 ] 1504 0.134% 99.988% ( 15, 22 ] 109 0.010% 99.998% ( 22, 34 ] 20 0.002% 100.000% ( 34, 51 ] 5 0.000% 100.000% ( 51, 76 ] 7 0.001% 100.001% ( 76, 110 ] 74 0.007% 100.007% ( 110, 170 ] 96 0.009% 100.016% ( 170, 250 ] 48 0.004% 100.020% ( 250, 380 ] 37 0.003% 100.023% ( 380, 580 ] 46 0.004% 100.028% ( 580, 870 ] 25 0.002% 100.030% ( 870, 1300 ] 14 0.001% 100.031% ( 1300, 1900 ] 12 0.001% 100.032% ( 1900, 2900 ] 6 0.001% 100.033% ( 2900, 4400 ] 8 0.001% 100.033% ** Level 1 read latency histogram (micros): Count: 26 Average: 168.8846 StdDev: 310.06 Min: 1 Median: 2.6667 Max: 1132 Percentiles: P50: 2.67 P75: 210.00 P99: 1132.00 P99.9: 1132.00 P99.99: 1132.00 ------------------------------------------------------ [ 0, 1 ] 5 19.231% 19.231% #### ( 1, 2 ] 6 23.077% 42.308% ##### ( 2, 3 ] 3 11.538% 53.846% ## ( 3, 4 ] 3 11.538% 65.385% ## ( 4, 6 ] 1 3.846% 69.231% # ( 110, 170 ] 1 3.846% 73.077% # ( 170, 250 ] 1 3.846% 76.923% # ( 380, 580 ] 3 11.538% 88.462% ## ( 580, 870 ] 1 3.846% 92.308% # ( 870, 1300 ] 2 7.692% 100.000% ## ** Level 2 read latency histogram (micros): Count: 124183 Average: 2.4196 StdDev: 17.15 Min: 0 Median: 1.4598 Max: 3560 Percentiles: P50: 1.46 P75: 1.85 P99: 6.34 P99.9: 100.73 P99.99: 604.10 ------------------------------------------------------ [ 0, 1 ] 25687 20.685% 20.685% #### ( 1, 2 ] 79175 63.757% 84.442% ############# ( 2, 3 ] 10855 8.741% 93.183% ## ( 3, 4 ] 4117 3.315% 96.498% # ( 4, 6 ] 3020 2.432% 98.930% ( 6, 10 ] 1011 0.814% 99.744% ( 10, 15 ] 155 0.125% 99.869% ( 15, 22 ] 12 0.010% 99.878% ( 22, 34 ] 4 0.003% 99.882% ( 34, 51 ] 1 0.001% 99.882% ( 76, 110 ] 30 0.024% 99.907% ( 110, 170 ] 59 0.048% 99.954% ( 170, 250 ] 21 0.017% 99.971% ( 250, 380 ] 10 0.008% 99.979% ( 380, 580 ] 13 0.010% 99.990% ( 580, 870 ] 7 0.006% 99.995% ( 870, 1300 ] 3 0.002% 99.998% ( 1900, 2900 ] 2 0.002% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 264867 Average: 3.5878 StdDev: 51.74 Min: 0 Median: 1.5968 Max: 7458 Percentiles: P50: 1.60 P75: 1.99 P99: 8.93 P99.9: 215.45 P99.99: 858.35 ------------------------------------------------------ [ 0, 1 ] 31033 11.716% 11.716% ## ( 1, 2 ] 169920 64.153% 75.869% ############# ( 2, 3 ] 35844 13.533% 89.402% ### ( 3, 4 ] 12065 4.555% 93.957% # ( 4, 6 ] 10248 3.869% 97.826% # ( 6, 10 ] 4247 1.603% 99.430% ( 10, 15 ] 676 0.255% 99.685% ( 15, 22 ] 68 0.026% 99.711% ( 22, 34 ] 11 0.004% 99.715% ( 34, 51 ] 3 0.001% 99.716% ( 51, 76 ] 1 0.000% 99.716% ( 76, 110 ] 131 0.049% 99.766% ( 110, 170 ] 279 0.105% 99.871% ( 170, 250 ] 134 0.051% 99.922% ( 250, 380 ] 73 0.028% 99.949% ( 380, 580 ] 72 0.027% 99.977% ( 580, 870 ] 37 0.014% 99.991% ( 870, 1300 ] 6 0.002% 99.993% ( 1300, 1900 ] 16 0.006% 99.999% ( 1900, 2900 ] 14 0.005% 100.004% ( 2900, 4400 ] 11 0.004% 100.008% ( 4400, 6600 ] 4 0.002% 100.010% ( 6600, 9900 ] 5 0.002% 100.012% ** Level 4 read latency histogram (micros): Count: 310 Average: 275.4097 StdDev: 1141.01 Min: 0 Median: 1.9703 Max: 9566 Percentiles: P50: 1.97 P75: 7.25 P99: 7342.50 P99.9: 9566.00 P99.99: 9566.00 ------------------------------------------------------ [ 0, 1 ] 57 18.387% 18.387% #### ( 1, 2 ] 101 32.581% 50.968% ####### ( 2, 3 ] 45 14.516% 65.484% ### ( 3, 4 ] 14 4.516% 70.000% # ( 4, 6 ] 13 4.194% 74.194% # ( 6, 10 ] 8 2.581% 76.774% # ( 10, 15 ] 21 6.774% 83.548% # ( 15, 22 ] 20 6.452% 90.000% # ( 76, 110 ] 2 0.645% 90.645% ( 110, 170 ] 2 0.645% 91.290% ( 170, 250 ] 2 0.645% 91.935% ( 250, 380 ] 2 0.645% 92.581% ( 580, 870 ] 1 0.323% 92.903% ( 1300, 1900 ] 4 1.290% 94.194% ( 1900, 2900 ] 7 2.258% 96.452% ( 2900, 4400 ] 6 1.935% 98.387% ( 4400, 6600 ] 1 0.323% 98.710% ( 6600, 9900 ] 4 1.290% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 915.1250 StdDev: 1012.71 Min: 113 Median: 380.0000 Max: 3662 Percentiles: P50: 380.00 P75: 1420.00 P99: 3662.00 P99.9: 3662.00 P99.99: 3662.00 ------------------------------------------------------ ( 110, 170 ] 9 22.500% 22.500% ##### ( 170, 250 ] 5 12.500% 35.000% ### ( 250, 380 ] 6 15.000% 50.000% ### ( 380, 580 ] 2 5.000% 55.000% # ( 580, 870 ] 4 10.000% 65.000% ## ( 870, 1300 ] 3 7.500% 72.500% ## ( 1300, 1900 ] 5 12.500% 85.000% ### ( 1900, 2900 ] 3 7.500% 92.500% ## ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 12.4 total, 3.2 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 318.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:1.806 H:M:S, 14.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 311.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.547 H:M:S, 17.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/05-18:52:31 ... thread 0: (1000000,5000000) ops and (300252.3,322516.6) ops/second in (3.330532,15.503078) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/14 2.70 GB 50.4 3.1 0.0 3.1 7.7 4.7 0.0 1.7 122.4 308.4 25.73 23.97 77 0.334 3198K 3445 0.0 0.0 L1 12/12 1.35 GB 0.0 1.7 1.7 0.0 1.7 1.7 0.2 1.0 228.3 227.1 7.74 7.47 2 3.868 1793K 8528 0.0 0.0 L2 1/0 51.72 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 250.6 250.4 1.51 1.45 2 0.754 383K 209 0.0 0.0 L3 17/0 762.83 MB 0.8 1.2 0.2 0.9 1.2 0.2 0.4 4.7 239.4 239.0 4.94 4.55 2 2.468 1200K 2364 0.0 0.0 L4 173/0 9.76 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 150.5 150.5 1.49 1.13 1 1.488 227K 0 0.0 0.0 L5 1044/0 86.19 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 1264/26 100.80 GB 0.0 6.5 2.4 4.2 11.2 7.0 2.3 2.4 161.8 277.1 41.39 38.56 84 0.493 6803K 14K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.5 2.4 4.2 11.2 7.0 2.2 2.4 161.8 277.1 41.39 38.56 84 0.493 6803K 14K 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.5 2.4 4.2 6.5 2.4 0.0 0.0 241.4 240.8 27.76 26.45 18 1.542 6803K 14K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 351.0 13.64 12.11 66 0.207 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.7 total, 15.5 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.20 GB write, 730.33 MB/s write, 6.54 GB read, 426.50 MB/s read, 41.4 seconds Interval compaction: 11.20 GB write, 739.94 MB/s write, 6.54 GB read, 432.11 MB/s read, 41.4 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: 19, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 19, interval: 22 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1444055 Average: 2.3377 StdDev: 14.23 Min: 0 Median: 1.5326 Max: 5005 Percentiles: P50: 1.53 P75: 1.91 P99: 5.82 P99.9: 11.64 P99.99: 17.60 ------------------------------------------------------ [ 0, 1 ] 206458 14.297% 14.297% ### ( 1, 2 ] 968083 67.039% 81.336% ############# ( 2, 3 ] 165791 11.481% 92.817% ## ( 3, 4 ] 53028 3.672% 96.489% # ( 4, 6 ] 39743 2.752% 99.242% # ( 6, 10 ] 8899 0.616% 99.858% ( 10, 15 ] 1858 0.129% 99.986% ( 15, 22 ] 136 0.009% 99.996% ( 22, 34 ] 21 0.001% 99.997% ( 34, 51 ] 7 0.000% 99.998% ( 51, 76 ] 10 0.001% 99.999% ( 76, 110 ] 100 0.007% 100.005% ( 110, 170 ] 143 0.010% 100.015% ( 170, 250 ] 78 0.005% 100.021% ( 250, 380 ] 54 0.004% 100.025% ( 380, 580 ] 77 0.005% 100.030% ( 580, 870 ] 37 0.003% 100.032% ( 870, 1300 ] 20 0.001% 100.034% ( 1300, 1900 ] 14 0.001% 100.035% ( 1900, 2900 ] 7 0.000% 100.035% ( 2900, 4400 ] 9 0.001% 100.036% ( 4400, 6600 ] 1 0.000% 100.036% ** Level 1 read latency histogram (micros): Count: 57393 Average: 3.1271 StdDev: 25.71 Min: 1 Median: 1.5109 Max: 1955 Percentiles: P50: 1.51 P75: 1.89 P99: 8.59 P99.9: 262.29 P99.99: 1264.68 ------------------------------------------------------ [ 0, 1 ] 9130 15.908% 15.908% ### ( 1, 2 ] 38301 66.735% 82.642% ############# ( 2, 3 ] 5976 10.412% 93.055% ## ( 3, 4 ] 1648 2.871% 95.926% # ( 4, 6 ] 1248 2.174% 98.101% ( 6, 10 ] 796 1.387% 99.488% ( 10, 15 ] 112 0.195% 99.683% ( 15, 22 ] 8 0.014% 99.697% ( 22, 34 ] 3 0.005% 99.702% ( 76, 110 ] 33 0.057% 99.760% ( 110, 170 ] 49 0.085% 99.845% ( 170, 250 ] 30 0.052% 99.897% ( 250, 380 ] 17 0.030% 99.927% ( 380, 580 ] 25 0.044% 99.970% ( 580, 870 ] 3 0.005% 99.976% ( 870, 1300 ] 9 0.016% 99.991% ( 1300, 1900 ] 4 0.007% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 124183 Average: 2.4196 StdDev: 17.15 Min: 0 Median: 1.4598 Max: 3560 Percentiles: P50: 1.46 P75: 1.85 P99: 6.34 P99.9: 100.73 P99.99: 604.10 ------------------------------------------------------ [ 0, 1 ] 25687 20.685% 20.685% #### ( 1, 2 ] 79175 63.757% 84.442% ############# ( 2, 3 ] 10855 8.741% 93.183% ## ( 3, 4 ] 4117 3.315% 96.498% # ( 4, 6 ] 3020 2.432% 98.930% ( 6, 10 ] 1011 0.814% 99.744% ( 10, 15 ] 155 0.125% 99.869% ( 15, 22 ] 12 0.010% 99.878% ( 22, 34 ] 4 0.003% 99.882% ( 34, 51 ] 1 0.001% 99.882% ( 76, 110 ] 30 0.024% 99.907% ( 110, 170 ] 59 0.048% 99.954% ( 170, 250 ] 21 0.017% 99.971% ( 250, 380 ] 10 0.008% 99.979% ( 380, 580 ] 13 0.010% 99.990% ( 580, 870 ] 7 0.006% 99.995% ( 870, 1300 ] 3 0.002% 99.998% ( 1900, 2900 ] 2 0.002% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 264867 Average: 3.5878 StdDev: 51.74 Min: 0 Median: 1.5968 Max: 7458 Percentiles: P50: 1.60 P75: 1.99 P99: 8.93 P99.9: 215.45 P99.99: 858.35 ------------------------------------------------------ [ 0, 1 ] 31033 11.716% 11.716% ## ( 1, 2 ] 169920 64.153% 75.869% ############# ( 2, 3 ] 35844 13.533% 89.402% ### ( 3, 4 ] 12065 4.555% 93.957% # ( 4, 6 ] 10248 3.869% 97.826% # ( 6, 10 ] 4247 1.603% 99.430% ( 10, 15 ] 676 0.255% 99.685% ( 15, 22 ] 68 0.026% 99.711% ( 22, 34 ] 11 0.004% 99.715% ( 34, 51 ] 3 0.001% 99.716% ( 51, 76 ] 1 0.000% 99.716% ( 76, 110 ] 131 0.049% 99.766% ( 110, 170 ] 279 0.105% 99.871% ( 170, 250 ] 134 0.051% 99.922% ( 250, 380 ] 73 0.028% 99.949% ( 380, 580 ] 72 0.027% 99.977% ( 580, 870 ] 37 0.014% 99.991% ( 870, 1300 ] 6 0.002% 99.993% ( 1300, 1900 ] 16 0.006% 99.999% ( 1900, 2900 ] 14 0.005% 100.004% ( 2900, 4400 ] 11 0.004% 100.008% ( 4400, 6600 ] 4 0.002% 100.010% ( 6600, 9900 ] 5 0.002% 100.012% ** Level 4 read latency histogram (micros): Count: 310 Average: 275.4097 StdDev: 1141.01 Min: 0 Median: 1.9703 Max: 9566 Percentiles: P50: 1.97 P75: 7.25 P99: 7342.50 P99.9: 9566.00 P99.99: 9566.00 ------------------------------------------------------ [ 0, 1 ] 57 18.387% 18.387% #### ( 1, 2 ] 101 32.581% 50.968% ####### ( 2, 3 ] 45 14.516% 65.484% ### ( 3, 4 ] 14 4.516% 70.000% # ( 4, 6 ] 13 4.194% 74.194% # ( 6, 10 ] 8 2.581% 76.774% # ( 10, 15 ] 21 6.774% 83.548% # ( 15, 22 ] 20 6.452% 90.000% # ( 76, 110 ] 2 0.645% 90.645% ( 110, 170 ] 2 0.645% 91.290% ( 170, 250 ] 2 0.645% 91.935% ( 250, 380 ] 2 0.645% 92.581% ( 580, 870 ] 1 0.323% 92.903% ( 1300, 1900 ] 4 1.290% 94.194% ( 1900, 2900 ] 7 2.258% 96.452% ( 2900, 4400 ] 6 1.935% 98.387% ( 4400, 6600 ] 1 0.323% 98.710% ( 6600, 9900 ] 4 1.290% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 915.1250 StdDev: 1012.71 Min: 113 Median: 380.0000 Max: 3662 Percentiles: P50: 380.00 P75: 1420.00 P99: 3662.00 P99.9: 3662.00 P99.99: 3662.00 ------------------------------------------------------ ( 110, 170 ] 9 22.500% 22.500% ##### ( 170, 250 ] 5 12.500% 35.000% ### ( 250, 380 ] 6 15.000% 50.000% ### ( 380, 580 ] 2 5.000% 55.000% # ( 580, 870 ] 4 10.000% 65.000% ## ( 870, 1300 ] 3 7.500% 72.500% ## ( 1300, 1900 ] 5 12.500% 85.000% ### ( 1900, 2900 ] 3 7.500% 92.500% ## ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 15.7 total, 3.3 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 313.26 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.497 H:M:S, 15.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 295.61 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.691 H:M:S, 20.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/05-18:52:36 ... thread 0: (1000000,6000000) ops and (227707.2,301588.1) ops/second in (4.391604,19.894682) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/10 3.75 GB 182.5 4.4 0.0 4.4 10.1 5.7 0.0 1.8 133.2 305.1 34.05 31.86 98 0.347 4605K 4884 0.0 0.0 L1 12/12 1.35 GB 0.0 1.7 1.7 0.0 1.7 1.7 0.2 1.0 228.3 227.1 7.74 7.47 2 3.868 1793K 8528 0.0 0.0 L2 1/0 51.72 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 250.6 250.4 1.51 1.45 2 0.754 383K 209 0.0 0.0 L3 17/0 762.83 MB 0.8 1.2 0.2 0.9 1.2 0.2 0.4 4.7 239.4 239.0 4.94 4.55 2 2.468 1200K 2364 0.0 0.0 L4 173/0 9.76 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 150.5 150.5 1.49 1.13 1 1.488 227K 0 0.0 0.0 L5 1044/0 86.19 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 1265/22 101.84 GB 0.0 7.9 2.4 5.5 13.6 8.1 2.3 2.4 162.6 280.1 49.72 46.46 105 0.474 8210K 15K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.9 2.4 5.5 13.6 8.1 2.2 2.4 162.6 280.1 49.72 46.46 105 0.474 8210K 15K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.9 2.4 5.5 7.9 2.4 0.0 0.0 244.9 244.4 33.01 31.61 23 1.435 8210K 15K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 350.7 16.71 14.84 82 0.204 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 20.1 total, 19.9 interval Flush(GB): cumulative 5.721, interval 5.721 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 13.60 GB write, 692.92 MB/s write, 7.90 GB read, 402.27 MB/s read, 49.7 seconds Interval compaction: 13.60 GB write, 700.03 MB/s write, 7.90 GB read, 406.39 MB/s read, 49.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 20, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 20, interval: 31 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1889527 Average: 2.3441 StdDev: 13.61 Min: 0 Median: 1.5306 Max: 5005 Percentiles: P50: 1.53 P75: 1.90 P99: 5.83 P99.9: 11.91 P99.99: 80.15 ------------------------------------------------------ [ 0, 1 ] 268985 14.236% 14.236% ### ( 1, 2 ] 1273688 67.408% 81.643% ############# ( 2, 3 ] 214765 11.366% 93.009% ## ( 3, 4 ] 67033 3.548% 96.557% # ( 4, 6 ] 50325 2.663% 99.220% # ( 6, 10 ] 11938 0.632% 99.852% ( 10, 15 ] 2360 0.125% 99.977% ( 15, 22 ] 174 0.009% 99.986% ( 22, 34 ] 26 0.001% 99.988% ( 34, 51 ] 9 0.000% 99.988% ( 51, 76 ] 16 0.001% 99.989% ( 76, 110 ] 156 0.008% 99.997% ( 110, 170 ] 250 0.013% 100.010% ( 170, 250 ] 127 0.007% 100.017% ( 250, 380 ] 93 0.005% 100.022% ( 380, 580 ] 123 0.007% 100.029% ( 580, 870 ] 53 0.003% 100.031% ( 870, 1300 ] 24 0.001% 100.033% ( 1300, 1900 ] 18 0.001% 100.034% ( 1900, 2900 ] 8 0.000% 100.034% ( 2900, 4400 ] 10 0.001% 100.035% ( 4400, 6600 ] 1 0.000% 100.035% ** Level 1 read latency histogram (micros): Count: 157098 Average: 2.7759 StdDev: 17.42 Min: 1 Median: 1.5400 Max: 1955 Percentiles: P50: 1.54 P75: 1.91 P99: 8.56 P99.9: 152.40 P99.99: 818.54 ------------------------------------------------------ [ 0, 1 ] 20865 13.282% 13.282% ### ( 1, 2 ] 106825 67.999% 81.280% ############## ( 2, 3 ] 17946 11.423% 92.704% ## ( 3, 4 ] 4513 2.873% 95.577% # ( 4, 6 ] 3798 2.418% 97.994% ( 6, 10 ] 2472 1.574% 99.568% ( 10, 15 ] 290 0.185% 99.752% ( 15, 22 ] 21 0.013% 99.766% ( 22, 34 ] 3 0.002% 99.768% ( 51, 76 ] 1 0.001% 99.768% ( 76, 110 ] 132 0.084% 99.852% ( 110, 170 ] 106 0.067% 99.920% ( 170, 250 ] 43 0.027% 99.947% ( 250, 380 ] 26 0.017% 99.964% ( 380, 580 ] 38 0.024% 99.988% ( 580, 870 ] 4 0.003% 99.990% ( 870, 1300 ] 9 0.006% 99.996% ( 1300, 1900 ] 5 0.003% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 124183 Average: 2.4196 StdDev: 17.15 Min: 0 Median: 1.4598 Max: 3560 Percentiles: P50: 1.46 P75: 1.85 P99: 6.34 P99.9: 100.73 P99.99: 604.10 ------------------------------------------------------ [ 0, 1 ] 25687 20.685% 20.685% #### ( 1, 2 ] 79175 63.757% 84.442% ############# ( 2, 3 ] 10855 8.741% 93.183% ## ( 3, 4 ] 4117 3.315% 96.498% # ( 4, 6 ] 3020 2.432% 98.930% ( 6, 10 ] 1011 0.814% 99.744% ( 10, 15 ] 155 0.125% 99.869% ( 15, 22 ] 12 0.010% 99.878% ( 22, 34 ] 4 0.003% 99.882% ( 34, 51 ] 1 0.001% 99.882% ( 76, 110 ] 30 0.024% 99.907% ( 110, 170 ] 59 0.048% 99.954% ( 170, 250 ] 21 0.017% 99.971% ( 250, 380 ] 10 0.008% 99.979% ( 380, 580 ] 13 0.010% 99.990% ( 580, 870 ] 7 0.006% 99.995% ( 870, 1300 ] 3 0.002% 99.998% ( 1900, 2900 ] 2 0.002% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 264867 Average: 3.5878 StdDev: 51.74 Min: 0 Median: 1.5968 Max: 7458 Percentiles: P50: 1.60 P75: 1.99 P99: 8.93 P99.9: 215.45 P99.99: 858.35 ------------------------------------------------------ [ 0, 1 ] 31033 11.716% 11.716% ## ( 1, 2 ] 169920 64.153% 75.869% ############# ( 2, 3 ] 35844 13.533% 89.402% ### ( 3, 4 ] 12065 4.555% 93.957% # ( 4, 6 ] 10248 3.869% 97.826% # ( 6, 10 ] 4247 1.603% 99.430% ( 10, 15 ] 676 0.255% 99.685% ( 15, 22 ] 68 0.026% 99.711% ( 22, 34 ] 11 0.004% 99.715% ( 34, 51 ] 3 0.001% 99.716% ( 51, 76 ] 1 0.000% 99.716% ( 76, 110 ] 131 0.049% 99.766% ( 110, 170 ] 279 0.105% 99.871% ( 170, 250 ] 134 0.051% 99.922% ( 250, 380 ] 73 0.028% 99.949% ( 380, 580 ] 72 0.027% 99.977% ( 580, 870 ] 37 0.014% 99.991% ( 870, 1300 ] 6 0.002% 99.993% ( 1300, 1900 ] 16 0.006% 99.999% ( 1900, 2900 ] 14 0.005% 100.004% ( 2900, 4400 ] 11 0.004% 100.008% ( 4400, 6600 ] 4 0.002% 100.010% ( 6600, 9900 ] 5 0.002% 100.012% ** Level 4 read latency histogram (micros): Count: 310 Average: 275.4097 StdDev: 1141.01 Min: 0 Median: 1.9703 Max: 9566 Percentiles: P50: 1.97 P75: 7.25 P99: 7342.50 P99.9: 9566.00 P99.99: 9566.00 ------------------------------------------------------ [ 0, 1 ] 57 18.387% 18.387% #### ( 1, 2 ] 101 32.581% 50.968% ####### ( 2, 3 ] 45 14.516% 65.484% ### ( 3, 4 ] 14 4.516% 70.000% # ( 4, 6 ] 13 4.194% 74.194% # ( 6, 10 ] 8 2.581% 76.774% # ( 10, 15 ] 21 6.774% 83.548% # ( 15, 22 ] 20 6.452% 90.000% # ( 76, 110 ] 2 0.645% 90.645% ( 110, 170 ] 2 0.645% 91.290% ( 170, 250 ] 2 0.645% 91.935% ( 250, 380 ] 2 0.645% 92.581% ( 580, 870 ] 1 0.323% 92.903% ( 1300, 1900 ] 4 1.290% 94.194% ( 1900, 2900 ] 7 2.258% 96.452% ( 2900, 4400 ] 6 1.935% 98.387% ( 4400, 6600 ] 1 0.323% 98.710% ( 6600, 9900 ] 4 1.290% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 915.1250 StdDev: 1012.71 Min: 113 Median: 380.0000 Max: 3662 Percentiles: P50: 380.00 P75: 1420.00 P99: 3662.00 P99.9: 3662.00 P99.99: 3662.00 ------------------------------------------------------ ( 110, 170 ] 9 22.500% 22.500% ##### ( 170, 250 ] 5 12.500% 35.000% ### ( 250, 380 ] 6 15.000% 50.000% ### ( 380, 580 ] 2 5.000% 55.000% # ( 580, 870 ] 4 10.000% 65.000% ## ( 870, 1300 ] 3 7.500% 72.500% ## ( 1300, 1900 ] 5 12.500% 85.000% ### ( 1900, 2900 ] 3 7.500% 92.500% ## ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 20.1 total, 4.4 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 293.78 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:4.262 H:M:S, 21.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 224.11 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.765 H:M:S, 40.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 2024/12/05-18:52:48 ... thread 0: (1000000,7000000) ops and (83221.0,219361.0) ops/second in (12.016192,31.910874) 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 13/11 2.70 GB 37.8 5.7 0.0 5.7 12.4 6.6 0.0 1.9 139.1 300.5 42.11 39.25 115 0.366 5948K 7787 0.0 0.0 L1 15/15 1.76 GB 0.0 5.0 3.7 1.4 5.0 3.6 0.2 1.4 227.0 224.5 22.73 21.93 3 7.577 5239K 55K 0.0 0.0 L2 5/3 643.90 MB 2.6 0.4 0.2 0.2 0.4 0.2 1.9 2.0 250.6 250.4 1.51 1.45 2 0.754 383K 209 0.0 0.0 L3 22/1 1007.62 MB 0.9 2.3 1.2 1.1 2.3 1.2 0.4 1.9 224.3 223.8 10.49 9.62 5 2.099 2391K 5978 0.0 0.0 L4 173/0 9.47 GB 1.0 0.5 0.5 0.0 0.5 0.5 0.9 1.0 141.1 140.9 3.78 2.57 6 0.629 541K 744 0.0 0.0 L5 1056/0 87.17 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1284/30 102.71 GB 0.0 13.9 5.6 8.4 20.5 12.1 5.2 3.1 177.2 260.7 80.62 74.82 131 0.615 14M 70K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.9 5.6 8.4 20.5 12.1 5.1 3.1 177.2 260.7 80.62 74.82 131 0.615 14M 70K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 13.9 5.6 8.4 13.9 5.5 0.0 0.0 234.4 233.2 60.93 57.55 35 1.741 14M 70K 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 345.7 19.68 17.27 96 0.205 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): 32.1 total, 31.9 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: 20.52 GB write, 654.36 MB/s write, 13.95 GB read, 444.72 MB/s read, 80.6 seconds Interval compaction: 20.52 GB write, 658.55 MB/s write, 13.95 GB read, 447.57 MB/s read, 80.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 23, pending-compaction-bytes-delays: 9, pending-compaction-bytes-stops: 0, total-delays: 23, total-stops: 23, interval: 46 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2733974 Average: 2.4024 StdDev: 15.29 Min: 0 Median: 1.5274 Max: 5770 Percentiles: P50: 1.53 P75: 1.90 P99: 5.96 P99.9: 12.97 P99.99: 148.38 ------------------------------------------------------ [ 0, 1 ] 397925 14.555% 14.555% ### ( 1, 2 ] 1837310 67.203% 81.758% ############# ( 2, 3 ] 301284 11.020% 92.778% ## ( 3, 4 ] 96355 3.524% 96.302% # ( 4, 6 ] 75195 2.750% 99.052% # ( 6, 10 ] 21057 0.770% 99.823% ( 10, 15 ] 3563 0.130% 99.953% ( 15, 22 ] 323 0.012% 99.965% ( 22, 34 ] 34 0.001% 99.966% ( 34, 51 ] 14 0.001% 99.967% ( 51, 76 ] 17 0.001% 99.967% ( 76, 110 ] 307 0.011% 99.978% ( 110, 170 ] 495 0.018% 99.997% ( 170, 250 ] 259 0.009% 100.006% ( 250, 380 ] 208 0.008% 100.014% ( 380, 580 ] 217 0.008% 100.022% ( 580, 870 ] 120 0.004% 100.026% ( 870, 1300 ] 56 0.002% 100.028% ( 1300, 1900 ] 24 0.001% 100.029% ( 1900, 2900 ] 12 0.000% 100.029% ( 2900, 4400 ] 17 0.001% 100.030% ( 4400, 6600 ] 2 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 671023 Average: 2.9425 StdDev: 27.96 Min: 1 Median: 1.5703 Max: 7487 Percentiles: P50: 1.57 P75: 1.95 P99: 8.51 P99.9: 136.55 P99.99: 418.08 ------------------------------------------------------ [ 0, 1 ] 83290 12.412% 12.412% ## ( 1, 2 ] 442288 65.912% 78.325% ############# ( 2, 3 ] 84354 12.571% 90.896% ### ( 3, 4 ] 25203 3.756% 94.652% # ( 4, 6 ] 22777 3.394% 98.046% # ( 6, 10 ] 10188 1.518% 99.564% ( 10, 15 ] 1401 0.209% 99.773% ( 15, 22 ] 173 0.026% 99.799% ( 22, 34 ] 23 0.003% 99.802% ( 34, 51 ] 2 0.000% 99.803% ( 51, 76 ] 1 0.000% 99.803% ( 76, 110 ] 452 0.067% 99.870% ( 110, 170 ] 452 0.067% 99.938% ( 170, 250 ] 190 0.028% 99.966% ( 250, 380 ] 140 0.021% 99.987% ( 380, 580 ] 115 0.017% 100.004% ( 580, 870 ] 61 0.009% 100.013% ( 870, 1300 ] 39 0.006% 100.019% ( 1300, 1900 ] 16 0.002% 100.021% ( 1900, 2900 ] 6 0.001% 100.022% ( 2900, 4400 ] 9 0.001% 100.023% ( 4400, 6600 ] 3 0.000% 100.024% ( 6600, 9900 ] 2 0.000% 100.024% ** Level 2 read latency histogram (micros): Count: 124183 Average: 2.4196 StdDev: 17.15 Min: 0 Median: 1.4598 Max: 3560 Percentiles: P50: 1.46 P75: 1.85 P99: 6.34 P99.9: 100.73 P99.99: 604.10 ------------------------------------------------------ [ 0, 1 ] 25687 20.685% 20.685% #### ( 1, 2 ] 79175 63.757% 84.442% ############# ( 2, 3 ] 10855 8.741% 93.183% ## ( 3, 4 ] 4117 3.315% 96.498% # ( 4, 6 ] 3020 2.432% 98.930% ( 6, 10 ] 1011 0.814% 99.744% ( 10, 15 ] 155 0.125% 99.869% ( 15, 22 ] 12 0.010% 99.878% ( 22, 34 ] 4 0.003% 99.882% ( 34, 51 ] 1 0.001% 99.882% ( 76, 110 ] 30 0.024% 99.907% ( 110, 170 ] 59 0.048% 99.954% ( 170, 250 ] 21 0.017% 99.971% ( 250, 380 ] 10 0.008% 99.979% ( 380, 580 ] 13 0.010% 99.990% ( 580, 870 ] 7 0.006% 99.995% ( 870, 1300 ] 3 0.002% 99.998% ( 1900, 2900 ] 2 0.002% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 351354 Average: 4.1370 StdDev: 55.65 Min: 0 Median: 1.6879 Max: 7458 Percentiles: P50: 1.69 P75: 2.38 P99: 9.23 P99.9: 232.90 P99.99: 509.96 ------------------------------------------------------ [ 0, 1 ] 32125 9.143% 9.143% ## ( 1, 2 ] 208693 59.397% 68.540% ############ ( 2, 3 ] 59419 16.911% 85.451% ### ( 3, 4 ] 21521 6.125% 91.577% # ( 4, 6 ] 21251 6.048% 97.625% # ( 6, 10 ] 5980 1.702% 99.327% ( 10, 15 ] 1131 0.322% 99.649% ( 15, 22 ] 114 0.032% 99.681% ( 22, 34 ] 20 0.006% 99.687% ( 34, 51 ] 7 0.002% 99.689% ( 51, 76 ] 2 0.001% 99.689% ( 76, 110 ] 163 0.046% 99.736% ( 110, 170 ] 384 0.109% 99.845% ( 170, 250 ] 245 0.070% 99.915% ( 250, 380 ] 156 0.044% 99.959% ( 380, 580 ] 166 0.047% 100.007% ( 580, 870 ] 80 0.023% 100.029% ( 870, 1300 ] 26 0.007% 100.037% ( 1300, 1900 ] 19 0.005% 100.042% ( 1900, 2900 ] 18 0.005% 100.047% ( 2900, 4400 ] 25 0.007% 100.054% ( 4400, 6600 ] 4 0.001% 100.055% ( 6600, 9900 ] 6 0.002% 100.057% ** Level 4 read latency histogram (micros): Count: 5262 Average: 60.0846 StdDev: 351.67 Min: 0 Median: 2.1315 Max: 9566 Percentiles: P50: 2.13 P75: 3.52 P99: 1357.12 P99.9: 4356.33 P99.99: 9465.88 ------------------------------------------------------ [ 0, 1 ] 165 3.136% 3.136% # ( 1, 2 ] 2314 43.976% 47.111% ######### ( 2, 3 ] 1156 21.969% 69.080% #### ( 3, 4 ] 602 11.441% 80.521% ## ( 4, 6 ] 446 8.476% 88.997% ## ( 6, 10 ] 106 2.014% 91.011% ( 10, 15 ] 82 1.558% 92.569% ( 15, 22 ] 27 0.513% 93.082% ( 22, 34 ] 2 0.038% 93.120% ( 76, 110 ] 2 0.038% 93.158% ( 110, 170 ] 33 0.627% 93.786% ( 170, 250 ] 39 0.741% 94.527% ( 250, 380 ] 41 0.779% 95.306% ( 380, 580 ] 74 1.406% 96.712% ( 580, 870 ] 80 1.520% 98.233% ( 870, 1300 ] 38 0.722% 98.955% ( 1300, 1900 ] 25 0.475% 99.430% ( 1900, 2900 ] 16 0.304% 99.734% ( 2900, 4400 ] 9 0.171% 99.905% ( 4400, 6600 ] 1 0.019% 99.924% ( 6600, 9900 ] 4 0.076% 100.000% ** Level 5 read latency histogram (micros): Count: 100 Average: 1074.2100 StdDev: 1197.05 Min: 104 Median: 491.1111 Max: 5178 Percentiles: P50: 491.11 P75: 1557.14 P99: 4400.00 P99.9: 5178.00 P99.99: 5178.00 ------------------------------------------------------ ( 76, 110 ] 3 3.000% 3.000% # ( 110, 170 ] 20 20.000% 23.000% #### ( 170, 250 ] 9 9.000% 32.000% ## ( 250, 380 ] 13 13.000% 45.000% ### ( 380, 580 ] 9 9.000% 54.000% ## ( 580, 870 ] 7 7.000% 61.000% # ( 870, 1300 ] 11 11.000% 72.000% ## ( 1300, 1900 ] 7 7.000% 79.000% # ( 1900, 2900 ] 9 9.000% 88.000% ## ( 2900, 4400 ] 11 11.000% 99.000% ## ( 4400, 6600 ] 1 1.000% 100.000% ** DB Stats ** Uptime(secs): 32.1 total, 12.0 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 214.51 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:13.349 H:M:S, 41.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 81.91 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:9.087 H:M:S, 75.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/05-18:52:52 ... thread 0: (1000000,8000000) ops and (204183.1,217341.5) ops/second in (4.897565,36.808439) 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/11 3.69 GB 138.5 6.5 0.0 6.5 14.1 7.6 0.0 1.9 137.7 298.6 48.50 44.95 132 0.367 6779K 8644 0.0 0.0 L1 15/15 1.76 GB 0.0 5.0 3.7 1.4 5.0 3.6 0.2 1.4 227.0 224.5 22.73 21.93 3 7.577 5239K 55K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 1.9 2.0 250.6 250.4 1.51 1.45 2 0.754 383K 209 0.0 0.0 L3 20/0 949.17 MB 0.9 3.2 1.8 1.4 3.2 1.8 0.4 1.8 216.7 216.2 15.10 13.69 8 1.887 3323K 8388 0.0 0.0 L4 177/0 9.47 GB 1.0 1.2 1.2 0.1 1.2 1.2 0.9 1.1 136.9 136.6 9.35 6.13 18 0.519 1291K 2257 0.0 0.0 L5 1064/0 87.85 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1294/26 103.69 GB 0.0 16.4 6.9 9.5 23.9 14.4 5.9 3.1 172.5 252.1 97.18 88.15 163 0.596 17M 74K 0.0 0.0 Int 0/0 0.00 KB 0.0 16.4 6.9 9.5 23.9 14.4 5.7 3.1 172.5 252.1 97.18 88.15 163 0.596 17M 74K 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.4 6.9 9.5 16.3 6.8 0.0 0.0 225.2 224.2 74.45 68.32 53 1.405 17M 74K 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 343.6 22.74 19.83 110 0.207 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 37.0 total, 36.8 interval Flush(GB): cumulative 7.629, interval 7.629 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 23.93 GB write, 661.97 MB/s write, 16.37 GB read, 452.98 MB/s read, 97.2 seconds Interval compaction: 23.93 GB write, 665.65 MB/s write, 16.37 GB read, 455.49 MB/s read, 97.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 17, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 17, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 26, pending-compaction-bytes-delays: 18, pending-compaction-bytes-stops: 0, total-delays: 35, total-stops: 26, interval: 61 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3068943 Average: 2.4276 StdDev: 15.25 Min: 0 Median: 1.5377 Max: 5770 Percentiles: P50: 1.54 P75: 1.91 P99: 6.00 P99.9: 13.07 P99.99: 151.89 ------------------------------------------------------ [ 0, 1 ] 429575 13.997% 13.997% ### ( 1, 2 ] 2054753 66.953% 80.951% ############# ( 2, 3 ] 349862 11.400% 92.351% ## ( 3, 4 ] 112964 3.681% 96.032% # ( 4, 6 ] 91262 2.974% 99.005% # ( 6, 10 ] 24950 0.813% 99.818% ( 10, 15 ] 4084 0.133% 99.951% ( 15, 22 ] 361 0.012% 99.963% ( 22, 34 ] 41 0.001% 99.964% ( 34, 51 ] 18 0.001% 99.965% ( 51, 76 ] 20 0.001% 99.966% ( 76, 110 ] 345 0.011% 99.977% ( 110, 170 ] 576 0.019% 99.996% ( 170, 250 ] 317 0.010% 100.006% ( 250, 380 ] 241 0.008% 100.014% ( 380, 580 ] 244 0.008% 100.022% ( 580, 870 ] 131 0.004% 100.026% ( 870, 1300 ] 64 0.002% 100.028% ( 1300, 1900 ] 27 0.001% 100.029% ( 1900, 2900 ] 14 0.000% 100.030% ( 2900, 4400 ] 19 0.001% 100.030% ( 4400, 6600 ] 2 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 930554 Average: 3.0775 StdDev: 31.12 Min: 1 Median: 1.5966 Max: 7487 Percentiles: P50: 1.60 P75: 1.98 P99: 8.68 P99.9: 143.72 P99.99: 439.28 ------------------------------------------------------ [ 0, 1 ] 101337 10.890% 10.890% ## ( 1, 2 ] 610003 65.553% 76.443% ############# ( 2, 3 ] 126076 13.548% 89.991% ### ( 3, 4 ] 37873 4.070% 94.061% # ( 4, 6 ] 35698 3.836% 97.897% # ( 6, 10 ] 15323 1.647% 99.544% ( 10, 15 ] 2182 0.234% 99.778% ( 15, 22 ] 236 0.025% 99.804% ( 22, 34 ] 36 0.004% 99.808% ( 34, 51 ] 4 0.000% 99.808% ( 51, 76 ] 3 0.000% 99.808% ( 76, 110 ] 496 0.053% 99.862% ( 110, 170 ] 636 0.068% 99.930% ( 170, 250 ] 296 0.032% 99.962% ( 250, 380 ] 209 0.022% 99.984% ( 380, 580 ] 182 0.020% 100.004% ( 580, 870 ] 100 0.011% 100.015% ( 870, 1300 ] 51 0.005% 100.020% ( 1300, 1900 ] 20 0.002% 100.022% ( 1900, 2900 ] 15 0.002% 100.024% ( 2900, 4400 ] 24 0.003% 100.026% ( 4400, 6600 ] 5 0.001% 100.027% ( 6600, 9900 ] 2 0.000% 100.027% ** Level 2 read latency histogram (micros): Count: 124183 Average: 2.4196 StdDev: 17.15 Min: 0 Median: 1.4598 Max: 3560 Percentiles: P50: 1.46 P75: 1.85 P99: 6.34 P99.9: 100.73 P99.99: 604.10 ------------------------------------------------------ [ 0, 1 ] 25687 20.685% 20.685% #### ( 1, 2 ] 79175 63.757% 84.442% ############# ( 2, 3 ] 10855 8.741% 93.183% ## ( 3, 4 ] 4117 3.315% 96.498% # ( 4, 6 ] 3020 2.432% 98.930% ( 6, 10 ] 1011 0.814% 99.744% ( 10, 15 ] 155 0.125% 99.869% ( 15, 22 ] 12 0.010% 99.878% ( 22, 34 ] 4 0.003% 99.882% ( 34, 51 ] 1 0.001% 99.882% ( 76, 110 ] 30 0.024% 99.907% ( 110, 170 ] 59 0.048% 99.954% ( 170, 250 ] 21 0.017% 99.971% ( 250, 380 ] 10 0.008% 99.979% ( 380, 580 ] 13 0.010% 99.990% ( 580, 870 ] 7 0.006% 99.995% ( 870, 1300 ] 3 0.002% 99.998% ( 1900, 2900 ] 2 0.002% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 590283 Average: 4.1584 StdDev: 56.59 Min: 0 Median: 1.8027 Max: 7858 Percentiles: P50: 1.80 P75: 2.71 P99: 9.05 P99.9: 105.58 P99.99: 185.73 ------------------------------------------------------ [ 0, 1 ] 35851 6.074% 6.074% # ( 1, 2 ] 323026 54.724% 60.797% ########### ( 2, 3 ] 117904 19.974% 80.772% #### ( 3, 4 ] 47459 8.040% 88.812% ## ( 4, 6 ] 51364 8.702% 97.513% ## ( 6, 10 ] 11510 1.950% 99.463% ( 10, 15 ] 2130 0.361% 99.824% ( 15, 22 ] 230 0.039% 99.863% ( 22, 34 ] 29 0.005% 99.868% ( 34, 51 ] 19 0.003% 99.871% ( 51, 76 ] 8 0.001% 99.872% ( 76, 110 ] 187 0.032% 99.904% ( 110, 170 ] 447 0.076% 99.980% ( 170, 250 ] 305 0.052% 100.032% ( 250, 380 ] 197 0.033% 100.065% ( 380, 580 ] 212 0.036% 100.101% ( 580, 870 ] 118 0.020% 100.121% ( 870, 1300 ] 48 0.008% 100.129% ( 1300, 1900 ] 22 0.004% 100.133% ( 1900, 2900 ] 21 0.004% 100.136% ( 2900, 4400 ] 58 0.010% 100.146% ( 4400, 6600 ] 5 0.001% 100.147% ( 6600, 9900 ] 10 0.002% 100.149% ** Level 4 read latency histogram (micros): Count: 17335 Average: 41.3254 StdDev: 243.26 Min: 0 Median: 2.1243 Max: 9566 Percentiles: P50: 2.12 P75: 3.46 P99: 858.35 P99.9: 3311.62 P99.99: 6819.86 ------------------------------------------------------ [ 0, 1 ] 498 2.873% 2.873% # ( 1, 2 ] 7688 44.350% 47.222% ######### ( 2, 3 ] 3875 22.354% 69.576% #### ( 3, 4 ] 2044 11.791% 81.367% ## ( 4, 6 ] 1497 8.636% 90.003% ## ( 6, 10 ] 336 1.938% 91.941% ( 10, 15 ] 207 1.194% 93.135% ( 15, 22 ] 31 0.179% 93.314% ( 22, 34 ] 2 0.012% 93.326% ( 34, 51 ] 1 0.006% 93.331% ( 76, 110 ] 27 0.156% 93.487% ( 110, 170 ] 181 1.044% 94.531% ( 170, 250 ] 186 1.073% 95.604% ( 250, 380 ] 192 1.108% 96.712% ( 380, 580 ] 221 1.275% 97.987% ( 580, 870 ] 183 1.056% 99.042% ( 870, 1300 ] 76 0.438% 99.481% ( 1300, 1900 ] 47 0.271% 99.752% ( 1900, 2900 ] 21 0.121% 99.873% ( 2900, 4400 ] 17 0.098% 99.971% ( 4400, 6600 ] 3 0.017% 99.988% ( 6600, 9900 ] 4 0.023% 100.012% ** Level 5 read latency histogram (micros): Count: 140 Average: 1125.5000 StdDev: 1310.20 Min: 90 Median: 460.0000 Max: 5872 Percentiles: P50: 460.00 P75: 1600.00 P99: 5573.33 P99.9: 5872.00 P99.99: 5872.00 ------------------------------------------------------ ( 76, 110 ] 6 4.286% 4.286% # ( 110, 170 ] 24 17.143% 21.429% ### ( 170, 250 ] 15 10.714% 32.143% ## ( 250, 380 ] 21 15.000% 47.143% ### ( 380, 580 ] 10 7.143% 54.286% # ( 580, 870 ] 10 7.143% 61.429% # ( 870, 1300 ] 14 10.000% 71.429% ## ( 1300, 1900 ] 10 7.143% 78.571% # ( 1900, 2900 ] 11 7.857% 86.429% ## ( 2900, 4400 ] 16 11.429% 97.857% ## ( 4400, 6600 ] 3 2.143% 100.000% ** DB Stats ** Uptime(secs): 37.0 total, 4.9 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 212.71 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.509 H:M:S, 41.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 200.94 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.160 H:M:S, 44.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/05-18:53:06 ... thread 0: (1000000,9000000) ops and (71704.0,177323.6) ops/second in (13.946215,50.754654) 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 2.52 GB 0.0 7.3 0.0 7.3 15.8 8.5 0.0 1.8 137.1 298.5 54.21 50.22 149 0.364 7547K 9393 0.0 0.0 L1 16/16 1.83 GB 0.0 8.9 5.8 3.1 8.8 5.7 0.2 1.5 222.2 219.4 40.95 38.64 4 10.237 8456K 55K 0.0 0.0 L2 6/5 772.69 MB 1.3 0.4 0.2 0.2 0.4 0.2 3.9 2.0 250.6 250.4 1.51 1.45 2 0.754 383K 209 0.0 0.0 L3 21/1 1.05 GB 0.9 5.0 2.9 2.1 5.0 2.8 0.6 1.7 187.8 187.0 27.21 22.26 18 1.511 5189K 21K 0.0 0.0 L4 175/0 9.50 GB 1.0 2.4 2.3 0.1 2.4 2.3 0.9 1.1 142.7 142.4 17.11 11.63 31 0.552 2435K 3397 0.0 0.0 L5 1076/0 88.89 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1310/38 104.54 GB 0.0 23.9 11.1 12.8 32.3 19.5 9.0 3.8 173.5 234.6 140.98 124.20 204 0.691 24M 89K 0.0 0.0 Int 0/0 0.00 KB 0.0 23.9 11.1 12.8 32.3 19.5 8.9 3.8 173.5 234.6 140.98 124.20 204 0.691 24M 89K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 23.9 11.1 12.8 23.7 10.9 0.0 0.0 211.9 210.6 115.41 101.94 80 1.443 24M 89K 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 342.5 25.57 22.26 124 0.206 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 51.0 total, 50.8 interval Flush(GB): cumulative 8.551, interval 8.551 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 32.29 GB write, 648.87 MB/s write, 23.89 GB read, 479.99 MB/s read, 141.0 seconds Interval compaction: 32.29 GB write, 651.48 MB/s write, 23.89 GB read, 481.92 MB/s read, 141.0 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: 28, pending-compaction-bytes-delays: 46, pending-compaction-bytes-stops: 0, total-delays: 69, total-stops: 28, interval: 97 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3649472 Average: 2.6958 StdDev: 22.58 Min: 0 Median: 1.5400 Max: 7015 Percentiles: P50: 1.54 P75: 1.92 P99: 6.86 P99.9: 89.65 P99.99: 357.77 ------------------------------------------------------ [ 0, 1 ] 519721 14.241% 14.241% ### ( 1, 2 ] 2416916 66.226% 80.467% ############# ( 2, 3 ] 415078 11.374% 91.841% ## ( 3, 4 ] 137232 3.760% 95.601% # ( 4, 6 ] 116879 3.203% 98.804% # ( 6, 10 ] 33095 0.907% 99.711% ( 10, 15 ] 5680 0.156% 99.867% ( 15, 22 ] 566 0.016% 99.882% ( 22, 34 ] 54 0.001% 99.884% ( 34, 51 ] 22 0.001% 99.884% ( 51, 76 ] 23 0.001% 99.885% ( 76, 110 ] 1389 0.038% 99.923% ( 110, 170 ] 1449 0.040% 99.963% ( 170, 250 ] 602 0.016% 99.979% ( 250, 380 ] 485 0.013% 99.992% ( 380, 580 ] 569 0.016% 100.008% ( 580, 870 ] 362 0.010% 100.018% ( 870, 1300 ] 177 0.005% 100.023% ( 1300, 1900 ] 70 0.002% 100.025% ( 1900, 2900 ] 49 0.001% 100.026% ( 2900, 4400 ] 48 0.001% 100.027% ( 4400, 6600 ] 5 0.000% 100.027% ( 6600, 9900 ] 1 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 1728933 Average: 3.8138 StdDev: 46.76 Min: 0 Median: 1.6326 Max: 7775 Percentiles: P50: 1.63 P75: 2.20 P99: 9.27 P99.9: 158.68 P99.99: 466.12 ------------------------------------------------------ [ 0, 1 ] 205157 11.866% 11.866% ## ( 1, 2 ] 1042301 60.286% 72.152% ############ ( 2, 3 ] 249626 14.438% 86.590% ### ( 3, 4 ] 90681 5.245% 91.835% # ( 4, 6 ] 96571 5.586% 97.421% # ( 6, 10 ] 33456 1.935% 99.356% ( 10, 15 ] 6283 0.363% 99.719% ( 15, 22 ] 740 0.043% 99.762% ( 22, 34 ] 70 0.004% 99.766% ( 34, 51 ] 14 0.001% 99.767% ( 51, 76 ] 40 0.002% 99.769% ( 76, 110 ] 1114 0.064% 99.833% ( 110, 170 ] 1420 0.082% 99.916% ( 170, 250 ] 515 0.030% 99.945% ( 250, 380 ] 541 0.031% 99.977% ( 380, 580 ] 539 0.031% 100.008% ( 580, 870 ] 402 0.023% 100.031% ( 870, 1300 ] 226 0.013% 100.044% ( 1300, 1900 ] 114 0.007% 100.051% ( 1900, 2900 ] 108 0.006% 100.057% ( 2900, 4400 ] 113 0.007% 100.064% ( 4400, 6600 ] 20 0.001% 100.065% ( 6600, 9900 ] 4 0.000% 100.065% ** Level 2 read latency histogram (micros): Count: 124183 Average: 2.4196 StdDev: 17.15 Min: 0 Median: 1.4598 Max: 3560 Percentiles: P50: 1.46 P75: 1.85 P99: 6.34 P99.9: 100.73 P99.99: 604.10 ------------------------------------------------------ [ 0, 1 ] 25687 20.685% 20.685% #### ( 1, 2 ] 79175 63.757% 84.442% ############# ( 2, 3 ] 10855 8.741% 93.183% ## ( 3, 4 ] 4117 3.315% 96.498% # ( 4, 6 ] 3020 2.432% 98.930% ( 6, 10 ] 1011 0.814% 99.744% ( 10, 15 ] 155 0.125% 99.869% ( 15, 22 ] 12 0.010% 99.878% ( 22, 34 ] 4 0.003% 99.882% ( 34, 51 ] 1 0.001% 99.882% ( 76, 110 ] 30 0.024% 99.907% ( 110, 170 ] 59 0.048% 99.954% ( 170, 250 ] 21 0.017% 99.971% ( 250, 380 ] 10 0.008% 99.979% ( 380, 580 ] 13 0.010% 99.990% ( 580, 870 ] 7 0.006% 99.995% ( 870, 1300 ] 3 0.002% 99.998% ( 1900, 2900 ] 2 0.002% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1060285 Average: 4.6187 StdDev: 60.11 Min: 0 Median: 1.8977 Max: 7858 Percentiles: P50: 1.90 P75: 2.90 P99: 9.27 P99.9: 21.84 P99.99: 189.04 ------------------------------------------------------ [ 0, 1 ] 42811 4.038% 4.038% # ( 1, 2 ] 542872 51.201% 55.238% ########## ( 2, 3 ] 232178 21.898% 77.136% #### ( 3, 4 ] 99265 9.362% 86.498% ## ( 4, 6 ] 113491 10.704% 97.202% ## ( 6, 10 ] 23322 2.200% 99.401% ( 10, 15 ] 4767 0.450% 99.851% ( 15, 22 ] 531 0.050% 99.901% ( 22, 34 ] 55 0.005% 99.906% ( 34, 51 ] 28 0.003% 99.909% ( 51, 76 ] 46 0.004% 99.913% ( 76, 110 ] 207 0.020% 99.933% ( 110, 170 ] 506 0.048% 99.981% ( 170, 250 ] 420 0.040% 100.020% ( 250, 380 ] 396 0.037% 100.058% ( 380, 580 ] 418 0.039% 100.097% ( 580, 870 ] 311 0.029% 100.126% ( 870, 1300 ] 185 0.017% 100.144% ( 1300, 1900 ] 83 0.008% 100.152% ( 1900, 2900 ] 79 0.007% 100.159% ( 2900, 4400 ] 118 0.011% 100.170% ( 4400, 6600 ] 16 0.002% 100.172% ( 6600, 9900 ] 13 0.001% 100.173% ** Level 4 read latency histogram (micros): Count: 33972 Average: 49.7787 StdDev: 279.77 Min: 0 Median: 2.1436 Max: 9566 Percentiles: P50: 2.14 P75: 3.48 P99: 1162.13 P99.9: 3918.61 P99.99: 6380.44 ------------------------------------------------------ [ 0, 1 ] 933 2.746% 2.746% # ( 1, 2 ] 14955 44.022% 46.768% ######### ( 2, 3 ] 7645 22.504% 69.272% ##### ( 3, 4 ] 4050 11.922% 81.193% ## ( 4, 6 ] 3006 8.848% 90.042% ## ( 6, 10 ] 740 2.178% 92.220% ( 10, 15 ] 362 1.066% 93.286% ( 15, 22 ] 49 0.144% 93.430% ( 22, 34 ] 9 0.026% 93.456% ( 34, 51 ] 2 0.006% 93.462% ( 51, 76 ] 1 0.003% 93.465% ( 76, 110 ] 40 0.118% 93.583% ( 110, 170 ] 251 0.739% 94.322% ( 170, 250 ] 298 0.877% 95.199% ( 250, 380 ] 312 0.918% 96.117% ( 380, 580 ] 421 1.239% 97.357% ( 580, 870 ] 383 1.127% 98.484% ( 870, 1300 ] 258 0.759% 99.243% ( 1300, 1900 ] 131 0.386% 99.629% ( 1900, 2900 ] 54 0.159% 99.788% ( 2900, 4400 ] 56 0.165% 99.953% ( 4400, 6600 ] 14 0.041% 99.994% ( 6600, 9900 ] 7 0.021% 100.015% ** Level 5 read latency histogram (micros): Count: 200 Average: 1169.8900 StdDev: 1347.54 Min: 90 Median: 473.3333 Max: 5872 Percentiles: P50: 473.33 P75: 1715.38 P99: 5720.00 P99.9: 5872.00 P99.99: 5872.00 ------------------------------------------------------ ( 76, 110 ] 9 4.500% 4.500% # ( 110, 170 ] 33 16.500% 21.000% ### ( 170, 250 ] 22 11.000% 32.000% ## ( 250, 380 ] 29 14.500% 46.500% ### ( 380, 580 ] 15 7.500% 54.000% ## ( 580, 870 ] 13 6.500% 60.500% # ( 870, 1300 ] 20 10.000% 70.500% ## ( 1300, 1900 ] 13 6.500% 77.000% # ( 1900, 2900 ] 15 7.500% 84.500% ## ( 2900, 4400 ] 26 13.000% 97.500% ### ( 4400, 6600 ] 5 2.500% 100.000% # ** DB Stats ** Uptime(secs): 51.0 total, 13.9 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 173.82 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:26.575 H:M:S, 52.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 70.57 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:11.066 H:M:S, 79.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/05-18:53:11 ... thread 0: (1000000,10000000) ops and (214543.7,180454.2) ops/second in (4.661054,55.415708) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/12 3.50 GB 132.2 8.4 0.0 8.4 17.9 9.5 0.0 1.9 137.7 294.5 62.20 57.21 168 0.370 8698K 10K 0.0 0.0 L1 16/16 1.83 GB 0.0 8.9 5.8 3.1 8.8 5.7 0.2 1.5 222.2 219.4 40.95 38.64 4 10.237 8456K 55K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 3.9 2.0 250.6 250.4 1.51 1.45 2 0.754 383K 209 0.0 0.0 L3 20/0 973.69 MB 1.0 6.0 3.6 2.4 6.0 3.6 0.6 1.7 185.7 185.0 33.10 26.99 20 1.655 6243K 24K 0.0 0.0 L4 178/0 9.67 GB 1.0 3.3 3.1 0.2 3.3 3.1 0.9 1.1 141.3 140.9 23.67 15.89 41 0.577 3311K 3397 0.0 0.0 L5 1084/0 89.57 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1317/28 105.52 GB 0.0 26.9 12.7 14.2 36.3 22.1 9.7 3.8 170.6 230.1 161.42 140.18 235 0.687 27M 94K 0.0 0.0 Int 0/0 0.00 KB 0.0 26.9 12.7 14.2 36.3 22.1 9.6 3.8 170.6 230.1 161.42 140.18 235 0.687 27M 94K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 26.9 12.7 14.2 26.7 12.5 0.0 0.0 207.9 206.7 132.44 115.28 96 1.380 27M 94K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.5 9.5 0.0 0.0 0.0 336.9 28.99 24.90 139 0.209 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 55.6 total, 55.4 interval Flush(GB): cumulative 9.536, interval 9.536 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 36.27 GB write, 667.77 MB/s write, 26.89 GB read, 495.03 MB/s read, 161.4 seconds Interval compaction: 36.27 GB write, 670.23 MB/s write, 26.89 GB read, 496.86 MB/s read, 161.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 31, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 31, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 36, pending-compaction-bytes-delays: 46, pending-compaction-bytes-stops: 0, total-delays: 77, total-stops: 36, interval: 113 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4127685 Average: 2.7040 StdDev: 23.43 Min: 0 Median: 1.5510 Max: 7015 Percentiles: P50: 1.55 P75: 1.93 P99: 7.01 P99.9: 76.47 P99.99: 312.11 ------------------------------------------------------ [ 0, 1 ] 565497 13.700% 13.700% ### ( 1, 2 ] 2719438 65.883% 79.583% ############# ( 2, 3 ] 487262 11.805% 91.388% ## ( 3, 4 ] 161948 3.923% 95.311% # ( 4, 6 ] 142292 3.447% 98.758% # ( 6, 10 ] 39473 0.956% 99.715% ( 10, 15 ] 6845 0.166% 99.881% ( 15, 22 ] 673 0.016% 99.897% ( 22, 34 ] 61 0.001% 99.898% ( 34, 51 ] 24 0.001% 99.899% ( 51, 76 ] 25 0.001% 99.900% ( 76, 110 ] 1393 0.034% 99.933% ( 110, 170 ] 1470 0.036% 99.969% ( 170, 250 ] 629 0.015% 99.984% ( 250, 380 ] 507 0.012% 99.996% ( 380, 580 ] 596 0.014% 100.011% ( 580, 870 ] 375 0.009% 100.020% ( 870, 1300 ] 193 0.005% 100.025% ( 1300, 1900 ] 78 0.002% 100.027% ( 1900, 2900 ] 54 0.001% 100.028% ( 2900, 4400 ] 63 0.002% 100.029% ( 4400, 6600 ] 9 0.000% 100.030% ( 6600, 9900 ] 1 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 1797801 Average: 3.8674 StdDev: 49.85 Min: 0 Median: 1.6324 Max: 11016 Percentiles: P50: 1.63 P75: 2.19 P99: 9.27 P99.9: 161.47 P99.99: 488.62 ------------------------------------------------------ [ 0, 1 ] 212240 11.806% 11.806% ## ( 1, 2 ] 1085728 60.392% 72.198% ############ ( 2, 3 ] 259712 14.446% 86.644% ### ( 3, 4 ] 93846 5.220% 91.864% # ( 4, 6 ] 99804 5.551% 97.415% # ( 6, 10 ] 34804 1.936% 99.351% ( 10, 15 ] 6542 0.364% 99.715% ( 15, 22 ] 759 0.042% 99.757% ( 22, 34 ] 70 0.004% 99.761% ( 34, 51 ] 14 0.001% 99.762% ( 51, 76 ] 40 0.002% 99.764% ( 76, 110 ] 1191 0.066% 99.830% ( 110, 170 ] 1461 0.081% 99.912% ( 170, 250 ] 542 0.030% 99.942% ( 250, 380 ] 563 0.031% 99.973% ( 380, 580 ] 562 0.031% 100.004% ( 580, 870 ] 416 0.023% 100.027% ( 870, 1300 ] 233 0.013% 100.040% ( 1300, 1900 ] 119 0.007% 100.047% ( 1900, 2900 ] 116 0.006% 100.053% ( 2900, 4400 ] 128 0.007% 100.061% ( 4400, 6600 ] 23 0.001% 100.062% ( 6600, 9900 ] 8 0.000% 100.062% ( 9900, 14000 ] 1 0.000% 100.062% ** Level 2 read latency histogram (micros): Count: 124183 Average: 2.4196 StdDev: 17.15 Min: 0 Median: 1.4598 Max: 3560 Percentiles: P50: 1.46 P75: 1.85 P99: 6.34 P99.9: 100.73 P99.99: 604.10 ------------------------------------------------------ [ 0, 1 ] 25687 20.685% 20.685% #### ( 1, 2 ] 79175 63.757% 84.442% ############# ( 2, 3 ] 10855 8.741% 93.183% ## ( 3, 4 ] 4117 3.315% 96.498% # ( 4, 6 ] 3020 2.432% 98.930% ( 6, 10 ] 1011 0.814% 99.744% ( 10, 15 ] 155 0.125% 99.869% ( 15, 22 ] 12 0.010% 99.878% ( 22, 34 ] 4 0.003% 99.882% ( 34, 51 ] 1 0.001% 99.882% ( 76, 110 ] 30 0.024% 99.907% ( 110, 170 ] 59 0.048% 99.954% ( 170, 250 ] 21 0.017% 99.971% ( 250, 380 ] 10 0.008% 99.979% ( 380, 580 ] 13 0.010% 99.990% ( 580, 870 ] 7 0.006% 99.995% ( 870, 1300 ] 3 0.002% 99.998% ( 1900, 2900 ] 2 0.002% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1312728 Average: 4.6982 StdDev: 64.59 Min: 0 Median: 1.9260 Max: 8175 Percentiles: P50: 1.93 P75: 2.93 P99: 9.22 P99.9: 16.25 P99.99: 146.55 ------------------------------------------------------ [ 0, 1 ] 45588 3.473% 3.473% # ( 1, 2 ] 659603 50.247% 53.720% ########## ( 2, 3 ] 300142 22.864% 76.583% ##### ( 3, 4 ] 125674 9.573% 86.157% ## ( 4, 6 ] 145360 11.073% 97.230% ## ( 6, 10 ] 28899 2.201% 99.432% ( 10, 15 ] 6037 0.460% 99.891% ( 15, 22 ] 631 0.048% 99.940% ( 22, 34 ] 62 0.005% 99.944% ( 34, 51 ] 30 0.002% 99.947% ( 51, 76 ] 49 0.004% 99.950% ( 76, 110 ] 208 0.016% 99.966% ( 110, 170 ] 515 0.039% 100.005% ( 170, 250 ] 445 0.034% 100.039% ( 250, 380 ] 424 0.032% 100.072% ( 380, 580 ] 449 0.034% 100.106% ( 580, 870 ] 345 0.026% 100.132% ( 870, 1300 ] 213 0.016% 100.148% ( 1300, 1900 ] 98 0.007% 100.156% ( 1900, 2900 ] 113 0.009% 100.164% ( 2900, 4400 ] 180 0.014% 100.178% ( 4400, 6600 ] 25 0.002% 100.180% ( 6600, 9900 ] 18 0.001% 100.181% ** Level 4 read latency histogram (micros): Count: 43995 Average: 51.7278 StdDev: 284.68 Min: 0 Median: 2.1653 Max: 9566 Percentiles: P50: 2.17 P75: 3.48 P99: 1221.08 P99.9: 3887.44 P99.99: 6132.57 ------------------------------------------------------ [ 0, 1 ] 1093 2.484% 2.484% ( 1, 2 ] 19230 43.710% 46.194% ######### ( 2, 3 ] 10133 23.032% 69.226% ##### ( 3, 4 ] 5255 11.945% 81.171% ## ( 4, 6 ] 3910 8.887% 90.058% ## ( 6, 10 ] 943 2.143% 92.201% ( 10, 15 ] 465 1.057% 93.258% ( 15, 22 ] 59 0.134% 93.392% ( 22, 34 ] 12 0.027% 93.420% ( 34, 51 ] 2 0.005% 93.424% ( 51, 76 ] 1 0.002% 93.427% ( 76, 110 ] 54 0.123% 93.549% ( 110, 170 ] 338 0.768% 94.318% ( 170, 250 ] 357 0.811% 95.129% ( 250, 380 ] 392 0.891% 96.020% ( 380, 580 ] 538 1.223% 97.243% ( 580, 870 ] 493 1.121% 98.363% ( 870, 1300 ] 343 0.780% 99.143% ( 1300, 1900 ] 190 0.432% 99.575% ( 1900, 2900 ] 91 0.207% 99.782% ( 2900, 4400 ] 79 0.180% 99.961% ( 4400, 6600 ] 16 0.036% 99.998% ( 6600, 9900 ] 8 0.018% 100.016% ** Level 5 read latency histogram (micros): Count: 240 Average: 1182.2208 StdDev: 1329.71 Min: 90 Median: 527.3684 Max: 5872 Percentiles: P50: 527.37 P75: 1733.33 P99: 5720.00 P99.9: 5872.00 P99.99: 5872.00 ------------------------------------------------------ ( 76, 110 ] 11 4.583% 4.583% # ( 110, 170 ] 35 14.583% 19.167% ### ( 170, 250 ] 27 11.250% 30.417% ## ( 250, 380 ] 33 13.750% 44.167% ### ( 380, 580 ] 19 7.917% 52.083% ## ( 580, 870 ] 19 7.917% 60.000% ## ( 870, 1300 ] 23 9.583% 69.583% ## ( 1300, 1900 ] 18 7.500% 77.083% ## ( 1900, 2900 ] 19 7.917% 85.000% ## ( 2900, 4400 ] 30 12.500% 97.500% ### ( 4400, 6600 ] 6 2.500% 100.000% # ** DB Stats ** Uptime(secs): 55.6 total, 4.7 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 176.94 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:28.471 H:M:S, 51.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 211.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:1.896 H:M:S, 40.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.749 micros/op 173929 ops/sec 60.001 seconds 10435999 operations; 168.5 MB/s Microseconds per write: Count: 10435999 Average: 5.7495 StdDev: 278.28 Min: 0 Median: 1.7273 Max: 308231 Percentiles: P50: 1.73 P75: 2.71 P99: 8.02 P99.9: 1158.53 P99.99: 2704.60 ------------------------------------------------------ [ 0, 1 ] 1466209 14.050% 14.050% ### ( 1, 2 ] 5158194 49.427% 63.476% ########## ( 2, 3 ] 1687894 16.174% 79.650% ### ( 3, 4 ] 1438543 13.784% 93.435% ### ( 4, 6 ] 536562 5.141% 98.576% # ( 6, 10 ] 87635 0.840% 99.416% ( 10, 15 ] 20901 0.200% 99.616% ( 15, 22 ] 6157 0.059% 99.675% ( 22, 34 ] 1126 0.011% 99.686% ( 34, 51 ] 153 0.001% 99.687% ( 51, 76 ] 18 0.000% 99.688% ( 76, 110 ] 7379 0.071% 99.758% ( 110, 170 ] 2827 0.027% 99.785% ( 170, 250 ] 300 0.003% 99.788% ( 250, 380 ] 84 0.001% 99.789% ( 380, 580 ] 13 0.000% 99.789% ( 580, 870 ] 20 0.000% 99.789% ( 870, 1300 ] 17210 0.165% 99.954% ( 1300, 1900 ] 96 0.001% 99.955% ( 1900, 2900 ] 4517 0.043% 99.998% ( 2900, 4400 ] 115 0.001% 100.000% ( 4400, 6600 ] 17 0.000% 100.000% ( 6600, 9900 ] 8 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% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 14 0.000% 100.000% ( 250000, 380000 ] 2 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 198602 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 : 10435999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10769950968 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 : 566 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31915389 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 : 32846110093 rocksdb.compact.write.bytes COUNT : 32653083449 rocksdb.flush.write.bytes COUNT : 10635309258 rocksdb.compact.read.marked.bytes COUNT : 0 rocksdb.compact.read.periodic.bytes COUNT : 0 rocksdb.compact.read.ttl.bytes COUNT : 0 rocksdb.compact.write.marked.bytes COUNT : 0 rocksdb.compact.write.periodic.bytes COUNT : 0 rocksdb.compact.write.ttl.bytes COUNT : 0 rocksdb.number.direct.load.table.properties COUNT : 57 rocksdb.number.superversion_acquires COUNT : 0 rocksdb.number.superversion_releases COUNT : 0 rocksdb.number.superversion_cleanups COUNT : 0 rocksdb.number.block.compressed COUNT : 0 rocksdb.number.block.decompressed COUNT : 0 rocksdb.number.block.not_compressed COUNT : 0 rocksdb.merge.operation.time.nanos COUNT : 0 rocksdb.filter.operation.time.nanos COUNT : 0 rocksdb.row.cache.hit COUNT : 0 rocksdb.row.cache.miss COUNT : 0 rocksdb.read.amp.estimate.useful.bytes COUNT : 0 rocksdb.read.amp.total.read.bytes COUNT : 0 rocksdb.number.rate_limiter.drains COUNT : 0 rocksdb.number.iter.skip COUNT : 0 rocksdb.blobdb.num.put COUNT : 0 rocksdb.blobdb.num.write COUNT : 0 rocksdb.blobdb.num.get COUNT : 0 rocksdb.blobdb.num.multiget COUNT : 0 rocksdb.blobdb.num.seek COUNT : 0 rocksdb.blobdb.num.next COUNT : 0 rocksdb.blobdb.num.prev COUNT : 0 rocksdb.blobdb.num.keys.written COUNT : 0 rocksdb.blobdb.num.keys.read COUNT : 0 rocksdb.blobdb.bytes.written COUNT : 0 rocksdb.blobdb.bytes.read COUNT : 0 rocksdb.blobdb.write.inlined COUNT : 0 rocksdb.blobdb.write.inlined.ttl COUNT : 0 rocksdb.blobdb.write.blob COUNT : 0 rocksdb.blobdb.write.blob.ttl COUNT : 0 rocksdb.blobdb.blob.file.bytes.written COUNT : 0 rocksdb.blobdb.blob.file.bytes.read COUNT : 0 rocksdb.blobdb.blob.file.synced COUNT : 0 rocksdb.blobdb.blob.index.expired.count COUNT : 0 rocksdb.blobdb.blob.index.expired.size COUNT : 0 rocksdb.blobdb.blob.index.evicted.count COUNT : 0 rocksdb.blobdb.blob.index.evicted.size COUNT : 0 rocksdb.blobdb.gc.num.files COUNT : 0 rocksdb.blobdb.gc.num.new.files COUNT : 0 rocksdb.blobdb.gc.failures COUNT : 0 rocksdb.blobdb.gc.num.keys.relocated COUNT : 0 rocksdb.blobdb.gc.bytes.relocated COUNT : 0 rocksdb.blobdb.fifo.num.files.evicted COUNT : 0 rocksdb.blobdb.fifo.num.keys.evicted COUNT : 0 rocksdb.blobdb.fifo.bytes.evicted COUNT : 0 rocksdb.txn.overhead.mutex.prepare COUNT : 0 rocksdb.txn.overhead.mutex.old.commit.map COUNT : 0 rocksdb.txn.overhead.duplicate.key COUNT : 0 rocksdb.txn.overhead.mutex.snapshot COUNT : 0 rocksdb.txn.get.tryagain COUNT : 0 rocksdb.number.multiget.keys.found COUNT : 0 rocksdb.num.iterator.created COUNT : 0 rocksdb.num.iterator.deleted COUNT : 0 rocksdb.block.cache.compression.dict.miss COUNT : 0 rocksdb.block.cache.compression.dict.hit COUNT : 0 rocksdb.block.cache.compression.dict.add COUNT : 0 rocksdb.block.cache.compression.dict.bytes.insert COUNT : 0 rocksdb.block.cache.add.redundant COUNT : 0 rocksdb.block.cache.index.add.redundant COUNT : 0 rocksdb.block.cache.filter.add.redundant COUNT : 0 rocksdb.block.cache.data.add.redundant COUNT : 0 rocksdb.block.cache.compression.dict.add.redundant COUNT : 0 rocksdb.files.marked.trash COUNT : 0 rocksdb.files.deleted.immediately COUNT : 241 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 : 10549562368 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4113408 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 : 32943761968 rocksdb.non.last.level.read.count COUNT : 7959830 rocksdb.block.checksum.compute.count COUNT : 7958755 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.376620 P95 : 3.843793 P99 : 6.265294 P100 : 308229.000000 COUNT : 10435999 SUM : 55321267 rocksdb.compaction.times.micros P50 : 920714.285714 P95 : 3985000.000000 P99 : 18080000.000000 P100 : 18216536.000000 COUNT : 98 SUM : 136422260 rocksdb.compaction.times.cpu_micros P50 : 869714.285714 P95 : 3635000.000000 P99 : 16718996.000000 P100 : 16718996.000000 COUNT : 98 SUM : 119220565 rocksdb.subcompaction.setup.times.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.table.sync.micros P50 : 689.945055 P95 : 1159.423077 P99 : 11027.500000 P100 : 13379.000000 COUNT : 145 SUM : 121114 rocksdb.compaction.outfile.sync.micros P50 : 972.613636 P95 : 66718.750000 P99 : 104575.000000 P100 : 130433.000000 COUNT : 386 SUM : 3803439 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 : 101.895349 P95 : 1243.318182 P99 : 2785.000000 P100 : 3511.000000 COUNT : 269 SUM : 75250 rocksdb.table.open.io.micros P50 : 1377.064220 P95 : 7569.375000 P99 : 17883.636364 P100 : 20497.000000 COUNT : 566 SUM : 1247796 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.664623 P95 : 7.928215 P99 : 11.728422 P100 : 11023.000000 COUNT : 7957358 SUM : 44733780 rocksdb.read.block.get.micros P50 : 475.180723 P95 : 3647.457627 P99 : 6316.444444 P100 : 9634.000000 COUNT : 1132 SUM : 1013664 rocksdb.write.raw.block.micros P50 : 0.512921 P95 : 0.974551 P99 : 2.976893 P100 : 13000.000000 COUNT : 10499210 SUM : 20396152 rocksdb.numfiles.in.singlecompaction P50 : 3.041667 P95 : 5.566667 P99 : 20.845000 P100 : 28.000000 COUNT : 133 SUM : 490 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.557356 P95 : 1150.625465 P99 : 2452.300355 P100 : 308021.000000 COUNT : 213823 SUM : 31928813 rocksdb.sst.read.micros P50 : 1.617928 P95 : 4.792907 P99 : 8.599154 P100 : 11016.000000 COUNT : 7960418 SUM : 28541339 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 : 10435999 SUM : 10769950968 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 : 213539.823009 P95 : 349305.555556 P99 : 478166.666667 P100 : 521438.000000 COUNT : 145 SUM : 30091591 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 : 354 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