[2024-12-17 07:55:33.341367] Starting SPDK v24.09.1-pre git sha1 b18e1bd62 / DPDK 22.11.4 initialization... [2024-12-17 07:55:33.341510] [ 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_pid3266424 ] Set seed to 1734418533337868 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-17 07:55:33.429279] app.c: 917:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-17 07:55:33.471102] app.c: 610:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-17 07:55:33.471151] app.c: 611:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 3266424' to capture a snapshot of events at runtime. [2024-12-17 07:55:33.471161] app.c: 616:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-17 07:55:33.471187] app.c: 617:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-17 07:55:33.471195] app.c: 618:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid3266424 for offline analysis/debug. [2024-12-17 07:55:33.471285] reactor.c: 990:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Tue Dec 17 07:55:37 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/17-07:55:40 ... thread 0: (1000000,1000000) ops and (331568.5,331568.5) ops/second in (3.015968,3.015968) 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 566.95 MB 25.2 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 347.4 2.54 2.30 12 0.212 0 0 0.0 0.0 L1 3/3 251.73 MB 0.0 0.2 0.2 0.1 0.2 0.2 0.1 1.3 252.8 252.6 1.00 0.96 1 0.997 255K 219 0.0 0.0 L2 1/0 48.85 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 236.9 236.9 0.47 0.44 1 0.470 113K 24 0.0 0.0 L3 18/0 881.40 MB 0.9 0.1 0.1 0.0 0.1 0.1 0.0 1.0 209.7 209.8 0.30 0.25 1 0.298 63K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.75 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 1190/8 97.00 GB 0.0 0.4 0.3 0.1 1.3 1.2 0.2 1.5 98.9 303.8 4.30 3.95 15 0.287 432K 243 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.3 1.2 0.1 1.5 98.9 303.8 4.30 3.95 15 0.287 432K 243 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 241.3 241.2 1.76 1.65 3 0.588 432K 243 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 347.4 2.54 2.30 12 0.212 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.2 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.28 GB write, 408.80 MB/s write, 0.42 GB read, 133.14 MB/s read, 4.3 seconds Interval compaction: 1.28 GB write, 433.32 MB/s write, 0.42 GB read, 141.12 MB/s read, 4.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 106186 Average: 1.7560 StdDev: 15.54 Min: 1 Median: 1.1047 Max: 3350 Percentiles: P50: 1.10 P75: 1.58 P99: 3.31 P99.9: 8.73 P99.99: 327.40 ------------------------------------------------------ [ 0, 1 ] 47275 44.521% 44.521% ######### ( 1, 2 ] 55549 52.313% 96.834% ########## ( 2, 3 ] 2069 1.948% 98.782% ( 3, 4 ] 758 0.714% 99.496% ( 4, 6 ] 316 0.298% 99.794% ( 6, 10 ] 167 0.157% 99.951% ( 10, 15 ] 20 0.019% 99.970% ( 15, 22 ] 8 0.008% 99.977% ( 51, 76 ] 1 0.001% 99.978% ( 110, 170 ] 8 0.008% 99.986% ( 170, 250 ] 3 0.003% 99.989% ( 250, 380 ] 4 0.004% 99.992% ( 380, 580 ] 2 0.002% 99.994% ( 580, 870 ] 2 0.002% 99.996% ( 870, 1300 ] 1 0.001% 99.997% ( 1300, 1900 ] 1 0.001% 99.998% ( 1900, 2900 ] 2 0.002% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 1 read latency histogram (micros): Count: 33238 Average: 2.2294 StdDev: 28.61 Min: 1 Median: 1.1721 Max: 3688 Percentiles: P50: 1.17 P75: 1.63 P99: 5.05 P99.9: 57.72 P99.99: 1502.86 ------------------------------------------------------ [ 0, 1 ] 13527 40.697% 40.697% ######## ( 1, 2 ] 17968 54.059% 94.756% ########### ( 2, 3 ] 1010 3.039% 97.795% # ( 3, 4 ] 300 0.903% 98.697% ( 4, 6 ] 192 0.578% 99.275% ( 6, 10 ] 125 0.376% 99.651% ( 10, 15 ] 26 0.078% 99.729% ( 15, 22 ] 13 0.039% 99.768% ( 22, 34 ] 1 0.003% 99.771% ( 34, 51 ] 39 0.117% 99.889% ( 51, 76 ] 14 0.042% 99.931% ( 76, 110 ] 2 0.006% 99.937% ( 110, 170 ] 1 0.003% 99.940% ( 170, 250 ] 8 0.024% 99.964% ( 250, 380 ] 3 0.009% 99.973% ( 380, 580 ] 3 0.009% 99.982% ( 580, 870 ] 1 0.003% 99.985% ( 870, 1300 ] 1 0.003% 99.988% ( 1300, 1900 ] 2 0.006% 99.994% ( 1900, 2900 ] 1 0.003% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 15873 Average: 1.7334 StdDev: 3.29 Min: 1 Median: 1.1862 Max: 243 Percentiles: P50: 1.19 P75: 1.64 P99: 3.52 P99.9: 9.13 P99.99: 207.67 ------------------------------------------------------ [ 0, 1 ] 6302 39.703% 39.703% ######## ( 1, 2 ] 8778 55.301% 95.004% ########### ( 2, 3 ] 558 3.515% 98.519% # ( 3, 4 ] 148 0.932% 99.452% ( 4, 6 ] 50 0.315% 99.767% ( 6, 10 ] 27 0.170% 99.937% ( 10, 15 ] 3 0.019% 99.956% ( 15, 22 ] 2 0.013% 99.968% ( 51, 76 ] 1 0.006% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 3 0.019% 100.000% ** Level 3 read latency histogram (micros): Count: 90 Average: 858.0333 StdDev: 1302.15 Min: 1 Median: 396.6667 Max: 5327 Percentiles: P50: 396.67 P75: 836.54 P99: 5327.00 P99.9: 5327.00 P99.99: 5327.00 ------------------------------------------------------ [ 0, 1 ] 24 26.667% 26.667% ##### ( 1, 2 ] 13 14.444% 41.111% ### ( 2, 3 ] 1 1.111% 42.222% ( 110, 170 ] 2 2.222% 44.444% ( 170, 250 ] 3 3.333% 47.778% # ( 250, 380 ] 1 1.111% 48.889% ( 380, 580 ] 12 13.333% 62.222% ### ( 580, 870 ] 13 14.444% 76.667% ### ( 870, 1300 ] 3 3.333% 80.000% # ( 1300, 1900 ] 3 3.333% 83.333% # ( 1900, 2900 ] 5 5.556% 88.889% # ( 2900, 4400 ] 7 7.778% 96.667% ## ( 4400, 6600 ] 3 3.333% 100.000% # ** Level 4 read latency histogram (micros): Count: 25 Average: 1804.2400 StdDev: 1404.78 Min: 382 Median: 1400.0000 Max: 5924 Percentiles: P50: 1400.00 P75: 2837.50 P99: 5924.00 P99.9: 5924.00 P99.99: 5924.00 ------------------------------------------------------ ( 380, 580 ] 5 20.000% 20.000% #### ( 580, 870 ] 5 20.000% 40.000% #### ( 870, 1300 ] 2 8.000% 48.000% ## ( 1300, 1900 ] 3 12.000% 60.000% ## ( 1900, 2900 ] 4 16.000% 76.000% ### ( 2900, 4400 ] 5 20.000% 96.000% #### ( 4400, 6600 ] 1 4.000% 100.000% # ** DB Stats ** Uptime(secs): 3.2 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 307.69 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.385 H:M:S, 12.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 326.06 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.385 H:M:S, 12.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/17-07:55:43 ... thread 0: (1000000,2000000) ops and (318579.9,324944.5) ops/second in (3.138930,6.154898) 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 74.4 322.3 7.62 7.00 28 0.272 575K 606 0.0 0.0 L1 2/2 50.41 MB 0.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 244.4 244.0 3.35 3.26 2 1.675 831K 1399 0.0 0.0 L2 5/4 563.92 MB 1.3 0.1 0.1 0.0 0.1 0.1 0.6 1.8 236.9 236.9 0.47 0.44 1 0.470 113K 24 0.0 0.0 L3 18/11 881.40 MB 0.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 209.7 209.8 0.30 0.25 1 0.298 63K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.75 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 1196/26 97.98 GB 0.0 1.5 0.6 0.9 3.4 2.5 0.7 1.8 132.8 293.6 11.74 10.95 32 0.367 1583K 2029 0.0 0.0 Int 0/0 0.00 KB 0.0 1.5 0.6 0.9 3.4 2.5 0.6 1.8 132.8 293.6 11.74 10.95 32 0.367 1583K 2029 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 250.0 249.6 6.24 6.03 6 1.040 1583K 2029 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 343.6 5.50 4.92 26 0.212 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.3 total, 6.2 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, 543.96 MB/s write, 1.52 GB read, 246.08 MB/s read, 11.7 seconds Interval compaction: 3.37 GB write, 559.95 MB/s write, 1.52 GB read, 253.32 MB/s read, 11.7 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: 421426 Average: 2.1892 StdDev: 11.80 Min: 1 Median: 1.4762 Max: 3350 Percentiles: P50: 1.48 P75: 1.88 P99: 5.70 P99.9: 9.91 P99.99: 14.54 ------------------------------------------------------ [ 0, 1 ] 86636 20.558% 20.558% #### ( 1, 2 ] 260532 61.822% 82.379% ############ ( 2, 3 ] 44819 10.635% 93.014% ## ( 3, 4 ] 15815 3.753% 96.767% # ( 4, 6 ] 11073 2.628% 99.395% # ( 6, 10 ] 2180 0.517% 99.912% ( 10, 15 ] 364 0.086% 99.998% ( 15, 22 ] 55 0.013% 100.011% ( 22, 34 ] 2 0.000% 100.012% ( 34, 51 ] 1 0.000% 100.012% ( 51, 76 ] 6 0.001% 100.014% ( 110, 170 ] 14 0.003% 100.017% ( 170, 250 ] 8 0.002% 100.019% ( 250, 380 ] 8 0.002% 100.021% ( 380, 580 ] 5 0.001% 100.022% ( 580, 870 ] 9 0.002% 100.024% ( 870, 1300 ] 5 0.001% 100.025% ( 1300, 1900 ] 1 0.000% 100.025% ( 1900, 2900 ] 4 0.001% 100.026% ( 2900, 4400 ] 2 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 140260 Average: 2.4047 StdDev: 16.08 Min: 1 Median: 1.5471 Max: 3688 Percentiles: P50: 1.55 P75: 1.95 P99: 5.93 P99.9: 14.45 P99.99: 379.52 ------------------------------------------------------ [ 0, 1 ] 22847 16.289% 16.289% ### ( 1, 2 ] 86432 61.623% 77.912% ############ ( 2, 3 ] 18947 13.508% 91.420% ### ( 3, 4 ] 5887 4.197% 95.617% # ( 4, 6 ] 4905 3.497% 99.115% # ( 6, 10 ] 931 0.664% 99.778% ( 10, 15 ] 193 0.138% 99.916% ( 15, 22 ] 27 0.019% 99.935% ( 22, 34 ] 4 0.003% 99.938% ( 34, 51 ] 40 0.029% 99.966% ( 51, 76 ] 15 0.011% 99.977% ( 76, 110 ] 2 0.001% 99.979% ( 110, 170 ] 2 0.001% 99.980% ( 170, 250 ] 8 0.006% 99.986% ( 250, 380 ] 7 0.005% 99.991% ( 380, 580 ] 4 0.003% 99.994% ( 580, 870 ] 2 0.001% 99.995% ( 870, 1300 ] 2 0.001% 99.996% ( 1300, 1900 ] 3 0.002% 99.999% ( 1900, 2900 ] 2 0.001% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 2 read latency histogram (micros): Count: 15929 Average: 1.7378 StdDev: 3.29 Min: 1 Median: 1.1889 Max: 243 Percentiles: P50: 1.19 P75: 1.64 P99: 3.54 P99.9: 9.27 P99.99: 207.52 ------------------------------------------------------ [ 0, 1 ] 6302 39.563% 39.563% ######## ( 1, 2 ] 8803 55.264% 94.827% ########### ( 2, 3 ] 582 3.654% 98.481% # ( 3, 4 ] 152 0.954% 99.435% ( 4, 6 ] 52 0.326% 99.761% ( 6, 10 ] 27 0.170% 99.931% ( 10, 15 ] 3 0.019% 99.950% ( 15, 22 ] 3 0.019% 99.969% ( 51, 76 ] 1 0.006% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 3 0.019% 100.000% ** Level 3 read latency histogram (micros): Count: 97634 Average: 4.0609 StdDev: 50.59 Min: 1 Median: 1.6941 Max: 5327 Percentiles: P50: 1.69 P75: 2.38 P99: 9.58 P99.9: 257.10 P99.99: 1335.49 ------------------------------------------------------ [ 0, 1 ] 8001 8.195% 8.195% ## ( 1, 2 ] 58805 60.230% 68.425% ############ ( 2, 3 ] 17117 17.532% 85.957% #### ( 3, 4 ] 5959 6.103% 92.060% # ( 4, 6 ] 4909 5.028% 97.088% # ( 6, 10 ] 2085 2.136% 99.224% ( 10, 15 ] 301 0.308% 99.532% ( 15, 22 ] 48 0.049% 99.581% ( 22, 34 ] 18 0.018% 99.600% ( 34, 51 ] 3 0.003% 99.603% ( 76, 110 ] 61 0.062% 99.665% ( 110, 170 ] 176 0.180% 99.845% ( 170, 250 ] 52 0.053% 99.899% ( 250, 380 ] 25 0.026% 99.924% ( 380, 580 ] 36 0.037% 99.961% ( 580, 870 ] 22 0.023% 99.984% ( 870, 1300 ] 6 0.006% 99.990% ( 1300, 1900 ] 4 0.004% 99.994% ( 1900, 2900 ] 5 0.005% 99.999% ( 2900, 4400 ] 8 0.008% 100.007% ( 4400, 6600 ] 3 0.003% 100.010% ** Level 4 read latency histogram (micros): Count: 25 Average: 1804.2400 StdDev: 1404.78 Min: 382 Median: 1400.0000 Max: 5924 Percentiles: P50: 1400.00 P75: 2837.50 P99: 5924.00 P99.9: 5924.00 P99.99: 5924.00 ------------------------------------------------------ ( 380, 580 ] 5 20.000% 20.000% #### ( 580, 870 ] 5 20.000% 40.000% #### ( 870, 1300 ] 2 8.000% 48.000% ## ( 1300, 1900 ] 3 12.000% 60.000% ## ( 1900, 2900 ] 4 16.000% 76.000% ### ( 2900, 4400 ] 5 20.000% 96.000% #### ( 4400, 6600 ] 1 4.000% 100.000% # ** DB Stats ** Uptime(secs): 6.3 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 310.59 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.818 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, 313.54 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, 13.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/12/17-07:55:46 ... thread 0: (1000000,3000000) ops and (337014.2,328870.5) ops/second in (2.967234,9.122132) 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/4 1.29 GB 107.0 1.4 0.0 1.4 4.1 2.7 0.0 1.5 103.4 310.1 13.40 12.42 44 0.305 1407K 1455 0.0 0.0 L1 10/0 865.66 MB 86.6 1.6 1.3 0.4 1.6 1.3 0.1 1.3 229.7 229.1 7.35 7.07 3 2.448 1713K 4300 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.6 1.8 236.9 236.9 0.47 0.44 1 0.470 113K 24 0.0 0.0 L3 21/0 886.63 MB 0.9 1.5 0.6 0.9 1.5 0.6 0.0 2.4 214.4 214.3 7.07 6.29 4 1.769 1527K 750 0.0 0.0 L4 166/0 9.40 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.4 1.0 186.5 186.5 0.69 0.58 1 0.690 130K 0 0.0 0.0 L5 1052/0 86.43 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 1259/4 98.84 GB 0.0 4.7 2.1 2.6 7.4 4.8 1.8 2.7 166.6 262.0 28.99 26.80 53 0.547 4891K 6529 0.0 0.0 Int 0/0 0.00 KB 0.0 4.7 2.1 2.6 7.4 4.8 1.7 2.7 166.6 262.0 28.99 26.80 53 0.547 4891K 6529 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.7 2.1 2.6 4.7 2.1 0.0 0.0 231.4 231.1 20.88 19.58 14 1.491 4891K 6529 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 341.8 8.11 7.23 39 0.208 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.3 total, 9.1 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: 7.42 GB write, 816.30 MB/s write, 4.72 GB read, 519.13 MB/s read, 29.0 seconds Interval compaction: 7.42 GB write, 832.49 MB/s write, 4.72 GB read, 529.43 MB/s read, 29.0 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: 755581 Average: 2.4080 StdDev: 12.17 Min: 1 Median: 1.5693 Max: 3350 Percentiles: P50: 1.57 P75: 1.97 P99: 5.90 P99.9: 11.49 P99.99: 14.95 ------------------------------------------------------ [ 0, 1 ] 112171 14.846% 14.846% ### ( 1, 2 ] 466554 61.748% 76.593% ############ ( 2, 3 ] 102011 13.501% 90.094% ### ( 3, 4 ] 39199 5.188% 95.282% # ( 4, 6 ] 29555 3.912% 99.194% # ( 6, 10 ] 5043 0.667% 99.861% ( 10, 15 ] 983 0.130% 99.991% ( 15, 22 ] 136 0.018% 100.009% ( 22, 34 ] 3 0.000% 100.010% ( 34, 51 ] 5 0.001% 100.010% ( 51, 76 ] 8 0.001% 100.012% ( 76, 110 ] 24 0.003% 100.015% ( 110, 170 ] 55 0.007% 100.022% ( 170, 250 ] 46 0.006% 100.028% ( 250, 380 ] 39 0.005% 100.033% ( 380, 580 ] 27 0.004% 100.037% ( 580, 870 ] 28 0.004% 100.040% ( 870, 1300 ] 12 0.002% 100.042% ( 1300, 1900 ] 4 0.001% 100.043% ( 1900, 2900 ] 6 0.001% 100.043% ( 2900, 4400 ] 3 0.000% 100.044% ** Level 1 read latency histogram (micros): Count: 219856 Average: 2.6569 StdDev: 15.88 Min: 1 Median: 1.6274 Max: 3688 Percentiles: P50: 1.63 P75: 2.15 P99: 6.91 P99.9: 40.01 P99.99: 548.12 ------------------------------------------------------ [ 0, 1 ] 26474 12.042% 12.042% ## ( 1, 2 ] 133021 60.504% 72.545% ############ ( 2, 3 ] 35083 15.957% 88.502% ### ( 3, 4 ] 12178 5.539% 94.042% # ( 4, 6 ] 10452 4.754% 98.796% # ( 6, 10 ] 1982 0.901% 99.697% ( 10, 15 ] 374 0.170% 99.867% ( 15, 22 ] 53 0.024% 99.891% ( 22, 34 ] 5 0.002% 99.894% ( 34, 51 ] 40 0.018% 99.912% ( 51, 76 ] 16 0.007% 99.919% ( 76, 110 ] 34 0.015% 99.935% ( 110, 170 ] 50 0.023% 99.957% ( 170, 250 ] 34 0.015% 99.973% ( 250, 380 ] 17 0.008% 99.980% ( 380, 580 ] 25 0.011% 99.992% ( 580, 870 ] 6 0.003% 99.995% ( 870, 1300 ] 2 0.001% 99.995% ( 1300, 1900 ] 7 0.003% 99.999% ( 1900, 2900 ] 2 0.001% 100.000% ( 2900, 4400 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28279 Average: 2.1360 StdDev: 10.78 Min: 1 Median: 1.3735 Max: 1494 Percentiles: P50: 1.37 P75: 1.79 P99: 6.46 P99.9: 13.66 P99.99: 414.42 ------------------------------------------------------ [ 0, 1 ] 7785 27.529% 27.529% ###### ( 1, 2 ] 17015 60.168% 87.698% ############ ( 2, 3 ] 2039 7.210% 94.908% # ( 3, 4 ] 702 2.482% 97.390% ( 4, 6 ] 424 1.499% 98.890% ( 6, 10 ] 274 0.969% 99.859% ( 10, 15 ] 16 0.057% 99.915% ( 15, 22 ] 6 0.021% 99.936% ( 51, 76 ] 1 0.004% 99.940% ( 76, 110 ] 2 0.007% 99.947% ( 110, 170 ] 7 0.025% 99.972% ( 170, 250 ] 4 0.014% 99.986% ( 250, 380 ] 1 0.004% 99.989% ( 380, 580 ] 1 0.004% 99.993% ( 580, 870 ] 1 0.004% 99.996% ( 1300, 1900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 259215 Average: 3.6274 StdDev: 35.38 Min: 1 Median: 1.7028 Max: 5327 Percentiles: P50: 1.70 P75: 2.40 P99: 9.32 P99.9: 239.82 P99.99: 769.63 ------------------------------------------------------ [ 0, 1 ] 19035 7.343% 7.343% # ( 1, 2 ] 157327 60.694% 68.037% ############ ( 2, 3 ] 44985 17.354% 85.391% ### ( 3, 4 ] 17194 6.633% 92.024% # ( 4, 6 ] 13700 5.285% 97.310% # ( 6, 10 ] 5277 2.036% 99.345% ( 10, 15 ] 707 0.273% 99.618% ( 15, 22 ] 109 0.042% 99.660% ( 22, 34 ] 25 0.010% 99.670% ( 34, 51 ] 5 0.002% 99.672% ( 51, 76 ] 31 0.012% 99.684% ( 76, 110 ] 121 0.047% 99.730% ( 110, 170 ] 308 0.119% 99.849% ( 170, 250 ] 151 0.058% 99.907% ( 250, 380 ] 93 0.036% 99.943% ( 380, 580 ] 91 0.035% 99.978% ( 580, 870 ] 46 0.018% 99.996% ( 870, 1300 ] 15 0.006% 100.002% ( 1300, 1900 ] 5 0.002% 100.004% ( 1900, 2900 ] 8 0.003% 100.007% ( 2900, 4400 ] 9 0.003% 100.010% ( 4400, 6600 ] 3 0.001% 100.012% ** Level 4 read latency histogram (micros): Count: 95 Average: 487.1368 StdDev: 1068.32 Min: 0 Median: 4.7500 Max: 5924 Percentiles: P50: 4.75 P75: 455.00 P99: 4510.00 P99.9: 5924.00 P99.99: 5924.00 ------------------------------------------------------ [ 0, 1 ] 28 29.474% 29.474% ###### ( 1, 2 ] 13 13.684% 43.158% ### ( 2, 3 ] 1 1.053% 44.211% ( 3, 4 ] 4 4.211% 48.421% # ( 4, 6 ] 4 4.211% 52.632% # ( 6, 10 ] 5 5.263% 57.895% # ( 15, 22 ] 2 2.105% 60.000% ( 22, 34 ] 10 10.526% 70.526% ## ( 34, 51 ] 1 1.053% 71.579% ( 170, 250 ] 1 1.053% 72.632% ( 380, 580 ] 6 6.316% 78.947% # ( 580, 870 ] 5 5.263% 84.211% # ( 870, 1300 ] 2 2.105% 86.316% ( 1300, 1900 ] 3 3.158% 89.474% # ( 1900, 2900 ] 4 4.211% 93.684% # ( 2900, 4400 ] 5 5.263% 98.947% # ( 4400, 6600 ] 1 1.053% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 582.0750 StdDev: 785.08 Min: 71 Median: 110.0000 Max: 3583 Percentiles: P50: 110.00 P75: 870.00 P99: 3583.00 P99.9: 3583.00 P99.99: 3583.00 ------------------------------------------------------ ( 51, 76 ] 6 15.000% 15.000% ### ( 76, 110 ] 14 35.000% 50.000% ####### ( 110, 170 ] 2 5.000% 55.000% # ( 170, 250 ] 1 2.500% 57.500% # ( 250, 380 ] 2 5.000% 62.500% # ( 380, 580 ] 3 7.500% 70.000% ## ( 580, 870 ] 2 5.000% 75.000% # ( 870, 1300 ] 2 5.000% 80.000% # ( 1300, 1900 ] 6 15.000% 95.000% ### ( 1900, 2900 ] 1 2.500% 97.500% # ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 9.3 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 317.32 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.046 H:M:S, 11.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 331.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:0.228 H:M:S, 7.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/17-07:55:49 ... thread 0: (1000000,4000000) ops and (329325.1,328984.0) ops/second in (3.036513,12.158645) 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/14 2.27 GB 6.3 2.2 0.0 2.2 5.8 3.7 0.0 1.6 114.4 310.3 19.28 17.94 61 0.316 2238K 2344 0.0 0.0 L1 10/10 865.66 MB 0.0 1.6 1.3 0.4 1.6 1.3 0.1 1.3 229.7 229.1 7.35 7.07 3 2.448 1713K 4300 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.6 1.8 236.9 236.9 0.47 0.44 1 0.470 113K 24 0.0 0.0 L3 21/0 886.63 MB 0.9 1.5 0.6 0.9 1.5 0.6 0.0 2.4 214.4 214.3 7.07 6.29 4 1.769 1527K 750 0.0 0.0 L4 166/0 9.40 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.4 1.0 186.5 186.5 0.69 0.58 1 0.690 130K 0 0.0 0.0 L5 1052/0 86.43 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/24 99.82 GB 0.0 5.5 2.1 3.4 9.2 5.8 1.8 2.5 162.1 270.3 34.86 32.32 70 0.498 5723K 7418 0.0 0.0 Int 0/0 0.00 KB 0.0 5.5 2.1 3.4 9.2 5.8 1.7 2.5 162.1 270.3 34.86 32.32 70 0.498 5723K 7418 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.5 2.1 3.4 5.5 2.1 0.0 0.0 236.0 235.7 23.94 22.57 17 1.408 5723K 7418 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 346.1 10.92 9.75 53 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): 12.3 total, 12.2 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.20 GB write, 763.40 MB/s write, 5.52 GB read, 457.76 MB/s read, 34.9 seconds Interval compaction: 9.20 GB write, 774.77 MB/s write, 5.52 GB read, 464.57 MB/s read, 34.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 15, interval: 15 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 984682 Average: 2.2984 StdDev: 11.50 Min: 1 Median: 1.5087 Max: 3350 Percentiles: P50: 1.51 P75: 1.92 P99: 5.82 P99.9: 11.43 P99.99: 18.15 ------------------------------------------------------ [ 0, 1 ] 184707 18.758% 18.758% #### ( 1, 2 ] 604737 61.414% 80.172% ############ ( 2, 3 ] 113568 11.533% 91.706% ## ( 3, 4 ] 43187 4.386% 96.092% # ( 4, 6 ] 31403 3.189% 99.281% # ( 6, 10 ] 5770 0.586% 99.867% ( 10, 15 ] 1140 0.116% 99.983% ( 15, 22 ] 161 0.016% 99.999% ( 22, 34 ] 4 0.000% 99.999% ( 34, 51 ] 5 0.001% 100.000% ( 51, 76 ] 9 0.001% 100.001% ( 76, 110 ] 44 0.004% 100.005% ( 110, 170 ] 98 0.010% 100.015% ( 170, 250 ] 58 0.006% 100.021% ( 250, 380 ] 45 0.005% 100.026% ( 380, 580 ] 33 0.003% 100.029% ( 580, 870 ] 34 0.003% 100.033% ( 870, 1300 ] 14 0.001% 100.034% ( 1300, 1900 ] 6 0.001% 100.035% ( 1900, 2900 ] 7 0.001% 100.035% ( 2900, 4400 ] 3 0.000% 100.036% ** Level 1 read latency histogram (micros): Count: 235410 Average: 2.6462 StdDev: 15.55 Min: 1 Median: 1.6093 Max: 3688 Percentiles: P50: 1.61 P75: 2.09 P99: 7.07 P99.9: 78.95 P99.99: 538.96 ------------------------------------------------------ [ 0, 1 ] 30934 13.140% 13.140% ### ( 1, 2 ] 142417 60.497% 73.638% ############ ( 2, 3 ] 35929 15.262% 88.900% ### ( 3, 4 ] 12528 5.322% 94.222% # ( 4, 6 ] 10673 4.534% 98.756% # ( 6, 10 ] 2159 0.917% 99.673% ( 10, 15 ] 405 0.172% 99.845% ( 15, 22 ] 60 0.025% 99.870% ( 22, 34 ] 5 0.002% 99.873% ( 34, 51 ] 40 0.017% 99.890% ( 51, 76 ] 18 0.008% 99.897% ( 76, 110 ] 76 0.032% 99.929% ( 110, 170 ] 63 0.027% 99.956% ( 170, 250 ] 37 0.016% 99.972% ( 250, 380 ] 21 0.009% 99.981% ( 380, 580 ] 27 0.011% 99.992% ( 580, 870 ] 6 0.003% 99.995% ( 870, 1300 ] 2 0.001% 99.996% ( 1300, 1900 ] 7 0.003% 99.999% ( 1900, 2900 ] 2 0.001% 100.000% ( 2900, 4400 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28279 Average: 2.1360 StdDev: 10.78 Min: 1 Median: 1.3735 Max: 1494 Percentiles: P50: 1.37 P75: 1.79 P99: 6.46 P99.9: 13.66 P99.99: 414.42 ------------------------------------------------------ [ 0, 1 ] 7785 27.529% 27.529% ###### ( 1, 2 ] 17015 60.168% 87.698% ############ ( 2, 3 ] 2039 7.210% 94.908% # ( 3, 4 ] 702 2.482% 97.390% ( 4, 6 ] 424 1.499% 98.890% ( 6, 10 ] 274 0.969% 99.859% ( 10, 15 ] 16 0.057% 99.915% ( 15, 22 ] 6 0.021% 99.936% ( 51, 76 ] 1 0.004% 99.940% ( 76, 110 ] 2 0.007% 99.947% ( 110, 170 ] 7 0.025% 99.972% ( 170, 250 ] 4 0.014% 99.986% ( 250, 380 ] 1 0.004% 99.989% ( 380, 580 ] 1 0.004% 99.993% ( 580, 870 ] 1 0.004% 99.996% ( 1300, 1900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 259215 Average: 3.6274 StdDev: 35.38 Min: 1 Median: 1.7028 Max: 5327 Percentiles: P50: 1.70 P75: 2.40 P99: 9.32 P99.9: 239.82 P99.99: 769.63 ------------------------------------------------------ [ 0, 1 ] 19035 7.343% 7.343% # ( 1, 2 ] 157327 60.694% 68.037% ############ ( 2, 3 ] 44985 17.354% 85.391% ### ( 3, 4 ] 17194 6.633% 92.024% # ( 4, 6 ] 13700 5.285% 97.310% # ( 6, 10 ] 5277 2.036% 99.345% ( 10, 15 ] 707 0.273% 99.618% ( 15, 22 ] 109 0.042% 99.660% ( 22, 34 ] 25 0.010% 99.670% ( 34, 51 ] 5 0.002% 99.672% ( 51, 76 ] 31 0.012% 99.684% ( 76, 110 ] 121 0.047% 99.730% ( 110, 170 ] 308 0.119% 99.849% ( 170, 250 ] 151 0.058% 99.907% ( 250, 380 ] 93 0.036% 99.943% ( 380, 580 ] 91 0.035% 99.978% ( 580, 870 ] 46 0.018% 99.996% ( 870, 1300 ] 15 0.006% 100.002% ( 1300, 1900 ] 5 0.002% 100.004% ( 1900, 2900 ] 8 0.003% 100.007% ( 2900, 4400 ] 9 0.003% 100.010% ( 4400, 6600 ] 3 0.001% 100.012% ** Level 4 read latency histogram (micros): Count: 95 Average: 487.1368 StdDev: 1068.32 Min: 0 Median: 4.7500 Max: 5924 Percentiles: P50: 4.75 P75: 455.00 P99: 4510.00 P99.9: 5924.00 P99.99: 5924.00 ------------------------------------------------------ [ 0, 1 ] 28 29.474% 29.474% ###### ( 1, 2 ] 13 13.684% 43.158% ### ( 2, 3 ] 1 1.053% 44.211% ( 3, 4 ] 4 4.211% 48.421% # ( 4, 6 ] 4 4.211% 52.632% # ( 6, 10 ] 5 5.263% 57.895% # ( 15, 22 ] 2 2.105% 60.000% ( 22, 34 ] 10 10.526% 70.526% ## ( 34, 51 ] 1 1.053% 71.579% ( 170, 250 ] 1 1.053% 72.632% ( 380, 580 ] 6 6.316% 78.947% # ( 580, 870 ] 5 5.263% 84.211% # ( 870, 1300 ] 2 2.105% 86.316% ( 1300, 1900 ] 3 3.158% 89.474% # ( 1900, 2900 ] 4 4.211% 93.684% # ( 2900, 4400 ] 5 5.263% 98.947% # ( 4400, 6600 ] 1 1.053% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 582.0750 StdDev: 785.08 Min: 71 Median: 110.0000 Max: 3583 Percentiles: P50: 110.00 P75: 870.00 P99: 3583.00 P99.9: 3583.00 P99.99: 3583.00 ------------------------------------------------------ ( 51, 76 ] 6 15.000% 15.000% ### ( 76, 110 ] 14 35.000% 50.000% ####### ( 110, 170 ] 2 5.000% 55.000% # ( 170, 250 ] 1 2.500% 57.500% # ( 250, 380 ] 2 5.000% 62.500% # ( 380, 580 ] 3 7.500% 70.000% ## ( 580, 870 ] 2 5.000% 75.000% # ( 870, 1300 ] 2 5.000% 80.000% # ( 1300, 1900 ] 6 15.000% 95.000% ### ( 1900, 2900 ] 1 2.500% 97.500% # ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 12.3 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 318.99 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.442 H:M:S, 11.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.12 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.395 H:M:S, 13.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/17-07:55:53 ... thread 0: (1000000,5000000) ops and (270803.3,315430.3) ops/second in (3.692717,15.851362) 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.32 GB 138.5 3.2 0.0 3.2 7.9 4.7 0.0 1.7 124.1 307.8 26.39 24.65 80 0.330 3326K 3472 0.0 0.0 L1 10/10 865.66 MB 0.0 1.6 1.3 0.4 1.6 1.3 0.1 1.3 229.7 229.1 7.35 7.07 3 2.448 1713K 4300 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.6 1.8 236.9 236.9 0.47 0.44 1 0.470 113K 24 0.0 0.0 L3 21/0 886.63 MB 0.9 1.5 0.6 0.9 1.5 0.6 0.0 2.4 214.4 214.3 7.07 6.29 4 1.769 1527K 750 0.0 0.0 L4 166/0 9.40 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.4 1.0 186.5 186.5 0.69 0.58 1 0.690 130K 0 0.0 0.0 L5 1052/0 86.43 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 1267/20 100.86 GB 0.0 6.6 2.1 4.5 11.3 6.8 1.8 2.4 160.1 275.5 41.97 39.03 89 0.472 6810K 8546 0.0 0.0 Int 0/0 0.00 KB 0.0 6.6 2.1 4.5 11.3 6.8 1.7 2.4 160.1 275.5 41.97 39.03 89 0.472 6810K 8546 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.6 2.1 4.5 6.6 2.1 0.0 0.0 240.2 239.9 27.98 26.53 21 1.332 6810K 8546 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 346.7 13.99 12.50 68 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): 16.0 total, 15.9 interval Flush(GB): cumulative 4.737, interval 4.737 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.29 GB write, 721.10 MB/s write, 6.56 GB read, 419.13 MB/s read, 42.0 seconds Interval compaction: 11.29 GB write, 729.33 MB/s write, 6.56 GB read, 423.91 MB/s read, 42.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 3, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 3, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 18, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 18, interval: 21 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1389008 Average: 2.2681 StdDev: 10.85 Min: 1 Median: 1.5064 Max: 3350 Percentiles: P50: 1.51 P75: 1.90 P99: 5.77 P99.9: 11.01 P99.99: 17.56 ------------------------------------------------------ [ 0, 1 ] 249862 17.989% 17.989% #### ( 1, 2 ] 878021 63.212% 81.201% ############# ( 2, 3 ] 156679 11.280% 92.481% ## ( 3, 4 ] 56628 4.077% 96.557% # ( 4, 6 ] 38425 2.766% 99.324% # ( 6, 10 ] 7708 0.555% 99.879% ( 10, 15 ] 1475 0.106% 99.985% ( 15, 22 ] 197 0.014% 99.999% ( 22, 34 ] 8 0.001% 100.000% ( 34, 51 ] 6 0.000% 100.000% ( 51, 76 ] 11 0.001% 100.001% ( 76, 110 ] 70 0.005% 100.006% ( 110, 170 ] 131 0.009% 100.015% ( 170, 250 ] 78 0.006% 100.021% ( 250, 380 ] 58 0.004% 100.025% ( 380, 580 ] 41 0.003% 100.028% ( 580, 870 ] 43 0.003% 100.031% ( 870, 1300 ] 18 0.001% 100.032% ( 1300, 1900 ] 6 0.000% 100.033% ( 1900, 2900 ] 10 0.001% 100.034% ( 2900, 4400 ] 3 0.000% 100.034% ** Level 1 read latency histogram (micros): Count: 297173 Average: 2.6416 StdDev: 14.86 Min: 1 Median: 1.5903 Max: 3688 Percentiles: P50: 1.59 P75: 1.99 P99: 7.44 P99.9: 98.11 P99.99: 546.41 ------------------------------------------------------ [ 0, 1 ] 39936 13.439% 13.439% ### ( 1, 2 ] 184064 61.938% 75.377% ############ ( 2, 3 ] 42654 14.353% 89.730% ### ( 3, 4 ] 14457 4.865% 94.595% # ( 4, 6 ] 11974 4.029% 98.624% # ( 6, 10 ] 3101 1.043% 99.668% ( 10, 15 ] 486 0.164% 99.831% ( 15, 22 ] 67 0.023% 99.854% ( 22, 34 ] 6 0.002% 99.856% ( 34, 51 ] 40 0.013% 99.869% ( 51, 76 ] 18 0.006% 99.875% ( 76, 110 ] 112 0.038% 99.913% ( 110, 170 ] 108 0.036% 99.950% ( 170, 250 ] 54 0.018% 99.968% ( 250, 380 ] 33 0.011% 99.979% ( 380, 580 ] 40 0.013% 99.992% ( 580, 870 ] 10 0.003% 99.996% ( 870, 1300 ] 3 0.001% 99.997% ( 1300, 1900 ] 7 0.002% 99.999% ( 1900, 2900 ] 2 0.001% 100.000% ( 2900, 4400 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28279 Average: 2.1360 StdDev: 10.78 Min: 1 Median: 1.3735 Max: 1494 Percentiles: P50: 1.37 P75: 1.79 P99: 6.46 P99.9: 13.66 P99.99: 414.42 ------------------------------------------------------ [ 0, 1 ] 7785 27.529% 27.529% ###### ( 1, 2 ] 17015 60.168% 87.698% ############ ( 2, 3 ] 2039 7.210% 94.908% # ( 3, 4 ] 702 2.482% 97.390% ( 4, 6 ] 424 1.499% 98.890% ( 6, 10 ] 274 0.969% 99.859% ( 10, 15 ] 16 0.057% 99.915% ( 15, 22 ] 6 0.021% 99.936% ( 51, 76 ] 1 0.004% 99.940% ( 76, 110 ] 2 0.007% 99.947% ( 110, 170 ] 7 0.025% 99.972% ( 170, 250 ] 4 0.014% 99.986% ( 250, 380 ] 1 0.004% 99.989% ( 380, 580 ] 1 0.004% 99.993% ( 580, 870 ] 1 0.004% 99.996% ( 1300, 1900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 259215 Average: 3.6274 StdDev: 35.38 Min: 1 Median: 1.7028 Max: 5327 Percentiles: P50: 1.70 P75: 2.40 P99: 9.32 P99.9: 239.82 P99.99: 769.63 ------------------------------------------------------ [ 0, 1 ] 19035 7.343% 7.343% # ( 1, 2 ] 157327 60.694% 68.037% ############ ( 2, 3 ] 44985 17.354% 85.391% ### ( 3, 4 ] 17194 6.633% 92.024% # ( 4, 6 ] 13700 5.285% 97.310% # ( 6, 10 ] 5277 2.036% 99.345% ( 10, 15 ] 707 0.273% 99.618% ( 15, 22 ] 109 0.042% 99.660% ( 22, 34 ] 25 0.010% 99.670% ( 34, 51 ] 5 0.002% 99.672% ( 51, 76 ] 31 0.012% 99.684% ( 76, 110 ] 121 0.047% 99.730% ( 110, 170 ] 308 0.119% 99.849% ( 170, 250 ] 151 0.058% 99.907% ( 250, 380 ] 93 0.036% 99.943% ( 380, 580 ] 91 0.035% 99.978% ( 580, 870 ] 46 0.018% 99.996% ( 870, 1300 ] 15 0.006% 100.002% ( 1300, 1900 ] 5 0.002% 100.004% ( 1900, 2900 ] 8 0.003% 100.007% ( 2900, 4400 ] 9 0.003% 100.010% ( 4400, 6600 ] 3 0.001% 100.012% ** Level 4 read latency histogram (micros): Count: 95 Average: 487.1368 StdDev: 1068.32 Min: 0 Median: 4.7500 Max: 5924 Percentiles: P50: 4.75 P75: 455.00 P99: 4510.00 P99.9: 5924.00 P99.99: 5924.00 ------------------------------------------------------ [ 0, 1 ] 28 29.474% 29.474% ###### ( 1, 2 ] 13 13.684% 43.158% ### ( 2, 3 ] 1 1.053% 44.211% ( 3, 4 ] 4 4.211% 48.421% # ( 4, 6 ] 4 4.211% 52.632% # ( 6, 10 ] 5 5.263% 57.895% # ( 15, 22 ] 2 2.105% 60.000% ( 22, 34 ] 10 10.526% 70.526% ## ( 34, 51 ] 1 1.053% 71.579% ( 170, 250 ] 1 1.053% 72.632% ( 380, 580 ] 6 6.316% 78.947% # ( 580, 870 ] 5 5.263% 84.211% # ( 870, 1300 ] 2 2.105% 86.316% ( 1300, 1900 ] 3 3.158% 89.474% # ( 1900, 2900 ] 4 4.211% 93.684% # ( 2900, 4400 ] 5 5.263% 98.947% # ( 4400, 6600 ] 1 1.053% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 582.0750 StdDev: 785.08 Min: 71 Median: 110.0000 Max: 3583 Percentiles: P50: 110.00 P75: 870.00 P99: 3583.00 P99.9: 3583.00 P99.99: 3583.00 ------------------------------------------------------ ( 51, 76 ] 6 15.000% 15.000% ### ( 76, 110 ] 14 35.000% 50.000% ####### ( 110, 170 ] 2 5.000% 55.000% # ( 170, 250 ] 1 2.500% 57.500% # ( 250, 380 ] 2 5.000% 62.500% # ( 380, 580 ] 3 7.500% 70.000% ## ( 580, 870 ] 2 5.000% 75.000% # ( 870, 1300 ] 2 5.000% 80.000% # ( 1300, 1900 ] 6 15.000% 95.000% ### ( 1900, 2900 ] 1 2.500% 97.500% # ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 16.0 total, 3.7 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 306.91 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.376 H:M:S, 14.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 266.52 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.935 H:M:S, 25.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/17-07:56:01 ... thread 0: (1000000,6000000) ops and (118301.7,246869.6) ops/second in (8.452963,24.304325) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/4 2.33 GB 213.6 4.9 0.0 4.9 10.6 5.7 0.0 1.8 139.3 303.2 35.71 33.46 100 0.357 5052K 7691 0.0 0.0 L1 19/0 1.77 GB 181.3 4.5 3.3 1.2 4.4 3.2 0.1 1.4 225.1 223.1 20.29 19.35 4 5.072 4637K 40K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 1.6 1.8 236.9 236.9 0.47 0.44 1 0.470 113K 24 0.0 0.0 L3 15/1 1.02 GB 0.9 1.5 0.6 0.9 1.5 0.6 1.0 2.4 214.4 214.3 7.07 6.29 4 1.769 1527K 750 0.0 0.0 L4 180/11 10.25 GB 1.0 0.1 0.1 0.0 0.1 0.1 1.3 1.0 186.5 186.5 0.69 0.58 1 0.690 130K 0 0.0 0.0 L5 1052/0 86.43 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 1277/16 101.81 GB 0.0 11.0 4.1 7.0 16.7 9.7 4.6 2.9 175.9 266.4 64.23 60.12 110 0.584 11M 49K 0.0 0.0 Int 0/0 0.00 KB 0.0 11.0 4.1 7.0 16.7 9.7 4.6 2.9 175.9 266.4 64.23 60.12 110 0.584 11M 49K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 11.0 4.1 7.0 11.0 4.0 0.0 0.0 238.8 237.7 47.33 45.02 26 1.820 11M 49K 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 346.5 16.91 15.10 84 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): 24.5 total, 24.3 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: 16.71 GB write, 698.71 MB/s write, 11.04 GB read, 461.48 MB/s read, 64.2 seconds Interval compaction: 16.71 GB write, 703.91 MB/s write, 11.04 GB read, 464.92 MB/s read, 64.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 18, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 18, interval: 31 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2195101 Average: 2.3672 StdDev: 12.69 Min: 0 Median: 1.4878 Max: 3820 Percentiles: P50: 1.49 P75: 1.88 P99: 5.81 P99.9: 17.82 P99.99: 168.50 ------------------------------------------------------ [ 0, 1 ] 407374 18.558% 18.558% #### ( 1, 2 ] 1415007 64.462% 83.020% ############# ( 2, 3 ] 225940 10.293% 93.313% ## ( 3, 4 ] 79378 3.616% 96.929% # ( 4, 6 ] 50155 2.285% 99.214% ( 6, 10 ] 12960 0.590% 99.805% ( 10, 15 ] 1985 0.090% 99.895% ( 15, 22 ] 268 0.012% 99.907% ( 22, 34 ] 12 0.001% 99.908% ( 34, 51 ] 9 0.000% 99.908% ( 51, 76 ] 26 0.001% 99.909% ( 76, 110 ] 776 0.035% 99.945% ( 110, 170 ] 1018 0.046% 99.991% ( 170, 250 ] 299 0.014% 100.005% ( 250, 380 ] 202 0.009% 100.014% ( 380, 580 ] 152 0.007% 100.021% ( 580, 870 ] 91 0.004% 100.025% ( 870, 1300 ] 28 0.001% 100.026% ( 1300, 1900 ] 10 0.000% 100.027% ( 1900, 2900 ] 15 0.001% 100.028% ( 2900, 4400 ] 7 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 440002 Average: 2.8115 StdDev: 17.95 Min: 1 Median: 1.5550 Max: 3688 Percentiles: P50: 1.55 P75: 1.95 P99: 7.82 P99.9: 159.62 P99.99: 792.66 ------------------------------------------------------ [ 0, 1 ] 65338 14.849% 14.849% ### ( 1, 2 ] 278679 63.336% 78.185% ############# ( 2, 3 ] 56064 12.742% 90.927% ### ( 3, 4 ] 18603 4.228% 95.155% # ( 4, 6 ] 14736 3.349% 98.504% # ( 6, 10 ] 4788 1.088% 99.592% ( 10, 15 ] 591 0.134% 99.727% ( 15, 22 ] 78 0.018% 99.744% ( 22, 34 ] 6 0.001% 99.746% ( 34, 51 ] 41 0.009% 99.755% ( 51, 76 ] 27 0.006% 99.761% ( 76, 110 ] 310 0.070% 99.832% ( 110, 170 ] 364 0.083% 99.914% ( 170, 250 ] 143 0.032% 99.947% ( 250, 380 ] 83 0.019% 99.966% ( 380, 580 ] 85 0.019% 99.985% ( 580, 870 ] 30 0.007% 99.992% ( 870, 1300 ] 17 0.004% 99.996% ( 1300, 1900 ] 14 0.003% 99.999% ( 1900, 2900 ] 4 0.001% 100.000% ( 2900, 4400 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28279 Average: 2.1360 StdDev: 10.78 Min: 1 Median: 1.3735 Max: 1494 Percentiles: P50: 1.37 P75: 1.79 P99: 6.46 P99.9: 13.66 P99.99: 414.42 ------------------------------------------------------ [ 0, 1 ] 7785 27.529% 27.529% ###### ( 1, 2 ] 17015 60.168% 87.698% ############ ( 2, 3 ] 2039 7.210% 94.908% # ( 3, 4 ] 702 2.482% 97.390% ( 4, 6 ] 424 1.499% 98.890% ( 6, 10 ] 274 0.969% 99.859% ( 10, 15 ] 16 0.057% 99.915% ( 15, 22 ] 6 0.021% 99.936% ( 51, 76 ] 1 0.004% 99.940% ( 76, 110 ] 2 0.007% 99.947% ( 110, 170 ] 7 0.025% 99.972% ( 170, 250 ] 4 0.014% 99.986% ( 250, 380 ] 1 0.004% 99.989% ( 380, 580 ] 1 0.004% 99.993% ( 580, 870 ] 1 0.004% 99.996% ( 1300, 1900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 259256 Average: 3.6677 StdDev: 35.62 Min: 1 Median: 1.7029 Max: 5327 Percentiles: P50: 1.70 P75: 2.40 P99: 9.35 P99.9: 246.30 P99.99: 781.66 ------------------------------------------------------ [ 0, 1 ] 19035 7.342% 7.342% # ( 1, 2 ] 157327 60.684% 68.026% ############ ( 2, 3 ] 44985 17.352% 85.378% ### ( 3, 4 ] 17194 6.632% 92.010% # ( 4, 6 ] 13700 5.284% 97.294% # ( 6, 10 ] 5277 2.035% 99.330% ( 10, 15 ] 707 0.273% 99.602% ( 15, 22 ] 109 0.042% 99.644% ( 22, 34 ] 25 0.010% 99.654% ( 34, 51 ] 5 0.002% 99.656% ( 51, 76 ] 31 0.012% 99.668% ( 76, 110 ] 128 0.049% 99.717% ( 110, 170 ] 324 0.125% 99.842% ( 170, 250 ] 157 0.061% 99.903% ( 250, 380 ] 94 0.036% 99.939% ( 380, 580 ] 98 0.038% 99.977% ( 580, 870 ] 49 0.019% 99.996% ( 870, 1300 ] 16 0.006% 100.002% ( 1300, 1900 ] 5 0.002% 100.004% ( 1900, 2900 ] 8 0.003% 100.007% ( 2900, 4400 ] 9 0.003% 100.010% ( 4400, 6600 ] 3 0.001% 100.012% ** Level 4 read latency histogram (micros): Count: 95 Average: 487.1368 StdDev: 1068.32 Min: 0 Median: 4.7500 Max: 5924 Percentiles: P50: 4.75 P75: 455.00 P99: 4510.00 P99.9: 5924.00 P99.99: 5924.00 ------------------------------------------------------ [ 0, 1 ] 28 29.474% 29.474% ###### ( 1, 2 ] 13 13.684% 43.158% ### ( 2, 3 ] 1 1.053% 44.211% ( 3, 4 ] 4 4.211% 48.421% # ( 4, 6 ] 4 4.211% 52.632% # ( 6, 10 ] 5 5.263% 57.895% # ( 15, 22 ] 2 2.105% 60.000% ( 22, 34 ] 10 10.526% 70.526% ## ( 34, 51 ] 1 1.053% 71.579% ( 170, 250 ] 1 1.053% 72.632% ( 380, 580 ] 6 6.316% 78.947% # ( 580, 870 ] 5 5.263% 84.211% # ( 870, 1300 ] 2 2.105% 86.316% ( 1300, 1900 ] 3 3.158% 89.474% # ( 1900, 2900 ] 4 4.211% 93.684% # ( 2900, 4400 ] 5 5.263% 98.947% # ( 4400, 6600 ] 1 1.053% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 616.8167 StdDev: 825.19 Min: 71 Median: 190.0000 Max: 3583 Percentiles: P50: 190.00 P75: 870.00 P99: 3583.00 P99.9: 3583.00 P99.99: 3583.00 ------------------------------------------------------ ( 51, 76 ] 6 10.000% 10.000% ## ( 76, 110 ] 17 28.333% 38.333% ###### ( 110, 170 ] 6 10.000% 48.333% ## ( 170, 250 ] 4 6.667% 55.000% # ( 250, 380 ] 3 5.000% 60.000% # ( 380, 580 ] 7 11.667% 71.667% ## ( 580, 870 ] 2 3.333% 75.000% # ( 870, 1300 ] 3 5.000% 80.000% # ( 1300, 1900 ] 8 13.333% 93.333% ### ( 1900, 2900 ] 2 3.333% 96.667% # ( 2900, 4400 ] 2 3.333% 100.000% # ** DB Stats ** Uptime(secs): 24.5 total, 8.5 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 241.15 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:7.858 H:M:S, 32.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 116.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:5.482 H:M:S, 64.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 0 2024/12/17-07:56:05 ... thread 0: (1000000,7000000) ops and (318258.2,255042.3) ops/second in (3.142103,27.446428) 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/12 3.25 GB 69.2 5.7 0.0 5.7 12.3 6.6 0.0 1.9 139.5 303.2 41.53 38.92 116 0.358 5884K 8529 0.0 0.0 L1 19/19 1.77 GB 0.0 4.5 3.3 1.2 4.4 3.2 0.1 1.4 225.1 223.1 20.29 19.35 4 5.072 4637K 40K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 1.6 1.8 236.9 236.9 0.47 0.44 1 0.470 113K 24 0.0 0.0 L3 14/0 920.81 MB 0.9 1.5 0.6 0.9 1.5 0.6 1.0 2.4 214.4 214.3 7.07 6.29 4 1.769 1527K 750 0.0 0.0 L4 173/0 9.70 GB 1.0 0.3 0.3 0.0 0.3 0.3 1.3 1.1 198.1 197.6 1.45 1.25 2 0.726 292K 782 0.0 0.0 L5 1060/0 87.11 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1281/31 102.73 GB 0.0 12.0 4.2 7.8 18.6 10.8 5.3 2.8 173.4 268.7 70.81 66.26 127 0.558 12M 50K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.0 4.2 7.8 18.6 10.8 5.3 2.8 173.4 268.7 70.81 66.26 127 0.558 12M 50K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 12.0 4.2 7.8 11.9 4.1 0.0 0.0 240.1 239.1 51.13 48.69 30 1.704 12M 50K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.6 6.6 0.0 0.0 0.0 345.7 19.68 17.57 97 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): 27.6 total, 27.4 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: 18.58 GB write, 688.78 MB/s write, 11.99 GB read, 444.39 MB/s read, 70.8 seconds Interval compaction: 18.58 GB write, 693.33 MB/s write, 11.99 GB read, 447.32 MB/s read, 70.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 23, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 23, interval: 36 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2547894 Average: 2.3766 StdDev: 13.33 Min: 0 Median: 1.4921 Max: 4032 Percentiles: P50: 1.49 P75: 1.88 P99: 5.82 P99.9: 14.91 P99.99: 168.36 ------------------------------------------------------ [ 0, 1 ] 459579 18.038% 18.038% #### ( 1, 2 ] 1654789 64.947% 82.985% ############# ( 2, 3 ] 264155 10.368% 93.353% ## ( 3, 4 ] 91843 3.605% 96.957% # ( 4, 6 ] 57116 2.242% 99.199% ( 6, 10 ] 15626 0.613% 99.812% ( 10, 15 ] 2283 0.090% 99.902% ( 15, 22 ] 291 0.011% 99.913% ( 22, 34 ] 15 0.001% 99.914% ( 34, 51 ] 11 0.000% 99.914% ( 51, 76 ] 26 0.001% 99.915% ( 76, 110 ] 809 0.032% 99.947% ( 110, 170 ] 1129 0.044% 99.991% ( 170, 250 ] 342 0.013% 100.005% ( 250, 380 ] 232 0.009% 100.014% ( 380, 580 ] 178 0.007% 100.021% ( 580, 870 ] 117 0.005% 100.025% ( 870, 1300 ] 37 0.001% 100.027% ( 1300, 1900 ] 14 0.001% 100.027% ( 1900, 2900 ] 19 0.001% 100.028% ( 2900, 4400 ] 10 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 472494 Average: 2.7690 StdDev: 17.32 Min: 1 Median: 1.5530 Max: 3688 Percentiles: P50: 1.55 P75: 1.95 P99: 7.83 P99.9: 154.30 P99.99: 761.26 ------------------------------------------------------ [ 0, 1 ] 70198 14.857% 14.857% ### ( 1, 2 ] 300281 63.552% 78.409% ############# ( 2, 3 ] 60114 12.723% 91.132% ### ( 3, 4 ] 19467 4.120% 95.252% # ( 4, 6 ] 15281 3.234% 98.486% # ( 6, 10 ] 5314 1.125% 99.611% ( 10, 15 ] 626 0.132% 99.743% ( 15, 22 ] 86 0.018% 99.761% ( 22, 34 ] 7 0.001% 99.763% ( 34, 51 ] 41 0.009% 99.772% ( 51, 76 ] 27 0.006% 99.777% ( 76, 110 ] 310 0.066% 99.843% ( 110, 170 ] 365 0.077% 99.920% ( 170, 250 ] 143 0.030% 99.950% ( 250, 380 ] 83 0.018% 99.968% ( 380, 580 ] 85 0.018% 99.986% ( 580, 870 ] 30 0.006% 99.992% ( 870, 1300 ] 17 0.004% 99.996% ( 1300, 1900 ] 14 0.003% 99.999% ( 1900, 2900 ] 4 0.001% 100.000% ( 2900, 4400 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28279 Average: 2.1360 StdDev: 10.78 Min: 1 Median: 1.3735 Max: 1494 Percentiles: P50: 1.37 P75: 1.79 P99: 6.46 P99.9: 13.66 P99.99: 414.42 ------------------------------------------------------ [ 0, 1 ] 7785 27.529% 27.529% ###### ( 1, 2 ] 17015 60.168% 87.698% ############ ( 2, 3 ] 2039 7.210% 94.908% # ( 3, 4 ] 702 2.482% 97.390% ( 4, 6 ] 424 1.499% 98.890% ( 6, 10 ] 274 0.969% 99.859% ( 10, 15 ] 16 0.057% 99.915% ( 15, 22 ] 6 0.021% 99.936% ( 51, 76 ] 1 0.004% 99.940% ( 76, 110 ] 2 0.007% 99.947% ( 110, 170 ] 7 0.025% 99.972% ( 170, 250 ] 4 0.014% 99.986% ( 250, 380 ] 1 0.004% 99.989% ( 380, 580 ] 1 0.004% 99.993% ( 580, 870 ] 1 0.004% 99.996% ( 1300, 1900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 266894 Average: 3.7226 StdDev: 35.53 Min: 1 Median: 1.6951 Max: 5327 Percentiles: P50: 1.70 P75: 2.38 P99: 9.42 P99.9: 252.74 P99.99: 793.66 ------------------------------------------------------ [ 0, 1 ] 20751 7.775% 7.775% ## ( 1, 2 ] 162133 60.748% 68.523% ############ ( 2, 3 ] 45560 17.070% 85.594% ### ( 3, 4 ] 17365 6.506% 92.100% # ( 4, 6 ] 13807 5.173% 97.273% # ( 6, 10 ] 5384 2.017% 99.290% ( 10, 15 ] 711 0.266% 99.557% ( 15, 22 ] 109 0.041% 99.598% ( 22, 34 ] 25 0.009% 99.607% ( 34, 51 ] 5 0.002% 99.609% ( 51, 76 ] 32 0.012% 99.621% ( 76, 110 ] 158 0.059% 99.680% ( 110, 170 ] 402 0.151% 99.831% ( 170, 250 ] 183 0.069% 99.899% ( 250, 380 ] 100 0.037% 99.937% ( 380, 580 ] 104 0.039% 99.976% ( 580, 870 ] 52 0.019% 99.995% ( 870, 1300 ] 18 0.007% 100.002% ( 1300, 1900 ] 5 0.002% 100.004% ( 1900, 2900 ] 8 0.003% 100.007% ( 2900, 4400 ] 9 0.003% 100.010% ( 4400, 6600 ] 3 0.001% 100.011% ** Level 4 read latency histogram (micros): Count: 115 Average: 416.1652 StdDev: 984.82 Min: 0 Median: 3.3750 Max: 5924 Percentiles: P50: 3.38 P75: 230.00 P99: 4355.00 P99.9: 5924.00 P99.99: 5924.00 ------------------------------------------------------ [ 0, 1 ] 37 32.174% 32.174% ###### ( 1, 2 ] 17 14.783% 46.957% ### ( 2, 3 ] 2 1.739% 48.696% ( 3, 4 ] 4 3.478% 52.174% # ( 4, 6 ] 4 3.478% 55.652% # ( 6, 10 ] 5 4.348% 60.000% # ( 15, 22 ] 2 1.739% 61.739% ( 22, 34 ] 10 8.696% 70.435% ## ( 34, 51 ] 1 0.870% 71.304% ( 110, 170 ] 2 1.739% 73.043% ( 170, 250 ] 3 2.609% 75.652% # ( 250, 380 ] 1 0.870% 76.522% ( 380, 580 ] 7 6.087% 82.609% # ( 580, 870 ] 5 4.348% 86.957% # ( 870, 1300 ] 2 1.739% 88.696% ( 1300, 1900 ] 3 2.609% 91.304% # ( 1900, 2900 ] 4 3.478% 94.783% # ( 2900, 4400 ] 5 4.348% 99.130% # ( 4400, 6600 ] 1 0.870% 100.000% ** Level 5 read latency histogram (micros): Count: 80 Average: 624.9750 StdDev: 809.98 Min: 71 Median: 183.3333 Max: 3583 Percentiles: P50: 183.33 P75: 956.00 P99: 3583.00 P99.9: 3583.00 P99.99: 3583.00 ------------------------------------------------------ ( 51, 76 ] 6 7.500% 7.500% ## ( 76, 110 ] 19 23.750% 31.250% ##### ( 110, 170 ] 14 17.500% 48.750% #### ( 170, 250 ] 6 7.500% 56.250% ## ( 250, 380 ] 3 3.750% 60.000% # ( 380, 580 ] 8 10.000% 70.000% ## ( 580, 870 ] 3 3.750% 73.750% # ( 870, 1300 ] 5 6.250% 80.000% # ( 1300, 1900 ] 11 13.750% 93.750% ### ( 1900, 2900 ] 3 3.750% 97.500% # ( 2900, 4400 ] 2 2.500% 100.000% # ** DB Stats ** Uptime(secs): 27.6 total, 3.1 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 249.35 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:8.317 H:M:S, 30.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 313.22 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.459 H:M:S, 14.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/17-07:56:24 ... thread 0: (1000000,8000000) ops and (51902.7,171257.6) ops/second in (19.266824,46.713252) 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/10 1.91 GB 0.0 6.7 0.0 6.7 14.3 7.6 0.0 1.9 141.6 302.4 48.51 45.49 135 0.359 6971K 9693 0.0 0.0 L1 17/17 1.67 GB 0.0 8.6 5.6 3.0 8.5 5.5 0.1 1.5 222.7 220.0 39.37 36.90 5 7.873 8538K 40K 0.0 0.0 L2 1/0 109.04 MB 1.1 0.1 0.1 0.0 0.1 0.1 3.9 1.8 236.9 236.9 0.47 0.44 1 0.470 113K 24 0.0 0.0 L3 25/9 1.83 GB 1.1 2.9 1.3 1.6 2.9 1.2 2.6 2.3 159.6 158.5 18.45 12.92 10 1.845 2977K 19K 0.0 0.0 L4 186/17 11.00 GB 1.1 1.9 1.7 0.2 1.9 1.7 1.3 1.1 134.1 133.4 14.74 9.25 18 0.819 1988K 9425 0.0 0.0 L5 1060/0 87.11 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1299/53 103.62 GB 0.0 20.2 8.6 11.6 27.7 16.1 9.3 3.6 170.1 233.1 121.54 105.01 169 0.719 20M 79K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.2 8.6 11.6 27.7 16.1 9.2 3.6 170.1 233.1 121.54 105.01 169 0.719 20M 79K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 20.2 8.6 11.6 20.0 8.4 0.0 0.0 209.0 207.5 98.91 84.82 57 1.735 20M 79K 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 345.3 22.62 20.19 112 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 46.9 total, 46.7 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: 27.67 GB write, 604.15 MB/s write, 20.18 GB read, 440.72 MB/s read, 121.5 seconds Interval compaction: 27.67 GB write, 606.49 MB/s write, 20.18 GB read, 442.43 MB/s read, 121.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 24, pending-compaction-bytes-delays: 25, pending-compaction-bytes-stops: 0, total-delays: 41, total-stops: 24, interval: 65 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3318359 Average: 2.7355 StdDev: 22.56 Min: 0 Median: 1.4806 Max: 6263 Percentiles: P50: 1.48 P75: 1.87 P99: 6.11 P99.9: 138.17 P99.99: 425.92 ------------------------------------------------------ [ 0, 1 ] 644186 19.413% 19.413% #### ( 1, 2 ] 2111735 63.638% 83.051% ############# ( 2, 3 ] 328810 9.909% 92.960% ## ( 3, 4 ] 118889 3.583% 96.542% # ( 4, 6 ] 80944 2.439% 98.982% ( 6, 10 ] 21885 0.660% 99.641% ( 10, 15 ] 3403 0.103% 99.744% ( 15, 22 ] 434 0.013% 99.757% ( 22, 34 ] 20 0.001% 99.757% ( 34, 51 ] 12 0.000% 99.758% ( 51, 76 ] 146 0.004% 99.762% ( 76, 110 ] 3151 0.095% 99.857% ( 110, 170 ] 3041 0.092% 99.949% ( 170, 250 ] 687 0.021% 99.969% ( 250, 380 ] 553 0.017% 99.986% ( 380, 580 ] 580 0.017% 100.004% ( 580, 870 ] 380 0.011% 100.015% ( 870, 1300 ] 158 0.005% 100.020% ( 1300, 1900 ] 69 0.002% 100.022% ( 1900, 2900 ] 46 0.001% 100.023% ( 2900, 4400 ] 35 0.001% 100.024% ( 4400, 6600 ] 5 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 1468985 Average: 4.1953 StdDev: 64.96 Min: 1 Median: 1.6099 Max: 11566 Percentiles: P50: 1.61 P75: 2.27 P99: 9.16 P99.9: 131.92 P99.99: 209.11 ------------------------------------------------------ [ 0, 1 ] 246966 16.812% 16.812% ### ( 1, 2 ] 799367 54.416% 71.228% ########### ( 2, 3 ] 206591 14.064% 85.292% ### ( 3, 4 ] 90841 6.184% 91.476% # ( 4, 6 ] 89829 6.115% 97.591% # ( 6, 10 ] 26237 1.786% 99.377% ( 10, 15 ] 4420 0.301% 99.678% ( 15, 22 ] 526 0.036% 99.714% ( 22, 34 ] 39 0.003% 99.716% ( 34, 51 ] 52 0.004% 99.720% ( 51, 76 ] 208 0.014% 99.734% ( 76, 110 ] 1803 0.123% 99.857% ( 110, 170 ] 1746 0.119% 99.975% ( 170, 250 ] 438 0.030% 100.005% ( 250, 380 ] 407 0.028% 100.033% ( 380, 580 ] 372 0.025% 100.058% ( 580, 870 ] 325 0.022% 100.080% ( 870, 1300 ] 208 0.014% 100.095% ( 1300, 1900 ] 95 0.006% 100.101% ( 1900, 2900 ] 88 0.006% 100.107% ( 2900, 4400 ] 152 0.010% 100.117% ( 4400, 6600 ] 51 0.003% 100.121% ( 6600, 9900 ] 22 0.001% 100.122% ( 9900, 14000 ] 2 0.000% 100.123% ** Level 2 read latency histogram (micros): Count: 28279 Average: 2.1360 StdDev: 10.78 Min: 1 Median: 1.3735 Max: 1494 Percentiles: P50: 1.37 P75: 1.79 P99: 6.46 P99.9: 13.66 P99.99: 414.42 ------------------------------------------------------ [ 0, 1 ] 7785 27.529% 27.529% ###### ( 1, 2 ] 17015 60.168% 87.698% ############ ( 2, 3 ] 2039 7.210% 94.908% # ( 3, 4 ] 702 2.482% 97.390% ( 4, 6 ] 424 1.499% 98.890% ( 6, 10 ] 274 0.969% 99.859% ( 10, 15 ] 16 0.057% 99.915% ( 15, 22 ] 6 0.021% 99.936% ( 51, 76 ] 1 0.004% 99.940% ( 76, 110 ] 2 0.007% 99.947% ( 110, 170 ] 7 0.025% 99.972% ( 170, 250 ] 4 0.014% 99.986% ( 250, 380 ] 1 0.004% 99.989% ( 380, 580 ] 1 0.004% 99.993% ( 580, 870 ] 1 0.004% 99.996% ( 1300, 1900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 549111 Average: 6.1058 StdDev: 74.70 Min: 1 Median: 1.8801 Max: 8495 Percentiles: P50: 1.88 P75: 2.89 P99: 9.70 P99.9: 344.54 P99.99: 557.67 ------------------------------------------------------ [ 0, 1 ] 24389 4.442% 4.442% # ( 1, 2 ] 284235 51.763% 56.204% ########## ( 2, 3 ] 116601 21.235% 77.439% #### ( 3, 4 ] 55770 10.156% 87.595% ## ( 4, 6 ] 50657 9.225% 96.820% ## ( 6, 10 ] 12939 2.356% 99.177% ( 10, 15 ] 2320 0.423% 99.599% ( 15, 22 ] 239 0.044% 99.643% ( 22, 34 ] 31 0.006% 99.649% ( 34, 51 ] 11 0.002% 99.651% ( 51, 76 ] 68 0.012% 99.663% ( 76, 110 ] 203 0.037% 99.700% ( 110, 170 ] 509 0.093% 99.793% ( 170, 250 ] 332 0.060% 99.853% ( 250, 380 ] 356 0.065% 99.918% ( 380, 580 ] 447 0.081% 99.999% ( 580, 870 ] 394 0.072% 100.071% ( 870, 1300 ] 252 0.046% 100.117% ( 1300, 1900 ] 133 0.024% 100.141% ( 1900, 2900 ] 67 0.012% 100.153% ( 2900, 4400 ] 75 0.014% 100.167% ( 4400, 6600 ] 20 0.004% 100.171% ( 6600, 9900 ] 3 0.001% 100.171% ** Level 4 read latency histogram (micros): Count: 14641 Average: 13.0568 StdDev: 133.61 Min: 0 Median: 2.2298 Max: 5924 Percentiles: P50: 2.23 P75: 3.45 P99: 164.71 P99.9: 2013.25 P99.99: 3443.41 ------------------------------------------------------ [ 0, 1 ] 197 1.346% 1.346% ( 1, 2 ] 6303 43.050% 44.396% ######### ( 2, 3 ] 3571 24.390% 68.786% ##### ( 3, 4 ] 2016 13.770% 82.556% ### ( 4, 6 ] 1941 13.257% 95.813% ### ( 6, 10 ] 336 2.295% 98.108% ( 10, 15 ] 81 0.553% 98.661% ( 15, 22 ] 9 0.061% 98.723% ( 22, 34 ] 14 0.096% 98.818% ( 34, 51 ] 5 0.034% 98.853% ( 51, 76 ] 1 0.007% 98.859% ( 76, 110 ] 6 0.041% 98.900% ( 110, 170 ] 16 0.109% 99.010% ( 170, 250 ] 28 0.191% 99.201% ( 250, 380 ] 17 0.116% 99.317% ( 380, 580 ] 22 0.150% 99.467% ( 580, 870 ] 29 0.198% 99.665% ( 870, 1300 ] 22 0.150% 99.816% ( 1300, 1900 ] 11 0.075% 99.891% ( 1900, 2900 ] 12 0.082% 99.973% ( 2900, 4400 ] 7 0.048% 100.020% ( 4400, 6600 ] 1 0.007% 100.027% ** Level 5 read latency histogram (micros): Count: 80 Average: 624.9750 StdDev: 809.98 Min: 71 Median: 183.3333 Max: 3583 Percentiles: P50: 183.33 P75: 956.00 P99: 3583.00 P99.9: 3583.00 P99.99: 3583.00 ------------------------------------------------------ ( 51, 76 ] 6 7.500% 7.500% ## ( 76, 110 ] 19 23.750% 31.250% ##### ( 110, 170 ] 14 17.500% 48.750% #### ( 170, 250 ] 6 7.500% 56.250% ## ( 250, 380 ] 3 3.750% 60.000% # ( 380, 580 ] 8 10.000% 70.000% ## ( 580, 870 ] 3 3.750% 73.750% # ( 870, 1300 ] 5 6.250% 80.000% # ( 1300, 1900 ] 11 13.750% 93.750% ### ( 1900, 2900 ] 3 3.750% 97.500% # ( 2900, 4400 ] 2 2.500% 100.000% # ** DB Stats ** Uptime(secs): 46.9 total, 19.3 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 167.89 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:24.176 H:M:S, 51.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 51.08 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.859 H:M:S, 82.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/12/17-07:56:27 ... thread 0: (1000000,9000000) ops and (294854.2,179623.7) ops/second in (3.391507,50.104759) 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/10 2.77 GB 88.1 7.3 0.0 7.3 15.7 8.5 0.0 1.9 138.7 300.7 53.59 49.89 149 0.360 7547K 10K 0.0 0.0 L1 17/17 1.67 GB 0.0 8.6 5.6 3.0 8.5 5.5 0.1 1.5 222.7 220.0 39.37 36.90 5 7.873 8538K 40K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 3.9 1.8 236.9 236.9 0.47 0.44 1 0.470 113K 24 0.0 0.0 L3 14/0 970.71 MB 1.0 2.9 1.3 1.6 2.9 1.2 2.7 2.3 159.6 158.5 18.45 12.92 10 1.845 2977K 19K 0.0 0.0 L4 166/0 9.70 GB 1.0 3.1 2.5 0.5 3.0 2.5 1.3 1.2 137.2 136.5 22.78 14.49 28 0.814 3144K 14K 0.0 0.0 L5 1088/0 89.38 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1301/27 104.48 GB 0.0 21.9 9.5 12.4 30.2 17.8 11.7 3.6 166.2 229.6 134.66 114.66 193 0.698 22M 84K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.9 9.5 12.4 30.2 17.8 11.6 3.6 166.2 229.6 134.66 114.66 193 0.698 22M 84K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 21.9 9.5 12.4 21.7 9.3 0.0 0.0 205.1 203.7 109.11 92.19 69 1.581 22M 84K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 0.0 0.0 0.0 340.3 25.55 22.47 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): 50.3 total, 50.1 interval Flush(GB): cumulative 8.490, interval 8.490 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 30.20 GB write, 614.91 MB/s write, 21.86 GB read, 445.09 MB/s read, 134.7 seconds Interval compaction: 30.20 GB write, 617.13 MB/s write, 21.86 GB read, 446.70 MB/s read, 134.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 36, pending-compaction-bytes-delays: 25, pending-compaction-bytes-stops: 0, total-delays: 41, total-stops: 36, interval: 77 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3647288 Average: 2.7207 StdDev: 21.91 Min: 0 Median: 1.4891 Max: 6263 Percentiles: P50: 1.49 P75: 1.88 P99: 6.31 P99.9: 134.16 P99.99: 396.16 ------------------------------------------------------ [ 0, 1 ] 687344 18.845% 18.845% #### ( 1, 2 ] 2323107 63.694% 82.539% ############# ( 2, 3 ] 372628 10.217% 92.756% ## ( 3, 4 ] 133649 3.664% 96.420% # ( 4, 6 ] 92096 2.525% 98.945% # ( 6, 10 ] 25757 0.706% 99.652% ( 10, 15 ] 3932 0.108% 99.759% ( 15, 22 ] 473 0.013% 99.772% ( 22, 34 ] 24 0.001% 99.773% ( 34, 51 ] 13 0.000% 99.773% ( 51, 76 ] 146 0.004% 99.777% ( 76, 110 ] 3200 0.088% 99.865% ( 110, 170 ] 3161 0.087% 99.952% ( 170, 250 ] 752 0.021% 99.972% ( 250, 380 ] 592 0.016% 99.989% ( 380, 580 ] 622 0.017% 100.006% ( 580, 870 ] 397 0.011% 100.017% ( 870, 1300 ] 164 0.004% 100.021% ( 1300, 1900 ] 69 0.002% 100.023% ( 1900, 2900 ] 47 0.001% 100.024% ( 2900, 4400 ] 37 0.001% 100.025% ( 4400, 6600 ] 5 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 1553118 Average: 4.4075 StdDev: 70.52 Min: 1 Median: 1.6247 Max: 11566 Percentiles: P50: 1.62 P75: 2.32 P99: 9.18 P99.9: 134.35 P99.99: 233.94 ------------------------------------------------------ [ 0, 1 ] 250113 16.104% 16.104% ### ( 1, 2 ] 842742 54.261% 70.365% ########### ( 2, 3 ] 225754 14.536% 84.901% ### ( 3, 4 ] 98812 6.362% 91.263% # ( 4, 6 ] 97370 6.269% 97.532% # ( 6, 10 ] 28635 1.844% 99.376% ( 10, 15 ] 4750 0.306% 99.682% ( 15, 22 ] 565 0.036% 99.718% ( 22, 34 ] 43 0.003% 99.721% ( 34, 51 ] 53 0.003% 99.724% ( 51, 76 ] 208 0.013% 99.738% ( 76, 110 ] 1808 0.116% 99.854% ( 110, 170 ] 1754 0.113% 99.967% ( 170, 250 ] 445 0.029% 99.996% ( 250, 380 ] 420 0.027% 100.023% ( 380, 580 ] 391 0.025% 100.048% ( 580, 870 ] 345 0.022% 100.070% ( 870, 1300 ] 234 0.015% 100.085% ( 1300, 1900 ] 110 0.007% 100.092% ( 1900, 2900 ] 119 0.008% 100.100% ( 2900, 4400 ] 207 0.013% 100.113% ( 4400, 6600 ] 60 0.004% 100.117% ( 6600, 9900 ] 26 0.002% 100.119% ( 9900, 14000 ] 2 0.000% 100.119% ** Level 2 read latency histogram (micros): Count: 28279 Average: 2.1360 StdDev: 10.78 Min: 1 Median: 1.3735 Max: 1494 Percentiles: P50: 1.37 P75: 1.79 P99: 6.46 P99.9: 13.66 P99.99: 414.42 ------------------------------------------------------ [ 0, 1 ] 7785 27.529% 27.529% ###### ( 1, 2 ] 17015 60.168% 87.698% ############ ( 2, 3 ] 2039 7.210% 94.908% # ( 3, 4 ] 702 2.482% 97.390% ( 4, 6 ] 424 1.499% 98.890% ( 6, 10 ] 274 0.969% 99.859% ( 10, 15 ] 16 0.057% 99.915% ( 15, 22 ] 6 0.021% 99.936% ( 51, 76 ] 1 0.004% 99.940% ( 76, 110 ] 2 0.007% 99.947% ( 110, 170 ] 7 0.025% 99.972% ( 170, 250 ] 4 0.014% 99.986% ( 250, 380 ] 1 0.004% 99.989% ( 380, 580 ] 1 0.004% 99.993% ( 580, 870 ] 1 0.004% 99.996% ( 1300, 1900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 683623 Average: 6.7538 StdDev: 90.06 Min: 1 Median: 1.8932 Max: 8495 Percentiles: P50: 1.89 P75: 2.90 P99: 9.62 P99.9: 392.38 P99.99: 640.91 ------------------------------------------------------ [ 0, 1 ] 26722 3.909% 3.909% # ( 1, 2 ] 352750 51.600% 55.509% ########## ( 2, 3 ] 148619 21.740% 77.249% #### ( 3, 4 ] 70836 10.362% 87.611% ## ( 4, 6 ] 64035 9.367% 96.978% ## ( 6, 10 ] 15286 2.236% 99.214% ( 10, 15 ] 2736 0.400% 99.614% ( 15, 22 ] 282 0.041% 99.655% ( 22, 34 ] 37 0.005% 99.661% ( 34, 51 ] 11 0.002% 99.662% ( 51, 76 ] 68 0.010% 99.672% ( 76, 110 ] 205 0.030% 99.702% ( 110, 170 ] 533 0.078% 99.780% ( 170, 250 ] 374 0.055% 99.835% ( 250, 380 ] 412 0.060% 99.895% ( 380, 580 ] 539 0.079% 99.974% ( 580, 870 ] 522 0.076% 100.050% ( 870, 1300 ] 343 0.050% 100.100% ( 1300, 1900 ] 187 0.027% 100.128% ( 1900, 2900 ] 116 0.017% 100.145% ( 2900, 4400 ] 142 0.021% 100.166% ( 4400, 6600 ] 44 0.006% 100.172% ( 6600, 9900 ] 11 0.002% 100.174% ** Level 4 read latency histogram (micros): Count: 39853 Average: 7.6409 StdDev: 93.76 Min: 0 Median: 2.0653 Max: 5924 Percentiles: P50: 2.07 P75: 3.15 P99: 10.10 P99.9: 815.25 P99.99: 1439.14 ------------------------------------------------------ [ 0, 1 ] 488 1.225% 1.225% ( 1, 2 ] 18796 47.163% 48.388% ######### ( 2, 3 ] 9844 24.701% 73.089% ##### ( 3, 4 ] 5094 12.782% 85.871% ### ( 4, 6 ] 4443 11.148% 97.019% ## ( 6, 10 ] 786 1.972% 98.991% ( 10, 15 ] 180 0.452% 99.443% ( 15, 22 ] 13 0.033% 99.476% ( 22, 34 ] 20 0.050% 99.526% ( 34, 51 ] 7 0.018% 99.543% ( 51, 76 ] 1 0.003% 99.546% ( 76, 110 ] 7 0.018% 99.563% ( 110, 170 ] 19 0.048% 99.611% ( 170, 250 ] 45 0.113% 99.724% ( 250, 380 ] 18 0.045% 99.769% ( 380, 580 ] 27 0.068% 99.837% ( 580, 870 ] 31 0.078% 99.915% ( 870, 1300 ] 27 0.068% 99.982% ( 1300, 1900 ] 13 0.033% 100.015% ( 1900, 2900 ] 15 0.038% 100.053% ( 2900, 4400 ] 11 0.028% 100.080% ( 4400, 6600 ] 1 0.003% 100.083% ** Level 5 read latency histogram (micros): Count: 220 Average: 1150.2227 StdDev: 1463.94 Min: 71 Median: 461.8182 Max: 7551 Percentiles: P50: 461.82 P75: 1671.43 P99: 6545.00 P99.9: 7551.00 P99.99: 7551.00 ------------------------------------------------------ ( 51, 76 ] 6 2.727% 2.727% # ( 76, 110 ] 27 12.273% 15.000% ## ( 110, 170 ] 29 13.182% 28.182% ### ( 170, 250 ] 20 9.091% 37.273% ## ( 250, 380 ] 19 8.636% 45.909% ## ( 380, 580 ] 22 10.000% 55.909% ## ( 580, 870 ] 19 8.636% 64.545% ## ( 870, 1300 ] 10 4.545% 69.091% # ( 1300, 1900 ] 21 9.545% 78.636% ## ( 1900, 2900 ] 20 9.091% 87.727% ## ( 2900, 4400 ] 17 7.727% 95.455% ## ( 4400, 6600 ] 8 3.636% 99.091% # ( 6600, 9900 ] 2 0.909% 100.000% ** DB Stats ** Uptime(secs): 50.3 total, 3.4 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 176.14 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:24.735 H:M:S, 49.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 290.19 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.559 H:M:S, 16.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/17-07:56:33 ... thread 0: (1000000,10000000) ops and (180012.7,179662.5) ops/second in (5.555164,55.659923) 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/10 3.81 GB 195.1 8.3 0.0 8.3 17.8 9.5 0.0 1.9 140.0 300.6 60.73 56.62 169 0.359 8634K 11K 0.0 0.0 L1 17/17 1.67 GB 0.0 8.6 5.6 3.0 8.5 5.5 0.1 1.5 222.7 220.0 39.37 36.90 5 7.873 8538K 40K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 3.9 1.8 236.9 236.9 0.47 0.44 1 0.470 113K 24 0.0 0.0 L3 14/0 970.71 MB 1.0 2.9 1.3 1.6 2.9 1.2 2.7 2.3 159.6 158.5 18.45 12.92 10 1.845 2977K 19K 0.0 0.0 L4 166/0 9.70 GB 1.0 3.1 2.5 0.5 3.0 2.5 1.3 1.2 137.2 136.5 22.78 14.49 28 0.814 3144K 14K 0.0 0.0 L5 1088/0 89.38 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1305/27 105.52 GB 0.0 22.9 9.5 13.5 32.3 18.8 11.7 3.4 165.4 233.2 141.80 121.39 213 0.666 23M 86K 0.0 0.0 Int 0/0 0.00 KB 0.0 22.9 9.5 13.5 32.3 18.8 11.6 3.4 165.4 233.2 141.80 121.39 213 0.666 23M 86K 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 22.9 9.5 13.5 22.8 9.3 0.0 0.0 207.2 205.8 113.20 96.20 73 1.551 23M 86K 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 341.5 28.60 25.18 140 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): 55.8 total, 55.7 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: 32.29 GB write, 592.07 MB/s write, 22.90 GB read, 419.99 MB/s read, 141.8 seconds Interval compaction: 32.29 GB write, 594.00 MB/s write, 22.90 GB read, 421.36 MB/s read, 141.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 24, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 24, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 38, pending-compaction-bytes-delays: 25, pending-compaction-bytes-stops: 0, total-delays: 49, total-stops: 38, interval: 87 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4048881 Average: 2.6763 StdDev: 21.09 Min: 0 Median: 1.4877 Max: 6263 Percentiles: P50: 1.49 P75: 1.88 P99: 6.12 P99.9: 129.44 P99.99: 379.61 ------------------------------------------------------ [ 0, 1 ] 758935 18.744% 18.744% #### ( 1, 2 ] 2594630 64.083% 82.827% ############# ( 2, 3 ] 410936 10.149% 92.976% ## ( 3, 4 ] 145243 3.587% 96.564% # ( 4, 6 ] 97829 2.416% 98.980% ( 6, 10 ] 27972 0.691% 99.671% ( 10, 15 ] 4246 0.105% 99.775% ( 15, 22 ] 517 0.013% 99.788% ( 22, 34 ] 26 0.001% 99.789% ( 34, 51 ] 15 0.000% 99.789% ( 51, 76 ] 147 0.004% 99.793% ( 76, 110 ] 3274 0.081% 99.874% ( 110, 170 ] 3278 0.081% 99.955% ( 170, 250 ] 794 0.020% 99.974% ( 250, 380 ] 636 0.016% 99.990% ( 380, 580 ] 653 0.016% 100.006% ( 580, 870 ] 412 0.010% 100.016% ( 870, 1300 ] 167 0.004% 100.020% ( 1300, 1900 ] 74 0.002% 100.022% ( 1900, 2900 ] 49 0.001% 100.024% ( 2900, 4400 ] 37 0.001% 100.024% ( 4400, 6600 ] 5 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 1745390 Average: 4.1839 StdDev: 66.59 Min: 1 Median: 1.6038 Max: 11566 Percentiles: P50: 1.60 P75: 2.22 P99: 9.08 P99.9: 132.98 P99.99: 238.60 ------------------------------------------------------ [ 0, 1 ] 287778 16.488% 16.488% ### ( 1, 2 ] 968737 55.503% 71.991% ########### ( 2, 3 ] 243003 13.923% 85.913% ### ( 3, 4 ] 103863 5.951% 91.864% # ( 4, 6 ] 100620 5.765% 97.629% # ( 6, 10 ] 31111 1.782% 99.411% ( 10, 15 ] 4919 0.282% 99.693% ( 15, 22 ] 591 0.034% 99.727% ( 22, 34 ] 45 0.003% 99.729% ( 34, 51 ] 54 0.003% 99.732% ( 51, 76 ] 232 0.013% 99.746% ( 76, 110 ] 1965 0.113% 99.858% ( 110, 170 ] 1897 0.109% 99.967% ( 170, 250 ] 467 0.027% 99.994% ( 250, 380 ] 441 0.025% 100.019% ( 380, 580 ] 406 0.023% 100.042% ( 580, 870 ] 350 0.020% 100.062% ( 870, 1300 ] 235 0.013% 100.076% ( 1300, 1900 ] 110 0.006% 100.082% ( 1900, 2900 ] 119 0.007% 100.089% ( 2900, 4400 ] 207 0.012% 100.101% ( 4400, 6600 ] 60 0.003% 100.104% ( 6600, 9900 ] 26 0.001% 100.106% ( 9900, 14000 ] 2 0.000% 100.106% ** Level 2 read latency histogram (micros): Count: 28279 Average: 2.1360 StdDev: 10.78 Min: 1 Median: 1.3735 Max: 1494 Percentiles: P50: 1.37 P75: 1.79 P99: 6.46 P99.9: 13.66 P99.99: 414.42 ------------------------------------------------------ [ 0, 1 ] 7785 27.529% 27.529% ###### ( 1, 2 ] 17015 60.168% 87.698% ############ ( 2, 3 ] 2039 7.210% 94.908% # ( 3, 4 ] 702 2.482% 97.390% ( 4, 6 ] 424 1.499% 98.890% ( 6, 10 ] 274 0.969% 99.859% ( 10, 15 ] 16 0.057% 99.915% ( 15, 22 ] 6 0.021% 99.936% ( 51, 76 ] 1 0.004% 99.940% ( 76, 110 ] 2 0.007% 99.947% ( 110, 170 ] 7 0.025% 99.972% ( 170, 250 ] 4 0.014% 99.986% ( 250, 380 ] 1 0.004% 99.989% ( 380, 580 ] 1 0.004% 99.993% ( 580, 870 ] 1 0.004% 99.996% ( 1300, 1900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 683623 Average: 6.7538 StdDev: 90.06 Min: 1 Median: 1.8932 Max: 8495 Percentiles: P50: 1.89 P75: 2.90 P99: 9.62 P99.9: 392.38 P99.99: 640.91 ------------------------------------------------------ [ 0, 1 ] 26722 3.909% 3.909% # ( 1, 2 ] 352750 51.600% 55.509% ########## ( 2, 3 ] 148619 21.740% 77.249% #### ( 3, 4 ] 70836 10.362% 87.611% ## ( 4, 6 ] 64035 9.367% 96.978% ## ( 6, 10 ] 15286 2.236% 99.214% ( 10, 15 ] 2736 0.400% 99.614% ( 15, 22 ] 282 0.041% 99.655% ( 22, 34 ] 37 0.005% 99.661% ( 34, 51 ] 11 0.002% 99.662% ( 51, 76 ] 68 0.010% 99.672% ( 76, 110 ] 205 0.030% 99.702% ( 110, 170 ] 533 0.078% 99.780% ( 170, 250 ] 374 0.055% 99.835% ( 250, 380 ] 412 0.060% 99.895% ( 380, 580 ] 539 0.079% 99.974% ( 580, 870 ] 522 0.076% 100.050% ( 870, 1300 ] 343 0.050% 100.100% ( 1300, 1900 ] 187 0.027% 100.128% ( 1900, 2900 ] 116 0.017% 100.145% ( 2900, 4400 ] 142 0.021% 100.166% ( 4400, 6600 ] 44 0.006% 100.172% ( 6600, 9900 ] 11 0.002% 100.174% ** Level 4 read latency histogram (micros): Count: 39853 Average: 7.6409 StdDev: 93.76 Min: 0 Median: 2.0653 Max: 5924 Percentiles: P50: 2.07 P75: 3.15 P99: 10.10 P99.9: 815.25 P99.99: 1439.14 ------------------------------------------------------ [ 0, 1 ] 488 1.225% 1.225% ( 1, 2 ] 18796 47.163% 48.388% ######### ( 2, 3 ] 9844 24.701% 73.089% ##### ( 3, 4 ] 5094 12.782% 85.871% ### ( 4, 6 ] 4443 11.148% 97.019% ## ( 6, 10 ] 786 1.972% 98.991% ( 10, 15 ] 180 0.452% 99.443% ( 15, 22 ] 13 0.033% 99.476% ( 22, 34 ] 20 0.050% 99.526% ( 34, 51 ] 7 0.018% 99.543% ( 51, 76 ] 1 0.003% 99.546% ( 76, 110 ] 7 0.018% 99.563% ( 110, 170 ] 19 0.048% 99.611% ( 170, 250 ] 45 0.113% 99.724% ( 250, 380 ] 18 0.045% 99.769% ( 380, 580 ] 27 0.068% 99.837% ( 580, 870 ] 31 0.078% 99.915% ( 870, 1300 ] 27 0.068% 99.982% ( 1300, 1900 ] 13 0.033% 100.015% ( 1900, 2900 ] 15 0.038% 100.053% ( 2900, 4400 ] 11 0.028% 100.080% ( 4400, 6600 ] 1 0.003% 100.083% ** Level 5 read latency histogram (micros): Count: 220 Average: 1150.2227 StdDev: 1463.94 Min: 71 Median: 461.8182 Max: 7551 Percentiles: P50: 461.82 P75: 1671.43 P99: 6545.00 P99.9: 7551.00 P99.99: 7551.00 ------------------------------------------------------ ( 51, 76 ] 6 2.727% 2.727% # ( 76, 110 ] 27 12.273% 15.000% ## ( 110, 170 ] 29 13.182% 28.182% ### ( 170, 250 ] 20 9.091% 37.273% ## ( 250, 380 ] 19 8.636% 45.909% ## ( 380, 580 ] 22 10.000% 55.909% ## ( 580, 870 ] 19 8.636% 64.545% ## ( 870, 1300 ] 10 4.545% 69.091% # ( 1300, 1900 ] 21 9.545% 78.636% ## ( 1900, 2900 ] 20 9.091% 87.727% ## ( 2900, 4400 ] 17 7.727% 95.455% ## ( 4400, 6600 ] 8 3.636% 99.091% # ( 6600, 9900 ] 2 0.909% 100.000% ** DB Stats ** Uptime(secs): 55.8 total, 5.6 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 176.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:27.489 H:M:S, 49.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 177.13 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.755 H:M:S, 49.6 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.887 micros/op 169864 ops/sec 60.095 seconds 10207999 operations; 164.6 MB/s Microseconds per write: Count: 10207999 Average: 5.8870 StdDev: 258.15 Min: 1 Median: 1.7703 Max: 274014 Percentiles: P50: 1.77 P75: 2.83 P99: 9.89 P99.9: 1151.89 P99.99: 2659.63 ------------------------------------------------------ [ 0, 1 ] 1157380 11.338% 11.338% ## ( 1, 2 ] 5123501 50.191% 61.529% ########## ( 2, 3 ] 1662403 16.285% 77.814% ### ( 3, 4 ] 1433125 14.039% 91.854% ### ( 4, 6 ] 582152 5.703% 97.556% # ( 6, 10 ] 151476 1.484% 99.040% ( 10, 15 ] 52239 0.512% 99.552% ( 15, 22 ] 10780 0.106% 99.658% ( 22, 34 ] 1831 0.018% 99.676% ( 34, 51 ] 251 0.002% 99.678% ( 51, 76 ] 25 0.000% 99.678% ( 76, 110 ] 7172 0.070% 99.749% ( 110, 170 ] 2695 0.026% 99.775% ( 170, 250 ] 290 0.003% 99.778% ( 250, 380 ] 209 0.002% 99.780% ( 380, 580 ] 26 0.000% 99.780% ( 580, 870 ] 13 0.000% 99.780% ( 870, 1300 ] 18645 0.183% 99.963% ( 1300, 1900 ] 67 0.001% 99.964% ( 1900, 2900 ] 3552 0.035% 99.998% ( 2900, 4400 ] 110 0.001% 99.999% ( 4400, 6600 ] 25 0.000% 100.000% ( 6600, 9900 ] 8 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 14000, 22000 ] 5 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 13 0.000% 100.000% ( 250000, 380000 ] 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 : 205522 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 : 10207999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10534654968 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 : 502 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31191342 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 : 29196170408 rocksdb.compact.write.bytes COUNT : 28999439174 rocksdb.flush.write.bytes COUNT : 10503230897 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 : 53 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 : 201 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 : 10418396160 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3917824 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 : 29290386523 rocksdb.non.last.level.read.count COUNT : 7077933 rocksdb.block.checksum.compute.count COUNT : 7076982 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.441908 P95 : 3.983478 P99 : 8.636447 P100 : 274008.000000 COUNT : 10207999 SUM : 55227476 rocksdb.compaction.times.micros P50 : 1030000.000000 P95 : 3506666.666667 P99 : 16080000.000000 P100 : 19078012.000000 COUNT : 74 SUM : 114157038 rocksdb.compaction.times.cpu_micros P50 : 918285.714286 P95 : 3506666.666667 P99 : 16080000.000000 P100 : 17550298.000000 COUNT : 74 SUM : 97149673 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 : 704.767442 P95 : 1178.818182 P99 : 1291.400000 P100 : 21362.000000 COUNT : 144 SUM : 119286 rocksdb.compaction.outfile.sync.micros P50 : 898.841463 P95 : 155857.142857 P99 : 236685.714286 P100 : 292809.000000 COUNT : 333 SUM : 6056516 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 : 93.988372 P95 : 855.500000 P99 : 3856.250000 P100 : 4787.000000 COUNT : 245 SUM : 58736 rocksdb.table.open.io.micros P50 : 1334.285714 P95 : 7212.857143 P99 : 11936.333333 P100 : 18681.000000 COUNT : 502 SUM : 1022207 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.592431 P95 : 7.309017 P99 : 10.250552 P100 : 11572.000000 COUNT : 7075628 SUM : 39434280 rocksdb.read.block.get.micros P50 : 440.952381 P95 : 3364.705882 P99 : 5309.333333 P100 : 7633.000000 COUNT : 1004 SUM : 844878 rocksdb.write.raw.block.micros P50 : 0.512426 P95 : 0.973609 P99 : 2.901058 P100 : 16377.000000 COUNT : 9568852 SUM : 17571936 rocksdb.numfiles.in.singlecompaction P50 : 3.305556 P95 : 8.000000 P99 : 26.800000 P100 : 27.000000 COUNT : 120 SUM : 499 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.561485 P95 : 1148.761204 P99 : 2358.620592 P100 : 273765.000000 COUNT : 205919 SUM : 31213335 rocksdb.sst.read.micros P50 : 1.551947 P95 : 4.317601 P99 : 8.349936 P100 : 11566.000000 COUNT : 7078254 SUM : 25060790 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 : 10207999 SUM : 10534654968 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 : 212711.864407 P95 : 341000.000000 P99 : 478800.000000 P100 : 482563.000000 COUNT : 144 SUM : 29284566 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 : 320 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