[2024-07-25 15:11:01.373639] Starting SPDK v24.09-pre git sha1 704257090 / DPDK 24.03.0 initialization... [2024-07-25 15:11:01.373964] [ 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_pid3124343 ] Set seed to 1721913061366252 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-25 15:11:01.534970] app.c: 909:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-25 15:11:01.755323] app.c: 603:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-25 15:11:01.755373] app.c: 604:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 3124343' to capture a snapshot of events at runtime. [2024-07-25 15:11:01.755386] app.c: 609:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-25 15:11:01.755399] app.c: 610:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-25 15:11:01.755409] app.c: 611:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid3124343 for offline analysis/debug. [2024-07-25 15:11:01.755506] reactor.c: 941:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Thu Jul 25 15:11:05 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/07/25-15:11:08 ... thread 0: (1000000,1000000) ops and (333411.2,333411.2) ops/second in (2.999299,2.999299) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/8 629.14 MB 12.6 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 342.8 2.57 2.39 13 0.198 0 0 0.0 0.0 L1 3/3 188.11 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 265.7 265.1 0.71 0.70 1 0.710 191K 396 0.0 0.0 L2 1/1 100.64 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.0 2.5 240.4 239.9 0.67 0.65 1 0.669 163K 308 0.0 0.0 L3 18/11 941.69 MB 0.1 0.1 0.1 0.0 0.1 0.1 0.0 1.0 203.3 203.3 0.29 0.28 1 0.294 60K 0 0.0 0.0 L4 124/0 9.66 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 112/0 8.61 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 268/23 20.09 GB 0.0 0.4 0.3 0.1 1.3 1.2 0.1 1.5 96.4 303.9 4.24 4.01 16 0.265 415K 704 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.3 1.2 0.1 1.5 96.4 303.9 4.24 4.01 16 0.265 415K 704 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.3 0.1 0.4 0.3 0.0 0.0 244.6 244.2 1.67 1.62 3 0.557 415K 704 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 342.8 2.57 2.39 13 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.1 total, 3.0 interval Flush(GB): cumulative 0.860, interval 0.860 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.26 GB write, 417.77 MB/s write, 0.40 GB read, 132.58 MB/s read, 4.2 seconds Interval compaction: 1.26 GB write, 429.40 MB/s write, 0.40 GB read, 136.27 MB/s read, 4.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: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 130777 Average: 2.1453 StdDev: 5.62 Min: 0 Median: 1.4341 Max: 1163 Percentiles: P50: 1.43 P75: 1.85 P99: 6.47 P99.9: 13.96 P99.99: 165.34 ------------------------------------------------------ [ 0, 1 ] 30992 23.698% 23.698% ##### ( 1, 2 ] 79247 60.597% 84.295% ############ ( 2, 3 ] 11651 8.909% 93.204% ## ( 3, 4 ] 4259 3.257% 96.461% # ( 4, 6 ] 3199 2.446% 98.907% ( 6, 10 ] 1038 0.794% 99.701% ( 10, 15 ] 331 0.253% 99.954% ( 15, 22 ] 36 0.028% 99.982% ( 22, 34 ] 9 0.007% 99.989% ( 34, 51 ] 2 0.002% 99.990% ( 51, 76 ] 1 0.001% 99.991% ( 110, 170 ] 1 0.001% 99.992% ( 170, 250 ] 12 0.009% 100.001% ( 250, 380 ] 2 0.002% 100.002% ( 380, 580 ] 11 0.008% 100.011% ( 870, 1300 ] 1 0.001% 100.011% ** Level 1 read latency histogram (micros): Count: 29068 Average: 2.1795 StdDev: 5.24 Min: 0 Median: 1.4789 Max: 684 Percentiles: P50: 1.48 P75: 1.88 P99: 5.88 P99.9: 13.19 P99.99: 262.12 ------------------------------------------------------ [ 0, 1 ] 5918 20.359% 20.359% #### ( 1, 2 ] 17991 61.893% 82.252% ############ ( 2, 3 ] 3005 10.338% 92.590% ## ( 3, 4 ] 1064 3.660% 96.250% # ( 4, 6 ] 850 2.924% 99.174% # ( 6, 10 ] 173 0.595% 99.770% ( 10, 15 ] 61 0.210% 99.979% ( 15, 22 ] 3 0.010% 99.990% ( 170, 250 ] 1 0.003% 99.993% ( 250, 380 ] 1 0.003% 99.997% ( 380, 580 ] 1 0.003% 100.000% ( 580, 870 ] 1 0.003% 100.003% ** Level 2 read latency histogram (micros): Count: 40116 Average: 2.8087 StdDev: 34.67 Min: 1 Median: 1.4890 Max: 4631 Percentiles: P50: 1.49 P75: 1.92 P99: 9.43 P99.9: 129.27 P99.99: 577.68 ------------------------------------------------------ [ 0, 1 ] 8775 21.874% 21.874% #### ( 1, 2 ] 23072 57.513% 79.387% ############ ( 2, 3 ] 4219 10.517% 89.904% ## ( 3, 4 ] 1535 3.826% 93.731% # ( 4, 6 ] 1534 3.824% 97.555% # ( 6, 10 ] 677 1.688% 99.242% ( 10, 15 ] 192 0.479% 99.721% ( 15, 22 ] 31 0.077% 99.798% ( 22, 34 ] 6 0.015% 99.813% ( 76, 110 ] 23 0.057% 99.870% ( 110, 170 ] 37 0.092% 99.963% ( 170, 250 ] 6 0.015% 99.978% ( 250, 380 ] 4 0.010% 99.988% ( 380, 580 ] 1 0.002% 99.990% ( 870, 1300 ] 1 0.002% 99.993% ( 1900, 2900 ] 1 0.002% 99.995% ( 2900, 4400 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 26597 Average: 8.1835 StdDev: 127.58 Min: 1 Median: 1.7869 Max: 5764 Percentiles: P50: 1.79 P75: 2.66 P99: 14.36 P99.9: 2255.72 P99.99: 5764.00 ------------------------------------------------------ [ 0, 1 ] 946 3.557% 3.557% # ( 1, 2 ] 15699 59.025% 62.582% ############ ( 2, 3 ] 4978 18.716% 81.299% #### ( 3, 4 ] 1785 6.711% 88.010% # ( 4, 6 ] 1929 7.253% 95.263% # ( 6, 10 ] 736 2.767% 98.030% # ( 10, 15 ] 297 1.117% 99.147% ( 15, 22 ] 32 0.120% 99.267% ( 22, 34 ] 10 0.038% 99.304% ( 34, 51 ] 13 0.049% 99.353% ( 51, 76 ] 11 0.041% 99.395% ( 76, 110 ] 5 0.019% 99.413% ( 110, 170 ] 76 0.286% 99.699% ( 170, 250 ] 27 0.102% 99.801% ( 250, 380 ] 12 0.045% 99.846% ( 380, 580 ] 2 0.008% 99.853% ( 580, 870 ] 1 0.004% 99.857% ( 870, 1300 ] 1 0.004% 99.861% ( 1300, 1900 ] 5 0.019% 99.880% ( 1900, 2900 ] 18 0.068% 99.947% ( 2900, 4400 ] 8 0.030% 99.977% ( 4400, 6600 ] 7 0.026% 100.004% ** Level 4 read latency histogram (micros): Count: 20 Average: 3322.4500 StdDev: 1260.38 Min: 764 Median: 3275.0000 Max: 5437 Percentiles: P50: 3275.00 P75: 4212.50 P99: 5437.00 P99.9: 5437.00 P99.99: 5437.00 ------------------------------------------------------ ( 580, 870 ] 1 5.000% 5.000% # ( 1300, 1900 ] 2 10.000% 15.000% ## ( 1900, 2900 ] 5 25.000% 40.000% ##### ( 2900, 4400 ] 8 40.000% 80.000% ######## ( 4400, 6600 ] 4 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 3.1 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 318.97 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.213 H:M:S, 6.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 327.77 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.213 H:M:S, 7.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/25-15:11:11 ... thread 0: (1000000,2000000) ops and (343224.0,338246.5) ops/second in (2.913549,5.912848) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/4 1.29 GB 106.5 1.0 0.0 1.0 2.8 1.8 0.0 1.5 109.9 308.6 9.16 8.68 32 0.286 1022K 4908 0.0 0.0 L1 1/0 49.82 MB 5.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 248.4 246.8 2.53 2.48 2 1.265 638K 3994 0.0 0.0 L2 1/1 100.64 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.4 2.5 240.4 239.9 0.67 0.65 1 0.669 163K 308 0.0 0.0 L3 22/11 1.30 GB 0.4 0.5 0.4 0.1 0.5 0.4 0.0 1.2 208.4 207.9 2.63 2.52 4 0.657 556K 1286 0.0 0.0 L4 124/0 9.66 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 112/0 8.61 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 269/16 21.00 GB 0.0 2.3 0.9 1.4 4.1 2.7 0.4 2.3 156.4 277.4 14.98 14.33 39 0.384 2379K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 2.3 0.9 1.4 4.1 2.7 0.4 2.3 156.4 277.4 14.98 14.33 39 0.384 2379K 10K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 2.3 0.9 1.4 2.3 0.9 0.0 0.0 239.0 237.9 9.81 9.55 11 0.891 2379K 10K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.8 1.8 0.0 0.0 0.0 352.3 5.18 4.78 28 0.185 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 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: 4.06 GB write, 693.00 MB/s write, 2.29 GB read, 390.65 MB/s read, 15.0 seconds Interval compaction: 4.06 GB write, 702.79 MB/s write, 2.29 GB read, 396.17 MB/s read, 15.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 397644 Average: 2.5079 StdDev: 5.87 Min: 0 Median: 1.6660 Max: 1163 Percentiles: P50: 1.67 P75: 2.28 P99: 7.18 P99.9: 13.73 P99.99: 19.53 ------------------------------------------------------ [ 0, 1 ] 41438 10.421% 10.421% ## ( 1, 2 ] 236316 59.429% 69.850% ############ ( 2, 3 ] 72273 18.175% 88.025% #### ( 3, 4 ] 23144 5.820% 93.845% # ( 4, 6 ] 19345 4.865% 98.710% # ( 6, 10 ] 3891 0.979% 99.689% ( 10, 15 ] 1127 0.283% 99.972% ( 15, 22 ] 110 0.028% 100.000% ( 22, 34 ] 25 0.006% 100.006% ( 34, 51 ] 6 0.002% 100.008% ( 51, 76 ] 1 0.000% 100.008% ( 76, 110 ] 1 0.000% 100.008% ( 110, 170 ] 1 0.000% 100.009% ( 170, 250 ] 27 0.007% 100.015% ( 250, 380 ] 5 0.001% 100.017% ( 380, 580 ] 24 0.006% 100.023% ( 580, 870 ] 1 0.000% 100.023% ( 870, 1300 ] 7 0.002% 100.025% ** Level 1 read latency histogram (micros): Count: 145835 Average: 2.8998 StdDev: 8.07 Min: 0 Median: 1.8164 Max: 1192 Percentiles: P50: 1.82 P75: 2.63 P99: 9.47 P99.9: 18.83 P99.99: 220.39 ------------------------------------------------------ [ 0, 1 ] 7582 5.199% 5.199% # ( 1, 2 ] 80027 54.875% 60.074% ########### ( 2, 3 ] 34586 23.716% 83.790% ##### ( 3, 4 ] 10003 6.859% 90.649% # ( 4, 6 ] 9974 6.839% 97.488% # ( 6, 10 ] 2540 1.742% 99.230% ( 10, 15 ] 911 0.625% 99.855% ( 15, 22 ] 121 0.083% 99.938% ( 22, 34 ] 10 0.007% 99.944% ( 34, 51 ] 5 0.003% 99.948% ( 76, 110 ] 1 0.001% 99.949% ( 110, 170 ] 39 0.027% 99.975% ( 170, 250 ] 34 0.023% 99.999% ( 250, 380 ] 13 0.009% 100.008% ( 380, 580 ] 6 0.004% 100.012% ( 580, 870 ] 6 0.004% 100.016% ( 870, 1300 ] 1 0.001% 100.016% ** Level 2 read latency histogram (micros): Count: 40692 Average: 3.1789 StdDev: 35.84 Min: 1 Median: 1.4996 Max: 4631 Percentiles: P50: 1.50 P75: 1.94 P99: 9.83 P99.9: 196.59 P99.99: 849.93 ------------------------------------------------------ [ 0, 1 ] 8775 21.564% 21.564% #### ( 1, 2 ] 23160 56.915% 78.480% ########### ( 2, 3 ] 4508 11.078% 89.558% ## ( 3, 4 ] 1600 3.932% 93.490% # ( 4, 6 ] 1582 3.888% 97.378% # ( 6, 10 ] 689 1.693% 99.071% ( 10, 15 ] 194 0.477% 99.548% ( 15, 22 ] 31 0.076% 99.624% ( 22, 34 ] 6 0.015% 99.639% ( 76, 110 ] 23 0.057% 99.695% ( 110, 170 ] 75 0.184% 99.880% ( 170, 250 ] 25 0.061% 99.941% ( 250, 380 ] 12 0.029% 99.971% ( 380, 580 ] 7 0.017% 99.988% ( 580, 870 ] 1 0.002% 99.990% ( 870, 1300 ] 1 0.002% 99.993% ( 1900, 2900 ] 1 0.002% 99.995% ( 2900, 4400 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 232283 Average: 3.6260 StdDev: 43.82 Min: 1 Median: 1.7819 Max: 5764 Percentiles: P50: 1.78 P75: 2.58 P99: 9.84 P99.9: 144.39 P99.99: 342.51 ------------------------------------------------------ [ 0, 1 ] 8827 3.800% 3.800% # ( 1, 2 ] 137246 59.086% 62.886% ############ ( 2, 3 ] 48418 20.844% 83.730% #### ( 3, 4 ] 16004 6.890% 90.620% # ( 4, 6 ] 14310 6.161% 96.781% # ( 6, 10 ] 5372 2.313% 99.093% ( 10, 15 ] 1117 0.481% 99.574% ( 15, 22 ] 152 0.065% 99.640% ( 22, 34 ] 33 0.014% 99.654% ( 34, 51 ] 183 0.079% 99.733% ( 51, 76 ] 162 0.070% 99.802% ( 76, 110 ] 88 0.038% 99.840% ( 110, 170 ] 242 0.104% 99.944% ( 170, 250 ] 83 0.036% 99.980% ( 250, 380 ] 32 0.014% 99.994% ( 380, 580 ] 14 0.006% 100.000% ( 580, 870 ] 3 0.001% 100.001% ( 870, 1300 ] 1 0.000% 100.002% ( 1300, 1900 ] 5 0.002% 100.004% ( 1900, 2900 ] 18 0.008% 100.012% ( 2900, 4400 ] 8 0.003% 100.015% ( 4400, 6600 ] 7 0.003% 100.018% ** Level 4 read latency histogram (micros): Count: 20 Average: 3322.4500 StdDev: 1260.38 Min: 764 Median: 3275.0000 Max: 5437 Percentiles: P50: 3275.00 P75: 4212.50 P99: 5437.00 P99.9: 5437.00 P99.99: 5437.00 ------------------------------------------------------ ( 580, 870 ] 1 5.000% 5.000% # ( 1300, 1900 ] 2 10.000% 15.000% ## ( 1900, 2900 ] 5 25.000% 40.000% ##### ( 2900, 4400 ] 8 40.000% 80.000% ######## ( 4400, 6600 ] 4 20.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, 328.12 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.213 H:M:S, 3.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 337.81 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/07/25-15:11:14 ... thread 0: (1000000,3000000) ops and (333449.8,336632.3) ops/second in (2.998952,8.911800) 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/8 2.26 GB 181.5 1.8 0.0 1.8 4.5 2.8 0.0 1.6 120.3 306.3 15.17 14.39 50 0.303 1852K 9185 0.0 0.0 L1 1/0 49.82 MB 5.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 248.4 246.8 2.53 2.48 2 1.265 638K 3994 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.4 2.5 240.4 239.9 0.67 0.65 1 0.669 163K 308 0.0 0.0 L3 21/0 944.57 MB 0.9 1.5 0.5 1.0 1.5 0.5 0.0 2.8 229.4 228.8 6.67 6.38 5 1.334 1554K 4165 0.0 0.0 L4 126/0 9.51 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 222.2 222.2 1.00 0.96 1 1.001 225K 0 0.0 0.0 L5 120/0 9.23 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 283/8 21.97 GB 0.0 4.3 1.2 3.0 7.0 4.0 1.3 2.5 167.7 275.7 26.04 24.86 59 0.441 4434K 17K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.3 1.2 3.0 7.0 4.0 1.3 2.5 167.7 275.7 26.04 24.86 59 0.441 4434K 17K 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.3 1.2 3.0 4.2 1.2 0.0 0.0 241.3 240.3 18.10 17.56 16 1.131 4434K 17K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 356.5 7.94 7.31 43 0.185 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.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: 7.01 GB write, 797.85 MB/s write, 4.26 GB read, 485.24 MB/s read, 26.0 seconds Interval compaction: 7.01 GB write, 805.33 MB/s write, 4.26 GB read, 489.78 MB/s read, 26.0 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: 646216 Average: 2.4157 StdDev: 5.95 Min: 0 Median: 1.6218 Max: 1163 Percentiles: P50: 1.62 P75: 2.09 P99: 6.47 P99.9: 13.63 P99.99: 19.81 ------------------------------------------------------ [ 0, 1 ] 73686 11.403% 11.403% ## ( 1, 2 ] 401141 62.075% 73.478% ############ ( 2, 3 ] 108330 16.764% 90.242% ### ( 3, 4 ] 31575 4.886% 95.128% # ( 4, 6 ] 24416 3.778% 98.906% # ( 6, 10 ] 5180 0.802% 99.708% ( 10, 15 ] 1714 0.265% 99.973% ( 15, 22 ] 162 0.025% 99.998% ( 22, 34 ] 32 0.005% 100.003% ( 34, 51 ] 6 0.001% 100.004% ( 51, 76 ] 3 0.000% 100.004% ( 76, 110 ] 2 0.000% 100.005% ( 110, 170 ] 1 0.000% 100.005% ( 170, 250 ] 41 0.006% 100.011% ( 250, 380 ] 11 0.002% 100.013% ( 380, 580 ] 33 0.005% 100.018% ( 580, 870 ] 4 0.001% 100.019% ( 870, 1300 ] 11 0.002% 100.020% ** Level 1 read latency histogram (micros): Count: 145835 Average: 2.8998 StdDev: 8.07 Min: 0 Median: 1.8164 Max: 1192 Percentiles: P50: 1.82 P75: 2.63 P99: 9.47 P99.9: 18.83 P99.99: 220.39 ------------------------------------------------------ [ 0, 1 ] 7582 5.199% 5.199% # ( 1, 2 ] 80027 54.875% 60.074% ########### ( 2, 3 ] 34586 23.716% 83.790% ##### ( 3, 4 ] 10003 6.859% 90.649% # ( 4, 6 ] 9974 6.839% 97.488% # ( 6, 10 ] 2540 1.742% 99.230% ( 10, 15 ] 911 0.625% 99.855% ( 15, 22 ] 121 0.083% 99.938% ( 22, 34 ] 10 0.007% 99.944% ( 34, 51 ] 5 0.003% 99.948% ( 76, 110 ] 1 0.001% 99.949% ( 110, 170 ] 39 0.027% 99.975% ( 170, 250 ] 34 0.023% 99.999% ( 250, 380 ] 13 0.009% 100.008% ( 380, 580 ] 6 0.004% 100.012% ( 580, 870 ] 6 0.004% 100.016% ( 870, 1300 ] 1 0.001% 100.016% ** Level 2 read latency histogram (micros): Count: 65588 Average: 2.8421 StdDev: 28.24 Min: 1 Median: 1.5337 Max: 4631 Percentiles: P50: 1.53 P75: 1.94 P99: 9.11 P99.9: 156.73 P99.99: 535.46 ------------------------------------------------------ [ 0, 1 ] 11431 17.428% 17.428% ### ( 1, 2 ] 40026 61.026% 78.455% ############ ( 2, 3 ] 8059 12.287% 90.742% ## ( 3, 4 ] 2412 3.678% 94.420% # ( 4, 6 ] 2099 3.200% 97.620% # ( 6, 10 ] 1164 1.775% 99.395% ( 10, 15 ] 210 0.320% 99.715% ( 15, 22 ] 33 0.050% 99.765% ( 22, 34 ] 6 0.009% 99.774% ( 51, 76 ] 1 0.002% 99.776% ( 76, 110 ] 23 0.035% 99.811% ( 110, 170 ] 75 0.114% 99.925% ( 170, 250 ] 25 0.038% 99.963% ( 250, 380 ] 12 0.018% 99.982% ( 380, 580 ] 7 0.011% 99.992% ( 580, 870 ] 1 0.002% 99.994% ( 870, 1300 ] 1 0.002% 99.995% ( 1900, 2900 ] 1 0.002% 99.997% ( 2900, 4400 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 306401 Average: 3.4591 StdDev: 38.63 Min: 0 Median: 1.7602 Max: 5764 Percentiles: P50: 1.76 P75: 2.51 P99: 9.65 P99.9: 149.45 P99.99: 372.37 ------------------------------------------------------ [ 0, 1 ] 13205 4.310% 4.310% # ( 1, 2 ] 184153 60.102% 64.412% ############ ( 2, 3 ] 63441 20.705% 85.117% #### ( 3, 4 ] 19422 6.339% 91.456% # ( 4, 6 ] 16989 5.545% 97.000% # ( 6, 10 ] 6711 2.190% 99.191% ( 10, 15 ] 1287 0.420% 99.611% ( 15, 22 ] 185 0.060% 99.671% ( 22, 34 ] 38 0.012% 99.683% ( 34, 51 ] 206 0.067% 99.751% ( 51, 76 ] 169 0.055% 99.806% ( 76, 110 ] 92 0.030% 99.836% ( 110, 170 ] 299 0.098% 99.933% ( 170, 250 ] 115 0.038% 99.971% ( 250, 380 ] 62 0.020% 99.991% ( 380, 580 ] 22 0.007% 99.998% ( 580, 870 ] 6 0.002% 100.000% ( 870, 1300 ] 3 0.001% 100.001% ( 1300, 1900 ] 5 0.002% 100.003% ( 1900, 2900 ] 18 0.006% 100.009% ( 2900, 4400 ] 8 0.003% 100.011% ( 4400, 6600 ] 7 0.002% 100.014% ** Level 4 read latency histogram (micros): Count: 50 Average: 1376.0400 StdDev: 1780.64 Min: 1 Median: 160.0000 Max: 5437 Percentiles: P50: 160.00 P75: 2800.00 P99: 5437.00 P99.9: 5437.00 P99.99: 5437.00 ------------------------------------------------------ [ 0, 1 ] 7 14.000% 14.000% ### ( 1, 2 ] 10 20.000% 34.000% #### ( 2, 3 ] 1 2.000% 36.000% ( 22, 34 ] 1 2.000% 38.000% ( 34, 51 ] 1 2.000% 40.000% ( 110, 170 ] 6 12.000% 52.000% ## ( 170, 250 ] 1 2.000% 54.000% ( 250, 380 ] 2 4.000% 58.000% # ( 380, 580 ] 1 2.000% 60.000% ( 580, 870 ] 1 2.000% 62.000% ( 1300, 1900 ] 2 4.000% 66.000% # ( 1900, 2900 ] 5 10.000% 76.000% ## ( 2900, 4400 ] 8 16.000% 92.000% ### ( 4400, 6600 ] 4 8.000% 100.000% ## ** Level 5 read latency histogram (micros): Count: 40 Average: 462.4500 StdDev: 478.98 Min: 109 Median: 226.0000 Max: 2032 Percentiles: P50: 226.00 P75: 580.00 P99: 2032.00 P99.9: 2032.00 P99.99: 2032.00 ------------------------------------------------------ ( 76, 110 ] 1 2.500% 2.500% # ( 110, 170 ] 12 30.000% 32.500% ###### ( 170, 250 ] 10 25.000% 57.500% ##### ( 250, 380 ] 4 10.000% 67.500% ## ( 380, 580 ] 3 7.500% 75.000% ## ( 580, 870 ] 1 2.500% 77.500% # ( 870, 1300 ] 7 17.500% 95.000% #### ( 1900, 2900 ] 2 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.14 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.388 H:M:S, 4.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 328.18 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.175 H:M:S, 5.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/25-15:11:17 ... thread 0: (1000000,4000000) ops and (332026.9,335469.0) ops/second in (3.011804,11.923604) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/4 3.24 GB 306.8 2.8 0.0 2.8 6.5 3.7 0.0 1.7 129.5 304.4 21.86 20.79 69 0.317 2874K 14K 0.0 0.0 L1 1/0 49.82 MB 5.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 248.4 246.8 2.53 2.48 2 1.265 638K 3994 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.4 2.5 240.4 239.9 0.67 0.65 1 0.669 163K 308 0.0 0.0 L3 21/0 944.57 MB 0.9 1.5 0.5 1.0 1.5 0.5 0.0 2.8 229.4 228.8 6.67 6.38 5 1.334 1554K 4165 0.0 0.0 L4 126/0 9.51 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 222.2 222.2 1.00 0.96 1 1.001 225K 0 0.0 0.0 L5 120/0 9.23 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 286/4 22.95 GB 0.0 5.2 1.2 4.0 9.0 5.0 1.3 2.4 164.2 280.7 32.73 31.26 78 0.420 5456K 22K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.2 1.2 4.0 9.0 5.0 1.3 2.4 164.2 280.7 32.73 31.26 78 0.420 5456K 22K 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.2 1.2 4.0 5.2 1.2 0.0 0.0 243.9 242.8 22.03 21.39 20 1.102 5456K 22K 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 358.8 10.70 9.87 58 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): 12.0 total, 11.9 interval Flush(GB): cumulative 3.747, interval 3.747 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.97 GB write, 764.96 MB/s write, 5.25 GB read, 447.36 MB/s read, 32.7 seconds Interval compaction: 8.97 GB write, 770.32 MB/s write, 5.25 GB read, 450.50 MB/s read, 32.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: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 901239 Average: 2.3221 StdDev: 6.15 Min: 0 Median: 1.5713 Max: 1189 Percentiles: P50: 1.57 P75: 1.96 P99: 5.96 P99.9: 13.29 P99.99: 19.63 ------------------------------------------------------ [ 0, 1 ] 123177 13.668% 13.668% ### ( 1, 2 ] 573200 63.601% 77.269% ############# ( 2, 3 ] 131678 14.611% 91.880% ### ( 3, 4 ] 37430 4.153% 96.033% # ( 4, 6 ] 27262 3.025% 99.058% # ( 6, 10 ] 6274 0.696% 99.754% ( 10, 15 ] 2004 0.222% 99.976% ( 15, 22 ] 189 0.021% 99.997% ( 22, 34 ] 38 0.004% 100.001% ( 34, 51 ] 6 0.001% 100.002% ( 51, 76 ] 4 0.000% 100.003% ( 76, 110 ] 3 0.000% 100.003% ( 110, 170 ] 1 0.000% 100.003% ( 170, 250 ] 55 0.006% 100.009% ( 250, 380 ] 19 0.002% 100.011% ( 380, 580 ] 40 0.004% 100.016% ( 580, 870 ] 7 0.001% 100.016% ( 870, 1300 ] 17 0.002% 100.018% ** Level 1 read latency histogram (micros): Count: 145835 Average: 2.8998 StdDev: 8.07 Min: 0 Median: 1.8164 Max: 1192 Percentiles: P50: 1.82 P75: 2.63 P99: 9.47 P99.9: 18.83 P99.99: 220.39 ------------------------------------------------------ [ 0, 1 ] 7582 5.199% 5.199% # ( 1, 2 ] 80027 54.875% 60.074% ########### ( 2, 3 ] 34586 23.716% 83.790% ##### ( 3, 4 ] 10003 6.859% 90.649% # ( 4, 6 ] 9974 6.839% 97.488% # ( 6, 10 ] 2540 1.742% 99.230% ( 10, 15 ] 911 0.625% 99.855% ( 15, 22 ] 121 0.083% 99.938% ( 22, 34 ] 10 0.007% 99.944% ( 34, 51 ] 5 0.003% 99.948% ( 76, 110 ] 1 0.001% 99.949% ( 110, 170 ] 39 0.027% 99.975% ( 170, 250 ] 34 0.023% 99.999% ( 250, 380 ] 13 0.009% 100.008% ( 380, 580 ] 6 0.004% 100.012% ( 580, 870 ] 6 0.004% 100.016% ( 870, 1300 ] 1 0.001% 100.016% ** Level 2 read latency histogram (micros): Count: 65588 Average: 2.8421 StdDev: 28.24 Min: 1 Median: 1.5337 Max: 4631 Percentiles: P50: 1.53 P75: 1.94 P99: 9.11 P99.9: 156.73 P99.99: 535.46 ------------------------------------------------------ [ 0, 1 ] 11431 17.428% 17.428% ### ( 1, 2 ] 40026 61.026% 78.455% ############ ( 2, 3 ] 8059 12.287% 90.742% ## ( 3, 4 ] 2412 3.678% 94.420% # ( 4, 6 ] 2099 3.200% 97.620% # ( 6, 10 ] 1164 1.775% 99.395% ( 10, 15 ] 210 0.320% 99.715% ( 15, 22 ] 33 0.050% 99.765% ( 22, 34 ] 6 0.009% 99.774% ( 51, 76 ] 1 0.002% 99.776% ( 76, 110 ] 23 0.035% 99.811% ( 110, 170 ] 75 0.114% 99.925% ( 170, 250 ] 25 0.038% 99.963% ( 250, 380 ] 12 0.018% 99.982% ( 380, 580 ] 7 0.011% 99.992% ( 580, 870 ] 1 0.002% 99.994% ( 870, 1300 ] 1 0.002% 99.995% ( 1900, 2900 ] 1 0.002% 99.997% ( 2900, 4400 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 306401 Average: 3.4591 StdDev: 38.63 Min: 0 Median: 1.7602 Max: 5764 Percentiles: P50: 1.76 P75: 2.51 P99: 9.65 P99.9: 149.45 P99.99: 372.37 ------------------------------------------------------ [ 0, 1 ] 13205 4.310% 4.310% # ( 1, 2 ] 184153 60.102% 64.412% ############ ( 2, 3 ] 63441 20.705% 85.117% #### ( 3, 4 ] 19422 6.339% 91.456% # ( 4, 6 ] 16989 5.545% 97.000% # ( 6, 10 ] 6711 2.190% 99.191% ( 10, 15 ] 1287 0.420% 99.611% ( 15, 22 ] 185 0.060% 99.671% ( 22, 34 ] 38 0.012% 99.683% ( 34, 51 ] 206 0.067% 99.751% ( 51, 76 ] 169 0.055% 99.806% ( 76, 110 ] 92 0.030% 99.836% ( 110, 170 ] 299 0.098% 99.933% ( 170, 250 ] 115 0.038% 99.971% ( 250, 380 ] 62 0.020% 99.991% ( 380, 580 ] 22 0.007% 99.998% ( 580, 870 ] 6 0.002% 100.000% ( 870, 1300 ] 3 0.001% 100.001% ( 1300, 1900 ] 5 0.002% 100.003% ( 1900, 2900 ] 18 0.006% 100.009% ( 2900, 4400 ] 8 0.003% 100.011% ( 4400, 6600 ] 7 0.002% 100.014% ** Level 4 read latency histogram (micros): Count: 50 Average: 1376.0400 StdDev: 1780.64 Min: 1 Median: 160.0000 Max: 5437 Percentiles: P50: 160.00 P75: 2800.00 P99: 5437.00 P99.9: 5437.00 P99.99: 5437.00 ------------------------------------------------------ [ 0, 1 ] 7 14.000% 14.000% ### ( 1, 2 ] 10 20.000% 34.000% #### ( 2, 3 ] 1 2.000% 36.000% ( 22, 34 ] 1 2.000% 38.000% ( 34, 51 ] 1 2.000% 40.000% ( 110, 170 ] 6 12.000% 52.000% ## ( 170, 250 ] 1 2.000% 54.000% ( 250, 380 ] 2 4.000% 58.000% # ( 380, 580 ] 1 2.000% 60.000% ( 580, 870 ] 1 2.000% 62.000% ( 1300, 1900 ] 2 4.000% 66.000% # ( 1900, 2900 ] 5 10.000% 76.000% ## ( 2900, 4400 ] 8 16.000% 92.000% ### ( 4400, 6600 ] 4 8.000% 100.000% ## ** Level 5 read latency histogram (micros): Count: 40 Average: 462.4500 StdDev: 478.98 Min: 109 Median: 226.0000 Max: 2032 Percentiles: P50: 226.00 P75: 580.00 P99: 2032.00 P99.9: 2032.00 P99.99: 2032.00 ------------------------------------------------------ ( 76, 110 ] 1 2.500% 2.500% # ( 110, 170 ] 12 30.000% 32.500% ###### ( 170, 250 ] 10 25.000% 57.500% ##### ( 250, 380 ] 4 10.000% 67.500% ## ( 380, 580 ] 3 7.500% 75.000% ## ( 580, 870 ] 1 2.500% 77.500% # ( 870, 1300 ] 7 17.500% 95.000% #### ( 1900, 2900 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 12.0 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 327.80 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.597 H:M:S, 5.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 326.77 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.209 H:M:S, 6.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 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.282 micros/op 233552 ops/sec 20.150 seconds 4705999 operations; 226.3 MB/s Microseconds per write: Count: 4705999 Average: 4.2817 StdDev: 156.36 Min: 1 Median: 1.7611 Max: 208929 Percentiles: P50: 1.76 P75: 3.05 P99: 9.05 P99.9: 290.24 P99.99: 2429.34 ------------------------------------------------------ [ 0, 1 ] 650391 13.820% 13.820% ### ( 1, 2 ] 2237167 47.539% 61.359% ########## ( 2, 3 ] 609128 12.944% 74.303% ### ( 3, 4 ] 659101 14.006% 88.308% ### ( 4, 6 ] 457226 9.716% 98.024% ## ( 6, 10 ] 60222 1.280% 99.304% ( 10, 15 ] 16830 0.358% 99.661% ( 15, 22 ] 4932 0.105% 99.766% ( 22, 34 ] 1298 0.028% 99.794% ( 34, 51 ] 233 0.005% 99.799% ( 51, 76 ] 51 0.001% 99.800% ( 76, 110 ] 9 0.000% 99.800% ( 110, 170 ] 4377 0.093% 99.893% ( 170, 250 ] 302 0.006% 99.899% ( 250, 380 ] 84 0.002% 99.901% ( 380, 580 ] 3 0.000% 99.901% ( 580, 870 ] 6 0.000% 99.901% ( 870, 1300 ] 3640 0.077% 99.979% ( 1300, 1900 ] 7 0.000% 99.979% ( 1900, 2900 ] 985 0.021% 100.000% ( 4400, 6600 ] 1 0.000% 100.000% ( 6600, 9900 ] 1 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 2 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 : 172900 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 : 4705999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 4856590968 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 : 158 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 6588063 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 : 8406159345 rocksdb.compact.write.bytes COUNT : 8237066900 rocksdb.flush.write.bytes COUNT : 4815119977 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 : 16 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 : 86 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 : 4783316992 rocksdb.memtable.garbage.bytes.at.flush COUNT : 8289280 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 : 8449746143 rocksdb.non.last.level.read.count COUNT : 2039789 rocksdb.block.checksum.compute.count COUNT : 2039489 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.410791 P95 : 4.758085 P99 : 7.676451 P100 : 208925.000000 COUNT : 4705999 SUM : 17985358 rocksdb.compaction.times.micros P50 : 993571.428571 P95 : 1847500.000000 P99 : 3978000.000000 P100 : 4042766.000000 COUNT : 23 SUM : 24856236 rocksdb.compaction.times.cpu_micros P50 : 993571.428571 P95 : 1847500.000000 P99 : 3853781.000000 P100 : 3853781.000000 COUNT : 23 SUM : 24176847 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 : 574.117647 P95 : 1267.750000 P99 : 1576.000000 P100 : 1576.000000 COUNT : 70 SUM : 46817 rocksdb.compaction.outfile.sync.micros P50 : 681.500000 P95 : 1277.156250 P99 : 1461.000000 P100 : 1461.000000 COUNT : 77 SUM : 54865 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 : 80.250000 P95 : 251.300000 P99 : 335.000000 P100 : 335.000000 COUNT : 99 SUM : 10361 rocksdb.table.open.io.micros P50 : 794.814815 P95 : 16254.545455 P99 : 18582.000000 P100 : 18582.000000 COUNT : 158 SUM : 381672 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.623738 P95 : 7.228012 P99 : 11.622267 P100 : 12986.000000 COUNT : 2039015 SUM : 9579930 rocksdb.read.block.get.micros P50 : 374.247788 P95 : 3680.000000 P99 : 5968.000000 P100 : 6097.000000 COUNT : 316 SUM : 246821 rocksdb.write.raw.block.micros P50 : 0.512476 P95 : 0.973704 P99 : 2.959174 P100 : 2606.000000 COUNT : 3162121 SUM : 5941338 rocksdb.numfiles.in.singlecompaction P50 : 3.382353 P95 : 12.750000 P99 : 17.000000 P100 : 17.000000 COUNT : 29 SUM : 126 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.562096 P95 : 1165.711955 P99 : 2473.614213 P100 : 208714.000000 COUNT : 42599 SUM : 6593191 rocksdb.sst.read.micros P50 : 1.566931 P95 : 3.928356 P99 : 7.983203 P100 : 5764.000000 COUNT : 2039816 SUM : 5477032 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 : 4705999 SUM : 4856590968 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 : 165263.157895 P95 : 266250.000000 P99 : 356968.000000 P100 : 356968.000000 COUNT : 70 SUM : 12729510 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 : 93 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