[2024-11-17 19:21:58.418066] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 22.11.4 initialization... [2024-11-17 19:21:58.418211] [ 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_pid691245 ] Set seed to 1731867718414587 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-17 19:21:58.507847] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-17 19:21:58.547735] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-17 19:21:58.547784] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 691245' to capture a snapshot of events at runtime. [2024-11-17 19:21:58.547795] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid691245 for offline analysis/debug. [2024-11-17 19:21:58.547834] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sun Nov 17 19:22:02 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/17-19:22:05 ... thread 0: (1000000,1000000) ops and (354735.5,354735.5) ops/second in (2.819002,2.819002) 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 10/9 630.02 MB 6.3 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 346.8 2.36 2.12 12 0.197 0 0 0.0 0.0 L2 3/2 237.29 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.0 1.8 257.9 257.8 1.35 1.31 2 0.676 354K 175 0.0 0.0 L3 10/0 881.90 MB 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 L4 116/0 9.72 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 1036/0 85.51 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 1175/11 96.94 GB 0.0 0.3 0.2 0.2 1.1 1.0 0.0 1.4 93.9 314.4 3.71 3.43 14 0.265 354K 175 0.0 0.0 Int 0/0 0.00 KB 0.0 0.3 0.2 0.2 1.1 1.0 0.0 1.4 93.9 314.4 3.71 3.43 14 0.265 354K 175 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.3 0.2 0.2 0.3 0.2 0.0 0.0 257.9 257.8 1.35 1.31 2 0.676 354K 175 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 346.8 2.36 2.12 12 0.197 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 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.14 GB write, 383.54 MB/s write, 0.34 GB read, 114.61 MB/s read, 3.7 seconds Interval compaction: 1.14 GB write, 413.97 MB/s write, 0.34 GB read, 123.70 MB/s read, 3.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: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 124134 Average: 1.9932 StdDev: 16.76 Min: 0 Median: 1.2909 Max: 2964 Percentiles: P50: 1.29 P75: 1.73 P99: 5.27 P99.9: 9.89 P99.99: 21.68 ------------------------------------------------------ [ 0, 1 ] 41376 33.332% 33.332% ####### ( 1, 2 ] 71130 57.301% 90.633% ########### ( 2, 3 ] 6114 4.925% 95.558% # ( 3, 4 ] 3017 2.430% 97.988% ( 4, 6 ] 1976 1.592% 99.580% ( 6, 10 ] 409 0.329% 99.910% ( 10, 15 ] 92 0.074% 99.984% ( 15, 22 ] 9 0.007% 99.991% ( 22, 34 ] 4 0.003% 99.994% ( 34, 51 ] 1 0.001% 99.995% ( 110, 170 ] 9 0.007% 100.002% ( 170, 250 ] 3 0.002% 100.005% ( 250, 380 ] 3 0.002% 100.007% ( 380, 580 ] 2 0.002% 100.009% ( 870, 1300 ] 1 0.001% 100.010% ( 1300, 1900 ] 3 0.002% 100.012% ( 1900, 2900 ] 1 0.001% 100.013% ( 2900, 4400 ] 2 0.002% 100.015% ** Level 2 read latency histogram (micros): Count: 71699 Average: 2.0609 StdDev: 10.48 Min: 0 Median: 1.2883 Max: 1592 Percentiles: P50: 1.29 P75: 1.73 P99: 5.73 P99.9: 43.42 P99.99: 533.20 ------------------------------------------------------ [ 0, 1 ] 24067 33.567% 33.567% ####### ( 1, 2 ] 40876 57.011% 90.577% ########### ( 2, 3 ] 3387 4.724% 95.301% # ( 3, 4 ] 1707 2.381% 97.682% ( 4, 6 ] 1094 1.526% 99.208% ( 6, 10 ] 423 0.590% 99.798% ( 10, 15 ] 46 0.064% 99.862% ( 15, 22 ] 12 0.017% 99.879% ( 22, 34 ] 3 0.004% 99.883% ( 34, 51 ] 24 0.033% 99.916% ( 51, 76 ] 23 0.032% 99.948% ( 76, 110 ] 8 0.011% 99.960% ( 110, 170 ] 2 0.003% 99.962% ( 170, 250 ] 12 0.017% 99.979% ( 250, 380 ] 5 0.007% 99.986% ( 380, 580 ] 5 0.007% 99.993% ( 580, 870 ] 4 0.006% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ( 1300, 1900 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 50 Average: 1669.4800 StdDev: 1373.09 Min: 163 Median: 1366.6667 Max: 4967 Percentiles: P50: 1366.67 P75: 2462.50 P99: 4967.00 P99.9: 4967.00 P99.99: 4967.00 ------------------------------------------------------ ( 110, 170 ] 1 2.000% 2.000% ( 170, 250 ] 2 4.000% 6.000% # ( 250, 380 ] 3 6.000% 12.000% # ( 380, 580 ] 10 20.000% 32.000% #### ( 580, 870 ] 4 8.000% 40.000% ## ( 870, 1300 ] 4 8.000% 48.000% ## ( 1300, 1900 ] 9 18.000% 66.000% #### ( 1900, 2900 ] 8 16.000% 82.000% ### ( 2900, 4400 ] 5 10.000% 92.000% ## ( 4400, 6600 ] 4 8.000% 100.000% ## ** Level 4 read latency histogram (micros): Count: 25 Average: 1502.3200 StdDev: 1717.25 Min: 57 Median: 977.5000 Max: 6678 Percentiles: P50: 977.50 P75: 1870.00 P99: 6678.00 P99.9: 6678.00 P99.99: 6678.00 ------------------------------------------------------ ( 51, 76 ] 2 8.000% 8.000% ## ( 110, 170 ] 1 4.000% 12.000% # ( 170, 250 ] 2 8.000% 20.000% ## ( 250, 380 ] 2 8.000% 28.000% ## ( 380, 580 ] 2 8.000% 36.000% ## ( 580, 870 ] 3 12.000% 48.000% ## ( 870, 1300 ] 2 8.000% 56.000% ## ( 1300, 1900 ] 5 20.000% 76.000% #### ( 1900, 2900 ] 3 12.000% 88.000% ## ( 4400, 6600 ] 2 8.000% 96.000% ## ( 6600, 9900 ] 1 4.000% 100.000% # ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 323.23 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.231 H:M:S, 7.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 348.78 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.231 H:M:S, 8.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/17-19:22:08 ... thread 0: (1000000,2000000) ops and (326713.4,340148.3) ops/second in (3.060787,5.879789) 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 10/10 1.29 GB 0.0 0.8 0.0 0.8 2.6 1.8 0.0 1.4 97.3 314.2 8.42 7.78 29 0.290 831K 828 0.0 0.0 L1 1/1 2.92 MB 0.0 0.3 0.3 0.0 0.3 0.3 0.2 1.0 239.3 238.9 1.32 1.28 1 1.317 319K 399 0.0 0.0 L2 2/1 147.14 MB 1.0 0.3 0.2 0.2 0.3 0.2 0.3 1.8 257.9 257.8 1.35 1.31 2 0.676 354K 175 0.0 0.0 L3 19/10 1.09 GB 0.2 0.2 0.2 0.0 0.2 0.2 0.2 1.0 230.2 230.2 0.81 0.74 1 0.813 189K 0 0.0 0.0 L4 169/0 9.51 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 132.6 132.6 1.27 0.90 1 1.267 170K 0 0.0 0.0 L5 1040/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1241/22 97.92 GB 0.0 1.8 0.8 1.0 3.6 2.6 1.1 2.0 139.6 278.2 13.17 12.01 34 0.387 1866K 1402 0.0 0.0 Int 0/0 0.00 KB 0.0 1.8 0.8 1.0 3.6 2.6 1.1 2.0 139.6 278.2 13.17 12.01 34 0.387 1866K 1402 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.8 0.8 1.0 1.8 0.8 0.0 0.0 232.1 232.0 7.92 7.34 8 0.990 1866K 1402 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 348.0 5.25 4.67 26 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): 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.58 GB write, 600.03 MB/s write, 1.79 GB read, 301.04 MB/s read, 13.2 seconds Interval compaction: 3.58 GB write, 622.86 MB/s write, 1.79 GB read, 312.49 MB/s read, 13.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: 6, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 6, interval: 6 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 374411 Average: 2.1453 StdDev: 12.94 Min: 0 Median: 1.4373 Max: 2964 Percentiles: P50: 1.44 P75: 1.83 P99: 5.57 P99.9: 9.83 P99.99: 14.64 ------------------------------------------------------ [ 0, 1 ] 84046 22.448% 22.448% #### ( 1, 2 ] 235905 63.007% 85.454% ############# ( 2, 3 ] 29899 7.986% 93.440% ## ( 3, 4 ] 13887 3.709% 97.149% # ( 4, 6 ] 8836 2.360% 99.509% ( 6, 10 ] 1527 0.408% 99.917% ( 10, 15 ] 295 0.079% 99.996% ( 15, 22 ] 24 0.006% 100.002% ( 22, 34 ] 8 0.002% 100.004% ( 34, 51 ] 3 0.001% 100.005% ( 51, 76 ] 1 0.000% 100.005% ( 110, 170 ] 13 0.003% 100.009% ( 170, 250 ] 11 0.003% 100.012% ( 250, 380 ] 10 0.003% 100.014% ( 380, 580 ] 6 0.002% 100.016% ( 580, 870 ] 5 0.001% 100.017% ( 870, 1300 ] 4 0.001% 100.018% ( 1300, 1900 ] 4 0.001% 100.019% ( 1900, 2900 ] 4 0.001% 100.021% ( 2900, 4400 ] 2 0.001% 100.021% ** Level 1 read latency histogram (micros): Count: 21 Average: 204.4762 StdDev: 459.40 Min: 1 Median: 1.7500 Max: 2011 Percentiles: P50: 1.75 P75: 282.50 P99: 2011.00 P99.9: 2011.00 P99.99: 2011.00 ------------------------------------------------------ [ 0, 1 ] 6 28.571% 28.571% ###### ( 1, 2 ] 6 28.571% 57.143% ###### ( 2, 3 ] 2 9.524% 66.667% ## ( 6, 10 ] 1 4.762% 71.429% # ( 250, 380 ] 3 14.286% 85.714% ### ( 380, 580 ] 1 4.762% 90.476% # ( 870, 1300 ] 1 4.762% 95.238% # ( 1900, 2900 ] 1 4.762% 100.000% # ** Level 2 read latency histogram (micros): Count: 88429 Average: 2.0867 StdDev: 9.45 Min: 0 Median: 1.3372 Max: 1592 Percentiles: P50: 1.34 P75: 1.76 P99: 5.76 P99.9: 24.28 P99.99: 466.28 ------------------------------------------------------ [ 0, 1 ] 26766 30.268% 30.268% ###### ( 1, 2 ] 51742 58.512% 88.781% ############ ( 2, 3 ] 4954 5.602% 94.383% # ( 3, 4 ] 2629 2.973% 97.356% # ( 4, 6 ] 1655 1.872% 99.228% ( 6, 10 ] 518 0.586% 99.813% ( 10, 15 ] 61 0.069% 99.882% ( 15, 22 ] 15 0.017% 99.899% ( 22, 34 ] 3 0.003% 99.903% ( 34, 51 ] 24 0.027% 99.930% ( 51, 76 ] 24 0.027% 99.957% ( 76, 110 ] 8 0.009% 99.966% ( 110, 170 ] 2 0.002% 99.968% ( 170, 250 ] 12 0.014% 99.982% ( 250, 380 ] 5 0.006% 99.988% ( 380, 580 ] 5 0.006% 99.993% ( 580, 870 ] 4 0.005% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 190502 Average: 3.3126 StdDev: 37.76 Min: 0 Median: 1.5659 Max: 4967 Percentiles: P50: 1.57 P75: 1.98 P99: 8.95 P99.9: 194.58 P99.99: 619.50 ------------------------------------------------------ [ 0, 1 ] 29370 15.417% 15.417% ### ( 1, 2 ] 116414 61.109% 76.526% ############ ( 2, 3 ] 24967 13.106% 89.632% ### ( 3, 4 ] 8693 4.563% 94.195% # ( 4, 6 ] 6871 3.607% 97.802% # ( 6, 10 ] 3096 1.625% 99.427% ( 10, 15 ] 484 0.254% 99.681% ( 15, 22 ] 81 0.043% 99.724% ( 22, 34 ] 32 0.017% 99.741% ( 34, 51 ] 1 0.001% 99.741% ( 51, 76 ] 1 0.001% 99.742% ( 76, 110 ] 82 0.043% 99.785% ( 110, 170 ] 194 0.102% 99.887% ( 170, 250 ] 83 0.044% 99.930% ( 250, 380 ] 66 0.035% 99.965% ( 380, 580 ] 44 0.023% 99.988% ( 580, 870 ] 29 0.015% 100.003% ( 870, 1300 ] 5 0.003% 100.006% ( 1300, 1900 ] 11 0.006% 100.012% ( 1900, 2900 ] 8 0.004% 100.016% ( 2900, 4400 ] 5 0.003% 100.018% ( 4400, 6600 ] 4 0.002% 100.020% ** Level 4 read latency histogram (micros): Count: 310 Average: 127.0000 StdDev: 635.81 Min: 0 Median: 2.3226 Max: 6678 Percentiles: P50: 2.32 P75: 6.06 P99: 2866.67 P99.9: 6678.00 P99.99: 6678.00 ------------------------------------------------------ [ 0, 1 ] 45 14.516% 14.516% ### ( 1, 2 ] 90 29.032% 43.548% ###### ( 2, 3 ] 62 20.000% 63.548% #### ( 3, 4 ] 22 7.097% 70.645% # ( 4, 6 ] 13 4.194% 74.839% # ( 6, 10 ] 31 10.000% 84.839% ## ( 10, 15 ] 17 5.484% 90.323% # ( 15, 22 ] 1 0.323% 90.645% ( 51, 76 ] 2 0.645% 91.290% ( 110, 170 ] 3 0.968% 92.258% ( 170, 250 ] 3 0.968% 93.226% ( 250, 380 ] 3 0.968% 94.194% ( 380, 580 ] 2 0.645% 94.839% ( 580, 870 ] 3 0.968% 95.806% ( 870, 1300 ] 2 0.645% 96.452% ( 1300, 1900 ] 5 1.613% 98.065% ( 1900, 2900 ] 3 0.968% 99.032% ( 4400, 6600 ] 2 0.645% 99.677% ( 6600, 9900 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 930.7000 StdDev: 1131.59 Min: 131 Median: 347.5000 Max: 4594 Percentiles: P50: 347.50 P75: 1300.00 P99: 4594.00 P99.9: 4594.00 P99.99: 4594.00 ------------------------------------------------------ ( 110, 170 ] 5 25.000% 25.000% ##### ( 170, 250 ] 2 10.000% 35.000% ## ( 250, 380 ] 4 20.000% 55.000% #### ( 580, 870 ] 2 10.000% 65.000% ## ( 870, 1300 ] 2 10.000% 75.000% ## ( 1300, 1900 ] 3 15.000% 90.000% ### ( 2900, 4400 ] 1 5.000% 95.000% # ( 4400, 6600 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 6.1 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 322.38 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.624 H:M:S, 10.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.54 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.394 H:M:S, 12.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/17-19:22:11 ... thread 0: (1000000,3000000) ops and (327146.2,335700.9) ops/second in (3.056737,8.936526) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/14 2.27 GB 69.2 1.3 0.0 1.3 4.1 2.8 0.0 1.5 100.4 315.3 13.18 12.20 45 0.293 1343K 1306 0.0 0.0 L1 1/1 2.92 MB 0.0 0.3 0.3 0.0 0.3 0.3 0.2 1.0 239.3 238.9 1.32 1.28 1 1.317 319K 399 0.0 0.0 L2 1/0 96.95 MB 1.0 0.3 0.2 0.2 0.3 0.2 0.3 1.8 257.9 257.8 1.35 1.31 2 0.676 354K 175 0.0 0.0 L3 20/0 906.67 MB 0.9 1.1 0.2 0.9 1.1 0.2 0.2 4.7 242.6 242.2 4.61 4.24 2 2.307 1136K 1727 0.0 0.0 L4 169/0 9.46 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 132.6 132.6 1.27 0.90 1 1.267 170K 0 0.0 0.0 L5 1044/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1253/15 98.90 GB 0.0 3.2 0.9 2.3 6.0 3.7 1.6 2.2 150.7 280.9 21.73 19.93 51 0.426 3324K 3607 0.0 0.0 Int 0/0 0.00 KB 0.0 3.2 0.9 2.3 6.0 3.7 1.6 2.2 150.7 280.9 21.73 19.93 51 0.426 3324K 3607 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.2 0.9 2.3 3.2 0.9 0.0 0.0 239.8 239.5 13.65 12.74 11 1.241 3324K 3607 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 350.9 8.08 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, 8.9 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.96 GB write, 666.35 MB/s write, 3.20 GB read, 357.35 MB/s read, 21.7 seconds Interval compaction: 5.96 GB write, 683.03 MB/s write, 3.20 GB read, 366.29 MB/s read, 21.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: 10, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 10, interval: 10 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 761344 Average: 2.1880 StdDev: 10.44 Min: 0 Median: 1.4762 Max: 2964 Percentiles: P50: 1.48 P75: 1.86 P99: 5.61 P99.9: 9.88 P99.99: 14.58 ------------------------------------------------------ [ 0, 1 ] 143807 18.889% 18.889% #### ( 1, 2 ] 497383 65.330% 84.218% ############# ( 2, 3 ] 66735 8.765% 92.984% ## ( 3, 4 ] 30667 4.028% 97.012% # ( 4, 6 ] 18792 2.468% 99.480% ( 6, 10 ] 3303 0.434% 99.914% ( 10, 15 ] 639 0.084% 99.998% ( 15, 22 ] 53 0.007% 100.005% ( 22, 34 ] 14 0.002% 100.006% ( 34, 51 ] 5 0.001% 100.007% ( 51, 76 ] 3 0.000% 100.007% ( 76, 110 ] 21 0.003% 100.010% ( 110, 170 ] 48 0.006% 100.017% ( 170, 250 ] 39 0.005% 100.022% ( 250, 380 ] 22 0.003% 100.025% ( 380, 580 ] 15 0.002% 100.027% ( 580, 870 ] 12 0.002% 100.028% ( 870, 1300 ] 6 0.001% 100.029% ( 1300, 1900 ] 6 0.001% 100.030% ( 1900, 2900 ] 5 0.001% 100.030% ( 2900, 4400 ] 2 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 21 Average: 204.4762 StdDev: 459.40 Min: 1 Median: 1.7500 Max: 2011 Percentiles: P50: 1.75 P75: 282.50 P99: 2011.00 P99.9: 2011.00 P99.99: 2011.00 ------------------------------------------------------ [ 0, 1 ] 6 28.571% 28.571% ###### ( 1, 2 ] 6 28.571% 57.143% ###### ( 2, 3 ] 2 9.524% 66.667% ## ( 6, 10 ] 1 4.762% 71.429% # ( 250, 380 ] 3 14.286% 85.714% ### ( 380, 580 ] 1 4.762% 90.476% # ( 870, 1300 ] 1 4.762% 95.238% # ( 1900, 2900 ] 1 4.762% 100.000% # ** Level 2 read latency histogram (micros): Count: 100889 Average: 2.0986 StdDev: 8.86 Min: 0 Median: 1.3621 Max: 1592 Percentiles: P50: 1.36 P75: 1.78 P99: 5.75 P99.9: 17.10 P99.99: 416.44 ------------------------------------------------------ [ 0, 1 ] 28816 28.562% 28.562% ###### ( 1, 2 ] 59727 59.201% 87.763% ############ ( 2, 3 ] 6209 6.154% 93.917% # ( 3, 4 ] 3353 3.323% 97.241% # ( 4, 6 ] 2034 2.016% 99.257% ( 6, 10 ] 574 0.569% 99.826% ( 10, 15 ] 70 0.069% 99.895% ( 15, 22 ] 17 0.017% 99.912% ( 22, 34 ] 3 0.003% 99.915% ( 34, 51 ] 24 0.024% 99.939% ( 51, 76 ] 24 0.024% 99.962% ( 76, 110 ] 8 0.008% 99.970% ( 110, 170 ] 2 0.002% 99.972% ( 170, 250 ] 12 0.012% 99.984% ( 250, 380 ] 5 0.005% 99.989% ( 380, 580 ] 5 0.005% 99.994% ( 580, 870 ] 4 0.004% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 266673 Average: 3.2156 StdDev: 33.15 Min: 0 Median: 1.5551 Max: 4967 Percentiles: P50: 1.56 P75: 1.96 P99: 8.93 P99.9: 204.03 P99.99: 691.70 ------------------------------------------------------ [ 0, 1 ] 41779 15.667% 15.667% ### ( 1, 2 ] 164951 61.855% 77.522% ############ ( 2, 3 ] 32138 12.051% 89.573% ## ( 3, 4 ] 12619 4.732% 94.305% # ( 4, 6 ] 9212 3.454% 97.760% # ( 6, 10 ] 4522 1.696% 99.456% ( 10, 15 ] 612 0.229% 99.685% ( 15, 22 ] 88 0.033% 99.718% ( 22, 34 ] 32 0.012% 99.730% ( 34, 51 ] 2 0.001% 99.731% ( 51, 76 ] 1 0.000% 99.731% ( 76, 110 ] 123 0.046% 99.777% ( 110, 170 ] 275 0.103% 99.880% ( 170, 250 ] 123 0.046% 99.927% ( 250, 380 ] 91 0.034% 99.961% ( 380, 580 ] 61 0.023% 99.984% ( 580, 870 ] 45 0.017% 100.000% ( 870, 1300 ] 10 0.004% 100.004% ( 1300, 1900 ] 11 0.004% 100.008% ( 1900, 2900 ] 8 0.003% 100.011% ( 2900, 4400 ] 5 0.002% 100.013% ( 4400, 6600 ] 4 0.001% 100.015% ** Level 4 read latency histogram (micros): Count: 310 Average: 127.0000 StdDev: 635.81 Min: 0 Median: 2.3226 Max: 6678 Percentiles: P50: 2.32 P75: 6.06 P99: 2866.67 P99.9: 6678.00 P99.99: 6678.00 ------------------------------------------------------ [ 0, 1 ] 45 14.516% 14.516% ### ( 1, 2 ] 90 29.032% 43.548% ###### ( 2, 3 ] 62 20.000% 63.548% #### ( 3, 4 ] 22 7.097% 70.645% # ( 4, 6 ] 13 4.194% 74.839% # ( 6, 10 ] 31 10.000% 84.839% ## ( 10, 15 ] 17 5.484% 90.323% # ( 15, 22 ] 1 0.323% 90.645% ( 51, 76 ] 2 0.645% 91.290% ( 110, 170 ] 3 0.968% 92.258% ( 170, 250 ] 3 0.968% 93.226% ( 250, 380 ] 3 0.968% 94.194% ( 380, 580 ] 2 0.645% 94.839% ( 580, 870 ] 3 0.968% 95.806% ( 870, 1300 ] 2 0.645% 96.452% ( 1300, 1900 ] 5 1.613% 98.065% ( 1900, 2900 ] 3 0.968% 99.032% ( 4400, 6600 ] 2 0.645% 99.677% ( 6600, 9900 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 942.7750 StdDev: 1121.54 Min: 99 Median: 347.5000 Max: 4594 Percentiles: P50: 347.50 P75: 1300.00 P99: 4594.00 P99.9: 4594.00 P99.99: 4594.00 ------------------------------------------------------ ( 76, 110 ] 2 5.000% 5.000% # ( 110, 170 ] 7 17.500% 22.500% #### ( 170, 250 ] 8 20.000% 42.500% #### ( 250, 380 ] 4 10.000% 52.500% ## ( 380, 580 ] 2 5.000% 57.500% # ( 580, 870 ] 4 10.000% 67.500% ## ( 870, 1300 ] 3 7.500% 75.000% ## ( 1300, 1900 ] 3 7.500% 82.500% ## ( 1900, 2900 ] 2 5.000% 87.500% # ( 2900, 4400 ] 4 10.000% 97.500% ## ( 4400, 6600 ] 1 2.500% 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, 322.25 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.018 H:M:S, 11.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.97 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.394 H:M:S, 12.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/17-19:22:14 ... thread 0: (1000000,4000000) ops and (330921.5,334493.2) ops/second in (3.021865,11.958391) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/10 2.15 GB 18.9 2.4 0.0 2.4 6.1 3.7 0.0 1.6 121.8 308.9 20.18 18.82 62 0.325 2494K 2557 0.0 0.0 L1 10/10 1.04 GB 0.0 1.4 1.4 0.0 1.4 1.3 0.2 1.0 231.6 230.7 5.99 5.80 2 2.997 1409K 4906 0.0 0.0 L2 1/0 96.95 MB 1.0 0.3 0.2 0.2 0.3 0.2 0.3 1.8 257.9 257.8 1.35 1.31 2 0.676 354K 175 0.0 0.0 L3 20/0 906.67 MB 0.9 1.1 0.2 0.9 1.1 0.2 0.2 4.7 242.6 242.2 4.61 4.24 2 2.307 1136K 1727 0.0 0.0 L4 169/0 9.46 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 132.6 132.6 1.27 0.90 1 1.267 170K 0 0.0 0.0 L5 1044/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1257/20 99.82 GB 0.0 5.4 1.9 3.4 9.0 5.6 1.6 2.4 164.1 276.9 33.40 31.07 69 0.484 5565K 9365 0.0 0.0 Int 0/0 0.00 KB 0.0 5.4 1.9 3.4 9.0 5.6 1.6 2.4 164.1 276.9 33.40 31.07 69 0.484 5565K 9365 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 1.9 3.4 5.3 1.9 0.0 0.0 241.6 241.2 22.69 21.53 16 1.418 5565K 9365 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 352.7 10.72 9.54 53 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.2 total, 12.0 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.03 GB write, 759.28 MB/s write, 5.35 GB read, 449.85 MB/s read, 33.4 seconds Interval compaction: 9.03 GB write, 773.48 MB/s write, 5.35 GB read, 458.26 MB/s read, 33.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 1043105 Average: 2.1537 StdDev: 10.56 Min: 0 Median: 1.4513 Max: 2997 Percentiles: P50: 1.45 P75: 1.84 P99: 5.54 P99.9: 9.82 P99.99: 14.77 ------------------------------------------------------ [ 0, 1 ] 215643 20.673% 20.673% #### ( 1, 2 ] 677877 64.986% 85.660% ############# ( 2, 3 ] 83884 8.042% 93.701% ## ( 3, 4 ] 38015 3.644% 97.346% # ( 4, 6 ] 22409 2.148% 99.494% ( 6, 10 ] 4438 0.425% 99.920% ( 10, 15 ] 770 0.074% 99.993% ( 15, 22 ] 71 0.007% 100.000% ( 22, 34 ] 16 0.002% 100.002% ( 34, 51 ] 5 0.000% 100.002% ( 51, 76 ] 5 0.000% 100.003% ( 76, 110 ] 54 0.005% 100.008% ( 110, 170 ] 81 0.008% 100.016% ( 170, 250 ] 51 0.005% 100.021% ( 250, 380 ] 33 0.003% 100.024% ( 380, 580 ] 26 0.002% 100.026% ( 580, 870 ] 19 0.002% 100.028% ( 870, 1300 ] 12 0.001% 100.029% ( 1300, 1900 ] 8 0.001% 100.030% ( 1900, 2900 ] 6 0.001% 100.030% ( 2900, 4400 ] 3 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 11672 Average: 5.2004 StdDev: 44.14 Min: 1 Median: 1.2775 Max: 2011 Percentiles: P50: 1.28 P75: 1.70 P99: 100.28 P99.9: 740.85 P99.99: 1799.68 ------------------------------------------------------ [ 0, 1 ] 3907 33.473% 33.473% ####### ( 1, 2 ] 6952 59.561% 93.035% ############ ( 2, 3 ] 291 2.493% 95.528% ( 3, 4 ] 134 1.148% 96.676% ( 4, 6 ] 54 0.463% 97.138% ( 6, 10 ] 165 1.414% 98.552% ( 10, 15 ] 16 0.137% 98.689% ( 15, 22 ] 2 0.017% 98.706% ( 76, 110 ] 48 0.411% 99.118% ( 110, 170 ] 43 0.368% 99.486% ( 170, 250 ] 18 0.154% 99.640% ( 250, 380 ] 10 0.086% 99.726% ( 380, 580 ] 17 0.146% 99.871% ( 580, 870 ] 6 0.051% 99.923% ( 870, 1300 ] 7 0.060% 99.983% ( 1300, 1900 ] 1 0.009% 99.991% ( 1900, 2900 ] 1 0.009% 100.000% ** Level 2 read latency histogram (micros): Count: 100889 Average: 2.0986 StdDev: 8.86 Min: 0 Median: 1.3621 Max: 1592 Percentiles: P50: 1.36 P75: 1.78 P99: 5.75 P99.9: 17.10 P99.99: 416.44 ------------------------------------------------------ [ 0, 1 ] 28816 28.562% 28.562% ###### ( 1, 2 ] 59727 59.201% 87.763% ############ ( 2, 3 ] 6209 6.154% 93.917% # ( 3, 4 ] 3353 3.323% 97.241% # ( 4, 6 ] 2034 2.016% 99.257% ( 6, 10 ] 574 0.569% 99.826% ( 10, 15 ] 70 0.069% 99.895% ( 15, 22 ] 17 0.017% 99.912% ( 22, 34 ] 3 0.003% 99.915% ( 34, 51 ] 24 0.024% 99.939% ( 51, 76 ] 24 0.024% 99.962% ( 76, 110 ] 8 0.008% 99.970% ( 110, 170 ] 2 0.002% 99.972% ( 170, 250 ] 12 0.012% 99.984% ( 250, 380 ] 5 0.005% 99.989% ( 380, 580 ] 5 0.005% 99.994% ( 580, 870 ] 4 0.004% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 266673 Average: 3.2156 StdDev: 33.15 Min: 0 Median: 1.5551 Max: 4967 Percentiles: P50: 1.56 P75: 1.96 P99: 8.93 P99.9: 204.03 P99.99: 691.70 ------------------------------------------------------ [ 0, 1 ] 41779 15.667% 15.667% ### ( 1, 2 ] 164951 61.855% 77.522% ############ ( 2, 3 ] 32138 12.051% 89.573% ## ( 3, 4 ] 12619 4.732% 94.305% # ( 4, 6 ] 9212 3.454% 97.760% # ( 6, 10 ] 4522 1.696% 99.456% ( 10, 15 ] 612 0.229% 99.685% ( 15, 22 ] 88 0.033% 99.718% ( 22, 34 ] 32 0.012% 99.730% ( 34, 51 ] 2 0.001% 99.731% ( 51, 76 ] 1 0.000% 99.731% ( 76, 110 ] 123 0.046% 99.777% ( 110, 170 ] 275 0.103% 99.880% ( 170, 250 ] 123 0.046% 99.927% ( 250, 380 ] 91 0.034% 99.961% ( 380, 580 ] 61 0.023% 99.984% ( 580, 870 ] 45 0.017% 100.000% ( 870, 1300 ] 10 0.004% 100.004% ( 1300, 1900 ] 11 0.004% 100.008% ( 1900, 2900 ] 8 0.003% 100.011% ( 2900, 4400 ] 5 0.002% 100.013% ( 4400, 6600 ] 4 0.001% 100.015% ** Level 4 read latency histogram (micros): Count: 310 Average: 127.0000 StdDev: 635.81 Min: 0 Median: 2.3226 Max: 6678 Percentiles: P50: 2.32 P75: 6.06 P99: 2866.67 P99.9: 6678.00 P99.99: 6678.00 ------------------------------------------------------ [ 0, 1 ] 45 14.516% 14.516% ### ( 1, 2 ] 90 29.032% 43.548% ###### ( 2, 3 ] 62 20.000% 63.548% #### ( 3, 4 ] 22 7.097% 70.645% # ( 4, 6 ] 13 4.194% 74.839% # ( 6, 10 ] 31 10.000% 84.839% ## ( 10, 15 ] 17 5.484% 90.323% # ( 15, 22 ] 1 0.323% 90.645% ( 51, 76 ] 2 0.645% 91.290% ( 110, 170 ] 3 0.968% 92.258% ( 170, 250 ] 3 0.968% 93.226% ( 250, 380 ] 3 0.968% 94.194% ( 380, 580 ] 2 0.645% 94.839% ( 580, 870 ] 3 0.968% 95.806% ( 870, 1300 ] 2 0.645% 96.452% ( 1300, 1900 ] 5 1.613% 98.065% ( 1900, 2900 ] 3 0.968% 99.032% ( 4400, 6600 ] 2 0.645% 99.677% ( 6600, 9900 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 942.7750 StdDev: 1121.54 Min: 99 Median: 347.5000 Max: 4594 Percentiles: P50: 347.50 P75: 1300.00 P99: 4594.00 P99.9: 4594.00 P99.99: 4594.00 ------------------------------------------------------ ( 76, 110 ] 2 5.000% 5.000% # ( 110, 170 ] 7 17.500% 22.500% #### ( 170, 250 ] 8 20.000% 42.500% #### ( 250, 380 ] 4 10.000% 52.500% ## ( 380, 580 ] 2 5.000% 57.500% # ( 580, 870 ] 4 10.000% 67.500% ## ( 870, 1300 ] 3 7.500% 75.000% ## ( 1300, 1900 ] 3 7.500% 82.500% ## ( 1900, 2900 ] 2 5.000% 87.500% # ( 2900, 4400 ] 4 10.000% 97.500% ## ( 4400, 6600 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 12.2 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 323.10 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.438 H:M:S, 11.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 325.69 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.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/17-19:22:17 ... thread 0: (1000000,5000000) ops and (324328.6,332409.6) ops/second in (3.083293,15.041684) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/14 3.13 GB 88.1 3.2 0.0 3.2 7.9 4.7 0.0 1.7 125.3 308.2 26.15 24.44 79 0.331 3326K 3430 0.0 0.0 L1 10/10 1.04 GB 0.0 1.4 1.4 0.0 1.4 1.3 0.2 1.0 231.6 230.7 5.99 5.80 2 2.997 1409K 4906 0.0 0.0 L2 1/0 96.95 MB 1.0 0.3 0.2 0.2 0.3 0.2 0.3 1.8 257.9 257.8 1.35 1.31 2 0.676 354K 175 0.0 0.0 L3 20/0 906.67 MB 0.9 1.1 0.2 0.9 1.1 0.2 0.2 4.7 242.6 242.2 4.61 4.24 2 2.307 1136K 1727 0.0 0.0 L4 169/0 9.46 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 132.6 132.6 1.27 0.90 1 1.267 170K 0 0.0 0.0 L5 1044/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1262/24 100.80 GB 0.0 6.2 1.9 4.2 10.8 6.6 1.6 2.3 160.0 281.3 39.38 36.70 86 0.458 6397K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.2 1.9 4.2 10.8 6.6 1.6 2.3 160.0 281.3 39.38 36.70 86 0.458 6397K 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.2 1.9 4.2 6.1 1.9 0.0 0.0 243.8 243.4 25.84 24.63 19 1.360 6397K 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 353.7 13.54 12.07 67 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): 15.3 total, 15.0 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: 10.82 GB write, 725.54 MB/s write, 6.15 GB read, 412.64 MB/s read, 39.4 seconds Interval compaction: 10.82 GB write, 736.33 MB/s write, 6.15 GB read, 418.78 MB/s read, 39.4 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: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 2, total-stops: 17, interval: 19 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1389276 Average: 2.1640 StdDev: 10.55 Min: 0 Median: 1.4573 Max: 3023 Percentiles: P50: 1.46 P75: 1.84 P99: 5.54 P99.9: 9.85 P99.99: 14.86 ------------------------------------------------------ [ 0, 1 ] 277704 19.989% 19.989% #### ( 1, 2 ] 911749 65.628% 85.617% ############# ( 2, 3 ] 113307 8.156% 93.773% ## ( 3, 4 ] 50278 3.619% 97.392% # ( 4, 6 ] 28946 2.084% 99.475% ( 6, 10 ] 6134 0.442% 99.917% ( 10, 15 ] 1049 0.076% 99.992% ( 15, 22 ] 90 0.006% 99.999% ( 22, 34 ] 21 0.002% 100.000% ( 34, 51 ] 7 0.001% 100.001% ( 51, 76 ] 8 0.001% 100.001% ( 76, 110 ] 91 0.007% 100.008% ( 110, 170 ] 116 0.008% 100.016% ( 170, 250 ] 75 0.005% 100.022% ( 250, 380 ] 50 0.004% 100.025% ( 380, 580 ] 36 0.003% 100.028% ( 580, 870 ] 26 0.002% 100.030% ( 870, 1300 ] 16 0.001% 100.031% ( 1300, 1900 ] 9 0.001% 100.031% ( 1900, 2900 ] 8 0.001% 100.032% ( 2900, 4400 ] 4 0.000% 100.032% ** Level 1 read latency histogram (micros): Count: 73431 Average: 2.9506 StdDev: 19.41 Min: 1 Median: 1.4811 Max: 2011 Percentiles: P50: 1.48 P75: 1.85 P99: 8.81 P99.9: 208.77 P99.99: 971.78 ------------------------------------------------------ [ 0, 1 ] 12846 17.494% 17.494% ### ( 1, 2 ] 49616 67.568% 85.062% ############## ( 2, 3 ] 5825 7.933% 92.995% ## ( 3, 4 ] 2243 3.055% 96.049% # ( 4, 6 ] 1310 1.784% 97.833% ( 6, 10 ] 1221 1.663% 99.496% ( 10, 15 ] 86 0.117% 99.613% ( 15, 22 ] 5 0.007% 99.620% ( 76, 110 ] 93 0.127% 99.747% ( 110, 170 ] 99 0.135% 99.882% ( 170, 250 ] 28 0.038% 99.920% ( 250, 380 ] 18 0.025% 99.944% ( 380, 580 ] 24 0.033% 99.977% ( 580, 870 ] 8 0.011% 99.988% ( 870, 1300 ] 7 0.010% 99.997% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 100889 Average: 2.0986 StdDev: 8.86 Min: 0 Median: 1.3621 Max: 1592 Percentiles: P50: 1.36 P75: 1.78 P99: 5.75 P99.9: 17.10 P99.99: 416.44 ------------------------------------------------------ [ 0, 1 ] 28816 28.562% 28.562% ###### ( 1, 2 ] 59727 59.201% 87.763% ############ ( 2, 3 ] 6209 6.154% 93.917% # ( 3, 4 ] 3353 3.323% 97.241% # ( 4, 6 ] 2034 2.016% 99.257% ( 6, 10 ] 574 0.569% 99.826% ( 10, 15 ] 70 0.069% 99.895% ( 15, 22 ] 17 0.017% 99.912% ( 22, 34 ] 3 0.003% 99.915% ( 34, 51 ] 24 0.024% 99.939% ( 51, 76 ] 24 0.024% 99.962% ( 76, 110 ] 8 0.008% 99.970% ( 110, 170 ] 2 0.002% 99.972% ( 170, 250 ] 12 0.012% 99.984% ( 250, 380 ] 5 0.005% 99.989% ( 380, 580 ] 5 0.005% 99.994% ( 580, 870 ] 4 0.004% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 266673 Average: 3.2156 StdDev: 33.15 Min: 0 Median: 1.5551 Max: 4967 Percentiles: P50: 1.56 P75: 1.96 P99: 8.93 P99.9: 204.03 P99.99: 691.70 ------------------------------------------------------ [ 0, 1 ] 41779 15.667% 15.667% ### ( 1, 2 ] 164951 61.855% 77.522% ############ ( 2, 3 ] 32138 12.051% 89.573% ## ( 3, 4 ] 12619 4.732% 94.305% # ( 4, 6 ] 9212 3.454% 97.760% # ( 6, 10 ] 4522 1.696% 99.456% ( 10, 15 ] 612 0.229% 99.685% ( 15, 22 ] 88 0.033% 99.718% ( 22, 34 ] 32 0.012% 99.730% ( 34, 51 ] 2 0.001% 99.731% ( 51, 76 ] 1 0.000% 99.731% ( 76, 110 ] 123 0.046% 99.777% ( 110, 170 ] 275 0.103% 99.880% ( 170, 250 ] 123 0.046% 99.927% ( 250, 380 ] 91 0.034% 99.961% ( 380, 580 ] 61 0.023% 99.984% ( 580, 870 ] 45 0.017% 100.000% ( 870, 1300 ] 10 0.004% 100.004% ( 1300, 1900 ] 11 0.004% 100.008% ( 1900, 2900 ] 8 0.003% 100.011% ( 2900, 4400 ] 5 0.002% 100.013% ( 4400, 6600 ] 4 0.001% 100.015% ** Level 4 read latency histogram (micros): Count: 310 Average: 127.0000 StdDev: 635.81 Min: 0 Median: 2.3226 Max: 6678 Percentiles: P50: 2.32 P75: 6.06 P99: 2866.67 P99.9: 6678.00 P99.99: 6678.00 ------------------------------------------------------ [ 0, 1 ] 45 14.516% 14.516% ### ( 1, 2 ] 90 29.032% 43.548% ###### ( 2, 3 ] 62 20.000% 63.548% #### ( 3, 4 ] 22 7.097% 70.645% # ( 4, 6 ] 13 4.194% 74.839% # ( 6, 10 ] 31 10.000% 84.839% ## ( 10, 15 ] 17 5.484% 90.323% # ( 15, 22 ] 1 0.323% 90.645% ( 51, 76 ] 2 0.645% 91.290% ( 110, 170 ] 3 0.968% 92.258% ( 170, 250 ] 3 0.968% 93.226% ( 250, 380 ] 3 0.968% 94.194% ( 380, 580 ] 2 0.645% 94.839% ( 580, 870 ] 3 0.968% 95.806% ( 870, 1300 ] 2 0.645% 96.452% ( 1300, 1900 ] 5 1.613% 98.065% ( 1900, 2900 ] 3 0.968% 99.032% ( 4400, 6600 ] 2 0.645% 99.677% ( 6600, 9900 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 942.7750 StdDev: 1121.54 Min: 99 Median: 347.5000 Max: 4594 Percentiles: P50: 347.50 P75: 1300.00 P99: 4594.00 P99.9: 4594.00 P99.99: 4594.00 ------------------------------------------------------ ( 76, 110 ] 2 5.000% 5.000% # ( 110, 170 ] 7 17.500% 22.500% #### ( 170, 250 ] 8 20.000% 42.500% #### ( 250, 380 ] 4 10.000% 52.500% ## ( 380, 580 ] 2 5.000% 57.500% # ( 580, 870 ] 4 10.000% 67.500% ## ( 870, 1300 ] 3 7.500% 75.000% ## ( 1300, 1900 ] 3 7.500% 82.500% ## ( 1900, 2900 ] 2 5.000% 87.500% # ( 2900, 4400 ] 4 10.000% 97.500% ## ( 4400, 6600 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 15.3 total, 3.1 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 322.31 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.870 H:M:S, 12.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.20 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.432 H:M:S, 14.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/17-19:22:25 ... thread 0: (1000000,6000000) ops and (132697.5,265749.9) ops/second in (7.535939,22.577623) 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/14 4.12 GB 194.9 5.0 0.0 5.0 10.7 5.7 0.0 1.9 143.2 303.6 36.08 33.92 100 0.361 5244K 6966 0.0 0.0 L1 10/10 1.04 GB 0.0 1.4 1.4 0.0 1.4 1.3 0.2 1.0 231.6 230.7 5.99 5.80 2 2.997 1409K 4906 0.0 0.0 L2 1/0 96.95 MB 1.0 0.3 0.2 0.2 0.3 0.2 0.3 1.8 257.9 257.8 1.35 1.31 2 0.676 354K 175 0.0 0.0 L3 20/0 906.67 MB 0.9 1.1 0.2 0.9 1.1 0.2 0.2 4.7 242.6 242.2 4.61 4.24 2 2.307 1136K 1727 0.0 0.0 L4 169/0 9.46 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 132.6 132.6 1.27 0.90 1 1.267 170K 0 0.0 0.0 L5 1044/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1263/24 101.78 GB 0.0 8.0 1.9 6.1 13.6 7.6 1.6 2.4 166.1 283.4 49.30 46.17 107 0.461 8315K 13K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.0 1.9 6.1 13.6 7.6 1.6 2.4 166.1 283.4 49.30 46.17 107 0.461 8315K 13K 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.0 1.9 6.1 8.0 1.9 0.0 0.0 249.0 248.6 32.89 31.55 24 1.370 8315K 13K 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.0 16.42 14.63 83 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): 22.8 total, 22.6 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 13.64 GB write, 612.67 MB/s write, 8.00 GB read, 359.13 MB/s read, 49.3 seconds Interval compaction: 13.64 GB write, 618.74 MB/s write, 8.00 GB read, 362.69 MB/s read, 49.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, 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: 11, total-stops: 17, interval: 28 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2131661 Average: 2.2181 StdDev: 12.04 Min: 0 Median: 1.4502 Max: 5091 Percentiles: P50: 1.45 P75: 1.83 P99: 5.63 P99.9: 11.52 P99.99: 133.37 ------------------------------------------------------ [ 0, 1 ] 430185 20.181% 20.181% #### ( 1, 2 ] 1411852 66.232% 86.413% ############# ( 2, 3 ] 162903 7.642% 94.055% ## ( 3, 4 ] 73111 3.430% 97.485% # ( 4, 6 ] 39686 1.862% 99.347% ( 6, 10 ] 11333 0.532% 99.878% ( 10, 15 ] 1510 0.071% 99.949% ( 15, 22 ] 145 0.007% 99.956% ( 22, 34 ] 24 0.001% 99.957% ( 34, 51 ] 10 0.000% 99.958% ( 51, 76 ] 17 0.001% 99.958% ( 76, 110 ] 473 0.022% 99.981% ( 110, 170 ] 513 0.024% 100.005% ( 170, 250 ] 196 0.009% 100.014% ( 250, 380 ] 133 0.006% 100.020% ( 380, 580 ] 92 0.004% 100.024% ( 580, 870 ] 58 0.003% 100.027% ( 870, 1300 ] 24 0.001% 100.028% ( 1300, 1900 ] 12 0.001% 100.029% ( 1900, 2900 ] 12 0.001% 100.029% ( 2900, 4400 ] 7 0.000% 100.030% ( 4400, 6600 ] 1 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 223541 Average: 2.6359 StdDev: 17.10 Min: 1 Median: 1.4630 Max: 3868 Percentiles: P50: 1.46 P75: 1.83 P99: 8.35 P99.9: 152.43 P99.99: 703.18 ------------------------------------------------------ [ 0, 1 ] 41852 18.722% 18.722% #### ( 1, 2 ] 151016 67.556% 86.279% ############## ( 2, 3 ] 16090 7.198% 93.476% # ( 3, 4 ] 6666 2.982% 96.458% # ( 4, 6 ] 3680 1.646% 98.105% ( 6, 10 ] 3414 1.527% 99.632% ( 10, 15 ] 199 0.089% 99.721% ( 15, 22 ] 23 0.010% 99.731% ( 22, 34 ] 1 0.000% 99.732% ( 51, 76 ] 3 0.001% 99.733% ( 76, 110 ] 220 0.098% 99.831% ( 110, 170 ] 217 0.097% 99.928% ( 170, 250 ] 53 0.024% 99.952% ( 250, 380 ] 35 0.016% 99.968% ( 380, 580 ] 42 0.019% 99.987% ( 580, 870 ] 18 0.008% 99.995% ( 870, 1300 ] 8 0.004% 99.998% ( 1300, 1900 ] 1 0.000% 99.999% ( 1900, 2900 ] 2 0.001% 100.000% ( 2900, 4400 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 100889 Average: 2.0986 StdDev: 8.86 Min: 0 Median: 1.3621 Max: 1592 Percentiles: P50: 1.36 P75: 1.78 P99: 5.75 P99.9: 17.10 P99.99: 416.44 ------------------------------------------------------ [ 0, 1 ] 28816 28.562% 28.562% ###### ( 1, 2 ] 59727 59.201% 87.763% ############ ( 2, 3 ] 6209 6.154% 93.917% # ( 3, 4 ] 3353 3.323% 97.241% # ( 4, 6 ] 2034 2.016% 99.257% ( 6, 10 ] 574 0.569% 99.826% ( 10, 15 ] 70 0.069% 99.895% ( 15, 22 ] 17 0.017% 99.912% ( 22, 34 ] 3 0.003% 99.915% ( 34, 51 ] 24 0.024% 99.939% ( 51, 76 ] 24 0.024% 99.962% ( 76, 110 ] 8 0.008% 99.970% ( 110, 170 ] 2 0.002% 99.972% ( 170, 250 ] 12 0.012% 99.984% ( 250, 380 ] 5 0.005% 99.989% ( 380, 580 ] 5 0.005% 99.994% ( 580, 870 ] 4 0.004% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 266673 Average: 3.2156 StdDev: 33.15 Min: 0 Median: 1.5551 Max: 4967 Percentiles: P50: 1.56 P75: 1.96 P99: 8.93 P99.9: 204.03 P99.99: 691.70 ------------------------------------------------------ [ 0, 1 ] 41779 15.667% 15.667% ### ( 1, 2 ] 164951 61.855% 77.522% ############ ( 2, 3 ] 32138 12.051% 89.573% ## ( 3, 4 ] 12619 4.732% 94.305% # ( 4, 6 ] 9212 3.454% 97.760% # ( 6, 10 ] 4522 1.696% 99.456% ( 10, 15 ] 612 0.229% 99.685% ( 15, 22 ] 88 0.033% 99.718% ( 22, 34 ] 32 0.012% 99.730% ( 34, 51 ] 2 0.001% 99.731% ( 51, 76 ] 1 0.000% 99.731% ( 76, 110 ] 123 0.046% 99.777% ( 110, 170 ] 275 0.103% 99.880% ( 170, 250 ] 123 0.046% 99.927% ( 250, 380 ] 91 0.034% 99.961% ( 380, 580 ] 61 0.023% 99.984% ( 580, 870 ] 45 0.017% 100.000% ( 870, 1300 ] 10 0.004% 100.004% ( 1300, 1900 ] 11 0.004% 100.008% ( 1900, 2900 ] 8 0.003% 100.011% ( 2900, 4400 ] 5 0.002% 100.013% ( 4400, 6600 ] 4 0.001% 100.015% ** Level 4 read latency histogram (micros): Count: 310 Average: 127.0000 StdDev: 635.81 Min: 0 Median: 2.3226 Max: 6678 Percentiles: P50: 2.32 P75: 6.06 P99: 2866.67 P99.9: 6678.00 P99.99: 6678.00 ------------------------------------------------------ [ 0, 1 ] 45 14.516% 14.516% ### ( 1, 2 ] 90 29.032% 43.548% ###### ( 2, 3 ] 62 20.000% 63.548% #### ( 3, 4 ] 22 7.097% 70.645% # ( 4, 6 ] 13 4.194% 74.839% # ( 6, 10 ] 31 10.000% 84.839% ## ( 10, 15 ] 17 5.484% 90.323% # ( 15, 22 ] 1 0.323% 90.645% ( 51, 76 ] 2 0.645% 91.290% ( 110, 170 ] 3 0.968% 92.258% ( 170, 250 ] 3 0.968% 93.226% ( 250, 380 ] 3 0.968% 94.194% ( 380, 580 ] 2 0.645% 94.839% ( 580, 870 ] 3 0.968% 95.806% ( 870, 1300 ] 2 0.645% 96.452% ( 1300, 1900 ] 5 1.613% 98.065% ( 1900, 2900 ] 3 0.968% 99.032% ( 4400, 6600 ] 2 0.645% 99.677% ( 6600, 9900 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 942.7750 StdDev: 1121.54 Min: 99 Median: 347.5000 Max: 4594 Percentiles: P50: 347.50 P75: 1300.00 P99: 4594.00 P99.9: 4594.00 P99.99: 4594.00 ------------------------------------------------------ ( 76, 110 ] 2 5.000% 5.000% # ( 110, 170 ] 7 17.500% 22.500% #### ( 170, 250 ] 8 20.000% 42.500% #### ( 250, 380 ] 4 10.000% 52.500% ## ( 380, 580 ] 2 5.000% 57.500% # ( 580, 870 ] 4 10.000% 67.500% ## ( 870, 1300 ] 3 7.500% 75.000% ## ( 1300, 1900 ] 3 7.500% 82.500% ## ( 1900, 2900 ] 2 5.000% 87.500% # ( 2900, 4400 ] 4 10.000% 97.500% ## ( 4400, 6600 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 22.8 total, 7.5 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 258.96 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:6.545 H:M:S, 28.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 130.60 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:4.675 H:M:S, 62.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/17-19:22:33 ... thread 0: (1000000,7000000) ops and (120219.1,226568.3) ops/second in (8.318143,30.895766) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/7 3.07 GB 69.3 6.0 0.0 6.0 12.7 6.6 0.0 1.9 144.2 302.9 42.82 40.24 120 0.357 6268K 7954 0.0 0.0 L1 17/17 1.96 GB 0.0 4.4 3.3 1.0 4.3 3.3 0.2 1.3 227.4 225.1 19.66 18.86 3 6.553 4539K 44K 0.0 0.0 L2 1/1 128.78 MB 0.0 0.3 0.2 0.2 0.3 0.2 1.3 1.8 257.9 257.8 1.35 1.31 2 0.676 354K 175 0.0 0.0 L3 26/2 1.10 GB 1.0 2.3 1.2 1.1 2.3 1.2 0.2 1.9 229.7 229.3 10.12 9.31 5 2.024 2361K 4716 0.0 0.0 L4 174/0 9.54 GB 1.0 0.3 0.3 0.0 0.3 0.3 0.9 1.0 148.8 148.8 1.86 1.41 3 0.620 280K 193 0.0 0.0 L5 1052/0 86.86 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1282/27 102.66 GB 0.0 13.3 5.0 8.3 19.9 11.6 4.0 3.0 179.3 268.3 75.81 71.14 133 0.570 13M 57K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.3 5.0 8.3 19.9 11.6 4.0 3.0 179.3 268.3 75.81 71.14 133 0.570 13M 57K 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 13.3 5.0 8.3 13.2 4.9 0.0 0.0 240.5 239.5 56.51 53.96 34 1.662 13M 57K 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.6 19.30 17.18 99 0.195 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): 31.1 total, 30.9 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: 19.86 GB write, 653.53 MB/s write, 13.28 GB read, 436.79 MB/s read, 75.8 seconds Interval compaction: 19.86 GB write, 658.27 MB/s write, 13.28 GB read, 439.96 MB/s read, 75.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 16, pending-compaction-bytes-stops: 0, total-delays: 30, total-stops: 17, interval: 47 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2739108 Average: 2.2980 StdDev: 12.59 Min: 0 Median: 1.4602 Max: 5091 Percentiles: P50: 1.46 P75: 1.84 P99: 5.83 P99.9: 14.06 P99.99: 164.27 ------------------------------------------------------ [ 0, 1 ] 531866 19.417% 19.417% #### ( 1, 2 ] 1820222 66.453% 85.871% ############# ( 2, 3 ] 213713 7.802% 93.673% ## ( 3, 4 ] 96621 3.527% 97.200% # ( 4, 6 ] 53983 1.971% 99.171% ( 6, 10 ] 18254 0.666% 99.838% ( 10, 15 ] 2106 0.077% 99.914% ( 15, 22 ] 199 0.007% 99.922% ( 22, 34 ] 27 0.001% 99.923% ( 34, 51 ] 28 0.001% 99.924% ( 51, 76 ] 48 0.002% 99.925% ( 76, 110 ] 906 0.033% 99.959% ( 110, 170 ] 952 0.035% 99.993% ( 170, 250 ] 337 0.012% 100.006% ( 250, 380 ] 235 0.009% 100.014% ( 380, 580 ] 174 0.006% 100.021% ( 580, 870 ] 95 0.003% 100.024% ( 870, 1300 ] 38 0.001% 100.025% ( 1300, 1900 ] 19 0.001% 100.026% ( 1900, 2900 ] 16 0.001% 100.027% ( 2900, 4400 ] 8 0.000% 100.027% ( 4400, 6600 ] 1 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 656069 Average: 2.7064 StdDev: 15.97 Min: 0 Median: 1.5138 Max: 3868 Percentiles: P50: 1.51 P75: 1.88 P99: 8.41 P99.9: 147.68 P99.99: 567.88 ------------------------------------------------------ [ 0, 1 ] 97962 14.932% 14.932% ### ( 1, 2 ] 447805 68.256% 83.187% ############## ( 2, 3 ] 57885 8.823% 92.010% ## ( 3, 4 ] 24334 3.709% 95.720% # ( 4, 6 ] 15234 2.322% 98.042% ( 6, 10 ] 10458 1.594% 99.636% ( 10, 15 ] 769 0.117% 99.753% ( 15, 22 ] 77 0.012% 99.765% ( 22, 34 ] 6 0.001% 99.765% ( 51, 76 ] 39 0.006% 99.771% ( 76, 110 ] 546 0.083% 99.855% ( 110, 170 ] 476 0.073% 99.927% ( 170, 250 ] 177 0.027% 99.954% ( 250, 380 ] 134 0.020% 99.975% ( 380, 580 ] 109 0.017% 99.991% ( 580, 870 ] 53 0.008% 99.999% ( 870, 1300 ] 29 0.004% 100.004% ( 1300, 1900 ] 8 0.001% 100.005% ( 1900, 2900 ] 2 0.000% 100.005% ( 2900, 4400 ] 2 0.000% 100.005% ** Level 2 read latency histogram (micros): Count: 100889 Average: 2.0986 StdDev: 8.86 Min: 0 Median: 1.3621 Max: 1592 Percentiles: P50: 1.36 P75: 1.78 P99: 5.75 P99.9: 17.10 P99.99: 416.44 ------------------------------------------------------ [ 0, 1 ] 28816 28.562% 28.562% ###### ( 1, 2 ] 59727 59.201% 87.763% ############ ( 2, 3 ] 6209 6.154% 93.917% # ( 3, 4 ] 3353 3.323% 97.241% # ( 4, 6 ] 2034 2.016% 99.257% ( 6, 10 ] 574 0.569% 99.826% ( 10, 15 ] 70 0.069% 99.895% ( 15, 22 ] 17 0.017% 99.912% ( 22, 34 ] 3 0.003% 99.915% ( 34, 51 ] 24 0.024% 99.939% ( 51, 76 ] 24 0.024% 99.962% ( 76, 110 ] 8 0.008% 99.970% ( 110, 170 ] 2 0.002% 99.972% ( 170, 250 ] 12 0.012% 99.984% ( 250, 380 ] 5 0.005% 99.989% ( 380, 580 ] 5 0.005% 99.994% ( 580, 870 ] 4 0.004% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 329001 Average: 3.4421 StdDev: 32.22 Min: 0 Median: 1.5812 Max: 4967 Percentiles: P50: 1.58 P75: 1.99 P99: 9.06 P99.9: 243.40 P99.99: 593.83 ------------------------------------------------------ [ 0, 1 ] 46256 14.060% 14.060% ### ( 1, 2 ] 203452 61.839% 75.899% ############ ( 2, 3 ] 41883 12.730% 88.629% ### ( 3, 4 ] 17213 5.232% 93.861% # ( 4, 6 ] 12862 3.909% 97.771% # ( 6, 10 ] 5292 1.609% 99.379% ( 10, 15 ] 732 0.222% 99.602% ( 15, 22 ] 104 0.032% 99.633% ( 22, 34 ] 33 0.010% 99.643% ( 34, 51 ] 3 0.001% 99.644% ( 51, 76 ] 4 0.001% 99.645% ( 76, 110 ] 226 0.069% 99.714% ( 110, 170 ] 423 0.129% 99.843% ( 170, 250 ] 206 0.063% 99.905% ( 250, 380 ] 159 0.048% 99.953% ( 380, 580 ] 117 0.036% 99.989% ( 580, 870 ] 65 0.020% 100.009% ( 870, 1300 ] 19 0.006% 100.015% ( 1300, 1900 ] 13 0.004% 100.019% ( 1900, 2900 ] 8 0.002% 100.021% ( 2900, 4400 ] 5 0.002% 100.022% ( 4400, 6600 ] 4 0.001% 100.024% ** Level 4 read latency histogram (micros): Count: 1765 Average: 48.2221 StdDev: 290.48 Min: 0 Median: 1.8430 Max: 6678 Percentiles: P50: 1.84 P75: 3.00 P99: 1030.06 P99.9: 5758.50 P99.99: 6678.00 ------------------------------------------------------ [ 0, 1 ] 155 8.782% 8.782% ## ( 1, 2 ] 863 48.895% 57.677% ########## ( 2, 3 ] 306 17.337% 75.014% ### ( 3, 4 ] 134 7.592% 82.606% ## ( 4, 6 ] 65 3.683% 86.289% # ( 6, 10 ] 55 3.116% 89.405% # ( 10, 15 ] 23 1.303% 90.708% ( 15, 22 ] 3 0.170% 90.878% ( 51, 76 ] 2 0.113% 90.992% ( 76, 110 ] 13 0.737% 91.728% ( 110, 170 ] 40 2.266% 93.994% ( 170, 250 ] 24 1.360% 95.354% ( 250, 380 ] 27 1.530% 96.884% ( 380, 580 ] 21 1.190% 98.074% ( 580, 870 ] 13 0.737% 98.810% ( 870, 1300 ] 9 0.510% 99.320% ( 1300, 1900 ] 6 0.340% 99.660% ( 1900, 2900 ] 3 0.170% 99.830% ( 4400, 6600 ] 2 0.113% 99.943% ( 6600, 9900 ] 1 0.057% 100.000% ** Level 5 read latency histogram (micros): Count: 80 Average: 762.1750 StdDev: 945.90 Min: 81 Median: 250.0000 Max: 4594 Percentiles: P50: 250.00 P75: 1085.00 P99: 4594.00 P99.9: 4594.00 P99.99: 4594.00 ------------------------------------------------------ ( 76, 110 ] 7 8.750% 8.750% ## ( 110, 170 ] 23 28.750% 37.500% ###### ( 170, 250 ] 10 12.500% 50.000% ### ( 250, 380 ] 6 7.500% 57.500% ## ( 380, 580 ] 4 5.000% 62.500% # ( 580, 870 ] 6 7.500% 70.000% ## ( 870, 1300 ] 8 10.000% 80.000% ## ( 1300, 1900 ] 6 7.500% 87.500% ## ( 1900, 2900 ] 5 6.250% 93.750% # ( 2900, 4400 ] 4 5.000% 98.750% # ( 4400, 6600 ] 1 1.250% 100.000% ** DB Stats ** Uptime(secs): 31.1 total, 8.3 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 221.37 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:11.960 H:M:S, 38.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 118.32 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:5.414 H:M:S, 65.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/17-19:22:39 ... thread 0: (1000000,8000000) ops and (166293.5,216747.9) ops/second in (6.013465,36.909231) 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 4.18 GB 182.5 7.1 0.0 7.1 14.8 7.7 0.0 1.9 145.1 301.2 50.37 47.20 139 0.362 7419K 9190 0.0 0.0 L1 17/17 1.96 GB 0.0 4.4 3.3 1.0 4.3 3.3 0.2 1.3 227.4 225.1 19.66 18.86 3 6.553 4539K 44K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.2 0.2 0.3 0.2 1.3 1.8 257.9 257.8 1.35 1.31 2 0.676 354K 175 0.0 0.0 L3 24/0 990.90 MB 1.0 2.5 1.3 1.2 2.5 1.3 0.2 1.9 228.7 228.3 11.32 10.44 6 1.886 2628K 5162 0.0 0.0 L4 175/0 9.43 GB 1.0 0.5 0.5 0.0 0.5 0.5 0.9 1.0 144.3 144.1 3.85 2.76 8 0.481 560K 633 0.0 0.0 L5 1056/0 87.23 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1288/24 103.77 GB 0.0 14.9 5.4 9.6 22.5 13.0 4.3 2.9 176.4 266.7 86.55 80.57 158 0.548 15M 60K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.9 5.4 9.6 22.5 13.0 4.3 2.9 176.4 266.7 86.55 80.57 158 0.548 15M 60K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 14.9 5.4 9.6 14.9 5.3 0.0 0.0 238.5 237.5 64.03 60.66 44 1.455 15M 60K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.7 7.7 0.0 0.0 0.0 349.6 22.52 19.91 114 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): 37.1 total, 36.9 interval Flush(GB): cumulative 7.690, interval 7.690 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: 22.54 GB write, 621.61 MB/s write, 14.91 GB read, 411.19 MB/s read, 86.5 seconds Interval compaction: 22.54 GB write, 625.38 MB/s write, 14.91 GB read, 413.68 MB/s read, 86.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 24, pending-compaction-bytes-delays: 23, pending-compaction-bytes-stops: 0, total-delays: 37, total-stops: 24, interval: 61 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3181956 Average: 2.3013 StdDev: 12.47 Min: 0 Median: 1.4625 Max: 5091 Percentiles: P50: 1.46 P75: 1.84 P99: 5.85 P99.9: 14.09 P99.99: 162.94 ------------------------------------------------------ [ 0, 1 ] 614434 19.310% 19.310% #### ( 1, 2 ] 2111605 66.362% 85.672% ############# ( 2, 3 ] 251031 7.889% 93.561% ## ( 3, 4 ] 113043 3.553% 97.114% # ( 4, 6 ] 65051 2.044% 99.158% ( 6, 10 ] 21558 0.678% 99.836% ( 10, 15 ] 2510 0.079% 99.914% ( 15, 22 ] 252 0.008% 99.922% ( 22, 34 ] 33 0.001% 99.923% ( 34, 51 ] 30 0.001% 99.924% ( 51, 76 ] 59 0.002% 99.926% ( 76, 110 ] 1115 0.035% 99.961% ( 110, 170 ] 1039 0.033% 99.994% ( 170, 250 ] 379 0.012% 100.006% ( 250, 380 ] 273 0.009% 100.014% ( 380, 580 ] 203 0.006% 100.021% ( 580, 870 ] 113 0.004% 100.024% ( 870, 1300 ] 43 0.001% 100.026% ( 1300, 1900 ] 21 0.001% 100.026% ( 1900, 2900 ] 19 0.001% 100.027% ( 2900, 4400 ] 9 0.000% 100.027% ( 4400, 6600 ] 1 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 848629 Average: 2.6359 StdDev: 15.38 Min: 0 Median: 1.4984 Max: 3962 Percentiles: P50: 1.50 P75: 1.87 P99: 8.35 P99.9: 138.55 P99.99: 544.16 ------------------------------------------------------ [ 0, 1 ] 139828 16.477% 16.477% ### ( 1, 2 ] 570821 67.264% 83.741% ############# ( 2, 3 ] 72164 8.504% 92.244% ## ( 3, 4 ] 29985 3.533% 95.778% # ( 4, 6 ] 19562 2.305% 98.083% ( 6, 10 ] 13238 1.560% 99.643% ( 10, 15 ] 980 0.115% 99.758% ( 15, 22 ] 110 0.013% 99.771% ( 22, 34 ] 9 0.001% 99.772% ( 34, 51 ] 1 0.000% 99.772% ( 51, 76 ] 53 0.006% 99.779% ( 76, 110 ] 751 0.088% 99.867% ( 110, 170 ] 585 0.069% 99.936% ( 170, 250 ] 204 0.024% 99.960% ( 250, 380 ] 153 0.018% 99.978% ( 380, 580 ] 122 0.014% 99.993% ( 580, 870 ] 54 0.006% 99.999% ( 870, 1300 ] 30 0.004% 100.002% ( 1300, 1900 ] 8 0.001% 100.003% ( 1900, 2900 ] 3 0.000% 100.004% ( 2900, 4400 ] 3 0.000% 100.004% ** Level 2 read latency histogram (micros): Count: 100889 Average: 2.0986 StdDev: 8.86 Min: 0 Median: 1.3621 Max: 1592 Percentiles: P50: 1.36 P75: 1.78 P99: 5.75 P99.9: 17.10 P99.99: 416.44 ------------------------------------------------------ [ 0, 1 ] 28816 28.562% 28.562% ###### ( 1, 2 ] 59727 59.201% 87.763% ############ ( 2, 3 ] 6209 6.154% 93.917% # ( 3, 4 ] 3353 3.323% 97.241% # ( 4, 6 ] 2034 2.016% 99.257% ( 6, 10 ] 574 0.569% 99.826% ( 10, 15 ] 70 0.069% 99.895% ( 15, 22 ] 17 0.017% 99.912% ( 22, 34 ] 3 0.003% 99.915% ( 34, 51 ] 24 0.024% 99.939% ( 51, 76 ] 24 0.024% 99.962% ( 76, 110 ] 8 0.008% 99.970% ( 110, 170 ] 2 0.002% 99.972% ( 170, 250 ] 12 0.012% 99.984% ( 250, 380 ] 5 0.005% 99.989% ( 380, 580 ] 5 0.005% 99.994% ( 580, 870 ] 4 0.004% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 413662 Average: 3.4934 StdDev: 36.34 Min: 0 Median: 1.6319 Max: 6628 Percentiles: P50: 1.63 P75: 2.20 P99: 8.92 P99.9: 186.49 P99.99: 417.04 ------------------------------------------------------ [ 0, 1 ] 49151 11.882% 11.882% ## ( 1, 2 ] 249514 60.318% 72.200% ############ ( 2, 3 ] 59155 14.300% 86.501% ### ( 3, 4 ] 25693 6.211% 92.712% # ( 4, 6 ] 21162 5.116% 97.827% # ( 6, 10 ] 6653 1.608% 99.436% ( 10, 15 ] 1029 0.249% 99.685% ( 15, 22 ] 123 0.030% 99.714% ( 22, 34 ] 33 0.008% 99.722% ( 34, 51 ] 4 0.001% 99.723% ( 51, 76 ] 5 0.001% 99.724% ( 76, 110 ] 235 0.057% 99.781% ( 110, 170 ] 446 0.108% 99.889% ( 170, 250 ] 220 0.053% 99.942% ( 250, 380 ] 173 0.042% 99.984% ( 380, 580 ] 133 0.032% 100.016% ( 580, 870 ] 75 0.018% 100.034% ( 870, 1300 ] 21 0.005% 100.039% ( 1300, 1900 ] 13 0.003% 100.043% ( 1900, 2900 ] 9 0.002% 100.045% ( 2900, 4400 ] 15 0.004% 100.048% ( 4400, 6600 ] 4 0.001% 100.049% ( 6600, 9900 ] 1 0.000% 100.050% ** Level 4 read latency histogram (micros): Count: 5557 Average: 37.2554 StdDev: 196.42 Min: 0 Median: 1.9185 Max: 6678 Percentiles: P50: 1.92 P75: 3.22 P99: 756.77 P99.9: 2010.75 P99.99: 5988.73 ------------------------------------------------------ [ 0, 1 ] 317 5.705% 5.705% # ( 1, 2 ] 2680 48.227% 53.932% ########## ( 2, 3 ] 1061 19.093% 73.025% #### ( 3, 4 ] 506 9.106% 82.131% ## ( 4, 6 ] 309 5.561% 87.691% # ( 6, 10 ] 137 2.465% 90.157% ( 10, 15 ] 49 0.882% 91.038% ( 15, 22 ] 5 0.090% 91.128% ( 51, 76 ] 2 0.036% 91.164% ( 76, 110 ] 64 1.152% 92.316% ( 110, 170 ] 114 2.051% 94.367% ( 170, 250 ] 84 1.512% 95.879% ( 250, 380 ] 72 1.296% 97.175% ( 380, 580 ] 74 1.332% 98.506% ( 580, 870 ] 45 0.810% 99.316% ( 870, 1300 ] 19 0.342% 99.658% ( 1300, 1900 ] 13 0.234% 99.892% ( 1900, 2900 ] 4 0.072% 99.964% ( 4400, 6600 ] 2 0.036% 100.000% ( 6600, 9900 ] 1 0.018% 100.018% ** Level 5 read latency histogram (micros): Count: 100 Average: 811.4900 StdDev: 997.04 Min: 81 Median: 271.6667 Max: 4594 Percentiles: P50: 271.67 P75: 1108.89 P99: 4400.00 P99.9: 4594.00 P99.99: 4594.00 ------------------------------------------------------ ( 76, 110 ] 7 7.000% 7.000% # ( 110, 170 ] 28 28.000% 35.000% ###### ( 170, 250 ] 14 14.000% 49.000% ### ( 250, 380 ] 6 6.000% 55.000% # ( 380, 580 ] 6 6.000% 61.000% # ( 580, 870 ] 9 9.000% 70.000% ## ( 870, 1300 ] 9 9.000% 79.000% ## ( 1300, 1900 ] 6 6.000% 85.000% # ( 1900, 2900 ] 7 7.000% 92.000% # ( 2900, 4400 ] 7 7.000% 99.000% # ( 4400, 6600 ] 1 1.000% 100.000% ** DB Stats ** Uptime(secs): 37.1 total, 6.0 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 212.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:15.146 H:M:S, 40.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 163.64 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:3.186 H:M:S, 53.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 2024/11/17-19:22:57 ... thread 0: (1000000,9000000) ops and (55055.4,163420.2) ops/second in (18.163527,55.072758) 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 2.64 GB 56.6 7.6 0.0 7.6 16.2 8.5 0.0 1.9 140.1 296.9 55.77 51.48 154 0.362 7931K 9661 0.0 0.0 L1 13/13 1.55 GB 0.0 8.7 5.7 3.0 8.6 5.6 0.2 1.5 224.0 221.0 39.88 37.67 4 9.970 8598K 44K 0.0 0.0 L2 1/1 128.78 MB 0.0 0.3 0.2 0.2 0.3 0.2 4.0 1.8 257.9 257.8 1.35 1.31 2 0.676 354K 175 0.0 0.0 L3 23/2 1.04 GB 1.0 6.5 3.9 2.6 6.5 3.9 0.2 1.6 189.5 188.7 35.30 28.69 19 1.858 6793K 29K 0.0 0.0 L4 176/0 9.60 GB 1.0 3.1 3.0 0.1 3.1 3.0 0.9 1.0 145.3 145.0 22.19 15.15 37 0.600 3209K 2211 0.0 0.0 L5 1084/0 89.57 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1313/29 104.53 GB 0.0 26.4 12.9 13.5 34.8 21.3 9.4 4.1 174.8 230.4 154.49 134.29 216 0.715 26M 86K 0.0 0.0 Int 0/0 0.00 KB 0.0 26.4 12.9 13.5 34.8 21.3 9.4 4.1 174.8 230.4 154.49 134.29 216 0.715 26M 86K 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 26.4 12.9 13.5 26.2 12.7 0.0 0.0 210.0 208.7 128.58 112.07 89 1.445 26M 86K 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 338.0 25.91 22.23 127 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): 55.3 total, 55.1 interval Flush(GB): cumulative 8.551, interval 8.551 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 34.76 GB write, 643.73 MB/s write, 26.37 GB read, 488.38 MB/s read, 154.5 seconds Interval compaction: 34.76 GB write, 646.35 MB/s write, 26.37 GB read, 490.36 MB/s read, 154.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 33, pending-compaction-bytes-delays: 55, pending-compaction-bytes-stops: 0, total-delays: 69, total-stops: 33, interval: 102 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3885473 Average: 2.6468 StdDev: 20.79 Min: 0 Median: 1.4803 Max: 7054 Percentiles: P50: 1.48 P75: 1.86 P99: 6.64 P99.9: 112.79 P99.99: 358.43 ------------------------------------------------------ [ 0, 1 ] 728189 18.741% 18.741% #### ( 1, 2 ] 2528788 65.083% 83.824% ############# ( 2, 3 ] 329235 8.473% 92.298% ## ( 3, 4 ] 153221 3.943% 96.241% # ( 4, 6 ] 102101 2.628% 98.869% # ( 6, 10 ] 31716 0.816% 99.685% ( 10, 15 ] 4112 0.106% 99.791% ( 15, 22 ] 508 0.013% 99.804% ( 22, 34 ] 45 0.001% 99.805% ( 34, 51 ] 31 0.001% 99.806% ( 51, 76 ] 86 0.002% 99.808% ( 76, 110 ] 3445 0.089% 99.897% ( 110, 170 ] 2376 0.061% 99.958% ( 170, 250 ] 741 0.019% 99.977% ( 250, 380 ] 588 0.015% 99.993% ( 380, 580 ] 551 0.014% 100.007% ( 580, 870 ] 342 0.009% 100.015% ( 870, 1300 ] 186 0.005% 100.020% ( 1300, 1900 ] 88 0.002% 100.023% ( 1900, 2900 ] 44 0.001% 100.024% ( 2900, 4400 ] 30 0.001% 100.024% ( 4400, 6600 ] 7 0.000% 100.025% ( 6600, 9900 ] 1 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 1915699 Average: 3.6694 StdDev: 49.57 Min: 0 Median: 1.5748 Max: 11838 Percentiles: P50: 1.57 P75: 1.98 P99: 9.03 P99.9: 165.10 P99.99: 547.13 ------------------------------------------------------ [ 0, 1 ] 281273 14.683% 14.683% ### ( 1, 2 ] 1177114 61.446% 76.128% ############ ( 2, 3 ] 215776 11.264% 87.392% ## ( 3, 4 ] 105657 5.515% 92.907% # ( 4, 6 ] 90281 4.713% 97.620% # ( 6, 10 ] 34850 1.819% 99.439% ( 10, 15 ] 4465 0.233% 99.672% ( 15, 22 ] 541 0.028% 99.700% ( 22, 34 ] 41 0.002% 99.702% ( 34, 51 ] 12 0.001% 99.703% ( 51, 76 ] 153 0.008% 99.711% ( 76, 110 ] 1948 0.102% 99.813% ( 110, 170 ] 1821 0.095% 99.908% ( 170, 250 ] 582 0.030% 99.938% ( 250, 380 ] 538 0.028% 99.966% ( 380, 580 ] 545 0.028% 99.995% ( 580, 870 ] 406 0.021% 100.016% ( 870, 1300 ] 265 0.014% 100.030% ( 1300, 1900 ] 123 0.006% 100.036% ( 1900, 2900 ] 72 0.004% 100.040% ( 2900, 4400 ] 85 0.004% 100.044% ( 4400, 6600 ] 17 0.001% 100.045% ( 6600, 9900 ] 25 0.001% 100.047% ( 9900, 14000 ] 1 0.000% 100.047% ** Level 2 read latency histogram (micros): Count: 100889 Average: 2.0986 StdDev: 8.86 Min: 0 Median: 1.3621 Max: 1592 Percentiles: P50: 1.36 P75: 1.78 P99: 5.75 P99.9: 17.10 P99.99: 416.44 ------------------------------------------------------ [ 0, 1 ] 28816 28.562% 28.562% ###### ( 1, 2 ] 59727 59.201% 87.763% ############ ( 2, 3 ] 6209 6.154% 93.917% # ( 3, 4 ] 3353 3.323% 97.241% # ( 4, 6 ] 2034 2.016% 99.257% ( 6, 10 ] 574 0.569% 99.826% ( 10, 15 ] 70 0.069% 99.895% ( 15, 22 ] 17 0.017% 99.912% ( 22, 34 ] 3 0.003% 99.915% ( 34, 51 ] 24 0.024% 99.939% ( 51, 76 ] 24 0.024% 99.962% ( 76, 110 ] 8 0.008% 99.970% ( 110, 170 ] 2 0.002% 99.972% ( 170, 250 ] 12 0.012% 99.984% ( 250, 380 ] 5 0.005% 99.989% ( 380, 580 ] 5 0.005% 99.994% ( 580, 870 ] 4 0.004% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1422686 Average: 4.3984 StdDev: 56.76 Min: 0 Median: 1.8420 Max: 8043 Percentiles: P50: 1.84 P75: 2.88 P99: 8.75 P99.9: 14.79 P99.99: 116.76 ------------------------------------------------------ [ 0, 1 ] 72124 5.070% 5.070% # ( 1, 2 ] 759167 53.362% 58.431% ########### ( 2, 3 ] 268252 18.855% 77.286% #### ( 3, 4 ] 148321 10.425% 87.712% ## ( 4, 6 ] 142105 9.989% 97.700% ## ( 6, 10 ] 26847 1.887% 99.587% ( 10, 15 ] 4642 0.326% 99.914% ( 15, 22 ] 524 0.037% 99.951% ( 22, 34 ] 58 0.004% 99.955% ( 34, 51 ] 17 0.001% 99.956% ( 51, 76 ] 32 0.002% 99.958% ( 76, 110 ] 389 0.027% 99.985% ( 110, 170 ] 583 0.041% 100.026% ( 170, 250 ] 399 0.028% 100.054% ( 250, 380 ] 459 0.032% 100.087% ( 380, 580 ] 478 0.034% 100.120% ( 580, 870 ] 409 0.029% 100.149% ( 870, 1300 ] 248 0.017% 100.166% ( 1300, 1900 ] 111 0.008% 100.174% ( 1900, 2900 ] 116 0.008% 100.182% ( 2900, 4400 ] 136 0.010% 100.192% ( 4400, 6600 ] 32 0.002% 100.194% ( 6600, 9900 ] 7 0.000% 100.195% ** Level 4 read latency histogram (micros): Count: 28423 Average: 61.2161 StdDev: 284.65 Min: 0 Median: 2.0772 Max: 7155 Percentiles: P50: 2.08 P75: 3.52 P99: 1296.13 P99.9: 3943.81 P99.99: 6231.54 ------------------------------------------------------ [ 0, 1 ] 940 3.307% 3.307% # ( 1, 2 ] 12821 45.108% 48.415% ######### ( 2, 3 ] 5838 20.540% 68.955% #### ( 3, 4 ] 3311 11.649% 80.604% ## ( 4, 6 ] 2164 7.614% 88.217% ## ( 6, 10 ] 616 2.167% 90.385% ( 10, 15 ] 181 0.637% 91.021% ( 15, 22 ] 20 0.070% 91.092% ( 22, 34 ] 4 0.014% 91.106% ( 34, 51 ] 2 0.007% 91.113% ( 51, 76 ] 3 0.011% 91.123% ( 76, 110 ] 134 0.471% 91.595% ( 110, 170 ] 315 1.108% 92.703% ( 170, 250 ] 294 1.034% 93.737% ( 250, 380 ] 312 1.098% 94.835% ( 380, 580 ] 499 1.756% 96.591% ( 580, 870 ] 439 1.545% 98.135% ( 870, 1300 ] 248 0.873% 99.008% ( 1300, 1900 ] 148 0.521% 99.529% ( 1900, 2900 ] 68 0.239% 99.768% ( 2900, 4400 ] 54 0.190% 99.958% ( 4400, 6600 ] 11 0.039% 99.996% ( 6600, 9900 ] 2 0.007% 100.004% ** Level 5 read latency histogram (micros): Count: 240 Average: 1190.8292 StdDev: 1321.97 Min: 81 Median: 652.5000 Max: 7106 Percentiles: P50: 652.50 P75: 1814.29 P99: 6086.67 P99.9: 7106.00 P99.99: 7106.00 ------------------------------------------------------ ( 76, 110 ] 12 5.000% 5.000% # ( 110, 170 ] 44 18.333% 23.333% #### ( 170, 250 ] 21 8.750% 32.083% ## ( 250, 380 ] 12 5.000% 37.083% # ( 380, 580 ] 24 10.000% 47.083% ## ( 580, 870 ] 28 11.667% 58.750% ## ( 870, 1300 ] 21 8.750% 67.500% ## ( 1300, 1900 ] 21 8.750% 76.250% ## ( 1900, 2900 ] 26 10.833% 87.083% ## ( 2900, 4400 ] 24 10.000% 97.083% ## ( 4400, 6600 ] 6 2.500% 99.583% # ( 6600, 9900 ] 1 0.417% 100.000% ** DB Stats ** Uptime(secs): 55.3 total, 18.2 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 160.18 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:29.967 H:M:S, 54.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 54.19 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:14.822 H:M:S, 81.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/17-19:23:01 ... thread 0: (1000000,10000000) ops and (270801.7,170167.9) ops/second in (3.692739,58.765497) 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.63 GB 163.6 8.7 0.0 8.7 18.3 9.5 0.0 1.9 141.8 296.5 63.07 58.37 173 0.365 9082K 10K 0.0 0.0 L1 13/13 1.55 GB 0.0 8.7 5.7 3.0 8.6 5.6 0.2 1.5 224.0 221.0 39.88 37.67 4 9.970 8598K 44K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.2 0.2 0.3 0.2 4.0 1.8 257.9 257.8 1.35 1.31 2 0.676 354K 175 0.0 0.0 L3 19/0 912.00 MB 0.9 6.7 4.1 2.7 6.7 4.0 0.2 1.6 188.5 187.7 36.58 29.63 20 1.829 7005K 30K 0.0 0.0 L4 174/0 9.50 GB 1.0 3.4 3.3 0.1 3.4 3.3 0.9 1.0 148.1 147.9 23.67 16.44 40 0.592 3490K 2428 0.0 0.0 L5 1088/0 89.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1313/26 105.51 GB 0.0 28.0 13.3 14.7 37.3 22.6 9.8 3.9 174.0 232.3 164.56 143.41 239 0.689 28M 88K 0.0 0.0 Int 0/0 0.00 KB 0.0 28.0 13.3 14.7 37.3 22.6 9.8 3.9 174.0 232.3 164.56 143.41 239 0.689 28M 88K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 28.0 13.3 14.7 27.8 13.1 0.0 0.0 210.9 209.7 135.73 118.60 97 1.399 28M 88K 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 338.8 28.82 24.81 142 0.203 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): 59.0 total, 58.8 interval Flush(GB): cumulative 9.536, interval 9.536 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 37.33 GB write, 648.03 MB/s write, 27.96 GB read, 485.35 MB/s read, 164.6 seconds Interval compaction: 37.33 GB write, 650.50 MB/s write, 27.96 GB read, 487.20 MB/s read, 164.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 21, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 21, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 34, pending-compaction-bytes-delays: 55, pending-compaction-bytes-stops: 0, total-delays: 76, total-stops: 34, interval: 110 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4209503 Average: 2.6380 StdDev: 20.46 Min: 0 Median: 1.4836 Max: 7054 Percentiles: P50: 1.48 P75: 1.87 P99: 6.53 P99.9: 109.12 P99.99: 350.17 ------------------------------------------------------ [ 0, 1 ] 776716 18.451% 18.451% #### ( 1, 2 ] 2745959 65.232% 83.684% ############# ( 2, 3 ] 361016 8.576% 92.260% ## ( 3, 4 ] 167829 3.987% 96.247% # ( 4, 6 ] 111403 2.646% 98.893% # ( 6, 10 ] 33773 0.802% 99.696% ( 10, 15 ] 4511 0.107% 99.803% ( 15, 22 ] 541 0.013% 99.816% ( 22, 34 ] 50 0.001% 99.817% ( 34, 51 ] 33 0.001% 99.818% ( 51, 76 ] 87 0.002% 99.820% ( 76, 110 ] 3465 0.082% 99.902% ( 110, 170 ] 2408 0.057% 99.959% ( 170, 250 ] 801 0.019% 99.978% ( 250, 380 ] 636 0.015% 99.993% ( 380, 580 ] 609 0.014% 100.008% ( 580, 870 ] 374 0.009% 100.017% ( 870, 1300 ] 203 0.005% 100.022% ( 1300, 1900 ] 92 0.002% 100.024% ( 1900, 2900 ] 46 0.001% 100.025% ( 2900, 4400 ] 31 0.001% 100.026% ( 4400, 6600 ] 7 0.000% 100.026% ( 6600, 9900 ] 1 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 2071358 Average: 3.5995 StdDev: 47.87 Min: 0 Median: 1.5725 Max: 11838 Percentiles: P50: 1.57 P75: 1.98 P99: 8.99 P99.9: 164.23 P99.99: 551.73 ------------------------------------------------------ [ 0, 1 ] 301622 14.562% 14.562% ### ( 1, 2 ] 1282243 61.903% 76.465% ############ ( 2, 3 ] 231692 11.186% 87.651% ## ( 3, 4 ] 112173 5.415% 93.066% # ( 4, 6 ] 94788 4.576% 97.642% # ( 6, 10 ] 37588 1.815% 99.457% ( 10, 15 ] 4618 0.223% 99.680% ( 15, 22 ] 558 0.027% 99.707% ( 22, 34 ] 43 0.002% 99.709% ( 34, 51 ] 13 0.001% 99.709% ( 51, 76 ] 165 0.008% 99.717% ( 76, 110 ] 2061 0.099% 99.817% ( 110, 170 ] 1907 0.092% 99.909% ( 170, 250 ] 623 0.030% 99.939% ( 250, 380 ] 571 0.028% 99.967% ( 380, 580 ] 567 0.027% 99.994% ( 580, 870 ] 423 0.020% 100.014% ( 870, 1300 ] 271 0.013% 100.027% ( 1300, 1900 ] 124 0.006% 100.033% ( 1900, 2900 ] 72 0.003% 100.037% ( 2900, 4400 ] 86 0.004% 100.041% ( 4400, 6600 ] 17 0.001% 100.042% ( 6600, 9900 ] 25 0.001% 100.043% ( 9900, 14000 ] 1 0.000% 100.043% ** Level 2 read latency histogram (micros): Count: 100889 Average: 2.0986 StdDev: 8.86 Min: 0 Median: 1.3621 Max: 1592 Percentiles: P50: 1.36 P75: 1.78 P99: 5.75 P99.9: 17.10 P99.99: 416.44 ------------------------------------------------------ [ 0, 1 ] 28816 28.562% 28.562% ###### ( 1, 2 ] 59727 59.201% 87.763% ############ ( 2, 3 ] 6209 6.154% 93.917% # ( 3, 4 ] 3353 3.323% 97.241% # ( 4, 6 ] 2034 2.016% 99.257% ( 6, 10 ] 574 0.569% 99.826% ( 10, 15 ] 70 0.069% 99.895% ( 15, 22 ] 17 0.017% 99.912% ( 22, 34 ] 3 0.003% 99.915% ( 34, 51 ] 24 0.024% 99.939% ( 51, 76 ] 24 0.024% 99.962% ( 76, 110 ] 8 0.008% 99.970% ( 110, 170 ] 2 0.002% 99.972% ( 170, 250 ] 12 0.012% 99.984% ( 250, 380 ] 5 0.005% 99.989% ( 380, 580 ] 5 0.005% 99.994% ( 580, 870 ] 4 0.004% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1491484 Average: 4.3539 StdDev: 55.55 Min: 0 Median: 1.8422 Max: 8043 Percentiles: P50: 1.84 P75: 2.87 P99: 8.77 P99.9: 14.82 P99.99: 119.68 ------------------------------------------------------ [ 0, 1 ] 73450 4.925% 4.925% # ( 1, 2 ] 798213 53.518% 58.443% ########### ( 2, 3 ] 282986 18.973% 77.416% #### ( 3, 4 ] 154422 10.354% 87.770% ## ( 4, 6 ] 147927 9.918% 97.688% ## ( 6, 10 ] 28247 1.894% 99.582% ( 10, 15 ] 4927 0.330% 99.912% ( 15, 22 ] 556 0.037% 99.949% ( 22, 34 ] 59 0.004% 99.953% ( 34, 51 ] 17 0.001% 99.954% ( 51, 76 ] 32 0.002% 99.957% ( 76, 110 ] 399 0.027% 99.983% ( 110, 170 ] 619 0.042% 100.025% ( 170, 250 ] 429 0.029% 100.054% ( 250, 380 ] 484 0.032% 100.086% ( 380, 580 ] 497 0.033% 100.119% ( 580, 870 ] 424 0.028% 100.148% ( 870, 1300 ] 251 0.017% 100.165% ( 1300, 1900 ] 111 0.007% 100.172% ( 1900, 2900 ] 116 0.008% 100.180% ( 2900, 4400 ] 136 0.009% 100.189% ( 4400, 6600 ] 32 0.002% 100.191% ( 6600, 9900 ] 7 0.000% 100.192% ** Level 4 read latency histogram (micros): Count: 31845 Average: 58.3218 StdDev: 272.32 Min: 0 Median: 2.1226 Max: 7155 Percentiles: P50: 2.12 P75: 3.58 P99: 1242.81 P99.9: 3831.50 P99.99: 5963.10 ------------------------------------------------------ [ 0, 1 ] 1034 3.247% 3.247% # ( 1, 2 ] 14084 44.227% 47.474% ######### ( 2, 3 ] 6561 20.603% 68.077% #### ( 3, 4 ] 3797 11.923% 80.000% ## ( 4, 6 ] 2510 7.882% 87.882% ## ( 6, 10 ] 750 2.355% 90.237% ( 10, 15 ] 219 0.688% 90.925% ( 15, 22 ] 27 0.085% 91.010% ( 22, 34 ] 6 0.019% 91.028% ( 34, 51 ] 2 0.006% 91.035% ( 51, 76 ] 3 0.009% 91.044% ( 76, 110 ] 161 0.506% 91.550% ( 110, 170 ] 398 1.250% 92.799% ( 170, 250 ] 364 1.143% 93.943% ( 250, 380 ] 365 1.146% 95.089% ( 380, 580 ] 554 1.740% 96.828% ( 580, 870 ] 467 1.466% 98.295% ( 870, 1300 ] 259 0.813% 99.108% ( 1300, 1900 ] 150 0.471% 99.579% ( 1900, 2900 ] 68 0.214% 99.793% ( 2900, 4400 ] 55 0.173% 99.965% ( 4400, 6600 ] 11 0.035% 100.000% ( 6600, 9900 ] 2 0.006% 100.006% ** Level 5 read latency histogram (micros): Count: 260 Average: 1156.5769 StdDev: 1300.50 Min: 81 Median: 610.0000 Max: 7106 Percentiles: P50: 610.00 P75: 1790.91 P99: 6013.33 P99.9: 7106.00 P99.99: 7106.00 ------------------------------------------------------ ( 76, 110 ] 19 7.308% 7.308% # ( 110, 170 ] 45 17.308% 24.615% ### ( 170, 250 ] 22 8.462% 33.077% ## ( 250, 380 ] 15 5.769% 38.846% # ( 380, 580 ] 26 10.000% 48.846% ## ( 580, 870 ] 29 11.154% 60.000% ## ( 870, 1300 ] 21 8.077% 68.077% ## ( 1300, 1900 ] 22 8.462% 76.538% ## ( 1900, 2900 ] 29 11.154% 87.692% ## ( 2900, 4400 ] 25 9.615% 97.308% ## ( 4400, 6600 ] 6 2.308% 99.615% ( 6600, 9900 ] 1 0.385% 100.000% ** DB Stats ** Uptime(secs): 59.0 total, 3.7 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 166.84 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:30.982 H:M:S, 52.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 266.52 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.014 H:M:S, 27.5 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.883 micros/op 169994 ops/sec 60.002 seconds 10199999 operations; 164.7 MB/s Microseconds per write: Count: 10199999 Average: 5.8825 StdDev: 291.67 Min: 0 Median: 1.7380 Max: 657717 Percentiles: P50: 1.74 P75: 2.77 P99: 9.80 P99.9: 1166.69 P99.99: 2692.61 ------------------------------------------------------ [ 0, 1 ] 1408114 13.805% 13.805% ### ( 1, 2 ] 5002829 49.047% 62.852% ########## ( 2, 3 ] 1619293 15.875% 78.728% ### ( 3, 4 ] 1377016 13.500% 92.228% ### ( 4, 6 ] 555688 5.448% 97.676% # ( 6, 10 ] 142133 1.393% 99.069% ( 10, 15 ] 48795 0.478% 99.548% ( 15, 22 ] 10786 0.106% 99.653% ( 22, 34 ] 2092 0.021% 99.674% ( 34, 51 ] 241 0.002% 99.676% ( 51, 76 ] 28 0.000% 99.677% ( 76, 110 ] 7016 0.069% 99.745% ( 110, 170 ] 2805 0.028% 99.773% ( 170, 250 ] 311 0.003% 99.776% ( 250, 380 ] 212 0.002% 99.778% ( 380, 580 ] 26 0.000% 99.778% ( 580, 870 ] 16 0.000% 99.778% ( 870, 1300 ] 17969 0.176% 99.955% ( 1300, 1900 ] 112 0.001% 99.956% ( 1900, 2900 ] 4412 0.043% 99.999% ( 2900, 4400 ] 67 0.001% 100.000% ( 4400, 6600 ] 14 0.000% 100.000% ( 6600, 9900 ] 3 0.000% 100.000% ( 9900, 14000 ] 4 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 4 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 170000, 250000 ] 10 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 : 203499 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 : 10199999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10526398968 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 : 575 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31665440 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 : 33233876837 rocksdb.compact.write.bytes COUNT : 33036721756 rocksdb.flush.write.bytes COUNT : 10437240932 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 : 61 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 : 211 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 : 10352896000 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3859456 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 : 33332513252 rocksdb.non.last.level.read.count COUNT : 8054011 rocksdb.block.checksum.compute.count COUNT : 8052922 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.390469 P95 : 3.957259 P99 : 8.565189 P100 : 657689.000000 COUNT : 10199999 SUM : 55202778 rocksdb.compaction.times.micros P50 : 925806.451613 P95 : 3670000.000000 P99 : 14160000.000000 P100 : 20221783.000000 COUNT : 98 SUM : 136655207 rocksdb.compaction.times.cpu_micros P50 : 901463.414634 P95 : 3670000.000000 P99 : 14160000.000000 P100 : 18804989.000000 COUNT : 98 SUM : 119511113 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 : 707.941176 P95 : 1251.625000 P99 : 9157.500000 P100 : 39555.000000 COUNT : 145 SUM : 156746 rocksdb.compaction.outfile.sync.micros P50 : 932.621359 P95 : 95222.222222 P99 : 227600.000000 P100 : 265467.000000 COUNT : 396 SUM : 5297789 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 : 99.215054 P95 : 865.166667 P99 : 2095.000000 P100 : 5332.000000 COUNT : 261 SUM : 56709 rocksdb.table.open.io.micros P50 : 1227.602041 P95 : 7164.473684 P99 : 12377.083333 P100 : 19176.000000 COUNT : 575 SUM : 1099152 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.610981 P95 : 7.634487 P99 : 11.024018 P100 : 11845.000000 COUNT : 8051364 SUM : 44243147 rocksdb.read.block.get.micros P50 : 421.428571 P95 : 2890.566038 P99 : 4992.307692 P100 : 7284.000000 COUNT : 1150 SUM : 885453 rocksdb.write.raw.block.micros P50 : 0.513178 P95 : 0.975037 P99 : 2.945828 P100 : 12171.000000 COUNT : 10530559 SUM : 20058834 rocksdb.numfiles.in.singlecompaction P50 : 3.090164 P95 : 7.100000 P99 : 20.985000 P100 : 24.000000 COUNT : 129 SUM : 486 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.564038 P95 : 1170.267439 P99 : 2463.502607 P100 : 657480.000000 COUNT : 199939 SUM : 31687188 rocksdb.sst.read.micros P50 : 1.564346 P95 : 4.565956 P99 : 8.373534 P100 : 11838.000000 COUNT : 8054373 SUM : 27805534 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 : 10199999 SUM : 10526398968 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 : 208532.110092 P95 : 331250.000000 P99 : 484500.000000 P100 : 793739.000000 COUNT : 145 SUM : 29360039 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 : 365 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