[2024-12-14 22:21:53.571289] Starting SPDK v25.01-pre git sha1 e01cb43b8 / DPDK 22.11.4 initialization... [2024-12-14 22:21:53.571559] [ 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_pid182577 ] Set seed to 1734211313564627 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-14 22:21:53.687840] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-14 22:21:53.709224] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-14 22:21:53.709266] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 182577' to capture a snapshot of events at runtime. [2024-12-14 22:21:53.709277] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-14 22:21:53.709287] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-14 22:21:53.709295] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid182577 for offline analysis/debug. [2024-12-14 22:21:53.709845] reactor.c: 995:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sat Dec 14 22:21:58 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/14-22:22:00 ... thread 0: (1000000,1000000) ops and (351410.2,351410.2) ops/second in (2.845677,2.845677) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/6 567.04 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 348.9 2.35 2.12 12 0.196 0 0 0.0 0.0 L2 3/2 251.74 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.1 2.0 245.2 245.1 1.54 1.48 2 0.771 383K 193 0.0 0.0 L3 9/0 741.36 MB 0.7 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.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1181/8 96.94 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.9 1.5 97.2 307.7 3.89 3.61 14 0.278 383K 193 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.8 1.5 97.2 307.7 3.89 3.61 14 0.278 383K 193 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.0 0.0 245.2 245.1 1.54 1.48 2 0.771 383K 193 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 348.9 2.35 2.12 12 0.196 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.1 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.17 GB write, 388.39 MB/s write, 0.37 GB read, 122.65 MB/s read, 3.9 seconds Interval compaction: 1.17 GB write, 420.39 MB/s write, 0.37 GB read, 132.76 MB/s read, 3.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 102137 Average: 1.8596 StdDev: 10.66 Min: 0 Median: 1.2379 Max: 2106 Percentiles: P50: 1.24 P75: 1.67 P99: 3.99 P99.9: 10.69 P99.99: 296.44 ------------------------------------------------------ [ 0, 1 ] 37088 36.312% 36.312% ####### ( 1, 2 ] 58772 57.542% 93.854% ############ ( 2, 3 ] 3904 3.822% 97.677% # ( 3, 4 ] 1372 1.343% 99.020% ( 4, 6 ] 635 0.622% 99.642% ( 6, 10 ] 254 0.249% 99.890% ( 10, 15 ] 79 0.077% 99.968% ( 15, 22 ] 7 0.007% 99.975% ( 34, 51 ] 2 0.002% 99.977% ( 51, 76 ] 1 0.001% 99.977% ( 110, 170 ] 7 0.007% 99.984% ( 170, 250 ] 5 0.005% 99.989% ( 250, 380 ] 5 0.005% 99.994% ( 380, 580 ] 1 0.001% 99.995% ( 580, 870 ] 1 0.001% 99.996% ( 870, 1300 ] 3 0.003% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ( 1900, 2900 ] 1 0.001% 100.001% ** Level 1 read latency histogram (micros): Count: 5 Average: 1041.6000 StdDev: 564.34 Min: 323 Median: 977.5000 Max: 2025 Percentiles: P50: 977.50 P75: 1246.25 P99: 2025.00 P99.9: 2025.00 P99.99: 2025.00 ------------------------------------------------------ ( 250, 380 ] 1 20.000% 20.000% #### ( 580, 870 ] 1 20.000% 40.000% #### ( 870, 1300 ] 2 40.000% 80.000% ######## ( 1900, 2900 ] 1 20.000% 100.000% #### ** Level 2 read latency histogram (micros): Count: 51098 Average: 1.9848 StdDev: 13.98 Min: 0 Median: 1.2834 Max: 2355 Percentiles: P50: 1.28 P75: 1.70 P99: 5.03 P99.9: 10.29 P99.99: 689.63 ------------------------------------------------------ [ 0, 1 ] 16943 33.158% 33.158% ####### ( 1, 2 ] 30364 59.423% 92.581% ############ ( 2, 3 ] 2029 3.971% 96.552% # ( 3, 4 ] 967 1.892% 98.444% ( 4, 6 ] 554 1.084% 99.528% ( 6, 10 ] 189 0.370% 99.898% ( 10, 15 ] 33 0.065% 99.963% ( 15, 22 ] 5 0.010% 99.973% ( 22, 34 ] 2 0.004% 99.977% ( 51, 76 ] 1 0.002% 99.978% ( 170, 250 ] 1 0.002% 99.980% ( 250, 380 ] 2 0.004% 99.984% ( 380, 580 ] 2 0.004% 99.988% ( 580, 870 ] 5 0.010% 99.998% ( 870, 1300 ] 1 0.002% 100.000% ( 1900, 2900 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 55 Average: 1456.8364 StdDev: 988.56 Min: 55 Median: 1416.6667 Max: 4361 Percentiles: P50: 1416.67 P75: 1875.00 P99: 4235.00 P99.9: 4361.00 P99.99: 4361.00 ------------------------------------------------------ ( 51, 76 ] 3 5.455% 5.455% # ( 76, 110 ] 2 3.636% 9.091% # ( 170, 250 ] 2 3.636% 12.727% # ( 250, 380 ] 2 3.636% 16.364% # ( 380, 580 ] 3 5.455% 21.818% # ( 580, 870 ] 6 10.909% 32.727% ## ( 870, 1300 ] 6 10.909% 43.636% ## ( 1300, 1900 ] 18 32.727% 76.364% ####### ( 1900, 2900 ] 8 14.545% 90.909% ### ( 2900, 4400 ] 5 9.091% 100.000% ## ** Level 4 read latency histogram (micros): Count: 15 Average: 1625.6667 StdDev: 1555.16 Min: 223 Median: 841.0000 Max: 5279 Percentiles: P50: 841.00 P75: 1750.00 P99: 5279.00 P99.9: 5279.00 P99.99: 5279.00 ------------------------------------------------------ ( 170, 250 ] 1 6.667% 6.667% # ( 250, 380 ] 1 6.667% 13.333% # ( 380, 580 ] 1 6.667% 20.000% # ( 580, 870 ] 5 33.333% 53.333% ####### ( 870, 1300 ] 1 6.667% 60.000% # ( 1300, 1900 ] 3 20.000% 80.000% #### ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 633.0000 StdDev: 956.20 Min: 75 Median: 140.0000 Max: 3893 Percentiles: P50: 140.00 P75: 725.00 P99: 3893.00 P99.9: 3893.00 P99.99: 3893.00 ------------------------------------------------------ ( 51, 76 ] 1 5.000% 5.000% # ( 76, 110 ] 7 35.000% 40.000% ####### ( 110, 170 ] 4 20.000% 60.000% #### ( 250, 380 ] 1 5.000% 65.000% # ( 380, 580 ] 1 5.000% 70.000% # ( 580, 870 ] 2 10.000% 80.000% ## ( 1300, 1900 ] 2 10.000% 90.000% ## ( 1900, 2900 ] 1 5.000% 95.000% # ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 3.1 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 319.40 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.233 H:M:S, 7.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 345.61 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.233 H:M:S, 8.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/14-22:22:04 ... thread 0: (1000000,2000000) ops and (319844.8,334885.4) ops/second in (3.126516,5.972193) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/4 1.17 GB 88.1 0.8 0.0 0.8 2.6 1.8 0.0 1.4 96.5 311.5 8.49 7.86 29 0.293 831K 900 0.0 0.0 L1 1/0 2.81 MB 0.3 0.4 0.4 0.0 0.4 0.4 0.2 1.0 238.8 238.4 1.58 1.54 1 1.583 383K 586 0.0 0.0 L2 2/0 54.45 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 245.2 245.1 1.54 1.48 2 0.771 383K 193 0.0 0.0 L3 42/0 998.29 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 199.3 199.1 4.00 3.50 3 1.332 808K 847 0.0 0.0 L4 144/0 9.53 GB 1.0 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 L5 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1245/4 97.92 GB 0.0 2.3 1.1 1.2 4.1 2.9 2.1 2.3 151.9 268.8 15.61 14.39 35 0.446 2408K 2526 0.0 0.0 Int 0/0 0.00 KB 0.0 2.3 1.1 1.2 4.1 2.9 2.1 2.3 151.9 268.8 15.61 14.39 35 0.446 2408K 2526 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 2.3 1.1 1.2 2.3 1.1 0.0 0.0 229.3 229.0 10.34 9.68 9 1.149 2408K 2526 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 346.8 5.27 4.70 26 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.2 total, 6.0 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: 4.10 GB write, 675.92 MB/s write, 2.32 GB read, 382.04 MB/s read, 15.6 seconds Interval compaction: 4.10 GB write, 702.45 MB/s write, 2.32 GB read, 397.04 MB/s read, 15.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 387550 Average: 2.1795 StdDev: 10.25 Min: 0 Median: 1.4717 Max: 3808 Percentiles: P50: 1.47 P75: 1.87 P99: 5.72 P99.9: 11.21 P99.99: 16.07 ------------------------------------------------------ [ 0, 1 ] 78724 20.313% 20.313% #### ( 1, 2 ] 243916 62.938% 83.251% ############# ( 2, 3 ] 38276 9.876% 93.128% ## ( 3, 4 ] 14303 3.691% 96.818% # ( 4, 6 ] 9858 2.544% 99.362% # ( 6, 10 ] 1978 0.510% 99.872% ( 10, 15 ] 452 0.117% 99.989% ( 15, 22 ] 41 0.011% 99.999% ( 22, 34 ] 6 0.002% 100.001% ( 34, 51 ] 7 0.002% 100.003% ( 51, 76 ] 6 0.002% 100.004% ( 110, 170 ] 13 0.003% 100.008% ( 170, 250 ] 12 0.003% 100.011% ( 250, 380 ] 9 0.002% 100.013% ( 380, 580 ] 4 0.001% 100.014% ( 580, 870 ] 9 0.002% 100.017% ( 870, 1300 ] 6 0.002% 100.018% ( 1300, 1900 ] 3 0.001% 100.019% ( 1900, 2900 ] 1 0.000% 100.019% ( 2900, 4400 ] 1 0.000% 100.019% ** Level 1 read latency histogram (micros): Count: 81751 Average: 2.5939 StdDev: 11.83 Min: 1 Median: 1.6981 Max: 2025 Percentiles: P50: 1.70 P75: 2.31 P99: 6.54 P99.9: 13.16 P99.99: 21.91 ------------------------------------------------------ [ 0, 1 ] 5115 6.257% 6.257% # ( 1, 2 ] 51225 62.660% 68.917% ############# ( 2, 3 ] 15992 19.562% 88.478% #### ( 3, 4 ] 4534 5.546% 94.025% # ( 4, 6 ] 3968 4.854% 98.878% # ( 6, 10 ] 731 0.894% 99.772% ( 10, 15 ] 165 0.202% 99.974% ( 15, 22 ] 13 0.016% 99.990% ( 34, 51 ] 1 0.001% 99.991% ( 110, 170 ] 1 0.001% 99.993% ( 170, 250 ] 1 0.001% 99.994% ( 250, 380 ] 3 0.004% 99.998% ( 380, 580 ] 2 0.002% 100.000% ( 580, 870 ] 2 0.002% 100.002% ( 870, 1300 ] 2 0.002% 100.005% ( 1300, 1900 ] 1 0.001% 100.006% ( 1900, 2900 ] 1 0.001% 100.007% ** Level 2 read latency histogram (micros): Count: 95432 Average: 2.1189 StdDev: 10.26 Min: 0 Median: 1.4359 Max: 2355 Percentiles: P50: 1.44 P75: 1.83 P99: 5.54 P99.9: 9.86 P99.99: 344.69 ------------------------------------------------------ [ 0, 1 ] 21233 22.249% 22.249% #### ( 1, 2 ] 60759 63.667% 85.917% ############# ( 2, 3 ] 7733 8.103% 94.020% ## ( 3, 4 ] 3223 3.377% 97.397% # ( 4, 6 ] 1982 2.077% 99.474% ( 6, 10 ] 421 0.441% 99.915% ( 10, 15 ] 55 0.058% 99.973% ( 15, 22 ] 10 0.010% 99.983% ( 22, 34 ] 3 0.003% 99.986% ( 51, 76 ] 1 0.001% 99.987% ( 170, 250 ] 1 0.001% 99.988% ( 250, 380 ] 2 0.002% 99.991% ( 380, 580 ] 2 0.002% 99.993% ( 580, 870 ] 5 0.005% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57436 Average: 3.9817 StdDev: 54.81 Min: 0 Median: 1.6966 Max: 4361 Percentiles: P50: 1.70 P75: 2.32 P99: 7.35 P99.9: 190.85 P99.99: 2432.05 ------------------------------------------------------ [ 0, 1 ] 3826 6.661% 6.661% # ( 1, 2 ] 35731 62.210% 68.871% ############ ( 2, 3 ] 11030 19.204% 88.075% #### ( 3, 4 ] 3255 5.667% 93.743% # ( 4, 6 ] 2849 4.960% 98.703% # ( 6, 10 ] 506 0.881% 99.584% ( 10, 15 ] 105 0.183% 99.767% ( 15, 22 ] 16 0.028% 99.795% ( 22, 34 ] 37 0.064% 99.859% ( 34, 51 ] 13 0.023% 99.882% ( 51, 76 ] 4 0.007% 99.889% ( 76, 110 ] 2 0.003% 99.892% ( 110, 170 ] 3 0.005% 99.897% ( 170, 250 ] 6 0.010% 99.908% ( 250, 380 ] 5 0.009% 99.916% ( 380, 580 ] 7 0.012% 99.929% ( 580, 870 ] 6 0.010% 99.939% ( 870, 1300 ] 7 0.012% 99.951% ( 1300, 1900 ] 18 0.031% 99.983% ( 1900, 2900 ] 8 0.014% 99.997% ( 2900, 4400 ] 5 0.009% 100.005% ** Level 4 read latency histogram (micros): Count: 15 Average: 1625.6667 StdDev: 1555.16 Min: 223 Median: 841.0000 Max: 5279 Percentiles: P50: 841.00 P75: 1750.00 P99: 5279.00 P99.9: 5279.00 P99.99: 5279.00 ------------------------------------------------------ ( 170, 250 ] 1 6.667% 6.667% # ( 250, 380 ] 1 6.667% 13.333% # ( 380, 580 ] 1 6.667% 20.000% # ( 580, 870 ] 5 33.333% 53.333% ####### ( 870, 1300 ] 1 6.667% 60.000% # ( 1300, 1900 ] 3 20.000% 80.000% #### ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 710.3000 StdDev: 961.81 Min: 75 Median: 210.0000 Max: 3893 Percentiles: P50: 210.00 P75: 797.50 P99: 3893.00 P99.9: 3893.00 P99.99: 3893.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 9 22.500% 25.000% ##### ( 110, 170 ] 8 20.000% 45.000% #### ( 170, 250 ] 4 10.000% 55.000% ## ( 250, 380 ] 2 5.000% 60.000% # ( 380, 580 ] 3 7.500% 67.500% ## ( 580, 870 ] 4 10.000% 77.500% ## ( 1300, 1900 ] 4 10.000% 87.500% ## ( 1900, 2900 ] 2 5.000% 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, 317.08 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.638 H:M:S, 10.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 314.79 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.405 H:M:S, 13.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/14-22:22:07 ... thread 0: (1000000,3000000) ops and (325469.0,331686.6) ops/second in (3.072489,9.044682) 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/12 2.15 GB 25.2 1.6 0.0 1.6 4.4 2.8 0.0 1.6 114.2 311.7 14.35 13.36 46 0.312 1663K 1760 0.0 0.0 L1 1/1 2.81 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 238.8 238.4 1.58 1.54 1 1.583 383K 586 0.0 0.0 L2 2/0 54.45 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 245.2 245.1 1.54 1.48 2 0.771 383K 193 0.0 0.0 L3 42/0 998.29 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 199.3 199.1 4.00 3.50 3 1.332 808K 847 0.0 0.0 L4 144/0 9.53 GB 1.0 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 L5 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1250/13 98.90 GB 0.0 3.1 1.1 2.0 5.9 3.9 2.1 2.1 148.6 280.5 21.47 19.88 52 0.413 3239K 3386 0.0 0.0 Int 0/0 0.00 KB 0.0 3.1 1.1 2.0 5.9 3.9 2.1 2.1 148.6 280.5 21.47 19.88 52 0.413 3239K 3386 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.1 1.1 2.0 3.1 1.1 0.0 0.0 238.3 238.1 13.39 12.67 12 1.116 3239K 3386 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.8 8.08 7.22 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.3 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.88 GB write, 648.91 MB/s write, 3.12 GB read, 343.81 MB/s read, 21.5 seconds Interval compaction: 5.88 GB write, 665.73 MB/s write, 3.12 GB read, 352.72 MB/s read, 21.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 680817 Average: 2.1141 StdDev: 10.06 Min: 0 Median: 1.4443 Max: 3808 Percentiles: P50: 1.44 P75: 1.84 P99: 5.53 P99.9: 11.05 P99.99: 14.98 ------------------------------------------------------ [ 0, 1 ] 147379 21.647% 21.647% #### ( 1, 2 ] 434410 63.807% 85.455% ############# ( 2, 3 ] 61276 9.000% 94.455% ## ( 3, 4 ] 21114 3.101% 97.556% # ( 4, 6 ] 12869 1.890% 99.446% ( 6, 10 ] 2924 0.429% 99.876% ( 10, 15 ] 780 0.115% 99.990% ( 15, 22 ] 63 0.009% 100.000% ( 22, 34 ] 10 0.001% 100.001% ( 34, 51 ] 8 0.001% 100.002% ( 51, 76 ] 7 0.001% 100.003% ( 110, 170 ] 23 0.003% 100.007% ( 170, 250 ] 16 0.002% 100.009% ( 250, 380 ] 13 0.002% 100.011% ( 380, 580 ] 9 0.001% 100.012% ( 580, 870 ] 13 0.002% 100.014% ( 870, 1300 ] 8 0.001% 100.015% ( 1300, 1900 ] 5 0.001% 100.016% ( 1900, 2900 ] 4 0.001% 100.017% ( 2900, 4400 ] 1 0.000% 100.017% ** Level 1 read latency histogram (micros): Count: 81752 Average: 2.5939 StdDev: 11.83 Min: 1 Median: 1.6981 Max: 2025 Percentiles: P50: 1.70 P75: 2.31 P99: 6.54 P99.9: 13.16 P99.99: 21.91 ------------------------------------------------------ [ 0, 1 ] 5115 6.257% 6.257% # ( 1, 2 ] 51225 62.659% 68.916% ############# ( 2, 3 ] 15993 19.563% 88.479% #### ( 3, 4 ] 4534 5.546% 94.025% # ( 4, 6 ] 3968 4.854% 98.878% # ( 6, 10 ] 731 0.894% 99.772% ( 10, 15 ] 165 0.202% 99.974% ( 15, 22 ] 13 0.016% 99.990% ( 34, 51 ] 1 0.001% 99.991% ( 110, 170 ] 1 0.001% 99.993% ( 170, 250 ] 1 0.001% 99.994% ( 250, 380 ] 3 0.004% 99.998% ( 380, 580 ] 2 0.002% 100.000% ( 580, 870 ] 2 0.002% 100.002% ( 870, 1300 ] 2 0.002% 100.005% ( 1300, 1900 ] 1 0.001% 100.006% ( 1900, 2900 ] 1 0.001% 100.007% ** Level 2 read latency histogram (micros): Count: 95432 Average: 2.1189 StdDev: 10.26 Min: 0 Median: 1.4359 Max: 2355 Percentiles: P50: 1.44 P75: 1.83 P99: 5.54 P99.9: 9.86 P99.99: 344.69 ------------------------------------------------------ [ 0, 1 ] 21233 22.249% 22.249% #### ( 1, 2 ] 60759 63.667% 85.917% ############# ( 2, 3 ] 7733 8.103% 94.020% ## ( 3, 4 ] 3223 3.377% 97.397% # ( 4, 6 ] 1982 2.077% 99.474% ( 6, 10 ] 421 0.441% 99.915% ( 10, 15 ] 55 0.058% 99.973% ( 15, 22 ] 10 0.010% 99.983% ( 22, 34 ] 3 0.003% 99.986% ( 51, 76 ] 1 0.001% 99.987% ( 170, 250 ] 1 0.001% 99.988% ( 250, 380 ] 2 0.002% 99.991% ( 380, 580 ] 2 0.002% 99.993% ( 580, 870 ] 5 0.005% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57436 Average: 3.9817 StdDev: 54.81 Min: 0 Median: 1.6966 Max: 4361 Percentiles: P50: 1.70 P75: 2.32 P99: 7.35 P99.9: 190.85 P99.99: 2432.05 ------------------------------------------------------ [ 0, 1 ] 3826 6.661% 6.661% # ( 1, 2 ] 35731 62.210% 68.871% ############ ( 2, 3 ] 11030 19.204% 88.075% #### ( 3, 4 ] 3255 5.667% 93.743% # ( 4, 6 ] 2849 4.960% 98.703% # ( 6, 10 ] 506 0.881% 99.584% ( 10, 15 ] 105 0.183% 99.767% ( 15, 22 ] 16 0.028% 99.795% ( 22, 34 ] 37 0.064% 99.859% ( 34, 51 ] 13 0.023% 99.882% ( 51, 76 ] 4 0.007% 99.889% ( 76, 110 ] 2 0.003% 99.892% ( 110, 170 ] 3 0.005% 99.897% ( 170, 250 ] 6 0.010% 99.908% ( 250, 380 ] 5 0.009% 99.916% ( 380, 580 ] 7 0.012% 99.929% ( 580, 870 ] 6 0.010% 99.939% ( 870, 1300 ] 7 0.012% 99.951% ( 1300, 1900 ] 18 0.031% 99.983% ( 1900, 2900 ] 8 0.014% 99.997% ( 2900, 4400 ] 5 0.009% 100.005% ** Level 4 read latency histogram (micros): Count: 15 Average: 1625.6667 StdDev: 1555.16 Min: 223 Median: 841.0000 Max: 5279 Percentiles: P50: 841.00 P75: 1750.00 P99: 5279.00 P99.9: 5279.00 P99.99: 5279.00 ------------------------------------------------------ ( 170, 250 ] 1 6.667% 6.667% # ( 250, 380 ] 1 6.667% 13.333% # ( 380, 580 ] 1 6.667% 20.000% # ( 580, 870 ] 5 33.333% 53.333% ####### ( 870, 1300 ] 1 6.667% 60.000% # ( 1300, 1900 ] 3 20.000% 80.000% #### ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 710.3000 StdDev: 961.81 Min: 75 Median: 210.0000 Max: 3893 Percentiles: P50: 210.00 P75: 797.50 P99: 3893.00 P99.9: 3893.00 P99.99: 3893.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 9 22.500% 25.000% ##### ( 110, 170 ] 8 20.000% 45.000% #### ( 170, 250 ] 4 10.000% 55.000% ## ( 250, 380 ] 2 5.000% 60.000% # ( 380, 580 ] 3 7.500% 67.500% ## ( 580, 870 ] 4 10.000% 77.500% ## ( 1300, 1900 ] 4 10.000% 87.500% ## ( 1900, 2900 ] 2 5.000% 92.500% # ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 9.3 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 318.15 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.049 H:M:S, 11.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.32 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/14-22:22:10 ... thread 0: (1000000,4000000) ops and (320413.6,328794.7) ops/second in (3.120966,12.165648) 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/12 3.13 GB 125.9 2.5 0.0 2.5 6.2 3.7 0.0 1.7 122.0 307.8 20.66 19.28 63 0.328 2558K 2719 0.0 0.0 L1 1/1 2.81 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 238.8 238.4 1.58 1.54 1 1.583 383K 586 0.0 0.0 L2 2/0 54.45 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 245.2 245.1 1.54 1.48 2 0.771 383K 193 0.0 0.0 L3 42/0 998.29 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 199.3 199.1 4.00 3.50 3 1.332 808K 847 0.0 0.0 L4 144/0 9.53 GB 1.0 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 L5 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1255/13 99.88 GB 0.0 4.0 1.1 2.9 7.7 4.9 2.1 2.1 146.6 284.7 27.78 25.80 69 0.403 4135K 4345 0.0 0.0 Int 0/0 0.00 KB 0.0 4.0 1.1 2.9 7.7 4.9 2.1 2.1 146.6 284.7 27.78 25.80 69 0.403 4135K 4345 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.0 1.1 2.9 4.0 1.1 0.0 0.0 242.7 242.4 16.78 16.01 15 1.119 4135K 4345 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 349.3 11.00 9.80 54 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.4 total, 12.2 interval Flush(GB): cumulative 3.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.73 GB write, 637.91 MB/s write, 3.98 GB read, 328.40 MB/s read, 27.8 seconds Interval compaction: 7.73 GB write, 650.20 MB/s write, 3.98 GB read, 334.73 MB/s read, 27.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 14, interval: 15 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1106480 Average: 2.1887 StdDev: 10.45 Min: 0 Median: 1.4859 Max: 3808 Percentiles: P50: 1.49 P75: 1.87 P99: 5.60 P99.9: 11.02 P99.99: 14.93 ------------------------------------------------------ [ 0, 1 ] 201660 18.225% 18.225% #### ( 1, 2 ] 723529 65.390% 83.616% ############# ( 2, 3 ] 115534 10.442% 94.057% ## ( 3, 4 ] 36623 3.310% 97.367% # ( 4, 6 ] 22570 2.040% 99.407% ( 6, 10 ] 5199 0.470% 99.877% ( 10, 15 ] 1273 0.115% 99.992% ( 15, 22 ] 96 0.009% 100.000% ( 22, 34 ] 13 0.001% 100.002% ( 34, 51 ] 10 0.001% 100.002% ( 51, 76 ] 9 0.001% 100.003% ( 76, 110 ] 30 0.003% 100.006% ( 110, 170 ] 78 0.007% 100.013% ( 170, 250 ] 37 0.003% 100.016% ( 250, 380 ] 25 0.002% 100.019% ( 380, 580 ] 19 0.002% 100.020% ( 580, 870 ] 20 0.002% 100.022% ( 870, 1300 ] 17 0.002% 100.024% ( 1300, 1900 ] 10 0.001% 100.025% ( 1900, 2900 ] 4 0.000% 100.025% ( 2900, 4400 ] 3 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 81752 Average: 2.5939 StdDev: 11.83 Min: 1 Median: 1.6981 Max: 2025 Percentiles: P50: 1.70 P75: 2.31 P99: 6.54 P99.9: 13.16 P99.99: 21.91 ------------------------------------------------------ [ 0, 1 ] 5115 6.257% 6.257% # ( 1, 2 ] 51225 62.659% 68.916% ############# ( 2, 3 ] 15993 19.563% 88.479% #### ( 3, 4 ] 4534 5.546% 94.025% # ( 4, 6 ] 3968 4.854% 98.878% # ( 6, 10 ] 731 0.894% 99.772% ( 10, 15 ] 165 0.202% 99.974% ( 15, 22 ] 13 0.016% 99.990% ( 34, 51 ] 1 0.001% 99.991% ( 110, 170 ] 1 0.001% 99.993% ( 170, 250 ] 1 0.001% 99.994% ( 250, 380 ] 3 0.004% 99.998% ( 380, 580 ] 2 0.002% 100.000% ( 580, 870 ] 2 0.002% 100.002% ( 870, 1300 ] 2 0.002% 100.005% ( 1300, 1900 ] 1 0.001% 100.006% ( 1900, 2900 ] 1 0.001% 100.007% ** Level 2 read latency histogram (micros): Count: 95432 Average: 2.1189 StdDev: 10.26 Min: 0 Median: 1.4359 Max: 2355 Percentiles: P50: 1.44 P75: 1.83 P99: 5.54 P99.9: 9.86 P99.99: 344.69 ------------------------------------------------------ [ 0, 1 ] 21233 22.249% 22.249% #### ( 1, 2 ] 60759 63.667% 85.917% ############# ( 2, 3 ] 7733 8.103% 94.020% ## ( 3, 4 ] 3223 3.377% 97.397% # ( 4, 6 ] 1982 2.077% 99.474% ( 6, 10 ] 421 0.441% 99.915% ( 10, 15 ] 55 0.058% 99.973% ( 15, 22 ] 10 0.010% 99.983% ( 22, 34 ] 3 0.003% 99.986% ( 51, 76 ] 1 0.001% 99.987% ( 170, 250 ] 1 0.001% 99.988% ( 250, 380 ] 2 0.002% 99.991% ( 380, 580 ] 2 0.002% 99.993% ( 580, 870 ] 5 0.005% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57436 Average: 3.9817 StdDev: 54.81 Min: 0 Median: 1.6966 Max: 4361 Percentiles: P50: 1.70 P75: 2.32 P99: 7.35 P99.9: 190.85 P99.99: 2432.05 ------------------------------------------------------ [ 0, 1 ] 3826 6.661% 6.661% # ( 1, 2 ] 35731 62.210% 68.871% ############ ( 2, 3 ] 11030 19.204% 88.075% #### ( 3, 4 ] 3255 5.667% 93.743% # ( 4, 6 ] 2849 4.960% 98.703% # ( 6, 10 ] 506 0.881% 99.584% ( 10, 15 ] 105 0.183% 99.767% ( 15, 22 ] 16 0.028% 99.795% ( 22, 34 ] 37 0.064% 99.859% ( 34, 51 ] 13 0.023% 99.882% ( 51, 76 ] 4 0.007% 99.889% ( 76, 110 ] 2 0.003% 99.892% ( 110, 170 ] 3 0.005% 99.897% ( 170, 250 ] 6 0.010% 99.908% ( 250, 380 ] 5 0.009% 99.916% ( 380, 580 ] 7 0.012% 99.929% ( 580, 870 ] 6 0.010% 99.939% ( 870, 1300 ] 7 0.012% 99.951% ( 1300, 1900 ] 18 0.031% 99.983% ( 1900, 2900 ] 8 0.014% 99.997% ( 2900, 4400 ] 5 0.009% 100.005% ** Level 4 read latency histogram (micros): Count: 15 Average: 1625.6667 StdDev: 1555.16 Min: 223 Median: 841.0000 Max: 5279 Percentiles: P50: 841.00 P75: 1750.00 P99: 5279.00 P99.9: 5279.00 P99.99: 5279.00 ------------------------------------------------------ ( 170, 250 ] 1 6.667% 6.667% # ( 250, 380 ] 1 6.667% 13.333% # ( 380, 580 ] 1 6.667% 20.000% # ( 580, 870 ] 5 33.333% 53.333% ####### ( 870, 1300 ] 1 6.667% 60.000% # ( 1300, 1900 ] 3 20.000% 80.000% #### ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 710.3000 StdDev: 961.81 Min: 75 Median: 210.0000 Max: 3893 Percentiles: P50: 210.00 P75: 797.50 P99: 3893.00 P99.9: 3893.00 P99.99: 3893.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 9 22.500% 25.000% ##### ( 110, 170 ] 8 20.000% 45.000% #### ( 170, 250 ] 4 10.000% 55.000% ## ( 250, 380 ] 2 5.000% 60.000% # ( 380, 580 ] 3 7.500% 67.500% ## ( 580, 870 ] 4 10.000% 77.500% ## ( 1300, 1900 ] 4 10.000% 87.500% ## ( 1900, 2900 ] 2 5.000% 92.500% # ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 12.4 total, 3.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 317.45 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.452 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, 315.35 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.403 H:M:S, 12.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/14-22:22:13 ... thread 0: (1000000,5000000) ops and (269476.8,314930.0) ops/second in (3.710894,15.876542) 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/14 2.46 GB 12.6 3.3 0.0 3.3 7.9 4.7 0.0 1.7 125.9 306.3 26.52 24.76 81 0.327 3390K 3613 0.0 0.0 L1 14/14 1.59 GB 0.0 2.0 2.0 0.0 2.0 2.0 0.2 1.0 230.3 228.9 8.76 8.45 2 4.379 2048K 12K 0.0 0.0 L2 2/0 54.45 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 245.2 245.1 1.54 1.48 2 0.771 383K 193 0.0 0.0 L3 42/0 998.29 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 199.3 199.1 4.00 3.50 3 1.332 808K 847 0.0 0.0 L4 144/0 9.53 GB 1.0 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 L5 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1266/28 100.80 GB 0.0 6.4 2.7 3.7 11.0 7.4 2.1 2.4 160.0 276.9 40.82 38.20 88 0.464 6631K 16K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.4 2.7 3.7 11.0 7.4 2.1 2.4 160.0 276.9 40.82 38.20 88 0.464 6631K 16K 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.7 3.7 6.4 2.7 0.0 0.0 240.9 240.3 27.11 26.02 19 1.427 6631K 16K 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 349.3 13.71 12.18 69 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 16.1 total, 15.9 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, 701.41 MB/s write, 6.38 GB read, 405.33 MB/s read, 40.8 seconds Interval compaction: 11.04 GB write, 711.77 MB/s write, 6.38 GB read, 411.32 MB/s read, 40.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 6, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 6, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 6, total-stops: 14, interval: 20 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1489284 Average: 2.2385 StdDev: 11.92 Min: 0 Median: 1.4921 Max: 4069 Percentiles: P50: 1.49 P75: 1.87 P99: 5.66 P99.9: 11.59 P99.99: 83.71 ------------------------------------------------------ [ 0, 1 ] 261680 17.571% 17.571% #### ( 1, 2 ] 981512 65.905% 83.476% ############# ( 2, 3 ] 156779 10.527% 94.003% ## ( 3, 4 ] 49318 3.312% 97.314% # ( 4, 6 ] 30256 2.032% 99.346% ( 6, 10 ] 7724 0.519% 99.865% ( 10, 15 ] 1654 0.111% 99.976% ( 15, 22 ] 147 0.010% 99.986% ( 22, 34 ] 14 0.001% 99.987% ( 34, 51 ] 13 0.001% 99.987% ( 51, 76 ] 13 0.001% 99.988% ( 76, 110 ] 115 0.008% 99.996% ( 110, 170 ] 197 0.013% 100.009% ( 170, 250 ] 96 0.006% 100.016% ( 250, 380 ] 61 0.004% 100.020% ( 380, 580 ] 46 0.003% 100.023% ( 580, 870 ] 38 0.003% 100.025% ( 870, 1300 ] 24 0.002% 100.027% ( 1300, 1900 ] 11 0.001% 100.028% ( 1900, 2900 ] 5 0.000% 100.028% ( 2900, 4400 ] 7 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 113130 Average: 2.6974 StdDev: 17.75 Min: 1 Median: 1.6075 Max: 2827 Percentiles: P50: 1.61 P75: 2.03 P99: 6.93 P99.9: 88.75 P99.99: 613.20 ------------------------------------------------------ [ 0, 1 ] 13651 12.067% 12.067% ## ( 1, 2 ] 70640 62.441% 74.508% ############ ( 2, 3 ] 17703 15.648% 90.156% ### ( 3, 4 ] 5368 4.745% 94.901% # ( 4, 6 ] 4397 3.887% 98.788% # ( 6, 10 ] 1026 0.907% 99.695% ( 10, 15 ] 192 0.170% 99.865% ( 15, 22 ] 18 0.016% 99.881% ( 22, 34 ] 1 0.001% 99.882% ( 34, 51 ] 1 0.001% 99.882% ( 76, 110 ] 53 0.047% 99.929% ( 110, 170 ] 36 0.032% 99.961% ( 170, 250 ] 5 0.004% 99.966% ( 250, 380 ] 18 0.016% 99.981% ( 380, 580 ] 9 0.008% 99.989% ( 580, 870 ] 6 0.005% 99.995% ( 870, 1300 ] 7 0.006% 100.001% ( 1300, 1900 ] 3 0.003% 100.004% ( 1900, 2900 ] 2 0.002% 100.005% ** Level 2 read latency histogram (micros): Count: 95432 Average: 2.1189 StdDev: 10.26 Min: 0 Median: 1.4359 Max: 2355 Percentiles: P50: 1.44 P75: 1.83 P99: 5.54 P99.9: 9.86 P99.99: 344.69 ------------------------------------------------------ [ 0, 1 ] 21233 22.249% 22.249% #### ( 1, 2 ] 60759 63.667% 85.917% ############# ( 2, 3 ] 7733 8.103% 94.020% ## ( 3, 4 ] 3223 3.377% 97.397% # ( 4, 6 ] 1982 2.077% 99.474% ( 6, 10 ] 421 0.441% 99.915% ( 10, 15 ] 55 0.058% 99.973% ( 15, 22 ] 10 0.010% 99.983% ( 22, 34 ] 3 0.003% 99.986% ( 51, 76 ] 1 0.001% 99.987% ( 170, 250 ] 1 0.001% 99.988% ( 250, 380 ] 2 0.002% 99.991% ( 380, 580 ] 2 0.002% 99.993% ( 580, 870 ] 5 0.005% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57436 Average: 3.9817 StdDev: 54.81 Min: 0 Median: 1.6966 Max: 4361 Percentiles: P50: 1.70 P75: 2.32 P99: 7.35 P99.9: 190.85 P99.99: 2432.05 ------------------------------------------------------ [ 0, 1 ] 3826 6.661% 6.661% # ( 1, 2 ] 35731 62.210% 68.871% ############ ( 2, 3 ] 11030 19.204% 88.075% #### ( 3, 4 ] 3255 5.667% 93.743% # ( 4, 6 ] 2849 4.960% 98.703% # ( 6, 10 ] 506 0.881% 99.584% ( 10, 15 ] 105 0.183% 99.767% ( 15, 22 ] 16 0.028% 99.795% ( 22, 34 ] 37 0.064% 99.859% ( 34, 51 ] 13 0.023% 99.882% ( 51, 76 ] 4 0.007% 99.889% ( 76, 110 ] 2 0.003% 99.892% ( 110, 170 ] 3 0.005% 99.897% ( 170, 250 ] 6 0.010% 99.908% ( 250, 380 ] 5 0.009% 99.916% ( 380, 580 ] 7 0.012% 99.929% ( 580, 870 ] 6 0.010% 99.939% ( 870, 1300 ] 7 0.012% 99.951% ( 1300, 1900 ] 18 0.031% 99.983% ( 1900, 2900 ] 8 0.014% 99.997% ( 2900, 4400 ] 5 0.009% 100.005% ** Level 4 read latency histogram (micros): Count: 15 Average: 1625.6667 StdDev: 1555.16 Min: 223 Median: 841.0000 Max: 5279 Percentiles: P50: 841.00 P75: 1750.00 P99: 5279.00 P99.9: 5279.00 P99.99: 5279.00 ------------------------------------------------------ ( 170, 250 ] 1 6.667% 6.667% # ( 250, 380 ] 1 6.667% 13.333% # ( 380, 580 ] 1 6.667% 20.000% # ( 580, 870 ] 5 33.333% 53.333% ####### ( 870, 1300 ] 1 6.667% 60.000% # ( 1300, 1900 ] 3 20.000% 80.000% #### ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 710.3000 StdDev: 961.81 Min: 75 Median: 210.0000 Max: 3893 Percentiles: P50: 210.00 P75: 797.50 P99: 3893.00 P99.9: 3893.00 P99.99: 3893.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 9 22.500% 25.000% ##### ( 110, 170 ] 8 20.000% 45.000% #### ( 170, 250 ] 4 10.000% 55.000% ## ( 250, 380 ] 2 5.000% 60.000% # ( 380, 580 ] 3 7.500% 67.500% ## ( 580, 870 ] 4 10.000% 77.500% ## ( 1300, 1900 ] 4 10.000% 87.500% ## ( 1900, 2900 ] 2 5.000% 92.500% # ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 16.1 total, 3.7 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 305.42 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.438 H:M:S, 15.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 265.22 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.987 H:M:S, 26.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/14-22:22:17 ... thread 0: (1000000,6000000) ops and (274594.2,307404.2) ops/second in (3.641737,19.518279) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/10 3.50 GB 144.8 4.3 0.0 4.3 10.0 5.7 0.0 1.8 131.2 305.3 33.62 31.46 99 0.340 4477K 4710 0.0 0.0 L1 14/14 1.59 GB 0.0 2.0 2.0 0.0 2.0 2.0 0.2 1.0 230.3 228.9 8.76 8.45 2 4.379 2048K 12K 0.0 0.0 L2 2/0 54.45 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 245.2 245.1 1.54 1.48 2 0.771 383K 193 0.0 0.0 L3 42/0 998.29 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 199.3 199.1 4.00 3.50 3 1.332 808K 847 0.0 0.0 L4 144/0 9.53 GB 1.0 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 L5 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1268/24 101.84 GB 0.0 7.4 2.7 4.7 13.1 8.4 2.1 2.3 158.6 280.5 47.92 44.90 106 0.452 7718K 17K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.4 2.7 4.7 13.1 8.4 2.1 2.3 158.6 280.5 47.92 44.90 106 0.452 7718K 17K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.4 2.7 4.7 7.4 2.7 0.0 0.0 244.1 243.5 31.14 29.96 23 1.354 7718K 17K 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 349.3 16.77 14.94 83 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): 19.8 total, 19.5 interval Flush(GB): cumulative 5.721, interval 5.721 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 13.13 GB write, 680.47 MB/s write, 7.42 GB read, 384.82 MB/s read, 47.9 seconds Interval compaction: 13.13 GB write, 688.64 MB/s write, 7.42 GB read, 389.44 MB/s read, 47.9 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: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 9, total-stops: 17, interval: 26 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1853977 Average: 2.2397 StdDev: 12.06 Min: 0 Median: 1.4962 Max: 4069 Percentiles: P50: 1.50 P75: 1.87 P99: 5.64 P99.9: 11.27 P99.99: 82.09 ------------------------------------------------------ [ 0, 1 ] 317245 17.112% 17.112% ### ( 1, 2 ] 1228844 66.282% 83.393% ############# ( 2, 3 ] 197813 10.670% 94.063% ## ( 3, 4 ] 61298 3.306% 97.369% # ( 4, 6 ] 36942 1.993% 99.362% ( 6, 10 ] 9500 0.512% 99.874% ( 10, 15 ] 1901 0.103% 99.977% ( 15, 22 ] 174 0.009% 99.986% ( 22, 34 ] 19 0.001% 99.987% ( 34, 51 ] 17 0.001% 99.988% ( 51, 76 ] 13 0.001% 99.989% ( 76, 110 ] 143 0.008% 99.996% ( 110, 170 ] 228 0.012% 100.009% ( 170, 250 ] 118 0.006% 100.015% ( 250, 380 ] 76 0.004% 100.019% ( 380, 580 ] 52 0.003% 100.022% ( 580, 870 ] 48 0.003% 100.024% ( 870, 1300 ] 31 0.002% 100.026% ( 1300, 1900 ] 12 0.001% 100.027% ( 1900, 2900 ] 5 0.000% 100.027% ( 2900, 4400 ] 10 0.001% 100.028% ** Level 1 read latency histogram (micros): Count: 204649 Average: 2.6532 StdDev: 15.09 Min: 1 Median: 1.5739 Max: 2827 Percentiles: P50: 1.57 P75: 1.96 P99: 7.53 P99.9: 119.13 P99.99: 568.73 ------------------------------------------------------ [ 0, 1 ] 26025 12.717% 12.717% ### ( 1, 2 ] 132950 64.965% 77.682% ############# ( 2, 3 ] 28424 13.889% 91.571% ### ( 3, 4 ] 8052 3.935% 95.505% # ( 4, 6 ] 6260 3.059% 98.564% # ( 6, 10 ] 2337 1.142% 99.706% ( 10, 15 ] 248 0.121% 99.828% ( 15, 22 ] 25 0.012% 99.840% ( 22, 34 ] 1 0.000% 99.840% ( 34, 51 ] 2 0.001% 99.841% ( 76, 110 ] 103 0.050% 99.892% ( 110, 170 ] 114 0.056% 99.947% ( 170, 250 ] 36 0.018% 99.965% ( 250, 380 ] 27 0.013% 99.978% ( 380, 580 ] 26 0.013% 99.991% ( 580, 870 ] 13 0.006% 99.997% ( 870, 1300 ] 7 0.003% 100.000% ( 1300, 1900 ] 3 0.001% 100.002% ( 1900, 2900 ] 2 0.001% 100.003% ** Level 2 read latency histogram (micros): Count: 95432 Average: 2.1189 StdDev: 10.26 Min: 0 Median: 1.4359 Max: 2355 Percentiles: P50: 1.44 P75: 1.83 P99: 5.54 P99.9: 9.86 P99.99: 344.69 ------------------------------------------------------ [ 0, 1 ] 21233 22.249% 22.249% #### ( 1, 2 ] 60759 63.667% 85.917% ############# ( 2, 3 ] 7733 8.103% 94.020% ## ( 3, 4 ] 3223 3.377% 97.397% # ( 4, 6 ] 1982 2.077% 99.474% ( 6, 10 ] 421 0.441% 99.915% ( 10, 15 ] 55 0.058% 99.973% ( 15, 22 ] 10 0.010% 99.983% ( 22, 34 ] 3 0.003% 99.986% ( 51, 76 ] 1 0.001% 99.987% ( 170, 250 ] 1 0.001% 99.988% ( 250, 380 ] 2 0.002% 99.991% ( 380, 580 ] 2 0.002% 99.993% ( 580, 870 ] 5 0.005% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57436 Average: 3.9817 StdDev: 54.81 Min: 0 Median: 1.6966 Max: 4361 Percentiles: P50: 1.70 P75: 2.32 P99: 7.35 P99.9: 190.85 P99.99: 2432.05 ------------------------------------------------------ [ 0, 1 ] 3826 6.661% 6.661% # ( 1, 2 ] 35731 62.210% 68.871% ############ ( 2, 3 ] 11030 19.204% 88.075% #### ( 3, 4 ] 3255 5.667% 93.743% # ( 4, 6 ] 2849 4.960% 98.703% # ( 6, 10 ] 506 0.881% 99.584% ( 10, 15 ] 105 0.183% 99.767% ( 15, 22 ] 16 0.028% 99.795% ( 22, 34 ] 37 0.064% 99.859% ( 34, 51 ] 13 0.023% 99.882% ( 51, 76 ] 4 0.007% 99.889% ( 76, 110 ] 2 0.003% 99.892% ( 110, 170 ] 3 0.005% 99.897% ( 170, 250 ] 6 0.010% 99.908% ( 250, 380 ] 5 0.009% 99.916% ( 380, 580 ] 7 0.012% 99.929% ( 580, 870 ] 6 0.010% 99.939% ( 870, 1300 ] 7 0.012% 99.951% ( 1300, 1900 ] 18 0.031% 99.983% ( 1900, 2900 ] 8 0.014% 99.997% ( 2900, 4400 ] 5 0.009% 100.005% ** Level 4 read latency histogram (micros): Count: 15 Average: 1625.6667 StdDev: 1555.16 Min: 223 Median: 841.0000 Max: 5279 Percentiles: P50: 841.00 P75: 1750.00 P99: 5279.00 P99.9: 5279.00 P99.99: 5279.00 ------------------------------------------------------ ( 170, 250 ] 1 6.667% 6.667% # ( 250, 380 ] 1 6.667% 13.333% # ( 380, 580 ] 1 6.667% 20.000% # ( 580, 870 ] 5 33.333% 53.333% ####### ( 870, 1300 ] 1 6.667% 60.000% # ( 1300, 1900 ] 3 20.000% 80.000% #### ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 710.3000 StdDev: 961.81 Min: 75 Median: 210.0000 Max: 3893 Percentiles: P50: 210.00 P75: 797.50 P99: 3893.00 P99.9: 3893.00 P99.99: 3893.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 9 22.500% 25.000% ##### ( 110, 170 ] 8 20.000% 45.000% #### ( 170, 250 ] 4 10.000% 55.000% ## ( 250, 380 ] 2 5.000% 60.000% # ( 380, 580 ] 3 7.500% 67.500% ## ( 580, 870 ] 4 10.000% 77.500% ## ( 1300, 1900 ] 4 10.000% 87.500% ## ( 1900, 2900 ] 2 5.000% 92.500% # ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 19.8 total, 3.6 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 298.93 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:3.372 H:M:S, 17.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 270.25 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.934 H:M:S, 25.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 2024/12/14-22:22:32 ... thread 0: (1000000,7000000) ops and (64964.1,200507.6) ops/second in (15.393114,34.911393) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/17 2.27 GB 0.0 4.6 0.0 4.6 11.2 6.6 0.0 1.7 122.7 297.5 38.52 35.05 112 0.344 4797K 5099 0.0 0.0 L1 14/14 1.61 GB 0.0 5.6 4.1 1.6 5.6 4.0 0.2 1.4 226.7 224.0 25.52 24.15 3 8.506 5873K 68K 0.0 0.0 L2 1/1 1.90 MB 0.0 0.4 0.2 0.2 0.4 0.2 2.5 2.0 245.2 245.1 1.54 1.48 2 0.771 383K 193 0.0 0.0 L3 24/9 1.66 GB 1.0 1.2 0.9 0.4 1.2 0.9 1.9 1.4 163.4 163.2 7.74 5.74 6 1.290 1258K 965 0.0 0.0 L4 158/0 9.55 GB 1.0 1.5 1.2 0.3 1.5 1.2 0.8 1.3 134.8 134.2 11.39 7.24 10 1.139 1489K 4539 0.0 0.0 L5 1064/0 87.54 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1278/41 102.64 GB 0.0 13.4 6.3 7.1 19.9 12.8 7.4 3.0 161.6 240.2 84.71 73.66 133 0.637 13M 78K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.4 6.3 7.1 19.9 12.8 7.4 3.0 161.6 240.2 84.71 73.66 133 0.637 13M 78K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 13.4 6.3 7.1 13.3 6.2 0.0 0.0 213.1 211.8 64.22 56.29 38 1.690 13M 78K 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 329.0 20.49 17.37 95 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): 35.1 total, 34.9 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 19.87 GB write, 578.85 MB/s write, 13.37 GB read, 389.42 MB/s read, 84.7 seconds Interval compaction: 19.87 GB write, 582.74 MB/s write, 13.37 GB read, 392.03 MB/s read, 84.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 31, pending-compaction-bytes-delays: 4, pending-compaction-bytes-stops: 0, total-delays: 15, total-stops: 31, interval: 46 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2510759 Average: 2.6590 StdDev: 26.41 Min: 0 Median: 1.4826 Max: 7536 Percentiles: P50: 1.48 P75: 1.87 P99: 5.90 P99.9: 108.27 P99.99: 356.87 ------------------------------------------------------ [ 0, 1 ] 474988 18.918% 18.918% #### ( 1, 2 ] 1616927 64.400% 83.318% ############# ( 2, 3 ] 253701 10.105% 93.423% ## ( 3, 4 ] 84189 3.353% 96.776% # ( 4, 6 ] 58727 2.339% 99.115% ( 6, 10 ] 14683 0.585% 99.700% ( 10, 15 ] 2709 0.108% 99.807% ( 15, 22 ] 386 0.015% 99.823% ( 22, 34 ] 28 0.001% 99.824% ( 34, 51 ] 19 0.001% 99.825% ( 51, 76 ] 35 0.001% 99.826% ( 76, 110 ] 1958 0.078% 99.904% ( 110, 170 ] 1509 0.060% 99.964% ( 170, 250 ] 378 0.015% 99.979% ( 250, 380 ] 332 0.013% 99.992% ( 380, 580 ] 317 0.013% 100.005% ( 580, 870 ] 186 0.007% 100.012% ( 870, 1300 ] 127 0.005% 100.018% ( 1300, 1900 ] 58 0.002% 100.020% ( 1900, 2900 ] 43 0.002% 100.022% ( 2900, 4400 ] 43 0.002% 100.023% ( 4400, 6600 ] 11 0.000% 100.024% ( 6600, 9900 ] 2 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 834534 Average: 3.9027 StdDev: 57.44 Min: 1 Median: 1.6026 Max: 10838 Percentiles: P50: 1.60 P75: 2.20 P99: 8.65 P99.9: 119.82 P99.99: 253.18 ------------------------------------------------------ [ 0, 1 ] 137752 16.506% 16.506% ### ( 1, 2 ] 463842 55.581% 72.087% ########### ( 2, 3 ] 119125 14.274% 86.362% ### ( 3, 4 ] 48488 5.810% 92.172% # ( 4, 6 ] 48745 5.841% 98.013% # ( 6, 10 ] 12422 1.488% 99.502% ( 10, 15 ] 1819 0.218% 99.719% ( 15, 22 ] 388 0.046% 99.766% ( 22, 34 ] 27 0.003% 99.769% ( 34, 51 ] 10 0.001% 99.770% ( 51, 76 ] 76 0.009% 99.780% ( 76, 110 ] 893 0.107% 99.887% ( 110, 170 ] 687 0.082% 99.969% ( 170, 250 ] 172 0.021% 99.989% ( 250, 380 ] 186 0.022% 100.012% ( 380, 580 ] 189 0.023% 100.034% ( 580, 870 ] 168 0.020% 100.055% ( 870, 1300 ] 110 0.013% 100.068% ( 1300, 1900 ] 61 0.007% 100.075% ( 1900, 2900 ] 64 0.008% 100.083% ( 2900, 4400 ] 64 0.008% 100.090% ( 4400, 6600 ] 27 0.003% 100.094% ( 6600, 9900 ] 6 0.001% 100.094% ( 9900, 14000 ] 1 0.000% 100.094% ** Level 2 read latency histogram (micros): Count: 95830 Average: 3.3303 StdDev: 61.14 Min: 0 Median: 1.4384 Max: 6184 Percentiles: P50: 1.44 P75: 1.83 P99: 5.62 P99.9: 14.49 P99.99: 3640.42 ------------------------------------------------------ [ 0, 1 ] 21234 22.158% 22.158% #### ( 1, 2 ] 60857 63.505% 85.663% ############# ( 2, 3 ] 7885 8.228% 93.891% ## ( 3, 4 ] 3262 3.404% 97.295% # ( 4, 6 ] 2016 2.104% 99.399% ( 6, 10 ] 429 0.448% 99.847% ( 10, 15 ] 57 0.059% 99.906% ( 15, 22 ] 10 0.010% 99.917% ( 22, 34 ] 3 0.003% 99.920% ( 51, 76 ] 1 0.001% 99.921% ( 170, 250 ] 3 0.003% 99.924% ( 250, 380 ] 5 0.005% 99.929% ( 380, 580 ] 10 0.010% 99.939% ( 580, 870 ] 17 0.018% 99.957% ( 870, 1300 ] 10 0.010% 99.968% ( 1300, 1900 ] 7 0.007% 99.975% ( 1900, 2900 ] 8 0.008% 99.983% ( 2900, 4400 ] 13 0.014% 99.997% ( 4400, 6600 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 361224 Average: 10.1900 StdDev: 116.43 Min: 0 Median: 1.8543 Max: 8004 Percentiles: P50: 1.85 P75: 2.80 P99: 13.23 P99.9: 1010.52 P99.99: 1486.57 ------------------------------------------------------ [ 0, 1 ] 12842 3.555% 3.555% # ( 1, 2 ] 196384 54.366% 57.921% ########### ( 2, 3 ] 77341 21.411% 79.332% #### ( 3, 4 ] 33075 9.156% 88.489% ## ( 4, 6 ] 29289 8.108% 96.597% ## ( 6, 10 ] 7919 2.192% 98.789% ( 10, 15 ] 1178 0.326% 99.115% ( 15, 22 ] 198 0.055% 99.170% ( 22, 34 ] 58 0.016% 99.186% ( 34, 51 ] 22 0.006% 99.192% ( 51, 76 ] 15 0.004% 99.196% ( 76, 110 ] 48 0.013% 99.210% ( 110, 170 ] 275 0.076% 99.286% ( 170, 250 ] 329 0.091% 99.377% ( 250, 380 ] 491 0.136% 99.513% ( 380, 580 ] 652 0.180% 99.693% ( 580, 870 ] 619 0.171% 99.865% ( 870, 1300 ] 391 0.108% 99.973% ( 1300, 1900 ] 199 0.055% 100.028% ( 1900, 2900 ] 115 0.032% 100.060% ( 2900, 4400 ] 131 0.036% 100.096% ( 4400, 6600 ] 37 0.010% 100.106% ( 6600, 9900 ] 3 0.001% 100.107% ** Level 4 read latency histogram (micros): Count: 18469 Average: 6.4772 StdDev: 90.50 Min: 1 Median: 2.0467 Max: 5279 Percentiles: P50: 2.05 P75: 2.95 P99: 9.37 P99.9: 1006.04 P99.99: 4145.93 ------------------------------------------------------ [ 0, 1 ] 180 0.975% 0.975% ( 1, 2 ] 8815 47.729% 48.703% ########## ( 2, 3 ] 5131 27.782% 76.485% ###### ( 3, 4 ] 1994 10.796% 87.281% ## ( 4, 6 ] 1927 10.434% 97.715% ## ( 6, 10 ] 282 1.527% 99.242% ( 10, 15 ] 62 0.336% 99.578% ( 15, 22 ] 6 0.032% 99.610% ( 22, 34 ] 2 0.011% 99.621% ( 34, 51 ] 1 0.005% 99.626% ( 51, 76 ] 1 0.005% 99.632% ( 110, 170 ] 3 0.016% 99.648% ( 170, 250 ] 20 0.108% 99.756% ( 250, 380 ] 7 0.038% 99.794% ( 380, 580 ] 4 0.022% 99.816% ( 580, 870 ] 13 0.070% 99.886% ( 870, 1300 ] 8 0.043% 99.930% ( 1300, 1900 ] 4 0.022% 99.951% ( 1900, 2900 ] 3 0.016% 99.968% ( 2900, 4400 ] 5 0.027% 99.995% ( 4400, 6600 ] 1 0.005% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 958.9250 StdDev: 1000.11 Min: 75 Median: 553.3333 Max: 5155 Percentiles: P50: 553.33 P75: 1518.18 P99: 4340.00 P99.9: 5155.00 P99.99: 5155.00 ------------------------------------------------------ ( 51, 76 ] 1 0.833% 0.833% ( 76, 110 ] 10 8.333% 9.167% ## ( 110, 170 ] 15 12.500% 21.667% ### ( 170, 250 ] 13 10.833% 32.500% ## ( 250, 380 ] 8 6.667% 39.167% # ( 380, 580 ] 15 12.500% 51.667% ### ( 580, 870 ] 14 11.667% 63.333% ## ( 870, 1300 ] 10 8.333% 71.667% ## ( 1300, 1900 ] 11 9.167% 80.833% ## ( 1900, 2900 ] 17 14.167% 95.000% ### ( 2900, 4400 ] 5 4.167% 99.167% # ( 4400, 6600 ] 1 0.833% 100.000% ** DB Stats ** Uptime(secs): 35.1 total, 15.4 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 196.01 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:15.446 H:M:S, 43.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 63.94 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:12.073 H:M:S, 78.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/12/14-22:22:36 ... thread 0: (1000000,8000000) ops and (280992.4,207953.1) ops/second in (3.558815,38.470208) 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 138.4 5.8 0.0 5.8 13.4 7.6 0.0 1.8 129.1 296.0 46.37 42.47 130 0.357 6076K 6560 0.0 0.0 L1 14/14 1.61 GB 0.0 5.6 4.1 1.6 5.6 4.0 0.2 1.4 226.7 224.0 25.52 24.15 3 8.506 5873K 68K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 2.5 2.0 245.2 245.1 1.54 1.48 2 0.771 383K 193 0.0 0.0 L3 15/0 963.37 MB 1.0 2.0 0.9 1.1 2.0 0.9 1.9 2.3 170.8 170.5 11.76 8.75 7 1.680 2013K 2891 0.0 0.0 L4 162/0 9.66 GB 1.0 1.5 1.2 0.3 1.5 1.2 1.5 1.3 134.8 134.2 11.39 7.24 10 1.139 1489K 4539 0.0 0.0 L5 1072/0 88.15 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1282/27 103.62 GB 0.0 15.3 6.3 9.0 22.8 13.8 8.8 3.0 162.5 241.8 96.58 84.09 152 0.635 15M 82K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.3 6.3 9.0 22.8 13.8 8.7 3.0 162.5 241.8 96.58 84.09 152 0.635 15M 82K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 15.3 6.3 9.0 15.2 6.2 0.0 0.0 214.6 213.4 73.13 64.09 43 1.701 15M 82K 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 330.5 23.45 20.00 109 0.215 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): 38.7 total, 38.5 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: 22.81 GB write, 603.34 MB/s write, 15.32 GB read, 405.37 MB/s read, 96.6 seconds Interval compaction: 22.81 GB write, 607.01 MB/s write, 15.32 GB read, 407.84 MB/s read, 96.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 35, pending-compaction-bytes-delays: 4, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 35, interval: 52 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2955549 Average: 2.6387 StdDev: 24.87 Min: 0 Median: 1.4987 Max: 7536 Percentiles: P50: 1.50 P75: 1.89 P99: 5.91 P99.9: 101.03 P99.99: 285.61 ------------------------------------------------------ [ 0, 1 ] 524352 17.741% 17.741% #### ( 1, 2 ] 1911741 64.683% 82.424% ############# ( 2, 3 ] 315276 10.667% 93.092% ## ( 3, 4 ] 104398 3.532% 96.624% # ( 4, 6 ] 73513 2.487% 99.111% ( 6, 10 ] 18239 0.617% 99.728% ( 10, 15 ] 3096 0.105% 99.833% ( 15, 22 ] 421 0.014% 99.847% ( 22, 34 ] 30 0.001% 99.848% ( 34, 51 ] 24 0.001% 99.849% ( 51, 76 ] 37 0.001% 99.850% ( 76, 110 ] 1992 0.067% 99.918% ( 110, 170 ] 1596 0.054% 99.972% ( 170, 250 ] 436 0.015% 99.987% ( 250, 380 ] 374 0.013% 99.999% ( 380, 580 ] 361 0.012% 100.011% ( 580, 870 ] 209 0.007% 100.018% ( 870, 1300 ] 144 0.005% 100.023% ( 1300, 1900 ] 63 0.002% 100.025% ( 1900, 2900 ] 46 0.002% 100.027% ( 2900, 4400 ] 43 0.001% 100.028% ( 4400, 6600 ] 11 0.000% 100.029% ( 6600, 9900 ] 2 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 907083 Average: 3.8329 StdDev: 55.28 Min: 1 Median: 1.6063 Max: 10838 Percentiles: P50: 1.61 P75: 2.19 P99: 8.65 P99.9: 125.01 P99.99: 283.15 ------------------------------------------------------ [ 0, 1 ] 143317 15.800% 15.800% ### ( 1, 2 ] 511652 56.406% 72.206% ########### ( 2, 3 ] 130933 14.435% 86.641% ### ( 3, 4 ] 51757 5.706% 92.346% # ( 4, 6 ] 51313 5.657% 98.003% # ( 6, 10 ] 13669 1.507% 99.510% ( 10, 15 ] 1905 0.210% 99.720% ( 15, 22 ] 393 0.043% 99.764% ( 22, 34 ] 27 0.003% 99.767% ( 34, 51 ] 10 0.001% 99.768% ( 51, 76 ] 77 0.008% 99.776% ( 76, 110 ] 937 0.103% 99.880% ( 110, 170 ] 743 0.082% 99.961% ( 170, 250 ] 206 0.023% 99.984% ( 250, 380 ] 209 0.023% 100.007% ( 380, 580 ] 210 0.023% 100.030% ( 580, 870 ] 177 0.020% 100.050% ( 870, 1300 ] 112 0.012% 100.062% ( 1300, 1900 ] 62 0.007% 100.069% ( 1900, 2900 ] 64 0.007% 100.076% ( 2900, 4400 ] 64 0.007% 100.083% ( 4400, 6600 ] 27 0.003% 100.086% ( 6600, 9900 ] 6 0.001% 100.087% ( 9900, 14000 ] 1 0.000% 100.087% ** Level 2 read latency histogram (micros): Count: 111910 Average: 3.5190 StdDev: 57.80 Min: 0 Median: 1.4864 Max: 6184 Percentiles: P50: 1.49 P75: 1.89 P99: 5.97 P99.9: 312.68 P99.99: 3454.88 ------------------------------------------------------ [ 0, 1 ] 21875 19.547% 19.547% #### ( 1, 2 ] 70064 62.607% 82.154% ############# ( 2, 3 ] 11322 10.117% 92.271% ## ( 3, 4 ] 4488 4.010% 96.282% # ( 4, 6 ] 3081 2.753% 99.035% # ( 6, 10 ] 784 0.701% 99.736% ( 10, 15 ] 112 0.100% 99.836% ( 15, 22 ] 17 0.015% 99.851% ( 22, 34 ] 3 0.003% 99.853% ( 51, 76 ] 1 0.001% 99.854% ( 110, 170 ] 21 0.019% 99.873% ( 170, 250 ] 19 0.017% 99.890% ( 250, 380 ] 23 0.021% 99.911% ( 380, 580 ] 28 0.025% 99.936% ( 580, 870 ] 27 0.024% 99.960% ( 870, 1300 ] 13 0.012% 99.971% ( 1300, 1900 ] 8 0.007% 99.979% ( 1900, 2900 ] 8 0.007% 99.986% ( 2900, 4400 ] 13 0.012% 99.997% ( 4400, 6600 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 366926 Average: 10.1010 StdDev: 115.59 Min: 0 Median: 1.8532 Max: 8004 Percentiles: P50: 1.85 P75: 2.80 P99: 13.13 P99.9: 1005.00 P99.99: 1484.85 ------------------------------------------------------ [ 0, 1 ] 13040 3.554% 3.554% # ( 1, 2 ] 199752 54.439% 57.993% ########### ( 2, 3 ] 78487 21.390% 79.384% #### ( 3, 4 ] 33512 9.133% 88.517% ## ( 4, 6 ] 29680 8.089% 96.606% ## ( 6, 10 ] 8043 2.192% 98.798% ( 10, 15 ] 1188 0.324% 99.121% ( 15, 22 ] 199 0.054% 99.176% ( 22, 34 ] 58 0.016% 99.191% ( 34, 51 ] 22 0.006% 99.197% ( 51, 76 ] 15 0.004% 99.201% ( 76, 110 ] 51 0.014% 99.215% ( 110, 170 ] 276 0.075% 99.291% ( 170, 250 ] 339 0.092% 99.383% ( 250, 380 ] 494 0.135% 99.518% ( 380, 580 ] 653 0.178% 99.696% ( 580, 870 ] 627 0.171% 99.866% ( 870, 1300 ] 392 0.107% 99.973% ( 1300, 1900 ] 199 0.054% 100.028% ( 1900, 2900 ] 115 0.031% 100.059% ( 2900, 4400 ] 131 0.036% 100.095% ( 4400, 6600 ] 37 0.010% 100.105% ( 6600, 9900 ] 3 0.001% 100.105% ** Level 4 read latency histogram (micros): Count: 18469 Average: 6.4772 StdDev: 90.50 Min: 1 Median: 2.0467 Max: 5279 Percentiles: P50: 2.05 P75: 2.95 P99: 9.37 P99.9: 1006.04 P99.99: 4145.93 ------------------------------------------------------ [ 0, 1 ] 180 0.975% 0.975% ( 1, 2 ] 8815 47.729% 48.703% ########## ( 2, 3 ] 5131 27.782% 76.485% ###### ( 3, 4 ] 1994 10.796% 87.281% ## ( 4, 6 ] 1927 10.434% 97.715% ## ( 6, 10 ] 282 1.527% 99.242% ( 10, 15 ] 62 0.336% 99.578% ( 15, 22 ] 6 0.032% 99.610% ( 22, 34 ] 2 0.011% 99.621% ( 34, 51 ] 1 0.005% 99.626% ( 51, 76 ] 1 0.005% 99.632% ( 110, 170 ] 3 0.016% 99.648% ( 170, 250 ] 20 0.108% 99.756% ( 250, 380 ] 7 0.038% 99.794% ( 380, 580 ] 4 0.022% 99.816% ( 580, 870 ] 13 0.070% 99.886% ( 870, 1300 ] 8 0.043% 99.930% ( 1300, 1900 ] 4 0.022% 99.951% ( 1900, 2900 ] 3 0.016% 99.968% ( 2900, 4400 ] 5 0.027% 99.995% ( 4400, 6600 ] 1 0.005% 100.000% ** Level 5 read latency histogram (micros): Count: 160 Average: 897.1187 StdDev: 954.32 Min: 75 Median: 495.7895 Max: 5155 Percentiles: P50: 495.79 P75: 1350.00 P99: 4220.00 P99.9: 5155.00 P99.99: 5155.00 ------------------------------------------------------ ( 51, 76 ] 1 0.625% 0.625% ( 76, 110 ] 11 6.875% 7.500% # ( 110, 170 ] 26 16.250% 23.750% ### ( 170, 250 ] 18 11.250% 35.000% ## ( 250, 380 ] 13 8.125% 43.125% ## ( 380, 580 ] 19 11.875% 55.000% ## ( 580, 870 ] 16 10.000% 65.000% ## ( 870, 1300 ] 15 9.375% 74.375% ## ( 1300, 1900 ] 12 7.500% 81.875% ## ( 1900, 2900 ] 23 14.375% 96.250% ### ( 2900, 4400 ] 5 3.125% 99.375% # ( 4400, 6600 ] 1 0.625% 100.000% ** DB Stats ** Uptime(secs): 38.7 total, 3.6 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 203.42 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:16.270 H:M:S, 42.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 276.55 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.824 H:M:S, 23.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/14-22:22:46 ... thread 0: (1000000,9000000) ops and (98484.1,185093.3) ops/second in (10.153928,48.624136) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/8 2.64 GB 0.0 8.1 0.0 8.1 16.7 8.6 0.0 1.9 141.7 291.7 58.69 54.02 153 0.384 8442K 12K 0.0 0.0 L1 25/25 2.54 GB 0.0 8.9 5.7 3.2 8.8 5.6 0.2 1.5 216.4 213.8 42.20 38.77 4 10.550 8122K 68K 0.0 0.0 L2 6/5 351.49 MB 0.6 0.4 0.2 0.2 0.4 0.2 3.2 2.0 245.2 245.1 1.54 1.48 2 0.771 383K 193 0.0 0.0 L3 21/5 1.28 GB 0.7 2.0 0.9 1.1 2.0 0.9 2.2 2.3 170.8 170.5 11.76 8.75 7 1.680 2013K 2891 0.0 0.0 L4 162/0 9.66 GB 1.0 1.5 1.2 0.3 1.5 1.2 1.5 1.3 134.8 134.2 11.39 7.24 10 1.139 1489K 4539 0.0 0.0 L5 1072/0 88.15 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1294/43 104.62 GB 0.0 20.9 7.9 12.9 29.4 16.4 9.8 3.4 170.2 239.3 125.58 110.26 176 0.714 20M 88K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.9 7.9 12.9 29.4 16.4 9.8 3.4 170.2 239.3 125.58 110.26 176 0.714 20M 88K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 20.9 7.9 12.9 20.7 7.8 0.0 0.0 215.7 214.4 99.06 87.52 50 1.981 20M 88K 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 332.6 26.52 22.73 126 0.210 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 48.9 total, 48.6 interval Flush(GB): cumulative 8.613, interval 8.613 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 29.35 GB write, 615.15 MB/s write, 20.87 GB read, 437.37 MB/s read, 125.6 seconds Interval compaction: 29.35 GB write, 618.12 MB/s write, 20.87 GB read, 439.48 MB/s read, 125.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 23, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 23, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 35, pending-compaction-bytes-delays: 11, pending-compaction-bytes-stops: 0, total-delays: 34, total-stops: 35, interval: 69 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3666942 Average: 2.8033 StdDev: 24.99 Min: 0 Median: 1.4986 Max: 7536 Percentiles: P50: 1.50 P75: 1.88 P99: 6.13 P99.9: 143.26 P99.99: 391.88 ------------------------------------------------------ [ 0, 1 ] 642286 17.516% 17.516% #### ( 1, 2 ] 2389107 65.153% 82.668% ############# ( 2, 3 ] 384520 10.486% 93.154% ## ( 3, 4 ] 127555 3.479% 96.633% # ( 4, 6 ] 86015 2.346% 98.978% ( 6, 10 ] 23732 0.647% 99.626% ( 10, 15 ] 3642 0.099% 99.725% ( 15, 22 ] 523 0.014% 99.739% ( 22, 34 ] 36 0.001% 99.740% ( 34, 51 ] 27 0.001% 99.741% ( 51, 76 ] 52 0.001% 99.742% ( 76, 110 ] 3813 0.104% 99.846% ( 110, 170 ] 3556 0.097% 99.943% ( 170, 250 ] 951 0.026% 99.969% ( 250, 380 ] 728 0.020% 99.989% ( 380, 580 ] 611 0.017% 100.006% ( 580, 870 ] 362 0.010% 100.016% ( 870, 1300 ] 195 0.005% 100.021% ( 1300, 1900 ] 72 0.002% 100.023% ( 1900, 2900 ] 51 0.001% 100.024% ( 2900, 4400 ] 52 0.001% 100.026% ( 4400, 6600 ] 11 0.000% 100.026% ( 6600, 9900 ] 2 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 1336683 Average: 3.7287 StdDev: 47.62 Min: 1 Median: 1.6014 Max: 10838 Percentiles: P50: 1.60 P75: 2.11 P99: 8.77 P99.9: 152.68 P99.99: 346.92 ------------------------------------------------------ [ 0, 1 ] 195657 14.638% 14.638% ### ( 1, 2 ] 786033 58.805% 73.442% ############ ( 2, 3 ] 186926 13.984% 87.427% ### ( 3, 4 ] 71993 5.386% 92.813% # ( 4, 6 ] 68151 5.099% 97.911% # ( 6, 10 ] 21029 1.573% 99.484% ( 10, 15 ] 2447 0.183% 99.667% ( 15, 22 ] 499 0.037% 99.705% ( 22, 34 ] 33 0.002% 99.707% ( 34, 51 ] 12 0.001% 99.708% ( 51, 76 ] 97 0.007% 99.715% ( 76, 110 ] 1426 0.107% 99.822% ( 110, 170 ] 1478 0.111% 99.933% ( 170, 250 ] 458 0.034% 99.967% ( 250, 380 ] 427 0.032% 99.999% ( 380, 580 ] 371 0.028% 100.026% ( 580, 870 ] 298 0.022% 100.049% ( 870, 1300 ] 167 0.012% 100.061% ( 1300, 1900 ] 68 0.005% 100.066% ( 1900, 2900 ] 67 0.005% 100.071% ( 2900, 4400 ] 67 0.005% 100.076% ( 4400, 6600 ] 27 0.002% 100.078% ( 6600, 9900 ] 6 0.000% 100.079% ( 9900, 14000 ] 1 0.000% 100.079% ** Level 2 read latency histogram (micros): Count: 111910 Average: 3.5190 StdDev: 57.80 Min: 0 Median: 1.4864 Max: 6184 Percentiles: P50: 1.49 P75: 1.89 P99: 5.97 P99.9: 312.68 P99.99: 3454.88 ------------------------------------------------------ [ 0, 1 ] 21875 19.547% 19.547% #### ( 1, 2 ] 70064 62.607% 82.154% ############# ( 2, 3 ] 11322 10.117% 92.271% ## ( 3, 4 ] 4488 4.010% 96.282% # ( 4, 6 ] 3081 2.753% 99.035% # ( 6, 10 ] 784 0.701% 99.736% ( 10, 15 ] 112 0.100% 99.836% ( 15, 22 ] 17 0.015% 99.851% ( 22, 34 ] 3 0.003% 99.853% ( 51, 76 ] 1 0.001% 99.854% ( 110, 170 ] 21 0.019% 99.873% ( 170, 250 ] 19 0.017% 99.890% ( 250, 380 ] 23 0.021% 99.911% ( 380, 580 ] 28 0.025% 99.936% ( 580, 870 ] 27 0.024% 99.960% ( 870, 1300 ] 13 0.012% 99.971% ( 1300, 1900 ] 8 0.007% 99.979% ( 1900, 2900 ] 8 0.007% 99.986% ( 2900, 4400 ] 13 0.012% 99.997% ( 4400, 6600 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 366926 Average: 10.1010 StdDev: 115.59 Min: 0 Median: 1.8532 Max: 8004 Percentiles: P50: 1.85 P75: 2.80 P99: 13.13 P99.9: 1005.00 P99.99: 1484.85 ------------------------------------------------------ [ 0, 1 ] 13040 3.554% 3.554% # ( 1, 2 ] 199752 54.439% 57.993% ########### ( 2, 3 ] 78487 21.390% 79.384% #### ( 3, 4 ] 33512 9.133% 88.517% ## ( 4, 6 ] 29680 8.089% 96.606% ## ( 6, 10 ] 8043 2.192% 98.798% ( 10, 15 ] 1188 0.324% 99.121% ( 15, 22 ] 199 0.054% 99.176% ( 22, 34 ] 58 0.016% 99.191% ( 34, 51 ] 22 0.006% 99.197% ( 51, 76 ] 15 0.004% 99.201% ( 76, 110 ] 51 0.014% 99.215% ( 110, 170 ] 276 0.075% 99.291% ( 170, 250 ] 339 0.092% 99.383% ( 250, 380 ] 494 0.135% 99.518% ( 380, 580 ] 653 0.178% 99.696% ( 580, 870 ] 627 0.171% 99.866% ( 870, 1300 ] 392 0.107% 99.973% ( 1300, 1900 ] 199 0.054% 100.028% ( 1900, 2900 ] 115 0.031% 100.059% ( 2900, 4400 ] 131 0.036% 100.095% ( 4400, 6600 ] 37 0.010% 100.105% ( 6600, 9900 ] 3 0.001% 100.105% ** Level 4 read latency histogram (micros): Count: 18469 Average: 6.4772 StdDev: 90.50 Min: 1 Median: 2.0467 Max: 5279 Percentiles: P50: 2.05 P75: 2.95 P99: 9.37 P99.9: 1006.04 P99.99: 4145.93 ------------------------------------------------------ [ 0, 1 ] 180 0.975% 0.975% ( 1, 2 ] 8815 47.729% 48.703% ########## ( 2, 3 ] 5131 27.782% 76.485% ###### ( 3, 4 ] 1994 10.796% 87.281% ## ( 4, 6 ] 1927 10.434% 97.715% ## ( 6, 10 ] 282 1.527% 99.242% ( 10, 15 ] 62 0.336% 99.578% ( 15, 22 ] 6 0.032% 99.610% ( 22, 34 ] 2 0.011% 99.621% ( 34, 51 ] 1 0.005% 99.626% ( 51, 76 ] 1 0.005% 99.632% ( 110, 170 ] 3 0.016% 99.648% ( 170, 250 ] 20 0.108% 99.756% ( 250, 380 ] 7 0.038% 99.794% ( 380, 580 ] 4 0.022% 99.816% ( 580, 870 ] 13 0.070% 99.886% ( 870, 1300 ] 8 0.043% 99.930% ( 1300, 1900 ] 4 0.022% 99.951% ( 1900, 2900 ] 3 0.016% 99.968% ( 2900, 4400 ] 5 0.027% 99.995% ( 4400, 6600 ] 1 0.005% 100.000% ** Level 5 read latency histogram (micros): Count: 160 Average: 897.1187 StdDev: 954.32 Min: 75 Median: 495.7895 Max: 5155 Percentiles: P50: 495.79 P75: 1350.00 P99: 4220.00 P99.9: 5155.00 P99.99: 5155.00 ------------------------------------------------------ ( 51, 76 ] 1 0.625% 0.625% ( 76, 110 ] 11 6.875% 7.500% # ( 110, 170 ] 26 16.250% 23.750% ### ( 170, 250 ] 18 11.250% 35.000% ## ( 250, 380 ] 13 8.125% 43.125% ## ( 380, 580 ] 19 11.875% 55.000% ## ( 580, 870 ] 16 10.000% 65.000% ## ( 870, 1300 ] 15 9.375% 74.375% ## ( 1300, 1900 ] 12 7.500% 81.875% ## ( 1900, 2900 ] 23 14.375% 96.250% ### ( 2900, 4400 ] 5 3.125% 99.375% # ( 4400, 6600 ] 1 0.625% 100.000% ** DB Stats ** Uptime(secs): 48.9 total, 10.2 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 181.28 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:23.400 H:M:S, 47.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 96.92 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:7.130 H:M:S, 70.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 7 num-running-flushes: 0 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.627 micros/op 150901 ops/sec 60.092 seconds 9067999 operations; 146.2 MB/s Microseconds per write: Count: 9067999 Average: 6.6268 StdDev: 372.72 Min: 0 Median: 1.7667 Max: 816237 Percentiles: P50: 1.77 P75: 2.84 P99: 11.10 P99.9: 1198.54 P99.99: 2691.54 ------------------------------------------------------ [ 0, 1 ] 1064588 11.740% 11.740% ## ( 1, 2 ] 4525356 49.905% 61.645% ########## ( 2, 3 ] 1443181 15.915% 77.560% ### ( 3, 4 ] 1256652 13.858% 91.418% ### ( 4, 6 ] 521736 5.754% 97.172% # ( 6, 10 ] 153793 1.696% 98.868% ( 10, 15 ] 54837 0.605% 99.472% ( 15, 22 ] 11408 0.126% 99.598% ( 22, 34 ] 2179 0.024% 99.622% ( 34, 51 ] 262 0.003% 99.625% ( 51, 76 ] 38 0.000% 99.625% ( 76, 110 ] 6206 0.068% 99.694% ( 110, 170 ] 2491 0.027% 99.721% ( 170, 250 ] 250 0.003% 99.724% ( 250, 380 ] 242 0.003% 99.727% ( 380, 580 ] 29 0.000% 99.727% ( 580, 870 ] 13 0.000% 99.727% ( 870, 1300 ] 20509 0.226% 99.953% ( 1300, 1900 ] 46 0.001% 99.954% ( 1900, 2900 ] 4139 0.046% 100.000% ( 2900, 4400 ] 12 0.000% 100.000% ( 4400, 6600 ] 9 0.000% 100.000% ( 6600, 9900 ] 2 0.000% 100.000% ( 9900, 14000 ] 3 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 170000, 250000 ] 11 0.000% 100.000% ( 250000, 380000 ] 1 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 : 193104 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 : 9067999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 9358174968 rocksdb.bytes.read COUNT : 0 rocksdb.number.db.seek COUNT : 0 rocksdb.number.db.next COUNT : 0 rocksdb.number.db.prev COUNT : 0 rocksdb.number.db.seek.found COUNT : 0 rocksdb.number.db.next.found COUNT : 0 rocksdb.number.db.prev.found COUNT : 0 rocksdb.db.iter.bytes.read COUNT : 0 rocksdb.no.file.opens COUNT : 464 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 34216233 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 : 27007618344 rocksdb.compact.write.bytes COUNT : 26820675259 rocksdb.flush.write.bytes COUNT : 9314212336 rocksdb.compact.read.marked.bytes COUNT : 0 rocksdb.compact.read.periodic.bytes COUNT : 0 rocksdb.compact.read.ttl.bytes COUNT : 0 rocksdb.compact.write.marked.bytes COUNT : 0 rocksdb.compact.write.periodic.bytes COUNT : 0 rocksdb.compact.write.ttl.bytes COUNT : 0 rocksdb.number.direct.load.table.properties COUNT : 47 rocksdb.number.superversion_acquires COUNT : 0 rocksdb.number.superversion_releases COUNT : 0 rocksdb.number.superversion_cleanups COUNT : 0 rocksdb.number.block.compressed COUNT : 0 rocksdb.number.block.decompressed COUNT : 0 rocksdb.number.block.not_compressed COUNT : 0 rocksdb.merge.operation.time.nanos COUNT : 0 rocksdb.filter.operation.time.nanos COUNT : 0 rocksdb.row.cache.hit COUNT : 0 rocksdb.row.cache.miss COUNT : 0 rocksdb.read.amp.estimate.useful.bytes COUNT : 0 rocksdb.read.amp.total.read.bytes COUNT : 0 rocksdb.number.rate_limiter.drains COUNT : 0 rocksdb.number.iter.skip COUNT : 0 rocksdb.blobdb.num.put COUNT : 0 rocksdb.blobdb.num.write COUNT : 0 rocksdb.blobdb.num.get COUNT : 0 rocksdb.blobdb.num.multiget COUNT : 0 rocksdb.blobdb.num.seek COUNT : 0 rocksdb.blobdb.num.next COUNT : 0 rocksdb.blobdb.num.prev COUNT : 0 rocksdb.blobdb.num.keys.written COUNT : 0 rocksdb.blobdb.num.keys.read COUNT : 0 rocksdb.blobdb.bytes.written COUNT : 0 rocksdb.blobdb.bytes.read COUNT : 0 rocksdb.blobdb.write.inlined COUNT : 0 rocksdb.blobdb.write.inlined.ttl COUNT : 0 rocksdb.blobdb.write.blob COUNT : 0 rocksdb.blobdb.write.blob.ttl COUNT : 0 rocksdb.blobdb.blob.file.bytes.written COUNT : 0 rocksdb.blobdb.blob.file.bytes.read COUNT : 0 rocksdb.blobdb.blob.file.synced COUNT : 0 rocksdb.blobdb.blob.index.expired.count COUNT : 0 rocksdb.blobdb.blob.index.expired.size COUNT : 0 rocksdb.blobdb.blob.index.evicted.count COUNT : 0 rocksdb.blobdb.blob.index.evicted.size COUNT : 0 rocksdb.blobdb.gc.num.files COUNT : 0 rocksdb.blobdb.gc.num.new.files COUNT : 0 rocksdb.blobdb.gc.failures COUNT : 0 rocksdb.blobdb.gc.num.keys.relocated COUNT : 0 rocksdb.blobdb.gc.bytes.relocated COUNT : 0 rocksdb.blobdb.fifo.num.files.evicted COUNT : 0 rocksdb.blobdb.fifo.num.keys.evicted COUNT : 0 rocksdb.blobdb.fifo.bytes.evicted COUNT : 0 rocksdb.txn.overhead.mutex.prepare COUNT : 0 rocksdb.txn.overhead.mutex.old.commit.map COUNT : 0 rocksdb.txn.overhead.duplicate.key COUNT : 0 rocksdb.txn.overhead.mutex.snapshot COUNT : 0 rocksdb.txn.get.tryagain COUNT : 0 rocksdb.number.multiget.keys.found COUNT : 0 rocksdb.num.iterator.created COUNT : 0 rocksdb.num.iterator.deleted COUNT : 0 rocksdb.block.cache.compression.dict.miss COUNT : 0 rocksdb.block.cache.compression.dict.hit COUNT : 0 rocksdb.block.cache.compression.dict.add COUNT : 0 rocksdb.block.cache.compression.dict.bytes.insert COUNT : 0 rocksdb.block.cache.add.redundant COUNT : 0 rocksdb.block.cache.index.add.redundant COUNT : 0 rocksdb.block.cache.filter.add.redundant COUNT : 0 rocksdb.block.cache.data.add.redundant COUNT : 0 rocksdb.block.cache.compression.dict.add.redundant COUNT : 0 rocksdb.files.marked.trash COUNT : 0 rocksdb.files.deleted.immediately COUNT : 249 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 : 9238976512 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3465216 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 : 27092359757 rocksdb.non.last.level.read.count COUNT : 6545554 rocksdb.block.checksum.compute.count COUNT : 6544673 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.419390 P95 : 4.098977 P99 : 9.264054 P100 : 816234.000000 COUNT : 9067999 SUM : 55575093 rocksdb.compaction.times.micros P50 : 1077812.500000 P95 : 6170000.000000 P99 : 16760104.000000 P100 : 16760104.000000 COUNT : 63 SUM : 108316242 rocksdb.compaction.times.cpu_micros P50 : 964193.548387 P95 : 4195000.000000 P99 : 15694300.000000 P100 : 15694300.000000 COUNT : 63 SUM : 95148510 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 : 700.492958 P95 : 1243.861111 P99 : 12893.000000 P100 : 69973.000000 COUNT : 127 SUM : 171237 rocksdb.compaction.outfile.sync.micros P50 : 855.610687 P95 : 44687.500000 P99 : 149666.666667 P100 : 166832.000000 COUNT : 305 SUM : 2623127 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 : 97.250000 P95 : 452.500000 P99 : 2680.000000 P100 : 3700.000000 COUNT : 222 SUM : 39360 rocksdb.table.open.io.micros P50 : 1469.411765 P95 : 6205.517241 P99 : 9749.142857 P100 : 11083.000000 COUNT : 464 SUM : 895364 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.598640 P95 : 7.330770 P99 : 10.217025 P100 : 10844.000000 COUNT : 6543435 SUM : 36219443 rocksdb.read.block.get.micros P50 : 463.333333 P95 : 2921.428571 P99 : 4247.142857 P100 : 5537.000000 COUNT : 928 SUM : 722582 rocksdb.write.raw.block.micros P50 : 0.513395 P95 : 0.975451 P99 : 2.930431 P100 : 11519.000000 COUNT : 8751708 SUM : 16471543 rocksdb.numfiles.in.singlecompaction P50 : 3.326087 P95 : 6.500000 P99 : 29.400000 P100 : 33.000000 COUNT : 115 SUM : 475 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.566928 P95 : 1167.141670 P99 : 2399.077482 P100 : 816040.000000 COUNT : 210581 SUM : 34240421 rocksdb.sst.read.micros P50 : 1.538408 P95 : 4.174877 P99 : 7.992375 P100 : 10838.000000 COUNT : 6545755 SUM : 22739400 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 : 9067999 SUM : 9358174968 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 : 212424.242424 P95 : 348892.857143 P99 : 544350.000000 P100 : 966226.000000 COUNT : 127 SUM : 26700648 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 : 284 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