[2024-12-10 05:35:15.290775] Starting SPDK v25.01-pre git sha1 4fb5f9881 / DPDK 24.03.0 initialization... [2024-12-10 05:35:15.290918] [ 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_pid1547077 ] Set seed to 1733805315288145 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-10 05:35:15.430843] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-10 05:35:15.535306] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-10 05:35:15.535360] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1547077' to capture a snapshot of events at runtime. [2024-12-10 05:35:15.535373] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-10 05:35:15.535386] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-10 05:35:15.535396] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1547077 for offline analysis/debug. [2024-12-10 05:35:15.536719] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Tue Dec 10 05:35:18 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/12/10-05:35:21 ... thread 0: (1000000,1000000) ops and (338148.9,338148.9) ops/second in (2.957277,2.957277) 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 8/5 503.31 MB 18.9 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 346.8 2.54 2.37 13 0.195 0 0 0.0 0.0 L1 1/0 10.97 MB 1.1 0.2 0.2 0.0 0.2 0.2 0.1 1.0 235.3 234.4 1.07 1.03 1 1.069 255K 999 0.0 0.0 L2 3/2 279.73 MB 1.1 0.3 0.1 0.1 0.3 0.1 0.2 2.1 250.7 250.3 1.03 1.00 2 0.516 262K 395 0.0 0.0 L3 18/12 939.04 MB 0.1 0.1 0.1 0.0 0.1 0.1 0.0 1.0 234.5 234.5 0.51 0.49 1 0.512 122K 0 0.0 0.0 L4 116/0 9.41 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.98 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 258/19 20.09 GB 0.0 0.6 0.5 0.1 1.5 1.3 0.4 1.7 122.3 293.0 5.15 4.89 17 0.303 639K 1394 0.0 0.0 Int 0/0 0.00 KB 0.0 0.6 0.5 0.1 1.5 1.3 0.4 1.7 122.3 293.0 5.15 4.89 17 0.303 639K 1394 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.6 0.5 0.1 0.6 0.5 0.0 0.0 241.2 240.7 2.61 2.52 4 0.653 639K 1394 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 346.8 2.54 2.37 13 0.195 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.0 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.47 GB write, 496.95 MB/s write, 0.62 GB read, 207.49 MB/s read, 5.2 seconds Interval compaction: 1.47 GB write, 510.22 MB/s write, 0.62 GB read, 213.02 MB/s read, 5.2 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: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 134777 Average: 2.0844 StdDev: 5.76 Min: 0 Median: 1.4177 Max: 1353 Percentiles: P50: 1.42 P75: 1.82 P99: 5.87 P99.9: 13.20 P99.99: 173.48 ------------------------------------------------------ [ 0, 1 ] 32345 23.999% 23.999% ##### ( 1, 2 ] 83906 62.255% 86.254% ############ ( 2, 3 ] 11308 8.390% 94.644% ## ( 3, 4 ] 3658 2.714% 97.359% # ( 4, 6 ] 2364 1.754% 99.113% ( 6, 10 ] 903 0.670% 99.783% ( 10, 15 ] 249 0.185% 99.967% ( 15, 22 ] 19 0.014% 99.981% ( 22, 34 ] 6 0.004% 99.986% ( 34, 51 ] 2 0.001% 99.987% ( 51, 76 ] 2 0.001% 99.989% ( 76, 110 ] 2 0.001% 99.990% ( 170, 250 ] 12 0.009% 99.999% ( 250, 380 ] 6 0.004% 100.004% ( 380, 580 ] 7 0.005% 100.009% ( 1300, 1900 ] 1 0.001% 100.010% ** Level 1 read latency histogram (micros): Count: 808 Average: 6.6386 StdDev: 40.44 Min: 1 Median: 2.6454 Max: 813 Percentiles: P50: 2.65 P75: 3.71 P99: 24.76 P99.9: 635.68 P99.99: 813.00 ------------------------------------------------------ [ 0, 1 ] 6 0.743% 0.743% ( 1, 2 ] 216 26.733% 27.475% ##### ( 2, 3 ] 282 34.901% 62.376% ####### ( 3, 4 ] 143 17.698% 80.074% #### ( 4, 6 ] 88 10.891% 90.965% ## ( 6, 10 ] 38 4.703% 95.668% # ( 10, 15 ] 22 2.723% 98.391% # ( 15, 22 ] 4 0.495% 98.886% ( 22, 34 ] 4 0.495% 99.381% ( 51, 76 ] 1 0.124% 99.505% ( 380, 580 ] 3 0.371% 99.876% ( 580, 870 ] 1 0.124% 100.000% ** Level 2 read latency histogram (micros): Count: 64244 Average: 2.3361 StdDev: 19.20 Min: 0 Median: 1.4346 Max: 4376 Percentiles: P50: 1.43 P75: 1.83 P99: 6.87 P99.9: 97.04 P99.99: 316.97 ------------------------------------------------------ [ 0, 1 ] 14455 22.500% 22.500% ##### ( 1, 2 ] 40650 63.274% 85.775% ############# ( 2, 3 ] 5051 7.862% 93.637% ## ( 3, 4 ] 1947 3.031% 96.667% # ( 4, 6 ] 1375 2.140% 98.808% ( 6, 10 ] 570 0.887% 99.695% ( 10, 15 ] 101 0.157% 99.852% ( 15, 22 ] 12 0.019% 99.871% ( 22, 34 ] 4 0.006% 99.877% ( 34, 51 ] 2 0.003% 99.880% ( 51, 76 ] 1 0.002% 99.882% ( 76, 110 ] 19 0.030% 99.911% ( 110, 170 ] 30 0.047% 99.958% ( 170, 250 ] 18 0.028% 99.986% ( 250, 380 ] 5 0.008% 99.994% ( 380, 580 ] 2 0.003% 99.997% ( 1300, 1900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 1298 Average: 99.6818 StdDev: 542.31 Min: 1 Median: 3.5784 Max: 5317 Percentiles: P50: 3.58 P75: 5.41 P99: 3363.85 P99.9: 5317.00 P99.99: 5317.00 ------------------------------------------------------ [ 0, 1 ] 15 1.156% 1.156% ( 1, 2 ] 116 8.937% 10.092% ## ( 2, 3 ] 364 28.043% 38.136% ###### ( 3, 4 ] 268 20.647% 58.783% #### ( 4, 6 ] 299 23.035% 81.818% ##### ( 6, 10 ] 83 6.394% 88.213% # ( 10, 15 ] 21 1.618% 89.831% ( 15, 22 ] 14 1.079% 90.909% ( 22, 34 ] 4 0.308% 91.217% ( 110, 170 ] 56 4.314% 95.532% # ( 170, 250 ] 16 1.233% 96.764% ( 250, 380 ] 6 0.462% 97.227% ( 380, 580 ] 2 0.154% 97.381% ( 580, 870 ] 2 0.154% 97.535% ( 870, 1300 ] 4 0.308% 97.843% ( 1300, 1900 ] 3 0.231% 98.074% ( 1900, 2900 ] 9 0.693% 98.767% ( 2900, 4400 ] 13 1.002% 99.769% ( 4400, 6600 ] 6 0.462% 100.231% ** Level 4 read latency histogram (micros): Count: 25 Average: 2329.9200 StdDev: 1383.72 Min: 107 Median: 2212.5000 Max: 4946 Percentiles: P50: 2212.50 P75: 3125.00 P99: 4946.00 P99.9: 4946.00 P99.99: 4946.00 ------------------------------------------------------ ( 76, 110 ] 2 8.000% 8.000% ## ( 170, 250 ] 1 4.000% 12.000% # ( 250, 380 ] 1 4.000% 16.000% # ( 870, 1300 ] 2 8.000% 24.000% ## ( 1300, 1900 ] 4 16.000% 40.000% ### ( 1900, 2900 ] 8 32.000% 72.000% ###### ( 2900, 4400 ] 5 20.000% 92.000% #### ( 4400, 6600 ] 2 8.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.0 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 324.00 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.155 H:M:S, 5.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 332.56 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.155 H:M:S, 5.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/10-05:35:24 ... thread 0: (1000000,2000000) ops and (343048.6,340581.1) ops/second in (2.915039,5.872316) 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/4 1.41 GB 119.0 1.0 0.0 1.0 2.8 1.8 0.0 1.6 114.3 308.6 9.36 8.90 32 0.292 1086K 5600 0.0 0.0 L1 1/0 10.97 MB 1.1 0.2 0.2 0.0 0.2 0.2 0.1 1.0 235.3 234.4 1.07 1.03 1 1.069 255K 999 0.0 0.0 L2 1/1 40.25 MB 0.0 0.3 0.1 0.1 0.3 0.1 0.2 2.1 250.7 250.3 1.03 1.00 2 0.516 262K 395 0.0 0.0 L3 19/10 1.15 GB 0.4 0.5 0.4 0.1 0.5 0.3 0.0 1.4 228.6 227.9 2.19 2.13 3 0.731 509K 1525 0.0 0.0 L4 116/0 9.41 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.98 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 259/15 21.00 GB 0.0 2.0 0.7 1.3 3.8 2.5 0.4 2.1 152.4 285.4 13.65 13.06 38 0.359 2113K 8519 0.0 0.0 Int 0/0 0.00 KB 0.0 2.0 0.7 1.3 3.8 2.5 0.4 2.1 152.4 285.4 13.65 13.06 38 0.359 2113K 8519 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.0 0.7 1.3 2.0 0.7 0.0 0.0 244.5 243.4 8.51 8.30 10 0.851 2113K 8519 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 355.0 5.14 4.76 28 0.184 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.0 total, 5.9 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: 3.81 GB write, 654.61 MB/s write, 2.03 GB read, 349.57 MB/s read, 13.7 seconds Interval compaction: 3.81 GB write, 663.41 MB/s write, 2.03 GB read, 354.27 MB/s read, 13.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 397431 Average: 2.4106 StdDev: 6.19 Min: 0 Median: 1.6141 Max: 1353 Percentiles: P50: 1.61 P75: 2.06 P99: 6.60 P99.9: 13.30 P99.99: 20.18 ------------------------------------------------------ [ 0, 1 ] 46748 11.763% 11.763% ## ( 1, 2 ] 247483 62.271% 74.033% ############ ( 2, 3 ] 63711 16.031% 90.064% ### ( 3, 4 ] 19763 4.973% 95.037% # ( 4, 6 ] 15224 3.831% 98.867% # ( 6, 10 ] 3513 0.884% 99.751% ( 10, 15 ] 896 0.225% 99.977% ( 15, 22 ] 72 0.018% 99.995% ( 22, 34 ] 11 0.003% 99.997% ( 34, 51 ] 3 0.001% 99.998% ( 51, 76 ] 7 0.002% 100.000% ( 76, 110 ] 2 0.001% 100.001% ( 170, 250 ] 27 0.007% 100.007% ( 250, 380 ] 11 0.003% 100.010% ( 380, 580 ] 17 0.004% 100.014% ( 580, 870 ] 3 0.001% 100.015% ( 870, 1300 ] 5 0.001% 100.016% ( 1300, 1900 ] 1 0.000% 100.017% ** Level 1 read latency histogram (micros): Count: 60825 Average: 2.7034 StdDev: 5.12 Min: 1 Median: 1.7955 Max: 813 Percentiles: P50: 1.80 P75: 2.56 P99: 8.06 P99.9: 14.25 P99.99: 74.97 ------------------------------------------------------ [ 0, 1 ] 1739 2.859% 2.859% # ( 1, 2 ] 36044 59.259% 62.118% ############ ( 2, 3 ] 13943 22.923% 85.041% ##### ( 3, 4 ] 4481 7.367% 92.408% # ( 4, 6 ] 3583 5.891% 98.298% # ( 6, 10 ] 827 1.360% 99.658% ( 10, 15 ] 173 0.284% 99.942% ( 15, 22 ] 20 0.033% 99.975% ( 22, 34 ] 7 0.012% 99.987% ( 51, 76 ] 2 0.003% 99.990% ( 76, 110 ] 1 0.002% 99.992% ( 380, 580 ] 4 0.007% 99.998% ( 580, 870 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 65437 Average: 2.5165 StdDev: 20.14 Min: 0 Median: 1.4438 Max: 4376 Percentiles: P50: 1.44 P75: 1.84 P99: 7.28 P99.9: 155.97 P99.99: 438.25 ------------------------------------------------------ [ 0, 1 ] 14461 22.099% 22.099% #### ( 1, 2 ] 41141 62.871% 84.970% ############# ( 2, 3 ] 5525 8.443% 93.414% ## ( 3, 4 ] 2025 3.095% 96.508% # ( 4, 6 ] 1442 2.204% 98.712% ( 6, 10 ] 588 0.899% 99.610% ( 10, 15 ] 101 0.154% 99.765% ( 15, 22 ] 12 0.018% 99.783% ( 22, 34 ] 4 0.006% 99.789% ( 34, 51 ] 2 0.003% 99.792% ( 51, 76 ] 1 0.002% 99.794% ( 76, 110 ] 19 0.029% 99.823% ( 110, 170 ] 66 0.101% 99.924% ( 170, 250 ] 29 0.044% 99.968% ( 250, 380 ] 13 0.020% 99.988% ( 380, 580 ] 5 0.008% 99.995% ( 580, 870 ] 1 0.002% 99.997% ( 1300, 1900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 220555 Average: 3.4160 StdDev: 42.97 Min: 1 Median: 1.6985 Max: 5317 Percentiles: P50: 1.70 P75: 2.34 P99: 9.20 P99.9: 150.58 P99.99: 498.89 ------------------------------------------------------ [ 0, 1 ] 13273 6.018% 6.018% # ( 1, 2 ] 138883 62.970% 68.988% ############# ( 2, 3 ] 39190 17.769% 86.757% #### ( 3, 4 ] 13319 6.039% 92.795% # ( 4, 6 ] 10228 4.637% 97.433% # ( 6, 10 ] 4326 1.961% 99.394% ( 10, 15 ] 564 0.256% 99.650% ( 15, 22 ] 56 0.025% 99.675% ( 22, 34 ] 11 0.005% 99.680% ( 34, 51 ] 168 0.076% 99.757% ( 51, 76 ] 89 0.040% 99.797% ( 76, 110 ] 56 0.025% 99.822% ( 110, 170 ] 255 0.116% 99.938% ( 170, 250 ] 85 0.039% 99.976% ( 250, 380 ] 25 0.011% 99.988% ( 380, 580 ] 10 0.005% 99.992% ( 580, 870 ] 4 0.002% 99.994% ( 870, 1300 ] 5 0.002% 99.996% ( 1300, 1900 ] 3 0.001% 99.998% ( 1900, 2900 ] 9 0.004% 100.002% ( 2900, 4400 ] 13 0.006% 100.008% ( 4400, 6600 ] 6 0.003% 100.010% ** Level 4 read latency histogram (micros): Count: 25 Average: 2329.9200 StdDev: 1383.72 Min: 107 Median: 2212.5000 Max: 4946 Percentiles: P50: 2212.50 P75: 3125.00 P99: 4946.00 P99.9: 4946.00 P99.99: 4946.00 ------------------------------------------------------ ( 76, 110 ] 2 8.000% 8.000% ## ( 170, 250 ] 1 4.000% 12.000% # ( 250, 380 ] 1 4.000% 16.000% # ( 870, 1300 ] 2 8.000% 24.000% ## ( 1300, 1900 ] 4 16.000% 40.000% ### ( 1900, 2900 ] 8 32.000% 72.000% ###### ( 2900, 4400 ] 5 20.000% 92.000% #### ( 4400, 6600 ] 2 8.000% 100.000% ## ** DB Stats ** Uptime(secs): 6.0 total, 2.9 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 330.68 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.155 H:M:S, 2.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 337.64 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/10-05:35:27 ... thread 0: (1000000,3000000) ops and (328476.9,336448.5) ops/second in (3.044354,8.916670) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/4 2.38 GB 219.0 2.1 0.0 2.1 4.8 2.8 0.0 1.8 131.7 305.3 16.24 15.48 51 0.318 2171K 11K 0.0 0.0 L1 1/0 10.97 MB 1.1 0.2 0.2 0.0 0.2 0.2 0.1 1.0 235.3 234.4 1.07 1.03 1 1.069 255K 999 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.1 0.1 0.3 0.1 0.2 2.1 250.7 250.3 1.03 1.00 2 0.516 262K 395 0.0 0.0 L3 17/0 779.49 MB 0.8 1.3 0.4 0.9 1.3 0.4 0.0 3.4 240.6 239.4 5.65 5.44 4 1.413 1381K 6884 0.0 0.0 L4 123/0 9.53 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 213.7 213.7 0.82 0.78 1 0.818 177K 0 0.0 0.0 L5 116/0 9.29 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 270/4 21.97 GB 0.0 4.1 0.9 3.2 6.8 3.7 0.9 2.5 168.6 281.9 24.81 23.73 59 0.421 4249K 19K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.1 0.9 3.2 6.8 3.7 0.9 2.5 168.6 281.9 24.81 23.73 59 0.421 4249K 19K 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.9 3.2 4.1 0.9 0.0 0.0 247.6 246.4 16.90 16.41 16 1.056 4249K 19K 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 357.8 7.91 7.32 43 0.184 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.0 total, 8.9 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.83 GB write, 777.54 MB/s write, 4.09 GB read, 465.08 MB/s read, 24.8 seconds Interval compaction: 6.83 GB write, 784.42 MB/s write, 4.09 GB read, 469.20 MB/s read, 24.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 658560 Average: 2.3266 StdDev: 6.50 Min: 0 Median: 1.5727 Max: 1702 Percentiles: P50: 1.57 P75: 1.96 P99: 5.97 P99.9: 12.90 P99.99: 20.76 ------------------------------------------------------ [ 0, 1 ] 87482 13.284% 13.284% ### ( 1, 2 ] 422175 64.106% 77.390% ############# ( 2, 3 ] 94779 14.392% 91.781% ### ( 3, 4 ] 27820 4.224% 96.006% # ( 4, 6 ] 20006 3.038% 99.044% # ( 6, 10 ] 4938 0.750% 99.793% ( 10, 15 ] 1212 0.184% 99.978% ( 15, 22 ] 101 0.015% 99.993% ( 22, 34 ] 18 0.003% 99.996% ( 34, 51 ] 6 0.001% 99.997% ( 51, 76 ] 12 0.002% 99.998% ( 76, 110 ] 2 0.000% 99.999% ( 170, 250 ] 41 0.006% 100.005% ( 250, 380 ] 22 0.003% 100.008% ( 380, 580 ] 21 0.003% 100.011% ( 580, 870 ] 6 0.001% 100.012% ( 870, 1300 ] 10 0.002% 100.014% ( 1300, 1900 ] 2 0.000% 100.014% ** Level 1 read latency histogram (micros): Count: 60825 Average: 2.7034 StdDev: 5.12 Min: 1 Median: 1.7955 Max: 813 Percentiles: P50: 1.80 P75: 2.56 P99: 8.06 P99.9: 14.25 P99.99: 74.97 ------------------------------------------------------ [ 0, 1 ] 1739 2.859% 2.859% # ( 1, 2 ] 36044 59.259% 62.118% ############ ( 2, 3 ] 13943 22.923% 85.041% ##### ( 3, 4 ] 4481 7.367% 92.408% # ( 4, 6 ] 3583 5.891% 98.298% # ( 6, 10 ] 827 1.360% 99.658% ( 10, 15 ] 173 0.284% 99.942% ( 15, 22 ] 20 0.033% 99.975% ( 22, 34 ] 7 0.012% 99.987% ( 51, 76 ] 2 0.003% 99.990% ( 76, 110 ] 1 0.002% 99.992% ( 380, 580 ] 4 0.007% 99.998% ( 580, 870 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 74458 Average: 2.5794 StdDev: 19.27 Min: 0 Median: 1.4781 Max: 4376 Percentiles: P50: 1.48 P75: 1.88 P99: 7.66 P99.9: 157.95 P99.99: 452.98 ------------------------------------------------------ [ 0, 1 ] 14864 19.963% 19.963% #### ( 1, 2 ] 46779 62.826% 82.789% ############# ( 2, 3 ] 7245 9.730% 92.519% ## ( 3, 4 ] 2621 3.520% 96.039% # ( 4, 6 ] 1880 2.525% 98.564% # ( 6, 10 ] 781 1.049% 99.613% ( 10, 15 ] 114 0.153% 99.766% ( 15, 22 ] 12 0.016% 99.782% ( 22, 34 ] 4 0.005% 99.788% ( 34, 51 ] 2 0.003% 99.790% ( 51, 76 ] 1 0.001% 99.792% ( 76, 110 ] 19 0.026% 99.817% ( 110, 170 ] 77 0.103% 99.921% ( 170, 250 ] 34 0.046% 99.966% ( 250, 380 ] 15 0.020% 99.987% ( 380, 580 ] 7 0.009% 99.996% ( 580, 870 ] 1 0.001% 99.997% ( 1300, 1900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 288473 Average: 3.2860 StdDev: 37.87 Min: 0 Median: 1.6865 Max: 5317 Percentiles: P50: 1.69 P75: 2.29 P99: 9.24 P99.9: 153.68 P99.99: 435.37 ------------------------------------------------------ [ 0, 1 ] 18647 6.464% 6.464% # ( 1, 2 ] 182952 63.421% 69.885% ############# ( 2, 3 ] 51213 17.753% 87.638% #### ( 3, 4 ] 15832 5.488% 93.126% # ( 4, 6 ] 12341 4.278% 97.404% # ( 6, 10 ] 5675 1.967% 99.372% ( 10, 15 ] 839 0.291% 99.662% ( 15, 22 ] 93 0.032% 99.695% ( 22, 34 ] 19 0.007% 99.701% ( 34, 51 ] 168 0.058% 99.759% ( 51, 76 ] 89 0.031% 99.790% ( 76, 110 ] 77 0.027% 99.817% ( 110, 170 ] 329 0.114% 99.931% ( 170, 250 ] 115 0.040% 99.971% ( 250, 380 ] 51 0.018% 99.989% ( 380, 580 ] 15 0.005% 99.994% ( 580, 870 ] 4 0.001% 99.995% ( 870, 1300 ] 5 0.002% 99.997% ( 1300, 1900 ] 3 0.001% 99.998% ( 1900, 2900 ] 9 0.003% 100.001% ( 2900, 4400 ] 13 0.005% 100.006% ( 4400, 6600 ] 6 0.002% 100.008% ** Level 4 read latency histogram (micros): Count: 60 Average: 1001.2333 StdDev: 1436.39 Min: 1 Median: 140.0000 Max: 4946 Percentiles: P50: 140.00 P75: 1900.00 P99: 4946.00 P99.9: 4946.00 P99.99: 4946.00 ------------------------------------------------------ [ 0, 1 ] 9 15.000% 15.000% ### ( 1, 2 ] 12 20.000% 35.000% #### ( 2, 3 ] 1 1.667% 36.667% ( 10, 15 ] 2 3.333% 40.000% # ( 22, 34 ] 1 1.667% 41.667% ( 76, 110 ] 2 3.333% 45.000% # ( 110, 170 ] 6 10.000% 55.000% ## ( 170, 250 ] 3 5.000% 60.000% # ( 250, 380 ] 3 5.000% 65.000% # ( 870, 1300 ] 2 3.333% 68.333% # ( 1300, 1900 ] 4 6.667% 75.000% # ( 1900, 2900 ] 8 13.333% 88.333% ### ( 2900, 4400 ] 5 8.333% 96.667% ## ( 4400, 6600 ] 2 3.333% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 405.0500 StdDev: 486.08 Min: 98 Median: 152.8571 Max: 1966 Percentiles: P50: 152.86 P75: 580.00 P99: 1966.00 P99.9: 1966.00 P99.99: 1966.00 ------------------------------------------------------ ( 76, 110 ] 5 25.000% 25.000% ##### ( 110, 170 ] 7 35.000% 60.000% ####### ( 250, 380 ] 2 10.000% 70.000% ## ( 380, 580 ] 1 5.000% 75.000% # ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 3 15.000% 95.000% ### ( 1900, 2900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 9.0 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 328.18 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.334 H:M:S, 3.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 323.28 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.179 H:M:S, 5.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/10-05:35:30 ... thread 0: (1000000,4000000) ops and (356637.2,341278.3) ops/second in (2.803970,11.720640) 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/8 3.30 GB 287.9 2.8 0.0 2.8 6.5 3.7 0.0 1.8 133.8 307.6 21.63 20.64 69 0.313 2938K 14K 0.0 0.0 L1 1/0 10.97 MB 1.1 0.2 0.2 0.0 0.2 0.2 0.1 1.0 235.3 234.4 1.07 1.03 1 1.069 255K 999 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.1 0.1 0.3 0.1 0.2 2.1 250.7 250.3 1.03 1.00 2 0.516 262K 395 0.0 0.0 L3 17/0 779.49 MB 0.8 1.3 0.4 0.9 1.3 0.4 0.0 3.4 240.6 239.4 5.65 5.44 4 1.413 1381K 6884 0.0 0.0 L4 123/0 9.53 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 213.7 213.7 0.82 0.78 1 0.818 177K 0 0.0 0.0 L5 116/0 9.29 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 276/8 22.89 GB 0.0 4.8 0.9 3.9 8.5 4.6 0.9 2.3 163.5 287.7 30.20 28.89 77 0.392 5015K 23K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.8 0.9 3.9 8.5 4.6 0.9 2.3 163.5 287.7 30.20 28.89 77 0.392 5015K 23K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.8 0.9 3.9 4.8 0.9 0.0 0.0 249.9 248.7 19.77 19.23 19 1.040 5015K 23K 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 361.7 10.43 9.66 58 0.180 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 11.8 total, 11.7 interval Flush(GB): cumulative 3.686, interval 3.686 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.49 GB write, 736.41 MB/s write, 4.82 GB read, 418.55 MB/s read, 30.2 seconds Interval compaction: 8.49 GB write, 741.37 MB/s write, 4.82 GB read, 421.37 MB/s read, 30.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 901770 Average: 2.2532 StdDev: 6.27 Min: 0 Median: 1.5345 Max: 1702 Percentiles: P50: 1.53 P75: 1.92 P99: 5.89 P99.9: 12.73 P99.99: 20.65 ------------------------------------------------------ [ 0, 1 ] 138412 15.349% 15.349% ### ( 1, 2 ] 584586 64.827% 80.175% ############# ( 2, 3 ] 115129 12.767% 92.942% ### ( 3, 4 ] 33134 3.674% 96.617% # ( 4, 6 ] 22768 2.525% 99.142% # ( 6, 10 ] 5984 0.664% 99.805% ( 10, 15 ] 1568 0.174% 99.979% ( 15, 22 ] 125 0.014% 99.993% ( 22, 34 ] 24 0.003% 99.996% ( 34, 51 ] 8 0.001% 99.996% ( 51, 76 ] 15 0.002% 99.998% ( 76, 110 ] 2 0.000% 99.998% ( 170, 250 ] 56 0.006% 100.005% ( 250, 380 ] 32 0.004% 100.008% ( 380, 580 ] 26 0.003% 100.011% ( 580, 870 ] 8 0.001% 100.012% ( 870, 1300 ] 14 0.002% 100.013% ( 1300, 1900 ] 2 0.000% 100.014% ** Level 1 read latency histogram (micros): Count: 60825 Average: 2.7034 StdDev: 5.12 Min: 1 Median: 1.7955 Max: 813 Percentiles: P50: 1.80 P75: 2.56 P99: 8.06 P99.9: 14.25 P99.99: 74.97 ------------------------------------------------------ [ 0, 1 ] 1739 2.859% 2.859% # ( 1, 2 ] 36044 59.259% 62.118% ############ ( 2, 3 ] 13943 22.923% 85.041% ##### ( 3, 4 ] 4481 7.367% 92.408% # ( 4, 6 ] 3583 5.891% 98.298% # ( 6, 10 ] 827 1.360% 99.658% ( 10, 15 ] 173 0.284% 99.942% ( 15, 22 ] 20 0.033% 99.975% ( 22, 34 ] 7 0.012% 99.987% ( 51, 76 ] 2 0.003% 99.990% ( 76, 110 ] 1 0.002% 99.992% ( 380, 580 ] 4 0.007% 99.998% ( 580, 870 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 74458 Average: 2.5794 StdDev: 19.27 Min: 0 Median: 1.4781 Max: 4376 Percentiles: P50: 1.48 P75: 1.88 P99: 7.66 P99.9: 157.95 P99.99: 452.98 ------------------------------------------------------ [ 0, 1 ] 14864 19.963% 19.963% #### ( 1, 2 ] 46779 62.826% 82.789% ############# ( 2, 3 ] 7245 9.730% 92.519% ## ( 3, 4 ] 2621 3.520% 96.039% # ( 4, 6 ] 1880 2.525% 98.564% # ( 6, 10 ] 781 1.049% 99.613% ( 10, 15 ] 114 0.153% 99.766% ( 15, 22 ] 12 0.016% 99.782% ( 22, 34 ] 4 0.005% 99.788% ( 34, 51 ] 2 0.003% 99.790% ( 51, 76 ] 1 0.001% 99.792% ( 76, 110 ] 19 0.026% 99.817% ( 110, 170 ] 77 0.103% 99.921% ( 170, 250 ] 34 0.046% 99.966% ( 250, 380 ] 15 0.020% 99.987% ( 380, 580 ] 7 0.009% 99.996% ( 580, 870 ] 1 0.001% 99.997% ( 1300, 1900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 288473 Average: 3.2860 StdDev: 37.87 Min: 0 Median: 1.6865 Max: 5317 Percentiles: P50: 1.69 P75: 2.29 P99: 9.24 P99.9: 153.68 P99.99: 435.37 ------------------------------------------------------ [ 0, 1 ] 18647 6.464% 6.464% # ( 1, 2 ] 182952 63.421% 69.885% ############# ( 2, 3 ] 51213 17.753% 87.638% #### ( 3, 4 ] 15832 5.488% 93.126% # ( 4, 6 ] 12341 4.278% 97.404% # ( 6, 10 ] 5675 1.967% 99.372% ( 10, 15 ] 839 0.291% 99.662% ( 15, 22 ] 93 0.032% 99.695% ( 22, 34 ] 19 0.007% 99.701% ( 34, 51 ] 168 0.058% 99.759% ( 51, 76 ] 89 0.031% 99.790% ( 76, 110 ] 77 0.027% 99.817% ( 110, 170 ] 329 0.114% 99.931% ( 170, 250 ] 115 0.040% 99.971% ( 250, 380 ] 51 0.018% 99.989% ( 380, 580 ] 15 0.005% 99.994% ( 580, 870 ] 4 0.001% 99.995% ( 870, 1300 ] 5 0.002% 99.997% ( 1300, 1900 ] 3 0.001% 99.998% ( 1900, 2900 ] 9 0.003% 100.001% ( 2900, 4400 ] 13 0.005% 100.006% ( 4400, 6600 ] 6 0.002% 100.008% ** Level 4 read latency histogram (micros): Count: 60 Average: 1001.2333 StdDev: 1436.39 Min: 1 Median: 140.0000 Max: 4946 Percentiles: P50: 140.00 P75: 1900.00 P99: 4946.00 P99.9: 4946.00 P99.99: 4946.00 ------------------------------------------------------ [ 0, 1 ] 9 15.000% 15.000% ### ( 1, 2 ] 12 20.000% 35.000% #### ( 2, 3 ] 1 1.667% 36.667% ( 10, 15 ] 2 3.333% 40.000% # ( 22, 34 ] 1 1.667% 41.667% ( 76, 110 ] 2 3.333% 45.000% # ( 110, 170 ] 6 10.000% 55.000% ## ( 170, 250 ] 3 5.000% 60.000% # ( 250, 380 ] 3 5.000% 65.000% # ( 870, 1300 ] 2 3.333% 68.333% # ( 1300, 1900 ] 4 6.667% 75.000% # ( 1900, 2900 ] 8 13.333% 88.333% ### ( 2900, 4400 ] 5 8.333% 96.667% ## ( 4400, 6600 ] 2 3.333% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 405.0500 StdDev: 486.08 Min: 98 Median: 152.8571 Max: 1966 Percentiles: P50: 152.86 P75: 580.00 P99: 1966.00 P99.9: 1966.00 P99.99: 1966.00 ------------------------------------------------------ ( 76, 110 ] 5 25.000% 25.000% ##### ( 110, 170 ] 7 35.000% 60.000% ####### ( 250, 380 ] 2 10.000% 70.000% ## ( 380, 580 ] 1 5.000% 75.000% # ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 3 15.000% 95.000% ### ( 1900, 2900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 11.8 total, 2.8 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 333.60 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.334 H:M:S, 2.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 351.00 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 20000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 19378.7 MB (estimated) FileSize: 19378.7 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 4.228 micros/op 236544 ops/sec 20.123 seconds 4759999 operations; 229.2 MB/s Microseconds per write: Count: 4759999 Average: 4.2275 StdDev: 118.59 Min: 0 Median: 1.7669 Max: 179601 Percentiles: P50: 1.77 P75: 3.06 P99: 8.68 P99.9: 165.23 P99.99: 2622.25 ------------------------------------------------------ [ 0, 1 ] 625177 13.134% 13.134% ### ( 1, 2 ] 2288078 48.069% 61.203% ########## ( 2, 3 ] 619488 13.014% 74.217% ### ( 3, 4 ] 650442 13.665% 87.882% ### ( 4, 6 ] 490415 10.303% 98.185% ## ( 6, 10 ] 57873 1.216% 99.401% ( 10, 15 ] 14193 0.298% 99.699% ( 15, 22 ] 4084 0.086% 99.785% ( 22, 34 ] 1185 0.025% 99.810% ( 34, 51 ] 181 0.004% 99.813% ( 51, 76 ] 45 0.001% 99.814% ( 76, 110 ] 11 0.000% 99.815% ( 110, 170 ] 4418 0.093% 99.907% ( 170, 250 ] 311 0.007% 99.914% ( 250, 380 ] 90 0.002% 99.916% ( 380, 580 ] 11 0.000% 99.916% ( 580, 870 ] 6 0.000% 99.916% ( 870, 1300 ] 2281 0.048% 99.964% ( 1300, 1900 ] 4 0.000% 99.964% ( 1900, 2900 ] 1703 0.036% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 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 : 168000 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 : 4759999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 4912318968 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 : 153 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 6389130 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 : 7809104602 rocksdb.compact.write.bytes COUNT : 7643053758 rocksdb.flush.write.bytes COUNT : 4881374896 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 : 0 rocksdb.number.superversion_releases COUNT : 0 rocksdb.number.superversion_cleanups COUNT : 0 rocksdb.number.block.compressed COUNT : 0 rocksdb.number.block.decompressed COUNT : 0 rocksdb.number.block.not_compressed COUNT : 0 rocksdb.merge.operation.time.nanos COUNT : 0 rocksdb.filter.operation.time.nanos COUNT : 0 rocksdb.row.cache.hit COUNT : 0 rocksdb.row.cache.miss COUNT : 0 rocksdb.read.amp.estimate.useful.bytes COUNT : 0 rocksdb.read.amp.total.read.bytes COUNT : 0 rocksdb.number.rate_limiter.drains COUNT : 0 rocksdb.number.iter.skip COUNT : 0 rocksdb.blobdb.num.put COUNT : 0 rocksdb.blobdb.num.write COUNT : 0 rocksdb.blobdb.num.get COUNT : 0 rocksdb.blobdb.num.multiget COUNT : 0 rocksdb.blobdb.num.seek COUNT : 0 rocksdb.blobdb.num.next COUNT : 0 rocksdb.blobdb.num.prev COUNT : 0 rocksdb.blobdb.num.keys.written COUNT : 0 rocksdb.blobdb.num.keys.read COUNT : 0 rocksdb.blobdb.bytes.written COUNT : 0 rocksdb.blobdb.bytes.read COUNT : 0 rocksdb.blobdb.write.inlined COUNT : 0 rocksdb.blobdb.write.inlined.ttl COUNT : 0 rocksdb.blobdb.write.blob COUNT : 0 rocksdb.blobdb.write.blob.ttl COUNT : 0 rocksdb.blobdb.blob.file.bytes.written COUNT : 0 rocksdb.blobdb.blob.file.bytes.read COUNT : 0 rocksdb.blobdb.blob.file.synced COUNT : 0 rocksdb.blobdb.blob.index.expired.count COUNT : 0 rocksdb.blobdb.blob.index.expired.size COUNT : 0 rocksdb.blobdb.blob.index.evicted.count COUNT : 0 rocksdb.blobdb.blob.index.evicted.size COUNT : 0 rocksdb.blobdb.gc.num.files COUNT : 0 rocksdb.blobdb.gc.num.new.files COUNT : 0 rocksdb.blobdb.gc.failures COUNT : 0 rocksdb.blobdb.gc.num.keys.relocated COUNT : 0 rocksdb.blobdb.gc.bytes.relocated COUNT : 0 rocksdb.blobdb.fifo.num.files.evicted COUNT : 0 rocksdb.blobdb.fifo.num.keys.evicted COUNT : 0 rocksdb.blobdb.fifo.bytes.evicted COUNT : 0 rocksdb.txn.overhead.mutex.prepare COUNT : 0 rocksdb.txn.overhead.mutex.old.commit.map COUNT : 0 rocksdb.txn.overhead.duplicate.key COUNT : 0 rocksdb.txn.overhead.mutex.snapshot COUNT : 0 rocksdb.txn.get.tryagain COUNT : 0 rocksdb.number.multiget.keys.found COUNT : 0 rocksdb.num.iterator.created COUNT : 0 rocksdb.num.iterator.deleted COUNT : 0 rocksdb.block.cache.compression.dict.miss COUNT : 0 rocksdb.block.cache.compression.dict.hit COUNT : 0 rocksdb.block.cache.compression.dict.add COUNT : 0 rocksdb.block.cache.compression.dict.bytes.insert COUNT : 0 rocksdb.block.cache.add.redundant COUNT : 0 rocksdb.block.cache.index.add.redundant COUNT : 0 rocksdb.block.cache.filter.add.redundant COUNT : 0 rocksdb.block.cache.data.add.redundant COUNT : 0 rocksdb.block.cache.compression.dict.add.redundant COUNT : 0 rocksdb.files.marked.trash COUNT : 0 rocksdb.files.deleted.immediately COUNT : 94 rocksdb.error.handler.bg.errro.count COUNT : 0 rocksdb.error.handler.bg.io.errro.count COUNT : 0 rocksdb.error.handler.bg.retryable.io.errro.count COUNT : 0 rocksdb.error.handler.autoresume.count COUNT : 0 rocksdb.error.handler.autoresume.retry.total.count COUNT : 0 rocksdb.error.handler.autoresume.success.count COUNT : 0 rocksdb.memtable.payload.bytes.at.flush COUNT : 4848812032 rocksdb.memtable.garbage.bytes.at.flush COUNT : 8093696 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 : 7848289392 rocksdb.non.last.level.read.count COUNT : 1893891 rocksdb.block.checksum.compute.count COUNT : 1893598 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.429840 P95 : 4.800460 P99 : 7.227992 P100 : 179595.000000 COUNT : 4759999 SUM : 17994643 rocksdb.compaction.times.micros P50 : 984666.666667 P95 : 1795000.000000 P99 : 3461029.000000 P100 : 3461029.000000 COUNT : 23 SUM : 23602766 rocksdb.compaction.times.cpu_micros P50 : 984666.666667 P95 : 1795000.000000 P99 : 3309858.000000 P100 : 3309858.000000 COUNT : 23 SUM : 22993169 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 : 538.139535 P95 : 1176.000000 P99 : 1176.000000 P100 : 1176.000000 COUNT : 72 SUM : 46312 rocksdb.compaction.outfile.sync.micros P50 : 695.256410 P95 : 1200.318182 P99 : 1474.000000 P100 : 1530.000000 COUNT : 71 SUM : 49014 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 : 103.127660 P95 : 333.107143 P99 : 346.000000 P100 : 346.000000 COUNT : 101 SUM : 13871 rocksdb.table.open.io.micros P50 : 773.937500 P95 : 13333.750000 P99 : 17108.000000 P100 : 17108.000000 COUNT : 153 SUM : 321138 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.535527 P95 : 5.997171 P99 : 9.897522 P100 : 7915.000000 COUNT : 1893205 SUM : 8307600 rocksdb.read.block.get.micros P50 : 346.363636 P95 : 3268.181818 P99 : 5496.000000 P100 : 5496.000000 COUNT : 306 SUM : 216654 rocksdb.write.raw.block.micros P50 : 0.511478 P95 : 0.971808 P99 : 2.998666 P100 : 3250.000000 COUNT : 3033610 SUM : 5770896 rocksdb.numfiles.in.singlecompaction P50 : 3.343750 P95 : 12.750000 P99 : 19.000000 P100 : 19.000000 COUNT : 29 SUM : 125 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.571525 P95 : 1955.640423 P99 : 2712.068155 P100 : 179315.000000 COUNT : 32186 SUM : 6392785 rocksdb.sst.read.micros P50 : 1.499227 P95 : 3.576433 P99 : 6.654202 P100 : 5317.000000 COUNT : 1894015 SUM : 4567469 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 : 4759999 SUM : 4912318968 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 : 174571.428571 P95 : 248628.571429 P99 : 342216.000000 P100 : 342216.000000 COUNT : 72 SUM : 12779193 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 : 94 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