[2024-07-13 21:57:24.019946] Starting SPDK v24.09-pre git sha1 719d03c6a / DPDK 24.03.0 initialization... [2024-07-13 21:57:24.020088] [ 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_pid1072805 ] Set seed to 1720900644016573 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-13 21:57:24.126704] app.c: 908:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-13 21:57:24.347602] app.c: 603:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-13 21:57:24.347652] app.c: 604:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1072805' to capture a snapshot of events at runtime. [2024-07-13 21:57:24.347662] app.c: 609:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-13 21:57:24.347672] app.c: 610:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-13 21:57:24.347680] app.c: 611:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1072805 for offline analysis/debug. [2024-07-13 21:57:24.347773] reactor.c: 941:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sat Jul 13 21:57:33 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/07/13-21:57:36 ... thread 0: (1000000,1000000) ops and (365522.7,365522.7) ops/second in (2.735808,2.735808) 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/6 567.06 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 357.6 2.29 2.06 12 0.191 0 0 0.0 0.0 L2 3/2 251.75 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.1 2.0 255.5 255.3 1.48 1.42 2 0.740 383K 193 0.0 0.0 L3 9/0 741.27 MB 0.7 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.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 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 1181/8 96.94 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.8 1.5 100.3 317.5 3.77 3.48 14 0.269 383K 193 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.7 1.5 100.3 317.5 3.77 3.48 14 0.269 383K 193 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.2 0.2 0.4 0.2 0.0 0.0 255.5 255.3 1.48 1.42 2 0.740 383K 193 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 357.6 2.29 2.06 12 0.191 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): 2.9 total, 2.7 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.17 GB write, 407.86 MB/s write, 0.37 GB read, 128.80 MB/s read, 3.8 seconds Interval compaction: 1.17 GB write, 437.22 MB/s write, 0.37 GB read, 138.07 MB/s read, 3.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 100409 Average: 1.9274 StdDev: 13.94 Min: 1 Median: 1.2993 Max: 3273 Percentiles: P50: 1.30 P75: 1.70 P99: 4.35 P99.9: 9.63 P99.99: 435.97 ------------------------------------------------------ [ 0, 1 ] 31377 31.249% 31.249% ###### ( 1, 2 ] 62902 62.646% 93.895% ############# ( 2, 3 ] 3730 3.715% 97.610% # ( 3, 4 ] 1261 1.256% 98.866% ( 4, 6 ] 790 0.787% 99.652% ( 6, 10 ] 276 0.275% 99.927% ( 10, 15 ] 37 0.037% 99.964% ( 15, 22 ] 12 0.012% 99.976% ( 22, 34 ] 1 0.001% 99.977% ( 34, 51 ] 1 0.001% 99.978% ( 110, 170 ] 8 0.008% 99.986% ( 170, 250 ] 3 0.003% 99.989% ( 250, 380 ] 1 0.001% 99.990% ( 380, 580 ] 7 0.007% 99.997% ( 580, 870 ] 2 0.002% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ( 1900, 2900 ] 1 0.001% 100.001% ( 2900, 4400 ] 1 0.001% 100.002% ** Level 2 read latency histogram (micros): Count: 50267 Average: 2.2997 StdDev: 33.80 Min: 0 Median: 1.3492 Max: 4685 Percentiles: P50: 1.35 P75: 1.74 P99: 5.23 P99.9: 11.33 P99.99: 1294.26 ------------------------------------------------------ [ 0, 1 ] 13825 27.503% 27.503% ###### ( 1, 2 ] 32385 64.426% 91.929% ############# ( 2, 3 ] 2421 4.816% 96.745% # ( 3, 4 ] 762 1.516% 98.261% ( 4, 6 ] 604 1.202% 99.463% ( 6, 10 ] 208 0.414% 99.877% ( 10, 15 ] 44 0.088% 99.964% ( 15, 22 ] 1 0.002% 99.966% ( 22, 34 ] 1 0.002% 99.968% ( 51, 76 ] 1 0.002% 99.970% ( 170, 250 ] 2 0.004% 99.974% ( 250, 380 ] 3 0.006% 99.980% ( 380, 580 ] 2 0.004% 99.984% ( 580, 870 ] 1 0.002% 99.986% ( 870, 1300 ] 2 0.004% 99.990% ( 1900, 2900 ] 3 0.006% 99.996% ( 2900, 4400 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 55 Average: 3079.0182 StdDev: 1930.71 Min: 96 Median: 3120.5882 Max: 7389 Percentiles: P50: 3120.59 P75: 4333.82 P99: 7389.00 P99.9: 7389.00 P99.99: 7389.00 ------------------------------------------------------ ( 76, 110 ] 1 1.818% 1.818% ( 110, 170 ] 1 1.818% 3.636% ( 170, 250 ] 2 3.636% 7.273% # ( 250, 380 ] 3 5.455% 12.727% # ( 380, 580 ] 3 5.455% 18.182% # ( 580, 870 ] 1 1.818% 20.000% ( 870, 1300 ] 2 3.636% 23.636% # ( 1300, 1900 ] 3 5.455% 29.091% # ( 1900, 2900 ] 9 16.364% 45.455% ### ( 2900, 4400 ] 17 30.909% 76.364% ###### ( 4400, 6600 ] 10 18.182% 94.545% #### ( 6600, 9900 ] 3 5.455% 100.000% # ** Level 4 read latency histogram (micros): Count: 15 Average: 3580.2000 StdDev: 1656.60 Min: 1028 Median: 3650.0000 Max: 6198 Percentiles: P50: 3650.00 P75: 4950.00 P99: 6198.00 P99.9: 6198.00 P99.99: 6198.00 ------------------------------------------------------ ( 870, 1300 ] 1 6.667% 6.667% # ( 1300, 1900 ] 2 13.333% 20.000% ### ( 1900, 2900 ] 2 13.333% 33.333% ### ( 2900, 4400 ] 5 33.333% 66.667% ####### ( 4400, 6600 ] 5 33.333% 100.000% ####### ** Level 5 read latency histogram (micros): Count: 20 Average: 883.6000 StdDev: 1249.52 Min: 97 Median: 150.0000 Max: 4228 Percentiles: P50: 150.00 P75: 870.00 P99: 4228.00 P99.9: 4228.00 P99.99: 4228.00 ------------------------------------------------------ ( 76, 110 ] 6 30.000% 30.000% ###### ( 110, 170 ] 6 30.000% 60.000% ###### ( 380, 580 ] 2 10.000% 70.000% ## ( 580, 870 ] 1 5.000% 75.000% # ( 1900, 2900 ] 3 15.000% 90.000% ### ( 2900, 4400 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 2.9 total, 2.7 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 335.40 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.225 H:M:S, 7.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 359.46 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.225 H:M:S, 8.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/13-21:57:39 ... thread 0: (1000000,2000000) ops and (330663.8,347220.5) ops/second in (3.024220,5.760028) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/6 1.17 GB 12.6 0.8 0.0 0.8 2.6 1.8 0.0 1.4 99.0 319.7 8.27 7.66 29 0.285 831K 884 0.0 0.0 L1 1/1 2.90 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 238.5 238.0 1.59 1.54 1 1.585 383K 602 0.0 0.0 L2 2/0 54.05 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 255.5 255.3 1.48 1.42 2 0.740 383K 193 0.0 0.0 L3 39/0 971.44 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 201.1 200.9 3.96 3.49 3 1.321 809K 854 0.0 0.0 L4 148/0 9.56 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.19 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 1246/7 97.92 GB 0.0 2.3 1.1 1.2 4.1 2.9 2.2 2.3 155.0 274.2 15.30 14.11 35 0.437 2408K 2533 0.0 0.0 Int 0/0 0.00 KB 0.0 2.3 1.1 1.2 4.1 2.9 2.1 2.3 155.0 274.2 15.30 14.11 35 0.437 2408K 2533 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 2.3 1.1 1.2 2.3 1.1 0.0 0.0 232.7 232.4 10.19 9.56 9 1.133 2408K 2533 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.8 1.8 0.0 0.0 0.0 357.7 5.11 4.55 26 0.196 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.0 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: 4.10 GB write, 704.24 MB/s write, 2.32 GB read, 398.07 MB/s read, 15.3 seconds Interval compaction: 4.10 GB write, 728.33 MB/s write, 2.32 GB read, 411.68 MB/s read, 15.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: 6, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 6, interval: 6 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 382926 Average: 2.2979 StdDev: 11.75 Min: 0 Median: 1.5409 Max: 3288 Percentiles: P50: 1.54 P75: 1.93 P99: 5.83 P99.9: 10.48 P99.99: 16.71 ------------------------------------------------------ [ 0, 1 ] 58028 15.154% 15.154% ### ( 1, 2 ] 246674 64.418% 79.572% ############# ( 2, 3 ] 49292 12.872% 92.444% ### ( 3, 4 ] 13109 3.423% 95.868% # ( 4, 6 ] 13077 3.415% 99.283% # ( 6, 10 ] 2329 0.608% 99.891% ( 10, 15 ] 367 0.096% 99.987% ( 15, 22 ] 52 0.014% 100.001% ( 22, 34 ] 3 0.001% 100.001% ( 34, 51 ] 2 0.001% 100.002% ( 51, 76 ] 3 0.001% 100.003% ( 110, 170 ] 13 0.003% 100.006% ( 170, 250 ] 10 0.003% 100.009% ( 250, 380 ] 3 0.001% 100.009% ( 380, 580 ] 15 0.004% 100.013% ( 580, 870 ] 7 0.002% 100.015% ( 870, 1300 ] 3 0.001% 100.016% ( 1300, 1900 ] 2 0.001% 100.016% ( 1900, 2900 ] 3 0.001% 100.017% ( 2900, 4400 ] 2 0.001% 100.018% ** Level 1 read latency histogram (micros): Count: 81814 Average: 2.6718 StdDev: 6.67 Min: 1 Median: 1.7917 Max: 1425 Percentiles: P50: 1.79 P75: 2.52 P99: 7.33 P99.9: 13.40 P99.99: 18.12 ------------------------------------------------------ [ 0, 1 ] 2994 3.660% 3.660% # ( 1, 2 ] 47888 58.533% 62.192% ############ ( 2, 3 ] 20205 24.696% 86.889% ##### ( 3, 4 ] 4445 5.433% 92.322% # ( 4, 6 ] 5166 6.314% 98.636% # ( 6, 10 ] 898 1.098% 99.734% ( 10, 15 ] 200 0.244% 99.978% ( 15, 22 ] 22 0.027% 100.005% ( 22, 34 ] 1 0.001% 100.006% ( 34, 51 ] 1 0.001% 100.007% ( 51, 76 ] 1 0.001% 100.009% ( 110, 170 ] 1 0.001% 100.010% ( 170, 250 ] 1 0.001% 100.011% ( 250, 380 ] 3 0.004% 100.015% ( 380, 580 ] 1 0.001% 100.016% ( 870, 1300 ] 1 0.001% 100.017% ( 1300, 1900 ] 1 0.001% 100.018% ** Level 2 read latency histogram (micros): Count: 95440 Average: 2.3185 StdDev: 24.54 Min: 0 Median: 1.4827 Max: 4685 Percentiles: P50: 1.48 P75: 1.86 P99: 5.71 P99.9: 10.23 P99.99: 425.60 ------------------------------------------------------ [ 0, 1 ] 17389 18.220% 18.220% #### ( 1, 2 ] 62837 65.839% 84.059% ############# ( 2, 3 ] 9675 10.137% 94.196% ## ( 3, 4 ] 2386 2.500% 96.696% # ( 4, 6 ] 2570 2.693% 99.389% # ( 6, 10 ] 484 0.507% 99.896% ( 10, 15 ] 77 0.081% 99.977% ( 15, 22 ] 3 0.003% 99.980% ( 22, 34 ] 1 0.001% 99.981% ( 51, 76 ] 3 0.003% 99.984% ( 170, 250 ] 2 0.002% 99.986% ( 250, 380 ] 3 0.003% 99.990% ( 380, 580 ] 2 0.002% 99.992% ( 580, 870 ] 1 0.001% 99.993% ( 870, 1300 ] 2 0.002% 99.995% ( 1900, 2900 ] 3 0.003% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57432 Average: 5.6906 StdDev: 112.58 Min: 0 Median: 1.7897 Max: 7389 Percentiles: P50: 1.79 P75: 2.52 P99: 8.16 P99.9: 239.59 P99.99: 4896.50 ------------------------------------------------------ [ 0, 1 ] 2250 3.918% 3.918% # ( 1, 2 ] 33514 58.354% 62.272% ############ ( 2, 3 ] 14083 24.521% 86.793% ##### ( 3, 4 ] 3091 5.382% 92.175% # ( 4, 6 ] 3586 6.244% 98.419% # ( 6, 10 ] 617 1.074% 99.493% ( 10, 15 ] 168 0.293% 99.786% ( 15, 22 ] 37 0.064% 99.850% ( 22, 34 ] 3 0.005% 99.855% ( 34, 51 ] 6 0.010% 99.866% ( 51, 76 ] 8 0.014% 99.880% ( 76, 110 ] 1 0.002% 99.882% ( 110, 170 ] 1 0.002% 99.883% ( 170, 250 ] 11 0.019% 99.902% ( 250, 380 ] 9 0.016% 99.918% ( 380, 580 ] 5 0.009% 99.927% ( 580, 870 ] 2 0.003% 99.930% ( 870, 1300 ] 3 0.005% 99.936% ( 1300, 1900 ] 3 0.005% 99.941% ( 1900, 2900 ] 9 0.016% 99.956% ( 2900, 4400 ] 17 0.030% 99.986% ( 4400, 6600 ] 10 0.017% 100.003% ( 6600, 9900 ] 3 0.005% 100.009% ** Level 4 read latency histogram (micros): Count: 15 Average: 3580.2000 StdDev: 1656.60 Min: 1028 Median: 3650.0000 Max: 6198 Percentiles: P50: 3650.00 P75: 4950.00 P99: 6198.00 P99.9: 6198.00 P99.99: 6198.00 ------------------------------------------------------ ( 870, 1300 ] 1 6.667% 6.667% # ( 1300, 1900 ] 2 13.333% 20.000% ### ( 1900, 2900 ] 2 13.333% 33.333% ### ( 2900, 4400 ] 5 33.333% 66.667% ####### ( 4400, 6600 ] 5 33.333% 100.000% ####### ** Level 5 read latency histogram (micros): Count: 40 Average: 827.1500 StdDev: 1146.92 Min: 84 Median: 158.0000 Max: 4228 Percentiles: P50: 158.00 P75: 870.00 P99: 4228.00 P99.9: 4228.00 P99.99: 4228.00 ------------------------------------------------------ ( 76, 110 ] 8 20.000% 20.000% #### ( 110, 170 ] 15 37.500% 57.500% ######## ( 380, 580 ] 5 12.500% 70.000% ### ( 580, 870 ] 2 5.000% 75.000% # ( 1300, 1900 ] 3 7.500% 82.500% ## ( 1900, 2900 ] 3 7.500% 90.000% ## ( 2900, 4400 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 6.0 total, 3.0 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 330.34 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.639 H:M:S, 10.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 325.43 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.414 H:M:S, 13.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/13-21:57:42 ... thread 0: (1000000,3000000) ops and (332323.0,342108.5) ops/second in (3.009121,8.769149) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/10 2.09 GB 75.5 1.4 0.0 1.4 4.1 2.7 0.0 1.5 105.7 317.0 13.11 12.16 44 0.298 1407K 1503 0.0 0.0 L1 1/1 2.90 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 238.5 238.0 1.59 1.54 1 1.585 383K 602 0.0 0.0 L2 2/0 54.05 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 255.5 255.3 1.48 1.42 2 0.740 383K 193 0.0 0.0 L3 39/0 971.44 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 201.1 200.9 3.96 3.49 3 1.321 809K 854 0.0 0.0 L4 148/0 9.56 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.19 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/11 98.84 GB 0.0 2.9 1.1 1.8 5.6 3.8 2.2 2.1 145.9 283.4 20.14 18.61 50 0.403 2984K 3152 0.0 0.0 Int 0/0 0.00 KB 0.0 2.9 1.1 1.8 5.6 3.8 2.1 2.1 145.9 283.4 20.14 18.61 50 0.403 2984K 3152 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 2.9 1.1 1.8 2.9 1.1 0.0 0.0 238.6 238.3 12.32 11.64 11 1.120 2984K 3152 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 354.4 7.82 6.97 39 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.0 total, 8.8 interval Flush(GB): cumulative 2.707, interval 2.707 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.57 GB write, 636.45 MB/s write, 2.87 GB read, 327.72 MB/s read, 20.1 seconds Interval compaction: 5.57 GB write, 650.76 MB/s write, 2.87 GB read, 335.08 MB/s read, 20.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 10, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 10, interval: 10 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 755951 Average: 2.2833 StdDev: 10.66 Min: 0 Median: 1.5536 Max: 3427 Percentiles: P50: 1.55 P75: 1.93 P99: 5.76 P99.9: 11.13 P99.99: 15.52 ------------------------------------------------------ [ 0, 1 ] 100074 13.238% 13.238% ### ( 1, 2 ] 502019 66.409% 79.647% ############# ( 2, 3 ] 103012 13.627% 93.274% ### ( 3, 4 ] 23651 3.129% 96.403% # ( 4, 6 ] 22334 2.954% 99.357% # ( 6, 10 ] 3911 0.517% 99.874% ( 10, 15 ] 866 0.115% 99.989% ( 15, 22 ] 126 0.017% 100.006% ( 22, 34 ] 26 0.003% 100.009% ( 34, 51 ] 8 0.001% 100.010% ( 51, 76 ] 8 0.001% 100.011% ( 76, 110 ] 1 0.000% 100.011% ( 110, 170 ] 18 0.002% 100.014% ( 170, 250 ] 14 0.002% 100.015% ( 250, 380 ] 5 0.001% 100.016% ( 380, 580 ] 21 0.003% 100.019% ( 580, 870 ] 13 0.002% 100.021% ( 870, 1300 ] 7 0.001% 100.022% ( 1300, 1900 ] 2 0.000% 100.022% ( 1900, 2900 ] 5 0.001% 100.022% ( 2900, 4400 ] 3 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 81814 Average: 2.6718 StdDev: 6.67 Min: 1 Median: 1.7917 Max: 1425 Percentiles: P50: 1.79 P75: 2.52 P99: 7.33 P99.9: 13.40 P99.99: 18.12 ------------------------------------------------------ [ 0, 1 ] 2994 3.660% 3.660% # ( 1, 2 ] 47888 58.533% 62.192% ############ ( 2, 3 ] 20205 24.696% 86.889% ##### ( 3, 4 ] 4445 5.433% 92.322% # ( 4, 6 ] 5166 6.314% 98.636% # ( 6, 10 ] 898 1.098% 99.734% ( 10, 15 ] 200 0.244% 99.978% ( 15, 22 ] 22 0.027% 100.005% ( 22, 34 ] 1 0.001% 100.006% ( 34, 51 ] 1 0.001% 100.007% ( 51, 76 ] 1 0.001% 100.009% ( 110, 170 ] 1 0.001% 100.010% ( 170, 250 ] 1 0.001% 100.011% ( 250, 380 ] 3 0.004% 100.015% ( 380, 580 ] 1 0.001% 100.016% ( 870, 1300 ] 1 0.001% 100.017% ( 1300, 1900 ] 1 0.001% 100.018% ** Level 2 read latency histogram (micros): Count: 95440 Average: 2.3185 StdDev: 24.54 Min: 0 Median: 1.4827 Max: 4685 Percentiles: P50: 1.48 P75: 1.86 P99: 5.71 P99.9: 10.23 P99.99: 425.60 ------------------------------------------------------ [ 0, 1 ] 17389 18.220% 18.220% #### ( 1, 2 ] 62837 65.839% 84.059% ############# ( 2, 3 ] 9675 10.137% 94.196% ## ( 3, 4 ] 2386 2.500% 96.696% # ( 4, 6 ] 2570 2.693% 99.389% # ( 6, 10 ] 484 0.507% 99.896% ( 10, 15 ] 77 0.081% 99.977% ( 15, 22 ] 3 0.003% 99.980% ( 22, 34 ] 1 0.001% 99.981% ( 51, 76 ] 3 0.003% 99.984% ( 170, 250 ] 2 0.002% 99.986% ( 250, 380 ] 3 0.003% 99.990% ( 380, 580 ] 2 0.002% 99.992% ( 580, 870 ] 1 0.001% 99.993% ( 870, 1300 ] 2 0.002% 99.995% ( 1900, 2900 ] 3 0.003% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57432 Average: 5.6906 StdDev: 112.58 Min: 0 Median: 1.7897 Max: 7389 Percentiles: P50: 1.79 P75: 2.52 P99: 8.16 P99.9: 239.59 P99.99: 4896.50 ------------------------------------------------------ [ 0, 1 ] 2250 3.918% 3.918% # ( 1, 2 ] 33514 58.354% 62.272% ############ ( 2, 3 ] 14083 24.521% 86.793% ##### ( 3, 4 ] 3091 5.382% 92.175% # ( 4, 6 ] 3586 6.244% 98.419% # ( 6, 10 ] 617 1.074% 99.493% ( 10, 15 ] 168 0.293% 99.786% ( 15, 22 ] 37 0.064% 99.850% ( 22, 34 ] 3 0.005% 99.855% ( 34, 51 ] 6 0.010% 99.866% ( 51, 76 ] 8 0.014% 99.880% ( 76, 110 ] 1 0.002% 99.882% ( 110, 170 ] 1 0.002% 99.883% ( 170, 250 ] 11 0.019% 99.902% ( 250, 380 ] 9 0.016% 99.918% ( 380, 580 ] 5 0.009% 99.927% ( 580, 870 ] 2 0.003% 99.930% ( 870, 1300 ] 3 0.005% 99.936% ( 1300, 1900 ] 3 0.005% 99.941% ( 1900, 2900 ] 9 0.016% 99.956% ( 2900, 4400 ] 17 0.030% 99.986% ( 4400, 6600 ] 10 0.017% 100.003% ( 6600, 9900 ] 3 0.005% 100.009% ** Level 4 read latency histogram (micros): Count: 15 Average: 3580.2000 StdDev: 1656.60 Min: 1028 Median: 3650.0000 Max: 6198 Percentiles: P50: 3650.00 P75: 4950.00 P99: 6198.00 P99.9: 6198.00 P99.99: 6198.00 ------------------------------------------------------ ( 870, 1300 ] 1 6.667% 6.667% # ( 1300, 1900 ] 2 13.333% 20.000% ### ( 1900, 2900 ] 2 13.333% 33.333% ### ( 2900, 4400 ] 5 33.333% 66.667% ####### ( 4400, 6600 ] 5 33.333% 100.000% ####### ** Level 5 read latency histogram (micros): Count: 40 Average: 827.1500 StdDev: 1146.92 Min: 84 Median: 158.0000 Max: 4228 Percentiles: P50: 158.00 P75: 870.00 P99: 4228.00 P99.9: 4228.00 P99.99: 4228.00 ------------------------------------------------------ ( 76, 110 ] 8 20.000% 20.000% #### ( 110, 170 ] 15 37.500% 57.500% ######## ( 380, 580 ] 5 12.500% 70.000% ### ( 580, 870 ] 2 5.000% 75.000% # ( 1300, 1900 ] 3 7.500% 82.500% ## ( 1900, 2900 ] 3 7.500% 90.000% ## ( 2900, 4400 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 9.0 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 329.24 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.077 H:M:S, 12.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 327.07 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.438 H:M:S, 14.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/13-21:57:45 ... thread 0: (1000000,4000000) ops and (330887.5,339232.5) ops/second in (3.022175,11.791324) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/12 2.03 GB 12.6 2.2 0.0 2.2 5.9 3.7 0.0 1.6 117.7 313.8 19.27 17.96 61 0.316 2302K 2505 0.0 0.0 L1 5/5 553.07 MB 0.0 1.4 1.4 0.0 1.4 1.4 0.2 1.0 236.1 235.2 6.15 6.00 2 3.073 1473K 5208 0.0 0.0 L2 2/0 54.05 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.9 2.0 255.5 255.3 1.48 1.42 2 0.740 383K 193 0.0 0.0 L3 16/0 903.53 MB 0.9 0.8 0.6 0.2 0.8 0.6 0.6 1.4 201.1 200.9 3.96 3.49 3 1.321 809K 854 0.0 0.0 L4 167/0 9.45 GB 1.0 0.0 0.0 0.0 0.0 0.0 1.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1056/0 86.86 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 1260/17 99.82 GB 0.0 4.8 2.2 2.6 8.5 5.8 4.4 2.3 158.6 280.8 30.85 28.87 68 0.454 4968K 8760 0.0 0.0 Int 0/0 0.00 KB 0.0 4.8 2.2 2.6 8.5 5.8 4.3 2.3 158.6 280.8 30.85 28.87 68 0.454 4968K 8760 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.8 2.2 2.6 4.8 2.1 0.0 0.0 242.4 242.0 20.19 19.35 15 1.346 4968K 8760 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 354.4 10.67 9.51 53 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): 12.0 total, 11.8 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.46 GB write, 722.65 MB/s write, 4.78 GB read, 408.16 MB/s read, 30.9 seconds Interval compaction: 8.46 GB write, 734.73 MB/s write, 4.78 GB read, 414.98 MB/s read, 30.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: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 15, interval: 15 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1100026 Average: 2.2759 StdDev: 10.25 Min: 0 Median: 1.5533 Max: 3427 Percentiles: P50: 1.55 P75: 1.93 P99: 5.73 P99.9: 10.81 P99.99: 14.64 ------------------------------------------------------ [ 0, 1 ] 144715 13.156% 13.156% ### ( 1, 2 ] 732512 66.590% 79.746% ############# ( 2, 3 ] 151093 13.735% 93.481% ### ( 3, 4 ] 33064 3.006% 96.487% # ( 4, 6 ] 31988 2.908% 99.395% # ( 6, 10 ] 5346 0.486% 99.881% ( 10, 15 ] 1292 0.117% 99.999% ( 15, 22 ] 157 0.014% 100.013% ( 22, 34 ] 30 0.003% 100.016% ( 34, 51 ] 9 0.001% 100.016% ( 51, 76 ] 10 0.001% 100.017% ( 76, 110 ] 1 0.000% 100.017% ( 110, 170 ] 23 0.002% 100.019% ( 170, 250 ] 19 0.002% 100.021% ( 250, 380 ] 8 0.001% 100.022% ( 380, 580 ] 27 0.002% 100.024% ( 580, 870 ] 19 0.002% 100.026% ( 870, 1300 ] 12 0.001% 100.027% ( 1300, 1900 ] 4 0.000% 100.028% ( 1900, 2900 ] 7 0.001% 100.028% ( 2900, 4400 ] 3 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 82596 Average: 2.8445 StdDev: 16.07 Min: 1 Median: 1.7903 Max: 1816 Percentiles: P50: 1.79 P75: 2.52 P99: 7.39 P99.9: 13.83 P99.99: 162.21 ------------------------------------------------------ [ 0, 1 ] 3034 3.673% 3.673% # ( 1, 2 ] 48420 58.623% 62.296% ############ ( 2, 3 ] 20326 24.609% 86.905% ##### ( 3, 4 ] 4482 5.426% 92.331% # ( 4, 6 ] 5194 6.288% 98.620% # ( 6, 10 ] 902 1.092% 99.712% ( 10, 15 ] 203 0.246% 99.958% ( 15, 22 ] 22 0.027% 99.984% ( 22, 34 ] 1 0.001% 99.985% ( 34, 51 ] 1 0.001% 99.987% ( 51, 76 ] 1 0.001% 99.988% ( 110, 170 ] 2 0.002% 99.990% ( 170, 250 ] 1 0.001% 99.992% ( 250, 380 ] 6 0.007% 99.999% ( 380, 580 ] 6 0.007% 100.006% ( 580, 870 ] 1 0.001% 100.007% ( 870, 1300 ] 4 0.005% 100.012% ( 1300, 1900 ] 5 0.006% 100.018% ** Level 2 read latency histogram (micros): Count: 95440 Average: 2.3185 StdDev: 24.54 Min: 0 Median: 1.4827 Max: 4685 Percentiles: P50: 1.48 P75: 1.86 P99: 5.71 P99.9: 10.23 P99.99: 425.60 ------------------------------------------------------ [ 0, 1 ] 17389 18.220% 18.220% #### ( 1, 2 ] 62837 65.839% 84.059% ############# ( 2, 3 ] 9675 10.137% 94.196% ## ( 3, 4 ] 2386 2.500% 96.696% # ( 4, 6 ] 2570 2.693% 99.389% # ( 6, 10 ] 484 0.507% 99.896% ( 10, 15 ] 77 0.081% 99.977% ( 15, 22 ] 3 0.003% 99.980% ( 22, 34 ] 1 0.001% 99.981% ( 51, 76 ] 3 0.003% 99.984% ( 170, 250 ] 2 0.002% 99.986% ( 250, 380 ] 3 0.003% 99.990% ( 380, 580 ] 2 0.002% 99.992% ( 580, 870 ] 1 0.001% 99.993% ( 870, 1300 ] 2 0.002% 99.995% ( 1900, 2900 ] 3 0.003% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57432 Average: 5.6906 StdDev: 112.58 Min: 0 Median: 1.7897 Max: 7389 Percentiles: P50: 1.79 P75: 2.52 P99: 8.16 P99.9: 239.59 P99.99: 4896.50 ------------------------------------------------------ [ 0, 1 ] 2250 3.918% 3.918% # ( 1, 2 ] 33514 58.354% 62.272% ############ ( 2, 3 ] 14083 24.521% 86.793% ##### ( 3, 4 ] 3091 5.382% 92.175% # ( 4, 6 ] 3586 6.244% 98.419% # ( 6, 10 ] 617 1.074% 99.493% ( 10, 15 ] 168 0.293% 99.786% ( 15, 22 ] 37 0.064% 99.850% ( 22, 34 ] 3 0.005% 99.855% ( 34, 51 ] 6 0.010% 99.866% ( 51, 76 ] 8 0.014% 99.880% ( 76, 110 ] 1 0.002% 99.882% ( 110, 170 ] 1 0.002% 99.883% ( 170, 250 ] 11 0.019% 99.902% ( 250, 380 ] 9 0.016% 99.918% ( 380, 580 ] 5 0.009% 99.927% ( 580, 870 ] 2 0.003% 99.930% ( 870, 1300 ] 3 0.005% 99.936% ( 1300, 1900 ] 3 0.005% 99.941% ( 1900, 2900 ] 9 0.016% 99.956% ( 2900, 4400 ] 17 0.030% 99.986% ( 4400, 6600 ] 10 0.017% 100.003% ( 6600, 9900 ] 3 0.005% 100.009% ** Level 4 read latency histogram (micros): Count: 15 Average: 3580.2000 StdDev: 1656.60 Min: 1028 Median: 3650.0000 Max: 6198 Percentiles: P50: 3650.00 P75: 4950.00 P99: 6198.00 P99.9: 6198.00 P99.99: 6198.00 ------------------------------------------------------ ( 870, 1300 ] 1 6.667% 6.667% # ( 1300, 1900 ] 2 13.333% 20.000% ### ( 1900, 2900 ] 2 13.333% 33.333% ### ( 2900, 4400 ] 5 33.333% 66.667% ####### ( 4400, 6600 ] 5 33.333% 100.000% ####### ** Level 5 read latency histogram (micros): Count: 80 Average: 785.9750 StdDev: 1084.89 Min: 76 Median: 186.0000 Max: 4228 Percentiles: P50: 186.00 P75: 821.67 P99: 4200.00 P99.9: 4228.00 P99.99: 4228.00 ------------------------------------------------------ ( 51, 76 ] 1 1.250% 1.250% ( 76, 110 ] 17 21.250% 22.500% #### ( 110, 170 ] 21 26.250% 48.750% ##### ( 170, 250 ] 5 6.250% 55.000% # ( 250, 380 ] 2 2.500% 57.500% # ( 380, 580 ] 9 11.250% 68.750% ## ( 580, 870 ] 6 7.500% 76.250% ## ( 870, 1300 ] 1 1.250% 77.500% ( 1300, 1900 ] 5 6.250% 83.750% # ( 1900, 2900 ] 7 8.750% 92.500% ## ( 2900, 4400 ] 6 7.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, 328.34 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.522 H:M:S, 12.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 325.65 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.446 H:M:S, 14.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/13-21:57:48 ... thread 0: (1000000,5000000) ops and (314207.6,333913.6) ops/second in (3.182609,14.973933) 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/12 3.01 GB 113.3 3.0 0.0 3.0 7.7 4.7 0.0 1.6 122.5 312.4 25.19 23.53 77 0.327 3134K 3382 0.0 0.0 L1 5/5 553.07 MB 0.0 1.4 1.4 0.0 1.4 1.4 0.2 1.0 236.1 235.2 6.15 6.00 2 3.073 1473K 5208 0.0 0.0 L2 2/0 54.05 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.9 2.0 255.5 255.3 1.48 1.42 2 0.740 383K 193 0.0 0.0 L3 16/0 903.53 MB 0.9 0.8 0.6 0.2 0.8 0.6 0.6 1.4 201.1 200.9 3.96 3.49 3 1.321 809K 854 0.0 0.0 L4 167/0 9.45 GB 1.0 0.0 0.0 0.0 0.0 0.0 1.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1056/0 86.86 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 1264/17 100.80 GB 0.0 5.6 2.2 3.4 10.2 6.8 4.4 2.2 155.3 285.2 36.78 34.44 84 0.438 5800K 9637 0.0 0.0 Int 0/0 0.00 KB 0.0 5.6 2.2 3.4 10.2 6.8 4.3 2.2 155.3 285.2 36.78 34.44 84 0.438 5800K 9637 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.6 2.2 3.4 5.6 2.1 0.0 0.0 245.4 244.9 23.28 22.40 18 1.293 5800K 9637 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 354.7 13.50 12.05 66 0.205 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.2 total, 15.0 interval Flush(GB): cumulative 4.676, interval 4.676 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: 10.24 GB write, 691.41 MB/s write, 5.58 GB read, 376.52 MB/s read, 36.8 seconds Interval compaction: 10.24 GB write, 700.51 MB/s write, 5.58 GB read, 381.47 MB/s read, 36.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 18, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 18, interval: 18 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1498658 Average: 2.2945 StdDev: 9.49 Min: 0 Median: 1.5646 Max: 3427 Percentiles: P50: 1.56 P75: 1.94 P99: 5.75 P99.9: 11.32 P99.99: 14.72 ------------------------------------------------------ [ 0, 1 ] 184244 12.294% 12.294% ## ( 1, 2 ] 1000851 66.783% 79.077% ############# ( 2, 3 ] 216118 14.421% 93.498% ### ( 3, 4 ] 44150 2.946% 96.444% # ( 4, 6 ] 43760 2.920% 99.364% # ( 6, 10 ] 7516 0.502% 99.865% ( 10, 15 ] 1978 0.132% 99.997% ( 15, 22 ] 193 0.013% 100.010% ( 22, 34 ] 32 0.002% 100.012% ( 34, 51 ] 9 0.001% 100.013% ( 51, 76 ] 11 0.001% 100.014% ( 76, 110 ] 30 0.002% 100.016% ( 110, 170 ] 63 0.004% 100.020% ( 170, 250 ] 33 0.002% 100.022% ( 250, 380 ] 21 0.001% 100.023% ( 380, 580 ] 34 0.002% 100.026% ( 580, 870 ] 27 0.002% 100.027% ( 870, 1300 ] 19 0.001% 100.029% ( 1300, 1900 ] 5 0.000% 100.029% ( 1900, 2900 ] 7 0.000% 100.030% ( 2900, 4400 ] 3 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 96960 Average: 2.8526 StdDev: 15.88 Min: 1 Median: 1.7642 Max: 1816 Percentiles: P50: 1.76 P75: 2.46 P99: 7.50 P99.9: 14.49 P99.99: 344.95 ------------------------------------------------------ [ 0, 1 ] 4053 4.180% 4.180% # ( 1, 2 ] 58133 59.956% 64.136% ############ ( 2, 3 ] 22914 23.632% 87.768% ##### ( 3, 4 ] 4880 5.033% 92.801% # ( 4, 6 ] 5602 5.778% 98.579% # ( 6, 10 ] 1088 1.122% 99.701% ( 10, 15 ] 215 0.222% 99.923% ( 15, 22 ] 28 0.029% 99.952% ( 22, 34 ] 1 0.001% 99.953% ( 34, 51 ] 1 0.001% 99.954% ( 51, 76 ] 1 0.001% 99.955% ( 110, 170 ] 25 0.026% 99.980% ( 170, 250 ] 2 0.002% 99.982% ( 250, 380 ] 10 0.010% 99.993% ( 380, 580 ] 11 0.011% 100.004% ( 580, 870 ] 1 0.001% 100.005% ( 870, 1300 ] 5 0.005% 100.010% ( 1300, 1900 ] 5 0.005% 100.015% ** Level 2 read latency histogram (micros): Count: 95440 Average: 2.3185 StdDev: 24.54 Min: 0 Median: 1.4827 Max: 4685 Percentiles: P50: 1.48 P75: 1.86 P99: 5.71 P99.9: 10.23 P99.99: 425.60 ------------------------------------------------------ [ 0, 1 ] 17389 18.220% 18.220% #### ( 1, 2 ] 62837 65.839% 84.059% ############# ( 2, 3 ] 9675 10.137% 94.196% ## ( 3, 4 ] 2386 2.500% 96.696% # ( 4, 6 ] 2570 2.693% 99.389% # ( 6, 10 ] 484 0.507% 99.896% ( 10, 15 ] 77 0.081% 99.977% ( 15, 22 ] 3 0.003% 99.980% ( 22, 34 ] 1 0.001% 99.981% ( 51, 76 ] 3 0.003% 99.984% ( 170, 250 ] 2 0.002% 99.986% ( 250, 380 ] 3 0.003% 99.990% ( 380, 580 ] 2 0.002% 99.992% ( 580, 870 ] 1 0.001% 99.993% ( 870, 1300 ] 2 0.002% 99.995% ( 1900, 2900 ] 3 0.003% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57432 Average: 5.6906 StdDev: 112.58 Min: 0 Median: 1.7897 Max: 7389 Percentiles: P50: 1.79 P75: 2.52 P99: 8.16 P99.9: 239.59 P99.99: 4896.50 ------------------------------------------------------ [ 0, 1 ] 2250 3.918% 3.918% # ( 1, 2 ] 33514 58.354% 62.272% ############ ( 2, 3 ] 14083 24.521% 86.793% ##### ( 3, 4 ] 3091 5.382% 92.175% # ( 4, 6 ] 3586 6.244% 98.419% # ( 6, 10 ] 617 1.074% 99.493% ( 10, 15 ] 168 0.293% 99.786% ( 15, 22 ] 37 0.064% 99.850% ( 22, 34 ] 3 0.005% 99.855% ( 34, 51 ] 6 0.010% 99.866% ( 51, 76 ] 8 0.014% 99.880% ( 76, 110 ] 1 0.002% 99.882% ( 110, 170 ] 1 0.002% 99.883% ( 170, 250 ] 11 0.019% 99.902% ( 250, 380 ] 9 0.016% 99.918% ( 380, 580 ] 5 0.009% 99.927% ( 580, 870 ] 2 0.003% 99.930% ( 870, 1300 ] 3 0.005% 99.936% ( 1300, 1900 ] 3 0.005% 99.941% ( 1900, 2900 ] 9 0.016% 99.956% ( 2900, 4400 ] 17 0.030% 99.986% ( 4400, 6600 ] 10 0.017% 100.003% ( 6600, 9900 ] 3 0.005% 100.009% ** Level 4 read latency histogram (micros): Count: 15 Average: 3580.2000 StdDev: 1656.60 Min: 1028 Median: 3650.0000 Max: 6198 Percentiles: P50: 3650.00 P75: 4950.00 P99: 6198.00 P99.9: 6198.00 P99.99: 6198.00 ------------------------------------------------------ ( 870, 1300 ] 1 6.667% 6.667% # ( 1300, 1900 ] 2 13.333% 20.000% ### ( 1900, 2900 ] 2 13.333% 33.333% ### ( 2900, 4400 ] 5 33.333% 66.667% ####### ( 4400, 6600 ] 5 33.333% 100.000% ####### ** Level 5 read latency histogram (micros): Count: 80 Average: 785.9750 StdDev: 1084.89 Min: 76 Median: 186.0000 Max: 4228 Percentiles: P50: 186.00 P75: 821.67 P99: 4200.00 P99.9: 4228.00 P99.99: 4228.00 ------------------------------------------------------ ( 51, 76 ] 1 1.250% 1.250% ( 76, 110 ] 17 21.250% 22.500% #### ( 110, 170 ] 21 26.250% 48.750% ##### ( 170, 250 ] 5 6.250% 55.000% # ( 250, 380 ] 2 2.500% 57.500% # ( 380, 580 ] 9 11.250% 68.750% ## ( 580, 870 ] 6 7.500% 76.250% ## ( 870, 1300 ] 1 1.250% 77.500% ( 1300, 1900 ] 5 6.250% 83.750% # ( 1900, 2900 ] 7 8.750% 92.500% ## ( 2900, 4400 ] 6 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 15.2 total, 3.2 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 324.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:2.114 H:M:S, 13.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 309.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.592 H:M:S, 18.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/13-21:57:53 ... thread 0: (1000000,6000000) ops and (194034.3,298097.2) ops/second in (5.153728,20.127661) 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/8 3.99 GB 239.1 4.4 0.0 4.4 10.0 5.7 0.0 1.8 134.6 308.9 33.22 31.15 97 0.343 4541K 4845 0.0 0.0 L1 5/5 553.07 MB 0.0 1.4 1.4 0.0 1.4 1.4 0.2 1.0 236.1 235.2 6.15 6.00 2 3.073 1473K 5208 0.0 0.0 L2 2/0 54.05 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.9 2.0 255.5 255.3 1.48 1.42 2 0.740 383K 193 0.0 0.0 L3 16/0 903.53 MB 0.9 0.8 0.6 0.2 0.8 0.6 0.6 1.4 201.1 200.9 3.96 3.49 3 1.321 809K 854 0.0 0.0 L4 167/0 9.45 GB 1.0 0.0 0.0 0.0 0.0 0.0 1.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1056/0 86.86 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 1264/13 101.79 GB 0.0 6.9 2.2 4.8 12.6 7.8 4.4 2.2 158.4 287.5 44.81 42.06 104 0.431 7207K 11K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.9 2.2 4.8 12.6 7.8 4.3 2.2 158.4 287.5 44.81 42.06 104 0.431 7207K 11K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.9 2.2 4.8 6.9 2.1 0.0 0.0 249.9 249.5 28.41 27.43 23 1.235 7207K 11K 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 353.3 16.40 14.62 81 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 20.3 total, 20.1 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 12.58 GB write, 633.80 MB/s write, 6.93 GB read, 349.24 MB/s read, 44.8 seconds Interval compaction: 12.58 GB write, 640.01 MB/s write, 6.93 GB read, 352.66 MB/s read, 44.8 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: 19, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 8, total-stops: 19, interval: 27 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1978675 Average: 2.3025 StdDev: 9.57 Min: 0 Median: 1.5606 Max: 3871 Percentiles: P50: 1.56 P75: 1.93 P99: 5.78 P99.9: 11.42 P99.99: 15.83 ------------------------------------------------------ [ 0, 1 ] 244365 12.350% 12.350% ## ( 1, 2 ] 1328936 67.163% 79.513% ############# ( 2, 3 ] 279736 14.138% 93.650% ### ( 3, 4 ] 55923 2.826% 96.477% # ( 4, 6 ] 56248 2.843% 99.319% # ( 6, 10 ] 10793 0.545% 99.865% ( 10, 15 ] 2448 0.124% 99.989% ( 15, 22 ] 237 0.012% 100.001% ( 22, 34 ] 36 0.002% 100.002% ( 34, 51 ] 15 0.001% 100.003% ( 51, 76 ] 12 0.001% 100.004% ( 76, 110 ] 59 0.003% 100.007% ( 110, 170 ] 128 0.006% 100.013% ( 170, 250 ] 68 0.003% 100.017% ( 250, 380 ] 46 0.002% 100.019% ( 380, 580 ] 63 0.003% 100.022% ( 580, 870 ] 52 0.003% 100.025% ( 870, 1300 ] 22 0.001% 100.026% ( 1300, 1900 ] 6 0.000% 100.026% ( 1900, 2900 ] 7 0.000% 100.027% ( 2900, 4400 ] 4 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 210555 Average: 2.6518 StdDev: 11.98 Min: 1 Median: 1.6504 Max: 1816 Percentiles: P50: 1.65 P75: 2.14 P99: 7.88 P99.9: 82.50 P99.99: 341.34 ------------------------------------------------------ [ 0, 1 ] 17703 8.408% 8.408% ## ( 1, 2 ] 134640 63.945% 72.353% ############# ( 2, 3 ] 38735 18.397% 90.750% #### ( 3, 4 ] 7300 3.467% 94.217% # ( 4, 6 ] 8779 4.169% 98.386% # ( 6, 10 ] 2753 1.307% 99.694% ( 10, 15 ] 361 0.171% 99.865% ( 15, 22 ] 46 0.022% 99.887% ( 22, 34 ] 1 0.000% 99.887% ( 34, 51 ] 1 0.000% 99.888% ( 51, 76 ] 1 0.000% 99.888% ( 76, 110 ] 133 0.063% 99.952% ( 110, 170 ] 59 0.028% 99.980% ( 170, 250 ] 11 0.005% 99.985% ( 250, 380 ] 17 0.008% 99.993% ( 380, 580 ] 17 0.008% 100.001% ( 580, 870 ] 4 0.002% 100.003% ( 870, 1300 ] 5 0.002% 100.005% ( 1300, 1900 ] 5 0.002% 100.008% ** Level 2 read latency histogram (micros): Count: 95440 Average: 2.3185 StdDev: 24.54 Min: 0 Median: 1.4827 Max: 4685 Percentiles: P50: 1.48 P75: 1.86 P99: 5.71 P99.9: 10.23 P99.99: 425.60 ------------------------------------------------------ [ 0, 1 ] 17389 18.220% 18.220% #### ( 1, 2 ] 62837 65.839% 84.059% ############# ( 2, 3 ] 9675 10.137% 94.196% ## ( 3, 4 ] 2386 2.500% 96.696% # ( 4, 6 ] 2570 2.693% 99.389% # ( 6, 10 ] 484 0.507% 99.896% ( 10, 15 ] 77 0.081% 99.977% ( 15, 22 ] 3 0.003% 99.980% ( 22, 34 ] 1 0.001% 99.981% ( 51, 76 ] 3 0.003% 99.984% ( 170, 250 ] 2 0.002% 99.986% ( 250, 380 ] 3 0.003% 99.990% ( 380, 580 ] 2 0.002% 99.992% ( 580, 870 ] 1 0.001% 99.993% ( 870, 1300 ] 2 0.002% 99.995% ( 1900, 2900 ] 3 0.003% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57432 Average: 5.6906 StdDev: 112.58 Min: 0 Median: 1.7897 Max: 7389 Percentiles: P50: 1.79 P75: 2.52 P99: 8.16 P99.9: 239.59 P99.99: 4896.50 ------------------------------------------------------ [ 0, 1 ] 2250 3.918% 3.918% # ( 1, 2 ] 33514 58.354% 62.272% ############ ( 2, 3 ] 14083 24.521% 86.793% ##### ( 3, 4 ] 3091 5.382% 92.175% # ( 4, 6 ] 3586 6.244% 98.419% # ( 6, 10 ] 617 1.074% 99.493% ( 10, 15 ] 168 0.293% 99.786% ( 15, 22 ] 37 0.064% 99.850% ( 22, 34 ] 3 0.005% 99.855% ( 34, 51 ] 6 0.010% 99.866% ( 51, 76 ] 8 0.014% 99.880% ( 76, 110 ] 1 0.002% 99.882% ( 110, 170 ] 1 0.002% 99.883% ( 170, 250 ] 11 0.019% 99.902% ( 250, 380 ] 9 0.016% 99.918% ( 380, 580 ] 5 0.009% 99.927% ( 580, 870 ] 2 0.003% 99.930% ( 870, 1300 ] 3 0.005% 99.936% ( 1300, 1900 ] 3 0.005% 99.941% ( 1900, 2900 ] 9 0.016% 99.956% ( 2900, 4400 ] 17 0.030% 99.986% ( 4400, 6600 ] 10 0.017% 100.003% ( 6600, 9900 ] 3 0.005% 100.009% ** Level 4 read latency histogram (micros): Count: 15 Average: 3580.2000 StdDev: 1656.60 Min: 1028 Median: 3650.0000 Max: 6198 Percentiles: P50: 3650.00 P75: 4950.00 P99: 6198.00 P99.9: 6198.00 P99.99: 6198.00 ------------------------------------------------------ ( 870, 1300 ] 1 6.667% 6.667% # ( 1300, 1900 ] 2 13.333% 20.000% ### ( 1900, 2900 ] 2 13.333% 33.333% ### ( 2900, 4400 ] 5 33.333% 66.667% ####### ( 4400, 6600 ] 5 33.333% 100.000% ####### ** Level 5 read latency histogram (micros): Count: 80 Average: 785.9750 StdDev: 1084.89 Min: 76 Median: 186.0000 Max: 4228 Percentiles: P50: 186.00 P75: 821.67 P99: 4200.00 P99.9: 4228.00 P99.99: 4228.00 ------------------------------------------------------ ( 51, 76 ] 1 1.250% 1.250% ( 76, 110 ] 17 21.250% 22.500% #### ( 110, 170 ] 21 26.250% 48.750% ##### ( 170, 250 ] 5 6.250% 55.000% # ( 250, 380 ] 2 2.500% 57.500% # ( 380, 580 ] 9 11.250% 68.750% ## ( 580, 870 ] 6 7.500% 76.250% ## ( 870, 1300 ] 1 1.250% 77.500% ( 1300, 1900 ] 5 6.250% 83.750% # ( 1900, 2900 ] 7 8.750% 92.500% ## ( 2900, 4400 ] 6 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 20.3 total, 5.2 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 290.52 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:4.566 H:M:S, 22.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 190.97 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.451 H:M:S, 47.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/13-21:58:17 ... thread 0: (1000000,7000000) ops and (41227.3,157716.5) ops/second in (24.255785,44.383446) 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/13 3.38 GB 69.2 5.2 0.0 5.2 11.9 6.7 0.0 1.8 134.5 309.0 39.33 36.88 116 0.339 5373K 5706 0.0 0.0 L1 18/18 2.18 GB 0.0 3.6 3.1 0.5 3.6 3.0 0.2 1.2 230.0 228.3 16.10 15.60 3 5.367 3760K 27K 0.0 0.0 L2 2/0 54.05 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.9 2.0 255.5 255.3 1.48 1.42 2 0.740 383K 193 0.0 0.0 L3 16/0 903.53 MB 0.9 0.8 0.6 0.2 0.8 0.6 0.6 1.4 201.1 200.9 3.96 3.49 3 1.321 809K 854 0.0 0.0 L4 167/0 9.45 GB 1.0 0.0 0.0 0.0 0.0 0.0 1.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1056/0 86.86 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 1276/31 102.81 GB 0.0 9.9 3.8 6.1 16.6 10.5 4.4 2.5 167.1 279.3 60.87 57.40 124 0.491 10M 34K 0.0 0.0 Int 0/0 0.00 KB 0.0 9.9 3.8 6.1 16.6 10.5 4.3 2.5 167.1 279.3 60.87 57.40 124 0.491 10M 34K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 9.9 3.8 6.1 9.9 3.8 0.0 0.0 245.6 244.8 41.40 40.04 27 1.533 10M 34K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.7 6.7 0.0 0.0 0.0 352.7 19.47 17.37 97 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): 44.6 total, 44.4 interval Flush(GB): cumulative 6.706, interval 6.706 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 16.60 GB write, 381.35 MB/s write, 9.93 GB read, 228.11 MB/s read, 60.9 seconds Interval compaction: 16.60 GB write, 383.05 MB/s write, 9.93 GB read, 229.13 MB/s read, 60.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: 21, pending-compaction-bytes-delays: 6, pending-compaction-bytes-stops: 0, total-delays: 18, total-stops: 21, interval: 39 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2908056 Average: 2.6967 StdDev: 13.94 Min: 0 Median: 1.5102 Max: 4020 Percentiles: P50: 1.51 P75: 1.88 P99: 6.02 P99.9: 141.75 P99.99: 303.67 ------------------------------------------------------ [ 0, 1 ] 456284 15.690% 15.690% ### ( 1, 2 ] 1955638 67.249% 82.939% ############# ( 2, 3 ] 324060 11.144% 94.083% ## ( 3, 4 ] 69780 2.400% 96.482% ( 4, 6 ] 73123 2.514% 98.997% # ( 6, 10 ] 15204 0.523% 99.520% ( 10, 15 ] 3420 0.118% 99.637% ( 15, 22 ] 590 0.020% 99.658% ( 22, 34 ] 44 0.002% 99.659% ( 34, 51 ] 23 0.001% 99.660% ( 51, 76 ] 19 0.001% 99.661% ( 76, 110 ] 4959 0.171% 99.831% ( 110, 170 ] 3787 0.130% 99.961% ( 170, 250 ] 641 0.022% 99.983% ( 250, 380 ] 468 0.016% 99.999% ( 380, 580 ] 409 0.014% 100.014% ( 580, 870 ] 154 0.005% 100.019% ( 870, 1300 ] 35 0.001% 100.020% ( 1300, 1900 ] 10 0.000% 100.020% ( 1900, 2900 ] 8 0.000% 100.021% ( 2900, 4400 ] 10 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 789383 Average: 2.5894 StdDev: 13.39 Min: 1 Median: 1.4163 Max: 2401 Percentiles: P50: 1.42 P75: 1.81 P99: 7.70 P99.9: 146.79 P99.99: 512.68 ------------------------------------------------------ [ 0, 1 ] 183598 23.258% 23.258% ##### ( 1, 2 ] 507035 64.232% 87.490% ############# ( 2, 3 ] 54058 6.848% 94.338% # ( 3, 4 ] 14730 1.866% 96.204% ( 4, 6 ] 19431 2.462% 98.666% ( 6, 10 ] 6213 0.787% 99.453% ( 10, 15 ] 1008 0.128% 99.581% ( 15, 22 ] 305 0.039% 99.619% ( 22, 34 ] 5 0.001% 99.620% ( 34, 51 ] 2 0.000% 99.620% ( 51, 76 ] 3 0.000% 99.621% ( 76, 110 ] 1506 0.191% 99.811% ( 110, 170 ] 1141 0.145% 99.956% ( 170, 250 ] 116 0.015% 99.971% ( 250, 380 ] 98 0.012% 99.983% ( 380, 580 ] 83 0.011% 99.994% ( 580, 870 ] 33 0.004% 99.998% ( 870, 1300 ] 19 0.002% 100.000% ( 1300, 1900 ] 12 0.002% 100.002% ( 1900, 2900 ] 2 0.000% 100.002% ** Level 2 read latency histogram (micros): Count: 95440 Average: 2.3185 StdDev: 24.54 Min: 0 Median: 1.4827 Max: 4685 Percentiles: P50: 1.48 P75: 1.86 P99: 5.71 P99.9: 10.23 P99.99: 425.60 ------------------------------------------------------ [ 0, 1 ] 17389 18.220% 18.220% #### ( 1, 2 ] 62837 65.839% 84.059% ############# ( 2, 3 ] 9675 10.137% 94.196% ## ( 3, 4 ] 2386 2.500% 96.696% # ( 4, 6 ] 2570 2.693% 99.389% # ( 6, 10 ] 484 0.507% 99.896% ( 10, 15 ] 77 0.081% 99.977% ( 15, 22 ] 3 0.003% 99.980% ( 22, 34 ] 1 0.001% 99.981% ( 51, 76 ] 3 0.003% 99.984% ( 170, 250 ] 2 0.002% 99.986% ( 250, 380 ] 3 0.003% 99.990% ( 380, 580 ] 2 0.002% 99.992% ( 580, 870 ] 1 0.001% 99.993% ( 870, 1300 ] 2 0.002% 99.995% ( 1900, 2900 ] 3 0.003% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57432 Average: 5.6906 StdDev: 112.58 Min: 0 Median: 1.7897 Max: 7389 Percentiles: P50: 1.79 P75: 2.52 P99: 8.16 P99.9: 239.59 P99.99: 4896.50 ------------------------------------------------------ [ 0, 1 ] 2250 3.918% 3.918% # ( 1, 2 ] 33514 58.354% 62.272% ############ ( 2, 3 ] 14083 24.521% 86.793% ##### ( 3, 4 ] 3091 5.382% 92.175% # ( 4, 6 ] 3586 6.244% 98.419% # ( 6, 10 ] 617 1.074% 99.493% ( 10, 15 ] 168 0.293% 99.786% ( 15, 22 ] 37 0.064% 99.850% ( 22, 34 ] 3 0.005% 99.855% ( 34, 51 ] 6 0.010% 99.866% ( 51, 76 ] 8 0.014% 99.880% ( 76, 110 ] 1 0.002% 99.882% ( 110, 170 ] 1 0.002% 99.883% ( 170, 250 ] 11 0.019% 99.902% ( 250, 380 ] 9 0.016% 99.918% ( 380, 580 ] 5 0.009% 99.927% ( 580, 870 ] 2 0.003% 99.930% ( 870, 1300 ] 3 0.005% 99.936% ( 1300, 1900 ] 3 0.005% 99.941% ( 1900, 2900 ] 9 0.016% 99.956% ( 2900, 4400 ] 17 0.030% 99.986% ( 4400, 6600 ] 10 0.017% 100.003% ( 6600, 9900 ] 3 0.005% 100.009% ** Level 4 read latency histogram (micros): Count: 15 Average: 3580.2000 StdDev: 1656.60 Min: 1028 Median: 3650.0000 Max: 6198 Percentiles: P50: 3650.00 P75: 4950.00 P99: 6198.00 P99.9: 6198.00 P99.99: 6198.00 ------------------------------------------------------ ( 870, 1300 ] 1 6.667% 6.667% # ( 1300, 1900 ] 2 13.333% 20.000% ### ( 1900, 2900 ] 2 13.333% 33.333% ### ( 2900, 4400 ] 5 33.333% 66.667% ####### ( 4400, 6600 ] 5 33.333% 100.000% ####### ** Level 5 read latency histogram (micros): Count: 80 Average: 785.9750 StdDev: 1084.89 Min: 76 Median: 186.0000 Max: 4228 Percentiles: P50: 186.00 P75: 821.67 P99: 4200.00 P99.9: 4228.00 P99.99: 4228.00 ------------------------------------------------------ ( 51, 76 ] 1 1.250% 1.250% ( 76, 110 ] 17 21.250% 22.500% #### ( 110, 170 ] 21 26.250% 48.750% ##### ( 170, 250 ] 5 6.250% 55.000% # ( 250, 380 ] 2 2.500% 57.500% # ( 380, 580 ] 9 11.250% 68.750% ## ( 580, 870 ] 6 7.500% 76.250% ## ( 870, 1300 ] 1 1.250% 77.500% ( 1300, 1900 ] 5 6.250% 83.750% # ( 1900, 2900 ] 7 8.750% 92.500% ## ( 2900, 4400 ] 6 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 44.6 total, 24.3 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 154.53 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:25.885 H:M:S, 58.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 40.57 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:21.319 H:M:S, 87.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 2024/07/13-21:58:24 ... thread 0: (1000000,8000000) ops and (143126.5,155732.1) ops/second in (6.986826,51.370272) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/6 1.60 GB 18.9 5.8 0.0 5.8 13.5 7.6 0.0 1.8 121.4 279.6 49.31 42.26 128 0.385 6076K 6651 0.0 0.0 L1 0/0 0.00 KB 0.0 8.5 5.8 2.7 8.4 5.7 0.2 1.4 223.6 220.4 38.91 36.37 4 9.728 8837K 125K 0.0 0.0 L2 6/4 519.58 MB 1.5 1.2 1.0 0.2 1.2 1.0 4.9 1.2 156.2 155.7 7.82 5.40 4 1.955 438K 193 0.0 0.0 L3 29/8 2.20 GB 1.9 3.8 2.7 1.1 3.8 2.7 2.8 1.4 140.9 139.9 27.77 18.10 13 2.136 3973K 25K 0.0 0.0 L4 183/5 11.13 GB 1.1 3.1 2.7 0.4 3.1 2.7 1.5 1.2 122.3 121.6 26.04 14.97 28 0.930 3165K 13K 0.0 0.0 L5 1072/0 88.15 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1298/23 103.59 GB 0.0 22.5 12.1 10.3 29.9 19.6 12.2 3.9 153.5 204.4 149.86 117.10 177 0.847 22M 171K 0.0 0.0 Int 0/0 0.00 KB 0.0 22.5 12.1 10.3 29.9 19.6 12.1 3.9 153.5 204.4 149.86 117.10 177 0.847 22M 171K 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 12.1 10.3 22.3 11.9 0.0 0.0 185.4 184.0 124.07 97.20 70 1.772 22M 171K 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 303.0 25.78 19.90 107 0.241 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): 51.6 total, 51.4 interval Flush(GB): cumulative 7.628, interval 7.628 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: 29.92 GB write, 594.11 MB/s write, 22.47 GB read, 446.09 MB/s read, 149.9 seconds Interval compaction: 29.92 GB write, 596.38 MB/s write, 22.47 GB read, 447.80 MB/s read, 149.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: 62, pending-compaction-bytes-delays: 8, pending-compaction-bytes-stops: 0, total-delays: 20, total-stops: 62, interval: 82 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3111187 Average: 2.9141 StdDev: 27.29 Min: 0 Median: 1.5343 Max: 13824 Percentiles: P50: 1.53 P75: 1.91 P99: 6.76 P99.9: 145.85 P99.99: 419.22 ------------------------------------------------------ [ 0, 1 ] 459644 14.774% 14.774% ### ( 1, 2 ] 2051121 65.927% 80.701% ############# ( 2, 3 ] 377891 12.146% 92.847% ## ( 3, 4 ] 89699 2.883% 95.731% # ( 4, 6 ] 98025 3.151% 98.881% # ( 6, 10 ] 19575 0.629% 99.510% ( 10, 15 ] 4122 0.132% 99.643% ( 15, 22 ] 669 0.022% 99.664% ( 22, 34 ] 52 0.002% 99.666% ( 34, 51 ] 25 0.001% 99.667% ( 51, 76 ] 22 0.001% 99.668% ( 76, 110 ] 4961 0.159% 99.827% ( 110, 170 ] 3799 0.122% 99.949% ( 170, 250 ] 664 0.021% 99.970% ( 250, 380 ] 510 0.016% 99.987% ( 380, 580 ] 494 0.016% 100.003% ( 580, 870 ] 250 0.008% 100.011% ( 870, 1300 ] 106 0.003% 100.014% ( 1300, 1900 ] 55 0.002% 100.016% ( 1900, 2900 ] 48 0.002% 100.018% ( 2900, 4400 ] 44 0.001% 100.019% ( 4400, 6600 ] 18 0.001% 100.020% ( 6600, 9900 ] 2 0.000% 100.020% ( 9900, 14000 ] 1 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 1941374 Average: 7.0031 StdDev: 118.64 Min: 1 Median: 1.8002 Max: 21506 Percentiles: P50: 1.80 P75: 2.71 P99: 9.46 P99.9: 124.43 P99.99: 413.64 ------------------------------------------------------ [ 0, 1 ] 189090 9.740% 9.740% ## ( 1, 2 ] 976777 50.314% 60.054% ########## ( 2, 3 ] 410896 21.165% 81.219% #### ( 3, 4 ] 137041 7.059% 88.278% # ( 4, 6 ] 171775 8.848% 97.126% ## ( 6, 10 ] 42030 2.165% 99.291% ( 10, 15 ] 8547 0.440% 99.731% ( 15, 22 ] 1294 0.067% 99.798% ( 22, 34 ] 75 0.004% 99.802% ( 34, 51 ] 45 0.002% 99.804% ( 51, 76 ] 18 0.001% 99.805% ( 76, 110 ] 1545 0.080% 99.885% ( 110, 170 ] 1246 0.064% 99.949% ( 170, 250 ] 272 0.014% 99.963% ( 250, 380 ] 416 0.021% 99.984% ( 380, 580 ] 671 0.035% 100.019% ( 580, 870 ] 819 0.042% 100.061% ( 870, 1300 ] 614 0.032% 100.093% ( 1300, 1900 ] 439 0.023% 100.115% ( 1900, 2900 ] 552 0.028% 100.144% ( 2900, 4400 ] 651 0.034% 100.177% ( 4400, 6600 ] 222 0.011% 100.189% ( 6600, 9900 ] 88 0.005% 100.193% ( 9900, 14000 ] 5 0.000% 100.193% ( 14000, 22000 ] 6 0.000% 100.194% ** Level 2 read latency histogram (micros): Count: 196823 Average: 5.9392 StdDev: 88.91 Min: 0 Median: 1.7712 Max: 7231 Percentiles: P50: 1.77 P75: 2.61 P99: 8.74 P99.9: 516.78 P99.99: 1039.12 ------------------------------------------------------ [ 0, 1 ] 17706 8.996% 8.996% ## ( 1, 2 ] 104648 53.169% 62.164% ########### ( 2, 3 ] 41090 20.877% 83.041% #### ( 3, 4 ] 13563 6.891% 89.932% # ( 4, 6 ] 15812 8.034% 97.966% ## ( 6, 10 ] 2975 1.512% 99.477% ( 10, 15 ] 565 0.287% 99.764% ( 15, 22 ] 53 0.027% 99.791% ( 22, 34 ] 6 0.003% 99.794% ( 34, 51 ] 9 0.005% 99.799% ( 51, 76 ] 5 0.003% 99.801% ( 76, 110 ] 2 0.001% 99.802% ( 110, 170 ] 16 0.008% 99.810% ( 170, 250 ] 28 0.014% 99.825% ( 250, 380 ] 78 0.040% 99.864% ( 380, 580 ] 107 0.054% 99.919% ( 580, 870 ] 115 0.058% 99.977% ( 870, 1300 ] 72 0.037% 100.014% ( 1300, 1900 ] 36 0.018% 100.032% ( 1900, 2900 ] 49 0.025% 100.057% ( 2900, 4400 ] 43 0.022% 100.079% ( 4400, 6600 ] 12 0.006% 100.085% ( 6600, 9900 ] 3 0.002% 100.086% ** Level 3 read latency histogram (micros): Count: 641690 Average: 12.0753 StdDev: 158.66 Min: 0 Median: 2.2420 Max: 28157 Percentiles: P50: 2.24 P75: 3.19 P99: 10.34 P99.9: 973.39 P99.99: 1364.55 ------------------------------------------------------ [ 0, 1 ] 4656 0.726% 0.726% ( 1, 2 ] 269308 41.969% 42.694% ######## ( 2, 3 ] 193731 30.191% 72.885% ###### ( 3, 4 ] 71051 11.072% 83.957% ## ( 4, 6 ] 80729 12.581% 96.538% ### ( 6, 10 ] 15568 2.426% 98.964% ( 10, 15 ] 3367 0.525% 99.489% ( 15, 22 ] 399 0.062% 99.551% ( 22, 34 ] 28 0.004% 99.555% ( 34, 51 ] 17 0.003% 99.558% ( 51, 76 ] 10 0.002% 99.560% ( 76, 110 ] 10 0.002% 99.561% ( 110, 170 ] 64 0.010% 99.571% ( 170, 250 ] 143 0.022% 99.593% ( 250, 380 ] 349 0.054% 99.648% ( 380, 580 ] 635 0.099% 99.747% ( 580, 870 ] 815 0.127% 99.874% ( 870, 1300 ] 700 0.109% 99.983% ( 1300, 1900 ] 426 0.066% 100.049% ( 1900, 2900 ] 328 0.051% 100.100% ( 2900, 4400 ] 458 0.071% 100.172% ( 4400, 6600 ] 125 0.019% 100.191% ( 6600, 9900 ] 28 0.004% 100.196% ( 9900, 14000 ] 1 0.000% 100.196% ( 22000, 33000 ] 1 0.000% 100.196% ** Level 4 read latency histogram (micros): Count: 22546 Average: 15.2482 StdDev: 187.26 Min: 1 Median: 2.2537 Max: 7281 Percentiles: P50: 2.25 P75: 3.23 P99: 21.18 P99.9: 3354.50 P99.99: 6103.99 ------------------------------------------------------ [ 0, 1 ] 110 0.488% 0.488% ( 1, 2 ] 9431 41.830% 42.318% ######## ( 2, 3 ] 6828 30.285% 72.603% ###### ( 3, 4 ] 2350 10.423% 83.026% ## ( 4, 6 ] 2833 12.565% 95.591% ### ( 6, 10 ] 607 2.692% 98.284% # ( 10, 15 ] 143 0.634% 98.918% ( 15, 22 ] 21 0.093% 99.011% ( 22, 34 ] 8 0.035% 99.046% ( 34, 51 ] 2 0.009% 99.055% ( 76, 110 ] 13 0.058% 99.113% ( 110, 170 ] 14 0.062% 99.175% ( 170, 250 ] 40 0.177% 99.352% ( 250, 380 ] 4 0.018% 99.370% ( 380, 580 ] 20 0.089% 99.459% ( 580, 870 ] 26 0.115% 99.574% ( 870, 1300 ] 32 0.142% 99.716% ( 1300, 1900 ] 21 0.093% 99.809% ( 1900, 2900 ] 15 0.067% 99.876% ( 2900, 4400 ] 18 0.080% 99.956% ( 4400, 6600 ] 10 0.044% 100.000% ( 6600, 9900 ] 1 0.004% 100.004% ** Level 5 read latency histogram (micros): Count: 160 Average: 1184.5500 StdDev: 1398.07 Min: 76 Median: 518.4615 Max: 6337 Percentiles: P50: 518.46 P75: 1800.00 P99: 6097.14 P99.9: 6337.00 P99.99: 6337.00 ------------------------------------------------------ ( 51, 76 ] 1 0.625% 0.625% ( 76, 110 ] 17 10.625% 11.250% ## ( 110, 170 ] 24 15.000% 26.250% ### ( 170, 250 ] 6 3.750% 30.000% # ( 250, 380 ] 14 8.750% 38.750% ## ( 380, 580 ] 26 16.250% 55.000% ### ( 580, 870 ] 15 9.375% 64.375% ## ( 870, 1300 ] 7 4.375% 68.750% # ( 1300, 1900 ] 12 7.500% 76.250% ## ( 1900, 2900 ] 14 8.750% 85.000% ## ( 2900, 4400 ] 17 10.625% 95.625% ## ( 4400, 6600 ] 7 4.375% 100.000% # ** DB Stats ** Uptime(secs): 51.6 total, 7.0 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 152.68 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:29.907 H:M:S, 58.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 140.88 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:4.022 H:M:S, 57.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/07/13-21:58:29 ... thread 0: (1000000,9000000) ops and (232130.3,161643.2) ops/second in (4.307926,55.678198) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/10 2.52 GB 81.8 6.5 0.0 6.5 15.1 8.5 0.0 1.8 119.2 275.4 56.00 47.49 142 0.394 6780K 7560 0.0 0.0 L1 0/0 0.00 KB 0.0 8.5 5.8 2.7 8.4 5.7 0.2 1.4 223.6 220.4 38.91 36.37 4 9.728 8837K 125K 0.0 0.0 L2 0/0 0.00 KB 0.0 1.2 1.0 0.2 1.2 1.0 4.9 1.2 156.2 155.7 7.82 5.40 4 1.955 438K 193 0.0 0.0 L3 13/0 927.28 MB 0.9 4.5 3.2 1.3 4.5 3.2 2.8 1.4 141.2 140.3 32.67 21.33 19 1.719 4684K 28K 0.0 0.0 L4 164/0 9.60 GB 1.0 5.2 4.3 0.9 5.1 4.3 1.7 1.2 127.7 127.1 41.34 24.66 46 0.899 5282K 23K 0.0 0.0 L5 1112/0 91.48 GB 0.9 0.0 0.0 0.0 0.0 0.0 6.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1303/10 104.50 GB 0.0 25.9 14.2 11.6 34.2 22.6 15.7 4.0 149.9 198.4 176.74 135.24 215 0.822 26M 184K 0.0 0.0 Int 0/0 0.00 KB 0.0 25.9 14.2 11.6 34.2 22.6 15.6 4.0 149.9 198.4 176.74 135.24 215 0.822 26M 184K 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 25.9 14.2 11.6 25.7 14.0 0.0 0.0 180.0 178.7 147.16 112.82 96 1.533 26M 184K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 296.1 29.58 22.43 119 0.249 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): 55.9 total, 55.7 interval Flush(GB): cumulative 8.551, interval 8.551 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 34.24 GB write, 627.41 MB/s write, 25.87 GB read, 474.12 MB/s read, 176.7 seconds Interval compaction: 34.24 GB write, 629.63 MB/s write, 25.87 GB read, 475.80 MB/s read, 176.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: 81, pending-compaction-bytes-delays: 8, pending-compaction-bytes-stops: 0, total-delays: 20, total-stops: 81, interval: 101 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3523152 Average: 3.0302 StdDev: 31.50 Min: 0 Median: 1.5643 Max: 13824 Percentiles: P50: 1.56 P75: 1.95 P99: 7.32 P99.9: 142.35 P99.99: 430.34 ------------------------------------------------------ [ 0, 1 ] 475384 13.493% 13.493% ### ( 1, 2 ] 2279264 64.694% 78.187% ############# ( 2, 3 ] 475129 13.486% 91.673% ### ( 3, 4 ] 117324 3.330% 95.003% # ( 4, 6 ] 131702 3.738% 98.741% # ( 6, 10 ] 27629 0.784% 99.525% ( 10, 15 ] 5242 0.149% 99.674% ( 15, 22 ] 803 0.023% 99.697% ( 22, 34 ] 60 0.002% 99.699% ( 34, 51 ] 30 0.001% 99.700% ( 51, 76 ] 24 0.001% 99.700% ( 76, 110 ] 4969 0.141% 99.841% ( 110, 170 ] 3837 0.109% 99.950% ( 170, 250 ] 703 0.020% 99.970% ( 250, 380 ] 560 0.016% 99.986% ( 380, 580 ] 555 0.016% 100.002% ( 580, 870 ] 309 0.009% 100.011% ( 870, 1300 ] 151 0.004% 100.015% ( 1300, 1900 ] 81 0.002% 100.017% ( 1900, 2900 ] 99 0.003% 100.020% ( 2900, 4400 ] 79 0.002% 100.022% ( 4400, 6600 ] 23 0.001% 100.023% ( 6600, 9900 ] 4 0.000% 100.023% ( 9900, 14000 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 2039279 Average: 6.9849 StdDev: 117.20 Min: 1 Median: 1.8153 Max: 21506 Percentiles: P50: 1.82 P75: 2.73 P99: 9.49 P99.9: 131.00 P99.99: 453.12 ------------------------------------------------------ [ 0, 1 ] 189446 9.290% 9.290% ## ( 1, 2 ] 1018230 49.931% 59.221% ########## ( 2, 3 ] 441631 21.656% 80.877% #### ( 3, 4 ] 146485 7.183% 88.060% # ( 4, 6 ] 183640 9.005% 97.065% ## ( 6, 10 ] 45255 2.219% 99.284% ( 10, 15 ] 9055 0.444% 99.728% ( 15, 22 ] 1362 0.067% 99.795% ( 22, 34 ] 83 0.004% 99.799% ( 34, 51 ] 48 0.002% 99.802% ( 51, 76 ] 19 0.001% 99.803% ( 76, 110 ] 1545 0.076% 99.878% ( 110, 170 ] 1259 0.062% 99.940% ( 170, 250 ] 288 0.014% 99.954% ( 250, 380 ] 464 0.023% 99.977% ( 380, 580 ] 725 0.036% 100.013% ( 580, 870 ] 893 0.044% 100.056% ( 870, 1300 ] 668 0.033% 100.089% ( 1300, 1900 ] 465 0.023% 100.112% ( 1900, 2900 ] 567 0.028% 100.140% ( 2900, 4400 ] 674 0.033% 100.173% ( 4400, 6600 ] 228 0.011% 100.184% ( 6600, 9900 ] 88 0.004% 100.188% ( 9900, 14000 ] 5 0.000% 100.188% ( 14000, 22000 ] 6 0.000% 100.189% ** Level 2 read latency histogram (micros): Count: 320951 Average: 7.5916 StdDev: 116.87 Min: 0 Median: 1.9152 Max: 7587 Percentiles: P50: 1.92 P75: 2.84 P99: 9.40 P99.9: 725.08 P99.99: 1847.44 ------------------------------------------------------ [ 0, 1 ] 17982 5.603% 5.603% # ( 1, 2 ] 155695 48.511% 54.113% ########## ( 2, 3 ] 79982 24.920% 79.034% ##### ( 3, 4 ] 26719 8.325% 87.359% ## ( 4, 6 ] 31727 9.885% 97.244% ## ( 6, 10 ] 6638 2.068% 99.312% ( 10, 15 ] 1292 0.403% 99.715% ( 15, 22 ] 157 0.049% 99.764% ( 22, 34 ] 15 0.005% 99.768% ( 34, 51 ] 15 0.005% 99.773% ( 51, 76 ] 5 0.002% 99.774% ( 76, 110 ] 5 0.002% 99.776% ( 110, 170 ] 24 0.007% 99.783% ( 170, 250 ] 39 0.012% 99.796% ( 250, 380 ] 100 0.031% 99.827% ( 380, 580 ] 151 0.047% 99.874% ( 580, 870 ] 168 0.052% 99.926% ( 870, 1300 ] 131 0.041% 99.967% ( 1300, 1900 ] 81 0.025% 99.992% ( 1900, 2900 ] 120 0.037% 100.030% ( 2900, 4400 ] 127 0.040% 100.069% ( 4400, 6600 ] 46 0.014% 100.084% ( 6600, 9900 ] 6 0.002% 100.085% ** Level 3 read latency histogram (micros): Count: 998132 Average: 11.5381 StdDev: 151.88 Min: 0 Median: 2.2224 Max: 28157 Percentiles: P50: 2.22 P75: 3.14 P99: 9.97 P99.9: 933.10 P99.99: 1348.03 ------------------------------------------------------ [ 0, 1 ] 6770 0.678% 0.678% ( 1, 2 ] 425297 42.609% 43.288% ######### ( 2, 3 ] 301255 30.182% 73.469% ###### ( 3, 4 ] 107778 10.798% 84.267% ## ( 4, 6 ] 123123 12.335% 96.603% ## ( 6, 10 ] 24126 2.417% 99.020% ( 10, 15 ] 5116 0.513% 99.532% ( 15, 22 ] 600 0.060% 99.593% ( 22, 34 ] 36 0.004% 99.596% ( 34, 51 ] 26 0.003% 99.599% ( 51, 76 ] 14 0.001% 99.600% ( 76, 110 ] 18 0.002% 99.602% ( 110, 170 ] 128 0.013% 99.615% ( 170, 250 ] 219 0.022% 99.637% ( 250, 380 ] 488 0.049% 99.686% ( 380, 580 ] 869 0.087% 99.773% ( 580, 870 ] 1125 0.113% 99.885% ( 870, 1300 ] 994 0.100% 99.985% ( 1300, 1900 ] 627 0.063% 100.048% ( 1900, 2900 ] 505 0.051% 100.098% ( 2900, 4400 ] 729 0.073% 100.171% ( 4400, 6600 ] 177 0.018% 100.189% ( 6600, 9900 ] 32 0.003% 100.192% ( 9900, 14000 ] 1 0.000% 100.192% ( 22000, 33000 ] 1 0.000% 100.193% ** Level 4 read latency histogram (micros): Count: 95221 Average: 11.6126 StdDev: 140.02 Min: 1 Median: 2.2095 Max: 8470 Percentiles: P50: 2.21 P75: 3.07 P99: 13.47 P99.9: 1913.91 P99.99: 3833.00 ------------------------------------------------------ [ 0, 1 ] 384 0.403% 0.403% ( 1, 2 ] 41080 43.142% 43.545% ######### ( 2, 3 ] 29333 30.805% 74.350% ###### ( 3, 4 ] 9330 9.798% 84.148% ## ( 4, 6 ] 11302 11.869% 96.018% ## ( 6, 10 ] 2498 2.623% 98.641% # ( 10, 15 ] 492 0.517% 99.158% ( 15, 22 ] 58 0.061% 99.219% ( 22, 34 ] 10 0.011% 99.229% ( 34, 51 ] 3 0.003% 99.232% ( 51, 76 ] 1 0.001% 99.233% ( 76, 110 ] 24 0.025% 99.259% ( 110, 170 ] 57 0.060% 99.318% ( 170, 250 ] 92 0.097% 99.415% ( 250, 380 ] 45 0.047% 99.462% ( 380, 580 ] 99 0.104% 99.566% ( 580, 870 ] 130 0.137% 99.703% ( 870, 1300 ] 124 0.130% 99.833% ( 1300, 1900 ] 63 0.066% 99.899% ( 1900, 2900 ] 56 0.059% 99.958% ( 2900, 4400 ] 49 0.051% 100.009% ( 4400, 6600 ] 14 0.015% 100.024% ( 6600, 9900 ] 2 0.002% 100.026% ** Level 5 read latency histogram (micros): Count: 360 Average: 1334.0583 StdDev: 1429.53 Min: 76 Median: 676.6667 Max: 6337 Percentiles: P50: 676.67 P75: 2066.67 P99: 6134.12 P99.9: 6337.00 P99.99: 6337.00 ------------------------------------------------------ ( 51, 76 ] 1 0.278% 0.278% ( 76, 110 ] 23 6.389% 6.667% # ( 110, 170 ] 39 10.833% 17.500% ## ( 170, 250 ] 20 5.556% 23.056% # ( 250, 380 ] 35 9.722% 32.778% ## ( 380, 580 ] 48 13.333% 46.111% ### ( 580, 870 ] 42 11.667% 57.778% ## ( 870, 1300 ] 25 6.944% 64.722% # ( 1300, 1900 ] 32 8.889% 73.611% ## ( 1900, 2900 ] 30 8.333% 81.944% ## ( 2900, 4400 ] 48 13.333% 95.278% ### ( 4400, 6600 ] 17 4.722% 100.000% # ** DB Stats ** Uptime(secs): 55.9 total, 4.3 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 158.52 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:31.411 H:M:S, 56.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 228.44 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.504 H:M:S, 34.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/13-21:58:32 ... thread 0: (1000000,10000000) ops and (330616.9,170349.5) ops/second in (3.024649,58.702847) 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/9 2.03 GB 18.9 7.3 0.0 7.3 16.8 9.5 0.0 1.8 121.1 277.7 61.89 52.99 158 0.392 7611K 8411 0.0 0.0 L1 17/17 1.40 GB 0.0 9.9 7.2 2.7 9.8 7.1 0.2 1.4 219.5 216.6 46.24 42.78 5 9.247 10M 133K 0.0 0.0 L2 0/0 0.00 KB 0.0 1.2 1.0 0.2 1.2 1.0 4.9 1.2 156.2 155.7 7.82 5.40 4 1.955 438K 193 0.0 0.0 L3 13/0 927.28 MB 0.9 4.5 3.2 1.3 4.5 3.2 2.8 1.4 141.2 140.3 32.67 21.33 19 1.719 4684K 28K 0.0 0.0 L4 164/0 9.60 GB 1.0 5.2 4.3 0.9 5.1 4.3 1.7 1.2 127.7 127.1 41.34 24.66 46 0.899 5282K 23K 0.0 0.0 L5 1112/0 91.48 GB 0.9 0.0 0.0 0.0 0.0 0.0 6.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1318/26 105.41 GB 0.0 28.1 15.6 12.4 37.4 24.9 15.7 3.9 151.4 201.4 189.96 147.15 232 0.819 28M 193K 0.0 0.0 Int 0/0 0.00 KB 0.0 28.1 15.6 12.4 37.4 24.9 15.6 3.9 151.4 201.4 189.96 147.15 232 0.819 28M 193K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 28.1 15.6 12.4 27.9 15.5 0.0 0.0 182.4 181.1 157.68 122.33 100 1.577 28M 193K 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 300.5 32.28 24.82 132 0.245 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): 58.9 total, 58.7 interval Flush(GB): cumulative 9.474, interval 9.474 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 37.36 GB write, 649.54 MB/s write, 28.08 GB read, 488.25 MB/s read, 190.0 seconds Interval compaction: 37.36 GB write, 651.72 MB/s write, 28.08 GB read, 489.89 MB/s read, 190.0 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: 86, pending-compaction-bytes-delays: 8, pending-compaction-bytes-stops: 0, total-delays: 20, total-stops: 86, interval: 106 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3849541 Average: 2.9759 StdDev: 30.32 Min: 0 Median: 1.5658 Max: 13824 Percentiles: P50: 1.57 P75: 1.95 P99: 7.20 P99.9: 137.00 P99.99: 390.64 ------------------------------------------------------ [ 0, 1 ] 511852 13.296% 13.296% ### ( 1, 2 ] 2497139 64.868% 78.165% ############# ( 2, 3 ] 525025 13.639% 91.804% ### ( 3, 4 ] 126472 3.285% 95.089% # ( 4, 6 ] 141451 3.674% 98.763% # ( 6, 10 ] 30414 0.790% 99.554% ( 10, 15 ] 5645 0.147% 99.700% ( 15, 22 ] 829 0.022% 99.722% ( 22, 34 ] 64 0.002% 99.723% ( 34, 51 ] 33 0.001% 99.724% ( 51, 76 ] 27 0.001% 99.725% ( 76, 110 ] 4985 0.129% 99.854% ( 110, 170 ] 3901 0.101% 99.956% ( 170, 250 ] 722 0.019% 99.974% ( 250, 380 ] 567 0.015% 99.989% ( 380, 580 ] 565 0.015% 100.004% ( 580, 870 ] 317 0.008% 100.012% ( 870, 1300 ] 158 0.004% 100.016% ( 1300, 1900 ] 82 0.002% 100.018% ( 1900, 2900 ] 101 0.003% 100.021% ( 2900, 4400 ] 80 0.002% 100.023% ( 4400, 6600 ] 23 0.001% 100.024% ( 6600, 9900 ] 4 0.000% 100.024% ( 9900, 14000 ] 1 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 2050742 Average: 6.9793 StdDev: 116.98 Min: 1 Median: 1.8119 Max: 21506 Percentiles: P50: 1.81 P75: 2.72 P99: 9.49 P99.9: 133.82 P99.99: 461.66 ------------------------------------------------------ [ 0, 1 ] 192366 9.380% 9.380% ## ( 1, 2 ] 1025985 50.030% 59.410% ########## ( 2, 3 ] 441894 21.548% 80.958% #### ( 3, 4 ] 146592 7.148% 88.106% # ( 4, 6 ] 183787 8.962% 97.068% ## ( 6, 10 ] 45401 2.214% 99.282% ( 10, 15 ] 9065 0.442% 99.724% ( 15, 22 ] 1363 0.066% 99.791% ( 22, 34 ] 84 0.004% 99.795% ( 34, 51 ] 49 0.002% 99.797% ( 51, 76 ] 20 0.001% 99.798% ( 76, 110 ] 1578 0.077% 99.875% ( 110, 170 ] 1280 0.062% 99.938% ( 170, 250 ] 305 0.015% 99.953% ( 250, 380 ] 468 0.023% 99.975% ( 380, 580 ] 737 0.036% 100.011% ( 580, 870 ] 905 0.044% 100.055% ( 870, 1300 ] 673 0.033% 100.088% ( 1300, 1900 ] 469 0.023% 100.111% ( 1900, 2900 ] 571 0.028% 100.139% ( 2900, 4400 ] 674 0.033% 100.172% ( 4400, 6600 ] 228 0.011% 100.183% ( 6600, 9900 ] 88 0.004% 100.187% ( 9900, 14000 ] 5 0.000% 100.187% ( 14000, 22000 ] 6 0.000% 100.188% ** Level 2 read latency histogram (micros): Count: 320951 Average: 7.5916 StdDev: 116.87 Min: 0 Median: 1.9152 Max: 7587 Percentiles: P50: 1.92 P75: 2.84 P99: 9.40 P99.9: 725.08 P99.99: 1847.44 ------------------------------------------------------ [ 0, 1 ] 17982 5.603% 5.603% # ( 1, 2 ] 155695 48.511% 54.113% ########## ( 2, 3 ] 79982 24.920% 79.034% ##### ( 3, 4 ] 26719 8.325% 87.359% ## ( 4, 6 ] 31727 9.885% 97.244% ## ( 6, 10 ] 6638 2.068% 99.312% ( 10, 15 ] 1292 0.403% 99.715% ( 15, 22 ] 157 0.049% 99.764% ( 22, 34 ] 15 0.005% 99.768% ( 34, 51 ] 15 0.005% 99.773% ( 51, 76 ] 5 0.002% 99.774% ( 76, 110 ] 5 0.002% 99.776% ( 110, 170 ] 24 0.007% 99.783% ( 170, 250 ] 39 0.012% 99.796% ( 250, 380 ] 100 0.031% 99.827% ( 380, 580 ] 151 0.047% 99.874% ( 580, 870 ] 168 0.052% 99.926% ( 870, 1300 ] 131 0.041% 99.967% ( 1300, 1900 ] 81 0.025% 99.992% ( 1900, 2900 ] 120 0.037% 100.030% ( 2900, 4400 ] 127 0.040% 100.069% ( 4400, 6600 ] 46 0.014% 100.084% ( 6600, 9900 ] 6 0.002% 100.085% ** Level 3 read latency histogram (micros): Count: 998132 Average: 11.5381 StdDev: 151.88 Min: 0 Median: 2.2224 Max: 28157 Percentiles: P50: 2.22 P75: 3.14 P99: 9.97 P99.9: 933.10 P99.99: 1348.03 ------------------------------------------------------ [ 0, 1 ] 6770 0.678% 0.678% ( 1, 2 ] 425297 42.609% 43.288% ######### ( 2, 3 ] 301255 30.182% 73.469% ###### ( 3, 4 ] 107778 10.798% 84.267% ## ( 4, 6 ] 123123 12.335% 96.603% ## ( 6, 10 ] 24126 2.417% 99.020% ( 10, 15 ] 5116 0.513% 99.532% ( 15, 22 ] 600 0.060% 99.593% ( 22, 34 ] 36 0.004% 99.596% ( 34, 51 ] 26 0.003% 99.599% ( 51, 76 ] 14 0.001% 99.600% ( 76, 110 ] 18 0.002% 99.602% ( 110, 170 ] 128 0.013% 99.615% ( 170, 250 ] 219 0.022% 99.637% ( 250, 380 ] 488 0.049% 99.686% ( 380, 580 ] 869 0.087% 99.773% ( 580, 870 ] 1125 0.113% 99.885% ( 870, 1300 ] 994 0.100% 99.985% ( 1300, 1900 ] 627 0.063% 100.048% ( 1900, 2900 ] 505 0.051% 100.098% ( 2900, 4400 ] 729 0.073% 100.171% ( 4400, 6600 ] 177 0.018% 100.189% ( 6600, 9900 ] 32 0.003% 100.192% ( 9900, 14000 ] 1 0.000% 100.192% ( 22000, 33000 ] 1 0.000% 100.193% ** Level 4 read latency histogram (micros): Count: 95221 Average: 11.6126 StdDev: 140.02 Min: 1 Median: 2.2095 Max: 8470 Percentiles: P50: 2.21 P75: 3.07 P99: 13.47 P99.9: 1913.91 P99.99: 3833.00 ------------------------------------------------------ [ 0, 1 ] 384 0.403% 0.403% ( 1, 2 ] 41080 43.142% 43.545% ######### ( 2, 3 ] 29333 30.805% 74.350% ###### ( 3, 4 ] 9330 9.798% 84.148% ## ( 4, 6 ] 11302 11.869% 96.018% ## ( 6, 10 ] 2498 2.623% 98.641% # ( 10, 15 ] 492 0.517% 99.158% ( 15, 22 ] 58 0.061% 99.219% ( 22, 34 ] 10 0.011% 99.229% ( 34, 51 ] 3 0.003% 99.232% ( 51, 76 ] 1 0.001% 99.233% ( 76, 110 ] 24 0.025% 99.259% ( 110, 170 ] 57 0.060% 99.318% ( 170, 250 ] 92 0.097% 99.415% ( 250, 380 ] 45 0.047% 99.462% ( 380, 580 ] 99 0.104% 99.566% ( 580, 870 ] 130 0.137% 99.703% ( 870, 1300 ] 124 0.130% 99.833% ( 1300, 1900 ] 63 0.066% 99.899% ( 1900, 2900 ] 56 0.059% 99.958% ( 2900, 4400 ] 49 0.051% 100.009% ( 4400, 6600 ] 14 0.015% 100.024% ( 6600, 9900 ] 2 0.002% 100.026% ** Level 5 read latency histogram (micros): Count: 360 Average: 1334.0583 StdDev: 1429.53 Min: 76 Median: 676.6667 Max: 6337 Percentiles: P50: 676.67 P75: 2066.67 P99: 6134.12 P99.9: 6337.00 P99.99: 6337.00 ------------------------------------------------------ ( 51, 76 ] 1 0.278% 0.278% ( 76, 110 ] 23 6.389% 6.667% # ( 110, 170 ] 39 10.833% 17.500% ## ( 170, 250 ] 20 5.556% 23.056% # ( 250, 380 ] 35 9.722% 32.778% ## ( 380, 580 ] 48 13.333% 46.111% ### ( 580, 870 ] 42 11.667% 57.778% ## ( 870, 1300 ] 25 6.944% 64.722% # ( 1300, 1900 ] 32 8.889% 73.611% ## ( 1900, 2900 ] 30 8.333% 81.944% ## ( 2900, 4400 ] 48 13.333% 95.278% ### ( 4400, 6600 ] 17 4.722% 100.000% # ** DB Stats ** Uptime(secs): 58.9 total, 3.0 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 167.09 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:31.834 H:M:S, 54.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 325.43 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.423 H:M:S, 14.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 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.759 micros/op 173627 ops/sec 60.002 seconds 10417999 operations; 168.2 MB/s Microseconds per write: Count: 10417999 Average: 5.7595 StdDev: 589.73 Min: 0 Median: 1.7241 Max: 815775 Percentiles: P50: 1.72 P75: 2.65 P99: 7.92 P99.9: 1134.50 P99.99: 2770.44 ------------------------------------------------------ [ 0, 1 ] 1456239 13.978% 13.978% ### ( 1, 2 ] 5182885 49.749% 63.727% ########## ( 2, 3 ] 1816086 17.432% 81.160% ### ( 3, 4 ] 1359885 13.053% 94.213% ### ( 4, 6 ] 458184 4.398% 98.611% # ( 6, 10 ] 84635 0.812% 99.423% ( 10, 15 ] 24876 0.239% 99.662% ( 15, 22 ] 7479 0.072% 99.734% ( 22, 34 ] 1529 0.015% 99.749% ( 34, 51 ] 232 0.002% 99.751% ( 51, 76 ] 30 0.000% 99.751% ( 76, 110 ] 7734 0.074% 99.825% ( 110, 170 ] 2438 0.023% 99.849% ( 170, 250 ] 302 0.003% 99.852% ( 250, 380 ] 125 0.001% 99.853% ( 380, 580 ] 24 0.000% 99.853% ( 580, 870 ] 22 0.000% 99.853% ( 870, 1300 ] 7927 0.076% 99.929% ( 1300, 1900 ] 18 0.000% 99.929% ( 1900, 2900 ] 7246 0.070% 99.999% ( 2900, 4400 ] 55 0.001% 100.000% ( 4400, 6600 ] 7 0.000% 100.000% ( 6600, 9900 ] 6 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 75000, 110000 ] 2 0.000% 100.000% ( 110000, 170000 ] 4 0.000% 100.000% ( 170000, 250000 ] 17 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 380000, 570000 ] 1 0.000% 100.000% ( 570000, 860000 ] 4 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 : 206542 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 : 10417999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10751374968 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 : 590 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 32047942 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 : 30889982013 rocksdb.compact.write.bytes COUNT : 30674392567 rocksdb.flush.write.bytes COUNT : 10568993517 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 : 79 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 : 347 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 : 10483981312 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4247552 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 : 31001878694 rocksdb.non.last.level.read.count COUNT : 7483832 rocksdb.block.checksum.compute.count COUNT : 7482731 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.359778 P95 : 3.757898 P99 : 5.996802 P100 : 815773.000000 COUNT : 10417999 SUM : 55208396 rocksdb.compaction.times.micros P50 : 1014545.454545 P95 : 5033333.333333 P99 : 14000000.000000 P100 : 22812591.000000 COUNT : 100 SUM : 157675093 rocksdb.compaction.times.cpu_micros P50 : 773000.000000 P95 : 3600000.000000 P99 : 9800000.000000 P100 : 20767813.000000 COUNT : 100 SUM : 122327035 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 : 708.051948 P95 : 5206.666667 P99 : 96700.000000 P100 : 237397.000000 COUNT : 138 SUM : 516581 rocksdb.compaction.outfile.sync.micros P50 : 1245.447761 P95 : 72403.846154 P99 : 164257.142857 P100 : 282533.000000 COUNT : 367 SUM : 5393325 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 : 145.454545 P95 : 2193.750000 P99 : 4029.285714 P100 : 6373.000000 COUNT : 273 SUM : 123948 rocksdb.table.open.io.micros P50 : 1768.571429 P95 : 9754.411765 P99 : 18628.571429 P100 : 21947.000000 COUNT : 590 SUM : 1665723 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.797630 P95 : 8.476542 P99 : 12.685010 P100 : 28162.000000 COUNT : 7481322 SUM : 57238479 rocksdb.read.block.get.micros P50 : 606.363636 P95 : 4251.851852 P99 : 6274.782609 P100 : 7432.000000 COUNT : 1180 SUM : 1335881 rocksdb.write.raw.block.micros P50 : 0.514128 P95 : 0.976843 P99 : 2.837739 P100 : 29850.000000 COUNT : 10006399 SUM : 23047185 rocksdb.numfiles.in.singlecompaction P50 : 3.159091 P95 : 3.997727 P99 : 24.160000 P100 : 31.000000 COUNT : 164 SUM : 598 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.570392 P95 : 2049.398007 P99 : 2734.197343 P100 : 815588.000000 COUNT : 123709 SUM : 32057983 rocksdb.sst.read.micros P50 : 1.705222 P95 : 5.160620 P99 : 9.210322 P100 : 28157.000000 COUNT : 7484755 SUM : 41890135 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 : 10417999 SUM : 10751374968 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 : 217826.086957 P95 : 524875.000000 P99 : 936582.000000 P100 : 936582.000000 COUNT : 138 SUM : 33523429 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 : 349 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