[2024-12-10 17:35:18.918732] Starting SPDK v25.01-pre git sha1 1a5bdab32 / DPDK 24.03.0 initialization... [2024-12-10 17:35:18.918856] [ 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_pid2294444 ] Set seed to 1733848518916133 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-10 17:35:19.057652] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-10 17:35:19.158853] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-10 17:35:19.158905] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 2294444' to capture a snapshot of events at runtime. [2024-12-10 17:35:19.158918] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-10 17:35:19.158932] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-10 17:35:19.158942] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid2294444 for offline analysis/debug. [2024-12-10 17:35:19.160264] reactor.c: 995:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Tue Dec 10 17:35:22 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/12/10-17:35:24 ... thread 0: (1000000,1000000) ops and (360192.4,360192.4) ops/second in (2.776294,2.776294) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/8 503.31 MB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 357.8 2.29 2.14 13 0.176 0 0 0.0 0.0 L1 3/3 188.08 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 250.8 249.9 0.75 0.73 1 0.753 191K 646 0.0 0.0 L2 2/1 125.62 MB 0.0 0.1 0.1 0.1 0.1 0.1 0.1 2.0 238.8 238.4 0.53 0.51 1 0.527 127K 182 0.0 0.0 L3 9/0 727.75 MB 0.7 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 124/0 9.60 GB 1.0 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 L5 116/0 8.92 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 262/12 20.03 GB 0.0 0.3 0.2 0.1 1.1 1.0 1.0 1.4 88.2 317.4 3.57 3.39 15 0.238 319K 828 0.0 0.0 Int 0/0 0.00 KB 0.0 0.3 0.2 0.1 1.1 1.0 0.5 1.4 88.2 317.4 3.57 3.39 15 0.238 319K 828 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.3 0.2 0.1 0.3 0.2 0.0 0.0 245.9 245.2 1.28 1.25 2 0.640 319K 828 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 357.8 2.29 2.14 13 0.176 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): 2.9 total, 2.8 interval Flush(GB): cumulative 0.799, interval 0.799 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.11 GB write, 395.76 MB/s write, 0.31 GB read, 110.02 MB/s read, 3.6 seconds Interval compaction: 1.11 GB write, 407.31 MB/s write, 0.31 GB read, 113.23 MB/s read, 3.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: 0, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 0, ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 114969 Average: 1.9013 StdDev: 4.67 Min: 1 Median: 1.3048 Max: 412 Percentiles: P50: 1.30 P75: 1.71 P99: 5.09 P99.9: 12.94 P99.99: 210.02 ------------------------------------------------------ [ 0, 1 ] 35937 31.258% 31.258% ###### ( 1, 2 ] 70697 61.492% 92.750% ############ ( 2, 3 ] 4828 4.199% 96.950% # ( 3, 4 ] 1893 1.647% 98.596% ( 4, 6 ] 857 0.745% 99.342% ( 6, 10 ] 554 0.482% 99.823% ( 10, 15 ] 155 0.135% 99.958% ( 15, 22 ] 24 0.021% 99.979% ( 22, 34 ] 4 0.003% 99.983% ( 34, 51 ] 1 0.001% 99.983% ( 51, 76 ] 3 0.003% 99.986% ( 76, 110 ] 1 0.001% 99.987% ( 170, 250 ] 13 0.011% 99.998% ( 250, 380 ] 6 0.005% 100.003% ( 380, 580 ] 7 0.006% 100.010% ** Level 1 read latency histogram (micros): Count: 20944 Average: 1.9362 StdDev: 6.71 Min: 1 Median: 1.3396 Max: 761 Percentiles: P50: 1.34 P75: 1.73 P99: 4.64 P99.9: 9.40 P99.99: 367.73 ------------------------------------------------------ [ 0, 1 ] 5936 28.342% 28.342% ###### ( 1, 2 ] 13357 63.775% 92.117% ############# ( 2, 3 ] 999 4.770% 96.887% # ( 3, 4 ] 383 1.829% 98.716% ( 4, 6 ] 186 0.888% 99.604% ( 6, 10 ] 73 0.349% 99.952% ( 10, 15 ] 6 0.029% 99.981% ( 170, 250 ] 1 0.005% 99.986% ( 250, 380 ] 1 0.005% 99.990% ( 380, 580 ] 1 0.005% 99.995% ( 580, 870 ] 1 0.005% 100.000% ** Level 2 read latency histogram (micros): Count: 7549 Average: 3.7418 StdDev: 43.88 Min: 0 Median: 1.6768 Max: 2341 Percentiles: P50: 1.68 P75: 2.26 P99: 8.33 P99.9: 188.04 P99.99: 2341.00 ------------------------------------------------------ [ 0, 1 ] 450 5.961% 5.961% # ( 1, 2 ] 4912 65.068% 71.029% ############# ( 2, 3 ] 1167 15.459% 86.488% ### ( 3, 4 ] 475 6.292% 92.781% # ( 4, 6 ] 417 5.524% 98.304% # ( 6, 10 ] 90 1.192% 99.497% ( 10, 15 ] 20 0.265% 99.762% ( 15, 22 ] 2 0.026% 99.788% ( 22, 34 ] 4 0.053% 99.841% ( 110, 170 ] 4 0.053% 99.894% ( 170, 250 ] 2 0.026% 99.921% ( 380, 580 ] 1 0.013% 99.934% ( 580, 870 ] 1 0.013% 99.947% ( 1300, 1900 ] 2 0.026% 99.974% ( 1900, 2900 ] 2 0.026% 100.000% ** Level 3 read latency histogram (micros): Count: 55 Average: 2459.9636 StdDev: 2406.74 Min: 97 Median: 1675.0000 Max: 9750 Percentiles: P50: 1675.00 P75: 2740.91 P99: 9597.50 P99.9: 9750.00 P99.99: 9750.00 ------------------------------------------------------ ( 76, 110 ] 2 3.636% 3.636% # ( 110, 170 ] 2 3.636% 7.273% # ( 250, 380 ] 1 1.818% 9.091% ( 380, 580 ] 1 1.818% 10.909% ( 580, 870 ] 4 7.273% 18.182% # ( 870, 1300 ] 10 18.182% 36.364% #### ( 1300, 1900 ] 12 21.818% 58.182% #### ( 1900, 2900 ] 11 20.000% 78.182% #### ( 2900, 4400 ] 3 5.455% 83.636% # ( 4400, 6600 ] 3 5.455% 89.091% # ( 6600, 9900 ] 6 10.909% 100.000% ## ** Level 4 read latency histogram (micros): Count: 15 Average: 3215.6667 StdDev: 2588.19 Min: 888 Median: 1675.0000 Max: 8532 Percentiles: P50: 1675.00 P75: 5775.00 P99: 8532.00 P99.9: 8532.00 P99.99: 8532.00 ------------------------------------------------------ ( 870, 1300 ] 5 33.333% 33.333% ####### ( 1300, 1900 ] 4 26.667% 60.000% ##### ( 2900, 4400 ] 1 6.667% 66.667% # ( 4400, 6600 ] 2 13.333% 80.000% ### ( 6600, 9900 ] 3 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 20 Average: 356.2500 StdDev: 435.15 Min: 95 Median: 106.9091 Max: 1792 Percentiles: P50: 106.91 P75: 380.00 P99: 1780.00 P99.9: 1792.00 P99.99: 1792.00 ------------------------------------------------------ ( 76, 110 ] 11 55.000% 55.000% ########### ( 110, 170 ] 1 5.000% 60.000% # ( 250, 380 ] 3 15.000% 75.000% ### ( 380, 580 ] 1 5.000% 80.000% # ( 870, 1300 ] 3 15.000% 95.000% ### ( 1300, 1900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 2.9 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 344.17 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.000 H:M:S, 0.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 354.12 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: 3 num-running-flushes: 1 2024/12/10-17:35:28 ... thread 0: (1000000,2000000) ops and (319180.2,338448.4) ops/second in (3.133026,5.909320) 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 11/8 1.29 GB 81.3 0.8 0.0 0.8 2.6 1.8 0.0 1.4 95.8 316.2 8.54 8.08 32 0.267 830K 4251 0.0 0.0 L1 2/0 49.72 MB 5.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 241.5 239.8 2.60 2.55 2 1.301 638K 4326 0.0 0.0 L2 2/2 133.39 MB 0.0 0.1 0.1 0.1 0.1 0.1 0.4 2.0 238.8 238.4 0.53 0.51 1 0.527 127K 182 0.0 0.0 L3 23/14 1.08 GB 0.3 0.5 0.4 0.1 0.5 0.4 0.2 1.3 212.7 212.0 2.29 2.21 3 0.763 494K 1674 0.0 0.0 L4 124/0 9.60 GB 1.0 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 L5 116/0 8.92 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 278/24 21.06 GB 0.0 2.0 0.9 1.1 3.8 2.7 1.3 2.1 147.5 282.0 13.96 13.36 38 0.367 2090K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 2.0 0.9 1.1 3.8 2.7 0.9 2.1 147.5 282.0 13.96 13.36 38 0.367 2090K 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.0 0.9 1.1 2.0 0.9 0.0 0.0 236.8 235.6 8.69 8.49 9 0.966 2090K 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 358.6 5.26 4.87 29 0.181 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.843, interval 1.843 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.84 GB write, 656.76 MB/s write, 2.01 GB read, 343.58 MB/s read, 14.0 seconds Interval compaction: 3.84 GB write, 665.77 MB/s write, 2.01 GB read, 348.30 MB/s read, 14.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: 1, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 1, interval: 1 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 401674 Average: 2.3489 StdDev: 5.97 Min: 0 Median: 1.5708 Max: 1285 Percentiles: P50: 1.57 P75: 1.98 P99: 6.65 P99.9: 13.29 P99.99: 18.66 ------------------------------------------------------ [ 0, 1 ] 60372 15.030% 15.030% ### ( 1, 2 ] 246076 61.263% 76.293% ############ ( 2, 3 ] 56559 14.081% 90.374% ### ( 3, 4 ] 19335 4.814% 95.187% # ( 4, 6 ] 14730 3.667% 98.854% # ( 6, 10 ] 3586 0.893% 99.747% ( 10, 15 ] 934 0.233% 99.980% ( 15, 22 ] 82 0.020% 100.000% ( 22, 34 ] 9 0.002% 100.002% ( 34, 51 ] 3 0.001% 100.003% ( 51, 76 ] 6 0.001% 100.004% ( 76, 110 ] 1 0.000% 100.005% ( 170, 250 ] 28 0.007% 100.012% ( 250, 380 ] 11 0.003% 100.014% ( 380, 580 ] 18 0.004% 100.019% ( 870, 1300 ] 7 0.002% 100.021% ** Level 1 read latency histogram (micros): Count: 134094 Average: 2.7999 StdDev: 7.57 Min: 0 Median: 1.7541 Max: 850 Percentiles: P50: 1.75 P75: 2.52 P99: 8.84 P99.9: 18.99 P99.99: 191.09 ------------------------------------------------------ [ 0, 1 ] 9156 6.828% 6.828% # ( 1, 2 ] 76765 57.247% 64.075% ########### ( 2, 3 ] 28280 21.090% 85.165% #### ( 3, 4 ] 9160 6.831% 91.996% # ( 4, 6 ] 8014 5.976% 97.972% # ( 6, 10 ] 1942 1.448% 99.421% ( 10, 15 ] 603 0.450% 99.870% ( 15, 22 ] 70 0.052% 99.922% ( 22, 34 ] 7 0.005% 99.928% ( 34, 51 ] 1 0.001% 99.928% ( 51, 76 ] 2 0.001% 99.930% ( 76, 110 ] 8 0.006% 99.936% ( 110, 170 ] 66 0.049% 99.985% ( 170, 250 ] 25 0.019% 100.004% ( 250, 380 ] 11 0.008% 100.012% ( 380, 580 ] 6 0.004% 100.016% ( 580, 870 ] 5 0.004% 100.020% ** Level 2 read latency histogram (micros): Count: 31314 Average: 2.9136 StdDev: 22.44 Min: 0 Median: 1.6735 Max: 2341 Percentiles: P50: 1.67 P75: 2.20 P99: 7.52 P99.9: 118.43 P99.99: 1560.58 ------------------------------------------------------ [ 0, 1 ] 1703 5.438% 5.438% # ( 1, 2 ] 20720 66.168% 71.607% ############# ( 2, 3 ] 5188 16.568% 88.175% ### ( 3, 4 ] 1811 5.783% 93.958% # ( 4, 6 ] 1451 4.634% 98.592% # ( 6, 10 ] 337 1.076% 99.668% ( 10, 15 ] 58 0.185% 99.853% ( 15, 22 ] 7 0.022% 99.875% ( 22, 34 ] 6 0.019% 99.895% ( 110, 170 ] 12 0.038% 99.933% ( 170, 250 ] 9 0.029% 99.962% ( 250, 380 ] 5 0.016% 99.978% ( 380, 580 ] 2 0.006% 99.984% ( 580, 870 ] 1 0.003% 99.987% ( 1300, 1900 ] 2 0.006% 99.994% ( 1900, 2900 ] 2 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 135958 Average: 4.3334 StdDev: 69.85 Min: 1 Median: 1.8935 Max: 9750 Percentiles: P50: 1.89 P75: 2.78 P99: 10.93 P99.9: 153.52 P99.99: 273.42 ------------------------------------------------------ [ 0, 1 ] 3039 2.235% 2.235% ( 1, 2 ] 72683 53.460% 55.695% ########### ( 2, 3 ] 33817 24.873% 80.568% ##### ( 3, 4 ] 10885 8.006% 88.574% ## ( 4, 6 ] 10711 7.878% 96.453% ## ( 6, 10 ] 3284 2.415% 98.868% ( 10, 15 ] 967 0.711% 99.579% ( 15, 22 ] 114 0.084% 99.663% ( 22, 34 ] 16 0.012% 99.675% ( 34, 51 ] 84 0.062% 99.737% ( 51, 76 ] 77 0.057% 99.793% ( 76, 110 ] 30 0.022% 99.815% ( 110, 170 ] 160 0.118% 99.933% ( 170, 250 ] 73 0.054% 99.987% ( 250, 380 ] 30 0.022% 100.009% ( 380, 580 ] 14 0.010% 100.019% ( 580, 870 ] 6 0.004% 100.024% ( 870, 1300 ] 10 0.007% 100.031% ( 1300, 1900 ] 12 0.009% 100.040% ( 1900, 2900 ] 11 0.008% 100.048% ( 2900, 4400 ] 3 0.002% 100.050% ( 4400, 6600 ] 3 0.002% 100.052% ( 6600, 9900 ] 6 0.004% 100.057% ** Level 4 read latency histogram (micros): Count: 15 Average: 3215.6667 StdDev: 2588.19 Min: 888 Median: 1675.0000 Max: 8532 Percentiles: P50: 1675.00 P75: 5775.00 P99: 8532.00 P99.9: 8532.00 P99.99: 8532.00 ------------------------------------------------------ ( 870, 1300 ] 5 33.333% 33.333% ####### ( 1300, 1900 ] 4 26.667% 60.000% ##### ( 2900, 4400 ] 1 6.667% 66.667% # ( 4400, 6600 ] 2 13.333% 80.000% ### ( 6600, 9900 ] 3 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 20 Average: 356.2500 StdDev: 435.15 Min: 95 Median: 106.9091 Max: 1792 Percentiles: P50: 106.91 P75: 380.00 P99: 1780.00 P99.9: 1792.00 P99.99: 1792.00 ------------------------------------------------------ ( 76, 110 ] 11 55.000% 55.000% ########### ( 110, 170 ] 1 5.000% 60.000% # ( 250, 380 ] 3 15.000% 75.000% ### ( 380, 580 ] 1 5.000% 80.000% # ( 870, 1300 ] 3 15.000% 95.000% ### ( 1300, 1900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 6.0 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 328.47 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.201 H:M:S, 3.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 314.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:0.201 H:M:S, 6.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/12/10-17:35:30 ... thread 0: (1000000,3000000) ops and (345927.0,340905.1) ops/second in (2.890783,8.800103) 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 14/4 2.20 GB 200.4 1.8 0.0 1.8 4.5 2.8 0.0 1.6 119.9 305.3 15.22 14.47 51 0.298 1852K 9115 0.0 0.0 L1 2/0 49.72 MB 5.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 241.5 239.8 2.60 2.55 2 1.301 638K 4326 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 0.4 2.0 238.8 238.4 0.53 0.51 1 0.527 127K 182 0.0 0.0 L3 21/0 977.09 MB 1.0 1.4 0.5 0.9 1.4 0.5 0.2 2.8 225.3 224.2 6.40 6.14 5 1.280 1464K 7204 0.0 0.0 L4 126/0 9.54 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 220.3 220.3 1.16 1.10 1 1.160 259K 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/4 21.97 GB 0.0 4.2 1.2 2.9 6.9 4.0 1.6 2.5 165.1 273.5 25.91 24.78 60 0.432 4342K 20K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.2 1.2 2.9 6.9 4.0 1.2 2.5 165.1 273.5 25.91 24.78 60 0.432 4342K 20K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.2 1.2 2.9 4.2 1.2 0.0 0.0 237.6 236.5 17.99 17.47 16 1.125 4342K 20K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 357.8 7.91 7.31 44 0.180 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 8.9 total, 8.8 interval Flush(GB): cumulative 2.765, interval 2.765 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.92 GB write, 797.70 MB/s write, 4.18 GB read, 481.37 MB/s read, 25.9 seconds Interval compaction: 6.92 GB write, 805.05 MB/s write, 4.18 GB read, 485.81 MB/s read, 25.9 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: 1, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 1, interval: 1 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 643826 Average: 2.3754 StdDev: 5.90 Min: 0 Median: 1.5974 Max: 1285 Percentiles: P50: 1.60 P75: 2.00 P99: 6.32 P99.9: 13.22 P99.99: 18.08 ------------------------------------------------------ [ 0, 1 ] 80535 12.509% 12.509% ### ( 1, 2 ] 404079 62.762% 75.271% ############# ( 2, 3 ] 99144 15.399% 90.670% ### ( 3, 4 ] 30757 4.777% 95.447% # ( 4, 6 ] 22451 3.487% 98.934% # ( 6, 10 ] 5259 0.817% 99.751% ( 10, 15 ] 1486 0.231% 99.982% ( 15, 22 ] 115 0.018% 100.000% ( 22, 34 ] 15 0.002% 100.002% ( 34, 51 ] 3 0.000% 100.003% ( 51, 76 ] 8 0.001% 100.004% ( 76, 110 ] 2 0.000% 100.004% ( 170, 250 ] 43 0.007% 100.011% ( 250, 380 ] 19 0.003% 100.014% ( 380, 580 ] 27 0.004% 100.018% ( 580, 870 ] 1 0.000% 100.018% ( 870, 1300 ] 12 0.002% 100.020% ** Level 1 read latency histogram (micros): Count: 145849 Average: 2.8007 StdDev: 7.28 Min: 0 Median: 1.7609 Max: 850 Percentiles: P50: 1.76 P75: 2.53 P99: 8.93 P99.9: 18.55 P99.99: 187.33 ------------------------------------------------------ [ 0, 1 ] 9377 6.429% 6.429% # ( 1, 2 ] 83511 57.259% 63.688% ########### ( 2, 3 ] 31029 21.275% 84.963% #### ( 3, 4 ] 10119 6.938% 91.901% # ( 4, 6 ] 8722 5.980% 97.881% # ( 6, 10 ] 2225 1.526% 99.406% ( 10, 15 ] 678 0.465% 99.871% ( 15, 22 ] 83 0.057% 99.928% ( 22, 34 ] 7 0.005% 99.933% ( 34, 51 ] 1 0.001% 99.933% ( 51, 76 ] 3 0.002% 99.936% ( 76, 110 ] 8 0.005% 99.941% ( 110, 170 ] 66 0.045% 99.986% ( 170, 250 ] 25 0.017% 100.003% ( 250, 380 ] 11 0.008% 100.011% ( 380, 580 ] 6 0.004% 100.015% ( 580, 870 ] 5 0.003% 100.019% ** Level 2 read latency histogram (micros): Count: 72758 Average: 2.8801 StdDev: 16.21 Min: 0 Median: 1.6656 Max: 2341 Percentiles: P50: 1.67 P75: 2.18 P99: 8.98 P99.9: 132.76 P99.99: 516.21 ------------------------------------------------------ [ 0, 1 ] 4640 6.377% 6.377% # ( 1, 2 ] 47685 65.539% 71.916% ############# ( 2, 3 ] 12682 17.430% 89.347% ### ( 3, 4 ] 3429 4.713% 94.060% # ( 4, 6 ] 2722 3.741% 97.801% # ( 6, 10 ] 1171 1.609% 99.410% ( 10, 15 ] 187 0.257% 99.667% ( 15, 22 ] 16 0.022% 99.689% ( 22, 34 ] 6 0.008% 99.698% ( 34, 51 ] 81 0.111% 99.809% ( 51, 76 ] 43 0.059% 99.868% ( 76, 110 ] 2 0.003% 99.871% ( 110, 170 ] 56 0.077% 99.948% ( 170, 250 ] 20 0.027% 99.975% ( 250, 380 ] 8 0.011% 99.986% ( 380, 580 ] 4 0.005% 99.992% ( 580, 870 ] 1 0.001% 99.993% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 2 0.003% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 260318 Average: 3.7130 StdDev: 50.99 Min: 1 Median: 1.7977 Max: 9750 Percentiles: P50: 1.80 P75: 2.58 P99: 10.32 P99.9: 156.59 P99.99: 300.10 ------------------------------------------------------ [ 0, 1 ] 9704 3.728% 3.728% # ( 1, 2 ] 151004 58.008% 61.735% ############ ( 2, 3 ] 59280 22.772% 84.507% ##### ( 3, 4 ] 16577 6.368% 90.875% # ( 4, 6 ] 15255 5.860% 96.736% # ( 6, 10 ] 5791 2.225% 98.960% ( 10, 15 ] 1630 0.626% 99.586% ( 15, 22 ] 197 0.076% 99.662% ( 22, 34 ] 22 0.008% 99.670% ( 34, 51 ] 146 0.056% 99.726% ( 51, 76 ] 109 0.042% 99.768% ( 76, 110 ] 88 0.034% 99.802% ( 110, 170 ] 328 0.126% 99.928% ( 170, 250 ] 139 0.053% 99.982% ( 250, 380 ] 57 0.022% 100.003% ( 380, 580 ] 20 0.008% 100.011% ( 580, 870 ] 11 0.004% 100.015% ( 870, 1300 ] 11 0.004% 100.020% ( 1300, 1900 ] 12 0.005% 100.024% ( 1900, 2900 ] 11 0.004% 100.028% ( 2900, 4400 ] 3 0.001% 100.030% ( 4400, 6600 ] 3 0.001% 100.031% ( 6600, 9900 ] 6 0.002% 100.033% ** Level 4 read latency histogram (micros): Count: 45 Average: 1124.5111 StdDev: 2104.10 Min: 0 Median: 152.0000 Max: 8532 Percentiles: P50: 152.00 P75: 1192.50 P99: 8532.00 P99.9: 8532.00 P99.99: 8532.00 ------------------------------------------------------ [ 0, 1 ] 10 22.222% 22.222% #### ( 1, 2 ] 7 15.556% 37.778% ### ( 2, 3 ] 1 2.222% 40.000% ( 22, 34 ] 1 2.222% 42.222% ( 110, 170 ] 5 11.111% 53.333% ## ( 170, 250 ] 4 8.889% 62.222% ## ( 250, 380 ] 1 2.222% 64.444% ( 380, 580 ] 1 2.222% 66.667% ( 870, 1300 ] 5 11.111% 77.778% ## ( 1300, 1900 ] 4 8.889% 86.667% ## ( 2900, 4400 ] 1 2.222% 88.889% ( 4400, 6600 ] 2 4.444% 93.333% # ( 6600, 9900 ] 3 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 384.2000 StdDev: 446.09 Min: 95 Median: 152.8571 Max: 1877 Percentiles: P50: 152.86 P75: 480.00 P99: 1780.00 P99.9: 1877.00 P99.99: 1877.00 ------------------------------------------------------ ( 76, 110 ] 15 37.500% 37.500% ######## ( 110, 170 ] 7 17.500% 55.000% #### ( 170, 250 ] 1 2.500% 57.500% # ( 250, 380 ] 6 15.000% 72.500% ### ( 380, 580 ] 2 5.000% 77.500% # ( 580, 870 ] 1 2.500% 80.000% # ( 870, 1300 ] 6 15.000% 95.000% ### ( 1300, 1900 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 8.9 total, 2.9 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 332.38 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.201 H:M:S, 2.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 340.46 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: 1 num-running-flushes: 1 2024/12/10-17:35:33 ... thread 0: (1000000,4000000) ops and (334367.1,339246.7) ops/second in (2.990725,11.790828) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/4 3.18 GB 300.4 2.8 0.0 2.8 6.6 3.7 0.0 1.8 130.7 303.3 22.14 21.12 70 0.316 2938K 14K 0.0 0.0 L1 2/0 49.72 MB 5.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 241.5 239.8 2.60 2.55 2 1.301 638K 4326 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 0.4 2.0 238.8 238.4 0.53 0.51 1 0.527 127K 182 0.0 0.0 L3 21/0 977.09 MB 1.0 1.4 0.5 0.9 1.4 0.5 0.2 2.8 225.3 224.2 6.40 6.14 5 1.280 1464K 7204 0.0 0.0 L4 126/0 9.54 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 220.3 220.3 1.16 1.10 1 1.160 259K 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 8.9 5.0 1.6 2.4 162.8 278.9 32.83 31.42 79 0.416 5428K 26K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.2 1.2 4.0 8.9 5.0 1.2 2.4 162.8 278.9 32.83 31.42 79 0.416 5428K 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 5.2 1.2 4.0 5.2 1.2 0.0 0.0 241.1 239.9 22.17 21.57 20 1.109 5428K 26K 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 360.0 10.66 9.85 59 0.181 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 11.9 total, 11.8 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.94 GB write, 771.11 MB/s write, 5.22 GB read, 450.18 MB/s read, 32.8 seconds Interval compaction: 8.94 GB write, 776.41 MB/s write, 5.22 GB read, 453.27 MB/s read, 32.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: 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: 903095 Average: 2.2886 StdDev: 6.24 Min: 0 Median: 1.5513 Max: 1698 Percentiles: P50: 1.55 P75: 1.94 P99: 5.94 P99.9: 12.91 P99.99: 18.01 ------------------------------------------------------ [ 0, 1 ] 132437 14.665% 14.665% ### ( 1, 2 ] 578827 64.094% 78.758% ############# ( 2, 3 ] 121478 13.451% 92.210% ### ( 3, 4 ] 36972 4.094% 96.304% # ( 4, 6 ] 25161 2.786% 99.090% # ( 6, 10 ] 6273 0.695% 99.784% ( 10, 15 ] 1798 0.199% 99.984% ( 15, 22 ] 141 0.016% 99.999% ( 22, 34 ] 17 0.002% 100.001% ( 34, 51 ] 5 0.001% 100.002% ( 51, 76 ] 10 0.001% 100.003% ( 76, 110 ] 3 0.000% 100.003% ( 170, 250 ] 57 0.006% 100.009% ( 250, 380 ] 30 0.003% 100.013% ( 380, 580 ] 31 0.003% 100.016% ( 580, 870 ] 2 0.000% 100.016% ( 870, 1300 ] 19 0.002% 100.018% ( 1300, 1900 ] 1 0.000% 100.018% ** Level 1 read latency histogram (micros): Count: 145849 Average: 2.8007 StdDev: 7.28 Min: 0 Median: 1.7609 Max: 850 Percentiles: P50: 1.76 P75: 2.53 P99: 8.93 P99.9: 18.55 P99.99: 187.33 ------------------------------------------------------ [ 0, 1 ] 9377 6.429% 6.429% # ( 1, 2 ] 83511 57.259% 63.688% ########### ( 2, 3 ] 31029 21.275% 84.963% #### ( 3, 4 ] 10119 6.938% 91.901% # ( 4, 6 ] 8722 5.980% 97.881% # ( 6, 10 ] 2225 1.526% 99.406% ( 10, 15 ] 678 0.465% 99.871% ( 15, 22 ] 83 0.057% 99.928% ( 22, 34 ] 7 0.005% 99.933% ( 34, 51 ] 1 0.001% 99.933% ( 51, 76 ] 3 0.002% 99.936% ( 76, 110 ] 8 0.005% 99.941% ( 110, 170 ] 66 0.045% 99.986% ( 170, 250 ] 25 0.017% 100.003% ( 250, 380 ] 11 0.008% 100.011% ( 380, 580 ] 6 0.004% 100.015% ( 580, 870 ] 5 0.003% 100.019% ** Level 2 read latency histogram (micros): Count: 72758 Average: 2.8801 StdDev: 16.21 Min: 0 Median: 1.6656 Max: 2341 Percentiles: P50: 1.67 P75: 2.18 P99: 8.98 P99.9: 132.76 P99.99: 516.21 ------------------------------------------------------ [ 0, 1 ] 4640 6.377% 6.377% # ( 1, 2 ] 47685 65.539% 71.916% ############# ( 2, 3 ] 12682 17.430% 89.347% ### ( 3, 4 ] 3429 4.713% 94.060% # ( 4, 6 ] 2722 3.741% 97.801% # ( 6, 10 ] 1171 1.609% 99.410% ( 10, 15 ] 187 0.257% 99.667% ( 15, 22 ] 16 0.022% 99.689% ( 22, 34 ] 6 0.008% 99.698% ( 34, 51 ] 81 0.111% 99.809% ( 51, 76 ] 43 0.059% 99.868% ( 76, 110 ] 2 0.003% 99.871% ( 110, 170 ] 56 0.077% 99.948% ( 170, 250 ] 20 0.027% 99.975% ( 250, 380 ] 8 0.011% 99.986% ( 380, 580 ] 4 0.005% 99.992% ( 580, 870 ] 1 0.001% 99.993% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 2 0.003% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 260318 Average: 3.7130 StdDev: 50.99 Min: 1 Median: 1.7977 Max: 9750 Percentiles: P50: 1.80 P75: 2.58 P99: 10.32 P99.9: 156.59 P99.99: 300.10 ------------------------------------------------------ [ 0, 1 ] 9704 3.728% 3.728% # ( 1, 2 ] 151004 58.008% 61.735% ############ ( 2, 3 ] 59280 22.772% 84.507% ##### ( 3, 4 ] 16577 6.368% 90.875% # ( 4, 6 ] 15255 5.860% 96.736% # ( 6, 10 ] 5791 2.225% 98.960% ( 10, 15 ] 1630 0.626% 99.586% ( 15, 22 ] 197 0.076% 99.662% ( 22, 34 ] 22 0.008% 99.670% ( 34, 51 ] 146 0.056% 99.726% ( 51, 76 ] 109 0.042% 99.768% ( 76, 110 ] 88 0.034% 99.802% ( 110, 170 ] 328 0.126% 99.928% ( 170, 250 ] 139 0.053% 99.982% ( 250, 380 ] 57 0.022% 100.003% ( 380, 580 ] 20 0.008% 100.011% ( 580, 870 ] 11 0.004% 100.015% ( 870, 1300 ] 11 0.004% 100.020% ( 1300, 1900 ] 12 0.005% 100.024% ( 1900, 2900 ] 11 0.004% 100.028% ( 2900, 4400 ] 3 0.001% 100.030% ( 4400, 6600 ] 3 0.001% 100.031% ( 6600, 9900 ] 6 0.002% 100.033% ** Level 4 read latency histogram (micros): Count: 45 Average: 1124.5111 StdDev: 2104.10 Min: 0 Median: 152.0000 Max: 8532 Percentiles: P50: 152.00 P75: 1192.50 P99: 8532.00 P99.9: 8532.00 P99.99: 8532.00 ------------------------------------------------------ [ 0, 1 ] 10 22.222% 22.222% #### ( 1, 2 ] 7 15.556% 37.778% ### ( 2, 3 ] 1 2.222% 40.000% ( 22, 34 ] 1 2.222% 42.222% ( 110, 170 ] 5 11.111% 53.333% ## ( 170, 250 ] 4 8.889% 62.222% ## ( 250, 380 ] 1 2.222% 64.444% ( 380, 580 ] 1 2.222% 66.667% ( 870, 1300 ] 5 11.111% 77.778% ## ( 1300, 1900 ] 4 8.889% 86.667% ## ( 2900, 4400 ] 1 2.222% 88.889% ( 4400, 6600 ] 2 4.444% 93.333% # ( 6600, 9900 ] 3 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 384.2000 StdDev: 446.09 Min: 95 Median: 152.8571 Max: 1877 Percentiles: P50: 152.86 P75: 480.00 P99: 1780.00 P99.9: 1877.00 P99.99: 1877.00 ------------------------------------------------------ ( 76, 110 ] 15 37.500% 37.500% ######## ( 110, 170 ] 7 17.500% 55.000% #### ( 170, 250 ] 1 2.500% 57.500% # ( 250, 380 ] 6 15.000% 72.500% ### ( 380, 580 ] 2 5.000% 77.500% # ( 580, 870 ] 1 2.500% 80.000% # ( 870, 1300 ] 6 15.000% 95.000% ### ( 1300, 1900 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 11.9 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 331.54 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.360 H:M:S, 3.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 329.05 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.159 H:M:S, 5.3 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.055 micros/op 246610 ops/sec 20.105 seconds 4957999 operations; 238.9 MB/s Microseconds per write: Count: 4957999 Average: 4.0550 StdDev: 122.67 Min: 1 Median: 1.7753 Max: 201378 Percentiles: P50: 1.78 P75: 3.06 P99: 8.91 P99.9: 164.94 P99.99: 2322.95 ------------------------------------------------------ [ 0, 1 ] 608202 12.267% 12.267% ## ( 1, 2 ] 2413011 48.669% 60.936% ########## ( 2, 3 ] 655482 13.221% 74.157% ### ( 3, 4 ] 686057 13.837% 87.994% ### ( 4, 6 ] 498051 10.045% 98.040% ## ( 6, 10 ] 65458 1.320% 99.360% ( 10, 15 ] 16552 0.334% 99.694% ( 15, 22 ] 4542 0.092% 99.785% ( 22, 34 ] 1239 0.025% 99.810% ( 34, 51 ] 179 0.004% 99.814% ( 51, 76 ] 25 0.001% 99.814% ( 76, 110 ] 7 0.000% 99.815% ( 110, 170 ] 4626 0.093% 99.908% ( 170, 250 ] 304 0.006% 99.914% ( 250, 380 ] 88 0.002% 99.916% ( 380, 580 ] 12 0.000% 99.916% ( 580, 870 ] 4 0.000% 99.916% ( 870, 1300 ] 3297 0.066% 99.983% ( 1300, 1900 ] 6 0.000% 99.983% ( 1900, 2900 ] 854 0.017% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 160091 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 : 4957999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 5116654968 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 : 166 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 5702002 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 : 8202245799 rocksdb.compact.write.bytes COUNT : 8043601779 rocksdb.flush.write.bytes COUNT : 5079155511 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 : 15 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 : 98 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 : 5045443584 rocksdb.memtable.garbage.bytes.at.flush COUNT : 8592384 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 : 8245048184 rocksdb.non.last.level.read.count COUNT : 1989213 rocksdb.block.checksum.compute.count COUNT : 1988896 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.420021 P95 : 4.769667 P99 : 7.448992 P100 : 201375.000000 COUNT : 4957999 SUM : 17739284 rocksdb.compaction.times.micros P50 : 1030000.000000 P95 : 1853333.333333 P99 : 3077657.000000 P100 : 3077657.000000 COUNT : 24 SUM : 26058041 rocksdb.compaction.times.cpu_micros P50 : 1030000.000000 P95 : 1853333.333333 P99 : 2937895.000000 P100 : 2937895.000000 COUNT : 24 SUM : 25403156 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 : 562.500000 P95 : 1286.562500 P99 : 2150.000000 P100 : 2193.000000 COUNT : 75 SUM : 52899 rocksdb.compaction.outfile.sync.micros P50 : 716.714286 P95 : 1278.500000 P99 : 2081.000000 P100 : 2081.000000 COUNT : 77 SUM : 56793 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 : 84.206897 P95 : 227.600000 P99 : 376.533333 P100 : 391.000000 COUNT : 108 SUM : 11235 rocksdb.table.open.io.micros P50 : 781.294118 P95 : 14622.222222 P99 : 18866.000000 P100 : 18866.000000 COUNT : 166 SUM : 352219 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.637091 P95 : 6.929077 P99 : 10.857365 P100 : 1919.000000 COUNT : 1988464 SUM : 9130282 rocksdb.read.block.get.micros P50 : 354.776119 P95 : 3620.000000 P99 : 8682.666667 P100 : 9841.000000 COUNT : 332 SUM : 266314 rocksdb.write.raw.block.micros P50 : 0.512314 P95 : 0.973397 P99 : 3.029568 P100 : 4494.000000 COUNT : 3178752 SUM : 6074550 rocksdb.numfiles.in.singlecompaction P50 : 3.394737 P95 : 8.700000 P99 : 19.000000 P100 : 19.000000 COUNT : 33 SUM : 140 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.561269 P95 : 1161.669443 P99 : 2453.103044 P100 : 201164.000000 COUNT : 38365 SUM : 5706602 rocksdb.sst.read.micros P50 : 1.548043 P95 : 3.834313 P99 : 7.516397 P100 : 9750.000000 COUNT : 1989337 SUM : 5073670 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 : 4957999 SUM : 5116654968 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 : 175405.405405 P95 : 248378.378378 P99 : 347500.000000 P100 : 351481.000000 COUNT : 75 SUM : 13390248 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 : 101 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