[2024-07-12 15:46:15.908935] Starting SPDK v24.09-pre git sha1 51ac12a73 / DPDK 24.03.0 initialization... [2024-07-12 15:46:15.909272] [ 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_pid1647126 ] Set seed to 1720791975901636 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-12 15:46:16.054448] app.c: 908:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-12 15:46:16.285264] app.c: 603:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-12 15:46:16.285310] app.c: 604:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1647126' to capture a snapshot of events at runtime. [2024-07-12 15:46:16.285323] app.c: 609:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-12 15:46:16.285336] app.c: 610:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-12 15:46:16.285346] app.c: 611:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1647126 for offline analysis/debug. [2024-07-12 15:46:16.285441] reactor.c: 941:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Jul 12 15:46:20 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/07/12-15:46:23 ... thread 0: (1000000,1000000) ops and (334725.9,334725.9) ops/second in (2.987519,2.987519) 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.16 MB 12.6 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 349.4 2.52 2.35 13 0.194 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 258.0 257.4 0.73 0.72 1 0.731 191K 407 0.0 0.0 L2 1/1 100.71 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.0 2.5 243.3 242.8 0.66 0.63 1 0.661 163K 318 0.0 0.0 L3 19/12 1004.58 MB 0.1 0.1 0.1 0.0 0.1 0.1 0.0 1.0 214.3 214.3 0.28 0.26 1 0.278 60K 0 0.0 0.0 L4 124/0 9.60 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/24 20.09 GB 0.0 0.4 0.3 0.1 1.3 1.2 0.1 1.5 97.6 307.6 4.19 3.96 16 0.262 415K 725 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 97.6 307.6 4.19 3.96 16 0.262 415K 725 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.9 244.4 1.67 1.61 3 0.557 415K 725 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 349.4 2.52 2.35 13 0.194 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, 419.67 MB/s write, 0.40 GB read, 133.15 MB/s read, 4.2 seconds Interval compaction: 1.26 GB write, 431.06 MB/s write, 0.40 GB read, 136.77 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: 130203 Average: 2.1188 StdDev: 5.69 Min: 0 Median: 1.4344 Max: 1163 Percentiles: P50: 1.43 P75: 1.84 P99: 5.81 P99.9: 12.40 P99.99: 183.20 ------------------------------------------------------ [ 0, 1 ] 30330 23.294% 23.294% ##### ( 1, 2 ] 80044 61.476% 84.771% ############ ( 2, 3 ] 11581 8.895% 93.665% ## ( 3, 4 ] 4323 3.320% 96.985% # ( 4, 6 ] 2894 2.223% 99.208% ( 6, 10 ] 825 0.634% 99.842% ( 10, 15 ] 162 0.124% 99.966% ( 15, 22 ] 20 0.015% 99.982% ( 22, 34 ] 7 0.005% 99.987% ( 34, 51 ] 2 0.002% 99.988% ( 51, 76 ] 1 0.001% 99.989% ( 76, 110 ] 1 0.001% 99.990% ( 170, 250 ] 12 0.009% 99.999% ( 250, 380 ] 2 0.002% 100.001% ( 380, 580 ] 11 0.008% 100.009% ( 870, 1300 ] 1 0.001% 100.010% ** Level 1 read latency histogram (micros): Count: 27123 Average: 2.1886 StdDev: 5.51 Min: 0 Median: 1.4976 Max: 706 Percentiles: P50: 1.50 P75: 1.90 P99: 5.70 P99.9: 10.22 P99.99: 287.40 ------------------------------------------------------ [ 0, 1 ] 5078 18.722% 18.722% #### ( 1, 2 ] 17052 62.869% 81.591% ############# ( 2, 3 ] 3032 11.179% 92.770% ## ( 3, 4 ] 1050 3.871% 96.641% # ( 4, 6 ] 755 2.784% 99.425% # ( 6, 10 ] 131 0.483% 99.908% ( 10, 15 ] 20 0.074% 99.982% ( 15, 22 ] 3 0.011% 99.993% ( 22, 34 ] 1 0.004% 99.996% ( 170, 250 ] 1 0.004% 100.000% ( 250, 380 ] 1 0.004% 100.004% ( 380, 580 ] 1 0.004% 100.007% ( 580, 870 ] 1 0.004% 100.011% ** Level 2 read latency histogram (micros): Count: 40097 Average: 3.0795 StdDev: 42.86 Min: 1 Median: 1.4752 Max: 5668 Percentiles: P50: 1.48 P75: 1.90 P99: 9.36 P99.9: 152.48 P99.99: 1894.18 ------------------------------------------------------ [ 0, 1 ] 8795 21.934% 21.934% #### ( 1, 2 ] 23681 59.059% 80.994% ############ ( 2, 3 ] 3755 9.365% 90.358% ## ( 3, 4 ] 1514 3.776% 94.134% # ( 4, 6 ] 1482 3.696% 97.830% # ( 6, 10 ] 558 1.392% 99.222% ( 10, 15 ] 145 0.362% 99.584% ( 15, 22 ] 23 0.057% 99.641% ( 22, 34 ] 1 0.002% 99.643% ( 34, 51 ] 22 0.055% 99.698% ( 51, 76 ] 10 0.025% 99.723% ( 76, 110 ] 44 0.110% 99.833% ( 110, 170 ] 38 0.095% 99.928% ( 170, 250 ] 14 0.035% 99.963% ( 250, 380 ] 7 0.017% 99.980% ( 380, 580 ] 1 0.002% 99.983% ( 580, 870 ] 2 0.005% 99.988% ( 1300, 1900 ] 1 0.002% 99.990% ( 1900, 2900 ] 1 0.002% 99.993% ( 2900, 4400 ] 2 0.005% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 30984 Average: 8.4881 StdDev: 144.03 Min: 1 Median: 1.6925 Max: 5751 Percentiles: P50: 1.69 P75: 2.35 P99: 12.21 P99.9: 2719.64 P99.99: 5751.00 ------------------------------------------------------ [ 0, 1 ] 1800 5.809% 5.809% # ( 1, 2 ] 19771 63.810% 69.620% ############# ( 2, 3 ] 4698 15.163% 84.782% ### ( 3, 4 ] 2158 6.965% 91.747% # ( 4, 6 ] 1507 4.864% 96.611% # ( 6, 10 ] 662 2.137% 98.748% ( 10, 15 ] 177 0.571% 99.319% ( 15, 22 ] 14 0.045% 99.364% ( 22, 34 ] 3 0.010% 99.374% ( 34, 51 ] 21 0.068% 99.442% ( 51, 76 ] 10 0.032% 99.474% ( 76, 110 ] 15 0.048% 99.522% ( 110, 170 ] 68 0.219% 99.742% ( 170, 250 ] 17 0.055% 99.797% ( 250, 380 ] 6 0.019% 99.816% ( 380, 580 ] 4 0.013% 99.829% ( 580, 870 ] 5 0.016% 99.845% ( 870, 1300 ] 4 0.013% 99.858% ( 1300, 1900 ] 4 0.013% 99.871% ( 1900, 2900 ] 11 0.036% 99.906% ( 2900, 4400 ] 11 0.036% 99.942% ( 4400, 6600 ] 18 0.058% 100.000% ** Level 4 read latency histogram (micros): Count: 10 Average: 2482.1000 StdDev: 1582.03 Min: 558 Median: 2400.0000 Max: 5087 Percentiles: P50: 2400.00 P75: 4025.00 P99: 5087.00 P99.9: 5087.00 P99.99: 5087.00 ------------------------------------------------------ ( 380, 580 ] 1 10.000% 10.000% ## ( 580, 870 ] 2 20.000% 30.000% #### ( 1300, 1900 ] 1 10.000% 40.000% ## ( 1900, 2900 ] 2 20.000% 60.000% #### ( 2900, 4400 ] 2 20.000% 80.000% #### ( 4400, 6600 ] 2 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, 320.43 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.205 H:M:S, 6.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 329.04 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.205 H:M:S, 6.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/12-15:46:26 ... thread 0: (1000000,2000000) ops and (324119.0,329337.0) ops/second in (3.085287,6.072806) 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.35 GB 106.4 1.0 0.0 1.0 2.8 1.8 0.0 1.5 107.2 307.6 9.39 8.89 32 0.293 1022K 4951 0.0 0.0 L1 1/0 49.63 MB 5.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 242.4 240.8 2.59 2.54 2 1.296 638K 4177 0.0 0.0 L2 1/1 100.71 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.4 2.5 243.3 242.8 0.66 0.63 1 0.661 163K 318 0.0 0.0 L3 23/12 1.36 GB 0.4 0.5 0.4 0.1 0.5 0.4 0.0 1.2 212.8 212.3 2.58 2.45 4 0.644 556K 1236 0.0 0.0 L4 124/0 9.60 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 270/17 21.06 GB 0.0 2.3 0.9 1.4 4.1 2.8 0.4 2.2 154.0 277.3 15.22 14.52 39 0.390 2380K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 2.3 0.9 1.4 4.1 2.8 0.4 2.2 154.0 277.3 15.22 14.52 39 0.390 2380K 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 238.1 237.0 9.85 9.55 11 0.895 2380K 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 351.1 5.37 4.97 28 0.192 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.2 total, 6.1 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: 4.12 GB write, 685.51 MB/s write, 2.29 GB read, 380.75 MB/s read, 15.2 seconds Interval compaction: 4.12 GB write, 694.67 MB/s write, 2.29 GB read, 385.84 MB/s read, 15.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 397262 Average: 2.4679 StdDev: 6.92 Min: 0 Median: 1.6389 Max: 1806 Percentiles: P50: 1.64 P75: 2.17 P99: 6.39 P99.9: 13.26 P99.99: 21.78 ------------------------------------------------------ [ 0, 1 ] 42433 10.681% 10.681% ## ( 1, 2 ] 244465 61.537% 72.219% ############ ( 2, 3 ] 66943 16.851% 89.070% ### ( 3, 4 ] 22535 5.673% 94.743% # ( 4, 6 ] 16580 4.174% 98.916% # ( 6, 10 ] 3392 0.854% 99.770% ( 10, 15 ] 793 0.200% 99.970% ( 15, 22 ] 85 0.021% 99.991% ( 22, 34 ] 14 0.004% 99.994% ( 34, 51 ] 5 0.001% 99.996% ( 51, 76 ] 5 0.001% 99.997% ( 76, 110 ] 8 0.002% 99.999% ( 110, 170 ] 22 0.006% 100.005% ( 170, 250 ] 29 0.007% 100.012% ( 250, 380 ] 6 0.002% 100.013% ( 380, 580 ] 25 0.006% 100.020% ( 580, 870 ] 3 0.001% 100.020% ( 870, 1300 ] 6 0.002% 100.022% ( 1300, 1900 ] 1 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 145837 Average: 2.9110 StdDev: 8.70 Min: 0 Median: 1.7837 Max: 797 Percentiles: P50: 1.78 P75: 2.56 P99: 8.71 P99.9: 116.38 P99.99: 241.27 ------------------------------------------------------ [ 0, 1 ] 7153 4.905% 4.905% # ( 1, 2 ] 83918 57.542% 62.447% ############ ( 2, 3 ] 32543 22.315% 84.762% #### ( 3, 4 ] 10248 7.027% 91.789% # ( 4, 6 ] 8888 6.094% 97.883% # ( 6, 10 ] 2400 1.646% 99.529% ( 10, 15 ] 445 0.305% 99.834% ( 15, 22 ] 69 0.047% 99.881% ( 22, 34 ] 10 0.007% 99.888% ( 34, 51 ] 1 0.001% 99.889% ( 51, 76 ] 1 0.001% 99.890% ( 76, 110 ] 4 0.003% 99.892% ( 110, 170 ] 105 0.072% 99.964% ( 170, 250 ] 42 0.029% 99.993% ( 250, 380 ] 17 0.012% 100.005% ( 380, 580 ] 12 0.008% 100.013% ( 580, 870 ] 6 0.004% 100.017% ** Level 2 read latency histogram (micros): Count: 40712 Average: 3.4910 StdDev: 43.50 Min: 1 Median: 1.4865 Max: 5668 Percentiles: P50: 1.49 P75: 1.91 P99: 10.00 P99.9: 220.94 P99.99: 1857.28 ------------------------------------------------------ [ 0, 1 ] 8795 21.603% 21.603% #### ( 1, 2 ] 23762 58.366% 79.969% ############ ( 2, 3 ] 4080 10.022% 89.991% ## ( 3, 4 ] 1581 3.883% 93.874% # ( 4, 6 ] 1520 3.734% 97.608% # ( 6, 10 ] 567 1.393% 99.000% ( 10, 15 ] 145 0.356% 99.356% ( 15, 22 ] 23 0.056% 99.413% ( 22, 34 ] 1 0.002% 99.415% ( 34, 51 ] 22 0.054% 99.469% ( 51, 76 ] 10 0.025% 99.494% ( 76, 110 ] 44 0.108% 99.602% ( 110, 170 ] 99 0.243% 99.845% ( 170, 250 ] 35 0.086% 99.931% ( 250, 380 ] 18 0.044% 99.975% ( 380, 580 ] 3 0.007% 99.983% ( 580, 870 ] 2 0.005% 99.988% ( 1300, 1900 ] 1 0.002% 99.990% ( 1900, 2900 ] 1 0.002% 99.993% ( 2900, 4400 ] 2 0.005% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 254541 Average: 3.6230 StdDev: 50.94 Min: 1 Median: 1.7068 Max: 5751 Percentiles: P50: 1.71 P75: 2.37 P99: 9.37 P99.9: 154.14 P99.99: 469.96 ------------------------------------------------------ [ 0, 1 ] 13767 5.409% 5.409% # ( 1, 2 ] 160592 63.091% 68.499% ############# ( 2, 3 ] 45218 17.765% 86.264% #### ( 3, 4 ] 16640 6.537% 92.801% # ( 4, 6 ] 11333 4.452% 97.253% # ( 6, 10 ] 5275 2.072% 99.326% ( 10, 15 ] 673 0.264% 99.590% ( 15, 22 ] 75 0.029% 99.620% ( 22, 34 ] 13 0.005% 99.625% ( 34, 51 ] 250 0.098% 99.723% ( 51, 76 ] 189 0.074% 99.797% ( 76, 110 ] 79 0.031% 99.828% ( 110, 170 ] 248 0.097% 99.926% ( 170, 250 ] 105 0.041% 99.967% ( 250, 380 ] 50 0.020% 99.987% ( 380, 580 ] 19 0.007% 99.994% ( 580, 870 ] 8 0.003% 99.997% ( 870, 1300 ] 4 0.002% 99.999% ( 1300, 1900 ] 4 0.002% 100.000% ( 1900, 2900 ] 11 0.004% 100.005% ( 2900, 4400 ] 11 0.004% 100.009% ( 4400, 6600 ] 18 0.007% 100.016% ** Level 4 read latency histogram (micros): Count: 10 Average: 2482.1000 StdDev: 1582.03 Min: 558 Median: 2400.0000 Max: 5087 Percentiles: P50: 2400.00 P75: 4025.00 P99: 5087.00 P99.9: 5087.00 P99.99: 5087.00 ------------------------------------------------------ ( 380, 580 ] 1 10.000% 10.000% ## ( 580, 870 ] 2 20.000% 30.000% #### ( 1300, 1900 ] 1 10.000% 40.000% ## ( 1900, 2900 ] 2 20.000% 60.000% #### ( 2900, 4400 ] 2 20.000% 80.000% #### ( 4400, 6600 ] 2 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 6.2 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 319.73 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.386 H:M:S, 6.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.04 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.181 H:M:S, 5.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/12-15:46:28 ... thread 0: (1000000,3000000) ops and (360128.5,338998.6) ops/second in (2.776787,8.849593) 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.7 0.0 1.7 121.4 305.0 15.02 14.26 49 0.307 1852K 9290 0.0 0.0 L1 1/0 49.63 MB 5.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 242.4 240.8 2.59 2.54 2 1.296 638K 4177 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 243.3 242.8 0.66 0.63 1 0.661 163K 318 0.0 0.0 L3 18/0 748.97 MB 0.7 1.6 0.5 1.0 1.6 0.5 0.0 2.9 238.7 238.1 6.68 6.37 5 1.336 1619K 4200 0.0 0.0 L4 130/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 229.6 229.6 0.97 0.93 1 0.973 226K 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.91 GB 0.0 4.3 1.2 3.1 7.0 3.9 1.6 2.6 170.9 276.9 25.93 24.74 58 0.447 4499K 17K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.3 1.2 3.1 7.0 3.9 1.6 2.6 170.9 276.9 25.93 24.74 58 0.447 4499K 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.1 4.3 1.2 0.0 0.0 244.1 243.1 18.15 17.55 16 1.134 4499K 17K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 355.8 7.78 7.18 42 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): 8.9 total, 8.9 interval Flush(GB): cumulative 2.703, interval 2.703 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, 803.78 MB/s write, 4.33 GB read, 495.97 MB/s read, 25.9 seconds Interval compaction: 7.01 GB write, 811.15 MB/s write, 4.33 GB read, 500.52 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: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 640087 Average: 2.3817 StdDev: 6.37 Min: 0 Median: 1.6028 Max: 1806 Percentiles: P50: 1.60 P75: 2.00 P99: 5.95 P99.9: 12.88 P99.99: 21.09 ------------------------------------------------------ [ 0, 1 ] 74220 11.595% 11.595% ## ( 1, 2 ] 407811 63.712% 75.307% ############# ( 2, 3 ] 99188 15.496% 90.803% ### ( 3, 4 ] 31202 4.875% 95.678% # ( 4, 6 ] 21795 3.405% 99.083% # ( 6, 10 ] 4577 0.715% 99.798% ( 10, 15 ] 1137 0.178% 99.975% ( 15, 22 ] 108 0.017% 99.992% ( 22, 34 ] 19 0.003% 99.995% ( 34, 51 ] 6 0.001% 99.996% ( 51, 76 ] 7 0.001% 99.997% ( 76, 110 ] 9 0.001% 99.999% ( 110, 170 ] 22 0.003% 100.002% ( 170, 250 ] 43 0.007% 100.009% ( 250, 380 ] 12 0.002% 100.011% ( 380, 580 ] 34 0.005% 100.016% ( 580, 870 ] 6 0.001% 100.017% ( 870, 1300 ] 8 0.001% 100.018% ( 1300, 1900 ] 1 0.000% 100.018% ** Level 1 read latency histogram (micros): Count: 145837 Average: 2.9110 StdDev: 8.70 Min: 0 Median: 1.7837 Max: 797 Percentiles: P50: 1.78 P75: 2.56 P99: 8.71 P99.9: 116.38 P99.99: 241.27 ------------------------------------------------------ [ 0, 1 ] 7153 4.905% 4.905% # ( 1, 2 ] 83918 57.542% 62.447% ############ ( 2, 3 ] 32543 22.315% 84.762% #### ( 3, 4 ] 10248 7.027% 91.789% # ( 4, 6 ] 8888 6.094% 97.883% # ( 6, 10 ] 2400 1.646% 99.529% ( 10, 15 ] 445 0.305% 99.834% ( 15, 22 ] 69 0.047% 99.881% ( 22, 34 ] 10 0.007% 99.888% ( 34, 51 ] 1 0.001% 99.889% ( 51, 76 ] 1 0.001% 99.890% ( 76, 110 ] 4 0.003% 99.892% ( 110, 170 ] 105 0.072% 99.964% ( 170, 250 ] 42 0.029% 99.993% ( 250, 380 ] 17 0.012% 100.005% ( 380, 580 ] 12 0.008% 100.013% ( 580, 870 ] 6 0.004% 100.017% ** Level 2 read latency histogram (micros): Count: 65581 Average: 3.0214 StdDev: 34.28 Min: 1 Median: 1.5161 Max: 5668 Percentiles: P50: 1.52 P75: 1.92 P99: 9.14 P99.9: 168.44 P99.99: 644.08 ------------------------------------------------------ [ 0, 1 ] 11602 17.691% 17.691% #### ( 1, 2 ] 41055 62.602% 80.293% ############# ( 2, 3 ] 7083 10.800% 91.093% ## ( 3, 4 ] 2379 3.628% 94.721% # ( 4, 6 ] 1986 3.028% 97.749% # ( 6, 10 ] 1044 1.592% 99.341% ( 10, 15 ] 169 0.258% 99.599% ( 15, 22 ] 24 0.037% 99.636% ( 22, 34 ] 1 0.002% 99.637% ( 34, 51 ] 22 0.034% 99.671% ( 51, 76 ] 10 0.015% 99.686% ( 76, 110 ] 44 0.067% 99.753% ( 110, 170 ] 99 0.151% 99.904% ( 170, 250 ] 35 0.053% 99.957% ( 250, 380 ] 18 0.027% 99.985% ( 380, 580 ] 3 0.005% 99.989% ( 580, 870 ] 2 0.003% 99.992% ( 1300, 1900 ] 1 0.002% 99.994% ( 1900, 2900 ] 1 0.002% 99.995% ( 2900, 4400 ] 2 0.003% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 322813 Average: 3.5011 StdDev: 45.65 Min: 1 Median: 1.7021 Max: 5751 Percentiles: P50: 1.70 P75: 2.34 P99: 9.37 P99.9: 161.30 P99.99: 496.99 ------------------------------------------------------ [ 0, 1 ] 17237 5.340% 5.340% # ( 1, 2 ] 205333 63.607% 68.947% ############# ( 2, 3 ] 58116 18.003% 86.950% #### ( 3, 4 ] 19693 6.100% 93.050% # ( 4, 6 ] 13595 4.211% 97.262% # ( 6, 10 ] 6654 2.061% 99.323% ( 10, 15 ] 951 0.295% 99.618% ( 15, 22 ] 99 0.031% 99.648% ( 22, 34 ] 13 0.004% 99.652% ( 34, 51 ] 250 0.077% 99.730% ( 51, 76 ] 190 0.059% 99.789% ( 76, 110 ] 83 0.026% 99.814% ( 110, 170 ] 323 0.100% 99.915% ( 170, 250 ] 147 0.046% 99.960% ( 250, 380 ] 78 0.024% 99.984% ( 380, 580 ] 32 0.010% 99.994% ( 580, 870 ] 10 0.003% 99.997% ( 870, 1300 ] 6 0.002% 99.999% ( 1300, 1900 ] 4 0.001% 100.000% ( 1900, 2900 ] 11 0.003% 100.004% ( 2900, 4400 ] 11 0.003% 100.007% ( 4400, 6600 ] 18 0.006% 100.013% ** Level 4 read latency histogram (micros): Count: 40 Average: 660.1000 StdDev: 1318.33 Min: 1 Median: 34.0000 Max: 5087 Percentiles: P50: 34.00 P75: 380.00 P99: 5087.00 P99.9: 5087.00 P99.99: 5087.00 ------------------------------------------------------ [ 0, 1 ] 9 22.500% 22.500% ##### ( 1, 2 ] 9 22.500% 45.000% ##### ( 15, 22 ] 1 2.500% 47.500% # ( 22, 34 ] 1 2.500% 50.000% # ( 34, 51 ] 2 5.000% 55.000% # ( 110, 170 ] 6 15.000% 70.000% ### ( 170, 250 ] 1 2.500% 72.500% # ( 250, 380 ] 1 2.500% 75.000% # ( 380, 580 ] 1 2.500% 77.500% # ( 580, 870 ] 2 5.000% 82.500% # ( 1300, 1900 ] 1 2.500% 85.000% # ( 1900, 2900 ] 2 5.000% 90.000% # ( 2900, 4400 ] 2 5.000% 95.000% # ( 4400, 6600 ] 2 5.000% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 527.6500 StdDev: 504.10 Min: 129 Median: 325.8333 Max: 2187 Percentiles: P50: 325.83 P75: 725.00 P99: 2187.00 P99.9: 2187.00 P99.99: 2187.00 ------------------------------------------------------ ( 110, 170 ] 7 17.500% 17.500% #### ( 170, 250 ] 6 15.000% 32.500% ### ( 250, 380 ] 12 30.000% 62.500% ###### ( 380, 580 ] 3 7.500% 70.000% ## ( 580, 870 ] 4 10.000% 80.000% ## ( 870, 1300 ] 5 12.500% 92.500% ### ( 1300, 1900 ] 1 2.500% 95.000% # ( 1900, 2900 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 8.9 total, 2.8 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 330.52 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.386 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, 354.43 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/07/12-15:46:32 ... thread 0: (1000000,4000000) ops and (283272.6,323108.0) ops/second in (3.530169,12.379762) 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/16 3.24 GB 50.1 2.8 0.0 2.8 6.5 3.7 0.0 1.7 129.8 305.0 21.82 20.77 69 0.316 2874K 14K 0.0 0.0 L1 1/1 49.63 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 242.4 240.8 2.59 2.54 2 1.296 638K 4177 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 243.3 242.8 0.66 0.63 1 0.661 163K 318 0.0 0.0 L3 18/0 748.97 MB 0.7 1.6 0.5 1.0 1.6 0.5 0.0 2.9 238.7 238.1 6.68 6.37 5 1.336 1619K 4200 0.0 0.0 L4 130/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 229.6 229.6 0.97 0.93 1 0.973 226K 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 287/17 22.95 GB 0.0 5.3 1.2 4.1 9.0 5.0 1.6 2.4 166.2 282.7 32.72 31.25 78 0.420 5521K 22K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.3 1.2 4.1 9.0 5.0 1.6 2.4 166.2 282.7 32.72 31.25 78 0.420 5521K 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.3 1.2 4.1 5.3 1.2 0.0 0.0 247.9 246.9 21.93 21.28 20 1.097 5521K 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 355.6 10.79 9.97 58 0.186 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.5 total, 12.4 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: 9.03 GB write, 742.27 MB/s write, 5.31 GB read, 436.26 MB/s read, 32.7 seconds Interval compaction: 9.03 GB write, 747.14 MB/s write, 5.31 GB read, 439.12 MB/s read, 32.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 3, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 3, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 5, interval: 8 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1022262 Average: 2.3955 StdDev: 7.01 Min: 0 Median: 1.5803 Max: 1806 Percentiles: P50: 1.58 P75: 1.96 P99: 5.95 P99.9: 13.72 P99.99: 152.36 ------------------------------------------------------ [ 0, 1 ] 122760 12.009% 12.009% ## ( 1, 2 ] 669252 65.468% 77.476% ############# ( 2, 3 ] 148718 14.548% 92.024% ### ( 3, 4 ] 43718 4.277% 96.301% # ( 4, 6 ] 28349 2.773% 99.074% # ( 6, 10 ] 7402 0.724% 99.798% ( 10, 15 ] 1399 0.137% 99.935% ( 15, 22 ] 142 0.014% 99.949% ( 22, 34 ] 28 0.003% 99.952% ( 34, 51 ] 9 0.001% 99.953% ( 51, 76 ] 10 0.001% 99.954% ( 76, 110 ] 49 0.005% 99.958% ( 110, 170 ] 460 0.045% 100.003% ( 170, 250 ] 85 0.008% 100.012% ( 250, 380 ] 36 0.004% 100.015% ( 380, 580 ] 46 0.004% 100.020% ( 580, 870 ] 16 0.002% 100.021% ( 870, 1300 ] 12 0.001% 100.022% ( 1300, 1900 ] 1 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 145838 Average: 2.9118 StdDev: 8.71 Min: 0 Median: 1.7837 Max: 797 Percentiles: P50: 1.78 P75: 2.56 P99: 8.72 P99.9: 116.88 P99.99: 241.27 ------------------------------------------------------ [ 0, 1 ] 7153 4.905% 4.905% # ( 1, 2 ] 83918 57.542% 62.447% ############ ( 2, 3 ] 32543 22.314% 84.761% #### ( 3, 4 ] 10248 7.027% 91.788% # ( 4, 6 ] 8888 6.094% 97.883% # ( 6, 10 ] 2400 1.646% 99.528% ( 10, 15 ] 445 0.305% 99.833% ( 15, 22 ] 69 0.047% 99.881% ( 22, 34 ] 10 0.007% 99.888% ( 34, 51 ] 1 0.001% 99.888% ( 51, 76 ] 1 0.001% 99.889% ( 76, 110 ] 4 0.003% 99.892% ( 110, 170 ] 106 0.073% 99.964% ( 170, 250 ] 42 0.029% 99.993% ( 250, 380 ] 17 0.012% 100.005% ( 380, 580 ] 12 0.008% 100.013% ( 580, 870 ] 6 0.004% 100.017% ** Level 2 read latency histogram (micros): Count: 65581 Average: 3.0214 StdDev: 34.28 Min: 1 Median: 1.5161 Max: 5668 Percentiles: P50: 1.52 P75: 1.92 P99: 9.14 P99.9: 168.44 P99.99: 644.08 ------------------------------------------------------ [ 0, 1 ] 11602 17.691% 17.691% #### ( 1, 2 ] 41055 62.602% 80.293% ############# ( 2, 3 ] 7083 10.800% 91.093% ## ( 3, 4 ] 2379 3.628% 94.721% # ( 4, 6 ] 1986 3.028% 97.749% # ( 6, 10 ] 1044 1.592% 99.341% ( 10, 15 ] 169 0.258% 99.599% ( 15, 22 ] 24 0.037% 99.636% ( 22, 34 ] 1 0.002% 99.637% ( 34, 51 ] 22 0.034% 99.671% ( 51, 76 ] 10 0.015% 99.686% ( 76, 110 ] 44 0.067% 99.753% ( 110, 170 ] 99 0.151% 99.904% ( 170, 250 ] 35 0.053% 99.957% ( 250, 380 ] 18 0.027% 99.985% ( 380, 580 ] 3 0.005% 99.989% ( 580, 870 ] 2 0.003% 99.992% ( 1300, 1900 ] 1 0.002% 99.994% ( 1900, 2900 ] 1 0.002% 99.995% ( 2900, 4400 ] 2 0.003% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 322813 Average: 3.5011 StdDev: 45.65 Min: 1 Median: 1.7021 Max: 5751 Percentiles: P50: 1.70 P75: 2.34 P99: 9.37 P99.9: 161.30 P99.99: 496.99 ------------------------------------------------------ [ 0, 1 ] 17237 5.340% 5.340% # ( 1, 2 ] 205333 63.607% 68.947% ############# ( 2, 3 ] 58116 18.003% 86.950% #### ( 3, 4 ] 19693 6.100% 93.050% # ( 4, 6 ] 13595 4.211% 97.262% # ( 6, 10 ] 6654 2.061% 99.323% ( 10, 15 ] 951 0.295% 99.618% ( 15, 22 ] 99 0.031% 99.648% ( 22, 34 ] 13 0.004% 99.652% ( 34, 51 ] 250 0.077% 99.730% ( 51, 76 ] 190 0.059% 99.789% ( 76, 110 ] 83 0.026% 99.814% ( 110, 170 ] 323 0.100% 99.915% ( 170, 250 ] 147 0.046% 99.960% ( 250, 380 ] 78 0.024% 99.984% ( 380, 580 ] 32 0.010% 99.994% ( 580, 870 ] 10 0.003% 99.997% ( 870, 1300 ] 6 0.002% 99.999% ( 1300, 1900 ] 4 0.001% 100.000% ( 1900, 2900 ] 11 0.003% 100.004% ( 2900, 4400 ] 11 0.003% 100.007% ( 4400, 6600 ] 18 0.006% 100.013% ** Level 4 read latency histogram (micros): Count: 40 Average: 660.1000 StdDev: 1318.33 Min: 1 Median: 34.0000 Max: 5087 Percentiles: P50: 34.00 P75: 380.00 P99: 5087.00 P99.9: 5087.00 P99.99: 5087.00 ------------------------------------------------------ [ 0, 1 ] 9 22.500% 22.500% ##### ( 1, 2 ] 9 22.500% 45.000% ##### ( 15, 22 ] 1 2.500% 47.500% # ( 22, 34 ] 1 2.500% 50.000% # ( 34, 51 ] 2 5.000% 55.000% # ( 110, 170 ] 6 15.000% 70.000% ### ( 170, 250 ] 1 2.500% 72.500% # ( 250, 380 ] 1 2.500% 75.000% # ( 380, 580 ] 1 2.500% 77.500% # ( 580, 870 ] 2 5.000% 82.500% # ( 1300, 1900 ] 1 2.500% 85.000% # ( 1900, 2900 ] 2 5.000% 90.000% # ( 2900, 4400 ] 2 5.000% 95.000% # ( 4400, 6600 ] 2 5.000% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 527.6500 StdDev: 504.10 Min: 129 Median: 325.8333 Max: 2187 Percentiles: P50: 325.83 P75: 725.00 P99: 2187.00 P99.9: 2187.00 P99.99: 2187.00 ------------------------------------------------------ ( 110, 170 ] 7 17.500% 17.500% #### ( 170, 250 ] 6 15.000% 32.500% ### ( 250, 380 ] 12 30.000% 62.500% ###### ( 380, 580 ] 3 7.500% 70.000% ## ( 580, 870 ] 4 10.000% 80.000% ## ( 870, 1300 ] 5 12.500% 92.500% ### ( 1300, 1900 ] 1 2.500% 95.000% # ( 1900, 2900 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 12.5 total, 3.5 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 315.86 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:1.071 H:M:S, 8.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 278.79 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.685 H:M:S, 19.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 20000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 19378.7 MB (estimated) FileSize: 19378.7 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 4.275 micros/op 233904 ops/sec 20.149 seconds 4712999 operations; 226.6 MB/s Microseconds per write: Count: 4712999 Average: 4.2753 StdDev: 154.89 Min: 0 Median: 1.7625 Max: 195305 Percentiles: P50: 1.76 P75: 3.03 P99: 8.88 P99.9: 870.92 P99.99: 2428.99 ------------------------------------------------------ [ 0, 1 ] 646230 13.712% 13.712% ### ( 1, 2 ] 2242855 47.589% 61.300% ########## ( 2, 3 ] 624385 13.248% 74.548% ### ( 3, 4 ] 660984 14.025% 88.573% ### ( 4, 6 ] 449872 9.545% 98.119% ## ( 6, 10 ] 57785 1.226% 99.345% ( 10, 15 ] 15551 0.330% 99.675% ( 15, 22 ] 4618 0.098% 99.773% ( 22, 34 ] 1032 0.022% 99.794% ( 34, 51 ] 147 0.003% 99.798% ( 51, 76 ] 26 0.001% 99.798% ( 76, 110 ] 6 0.000% 99.798% ( 110, 170 ] 4446 0.094% 99.893% ( 170, 250 ] 269 0.006% 99.898% ( 250, 380 ] 60 0.001% 99.900% ( 380, 580 ] 6 0.000% 99.900% ( 580, 870 ] 6 0.000% 99.900% ( 870, 1300 ] 3723 0.079% 99.979% ( 1300, 1900 ] 3 0.000% 99.979% ( 1900, 2900 ] 990 0.021% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 170000, 250000 ] 3 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 : 185516 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 : 4712999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 4863814968 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 : 159 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 6637179 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 : 9968003390 rocksdb.compact.write.bytes COUNT : 9786795174 rocksdb.flush.write.bytes COUNT : 4815113000 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 : 14 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 : 76 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 : 4783268864 rocksdb.memtable.garbage.bytes.at.flush COUNT : 8248320 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 : 10009167646 rocksdb.non.last.level.read.count COUNT : 2419687 rocksdb.block.checksum.compute.count COUNT : 2419384 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.407989 P95 : 4.706795 P99 : 7.393619 P100 : 195303.000000 COUNT : 4712999 SUM : 17980290 rocksdb.compaction.times.micros P50 : 993571.428571 P95 : 1847500.000000 P99 : 3978000.000000 P100 : 4101128.000000 COUNT : 23 SUM : 24806330 rocksdb.compaction.times.cpu_micros P50 : 993571.428571 P95 : 1847500.000000 P99 : 3916729.000000 P100 : 3916729.000000 COUNT : 23 SUM : 24114777 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 : 553.684211 P95 : 1246.250000 P99 : 1480.000000 P100 : 1513.000000 COUNT : 70 SUM : 46158 rocksdb.compaction.outfile.sync.micros P50 : 648.684211 P95 : 1214.000000 P99 : 1546.000000 P100 : 1546.000000 COUNT : 84 SUM : 55659 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 : 86.461538 P95 : 271.666667 P99 : 308.000000 P100 : 308.000000 COUNT : 100 SUM : 10897 rocksdb.table.open.io.micros P50 : 819.652778 P95 : 14933.333333 P99 : 18573.000000 P100 : 18573.000000 COUNT : 159 SUM : 379041 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.657288 P95 : 7.037337 P99 : 11.698007 P100 : 4745.000000 COUNT : 2419402 SUM : 12166230 rocksdb.read.block.get.micros P50 : 402.500000 P95 : 3731.818182 P99 : 5893.000000 P100 : 5893.000000 COUNT : 318 SUM : 244534 rocksdb.write.raw.block.micros P50 : 0.512209 P95 : 0.973198 P99 : 2.860625 P100 : 6488.000000 COUNT : 3539492 SUM : 6561170 rocksdb.numfiles.in.singlecompaction P50 : 3.416667 P95 : 11.125000 P99 : 13.000000 P100 : 13.000000 COUNT : 31 SUM : 134 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.560935 P95 : 1162.099866 P99 : 2461.898990 P100 : 195091.000000 COUNT : 43772 SUM : 6641862 rocksdb.sst.read.micros P50 : 1.597655 P95 : 3.909127 P99 : 8.506956 P100 : 5751.000000 COUNT : 2420478 SUM : 7298034 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 : 4712999 SUM : 4863814968 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 : 192325.581395 P95 : 266250.000000 P99 : 357250.000000 P100 : 362099.000000 COUNT : 70 SUM : 12952897 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 : 95 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