[2024-11-29 15:18:33.743822] Starting SPDK v24.09.1-pre git sha1 b18e1bd62 / DPDK 23.11.0 initialization... [2024-11-29 15:18:33.743960] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=lib.power:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid1852666 ] Set seed to 1732889913740354 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-29 15:18:33.841632] app.c: 917:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-29 15:18:33.882462] app.c: 610:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-29 15:18:33.882512] app.c: 611:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1852666' to capture a snapshot of events at runtime. [2024-11-29 15:18:33.882523] app.c: 616:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-29 15:18:33.882533] app.c: 617:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-29 15:18:33.882541] app.c: 618:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1852666 for offline analysis/debug. [2024-11-29 15:18:33.882632] reactor.c: 990:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Nov 29 15:18:38 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/29-15:18:40 ... thread 0: (1000000,1000000) ops and (356799.9,356799.9) ops/second in (2.802691,2.802691) 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/5 504.03 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 349.3 2.34 2.12 12 0.195 0 0 0.0 0.0 L1 3/3 251.72 MB 0.0 0.2 0.2 0.1 0.2 0.2 0.1 1.3 254.5 254.3 0.99 0.96 1 0.990 255K 213 0.0 0.0 L2 1/0 48.77 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 237.3 237.2 0.47 0.45 1 0.469 113K 34 0.0 0.0 L3 16/0 692.50 MB 0.7 0.1 0.1 0.0 0.1 0.1 0.0 1.0 208.8 208.8 0.30 0.24 1 0.300 63K 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 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 1188/8 96.94 GB 0.0 0.4 0.3 0.1 1.2 1.1 0.2 1.5 103.8 303.3 4.10 3.76 15 0.274 432K 247 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.2 1.1 0.1 1.5 103.8 303.3 4.10 3.76 15 0.274 432K 247 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.3 0.1 0.4 0.3 0.0 0.0 242.1 242.0 1.76 1.64 3 0.586 432K 247 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 349.3 2.34 2.12 12 0.195 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.22 GB write, 411.86 MB/s write, 0.42 GB read, 140.93 MB/s read, 4.1 seconds Interval compaction: 1.22 GB write, 443.80 MB/s write, 0.42 GB read, 151.86 MB/s read, 4.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 99006 Average: 1.7169 StdDev: 10.64 Min: 1 Median: 1.0821 Max: 1884 Percentiles: P50: 1.08 P75: 1.57 P99: 3.29 P99.9: 9.38 P99.99: 321.46 ------------------------------------------------------ [ 0, 1 ] 45339 45.794% 45.794% ######### ( 1, 2 ] 50706 51.215% 97.009% ########## ( 2, 3 ] 1770 1.788% 98.797% ( 3, 4 ] 688 0.695% 99.492% ( 4, 6 ] 300 0.303% 99.795% ( 6, 10 ] 123 0.124% 99.919% ( 10, 15 ] 47 0.047% 99.967% ( 15, 22 ] 7 0.007% 99.974% ( 22, 34 ] 1 0.001% 99.975% ( 34, 51 ] 1 0.001% 99.976% ( 110, 170 ] 8 0.008% 99.984% ( 170, 250 ] 5 0.005% 99.989% ( 250, 380 ] 2 0.002% 99.991% ( 380, 580 ] 1 0.001% 99.992% ( 580, 870 ] 4 0.004% 99.996% ( 870, 1300 ] 2 0.002% 99.998% ( 1300, 1900 ] 2 0.002% 100.000% ** Level 1 read latency histogram (micros): Count: 27472 Average: 2.1121 StdDev: 16.55 Min: 1 Median: 1.1567 Max: 1504 Percentiles: P50: 1.16 P75: 1.63 P99: 5.74 P99.9: 54.18 P99.99: 797.77 ------------------------------------------------------ [ 0, 1 ] 11457 41.704% 41.704% ######## ( 1, 2 ] 14542 52.934% 94.638% ########### ( 2, 3 ] 816 2.970% 97.608% # ( 3, 4 ] 227 0.826% 98.435% ( 4, 6 ] 178 0.648% 99.083% ( 6, 10 ] 145 0.528% 99.611% ( 10, 15 ] 27 0.098% 99.709% ( 15, 22 ] 4 0.015% 99.723% ( 22, 34 ] 2 0.007% 99.731% ( 34, 51 ] 45 0.164% 99.894% ( 51, 76 ] 12 0.044% 99.938% ( 76, 110 ] 1 0.004% 99.942% ( 110, 170 ] 2 0.007% 99.949% ( 170, 250 ] 3 0.011% 99.960% ( 250, 380 ] 3 0.011% 99.971% ( 380, 580 ] 3 0.011% 99.982% ( 580, 870 ] 3 0.011% 99.993% ( 1300, 1900 ] 2 0.007% 100.000% ** Level 2 read latency histogram (micros): Count: 15892 Average: 1.6407 StdDev: 3.39 Min: 1 Median: 1.0671 Max: 278 Percentiles: P50: 1.07 P75: 1.56 P99: 3.28 P99.9: 9.84 P99.99: 226.43 ------------------------------------------------------ [ 0, 1 ] 7410 46.627% 46.627% ######### ( 1, 2 ] 7986 50.252% 96.879% ########## ( 2, 3 ] 303 1.907% 98.786% ( 3, 4 ] 121 0.761% 99.547% ( 4, 6 ] 35 0.220% 99.767% ( 6, 10 ] 22 0.138% 99.906% ( 10, 15 ] 10 0.063% 99.969% ( 15, 22 ] 1 0.006% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 2 0.013% 99.994% ( 250, 380 ] 1 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 80 Average: 773.9125 StdDev: 1156.52 Min: 0 Median: 271.6667 Max: 4685 Percentiles: P50: 271.67 P75: 841.00 P99: 4685.00 P99.9: 4685.00 P99.99: 4685.00 ------------------------------------------------------ [ 0, 1 ] 31 38.750% 38.750% ######## ( 1, 2 ] 4 5.000% 43.750% # ( 2, 3 ] 1 1.250% 45.000% ( 3, 4 ] 1 1.250% 46.250% ( 51, 76 ] 1 1.250% 47.500% ( 170, 250 ] 1 1.250% 48.750% ( 250, 380 ] 6 7.500% 56.250% ## ( 380, 580 ] 6 7.500% 63.750% ## ( 580, 870 ] 10 12.500% 76.250% ### ( 870, 1300 ] 3 3.750% 80.000% # ( 1300, 1900 ] 2 2.500% 82.500% # ( 1900, 2900 ] 4 5.000% 87.500% # ( 2900, 4400 ] 9 11.250% 98.750% ## ( 4400, 6600 ] 1 1.250% 100.000% ** Level 4 read latency histogram (micros): Count: 35 Average: 1840.5714 StdDev: 1343.54 Min: 274 Median: 1146.4286 Max: 5171 Percentiles: P50: 1146.43 P75: 3108.33 P99: 5171.00 P99.9: 5171.00 P99.99: 5171.00 ------------------------------------------------------ ( 250, 380 ] 2 5.714% 5.714% # ( 380, 580 ] 2 5.714% 11.429% # ( 580, 870 ] 9 25.714% 37.143% ##### ( 870, 1300 ] 7 20.000% 57.143% #### ( 1300, 1900 ] 2 5.714% 62.857% # ( 1900, 2900 ] 3 8.571% 71.429% ## ( 2900, 4400 ] 9 25.714% 97.143% ##### ( 4400, 6600 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 325.65 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.190 H:M:S, 6.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 350.81 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.190 H:M:S, 6.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/29-15:18:44 ... thread 0: (1000000,2000000) ops and (313704.8,333867.5) ops/second in (3.187710,5.990401) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/9 1.23 GB 18.9 0.6 0.0 0.6 2.4 1.8 0.0 1.3 76.0 329.3 7.46 6.86 28 0.266 575K 606 0.0 0.0 L1 6/6 565.42 MB 0.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 246.3 245.9 3.32 3.23 2 1.662 831K 1467 0.0 0.0 L2 1/0 48.77 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 237.3 237.2 0.47 0.45 1 0.469 113K 34 0.0 0.0 L3 16/0 692.50 MB 0.7 0.1 0.1 0.0 0.1 0.1 0.0 1.0 208.8 208.8 0.30 0.24 1 0.300 63K 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 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 1194/15 97.98 GB 0.0 1.5 0.6 0.9 3.4 2.5 0.2 1.8 135.0 298.4 11.55 10.79 32 0.361 1583K 2107 0.0 0.0 Int 0/0 0.00 KB 0.0 1.5 0.6 0.9 3.4 2.5 0.1 1.8 135.0 298.4 11.55 10.79 32 0.361 1583K 2107 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.5 0.6 0.9 1.5 0.6 0.0 0.0 251.4 251.1 6.20 5.99 6 1.034 1583K 2107 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.8 1.8 0.0 0.0 0.0 353.4 5.35 4.80 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.37 GB write, 555.16 MB/s write, 1.52 GB read, 251.17 MB/s read, 11.6 seconds Interval compaction: 3.37 GB write, 575.31 MB/s write, 1.52 GB read, 260.28 MB/s read, 11.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 387537 Average: 2.0003 StdDev: 11.90 Min: 1 Median: 1.3650 Max: 3740 Percentiles: P50: 1.36 P75: 1.77 P99: 5.01 P99.9: 9.99 P99.99: 14.67 ------------------------------------------------------ [ 0, 1 ] 105764 27.291% 27.291% ##### ( 1, 2 ] 241141 62.224% 89.515% ############ ( 2, 3 ] 24950 6.438% 95.953% # ( 3, 4 ] 9558 2.466% 98.420% ( 4, 6 ] 4467 1.153% 99.572% ( 6, 10 ] 1274 0.329% 99.901% ( 10, 15 ] 370 0.095% 99.997% ( 15, 22 ] 21 0.005% 100.002% ( 22, 34 ] 8 0.002% 100.004% ( 34, 51 ] 2 0.001% 100.005% ( 51, 76 ] 1 0.000% 100.005% ( 110, 170 ] 16 0.004% 100.009% ( 170, 250 ] 9 0.002% 100.011% ( 250, 380 ] 7 0.002% 100.013% ( 380, 580 ] 3 0.001% 100.014% ( 580, 870 ] 9 0.002% 100.016% ( 870, 1300 ] 7 0.002% 100.018% ( 1300, 1900 ] 3 0.001% 100.019% ( 1900, 2900 ] 1 0.000% 100.019% ( 2900, 4400 ] 2 0.001% 100.020% ** Level 1 read latency histogram (micros): Count: 105990 Average: 2.0776 StdDev: 11.09 Min: 1 Median: 1.3703 Max: 1561 Percentiles: P50: 1.37 P75: 1.77 P99: 5.15 P99.9: 14.40 P99.99: 526.70 ------------------------------------------------------ [ 0, 1 ] 28447 26.839% 26.839% ##### ( 1, 2 ] 66294 62.547% 89.387% ############# ( 2, 3 ] 7132 6.729% 96.116% # ( 3, 4 ] 2389 2.254% 98.370% ( 4, 6 ] 1158 1.093% 99.462% ( 6, 10 ] 368 0.347% 99.809% ( 10, 15 ] 109 0.103% 99.912% ( 15, 22 ] 5 0.005% 99.917% ( 22, 34 ] 3 0.003% 99.920% ( 34, 51 ] 45 0.042% 99.962% ( 51, 76 ] 12 0.011% 99.974% ( 76, 110 ] 2 0.002% 99.975% ( 110, 170 ] 3 0.003% 99.978% ( 170, 250 ] 4 0.004% 99.982% ( 250, 380 ] 4 0.004% 99.986% ( 380, 580 ] 6 0.006% 99.992% ( 580, 870 ] 4 0.004% 99.995% ( 870, 1300 ] 2 0.002% 99.997% ( 1300, 1900 ] 3 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 15892 Average: 1.6407 StdDev: 3.39 Min: 1 Median: 1.0671 Max: 278 Percentiles: P50: 1.07 P75: 1.56 P99: 3.28 P99.9: 9.84 P99.99: 226.43 ------------------------------------------------------ [ 0, 1 ] 7410 46.627% 46.627% ######### ( 1, 2 ] 7986 50.252% 96.879% ########## ( 2, 3 ] 303 1.907% 98.786% ( 3, 4 ] 121 0.761% 99.547% ( 4, 6 ] 35 0.220% 99.767% ( 6, 10 ] 22 0.138% 99.906% ( 10, 15 ] 10 0.063% 99.969% ( 15, 22 ] 1 0.006% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 2 0.013% 99.994% ( 250, 380 ] 1 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 80 Average: 773.9125 StdDev: 1156.52 Min: 0 Median: 271.6667 Max: 4685 Percentiles: P50: 271.67 P75: 841.00 P99: 4685.00 P99.9: 4685.00 P99.99: 4685.00 ------------------------------------------------------ [ 0, 1 ] 31 38.750% 38.750% ######## ( 1, 2 ] 4 5.000% 43.750% # ( 2, 3 ] 1 1.250% 45.000% ( 3, 4 ] 1 1.250% 46.250% ( 51, 76 ] 1 1.250% 47.500% ( 170, 250 ] 1 1.250% 48.750% ( 250, 380 ] 6 7.500% 56.250% ## ( 380, 580 ] 6 7.500% 63.750% ## ( 580, 870 ] 10 12.500% 76.250% ### ( 870, 1300 ] 3 3.750% 80.000% # ( 1300, 1900 ] 2 2.500% 82.500% # ( 1900, 2900 ] 4 5.000% 87.500% # ( 2900, 4400 ] 9 11.250% 98.750% ## ( 4400, 6600 ] 1 1.250% 100.000% ** Level 4 read latency histogram (micros): Count: 35 Average: 1840.5714 StdDev: 1343.54 Min: 274 Median: 1146.4286 Max: 5171 Percentiles: P50: 1146.43 P75: 3108.33 P99: 5171.00 P99.9: 5171.00 P99.99: 5171.00 ------------------------------------------------------ ( 250, 380 ] 2 5.714% 5.714% # ( 380, 580 ] 2 5.714% 11.429% # ( 580, 870 ] 9 25.714% 37.143% ##### ( 870, 1300 ] 7 20.000% 57.143% #### ( 1300, 1900 ] 2 5.714% 62.857% # ( 1900, 2900 ] 3 8.571% 71.429% ## ( 2900, 4400 ] 9 25.714% 97.143% ##### ( 4400, 6600 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 6.2 total, 3.2 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 316.98 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.769 H:M:S, 12.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 308.75 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.579 H:M:S, 18.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/29-15:18:46 ... thread 0: (1000000,3000000) ops and (357810.8,341484.4) ops/second in (2.794773,8.785174) 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/9 2.09 GB 107.0 1.4 0.0 1.4 4.1 2.7 0.0 1.5 106.5 319.4 13.01 12.10 44 0.296 1407K 1498 0.0 0.0 L1 6/6 565.42 MB 0.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 246.3 245.9 3.32 3.23 2 1.662 831K 1467 0.0 0.0 L2 1/0 48.77 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 237.3 237.2 0.47 0.45 1 0.469 113K 34 0.0 0.0 L3 16/0 692.50 MB 0.7 0.1 0.1 0.0 0.1 0.1 0.0 1.0 208.8 208.8 0.30 0.24 1 0.300 63K 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 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 1198/15 98.84 GB 0.0 2.3 0.6 1.7 5.0 3.3 0.2 1.9 139.0 300.9 17.11 16.02 48 0.356 2415K 2999 0.0 0.0 Int 0/0 0.00 KB 0.0 2.3 0.6 1.7 5.0 3.3 0.1 1.9 139.0 300.9 17.11 16.02 48 0.356 2415K 2999 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 2.3 0.6 1.7 2.3 0.6 0.0 0.0 256.3 256.0 9.28 9.00 9 1.031 2415K 2999 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 354.1 7.83 7.02 39 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.0 total, 8.8 interval Flush(GB): cumulative 2.707, interval 2.707 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.03 GB write, 571.65 MB/s write, 2.32 GB read, 264.16 MB/s read, 17.1 seconds Interval compaction: 5.03 GB write, 585.80 MB/s write, 2.32 GB read, 270.70 MB/s read, 17.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 10, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 10, interval: 10 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 691604 Average: 2.0714 StdDev: 10.18 Min: 1 Median: 1.4275 Max: 3740 Percentiles: P50: 1.43 P75: 1.82 P99: 5.30 P99.9: 10.28 P99.99: 14.44 ------------------------------------------------------ [ 0, 1 ] 155229 22.445% 22.445% #### ( 1, 2 ] 445828 64.463% 86.908% ############# ( 2, 3 ] 57129 8.260% 95.168% ## ( 3, 4 ] 19861 2.872% 98.040% # ( 4, 6 ] 10224 1.478% 99.518% ( 6, 10 ] 2602 0.376% 99.894% ( 10, 15 ] 747 0.108% 100.002% ( 15, 22 ] 42 0.006% 100.008% ( 22, 34 ] 15 0.002% 100.011% ( 34, 51 ] 2 0.000% 100.011% ( 51, 76 ] 6 0.001% 100.012% ( 110, 170 ] 23 0.003% 100.015% ( 170, 250 ] 16 0.002% 100.017% ( 250, 380 ] 14 0.002% 100.019% ( 380, 580 ] 5 0.001% 100.020% ( 580, 870 ] 15 0.002% 100.022% ( 870, 1300 ] 8 0.001% 100.023% ( 1300, 1900 ] 3 0.000% 100.024% ( 1900, 2900 ] 3 0.000% 100.024% ( 2900, 4400 ] 2 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 174909 Average: 2.0970 StdDev: 8.65 Min: 1 Median: 1.4332 Max: 1561 Percentiles: P50: 1.43 P75: 1.82 P99: 5.26 P99.9: 12.89 P99.99: 299.05 ------------------------------------------------------ [ 0, 1 ] 38330 21.914% 21.914% #### ( 1, 2 ] 113387 64.826% 86.741% ############# ( 2, 3 ] 15349 8.775% 95.516% ## ( 3, 4 ] 4591 2.625% 98.141% # ( 4, 6 ] 2388 1.365% 99.506% ( 6, 10 ] 581 0.332% 99.838% ( 10, 15 ] 187 0.107% 99.945% ( 15, 22 ] 7 0.004% 99.949% ( 22, 34 ] 3 0.002% 99.951% ( 34, 51 ] 45 0.026% 99.977% ( 51, 76 ] 13 0.007% 99.984% ( 76, 110 ] 2 0.001% 99.985% ( 110, 170 ] 3 0.002% 99.987% ( 170, 250 ] 4 0.002% 99.989% ( 250, 380 ] 4 0.002% 99.991% ( 380, 580 ] 6 0.003% 99.995% ( 580, 870 ] 4 0.002% 99.997% ( 870, 1300 ] 2 0.001% 99.998% ( 1300, 1900 ] 3 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 15892 Average: 1.6407 StdDev: 3.39 Min: 1 Median: 1.0671 Max: 278 Percentiles: P50: 1.07 P75: 1.56 P99: 3.28 P99.9: 9.84 P99.99: 226.43 ------------------------------------------------------ [ 0, 1 ] 7410 46.627% 46.627% ######### ( 1, 2 ] 7986 50.252% 96.879% ########## ( 2, 3 ] 303 1.907% 98.786% ( 3, 4 ] 121 0.761% 99.547% ( 4, 6 ] 35 0.220% 99.767% ( 6, 10 ] 22 0.138% 99.906% ( 10, 15 ] 10 0.063% 99.969% ( 15, 22 ] 1 0.006% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 2 0.013% 99.994% ( 250, 380 ] 1 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 80 Average: 773.9125 StdDev: 1156.52 Min: 0 Median: 271.6667 Max: 4685 Percentiles: P50: 271.67 P75: 841.00 P99: 4685.00 P99.9: 4685.00 P99.99: 4685.00 ------------------------------------------------------ [ 0, 1 ] 31 38.750% 38.750% ######## ( 1, 2 ] 4 5.000% 43.750% # ( 2, 3 ] 1 1.250% 45.000% ( 3, 4 ] 1 1.250% 46.250% ( 51, 76 ] 1 1.250% 47.500% ( 170, 250 ] 1 1.250% 48.750% ( 250, 380 ] 6 7.500% 56.250% ## ( 380, 580 ] 6 7.500% 63.750% ## ( 580, 870 ] 10 12.500% 76.250% ### ( 870, 1300 ] 3 3.750% 80.000% # ( 1300, 1900 ] 2 2.500% 82.500% # ( 1900, 2900 ] 4 5.000% 87.500% # ( 2900, 4400 ] 9 11.250% 98.750% ## ( 4400, 6600 ] 1 1.250% 100.000% ** Level 4 read latency histogram (micros): Count: 35 Average: 1840.5714 StdDev: 1343.54 Min: 274 Median: 1146.4286 Max: 5171 Percentiles: P50: 1146.43 P75: 3108.33 P99: 5171.00 P99.9: 5171.00 P99.99: 5171.00 ------------------------------------------------------ ( 250, 380 ] 2 5.714% 5.714% # ( 380, 580 ] 2 5.714% 11.429% # ( 580, 870 ] 9 25.714% 37.143% ##### ( 870, 1300 ] 7 20.000% 57.143% #### ( 1300, 1900 ] 2 5.714% 62.857% # ( 1900, 2900 ] 3 8.571% 71.429% ## ( 2900, 4400 ] 9 25.714% 97.143% ##### ( 4400, 6600 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 9.0 total, 2.8 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 327.90 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.969 H:M:S, 10.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 352.16 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.200 H:M:S, 7.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/29-15:18:50 ... thread 0: (1000000,4000000) ops and (311324.2,333409.5) ops/second in (3.212086,11.997260) 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/8 2.34 GB 176.2 2.2 0.0 2.2 5.9 3.8 0.0 1.6 115.3 316.1 19.12 17.82 61 0.314 2238K 2342 0.0 0.0 L1 12/0 1.34 GB 137.6 2.2 1.3 0.9 2.1 1.3 0.1 1.7 237.9 236.9 9.26 8.94 3 3.086 2236K 8695 0.0 0.0 L2 1/0 48.77 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 237.3 237.2 0.47 0.45 1 0.469 113K 34 0.0 0.0 L3 16/0 692.50 MB 0.7 0.1 0.1 0.0 0.1 0.1 0.0 1.0 208.8 208.8 0.30 0.24 1 0.300 63K 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 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 1204/8 99.88 GB 0.0 4.5 1.4 3.1 8.2 5.2 0.2 2.2 157.2 288.6 29.15 27.44 66 0.442 4651K 11K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.5 1.4 3.1 8.2 5.2 0.1 2.2 157.2 288.6 29.15 27.44 66 0.442 4651K 11K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.5 1.4 3.1 4.5 1.4 0.0 0.0 249.9 249.3 18.33 17.74 13 1.410 4651K 11K 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 355.1 10.82 9.70 53 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): 12.2 total, 12.0 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.22 GB write, 688.62 MB/s write, 4.47 GB read, 375.01 MB/s read, 29.2 seconds Interval compaction: 8.22 GB write, 701.10 MB/s write, 4.47 GB read, 381.81 MB/s read, 29.2 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: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 14, interval: 14 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1005043 Average: 2.1124 StdDev: 10.72 Min: 1 Median: 1.4253 Max: 3740 Percentiles: P50: 1.43 P75: 1.81 P99: 5.31 P99.9: 11.13 P99.99: 44.61 ------------------------------------------------------ [ 0, 1 ] 227414 22.627% 22.627% ##### ( 1, 2 ] 646797 64.355% 86.982% ############# ( 2, 3 ] 82077 8.167% 95.149% ## ( 3, 4 ] 29171 2.902% 98.051% # ( 4, 6 ] 14555 1.448% 99.500% ( 6, 10 ] 3790 0.377% 99.877% ( 10, 15 ] 1039 0.103% 99.980% ( 15, 22 ] 77 0.008% 99.988% ( 22, 34 ] 21 0.002% 99.990% ( 34, 51 ] 4 0.000% 99.990% ( 51, 76 ] 7 0.001% 99.991% ( 76, 110 ] 97 0.010% 100.001% ( 110, 170 ] 95 0.009% 100.010% ( 170, 250 ] 42 0.004% 100.014% ( 250, 380 ] 43 0.004% 100.019% ( 380, 580 ] 25 0.002% 100.021% ( 580, 870 ] 27 0.003% 100.024% ( 870, 1300 ] 13 0.001% 100.025% ( 1300, 1900 ] 6 0.001% 100.026% ( 1900, 2900 ] 6 0.001% 100.026% ( 2900, 4400 ] 2 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 219854 Average: 2.2628 StdDev: 14.34 Min: 1 Median: 1.4548 Max: 2763 Percentiles: P50: 1.45 P75: 1.83 P99: 5.37 P99.9: 14.47 P99.99: 622.03 ------------------------------------------------------ [ 0, 1 ] 44164 20.088% 20.088% #### ( 1, 2 ] 144605 65.773% 85.861% ############# ( 2, 3 ] 20435 9.295% 95.156% ## ( 3, 4 ] 6263 2.849% 98.005% # ( 4, 6 ] 3204 1.457% 99.462% ( 6, 10 ] 763 0.347% 99.809% ( 10, 15 ] 224 0.102% 99.911% ( 15, 22 ] 9 0.004% 99.915% ( 22, 34 ] 4 0.002% 99.917% ( 34, 51 ] 45 0.020% 99.937% ( 51, 76 ] 13 0.006% 99.943% ( 76, 110 ] 28 0.013% 99.956% ( 110, 170 ] 34 0.015% 99.971% ( 170, 250 ] 10 0.005% 99.976% ( 250, 380 ] 10 0.005% 99.980% ( 380, 580 ] 20 0.009% 99.990% ( 580, 870 ] 7 0.003% 99.993% ( 870, 1300 ] 6 0.003% 99.995% ( 1300, 1900 ] 9 0.004% 100.000% ( 1900, 2900 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 15892 Average: 1.6407 StdDev: 3.39 Min: 1 Median: 1.0671 Max: 278 Percentiles: P50: 1.07 P75: 1.56 P99: 3.28 P99.9: 9.84 P99.99: 226.43 ------------------------------------------------------ [ 0, 1 ] 7410 46.627% 46.627% ######### ( 1, 2 ] 7986 50.252% 96.879% ########## ( 2, 3 ] 303 1.907% 98.786% ( 3, 4 ] 121 0.761% 99.547% ( 4, 6 ] 35 0.220% 99.767% ( 6, 10 ] 22 0.138% 99.906% ( 10, 15 ] 10 0.063% 99.969% ( 15, 22 ] 1 0.006% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 2 0.013% 99.994% ( 250, 380 ] 1 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 80 Average: 773.9125 StdDev: 1156.52 Min: 0 Median: 271.6667 Max: 4685 Percentiles: P50: 271.67 P75: 841.00 P99: 4685.00 P99.9: 4685.00 P99.99: 4685.00 ------------------------------------------------------ [ 0, 1 ] 31 38.750% 38.750% ######## ( 1, 2 ] 4 5.000% 43.750% # ( 2, 3 ] 1 1.250% 45.000% ( 3, 4 ] 1 1.250% 46.250% ( 51, 76 ] 1 1.250% 47.500% ( 170, 250 ] 1 1.250% 48.750% ( 250, 380 ] 6 7.500% 56.250% ## ( 380, 580 ] 6 7.500% 63.750% ## ( 580, 870 ] 10 12.500% 76.250% ### ( 870, 1300 ] 3 3.750% 80.000% # ( 1300, 1900 ] 2 2.500% 82.500% # ( 1900, 2900 ] 4 5.000% 87.500% # ( 2900, 4400 ] 9 11.250% 98.750% ## ( 4400, 6600 ] 1 1.250% 100.000% ** Level 4 read latency histogram (micros): Count: 35 Average: 1840.5714 StdDev: 1343.54 Min: 274 Median: 1146.4286 Max: 5171 Percentiles: P50: 1146.43 P75: 3108.33 P99: 5171.00 P99.9: 5171.00 P99.99: 5171.00 ------------------------------------------------------ ( 250, 380 ] 2 5.714% 5.714% # ( 380, 580 ] 2 5.714% 11.429% # ( 580, 870 ] 9 25.714% 37.143% ##### ( 870, 1300 ] 7 20.000% 57.143% #### ( 1300, 1900 ] 2 5.714% 62.857% # ( 1900, 2900 ] 3 8.571% 71.429% ## ( 2900, 4400 ] 9 25.714% 97.143% ##### ( 4400, 6600 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 12.2 total, 3.2 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 322.24 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.560 H:M:S, 12.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 306.39 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.592 H:M:S, 18.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/29-15:18:53 ... thread 0: (1000000,5000000) ops and (335145.8,333755.3) ops/second in (2.983776,14.981036) 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/17 3.26 GB 18.9 3.0 0.0 3.0 7.7 4.7 0.0 1.6 122.8 315.7 25.13 23.46 78 0.322 3134K 3295 0.0 0.0 L1 12/12 1.34 GB 0.0 2.2 1.3 0.9 2.1 1.3 0.1 1.7 237.9 236.9 9.26 8.94 3 3.086 2236K 8695 0.0 0.0 L2 1/0 48.77 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 237.3 237.2 0.47 0.45 1 0.469 113K 34 0.0 0.0 L3 16/0 692.50 MB 0.7 0.1 0.1 0.0 0.1 0.1 0.0 1.0 208.8 208.8 0.30 0.24 1 0.300 63K 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 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 1208/29 100.80 GB 0.0 5.3 1.4 3.9 10.1 6.1 0.2 2.1 155.4 293.0 35.16 33.08 83 0.424 5547K 12K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.3 1.4 3.9 10.1 6.1 0.1 2.1 155.4 293.0 35.16 33.08 83 0.424 5547K 12K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.3 1.4 3.9 5.3 1.4 0.0 0.0 253.7 253.1 21.53 20.89 16 1.346 5547K 12K 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 356.1 13.62 12.19 67 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.2 total, 15.0 interval Flush(GB): cumulative 4.737, interval 4.737 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 10.06 GB write, 677.71 MB/s write, 5.34 GB read, 359.42 MB/s read, 35.2 seconds Interval compaction: 10.06 GB write, 687.55 MB/s write, 5.34 GB read, 364.63 MB/s read, 35.2 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: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 17, interval: 17 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1253577 Average: 2.1245 StdDev: 12.51 Min: 1 Median: 1.4134 Max: 3740 Percentiles: P50: 1.41 P75: 1.80 P99: 5.28 P99.9: 11.59 P99.99: 108.26 ------------------------------------------------------ [ 0, 1 ] 295225 23.551% 23.551% ##### ( 1, 2 ] 802049 63.981% 87.531% ############# ( 2, 3 ] 98120 7.827% 95.359% ## ( 3, 4 ] 34767 2.773% 98.132% # ( 4, 6 ] 17065 1.361% 99.493% ( 6, 10 ] 4704 0.375% 99.869% ( 10, 15 ] 1234 0.098% 99.967% ( 15, 22 ] 95 0.008% 99.975% ( 22, 34 ] 25 0.002% 99.977% ( 34, 51 ] 5 0.000% 99.977% ( 51, 76 ] 8 0.001% 99.978% ( 76, 110 ] 163 0.013% 99.991% ( 110, 170 ] 187 0.015% 100.006% ( 170, 250 ] 69 0.006% 100.011% ( 250, 380 ] 54 0.004% 100.015% ( 380, 580 ] 38 0.003% 100.018% ( 580, 870 ] 36 0.003% 100.021% ( 870, 1300 ] 19 0.002% 100.023% ( 1300, 1900 ] 8 0.001% 100.023% ( 1900, 2900 ] 9 0.001% 100.024% ( 2900, 4400 ] 5 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 244457 Average: 2.2829 StdDev: 13.88 Min: 1 Median: 1.4534 Max: 2763 Percentiles: P50: 1.45 P75: 1.83 P99: 5.55 P99.9: 34.96 P99.99: 575.54 ------------------------------------------------------ [ 0, 1 ] 49545 20.267% 20.267% #### ( 1, 2 ] 160293 65.571% 85.838% ############# ( 2, 3 ] 22424 9.173% 95.011% ## ( 3, 4 ] 6999 2.863% 97.874% # ( 4, 6 ] 3541 1.449% 99.323% ( 6, 10 ] 1125 0.460% 99.783% ( 10, 15 ] 262 0.107% 99.890% ( 15, 22 ] 16 0.007% 99.897% ( 22, 34 ] 5 0.002% 99.899% ( 34, 51 ] 45 0.018% 99.917% ( 51, 76 ] 13 0.005% 99.923% ( 76, 110 ] 45 0.018% 99.941% ( 110, 170 ] 73 0.030% 99.971% ( 170, 250 ] 12 0.005% 99.976% ( 250, 380 ] 15 0.006% 99.982% ( 380, 580 ] 20 0.008% 99.990% ( 580, 870 ] 8 0.003% 99.993% ( 870, 1300 ] 6 0.002% 99.996% ( 1300, 1900 ] 9 0.004% 100.000% ( 1900, 2900 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 15892 Average: 1.6407 StdDev: 3.39 Min: 1 Median: 1.0671 Max: 278 Percentiles: P50: 1.07 P75: 1.56 P99: 3.28 P99.9: 9.84 P99.99: 226.43 ------------------------------------------------------ [ 0, 1 ] 7410 46.627% 46.627% ######### ( 1, 2 ] 7986 50.252% 96.879% ########## ( 2, 3 ] 303 1.907% 98.786% ( 3, 4 ] 121 0.761% 99.547% ( 4, 6 ] 35 0.220% 99.767% ( 6, 10 ] 22 0.138% 99.906% ( 10, 15 ] 10 0.063% 99.969% ( 15, 22 ] 1 0.006% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 2 0.013% 99.994% ( 250, 380 ] 1 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 80 Average: 773.9125 StdDev: 1156.52 Min: 0 Median: 271.6667 Max: 4685 Percentiles: P50: 271.67 P75: 841.00 P99: 4685.00 P99.9: 4685.00 P99.99: 4685.00 ------------------------------------------------------ [ 0, 1 ] 31 38.750% 38.750% ######## ( 1, 2 ] 4 5.000% 43.750% # ( 2, 3 ] 1 1.250% 45.000% ( 3, 4 ] 1 1.250% 46.250% ( 51, 76 ] 1 1.250% 47.500% ( 170, 250 ] 1 1.250% 48.750% ( 250, 380 ] 6 7.500% 56.250% ## ( 380, 580 ] 6 7.500% 63.750% ## ( 580, 870 ] 10 12.500% 76.250% ### ( 870, 1300 ] 3 3.750% 80.000% # ( 1300, 1900 ] 2 2.500% 82.500% # ( 1900, 2900 ] 4 5.000% 87.500% # ( 2900, 4400 ] 9 11.250% 98.750% ## ( 4400, 6600 ] 1 1.250% 100.000% ** Level 4 read latency histogram (micros): Count: 35 Average: 1840.5714 StdDev: 1343.54 Min: 274 Median: 1146.4286 Max: 5171 Percentiles: P50: 1146.43 P75: 3108.33 P99: 5171.00 P99.9: 5171.00 P99.99: 5171.00 ------------------------------------------------------ ( 250, 380 ] 2 5.714% 5.714% # ( 380, 580 ] 2 5.714% 11.429% # ( 580, 870 ] 9 25.714% 37.143% ##### ( 870, 1300 ] 7 20.000% 57.143% #### ( 1300, 1900 ] 2 5.714% 62.857% # ( 1900, 2900 ] 3 8.571% 71.429% ## ( 2900, 4400 ] 9 25.714% 97.143% ##### ( 4400, 6600 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 15.2 total, 3.0 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 323.74 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.967 H:M:S, 12.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 329.87 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.406 H:M:S, 13.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/29-15:19:11 ... thread 0: (1000000,6000000) ops and (53521.7,178226.4) ops/second in (18.684017,33.665053) 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 4/4 1.47 GB 0.0 5.6 0.0 5.6 11.3 5.7 0.0 2.0 149.9 302.8 38.24 35.76 100 0.382 5819K 11K 0.0 0.0 L1 10/10 1.08 GB 0.0 6.3 4.1 2.2 6.2 4.0 0.1 1.5 222.6 219.5 29.09 27.20 4 7.272 6573K 88K 0.0 0.0 L2 25/5 3.07 GB 25.8 0.1 0.1 0.0 0.1 0.1 3.1 1.8 237.3 237.2 0.47 0.45 1 0.469 113K 34 0.0 0.0 L3 16/9 692.50 MB 0.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 208.8 208.8 0.30 0.24 1 0.300 63K 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 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 1215/28 101.76 GB 0.0 12.1 4.2 7.8 17.7 9.9 3.2 3.1 181.8 266.4 68.09 63.66 106 0.642 12M 99K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.1 4.2 7.8 17.7 9.9 3.1 3.1 181.8 266.4 68.09 63.66 106 0.642 12M 99K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 12.1 4.2 7.8 12.0 4.1 0.0 0.0 239.8 237.9 51.62 48.96 23 2.244 12M 99K 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 355.6 16.48 14.70 83 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 33.9 total, 33.7 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: 17.71 GB write, 535.27 MB/s write, 12.09 GB read, 365.33 MB/s read, 68.1 seconds Interval compaction: 17.71 GB write, 538.73 MB/s write, 12.09 GB read, 367.69 MB/s read, 68.1 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: 17, pending-compaction-bytes-delays: 6, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 17, interval: 34 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2556985 Average: 2.6340 StdDev: 16.52 Min: 1 Median: 1.4128 Max: 4140 Percentiles: P50: 1.41 P75: 1.80 P99: 5.99 P99.9: 151.15 P99.99: 339.17 ------------------------------------------------------ [ 0, 1 ] 603708 23.610% 23.610% ##### ( 1, 2 ] 1634520 63.924% 87.534% ############# ( 2, 3 ] 188310 7.365% 94.898% # ( 3, 4 ] 68580 2.682% 97.580% # ( 4, 6 ] 36403 1.424% 99.004% ( 6, 10 ] 12949 0.506% 99.511% ( 10, 15 ] 2746 0.107% 99.618% ( 15, 22 ] 354 0.014% 99.632% ( 22, 34 ] 37 0.001% 99.633% ( 34, 51 ] 7 0.000% 99.634% ( 51, 76 ] 45 0.002% 99.635% ( 76, 110 ] 4079 0.160% 99.795% ( 110, 170 ] 3924 0.153% 99.948% ( 170, 250 ] 737 0.029% 99.977% ( 250, 380 ] 483 0.019% 99.996% ( 380, 580 ] 389 0.015% 100.011% ( 580, 870 ] 178 0.007% 100.018% ( 870, 1300 ] 47 0.002% 100.020% ( 1300, 1900 ] 17 0.001% 100.021% ( 1900, 2900 ] 17 0.001% 100.021% ( 2900, 4400 ] 12 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 572655 Average: 2.6127 StdDev: 18.09 Min: 1 Median: 1.4139 Max: 3946 Percentiles: P50: 1.41 P75: 1.81 P99: 6.98 P99.9: 151.32 P99.99: 843.68 ------------------------------------------------------ [ 0, 1 ] 137092 23.940% 23.940% ##### ( 1, 2 ] 360593 62.969% 86.908% ############# ( 2, 3 ] 43192 7.542% 94.451% ## ( 3, 4 ] 15203 2.655% 97.106% # ( 4, 6 ] 9868 1.723% 98.829% ( 6, 10 ] 4007 0.700% 99.529% ( 10, 15 ] 680 0.119% 99.647% ( 15, 22 ] 134 0.023% 99.671% ( 22, 34 ] 7 0.001% 99.672% ( 34, 51 ] 45 0.008% 99.680% ( 51, 76 ] 41 0.007% 99.687% ( 76, 110 ] 751 0.131% 99.818% ( 110, 170 ] 683 0.119% 99.937% ( 170, 250 ] 106 0.019% 99.956% ( 250, 380 ] 88 0.015% 99.971% ( 380, 580 ] 66 0.012% 99.983% ( 580, 870 ] 47 0.008% 99.991% ( 870, 1300 ] 30 0.005% 99.996% ( 1300, 1900 ] 18 0.003% 99.999% ( 1900, 2900 ] 3 0.001% 100.000% ( 2900, 4400 ] 2 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 15894 Average: 1.6917 StdDev: 6.00 Min: 1 Median: 1.0672 Max: 583 Percentiles: P50: 1.07 P75: 1.56 P99: 3.30 P99.9: 10.55 P99.99: 303.38 ------------------------------------------------------ [ 0, 1 ] 7410 46.621% 46.621% ######### ( 1, 2 ] 7986 50.245% 96.867% ########## ( 2, 3 ] 303 1.906% 98.773% ( 3, 4 ] 121 0.761% 99.534% ( 4, 6 ] 35 0.220% 99.755% ( 6, 10 ] 22 0.138% 99.893% ( 10, 15 ] 10 0.063% 99.956% ( 15, 22 ] 1 0.006% 99.962% ( 110, 170 ] 1 0.006% 99.969% ( 170, 250 ] 3 0.019% 99.987% ( 250, 380 ] 1 0.006% 99.994% ( 580, 870 ] 1 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 3192 Average: 34.4740 StdDev: 234.78 Min: 0 Median: 1.5620 Max: 4685 Percentiles: P50: 1.56 P75: 2.01 P99: 782.75 P99.9: 4034.67 P99.99: 4685.00 ------------------------------------------------------ [ 0, 1 ] 576 18.045% 18.045% #### ( 1, 2 ] 1815 56.861% 74.906% ########### ( 2, 3 ] 415 13.001% 87.907% ### ( 3, 4 ] 97 3.039% 90.946% # ( 4, 6 ] 79 2.475% 93.421% ( 6, 10 ] 44 1.378% 94.799% ( 10, 15 ] 3 0.094% 94.893% ( 15, 22 ] 4 0.125% 95.019% ( 51, 76 ] 1 0.031% 95.050% ( 76, 110 ] 8 0.251% 95.301% ( 110, 170 ] 32 1.003% 96.303% ( 170, 250 ] 24 0.752% 97.055% ( 250, 380 ] 16 0.501% 97.556% ( 380, 580 ] 30 0.940% 98.496% ( 580, 870 ] 23 0.721% 99.217% ( 870, 1300 ] 6 0.188% 99.405% ( 1300, 1900 ] 5 0.157% 99.561% ( 1900, 2900 ] 4 0.125% 99.687% ( 2900, 4400 ] 9 0.282% 99.969% ( 4400, 6600 ] 1 0.031% 100.000% ** Level 4 read latency histogram (micros): Count: 35 Average: 1840.5714 StdDev: 1343.54 Min: 274 Median: 1146.4286 Max: 5171 Percentiles: P50: 1146.43 P75: 3108.33 P99: 5171.00 P99.9: 5171.00 P99.99: 5171.00 ------------------------------------------------------ ( 250, 380 ] 2 5.714% 5.714% # ( 380, 580 ] 2 5.714% 11.429% # ( 580, 870 ] 9 25.714% 37.143% ##### ( 870, 1300 ] 7 20.000% 57.143% #### ( 1300, 1900 ] 2 5.714% 62.857% # ( 1900, 2900 ] 3 8.571% 71.429% ## ( 2900, 4400 ] 9 25.714% 97.143% ##### ( 4400, 6600 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 33.9 total, 18.7 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 174.27 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:17.270 H:M:S, 51.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 52.68 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:15.303 H:M:S, 81.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 0 2024/11/29-15:19:19 ... thread 0: (1000000,7000000) ops and (134554.5,170328.8) ops/second in (7.431934,41.096987) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/8 2.33 GB 56.6 6.2 0.0 6.2 12.7 6.6 0.0 1.9 141.6 292.9 44.48 40.27 114 0.390 6395K 12K 0.0 0.0 L1 10/10 1.08 GB 0.0 6.3 4.1 2.2 6.2 4.0 0.1 1.5 222.6 219.5 29.09 27.20 4 7.272 6573K 88K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 3.1 1.8 237.3 237.2 0.47 0.45 1 0.469 113K 34 0.0 0.0 L3 33/0 952.48 MB 1.0 4.5 3.1 1.4 4.5 3.1 0.0 1.4 133.9 133.8 34.32 20.63 23 1.492 4639K 1006 0.0 0.0 L4 143/0 9.76 GB 1.0 0.4 0.4 0.0 0.4 0.4 2.4 1.0 173.1 173.1 2.33 1.92 4 0.583 409K 0 0.0 0.0 L5 1076/0 88.52 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1272/18 102.62 GB 0.0 17.5 7.7 9.8 23.9 14.2 8.2 3.6 161.6 221.5 110.69 90.47 146 0.758 18M 101K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.5 7.7 9.8 23.9 14.2 8.2 3.6 161.6 221.5 110.69 90.47 146 0.758 18M 101K 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 17.5 7.7 9.8 17.4 7.6 0.0 0.0 198.0 196.9 90.31 73.44 51 1.771 18M 101K 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 330.9 20.37 17.03 95 0.214 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 41.3 total, 41.1 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 23.94 GB write, 593.45 MB/s write, 17.46 GB read, 432.80 MB/s read, 110.7 seconds Interval compaction: 23.94 GB write, 596.59 MB/s write, 17.46 GB read, 435.09 MB/s read, 110.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: 30, pending-compaction-bytes-delays: 15, pending-compaction-bytes-stops: 0, total-delays: 26, total-stops: 30, interval: 56 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3001146 Average: 2.8872 StdDev: 29.56 Min: 1 Median: 1.4661 Max: 10694 Percentiles: P50: 1.47 P75: 1.87 P99: 7.19 P99.9: 152.13 P99.99: 413.35 ------------------------------------------------------ [ 0, 1 ] 624072 20.794% 20.794% #### ( 1, 2 ] 1880548 62.661% 83.455% ############# ( 2, 3 ] 287781 9.589% 93.044% ## ( 3, 4 ] 101380 3.378% 96.423% # ( 4, 6 ] 70883 2.362% 98.784% ( 6, 10 ] 21836 0.728% 99.512% ( 10, 15 ] 4073 0.136% 99.648% ( 15, 22 ] 500 0.017% 99.664% ( 22, 34 ] 43 0.001% 99.666% ( 34, 51 ] 11 0.000% 99.666% ( 51, 76 ] 54 0.002% 99.668% ( 76, 110 ] 4135 0.138% 99.806% ( 110, 170 ] 4033 0.134% 99.940% ( 170, 250 ] 834 0.028% 99.968% ( 250, 380 ] 583 0.019% 99.987% ( 380, 580 ] 497 0.017% 100.004% ( 580, 870 ] 253 0.008% 100.012% ( 870, 1300 ] 99 0.003% 100.016% ( 1300, 1900 ] 50 0.002% 100.017% ( 1900, 2900 ] 79 0.003% 100.020% ( 2900, 4400 ] 67 0.002% 100.022% ( 4400, 6600 ] 10 0.000% 100.022% ( 6600, 9900 ] 2 0.000% 100.023% ( 9900, 14000 ] 2 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 1380202 Average: 6.0632 StdDev: 96.37 Min: 1 Median: 1.7045 Max: 8702 Percentiles: P50: 1.70 P75: 2.50 P99: 9.22 P99.9: 138.55 P99.99: 327.49 ------------------------------------------------------ [ 0, 1 ] 148760 10.778% 10.778% ## ( 1, 2 ] 768376 55.671% 66.449% ########### ( 2, 3 ] 236380 17.126% 83.576% ### ( 3, 4 ] 102948 7.459% 91.035% # ( 4, 6 ] 89507 6.485% 97.520% # ( 6, 10 ] 25368 1.838% 99.358% ( 10, 15 ] 5237 0.379% 99.737% ( 15, 22 ] 741 0.054% 99.791% ( 22, 34 ] 52 0.004% 99.795% ( 34, 51 ] 53 0.004% 99.799% ( 51, 76 ] 51 0.004% 99.802% ( 76, 110 ] 843 0.061% 99.863% ( 110, 170 ] 1063 0.077% 99.940% ( 170, 250 ] 437 0.032% 99.972% ( 250, 380 ] 416 0.030% 100.002% ( 380, 580 ] 436 0.032% 100.034% ( 580, 870 ] 406 0.029% 100.063% ( 870, 1300 ] 325 0.024% 100.087% ( 1300, 1900 ] 248 0.018% 100.105% ( 1900, 2900 ] 443 0.032% 100.137% ( 2900, 4400 ] 421 0.031% 100.167% ( 4400, 6600 ] 98 0.007% 100.174% ( 6600, 9900 ] 22 0.002% 100.176% ** Level 2 read latency histogram (micros): Count: 28277 Average: 2.8571 StdDev: 23.94 Min: 1 Median: 1.2874 Max: 1885 Percentiles: P50: 1.29 P75: 1.72 P99: 6.72 P99.9: 350.74 P99.99: 829.99 ------------------------------------------------------ [ 0, 1 ] 9490 33.561% 33.561% ####### ( 1, 2 ] 16176 57.206% 90.766% ########### ( 2, 3 ] 1407 4.976% 95.742% # ( 3, 4 ] 596 2.108% 97.850% ( 4, 6 ] 288 1.018% 98.868% ( 6, 10 ] 208 0.736% 99.604% ( 10, 15 ] 19 0.067% 99.671% ( 15, 22 ] 4 0.014% 99.685% ( 76, 110 ] 6 0.021% 99.706% ( 110, 170 ] 24 0.085% 99.791% ( 170, 250 ] 16 0.057% 99.848% ( 250, 380 ] 19 0.067% 99.915% ( 380, 580 ] 16 0.057% 99.972% ( 580, 870 ] 6 0.021% 99.993% ( 1300, 1900 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 455591 Average: 4.3468 StdDev: 55.12 Min: 0 Median: 1.8454 Max: 7782 Percentiles: P50: 1.85 P75: 2.77 P99: 8.64 P99.9: 105.03 P99.99: 237.42 ------------------------------------------------------ [ 0, 1 ] 16490 3.619% 3.619% # ( 1, 2 ] 249934 54.859% 58.479% ########### ( 2, 3 ] 97733 21.452% 79.931% #### ( 3, 4 ] 44298 9.723% 89.654% ## ( 4, 6 ] 37566 8.246% 97.899% ## ( 6, 10 ] 7587 1.665% 99.565% ( 10, 15 ] 1207 0.265% 99.830% ( 15, 22 ] 136 0.030% 99.860% ( 22, 34 ] 20 0.004% 99.864% ( 34, 51 ] 5 0.001% 99.865% ( 51, 76 ] 39 0.009% 99.874% ( 76, 110 ] 141 0.031% 99.905% ( 110, 170 ] 215 0.047% 99.952% ( 170, 250 ] 207 0.045% 99.997% ( 250, 380 ] 167 0.037% 100.034% ( 380, 580 ] 169 0.037% 100.071% ( 580, 870 ] 126 0.028% 100.099% ( 870, 1300 ] 54 0.012% 100.110% ( 1300, 1900 ] 36 0.008% 100.118% ( 1900, 2900 ] 33 0.007% 100.126% ( 2900, 4400 ] 49 0.011% 100.136% ( 4400, 6600 ] 7 0.002% 100.138% ( 6600, 9900 ] 2 0.000% 100.138% ** Level 4 read latency histogram (micros): Count: 85 Average: 847.7059 StdDev: 1231.56 Min: 1 Median: 230.0000 Max: 5171 Percentiles: P50: 230.00 P75: 1071.56 P99: 4730.00 P99.9: 5171.00 P99.99: 5171.00 ------------------------------------------------------ [ 0, 1 ] 5 5.882% 5.882% # ( 1, 2 ] 20 23.529% 29.412% ##### ( 2, 3 ] 4 4.706% 34.118% # ( 3, 4 ] 5 5.882% 40.000% # ( 6, 10 ] 1 1.176% 41.176% ( 10, 15 ] 1 1.176% 42.353% ( 15, 22 ] 2 2.353% 44.706% ( 170, 250 ] 6 7.059% 51.765% # ( 250, 380 ] 2 2.353% 54.118% ( 380, 580 ] 3 3.529% 57.647% # ( 580, 870 ] 11 12.941% 70.588% ### ( 870, 1300 ] 8 9.412% 80.000% ## ( 1300, 1900 ] 4 4.706% 84.706% # ( 1900, 2900 ] 3 3.529% 88.235% # ( 2900, 4400 ] 9 10.588% 98.824% ## ( 4400, 6600 ] 1 1.176% 100.000% ** Level 5 read latency histogram (micros): Count: 160 Average: 1717.5438 StdDev: 2080.76 Min: 78 Median: 812.0000 Max: 13683 Percentiles: P50: 812.00 P75: 2700.00 P99: 9405.00 P99.9: 13344.00 P99.99: 13683.00 ------------------------------------------------------ ( 76, 110 ] 11 6.875% 6.875% # ( 110, 170 ] 19 11.875% 18.750% ## ( 170, 250 ] 13 8.125% 26.875% ## ( 250, 380 ] 11 6.875% 33.750% # ( 380, 580 ] 14 8.750% 42.500% ## ( 580, 870 ] 15 9.375% 51.875% ## ( 870, 1300 ] 11 6.875% 58.750% # ( 1300, 1900 ] 10 6.250% 65.000% # ( 1900, 2900 ] 20 12.500% 77.500% ### ( 2900, 4400 ] 23 14.375% 91.875% ### ( 4400, 6600 ] 8 5.000% 96.875% # ( 6600, 9900 ] 4 2.500% 99.375% # ( 9900, 14000 ] 1 0.625% 100.000% ** DB Stats ** Uptime(secs): 41.3 total, 7.4 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 166.75 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:21.732 H:M:S, 52.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 132.43 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:4.462 H:M:S, 60.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/29-15:19:22 ... thread 0: (1000000,8000000) ops and (328774.4,181247.3) ops/second in (3.041599,44.138586) 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/8 3.31 GB 163.6 7.0 0.0 7.0 14.6 7.6 0.0 1.9 141.7 294.3 50.69 46.11 131 0.387 7290K 13K 0.0 0.0 L1 10/10 1.08 GB 0.0 6.3 4.1 2.2 6.2 4.0 0.1 1.5 222.6 219.5 29.09 27.20 4 7.272 6573K 88K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 3.1 1.8 237.3 237.2 0.47 0.45 1 0.469 113K 34 0.0 0.0 L3 33/0 952.48 MB 1.0 4.5 3.1 1.4 4.5 3.1 0.0 1.4 133.9 133.8 34.32 20.63 23 1.492 4639K 1006 0.0 0.0 L4 143/0 9.76 GB 1.0 0.4 0.4 0.0 0.4 0.4 2.4 1.0 173.1 173.1 2.33 1.92 4 0.583 409K 0 0.0 0.0 L5 1076/0 88.52 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1277/18 103.60 GB 0.0 18.3 7.7 10.6 25.8 15.2 8.2 3.4 160.5 225.9 116.90 96.31 163 0.717 19M 102K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.3 7.7 10.6 25.8 15.2 8.2 3.4 160.5 225.9 116.90 96.31 163 0.717 19M 102K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 18.3 7.7 10.6 18.2 7.6 0.0 0.0 200.3 199.2 93.67 76.74 54 1.735 19M 102K 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 333.6 23.23 19.58 109 0.213 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): 44.4 total, 44.1 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 25.79 GB write, 595.32 MB/s write, 18.32 GB read, 422.99 MB/s read, 116.9 seconds Interval compaction: 25.79 GB write, 598.25 MB/s write, 18.32 GB read, 425.08 MB/s read, 116.9 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: 33, pending-compaction-bytes-delays: 15, pending-compaction-bytes-stops: 0, total-delays: 26, total-stops: 33, interval: 59 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3276887 Average: 2.8344 StdDev: 28.50 Min: 1 Median: 1.4724 Max: 10694 Percentiles: P50: 1.47 P75: 1.87 P99: 6.93 P99.9: 147.44 P99.99: 380.12 ------------------------------------------------------ [ 0, 1 ] 662698 20.223% 20.223% #### ( 1, 2 ] 2065374 63.029% 83.252% ############# ( 2, 3 ] 321393 9.808% 93.060% ## ( 3, 4 ] 111824 3.413% 96.472% # ( 4, 6 ] 77417 2.363% 98.835% ( 6, 10 ] 23282 0.710% 99.545% ( 10, 15 ] 4325 0.132% 99.677% ( 15, 22 ] 526 0.016% 99.693% ( 22, 34 ] 47 0.001% 99.695% ( 34, 51 ] 13 0.000% 99.695% ( 51, 76 ] 55 0.002% 99.697% ( 76, 110 ] 4136 0.126% 99.823% ( 110, 170 ] 4040 0.123% 99.946% ( 170, 250 ] 839 0.026% 99.972% ( 250, 380 ] 591 0.018% 99.990% ( 380, 580 ] 498 0.015% 100.005% ( 580, 870 ] 255 0.008% 100.013% ( 870, 1300 ] 106 0.003% 100.016% ( 1300, 1900 ] 52 0.002% 100.018% ( 1900, 2900 ] 80 0.002% 100.020% ( 2900, 4400 ] 68 0.002% 100.022% ( 4400, 6600 ] 10 0.000% 100.023% ( 6600, 9900 ] 2 0.000% 100.023% ( 9900, 14000 ] 2 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 1512660 Average: 5.7633 StdDev: 92.11 Min: 1 Median: 1.6906 Max: 8702 Percentiles: P50: 1.69 P75: 2.44 P99: 9.15 P99.9: 138.81 P99.99: 332.94 ------------------------------------------------------ [ 0, 1 ] 163702 10.822% 10.822% ## ( 1, 2 ] 858092 56.727% 67.549% ########### ( 2, 3 ] 254132 16.800% 84.350% ### ( 3, 4 ] 107366 7.098% 91.448% # ( 4, 6 ] 92675 6.127% 97.574% # ( 6, 10 ] 27406 1.812% 99.386% ( 10, 15 ] 5335 0.353% 99.739% ( 15, 22 ] 758 0.050% 99.789% ( 22, 34 ] 56 0.004% 99.793% ( 34, 51 ] 53 0.004% 99.796% ( 51, 76 ] 65 0.004% 99.800% ( 76, 110 ] 946 0.063% 99.863% ( 110, 170 ] 1169 0.077% 99.940% ( 170, 250 ] 473 0.031% 99.971% ( 250, 380 ] 440 0.029% 100.001% ( 380, 580 ] 453 0.030% 100.030% ( 580, 870 ] 411 0.027% 100.058% ( 870, 1300 ] 325 0.021% 100.079% ( 1300, 1900 ] 248 0.016% 100.096% ( 1900, 2900 ] 443 0.029% 100.125% ( 2900, 4400 ] 421 0.028% 100.153% ( 4400, 6600 ] 98 0.006% 100.159% ( 6600, 9900 ] 22 0.001% 100.161% ** Level 2 read latency histogram (micros): Count: 28277 Average: 2.8571 StdDev: 23.94 Min: 1 Median: 1.2874 Max: 1885 Percentiles: P50: 1.29 P75: 1.72 P99: 6.72 P99.9: 350.74 P99.99: 829.99 ------------------------------------------------------ [ 0, 1 ] 9490 33.561% 33.561% ####### ( 1, 2 ] 16176 57.206% 90.766% ########### ( 2, 3 ] 1407 4.976% 95.742% # ( 3, 4 ] 596 2.108% 97.850% ( 4, 6 ] 288 1.018% 98.868% ( 6, 10 ] 208 0.736% 99.604% ( 10, 15 ] 19 0.067% 99.671% ( 15, 22 ] 4 0.014% 99.685% ( 76, 110 ] 6 0.021% 99.706% ( 110, 170 ] 24 0.085% 99.791% ( 170, 250 ] 16 0.057% 99.848% ( 250, 380 ] 19 0.067% 99.915% ( 380, 580 ] 16 0.057% 99.972% ( 580, 870 ] 6 0.021% 99.993% ( 1300, 1900 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 455591 Average: 4.3468 StdDev: 55.12 Min: 0 Median: 1.8454 Max: 7782 Percentiles: P50: 1.85 P75: 2.77 P99: 8.64 P99.9: 105.03 P99.99: 237.42 ------------------------------------------------------ [ 0, 1 ] 16490 3.619% 3.619% # ( 1, 2 ] 249934 54.859% 58.479% ########### ( 2, 3 ] 97733 21.452% 79.931% #### ( 3, 4 ] 44298 9.723% 89.654% ## ( 4, 6 ] 37566 8.246% 97.899% ## ( 6, 10 ] 7587 1.665% 99.565% ( 10, 15 ] 1207 0.265% 99.830% ( 15, 22 ] 136 0.030% 99.860% ( 22, 34 ] 20 0.004% 99.864% ( 34, 51 ] 5 0.001% 99.865% ( 51, 76 ] 39 0.009% 99.874% ( 76, 110 ] 141 0.031% 99.905% ( 110, 170 ] 215 0.047% 99.952% ( 170, 250 ] 207 0.045% 99.997% ( 250, 380 ] 167 0.037% 100.034% ( 380, 580 ] 169 0.037% 100.071% ( 580, 870 ] 126 0.028% 100.099% ( 870, 1300 ] 54 0.012% 100.110% ( 1300, 1900 ] 36 0.008% 100.118% ( 1900, 2900 ] 33 0.007% 100.126% ( 2900, 4400 ] 49 0.011% 100.136% ( 4400, 6600 ] 7 0.002% 100.138% ( 6600, 9900 ] 2 0.000% 100.138% ** Level 4 read latency histogram (micros): Count: 85 Average: 847.7059 StdDev: 1231.56 Min: 1 Median: 230.0000 Max: 5171 Percentiles: P50: 230.00 P75: 1071.56 P99: 4730.00 P99.9: 5171.00 P99.99: 5171.00 ------------------------------------------------------ [ 0, 1 ] 5 5.882% 5.882% # ( 1, 2 ] 20 23.529% 29.412% ##### ( 2, 3 ] 4 4.706% 34.118% # ( 3, 4 ] 5 5.882% 40.000% # ( 6, 10 ] 1 1.176% 41.176% ( 10, 15 ] 1 1.176% 42.353% ( 15, 22 ] 2 2.353% 44.706% ( 170, 250 ] 6 7.059% 51.765% # ( 250, 380 ] 2 2.353% 54.118% ( 380, 580 ] 3 3.529% 57.647% # ( 580, 870 ] 11 12.941% 70.588% ### ( 870, 1300 ] 8 9.412% 80.000% ## ( 1300, 1900 ] 4 4.706% 84.706% # ( 1900, 2900 ] 3 3.529% 88.235% # ( 2900, 4400 ] 9 10.588% 98.824% ## ( 4400, 6600 ] 1 1.176% 100.000% ** Level 5 read latency histogram (micros): Count: 160 Average: 1717.5438 StdDev: 2080.76 Min: 78 Median: 812.0000 Max: 13683 Percentiles: P50: 812.00 P75: 2700.00 P99: 9405.00 P99.9: 13344.00 P99.99: 13683.00 ------------------------------------------------------ ( 76, 110 ] 11 6.875% 6.875% # ( 110, 170 ] 19 11.875% 18.750% ## ( 170, 250 ] 13 8.125% 26.875% ## ( 250, 380 ] 11 6.875% 33.750% # ( 380, 580 ] 14 8.750% 42.500% ## ( 580, 870 ] 15 9.375% 51.875% ## ( 870, 1300 ] 11 6.875% 58.750% # ( 1300, 1900 ] 10 6.250% 65.000% # ( 1900, 2900 ] 20 12.500% 77.500% ### ( 2900, 4400 ] 23 14.375% 91.875% ### ( 4400, 6600 ] 8 5.000% 96.875% # ( 6600, 9900 ] 4 2.500% 99.375% # ( 9900, 14000 ] 1 0.625% 100.000% ** DB Stats ** Uptime(secs): 44.4 total, 3.0 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 177.49 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:22.125 H:M:S, 49.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 323.39 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.393 H:M:S, 12.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/29-15:19:25 ... thread 0: (1000000,9000000) ops and (305981.4,189846.4) ops/second in (3.268172,47.406758) 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/4 2.77 GB 258.0 7.8 0.0 7.8 16.3 8.5 0.0 1.9 141.2 295.5 56.65 51.69 149 0.380 8122K 14K 0.0 0.0 L1 32/0 2.34 GB 240.0 8.9 5.6 3.3 8.8 5.5 0.1 1.6 214.1 211.5 42.41 38.44 5 8.482 8100K 88K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 3.2 1.8 237.3 237.2 0.47 0.45 1 0.469 113K 34 0.0 0.0 L3 21/0 856.93 MB 0.9 4.5 3.1 1.4 4.5 3.1 0.2 1.4 133.9 133.8 34.32 20.63 23 1.492 4639K 1006 0.0 0.0 L4 155/0 9.67 GB 1.0 0.4 0.4 0.0 0.4 0.4 2.7 1.0 173.1 173.1 2.33 1.92 4 0.583 409K 0 0.0 0.0 L5 1080/0 88.89 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1304/4 104.50 GB 0.0 21.7 9.2 12.5 30.1 17.6 9.3 3.5 162.9 226.3 136.18 113.14 182 0.748 21M 103K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.7 9.2 12.5 30.1 17.6 9.2 3.5 162.9 226.3 136.18 113.14 182 0.748 21M 103K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 21.7 9.2 12.5 21.5 9.0 0.0 0.0 201.5 200.4 110.11 91.03 58 1.898 21M 103K 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 335.9 26.07 22.11 124 0.210 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 47.6 total, 47.4 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: 30.10 GB write, 647.11 MB/s write, 21.67 GB read, 465.87 MB/s read, 136.2 seconds Interval compaction: 30.10 GB write, 650.08 MB/s write, 21.67 GB read, 468.01 MB/s read, 136.2 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: 35, pending-compaction-bytes-delays: 16, pending-compaction-bytes-stops: 0, total-delays: 30, total-stops: 35, interval: 65 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3574237 Average: 2.7881 StdDev: 27.42 Min: 1 Median: 1.4739 Max: 10694 Percentiles: P50: 1.47 P75: 1.87 P99: 6.69 P99.9: 143.72 P99.99: 361.82 ------------------------------------------------------ [ 0, 1 ] 715343 20.014% 20.014% #### ( 1, 2 ] 2261401 63.269% 83.283% ############# ( 2, 3 ] 352381 9.859% 93.142% ## ( 3, 4 ] 122068 3.415% 96.557% # ( 4, 6 ] 83039 2.323% 98.881% ( 6, 10 ] 24705 0.691% 99.572% ( 10, 15 ] 4563 0.128% 99.700% ( 15, 22 ] 551 0.015% 99.715% ( 22, 34 ] 54 0.002% 99.717% ( 34, 51 ] 13 0.000% 99.717% ( 51, 76 ] 57 0.002% 99.718% ( 76, 110 ] 4174 0.117% 99.835% ( 110, 170 ] 4119 0.115% 99.951% ( 170, 250 ] 887 0.025% 99.975% ( 250, 380 ] 611 0.017% 99.992% ( 380, 580 ] 519 0.015% 100.007% ( 580, 870 ] 266 0.007% 100.014% ( 870, 1300 ] 109 0.003% 100.017% ( 1300, 1900 ] 55 0.002% 100.019% ( 1900, 2900 ] 80 0.002% 100.021% ( 2900, 4400 ] 68 0.002% 100.023% ( 4400, 6600 ] 10 0.000% 100.023% ( 6600, 9900 ] 2 0.000% 100.023% ( 9900, 14000 ] 2 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 1628932 Average: 5.5862 StdDev: 89.27 Min: 1 Median: 1.6820 Max: 8702 Percentiles: P50: 1.68 P75: 2.40 P99: 9.12 P99.9: 143.50 P99.99: 353.21 ------------------------------------------------------ [ 0, 1 ] 174649 10.722% 10.722% ## ( 1, 2 ] 938198 57.596% 68.318% ############ ( 2, 3 ] 270044 16.578% 84.896% ### ( 3, 4 ] 111520 6.846% 91.742% # ( 4, 6 ] 95435 5.859% 97.601% # ( 6, 10 ] 29243 1.795% 99.396% ( 10, 15 ] 5460 0.335% 99.731% ( 15, 22 ] 769 0.047% 99.778% ( 22, 34 ] 57 0.003% 99.782% ( 34, 51 ] 54 0.003% 99.785% ( 51, 76 ] 92 0.006% 99.791% ( 76, 110 ] 1050 0.064% 99.855% ( 110, 170 ] 1311 0.080% 99.936% ( 170, 250 ] 510 0.031% 99.967% ( 250, 380 ] 475 0.029% 99.996% ( 380, 580 ] 480 0.029% 100.025% ( 580, 870 ] 430 0.026% 100.052% ( 870, 1300 ] 343 0.021% 100.073% ( 1300, 1900 ] 255 0.016% 100.089% ( 1900, 2900 ] 443 0.027% 100.116% ( 2900, 4400 ] 422 0.026% 100.142% ( 4400, 6600 ] 98 0.006% 100.148% ( 6600, 9900 ] 23 0.001% 100.149% ** Level 2 read latency histogram (micros): Count: 28277 Average: 2.8571 StdDev: 23.94 Min: 1 Median: 1.2874 Max: 1885 Percentiles: P50: 1.29 P75: 1.72 P99: 6.72 P99.9: 350.74 P99.99: 829.99 ------------------------------------------------------ [ 0, 1 ] 9490 33.561% 33.561% ####### ( 1, 2 ] 16176 57.206% 90.766% ########### ( 2, 3 ] 1407 4.976% 95.742% # ( 3, 4 ] 596 2.108% 97.850% ( 4, 6 ] 288 1.018% 98.868% ( 6, 10 ] 208 0.736% 99.604% ( 10, 15 ] 19 0.067% 99.671% ( 15, 22 ] 4 0.014% 99.685% ( 76, 110 ] 6 0.021% 99.706% ( 110, 170 ] 24 0.085% 99.791% ( 170, 250 ] 16 0.057% 99.848% ( 250, 380 ] 19 0.067% 99.915% ( 380, 580 ] 16 0.057% 99.972% ( 580, 870 ] 6 0.021% 99.993% ( 1300, 1900 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 455591 Average: 4.3468 StdDev: 55.12 Min: 0 Median: 1.8454 Max: 7782 Percentiles: P50: 1.85 P75: 2.77 P99: 8.64 P99.9: 105.03 P99.99: 237.42 ------------------------------------------------------ [ 0, 1 ] 16490 3.619% 3.619% # ( 1, 2 ] 249934 54.859% 58.479% ########### ( 2, 3 ] 97733 21.452% 79.931% #### ( 3, 4 ] 44298 9.723% 89.654% ## ( 4, 6 ] 37566 8.246% 97.899% ## ( 6, 10 ] 7587 1.665% 99.565% ( 10, 15 ] 1207 0.265% 99.830% ( 15, 22 ] 136 0.030% 99.860% ( 22, 34 ] 20 0.004% 99.864% ( 34, 51 ] 5 0.001% 99.865% ( 51, 76 ] 39 0.009% 99.874% ( 76, 110 ] 141 0.031% 99.905% ( 110, 170 ] 215 0.047% 99.952% ( 170, 250 ] 207 0.045% 99.997% ( 250, 380 ] 167 0.037% 100.034% ( 380, 580 ] 169 0.037% 100.071% ( 580, 870 ] 126 0.028% 100.099% ( 870, 1300 ] 54 0.012% 100.110% ( 1300, 1900 ] 36 0.008% 100.118% ( 1900, 2900 ] 33 0.007% 100.126% ( 2900, 4400 ] 49 0.011% 100.136% ( 4400, 6600 ] 7 0.002% 100.138% ( 6600, 9900 ] 2 0.000% 100.138% ** Level 4 read latency histogram (micros): Count: 85 Average: 847.7059 StdDev: 1231.56 Min: 1 Median: 230.0000 Max: 5171 Percentiles: P50: 230.00 P75: 1071.56 P99: 4730.00 P99.9: 5171.00 P99.99: 5171.00 ------------------------------------------------------ [ 0, 1 ] 5 5.882% 5.882% # ( 1, 2 ] 20 23.529% 29.412% ##### ( 2, 3 ] 4 4.706% 34.118% # ( 3, 4 ] 5 5.882% 40.000% # ( 6, 10 ] 1 1.176% 41.176% ( 10, 15 ] 1 1.176% 42.353% ( 15, 22 ] 2 2.353% 44.706% ( 170, 250 ] 6 7.059% 51.765% # ( 250, 380 ] 2 2.353% 54.118% ( 380, 580 ] 3 3.529% 57.647% # ( 580, 870 ] 11 12.941% 70.588% ### ( 870, 1300 ] 8 9.412% 80.000% ## ( 1300, 1900 ] 4 4.706% 84.706% # ( 1900, 2900 ] 3 3.529% 88.235% # ( 2900, 4400 ] 9 10.588% 98.824% ## ( 4400, 6600 ] 1 1.176% 100.000% ** Level 5 read latency histogram (micros): Count: 180 Average: 1652.3667 StdDev: 2021.63 Min: 78 Median: 761.2500 Max: 13683 Percentiles: P50: 761.25 P75: 2595.65 P99: 9240.00 P99.9: 13262.00 P99.99: 13683.00 ------------------------------------------------------ ( 76, 110 ] 12 6.667% 6.667% # ( 110, 170 ] 23 12.778% 19.444% ### ( 170, 250 ] 16 8.889% 28.333% ## ( 250, 380 ] 13 7.222% 35.556% # ( 380, 580 ] 16 8.889% 44.444% ## ( 580, 870 ] 16 8.889% 53.333% ## ( 870, 1300 ] 11 6.111% 59.444% # ( 1300, 1900 ] 12 6.667% 66.111% # ( 1900, 2900 ] 23 12.778% 78.889% ### ( 2900, 4400 ] 24 13.333% 92.222% ### ( 4400, 6600 ] 9 5.000% 97.222% # ( 6600, 9900 ] 4 2.222% 99.444% ( 9900, 14000 ] 1 0.556% 100.000% ** DB Stats ** Uptime(secs): 47.6 total, 3.3 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 185.98 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.717 H:M:S, 47.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 301.31 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.592 H:M:S, 18.1 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 : 6.527 micros/op 153203 ops/sec 60.201 seconds 9222999 operations; 148.4 MB/s Microseconds per write: Count: 9222999 Average: 6.5272 StdDev: 379.14 Min: 0 Median: 1.7370 Max: 828660 Percentiles: P50: 1.74 P75: 2.76 P99: 9.71 P99.9: 1220.47 P99.99: 2762.97 ------------------------------------------------------ [ 0, 1 ] 1252866 13.584% 13.584% ### ( 1, 2 ] 4557140 49.411% 62.995% ########## ( 2, 3 ] 1447480 15.694% 78.689% ### ( 3, 4 ] 1261936 13.682% 92.371% ### ( 4, 6 ] 498402 5.404% 97.775% # ( 6, 10 ] 121647 1.319% 99.094% ( 10, 15 ] 40392 0.438% 99.532% ( 15, 22 ] 9076 0.098% 99.631% ( 22, 34 ] 1557 0.017% 99.648% ( 34, 51 ] 180 0.002% 99.650% ( 51, 76 ] 17 0.000% 99.650% ( 76, 110 ] 6473 0.070% 99.720% ( 110, 170 ] 2413 0.026% 99.746% ( 170, 250 ] 284 0.003% 99.749% ( 250, 380 ] 176 0.002% 99.751% ( 380, 580 ] 24 0.000% 99.751% ( 580, 870 ] 13 0.000% 99.751% ( 870, 1300 ] 16809 0.182% 99.934% ( 1300, 1900 ] 51 0.001% 99.934% ( 1900, 2900 ] 5957 0.065% 99.999% ( 2900, 4400 ] 68 0.001% 100.000% ( 4400, 6600 ] 12 0.000% 100.000% ( 6600, 9900 ] 6 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 33000, 50000 ] 2 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 14 0.000% 100.000% ( 570000, 860000 ] 1 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 : 174371 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 : 9222999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 9518134968 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 : 464 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 34656543 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 : 26831123819 rocksdb.compact.write.bytes COUNT : 26663155965 rocksdb.flush.write.bytes COUNT : 9512246907 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 : 47 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 : 280 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 : 9435604992 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3727360 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 : 26915319731 rocksdb.non.last.level.read.count COUNT : 6502712 rocksdb.block.checksum.compute.count COUNT : 6501831 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.374774 P95 : 3.945108 P99 : 8.432867 P100 : 828657.000000 COUNT : 9222999 SUM : 55803790 rocksdb.compaction.times.micros P50 : 1120312.500000 P95 : 5345000.000000 P99 : 17120000.000000 P100 : 19829848.000000 COUNT : 61 SUM : 112910686 rocksdb.compaction.times.cpu_micros P50 : 981428.571429 P95 : 5345000.000000 P99 : 17120000.000000 P100 : 18266147.000000 COUNT : 61 SUM : 93778746 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 : 697.705882 P95 : 1165.136364 P99 : 99850.000000 P100 : 344623.000000 COUNT : 129 SUM : 529159 rocksdb.compaction.outfile.sync.micros P50 : 844.682540 P95 : 156222.222222 P99 : 208690.000000 P100 : 208690.000000 COUNT : 304 SUM : 7011056 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 : 92.540541 P95 : 791.285714 P99 : 1864.000000 P100 : 6187.000000 COUNT : 218 SUM : 45693 rocksdb.table.open.io.micros P50 : 1457.377049 P95 : 8820.000000 P99 : 14960.000000 P100 : 22955.000000 COUNT : 464 SUM : 1052542 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.528744 P95 : 6.942852 P99 : 10.217363 P100 : 12038.000000 COUNT : 6500636 SUM : 36082913 rocksdb.read.block.get.micros P50 : 457.419355 P95 : 3638.888889 P99 : 6044.923077 P100 : 13727.000000 COUNT : 928 SUM : 844396 rocksdb.write.raw.block.micros P50 : 0.512261 P95 : 0.973295 P99 : 2.801942 P100 : 20415.000000 COUNT : 8761562 SUM : 16475126 rocksdb.numfiles.in.singlecompaction P50 : 3.448529 P95 : 7.500000 P99 : 33.400000 P100 : 40.000000 COUNT : 105 SUM : 462 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.561886 P95 : 1188.466433 P99 : 2563.170281 P100 : 828473.000000 COUNT : 208480 SUM : 34677821 rocksdb.sst.read.micros P50 : 1.511097 P95 : 3.989220 P99 : 8.006577 P100 : 13683.000000 COUNT : 6503075 SUM : 23104679 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 : 9222999 SUM : 9518134968 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 : 210425.531915 P95 : 357250.000000 P99 : 551633.333333 P100 : 991814.000000 COUNT : 129 SUM : 26935078 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 : 293 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