[2024-12-05 16:02:56.855332] Starting SPDK v24.09.1-pre git sha1 b18e1bd62 / DPDK 22.11.4 initialization... [2024-12-05 16:02:56.855495] [ 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_pid1334167 ] Set seed to 1733410976851542 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-05 16:02:56.942679] app.c: 917:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-05 16:02:56.980763] app.c: 610:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-05 16:02:56.980809] app.c: 611:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1334167' to capture a snapshot of events at runtime. [2024-12-05 16:02:56.980819] app.c: 616:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-05 16:02:56.980829] app.c: 617:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-05 16:02:56.980837] app.c: 618:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1334167 for offline analysis/debug. [2024-12-05 16:02:56.980917] reactor.c: 990:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Thu Dec 5 16:03:01 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/05-16:03:04 ... thread 0: (1000000,1000000) ops and (332446.3,332446.3) ops/second in (3.008005,3.008005) 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 6/4 440.93 MB 18.9 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 347.0 2.54 2.30 12 0.212 0 0 0.0 0.0 L1 3/0 249.27 MB 24.9 0.2 0.2 0.0 0.2 0.2 0.2 1.0 250.4 250.2 1.01 0.97 1 1.006 255K 224 0.0 0.0 L2 3/2 191.37 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.1 1.5 248.7 248.6 0.78 0.75 2 0.389 196K 82 0.0 0.0 L3 12/0 993.12 MB 1.0 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 85.57 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 1180/6 97.00 GB 0.0 0.4 0.4 0.1 1.3 1.2 0.4 1.5 103.0 306.8 4.32 4.02 15 0.288 452K 306 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.4 0.1 1.3 1.2 0.2 1.5 103.0 306.8 4.32 4.02 15 0.288 452K 306 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.4 0.1 0.4 0.4 0.0 0.0 249.7 249.5 1.78 1.72 3 0.595 452K 306 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 347.0 2.54 2.30 12 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): 3.2 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 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.30 GB write, 410.55 MB/s write, 0.43 GB read, 137.78 MB/s read, 4.3 seconds Interval compaction: 1.30 GB write, 440.91 MB/s write, 0.43 GB read, 147.97 MB/s read, 4.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 156422 Average: 1.9382 StdDev: 11.75 Min: 0 Median: 1.3079 Max: 2733 Percentiles: P50: 1.31 P75: 1.73 P99: 4.97 P99.9: 9.62 P99.99: 112.68 ------------------------------------------------------ [ 0, 1 ] 49519 31.657% 31.657% ###### ( 1, 2 ] 93191 59.577% 91.234% ############ ( 2, 3 ] 8035 5.137% 96.371% # ( 3, 4 ] 3178 2.032% 98.402% ( 4, 6 ] 1930 1.234% 99.636% ( 6, 10 ] 458 0.293% 99.929% ( 10, 15 ] 81 0.052% 99.981% ( 15, 22 ] 11 0.007% 99.988% ( 22, 34 ] 4 0.003% 99.990% ( 51, 76 ] 1 0.001% 99.991% ( 110, 170 ] 8 0.005% 99.996% ( 170, 250 ] 2 0.001% 99.997% ( 250, 380 ] 4 0.003% 100.000% ( 380, 580 ] 1 0.001% 100.001% ( 580, 870 ] 4 0.003% 100.003% ( 870, 1300 ] 2 0.001% 100.004% ( 1300, 1900 ] 1 0.001% 100.005% ( 1900, 2900 ] 2 0.001% 100.006% ** Level 1 read latency histogram (micros): Count: 656 Average: 7.6951 StdDev: 48.48 Min: 1 Median: 2.5794 Max: 990 Percentiles: P50: 2.58 P75: 3.61 P99: 136.40 P99.9: 990.00 P99.99: 990.00 ------------------------------------------------------ [ 0, 1 ] 8 1.220% 1.220% ( 1, 2 ] 185 28.201% 29.421% ###### ( 2, 3 ] 233 35.518% 64.939% ####### ( 3, 4 ] 109 16.616% 81.555% ### ( 4, 6 ] 79 12.043% 93.598% ## ( 6, 10 ] 27 4.116% 97.713% # ( 10, 15 ] 7 1.067% 98.780% ( 34, 51 ] 1 0.152% 98.933% ( 110, 170 ] 1 0.152% 99.085% ( 170, 250 ] 1 0.152% 99.238% ( 250, 380 ] 3 0.457% 99.695% ( 380, 580 ] 1 0.152% 99.848% ( 870, 1300 ] 1 0.152% 100.000% ** Level 2 read latency histogram (micros): Count: 40967 Average: 2.4073 StdDev: 23.46 Min: 1 Median: 1.5264 Max: 3749 Percentiles: P50: 1.53 P75: 1.89 P99: 5.83 P99.9: 9.80 P99.99: 560.66 ------------------------------------------------------ [ 0, 1 ] 5736 14.002% 14.002% ### ( 1, 2 ] 28014 68.382% 82.383% ############## ( 2, 3 ] 3960 9.666% 92.050% ## ( 3, 4 ] 1800 4.394% 96.443% # ( 4, 6 ] 1145 2.795% 99.238% # ( 6, 10 ] 285 0.696% 99.934% ( 10, 15 ] 15 0.037% 99.971% ( 15, 22 ] 2 0.005% 99.976% ( 51, 76 ] 1 0.002% 99.978% ( 110, 170 ] 1 0.002% 99.980% ( 250, 380 ] 3 0.007% 99.988% ( 380, 580 ] 1 0.002% 99.990% ( 580, 870 ] 2 0.005% 99.995% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 55 Average: 1494.9636 StdDev: 1006.49 Min: 186 Median: 1219.3750 Max: 4811 Percentiles: P50: 1219.38 P75: 2250.00 P99: 4811.00 P99.9: 4811.00 P99.99: 4811.00 ------------------------------------------------------ ( 170, 250 ] 2 3.636% 3.636% # ( 250, 380 ] 2 3.636% 7.273% # ( 380, 580 ] 6 10.909% 18.182% ## ( 580, 870 ] 11 20.000% 38.182% #### ( 870, 1300 ] 8 14.545% 52.727% ### ( 1300, 1900 ] 7 12.727% 65.455% ### ( 1900, 2900 ] 15 27.273% 92.727% ##### ( 2900, 4400 ] 3 5.455% 98.182% # ( 4400, 6600 ] 1 1.818% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 1732.4000 StdDev: 1409.09 Min: 545 Median: 1156.6667 Max: 5169 Percentiles: P50: 1156.67 P75: 1780.00 P99: 5169.00 P99.9: 5169.00 P99.99: 5169.00 ------------------------------------------------------ ( 380, 580 ] 1 5.000% 5.000% # ( 580, 870 ] 7 35.000% 40.000% ####### ( 870, 1300 ] 3 15.000% 55.000% ### ( 1300, 1900 ] 5 25.000% 80.000% ##### ( 2900, 4400 ] 2 10.000% 90.000% ## ( 4400, 6600 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.2 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 304.49 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.416 H:M:S, 12.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 326.93 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.416 H:M:S, 13.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/05-16:03:07 ... thread 0: (1000000,2000000) ops and (353369.5,342588.7) ops/second in (2.829899,5.837904) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/16 1.35 GB 6.3 0.2 0.0 0.2 2.0 1.8 0.0 1.1 40.9 337.7 6.15 5.57 27 0.228 255K 260 0.0 0.0 L1 3/3 249.27 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 250.4 250.2 1.01 0.97 1 1.006 255K 224 0.0 0.0 L2 1/0 4.34 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.1 1.5 248.7 248.6 0.78 0.75 2 0.389 196K 82 0.0 0.0 L3 15/0 697.22 MB 0.7 0.2 0.2 0.0 0.2 0.2 0.1 1.0 225.0 225.0 0.83 0.77 1 0.831 189K 0 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 144.1 144.1 1.17 0.78 1 1.166 170K 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1253/19 97.92 GB 0.0 1.0 0.7 0.3 2.8 2.5 1.0 1.6 105.9 289.7 9.93 8.85 32 0.310 1068K 566 0.0 0.0 Int 0/0 0.00 KB 0.0 1.0 0.7 0.3 2.8 2.5 0.9 1.6 105.9 289.7 9.93 8.85 32 0.310 1068K 566 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.0 0.7 0.3 1.0 0.7 0.0 0.0 222.9 222.8 4.72 4.20 6 0.787 1068K 566 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 350.4 5.21 4.65 26 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 total, 5.8 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: 2.81 GB write, 474.87 MB/s write, 1.03 GB read, 173.59 MB/s read, 9.9 seconds Interval compaction: 2.81 GB write, 492.97 MB/s write, 1.03 GB read, 180.21 MB/s read, 9.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 9, interval: 9 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 345293 Average: 2.0742 StdDev: 13.44 Min: 0 Median: 1.4044 Max: 3289 Percentiles: P50: 1.40 P75: 1.80 P99: 5.34 P99.9: 10.01 P99.99: 14.87 ------------------------------------------------------ [ 0, 1 ] 85036 24.627% 24.627% ##### ( 1, 2 ] 216660 62.747% 87.374% ############# ( 2, 3 ] 27561 7.982% 95.356% ## ( 3, 4 ] 9095 2.634% 97.990% # ( 4, 6 ] 5224 1.513% 99.503% ( 6, 10 ] 1373 0.398% 99.900% ( 10, 15 ] 320 0.093% 99.993% ( 15, 22 ] 31 0.009% 100.002% ( 22, 34 ] 5 0.001% 100.003% ( 34, 51 ] 1 0.000% 100.004% ( 51, 76 ] 2 0.001% 100.004% ( 110, 170 ] 13 0.004% 100.008% ( 170, 250 ] 11 0.003% 100.011% ( 250, 380 ] 11 0.003% 100.014% ( 380, 580 ] 1 0.000% 100.015% ( 580, 870 ] 7 0.002% 100.017% ( 870, 1300 ] 3 0.001% 100.018% ( 1300, 1900 ] 2 0.001% 100.018% ( 1900, 2900 ] 3 0.001% 100.019% ( 2900, 4400 ] 3 0.001% 100.020% ** Level 1 read latency histogram (micros): Count: 29792 Average: 2.1524 StdDev: 7.30 Min: 1 Median: 1.4636 Max: 990 Percentiles: P50: 1.46 P75: 1.85 P99: 5.57 P99.9: 12.59 P99.99: 337.57 ------------------------------------------------------ [ 0, 1 ] 6028 20.234% 20.234% #### ( 1, 2 ] 19129 64.209% 84.442% ############# ( 2, 3 ] 2990 10.036% 94.478% ## ( 3, 4 ] 937 3.145% 97.624% # ( 4, 6 ] 522 1.752% 99.376% ( 6, 10 ] 136 0.456% 99.832% ( 10, 15 ] 39 0.131% 99.963% ( 15, 22 ] 3 0.010% 99.973% ( 34, 51 ] 1 0.003% 99.977% ( 110, 170 ] 1 0.003% 99.980% ( 170, 250 ] 1 0.003% 99.983% ( 250, 380 ] 3 0.010% 99.993% ( 380, 580 ] 1 0.003% 99.997% ( 870, 1300 ] 1 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 47969 Average: 2.3779 StdDev: 21.68 Min: 1 Median: 1.5323 Max: 3749 Percentiles: P50: 1.53 P75: 1.90 P99: 5.80 P99.9: 9.85 P99.99: 420.62 ------------------------------------------------------ [ 0, 1 ] 6526 13.605% 13.605% ### ( 1, 2 ] 32797 68.371% 81.976% ############## ( 2, 3 ] 4979 10.380% 92.355% ## ( 3, 4 ] 2007 4.184% 96.539% # ( 4, 6 ] 1308 2.727% 99.266% # ( 6, 10 ] 316 0.659% 99.925% ( 10, 15 ] 22 0.046% 99.971% ( 15, 22 ] 4 0.008% 99.979% ( 51, 76 ] 1 0.002% 99.981% ( 110, 170 ] 1 0.002% 99.983% ( 250, 380 ] 3 0.006% 99.990% ( 380, 580 ] 1 0.002% 99.992% ( 580, 870 ] 2 0.004% 99.996% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 42740 Average: 3.8551 StdDev: 64.83 Min: 1 Median: 1.3664 Max: 4811 Percentiles: P50: 1.37 P75: 1.76 P99: 5.19 P99.9: 665.95 P99.99: 2881.73 ------------------------------------------------------ [ 0, 1 ] 11342 26.537% 26.537% ##### ( 1, 2 ] 27369 64.036% 90.573% ############# ( 2, 3 ] 2477 5.796% 96.369% # ( 3, 4 ] 864 2.022% 98.390% ( 4, 6 ] 439 1.027% 99.417% ( 6, 10 ] 157 0.367% 99.785% ( 10, 15 ] 25 0.058% 99.843% ( 15, 22 ] 8 0.019% 99.862% ( 22, 34 ] 1 0.002% 99.864% ( 110, 170 ] 1 0.002% 99.867% ( 170, 250 ] 2 0.005% 99.871% ( 250, 380 ] 3 0.007% 99.878% ( 380, 580 ] 6 0.014% 99.892% ( 580, 870 ] 11 0.026% 99.918% ( 870, 1300 ] 9 0.021% 99.939% ( 1300, 1900 ] 7 0.016% 99.956% ( 1900, 2900 ] 15 0.035% 99.991% ( 2900, 4400 ] 3 0.007% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 4 read latency histogram (micros): Count: 305 Average: 118.2426 StdDev: 559.86 Min: 0 Median: 0.9776 Max: 5169 Percentiles: P50: 0.98 P75: 4.44 P99: 3612.50 P99.9: 5169.00 P99.99: 5169.00 ------------------------------------------------------ [ 0, 1 ] 156 51.148% 51.148% ########## ( 1, 2 ] 65 21.311% 72.459% #### ( 2, 3 ] 1 0.328% 72.787% ( 3, 4 ] 3 0.984% 73.770% ( 4, 6 ] 17 5.574% 79.344% # ( 6, 10 ] 37 12.131% 91.475% ## ( 10, 15 ] 1 0.328% 91.803% ( 76, 110 ] 2 0.656% 92.459% ( 110, 170 ] 2 0.656% 93.115% ( 250, 380 ] 1 0.328% 93.443% ( 380, 580 ] 1 0.328% 93.770% ( 580, 870 ] 7 2.295% 96.066% ( 870, 1300 ] 3 0.984% 97.049% ( 1300, 1900 ] 5 1.639% 98.689% ( 2900, 4400 ] 2 0.656% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 688.4000 StdDev: 819.07 Min: 105 Median: 250.0000 Max: 2656 Percentiles: P50: 250.00 P75: 870.00 P99: 2656.00 P99.9: 2656.00 P99.99: 2656.00 ------------------------------------------------------ ( 76, 110 ] 3 15.000% 15.000% ### ( 110, 170 ] 6 30.000% 45.000% ###### ( 170, 250 ] 1 5.000% 50.000% # ( 250, 380 ] 3 15.000% 65.000% ### ( 580, 870 ] 2 10.000% 75.000% ## ( 870, 1300 ] 1 5.000% 80.000% # ( 1300, 1900 ] 1 5.000% 85.000% # ( 1900, 2900 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 6.1 total, 2.8 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 324.70 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.636 H:M:S, 10.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 347.78 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.220 H:M:S, 7.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/05-16:03:10 ... thread 0: (1000000,3000000) ops and (333510.9,339508.3) ops/second in (2.998403,8.836307) 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/4 1.60 GB 132.2 1.4 0.0 1.4 4.1 2.8 0.0 1.5 103.8 316.1 13.35 12.38 45 0.297 1407K 1481 0.0 0.0 L1 5/0 485.30 MB 48.5 1.2 1.0 0.2 1.2 1.0 0.2 1.2 234.2 233.3 5.37 5.21 2 2.683 1276K 4624 0.0 0.0 L2 1/0 4.34 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.6 1.5 248.7 248.6 0.78 0.75 2 0.389 196K 82 0.0 0.0 L3 15/0 897.34 MB 0.9 0.2 0.2 0.0 0.2 0.2 0.6 1.0 225.0 225.0 0.83 0.77 1 0.831 189K 0 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.6 1.0 144.1 144.1 1.17 0.78 1 1.166 170K 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1253/4 98.90 GB 0.0 3.1 1.5 1.7 5.9 4.2 2.7 2.1 148.5 280.2 21.49 19.89 51 0.421 3240K 6187 0.0 0.0 Int 0/0 0.00 KB 0.0 3.1 1.5 1.7 5.9 4.2 2.5 2.1 148.5 280.2 21.49 19.89 51 0.421 3240K 6187 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.1 1.5 1.7 3.1 1.4 0.0 0.0 236.3 235.8 13.51 12.77 11 1.228 3240K 6187 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.13 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.8 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: 5.88 GB write, 664.38 MB/s write, 3.12 GB read, 352.21 MB/s read, 21.5 seconds Interval compaction: 5.88 GB write, 681.12 MB/s write, 3.12 GB read, 361.08 MB/s read, 21.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: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 14, interval: 14 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 694751 Average: 2.1324 StdDev: 11.67 Min: 0 Median: 1.4587 Max: 3289 Percentiles: P50: 1.46 P75: 1.84 P99: 5.42 P99.9: 9.94 P99.99: 14.12 ------------------------------------------------------ [ 0, 1 ] 141063 20.304% 20.304% #### ( 1, 2 ] 449809 64.744% 85.048% ############# ( 2, 3 ] 67176 9.669% 94.717% ## ( 3, 4 ] 21105 3.038% 97.755% # ( 4, 6 ] 12216 1.758% 99.513% ( 6, 10 ] 2731 0.393% 99.906% ( 10, 15 ] 706 0.102% 100.008% ( 15, 22 ] 54 0.008% 100.016% ( 22, 34 ] 11 0.002% 100.017% ( 34, 51 ] 1 0.000% 100.017% ( 51, 76 ] 3 0.000% 100.018% ( 110, 170 ] 20 0.003% 100.021% ( 170, 250 ] 17 0.002% 100.023% ( 250, 380 ] 16 0.002% 100.025% ( 380, 580 ] 3 0.000% 100.026% ( 580, 870 ] 15 0.002% 100.028% ( 870, 1300 ] 7 0.001% 100.029% ( 1300, 1900 ] 5 0.001% 100.030% ( 1900, 2900 ] 4 0.001% 100.030% ( 2900, 4400 ] 4 0.001% 100.031% ** Level 1 read latency histogram (micros): Count: 63983 Average: 2.3420 StdDev: 12.81 Min: 0 Median: 1.5178 Max: 1211 Percentiles: P50: 1.52 P75: 1.89 P99: 5.60 P99.9: 12.72 P99.99: 812.25 ------------------------------------------------------ [ 0, 1 ] 9890 15.457% 15.457% ### ( 1, 2 ] 42684 66.711% 82.169% ############# ( 2, 3 ] 7598 11.875% 94.044% ## ( 3, 4 ] 2119 3.312% 97.356% # ( 4, 6 ] 1312 2.051% 99.406% ( 6, 10 ] 273 0.427% 99.833% ( 10, 15 ] 79 0.123% 99.956% ( 15, 22 ] 4 0.006% 99.962% ( 34, 51 ] 1 0.002% 99.964% ( 110, 170 ] 1 0.002% 99.966% ( 170, 250 ] 1 0.002% 99.967% ( 250, 380 ] 8 0.013% 99.980% ( 380, 580 ] 5 0.008% 99.987% ( 580, 870 ] 2 0.003% 99.991% ( 870, 1300 ] 6 0.009% 100.000% ** Level 2 read latency histogram (micros): Count: 47969 Average: 2.3779 StdDev: 21.68 Min: 1 Median: 1.5323 Max: 3749 Percentiles: P50: 1.53 P75: 1.90 P99: 5.80 P99.9: 9.85 P99.99: 420.62 ------------------------------------------------------ [ 0, 1 ] 6526 13.605% 13.605% ### ( 1, 2 ] 32797 68.371% 81.976% ############## ( 2, 3 ] 4979 10.380% 92.355% ## ( 3, 4 ] 2007 4.184% 96.539% # ( 4, 6 ] 1308 2.727% 99.266% # ( 6, 10 ] 316 0.659% 99.925% ( 10, 15 ] 22 0.046% 99.971% ( 15, 22 ] 4 0.008% 99.979% ( 51, 76 ] 1 0.002% 99.981% ( 110, 170 ] 1 0.002% 99.983% ( 250, 380 ] 3 0.006% 99.990% ( 380, 580 ] 1 0.002% 99.992% ( 580, 870 ] 2 0.004% 99.996% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 42740 Average: 3.8551 StdDev: 64.83 Min: 1 Median: 1.3664 Max: 4811 Percentiles: P50: 1.37 P75: 1.76 P99: 5.19 P99.9: 665.95 P99.99: 2881.73 ------------------------------------------------------ [ 0, 1 ] 11342 26.537% 26.537% ##### ( 1, 2 ] 27369 64.036% 90.573% ############# ( 2, 3 ] 2477 5.796% 96.369% # ( 3, 4 ] 864 2.022% 98.390% ( 4, 6 ] 439 1.027% 99.417% ( 6, 10 ] 157 0.367% 99.785% ( 10, 15 ] 25 0.058% 99.843% ( 15, 22 ] 8 0.019% 99.862% ( 22, 34 ] 1 0.002% 99.864% ( 110, 170 ] 1 0.002% 99.867% ( 170, 250 ] 2 0.005% 99.871% ( 250, 380 ] 3 0.007% 99.878% ( 380, 580 ] 6 0.014% 99.892% ( 580, 870 ] 11 0.026% 99.918% ( 870, 1300 ] 9 0.021% 99.939% ( 1300, 1900 ] 7 0.016% 99.956% ( 1900, 2900 ] 15 0.035% 99.991% ( 2900, 4400 ] 3 0.007% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 4 read latency histogram (micros): Count: 305 Average: 118.2426 StdDev: 559.86 Min: 0 Median: 0.9776 Max: 5169 Percentiles: P50: 0.98 P75: 4.44 P99: 3612.50 P99.9: 5169.00 P99.99: 5169.00 ------------------------------------------------------ [ 0, 1 ] 156 51.148% 51.148% ########## ( 1, 2 ] 65 21.311% 72.459% #### ( 2, 3 ] 1 0.328% 72.787% ( 3, 4 ] 3 0.984% 73.770% ( 4, 6 ] 17 5.574% 79.344% # ( 6, 10 ] 37 12.131% 91.475% ## ( 10, 15 ] 1 0.328% 91.803% ( 76, 110 ] 2 0.656% 92.459% ( 110, 170 ] 2 0.656% 93.115% ( 250, 380 ] 1 0.328% 93.443% ( 380, 580 ] 1 0.328% 93.770% ( 580, 870 ] 7 2.295% 96.066% ( 870, 1300 ] 3 0.984% 97.049% ( 1300, 1900 ] 5 1.639% 98.689% ( 2900, 4400 ] 2 0.656% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 724.2750 StdDev: 765.63 Min: 105 Median: 315.0000 Max: 2656 Percentiles: P50: 315.00 P75: 1156.67 P99: 2656.00 P99.9: 2656.00 P99.99: 2656.00 ------------------------------------------------------ ( 76, 110 ] 3 7.500% 7.500% ## ( 110, 170 ] 13 32.500% 40.000% ####### ( 170, 250 ] 2 5.000% 45.000% # ( 250, 380 ] 4 10.000% 55.000% ## ( 380, 580 ] 3 7.500% 62.500% ## ( 580, 870 ] 3 7.500% 70.000% ## ( 870, 1300 ] 3 7.500% 77.500% ## ( 1300, 1900 ] 4 10.000% 87.500% ## ( 1900, 2900 ] 5 12.500% 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, 325.87 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.000 H:M:S, 11.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 328.24 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.364 H:M:S, 12.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/05-16:03:13 ... thread 0: (1000000,4000000) ops and (335249.4,338433.5) ops/second in (2.982854,11.819161) 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.58 GB 232.8 2.5 0.0 2.5 6.2 3.7 0.0 1.7 123.8 312.5 20.35 19.01 63 0.323 2558K 2688 0.0 0.0 L1 5/0 485.30 MB 48.5 1.2 1.0 0.2 1.2 1.0 0.2 1.2 234.2 233.3 5.37 5.21 2 2.683 1276K 4624 0.0 0.0 L2 1/0 4.34 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.6 1.5 248.7 248.6 0.78 0.75 2 0.389 196K 82 0.0 0.0 L3 15/0 897.34 MB 0.9 0.2 0.2 0.0 0.2 0.2 0.6 1.0 225.0 225.0 0.83 0.77 1 0.831 189K 0 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.6 1.0 144.1 144.1 1.17 0.78 1 1.166 170K 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1255/4 99.88 GB 0.0 4.2 1.5 2.8 8.0 5.2 2.7 2.1 151.8 286.4 28.49 26.52 69 0.413 4391K 7394 0.0 0.0 Int 0/0 0.00 KB 0.0 4.2 1.5 2.8 8.0 5.2 2.5 2.1 151.8 286.4 28.49 26.52 69 0.413 4391K 7394 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.2 1.5 2.8 4.2 1.4 0.0 0.0 243.6 243.2 17.75 16.93 15 1.183 4391K 7394 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 357.9 10.74 9.59 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.0 total, 11.8 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: 7.97 GB write, 677.57 MB/s write, 4.22 GB read, 359.13 MB/s read, 28.5 seconds Interval compaction: 7.97 GB write, 690.33 MB/s write, 4.22 GB read, 365.89 MB/s read, 28.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: 19, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 19, interval: 19 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 956435 Average: 2.0772 StdDev: 11.14 Min: 0 Median: 1.4249 Max: 3289 Percentiles: P50: 1.42 P75: 1.82 P99: 5.26 P99.9: 9.89 P99.99: 14.38 ------------------------------------------------------ [ 0, 1 ] 217828 22.775% 22.775% ##### ( 1, 2 ] 612833 64.075% 86.850% ############# ( 2, 3 ] 81156 8.485% 95.335% ## ( 3, 4 ] 25933 2.711% 98.046% # ( 4, 6 ] 14444 1.510% 99.557% ( 6, 10 ] 3376 0.353% 99.910% ( 10, 15 ] 879 0.092% 100.001% ( 15, 22 ] 81 0.008% 100.010% ( 22, 34 ] 14 0.001% 100.011% ( 34, 51 ] 2 0.000% 100.012% ( 51, 76 ] 4 0.000% 100.012% ( 110, 170 ] 30 0.003% 100.015% ( 170, 250 ] 21 0.002% 100.017% ( 250, 380 ] 21 0.002% 100.020% ( 380, 580 ] 5 0.001% 100.020% ( 580, 870 ] 22 0.002% 100.022% ( 870, 1300 ] 13 0.001% 100.024% ( 1300, 1900 ] 6 0.001% 100.024% ( 1900, 2900 ] 6 0.001% 100.025% ( 2900, 4400 ] 4 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 63983 Average: 2.3420 StdDev: 12.81 Min: 0 Median: 1.5178 Max: 1211 Percentiles: P50: 1.52 P75: 1.89 P99: 5.60 P99.9: 12.72 P99.99: 812.25 ------------------------------------------------------ [ 0, 1 ] 9890 15.457% 15.457% ### ( 1, 2 ] 42684 66.711% 82.169% ############# ( 2, 3 ] 7598 11.875% 94.044% ## ( 3, 4 ] 2119 3.312% 97.356% # ( 4, 6 ] 1312 2.051% 99.406% ( 6, 10 ] 273 0.427% 99.833% ( 10, 15 ] 79 0.123% 99.956% ( 15, 22 ] 4 0.006% 99.962% ( 34, 51 ] 1 0.002% 99.964% ( 110, 170 ] 1 0.002% 99.966% ( 170, 250 ] 1 0.002% 99.967% ( 250, 380 ] 8 0.013% 99.980% ( 380, 580 ] 5 0.008% 99.987% ( 580, 870 ] 2 0.003% 99.991% ( 870, 1300 ] 6 0.009% 100.000% ** Level 2 read latency histogram (micros): Count: 47969 Average: 2.3779 StdDev: 21.68 Min: 1 Median: 1.5323 Max: 3749 Percentiles: P50: 1.53 P75: 1.90 P99: 5.80 P99.9: 9.85 P99.99: 420.62 ------------------------------------------------------ [ 0, 1 ] 6526 13.605% 13.605% ### ( 1, 2 ] 32797 68.371% 81.976% ############## ( 2, 3 ] 4979 10.380% 92.355% ## ( 3, 4 ] 2007 4.184% 96.539% # ( 4, 6 ] 1308 2.727% 99.266% # ( 6, 10 ] 316 0.659% 99.925% ( 10, 15 ] 22 0.046% 99.971% ( 15, 22 ] 4 0.008% 99.979% ( 51, 76 ] 1 0.002% 99.981% ( 110, 170 ] 1 0.002% 99.983% ( 250, 380 ] 3 0.006% 99.990% ( 380, 580 ] 1 0.002% 99.992% ( 580, 870 ] 2 0.004% 99.996% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 42740 Average: 3.8551 StdDev: 64.83 Min: 1 Median: 1.3664 Max: 4811 Percentiles: P50: 1.37 P75: 1.76 P99: 5.19 P99.9: 665.95 P99.99: 2881.73 ------------------------------------------------------ [ 0, 1 ] 11342 26.537% 26.537% ##### ( 1, 2 ] 27369 64.036% 90.573% ############# ( 2, 3 ] 2477 5.796% 96.369% # ( 3, 4 ] 864 2.022% 98.390% ( 4, 6 ] 439 1.027% 99.417% ( 6, 10 ] 157 0.367% 99.785% ( 10, 15 ] 25 0.058% 99.843% ( 15, 22 ] 8 0.019% 99.862% ( 22, 34 ] 1 0.002% 99.864% ( 110, 170 ] 1 0.002% 99.867% ( 170, 250 ] 2 0.005% 99.871% ( 250, 380 ] 3 0.007% 99.878% ( 380, 580 ] 6 0.014% 99.892% ( 580, 870 ] 11 0.026% 99.918% ( 870, 1300 ] 9 0.021% 99.939% ( 1300, 1900 ] 7 0.016% 99.956% ( 1900, 2900 ] 15 0.035% 99.991% ( 2900, 4400 ] 3 0.007% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 4 read latency histogram (micros): Count: 305 Average: 118.2426 StdDev: 559.86 Min: 0 Median: 0.9776 Max: 5169 Percentiles: P50: 0.98 P75: 4.44 P99: 3612.50 P99.9: 5169.00 P99.99: 5169.00 ------------------------------------------------------ [ 0, 1 ] 156 51.148% 51.148% ########## ( 1, 2 ] 65 21.311% 72.459% #### ( 2, 3 ] 1 0.328% 72.787% ( 3, 4 ] 3 0.984% 73.770% ( 4, 6 ] 17 5.574% 79.344% # ( 6, 10 ] 37 12.131% 91.475% ## ( 10, 15 ] 1 0.328% 91.803% ( 76, 110 ] 2 0.656% 92.459% ( 110, 170 ] 2 0.656% 93.115% ( 250, 380 ] 1 0.328% 93.443% ( 380, 580 ] 1 0.328% 93.770% ( 580, 870 ] 7 2.295% 96.066% ( 870, 1300 ] 3 0.984% 97.049% ( 1300, 1900 ] 5 1.639% 98.689% ( 2900, 4400 ] 2 0.656% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 724.2750 StdDev: 765.63 Min: 105 Median: 315.0000 Max: 2656 Percentiles: P50: 315.00 P75: 1156.67 P99: 2656.00 P99.9: 2656.00 P99.99: 2656.00 ------------------------------------------------------ ( 76, 110 ] 3 7.500% 7.500% ## ( 110, 170 ] 13 32.500% 40.000% ####### ( 170, 250 ] 2 5.000% 45.000% # ( 250, 380 ] 4 10.000% 55.000% ## ( 380, 580 ] 3 7.500% 62.500% ## ( 580, 870 ] 3 7.500% 70.000% ## ( 870, 1300 ] 3 7.500% 77.500% ## ( 1300, 1900 ] 4 10.000% 87.500% ## ( 1900, 2900 ] 5 12.500% 100.000% ### ** DB Stats ** Uptime(secs): 12.0 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 326.88 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.372 H:M:S, 11.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 329.95 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.373 H:M:S, 12.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/05-16:03:16 ... thread 0: (1000000,5000000) ops and (335607.9,337864.6) ops/second in (2.979668,14.798829) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/4 3.50 GB 333.5 3.3 0.0 3.3 8.0 4.7 0.0 1.7 129.8 312.3 26.21 24.55 79 0.332 3453K 3651 0.0 0.0 L1 5/0 485.30 MB 48.5 1.2 1.0 0.2 1.2 1.0 0.2 1.2 234.2 233.3 5.37 5.21 2 2.683 1276K 4624 0.0 0.0 L2 1/0 4.34 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.6 1.5 248.7 248.6 0.78 0.75 2 0.389 196K 82 0.0 0.0 L3 15/0 897.34 MB 0.9 0.2 0.2 0.0 0.2 0.2 0.6 1.0 225.0 225.0 0.83 0.77 1 0.831 189K 0 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.6 1.0 144.1 144.1 1.17 0.78 1 1.166 170K 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1259/4 100.80 GB 0.0 5.1 1.5 3.6 9.8 6.1 2.7 2.1 151.6 290.7 34.35 32.07 85 0.404 5287K 8357 0.0 0.0 Int 0/0 0.00 KB 0.0 5.1 1.5 3.6 9.8 6.1 2.5 2.1 151.6 290.7 34.35 32.07 85 0.404 5287K 8357 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.1 1.5 3.6 5.1 1.4 0.0 0.0 247.4 247.0 21.05 20.17 18 1.169 5287K 8357 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 360.0 13.30 11.89 67 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.0 total, 14.8 interval Flush(GB): cumulative 4.675, interval 4.675 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.75 GB write, 664.72 MB/s write, 5.08 GB read, 346.61 MB/s read, 34.3 seconds Interval compaction: 9.75 GB write, 674.71 MB/s write, 5.08 GB read, 351.82 MB/s read, 34.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 24, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 24, interval: 24 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1220253 Average: 2.0433 StdDev: 10.99 Min: 0 Median: 1.4047 Max: 3289 Percentiles: P50: 1.40 P75: 1.80 P99: 5.13 P99.9: 9.83 P99.99: 14.50 ------------------------------------------------------ [ 0, 1 ] 295119 24.185% 24.185% ##### ( 1, 2 ] 778308 63.783% 87.968% ############# ( 2, 3 ] 94845 7.773% 95.740% ## ( 3, 4 ] 30539 2.503% 98.243% # ( 4, 6 ] 16398 1.344% 99.587% ( 6, 10 ] 3991 0.327% 99.914% ( 10, 15 ] 1035 0.085% 99.999% ( 15, 22 ] 110 0.009% 100.008% ( 22, 34 ] 17 0.001% 100.009% ( 34, 51 ] 3 0.000% 100.009% ( 51, 76 ] 5 0.000% 100.010% ( 110, 170 ] 37 0.003% 100.013% ( 170, 250 ] 27 0.002% 100.015% ( 250, 380 ] 25 0.002% 100.017% ( 380, 580 ] 6 0.000% 100.017% ( 580, 870 ] 25 0.002% 100.019% ( 870, 1300 ] 19 0.002% 100.021% ( 1300, 1900 ] 10 0.001% 100.022% ( 1900, 2900 ] 6 0.000% 100.022% ( 2900, 4400 ] 5 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 63983 Average: 2.3420 StdDev: 12.81 Min: 0 Median: 1.5178 Max: 1211 Percentiles: P50: 1.52 P75: 1.89 P99: 5.60 P99.9: 12.72 P99.99: 812.25 ------------------------------------------------------ [ 0, 1 ] 9890 15.457% 15.457% ### ( 1, 2 ] 42684 66.711% 82.169% ############# ( 2, 3 ] 7598 11.875% 94.044% ## ( 3, 4 ] 2119 3.312% 97.356% # ( 4, 6 ] 1312 2.051% 99.406% ( 6, 10 ] 273 0.427% 99.833% ( 10, 15 ] 79 0.123% 99.956% ( 15, 22 ] 4 0.006% 99.962% ( 34, 51 ] 1 0.002% 99.964% ( 110, 170 ] 1 0.002% 99.966% ( 170, 250 ] 1 0.002% 99.967% ( 250, 380 ] 8 0.013% 99.980% ( 380, 580 ] 5 0.008% 99.987% ( 580, 870 ] 2 0.003% 99.991% ( 870, 1300 ] 6 0.009% 100.000% ** Level 2 read latency histogram (micros): Count: 47969 Average: 2.3779 StdDev: 21.68 Min: 1 Median: 1.5323 Max: 3749 Percentiles: P50: 1.53 P75: 1.90 P99: 5.80 P99.9: 9.85 P99.99: 420.62 ------------------------------------------------------ [ 0, 1 ] 6526 13.605% 13.605% ### ( 1, 2 ] 32797 68.371% 81.976% ############## ( 2, 3 ] 4979 10.380% 92.355% ## ( 3, 4 ] 2007 4.184% 96.539% # ( 4, 6 ] 1308 2.727% 99.266% # ( 6, 10 ] 316 0.659% 99.925% ( 10, 15 ] 22 0.046% 99.971% ( 15, 22 ] 4 0.008% 99.979% ( 51, 76 ] 1 0.002% 99.981% ( 110, 170 ] 1 0.002% 99.983% ( 250, 380 ] 3 0.006% 99.990% ( 380, 580 ] 1 0.002% 99.992% ( 580, 870 ] 2 0.004% 99.996% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 42740 Average: 3.8551 StdDev: 64.83 Min: 1 Median: 1.3664 Max: 4811 Percentiles: P50: 1.37 P75: 1.76 P99: 5.19 P99.9: 665.95 P99.99: 2881.73 ------------------------------------------------------ [ 0, 1 ] 11342 26.537% 26.537% ##### ( 1, 2 ] 27369 64.036% 90.573% ############# ( 2, 3 ] 2477 5.796% 96.369% # ( 3, 4 ] 864 2.022% 98.390% ( 4, 6 ] 439 1.027% 99.417% ( 6, 10 ] 157 0.367% 99.785% ( 10, 15 ] 25 0.058% 99.843% ( 15, 22 ] 8 0.019% 99.862% ( 22, 34 ] 1 0.002% 99.864% ( 110, 170 ] 1 0.002% 99.867% ( 170, 250 ] 2 0.005% 99.871% ( 250, 380 ] 3 0.007% 99.878% ( 380, 580 ] 6 0.014% 99.892% ( 580, 870 ] 11 0.026% 99.918% ( 870, 1300 ] 9 0.021% 99.939% ( 1300, 1900 ] 7 0.016% 99.956% ( 1900, 2900 ] 15 0.035% 99.991% ( 2900, 4400 ] 3 0.007% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 4 read latency histogram (micros): Count: 305 Average: 118.2426 StdDev: 559.86 Min: 0 Median: 0.9776 Max: 5169 Percentiles: P50: 0.98 P75: 4.44 P99: 3612.50 P99.9: 5169.00 P99.99: 5169.00 ------------------------------------------------------ [ 0, 1 ] 156 51.148% 51.148% ########## ( 1, 2 ] 65 21.311% 72.459% #### ( 2, 3 ] 1 0.328% 72.787% ( 3, 4 ] 3 0.984% 73.770% ( 4, 6 ] 17 5.574% 79.344% # ( 6, 10 ] 37 12.131% 91.475% ## ( 10, 15 ] 1 0.328% 91.803% ( 76, 110 ] 2 0.656% 92.459% ( 110, 170 ] 2 0.656% 93.115% ( 250, 380 ] 1 0.328% 93.443% ( 380, 580 ] 1 0.328% 93.770% ( 580, 870 ] 7 2.295% 96.066% ( 870, 1300 ] 3 0.984% 97.049% ( 1300, 1900 ] 5 1.639% 98.689% ( 2900, 4400 ] 2 0.656% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 724.2750 StdDev: 765.63 Min: 105 Median: 315.0000 Max: 2656 Percentiles: P50: 315.00 P75: 1156.67 P99: 2656.00 P99.9: 2656.00 P99.99: 2656.00 ------------------------------------------------------ ( 76, 110 ] 3 7.500% 7.500% ## ( 110, 170 ] 13 32.500% 40.000% ####### ( 170, 250 ] 2 5.000% 45.000% # ( 250, 380 ] 4 10.000% 55.000% ## ( 380, 580 ] 3 7.500% 62.500% ## ( 580, 870 ] 3 7.500% 70.000% ## ( 870, 1300 ] 3 7.500% 77.500% ## ( 1300, 1900 ] 4 10.000% 87.500% ## ( 1900, 2900 ] 5 12.500% 100.000% ### ** DB Stats ** Uptime(secs): 15.0 total, 3.0 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 327.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:1.755 H:M:S, 11.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 330.30 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.383 H:M:S, 12.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/05-16:03:24 ... thread 0: (1000000,6000000) ops and (115498.8,255788.0) ops/second in (8.658095,23.456924) 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/15 4.55 GB 100.4 5.2 0.0 5.2 10.9 5.7 0.0 1.9 146.7 307.1 36.49 34.42 100 0.365 5436K 7508 0.0 0.0 L1 5/5 485.30 MB 0.0 1.2 1.0 0.2 1.2 1.0 0.2 1.2 234.2 233.3 5.37 5.21 2 2.683 1276K 4624 0.0 0.0 L2 1/0 4.34 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.6 1.5 248.7 248.6 0.78 0.75 2 0.389 196K 82 0.0 0.0 L3 15/0 897.34 MB 0.9 0.2 0.2 0.0 0.2 0.2 0.6 1.0 225.0 225.0 0.83 0.77 1 0.831 189K 0 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.6 1.0 144.1 144.1 1.17 0.78 1 1.166 170K 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1260/20 101.85 GB 0.0 7.0 1.5 5.5 12.7 7.2 2.7 2.2 160.4 291.4 44.63 41.93 106 0.421 7269K 12K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.0 1.5 5.5 12.7 7.2 2.5 2.2 160.4 291.4 44.63 41.93 106 0.421 7269K 12K 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 7.0 1.5 5.5 7.0 1.4 0.0 0.0 253.0 252.5 28.30 27.33 23 1.231 7269K 12K 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 358.8 16.33 14.60 83 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): 23.7 total, 23.5 interval Flush(GB): cumulative 5.721, interval 5.721 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: 12.70 GB write, 549.18 MB/s write, 6.99 GB read, 302.31 MB/s read, 44.6 seconds Interval compaction: 12.70 GB write, 554.39 MB/s write, 6.99 GB read, 305.18 MB/s read, 44.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: 25, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 8, total-stops: 25, interval: 33 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2150940 Average: 2.0899 StdDev: 9.45 Min: 0 Median: 1.4319 Max: 3289 Percentiles: P50: 1.43 P75: 1.82 P99: 5.29 P99.9: 10.17 P99.99: 40.48 ------------------------------------------------------ [ 0, 1 ] 470212 21.861% 21.861% #### ( 1, 2 ] 1401435 65.155% 87.015% ############# ( 2, 3 ] 183399 8.526% 95.542% ## ( 3, 4 ] 54941 2.554% 98.096% # ( 4, 6 ] 30069 1.398% 99.494% ( 6, 10 ] 8675 0.403% 99.897% ( 10, 15 ] 1781 0.083% 99.980% ( 15, 22 ] 191 0.009% 99.989% ( 22, 34 ] 21 0.001% 99.990% ( 34, 51 ] 5 0.000% 99.990% ( 51, 76 ] 14 0.001% 99.991% ( 76, 110 ] 159 0.007% 99.998% ( 110, 170 ] 236 0.011% 100.009% ( 170, 250 ] 82 0.004% 100.013% ( 250, 380 ] 53 0.002% 100.015% ( 380, 580 ] 33 0.002% 100.017% ( 580, 870 ] 42 0.002% 100.019% ( 870, 1300 ] 28 0.001% 100.020% ( 1300, 1900 ] 11 0.001% 100.021% ( 1900, 2900 ] 7 0.000% 100.021% ( 2900, 4400 ] 5 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 67302 Average: 2.4907 StdDev: 14.41 Min: 0 Median: 1.5172 Max: 1211 Percentiles: P50: 1.52 P75: 1.89 P99: 5.72 P99.9: 94.10 P99.99: 886.57 ------------------------------------------------------ [ 0, 1 ] 10496 15.595% 15.595% ### ( 1, 2 ] 44768 66.518% 82.113% ############# ( 2, 3 ] 7970 11.842% 93.956% ## ( 3, 4 ] 2209 3.282% 97.238% # ( 4, 6 ] 1378 2.047% 99.285% ( 6, 10 ] 309 0.459% 99.744% ( 10, 15 ] 80 0.119% 99.863% ( 15, 22 ] 4 0.006% 99.869% ( 34, 51 ] 1 0.001% 99.871% ( 76, 110 ] 37 0.055% 99.926% ( 110, 170 ] 12 0.018% 99.944% ( 170, 250 ] 8 0.012% 99.955% ( 250, 380 ] 12 0.018% 99.973% ( 380, 580 ] 8 0.012% 99.985% ( 580, 870 ] 3 0.004% 99.990% ( 870, 1300 ] 7 0.010% 100.000% ** Level 2 read latency histogram (micros): Count: 47969 Average: 2.3779 StdDev: 21.68 Min: 1 Median: 1.5323 Max: 3749 Percentiles: P50: 1.53 P75: 1.90 P99: 5.80 P99.9: 9.85 P99.99: 420.62 ------------------------------------------------------ [ 0, 1 ] 6526 13.605% 13.605% ### ( 1, 2 ] 32797 68.371% 81.976% ############## ( 2, 3 ] 4979 10.380% 92.355% ## ( 3, 4 ] 2007 4.184% 96.539% # ( 4, 6 ] 1308 2.727% 99.266% # ( 6, 10 ] 316 0.659% 99.925% ( 10, 15 ] 22 0.046% 99.971% ( 15, 22 ] 4 0.008% 99.979% ( 51, 76 ] 1 0.002% 99.981% ( 110, 170 ] 1 0.002% 99.983% ( 250, 380 ] 3 0.006% 99.990% ( 380, 580 ] 1 0.002% 99.992% ( 580, 870 ] 2 0.004% 99.996% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 42740 Average: 3.8551 StdDev: 64.83 Min: 1 Median: 1.3664 Max: 4811 Percentiles: P50: 1.37 P75: 1.76 P99: 5.19 P99.9: 665.95 P99.99: 2881.73 ------------------------------------------------------ [ 0, 1 ] 11342 26.537% 26.537% ##### ( 1, 2 ] 27369 64.036% 90.573% ############# ( 2, 3 ] 2477 5.796% 96.369% # ( 3, 4 ] 864 2.022% 98.390% ( 4, 6 ] 439 1.027% 99.417% ( 6, 10 ] 157 0.367% 99.785% ( 10, 15 ] 25 0.058% 99.843% ( 15, 22 ] 8 0.019% 99.862% ( 22, 34 ] 1 0.002% 99.864% ( 110, 170 ] 1 0.002% 99.867% ( 170, 250 ] 2 0.005% 99.871% ( 250, 380 ] 3 0.007% 99.878% ( 380, 580 ] 6 0.014% 99.892% ( 580, 870 ] 11 0.026% 99.918% ( 870, 1300 ] 9 0.021% 99.939% ( 1300, 1900 ] 7 0.016% 99.956% ( 1900, 2900 ] 15 0.035% 99.991% ( 2900, 4400 ] 3 0.007% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 4 read latency histogram (micros): Count: 305 Average: 118.2426 StdDev: 559.86 Min: 0 Median: 0.9776 Max: 5169 Percentiles: P50: 0.98 P75: 4.44 P99: 3612.50 P99.9: 5169.00 P99.99: 5169.00 ------------------------------------------------------ [ 0, 1 ] 156 51.148% 51.148% ########## ( 1, 2 ] 65 21.311% 72.459% #### ( 2, 3 ] 1 0.328% 72.787% ( 3, 4 ] 3 0.984% 73.770% ( 4, 6 ] 17 5.574% 79.344% # ( 6, 10 ] 37 12.131% 91.475% ## ( 10, 15 ] 1 0.328% 91.803% ( 76, 110 ] 2 0.656% 92.459% ( 110, 170 ] 2 0.656% 93.115% ( 250, 380 ] 1 0.328% 93.443% ( 380, 580 ] 1 0.328% 93.770% ( 580, 870 ] 7 2.295% 96.066% ( 870, 1300 ] 3 0.984% 97.049% ( 1300, 1900 ] 5 1.639% 98.689% ( 2900, 4400 ] 2 0.656% 99.344% ( 4400, 6600 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 724.2750 StdDev: 765.63 Min: 105 Median: 315.0000 Max: 2656 Percentiles: P50: 315.00 P75: 1156.67 P99: 2656.00 P99.9: 2656.00 P99.99: 2656.00 ------------------------------------------------------ ( 76, 110 ] 3 7.500% 7.500% ## ( 110, 170 ] 13 32.500% 40.000% ####### ( 170, 250 ] 2 5.000% 45.000% # ( 250, 380 ] 4 10.000% 55.000% ## ( 380, 580 ] 3 7.500% 62.500% ## ( 580, 870 ] 3 7.500% 70.000% ## ( 870, 1300 ] 3 7.500% 77.500% ## ( 1300, 1900 ] 4 10.000% 87.500% ## ( 1900, 2900 ] 5 12.500% 100.000% ### ** DB Stats ** Uptime(secs): 23.7 total, 8.7 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 249.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:7.533 H:M:S, 31.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 113.67 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.777 H:M:S, 66.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 2024/12/05-16:03:38 ... thread 0: (1000000,7000000) ops and (70791.3,186254.7) ops/second in (14.126021,37.582945) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/8 1.84 GB 6.3 5.7 0.0 5.7 12.3 6.6 0.0 1.9 138.3 297.3 42.35 38.69 114 0.371 5947K 7987 0.0 0.0 L1 9/9 963.37 MB 0.0 5.3 4.5 0.7 5.2 4.5 0.2 1.1 217.5 214.0 24.80 23.01 3 8.265 5475K 85K 0.0 0.0 L2 13/9 1.63 GB 5.2 0.2 0.1 0.1 0.2 0.1 3.6 1.5 248.7 248.6 0.78 0.75 2 0.389 196K 82 0.0 0.0 L3 20/5 1.50 GB 0.9 0.9 0.4 0.5 0.9 0.4 1.7 2.1 173.1 172.3 5.44 4.21 3 1.812 955K 4254 0.0 0.0 L4 173/6 9.78 GB 1.0 0.7 0.7 0.0 0.7 0.7 0.8 1.0 136.5 136.4 5.36 3.37 7 0.766 722K 138 0.0 0.0 L5 1056/0 86.92 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1280/37 102.62 GB 0.0 12.8 5.8 7.0 19.3 12.3 7.7 2.9 166.6 251.0 78.72 70.03 129 0.610 13M 98K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.8 5.8 7.0 19.3 12.3 7.6 2.9 166.6 251.0 78.72 70.03 129 0.610 13M 98K 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 12.8 5.8 7.0 12.7 5.7 0.0 0.0 224.3 222.6 58.47 53.07 34 1.720 13M 98K 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 332.8 20.25 16.97 95 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): 37.8 total, 37.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: 19.29 GB write, 522.60 MB/s write, 12.81 GB read, 346.94 MB/s read, 78.7 seconds Interval compaction: 19.29 GB write, 525.70 MB/s write, 12.81 GB read, 349.00 MB/s read, 78.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 37, pending-compaction-bytes-delays: 5, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 37, interval: 54 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2854380 Average: 2.6537 StdDev: 23.41 Min: 0 Median: 1.4387 Max: 7504 Percentiles: P50: 1.44 P75: 1.83 P99: 5.95 P99.9: 137.54 P99.99: 353.86 ------------------------------------------------------ [ 0, 1 ] 629464 22.053% 22.053% #### ( 1, 2 ] 1818288 63.702% 85.754% ############# ( 2, 3 ] 245169 8.589% 94.343% ## ( 3, 4 ] 81483 2.855% 97.198% # ( 4, 6 ] 52707 1.847% 99.045% ( 6, 10 ] 14845 0.520% 99.565% ( 10, 15 ] 2989 0.105% 99.669% ( 15, 22 ] 414 0.015% 99.684% ( 22, 34 ] 34 0.001% 99.685% ( 34, 51 ] 8 0.000% 99.685% ( 51, 76 ] 69 0.002% 99.688% ( 76, 110 ] 4596 0.161% 99.849% ( 110, 170 ] 3184 0.112% 99.960% ( 170, 250 ] 515 0.018% 99.978% ( 250, 380 ] 415 0.015% 99.993% ( 380, 580 ] 376 0.013% 100.006% ( 580, 870 ] 154 0.005% 100.012% ( 870, 1300 ] 63 0.002% 100.014% ( 1300, 1900 ] 34 0.001% 100.015% ( 1900, 2900 ] 36 0.001% 100.016% ( 2900, 4400 ] 40 0.001% 100.018% ( 4400, 6600 ] 11 0.000% 100.018% ( 6600, 9900 ] 2 0.000% 100.018% ** Level 1 read latency histogram (micros): Count: 746756 Average: 5.7682 StdDev: 88.17 Min: 0 Median: 1.8158 Max: 11689 Percentiles: P50: 1.82 P75: 2.75 P99: 9.26 P99.9: 93.94 P99.99: 157.85 ------------------------------------------------------ [ 0, 1 ] 56362 7.548% 7.548% ## ( 1, 2 ] 388599 52.038% 59.586% ########## ( 2, 3 ] 153982 20.620% 80.206% #### ( 3, 4 ] 64767 8.673% 88.879% ## ( 4, 6 ] 62704 8.397% 97.276% ## ( 6, 10 ] 15803 2.116% 99.392% ( 10, 15 ] 3032 0.406% 99.798% ( 15, 22 ] 393 0.053% 99.851% ( 22, 34 ] 27 0.004% 99.854% ( 34, 51 ] 8 0.001% 99.856% ( 51, 76 ] 42 0.006% 99.861% ( 76, 110 ] 550 0.074% 99.935% ( 110, 170 ] 517 0.069% 100.004% ( 170, 250 ] 210 0.028% 100.032% ( 250, 380 ] 272 0.036% 100.069% ( 380, 580 ] 337 0.045% 100.114% ( 580, 870 ] 321 0.043% 100.157% ( 870, 1300 ] 217 0.029% 100.186% ( 1300, 1900 ] 112 0.015% 100.201% ( 1900, 2900 ] 104 0.014% 100.215% ( 2900, 4400 ] 175 0.023% 100.238% ( 4400, 6600 ] 47 0.006% 100.244% ( 6600, 9900 ] 12 0.002% 100.246% ( 9900, 14000 ] 1 0.000% 100.246% ** Level 2 read latency histogram (micros): Count: 77314 Average: 4.1156 StdDev: 46.84 Min: 1 Median: 1.6708 Max: 4153 Percentiles: P50: 1.67 P75: 2.29 P99: 8.55 P99.9: 554.70 P99.99: 2322.87 ------------------------------------------------------ [ 0, 1 ] 6762 8.746% 8.746% ## ( 1, 2 ] 47549 61.501% 70.247% ############ ( 2, 3 ] 12642 16.352% 86.599% ### ( 3, 4 ] 4840 6.260% 92.859% # ( 4, 6 ] 4070 5.264% 98.123% # ( 6, 10 ] 1065 1.377% 99.501% ( 10, 15 ] 166 0.215% 99.715% ( 15, 22 ] 21 0.027% 99.743% ( 22, 34 ] 1 0.001% 99.744% ( 51, 76 ] 1 0.001% 99.745% ( 76, 110 ] 1 0.001% 99.746% ( 110, 170 ] 16 0.021% 99.767% ( 170, 250 ] 23 0.030% 99.797% ( 250, 380 ] 43 0.056% 99.853% ( 380, 580 ] 42 0.054% 99.907% ( 580, 870 ] 35 0.045% 99.952% ( 870, 1300 ] 22 0.028% 99.981% ( 1300, 1900 ] 6 0.008% 99.988% ( 1900, 2900 ] 3 0.004% 99.992% ( 2900, 4400 ] 6 0.008% 100.000% ** Level 3 read latency histogram (micros): Count: 178306 Average: 5.3072 StdDev: 77.77 Min: 1 Median: 1.8306 Max: 7856 Percentiles: P50: 1.83 P75: 2.78 P99: 8.91 P99.9: 305.97 P99.99: 798.15 ------------------------------------------------------ [ 0, 1 ] 12617 7.076% 7.076% # ( 1, 2 ] 92149 51.680% 58.756% ########## ( 2, 3 ] 37206 20.866% 79.623% #### ( 3, 4 ] 16605 9.313% 88.935% ## ( 4, 6 ] 15657 8.781% 97.716% ## ( 6, 10 ] 3143 1.763% 99.479% ( 10, 15 ] 596 0.334% 99.813% ( 15, 22 ] 94 0.053% 99.866% ( 22, 34 ] 4 0.002% 99.868% ( 34, 51 ] 5 0.003% 99.871% ( 110, 170 ] 6 0.003% 99.874% ( 170, 250 ] 19 0.011% 99.885% ( 250, 380 ] 62 0.035% 99.920% ( 380, 580 ] 68 0.038% 99.958% ( 580, 870 ] 76 0.043% 100.001% ( 870, 1300 ] 51 0.029% 100.029% ( 1300, 1900 ] 29 0.016% 100.045% ( 1900, 2900 ] 42 0.024% 100.069% ( 2900, 4400 ] 27 0.015% 100.084% ( 4400, 6600 ] 6 0.003% 100.087% ( 6600, 9900 ] 3 0.002% 100.089% ** Level 4 read latency histogram (micros): Count: 8653 Average: 97.8172 StdDev: 405.94 Min: 0 Median: 2.1293 Max: 6432 Percentiles: P50: 2.13 P75: 3.49 P99: 2171.09 P99.9: 4315.33 P99.99: 6013.76 ------------------------------------------------------ [ 0, 1 ] 304 3.513% 3.513% # ( 1, 2 ] 3768 43.546% 47.059% ######### ( 2, 3 ] 1968 22.744% 69.802% ##### ( 3, 4 ] 920 10.632% 80.435% ## ( 4, 6 ] 608 7.026% 87.461% # ( 6, 10 ] 233 2.693% 90.154% # ( 10, 15 ] 31 0.358% 90.512% ( 15, 22 ] 4 0.046% 90.558% ( 22, 34 ] 3 0.035% 90.593% ( 34, 51 ] 2 0.023% 90.616% ( 76, 110 ] 4 0.046% 90.662% ( 110, 170 ] 15 0.173% 90.836% ( 170, 250 ] 59 0.682% 91.517% ( 250, 380 ] 90 1.040% 92.557% ( 380, 580 ] 144 1.664% 94.222% ( 580, 870 ] 168 1.942% 96.163% ( 870, 1300 ] 150 1.734% 97.897% ( 1300, 1900 ] 83 0.959% 98.856% ( 1900, 2900 ] 46 0.532% 99.387% ( 2900, 4400 ] 47 0.543% 99.931% ( 4400, 6600 ] 7 0.081% 100.012% ** Level 5 read latency histogram (micros): Count: 80 Average: 1047.6125 StdDev: 1086.07 Min: 105 Median: 560.0000 Max: 5085 Percentiles: P50: 560.00 P75: 1600.00 P99: 4840.00 P99.9: 5085.00 P99.99: 5085.00 ------------------------------------------------------ ( 76, 110 ] 3 3.750% 3.750% # ( 110, 170 ] 14 17.500% 21.250% #### ( 170, 250 ] 3 3.750% 25.000% # ( 250, 380 ] 11 13.750% 38.750% ### ( 380, 580 ] 10 12.500% 51.250% ### ( 580, 870 ] 10 12.500% 63.750% ### ( 870, 1300 ] 5 6.250% 70.000% # ( 1300, 1900 ] 8 10.000% 80.000% ## ( 1900, 2900 ] 9 11.250% 91.250% ## ( 2900, 4400 ] 6 7.500% 98.750% ## ( 4400, 6600 ] 1 1.250% 100.000% ** DB Stats ** Uptime(secs): 37.8 total, 14.1 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 182.22 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:18.366 H:M:S, 48.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 69.67 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:10.833 H:M:S, 76.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 7 num-running-flushes: 1 2024/12/05-16:03:43 ... thread 0: (1000000,8000000) ops and (199313.4,187792.7) ops/second in (5.017223,42.600168) 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 12/8 2.82 GB 113.2 6.8 0.0 6.8 14.3 7.6 0.0 1.9 134.0 283.7 51.71 45.57 129 0.401 7035K 9436 0.0 0.0 L1 9/9 963.37 MB 0.0 5.3 4.5 0.7 5.2 4.5 0.2 1.1 217.5 214.0 24.80 23.01 3 8.265 5475K 85K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 3.6 1.5 248.7 248.6 0.78 0.75 2 0.389 196K 82 0.0 0.0 L3 14/0 944.84 MB 0.9 3.3 2.1 1.2 3.3 2.1 1.7 1.6 156.9 156.0 21.41 15.43 10 2.141 3413K 20K 0.0 0.0 L4 177/0 9.70 GB 1.0 3.0 2.9 0.1 3.0 2.9 0.9 1.0 126.9 126.7 24.23 14.30 37 0.655 3055K 2646 0.0 0.0 L5 1084/0 89.20 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1296/17 103.58 GB 0.0 18.5 9.6 8.9 26.0 17.1 10.0 3.4 154.2 216.2 122.93 99.07 181 0.679 19M 118K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.5 9.6 8.9 26.0 17.1 9.9 3.4 154.2 216.2 122.93 99.07 181 0.679 19M 118K 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 18.5 9.6 8.9 18.4 9.5 0.0 0.0 193.1 191.9 98.14 79.43 74 1.326 19M 118K 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 312.6 24.79 19.64 107 0.232 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): 42.8 total, 42.6 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.95 GB write, 620.62 MB/s write, 18.51 GB read, 442.52 MB/s read, 122.9 seconds Interval compaction: 25.95 GB write, 623.86 MB/s write, 18.51 GB read, 444.83 MB/s read, 122.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 65, pending-compaction-bytes-delays: 5, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 65, interval: 82 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3311539 Average: 2.7924 StdDev: 28.89 Min: 0 Median: 1.4839 Max: 9062 Percentiles: P50: 1.48 P75: 1.88 P99: 6.63 P99.9: 131.31 P99.99: 347.45 ------------------------------------------------------ [ 0, 1 ] 651071 19.661% 19.661% #### ( 1, 2 ] 2076225 62.697% 82.357% ############# ( 2, 3 ] 337630 10.196% 92.553% ## ( 3, 4 ] 120650 3.643% 96.196% # ( 4, 6 ] 89284 2.696% 98.892% # ( 6, 10 ] 22588 0.682% 99.574% ( 10, 15 ] 4325 0.131% 99.705% ( 15, 22 ] 560 0.017% 99.722% ( 22, 34 ] 51 0.002% 99.724% ( 34, 51 ] 8 0.000% 99.724% ( 51, 76 ] 72 0.002% 99.726% ( 76, 110 ] 4614 0.139% 99.865% ( 110, 170 ] 3239 0.098% 99.963% ( 170, 250 ] 559 0.017% 99.980% ( 250, 380 ] 444 0.013% 99.993% ( 380, 580 ] 433 0.013% 100.006% ( 580, 870 ] 191 0.006% 100.012% ( 870, 1300 ] 106 0.003% 100.015% ( 1300, 1900 ] 57 0.002% 100.017% ( 1900, 2900 ] 62 0.002% 100.019% ( 2900, 4400 ] 78 0.002% 100.021% ( 4400, 6600 ] 20 0.001% 100.022% ( 6600, 9900 ] 5 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 983741 Average: 6.4059 StdDev: 100.44 Min: 0 Median: 1.8478 Max: 11689 Percentiles: P50: 1.85 P75: 2.79 P99: 9.38 P99.9: 112.29 P99.99: 293.73 ------------------------------------------------------ [ 0, 1 ] 61306 6.232% 6.232% # ( 1, 2 ] 507854 51.625% 57.857% ########## ( 2, 3 ] 212390 21.590% 79.447% #### ( 3, 4 ] 88168 8.963% 88.409% ## ( 4, 6 ] 85591 8.701% 97.110% ## ( 6, 10 ] 21985 2.235% 99.345% ( 10, 15 ] 4226 0.430% 99.774% ( 15, 22 ] 520 0.053% 99.827% ( 22, 34 ] 35 0.004% 99.831% ( 34, 51 ] 11 0.001% 99.832% ( 51, 76 ] 44 0.004% 99.836% ( 76, 110 ] 607 0.062% 99.898% ( 110, 170 ] 557 0.057% 99.955% ( 170, 250 ] 243 0.025% 99.979% ( 250, 380 ] 317 0.032% 100.011% ( 380, 580 ] 427 0.043% 100.055% ( 580, 870 ] 439 0.045% 100.100% ( 870, 1300 ] 309 0.031% 100.131% ( 1300, 1900 ] 155 0.016% 100.147% ( 1900, 2900 ] 215 0.022% 100.169% ( 2900, 4400 ] 298 0.030% 100.199% ( 4400, 6600 ] 88 0.009% 100.208% ( 6600, 9900 ] 19 0.002% 100.210% ( 9900, 14000 ] 2 0.000% 100.210% ** Level 2 read latency histogram (micros): Count: 77314 Average: 4.1156 StdDev: 46.84 Min: 1 Median: 1.6708 Max: 4153 Percentiles: P50: 1.67 P75: 2.29 P99: 8.55 P99.9: 554.70 P99.99: 2322.87 ------------------------------------------------------ [ 0, 1 ] 6762 8.746% 8.746% ## ( 1, 2 ] 47549 61.501% 70.247% ############ ( 2, 3 ] 12642 16.352% 86.599% ### ( 3, 4 ] 4840 6.260% 92.859% # ( 4, 6 ] 4070 5.264% 98.123% # ( 6, 10 ] 1065 1.377% 99.501% ( 10, 15 ] 166 0.215% 99.715% ( 15, 22 ] 21 0.027% 99.743% ( 22, 34 ] 1 0.001% 99.744% ( 51, 76 ] 1 0.001% 99.745% ( 76, 110 ] 1 0.001% 99.746% ( 110, 170 ] 16 0.021% 99.767% ( 170, 250 ] 23 0.030% 99.797% ( 250, 380 ] 43 0.056% 99.853% ( 380, 580 ] 42 0.054% 99.907% ( 580, 870 ] 35 0.045% 99.952% ( 870, 1300 ] 22 0.028% 99.981% ( 1300, 1900 ] 6 0.008% 99.988% ( 1900, 2900 ] 3 0.004% 99.992% ( 2900, 4400 ] 6 0.008% 100.000% ** Level 3 read latency histogram (micros): Count: 770156 Average: 6.0373 StdDev: 89.12 Min: 1 Median: 1.9893 Max: 8988 Percentiles: P50: 1.99 P75: 2.96 P99: 8.78 P99.9: 13.99 P99.99: 16.32 ------------------------------------------------------ [ 0, 1 ] 16633 2.160% 2.160% ( 1, 2 ] 372415 48.356% 50.515% ########## ( 2, 3 ] 195571 25.394% 75.909% ##### ( 3, 4 ] 85701 11.128% 87.037% ## ( 4, 6 ] 81999 10.647% 97.684% ## ( 6, 10 ] 14585 1.894% 99.578% ( 10, 15 ] 3113 0.404% 99.982% ( 15, 22 ] 328 0.043% 100.025% ( 22, 34 ] 21 0.003% 100.027% ( 34, 51 ] 11 0.001% 100.029% ( 51, 76 ] 10 0.001% 100.030% ( 76, 110 ] 21 0.003% 100.033% ( 110, 170 ] 73 0.009% 100.042% ( 170, 250 ] 103 0.013% 100.056% ( 250, 380 ] 189 0.025% 100.080% ( 380, 580 ] 263 0.034% 100.114% ( 580, 870 ] 328 0.043% 100.157% ( 870, 1300 ] 257 0.033% 100.190% ( 1300, 1900 ] 168 0.022% 100.212% ( 1900, 2900 ] 191 0.025% 100.237% ( 2900, 4400 ] 182 0.024% 100.260% ( 4400, 6600 ] 39 0.005% 100.266% ( 6600, 9900 ] 12 0.002% 100.267% ** Level 4 read latency histogram (micros): Count: 32176 Average: 105.3078 StdDev: 470.87 Min: 0 Median: 2.1186 Max: 12475 Percentiles: P50: 2.12 P75: 3.39 P99: 2709.74 P99.9: 5071.73 P99.99: 6588.60 ------------------------------------------------------ [ 0, 1 ] 668 2.076% 2.076% ( 1, 2 ] 14529 45.155% 47.231% ######### ( 2, 3 ] 7515 23.356% 70.587% ##### ( 3, 4 ] 3606 11.207% 81.794% ## ( 4, 6 ] 2112 6.564% 88.358% # ( 6, 10 ] 742 2.306% 90.664% ( 10, 15 ] 147 0.457% 91.121% ( 15, 22 ] 35 0.109% 91.229% ( 22, 34 ] 7 0.022% 91.251% ( 34, 51 ] 5 0.016% 91.267% ( 51, 76 ] 3 0.009% 91.276% ( 76, 110 ] 27 0.084% 91.360% ( 110, 170 ] 92 0.286% 91.646% ( 170, 250 ] 191 0.594% 92.240% ( 250, 380 ] 263 0.817% 93.057% ( 380, 580 ] 456 1.417% 94.474% ( 580, 870 ] 521 1.619% 96.093% ( 870, 1300 ] 438 1.361% 97.455% ( 1300, 1900 ] 311 0.967% 98.421% ( 1900, 2900 ] 230 0.715% 99.136% ( 2900, 4400 ] 233 0.724% 99.860% ( 4400, 6600 ] 42 0.131% 99.991% ( 6600, 9900 ] 4 0.012% 100.003% ( 9900, 14000 ] 2 0.006% 100.009% ** Level 5 read latency histogram (micros): Count: 220 Average: 1328.0045 StdDev: 1360.82 Min: 82 Median: 730.8000 Max: 6929 Percentiles: P50: 730.80 P75: 2093.55 P99: 6222.86 P99.9: 6929.00 P99.99: 6929.00 ------------------------------------------------------ ( 76, 110 ] 7 3.182% 3.182% # ( 110, 170 ] 21 9.545% 12.727% ## ( 170, 250 ] 20 9.091% 21.818% ## ( 250, 380 ] 25 11.364% 33.182% ## ( 380, 580 ] 24 10.909% 44.091% ## ( 580, 870 ] 25 11.364% 55.455% ## ( 870, 1300 ] 16 7.273% 62.727% # ( 1300, 1900 ] 21 9.545% 72.273% ## ( 1900, 2900 ] 31 14.091% 86.364% ### ( 2900, 4400 ] 22 10.000% 96.364% ## ( 4400, 6600 ] 7 3.182% 99.545% # ( 6600, 9900 ] 1 0.455% 100.000% ** DB Stats ** Uptime(secs): 42.8 total, 5.0 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 183.86 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:20.373 H:M:S, 47.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 196.16 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.007 H:M:S, 40.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/05-16:03:46 ... thread 0: (1000000,9000000) ops and (334333.3,197406.5) ops/second in (2.991027,45.591195) 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 16/8 3.75 GB 207.6 7.6 0.0 7.6 16.0 8.5 0.0 1.9 134.7 285.6 57.52 51.05 145 0.397 7866K 10K 0.0 0.0 L1 9/9 963.37 MB 0.0 5.3 4.5 0.7 5.2 4.5 0.2 1.1 217.5 214.0 24.80 23.01 3 8.265 5475K 85K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 3.6 1.5 248.7 248.6 0.78 0.75 2 0.389 196K 82 0.0 0.0 L3 14/0 944.84 MB 0.9 3.3 2.1 1.2 3.3 2.1 1.7 1.6 156.9 156.0 21.41 15.43 10 2.141 3413K 20K 0.0 0.0 L4 177/0 9.70 GB 1.0 3.0 2.9 0.1 3.0 2.9 0.9 1.0 126.9 126.7 24.23 14.30 37 0.655 3055K 2646 0.0 0.0 L5 1084/0 89.20 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1300/17 104.51 GB 0.0 19.3 9.6 9.7 27.7 18.0 10.0 3.3 153.6 220.1 128.75 104.55 197 0.654 20M 119K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.3 9.6 9.7 27.7 18.0 9.9 3.3 153.6 220.1 128.75 104.55 197 0.654 20M 119K 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 19.3 9.6 9.7 19.2 9.5 0.0 0.0 195.2 194.0 101.27 82.50 77 1.315 20M 119K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 0.0 0.0 0.0 316.4 27.48 22.05 120 0.229 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): 45.8 total, 45.6 interval Flush(GB): cumulative 8.490, interval 8.490 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: 27.68 GB write, 618.58 MB/s write, 19.31 GB read, 431.51 MB/s read, 128.7 seconds Interval compaction: 27.68 GB write, 621.60 MB/s write, 19.31 GB read, 433.62 MB/s read, 128.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 67, pending-compaction-bytes-delays: 5, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 67, interval: 84 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3563478 Average: 2.7619 StdDev: 28.02 Min: 0 Median: 1.4879 Max: 9062 Percentiles: P50: 1.49 P75: 1.88 P99: 6.47 P99.9: 127.41 P99.99: 331.86 ------------------------------------------------------ [ 0, 1 ] 685665 19.241% 19.241% #### ( 1, 2 ] 2246413 63.040% 82.281% ############# ( 2, 3 ] 368677 10.346% 92.627% ## ( 3, 4 ] 129818 3.643% 96.270% # ( 4, 6 ] 94498 2.652% 98.922% # ( 6, 10 ] 23848 0.669% 99.591% ( 10, 15 ] 4667 0.131% 99.722% ( 15, 22 ] 582 0.016% 99.739% ( 22, 34 ] 51 0.001% 99.740% ( 34, 51 ] 8 0.000% 99.740% ( 51, 76 ] 73 0.002% 99.742% ( 76, 110 ] 4664 0.131% 99.873% ( 110, 170 ] 3283 0.092% 99.965% ( 170, 250 ] 587 0.016% 99.982% ( 250, 380 ] 460 0.013% 99.995% ( 380, 580 ] 452 0.013% 100.008% ( 580, 870 ] 196 0.006% 100.013% ( 870, 1300 ] 115 0.003% 100.016% ( 1300, 1900 ] 58 0.002% 100.018% ( 1900, 2900 ] 64 0.002% 100.020% ( 2900, 4400 ] 78 0.002% 100.022% ( 4400, 6600 ] 20 0.001% 100.022% ( 6600, 9900 ] 5 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 1111532 Average: 5.9803 StdDev: 94.61 Min: 0 Median: 1.8108 Max: 11689 Percentiles: P50: 1.81 P75: 2.72 P99: 9.29 P99.9: 117.96 P99.99: 305.77 ------------------------------------------------------ [ 0, 1 ] 74391 6.693% 6.693% # ( 1, 2 ] 593684 53.411% 60.104% ########### ( 2, 3 ] 231460 20.824% 80.927% #### ( 3, 4 ] 92259 8.300% 89.228% ## ( 4, 6 ] 88793 7.988% 97.216% ## ( 6, 10 ] 24138 2.172% 99.388% ( 10, 15 ] 4313 0.388% 99.776% ( 15, 22 ] 526 0.047% 99.823% ( 22, 34 ] 36 0.003% 99.826% ( 34, 51 ] 11 0.001% 99.827% ( 51, 76 ] 49 0.004% 99.832% ( 76, 110 ] 671 0.060% 99.892% ( 110, 170 ] 674 0.061% 99.953% ( 170, 250 ] 273 0.025% 99.977% ( 250, 380 ] 333 0.030% 100.007% ( 380, 580 ] 450 0.040% 100.048% ( 580, 870 ] 447 0.040% 100.088% ( 870, 1300 ] 310 0.028% 100.116% ( 1300, 1900 ] 155 0.014% 100.130% ( 1900, 2900 ] 216 0.019% 100.149% ( 2900, 4400 ] 298 0.027% 100.176% ( 4400, 6600 ] 88 0.008% 100.184% ( 6600, 9900 ] 19 0.002% 100.186% ( 9900, 14000 ] 2 0.000% 100.186% ** Level 2 read latency histogram (micros): Count: 77314 Average: 4.1156 StdDev: 46.84 Min: 1 Median: 1.6708 Max: 4153 Percentiles: P50: 1.67 P75: 2.29 P99: 8.55 P99.9: 554.70 P99.99: 2322.87 ------------------------------------------------------ [ 0, 1 ] 6762 8.746% 8.746% ## ( 1, 2 ] 47549 61.501% 70.247% ############ ( 2, 3 ] 12642 16.352% 86.599% ### ( 3, 4 ] 4840 6.260% 92.859% # ( 4, 6 ] 4070 5.264% 98.123% # ( 6, 10 ] 1065 1.377% 99.501% ( 10, 15 ] 166 0.215% 99.715% ( 15, 22 ] 21 0.027% 99.743% ( 22, 34 ] 1 0.001% 99.744% ( 51, 76 ] 1 0.001% 99.745% ( 76, 110 ] 1 0.001% 99.746% ( 110, 170 ] 16 0.021% 99.767% ( 170, 250 ] 23 0.030% 99.797% ( 250, 380 ] 43 0.056% 99.853% ( 380, 580 ] 42 0.054% 99.907% ( 580, 870 ] 35 0.045% 99.952% ( 870, 1300 ] 22 0.028% 99.981% ( 1300, 1900 ] 6 0.008% 99.988% ( 1900, 2900 ] 3 0.004% 99.992% ( 2900, 4400 ] 6 0.008% 100.000% ** Level 3 read latency histogram (micros): Count: 770156 Average: 6.0373 StdDev: 89.12 Min: 1 Median: 1.9893 Max: 8988 Percentiles: P50: 1.99 P75: 2.96 P99: 8.78 P99.9: 13.99 P99.99: 16.32 ------------------------------------------------------ [ 0, 1 ] 16633 2.160% 2.160% ( 1, 2 ] 372415 48.356% 50.515% ########## ( 2, 3 ] 195571 25.394% 75.909% ##### ( 3, 4 ] 85701 11.128% 87.037% ## ( 4, 6 ] 81999 10.647% 97.684% ## ( 6, 10 ] 14585 1.894% 99.578% ( 10, 15 ] 3113 0.404% 99.982% ( 15, 22 ] 328 0.043% 100.025% ( 22, 34 ] 21 0.003% 100.027% ( 34, 51 ] 11 0.001% 100.029% ( 51, 76 ] 10 0.001% 100.030% ( 76, 110 ] 21 0.003% 100.033% ( 110, 170 ] 73 0.009% 100.042% ( 170, 250 ] 103 0.013% 100.056% ( 250, 380 ] 189 0.025% 100.080% ( 380, 580 ] 263 0.034% 100.114% ( 580, 870 ] 328 0.043% 100.157% ( 870, 1300 ] 257 0.033% 100.190% ( 1300, 1900 ] 168 0.022% 100.212% ( 1900, 2900 ] 191 0.025% 100.237% ( 2900, 4400 ] 182 0.024% 100.260% ( 4400, 6600 ] 39 0.005% 100.266% ( 6600, 9900 ] 12 0.002% 100.267% ** Level 4 read latency histogram (micros): Count: 32176 Average: 105.3078 StdDev: 470.87 Min: 0 Median: 2.1186 Max: 12475 Percentiles: P50: 2.12 P75: 3.39 P99: 2709.74 P99.9: 5071.73 P99.99: 6588.60 ------------------------------------------------------ [ 0, 1 ] 668 2.076% 2.076% ( 1, 2 ] 14529 45.155% 47.231% ######### ( 2, 3 ] 7515 23.356% 70.587% ##### ( 3, 4 ] 3606 11.207% 81.794% ## ( 4, 6 ] 2112 6.564% 88.358% # ( 6, 10 ] 742 2.306% 90.664% ( 10, 15 ] 147 0.457% 91.121% ( 15, 22 ] 35 0.109% 91.229% ( 22, 34 ] 7 0.022% 91.251% ( 34, 51 ] 5 0.016% 91.267% ( 51, 76 ] 3 0.009% 91.276% ( 76, 110 ] 27 0.084% 91.360% ( 110, 170 ] 92 0.286% 91.646% ( 170, 250 ] 191 0.594% 92.240% ( 250, 380 ] 263 0.817% 93.057% ( 380, 580 ] 456 1.417% 94.474% ( 580, 870 ] 521 1.619% 96.093% ( 870, 1300 ] 438 1.361% 97.455% ( 1300, 1900 ] 311 0.967% 98.421% ( 1900, 2900 ] 230 0.715% 99.136% ( 2900, 4400 ] 233 0.724% 99.860% ( 4400, 6600 ] 42 0.131% 99.991% ( 6600, 9900 ] 4 0.012% 100.003% ( 9900, 14000 ] 2 0.006% 100.009% ** Level 5 read latency histogram (micros): Count: 220 Average: 1328.0045 StdDev: 1360.82 Min: 82 Median: 730.8000 Max: 6929 Percentiles: P50: 730.80 P75: 2093.55 P99: 6222.86 P99.9: 6929.00 P99.99: 6929.00 ------------------------------------------------------ ( 76, 110 ] 7 3.182% 3.182% # ( 110, 170 ] 21 9.545% 12.727% ## ( 170, 250 ] 20 9.091% 21.818% ## ( 250, 380 ] 25 11.364% 33.182% ## ( 380, 580 ] 24 10.909% 44.091% ## ( 580, 870 ] 25 11.364% 55.455% ## ( 870, 1300 ] 16 7.273% 62.727% # ( 1300, 1900 ] 21 9.545% 72.273% ## ( 1900, 2900 ] 31 14.091% 86.364% ### ( 2900, 4400 ] 22 10.000% 96.364% ## ( 4400, 6600 ] 7 3.182% 99.545% # ( 6600, 9900 ] 1 0.455% 100.000% ** DB Stats ** Uptime(secs): 45.8 total, 3.0 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 193.33 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:20.769 H:M:S, 45.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 329.04 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.396 H:M:S, 13.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/05-16:03:50 ... thread 0: (1000000,10000000) ops and (289867.1,203910.8) ops/second in (3.449857,49.041052) 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/17 3.38 GB 6.3 8.4 0.0 8.4 18.0 9.5 0.0 1.9 134.9 287.3 63.98 57.09 163 0.393 8762K 11K 0.0 0.0 L1 34/34 2.33 GB 0.0 7.6 6.0 1.7 7.5 5.9 0.2 1.3 207.6 204.8 37.57 33.75 4 9.393 6942K 85K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 3.6 1.5 248.7 248.6 0.78 0.75 2 0.389 196K 82 0.0 0.0 L3 14/0 944.84 MB 0.9 3.3 2.1 1.2 3.3 2.1 1.7 1.6 156.9 156.0 21.41 15.43 10 2.141 3413K 20K 0.0 0.0 L4 177/0 9.70 GB 1.0 3.0 2.9 0.1 3.0 2.9 0.9 1.0 126.9 126.7 24.23 14.30 37 0.655 3055K 2646 0.0 0.0 L5 1084/0 89.20 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1327/51 105.53 GB 0.0 22.5 11.0 11.5 31.9 20.4 10.0 3.3 155.8 220.8 147.98 121.33 216 0.685 22M 120K 0.0 0.0 Int 0/0 0.00 KB 0.0 22.5 11.0 11.5 31.9 20.4 9.9 3.3 155.8 220.8 147.98 121.33 216 0.685 22M 120K 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 22.5 11.0 11.5 22.4 10.9 0.0 0.0 196.3 195.1 117.48 96.60 81 1.450 22M 120K 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.50 24.73 135 0.226 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.3 total, 49.0 interval Flush(GB): cumulative 9.536, interval 9.536 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: 31.91 GB write, 663.35 MB/s write, 22.52 GB read, 468.08 MB/s read, 148.0 seconds Interval compaction: 31.91 GB write, 666.36 MB/s write, 22.52 GB read, 470.20 MB/s read, 148.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 71, pending-compaction-bytes-delays: 5, pending-compaction-bytes-stops: 0, total-delays: 20, total-stops: 71, interval: 91 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3839491 Average: 2.7338 StdDev: 27.39 Min: 0 Median: 1.4878 Max: 9062 Percentiles: P50: 1.49 P75: 1.88 P99: 6.32 P99.9: 124.13 P99.99: 323.33 ------------------------------------------------------ [ 0, 1 ] 735424 19.154% 19.154% #### ( 1, 2 ] 2427698 63.230% 82.384% ############# ( 2, 3 ] 397847 10.362% 92.746% ## ( 3, 4 ] 138408 3.605% 96.351% # ( 4, 6 ] 99734 2.598% 98.948% # ( 6, 10 ] 25167 0.655% 99.604% ( 10, 15 ] 5040 0.131% 99.735% ( 15, 22 ] 607 0.016% 99.751% ( 22, 34 ] 54 0.001% 99.752% ( 34, 51 ] 9 0.000% 99.752% ( 51, 76 ] 75 0.002% 99.754% ( 76, 110 ] 4796 0.125% 99.879% ( 110, 170 ] 3366 0.088% 99.967% ( 170, 250 ] 613 0.016% 99.983% ( 250, 380 ] 477 0.012% 99.995% ( 380, 580 ] 468 0.012% 100.008% ( 580, 870 ] 213 0.006% 100.013% ( 870, 1300 ] 118 0.003% 100.016% ( 1300, 1900 ] 60 0.002% 100.018% ( 1900, 2900 ] 67 0.002% 100.020% ( 2900, 4400 ] 81 0.002% 100.022% ( 4400, 6600 ] 20 0.001% 100.022% ( 6600, 9900 ] 5 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 1197536 Average: 5.8220 StdDev: 91.59 Min: 0 Median: 1.7938 Max: 11689 Percentiles: P50: 1.79 P75: 2.67 P99: 9.28 P99.9: 133.39 P99.99: 341.75 ------------------------------------------------------ [ 0, 1 ] 83716 6.991% 6.991% # ( 1, 2 ] 648833 54.181% 61.171% ########### ( 2, 3 ] 245420 20.494% 81.665% #### ( 3, 4 ] 95286 7.957% 89.622% ## ( 4, 6 ] 91311 7.625% 97.247% ## ( 6, 10 ] 25628 2.140% 99.387% ( 10, 15 ] 4439 0.371% 99.758% ( 15, 22 ] 537 0.045% 99.802% ( 22, 34 ] 39 0.003% 99.806% ( 34, 51 ] 13 0.001% 99.807% ( 51, 76 ] 52 0.004% 99.811% ( 76, 110 ] 751 0.063% 99.874% ( 110, 170 ] 804 0.067% 99.941% ( 170, 250 ] 324 0.027% 99.968% ( 250, 380 ] 373 0.031% 99.999% ( 380, 580 ] 486 0.041% 100.040% ( 580, 870 ] 464 0.039% 100.078% ( 870, 1300 ] 334 0.028% 100.106% ( 1300, 1900 ] 164 0.014% 100.120% ( 1900, 2900 ] 217 0.018% 100.138% ( 2900, 4400 ] 300 0.025% 100.163% ( 4400, 6600 ] 88 0.007% 100.171% ( 6600, 9900 ] 19 0.002% 100.172% ( 9900, 14000 ] 2 0.000% 100.172% ** Level 2 read latency histogram (micros): Count: 77314 Average: 4.1156 StdDev: 46.84 Min: 1 Median: 1.6708 Max: 4153 Percentiles: P50: 1.67 P75: 2.29 P99: 8.55 P99.9: 554.70 P99.99: 2322.87 ------------------------------------------------------ [ 0, 1 ] 6762 8.746% 8.746% ## ( 1, 2 ] 47549 61.501% 70.247% ############ ( 2, 3 ] 12642 16.352% 86.599% ### ( 3, 4 ] 4840 6.260% 92.859% # ( 4, 6 ] 4070 5.264% 98.123% # ( 6, 10 ] 1065 1.377% 99.501% ( 10, 15 ] 166 0.215% 99.715% ( 15, 22 ] 21 0.027% 99.743% ( 22, 34 ] 1 0.001% 99.744% ( 51, 76 ] 1 0.001% 99.745% ( 76, 110 ] 1 0.001% 99.746% ( 110, 170 ] 16 0.021% 99.767% ( 170, 250 ] 23 0.030% 99.797% ( 250, 380 ] 43 0.056% 99.853% ( 380, 580 ] 42 0.054% 99.907% ( 580, 870 ] 35 0.045% 99.952% ( 870, 1300 ] 22 0.028% 99.981% ( 1300, 1900 ] 6 0.008% 99.988% ( 1900, 2900 ] 3 0.004% 99.992% ( 2900, 4400 ] 6 0.008% 100.000% ** Level 3 read latency histogram (micros): Count: 770156 Average: 6.0373 StdDev: 89.12 Min: 1 Median: 1.9893 Max: 8988 Percentiles: P50: 1.99 P75: 2.96 P99: 8.78 P99.9: 13.99 P99.99: 16.32 ------------------------------------------------------ [ 0, 1 ] 16633 2.160% 2.160% ( 1, 2 ] 372415 48.356% 50.515% ########## ( 2, 3 ] 195571 25.394% 75.909% ##### ( 3, 4 ] 85701 11.128% 87.037% ## ( 4, 6 ] 81999 10.647% 97.684% ## ( 6, 10 ] 14585 1.894% 99.578% ( 10, 15 ] 3113 0.404% 99.982% ( 15, 22 ] 328 0.043% 100.025% ( 22, 34 ] 21 0.003% 100.027% ( 34, 51 ] 11 0.001% 100.029% ( 51, 76 ] 10 0.001% 100.030% ( 76, 110 ] 21 0.003% 100.033% ( 110, 170 ] 73 0.009% 100.042% ( 170, 250 ] 103 0.013% 100.056% ( 250, 380 ] 189 0.025% 100.080% ( 380, 580 ] 263 0.034% 100.114% ( 580, 870 ] 328 0.043% 100.157% ( 870, 1300 ] 257 0.033% 100.190% ( 1300, 1900 ] 168 0.022% 100.212% ( 1900, 2900 ] 191 0.025% 100.237% ( 2900, 4400 ] 182 0.024% 100.260% ( 4400, 6600 ] 39 0.005% 100.266% ( 6600, 9900 ] 12 0.002% 100.267% ** Level 4 read latency histogram (micros): Count: 32176 Average: 105.3078 StdDev: 470.87 Min: 0 Median: 2.1186 Max: 12475 Percentiles: P50: 2.12 P75: 3.39 P99: 2709.74 P99.9: 5071.73 P99.99: 6588.60 ------------------------------------------------------ [ 0, 1 ] 668 2.076% 2.076% ( 1, 2 ] 14529 45.155% 47.231% ######### ( 2, 3 ] 7515 23.356% 70.587% ##### ( 3, 4 ] 3606 11.207% 81.794% ## ( 4, 6 ] 2112 6.564% 88.358% # ( 6, 10 ] 742 2.306% 90.664% ( 10, 15 ] 147 0.457% 91.121% ( 15, 22 ] 35 0.109% 91.229% ( 22, 34 ] 7 0.022% 91.251% ( 34, 51 ] 5 0.016% 91.267% ( 51, 76 ] 3 0.009% 91.276% ( 76, 110 ] 27 0.084% 91.360% ( 110, 170 ] 92 0.286% 91.646% ( 170, 250 ] 191 0.594% 92.240% ( 250, 380 ] 263 0.817% 93.057% ( 380, 580 ] 456 1.417% 94.474% ( 580, 870 ] 521 1.619% 96.093% ( 870, 1300 ] 438 1.361% 97.455% ( 1300, 1900 ] 311 0.967% 98.421% ( 1900, 2900 ] 230 0.715% 99.136% ( 2900, 4400 ] 233 0.724% 99.860% ( 4400, 6600 ] 42 0.131% 99.991% ( 6600, 9900 ] 4 0.012% 100.003% ( 9900, 14000 ] 2 0.006% 100.009% ** Level 5 read latency histogram (micros): Count: 220 Average: 1328.0045 StdDev: 1360.82 Min: 82 Median: 730.8000 Max: 6929 Percentiles: P50: 730.80 P75: 2093.55 P99: 6222.86 P99.9: 6929.00 P99.99: 6929.00 ------------------------------------------------------ ( 76, 110 ] 7 3.182% 3.182% # ( 110, 170 ] 21 9.545% 12.727% ## ( 170, 250 ] 20 9.091% 21.818% ## ( 250, 380 ] 25 11.364% 33.182% ## ( 380, 580 ] 24 10.909% 44.091% ## ( 580, 870 ] 25 11.364% 55.455% ## ( 870, 1300 ] 16 7.273% 62.727% # ( 1300, 1900 ] 21 9.545% 72.273% ## ( 1900, 2900 ] 31 14.091% 86.364% ### ( 2900, 4400 ] 22 10.000% 96.364% ## ( 4400, 6600 ] 7 3.182% 99.545% # ( 6600, 9900 ] 1 0.455% 100.000% ** DB Stats ** Uptime(secs): 49.3 total, 3.4 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 199.77 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:21.597 H:M:S, 43.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 285.29 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.828 H:M:S, 24.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 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.927 micros/op 168708 ops/sec 60.080 seconds 10135999 operations; 163.5 MB/s Microseconds per write: Count: 10135999 Average: 5.9274 StdDev: 462.25 Min: 0 Median: 1.7329 Max: 689520 Percentiles: P50: 1.73 P75: 2.75 P99: 9.37 P99.9: 1142.57 P99.99: 2650.98 ------------------------------------------------------ [ 0, 1 ] 1388039 13.694% 13.694% ### ( 1, 2 ] 5021239 49.539% 63.233% ########## ( 2, 3 ] 1594420 15.730% 78.963% ### ( 3, 4 ] 1393228 13.745% 92.708% ### ( 4, 6 ] 535877 5.287% 97.995% # ( 6, 10 ] 121013 1.194% 99.189% ( 10, 15 ] 38714 0.382% 99.571% ( 15, 22 ] 9904 0.098% 99.669% ( 22, 34 ] 1927 0.019% 99.688% ( 34, 51 ] 236 0.002% 99.690% ( 51, 76 ] 26 0.000% 99.690% ( 76, 110 ] 7050 0.070% 99.760% ( 110, 170 ] 2708 0.027% 99.787% ( 170, 250 ] 342 0.003% 99.790% ( 250, 380 ] 186 0.002% 99.792% ( 380, 580 ] 44 0.000% 99.792% ( 580, 870 ] 33 0.000% 99.793% ( 870, 1300 ] 17159 0.169% 99.962% ( 1300, 1900 ] 37 0.000% 99.962% ( 1900, 2900 ] 3733 0.037% 99.999% ( 2900, 4400 ] 48 0.000% 100.000% ( 6600, 9900 ] 3 0.000% 100.000% ( 14000, 22000 ] 6 0.000% 100.000% ( 22000, 33000 ] 3 0.000% 100.000% ( 33000, 50000 ] 2 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 15 0.000% 100.000% ( 380000, 570000 ] 1 0.000% 100.000% ( 570000, 860000 ] 3 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 199720 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 : 10135999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10460350968 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 : 502 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31998155 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 : 27699601041 rocksdb.compact.write.bytes COUNT : 27505769735 rocksdb.flush.write.bytes COUNT : 10436999207 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 : 52 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 : 279 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 : 10352920576 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4082688 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 : 27793673378 rocksdb.non.last.level.read.count COUNT : 6713359 rocksdb.block.checksum.compute.count COUNT : 6712407 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.386683 P95 : 3.914324 P99 : 7.954629 P100 : 689517.000000 COUNT : 10135999 SUM : 55372135 rocksdb.compaction.times.micros P50 : 948400.000000 P95 : 3897500.000000 P99 : 15360000.000000 P100 : 19429328.000000 COUNT : 83 SUM : 119627261 rocksdb.compaction.times.cpu_micros P50 : 866296.296296 P95 : 2850000.000000 P99 : 15360000.000000 P100 : 17795713.000000 COUNT : 83 SUM : 98715481 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 : 687.906977 P95 : 8415.000000 P99 : 147200.000000 P100 : 225087.000000 COUNT : 138 SUM : 539176 rocksdb.compaction.outfile.sync.micros P50 : 1148.703704 P95 : 72403.846154 P99 : 142760.000000 P100 : 354059.000000 COUNT : 327 SUM : 4466955 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.000000 P95 : 2500.000000 P99 : 4184.000000 P100 : 4945.000000 COUNT : 244 SUM : 99688 rocksdb.table.open.io.micros P50 : 1596.385542 P95 : 8238.214286 P99 : 12624.222222 P100 : 19117.000000 COUNT : 502 SUM : 1132898 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.604852 P95 : 7.542097 P99 : 10.861363 P100 : 12481.000000 COUNT : 6711076 SUM : 41323439 rocksdb.read.block.get.micros P50 : 468.607595 P95 : 3533.333333 P99 : 5714.133333 P100 : 9474.000000 COUNT : 1004 SUM : 906991 rocksdb.write.raw.block.micros P50 : 0.513020 P95 : 0.974738 P99 : 2.836852 P100 : 15824.000000 COUNT : 9189679 SUM : 18938666 rocksdb.numfiles.in.singlecompaction P50 : 3.125000 P95 : 3.987500 P99 : 20.950000 P100 : 47.000000 COUNT : 115 SUM : 434 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.561499 P95 : 1153.483941 P99 : 2390.016265 P100 : 689326.000000 COUNT : 191533 SUM : 32016654 rocksdb.sst.read.micros P50 : 1.567427 P95 : 4.432774 P99 : 8.288097 P100 : 12475.000000 COUNT : 6713719 SUM : 27839860 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 : 10135999 SUM : 10460350968 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 : 212197.802198 P95 : 459800.000000 P99 : 759950.000000 P100 : 843475.000000 COUNT : 138 SUM : 31031751 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 : 303 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