[2024-11-19 09:31:22.699799] Starting SPDK v25.01-pre git sha1 d47eb51c9 / DPDK 24.03.0 initialization... [2024-11-19 09:31:22.700131] [ 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_pid1119345 ] Set seed to 1732005082692650 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-19 09:31:22.867426] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-19 09:31:22.980209] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-19 09:31:22.980262] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1119345' to capture a snapshot of events at runtime. [2024-11-19 09:31:22.980276] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-19 09:31:22.980290] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-19 09:31:22.980300] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1119345 for offline analysis/debug. [2024-11-19 09:31:22.981622] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Tue Nov 19 09:31:28 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/11/19-09:31:34 ... thread 0: (1000000,1000000) ops and (162833.2,162833.2) ops/second in (6.141253,6.141253) 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/18 3.55 GB 6.3 0.7 0.0 0.7 1.6 0.9 0.0 1.9 120.6 260.7 6.26 5.65 17 0.368 766K 3606 0.0 0.0 L1 5/5 576.62 MB 0.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 L3 15/0 894.06 MB 0.9 0.2 0.1 0.1 0.2 0.1 0.0 1.6 163.1 160.6 1.29 1.08 1 1.288 130K 0 0.0 0.0 L4 126/0 9.52 GB 1.0 0.6 0.4 0.2 0.6 0.4 0.0 1.6 185.9 182.9 3.38 3.03 3 1.126 18K 0 0.0 0.0 L5 128/0 10.52 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 293/23 25.03 GB 0.0 1.6 0.5 1.1 2.4 1.3 0.6 2.8 145.8 224.9 10.93 9.75 21 0.520 915K 3606 0.0 0.0 Int 0/0 0.00 KB 0.0 1.6 0.5 1.1 2.4 1.3 0.6 2.8 145.8 224.9 10.93 9.75 21 0.520 915K 3606 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.6 0.5 1.1 1.5 0.5 0.0 0.0 207.7 205.5 7.67 7.03 7 1.096 915K 3606 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 270.3 3.26 2.72 14 0.233 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.3 total, 6.1 interval Flush(GB): cumulative 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: 2.40 GB write, 390.95 MB/s write, 1.56 GB read, 253.46 MB/s read, 10.9 seconds Interval compaction: 2.40 GB write, 399.84 MB/s write, 1.56 GB read, 259.23 MB/s read, 10.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 7, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 7, 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: 7, total-stops: 0, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 270399 Average: 40.1396 StdDev: 219.60 Min: 0 Median: 1.6540 Max: 28757 Percentiles: P50: 1.65 P75: 2.77 P99: 459.61 P99.9: 838.99 P99.99: 1289.21 ------------------------------------------------------ [ 0, 1 ] 46089 17.045% 17.045% ### ( 1, 2 ] 136245 50.387% 67.431% ########## ( 2, 3 ] 26420 9.771% 77.202% ## ( 3, 4 ] 7836 2.898% 80.100% # ( 4, 6 ] 6420 2.374% 82.474% ( 6, 10 ] 1447 0.535% 83.010% ( 10, 15 ] 292 0.108% 83.118% ( 15, 22 ] 61 0.023% 83.140% ( 22, 34 ] 26 0.010% 83.150% ( 34, 51 ] 3 0.001% 83.151% ( 51, 76 ] 17 0.006% 83.157% ( 76, 110 ] 1154 0.427% 83.584% ( 110, 170 ] 20667 7.643% 91.227% ## ( 170, 250 ] 15576 5.760% 96.987% # ( 250, 380 ] 4311 1.594% 98.582% ( 380, 580 ] 2844 1.052% 99.634% ( 580, 870 ] 808 0.299% 99.932% ( 870, 1300 ] 161 0.060% 99.992% ( 1300, 1900 ] 84 0.031% 100.023% ( 1900, 2900 ] 68 0.025% 100.048% ( 2900, 4400 ] 21 0.008% 100.056% ( 4400, 6600 ] 5 0.002% 100.058% ( 6600, 9900 ] 2 0.001% 100.058% ( 9900, 14000 ] 8 0.003% 100.061% ( 14000, 22000 ] 6 0.002% 100.064% ( 22000, 33000 ] 10 0.004% 100.067% ** Level 1 read latency histogram (micros): Count: 1663 Average: 249.5171 StdDev: 721.57 Min: 100 Median: 177.4306 Max: 23944 Percentiles: P50: 177.43 P75: 235.17 P99: 846.89 P99.9: 12640.85 P99.99: 23944.00 ------------------------------------------------------ ( 76, 110 ] 23 1.383% 1.383% ( 110, 170 ] 755 45.400% 46.783% ######### ( 170, 250 ] 576 34.636% 81.419% ####### ( 250, 380 ] 155 9.321% 90.740% ## ( 380, 580 ] 107 6.434% 97.174% # ( 580, 870 ] 33 1.984% 99.158% ( 870, 1300 ] 5 0.301% 99.459% ( 1300, 1900 ] 1 0.060% 99.519% ( 1900, 2900 ] 3 0.180% 99.699% ( 2900, 4400 ] 1 0.060% 99.759% ( 4400, 6600 ] 1 0.060% 99.820% ( 9900, 14000 ] 2 0.120% 99.940% ( 22000, 33000 ] 1 0.060% 100.000% ** Level 3 read latency histogram (micros): Count: 85210 Average: 11.8297 StdDev: 68.79 Min: 0 Median: 1.7800 Max: 4977 Percentiles: P50: 1.78 P75: 2.65 P99: 236.79 P99.9: 631.52 P99.99: 1245.80 ------------------------------------------------------ [ 0, 1 ] 5085 5.968% 5.968% # ( 1, 2 ] 48100 56.449% 62.416% ########### ( 2, 3 ] 16383 19.227% 81.643% #### ( 3, 4 ] 5440 6.384% 88.027% # ( 4, 6 ] 4440 5.211% 93.238% # ( 6, 10 ] 1842 2.162% 95.400% ( 10, 15 ] 457 0.536% 95.936% ( 15, 22 ] 106 0.124% 96.060% ( 22, 34 ] 30 0.035% 96.096% ( 34, 51 ] 2 0.002% 96.098% ( 51, 76 ] 3 0.004% 96.101% ( 76, 110 ] 101 0.119% 96.220% ( 110, 170 ] 1489 1.747% 97.967% ( 170, 250 ] 1054 1.237% 99.204% ( 250, 380 ] 329 0.386% 99.590% ( 380, 580 ] 251 0.295% 99.885% ( 580, 870 ] 72 0.084% 99.969% ( 870, 1300 ] 20 0.023% 99.993% ( 1300, 1900 ] 13 0.015% 100.008% ( 1900, 2900 ] 8 0.009% 100.018% ( 2900, 4400 ] 6 0.007% 100.025% ( 4400, 6600 ] 2 0.002% 100.027% ** Level 4 read latency histogram (micros): Count: 93867 Average: 77.5949 StdDev: 188.91 Min: 0 Median: 2.4627 Max: 7605 Percentiles: P50: 2.46 P75: 138.34 P99: 575.33 P99.9: 2419.04 P99.99: 3617.50 ------------------------------------------------------ [ 0, 1 ] 5314 5.661% 5.661% # ( 1, 2 ] 36298 38.670% 44.331% ######## ( 2, 3 ] 11502 12.254% 56.584% ## ( 3, 4 ] 4111 4.380% 60.964% # ( 4, 6 ] 3605 3.841% 64.804% # ( 6, 10 ] 1343 1.431% 66.235% ( 10, 15 ] 386 0.411% 66.646% ( 15, 22 ] 88 0.094% 66.740% ( 22, 34 ] 12 0.013% 66.753% ( 34, 51 ] 2 0.002% 66.755% ( 51, 76 ] 6 0.006% 66.761% ( 76, 110 ] 776 0.827% 67.588% ( 110, 170 ] 14729 15.691% 83.280% ### ( 170, 250 ] 10128 10.790% 94.069% ## ( 250, 380 ] 2804 2.987% 97.056% # ( 380, 580 ] 1869 1.991% 99.048% ( 580, 870 ] 523 0.557% 99.605% ( 870, 1300 ] 143 0.152% 99.757% ( 1300, 1900 ] 77 0.082% 99.839% ( 1900, 2900 ] 112 0.119% 99.958% ( 2900, 4400 ] 64 0.068% 100.027% ( 4400, 6600 ] 13 0.014% 100.040% ( 6600, 9900 ] 2 0.002% 100.043% ** Level 5 read latency histogram (micros): Count: 31887 Average: 222.2586 StdDev: 263.33 Min: 88 Median: 168.2325 Max: 7127 Percentiles: P50: 168.23 P75: 229.65 P99: 1025.85 P99.9: 4212.25 P99.99: 6381.13 ------------------------------------------------------ ( 76, 110 ] 969 3.039% 3.039% # ( 110, 170 ] 15429 48.386% 51.425% ########## ( 170, 250 ] 10081 31.615% 83.040% ###### ( 250, 380 ] 2669 8.370% 91.410% ## ( 380, 580 ] 1902 5.965% 97.375% # ( 580, 870 ] 475 1.490% 98.865% ( 870, 1300 ] 119 0.373% 99.238% ( 1300, 1900 ] 73 0.229% 99.467% ( 1900, 2900 ] 76 0.238% 99.705% ( 2900, 4400 ] 71 0.223% 99.928% ( 4400, 6600 ] 22 0.069% 99.997% ( 6600, 9900 ] 1 0.003% 100.000% ** DB Stats ** Uptime(secs): 6.3 total, 6.1 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 156.61 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.066 H:M:S, 32.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 160.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:2.066 H:M:S, 33.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-09:31:48 ... thread 0: (1000000,2000000) ops and (73345.6,101136.1) ops/second in (13.634075,19.775328) 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/14 4.57 GB 191.8 3.3 0.0 3.3 5.2 1.9 0.0 2.7 170.0 266.2 19.94 18.63 40 0.498 3442K 32K 0.0 0.0 L1 5/5 576.62 MB 0.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 L3 15/0 894.06 MB 0.9 0.2 0.1 0.1 0.2 0.1 0.0 1.6 163.1 160.6 1.29 1.08 1 1.288 130K 0 0.0 0.0 L4 126/0 9.52 GB 1.0 0.6 0.4 0.2 0.6 0.4 0.0 1.6 185.9 182.9 3.38 3.03 3 1.126 18K 0 0.0 0.0 L5 128/0 10.52 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 292/19 26.05 GB 0.0 4.1 0.5 3.6 6.0 2.4 0.6 3.1 171.8 249.2 24.61 22.74 44 0.559 3591K 32K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.1 0.5 3.6 6.0 2.4 0.6 3.1 171.8 249.2 24.61 22.74 44 0.559 3591K 32K 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 0.5 3.6 4.1 0.5 0.0 0.0 238.9 236.4 17.69 16.90 13 1.361 3591K 32K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.9 1.9 0.0 0.0 0.0 282.1 6.91 5.84 31 0.223 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 19.9 total, 19.8 interval Flush(GB): cumulative 1.905, interval 1.905 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.99 GB write, 307.89 MB/s write, 4.13 GB read, 212.25 MB/s read, 24.6 seconds Interval compaction: 5.99 GB write, 310.07 MB/s write, 4.13 GB read, 213.75 MB/s read, 24.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 25, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 25, 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: 25, total-stops: 0, interval: 25 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1056651 Average: 33.2630 StdDev: 128.71 Min: 0 Median: 1.5861 Max: 28757 Percentiles: P50: 1.59 P75: 2.51 P99: 345.00 P99.9: 576.74 P99.99: 770.09 ------------------------------------------------------ [ 0, 1 ] 213261 20.183% 20.183% #### ( 1, 2 ] 537544 50.872% 71.055% ########## ( 2, 3 ] 81557 7.718% 78.774% ## ( 3, 4 ] 23299 2.205% 80.979% ( 4, 6 ] 21822 2.065% 83.044% ( 6, 10 ] 4475 0.424% 83.467% ( 10, 15 ] 1159 0.110% 83.577% ( 15, 22 ] 234 0.022% 83.599% ( 22, 34 ] 62 0.006% 83.605% ( 34, 51 ] 15 0.001% 83.606% ( 51, 76 ] 20 0.002% 83.608% ( 76, 110 ] 4850 0.459% 84.067% ( 110, 170 ] 92437 8.748% 92.815% ## ( 170, 250 ] 57686 5.459% 98.275% # ( 250, 380 ] 10488 0.993% 99.267% ( 380, 580 ] 6797 0.643% 99.911% ( 580, 870 ] 1282 0.121% 100.032% ( 870, 1300 ] 190 0.018% 100.050% ( 1300, 1900 ] 98 0.009% 100.059% ( 1900, 2900 ] 95 0.009% 100.068% ( 2900, 4400 ] 39 0.004% 100.072% ( 4400, 6600 ] 5 0.000% 100.072% ( 6600, 9900 ] 2 0.000% 100.072% ( 9900, 14000 ] 8 0.001% 100.073% ( 14000, 22000 ] 6 0.001% 100.074% ( 22000, 33000 ] 10 0.001% 100.075% ** Level 1 read latency histogram (micros): Count: 6078 Average: 199.2581 StdDev: 387.51 Min: 96 Median: 163.6667 Max: 23944 Percentiles: P50: 163.67 P75: 216.73 P99: 647.26 P99.9: 2880.50 P99.99: 23944.00 ------------------------------------------------------ ( 76, 110 ] 141 2.320% 2.320% ( 110, 170 ] 3240 53.307% 55.627% ########### ( 170, 250 ] 2016 33.169% 88.796% ####### ( 250, 380 ] 372 6.120% 94.916% # ( 380, 580 ] 235 3.866% 98.782% # ( 580, 870 ] 57 0.938% 99.720% ( 870, 1300 ] 5 0.082% 99.803% ( 1300, 1900 ] 2 0.033% 99.835% ( 1900, 2900 ] 4 0.066% 99.901% ( 2900, 4400 ] 2 0.033% 99.934% ( 4400, 6600 ] 1 0.016% 99.951% ( 9900, 14000 ] 2 0.033% 99.984% ( 22000, 33000 ] 1 0.016% 100.000% ** Level 3 read latency histogram (micros): Count: 94255 Average: 27.0825 StdDev: 84.84 Min: 0 Median: 1.8741 Max: 4977 Percentiles: P50: 1.87 P75: 3.20 P99: 325.38 P99.9: 678.92 P99.99: 1291.68 ------------------------------------------------------ [ 0, 1 ] 5085 5.395% 5.395% # ( 1, 2 ] 48100 51.032% 56.427% ########## ( 2, 3 ] 16389 17.388% 73.815% ### ( 3, 4 ] 5508 5.844% 79.658% # ( 4, 6 ] 4635 4.918% 84.576% # ( 6, 10 ] 1853 1.966% 86.542% ( 10, 15 ] 460 0.488% 87.030% ( 15, 22 ] 107 0.114% 87.143% ( 22, 34 ] 30 0.032% 87.175% ( 34, 51 ] 2 0.002% 87.177% ( 51, 76 ] 3 0.003% 87.181% ( 76, 110 ] 422 0.448% 87.628% ( 110, 170 ] 6517 6.914% 94.542% # ( 170, 250 ] 3795 4.026% 98.569% # ( 250, 380 ] 701 0.744% 99.313% ( 380, 580 ] 521 0.553% 99.865% ( 580, 870 ] 96 0.102% 99.967% ( 870, 1300 ] 22 0.023% 99.990% ( 1300, 1900 ] 14 0.015% 100.005% ( 1900, 2900 ] 10 0.011% 100.016% ( 2900, 4400 ] 6 0.006% 100.022% ( 4400, 6600 ] 2 0.002% 100.024% ** Level 4 read latency histogram (micros): Count: 179261 Average: 123.2814 StdDev: 155.81 Min: 0 Median: 131.0769 Max: 7605 Percentiles: P50: 131.08 P75: 178.94 P99: 553.16 P99.9: 1783.85 P99.99: 3409.40 ------------------------------------------------------ [ 0, 1 ] 5314 2.964% 2.964% # ( 1, 2 ] 36302 20.251% 23.215% #### ( 2, 3 ] 11523 6.428% 29.643% # ( 3, 4 ] 4502 2.511% 32.155% # ( 4, 6 ] 4781 2.667% 34.822% # ( 6, 10 ] 1443 0.805% 35.627% ( 10, 15 ] 416 0.232% 35.859% ( 15, 22 ] 102 0.057% 35.916% ( 22, 34 ] 17 0.009% 35.925% ( 34, 51 ] 3 0.002% 35.927% ( 51, 76 ] 6 0.003% 35.930% ( 76, 110 ] 3180 1.774% 37.704% ( 110, 170 ] 62746 35.003% 72.707% ####### ( 170, 250 ] 36801 20.529% 93.236% #### ( 250, 380 ] 6483 3.617% 96.853% # ( 380, 580 ] 4446 2.480% 99.333% ( 580, 870 ] 791 0.441% 99.774% ( 870, 1300 ] 158 0.088% 99.862% ( 1300, 1900 ] 84 0.047% 99.909% ( 1900, 2900 ] 123 0.069% 99.978% ( 2900, 4400 ] 65 0.036% 100.014% ( 4400, 6600 ] 13 0.007% 100.021% ( 6600, 9900 ] 2 0.001% 100.022% ** Level 5 read latency histogram (micros): Count: 114184 Average: 188.8983 StdDev: 157.42 Min: 84 Median: 160.0501 Max: 7127 Percentiles: P50: 160.05 P75: 211.59 P99: 579.75 P99.9: 2695.69 P99.99: 5458.16 ------------------------------------------------------ ( 76, 110 ] 3968 3.475% 3.475% # ( 110, 170 ] 63685 55.774% 59.249% ########### ( 170, 250 ] 34598 30.300% 89.549% ###### ( 250, 380 ] 6209 5.438% 94.987% # ( 380, 580 ] 4588 4.018% 99.005% # ( 580, 870 ] 741 0.649% 99.654% ( 870, 1300 ] 133 0.116% 99.771% ( 1300, 1900 ] 77 0.067% 99.838% ( 1900, 2900 ] 89 0.078% 99.916% ( 2900, 4400 ] 74 0.065% 99.981% ( 4400, 6600 ] 22 0.019% 100.000% ( 6600, 9900 ] 1 0.001% 100.001% ** DB Stats ** Uptime(secs): 19.9 total, 13.6 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 98.82 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:11.304 H:M:S, 56.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 72.19 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:9.238 H:M:S, 67.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 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] readwhilewriting : 258.870 micros/op 15402 ops/sec 20.191 seconds 310996 operations; 14.9 MB/s (77999 of 77999 found) Microseconds per read: Count: 310996 Average: 258.8813 StdDev: 412.93 Min: 3 Median: 217.0097 Max: 35070 Percentiles: P50: 217.01 P75: 281.41 P99: 831.65 P99.9: 4014.37 P99.99: 20942.04 ------------------------------------------------------ ( 2, 3 ] 4 0.001% 0.001% ( 3, 4 ] 9 0.003% 0.004% ( 4, 6 ] 124 0.040% 0.044% ( 6, 10 ] 471 0.151% 0.196% ( 10, 15 ] 325 0.105% 0.300% ( 15, 22 ] 320 0.103% 0.403% ( 22, 34 ] 8945 2.876% 3.279% # ( 34, 51 ] 4568 1.469% 4.748% ( 51, 76 ] 760 0.244% 4.992% ( 76, 110 ] 118 0.038% 5.030% ( 110, 170 ] 45854 14.744% 19.775% ### ( 170, 250 ] 159967 51.437% 71.212% ########## ( 250, 380 ] 48764 15.680% 86.891% ### ( 380, 580 ] 30248 9.726% 96.618% ## ( 580, 870 ] 8538 2.745% 99.363% # ( 870, 1300 ] 1400 0.450% 99.813% ( 1300, 1900 ] 142 0.046% 99.859% ( 1900, 2900 ] 76 0.024% 99.883% ( 2900, 4400 ] 70 0.023% 99.906% ( 4400, 6600 ] 68 0.022% 99.928% ( 6600, 9900 ] 108 0.035% 99.962% ( 9900, 14000 ] 59 0.019% 99.981% ( 14000, 22000 ] 31 0.010% 99.991% ( 22000, 33000 ] 25 0.008% 99.999% ( 33000, 50000 ] 2 0.001% 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 : 5805107 rocksdb.bloom.filter.full.positive COUNT : 366599 rocksdb.bloom.filter.full.true.positive COUNT : 310133 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 : 863 rocksdb.memtable.miss COUNT : 310133 rocksdb.l0.hit COUNT : 56883 rocksdb.l1.hit COUNT : 7252 rocksdb.l2andup.hit COUNT : 245998 rocksdb.compaction.key.drop.new COUNT : 66322 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 : 2114668 rocksdb.number.keys.read COUNT : 310996 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 2182337376 rocksdb.bytes.read COUNT : 310996000 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 : 341 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 11303581 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 : 4794104927 rocksdb.compact.write.bytes COUNT : 4723596236 rocksdb.flush.write.bytes COUNT : 2111015213 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 : 13 rocksdb.number.superversion_acquires COUNT : 328 rocksdb.number.superversion_releases COUNT : 307 rocksdb.number.superversion_cleanups COUNT : 79 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 : 0 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 : 2096762880 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3341312 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 : 6182178674 rocksdb.non.last.level.read.count COUNT : 1460461 rocksdb.block.checksum.compute.count COUNT : 1531623 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 : 216.228048 P95 : 545.860204 P99 : 831.010350 P100 : 35068.000000 COUNT : 310996 SUM : 80164929 rocksdb.db.write.micros P50 : 1.535228 P95 : 5.414002 P99 : 12.879338 P100 : 2349.000000 COUNT : 2114668 SUM : 17015708 rocksdb.compaction.times.micros P50 : 1105555.555556 P95 : 3069173.000000 P99 : 3069173.000000 P100 : 3069173.000000 COUNT : 13 SUM : 17693092 rocksdb.compaction.times.cpu_micros P50 : 1060909.090909 P95 : 3032068.000000 P99 : 3032068.000000 P100 : 3032068.000000 COUNT : 13 SUM : 16898499 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 : 870.000000 P95 : 1677.000000 P99 : 1677.000000 P100 : 1677.000000 COUNT : 32 SUM : 31824 rocksdb.compaction.outfile.sync.micros P50 : 1018.846154 P95 : 2725.000000 P99 : 3703.000000 P100 : 3703.000000 COUNT : 27 SUM : 32447 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 : 180.000000 P95 : 415.000000 P99 : 415.000000 P100 : 415.000000 COUNT : 48 SUM : 9669 rocksdb.table.open.io.micros P50 : 5940.000000 P95 : 13305.277778 P99 : 45540.769231 P100 : 49815.000000 COUNT : 341 SUM : 2505283 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.597552 P95 : 149.590593 P99 : 246.744939 P100 : 6399.000000 COUNT : 1160750 SUM : 22092582 rocksdb.read.block.get.micros P50 : 164.043035 P95 : 370.766316 P99 : 576.460310 P100 : 29474.000000 COUNT : 370546 SUM : 67929300 rocksdb.write.raw.block.micros P50 : 0.545021 P95 : 1.582658 P99 : 6.969936 P100 : 6373.000000 COUNT : 1655834 SUM : 3823482 rocksdb.numfiles.in.singlecompaction P50 : 3.363636 P95 : 16.400000 P99 : 19.000000 P100 : 19.000000 COUNT : 16 SUM : 75 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.578911 P95 : 1204.673104 P99 : 2330.000000 P100 : 2330.000000 COUNT : 66224 SUM : 11312747 rocksdb.sst.read.micros P50 : 1.814522 P95 : 234.005331 P99 : 457.520927 P100 : 28757.000000 COUNT : 1460501 SUM : 84091401 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 : 1000.000000 P95 : 1000.000000 P99 : 1000.000000 P100 : 1000.000000 COUNT : 310996 SUM : 310996000 rocksdb.bytes.per.write P50 : 1032.000000 P95 : 1032.000000 P99 : 1032.000000 P100 : 1032.000000 COUNT : 2114668 SUM : 2182337376 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 : 215714.285714 P95 : 293568.000000 P99 : 293568.000000 P100 : 293568.000000 COUNT : 32 SUM : 7124955 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 : 48 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