[2024-12-10 17:34:12.788294] Starting SPDK v25.01-pre git sha1 7219bd1a7 / DPDK 24.03.0 initialization... [2024-12-10 17:34:12.788431] [ 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_pid787540 ] Set seed to 1733848452784745 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-10 17:34:12.906070] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-10 17:34:13.013803] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-10 17:34:13.013847] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 787540' to capture a snapshot of events at runtime. [2024-12-10 17:34:13.013857] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-10 17:34:13.013867] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-10 17:34:13.013875] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid787540 for offline analysis/debug. [2024-12-10 17:34:13.015259] reactor.c: 995:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Tue Dec 10 17:34:18 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/10-17:34:21 ... thread 0: (1000000,1000000) ops and (336534.7,336534.7) ops/second in (2.971462,2.971462) 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/5 503.01 MB 18.8 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 349.7 2.52 2.27 12 0.210 0 0 0.0 0.0 L1 2/0 240.24 MB 24.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 256.4 255.3 0.98 0.96 1 0.981 255K 1043 0.0 0.0 L2 1/0 49.19 MB 0.5 0.3 0.1 0.2 0.3 0.1 0.0 2.3 242.2 241.4 1.27 1.22 3 0.424 312K 951 0.0 0.0 L3 17/0 876.48 MB 0.9 0.1 0.1 0.0 0.1 0.1 0.0 1.0 218.3 218.3 0.55 0.50 1 0.552 122K 0 0.0 0.0 L4 116/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 108/0 8.86 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 251/5 20.08 GB 0.0 0.7 0.5 0.2 1.5 1.4 0.1 1.8 127.8 292.8 5.32 4.94 17 0.313 690K 1994 0.0 0.0 Int 0/0 0.00 KB 0.0 0.7 0.5 0.2 1.5 1.4 0.1 1.8 127.8 292.8 5.32 4.94 17 0.313 690K 1994 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.7 0.5 0.2 0.7 0.5 0.0 0.0 242.4 241.7 2.80 2.68 5 0.561 690K 1994 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.7 2.52 2.27 12 0.210 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.52 GB write, 506.86 MB/s write, 0.66 GB read, 221.15 MB/s read, 5.3 seconds Interval compaction: 1.52 GB write, 523.93 MB/s write, 0.66 GB read, 228.60 MB/s read, 5.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: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 139749 Average: 2.0435 StdDev: 12.87 Min: 0 Median: 1.3706 Max: 3309 Percentiles: P50: 1.37 P75: 1.78 P99: 5.43 P99.9: 9.80 P99.99: 150.25 ------------------------------------------------------ [ 0, 1 ] 38168 27.312% 27.312% ##### ( 1, 2 ] 85553 61.219% 88.531% ############ ( 2, 3 ] 9411 6.734% 95.265% # ( 3, 4 ] 3536 2.530% 97.795% # ( 4, 6 ] 2350 1.682% 99.477% ( 6, 10 ] 624 0.447% 99.923% ( 10, 15 ] 65 0.047% 99.970% ( 15, 22 ] 18 0.013% 99.983% ( 22, 34 ] 4 0.003% 99.986% ( 34, 51 ] 2 0.001% 99.987% ( 51, 76 ] 1 0.001% 99.988% ( 110, 170 ] 6 0.004% 99.992% ( 170, 250 ] 4 0.003% 99.995% ( 250, 380 ] 5 0.004% 99.999% ( 380, 580 ] 1 0.001% 99.999% ( 580, 870 ] 1 0.001% 100.000% ( 870, 1300 ] 4 0.003% 100.003% ( 1300, 1900 ] 2 0.001% 100.004% ( 2900, 4400 ] 1 0.001% 100.005% ** Level 1 read latency histogram (micros): Count: 2581 Average: 3.8047 StdDev: 38.00 Min: 1 Median: 1.7015 Max: 1638 Percentiles: P50: 1.70 P75: 2.43 P99: 9.04 P99.9: 463.80 P99.99: 1638.00 ------------------------------------------------------ [ 0, 1 ] 232 8.989% 8.989% ## ( 1, 2 ] 1509 58.466% 67.454% ############ ( 2, 3 ] 452 17.513% 84.967% #### ( 3, 4 ] 215 8.330% 93.297% ## ( 4, 6 ] 116 4.494% 97.792% # ( 6, 10 ] 41 1.589% 99.380% ( 10, 15 ] 8 0.310% 99.690% ( 15, 22 ] 4 0.155% 99.845% ( 250, 380 ] 1 0.039% 99.884% ( 380, 580 ] 1 0.039% 99.923% ( 870, 1300 ] 1 0.039% 99.961% ( 1300, 1900 ] 1 0.039% 100.000% ** Level 2 read latency histogram (micros): Count: 74265 Average: 2.2802 StdDev: 12.33 Min: 0 Median: 1.4569 Max: 2169 Percentiles: P50: 1.46 P75: 1.86 P99: 6.02 P99.9: 26.41 P99.99: 185.73 ------------------------------------------------------ [ 0, 1 ] 15995 21.538% 21.538% #### ( 1, 2 ] 46259 62.289% 83.827% ############ ( 2, 3 ] 6802 9.159% 92.986% ## ( 3, 4 ] 2515 3.387% 96.372% # ( 4, 6 ] 1949 2.624% 98.997% # ( 6, 10 ] 578 0.778% 99.775% ( 10, 15 ] 74 0.100% 99.875% ( 15, 22 ] 18 0.024% 99.899% ( 22, 34 ] 2 0.003% 99.902% ( 34, 51 ] 4 0.005% 99.907% ( 51, 76 ] 48 0.065% 99.972% ( 76, 110 ] 9 0.012% 99.984% ( 110, 170 ] 3 0.004% 99.988% ( 170, 250 ] 8 0.011% 99.999% ( 250, 380 ] 3 0.004% 100.003% ( 380, 580 ] 1 0.001% 100.004% ( 580, 870 ] 1 0.001% 100.005% ( 870, 1300 ] 3 0.004% 100.009% ( 1300, 1900 ] 1 0.001% 100.011% ( 1900, 2900 ] 1 0.001% 100.012% ** Level 3 read latency histogram (micros): Count: 85 Average: 1489.9765 StdDev: 2103.50 Min: 1 Median: 282.5000 Max: 9508 Percentiles: P50: 282.50 P75: 2250.00 P99: 8965.00 P99.9: 9508.00 P99.99: 9508.00 ------------------------------------------------------ [ 0, 1 ] 9 10.588% 10.588% ## ( 1, 2 ] 15 17.647% 28.235% #### ( 2, 3 ] 1 1.176% 29.412% ( 6, 10 ] 5 5.882% 35.294% # ( 10, 15 ] 2 2.353% 37.647% ( 15, 22 ] 4 4.706% 42.353% # ( 51, 76 ] 1 1.176% 43.529% ( 76, 110 ] 1 1.176% 44.706% ( 170, 250 ] 4 4.706% 49.412% # ( 250, 380 ] 2 2.353% 51.765% ( 380, 580 ] 2 2.353% 54.118% ( 580, 870 ] 2 2.353% 56.471% ( 870, 1300 ] 5 5.882% 62.353% # ( 1300, 1900 ] 9 10.588% 72.941% ## ( 1900, 2900 ] 5 5.882% 78.824% # ( 2900, 4400 ] 7 8.235% 87.059% ## ( 4400, 6600 ] 8 9.412% 96.471% ## ( 6600, 9900 ] 3 3.529% 100.000% # ** Level 4 read latency histogram (micros): Count: 30 Average: 3050.0667 StdDev: 1976.52 Min: 148 Median: 2900.0000 Max: 7135 Percentiles: P50: 2900.00 P75: 4583.33 P99: 7135.00 P99.9: 7135.00 P99.99: 7135.00 ------------------------------------------------------ ( 110, 170 ] 2 6.667% 6.667% # ( 250, 380 ] 1 3.333% 10.000% # ( 380, 580 ] 1 3.333% 13.333% # ( 580, 870 ] 1 3.333% 16.667% # ( 870, 1300 ] 3 10.000% 26.667% ## ( 1300, 1900 ] 2 6.667% 33.333% # ( 1900, 2900 ] 5 16.667% 50.000% ### ( 2900, 4400 ] 7 23.333% 73.333% ##### ( 4400, 6600 ] 6 20.000% 93.333% #### ( 6600, 9900 ] 2 6.667% 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.15 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.371 H:M:S, 12.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 330.85 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.371 H:M:S, 12.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/10-17:34:24 ... thread 0: (1000000,2000000) ops and (351166.5,343694.9) ops/second in (2.847652,5.819114) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/8 1.41 GB 87.5 0.9 0.0 0.9 2.6 1.8 0.0 1.5 102.0 312.6 8.63 8.02 29 0.298 894K 5195 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 256.4 255.3 0.98 0.96 1 0.981 255K 1043 0.0 0.0 L2 1/1 49.19 MB 0.0 0.3 0.1 0.2 0.3 0.1 0.2 2.3 242.2 241.4 1.27 1.22 3 0.424 312K 951 0.0 0.0 L3 18/9 1.09 GB 0.4 0.5 0.4 0.1 0.5 0.4 0.0 1.4 218.7 218.0 2.31 2.16 3 0.770 513K 1554 0.0 0.0 L4 116/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 108/0 8.86 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 254/18 21.00 GB 0.0 1.9 0.7 1.2 3.7 2.5 0.4 2.1 147.4 284.9 13.20 12.35 36 0.367 1975K 8743 0.0 0.0 Int 0/0 0.00 KB 0.0 1.9 0.7 1.2 3.7 2.5 0.4 2.1 147.4 284.9 13.20 12.35 36 0.367 1975K 8743 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 1.9 0.7 1.2 1.9 0.7 0.0 0.0 242.9 241.8 8.01 7.71 10 0.801 1975K 8743 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.4 5.19 4.65 26 0.200 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): 5.9 total, 5.8 interval Flush(GB): cumulative 1.781, interval 1.781 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.67 GB write, 634.94 MB/s write, 1.90 GB read, 328.45 MB/s read, 13.2 seconds Interval compaction: 3.67 GB write, 645.87 MB/s write, 1.90 GB read, 334.10 MB/s read, 13.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: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 375192 Average: 2.3605 StdDev: 15.54 Min: 0 Median: 1.5510 Max: 4248 Percentiles: P50: 1.55 P75: 1.95 P99: 5.90 P99.9: 11.62 P99.99: 18.88 ------------------------------------------------------ [ 0, 1 ] 59058 15.741% 15.741% ### ( 1, 2 ] 233267 62.173% 77.913% ############ ( 2, 3 ] 50771 13.532% 91.445% ### ( 3, 4 ] 15595 4.157% 95.602% # ( 4, 6 ] 13442 3.583% 99.185% # ( 6, 10 ] 2538 0.676% 99.861% ( 10, 15 ] 455 0.121% 99.982% ( 15, 22 ] 55 0.015% 99.997% ( 22, 34 ] 11 0.003% 100.000% ( 34, 51 ] 3 0.001% 100.001% ( 51, 76 ] 2 0.001% 100.001% ( 110, 170 ] 7 0.002% 100.003% ( 170, 250 ] 16 0.004% 100.007% ( 250, 380 ] 7 0.002% 100.009% ( 380, 580 ] 2 0.001% 100.010% ( 580, 870 ] 6 0.002% 100.011% ( 870, 1300 ] 9 0.002% 100.014% ( 1300, 1900 ] 5 0.001% 100.015% ( 1900, 2900 ] 2 0.001% 100.016% ( 2900, 4400 ] 4 0.001% 100.017% ** Level 1 read latency histogram (micros): Count: 63582 Average: 2.9495 StdDev: 13.14 Min: 1 Median: 1.7753 Max: 1638 Percentiles: P50: 1.78 P75: 2.52 P99: 8.39 P99.9: 61.45 P99.99: 626.53 ------------------------------------------------------ [ 0, 1 ] 2275 3.578% 3.578% # ( 1, 2 ] 38069 59.874% 63.452% ############ ( 2, 3 ] 14081 22.146% 85.598% #### ( 3, 4 ] 3883 6.107% 91.705% # ( 4, 6 ] 4076 6.411% 98.116% # ( 6, 10 ] 940 1.478% 99.594% ( 10, 15 ] 168 0.264% 99.858% ( 15, 22 ] 24 0.038% 99.896% ( 22, 34 ] 2 0.003% 99.899% ( 51, 76 ] 1 0.002% 99.901% ( 76, 110 ] 3 0.005% 99.906% ( 110, 170 ] 22 0.035% 99.940% ( 170, 250 ] 12 0.019% 99.959% ( 250, 380 ] 10 0.016% 99.975% ( 380, 580 ] 9 0.014% 99.989% ( 580, 870 ] 4 0.006% 99.995% ( 870, 1300 ] 2 0.003% 99.998% ( 1300, 1900 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 77209 Average: 2.3741 StdDev: 14.06 Min: 0 Median: 1.4703 Max: 2169 Percentiles: P50: 1.47 P75: 1.87 P99: 6.15 P99.9: 55.06 P99.99: 259.07 ------------------------------------------------------ [ 0, 1 ] 16082 20.829% 20.829% #### ( 1, 2 ] 47885 62.020% 82.849% ############ ( 2, 3 ] 7652 9.911% 92.760% ## ( 3, 4 ] 2687 3.480% 96.240% # ( 4, 6 ] 2108 2.730% 98.970% # ( 6, 10 ] 608 0.787% 99.758% ( 10, 15 ] 77 0.100% 99.858% ( 15, 22 ] 19 0.025% 99.882% ( 22, 34 ] 2 0.003% 99.885% ( 34, 51 ] 4 0.005% 99.890% ( 51, 76 ] 48 0.062% 99.952% ( 76, 110 ] 9 0.012% 99.964% ( 110, 170 ] 8 0.010% 99.974% ( 170, 250 ] 12 0.016% 99.990% ( 250, 380 ] 4 0.005% 99.995% ( 380, 580 ] 3 0.004% 99.999% ( 580, 870 ] 3 0.004% 100.003% ( 870, 1300 ] 5 0.006% 100.009% ( 1300, 1900 ] 1 0.001% 100.010% ( 1900, 2900 ] 1 0.001% 100.012% ** Level 3 read latency histogram (micros): Count: 190766 Average: 3.8725 StdDev: 57.24 Min: 0 Median: 1.6971 Max: 9508 Percentiles: P50: 1.70 P75: 2.33 P99: 8.83 P99.9: 234.68 P99.99: 839.23 ------------------------------------------------------ [ 0, 1 ] 12058 6.321% 6.321% # ( 1, 2 ] 119527 62.656% 68.977% ############# ( 2, 3 ] 34980 18.337% 87.314% #### ( 3, 4 ] 10284 5.391% 92.705% # ( 4, 6 ] 9441 4.949% 97.654% # ( 6, 10 ] 3634 1.905% 99.559% ( 10, 15 ] 242 0.127% 99.685% ( 15, 22 ] 39 0.020% 99.706% ( 22, 34 ] 2 0.001% 99.707% ( 34, 51 ] 4 0.002% 99.709% ( 51, 76 ] 2 0.001% 99.710% ( 76, 110 ] 118 0.062% 99.772% ( 110, 170 ] 166 0.087% 99.859% ( 170, 250 ] 98 0.051% 99.910% ( 250, 380 ] 74 0.039% 99.949% ( 380, 580 ] 53 0.028% 99.977% ( 580, 870 ] 29 0.015% 99.992% ( 870, 1300 ] 9 0.005% 99.997% ( 1300, 1900 ] 14 0.007% 100.004% ( 1900, 2900 ] 6 0.003% 100.007% ( 2900, 4400 ] 7 0.004% 100.011% ( 4400, 6600 ] 8 0.004% 100.015% ( 6600, 9900 ] 3 0.002% 100.017% ** Level 4 read latency histogram (micros): Count: 30 Average: 3050.0667 StdDev: 1976.52 Min: 148 Median: 2900.0000 Max: 7135 Percentiles: P50: 2900.00 P75: 4583.33 P99: 7135.00 P99.9: 7135.00 P99.99: 7135.00 ------------------------------------------------------ ( 110, 170 ] 2 6.667% 6.667% # ( 250, 380 ] 1 3.333% 10.000% # ( 380, 580 ] 1 3.333% 13.333% # ( 580, 870 ] 1 3.333% 16.667% # ( 870, 1300 ] 3 10.000% 26.667% ## ( 1300, 1900 ] 2 6.667% 33.333% # ( 1900, 2900 ] 5 16.667% 50.000% ### ( 2900, 4400 ] 7 23.333% 73.333% ##### ( 4400, 6600 ] 6 20.000% 93.333% #### ( 6600, 9900 ] 2 6.667% 100.000% # ** DB Stats ** Uptime(secs): 5.9 total, 2.8 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 332.40 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.592 H:M:S, 10.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 345.62 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.221 H:M:S, 7.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/10-17:34:27 ... thread 0: (1000000,3000000) ops and (331192.1,339423.7) ops/second in (3.019396,8.838510) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/8 2.32 GB 181.4 1.7 0.0 1.7 4.4 2.7 0.0 1.6 119.7 307.1 14.71 13.73 45 0.327 1788K 10K 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 256.4 255.3 0.98 0.96 1 0.981 255K 1043 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.1 0.2 0.3 0.1 0.2 2.3 242.2 241.4 1.27 1.22 3 0.424 312K 951 0.0 0.0 L3 20/0 977.65 MB 1.0 1.3 0.4 0.9 1.3 0.4 0.0 3.2 232.1 229.3 5.65 5.23 4 1.411 1330K 16K 0.0 0.0 L4 122/0 9.76 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 206.3 206.3 0.83 0.75 1 0.835 174K 0 0.0 0.0 L5 108/0 8.86 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 265/8 21.90 GB 0.0 3.7 0.9 2.8 6.4 3.6 0.4 2.4 162.2 279.0 23.44 21.89 54 0.434 3861K 28K 0.0 0.0 Int 0/0 0.00 KB 0.0 3.7 0.9 2.8 6.4 3.6 0.4 2.4 162.2 279.0 23.44 21.89 54 0.434 3861K 28K 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 3.7 0.9 2.8 3.7 0.9 0.0 0.0 243.9 242.1 15.59 14.88 15 1.039 3861K 28K 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 352.3 7.86 7.01 39 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 8.9 total, 8.8 interval Flush(GB): cumulative 2.702, interval 2.702 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.39 GB write, 731.63 MB/s write, 3.71 GB read, 425.31 MB/s read, 23.4 seconds Interval compaction: 6.39 GB write, 739.92 MB/s write, 3.71 GB read, 430.12 MB/s read, 23.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 12, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 12, interval: 12 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 642203 Average: 2.2850 StdDev: 13.37 Min: 0 Median: 1.5311 Max: 4248 Percentiles: P50: 1.53 P75: 1.92 P99: 5.76 P99.9: 10.30 P99.99: 18.03 ------------------------------------------------------ [ 0, 1 ] 102611 15.978% 15.978% ### ( 1, 2 ] 411363 64.055% 80.033% ############# ( 2, 3 ] 81868 12.748% 92.781% ### ( 3, 4 ] 23386 3.642% 96.422% # ( 4, 6 ] 18845 2.934% 99.357% # ( 6, 10 ] 3454 0.538% 99.895% ( 10, 15 ] 576 0.090% 99.984% ( 15, 22 ] 85 0.013% 99.998% ( 22, 34 ] 12 0.002% 100.000% ( 34, 51 ] 5 0.001% 100.000% ( 51, 76 ] 6 0.001% 100.001% ( 110, 170 ] 9 0.001% 100.003% ( 170, 250 ] 25 0.004% 100.007% ( 250, 380 ] 10 0.002% 100.008% ( 380, 580 ] 9 0.001% 100.009% ( 580, 870 ] 9 0.001% 100.011% ( 870, 1300 ] 14 0.002% 100.013% ( 1300, 1900 ] 7 0.001% 100.014% ( 1900, 2900 ] 3 0.000% 100.015% ( 2900, 4400 ] 4 0.001% 100.015% ** Level 1 read latency histogram (micros): Count: 63582 Average: 2.9495 StdDev: 13.14 Min: 1 Median: 1.7753 Max: 1638 Percentiles: P50: 1.78 P75: 2.52 P99: 8.39 P99.9: 61.45 P99.99: 626.53 ------------------------------------------------------ [ 0, 1 ] 2275 3.578% 3.578% # ( 1, 2 ] 38069 59.874% 63.452% ############ ( 2, 3 ] 14081 22.146% 85.598% #### ( 3, 4 ] 3883 6.107% 91.705% # ( 4, 6 ] 4076 6.411% 98.116% # ( 6, 10 ] 940 1.478% 99.594% ( 10, 15 ] 168 0.264% 99.858% ( 15, 22 ] 24 0.038% 99.896% ( 22, 34 ] 2 0.003% 99.899% ( 51, 76 ] 1 0.002% 99.901% ( 76, 110 ] 3 0.005% 99.906% ( 110, 170 ] 22 0.035% 99.940% ( 170, 250 ] 12 0.019% 99.959% ( 250, 380 ] 10 0.016% 99.975% ( 380, 580 ] 9 0.014% 99.989% ( 580, 870 ] 4 0.006% 99.995% ( 870, 1300 ] 2 0.003% 99.998% ( 1300, 1900 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 86756 Average: 2.3736 StdDev: 13.31 Min: 0 Median: 1.4837 Max: 2169 Percentiles: P50: 1.48 P75: 1.88 P99: 6.55 P99.9: 54.25 P99.99: 245.50 ------------------------------------------------------ [ 0, 1 ] 17108 19.720% 19.720% #### ( 1, 2 ] 54305 62.595% 82.315% ############# ( 2, 3 ] 9104 10.494% 92.809% ## ( 3, 4 ] 2920 3.366% 96.174% # ( 4, 6 ] 2345 2.703% 98.877% # ( 6, 10 ] 768 0.885% 99.763% ( 10, 15 ] 88 0.101% 99.864% ( 15, 22 ] 19 0.022% 99.886% ( 22, 34 ] 2 0.002% 99.888% ( 34, 51 ] 4 0.005% 99.893% ( 51, 76 ] 48 0.055% 99.948% ( 76, 110 ] 14 0.016% 99.964% ( 110, 170 ] 11 0.013% 99.977% ( 170, 250 ] 12 0.014% 99.991% ( 250, 380 ] 4 0.005% 99.995% ( 380, 580 ] 3 0.003% 99.999% ( 580, 870 ] 3 0.003% 100.002% ( 870, 1300 ] 5 0.006% 100.008% ( 1300, 1900 ] 1 0.001% 100.009% ( 1900, 2900 ] 1 0.001% 100.010% ** Level 3 read latency histogram (micros): Count: 272495 Average: 3.6910 StdDev: 49.15 Min: 0 Median: 1.6867 Max: 9508 Percentiles: P50: 1.69 P75: 2.28 P99: 8.82 P99.9: 244.40 P99.99: 868.36 ------------------------------------------------------ [ 0, 1 ] 17951 6.588% 6.588% # ( 1, 2 ] 172275 63.221% 69.809% ############# ( 2, 3 ] 50477 18.524% 88.333% #### ( 3, 4 ] 13208 4.847% 93.180% # ( 4, 6 ] 12277 4.505% 97.685% # ( 6, 10 ] 5078 1.864% 99.549% ( 10, 15 ] 365 0.134% 99.683% ( 15, 22 ] 53 0.019% 99.702% ( 22, 34 ] 4 0.001% 99.704% ( 34, 51 ] 5 0.002% 99.706% ( 51, 76 ] 3 0.001% 99.707% ( 76, 110 ] 165 0.061% 99.767% ( 110, 170 ] 222 0.081% 99.849% ( 170, 250 ] 150 0.055% 99.904% ( 250, 380 ] 114 0.042% 99.946% ( 380, 580 ] 77 0.028% 99.974% ( 580, 870 ] 44 0.016% 99.990% ( 870, 1300 ] 19 0.007% 99.997% ( 1300, 1900 ] 15 0.006% 100.003% ( 1900, 2900 ] 6 0.002% 100.005% ( 2900, 4400 ] 7 0.003% 100.007% ( 4400, 6600 ] 8 0.003% 100.010% ( 6600, 9900 ] 3 0.001% 100.011% ** Level 4 read latency histogram (micros): Count: 60 Average: 1545.8833 StdDev: 2053.98 Min: 1 Median: 170.0000 Max: 7135 Percentiles: P50: 170.00 P75: 2900.00 P99: 7135.00 P99.9: 7135.00 P99.99: 7135.00 ------------------------------------------------------ [ 0, 1 ] 8 13.333% 13.333% ### ( 1, 2 ] 9 15.000% 28.333% ### ( 3, 4 ] 1 1.667% 30.000% ( 6, 10 ] 1 1.667% 31.667% ( 10, 15 ] 1 1.667% 33.333% ( 15, 22 ] 1 1.667% 35.000% ( 22, 34 ] 1 1.667% 36.667% ( 76, 110 ] 6 10.000% 46.667% ## ( 110, 170 ] 2 3.333% 50.000% # ( 250, 380 ] 3 5.000% 55.000% # ( 380, 580 ] 1 1.667% 56.667% ( 580, 870 ] 1 1.667% 58.333% ( 870, 1300 ] 3 5.000% 63.333% # ( 1300, 1900 ] 2 3.333% 66.667% # ( 1900, 2900 ] 5 8.333% 75.000% ## ( 2900, 4400 ] 7 11.667% 86.667% ## ( 4400, 6600 ] 6 10.000% 96.667% ## ( 6600, 9900 ] 2 3.333% 100.000% # ** DB Stats ** Uptime(secs): 8.9 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 330.22 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.996 H:M:S, 11.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 325.95 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.404 H:M:S, 13.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/10-17:34:30 ... thread 0: (1000000,4000000) ops and (319181.7,334126.3) ops/second in (3.133012,11.971522) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/14 3.36 GB 25.1 2.8 0.0 2.8 6.6 3.7 0.0 1.7 131.8 305.9 21.94 20.56 63 0.348 2937K 16K 0.0 0.0 L1 0/0 0.00 KB 0.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 256.4 255.3 0.98 0.96 1 0.981 255K 1043 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.1 0.2 0.3 0.1 0.2 2.3 242.2 241.4 1.27 1.22 3 0.424 312K 951 0.0 0.0 L3 20/0 977.65 MB 1.0 1.3 0.4 0.9 1.3 0.4 0.0 3.2 232.1 229.3 5.65 5.23 4 1.411 1330K 16K 0.0 0.0 L4 122/0 9.76 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 206.3 206.3 0.83 0.75 1 0.835 174K 0 0.0 0.0 L5 108/0 8.86 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 267/14 22.94 GB 0.0 4.8 0.9 3.9 8.5 4.7 0.4 2.3 160.9 284.8 30.68 28.71 72 0.426 5011K 34K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.8 0.9 3.9 8.5 4.7 0.4 2.3 160.9 284.8 30.68 28.71 72 0.426 5011K 34K 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.8 0.9 3.9 4.8 0.9 0.0 0.0 248.5 246.7 19.86 19.06 19 1.045 5011K 34K 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 354.6 10.82 9.66 53 0.204 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.1 total, 12.0 interval Flush(GB): cumulative 3.746, interval 3.746 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.53 GB write, 723.56 MB/s write, 4.82 GB read, 408.71 MB/s read, 30.7 seconds Interval compaction: 8.53 GB write, 729.61 MB/s write, 4.82 GB read, 412.13 MB/s read, 30.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 18, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 18, interval: 18 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 872763 Average: 2.2979 StdDev: 14.58 Min: 0 Median: 1.4865 Max: 4248 Percentiles: P50: 1.49 P75: 1.87 P99: 5.69 P99.9: 13.04 P99.99: 194.93 ------------------------------------------------------ [ 0, 1 ] 162748 18.647% 18.647% #### ( 1, 2 ] 562456 64.445% 83.093% ############# ( 2, 3 ] 93556 10.720% 93.812% ## ( 3, 4 ] 27689 3.173% 96.985% # ( 4, 6 ] 20769 2.380% 99.365% ( 6, 10 ] 4198 0.481% 99.846% ( 10, 15 ] 779 0.089% 99.935% ( 15, 22 ] 121 0.014% 99.949% ( 22, 34 ] 16 0.002% 99.951% ( 34, 51 ] 8 0.001% 99.952% ( 51, 76 ] 12 0.001% 99.953% ( 76, 110 ] 63 0.007% 99.960% ( 110, 170 ] 228 0.026% 99.986% ( 170, 250 ] 105 0.012% 99.998% ( 250, 380 ] 36 0.004% 100.002% ( 380, 580 ] 38 0.004% 100.007% ( 580, 870 ] 18 0.002% 100.009% ( 870, 1300 ] 19 0.002% 100.011% ( 1300, 1900 ] 11 0.001% 100.012% ( 1900, 2900 ] 4 0.000% 100.013% ( 2900, 4400 ] 7 0.001% 100.014% ** Level 1 read latency histogram (micros): Count: 63582 Average: 2.9495 StdDev: 13.14 Min: 1 Median: 1.7753 Max: 1638 Percentiles: P50: 1.78 P75: 2.52 P99: 8.39 P99.9: 61.45 P99.99: 626.53 ------------------------------------------------------ [ 0, 1 ] 2275 3.578% 3.578% # ( 1, 2 ] 38069 59.874% 63.452% ############ ( 2, 3 ] 14081 22.146% 85.598% #### ( 3, 4 ] 3883 6.107% 91.705% # ( 4, 6 ] 4076 6.411% 98.116% # ( 6, 10 ] 940 1.478% 99.594% ( 10, 15 ] 168 0.264% 99.858% ( 15, 22 ] 24 0.038% 99.896% ( 22, 34 ] 2 0.003% 99.899% ( 51, 76 ] 1 0.002% 99.901% ( 76, 110 ] 3 0.005% 99.906% ( 110, 170 ] 22 0.035% 99.940% ( 170, 250 ] 12 0.019% 99.959% ( 250, 380 ] 10 0.016% 99.975% ( 380, 580 ] 9 0.014% 99.989% ( 580, 870 ] 4 0.006% 99.995% ( 870, 1300 ] 2 0.003% 99.998% ( 1300, 1900 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 86756 Average: 2.3736 StdDev: 13.31 Min: 0 Median: 1.4837 Max: 2169 Percentiles: P50: 1.48 P75: 1.88 P99: 6.55 P99.9: 54.25 P99.99: 245.50 ------------------------------------------------------ [ 0, 1 ] 17108 19.720% 19.720% #### ( 1, 2 ] 54305 62.595% 82.315% ############# ( 2, 3 ] 9104 10.494% 92.809% ## ( 3, 4 ] 2920 3.366% 96.174% # ( 4, 6 ] 2345 2.703% 98.877% # ( 6, 10 ] 768 0.885% 99.763% ( 10, 15 ] 88 0.101% 99.864% ( 15, 22 ] 19 0.022% 99.886% ( 22, 34 ] 2 0.002% 99.888% ( 34, 51 ] 4 0.005% 99.893% ( 51, 76 ] 48 0.055% 99.948% ( 76, 110 ] 14 0.016% 99.964% ( 110, 170 ] 11 0.013% 99.977% ( 170, 250 ] 12 0.014% 99.991% ( 250, 380 ] 4 0.005% 99.995% ( 380, 580 ] 3 0.003% 99.999% ( 580, 870 ] 3 0.003% 100.002% ( 870, 1300 ] 5 0.006% 100.008% ( 1300, 1900 ] 1 0.001% 100.009% ( 1900, 2900 ] 1 0.001% 100.010% ** Level 3 read latency histogram (micros): Count: 272495 Average: 3.6910 StdDev: 49.15 Min: 0 Median: 1.6867 Max: 9508 Percentiles: P50: 1.69 P75: 2.28 P99: 8.82 P99.9: 244.40 P99.99: 868.36 ------------------------------------------------------ [ 0, 1 ] 17951 6.588% 6.588% # ( 1, 2 ] 172275 63.221% 69.809% ############# ( 2, 3 ] 50477 18.524% 88.333% #### ( 3, 4 ] 13208 4.847% 93.180% # ( 4, 6 ] 12277 4.505% 97.685% # ( 6, 10 ] 5078 1.864% 99.549% ( 10, 15 ] 365 0.134% 99.683% ( 15, 22 ] 53 0.019% 99.702% ( 22, 34 ] 4 0.001% 99.704% ( 34, 51 ] 5 0.002% 99.706% ( 51, 76 ] 3 0.001% 99.707% ( 76, 110 ] 165 0.061% 99.767% ( 110, 170 ] 222 0.081% 99.849% ( 170, 250 ] 150 0.055% 99.904% ( 250, 380 ] 114 0.042% 99.946% ( 380, 580 ] 77 0.028% 99.974% ( 580, 870 ] 44 0.016% 99.990% ( 870, 1300 ] 19 0.007% 99.997% ( 1300, 1900 ] 15 0.006% 100.003% ( 1900, 2900 ] 6 0.002% 100.005% ( 2900, 4400 ] 7 0.003% 100.007% ( 4400, 6600 ] 8 0.003% 100.010% ( 6600, 9900 ] 3 0.001% 100.011% ** Level 4 read latency histogram (micros): Count: 60 Average: 1545.8833 StdDev: 2053.98 Min: 1 Median: 170.0000 Max: 7135 Percentiles: P50: 170.00 P75: 2900.00 P99: 7135.00 P99.9: 7135.00 P99.99: 7135.00 ------------------------------------------------------ [ 0, 1 ] 8 13.333% 13.333% ### ( 1, 2 ] 9 15.000% 28.333% ### ( 3, 4 ] 1 1.667% 30.000% ( 6, 10 ] 1 1.667% 31.667% ( 10, 15 ] 1 1.667% 33.333% ( 15, 22 ] 1 1.667% 35.000% ( 22, 34 ] 1 1.667% 36.667% ( 76, 110 ] 6 10.000% 46.667% ## ( 110, 170 ] 2 3.333% 50.000% # ( 250, 380 ] 3 5.000% 55.000% # ( 380, 580 ] 1 1.667% 56.667% ( 580, 870 ] 1 1.667% 58.333% ( 870, 1300 ] 3 5.000% 63.333% # ( 1300, 1900 ] 2 3.333% 66.667% # ( 1900, 2900 ] 5 8.333% 75.000% ## ( 2900, 4400 ] 7 11.667% 86.667% ## ( 4400, 6600 ] 6 10.000% 96.667% ## ( 6600, 9900 ] 2 3.333% 100.000% # ** DB Stats ** Uptime(secs): 12.1 total, 3.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 326.05 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.548 H:M:S, 12.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 314.14 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.552 H:M:S, 17.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 20000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 19378.7 MB (estimated) FileSize: 19378.7 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 4.042 micros/op 247429 ops/sec 20.070 seconds 4965999 operations; 239.7 MB/s Microseconds per write: Count: 4965999 Average: 4.0415 StdDev: 241.32 Min: 0 Median: 1.7006 Max: 212943 Percentiles: P50: 1.70 P75: 2.65 P99: 8.24 P99.9: 136.29 P99.99: 2383.78 ------------------------------------------------------ [ 0, 1 ] 736416 14.829% 14.829% ### ( 1, 2 ] 2493032 50.202% 65.031% ########## ( 2, 3 ] 757242 15.249% 80.280% ### ( 3, 4 ] 670025 13.492% 93.772% ### ( 4, 6 ] 233542 4.703% 98.475% # ( 6, 10 ] 46540 0.937% 99.412% ( 10, 15 ] 15126 0.305% 99.717% ( 15, 22 ] 4165 0.084% 99.800% ( 22, 34 ] 664 0.013% 99.814% ( 34, 51 ] 96 0.002% 99.816% ( 51, 76 ] 7 0.000% 99.816% ( 76, 110 ] 3661 0.074% 99.890% ( 110, 170 ] 1180 0.024% 99.913% ( 170, 250 ] 136 0.003% 99.916% ( 250, 380 ] 49 0.001% 99.917% ( 380, 580 ] 8 0.000% 99.917% ( 580, 870 ] 4 0.000% 99.917% ( 870, 1300 ] 3157 0.064% 99.981% ( 1300, 1900 ] 2 0.000% 99.981% ( 1900, 2900 ] 931 0.019% 100.000% ( 2900, 4400 ] 2 0.000% 100.000% ( 4400, 6600 ] 1 0.000% 100.000% ( 6600, 9900 ] 1 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 7 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 : 191345 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 : 4965999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 5124910968 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 : 144 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 6883193 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 : 8969165423 rocksdb.compact.write.bytes COUNT : 8780767652 rocksdb.flush.write.bytes COUNT : 5077751574 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 : 10 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 : 5045419008 rocksdb.memtable.garbage.bytes.at.flush COUNT : 9884672 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 : 9008364231 rocksdb.non.last.level.read.count COUNT : 2176586 rocksdb.block.checksum.compute.count COUNT : 2176309 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.335508 P95 : 3.819525 P99 : 6.301368 P100 : 212940.000000 COUNT : 4965999 SUM : 17818956 rocksdb.compaction.times.micros P50 : 1017857.142857 P95 : 1865000.000000 P99 : 3335378.000000 P100 : 3335378.000000 COUNT : 23 SUM : 23847635 rocksdb.compaction.times.cpu_micros P50 : 969285.714286 P95 : 1795000.000000 P99 : 3072028.000000 P100 : 3072028.000000 COUNT : 23 SUM : 22973282 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 : 889.545455 P95 : 1294.136364 P99 : 1739.000000 P100 : 1739.000000 COUNT : 69 SUM : 58818 rocksdb.compaction.outfile.sync.micros P50 : 766.428571 P95 : 1535.000000 P99 : 1652.000000 P100 : 1652.000000 COUNT : 73 SUM : 59775 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 : 76.000000 P95 : 224.666667 P99 : 255.200000 P100 : 290.000000 COUNT : 96 SUM : 9426 rocksdb.table.open.io.micros P50 : 1425.000000 P95 : 15600.000000 P99 : 20458.000000 P100 : 20458.000000 COUNT : 144 SUM : 418235 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.578140 P95 : 6.217403 P99 : 9.839128 P100 : 4631.000000 COUNT : 2176023 SUM : 10414845 rocksdb.read.block.get.micros P50 : 477.560976 P95 : 4236.363636 P99 : 6732.000000 P100 : 9596.000000 COUNT : 288 SUM : 301686 rocksdb.write.raw.block.micros P50 : 0.510993 P95 : 0.970887 P99 : 2.722563 P100 : 4159.000000 COUNT : 3358166 SUM : 6214177 rocksdb.numfiles.in.singlecompaction P50 : 3.285714 P95 : 9.200000 P99 : 13.600000 P100 : 14.000000 COUNT : 28 SUM : 113 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.559856 P95 : 1165.276195 P99 : 2499.409237 P100 : 212722.000000 COUNT : 38695 SUM : 6887447 rocksdb.sst.read.micros P50 : 1.536738 P95 : 3.678571 P99 : 7.324882 P100 : 9508.000000 COUNT : 2176810 SUM : 6174892 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 : 4965999 SUM : 5124910968 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 : 210769.230769 P95 : 330166.666667 P99 : 368741.000000 P100 : 368741.000000 COUNT : 69 SUM : 13699633 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 : 91 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