[2024-12-15 05:12:39.731073] Starting SPDK v25.01-pre git sha1 e01cb43b8 / DPDK 22.11.4 initialization... [2024-12-15 05:12:39.731354] [ 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_pid181868 ] Set seed to 1734235959724368 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-15 05:12:39.849049] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-15 05:12:39.872401] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-15 05:12:39.872443] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 181868' to capture a snapshot of events at runtime. [2024-12-15 05:12:39.872454] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-15 05:12:39.872480] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-15 05:12:39.872488] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid181868 for offline analysis/debug. [2024-12-15 05:12:39.873067] reactor.c: 995:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sun Dec 15 05:12:44 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/15-05:12:46 ... thread 0: (1000000,1000000) ops and (355261.5,355261.5) ops/second in (2.814828,2.814828) 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 6/4 378.00 MB 12.6 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 347.2 2.36 2.11 12 0.197 0 0 0.0 0.0 L1 4/0 251.75 MB 25.2 0.2 0.2 0.0 0.2 0.2 0.2 1.0 239.0 238.7 1.05 1.01 1 1.055 255K 238 0.0 0.0 L2 3/2 188.89 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.1 1.5 238.5 238.4 0.79 0.76 1 0.792 191K 75 0.0 0.0 L3 12/0 993.39 MB 1.0 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 85.57 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1181/6 96.94 GB 0.0 0.4 0.4 0.1 1.2 1.2 0.4 1.5 104.9 299.5 4.21 3.88 14 0.300 447K 313 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.4 0.1 1.2 1.2 0.4 1.5 104.9 299.5 4.21 3.88 14 0.300 447K 313 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.4 0.1 0.4 0.4 0.0 0.0 238.8 238.6 1.85 1.77 2 0.923 447K 313 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 347.2 2.36 2.11 12 0.197 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.23 GB write, 413.49 MB/s write, 0.43 GB read, 144.76 MB/s read, 4.2 seconds Interval compaction: 1.23 GB write, 447.21 MB/s write, 0.43 GB read, 156.56 MB/s read, 4.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 1, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 1, interval: 1 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 141988 Average: 2.0234 StdDev: 15.67 Min: 0 Median: 1.3431 Max: 3449 Percentiles: P50: 1.34 P75: 1.77 P99: 5.34 P99.9: 9.87 P99.99: 21.44 ------------------------------------------------------ [ 0, 1 ] 42204 29.724% 29.724% ###### ( 1, 2 ] 83922 59.105% 88.829% ############ ( 2, 3 ] 9017 6.351% 95.179% # ( 3, 4 ] 3872 2.727% 97.906% # ( 4, 6 ] 2323 1.636% 99.542% ( 6, 10 ] 526 0.370% 99.913% ( 10, 15 ] 97 0.068% 99.981% ( 15, 22 ] 15 0.011% 99.992% ( 22, 34 ] 3 0.002% 99.994% ( 34, 51 ] 2 0.001% 99.995% ( 51, 76 ] 3 0.002% 99.997% ( 110, 170 ] 7 0.005% 100.002% ( 170, 250 ] 6 0.004% 100.006% ( 250, 380 ] 5 0.004% 100.010% ( 380, 580 ] 1 0.001% 100.011% ( 1300, 1900 ] 1 0.001% 100.011% ( 1900, 2900 ] 2 0.001% 100.013% ( 2900, 4400 ] 2 0.001% 100.014% ** Level 1 read latency histogram (micros): Count: 20 Average: 155.7000 StdDev: 347.95 Min: 1 Median: 1.6000 Max: 1164 Percentiles: P50: 1.60 P75: 22.00 P99: 1164.00 P99.9: 1164.00 P99.99: 1164.00 ------------------------------------------------------ [ 0, 1 ] 7 35.000% 35.000% ####### ( 1, 2 ] 5 25.000% 60.000% ##### ( 2, 3 ] 1 5.000% 65.000% # ( 3, 4 ] 1 5.000% 70.000% # ( 15, 22 ] 1 5.000% 75.000% # ( 110, 170 ] 1 5.000% 80.000% # ( 170, 250 ] 1 5.000% 85.000% # ( 250, 380 ] 1 5.000% 90.000% # ( 870, 1300 ] 2 10.000% 100.000% ## ** Level 2 read latency histogram (micros): Count: 29506 Average: 2.7171 StdDev: 25.37 Min: 1 Median: 1.5599 Max: 2739 Percentiles: P50: 1.56 P75: 1.93 P99: 6.35 P99.9: 13.37 P99.99: 1607.41 ------------------------------------------------------ [ 0, 1 ] 3727 12.631% 12.631% ### ( 1, 2 ] 19693 66.742% 79.374% ############# ( 2, 3 ] 3153 10.686% 90.060% ## ( 3, 4 ] 1470 4.982% 95.042% # ( 4, 6 ] 1144 3.877% 98.919% # ( 6, 10 ] 276 0.935% 99.854% ( 10, 15 ] 20 0.068% 99.922% ( 15, 22 ] 7 0.024% 99.946% ( 34, 51 ] 1 0.003% 99.949% ( 51, 76 ] 1 0.003% 99.953% ( 110, 170 ] 1 0.003% 99.956% ( 170, 250 ] 2 0.007% 99.963% ( 250, 380 ] 1 0.003% 99.966% ( 380, 580 ] 2 0.007% 99.973% ( 580, 870 ] 1 0.003% 99.976% ( 870, 1300 ] 2 0.007% 99.983% ( 1300, 1900 ] 4 0.014% 99.997% ( 1900, 2900 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 50 Average: 1680.3600 StdDev: 1303.93 Min: 119 Median: 1300.0000 Max: 4421 Percentiles: P50: 1300.00 P75: 2733.33 P99: 4421.00 P99.9: 4421.00 P99.99: 4421.00 ------------------------------------------------------ ( 110, 170 ] 2 4.000% 4.000% # ( 170, 250 ] 4 8.000% 12.000% ## ( 250, 380 ] 5 10.000% 22.000% ## ( 380, 580 ] 5 10.000% 32.000% ## ( 580, 870 ] 2 4.000% 36.000% # ( 870, 1300 ] 7 14.000% 50.000% ### ( 1300, 1900 ] 5 10.000% 60.000% ## ( 1900, 2900 ] 9 18.000% 78.000% #### ( 2900, 4400 ] 10 20.000% 98.000% #### ( 4400, 6600 ] 1 2.000% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 1578.2000 StdDev: 1203.19 Min: 198 Median: 1228.3333 Max: 5166 Percentiles: P50: 1228.33 P75: 1900.00 P99: 5166.00 P99.9: 5166.00 P99.99: 5166.00 ------------------------------------------------------ ( 170, 250 ] 1 5.000% 5.000% # ( 250, 380 ] 2 10.000% 15.000% ## ( 380, 580 ] 1 5.000% 20.000% # ( 580, 870 ] 1 5.000% 25.000% # ( 870, 1300 ] 6 30.000% 55.000% ###### ( 1300, 1900 ] 4 20.000% 75.000% #### ( 1900, 2900 ] 1 5.000% 80.000% # ( 2900, 4400 ] 3 15.000% 95.000% ### ( 4400, 6600 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 323.05 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.216 H:M:S, 7.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 349.30 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.216 H:M:S, 7.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/15-05:12:50 ... thread 0: (1000000,2000000) ops and (319293.5,336318.6) ops/second in (3.131915,5.946743) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/10 1.35 GB 12.6 0.8 0.0 0.8 2.6 1.8 0.0 1.4 98.2 317.2 8.34 7.70 29 0.288 831K 827 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 239.0 238.7 1.05 1.01 1 1.055 255K 238 0.0 0.0 L2 2/1 82.16 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.3 1.5 231.8 231.7 0.83 0.80 2 0.417 196K 82 0.0 0.0 L3 17/8 805.80 MB 0.2 0.2 0.2 0.0 0.2 0.2 0.3 1.0 224.9 224.9 0.83 0.77 1 0.831 189K 0 0.0 0.0 L4 169/0 9.51 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 132.0 132.0 1.27 0.89 1 1.274 170K 0 0.0 0.0 L5 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1247/19 97.92 GB 0.0 1.6 0.7 0.9 3.4 2.5 1.8 1.9 131.3 279.3 12.33 11.18 34 0.363 1644K 1147 0.0 0.0 Int 0/0 0.00 KB 0.0 1.6 0.7 0.9 3.4 2.5 1.8 1.9 131.3 279.3 12.33 11.18 34 0.363 1644K 1147 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.6 0.7 0.9 1.6 0.7 0.0 0.0 227.3 227.2 7.12 6.55 8 0.890 1644K 1147 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 350.7 5.21 4.63 26 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.2 total, 5.9 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.36 GB write, 557.65 MB/s write, 1.58 GB read, 262.13 MB/s read, 12.3 seconds Interval compaction: 3.36 GB write, 579.18 MB/s write, 1.58 GB read, 272.25 MB/s read, 12.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: 6, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 6, interval: 6 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 380804 Average: 2.1858 StdDev: 13.41 Min: 0 Median: 1.4704 Max: 3449 Percentiles: P50: 1.47 P75: 1.86 P99: 5.61 P99.9: 9.78 P99.99: 21.18 ------------------------------------------------------ [ 0, 1 ] 76395 20.062% 20.062% #### ( 1, 2 ] 242389 63.652% 83.713% ############# ( 2, 3 ] 36690 9.635% 93.348% ## ( 3, 4 ] 14305 3.757% 97.105% # ( 4, 6 ] 8961 2.353% 99.458% ( 6, 10 ] 1784 0.468% 99.926% ( 10, 15 ] 214 0.056% 99.983% ( 15, 22 ] 35 0.009% 99.992% ( 22, 34 ] 7 0.002% 99.994% ( 34, 51 ] 6 0.002% 99.995% ( 51, 76 ] 3 0.001% 99.996% ( 76, 110 ] 1 0.000% 99.996% ( 110, 170 ] 15 0.004% 100.000% ( 170, 250 ] 9 0.002% 100.003% ( 250, 380 ] 10 0.003% 100.005% ( 380, 580 ] 3 0.001% 100.006% ( 580, 870 ] 8 0.002% 100.008% ( 870, 1300 ] 5 0.001% 100.009% ( 1300, 1900 ] 2 0.001% 100.010% ( 1900, 2900 ] 2 0.001% 100.011% ( 2900, 4400 ] 4 0.001% 100.012% ** Level 1 read latency histogram (micros): Count: 667 Average: 7.9250 StdDev: 65.64 Min: 1 Median: 2.4694 Max: 1164 Percentiles: P50: 2.47 P75: 3.55 P99: 14.52 P99.9: 1156.60 P99.99: 1164.00 ------------------------------------------------------ [ 0, 1 ] 16 2.399% 2.399% ( 1, 2 ] 233 34.933% 37.331% ####### ( 2, 3 ] 180 26.987% 64.318% ##### ( 3, 4 ] 130 19.490% 83.808% #### ( 4, 6 ] 65 9.745% 93.553% ## ( 6, 10 ] 30 4.498% 98.051% # ( 10, 15 ] 7 1.049% 99.100% ( 15, 22 ] 1 0.150% 99.250% ( 110, 170 ] 1 0.150% 99.400% ( 170, 250 ] 1 0.150% 99.550% ( 250, 380 ] 1 0.150% 99.700% ( 870, 1300 ] 2 0.300% 100.000% ** Level 2 read latency histogram (micros): Count: 70408 Average: 2.7800 StdDev: 19.25 Min: 1 Median: 1.5617 Max: 2739 Percentiles: P50: 1.56 P75: 1.93 P99: 7.29 P99.9: 146.90 P99.99: 693.63 ------------------------------------------------------ [ 0, 1 ] 8587 12.196% 12.196% ## ( 1, 2 ] 47383 67.298% 79.494% ############# ( 2, 3 ] 8306 11.797% 91.291% ## ( 3, 4 ] 3052 4.335% 95.625% # ( 4, 6 ] 2140 3.039% 98.665% # ( 6, 10 ] 731 1.038% 99.703% ( 10, 15 ] 56 0.080% 99.783% ( 15, 22 ] 11 0.016% 99.798% ( 34, 51 ] 2 0.003% 99.801% ( 51, 76 ] 2 0.003% 99.804% ( 76, 110 ] 27 0.038% 99.842% ( 110, 170 ] 66 0.094% 99.936% ( 170, 250 ] 16 0.023% 99.959% ( 250, 380 ] 8 0.011% 99.970% ( 380, 580 ] 12 0.017% 99.987% ( 580, 870 ] 5 0.007% 99.994% ( 870, 1300 ] 2 0.003% 99.997% ( 1300, 1900 ] 4 0.006% 100.003% ( 1900, 2900 ] 1 0.001% 100.004% ** Level 3 read latency histogram (micros): Count: 170627 Average: 3.5922 StdDev: 40.04 Min: 1 Median: 1.6950 Max: 4421 Percentiles: P50: 1.70 P75: 2.33 P99: 8.90 P99.9: 169.49 P99.99: 502.44 ------------------------------------------------------ [ 0, 1 ] 13359 7.829% 7.829% ## ( 1, 2 ] 103531 60.677% 68.506% ############ ( 2, 3 ] 33230 19.475% 87.981% #### ( 3, 4 ] 8947 5.244% 93.225% # ( 4, 6 ] 7752 4.543% 97.768% # ( 6, 10 ] 2900 1.700% 99.468% ( 10, 15 ] 353 0.207% 99.675% ( 15, 22 ] 91 0.053% 99.728% ( 22, 34 ] 23 0.013% 99.742% ( 34, 51 ] 10 0.006% 99.747% ( 51, 76 ] 4 0.002% 99.750% ( 76, 110 ] 68 0.040% 99.790% ( 110, 170 ] 190 0.111% 99.901% ( 170, 250 ] 73 0.043% 99.944% ( 250, 380 ] 52 0.030% 99.974% ( 380, 580 ] 44 0.026% 100.000% ( 580, 870 ] 21 0.012% 100.012% ( 870, 1300 ] 12 0.007% 100.019% ( 1300, 1900 ] 6 0.004% 100.023% ( 1900, 2900 ] 9 0.005% 100.028% ( 2900, 4400 ] 11 0.006% 100.035% ( 4400, 6600 ] 1 0.001% 100.035% ** Level 4 read latency histogram (micros): Count: 305 Average: 109.8590 StdDev: 497.38 Min: 1 Median: 1.8915 Max: 5166 Percentiles: P50: 1.89 P75: 5.29 P99: 3375.00 P99.9: 5166.00 P99.99: 5166.00 ------------------------------------------------------ [ 0, 1 ] 58 19.016% 19.016% #### ( 1, 2 ] 106 34.754% 53.770% ####### ( 2, 3 ] 49 16.066% 69.836% ### ( 3, 4 ] 8 2.623% 72.459% # ( 4, 6 ] 12 3.934% 76.393% # ( 6, 10 ] 24 7.869% 84.262% ## ( 10, 15 ] 19 6.230% 90.492% # ( 15, 22 ] 5 1.639% 92.131% ( 22, 34 ] 1 0.328% 92.459% ( 76, 110 ] 1 0.328% 92.787% ( 170, 250 ] 1 0.328% 93.115% ( 250, 380 ] 3 0.984% 94.098% ( 380, 580 ] 2 0.656% 94.754% ( 580, 870 ] 1 0.328% 95.082% ( 870, 1300 ] 6 1.967% 97.049% ( 1300, 1900 ] 4 1.311% 98.361% ( 1900, 2900 ] 1 0.328% 98.689% ( 2900, 4400 ] 3 0.984% 99.672% ( 4400, 6600 ] 1 0.328% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 707.1500 StdDev: 1001.63 Min: 87 Median: 158.0000 Max: 4272 Percentiles: P50: 158.00 P75: 1085.00 P99: 4200.00 P99.9: 4272.00 P99.99: 4272.00 ------------------------------------------------------ ( 76, 110 ] 8 20.000% 20.000% #### ( 110, 170 ] 15 37.500% 57.500% ######## ( 250, 380 ] 1 2.500% 60.000% # ( 380, 580 ] 4 10.000% 70.000% ## ( 580, 870 ] 1 2.500% 72.500% # ( 870, 1300 ] 2 5.000% 77.500% # ( 1300, 1900 ] 5 12.500% 90.000% ### ( 1900, 2900 ] 1 2.500% 92.500% # ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 6.2 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 318.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.674 H:M:S, 10.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 314.24 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: 3 num-running-flushes: 1 2024/12/15-05:12:53 ... thread 0: (1000000,3000000) ops and (325652.7,332686.5) ops/second in (3.070756,9.017499) 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.34 GB 107.0 1.6 0.0 1.6 4.4 2.8 0.0 1.6 114.3 312.0 14.33 13.32 46 0.312 1663K 1720 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 239.0 238.7 1.05 1.01 1 1.055 255K 238 0.0 0.0 L2 1/0 77.70 MB 0.8 0.2 0.1 0.1 0.2 0.1 0.3 1.5 231.8 231.7 0.83 0.80 2 0.417 196K 82 0.0 0.0 L3 14/0 807.46 MB 0.8 0.8 0.2 0.6 0.8 0.2 0.3 4.2 223.2 222.5 3.61 3.37 2 1.807 819K 2836 0.0 0.0 L4 169/0 9.51 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 132.0 132.0 1.27 0.89 1 1.274 170K 0 0.0 0.0 L5 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1248/10 98.90 GB 0.0 3.0 0.7 2.3 5.8 3.5 1.8 2.1 144.9 279.0 21.11 19.39 52 0.406 3105K 4876 0.0 0.0 Int 0/0 0.00 KB 0.0 3.0 0.7 2.3 5.8 3.5 1.8 2.1 144.9 279.0 21.11 19.39 52 0.406 3105K 4876 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.0 0.7 2.3 3.0 0.7 0.0 0.0 234.9 234.5 13.02 12.21 12 1.085 3105K 4876 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 350.4 8.09 7.19 40 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): 9.2 total, 9.0 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.75 GB write, 636.64 MB/s write, 2.99 GB read, 330.67 MB/s read, 21.1 seconds Interval compaction: 5.75 GB write, 652.86 MB/s write, 2.99 GB read, 339.09 MB/s read, 21.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 11, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 797108 Average: 2.2019 StdDev: 11.57 Min: 0 Median: 1.5000 Max: 3449 Percentiles: P50: 1.50 P75: 1.88 P99: 5.55 P99.9: 9.64 P99.99: 14.47 ------------------------------------------------------ [ 0, 1 ] 134115 16.825% 16.825% ### ( 1, 2 ] 528837 66.344% 83.170% ############# ( 2, 3 ] 83576 10.485% 93.655% ## ( 3, 4 ] 28522 3.578% 97.233% # ( 4, 6 ] 18175 2.280% 99.513% ( 6, 10 ] 3391 0.425% 99.938% ( 10, 15 ] 463 0.058% 99.996% ( 15, 22 ] 54 0.007% 100.003% ( 22, 34 ] 13 0.002% 100.005% ( 34, 51 ] 7 0.001% 100.006% ( 51, 76 ] 7 0.001% 100.007% ( 76, 110 ] 8 0.001% 100.008% ( 110, 170 ] 47 0.006% 100.013% ( 170, 250 ] 17 0.002% 100.016% ( 250, 380 ] 19 0.002% 100.018% ( 380, 580 ] 11 0.001% 100.019% ( 580, 870 ] 14 0.002% 100.021% ( 870, 1300 ] 8 0.001% 100.022% ( 1300, 1900 ] 4 0.001% 100.023% ( 1900, 2900 ] 4 0.001% 100.023% ( 2900, 4400 ] 5 0.001% 100.024% ** Level 1 read latency histogram (micros): Count: 667 Average: 7.9250 StdDev: 65.64 Min: 1 Median: 2.4694 Max: 1164 Percentiles: P50: 2.47 P75: 3.55 P99: 14.52 P99.9: 1156.60 P99.99: 1164.00 ------------------------------------------------------ [ 0, 1 ] 16 2.399% 2.399% ( 1, 2 ] 233 34.933% 37.331% ####### ( 2, 3 ] 180 26.987% 64.318% ##### ( 3, 4 ] 130 19.490% 83.808% #### ( 4, 6 ] 65 9.745% 93.553% ## ( 6, 10 ] 30 4.498% 98.051% # ( 10, 15 ] 7 1.049% 99.100% ( 15, 22 ] 1 0.150% 99.250% ( 110, 170 ] 1 0.150% 99.400% ( 170, 250 ] 1 0.150% 99.550% ( 250, 380 ] 1 0.150% 99.700% ( 870, 1300 ] 2 0.300% 100.000% ** Level 2 read latency histogram (micros): Count: 77413 Average: 2.7504 StdDev: 18.36 Min: 1 Median: 1.5706 Max: 2739 Percentiles: P50: 1.57 P75: 1.94 P99: 7.36 P99.9: 140.53 P99.99: 653.00 ------------------------------------------------------ [ 0, 1 ] 8983 11.604% 11.604% ## ( 1, 2 ] 52088 67.286% 78.890% ############# ( 2, 3 ] 9411 12.157% 91.047% ## ( 3, 4 ] 3447 4.453% 95.499% # ( 4, 6 ] 2422 3.129% 98.628% # ( 6, 10 ] 844 1.090% 99.718% ( 10, 15 ] 62 0.080% 99.798% ( 15, 22 ] 14 0.018% 99.817% ( 34, 51 ] 2 0.003% 99.819% ( 51, 76 ] 2 0.003% 99.822% ( 76, 110 ] 27 0.035% 99.857% ( 110, 170 ] 66 0.085% 99.942% ( 170, 250 ] 16 0.021% 99.963% ( 250, 380 ] 8 0.010% 99.973% ( 380, 580 ] 12 0.016% 99.988% ( 580, 870 ] 5 0.006% 99.995% ( 870, 1300 ] 2 0.003% 99.997% ( 1300, 1900 ] 4 0.005% 100.003% ( 1900, 2900 ] 1 0.001% 100.004% ** Level 3 read latency histogram (micros): Count: 170652 Average: 3.6371 StdDev: 40.63 Min: 1 Median: 1.6950 Max: 4421 Percentiles: P50: 1.70 P75: 2.33 P99: 8.91 P99.9: 179.15 P99.99: 526.67 ------------------------------------------------------ [ 0, 1 ] 13367 7.833% 7.833% ## ( 1, 2 ] 103536 60.671% 68.504% ############ ( 2, 3 ] 33232 19.474% 87.977% #### ( 3, 4 ] 8947 5.243% 93.220% # ( 4, 6 ] 7752 4.543% 97.763% # ( 6, 10 ] 2900 1.699% 99.462% ( 10, 15 ] 353 0.207% 99.669% ( 15, 22 ] 91 0.053% 99.722% ( 22, 34 ] 23 0.013% 99.736% ( 34, 51 ] 10 0.006% 99.742% ( 51, 76 ] 4 0.002% 99.744% ( 76, 110 ] 68 0.040% 99.784% ( 110, 170 ] 190 0.111% 99.895% ( 170, 250 ] 73 0.043% 99.938% ( 250, 380 ] 53 0.031% 99.969% ( 380, 580 ] 49 0.029% 99.998% ( 580, 870 ] 21 0.012% 100.010% ( 870, 1300 ] 14 0.008% 100.018% ( 1300, 1900 ] 8 0.005% 100.023% ( 1900, 2900 ] 9 0.005% 100.028% ( 2900, 4400 ] 11 0.006% 100.035% ( 4400, 6600 ] 1 0.001% 100.035% ** Level 4 read latency histogram (micros): Count: 305 Average: 109.8590 StdDev: 497.38 Min: 1 Median: 1.8915 Max: 5166 Percentiles: P50: 1.89 P75: 5.29 P99: 3375.00 P99.9: 5166.00 P99.99: 5166.00 ------------------------------------------------------ [ 0, 1 ] 58 19.016% 19.016% #### ( 1, 2 ] 106 34.754% 53.770% ####### ( 2, 3 ] 49 16.066% 69.836% ### ( 3, 4 ] 8 2.623% 72.459% # ( 4, 6 ] 12 3.934% 76.393% # ( 6, 10 ] 24 7.869% 84.262% ## ( 10, 15 ] 19 6.230% 90.492% # ( 15, 22 ] 5 1.639% 92.131% ( 22, 34 ] 1 0.328% 92.459% ( 76, 110 ] 1 0.328% 92.787% ( 170, 250 ] 1 0.328% 93.115% ( 250, 380 ] 3 0.984% 94.098% ( 380, 580 ] 2 0.656% 94.754% ( 580, 870 ] 1 0.328% 95.082% ( 870, 1300 ] 6 1.967% 97.049% ( 1300, 1900 ] 4 1.311% 98.361% ( 1900, 2900 ] 1 0.328% 98.689% ( 2900, 4400 ] 3 0.984% 99.672% ( 4400, 6600 ] 1 0.328% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 707.1500 StdDev: 1001.63 Min: 87 Median: 158.0000 Max: 4272 Percentiles: P50: 158.00 P75: 1085.00 P99: 4200.00 P99.9: 4272.00 P99.99: 4272.00 ------------------------------------------------------ ( 76, 110 ] 8 20.000% 20.000% #### ( 110, 170 ] 15 37.500% 57.500% ######## ( 250, 380 ] 1 2.500% 60.000% # ( 380, 580 ] 4 10.000% 70.000% ## ( 580, 870 ] 1 2.500% 72.500% # ( 870, 1300 ] 2 5.000% 77.500% # ( 1300, 1900 ] 5 12.500% 90.000% ### ( 1900, 2900 ] 1 2.500% 92.500% # ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 9.2 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 319.22 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.085 H:M:S, 11.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.51 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.411 H:M:S, 13.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/15-05:12:56 ... thread 0: (1000000,4000000) ops and (322923.3,330190.7) ops/second in (3.096711,12.114210) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/9 2.27 GB 56.7 2.4 0.0 2.4 6.1 3.7 0.0 1.6 121.3 307.8 20.26 18.87 62 0.327 2494K 2598 0.0 0.0 L1 6/6 487.98 MB 0.0 1.2 1.2 0.0 1.2 1.2 0.2 1.0 233.5 232.7 5.39 5.24 2 2.696 1278K 4120 0.0 0.0 L2 1/1 128.77 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.8 1.5 231.8 231.7 0.83 0.80 2 0.417 196K 82 0.0 0.0 L3 18/2 782.07 MB 0.7 1.4 0.6 0.7 1.4 0.6 0.3 2.2 215.1 214.5 6.60 6.06 4 1.649 1440K 3929 0.0 0.0 L4 169/0 9.62 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 132.0 132.0 1.27 0.89 1 1.274 170K 0 0.0 0.0 L5 1052/0 86.55 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1260/18 99.82 GB 0.0 5.4 2.2 3.2 9.0 5.8 3.1 2.5 160.0 269.7 34.35 31.86 71 0.484 5580K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.4 2.2 3.2 9.0 5.8 3.1 2.5 160.0 269.7 34.35 31.86 71 0.484 5580K 10K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.4 2.2 3.2 5.4 2.1 0.0 0.0 233.5 233.0 23.54 22.26 18 1.308 5580K 10K 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 349.5 10.82 9.59 53 0.204 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.3 total, 12.1 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.05 GB write, 750.45 MB/s write, 5.37 GB read, 445.18 MB/s read, 34.4 seconds Interval compaction: 9.05 GB write, 764.68 MB/s write, 5.37 GB read, 453.62 MB/s read, 34.4 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: 1091536 Average: 2.2668 StdDev: 11.70 Min: 0 Median: 1.5269 Max: 3449 Percentiles: P50: 1.53 P75: 1.90 P99: 5.64 P99.9: 9.82 P99.99: 14.93 ------------------------------------------------------ [ 0, 1 ] 163646 14.992% 14.992% ### ( 1, 2 ] 725160 66.435% 81.427% ############# ( 2, 3 ] 126432 11.583% 93.010% ## ( 3, 4 ] 42227 3.869% 96.879% # ( 4, 6 ] 28195 2.583% 99.462% # ( 6, 10 ] 5007 0.459% 99.920% ( 10, 15 ] 771 0.071% 99.991% ( 15, 22 ] 76 0.007% 99.998% ( 22, 34 ] 13 0.001% 99.999% ( 34, 51 ] 7 0.001% 100.000% ( 51, 76 ] 8 0.001% 100.001% ( 76, 110 ] 27 0.002% 100.003% ( 110, 170 ] 89 0.008% 100.011% ( 170, 250 ] 38 0.003% 100.015% ( 250, 380 ] 28 0.003% 100.017% ( 380, 580 ] 23 0.002% 100.019% ( 580, 870 ] 26 0.002% 100.022% ( 870, 1300 ] 11 0.001% 100.023% ( 1300, 1900 ] 9 0.001% 100.024% ( 1900, 2900 ] 5 0.000% 100.024% ( 2900, 4400 ] 6 0.001% 100.025% ** Level 1 read latency histogram (micros): Count: 165262 Average: 2.7991 StdDev: 14.32 Min: 1 Median: 1.6587 Max: 1261 Percentiles: P50: 1.66 P75: 2.17 P99: 7.23 P99.9: 33.21 P99.99: 453.38 ------------------------------------------------------ [ 0, 1 ] 12548 7.593% 7.593% ## ( 1, 2 ] 106397 64.381% 71.974% ############# ( 2, 3 ] 28628 17.323% 89.296% ### ( 3, 4 ] 8377 5.069% 94.365% # ( 4, 6 ] 7096 4.294% 98.659% # ( 6, 10 ] 1837 1.112% 99.771% ( 10, 15 ] 180 0.109% 99.880% ( 15, 22 ] 31 0.019% 99.898% ( 22, 34 ] 4 0.002% 99.901% ( 34, 51 ] 1 0.001% 99.901% ( 51, 76 ] 1 0.001% 99.902% ( 76, 110 ] 35 0.021% 99.923% ( 110, 170 ] 44 0.027% 99.950% ( 170, 250 ] 33 0.020% 99.970% ( 250, 380 ] 22 0.013% 99.983% ( 380, 580 ] 34 0.021% 100.004% ( 580, 870 ] 16 0.010% 100.013% ( 870, 1300 ] 13 0.008% 100.021% ** Level 2 read latency histogram (micros): Count: 77413 Average: 2.7504 StdDev: 18.36 Min: 1 Median: 1.5706 Max: 2739 Percentiles: P50: 1.57 P75: 1.94 P99: 7.36 P99.9: 140.53 P99.99: 653.00 ------------------------------------------------------ [ 0, 1 ] 8983 11.604% 11.604% ## ( 1, 2 ] 52088 67.286% 78.890% ############# ( 2, 3 ] 9411 12.157% 91.047% ## ( 3, 4 ] 3447 4.453% 95.499% # ( 4, 6 ] 2422 3.129% 98.628% # ( 6, 10 ] 844 1.090% 99.718% ( 10, 15 ] 62 0.080% 99.798% ( 15, 22 ] 14 0.018% 99.817% ( 34, 51 ] 2 0.003% 99.819% ( 51, 76 ] 2 0.003% 99.822% ( 76, 110 ] 27 0.035% 99.857% ( 110, 170 ] 66 0.085% 99.942% ( 170, 250 ] 16 0.021% 99.963% ( 250, 380 ] 8 0.010% 99.973% ( 380, 580 ] 12 0.016% 99.988% ( 580, 870 ] 5 0.006% 99.995% ( 870, 1300 ] 2 0.003% 99.997% ( 1300, 1900 ] 4 0.005% 100.003% ( 1900, 2900 ] 1 0.001% 100.004% ** Level 3 read latency histogram (micros): Count: 182291 Average: 4.1397 StdDev: 41.76 Min: 1 Median: 1.7045 Max: 4421 Percentiles: P50: 1.70 P75: 2.37 P99: 9.48 P99.9: 310.31 P99.99: 630.35 ------------------------------------------------------ [ 0, 1 ] 13946 7.650% 7.650% ## ( 1, 2 ] 109588 60.117% 67.767% ############ ( 2, 3 ] 36061 19.782% 87.550% #### ( 3, 4 ] 9766 5.357% 92.907% # ( 4, 6 ] 8405 4.611% 97.518% # ( 6, 10 ] 3105 1.703% 99.221% ( 10, 15 ] 382 0.210% 99.431% ( 15, 22 ] 95 0.052% 99.483% ( 22, 34 ] 24 0.013% 99.496% ( 34, 51 ] 10 0.005% 99.501% ( 51, 76 ] 6 0.003% 99.505% ( 76, 110 ] 177 0.097% 99.602% ( 110, 170 ] 330 0.181% 99.783% ( 170, 250 ] 165 0.091% 99.873% ( 250, 380 ] 105 0.058% 99.931% ( 380, 580 ] 101 0.055% 99.986% ( 580, 870 ] 39 0.021% 100.008% ( 870, 1300 ] 16 0.009% 100.016% ( 1300, 1900 ] 9 0.005% 100.021% ( 1900, 2900 ] 9 0.005% 100.026% ( 2900, 4400 ] 11 0.006% 100.032% ( 4400, 6600 ] 1 0.001% 100.033% ** Level 4 read latency histogram (micros): Count: 305 Average: 109.8590 StdDev: 497.38 Min: 1 Median: 1.8915 Max: 5166 Percentiles: P50: 1.89 P75: 5.29 P99: 3375.00 P99.9: 5166.00 P99.99: 5166.00 ------------------------------------------------------ [ 0, 1 ] 58 19.016% 19.016% #### ( 1, 2 ] 106 34.754% 53.770% ####### ( 2, 3 ] 49 16.066% 69.836% ### ( 3, 4 ] 8 2.623% 72.459% # ( 4, 6 ] 12 3.934% 76.393% # ( 6, 10 ] 24 7.869% 84.262% ## ( 10, 15 ] 19 6.230% 90.492% # ( 15, 22 ] 5 1.639% 92.131% ( 22, 34 ] 1 0.328% 92.459% ( 76, 110 ] 1 0.328% 92.787% ( 170, 250 ] 1 0.328% 93.115% ( 250, 380 ] 3 0.984% 94.098% ( 380, 580 ] 2 0.656% 94.754% ( 580, 870 ] 1 0.328% 95.082% ( 870, 1300 ] 6 1.967% 97.049% ( 1300, 1900 ] 4 1.311% 98.361% ( 1900, 2900 ] 1 0.328% 98.689% ( 2900, 4400 ] 3 0.984% 99.672% ( 4400, 6600 ] 1 0.328% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 852.4500 StdDev: 1056.53 Min: 87 Median: 250.0000 Max: 4272 Percentiles: P50: 250.00 P75: 1375.00 P99: 4220.00 P99.9: 4272.00 P99.99: 4272.00 ------------------------------------------------------ ( 76, 110 ] 8 13.333% 13.333% ### ( 110, 170 ] 18 30.000% 43.333% ###### ( 170, 250 ] 4 6.667% 50.000% # ( 250, 380 ] 2 3.333% 53.333% # ( 380, 580 ] 6 10.000% 63.333% ## ( 580, 870 ] 2 3.333% 66.667% # ( 870, 1300 ] 4 6.667% 73.333% # ( 1300, 1900 ] 8 13.333% 86.667% ### ( 1900, 2900 ] 3 5.000% 91.667% # ( 2900, 4400 ] 5 8.333% 100.000% ## ** DB Stats ** Uptime(secs): 12.3 total, 3.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 318.87 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.502 H:M:S, 12.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 317.82 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.417 H:M:S, 13.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/15-05:13:00 ... thread 0: (1000000,5000000) ops and (255440.8,311934.4) ops/second in (3.914801,16.029011) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/13 3.26 GB 132.2 3.2 0.0 3.2 7.9 4.7 0.0 1.7 124.9 307.3 26.23 24.48 79 0.332 3326K 3450 0.0 0.0 L1 6/6 487.98 MB 0.0 1.2 1.2 0.0 1.2 1.2 0.2 1.0 233.5 232.7 5.39 5.24 2 2.696 1278K 4120 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.8 1.5 231.8 231.7 0.83 0.80 2 0.417 196K 82 0.0 0.0 L3 20/0 910.47 MB 0.9 1.6 0.8 0.8 1.6 0.8 0.3 2.1 215.5 214.9 7.59 6.99 5 1.517 1660K 4294 0.0 0.0 L4 169/0 9.62 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 132.0 132.0 1.27 0.89 1 1.274 170K 0 0.0 0.0 L5 1052/0 86.55 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1266/19 100.80 GB 0.0 6.4 2.3 4.1 11.0 6.9 3.1 2.4 158.1 273.7 41.31 38.40 89 0.464 6632K 11K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.4 2.3 4.1 11.0 6.9 3.1 2.4 158.1 273.7 41.31 38.40 89 0.464 6632K 11K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.4 2.3 4.1 6.4 2.3 0.0 0.0 236.2 235.8 27.65 26.26 22 1.257 6632K 11K 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 350.3 13.67 12.14 67 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): 16.3 total, 16.0 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.04 GB write, 695.36 MB/s write, 6.38 GB read, 401.67 MB/s read, 41.3 seconds Interval compaction: 11.04 GB write, 705.32 MB/s write, 6.38 GB read, 407.42 MB/s read, 41.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 3, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 3, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 19, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 19, interval: 22 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1497622 Average: 2.2901 StdDev: 11.92 Min: 0 Median: 1.5213 Max: 3449 Percentiles: P50: 1.52 P75: 1.90 P99: 5.67 P99.9: 9.98 P99.99: 104.36 ------------------------------------------------------ [ 0, 1 ] 227584 15.196% 15.196% ### ( 1, 2 ] 999821 66.761% 81.957% ############# ( 2, 3 ] 169853 11.342% 93.298% ## ( 3, 4 ] 55567 3.710% 97.009% # ( 4, 6 ] 35627 2.379% 99.388% ( 6, 10 ] 7711 0.515% 99.903% ( 10, 15 ] 1088 0.073% 99.975% ( 15, 22 ] 105 0.007% 99.982% ( 22, 34 ] 15 0.001% 99.983% ( 34, 51 ] 8 0.001% 99.984% ( 51, 76 ] 10 0.001% 99.984% ( 76, 110 ] 101 0.007% 99.991% ( 110, 170 ] 203 0.014% 100.005% ( 170, 250 ] 99 0.007% 100.011% ( 250, 380 ] 54 0.004% 100.015% ( 380, 580 ] 61 0.004% 100.019% ( 580, 870 ] 44 0.003% 100.022% ( 870, 1300 ] 20 0.001% 100.023% ( 1300, 1900 ] 11 0.001% 100.024% ( 1900, 2900 ] 7 0.000% 100.025% ( 2900, 4400 ] 7 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 229121 Average: 2.8519 StdDev: 15.79 Min: 1 Median: 1.6369 Max: 2673 Percentiles: P50: 1.64 P75: 2.09 P99: 7.73 P99.9: 138.84 P99.99: 504.35 ------------------------------------------------------ [ 0, 1 ] 19968 8.715% 8.715% ## ( 1, 2 ] 148527 64.825% 73.540% ############# ( 2, 3 ] 37305 16.282% 89.822% ### ( 3, 4 ] 10874 4.746% 94.567% # ( 4, 6 ] 8932 3.898% 98.466% # ( 6, 10 ] 2837 1.238% 99.704% ( 10, 15 ] 279 0.122% 99.826% ( 15, 22 ] 38 0.017% 99.842% ( 22, 34 ] 4 0.002% 99.844% ( 34, 51 ] 1 0.000% 99.845% ( 51, 76 ] 3 0.001% 99.846% ( 76, 110 ] 59 0.026% 99.872% ( 110, 170 ] 135 0.059% 99.931% ( 170, 250 ] 67 0.029% 99.960% ( 250, 380 ] 38 0.017% 99.976% ( 380, 580 ] 50 0.022% 99.998% ( 580, 870 ] 20 0.009% 100.007% ( 870, 1300 ] 16 0.007% 100.014% ( 1300, 1900 ] 1 0.000% 100.014% ( 1900, 2900 ] 1 0.000% 100.015% ** Level 2 read latency histogram (micros): Count: 77413 Average: 2.7504 StdDev: 18.36 Min: 1 Median: 1.5706 Max: 2739 Percentiles: P50: 1.57 P75: 1.94 P99: 7.36 P99.9: 140.53 P99.99: 653.00 ------------------------------------------------------ [ 0, 1 ] 8983 11.604% 11.604% ## ( 1, 2 ] 52088 67.286% 78.890% ############# ( 2, 3 ] 9411 12.157% 91.047% ## ( 3, 4 ] 3447 4.453% 95.499% # ( 4, 6 ] 2422 3.129% 98.628% # ( 6, 10 ] 844 1.090% 99.718% ( 10, 15 ] 62 0.080% 99.798% ( 15, 22 ] 14 0.018% 99.817% ( 34, 51 ] 2 0.003% 99.819% ( 51, 76 ] 2 0.003% 99.822% ( 76, 110 ] 27 0.035% 99.857% ( 110, 170 ] 66 0.085% 99.942% ( 170, 250 ] 16 0.021% 99.963% ( 250, 380 ] 8 0.010% 99.973% ( 380, 580 ] 12 0.016% 99.988% ( 580, 870 ] 5 0.006% 99.995% ( 870, 1300 ] 2 0.003% 99.997% ( 1300, 1900 ] 4 0.005% 100.003% ( 1900, 2900 ] 1 0.001% 100.004% ** Level 3 read latency histogram (micros): Count: 186908 Average: 4.1092 StdDev: 41.36 Min: 1 Median: 1.7014 Max: 4421 Percentiles: P50: 1.70 P75: 2.36 P99: 9.44 P99.9: 308.30 P99.99: 640.24 ------------------------------------------------------ [ 0, 1 ] 14361 7.683% 7.683% ## ( 1, 2 ] 112769 60.334% 68.017% ############ ( 2, 3 ] 36705 19.638% 87.655% #### ( 3, 4 ] 9981 5.340% 92.995% # ( 4, 6 ] 8543 4.571% 97.566% # ( 6, 10 ] 3120 1.669% 99.235% ( 10, 15 ] 383 0.205% 99.440% ( 15, 22 ] 95 0.051% 99.491% ( 22, 34 ] 24 0.013% 99.504% ( 34, 51 ] 10 0.005% 99.509% ( 51, 76 ] 6 0.003% 99.513% ( 76, 110 ] 177 0.095% 99.607% ( 110, 170 ] 331 0.177% 99.784% ( 170, 250 ] 169 0.090% 99.875% ( 250, 380 ] 105 0.056% 99.931% ( 380, 580 ] 102 0.055% 99.986% ( 580, 870 ] 40 0.021% 100.007% ( 870, 1300 ] 17 0.009% 100.016% ( 1300, 1900 ] 9 0.005% 100.021% ( 1900, 2900 ] 9 0.005% 100.026% ( 2900, 4400 ] 11 0.006% 100.032% ( 4400, 6600 ] 1 0.001% 100.032% ** Level 4 read latency histogram (micros): Count: 305 Average: 109.8590 StdDev: 497.38 Min: 1 Median: 1.8915 Max: 5166 Percentiles: P50: 1.89 P75: 5.29 P99: 3375.00 P99.9: 5166.00 P99.99: 5166.00 ------------------------------------------------------ [ 0, 1 ] 58 19.016% 19.016% #### ( 1, 2 ] 106 34.754% 53.770% ####### ( 2, 3 ] 49 16.066% 69.836% ### ( 3, 4 ] 8 2.623% 72.459% # ( 4, 6 ] 12 3.934% 76.393% # ( 6, 10 ] 24 7.869% 84.262% ## ( 10, 15 ] 19 6.230% 90.492% # ( 15, 22 ] 5 1.639% 92.131% ( 22, 34 ] 1 0.328% 92.459% ( 76, 110 ] 1 0.328% 92.787% ( 170, 250 ] 1 0.328% 93.115% ( 250, 380 ] 3 0.984% 94.098% ( 380, 580 ] 2 0.656% 94.754% ( 580, 870 ] 1 0.328% 95.082% ( 870, 1300 ] 6 1.967% 97.049% ( 1300, 1900 ] 4 1.311% 98.361% ( 1900, 2900 ] 1 0.328% 98.689% ( 2900, 4400 ] 3 0.984% 99.672% ( 4400, 6600 ] 1 0.328% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 852.4500 StdDev: 1056.53 Min: 87 Median: 250.0000 Max: 4272 Percentiles: P50: 250.00 P75: 1375.00 P99: 4220.00 P99.9: 4272.00 P99.99: 4272.00 ------------------------------------------------------ ( 76, 110 ] 8 13.333% 13.333% ### ( 110, 170 ] 18 30.000% 43.333% ###### ( 170, 250 ] 4 6.667% 50.000% # ( 250, 380 ] 2 3.333% 53.333% # ( 380, 580 ] 6 10.000% 63.333% ## ( 580, 870 ] 2 3.333% 66.667% # ( 870, 1300 ] 4 6.667% 73.333% # ( 1300, 1900 ] 8 13.333% 86.667% ### ( 1900, 2900 ] 3 5.000% 91.667% # ( 2900, 4400 ] 5 8.333% 100.000% ## ** DB Stats ** Uptime(secs): 16.3 total, 3.9 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 302.63 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.662 H:M:S, 16.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 251.40 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.160 H:M:S, 29.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/15-05:13:06 ... thread 0: (1000000,6000000) ops and (149324.4,264016.6) ops/second in (6.696830,22.725841) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/6 2.52 GB 113.3 4.2 0.0 4.2 9.9 5.7 0.0 1.7 126.9 295.9 34.26 31.24 97 0.353 4413K 4608 0.0 0.0 L1 3/0 300.44 MB 30.0 3.4 3.0 0.5 3.4 2.9 0.2 1.2 229.2 227.4 15.31 14.76 3 5.104 3563K 26K 0.0 0.0 L2 11/7 1.29 GB 4.5 0.2 0.1 0.1 0.2 0.1 2.7 1.5 231.8 231.7 0.83 0.80 2 0.417 196K 82 0.0 0.0 L3 33/9 1.44 GB 1.0 2.6 1.4 1.2 2.6 1.4 0.3 1.9 196.8 196.1 13.42 11.67 9 1.492 2683K 9545 0.0 0.0 L4 170/0 9.67 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 137.7 137.7 1.58 1.13 2 0.788 217K 0 0.0 0.0 L5 1052/0 86.55 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1281/22 101.76 GB 0.0 10.7 4.6 6.0 16.3 10.3 5.0 2.9 166.8 254.8 65.41 59.60 113 0.579 11M 40K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.7 4.6 6.0 16.3 10.3 5.0 2.9 166.8 254.8 65.41 59.60 113 0.579 11M 40K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 10.7 4.6 6.0 10.6 4.6 0.0 0.0 227.5 226.7 47.94 44.79 32 1.498 11M 40K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 331.9 17.46 14.81 81 0.216 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 23.0 total, 22.7 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 16.27 GB write, 725.83 MB/s write, 10.65 GB read, 475.19 MB/s read, 65.4 seconds Interval compaction: 16.27 GB write, 733.17 MB/s write, 10.65 GB read, 479.99 MB/s read, 65.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 9, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 9, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 25, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 9, total-stops: 25, interval: 34 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2073758 Average: 2.4475 StdDev: 19.00 Min: 0 Median: 1.5403 Max: 5310 Percentiles: P50: 1.54 P75: 1.92 P99: 5.87 P99.9: 11.73 P99.99: 153.26 ------------------------------------------------------ [ 0, 1 ] 302929 14.608% 14.608% ### ( 1, 2 ] 1358450 65.507% 80.114% ############# ( 2, 3 ] 244772 11.803% 91.918% ## ( 3, 4 ] 88164 4.251% 96.169% # ( 4, 6 ] 62771 3.027% 99.196% # ( 6, 10 ] 13940 0.672% 99.868% ( 10, 15 ] 1899 0.092% 99.960% ( 15, 22 ] 189 0.009% 99.969% ( 22, 34 ] 21 0.001% 99.970% ( 34, 51 ] 10 0.000% 99.970% ( 51, 76 ] 12 0.001% 99.971% ( 76, 110 ] 142 0.007% 99.978% ( 110, 170 ] 349 0.017% 99.995% ( 170, 250 ] 162 0.008% 100.003% ( 250, 380 ] 113 0.005% 100.008% ( 380, 580 ] 122 0.006% 100.014% ( 580, 870 ] 100 0.005% 100.019% ( 870, 1300 ] 46 0.002% 100.021% ( 1300, 1900 ] 23 0.001% 100.022% ( 1900, 2900 ] 23 0.001% 100.023% ( 2900, 4400 ] 30 0.001% 100.025% ( 4400, 6600 ] 2 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 648234 Average: 3.7341 StdDev: 44.81 Min: 1 Median: 1.7690 Max: 7403 Percentiles: P50: 1.77 P75: 2.61 P99: 8.46 P99.9: 21.52 P99.99: 231.84 ------------------------------------------------------ [ 0, 1 ] 41189 6.354% 6.354% # ( 1, 2 ] 367940 56.760% 63.114% ########### ( 2, 3 ] 126754 19.554% 82.668% #### ( 3, 4 ] 50238 7.750% 90.418% ## ( 4, 6 ] 48828 7.532% 97.951% ## ( 6, 10 ] 11084 1.710% 99.660% ( 10, 15 ] 1376 0.212% 99.873% ( 15, 22 ] 192 0.030% 99.902% ( 22, 34 ] 11 0.002% 99.904% ( 34, 51 ] 4 0.001% 99.905% ( 51, 76 ] 18 0.003% 99.907% ( 76, 110 ] 209 0.032% 99.940% ( 110, 170 ] 230 0.035% 99.975% ( 170, 250 ] 127 0.020% 99.995% ( 250, 380 ] 136 0.021% 100.016% ( 380, 580 ] 171 0.026% 100.042% ( 580, 870 ] 116 0.018% 100.060% ( 870, 1300 ] 87 0.013% 100.073% ( 1300, 1900 ] 35 0.005% 100.079% ( 1900, 2900 ] 33 0.005% 100.084% ( 2900, 4400 ] 39 0.006% 100.090% ( 4400, 6600 ] 9 0.001% 100.091% ( 6600, 9900 ] 1 0.000% 100.091% ** Level 2 read latency histogram (micros): Count: 77413 Average: 2.7504 StdDev: 18.36 Min: 1 Median: 1.5706 Max: 2739 Percentiles: P50: 1.57 P75: 1.94 P99: 7.36 P99.9: 140.53 P99.99: 653.00 ------------------------------------------------------ [ 0, 1 ] 8983 11.604% 11.604% ## ( 1, 2 ] 52088 67.286% 78.890% ############# ( 2, 3 ] 9411 12.157% 91.047% ## ( 3, 4 ] 3447 4.453% 95.499% # ( 4, 6 ] 2422 3.129% 98.628% # ( 6, 10 ] 844 1.090% 99.718% ( 10, 15 ] 62 0.080% 99.798% ( 15, 22 ] 14 0.018% 99.817% ( 34, 51 ] 2 0.003% 99.819% ( 51, 76 ] 2 0.003% 99.822% ( 76, 110 ] 27 0.035% 99.857% ( 110, 170 ] 66 0.085% 99.942% ( 170, 250 ] 16 0.021% 99.963% ( 250, 380 ] 8 0.010% 99.973% ( 380, 580 ] 12 0.016% 99.988% ( 580, 870 ] 5 0.006% 99.995% ( 870, 1300 ] 2 0.003% 99.997% ( 1300, 1900 ] 4 0.005% 100.003% ( 1900, 2900 ] 1 0.001% 100.004% ** Level 3 read latency histogram (micros): Count: 383278 Average: 5.2270 StdDev: 62.76 Min: 1 Median: 1.8636 Max: 7566 Percentiles: P50: 1.86 P75: 2.79 P99: 9.73 P99.9: 372.72 P99.99: 686.91 ------------------------------------------------------ [ 0, 1 ] 16527 4.312% 4.312% # ( 1, 2 ] 202773 52.905% 57.217% ########### ( 2, 3 ] 86381 22.537% 79.754% ##### ( 3, 4 ] 32875 8.577% 88.332% ## ( 4, 6 ] 32706 8.533% 96.865% ## ( 6, 10 ] 8777 2.290% 99.155% ( 10, 15 ] 1344 0.351% 99.506% ( 15, 22 ] 239 0.062% 99.568% ( 22, 34 ] 37 0.010% 99.578% ( 34, 51 ] 14 0.004% 99.581% ( 51, 76 ] 8 0.002% 99.583% ( 76, 110 ] 202 0.053% 99.636% ( 110, 170 ] 431 0.112% 99.748% ( 170, 250 ] 340 0.089% 99.837% ( 250, 380 ] 255 0.067% 99.904% ( 380, 580 ] 268 0.070% 99.974% ( 580, 870 ] 170 0.044% 100.018% ( 870, 1300 ] 74 0.019% 100.037% ( 1300, 1900 ] 36 0.009% 100.047% ( 1900, 2900 ] 42 0.011% 100.058% ( 2900, 4400 ] 46 0.012% 100.070% ( 4400, 6600 ] 9 0.002% 100.072% ( 6600, 9900 ] 1 0.000% 100.072% ** Level 4 read latency histogram (micros): Count: 1032 Average: 67.0271 StdDev: 310.10 Min: 1 Median: 2.0670 Max: 5166 Percentiles: P50: 2.07 P75: 3.80 P99: 1290.17 P99.9: 4384.00 P99.99: 5166.00 ------------------------------------------------------ [ 0, 1 ] 65 6.298% 6.298% # ( 1, 2 ] 438 42.442% 48.740% ######## ( 2, 3 ] 194 18.798% 67.539% #### ( 3, 4 ] 96 9.302% 76.841% ## ( 4, 6 ] 75 7.267% 84.109% # ( 6, 10 ] 46 4.457% 88.566% # ( 10, 15 ] 23 2.229% 90.795% ( 15, 22 ] 5 0.484% 91.279% ( 22, 34 ] 1 0.097% 91.376% ( 76, 110 ] 6 0.581% 91.957% ( 110, 170 ] 3 0.291% 92.248% ( 170, 250 ] 10 0.969% 93.217% ( 250, 380 ] 10 0.969% 94.186% ( 380, 580 ] 26 2.519% 96.705% # ( 580, 870 ] 10 0.969% 97.674% ( 870, 1300 ] 14 1.357% 99.031% ( 1300, 1900 ] 5 0.484% 99.516% ( 1900, 2900 ] 1 0.097% 99.612% ( 2900, 4400 ] 3 0.291% 99.903% ( 4400, 6600 ] 1 0.097% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 852.4500 StdDev: 1056.53 Min: 87 Median: 250.0000 Max: 4272 Percentiles: P50: 250.00 P75: 1375.00 P99: 4220.00 P99.9: 4272.00 P99.99: 4272.00 ------------------------------------------------------ ( 76, 110 ] 8 13.333% 13.333% ### ( 110, 170 ] 18 30.000% 43.333% ###### ( 170, 250 ] 4 6.667% 50.000% # ( 250, 380 ] 2 3.333% 53.333% # ( 380, 580 ] 6 10.000% 63.333% ## ( 580, 870 ] 2 3.333% 66.667% # ( 870, 1300 ] 4 6.667% 73.333% # ( 1300, 1900 ] 8 13.333% 86.667% ### ( 1900, 2900 ] 3 5.000% 91.667% # ( 2900, 4400 ] 5 8.333% 100.000% ## ** DB Stats ** Uptime(secs): 23.0 total, 6.7 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 257.22 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:6.339 H:M:S, 27.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 146.96 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:3.677 H:M:S, 54.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 2024/12/15-05:13:11 ... thread 0: (1000000,7000000) ops and (210215.6,254704.2) ops/second in (4.757021,27.482862) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/11 3.49 GB 18.9 6.3 0.0 6.3 13.0 6.6 0.0 2.0 133.8 273.7 48.50 42.57 112 0.433 6586K 14K 0.0 0.0 L1 3/3 300.44 MB 0.0 3.4 3.0 0.5 3.4 2.9 0.2 1.2 229.2 227.4 15.31 14.76 3 5.104 3563K 26K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 2.7 1.5 231.8 231.7 0.83 0.80 2 0.417 196K 82 0.0 0.0 L3 24/0 957.35 MB 1.0 4.8 2.6 2.2 4.8 2.6 0.3 1.8 176.3 175.6 27.98 22.17 17 1.646 5009K 18K 0.0 0.0 L4 185/0 9.47 GB 1.0 2.1 2.0 0.1 2.1 2.0 0.9 1.1 122.7 122.5 17.49 10.15 41 0.427 2111K 1605 0.0 0.0 L5 1076/0 88.52 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1301/14 102.72 GB 0.0 16.9 7.7 9.2 23.4 14.3 7.0 3.5 156.8 218.0 110.11 90.45 175 0.629 17M 61K 0.0 0.0 Int 0/0 0.00 KB 0.0 16.9 7.7 9.2 23.4 14.3 7.0 3.5 156.8 218.0 110.11 90.45 175 0.629 17M 61K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 16.9 7.7 9.2 16.8 7.6 0.0 0.0 195.8 195.1 88.18 72.96 82 1.075 17M 61K 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 310.2 21.93 17.50 93 0.236 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.7 total, 27.5 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: 23.44 GB write, 866.24 MB/s write, 16.86 GB read, 623.06 MB/s read, 110.1 seconds Interval compaction: 23.44 GB write, 873.48 MB/s write, 16.86 GB read, 628.26 MB/s read, 110.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 9, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 9, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 56, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 9, total-stops: 56, interval: 65 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2467436 Average: 2.6749 StdDev: 25.75 Min: 0 Median: 1.5730 Max: 6624 Percentiles: P50: 1.57 P75: 1.97 P99: 6.13 P99.9: 13.43 P99.99: 243.49 ------------------------------------------------------ [ 0, 1 ] 333224 13.505% 13.505% ### ( 1, 2 ] 1571538 63.691% 77.196% ############# ( 2, 3 ] 317673 12.875% 90.071% ### ( 3, 4 ] 122616 4.969% 95.040% # ( 4, 6 ] 97035 3.933% 98.973% # ( 6, 10 ] 20901 0.847% 99.820% ( 10, 15 ] 2888 0.117% 99.937% ( 15, 22 ] 298 0.012% 99.949% ( 22, 34 ] 26 0.001% 99.950% ( 34, 51 ] 12 0.000% 99.950% ( 51, 76 ] 14 0.001% 99.951% ( 76, 110 ] 194 0.008% 99.959% ( 110, 170 ] 536 0.022% 99.981% ( 170, 250 ] 255 0.010% 99.991% ( 250, 380 ] 186 0.008% 99.998% ( 380, 580 ] 221 0.009% 100.007% ( 580, 870 ] 172 0.007% 100.014% ( 870, 1300 ] 98 0.004% 100.018% ( 1300, 1900 ] 48 0.002% 100.020% ( 1900, 2900 ] 57 0.002% 100.023% ( 2900, 4400 ] 52 0.002% 100.025% ( 4400, 6600 ] 9 0.000% 100.025% ( 6600, 9900 ] 1 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 806621 Average: 5.0057 StdDev: 80.59 Min: 1 Median: 1.8190 Max: 9847 Percentiles: P50: 1.82 P75: 2.72 P99: 8.87 P99.9: 128.09 P99.99: 601.77 ------------------------------------------------------ [ 0, 1 ] 42730 5.297% 5.297% # ( 1, 2 ] 440280 54.583% 59.881% ########### ( 2, 3 ] 168288 20.863% 80.744% #### ( 3, 4 ] 68122 8.445% 89.189% ## ( 4, 6 ] 67832 8.409% 97.599% ## ( 6, 10 ] 15763 1.954% 99.553% ( 10, 15 ] 2192 0.272% 99.825% ( 15, 22 ] 279 0.035% 99.859% ( 22, 34 ] 17 0.002% 99.861% ( 34, 51 ] 8 0.001% 99.862% ( 51, 76 ] 21 0.003% 99.865% ( 76, 110 ] 210 0.026% 99.891% ( 110, 170 ] 240 0.030% 99.921% ( 170, 250 ] 139 0.017% 99.938% ( 250, 380 ] 174 0.022% 99.960% ( 380, 580 ] 231 0.029% 99.988% ( 580, 870 ] 191 0.024% 100.012% ( 870, 1300 ] 150 0.019% 100.030% ( 1300, 1900 ] 101 0.013% 100.043% ( 1900, 2900 ] 132 0.016% 100.059% ( 2900, 4400 ] 119 0.015% 100.074% ( 4400, 6600 ] 47 0.006% 100.080% ( 6600, 9900 ] 19 0.002% 100.082% ** Level 2 read latency histogram (micros): Count: 77413 Average: 2.7504 StdDev: 18.36 Min: 1 Median: 1.5706 Max: 2739 Percentiles: P50: 1.57 P75: 1.94 P99: 7.36 P99.9: 140.53 P99.99: 653.00 ------------------------------------------------------ [ 0, 1 ] 8983 11.604% 11.604% ## ( 1, 2 ] 52088 67.286% 78.890% ############# ( 2, 3 ] 9411 12.157% 91.047% ## ( 3, 4 ] 3447 4.453% 95.499% # ( 4, 6 ] 2422 3.129% 98.628% # ( 6, 10 ] 844 1.090% 99.718% ( 10, 15 ] 62 0.080% 99.798% ( 15, 22 ] 14 0.018% 99.817% ( 34, 51 ] 2 0.003% 99.819% ( 51, 76 ] 2 0.003% 99.822% ( 76, 110 ] 27 0.035% 99.857% ( 110, 170 ] 66 0.085% 99.942% ( 170, 250 ] 16 0.021% 99.963% ( 250, 380 ] 8 0.010% 99.973% ( 380, 580 ] 12 0.016% 99.988% ( 580, 870 ] 5 0.006% 99.995% ( 870, 1300 ] 2 0.003% 99.997% ( 1300, 1900 ] 4 0.005% 100.003% ( 1900, 2900 ] 1 0.001% 100.004% ** Level 3 read latency histogram (micros): Count: 1003861 Average: 5.9003 StdDev: 83.57 Min: 1 Median: 1.9739 Max: 10973 Percentiles: P50: 1.97 P75: 2.95 P99: 9.20 P99.9: 164.30 P99.99: 392.38 ------------------------------------------------------ [ 0, 1 ] 20940 2.086% 2.086% ( 1, 2 ] 493888 49.199% 51.285% ########## ( 2, 3 ] 249465 24.851% 76.135% ##### ( 3, 4 ] 105224 10.482% 86.617% ## ( 4, 6 ] 107359 10.695% 97.312% ## ( 6, 10 ] 21195 2.111% 99.423% ( 10, 15 ] 3488 0.347% 99.771% ( 15, 22 ] 475 0.047% 99.818% ( 22, 34 ] 66 0.007% 99.825% ( 34, 51 ] 30 0.003% 99.828% ( 51, 76 ] 11 0.001% 99.829% ( 76, 110 ] 232 0.023% 99.852% ( 110, 170 ] 535 0.053% 99.905% ( 170, 250 ] 433 0.043% 99.948% ( 250, 380 ] 392 0.039% 99.987% ( 380, 580 ] 446 0.044% 100.032% ( 580, 870 ] 390 0.039% 100.071% ( 870, 1300 ] 287 0.029% 100.099% ( 1300, 1900 ] 176 0.018% 100.117% ( 1900, 2900 ] 201 0.020% 100.137% ( 2900, 4400 ] 228 0.023% 100.159% ( 4400, 6600 ] 44 0.004% 100.164% ( 6600, 9900 ] 10 0.001% 100.165% ( 9900, 14000 ] 1 0.000% 100.165% ** Level 4 read latency histogram (micros): Count: 30413 Average: 108.7074 StdDev: 493.27 Min: 1 Median: 2.0621 Max: 9280 Percentiles: P50: 2.06 P75: 3.40 P99: 2731.17 P99.9: 5890.58 P99.99: 8533.16 ------------------------------------------------------ [ 0, 1 ] 649 2.134% 2.134% ( 1, 2 ] 14144 46.506% 48.640% ######### ( 2, 3 ] 6663 21.908% 70.549% #### ( 3, 4 ] 3348 11.008% 81.557% ## ( 4, 6 ] 2110 6.938% 88.495% # ( 6, 10 ] 690 2.269% 90.764% ( 10, 15 ] 125 0.411% 91.175% ( 15, 22 ] 16 0.053% 91.227% ( 22, 34 ] 2 0.007% 91.234% ( 51, 76 ] 2 0.007% 91.241% ( 76, 110 ] 40 0.132% 91.372% ( 110, 170 ] 139 0.457% 91.829% ( 170, 250 ] 145 0.477% 92.306% ( 250, 380 ] 232 0.763% 93.069% ( 380, 580 ] 392 1.289% 94.358% ( 580, 870 ] 488 1.605% 95.962% ( 870, 1300 ] 439 1.443% 97.406% ( 1300, 1900 ] 307 1.009% 98.415% ( 1900, 2900 ] 214 0.704% 99.119% ( 2900, 4400 ] 201 0.661% 99.780% ( 4400, 6600 ] 54 0.178% 99.957% ( 6600, 9900 ] 17 0.056% 100.013% ** Level 5 read latency histogram (micros): Count: 180 Average: 1340.8000 StdDev: 1559.16 Min: 82 Median: 665.2941 Max: 7533 Percentiles: P50: 665.29 P75: 2011.11 P99: 6930.00 P99.9: 7533.00 P99.99: 7533.00 ------------------------------------------------------ ( 76, 110 ] 12 6.667% 6.667% # ( 110, 170 ] 32 17.778% 24.444% #### ( 170, 250 ] 12 6.667% 31.111% # ( 250, 380 ] 11 6.111% 37.222% # ( 380, 580 ] 18 10.000% 47.222% ## ( 580, 870 ] 17 9.444% 56.667% ## ( 870, 1300 ] 13 7.222% 63.889% # ( 1300, 1900 ] 18 10.000% 73.889% ## ( 1900, 2900 ] 18 10.000% 83.889% ## ( 2900, 4400 ] 20 11.111% 95.000% ## ( 4400, 6600 ] 7 3.889% 98.889% # ( 6600, 9900 ] 2 1.111% 100.000% ** DB Stats ** Uptime(secs): 27.7 total, 4.8 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 248.58 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.240 H:M:S, 29.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 206.90 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.901 H:M:S, 40.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/15-05:13:15 ... thread 0: (1000000,8000000) ops and (278270.5,257429.4) ops/second in (3.593625,31.076487) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/11 4.42 GB 113.3 7.1 0.0 7.1 14.7 7.6 0.0 1.9 134.5 276.9 54.31 48.00 129 0.421 7418K 15K 0.0 0.0 L1 3/3 300.44 MB 0.0 3.4 3.0 0.5 3.4 2.9 0.2 1.2 229.2 227.4 15.31 14.76 3 5.104 3563K 26K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 2.7 1.5 231.8 231.7 0.83 0.80 2 0.417 196K 82 0.0 0.0 L3 24/0 957.35 MB 1.0 4.8 2.6 2.2 4.8 2.6 0.3 1.8 176.3 175.6 27.98 22.17 17 1.646 5009K 18K 0.0 0.0 L4 185/0 9.47 GB 1.0 2.1 2.0 0.1 2.1 2.0 0.9 1.1 122.7 122.5 17.49 10.15 41 0.427 2111K 1605 0.0 0.0 L5 1076/0 88.52 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1306/14 103.64 GB 0.0 17.7 7.7 10.0 25.2 15.2 7.0 3.3 156.0 222.3 115.92 95.89 192 0.604 18M 62K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.7 7.7 10.0 25.2 15.2 7.0 3.3 156.0 222.3 115.92 95.89 192 0.604 18M 62K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 17.7 7.7 10.0 17.6 7.6 0.0 0.0 198.1 197.4 91.30 76.01 85 1.074 18M 62K 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 314.7 24.62 19.88 107 0.230 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 31.3 total, 31.1 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 25.17 GB write, 823.12 MB/s write, 17.66 GB read, 577.70 MB/s read, 115.9 seconds Interval compaction: 25.17 GB write, 829.21 MB/s write, 17.66 GB read, 581.97 MB/s read, 115.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 57, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 12, total-stops: 57, interval: 69 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2883768 Average: 2.6090 StdDev: 24.10 Min: 0 Median: 1.5664 Max: 6624 Percentiles: P50: 1.57 P75: 1.96 P99: 6.00 P99.9: 12.77 P99.99: 182.61 ------------------------------------------------------ [ 0, 1 ] 392149 13.598% 13.598% ### ( 1, 2 ] 1853406 64.270% 77.869% ############# ( 2, 3 ] 367452 12.742% 90.611% ### ( 3, 4 ] 136848 4.745% 95.356% # ( 4, 6 ] 105237 3.649% 99.006% # ( 6, 10 ] 24019 0.833% 99.839% ( 10, 15 ] 3204 0.111% 99.950% ( 15, 22 ] 333 0.012% 99.961% ( 22, 34 ] 27 0.001% 99.962% ( 34, 51 ] 13 0.000% 99.963% ( 51, 76 ] 16 0.001% 99.963% ( 76, 110 ] 194 0.007% 99.970% ( 110, 170 ] 541 0.019% 99.989% ( 170, 250 ] 264 0.009% 99.998% ( 250, 380 ] 189 0.007% 100.004% ( 380, 580 ] 223 0.008% 100.012% ( 580, 870 ] 179 0.006% 100.018% ( 870, 1300 ] 100 0.003% 100.022% ( 1300, 1900 ] 49 0.002% 100.023% ( 1900, 2900 ] 61 0.002% 100.026% ( 2900, 4400 ] 53 0.002% 100.027% ( 4400, 6600 ] 9 0.000% 100.028% ( 6600, 9900 ] 1 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 806621 Average: 5.0057 StdDev: 80.59 Min: 1 Median: 1.8190 Max: 9847 Percentiles: P50: 1.82 P75: 2.72 P99: 8.87 P99.9: 128.09 P99.99: 601.77 ------------------------------------------------------ [ 0, 1 ] 42730 5.297% 5.297% # ( 1, 2 ] 440280 54.583% 59.881% ########### ( 2, 3 ] 168288 20.863% 80.744% #### ( 3, 4 ] 68122 8.445% 89.189% ## ( 4, 6 ] 67832 8.409% 97.599% ## ( 6, 10 ] 15763 1.954% 99.553% ( 10, 15 ] 2192 0.272% 99.825% ( 15, 22 ] 279 0.035% 99.859% ( 22, 34 ] 17 0.002% 99.861% ( 34, 51 ] 8 0.001% 99.862% ( 51, 76 ] 21 0.003% 99.865% ( 76, 110 ] 210 0.026% 99.891% ( 110, 170 ] 240 0.030% 99.921% ( 170, 250 ] 139 0.017% 99.938% ( 250, 380 ] 174 0.022% 99.960% ( 380, 580 ] 231 0.029% 99.988% ( 580, 870 ] 191 0.024% 100.012% ( 870, 1300 ] 150 0.019% 100.030% ( 1300, 1900 ] 101 0.013% 100.043% ( 1900, 2900 ] 132 0.016% 100.059% ( 2900, 4400 ] 119 0.015% 100.074% ( 4400, 6600 ] 47 0.006% 100.080% ( 6600, 9900 ] 19 0.002% 100.082% ** Level 2 read latency histogram (micros): Count: 77413 Average: 2.7504 StdDev: 18.36 Min: 1 Median: 1.5706 Max: 2739 Percentiles: P50: 1.57 P75: 1.94 P99: 7.36 P99.9: 140.53 P99.99: 653.00 ------------------------------------------------------ [ 0, 1 ] 8983 11.604% 11.604% ## ( 1, 2 ] 52088 67.286% 78.890% ############# ( 2, 3 ] 9411 12.157% 91.047% ## ( 3, 4 ] 3447 4.453% 95.499% # ( 4, 6 ] 2422 3.129% 98.628% # ( 6, 10 ] 844 1.090% 99.718% ( 10, 15 ] 62 0.080% 99.798% ( 15, 22 ] 14 0.018% 99.817% ( 34, 51 ] 2 0.003% 99.819% ( 51, 76 ] 2 0.003% 99.822% ( 76, 110 ] 27 0.035% 99.857% ( 110, 170 ] 66 0.085% 99.942% ( 170, 250 ] 16 0.021% 99.963% ( 250, 380 ] 8 0.010% 99.973% ( 380, 580 ] 12 0.016% 99.988% ( 580, 870 ] 5 0.006% 99.995% ( 870, 1300 ] 2 0.003% 99.997% ( 1300, 1900 ] 4 0.005% 100.003% ( 1900, 2900 ] 1 0.001% 100.004% ** Level 3 read latency histogram (micros): Count: 1003861 Average: 5.9003 StdDev: 83.57 Min: 1 Median: 1.9739 Max: 10973 Percentiles: P50: 1.97 P75: 2.95 P99: 9.20 P99.9: 164.30 P99.99: 392.38 ------------------------------------------------------ [ 0, 1 ] 20940 2.086% 2.086% ( 1, 2 ] 493888 49.199% 51.285% ########## ( 2, 3 ] 249465 24.851% 76.135% ##### ( 3, 4 ] 105224 10.482% 86.617% ## ( 4, 6 ] 107359 10.695% 97.312% ## ( 6, 10 ] 21195 2.111% 99.423% ( 10, 15 ] 3488 0.347% 99.771% ( 15, 22 ] 475 0.047% 99.818% ( 22, 34 ] 66 0.007% 99.825% ( 34, 51 ] 30 0.003% 99.828% ( 51, 76 ] 11 0.001% 99.829% ( 76, 110 ] 232 0.023% 99.852% ( 110, 170 ] 535 0.053% 99.905% ( 170, 250 ] 433 0.043% 99.948% ( 250, 380 ] 392 0.039% 99.987% ( 380, 580 ] 446 0.044% 100.032% ( 580, 870 ] 390 0.039% 100.071% ( 870, 1300 ] 287 0.029% 100.099% ( 1300, 1900 ] 176 0.018% 100.117% ( 1900, 2900 ] 201 0.020% 100.137% ( 2900, 4400 ] 228 0.023% 100.159% ( 4400, 6600 ] 44 0.004% 100.164% ( 6600, 9900 ] 10 0.001% 100.165% ( 9900, 14000 ] 1 0.000% 100.165% ** Level 4 read latency histogram (micros): Count: 30413 Average: 108.7074 StdDev: 493.27 Min: 1 Median: 2.0621 Max: 9280 Percentiles: P50: 2.06 P75: 3.40 P99: 2731.17 P99.9: 5890.58 P99.99: 8533.16 ------------------------------------------------------ [ 0, 1 ] 649 2.134% 2.134% ( 1, 2 ] 14144 46.506% 48.640% ######### ( 2, 3 ] 6663 21.908% 70.549% #### ( 3, 4 ] 3348 11.008% 81.557% ## ( 4, 6 ] 2110 6.938% 88.495% # ( 6, 10 ] 690 2.269% 90.764% ( 10, 15 ] 125 0.411% 91.175% ( 15, 22 ] 16 0.053% 91.227% ( 22, 34 ] 2 0.007% 91.234% ( 51, 76 ] 2 0.007% 91.241% ( 76, 110 ] 40 0.132% 91.372% ( 110, 170 ] 139 0.457% 91.829% ( 170, 250 ] 145 0.477% 92.306% ( 250, 380 ] 232 0.763% 93.069% ( 380, 580 ] 392 1.289% 94.358% ( 580, 870 ] 488 1.605% 95.962% ( 870, 1300 ] 439 1.443% 97.406% ( 1300, 1900 ] 307 1.009% 98.415% ( 1900, 2900 ] 214 0.704% 99.119% ( 2900, 4400 ] 201 0.661% 99.780% ( 4400, 6600 ] 54 0.178% 99.957% ( 6600, 9900 ] 17 0.056% 100.013% ** Level 5 read latency histogram (micros): Count: 180 Average: 1340.8000 StdDev: 1559.16 Min: 82 Median: 665.2941 Max: 7533 Percentiles: P50: 665.29 P75: 2011.11 P99: 6930.00 P99.9: 7533.00 P99.99: 7533.00 ------------------------------------------------------ ( 76, 110 ] 12 6.667% 6.667% # ( 110, 170 ] 32 17.778% 24.444% #### ( 170, 250 ] 12 6.667% 31.111% # ( 250, 380 ] 11 6.111% 37.222% # ( 380, 580 ] 18 10.000% 47.222% ## ( 580, 870 ] 17 9.444% 56.667% ## ( 870, 1300 ] 13 7.222% 63.889% # ( 1300, 1900 ] 18 10.000% 73.889% ## ( 1900, 2900 ] 18 10.000% 83.889% ## ( 2900, 4400 ] 20 11.111% 95.000% ## ( 4400, 6600 ] 7 3.889% 98.889% # ( 6600, 9900 ] 2 1.111% 100.000% ** DB Stats ** Uptime(secs): 31.3 total, 3.6 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 251.48 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:9.126 H:M:S, 29.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 273.87 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.886 H:M:S, 24.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/15-05:13:23 ... thread 0: (1000000,9000000) ops and (118333.7,227691.5) ops/second in (8.450679,39.527166) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/11 5.40 GB 213.8 8.9 0.0 8.9 17.5 8.5 0.0 2.0 142.7 279.3 63.98 57.26 150 0.427 9272K 18K 0.0 0.0 L1 3/3 300.44 MB 0.0 3.4 3.0 0.5 3.4 2.9 0.2 1.2 229.2 227.4 15.31 14.76 3 5.104 3563K 26K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 2.7 1.5 231.8 231.7 0.83 0.80 2 0.417 196K 82 0.0 0.0 L3 24/0 957.35 MB 1.0 4.8 2.6 2.2 4.8 2.6 0.3 1.8 176.3 175.6 27.98 22.17 17 1.646 5009K 18K 0.0 0.0 L4 185/0 9.47 GB 1.0 2.1 2.0 0.1 2.1 2.0 0.9 1.1 122.7 122.5 17.49 10.15 41 0.427 2111K 1605 0.0 0.0 L5 1076/0 88.52 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1307/14 104.62 GB 0.0 19.4 7.7 11.7 27.9 16.2 7.0 3.3 158.6 227.7 125.59 105.15 213 0.590 20M 65K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.4 7.7 11.7 27.9 16.2 7.0 3.3 158.6 227.7 125.59 105.15 213 0.590 20M 65K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 19.4 7.7 11.7 19.4 7.6 0.0 0.0 203.1 202.4 98.04 82.66 90 1.089 20M 65K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 317.9 27.55 22.50 123 0.224 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 39.8 total, 39.5 interval Flush(GB): cumulative 8.551, interval 8.551 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 27.93 GB write, 719.37 MB/s write, 19.45 GB read, 500.84 MB/s read, 125.6 seconds Interval compaction: 27.93 GB write, 723.55 MB/s write, 19.45 GB read, 503.75 MB/s read, 125.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 22, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 22, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 57, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 22, total-stops: 57, interval: 79 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3828534 Average: 2.5235 StdDev: 21.45 Min: 0 Median: 1.5472 Max: 6624 Percentiles: P50: 1.55 P75: 1.93 P99: 5.97 P99.9: 12.69 P99.99: 168.37 ------------------------------------------------------ [ 0, 1 ] 548092 14.316% 14.316% ### ( 1, 2 ] 2496638 65.211% 79.527% ############# ( 2, 3 ] 463800 12.114% 91.642% ## ( 3, 4 ] 164440 4.295% 95.937% # ( 4, 6 ] 119149 3.112% 99.049% # ( 6, 10 ] 30630 0.800% 99.849% ( 10, 15 ] 3638 0.095% 99.944% ( 15, 22 ] 401 0.010% 99.954% ( 22, 34 ] 28 0.001% 99.955% ( 34, 51 ] 14 0.000% 99.955% ( 51, 76 ] 31 0.001% 99.956% ( 76, 110 ] 511 0.013% 99.970% ( 110, 170 ] 802 0.021% 99.991% ( 170, 250 ] 336 0.009% 99.999% ( 250, 380 ] 244 0.006% 100.006% ( 380, 580 ] 283 0.007% 100.013% ( 580, 870 ] 207 0.005% 100.019% ( 870, 1300 ] 106 0.003% 100.021% ( 1300, 1900 ] 52 0.001% 100.023% ( 1900, 2900 ] 66 0.002% 100.024% ( 2900, 4400 ] 53 0.001% 100.026% ( 4400, 6600 ] 9 0.000% 100.026% ( 6600, 9900 ] 1 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 806621 Average: 5.0057 StdDev: 80.59 Min: 1 Median: 1.8190 Max: 9847 Percentiles: P50: 1.82 P75: 2.72 P99: 8.87 P99.9: 128.09 P99.99: 601.77 ------------------------------------------------------ [ 0, 1 ] 42730 5.297% 5.297% # ( 1, 2 ] 440280 54.583% 59.881% ########### ( 2, 3 ] 168288 20.863% 80.744% #### ( 3, 4 ] 68122 8.445% 89.189% ## ( 4, 6 ] 67832 8.409% 97.599% ## ( 6, 10 ] 15763 1.954% 99.553% ( 10, 15 ] 2192 0.272% 99.825% ( 15, 22 ] 279 0.035% 99.859% ( 22, 34 ] 17 0.002% 99.861% ( 34, 51 ] 8 0.001% 99.862% ( 51, 76 ] 21 0.003% 99.865% ( 76, 110 ] 210 0.026% 99.891% ( 110, 170 ] 240 0.030% 99.921% ( 170, 250 ] 139 0.017% 99.938% ( 250, 380 ] 174 0.022% 99.960% ( 380, 580 ] 231 0.029% 99.988% ( 580, 870 ] 191 0.024% 100.012% ( 870, 1300 ] 150 0.019% 100.030% ( 1300, 1900 ] 101 0.013% 100.043% ( 1900, 2900 ] 132 0.016% 100.059% ( 2900, 4400 ] 119 0.015% 100.074% ( 4400, 6600 ] 47 0.006% 100.080% ( 6600, 9900 ] 19 0.002% 100.082% ** Level 2 read latency histogram (micros): Count: 77413 Average: 2.7504 StdDev: 18.36 Min: 1 Median: 1.5706 Max: 2739 Percentiles: P50: 1.57 P75: 1.94 P99: 7.36 P99.9: 140.53 P99.99: 653.00 ------------------------------------------------------ [ 0, 1 ] 8983 11.604% 11.604% ## ( 1, 2 ] 52088 67.286% 78.890% ############# ( 2, 3 ] 9411 12.157% 91.047% ## ( 3, 4 ] 3447 4.453% 95.499% # ( 4, 6 ] 2422 3.129% 98.628% # ( 6, 10 ] 844 1.090% 99.718% ( 10, 15 ] 62 0.080% 99.798% ( 15, 22 ] 14 0.018% 99.817% ( 34, 51 ] 2 0.003% 99.819% ( 51, 76 ] 2 0.003% 99.822% ( 76, 110 ] 27 0.035% 99.857% ( 110, 170 ] 66 0.085% 99.942% ( 170, 250 ] 16 0.021% 99.963% ( 250, 380 ] 8 0.010% 99.973% ( 380, 580 ] 12 0.016% 99.988% ( 580, 870 ] 5 0.006% 99.995% ( 870, 1300 ] 2 0.003% 99.997% ( 1300, 1900 ] 4 0.005% 100.003% ( 1900, 2900 ] 1 0.001% 100.004% ** Level 3 read latency histogram (micros): Count: 1003861 Average: 5.9003 StdDev: 83.57 Min: 1 Median: 1.9739 Max: 10973 Percentiles: P50: 1.97 P75: 2.95 P99: 9.20 P99.9: 164.30 P99.99: 392.38 ------------------------------------------------------ [ 0, 1 ] 20940 2.086% 2.086% ( 1, 2 ] 493888 49.199% 51.285% ########## ( 2, 3 ] 249465 24.851% 76.135% ##### ( 3, 4 ] 105224 10.482% 86.617% ## ( 4, 6 ] 107359 10.695% 97.312% ## ( 6, 10 ] 21195 2.111% 99.423% ( 10, 15 ] 3488 0.347% 99.771% ( 15, 22 ] 475 0.047% 99.818% ( 22, 34 ] 66 0.007% 99.825% ( 34, 51 ] 30 0.003% 99.828% ( 51, 76 ] 11 0.001% 99.829% ( 76, 110 ] 232 0.023% 99.852% ( 110, 170 ] 535 0.053% 99.905% ( 170, 250 ] 433 0.043% 99.948% ( 250, 380 ] 392 0.039% 99.987% ( 380, 580 ] 446 0.044% 100.032% ( 580, 870 ] 390 0.039% 100.071% ( 870, 1300 ] 287 0.029% 100.099% ( 1300, 1900 ] 176 0.018% 100.117% ( 1900, 2900 ] 201 0.020% 100.137% ( 2900, 4400 ] 228 0.023% 100.159% ( 4400, 6600 ] 44 0.004% 100.164% ( 6600, 9900 ] 10 0.001% 100.165% ( 9900, 14000 ] 1 0.000% 100.165% ** Level 4 read latency histogram (micros): Count: 30413 Average: 108.7074 StdDev: 493.27 Min: 1 Median: 2.0621 Max: 9280 Percentiles: P50: 2.06 P75: 3.40 P99: 2731.17 P99.9: 5890.58 P99.99: 8533.16 ------------------------------------------------------ [ 0, 1 ] 649 2.134% 2.134% ( 1, 2 ] 14144 46.506% 48.640% ######### ( 2, 3 ] 6663 21.908% 70.549% #### ( 3, 4 ] 3348 11.008% 81.557% ## ( 4, 6 ] 2110 6.938% 88.495% # ( 6, 10 ] 690 2.269% 90.764% ( 10, 15 ] 125 0.411% 91.175% ( 15, 22 ] 16 0.053% 91.227% ( 22, 34 ] 2 0.007% 91.234% ( 51, 76 ] 2 0.007% 91.241% ( 76, 110 ] 40 0.132% 91.372% ( 110, 170 ] 139 0.457% 91.829% ( 170, 250 ] 145 0.477% 92.306% ( 250, 380 ] 232 0.763% 93.069% ( 380, 580 ] 392 1.289% 94.358% ( 580, 870 ] 488 1.605% 95.962% ( 870, 1300 ] 439 1.443% 97.406% ( 1300, 1900 ] 307 1.009% 98.415% ( 1900, 2900 ] 214 0.704% 99.119% ( 2900, 4400 ] 201 0.661% 99.780% ( 4400, 6600 ] 54 0.178% 99.957% ( 6600, 9900 ] 17 0.056% 100.013% ** Level 5 read latency histogram (micros): Count: 180 Average: 1340.8000 StdDev: 1559.16 Min: 82 Median: 665.2941 Max: 7533 Percentiles: P50: 665.29 P75: 2011.11 P99: 6930.00 P99.9: 7533.00 P99.99: 7533.00 ------------------------------------------------------ ( 76, 110 ] 12 6.667% 6.667% # ( 110, 170 ] 32 17.778% 24.444% #### ( 170, 250 ] 12 6.667% 31.111% # ( 250, 380 ] 11 6.111% 37.222% # ( 380, 580 ] 18 10.000% 47.222% ## ( 580, 870 ] 17 9.444% 56.667% ## ( 870, 1300 ] 13 7.222% 63.889% # ( 1300, 1900 ] 18 10.000% 73.889% ## ( 1900, 2900 ] 18 10.000% 83.889% ## ( 2900, 4400 ] 20 11.111% 95.000% ## ( 4400, 6600 ] 7 3.889% 98.889% # ( 6600, 9900 ] 2 1.111% 100.000% ** DB Stats ** Uptime(secs): 39.8 total, 8.5 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 222.79 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:14.632 H:M:S, 36.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 116.46 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.505 H:M:S, 65.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 6.115 micros/op 163532 ops/sec 60.166 seconds 9838999 operations; 158.5 MB/s Microseconds per write: Count: 9838999 Average: 6.1150 StdDev: 414.02 Min: 1 Median: 1.7561 Max: 671140 Percentiles: P50: 1.76 P75: 2.82 P99: 10.00 P99.9: 1160.90 P99.99: 2685.22 ------------------------------------------------------ [ 0, 1 ] 1221469 12.415% 12.415% ## ( 1, 2 ] 4890667 49.707% 62.122% ########## ( 2, 3 ] 1548529 15.739% 77.860% ### ( 3, 4 ] 1369455 13.919% 91.779% ### ( 4, 6 ] 561399 5.706% 97.485% # ( 6, 10 ] 149162 1.516% 99.001% ( 10, 15 ] 52494 0.534% 99.534% ( 15, 22 ] 11642 0.118% 99.653% ( 22, 34 ] 2245 0.023% 99.675% ( 34, 51 ] 278 0.003% 99.678% ( 51, 76 ] 40 0.000% 99.679% ( 76, 110 ] 6582 0.067% 99.746% ( 110, 170 ] 2862 0.029% 99.775% ( 170, 250 ] 304 0.003% 99.778% ( 250, 380 ] 241 0.002% 99.780% ( 380, 580 ] 37 0.000% 99.781% ( 580, 870 ] 26 0.000% 99.781% ( 870, 1300 ] 17336 0.176% 99.957% ( 1300, 1900 ] 85 0.001% 99.958% ( 1900, 2900 ] 4027 0.041% 99.999% ( 2900, 4400 ] 76 0.001% 100.000% ( 4400, 6600 ] 12 0.000% 100.000% ( 6600, 9900 ] 5 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 50000, 75000 ] 2 0.000% 100.000% ( 110000, 170000 ] 3 0.000% 100.000% ( 170000, 250000 ] 11 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 380000, 570000 ] 2 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 197610 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 : 9838999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10153846968 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 : 600 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 32242692 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 : 31928906395 rocksdb.compact.write.bytes COUNT : 31741059013 rocksdb.flush.write.bytes COUNT : 10106894125 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 : 56 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 : 311 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 : 10025297920 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3798016 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 : 32022373680 rocksdb.non.last.level.read.count COUNT : 7738800 rocksdb.block.checksum.compute.count COUNT : 7737656 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.413503 P95 : 3.986417 P99 : 8.803916 P100 : 671138.000000 COUNT : 9838999 SUM : 55374627 rocksdb.compaction.times.micros P50 : 696875.000000 P95 : 3436666.666667 P99 : 13286000.000000 P100 : 17612998.000000 COUNT : 117 SUM : 135976886 rocksdb.compaction.times.cpu_micros P50 : 475000.000000 P95 : 2970000.000000 P99 : 9239000.000000 P100 : 16174720.000000 COUNT : 117 SUM : 113992261 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 : 748.562500 P95 : 6723.750000 P99 : 43710.000000 P100 : 63197.000000 COUNT : 137 SUM : 277950 rocksdb.compaction.outfile.sync.micros P50 : 1160.478723 P95 : 28783.333333 P99 : 96350.000000 P100 : 106978.000000 COUNT : 429 SUM : 2746666 rocksdb.wal.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.manifest.file.sync.micros P50 : 108.080645 P95 : 1293.550000 P99 : 4524.666667 P100 : 5863.000000 COUNT : 283 SUM : 92918 rocksdb.table.open.io.micros P50 : 1312.244898 P95 : 7385.714286 P99 : 12633.333333 P100 : 19131.000000 COUNT : 600 SUM : 1203454 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.687042 P95 : 7.912690 P99 : 11.124732 P100 : 25252.000000 COUNT : 7736042 SUM : 49231823 rocksdb.read.block.get.micros P50 : 358.775510 P95 : 3382.142857 P99 : 5694.117647 P100 : 9822.000000 COUNT : 1200 SUM : 982918 rocksdb.write.raw.block.micros P50 : 0.515048 P95 : 0.978590 P99 : 2.999358 P100 : 14842.000000 COUNT : 10135656 SUM : 20898013 rocksdb.numfiles.in.singlecompaction P50 : 2.318182 P95 : 5.566667 P99 : 13.675000 P100 : 38.000000 COUNT : 153 SUM : 522 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.564639 P95 : 1168.594995 P99 : 2447.922175 P100 : 670958.000000 COUNT : 188838 SUM : 32264109 rocksdb.sst.read.micros P50 : 1.613831 P95 : 4.706287 P99 : 8.470854 P100 : 25248.000000 COUNT : 7739163 SUM : 33197976 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 : 9838999 SUM : 10153846968 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 : 213232.323232 P95 : 387125.000000 P99 : 727566.666667 P100 : 805088.000000 COUNT : 137 SUM : 30161551 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 : 392 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