[2024-12-05 11:56:32.226370] Starting SPDK v25.01-pre git sha1 0f9fa3b10 / DPDK 24.03.0 initialization... [2024-12-05 11:56:32.226690] [ 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_pid4040816 ] Set seed to 1733396192219092 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-05 11:56:32.377273] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-05 11:56:32.478652] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-05 11:56:32.478712] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 4040816' to capture a snapshot of events at runtime. [2024-12-05 11:56:32.478726] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-05 11:56:32.478739] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-05 11:56:32.478749] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid4040816 for offline analysis/debug. [2024-12-05 11:56:32.480037] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Thu Dec 5 11:56:35 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/12/05-11:56:38 ... thread 0: (1000000,1000000) ops and (330432.5,330432.5) ops/second in (3.026337,3.026337) 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 629.11 MB 12.6 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 342.0 2.57 2.40 13 0.198 0 0 0.0 0.0 L1 3/3 188.07 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 254.8 254.2 0.74 0.72 1 0.740 191K 464 0.0 0.0 L2 1/1 100.49 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.0 2.6 250.9 250.4 0.64 0.62 1 0.641 163K 304 0.0 0.0 L3 17/10 878.87 MB 0.1 0.1 0.1 0.0 0.1 0.1 0.0 1.0 200.3 200.3 0.30 0.28 1 0.299 60K 0 0.0 0.0 L4 120/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 112/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 263/22 20.09 GB 0.0 0.4 0.3 0.1 1.3 1.2 0.1 1.5 96.2 303.0 4.25 4.02 16 0.266 415K 768 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.3 1.2 0.1 1.5 96.2 303.0 4.25 4.02 16 0.266 415K 768 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 243.6 243.1 1.68 1.62 3 0.560 415K 768 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 342.0 2.57 2.40 13 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.1 total, 3.0 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.26 GB write, 412.88 MB/s write, 0.40 GB read, 131.08 MB/s read, 4.3 seconds Interval compaction: 1.26 GB write, 425.67 MB/s write, 0.40 GB read, 135.14 MB/s read, 4.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 132020 Average: 2.0821 StdDev: 5.90 Min: 1 Median: 1.4058 Max: 1445 Percentiles: P50: 1.41 P75: 1.82 P99: 5.78 P99.9: 12.30 P99.99: 262.97 ------------------------------------------------------ [ 0, 1 ] 33951 25.717% 25.717% ##### ( 1, 2 ] 79007 59.845% 85.561% ############ ( 2, 3 ] 10636 8.056% 93.618% ## ( 3, 4 ] 4588 3.475% 97.093% # ( 4, 6 ] 2826 2.141% 99.233% ( 6, 10 ] 813 0.616% 99.849% ( 10, 15 ] 152 0.115% 99.964% ( 15, 22 ] 16 0.012% 99.977% ( 22, 34 ] 5 0.004% 99.980% ( 34, 51 ] 2 0.002% 99.982% ( 51, 76 ] 1 0.001% 99.983% ( 170, 250 ] 12 0.009% 99.992% ( 250, 380 ] 8 0.006% 99.998% ( 380, 580 ] 6 0.005% 100.002% ( 1300, 1900 ] 1 0.001% 100.003% ** Level 1 read latency histogram (micros): Count: 28843 Average: 2.1402 StdDev: 5.77 Min: 0 Median: 1.4612 Max: 806 Percentiles: P50: 1.46 P75: 1.87 P99: 5.67 P99.9: 9.75 P99.99: 265.04 ------------------------------------------------------ [ 0, 1 ] 6341 21.985% 21.985% #### ( 1, 2 ] 17519 60.739% 82.724% ############ ( 2, 3 ] 2860 9.916% 92.639% ## ( 3, 4 ] 1187 4.115% 96.755% # ( 4, 6 ] 778 2.697% 99.452% # ( 6, 10 ] 139 0.482% 99.934% ( 10, 15 ] 13 0.045% 99.979% ( 15, 22 ] 3 0.010% 99.990% ( 170, 250 ] 1 0.003% 99.993% ( 250, 380 ] 1 0.003% 99.997% ( 380, 580 ] 1 0.003% 100.000% ( 580, 870 ] 1 0.003% 100.003% ** Level 2 read latency histogram (micros): Count: 40184 Average: 2.7912 StdDev: 26.32 Min: 1 Median: 1.4653 Max: 4011 Percentiles: P50: 1.47 P75: 1.90 P99: 9.53 P99.9: 135.12 P99.99: 771.55 ------------------------------------------------------ [ 0, 1 ] 9395 23.380% 23.380% ##### ( 1, 2 ] 22988 57.207% 80.587% ########### ( 2, 3 ] 3915 9.743% 90.329% ## ( 3, 4 ] 1494 3.718% 94.047% # ( 4, 6 ] 1479 3.681% 97.728% # ( 6, 10 ] 579 1.441% 99.169% ( 10, 15 ] 163 0.406% 99.574% ( 15, 22 ] 22 0.055% 99.629% ( 22, 34 ] 4 0.010% 99.639% ( 34, 51 ] 49 0.122% 99.761% ( 51, 76 ] 14 0.035% 99.796% ( 76, 110 ] 28 0.070% 99.866% ( 110, 170 ] 33 0.082% 99.948% ( 170, 250 ] 11 0.027% 99.975% ( 250, 380 ] 2 0.005% 99.980% ( 380, 580 ] 2 0.005% 99.985% ( 580, 870 ] 3 0.007% 99.993% ( 870, 1300 ] 1 0.002% 99.995% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 31470 Average: 6.7914 StdDev: 111.01 Min: 1 Median: 1.7126 Max: 5176 Percentiles: P50: 1.71 P75: 2.44 P99: 12.75 P99.9: 1564.68 P99.99: 5176.00 ------------------------------------------------------ [ 0, 1 ] 1707 5.424% 5.424% # ( 1, 2 ] 19688 62.561% 67.985% ############# ( 2, 3 ] 4979 15.821% 83.807% ### ( 3, 4 ] 2235 7.102% 90.909% # ( 4, 6 ] 1741 5.532% 96.441% # ( 6, 10 ] 676 2.148% 98.589% ( 10, 15 ] 237 0.753% 99.342% ( 15, 22 ] 25 0.079% 99.422% ( 34, 51 ] 36 0.114% 99.536% ( 51, 76 ] 23 0.073% 99.609% ( 76, 110 ] 6 0.019% 99.628% ( 110, 170 ] 62 0.197% 99.825% ( 170, 250 ] 7 0.022% 99.847% ( 250, 380 ] 5 0.016% 99.863% ( 380, 580 ] 1 0.003% 99.867% ( 580, 870 ] 4 0.013% 99.879% ( 870, 1300 ] 4 0.013% 99.892% ( 1300, 1900 ] 8 0.025% 99.917% ( 1900, 2900 ] 8 0.025% 99.943% ( 2900, 4400 ] 14 0.044% 99.987% ( 4400, 6600 ] 5 0.016% 100.003% ** Level 4 read latency histogram (micros): Count: 20 Average: 2750.6000 StdDev: 1183.88 Min: 1259 Median: 2700.0000 Max: 5113 Percentiles: P50: 2700.00 P75: 3757.14 P99: 5113.00 P99.9: 5113.00 P99.99: 5113.00 ------------------------------------------------------ ( 870, 1300 ] 3 15.000% 15.000% ### ( 1300, 1900 ] 3 15.000% 30.000% ### ( 1900, 2900 ] 5 25.000% 55.000% ##### ( 2900, 4400 ] 7 35.000% 90.000% ####### ( 4400, 6600 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.1 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 315.20 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.204 H:M:S, 6.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.87 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.204 H:M:S, 6.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/05-11:56:41 ... thread 0: (1000000,2000000) ops and (338409.2,334373.3) ops/second in (2.955002,5.981339) 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/4 1.29 GB 106.5 1.0 0.0 1.0 2.8 1.8 0.0 1.5 108.5 304.5 9.28 8.80 32 0.290 1022K 4820 0.0 0.0 L1 1/0 49.70 MB 5.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 242.2 240.6 2.59 2.54 2 1.297 638K 4126 0.0 0.0 L2 1/1 100.49 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.4 2.6 250.9 250.4 0.64 0.62 1 0.641 163K 304 0.0 0.0 L3 20/10 1.23 GB 0.4 0.5 0.4 0.1 0.5 0.4 0.0 1.2 209.2 208.8 2.62 2.52 4 0.655 556K 1266 0.0 0.0 L4 120/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 112/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 263/15 21.00 GB 0.0 2.3 0.9 1.4 4.1 2.7 0.4 2.3 154.9 274.7 15.13 14.48 39 0.388 2379K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 2.3 0.9 1.4 4.1 2.7 0.4 2.3 154.9 274.7 15.13 14.48 39 0.388 2379K 10K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 2.3 0.9 1.4 2.3 0.9 0.0 0.0 236.5 235.4 9.91 9.65 11 0.901 2379K 10K 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 349.2 5.22 4.83 28 0.187 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 total, 6.0 interval Flush(GB): cumulative 1.782, interval 1.782 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.06 GB write, 684.09 MB/s write, 2.29 GB read, 385.64 MB/s read, 15.1 seconds Interval compaction: 4.06 GB write, 694.82 MB/s write, 2.29 GB read, 391.69 MB/s read, 15.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: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 402753 Average: 2.4500 StdDev: 6.43 Min: 1 Median: 1.6288 Max: 1458 Percentiles: P50: 1.63 P75: 2.14 P99: 6.29 P99.9: 12.99 P99.99: 29.34 ------------------------------------------------------ [ 0, 1 ] 46762 11.611% 11.611% ## ( 1, 2 ] 245890 61.052% 72.663% ############ ( 2, 3 ] 65303 16.214% 88.877% ### ( 3, 4 ] 23864 5.925% 94.802% # ( 4, 6 ] 16658 4.136% 98.938% # ( 6, 10 ] 3464 0.860% 99.798% ( 10, 15 ] 686 0.170% 99.969% ( 15, 22 ] 80 0.020% 99.989% ( 22, 34 ] 11 0.003% 99.991% ( 34, 51 ] 7 0.002% 99.993% ( 51, 76 ] 6 0.001% 99.995% ( 76, 110 ] 3 0.001% 99.995% ( 110, 170 ] 17 0.004% 100.000% ( 170, 250 ] 37 0.009% 100.009% ( 250, 380 ] 14 0.003% 100.012% ( 380, 580 ] 20 0.005% 100.017% ( 580, 870 ] 3 0.001% 100.018% ( 870, 1300 ] 4 0.001% 100.019% ( 1300, 1900 ] 2 0.000% 100.019% ** Level 1 read latency histogram (micros): Count: 145823 Average: 2.8392 StdDev: 8.13 Min: 0 Median: 1.7713 Max: 1043 Percentiles: P50: 1.77 P75: 2.55 P99: 8.48 P99.9: 19.60 P99.99: 226.59 ------------------------------------------------------ [ 0, 1 ] 8593 5.893% 5.893% # ( 1, 2 ] 83385 57.182% 63.075% ########### ( 2, 3 ] 31436 21.558% 84.633% #### ( 3, 4 ] 10591 7.263% 91.896% # ( 4, 6 ] 8946 6.135% 98.030% # ( 6, 10 ] 2280 1.564% 99.594% ( 10, 15 ] 412 0.283% 99.877% ( 15, 22 ] 52 0.036% 99.912% ( 22, 34 ] 7 0.005% 99.917% ( 34, 51 ] 4 0.003% 99.920% ( 51, 76 ] 2 0.001% 99.921% ( 76, 110 ] 4 0.003% 99.924% ( 110, 170 ] 66 0.045% 99.969% ( 170, 250 ] 43 0.029% 99.999% ( 250, 380 ] 12 0.008% 100.007% ( 380, 580 ] 10 0.007% 100.014% ( 580, 870 ] 4 0.003% 100.016% ( 870, 1300 ] 1 0.001% 100.017% ** Level 2 read latency histogram (micros): Count: 51614 Average: 3.0373 StdDev: 24.85 Min: 1 Median: 1.5119 Max: 4011 Percentiles: P50: 1.51 P75: 1.94 P99: 9.57 P99.9: 200.60 P99.99: 661.06 ------------------------------------------------------ [ 0, 1 ] 10273 19.904% 19.904% #### ( 1, 2 ] 30346 58.794% 78.698% ############ ( 2, 3 ] 5807 11.251% 89.948% ## ( 3, 4 ] 2101 4.071% 94.019% # ( 4, 6 ] 1847 3.578% 97.598% # ( 6, 10 ] 811 1.571% 99.169% ( 10, 15 ] 174 0.337% 99.506% ( 15, 22 ] 22 0.043% 99.549% ( 22, 34 ] 4 0.008% 99.556% ( 34, 51 ] 49 0.095% 99.651% ( 51, 76 ] 14 0.027% 99.678% ( 76, 110 ] 28 0.054% 99.733% ( 110, 170 ] 73 0.141% 99.874% ( 170, 250 ] 35 0.068% 99.942% ( 250, 380 ] 17 0.033% 99.975% ( 380, 580 ] 7 0.014% 99.988% ( 580, 870 ] 3 0.006% 99.994% ( 870, 1300 ] 1 0.002% 99.996% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 233837 Average: 3.4644 StdDev: 41.61 Min: 1 Median: 1.7362 Max: 5176 Percentiles: P50: 1.74 P75: 2.47 P99: 9.49 P99.9: 137.63 P99.99: 474.52 ------------------------------------------------------ [ 0, 1 ] 10940 4.678% 4.678% # ( 1, 2 ] 143957 61.563% 66.241% ############ ( 2, 3 ] 43490 18.598% 84.840% #### ( 3, 4 ] 16519 7.064% 91.904% # ( 4, 6 ] 12308 5.263% 97.168% # ( 6, 10 ] 4915 2.102% 99.270% ( 10, 15 ] 850 0.364% 99.633% ( 15, 22 ] 99 0.042% 99.675% ( 22, 34 ] 9 0.004% 99.679% ( 34, 51 ] 241 0.103% 99.782% ( 51, 76 ] 130 0.056% 99.838% ( 76, 110 ] 42 0.018% 99.856% ( 110, 170 ] 224 0.096% 99.952% ( 170, 250 ] 51 0.022% 99.973% ( 250, 380 ] 32 0.014% 99.987% ( 380, 580 ] 14 0.006% 99.993% ( 580, 870 ] 6 0.003% 99.996% ( 870, 1300 ] 4 0.002% 99.997% ( 1300, 1900 ] 10 0.004% 100.002% ( 1900, 2900 ] 8 0.003% 100.005% ( 2900, 4400 ] 14 0.006% 100.011% ( 4400, 6600 ] 5 0.002% 100.013% ** Level 4 read latency histogram (micros): Count: 20 Average: 2750.6000 StdDev: 1183.88 Min: 1259 Median: 2700.0000 Max: 5113 Percentiles: P50: 2700.00 P75: 3757.14 P99: 5113.00 P99.9: 5113.00 P99.99: 5113.00 ------------------------------------------------------ ( 870, 1300 ] 3 15.000% 15.000% ### ( 1300, 1900 ] 3 15.000% 30.000% ### ( 1900, 2900 ] 5 25.000% 55.000% ##### ( 2900, 4400 ] 7 35.000% 90.000% ####### ( 4400, 6600 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 6.1 total, 3.0 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 323.89 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.204 H:M:S, 3.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 333.09 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-11:56:44 ... thread 0: (1000000,3000000) ops and (330603.8,333107.3) ops/second in (3.024769,9.006108) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/15 2.26 GB 0.0 1.7 0.0 1.7 4.5 2.8 0.0 1.6 117.6 306.1 14.98 14.22 50 0.300 1788K 8483 0.0 0.0 L1 1/1 49.70 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 242.2 240.6 2.59 2.54 2 1.297 638K 4126 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 250.9 250.4 0.64 0.62 1 0.641 163K 304 0.0 0.0 L3 19/0 880.05 MB 0.9 1.4 0.5 0.9 1.4 0.5 0.0 2.7 233.5 232.8 6.28 6.03 5 1.257 1490K 3971 0.0 0.0 L4 126/0 9.76 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 225.8 225.8 0.99 0.95 1 0.993 227K 0 0.0 0.0 L5 116/0 9.04 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 277/16 21.98 GB 0.0 4.1 1.2 2.9 6.9 4.0 1.1 2.5 166.4 276.8 25.49 24.36 59 0.432 4308K 16K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.1 1.2 2.9 6.9 4.0 1.1 2.5 166.4 276.8 25.49 24.36 59 0.432 4308K 16K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.1 1.2 2.9 4.1 1.2 0.0 0.0 241.8 240.9 17.54 17.02 16 1.096 4308K 16K 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 356.1 7.95 7.34 43 0.185 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.1 total, 9.0 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.89 GB write, 775.20 MB/s write, 4.14 GB read, 466.06 MB/s read, 25.5 seconds Interval compaction: 6.89 GB write, 783.27 MB/s write, 4.14 GB read, 470.92 MB/s read, 25.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: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 626110 Average: 2.4110 StdDev: 7.19 Min: 1 Median: 1.5746 Max: 1458 Percentiles: P50: 1.57 P75: 1.97 P99: 6.10 P99.9: 14.31 P99.99: 168.47 ------------------------------------------------------ [ 0, 1 ] 85388 13.638% 13.638% ### ( 1, 2 ] 396195 63.279% 76.917% ############# ( 2, 3 ] 87895 14.038% 90.955% ### ( 3, 4 ] 30364 4.850% 95.805% # ( 4, 6 ] 19884 3.176% 98.980% # ( 6, 10 ] 4882 0.780% 99.760% ( 10, 15 ] 1018 0.163% 99.923% ( 15, 22 ] 104 0.017% 99.939% ( 22, 34 ] 21 0.003% 99.943% ( 34, 51 ] 8 0.001% 99.944% ( 51, 76 ] 8 0.001% 99.945% ( 76, 110 ] 29 0.005% 99.950% ( 110, 170 ] 259 0.041% 99.991% ( 170, 250 ] 71 0.011% 100.003% ( 250, 380 ] 32 0.005% 100.008% ( 380, 580 ] 28 0.004% 100.012% ( 580, 870 ] 8 0.001% 100.013% ( 870, 1300 ] 7 0.001% 100.015% ( 1300, 1900 ] 2 0.000% 100.015% ** Level 1 read latency histogram (micros): Count: 145824 Average: 2.8403 StdDev: 8.14 Min: 0 Median: 1.7713 Max: 1043 Percentiles: P50: 1.77 P75: 2.55 P99: 8.48 P99.9: 19.74 P99.99: 226.59 ------------------------------------------------------ [ 0, 1 ] 8593 5.893% 5.893% # ( 1, 2 ] 83385 57.182% 63.075% ########### ( 2, 3 ] 31436 21.557% 84.632% #### ( 3, 4 ] 10591 7.263% 91.895% # ( 4, 6 ] 8946 6.135% 98.030% # ( 6, 10 ] 2280 1.564% 99.593% ( 10, 15 ] 412 0.283% 99.876% ( 15, 22 ] 52 0.036% 99.912% ( 22, 34 ] 7 0.005% 99.916% ( 34, 51 ] 4 0.003% 99.919% ( 51, 76 ] 2 0.001% 99.920% ( 76, 110 ] 4 0.003% 99.923% ( 110, 170 ] 67 0.046% 99.969% ( 170, 250 ] 43 0.029% 99.999% ( 250, 380 ] 12 0.008% 100.007% ( 380, 580 ] 10 0.007% 100.014% ( 580, 870 ] 4 0.003% 100.016% ( 870, 1300 ] 1 0.001% 100.017% ** Level 2 read latency histogram (micros): Count: 65604 Average: 2.8651 StdDev: 22.05 Min: 1 Median: 1.5214 Max: 4011 Percentiles: P50: 1.52 P75: 1.93 P99: 9.18 P99.9: 169.50 P99.99: 563.99 ------------------------------------------------------ [ 0, 1 ] 11900 18.139% 18.139% #### ( 1, 2 ] 40085 61.101% 79.241% ############ ( 2, 3 ] 7488 11.414% 90.655% ## ( 3, 4 ] 2568 3.914% 94.569% # ( 4, 6 ] 2057 3.135% 97.704% # ( 6, 10 ] 1068 1.628% 99.332% ( 10, 15 ] 181 0.276% 99.608% ( 15, 22 ] 24 0.037% 99.645% ( 22, 34 ] 4 0.006% 99.651% ( 34, 51 ] 49 0.075% 99.726% ( 51, 76 ] 14 0.021% 99.747% ( 76, 110 ] 28 0.043% 99.790% ( 110, 170 ] 73 0.111% 99.901% ( 170, 250 ] 35 0.053% 99.954% ( 250, 380 ] 17 0.026% 99.980% ( 380, 580 ] 7 0.011% 99.991% ( 580, 870 ] 3 0.005% 99.995% ( 870, 1300 ] 1 0.002% 99.997% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 290832 Average: 3.3661 StdDev: 38.12 Min: 1 Median: 1.7192 Max: 5176 Percentiles: P50: 1.72 P75: 2.40 P99: 9.33 P99.9: 144.94 P99.99: 568.60 ------------------------------------------------------ [ 0, 1 ] 14336 4.929% 4.929% # ( 1, 2 ] 182265 62.670% 67.600% ############# ( 2, 3 ] 53931 18.544% 86.143% #### ( 3, 4 ] 18911 6.502% 92.646% # ( 4, 6 ] 13779 4.738% 97.383% # ( 6, 10 ] 5656 1.945% 99.328% ( 10, 15 ] 975 0.335% 99.663% ( 15, 22 ] 115 0.040% 99.703% ( 22, 34 ] 10 0.003% 99.706% ( 34, 51 ] 243 0.084% 99.790% ( 51, 76 ] 130 0.045% 99.835% ( 76, 110 ] 44 0.015% 99.850% ( 110, 170 ] 251 0.086% 99.936% ( 170, 250 ] 71 0.024% 99.960% ( 250, 380 ] 68 0.023% 99.984% ( 380, 580 ] 19 0.007% 99.990% ( 580, 870 ] 12 0.004% 99.994% ( 870, 1300 ] 9 0.003% 99.998% ( 1300, 1900 ] 10 0.003% 100.001% ( 1900, 2900 ] 9 0.003% 100.004% ( 2900, 4400 ] 14 0.005% 100.009% ( 4400, 6600 ] 5 0.002% 100.011% ** Level 4 read latency histogram (micros): Count: 50 Average: 1140.6000 StdDev: 1514.80 Min: 1 Median: 160.0000 Max: 5113 Percentiles: P50: 160.00 P75: 2200.00 P99: 5113.00 P99.9: 5113.00 P99.99: 5113.00 ------------------------------------------------------ [ 0, 1 ] 12 24.000% 24.000% ##### ( 1, 2 ] 6 12.000% 36.000% ## ( 10, 15 ] 1 2.000% 38.000% ( 34, 51 ] 1 2.000% 40.000% ( 110, 170 ] 6 12.000% 52.000% ## ( 170, 250 ] 2 4.000% 56.000% # ( 250, 380 ] 2 4.000% 60.000% # ( 870, 1300 ] 3 6.000% 66.000% # ( 1300, 1900 ] 3 6.000% 72.000% # ( 1900, 2900 ] 5 10.000% 82.000% ## ( 2900, 4400 ] 7 14.000% 96.000% ### ( 4400, 6600 ] 2 4.000% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 552.4000 StdDev: 589.89 Min: 110 Median: 315.0000 Max: 2067 Percentiles: P50: 315.00 P75: 870.00 P99: 2067.00 P99.9: 2067.00 P99.99: 2067.00 ------------------------------------------------------ ( 76, 110 ] 1 5.000% 5.000% # ( 110, 170 ] 7 35.000% 40.000% ####### ( 170, 250 ] 1 5.000% 45.000% # ( 250, 380 ] 2 10.000% 55.000% ## ( 380, 580 ] 3 15.000% 70.000% ### ( 580, 870 ] 1 5.000% 75.000% # ( 870, 1300 ] 3 15.000% 90.000% ### ( 1900, 2900 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 9.1 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 324.39 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.385 H:M:S, 4.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 325.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:0.181 H:M:S, 6.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/05-11:56:48 ... thread 0: (1000000,4000000) ops and (274219.2,316134.9) ops/second in (3.646718,12.652826) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/15 3.24 GB 100.2 2.7 0.0 2.7 6.4 3.7 0.0 1.7 127.5 303.6 21.71 20.67 70 0.310 2811K 13K 0.0 0.0 L1 1/1 49.70 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 242.2 240.6 2.59 2.54 2 1.297 638K 4126 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 250.9 250.4 0.64 0.62 1 0.641 163K 304 0.0 0.0 L3 19/0 880.05 MB 0.9 1.4 0.5 0.9 1.4 0.5 0.0 2.7 233.5 232.8 6.28 6.03 5 1.257 1490K 3971 0.0 0.0 L4 126/0 9.76 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 225.8 225.8 0.99 0.95 1 0.993 227K 0 0.0 0.0 L5 116/0 9.04 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 281/16 22.95 GB 0.0 5.1 1.2 3.9 8.9 5.0 1.1 2.4 162.9 281.3 32.22 30.81 79 0.408 5330K 21K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.1 1.2 3.9 8.9 5.0 1.1 2.4 162.9 281.3 32.22 30.81 79 0.408 5330K 21K 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.1 1.2 3.9 5.1 1.2 0.0 0.0 245.2 244.2 21.41 20.81 20 1.070 5330K 21K 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 354.8 10.82 10.01 59 0.183 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.7 total, 12.7 interval Flush(GB): cumulative 3.747, interval 3.747 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: 8.85 GB write, 710.97 MB/s write, 5.13 GB read, 411.71 MB/s read, 32.2 seconds Interval compaction: 8.85 GB write, 716.24 MB/s write, 5.13 GB read, 414.76 MB/s read, 32.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 6, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 6, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 6, total-stops: 5, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1084170 Average: 2.4296 StdDev: 7.53 Min: 0 Median: 1.5807 Max: 1704 Percentiles: P50: 1.58 P75: 1.97 P99: 6.46 P99.9: 14.24 P99.99: 155.72 ------------------------------------------------------ [ 0, 1 ] 133967 12.357% 12.357% ## ( 1, 2 ] 702757 64.820% 77.176% ############# ( 2, 3 ] 157608 14.537% 91.714% ### ( 3, 4 ] 47577 4.388% 96.102% # ( 4, 6 ] 30328 2.797% 98.899% # ( 6, 10 ] 9415 0.868% 99.768% ( 10, 15 ] 1695 0.156% 99.924% ( 15, 22 ] 156 0.014% 99.938% ( 22, 34 ] 31 0.003% 99.941% ( 34, 51 ] 8 0.001% 99.942% ( 51, 76 ] 13 0.001% 99.943% ( 76, 110 ] 56 0.005% 99.948% ( 110, 170 ] 594 0.055% 100.003% ( 170, 250 ] 123 0.011% 100.015% ( 250, 380 ] 54 0.005% 100.020% ( 380, 580 ] 45 0.004% 100.024% ( 580, 870 ] 15 0.001% 100.025% ( 870, 1300 ] 13 0.001% 100.026% ( 1300, 1900 ] 4 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 145824 Average: 2.8403 StdDev: 8.14 Min: 0 Median: 1.7713 Max: 1043 Percentiles: P50: 1.77 P75: 2.55 P99: 8.48 P99.9: 19.74 P99.99: 226.59 ------------------------------------------------------ [ 0, 1 ] 8593 5.893% 5.893% # ( 1, 2 ] 83385 57.182% 63.075% ########### ( 2, 3 ] 31436 21.557% 84.632% #### ( 3, 4 ] 10591 7.263% 91.895% # ( 4, 6 ] 8946 6.135% 98.030% # ( 6, 10 ] 2280 1.564% 99.593% ( 10, 15 ] 412 0.283% 99.876% ( 15, 22 ] 52 0.036% 99.912% ( 22, 34 ] 7 0.005% 99.916% ( 34, 51 ] 4 0.003% 99.919% ( 51, 76 ] 2 0.001% 99.920% ( 76, 110 ] 4 0.003% 99.923% ( 110, 170 ] 67 0.046% 99.969% ( 170, 250 ] 43 0.029% 99.999% ( 250, 380 ] 12 0.008% 100.007% ( 380, 580 ] 10 0.007% 100.014% ( 580, 870 ] 4 0.003% 100.016% ( 870, 1300 ] 1 0.001% 100.017% ** Level 2 read latency histogram (micros): Count: 65604 Average: 2.8651 StdDev: 22.05 Min: 1 Median: 1.5214 Max: 4011 Percentiles: P50: 1.52 P75: 1.93 P99: 9.18 P99.9: 169.50 P99.99: 563.99 ------------------------------------------------------ [ 0, 1 ] 11900 18.139% 18.139% #### ( 1, 2 ] 40085 61.101% 79.241% ############ ( 2, 3 ] 7488 11.414% 90.655% ## ( 3, 4 ] 2568 3.914% 94.569% # ( 4, 6 ] 2057 3.135% 97.704% # ( 6, 10 ] 1068 1.628% 99.332% ( 10, 15 ] 181 0.276% 99.608% ( 15, 22 ] 24 0.037% 99.645% ( 22, 34 ] 4 0.006% 99.651% ( 34, 51 ] 49 0.075% 99.726% ( 51, 76 ] 14 0.021% 99.747% ( 76, 110 ] 28 0.043% 99.790% ( 110, 170 ] 73 0.111% 99.901% ( 170, 250 ] 35 0.053% 99.954% ( 250, 380 ] 17 0.026% 99.980% ( 380, 580 ] 7 0.011% 99.991% ( 580, 870 ] 3 0.005% 99.995% ( 870, 1300 ] 1 0.002% 99.997% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 290832 Average: 3.3661 StdDev: 38.12 Min: 1 Median: 1.7192 Max: 5176 Percentiles: P50: 1.72 P75: 2.40 P99: 9.33 P99.9: 144.94 P99.99: 568.60 ------------------------------------------------------ [ 0, 1 ] 14336 4.929% 4.929% # ( 1, 2 ] 182265 62.670% 67.600% ############# ( 2, 3 ] 53931 18.544% 86.143% #### ( 3, 4 ] 18911 6.502% 92.646% # ( 4, 6 ] 13779 4.738% 97.383% # ( 6, 10 ] 5656 1.945% 99.328% ( 10, 15 ] 975 0.335% 99.663% ( 15, 22 ] 115 0.040% 99.703% ( 22, 34 ] 10 0.003% 99.706% ( 34, 51 ] 243 0.084% 99.790% ( 51, 76 ] 130 0.045% 99.835% ( 76, 110 ] 44 0.015% 99.850% ( 110, 170 ] 251 0.086% 99.936% ( 170, 250 ] 71 0.024% 99.960% ( 250, 380 ] 68 0.023% 99.984% ( 380, 580 ] 19 0.007% 99.990% ( 580, 870 ] 12 0.004% 99.994% ( 870, 1300 ] 9 0.003% 99.998% ( 1300, 1900 ] 10 0.003% 100.001% ( 1900, 2900 ] 9 0.003% 100.004% ( 2900, 4400 ] 14 0.005% 100.009% ( 4400, 6600 ] 5 0.002% 100.011% ** Level 4 read latency histogram (micros): Count: 50 Average: 1140.6000 StdDev: 1514.80 Min: 1 Median: 160.0000 Max: 5113 Percentiles: P50: 160.00 P75: 2200.00 P99: 5113.00 P99.9: 5113.00 P99.99: 5113.00 ------------------------------------------------------ [ 0, 1 ] 12 24.000% 24.000% ##### ( 1, 2 ] 6 12.000% 36.000% ## ( 10, 15 ] 1 2.000% 38.000% ( 34, 51 ] 1 2.000% 40.000% ( 110, 170 ] 6 12.000% 52.000% ## ( 170, 250 ] 2 4.000% 56.000% # ( 250, 380 ] 2 4.000% 60.000% # ( 870, 1300 ] 3 6.000% 66.000% # ( 1300, 1900 ] 3 6.000% 72.000% # ( 1900, 2900 ] 5 10.000% 82.000% ## ( 2900, 4400 ] 7 14.000% 96.000% ### ( 4400, 6600 ] 2 4.000% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 552.4000 StdDev: 589.89 Min: 110 Median: 315.0000 Max: 2067 Percentiles: P50: 315.00 P75: 870.00 P99: 2067.00 P99.9: 2067.00 P99.99: 2067.00 ------------------------------------------------------ ( 76, 110 ] 1 5.000% 5.000% # ( 110, 170 ] 7 35.000% 40.000% ####### ( 170, 250 ] 1 5.000% 45.000% # ( 250, 380 ] 2 10.000% 55.000% ## ( 380, 580 ] 3 15.000% 70.000% ### ( 580, 870 ] 1 5.000% 75.000% # ( 870, 1300 ] 3 15.000% 90.000% ### ( 1900, 2900 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 12.7 total, 3.6 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 308.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:1.185 H:M:S, 9.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 269.88 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.801 H:M:S, 22.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.169 micros/op 239855 ops/sec 20.004 seconds 4797999 operations; 232.4 MB/s Microseconds per write: Count: 4797999 Average: 4.1689 StdDev: 298.00 Min: 1 Median: 1.7934 Max: 587529 Percentiles: P50: 1.79 P75: 3.05 P99: 7.91 P99.9: 160.17 P99.99: 2506.39 ------------------------------------------------------ [ 0, 1 ] 581213 12.114% 12.114% ## ( 1, 2 ] 2290998 47.749% 59.863% ########## ( 2, 3 ] 691663 14.416% 74.278% ### ( 3, 4 ] 656069 13.674% 87.952% ### ( 4, 6 ] 504049 10.505% 98.458% ## ( 6, 10 ] 54407 1.134% 99.591% ( 10, 15 ] 7703 0.161% 99.752% ( 15, 22 ] 2410 0.050% 99.802% ( 22, 34 ] 771 0.016% 99.818% ( 34, 51 ] 140 0.003% 99.821% ( 51, 76 ] 24 0.001% 99.822% ( 76, 110 ] 6 0.000% 99.822% ( 110, 170 ] 4482 0.093% 99.915% ( 170, 250 ] 340 0.007% 99.922% ( 250, 380 ] 50 0.001% 99.923% ( 380, 580 ] 4 0.000% 99.924% ( 580, 870 ] 12 0.000% 99.924% ( 870, 1300 ] 2468 0.051% 99.975% ( 1300, 1900 ] 8 0.000% 99.975% ( 1900, 2900 ] 1158 0.024% 99.999% ( 2900, 4400 ] 12 0.000% 100.000% ( 4400, 6600 ] 5 0.000% 100.000% ( 6600, 9900 ] 1 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 50000, 75000 ] 1 0.000% 100.000% ( 170000, 250000 ] 2 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 200875 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 : 4797999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 4951534968 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 : 203 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 6073010 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 : 11415667575 rocksdb.compact.write.bytes COUNT : 11204742464 rocksdb.flush.write.bytes COUNT : 4815157191 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 : 30 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 : 89 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 : 4783330304 rocksdb.memtable.garbage.bytes.at.flush COUNT : 8262656 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 : 11368221531 rocksdb.non.last.level.read.count COUNT : 2745670 rocksdb.block.checksum.compute.count COUNT : 2768243 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.432241 P95 : 4.718269 P99 : 6.083881 P100 : 587527.000000 COUNT : 4797999 SUM : 17747488 rocksdb.compaction.times.micros P50 : 992222.222222 P95 : 3460000.000000 P99 : 9872866.000000 P100 : 9872866.000000 COUNT : 32 SUM : 42544322 rocksdb.compaction.times.cpu_micros P50 : 928000.000000 P95 : 3460000.000000 P99 : 8744000.000000 P100 : 9198783.000000 COUNT : 32 SUM : 38549228 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 : 554.358974 P95 : 1290.652174 P99 : 7590.000000 P100 : 8039.000000 COUNT : 70 SUM : 60365 rocksdb.compaction.outfile.sync.micros P50 : 733.055556 P95 : 4314.285714 P99 : 6556.000000 P100 : 9040.000000 COUNT : 108 SUM : 124779 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 : 95.000000 P95 : 325.111111 P99 : 3530.000000 P100 : 3892.000000 COUNT : 116 SUM : 21129 rocksdb.table.open.io.micros P50 : 866.282051 P95 : 11198.333333 P99 : 15741.000000 P100 : 15741.000000 COUNT : 202 SUM : 465753 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.788054 P95 : 8.336621 P99 : 13.044244 P100 : 11475.000000 COUNT : 2767897 SUM : 16568629 rocksdb.read.block.get.micros P50 : 405.333333 P95 : 3129.166667 P99 : 4818.000000 P100 : 5232.000000 COUNT : 405 SUM : 324295 rocksdb.write.raw.block.micros P50 : 0.516256 P95 : 0.980887 P99 : 3.328233 P100 : 10750.000000 COUNT : 3892930 SUM : 8359523 rocksdb.numfiles.in.singlecompaction P50 : 3.166667 P95 : 8.866667 P99 : 12.000000 P100 : 12.000000 COUNT : 57 SUM : 214 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.557091 P95 : 1192.168156 P99 : 2597.157712 P100 : 583933.000000 COUNT : 35548 SUM : 6074606 rocksdb.sst.read.micros P50 : 1.690208 P95 : 4.941697 P99 : 9.214458 P100 : 11470.000000 COUNT : 2746056 SUM : 10428928 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 : 4797999 SUM : 4951534968 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 : 196046.511628 P95 : 315000.000000 P99 : 657000.000000 P100 : 775626.000000 COUNT : 70 SUM : 13622315 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 : 127 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