[2024-08-14 00:12:13.859205] Starting SPDK v24.09-pre git sha1 d47670264 / DPDK 22.11.4 initialization... [2024-08-14 00:12:13.859358] [ 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_pid1959760 ] Set seed to 1723587133855579 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-08-14 00:12:13.947575] app.c: 910:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-08-14 00:12:13.985276] app.c: 604:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-08-14 00:12:13.985320] app.c: 605:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1959760' to capture a snapshot of events at runtime. [2024-08-14 00:12:13.985331] app.c: 610:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-08-14 00:12:13.985341] app.c: 611:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-08-14 00:12:13.985350] app.c: 612:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1959760 for offline analysis/debug. [2024-08-14 00:12:13.985430] reactor.c: 941:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Wed Aug 14 00:12:18 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/08/14-00:12:21 ... thread 0: (1000000,1000000) ops and (358778.4,358778.4) ops/second in (2.787236,2.787236) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/6 504.01 MB 12.6 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 352.9 2.32 2.09 12 0.193 0 0 0.0 0.0 L1 1/0 2.16 MB 0.2 0.2 0.2 0.1 0.2 0.2 0.1 1.3 250.0 249.8 1.01 0.98 1 1.008 255K 209 0.0 0.0 L2 3/2 298.45 MB 1.2 0.1 0.1 0.0 0.1 0.1 0.3 1.8 232.3 232.2 0.48 0.45 1 0.479 113K 43 0.0 0.0 L3 18/11 881.36 MB 0.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 190.0 190.0 0.33 0.27 1 0.329 63K 0 0.0 0.0 L4 116/0 9.54 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 1032/0 85.75 GB 0.9 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 1178/19 96.94 GB 0.0 0.4 0.3 0.1 1.2 1.1 0.4 1.5 102.9 300.8 4.14 3.80 15 0.276 432K 252 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.2 1.1 0.4 1.5 102.9 300.8 4.14 3.80 15 0.276 432K 252 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.3 0.1 0.4 0.3 0.0 0.0 234.5 234.3 1.82 1.71 3 0.605 432K 252 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 352.9 2.32 2.09 12 0.193 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.8 interval Flush(GB): cumulative 0.800, interval 0.800 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.22 GB write, 411.34 MB/s write, 0.42 GB read, 140.72 MB/s read, 4.1 seconds Interval compaction: 1.22 GB write, 446.30 MB/s write, 0.42 GB read, 152.68 MB/s read, 4.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: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 112066 Average: 1.8596 StdDev: 18.01 Min: 0 Median: 1.1596 Max: 3430 Percentiles: P50: 1.16 P75: 1.63 P99: 4.12 P99.9: 9.94 P99.99: 296.63 ------------------------------------------------------ [ 0, 1 ] 46577 41.562% 41.562% ######## ( 1, 2 ] 59271 52.889% 94.451% ########### ( 2, 3 ] 3550 3.168% 97.619% # ( 3, 4 ] 1511 1.348% 98.968% ( 4, 6 ] 679 0.606% 99.573% ( 6, 10 ] 375 0.335% 99.908% ( 10, 15 ] 62 0.055% 99.963% ( 15, 22 ] 16 0.014% 99.978% ( 22, 34 ] 3 0.003% 99.980% ( 51, 76 ] 2 0.002% 99.982% ( 110, 170 ] 6 0.005% 99.988% ( 170, 250 ] 4 0.004% 99.991% ( 250, 380 ] 5 0.004% 99.996% ( 580, 870 ] 4 0.004% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ( 1900, 2900 ] 3 0.003% 100.003% ( 2900, 4400 ] 1 0.001% 100.004% ** Level 1 read latency histogram (micros): Count: 16127 Average: 3.0009 StdDev: 28.67 Min: 0 Median: 1.3497 Max: 1725 Percentiles: P50: 1.35 P75: 1.80 P99: 8.60 P99.9: 290.58 P99.99: 1577.46 ------------------------------------------------------ [ 0, 1 ] 4909 30.440% 30.440% ###### ( 1, 2 ] 9020 55.931% 86.371% ########### ( 2, 3 ] 1330 8.247% 94.618% ## ( 3, 4 ] 294 1.823% 96.441% ( 4, 6 ] 313 1.941% 98.382% ( 6, 10 ] 155 0.961% 99.343% ( 10, 15 ] 24 0.149% 99.492% ( 15, 22 ] 9 0.056% 99.547% ( 34, 51 ] 15 0.093% 99.640% ( 51, 76 ] 28 0.174% 99.814% ( 76, 110 ] 5 0.031% 99.845% ( 110, 170 ] 4 0.025% 99.870% ( 170, 250 ] 4 0.025% 99.895% ( 250, 380 ] 6 0.037% 99.932% ( 380, 580 ] 5 0.031% 99.963% ( 580, 870 ] 2 0.012% 99.975% ( 870, 1300 ] 2 0.012% 99.988% ( 1300, 1900 ] 3 0.019% 100.006% ** Level 2 read latency histogram (micros): Count: 15861 Average: 1.8445 StdDev: 3.53 Min: 1 Median: 1.1933 Max: 259 Percentiles: P50: 1.19 P75: 1.70 P99: 5.60 P99.9: 10.97 P99.99: 259.00 ------------------------------------------------------ [ 0, 1 ] 6423 40.496% 40.496% ######## ( 1, 2 ] 7797 49.158% 89.654% ########## ( 2, 3 ] 945 5.958% 95.612% # ( 3, 4 ] 366 2.308% 97.919% ( 4, 6 ] 214 1.349% 99.269% ( 6, 10 ] 98 0.618% 99.887% ( 10, 15 ] 11 0.069% 99.956% ( 15, 22 ] 2 0.013% 99.968% ( 51, 76 ] 1 0.006% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 1 0.006% 99.987% ( 250, 380 ] 2 0.013% 100.000% ** Level 3 read latency histogram (micros): Count: 7253 Average: 14.0742 StdDev: 152.78 Min: 1 Median: 1.6087 Max: 4668 Percentiles: P50: 1.61 P75: 2.06 P99: 182.35 P99.9: 2368.38 P99.99: 3582.41 ------------------------------------------------------ [ 0, 1 ] 907 12.505% 12.505% ### ( 1, 2 ] 4468 61.602% 74.107% ############ ( 2, 3 ] 1009 13.911% 88.019% ### ( 3, 4 ] 325 4.481% 92.500% # ( 4, 6 ] 279 3.847% 96.346% # ( 6, 10 ] 119 1.641% 97.987% ( 10, 15 ] 26 0.358% 98.346% ( 15, 22 ] 5 0.069% 98.414% ( 22, 34 ] 2 0.028% 98.442% ( 51, 76 ] 1 0.014% 98.456% ( 110, 170 ] 38 0.524% 98.980% ( 170, 250 ] 16 0.221% 99.200% ( 250, 380 ] 15 0.207% 99.407% ( 380, 580 ] 10 0.138% 99.545% ( 580, 870 ] 10 0.138% 99.683% ( 870, 1300 ] 5 0.069% 99.752% ( 1300, 1900 ] 8 0.110% 99.862% ( 1900, 2900 ] 8 0.110% 99.972% ( 2900, 4400 ] 5 0.069% 100.041% ( 4400, 6600 ] 1 0.014% 100.055% ** Level 4 read latency histogram (micros): Count: 25 Average: 1471.0400 StdDev: 1416.27 Min: 147 Median: 821.6667 Max: 5322 Percentiles: P50: 821.67 P75: 2337.50 P99: 5322.00 P99.9: 5322.00 P99.99: 5322.00 ------------------------------------------------------ ( 110, 170 ] 2 8.000% 8.000% ## ( 170, 250 ] 2 8.000% 16.000% ## ( 250, 380 ] 2 8.000% 24.000% ## ( 380, 580 ] 4 16.000% 40.000% ### ( 580, 870 ] 3 12.000% 52.000% ## ( 870, 1300 ] 2 8.000% 60.000% ## ( 1300, 1900 ] 2 8.000% 68.000% ## ( 1900, 2900 ] 4 16.000% 84.000% ### ( 2900, 4400 ] 3 12.000% 96.000% ## ( 4400, 6600 ] 1 4.000% 100.000% # ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 325.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.210 H:M:S, 6.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 352.83 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.210 H:M:S, 7.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/08/14-00:12:24 ... thread 0: (1000000,2000000) ops and (325025.4,341068.8) ops/second in (3.076683,5.863919) 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.48 GB 94.4 0.9 0.0 0.9 2.7 1.8 0.0 1.5 106.6 312.7 8.86 8.21 29 0.306 959K 1315 0.0 0.0 L1 1/0 2.16 MB 0.2 0.2 0.2 0.1 0.2 0.2 0.1 1.3 250.0 249.8 1.01 0.98 1 1.008 255K 209 0.0 0.0 L2 2/1 169.69 MB 1.2 0.1 0.1 0.0 0.1 0.1 0.3 1.8 232.3 232.2 0.48 0.45 1 0.479 113K 43 0.0 0.0 L3 74/10 1010.06 MB 0.2 0.2 0.2 0.1 0.2 0.2 0.0 1.3 148.7 148.7 1.66 1.22 2 0.832 251K 97 0.0 0.0 L4 116/0 9.54 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 1032/0 85.75 GB 0.9 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 1236/19 97.92 GB 0.0 1.5 0.4 1.1 3.3 2.2 0.4 1.9 129.5 281.5 12.01 10.87 33 0.364 1579K 1664 0.0 0.0 Int 0/0 0.00 KB 0.0 1.5 0.4 1.1 3.3 2.2 0.4 1.9 129.5 281.5 12.01 10.87 33 0.364 1579K 1664 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.5 0.4 1.1 1.5 0.4 0.0 0.0 228.3 228.0 6.82 6.23 7 0.974 1579K 1664 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.6 5.20 4.63 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): 6.1 total, 5.9 interval Flush(GB): cumulative 1.784, interval 1.784 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.30 GB write, 554.06 MB/s write, 1.52 GB read, 254.94 MB/s read, 12.0 seconds Interval compaction: 3.30 GB write, 576.45 MB/s write, 1.52 GB read, 265.24 MB/s read, 12.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 381508 Average: 2.1580 StdDev: 11.82 Min: 0 Median: 1.4561 Max: 3430 Percentiles: P50: 1.46 P75: 1.85 P99: 5.59 P99.9: 10.86 P99.99: 18.81 ------------------------------------------------------ [ 0, 1 ] 81223 21.290% 21.290% #### ( 1, 2 ] 240148 62.947% 84.237% ############# ( 2, 3 ] 35606 9.333% 93.570% ## ( 3, 4 ] 14416 3.779% 97.349% # ( 4, 6 ] 7929 2.078% 99.427% ( 6, 10 ] 1741 0.456% 99.883% ( 10, 15 ] 387 0.101% 99.985% ( 15, 22 ] 42 0.011% 99.996% ( 22, 34 ] 4 0.001% 99.997% ( 34, 51 ] 5 0.001% 99.998% ( 51, 76 ] 5 0.001% 99.999% ( 110, 170 ] 8 0.002% 100.002% ( 170, 250 ] 15 0.004% 100.006% ( 250, 380 ] 12 0.003% 100.009% ( 380, 580 ] 5 0.001% 100.010% ( 580, 870 ] 9 0.002% 100.012% ( 870, 1300 ] 2 0.001% 100.013% ( 1300, 1900 ] 3 0.001% 100.014% ( 1900, 2900 ] 4 0.001% 100.015% ( 2900, 4400 ] 1 0.000% 100.015% ** Level 1 read latency histogram (micros): Count: 44979 Average: 2.7371 StdDev: 17.19 Min: 0 Median: 1.6234 Max: 1725 Percentiles: P50: 1.62 P75: 2.18 P99: 7.27 P99.9: 63.52 P99.99: 977.95 ------------------------------------------------------ [ 0, 1 ] 6218 13.824% 13.824% ### ( 1, 2 ] 26101 58.029% 71.854% ############ ( 2, 3 ] 7692 17.101% 88.955% ### ( 3, 4 ] 2253 5.009% 93.964% # ( 4, 6 ] 2135 4.747% 98.711% # ( 6, 10 ] 409 0.909% 99.620% ( 10, 15 ] 82 0.182% 99.802% ( 15, 22 ] 15 0.033% 99.835% ( 34, 51 ] 15 0.033% 99.869% ( 51, 76 ] 28 0.062% 99.931% ( 76, 110 ] 5 0.011% 99.942% ( 110, 170 ] 4 0.009% 99.951% ( 170, 250 ] 4 0.009% 99.960% ( 250, 380 ] 6 0.013% 99.973% ( 380, 580 ] 5 0.011% 99.984% ( 580, 870 ] 2 0.004% 99.989% ( 870, 1300 ] 2 0.004% 99.993% ( 1300, 1900 ] 3 0.007% 100.000% ** Level 2 read latency histogram (micros): Count: 15985 Average: 1.8522 StdDev: 3.52 Min: 1 Median: 1.2002 Max: 259 Percentiles: P50: 1.20 P75: 1.71 P99: 5.60 P99.9: 10.92 P99.99: 259.00 ------------------------------------------------------ [ 0, 1 ] 6423 40.181% 40.181% ######## ( 1, 2 ] 7840 49.046% 89.227% ########## ( 2, 3 ] 1013 6.337% 95.565% # ( 3, 4 ] 371 2.321% 97.886% ( 4, 6 ] 222 1.389% 99.274% ( 6, 10 ] 98 0.613% 99.887% ( 10, 15 ] 11 0.069% 99.956% ( 15, 22 ] 2 0.013% 99.969% ( 51, 76 ] 1 0.006% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 1 0.006% 99.987% ( 250, 380 ] 2 0.013% 100.000% ** Level 3 read latency histogram (micros): Count: 211081 Average: 3.4025 StdDev: 33.37 Min: 1 Median: 1.5943 Max: 4668 Percentiles: P50: 1.59 P75: 1.99 P99: 8.90 P99.9: 219.75 P99.99: 732.18 ------------------------------------------------------ [ 0, 1 ] 26685 12.642% 12.642% ### ( 1, 2 ] 132692 62.863% 75.505% ############# ( 2, 3 ] 30388 14.396% 89.902% ### ( 3, 4 ] 9213 4.365% 94.266% # ( 4, 6 ] 7417 3.514% 97.780% # ( 6, 10 ] 3556 1.685% 99.465% ( 10, 15 ] 298 0.141% 99.606% ( 15, 22 ] 85 0.040% 99.646% ( 22, 34 ] 38 0.018% 99.664% ( 34, 51 ] 5 0.002% 99.666% ( 51, 76 ] 9 0.004% 99.671% ( 76, 110 ] 124 0.059% 99.729% ( 110, 170 ] 294 0.139% 99.869% ( 170, 250 ] 106 0.050% 99.919% ( 250, 380 ] 72 0.034% 99.953% ( 380, 580 ] 59 0.028% 99.981% ( 580, 870 ] 36 0.017% 99.998% ( 870, 1300 ] 14 0.007% 100.005% ( 1300, 1900 ] 10 0.005% 100.009% ( 1900, 2900 ] 10 0.005% 100.014% ( 2900, 4400 ] 5 0.002% 100.017% ( 4400, 6600 ] 1 0.000% 100.017% ** Level 4 read latency histogram (micros): Count: 25 Average: 1471.0400 StdDev: 1416.27 Min: 147 Median: 821.6667 Max: 5322 Percentiles: P50: 821.67 P75: 2337.50 P99: 5322.00 P99.9: 5322.00 P99.99: 5322.00 ------------------------------------------------------ ( 110, 170 ] 2 8.000% 8.000% ## ( 170, 250 ] 2 8.000% 16.000% ## ( 250, 380 ] 2 8.000% 24.000% ## ( 380, 580 ] 4 16.000% 40.000% ### ( 580, 870 ] 3 12.000% 52.000% ## ( 870, 1300 ] 2 8.000% 60.000% ## ( 1300, 1900 ] 2 8.000% 68.000% ## ( 1900, 2900 ] 4 16.000% 84.000% ### ( 2900, 4400 ] 3 12.000% 96.000% ## ( 4400, 6600 ] 1 4.000% 100.000% # ** DB Stats ** Uptime(secs): 6.1 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 322.56 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.559 H:M:S, 9.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.89 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.349 H:M:S, 11.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/08/14-00:12:27 ... thread 0: (1000000,3000000) ops and (331125.5,337688.7) ops/second in (3.020003,8.883922) 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 13/4 2.46 GB 220.2 2.0 0.0 2.0 4.8 2.8 0.0 1.7 130.2 307.5 15.97 14.92 47 0.340 2110K 2518 0.0 0.0 L1 1/0 2.16 MB 0.2 0.2 0.2 0.1 0.2 0.2 0.1 1.3 250.0 249.8 1.01 0.98 1 1.008 255K 209 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.3 1.8 232.3 232.2 0.48 0.45 1 0.479 113K 43 0.0 0.0 L3 20/0 898.54 MB 0.9 1.3 0.4 0.9 1.3 0.4 0.0 3.7 215.1 215.0 6.20 5.41 4 1.549 1327K 636 0.0 0.0 L4 169/0 9.50 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.2 1.0 157.6 157.7 0.77 0.60 1 0.772 123K 0 0.0 0.0 L5 1036/0 86.06 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1239/4 98.90 GB 0.0 3.8 0.7 3.1 6.6 3.5 0.9 2.4 159.5 275.4 24.43 22.36 54 0.452 3930K 3406 0.0 0.0 Int 0/0 0.00 KB 0.0 3.8 0.7 3.1 6.6 3.5 0.8 2.4 159.5 275.4 24.43 22.36 54 0.452 3930K 3406 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.8 0.7 3.1 3.8 0.7 0.0 0.0 236.9 236.7 16.45 15.25 14 1.175 3930K 3406 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 355.3 7.98 7.11 40 0.199 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): 9.1 total, 8.9 interval Flush(GB): cumulative 2.768, interval 2.768 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.57 GB write, 737.55 MB/s write, 3.81 GB read, 427.17 MB/s read, 24.4 seconds Interval compaction: 6.57 GB write, 757.22 MB/s write, 3.81 GB read, 438.57 MB/s read, 24.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: 637169 Average: 2.1354 StdDev: 10.97 Min: 0 Median: 1.4487 Max: 3430 Percentiles: P50: 1.45 P75: 1.84 P99: 5.54 P99.9: 11.30 P99.99: 18.53 ------------------------------------------------------ [ 0, 1 ] 136651 21.447% 21.447% #### ( 1, 2 ] 405502 63.641% 85.088% ############# ( 2, 3 ] 56540 8.874% 93.961% ## ( 3, 4 ] 22763 3.573% 97.534% # ( 4, 6 ] 12119 1.902% 99.436% ( 6, 10 ] 2770 0.435% 99.871% ( 10, 15 ] 725 0.114% 99.984% ( 15, 22 ] 72 0.011% 99.996% ( 22, 34 ] 10 0.002% 99.997% ( 34, 51 ] 5 0.001% 99.998% ( 51, 76 ] 7 0.001% 99.999% ( 110, 170 ] 13 0.002% 100.001% ( 170, 250 ] 21 0.003% 100.005% ( 250, 380 ] 19 0.003% 100.008% ( 380, 580 ] 9 0.001% 100.009% ( 580, 870 ] 17 0.003% 100.012% ( 870, 1300 ] 6 0.001% 100.013% ( 1300, 1900 ] 4 0.001% 100.013% ( 1900, 2900 ] 4 0.001% 100.014% ( 2900, 4400 ] 2 0.000% 100.014% ** Level 1 read latency histogram (micros): Count: 75656 Average: 2.4948 StdDev: 13.27 Min: 0 Median: 1.5849 Max: 1725 Percentiles: P50: 1.58 P75: 1.98 P99: 5.95 P99.9: 24.06 P99.99: 557.38 ------------------------------------------------------ [ 0, 1 ] 9885 13.066% 13.066% ### ( 1, 2 ] 47773 63.145% 76.211% ############# ( 2, 3 ] 11540 15.253% 91.464% ### ( 3, 4 ] 3145 4.157% 95.621% # ( 4, 6 ] 2620 3.463% 99.084% # ( 6, 10 ] 500 0.661% 99.745% ( 10, 15 ] 100 0.132% 99.877% ( 15, 22 ] 17 0.022% 99.900% ( 22, 34 ] 2 0.003% 99.902% ( 34, 51 ] 15 0.020% 99.922% ( 51, 76 ] 28 0.037% 99.959% ( 76, 110 ] 5 0.007% 99.966% ( 110, 170 ] 4 0.005% 99.971% ( 170, 250 ] 4 0.005% 99.976% ( 250, 380 ] 6 0.008% 99.984% ( 380, 580 ] 5 0.007% 99.991% ( 580, 870 ] 2 0.003% 99.993% ( 870, 1300 ] 2 0.003% 99.996% ( 1300, 1900 ] 3 0.004% 100.000% ** Level 2 read latency histogram (micros): Count: 28262 Average: 2.0094 StdDev: 2.72 Min: 1 Median: 1.3857 Max: 259 Percentiles: P50: 1.39 P75: 1.82 P99: 5.57 P99.9: 9.85 P99.99: 183.90 ------------------------------------------------------ [ 0, 1 ] 7823 27.680% 27.680% ###### ( 1, 2 ] 16356 57.873% 85.553% ############ ( 2, 3 ] 2300 8.138% 93.691% ## ( 3, 4 ] 1048 3.708% 97.399% # ( 4, 6 ] 576 2.038% 99.437% ( 6, 10 ] 136 0.481% 99.919% ( 10, 15 ] 15 0.053% 99.972% ( 15, 22 ] 3 0.011% 99.982% ( 51, 76 ] 1 0.004% 99.986% ( 110, 170 ] 1 0.004% 99.989% ( 170, 250 ] 1 0.004% 99.993% ( 250, 380 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 278151 Average: 3.1841 StdDev: 29.52 Min: 0 Median: 1.5987 Max: 4668 Percentiles: P50: 1.60 P75: 1.99 P99: 8.55 P99.9: 189.23 P99.99: 719.37 ------------------------------------------------------ [ 0, 1 ] 33426 12.017% 12.017% ## ( 1, 2 ] 176463 63.441% 75.459% ############# ( 2, 3 ] 41239 14.826% 90.285% ### ( 3, 4 ] 12203 4.387% 94.672% # ( 4, 6 ] 9411 3.383% 98.055% # ( 6, 10 ] 4128 1.484% 99.539% ( 10, 15 ] 406 0.146% 99.685% ( 15, 22 ] 97 0.035% 99.720% ( 22, 34 ] 38 0.014% 99.734% ( 34, 51 ] 5 0.002% 99.736% ( 51, 76 ] 9 0.003% 99.739% ( 76, 110 ] 125 0.045% 99.784% ( 110, 170 ] 294 0.106% 99.890% ( 170, 250 ] 120 0.043% 99.933% ( 250, 380 ] 77 0.028% 99.960% ( 380, 580 ] 62 0.022% 99.983% ( 580, 870 ] 42 0.015% 99.998% ( 870, 1300 ] 16 0.006% 100.004% ( 1300, 1900 ] 10 0.004% 100.007% ( 1900, 2900 ] 10 0.004% 100.011% ( 2900, 4400 ] 5 0.002% 100.013% ( 4400, 6600 ] 1 0.000% 100.013% ** Level 4 read latency histogram (micros): Count: 150 Average: 254.8467 StdDev: 795.20 Min: 0 Median: 1.7368 Max: 5322 Percentiles: P50: 1.74 P75: 16.59 P99: 4150.00 P99.9: 5322.00 P99.99: 5322.00 ------------------------------------------------------ [ 0, 1 ] 47 31.333% 31.333% ###### ( 1, 2 ] 38 25.333% 56.667% ##### ( 2, 3 ] 4 2.667% 59.333% # ( 3, 4 ] 6 4.000% 63.333% # ( 4, 6 ] 2 1.333% 64.667% ( 6, 10 ] 1 0.667% 65.333% ( 10, 15 ] 12 8.000% 73.333% ## ( 15, 22 ] 11 7.333% 80.667% # ( 51, 76 ] 1 0.667% 81.333% ( 110, 170 ] 4 2.667% 84.000% # ( 170, 250 ] 2 1.333% 85.333% ( 250, 380 ] 2 1.333% 86.667% ( 380, 580 ] 5 3.333% 90.000% # ( 580, 870 ] 3 2.000% 92.000% ( 870, 1300 ] 2 1.333% 93.333% ( 1300, 1900 ] 2 1.333% 94.667% ( 1900, 2900 ] 4 2.667% 97.333% # ( 2900, 4400 ] 3 2.000% 99.333% ( 4400, 6600 ] 1 0.667% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 662.7500 StdDev: 805.05 Min: 73 Median: 315.0000 Max: 2897 Percentiles: P50: 315.00 P75: 773.33 P99: 2850.00 P99.9: 2895.00 P99.99: 2897.00 ------------------------------------------------------ ( 51, 76 ] 2 10.000% 10.000% ## ( 76, 110 ] 2 10.000% 20.000% ## ( 110, 170 ] 4 20.000% 40.000% #### ( 250, 380 ] 4 20.000% 60.000% #### ( 380, 580 ] 1 5.000% 65.000% # ( 580, 870 ] 3 15.000% 80.000% ### ( 1900, 2900 ] 4 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 9.1 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 323.66 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.917 H:M:S, 10.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 325.89 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.358 H:M:S, 11.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/08/14-00:12:30 ... thread 0: (1000000,4000000) ops and (331623.6,336151.7) ops/second in (3.015467,11.899389) 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/14 3.44 GB 6.3 3.1 0.0 3.1 6.9 3.7 0.0 1.8 139.6 306.5 23.01 21.58 65 0.354 3262K 3846 0.0 0.0 L1 1/1 2.16 MB 0.0 0.2 0.2 0.1 0.2 0.2 0.1 1.3 250.0 249.8 1.01 0.98 1 1.008 255K 209 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.3 1.8 232.3 232.2 0.48 0.45 1 0.479 113K 43 0.0 0.0 L3 20/0 898.54 MB 0.9 1.3 0.4 0.9 1.3 0.4 0.0 3.7 215.1 215.0 6.20 5.41 4 1.549 1327K 636 0.0 0.0 L4 169/0 9.50 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.2 1.0 157.6 157.7 0.77 0.60 1 0.772 123K 0 0.0 0.0 L5 1036/0 86.06 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1241/15 99.88 GB 0.0 4.9 0.7 4.2 8.7 4.5 0.9 2.3 159.9 281.9 31.46 29.02 72 0.437 5081K 4734 0.0 0.0 Int 0/0 0.00 KB 0.0 4.9 0.7 4.2 8.7 4.5 0.8 2.3 159.9 281.9 31.46 29.02 72 0.437 5081K 4734 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.9 0.7 4.2 4.9 0.7 0.0 0.0 243.1 242.9 20.69 19.40 18 1.150 5081K 4734 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 356.8 10.77 9.62 54 0.199 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, 11.9 interval Flush(GB): cumulative 3.753, interval 3.753 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.66 GB write, 730.66 MB/s write, 4.91 GB read, 414.47 MB/s read, 31.5 seconds Interval compaction: 8.66 GB write, 745.21 MB/s write, 4.91 GB read, 422.72 MB/s read, 31.5 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: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 16, interval: 16 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 896600 Average: 2.1049 StdDev: 10.85 Min: 0 Median: 1.4098 Max: 3430 Percentiles: P50: 1.41 P75: 1.81 P99: 5.40 P99.9: 12.03 P99.99: 144.39 ------------------------------------------------------ [ 0, 1 ] 217129 24.217% 24.217% ##### ( 1, 2 ] 564141 62.920% 87.137% ############# ( 2, 3 ] 68929 7.688% 94.825% ## ( 3, 4 ] 27560 3.074% 97.899% # ( 4, 6 ] 14092 1.572% 99.470% ( 6, 10 ] 3470 0.387% 99.857% ( 10, 15 ] 940 0.105% 99.962% ( 15, 22 ] 97 0.011% 99.973% ( 22, 34 ] 16 0.002% 99.975% ( 34, 51 ] 5 0.001% 99.975% ( 51, 76 ] 9 0.001% 99.976% ( 76, 110 ] 57 0.006% 99.983% ( 110, 170 ] 114 0.013% 99.995% ( 170, 250 ] 45 0.005% 100.000% ( 250, 380 ] 37 0.004% 100.005% ( 380, 580 ] 21 0.002% 100.007% ( 580, 870 ] 24 0.003% 100.010% ( 870, 1300 ] 12 0.001% 100.011% ( 1300, 1900 ] 8 0.001% 100.012% ( 1900, 2900 ] 4 0.000% 100.012% ( 2900, 4400 ] 2 0.000% 100.012% ** Level 1 read latency histogram (micros): Count: 75657 Average: 2.5003 StdDev: 13.36 Min: 0 Median: 1.5849 Max: 1725 Percentiles: P50: 1.58 P75: 1.98 P99: 5.95 P99.9: 30.06 P99.99: 561.14 ------------------------------------------------------ [ 0, 1 ] 9885 13.066% 13.066% ### ( 1, 2 ] 47773 63.144% 76.210% ############# ( 2, 3 ] 11540 15.253% 91.463% ### ( 3, 4 ] 3145 4.157% 95.620% # ( 4, 6 ] 2620 3.463% 99.083% # ( 6, 10 ] 500 0.661% 99.744% ( 10, 15 ] 100 0.132% 99.876% ( 15, 22 ] 17 0.022% 99.898% ( 22, 34 ] 2 0.003% 99.901% ( 34, 51 ] 15 0.020% 99.921% ( 51, 76 ] 28 0.037% 99.958% ( 76, 110 ] 5 0.007% 99.964% ( 110, 170 ] 4 0.005% 99.970% ( 170, 250 ] 4 0.005% 99.975% ( 250, 380 ] 6 0.008% 99.983% ( 380, 580 ] 6 0.008% 99.991% ( 580, 870 ] 2 0.003% 99.993% ( 870, 1300 ] 2 0.003% 99.996% ( 1300, 1900 ] 3 0.004% 100.000% ** Level 2 read latency histogram (micros): Count: 28262 Average: 2.0094 StdDev: 2.72 Min: 1 Median: 1.3857 Max: 259 Percentiles: P50: 1.39 P75: 1.82 P99: 5.57 P99.9: 9.85 P99.99: 183.90 ------------------------------------------------------ [ 0, 1 ] 7823 27.680% 27.680% ###### ( 1, 2 ] 16356 57.873% 85.553% ############ ( 2, 3 ] 2300 8.138% 93.691% ## ( 3, 4 ] 1048 3.708% 97.399% # ( 4, 6 ] 576 2.038% 99.437% ( 6, 10 ] 136 0.481% 99.919% ( 10, 15 ] 15 0.053% 99.972% ( 15, 22 ] 3 0.011% 99.982% ( 51, 76 ] 1 0.004% 99.986% ( 110, 170 ] 1 0.004% 99.989% ( 170, 250 ] 1 0.004% 99.993% ( 250, 380 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 278151 Average: 3.1841 StdDev: 29.52 Min: 0 Median: 1.5987 Max: 4668 Percentiles: P50: 1.60 P75: 1.99 P99: 8.55 P99.9: 189.23 P99.99: 719.37 ------------------------------------------------------ [ 0, 1 ] 33426 12.017% 12.017% ## ( 1, 2 ] 176463 63.441% 75.459% ############# ( 2, 3 ] 41239 14.826% 90.285% ### ( 3, 4 ] 12203 4.387% 94.672% # ( 4, 6 ] 9411 3.383% 98.055% # ( 6, 10 ] 4128 1.484% 99.539% ( 10, 15 ] 406 0.146% 99.685% ( 15, 22 ] 97 0.035% 99.720% ( 22, 34 ] 38 0.014% 99.734% ( 34, 51 ] 5 0.002% 99.736% ( 51, 76 ] 9 0.003% 99.739% ( 76, 110 ] 125 0.045% 99.784% ( 110, 170 ] 294 0.106% 99.890% ( 170, 250 ] 120 0.043% 99.933% ( 250, 380 ] 77 0.028% 99.960% ( 380, 580 ] 62 0.022% 99.983% ( 580, 870 ] 42 0.015% 99.998% ( 870, 1300 ] 16 0.006% 100.004% ( 1300, 1900 ] 10 0.004% 100.007% ( 1900, 2900 ] 10 0.004% 100.011% ( 2900, 4400 ] 5 0.002% 100.013% ( 4400, 6600 ] 1 0.000% 100.013% ** Level 4 read latency histogram (micros): Count: 150 Average: 254.8467 StdDev: 795.20 Min: 0 Median: 1.7368 Max: 5322 Percentiles: P50: 1.74 P75: 16.59 P99: 4150.00 P99.9: 5322.00 P99.99: 5322.00 ------------------------------------------------------ [ 0, 1 ] 47 31.333% 31.333% ###### ( 1, 2 ] 38 25.333% 56.667% ##### ( 2, 3 ] 4 2.667% 59.333% # ( 3, 4 ] 6 4.000% 63.333% # ( 4, 6 ] 2 1.333% 64.667% ( 6, 10 ] 1 0.667% 65.333% ( 10, 15 ] 12 8.000% 73.333% ## ( 15, 22 ] 11 7.333% 80.667% # ( 51, 76 ] 1 0.667% 81.333% ( 110, 170 ] 4 2.667% 84.000% # ( 170, 250 ] 2 1.333% 85.333% ( 250, 380 ] 2 1.333% 86.667% ( 380, 580 ] 5 3.333% 90.000% # ( 580, 870 ] 3 2.000% 92.000% ( 870, 1300 ] 2 1.333% 93.333% ( 1300, 1900 ] 2 1.333% 94.667% ( 1900, 2900 ] 4 2.667% 97.333% # ( 2900, 4400 ] 3 2.000% 99.333% ( 4400, 6600 ] 1 0.667% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 662.7500 StdDev: 805.05 Min: 73 Median: 315.0000 Max: 2897 Percentiles: P50: 315.00 P75: 773.33 P99: 2850.00 P99.9: 2895.00 P99.99: 2897.00 ------------------------------------------------------ ( 51, 76 ] 2 10.000% 10.000% ## ( 76, 110 ] 2 10.000% 20.000% ## ( 110, 170 ] 4 20.000% 40.000% #### ( 250, 380 ] 4 20.000% 60.000% #### ( 380, 580 ] 1 5.000% 65.000% # ( 580, 870 ] 3 15.000% 80.000% ### ( 1900, 2900 ] 4 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 12.1 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 324.34 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.307 H:M:S, 10.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 326.38 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.390 H:M:S, 12.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/08/14-00:12:37 ... thread 0: (1000000,5000000) ops and (128647.8,254161.3) ops/second in (7.773160,19.672549) 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/14 4.42 GB 106.7 4.8 0.0 4.8 9.5 4.7 0.0 2.0 152.9 303.6 32.13 30.32 84 0.383 4988K 7569 0.0 0.0 L1 1/1 2.16 MB 0.0 0.2 0.2 0.1 0.2 0.2 0.1 1.3 250.0 249.8 1.01 0.98 1 1.008 255K 209 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.3 1.8 232.3 232.2 0.48 0.45 1 0.479 113K 43 0.0 0.0 L3 20/0 898.54 MB 0.9 1.3 0.4 0.9 1.3 0.4 0.0 3.7 215.1 215.0 6.20 5.41 4 1.549 1327K 636 0.0 0.0 L4 169/0 9.50 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.2 1.0 157.6 157.7 0.77 0.60 1 0.772 123K 0 0.0 0.0 L5 1036/0 86.06 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1244/15 100.87 GB 0.0 6.6 0.7 5.9 11.3 5.4 0.9 2.4 165.8 285.1 40.59 37.76 91 0.446 6808K 8457 0.0 0.0 Int 0/0 0.00 KB 0.0 6.6 0.7 5.9 11.3 5.4 0.8 2.4 165.8 285.1 40.59 37.76 91 0.446 6808K 8457 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.6 0.7 5.9 6.6 0.7 0.0 0.0 249.5 249.1 26.98 25.60 22 1.226 6808K 8457 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 356.4 13.61 12.16 69 0.197 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): 19.9 total, 19.7 interval Flush(GB): cumulative 4.737, interval 4.737 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.30 GB write, 581.23 MB/s write, 6.57 GB read, 338.04 MB/s read, 40.6 seconds Interval compaction: 11.30 GB write, 588.23 MB/s write, 6.57 GB read, 342.11 MB/s read, 40.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 8, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 8, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 8, total-stops: 17, interval: 25 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1785016 Average: 2.0922 StdDev: 9.41 Min: 0 Median: 1.4259 Max: 3430 Percentiles: P50: 1.43 P75: 1.81 P99: 5.36 P99.9: 11.01 P99.99: 80.37 ------------------------------------------------------ [ 0, 1 ] 395264 22.143% 22.143% #### ( 1, 2 ] 1167466 65.404% 87.547% ############# ( 2, 3 ] 136988 7.674% 95.221% ## ( 3, 4 ] 51203 2.868% 98.090% # ( 4, 6 ] 23905 1.339% 99.429% ( 6, 10 ] 8057 0.451% 99.881% ( 10, 15 ] 1737 0.097% 99.978% ( 15, 22 ] 160 0.009% 99.987% ( 22, 34 ] 20 0.001% 99.988% ( 34, 51 ] 11 0.001% 99.989% ( 51, 76 ] 11 0.001% 99.989% ( 76, 110 ] 136 0.008% 99.997% ( 110, 170 ] 199 0.011% 100.008% ( 170, 250 ] 76 0.004% 100.012% ( 250, 380 ] 63 0.004% 100.016% ( 380, 580 ] 32 0.002% 100.017% ( 580, 870 ] 40 0.002% 100.020% ( 870, 1300 ] 18 0.001% 100.021% ( 1300, 1900 ] 9 0.001% 100.021% ( 1900, 2900 ] 8 0.000% 100.022% ( 2900, 4400 ] 2 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 75657 Average: 2.5003 StdDev: 13.36 Min: 0 Median: 1.5849 Max: 1725 Percentiles: P50: 1.58 P75: 1.98 P99: 5.95 P99.9: 30.06 P99.99: 561.14 ------------------------------------------------------ [ 0, 1 ] 9885 13.066% 13.066% ### ( 1, 2 ] 47773 63.144% 76.210% ############# ( 2, 3 ] 11540 15.253% 91.463% ### ( 3, 4 ] 3145 4.157% 95.620% # ( 4, 6 ] 2620 3.463% 99.083% # ( 6, 10 ] 500 0.661% 99.744% ( 10, 15 ] 100 0.132% 99.876% ( 15, 22 ] 17 0.022% 99.898% ( 22, 34 ] 2 0.003% 99.901% ( 34, 51 ] 15 0.020% 99.921% ( 51, 76 ] 28 0.037% 99.958% ( 76, 110 ] 5 0.007% 99.964% ( 110, 170 ] 4 0.005% 99.970% ( 170, 250 ] 4 0.005% 99.975% ( 250, 380 ] 6 0.008% 99.983% ( 380, 580 ] 6 0.008% 99.991% ( 580, 870 ] 2 0.003% 99.993% ( 870, 1300 ] 2 0.003% 99.996% ( 1300, 1900 ] 3 0.004% 100.000% ** Level 2 read latency histogram (micros): Count: 28262 Average: 2.0094 StdDev: 2.72 Min: 1 Median: 1.3857 Max: 259 Percentiles: P50: 1.39 P75: 1.82 P99: 5.57 P99.9: 9.85 P99.99: 183.90 ------------------------------------------------------ [ 0, 1 ] 7823 27.680% 27.680% ###### ( 1, 2 ] 16356 57.873% 85.553% ############ ( 2, 3 ] 2300 8.138% 93.691% ## ( 3, 4 ] 1048 3.708% 97.399% # ( 4, 6 ] 576 2.038% 99.437% ( 6, 10 ] 136 0.481% 99.919% ( 10, 15 ] 15 0.053% 99.972% ( 15, 22 ] 3 0.011% 99.982% ( 51, 76 ] 1 0.004% 99.986% ( 110, 170 ] 1 0.004% 99.989% ( 170, 250 ] 1 0.004% 99.993% ( 250, 380 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 278151 Average: 3.1841 StdDev: 29.52 Min: 0 Median: 1.5987 Max: 4668 Percentiles: P50: 1.60 P75: 1.99 P99: 8.55 P99.9: 189.23 P99.99: 719.37 ------------------------------------------------------ [ 0, 1 ] 33426 12.017% 12.017% ## ( 1, 2 ] 176463 63.441% 75.459% ############# ( 2, 3 ] 41239 14.826% 90.285% ### ( 3, 4 ] 12203 4.387% 94.672% # ( 4, 6 ] 9411 3.383% 98.055% # ( 6, 10 ] 4128 1.484% 99.539% ( 10, 15 ] 406 0.146% 99.685% ( 15, 22 ] 97 0.035% 99.720% ( 22, 34 ] 38 0.014% 99.734% ( 34, 51 ] 5 0.002% 99.736% ( 51, 76 ] 9 0.003% 99.739% ( 76, 110 ] 125 0.045% 99.784% ( 110, 170 ] 294 0.106% 99.890% ( 170, 250 ] 120 0.043% 99.933% ( 250, 380 ] 77 0.028% 99.960% ( 380, 580 ] 62 0.022% 99.983% ( 580, 870 ] 42 0.015% 99.998% ( 870, 1300 ] 16 0.006% 100.004% ( 1300, 1900 ] 10 0.004% 100.007% ( 1900, 2900 ] 10 0.004% 100.011% ( 2900, 4400 ] 5 0.002% 100.013% ( 4400, 6600 ] 1 0.000% 100.013% ** Level 4 read latency histogram (micros): Count: 150 Average: 254.8467 StdDev: 795.20 Min: 0 Median: 1.7368 Max: 5322 Percentiles: P50: 1.74 P75: 16.59 P99: 4150.00 P99.9: 5322.00 P99.99: 5322.00 ------------------------------------------------------ [ 0, 1 ] 47 31.333% 31.333% ###### ( 1, 2 ] 38 25.333% 56.667% ##### ( 2, 3 ] 4 2.667% 59.333% # ( 3, 4 ] 6 4.000% 63.333% # ( 4, 6 ] 2 1.333% 64.667% ( 6, 10 ] 1 0.667% 65.333% ( 10, 15 ] 12 8.000% 73.333% ## ( 15, 22 ] 11 7.333% 80.667% # ( 51, 76 ] 1 0.667% 81.333% ( 110, 170 ] 4 2.667% 84.000% # ( 170, 250 ] 2 1.333% 85.333% ( 250, 380 ] 2 1.333% 86.667% ( 380, 580 ] 5 3.333% 90.000% # ( 580, 870 ] 3 2.000% 92.000% ( 870, 1300 ] 2 1.333% 93.333% ( 1300, 1900 ] 2 1.333% 94.667% ( 1900, 2900 ] 4 2.667% 97.333% # ( 2900, 4400 ] 3 2.000% 99.333% ( 4400, 6600 ] 1 0.667% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 662.7500 StdDev: 805.05 Min: 73 Median: 315.0000 Max: 2897 Percentiles: P50: 315.00 P75: 773.33 P99: 2850.00 P99.9: 2895.00 P99.99: 2897.00 ------------------------------------------------------ ( 51, 76 ] 2 10.000% 10.000% ## ( 76, 110 ] 2 10.000% 20.000% ## ( 110, 170 ] 4 20.000% 40.000% #### ( 250, 380 ] 4 20.000% 60.000% #### ( 380, 580 ] 1 5.000% 65.000% # ( 580, 870 ] 3 15.000% 80.000% ### ( 1900, 2900 ] 4 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 19.9 total, 7.8 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 247.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:6.199 H:M:S, 31.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 126.61 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:4.893 H:M:S, 62.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/08/14-00:12:46 ... thread 0: (1000000,6000000) ops and (116517.9,212352.4) ops/second in (8.582369,28.254918) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 7/4 1.96 GB 175.7 6.3 0.0 6.3 12.0 5.6 0.0 2.1 158.5 299.8 40.94 38.47 103 0.397 6586K 10K 0.0 0.0 L1 15/0 1.31 GB 134.6 3.6 3.6 0.1 3.6 3.5 0.1 1.0 217.7 214.4 17.06 15.92 2 8.532 3772K 56K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 2.3 1.8 232.3 232.2 0.48 0.45 1 0.479 113K 43 0.0 0.0 L3 23/9 2.11 GB 1.3 1.3 0.4 0.9 1.3 0.4 2.0 3.7 215.1 215.0 6.20 5.41 4 1.549 1327K 636 0.0 0.0 L4 182/58 10.29 GB 0.7 0.1 0.1 0.0 0.1 0.1 0.9 1.0 157.6 157.7 0.77 0.60 1 0.772 123K 0 0.0 0.0 L5 1036/0 86.06 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1263/71 101.73 GB 0.0 11.5 4.1 7.4 17.1 9.7 5.7 3.0 179.8 267.3 65.45 60.84 111 0.590 11M 68K 0.0 0.0 Int 0/0 0.00 KB 0.0 11.5 4.1 7.4 17.1 9.7 5.6 3.0 179.8 267.3 65.45 60.84 111 0.590 11M 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 11.5 4.1 7.4 11.4 4.0 0.0 0.0 239.5 238.1 49.14 46.31 27 1.820 11M 68K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 355.3 16.31 14.54 84 0.194 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 28.5 total, 28.3 interval Flush(GB): cumulative 5.660, interval 5.660 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: 17.08 GB write, 614.01 MB/s write, 11.49 GB read, 413.01 MB/s read, 65.4 seconds Interval compaction: 17.08 GB write, 619.16 MB/s write, 11.49 GB read, 416.47 MB/s read, 65.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 17, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 17, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 17, interval: 34 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2625970 Average: 2.5009 StdDev: 14.35 Min: 0 Median: 1.4342 Max: 3711 Percentiles: P50: 1.43 P75: 1.82 P99: 5.95 P99.9: 135.21 P99.99: 245.69 ------------------------------------------------------ [ 0, 1 ] 568819 21.661% 21.661% #### ( 1, 2 ] 1713761 65.262% 86.923% ############# ( 2, 3 ] 203430 7.747% 94.670% ## ( 3, 4 ] 75966 2.893% 97.563% # ( 4, 6 ] 38745 1.475% 99.038% ( 6, 10 ] 15661 0.596% 99.635% ( 10, 15 ] 2737 0.104% 99.739% ( 15, 22 ] 287 0.011% 99.750% ( 22, 34 ] 28 0.001% 99.751% ( 34, 51 ] 18 0.001% 99.752% ( 51, 76 ] 28 0.001% 99.753% ( 76, 110 ] 2656 0.101% 99.854% ( 110, 170 ] 2877 0.110% 99.964% ( 170, 250 ] 735 0.028% 99.992% ( 250, 380 ] 432 0.016% 100.008% ( 380, 580 ] 319 0.012% 100.020% ( 580, 870 ] 145 0.006% 100.026% ( 870, 1300 ] 30 0.001% 100.027% ( 1300, 1900 ] 13 0.000% 100.027% ( 1900, 2900 ] 19 0.001% 100.028% ( 2900, 4400 ] 6 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 113549 Average: 5.4047 StdDev: 77.37 Min: 0 Median: 1.6973 Max: 6810 Percentiles: P50: 1.70 P75: 2.40 P99: 8.41 P99.9: 326.43 P99.99: 696.20 ------------------------------------------------------ [ 0, 1 ] 10500 9.247% 9.247% ## ( 1, 2 ] 66363 58.444% 67.691% ############ ( 2, 3 ] 20608 18.149% 85.840% #### ( 3, 4 ] 7342 6.466% 92.306% # ( 4, 6 ] 6837 6.021% 98.328% # ( 6, 10 ] 1268 1.117% 99.444% ( 10, 15 ] 243 0.214% 99.658% ( 15, 22 ] 31 0.027% 99.686% ( 22, 34 ] 12 0.011% 99.696% ( 34, 51 ] 17 0.015% 99.711% ( 51, 76 ] 31 0.027% 99.738% ( 76, 110 ] 41 0.036% 99.775% ( 110, 170 ] 51 0.045% 99.819% ( 170, 250 ] 55 0.048% 99.868% ( 250, 380 ] 62 0.055% 99.923% ( 380, 580 ] 51 0.045% 99.967% ( 580, 870 ] 64 0.056% 100.024% ( 870, 1300 ] 34 0.030% 100.054% ( 1300, 1900 ] 21 0.018% 100.072% ( 1900, 2900 ] 18 0.016% 100.088% ( 2900, 4400 ] 21 0.018% 100.107% ( 4400, 6600 ] 4 0.004% 100.110% ( 6600, 9900 ] 1 0.001% 100.111% ** Level 2 read latency histogram (micros): Count: 28262 Average: 2.0094 StdDev: 2.72 Min: 1 Median: 1.3857 Max: 259 Percentiles: P50: 1.39 P75: 1.82 P99: 5.57 P99.9: 9.85 P99.99: 183.90 ------------------------------------------------------ [ 0, 1 ] 7823 27.680% 27.680% ###### ( 1, 2 ] 16356 57.873% 85.553% ############ ( 2, 3 ] 2300 8.138% 93.691% ## ( 3, 4 ] 1048 3.708% 97.399% # ( 4, 6 ] 576 2.038% 99.437% ( 6, 10 ] 136 0.481% 99.919% ( 10, 15 ] 15 0.053% 99.972% ( 15, 22 ] 3 0.011% 99.982% ( 51, 76 ] 1 0.004% 99.986% ( 110, 170 ] 1 0.004% 99.989% ( 170, 250 ] 1 0.004% 99.993% ( 250, 380 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 283453 Average: 4.2283 StdDev: 53.27 Min: 0 Median: 1.6046 Max: 6306 Percentiles: P50: 1.60 P75: 2.00 P99: 8.97 P99.9: 443.05 P99.99: 1470.10 ------------------------------------------------------ [ 0, 1 ] 33574 11.845% 11.845% ## ( 1, 2 ] 178887 63.110% 74.955% ############# ( 2, 3 ] 42297 14.922% 89.877% ### ( 3, 4 ] 12833 4.527% 94.404% # ( 4, 6 ] 9837 3.470% 97.874% # ( 6, 10 ] 4299 1.517% 99.391% ( 10, 15 ] 438 0.155% 99.546% ( 15, 22 ] 103 0.036% 99.582% ( 22, 34 ] 41 0.014% 99.596% ( 34, 51 ] 5 0.002% 99.598% ( 51, 76 ] 9 0.003% 99.601% ( 76, 110 ] 129 0.046% 99.647% ( 110, 170 ] 329 0.116% 99.763% ( 170, 250 ] 177 0.062% 99.825% ( 250, 380 ] 163 0.058% 99.883% ( 380, 580 ] 154 0.054% 99.937% ( 580, 870 ] 92 0.032% 99.970% ( 870, 1300 ] 50 0.018% 99.987% ( 1300, 1900 ] 27 0.010% 99.997% ( 1900, 2900 ] 20 0.007% 100.004% ( 2900, 4400 ] 23 0.008% 100.012% ( 4400, 6600 ] 6 0.002% 100.014% ** Level 4 read latency histogram (micros): Count: 1455 Average: 79.7038 StdDev: 428.80 Min: 0 Median: 1.9444 Max: 5322 Percentiles: P50: 1.94 P75: 3.14 P99: 2590.00 P99.9: 5322.00 P99.99: 5322.00 ------------------------------------------------------ [ 0, 1 ] 73 5.017% 5.017% # ( 1, 2 ] 693 47.629% 52.646% ########## ( 2, 3 ] 308 21.168% 73.814% #### ( 3, 4 ] 123 8.454% 82.268% ## ( 4, 6 ] 84 5.773% 88.041% # ( 6, 10 ] 31 2.131% 90.172% ( 10, 15 ] 21 1.443% 91.615% ( 15, 22 ] 13 0.893% 92.509% ( 51, 76 ] 1 0.069% 92.577% ( 110, 170 ] 7 0.481% 93.058% ( 170, 250 ] 15 1.031% 94.089% ( 250, 380 ] 17 1.168% 95.258% ( 380, 580 ] 24 1.649% 96.907% ( 580, 870 ] 11 0.756% 97.663% ( 870, 1300 ] 10 0.687% 98.351% ( 1300, 1900 ] 6 0.412% 98.763% ( 1900, 2900 ] 5 0.344% 99.107% ( 2900, 4400 ] 9 0.619% 99.725% ( 4400, 6600 ] 4 0.275% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 662.7500 StdDev: 805.05 Min: 73 Median: 315.0000 Max: 2897 Percentiles: P50: 315.00 P75: 773.33 P99: 2850.00 P99.9: 2895.00 P99.99: 2897.00 ------------------------------------------------------ ( 51, 76 ] 2 10.000% 10.000% ## ( 76, 110 ] 2 10.000% 20.000% ## ( 110, 170 ] 4 20.000% 40.000% #### ( 250, 380 ] 4 20.000% 60.000% #### ( 380, 580 ] 1 5.000% 65.000% # ( 580, 870 ] 3 15.000% 80.000% ### ( 1900, 2900 ] 4 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 28.5 total, 8.6 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 207.25 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:11.825 H:M:S, 41.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 114.68 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:5.625 H:M:S, 65.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/08/14-00:12:50 ... thread 0: (1000000,7000000) ops and (228495.2,214517.5) ops/second in (4.376459,32.631377) 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 13/9 2.88 GB 56.6 7.0 0.0 7.0 13.5 6.6 0.0 2.1 148.7 289.3 47.86 43.55 117 0.409 7226K 11K 0.0 0.0 L1 15/15 1.31 GB 0.0 3.6 3.6 0.1 3.6 3.5 0.1 1.0 217.7 214.4 17.06 15.92 2 8.532 3772K 56K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 2.3 1.8 232.3 232.2 0.48 0.45 1 0.479 113K 43 0.0 0.0 L3 13/2 930.76 MB 0.9 1.3 0.4 0.9 1.3 0.4 2.0 3.7 215.1 215.0 6.20 5.41 4 1.549 1327K 636 0.0 0.0 L4 193/33 11.48 GB 0.9 2.1 1.3 0.8 2.1 1.3 0.9 1.6 136.8 136.5 15.83 9.77 11 1.439 1529K 2536 0.0 0.0 L5 1036/0 86.06 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1270/59 102.65 GB 0.0 14.1 5.3 8.8 20.6 11.8 5.7 3.1 165.2 241.4 87.43 75.10 135 0.648 13M 71K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.1 5.3 8.8 20.6 11.8 5.6 3.1 165.2 241.4 87.43 75.10 135 0.648 13M 71K 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 14.1 5.3 8.8 14.0 5.2 0.0 0.0 215.3 214.2 67.07 58.02 39 1.720 13M 71K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.6 6.6 0.0 0.0 0.0 330.9 20.37 17.07 96 0.212 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): 32.9 total, 32.6 interval Flush(GB): cumulative 6.583, interval 6.583 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: 20.61 GB write, 642.16 MB/s write, 14.10 GB read, 439.38 MB/s read, 87.4 seconds Interval compaction: 20.61 GB write, 646.83 MB/s write, 14.10 GB read, 442.57 MB/s read, 87.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 17, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 17, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 32, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 32, interval: 49 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2992379 Average: 2.6431 StdDev: 18.66 Min: 0 Median: 1.4769 Max: 5842 Percentiles: P50: 1.48 P75: 1.87 P99: 6.61 P99.9: 130.96 P99.99: 253.30 ------------------------------------------------------ [ 0, 1 ] 581338 19.427% 19.427% #### ( 1, 2 ] 1918431 64.111% 83.538% ############# ( 2, 3 ] 278241 9.298% 92.836% ## ( 3, 4 ] 110827 3.704% 96.540% # ( 4, 6 ] 70201 2.346% 98.886% ( 6, 10 ] 22350 0.747% 99.633% ( 10, 15 ] 3787 0.127% 99.759% ( 15, 22 ] 448 0.015% 99.774% ( 22, 34 ] 37 0.001% 99.775% ( 34, 51 ] 21 0.001% 99.776% ( 51, 76 ] 30 0.001% 99.777% ( 76, 110 ] 2662 0.089% 99.866% ( 110, 170 ] 2905 0.097% 99.963% ( 170, 250 ] 790 0.026% 99.990% ( 250, 380 ] 503 0.017% 100.006% ( 380, 580 ] 412 0.014% 100.020% ( 580, 870 ] 238 0.008% 100.028% ( 870, 1300 ] 74 0.002% 100.031% ( 1300, 1900 ] 29 0.001% 100.032% ( 1900, 2900 ] 38 0.001% 100.033% ( 2900, 4400 ] 22 0.001% 100.034% ( 4400, 6600 ] 1 0.000% 100.034% ** Level 1 read latency histogram (micros): Count: 369186 Average: 6.7279 StdDev: 100.66 Min: 0 Median: 1.9027 Max: 7835 Percentiles: P50: 1.90 P75: 2.87 P99: 9.18 P99.9: 103.21 P99.99: 486.60 ------------------------------------------------------ [ 0, 1 ] 13244 3.587% 3.587% # ( 1, 2 ] 189822 51.416% 55.004% ########## ( 2, 3 ] 85228 23.085% 78.089% ##### ( 3, 4 ] 35515 9.620% 87.709% ## ( 4, 6 ] 35731 9.678% 97.387% ## ( 6, 10 ] 7491 2.029% 99.416% ( 10, 15 ] 1500 0.406% 99.823% ( 15, 22 ] 176 0.048% 99.870% ( 22, 34 ] 24 0.007% 99.877% ( 34, 51 ] 19 0.005% 99.882% ( 51, 76 ] 34 0.009% 99.891% ( 76, 110 ] 41 0.011% 99.902% ( 110, 170 ] 57 0.015% 99.918% ( 170, 250 ] 77 0.021% 99.939% ( 250, 380 ] 108 0.029% 99.968% ( 380, 580 ] 154 0.042% 100.009% ( 580, 870 ] 197 0.053% 100.063% ( 870, 1300 ] 142 0.038% 100.101% ( 1300, 1900 ] 102 0.028% 100.129% ( 1900, 2900 ] 100 0.027% 100.156% ( 2900, 4400 ] 107 0.029% 100.185% ( 4400, 6600 ] 36 0.010% 100.195% ( 6600, 9900 ] 5 0.001% 100.196% ** Level 2 read latency histogram (micros): Count: 28262 Average: 2.0094 StdDev: 2.72 Min: 1 Median: 1.3857 Max: 259 Percentiles: P50: 1.39 P75: 1.82 P99: 5.57 P99.9: 9.85 P99.99: 183.90 ------------------------------------------------------ [ 0, 1 ] 7823 27.680% 27.680% ###### ( 1, 2 ] 16356 57.873% 85.553% ############ ( 2, 3 ] 2300 8.138% 93.691% ## ( 3, 4 ] 1048 3.708% 97.399% # ( 4, 6 ] 576 2.038% 99.437% ( 6, 10 ] 136 0.481% 99.919% ( 10, 15 ] 15 0.053% 99.972% ( 15, 22 ] 3 0.011% 99.982% ( 51, 76 ] 1 0.004% 99.986% ( 110, 170 ] 1 0.004% 99.989% ( 170, 250 ] 1 0.004% 99.993% ( 250, 380 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 319140 Average: 9.1488 StdDev: 126.79 Min: 0 Median: 1.6337 Max: 7810 Percentiles: P50: 1.63 P75: 2.15 P99: 9.81 P99.9: 1784.97 P99.99: 4141.84 ------------------------------------------------------ [ 0, 1 ] 34577 10.834% 10.834% ## ( 1, 2 ] 197254 61.808% 72.642% ############ ( 2, 3 ] 49929 15.645% 88.287% ### ( 3, 4 ] 16623 5.209% 93.496% # ( 4, 6 ] 12656 3.966% 97.462% # ( 6, 10 ] 5159 1.617% 99.078% ( 10, 15 ] 529 0.166% 99.244% ( 15, 22 ] 126 0.039% 99.283% ( 22, 34 ] 43 0.013% 99.297% ( 34, 51 ] 5 0.002% 99.298% ( 51, 76 ] 10 0.003% 99.302% ( 76, 110 ] 130 0.041% 99.342% ( 110, 170 ] 341 0.107% 99.449% ( 170, 250 ] 202 0.063% 99.512% ( 250, 380 ] 260 0.081% 99.594% ( 380, 580 ] 328 0.103% 99.697% ( 580, 870 ] 293 0.092% 99.788% ( 870, 1300 ] 233 0.073% 99.862% ( 1300, 1900 ] 152 0.048% 99.909% ( 1900, 2900 ] 119 0.037% 99.946% ( 2900, 4400 ] 168 0.053% 99.999% ( 4400, 6600 ] 37 0.012% 100.011% ( 6600, 9900 ] 8 0.003% 100.013% ** Level 4 read latency histogram (micros): Count: 137705 Average: 9.4220 StdDev: 109.00 Min: 0 Median: 1.8774 Max: 7916 Percentiles: P50: 1.88 P75: 2.86 P99: 12.69 P99.9: 1321.86 P99.99: 3416.88 ------------------------------------------------------ [ 0, 1 ] 4216 3.062% 3.062% # ( 1, 2 ] 73669 53.498% 56.559% ########### ( 2, 3 ] 29650 21.532% 78.091% #### ( 3, 4 ] 13669 9.926% 88.017% ## ( 4, 6 ] 11744 8.528% 96.546% ## ( 6, 10 ] 3116 2.263% 98.808% ( 10, 15 ] 491 0.357% 99.165% ( 15, 22 ] 81 0.059% 99.224% ( 22, 34 ] 4 0.003% 99.227% ( 34, 51 ] 3 0.002% 99.229% ( 51, 76 ] 3 0.002% 99.231% ( 76, 110 ] 38 0.028% 99.259% ( 110, 170 ] 66 0.048% 99.306% ( 170, 250 ] 119 0.086% 99.393% ( 250, 380 ] 145 0.105% 99.498% ( 380, 580 ] 207 0.150% 99.649% ( 580, 870 ] 202 0.147% 99.795% ( 870, 1300 ] 142 0.103% 99.898% ( 1300, 1900 ] 63 0.046% 99.944% ( 1900, 2900 ] 46 0.033% 99.977% ( 2900, 4400 ] 50 0.036% 100.014% ( 4400, 6600 ] 8 0.006% 100.020% ( 6600, 9900 ] 1 0.001% 100.020% ** Level 5 read latency histogram (micros): Count: 20 Average: 662.7500 StdDev: 805.05 Min: 73 Median: 315.0000 Max: 2897 Percentiles: P50: 315.00 P75: 773.33 P99: 2850.00 P99.9: 2895.00 P99.99: 2897.00 ------------------------------------------------------ ( 51, 76 ] 2 10.000% 10.000% ## ( 76, 110 ] 2 10.000% 20.000% ## ( 110, 170 ] 4 20.000% 40.000% #### ( 250, 380 ] 4 20.000% 60.000% #### ( 380, 580 ] 1 5.000% 65.000% # ( 580, 870 ] 3 15.000% 80.000% ### ( 1900, 2900 ] 4 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 32.9 total, 4.4 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 209.59 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:13.343 H:M:S, 40.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 224.88 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.518 H:M:S, 34.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/08/14-00:12:54 ... thread 0: (1000000,8000000) ops and (255412.8,218898.6) ops/second in (3.915230,36.546607) 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.87 GB 138.4 7.8 0.0 7.8 15.4 7.6 0.0 2.0 147.1 289.4 54.37 49.58 134 0.406 8121K 12K 0.0 0.0 L1 15/15 1.31 GB 0.0 3.6 3.6 0.1 3.6 3.5 0.1 1.0 217.7 214.4 17.06 15.92 2 8.532 3772K 56K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 2.3 1.8 232.3 232.2 0.48 0.45 1 0.479 113K 43 0.0 0.0 L3 11/0 920.77 MB 0.9 1.3 0.4 0.9 1.3 0.4 2.0 3.7 215.1 215.0 6.20 5.41 4 1.549 1327K 636 0.0 0.0 L4 178/0 9.76 GB 1.0 4.8 1.3 3.5 4.8 1.3 0.9 3.6 161.4 161.0 30.65 21.35 13 2.358 1987K 2536 0.0 0.0 L5 1052/0 87.78 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1274/28 103.62 GB 0.0 17.7 5.3 12.4 25.2 12.8 7.4 3.3 166.5 236.9 108.76 92.71 154 0.706 15M 72K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.7 5.3 12.4 25.2 12.8 7.4 3.3 166.5 236.9 108.76 92.71 154 0.706 15M 72K 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 17.7 5.3 12.4 17.6 5.2 0.0 0.0 212.0 211.0 85.39 73.01 44 1.941 15M 72K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.6 7.6 0.0 0.0 0.0 331.5 23.38 19.70 110 0.213 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): 36.8 total, 36.5 interval Flush(GB): cumulative 7.567, interval 7.567 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: 25.17 GB write, 700.54 MB/s write, 17.68 GB read, 492.21 MB/s read, 108.8 seconds Interval compaction: 25.17 GB write, 705.08 MB/s write, 17.68 GB read, 495.40 MB/s read, 108.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 17, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 17, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 37, pending-compaction-bytes-delays: 4, pending-compaction-bytes-stops: 0, total-delays: 21, total-stops: 37, interval: 58 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3385641 Average: 2.6706 StdDev: 18.38 Min: 0 Median: 1.5003 Max: 5842 Percentiles: P50: 1.50 P75: 1.89 P99: 6.81 P99.9: 123.25 P99.99: 234.00 ------------------------------------------------------ [ 0, 1 ] 610426 18.030% 18.030% #### ( 1, 2 ] 2163496 63.902% 81.932% ############# ( 2, 3 ] 343906 10.158% 92.090% ## ( 3, 4 ] 137615 4.065% 96.154% # ( 4, 6 ] 90811 2.682% 98.837% # ( 6, 10 ] 27289 0.806% 99.643% ( 10, 15 ] 4707 0.139% 99.782% ( 15, 22 ] 557 0.016% 99.798% ( 22, 34 ] 39 0.001% 99.799% ( 34, 51 ] 23 0.001% 99.800% ( 51, 76 ] 30 0.001% 99.801% ( 76, 110 ] 2695 0.080% 99.880% ( 110, 170 ] 3004 0.089% 99.969% ( 170, 250 ] 883 0.026% 99.995% ( 250, 380 ] 581 0.017% 100.012% ( 380, 580 ] 470 0.014% 100.026% ( 580, 870 ] 275 0.008% 100.034% ( 870, 1300 ] 95 0.003% 100.037% ( 1300, 1900 ] 35 0.001% 100.038% ( 1900, 2900 ] 42 0.001% 100.040% ( 2900, 4400 ] 22 0.001% 100.040% ( 4400, 6600 ] 1 0.000% 100.040% ** Level 1 read latency histogram (micros): Count: 411242 Average: 6.3249 StdDev: 95.46 Min: 0 Median: 1.8567 Max: 7835 Percentiles: P50: 1.86 P75: 2.79 P99: 9.13 P99.9: 132.64 P99.99: 489.60 ------------------------------------------------------ [ 0, 1 ] 17915 4.356% 4.356% # ( 1, 2 ] 219094 53.276% 57.632% ########### ( 2, 3 ] 90437 21.991% 79.624% #### ( 3, 4 ] 36768 8.941% 88.564% ## ( 4, 6 ] 36552 8.888% 97.453% ## ( 6, 10 ] 8140 1.979% 99.432% ( 10, 15 ] 1551 0.377% 99.809% ( 15, 22 ] 179 0.044% 99.853% ( 22, 34 ] 24 0.006% 99.858% ( 34, 51 ] 19 0.005% 99.863% ( 51, 76 ] 34 0.008% 99.871% ( 76, 110 ] 77 0.019% 99.890% ( 110, 170 ] 108 0.026% 99.916% ( 170, 250 ] 94 0.023% 99.939% ( 250, 380 ] 119 0.029% 99.968% ( 380, 580 ] 164 0.040% 100.008% ( 580, 870 ] 199 0.048% 100.056% ( 870, 1300 ] 142 0.035% 100.091% ( 1300, 1900 ] 102 0.025% 100.116% ( 1900, 2900 ] 100 0.024% 100.140% ( 2900, 4400 ] 107 0.026% 100.166% ( 4400, 6600 ] 36 0.009% 100.175% ( 6600, 9900 ] 5 0.001% 100.176% ** Level 2 read latency histogram (micros): Count: 28262 Average: 2.0094 StdDev: 2.72 Min: 1 Median: 1.3857 Max: 259 Percentiles: P50: 1.39 P75: 1.82 P99: 5.57 P99.9: 9.85 P99.99: 183.90 ------------------------------------------------------ [ 0, 1 ] 7823 27.680% 27.680% ###### ( 1, 2 ] 16356 57.873% 85.553% ############ ( 2, 3 ] 2300 8.138% 93.691% ## ( 3, 4 ] 1048 3.708% 97.399% # ( 4, 6 ] 576 2.038% 99.437% ( 6, 10 ] 136 0.481% 99.919% ( 10, 15 ] 15 0.053% 99.972% ( 15, 22 ] 3 0.011% 99.982% ( 51, 76 ] 1 0.004% 99.986% ( 110, 170 ] 1 0.004% 99.989% ( 170, 250 ] 1 0.004% 99.993% ( 250, 380 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 320162 Average: 9.2816 StdDev: 126.92 Min: 0 Median: 1.6352 Max: 7810 Percentiles: P50: 1.64 P75: 2.16 P99: 9.90 P99.9: 1781.72 P99.99: 4140.93 ------------------------------------------------------ [ 0, 1 ] 34586 10.803% 10.803% ## ( 1, 2 ] 197582 61.713% 72.516% ############ ( 2, 3 ] 50337 15.722% 88.238% ### ( 3, 4 ] 16691 5.213% 93.451% # ( 4, 6 ] 12711 3.970% 97.422% # ( 6, 10 ] 5179 1.618% 99.039% ( 10, 15 ] 530 0.166% 99.205% ( 15, 22 ] 127 0.040% 99.244% ( 22, 34 ] 43 0.013% 99.258% ( 34, 51 ] 5 0.002% 99.259% ( 51, 76 ] 10 0.003% 99.263% ( 76, 110 ] 134 0.042% 99.304% ( 110, 170 ] 367 0.115% 99.419% ( 170, 250 ] 232 0.072% 99.492% ( 250, 380 ] 284 0.089% 99.580% ( 380, 580 ] 352 0.110% 99.690% ( 580, 870 ] 308 0.096% 99.786% ( 870, 1300 ] 241 0.075% 99.862% ( 1300, 1900 ] 153 0.048% 99.909% ( 1900, 2900 ] 119 0.037% 99.947% ( 2900, 4400 ] 168 0.052% 99.999% ( 4400, 6600 ] 37 0.012% 100.011% ( 6600, 9900 ] 8 0.002% 100.013% ** Level 4 read latency histogram (micros): Count: 137875 Average: 9.7539 StdDev: 110.26 Min: 0 Median: 1.8776 Max: 7916 Percentiles: P50: 1.88 P75: 2.86 P99: 13.58 P99.9: 1363.81 P99.99: 3416.37 ------------------------------------------------------ [ 0, 1 ] 4252 3.084% 3.084% # ( 1, 2 ] 73711 53.462% 56.546% ########### ( 2, 3 ] 29653 21.507% 78.053% #### ( 3, 4 ] 13669 9.914% 87.967% ## ( 4, 6 ] 11744 8.518% 96.485% ## ( 6, 10 ] 3116 2.260% 98.745% ( 10, 15 ] 491 0.356% 99.101% ( 15, 22 ] 81 0.059% 99.160% ( 22, 34 ] 4 0.003% 99.163% ( 34, 51 ] 3 0.002% 99.165% ( 51, 76 ] 3 0.002% 99.167% ( 76, 110 ] 44 0.032% 99.199% ( 110, 170 ] 72 0.052% 99.251% ( 170, 250 ] 141 0.102% 99.354% ( 250, 380 ] 152 0.110% 99.464% ( 380, 580 ] 228 0.165% 99.629% ( 580, 870 ] 210 0.152% 99.782% ( 870, 1300 ] 156 0.113% 99.895% ( 1300, 1900 ] 67 0.049% 99.943% ( 1900, 2900 ] 47 0.034% 99.978% ( 2900, 4400 ] 50 0.036% 100.014% ( 4400, 6600 ] 8 0.006% 100.020% ( 6600, 9900 ] 1 0.001% 100.020% ** Level 5 read latency histogram (micros): Count: 55 Average: 869.7273 StdDev: 1049.54 Min: 73 Median: 315.0000 Max: 3925 Percentiles: P50: 315.00 P75: 1350.00 P99: 3925.00 P99.9: 3925.00 P99.99: 3925.00 ------------------------------------------------------ ( 51, 76 ] 2 3.636% 3.636% # ( 76, 110 ] 9 16.364% 20.000% ### ( 110, 170 ] 9 16.364% 36.364% ### ( 170, 250 ] 4 7.273% 43.636% # ( 250, 380 ] 7 12.727% 56.364% ### ( 380, 580 ] 2 3.636% 60.000% # ( 580, 870 ] 5 9.091% 69.091% ## ( 870, 1300 ] 3 5.455% 74.545% # ( 1300, 1900 ] 3 5.455% 80.000% # ( 1900, 2900 ] 6 10.909% 90.909% ## ( 2900, 4400 ] 5 9.091% 100.000% ## ** DB Stats ** Uptime(secs): 36.8 total, 3.9 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 214.04 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:14.514 H:M:S, 39.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 251.36 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.172 H:M:S, 29.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/08/14-00:13:07 ... thread 0: (1000000,9000000) ops and (77501.6,182003.6) ops/second in (12.902966,49.449573) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/5 2.82 GB 25.2 10.4 0.0 10.4 18.9 8.5 0.0 2.2 152.4 277.5 69.82 62.41 152 0.459 10M 24K 0.0 0.0 L1 7/7 585.28 MB 0.0 7.0 5.6 1.4 6.9 5.5 0.1 1.2 215.0 212.0 33.17 30.60 3 11.058 6399K 56K 0.0 0.0 L2 1/0 77.45 MB 0.8 0.1 0.1 0.0 0.1 0.1 5.0 1.8 232.3 232.2 0.48 0.45 1 0.479 113K 43 0.0 0.0 L3 23/5 1.48 GB 0.9 2.5 0.8 1.7 2.5 0.8 4.2 3.1 166.8 165.7 15.43 11.31 10 1.543 2587K 17K 0.0 0.0 L4 169/14 9.83 GB 1.0 7.4 3.4 4.0 7.4 3.3 0.9 2.2 149.0 148.5 50.74 33.55 32 1.586 4611K 7772 0.0 0.0 L5 1076/0 89.75 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1284/31 104.53 GB 0.0 27.4 9.8 17.5 35.8 18.2 14.3 4.2 165.2 215.8 169.65 138.33 198 0.857 24M 106K 0.0 0.0 Int 0/0 0.00 KB 0.0 27.4 9.8 17.5 35.8 18.2 14.2 4.2 165.2 215.8 169.65 138.33 198 0.857 24M 106K 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 27.4 9.8 17.5 27.2 9.7 0.0 0.0 197.1 195.9 142.16 116.00 75 1.896 24M 106K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 318.6 27.48 22.33 123 0.223 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): 49.7 total, 49.5 interval Flush(GB): cumulative 8.551, interval 8.551 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: 35.75 GB write, 736.85 MB/s write, 27.36 GB read, 563.90 MB/s read, 169.6 seconds Interval compaction: 35.75 GB write, 740.39 MB/s write, 27.36 GB read, 566.61 MB/s read, 169.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 19, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 19, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 51, pending-compaction-bytes-delays: 25, pending-compaction-bytes-stops: 0, total-delays: 44, total-stops: 51, interval: 95 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4258526 Average: 2.9506 StdDev: 24.92 Min: 0 Median: 1.5094 Max: 8822 Percentiles: P50: 1.51 P75: 1.90 P99: 7.71 P99.9: 152.23 P99.99: 333.95 ------------------------------------------------------ [ 0, 1 ] 743620 17.462% 17.462% ### ( 1, 2 ] 2720127 63.875% 81.337% ############# ( 2, 3 ] 438615 10.300% 91.636% ## ( 3, 4 ] 176969 4.156% 95.792% # ( 4, 6 ] 120463 2.829% 98.621% # ( 6, 10 ] 37780 0.887% 99.508% ( 10, 15 ] 6248 0.147% 99.655% ( 15, 22 ] 733 0.017% 99.672% ( 22, 34 ] 49 0.001% 99.673% ( 34, 51 ] 31 0.001% 99.674% ( 51, 76 ] 57 0.001% 99.675% ( 76, 110 ] 5512 0.129% 99.805% ( 110, 170 ] 5773 0.136% 99.940% ( 170, 250 ] 1478 0.035% 99.975% ( 250, 380 ] 999 0.023% 99.998% ( 380, 580 ] 809 0.019% 100.017% ( 580, 870 ] 437 0.010% 100.028% ( 870, 1300 ] 157 0.004% 100.031% ( 1300, 1900 ] 75 0.002% 100.033% ( 1900, 2900 ] 76 0.002% 100.035% ( 2900, 4400 ] 60 0.001% 100.036% ( 4400, 6600 ] 12 0.000% 100.036% ( 6600, 9900 ] 1 0.000% 100.037% ** Level 1 read latency histogram (micros): Count: 1389848 Average: 6.6672 StdDev: 101.53 Min: 0 Median: 1.8475 Max: 18817 Percentiles: P50: 1.85 P75: 2.82 P99: 9.31 P99.9: 97.61 P99.99: 217.01 ------------------------------------------------------ [ 0, 1 ] 67402 4.850% 4.850% # ( 1, 2 ] 740462 53.276% 58.126% ########### ( 2, 3 ] 286234 20.595% 78.721% #### ( 3, 4 ] 126630 9.111% 87.832% ## ( 4, 6 ] 127907 9.203% 97.035% ## ( 6, 10 ] 33030 2.377% 99.411% ( 10, 15 ] 5351 0.385% 99.796% ( 15, 22 ] 632 0.045% 99.842% ( 22, 34 ] 59 0.004% 99.846% ( 34, 51 ] 40 0.003% 99.849% ( 51, 76 ] 108 0.008% 99.857% ( 76, 110 ] 949 0.068% 99.925% ( 110, 170 ] 687 0.049% 99.974% ( 170, 250 ] 371 0.027% 100.001% ( 250, 380 ] 476 0.034% 100.035% ( 380, 580 ] 577 0.042% 100.077% ( 580, 870 ] 647 0.047% 100.123% ( 870, 1300 ] 538 0.039% 100.162% ( 1300, 1900 ] 305 0.022% 100.184% ( 1900, 2900 ] 332 0.024% 100.208% ( 2900, 4400 ] 439 0.032% 100.239% ( 4400, 6600 ] 123 0.009% 100.248% ( 6600, 9900 ] 26 0.002% 100.250% ( 14000, 22000 ] 1 0.000% 100.250% ** Level 2 read latency histogram (micros): Count: 28262 Average: 2.0094 StdDev: 2.72 Min: 1 Median: 1.3857 Max: 259 Percentiles: P50: 1.39 P75: 1.82 P99: 5.57 P99.9: 9.85 P99.99: 183.90 ------------------------------------------------------ [ 0, 1 ] 7823 27.680% 27.680% ###### ( 1, 2 ] 16356 57.873% 85.553% ############ ( 2, 3 ] 2300 8.138% 93.691% ## ( 3, 4 ] 1048 3.708% 97.399% # ( 4, 6 ] 576 2.038% 99.437% ( 6, 10 ] 136 0.481% 99.919% ( 10, 15 ] 15 0.053% 99.972% ( 15, 22 ] 3 0.011% 99.982% ( 51, 76 ] 1 0.004% 99.986% ( 110, 170 ] 1 0.004% 99.989% ( 170, 250 ] 1 0.004% 99.993% ( 250, 380 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 579239 Average: 8.1623 StdDev: 112.81 Min: 0 Median: 1.7820 Max: 7810 Percentiles: P50: 1.78 P75: 2.66 P99: 9.35 P99.9: 698.07 P99.99: 1117.36 ------------------------------------------------------ [ 0, 1 ] 37573 6.487% 6.487% # ( 1, 2 ] 322326 55.646% 62.133% ########### ( 2, 3 ] 112275 19.383% 81.516% #### ( 3, 4 ] 48876 8.438% 89.954% ## ( 4, 6 ] 44461 7.676% 97.630% ## ( 6, 10 ] 9479 1.636% 99.266% ( 10, 15 ] 1495 0.258% 99.525% ( 15, 22 ] 208 0.036% 99.560% ( 22, 34 ] 47 0.008% 99.569% ( 34, 51 ] 8 0.001% 99.570% ( 51, 76 ] 19 0.003% 99.573% ( 76, 110 ] 138 0.024% 99.597% ( 110, 170 ] 394 0.068% 99.665% ( 170, 250 ] 269 0.046% 99.712% ( 250, 380 ] 385 0.066% 99.778% ( 380, 580 ] 504 0.087% 99.865% ( 580, 870 ] 498 0.086% 99.951% ( 870, 1300 ] 393 0.068% 100.019% ( 1300, 1900 ] 233 0.040% 100.059% ( 1900, 2900 ] 160 0.028% 100.087% ( 2900, 4400 ] 236 0.041% 100.127% ( 4400, 6600 ] 54 0.009% 100.137% ( 6600, 9900 ] 12 0.002% 100.139% ** Level 4 read latency histogram (micros): Count: 294317 Average: 14.7202 StdDev: 159.25 Min: 0 Median: 1.9413 Max: 8814 Percentiles: P50: 1.94 P75: 2.97 P99: 123.31 P99.9: 1472.02 P99.99: 2257.76 ------------------------------------------------------ [ 0, 1 ] 5781 1.964% 1.964% ( 1, 2 ] 150187 51.029% 52.993% ########## ( 2, 3 ] 66957 22.750% 75.743% ##### ( 3, 4 ] 31631 10.747% 86.490% ## ( 4, 6 ] 28777 9.778% 96.268% ## ( 6, 10 ] 6567 2.231% 98.499% ( 10, 15 ] 1221 0.415% 98.914% ( 15, 22 ] 130 0.044% 98.958% ( 22, 34 ] 10 0.003% 98.962% ( 34, 51 ] 12 0.004% 98.966% ( 51, 76 ] 6 0.002% 98.968% ( 76, 110 ] 61 0.021% 98.989% ( 110, 170 ] 157 0.053% 99.042% ( 170, 250 ] 331 0.112% 99.154% ( 250, 380 ] 407 0.138% 99.293% ( 380, 580 ] 592 0.201% 99.494% ( 580, 870 ] 668 0.227% 99.721% ( 870, 1300 ] 455 0.155% 99.875% ( 1300, 1900 ] 257 0.087% 99.963% ( 1900, 2900 ] 228 0.077% 100.040% ( 2900, 4400 ] 208 0.071% 100.111% ( 4400, 6600 ] 60 0.020% 100.131% ( 6600, 9900 ] 6 0.002% 100.133% ** Level 5 read latency histogram (micros): Count: 175 Average: 1523.3657 StdDev: 1563.42 Min: 73 Median: 816.5789 Max: 7095 Percentiles: P50: 816.58 P75: 2578.57 P99: 6416.67 P99.9: 7095.00 P99.99: 7095.00 ------------------------------------------------------ ( 51, 76 ] 2 1.143% 1.143% ( 76, 110 ] 9 5.143% 6.286% # ( 110, 170 ] 12 6.857% 13.143% # ( 170, 250 ] 15 8.571% 21.714% ## ( 250, 380 ] 16 9.143% 30.857% ## ( 380, 580 ] 18 10.286% 41.143% ## ( 580, 870 ] 19 10.857% 52.000% ## ( 870, 1300 ] 17 9.714% 61.714% ## ( 1300, 1900 ] 9 5.143% 66.857% # ( 1900, 2900 ] 21 12.000% 78.857% ## ( 2900, 4400 ] 27 15.429% 94.286% ### ( 4400, 6600 ] 9 5.143% 99.429% # ( 6600, 9900 ] 1 0.571% 100.000% ** DB Stats ** Uptime(secs): 49.7 total, 12.9 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 178.27 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:24.243 H:M:S, 48.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 76.28 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:9.729 H:M:S, 75.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 6 num-running-flushes: 1 2024/08/14-00:13:10 ... thread 0: (1000000,10000000) ops and (320280.4,190215.9) ops/second in (3.122264,52.571837) 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/9 3.74 GB 88.1 10.9 0.0 10.9 20.4 9.4 0.0 2.2 149.9 279.3 74.77 66.95 167 0.448 11M 24K 0.0 0.0 L1 7/7 585.28 MB 0.0 7.0 5.6 1.4 6.9 5.5 0.1 1.2 215.0 212.0 33.17 30.60 3 11.058 6399K 56K 0.0 0.0 L2 1/0 77.45 MB 0.8 0.1 0.1 0.0 0.1 0.1 5.0 1.8 232.3 232.2 0.48 0.45 1 0.479 113K 43 0.0 0.0 L3 18/0 936.99 MB 0.9 2.5 0.8 1.7 2.5 0.8 4.2 3.1 166.8 165.7 15.43 11.31 10 1.543 2587K 17K 0.0 0.0 L4 161/0 9.59 GB 1.0 8.3 3.9 4.3 8.3 3.9 0.9 2.1 150.5 150.1 56.33 37.73 37 1.523 5540K 9241 0.0 0.0 L5 1088/0 90.56 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1290/16 105.45 GB 0.0 28.8 10.4 18.4 38.1 19.7 15.1 4.0 163.8 216.7 180.19 147.04 218 0.827 26M 108K 0.0 0.0 Int 0/0 0.00 KB 0.0 28.8 10.4 18.4 38.1 19.7 15.1 4.0 163.8 216.7 180.19 147.04 218 0.827 26M 108K 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 28.8 10.4 18.4 28.7 10.2 0.0 0.0 196.8 195.7 149.89 122.27 82 1.828 26M 108K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.5 9.5 0.0 0.0 0.0 320.2 30.30 24.77 136 0.223 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): 52.8 total, 52.6 interval Flush(GB): cumulative 9.474, interval 9.474 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: 38.13 GB write, 739.29 MB/s write, 28.81 GB read, 558.72 MB/s read, 180.2 seconds Interval compaction: 38.13 GB write, 742.62 MB/s write, 28.81 GB read, 561.24 MB/s read, 180.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 19, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 19, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 55, pending-compaction-bytes-delays: 25, pending-compaction-bytes-stops: 0, total-delays: 44, total-stops: 55, interval: 99 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4625728 Average: 2.9054 StdDev: 24.10 Min: 0 Median: 1.5139 Max: 8822 Percentiles: P50: 1.51 P75: 1.90 P99: 7.61 P99.9: 147.93 P99.99: 316.77 ------------------------------------------------------ [ 0, 1 ] 789698 17.072% 17.072% ### ( 1, 2 ] 2963986 64.076% 81.148% ############# ( 2, 3 ] 487098 10.530% 91.678% ## ( 3, 4 ] 191638 4.143% 95.821% # ( 4, 6 ] 130383 2.819% 98.640% # ( 6, 10 ] 41398 0.895% 99.535% ( 10, 15 ] 6706 0.145% 99.680% ( 15, 22 ] 797 0.017% 99.697% ( 22, 34 ] 55 0.001% 99.698% ( 34, 51 ] 32 0.001% 99.699% ( 51, 76 ] 58 0.001% 99.700% ( 76, 110 ] 5577 0.121% 99.821% ( 110, 170 ] 5817 0.126% 99.946% ( 170, 250 ] 1499 0.032% 99.979% ( 250, 380 ] 1021 0.022% 100.001% ( 380, 580 ] 822 0.018% 100.019% ( 580, 870 ] 443 0.010% 100.028% ( 870, 1300 ] 162 0.004% 100.032% ( 1300, 1900 ] 77 0.002% 100.033% ( 1900, 2900 ] 78 0.002% 100.035% ( 2900, 4400 ] 61 0.001% 100.036% ( 4400, 6600 ] 12 0.000% 100.037% ( 6600, 9900 ] 1 0.000% 100.037% ** Level 1 read latency histogram (micros): Count: 1411686 Average: 6.6130 StdDev: 100.84 Min: 0 Median: 1.8475 Max: 18817 Percentiles: P50: 1.85 P75: 2.82 P99: 9.30 P99.9: 97.08 P99.99: 218.05 ------------------------------------------------------ [ 0, 1 ] 67682 4.794% 4.794% # ( 1, 2 ] 753032 53.343% 58.137% ########### ( 2, 3 ] 291062 20.618% 78.755% #### ( 3, 4 ] 128614 9.111% 87.866% ## ( 4, 6 ] 129480 9.172% 97.038% ## ( 6, 10 ] 33538 2.376% 99.414% ( 10, 15 ] 5429 0.385% 99.798% ( 15, 22 ] 640 0.045% 99.844% ( 22, 34 ] 59 0.004% 99.848% ( 34, 51 ] 40 0.003% 99.851% ( 51, 76 ] 110 0.008% 99.858% ( 76, 110 ] 949 0.067% 99.926% ( 110, 170 ] 687 0.049% 99.974% ( 170, 250 ] 371 0.026% 100.000% ( 250, 380 ] 479 0.034% 100.034% ( 380, 580 ] 580 0.041% 100.076% ( 580, 870 ] 647 0.046% 100.121% ( 870, 1300 ] 538 0.038% 100.159% ( 1300, 1900 ] 305 0.022% 100.181% ( 1900, 2900 ] 332 0.024% 100.205% ( 2900, 4400 ] 439 0.031% 100.236% ( 4400, 6600 ] 124 0.009% 100.244% ( 6600, 9900 ] 26 0.002% 100.246% ( 14000, 22000 ] 1 0.000% 100.246% ** Level 2 read latency histogram (micros): Count: 28262 Average: 2.0094 StdDev: 2.72 Min: 1 Median: 1.3857 Max: 259 Percentiles: P50: 1.39 P75: 1.82 P99: 5.57 P99.9: 9.85 P99.99: 183.90 ------------------------------------------------------ [ 0, 1 ] 7823 27.680% 27.680% ###### ( 1, 2 ] 16356 57.873% 85.553% ############ ( 2, 3 ] 2300 8.138% 93.691% ## ( 3, 4 ] 1048 3.708% 97.399% # ( 4, 6 ] 576 2.038% 99.437% ( 6, 10 ] 136 0.481% 99.919% ( 10, 15 ] 15 0.053% 99.972% ( 15, 22 ] 3 0.011% 99.982% ( 51, 76 ] 1 0.004% 99.986% ( 110, 170 ] 1 0.004% 99.989% ( 170, 250 ] 1 0.004% 99.993% ( 250, 380 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 623902 Average: 7.8119 StdDev: 108.83 Min: 0 Median: 1.7856 Max: 7810 Percentiles: P50: 1.79 P75: 2.66 P99: 9.27 P99.9: 671.39 P99.99: 1103.72 ------------------------------------------------------ [ 0, 1 ] 38259 6.132% 6.132% # ( 1, 2 ] 348394 55.841% 61.973% ########### ( 2, 3 ] 122252 19.595% 81.568% #### ( 3, 4 ] 52861 8.473% 90.041% ## ( 4, 6 ] 47796 7.661% 97.702% ## ( 6, 10 ] 9911 1.589% 99.290% ( 10, 15 ] 1606 0.257% 99.548% ( 15, 22 ] 223 0.036% 99.583% ( 22, 34 ] 47 0.008% 99.591% ( 34, 51 ] 9 0.001% 99.592% ( 51, 76 ] 19 0.003% 99.595% ( 76, 110 ] 146 0.023% 99.619% ( 110, 170 ] 407 0.065% 99.684% ( 170, 250 ] 277 0.044% 99.728% ( 250, 380 ] 397 0.064% 99.792% ( 380, 580 ] 514 0.082% 99.874% ( 580, 870 ] 508 0.081% 99.956% ( 870, 1300 ] 393 0.063% 100.019% ( 1300, 1900 ] 236 0.038% 100.057% ( 1900, 2900 ] 160 0.026% 100.082% ( 2900, 4400 ] 236 0.038% 100.120% ( 4400, 6600 ] 54 0.009% 100.129% ( 6600, 9900 ] 12 0.002% 100.131% ** Level 4 read latency histogram (micros): Count: 336999 Average: 13.5514 StdDev: 150.39 Min: 0 Median: 1.9334 Max: 8814 Percentiles: P50: 1.93 P75: 2.95 P99: 15.19 P99.9: 1288.93 P99.99: 2017.17 ------------------------------------------------------ [ 0, 1 ] 6242 1.852% 1.852% ( 1, 2 ] 173829 51.581% 53.434% ########## ( 2, 3 ] 76625 22.737% 76.171% ##### ( 3, 4 ] 35666 10.583% 86.755% ## ( 4, 6 ] 32335 9.595% 96.350% ## ( 6, 10 ] 7589 2.252% 98.601% ( 10, 15 ] 1339 0.397% 98.999% ( 15, 22 ] 150 0.045% 99.043% ( 22, 34 ] 11 0.003% 99.047% ( 34, 51 ] 12 0.004% 99.050% ( 51, 76 ] 6 0.002% 99.052% ( 76, 110 ] 72 0.021% 99.073% ( 110, 170 ] 194 0.058% 99.131% ( 170, 250 ] 368 0.109% 99.240% ( 250, 380 ] 450 0.134% 99.374% ( 380, 580 ] 626 0.186% 99.559% ( 580, 870 ] 694 0.206% 99.765% ( 870, 1300 ] 466 0.138% 99.904% ( 1300, 1900 ] 264 0.078% 99.982% ( 1900, 2900 ] 233 0.069% 100.051% ( 2900, 4400 ] 212 0.063% 100.114% ( 4400, 6600 ] 61 0.018% 100.132% ( 6600, 9900 ] 6 0.002% 100.134% ** Level 5 read latency histogram (micros): Count: 200 Average: 1426.6050 StdDev: 1522.62 Min: 73 Median: 739.5000 Max: 7095 Percentiles: P50: 739.50 P75: 2378.26 P99: 6355.56 P99.9: 7095.00 P99.99: 7095.00 ------------------------------------------------------ ( 51, 76 ] 2 1.000% 1.000% ( 76, 110 ] 11 5.500% 6.500% # ( 110, 170 ] 18 9.000% 15.500% ## ( 170, 250 ] 17 8.500% 24.000% ## ( 250, 380 ] 20 10.000% 34.000% ## ( 380, 580 ] 21 10.500% 44.500% ## ( 580, 870 ] 20 10.000% 54.500% ## ( 870, 1300 ] 19 9.500% 64.000% ## ( 1300, 1900 ] 11 5.500% 69.500% # ( 1900, 2900 ] 23 11.500% 81.000% ## ( 2900, 4400 ] 28 14.000% 95.000% ### ( 4400, 6600 ] 9 4.500% 99.500% # ( 6600, 9900 ] 1 0.500% 100.000% ** DB Stats ** Uptime(secs): 52.8 total, 3.1 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 186.36 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:24.659 H:M:S, 46.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 315.23 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.415 H:M:S, 13.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: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 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 : 5.549 micros/op 180197 ops/sec 60.062 seconds 10822999 operations; 174.6 MB/s Microseconds per write: Count: 10822999 Average: 5.5494 StdDev: 405.84 Min: 1 Median: 1.7627 Max: 715956 Percentiles: P50: 1.76 P75: 2.80 P99: 9.66 P99.9: 1099.11 P99.99: 2532.68 ------------------------------------------------------ [ 0, 1 ] 1297576 11.989% 11.989% ## ( 1, 2 ] 5394058 49.839% 61.828% ########## ( 2, 3 ] 1781149 16.457% 78.285% ### ( 3, 4 ] 1503570 13.892% 92.177% ### ( 4, 6 ] 602742 5.569% 97.746% # ( 6, 10 ] 148138 1.369% 99.115% ( 10, 15 ] 50851 0.470% 99.585% ( 15, 22 ] 11433 0.106% 99.691% ( 22, 34 ] 2047 0.019% 99.710% ( 34, 51 ] 291 0.003% 99.712% ( 51, 76 ] 41 0.000% 99.713% ( 76, 110 ] 7374 0.068% 99.781% ( 110, 170 ] 3056 0.028% 99.809% ( 170, 250 ] 332 0.003% 99.812% ( 250, 380 ] 217 0.002% 99.814% ( 380, 580 ] 32 0.000% 99.814% ( 580, 870 ] 27 0.000% 99.815% ( 870, 1300 ] 17346 0.160% 99.975% ( 1300, 1900 ] 55 0.001% 99.975% ( 1900, 2900 ] 2500 0.023% 99.998% ( 2900, 4400 ] 95 0.001% 99.999% ( 4400, 6600 ] 28 0.000% 100.000% ( 6600, 9900 ] 11 0.000% 100.000% ( 9900, 14000 ] 3 0.000% 100.000% ( 14000, 22000 ] 4 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 110000, 170000 ] 3 0.000% 100.000% ( 170000, 250000 ] 14 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 380000, 570000 ] 2 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 195399 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 : 10822999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 11169334968 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 : 628 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 29689455 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 : 35480381622 rocksdb.compact.write.bytes COUNT : 35271420843 rocksdb.flush.write.bytes COUNT : 11163673903 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 : 84 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 : 313 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 : 11073660928 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4295680 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 : 32471991431 rocksdb.non.last.level.read.count COUNT : 7841808 rocksdb.block.checksum.compute.count COUNT : 8592696 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.400679 P95 : 3.941662 P99 : 8.218944 P100 : 715954.000000 COUNT : 10822999 SUM : 54697507 rocksdb.compaction.times.micros P50 : 1144750.000000 P95 : 7215000.000000 P99 : 16108354.000000 P100 : 16108354.000000 COUNT : 87 SUM : 155369672 rocksdb.compaction.times.cpu_micros P50 : 957750.000000 P95 : 4776666.666667 P99 : 14936160.000000 P100 : 14936160.000000 COUNT : 87 SUM : 127652296 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 : 728.580247 P95 : 1855.000000 P99 : 16040.000000 P100 : 21732.000000 COUNT : 149 SUM : 183172 rocksdb.compaction.outfile.sync.micros P50 : 1080.222222 P95 : 68750.000000 P99 : 128000.000000 P100 : 373554.000000 COUNT : 410 SUM : 4238239 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 : 101.500000 P95 : 1278.500000 P99 : 4141.250000 P100 : 4931.000000 COUNT : 269 SUM : 81863 rocksdb.table.open.io.micros P50 : 1412.087912 P95 : 7766.000000 P99 : 12245.200000 P100 : 17905.000000 COUNT : 628 SUM : 1368519 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.685712 P95 : 7.953929 P99 : 11.792971 P100 : 18822.000000 COUNT : 8591095 SUM : 57016672 rocksdb.read.block.get.micros P50 : 475.798319 P95 : 3481.538462 P99 : 5493.714286 P100 : 10154.000000 COUNT : 1256 SUM : 1114383 rocksdb.write.raw.block.micros P50 : 0.513576 P95 : 0.975794 P99 : 2.906212 P100 : 21005.000000 COUNT : 11247078 SUM : 22946307 rocksdb.numfiles.in.singlecompaction P50 : 3.378947 P95 : 9.600000 P99 : 20.973333 P100 : 34.000000 COUNT : 144 SUM : 613 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.559210 P95 : 1130.424421 P99 : 2192.760145 P100 : 715776.000000 COUNT : 190232 SUM : 29713994 rocksdb.sst.read.micros P50 : 1.596715 P95 : 4.624668 P99 : 8.730254 P100 : 18817.000000 COUNT : 7842372 SUM : 34493488 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 : 10822999 SUM : 11169334968 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 : 211960.784314 P95 : 400900.000000 P99 : 788950.000000 P100 : 904824.000000 COUNT : 149 SUM : 33032263 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 : 411 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