[2024-07-25 17:18:40.811803] Starting SPDK v24.01.1-pre git sha1 dbef7efac / DPDK 22.11.4 initialization... [2024-07-25 17:18:40.812058] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid1213190 ] Set seed to 1721920720805439 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-25 17:18:40.905375] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-25 17:18:40.944382] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-25 17:18:40.944429] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1213190' to capture a snapshot of events at runtime. [2024-07-25 17:18:40.944441] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1213190 for offline analysis/debug. [2024-07-25 17:18:40.944462] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Thu Jul 25 17:18:45 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/07/25-17:18:48 ... thread 0: (1000000,1000000) ops and (358795.5,358795.5) ops/second in (2.787103,2.787103) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/6 567.00 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 355.4 2.30 2.09 12 0.192 0 0 0.0 0.0 L2 3/2 251.78 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.1 2.0 251.5 251.3 1.50 1.45 2 0.752 383K 181 0.0 0.0 L3 10/0 804.20 MB 0.8 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 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 1182/8 96.94 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.5 99.3 314.3 3.81 3.54 14 0.272 383K 181 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.1 1.5 99.3 314.3 3.81 3.54 14 0.272 383K 181 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.0 0.0 251.5 251.3 1.50 1.45 2 0.752 383K 181 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 355.4 2.30 2.09 12 0.192 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.17 GB write, 401.36 MB/s write, 0.37 GB read, 126.76 MB/s read, 3.8 seconds Interval compaction: 1.17 GB write, 429.16 MB/s write, 0.37 GB read, 135.54 MB/s read, 3.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 1, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 1, interval: 1 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 101890 Average: 1.8228 StdDev: 15.89 Min: 1 Median: 1.1792 Max: 3462 Percentiles: P50: 1.18 P75: 1.63 P99: 3.85 P99.9: 8.84 P99.99: 271.09 ------------------------------------------------------ [ 0, 1 ] 40911 40.152% 40.152% ######## ( 1, 2 ] 56006 54.967% 95.119% ########### ( 2, 3 ] 3006 2.950% 98.069% # ( 3, 4 ] 1121 1.100% 99.170% ( 4, 6 ] 621 0.609% 99.779% ( 6, 10 ] 175 0.172% 99.951% ( 10, 15 ] 21 0.021% 99.972% ( 15, 22 ] 4 0.004% 99.975% ( 22, 34 ] 2 0.002% 99.977% ( 110, 170 ] 11 0.011% 99.988% ( 170, 250 ] 2 0.002% 99.990% ( 250, 380 ] 5 0.005% 99.995% ( 580, 870 ] 3 0.003% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 2 read latency histogram (micros): Count: 51226 Average: 1.9724 StdDev: 15.09 Min: 1 Median: 1.2193 Max: 2057 Percentiles: P50: 1.22 P75: 1.67 P99: 4.95 P99.9: 9.78 P99.99: 815.74 ------------------------------------------------------ [ 0, 1 ] 19414 37.899% 37.899% ######## ( 1, 2 ] 28264 55.175% 93.074% ########### ( 2, 3 ] 1832 3.576% 96.650% # ( 3, 4 ] 947 1.849% 98.499% ( 4, 6 ] 540 1.054% 99.553% ( 6, 10 ] 189 0.369% 99.922% ( 10, 15 ] 19 0.037% 99.959% ( 15, 22 ] 3 0.006% 99.965% ( 22, 34 ] 2 0.004% 99.969% ( 51, 76 ] 2 0.004% 99.973% ( 76, 110 ] 1 0.002% 99.975% ( 110, 170 ] 1 0.002% 99.977% ( 250, 380 ] 3 0.006% 99.982% ( 580, 870 ] 6 0.012% 99.994% ( 870, 1300 ] 3 0.006% 100.000% ( 1900, 2900 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 40 Average: 1250.8250 StdDev: 872.20 Min: 54 Median: 1104.5455 Max: 3746 Percentiles: P50: 1104.55 P75: 1675.00 P99: 3746.00 P99.9: 3746.00 P99.99: 3746.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 110, 170 ] 2 5.000% 7.500% # ( 170, 250 ] 1 2.500% 10.000% # ( 250, 380 ] 2 5.000% 15.000% # ( 380, 580 ] 3 7.500% 22.500% ## ( 580, 870 ] 5 12.500% 35.000% ### ( 870, 1300 ] 11 27.500% 62.500% ###### ( 1300, 1900 ] 8 20.000% 82.500% #### ( 1900, 2900 ] 4 10.000% 92.500% ## ( 2900, 4400 ] 3 7.500% 100.000% ## ** Level 4 read latency histogram (micros): Count: 30 Average: 1544.8000 StdDev: 1054.93 Min: 287 Median: 1228.3333 Max: 4388 Percentiles: P50: 1228.33 P75: 1857.14 P99: 4310.00 P99.9: 4388.00 P99.99: 4388.00 ------------------------------------------------------ ( 250, 380 ] 2 6.667% 6.667% # ( 380, 580 ] 1 3.333% 10.000% # ( 580, 870 ] 7 23.333% 33.333% ##### ( 870, 1300 ] 6 20.000% 53.333% #### ( 1300, 1900 ] 7 23.333% 76.667% ##### ( 1900, 2900 ] 2 6.667% 83.333% # ( 2900, 4400 ] 5 16.667% 100.000% ### ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 330.05 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.212 H:M:S, 7.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 352.84 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.212 H:M:S, 7.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/25-17:18:51 ... thread 0: (1000000,2000000) ops and (324395.5,340729.4) ops/second in (3.082657,5.869760) 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/11 1.17 GB 18.9 0.2 0.0 0.2 2.0 1.8 0.0 1.1 41.2 339.8 6.12 5.55 27 0.227 255K 258 0.0 0.0 L1 1/1 3.04 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 240.6 240.2 1.57 1.52 1 1.571 383K 597 0.0 0.0 L2 2/1 55.12 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 251.5 251.3 1.50 1.45 2 0.752 383K 181 0.0 0.0 L3 20/10 1.12 GB 0.3 0.2 0.2 0.0 0.2 0.2 0.4 1.0 230.5 230.5 1.08 1.01 1 1.084 253K 0 0.0 0.0 L4 174/0 9.75 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 159.2 159.3 1.41 1.05 1 1.413 228K 0 0.0 0.0 L5 1044/0 85.82 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 1255/23 97.92 GB 0.0 1.4 1.0 0.4 3.2 2.8 1.1 1.8 126.9 283.1 11.69 10.58 32 0.365 1505K 1036 0.0 0.0 Int 0/0 0.00 KB 0.0 1.4 1.0 0.4 3.2 2.8 1.0 1.8 126.9 283.1 11.69 10.58 32 0.365 1505K 1036 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.4 1.0 0.4 1.4 1.0 0.0 0.0 226.9 226.8 6.53 5.97 6 1.089 1505K 1036 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 354.5 5.15 4.61 26 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 total, 5.9 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.23 GB write, 545.56 MB/s write, 1.45 GB read, 244.49 MB/s read, 11.7 seconds Interval compaction: 3.23 GB write, 563.51 MB/s write, 1.45 GB read, 252.53 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: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 366879 Average: 2.1894 StdDev: 14.70 Min: 1 Median: 1.4610 Max: 3462 Percentiles: P50: 1.46 P75: 1.86 P99: 5.67 P99.9: 9.89 P99.99: 14.75 ------------------------------------------------------ [ 0, 1 ] 77188 21.039% 21.039% #### ( 1, 2 ] 230491 62.825% 83.864% ############# ( 2, 3 ] 32631 8.894% 92.758% ## ( 3, 4 ] 14567 3.971% 96.729% # ( 4, 6 ] 9973 2.718% 99.447% # ( 6, 10 ] 1709 0.466% 99.913% ( 10, 15 ] 299 0.081% 99.994% ( 15, 22 ] 29 0.008% 100.002% ( 22, 34 ] 9 0.002% 100.005% ( 34, 51 ] 3 0.001% 100.005% ( 51, 76 ] 1 0.000% 100.006% ( 110, 170 ] 17 0.005% 100.010% ( 170, 250 ] 7 0.002% 100.012% ( 250, 380 ] 11 0.003% 100.015% ( 380, 580 ] 3 0.001% 100.016% ( 580, 870 ] 6 0.002% 100.018% ( 1300, 1900 ] 3 0.001% 100.019% ( 1900, 2900 ] 2 0.001% 100.019% ( 2900, 4400 ] 5 0.001% 100.020% ** Level 1 read latency histogram (micros): Count: 26 Average: 184.9231 StdDev: 371.64 Min: 1 Median: 1.8182 Max: 1474 Percentiles: P50: 1.82 P75: 210.00 P99: 1474.00 P99.9: 1474.00 P99.99: 1474.00 ------------------------------------------------------ [ 0, 1 ] 4 15.385% 15.385% ### ( 1, 2 ] 11 42.308% 57.692% ######## ( 2, 3 ] 1 3.846% 61.538% # ( 3, 4 ] 1 3.846% 65.385% # ( 4, 6 ] 1 3.846% 69.231% # ( 110, 170 ] 1 3.846% 73.077% # ( 170, 250 ] 1 3.846% 76.923% # ( 250, 380 ] 3 11.538% 88.462% ## ( 870, 1300 ] 2 7.692% 96.154% ## ( 1300, 1900 ] 1 3.846% 100.000% # ** Level 2 read latency histogram (micros): Count: 95754 Average: 2.0910 StdDev: 11.06 Min: 1 Median: 1.3817 Max: 2057 Percentiles: P50: 1.38 P75: 1.80 P99: 5.64 P99.9: 10.09 P99.99: 600.52 ------------------------------------------------------ [ 0, 1 ] 26060 27.216% 27.216% ##### ( 1, 2 ] 57154 59.688% 86.904% ############ ( 2, 3 ] 6557 6.848% 93.752% # ( 3, 4 ] 3204 3.346% 97.098% # ( 4, 6 ] 2224 2.323% 99.420% ( 6, 10 ] 458 0.478% 99.899% ( 10, 15 ] 71 0.074% 99.973% ( 15, 22 ] 7 0.007% 99.980% ( 22, 34 ] 2 0.002% 99.982% ( 51, 76 ] 2 0.002% 99.984% ( 76, 110 ] 1 0.001% 99.985% ( 110, 170 ] 1 0.001% 99.986% ( 250, 380 ] 3 0.003% 99.990% ( 580, 870 ] 6 0.006% 99.996% ( 870, 1300 ] 3 0.003% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 187168 Average: 3.1387 StdDev: 27.26 Min: 1 Median: 1.5590 Max: 3746 Percentiles: P50: 1.56 P75: 1.96 P99: 8.71 P99.9: 162.10 P99.99: 413.96 ------------------------------------------------------ [ 0, 1 ] 28326 15.134% 15.134% ### ( 1, 2 ] 116743 62.373% 77.507% ############ ( 2, 3 ] 23467 12.538% 90.045% ### ( 3, 4 ] 8281 4.424% 94.470% # ( 4, 6 ] 6651 3.553% 98.023% # ( 6, 10 ] 2698 1.441% 99.465% ( 10, 15 ] 437 0.233% 99.698% ( 15, 22 ] 73 0.039% 99.737% ( 22, 34 ] 20 0.011% 99.748% ( 34, 51 ] 3 0.002% 99.749% ( 51, 76 ] 6 0.003% 99.753% ( 76, 110 ] 91 0.049% 99.801% ( 110, 170 ] 214 0.114% 99.916% ( 170, 250 ] 75 0.040% 99.956% ( 250, 380 ] 59 0.032% 99.987% ( 380, 580 ] 37 0.020% 100.007% ( 580, 870 ] 23 0.012% 100.019% ( 870, 1300 ] 17 0.009% 100.028% ( 1300, 1900 ] 9 0.005% 100.033% ( 1900, 2900 ] 5 0.003% 100.036% ( 2900, 4400 ] 3 0.002% 100.037% ** Level 4 read latency histogram (micros): Count: 320 Average: 150.3750 StdDev: 553.48 Min: 1 Median: 1.7500 Max: 4388 Percentiles: P50: 1.75 P75: 7.71 P99: 3440.00 P99.9: 4304.00 P99.99: 4388.00 ------------------------------------------------------ [ 0, 1 ] 67 20.938% 20.938% #### ( 1, 2 ] 124 38.750% 59.688% ######## ( 2, 3 ] 34 10.625% 70.312% ## ( 3, 4 ] 3 0.938% 71.250% ( 4, 6 ] 6 1.875% 73.125% ( 6, 10 ] 14 4.375% 77.500% # ( 10, 15 ] 36 11.250% 88.750% ## ( 15, 22 ] 4 1.250% 90.000% ( 170, 250 ] 1 0.312% 90.312% ( 250, 380 ] 2 0.625% 90.938% ( 380, 580 ] 2 0.625% 91.562% ( 580, 870 ] 7 2.188% 93.750% ( 870, 1300 ] 6 1.875% 95.625% ( 1300, 1900 ] 7 2.188% 97.812% ( 1900, 2900 ] 2 0.625% 98.438% ( 2900, 4400 ] 5 1.562% 100.000% ** DB Stats ** Uptime(secs): 6.1 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 324.57 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.623 H:M:S, 10.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.26 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.411 H:M:S, 13.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/25-17:18:54 ... thread 0: (1000000,3000000) ops and (320468.7,333697.1) ops/second in (3.120430,8.990190) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/7 1.48 GB 12.6 1.4 0.0 1.4 4.1 2.8 0.0 1.5 103.5 314.9 13.40 12.41 45 0.298 1407K 1550 0.0 0.0 L1 3/3 212.37 MB 0.0 1.0 1.0 0.0 1.0 1.0 0.2 1.0 234.6 234.0 4.58 4.43 2 2.288 1090K 2615 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 251.5 251.3 1.50 1.45 2 0.752 383K 181 0.0 0.0 L3 21/0 909.86 MB 0.9 1.9 0.8 1.1 1.9 0.8 0.4 2.5 233.0 232.5 8.31 7.77 6 1.385 1966K 3994 0.0 0.0 L4 174/0 9.53 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 159.2 159.3 1.41 1.05 1 1.413 228K 0 0.0 0.0 L5 1056/0 86.80 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1263/10 98.90 GB 0.0 4.9 2.2 2.7 7.6 5.0 3.3 2.8 171.2 268.0 29.20 27.11 56 0.521 5076K 8340 0.0 0.0 Int 0/0 0.00 KB 0.0 4.9 2.2 2.7 7.6 5.0 3.2 2.8 171.2 268.0 29.20 27.11 56 0.521 5076K 8340 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.9 2.2 2.7 4.9 2.2 0.0 0.0 236.5 236.1 21.14 19.93 16 1.321 5076K 8340 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 351.5 8.06 7.19 40 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): 9.2 total, 9.0 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.64 GB write, 851.97 MB/s write, 4.88 GB read, 544.26 MB/s read, 29.2 seconds Interval compaction: 7.64 GB write, 870.27 MB/s write, 4.88 GB read, 555.95 MB/s read, 29.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 702682 Average: 2.2995 StdDev: 12.82 Min: 1 Median: 1.5292 Max: 4258 Percentiles: P50: 1.53 P75: 1.93 P99: 5.84 P99.9: 10.45 P99.99: 14.22 ------------------------------------------------------ [ 0, 1 ] 116459 16.573% 16.573% ### ( 1, 2 ] 443835 63.163% 79.736% ############# ( 2, 3 ] 74342 10.580% 90.316% ## ( 3, 4 ] 36044 5.129% 95.446% # ( 4, 6 ] 27205 3.872% 99.317% # ( 6, 10 ] 4020 0.572% 99.889% ( 10, 15 ] 839 0.119% 100.009% ( 15, 22 ] 65 0.009% 100.018% ( 22, 34 ] 15 0.002% 100.020% ( 34, 51 ] 5 0.001% 100.021% ( 51, 76 ] 1 0.000% 100.021% ( 76, 110 ] 1 0.000% 100.021% ( 110, 170 ] 21 0.003% 100.024% ( 170, 250 ] 18 0.003% 100.027% ( 250, 380 ] 17 0.002% 100.029% ( 380, 580 ] 7 0.001% 100.030% ( 580, 870 ] 12 0.002% 100.032% ( 870, 1300 ] 3 0.000% 100.032% ( 1300, 1900 ] 3 0.000% 100.033% ( 1900, 2900 ] 2 0.000% 100.033% ( 2900, 4400 ] 7 0.001% 100.034% ** Level 1 read latency histogram (micros): Count: 217214 Average: 2.8003 StdDev: 10.91 Min: 1 Median: 1.7184 Max: 1824 Percentiles: P50: 1.72 P75: 2.52 P99: 7.90 P99.9: 12.43 P99.99: 13.89 ------------------------------------------------------ [ 0, 1 ] 15884 7.313% 7.313% # ( 1, 2 ] 129068 59.420% 66.732% ############ ( 2, 3 ] 34709 15.979% 82.712% ### ( 3, 4 ] 17522 8.067% 90.778% ## ( 4, 6 ] 16381 7.541% 98.320% ## ( 6, 10 ] 3108 1.431% 99.750% ( 10, 15 ] 668 0.308% 100.058% ( 15, 22 ] 70 0.032% 100.090% ( 22, 34 ] 4 0.002% 100.092% ( 34, 51 ] 4 0.002% 100.094% ( 51, 76 ] 1 0.000% 100.094% ( 76, 110 ] 11 0.005% 100.099% ( 110, 170 ] 25 0.012% 100.111% ( 170, 250 ] 21 0.010% 100.121% ( 250, 380 ] 23 0.011% 100.131% ( 380, 580 ] 18 0.008% 100.139% ( 580, 870 ] 9 0.004% 100.144% ( 870, 1300 ] 5 0.002% 100.146% ( 1300, 1900 ] 3 0.001% 100.147% ** Level 2 read latency histogram (micros): Count: 124192 Average: 2.3153 StdDev: 12.15 Min: 1 Median: 1.4210 Max: 2057 Percentiles: P50: 1.42 P75: 1.83 P99: 6.00 P99.9: 89.14 P99.99: 630.94 ------------------------------------------------------ [ 0, 1 ] 30233 24.344% 24.344% ##### ( 1, 2 ] 75693 60.948% 85.292% ############ ( 2, 3 ] 9120 7.343% 92.636% # ( 3, 4 ] 4709 3.792% 96.427% # ( 4, 6 ] 3199 2.576% 99.003% # ( 6, 10 ] 949 0.764% 99.767% ( 10, 15 ] 125 0.101% 99.868% ( 15, 22 ] 11 0.009% 99.877% ( 22, 34 ] 2 0.002% 99.878% ( 34, 51 ] 1 0.001% 99.879% ( 51, 76 ] 3 0.002% 99.882% ( 76, 110 ] 59 0.048% 99.929% ( 110, 170 ] 44 0.035% 99.965% ( 170, 250 ] 8 0.006% 99.971% ( 250, 380 ] 17 0.014% 99.985% ( 380, 580 ] 5 0.004% 99.989% ( 580, 870 ] 9 0.007% 99.996% ( 870, 1300 ] 4 0.003% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 239453 Average: 3.1620 StdDev: 26.27 Min: 1 Median: 1.5719 Max: 3746 Percentiles: P50: 1.57 P75: 1.97 P99: 8.79 P99.9: 172.65 P99.99: 518.38 ------------------------------------------------------ [ 0, 1 ] 34607 14.453% 14.453% ### ( 1, 2 ] 148830 62.154% 76.607% ############ ( 2, 3 ] 29661 12.387% 88.994% ## ( 3, 4 ] 12203 5.096% 94.090% # ( 4, 6 ] 9223 3.852% 97.942% # ( 6, 10 ] 3636 1.518% 99.460% ( 10, 15 ] 586 0.245% 99.705% ( 15, 22 ] 84 0.035% 99.740% ( 22, 34 ] 24 0.010% 99.750% ( 34, 51 ] 3 0.001% 99.751% ( 51, 76 ] 6 0.003% 99.754% ( 76, 110 ] 104 0.043% 99.797% ( 110, 170 ] 243 0.101% 99.899% ( 170, 250 ] 107 0.045% 99.943% ( 250, 380 ] 74 0.031% 99.974% ( 380, 580 ] 55 0.023% 99.997% ( 580, 870 ] 38 0.016% 100.013% ( 870, 1300 ] 20 0.008% 100.021% ( 1300, 1900 ] 9 0.004% 100.025% ( 1900, 2900 ] 6 0.003% 100.028% ( 2900, 4400 ] 3 0.001% 100.029% ** Level 4 read latency histogram (micros): Count: 320 Average: 150.3750 StdDev: 553.48 Min: 1 Median: 1.7500 Max: 4388 Percentiles: P50: 1.75 P75: 7.71 P99: 3440.00 P99.9: 4304.00 P99.99: 4388.00 ------------------------------------------------------ [ 0, 1 ] 67 20.938% 20.938% #### ( 1, 2 ] 124 38.750% 59.688% ######## ( 2, 3 ] 34 10.625% 70.312% ## ( 3, 4 ] 3 0.938% 71.250% ( 4, 6 ] 6 1.875% 73.125% ( 6, 10 ] 14 4.375% 77.500% # ( 10, 15 ] 36 11.250% 88.750% ## ( 15, 22 ] 4 1.250% 90.000% ( 170, 250 ] 1 0.312% 90.312% ( 250, 380 ] 2 0.625% 90.938% ( 380, 580 ] 2 0.625% 91.562% ( 580, 870 ] 7 2.188% 93.750% ( 870, 1300 ] 6 1.875% 95.625% ( 1300, 1900 ] 7 2.188% 97.812% ( 1900, 2900 ] 2 0.625% 98.438% ( 2900, 4400 ] 5 1.562% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 831.7667 StdDev: 1026.63 Min: 91 Median: 380.0000 Max: 4712 Percentiles: P50: 380.00 P75: 1300.00 P99: 4712.00 P99.9: 4712.00 P99.99: 4712.00 ------------------------------------------------------ ( 76, 110 ] 5 8.333% 8.333% ## ( 110, 170 ] 10 16.667% 25.000% ### ( 170, 250 ] 5 8.333% 33.333% ## ( 250, 380 ] 10 16.667% 50.000% ### ( 380, 580 ] 10 16.667% 66.667% ### ( 580, 870 ] 3 5.000% 71.667% # ( 870, 1300 ] 2 3.333% 75.000% # ( 1300, 1900 ] 6 10.000% 85.000% ## ( 1900, 2900 ] 5 8.333% 93.333% ## ( 2900, 4400 ] 3 5.000% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 9.2 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 321.45 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.043 H:M:S, 11.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 315.39 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.420 H:M:S, 13.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/25-17:18:57 ... thread 0: (1000000,4000000) ops and (324851.6,331440.8) ops/second in (3.078329,12.068519) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/11 2.40 GB 75.5 1.9 0.0 1.9 5.6 3.7 0.0 1.5 106.6 312.7 18.33 16.98 60 0.305 1982K 2155 0.0 0.0 L1 3/3 212.37 MB 0.0 1.0 1.0 0.0 1.0 1.0 0.2 1.0 234.6 234.0 4.58 4.43 2 2.288 1090K 2615 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 251.5 251.3 1.50 1.45 2 0.752 383K 181 0.0 0.0 L3 21/0 909.86 MB 0.9 1.9 0.8 1.1 1.9 0.8 0.4 2.5 233.0 232.5 8.31 7.77 6 1.385 1966K 3994 0.0 0.0 L4 174/0 9.53 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 159.2 159.3 1.41 1.05 1 1.413 228K 0 0.0 0.0 L5 1056/0 86.80 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1270/14 99.82 GB 0.0 5.4 2.2 3.2 9.1 5.9 3.3 2.5 163.1 273.6 34.13 31.68 71 0.481 5651K 8945 0.0 0.0 Int 0/0 0.00 KB 0.0 5.4 2.2 3.2 9.1 5.9 3.2 2.5 163.1 273.6 34.13 31.68 71 0.481 5651K 8945 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.4 2.2 3.2 5.4 2.2 0.0 0.0 238.5 238.1 23.34 22.07 18 1.296 5651K 8945 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 350.2 10.79 9.61 53 0.204 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.3 total, 12.1 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.12 GB write, 761.35 MB/s write, 5.44 GB read, 453.87 MB/s read, 34.1 seconds Interval compaction: 9.12 GB write, 773.53 MB/s write, 5.44 GB read, 461.14 MB/s read, 34.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: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 14, interval: 14 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1079662 Average: 2.2416 StdDev: 11.77 Min: 1 Median: 1.5053 Max: 4258 Percentiles: P50: 1.51 P75: 1.89 P99: 5.78 P99.9: 10.47 P99.99: 14.21 ------------------------------------------------------ [ 0, 1 ] 187330 17.351% 17.351% ### ( 1, 2 ] 697658 64.618% 81.969% ############# ( 2, 3 ] 104160 9.647% 91.616% ## ( 3, 4 ] 49066 4.545% 96.161% # ( 4, 6 ] 34417 3.188% 99.349% # ( 6, 10 ] 5833 0.540% 99.889% ( 10, 15 ] 1297 0.120% 100.009% ( 15, 22 ] 94 0.009% 100.018% ( 22, 34 ] 18 0.002% 100.020% ( 34, 51 ] 8 0.001% 100.020% ( 51, 76 ] 3 0.000% 100.021% ( 76, 110 ] 20 0.002% 100.022% ( 110, 170 ] 36 0.003% 100.026% ( 170, 250 ] 27 0.003% 100.028% ( 250, 380 ] 27 0.003% 100.031% ( 380, 580 ] 11 0.001% 100.032% ( 580, 870 ] 17 0.002% 100.033% ( 870, 1300 ] 5 0.000% 100.034% ( 1300, 1900 ] 6 0.001% 100.034% ( 1900, 2900 ] 3 0.000% 100.035% ( 2900, 4400 ] 8 0.001% 100.035% ** Level 1 read latency histogram (micros): Count: 217214 Average: 2.8003 StdDev: 10.91 Min: 1 Median: 1.7184 Max: 1824 Percentiles: P50: 1.72 P75: 2.52 P99: 7.90 P99.9: 12.43 P99.99: 13.89 ------------------------------------------------------ [ 0, 1 ] 15884 7.313% 7.313% # ( 1, 2 ] 129068 59.420% 66.732% ############ ( 2, 3 ] 34709 15.979% 82.712% ### ( 3, 4 ] 17522 8.067% 90.778% ## ( 4, 6 ] 16381 7.541% 98.320% ## ( 6, 10 ] 3108 1.431% 99.750% ( 10, 15 ] 668 0.308% 100.058% ( 15, 22 ] 70 0.032% 100.090% ( 22, 34 ] 4 0.002% 100.092% ( 34, 51 ] 4 0.002% 100.094% ( 51, 76 ] 1 0.000% 100.094% ( 76, 110 ] 11 0.005% 100.099% ( 110, 170 ] 25 0.012% 100.111% ( 170, 250 ] 21 0.010% 100.121% ( 250, 380 ] 23 0.011% 100.131% ( 380, 580 ] 18 0.008% 100.139% ( 580, 870 ] 9 0.004% 100.144% ( 870, 1300 ] 5 0.002% 100.146% ( 1300, 1900 ] 3 0.001% 100.147% ** Level 2 read latency histogram (micros): Count: 124192 Average: 2.3153 StdDev: 12.15 Min: 1 Median: 1.4210 Max: 2057 Percentiles: P50: 1.42 P75: 1.83 P99: 6.00 P99.9: 89.14 P99.99: 630.94 ------------------------------------------------------ [ 0, 1 ] 30233 24.344% 24.344% ##### ( 1, 2 ] 75693 60.948% 85.292% ############ ( 2, 3 ] 9120 7.343% 92.636% # ( 3, 4 ] 4709 3.792% 96.427% # ( 4, 6 ] 3199 2.576% 99.003% # ( 6, 10 ] 949 0.764% 99.767% ( 10, 15 ] 125 0.101% 99.868% ( 15, 22 ] 11 0.009% 99.877% ( 22, 34 ] 2 0.002% 99.878% ( 34, 51 ] 1 0.001% 99.879% ( 51, 76 ] 3 0.002% 99.882% ( 76, 110 ] 59 0.048% 99.929% ( 110, 170 ] 44 0.035% 99.965% ( 170, 250 ] 8 0.006% 99.971% ( 250, 380 ] 17 0.014% 99.985% ( 380, 580 ] 5 0.004% 99.989% ( 580, 870 ] 9 0.007% 99.996% ( 870, 1300 ] 4 0.003% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 239453 Average: 3.1620 StdDev: 26.27 Min: 1 Median: 1.5719 Max: 3746 Percentiles: P50: 1.57 P75: 1.97 P99: 8.79 P99.9: 172.65 P99.99: 518.38 ------------------------------------------------------ [ 0, 1 ] 34607 14.453% 14.453% ### ( 1, 2 ] 148830 62.154% 76.607% ############ ( 2, 3 ] 29661 12.387% 88.994% ## ( 3, 4 ] 12203 5.096% 94.090% # ( 4, 6 ] 9223 3.852% 97.942% # ( 6, 10 ] 3636 1.518% 99.460% ( 10, 15 ] 586 0.245% 99.705% ( 15, 22 ] 84 0.035% 99.740% ( 22, 34 ] 24 0.010% 99.750% ( 34, 51 ] 3 0.001% 99.751% ( 51, 76 ] 6 0.003% 99.754% ( 76, 110 ] 104 0.043% 99.797% ( 110, 170 ] 243 0.101% 99.899% ( 170, 250 ] 107 0.045% 99.943% ( 250, 380 ] 74 0.031% 99.974% ( 380, 580 ] 55 0.023% 99.997% ( 580, 870 ] 38 0.016% 100.013% ( 870, 1300 ] 20 0.008% 100.021% ( 1300, 1900 ] 9 0.004% 100.025% ( 1900, 2900 ] 6 0.003% 100.028% ( 2900, 4400 ] 3 0.001% 100.029% ** Level 4 read latency histogram (micros): Count: 320 Average: 150.3750 StdDev: 553.48 Min: 1 Median: 1.7500 Max: 4388 Percentiles: P50: 1.75 P75: 7.71 P99: 3440.00 P99.9: 4304.00 P99.99: 4388.00 ------------------------------------------------------ [ 0, 1 ] 67 20.938% 20.938% #### ( 1, 2 ] 124 38.750% 59.688% ######## ( 2, 3 ] 34 10.625% 70.312% ## ( 3, 4 ] 3 0.938% 71.250% ( 4, 6 ] 6 1.875% 73.125% ( 6, 10 ] 14 4.375% 77.500% # ( 10, 15 ] 36 11.250% 88.750% ## ( 15, 22 ] 4 1.250% 90.000% ( 170, 250 ] 1 0.312% 90.312% ( 250, 380 ] 2 0.625% 90.938% ( 380, 580 ] 2 0.625% 91.562% ( 580, 870 ] 7 2.188% 93.750% ( 870, 1300 ] 6 1.875% 95.625% ( 1300, 1900 ] 7 2.188% 97.812% ( 1900, 2900 ] 2 0.625% 98.438% ( 2900, 4400 ] 5 1.562% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 831.7667 StdDev: 1026.63 Min: 91 Median: 380.0000 Max: 4712 Percentiles: P50: 380.00 P75: 1300.00 P99: 4712.00 P99.9: 4712.00 P99.99: 4712.00 ------------------------------------------------------ ( 76, 110 ] 5 8.333% 8.333% ## ( 110, 170 ] 10 16.667% 25.000% ### ( 170, 250 ] 5 8.333% 33.333% ## ( 250, 380 ] 10 16.667% 50.000% ### ( 380, 580 ] 10 16.667% 66.667% ### ( 580, 870 ] 3 5.000% 71.667% # ( 870, 1300 ] 2 3.333% 75.000% # ( 1300, 1900 ] 6 10.000% 85.000% ## ( 1900, 2900 ] 5 8.333% 93.333% ## ( 2900, 4400 ] 3 5.000% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 12.3 total, 3.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 321.02 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.485 H:M:S, 12.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.73 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.442 H:M:S, 14.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/25-17:19:00 ... thread 0: (1000000,5000000) ops and (323217.6,329762.9) ops/second in (3.093891,15.162410) 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/11 3.38 GB 182.5 3.0 0.0 3.0 7.7 4.7 0.0 1.6 121.3 309.4 25.44 23.72 78 0.326 3134K 3369 0.0 0.0 L1 3/3 212.37 MB 0.0 1.0 1.0 0.0 1.0 1.0 0.2 1.0 234.6 234.0 4.58 4.43 2 2.288 1090K 2615 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 251.5 251.3 1.50 1.45 2 0.752 383K 181 0.0 0.0 L3 21/0 909.86 MB 0.9 1.9 0.8 1.1 1.9 0.8 0.4 2.5 233.0 232.5 8.31 7.77 6 1.385 1966K 3994 0.0 0.0 L4 174/0 9.53 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 159.2 159.3 1.41 1.05 1 1.413 228K 0 0.0 0.0 L5 1056/0 86.80 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1272/14 100.80 GB 0.0 6.5 2.2 4.3 11.2 6.9 3.3 2.4 162.5 278.3 41.24 38.42 89 0.463 6803K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.5 2.2 4.3 11.2 6.9 3.2 2.4 162.5 278.3 41.24 38.42 89 0.463 6803K 10K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.5 2.2 4.3 6.5 2.2 0.0 0.0 242.7 242.4 27.60 26.26 22 1.255 6803K 10K 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 351.0 13.64 12.16 67 0.204 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.4 total, 15.2 interval Flush(GB): cumulative 4.675, interval 4.675 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.21 GB write, 747.34 MB/s write, 6.54 GB read, 436.27 MB/s read, 41.2 seconds Interval compaction: 11.21 GB write, 756.86 MB/s write, 6.54 GB read, 441.83 MB/s read, 41.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 17, interval: 18 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1459169 Average: 2.2504 StdDev: 11.71 Min: 1 Median: 1.5028 Max: 4258 Percentiles: P50: 1.50 P75: 1.89 P99: 5.80 P99.9: 10.60 P99.99: 14.40 ------------------------------------------------------ [ 0, 1 ] 249881 17.125% 17.125% ### ( 1, 2 ] 954092 65.386% 82.511% ############# ( 2, 3 ] 137897 9.450% 91.961% ## ( 3, 4 ] 63443 4.348% 96.309% # ( 4, 6 ] 43747 2.998% 99.307% # ( 6, 10 ] 8442 0.579% 99.886% ( 10, 15 ] 1728 0.118% 100.004% ( 15, 22 ] 127 0.009% 100.013% ( 22, 34 ] 29 0.002% 100.015% ( 34, 51 ] 10 0.001% 100.016% ( 51, 76 ] 6 0.000% 100.016% ( 76, 110 ] 41 0.003% 100.019% ( 110, 170 ] 89 0.006% 100.025% ( 170, 250 ] 58 0.004% 100.029% ( 250, 380 ] 41 0.003% 100.032% ( 380, 580 ] 27 0.002% 100.034% ( 580, 870 ] 32 0.002% 100.036% ( 870, 1300 ] 11 0.001% 100.036% ( 1300, 1900 ] 8 0.001% 100.037% ( 1900, 2900 ] 3 0.000% 100.037% ( 2900, 4400 ] 10 0.001% 100.038% ** Level 1 read latency histogram (micros): Count: 263628 Average: 2.7736 StdDev: 10.99 Min: 1 Median: 1.6766 Max: 1824 Percentiles: P50: 1.68 P75: 2.36 P99: 8.01 P99.9: 13.20 P99.99: 14.86 ------------------------------------------------------ [ 0, 1 ] 23405 8.878% 8.878% ## ( 1, 2 ] 160237 60.781% 69.660% ############ ( 2, 3 ] 38754 14.700% 84.360% ### ( 3, 4 ] 19166 7.270% 91.630% # ( 4, 6 ] 17498 6.637% 98.267% # ( 6, 10 ] 3847 1.459% 99.727% ( 10, 15 ] 714 0.271% 99.997% ( 15, 22 ] 75 0.028% 100.026% ( 22, 34 ] 4 0.002% 100.027% ( 34, 51 ] 5 0.002% 100.029% ( 51, 76 ] 12 0.005% 100.034% ( 76, 110 ] 52 0.020% 100.053% ( 110, 170 ] 63 0.024% 100.077% ( 170, 250 ] 40 0.015% 100.093% ( 250, 380 ] 30 0.011% 100.104% ( 380, 580 ] 26 0.010% 100.114% ( 580, 870 ] 12 0.005% 100.118% ( 870, 1300 ] 5 0.002% 100.120% ( 1300, 1900 ] 3 0.001% 100.121% ** Level 2 read latency histogram (micros): Count: 124192 Average: 2.3153 StdDev: 12.15 Min: 1 Median: 1.4210 Max: 2057 Percentiles: P50: 1.42 P75: 1.83 P99: 6.00 P99.9: 89.14 P99.99: 630.94 ------------------------------------------------------ [ 0, 1 ] 30233 24.344% 24.344% ##### ( 1, 2 ] 75693 60.948% 85.292% ############ ( 2, 3 ] 9120 7.343% 92.636% # ( 3, 4 ] 4709 3.792% 96.427% # ( 4, 6 ] 3199 2.576% 99.003% # ( 6, 10 ] 949 0.764% 99.767% ( 10, 15 ] 125 0.101% 99.868% ( 15, 22 ] 11 0.009% 99.877% ( 22, 34 ] 2 0.002% 99.878% ( 34, 51 ] 1 0.001% 99.879% ( 51, 76 ] 3 0.002% 99.882% ( 76, 110 ] 59 0.048% 99.929% ( 110, 170 ] 44 0.035% 99.965% ( 170, 250 ] 8 0.006% 99.971% ( 250, 380 ] 17 0.014% 99.985% ( 380, 580 ] 5 0.004% 99.989% ( 580, 870 ] 9 0.007% 99.996% ( 870, 1300 ] 4 0.003% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 239453 Average: 3.1620 StdDev: 26.27 Min: 1 Median: 1.5719 Max: 3746 Percentiles: P50: 1.57 P75: 1.97 P99: 8.79 P99.9: 172.65 P99.99: 518.38 ------------------------------------------------------ [ 0, 1 ] 34607 14.453% 14.453% ### ( 1, 2 ] 148830 62.154% 76.607% ############ ( 2, 3 ] 29661 12.387% 88.994% ## ( 3, 4 ] 12203 5.096% 94.090% # ( 4, 6 ] 9223 3.852% 97.942% # ( 6, 10 ] 3636 1.518% 99.460% ( 10, 15 ] 586 0.245% 99.705% ( 15, 22 ] 84 0.035% 99.740% ( 22, 34 ] 24 0.010% 99.750% ( 34, 51 ] 3 0.001% 99.751% ( 51, 76 ] 6 0.003% 99.754% ( 76, 110 ] 104 0.043% 99.797% ( 110, 170 ] 243 0.101% 99.899% ( 170, 250 ] 107 0.045% 99.943% ( 250, 380 ] 74 0.031% 99.974% ( 380, 580 ] 55 0.023% 99.997% ( 580, 870 ] 38 0.016% 100.013% ( 870, 1300 ] 20 0.008% 100.021% ( 1300, 1900 ] 9 0.004% 100.025% ( 1900, 2900 ] 6 0.003% 100.028% ( 2900, 4400 ] 3 0.001% 100.029% ** Level 4 read latency histogram (micros): Count: 320 Average: 150.3750 StdDev: 553.48 Min: 1 Median: 1.7500 Max: 4388 Percentiles: P50: 1.75 P75: 7.71 P99: 3440.00 P99.9: 4304.00 P99.99: 4388.00 ------------------------------------------------------ [ 0, 1 ] 67 20.938% 20.938% #### ( 1, 2 ] 124 38.750% 59.688% ######## ( 2, 3 ] 34 10.625% 70.312% ## ( 3, 4 ] 3 0.938% 71.250% ( 4, 6 ] 6 1.875% 73.125% ( 6, 10 ] 14 4.375% 77.500% # ( 10, 15 ] 36 11.250% 88.750% ## ( 15, 22 ] 4 1.250% 90.000% ( 170, 250 ] 1 0.312% 90.312% ( 250, 380 ] 2 0.625% 90.938% ( 380, 580 ] 2 0.625% 91.562% ( 580, 870 ] 7 2.188% 93.750% ( 870, 1300 ] 6 1.875% 95.625% ( 1300, 1900 ] 7 2.188% 97.812% ( 1900, 2900 ] 2 0.625% 98.438% ( 2900, 4400 ] 5 1.562% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 831.7667 StdDev: 1026.63 Min: 91 Median: 380.0000 Max: 4712 Percentiles: P50: 380.00 P75: 1300.00 P99: 4712.00 P99.9: 4712.00 P99.99: 4712.00 ------------------------------------------------------ ( 76, 110 ] 5 8.333% 8.333% ## ( 110, 170 ] 10 16.667% 25.000% ### ( 170, 250 ] 5 8.333% 33.333% ## ( 250, 380 ] 10 16.667% 50.000% ### ( 380, 580 ] 10 16.667% 66.667% ### ( 580, 870 ] 3 5.000% 71.667% # ( 870, 1300 ] 2 3.333% 75.000% # ( 1300, 1900 ] 6 10.000% 85.000% ## ( 1900, 2900 ] 5 8.333% 93.333% ## ( 2900, 4400 ] 3 5.000% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 15.4 total, 3.1 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 320.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:1.914 H:M:S, 12.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 318.11 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.429 H:M:S, 13.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/25-17:19:03 ... thread 0: (1000000,6000000) ops and (334823.9,330595.7) ops/second in (2.986645,18.149055) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/13 3.01 GB 18.9 3.8 0.0 3.8 9.5 5.7 0.0 1.7 125.0 310.3 31.25 29.17 95 0.329 3965K 4218 0.0 0.0 L1 13/13 1.55 GB 0.0 2.6 2.4 0.2 2.6 2.4 0.2 1.1 234.8 233.6 11.37 11.00 3 3.791 2711K 13K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 251.5 251.3 1.50 1.45 2 0.752 383K 181 0.0 0.0 L3 21/0 909.86 MB 0.9 1.9 0.8 1.1 1.9 0.8 0.4 2.5 233.0 232.5 8.31 7.77 6 1.385 1966K 3994 0.0 0.0 L4 174/0 9.53 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 159.2 159.3 1.41 1.05 1 1.413 228K 0 0.0 0.0 L5 1056/0 86.80 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1280/26 101.77 GB 0.0 8.9 3.6 5.3 14.5 9.2 3.3 2.6 169.3 276.5 53.85 50.44 107 0.503 9256K 22K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.9 3.6 5.3 14.5 9.2 3.2 2.6 169.3 276.5 53.85 50.44 107 0.503 9256K 22K 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.9 3.6 5.3 8.9 3.5 0.0 0.0 243.4 242.8 37.45 35.81 26 1.440 9256K 22K 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.4 16.40 14.63 81 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 18.3 total, 18.2 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: 14.54 GB write, 811.65 MB/s write, 8.90 GB read, 496.94 MB/s read, 53.8 seconds Interval compaction: 14.54 GB write, 820.28 MB/s write, 8.90 GB read, 502.23 MB/s read, 53.8 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: 21, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 2, total-stops: 21, interval: 23 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1690165 Average: 2.2244 StdDev: 12.35 Min: 1 Median: 1.4783 Max: 4258 Percentiles: P50: 1.48 P75: 1.86 P99: 5.75 P99.9: 11.00 P99.99: 14.94 ------------------------------------------------------ [ 0, 1 ] 319739 18.918% 18.918% #### ( 1, 2 ] 1098286 64.981% 83.899% ############# ( 2, 3 ] 147255 8.712% 92.611% ## ( 3, 4 ] 68124 4.031% 96.642% # ( 4, 6 ] 45622 2.699% 99.341% # ( 6, 10 ] 9063 0.536% 99.877% ( 10, 15 ] 1932 0.114% 99.991% ( 15, 22 ] 158 0.009% 100.001% ( 22, 34 ] 31 0.002% 100.003% ( 34, 51 ] 10 0.001% 100.003% ( 51, 76 ] 8 0.000% 100.004% ( 76, 110 ] 101 0.006% 100.010% ( 110, 170 ] 156 0.009% 100.019% ( 170, 250 ] 73 0.004% 100.023% ( 250, 380 ] 59 0.003% 100.027% ( 380, 580 ] 41 0.002% 100.029% ( 580, 870 ] 36 0.002% 100.031% ( 870, 1300 ] 15 0.001% 100.032% ( 1300, 1900 ] 10 0.001% 100.033% ( 1900, 2900 ] 5 0.000% 100.033% ( 2900, 4400 ] 12 0.001% 100.034% ** Level 1 read latency histogram (micros): Count: 277132 Average: 2.9052 StdDev: 15.12 Min: 1 Median: 1.6646 Max: 2223 Percentiles: P50: 1.66 P75: 2.32 P99: 8.15 P99.9: 14.29 P99.99: 96.44 ------------------------------------------------------ [ 0, 1 ] 26422 9.534% 9.534% ## ( 1, 2 ] 168750 60.892% 70.426% ############ ( 2, 3 ] 39650 14.307% 84.733% ### ( 3, 4 ] 19658 7.093% 91.826% # ( 4, 6 ] 17699 6.386% 98.213% # ( 6, 10 ] 4050 1.461% 99.674% ( 10, 15 ] 730 0.263% 99.938% ( 15, 22 ] 80 0.029% 99.966% ( 22, 34 ] 4 0.001% 99.968% ( 34, 51 ] 5 0.002% 99.970% ( 51, 76 ] 13 0.005% 99.974% ( 76, 110 ] 72 0.026% 100.000% ( 110, 170 ] 141 0.051% 100.051% ( 170, 250 ] 57 0.021% 100.072% ( 250, 380 ] 43 0.016% 100.087% ( 380, 580 ] 43 0.016% 100.103% ( 580, 870 ] 16 0.006% 100.109% ( 870, 1300 ] 12 0.004% 100.113% ( 1300, 1900 ] 6 0.002% 100.115% ( 1900, 2900 ] 1 0.000% 100.115% ** Level 2 read latency histogram (micros): Count: 124192 Average: 2.3153 StdDev: 12.15 Min: 1 Median: 1.4210 Max: 2057 Percentiles: P50: 1.42 P75: 1.83 P99: 6.00 P99.9: 89.14 P99.99: 630.94 ------------------------------------------------------ [ 0, 1 ] 30233 24.344% 24.344% ##### ( 1, 2 ] 75693 60.948% 85.292% ############ ( 2, 3 ] 9120 7.343% 92.636% # ( 3, 4 ] 4709 3.792% 96.427% # ( 4, 6 ] 3199 2.576% 99.003% # ( 6, 10 ] 949 0.764% 99.767% ( 10, 15 ] 125 0.101% 99.868% ( 15, 22 ] 11 0.009% 99.877% ( 22, 34 ] 2 0.002% 99.878% ( 34, 51 ] 1 0.001% 99.879% ( 51, 76 ] 3 0.002% 99.882% ( 76, 110 ] 59 0.048% 99.929% ( 110, 170 ] 44 0.035% 99.965% ( 170, 250 ] 8 0.006% 99.971% ( 250, 380 ] 17 0.014% 99.985% ( 380, 580 ] 5 0.004% 99.989% ( 580, 870 ] 9 0.007% 99.996% ( 870, 1300 ] 4 0.003% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 239453 Average: 3.1620 StdDev: 26.27 Min: 1 Median: 1.5719 Max: 3746 Percentiles: P50: 1.57 P75: 1.97 P99: 8.79 P99.9: 172.65 P99.99: 518.38 ------------------------------------------------------ [ 0, 1 ] 34607 14.453% 14.453% ### ( 1, 2 ] 148830 62.154% 76.607% ############ ( 2, 3 ] 29661 12.387% 88.994% ## ( 3, 4 ] 12203 5.096% 94.090% # ( 4, 6 ] 9223 3.852% 97.942% # ( 6, 10 ] 3636 1.518% 99.460% ( 10, 15 ] 586 0.245% 99.705% ( 15, 22 ] 84 0.035% 99.740% ( 22, 34 ] 24 0.010% 99.750% ( 34, 51 ] 3 0.001% 99.751% ( 51, 76 ] 6 0.003% 99.754% ( 76, 110 ] 104 0.043% 99.797% ( 110, 170 ] 243 0.101% 99.899% ( 170, 250 ] 107 0.045% 99.943% ( 250, 380 ] 74 0.031% 99.974% ( 380, 580 ] 55 0.023% 99.997% ( 580, 870 ] 38 0.016% 100.013% ( 870, 1300 ] 20 0.008% 100.021% ( 1300, 1900 ] 9 0.004% 100.025% ( 1900, 2900 ] 6 0.003% 100.028% ( 2900, 4400 ] 3 0.001% 100.029% ** Level 4 read latency histogram (micros): Count: 320 Average: 150.3750 StdDev: 553.48 Min: 1 Median: 1.7500 Max: 4388 Percentiles: P50: 1.75 P75: 7.71 P99: 3440.00 P99.9: 4304.00 P99.99: 4388.00 ------------------------------------------------------ [ 0, 1 ] 67 20.938% 20.938% #### ( 1, 2 ] 124 38.750% 59.688% ######## ( 2, 3 ] 34 10.625% 70.312% ## ( 3, 4 ] 3 0.938% 71.250% ( 4, 6 ] 6 1.875% 73.125% ( 6, 10 ] 14 4.375% 77.500% # ( 10, 15 ] 36 11.250% 88.750% ## ( 15, 22 ] 4 1.250% 90.000% ( 170, 250 ] 1 0.312% 90.312% ( 250, 380 ] 2 0.625% 90.938% ( 380, 580 ] 2 0.625% 91.562% ( 580, 870 ] 7 2.188% 93.750% ( 870, 1300 ] 6 1.875% 95.625% ( 1300, 1900 ] 7 2.188% 97.812% ( 1900, 2900 ] 2 0.625% 98.438% ( 2900, 4400 ] 5 1.562% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 831.7667 StdDev: 1026.63 Min: 91 Median: 380.0000 Max: 4712 Percentiles: P50: 380.00 P75: 1300.00 P99: 4712.00 P99.9: 4712.00 P99.99: 4712.00 ------------------------------------------------------ ( 76, 110 ] 5 8.333% 8.333% ## ( 110, 170 ] 10 16.667% 25.000% ### ( 170, 250 ] 5 8.333% 33.333% ## ( 250, 380 ] 10 16.667% 50.000% ### ( 380, 580 ] 10 16.667% 66.667% ### ( 580, 870 ] 3 5.000% 71.667% # ( 870, 1300 ] 2 3.333% 75.000% # ( 1300, 1900 ] 6 10.000% 85.000% ## ( 1900, 2900 ] 5 8.333% 93.333% ## ( 2900, 4400 ] 3 5.000% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 18.3 total, 3.0 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 321.91 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.287 H:M:S, 12.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 329.53 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.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/25-17:19:08 ... thread 0: (1000000,7000000) ops and (190489.0,299161.9) ops/second in (5.249647,23.398702) 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.99 GB 119.6 4.9 0.0 4.9 11.5 6.6 0.0 1.7 130.8 309.6 38.03 35.60 114 0.334 5053K 5313 0.0 0.0 L1 13/13 1.55 GB 0.0 2.6 2.4 0.2 2.6 2.4 0.2 1.1 234.8 233.6 11.37 11.00 3 3.791 2711K 13K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 251.5 251.3 1.50 1.45 2 0.752 383K 181 0.0 0.0 L3 21/0 909.86 MB 0.9 1.9 0.8 1.1 1.9 0.8 0.4 2.5 233.0 232.5 8.31 7.77 6 1.385 1966K 3994 0.0 0.0 L4 174/0 9.53 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 159.2 159.3 1.41 1.05 1 1.413 228K 0 0.0 0.0 L5 1056/0 86.80 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1283/26 102.76 GB 0.0 9.9 3.6 6.4 16.6 10.2 3.3 2.5 168.0 279.8 60.63 56.87 126 0.481 10M 23K 0.0 0.0 Int 0/0 0.00 KB 0.0 9.9 3.6 6.4 16.6 10.2 3.2 2.5 168.0 279.8 60.63 56.87 126 0.481 10M 23K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 9.9 3.6 6.4 9.9 3.5 0.0 0.0 246.5 245.9 41.33 39.63 30 1.378 10M 23K 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 352.5 19.30 17.23 96 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): 23.6 total, 23.4 interval Flush(GB): cumulative 6.644, interval 6.644 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 16.57 GB write, 719.12 MB/s write, 9.95 GB read, 431.76 MB/s read, 60.6 seconds Interval compaction: 16.57 GB write, 725.05 MB/s write, 9.95 GB read, 435.32 MB/s read, 60.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 9, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 9, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 23, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 9, total-stops: 23, interval: 32 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2170275 Average: 2.2008 StdDev: 12.01 Min: 1 Median: 1.4671 Max: 4258 Percentiles: P50: 1.47 P75: 1.85 P99: 5.71 P99.9: 10.98 P99.99: 18.82 ------------------------------------------------------ [ 0, 1 ] 420088 19.356% 19.356% #### ( 1, 2 ] 1423930 65.611% 84.967% ############# ( 2, 3 ] 178520 8.226% 93.193% ## ( 3, 4 ] 81657 3.763% 96.955% # ( 4, 6 ] 51966 2.394% 99.350% ( 6, 10 ] 11495 0.530% 99.879% ( 10, 15 ] 2296 0.106% 99.985% ( 15, 22 ] 194 0.009% 99.994% ( 22, 34 ] 34 0.002% 99.996% ( 34, 51 ] 12 0.001% 99.996% ( 51, 76 ] 11 0.001% 99.997% ( 76, 110 ] 147 0.007% 100.003% ( 110, 170 ] 258 0.012% 100.015% ( 170, 250 ] 93 0.004% 100.020% ( 250, 380 ] 81 0.004% 100.023% ( 380, 580 ] 50 0.002% 100.026% ( 580, 870 ] 46 0.002% 100.028% ( 870, 1300 ] 24 0.001% 100.029% ( 1300, 1900 ] 11 0.001% 100.029% ( 1900, 2900 ] 6 0.000% 100.030% ( 2900, 4400 ] 14 0.001% 100.030% ** Level 1 read latency histogram (micros): Count: 376328 Average: 2.7691 StdDev: 13.77 Min: 1 Median: 1.6018 Max: 2223 Percentiles: P50: 1.60 P75: 2.01 P99: 8.19 P99.9: 15.42 P99.99: 135.97 ------------------------------------------------------ [ 0, 1 ] 46424 12.336% 12.336% ## ( 1, 2 ] 235539 62.589% 74.925% ############# ( 2, 3 ] 46139 12.260% 87.185% ## ( 3, 4 ] 22219 5.904% 93.089% # ( 4, 6 ] 19190 5.099% 98.189% # ( 6, 10 ] 5574 1.481% 99.670% ( 10, 15 ] 861 0.229% 99.898% ( 15, 22 ] 95 0.025% 99.924% ( 22, 34 ] 4 0.001% 99.925% ( 34, 51 ] 6 0.002% 99.926% ( 51, 76 ] 15 0.004% 99.930% ( 76, 110 ] 114 0.030% 99.961% ( 110, 170 ] 255 0.068% 100.028% ( 170, 250 ] 70 0.019% 100.047% ( 250, 380 ] 49 0.013% 100.060% ( 380, 580 ] 57 0.015% 100.075% ( 580, 870 ] 17 0.005% 100.080% ( 870, 1300 ] 13 0.003% 100.083% ( 1300, 1900 ] 6 0.002% 100.085% ( 1900, 2900 ] 1 0.000% 100.085% ** Level 2 read latency histogram (micros): Count: 124192 Average: 2.3153 StdDev: 12.15 Min: 1 Median: 1.4210 Max: 2057 Percentiles: P50: 1.42 P75: 1.83 P99: 6.00 P99.9: 89.14 P99.99: 630.94 ------------------------------------------------------ [ 0, 1 ] 30233 24.344% 24.344% ##### ( 1, 2 ] 75693 60.948% 85.292% ############ ( 2, 3 ] 9120 7.343% 92.636% # ( 3, 4 ] 4709 3.792% 96.427% # ( 4, 6 ] 3199 2.576% 99.003% # ( 6, 10 ] 949 0.764% 99.767% ( 10, 15 ] 125 0.101% 99.868% ( 15, 22 ] 11 0.009% 99.877% ( 22, 34 ] 2 0.002% 99.878% ( 34, 51 ] 1 0.001% 99.879% ( 51, 76 ] 3 0.002% 99.882% ( 76, 110 ] 59 0.048% 99.929% ( 110, 170 ] 44 0.035% 99.965% ( 170, 250 ] 8 0.006% 99.971% ( 250, 380 ] 17 0.014% 99.985% ( 380, 580 ] 5 0.004% 99.989% ( 580, 870 ] 9 0.007% 99.996% ( 870, 1300 ] 4 0.003% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 239453 Average: 3.1620 StdDev: 26.27 Min: 1 Median: 1.5719 Max: 3746 Percentiles: P50: 1.57 P75: 1.97 P99: 8.79 P99.9: 172.65 P99.99: 518.38 ------------------------------------------------------ [ 0, 1 ] 34607 14.453% 14.453% ### ( 1, 2 ] 148830 62.154% 76.607% ############ ( 2, 3 ] 29661 12.387% 88.994% ## ( 3, 4 ] 12203 5.096% 94.090% # ( 4, 6 ] 9223 3.852% 97.942% # ( 6, 10 ] 3636 1.518% 99.460% ( 10, 15 ] 586 0.245% 99.705% ( 15, 22 ] 84 0.035% 99.740% ( 22, 34 ] 24 0.010% 99.750% ( 34, 51 ] 3 0.001% 99.751% ( 51, 76 ] 6 0.003% 99.754% ( 76, 110 ] 104 0.043% 99.797% ( 110, 170 ] 243 0.101% 99.899% ( 170, 250 ] 107 0.045% 99.943% ( 250, 380 ] 74 0.031% 99.974% ( 380, 580 ] 55 0.023% 99.997% ( 580, 870 ] 38 0.016% 100.013% ( 870, 1300 ] 20 0.008% 100.021% ( 1300, 1900 ] 9 0.004% 100.025% ( 1900, 2900 ] 6 0.003% 100.028% ( 2900, 4400 ] 3 0.001% 100.029% ** Level 4 read latency histogram (micros): Count: 320 Average: 150.3750 StdDev: 553.48 Min: 1 Median: 1.7500 Max: 4388 Percentiles: P50: 1.75 P75: 7.71 P99: 3440.00 P99.9: 4304.00 P99.99: 4388.00 ------------------------------------------------------ [ 0, 1 ] 67 20.938% 20.938% #### ( 1, 2 ] 124 38.750% 59.688% ######## ( 2, 3 ] 34 10.625% 70.312% ## ( 3, 4 ] 3 0.938% 71.250% ( 4, 6 ] 6 1.875% 73.125% ( 6, 10 ] 14 4.375% 77.500% # ( 10, 15 ] 36 11.250% 88.750% ## ( 15, 22 ] 4 1.250% 90.000% ( 170, 250 ] 1 0.312% 90.312% ( 250, 380 ] 2 0.625% 90.938% ( 380, 580 ] 2 0.625% 91.562% ( 580, 870 ] 7 2.188% 93.750% ( 870, 1300 ] 6 1.875% 95.625% ( 1300, 1900 ] 7 2.188% 97.812% ( 1900, 2900 ] 2 0.625% 98.438% ( 2900, 4400 ] 5 1.562% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 831.7667 StdDev: 1026.63 Min: 91 Median: 380.0000 Max: 4712 Percentiles: P50: 380.00 P75: 1300.00 P99: 4712.00 P99.9: 4712.00 P99.99: 4712.00 ------------------------------------------------------ ( 76, 110 ] 5 8.333% 8.333% ## ( 110, 170 ] 10 16.667% 25.000% ### ( 170, 250 ] 5 8.333% 33.333% ## ( 250, 380 ] 10 16.667% 50.000% ### ( 380, 580 ] 10 16.667% 66.667% ### ( 580, 870 ] 3 5.000% 71.667% # ( 870, 1300 ] 2 3.333% 75.000% # ( 1300, 1900 ] 6 10.000% 85.000% ## ( 1900, 2900 ] 5 8.333% 93.333% ## ( 2900, 4400 ] 3 5.000% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 23.6 total, 5.2 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 292.00 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:4.805 H:M:S, 20.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 187.48 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.517 H:M:S, 48.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/25-17:19:30 ... thread 0: (1000000,8000000) ops and (45043.4,175440.5) ops/second in (22.200801,45.599503) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 7/7 2.08 GB 0.0 6.9 0.0 6.9 14.4 7.6 0.0 1.9 141.4 296.5 49.87 45.70 132 0.378 7162K 13K 0.0 0.0 L1 14/14 1.32 GB 0.0 7.0 5.2 1.8 6.9 5.1 0.2 1.3 222.9 219.8 32.09 30.03 4 8.022 7261K 98K 0.0 0.0 L2 1/1 128.78 MB 0.0 0.4 0.2 0.2 0.4 0.2 3.9 2.0 251.5 251.3 1.50 1.45 2 0.752 383K 181 0.0 0.0 L3 23/4 1.22 GB 1.0 6.6 3.6 3.0 6.6 3.6 0.4 1.8 155.6 154.8 43.41 30.04 26 1.670 6859K 35K 0.0 0.0 L4 178/2 9.67 GB 1.0 2.8 2.7 0.1 2.8 2.7 0.8 1.0 127.5 127.2 22.45 13.54 32 0.701 2843K 3126 0.0 0.0 L5 1084/0 89.14 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1307/28 103.55 GB 0.0 23.6 11.7 11.9 31.0 19.1 8.6 4.1 162.1 212.9 149.32 120.76 196 0.762 24M 150K 0.0 0.0 Int 0/0 0.00 KB 0.0 23.6 11.7 11.9 31.0 19.1 8.5 4.1 162.1 212.9 149.32 120.76 196 0.762 24M 150K 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 23.6 11.7 11.9 23.5 11.5 0.0 0.0 191.9 190.6 126.13 100.98 86 1.467 24M 150K 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 334.1 23.19 19.78 110 0.211 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 45.8 total, 45.6 interval Flush(GB): cumulative 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: 31.05 GB write, 694.27 MB/s write, 23.63 GB read, 528.43 MB/s read, 149.3 seconds Interval compaction: 31.05 GB write, 697.21 MB/s write, 23.63 GB read, 530.67 MB/s read, 149.3 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: 35, pending-compaction-bytes-delays: 36, pending-compaction-bytes-stops: 0, total-delays: 51, total-stops: 35, interval: 86 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3471371 Average: 2.9524 StdDev: 35.18 Min: 0 Median: 1.4821 Max: 10410 Percentiles: P50: 1.48 P75: 1.87 P99: 7.63 P99.9: 145.38 P99.99: 393.44 ------------------------------------------------------ [ 0, 1 ] 666088 19.188% 19.188% #### ( 1, 2 ] 2218634 63.912% 83.100% ############# ( 2, 3 ] 296243 8.534% 91.634% ## ( 3, 4 ] 137141 3.951% 95.585% # ( 4, 6 ] 105986 3.053% 98.638% # ( 6, 10 ] 30869 0.889% 99.527% ( 10, 15 ] 5629 0.162% 99.689% ( 15, 22 ] 714 0.021% 99.710% ( 22, 34 ] 75 0.002% 99.712% ( 34, 51 ] 32 0.001% 99.713% ( 51, 76 ] 63 0.002% 99.715% ( 76, 110 ] 4071 0.117% 99.832% ( 110, 170 ] 3996 0.115% 99.947% ( 170, 250 ] 805 0.023% 99.970% ( 250, 380 ] 646 0.019% 99.989% ( 380, 580 ] 504 0.015% 100.004% ( 580, 870 ] 267 0.008% 100.011% ( 870, 1300 ] 127 0.004% 100.015% ( 1300, 1900 ] 72 0.002% 100.017% ( 1900, 2900 ] 86 0.002% 100.020% ( 2900, 4400 ] 117 0.003% 100.023% ( 4400, 6600 ] 25 0.001% 100.024% ( 6600, 9900 ] 12 0.000% 100.024% ( 9900, 14000 ] 1 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 1429625 Average: 6.1888 StdDev: 98.03 Min: 0 Median: 1.7367 Max: 10167 Percentiles: P50: 1.74 P75: 2.70 P99: 9.64 P99.9: 134.27 P99.99: 435.13 ------------------------------------------------------ [ 0, 1 ] 145326 10.165% 10.165% ## ( 1, 2 ] 773006 54.071% 64.236% ########### ( 2, 3 ] 219586 15.360% 79.596% ### ( 3, 4 ] 121741 8.516% 88.111% ## ( 4, 6 ] 126777 8.868% 96.979% ## ( 6, 10 ] 31779 2.223% 99.202% ( 10, 15 ] 7631 0.534% 99.736% ( 15, 22 ] 976 0.068% 99.804% ( 22, 34 ] 65 0.005% 99.808% ( 34, 51 ] 43 0.003% 99.811% ( 51, 76 ] 85 0.006% 99.817% ( 76, 110 ] 823 0.058% 99.875% ( 110, 170 ] 886 0.062% 99.937% ( 170, 250 ] 255 0.018% 99.955% ( 250, 380 ] 364 0.025% 99.980% ( 380, 580 ] 508 0.036% 100.016% ( 580, 870 ] 572 0.040% 100.056% ( 870, 1300 ] 459 0.032% 100.088% ( 1300, 1900 ] 245 0.017% 100.105% ( 1900, 2900 ] 296 0.021% 100.126% ( 2900, 4400 ] 428 0.030% 100.156% ( 4400, 6600 ] 140 0.010% 100.165% ( 6600, 9900 ] 23 0.002% 100.167% ( 9900, 14000 ] 1 0.000% 100.167% ** Level 2 read latency histogram (micros): Count: 124192 Average: 2.3153 StdDev: 12.15 Min: 1 Median: 1.4210 Max: 2057 Percentiles: P50: 1.42 P75: 1.83 P99: 6.00 P99.9: 89.14 P99.99: 630.94 ------------------------------------------------------ [ 0, 1 ] 30233 24.344% 24.344% ##### ( 1, 2 ] 75693 60.948% 85.292% ############ ( 2, 3 ] 9120 7.343% 92.636% # ( 3, 4 ] 4709 3.792% 96.427% # ( 4, 6 ] 3199 2.576% 99.003% # ( 6, 10 ] 949 0.764% 99.767% ( 10, 15 ] 125 0.101% 99.868% ( 15, 22 ] 11 0.009% 99.877% ( 22, 34 ] 2 0.002% 99.878% ( 34, 51 ] 1 0.001% 99.879% ( 51, 76 ] 3 0.002% 99.882% ( 76, 110 ] 59 0.048% 99.929% ( 110, 170 ] 44 0.035% 99.965% ( 170, 250 ] 8 0.006% 99.971% ( 250, 380 ] 17 0.014% 99.985% ( 380, 580 ] 5 0.004% 99.989% ( 580, 870 ] 9 0.007% 99.996% ( 870, 1300 ] 4 0.003% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1408567 Average: 6.6393 StdDev: 104.11 Min: 1 Median: 1.9215 Max: 15065 Percentiles: P50: 1.92 P75: 3.08 P99: 9.51 P99.9: 19.34 P99.99: 219.75 ------------------------------------------------------ [ 0, 1 ] 57779 4.102% 4.102% # ( 1, 2 ] 701549 49.806% 53.908% ########## ( 2, 3 ] 284283 20.182% 74.090% #### ( 3, 4 ] 156114 11.083% 85.173% ## ( 4, 6 ] 166631 11.830% 97.003% ## ( 6, 10 ] 32060 2.276% 99.279% ( 10, 15 ] 8192 0.582% 99.861% ( 15, 22 ] 891 0.063% 99.924% ( 22, 34 ] 91 0.006% 99.931% ( 34, 51 ] 40 0.003% 99.933% ( 51, 76 ] 56 0.004% 99.937% ( 76, 110 ] 153 0.011% 99.948% ( 110, 170 ] 341 0.024% 99.973% ( 170, 250 ] 399 0.028% 100.001% ( 250, 380 ] 525 0.037% 100.038% ( 380, 580 ] 629 0.045% 100.083% ( 580, 870 ] 714 0.051% 100.133% ( 870, 1300 ] 556 0.039% 100.173% ( 1300, 1900 ] 332 0.024% 100.197% ( 1900, 2900 ] 281 0.020% 100.216% ( 2900, 4400 ] 362 0.026% 100.242% ( 4400, 6600 ] 114 0.008% 100.250% ( 6600, 9900 ] 50 0.004% 100.254% ( 9900, 14000 ] 6 0.000% 100.254% ( 14000, 22000 ] 3 0.000% 100.254% ** Level 4 read latency histogram (micros): Count: 33125 Average: 91.0775 StdDev: 474.91 Min: 1 Median: 2.0199 Max: 19832 Percentiles: P50: 2.02 P75: 3.40 P99: 2470.81 P99.9: 5696.43 P99.99: 9059.13 ------------------------------------------------------ [ 0, 1 ] 1193 3.602% 3.602% # ( 1, 2 ] 15234 45.989% 49.591% ######### ( 2, 3 ] 6824 20.601% 70.192% #### ( 3, 4 ] 3940 11.894% 82.086% ## ( 4, 6 ] 2687 8.112% 90.198% ## ( 6, 10 ] 684 2.065% 92.263% ( 10, 15 ] 276 0.833% 93.096% ( 15, 22 ] 29 0.088% 93.183% ( 22, 34 ] 14 0.042% 93.226% ( 34, 51 ] 2 0.006% 93.232% ( 51, 76 ] 10 0.030% 93.262% ( 76, 110 ] 11 0.033% 93.295% ( 110, 170 ] 28 0.085% 93.380% ( 170, 250 ] 93 0.281% 93.660% ( 250, 380 ] 176 0.531% 94.192% ( 380, 580 ] 343 1.035% 95.227% ( 580, 870 ] 494 1.491% 96.718% ( 870, 1300 ] 417 1.259% 97.977% ( 1300, 1900 ] 240 0.725% 98.702% ( 1900, 2900 ] 173 0.522% 99.224% ( 2900, 4400 ] 195 0.589% 99.813% ( 4400, 6600 ] 49 0.148% 99.961% ( 6600, 9900 ] 13 0.039% 100.000% ( 9900, 14000 ] 2 0.006% 100.006% ( 14000, 22000 ] 2 0.006% 100.012% ** Level 5 read latency histogram (micros): Count: 200 Average: 1439.8350 StdDev: 1734.76 Min: 91 Median: 655.6522 Max: 9103 Percentiles: P50: 655.65 P75: 2076.47 P99: 8250.00 P99.9: 9103.00 P99.99: 9103.00 ------------------------------------------------------ ( 76, 110 ] 5 2.500% 2.500% # ( 110, 170 ] 14 7.000% 9.500% # ( 170, 250 ] 13 6.500% 16.000% # ( 250, 380 ] 34 17.000% 33.000% ### ( 380, 580 ] 28 14.000% 47.000% ### ( 580, 870 ] 23 11.500% 58.500% ## ( 870, 1300 ] 15 7.500% 66.000% ## ( 1300, 1900 ] 15 7.500% 73.500% ## ( 1900, 2900 ] 17 8.500% 82.000% ## ( 2900, 4400 ] 21 10.500% 92.500% ## ( 4400, 6600 ] 11 5.500% 98.000% # ( 6600, 9900 ] 4 2.000% 100.000% ** DB Stats ** Uptime(secs): 45.8 total, 22.2 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 171.93 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:23.463 H:M:S, 51.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 44.33 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:18.658 H:M:S, 84.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 2024/07/25-17:19:33 ... thread 0: (1000000,9000000) ops and (323539.5,184841.7) ops/second in (3.090813,48.690316) 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/7 3.00 GB 94.4 7.8 0.0 7.8 16.3 8.5 0.0 1.9 141.1 296.6 56.23 51.61 149 0.377 8058K 14K 0.0 0.0 L1 14/14 1.32 GB 0.0 7.0 5.2 1.8 6.9 5.1 0.2 1.3 222.9 219.8 32.09 30.03 4 8.022 7261K 98K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 3.9 2.0 251.5 251.3 1.50 1.45 2 0.752 383K 181 0.0 0.0 L3 18/0 961.68 MB 1.0 6.8 3.7 3.1 6.8 3.7 0.4 1.8 156.0 155.2 44.84 31.16 27 1.661 7104K 36K 0.0 0.0 L4 180/0 9.76 GB 1.0 3.2 3.1 0.1 3.2 3.1 0.8 1.0 132.6 132.3 24.74 15.45 37 0.669 3254K 3355 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 1311/21 104.47 GB 0.0 25.1 12.2 12.9 33.5 20.6 9.0 3.9 161.5 215.4 159.40 129.71 219 0.728 26M 153K 0.0 0.0 Int 0/0 0.00 KB 0.0 25.1 12.2 12.9 33.5 20.6 8.9 3.9 161.5 215.4 159.40 129.71 219 0.728 26M 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 25.1 12.2 12.9 25.0 12.1 0.0 0.0 193.1 192.0 133.28 107.35 95 1.403 26M 153K 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 335.3 26.12 22.36 124 0.211 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): 48.9 total, 48.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: 33.54 GB write, 702.48 MB/s write, 25.14 GB read, 526.58 MB/s read, 159.4 seconds Interval compaction: 33.54 GB write, 705.27 MB/s write, 25.14 GB read, 528.67 MB/s read, 159.4 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: 40, pending-compaction-bytes-delays: 36, pending-compaction-bytes-stops: 0, total-delays: 51, total-stops: 40, interval: 91 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3821554 Average: 2.9015 StdDev: 33.64 Min: 0 Median: 1.4908 Max: 10410 Percentiles: P50: 1.49 P75: 1.88 P99: 7.53 P99.9: 139.09 P99.99: 359.03 ------------------------------------------------------ [ 0, 1 ] 709346 18.562% 18.562% #### ( 1, 2 ] 2447727 64.051% 82.612% ############# ( 2, 3 ] 338424 8.856% 91.468% ## ( 3, 4 ] 154964 4.055% 95.523% # ( 4, 6 ] 119721 3.133% 98.656% # ( 6, 10 ] 34295 0.897% 99.553% ( 10, 15 ] 6287 0.165% 99.718% ( 15, 22 ] 770 0.020% 99.738% ( 22, 34 ] 76 0.002% 99.740% ( 34, 51 ] 34 0.001% 99.741% ( 51, 76 ] 65 0.002% 99.742% ( 76, 110 ] 4077 0.107% 99.849% ( 110, 170 ] 4014 0.105% 99.954% ( 170, 250 ] 820 0.021% 99.976% ( 250, 380 ] 658 0.017% 99.993% ( 380, 580 ] 512 0.013% 100.006% ( 580, 870 ] 275 0.007% 100.013% ( 870, 1300 ] 133 0.003% 100.017% ( 1300, 1900 ] 75 0.002% 100.019% ( 1900, 2900 ] 87 0.002% 100.021% ( 2900, 4400 ] 117 0.003% 100.024% ( 4400, 6600 ] 25 0.001% 100.025% ( 6600, 9900 ] 12 0.000% 100.025% ( 9900, 14000 ] 1 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 1514966 Average: 5.9942 StdDev: 95.27 Min: 0 Median: 1.7243 Max: 10167 Percentiles: P50: 1.72 P75: 2.65 P99: 9.59 P99.9: 135.54 P99.99: 438.16 ------------------------------------------------------ [ 0, 1 ] 154554 10.202% 10.202% ## ( 1, 2 ] 832445 54.948% 65.150% ########### ( 2, 3 ] 228567 15.087% 80.237% ### ( 3, 4 ] 125222 8.266% 88.503% ## ( 4, 6 ] 129201 8.528% 97.031% ## ( 6, 10 ] 33217 2.193% 99.224% ( 10, 15 ] 7774 0.513% 99.737% ( 15, 22 ] 985 0.065% 99.802% ( 22, 34 ] 65 0.004% 99.806% ( 34, 51 ] 43 0.003% 99.809% ( 51, 76 ] 85 0.006% 99.815% ( 76, 110 ] 887 0.059% 99.873% ( 110, 170 ] 954 0.063% 99.936% ( 170, 250 ] 284 0.019% 99.955% ( 250, 380 ] 380 0.025% 99.980% ( 380, 580 ] 521 0.034% 100.014% ( 580, 870 ] 577 0.038% 100.052% ( 870, 1300 ] 461 0.030% 100.083% ( 1300, 1900 ] 245 0.016% 100.099% ( 1900, 2900 ] 296 0.020% 100.119% ( 2900, 4400 ] 428 0.028% 100.147% ( 4400, 6600 ] 140 0.009% 100.156% ( 6600, 9900 ] 23 0.002% 100.158% ( 9900, 14000 ] 1 0.000% 100.158% ** Level 2 read latency histogram (micros): Count: 124192 Average: 2.3153 StdDev: 12.15 Min: 1 Median: 1.4210 Max: 2057 Percentiles: P50: 1.42 P75: 1.83 P99: 6.00 P99.9: 89.14 P99.99: 630.94 ------------------------------------------------------ [ 0, 1 ] 30233 24.344% 24.344% ##### ( 1, 2 ] 75693 60.948% 85.292% ############ ( 2, 3 ] 9120 7.343% 92.636% # ( 3, 4 ] 4709 3.792% 96.427% # ( 4, 6 ] 3199 2.576% 99.003% # ( 6, 10 ] 949 0.764% 99.767% ( 10, 15 ] 125 0.101% 99.868% ( 15, 22 ] 11 0.009% 99.877% ( 22, 34 ] 2 0.002% 99.878% ( 34, 51 ] 1 0.001% 99.879% ( 51, 76 ] 3 0.002% 99.882% ( 76, 110 ] 59 0.048% 99.929% ( 110, 170 ] 44 0.035% 99.965% ( 170, 250 ] 8 0.006% 99.971% ( 250, 380 ] 17 0.014% 99.985% ( 380, 580 ] 5 0.004% 99.989% ( 580, 870 ] 9 0.007% 99.996% ( 870, 1300 ] 4 0.003% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1483269 Average: 6.4501 StdDev: 101.46 Min: 1 Median: 1.9190 Max: 15065 Percentiles: P50: 1.92 P75: 3.06 P99: 9.46 P99.9: 18.30 P99.99: 203.52 ------------------------------------------------------ [ 0, 1 ] 59611 4.019% 4.019% # ( 1, 2 ] 742160 50.035% 54.054% ########## ( 2, 3 ] 300623 20.268% 74.322% #### ( 3, 4 ] 163635 11.032% 85.354% ## ( 4, 6 ] 173597 11.704% 97.058% ## ( 6, 10 ] 33333 2.247% 99.305% ( 10, 15 ] 8396 0.566% 99.871% ( 15, 22 ] 915 0.062% 99.933% ( 22, 34 ] 91 0.006% 99.939% ( 34, 51 ] 40 0.003% 99.941% ( 51, 76 ] 56 0.004% 99.945% ( 76, 110 ] 153 0.010% 99.956% ( 110, 170 ] 341 0.023% 99.979% ( 170, 250 ] 405 0.027% 100.006% ( 250, 380 ] 527 0.036% 100.041% ( 380, 580 ] 632 0.043% 100.084% ( 580, 870 ] 715 0.048% 100.132% ( 870, 1300 ] 556 0.037% 100.170% ( 1300, 1900 ] 332 0.022% 100.192% ( 1900, 2900 ] 281 0.019% 100.211% ( 2900, 4400 ] 362 0.024% 100.235% ( 4400, 6600 ] 114 0.008% 100.243% ( 6600, 9900 ] 50 0.003% 100.246% ( 9900, 14000 ] 6 0.000% 100.247% ( 14000, 22000 ] 3 0.000% 100.247% ** Level 4 read latency histogram (micros): Count: 36340 Average: 85.0857 StdDev: 454.81 Min: 1 Median: 1.9972 Max: 19832 Percentiles: P50: 2.00 P75: 3.37 P99: 2284.97 P99.9: 5552.08 P99.99: 8977.52 ------------------------------------------------------ [ 0, 1 ] 1327 3.652% 3.652% # ( 1, 2 ] 16890 46.478% 50.129% ######### ( 2, 3 ] 7484 20.594% 70.724% #### ( 3, 4 ] 4209 11.582% 82.306% ## ( 4, 6 ] 2894 7.964% 90.270% ## ( 6, 10 ] 742 2.042% 92.312% ( 10, 15 ] 298 0.820% 93.132% ( 15, 22 ] 30 0.083% 93.214% ( 22, 34 ] 15 0.041% 93.255% ( 34, 51 ] 3 0.008% 93.264% ( 51, 76 ] 13 0.036% 93.299% ( 76, 110 ] 19 0.052% 93.352% ( 110, 170 ] 77 0.212% 93.564% ( 170, 250 ] 147 0.405% 93.968% ( 250, 380 ] 214 0.589% 94.557% ( 380, 580 ] 367 1.010% 95.567% ( 580, 870 ] 516 1.420% 96.987% ( 870, 1300 ] 423 1.164% 98.151% ( 1300, 1900 ] 242 0.666% 98.817% ( 1900, 2900 ] 173 0.476% 99.293% ( 2900, 4400 ] 195 0.537% 99.829% ( 4400, 6600 ] 49 0.135% 99.964% ( 6600, 9900 ] 13 0.036% 100.000% ( 9900, 14000 ] 2 0.006% 100.006% ( 14000, 22000 ] 2 0.006% 100.011% ** Level 5 read latency histogram (micros): Count: 220 Average: 1388.6273 StdDev: 1698.96 Min: 79 Median: 614.8000 Max: 9103 Percentiles: P50: 614.80 P75: 2005.26 P99: 8085.00 P99.9: 9103.00 P99.99: 9103.00 ------------------------------------------------------ ( 76, 110 ] 8 3.636% 3.636% # ( 110, 170 ] 20 9.091% 12.727% ## ( 170, 250 ] 15 6.818% 19.545% # ( 250, 380 ] 35 15.909% 35.455% ### ( 380, 580 ] 29 13.182% 48.636% ### ( 580, 870 ] 25 11.364% 60.000% ## ( 870, 1300 ] 15 6.818% 66.818% # ( 1300, 1900 ] 16 7.273% 74.091% # ( 1900, 2900 ] 19 8.636% 82.727% ## ( 2900, 4400 ] 23 10.455% 93.182% ## ( 4400, 6600 ] 11 5.000% 98.182% # ( 6600, 9900 ] 4 1.818% 100.000% ** DB Stats ** Uptime(secs): 48.9 total, 3.1 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 181.19 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:23.898 H:M:S, 48.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 318.43 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.435 H:M:S, 14.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/25-17:19:36 ... thread 0: (1000000,10000000) ops and (325771.9,193199.6) ops/second in (3.069632,51.759948) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/7 3.99 GB 195.1 8.6 0.0 8.6 18.0 9.5 0.0 1.9 141.1 297.3 62.04 57.07 165 0.376 8889K 15K 0.0 0.0 L1 14/14 1.32 GB 0.0 7.0 5.2 1.8 6.9 5.1 0.2 1.3 222.9 219.8 32.09 30.03 4 8.022 7261K 98K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 3.9 2.0 251.5 251.3 1.50 1.45 2 0.752 383K 181 0.0 0.0 L3 18/0 961.68 MB 1.0 6.8 3.7 3.1 6.8 3.7 0.4 1.8 156.0 155.2 44.84 31.16 27 1.661 7104K 36K 0.0 0.0 L4 180/0 9.76 GB 1.0 3.2 3.1 0.1 3.2 3.1 0.8 1.0 132.6 132.3 24.74 15.45 37 0.669 3254K 3355 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 1316/21 105.46 GB 0.0 25.9 12.2 13.7 35.3 21.5 9.0 3.7 160.8 218.5 165.21 135.17 235 0.703 26M 153K 0.0 0.0 Int 0/0 0.00 KB 0.0 25.9 12.2 13.7 35.3 21.5 8.9 3.7 160.8 218.5 165.21 135.17 235 0.703 26M 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 25.9 12.2 13.7 25.8 12.1 0.0 0.0 194.8 193.6 136.36 110.37 98 1.391 26M 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 336.3 28.85 24.80 137 0.211 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 52.0 total, 51.8 interval Flush(GB): cumulative 9.474, interval 9.474 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 35.26 GB write, 694.91 MB/s write, 25.94 GB read, 511.23 MB/s read, 165.2 seconds Interval compaction: 35.26 GB write, 697.51 MB/s write, 25.94 GB read, 513.14 MB/s read, 165.2 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: 44, pending-compaction-bytes-delays: 36, pending-compaction-bytes-stops: 0, total-delays: 51, total-stops: 44, interval: 95 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4084689 Average: 2.8603 StdDev: 32.66 Min: 0 Median: 1.4908 Max: 10410 Percentiles: P50: 1.49 P75: 1.88 P99: 7.38 P99.9: 135.84 P99.99: 350.62 ------------------------------------------------------ [ 0, 1 ] 752842 18.431% 18.431% #### ( 1, 2 ] 2627600 64.328% 82.759% ############# ( 2, 3 ] 361233 8.844% 91.602% ## ( 3, 4 ] 164854 4.036% 95.638% # ( 4, 6 ] 124954 3.059% 98.697% # ( 6, 10 ] 35769 0.876% 99.573% ( 10, 15 ] 6550 0.160% 99.733% ( 15, 22 ] 785 0.019% 99.753% ( 22, 34 ] 76 0.002% 99.755% ( 34, 51 ] 35 0.001% 99.755% ( 51, 76 ] 68 0.002% 99.757% ( 76, 110 ] 4095 0.100% 99.857% ( 110, 170 ] 4050 0.099% 99.956% ( 170, 250 ] 845 0.021% 99.977% ( 250, 380 ] 679 0.017% 99.994% ( 380, 580 ] 526 0.013% 100.007% ( 580, 870 ] 287 0.007% 100.014% ( 870, 1300 ] 135 0.003% 100.017% ( 1300, 1900 ] 76 0.002% 100.019% ( 1900, 2900 ] 88 0.002% 100.021% ( 2900, 4400 ] 118 0.003% 100.024% ( 4400, 6600 ] 25 0.001% 100.025% ( 6600, 9900 ] 12 0.000% 100.025% ( 9900, 14000 ] 1 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 1648691 Average: 5.7194 StdDev: 91.40 Min: 0 Median: 1.7026 Max: 10167 Percentiles: P50: 1.70 P75: 2.57 P99: 9.52 P99.9: 137.53 P99.99: 442.57 ------------------------------------------------------ [ 0, 1 ] 174115 10.561% 10.561% ## ( 1, 2 ] 925497 56.135% 66.696% ########### ( 2, 3 ] 239993 14.557% 81.253% ### ( 3, 4 ] 129537 7.857% 89.110% ## ( 4, 6 ] 131934 8.002% 97.112% ## ( 6, 10 ] 35396 2.147% 99.259% ( 10, 15 ] 7955 0.483% 99.741% ( 15, 22 ] 994 0.060% 99.802% ( 22, 34 ] 65 0.004% 99.806% ( 34, 51 ] 44 0.003% 99.808% ( 51, 76 ] 88 0.005% 99.814% ( 76, 110 ] 943 0.057% 99.871% ( 110, 170 ] 1049 0.064% 99.934% ( 170, 250 ] 333 0.020% 99.955% ( 250, 380 ] 412 0.025% 99.980% ( 380, 580 ] 547 0.033% 100.013% ( 580, 870 ] 581 0.035% 100.048% ( 870, 1300 ] 464 0.028% 100.076% ( 1300, 1900 ] 245 0.015% 100.091% ( 1900, 2900 ] 296 0.018% 100.109% ( 2900, 4400 ] 428 0.026% 100.135% ( 4400, 6600 ] 140 0.008% 100.143% ( 6600, 9900 ] 23 0.001% 100.145% ( 9900, 14000 ] 1 0.000% 100.145% ** Level 2 read latency histogram (micros): Count: 124192 Average: 2.3153 StdDev: 12.15 Min: 1 Median: 1.4210 Max: 2057 Percentiles: P50: 1.42 P75: 1.83 P99: 6.00 P99.9: 89.14 P99.99: 630.94 ------------------------------------------------------ [ 0, 1 ] 30233 24.344% 24.344% ##### ( 1, 2 ] 75693 60.948% 85.292% ############ ( 2, 3 ] 9120 7.343% 92.636% # ( 3, 4 ] 4709 3.792% 96.427% # ( 4, 6 ] 3199 2.576% 99.003% # ( 6, 10 ] 949 0.764% 99.767% ( 10, 15 ] 125 0.101% 99.868% ( 15, 22 ] 11 0.009% 99.877% ( 22, 34 ] 2 0.002% 99.878% ( 34, 51 ] 1 0.001% 99.879% ( 51, 76 ] 3 0.002% 99.882% ( 76, 110 ] 59 0.048% 99.929% ( 110, 170 ] 44 0.035% 99.965% ( 170, 250 ] 8 0.006% 99.971% ( 250, 380 ] 17 0.014% 99.985% ( 380, 580 ] 5 0.004% 99.989% ( 580, 870 ] 9 0.007% 99.996% ( 870, 1300 ] 4 0.003% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1483269 Average: 6.4501 StdDev: 101.46 Min: 1 Median: 1.9190 Max: 15065 Percentiles: P50: 1.92 P75: 3.06 P99: 9.46 P99.9: 18.30 P99.99: 203.52 ------------------------------------------------------ [ 0, 1 ] 59611 4.019% 4.019% # ( 1, 2 ] 742160 50.035% 54.054% ########## ( 2, 3 ] 300623 20.268% 74.322% #### ( 3, 4 ] 163635 11.032% 85.354% ## ( 4, 6 ] 173597 11.704% 97.058% ## ( 6, 10 ] 33333 2.247% 99.305% ( 10, 15 ] 8396 0.566% 99.871% ( 15, 22 ] 915 0.062% 99.933% ( 22, 34 ] 91 0.006% 99.939% ( 34, 51 ] 40 0.003% 99.941% ( 51, 76 ] 56 0.004% 99.945% ( 76, 110 ] 153 0.010% 99.956% ( 110, 170 ] 341 0.023% 99.979% ( 170, 250 ] 405 0.027% 100.006% ( 250, 380 ] 527 0.036% 100.041% ( 380, 580 ] 632 0.043% 100.084% ( 580, 870 ] 715 0.048% 100.132% ( 870, 1300 ] 556 0.037% 100.170% ( 1300, 1900 ] 332 0.022% 100.192% ( 1900, 2900 ] 281 0.019% 100.211% ( 2900, 4400 ] 362 0.024% 100.235% ( 4400, 6600 ] 114 0.008% 100.243% ( 6600, 9900 ] 50 0.003% 100.246% ( 9900, 14000 ] 6 0.000% 100.247% ( 14000, 22000 ] 3 0.000% 100.247% ** Level 4 read latency histogram (micros): Count: 36340 Average: 85.0857 StdDev: 454.81 Min: 1 Median: 1.9972 Max: 19832 Percentiles: P50: 2.00 P75: 3.37 P99: 2284.97 P99.9: 5552.08 P99.99: 8977.52 ------------------------------------------------------ [ 0, 1 ] 1327 3.652% 3.652% # ( 1, 2 ] 16890 46.478% 50.129% ######### ( 2, 3 ] 7484 20.594% 70.724% #### ( 3, 4 ] 4209 11.582% 82.306% ## ( 4, 6 ] 2894 7.964% 90.270% ## ( 6, 10 ] 742 2.042% 92.312% ( 10, 15 ] 298 0.820% 93.132% ( 15, 22 ] 30 0.083% 93.214% ( 22, 34 ] 15 0.041% 93.255% ( 34, 51 ] 3 0.008% 93.264% ( 51, 76 ] 13 0.036% 93.299% ( 76, 110 ] 19 0.052% 93.352% ( 110, 170 ] 77 0.212% 93.564% ( 170, 250 ] 147 0.405% 93.968% ( 250, 380 ] 214 0.589% 94.557% ( 380, 580 ] 367 1.010% 95.567% ( 580, 870 ] 516 1.420% 96.987% ( 870, 1300 ] 423 1.164% 98.151% ( 1300, 1900 ] 242 0.666% 98.817% ( 1900, 2900 ] 173 0.476% 99.293% ( 2900, 4400 ] 195 0.537% 99.829% ( 4400, 6600 ] 49 0.135% 99.964% ( 6600, 9900 ] 13 0.036% 100.000% ( 9900, 14000 ] 2 0.006% 100.006% ( 14000, 22000 ] 2 0.006% 100.011% ** Level 5 read latency histogram (micros): Count: 220 Average: 1388.6273 StdDev: 1698.96 Min: 79 Median: 614.8000 Max: 9103 Percentiles: P50: 614.80 P75: 2005.26 P99: 8085.00 P99.9: 9103.00 P99.99: 9103.00 ------------------------------------------------------ ( 76, 110 ] 8 3.636% 3.636% # ( 110, 170 ] 20 9.091% 12.727% ## ( 170, 250 ] 15 6.818% 19.545% # ( 250, 380 ] 35 15.909% 35.455% ### ( 380, 580 ] 29 13.182% 48.636% ### ( 580, 870 ] 25 11.364% 60.000% ## ( 870, 1300 ] 15 6.818% 66.818% # ( 1300, 1900 ] 16 7.273% 74.091% # ( 1900, 2900 ] 19 8.636% 82.727% ## ( 2900, 4400 ] 23 10.455% 93.182% ## ( 4400, 6600 ] 11 5.000% 98.182% # ( 6600, 9900 ] 4 1.818% 100.000% ** DB Stats ** Uptime(secs): 52.0 total, 3.1 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 189.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:24.352 H:M:S, 46.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.62 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.454 H:M:S, 14.8 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.508 micros/op 181547 ops/sec 60.001 seconds 10892999 operations; 175.9 MB/s Microseconds per write: Count: 10892999 Average: 5.5082 StdDev: 342.75 Min: 1 Median: 1.7530 Max: 718024 Percentiles: P50: 1.75 P75: 2.74 P99: 9.22 P99.9: 1108.07 P99.99: 2728.58 ------------------------------------------------------ [ 0, 1 ] 1352609 12.417% 12.417% ## ( 1, 2 ] 5436574 49.909% 62.326% ########## ( 2, 3 ] 1857434 17.052% 79.378% ### ( 3, 4 ] 1480532 13.592% 92.969% ### ( 4, 6 ] 548376 5.034% 98.004% # ( 6, 10 ] 134803 1.238% 99.241% ( 10, 15 ] 40617 0.373% 99.614% ( 15, 22 ] 9226 0.085% 99.699% ( 22, 34 ] 2076 0.019% 99.718% ( 34, 51 ] 207 0.002% 99.720% ( 51, 76 ] 38 0.000% 99.720% ( 76, 110 ] 7928 0.073% 99.793% ( 110, 170 ] 2674 0.025% 99.817% ( 170, 250 ] 304 0.003% 99.820% ( 250, 380 ] 179 0.002% 99.822% ( 380, 580 ] 39 0.000% 99.822% ( 580, 870 ] 33 0.000% 99.822% ( 870, 1300 ] 15275 0.140% 99.963% ( 1300, 1900 ] 205 0.002% 99.964% ( 1900, 2900 ] 3356 0.031% 99.995% ( 2900, 4400 ] 363 0.003% 99.999% ( 4400, 6600 ] 101 0.001% 100.000% ( 6600, 9900 ] 24 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 3 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 16 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 231142 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 : 10892999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 11241574968 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 : 688 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 30011201 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 : 38778534483 rocksdb.compact.write.bytes COUNT : 38535150706 rocksdb.flush.write.bytes COUNT : 11097548973 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 : 74 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 : 352 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 : 11008114688 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4326400 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 : 38886678075 rocksdb.non.last.level.read.count COUNT : 9395713 rocksdb.block.checksum.compute.count COUNT : 9394411 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.394290 P95 : 3.881203 P99 : 7.718890 P100 : 718019.000000 COUNT : 10892999 SUM : 54762671 rocksdb.compaction.times.micros P50 : 1003157.894737 P95 : 2814285.714286 P99 : 16720000.000000 P100 : 20715196.000000 COUNT : 132 SUM : 187043333 rocksdb.compaction.times.cpu_micros P50 : 895789.473684 P95 : 2300000.000000 P99 : 12656000.000000 P100 : 19035340.000000 COUNT : 132 SUM : 148286754 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 : 689.176471 P95 : 1236.764706 P99 : 11950.000000 P100 : 17889.000000 COUNT : 150 SUM : 141496 rocksdb.compaction.outfile.sync.micros P50 : 1331.578947 P95 : 94833.333333 P99 : 150200.000000 P100 : 165854.000000 COUNT : 462 SUM : 8550914 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 : 110.697674 P95 : 2456.250000 P99 : 4112.272727 P100 : 4460.000000 COUNT : 311 SUM : 137310 rocksdb.table.open.io.micros P50 : 1472.093023 P95 : 7040.000000 P99 : 12313.142857 P100 : 15013.000000 COUNT : 688 SUM : 1466816 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.701815 P95 : 8.537043 P99 : 12.777824 P100 : 19836.000000 COUNT : 9392925 SUM : 65959993 rocksdb.read.block.get.micros P50 : 438.108108 P95 : 3612.500000 P99 : 5917.120000 P100 : 9249.000000 COUNT : 1376 SUM : 1225262 rocksdb.write.raw.block.micros P50 : 0.515051 P95 : 0.978598 P99 : 2.964238 P100 : 27732.000000 COUNT : 12027250 SUM : 24209889 rocksdb.numfiles.in.singlecompaction P50 : 2.543478 P95 : 5.500000 P99 : 16.050000 P100 : 26.000000 COUNT : 185 SUM : 615 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.555494 P95 : 1137.654037 P99 : 2464.811715 P100 : 717839.000000 COUNT : 196114 SUM : 30030208 rocksdb.sst.read.micros P50 : 1.654522 P95 : 5.235642 P99 : 9.313663 P100 : 19832.000000 COUNT : 9396638 SUM : 46596638 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 : 10892999 SUM : 11241574968 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 : 212142.857143 P95 : 360882.352941 P99 : 546250.000000 P100 : 903336.000000 COUNT : 150 SUM : 31611487 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 : 443 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