[2024-12-10 12:17:36.418852] Starting SPDK v25.01-pre git sha1 d13942918 / DPDK 24.03.0 initialization... [2024-12-10 12:17:36.419017] [ 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_pid1784101 ] Set seed to 1733829456415380 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-10 12:17:36.559334] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-10 12:17:36.663861] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-10 12:17:36.663920] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1784101' to capture a snapshot of events at runtime. [2024-12-10 12:17:36.663933] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-10 12:17:36.663946] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-10 12:17:36.663955] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1784101 for offline analysis/debug. [2024-12-10 12:17:36.665200] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Tue Dec 10 12:17:39 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/12/10-12:17:46 ... thread 0: (1000000,1000000) ops and (148028.8,148028.8) ops/second in (6.755444,6.755444) 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/7 817.28 MB 25.1 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 135.2 6.05 2.45 10 0.605 0 0 0.0 0.0 L1 3/3 192.79 MB 0.0 0.3 0.2 0.1 0.3 0.2 0.0 1.2 110.3 109.7 2.55 1.46 1 2.547 285K 1603 0.0 0.0 L2 1/0 86.60 MB 0.9 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 L3 38/8 2.24 GB 1.7 3.0 2.1 0.8 2.9 2.0 0.0 1.3 106.5 102.6 28.53 15.50 12 2.378 2007K 5770 0.0 0.0 L4 161/19 11.67 GB 1.1 2.2 1.2 0.9 2.0 1.1 0.8 1.6 115.4 108.0 19.28 10.61 10 1.928 337K 0 0.0 0.0 L5 116/0 9.04 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 329/37 24.02 GB 0.0 5.4 3.6 1.8 6.0 4.1 0.9 7.5 98.3 108.2 56.41 30.02 33 1.709 2630K 7373 0.0 0.0 Int 0/0 0.00 KB 0.0 5.4 3.6 1.8 6.0 4.1 0.9 7.5 98.3 108.2 56.41 30.02 33 1.709 2630K 7373 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.4 3.6 1.8 5.2 3.4 0.0 0.0 110.1 105.0 50.36 27.57 23 2.190 2630K 7373 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 135.2 6.05 2.45 10 0.605 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.8 total, 6.8 interval Flush(GB): cumulative 0.798, interval 0.798 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.96 GB write, 894.85 MB/s write, 5.41 GB read, 812.66 MB/s read, 56.4 seconds Interval compaction: 5.96 GB write, 903.29 MB/s write, 5.41 GB read, 820.32 MB/s read, 56.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 13, interval: 13 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 188463 Average: 27.5677 StdDev: 310.58 Min: 1 Median: 2.1888 Max: 39576 Percentiles: P50: 2.19 P75: 3.21 P99: 698.44 P99.9: 4001.97 P99.99: 6508.02 ------------------------------------------------------ [ 0, 1 ] 3565 1.892% 1.892% ( 1, 2 ] 80606 42.770% 44.662% ######### ( 2, 3 ] 53277 28.269% 72.931% ###### ( 3, 4 ] 18770 9.960% 82.891% ## ( 4, 6 ] 21706 11.517% 94.408% ## ( 6, 10 ] 5592 2.967% 97.375% # ( 10, 15 ] 1109 0.588% 97.964% ( 15, 22 ] 170 0.090% 98.054% ( 22, 34 ] 9 0.005% 98.059% ( 34, 51 ] 16 0.008% 98.067% ( 51, 76 ] 16 0.008% 98.075% ( 76, 110 ] 2 0.001% 98.077% ( 110, 170 ] 31 0.016% 98.093% ( 170, 250 ] 132 0.070% 98.163% ( 250, 380 ] 369 0.196% 98.359% ( 380, 580 ] 851 0.452% 98.810% ( 580, 870 ] 875 0.464% 99.275% ( 870, 1300 ] 458 0.243% 99.518% ( 1300, 1900 ] 252 0.134% 99.651% ( 1900, 2900 ] 243 0.129% 99.780% ( 2900, 4400 ] 307 0.163% 99.943% ( 4400, 6600 ] 92 0.049% 99.992% ( 6600, 9900 ] 18 0.010% 100.002% ( 9900, 14000 ] 2 0.001% 100.003% ( 14000, 22000 ] 3 0.002% 100.004% ( 22000, 33000 ] 5 0.003% 100.007% ( 33000, 50000 ] 2 0.001% 100.008% ** Level 1 read latency histogram (micros): Count: 50818 Average: 19.9568 StdDev: 301.55 Min: 1 Median: 2.2848 Max: 32941 Percentiles: P50: 2.28 P75: 3.33 P99: 415.66 P99.9: 3775.43 P99.99: 7609.91 ------------------------------------------------------ [ 0, 1 ] 506 0.996% 0.996% ( 1, 2 ] 20591 40.519% 41.515% ######## ( 2, 3 ] 15142 29.797% 71.311% ###### ( 3, 4 ] 5646 11.110% 82.422% ## ( 4, 6 ] 6298 12.393% 94.815% ## ( 6, 10 ] 1633 3.213% 98.028% # ( 10, 15 ] 321 0.632% 98.660% ( 15, 22 ] 32 0.063% 98.723% ( 22, 34 ] 4 0.008% 98.731% ( 34, 51 ] 11 0.022% 98.752% ( 51, 76 ] 6 0.012% 98.764% ( 76, 110 ] 5 0.010% 98.774% ( 110, 170 ] 2 0.004% 98.778% ( 170, 250 ] 13 0.026% 98.804% ( 250, 380 ] 68 0.134% 98.937% ( 380, 580 ] 184 0.362% 99.299% ( 580, 870 ] 155 0.305% 99.604% ( 870, 1300 ] 52 0.102% 99.707% ( 1300, 1900 ] 22 0.043% 99.750% ( 1900, 2900 ] 48 0.094% 99.845% ( 2900, 4400 ] 50 0.098% 99.943% ( 4400, 6600 ] 24 0.047% 99.990% ( 6600, 9900 ] 3 0.006% 99.996% ( 14000, 22000 ] 2 0.004% 100.000% ( 22000, 33000 ] 2 0.004% 100.004% ** Level 2 read latency histogram (micros): Count: 470582 Average: 16.0266 StdDev: 293.82 Min: 1 Median: 2.3023 Max: 72385 Percentiles: P50: 2.30 P75: 3.35 P99: 13.48 P99.9: 1739.30 P99.99: 2845.93 ------------------------------------------------------ [ 0, 1 ] 4297 0.913% 0.913% ( 1, 2 ] 187967 39.944% 40.857% ######## ( 2, 3 ] 142343 30.248% 71.105% ###### ( 3, 4 ] 53010 11.265% 82.370% ## ( 4, 6 ] 60769 12.914% 95.283% ### ( 6, 10 ] 14905 3.167% 98.451% # ( 10, 15 ] 3711 0.789% 99.239% ( 15, 22 ] 566 0.120% 99.360% ( 22, 34 ] 100 0.021% 99.381% ( 34, 51 ] 133 0.028% 99.409% ( 51, 76 ] 86 0.018% 99.427% ( 76, 110 ] 40 0.009% 99.436% ( 110, 170 ] 37 0.008% 99.444% ( 170, 250 ] 89 0.019% 99.463% ( 250, 380 ] 305 0.065% 99.527% ( 380, 580 ] 663 0.141% 99.668% ( 580, 870 ] 579 0.123% 99.791% ( 870, 1300 ] 313 0.067% 99.858% ( 1300, 1900 ] 271 0.058% 99.915% ( 1900, 2900 ] 371 0.079% 99.994% ( 2900, 4400 ] 431 0.092% 100.086% ( 4400, 6600 ] 169 0.036% 100.122% ( 6600, 9900 ] 48 0.010% 100.132% ( 9900, 14000 ] 12 0.003% 100.135% ( 14000, 22000 ] 9 0.002% 100.136% ( 22000, 33000 ] 7 0.001% 100.138% ( 33000, 50000 ] 3 0.001% 100.139% ( 50000, 75000 ] 2 0.000% 100.139% ** Level 3 read latency histogram (micros): Count: 584949 Average: 18.9324 StdDev: 270.61 Min: 1 Median: 2.3398 Max: 40833 Percentiles: P50: 2.34 P75: 3.34 P99: 14.60 P99.9: 1477.03 P99.99: 2368.04 ------------------------------------------------------ [ 0, 1 ] 3805 0.650% 0.650% ( 1, 2 ] 225023 38.469% 39.119% ######## ( 2, 3 ] 187298 32.020% 71.139% ###### ( 3, 4 ] 65773 11.244% 82.383% ## ( 4, 6 ] 75018 12.825% 95.208% ### ( 6, 10 ] 18396 3.145% 98.353% # ( 10, 15 ] 4113 0.703% 99.056% ( 15, 22 ] 574 0.098% 99.154% ( 22, 34 ] 86 0.015% 99.169% ( 34, 51 ] 139 0.024% 99.192% ( 51, 76 ] 97 0.017% 99.209% ( 76, 110 ] 50 0.009% 99.218% ( 110, 170 ] 57 0.010% 99.227% ( 170, 250 ] 177 0.030% 99.258% ( 250, 380 ] 619 0.106% 99.363% ( 380, 580 ] 1233 0.211% 99.574% ( 580, 870 ] 1209 0.207% 99.781% ( 870, 1300 ] 588 0.101% 99.881% ( 1300, 1900 ] 373 0.064% 99.945% ( 1900, 2900 ] 563 0.096% 100.041% ( 2900, 4400 ] 717 0.123% 100.164% ( 4400, 6600 ] 254 0.043% 100.207% ( 6600, 9900 ] 40 0.007% 100.214% ( 9900, 14000 ] 4 0.001% 100.215% ( 14000, 22000 ] 19 0.003% 100.218% ( 22000, 33000 ] 11 0.002% 100.220% ( 33000, 50000 ] 4 0.001% 100.221% ** Level 4 read latency histogram (micros): Count: 440645 Average: 38.1055 StdDev: 411.13 Min: 1 Median: 2.3579 Max: 72350 Percentiles: P50: 2.36 P75: 3.46 P99: 751.71 P99.9: 3115.66 P99.99: 3626.72 ------------------------------------------------------ [ 0, 1 ] 3674 0.834% 0.834% ( 1, 2 ] 168079 38.144% 38.978% ######## ( 2, 3 ] 135722 30.801% 69.778% ###### ( 3, 4 ] 49753 11.291% 81.069% ## ( 4, 6 ] 56189 12.752% 93.821% ### ( 6, 10 ] 13274 3.012% 96.833% # ( 10, 15 ] 2962 0.672% 97.505% ( 15, 22 ] 346 0.079% 97.584% ( 22, 34 ] 35 0.008% 97.592% ( 34, 51 ] 80 0.018% 97.610% ( 51, 76 ] 82 0.019% 97.629% ( 76, 110 ] 42 0.010% 97.638% ( 110, 170 ] 95 0.022% 97.660% ( 170, 250 ] 408 0.093% 97.752% ( 250, 380 ] 1280 0.290% 98.043% ( 380, 580 ] 2666 0.605% 98.648% ( 580, 870 ] 2622 0.595% 99.243% ( 870, 1300 ] 1247 0.283% 99.526% ( 1300, 1900 ] 657 0.149% 99.675% ( 1900, 2900 ] 825 0.187% 99.862% ( 2900, 4400 ] 1164 0.264% 100.126% ( 4400, 6600 ] 352 0.080% 100.206% ( 6600, 9900 ] 63 0.014% 100.221% ( 9900, 14000 ] 7 0.002% 100.222% ( 14000, 22000 ] 17 0.004% 100.226% ( 22000, 33000 ] 12 0.003% 100.229% ( 33000, 50000 ] 3 0.001% 100.229% ( 50000, 75000 ] 5 0.001% 100.231% ** Level 5 read latency histogram (micros): Count: 7089 Average: 1233.3222 StdDev: 2179.72 Min: 108 Median: 686.6251 Max: 76712 Percentiles: P50: 686.63 P75: 1222.02 P99: 6396.07 P99.9: 27010.50 P99.99: 76712.00 ------------------------------------------------------ ( 76, 110 ] 1 0.014% 0.014% ( 110, 170 ] 33 0.466% 0.480% ( 170, 250 ] 218 3.075% 3.555% # ( 250, 380 ] 861 12.146% 15.700% ## ( 380, 580 ] 1798 25.363% 41.064% ##### ( 580, 870 ] 1723 24.305% 65.369% ##### ( 870, 1300 ] 834 11.765% 77.134% ## ( 1300, 1900 ] 358 5.050% 82.184% # ( 1900, 2900 ] 425 5.995% 88.179% # ( 2900, 4400 ] 592 8.351% 96.530% ## ( 4400, 6600 ] 193 2.723% 99.252% # ( 6600, 9900 ] 36 0.508% 99.760% ( 9900, 14000 ] 5 0.071% 99.831% ( 14000, 22000 ] 4 0.056% 99.887% ( 22000, 33000 ] 2 0.028% 99.915% ( 33000, 50000 ] 3 0.042% 99.958% ( 50000, 75000 ] 2 0.028% 99.986% ( 75000, 110000 ] 1 0.014% 100.000% ** DB Stats ** Uptime(secs): 6.8 total, 6.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 144.24 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.163 H:M:S, 31.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 145.57 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.163 H:M:S, 32.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/12/10-12:17:52 ... thread 0: (1000000,2000000) ops and (159668.9,153628.7) ops/second in (6.262960,13.018404) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/13 1.59 GB 18.9 0.6 0.0 0.6 2.5 1.8 0.0 1.3 36.4 145.3 17.28 9.19 26 0.665 638K 3657 0.0 0.0 L1 3/3 224.94 MB 0.0 0.7 0.5 0.2 0.7 0.5 0.0 1.5 101.9 101.1 7.12 3.77 2 3.560 736K 5191 0.0 0.0 L2 1/0 54.49 MB 0.5 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 L3 19/1 1021.34 MB 1.0 3.8 2.4 1.4 3.6 2.3 0.0 1.5 109.6 106.0 35.19 20.02 16 2.199 2837K 18K 0.0 0.0 L4 150/2 9.79 GB 1.0 8.0 2.5 5.5 7.0 1.5 1.0 2.8 124.0 108.0 65.99 38.11 30 2.200 1651K 49 0.0 0.0 L5 153/0 11.50 GB 0.1 0.0 0.0 0.0 0.0 0.0 2.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 341/19 24.15 GB 0.0 13.1 5.4 7.7 13.8 6.0 3.8 7.5 106.7 112.2 125.57 71.08 74 1.697 5863K 26K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.1 5.4 7.7 13.8 6.0 3.8 7.5 106.7 112.2 125.57 71.08 74 1.697 5863K 26K 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 13.1 5.4 7.7 11.9 4.2 0.0 0.0 118.4 107.8 113.15 65.23 50 2.263 5863K 26K 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 151.9 12.42 5.85 24 0.518 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): 13.1 total, 13.0 interval Flush(GB): cumulative 1.842, interval 1.842 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: 13.76 GB write, 1076.44 MB/s write, 13.08 GB read, 1023.59 MB/s read, 125.6 seconds Interval compaction: 13.76 GB write, 1081.71 MB/s write, 13.08 GB read, 1028.60 MB/s read, 125.6 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: 28, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 28, interval: 28 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 375217 Average: 31.1384 StdDev: 310.23 Min: 1 Median: 2.0770 Max: 39576 Percentiles: P50: 2.08 P75: 3.09 P99: 690.35 P99.9: 3776.04 P99.99: 6060.20 ------------------------------------------------------ [ 0, 1 ] 11523 3.071% 3.071% # ( 1, 2 ] 168509 44.910% 47.981% ######### ( 2, 3 ] 98402 26.225% 74.206% ##### ( 3, 4 ] 34100 9.088% 83.294% ## ( 4, 6 ] 37172 9.907% 93.201% ## ( 6, 10 ] 9646 2.571% 95.772% # ( 10, 15 ] 2029 0.541% 96.313% ( 15, 22 ] 272 0.072% 96.385% ( 22, 34 ] 18 0.005% 96.390% ( 34, 51 ] 25 0.007% 96.396% ( 51, 76 ] 26 0.007% 96.403% ( 76, 110 ] 27 0.007% 96.411% ( 110, 170 ] 847 0.226% 96.636% ( 170, 250 ] 3172 0.845% 97.482% ( 250, 380 ] 2458 0.655% 98.137% ( 380, 580 ] 2483 0.662% 98.799% ( 580, 870 ] 1989 0.530% 99.329% ( 870, 1300 ] 992 0.264% 99.593% ( 1300, 1900 ] 414 0.110% 99.703% ( 1900, 2900 ] 431 0.115% 99.818% ( 2900, 4400 ] 527 0.140% 99.959% ( 4400, 6600 ] 157 0.042% 100.001% ( 6600, 9900 ] 37 0.010% 100.010% ( 9900, 14000 ] 10 0.003% 100.013% ( 14000, 22000 ] 19 0.005% 100.018% ( 22000, 33000 ] 10 0.003% 100.021% ( 33000, 50000 ] 2 0.001% 100.021% ** Level 1 read latency histogram (micros): Count: 128507 Average: 27.9937 StdDev: 400.42 Min: 1 Median: 2.3756 Max: 49994 Percentiles: P50: 2.38 P75: 3.50 P99: 554.02 P99.9: 4083.37 P99.99: 11078.03 ------------------------------------------------------ [ 0, 1 ] 1199 0.933% 0.933% ( 1, 2 ] 48006 37.357% 38.290% ####### ( 2, 3 ] 40061 31.174% 69.464% ###### ( 3, 4 ] 14188 11.041% 80.505% ## ( 4, 6 ] 16597 12.915% 93.420% ### ( 6, 10 ] 4192 3.262% 96.682% # ( 10, 15 ] 923 0.718% 97.400% ( 15, 22 ] 116 0.090% 97.490% ( 22, 34 ] 10 0.008% 97.498% ( 34, 51 ] 27 0.021% 97.519% ( 51, 76 ] 27 0.021% 97.540% ( 76, 110 ] 18 0.014% 97.554% ( 110, 170 ] 159 0.124% 97.678% ( 170, 250 ] 603 0.469% 98.147% ( 250, 380 ] 554 0.431% 98.578% ( 380, 580 ] 624 0.486% 99.064% ( 580, 870 ] 502 0.391% 99.455% ( 870, 1300 ] 223 0.174% 99.628% ( 1300, 1900 ] 106 0.082% 99.711% ( 1900, 2900 ] 123 0.096% 99.806% ( 2900, 4400 ] 154 0.120% 99.926% ( 4400, 6600 ] 55 0.043% 99.969% ( 6600, 9900 ] 27 0.021% 99.990% ( 9900, 14000 ] 4 0.003% 99.993% ( 14000, 22000 ] 7 0.005% 99.998% ( 22000, 33000 ] 5 0.004% 100.002% ( 33000, 50000 ] 4 0.003% 100.005% ** Level 2 read latency histogram (micros): Count: 470582 Average: 16.0266 StdDev: 293.82 Min: 1 Median: 2.3023 Max: 72385 Percentiles: P50: 2.30 P75: 3.35 P99: 13.48 P99.9: 1739.30 P99.99: 2845.93 ------------------------------------------------------ [ 0, 1 ] 4297 0.913% 0.913% ( 1, 2 ] 187967 39.944% 40.857% ######## ( 2, 3 ] 142343 30.248% 71.105% ###### ( 3, 4 ] 53010 11.265% 82.370% ## ( 4, 6 ] 60769 12.914% 95.283% ### ( 6, 10 ] 14905 3.167% 98.451% # ( 10, 15 ] 3711 0.789% 99.239% ( 15, 22 ] 566 0.120% 99.360% ( 22, 34 ] 100 0.021% 99.381% ( 34, 51 ] 133 0.028% 99.409% ( 51, 76 ] 86 0.018% 99.427% ( 76, 110 ] 40 0.009% 99.436% ( 110, 170 ] 37 0.008% 99.444% ( 170, 250 ] 89 0.019% 99.463% ( 250, 380 ] 305 0.065% 99.527% ( 380, 580 ] 663 0.141% 99.668% ( 580, 870 ] 579 0.123% 99.791% ( 870, 1300 ] 313 0.067% 99.858% ( 1300, 1900 ] 271 0.058% 99.915% ( 1900, 2900 ] 371 0.079% 99.994% ( 2900, 4400 ] 431 0.092% 100.086% ( 4400, 6600 ] 169 0.036% 100.122% ( 6600, 9900 ] 48 0.010% 100.132% ( 9900, 14000 ] 12 0.003% 100.135% ( 14000, 22000 ] 9 0.002% 100.136% ( 22000, 33000 ] 7 0.001% 100.138% ( 33000, 50000 ] 3 0.001% 100.139% ( 50000, 75000 ] 2 0.000% 100.139% ** Level 3 read latency histogram (micros): Count: 943470 Average: 19.0557 StdDev: 276.40 Min: 1 Median: 2.3383 Max: 44158 Percentiles: P50: 2.34 P75: 3.36 P99: 156.85 P99.9: 1518.17 P99.99: 2500.07 ------------------------------------------------------ [ 0, 1 ] 7902 0.838% 0.838% ( 1, 2 ] 362497 38.422% 39.259% ######## ( 2, 3 ] 299508 31.745% 71.005% ###### ( 3, 4 ] 106061 11.242% 82.246% ## ( 4, 6 ] 119876 12.706% 94.952% ### ( 6, 10 ] 29709 3.149% 98.101% # ( 10, 15 ] 6802 0.721% 98.822% ( 15, 22 ] 883 0.094% 98.915% ( 22, 34 ] 116 0.012% 98.928% ( 34, 51 ] 228 0.024% 98.952% ( 51, 76 ] 159 0.017% 98.969% ( 76, 110 ] 78 0.008% 98.977% ( 110, 170 ] 277 0.029% 99.006% ( 170, 250 ] 1008 0.107% 99.113% ( 250, 380 ] 1483 0.157% 99.270% ( 380, 580 ] 2193 0.232% 99.503% ( 580, 870 ] 2295 0.243% 99.746% ( 870, 1300 ] 1241 0.132% 99.878% ( 1300, 1900 ] 579 0.061% 99.939% ( 1900, 2900 ] 801 0.085% 100.024% ( 2900, 4400 ] 1019 0.108% 100.132% ( 4400, 6600 ] 314 0.033% 100.165% ( 6600, 9900 ] 74 0.008% 100.173% ( 9900, 14000 ] 20 0.002% 100.175% ( 14000, 22000 ] 40 0.004% 100.179% ( 22000, 33000 ] 16 0.002% 100.181% ( 33000, 50000 ] 8 0.001% 100.182% ** Level 4 read latency histogram (micros): Count: 1461634 Average: 27.5986 StdDev: 373.42 Min: 1 Median: 2.3766 Max: 72350 Percentiles: P50: 2.38 P75: 3.50 P99: 435.49 P99.9: 1524.89 P99.99: 2157.03 ------------------------------------------------------ [ 0, 1 ] 13352 0.913% 0.913% ( 1, 2 ] 548699 37.540% 38.454% ######## ( 2, 3 ] 448118 30.659% 69.112% ###### ( 3, 4 ] 173204 11.850% 80.962% ## ( 4, 6 ] 192210 13.150% 94.113% ### ( 6, 10 ] 45774 3.132% 97.244% # ( 10, 15 ] 11324 0.775% 98.019% ( 15, 22 ] 1411 0.097% 98.116% ( 22, 34 ] 154 0.011% 98.126% ( 34, 51 ] 320 0.022% 98.148% ( 51, 76 ] 328 0.022% 98.171% ( 76, 110 ] 142 0.010% 98.180% ( 110, 170 ] 1256 0.086% 98.266% ( 170, 250 ] 4512 0.309% 98.575% ( 250, 380 ] 4531 0.310% 98.885% ( 380, 580 ] 6068 0.415% 99.300% ( 580, 870 ] 5494 0.376% 99.676% ( 870, 1300 ] 2758 0.189% 99.865% ( 1300, 1900 ] 1383 0.095% 99.959% ( 1900, 2900 ] 1754 0.120% 100.079% ( 2900, 4400 ] 2128 0.146% 100.225% ( 4400, 6600 ] 637 0.044% 100.268% ( 6600, 9900 ] 236 0.016% 100.285% ( 9900, 14000 ] 44 0.003% 100.288% ( 14000, 22000 ] 87 0.006% 100.294% ( 22000, 33000 ] 58 0.004% 100.297% ( 33000, 50000 ] 21 0.001% 100.299% ( 50000, 75000 ] 6 0.000% 100.299% ** Level 5 read latency histogram (micros): Count: 17805 Average: 922.7955 StdDev: 1966.18 Min: 94 Median: 494.4701 Max: 76712 Percentiles: P50: 494.47 P75: 846.16 P99: 5985.14 P99.9: 27857.50 P99.99: 71097.50 ------------------------------------------------------ ( 76, 110 ] 21 0.118% 0.118% ( 110, 170 ] 844 4.740% 4.858% # ( 170, 250 ] 2978 16.726% 21.584% ### ( 250, 380 ] 2975 16.709% 38.293% ### ( 380, 580 ] 3642 20.455% 58.748% #### ( 580, 870 ] 3153 17.709% 76.456% #### ( 870, 1300 ] 1560 8.762% 85.218% ## ( 1300, 1900 ] 575 3.229% 88.447% # ( 1900, 2900 ] 685 3.847% 92.294% # ( 2900, 4400 ] 985 5.532% 97.826% # ( 4400, 6600 ] 290 1.629% 99.455% ( 6600, 9900 ] 54 0.303% 99.758% ( 9900, 14000 ] 13 0.073% 99.832% ( 14000, 22000 ] 9 0.051% 99.882% ( 22000, 33000 ] 6 0.034% 99.916% ( 33000, 50000 ] 9 0.051% 99.966% ( 50000, 75000 ] 5 0.028% 99.994% ( 75000, 110000 ] 1 0.006% 100.000% ** DB Stats ** Uptime(secs): 13.1 total, 6.3 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 150.41 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:4.129 H:M:S, 31.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 157.15 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:1.967 H:M:S, 31.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/12/10-12:17:56 ... thread 0: (1000000,3000000) ops and (278485.5,180622.2) ops/second in (3.590851,16.609255) 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 16/9 2.57 GB 150.3 1.9 0.0 1.9 4.7 2.8 0.0 1.7 75.1 186.2 25.96 17.11 47 0.552 1979K 10K 0.0 0.0 L1 3/3 224.94 MB 0.0 0.7 0.5 0.2 0.7 0.5 0.0 1.5 101.9 101.1 7.12 3.77 2 3.560 736K 5191 0.0 0.0 L2 1/0 54.49 MB 0.5 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 L3 18/0 992.97 MB 1.0 3.8 2.4 1.4 3.6 2.3 0.0 1.5 109.6 106.0 35.19 20.02 16 2.199 2837K 18K 0.0 0.0 L4 146/0 9.48 GB 1.0 8.1 2.5 5.6 7.1 1.5 1.0 2.8 125.3 108.9 66.57 38.65 31 2.147 1680K 49 0.0 0.0 L5 157/0 11.81 GB 0.1 0.0 0.0 0.0 0.0 0.0 2.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 341/12 25.10 GB 0.0 14.5 5.4 9.1 16.1 7.0 4.1 5.7 110.3 122.6 134.83 79.54 96 1.405 7233K 33K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.5 5.4 9.1 16.1 7.0 4.1 5.7 110.3 122.6 134.83 79.54 96 1.405 7233K 33K 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 14.5 5.4 9.1 13.3 4.2 0.0 0.0 124.6 114.3 119.30 70.95 56 2.130 7233K 33K 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 186.2 15.53 8.59 40 0.388 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): 16.7 total, 16.6 interval Flush(GB): cumulative 2.825, interval 2.825 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: 16.15 GB write, 991.37 MB/s write, 14.52 GB read, 891.66 MB/s read, 134.8 seconds Interval compaction: 16.15 GB write, 995.18 MB/s write, 14.52 GB read, 895.08 MB/s read, 134.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: 28, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 28, interval: 28 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 667011 Average: 24.9542 StdDev: 235.83 Min: 0 Median: 1.7759 Max: 39576 Percentiles: P50: 1.78 P75: 2.72 P99: 438.37 P99.9: 2476.36 P99.99: 4087.76 ------------------------------------------------------ [ 0, 1 ] 70230 10.529% 10.529% ## ( 1, 2 ] 339316 50.871% 61.400% ########## ( 2, 3 ] 126428 18.954% 80.355% #### ( 3, 4 ] 41243 6.183% 86.538% # ( 4, 6 ] 41453 6.215% 92.753% # ( 6, 10 ] 10930 1.639% 94.391% ( 10, 15 ] 2364 0.354% 94.746% ( 15, 22 ] 302 0.045% 94.791% ( 22, 34 ] 35 0.005% 94.796% ( 34, 51 ] 26 0.004% 94.800% ( 51, 76 ] 29 0.004% 94.804% ( 76, 110 ] 276 0.041% 94.846% ( 110, 170 ] 6690 1.003% 95.849% ( 170, 250 ] 15293 2.293% 98.142% ( 250, 380 ] 4797 0.719% 98.861% ( 380, 580 ] 3186 0.478% 99.338% ( 580, 870 ] 2080 0.312% 99.650% ( 870, 1300 ] 1002 0.150% 99.800% ( 1300, 1900 ] 416 0.062% 99.863% ( 1900, 2900 ] 432 0.065% 99.928% ( 2900, 4400 ] 527 0.079% 100.007% ( 4400, 6600 ] 157 0.024% 100.030% ( 6600, 9900 ] 37 0.006% 100.036% ( 9900, 14000 ] 10 0.001% 100.037% ( 14000, 22000 ] 19 0.003% 100.040% ( 22000, 33000 ] 10 0.001% 100.042% ( 33000, 50000 ] 2 0.000% 100.042% ** Level 1 read latency histogram (micros): Count: 133234 Average: 31.6929 StdDev: 394.31 Min: 1 Median: 2.4162 Max: 49994 Percentiles: P50: 2.42 P75: 3.66 P99: 547.13 P99.9: 4037.33 P99.99: 10593.51 ------------------------------------------------------ [ 0, 1 ] 1214 0.911% 0.911% ( 1, 2 ] 48535 36.428% 37.340% ####### ( 2, 3 ] 40530 30.420% 67.760% ###### ( 3, 4 ] 14624 10.976% 78.736% ## ( 4, 6 ] 16835 12.636% 91.372% ### ( 6, 10 ] 4230 3.175% 94.546% # ( 10, 15 ] 947 0.711% 95.257% ( 15, 22 ] 124 0.093% 95.350% ( 22, 34 ] 14 0.011% 95.361% ( 34, 51 ] 28 0.021% 95.382% ( 51, 76 ] 27 0.020% 95.402% ( 76, 110 ] 49 0.037% 95.439% ( 110, 170 ] 925 0.694% 96.133% ( 170, 250 ] 2276 1.708% 97.841% ( 250, 380 ] 947 0.711% 98.552% ( 380, 580 ] 714 0.536% 99.088% ( 580, 870 ] 513 0.385% 99.473% ( 870, 1300 ] 223 0.167% 99.640% ( 1300, 1900 ] 106 0.080% 99.720% ( 1900, 2900 ] 123 0.092% 99.812% ( 2900, 4400 ] 154 0.116% 99.928% ( 4400, 6600 ] 55 0.041% 99.969% ( 6600, 9900 ] 27 0.020% 99.989% ( 9900, 14000 ] 4 0.003% 99.992% ( 14000, 22000 ] 7 0.005% 99.998% ( 22000, 33000 ] 5 0.004% 100.002% ( 33000, 50000 ] 4 0.003% 100.005% ** Level 2 read latency histogram (micros): Count: 470582 Average: 16.0266 StdDev: 293.82 Min: 1 Median: 2.3023 Max: 72385 Percentiles: P50: 2.30 P75: 3.35 P99: 13.48 P99.9: 1739.30 P99.99: 2845.93 ------------------------------------------------------ [ 0, 1 ] 4297 0.913% 0.913% ( 1, 2 ] 187967 39.944% 40.857% ######## ( 2, 3 ] 142343 30.248% 71.105% ###### ( 3, 4 ] 53010 11.265% 82.370% ## ( 4, 6 ] 60769 12.914% 95.283% ### ( 6, 10 ] 14905 3.167% 98.451% # ( 10, 15 ] 3711 0.789% 99.239% ( 15, 22 ] 566 0.120% 99.360% ( 22, 34 ] 100 0.021% 99.381% ( 34, 51 ] 133 0.028% 99.409% ( 51, 76 ] 86 0.018% 99.427% ( 76, 110 ] 40 0.009% 99.436% ( 110, 170 ] 37 0.008% 99.444% ( 170, 250 ] 89 0.019% 99.463% ( 250, 380 ] 305 0.065% 99.527% ( 380, 580 ] 663 0.141% 99.668% ( 580, 870 ] 579 0.123% 99.791% ( 870, 1300 ] 313 0.067% 99.858% ( 1300, 1900 ] 271 0.058% 99.915% ( 1900, 2900 ] 371 0.079% 99.994% ( 2900, 4400 ] 431 0.092% 100.086% ( 4400, 6600 ] 169 0.036% 100.122% ( 6600, 9900 ] 48 0.010% 100.132% ( 9900, 14000 ] 12 0.003% 100.135% ( 14000, 22000 ] 9 0.002% 100.136% ( 22000, 33000 ] 7 0.001% 100.138% ( 33000, 50000 ] 3 0.001% 100.139% ( 50000, 75000 ] 2 0.000% 100.139% ** Level 3 read latency histogram (micros): Count: 950993 Average: 19.9336 StdDev: 275.66 Min: 1 Median: 2.3447 Max: 44158 Percentiles: P50: 2.34 P75: 3.39 P99: 239.36 P99.9: 1509.33 P99.99: 2497.88 ------------------------------------------------------ [ 0, 1 ] 8000 0.841% 0.841% ( 1, 2 ] 364009 38.277% 39.118% ######## ( 2, 3 ] 300255 31.573% 70.691% ###### ( 3, 4 ] 106256 11.173% 81.864% ## ( 4, 6 ] 120049 12.624% 94.487% ### ( 6, 10 ] 29735 3.127% 97.614% # ( 10, 15 ] 6812 0.716% 98.330% ( 15, 22 ] 883 0.093% 98.423% ( 22, 34 ] 116 0.012% 98.436% ( 34, 51 ] 228 0.024% 98.460% ( 51, 76 ] 159 0.017% 98.476% ( 76, 110 ] 147 0.015% 98.492% ( 110, 170 ] 1583 0.166% 98.658% ( 170, 250 ] 3750 0.394% 99.052% ( 250, 380 ] 1973 0.207% 99.260% ( 380, 580 ] 2333 0.245% 99.505% ( 580, 870 ] 2311 0.243% 99.748% ( 870, 1300 ] 1241 0.130% 99.879% ( 1300, 1900 ] 579 0.061% 99.940% ( 1900, 2900 ] 801 0.084% 100.024% ( 2900, 4400 ] 1019 0.107% 100.131% ( 4400, 6600 ] 314 0.033% 100.164% ( 6600, 9900 ] 74 0.008% 100.172% ( 9900, 14000 ] 20 0.002% 100.174% ( 14000, 22000 ] 40 0.004% 100.178% ( 22000, 33000 ] 16 0.002% 100.180% ( 33000, 50000 ] 8 0.001% 100.181% ** Level 4 read latency histogram (micros): Count: 1498642 Average: 30.5199 StdDev: 369.65 Min: 1 Median: 2.4000 Max: 72350 Percentiles: P50: 2.40 P75: 3.60 P99: 445.83 P99.9: 1507.53 P99.99: 2153.07 ------------------------------------------------------ [ 0, 1 ] 13887 0.927% 0.927% ( 1, 2 ] 555215 37.048% 37.975% ####### ( 2, 3 ] 450560 30.065% 68.039% ###### ( 3, 4 ] 173794 11.597% 79.636% ## ( 4, 6 ] 192772 12.863% 92.499% ### ( 6, 10 ] 46003 3.070% 95.569% # ( 10, 15 ] 11349 0.757% 96.326% ( 15, 22 ] 1414 0.094% 96.420% ( 22, 34 ] 155 0.010% 96.431% ( 34, 51 ] 320 0.021% 96.452% ( 51, 76 ] 328 0.022% 96.474% ( 76, 110 ] 487 0.032% 96.506% ( 110, 170 ] 8517 0.568% 97.075% ( 170, 250 ] 19303 1.288% 98.363% ( 250, 380 ] 7271 0.485% 98.848% ( 380, 580 ] 6929 0.462% 99.310% ( 580, 870 ] 5600 0.374% 99.684% ( 870, 1300 ] 2761 0.184% 99.868% ( 1300, 1900 ] 1383 0.092% 99.960% ( 1900, 2900 ] 1755 0.117% 100.077% ( 2900, 4400 ] 2128 0.142% 100.219% ( 4400, 6600 ] 637 0.043% 100.262% ( 6600, 9900 ] 236 0.016% 100.278% ( 9900, 14000 ] 44 0.003% 100.281% ( 14000, 22000 ] 87 0.006% 100.286% ( 22000, 33000 ] 58 0.004% 100.290% ( 33000, 50000 ] 21 0.001% 100.292% ( 50000, 75000 ] 6 0.000% 100.292% ** Level 5 read latency histogram (micros): Count: 36317 Average: 558.0154 StdDev: 1423.42 Min: 91 Median: 241.2475 Max: 76712 Percentiles: P50: 241.25 P75: 502.55 P99: 4573.19 P99.9: 11692.33 P99.99: 56841.50 ------------------------------------------------------ ( 76, 110 ] 256 0.705% 0.705% ( 110, 170 ] 5859 16.133% 16.838% ### ( 170, 250 ] 13523 37.236% 54.074% ####### ( 250, 380 ] 4995 13.754% 67.828% ### ( 380, 580 ] 4251 11.705% 79.533% ## ( 580, 870 ] 3237 8.913% 88.446% ## ( 870, 1300 ] 1564 4.307% 92.753% # ( 1300, 1900 ] 576 1.586% 94.339% ( 1900, 2900 ] 685 1.886% 96.225% ( 2900, 4400 ] 985 2.712% 98.937% # ( 4400, 6600 ] 290 0.799% 99.736% ( 6600, 9900 ] 54 0.149% 99.884% ( 9900, 14000 ] 13 0.036% 99.920% ( 14000, 22000 ] 9 0.025% 99.945% ( 22000, 33000 ] 6 0.017% 99.961% ( 33000, 50000 ] 9 0.025% 99.986% ( 50000, 75000 ] 5 0.014% 100.000% ( 75000, 110000 ] 1 0.003% 100.003% ** DB Stats ** Uptime(secs): 16.7 total, 3.6 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 177.04 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:4.129 H:M:S, 24.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 274.08 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: 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 : 492.884 micros/op 8095 ops/sec 20.133 seconds 162996 operations; 7.8 MB/s (40999 of 40999 found) Microseconds per read: Count: 162996 Average: 492.8975 StdDev: 1461.44 Min: 2 Median: 246.5138 Max: 129295 Percentiles: P50: 246.51 P75: 425.15 P99: 4331.19 P99.9: 21111.37 P99.99: 54219.37 ------------------------------------------------------ ( 1, 2 ] 8 0.005% 0.005% ( 2, 3 ] 53 0.033% 0.037% ( 3, 4 ] 89 0.055% 0.092% ( 4, 6 ] 192 0.118% 0.210% ( 6, 10 ] 275 0.169% 0.379% ( 10, 15 ] 946 0.580% 0.959% ( 15, 22 ] 3052 1.872% 2.831% ( 22, 34 ] 2842 1.744% 4.575% ( 34, 51 ] 1528 0.937% 5.512% ( 51, 76 ] 235 0.144% 5.657% ( 76, 110 ] 83 0.051% 5.708% ( 110, 170 ] 10413 6.389% 12.096% # ( 170, 250 ] 64597 39.631% 51.727% ######## ( 250, 380 ] 33270 20.412% 72.139% #### ( 380, 580 ] 20660 12.675% 84.814% ### ( 580, 870 ] 11787 7.231% 92.045% # ( 870, 1300 ] 5147 3.158% 95.203% # ( 1300, 1900 ] 1977 1.213% 96.416% ( 1900, 2900 ] 1800 1.104% 97.520% ( 2900, 4400 ] 2528 1.551% 99.071% ( 4400, 6600 ] 835 0.512% 99.583% ( 6600, 9900 ] 300 0.184% 99.767% ( 9900, 14000 ] 104 0.064% 99.831% ( 14000, 22000 ] 126 0.077% 99.909% ( 22000, 33000 ] 89 0.055% 99.963% ( 33000, 50000 ] 41 0.025% 99.988% ( 50000, 75000 ] 16 0.010% 99.998% ( 75000, 110000 ] 2 0.001% 99.999% ( 110000, 170000 ] 1 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 : 2386230 rocksdb.bloom.filter.full.positive COUNT : 185757 rocksdb.bloom.filter.full.true.positive COUNT : 162113 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 : 883 rocksdb.memtable.miss COUNT : 162113 rocksdb.l0.hit COUNT : 15903 rocksdb.l1.hit COUNT : 1608 rocksdb.l2andup.hit COUNT : 144602 rocksdb.compaction.key.drop.new COUNT : 1256893 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 : 3834765 rocksdb.number.keys.read COUNT : 162996 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 3957477480 rocksdb.bytes.read COUNT : 162996000 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 : 561 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 4602149 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 : 16735771896 rocksdb.compact.write.bytes COUNT : 15441135427 rocksdb.flush.write.bytes COUNT : 3890814471 rocksdb.compact.read.marked.bytes COUNT : 0 rocksdb.compact.read.periodic.bytes COUNT : 0 rocksdb.compact.read.ttl.bytes COUNT : 0 rocksdb.compact.write.marked.bytes COUNT : 0 rocksdb.compact.write.periodic.bytes COUNT : 0 rocksdb.compact.write.ttl.bytes COUNT : 0 rocksdb.number.direct.load.table.properties COUNT : 30 rocksdb.number.superversion_acquires COUNT : 785 rocksdb.number.superversion_releases COUNT : 751 rocksdb.number.superversion_cleanups COUNT : 190 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 : 116 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 : 3865956352 rocksdb.memtable.garbage.bytes.at.flush COUNT : 7489536 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 : 17001991148 rocksdb.non.last.level.read.count COUNT : 4081085 rocksdb.block.checksum.compute.count COUNT : 4243571 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 : 245.792264 P95 : 1271.630078 P99 : 4330.546318 P100 : 129293.000000 COUNT : 162996 SUM : 80193597 rocksdb.db.write.micros P50 : 1.581120 P95 : 5.118221 P99 : 7.593459 P100 : 860561.000000 COUNT : 3834765 SUM : 15325416 rocksdb.compaction.times.micros P50 : 2040000.000000 P95 : 4078333.333333 P99 : 5205857.000000 P100 : 5205857.000000 COUNT : 59 SUM : 122289955 rocksdb.compaction.times.cpu_micros P50 : 1290740.740741 P95 : 2408333.333333 P99 : 2801666.666667 P100 : 2875550.000000 COUNT : 59 SUM : 73876477 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 : 1085.000000 P95 : 7755.000000 P99 : 14213.000000 P100 : 14213.000000 COUNT : 53 SUM : 109663 rocksdb.compaction.outfile.sync.micros P50 : 3115.909091 P95 : 8379.642857 P99 : 13815.500000 P100 : 38264.000000 COUNT : 209 SUM : 727050 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 : 240.000000 P95 : 3636.363636 P99 : 4356.363636 P100 : 4583.000000 COUNT : 132 SUM : 95024 rocksdb.table.open.io.micros P50 : 5673.033708 P95 : 19223.076923 P99 : 28036.250000 P100 : 126200.000000 COUNT : 561 SUM : 3846841 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 : 4.595814 P95 : 9.807967 P99 : 207.078429 P100 : 72390.000000 COUNT : 4054821 SUM : 70743053 rocksdb.read.block.get.micros P50 : 213.906595 P95 : 1137.146804 P99 : 4005.049313 P100 : 76794.000000 COUNT : 188251 SUM : 73059077 rocksdb.write.raw.block.micros P50 : 0.542186 P95 : 1.522017 P99 : 4.343952 P100 : 74921.000000 COUNT : 4683680 SUM : 20292304 rocksdb.numfiles.in.singlecompaction P50 : 3.270270 P95 : 5.500000 P99 : 6.800000 P100 : 8.000000 COUNT : 80 SUM : 290 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.559901 P95 : 1103.379032 P99 : 1274.150461 P100 : 860378.000000 COUNT : 4309 SUM : 4602648 rocksdb.sst.read.micros P50 : 2.226552 P95 : 137.908442 P99 : 540.969056 P100 : 76712.000000 COUNT : 4081226 SUM : 129064925 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 : 162996 SUM : 162996000 rocksdb.bytes.per.write P50 : 1032.000000 P95 : 1032.000000 P99 : 1032.000000 P100 : 1032.000000 COUNT : 3834765 SUM : 3957477480 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 : 236250.000000 P95 : 899666.666667 P99 : 1122077.000000 P100 : 1122077.000000 COUNT : 53 SUM : 17998987 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 : 216 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