[2024-12-05 11:59:54.966537] Starting SPDK v25.01-pre git sha1 3a4e432ea / DPDK 24.03.0 initialization... [2024-12-05 11:59:54.966855] [ 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_pid1937454 ] Set seed to 1733396394959328 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-05 11:59:55.173299] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-05 11:59:55.315415] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-05 11:59:55.315478] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1937454' to capture a snapshot of events at runtime. [2024-12-05 11:59:55.315497] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-05 11:59:55.315516] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-05 11:59:55.315531] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1937454 for offline analysis/debug. [2024-12-05 11:59:55.317279] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Thu Dec 5 12:00:02 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/12/05-12:00:06 ... thread 0: (1000000,1000000) ops and (258061.8,258061.8) ops/second in (3.875041,3.875041) 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 7/5 440.40 MB 12.6 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 309.3 2.85 2.51 14 0.203 0 0 0.0 0.0 L1 4/0 374.37 MB 37.4 0.6 0.4 0.2 0.5 0.4 0.1 1.5 246.9 245.6 2.29 2.21 2 1.145 574K 3045 0.0 0.0 L2 1/1 100.17 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.0 2.6 241.0 240.5 0.67 0.63 1 0.668 163K 305 0.0 0.0 L3 17/10 753.32 MB 0.1 0.1 0.1 0.0 0.1 0.1 0.0 1.0 189.0 189.0 0.32 0.27 1 0.320 61K 0 0.0 0.0 L4 140/0 9.66 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 132/0 8.80 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 301/16 20.08 GB 0.0 0.8 0.5 0.3 1.6 1.3 0.1 1.9 128.5 271.7 6.13 5.62 18 0.340 799K 3350 0.0 0.0 Int 0/0 0.00 KB 0.0 0.8 0.5 0.3 1.6 1.3 0.1 1.9 128.5 271.7 6.13 5.62 18 0.340 799K 3350 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.8 0.5 0.3 0.8 0.5 0.0 0.0 240.0 239.0 3.28 3.11 4 0.819 799K 3350 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 309.3 2.85 2.51 14 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): 4.0 total, 3.9 interval Flush(GB): cumulative 0.860, interval 0.860 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.63 GB write, 419.27 MB/s write, 0.77 GB read, 198.23 MB/s read, 6.1 seconds Interval compaction: 1.63 GB write, 429.25 MB/s write, 0.77 GB read, 202.94 MB/s read, 6.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 158536 Average: 2.1500 StdDev: 15.31 Min: 1 Median: 1.4324 Max: 3353 Percentiles: P50: 1.43 P75: 1.83 P99: 5.68 P99.9: 11.18 P99.99: 43.74 ------------------------------------------------------ [ 0, 1 ] 35985 22.698% 22.698% ##### ( 1, 2 ] 100102 63.141% 85.840% ############# ( 2, 3 ] 14025 8.847% 94.686% ## ( 3, 4 ] 4262 2.688% 97.375% # ( 4, 6 ] 3060 1.930% 99.305% ( 6, 10 ] 907 0.572% 99.877% ( 10, 15 ] 155 0.098% 99.975% ( 15, 22 ] 22 0.014% 99.989% ( 22, 34 ] 1 0.001% 99.989% ( 34, 51 ] 2 0.001% 99.991% ( 51, 76 ] 1 0.001% 99.991% ( 170, 250 ] 12 0.008% 99.999% ( 250, 380 ] 2 0.001% 100.000% ( 380, 580 ] 8 0.005% 100.005% ( 580, 870 ] 1 0.001% 100.006% ( 870, 1300 ] 1 0.001% 100.006% ( 1300, 1900 ] 1 0.001% 100.007% ( 2900, 4400 ] 3 0.002% 100.009% ** Level 1 read latency histogram (micros): Count: 47789 Average: 2.1622 StdDev: 13.34 Min: 0 Median: 1.4207 Max: 1911 Percentiles: P50: 1.42 P75: 1.81 P99: 5.49 P99.9: 11.12 P99.99: 644.12 ------------------------------------------------------ [ 0, 1 ] 11116 23.261% 23.261% ##### ( 1, 2 ] 30376 63.563% 86.823% ############# ( 2, 3 ] 3874 8.106% 94.930% ## ( 3, 4 ] 1301 2.722% 97.652% # ( 4, 6 ] 865 1.810% 99.462% ( 6, 10 ] 200 0.419% 99.881% ( 10, 15 ] 41 0.086% 99.967% ( 15, 22 ] 6 0.013% 99.979% ( 170, 250 ] 1 0.002% 99.981% ( 380, 580 ] 4 0.008% 99.990% ( 580, 870 ] 1 0.002% 99.992% ( 870, 1300 ] 3 0.006% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 40338 Average: 3.2729 StdDev: 63.80 Min: 1 Median: 1.4503 Max: 10398 Percentiles: P50: 1.45 P75: 1.89 P99: 9.00 P99.9: 201.35 P99.99: 1493.24 ------------------------------------------------------ [ 0, 1 ] 9807 24.312% 24.312% ##### ( 1, 2 ] 23011 57.045% 81.358% ########### ( 2, 3 ] 3892 9.648% 91.006% ## ( 3, 4 ] 1530 3.793% 94.799% # ( 4, 6 ] 1327 3.290% 98.089% # ( 6, 10 ] 490 1.215% 99.303% ( 10, 15 ] 123 0.305% 99.608% ( 15, 22 ] 13 0.032% 99.641% ( 22, 34 ] 2 0.005% 99.645% ( 34, 51 ] 1 0.002% 99.648% ( 51, 76 ] 56 0.139% 99.787% ( 76, 110 ] 16 0.040% 99.826% ( 110, 170 ] 23 0.057% 99.883% ( 170, 250 ] 17 0.042% 99.926% ( 250, 380 ] 12 0.030% 99.955% ( 380, 580 ] 7 0.017% 99.973% ( 580, 870 ] 3 0.007% 99.980% ( 870, 1300 ] 3 0.007% 99.988% ( 1300, 1900 ] 3 0.007% 99.995% ( 4400, 6600 ] 1 0.002% 99.998% ( 9900, 14000 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 33024 Average: 10.6118 StdDev: 214.00 Min: 1 Median: 2.2670 Max: 12377 Percentiles: P50: 2.27 P75: 2.86 P99: 16.43 P99.9: 1523.20 P99.99: 9809.28 ------------------------------------------------------ [ 0, 1 ] 81 0.245% 0.245% ( 1, 2 ] 12698 38.451% 38.696% ######## ( 2, 3 ] 13981 42.336% 81.032% ######## ( 3, 4 ] 2123 6.429% 87.461% # ( 4, 6 ] 2593 7.852% 95.312% ## ( 6, 10 ] 862 2.610% 97.923% # ( 10, 15 ] 337 1.020% 98.943% ( 15, 22 ] 92 0.279% 99.222% ( 22, 34 ] 11 0.033% 99.255% ( 34, 51 ] 1 0.003% 99.258% ( 51, 76 ] 1 0.003% 99.261% ( 76, 110 ] 47 0.142% 99.403% ( 110, 170 ] 99 0.300% 99.703% ( 170, 250 ] 21 0.064% 99.767% ( 250, 380 ] 10 0.030% 99.797% ( 380, 580 ] 19 0.058% 99.855% ( 580, 870 ] 2 0.006% 99.861% ( 870, 1300 ] 10 0.030% 99.891% ( 1300, 1900 ] 8 0.024% 99.915% ( 2900, 4400 ] 10 0.030% 99.945% ( 4400, 6600 ] 4 0.012% 99.958% ( 6600, 9900 ] 11 0.033% 99.991% ( 9900, 14000 ] 3 0.009% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 4681.3500 StdDev: 3484.67 Min: 917 Median: 4400.0000 Max: 10938 Percentiles: P50: 4400.00 P75: 7425.00 P99: 10938.00 P99.9: 10938.00 P99.99: 10938.00 ------------------------------------------------------ ( 870, 1300 ] 4 20.000% 20.000% #### ( 1300, 1900 ] 4 20.000% 40.000% #### ( 1900, 2900 ] 1 5.000% 45.000% # ( 2900, 4400 ] 1 5.000% 50.000% # ( 4400, 6600 ] 4 20.000% 70.000% #### ( 6600, 9900 ] 4 20.000% 90.000% #### ( 9900, 14000 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 4.0 total, 3.9 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 247.93 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00: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, 253.81 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: 2 num-running-flushes: 1 2024/12/05-12:00:09 ... thread 0: (1000000,2000000) ops and (250194.8,254067.4) ops/second in (3.996886,7.871927) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/12 1.41 GB 25.0 0.8 0.0 0.8 2.6 1.8 0.0 1.4 83.2 274.8 9.83 8.95 33 0.298 830K 4470 0.0 0.0 L1 1/1 14.83 MB 0.0 0.6 0.4 0.2 0.5 0.4 0.1 1.5 246.9 245.6 2.29 2.21 2 1.145 574K 3045 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 241.0 240.5 0.67 0.63 1 0.668 163K 305 0.0 0.0 L3 19/2 952.08 MB 0.8 1.3 0.5 0.8 1.3 0.5 0.0 2.5 196.1 195.6 6.70 6.20 5 1.340 1334K 3420 0.0 0.0 L4 140/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 136/0 9.10 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 309/15 21.06 GB 0.0 2.8 0.9 1.9 4.6 2.8 1.0 2.5 146.7 243.0 19.49 17.99 41 0.475 2902K 11K 0.0 0.0 Int 0/0 0.00 KB 0.0 2.8 0.9 1.9 4.6 2.8 1.0 2.5 146.7 243.0 19.49 17.99 41 0.475 2902K 11K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 2.8 0.9 1.9 2.8 0.9 0.0 0.0 221.2 220.3 12.92 12.25 11 1.175 2902K 11K 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 287.7 6.56 5.75 30 0.219 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.0 total, 7.9 interval Flush(GB): cumulative 1.843, interval 1.843 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 4.62 GB write, 594.32 MB/s write, 2.79 GB read, 358.82 MB/s read, 19.5 seconds Interval compaction: 4.62 GB write, 601.28 MB/s write, 2.79 GB read, 363.02 MB/s read, 19.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: 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: 437676 Average: 2.5513 StdDev: 14.09 Min: 1 Median: 1.6251 Max: 3580 Percentiles: P50: 1.63 P75: 2.12 P99: 6.31 P99.9: 13.65 P99.99: 190.70 ------------------------------------------------------ [ 0, 1 ] 51505 11.768% 11.768% ## ( 1, 2 ] 267670 61.157% 72.925% ############ ( 2, 3 ] 78936 18.035% 90.960% #### ( 3, 4 ] 18976 4.336% 95.296% # ( 4, 6 ] 15918 3.637% 98.933% # ( 6, 10 ] 3798 0.868% 99.801% ( 10, 15 ] 597 0.136% 99.937% ( 15, 22 ] 74 0.017% 99.954% ( 22, 34 ] 4 0.001% 99.955% ( 34, 51 ] 2 0.000% 99.955% ( 51, 76 ] 31 0.007% 99.962% ( 76, 110 ] 37 0.008% 99.971% ( 110, 170 ] 71 0.016% 99.987% ( 170, 250 ] 55 0.013% 100.000% ( 250, 380 ] 40 0.009% 100.009% ( 380, 580 ] 37 0.008% 100.017% ( 580, 870 ] 10 0.002% 100.019% ( 870, 1300 ] 12 0.003% 100.022% ( 1300, 1900 ] 3 0.001% 100.023% ( 2900, 4400 ] 4 0.001% 100.024% ** Level 1 read latency histogram (micros): Count: 139004 Average: 2.5688 StdDev: 9.00 Min: 0 Median: 1.6657 Max: 1911 Percentiles: P50: 1.67 P75: 2.28 P99: 7.57 P99.9: 14.06 P99.99: 21.54 ------------------------------------------------------ [ 0, 1 ] 14787 10.638% 10.638% ## ( 1, 2 ] 82192 59.129% 69.767% ############ ( 2, 3 ] 26120 18.791% 88.558% #### ( 3, 4 ] 7354 5.290% 93.848% # ( 4, 6 ] 6584 4.737% 98.585% # ( 6, 10 ] 1467 1.055% 99.640% ( 10, 15 ] 445 0.320% 99.960% ( 15, 22 ] 44 0.032% 99.992% ( 22, 34 ] 5 0.004% 99.996% ( 76, 110 ] 12 0.009% 100.004% ( 110, 170 ] 22 0.016% 100.020% ( 170, 250 ] 8 0.006% 100.026% ( 250, 380 ] 6 0.004% 100.030% ( 380, 580 ] 7 0.005% 100.035% ( 580, 870 ] 2 0.001% 100.037% ( 870, 1300 ] 3 0.002% 100.039% ( 1900, 2900 ] 1 0.001% 100.040% ** Level 2 read latency histogram (micros): Count: 65671 Average: 3.4233 StdDev: 50.84 Min: 1 Median: 1.7391 Max: 10398 Percentiles: P50: 1.74 P75: 2.50 P99: 9.43 P99.9: 204.01 P99.99: 1075.38 ------------------------------------------------------ [ 0, 1 ] 9820 14.953% 14.953% ### ( 1, 2 ] 31141 47.420% 62.373% ######### ( 2, 3 ] 16506 25.134% 87.507% ##### ( 3, 4 ] 3208 4.885% 92.392% # ( 4, 6 ] 3402 5.180% 97.573% # ( 6, 10 ] 1093 1.664% 99.237% ( 10, 15 ] 286 0.436% 99.673% ( 15, 22 ] 22 0.034% 99.706% ( 22, 34 ] 3 0.005% 99.711% ( 34, 51 ] 1 0.002% 99.712% ( 51, 76 ] 56 0.085% 99.797% ( 76, 110 ] 16 0.024% 99.822% ( 110, 170 ] 39 0.059% 99.881% ( 170, 250 ] 29 0.044% 99.925% ( 250, 380 ] 20 0.030% 99.956% ( 380, 580 ] 13 0.020% 99.976% ( 580, 870 ] 8 0.012% 99.988% ( 870, 1300 ] 3 0.005% 99.992% ( 1300, 1900 ] 3 0.005% 99.997% ( 4400, 6600 ] 1 0.002% 99.998% ( 9900, 14000 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 223094 Average: 4.8629 StdDev: 85.15 Min: 1 Median: 2.1424 Max: 12377 Percentiles: P50: 2.14 P75: 2.77 P99: 11.02 P99.9: 304.98 P99.99: 1061.54 ------------------------------------------------------ [ 0, 1 ] 2464 1.104% 1.104% ( 1, 2 ] 96401 43.211% 44.315% ######### ( 2, 3 ] 89031 39.907% 84.223% ######## ( 3, 4 ] 13334 5.977% 90.200% # ( 4, 6 ] 14544 6.519% 96.719% # ( 6, 10 ] 4792 2.148% 98.867% ( 10, 15 ] 1452 0.651% 99.518% ( 15, 22 ] 227 0.102% 99.619% ( 22, 34 ] 31 0.014% 99.633% ( 34, 51 ] 2 0.001% 99.634% ( 51, 76 ] 3 0.001% 99.636% ( 76, 110 ] 79 0.035% 99.671% ( 110, 170 ] 331 0.148% 99.819% ( 170, 250 ] 141 0.063% 99.883% ( 250, 380 ] 92 0.041% 99.924% ( 380, 580 ] 102 0.046% 99.970% ( 580, 870 ] 35 0.016% 99.985% ( 870, 1300 ] 24 0.011% 99.996% ( 1300, 1900 ] 15 0.007% 100.003% ( 1900, 2900 ] 1 0.000% 100.003% ( 2900, 4400 ] 11 0.005% 100.008% ( 4400, 6600 ] 4 0.002% 100.010% ( 6600, 9900 ] 11 0.005% 100.015% ( 9900, 14000 ] 3 0.001% 100.016% ** Level 4 read latency histogram (micros): Count: 20 Average: 4681.3500 StdDev: 3484.67 Min: 917 Median: 4400.0000 Max: 10938 Percentiles: P50: 4400.00 P75: 7425.00 P99: 10938.00 P99.9: 10938.00 P99.99: 10938.00 ------------------------------------------------------ ( 870, 1300 ] 4 20.000% 20.000% #### ( 1300, 1900 ] 4 20.000% 40.000% #### ( 1900, 2900 ] 1 5.000% 45.000% # ( 2900, 4400 ] 1 5.000% 50.000% # ( 4400, 6600 ] 4 20.000% 70.000% #### ( 6600, 9900 ] 4 20.000% 90.000% #### ( 9900, 14000 ] 2 10.000% 100.000% ## ** Level 5 read latency histogram (micros): Count: 20 Average: 1349.1500 StdDev: 1447.83 Min: 136 Median: 513.3333 Max: 4827 Percentiles: P50: 513.33 P75: 1900.00 P99: 4827.00 P99.9: 4827.00 P99.99: 4827.00 ------------------------------------------------------ ( 110, 170 ] 1 5.000% 5.000% # ( 170, 250 ] 1 5.000% 10.000% # ( 250, 380 ] 4 20.000% 30.000% #### ( 380, 580 ] 6 30.000% 60.000% ###### ( 580, 870 ] 1 5.000% 65.000% # ( 1300, 1900 ] 2 10.000% 75.000% ## ( 2900, 4400 ] 4 20.000% 95.000% #### ( 4400, 6600 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 8.0 total, 4.0 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 247.08 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.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, 246.24 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.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/12/05-12:00:13 ... thread 0: (1000000,3000000) ops and (253244.1,253792.4) ops/second in (3.948760,11.820687) 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/8 1.41 GB 18.9 1.5 0.0 1.5 4.3 2.8 0.0 1.6 94.5 264.2 16.63 15.23 51 0.326 1597K 8056 0.0 0.0 L1 5/5 490.34 MB 0.0 1.5 1.3 0.2 1.5 1.3 0.1 1.1 226.9 223.7 6.70 6.41 3 2.234 1544K 21K 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 241.0 240.5 0.67 0.63 1 0.668 163K 305 0.0 0.0 L3 18/0 940.68 MB 0.9 1.4 0.6 0.8 1.4 0.6 0.3 2.3 196.9 196.4 7.50 6.92 6 1.249 1499K 3924 0.0 0.0 L4 142/0 9.49 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 200.1 200.1 1.00 0.89 1 0.998 202K 0 0.0 0.0 L5 144/0 9.66 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 320/13 21.96 GB 0.0 4.8 2.2 2.6 7.5 4.9 2.5 2.7 151.7 237.8 32.50 30.08 62 0.524 5007K 34K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.8 2.2 2.6 7.5 4.9 2.5 2.7 151.7 237.8 32.50 30.08 62 0.524 5007K 34K 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.8 2.2 2.6 4.8 2.1 0.0 0.0 219.2 217.6 22.50 21.30 17 1.323 5007K 34K 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 283.1 10.00 8.77 45 0.222 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): 11.9 total, 11.8 interval Flush(GB): cumulative 2.765, interval 2.765 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.55 GB write, 648.55 MB/s write, 4.81 GB read, 413.80 MB/s read, 32.5 seconds Interval compaction: 7.55 GB write, 653.61 MB/s write, 4.81 GB read, 417.03 MB/s read, 32.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: 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: 802691 Average: 2.6168 StdDev: 14.04 Min: 1 Median: 1.6467 Max: 3580 Percentiles: P50: 1.65 P75: 2.17 P99: 6.82 P99.9: 14.14 P99.99: 159.63 ------------------------------------------------------ [ 0, 1 ] 83573 10.412% 10.412% ## ( 1, 2 ] 491379 61.216% 71.628% ############ ( 2, 3 ] 158946 19.802% 91.430% #### ( 3, 4 ] 32333 4.028% 95.458% # ( 4, 6 ] 26856 3.346% 98.804% # ( 6, 10 ] 7684 0.957% 99.761% ( 10, 15 ] 1351 0.168% 99.929% ( 15, 22 ] 155 0.019% 99.948% ( 22, 34 ] 9 0.001% 99.950% ( 34, 51 ] 7 0.001% 99.950% ( 51, 76 ] 38 0.005% 99.955% ( 76, 110 ] 89 0.011% 99.966% ( 110, 170 ] 233 0.029% 99.995% ( 170, 250 ] 102 0.013% 100.008% ( 250, 380 ] 94 0.012% 100.020% ( 380, 580 ] 77 0.010% 100.029% ( 580, 870 ] 23 0.003% 100.032% ( 870, 1300 ] 24 0.003% 100.035% ( 1300, 1900 ] 11 0.001% 100.037% ( 1900, 2900 ] 3 0.000% 100.037% ( 2900, 4400 ] 4 0.000% 100.037% ** Level 1 read latency histogram (micros): Count: 175518 Average: 2.6534 StdDev: 11.96 Min: 0 Median: 1.6624 Max: 1911 Percentiles: P50: 1.66 P75: 2.24 P99: 7.31 P99.9: 14.60 P99.99: 159.31 ------------------------------------------------------ [ 0, 1 ] 17125 9.757% 9.757% ## ( 1, 2 ] 106626 60.749% 70.506% ############ ( 2, 3 ] 33335 18.992% 89.499% #### ( 3, 4 ] 8703 4.958% 94.457% # ( 4, 6 ] 7413 4.223% 98.680% # ( 6, 10 ] 1713 0.976% 99.656% ( 10, 15 ] 465 0.265% 99.921% ( 15, 22 ] 46 0.026% 99.948% ( 22, 34 ] 5 0.003% 99.950% ( 76, 110 ] 30 0.017% 99.968% ( 110, 170 ] 48 0.027% 99.995% ( 170, 250 ] 18 0.010% 100.005% ( 250, 380 ] 11 0.006% 100.011% ( 380, 580 ] 19 0.011% 100.022% ( 580, 870 ] 5 0.003% 100.025% ( 870, 1300 ] 9 0.005% 100.030% ( 1300, 1900 ] 1 0.001% 100.031% ( 1900, 2900 ] 1 0.001% 100.031% ** Level 2 read latency histogram (micros): Count: 65671 Average: 3.4233 StdDev: 50.84 Min: 1 Median: 1.7391 Max: 10398 Percentiles: P50: 1.74 P75: 2.50 P99: 9.43 P99.9: 204.01 P99.99: 1075.38 ------------------------------------------------------ [ 0, 1 ] 9820 14.953% 14.953% ### ( 1, 2 ] 31141 47.420% 62.373% ######### ( 2, 3 ] 16506 25.134% 87.507% ##### ( 3, 4 ] 3208 4.885% 92.392% # ( 4, 6 ] 3402 5.180% 97.573% # ( 6, 10 ] 1093 1.664% 99.237% ( 10, 15 ] 286 0.436% 99.673% ( 15, 22 ] 22 0.034% 99.706% ( 22, 34 ] 3 0.005% 99.711% ( 34, 51 ] 1 0.002% 99.712% ( 51, 76 ] 56 0.085% 99.797% ( 76, 110 ] 16 0.024% 99.822% ( 110, 170 ] 39 0.059% 99.881% ( 170, 250 ] 29 0.044% 99.925% ( 250, 380 ] 20 0.030% 99.956% ( 380, 580 ] 13 0.020% 99.976% ( 580, 870 ] 8 0.012% 99.988% ( 870, 1300 ] 3 0.005% 99.992% ( 1300, 1900 ] 3 0.005% 99.997% ( 4400, 6600 ] 1 0.002% 99.998% ( 9900, 14000 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 260975 Average: 4.6349 StdDev: 79.02 Min: 0 Median: 2.0595 Max: 12377 Percentiles: P50: 2.06 P75: 2.73 P99: 10.48 P99.9: 288.05 P99.99: 1033.77 ------------------------------------------------------ [ 0, 1 ] 4542 1.740% 1.740% ( 1, 2 ] 120185 46.052% 47.793% ######### ( 2, 3 ] 96886 37.125% 84.917% ####### ( 3, 4 ] 15174 5.814% 90.732% # ( 4, 6 ] 15896 6.091% 96.823% # ( 6, 10 ] 5536 2.121% 98.944% ( 10, 15 ] 1529 0.586% 99.530% ( 15, 22 ] 243 0.093% 99.623% ( 22, 34 ] 31 0.012% 99.635% ( 34, 51 ] 2 0.001% 99.636% ( 51, 76 ] 4 0.002% 99.637% ( 76, 110 ] 107 0.041% 99.678% ( 110, 170 ] 384 0.147% 99.825% ( 170, 250 ] 164 0.063% 99.888% ( 250, 380 ] 106 0.041% 99.929% ( 380, 580 ] 111 0.043% 99.971% ( 580, 870 ] 39 0.015% 99.986% ( 870, 1300 ] 26 0.010% 99.996% ( 1300, 1900 ] 16 0.006% 100.002% ( 1900, 2900 ] 1 0.000% 100.003% ( 2900, 4400 ] 11 0.004% 100.007% ( 4400, 6600 ] 4 0.002% 100.008% ( 6600, 9900 ] 11 0.004% 100.013% ( 9900, 14000 ] 3 0.001% 100.014% ** Level 4 read latency histogram (micros): Count: 50 Average: 1956.6000 StdDev: 3137.18 Min: 1 Median: 315.0000 Max: 10938 Percentiles: P50: 315.00 P75: 1825.00 P99: 10938.00 P99.9: 10938.00 P99.99: 10938.00 ------------------------------------------------------ [ 0, 1 ] 7 14.000% 14.000% ### ( 1, 2 ] 9 18.000% 32.000% #### ( 2, 3 ] 2 4.000% 36.000% # ( 110, 170 ] 6 12.000% 48.000% ## ( 250, 380 ] 2 4.000% 52.000% # ( 380, 580 ] 1 2.000% 54.000% ( 580, 870 ] 2 4.000% 58.000% # ( 870, 1300 ] 5 10.000% 68.000% ## ( 1300, 1900 ] 4 8.000% 76.000% ## ( 1900, 2900 ] 1 2.000% 78.000% ( 2900, 4400 ] 1 2.000% 80.000% ( 4400, 6600 ] 4 8.000% 88.000% ## ( 6600, 9900 ] 4 8.000% 96.000% ## ( 9900, 14000 ] 2 4.000% 100.000% # ** Level 5 read latency histogram (micros): Count: 60 Average: 1197.6000 StdDev: 1330.33 Min: 86 Median: 525.4545 Max: 4827 Percentiles: P50: 525.45 P75: 1750.00 P99: 4827.00 P99.9: 4827.00 P99.99: 4827.00 ------------------------------------------------------ ( 76, 110 ] 3 5.000% 5.000% # ( 110, 170 ] 7 11.667% 16.667% ## ( 170, 250 ] 2 3.333% 20.000% # ( 250, 380 ] 10 16.667% 36.667% ### ( 380, 580 ] 11 18.333% 55.000% #### ( 580, 870 ] 4 6.667% 61.667% # ( 870, 1300 ] 5 8.333% 70.000% ## ( 1300, 1900 ] 4 6.667% 76.667% # ( 1900, 2900 ] 3 5.000% 81.667% # ( 2900, 4400 ] 10 16.667% 98.333% ### ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 11.9 total, 3.9 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 247.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.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, 249.24 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/05-12:00:17 ... thread 0: (1000000,4000000) ops and (254164.0,253885.2) ops/second in (3.934467,15.755154) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/12 2.39 GB 94.0 2.3 0.0 2.3 6.0 3.7 0.0 1.6 99.0 261.8 23.51 21.59 70 0.336 2363K 11K 0.0 0.0 L1 5/5 490.34 MB 0.0 1.5 1.3 0.2 1.5 1.3 0.1 1.1 226.9 223.7 6.70 6.41 3 2.234 1544K 21K 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 241.0 240.5 0.67 0.63 1 0.668 163K 305 0.0 0.0 L3 18/0 940.68 MB 0.9 1.4 0.6 0.8 1.4 0.6 0.3 2.3 196.9 196.4 7.50 6.92 6 1.249 1499K 3924 0.0 0.0 L4 142/0 9.49 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 200.1 200.1 1.00 0.89 1 0.998 202K 0 0.0 0.0 L5 144/0 9.66 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 327/17 22.94 GB 0.0 5.6 2.2 3.4 9.3 5.9 2.5 2.5 144.4 240.9 39.37 36.44 81 0.486 5773K 37K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.6 2.2 3.4 9.3 5.9 2.5 2.5 144.4 240.9 39.37 36.44 81 0.486 5773K 37K 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.6 2.2 3.4 5.5 2.1 0.0 0.0 220.9 219.4 25.74 24.47 20 1.287 5773K 37K 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 281.4 13.64 11.97 61 0.224 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.8 total, 15.8 interval Flush(GB): cumulative 3.748, interval 3.748 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.26 GB write, 598.46 MB/s write, 5.55 GB read, 358.71 MB/s read, 39.4 seconds Interval compaction: 9.26 GB write, 601.96 MB/s write, 5.55 GB read, 360.81 MB/s read, 39.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: 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: 1208119 Average: 2.6297 StdDev: 13.68 Min: 1 Median: 1.6634 Max: 3580 Percentiles: P50: 1.66 P75: 2.21 P99: 6.68 P99.9: 13.85 P99.99: 152.98 ------------------------------------------------------ [ 0, 1 ] 113287 9.377% 9.377% ## ( 1, 2 ] 739829 61.238% 70.615% ############ ( 2, 3 ] 255576 21.155% 91.770% #### ( 3, 4 ] 46907 3.883% 95.653% # ( 4, 6 ] 38504 3.187% 98.840% # ( 6, 10 ] 11403 0.944% 99.784% ( 10, 15 ] 1827 0.151% 99.935% ( 15, 22 ] 186 0.015% 99.950% ( 22, 34 ] 17 0.001% 99.952% ( 34, 51 ] 9 0.001% 99.952% ( 51, 76 ] 45 0.004% 99.956% ( 76, 110 ] 137 0.011% 99.968% ( 110, 170 ] 380 0.031% 99.999% ( 170, 250 ] 171 0.014% 100.013% ( 250, 380 ] 139 0.012% 100.025% ( 380, 580 ] 112 0.009% 100.034% ( 580, 870 ] 38 0.003% 100.037% ( 870, 1300 ] 32 0.003% 100.040% ( 1300, 1900 ] 17 0.001% 100.041% ( 1900, 2900 ] 5 0.000% 100.042% ( 2900, 4400 ] 5 0.000% 100.042% ** Level 1 read latency histogram (micros): Count: 225502 Average: 2.7516 StdDev: 12.43 Min: 0 Median: 1.6554 Max: 1911 Percentiles: P50: 1.66 P75: 2.20 P99: 7.82 P99.9: 110.99 P99.99: 265.46 ------------------------------------------------------ [ 0, 1 ] 21226 9.413% 9.413% ## ( 1, 2 ] 139648 61.928% 71.340% ############ ( 2, 3 ] 42277 18.748% 90.088% #### ( 3, 4 ] 10313 4.573% 94.662% # ( 4, 6 ] 8596 3.812% 98.474% # ( 6, 10 ] 2611 1.158% 99.631% ( 10, 15 ] 497 0.220% 99.852% ( 15, 22 ] 49 0.022% 99.874% ( 22, 34 ] 7 0.003% 99.877% ( 76, 110 ] 50 0.022% 99.899% ( 110, 170 ] 152 0.067% 99.966% ( 170, 250 ] 50 0.022% 99.988% ( 250, 380 ] 29 0.013% 100.001% ( 380, 580 ] 32 0.014% 100.016% ( 580, 870 ] 9 0.004% 100.020% ( 870, 1300 ] 9 0.004% 100.024% ( 1300, 1900 ] 1 0.000% 100.024% ( 1900, 2900 ] 1 0.000% 100.024% ** Level 2 read latency histogram (micros): Count: 65671 Average: 3.4233 StdDev: 50.84 Min: 1 Median: 1.7391 Max: 10398 Percentiles: P50: 1.74 P75: 2.50 P99: 9.43 P99.9: 204.01 P99.99: 1075.38 ------------------------------------------------------ [ 0, 1 ] 9820 14.953% 14.953% ### ( 1, 2 ] 31141 47.420% 62.373% ######### ( 2, 3 ] 16506 25.134% 87.507% ##### ( 3, 4 ] 3208 4.885% 92.392% # ( 4, 6 ] 3402 5.180% 97.573% # ( 6, 10 ] 1093 1.664% 99.237% ( 10, 15 ] 286 0.436% 99.673% ( 15, 22 ] 22 0.034% 99.706% ( 22, 34 ] 3 0.005% 99.711% ( 34, 51 ] 1 0.002% 99.712% ( 51, 76 ] 56 0.085% 99.797% ( 76, 110 ] 16 0.024% 99.822% ( 110, 170 ] 39 0.059% 99.881% ( 170, 250 ] 29 0.044% 99.925% ( 250, 380 ] 20 0.030% 99.956% ( 380, 580 ] 13 0.020% 99.976% ( 580, 870 ] 8 0.012% 99.988% ( 870, 1300 ] 3 0.005% 99.992% ( 1300, 1900 ] 3 0.005% 99.997% ( 4400, 6600 ] 1 0.002% 99.998% ( 9900, 14000 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 260975 Average: 4.6349 StdDev: 79.02 Min: 0 Median: 2.0595 Max: 12377 Percentiles: P50: 2.06 P75: 2.73 P99: 10.48 P99.9: 288.05 P99.99: 1033.77 ------------------------------------------------------ [ 0, 1 ] 4542 1.740% 1.740% ( 1, 2 ] 120185 46.052% 47.793% ######### ( 2, 3 ] 96886 37.125% 84.917% ####### ( 3, 4 ] 15174 5.814% 90.732% # ( 4, 6 ] 15896 6.091% 96.823% # ( 6, 10 ] 5536 2.121% 98.944% ( 10, 15 ] 1529 0.586% 99.530% ( 15, 22 ] 243 0.093% 99.623% ( 22, 34 ] 31 0.012% 99.635% ( 34, 51 ] 2 0.001% 99.636% ( 51, 76 ] 4 0.002% 99.637% ( 76, 110 ] 107 0.041% 99.678% ( 110, 170 ] 384 0.147% 99.825% ( 170, 250 ] 164 0.063% 99.888% ( 250, 380 ] 106 0.041% 99.929% ( 380, 580 ] 111 0.043% 99.971% ( 580, 870 ] 39 0.015% 99.986% ( 870, 1300 ] 26 0.010% 99.996% ( 1300, 1900 ] 16 0.006% 100.002% ( 1900, 2900 ] 1 0.000% 100.003% ( 2900, 4400 ] 11 0.004% 100.007% ( 4400, 6600 ] 4 0.002% 100.008% ( 6600, 9900 ] 11 0.004% 100.013% ( 9900, 14000 ] 3 0.001% 100.014% ** Level 4 read latency histogram (micros): Count: 50 Average: 1956.6000 StdDev: 3137.18 Min: 1 Median: 315.0000 Max: 10938 Percentiles: P50: 315.00 P75: 1825.00 P99: 10938.00 P99.9: 10938.00 P99.99: 10938.00 ------------------------------------------------------ [ 0, 1 ] 7 14.000% 14.000% ### ( 1, 2 ] 9 18.000% 32.000% #### ( 2, 3 ] 2 4.000% 36.000% # ( 110, 170 ] 6 12.000% 48.000% ## ( 250, 380 ] 2 4.000% 52.000% # ( 380, 580 ] 1 2.000% 54.000% ( 580, 870 ] 2 4.000% 58.000% # ( 870, 1300 ] 5 10.000% 68.000% ## ( 1300, 1900 ] 4 8.000% 76.000% ## ( 1900, 2900 ] 1 2.000% 78.000% ( 2900, 4400 ] 1 2.000% 80.000% ( 4400, 6600 ] 4 8.000% 88.000% ## ( 6600, 9900 ] 4 8.000% 96.000% ## ( 9900, 14000 ] 2 4.000% 100.000% # ** Level 5 read latency histogram (micros): Count: 60 Average: 1197.6000 StdDev: 1330.33 Min: 86 Median: 525.4545 Max: 4827 Percentiles: P50: 525.45 P75: 1750.00 P99: 4827.00 P99.9: 4827.00 P99.99: 4827.00 ------------------------------------------------------ ( 76, 110 ] 3 5.000% 5.000% # ( 110, 170 ] 7 11.667% 16.667% ## ( 170, 250 ] 2 3.333% 20.000% # ( 250, 380 ] 10 16.667% 36.667% ### ( 380, 580 ] 11 18.333% 55.000% #### ( 580, 870 ] 4 6.667% 61.667% # ( 870, 1300 ] 5 8.333% 70.000% ## ( 1300, 1900 ] 4 6.667% 76.667% # ( 1900, 2900 ] 3 5.000% 81.667% # ( 2900, 4400 ] 10 16.667% 98.333% ### ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 15.8 total, 3.9 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 248.38 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, 250.14 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: 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 : 4.065 micros/op 246007 ops/sec 20.003 seconds 4920999 operations; 238.4 MB/s Microseconds per write: Count: 4920999 Average: 4.0649 StdDev: 18.45 Min: 1 Median: 2.6731 Max: 27955 Percentiles: P50: 2.67 P75: 4.28 P99: 9.86 P99.9: 130.22 P99.99: 423.33 ------------------------------------------------------ [ 0, 1 ] 8943 0.182% 0.182% ( 1, 2 ] 1180304 23.985% 24.167% ##### ( 2, 3 ] 1888617 38.379% 62.546% ######## ( 3, 4 ] 480238 9.759% 72.304% ## ( 4, 6 ] 957800 19.464% 91.768% #### ( 6, 10 ] 368626 7.491% 99.259% # ( 10, 15 ] 23938 0.486% 99.745% ( 15, 22 ] 4773 0.097% 99.842% ( 22, 34 ] 1798 0.037% 99.879% ( 34, 51 ] 454 0.009% 99.888% ( 51, 76 ] 27 0.001% 99.889% ( 76, 110 ] 1 0.000% 99.889% ( 110, 170 ] 1659 0.034% 99.922% ( 170, 250 ] 3161 0.064% 99.987% ( 250, 380 ] 164 0.003% 99.990% ( 380, 580 ] 18 0.000% 99.990% ( 870, 1300 ] 429 0.009% 99.999% ( 1300, 1900 ] 2 0.000% 99.999% ( 1900, 2900 ] 46 0.001% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 121260 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 : 4920999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 5078470968 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 : 189 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 553319 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 : 9384944567 rocksdb.compact.write.bytes COUNT : 9258452547 rocksdb.flush.write.bytes COUNT : 4947687152 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 : 20 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 : 111 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 : 4914332672 rocksdb.memtable.garbage.bytes.at.flush COUNT : 7879680 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 : 9428176584 rocksdb.non.last.level.read.count COUNT : 2274588 rocksdb.block.checksum.compute.count COUNT : 2274230 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.914880 P95 : 6.047164 P99 : 9.601387 P100 : 2154.000000 COUNT : 4920999 SUM : 16721966 rocksdb.compaction.times.micros P50 : 1067777.777778 P95 : 5950000.000000 P99 : 8054799.000000 P100 : 8054799.000000 COUNT : 25 SUM : 38430047 rocksdb.compaction.times.cpu_micros P50 : 1047000.000000 P95 : 4125000.000000 P99 : 7529844.000000 P100 : 7529844.000000 COUNT : 25 SUM : 36396706 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 : 863.695652 P95 : 1725.000000 P99 : 1725.000000 P100 : 1725.000000 COUNT : 75 SUM : 71495 rocksdb.compaction.outfile.sync.micros P50 : 930.641026 P95 : 1736.666667 P99 : 2059.000000 P100 : 2059.000000 COUNT : 89 SUM : 86147 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 : 145.250000 P95 : 452.500000 P99 : 762.700000 P100 : 802.000000 COUNT : 111 SUM : 19193 rocksdb.table.open.io.micros P50 : 1655.263158 P95 : 21280.000000 P99 : 27214.000000 P100 : 27214.000000 COUNT : 189 SUM : 685863 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.960598 P95 : 7.765180 P99 : 12.441438 P100 : 17507.000000 COUNT : 2273849 SUM : 12005500 rocksdb.read.block.get.micros P50 : 656.315789 P95 : 6380.000000 P99 : 10900.400000 P100 : 12442.000000 COUNT : 378 SUM : 515934 rocksdb.write.raw.block.micros P50 : 0.519438 P95 : 0.986933 P99 : 3.938988 P100 : 7849.000000 COUNT : 3456856 SUM : 7706992 rocksdb.numfiles.in.singlecompaction P50 : 3.400000 P95 : 12.750000 P99 : 19.340000 P100 : 20.000000 COUNT : 38 SUM : 175 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.561271 P95 : 1122.159251 P99 : 1932.173913 P100 : 2142.000000 COUNT : 4452 SUM : 553876 rocksdb.sst.read.micros P50 : 1.711818 P95 : 4.241852 P99 : 8.414197 P100 : 12377.000000 COUNT : 2274879 SUM : 7354226 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 : 4920999 SUM : 5078470968 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 : 211126.760563 P95 : 249154.929577 P99 : 347500.000000 P100 : 363206.000000 COUNT : 75 SUM : 16852185 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 : 116 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