[2024-12-01 22:43:17.297839] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 23.11.0 initialization... [2024-12-01 22:43:17.297956] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid963012 ] Set seed to 1733089397295504 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-01 22:43:17.394551] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-01 22:43:17.431411] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-01 22:43:17.431455] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 963012' to capture a snapshot of events at runtime. [2024-12-01 22:43:17.431467] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid963012 for offline analysis/debug. [2024-12-01 22:43:17.431505] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sun Dec 1 22:43:21 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/01-22:43:25 ... thread 0: (1000000,1000000) ops and (235428.6,235428.6) ops/second in (4.247573,4.247573) 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/16 2.83 GB 62.9 0.6 0.0 0.6 1.4 0.9 0.0 1.6 105.1 268.3 5.40 4.46 15 0.360 575K 614 0.0 0.0 L1 11/11 1.16 GB 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 L2 1/0 94.26 MB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 21/0 971.80 MB 1.0 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 159/0 9.69 GB 1.0 1.3 0.7 0.6 1.3 0.7 0.0 1.8 118.4 117.2 11.47 6.48 10 1.147 0 0 0.0 0.0 L5 1112/0 91.41 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1323/27 106.13 GB 0.0 1.9 0.7 1.1 2.7 1.6 2.0 3.2 114.1 165.6 16.87 10.93 25 0.675 575K 614 0.0 0.0 Int 0/0 0.00 KB 0.0 1.9 0.7 1.1 2.7 1.6 2.0 3.2 114.1 165.6 16.87 10.93 25 0.675 575K 614 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.9 0.7 1.1 1.9 0.7 0.0 0.0 141.4 140.4 13.61 8.57 12 1.134 575K 614 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.6 3.26 2.36 13 0.251 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.4 total, 4.2 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 2.73 GB write, 634.33 MB/s write, 1.88 GB read, 437.16 MB/s read, 16.9 seconds Interval compaction: 2.73 GB write, 657.09 MB/s write, 1.88 GB read, 452.85 MB/s read, 16.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 2, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 2, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 2, total-stops: 5, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 272542 Average: 12.5101 StdDev: 118.35 Min: 0 Median: 1.5328 Max: 7135 Percentiles: P50: 1.53 P75: 1.95 P99: 218.39 P99.9: 1261.76 P99.99: 2468.15 ------------------------------------------------------ [ 0, 1 ] 49989 18.342% 18.342% #### ( 1, 2 ] 161929 59.414% 77.756% ############ ( 2, 3 ] 30725 11.273% 89.030% ## ( 3, 4 ] 11138 4.087% 93.116% # ( 4, 6 ] 8234 3.021% 96.137% # ( 6, 10 ] 2501 0.918% 97.055% ( 10, 15 ] 437 0.160% 97.215% ( 15, 22 ] 98 0.036% 97.251% ( 22, 34 ] 19 0.007% 97.258% ( 34, 51 ] 5 0.002% 97.260% ( 51, 76 ] 4 0.001% 97.262% ( 76, 110 ] 901 0.331% 97.592% ( 110, 170 ] 3024 1.110% 98.702% ( 170, 250 ] 1345 0.494% 99.195% ( 250, 380 ] 650 0.238% 99.434% ( 380, 580 ] 624 0.229% 99.663% ( 580, 870 ] 396 0.145% 99.808% ( 870, 1300 ] 276 0.101% 99.909% ( 1300, 1900 ] 152 0.056% 99.965% ( 1900, 2900 ] 121 0.044% 100.010% ( 2900, 4400 ] 80 0.029% 100.039% ( 4400, 6600 ] 30 0.011% 100.050% ( 6600, 9900 ] 3 0.001% 100.051% ** Level 1 read latency histogram (micros): Count: 311 Average: 498.6206 StdDev: 853.64 Min: 82 Median: 188.9189 Max: 5137 Percentiles: P50: 188.92 P75: 382.00 P99: 5137.00 P99.9: 5137.00 P99.99: 5137.00 ------------------------------------------------------ ( 76, 110 ] 30 9.646% 9.646% ## ( 110, 170 ] 108 34.727% 44.373% ####### ( 170, 250 ] 74 23.794% 68.167% ##### ( 250, 380 ] 21 6.752% 74.920% # ( 380, 580 ] 25 8.039% 82.958% ## ( 580, 870 ] 8 2.572% 85.531% # ( 870, 1300 ] 16 5.145% 90.675% # ( 1300, 1900 ] 6 1.929% 92.605% ( 1900, 2900 ] 15 4.823% 97.428% # ( 2900, 4400 ] 2 0.643% 98.071% ( 4400, 6600 ] 6 1.929% 100.000% ** Level 2 read latency histogram (micros): Count: 21 Average: 363.4286 StdDev: 432.09 Min: 115 Median: 210.0000 Max: 2121 Percentiles: P50: 210.00 P75: 417.50 P99: 2121.00 P99.9: 2121.00 P99.99: 2121.00 ------------------------------------------------------ ( 110, 170 ] 7 33.333% 33.333% ####### ( 170, 250 ] 7 33.333% 66.667% ####### ( 250, 380 ] 1 4.762% 71.429% # ( 380, 580 ] 4 19.048% 90.476% #### ( 870, 1300 ] 1 4.762% 95.238% # ( 1900, 2900 ] 1 4.762% 100.000% # ** Level 3 read latency histogram (micros): Count: 12852 Average: 21.7768 StdDev: 157.33 Min: 1 Median: 1.7916 Max: 5223 Percentiles: P50: 1.79 P75: 2.78 P99: 614.17 P99.9: 2553.43 P99.99: 4338.89 ------------------------------------------------------ [ 0, 1 ] 1105 8.598% 8.598% ## ( 1, 2 ] 6722 52.303% 60.901% ########## ( 2, 3 ] 2330 18.129% 79.031% #### ( 3, 4 ] 951 7.400% 86.430% # ( 4, 6 ] 928 7.221% 93.651% # ( 6, 10 ] 292 2.272% 95.923% ( 10, 15 ] 47 0.366% 96.289% ( 15, 22 ] 11 0.086% 96.374% ( 22, 34 ] 3 0.023% 96.397% ( 76, 110 ] 34 0.265% 96.662% ( 110, 170 ] 121 0.941% 97.603% ( 170, 250 ] 61 0.475% 98.078% ( 250, 380 ] 52 0.405% 98.483% ( 380, 580 ] 60 0.467% 98.950% ( 580, 870 ] 55 0.428% 99.378% ( 870, 1300 ] 43 0.335% 99.712% ( 1300, 1900 ] 15 0.117% 99.829% ( 1900, 2900 ] 14 0.109% 99.938% ( 2900, 4400 ] 7 0.054% 99.992% ( 4400, 6600 ] 1 0.008% 100.000% ** Level 4 read latency histogram (micros): Count: 60866 Average: 38.0981 StdDev: 257.12 Min: 1 Median: 1.8348 Max: 7083 Percentiles: P50: 1.83 P75: 2.88 P99: 990.30 P99.9: 3323.97 P99.99: 4179.90 ------------------------------------------------------ [ 0, 1 ] 4801 7.888% 7.888% ## ( 1, 2 ] 30703 50.444% 58.331% ########## ( 2, 3 ] 11526 18.937% 77.268% #### ( 3, 4 ] 4502 7.397% 84.665% # ( 4, 6 ] 4129 6.784% 91.448% # ( 6, 10 ] 1691 2.778% 94.227% # ( 10, 15 ] 332 0.545% 94.772% ( 15, 22 ] 78 0.128% 94.900% ( 22, 34 ] 28 0.046% 94.946% ( 34, 51 ] 8 0.013% 94.959% ( 51, 76 ] 2 0.003% 94.963% ( 76, 110 ] 208 0.342% 95.304% ( 110, 170 ] 756 1.242% 96.547% ( 170, 250 ] 435 0.715% 97.261% ( 250, 380 ] 321 0.527% 97.789% ( 380, 580 ] 355 0.583% 98.372% ( 580, 870 ] 311 0.511% 98.883% ( 870, 1300 ] 255 0.419% 99.302% ( 1300, 1900 ] 188 0.309% 99.611% ( 1900, 2900 ] 149 0.245% 99.855% ( 2900, 4400 ] 96 0.158% 100.013% ( 4400, 6600 ] 41 0.067% 100.081% ( 6600, 9900 ] 1 0.002% 100.082% ** Level 5 read latency histogram (micros): Count: 22406 Average: 514.8495 StdDev: 869.95 Min: 75 Median: 196.4200 Max: 17389 Percentiles: P50: 196.42 P75: 443.11 P99: 4454.07 P99.9: 7310.01 P99.99: 9869.46 ------------------------------------------------------ ( 51, 76 ] 1 0.004% 0.004% ( 76, 110 ] 2130 9.506% 9.511% ## ( 110, 170 ] 7751 34.593% 44.104% ####### ( 170, 250 ] 4000 17.852% 61.957% #### ( 250, 380 ] 2281 10.180% 72.137% ## ( 380, 580 ] 2033 9.073% 81.210% ## ( 580, 870 ] 1262 5.632% 86.843% # ( 870, 1300 ] 753 3.361% 90.204% # ( 1300, 1900 ] 623 2.781% 92.984% # ( 1900, 2900 ] 766 3.419% 96.403% # ( 2900, 4400 ] 577 2.575% 98.978% # ( 4400, 6600 ] 201 0.897% 99.875% ( 6600, 9900 ] 26 0.116% 99.991% ( 9900, 14000 ] 1 0.004% 99.996% ( 14000, 22000 ] 1 0.004% 100.000% ** DB Stats ** Uptime(secs): 4.4 total, 4.3 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 223.55 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.610 H:M:S, 13.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 231.55 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.610 H:M:S, 14.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/01-22:43:39 ... thread 0: (1000000,2000000) ops and (74248.1,112892.7) ops/second in (13.468361,17.715934) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/12 3.87 GB 194.7 2.8 0.0 2.8 4.7 1.9 0.0 2.5 168.4 281.5 17.21 15.64 38 0.453 2941K 6297 0.0 0.0 L1 11/11 1.16 GB 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 L2 1/0 94.26 MB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 21/0 971.80 MB 1.0 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 159/0 9.69 GB 1.0 1.3 0.7 0.6 1.3 0.7 0.0 1.8 118.4 117.2 11.47 6.48 10 1.147 0 0 0.0 0.0 L5 1112/0 91.41 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1321/23 107.17 GB 0.0 4.2 0.7 3.4 6.0 2.6 2.0 3.2 148.4 215.8 28.68 22.12 48 0.597 2941K 6297 0.0 0.0 Int 0/0 0.00 KB 0.0 4.2 0.7 3.4 6.0 2.6 2.0 3.2 148.4 215.8 28.68 22.12 48 0.597 2941K 6297 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.2 0.7 3.4 4.1 0.7 0.0 0.0 191.5 190.7 22.21 17.02 18 1.234 2941K 6297 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 302.1 6.47 5.10 30 0.216 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 17.9 total, 17.7 interval Flush(GB): cumulative 1.907, interval 1.907 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.04 GB write, 346.25 MB/s write, 4.15 GB read, 238.07 MB/s read, 28.7 seconds Interval compaction: 6.04 GB write, 349.23 MB/s write, 4.15 GB read, 240.12 MB/s read, 28.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 5, pending-compaction-bytes-delays: 4, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 5, interval: 22 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 964515 Average: 22.6438 StdDev: 88.71 Min: 0 Median: 1.4688 Max: 7135 Percentiles: P50: 1.47 P75: 1.96 P99: 247.59 P99.9: 687.99 P99.99: 1124.15 ------------------------------------------------------ [ 0, 1 ] 254043 26.339% 26.339% ##### ( 1, 2 ] 486754 50.466% 76.805% ########## ( 2, 3 ] 61807 6.408% 83.213% # ( 3, 4 ] 23701 2.457% 85.671% ( 4, 6 ] 16934 1.756% 87.426% ( 6, 10 ] 4114 0.427% 87.853% ( 10, 15 ] 868 0.090% 87.943% ( 15, 22 ] 143 0.015% 87.958% ( 22, 34 ] 23 0.002% 87.960% ( 34, 51 ] 6 0.001% 87.961% ( 51, 76 ] 16 0.002% 87.962% ( 76, 110 ] 22068 2.288% 90.250% ( 110, 170 ] 68032 7.053% 97.304% # ( 170, 250 ] 16870 1.749% 99.053% ( 250, 380 ] 4456 0.462% 99.515% ( 380, 580 ] 3320 0.344% 99.859% ( 580, 870 ] 1062 0.110% 99.969% ( 870, 1300 ] 341 0.035% 100.004% ( 1300, 1900 ] 172 0.018% 100.022% ( 1900, 2900 ] 178 0.018% 100.041% ( 2900, 4400 ] 123 0.013% 100.053% ( 4400, 6600 ] 30 0.003% 100.057% ( 6600, 9900 ] 3 0.000% 100.057% ** Level 1 read latency histogram (micros): Count: 3352 Average: 188.1095 StdDev: 293.99 Min: 78 Median: 141.5967 Max: 5137 Percentiles: P50: 141.60 P75: 167.33 P99: 1242.97 P99.9: 5137.00 P99.99: 5137.00 ------------------------------------------------------ ( 76, 110 ] 647 19.302% 19.302% #### ( 110, 170 ] 1954 58.294% 77.595% ############ ( 170, 250 ] 463 13.813% 91.408% ### ( 250, 380 ] 116 3.461% 94.869% # ( 380, 580 ] 100 2.983% 97.852% # ( 580, 870 ] 22 0.656% 98.508% ( 870, 1300 ] 19 0.567% 99.075% ( 1300, 1900 ] 6 0.179% 99.254% ( 1900, 2900 ] 17 0.507% 99.761% ( 2900, 4400 ] 2 0.060% 99.821% ( 4400, 6600 ] 6 0.179% 100.000% ** Level 2 read latency histogram (micros): Count: 386 Average: 171.6839 StdDev: 146.66 Min: 79 Median: 145.6017 Max: 2121 Percentiles: P50: 145.60 P75: 169.63 P99: 890.07 P99.9: 2121.00 P99.99: 2121.00 ------------------------------------------------------ ( 76, 110 ] 50 12.953% 12.953% ### ( 110, 170 ] 241 62.435% 75.389% ############ ( 170, 250 ] 66 17.098% 92.487% ### ( 250, 380 ] 13 3.368% 95.855% # ( 380, 580 ] 7 1.813% 97.668% ( 580, 870 ] 5 1.295% 98.964% ( 870, 1300 ] 3 0.777% 99.741% ( 1900, 2900 ] 1 0.259% 100.000% ** Level 3 read latency histogram (micros): Count: 16348 Average: 50.6529 StdDev: 155.13 Min: 1 Median: 2.1489 Max: 5223 Percentiles: P50: 2.15 P75: 9.08 P99: 577.77 P99.9: 2303.71 P99.99: 4263.97 ------------------------------------------------------ [ 0, 1 ] 1105 6.759% 6.759% # ( 1, 2 ] 6722 41.118% 47.877% ######## ( 2, 3 ] 2330 14.253% 62.130% ### ( 3, 4 ] 951 5.817% 67.947% # ( 4, 6 ] 928 5.677% 73.624% # ( 6, 10 ] 292 1.786% 75.410% ( 10, 15 ] 47 0.287% 75.697% ( 15, 22 ] 11 0.067% 75.765% ( 22, 34 ] 3 0.018% 75.783% ( 76, 110 ] 696 4.257% 80.040% # ( 110, 170 ] 2247 13.745% 93.785% ### ( 170, 250 ] 532 3.254% 97.039% # ( 250, 380 ] 189 1.156% 98.195% ( 380, 580 ] 133 0.814% 99.009% ( 580, 870 ] 77 0.471% 99.480% ( 870, 1300 ] 47 0.287% 99.768% ( 1300, 1900 ] 16 0.098% 99.865% ( 1900, 2900 ] 14 0.086% 99.951% ( 2900, 4400 ] 7 0.043% 99.994% ( 4400, 6600 ] 1 0.006% 100.000% ** Level 4 read latency histogram (micros): Count: 87666 Average: 70.8132 StdDev: 225.74 Min: 1 Median: 2.6775 Max: 7083 Percentiles: P50: 2.68 P75: 113.30 P99: 754.88 P99.9: 2920.63 P99.99: 4140.72 ------------------------------------------------------ [ 0, 1 ] 4802 5.478% 5.478% # ( 1, 2 ] 30829 35.166% 40.644% ####### ( 2, 3 ] 12107 13.810% 54.454% ### ( 3, 4 ] 4899 5.588% 60.043% # ( 4, 6 ] 4824 5.503% 65.545% # ( 6, 10 ] 1747 1.993% 67.538% ( 10, 15 ] 355 0.405% 67.943% ( 15, 22 ] 83 0.095% 68.038% ( 22, 34 ] 28 0.032% 68.070% ( 34, 51 ] 8 0.009% 68.079% ( 51, 76 ] 4 0.005% 68.083% ( 76, 110 ] 5198 5.929% 74.013% # ( 110, 170 ] 15718 17.929% 91.942% #### ( 170, 250 ] 3811 4.347% 96.289% # ( 250, 380 ] 1150 1.312% 97.601% ( 380, 580 ] 961 1.096% 98.697% ( 580, 870 ] 440 0.502% 99.199% ( 870, 1300 ] 269 0.307% 99.506% ( 1300, 1900 ] 191 0.218% 99.724% ( 1900, 2900 ] 153 0.175% 99.898% ( 2900, 4400 ] 97 0.111% 100.009% ( 4400, 6600 ] 41 0.047% 100.056% ( 6600, 9900 ] 1 0.001% 100.057% ** Level 5 read latency histogram (micros): Count: 234308 Average: 190.7777 StdDev: 301.73 Min: 73 Median: 142.3961 Max: 17389 Percentiles: P50: 142.40 P75: 168.37 P99: 1274.24 P99.9: 4365.82 P99.99: 6562.45 ------------------------------------------------------ ( 51, 76 ] 23 0.010% 0.010% ( 76, 110 ] 44067 18.807% 18.817% #### ( 110, 170 ] 135320 57.753% 76.570% ############ ( 170, 250 ] 32764 13.983% 90.553% ### ( 250, 380 ] 9185 3.920% 94.474% # ( 380, 580 ] 7263 3.100% 97.573% # ( 580, 870 ] 2510 1.071% 98.645% ( 870, 1300 ] 886 0.378% 99.023% ( 1300, 1900 ] 670 0.286% 99.309% ( 1900, 2900 ] 815 0.348% 99.656% ( 2900, 4400 ] 584 0.249% 99.906% ( 4400, 6600 ] 201 0.086% 99.991% ( 6600, 9900 ] 26 0.011% 100.003% ( 9900, 14000 ] 1 0.000% 100.003% ( 14000, 22000 ] 1 0.000% 100.003% ** DB Stats ** Uptime(secs): 17.9 total, 13.5 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 110.14 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:10.208 H:M:S, 57.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 73.07 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.598 H:M:S, 71.3 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: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] readwhilewriting : 201.846 micros/op 19803 ops/sec 60.090 seconds 1189996 operations; 19.2 MB/s (300999 of 300999 found) Microseconds per read: Count: 1189996 Average: 201.8478 StdDev: 396.28 Min: 2 Median: 167.4044 Max: 62621 Percentiles: P50: 167.40 P75: 225.90 P99: 572.58 P99.9: 4374.60 P99.99: 19333.36 ------------------------------------------------------ ( 1, 2 ] 9 0.001% 0.001% ( 2, 3 ] 32 0.003% 0.003% ( 3, 4 ] 47 0.004% 0.007% ( 4, 6 ] 91 0.008% 0.015% ( 6, 10 ] 482 0.041% 0.056% ( 10, 15 ] 5161 0.434% 0.489% ( 15, 22 ] 3789 0.318% 0.808% ( 22, 34 ] 10539 0.886% 1.693% ( 34, 51 ] 1847 0.155% 1.848% ( 51, 76 ] 192 0.016% 1.865% ( 76, 110 ] 25610 2.152% 4.017% ( 110, 170 ] 571941 48.062% 52.079% ########## ( 170, 250 ] 390384 32.805% 84.885% ####### ( 250, 380 ] 134454 11.299% 96.183% ## ( 380, 580 ] 34810 2.925% 99.109% # ( 580, 870 ] 7034 0.591% 99.700% ( 870, 1300 ] 1427 0.120% 99.820% ( 1300, 1900 ] 326 0.027% 99.847% ( 1900, 2900 ] 341 0.029% 99.876% ( 2900, 4400 ] 295 0.025% 99.900% ( 4400, 6600 ] 426 0.036% 99.936% ( 6600, 9900 ] 372 0.031% 99.967% ( 9900, 14000 ] 176 0.015% 99.982% ( 14000, 22000 ] 138 0.012% 99.994% ( 22000, 33000 ] 52 0.004% 99.998% ( 33000, 50000 ] 17 0.001% 100.000% ( 50000, 75000 ] 4 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 : 22818552 rocksdb.bloom.filter.full.positive COUNT : 1411110 rocksdb.bloom.filter.full.true.positive COUNT : 1189637 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 : 359 rocksdb.memtable.miss COUNT : 1189637 rocksdb.l0.hit COUNT : 46169 rocksdb.l1.hit COUNT : 13528 rocksdb.l2andup.hit COUNT : 1129940 rocksdb.compaction.key.drop.new COUNT : 36751 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 : 2141735 rocksdb.number.keys.read COUNT : 1189996 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 2210270520 rocksdb.bytes.read COUNT : 1189996000 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 : 1383 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 51447300 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 : 6294138516 rocksdb.compact.write.bytes COUNT : 6257168053 rocksdb.flush.write.bytes COUNT : 2180000250 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 : 58 rocksdb.number.superversion_acquires COUNT : 356 rocksdb.number.superversion_releases COUNT : 342 rocksdb.number.superversion_cleanups COUNT : 90 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 : 2162289664 rocksdb.memtable.garbage.bytes.at.flush COUNT : 722944 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 : 11576383360 rocksdb.non.last.level.read.count COUNT : 2652129 rocksdb.block.checksum.compute.count COUNT : 2949202 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 : 166.555916 P95 : 365.874930 P99 : 572.156981 P100 : 62619.000000 COUNT : 1189996 SUM : 239180954 rocksdb.db.write.micros P50 : 1.591458 P95 : 5.485578 P99 : 1163.631798 P100 : 253990.000000 COUNT : 2141735 SUM : 57093537 rocksdb.compaction.times.micros P50 : 1076363.636364 P95 : 3040000.000000 P99 : 3897729.000000 P100 : 3897729.000000 COUNT : 18 SUM : 22210909 rocksdb.compaction.times.cpu_micros P50 : 928000.000000 P95 : 3040000.000000 P99 : 3839276.000000 P100 : 3839276.000000 COUNT : 18 SUM : 17021484 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 : 773.333333 P95 : 2600.000000 P99 : 44560.000000 P100 : 47863.000000 COUNT : 32 SUM : 75433 rocksdb.compaction.outfile.sync.micros P50 : 1962.500000 P95 : 87687.500000 P99 : 105537.500000 P100 : 106701.000000 COUNT : 51 SUM : 772070 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 : 160.000000 P95 : 2975.000000 P99 : 6777.000000 P100 : 6777.000000 COUNT : 58 SUM : 41078 rocksdb.table.open.io.micros P50 : 5932.369942 P95 : 13964.548872 P99 : 21104.262295 P100 : 27515.000000 COUNT : 1383 SUM : 9280192 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.751761 P95 : 163.714095 P99 : 242.706531 P100 : 16167.000000 COUNT : 1524837 SUM : 57420679 rocksdb.read.block.get.micros P50 : 136.201180 P95 : 233.025849 P99 : 463.424232 P100 : 17452.000000 COUNT : 1422934 SUM : 202684349 rocksdb.write.raw.block.micros P50 : 0.566347 P95 : 1.751764 P99 : 3.458162 P100 : 11159.000000 COUNT : 2043718 SUM : 4812225 rocksdb.numfiles.in.singlecompaction P50 : 3.266667 P95 : 5.400000 P99 : 23.000000 P100 : 23.000000 COUNT : 26 SUM : 108 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.590557 P95 : 2276.930485 P99 : 2775.482395 P100 : 253819.000000 COUNT : 207086 SUM : 51464161 rocksdb.sst.read.micros P50 : 105.747425 P95 : 205.826732 P99 : 374.289705 P100 : 17389.000000 COUNT : 2652145 SUM : 247705380 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 : 1189996 SUM : 1189996000 rocksdb.bytes.per.write P50 : 1032.000000 P95 : 1032.000000 P99 : 1032.000000 P100 : 1032.000000 COUNT : 2141735 SUM : 2210270520 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 : 214137.931034 P95 : 418000.000000 P99 : 478045.000000 P100 : 478045.000000 COUNT : 32 SUM : 6953526 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 : 61 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