[2024-11-19 10:38:28.898538] Starting SPDK v25.01-pre git sha1 53ca6a885 / DPDK 24.03.0 initialization... [2024-11-19 10:38:28.898831] [ 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_pid3739957 ] Set seed to 1732009108891723 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-19 10:38:29.049590] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-19 10:38:29.145081] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-19 10:38:29.145124] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 3739957' to capture a snapshot of events at runtime. [2024-11-19 10:38:29.145136] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-19 10:38:29.145147] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-19 10:38:29.145158] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid3739957 for offline analysis/debug. [2024-11-19 10:38:29.146413] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Tue Nov 19 10:38:31 2024 CPU: 144 * Intel(R) Xeon(R) Platinum 8360Y CPU @ 2.40GHz CPUCache: 55296 KB 2024/11/19-10:38:34 ... thread 0: (1000000,1000000) ops and (377694.7,377694.7) ops/second in (2.647641,2.647641) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/8 566.27 MB 6.3 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 395.7 2.07 1.90 13 0.159 0 0 0.0 0.0 L1 3/3 188.11 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 274.6 273.7 0.69 0.67 1 0.687 191K 614 0.0 0.0 L2 1/1 100.83 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.0 2.6 262.2 261.6 0.61 0.59 1 0.613 163K 328 0.0 0.0 L3 19/12 1004.59 MB 0.1 0.1 0.1 0.0 0.1 0.1 0.0 1.0 209.8 209.8 0.28 0.27 1 0.284 60K 0 0.0 0.0 L4 124/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 120/0 8.67 GB 0.1 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 276/24 20.03 GB 0.0 0.4 0.3 0.1 1.2 1.1 0.1 1.5 112.1 335.8 3.65 3.43 16 0.228 415K 942 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.2 1.1 0.1 1.5 112.1 335.8 3.65 3.43 16 0.228 415K 942 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.3 0.1 0.4 0.3 0.0 0.0 258.2 257.6 1.59 1.53 3 0.528 415K 942 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 395.7 2.07 1.90 13 0.159 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): 2.7 total, 2.7 interval Flush(GB): cumulative 0.799, interval 0.799 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.20 GB write, 451.20 MB/s write, 0.40 GB read, 150.58 MB/s read, 3.7 seconds Interval compaction: 1.20 GB write, 462.54 MB/s write, 0.40 GB read, 154.37 MB/s read, 3.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 0, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 0, ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 114895 Average: 1.9779 StdDev: 4.40 Min: 0 Median: 1.3576 Max: 464 Percentiles: P50: 1.36 P75: 1.77 P99: 5.39 P99.9: 9.71 P99.99: 127.55 ------------------------------------------------------ [ 0, 1 ] 32485 28.274% 28.274% ###### ( 1, 2 ] 69803 60.754% 89.027% ############ ( 2, 3 ] 7043 6.130% 95.157% # ( 3, 4 ] 3160 2.750% 97.908% # ( 4, 6 ] 1801 1.568% 99.475% ( 6, 10 ] 528 0.460% 99.935% ( 10, 15 ] 43 0.037% 99.972% ( 15, 22 ] 14 0.012% 99.984% ( 22, 34 ] 3 0.003% 99.987% ( 34, 51 ] 1 0.001% 99.988% ( 110, 170 ] 12 0.010% 99.998% ( 170, 250 ] 1 0.001% 99.999% ( 250, 380 ] 7 0.006% 100.005% ( 380, 580 ] 6 0.005% 100.010% ** Level 1 read latency histogram (micros): Count: 22868 Average: 2.0180 StdDev: 4.62 Min: 1 Median: 1.4057 Max: 519 Percentiles: P50: 1.41 P75: 1.80 P99: 5.11 P99.9: 8.51 P99.99: 227.06 ------------------------------------------------------ [ 0, 1 ] 5518 24.130% 24.130% ##### ( 1, 2 ] 14582 63.766% 87.896% ############# ( 2, 3 ] 1524 6.664% 94.560% # ( 3, 4 ] 798 3.490% 98.050% # ( 4, 6 ] 394 1.723% 99.773% ( 6, 10 ] 48 0.210% 99.983% ( 15, 22 ] 1 0.004% 99.987% ( 110, 170 ] 1 0.004% 99.991% ( 170, 250 ] 1 0.004% 99.996% ( 380, 580 ] 2 0.009% 100.004% ** Level 2 read latency histogram (micros): Count: 40109 Average: 2.6696 StdDev: 21.71 Min: 1 Median: 1.3713 Max: 2488 Percentiles: P50: 1.37 P75: 1.82 P99: 8.18 P99.9: 172.38 P99.99: 577.82 ------------------------------------------------------ [ 0, 1 ] 11745 29.283% 29.283% ###### ( 1, 2 ] 22377 55.790% 85.073% ########### ( 2, 3 ] 2630 6.557% 91.630% # ( 3, 4 ] 1516 3.780% 95.410% # ( 4, 6 ] 1204 3.002% 98.412% # ( 6, 10 ] 432 1.077% 99.489% ( 10, 15 ] 48 0.120% 99.609% ( 15, 22 ] 8 0.020% 99.629% ( 22, 34 ] 4 0.010% 99.638% ( 34, 51 ] 25 0.062% 99.701% ( 51, 76 ] 4 0.010% 99.711% ( 76, 110 ] 32 0.080% 99.791% ( 110, 170 ] 43 0.107% 99.898% ( 170, 250 ] 30 0.075% 99.973% ( 250, 380 ] 6 0.015% 99.988% ( 380, 580 ] 1 0.002% 99.990% ( 1300, 1900 ] 2 0.005% 99.995% ( 1900, 2900 ] 2 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 25788 Average: 6.6122 StdDev: 97.35 Min: 0 Median: 1.0475 Max: 3613 Percentiles: P50: 1.05 P75: 1.76 P99: 8.65 P99.9: 2060.55 P99.99: 3613.00 ------------------------------------------------------ [ 0, 1 ] 12462 48.325% 48.325% ########## ( 1, 2 ] 9101 35.292% 83.616% ####### ( 2, 3 ] 2376 9.214% 92.830% ## ( 3, 4 ] 982 3.808% 96.638% # ( 4, 6 ] 498 1.931% 98.569% ( 6, 10 ] 169 0.655% 99.224% ( 10, 15 ] 8 0.031% 99.255% ( 15, 22 ] 1 0.004% 99.259% ( 22, 34 ] 1 0.004% 99.263% ( 34, 51 ] 18 0.070% 99.333% ( 51, 76 ] 13 0.050% 99.383% ( 76, 110 ] 19 0.074% 99.457% ( 110, 170 ] 57 0.221% 99.678% ( 170, 250 ] 18 0.070% 99.748% ( 250, 380 ] 8 0.031% 99.779% ( 380, 580 ] 5 0.019% 99.798% ( 580, 870 ] 4 0.016% 99.814% ( 870, 1300 ] 7 0.027% 99.841% ( 1300, 1900 ] 13 0.050% 99.891% ( 1900, 2900 ] 20 0.078% 99.969% ( 2900, 4400 ] 9 0.035% 100.004% ** Level 4 read latency histogram (micros): Count: 10 Average: 2121.9000 StdDev: 887.02 Min: 576 Median: 2400.0000 Max: 3206 Percentiles: P50: 2400.00 P75: 3150.00 P99: 3206.00 P99.9: 3206.00 P99.99: 3206.00 ------------------------------------------------------ ( 380, 580 ] 1 10.000% 10.000% ## ( 580, 870 ] 1 10.000% 20.000% ## ( 1300, 1900 ] 1 10.000% 30.000% ## ( 1900, 2900 ] 4 40.000% 70.000% ######## ( 2900, 4400 ] 3 30.000% 100.000% ###### ** DB Stats ** Uptime(secs): 2.7 total, 2.7 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 362.11 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.000 H:M:S, 0.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 371.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:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/19-10:38:36 ... thread 0: (1000000,2000000) ops and (380707.4,379195.1) ops/second in (2.626689,5.274330) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/8 1.29 GB 12.6 0.8 0.0 0.8 2.6 1.8 0.0 1.4 109.5 353.2 7.47 6.88 30 0.249 830K 4234 0.0 0.0 L1 1/1 49.77 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 276.5 274.6 2.27 2.23 2 1.136 638K 4274 0.0 0.0 L2 2/2 229.61 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.4 2.6 262.2 261.6 0.61 0.59 1 0.613 163K 328 0.0 0.0 L3 21/14 1.23 GB 0.3 0.4 0.3 0.1 0.4 0.3 0.0 1.2 221.7 221.2 1.69 1.57 3 0.565 381K 835 0.0 0.0 L4 124/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 120/0 8.67 GB 0.1 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 278/25 21.00 GB 0.0 1.9 0.8 1.1 3.7 2.6 0.4 2.1 164.6 315.2 12.05 11.27 36 0.335 2013K 9671 0.0 0.0 Int 0/0 0.00 KB 0.0 1.9 0.8 1.1 3.7 2.6 0.4 2.1 164.6 315.2 12.05 11.27 36 0.335 2013K 9671 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.9 0.8 1.1 1.9 0.8 0.0 0.0 265.1 263.8 7.48 7.14 9 0.831 2013K 9671 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 399.2 4.57 4.13 27 0.169 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): 5.3 total, 5.3 interval Flush(GB): cumulative 1.781, interval 1.781 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.71 GB write, 710.44 MB/s write, 1.94 GB read, 370.96 MB/s read, 12.0 seconds Interval compaction: 3.71 GB write, 719.41 MB/s write, 1.94 GB read, 375.64 MB/s read, 12.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 355845 Average: 2.5461 StdDev: 13.34 Min: 0 Median: 1.4222 Max: 1254 Percentiles: P50: 1.42 P75: 1.86 P99: 5.79 P99.9: 163.57 P99.99: 344.73 ------------------------------------------------------ [ 0, 1 ] 92211 25.913% 25.913% ##### ( 1, 2 ] 202995 57.046% 82.959% ########### ( 2, 3 ] 33508 9.416% 92.376% ## ( 3, 4 ] 16556 4.653% 97.028% # ( 4, 6 ] 7836 2.202% 99.230% ( 6, 10 ] 1903 0.535% 99.765% ( 10, 15 ] 204 0.057% 99.822% ( 15, 22 ] 47 0.013% 99.836% ( 22, 34 ] 11 0.003% 99.839% ( 34, 51 ] 4 0.001% 99.840% ( 51, 76 ] 4 0.001% 99.841% ( 76, 110 ] 3 0.001% 99.842% ( 110, 170 ] 232 0.065% 99.907% ( 170, 250 ] 173 0.049% 99.956% ( 250, 380 ] 168 0.047% 100.003% ( 380, 580 ] 84 0.024% 100.026% ( 580, 870 ] 25 0.007% 100.033% ( 870, 1300 ] 5 0.001% 100.035% ** Level 1 read latency histogram (micros): Count: 145890 Average: 2.4881 StdDev: 10.67 Min: 1 Median: 1.4627 Max: 1081 Percentiles: P50: 1.46 P75: 1.93 P99: 6.58 P99.9: 138.93 P99.99: 405.38 ------------------------------------------------------ [ 0, 1 ] 37089 25.423% 25.423% ##### ( 1, 2 ] 77485 53.112% 78.535% ########### ( 2, 3 ] 15429 10.576% 89.110% ## ( 3, 4 ] 8739 5.990% 95.100% # ( 4, 6 ] 5505 3.773% 98.874% # ( 6, 10 ] 1270 0.871% 99.744% ( 10, 15 ] 175 0.120% 99.864% ( 15, 22 ] 19 0.013% 99.877% ( 22, 34 ] 5 0.003% 99.881% ( 34, 51 ] 3 0.002% 99.883% ( 51, 76 ] 1 0.001% 99.883% ( 110, 170 ] 50 0.034% 99.918% ( 170, 250 ] 48 0.033% 99.951% ( 250, 380 ] 55 0.038% 99.988% ( 380, 580 ] 19 0.013% 100.001% ( 580, 870 ] 5 0.003% 100.005% ( 870, 1300 ] 2 0.001% 100.006% ** Level 2 read latency histogram (micros): Count: 60515 Average: 2.3859 StdDev: 18.20 Min: 1 Median: 1.2467 Max: 2488 Percentiles: P50: 1.25 P75: 1.76 P99: 6.63 P99.9: 162.34 P99.99: 379.33 ------------------------------------------------------ [ 0, 1 ] 22992 37.994% 37.994% ######## ( 1, 2 ] 29447 48.661% 86.655% ########## ( 2, 3 ] 3901 6.446% 93.101% # ( 3, 4 ] 2015 3.330% 96.431% # ( 4, 6 ] 1484 2.452% 98.883% ( 6, 10 ] 449 0.742% 99.625% ( 10, 15 ] 49 0.081% 99.706% ( 15, 22 ] 8 0.013% 99.719% ( 22, 34 ] 4 0.007% 99.726% ( 34, 51 ] 25 0.041% 99.767% ( 51, 76 ] 4 0.007% 99.774% ( 76, 110 ] 32 0.053% 99.826% ( 110, 170 ] 51 0.084% 99.911% ( 170, 250 ] 38 0.063% 99.974% ( 250, 380 ] 10 0.017% 99.990% ( 380, 580 ] 2 0.003% 99.993% ( 1300, 1900 ] 2 0.003% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 266416 Average: 2.8712 StdDev: 33.49 Min: 0 Median: 0.9847 Max: 3613 Percentiles: P50: 0.98 P75: 1.68 P99: 5.73 P99.9: 278.41 P99.99: 1408.85 ------------------------------------------------------ [ 0, 1 ] 135275 50.776% 50.776% ########## ( 1, 2 ] 94369 35.422% 86.198% ####### ( 2, 3 ] 20452 7.677% 93.874% ## ( 3, 4 ] 9250 3.472% 97.346% # ( 4, 6 ] 5097 1.913% 99.259% ( 6, 10 ] 816 0.306% 99.566% ( 10, 15 ] 62 0.023% 99.589% ( 15, 22 ] 15 0.006% 99.595% ( 22, 34 ] 4 0.002% 99.596% ( 34, 51 ] 157 0.059% 99.655% ( 51, 76 ] 41 0.015% 99.670% ( 76, 110 ] 49 0.018% 99.689% ( 110, 170 ] 257 0.096% 99.785% ( 170, 250 ] 269 0.101% 99.886% ( 250, 380 ] 172 0.065% 99.951% ( 380, 580 ] 73 0.027% 99.978% ( 580, 870 ] 20 0.008% 99.986% ( 870, 1300 ] 10 0.004% 99.989% ( 1300, 1900 ] 13 0.005% 99.994% ( 1900, 2900 ] 20 0.008% 100.002% ( 2900, 4400 ] 9 0.003% 100.005% ** Level 4 read latency histogram (micros): Count: 10 Average: 2121.9000 StdDev: 887.02 Min: 576 Median: 2400.0000 Max: 3206 Percentiles: P50: 2400.00 P75: 3150.00 P99: 3206.00 P99.9: 3206.00 P99.99: 3206.00 ------------------------------------------------------ ( 380, 580 ] 1 10.000% 10.000% ## ( 580, 870 ] 1 10.000% 20.000% ## ( 1300, 1900 ] 1 10.000% 30.000% ## ( 1900, 2900 ] 4 40.000% 70.000% ######## ( 2900, 4400 ] 3 30.000% 100.000% ###### ** DB Stats ** Uptime(secs): 5.3 total, 2.6 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 368.29 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.423 H:M:S, 7.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 374.69 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.423 H:M:S, 16.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/19-10:38:39 ... thread 0: (1000000,3000000) ops and (354638.0,370640.0) ops/second in (2.819777,8.094107) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/8 2.26 GB 112.7 1.7 0.0 1.7 4.4 2.8 0.0 1.6 134.4 357.6 12.64 11.74 46 0.275 1724K 9236 0.0 0.0 L1 1/1 49.77 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 276.5 274.6 2.27 2.23 2 1.136 638K 4274 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.4 2.6 262.2 261.6 0.61 0.59 1 0.613 163K 328 0.0 0.0 L3 18/0 747.40 MB 0.7 1.6 0.5 1.0 1.6 0.5 0.0 2.9 298.7 297.9 5.34 4.99 5 1.069 1621K 4247 0.0 0.0 L4 130/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 244.7 244.7 0.92 0.88 1 0.920 228K 0 0.0 0.0 L5 128/0 9.29 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 291/9 21.97 GB 0.0 4.2 1.2 3.0 7.0 4.0 1.6 2.5 197.8 326.8 21.78 20.42 55 0.396 4375K 18K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.2 1.2 3.0 7.0 4.0 1.6 2.5 197.8 326.8 21.78 20.42 55 0.396 4375K 18K 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.2 1.2 3.0 4.2 1.2 0.0 0.0 293.3 292.1 14.69 14.02 15 0.979 4375K 18K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 398.8 7.10 6.40 40 0.177 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): 8.2 total, 8.1 interval Flush(GB): cumulative 2.764, interval 2.764 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: 6.95 GB write, 872.14 MB/s write, 4.21 GB read, 527.72 MB/s read, 21.8 seconds Interval compaction: 6.95 GB write, 879.32 MB/s write, 4.21 GB read, 532.06 MB/s read, 21.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: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 9, interval: 9 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 802647 Average: 2.1995 StdDev: 11.31 Min: 0 Median: 1.2765 Max: 1889 Percentiles: P50: 1.28 P75: 1.76 P99: 5.31 P99.9: 12.24 P99.99: 203.71 ------------------------------------------------------ [ 0, 1 ] 287526 35.822% 35.822% ####### ( 1, 2 ] 411530 51.272% 87.094% ########## ( 2, 3 ] 59425 7.404% 94.497% # ( 3, 4 ] 27655 3.445% 97.943% # ( 4, 6 ] 12998 1.619% 99.562% ( 6, 10 ] 2603 0.324% 99.887% ( 10, 15 ] 240 0.030% 99.917% ( 15, 22 ] 55 0.007% 99.923% ( 22, 34 ] 15 0.002% 99.925% ( 34, 51 ] 6 0.001% 99.926% ( 51, 76 ] 4 0.000% 99.926% ( 76, 110 ] 25 0.003% 99.930% ( 110, 170 ] 360 0.045% 99.974% ( 170, 250 ] 296 0.037% 100.011% ( 250, 380 ] 218 0.027% 100.038% ( 380, 580 ] 119 0.015% 100.053% ( 580, 870 ] 33 0.004% 100.057% ( 870, 1300 ] 9 0.001% 100.059% ( 1300, 1900 ] 3 0.000% 100.059% ** Level 1 read latency histogram (micros): Count: 145890 Average: 2.4881 StdDev: 10.67 Min: 1 Median: 1.4627 Max: 1081 Percentiles: P50: 1.46 P75: 1.93 P99: 6.58 P99.9: 138.93 P99.99: 405.38 ------------------------------------------------------ [ 0, 1 ] 37089 25.423% 25.423% ##### ( 1, 2 ] 77485 53.112% 78.535% ########### ( 2, 3 ] 15429 10.576% 89.110% ## ( 3, 4 ] 8739 5.990% 95.100% # ( 4, 6 ] 5505 3.773% 98.874% # ( 6, 10 ] 1270 0.871% 99.744% ( 10, 15 ] 175 0.120% 99.864% ( 15, 22 ] 19 0.013% 99.877% ( 22, 34 ] 5 0.003% 99.881% ( 34, 51 ] 3 0.002% 99.883% ( 51, 76 ] 1 0.001% 99.883% ( 110, 170 ] 50 0.034% 99.918% ( 170, 250 ] 48 0.033% 99.951% ( 250, 380 ] 55 0.038% 99.988% ( 380, 580 ] 19 0.013% 100.001% ( 580, 870 ] 5 0.003% 100.005% ( 870, 1300 ] 2 0.001% 100.006% ** Level 2 read latency histogram (micros): Count: 65640 Average: 2.3144 StdDev: 17.48 Min: 1 Median: 1.2114 Max: 2488 Percentiles: P50: 1.21 P75: 1.74 P99: 6.20 P99.9: 156.31 P99.99: 372.67 ------------------------------------------------------ [ 0, 1 ] 26273 40.026% 40.026% ######## ( 1, 2 ] 30971 47.183% 87.209% ######### ( 2, 3 ] 4074 6.207% 93.416% # ( 3, 4 ] 2097 3.195% 96.610% # ( 4, 6 ] 1546 2.355% 98.966% ( 6, 10 ] 451 0.687% 99.653% ( 10, 15 ] 49 0.075% 99.727% ( 15, 22 ] 9 0.014% 99.741% ( 22, 34 ] 4 0.006% 99.747% ( 34, 51 ] 25 0.038% 99.785% ( 51, 76 ] 4 0.006% 99.791% ( 76, 110 ] 32 0.049% 99.840% ( 110, 170 ] 51 0.078% 99.918% ( 170, 250 ] 38 0.058% 99.976% ( 250, 380 ] 10 0.015% 99.991% ( 380, 580 ] 2 0.003% 99.994% ( 1300, 1900 ] 2 0.003% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 323797 Average: 2.8425 StdDev: 31.14 Min: 0 Median: 1.1166 Max: 3613 Percentiles: P50: 1.12 P75: 1.74 P99: 5.74 P99.9: 280.50 P99.99: 1214.73 ------------------------------------------------------ [ 0, 1 ] 146712 45.310% 45.310% ######### ( 1, 2 ] 130209 40.213% 85.523% ######## ( 2, 3 ] 25817 7.973% 93.496% ## ( 3, 4 ] 12076 3.729% 97.226% # ( 4, 6 ] 6600 2.038% 99.264% ( 6, 10 ] 1092 0.337% 99.601% ( 10, 15 ] 83 0.026% 99.627% ( 15, 22 ] 19 0.006% 99.633% ( 22, 34 ] 4 0.001% 99.634% ( 34, 51 ] 159 0.049% 99.683% ( 51, 76 ] 42 0.013% 99.696% ( 76, 110 ] 50 0.015% 99.712% ( 110, 170 ] 281 0.087% 99.798% ( 170, 250 ] 279 0.086% 99.884% ( 250, 380 ] 214 0.066% 99.951% ( 380, 580 ] 94 0.029% 99.980% ( 580, 870 ] 24 0.007% 99.987% ( 870, 1300 ] 12 0.004% 99.991% ( 1300, 1900 ] 14 0.004% 99.995% ( 1900, 2900 ] 20 0.006% 100.001% ( 2900, 4400 ] 9 0.003% 100.004% ** Level 4 read latency histogram (micros): Count: 40 Average: 578.0500 StdDev: 999.11 Min: 1 Median: 34.0000 Max: 3206 Percentiles: P50: 34.00 P75: 380.00 P99: 3206.00 P99.9: 3206.00 P99.99: 3206.00 ------------------------------------------------------ [ 0, 1 ] 11 27.500% 27.500% ###### ( 1, 2 ] 5 12.500% 40.000% ### ( 2, 3 ] 2 5.000% 45.000% # ( 6, 10 ] 1 2.500% 47.500% # ( 22, 34 ] 1 2.500% 50.000% # ( 76, 110 ] 1 2.500% 52.500% # ( 110, 170 ] 5 12.500% 65.000% ### ( 170, 250 ] 1 2.500% 67.500% # ( 250, 380 ] 3 7.500% 75.000% ## ( 380, 580 ] 1 2.500% 77.500% # ( 580, 870 ] 1 2.500% 80.000% # ( 1300, 1900 ] 1 2.500% 82.500% # ( 1900, 2900 ] 4 10.000% 92.500% ## ( 2900, 4400 ] 3 7.500% 100.000% ## ** Level 5 read latency histogram (micros): Count: 40 Average: 426.8000 StdDev: 393.02 Min: 103 Median: 276.0000 Max: 1766 Percentiles: P50: 276.00 P75: 513.33 P99: 1766.00 P99.9: 1766.00 P99.99: 1766.00 ------------------------------------------------------ ( 76, 110 ] 1 2.500% 2.500% # ( 110, 170 ] 6 15.000% 17.500% ### ( 170, 250 ] 11 27.500% 45.000% ###### ( 250, 380 ] 10 25.000% 70.000% ##### ( 380, 580 ] 3 7.500% 77.500% ## ( 580, 870 ] 3 7.500% 85.000% ## ( 870, 1300 ] 4 10.000% 95.000% ## ( 1300, 1900 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 8.2 total, 2.8 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 361.64 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.035 H:M:S, 12.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 349.04 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.612 H:M:S, 21.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/19-10:38:42 ... thread 0: (1000000,4000000) ops and (428925.9,383674.2) ops/second in (2.331405,10.425512) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/4 2.02 GB 181.4 2.5 0.0 2.5 6.2 3.7 0.0 1.7 145.5 357.6 17.72 16.57 63 0.281 2618K 14K 0.0 0.0 L1 7/0 736.52 MB 73.7 1.8 1.6 0.2 1.8 1.6 0.1 1.1 293.6 287.9 6.37 6.10 3 2.122 1898K 36K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.8 2.6 262.2 261.6 0.61 0.59 1 0.613 163K 328 0.0 0.0 L3 18/0 961.47 MB 1.0 1.6 0.5 1.0 1.6 0.5 0.5 2.9 298.7 297.9 5.34 4.99 5 1.069 1621K 4247 0.0 0.0 L4 130/0 9.65 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 244.7 244.7 0.92 0.88 1 0.920 228K 0 0.0 0.0 L5 132/0 9.54 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 298/4 22.86 GB 0.0 6.3 2.4 3.9 9.9 6.0 3.0 2.7 207.6 327.7 30.96 29.12 73 0.424 6529K 55K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.3 2.4 3.9 9.9 6.0 3.0 2.7 207.6 327.7 30.96 29.12 73 0.424 6529K 55K 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.3 2.4 3.9 6.2 2.4 0.0 0.0 296.2 293.7 21.70 20.75 19 1.142 6529K 55K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 407.5 9.26 8.37 54 0.171 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): 10.5 total, 10.4 interval Flush(GB): cumulative 3.685, interval 3.685 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.91 GB write, 966.83 MB/s write, 6.28 GB read, 612.56 MB/s read, 31.0 seconds Interval compaction: 9.91 GB write, 973.00 MB/s write, 6.28 GB read, 616.47 MB/s read, 31.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 11, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1099335 Average: 2.1319 StdDev: 10.35 Min: 0 Median: 1.2783 Max: 1889 Percentiles: P50: 1.28 P75: 1.75 P99: 5.16 P99.9: 9.86 P99.99: 169.14 ------------------------------------------------------ [ 0, 1 ] 388556 35.345% 35.345% ####### ( 1, 2 ] 578975 52.666% 88.011% ########### ( 2, 3 ] 76811 6.987% 94.998% # ( 3, 4 ] 34839 3.169% 98.167% # ( 4, 6 ] 15835 1.440% 99.607% ( 6, 10 ] 3338 0.304% 99.911% ( 10, 15 ] 332 0.030% 99.941% ( 15, 22 ] 65 0.006% 99.947% ( 22, 34 ] 21 0.002% 99.949% ( 34, 51 ] 9 0.001% 99.950% ( 51, 76 ] 6 0.001% 99.950% ( 76, 110 ] 30 0.003% 99.953% ( 110, 170 ] 414 0.038% 99.991% ( 170, 250 ] 355 0.032% 100.023% ( 250, 380 ] 242 0.022% 100.045% ( 380, 580 ] 133 0.012% 100.057% ( 580, 870 ] 34 0.003% 100.060% ( 870, 1300 ] 13 0.001% 100.061% ( 1300, 1900 ] 4 0.000% 100.062% ** Level 1 read latency histogram (micros): Count: 158582 Average: 2.5922 StdDev: 14.42 Min: 1 Median: 1.4340 Max: 1890 Percentiles: P50: 1.43 P75: 1.91 P99: 6.51 P99.9: 186.67 P99.99: 514.28 ------------------------------------------------------ [ 0, 1 ] 43328 27.322% 27.322% ##### ( 1, 2 ] 82867 52.255% 79.577% ########## ( 2, 3 ] 15973 10.072% 89.650% ## ( 3, 4 ] 8986 5.666% 95.316% # ( 4, 6 ] 5679 3.581% 98.897% # ( 6, 10 ] 1275 0.804% 99.701% ( 10, 15 ] 178 0.112% 99.813% ( 15, 22 ] 20 0.013% 99.826% ( 22, 34 ] 5 0.003% 99.829% ( 34, 51 ] 3 0.002% 99.831% ( 51, 76 ] 1 0.001% 99.832% ( 76, 110 ] 3 0.002% 99.834% ( 110, 170 ] 90 0.057% 99.890% ( 170, 250 ] 74 0.047% 99.937% ( 250, 380 ] 64 0.040% 99.977% ( 380, 580 ] 30 0.019% 99.996% ( 580, 870 ] 9 0.006% 100.002% ( 870, 1300 ] 2 0.001% 100.003% ( 1300, 1900 ] 4 0.003% 100.006% ** Level 2 read latency histogram (micros): Count: 65640 Average: 2.3144 StdDev: 17.48 Min: 1 Median: 1.2114 Max: 2488 Percentiles: P50: 1.21 P75: 1.74 P99: 6.20 P99.9: 156.31 P99.99: 372.67 ------------------------------------------------------ [ 0, 1 ] 26273 40.026% 40.026% ######## ( 1, 2 ] 30971 47.183% 87.209% ######### ( 2, 3 ] 4074 6.207% 93.416% # ( 3, 4 ] 2097 3.195% 96.610% # ( 4, 6 ] 1546 2.355% 98.966% ( 6, 10 ] 451 0.687% 99.653% ( 10, 15 ] 49 0.075% 99.727% ( 15, 22 ] 9 0.014% 99.741% ( 22, 34 ] 4 0.006% 99.747% ( 34, 51 ] 25 0.038% 99.785% ( 51, 76 ] 4 0.006% 99.791% ( 76, 110 ] 32 0.049% 99.840% ( 110, 170 ] 51 0.078% 99.918% ( 170, 250 ] 38 0.058% 99.976% ( 250, 380 ] 10 0.015% 99.991% ( 380, 580 ] 2 0.003% 99.994% ( 1300, 1900 ] 2 0.003% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 323797 Average: 2.8425 StdDev: 31.14 Min: 0 Median: 1.1166 Max: 3613 Percentiles: P50: 1.12 P75: 1.74 P99: 5.74 P99.9: 280.50 P99.99: 1214.73 ------------------------------------------------------ [ 0, 1 ] 146712 45.310% 45.310% ######### ( 1, 2 ] 130209 40.213% 85.523% ######## ( 2, 3 ] 25817 7.973% 93.496% ## ( 3, 4 ] 12076 3.729% 97.226% # ( 4, 6 ] 6600 2.038% 99.264% ( 6, 10 ] 1092 0.337% 99.601% ( 10, 15 ] 83 0.026% 99.627% ( 15, 22 ] 19 0.006% 99.633% ( 22, 34 ] 4 0.001% 99.634% ( 34, 51 ] 159 0.049% 99.683% ( 51, 76 ] 42 0.013% 99.696% ( 76, 110 ] 50 0.015% 99.712% ( 110, 170 ] 281 0.087% 99.798% ( 170, 250 ] 279 0.086% 99.884% ( 250, 380 ] 214 0.066% 99.951% ( 380, 580 ] 94 0.029% 99.980% ( 580, 870 ] 24 0.007% 99.987% ( 870, 1300 ] 12 0.004% 99.991% ( 1300, 1900 ] 14 0.004% 99.995% ( 1900, 2900 ] 20 0.006% 100.001% ( 2900, 4400 ] 9 0.003% 100.004% ** Level 4 read latency histogram (micros): Count: 40 Average: 578.0500 StdDev: 999.11 Min: 1 Median: 34.0000 Max: 3206 Percentiles: P50: 34.00 P75: 380.00 P99: 3206.00 P99.9: 3206.00 P99.99: 3206.00 ------------------------------------------------------ [ 0, 1 ] 11 27.500% 27.500% ###### ( 1, 2 ] 5 12.500% 40.000% ### ( 2, 3 ] 2 5.000% 45.000% # ( 6, 10 ] 1 2.500% 47.500% # ( 22, 34 ] 1 2.500% 50.000% # ( 76, 110 ] 1 2.500% 52.500% # ( 110, 170 ] 5 12.500% 65.000% ### ( 170, 250 ] 1 2.500% 67.500% # ( 250, 380 ] 3 7.500% 75.000% ## ( 380, 580 ] 1 2.500% 77.500% # ( 580, 870 ] 1 2.500% 80.000% # ( 1300, 1900 ] 1 2.500% 82.500% # ( 1900, 2900 ] 4 10.000% 92.500% ## ( 2900, 4400 ] 3 7.500% 100.000% ## ** Level 5 read latency histogram (micros): Count: 60 Average: 420.6500 StdDev: 379.96 Min: 103 Median: 260.8333 Max: 1766 Percentiles: P50: 260.83 P75: 513.33 P99: 1766.00 P99.9: 1766.00 P99.99: 1766.00 ------------------------------------------------------ ( 76, 110 ] 3 5.000% 5.000% # ( 110, 170 ] 9 15.000% 20.000% ### ( 170, 250 ] 17 28.333% 48.333% ###### ( 250, 380 ] 12 20.000% 68.333% #### ( 380, 580 ] 6 10.000% 78.333% ## ( 580, 870 ] 3 5.000% 83.333% # ( 870, 1300 ] 7 11.667% 95.000% ## ( 1300, 1900 ] 3 5.000% 100.000% # ** DB Stats ** Uptime(secs): 10.5 total, 2.3 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 375.08 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.249 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, 422.13 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.214 H:M:S, 9.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/19-10:38:44 ... thread 0: (1000000,5000000) ops and (400741.2,386970.3) ops/second in (2.495376,12.920888) 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/15 3.06 GB 37.6 3.3 0.0 3.3 8.0 4.7 0.0 1.7 148.5 363.6 22.44 20.97 82 0.274 3384K 17K 0.0 0.0 L1 7/7 736.52 MB 0.0 1.8 1.6 0.2 1.8 1.6 0.1 1.1 293.6 287.9 6.37 6.10 3 2.122 1898K 36K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.8 2.6 262.2 261.6 0.61 0.59 1 0.613 163K 328 0.0 0.0 L3 18/0 961.47 MB 1.0 1.6 0.5 1.0 1.6 0.5 0.5 2.9 298.7 297.9 5.34 4.99 5 1.069 1621K 4247 0.0 0.0 L4 130/0 9.65 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 244.7 244.7 0.92 0.88 1 0.920 228K 0 0.0 0.0 L5 132/0 9.54 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 305/22 23.90 GB 0.0 7.0 2.4 4.6 11.7 7.1 3.0 2.5 201.3 335.4 35.68 33.53 92 0.388 7296K 59K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.0 2.4 4.6 11.7 7.1 3.0 2.5 201.3 335.4 35.68 33.53 92 0.388 7296K 59K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.0 2.4 4.6 7.0 2.4 0.0 0.0 296.6 294.1 24.22 23.20 22 1.101 7296K 59K 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 422.7 11.46 10.33 70 0.164 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): 13.0 total, 12.9 interval Flush(GB): cumulative 4.729, interval 4.729 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.69 GB write, 921.25 MB/s write, 7.02 GB read, 553.01 MB/s read, 35.7 seconds Interval compaction: 11.69 GB write, 926.00 MB/s write, 7.02 GB read, 555.86 MB/s read, 35.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 2, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 2, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 12, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 2, total-stops: 12, interval: 14 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1430490 Average: 2.0925 StdDev: 9.87 Min: 0 Median: 1.2561 Max: 1889 Percentiles: P50: 1.26 P75: 1.74 P99: 5.03 P99.9: 9.75 P99.99: 152.10 ------------------------------------------------------ [ 0, 1 ] 524994 36.700% 36.700% ####### ( 1, 2 ] 742958 51.937% 88.638% ########## ( 2, 3 ] 95991 6.710% 95.348% # ( 3, 4 ] 42502 2.971% 98.319% # ( 4, 6 ] 18935 1.324% 99.643% ( 6, 10 ] 3924 0.274% 99.917% ( 10, 15 ] 408 0.029% 99.946% ( 15, 22 ] 75 0.005% 99.951% ( 22, 34 ] 28 0.002% 99.953% ( 34, 51 ] 18 0.001% 99.954% ( 51, 76 ] 9 0.001% 99.955% ( 76, 110 ] 73 0.005% 99.960% ( 110, 170 ] 617 0.043% 100.003% ( 170, 250 ] 457 0.032% 100.035% ( 250, 380 ] 276 0.019% 100.054% ( 380, 580 ] 143 0.010% 100.064% ( 580, 870 ] 40 0.003% 100.067% ( 870, 1300 ] 16 0.001% 100.068% ( 1300, 1900 ] 5 0.000% 100.068% ** Level 1 read latency histogram (micros): Count: 158583 Average: 2.5935 StdDev: 14.43 Min: 1 Median: 1.4340 Max: 1890 Percentiles: P50: 1.43 P75: 1.91 P99: 6.52 P99.9: 187.51 P99.99: 514.28 ------------------------------------------------------ [ 0, 1 ] 43328 27.322% 27.322% ##### ( 1, 2 ] 82867 52.255% 79.577% ########## ( 2, 3 ] 15973 10.072% 89.649% ## ( 3, 4 ] 8986 5.666% 95.315% # ( 4, 6 ] 5679 3.581% 98.896% # ( 6, 10 ] 1275 0.804% 99.700% ( 10, 15 ] 178 0.112% 99.813% ( 15, 22 ] 20 0.013% 99.825% ( 22, 34 ] 5 0.003% 99.828% ( 34, 51 ] 3 0.002% 99.830% ( 51, 76 ] 1 0.001% 99.831% ( 76, 110 ] 3 0.002% 99.833% ( 110, 170 ] 90 0.057% 99.890% ( 170, 250 ] 75 0.047% 99.937% ( 250, 380 ] 64 0.040% 99.977% ( 380, 580 ] 30 0.019% 99.996% ( 580, 870 ] 9 0.006% 100.002% ( 870, 1300 ] 2 0.001% 100.003% ( 1300, 1900 ] 4 0.003% 100.006% ** Level 2 read latency histogram (micros): Count: 65640 Average: 2.3144 StdDev: 17.48 Min: 1 Median: 1.2114 Max: 2488 Percentiles: P50: 1.21 P75: 1.74 P99: 6.20 P99.9: 156.31 P99.99: 372.67 ------------------------------------------------------ [ 0, 1 ] 26273 40.026% 40.026% ######## ( 1, 2 ] 30971 47.183% 87.209% ######### ( 2, 3 ] 4074 6.207% 93.416% # ( 3, 4 ] 2097 3.195% 96.610% # ( 4, 6 ] 1546 2.355% 98.966% ( 6, 10 ] 451 0.687% 99.653% ( 10, 15 ] 49 0.075% 99.727% ( 15, 22 ] 9 0.014% 99.741% ( 22, 34 ] 4 0.006% 99.747% ( 34, 51 ] 25 0.038% 99.785% ( 51, 76 ] 4 0.006% 99.791% ( 76, 110 ] 32 0.049% 99.840% ( 110, 170 ] 51 0.078% 99.918% ( 170, 250 ] 38 0.058% 99.976% ( 250, 380 ] 10 0.015% 99.991% ( 380, 580 ] 2 0.003% 99.994% ( 1300, 1900 ] 2 0.003% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 323797 Average: 2.8425 StdDev: 31.14 Min: 0 Median: 1.1166 Max: 3613 Percentiles: P50: 1.12 P75: 1.74 P99: 5.74 P99.9: 280.50 P99.99: 1214.73 ------------------------------------------------------ [ 0, 1 ] 146712 45.310% 45.310% ######### ( 1, 2 ] 130209 40.213% 85.523% ######## ( 2, 3 ] 25817 7.973% 93.496% ## ( 3, 4 ] 12076 3.729% 97.226% # ( 4, 6 ] 6600 2.038% 99.264% ( 6, 10 ] 1092 0.337% 99.601% ( 10, 15 ] 83 0.026% 99.627% ( 15, 22 ] 19 0.006% 99.633% ( 22, 34 ] 4 0.001% 99.634% ( 34, 51 ] 159 0.049% 99.683% ( 51, 76 ] 42 0.013% 99.696% ( 76, 110 ] 50 0.015% 99.712% ( 110, 170 ] 281 0.087% 99.798% ( 170, 250 ] 279 0.086% 99.884% ( 250, 380 ] 214 0.066% 99.951% ( 380, 580 ] 94 0.029% 99.980% ( 580, 870 ] 24 0.007% 99.987% ( 870, 1300 ] 12 0.004% 99.991% ( 1300, 1900 ] 14 0.004% 99.995% ( 1900, 2900 ] 20 0.006% 100.001% ( 2900, 4400 ] 9 0.003% 100.004% ** Level 4 read latency histogram (micros): Count: 40 Average: 578.0500 StdDev: 999.11 Min: 1 Median: 34.0000 Max: 3206 Percentiles: P50: 34.00 P75: 380.00 P99: 3206.00 P99.9: 3206.00 P99.99: 3206.00 ------------------------------------------------------ [ 0, 1 ] 11 27.500% 27.500% ###### ( 1, 2 ] 5 12.500% 40.000% ### ( 2, 3 ] 2 5.000% 45.000% # ( 6, 10 ] 1 2.500% 47.500% # ( 22, 34 ] 1 2.500% 50.000% # ( 76, 110 ] 1 2.500% 52.500% # ( 110, 170 ] 5 12.500% 65.000% ### ( 170, 250 ] 1 2.500% 67.500% # ( 250, 380 ] 3 7.500% 75.000% ## ( 380, 580 ] 1 2.500% 77.500% # ( 580, 870 ] 1 2.500% 80.000% # ( 1300, 1900 ] 1 2.500% 82.500% # ( 1900, 2900 ] 4 10.000% 92.500% ## ( 2900, 4400 ] 3 7.500% 100.000% ## ** Level 5 read latency histogram (micros): Count: 60 Average: 420.6500 StdDev: 379.96 Min: 103 Median: 260.8333 Max: 1766 Percentiles: P50: 260.83 P75: 513.33 P99: 1766.00 P99.9: 1766.00 P99.99: 1766.00 ------------------------------------------------------ ( 76, 110 ] 3 5.000% 5.000% # ( 110, 170 ] 9 15.000% 20.000% ### ( 170, 250 ] 17 28.333% 48.333% ###### ( 250, 380 ] 12 20.000% 68.333% #### ( 380, 580 ] 6 10.000% 78.333% ## ( 580, 870 ] 3 5.000% 83.333% # ( 870, 1300 ] 7 11.667% 95.000% ## ( 1300, 1900 ] 3 5.000% 100.000% # ** DB Stats ** Uptime(secs): 13.0 total, 2.5 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 378.79 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.566 H:M:S, 12.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 394.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.317 H:M:S, 12.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-10:38:48 ... thread 0: (1000000,6000000) ops and (237122.0,350096.6) ops/second in (4.217239,17.138127) 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/18 3.97 GB 0.0 4.5 0.0 4.5 10.1 5.6 0.0 1.8 162.3 366.0 28.29 26.54 102 0.277 4662K 23K 0.0 0.0 L1 7/7 736.52 MB 0.0 1.8 1.6 0.2 1.8 1.6 0.1 1.1 293.6 287.9 6.37 6.10 3 2.122 1898K 36K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.8 2.6 262.2 261.6 0.61 0.59 1 0.613 163K 328 0.0 0.0 L3 18/0 961.47 MB 1.0 1.6 0.5 1.0 1.6 0.5 0.5 2.9 298.7 297.9 5.34 4.99 5 1.069 1621K 4247 0.0 0.0 L4 130/0 9.65 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 244.7 244.7 0.92 0.88 1 0.920 228K 0 0.0 0.0 L5 132/0 9.54 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 305/25 24.81 GB 0.0 8.2 2.4 5.8 13.8 8.0 3.0 2.4 203.3 341.1 41.53 39.10 112 0.371 8573K 65K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.2 2.4 5.8 13.8 8.0 3.0 2.4 203.3 341.1 41.53 39.10 112 0.371 8573K 65K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 8.2 2.4 5.8 8.2 2.3 0.0 0.0 300.7 298.4 28.07 26.97 27 1.040 8573K 65K 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 430.0 13.46 12.13 85 0.158 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): 17.2 total, 17.1 interval Flush(GB): cumulative 5.651, interval 5.651 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 13.83 GB write, 823.07 MB/s write, 8.24 GB read, 490.60 MB/s read, 41.5 seconds Interval compaction: 13.83 GB write, 826.27 MB/s write, 8.24 GB read, 492.51 MB/s read, 41.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 12, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 10, total-stops: 12, interval: 22 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1995903 Average: 2.1237 StdDev: 10.29 Min: 0 Median: 1.2194 Max: 1889 Percentiles: P50: 1.22 P75: 1.71 P99: 4.97 P99.9: 41.55 P99.99: 179.17 ------------------------------------------------------ [ 0, 1 ] 776291 38.894% 38.894% ######## ( 1, 2 ] 1010221 50.615% 89.509% ########## ( 2, 3 ] 122912 6.158% 95.667% # ( 3, 4 ] 54558 2.733% 98.401% # ( 4, 6 ] 24620 1.234% 99.634% ( 6, 10 ] 4591 0.230% 99.864% ( 10, 15 ] 564 0.028% 99.892% ( 15, 22 ] 107 0.005% 99.898% ( 22, 34 ] 33 0.002% 99.899% ( 34, 51 ] 25 0.001% 99.901% ( 51, 76 ] 11 0.001% 99.901% ( 76, 110 ] 258 0.013% 99.914% ( 110, 170 ] 1410 0.071% 99.985% ( 170, 250 ] 902 0.045% 100.030% ( 250, 380 ] 418 0.021% 100.051% ( 380, 580 ] 190 0.010% 100.061% ( 580, 870 ] 52 0.003% 100.063% ( 870, 1300 ] 18 0.001% 100.064% ( 1300, 1900 ] 7 0.000% 100.064% ** Level 1 read latency histogram (micros): Count: 220677 Average: 2.4288 StdDev: 13.20 Min: 1 Median: 1.2960 Max: 1890 Percentiles: P50: 1.30 P75: 1.82 P99: 5.93 P99.9: 183.13 P99.99: 482.62 ------------------------------------------------------ [ 0, 1 ] 79189 35.885% 35.885% ####### ( 1, 2 ] 105248 47.693% 83.578% ########## ( 2, 3 ] 17962 8.139% 91.717% ## ( 3, 4 ] 9910 4.491% 96.208% # ( 4, 6 ] 6387 2.894% 99.102% # ( 6, 10 ] 1311 0.594% 99.696% ( 10, 15 ] 179 0.081% 99.778% ( 15, 22 ] 21 0.010% 99.787% ( 22, 34 ] 5 0.002% 99.789% ( 34, 51 ] 4 0.002% 99.791% ( 51, 76 ] 2 0.001% 99.792% ( 76, 110 ] 43 0.019% 99.811% ( 110, 170 ] 173 0.078% 99.890% ( 170, 250 ] 136 0.062% 99.952% ( 250, 380 ] 68 0.031% 99.982% ( 380, 580 ] 33 0.015% 99.997% ( 580, 870 ] 9 0.004% 100.001% ( 870, 1300 ] 2 0.001% 100.002% ( 1300, 1900 ] 4 0.002% 100.004% ** Level 2 read latency histogram (micros): Count: 65640 Average: 2.3144 StdDev: 17.48 Min: 1 Median: 1.2114 Max: 2488 Percentiles: P50: 1.21 P75: 1.74 P99: 6.20 P99.9: 156.31 P99.99: 372.67 ------------------------------------------------------ [ 0, 1 ] 26273 40.026% 40.026% ######## ( 1, 2 ] 30971 47.183% 87.209% ######### ( 2, 3 ] 4074 6.207% 93.416% # ( 3, 4 ] 2097 3.195% 96.610% # ( 4, 6 ] 1546 2.355% 98.966% ( 6, 10 ] 451 0.687% 99.653% ( 10, 15 ] 49 0.075% 99.727% ( 15, 22 ] 9 0.014% 99.741% ( 22, 34 ] 4 0.006% 99.747% ( 34, 51 ] 25 0.038% 99.785% ( 51, 76 ] 4 0.006% 99.791% ( 76, 110 ] 32 0.049% 99.840% ( 110, 170 ] 51 0.078% 99.918% ( 170, 250 ] 38 0.058% 99.976% ( 250, 380 ] 10 0.015% 99.991% ( 380, 580 ] 2 0.003% 99.994% ( 1300, 1900 ] 2 0.003% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 323797 Average: 2.8425 StdDev: 31.14 Min: 0 Median: 1.1166 Max: 3613 Percentiles: P50: 1.12 P75: 1.74 P99: 5.74 P99.9: 280.50 P99.99: 1214.73 ------------------------------------------------------ [ 0, 1 ] 146712 45.310% 45.310% ######### ( 1, 2 ] 130209 40.213% 85.523% ######## ( 2, 3 ] 25817 7.973% 93.496% ## ( 3, 4 ] 12076 3.729% 97.226% # ( 4, 6 ] 6600 2.038% 99.264% ( 6, 10 ] 1092 0.337% 99.601% ( 10, 15 ] 83 0.026% 99.627% ( 15, 22 ] 19 0.006% 99.633% ( 22, 34 ] 4 0.001% 99.634% ( 34, 51 ] 159 0.049% 99.683% ( 51, 76 ] 42 0.013% 99.696% ( 76, 110 ] 50 0.015% 99.712% ( 110, 170 ] 281 0.087% 99.798% ( 170, 250 ] 279 0.086% 99.884% ( 250, 380 ] 214 0.066% 99.951% ( 380, 580 ] 94 0.029% 99.980% ( 580, 870 ] 24 0.007% 99.987% ( 870, 1300 ] 12 0.004% 99.991% ( 1300, 1900 ] 14 0.004% 99.995% ( 1900, 2900 ] 20 0.006% 100.001% ( 2900, 4400 ] 9 0.003% 100.004% ** Level 4 read latency histogram (micros): Count: 40 Average: 578.0500 StdDev: 999.11 Min: 1 Median: 34.0000 Max: 3206 Percentiles: P50: 34.00 P75: 380.00 P99: 3206.00 P99.9: 3206.00 P99.99: 3206.00 ------------------------------------------------------ [ 0, 1 ] 11 27.500% 27.500% ###### ( 1, 2 ] 5 12.500% 40.000% ### ( 2, 3 ] 2 5.000% 45.000% # ( 6, 10 ] 1 2.500% 47.500% # ( 22, 34 ] 1 2.500% 50.000% # ( 76, 110 ] 1 2.500% 52.500% # ( 110, 170 ] 5 12.500% 65.000% ### ( 170, 250 ] 1 2.500% 67.500% # ( 250, 380 ] 3 7.500% 75.000% ## ( 380, 580 ] 1 2.500% 77.500% # ( 580, 870 ] 1 2.500% 80.000% # ( 1300, 1900 ] 1 2.500% 82.500% # ( 1900, 2900 ] 4 10.000% 92.500% ## ( 2900, 4400 ] 3 7.500% 100.000% ## ** Level 5 read latency histogram (micros): Count: 60 Average: 420.6500 StdDev: 379.96 Min: 103 Median: 260.8333 Max: 1766 Percentiles: P50: 260.83 P75: 513.33 P99: 1766.00 P99.9: 1766.00 P99.99: 1766.00 ------------------------------------------------------ ( 76, 110 ] 3 5.000% 5.000% # ( 110, 170 ] 9 15.000% 20.000% ### ( 170, 250 ] 17 28.333% 48.333% ###### ( 250, 380 ] 12 20.000% 68.333% #### ( 380, 580 ] 6 10.000% 78.333% ## ( 580, 870 ] 3 5.000% 83.333% # ( 870, 1300 ] 7 11.667% 95.000% ## ( 1300, 1900 ] 3 5.000% 100.000% # ** DB Stats ** Uptime(secs): 17.2 total, 4.2 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 343.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:3.437 H:M:S, 20.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 233.37 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.871 H:M:S, 44.4 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: 20000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 19378.7 MB (estimated) FileSize: 19378.7 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 : 3.273 micros/op 305496 ops/sec 20.003 seconds 6110999 operations; 296.0 MB/s Microseconds per write: Count: 6110999 Average: 3.2733 StdDev: 207.59 Min: 0 Median: 1.4935 Max: 218627 Percentiles: P50: 1.49 P75: 2.19 P99: 7.53 P99.9: 99.92 P99.99: 1243.13 ------------------------------------------------------ [ 0, 1 ] 1778066 29.096% 29.096% ###### ( 1, 2 ] 2588592 42.360% 71.456% ######## ( 2, 3 ] 1121689 18.355% 89.811% #### ( 3, 4 ] 418371 6.846% 96.657% # ( 4, 6 ] 126888 2.076% 98.734% ( 6, 10 ] 42542 0.696% 99.430% ( 10, 15 ] 13477 0.221% 99.650% ( 15, 22 ] 7039 0.115% 99.765% ( 22, 34 ] 3458 0.057% 99.822% ( 34, 51 ] 550 0.009% 99.831% ( 51, 76 ] 1146 0.019% 99.850% ( 76, 110 ] 4364 0.071% 99.921% ( 110, 170 ] 548 0.009% 99.930% ( 170, 250 ] 134 0.002% 99.932% ( 250, 380 ] 66 0.001% 99.933% ( 380, 580 ] 10 0.000% 99.934% ( 580, 870 ] 9 0.000% 99.934% ( 870, 1300 ] 3963 0.065% 99.999% ( 1300, 1900 ] 5 0.000% 99.999% ( 1900, 2900 ] 71 0.001% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 6 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 : 253069 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 : 6110999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 6306550968 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 : 195 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 5839423 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 : 12224805645 rocksdb.compact.write.bytes COUNT : 11974859476 rocksdb.flush.write.bytes COUNT : 6265538705 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 : 18 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 : 94 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 : 6224896000 rocksdb.memtable.garbage.bytes.at.flush COUNT : 11486208 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 : 12276512994 rocksdb.non.last.level.read.count COUNT : 2966280 rocksdb.block.checksum.compute.count COUNT : 2965909 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.050266 P95 : 3.287595 P99 : 5.941020 P100 : 218625.000000 COUNT : 6110999 SUM : 17734195 rocksdb.compaction.times.micros P50 : 848846.153846 P95 : 3355000.000000 P99 : 4092369.000000 P100 : 4092369.000000 COUNT : 27 SUM : 28071400 rocksdb.compaction.times.cpu_micros P50 : 848846.153846 P95 : 2550000.000000 P99 : 3871708.000000 P100 : 3871708.000000 COUNT : 27 SUM : 26967187 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 : 535.555556 P95 : 1178.166667 P99 : 1372.000000 P100 : 1456.000000 COUNT : 88 SUM : 52966 rocksdb.compaction.outfile.sync.micros P50 : 577.872340 P95 : 1227.681818 P99 : 1501.000000 P100 : 1501.000000 COUNT : 97 SUM : 62614 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 : 102.444444 P95 : 268.200000 P99 : 528.000000 P100 : 590.000000 COUNT : 126 SUM : 16122 rocksdb.table.open.io.micros P50 : 799.653465 P95 : 9405.000000 P99 : 12906.000000 P100 : 12906.000000 COUNT : 195 SUM : 339470 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 : 2.536932 P95 : 5.152852 P99 : 9.011030 P100 : 1759.000000 COUNT : 2966571 SUM : 11764905 rocksdb.read.block.get.micros P50 : 386.315789 P95 : 2275.000000 P99 : 3564.285714 P100 : 3812.000000 COUNT : 390 SUM : 228504 rocksdb.write.raw.block.micros P50 : 0.509867 P95 : 0.968747 P99 : 2.116903 P100 : 3159.000000 COUNT : 4421166 SUM : 6252940 rocksdb.numfiles.in.singlecompaction P50 : 3.460000 P95 : 10.250000 P99 : 18.000000 P100 : 18.000000 COUNT : 39 SUM : 178 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.609008 P95 : 1127.002773 P99 : 1272.511218 P100 : 218421.000000 COUNT : 33560 SUM : 5847862 rocksdb.sst.read.micros P50 : 1.201369 P95 : 3.079842 P99 : 5.639387 P100 : 3613.000000 COUNT : 2968288 SUM : 7784398 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 : 6110999 SUM : 6306550968 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 : 144285.714286 P95 : 308500.000000 P99 : 324915.000000 P100 : 324915.000000 COUNT : 88 SUM : 13866690 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 : 120 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