[2024-11-20 13:41:43.779904] Starting SPDK v25.01-pre git sha1 bc5264bd5 / DPDK 24.03.0 initialization... [2024-11-20 13:41:43.780068] [ 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_pid2880095 ] Set seed to 1732106503776347 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-20 13:41:43.917118] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-20 13:41:44.020021] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-20 13:41:44.020080] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 2880095' to capture a snapshot of events at runtime. [2024-11-20 13:41:44.020093] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-20 13:41:44.020106] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-20 13:41:44.020116] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid2880095 for offline analysis/debug. [2024-11-20 13:41:44.021439] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Wed Nov 20 13:41:46 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/11/20-13:41:54 ... thread 0: (1000000,1000000) ops and (136581.4,136581.4) ops/second in (7.321640,7.321640) 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 7/4 565.69 MB 25.1 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 121.7 6.71 2.61 10 0.671 0 0 0.0 0.0 L1 2/0 176.89 MB 17.7 0.7 0.5 0.2 0.7 0.5 0.0 1.4 100.4 99.7 6.79 3.62 2 3.395 692K 4537 0.0 0.0 L2 5/0 337.76 MB 3.4 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 37/9 2.10 GB 1.6 2.7 1.9 0.8 2.6 1.8 0.0 1.4 101.5 97.6 27.13 15.12 11 2.467 2080K 5911 0.0 0.0 L4 165/29 11.80 GB 1.0 2.2 1.6 0.6 2.1 1.5 0.4 1.4 100.5 98.9 22.16 12.87 11 2.014 420K 0 0.0 0.0 L5 120/0 9.23 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 336/42 24.18 GB 0.0 5.5 3.9 1.6 6.2 4.6 0.7 7.8 90.2 100.9 62.80 34.22 34 1.847 3193K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.5 3.9 1.6 6.2 4.6 0.7 7.8 90.2 100.9 62.80 34.22 34 1.847 3193K 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 5.5 3.9 1.6 5.4 3.8 0.0 0.0 101.0 98.4 56.08 31.61 24 2.337 3193K 10K 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 121.7 6.71 2.61 10 0.671 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): 7.4 total, 7.3 interval Flush(GB): cumulative 0.798, interval 0.798 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.18 GB write, 857.70 MB/s write, 5.53 GB read, 766.98 MB/s read, 62.8 seconds Interval compaction: 6.18 GB write, 864.61 MB/s write, 5.53 GB read, 773.17 MB/s read, 62.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: 19, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 19, interval: 19 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 191880 Average: 23.5184 StdDev: 303.90 Min: 1 Median: 2.2337 Max: 47693 Percentiles: P50: 2.23 P75: 3.22 P99: 532.88 P99.9: 3821.84 P99.99: 8516.58 ------------------------------------------------------ [ 0, 1 ] 3176 1.655% 1.655% ( 1, 2 ] 79481 41.422% 43.077% ######## ( 2, 3 ] 56849 29.627% 72.705% ###### ( 3, 4 ] 19882 10.362% 83.066% ## ( 4, 6 ] 22444 11.697% 94.763% ## ( 6, 10 ] 5726 2.984% 97.748% # ( 10, 15 ] 1148 0.598% 98.346% ( 15, 22 ] 120 0.063% 98.408% ( 22, 34 ] 14 0.007% 98.416% ( 34, 51 ] 28 0.015% 98.430% ( 51, 76 ] 21 0.011% 98.441% ( 76, 110 ] 13 0.007% 98.448% ( 110, 170 ] 37 0.019% 98.467% ( 170, 250 ] 97 0.051% 98.518% ( 250, 380 ] 372 0.194% 98.712% ( 380, 580 ] 725 0.378% 99.090% ( 580, 870 ] 712 0.371% 99.461% ( 870, 1300 ] 341 0.178% 99.638% ( 1300, 1900 ] 201 0.105% 99.743% ( 1900, 2900 ] 162 0.084% 99.827% ( 2900, 4400 ] 228 0.119% 99.946% ( 4400, 6600 ] 61 0.032% 99.978% ( 6600, 9900 ] 41 0.021% 99.999% ( 9900, 14000 ] 13 0.007% 100.006% ( 14000, 22000 ] 9 0.005% 100.011% ( 22000, 33000 ] 2 0.001% 100.012% ( 33000, 50000 ] 1 0.001% 100.013% ** Level 1 read latency histogram (micros): Count: 52523 Average: 24.9717 StdDev: 398.64 Min: 1 Median: 2.3418 Max: 40439 Percentiles: P50: 2.34 P75: 3.34 P99: 473.62 P99.9: 4240.68 P99.99: 18996.93 ------------------------------------------------------ [ 0, 1 ] 474 0.902% 0.902% ( 1, 2 ] 19962 38.006% 38.909% ######## ( 2, 3 ] 17044 32.451% 71.359% ###### ( 3, 4 ] 5601 10.664% 82.023% ## ( 4, 6 ] 6560 12.490% 94.513% ## ( 6, 10 ] 1733 3.300% 97.812% # ( 10, 15 ] 325 0.619% 98.431% ( 15, 22 ] 34 0.065% 98.496% ( 22, 34 ] 6 0.011% 98.507% ( 34, 51 ] 7 0.013% 98.521% ( 51, 76 ] 2 0.004% 98.524% ( 76, 110 ] 9 0.017% 98.542% ( 110, 170 ] 10 0.019% 98.561% ( 170, 250 ] 45 0.086% 98.646% ( 250, 380 ] 87 0.166% 98.812% ( 380, 580 ] 211 0.402% 99.214% ( 580, 870 ] 167 0.318% 99.532% ( 870, 1300 ] 78 0.149% 99.680% ( 1300, 1900 ] 30 0.057% 99.737% ( 1900, 2900 ] 39 0.074% 99.812% ( 2900, 4400 ] 52 0.099% 99.911% ( 4400, 6600 ] 18 0.034% 99.945% ( 6600, 9900 ] 12 0.023% 99.968% ( 9900, 14000 ] 8 0.015% 99.983% ( 14000, 22000 ] 6 0.011% 99.994% ( 22000, 33000 ] 2 0.004% 99.998% ( 33000, 50000 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 422305 Average: 16.5327 StdDev: 271.48 Min: 1 Median: 2.3094 Max: 46029 Percentiles: P50: 2.31 P75: 3.32 P99: 13.13 P99.9: 1425.77 P99.99: 2553.36 ------------------------------------------------------ [ 0, 1 ] 3893 0.922% 0.922% ( 1, 2 ] 166664 39.465% 40.387% ######## ( 2, 3 ] 131210 31.070% 71.457% ###### ( 3, 4 ] 47028 11.136% 82.593% ## ( 4, 6 ] 54166 12.826% 95.419% ### ( 6, 10 ] 13105 3.103% 98.523% # ( 10, 15 ] 3219 0.762% 99.285% ( 15, 22 ] 532 0.126% 99.411% ( 22, 34 ] 72 0.017% 99.428% ( 34, 51 ] 106 0.025% 99.453% ( 51, 76 ] 105 0.025% 99.478% ( 76, 110 ] 19 0.004% 99.482% ( 110, 170 ] 30 0.007% 99.489% ( 170, 250 ] 90 0.021% 99.511% ( 250, 380 ] 356 0.084% 99.595% ( 380, 580 ] 582 0.138% 99.733% ( 580, 870 ] 421 0.100% 99.833% ( 870, 1300 ] 239 0.057% 99.889% ( 1300, 1900 ] 218 0.052% 99.941% ( 1900, 2900 ] 318 0.075% 100.016% ( 2900, 4400 ] 383 0.091% 100.107% ( 4400, 6600 ] 125 0.030% 100.136% ( 6600, 9900 ] 107 0.025% 100.162% ( 9900, 14000 ] 16 0.004% 100.166% ( 14000, 22000 ] 26 0.006% 100.172% ( 22000, 33000 ] 4 0.001% 100.173% ( 33000, 50000 ] 1 0.000% 100.173% ** Level 3 read latency histogram (micros): Count: 619559 Average: 20.4807 StdDev: 329.54 Min: 0 Median: 2.3250 Max: 52905 Percentiles: P50: 2.32 P75: 3.31 P99: 15.02 P99.9: 1904.76 P99.99: 3004.23 ------------------------------------------------------ [ 0, 1 ] 5544 0.895% 0.895% ( 1, 2 ] 239900 38.721% 39.616% ######## ( 2, 3 ] 197979 31.955% 71.571% ###### ( 3, 4 ] 69158 11.162% 82.733% ## ( 4, 6 ] 78384 12.652% 95.385% ### ( 6, 10 ] 18520 2.989% 98.374% # ( 10, 15 ] 3877 0.626% 99.000% ( 15, 22 ] 511 0.082% 99.082% ( 22, 34 ] 75 0.012% 99.094% ( 34, 51 ] 160 0.026% 99.120% ( 51, 76 ] 124 0.020% 99.140% ( 76, 110 ] 59 0.010% 99.150% ( 110, 170 ] 89 0.014% 99.164% ( 170, 250 ] 248 0.040% 99.204% ( 250, 380 ] 752 0.121% 99.325% ( 380, 580 ] 1416 0.229% 99.554% ( 580, 870 ] 1149 0.185% 99.739% ( 870, 1300 ] 620 0.100% 99.840% ( 1300, 1900 ] 372 0.060% 99.900% ( 1900, 2900 ] 513 0.083% 99.982% ( 2900, 4400 ] 677 0.109% 100.092% ( 4400, 6600 ] 202 0.033% 100.124% ( 6600, 9900 ] 167 0.027% 100.151% ( 9900, 14000 ] 28 0.005% 100.156% ( 14000, 22000 ] 43 0.007% 100.163% ( 22000, 33000 ] 17 0.003% 100.165% ( 33000, 50000 ] 5 0.001% 100.166% ( 50000, 75000 ] 1 0.000% 100.166% ** Level 4 read latency histogram (micros): Count: 452672 Average: 41.7517 StdDev: 473.52 Min: 1 Median: 2.3911 Max: 54037 Percentiles: P50: 2.39 P75: 3.50 P99: 750.46 P99.9: 3081.18 P99.99: 3647.54 ------------------------------------------------------ [ 0, 1 ] 3323 0.734% 0.734% ( 1, 2 ] 167318 36.962% 37.696% ####### ( 2, 3 ] 142421 31.462% 69.159% ###### ( 3, 4 ] 52775 11.659% 80.817% ## ( 4, 6 ] 58299 12.879% 93.696% ### ( 6, 10 ] 13773 3.043% 96.739% # ( 10, 15 ] 2756 0.609% 97.348% ( 15, 22 ] 351 0.078% 97.425% ( 22, 34 ] 52 0.011% 97.437% ( 34, 51 ] 100 0.022% 97.459% ( 51, 76 ] 89 0.020% 97.478% ( 76, 110 ] 38 0.008% 97.487% ( 110, 170 ] 150 0.033% 97.520% ( 170, 250 ] 531 0.117% 97.637% ( 250, 380 ] 1514 0.334% 97.972% ( 380, 580 ] 3003 0.663% 98.635% ( 580, 870 ] 2811 0.621% 99.256% ( 870, 1300 ] 1350 0.298% 99.554% ( 1300, 1900 ] 655 0.145% 99.699% ( 1900, 2900 ] 780 0.172% 99.871% ( 2900, 4400 ] 1080 0.239% 100.110% ( 4400, 6600 ] 314 0.069% 100.179% ( 6600, 9900 ] 156 0.034% 100.214% ( 9900, 14000 ] 38 0.008% 100.222% ( 14000, 22000 ] 50 0.011% 100.233% ( 22000, 33000 ] 23 0.005% 100.238% ( 33000, 50000 ] 15 0.003% 100.241% ( 50000, 75000 ] 1 0.000% 100.242% ** Level 5 read latency histogram (micros): Count: 8025 Average: 1225.7204 StdDev: 2277.04 Min: 93 Median: 639.2481 Max: 54040 Percentiles: P50: 639.25 P75: 1123.49 P99: 8525.00 P99.9: 32132.69 P99.99: 54040.00 ------------------------------------------------------ ( 76, 110 ] 12 0.150% 0.150% ( 110, 170 ] 109 1.358% 1.508% ( 170, 250 ] 367 4.573% 6.081% # ( 250, 380 ] 1064 13.259% 19.340% ### ( 380, 580 ] 2076 25.869% 45.209% ##### ( 580, 870 ] 1882 23.452% 68.660% ##### ( 870, 1300 ] 863 10.754% 79.414% ## ( 1300, 1900 ] 366 4.561% 83.975% # ( 1900, 2900 ] 404 5.034% 89.009% # ( 2900, 4400 ] 603 7.514% 96.523% ## ( 4400, 6600 ] 162 2.019% 98.542% ( 6600, 9900 ] 63 0.785% 99.327% ( 9900, 14000 ] 19 0.237% 99.564% ( 14000, 22000 ] 15 0.187% 99.751% ( 22000, 33000 ] 13 0.162% 99.913% ( 33000, 50000 ] 5 0.062% 99.975% ( 50000, 75000 ] 2 0.025% 100.000% ** DB Stats ** Uptime(secs): 7.4 total, 7.3 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 133.28 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.401 H:M:S, 32.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 134.34 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.401 H:M:S, 32.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/11/20-13:42:00 ... thread 0: (1000000,2000000) ops and (164354.4,149186.3) ops/second in (6.084414,13.406054) 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/12 1.59 GB 43.7 0.7 0.0 0.7 2.5 1.8 0.0 1.4 38.6 143.8 17.89 9.21 25 0.716 702K 4556 0.0 0.0 L1 2/2 176.89 MB 0.0 0.7 0.5 0.2 0.7 0.5 0.0 1.4 100.4 99.7 6.79 3.62 2 3.395 692K 4537 0.0 0.0 L2 3/2 175.93 MB 0.5 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 18/8 1018.81 MB 0.6 3.1 2.0 1.0 3.0 1.9 0.0 1.5 105.5 101.8 29.86 17.15 13 2.297 2483K 11K 0.0 0.0 L4 148/0 9.52 GB 1.0 8.9 2.8 6.1 7.8 1.7 0.4 2.7 126.6 110.0 72.34 43.53 32 2.261 1696K 0 0.0 0.0 L5 157/0 11.63 GB 0.1 0.0 0.0 0.0 0.0 0.0 2.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 342/24 24.08 GB 0.0 13.4 5.3 8.0 13.9 5.9 3.1 7.6 107.8 112.3 126.88 73.51 72 1.762 5573K 20K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.4 5.3 8.0 13.9 5.9 3.1 7.6 107.8 112.3 126.88 73.51 72 1.762 5573K 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 13.4 5.3 8.0 12.1 4.0 0.0 0.0 119.9 108.3 114.12 67.74 49 2.329 5573K 20K 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 147.8 12.76 5.77 23 0.555 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 13.5 total, 13.4 interval Flush(GB): cumulative 1.842, interval 1.842 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 13.91 GB write, 1057.84 MB/s write, 13.36 GB read, 1015.66 MB/s read, 126.9 seconds Interval compaction: 13.91 GB write, 1062.50 MB/s write, 13.36 GB read, 1020.13 MB/s read, 126.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: 35, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 35, interval: 35 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 400812 Average: 32.9752 StdDev: 327.09 Min: 1 Median: 2.1723 Max: 47693 Percentiles: P50: 2.17 P75: 3.17 P99: 761.16 P99.9: 3781.93 P99.99: 6260.29 ------------------------------------------------------ [ 0, 1 ] 8072 2.014% 2.014% ( 1, 2 ] 172799 43.112% 45.126% ######### ( 2, 3 ] 113404 28.294% 73.420% ###### ( 3, 4 ] 38193 9.529% 82.949% ## ( 4, 6 ] 41706 10.405% 93.354% ## ( 6, 10 ] 10885 2.716% 96.070% # ( 10, 15 ] 2164 0.540% 96.610% ( 15, 22 ] 229 0.057% 96.667% ( 22, 34 ] 19 0.005% 96.672% ( 34, 51 ] 42 0.010% 96.682% ( 51, 76 ] 45 0.011% 96.693% ( 76, 110 ] 28 0.007% 96.700% ( 110, 170 ] 325 0.081% 96.781% ( 170, 250 ] 1622 0.405% 97.186% ( 250, 380 ] 2359 0.589% 97.775% ( 380, 580 ] 3161 0.789% 98.563% ( 580, 870 ] 2806 0.700% 99.263% ( 870, 1300 ] 1322 0.330% 99.593% ( 1300, 1900 ] 453 0.113% 99.706% ( 1900, 2900 ] 437 0.109% 99.815% ( 2900, 4400 ] 582 0.145% 99.960% ( 4400, 6600 ] 143 0.036% 99.996% ( 6600, 9900 ] 63 0.016% 100.012% ( 9900, 14000 ] 24 0.006% 100.018% ( 14000, 22000 ] 22 0.005% 100.023% ( 22000, 33000 ] 7 0.002% 100.025% ( 33000, 50000 ] 4 0.001% 100.026% ** Level 1 read latency histogram (micros): Count: 116704 Average: 34.5727 StdDev: 418.67 Min: 1 Median: 2.3589 Max: 40439 Percentiles: P50: 2.36 P75: 3.39 P99: 765.01 P99.9: 4183.30 P99.99: 12631.42 ------------------------------------------------------ [ 0, 1 ] 916 0.785% 0.785% ( 1, 2 ] 43781 37.515% 38.299% ######## ( 2, 3 ] 38049 32.603% 70.902% ####### ( 3, 4 ] 12161 10.420% 81.323% ## ( 4, 6 ] 14033 12.024% 93.347% ## ( 6, 10 ] 3715 3.183% 96.531% # ( 10, 15 ] 701 0.601% 97.131% ( 15, 22 ] 83 0.071% 97.202% ( 22, 34 ] 7 0.006% 97.208% ( 34, 51 ] 17 0.015% 97.223% ( 51, 76 ] 16 0.014% 97.237% ( 76, 110 ] 17 0.015% 97.251% ( 110, 170 ] 58 0.050% 97.301% ( 170, 250 ] 227 0.195% 97.495% ( 250, 380 ] 455 0.390% 97.885% ( 380, 580 ] 811 0.695% 98.580% ( 580, 870 ] 768 0.658% 99.238% ( 870, 1300 ] 378 0.324% 99.562% ( 1300, 1900 ] 111 0.095% 99.657% ( 1900, 2900 ] 137 0.117% 99.775% ( 2900, 4400 ] 171 0.147% 99.921% ( 4400, 6600 ] 49 0.042% 99.963% ( 6600, 9900 ] 26 0.022% 99.985% ( 9900, 14000 ] 8 0.007% 99.992% ( 14000, 22000 ] 11 0.009% 100.002% ( 22000, 33000 ] 8 0.007% 100.009% ( 33000, 50000 ] 2 0.002% 100.010% ** Level 2 read latency histogram (micros): Count: 422305 Average: 16.5327 StdDev: 271.48 Min: 1 Median: 2.3094 Max: 46029 Percentiles: P50: 2.31 P75: 3.32 P99: 13.13 P99.9: 1425.77 P99.99: 2553.36 ------------------------------------------------------ [ 0, 1 ] 3893 0.922% 0.922% ( 1, 2 ] 166664 39.465% 40.387% ######## ( 2, 3 ] 131210 31.070% 71.457% ###### ( 3, 4 ] 47028 11.136% 82.593% ## ( 4, 6 ] 54166 12.826% 95.419% ### ( 6, 10 ] 13105 3.103% 98.523% # ( 10, 15 ] 3219 0.762% 99.285% ( 15, 22 ] 532 0.126% 99.411% ( 22, 34 ] 72 0.017% 99.428% ( 34, 51 ] 106 0.025% 99.453% ( 51, 76 ] 105 0.025% 99.478% ( 76, 110 ] 19 0.004% 99.482% ( 110, 170 ] 30 0.007% 99.489% ( 170, 250 ] 90 0.021% 99.511% ( 250, 380 ] 356 0.084% 99.595% ( 380, 580 ] 582 0.138% 99.733% ( 580, 870 ] 421 0.100% 99.833% ( 870, 1300 ] 239 0.057% 99.889% ( 1300, 1900 ] 218 0.052% 99.941% ( 1900, 2900 ] 318 0.075% 100.016% ( 2900, 4400 ] 383 0.091% 100.107% ( 4400, 6600 ] 125 0.030% 100.136% ( 6600, 9900 ] 107 0.025% 100.162% ( 9900, 14000 ] 16 0.004% 100.166% ( 14000, 22000 ] 26 0.006% 100.172% ( 22000, 33000 ] 4 0.001% 100.173% ( 33000, 50000 ] 1 0.000% 100.173% ** Level 3 read latency histogram (micros): Count: 993669 Average: 18.4803 StdDev: 296.84 Min: 0 Median: 2.3164 Max: 52905 Percentiles: P50: 2.32 P75: 3.29 P99: 42.17 P99.9: 1681.68 P99.99: 2917.74 ------------------------------------------------------ [ 0, 1 ] 8439 0.849% 0.849% ( 1, 2 ] 388443 39.092% 39.941% ######## ( 2, 3 ] 315941 31.795% 71.736% ###### ( 3, 4 ] 110291 11.099% 82.836% ## ( 4, 6 ] 123098 12.388% 95.224% ## ( 6, 10 ] 30312 3.051% 98.275% # ( 10, 15 ] 6159 0.620% 98.894% ( 15, 22 ] 799 0.080% 98.975% ( 22, 34 ] 122 0.012% 98.987% ( 34, 51 ] 269 0.027% 99.014% ( 51, 76 ] 209 0.021% 99.035% ( 76, 110 ] 75 0.008% 99.043% ( 110, 170 ] 166 0.017% 99.059% ( 170, 250 ] 738 0.074% 99.134% ( 250, 380 ] 1542 0.155% 99.289% ( 380, 580 ] 2386 0.240% 99.529% ( 580, 870 ] 2168 0.218% 99.747% ( 870, 1300 ] 1186 0.119% 99.867% ( 1300, 1900 ] 524 0.053% 99.919% ( 1900, 2900 ] 693 0.070% 99.989% ( 2900, 4400 ] 899 0.090% 100.080% ( 4400, 6600 ] 250 0.025% 100.105% ( 6600, 9900 ] 177 0.018% 100.122% ( 9900, 14000 ] 35 0.004% 100.126% ( 14000, 22000 ] 60 0.006% 100.132% ( 22000, 33000 ] 22 0.002% 100.134% ( 33000, 50000 ] 7 0.001% 100.135% ( 50000, 75000 ] 1 0.000% 100.135% ** Level 4 read latency histogram (micros): Count: 1591815 Average: 25.8799 StdDev: 344.53 Min: 1 Median: 2.4044 Max: 54037 Percentiles: P50: 2.40 P75: 3.51 P99: 420.88 P99.9: 1193.14 P99.99: 1566.91 ------------------------------------------------------ [ 0, 1 ] 11441 0.719% 0.719% ( 1, 2 ] 581986 36.561% 37.280% ####### ( 2, 3 ] 500714 31.456% 68.735% ###### ( 3, 4 ] 193984 12.186% 80.922% ## ( 4, 6 ] 214272 13.461% 94.383% ### ( 6, 10 ] 50767 3.189% 97.572% # ( 10, 15 ] 11501 0.723% 98.294% ( 15, 22 ] 1478 0.093% 98.387% ( 22, 34 ] 166 0.010% 98.398% ( 34, 51 ] 438 0.028% 98.425% ( 51, 76 ] 389 0.024% 98.450% ( 76, 110 ] 123 0.008% 98.457% ( 110, 170 ] 517 0.032% 98.490% ( 170, 250 ] 2375 0.149% 98.639% ( 250, 380 ] 4344 0.273% 98.912% ( 380, 580 ] 6859 0.431% 99.343% ( 580, 870 ] 6493 0.408% 99.751% ( 870, 1300 ] 3162 0.199% 99.949% ( 1300, 1900 ] 1454 0.091% 100.041% ( 1900, 2900 ] 1727 0.108% 100.149% ( 2900, 4400 ] 2018 0.127% 100.276% ( 4400, 6600 ] 566 0.036% 100.312% ( 6600, 9900 ] 248 0.016% 100.327% ( 9900, 14000 ] 75 0.005% 100.332% ( 14000, 22000 ] 94 0.006% 100.338% ( 22000, 33000 ] 52 0.003% 100.341% ( 33000, 50000 ] 24 0.002% 100.343% ( 50000, 75000 ] 1 0.000% 100.343% ** Level 5 read latency histogram (micros): Count: 17357 Average: 1012.3691 StdDev: 1894.44 Min: 93 Median: 565.6300 Max: 54040 Percentiles: P50: 565.63 P75: 917.19 P99: 6391.75 P99.9: 29321.50 P99.99: 53303.75 ------------------------------------------------------ ( 76, 110 ] 16 0.092% 0.092% ( 110, 170 ] 304 1.751% 1.844% ( 170, 250 ] 1628 9.380% 11.223% ## ( 250, 380 ] 2797 16.115% 27.338% ### ( 380, 580 ] 4238 24.417% 51.754% ##### ( 580, 870 ] 3835 22.095% 73.849% #### ( 870, 1300 ] 1820 10.486% 84.335% ## ( 1300, 1900 ] 615 3.543% 87.878% # ( 1900, 2900 ] 720 4.148% 92.026% # ( 2900, 4400 ] 985 5.675% 97.701% # ( 4400, 6600 ] 249 1.435% 99.136% ( 6600, 9900 ] 76 0.438% 99.574% ( 9900, 14000 ] 23 0.133% 99.706% ( 14000, 22000 ] 19 0.109% 99.816% ( 22000, 33000 ] 22 0.127% 99.942% ( 33000, 50000 ] 8 0.046% 99.988% ( 50000, 75000 ] 2 0.012% 100.000% ** DB Stats ** Uptime(secs): 13.5 total, 6.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 146.14 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:4.155 H:M:S, 30.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 161.76 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.754 H:M:S, 28.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 2024/11/20-13:42:04 ... thread 0: (1000000,3000000) ops and (266017.2,174772.1) ops/second in (3.759156,17.165210) 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/8 2.51 GB 175.1 2.0 0.0 2.0 4.8 2.8 0.0 1.7 76.1 179.4 27.28 17.55 45 0.606 2107K 11K 0.0 0.0 L1 2/2 176.89 MB 0.0 0.7 0.5 0.2 0.7 0.5 0.0 1.4 100.4 99.7 6.79 3.62 2 3.395 692K 4537 0.0 0.0 L2 1/0 48.69 MB 0.5 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 17/0 953.17 MB 1.0 3.6 2.2 1.5 3.5 2.0 0.0 1.6 113.1 109.4 32.91 19.86 15 2.194 3064K 22K 0.0 0.0 L4 151/0 9.70 GB 1.0 9.2 3.0 6.2 8.0 1.8 0.4 2.7 127.8 111.5 73.37 44.50 33 2.223 1920K 1544 0.0 0.0 L5 157/0 11.63 GB 0.1 0.0 0.0 0.0 0.0 0.0 2.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 342/10 24.98 GB 0.0 15.5 5.6 9.9 16.9 7.0 3.2 6.1 113.0 123.6 140.34 85.53 95 1.477 7784K 40K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.5 5.6 9.9 16.9 7.0 3.2 6.1 113.0 123.6 140.34 85.53 95 1.477 7784K 40K 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 15.5 5.6 9.9 14.2 4.3 0.0 0.0 127.4 116.6 124.50 77.09 57 2.184 7784K 40K 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 178.7 15.84 8.44 38 0.417 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): 17.2 total, 17.2 interval Flush(GB): cumulative 2.763, interval 2.763 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 16.94 GB write, 1006.98 MB/s write, 15.48 GB read, 920.36 MB/s read, 140.3 seconds Interval compaction: 16.94 GB write, 1010.45 MB/s write, 15.48 GB read, 923.53 MB/s read, 140.3 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: 35, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 35, interval: 35 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 701439 Average: 26.2324 StdDev: 252.32 Min: 0 Median: 1.8421 Max: 47693 Percentiles: P50: 1.84 P75: 2.79 P99: 517.35 P99.9: 2550.48 P99.99: 4129.48 ------------------------------------------------------ [ 0, 1 ] 54414 7.757% 7.757% ## ( 1, 2 ] 351861 50.163% 57.920% ########## ( 2, 3 ] 150712 21.486% 79.406% #### ( 3, 4 ] 47812 6.816% 86.223% # ( 4, 6 ] 47673 6.796% 93.019% # ( 6, 10 ] 12276 1.750% 94.769% ( 10, 15 ] 2377 0.339% 95.108% ( 15, 22 ] 268 0.038% 95.146% ( 22, 34 ] 31 0.004% 95.151% ( 34, 51 ] 45 0.006% 95.157% ( 51, 76 ] 47 0.007% 95.164% ( 76, 110 ] 243 0.035% 95.198% ( 110, 170 ] 5191 0.740% 95.938% ( 170, 250 ] 13431 1.915% 97.853% ( 250, 380 ] 5253 0.749% 98.602% ( 380, 580 ] 4065 0.580% 99.182% ( 580, 870 ] 2967 0.423% 99.605% ( 870, 1300 ] 1330 0.190% 99.794% ( 1300, 1900 ] 457 0.065% 99.859% ( 1900, 2900 ] 439 0.063% 99.922% ( 2900, 4400 ] 583 0.083% 100.005% ( 4400, 6600 ] 143 0.020% 100.026% ( 6600, 9900 ] 64 0.009% 100.035% ( 9900, 14000 ] 25 0.004% 100.038% ( 14000, 22000 ] 24 0.003% 100.042% ( 22000, 33000 ] 7 0.001% 100.043% ( 33000, 50000 ] 4 0.001% 100.043% ** Level 1 read latency histogram (micros): Count: 136492 Average: 34.7504 StdDev: 389.16 Min: 1 Median: 2.3395 Max: 40439 Percentiles: P50: 2.34 P75: 3.44 P99: 695.15 P99.9: 3983.40 P99.99: 9820.65 ------------------------------------------------------ [ 0, 1 ] 1367 1.002% 1.002% ( 1, 2 ] 52503 38.466% 39.468% ######## ( 2, 3 ] 42339 31.019% 70.487% ###### ( 3, 4 ] 13916 10.195% 80.682% ## ( 4, 6 ] 15137 11.090% 91.772% ## ( 6, 10 ] 4121 3.019% 94.792% # ( 10, 15 ] 792 0.580% 95.372% ( 15, 22 ] 112 0.082% 95.454% ( 22, 34 ] 20 0.015% 95.469% ( 34, 51 ] 19 0.014% 95.483% ( 51, 76 ] 16 0.012% 95.494% ( 76, 110 ] 39 0.029% 95.523% ( 110, 170 ] 721 0.528% 96.051% ( 170, 250 ] 1835 1.344% 97.395% ( 250, 380 ] 909 0.666% 98.061% ( 380, 580 ] 967 0.708% 98.770% ( 580, 870 ] 791 0.580% 99.349% ( 870, 1300 ] 379 0.278% 99.627% ( 1300, 1900 ] 112 0.082% 99.709% ( 1900, 2900 ] 137 0.100% 99.810% ( 2900, 4400 ] 171 0.125% 99.935% ( 4400, 6600 ] 49 0.036% 99.971% ( 6600, 9900 ] 27 0.020% 99.990% ( 9900, 14000 ] 8 0.006% 99.996% ( 14000, 22000 ] 11 0.008% 100.004% ( 22000, 33000 ] 8 0.006% 100.010% ( 33000, 50000 ] 2 0.001% 100.012% ** Level 2 read latency histogram (micros): Count: 422305 Average: 16.5327 StdDev: 271.48 Min: 1 Median: 2.3094 Max: 46029 Percentiles: P50: 2.31 P75: 3.32 P99: 13.13 P99.9: 1425.77 P99.99: 2553.36 ------------------------------------------------------ [ 0, 1 ] 3893 0.922% 0.922% ( 1, 2 ] 166664 39.465% 40.387% ######## ( 2, 3 ] 131210 31.070% 71.457% ###### ( 3, 4 ] 47028 11.136% 82.593% ## ( 4, 6 ] 54166 12.826% 95.419% ### ( 6, 10 ] 13105 3.103% 98.523% # ( 10, 15 ] 3219 0.762% 99.285% ( 15, 22 ] 532 0.126% 99.411% ( 22, 34 ] 72 0.017% 99.428% ( 34, 51 ] 106 0.025% 99.453% ( 51, 76 ] 105 0.025% 99.478% ( 76, 110 ] 19 0.004% 99.482% ( 110, 170 ] 30 0.007% 99.489% ( 170, 250 ] 90 0.021% 99.511% ( 250, 380 ] 356 0.084% 99.595% ( 380, 580 ] 582 0.138% 99.733% ( 580, 870 ] 421 0.100% 99.833% ( 870, 1300 ] 239 0.057% 99.889% ( 1300, 1900 ] 218 0.052% 99.941% ( 1900, 2900 ] 318 0.075% 100.016% ( 2900, 4400 ] 383 0.091% 100.107% ( 4400, 6600 ] 125 0.030% 100.136% ( 6600, 9900 ] 107 0.025% 100.162% ( 9900, 14000 ] 16 0.004% 100.166% ( 14000, 22000 ] 26 0.006% 100.172% ( 22000, 33000 ] 4 0.001% 100.173% ( 33000, 50000 ] 1 0.000% 100.173% ** Level 3 read latency histogram (micros): Count: 1083901 Average: 17.7574 StdDev: 284.87 Min: 0 Median: 2.2622 Max: 52905 Percentiles: P50: 2.26 P75: 3.19 P99: 194.08 P99.9: 1573.78 P99.99: 2896.55 ------------------------------------------------------ [ 0, 1 ] 11894 1.097% 1.097% ( 1, 2 ] 441461 40.729% 41.826% ######## ( 2, 3 ] 337843 31.169% 72.995% ###### ( 3, 4 ] 114513 10.565% 83.560% ## ( 4, 6 ] 126281 11.651% 95.211% ## ( 6, 10 ] 31651 2.920% 98.131% # ( 10, 15 ] 6294 0.581% 98.712% ( 15, 22 ] 814 0.075% 98.787% ( 22, 34 ] 128 0.012% 98.799% ( 34, 51 ] 269 0.025% 98.823% ( 51, 76 ] 209 0.019% 98.843% ( 76, 110 ] 102 0.009% 98.852% ( 110, 170 ] 882 0.081% 98.933% ( 170, 250 ] 2395 0.221% 99.154% ( 250, 380 ] 1952 0.180% 99.335% ( 380, 580 ] 2509 0.231% 99.566% ( 580, 870 ] 2192 0.202% 99.768% ( 870, 1300 ] 1189 0.110% 99.878% ( 1300, 1900 ] 524 0.048% 99.926% ( 1900, 2900 ] 693 0.064% 99.990% ( 2900, 4400 ] 900 0.083% 100.073% ( 4400, 6600 ] 250 0.023% 100.096% ( 6600, 9900 ] 177 0.016% 100.113% ( 9900, 14000 ] 35 0.003% 100.116% ( 14000, 22000 ] 61 0.006% 100.122% ( 22000, 33000 ] 22 0.002% 100.124% ( 33000, 50000 ] 7 0.001% 100.124% ( 50000, 75000 ] 1 0.000% 100.124% ** Level 4 read latency histogram (micros): Count: 1626422 Average: 28.9856 StdDev: 342.25 Min: 0 Median: 2.4293 Max: 54037 Percentiles: P50: 2.43 P75: 3.62 P99: 440.02 P99.9: 1189.19 P99.99: 1566.40 ------------------------------------------------------ [ 0, 1 ] 11513 0.708% 0.708% ( 1, 2 ] 585823 36.019% 36.727% ####### ( 2, 3 ] 502796 30.914% 67.641% ###### ( 3, 4 ] 194559 11.962% 79.604% ## ( 4, 6 ] 214733 13.203% 92.806% ### ( 6, 10 ] 50916 3.131% 95.937% # ( 10, 15 ] 11520 0.708% 96.645% ( 15, 22 ] 1481 0.091% 96.736% ( 22, 34 ] 167 0.010% 96.747% ( 34, 51 ] 438 0.027% 96.774% ( 51, 76 ] 390 0.024% 96.798% ( 76, 110 ] 396 0.024% 96.822% ( 110, 170 ] 7269 0.447% 97.269% ( 170, 250 ] 17683 1.087% 98.356% ( 250, 380 ] 8065 0.496% 98.852% ( 380, 580 ] 8027 0.494% 99.345% ( 580, 870 ] 6668 0.410% 99.755% ( 870, 1300 ] 3168 0.195% 99.950% ( 1300, 1900 ] 1458 0.090% 100.040% ( 1900, 2900 ] 1727 0.106% 100.146% ( 2900, 4400 ] 2019 0.124% 100.270% ( 4400, 6600 ] 566 0.035% 100.305% ( 6600, 9900 ] 248 0.015% 100.320% ( 9900, 14000 ] 76 0.005% 100.325% ( 14000, 22000 ] 95 0.006% 100.331% ( 22000, 33000 ] 52 0.003% 100.334% ( 33000, 50000 ] 24 0.001% 100.335% ( 50000, 75000 ] 1 0.000% 100.335% ** Level 5 read latency histogram (micros): Count: 36194 Average: 598.2856 StdDev: 1373.73 Min: 91 Median: 269.3137 Max: 54040 Percentiles: P50: 269.31 P75: 559.29 P99: 4734.93 P99.9: 19813.05 P99.99: 44433.77 ------------------------------------------------------ ( 76, 110 ] 195 0.539% 0.539% ( 110, 170 ] 4965 13.718% 14.257% ### ( 170, 250 ] 12149 33.566% 47.823% ####### ( 250, 380 ] 5304 14.654% 62.477% ### ( 380, 580 ] 5056 13.969% 76.446% ### ( 580, 870 ] 3976 10.985% 87.432% ## ( 870, 1300 ] 1825 5.042% 92.474% # ( 1300, 1900 ] 616 1.702% 94.176% ( 1900, 2900 ] 722 1.995% 96.171% ( 2900, 4400 ] 986 2.724% 98.895% # ( 4400, 6600 ] 250 0.691% 99.586% ( 6600, 9900 ] 76 0.210% 99.796% ( 9900, 14000 ] 24 0.066% 99.862% ( 14000, 22000 ] 19 0.052% 99.914% ( 22000, 33000 ] 22 0.061% 99.975% ( 33000, 50000 ] 8 0.022% 99.997% ( 50000, 75000 ] 2 0.006% 100.003% ** DB Stats ** Uptime(secs): 17.2 total, 3.8 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 171.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:4.155 H:M:S, 24.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 261.81 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 20000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 19378.7 MB (estimated) FileSize: 19378.7 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] readwhilewriting : 538.980 micros/op 7374 ops/sec 20.204 seconds 148996 operations; 7.1 MB/s (36999 of 36999 found) Microseconds per read: Count: 148996 Average: 538.9990 StdDev: 1503.38 Min: 2 Median: 271.9988 Max: 92591 Percentiles: P50: 272.00 P75: 483.43 P99: 4510.58 P99.9: 23630.04 P99.99: 48904.60 ------------------------------------------------------ ( 1, 2 ] 4 0.003% 0.003% ( 2, 3 ] 34 0.023% 0.026% ( 3, 4 ] 55 0.037% 0.062% ( 4, 6 ] 137 0.092% 0.154% ( 6, 10 ] 256 0.172% 0.326% ( 10, 15 ] 557 0.374% 0.700% ( 15, 22 ] 2095 1.406% 2.106% ( 22, 34 ] 2878 1.932% 4.038% ( 34, 51 ] 1628 1.093% 5.130% ( 51, 76 ] 264 0.177% 5.308% ( 76, 110 ] 63 0.042% 5.350% ( 110, 170 ] 7668 5.146% 10.496% # ( 170, 250 ] 53483 35.896% 46.392% ####### ( 250, 380 ] 31769 21.322% 67.714% #### ( 380, 580 ] 20992 14.089% 81.803% ### ( 580, 870 ] 13168 8.838% 90.641% ## ( 870, 1300 ] 6029 4.046% 94.687% # ( 1300, 1900 ] 2154 1.446% 96.133% ( 1900, 2900 ] 1836 1.232% 97.365% ( 2900, 4400 ] 2400 1.611% 98.976% ( 4400, 6600 ] 717 0.481% 99.457% ( 6600, 9900 ] 314 0.211% 99.668% ( 9900, 14000 ] 158 0.106% 99.774% ( 14000, 22000 ] 172 0.115% 99.889% ( 22000, 33000 ] 108 0.072% 99.962% ( 33000, 50000 ] 45 0.030% 99.992% ( 50000, 75000 ] 9 0.006% 99.998% ( 75000, 110000 ] 3 0.002% 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 : 2056075 rocksdb.bloom.filter.full.positive COUNT : 168320 rocksdb.bloom.filter.full.true.positive COUNT : 148207 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 : 789 rocksdb.memtable.miss COUNT : 148207 rocksdb.l0.hit COUNT : 14092 rocksdb.l1.hit COUNT : 1183 rocksdb.l2andup.hit COUNT : 132932 rocksdb.compaction.key.drop.new COUNT : 1365024 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 : 3812176 rocksdb.number.keys.read COUNT : 148996 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 3934165632 rocksdb.bytes.read COUNT : 148996000 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 : 574 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 4212736 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 : 17746065045 rocksdb.compact.write.bytes COUNT : 16340103269 rocksdb.flush.write.bytes COUNT : 3824519971 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 : 27 rocksdb.number.superversion_acquires COUNT : 754 rocksdb.number.superversion_releases COUNT : 727 rocksdb.number.superversion_cleanups COUNT : 186 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 : 83 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 : 3800485888 rocksdb.memtable.garbage.bytes.at.flush COUNT : 7749632 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 : 17932023765 rocksdb.non.last.level.read.count COUNT : 4306434 rocksdb.block.checksum.compute.count COUNT : 4470624 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 : 269.878298 P95 : 1429.363679 P99 : 4510.582985 P100 : 92590.000000 COUNT : 148996 SUM : 80164318 rocksdb.db.write.micros P50 : 1.602954 P95 : 5.081644 P99 : 7.057370 P100 : 662920.000000 COUNT : 3812176 SUM : 15080310 rocksdb.compaction.times.micros P50 : 2130769.230769 P95 : 3880000.000000 P99 : 4037239.000000 P100 : 4037239.000000 COUNT : 60 SUM : 127436542 rocksdb.compaction.times.cpu_micros P50 : 1336111.111111 P95 : 1861111.111111 P99 : 2272078.000000 P100 : 2272078.000000 COUNT : 60 SUM : 79961322 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 : 1120.833333 P95 : 8217.000000 P99 : 8916.000000 P100 : 8916.000000 COUNT : 51 SUM : 109730 rocksdb.compaction.outfile.sync.micros P50 : 2797.058824 P95 : 8643.461538 P99 : 17240.000000 P100 : 42268.000000 COUNT : 219 SUM : 764216 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 : 282.500000 P95 : 3050.000000 P99 : 4330.000000 P100 : 8759.000000 COUNT : 128 SUM : 82711 rocksdb.table.open.io.micros P50 : 5837.333333 P95 : 19083.076923 P99 : 21908.923077 P100 : 24032.000000 COUNT : 574 SUM : 3876861 rocksdb.db.multiget.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.read.block.compaction.micros P50 : 4.639984 P95 : 9.721758 P99 : 197.897025 P100 : 47698.000000 COUNT : 4299835 SUM : 72640102 rocksdb.read.block.get.micros P50 : 223.286100 P95 : 1226.651152 P99 : 4113.412225 P100 : 54047.000000 COUNT : 170661 SUM : 73284548 rocksdb.write.raw.block.micros P50 : 0.536932 P95 : 1.416863 P99 : 4.110592 P100 : 79372.000000 COUNT : 4898044 SUM : 22821810 rocksdb.numfiles.in.singlecompaction P50 : 3.266667 P95 : 5.637500 P99 : 6.880000 P100 : 7.000000 COUNT : 78 SUM : 287 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.578603 P95 : 1200.462963 P99 : 424333.333333 P100 : 662724.000000 COUNT : 530 SUM : 4212816 rocksdb.sst.read.micros P50 : 2.239095 P95 : 15.066748 P99 : 557.435835 P100 : 54040.000000 COUNT : 4307152 SUM : 131131229 rocksdb.num.subcompactions.scheduled P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.bytes.per.read P50 : 1000.000000 P95 : 1000.000000 P99 : 1000.000000 P100 : 1000.000000 COUNT : 148996 SUM : 148996000 rocksdb.bytes.per.write P50 : 1032.000000 P95 : 1032.000000 P99 : 1032.000000 P100 : 1032.000000 COUNT : 3812176 SUM : 3934165632 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 : 238000.000000 P95 : 911000.000000 P99 : 1002640.000000 P100 : 1002640.000000 COUNT : 51 SUM : 18424995 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 : 228 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