[2024-11-19 07:36:10.845615] Starting SPDK v25.01-pre git sha1 d47eb51c9 / DPDK 24.03.0 initialization... [2024-11-19 07:36:10.845731] [ 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_pid1697232 ] Set seed to 1731998170843116 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-19 07:36:10.961608] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-19 07:36:11.068696] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-19 07:36:11.068747] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1697232' to capture a snapshot of events at runtime. [2024-11-19 07:36:11.068758] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-19 07:36:11.068768] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-19 07:36:11.068776] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1697232 for offline analysis/debug. [2024-11-19 07:36:11.070195] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Tue Nov 19 07:36:19 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/19-07:36:22 ... thread 0: (1000000,1000000) ops and (335224.7,335224.7) ops/second in (2.983074,2.983074) 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/7 567.01 MB 12.6 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 352.1 2.51 2.25 12 0.209 0 0 0.0 0.0 L1 3/3 188.89 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 259.0 258.9 0.73 0.70 1 0.730 191K 83 0.0 0.0 L2 2/1 125.96 MB 0.0 0.1 0.1 0.1 0.1 0.1 0.1 2.0 242.3 242.2 0.52 0.50 1 0.520 127K 34 0.0 0.0 L3 11/0 867.33 MB 0.9 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.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.69 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 1180/11 97.00 GB 0.0 0.3 0.2 0.1 1.2 1.1 0.3 1.4 83.9 318.8 3.75 3.45 14 0.268 319K 117 0.0 0.0 Int 0/0 0.00 KB 0.0 0.3 0.2 0.1 1.2 1.1 0.2 1.4 83.9 318.8 3.75 3.45 14 0.268 319K 117 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.3 0.2 0.1 0.3 0.2 0.0 0.0 252.1 252.0 1.25 1.21 2 0.625 319K 117 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 352.1 2.51 2.25 12 0.209 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.2 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.17 GB write, 373.12 MB/s write, 0.31 GB read, 98.20 MB/s read, 3.8 seconds Interval compaction: 1.17 GB write, 401.02 MB/s write, 0.31 GB read, 105.54 MB/s read, 3.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 133458 Average: 2.0166 StdDev: 17.39 Min: 1 Median: 1.3347 Max: 3430 Percentiles: P50: 1.33 P75: 1.74 P99: 5.19 P99.9: 9.62 P99.99: 132.75 ------------------------------------------------------ [ 0, 1 ] 39333 29.472% 29.472% ###### ( 1, 2 ] 81862 61.339% 90.811% ############ ( 2, 3 ] 7260 5.440% 96.251% # ( 3, 4 ] 2556 1.915% 98.166% ( 4, 6 ] 1877 1.406% 99.573% ( 6, 10 ] 484 0.363% 99.936% ( 10, 15 ] 56 0.042% 99.978% ( 15, 22 ] 6 0.004% 99.982% ( 22, 34 ] 5 0.004% 99.986% ( 34, 51 ] 3 0.002% 99.988% ( 51, 76 ] 1 0.001% 99.989% ( 110, 170 ] 7 0.005% 99.994% ( 170, 250 ] 2 0.001% 99.996% ( 250, 380 ] 4 0.003% 99.999% ( 380, 580 ] 4 0.003% 100.001% ( 580, 870 ] 1 0.001% 100.002% ( 870, 1300 ] 2 0.001% 100.004% ( 1900, 2900 ] 2 0.001% 100.005% ( 2900, 4400 ] 2 0.001% 100.007% ** Level 1 read latency histogram (micros): Count: 32219 Average: 2.0466 StdDev: 6.36 Min: 1 Median: 1.4254 Max: 977 Percentiles: P50: 1.43 P75: 1.82 P99: 5.21 P99.9: 9.13 P99.99: 232.25 ------------------------------------------------------ [ 0, 1 ] 7360 22.844% 22.844% ##### ( 1, 2 ] 20570 63.844% 86.688% ############# ( 2, 3 ] 2763 8.576% 95.264% ## ( 3, 4 ] 851 2.641% 97.905% # ( 4, 6 ] 584 1.813% 99.718% ( 6, 10 ] 75 0.233% 99.950% ( 10, 15 ] 10 0.031% 99.981% ( 15, 22 ] 1 0.003% 99.984% ( 51, 76 ] 1 0.003% 99.988% ( 170, 250 ] 1 0.003% 99.991% ( 250, 380 ] 1 0.003% 99.994% ( 380, 580 ] 1 0.003% 99.997% ( 870, 1300 ] 1 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 29001 Average: 3.2096 StdDev: 59.94 Min: 0 Median: 1.5944 Max: 5801 Percentiles: P50: 1.59 P75: 1.97 P99: 6.92 P99.9: 14.34 P99.99: 4473.26 ------------------------------------------------------ [ 0, 1 ] 3053 10.527% 10.527% ## ( 1, 2 ] 19260 66.412% 76.939% ############# ( 2, 3 ] 3911 13.486% 90.424% ### ( 3, 4 ] 1311 4.521% 94.945% # ( 4, 6 ] 1112 3.834% 98.779% # ( 6, 10 ] 279 0.962% 99.741% ( 10, 15 ] 53 0.183% 99.924% ( 15, 22 ] 6 0.021% 99.945% ( 22, 34 ] 2 0.007% 99.952% ( 34, 51 ] 1 0.003% 99.955% ( 51, 76 ] 1 0.003% 99.959% ( 250, 380 ] 1 0.003% 99.962% ( 380, 580 ] 2 0.007% 99.969% ( 580, 870 ] 3 0.010% 99.979% ( 870, 1300 ] 1 0.003% 99.983% ( 1300, 1900 ] 1 0.003% 99.986% ( 2900, 4400 ] 1 0.003% 99.990% ( 4400, 6600 ] 3 0.010% 100.000% ** Level 3 read latency histogram (micros): Count: 45 Average: 2692.9778 StdDev: 2006.89 Min: 228 Median: 1870.0000 Max: 7085 Percentiles: P50: 1870.00 P75: 4785.00 P99: 7085.00 P99.9: 7085.00 P99.99: 7085.00 ------------------------------------------------------ ( 170, 250 ] 1 2.222% 2.222% ( 250, 380 ] 2 4.444% 6.667% # ( 380, 580 ] 4 8.889% 15.556% ## ( 580, 870 ] 4 8.889% 24.444% ## ( 870, 1300 ] 2 4.444% 28.889% # ( 1300, 1900 ] 10 22.222% 51.111% #### ( 1900, 2900 ] 5 11.111% 62.222% ## ( 2900, 4400 ] 4 8.889% 71.111% ## ( 4400, 6600 ] 10 22.222% 93.333% #### ( 6600, 9900 ] 3 6.667% 100.000% # ** Level 4 read latency histogram (micros): Count: 25 Average: 3208.0800 StdDev: 2048.53 Min: 224 Median: 2685.7143 Max: 8697 Percentiles: P50: 2685.71 P75: 5264.29 P99: 8697.00 P99.9: 8697.00 P99.99: 8697.00 ------------------------------------------------------ ( 170, 250 ] 1 4.000% 4.000% # ( 580, 870 ] 1 4.000% 8.000% # ( 870, 1300 ] 4 16.000% 24.000% ### ( 1300, 1900 ] 1 4.000% 28.000% # ( 1900, 2900 ] 7 28.000% 56.000% ###### ( 2900, 4400 ] 2 8.000% 64.000% ## ( 4400, 6600 ] 7 28.000% 92.000% ###### ( 6600, 9900 ] 2 8.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.2 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 306.80 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.383 H:M:S, 11.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 329.67 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.383 H:M:S, 12.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/19-07:36:25 ... thread 0: (1000000,2000000) ops and (319418.9,327131.0) ops/second in (3.130685,6.113759) 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 1.35 GB 37.8 0.6 0.0 0.6 2.4 1.8 0.0 1.3 74.5 322.6 7.61 6.97 28 0.272 575K 617 0.0 0.0 L1 1/1 3.27 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.1 1.5 244.6 244.3 2.32 2.25 2 1.159 575K 572 0.0 0.0 L2 2/2 117.69 MB 0.0 0.1 0.1 0.1 0.1 0.1 0.4 2.0 242.3 242.2 0.52 0.50 1 0.520 127K 34 0.0 0.0 L3 75/32 1.22 GB 0.3 0.5 0.4 0.1 0.5 0.4 0.1 1.3 178.3 178.2 2.77 2.30 2 1.387 502K 343 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.69 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 1247/46 97.98 GB 0.0 1.7 0.8 0.9 3.6 2.6 0.7 1.9 132.7 275.4 13.23 12.02 33 0.401 1781K 1566 0.0 0.0 Int 0/0 0.00 KB 0.0 1.7 0.8 0.9 3.6 2.6 0.5 1.9 132.7 275.4 13.23 12.02 33 0.401 1781K 1566 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.7 0.8 0.9 1.7 0.8 0.0 0.0 225.2 225.0 7.79 7.18 7 1.113 1781K 1566 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 347.7 5.44 4.84 26 0.209 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.3 total, 6.1 interval Flush(GB): cumulative 1.846, interval 1.846 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.56 GB write, 574.71 MB/s write, 1.71 GB read, 276.79 MB/s read, 13.2 seconds Interval compaction: 3.56 GB write, 595.68 MB/s write, 1.71 GB read, 286.89 MB/s read, 13.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: 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: 413321 Average: 2.4087 StdDev: 12.97 Min: 1 Median: 1.6009 Max: 3430 Percentiles: P50: 1.60 P75: 2.05 P99: 5.90 P99.9: 9.88 P99.99: 13.35 ------------------------------------------------------ [ 0, 1 ] 55900 13.525% 13.525% ### ( 1, 2 ] 250895 60.702% 74.227% ############ ( 2, 3 ] 66168 16.009% 90.236% ### ( 3, 4 ] 19073 4.615% 94.850% # ( 4, 6 ] 18048 4.367% 99.217% # ( 6, 10 ] 2908 0.704% 99.920% ( 10, 15 ] 430 0.104% 100.024% ( 15, 22 ] 47 0.011% 100.036% ( 22, 34 ] 12 0.003% 100.039% ( 34, 51 ] 3 0.001% 100.039% ( 51, 76 ] 1 0.000% 100.040% ( 110, 170 ] 8 0.002% 100.042% ( 170, 250 ] 12 0.003% 100.045% ( 250, 380 ] 7 0.002% 100.046% ( 380, 580 ] 8 0.002% 100.048% ( 580, 870 ] 6 0.001% 100.050% ( 870, 1300 ] 6 0.001% 100.051% ( 1300, 1900 ] 4 0.001% 100.052% ( 1900, 2900 ] 2 0.000% 100.053% ( 2900, 4400 ] 3 0.001% 100.053% ** Level 1 read latency histogram (micros): Count: 127405 Average: 2.4701 StdDev: 9.03 Min: 1 Median: 1.6720 Max: 2154 Percentiles: P50: 1.67 P75: 2.26 P99: 5.89 P99.9: 11.99 P99.99: 27.04 ------------------------------------------------------ [ 0, 1 ] 11676 9.164% 9.164% ## ( 1, 2 ] 77420 60.767% 69.931% ############ ( 2, 3 ] 24950 19.583% 89.515% #### ( 3, 4 ] 6308 4.951% 94.466% # ( 4, 6 ] 6101 4.789% 99.254% # ( 6, 10 ] 759 0.596% 99.850% ( 10, 15 ] 160 0.126% 99.976% ( 15, 22 ] 17 0.013% 99.989% ( 22, 34 ] 3 0.002% 99.991% ( 51, 76 ] 1 0.001% 99.992% ( 170, 250 ] 1 0.001% 99.993% ( 250, 380 ] 4 0.003% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 870, 1300 ] 2 0.002% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31910 Average: 3.1835 StdDev: 57.15 Min: 0 Median: 1.6281 Max: 5801 Percentiles: P50: 1.63 P75: 2.07 P99: 7.15 P99.9: 14.39 P99.99: 4113.50 ------------------------------------------------------ [ 0, 1 ] 3073 9.630% 9.630% ## ( 1, 2 ] 20509 64.271% 73.902% ############# ( 2, 3 ] 5067 15.879% 89.781% ### ( 3, 4 ] 1523 4.773% 94.553% # ( 4, 6 ] 1323 4.146% 98.699% # ( 6, 10 ] 333 1.044% 99.743% ( 10, 15 ] 57 0.179% 99.922% ( 15, 22 ] 7 0.022% 99.944% ( 22, 34 ] 4 0.013% 99.956% ( 34, 51 ] 1 0.003% 99.959% ( 51, 76 ] 1 0.003% 99.962% ( 250, 380 ] 1 0.003% 99.966% ( 380, 580 ] 2 0.006% 99.972% ( 580, 870 ] 3 0.009% 99.981% ( 870, 1300 ] 1 0.003% 99.984% ( 1300, 1900 ] 1 0.003% 99.987% ( 2900, 4400 ] 1 0.003% 99.991% ( 4400, 6600 ] 3 0.009% 100.000% ** Level 3 read latency histogram (micros): Count: 185523 Average: 4.1205 StdDev: 57.62 Min: 1 Median: 1.7360 Max: 7085 Percentiles: P50: 1.74 P75: 2.47 P99: 9.18 P99.9: 241.14 P99.99: 724.54 ------------------------------------------------------ [ 0, 1 ] 11675 6.293% 6.293% # ( 1, 2 ] 110178 59.388% 65.681% ############ ( 2, 3 ] 37136 20.017% 85.698% #### ( 3, 4 ] 11743 6.330% 92.027% # ( 4, 6 ] 10172 5.483% 97.510% # ( 6, 10 ] 3478 1.875% 99.385% ( 10, 15 ] 463 0.250% 99.635% ( 15, 22 ] 61 0.033% 99.667% ( 22, 34 ] 36 0.019% 99.687% ( 34, 51 ] 11 0.006% 99.693% ( 51, 76 ] 1 0.001% 99.693% ( 76, 110 ] 76 0.041% 99.734% ( 110, 170 ] 216 0.116% 99.851% ( 170, 250 ] 104 0.056% 99.907% ( 250, 380 ] 76 0.041% 99.948% ( 380, 580 ] 63 0.034% 99.982% ( 580, 870 ] 33 0.018% 99.999% ( 870, 1300 ] 14 0.008% 100.007% ( 1300, 1900 ] 13 0.007% 100.014% ( 1900, 2900 ] 9 0.005% 100.019% ( 2900, 4400 ] 6 0.003% 100.022% ( 4400, 6600 ] 10 0.005% 100.027% ( 6600, 9900 ] 3 0.002% 100.029% ** Level 4 read latency histogram (micros): Count: 25 Average: 3208.0800 StdDev: 2048.53 Min: 224 Median: 2685.7143 Max: 8697 Percentiles: P50: 2685.71 P75: 5264.29 P99: 8697.00 P99.9: 8697.00 P99.99: 8697.00 ------------------------------------------------------ ( 170, 250 ] 1 4.000% 4.000% # ( 580, 870 ] 1 4.000% 8.000% # ( 870, 1300 ] 4 16.000% 24.000% ### ( 1300, 1900 ] 1 4.000% 28.000% # ( 1900, 2900 ] 7 28.000% 56.000% ###### ( 2900, 4400 ] 2 8.000% 64.000% ## ( 4400, 6600 ] 7 28.000% 92.000% ###### ( 6600, 9900 ] 2 8.000% 100.000% ## ** DB Stats ** Uptime(secs): 6.3 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 310.54 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.848 H:M:S, 13.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 314.38 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.465 H:M:S, 14.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/11/19-07:36:28 ... thread 0: (1000000,3000000) ops and (344818.2,332821.6) ops/second in (2.900079,9.013838) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/4 1.54 GB 132.1 1.4 0.0 1.4 4.1 2.7 0.0 1.5 106.1 308.9 13.66 12.61 44 0.310 1471K 1661 0.0 0.0 L1 3/0 222.11 MB 22.2 1.2 1.0 0.2 1.2 1.0 0.1 1.2 230.1 229.6 5.49 5.32 3 1.829 1282K 2551 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 0.9 2.0 242.3 242.2 0.52 0.50 1 0.520 127K 34 0.0 0.0 L3 20/0 889.79 MB 0.9 2.0 0.8 1.2 2.0 0.8 0.2 2.4 207.8 207.5 10.10 8.98 7 1.443 1996K 2136 0.0 0.0 L4 164/0 9.54 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.8 1.0 174.3 174.3 0.67 0.57 1 0.674 111K 0 0.0 0.0 L5 1052/0 86.68 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 1249/4 98.84 GB 0.0 4.9 2.1 2.9 7.6 4.8 3.0 2.8 166.0 256.8 30.44 27.98 56 0.544 4989K 6382 0.0 0.0 Int 0/0 0.00 KB 0.0 4.9 2.1 2.9 7.6 4.8 2.9 2.8 166.0 256.8 30.44 27.98 56 0.544 4989K 6382 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.9 2.1 2.9 4.9 2.1 0.0 0.0 225.0 224.7 22.46 20.93 17 1.321 4989K 6382 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 347.4 7.98 7.05 39 0.205 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.2 total, 9.0 interval Flush(GB): cumulative 2.707, interval 2.707 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.64 GB write, 846.30 MB/s write, 4.94 GB read, 547.07 MB/s read, 30.4 seconds Interval compaction: 7.64 GB write, 867.25 MB/s write, 4.94 GB read, 560.60 MB/s read, 30.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: 10, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 10, interval: 10 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 704087 Average: 2.4694 StdDev: 11.94 Min: 1 Median: 1.6433 Max: 3430 Percentiles: P50: 1.64 P75: 2.18 P99: 5.91 P99.9: 9.87 P99.99: 13.09 ------------------------------------------------------ [ 0, 1 ] 75189 10.679% 10.679% ## ( 1, 2 ] 430343 61.121% 71.800% ############ ( 2, 3 ] 122879 17.452% 89.252% ### ( 3, 4 ] 36204 5.142% 94.394% # ( 4, 6 ] 34013 4.831% 99.225% # ( 6, 10 ] 4918 0.698% 99.923% ( 10, 15 ] 761 0.108% 100.031% ( 15, 22 ] 87 0.012% 100.044% ( 22, 34 ] 22 0.003% 100.047% ( 34, 51 ] 4 0.001% 100.047% ( 51, 76 ] 3 0.000% 100.048% ( 110, 170 ] 11 0.002% 100.049% ( 170, 250 ] 21 0.003% 100.052% ( 250, 380 ] 9 0.001% 100.054% ( 380, 580 ] 13 0.002% 100.055% ( 580, 870 ] 9 0.001% 100.057% ( 870, 1300 ] 13 0.002% 100.059% ( 1300, 1900 ] 7 0.001% 100.060% ( 1900, 2900 ] 2 0.000% 100.060% ( 2900, 4400 ] 4 0.001% 100.060% ** Level 1 read latency histogram (micros): Count: 236434 Average: 2.6273 StdDev: 10.87 Min: 1 Median: 1.7346 Max: 2154 Percentiles: P50: 1.73 P75: 2.41 P99: 5.96 P99.9: 13.15 P99.99: 163.10 ------------------------------------------------------ [ 0, 1 ] 14826 6.271% 6.271% # ( 1, 2 ] 140740 59.526% 65.797% ############ ( 2, 3 ] 52836 22.347% 88.144% #### ( 3, 4 ] 12860 5.439% 93.583% # ( 4, 6 ] 13047 5.518% 99.101% # ( 6, 10 ] 1630 0.689% 99.791% ( 10, 15 ] 410 0.173% 99.964% ( 15, 22 ] 32 0.014% 99.978% ( 22, 34 ] 4 0.002% 99.979% ( 34, 51 ] 1 0.000% 99.980% ( 51, 76 ] 1 0.000% 99.980% ( 76, 110 ] 3 0.001% 99.981% ( 110, 170 ] 23 0.010% 99.991% ( 170, 250 ] 6 0.003% 99.994% ( 250, 380 ] 15 0.006% 100.000% ( 380, 580 ] 6 0.003% 100.003% ( 580, 870 ] 3 0.001% 100.004% ( 870, 1300 ] 3 0.001% 100.005% ( 1300, 1900 ] 4 0.002% 100.007% ( 1900, 2900 ] 2 0.001% 100.008% ** Level 2 read latency histogram (micros): Count: 60287 Average: 3.7176 StdDev: 46.05 Min: 0 Median: 1.7145 Max: 5801 Percentiles: P50: 1.71 P75: 2.40 P99: 8.73 P99.9: 316.03 P99.99: 1494.26 ------------------------------------------------------ [ 0, 1 ] 3938 6.532% 6.532% # ( 1, 2 ] 36679 60.841% 67.373% ############ ( 2, 3 ] 11528 19.122% 86.495% #### ( 3, 4 ] 3637 6.033% 92.527% # ( 4, 6 ] 3237 5.369% 97.897% # ( 6, 10 ] 975 1.617% 99.514% ( 10, 15 ] 118 0.196% 99.710% ( 15, 22 ] 17 0.028% 99.738% ( 22, 34 ] 5 0.008% 99.746% ( 34, 51 ] 1 0.002% 99.748% ( 51, 76 ] 1 0.002% 99.750% ( 76, 110 ] 3 0.005% 99.755% ( 110, 170 ] 41 0.068% 99.823% ( 170, 250 ] 33 0.055% 99.877% ( 250, 380 ] 27 0.045% 99.922% ( 380, 580 ] 20 0.033% 99.955% ( 580, 870 ] 16 0.027% 99.982% ( 870, 1300 ] 4 0.007% 99.988% ( 1300, 1900 ] 3 0.005% 99.993% ( 2900, 4400 ] 1 0.002% 99.995% ( 4400, 6600 ] 3 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 315247 Average: 3.6342 StdDev: 45.01 Min: 0 Median: 1.7547 Max: 7085 Percentiles: P50: 1.75 P75: 2.49 P99: 8.72 P99.9: 164.85 P99.99: 461.19 ------------------------------------------------------ [ 0, 1 ] 16534 5.245% 5.245% # ( 1, 2 ] 186958 59.305% 64.550% ############ ( 2, 3 ] 66800 21.190% 85.740% #### ( 3, 4 ] 20851 6.614% 92.354% # ( 4, 6 ] 17447 5.534% 97.888% # ( 6, 10 ] 5147 1.633% 99.521% ( 10, 15 ] 713 0.226% 99.747% ( 15, 22 ] 88 0.028% 99.775% ( 22, 34 ] 46 0.015% 99.790% ( 34, 51 ] 14 0.004% 99.794% ( 51, 76 ] 16 0.005% 99.799% ( 76, 110 ] 102 0.032% 99.832% ( 110, 170 ] 236 0.075% 99.906% ( 170, 250 ] 135 0.043% 99.949% ( 250, 380 ] 96 0.030% 99.980% ( 380, 580 ] 80 0.025% 100.005% ( 580, 870 ] 46 0.015% 100.020% ( 870, 1300 ] 18 0.006% 100.025% ( 1300, 1900 ] 15 0.005% 100.030% ( 1900, 2900 ] 9 0.003% 100.033% ( 2900, 4400 ] 6 0.002% 100.035% ( 4400, 6600 ] 10 0.003% 100.038% ( 6600, 9900 ] 3 0.001% 100.039% ** Level 4 read latency histogram (micros): Count: 100 Average: 806.1900 StdDev: 1724.00 Min: 1 Median: 4.7273 Max: 8697 Percentiles: P50: 4.73 P75: 34.00 P99: 8250.00 P99.9: 8697.00 P99.99: 8697.00 ------------------------------------------------------ [ 0, 1 ] 20 20.000% 20.000% #### ( 1, 2 ] 19 19.000% 39.000% #### ( 2, 3 ] 5 5.000% 44.000% # ( 3, 4 ] 2 2.000% 46.000% ( 4, 6 ] 11 11.000% 57.000% ## ( 6, 10 ] 3 3.000% 60.000% # ( 10, 15 ] 8 8.000% 68.000% ## ( 15, 22 ] 4 4.000% 72.000% # ( 22, 34 ] 3 3.000% 75.000% # ( 170, 250 ] 1 1.000% 76.000% ( 580, 870 ] 1 1.000% 77.000% ( 870, 1300 ] 4 4.000% 81.000% # ( 1300, 1900 ] 1 1.000% 82.000% ( 1900, 2900 ] 7 7.000% 89.000% # ( 2900, 4400 ] 2 2.000% 91.000% ( 4400, 6600 ] 7 7.000% 98.000% # ( 6600, 9900 ] 2 2.000% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 871.1167 StdDev: 1145.62 Min: 83 Median: 223.3333 Max: 5084 Percentiles: P50: 223.33 P75: 1156.67 P99: 5084.00 P99.9: 5084.00 P99.99: 5084.00 ------------------------------------------------------ ( 76, 110 ] 9 15.000% 15.000% ### ( 110, 170 ] 19 31.667% 46.667% ###### ( 170, 250 ] 3 5.000% 51.667% # ( 250, 380 ] 1 1.667% 53.333% ( 380, 580 ] 5 8.333% 61.667% ## ( 580, 870 ] 4 6.667% 68.333% # ( 870, 1300 ] 6 10.000% 78.333% ## ( 1300, 1900 ] 4 6.667% 85.000% # ( 1900, 2900 ] 5 8.333% 93.333% ## ( 2900, 4400 ] 3 5.000% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 9.2 total, 2.9 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 319.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:1.074 H:M:S, 11.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 339.36 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.226 H:M:S, 7.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/19-07:36:31 ... thread 0: (1000000,4000000) ops and (308823.0,326478.9) ops/second in (3.238101,12.251939) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/14 2.58 GB 12.6 2.2 0.0 2.2 6.0 3.8 0.0 1.6 114.9 309.3 19.75 18.32 61 0.324 2302K 2546 0.0 0.0 L1 3/3 222.11 MB 0.0 1.2 1.0 0.2 1.2 1.0 0.1 1.2 230.1 229.6 5.49 5.32 3 1.829 1282K 2551 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 0.9 2.0 242.3 242.2 0.52 0.50 1 0.520 127K 34 0.0 0.0 L3 20/0 889.79 MB 0.9 2.0 0.8 1.2 2.0 0.8 0.2 2.4 207.8 207.5 10.10 8.98 7 1.443 1996K 2136 0.0 0.0 L4 164/0 9.54 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.8 1.0 174.3 174.3 0.67 0.57 1 0.674 111K 0 0.0 0.0 L5 1052/0 86.68 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 1254/17 99.88 GB 0.0 5.7 2.1 3.7 9.5 5.8 3.0 2.5 160.8 265.7 36.53 33.69 73 0.500 5821K 7267 0.0 0.0 Int 0/0 0.00 KB 0.0 5.7 2.1 3.7 9.5 5.8 2.9 2.5 160.8 265.7 36.53 33.69 73 0.500 5821K 7267 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.7 2.1 3.7 5.7 2.1 0.0 0.0 229.8 229.5 25.55 23.96 20 1.278 5821K 7267 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 350.1 10.98 9.73 53 0.207 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.5 total, 12.3 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: 9.48 GB write, 778.06 MB/s write, 5.74 GB read, 470.72 MB/s read, 36.5 seconds Interval compaction: 9.48 GB write, 792.22 MB/s write, 5.74 GB read, 479.30 MB/s read, 36.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: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 14, interval: 14 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 974549 Average: 2.3703 StdDev: 13.09 Min: 1 Median: 1.5752 Max: 3905 Percentiles: P50: 1.58 P75: 1.98 P99: 5.83 P99.9: 9.86 P99.99: 13.81 ------------------------------------------------------ [ 0, 1 ] 137995 14.160% 14.160% ### ( 1, 2 ] 607253 62.311% 76.471% ############ ( 2, 3 ] 144021 14.778% 91.249% ### ( 3, 4 ] 41727 4.282% 95.531% # ( 4, 6 ] 37042 3.801% 99.332% # ( 6, 10 ] 5741 0.589% 99.921% ( 10, 15 ] 882 0.091% 100.011% ( 15, 22 ] 116 0.012% 100.023% ( 22, 34 ] 22 0.002% 100.026% ( 34, 51 ] 5 0.001% 100.026% ( 51, 76 ] 5 0.001% 100.027% ( 76, 110 ] 13 0.001% 100.028% ( 110, 170 ] 52 0.005% 100.033% ( 170, 250 ] 44 0.005% 100.038% ( 250, 380 ] 16 0.002% 100.040% ( 380, 580 ] 23 0.002% 100.042% ( 580, 870 ] 15 0.002% 100.043% ( 870, 1300 ] 18 0.002% 100.045% ( 1300, 1900 ] 9 0.001% 100.046% ( 1900, 2900 ] 3 0.000% 100.046% ( 2900, 4400 ] 7 0.001% 100.047% ** Level 1 read latency histogram (micros): Count: 236435 Average: 2.6273 StdDev: 10.87 Min: 1 Median: 1.7346 Max: 2154 Percentiles: P50: 1.73 P75: 2.41 P99: 5.96 P99.9: 13.15 P99.99: 163.10 ------------------------------------------------------ [ 0, 1 ] 14826 6.271% 6.271% # ( 1, 2 ] 140740 59.526% 65.797% ############ ( 2, 3 ] 52836 22.347% 88.143% #### ( 3, 4 ] 12861 5.440% 93.583% # ( 4, 6 ] 13047 5.518% 99.101% # ( 6, 10 ] 1630 0.689% 99.791% ( 10, 15 ] 410 0.173% 99.964% ( 15, 22 ] 32 0.014% 99.978% ( 22, 34 ] 4 0.002% 99.979% ( 34, 51 ] 1 0.000% 99.980% ( 51, 76 ] 1 0.000% 99.980% ( 76, 110 ] 3 0.001% 99.981% ( 110, 170 ] 23 0.010% 99.991% ( 170, 250 ] 6 0.003% 99.994% ( 250, 380 ] 15 0.006% 100.000% ( 380, 580 ] 6 0.003% 100.003% ( 580, 870 ] 3 0.001% 100.004% ( 870, 1300 ] 3 0.001% 100.005% ( 1300, 1900 ] 4 0.002% 100.007% ( 1900, 2900 ] 2 0.001% 100.008% ** Level 2 read latency histogram (micros): Count: 60287 Average: 3.7176 StdDev: 46.05 Min: 0 Median: 1.7145 Max: 5801 Percentiles: P50: 1.71 P75: 2.40 P99: 8.73 P99.9: 316.03 P99.99: 1494.26 ------------------------------------------------------ [ 0, 1 ] 3938 6.532% 6.532% # ( 1, 2 ] 36679 60.841% 67.373% ############ ( 2, 3 ] 11528 19.122% 86.495% #### ( 3, 4 ] 3637 6.033% 92.527% # ( 4, 6 ] 3237 5.369% 97.897% # ( 6, 10 ] 975 1.617% 99.514% ( 10, 15 ] 118 0.196% 99.710% ( 15, 22 ] 17 0.028% 99.738% ( 22, 34 ] 5 0.008% 99.746% ( 34, 51 ] 1 0.002% 99.748% ( 51, 76 ] 1 0.002% 99.750% ( 76, 110 ] 3 0.005% 99.755% ( 110, 170 ] 41 0.068% 99.823% ( 170, 250 ] 33 0.055% 99.877% ( 250, 380 ] 27 0.045% 99.922% ( 380, 580 ] 20 0.033% 99.955% ( 580, 870 ] 16 0.027% 99.982% ( 870, 1300 ] 4 0.007% 99.988% ( 1300, 1900 ] 3 0.005% 99.993% ( 2900, 4400 ] 1 0.002% 99.995% ( 4400, 6600 ] 3 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 315247 Average: 3.6342 StdDev: 45.01 Min: 0 Median: 1.7547 Max: 7085 Percentiles: P50: 1.75 P75: 2.49 P99: 8.72 P99.9: 164.85 P99.99: 461.19 ------------------------------------------------------ [ 0, 1 ] 16534 5.245% 5.245% # ( 1, 2 ] 186958 59.305% 64.550% ############ ( 2, 3 ] 66800 21.190% 85.740% #### ( 3, 4 ] 20851 6.614% 92.354% # ( 4, 6 ] 17447 5.534% 97.888% # ( 6, 10 ] 5147 1.633% 99.521% ( 10, 15 ] 713 0.226% 99.747% ( 15, 22 ] 88 0.028% 99.775% ( 22, 34 ] 46 0.015% 99.790% ( 34, 51 ] 14 0.004% 99.794% ( 51, 76 ] 16 0.005% 99.799% ( 76, 110 ] 102 0.032% 99.832% ( 110, 170 ] 236 0.075% 99.906% ( 170, 250 ] 135 0.043% 99.949% ( 250, 380 ] 96 0.030% 99.980% ( 380, 580 ] 80 0.025% 100.005% ( 580, 870 ] 46 0.015% 100.020% ( 870, 1300 ] 18 0.006% 100.025% ( 1300, 1900 ] 15 0.005% 100.030% ( 1900, 2900 ] 9 0.003% 100.033% ( 2900, 4400 ] 6 0.002% 100.035% ( 4400, 6600 ] 10 0.003% 100.038% ( 6600, 9900 ] 3 0.001% 100.039% ** Level 4 read latency histogram (micros): Count: 100 Average: 806.1900 StdDev: 1724.00 Min: 1 Median: 4.7273 Max: 8697 Percentiles: P50: 4.73 P75: 34.00 P99: 8250.00 P99.9: 8697.00 P99.99: 8697.00 ------------------------------------------------------ [ 0, 1 ] 20 20.000% 20.000% #### ( 1, 2 ] 19 19.000% 39.000% #### ( 2, 3 ] 5 5.000% 44.000% # ( 3, 4 ] 2 2.000% 46.000% ( 4, 6 ] 11 11.000% 57.000% ## ( 6, 10 ] 3 3.000% 60.000% # ( 10, 15 ] 8 8.000% 68.000% ## ( 15, 22 ] 4 4.000% 72.000% # ( 22, 34 ] 3 3.000% 75.000% # ( 170, 250 ] 1 1.000% 76.000% ( 580, 870 ] 1 1.000% 77.000% ( 870, 1300 ] 4 4.000% 81.000% # ( 1300, 1900 ] 1 1.000% 82.000% ( 1900, 2900 ] 7 7.000% 89.000% # ( 2900, 4400 ] 2 2.000% 91.000% ( 4400, 6600 ] 7 7.000% 98.000% # ( 6600, 9900 ] 2 2.000% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 871.1167 StdDev: 1145.62 Min: 83 Median: 223.3333 Max: 5084 Percentiles: P50: 223.33 P75: 1156.67 P99: 5084.00 P99.9: 5084.00 P99.99: 5084.00 ------------------------------------------------------ ( 76, 110 ] 9 15.000% 15.000% ### ( 110, 170 ] 19 31.667% 46.667% ###### ( 170, 250 ] 3 5.000% 51.667% # ( 250, 380 ] 1 1.667% 53.333% ( 380, 580 ] 5 8.333% 61.667% ## ( 580, 870 ] 4 6.667% 68.333% # ( 870, 1300 ] 6 10.000% 78.333% ## ( 1300, 1900 ] 4 6.667% 85.000% # ( 1900, 2900 ] 5 8.333% 93.333% ## ( 2900, 4400 ] 3 5.000% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 12.5 total, 3.2 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 315.53 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.711 H:M:S, 13.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 303.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:0.637 H:M:S, 19.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-07:36:35 ... thread 0: (1000000,5000000) ops and (278059.9,315491.5) ops/second in (3.596347,15.848286) 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/10 3.50 GB 132.2 3.3 0.0 3.3 7.9 4.7 0.0 1.7 125.6 305.5 26.59 24.76 79 0.337 3390K 3634 0.0 0.0 L1 3/3 222.11 MB 0.0 1.2 1.0 0.2 1.2 1.0 0.1 1.2 230.1 229.6 5.49 5.32 3 1.829 1282K 2551 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 0.9 2.0 242.3 242.2 0.52 0.50 1 0.520 127K 34 0.0 0.0 L3 20/0 889.79 MB 0.9 2.0 0.8 1.2 2.0 0.8 0.2 2.4 207.8 207.5 10.10 8.98 7 1.443 1996K 2136 0.0 0.0 L4 164/0 9.54 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.8 1.0 174.3 174.3 0.67 0.57 1 0.674 111K 0 0.0 0.0 L5 1052/0 86.68 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 1256/13 100.80 GB 0.0 6.8 2.1 4.7 11.4 6.7 3.0 2.4 160.1 270.3 43.37 40.12 91 0.477 6908K 8355 0.0 0.0 Int 0/0 0.00 KB 0.0 6.8 2.1 4.7 11.4 6.7 2.9 2.4 160.1 270.3 43.37 40.12 91 0.477 6908K 8355 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.8 2.1 4.7 6.8 2.1 0.0 0.0 234.3 233.9 29.64 27.95 24 1.235 6908K 8355 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 348.8 13.73 12.17 67 0.205 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 16.1 total, 15.8 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.45 GB write, 729.32 MB/s write, 6.78 GB read, 432.04 MB/s read, 43.4 seconds Interval compaction: 11.45 GB write, 739.59 MB/s write, 6.78 GB read, 438.12 MB/s read, 43.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 3, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 3, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 16, interval: 19 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1418987 Average: 2.3437 StdDev: 12.52 Min: 1 Median: 1.5731 Max: 4271 Percentiles: P50: 1.57 P75: 1.96 P99: 5.79 P99.9: 9.83 P99.99: 13.66 ------------------------------------------------------ [ 0, 1 ] 188635 13.294% 13.294% ### ( 1, 2 ] 908901 64.053% 77.346% ############# ( 2, 3 ] 209621 14.773% 92.119% ### ( 3, 4 ] 55409 3.905% 96.024% # ( 4, 6 ] 47057 3.316% 99.340% # ( 6, 10 ] 8296 0.585% 99.925% ( 10, 15 ] 1266 0.089% 100.014% ( 15, 22 ] 154 0.011% 100.025% ( 22, 34 ] 25 0.002% 100.027% ( 34, 51 ] 9 0.001% 100.027% ( 51, 76 ] 8 0.001% 100.028% ( 76, 110 ] 20 0.001% 100.029% ( 110, 170 ] 62 0.004% 100.034% ( 170, 250 ] 56 0.004% 100.037% ( 250, 380 ] 18 0.001% 100.039% ( 380, 580 ] 29 0.002% 100.041% ( 580, 870 ] 21 0.001% 100.042% ( 870, 1300 ] 27 0.002% 100.044% ( 1300, 1900 ] 9 0.001% 100.045% ( 1900, 2900 ] 5 0.000% 100.045% ( 2900, 4400 ] 9 0.001% 100.046% ** Level 1 read latency histogram (micros): Count: 236435 Average: 2.6273 StdDev: 10.87 Min: 1 Median: 1.7346 Max: 2154 Percentiles: P50: 1.73 P75: 2.41 P99: 5.96 P99.9: 13.15 P99.99: 163.10 ------------------------------------------------------ [ 0, 1 ] 14826 6.271% 6.271% # ( 1, 2 ] 140740 59.526% 65.797% ############ ( 2, 3 ] 52836 22.347% 88.143% #### ( 3, 4 ] 12861 5.440% 93.583% # ( 4, 6 ] 13047 5.518% 99.101% # ( 6, 10 ] 1630 0.689% 99.791% ( 10, 15 ] 410 0.173% 99.964% ( 15, 22 ] 32 0.014% 99.978% ( 22, 34 ] 4 0.002% 99.979% ( 34, 51 ] 1 0.000% 99.980% ( 51, 76 ] 1 0.000% 99.980% ( 76, 110 ] 3 0.001% 99.981% ( 110, 170 ] 23 0.010% 99.991% ( 170, 250 ] 6 0.003% 99.994% ( 250, 380 ] 15 0.006% 100.000% ( 380, 580 ] 6 0.003% 100.003% ( 580, 870 ] 3 0.001% 100.004% ( 870, 1300 ] 3 0.001% 100.005% ( 1300, 1900 ] 4 0.002% 100.007% ( 1900, 2900 ] 2 0.001% 100.008% ** Level 2 read latency histogram (micros): Count: 60287 Average: 3.7176 StdDev: 46.05 Min: 0 Median: 1.7145 Max: 5801 Percentiles: P50: 1.71 P75: 2.40 P99: 8.73 P99.9: 316.03 P99.99: 1494.26 ------------------------------------------------------ [ 0, 1 ] 3938 6.532% 6.532% # ( 1, 2 ] 36679 60.841% 67.373% ############ ( 2, 3 ] 11528 19.122% 86.495% #### ( 3, 4 ] 3637 6.033% 92.527% # ( 4, 6 ] 3237 5.369% 97.897% # ( 6, 10 ] 975 1.617% 99.514% ( 10, 15 ] 118 0.196% 99.710% ( 15, 22 ] 17 0.028% 99.738% ( 22, 34 ] 5 0.008% 99.746% ( 34, 51 ] 1 0.002% 99.748% ( 51, 76 ] 1 0.002% 99.750% ( 76, 110 ] 3 0.005% 99.755% ( 110, 170 ] 41 0.068% 99.823% ( 170, 250 ] 33 0.055% 99.877% ( 250, 380 ] 27 0.045% 99.922% ( 380, 580 ] 20 0.033% 99.955% ( 580, 870 ] 16 0.027% 99.982% ( 870, 1300 ] 4 0.007% 99.988% ( 1300, 1900 ] 3 0.005% 99.993% ( 2900, 4400 ] 1 0.002% 99.995% ( 4400, 6600 ] 3 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 315247 Average: 3.6342 StdDev: 45.01 Min: 0 Median: 1.7547 Max: 7085 Percentiles: P50: 1.75 P75: 2.49 P99: 8.72 P99.9: 164.85 P99.99: 461.19 ------------------------------------------------------ [ 0, 1 ] 16534 5.245% 5.245% # ( 1, 2 ] 186958 59.305% 64.550% ############ ( 2, 3 ] 66800 21.190% 85.740% #### ( 3, 4 ] 20851 6.614% 92.354% # ( 4, 6 ] 17447 5.534% 97.888% # ( 6, 10 ] 5147 1.633% 99.521% ( 10, 15 ] 713 0.226% 99.747% ( 15, 22 ] 88 0.028% 99.775% ( 22, 34 ] 46 0.015% 99.790% ( 34, 51 ] 14 0.004% 99.794% ( 51, 76 ] 16 0.005% 99.799% ( 76, 110 ] 102 0.032% 99.832% ( 110, 170 ] 236 0.075% 99.906% ( 170, 250 ] 135 0.043% 99.949% ( 250, 380 ] 96 0.030% 99.980% ( 380, 580 ] 80 0.025% 100.005% ( 580, 870 ] 46 0.015% 100.020% ( 870, 1300 ] 18 0.006% 100.025% ( 1300, 1900 ] 15 0.005% 100.030% ( 1900, 2900 ] 9 0.003% 100.033% ( 2900, 4400 ] 6 0.002% 100.035% ( 4400, 6600 ] 10 0.003% 100.038% ( 6600, 9900 ] 3 0.001% 100.039% ** Level 4 read latency histogram (micros): Count: 100 Average: 806.1900 StdDev: 1724.00 Min: 1 Median: 4.7273 Max: 8697 Percentiles: P50: 4.73 P75: 34.00 P99: 8250.00 P99.9: 8697.00 P99.99: 8697.00 ------------------------------------------------------ [ 0, 1 ] 20 20.000% 20.000% #### ( 1, 2 ] 19 19.000% 39.000% #### ( 2, 3 ] 5 5.000% 44.000% # ( 3, 4 ] 2 2.000% 46.000% ( 4, 6 ] 11 11.000% 57.000% ## ( 6, 10 ] 3 3.000% 60.000% # ( 10, 15 ] 8 8.000% 68.000% ## ( 15, 22 ] 4 4.000% 72.000% # ( 22, 34 ] 3 3.000% 75.000% # ( 170, 250 ] 1 1.000% 76.000% ( 580, 870 ] 1 1.000% 77.000% ( 870, 1300 ] 4 4.000% 81.000% # ( 1300, 1900 ] 1 1.000% 82.000% ( 1900, 2900 ] 7 7.000% 89.000% # ( 2900, 4400 ] 2 2.000% 91.000% ( 4400, 6600 ] 7 7.000% 98.000% # ( 6600, 9900 ] 2 2.000% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 871.1167 StdDev: 1145.62 Min: 83 Median: 223.3333 Max: 5084 Percentiles: P50: 223.33 P75: 1156.67 P99: 5084.00 P99.9: 5084.00 P99.99: 5084.00 ------------------------------------------------------ ( 76, 110 ] 9 15.000% 15.000% ### ( 110, 170 ] 19 31.667% 46.667% ###### ( 170, 250 ] 3 5.000% 51.667% # ( 250, 380 ] 1 1.667% 53.333% ( 380, 580 ] 5 8.333% 61.667% ## ( 580, 870 ] 4 6.667% 68.333% # ( 870, 1300 ] 6 10.000% 78.333% ## ( 1300, 1900 ] 4 6.667% 85.000% # ( 1900, 2900 ] 5 8.333% 93.333% ## ( 2900, 4400 ] 3 5.000% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 16.1 total, 3.6 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 306.16 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.605 H:M:S, 16.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 273.67 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.894 H:M:S, 24.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/19-07:36:42 ... thread 0: (1000000,6000000) ops and (137890.8,259735.7) ops/second in (7.252117,23.100403) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/9 2.27 GB 12.6 4.8 0.0 4.8 10.5 5.7 0.0 1.8 139.0 302.8 35.34 33.11 99 0.357 4988K 6722 0.0 0.0 L1 17/17 1.40 GB 0.0 3.7 3.3 0.4 3.6 3.2 0.1 1.1 225.5 223.6 16.63 16.04 4 4.158 3808K 30K 0.0 0.0 L2 3/1 377.69 MB 2.5 0.1 0.1 0.1 0.1 0.1 1.9 2.0 242.3 242.2 0.52 0.50 1 0.520 127K 34 0.0 0.0 L3 17/1 1018.54 MB 0.9 2.0 0.8 1.2 2.0 0.8 0.8 2.4 207.8 207.5 10.10 8.98 7 1.443 1996K 2136 0.0 0.0 L4 168/0 9.73 GB 1.0 0.1 0.1 0.0 0.1 0.1 1.3 1.0 174.3 174.3 0.67 0.57 1 0.674 111K 0 0.0 0.0 L5 1056/0 86.98 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1272/28 101.76 GB 0.0 10.7 4.3 6.5 16.4 9.9 5.5 2.9 173.9 264.9 63.27 59.19 112 0.565 11M 39K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.7 4.3 6.5 16.4 9.9 5.3 2.9 173.9 264.9 63.27 59.19 112 0.565 11M 39K 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.3 6.5 10.7 4.2 0.0 0.0 235.7 234.8 46.69 44.48 29 1.610 11M 39K 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.6 16.58 14.71 83 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): 23.3 total, 23.1 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.37 GB write, 718.57 MB/s write, 10.75 GB read, 471.85 MB/s read, 63.3 seconds Interval compaction: 16.37 GB write, 725.51 MB/s write, 10.75 GB read, 476.41 MB/s read, 63.3 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: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 16, interval: 27 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2142415 Average: 2.3660 StdDev: 12.43 Min: 1 Median: 1.5499 Max: 4271 Percentiles: P50: 1.55 P75: 1.93 P99: 5.81 P99.9: 10.72 P99.99: 92.04 ------------------------------------------------------ [ 0, 1 ] 300514 14.027% 14.027% ### ( 1, 2 ] 1401519 65.418% 79.445% ############# ( 2, 3 ] 289914 13.532% 92.977% ### ( 3, 4 ] 74612 3.483% 96.459% # ( 4, 6 ] 60059 2.803% 99.263% # ( 6, 10 ] 13395 0.625% 99.888% ( 10, 15 ] 1815 0.085% 99.973% ( 15, 22 ] 206 0.010% 99.982% ( 22, 34 ] 25 0.001% 99.983% ( 34, 51 ] 11 0.001% 99.984% ( 51, 76 ] 11 0.001% 99.984% ( 76, 110 ] 256 0.012% 99.996% ( 110, 170 ] 401 0.019% 100.015% ( 170, 250 ] 192 0.009% 100.024% ( 250, 380 ] 87 0.004% 100.028% ( 380, 580 ] 116 0.005% 100.034% ( 580, 870 ] 65 0.003% 100.037% ( 870, 1300 ] 37 0.002% 100.038% ( 1300, 1900 ] 11 0.001% 100.039% ( 1900, 2900 ] 10 0.000% 100.039% ( 2900, 4400 ] 9 0.000% 100.040% ** Level 1 read latency histogram (micros): Count: 334908 Average: 2.7693 StdDev: 16.78 Min: 0 Median: 1.6823 Max: 3804 Percentiles: P50: 1.68 P75: 2.27 P99: 6.39 P99.9: 83.12 P99.99: 537.20 ------------------------------------------------------ [ 0, 1 ] 26152 7.809% 7.809% ## ( 1, 2 ] 207086 61.834% 69.642% ############ ( 2, 3 ] 67077 20.028% 89.671% #### ( 3, 4 ] 15697 4.687% 94.358% # ( 4, 6 ] 15285 4.564% 98.922% # ( 6, 10 ] 2696 0.805% 99.727% ( 10, 15 ] 512 0.153% 99.880% ( 15, 22 ] 42 0.013% 99.892% ( 22, 34 ] 4 0.001% 99.893% ( 34, 51 ] 1 0.000% 99.894% ( 51, 76 ] 1 0.000% 99.894% ( 76, 110 ] 96 0.029% 99.923% ( 110, 170 ] 117 0.035% 99.958% ( 170, 250 ] 40 0.012% 99.970% ( 250, 380 ] 41 0.012% 99.982% ( 380, 580 ] 35 0.010% 99.992% ( 580, 870 ] 17 0.005% 99.997% ( 870, 1300 ] 12 0.004% 100.001% ( 1300, 1900 ] 11 0.003% 100.004% ( 1900, 2900 ] 3 0.001% 100.005% ( 2900, 4400 ] 1 0.000% 100.005% ** Level 2 read latency histogram (micros): Count: 60287 Average: 3.7176 StdDev: 46.05 Min: 0 Median: 1.7145 Max: 5801 Percentiles: P50: 1.71 P75: 2.40 P99: 8.73 P99.9: 316.03 P99.99: 1494.26 ------------------------------------------------------ [ 0, 1 ] 3938 6.532% 6.532% # ( 1, 2 ] 36679 60.841% 67.373% ############ ( 2, 3 ] 11528 19.122% 86.495% #### ( 3, 4 ] 3637 6.033% 92.527% # ( 4, 6 ] 3237 5.369% 97.897% # ( 6, 10 ] 975 1.617% 99.514% ( 10, 15 ] 118 0.196% 99.710% ( 15, 22 ] 17 0.028% 99.738% ( 22, 34 ] 5 0.008% 99.746% ( 34, 51 ] 1 0.002% 99.748% ( 51, 76 ] 1 0.002% 99.750% ( 76, 110 ] 3 0.005% 99.755% ( 110, 170 ] 41 0.068% 99.823% ( 170, 250 ] 33 0.055% 99.877% ( 250, 380 ] 27 0.045% 99.922% ( 380, 580 ] 20 0.033% 99.955% ( 580, 870 ] 16 0.027% 99.982% ( 870, 1300 ] 4 0.007% 99.988% ( 1300, 1900 ] 3 0.005% 99.993% ( 2900, 4400 ] 1 0.002% 99.995% ( 4400, 6600 ] 3 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 315247 Average: 3.6342 StdDev: 45.01 Min: 0 Median: 1.7547 Max: 7085 Percentiles: P50: 1.75 P75: 2.49 P99: 8.72 P99.9: 164.85 P99.99: 461.19 ------------------------------------------------------ [ 0, 1 ] 16534 5.245% 5.245% # ( 1, 2 ] 186958 59.305% 64.550% ############ ( 2, 3 ] 66800 21.190% 85.740% #### ( 3, 4 ] 20851 6.614% 92.354% # ( 4, 6 ] 17447 5.534% 97.888% # ( 6, 10 ] 5147 1.633% 99.521% ( 10, 15 ] 713 0.226% 99.747% ( 15, 22 ] 88 0.028% 99.775% ( 22, 34 ] 46 0.015% 99.790% ( 34, 51 ] 14 0.004% 99.794% ( 51, 76 ] 16 0.005% 99.799% ( 76, 110 ] 102 0.032% 99.832% ( 110, 170 ] 236 0.075% 99.906% ( 170, 250 ] 135 0.043% 99.949% ( 250, 380 ] 96 0.030% 99.980% ( 380, 580 ] 80 0.025% 100.005% ( 580, 870 ] 46 0.015% 100.020% ( 870, 1300 ] 18 0.006% 100.025% ( 1300, 1900 ] 15 0.005% 100.030% ( 1900, 2900 ] 9 0.003% 100.033% ( 2900, 4400 ] 6 0.002% 100.035% ( 4400, 6600 ] 10 0.003% 100.038% ( 6600, 9900 ] 3 0.001% 100.039% ** Level 4 read latency histogram (micros): Count: 100 Average: 806.1900 StdDev: 1724.00 Min: 1 Median: 4.7273 Max: 8697 Percentiles: P50: 4.73 P75: 34.00 P99: 8250.00 P99.9: 8697.00 P99.99: 8697.00 ------------------------------------------------------ [ 0, 1 ] 20 20.000% 20.000% #### ( 1, 2 ] 19 19.000% 39.000% #### ( 2, 3 ] 5 5.000% 44.000% # ( 3, 4 ] 2 2.000% 46.000% ( 4, 6 ] 11 11.000% 57.000% ## ( 6, 10 ] 3 3.000% 60.000% # ( 10, 15 ] 8 8.000% 68.000% ## ( 15, 22 ] 4 4.000% 72.000% # ( 22, 34 ] 3 3.000% 75.000% # ( 170, 250 ] 1 1.000% 76.000% ( 580, 870 ] 1 1.000% 77.000% ( 870, 1300 ] 4 4.000% 81.000% # ( 1300, 1900 ] 1 1.000% 82.000% ( 1900, 2900 ] 7 7.000% 89.000% # ( 2900, 4400 ] 2 2.000% 91.000% ( 4400, 6600 ] 7 7.000% 98.000% # ( 6600, 9900 ] 2 2.000% 100.000% ** Level 5 read latency histogram (micros): Count: 80 Average: 863.6000 StdDev: 1116.09 Min: 83 Median: 250.0000 Max: 5084 Percentiles: P50: 250.00 P75: 1192.50 P99: 4840.00 P99.9: 5084.00 P99.99: 5084.00 ------------------------------------------------------ ( 76, 110 ] 11 13.750% 13.750% ### ( 110, 170 ] 23 28.750% 42.500% ###### ( 170, 250 ] 6 7.500% 50.000% ## ( 250, 380 ] 3 3.750% 53.750% # ( 380, 580 ] 7 8.750% 62.500% ## ( 580, 870 ] 4 5.000% 67.500% # ( 870, 1300 ] 8 10.000% 77.500% ## ( 1300, 1900 ] 6 7.500% 85.000% ## ( 1900, 2900 ] 6 7.500% 92.500% ## ( 2900, 4400 ] 5 6.250% 98.750% # ( 4400, 6600 ] 1 1.250% 100.000% ** DB Stats ** Uptime(secs): 23.3 total, 7.3 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 253.17 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:7.007 H:M:S, 30.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 135.71 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:4.402 H:M:S, 60.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-07:36:45 ... thread 0: (1000000,7000000) ops and (307282.8,265606.9) ops/second in (3.254331,26.354734) 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/13 3.19 GB 75.5 5.4 0.0 5.4 11.9 6.6 0.0 1.8 135.4 301.8 40.47 37.76 114 0.355 5564K 7305 0.0 0.0 L1 17/17 1.40 GB 0.0 3.7 3.3 0.4 3.6 3.2 0.1 1.1 225.5 223.6 16.63 16.04 4 4.158 3808K 30K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 1.9 2.0 242.3 242.2 0.52 0.50 1 0.520 127K 34 0.0 0.0 L3 16/0 967.97 MB 1.0 2.7 1.2 1.5 2.7 1.2 0.8 2.2 210.6 210.2 13.05 11.76 10 1.305 2656K 4501 0.0 0.0 L4 169/0 9.47 GB 1.0 0.5 0.4 0.1 0.5 0.4 1.4 1.1 159.5 159.0 3.11 2.44 8 0.389 495K 1630 0.0 0.0 L5 1064/0 87.66 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 1284/30 102.67 GB 0.0 12.3 5.0 7.3 18.8 11.5 6.2 2.9 170.8 261.6 73.77 68.50 137 0.538 12M 44K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.3 5.0 7.3 18.8 11.5 6.1 2.9 170.8 261.6 73.77 68.50 137 0.538 12M 44K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 12.3 5.0 7.3 12.3 4.9 0.0 0.0 231.8 231.0 54.36 51.37 41 1.326 12M 44K 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 347.1 19.42 17.13 96 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): 26.6 total, 26.4 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: 18.84 GB write, 725.96 MB/s write, 12.31 GB read, 474.07 MB/s read, 73.8 seconds Interval compaction: 18.84 GB write, 732.11 MB/s write, 12.31 GB read, 478.09 MB/s read, 73.8 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: 21, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 21, interval: 32 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2519242 Average: 2.4062 StdDev: 13.20 Min: 1 Median: 1.5747 Max: 4271 Percentiles: P50: 1.57 P75: 1.96 P99: 5.90 P99.9: 10.91 P99.99: 20.82 ------------------------------------------------------ [ 0, 1 ] 322262 12.792% 12.792% ### ( 1, 2 ] 1631131 64.747% 77.539% ############# ( 2, 3 ] 370155 14.693% 92.232% ### ( 3, 4 ] 94058 3.734% 95.966% # ( 4, 6 ] 80604 3.200% 99.165% # ( 6, 10 ] 18055 0.717% 99.882% ( 10, 15 ] 2515 0.100% 99.982% ( 15, 22 ] 254 0.010% 99.992% ( 22, 34 ] 28 0.001% 99.993% ( 34, 51 ] 11 0.000% 99.993% ( 51, 76 ] 14 0.001% 99.994% ( 76, 110 ] 256 0.010% 100.004% ( 110, 170 ] 407 0.016% 100.020% ( 170, 250 ] 200 0.008% 100.028% ( 250, 380 ] 89 0.004% 100.032% ( 380, 580 ] 121 0.005% 100.036% ( 580, 870 ] 66 0.003% 100.039% ( 870, 1300 ] 44 0.002% 100.041% ( 1300, 1900 ] 11 0.000% 100.041% ( 1900, 2900 ] 13 0.001% 100.042% ( 2900, 4400 ] 14 0.001% 100.042% ** Level 1 read latency histogram (micros): Count: 416026 Average: 2.7726 StdDev: 15.89 Min: 0 Median: 1.6924 Max: 3804 Percentiles: P50: 1.69 P75: 2.29 P99: 6.86 P99.9: 77.31 P99.99: 548.32 ------------------------------------------------------ [ 0, 1 ] 29287 7.040% 7.040% # ( 1, 2 ] 258135 62.048% 69.088% ############ ( 2, 3 ] 85134 20.464% 89.551% #### ( 3, 4 ] 19609 4.713% 94.265% # ( 4, 6 ] 18865 4.535% 98.799% # ( 6, 10 ] 3882 0.933% 99.732% ( 10, 15 ] 638 0.153% 99.886% ( 15, 22 ] 48 0.012% 99.897% ( 22, 34 ] 5 0.001% 99.898% ( 34, 51 ] 2 0.000% 99.899% ( 51, 76 ] 1 0.000% 99.899% ( 76, 110 ] 103 0.025% 99.924% ( 110, 170 ] 132 0.032% 99.956% ( 170, 250 ] 54 0.013% 99.969% ( 250, 380 ] 49 0.012% 99.980% ( 380, 580 ] 48 0.012% 99.992% ( 580, 870 ] 22 0.005% 99.997% ( 870, 1300 ] 15 0.004% 100.001% ( 1300, 1900 ] 11 0.003% 100.003% ( 1900, 2900 ] 3 0.001% 100.004% ( 2900, 4400 ] 1 0.000% 100.004% ** Level 2 read latency histogram (micros): Count: 60287 Average: 3.7176 StdDev: 46.05 Min: 0 Median: 1.7145 Max: 5801 Percentiles: P50: 1.71 P75: 2.40 P99: 8.73 P99.9: 316.03 P99.99: 1494.26 ------------------------------------------------------ [ 0, 1 ] 3938 6.532% 6.532% # ( 1, 2 ] 36679 60.841% 67.373% ############ ( 2, 3 ] 11528 19.122% 86.495% #### ( 3, 4 ] 3637 6.033% 92.527% # ( 4, 6 ] 3237 5.369% 97.897% # ( 6, 10 ] 975 1.617% 99.514% ( 10, 15 ] 118 0.196% 99.710% ( 15, 22 ] 17 0.028% 99.738% ( 22, 34 ] 5 0.008% 99.746% ( 34, 51 ] 1 0.002% 99.748% ( 51, 76 ] 1 0.002% 99.750% ( 76, 110 ] 3 0.005% 99.755% ( 110, 170 ] 41 0.068% 99.823% ( 170, 250 ] 33 0.055% 99.877% ( 250, 380 ] 27 0.045% 99.922% ( 380, 580 ] 20 0.033% 99.955% ( 580, 870 ] 16 0.027% 99.982% ( 870, 1300 ] 4 0.007% 99.988% ( 1300, 1900 ] 3 0.005% 99.993% ( 2900, 4400 ] 1 0.002% 99.995% ( 4400, 6600 ] 3 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 452583 Average: 3.8173 StdDev: 41.29 Min: 0 Median: 1.8318 Max: 7085 Percentiles: P50: 1.83 P75: 2.67 P99: 8.87 P99.9: 142.99 P99.99: 243.91 ------------------------------------------------------ [ 0, 1 ] 18115 4.003% 4.003% # ( 1, 2 ] 250262 55.296% 59.299% ########### ( 2, 3 ] 106218 23.469% 82.768% ##### ( 3, 4 ] 34510 7.625% 90.393% ## ( 4, 6 ] 33185 7.332% 97.726% # ( 6, 10 ] 8046 1.778% 99.504% ( 10, 15 ] 1262 0.279% 99.782% ( 15, 22 ] 135 0.030% 99.812% ( 22, 34 ] 49 0.011% 99.823% ( 34, 51 ] 15 0.003% 99.826% ( 51, 76 ] 18 0.004% 99.830% ( 76, 110 ] 118 0.026% 99.856% ( 110, 170 ] 359 0.079% 99.936% ( 170, 250 ] 266 0.059% 99.994% ( 250, 380 ] 165 0.036% 100.031% ( 380, 580 ] 160 0.035% 100.066% ( 580, 870 ] 87 0.019% 100.086% ( 870, 1300 ] 32 0.007% 100.093% ( 1300, 1900 ] 15 0.003% 100.096% ( 1900, 2900 ] 15 0.003% 100.099% ( 2900, 4400 ] 9 0.002% 100.101% ( 4400, 6600 ] 10 0.002% 100.103% ( 6600, 9900 ] 3 0.001% 100.104% ** Level 4 read latency histogram (micros): Count: 165 Average: 527.9939 StdDev: 1394.01 Min: 1 Median: 2.6538 Max: 8697 Percentiles: P50: 2.65 P75: 25.00 P99: 7177.50 P99.9: 8697.00 P99.99: 8697.00 ------------------------------------------------------ [ 0, 1 ] 34 20.606% 20.606% #### ( 1, 2 ] 40 24.242% 44.848% ##### ( 2, 3 ] 13 7.879% 52.727% ## ( 3, 4 ] 5 3.030% 55.758% # ( 4, 6 ] 14 8.485% 64.242% ## ( 6, 10 ] 3 1.818% 66.061% ( 10, 15 ] 9 5.455% 71.515% # ( 15, 22 ] 5 3.030% 74.545% # ( 22, 34 ] 3 1.818% 76.364% ( 110, 170 ] 6 3.636% 80.000% # ( 170, 250 ] 2 1.212% 81.212% ( 250, 380 ] 1 0.606% 81.818% ( 580, 870 ] 5 3.030% 84.848% # ( 870, 1300 ] 6 3.636% 88.485% # ( 1300, 1900 ] 1 0.606% 89.091% ( 1900, 2900 ] 7 4.242% 93.333% # ( 2900, 4400 ] 2 1.212% 94.545% ( 4400, 6600 ] 7 4.242% 98.788% # ( 6600, 9900 ] 2 1.212% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 859.5667 StdDev: 1085.31 Min: 79 Median: 271.6667 Max: 5084 Percentiles: P50: 271.67 P75: 1264.17 P99: 5084.00 P99.9: 5084.00 P99.99: 5084.00 ------------------------------------------------------ ( 76, 110 ] 22 18.333% 18.333% #### ( 110, 170 ] 29 24.167% 42.500% ##### ( 170, 250 ] 8 6.667% 49.167% # ( 250, 380 ] 6 5.000% 54.167% # ( 380, 580 ] 9 7.500% 61.667% ## ( 580, 870 ] 5 4.167% 65.833% # ( 870, 1300 ] 12 10.000% 75.833% ## ( 1300, 1900 ] 10 8.333% 84.167% ## ( 1900, 2900 ] 11 9.167% 93.333% ## ( 2900, 4400 ] 6 5.000% 98.333% # ( 4400, 6600 ] 2 1.667% 100.000% ** DB Stats ** Uptime(secs): 26.6 total, 3.3 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 259.20 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:7.526 H:M:S, 28.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 302.42 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.519 H:M:S, 16.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-07:36:50 ... thread 0: (1000000,8000000) ops and (218874.8,258702.5) ops/second in (4.568821,30.923555) 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/9 4.24 GB 214.0 6.8 0.0 6.8 14.4 7.6 0.0 1.9 141.2 300.2 49.07 45.90 134 0.366 7035K 8880 0.0 0.0 L1 17/17 1.40 GB 0.0 3.7 3.3 0.4 3.6 3.2 0.1 1.1 225.5 223.6 16.63 16.04 4 4.158 3808K 30K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 1.9 2.0 242.3 242.2 0.52 0.50 1 0.520 127K 34 0.0 0.0 L3 16/0 967.97 MB 1.0 2.7 1.2 1.5 2.7 1.2 0.8 2.2 210.6 210.2 13.05 11.76 10 1.305 2656K 4501 0.0 0.0 L4 169/0 9.47 GB 1.0 0.5 0.4 0.1 0.5 0.4 1.4 1.1 159.5 159.0 3.11 2.44 8 0.389 495K 1630 0.0 0.0 L5 1064/0 87.66 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 1284/26 103.72 GB 0.0 13.7 5.0 8.8 21.3 12.5 6.2 2.8 170.5 264.8 82.38 76.65 157 0.525 14M 45K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.7 5.0 8.8 21.3 12.5 6.1 2.8 170.5 264.8 82.38 76.65 157 0.525 14M 45K 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.7 5.0 8.8 13.7 4.9 0.0 0.0 234.7 233.9 59.86 56.76 46 1.301 14M 45K 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 346.9 22.52 19.88 111 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): 31.1 total, 30.9 interval Flush(GB): cumulative 7.629, interval 7.629 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 21.30 GB write, 700.32 MB/s write, 13.72 GB read, 451.05 MB/s read, 82.4 seconds Interval compaction: 21.30 GB write, 705.38 MB/s write, 13.72 GB read, 454.31 MB/s read, 82.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 18, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 18, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 24, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 18, total-stops: 24, interval: 42 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2990310 Average: 2.4091 StdDev: 12.99 Min: 1 Median: 1.5760 Max: 4271 Percentiles: P50: 1.58 P75: 1.96 P99: 5.89 P99.9: 10.89 P99.99: 48.53 ------------------------------------------------------ [ 0, 1 ] 374013 12.507% 12.507% ### ( 1, 2 ] 1946575 65.096% 77.604% ############# ( 2, 3 ] 443897 14.845% 92.448% ### ( 3, 4 ] 108808 3.639% 96.087% # ( 4, 6 ] 92288 3.086% 99.173% # ( 6, 10 ] 21226 0.710% 99.883% ( 10, 15 ] 2870 0.096% 99.979% ( 15, 22 ] 288 0.010% 99.988% ( 22, 34 ] 34 0.001% 99.990% ( 34, 51 ] 14 0.000% 99.990% ( 51, 76 ] 16 0.001% 99.991% ( 76, 110 ] 327 0.011% 100.002% ( 110, 170 ] 504 0.017% 100.018% ( 170, 250 ] 251 0.008% 100.027% ( 250, 380 ] 115 0.004% 100.031% ( 380, 580 ] 162 0.005% 100.036% ( 580, 870 ] 83 0.003% 100.039% ( 870, 1300 ] 53 0.002% 100.041% ( 1300, 1900 ] 13 0.000% 100.041% ( 1900, 2900 ] 13 0.000% 100.041% ( 2900, 4400 ] 16 0.001% 100.042% ** Level 1 read latency histogram (micros): Count: 517659 Average: 2.7581 StdDev: 15.46 Min: 0 Median: 1.6720 Max: 3804 Percentiles: P50: 1.67 P75: 2.22 P99: 7.30 P99.9: 98.01 P99.99: 531.70 ------------------------------------------------------ [ 0, 1 ] 39645 7.659% 7.659% ## ( 1, 2 ] 326152 63.005% 70.664% ############# ( 2, 3 ] 101158 19.541% 90.205% #### ( 3, 4 ] 22368 4.321% 94.526% # ( 4, 6 ] 21368 4.128% 98.654% # ( 6, 10 ] 5494 1.061% 99.715% ( 10, 15 ] 729 0.141% 99.856% ( 15, 22 ] 62 0.012% 99.868% ( 22, 34 ] 5 0.001% 99.869% ( 34, 51 ] 2 0.000% 99.869% ( 51, 76 ] 2 0.000% 99.870% ( 76, 110 ] 243 0.047% 99.917% ( 110, 170 ] 191 0.037% 99.954% ( 170, 250 ] 75 0.014% 99.968% ( 250, 380 ] 71 0.014% 99.982% ( 380, 580 ] 57 0.011% 99.993% ( 580, 870 ] 23 0.004% 99.997% ( 870, 1300 ] 17 0.003% 100.001% ( 1300, 1900 ] 11 0.002% 100.003% ( 1900, 2900 ] 3 0.001% 100.003% ( 2900, 4400 ] 2 0.000% 100.004% ** Level 2 read latency histogram (micros): Count: 60287 Average: 3.7176 StdDev: 46.05 Min: 0 Median: 1.7145 Max: 5801 Percentiles: P50: 1.71 P75: 2.40 P99: 8.73 P99.9: 316.03 P99.99: 1494.26 ------------------------------------------------------ [ 0, 1 ] 3938 6.532% 6.532% # ( 1, 2 ] 36679 60.841% 67.373% ############ ( 2, 3 ] 11528 19.122% 86.495% #### ( 3, 4 ] 3637 6.033% 92.527% # ( 4, 6 ] 3237 5.369% 97.897% # ( 6, 10 ] 975 1.617% 99.514% ( 10, 15 ] 118 0.196% 99.710% ( 15, 22 ] 17 0.028% 99.738% ( 22, 34 ] 5 0.008% 99.746% ( 34, 51 ] 1 0.002% 99.748% ( 51, 76 ] 1 0.002% 99.750% ( 76, 110 ] 3 0.005% 99.755% ( 110, 170 ] 41 0.068% 99.823% ( 170, 250 ] 33 0.055% 99.877% ( 250, 380 ] 27 0.045% 99.922% ( 380, 580 ] 20 0.033% 99.955% ( 580, 870 ] 16 0.027% 99.982% ( 870, 1300 ] 4 0.007% 99.988% ( 1300, 1900 ] 3 0.005% 99.993% ( 2900, 4400 ] 1 0.002% 99.995% ( 4400, 6600 ] 3 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 452583 Average: 3.8173 StdDev: 41.29 Min: 0 Median: 1.8318 Max: 7085 Percentiles: P50: 1.83 P75: 2.67 P99: 8.87 P99.9: 142.99 P99.99: 243.91 ------------------------------------------------------ [ 0, 1 ] 18115 4.003% 4.003% # ( 1, 2 ] 250262 55.296% 59.299% ########### ( 2, 3 ] 106218 23.469% 82.768% ##### ( 3, 4 ] 34510 7.625% 90.393% ## ( 4, 6 ] 33185 7.332% 97.726% # ( 6, 10 ] 8046 1.778% 99.504% ( 10, 15 ] 1262 0.279% 99.782% ( 15, 22 ] 135 0.030% 99.812% ( 22, 34 ] 49 0.011% 99.823% ( 34, 51 ] 15 0.003% 99.826% ( 51, 76 ] 18 0.004% 99.830% ( 76, 110 ] 118 0.026% 99.856% ( 110, 170 ] 359 0.079% 99.936% ( 170, 250 ] 266 0.059% 99.994% ( 250, 380 ] 165 0.036% 100.031% ( 380, 580 ] 160 0.035% 100.066% ( 580, 870 ] 87 0.019% 100.086% ( 870, 1300 ] 32 0.007% 100.093% ( 1300, 1900 ] 15 0.003% 100.096% ( 1900, 2900 ] 15 0.003% 100.099% ( 2900, 4400 ] 9 0.002% 100.101% ( 4400, 6600 ] 10 0.002% 100.103% ( 6600, 9900 ] 3 0.001% 100.104% ** Level 4 read latency histogram (micros): Count: 165 Average: 527.9939 StdDev: 1394.01 Min: 1 Median: 2.6538 Max: 8697 Percentiles: P50: 2.65 P75: 25.00 P99: 7177.50 P99.9: 8697.00 P99.99: 8697.00 ------------------------------------------------------ [ 0, 1 ] 34 20.606% 20.606% #### ( 1, 2 ] 40 24.242% 44.848% ##### ( 2, 3 ] 13 7.879% 52.727% ## ( 3, 4 ] 5 3.030% 55.758% # ( 4, 6 ] 14 8.485% 64.242% ## ( 6, 10 ] 3 1.818% 66.061% ( 10, 15 ] 9 5.455% 71.515% # ( 15, 22 ] 5 3.030% 74.545% # ( 22, 34 ] 3 1.818% 76.364% ( 110, 170 ] 6 3.636% 80.000% # ( 170, 250 ] 2 1.212% 81.212% ( 250, 380 ] 1 0.606% 81.818% ( 580, 870 ] 5 3.030% 84.848% # ( 870, 1300 ] 6 3.636% 88.485% # ( 1300, 1900 ] 1 0.606% 89.091% ( 1900, 2900 ] 7 4.242% 93.333% # ( 2900, 4400 ] 2 1.212% 94.545% ( 4400, 6600 ] 7 4.242% 98.788% # ( 6600, 9900 ] 2 1.212% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 859.5667 StdDev: 1085.31 Min: 79 Median: 271.6667 Max: 5084 Percentiles: P50: 271.67 P75: 1264.17 P99: 5084.00 P99.9: 5084.00 P99.99: 5084.00 ------------------------------------------------------ ( 76, 110 ] 22 18.333% 18.333% #### ( 110, 170 ] 29 24.167% 42.500% ##### ( 170, 250 ] 8 6.667% 49.167% # ( 250, 380 ] 6 5.000% 54.167% # ( 380, 580 ] 9 7.500% 61.667% ## ( 580, 870 ] 5 4.167% 65.833% # ( 870, 1300 ] 12 10.000% 75.833% ## ( 1300, 1900 ] 10 8.333% 84.167% ## ( 1900, 2900 ] 11 9.167% 93.333% ## ( 2900, 4400 ] 6 5.000% 98.333% # ( 4400, 6600 ] 2 1.667% 100.000% ** DB Stats ** Uptime(secs): 31.1 total, 4.6 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 252.78 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:9.414 H:M:S, 30.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 215.42 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.887 H:M:S, 41.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/19-07:37:04 ... thread 0: (1000000,9000000) ops and (72250.0,201052.7) ops/second in (13.840832,44.764387) 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/10 2.94 GB 12.6 8.6 0.0 8.6 17.1 8.5 0.0 2.0 147.5 292.6 59.79 55.45 150 0.399 8953K 17K 0.0 0.0 L1 17/17 2.02 GB 0.0 7.2 5.4 1.8 7.1 5.3 0.1 1.3 218.8 216.3 33.77 31.81 5 6.755 7270K 30K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 3.4 2.0 242.3 242.2 0.52 0.50 1 0.520 127K 34 0.0 0.0 L3 20/0 992.59 MB 1.0 5.0 2.4 2.6 5.0 2.4 1.1 2.0 185.3 184.4 27.67 22.85 19 1.456 5072K 24K 0.0 0.0 L4 175/0 9.60 GB 1.0 2.3 1.9 0.4 2.2 1.9 1.4 1.2 168.2 167.0 13.75 11.02 29 0.474 2341K 16K 0.0 0.0 L5 1080/0 88.95 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1304/27 104.49 GB 0.0 23.2 9.8 13.4 31.6 18.1 9.3 3.7 175.4 238.5 135.50 121.63 204 0.664 23M 89K 0.0 0.0 Int 0/0 0.00 KB 0.0 23.2 9.8 13.4 31.6 18.1 9.1 3.7 175.4 238.5 135.50 121.63 204 0.664 23M 89K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 23.2 9.8 13.4 23.1 9.6 0.0 0.0 216.0 214.7 110.05 99.45 80 1.376 23M 89K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 0.0 0.0 0.0 341.5 25.46 22.19 124 0.205 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 45.0 total, 44.8 interval Flush(GB): cumulative 8.490, interval 8.490 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 31.57 GB write, 718.49 MB/s write, 23.22 GB read, 528.40 MB/s read, 135.5 seconds Interval compaction: 31.57 GB write, 722.07 MB/s write, 23.22 GB read, 531.04 MB/s read, 135.5 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: 27, pending-compaction-bytes-delays: 29, pending-compaction-bytes-stops: 0, total-delays: 51, total-stops: 27, interval: 78 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3929442 Average: 2.8495 StdDev: 21.56 Min: 1 Median: 1.5896 Max: 5469 Percentiles: P50: 1.59 P75: 1.98 P99: 7.08 P99.9: 131.99 P99.99: 256.46 ------------------------------------------------------ [ 0, 1 ] 479514 12.203% 12.203% ## ( 1, 2 ] 2519161 64.110% 76.313% ############# ( 2, 3 ] 594191 15.122% 91.435% ### ( 3, 4 ] 152022 3.869% 95.303% # ( 4, 6 ] 135572 3.450% 98.753% # ( 6, 10 ] 36029 0.917% 99.670% ( 10, 15 ] 4482 0.114% 99.784% ( 15, 22 ] 569 0.014% 99.799% ( 22, 34 ] 43 0.001% 99.800% ( 34, 51 ] 20 0.001% 99.801% ( 51, 76 ] 22 0.001% 99.801% ( 76, 110 ] 2427 0.062% 99.863% ( 110, 170 ] 3986 0.101% 99.964% ( 170, 250 ] 980 0.025% 99.989% ( 250, 380 ] 625 0.016% 100.005% ( 380, 580 ] 569 0.014% 100.020% ( 580, 870 ] 317 0.008% 100.028% ( 870, 1300 ] 152 0.004% 100.032% ( 1300, 1900 ] 58 0.001% 100.033% ( 1900, 2900 ] 55 0.001% 100.034% ( 2900, 4400 ] 50 0.001% 100.036% ( 4400, 6600 ] 4 0.000% 100.036% ** Level 1 read latency histogram (micros): Count: 1261411 Average: 3.6164 StdDev: 32.58 Min: 0 Median: 1.7770 Max: 7639 Percentiles: P50: 1.78 P75: 2.58 P99: 8.97 P99.9: 96.27 P99.99: 163.51 ------------------------------------------------------ [ 0, 1 ] 76258 6.045% 6.045% # ( 1, 2 ] 713557 56.568% 62.614% ########### ( 2, 3 ] 268935 21.320% 83.934% #### ( 3, 4 ] 80445 6.377% 90.311% # ( 4, 6 ] 89943 7.130% 97.442% # ( 6, 10 ] 26438 2.096% 99.537% ( 10, 15 ] 3488 0.277% 99.814% ( 15, 22 ] 473 0.037% 99.851% ( 22, 34 ] 36 0.003% 99.854% ( 34, 51 ] 11 0.001% 99.855% ( 51, 76 ] 35 0.003% 99.858% ( 76, 110 ] 890 0.071% 99.928% ( 110, 170 ] 870 0.069% 99.997% ( 170, 250 ] 356 0.028% 100.026% ( 250, 380 ] 402 0.032% 100.058% ( 380, 580 ] 380 0.030% 100.088% ( 580, 870 ] 262 0.021% 100.108% ( 870, 1300 ] 142 0.011% 100.120% ( 1300, 1900 ] 48 0.004% 100.124% ( 1900, 2900 ] 32 0.003% 100.126% ( 2900, 4400 ] 33 0.003% 100.129% ( 4400, 6600 ] 1 0.000% 100.129% ( 6600, 9900 ] 2 0.000% 100.129% ** Level 2 read latency histogram (micros): Count: 60287 Average: 3.7176 StdDev: 46.05 Min: 0 Median: 1.7145 Max: 5801 Percentiles: P50: 1.71 P75: 2.40 P99: 8.73 P99.9: 316.03 P99.99: 1494.26 ------------------------------------------------------ [ 0, 1 ] 3938 6.532% 6.532% # ( 1, 2 ] 36679 60.841% 67.373% ############ ( 2, 3 ] 11528 19.122% 86.495% #### ( 3, 4 ] 3637 6.033% 92.527% # ( 4, 6 ] 3237 5.369% 97.897% # ( 6, 10 ] 975 1.617% 99.514% ( 10, 15 ] 118 0.196% 99.710% ( 15, 22 ] 17 0.028% 99.738% ( 22, 34 ] 5 0.008% 99.746% ( 34, 51 ] 1 0.002% 99.748% ( 51, 76 ] 1 0.002% 99.750% ( 76, 110 ] 3 0.005% 99.755% ( 110, 170 ] 41 0.068% 99.823% ( 170, 250 ] 33 0.055% 99.877% ( 250, 380 ] 27 0.045% 99.922% ( 380, 580 ] 20 0.033% 99.955% ( 580, 870 ] 16 0.027% 99.982% ( 870, 1300 ] 4 0.007% 99.988% ( 1300, 1900 ] 3 0.005% 99.993% ( 2900, 4400 ] 1 0.002% 99.995% ( 4400, 6600 ] 3 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 1031037 Average: 4.3677 StdDev: 42.00 Min: 0 Median: 2.0043 Max: 7085 Percentiles: P50: 2.00 P75: 2.94 P99: 9.07 P99.9: 15.75 P99.99: 129.79 ------------------------------------------------------ [ 0, 1 ] 22580 2.190% 2.190% ( 1, 2 ] 491755 47.695% 49.885% ########## ( 2, 3 ] 274853 26.658% 76.543% ##### ( 3, 4 ] 99784 9.678% 86.221% ## ( 4, 6 ] 114049 11.062% 97.283% ## ( 6, 10 ] 23071 2.238% 99.520% ( 10, 15 ] 3869 0.375% 99.896% ( 15, 22 ] 417 0.040% 99.936% ( 22, 34 ] 67 0.006% 99.943% ( 34, 51 ] 26 0.003% 99.945% ( 51, 76 ] 59 0.006% 99.951% ( 76, 110 ] 204 0.020% 99.971% ( 110, 170 ] 606 0.059% 100.029% ( 170, 250 ] 573 0.056% 100.085% ( 250, 380 ] 472 0.046% 100.131% ( 380, 580 ] 481 0.047% 100.177% ( 580, 870 ] 356 0.035% 100.212% ( 870, 1300 ] 211 0.020% 100.232% ( 1300, 1900 ] 69 0.007% 100.239% ( 1900, 2900 ] 25 0.002% 100.242% ( 2900, 4400 ] 39 0.004% 100.245% ( 4400, 6600 ] 10 0.001% 100.246% ( 6600, 9900 ] 3 0.000% 100.247% ** Level 4 read latency histogram (micros): Count: 380 Average: 312.2474 StdDev: 977.55 Min: 1 Median: 2.6286 Max: 8697 Percentiles: P50: 2.63 P75: 87.33 P99: 6034.29 P99.9: 8697.00 P99.99: 8697.00 ------------------------------------------------------ [ 0, 1 ] 71 18.684% 18.684% #### ( 1, 2 ] 97 25.526% 44.211% ##### ( 2, 3 ] 35 9.211% 53.421% ## ( 3, 4 ] 17 4.474% 57.895% # ( 4, 6 ] 15 3.947% 61.842% # ( 6, 10 ] 4 1.053% 62.895% ( 10, 15 ] 13 3.421% 66.316% # ( 15, 22 ] 12 3.158% 69.474% # ( 22, 34 ] 7 1.842% 71.316% ( 34, 51 ] 1 0.263% 71.579% ( 51, 76 ] 11 2.895% 74.474% # ( 76, 110 ] 6 1.579% 76.053% ( 110, 170 ] 6 1.579% 77.632% ( 170, 250 ] 23 6.053% 83.684% # ( 250, 380 ] 7 1.842% 85.526% ( 380, 580 ] 6 1.579% 87.105% ( 580, 870 ] 15 3.947% 91.053% # ( 870, 1300 ] 11 2.895% 93.947% # ( 1300, 1900 ] 4 1.053% 95.000% ( 1900, 2900 ] 7 1.842% 96.842% ( 2900, 4400 ] 3 0.789% 97.632% ( 4400, 6600 ] 7 1.842% 99.474% ( 6600, 9900 ] 2 0.526% 100.000% ** Level 5 read latency histogram (micros): Count: 200 Average: 908.8200 StdDev: 1114.63 Min: 79 Median: 320.9091 Max: 5084 Percentiles: P50: 320.91 P75: 1366.67 P99: 5084.00 P99.9: 5084.00 P99.99: 5084.00 ------------------------------------------------------ ( 76, 110 ] 28 14.000% 14.000% ### ( 110, 170 ] 47 23.500% 37.500% ##### ( 170, 250 ] 19 9.500% 47.000% ## ( 250, 380 ] 11 5.500% 52.500% # ( 380, 580 ] 14 7.000% 59.500% # ( 580, 870 ] 12 6.000% 65.500% # ( 870, 1300 ] 17 8.500% 74.000% ## ( 1300, 1900 ] 18 9.000% 83.000% ## ( 1900, 2900 ] 16 8.000% 91.000% ## ( 2900, 4400 ] 15 7.500% 98.500% ## ( 4400, 6600 ] 3 1.500% 100.000% ** DB Stats ** Uptime(secs): 45.0 total, 13.8 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 196.89 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:20.392 H:M:S, 45.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 71.11 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:10.978 H:M:S, 79.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 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.092 micros/op 164154 ops/sec 60.181 seconds 9878999 operations; 159.1 MB/s Microseconds per write: Count: 9878999 Average: 6.0918 StdDev: 282.71 Min: 0 Median: 1.7335 Max: 306425 Percentiles: P50: 1.73 P75: 2.74 P99: 8.79 P99.9: 1187.72 P99.99: 2732.59 ------------------------------------------------------ [ 0, 1 ] 1367749 13.845% 13.845% ### ( 1, 2 ] 4869390 49.290% 63.135% ########## ( 2, 3 ] 1583385 16.028% 79.163% ### ( 3, 4 ] 1365538 13.823% 92.986% ### ( 4, 6 ] 525681 5.321% 98.307% # ( 6, 10 ] 98306 0.995% 99.302% ( 10, 15 ] 26560 0.269% 99.571% ( 15, 22 ] 7954 0.081% 99.651% ( 22, 34 ] 1554 0.016% 99.667% ( 34, 51 ] 204 0.002% 99.669% ( 51, 76 ] 18 0.000% 99.669% ( 76, 110 ] 6744 0.068% 99.738% ( 110, 170 ] 2838 0.029% 99.766% ( 170, 250 ] 311 0.003% 99.770% ( 250, 380 ] 105 0.001% 99.771% ( 380, 580 ] 16 0.000% 99.771% ( 580, 870 ] 14 0.000% 99.771% ( 870, 1300 ] 17260 0.175% 99.946% ( 1300, 1900 ] 43 0.000% 99.946% ( 1900, 2900 ] 5214 0.053% 99.999% ( 2900, 4400 ] 63 0.001% 99.999% ( 4400, 6600 ] 19 0.000% 100.000% ( 6600, 9900 ] 5 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 5 0.000% 100.000% ( 33000, 50000 ] 2 0.000% 100.000% ( 50000, 75000 ] 1 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 13 0.000% 100.000% ( 250000, 380000 ] 2 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 214283 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 : 9878999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10195126968 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 : 528 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 33327056 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 : 30737530122 rocksdb.compact.write.bytes COUNT : 30537823635 rocksdb.flush.write.bytes COUNT : 10172905012 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 : 49 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 : 253 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 : 10090798080 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3837952 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 : 30826480613 rocksdb.non.last.level.read.count COUNT : 7451355 rocksdb.block.checksum.compute.count COUNT : 7450348 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.378361 P95 : 3.880438 P99 : 7.235198 P100 : 306423.000000 COUNT : 9878999 SUM : 55642871 rocksdb.compaction.times.micros P50 : 951538.461538 P95 : 3740000.000000 P99 : 15280000.000000 P100 : 17143411.000000 COUNT : 84 SUM : 114688117 rocksdb.compaction.times.cpu_micros P50 : 918620.689655 P95 : 3740000.000000 P99 : 15280000.000000 P100 : 15772756.000000 COUNT : 84 SUM : 103968814 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 : 709.085366 P95 : 1235.500000 P99 : 2443.333333 P100 : 2747.000000 COUNT : 137 SUM : 101966 rocksdb.compaction.outfile.sync.micros P50 : 852.881944 P95 : 43412.500000 P99 : 142175.000000 P100 : 163927.000000 COUNT : 371 SUM : 2506420 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.617284 P95 : 423.000000 P99 : 962.450000 P100 : 2556.000000 COUNT : 257 SUM : 39056 rocksdb.table.open.io.micros P50 : 1215.977011 P95 : 6175.714286 P99 : 15965.714286 P100 : 20719.000000 COUNT : 528 SUM : 1056799 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.697168 P95 : 7.808550 P99 : 10.534531 P100 : 13070.000000 COUNT : 7448950 SUM : 38920637 rocksdb.read.block.get.micros P50 : 422.857143 P95 : 3320.000000 P99 : 5956.210526 P100 : 8826.000000 COUNT : 1056 SUM : 861088 rocksdb.write.raw.block.micros P50 : 0.513393 P95 : 0.975447 P99 : 2.929236 P100 : 8096.000000 COUNT : 9860155 SUM : 18646334 rocksdb.numfiles.in.singlecompaction P50 : 3.103448 P95 : 10.875000 P99 : 26.000000 P100 : 26.000000 COUNT : 126 SUM : 493 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.558308 P95 : 1162.128012 P99 : 2499.600768 P100 : 306234.000000 COUNT : 217308 SUM : 33342231 rocksdb.sst.read.micros P50 : 1.639080 P95 : 4.683010 P99 : 8.338457 P100 : 8697.000000 COUNT : 7451709 SUM : 23757175 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 : 9878999 SUM : 10195126968 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 : 214074.074074 P95 : 350558.823529 P99 : 445012.000000 P100 : 445012.000000 COUNT : 137 SUM : 28446867 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 : 348 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