[2024-12-07 04:35:35.531859] Starting SPDK v25.01-pre git sha1 a2f5e1c2d / DPDK 24.03.0 initialization... [2024-12-07 04:35:35.531961] [ 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_pid1452779 ] Set seed to 1733542535529317 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-07 04:35:35.642133] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-07 04:35:35.746700] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-07 04:35:35.746750] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1452779' to capture a snapshot of events at runtime. [2024-12-07 04:35:35.746761] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-07 04:35:35.746771] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-07 04:35:35.746778] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1452779 for offline analysis/debug. [2024-12-07 04:35:35.748255] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sat Dec 7 04:35:44 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/07-04:35:46 ... thread 0: (1000000,1000000) ops and (339515.7,339515.7) ops/second in (2.945372,2.945372) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/5 567.00 MB 25.2 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 355.1 2.48 2.23 12 0.207 0 0 0.0 0.0 L1 3/3 251.78 MB 0.0 0.2 0.2 0.1 0.2 0.2 0.1 1.3 251.6 251.4 1.00 0.97 1 1.002 255K 184 0.0 0.0 L2 1/0 49.19 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 234.8 234.8 0.48 0.45 1 0.476 113K 31 0.0 0.0 L3 17/0 818.39 MB 0.8 0.1 0.1 0.0 0.1 0.1 0.0 1.0 207.5 207.5 0.30 0.25 1 0.301 63K 0 0.0 0.0 L4 116/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1189/8 97.00 GB 0.0 0.4 0.3 0.1 1.3 1.2 0.2 1.5 100.0 306.9 4.26 3.90 15 0.284 432K 215 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.3 1.2 0.1 1.5 100.0 306.9 4.26 3.90 15 0.284 432K 215 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.3 0.1 0.4 0.3 0.0 0.0 239.6 239.5 1.78 1.66 3 0.593 432K 215 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 355.1 2.48 2.23 12 0.207 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.1 total, 2.9 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.28 GB write, 416.57 MB/s write, 0.42 GB read, 135.73 MB/s read, 4.3 seconds Interval compaction: 1.28 GB write, 443.85 MB/s write, 0.42 GB read, 144.62 MB/s read, 4.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 102771 Average: 1.9615 StdDev: 23.79 Min: 1 Median: 1.2458 Max: 3777 Percentiles: P50: 1.25 P75: 1.65 P99: 3.62 P99.9: 9.78 P99.99: 372.80 ------------------------------------------------------ [ 0, 1 ] 35931 34.962% 34.962% ####### ( 1, 2 ] 62878 61.183% 96.145% ############ ( 2, 3 ] 2310 2.248% 98.393% ( 3, 4 ] 1007 0.980% 99.372% ( 4, 6 ] 371 0.361% 99.733% ( 6, 10 ] 181 0.176% 99.910% ( 10, 15 ] 51 0.050% 99.959% ( 15, 22 ] 12 0.012% 99.971% ( 34, 51 ] 3 0.003% 99.974% ( 51, 76 ] 2 0.002% 99.976% ( 110, 170 ] 5 0.005% 99.981% ( 170, 250 ] 5 0.005% 99.985% ( 250, 380 ] 5 0.005% 99.990% ( 580, 870 ] 1 0.001% 99.991% ( 870, 1300 ] 3 0.003% 99.994% ( 1300, 1900 ] 1 0.001% 99.995% ( 2900, 4400 ] 5 0.005% 100.000% ** Level 1 read latency histogram (micros): Count: 30601 Average: 2.5712 StdDev: 42.85 Min: 1 Median: 1.2450 Max: 6043 Percentiles: P50: 1.25 P75: 1.66 P99: 5.50 P99.9: 184.76 P99.99: 1581.97 ------------------------------------------------------ [ 0, 1 ] 10766 35.182% 35.182% ####### ( 1, 2 ] 18507 60.478% 95.660% ############ ( 2, 3 ] 627 2.049% 97.709% ( 3, 4 ] 273 0.892% 98.601% ( 4, 6 ] 163 0.533% 99.134% ( 6, 10 ] 141 0.461% 99.595% ( 10, 15 ] 38 0.124% 99.719% ( 15, 22 ] 9 0.029% 99.748% ( 22, 34 ] 1 0.003% 99.752% ( 34, 51 ] 1 0.003% 99.755% ( 51, 76 ] 37 0.121% 99.876% ( 76, 110 ] 2 0.007% 99.882% ( 110, 170 ] 3 0.010% 99.892% ( 170, 250 ] 13 0.042% 99.935% ( 250, 380 ] 6 0.020% 99.954% ( 380, 580 ] 7 0.023% 99.977% ( 580, 870 ] 2 0.007% 99.984% ( 870, 1300 ] 1 0.003% 99.987% ( 1300, 1900 ] 2 0.007% 99.993% ( 2900, 4400 ] 1 0.003% 99.997% ( 4400, 6600 ] 1 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 15867 Average: 1.8108 StdDev: 5.92 Min: 0 Median: 1.2391 Max: 625 Percentiles: P50: 1.24 P75: 1.66 P99: 3.64 P99.9: 11.07 P99.99: 303.73 ------------------------------------------------------ [ 0, 1 ] 5697 35.905% 35.905% ####### ( 1, 2 ] 9354 58.953% 94.857% ############ ( 2, 3 ] 567 3.573% 98.431% # ( 3, 4 ] 141 0.889% 99.319% ( 4, 6 ] 61 0.384% 99.704% ( 6, 10 ] 29 0.183% 99.887% ( 10, 15 ] 10 0.063% 99.950% ( 15, 22 ] 3 0.019% 99.968% ( 51, 76 ] 1 0.006% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 1 0.006% 99.987% ( 250, 380 ] 1 0.006% 99.994% ( 580, 870 ] 1 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 85 Average: 1433.7529 StdDev: 2373.71 Min: 0 Median: 155.0000 Max: 9866 Percentiles: P50: 155.00 P75: 2150.00 P99: 9198.75 P99.9: 9829.88 P99.99: 9866.00 ------------------------------------------------------ [ 0, 1 ] 22 25.882% 25.882% ##### ( 1, 2 ] 13 15.294% 41.176% ### ( 2, 3 ] 3 3.529% 44.706% # ( 51, 76 ] 3 3.529% 48.235% # ( 110, 170 ] 2 2.353% 50.588% ( 170, 250 ] 6 7.059% 57.647% # ( 250, 380 ] 2 2.353% 60.000% ( 380, 580 ] 6 7.059% 67.059% # ( 580, 870 ] 2 2.353% 69.412% ( 870, 1300 ] 1 1.176% 70.588% ( 1300, 1900 ] 3 3.529% 74.118% # ( 1900, 2900 ] 3 3.529% 77.647% # ( 2900, 4400 ] 7 8.235% 85.882% ## ( 4400, 6600 ] 8 9.412% 95.294% ## ( 6600, 9900 ] 4 4.706% 100.000% # ** Level 4 read latency histogram (micros): Count: 30 Average: 3059.7667 StdDev: 1860.52 Min: 141 Median: 2775.0000 Max: 7343 Percentiles: P50: 2775.00 P75: 4292.86 P99: 7343.00 P99.9: 7343.00 P99.99: 7343.00 ------------------------------------------------------ ( 110, 170 ] 1 3.333% 3.333% # ( 170, 250 ] 1 3.333% 6.667% # ( 250, 380 ] 1 3.333% 10.000% # ( 580, 870 ] 1 3.333% 13.333% # ( 1300, 1900 ] 4 13.333% 26.667% ### ( 1900, 2900 ] 8 26.667% 53.333% ##### ( 2900, 4400 ] 7 23.333% 76.667% ##### ( 4400, 6600 ] 6 20.000% 96.667% #### ( 6600, 9900 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 3.1 total, 2.9 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 313.44 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.374 H:M:S, 11.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 333.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:0.374 H:M:S, 12.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/07-04:35:50 ... thread 0: (1000000,2000000) ops and (326090.4,332667.7) ops/second in (3.066634,6.012006) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/8 1.23 GB 69.2 0.6 0.0 0.6 2.4 1.8 0.0 1.3 75.6 327.6 7.50 6.86 28 0.268 575K 597 0.0 0.0 L1 2/0 50.46 MB 5.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 241.8 241.3 3.39 3.30 2 1.693 831K 1395 0.0 0.0 L2 5/4 564.25 MB 1.3 0.1 0.1 0.0 0.1 0.1 0.6 1.8 234.8 234.8 0.48 0.45 1 0.476 113K 31 0.0 0.0 L3 17/10 818.39 MB 0.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 207.5 207.5 0.30 0.25 1 0.301 63K 0 0.0 0.0 L4 116/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1195/22 97.98 GB 0.0 1.5 0.6 0.9 3.4 2.5 0.7 1.8 133.8 295.7 11.66 10.85 32 0.364 1583K 2023 0.0 0.0 Int 0/0 0.00 KB 0.0 1.5 0.6 0.9 3.4 2.5 0.6 1.8 133.8 295.7 11.66 10.85 32 0.364 1583K 2023 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.5 0.6 0.9 1.5 0.6 0.0 0.0 247.3 247.0 6.31 6.09 6 1.051 1583K 2023 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 353.0 5.35 4.75 26 0.206 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.2 total, 6.0 interval Flush(GB): cumulative 1.846, interval 1.846 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.37 GB write, 555.52 MB/s write, 1.52 GB read, 251.35 MB/s read, 11.7 seconds Interval compaction: 3.37 GB write, 573.35 MB/s write, 1.52 GB read, 259.42 MB/s read, 11.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 9, interval: 9 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 408871 Average: 2.2758 StdDev: 17.60 Min: 1 Median: 1.5159 Max: 4518 Percentiles: P50: 1.52 P75: 1.90 P99: 5.63 P99.9: 9.76 P99.99: 14.49 ------------------------------------------------------ [ 0, 1 ] 67205 16.437% 16.437% ### ( 1, 2 ] 265995 65.056% 81.493% ############# ( 2, 3 ] 48746 11.922% 93.415% ## ( 3, 4 ] 14758 3.609% 97.024% # ( 4, 6 ] 9908 2.423% 99.448% ( 6, 10 ] 1967 0.481% 99.929% ( 10, 15 ] 281 0.069% 99.997% ( 15, 22 ] 48 0.012% 100.009% ( 22, 34 ] 14 0.003% 100.012% ( 34, 51 ] 4 0.001% 100.013% ( 51, 76 ] 6 0.001% 100.015% ( 110, 170 ] 8 0.002% 100.017% ( 170, 250 ] 13 0.003% 100.020% ( 250, 380 ] 8 0.002% 100.022% ( 380, 580 ] 5 0.001% 100.023% ( 580, 870 ] 4 0.001% 100.024% ( 870, 1300 ] 5 0.001% 100.025% ( 1300, 1900 ] 5 0.001% 100.027% ( 1900, 2900 ] 1 0.000% 100.027% ( 2900, 4400 ] 7 0.002% 100.029% ( 4400, 6600 ] 1 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 128329 Average: 2.5558 StdDev: 22.74 Min: 1 Median: 1.6036 Max: 6043 Percentiles: P50: 1.60 P75: 2.04 P99: 5.94 P99.9: 14.74 P99.99: 534.18 ------------------------------------------------------ [ 0, 1 ] 16707 13.019% 13.019% ### ( 1, 2 ] 78624 61.268% 74.286% ############ ( 2, 3 ] 22005 17.147% 91.434% ### ( 3, 4 ] 5213 4.062% 95.496% # ( 4, 6 ] 4627 3.606% 99.102% # ( 6, 10 ] 839 0.654% 99.755% ( 10, 15 ] 196 0.153% 99.908% ( 15, 22 ] 29 0.023% 99.931% ( 22, 34 ] 2 0.002% 99.932% ( 34, 51 ] 1 0.001% 99.933% ( 51, 76 ] 38 0.030% 99.963% ( 76, 110 ] 2 0.002% 99.964% ( 110, 170 ] 4 0.003% 99.967% ( 170, 250 ] 13 0.010% 99.977% ( 250, 380 ] 10 0.008% 99.985% ( 380, 580 ] 8 0.006% 99.991% ( 580, 870 ] 2 0.002% 99.993% ( 870, 1300 ] 1 0.001% 99.994% ( 1300, 1900 ] 5 0.004% 99.998% ( 1900, 2900 ] 1 0.001% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 15918 Average: 1.8156 StdDev: 5.91 Min: 0 Median: 1.2415 Max: 625 Percentiles: P50: 1.24 P75: 1.67 P99: 3.67 P99.9: 11.54 P99.99: 303.07 ------------------------------------------------------ [ 0, 1 ] 5697 35.790% 35.790% ####### ( 1, 2 ] 9367 58.845% 94.635% ############ ( 2, 3 ] 597 3.750% 98.385% # ( 3, 4 ] 145 0.911% 99.296% ( 4, 6 ] 64 0.402% 99.698% ( 6, 10 ] 29 0.182% 99.881% ( 10, 15 ] 10 0.063% 99.943% ( 15, 22 ] 4 0.025% 99.969% ( 51, 76 ] 1 0.006% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 1 0.006% 99.987% ( 250, 380 ] 1 0.006% 99.994% ( 580, 870 ] 1 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 80889 Average: 4.8337 StdDev: 91.46 Min: 0 Median: 1.7063 Max: 9866 Percentiles: P50: 1.71 P75: 2.36 P99: 9.47 P99.9: 335.84 P99.99: 4380.95 ------------------------------------------------------ [ 0, 1 ] 4863 6.012% 6.012% # ( 1, 2 ] 50378 62.280% 68.292% ############ ( 2, 3 ] 15191 18.780% 87.072% #### ( 3, 4 ] 4641 5.737% 92.810% # ( 4, 6 ] 3701 4.575% 97.385% # ( 6, 10 ] 1507 1.863% 99.248% ( 10, 15 ] 256 0.316% 99.565% ( 15, 22 ] 23 0.028% 99.593% ( 51, 76 ] 4 0.005% 99.598% ( 76, 110 ] 64 0.079% 99.677% ( 110, 170 ] 99 0.122% 99.800% ( 170, 250 ] 59 0.073% 99.873% ( 250, 380 ] 35 0.043% 99.916% ( 380, 580 ] 29 0.036% 99.952% ( 580, 870 ] 14 0.017% 99.969% ( 870, 1300 ] 4 0.005% 99.974% ( 1300, 1900 ] 4 0.005% 99.979% ( 1900, 2900 ] 3 0.004% 99.983% ( 2900, 4400 ] 7 0.009% 99.991% ( 4400, 6600 ] 8 0.010% 100.001% ( 6600, 9900 ] 4 0.005% 100.006% ** Level 4 read latency histogram (micros): Count: 30 Average: 3059.7667 StdDev: 1860.52 Min: 141 Median: 2775.0000 Max: 7343 Percentiles: P50: 2775.00 P75: 4292.86 P99: 7343.00 P99.9: 7343.00 P99.99: 7343.00 ------------------------------------------------------ ( 110, 170 ] 1 3.333% 3.333% # ( 170, 250 ] 1 3.333% 6.667% # ( 250, 380 ] 1 3.333% 10.000% # ( 580, 870 ] 1 3.333% 13.333% # ( 1300, 1900 ] 4 13.333% 26.667% ### ( 1900, 2900 ] 8 26.667% 53.333% ##### ( 2900, 4400 ] 7 23.333% 76.667% ##### ( 4400, 6600 ] 6 20.000% 96.667% #### ( 6600, 9900 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 6.2 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 317.15 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.788 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, 320.94 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.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/12/07-04:35:52 ... thread 0: (1000000,3000000) ops and (350250.2,338329.0) ops/second in (2.855102,8.867108) 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/12 2.09 GB 37.8 1.4 0.0 1.4 4.1 2.7 0.0 1.5 104.4 313.1 13.27 12.27 44 0.302 1407K 1487 0.0 0.0 L1 2/2 50.46 MB 0.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 241.8 241.3 3.39 3.30 2 1.693 831K 1395 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.6 1.8 234.8 234.8 0.48 0.45 1 0.476 113K 31 0.0 0.0 L3 24/0 989.41 MB 1.0 1.4 0.6 0.8 1.4 0.6 0.0 2.3 209.2 209.1 6.99 6.19 4 1.747 1463K 739 0.0 0.0 L4 152/0 9.55 GB 1.0 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 L5 1048/0 86.18 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1241/14 98.84 GB 0.0 3.7 1.2 2.5 6.4 3.9 1.4 2.4 156.6 271.4 24.12 22.20 51 0.473 3815K 3652 0.0 0.0 Int 0/0 0.00 KB 0.0 3.7 1.2 2.5 6.4 3.9 1.3 2.4 156.6 271.4 24.12 22.20 51 0.473 3815K 3652 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.7 1.2 2.5 3.7 1.2 0.0 0.0 232.3 232.0 16.27 15.24 12 1.355 3815K 3652 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 352.9 7.85 6.96 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.1 total, 8.9 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: 6.39 GB write, 722.39 MB/s write, 3.69 GB read, 416.92 MB/s read, 24.1 seconds Interval compaction: 6.39 GB write, 738.11 MB/s write, 3.69 GB read, 425.99 MB/s read, 24.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: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 11, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 681476 Average: 2.3893 StdDev: 16.10 Min: 1 Median: 1.5753 Max: 4518 Percentiles: P50: 1.58 P75: 1.96 P99: 5.79 P99.9: 10.23 P99.99: 17.32 ------------------------------------------------------ [ 0, 1 ] 86404 12.679% 12.679% ### ( 1, 2 ] 442111 64.876% 77.554% ############# ( 2, 3 ] 99351 14.579% 92.133% ### ( 3, 4 ] 28369 4.163% 96.296% # ( 4, 6 ] 20618 3.025% 99.322% # ( 6, 10 ] 3913 0.574% 99.896% ( 10, 15 ] 617 0.091% 99.986% ( 15, 22 ] 75 0.011% 99.997% ( 22, 34 ] 19 0.003% 100.000% ( 34, 51 ] 5 0.001% 100.001% ( 51, 76 ] 9 0.001% 100.002% ( 76, 110 ] 14 0.002% 100.004% ( 110, 170 ] 36 0.005% 100.010% ( 170, 250 ] 30 0.004% 100.014% ( 250, 380 ] 25 0.004% 100.018% ( 380, 580 ] 16 0.002% 100.020% ( 580, 870 ] 10 0.001% 100.021% ( 870, 1300 ] 11 0.002% 100.023% ( 1300, 1900 ] 8 0.001% 100.024% ( 1900, 2900 ] 4 0.001% 100.025% ( 2900, 4400 ] 8 0.001% 100.026% ( 4400, 6600 ] 1 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 207107 Average: 2.5979 StdDev: 17.91 Min: 1 Median: 1.6897 Max: 6043 Percentiles: P50: 1.69 P75: 2.31 P99: 6.16 P99.9: 14.05 P99.99: 357.76 ------------------------------------------------------ [ 0, 1 ] 18484 8.925% 8.925% ## ( 1, 2 ] 123342 59.555% 68.480% ############ ( 2, 3 ] 43245 20.881% 89.360% #### ( 3, 4 ] 10227 4.938% 94.298% # ( 4, 6 ] 9672 4.670% 98.968% # ( 6, 10 ] 1653 0.798% 99.766% ( 10, 15 ] 342 0.165% 99.931% ( 15, 22 ] 50 0.024% 99.956% ( 22, 34 ] 4 0.002% 99.958% ( 34, 51 ] 2 0.001% 99.958% ( 51, 76 ] 38 0.018% 99.977% ( 76, 110 ] 2 0.001% 99.978% ( 110, 170 ] 4 0.002% 99.980% ( 170, 250 ] 13 0.006% 99.986% ( 250, 380 ] 10 0.005% 99.991% ( 380, 580 ] 8 0.004% 99.995% ( 580, 870 ] 2 0.001% 99.996% ( 870, 1300 ] 1 0.000% 99.996% ( 1300, 1900 ] 5 0.002% 99.999% ( 1900, 2900 ] 1 0.000% 99.999% ( 2900, 4400 ] 1 0.000% 100.000% ( 4400, 6600 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28358 Average: 2.4038 StdDev: 17.92 Min: 0 Median: 1.4689 Max: 2531 Percentiles: P50: 1.47 P75: 1.89 P99: 6.64 P99.9: 15.37 P99.99: 692.54 ------------------------------------------------------ [ 0, 1 ] 6221 21.937% 21.937% #### ( 1, 2 ] 16970 59.842% 81.779% ############ ( 2, 3 ] 3159 11.140% 92.919% ## ( 3, 4 ] 892 3.145% 96.065% # ( 4, 6 ] 790 2.786% 98.850% # ( 6, 10 ] 265 0.934% 99.785% ( 10, 15 ] 32 0.113% 99.898% ( 15, 22 ] 12 0.042% 99.940% ( 51, 76 ] 1 0.004% 99.944% ( 110, 170 ] 3 0.011% 99.954% ( 170, 250 ] 3 0.011% 99.965% ( 250, 380 ] 3 0.011% 99.975% ( 380, 580 ] 3 0.011% 99.986% ( 580, 870 ] 3 0.011% 99.996% ( 1900, 2900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 212361 Average: 4.0814 StdDev: 58.80 Min: 0 Median: 1.7173 Max: 9866 Percentiles: P50: 1.72 P75: 2.40 P99: 9.46 P99.9: 281.74 P99.99: 774.10 ------------------------------------------------------ [ 0, 1 ] 12855 6.053% 6.053% # ( 1, 2 ] 130115 61.271% 67.324% ############ ( 2, 3 ] 40994 19.304% 86.628% #### ( 3, 4 ] 12825 6.039% 92.667% # ( 4, 6 ] 9838 4.633% 97.300% # ( 6, 10 ] 4169 1.963% 99.263% ( 10, 15 ] 569 0.268% 99.531% ( 15, 22 ] 97 0.046% 99.577% ( 22, 34 ] 21 0.010% 99.587% ( 34, 51 ] 1 0.000% 99.587% ( 51, 76 ] 4 0.002% 99.589% ( 76, 110 ] 206 0.097% 99.686% ( 110, 170 ] 270 0.127% 99.813% ( 170, 250 ] 159 0.075% 99.888% ( 250, 380 ] 105 0.049% 99.937% ( 380, 580 ] 87 0.041% 99.978% ( 580, 870 ] 37 0.017% 99.996% ( 870, 1300 ] 17 0.008% 100.004% ( 1300, 1900 ] 6 0.003% 100.007% ( 1900, 2900 ] 3 0.001% 100.008% ( 2900, 4400 ] 7 0.003% 100.011% ( 4400, 6600 ] 8 0.004% 100.015% ( 6600, 9900 ] 4 0.002% 100.017% ** Level 4 read latency histogram (micros): Count: 30 Average: 3059.7667 StdDev: 1860.52 Min: 141 Median: 2775.0000 Max: 7343 Percentiles: P50: 2775.00 P75: 4292.86 P99: 7343.00 P99.9: 7343.00 P99.99: 7343.00 ------------------------------------------------------ ( 110, 170 ] 1 3.333% 3.333% # ( 170, 250 ] 1 3.333% 6.667% # ( 250, 380 ] 1 3.333% 10.000% # ( 580, 870 ] 1 3.333% 13.333% # ( 1300, 1900 ] 4 13.333% 26.667% ### ( 1900, 2900 ] 8 26.667% 53.333% ##### ( 2900, 4400 ] 7 23.333% 76.667% ##### ( 4400, 6600 ] 6 20.000% 96.667% #### ( 6600, 9900 ] 1 3.333% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 881.3000 StdDev: 1098.57 Min: 98 Median: 250.0000 Max: 3900 Percentiles: P50: 250.00 P75: 1600.00 P99: 3900.00 P99.9: 3900.00 P99.99: 3900.00 ------------------------------------------------------ ( 76, 110 ] 7 35.000% 35.000% ####### ( 110, 170 ] 2 10.000% 45.000% ## ( 170, 250 ] 1 5.000% 50.000% # ( 380, 580 ] 4 20.000% 70.000% #### ( 1300, 1900 ] 2 10.000% 80.000% ## ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 9.1 total, 2.9 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 325.83 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.980 H:M:S, 10.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 344.71 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.192 H:M:S, 6.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/07-04:35:56 ... thread 0: (1000000,4000000) ops and (271044.1,318559.0) ops/second in (3.689436,12.556544) 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.13 GB 151.0 2.5 0.0 2.5 6.2 3.7 0.0 1.7 121.8 307.5 20.68 19.26 63 0.328 2558K 2729 0.0 0.0 L1 2/2 50.46 MB 0.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 241.8 241.3 3.39 3.30 2 1.693 831K 1395 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.6 1.8 234.8 234.8 0.48 0.45 1 0.476 113K 31 0.0 0.0 L3 24/0 989.41 MB 1.0 1.4 0.6 0.8 1.4 0.6 0.0 2.3 209.2 209.1 6.99 6.19 4 1.747 1463K 739 0.0 0.0 L4 152/0 9.55 GB 1.0 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 L5 1048/0 86.18 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1244/14 99.88 GB 0.0 4.8 1.2 3.6 8.5 4.9 1.4 2.3 155.8 277.5 31.53 29.19 70 0.450 4966K 4894 0.0 0.0 Int 0/0 0.00 KB 0.0 4.8 1.2 3.6 8.5 4.9 1.3 2.3 155.8 277.5 31.53 29.19 70 0.450 4966K 4894 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 1.2 3.6 4.8 1.2 0.0 0.0 238.3 238.1 20.61 19.51 16 1.288 4966K 4894 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 351.8 10.92 9.68 54 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): 12.8 total, 12.6 interval Flush(GB): cumulative 3.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.54 GB write, 686.19 MB/s write, 4.80 GB read, 385.22 MB/s read, 31.5 seconds Interval compaction: 8.54 GB write, 696.73 MB/s write, 4.80 GB read, 391.14 MB/s read, 31.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 2, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 2, 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: 2, total-stops: 15, interval: 17 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1172754 Average: 2.3821 StdDev: 14.12 Min: 1 Median: 1.5776 Max: 4518 Percentiles: P50: 1.58 P75: 1.95 P99: 5.83 P99.9: 9.99 P99.99: 14.90 ------------------------------------------------------ [ 0, 1 ] 137437 11.719% 11.719% ## ( 1, 2 ] 777212 66.272% 77.992% ############# ( 2, 3 ] 171492 14.623% 92.615% ### ( 3, 4 ] 45417 3.873% 96.487% # ( 4, 6 ] 32137 2.740% 99.228% # ( 6, 10 ] 7901 0.674% 99.901% ( 10, 15 ] 1061 0.090% 99.992% ( 15, 22 ] 109 0.009% 100.001% ( 22, 34 ] 25 0.002% 100.003% ( 34, 51 ] 8 0.001% 100.004% ( 51, 76 ] 11 0.001% 100.005% ( 76, 110 ] 47 0.004% 100.009% ( 110, 170 ] 105 0.009% 100.018% ( 170, 250 ] 65 0.006% 100.023% ( 250, 380 ] 50 0.004% 100.028% ( 380, 580 ] 30 0.003% 100.030% ( 580, 870 ] 23 0.002% 100.032% ( 870, 1300 ] 16 0.001% 100.033% ( 1300, 1900 ] 12 0.001% 100.034% ( 1900, 2900 ] 5 0.000% 100.035% ( 2900, 4400 ] 10 0.001% 100.036% ( 4400, 6600 ] 1 0.000% 100.036% ** Level 1 read latency histogram (micros): Count: 208385 Average: 2.6415 StdDev: 18.10 Min: 1 Median: 1.6896 Max: 6043 Percentiles: P50: 1.69 P75: 2.31 P99: 6.33 P99.9: 14.95 P99.99: 383.23 ------------------------------------------------------ [ 0, 1 ] 18573 8.913% 8.913% ## ( 1, 2 ] 124160 59.582% 68.495% ############ ( 2, 3 ] 43480 20.865% 89.360% #### ( 3, 4 ] 10256 4.922% 94.282% # ( 4, 6 ] 9695 4.652% 98.934% # ( 6, 10 ] 1674 0.803% 99.738% ( 10, 15 ] 343 0.165% 99.902% ( 15, 22 ] 50 0.024% 99.926% ( 22, 34 ] 4 0.002% 99.928% ( 34, 51 ] 2 0.001% 99.929% ( 51, 76 ] 38 0.018% 99.947% ( 76, 110 ] 25 0.012% 99.959% ( 110, 170 ] 31 0.015% 99.974% ( 170, 250 ] 18 0.009% 99.983% ( 250, 380 ] 16 0.008% 99.990% ( 380, 580 ] 10 0.005% 99.995% ( 580, 870 ] 2 0.001% 99.996% ( 870, 1300 ] 1 0.000% 99.997% ( 1300, 1900 ] 5 0.002% 99.999% ( 1900, 2900 ] 1 0.000% 100.000% ( 2900, 4400 ] 1 0.000% 100.000% ( 4400, 6600 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28358 Average: 2.4038 StdDev: 17.92 Min: 0 Median: 1.4689 Max: 2531 Percentiles: P50: 1.47 P75: 1.89 P99: 6.64 P99.9: 15.37 P99.99: 692.54 ------------------------------------------------------ [ 0, 1 ] 6221 21.937% 21.937% #### ( 1, 2 ] 16970 59.842% 81.779% ############ ( 2, 3 ] 3159 11.140% 92.919% ## ( 3, 4 ] 892 3.145% 96.065% # ( 4, 6 ] 790 2.786% 98.850% # ( 6, 10 ] 265 0.934% 99.785% ( 10, 15 ] 32 0.113% 99.898% ( 15, 22 ] 12 0.042% 99.940% ( 51, 76 ] 1 0.004% 99.944% ( 110, 170 ] 3 0.011% 99.954% ( 170, 250 ] 3 0.011% 99.965% ( 250, 380 ] 3 0.011% 99.975% ( 380, 580 ] 3 0.011% 99.986% ( 580, 870 ] 3 0.011% 99.996% ( 1900, 2900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 212361 Average: 4.0814 StdDev: 58.80 Min: 0 Median: 1.7173 Max: 9866 Percentiles: P50: 1.72 P75: 2.40 P99: 9.46 P99.9: 281.74 P99.99: 774.10 ------------------------------------------------------ [ 0, 1 ] 12855 6.053% 6.053% # ( 1, 2 ] 130115 61.271% 67.324% ############ ( 2, 3 ] 40994 19.304% 86.628% #### ( 3, 4 ] 12825 6.039% 92.667% # ( 4, 6 ] 9838 4.633% 97.300% # ( 6, 10 ] 4169 1.963% 99.263% ( 10, 15 ] 569 0.268% 99.531% ( 15, 22 ] 97 0.046% 99.577% ( 22, 34 ] 21 0.010% 99.587% ( 34, 51 ] 1 0.000% 99.587% ( 51, 76 ] 4 0.002% 99.589% ( 76, 110 ] 206 0.097% 99.686% ( 110, 170 ] 270 0.127% 99.813% ( 170, 250 ] 159 0.075% 99.888% ( 250, 380 ] 105 0.049% 99.937% ( 380, 580 ] 87 0.041% 99.978% ( 580, 870 ] 37 0.017% 99.996% ( 870, 1300 ] 17 0.008% 100.004% ( 1300, 1900 ] 6 0.003% 100.007% ( 1900, 2900 ] 3 0.001% 100.008% ( 2900, 4400 ] 7 0.003% 100.011% ( 4400, 6600 ] 8 0.004% 100.015% ( 6600, 9900 ] 4 0.002% 100.017% ** Level 4 read latency histogram (micros): Count: 30 Average: 3059.7667 StdDev: 1860.52 Min: 141 Median: 2775.0000 Max: 7343 Percentiles: P50: 2775.00 P75: 4292.86 P99: 7343.00 P99.9: 7343.00 P99.99: 7343.00 ------------------------------------------------------ ( 110, 170 ] 1 3.333% 3.333% # ( 170, 250 ] 1 3.333% 6.667% # ( 250, 380 ] 1 3.333% 10.000% # ( 580, 870 ] 1 3.333% 13.333% # ( 1300, 1900 ] 4 13.333% 26.667% ### ( 1900, 2900 ] 8 26.667% 53.333% ##### ( 2900, 4400 ] 7 23.333% 76.667% ##### ( 4400, 6600 ] 6 20.000% 96.667% #### ( 6600, 9900 ] 1 3.333% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 881.3000 StdDev: 1098.57 Min: 98 Median: 250.0000 Max: 3900 Percentiles: P50: 250.00 P75: 1600.00 P99: 3900.00 P99.9: 3900.00 P99.99: 3900.00 ------------------------------------------------------ ( 76, 110 ] 7 35.000% 35.000% ####### ( 110, 170 ] 2 10.000% 45.000% ## ( 170, 250 ] 1 5.000% 50.000% # ( 380, 580 ] 4 20.000% 70.000% #### ( 1300, 1900 ] 2 10.000% 80.000% ## ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 12.8 total, 3.7 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 308.74 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.976 H:M:S, 15.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 266.76 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.996 H:M:S, 27.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/07-04:35:59 ... thread 0: (1000000,5000000) ops and (343256.1,323209.9) ops/second in (2.913277,15.469821) 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/4 2.64 GB 239.1 3.2 0.0 3.2 7.9 4.7 0.0 1.7 125.2 308.0 26.17 24.42 80 0.327 3326K 3506 0.0 0.0 L1 14/0 1.45 GB 148.8 2.3 1.9 0.4 2.3 1.9 0.1 1.2 229.3 228.2 10.11 9.76 3 3.368 2352K 10K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.6 1.8 234.8 234.8 0.48 0.45 1 0.476 113K 31 0.0 0.0 L3 24/0 989.41 MB 1.0 1.4 0.6 0.8 1.4 0.6 0.0 2.3 209.2 209.1 6.99 6.19 4 1.747 1463K 739 0.0 0.0 L4 152/0 9.55 GB 1.0 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 L5 1048/0 86.18 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1253/4 100.80 GB 0.0 7.0 2.6 4.4 11.7 7.2 1.4 2.5 163.8 272.9 43.74 40.81 88 0.497 7255K 15K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.0 2.6 4.4 11.7 7.2 1.3 2.5 163.8 272.9 43.74 40.81 88 0.497 7255K 15K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.0 2.6 4.4 7.0 2.6 0.0 0.0 237.4 236.9 30.19 28.79 20 1.509 7255K 15K 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 353.3 13.55 12.02 68 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.7 total, 15.5 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: 11.66 GB write, 762.12 MB/s write, 7.00 GB read, 457.48 MB/s read, 43.7 seconds Interval compaction: 11.66 GB write, 771.63 MB/s write, 7.00 GB read, 463.18 MB/s read, 43.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 3, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 3, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 17, interval: 20 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1388081 Average: 2.3299 StdDev: 13.75 Min: 1 Median: 1.5467 Max: 4518 Percentiles: P50: 1.55 P75: 1.92 P99: 5.78 P99.9: 10.30 P99.99: 18.30 ------------------------------------------------------ [ 0, 1 ] 191247 13.778% 13.778% ### ( 1, 2 ] 919649 66.253% 80.031% ############# ( 2, 3 ] 183653 13.231% 93.262% ### ( 3, 4 ] 49318 3.553% 96.815% # ( 4, 6 ] 34012 2.450% 99.265% ( 6, 10 ] 8739 0.630% 99.895% ( 10, 15 ] 1261 0.091% 99.985% ( 15, 22 ] 136 0.010% 99.995% ( 22, 34 ] 28 0.002% 99.997% ( 34, 51 ] 10 0.001% 99.998% ( 51, 76 ] 12 0.001% 99.999% ( 76, 110 ] 56 0.004% 100.003% ( 110, 170 ] 143 0.010% 100.013% ( 170, 250 ] 74 0.005% 100.019% ( 250, 380 ] 55 0.004% 100.022% ( 380, 580 ] 38 0.003% 100.025% ( 580, 870 ] 31 0.002% 100.027% ( 870, 1300 ] 20 0.001% 100.029% ( 1300, 1900 ] 15 0.001% 100.030% ( 1900, 2900 ] 5 0.000% 100.030% ( 2900, 4400 ] 11 0.001% 100.031% ( 4400, 6600 ] 1 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 219989 Average: 2.7528 StdDev: 20.77 Min: 0 Median: 1.6772 Max: 6043 Percentiles: P50: 1.68 P75: 2.28 P99: 6.57 P99.9: 64.82 P99.99: 572.60 ------------------------------------------------------ [ 0, 1 ] 20688 9.404% 9.404% ## ( 1, 2 ] 131877 59.947% 69.351% ############ ( 2, 3 ] 44598 20.273% 89.624% #### ( 3, 4 ] 10487 4.767% 94.391% # ( 4, 6 ] 9881 4.492% 98.883% # ( 6, 10 ] 1812 0.824% 99.706% ( 10, 15 ] 348 0.158% 99.865% ( 15, 22 ] 51 0.023% 99.888% ( 22, 34 ] 4 0.002% 99.890% ( 34, 51 ] 2 0.001% 99.890% ( 51, 76 ] 38 0.017% 99.908% ( 76, 110 ] 47 0.021% 99.929% ( 110, 170 ] 58 0.026% 99.955% ( 170, 250 ] 26 0.012% 99.967% ( 250, 380 ] 24 0.011% 99.978% ( 380, 580 ] 27 0.012% 99.990% ( 580, 870 ] 3 0.001% 99.992% ( 870, 1300 ] 7 0.003% 99.995% ( 1300, 1900 ] 7 0.003% 99.998% ( 1900, 2900 ] 1 0.000% 99.999% ( 2900, 4400 ] 2 0.001% 100.000% ( 4400, 6600 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28358 Average: 2.4038 StdDev: 17.92 Min: 0 Median: 1.4689 Max: 2531 Percentiles: P50: 1.47 P75: 1.89 P99: 6.64 P99.9: 15.37 P99.99: 692.54 ------------------------------------------------------ [ 0, 1 ] 6221 21.937% 21.937% #### ( 1, 2 ] 16970 59.842% 81.779% ############ ( 2, 3 ] 3159 11.140% 92.919% ## ( 3, 4 ] 892 3.145% 96.065% # ( 4, 6 ] 790 2.786% 98.850% # ( 6, 10 ] 265 0.934% 99.785% ( 10, 15 ] 32 0.113% 99.898% ( 15, 22 ] 12 0.042% 99.940% ( 51, 76 ] 1 0.004% 99.944% ( 110, 170 ] 3 0.011% 99.954% ( 170, 250 ] 3 0.011% 99.965% ( 250, 380 ] 3 0.011% 99.975% ( 380, 580 ] 3 0.011% 99.986% ( 580, 870 ] 3 0.011% 99.996% ( 1900, 2900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 212361 Average: 4.0814 StdDev: 58.80 Min: 0 Median: 1.7173 Max: 9866 Percentiles: P50: 1.72 P75: 2.40 P99: 9.46 P99.9: 281.74 P99.99: 774.10 ------------------------------------------------------ [ 0, 1 ] 12855 6.053% 6.053% # ( 1, 2 ] 130115 61.271% 67.324% ############ ( 2, 3 ] 40994 19.304% 86.628% #### ( 3, 4 ] 12825 6.039% 92.667% # ( 4, 6 ] 9838 4.633% 97.300% # ( 6, 10 ] 4169 1.963% 99.263% ( 10, 15 ] 569 0.268% 99.531% ( 15, 22 ] 97 0.046% 99.577% ( 22, 34 ] 21 0.010% 99.587% ( 34, 51 ] 1 0.000% 99.587% ( 51, 76 ] 4 0.002% 99.589% ( 76, 110 ] 206 0.097% 99.686% ( 110, 170 ] 270 0.127% 99.813% ( 170, 250 ] 159 0.075% 99.888% ( 250, 380 ] 105 0.049% 99.937% ( 380, 580 ] 87 0.041% 99.978% ( 580, 870 ] 37 0.017% 99.996% ( 870, 1300 ] 17 0.008% 100.004% ( 1300, 1900 ] 6 0.003% 100.007% ( 1900, 2900 ] 3 0.001% 100.008% ( 2900, 4400 ] 7 0.003% 100.011% ( 4400, 6600 ] 8 0.004% 100.015% ( 6600, 9900 ] 4 0.002% 100.017% ** Level 4 read latency histogram (micros): Count: 30 Average: 3059.7667 StdDev: 1860.52 Min: 141 Median: 2775.0000 Max: 7343 Percentiles: P50: 2775.00 P75: 4292.86 P99: 7343.00 P99.9: 7343.00 P99.99: 7343.00 ------------------------------------------------------ ( 110, 170 ] 1 3.333% 3.333% # ( 170, 250 ] 1 3.333% 6.667% # ( 250, 380 ] 1 3.333% 10.000% # ( 580, 870 ] 1 3.333% 13.333% # ( 1300, 1900 ] 4 13.333% 26.667% ### ( 1900, 2900 ] 8 26.667% 53.333% ##### ( 2900, 4400 ] 7 23.333% 76.667% ##### ( 4400, 6600 ] 6 20.000% 96.667% #### ( 6600, 9900 ] 1 3.333% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 881.3000 StdDev: 1098.57 Min: 98 Median: 250.0000 Max: 3900 Percentiles: P50: 250.00 P75: 1600.00 P99: 3900.00 P99.9: 3900.00 P99.99: 3900.00 ------------------------------------------------------ ( 76, 110 ] 7 35.000% 35.000% ####### ( 110, 170 ] 2 10.000% 45.000% ## ( 170, 250 ] 1 5.000% 50.000% # ( 380, 580 ] 4 20.000% 70.000% #### ( 1300, 1900 ] 2 10.000% 80.000% ## ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 15.7 total, 2.9 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 314.15 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.300 H:M:S, 14.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 337.83 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.324 H:M:S, 11.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/07-04:36:02 ... thread 0: (1000000,6000000) ops and (322404.4,323075.4) ops/second in (3.101695,18.571516) 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/17 3.63 GB 0.0 4.3 0.0 4.3 10.0 5.7 0.0 1.8 132.3 305.9 33.34 31.19 98 0.340 4477K 4749 0.0 0.0 L1 14/14 1.45 GB 0.0 2.3 1.9 0.4 2.3 1.9 0.1 1.2 229.3 228.2 10.11 9.76 3 3.368 2352K 10K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.6 1.8 234.8 234.8 0.48 0.45 1 0.476 113K 31 0.0 0.0 L3 24/0 989.41 MB 1.0 1.4 0.6 0.8 1.4 0.6 0.0 2.3 209.2 209.1 6.99 6.19 4 1.747 1463K 739 0.0 0.0 L4 152/0 9.55 GB 1.0 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 L5 1048/0 86.18 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1255/31 101.78 GB 0.0 8.1 2.6 5.5 13.7 8.2 1.4 2.4 163.0 276.5 50.91 47.59 106 0.480 8407K 16K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.1 2.6 5.5 13.7 8.2 1.3 2.4 163.0 276.5 50.91 47.59 106 0.480 8407K 16K 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 8.1 2.6 5.5 8.1 2.6 0.0 0.0 240.4 239.9 34.53 33.03 24 1.439 8407K 16K 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.9 16.38 14.56 82 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 18.8 total, 18.6 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: 13.75 GB write, 750.22 MB/s write, 8.11 GB read, 442.29 MB/s read, 50.9 seconds Interval compaction: 13.75 GB write, 758.02 MB/s write, 8.11 GB read, 446.89 MB/s read, 50.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 5, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 5, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 22, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 5, total-stops: 22, interval: 27 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1646234 Average: 2.2888 StdDev: 13.52 Min: 1 Median: 1.5239 Max: 4518 Percentiles: P50: 1.52 P75: 1.90 P99: 5.70 P99.9: 10.30 P99.99: 20.79 ------------------------------------------------------ [ 0, 1 ] 251281 15.264% 15.264% ### ( 1, 2 ] 1091491 66.302% 81.566% ############# ( 2, 3 ] 201487 12.239% 93.806% ## ( 3, 4 ] 54529 3.312% 97.118% # ( 4, 6 ] 36410 2.212% 99.330% ( 6, 10 ] 9304 0.565% 99.895% ( 10, 15 ] 1426 0.087% 99.981% ( 15, 22 ] 171 0.010% 99.992% ( 22, 34 ] 30 0.002% 99.994% ( 34, 51 ] 10 0.001% 99.994% ( 51, 76 ] 14 0.001% 99.995% ( 76, 110 ] 66 0.004% 99.999% ( 110, 170 ] 178 0.011% 100.010% ( 170, 250 ] 95 0.006% 100.016% ( 250, 380 ] 61 0.004% 100.019% ( 380, 580 ] 44 0.003% 100.022% ( 580, 870 ] 40 0.002% 100.024% ( 870, 1300 ] 26 0.002% 100.026% ( 1300, 1900 ] 16 0.001% 100.027% ( 1900, 2900 ] 7 0.000% 100.027% ( 2900, 4400 ] 12 0.001% 100.028% ( 4400, 6600 ] 1 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 220057 Average: 2.8219 StdDev: 22.59 Min: 0 Median: 1.6775 Max: 6043 Percentiles: P50: 1.68 P75: 2.28 P99: 6.71 P99.9: 109.25 P99.99: 695.67 ------------------------------------------------------ [ 0, 1 ] 20688 9.401% 9.401% ## ( 1, 2 ] 131877 59.929% 69.330% ############ ( 2, 3 ] 44598 20.267% 89.596% #### ( 3, 4 ] 10490 4.767% 94.363% # ( 4, 6 ] 9881 4.490% 98.853% # ( 6, 10 ] 1812 0.823% 99.677% ( 10, 15 ] 348 0.158% 99.835% ( 15, 22 ] 52 0.024% 99.859% ( 22, 34 ] 4 0.002% 99.860% ( 34, 51 ] 2 0.001% 99.861% ( 51, 76 ] 38 0.017% 99.879% ( 76, 110 ] 48 0.022% 99.900% ( 110, 170 ] 101 0.046% 99.946% ( 170, 250 ] 38 0.017% 99.964% ( 250, 380 ] 29 0.013% 99.977% ( 380, 580 ] 27 0.012% 99.989% ( 580, 870 ] 5 0.002% 99.991% ( 870, 1300 ] 7 0.003% 99.995% ( 1300, 1900 ] 7 0.003% 99.998% ( 1900, 2900 ] 1 0.000% 99.998% ( 2900, 4400 ] 3 0.001% 100.000% ( 4400, 6600 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28358 Average: 2.4038 StdDev: 17.92 Min: 0 Median: 1.4689 Max: 2531 Percentiles: P50: 1.47 P75: 1.89 P99: 6.64 P99.9: 15.37 P99.99: 692.54 ------------------------------------------------------ [ 0, 1 ] 6221 21.937% 21.937% #### ( 1, 2 ] 16970 59.842% 81.779% ############ ( 2, 3 ] 3159 11.140% 92.919% ## ( 3, 4 ] 892 3.145% 96.065% # ( 4, 6 ] 790 2.786% 98.850% # ( 6, 10 ] 265 0.934% 99.785% ( 10, 15 ] 32 0.113% 99.898% ( 15, 22 ] 12 0.042% 99.940% ( 51, 76 ] 1 0.004% 99.944% ( 110, 170 ] 3 0.011% 99.954% ( 170, 250 ] 3 0.011% 99.965% ( 250, 380 ] 3 0.011% 99.975% ( 380, 580 ] 3 0.011% 99.986% ( 580, 870 ] 3 0.011% 99.996% ( 1900, 2900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 212361 Average: 4.0814 StdDev: 58.80 Min: 0 Median: 1.7173 Max: 9866 Percentiles: P50: 1.72 P75: 2.40 P99: 9.46 P99.9: 281.74 P99.99: 774.10 ------------------------------------------------------ [ 0, 1 ] 12855 6.053% 6.053% # ( 1, 2 ] 130115 61.271% 67.324% ############ ( 2, 3 ] 40994 19.304% 86.628% #### ( 3, 4 ] 12825 6.039% 92.667% # ( 4, 6 ] 9838 4.633% 97.300% # ( 6, 10 ] 4169 1.963% 99.263% ( 10, 15 ] 569 0.268% 99.531% ( 15, 22 ] 97 0.046% 99.577% ( 22, 34 ] 21 0.010% 99.587% ( 34, 51 ] 1 0.000% 99.587% ( 51, 76 ] 4 0.002% 99.589% ( 76, 110 ] 206 0.097% 99.686% ( 110, 170 ] 270 0.127% 99.813% ( 170, 250 ] 159 0.075% 99.888% ( 250, 380 ] 105 0.049% 99.937% ( 380, 580 ] 87 0.041% 99.978% ( 580, 870 ] 37 0.017% 99.996% ( 870, 1300 ] 17 0.008% 100.004% ( 1300, 1900 ] 6 0.003% 100.007% ( 1900, 2900 ] 3 0.001% 100.008% ( 2900, 4400 ] 7 0.003% 100.011% ( 4400, 6600 ] 8 0.004% 100.015% ( 6600, 9900 ] 4 0.002% 100.017% ** Level 4 read latency histogram (micros): Count: 30 Average: 3059.7667 StdDev: 1860.52 Min: 141 Median: 2775.0000 Max: 7343 Percentiles: P50: 2775.00 P75: 4292.86 P99: 7343.00 P99.9: 7343.00 P99.99: 7343.00 ------------------------------------------------------ ( 110, 170 ] 1 3.333% 3.333% # ( 170, 250 ] 1 3.333% 6.667% # ( 250, 380 ] 1 3.333% 10.000% # ( 580, 870 ] 1 3.333% 13.333% # ( 1300, 1900 ] 4 13.333% 26.667% ### ( 1900, 2900 ] 8 26.667% 53.333% ##### ( 2900, 4400 ] 7 23.333% 76.667% ##### ( 4400, 6600 ] 6 20.000% 96.667% #### ( 6600, 9900 ] 1 3.333% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 881.3000 StdDev: 1098.57 Min: 98 Median: 250.0000 Max: 3900 Percentiles: P50: 250.00 P75: 1600.00 P99: 3900.00 P99.9: 3900.00 P99.99: 3900.00 ------------------------------------------------------ ( 76, 110 ] 7 35.000% 35.000% ####### ( 110, 170 ] 2 10.000% 45.000% ## ( 170, 250 ] 1 5.000% 50.000% # ( 380, 580 ] 4 20.000% 70.000% #### ( 1300, 1900 ] 2 10.000% 80.000% ## ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 18.8 total, 3.1 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 314.67 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.774 H:M:S, 14.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 317.31 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.474 H:M:S, 15.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/07-04:36:31 ... thread 0: (1000000,7000000) ops and (34684.1,147669.4) ops/second in (28.831672,47.403188) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/5 944.48 MB 25.2 4.8 0.0 4.8 11.4 6.6 0.0 1.7 124.7 295.7 39.40 35.66 114 0.346 4989K 5248 0.0 0.0 L1 9/9 669.78 MB 0.0 7.3 5.5 1.8 7.2 5.4 0.1 1.3 207.1 203.4 36.31 32.50 4 9.078 7634K 132K 0.0 0.0 L2 8/8 1.00 GB 0.0 0.1 0.1 0.0 0.1 0.1 4.9 1.8 234.8 234.8 0.48 0.45 1 0.476 113K 31 0.0 0.0 L3 24/9 2.16 GB 1.1 1.7 0.8 0.8 1.7 0.8 3.1 2.0 190.1 189.9 9.08 7.41 7 1.297 1463K 739 0.0 0.0 L4 180/23 11.65 GB 1.2 1.2 1.1 0.2 1.2 1.1 1.4 1.1 99.1 98.5 12.67 6.18 9 1.408 1185K 4992 0.0 0.0 L5 1048/0 86.18 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1277/54 102.58 GB 0.0 15.2 7.5 7.7 21.6 13.9 9.8 3.3 158.5 225.9 97.93 82.21 135 0.725 15M 143K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.2 7.5 7.7 21.6 13.9 9.7 3.3 158.5 225.9 97.93 82.21 135 0.725 15M 143K 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 15.2 7.5 7.7 15.0 7.4 0.0 0.0 200.6 198.7 77.39 65.04 39 1.984 15M 143K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.6 6.6 0.0 0.0 0.0 328.2 20.54 17.16 96 0.214 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): 47.6 total, 47.4 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 21.60 GB write, 464.70 MB/s write, 15.16 GB read, 326.17 MB/s read, 97.9 seconds Interval compaction: 21.60 GB write, 466.59 MB/s write, 15.16 GB read, 327.50 MB/s read, 97.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 36, pending-compaction-bytes-delays: 1, pending-compaction-bytes-stops: 0, total-delays: 16, total-stops: 36, interval: 52 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2788504 Average: 3.3008 StdDev: 24.90 Min: 1 Median: 1.4828 Max: 11576 Percentiles: P50: 1.48 P75: 1.86 P99: 8.90 P99.9: 168.71 P99.99: 497.11 ------------------------------------------------------ [ 0, 1 ] 510729 18.316% 18.316% #### ( 1, 2 ] 1829815 65.620% 83.935% ############# ( 2, 3 ] 266894 9.571% 93.507% ## ( 3, 4 ] 82824 2.970% 96.477% # ( 4, 6 ] 57666 2.068% 98.545% ( 6, 10 ] 17512 0.628% 99.173% ( 10, 15 ] 2508 0.090% 99.263% ( 15, 22 ] 374 0.013% 99.276% ( 22, 34 ] 43 0.002% 99.278% ( 34, 51 ] 12 0.000% 99.278% ( 51, 76 ] 26 0.001% 99.279% ( 76, 110 ] 8119 0.291% 99.570% ( 110, 170 ] 9396 0.337% 99.907% ( 170, 250 ] 1033 0.037% 99.944% ( 250, 380 ] 818 0.029% 99.974% ( 380, 580 ] 779 0.028% 100.002% ( 580, 870 ] 273 0.010% 100.011% ( 870, 1300 ] 83 0.003% 100.014% ( 1300, 1900 ] 28 0.001% 100.015% ( 1900, 2900 ] 29 0.001% 100.016% ( 2900, 4400 ] 28 0.001% 100.017% ( 4400, 6600 ] 6 0.000% 100.018% ( 6600, 9900 ] 2 0.000% 100.018% ( 9900, 14000 ] 1 0.000% 100.018% ** Level 1 read latency histogram (micros): Count: 1092038 Average: 6.3812 StdDev: 107.76 Min: 0 Median: 1.7137 Max: 21469 Percentiles: P50: 1.71 P75: 2.52 P99: 9.46 P99.9: 161.01 P99.99: 472.16 ------------------------------------------------------ [ 0, 1 ] 134127 12.282% 12.282% ## ( 1, 2 ] 577153 52.851% 65.133% ########### ( 2, 3 ] 208315 19.076% 84.209% #### ( 3, 4 ] 73952 6.772% 90.981% # ( 4, 6 ] 72152 6.607% 97.588% # ( 6, 10 ] 17829 1.633% 99.221% ( 10, 15 ] 3714 0.340% 99.561% ( 15, 22 ] 627 0.057% 99.618% ( 22, 34 ] 48 0.004% 99.623% ( 34, 51 ] 16 0.001% 99.624% ( 51, 76 ] 47 0.004% 99.628% ( 76, 110 ] 1555 0.142% 99.771% ( 110, 170 ] 1662 0.152% 99.923% ( 170, 250 ] 271 0.025% 99.948% ( 250, 380 ] 290 0.027% 99.974% ( 380, 580 ] 375 0.034% 100.009% ( 580, 870 ] 327 0.030% 100.039% ( 870, 1300 ] 274 0.025% 100.064% ( 1300, 1900 ] 187 0.017% 100.081% ( 1900, 2900 ] 258 0.024% 100.104% ( 2900, 4400 ] 340 0.031% 100.136% ( 4400, 6600 ] 115 0.011% 100.146% ( 6600, 9900 ] 24 0.002% 100.148% ( 9900, 14000 ] 4 0.000% 100.149% ( 14000, 22000 ] 2 0.000% 100.149% ** Level 2 read latency histogram (micros): Count: 28358 Average: 2.4038 StdDev: 17.92 Min: 0 Median: 1.4689 Max: 2531 Percentiles: P50: 1.47 P75: 1.89 P99: 6.64 P99.9: 15.37 P99.99: 692.54 ------------------------------------------------------ [ 0, 1 ] 6221 21.937% 21.937% #### ( 1, 2 ] 16970 59.842% 81.779% ############ ( 2, 3 ] 3159 11.140% 92.919% ## ( 3, 4 ] 892 3.145% 96.065% # ( 4, 6 ] 790 2.786% 98.850% # ( 6, 10 ] 265 0.934% 99.785% ( 10, 15 ] 32 0.113% 99.898% ( 15, 22 ] 12 0.042% 99.940% ( 51, 76 ] 1 0.004% 99.944% ( 110, 170 ] 3 0.011% 99.954% ( 170, 250 ] 3 0.011% 99.965% ( 250, 380 ] 3 0.011% 99.975% ( 380, 580 ] 3 0.011% 99.986% ( 580, 870 ] 3 0.011% 99.996% ( 1900, 2900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 281650 Average: 9.2782 StdDev: 123.49 Min: 0 Median: 1.7785 Max: 21866 Percentiles: P50: 1.78 P75: 2.58 P99: 14.99 P99.9: 1204.28 P99.99: 3271.91 ------------------------------------------------------ [ 0, 1 ] 13998 4.970% 4.970% # ( 1, 2 ] 162906 57.840% 62.810% ############ ( 2, 3 ] 59287 21.050% 83.860% #### ( 3, 4 ] 20685 7.344% 91.204% # ( 4, 6 ] 15124 5.370% 96.574% # ( 6, 10 ] 5940 2.109% 98.683% ( 10, 15 ] 895 0.318% 99.001% ( 15, 22 ] 170 0.060% 99.061% ( 22, 34 ] 28 0.010% 99.071% ( 34, 51 ] 5 0.002% 99.073% ( 51, 76 ] 5 0.002% 99.074% ( 76, 110 ] 228 0.081% 99.155% ( 110, 170 ] 361 0.128% 99.284% ( 170, 250 ] 361 0.128% 99.412% ( 250, 380 ] 391 0.139% 99.551% ( 380, 580 ] 421 0.149% 99.700% ( 580, 870 ] 376 0.133% 99.833% ( 870, 1300 ] 241 0.086% 99.919% ( 1300, 1900 ] 100 0.036% 99.955% ( 1900, 2900 ] 80 0.028% 99.983% ( 2900, 4400 ] 80 0.028% 100.011% ( 4400, 6600 ] 28 0.010% 100.021% ( 6600, 9900 ] 10 0.004% 100.025% ( 9900, 14000 ] 1 0.000% 100.025% ( 14000, 22000 ] 1 0.000% 100.026% ** Level 4 read latency histogram (micros): Count: 36864 Average: 7.0431 StdDev: 119.03 Min: 1 Median: 2.2806 Max: 7343 Percentiles: P50: 2.28 P75: 3.16 P99: 9.40 P99.9: 245.39 P99.99: 2462.58 ------------------------------------------------------ [ 0, 1 ] 113 0.307% 0.307% ( 1, 2 ] 15002 40.696% 41.002% ######## ( 2, 3 ] 11823 32.072% 73.074% ###### ( 3, 4 ] 4360 11.827% 84.901% ## ( 4, 6 ] 4636 12.576% 97.477% ### ( 6, 10 ] 661 1.793% 99.270% ( 10, 15 ] 168 0.456% 99.726% ( 15, 22 ] 38 0.103% 99.829% ( 22, 34 ] 2 0.005% 99.835% ( 34, 51 ] 2 0.005% 99.840% ( 51, 76 ] 3 0.008% 99.848% ( 76, 110 ] 3 0.008% 99.856% ( 110, 170 ] 2 0.005% 99.862% ( 170, 250 ] 15 0.041% 99.902% ( 250, 380 ] 2 0.005% 99.908% ( 380, 580 ] 6 0.016% 99.924% ( 580, 870 ] 3 0.008% 99.932% ( 870, 1300 ] 7 0.019% 99.951% ( 1300, 1900 ] 7 0.019% 99.970% ( 1900, 2900 ] 13 0.035% 100.005% ( 2900, 4400 ] 10 0.027% 100.033% ( 4400, 6600 ] 8 0.022% 100.054% ( 6600, 9900 ] 1 0.003% 100.057% ** Level 5 read latency histogram (micros): Count: 20 Average: 881.3000 StdDev: 1098.57 Min: 98 Median: 250.0000 Max: 3900 Percentiles: P50: 250.00 P75: 1600.00 P99: 3900.00 P99.9: 3900.00 P99.99: 3900.00 ------------------------------------------------------ ( 76, 110 ] 7 35.000% 35.000% ####### ( 110, 170 ] 2 10.000% 45.000% ## ( 170, 250 ] 1 5.000% 50.000% # ( 380, 580 ] 4 20.000% 70.000% #### ( 1300, 1900 ] 2 10.000% 80.000% ## ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 47.6 total, 28.8 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 144.74 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:28.087 H:M:S, 59.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 34.14 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:25.313 H:M:S, 87.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/12/07-04:36:35 ... thread 0: (1000000,8000000) ops and (250842.6,155673.1) ops/second in (3.986564,51.389752) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/13 1.91 GB 69.2 5.5 0.0 5.5 13.0 7.6 0.0 1.7 122.0 290.4 45.97 41.06 129 0.356 5692K 6153 0.0 0.0 L1 9/9 669.78 MB 0.0 7.3 5.5 1.8 7.2 5.4 0.1 1.3 207.1 203.4 36.31 32.50 4 9.078 7634K 132K 0.0 0.0 L2 8/8 1.00 GB 0.0 0.1 0.1 0.0 0.1 0.1 4.9 1.8 234.8 234.8 0.48 0.45 1 0.476 113K 31 0.0 0.0 L3 15/1 1.03 GB 0.9 1.7 0.8 0.8 1.7 0.8 3.1 2.0 190.1 189.9 9.08 7.41 7 1.297 1463K 739 0.0 0.0 L4 148/0 9.51 GB 1.0 2.9 2.2 0.7 2.8 2.2 1.4 1.3 113.0 112.4 25.92 14.09 18 1.440 2884K 12K 0.0 0.0 L5 1088/0 89.45 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1283/31 103.55 GB 0.0 17.5 8.6 8.8 24.9 16.0 13.0 3.3 151.9 216.4 117.76 95.51 159 0.741 17M 151K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.5 8.6 8.8 24.9 16.0 13.0 3.3 151.9 216.4 117.76 95.51 159 0.741 17M 151K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 17.5 8.6 8.8 17.3 8.5 0.0 0.0 191.2 189.5 93.59 75.70 50 1.872 17M 151K 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 320.6 24.17 19.81 109 0.222 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.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 24.89 GB write, 494.03 MB/s write, 17.47 GB read, 346.83 MB/s read, 117.8 seconds Interval compaction: 24.89 GB write, 495.89 MB/s write, 17.47 GB read, 348.13 MB/s read, 117.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 50, pending-compaction-bytes-delays: 1, pending-compaction-bytes-stops: 0, total-delays: 16, total-stops: 50, interval: 66 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3114644 Average: 3.3533 StdDev: 28.19 Min: 1 Median: 1.5123 Max: 11576 Percentiles: P50: 1.51 P75: 1.90 P99: 8.76 P99.9: 168.14 P99.99: 510.71 ------------------------------------------------------ [ 0, 1 ] 522572 16.778% 16.778% ### ( 1, 2 ] 2019667 64.844% 81.622% ############# ( 2, 3 ] 341107 10.952% 92.574% ## ( 3, 4 ] 106174 3.409% 95.983% # ( 4, 6 ] 78645 2.525% 98.508% # ( 6, 10 ] 22202 0.713% 99.221% ( 10, 15 ] 3359 0.108% 99.328% ( 15, 22 ] 467 0.015% 99.343% ( 22, 34 ] 47 0.002% 99.345% ( 34, 51 ] 14 0.000% 99.345% ( 51, 76 ] 28 0.001% 99.346% ( 76, 110 ] 8119 0.261% 99.607% ( 110, 170 ] 9420 0.302% 99.909% ( 170, 250 ] 1082 0.035% 99.944% ( 250, 380 ] 874 0.028% 99.972% ( 380, 580 ] 850 0.027% 99.999% ( 580, 870 ] 342 0.011% 100.010% ( 870, 1300 ] 129 0.004% 100.015% ( 1300, 1900 ] 62 0.002% 100.017% ( 1900, 2900 ] 48 0.002% 100.018% ( 2900, 4400 ] 54 0.002% 100.020% ( 4400, 6600 ] 10 0.000% 100.020% ( 6600, 9900 ] 2 0.000% 100.020% ( 9900, 14000 ] 1 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 1562986 Average: 6.1530 StdDev: 98.03 Min: 0 Median: 1.7892 Max: 21469 Percentiles: P50: 1.79 P75: 2.64 P99: 9.48 P99.9: 164.79 P99.99: 483.20 ------------------------------------------------------ [ 0, 1 ] 139160 8.903% 8.903% ## ( 1, 2 ] 813925 52.075% 60.978% ########## ( 2, 3 ] 343593 21.983% 82.962% #### ( 3, 4 ] 112797 7.217% 90.178% # ( 4, 6 ] 112050 7.169% 97.347% # ( 6, 10 ] 29706 1.901% 99.248% ( 10, 15 ] 5783 0.370% 99.618% ( 15, 22 ] 920 0.059% 99.677% ( 22, 34 ] 64 0.004% 99.681% ( 34, 51 ] 19 0.001% 99.682% ( 51, 76 ] 54 0.003% 99.686% ( 76, 110 ] 1661 0.106% 99.792% ( 110, 170 ] 1854 0.119% 99.910% ( 170, 250 ] 427 0.027% 99.938% ( 250, 380 ] 506 0.032% 99.970% ( 380, 580 ] 606 0.039% 100.009% ( 580, 870 ] 569 0.036% 100.045% ( 870, 1300 ] 466 0.030% 100.075% ( 1300, 1900 ] 278 0.018% 100.093% ( 1900, 2900 ] 350 0.022% 100.115% ( 2900, 4400 ] 414 0.026% 100.142% ( 4400, 6600 ] 124 0.008% 100.150% ( 6600, 9900 ] 24 0.002% 100.151% ( 9900, 14000 ] 4 0.000% 100.152% ( 14000, 22000 ] 2 0.000% 100.152% ** Level 2 read latency histogram (micros): Count: 28358 Average: 2.4038 StdDev: 17.92 Min: 0 Median: 1.4689 Max: 2531 Percentiles: P50: 1.47 P75: 1.89 P99: 6.64 P99.9: 15.37 P99.99: 692.54 ------------------------------------------------------ [ 0, 1 ] 6221 21.937% 21.937% #### ( 1, 2 ] 16970 59.842% 81.779% ############ ( 2, 3 ] 3159 11.140% 92.919% ## ( 3, 4 ] 892 3.145% 96.065% # ( 4, 6 ] 790 2.786% 98.850% # ( 6, 10 ] 265 0.934% 99.785% ( 10, 15 ] 32 0.113% 99.898% ( 15, 22 ] 12 0.042% 99.940% ( 51, 76 ] 1 0.004% 99.944% ( 110, 170 ] 3 0.011% 99.954% ( 170, 250 ] 3 0.011% 99.965% ( 250, 380 ] 3 0.011% 99.975% ( 380, 580 ] 3 0.011% 99.986% ( 580, 870 ] 3 0.011% 99.996% ( 1900, 2900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 332496 Average: 10.8646 StdDev: 134.77 Min: 0 Median: 1.7993 Max: 21866 Percentiles: P50: 1.80 P75: 2.62 P99: 40.94 P99.9: 1596.55 P99.99: 3647.33 ------------------------------------------------------ [ 0, 1 ] 15076 4.534% 4.534% # ( 1, 2 ] 189139 56.885% 61.419% ########### ( 2, 3 ] 72437 21.786% 83.205% #### ( 3, 4 ] 25395 7.638% 90.842% ## ( 4, 6 ] 18683 5.619% 96.461% # ( 6, 10 ] 7132 2.145% 98.606% ( 10, 15 ] 1078 0.324% 98.931% ( 15, 22 ] 199 0.060% 98.990% ( 22, 34 ] 30 0.009% 98.999% ( 34, 51 ] 5 0.002% 99.001% ( 51, 76 ] 6 0.002% 99.003% ( 76, 110 ] 228 0.069% 99.071% ( 110, 170 ] 372 0.112% 99.183% ( 170, 250 ] 380 0.114% 99.297% ( 250, 380 ] 456 0.137% 99.435% ( 380, 580 ] 535 0.161% 99.595% ( 580, 870 ] 552 0.166% 99.762% ( 870, 1300 ] 375 0.113% 99.874% ( 1300, 1900 ] 173 0.052% 99.926% ( 1900, 2900 ] 142 0.043% 99.969% ( 2900, 4400 ] 140 0.042% 100.011% ( 4400, 6600 ] 35 0.011% 100.022% ( 6600, 9900 ] 10 0.003% 100.025% ( 9900, 14000 ] 1 0.000% 100.025% ( 14000, 22000 ] 1 0.000% 100.025% ** Level 4 read latency histogram (micros): Count: 90909 Average: 6.2607 StdDev: 96.89 Min: 1 Median: 2.1433 Max: 7343 Percentiles: P50: 2.14 P75: 2.96 P99: 9.27 P99.9: 552.73 P99.99: 2511.89 ------------------------------------------------------ [ 0, 1 ] 476 0.524% 0.524% ( 1, 2 ] 40982 45.080% 45.604% ######### ( 2, 3 ] 27884 30.672% 76.276% ###### ( 3, 4 ] 9533 10.486% 86.763% ## ( 4, 6 ] 9878 10.866% 97.628% ## ( 6, 10 ] 1524 1.676% 99.305% ( 10, 15 ] 365 0.402% 99.706% ( 15, 22 ] 60 0.066% 99.772% ( 22, 34 ] 5 0.006% 99.778% ( 34, 51 ] 3 0.003% 99.781% ( 51, 76 ] 3 0.003% 99.784% ( 76, 110 ] 3 0.003% 99.788% ( 110, 170 ] 11 0.012% 99.800% ( 170, 250 ] 41 0.045% 99.845% ( 250, 380 ] 19 0.021% 99.866% ( 380, 580 ] 36 0.040% 99.905% ( 580, 870 ] 28 0.031% 99.936% ( 870, 1300 ] 20 0.022% 99.958% ( 1300, 1900 ] 13 0.014% 99.972% ( 1900, 2900 ] 26 0.029% 100.001% ( 2900, 4400 ] 22 0.024% 100.025% ( 4400, 6600 ] 10 0.011% 100.036% ( 6600, 9900 ] 1 0.001% 100.037% ** Level 5 read latency histogram (micros): Count: 220 Average: 1491.2227 StdDev: 1513.34 Min: 82 Median: 790.0000 Max: 6883 Percentiles: P50: 790.00 P75: 2366.67 P99: 6380.00 P99.9: 6883.00 P99.99: 6883.00 ------------------------------------------------------ ( 76, 110 ] 15 6.818% 6.818% # ( 110, 170 ] 11 5.000% 11.818% # ( 170, 250 ] 14 6.364% 18.182% # ( 250, 380 ] 21 9.545% 27.727% ## ( 380, 580 ] 28 12.727% 40.455% ### ( 580, 870 ] 29 13.182% 53.636% ### ( 870, 1300 ] 15 6.818% 60.455% # ( 1300, 1900 ] 25 11.364% 71.818% ## ( 1900, 2900 ] 15 6.818% 78.636% # ( 2900, 4400 ] 34 15.455% 94.091% ### ( 4400, 6600 ] 12 5.455% 99.545% # ( 6600, 9900 ] 1 0.455% 100.000% ** DB Stats ** Uptime(secs): 51.6 total, 4.0 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 152.63 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.309 H:M:S, 56.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 246.88 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.223 H:M:S, 30.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/12/07-04:36:38 ... thread 0: (1000000,9000000) ops and (304171.5,164601.9) ops/second in (3.287619,54.677371) 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/13 2.21 GB 12.6 6.3 0.0 6.3 14.8 8.5 0.0 1.7 123.3 291.3 52.10 46.80 145 0.359 6524K 7058 0.0 0.0 L1 17/17 1.32 GB 0.0 8.7 6.2 2.5 8.5 6.1 0.1 1.4 200.5 197.4 44.29 38.62 5 8.859 8337K 132K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 4.9 1.8 234.8 234.8 0.48 0.45 1 0.476 113K 31 0.0 0.0 L3 13/0 907.24 MB 0.9 2.8 1.8 1.0 2.8 1.8 3.1 1.5 181.1 180.6 15.91 12.64 8 1.988 1594K 739 0.0 0.0 L4 157/0 9.67 GB 1.0 3.0 2.4 0.7 3.0 2.4 2.4 1.3 116.2 115.7 26.72 14.84 19 1.406 3064K 12K 0.0 0.0 L5 1100/0 90.43 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1301/30 104.52 GB 0.0 20.9 10.5 10.4 29.3 18.9 15.0 3.4 153.4 215.0 139.50 113.35 178 0.784 19M 152K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.9 10.5 10.4 29.3 18.9 15.0 3.4 153.4 215.0 139.50 113.35 178 0.784 19M 152K 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 20.9 10.5 10.4 20.7 10.3 0.0 0.0 190.4 188.9 112.44 90.97 56 2.008 19M 152K 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 323.6 27.06 22.37 122 0.222 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): 54.9 total, 54.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: 29.29 GB write, 546.59 MB/s write, 20.90 GB read, 390.09 MB/s read, 139.5 seconds Interval compaction: 29.29 GB write, 548.52 MB/s write, 20.90 GB read, 391.47 MB/s read, 139.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 55, pending-compaction-bytes-delays: 1, pending-compaction-bytes-stops: 0, total-delays: 16, total-stops: 55, interval: 71 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3354519 Average: 3.2876 StdDev: 27.45 Min: 1 Median: 1.5148 Max: 11576 Percentiles: P50: 1.51 P75: 1.90 P99: 8.47 P99.9: 166.86 P99.99: 500.03 ------------------------------------------------------ [ 0, 1 ] 555546 16.561% 16.561% ### ( 1, 2 ] 2178985 64.957% 81.518% ############# ( 2, 3 ] 372374 11.101% 92.618% ## ( 3, 4 ] 115093 3.431% 96.049% # ( 4, 6 ] 84610 2.522% 98.572% # ( 6, 10 ] 23291 0.694% 99.266% ( 10, 15 ] 3567 0.106% 99.372% ( 15, 22 ] 489 0.015% 99.387% ( 22, 34 ] 53 0.002% 99.389% ( 34, 51 ] 18 0.001% 99.389% ( 51, 76 ] 28 0.001% 99.390% ( 76, 110 ] 8120 0.242% 99.632% ( 110, 170 ] 9487 0.283% 99.915% ( 170, 250 ] 1112 0.033% 99.948% ( 250, 380 ] 889 0.027% 99.974% ( 380, 580 ] 869 0.026% 100.000% ( 580, 870 ] 358 0.011% 100.011% ( 870, 1300 ] 137 0.004% 100.015% ( 1300, 1900 ] 63 0.002% 100.017% ( 1900, 2900 ] 51 0.002% 100.019% ( 2900, 4400 ] 55 0.002% 100.020% ( 4400, 6600 ] 10 0.000% 100.020% ( 6600, 9900 ] 2 0.000% 100.021% ( 9900, 14000 ] 1 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 1670758 Average: 5.9914 StdDev: 95.11 Min: 0 Median: 1.7832 Max: 21469 Percentiles: P50: 1.78 P75: 2.62 P99: 9.46 P99.9: 166.96 P99.99: 494.17 ------------------------------------------------------ [ 0, 1 ] 145076 8.683% 8.683% ## ( 1, 2 ] 881384 52.754% 61.437% ########### ( 2, 3 ] 365719 21.889% 83.326% #### ( 3, 4 ] 118183 7.074% 90.400% # ( 4, 6 ] 116257 6.958% 97.358% # ( 6, 10 ] 31713 1.898% 99.256% ( 10, 15 ] 5999 0.359% 99.615% ( 15, 22 ] 939 0.056% 99.672% ( 22, 34 ] 65 0.004% 99.675% ( 34, 51 ] 19 0.001% 99.677% ( 51, 76 ] 54 0.003% 99.680% ( 76, 110 ] 1737 0.104% 99.784% ( 110, 170 ] 2046 0.122% 99.906% ( 170, 250 ] 490 0.029% 99.936% ( 250, 380 ] 544 0.033% 99.968% ( 380, 580 ] 641 0.038% 100.006% ( 580, 870 ] 591 0.035% 100.042% ( 870, 1300 ] 474 0.028% 100.070% ( 1300, 1900 ] 285 0.017% 100.087% ( 1900, 2900 ] 353 0.021% 100.108% ( 2900, 4400 ] 416 0.025% 100.133% ( 4400, 6600 ] 124 0.007% 100.141% ( 6600, 9900 ] 24 0.001% 100.142% ( 9900, 14000 ] 4 0.000% 100.142% ( 14000, 22000 ] 2 0.000% 100.143% ** Level 2 read latency histogram (micros): Count: 28358 Average: 2.4038 StdDev: 17.92 Min: 0 Median: 1.4689 Max: 2531 Percentiles: P50: 1.47 P75: 1.89 P99: 6.64 P99.9: 15.37 P99.99: 692.54 ------------------------------------------------------ [ 0, 1 ] 6221 21.937% 21.937% #### ( 1, 2 ] 16970 59.842% 81.779% ############ ( 2, 3 ] 3159 11.140% 92.919% ## ( 3, 4 ] 892 3.145% 96.065% # ( 4, 6 ] 790 2.786% 98.850% # ( 6, 10 ] 265 0.934% 99.785% ( 10, 15 ] 32 0.113% 99.898% ( 15, 22 ] 12 0.042% 99.940% ( 51, 76 ] 1 0.004% 99.944% ( 110, 170 ] 3 0.011% 99.954% ( 170, 250 ] 3 0.011% 99.965% ( 250, 380 ] 3 0.011% 99.975% ( 380, 580 ] 3 0.011% 99.986% ( 580, 870 ] 3 0.011% 99.996% ( 1900, 2900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 379825 Average: 9.9378 StdDev: 126.52 Min: 0 Median: 1.7880 Max: 21866 Percentiles: P50: 1.79 P75: 2.58 P99: 14.49 P99.9: 1453.92 P99.99: 3596.62 ------------------------------------------------------ [ 0, 1 ] 16505 4.345% 4.345% # ( 1, 2 ] 220055 57.936% 62.281% ############ ( 2, 3 ] 83161 21.895% 84.176% #### ( 3, 4 ] 27545 7.252% 91.428% # ( 4, 6 ] 20310 5.347% 96.775% # ( 6, 10 ] 7446 1.960% 98.735% ( 10, 15 ] 1119 0.295% 99.030% ( 15, 22 ] 205 0.054% 99.084% ( 22, 34 ] 30 0.008% 99.092% ( 34, 51 ] 5 0.001% 99.093% ( 51, 76 ] 7 0.002% 99.095% ( 76, 110 ] 256 0.067% 99.163% ( 110, 170 ] 396 0.104% 99.267% ( 170, 250 ] 395 0.104% 99.371% ( 250, 380 ] 473 0.125% 99.495% ( 380, 580 ] 552 0.145% 99.641% ( 580, 870 ] 556 0.146% 99.787% ( 870, 1300 ] 383 0.101% 99.888% ( 1300, 1900 ] 180 0.047% 99.935% ( 1900, 2900 ] 143 0.038% 99.973% ( 2900, 4400 ] 140 0.037% 100.010% ( 4400, 6600 ] 35 0.009% 100.019% ( 6600, 9900 ] 10 0.003% 100.022% ( 9900, 14000 ] 1 0.000% 100.022% ( 14000, 22000 ] 1 0.000% 100.022% ** Level 4 read latency histogram (micros): Count: 90934 Average: 6.2815 StdDev: 96.95 Min: 1 Median: 2.1432 Max: 7343 Percentiles: P50: 2.14 P75: 2.96 P99: 9.29 P99.9: 558.74 P99.99: 2511.79 ------------------------------------------------------ [ 0, 1 ] 486 0.534% 0.534% ( 1, 2 ] 40988 45.074% 45.609% ######### ( 2, 3 ] 27884 30.664% 76.273% ###### ( 3, 4 ] 9533 10.483% 86.756% ## ( 4, 6 ] 9878 10.863% 97.619% ## ( 6, 10 ] 1526 1.678% 99.297% ( 10, 15 ] 365 0.401% 99.699% ( 15, 22 ] 61 0.067% 99.766% ( 22, 34 ] 6 0.007% 99.772% ( 34, 51 ] 3 0.003% 99.776% ( 51, 76 ] 3 0.003% 99.779% ( 76, 110 ] 3 0.003% 99.782% ( 110, 170 ] 12 0.013% 99.795% ( 170, 250 ] 43 0.047% 99.843% ( 250, 380 ] 19 0.021% 99.864% ( 380, 580 ] 37 0.041% 99.904% ( 580, 870 ] 28 0.031% 99.935% ( 870, 1300 ] 21 0.023% 99.958% ( 1300, 1900 ] 13 0.014% 99.973% ( 1900, 2900 ] 26 0.029% 100.001% ( 2900, 4400 ] 22 0.024% 100.025% ( 4400, 6600 ] 10 0.011% 100.036% ( 6600, 9900 ] 1 0.001% 100.037% ** Level 5 read latency histogram (micros): Count: 280 Average: 1379.2607 StdDev: 1460.66 Min: 82 Median: 696.0000 Max: 6883 Percentiles: P50: 696.00 P75: 2138.10 P99: 6270.00 P99.9: 6883.00 P99.99: 6883.00 ------------------------------------------------------ ( 76, 110 ] 17 6.071% 6.071% # ( 110, 170 ] 21 7.500% 13.571% ## ( 170, 250 ] 27 9.643% 23.214% ## ( 250, 380 ] 28 10.000% 33.214% ## ( 380, 580 ] 33 11.786% 45.000% ## ( 580, 870 ] 35 12.500% 57.500% ### ( 870, 1300 ] 16 5.714% 63.214% # ( 1300, 1900 ] 28 10.000% 73.214% ## ( 1900, 2900 ] 21 7.500% 80.714% ## ( 2900, 4400 ] 41 14.643% 95.357% ### ( 4400, 6600 ] 12 4.286% 99.643% # ( 6600, 9900 ] 1 0.357% 100.000% ** DB Stats ** Uptime(secs): 54.9 total, 3.3 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 161.43 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.974 H:M:S, 54.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 299.36 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.665 H:M:S, 20.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/07-04:36:42 ... thread 0: (1000000,10000000) ops and (302598.0,172467.1) ops/second in (3.304714,57.982085) 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 19/13 3.20 GB 107.0 7.1 0.0 7.1 16.6 9.5 0.0 1.7 124.6 292.3 58.16 52.47 162 0.359 7355K 7947 0.0 0.0 L1 17/17 1.32 GB 0.0 8.7 6.2 2.5 8.5 6.1 0.1 1.4 200.5 197.4 44.29 38.62 5 8.859 8337K 132K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 4.9 1.8 234.8 234.8 0.48 0.45 1 0.476 113K 31 0.0 0.0 L3 13/0 907.24 MB 0.9 2.8 1.8 1.0 2.8 1.8 3.1 1.5 181.1 180.6 15.91 12.64 8 1.988 1594K 739 0.0 0.0 L4 157/0 9.67 GB 1.0 3.0 2.4 0.7 3.0 2.4 2.4 1.3 116.2 115.7 26.72 14.84 19 1.406 3064K 12K 0.0 0.0 L5 1100/0 90.43 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1306/30 105.51 GB 0.0 21.7 10.5 11.2 31.1 19.9 15.0 3.3 152.7 218.6 145.56 119.02 195 0.746 20M 153K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.7 10.5 11.2 31.1 19.9 15.0 3.3 152.7 218.6 145.56 119.02 195 0.746 20M 153K 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 21.7 10.5 11.2 21.5 10.3 0.0 0.0 192.4 190.9 115.53 94.01 59 1.958 20M 153K 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 325.2 30.03 25.01 136 0.221 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.2 total, 58.0 interval Flush(GB): cumulative 9.536, interval 9.536 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 31.07 GB write, 546.92 MB/s write, 21.70 GB read, 382.01 MB/s read, 145.6 seconds Interval compaction: 31.07 GB write, 548.74 MB/s write, 21.70 GB read, 383.28 MB/s read, 145.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 17, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 17, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 58, pending-compaction-bytes-delays: 1, pending-compaction-bytes-stops: 0, total-delays: 18, total-stops: 58, interval: 76 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3701388 Average: 3.1978 StdDev: 26.42 Min: 1 Median: 1.5190 Max: 11576 Percentiles: P50: 1.52 P75: 1.90 P99: 8.09 P99.9: 164.59 P99.99: 477.93 ------------------------------------------------------ [ 0, 1 ] 596524 16.116% 16.116% ### ( 1, 2 ] 2416493 65.286% 81.402% ############# ( 2, 3 ] 422021 11.402% 92.804% ## ( 3, 4 ] 125046 3.378% 96.182% # ( 4, 6 ] 91181 2.463% 98.646% ( 6, 10 ] 25093 0.678% 99.324% ( 10, 15 ] 3875 0.105% 99.428% ( 15, 22 ] 524 0.014% 99.443% ( 22, 34 ] 57 0.002% 99.444% ( 34, 51 ] 18 0.000% 99.445% ( 51, 76 ] 29 0.001% 99.445% ( 76, 110 ] 8158 0.220% 99.666% ( 110, 170 ] 9528 0.257% 99.923% ( 170, 250 ] 1135 0.031% 99.954% ( 250, 380 ] 905 0.024% 99.978% ( 380, 580 ] 882 0.024% 100.002% ( 580, 870 ] 365 0.010% 100.012% ( 870, 1300 ] 145 0.004% 100.016% ( 1300, 1900 ] 64 0.002% 100.018% ( 1900, 2900 ] 53 0.001% 100.019% ( 2900, 4400 ] 57 0.002% 100.021% ( 4400, 6600 ] 10 0.000% 100.021% ( 6600, 9900 ] 2 0.000% 100.021% ( 9900, 14000 ] 1 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 1720195 Average: 5.9066 StdDev: 93.77 Min: 0 Median: 1.7766 Max: 21469 Percentiles: P50: 1.78 P75: 2.60 P99: 9.45 P99.9: 167.51 P99.99: 496.71 ------------------------------------------------------ [ 0, 1 ] 150094 8.725% 8.725% ## ( 1, 2 ] 914300 53.151% 61.876% ########### ( 2, 3 ] 373696 21.724% 83.600% #### ( 3, 4 ] 119519 6.948% 90.548% # ( 4, 6 ] 117347 6.822% 97.370% # ( 6, 10 ] 32550 1.892% 99.262% ( 10, 15 ] 6060 0.352% 99.615% ( 15, 22 ] 946 0.055% 99.670% ( 22, 34 ] 67 0.004% 99.674% ( 34, 51 ] 19 0.001% 99.675% ( 51, 76 ] 55 0.003% 99.678% ( 76, 110 ] 1808 0.105% 99.783% ( 110, 170 ] 2101 0.122% 99.905% ( 170, 250 ] 517 0.030% 99.935% ( 250, 380 ] 560 0.033% 99.968% ( 380, 580 ] 658 0.038% 100.006% ( 580, 870 ] 596 0.035% 100.041% ( 870, 1300 ] 475 0.028% 100.068% ( 1300, 1900 ] 285 0.017% 100.085% ( 1900, 2900 ] 353 0.021% 100.105% ( 2900, 4400 ] 416 0.024% 100.129% ( 4400, 6600 ] 124 0.007% 100.137% ( 6600, 9900 ] 24 0.001% 100.138% ( 9900, 14000 ] 4 0.000% 100.138% ( 14000, 22000 ] 2 0.000% 100.138% ** Level 2 read latency histogram (micros): Count: 28358 Average: 2.4038 StdDev: 17.92 Min: 0 Median: 1.4689 Max: 2531 Percentiles: P50: 1.47 P75: 1.89 P99: 6.64 P99.9: 15.37 P99.99: 692.54 ------------------------------------------------------ [ 0, 1 ] 6221 21.937% 21.937% #### ( 1, 2 ] 16970 59.842% 81.779% ############ ( 2, 3 ] 3159 11.140% 92.919% ## ( 3, 4 ] 892 3.145% 96.065% # ( 4, 6 ] 790 2.786% 98.850% # ( 6, 10 ] 265 0.934% 99.785% ( 10, 15 ] 32 0.113% 99.898% ( 15, 22 ] 12 0.042% 99.940% ( 51, 76 ] 1 0.004% 99.944% ( 110, 170 ] 3 0.011% 99.954% ( 170, 250 ] 3 0.011% 99.965% ( 250, 380 ] 3 0.011% 99.975% ( 380, 580 ] 3 0.011% 99.986% ( 580, 870 ] 3 0.011% 99.996% ( 1900, 2900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 379825 Average: 9.9378 StdDev: 126.52 Min: 0 Median: 1.7880 Max: 21866 Percentiles: P50: 1.79 P75: 2.58 P99: 14.49 P99.9: 1453.92 P99.99: 3596.62 ------------------------------------------------------ [ 0, 1 ] 16505 4.345% 4.345% # ( 1, 2 ] 220055 57.936% 62.281% ############ ( 2, 3 ] 83161 21.895% 84.176% #### ( 3, 4 ] 27545 7.252% 91.428% # ( 4, 6 ] 20310 5.347% 96.775% # ( 6, 10 ] 7446 1.960% 98.735% ( 10, 15 ] 1119 0.295% 99.030% ( 15, 22 ] 205 0.054% 99.084% ( 22, 34 ] 30 0.008% 99.092% ( 34, 51 ] 5 0.001% 99.093% ( 51, 76 ] 7 0.002% 99.095% ( 76, 110 ] 256 0.067% 99.163% ( 110, 170 ] 396 0.104% 99.267% ( 170, 250 ] 395 0.104% 99.371% ( 250, 380 ] 473 0.125% 99.495% ( 380, 580 ] 552 0.145% 99.641% ( 580, 870 ] 556 0.146% 99.787% ( 870, 1300 ] 383 0.101% 99.888% ( 1300, 1900 ] 180 0.047% 99.935% ( 1900, 2900 ] 143 0.038% 99.973% ( 2900, 4400 ] 140 0.037% 100.010% ( 4400, 6600 ] 35 0.009% 100.019% ( 6600, 9900 ] 10 0.003% 100.022% ( 9900, 14000 ] 1 0.000% 100.022% ( 14000, 22000 ] 1 0.000% 100.022% ** Level 4 read latency histogram (micros): Count: 90934 Average: 6.2815 StdDev: 96.95 Min: 1 Median: 2.1432 Max: 7343 Percentiles: P50: 2.14 P75: 2.96 P99: 9.29 P99.9: 558.74 P99.99: 2511.79 ------------------------------------------------------ [ 0, 1 ] 486 0.534% 0.534% ( 1, 2 ] 40988 45.074% 45.609% ######### ( 2, 3 ] 27884 30.664% 76.273% ###### ( 3, 4 ] 9533 10.483% 86.756% ## ( 4, 6 ] 9878 10.863% 97.619% ## ( 6, 10 ] 1526 1.678% 99.297% ( 10, 15 ] 365 0.401% 99.699% ( 15, 22 ] 61 0.067% 99.766% ( 22, 34 ] 6 0.007% 99.772% ( 34, 51 ] 3 0.003% 99.776% ( 51, 76 ] 3 0.003% 99.779% ( 76, 110 ] 3 0.003% 99.782% ( 110, 170 ] 12 0.013% 99.795% ( 170, 250 ] 43 0.047% 99.843% ( 250, 380 ] 19 0.021% 99.864% ( 380, 580 ] 37 0.041% 99.904% ( 580, 870 ] 28 0.031% 99.935% ( 870, 1300 ] 21 0.023% 99.958% ( 1300, 1900 ] 13 0.014% 99.973% ( 1900, 2900 ] 26 0.029% 100.001% ( 2900, 4400 ] 22 0.024% 100.025% ( 4400, 6600 ] 10 0.011% 100.036% ( 6600, 9900 ] 1 0.001% 100.037% ** Level 5 read latency histogram (micros): Count: 280 Average: 1379.2607 StdDev: 1460.66 Min: 82 Median: 696.0000 Max: 6883 Percentiles: P50: 696.00 P75: 2138.10 P99: 6270.00 P99.9: 6883.00 P99.99: 6883.00 ------------------------------------------------------ ( 76, 110 ] 17 6.071% 6.071% # ( 110, 170 ] 21 7.500% 13.571% ## ( 170, 250 ] 27 9.643% 23.214% ## ( 250, 380 ] 28 10.000% 33.214% ## ( 380, 580 ] 33 11.786% 45.000% ## ( 580, 870 ] 35 12.500% 57.500% ### ( 870, 1300 ] 16 5.714% 63.214% # ( 1300, 1900 ] 28 10.000% 73.214% ## ( 1900, 2900 ] 21 7.500% 80.714% ## ( 2900, 4400 ] 41 14.643% 95.357% ### ( 4400, 6600 ] 12 4.286% 99.643% # ( 6600, 9900 ] 1 0.357% 100.000% ** DB Stats ** Uptime(secs): 58.2 total, 3.3 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 169.17 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:30.643 H:M:S, 52.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 297.82 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.669 H:M:S, 20.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.743 micros/op 174113 ops/sec 60.070 seconds 10458999 operations; 168.7 MB/s Microseconds per write: Count: 10458999 Average: 5.7434 StdDev: 474.46 Min: 0 Median: 1.7311 Max: 970513 Percentiles: P50: 1.73 P75: 2.73 P99: 9.13 P99.9: 1175.26 P99.99: 2775.26 ------------------------------------------------------ [ 0, 1 ] 1428513 13.658% 13.658% ### ( 1, 2 ] 5199347 49.712% 63.370% ########## ( 2, 3 ] 1656798 15.841% 79.211% ### ( 3, 4 ] 1426597 13.640% 92.851% ### ( 4, 6 ] 548691 5.246% 98.097% # ( 6, 10 ] 120535 1.152% 99.249% ( 10, 15 ] 40084 0.383% 99.633% ( 15, 22 ] 9674 0.092% 99.725% ( 22, 34 ] 1632 0.016% 99.741% ( 34, 51 ] 210 0.002% 99.743% ( 51, 76 ] 29 0.000% 99.743% ( 76, 110 ] 7261 0.069% 99.812% ( 110, 170 ] 2829 0.027% 99.839% ( 170, 250 ] 326 0.003% 99.842% ( 250, 380 ] 173 0.002% 99.844% ( 380, 580 ] 15 0.000% 99.844% ( 580, 870 ] 14 0.000% 99.844% ( 870, 1300 ] 8187 0.078% 99.923% ( 1300, 1900 ] 22 0.000% 99.923% ( 1900, 2900 ] 8016 0.077% 100.000% ( 2900, 4400 ] 13 0.000% 100.000% ( 4400, 6600 ] 1 0.000% 100.000% ( 6600, 9900 ] 2 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 14000, 22000 ] 3 0.000% 100.000% ( 22000, 33000 ] 3 0.000% 100.000% ( 33000, 50000 ] 2 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 16 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% ( 860000, 1200000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 187089 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 : 10458999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10793686968 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 : 503 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31483531 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 : 25487703984 rocksdb.compact.write.bytes COUNT : 25297814464 rocksdb.flush.write.bytes COUNT : 10767326619 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 : 66 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 : 274 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 : 10680587264 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4220928 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 : 25590358126 rocksdb.non.last.level.read.count COUNT : 6176213 rocksdb.block.checksum.compute.count COUNT : 6175273 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.379755 P95 : 3.899312 P99 : 7.591047 P100 : 970506.000000 COUNT : 10458999 SUM : 55230734 rocksdb.compaction.times.micros P50 : 1242000.000000 P95 : 7545000.000000 P99 : 26204658.000000 P100 : 26204658.000000 COUNT : 61 SUM : 117686581 rocksdb.compaction.times.cpu_micros P50 : 971379.310345 P95 : 4996666.666667 P99 : 22732302.000000 P100 : 22732302.000000 COUNT : 61 SUM : 96126221 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 : 700.519481 P95 : 1240.173913 P99 : 46260.000000 P100 : 181102.000000 COUNT : 144 SUM : 374355 rocksdb.compaction.outfile.sync.micros P50 : 901.159420 P95 : 118142.857143 P99 : 169914.285714 P100 : 252259.000000 COUNT : 302 SUM : 5525945 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 : 103.597403 P95 : 1206.833333 P99 : 3402.500000 P100 : 6579.000000 COUNT : 233 SUM : 66409 rocksdb.table.open.io.micros P50 : 1560.294118 P95 : 9880.200000 P99 : 18341.818182 P100 : 19614.000000 COUNT : 503 SUM : 1334166 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.662955 P95 : 7.645998 P99 : 12.717683 P100 : 21870.000000 COUNT : 6173995 SUM : 39861428 rocksdb.read.block.get.micros P50 : 542.204724 P95 : 4097.887324 P99 : 6240.903226 P100 : 10002.000000 COUNT : 1006 SUM : 1069312 rocksdb.write.raw.block.micros P50 : 0.514273 P95 : 0.977119 P99 : 2.903534 P100 : 16171.000000 COUNT : 8735638 SUM : 18005455 rocksdb.numfiles.in.singlecompaction P50 : 3.406977 P95 : 8.100000 P99 : 26.920000 P100 : 31.000000 COUNT : 118 SUM : 522 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.573566 P95 : 2110.434620 P99 : 2745.384039 P100 : 970305.000000 COUNT : 127101 SUM : 31498580 rocksdb.sst.read.micros P50 : 1.606074 P95 : 4.446424 P99 : 9.170248 P100 : 21866.000000 COUNT : 6176668 SUM : 27518271 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 : 10458999 SUM : 10793686968 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 : 212307.692308 P95 : 364111.111111 P99 : 796200.000000 P100 : 1090473.000000 COUNT : 144 SUM : 31483067 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 : 299 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