[2024-07-12 19:03:06.144151] Starting SPDK v24.09-pre git sha1 5f33ec93a / DPDK 24.03.0 initialization... [2024-07-12 19:03:06.144422] [ 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_pid1491772 ] Set seed to 1720803786137733 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-12 19:03:06.257280] app.c: 908:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-12 19:03:06.471393] app.c: 603:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-12 19:03:06.471442] app.c: 604:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1491772' to capture a snapshot of events at runtime. [2024-07-12 19:03:06.471452] app.c: 609:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-12 19:03:06.471463] app.c: 610:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-12 19:03:06.471471] app.c: 611:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1491772 for offline analysis/debug. [2024-07-12 19:03:06.471569] reactor.c: 941:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Jul 12 19:03:12 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/07/12-19:03:15 ... thread 0: (1000000,1000000) ops and (343562.8,343562.8) ops/second in (2.910676,2.910676) 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.07 MB 18.9 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 357.8 2.46 2.21 12 0.205 0 0 0.0 0.0 L1 2/0 240.41 MB 24.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 252.6 251.5 1.00 0.97 1 0.995 255K 1086 0.0 0.0 L2 1/0 49.06 MB 0.5 0.3 0.1 0.2 0.3 0.1 0.0 2.3 247.0 246.3 1.25 1.19 3 0.415 312K 885 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 223.4 223.4 0.54 0.49 1 0.540 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.09 GB 0.0 0.7 0.5 0.2 1.5 1.4 0.1 1.8 129.7 297.3 5.24 4.86 17 0.308 690K 1971 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 129.7 297.3 5.24 4.86 17 0.308 690K 1971 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 244.4 243.7 2.78 2.65 5 0.556 690K 1971 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 357.8 2.46 2.21 12 0.205 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.0 total, 2.9 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, 519.74 MB/s write, 0.66 GB read, 226.74 MB/s read, 5.2 seconds Interval compaction: 1.52 GB write, 534.93 MB/s write, 0.66 GB read, 233.36 MB/s read, 5.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: 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: 140752 Average: 2.0791 StdDev: 10.68 Min: 1 Median: 1.4175 Max: 3201 Percentiles: P50: 1.42 P75: 1.81 P99: 5.48 P99.9: 10.25 P99.99: 21.32 ------------------------------------------------------ [ 0, 1 ] 32799 23.303% 23.303% ##### ( 1, 2 ] 90002 63.944% 87.246% ############# ( 2, 3 ] 11144 7.917% 95.164% ## ( 3, 4 ] 3549 2.521% 97.685% # ( 4, 6 ] 2506 1.780% 99.466% ( 6, 10 ] 607 0.431% 99.897% ( 10, 15 ] 123 0.087% 99.984% ( 15, 22 ] 11 0.008% 99.992% ( 22, 34 ] 3 0.002% 99.994% ( 34, 51 ] 1 0.001% 99.995% ( 51, 76 ] 4 0.003% 99.998% ( 110, 170 ] 8 0.006% 100.004% ( 170, 250 ] 2 0.001% 100.005% ( 250, 380 ] 2 0.001% 100.006% ( 380, 580 ] 6 0.004% 100.011% ( 580, 870 ] 3 0.002% 100.013% ( 870, 1300 ] 2 0.001% 100.014% ( 2900, 4400 ] 1 0.001% 100.015% ** Level 1 read latency histogram (micros): Count: 2530 Average: 4.1158 StdDev: 45.23 Min: 1 Median: 1.7353 Max: 1782 Percentiles: P50: 1.74 P75: 2.54 P99: 9.37 P99.9: 345.55 P99.99: 1782.00 ------------------------------------------------------ [ 0, 1 ] 226 8.933% 8.933% ## ( 1, 2 ] 1413 55.850% 64.783% ########### ( 2, 3 ] 479 18.933% 83.715% #### ( 3, 4 ] 218 8.617% 92.332% ## ( 4, 6 ] 135 5.336% 97.668% # ( 6, 10 ] 40 1.581% 99.249% ( 10, 15 ] 13 0.514% 99.763% ( 15, 22 ] 1 0.040% 99.802% ( 22, 34 ] 1 0.040% 99.842% ( 250, 380 ] 2 0.079% 99.921% ( 1300, 1900 ] 2 0.079% 100.000% ** Level 2 read latency histogram (micros): Count: 74284 Average: 2.5900 StdDev: 27.71 Min: 0 Median: 1.4963 Max: 5568 Percentiles: P50: 1.50 P75: 1.90 P99: 6.59 P99.9: 56.50 P99.99: 377.58 ------------------------------------------------------ [ 0, 1 ] 14161 19.063% 19.063% #### ( 1, 2 ] 46303 62.332% 81.396% ############ ( 2, 3 ] 8043 10.827% 92.223% ## ( 3, 4 ] 2593 3.491% 95.714% # ( 4, 6 ] 2348 3.161% 98.875% # ( 6, 10 ] 633 0.852% 99.727% ( 10, 15 ] 107 0.144% 99.871% ( 15, 22 ] 11 0.015% 99.886% ( 22, 34 ] 3 0.004% 99.890% ( 34, 51 ] 2 0.003% 99.892% ( 51, 76 ] 26 0.035% 99.927% ( 76, 110 ] 6 0.008% 99.935% ( 110, 170 ] 3 0.004% 99.939% ( 170, 250 ] 15 0.020% 99.960% ( 250, 380 ] 23 0.031% 99.991% ( 380, 580 ] 6 0.008% 99.999% ( 580, 870 ] 4 0.005% 100.004% ( 870, 1300 ] 1 0.001% 100.005% ( 1300, 1900 ] 1 0.001% 100.007% ( 1900, 2900 ] 1 0.001% 100.008% ( 2900, 4400 ] 1 0.001% 100.009% ( 4400, 6600 ] 1 0.001% 100.011% ** Level 3 read latency histogram (micros): Count: 85 Average: 1572.2353 StdDev: 2139.37 Min: 1 Median: 240.0000 Max: 7543 Percentiles: P50: 240.00 P75: 3162.50 P99: 7543.00 P99.9: 7543.00 P99.99: 7543.00 ------------------------------------------------------ [ 0, 1 ] 16 18.824% 18.824% #### ( 1, 2 ] 8 9.412% 28.235% ## ( 2, 3 ] 1 1.176% 29.412% ( 3, 4 ] 2 2.353% 31.765% ( 4, 6 ] 1 1.176% 32.941% ( 6, 10 ] 3 3.529% 36.471% # ( 10, 15 ] 5 5.882% 42.353% # ( 15, 22 ] 1 1.176% 43.529% ( 76, 110 ] 1 1.176% 44.706% ( 110, 170 ] 1 1.176% 45.882% ( 170, 250 ] 4 4.706% 50.588% # ( 250, 380 ] 3 3.529% 54.118% # ( 380, 580 ] 3 3.529% 57.647% # ( 580, 870 ] 2 2.353% 60.000% ( 870, 1300 ] 2 2.353% 62.353% ( 1300, 1900 ] 5 5.882% 68.235% # ( 1900, 2900 ] 4 4.706% 72.941% # ( 2900, 4400 ] 10 11.765% 84.706% ## ( 4400, 6600 ] 10 11.765% 96.471% ## ( 6600, 9900 ] 3 3.529% 100.000% # ** Level 4 read latency histogram (micros): Count: 30 Average: 3217.5667 StdDev: 1923.34 Min: 149 Median: 3309.0909 Max: 8024 Percentiles: P50: 3309.09 P75: 4331.82 P99: 8024.00 P99.9: 8024.00 P99.99: 8024.00 ------------------------------------------------------ ( 110, 170 ] 1 3.333% 3.333% # ( 250, 380 ] 1 3.333% 6.667% # ( 380, 580 ] 2 6.667% 13.333% # ( 580, 870 ] 1 3.333% 16.667% # ( 870, 1300 ] 2 6.667% 23.333% # ( 1300, 1900 ] 2 6.667% 30.000% # ( 1900, 2900 ] 3 10.000% 40.000% ## ( 2900, 4400 ] 11 36.667% 76.667% ####### ( 4400, 6600 ] 6 20.000% 96.667% #### ( 6600, 9900 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 3.0 total, 2.9 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 328.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:0.375 H:M:S, 12.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 337.78 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.375 H:M:S, 12.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/12-19:03:18 ... thread 0: (1000000,2000000) ops and (354866.5,349123.2) ops/second in (2.817961,5.728637) 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 18.9 0.8 0.0 0.8 2.6 1.8 0.0 1.4 99.5 320.9 8.22 7.57 29 0.283 830K 4506 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 252.6 251.5 1.00 0.97 1 0.995 255K 1086 0.0 0.0 L2 1/1 49.06 MB 0.0 0.3 0.1 0.2 0.3 0.1 0.2 2.3 247.0 246.3 1.25 1.19 3 0.415 312K 885 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 223.8 223.1 2.25 2.13 3 0.751 512K 1531 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.8 0.7 1.1 3.6 2.5 0.4 2.0 148.0 290.8 12.71 11.85 36 0.353 1910K 8008 0.0 0.0 Int 0/0 0.00 KB 0.0 1.8 0.7 1.1 3.6 2.5 0.4 2.0 148.0 290.8 12.71 11.85 36 0.353 1910K 8008 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.8 0.7 1.1 1.8 0.7 0.0 0.0 247.2 246.1 7.61 7.34 10 0.761 1910K 8008 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 357.5 5.10 4.51 26 0.196 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.8 total, 5.7 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.61 GB write, 635.73 MB/s write, 1.84 GB read, 323.52 MB/s read, 12.7 seconds Interval compaction: 3.61 GB write, 645.16 MB/s write, 1.84 GB read, 328.32 MB/s read, 12.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: 8, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 8, interval: 8 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 338353 Average: 2.3798 StdDev: 13.53 Min: 1 Median: 1.5376 Max: 3583 Percentiles: P50: 1.54 P75: 1.93 P99: 5.86 P99.9: 13.73 P99.99: 227.91 ------------------------------------------------------ [ 0, 1 ] 52105 15.400% 15.400% ### ( 1, 2 ] 217779 64.364% 79.764% ############# ( 2, 3 ] 44268 13.083% 92.847% ### ( 3, 4 ] 12172 3.597% 96.445% # ( 4, 6 ] 9322 2.755% 99.200% # ( 6, 10 ] 2040 0.603% 99.803% ( 10, 15 ] 443 0.131% 99.934% ( 15, 22 ] 27 0.008% 99.942% ( 22, 34 ] 7 0.002% 99.944% ( 34, 51 ] 2 0.001% 99.944% ( 51, 76 ] 14 0.004% 99.949% ( 76, 110 ] 40 0.012% 99.960% ( 110, 170 ] 79 0.023% 99.984% ( 170, 250 ] 32 0.009% 99.993% ( 250, 380 ] 18 0.005% 99.999% ( 380, 580 ] 21 0.006% 100.005% ( 580, 870 ] 11 0.003% 100.008% ( 870, 1300 ] 5 0.001% 100.009% ( 1300, 1900 ] 2 0.001% 100.010% ( 1900, 2900 ] 2 0.001% 100.011% ( 2900, 4400 ] 2 0.001% 100.011% ** Level 1 read latency histogram (micros): Count: 63576 Average: 2.7462 StdDev: 11.48 Min: 1 Median: 1.7366 Max: 1782 Percentiles: P50: 1.74 P75: 2.39 P99: 8.11 P99.9: 15.13 P99.99: 512.12 ------------------------------------------------------ [ 0, 1 ] 2343 3.685% 3.685% # ( 1, 2 ] 39974 62.876% 66.561% ############# ( 2, 3 ] 13623 21.428% 87.989% #### ( 3, 4 ] 3694 5.810% 93.800% # ( 4, 6 ] 2885 4.538% 98.337% # ( 6, 10 ] 798 1.255% 99.593% ( 10, 15 ] 195 0.307% 99.899% ( 15, 22 ] 23 0.036% 99.936% ( 22, 34 ] 2 0.003% 99.939% ( 34, 51 ] 1 0.002% 99.940% ( 76, 110 ] 3 0.005% 99.945% ( 110, 170 ] 13 0.020% 99.965% ( 170, 250 ] 6 0.009% 99.975% ( 250, 380 ] 7 0.011% 99.986% ( 380, 580 ] 4 0.006% 99.992% ( 580, 870 ] 3 0.005% 99.997% ( 1300, 1900 ] 2 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 76803 Average: 2.6278 StdDev: 27.53 Min: 0 Median: 1.5070 Max: 5568 Percentiles: P50: 1.51 P75: 1.91 P99: 6.62 P99.9: 63.69 P99.99: 437.99 ------------------------------------------------------ [ 0, 1 ] 14215 18.508% 18.508% #### ( 1, 2 ] 47706 62.115% 80.623% ############ ( 2, 3 ] 8795 11.451% 92.075% ## ( 3, 4 ] 2733 3.558% 95.633% # ( 4, 6 ] 2484 3.234% 98.867% # ( 6, 10 ] 654 0.852% 99.719% ( 10, 15 ] 110 0.143% 99.862% ( 15, 22 ] 11 0.014% 99.876% ( 22, 34 ] 3 0.004% 99.880% ( 34, 51 ] 2 0.003% 99.883% ( 51, 76 ] 26 0.034% 99.917% ( 76, 110 ] 8 0.010% 99.927% ( 110, 170 ] 6 0.008% 99.935% ( 170, 250 ] 16 0.021% 99.956% ( 250, 380 ] 24 0.031% 99.987% ( 380, 580 ] 8 0.010% 99.997% ( 580, 870 ] 5 0.007% 100.004% ( 870, 1300 ] 1 0.001% 100.005% ( 1300, 1900 ] 1 0.001% 100.007% ( 1900, 2900 ] 1 0.001% 100.008% ( 2900, 4400 ] 1 0.001% 100.009% ( 4400, 6600 ] 1 0.001% 100.010% ** Level 3 read latency histogram (micros): Count: 169032 Average: 3.9673 StdDev: 61.65 Min: 1 Median: 1.7291 Max: 7543 Percentiles: P50: 1.73 P75: 2.38 P99: 8.91 P99.9: 217.24 P99.99: 829.91 ------------------------------------------------------ [ 0, 1 ] 8114 4.800% 4.800% # ( 1, 2 ] 104790 61.994% 66.794% ############ ( 2, 3 ] 36650 21.682% 88.477% #### ( 3, 4 ] 8507 5.033% 93.510% # ( 4, 6 ] 7141 4.225% 97.734% # ( 6, 10 ] 2947 1.743% 99.478% ( 10, 15 ] 324 0.192% 99.669% ( 15, 22 ] 29 0.017% 99.686% ( 22, 34 ] 8 0.005% 99.691% ( 34, 51 ] 3 0.002% 99.693% ( 51, 76 ] 1 0.001% 99.694% ( 76, 110 ] 124 0.073% 99.767% ( 110, 170 ] 174 0.103% 99.870% ( 170, 250 ] 88 0.052% 99.922% ( 250, 380 ] 58 0.034% 99.956% ( 380, 580 ] 40 0.024% 99.980% ( 580, 870 ] 21 0.012% 99.992% ( 870, 1300 ] 8 0.005% 99.997% ( 1300, 1900 ] 6 0.004% 100.001% ( 1900, 2900 ] 5 0.003% 100.004% ( 2900, 4400 ] 10 0.006% 100.009% ( 4400, 6600 ] 10 0.006% 100.015% ( 6600, 9900 ] 3 0.002% 100.017% ** Level 4 read latency histogram (micros): Count: 30 Average: 3217.5667 StdDev: 1923.34 Min: 149 Median: 3309.0909 Max: 8024 Percentiles: P50: 3309.09 P75: 4331.82 P99: 8024.00 P99.9: 8024.00 P99.99: 8024.00 ------------------------------------------------------ ( 110, 170 ] 1 3.333% 3.333% # ( 250, 380 ] 1 3.333% 6.667% # ( 380, 580 ] 2 6.667% 13.333% # ( 580, 870 ] 1 3.333% 16.667% # ( 870, 1300 ] 2 6.667% 23.333% # ( 1300, 1900 ] 2 6.667% 30.000% # ( 1900, 2900 ] 3 10.000% 40.000% ## ( 2900, 4400 ] 11 36.667% 76.667% ####### ( 4400, 6600 ] 6 20.000% 96.667% #### ( 6600, 9900 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 5.8 total, 2.8 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 338.45 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.597 H:M:S, 10.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 349.27 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.222 H:M:S, 7.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/12-19:03:21 ... thread 0: (1000000,3000000) ops and (324626.9,340557.1) ops/second in (3.080459,8.809096) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/16 2.33 GB 56.3 1.4 0.0 1.4 4.0 2.7 0.0 1.5 105.1 314.6 13.17 12.11 44 0.299 1405K 7553 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 252.6 251.5 1.00 0.97 1 0.995 255K 1086 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 247.0 246.3 1.25 1.19 3 0.415 312K 885 0.0 0.0 L3 14/0 977.66 MB 1.0 1.3 0.4 0.9 1.3 0.4 0.0 3.2 226.3 223.5 5.79 5.43 4 1.447 1330K 16K 0.0 0.0 L4 122/0 9.77 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 200.9 200.9 0.86 0.74 1 0.859 175K 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 262/16 21.90 GB 0.0 3.3 0.9 2.4 6.0 3.6 0.4 2.2 155.3 279.6 22.06 20.45 53 0.416 3478K 25K 0.0 0.0 Int 0/0 0.00 KB 0.0 3.3 0.9 2.4 6.0 3.6 0.4 2.2 155.3 279.6 22.06 20.45 53 0.416 3478K 25K 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.3 0.9 2.4 3.3 0.9 0.0 0.0 240.4 238.6 14.25 13.56 14 1.018 3478K 25K 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 354.4 7.81 6.88 39 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): 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.02 GB write, 693.17 MB/s write, 3.34 GB read, 384.99 MB/s read, 22.1 seconds Interval compaction: 6.02 GB write, 699.86 MB/s write, 3.34 GB read, 388.71 MB/s read, 22.1 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: 726954 Average: 2.6524 StdDev: 14.92 Min: 1 Median: 1.6291 Max: 3984 Percentiles: P50: 1.63 P75: 2.09 P99: 6.92 P99.9: 14.53 P99.99: 205.39 ------------------------------------------------------ [ 0, 1 ] 74130 10.197% 10.197% ## ( 1, 2 ] 459920 63.267% 73.464% ############# ( 2, 3 ] 127107 17.485% 90.949% ### ( 3, 4 ] 30610 4.211% 95.160% # ( 4, 6 ] 26288 3.616% 98.776% # ( 6, 10 ] 7066 0.972% 99.748% ( 10, 15 ] 1221 0.168% 99.916% ( 15, 22 ] 85 0.012% 99.928% ( 22, 34 ] 10 0.001% 99.929% ( 34, 51 ] 4 0.001% 99.929% ( 51, 76 ] 20 0.003% 99.932% ( 76, 110 ] 110 0.015% 99.947% ( 110, 170 ] 256 0.035% 99.983% ( 170, 250 ] 125 0.017% 100.000% ( 250, 380 ] 85 0.012% 100.011% ( 380, 580 ] 94 0.013% 100.024% ( 580, 870 ] 36 0.005% 100.029% ( 870, 1300 ] 19 0.003% 100.032% ( 1300, 1900 ] 9 0.001% 100.033% ( 1900, 2900 ] 4 0.001% 100.034% ( 2900, 4400 ] 3 0.000% 100.034% ** Level 1 read latency histogram (micros): Count: 63576 Average: 2.7462 StdDev: 11.48 Min: 1 Median: 1.7366 Max: 1782 Percentiles: P50: 1.74 P75: 2.39 P99: 8.11 P99.9: 15.13 P99.99: 512.12 ------------------------------------------------------ [ 0, 1 ] 2343 3.685% 3.685% # ( 1, 2 ] 39974 62.876% 66.561% ############# ( 2, 3 ] 13623 21.428% 87.989% #### ( 3, 4 ] 3694 5.810% 93.800% # ( 4, 6 ] 2885 4.538% 98.337% # ( 6, 10 ] 798 1.255% 99.593% ( 10, 15 ] 195 0.307% 99.899% ( 15, 22 ] 23 0.036% 99.936% ( 22, 34 ] 2 0.003% 99.939% ( 34, 51 ] 1 0.002% 99.940% ( 76, 110 ] 3 0.005% 99.945% ( 110, 170 ] 13 0.020% 99.965% ( 170, 250 ] 6 0.009% 99.975% ( 250, 380 ] 7 0.011% 99.986% ( 380, 580 ] 4 0.006% 99.992% ( 580, 870 ] 3 0.005% 99.997% ( 1300, 1900 ] 2 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 86744 Average: 2.7732 StdDev: 26.85 Min: 0 Median: 1.5439 Max: 5568 Percentiles: P50: 1.54 P75: 1.95 P99: 7.38 P99.9: 141.81 P99.99: 517.67 ------------------------------------------------------ [ 0, 1 ] 14548 16.771% 16.771% ### ( 1, 2 ] 52998 61.097% 77.868% ############ ( 2, 3 ] 11747 13.542% 91.410% ### ( 3, 4 ] 3223 3.716% 95.126% # ( 4, 6 ] 3057 3.524% 98.650% # ( 6, 10 ] 880 1.014% 99.665% ( 10, 15 ] 135 0.156% 99.820% ( 15, 22 ] 11 0.013% 99.833% ( 22, 34 ] 4 0.005% 99.837% ( 34, 51 ] 2 0.002% 99.840% ( 51, 76 ] 26 0.030% 99.870% ( 76, 110 ] 13 0.015% 99.885% ( 110, 170 ] 25 0.029% 99.914% ( 170, 250 ] 25 0.029% 99.942% ( 250, 380 ] 31 0.036% 99.978% ( 380, 580 ] 15 0.017% 99.995% ( 580, 870 ] 6 0.007% 100.002% ( 870, 1300 ] 2 0.002% 100.005% ( 1300, 1900 ] 1 0.001% 100.006% ( 1900, 2900 ] 1 0.001% 100.007% ( 2900, 4400 ] 1 0.001% 100.008% ( 4400, 6600 ] 1 0.001% 100.009% ** Level 3 read latency histogram (micros): Count: 272295 Average: 3.8426 StdDev: 51.58 Min: 1 Median: 1.7479 Max: 7543 Percentiles: P50: 1.75 P75: 2.43 P99: 9.06 P99.9: 243.71 P99.99: 1119.61 ------------------------------------------------------ [ 0, 1 ] 12170 4.469% 4.469% # ( 1, 2 ] 165761 60.876% 65.345% ############ ( 2, 3 ] 61751 22.678% 88.023% ##### ( 3, 4 ] 13984 5.136% 93.159% # ( 4, 6 ] 11994 4.405% 97.563% # ( 6, 10 ] 5120 1.880% 99.444% ( 10, 15 ] 632 0.232% 99.676% ( 15, 22 ] 61 0.022% 99.698% ( 22, 34 ] 13 0.005% 99.703% ( 34, 51 ] 4 0.001% 99.704% ( 51, 76 ] 1 0.000% 99.705% ( 76, 110 ] 177 0.065% 99.770% ( 110, 170 ] 234 0.086% 99.856% ( 170, 250 ] 131 0.048% 99.904% ( 250, 380 ] 103 0.038% 99.942% ( 380, 580 ] 73 0.027% 99.968% ( 580, 870 ] 46 0.017% 99.985% ( 870, 1300 ] 22 0.008% 99.993% ( 1300, 1900 ] 12 0.004% 99.998% ( 1900, 2900 ] 11 0.004% 100.002% ( 2900, 4400 ] 10 0.004% 100.006% ( 4400, 6600 ] 10 0.004% 100.009% ( 6600, 9900 ] 3 0.001% 100.010% ** Level 4 read latency histogram (micros): Count: 60 Average: 1658.6833 StdDev: 2074.44 Min: 1 Median: 380.0000 Max: 8024 Percentiles: P50: 380.00 P75: 3309.09 P99: 7920.00 P99.9: 8024.00 P99.99: 8024.00 ------------------------------------------------------ [ 0, 1 ] 7 11.667% 11.667% ## ( 1, 2 ] 11 18.333% 30.000% #### ( 22, 34 ] 2 3.333% 33.333% # ( 76, 110 ] 6 10.000% 43.333% ## ( 110, 170 ] 1 1.667% 45.000% ( 250, 380 ] 3 5.000% 50.000% # ( 380, 580 ] 2 3.333% 53.333% # ( 580, 870 ] 2 3.333% 56.667% # ( 870, 1300 ] 3 5.000% 61.667% # ( 1300, 1900 ] 2 3.333% 65.000% # ( 1900, 2900 ] 3 5.000% 70.000% # ( 2900, 4400 ] 11 18.333% 88.333% #### ( 4400, 6600 ] 6 10.000% 98.333% ## ( 6600, 9900 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 8.9 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 331.88 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.075 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, 319.50 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.478 H:M:S, 15.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/12-19:03:24 ... thread 0: (1000000,4000000) ops and (304297.7,330705.6) ops/second in (3.286255,12.095351) 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/13 2.14 GB 18.9 2.1 0.0 2.1 5.9 3.7 0.0 1.6 113.5 310.7 19.39 17.91 61 0.318 2235K 11K 0.0 0.0 L1 10/10 1.19 GB 0.0 1.5 1.5 0.0 1.4 1.4 0.1 1.0 227.4 222.3 6.62 6.30 2 3.308 1528K 33K 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 247.0 246.3 1.25 1.19 3 0.415 312K 885 0.0 0.0 L3 14/0 977.66 MB 1.0 1.3 0.4 0.9 1.3 0.4 0.0 3.2 226.3 223.5 5.79 5.43 4 1.447 1330K 16K 0.0 0.0 L4 122/0 9.77 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 200.9 200.9 0.86 0.74 1 0.859 175K 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 269/23 22.91 GB 0.0 5.4 2.2 3.2 9.1 5.9 0.4 2.4 162.1 273.4 33.90 31.56 71 0.477 5581K 62K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.4 2.2 3.2 9.1 5.9 0.4 2.4 162.1 273.4 33.90 31.56 71 0.477 5581K 62K 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.4 2.2 3.2 5.3 2.1 0.0 0.0 238.9 236.2 23.01 21.95 18 1.278 5581K 62K 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 352.2 10.89 9.61 53 0.205 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.2 total, 12.1 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: 9.05 GB write, 760.90 MB/s write, 5.37 GB read, 451.13 MB/s read, 33.9 seconds Interval compaction: 9.05 GB write, 766.25 MB/s write, 5.37 GB read, 454.30 MB/s read, 33.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 16, interval: 17 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1060787 Average: 2.6268 StdDev: 15.15 Min: 0 Median: 1.6140 Max: 3984 Percentiles: P50: 1.61 P75: 2.00 P99: 6.74 P99.9: 14.84 P99.99: 208.15 ------------------------------------------------------ [ 0, 1 ] 108315 10.211% 10.211% ## ( 1, 2 ] 687453 64.806% 75.017% ############# ( 2, 3 ] 178124 16.792% 91.808% ### ( 3, 4 ] 40819 3.848% 95.656% # ( 4, 6 ] 33659 3.173% 98.829% # ( 6, 10 ] 9787 0.923% 99.752% ( 10, 15 ] 1622 0.153% 99.905% ( 15, 22 ] 106 0.010% 99.915% ( 22, 34 ] 12 0.001% 99.916% ( 34, 51 ] 5 0.000% 99.917% ( 51, 76 ] 23 0.002% 99.919% ( 76, 110 ] 195 0.018% 99.937% ( 110, 170 ] 478 0.045% 99.982% ( 170, 250 ] 176 0.017% 99.999% ( 250, 380 ] 112 0.011% 100.009% ( 380, 580 ] 133 0.013% 100.022% ( 580, 870 ] 52 0.005% 100.027% ( 870, 1300 ] 27 0.003% 100.029% ( 1300, 1900 ] 11 0.001% 100.030% ( 1900, 2900 ] 5 0.000% 100.031% ( 2900, 4400 ] 6 0.001% 100.031% ** Level 1 read latency histogram (micros): Count: 92307 Average: 2.9536 StdDev: 22.58 Min: 0 Median: 1.6729 Max: 2942 Percentiles: P50: 1.67 P75: 2.21 P99: 8.28 P99.9: 127.86 P99.99: 1167.70 ------------------------------------------------------ [ 0, 1 ] 6200 6.717% 6.717% # ( 1, 2 ] 59375 64.323% 71.040% ############# ( 2, 3 ] 17031 18.450% 89.491% #### ( 3, 4 ] 4542 4.921% 94.411% # ( 4, 6 ] 3555 3.851% 98.262% # ( 6, 10 ] 1193 1.292% 99.555% ( 10, 15 ] 245 0.265% 99.820% ( 15, 22 ] 30 0.033% 99.853% ( 22, 34 ] 4 0.004% 99.857% ( 34, 51 ] 1 0.001% 99.858% ( 76, 110 ] 25 0.027% 99.885% ( 110, 170 ] 46 0.050% 99.935% ( 170, 250 ] 12 0.013% 99.948% ( 250, 380 ] 15 0.016% 99.964% ( 380, 580 ] 12 0.013% 99.977% ( 580, 870 ] 9 0.010% 99.987% ( 870, 1300 ] 4 0.004% 99.991% ( 1300, 1900 ] 5 0.005% 99.997% ( 1900, 2900 ] 2 0.002% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 86744 Average: 2.7732 StdDev: 26.85 Min: 0 Median: 1.5439 Max: 5568 Percentiles: P50: 1.54 P75: 1.95 P99: 7.38 P99.9: 141.81 P99.99: 517.67 ------------------------------------------------------ [ 0, 1 ] 14548 16.771% 16.771% ### ( 1, 2 ] 52998 61.097% 77.868% ############ ( 2, 3 ] 11747 13.542% 91.410% ### ( 3, 4 ] 3223 3.716% 95.126% # ( 4, 6 ] 3057 3.524% 98.650% # ( 6, 10 ] 880 1.014% 99.665% ( 10, 15 ] 135 0.156% 99.820% ( 15, 22 ] 11 0.013% 99.833% ( 22, 34 ] 4 0.005% 99.837% ( 34, 51 ] 2 0.002% 99.840% ( 51, 76 ] 26 0.030% 99.870% ( 76, 110 ] 13 0.015% 99.885% ( 110, 170 ] 25 0.029% 99.914% ( 170, 250 ] 25 0.029% 99.942% ( 250, 380 ] 31 0.036% 99.978% ( 380, 580 ] 15 0.017% 99.995% ( 580, 870 ] 6 0.007% 100.002% ( 870, 1300 ] 2 0.002% 100.005% ( 1300, 1900 ] 1 0.001% 100.006% ( 1900, 2900 ] 1 0.001% 100.007% ( 2900, 4400 ] 1 0.001% 100.008% ( 4400, 6600 ] 1 0.001% 100.009% ** Level 3 read latency histogram (micros): Count: 272295 Average: 3.8426 StdDev: 51.58 Min: 1 Median: 1.7479 Max: 7543 Percentiles: P50: 1.75 P75: 2.43 P99: 9.06 P99.9: 243.71 P99.99: 1119.61 ------------------------------------------------------ [ 0, 1 ] 12170 4.469% 4.469% # ( 1, 2 ] 165761 60.876% 65.345% ############ ( 2, 3 ] 61751 22.678% 88.023% ##### ( 3, 4 ] 13984 5.136% 93.159% # ( 4, 6 ] 11994 4.405% 97.563% # ( 6, 10 ] 5120 1.880% 99.444% ( 10, 15 ] 632 0.232% 99.676% ( 15, 22 ] 61 0.022% 99.698% ( 22, 34 ] 13 0.005% 99.703% ( 34, 51 ] 4 0.001% 99.704% ( 51, 76 ] 1 0.000% 99.705% ( 76, 110 ] 177 0.065% 99.770% ( 110, 170 ] 234 0.086% 99.856% ( 170, 250 ] 131 0.048% 99.904% ( 250, 380 ] 103 0.038% 99.942% ( 380, 580 ] 73 0.027% 99.968% ( 580, 870 ] 46 0.017% 99.985% ( 870, 1300 ] 22 0.008% 99.993% ( 1300, 1900 ] 12 0.004% 99.998% ( 1900, 2900 ] 11 0.004% 100.002% ( 2900, 4400 ] 10 0.004% 100.006% ( 4400, 6600 ] 10 0.004% 100.009% ( 6600, 9900 ] 3 0.001% 100.010% ** Level 4 read latency histogram (micros): Count: 60 Average: 1658.6833 StdDev: 2074.44 Min: 1 Median: 380.0000 Max: 8024 Percentiles: P50: 380.00 P75: 3309.09 P99: 7920.00 P99.9: 8024.00 P99.99: 8024.00 ------------------------------------------------------ [ 0, 1 ] 7 11.667% 11.667% ## ( 1, 2 ] 11 18.333% 30.000% #### ( 22, 34 ] 2 3.333% 33.333% # ( 76, 110 ] 6 10.000% 43.333% ## ( 110, 170 ] 1 1.667% 45.000% ( 250, 380 ] 3 5.000% 50.000% # ( 380, 580 ] 2 3.333% 53.333% # ( 580, 870 ] 2 3.333% 56.667% # ( 870, 1300 ] 3 5.000% 61.667% # ( 1300, 1900 ] 2 3.333% 65.000% # ( 1900, 2900 ] 3 5.000% 70.000% # ( 2900, 4400 ] 11 18.333% 88.333% #### ( 4400, 6600 ] 6 10.000% 98.333% ## ( 6600, 9900 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 12.2 total, 3.3 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 323.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:1.786 H:M:S, 14.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 299.49 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.711 H:M:S, 21.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/12-19:03:28 ... thread 0: (1000000,5000000) ops and (312997.6,327005.5) ops/second in (3.194913,15.290264) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/13 3.12 GB 118.9 3.3 0.0 3.3 8.0 4.7 0.0 1.7 125.8 307.9 26.50 24.60 80 0.331 3385K 17K 0.0 0.0 L1 10/10 1.19 GB 0.0 1.5 1.5 0.0 1.4 1.4 0.1 1.0 227.4 222.3 6.62 6.30 2 3.308 1528K 33K 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 247.0 246.3 1.25 1.19 3 0.415 312K 885 0.0 0.0 L3 14/0 977.66 MB 1.0 1.3 0.4 0.9 1.3 0.4 0.0 3.2 226.3 223.5 5.79 5.43 4 1.447 1330K 16K 0.0 0.0 L4 122/0 9.77 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 200.9 200.9 0.86 0.74 1 0.859 175K 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 272/23 23.89 GB 0.0 6.5 2.2 4.3 11.1 6.8 0.4 2.4 161.6 278.0 41.01 38.26 90 0.456 6731K 68K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.5 2.2 4.3 11.1 6.8 0.4 2.4 161.6 278.0 41.01 38.26 90 0.456 6731K 68K 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 6.5 2.2 4.3 6.4 2.1 0.0 0.0 243.1 240.6 27.26 26.12 22 1.239 6731K 68K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 352.3 13.75 12.14 68 0.202 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): 15.4 total, 15.3 interval Flush(GB): cumulative 4.729, interval 4.729 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: 11.13 GB write, 741.47 MB/s write, 6.47 GB read, 431.02 MB/s read, 41.0 seconds Interval compaction: 11.13 GB write, 745.59 MB/s write, 6.47 GB read, 433.41 MB/s read, 41.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 4, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 4, 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: 4, total-stops: 18, interval: 22 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1429161 Average: 2.6080 StdDev: 14.51 Min: 0 Median: 1.6191 Max: 3984 Percentiles: P50: 1.62 P75: 2.01 P99: 6.47 P99.9: 14.44 P99.99: 187.41 ------------------------------------------------------ [ 0, 1 ] 138391 9.683% 9.683% ## ( 1, 2 ] 930760 65.126% 74.810% ############# ( 2, 3 ] 246733 17.264% 92.074% ### ( 3, 4 ] 53484 3.742% 95.816% # ( 4, 6 ] 44053 3.082% 98.899% # ( 6, 10 ] 12443 0.871% 99.769% ( 10, 15 ] 2104 0.147% 99.917% ( 15, 22 ] 127 0.009% 99.925% ( 22, 34 ] 13 0.001% 99.926% ( 34, 51 ] 5 0.000% 99.927% ( 51, 76 ] 26 0.002% 99.928% ( 76, 110 ] 255 0.018% 99.946% ( 110, 170 ] 576 0.040% 99.987% ( 170, 250 ] 221 0.015% 100.002% ( 250, 380 ] 141 0.010% 100.012% ( 380, 580 ] 169 0.012% 100.024% ( 580, 870 ] 67 0.005% 100.028% ( 870, 1300 ] 35 0.002% 100.031% ( 1300, 1900 ] 17 0.001% 100.032% ( 1900, 2900 ] 7 0.000% 100.033% ( 2900, 4400 ] 6 0.000% 100.033% ** Level 1 read latency histogram (micros): Count: 167305 Average: 2.9654 StdDev: 19.02 Min: 0 Median: 1.6755 Max: 2942 Percentiles: P50: 1.68 P75: 2.21 P99: 8.48 P99.9: 155.52 P99.99: 792.73 ------------------------------------------------------ [ 0, 1 ] 10850 6.485% 6.485% # ( 1, 2 ] 107775 64.418% 70.903% ############# ( 2, 3 ] 32541 19.450% 90.354% #### ( 3, 4 ] 6985 4.175% 94.529% # ( 4, 6 ] 5947 3.555% 98.083% # ( 6, 10 ] 2475 1.479% 99.562% ( 10, 15 ] 356 0.213% 99.775% ( 15, 22 ] 37 0.022% 99.797% ( 22, 34 ] 4 0.002% 99.800% ( 34, 51 ] 1 0.001% 99.800% ( 51, 76 ] 1 0.001% 99.801% ( 76, 110 ] 61 0.036% 99.837% ( 110, 170 ] 138 0.082% 99.920% ( 170, 250 ] 42 0.025% 99.945% ( 250, 380 ] 34 0.020% 99.965% ( 380, 580 ] 31 0.019% 99.984% ( 580, 870 ] 14 0.008% 99.992% ( 870, 1300 ] 5 0.003% 99.995% ( 1300, 1900 ] 5 0.003% 99.998% ( 1900, 2900 ] 2 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 86744 Average: 2.7732 StdDev: 26.85 Min: 0 Median: 1.5439 Max: 5568 Percentiles: P50: 1.54 P75: 1.95 P99: 7.38 P99.9: 141.81 P99.99: 517.67 ------------------------------------------------------ [ 0, 1 ] 14548 16.771% 16.771% ### ( 1, 2 ] 52998 61.097% 77.868% ############ ( 2, 3 ] 11747 13.542% 91.410% ### ( 3, 4 ] 3223 3.716% 95.126% # ( 4, 6 ] 3057 3.524% 98.650% # ( 6, 10 ] 880 1.014% 99.665% ( 10, 15 ] 135 0.156% 99.820% ( 15, 22 ] 11 0.013% 99.833% ( 22, 34 ] 4 0.005% 99.837% ( 34, 51 ] 2 0.002% 99.840% ( 51, 76 ] 26 0.030% 99.870% ( 76, 110 ] 13 0.015% 99.885% ( 110, 170 ] 25 0.029% 99.914% ( 170, 250 ] 25 0.029% 99.942% ( 250, 380 ] 31 0.036% 99.978% ( 380, 580 ] 15 0.017% 99.995% ( 580, 870 ] 6 0.007% 100.002% ( 870, 1300 ] 2 0.002% 100.005% ( 1300, 1900 ] 1 0.001% 100.006% ( 1900, 2900 ] 1 0.001% 100.007% ( 2900, 4400 ] 1 0.001% 100.008% ( 4400, 6600 ] 1 0.001% 100.009% ** Level 3 read latency histogram (micros): Count: 272295 Average: 3.8426 StdDev: 51.58 Min: 1 Median: 1.7479 Max: 7543 Percentiles: P50: 1.75 P75: 2.43 P99: 9.06 P99.9: 243.71 P99.99: 1119.61 ------------------------------------------------------ [ 0, 1 ] 12170 4.469% 4.469% # ( 1, 2 ] 165761 60.876% 65.345% ############ ( 2, 3 ] 61751 22.678% 88.023% ##### ( 3, 4 ] 13984 5.136% 93.159% # ( 4, 6 ] 11994 4.405% 97.563% # ( 6, 10 ] 5120 1.880% 99.444% ( 10, 15 ] 632 0.232% 99.676% ( 15, 22 ] 61 0.022% 99.698% ( 22, 34 ] 13 0.005% 99.703% ( 34, 51 ] 4 0.001% 99.704% ( 51, 76 ] 1 0.000% 99.705% ( 76, 110 ] 177 0.065% 99.770% ( 110, 170 ] 234 0.086% 99.856% ( 170, 250 ] 131 0.048% 99.904% ( 250, 380 ] 103 0.038% 99.942% ( 380, 580 ] 73 0.027% 99.968% ( 580, 870 ] 46 0.017% 99.985% ( 870, 1300 ] 22 0.008% 99.993% ( 1300, 1900 ] 12 0.004% 99.998% ( 1900, 2900 ] 11 0.004% 100.002% ( 2900, 4400 ] 10 0.004% 100.006% ( 4400, 6600 ] 10 0.004% 100.009% ( 6600, 9900 ] 3 0.001% 100.010% ** Level 4 read latency histogram (micros): Count: 60 Average: 1658.6833 StdDev: 2074.44 Min: 1 Median: 380.0000 Max: 8024 Percentiles: P50: 380.00 P75: 3309.09 P99: 7920.00 P99.9: 8024.00 P99.99: 8024.00 ------------------------------------------------------ [ 0, 1 ] 7 11.667% 11.667% ## ( 1, 2 ] 11 18.333% 30.000% #### ( 22, 34 ] 2 3.333% 33.333% # ( 76, 110 ] 6 10.000% 43.333% ## ( 110, 170 ] 1 1.667% 45.000% ( 250, 380 ] 3 5.000% 50.000% # ( 380, 580 ] 2 3.333% 53.333% # ( 580, 870 ] 2 3.333% 56.667% # ( 870, 1300 ] 3 5.000% 61.667% # ( 1300, 1900 ] 2 3.333% 65.000% # ( 1900, 2900 ] 3 5.000% 70.000% # ( 2900, 4400 ] 11 18.333% 88.333% #### ( 4400, 6600 ] 6 10.000% 98.333% ## ( 6600, 9900 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 15.4 total, 3.2 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 320.01 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.371 H:M:S, 15.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 308.05 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.585 H:M:S, 18.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 20000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 19378.7 MB (estimated) FileSize: 19378.7 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 3.414 micros/op 292892 ops/sec 20.001 seconds 5857999 operations; 283.8 MB/s Microseconds per write: Count: 5857999 Average: 3.4142 StdDev: 258.34 Min: 0 Median: 1.6995 Max: 222944 Percentiles: P50: 1.70 P75: 2.59 P99: 6.85 P99.9: 94.18 P99.99: 1256.57 ------------------------------------------------------ [ 0, 1 ] 892418 15.234% 15.234% ### ( 1, 2 ] 2911422 49.700% 64.934% ########## ( 2, 3 ] 997219 17.023% 81.957% ### ( 3, 4 ] 746872 12.750% 94.707% ### ( 4, 6 ] 242283 4.136% 98.843% # ( 6, 10 ] 43339 0.740% 99.583% ( 10, 15 ] 11604 0.198% 99.781% ( 15, 22 ] 3737 0.064% 99.845% ( 22, 34 ] 749 0.013% 99.857% ( 34, 51 ] 82 0.001% 99.859% ( 51, 76 ] 13 0.000% 99.859% ( 76, 110 ] 4495 0.077% 99.936% ( 110, 170 ] 1251 0.021% 99.957% ( 170, 250 ] 165 0.003% 99.960% ( 250, 380 ] 31 0.001% 99.960% ( 380, 580 ] 3 0.000% 99.960% ( 580, 870 ] 5 0.000% 99.961% ( 870, 1300 ] 1919 0.033% 99.993% ( 1300, 1900 ] 1 0.000% 99.993% ( 1900, 2900 ] 376 0.006% 100.000% ( 2900, 4400 ] 1 0.000% 100.000% ( 6600, 9900 ] 1 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 8 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 : 189430 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 : 5857999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 6045454968 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 : 162 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 4764848 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 : 10124575242 rocksdb.compact.write.bytes COUNT : 9938447741 rocksdb.flush.write.bytes COUNT : 5935274937 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 : 5897187328 rocksdb.memtable.garbage.bytes.at.flush COUNT : 11259904 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 : 10168165056 rocksdb.non.last.level.read.count COUNT : 2455510 rocksdb.block.checksum.compute.count COUNT : 2455196 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.323386 P95 : 3.705618 P99 : 5.806556 P100 : 222942.000000 COUNT : 5857999 SUM : 17372420 rocksdb.compaction.times.micros P50 : 1008750.000000 P95 : 3880000.000000 P99 : 5620894.000000 P100 : 5620894.000000 COUNT : 26 SUM : 31261627 rocksdb.compaction.times.cpu_micros P50 : 980000.000000 P95 : 3880000.000000 P99 : 5325045.000000 P100 : 5325045.000000 COUNT : 26 SUM : 29930616 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 : 746.750000 P95 : 1270.616667 P99 : 1451.000000 P100 : 1451.000000 COUNT : 81 SUM : 63039 rocksdb.compaction.outfile.sync.micros P50 : 855.128205 P95 : 1675.000000 P99 : 3200.000000 P100 : 3854.000000 COUNT : 80 SUM : 74627 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 : 90.733333 P95 : 224.181818 P99 : 365.700000 P100 : 888.000000 COUNT : 111 SUM : 12120 rocksdb.table.open.io.micros P50 : 1450.000000 P95 : 16600.000000 P99 : 20871.000000 P100 : 20871.000000 COUNT : 162 SUM : 477113 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.691189 P95 : 6.993446 P99 : 9.997244 P100 : 4038.000000 COUNT : 2454910 SUM : 12238444 rocksdb.read.block.get.micros P50 : 500.000000 P95 : 4535.384615 P99 : 7227.000000 P100 : 8283.000000 COUNT : 324 SUM : 343005 rocksdb.write.raw.block.micros P50 : 0.511028 P95 : 0.970954 P99 : 2.692537 P100 : 6285.000000 COUNT : 3848064 SUM : 7100210 rocksdb.numfiles.in.singlecompaction P50 : 3.366667 P95 : 9.266667 P99 : 19.000000 P100 : 19.000000 COUNT : 31 SUM : 136 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.560366 P95 : 1144.416146 P99 : 2360.265957 P100 : 222726.000000 COUNT : 21694 SUM : 4767159 rocksdb.sst.read.micros P50 : 1.627959 P95 : 3.924445 P99 : 7.942738 P100 : 8024.000000 COUNT : 2455851 SUM : 7412939 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 : 5857999 SUM : 6045454968 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 : 203962.264151 P95 : 327350.000000 P99 : 366706.000000 P100 : 366706.000000 COUNT : 81 SUM : 16139463 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 : 113 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