[2024-07-25 21:45:01.386578] Starting SPDK v24.01.1-pre git sha1 dbef7efac / DPDK 23.11.0 initialization... [2024-07-25 21:45:01.386714] [ 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_pid2590055 ] Set seed to 1721936701383296 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-25 21:45:01.484041] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-25 21:45:01.714186] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-25 21:45:01.714230] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 2590055' to capture a snapshot of events at runtime. [2024-07-25 21:45:01.714240] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid2590055 for offline analysis/debug. [2024-07-25 21:45:01.714268] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Thu Jul 25 21:45:11 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/07/25-21:45:14 ... thread 0: (1000000,1000000) ops and (346291.3,346291.3) ops/second in (2.887742,2.887742) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/5 566.97 MB 25.2 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 355.8 2.48 2.22 12 0.207 0 0 0.0 0.0 L1 1/0 1.84 MB 0.2 0.2 0.2 0.1 0.2 0.2 0.1 1.3 256.2 256.0 0.98 0.95 1 0.983 255K 183 0.0 0.0 L2 3/2 298.83 MB 1.2 0.1 0.1 0.0 0.1 0.1 0.2 1.8 241.3 241.3 0.46 0.44 1 0.462 113K 25 0.0 0.0 L3 16/9 755.44 MB 0.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 190.3 190.3 0.33 0.27 1 0.329 63K 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1188/16 97.00 GB 0.0 0.4 0.3 0.1 1.3 1.2 0.4 1.5 100.2 307.5 4.25 3.88 15 0.283 432K 208 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.3 1.2 0.4 1.5 100.2 307.5 4.25 3.88 15 0.283 432K 208 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.3 0.1 0.4 0.3 0.0 0.0 240.1 240.0 1.77 1.66 3 0.591 432K 208 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 355.8 2.48 2.22 12 0.207 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.1 total, 2.9 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.28 GB write, 421.63 MB/s write, 0.42 GB read, 137.33 MB/s read, 4.3 seconds Interval compaction: 1.28 GB write, 452.58 MB/s write, 0.42 GB read, 147.41 MB/s read, 4.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 123467 Average: 2.0199 StdDev: 13.18 Min: 1 Median: 1.3354 Max: 2250 Percentiles: P50: 1.34 P75: 1.75 P99: 5.41 P99.9: 11.35 P99.99: 364.98 ------------------------------------------------------ [ 0, 1 ] 36459 29.529% 29.529% ###### ( 1, 2 ] 75351 61.029% 90.559% ############ ( 2, 3 ] 6313 5.113% 95.672% # ( 3, 4 ] 2775 2.248% 97.919% ( 4, 6 ] 1889 1.530% 99.449% ( 6, 10 ] 528 0.428% 99.877% ( 10, 15 ] 109 0.088% 99.965% ( 15, 22 ] 17 0.014% 99.979% ( 22, 34 ] 1 0.001% 99.980% ( 34, 51 ] 2 0.002% 99.981% ( 110, 170 ] 9 0.007% 99.989% ( 250, 380 ] 3 0.002% 99.991% ( 380, 580 ] 2 0.002% 99.993% ( 580, 870 ] 2 0.002% 99.994% ( 870, 1300 ] 3 0.002% 99.997% ( 1300, 1900 ] 3 0.002% 99.999% ( 1900, 2900 ] 2 0.002% 100.001% ** Level 1 read latency histogram (micros): Count: 15592 Average: 2.7829 StdDev: 13.65 Min: 1 Median: 1.7092 Max: 1233 Percentiles: P50: 1.71 P75: 2.44 P99: 8.41 P99.9: 14.27 P99.99: 964.77 ------------------------------------------------------ [ 0, 1 ] 1219 7.818% 7.818% ## ( 1, 2 ] 9274 59.479% 67.297% ############ ( 2, 3 ] 2708 17.368% 84.665% ### ( 3, 4 ] 1001 6.420% 91.085% # ( 4, 6 ] 1080 6.927% 98.012% # ( 6, 10 ] 256 1.642% 99.654% ( 10, 15 ] 45 0.289% 99.942% ( 15, 22 ] 1 0.006% 99.949% ( 22, 34 ] 4 0.026% 99.974% ( 250, 380 ] 1 0.006% 99.981% ( 380, 580 ] 1 0.006% 99.987% ( 870, 1300 ] 2 0.013% 100.000% ** Level 2 read latency histogram (micros): Count: 28202 Average: 2.4587 StdDev: 37.71 Min: 0 Median: 1.2315 Max: 5501 Percentiles: P50: 1.23 P75: 1.69 P99: 7.68 P99.9: 87.89 P99.99: 947.31 ------------------------------------------------------ [ 0, 1 ] 10515 37.285% 37.285% ####### ( 1, 2 ] 15488 54.918% 92.203% ########### ( 2, 3 ] 1081 3.833% 96.036% # ( 3, 4 ] 486 1.723% 97.759% ( 4, 6 ] 246 0.872% 98.631% ( 6, 10 ] 248 0.879% 99.511% ( 10, 15 ] 57 0.202% 99.713% ( 15, 22 ] 7 0.025% 99.738% ( 22, 34 ] 1 0.004% 99.741% ( 34, 51 ] 4 0.014% 99.755% ( 51, 76 ] 38 0.135% 99.890% ( 76, 110 ] 8 0.028% 99.918% ( 110, 170 ] 1 0.004% 99.922% ( 170, 250 ] 9 0.032% 99.954% ( 250, 380 ] 3 0.011% 99.965% ( 380, 580 ] 5 0.018% 99.982% ( 580, 870 ] 2 0.007% 99.989% ( 870, 1300 ] 1 0.004% 99.993% ( 1900, 2900 ] 1 0.004% 99.996% ( 4400, 6600 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 32124 Average: 7.3891 StdDev: 143.89 Min: 1 Median: 1.5960 Max: 7678 Percentiles: P50: 1.60 P75: 2.00 P99: 10.15 P99.9: 644.16 P99.99: 4757.52 ------------------------------------------------------ [ 0, 1 ] 4222 13.143% 13.143% ### ( 1, 2 ] 19867 61.845% 74.988% ############ ( 2, 3 ] 3916 12.190% 87.178% ## ( 3, 4 ] 1686 5.248% 92.426% # ( 4, 6 ] 1521 4.735% 97.161% # ( 6, 10 ] 587 1.827% 98.988% ( 10, 15 ] 122 0.380% 99.368% ( 15, 22 ] 28 0.087% 99.455% ( 22, 34 ] 2 0.006% 99.461% ( 51, 76 ] 1 0.003% 99.465% ( 76, 110 ] 36 0.112% 99.577% ( 110, 170 ] 54 0.168% 99.745% ( 170, 250 ] 21 0.065% 99.810% ( 250, 380 ] 15 0.047% 99.857% ( 380, 580 ] 11 0.034% 99.891% ( 580, 870 ] 13 0.040% 99.932% ( 870, 1300 ] 6 0.019% 99.950% ( 1300, 1900 ] 4 0.012% 99.963% ( 1900, 2900 ] 2 0.006% 99.969% ( 2900, 4400 ] 5 0.016% 99.984% ( 4400, 6600 ] 11 0.034% 100.019% ( 6600, 9900 ] 4 0.012% 100.031% ** Level 4 read latency histogram (micros): Count: 35 Average: 3873.7429 StdDev: 1894.19 Min: 438 Median: 4583.3333 Max: 7005 Percentiles: P50: 4583.33 P75: 5652.78 P99: 7005.00 P99.9: 7005.00 P99.99: 7005.00 ------------------------------------------------------ ( 380, 580 ] 2 5.714% 5.714% # ( 580, 870 ] 2 5.714% 11.429% # ( 870, 1300 ] 1 2.857% 14.286% # ( 1300, 1900 ] 4 11.429% 25.714% ## ( 1900, 2900 ] 2 5.714% 31.429% # ( 2900, 4400 ] 5 14.286% 45.714% ### ( 4400, 6600 ] 18 51.429% 97.143% ########## ( 6600, 9900 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 3.1 total, 2.9 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 317.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:0.402 H:M:S, 13.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 340.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:0.402 H:M:S, 13.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/25-21:45:17 ... thread 0: (1000000,2000000) ops and (327422.3,336592.6) ops/second in (3.054160,5.941902) 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/11 1.54 GB 6.3 0.9 0.0 0.9 2.7 1.8 0.0 1.5 102.1 320.9 8.63 7.99 29 0.298 895K 982 0.0 0.0 L1 1/1 1.84 MB 0.0 0.2 0.2 0.1 0.2 0.2 0.1 1.3 256.2 256.0 0.98 0.95 1 0.983 255K 183 0.0 0.0 L2 1/1 121.16 MB 0.0 0.1 0.1 0.0 0.1 0.1 0.2 1.8 241.3 241.3 0.46 0.44 1 0.462 113K 25 0.0 0.0 L3 77/34 932.61 MB 0.8 1.0 0.2 0.7 1.0 0.2 0.0 4.1 211.1 211.0 4.69 4.03 3 1.562 1004K 539 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1251/47 97.98 GB 0.0 2.2 0.5 1.7 4.0 2.3 0.4 2.2 151.3 279.2 14.77 13.41 34 0.434 2269K 1729 0.0 0.0 Int 0/0 0.00 KB 0.0 2.2 0.5 1.7 4.0 2.3 0.4 2.2 151.3 279.2 14.77 13.41 34 0.434 2269K 1729 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 2.2 0.5 1.7 2.2 0.5 0.0 0.0 236.3 236.2 9.46 8.68 8 1.182 2269K 1729 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 355.9 5.31 4.72 26 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): 6.2 total, 5.9 interval Flush(GB): cumulative 1.846, interval 1.846 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 4.03 GB write, 669.78 MB/s write, 2.18 GB read, 363.04 MB/s read, 14.8 seconds Interval compaction: 4.03 GB write, 693.68 MB/s write, 2.18 GB read, 375.99 MB/s read, 14.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 11, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 388612 Average: 2.3148 StdDev: 15.04 Min: 1 Median: 1.5215 Max: 3577 Percentiles: P50: 1.52 P75: 1.91 P99: 5.85 P99.9: 10.57 P99.99: 17.52 ------------------------------------------------------ [ 0, 1 ] 64145 16.506% 16.506% ### ( 1, 2 ] 249584 64.224% 80.731% ############# ( 2, 3 ] 43358 11.157% 91.888% ## ( 3, 4 ] 15109 3.888% 95.776% # ( 4, 6 ] 13569 3.492% 99.267% # ( 6, 10 ] 2416 0.622% 99.889% ( 10, 15 ] 378 0.097% 99.986% ( 15, 22 ] 42 0.011% 99.997% ( 22, 34 ] 7 0.002% 99.999% ( 34, 51 ] 5 0.001% 100.000% ( 51, 76 ] 3 0.001% 100.001% ( 76, 110 ] 1 0.000% 100.001% ( 110, 170 ] 15 0.004% 100.005% ( 170, 250 ] 5 0.001% 100.006% ( 250, 380 ] 5 0.001% 100.008% ( 380, 580 ] 5 0.001% 100.009% ( 580, 870 ] 6 0.002% 100.011% ( 870, 1300 ] 8 0.002% 100.013% ( 1300, 1900 ] 6 0.002% 100.014% ( 1900, 2900 ] 5 0.001% 100.015% ( 2900, 4400 ] 3 0.001% 100.016% ** Level 1 read latency histogram (micros): Count: 55616 Average: 2.5487 StdDev: 7.30 Min: 1 Median: 1.6842 Max: 1233 Percentiles: P50: 1.68 P75: 2.31 P99: 7.02 P99.9: 13.41 P99.99: 32.88 ------------------------------------------------------ [ 0, 1 ] 4262 7.663% 7.663% ## ( 1, 2 ] 34413 61.876% 69.539% ############ ( 2, 3 ] 9742 17.517% 87.056% #### ( 3, 4 ] 3169 5.698% 92.754% # ( 4, 6 ] 3332 5.991% 98.745% # ( 6, 10 ] 555 0.998% 99.743% ( 10, 15 ] 128 0.230% 99.973% ( 15, 22 ] 4 0.007% 99.980% ( 22, 34 ] 6 0.011% 99.991% ( 51, 76 ] 1 0.002% 99.993% ( 250, 380 ] 1 0.002% 99.995% ( 380, 580 ] 1 0.002% 99.996% ( 870, 1300 ] 2 0.004% 100.000% ** Level 2 read latency histogram (micros): Count: 40606 Average: 2.3242 StdDev: 31.43 Min: 0 Median: 1.3079 Max: 5501 Percentiles: P50: 1.31 P75: 1.73 P99: 6.18 P99.9: 69.68 P99.99: 716.21 ------------------------------------------------------ [ 0, 1 ] 12931 31.845% 31.845% ###### ( 1, 2 ] 23942 58.962% 90.807% ############ ( 2, 3 ] 1947 4.795% 95.602% # ( 3, 4 ] 845 2.081% 97.683% ( 4, 6 ] 522 1.286% 98.968% ( 6, 10 ] 281 0.692% 99.660% ( 10, 15 ] 57 0.140% 99.801% ( 15, 22 ] 7 0.017% 99.818% ( 22, 34 ] 1 0.002% 99.820% ( 34, 51 ] 4 0.010% 99.830% ( 51, 76 ] 38 0.094% 99.924% ( 76, 110 ] 8 0.020% 99.943% ( 110, 170 ] 1 0.002% 99.946% ( 170, 250 ] 9 0.022% 99.968% ( 250, 380 ] 3 0.007% 99.975% ( 380, 580 ] 5 0.012% 99.988% ( 580, 870 ] 2 0.005% 99.993% ( 870, 1300 ] 1 0.002% 99.995% ( 1900, 2900 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 196966 Average: 3.7244 StdDev: 59.86 Min: 1 Median: 1.5957 Max: 7678 Percentiles: P50: 1.60 P75: 2.00 P99: 9.18 P99.9: 220.21 P99.99: 776.27 ------------------------------------------------------ [ 0, 1 ] 25306 12.848% 12.848% ### ( 1, 2 ] 122834 62.363% 75.211% ############ ( 2, 3 ] 25290 12.840% 88.051% ### ( 3, 4 ] 10161 5.159% 93.209% # ( 4, 6 ] 8398 4.264% 97.473% # ( 6, 10 ] 3783 1.921% 99.394% ( 10, 15 ] 519 0.263% 99.657% ( 15, 22 ] 56 0.028% 99.686% ( 22, 34 ] 10 0.005% 99.691% ( 34, 51 ] 3 0.002% 99.692% ( 51, 76 ] 2 0.001% 99.693% ( 76, 110 ] 136 0.069% 99.762% ( 110, 170 ] 202 0.103% 99.865% ( 170, 250 ] 110 0.056% 99.921% ( 250, 380 ] 65 0.033% 99.954% ( 380, 580 ] 51 0.026% 99.980% ( 580, 870 ] 30 0.015% 99.995% ( 870, 1300 ] 11 0.006% 100.001% ( 1300, 1900 ] 6 0.003% 100.004% ( 1900, 2900 ] 2 0.001% 100.005% ( 2900, 4400 ] 5 0.003% 100.007% ( 4400, 6600 ] 11 0.006% 100.013% ( 6600, 9900 ] 4 0.002% 100.015% ** Level 4 read latency histogram (micros): Count: 35 Average: 3873.7429 StdDev: 1894.19 Min: 438 Median: 4583.3333 Max: 7005 Percentiles: P50: 4583.33 P75: 5652.78 P99: 7005.00 P99.9: 7005.00 P99.99: 7005.00 ------------------------------------------------------ ( 380, 580 ] 2 5.714% 5.714% # ( 580, 870 ] 2 5.714% 11.429% # ( 870, 1300 ] 1 2.857% 14.286% # ( 1300, 1900 ] 4 11.429% 25.714% ## ( 1900, 2900 ] 2 5.714% 31.429% # ( 2900, 4400 ] 5 14.286% 45.714% ### ( 4400, 6600 ] 18 51.429% 97.143% ########## ( 6600, 9900 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 6.2 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 319.77 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.843 H:M:S, 13.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 322.26 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.442 H:M:S, 14.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/25-21:45:19 ... thread 0: (1000000,3000000) ops and (358191.6,343496.9) ops/second in (2.791802,8.733704) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/11 2.40 GB 100.7 1.7 0.0 1.7 4.4 2.7 0.0 1.6 122.5 314.8 14.40 13.42 45 0.320 1790K 2001 0.0 0.0 L1 1/1 1.84 MB 0.0 0.2 0.2 0.1 0.2 0.2 0.1 1.3 256.2 256.0 0.98 0.95 1 0.983 255K 183 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.2 1.8 241.3 241.3 0.46 0.44 1 0.462 113K 25 0.0 0.0 L3 39/0 994.79 MB 1.0 1.2 0.4 0.8 1.2 0.4 0.0 3.3 211.5 211.4 5.71 4.97 4 1.427 1199K 539 0.0 0.0 L4 128/0 9.65 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1228/12 98.84 GB 0.0 3.3 0.6 2.7 6.0 3.3 0.4 2.2 154.7 283.2 21.56 19.78 51 0.423 3359K 2748 0.0 0.0 Int 0/0 0.00 KB 0.0 3.3 0.6 2.7 6.0 3.3 0.4 2.2 154.7 283.2 21.56 19.78 51 0.423 3359K 2748 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.3 0.6 2.7 3.3 0.6 0.0 0.0 241.8 241.6 13.79 12.88 12 1.149 3359K 2748 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 357.1 7.76 6.90 39 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 8.9 total, 8.7 interval Flush(GB): cumulative 2.707, interval 2.707 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.96 GB write, 682.20 MB/s write, 3.26 GB read, 372.73 MB/s read, 21.6 seconds Interval compaction: 5.96 GB write, 698.77 MB/s write, 3.26 GB read, 381.78 MB/s read, 21.6 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: 12, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 12, interval: 12 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 795085 Average: 2.3288 StdDev: 12.43 Min: 1 Median: 1.5537 Max: 3577 Percentiles: P50: 1.55 P75: 1.93 P99: 5.82 P99.9: 10.09 P99.99: 14.30 ------------------------------------------------------ [ 0, 1 ] 106094 13.344% 13.344% ### ( 1, 2 ] 526402 66.207% 79.551% ############# ( 2, 3 ] 98058 12.333% 91.884% ## ( 3, 4 ] 31213 3.926% 95.810% # ( 4, 6 ] 27947 3.515% 99.324% # ( 6, 10 ] 4561 0.574% 99.898% ( 10, 15 ] 851 0.107% 100.005% ( 15, 22 ] 77 0.010% 100.015% ( 22, 34 ] 13 0.002% 100.016% ( 34, 51 ] 5 0.001% 100.017% ( 51, 76 ] 8 0.001% 100.018% ( 76, 110 ] 13 0.002% 100.020% ( 110, 170 ] 39 0.005% 100.025% ( 170, 250 ] 11 0.001% 100.026% ( 250, 380 ] 10 0.001% 100.027% ( 380, 580 ] 11 0.001% 100.029% ( 580, 870 ] 18 0.002% 100.031% ( 870, 1300 ] 11 0.001% 100.032% ( 1300, 1900 ] 7 0.001% 100.033% ( 1900, 2900 ] 7 0.001% 100.034% ( 2900, 4400 ] 4 0.001% 100.035% ** Level 1 read latency histogram (micros): Count: 63461 Average: 2.5494 StdDev: 6.85 Min: 1 Median: 1.6923 Max: 1233 Percentiles: P50: 1.69 P75: 2.33 P99: 6.94 P99.9: 13.29 P99.99: 31.31 ------------------------------------------------------ [ 0, 1 ] 4599 7.247% 7.247% # ( 1, 2 ] 39189 61.753% 69.000% ############ ( 2, 3 ] 11474 18.080% 87.080% #### ( 3, 4 ] 3637 5.731% 92.811% # ( 4, 6 ] 3780 5.956% 98.768% # ( 6, 10 ] 627 0.988% 99.756% ( 10, 15 ] 139 0.219% 99.975% ( 15, 22 ] 5 0.008% 99.983% ( 22, 34 ] 6 0.009% 99.992% ( 51, 76 ] 1 0.002% 99.994% ( 250, 380 ] 1 0.002% 99.995% ( 380, 580 ] 1 0.002% 99.997% ( 870, 1300 ] 2 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 40606 Average: 2.3242 StdDev: 31.43 Min: 0 Median: 1.3079 Max: 5501 Percentiles: P50: 1.31 P75: 1.73 P99: 6.18 P99.9: 69.68 P99.99: 716.21 ------------------------------------------------------ [ 0, 1 ] 12931 31.845% 31.845% ###### ( 1, 2 ] 23942 58.962% 90.807% ############ ( 2, 3 ] 1947 4.795% 95.602% # ( 3, 4 ] 845 2.081% 97.683% ( 4, 6 ] 522 1.286% 98.968% ( 6, 10 ] 281 0.692% 99.660% ( 10, 15 ] 57 0.140% 99.801% ( 15, 22 ] 7 0.017% 99.818% ( 22, 34 ] 1 0.002% 99.820% ( 34, 51 ] 4 0.010% 99.830% ( 51, 76 ] 38 0.094% 99.924% ( 76, 110 ] 8 0.020% 99.943% ( 110, 170 ] 1 0.002% 99.946% ( 170, 250 ] 9 0.022% 99.968% ( 250, 380 ] 3 0.007% 99.975% ( 380, 580 ] 5 0.012% 99.988% ( 580, 870 ] 2 0.005% 99.993% ( 870, 1300 ] 1 0.002% 99.995% ( 1900, 2900 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 215326 Average: 3.6775 StdDev: 57.47 Min: 1 Median: 1.5992 Max: 7678 Percentiles: P50: 1.60 P75: 2.00 P99: 9.11 P99.9: 220.87 P99.99: 777.44 ------------------------------------------------------ [ 0, 1 ] 26780 12.437% 12.437% ## ( 1, 2 ] 134993 62.692% 75.129% ############# ( 2, 3 ] 28002 13.004% 88.134% ### ( 3, 4 ] 11124 5.166% 93.300% # ( 4, 6 ] 9239 4.291% 97.591% # ( 6, 10 ] 3898 1.810% 99.401% ( 10, 15 ] 546 0.254% 99.654% ( 15, 22 ] 57 0.026% 99.681% ( 22, 34 ] 10 0.005% 99.686% ( 34, 51 ] 3 0.001% 99.687% ( 51, 76 ] 2 0.001% 99.688% ( 76, 110 ] 157 0.073% 99.761% ( 110, 170 ] 224 0.104% 99.865% ( 170, 250 ] 119 0.055% 99.920% ( 250, 380 ] 70 0.033% 99.953% ( 380, 580 ] 58 0.027% 99.980% ( 580, 870 ] 33 0.015% 99.995% ( 870, 1300 ] 12 0.006% 100.000% ( 1300, 1900 ] 6 0.003% 100.003% ( 1900, 2900 ] 2 0.001% 100.004% ( 2900, 4400 ] 5 0.002% 100.007% ( 4400, 6600 ] 11 0.005% 100.012% ( 6600, 9900 ] 4 0.002% 100.013% ** Level 4 read latency histogram (micros): Count: 35 Average: 3873.7429 StdDev: 1894.19 Min: 438 Median: 4583.3333 Max: 7005 Percentiles: P50: 4583.33 P75: 5652.78 P99: 7005.00 P99.9: 7005.00 P99.99: 7005.00 ------------------------------------------------------ ( 380, 580 ] 2 5.714% 5.714% # ( 580, 870 ] 2 5.714% 11.429% # ( 870, 1300 ] 1 2.857% 14.286% # ( 1300, 1900 ] 4 11.429% 25.714% ## ( 1900, 2900 ] 2 5.714% 31.429% # ( 2900, 4400 ] 5 14.286% 45.714% ### ( 4400, 6600 ] 18 51.429% 97.143% ########## ( 6600, 9900 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 8.9 total, 2.8 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 329.99 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.049 H:M:S, 11.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 352.53 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.206 H:M:S, 7.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/25-21:45:22 ... thread 0: (1000000,4000000) ops and (329045.1,339766.2) ops/second in (3.039097,11.772801) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/13 2.21 GB 6.3 2.5 0.0 2.5 6.2 3.7 0.0 1.7 126.2 310.6 20.47 19.09 62 0.330 2622K 2852 0.0 0.0 L1 7/7 676.47 MB 0.0 1.4 1.4 0.1 1.4 1.3 0.1 1.0 234.9 233.8 6.17 5.96 2 3.086 1472K 6183 0.0 0.0 L2 1/1 128.77 MB 0.0 0.1 0.1 0.0 0.1 0.1 0.7 1.8 241.3 241.3 0.46 0.44 1 0.462 113K 25 0.0 0.0 L3 25/2 950.99 MB 0.9 1.5 0.6 0.9 1.5 0.6 0.1 2.4 205.4 205.2 7.38 6.37 6 1.230 1471K 657 0.0 0.0 L4 164/0 9.70 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.4 1.0 148.7 148.8 0.82 0.62 1 0.822 124K 0 0.0 0.0 L5 1048/0 86.19 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 1259/23 99.82 GB 0.0 5.6 2.1 3.5 9.3 5.8 1.7 2.5 163.7 270.5 35.31 32.48 72 0.490 5803K 9717 0.0 0.0 Int 0/0 0.00 KB 0.0 5.6 2.1 3.5 9.3 5.8 1.7 2.5 163.7 270.5 35.31 32.48 72 0.490 5803K 9717 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.6 2.1 3.5 5.6 2.1 0.0 0.0 234.3 233.9 24.67 23.05 19 1.298 5803K 9717 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 355.3 10.64 9.44 53 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.0 total, 11.8 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.33 GB write, 796.77 MB/s write, 5.65 GB read, 482.31 MB/s read, 35.3 seconds Interval compaction: 9.33 GB write, 811.13 MB/s write, 5.65 GB read, 491.00 MB/s read, 35.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 17, interval: 17 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1106494 Average: 2.3893 StdDev: 12.90 Min: 1 Median: 1.5655 Max: 3577 Percentiles: P50: 1.57 P75: 1.94 P99: 5.87 P99.9: 11.09 P99.99: 17.66 ------------------------------------------------------ [ 0, 1 ] 138018 12.473% 12.473% ## ( 1, 2 ] 734294 66.362% 78.836% ############# ( 2, 3 ] 141425 12.781% 91.617% ### ( 3, 4 ] 44134 3.989% 95.606% # ( 4, 6 ] 40229 3.636% 99.241% # ( 6, 10 ] 7022 0.635% 99.876% ( 10, 15 ] 1221 0.110% 99.986% ( 15, 22 ] 109 0.010% 99.996% ( 22, 34 ] 16 0.001% 99.998% ( 34, 51 ] 5 0.000% 99.998% ( 51, 76 ] 11 0.001% 99.999% ( 76, 110 ] 30 0.003% 100.002% ( 110, 170 ] 142 0.013% 100.015% ( 170, 250 ] 46 0.004% 100.019% ( 250, 380 ] 33 0.003% 100.022% ( 380, 580 ] 35 0.003% 100.025% ( 580, 870 ] 31 0.003% 100.028% ( 870, 1300 ] 17 0.002% 100.029% ( 1300, 1900 ] 13 0.001% 100.030% ( 1900, 2900 ] 9 0.001% 100.031% ( 2900, 4400 ] 5 0.000% 100.032% ** Level 1 read latency histogram (micros): Count: 153159 Average: 2.8894 StdDev: 17.38 Min: 1 Median: 1.7401 Max: 3193 Percentiles: P50: 1.74 P75: 2.48 P99: 7.78 P99.9: 14.97 P99.99: 299.26 ------------------------------------------------------ [ 0, 1 ] 8911 5.818% 5.818% # ( 1, 2 ] 91437 59.701% 65.519% ############ ( 2, 3 ] 30189 19.711% 85.230% #### ( 3, 4 ] 9767 6.377% 91.607% # ( 4, 6 ] 10502 6.857% 98.464% # ( 6, 10 ] 1849 1.207% 99.671% ( 10, 15 ] 354 0.231% 99.902% ( 15, 22 ] 29 0.019% 99.921% ( 22, 34 ] 7 0.005% 99.926% ( 51, 76 ] 2 0.001% 99.927% ( 76, 110 ] 38 0.025% 99.952% ( 110, 170 ] 43 0.028% 99.980% ( 170, 250 ] 11 0.007% 99.987% ( 250, 380 ] 15 0.010% 99.997% ( 380, 580 ] 16 0.010% 100.007% ( 580, 870 ] 3 0.002% 100.009% ( 870, 1300 ] 6 0.004% 100.013% ( 1300, 1900 ] 2 0.001% 100.014% ( 1900, 2900 ] 3 0.002% 100.016% ( 2900, 4400 ] 1 0.001% 100.017% ** Level 2 read latency histogram (micros): Count: 40606 Average: 2.3242 StdDev: 31.43 Min: 0 Median: 1.3079 Max: 5501 Percentiles: P50: 1.31 P75: 1.73 P99: 6.18 P99.9: 69.68 P99.99: 716.21 ------------------------------------------------------ [ 0, 1 ] 12931 31.845% 31.845% ###### ( 1, 2 ] 23942 58.962% 90.807% ############ ( 2, 3 ] 1947 4.795% 95.602% # ( 3, 4 ] 845 2.081% 97.683% ( 4, 6 ] 522 1.286% 98.968% ( 6, 10 ] 281 0.692% 99.660% ( 10, 15 ] 57 0.140% 99.801% ( 15, 22 ] 7 0.017% 99.818% ( 22, 34 ] 1 0.002% 99.820% ( 34, 51 ] 4 0.010% 99.830% ( 51, 76 ] 38 0.094% 99.924% ( 76, 110 ] 8 0.020% 99.943% ( 110, 170 ] 1 0.002% 99.946% ( 170, 250 ] 9 0.022% 99.968% ( 250, 380 ] 3 0.007% 99.975% ( 380, 580 ] 5 0.012% 99.988% ( 580, 870 ] 2 0.005% 99.993% ( 870, 1300 ] 1 0.002% 99.995% ( 1900, 2900 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 279919 Average: 4.0900 StdDev: 53.75 Min: 0 Median: 1.6322 Max: 7678 Percentiles: P50: 1.63 P75: 2.16 P99: 9.52 P99.9: 342.25 P99.99: 882.39 ------------------------------------------------------ [ 0, 1 ] 30627 10.941% 10.941% ## ( 1, 2 ] 172929 61.778% 72.720% ############ ( 2, 3 ] 41179 14.711% 87.431% ### ( 3, 4 ] 14770 5.277% 92.707% # ( 4, 6 ] 13343 4.767% 97.474% # ( 6, 10 ] 4861 1.737% 99.210% ( 10, 15 ] 774 0.277% 99.487% ( 15, 22 ] 93 0.033% 99.520% ( 22, 34 ] 12 0.004% 99.525% ( 34, 51 ] 3 0.001% 99.526% ( 51, 76 ] 10 0.004% 99.529% ( 76, 110 ] 288 0.103% 99.632% ( 110, 170 ] 400 0.143% 99.775% ( 170, 250 ] 233 0.083% 99.858% ( 250, 380 ] 165 0.059% 99.917% ( 380, 580 ] 130 0.046% 99.964% ( 580, 870 ] 73 0.026% 99.990% ( 870, 1300 ] 35 0.013% 100.002% ( 1300, 1900 ] 11 0.004% 100.006% ( 1900, 2900 ] 4 0.001% 100.008% ( 2900, 4400 ] 5 0.002% 100.009% ( 4400, 6600 ] 11 0.004% 100.013% ( 6600, 9900 ] 4 0.001% 100.015% ** Level 4 read latency histogram (micros): Count: 165 Average: 828.5636 StdDev: 1805.08 Min: 0 Median: 2.1875 Max: 7005 Percentiles: P50: 2.19 P75: 19.16 P99: 6520.56 P99.9: 7005.00 P99.99: 7005.00 ------------------------------------------------------ [ 0, 1 ] 41 24.848% 24.848% ##### ( 1, 2 ] 40 24.242% 49.091% ##### ( 2, 3 ] 8 4.848% 53.939% # ( 3, 4 ] 10 6.061% 60.000% # ( 4, 6 ] 2 1.212% 61.212% ( 6, 10 ] 1 0.606% 61.818% ( 10, 15 ] 17 10.303% 72.121% ## ( 15, 22 ] 8 4.848% 76.970% # ( 110, 170 ] 1 0.606% 77.576% ( 170, 250 ] 2 1.212% 78.788% ( 380, 580 ] 2 1.212% 80.000% ( 580, 870 ] 2 1.212% 81.212% ( 870, 1300 ] 1 0.606% 81.818% ( 1300, 1900 ] 4 2.424% 84.242% ( 1900, 2900 ] 2 1.212% 85.455% ( 2900, 4400 ] 5 3.030% 88.485% # ( 4400, 6600 ] 18 10.909% 99.394% ## ( 6600, 9900 ] 1 0.606% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 945.6500 StdDev: 1199.42 Min: 84 Median: 223.3333 Max: 4225 Percentiles: P50: 223.33 P75: 1600.00 P99: 4225.00 P99.9: 4225.00 P99.99: 4225.00 ------------------------------------------------------ ( 76, 110 ] 5 25.000% 25.000% ##### ( 110, 170 ] 3 15.000% 40.000% ### ( 170, 250 ] 3 15.000% 55.000% ### ( 380, 580 ] 1 5.000% 60.000% # ( 580, 870 ] 2 10.000% 70.000% ## ( 1300, 1900 ] 2 10.000% 80.000% ## ( 1900, 2900 ] 2 10.000% 90.000% ## ( 2900, 4400 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 12.0 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 328.43 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.483 H:M:S, 12.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 323.83 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.434 H:M:S, 14.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/25-21:45:26 ... thread 0: (1000000,5000000) ops and (312533.7,333946.5) ops/second in (3.199655,14.972456) 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.26 GB 113.3 3.3 0.0 3.3 8.1 4.7 0.0 1.7 127.9 310.1 26.60 24.84 79 0.337 3454K 3691 0.0 0.0 L1 7/7 676.47 MB 0.0 1.4 1.4 0.1 1.4 1.3 0.1 1.0 234.9 233.8 6.17 5.96 2 3.086 1472K 6183 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.7 1.8 241.3 241.3 0.46 0.44 1 0.462 113K 25 0.0 0.0 L3 23/0 985.23 MB 1.0 1.7 0.7 1.0 1.7 0.7 0.1 2.3 207.7 207.6 8.36 7.31 7 1.195 1697K 698 0.0 0.0 L4 164/0 9.49 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 170.6 170.6 1.27 1.03 2 0.635 220K 0 0.0 0.0 L5 1052/0 86.49 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 1265/20 100.86 GB 0.0 6.8 2.4 4.4 11.5 7.1 2.0 2.4 161.4 274.2 42.87 39.58 91 0.471 6956K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.8 2.4 4.4 11.5 7.1 2.0 2.4 161.4 274.2 42.87 39.58 91 0.471 6956K 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.8 2.4 4.4 6.7 2.3 0.0 0.0 236.7 236.3 29.22 27.46 24 1.217 6956K 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 355.4 13.65 12.13 67 0.204 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.2 total, 15.0 interval Flush(GB): cumulative 4.737, interval 4.737 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.48 GB write, 774.14 MB/s write, 6.75 GB read, 455.48 MB/s read, 42.9 seconds Interval compaction: 11.48 GB write, 785.10 MB/s write, 6.75 GB read, 461.93 MB/s read, 42.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 23, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 23, interval: 23 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1515791 Average: 2.3754 StdDev: 12.31 Min: 1 Median: 1.5665 Max: 3782 Percentiles: P50: 1.57 P75: 1.94 P99: 5.85 P99.9: 10.62 P99.99: 14.93 ------------------------------------------------------ [ 0, 1 ] 182709 12.054% 12.054% ## ( 1, 2 ] 1015421 66.990% 79.043% ############# ( 2, 3 ] 194341 12.821% 91.864% ### ( 3, 4 ] 59423 3.920% 95.785% # ( 4, 6 ] 52645 3.473% 99.258% # ( 6, 10 ] 9541 0.629% 99.887% ( 10, 15 ] 1583 0.104% 99.992% ( 15, 22 ] 132 0.009% 100.000% ( 22, 34 ] 20 0.001% 100.002% ( 34, 51 ] 8 0.001% 100.002% ( 51, 76 ] 12 0.001% 100.003% ( 76, 110 ] 39 0.003% 100.005% ( 110, 170 ] 182 0.012% 100.017% ( 170, 250 ] 56 0.004% 100.021% ( 250, 380 ] 43 0.003% 100.024% ( 380, 580 ] 50 0.003% 100.027% ( 580, 870 ] 34 0.002% 100.030% ( 870, 1300 ] 23 0.002% 100.031% ( 1300, 1900 ] 18 0.001% 100.032% ( 1900, 2900 ] 10 0.001% 100.033% ( 2900, 4400 ] 6 0.000% 100.033% ** Level 1 read latency histogram (micros): Count: 170509 Average: 2.8943 StdDev: 16.77 Min: 1 Median: 1.7278 Max: 3193 Percentiles: P50: 1.73 P75: 2.44 P99: 7.93 P99.9: 78.83 P99.99: 314.63 ------------------------------------------------------ [ 0, 1 ] 10104 5.926% 5.926% # ( 1, 2 ] 103259 60.559% 66.485% ############ ( 2, 3 ] 32788 19.229% 85.715% #### ( 3, 4 ] 10425 6.114% 91.829% # ( 4, 6 ] 11186 6.560% 98.389% # ( 6, 10 ] 2155 1.264% 99.653% ( 10, 15 ] 377 0.221% 99.874% ( 15, 22 ] 30 0.018% 99.892% ( 22, 34 ] 7 0.004% 99.896% ( 51, 76 ] 2 0.001% 99.897% ( 76, 110 ] 66 0.039% 99.935% ( 110, 170 ] 64 0.038% 99.973% ( 170, 250 ] 20 0.012% 99.985% ( 250, 380 ] 18 0.011% 99.995% ( 380, 580 ] 18 0.011% 100.006% ( 580, 870 ] 3 0.002% 100.008% ( 870, 1300 ] 6 0.004% 100.011% ( 1300, 1900 ] 2 0.001% 100.012% ( 1900, 2900 ] 3 0.002% 100.014% ( 2900, 4400 ] 1 0.001% 100.015% ** Level 2 read latency histogram (micros): Count: 40606 Average: 2.3242 StdDev: 31.43 Min: 0 Median: 1.3079 Max: 5501 Percentiles: P50: 1.31 P75: 1.73 P99: 6.18 P99.9: 69.68 P99.99: 716.21 ------------------------------------------------------ [ 0, 1 ] 12931 31.845% 31.845% ###### ( 1, 2 ] 23942 58.962% 90.807% ############ ( 2, 3 ] 1947 4.795% 95.602% # ( 3, 4 ] 845 2.081% 97.683% ( 4, 6 ] 522 1.286% 98.968% ( 6, 10 ] 281 0.692% 99.660% ( 10, 15 ] 57 0.140% 99.801% ( 15, 22 ] 7 0.017% 99.818% ( 22, 34 ] 1 0.002% 99.820% ( 34, 51 ] 4 0.010% 99.830% ( 51, 76 ] 38 0.094% 99.924% ( 76, 110 ] 8 0.020% 99.943% ( 110, 170 ] 1 0.002% 99.946% ( 170, 250 ] 9 0.022% 99.968% ( 250, 380 ] 3 0.007% 99.975% ( 380, 580 ] 5 0.012% 99.988% ( 580, 870 ] 2 0.005% 99.993% ( 870, 1300 ] 1 0.002% 99.995% ( 1900, 2900 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 306770 Average: 3.9579 StdDev: 51.43 Min: 0 Median: 1.6386 Max: 7678 Percentiles: P50: 1.64 P75: 2.17 P99: 9.36 P99.9: 322.67 P99.99: 873.75 ------------------------------------------------------ [ 0, 1 ] 31778 10.359% 10.359% ## ( 1, 2 ] 190418 62.072% 72.431% ############ ( 2, 3 ] 46537 15.170% 87.601% ### ( 3, 4 ] 16081 5.242% 92.843% # ( 4, 6 ] 14641 4.773% 97.615% # ( 6, 10 ] 5049 1.646% 99.261% ( 10, 15 ] 821 0.268% 99.529% ( 15, 22 ] 95 0.031% 99.560% ( 22, 34 ] 13 0.004% 99.564% ( 34, 51 ] 3 0.001% 99.565% ( 51, 76 ] 10 0.003% 99.568% ( 76, 110 ] 288 0.094% 99.662% ( 110, 170 ] 400 0.130% 99.793% ( 170, 250 ] 237 0.077% 99.870% ( 250, 380 ] 165 0.054% 99.924% ( 380, 580 ] 130 0.042% 99.966% ( 580, 870 ] 73 0.024% 99.990% ( 870, 1300 ] 37 0.012% 100.002% ( 1300, 1900 ] 11 0.004% 100.006% ( 1900, 2900 ] 4 0.001% 100.007% ( 2900, 4400 ] 5 0.002% 100.008% ( 4400, 6600 ] 11 0.004% 100.012% ( 6600, 9900 ] 4 0.001% 100.013% ** Level 4 read latency histogram (micros): Count: 185 Average: 745.9459 StdDev: 1722.11 Min: 0 Median: 2.1500 Max: 7005 Percentiles: P50: 2.15 P75: 20.03 P99: 6496.11 P99.9: 7005.00 P99.99: 7005.00 ------------------------------------------------------ [ 0, 1 ] 46 24.865% 24.865% ##### ( 1, 2 ] 45 24.324% 49.189% ##### ( 2, 3 ] 10 5.405% 54.595% # ( 3, 4 ] 10 5.405% 60.000% # ( 4, 6 ] 2 1.081% 61.081% ( 6, 10 ] 3 1.622% 62.703% ( 10, 15 ] 17 9.189% 71.892% ## ( 15, 22 ] 8 4.324% 76.216% # ( 22, 34 ] 2 1.081% 77.297% ( 34, 51 ] 1 0.541% 77.838% ( 51, 76 ] 1 0.541% 78.378% ( 110, 170 ] 1 0.541% 78.919% ( 170, 250 ] 2 1.081% 80.000% ( 250, 380 ] 1 0.541% 80.541% ( 380, 580 ] 2 1.081% 81.622% ( 580, 870 ] 3 1.622% 83.243% ( 870, 1300 ] 1 0.541% 83.784% ( 1300, 1900 ] 4 2.162% 85.946% ( 1900, 2900 ] 2 1.081% 87.027% ( 2900, 4400 ] 5 2.703% 89.730% # ( 4400, 6600 ] 18 9.730% 99.459% ## ( 6600, 9900 ] 1 0.541% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 875.6500 StdDev: 1097.59 Min: 84 Median: 170.0000 Max: 4225 Percentiles: P50: 170.00 P75: 1450.00 P99: 4200.00 P99.9: 4225.00 P99.99: 4225.00 ------------------------------------------------------ ( 76, 110 ] 13 32.500% 32.500% ####### ( 110, 170 ] 7 17.500% 50.000% #### ( 170, 250 ] 3 7.500% 57.500% ## ( 380, 580 ] 1 2.500% 60.000% # ( 580, 870 ] 3 7.500% 67.500% ## ( 870, 1300 ] 2 5.000% 72.500% # ( 1300, 1900 ] 4 10.000% 82.500% ## ( 1900, 2900 ] 4 10.000% 92.500% ## ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 15.2 total, 3.2 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 324.04 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.095 H:M:S, 13.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 307.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:0.613 H:M:S, 19.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/25-21:45:32 ... thread 0: (1000000,6000000) ops and (161862.1,283680.5) ops/second in (6.178100,21.150556) 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/15 4.18 GB 88.1 4.6 0.0 4.6 10.3 5.7 0.0 1.8 138.2 307.6 34.19 32.07 99 0.345 4797K 5051 0.0 0.0 L1 7/7 676.47 MB 0.0 1.4 1.4 0.1 1.4 1.3 0.1 1.0 234.9 233.8 6.17 5.96 2 3.086 1472K 6183 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.7 1.8 241.3 241.3 0.46 0.44 1 0.462 113K 25 0.0 0.0 L3 23/0 985.23 MB 1.0 1.7 0.7 1.0 1.7 0.7 0.1 2.3 207.7 207.6 8.36 7.31 7 1.195 1697K 698 0.0 0.0 L4 164/0 9.49 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 170.6 170.6 1.27 1.03 2 0.635 220K 0 0.0 0.0 L5 1052/0 86.49 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 1265/22 101.78 GB 0.0 8.0 2.4 5.7 13.7 8.0 2.0 2.4 163.3 277.9 50.46 46.81 111 0.455 8299K 11K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.0 2.4 5.7 13.7 8.0 2.0 2.4 163.3 277.9 50.46 46.81 111 0.455 8299K 11K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 8.0 2.4 5.7 8.0 2.3 0.0 0.0 241.4 241.0 34.13 32.30 29 1.177 8299K 11K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 355.0 16.32 14.51 82 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 21.4 total, 21.2 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 13.69 GB write, 656.36 MB/s write, 8.05 GB read, 385.69 MB/s read, 50.5 seconds Interval compaction: 13.69 GB write, 662.94 MB/s write, 8.05 GB read, 389.56 MB/s read, 50.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 9, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 9, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 23, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 9, total-stops: 23, interval: 32 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2058243 Average: 2.3602 StdDev: 11.84 Min: 1 Median: 1.5463 Max: 3782 Percentiles: P50: 1.55 P75: 1.91 P99: 5.88 P99.9: 11.81 P99.99: 109.62 ------------------------------------------------------ [ 0, 1 ] 266129 12.930% 12.930% ### ( 1, 2 ] 1396603 67.854% 80.784% ############## ( 2, 3 ] 241898 11.753% 92.537% ## ( 3, 4 ] 74610 3.625% 96.162% # ( 4, 6 ] 62227 3.023% 99.185% # ( 6, 10 ] 13957 0.678% 99.863% ( 10, 15 ] 2105 0.102% 99.965% ( 15, 22 ] 258 0.013% 99.978% ( 22, 34 ] 42 0.002% 99.980% ( 34, 51 ] 20 0.001% 99.981% ( 51, 76 ] 26 0.001% 99.982% ( 76, 110 ] 164 0.008% 99.990% ( 110, 170 ] 414 0.020% 100.010% ( 170, 250 ] 118 0.006% 100.016% ( 250, 380 ] 79 0.004% 100.020% ( 380, 580 ] 78 0.004% 100.024% ( 580, 870 ] 61 0.003% 100.027% ( 870, 1300 ] 28 0.001% 100.028% ( 1300, 1900 ] 19 0.001% 100.029% ( 1900, 2900 ] 12 0.001% 100.029% ( 2900, 4400 ] 7 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 308102 Average: 2.6938 StdDev: 15.08 Min: 1 Median: 1.6146 Max: 3706 Percentiles: P50: 1.61 P75: 2.00 P99: 8.13 P99.9: 95.13 P99.99: 344.57 ------------------------------------------------------ [ 0, 1 ] 31491 10.221% 10.221% ## ( 1, 2 ] 199410 64.722% 74.943% ############# ( 2, 3 ] 44308 14.381% 89.324% ### ( 3, 4 ] 13796 4.478% 93.802% # ( 4, 6 ] 13727 4.455% 98.257% # ( 6, 10 ] 4294 1.394% 99.651% ( 10, 15 ] 554 0.180% 99.831% ( 15, 22 ] 67 0.022% 99.852% ( 22, 34 ] 16 0.005% 99.858% ( 34, 51 ] 3 0.001% 99.858% ( 51, 76 ] 3 0.001% 99.859% ( 76, 110 ] 222 0.072% 99.932% ( 110, 170 ] 115 0.037% 99.969% ( 170, 250 ] 39 0.013% 99.981% ( 250, 380 ] 36 0.012% 99.993% ( 380, 580 ] 26 0.008% 100.002% ( 580, 870 ] 7 0.002% 100.004% ( 870, 1300 ] 6 0.002% 100.006% ( 1300, 1900 ] 2 0.001% 100.006% ( 1900, 2900 ] 3 0.001% 100.007% ( 2900, 4400 ] 2 0.001% 100.008% ** Level 2 read latency histogram (micros): Count: 40606 Average: 2.3242 StdDev: 31.43 Min: 0 Median: 1.3079 Max: 5501 Percentiles: P50: 1.31 P75: 1.73 P99: 6.18 P99.9: 69.68 P99.99: 716.21 ------------------------------------------------------ [ 0, 1 ] 12931 31.845% 31.845% ###### ( 1, 2 ] 23942 58.962% 90.807% ############ ( 2, 3 ] 1947 4.795% 95.602% # ( 3, 4 ] 845 2.081% 97.683% ( 4, 6 ] 522 1.286% 98.968% ( 6, 10 ] 281 0.692% 99.660% ( 10, 15 ] 57 0.140% 99.801% ( 15, 22 ] 7 0.017% 99.818% ( 22, 34 ] 1 0.002% 99.820% ( 34, 51 ] 4 0.010% 99.830% ( 51, 76 ] 38 0.094% 99.924% ( 76, 110 ] 8 0.020% 99.943% ( 110, 170 ] 1 0.002% 99.946% ( 170, 250 ] 9 0.022% 99.968% ( 250, 380 ] 3 0.007% 99.975% ( 380, 580 ] 5 0.012% 99.988% ( 580, 870 ] 2 0.005% 99.993% ( 870, 1300 ] 1 0.002% 99.995% ( 1900, 2900 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 306770 Average: 3.9579 StdDev: 51.43 Min: 0 Median: 1.6386 Max: 7678 Percentiles: P50: 1.64 P75: 2.17 P99: 9.36 P99.9: 322.67 P99.99: 873.75 ------------------------------------------------------ [ 0, 1 ] 31778 10.359% 10.359% ## ( 1, 2 ] 190418 62.072% 72.431% ############ ( 2, 3 ] 46537 15.170% 87.601% ### ( 3, 4 ] 16081 5.242% 92.843% # ( 4, 6 ] 14641 4.773% 97.615% # ( 6, 10 ] 5049 1.646% 99.261% ( 10, 15 ] 821 0.268% 99.529% ( 15, 22 ] 95 0.031% 99.560% ( 22, 34 ] 13 0.004% 99.564% ( 34, 51 ] 3 0.001% 99.565% ( 51, 76 ] 10 0.003% 99.568% ( 76, 110 ] 288 0.094% 99.662% ( 110, 170 ] 400 0.130% 99.793% ( 170, 250 ] 237 0.077% 99.870% ( 250, 380 ] 165 0.054% 99.924% ( 380, 580 ] 130 0.042% 99.966% ( 580, 870 ] 73 0.024% 99.990% ( 870, 1300 ] 37 0.012% 100.002% ( 1300, 1900 ] 11 0.004% 100.006% ( 1900, 2900 ] 4 0.001% 100.007% ( 2900, 4400 ] 5 0.002% 100.008% ( 4400, 6600 ] 11 0.004% 100.012% ( 6600, 9900 ] 4 0.001% 100.013% ** Level 4 read latency histogram (micros): Count: 185 Average: 745.9459 StdDev: 1722.11 Min: 0 Median: 2.1500 Max: 7005 Percentiles: P50: 2.15 P75: 20.03 P99: 6496.11 P99.9: 7005.00 P99.99: 7005.00 ------------------------------------------------------ [ 0, 1 ] 46 24.865% 24.865% ##### ( 1, 2 ] 45 24.324% 49.189% ##### ( 2, 3 ] 10 5.405% 54.595% # ( 3, 4 ] 10 5.405% 60.000% # ( 4, 6 ] 2 1.081% 61.081% ( 6, 10 ] 3 1.622% 62.703% ( 10, 15 ] 17 9.189% 71.892% ## ( 15, 22 ] 8 4.324% 76.216% # ( 22, 34 ] 2 1.081% 77.297% ( 34, 51 ] 1 0.541% 77.838% ( 51, 76 ] 1 0.541% 78.378% ( 110, 170 ] 1 0.541% 78.919% ( 170, 250 ] 2 1.081% 80.000% ( 250, 380 ] 1 0.541% 80.541% ( 380, 580 ] 2 1.081% 81.622% ( 580, 870 ] 3 1.622% 83.243% ( 870, 1300 ] 1 0.541% 83.784% ( 1300, 1900 ] 4 2.162% 85.946% ( 1900, 2900 ] 2 1.081% 87.027% ( 2900, 4400 ] 5 2.703% 89.730% # ( 4400, 6600 ] 18 9.730% 99.459% ## ( 6600, 9900 ] 1 0.541% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 875.6500 StdDev: 1097.59 Min: 84 Median: 170.0000 Max: 4225 Percentiles: P50: 170.00 P75: 1450.00 P99: 4200.00 P99.9: 4225.00 P99.99: 4225.00 ------------------------------------------------------ ( 76, 110 ] 13 32.500% 32.500% ####### ( 110, 170 ] 7 17.500% 50.000% #### ( 170, 250 ] 3 7.500% 57.500% ## ( 380, 580 ] 1 2.500% 60.000% # ( 580, 870 ] 3 7.500% 67.500% ## ( 870, 1300 ] 2 5.000% 72.500% # ( 1300, 1900 ] 4 10.000% 82.500% ## ( 1900, 2900 ] 4 10.000% 92.500% ## ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 21.4 total, 6.2 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 276.40 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:5.622 H:M:S, 26.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 159.30 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:3.526 H:M:S, 57.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/25-21:45:38 ... thread 0: (1000000,7000000) ops and (174474.5,260396.8) ops/second in (5.731498,26.882054) 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/10 3.20 GB 151.0 5.2 0.0 5.2 11.8 6.6 0.0 1.8 129.4 292.1 41.39 37.12 113 0.366 5436K 5866 0.0 0.0 L1 5/0 600.72 MB 60.1 4.0 3.3 0.7 3.9 3.2 0.1 1.2 231.8 229.7 17.59 16.94 3 5.863 4140K 36K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 2.7 1.8 241.3 241.3 0.46 0.44 1 0.462 113K 25 0.0 0.0 L3 17/0 996.08 MB 1.0 3.4 1.7 1.7 3.4 1.7 1.1 2.0 176.6 176.1 19.54 15.17 15 1.302 3436K 8910 0.0 0.0 L4 178/0 9.75 GB 1.0 1.8 1.7 0.1 1.8 1.7 0.8 1.1 140.4 140.0 13.28 8.59 27 0.492 1893K 4450 0.0 0.0 L5 1072/0 88.15 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1288/10 102.66 GB 0.0 14.5 6.7 7.8 21.0 13.2 7.1 3.2 161.0 233.5 92.26 78.26 159 0.580 15M 55K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.5 6.7 7.8 21.0 13.2 7.1 3.2 161.0 233.5 92.26 78.26 159 0.580 15M 55K 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.5 6.7 7.8 14.5 6.6 0.0 0.0 207.4 206.6 71.63 61.20 65 1.102 15M 55K 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 326.8 20.63 17.05 94 0.219 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): 27.1 total, 26.9 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 21.04 GB write, 794.98 MB/s write, 14.51 GB read, 548.31 MB/s read, 92.3 seconds Interval compaction: 21.04 GB write, 801.26 MB/s write, 14.51 GB read, 552.63 MB/s read, 92.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: 49, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 49, interval: 60 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2625079 Average: 2.5606 StdDev: 19.09 Min: 1 Median: 1.5869 Max: 7899 Percentiles: P50: 1.59 P75: 1.97 P99: 6.56 P99.9: 12.99 P99.99: 130.92 ------------------------------------------------------ [ 0, 1 ] 301688 11.493% 11.493% ## ( 1, 2 ] 1722464 65.616% 77.108% ############# ( 2, 3 ] 344485 13.123% 90.231% ### ( 3, 4 ] 116291 4.430% 94.661% # ( 4, 6 ] 110387 4.205% 98.866% # ( 6, 10 ] 24920 0.949% 99.815% ( 10, 15 ] 3713 0.141% 99.957% ( 15, 22 ] 378 0.014% 99.971% ( 22, 34 ] 52 0.002% 99.973% ( 34, 51 ] 23 0.001% 99.974% ( 51, 76 ] 27 0.001% 99.975% ( 76, 110 ] 211 0.008% 99.983% ( 110, 170 ] 509 0.019% 100.003% ( 170, 250 ] 173 0.007% 100.009% ( 250, 380 ] 134 0.005% 100.014% ( 380, 580 ] 157 0.006% 100.020% ( 580, 870 ] 153 0.006% 100.026% ( 870, 1300 ] 85 0.003% 100.029% ( 1300, 1900 ] 37 0.001% 100.031% ( 1900, 2900 ] 19 0.001% 100.032% ( 2900, 4400 ] 19 0.001% 100.032% ( 4400, 6600 ] 3 0.000% 100.032% ( 6600, 9900 ] 3 0.000% 100.032% ** Level 1 read latency histogram (micros): Count: 708599 Average: 5.0487 StdDev: 84.48 Min: 1 Median: 1.7931 Max: 15603 Percentiles: P50: 1.79 P75: 2.68 P99: 9.16 P99.9: 102.22 P99.99: 540.75 ------------------------------------------------------ [ 0, 1 ] 40875 5.768% 5.768% # ( 1, 2 ] 395188 55.770% 61.539% ########### ( 2, 3 ] 140299 19.799% 81.338% #### ( 3, 4 ] 52836 7.456% 88.795% # ( 4, 6 ] 61007 8.610% 97.404% ## ( 6, 10 ] 14306 2.019% 99.423% ( 10, 15 ] 2828 0.399% 99.822% ( 15, 22 ] 275 0.039% 99.861% ( 22, 34 ] 23 0.003% 99.864% ( 34, 51 ] 9 0.001% 99.866% ( 51, 76 ] 10 0.001% 99.867% ( 76, 110 ] 304 0.043% 99.910% ( 110, 170 ] 171 0.024% 99.934% ( 170, 250 ] 91 0.013% 99.947% ( 250, 380 ] 147 0.021% 99.968% ( 380, 580 ] 198 0.028% 99.995% ( 580, 870 ] 182 0.026% 100.021% ( 870, 1300 ] 131 0.018% 100.040% ( 1300, 1900 ] 80 0.011% 100.051% ( 1900, 2900 ] 100 0.014% 100.065% ( 2900, 4400 ] 119 0.017% 100.082% ( 4400, 6600 ] 45 0.006% 100.088% ( 6600, 9900 ] 12 0.002% 100.090% ( 9900, 14000 ] 2 0.000% 100.090% ( 14000, 22000 ] 1 0.000% 100.090% ** Level 2 read latency histogram (micros): Count: 40606 Average: 2.3242 StdDev: 31.43 Min: 0 Median: 1.3079 Max: 5501 Percentiles: P50: 1.31 P75: 1.73 P99: 6.18 P99.9: 69.68 P99.99: 716.21 ------------------------------------------------------ [ 0, 1 ] 12931 31.845% 31.845% ###### ( 1, 2 ] 23942 58.962% 90.807% ############ ( 2, 3 ] 1947 4.795% 95.602% # ( 3, 4 ] 845 2.081% 97.683% ( 4, 6 ] 522 1.286% 98.968% ( 6, 10 ] 281 0.692% 99.660% ( 10, 15 ] 57 0.140% 99.801% ( 15, 22 ] 7 0.017% 99.818% ( 22, 34 ] 1 0.002% 99.820% ( 34, 51 ] 4 0.010% 99.830% ( 51, 76 ] 38 0.094% 99.924% ( 76, 110 ] 8 0.020% 99.943% ( 110, 170 ] 1 0.002% 99.946% ( 170, 250 ] 9 0.022% 99.968% ( 250, 380 ] 3 0.007% 99.975% ( 380, 580 ] 5 0.012% 99.988% ( 580, 870 ] 2 0.005% 99.993% ( 870, 1300 ] 1 0.002% 99.995% ( 1900, 2900 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 773183 Average: 5.8848 StdDev: 82.55 Min: 0 Median: 1.8710 Max: 13078 Percentiles: P50: 1.87 P75: 2.84 P99: 9.40 P99.9: 346.18 P99.99: 612.95 ------------------------------------------------------ [ 0, 1 ] 38140 4.933% 4.933% # ( 1, 2 ] 400045 51.740% 56.673% ########## ( 2, 3 ] 167828 21.706% 78.379% #### ( 3, 4 ] 68732 8.889% 87.268% ## ( 4, 6 ] 77261 9.993% 97.261% ## ( 6, 10 ] 15811 2.045% 99.306% ( 10, 15 ] 2665 0.345% 99.651% ( 15, 22 ] 288 0.037% 99.688% ( 22, 34 ] 37 0.005% 99.693% ( 34, 51 ] 13 0.002% 99.694% ( 51, 76 ] 13 0.002% 99.696% ( 76, 110 ] 300 0.039% 99.735% ( 110, 170 ] 524 0.068% 99.803% ( 170, 250 ] 394 0.051% 99.854% ( 250, 380 ] 485 0.063% 99.916% ( 380, 580 ] 519 0.067% 99.983% ( 580, 870 ] 446 0.058% 100.041% ( 870, 1300 ] 281 0.036% 100.077% ( 1300, 1900 ] 127 0.016% 100.094% ( 1900, 2900 ] 97 0.013% 100.106% ( 2900, 4400 ] 119 0.015% 100.122% ( 4400, 6600 ] 37 0.005% 100.127% ( 6600, 9900 ] 12 0.002% 100.128% ( 9900, 14000 ] 2 0.000% 100.128% ** Level 4 read latency histogram (micros): Count: 8923 Average: 93.8508 StdDev: 545.51 Min: 0 Median: 1.9518 Max: 14566 Percentiles: P50: 1.95 P75: 3.22 P99: 2894.39 P99.9: 6353.41 P99.99: 9311.08 ------------------------------------------------------ [ 0, 1 ] 366 4.102% 4.102% # ( 1, 2 ] 4303 48.224% 52.325% ########## ( 2, 3 ] 1812 20.307% 72.633% #### ( 3, 4 ] 978 10.960% 83.593% ## ( 4, 6 ] 655 7.341% 90.934% # ( 6, 10 ] 181 2.028% 92.962% ( 10, 15 ] 60 0.672% 93.634% ( 15, 22 ] 11 0.123% 93.758% ( 22, 34 ] 2 0.022% 93.780% ( 34, 51 ] 1 0.011% 93.791% ( 51, 76 ] 3 0.034% 93.825% ( 76, 110 ] 1 0.011% 93.836% ( 110, 170 ] 31 0.347% 94.184% ( 170, 250 ] 30 0.336% 94.520% ( 250, 380 ] 51 0.572% 95.091% ( 380, 580 ] 88 0.986% 96.078% ( 580, 870 ] 99 1.109% 97.187% ( 870, 1300 ] 71 0.796% 97.983% ( 1300, 1900 ] 50 0.560% 98.543% ( 1900, 2900 ] 41 0.459% 99.003% ( 2900, 4400 ] 49 0.549% 99.552% ( 4400, 6600 ] 35 0.392% 99.944% ( 6600, 9900 ] 5 0.056% 100.000% ( 14000, 22000 ] 1 0.011% 100.011% ** Level 5 read latency histogram (micros): Count: 140 Average: 1230.0429 StdDev: 1368.70 Min: 84 Median: 537.1429 Max: 5942 Percentiles: P50: 537.14 P75: 1976.92 P99: 5573.33 P99.9: 5942.00 P99.99: 5942.00 ------------------------------------------------------ ( 76, 110 ] 15 10.714% 10.714% ## ( 110, 170 ] 10 7.143% 17.857% # ( 170, 250 ] 18 12.857% 30.714% ### ( 250, 380 ] 16 11.429% 42.143% ## ( 380, 580 ] 14 10.000% 52.143% ## ( 580, 870 ] 12 8.571% 60.714% ## ( 870, 1300 ] 8 5.714% 66.429% # ( 1300, 1900 ] 11 7.857% 74.286% ## ( 1900, 2900 ] 13 9.286% 83.571% ## ( 2900, 4400 ] 20 14.286% 97.857% ### ( 4400, 6600 ] 3 2.143% 100.000% ** DB Stats ** Uptime(secs): 27.1 total, 5.7 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 254.26 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:8.578 H:M:S, 31.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 171.72 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.956 H:M:S, 51.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/25-21:45:41 ... thread 0: (1000000,8000000) ops and (337907.0,268083.5) ops/second in (2.959394,29.841448) 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/16 4.17 GB 0.0 7.5 0.0 7.5 15.1 7.6 0.0 2.0 143.2 287.3 53.66 48.57 131 0.410 7802K 15K 0.0 0.0 L1 5/5 600.72 MB 0.0 4.0 3.3 0.7 3.9 3.2 0.1 1.2 231.8 229.7 17.59 16.94 3 5.863 4140K 36K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 2.7 1.8 241.3 241.3 0.46 0.44 1 0.462 113K 25 0.0 0.0 L3 17/0 996.08 MB 1.0 3.4 1.7 1.7 3.4 1.7 1.1 2.0 176.6 176.1 19.54 15.17 15 1.302 3436K 8910 0.0 0.0 L4 178/0 9.75 GB 1.0 1.8 1.7 0.1 1.8 1.7 0.8 1.1 140.4 140.0 13.28 8.59 27 0.492 1893K 4450 0.0 0.0 L5 1072/0 88.15 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1288/21 103.64 GB 0.0 16.8 6.7 10.1 24.3 14.2 7.1 3.2 164.4 237.9 104.53 89.71 177 0.591 17M 65K 0.0 0.0 Int 0/0 0.00 KB 0.0 16.8 6.7 10.1 24.3 14.2 7.1 3.2 164.4 237.9 104.53 89.71 177 0.591 17M 65K 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 16.8 6.7 10.1 16.7 6.6 0.0 0.0 211.9 211.1 81.11 70.16 69 1.176 17M 65K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.6 7.6 0.0 0.0 0.0 330.9 23.42 19.55 108 0.217 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): 30.1 total, 29.8 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 24.29 GB write, 827.41 MB/s write, 16.78 GB read, 571.82 MB/s read, 104.5 seconds Interval compaction: 24.29 GB write, 833.29 MB/s write, 16.78 GB read, 575.88 MB/s read, 104.5 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: 54, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 54, interval: 65 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2861497 Average: 2.5386 StdDev: 19.03 Min: 1 Median: 1.5709 Max: 7899 Percentiles: P50: 1.57 P75: 1.95 P99: 6.37 P99.9: 13.24 P99.99: 147.05 ------------------------------------------------------ [ 0, 1 ] 354825 12.400% 12.400% ## ( 1, 2 ] 1884745 65.866% 78.266% ############# ( 2, 3 ] 357413 12.490% 90.756% ## ( 3, 4 ] 120621 4.215% 94.971% # ( 4, 6 ] 112895 3.945% 98.917% # ( 6, 10 ] 25649 0.896% 99.813% ( 10, 15 ] 3846 0.134% 99.947% ( 15, 22 ] 398 0.014% 99.961% ( 22, 34 ] 55 0.002% 99.963% ( 34, 51 ] 25 0.001% 99.964% ( 51, 76 ] 33 0.001% 99.965% ( 76, 110 ] 291 0.010% 99.976% ( 110, 170 ] 675 0.024% 99.999% ( 170, 250 ] 216 0.008% 100.007% ( 250, 380 ] 156 0.005% 100.012% ( 380, 580 ] 172 0.006% 100.018% ( 580, 870 ] 165 0.006% 100.024% ( 870, 1300 ] 90 0.003% 100.027% ( 1300, 1900 ] 40 0.001% 100.028% ( 1900, 2900 ] 21 0.001% 100.029% ( 2900, 4400 ] 22 0.001% 100.030% ( 4400, 6600 ] 3 0.000% 100.030% ( 6600, 9900 ] 3 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 708600 Average: 5.0489 StdDev: 84.48 Min: 1 Median: 1.7931 Max: 15603 Percentiles: P50: 1.79 P75: 2.68 P99: 9.16 P99.9: 102.33 P99.99: 540.75 ------------------------------------------------------ [ 0, 1 ] 40875 5.768% 5.768% # ( 1, 2 ] 395188 55.770% 61.539% ########### ( 2, 3 ] 140299 19.799% 81.338% #### ( 3, 4 ] 52836 7.456% 88.795% # ( 4, 6 ] 61007 8.610% 97.404% ## ( 6, 10 ] 14306 2.019% 99.423% ( 10, 15 ] 2828 0.399% 99.822% ( 15, 22 ] 275 0.039% 99.861% ( 22, 34 ] 23 0.003% 99.864% ( 34, 51 ] 9 0.001% 99.865% ( 51, 76 ] 10 0.001% 99.867% ( 76, 110 ] 304 0.043% 99.910% ( 110, 170 ] 172 0.024% 99.934% ( 170, 250 ] 91 0.013% 99.947% ( 250, 380 ] 147 0.021% 99.968% ( 380, 580 ] 198 0.028% 99.995% ( 580, 870 ] 182 0.026% 100.021% ( 870, 1300 ] 131 0.018% 100.040% ( 1300, 1900 ] 80 0.011% 100.051% ( 1900, 2900 ] 100 0.014% 100.065% ( 2900, 4400 ] 119 0.017% 100.082% ( 4400, 6600 ] 45 0.006% 100.088% ( 6600, 9900 ] 12 0.002% 100.090% ( 9900, 14000 ] 2 0.000% 100.090% ( 14000, 22000 ] 1 0.000% 100.090% ** Level 2 read latency histogram (micros): Count: 40606 Average: 2.3242 StdDev: 31.43 Min: 0 Median: 1.3079 Max: 5501 Percentiles: P50: 1.31 P75: 1.73 P99: 6.18 P99.9: 69.68 P99.99: 716.21 ------------------------------------------------------ [ 0, 1 ] 12931 31.845% 31.845% ###### ( 1, 2 ] 23942 58.962% 90.807% ############ ( 2, 3 ] 1947 4.795% 95.602% # ( 3, 4 ] 845 2.081% 97.683% ( 4, 6 ] 522 1.286% 98.968% ( 6, 10 ] 281 0.692% 99.660% ( 10, 15 ] 57 0.140% 99.801% ( 15, 22 ] 7 0.017% 99.818% ( 22, 34 ] 1 0.002% 99.820% ( 34, 51 ] 4 0.010% 99.830% ( 51, 76 ] 38 0.094% 99.924% ( 76, 110 ] 8 0.020% 99.943% ( 110, 170 ] 1 0.002% 99.946% ( 170, 250 ] 9 0.022% 99.968% ( 250, 380 ] 3 0.007% 99.975% ( 380, 580 ] 5 0.012% 99.988% ( 580, 870 ] 2 0.005% 99.993% ( 870, 1300 ] 1 0.002% 99.995% ( 1900, 2900 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 773183 Average: 5.8848 StdDev: 82.55 Min: 0 Median: 1.8710 Max: 13078 Percentiles: P50: 1.87 P75: 2.84 P99: 9.40 P99.9: 346.18 P99.99: 612.95 ------------------------------------------------------ [ 0, 1 ] 38140 4.933% 4.933% # ( 1, 2 ] 400045 51.740% 56.673% ########## ( 2, 3 ] 167828 21.706% 78.379% #### ( 3, 4 ] 68732 8.889% 87.268% ## ( 4, 6 ] 77261 9.993% 97.261% ## ( 6, 10 ] 15811 2.045% 99.306% ( 10, 15 ] 2665 0.345% 99.651% ( 15, 22 ] 288 0.037% 99.688% ( 22, 34 ] 37 0.005% 99.693% ( 34, 51 ] 13 0.002% 99.694% ( 51, 76 ] 13 0.002% 99.696% ( 76, 110 ] 300 0.039% 99.735% ( 110, 170 ] 524 0.068% 99.803% ( 170, 250 ] 394 0.051% 99.854% ( 250, 380 ] 485 0.063% 99.916% ( 380, 580 ] 519 0.067% 99.983% ( 580, 870 ] 446 0.058% 100.041% ( 870, 1300 ] 281 0.036% 100.077% ( 1300, 1900 ] 127 0.016% 100.094% ( 1900, 2900 ] 97 0.013% 100.106% ( 2900, 4400 ] 119 0.015% 100.122% ( 4400, 6600 ] 37 0.005% 100.127% ( 6600, 9900 ] 12 0.002% 100.128% ( 9900, 14000 ] 2 0.000% 100.128% ** Level 4 read latency histogram (micros): Count: 8923 Average: 93.8508 StdDev: 545.51 Min: 0 Median: 1.9518 Max: 14566 Percentiles: P50: 1.95 P75: 3.22 P99: 2894.39 P99.9: 6353.41 P99.99: 9311.08 ------------------------------------------------------ [ 0, 1 ] 366 4.102% 4.102% # ( 1, 2 ] 4303 48.224% 52.325% ########## ( 2, 3 ] 1812 20.307% 72.633% #### ( 3, 4 ] 978 10.960% 83.593% ## ( 4, 6 ] 655 7.341% 90.934% # ( 6, 10 ] 181 2.028% 92.962% ( 10, 15 ] 60 0.672% 93.634% ( 15, 22 ] 11 0.123% 93.758% ( 22, 34 ] 2 0.022% 93.780% ( 34, 51 ] 1 0.011% 93.791% ( 51, 76 ] 3 0.034% 93.825% ( 76, 110 ] 1 0.011% 93.836% ( 110, 170 ] 31 0.347% 94.184% ( 170, 250 ] 30 0.336% 94.520% ( 250, 380 ] 51 0.572% 95.091% ( 380, 580 ] 88 0.986% 96.078% ( 580, 870 ] 99 1.109% 97.187% ( 870, 1300 ] 71 0.796% 97.983% ( 1300, 1900 ] 50 0.560% 98.543% ( 1900, 2900 ] 41 0.459% 99.003% ( 2900, 4400 ] 49 0.549% 99.552% ( 4400, 6600 ] 35 0.392% 99.944% ( 6600, 9900 ] 5 0.056% 100.000% ( 14000, 22000 ] 1 0.011% 100.011% ** Level 5 read latency histogram (micros): Count: 140 Average: 1230.0429 StdDev: 1368.70 Min: 84 Median: 537.1429 Max: 5942 Percentiles: P50: 537.14 P75: 1976.92 P99: 5573.33 P99.9: 5942.00 P99.99: 5942.00 ------------------------------------------------------ ( 76, 110 ] 15 10.714% 10.714% ## ( 110, 170 ] 10 7.143% 17.857% # ( 170, 250 ] 18 12.857% 30.714% ### ( 250, 380 ] 16 11.429% 42.143% ## ( 380, 580 ] 14 10.000% 52.143% ## ( 580, 870 ] 12 8.571% 60.714% ## ( 870, 1300 ] 8 5.714% 66.429% # ( 1300, 1900 ] 11 7.857% 74.286% ## ( 1900, 2900 ] 13 9.286% 83.571% ## ( 2900, 4400 ] 20 14.286% 97.857% ### ( 4400, 6600 ] 3 2.143% 100.000% ** DB Stats ** Uptime(secs): 30.1 total, 3.0 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 261.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:9.006 H:M:S, 30.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 332.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:0.428 H:M:S, 14.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/25-21:45:55 ... thread 0: (1000000,9000000) ops and (66961.0,201002.7) ops/second in (14.934063,44.775511) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/12 5.21 GB 131.5 9.7 0.0 9.7 18.3 8.6 0.0 2.1 152.3 287.0 65.33 59.59 151 0.433 10M 23K 0.0 0.0 L1 5/5 600.72 MB 0.0 4.0 3.3 0.7 3.9 3.2 0.1 1.2 231.8 229.7 17.59 16.94 3 5.863 4140K 36K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 2.7 1.8 241.3 241.3 0.46 0.44 1 0.462 113K 25 0.0 0.0 L3 17/0 996.08 MB 1.0 3.4 1.7 1.7 3.4 1.7 1.1 2.0 176.6 176.1 19.54 15.17 15 1.302 3436K 8910 0.0 0.0 L4 178/0 9.75 GB 1.0 1.8 1.7 0.1 1.8 1.7 0.8 1.1 140.4 140.0 13.28 8.59 27 0.492 1893K 4450 0.0 0.0 L5 1072/0 88.15 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1286/17 104.68 GB 0.0 19.0 6.7 12.3 27.5 15.2 7.1 3.2 167.4 242.7 116.19 100.73 197 0.590 19M 73K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.0 6.7 12.3 27.5 15.2 7.1 3.2 167.4 242.7 116.19 100.73 197 0.590 19M 73K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 19.0 6.7 12.3 18.9 6.6 0.0 0.0 216.9 216.1 89.67 78.44 74 1.212 19M 73K 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 332.6 26.52 22.28 123 0.216 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 45.0 total, 44.8 interval Flush(GB): cumulative 8.613, interval 8.613 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 27.54 GB write, 626.77 MB/s write, 19.00 GB read, 432.39 MB/s read, 116.2 seconds Interval compaction: 27.54 GB write, 629.74 MB/s write, 19.00 GB read, 434.44 MB/s read, 116.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 17, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 17, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 57, pending-compaction-bytes-delays: 4, pending-compaction-bytes-stops: 0, total-delays: 21, total-stops: 57, interval: 78 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4268586 Average: 2.5275 StdDev: 17.19 Min: 1 Median: 1.5451 Max: 7899 Percentiles: P50: 1.55 P75: 1.92 P99: 6.56 P99.9: 19.40 P99.99: 182.83 ------------------------------------------------------ [ 0, 1 ] 571617 13.391% 13.391% ### ( 1, 2 ] 2866716 67.158% 80.550% ############# ( 2, 3 ] 488433 11.443% 91.992% ## ( 3, 4 ] 154579 3.621% 95.614% # ( 4, 6 ] 139118 3.259% 98.873% # ( 6, 10 ] 38613 0.905% 99.777% ( 10, 15 ] 4859 0.114% 99.891% ( 15, 22 ] 612 0.014% 99.905% ( 22, 34 ] 78 0.002% 99.907% ( 34, 51 ] 31 0.001% 99.908% ( 51, 76 ] 37 0.001% 99.909% ( 76, 110 ] 1284 0.030% 99.939% ( 110, 170 ] 2099 0.049% 99.988% ( 170, 250 ] 531 0.012% 100.000% ( 250, 380 ] 378 0.009% 100.009% ( 380, 580 ] 301 0.007% 100.016% ( 580, 870 ] 211 0.005% 100.021% ( 870, 1300 ] 101 0.002% 100.024% ( 1300, 1900 ] 44 0.001% 100.025% ( 1900, 2900 ] 27 0.001% 100.025% ( 2900, 4400 ] 26 0.001% 100.026% ( 4400, 6600 ] 3 0.000% 100.026% ( 6600, 9900 ] 3 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 742263 Average: 4.9210 StdDev: 82.56 Min: 1 Median: 1.7669 Max: 15603 Percentiles: P50: 1.77 P75: 2.63 P99: 9.14 P99.9: 103.80 P99.99: 538.19 ------------------------------------------------------ [ 0, 1 ] 51432 6.929% 6.929% # ( 1, 2 ] 416873 56.162% 63.092% ########### ( 2, 3 ] 140531 18.933% 82.024% #### ( 3, 4 ] 53232 7.172% 89.196% # ( 4, 6 ] 61225 8.248% 97.444% ## ( 6, 10 ] 14720 1.983% 99.427% ( 10, 15 ] 2849 0.384% 99.811% ( 15, 22 ] 285 0.038% 99.850% ( 22, 34 ] 25 0.003% 99.853% ( 34, 51 ] 10 0.001% 99.854% ( 51, 76 ] 10 0.001% 99.856% ( 76, 110 ] 402 0.054% 99.910% ( 110, 170 ] 197 0.027% 99.936% ( 170, 250 ] 91 0.012% 99.949% ( 250, 380 ] 147 0.020% 99.968% ( 380, 580 ] 202 0.027% 99.996% ( 580, 870 ] 182 0.025% 100.020% ( 870, 1300 ] 131 0.018% 100.038% ( 1300, 1900 ] 80 0.011% 100.049% ( 1900, 2900 ] 100 0.013% 100.062% ( 2900, 4400 ] 119 0.016% 100.078% ( 4400, 6600 ] 45 0.006% 100.084% ( 6600, 9900 ] 12 0.002% 100.086% ( 9900, 14000 ] 2 0.000% 100.086% ( 14000, 22000 ] 1 0.000% 100.086% ** Level 2 read latency histogram (micros): Count: 40606 Average: 2.3242 StdDev: 31.43 Min: 0 Median: 1.3079 Max: 5501 Percentiles: P50: 1.31 P75: 1.73 P99: 6.18 P99.9: 69.68 P99.99: 716.21 ------------------------------------------------------ [ 0, 1 ] 12931 31.845% 31.845% ###### ( 1, 2 ] 23942 58.962% 90.807% ############ ( 2, 3 ] 1947 4.795% 95.602% # ( 3, 4 ] 845 2.081% 97.683% ( 4, 6 ] 522 1.286% 98.968% ( 6, 10 ] 281 0.692% 99.660% ( 10, 15 ] 57 0.140% 99.801% ( 15, 22 ] 7 0.017% 99.818% ( 22, 34 ] 1 0.002% 99.820% ( 34, 51 ] 4 0.010% 99.830% ( 51, 76 ] 38 0.094% 99.924% ( 76, 110 ] 8 0.020% 99.943% ( 110, 170 ] 1 0.002% 99.946% ( 170, 250 ] 9 0.022% 99.968% ( 250, 380 ] 3 0.007% 99.975% ( 380, 580 ] 5 0.012% 99.988% ( 580, 870 ] 2 0.005% 99.993% ( 870, 1300 ] 1 0.002% 99.995% ( 1900, 2900 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 773183 Average: 5.8848 StdDev: 82.55 Min: 0 Median: 1.8710 Max: 13078 Percentiles: P50: 1.87 P75: 2.84 P99: 9.40 P99.9: 346.18 P99.99: 612.95 ------------------------------------------------------ [ 0, 1 ] 38140 4.933% 4.933% # ( 1, 2 ] 400045 51.740% 56.673% ########## ( 2, 3 ] 167828 21.706% 78.379% #### ( 3, 4 ] 68732 8.889% 87.268% ## ( 4, 6 ] 77261 9.993% 97.261% ## ( 6, 10 ] 15811 2.045% 99.306% ( 10, 15 ] 2665 0.345% 99.651% ( 15, 22 ] 288 0.037% 99.688% ( 22, 34 ] 37 0.005% 99.693% ( 34, 51 ] 13 0.002% 99.694% ( 51, 76 ] 13 0.002% 99.696% ( 76, 110 ] 300 0.039% 99.735% ( 110, 170 ] 524 0.068% 99.803% ( 170, 250 ] 394 0.051% 99.854% ( 250, 380 ] 485 0.063% 99.916% ( 380, 580 ] 519 0.067% 99.983% ( 580, 870 ] 446 0.058% 100.041% ( 870, 1300 ] 281 0.036% 100.077% ( 1300, 1900 ] 127 0.016% 100.094% ( 1900, 2900 ] 97 0.013% 100.106% ( 2900, 4400 ] 119 0.015% 100.122% ( 4400, 6600 ] 37 0.005% 100.127% ( 6600, 9900 ] 12 0.002% 100.128% ( 9900, 14000 ] 2 0.000% 100.128% ** Level 4 read latency histogram (micros): Count: 8923 Average: 93.8508 StdDev: 545.51 Min: 0 Median: 1.9518 Max: 14566 Percentiles: P50: 1.95 P75: 3.22 P99: 2894.39 P99.9: 6353.41 P99.99: 9311.08 ------------------------------------------------------ [ 0, 1 ] 366 4.102% 4.102% # ( 1, 2 ] 4303 48.224% 52.325% ########## ( 2, 3 ] 1812 20.307% 72.633% #### ( 3, 4 ] 978 10.960% 83.593% ## ( 4, 6 ] 655 7.341% 90.934% # ( 6, 10 ] 181 2.028% 92.962% ( 10, 15 ] 60 0.672% 93.634% ( 15, 22 ] 11 0.123% 93.758% ( 22, 34 ] 2 0.022% 93.780% ( 34, 51 ] 1 0.011% 93.791% ( 51, 76 ] 3 0.034% 93.825% ( 76, 110 ] 1 0.011% 93.836% ( 110, 170 ] 31 0.347% 94.184% ( 170, 250 ] 30 0.336% 94.520% ( 250, 380 ] 51 0.572% 95.091% ( 380, 580 ] 88 0.986% 96.078% ( 580, 870 ] 99 1.109% 97.187% ( 870, 1300 ] 71 0.796% 97.983% ( 1300, 1900 ] 50 0.560% 98.543% ( 1900, 2900 ] 41 0.459% 99.003% ( 2900, 4400 ] 49 0.549% 99.552% ( 4400, 6600 ] 35 0.392% 99.944% ( 6600, 9900 ] 5 0.056% 100.000% ( 14000, 22000 ] 1 0.011% 100.011% ** Level 5 read latency histogram (micros): Count: 140 Average: 1230.0429 StdDev: 1368.70 Min: 84 Median: 537.1429 Max: 5942 Percentiles: P50: 537.14 P75: 1976.92 P99: 5573.33 P99.9: 5942.00 P99.99: 5942.00 ------------------------------------------------------ ( 76, 110 ] 15 10.714% 10.714% ## ( 110, 170 ] 10 7.143% 17.857% # ( 170, 250 ] 18 12.857% 30.714% ### ( 250, 380 ] 16 11.429% 42.143% ## ( 380, 580 ] 14 10.000% 52.143% ## ( 580, 870 ] 12 8.571% 60.714% ## ( 870, 1300 ] 8 5.714% 66.429% # ( 1300, 1900 ] 11 7.857% 74.286% ## ( 1900, 2900 ] 13 9.286% 83.571% ## ( 2900, 4400 ] 20 14.286% 97.857% ### ( 4400, 6600 ] 3 2.143% 100.000% ** DB Stats ** Uptime(secs): 45.0 total, 14.9 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 196.88 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:20.817 H:M:S, 46.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 65.90 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:11.811 H:M:S, 79.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 2024/07/25-21:46:09 ... thread 0: (1000000,10000000) ops and (74225.2,171679.6) ops/second in (13.472515,58.248026) 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/7 2.15 GB 50.3 10.1 0.0 10.1 19.5 9.5 0.0 2.1 143.2 277.4 72.12 63.51 163 0.442 10M 23K 0.0 0.0 L1 13/13 1.35 GB 0.0 8.5 7.2 1.3 8.4 7.1 0.1 1.2 224.0 220.7 38.82 36.47 4 9.706 8744K 41K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 5.8 1.8 241.3 241.3 0.46 0.44 1 0.462 113K 25 0.0 0.0 L3 13/1 1004.04 MB 0.9 5.8 3.1 2.8 5.8 3.0 2.8 1.9 154.1 153.1 38.70 27.44 27 1.433 5657K 31K 0.0 0.0 L4 174/5 9.79 GB 1.0 6.4 4.7 1.7 6.4 4.7 0.8 1.4 131.6 130.4 49.97 30.32 57 0.877 6679K 58K 0.0 0.0 L5 1108/0 91.11 GB 0.9 0.0 0.0 0.0 0.0 0.0 5.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1318/26 105.37 GB 0.0 30.9 15.0 15.9 40.2 24.2 14.8 4.2 158.3 205.6 200.08 158.18 252 0.794 31M 155K 0.0 0.0 Int 0/0 0.00 KB 0.0 30.9 15.0 15.9 40.2 24.2 14.8 4.2 158.3 205.6 200.08 158.18 252 0.794 31M 155K 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 30.9 15.0 15.9 30.7 14.8 0.0 0.0 188.0 186.6 168.46 133.45 118 1.428 31M 155K 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 306.8 31.62 24.73 134 0.236 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 58.5 total, 58.2 interval Flush(GB): cumulative 9.474, interval 9.474 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 40.17 GB write, 703.52 MB/s write, 30.93 GB read, 541.85 MB/s read, 200.1 seconds Interval compaction: 40.17 GB write, 706.08 MB/s write, 30.93 GB read, 543.82 MB/s read, 200.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 17, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 17, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 84, pending-compaction-bytes-delays: 22, pending-compaction-bytes-stops: 0, total-delays: 39, total-stops: 84, interval: 123 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4804894 Average: 3.0918 StdDev: 42.51 Min: 1 Median: 1.5694 Max: 17876 Percentiles: P50: 1.57 P75: 1.95 P99: 7.80 P99.9: 134.14 P99.99: 378.97 ------------------------------------------------------ [ 0, 1 ] 612453 12.746% 12.746% ### ( 1, 2 ] 3143774 65.429% 78.175% ############# ( 2, 3 ] 595913 12.402% 90.577% ## ( 3, 4 ] 191835 3.992% 94.570% # ( 4, 6 ] 189322 3.940% 98.510% # ( 6, 10 ] 52263 1.088% 99.598% ( 10, 15 ] 7739 0.161% 99.759% ( 15, 22 ] 959 0.020% 99.779% ( 22, 34 ] 100 0.002% 99.781% ( 34, 51 ] 36 0.001% 99.781% ( 51, 76 ] 66 0.001% 99.783% ( 76, 110 ] 3786 0.079% 99.862% ( 110, 170 ] 4583 0.095% 99.957% ( 170, 250 ] 897 0.019% 99.976% ( 250, 380 ] 694 0.014% 99.990% ( 380, 580 ] 601 0.013% 100.003% ( 580, 870 ] 378 0.008% 100.011% ( 870, 1300 ] 206 0.004% 100.015% ( 1300, 1900 ] 109 0.002% 100.017% ( 1900, 2900 ] 128 0.003% 100.020% ( 2900, 4400 ] 183 0.004% 100.024% ( 4400, 6600 ] 52 0.001% 100.025% ( 6600, 9900 ] 28 0.001% 100.025% ( 9900, 14000 ] 5 0.000% 100.025% ( 14000, 22000 ] 3 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 1617566 Average: 6.6760 StdDev: 122.62 Min: 1 Median: 1.8565 Max: 17994 Percentiles: P50: 1.86 P75: 2.87 P99: 9.65 P99.9: 148.70 P99.99: 577.27 ------------------------------------------------------ [ 0, 1 ] 98140 6.067% 6.067% # ( 1, 2 ] 829697 51.293% 57.360% ########## ( 2, 3 ] 327314 20.235% 77.595% #### ( 3, 4 ] 141520 8.749% 86.344% ## ( 4, 6 ] 168861 10.439% 96.783% ## ( 6, 10 ] 39281 2.428% 99.212% ( 10, 15 ] 8390 0.519% 99.730% ( 15, 22 ] 905 0.056% 99.786% ( 22, 34 ] 76 0.005% 99.791% ( 34, 51 ] 28 0.002% 99.793% ( 51, 76 ] 52 0.003% 99.796% ( 76, 110 ] 1202 0.074% 99.870% ( 110, 170 ] 748 0.046% 99.916% ( 170, 250 ] 232 0.014% 99.931% ( 250, 380 ] 398 0.025% 99.955% ( 380, 580 ] 568 0.035% 99.990% ( 580, 870 ] 622 0.038% 100.029% ( 870, 1300 ] 490 0.030% 100.059% ( 1300, 1900 ] 265 0.016% 100.076% ( 1900, 2900 ] 345 0.021% 100.097% ( 2900, 4400 ] 418 0.026% 100.123% ( 4400, 6600 ] 155 0.010% 100.132% ( 6600, 9900 ] 70 0.004% 100.137% ( 9900, 14000 ] 17 0.001% 100.138% ( 14000, 22000 ] 19 0.001% 100.139% ** Level 2 read latency histogram (micros): Count: 40606 Average: 2.3242 StdDev: 31.43 Min: 0 Median: 1.3079 Max: 5501 Percentiles: P50: 1.31 P75: 1.73 P99: 6.18 P99.9: 69.68 P99.99: 716.21 ------------------------------------------------------ [ 0, 1 ] 12931 31.845% 31.845% ###### ( 1, 2 ] 23942 58.962% 90.807% ############ ( 2, 3 ] 1947 4.795% 95.602% # ( 3, 4 ] 845 2.081% 97.683% ( 4, 6 ] 522 1.286% 98.968% ( 6, 10 ] 281 0.692% 99.660% ( 10, 15 ] 57 0.140% 99.801% ( 15, 22 ] 7 0.017% 99.818% ( 22, 34 ] 1 0.002% 99.820% ( 34, 51 ] 4 0.010% 99.830% ( 51, 76 ] 38 0.094% 99.924% ( 76, 110 ] 8 0.020% 99.943% ( 110, 170 ] 1 0.002% 99.946% ( 170, 250 ] 9 0.022% 99.968% ( 250, 380 ] 3 0.007% 99.975% ( 380, 580 ] 5 0.012% 99.988% ( 580, 870 ] 2 0.005% 99.993% ( 870, 1300 ] 1 0.002% 99.995% ( 1900, 2900 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 1479584 Average: 5.4430 StdDev: 83.66 Min: 0 Median: 1.9695 Max: 15659 Percentiles: P50: 1.97 P75: 3.00 P99: 9.15 P99.9: 124.16 P99.99: 347.96 ------------------------------------------------------ [ 0, 1 ] 46192 3.122% 3.122% # ( 1, 2 ] 715428 48.353% 51.475% ########## ( 2, 3 ] 347986 23.519% 74.994% ##### ( 3, 4 ] 151437 10.235% 85.230% ## ( 4, 6 ] 178887 12.090% 97.320% ## ( 6, 10 ] 31595 2.135% 99.455% ( 10, 15 ] 5449 0.368% 99.824% ( 15, 22 ] 561 0.038% 99.862% ( 22, 34 ] 52 0.004% 99.865% ( 34, 51 ] 24 0.002% 99.867% ( 51, 76 ] 50 0.003% 99.870% ( 76, 110 ] 311 0.021% 99.891% ( 110, 170 ] 561 0.038% 99.929% ( 170, 250 ] 466 0.031% 99.960% ( 250, 380 ] 580 0.039% 100.000% ( 380, 580 ] 672 0.045% 100.045% ( 580, 870 ] 605 0.041% 100.086% ( 870, 1300 ] 391 0.026% 100.112% ( 1300, 1900 ] 193 0.013% 100.125% ( 1900, 2900 ] 157 0.011% 100.136% ( 2900, 4400 ] 217 0.015% 100.151% ( 4400, 6600 ] 63 0.004% 100.155% ( 6600, 9900 ] 25 0.002% 100.157% ( 9900, 14000 ] 3 0.000% 100.157% ( 14000, 22000 ] 6 0.000% 100.157% ** Level 4 read latency histogram (micros): Count: 436399 Average: 16.4059 StdDev: 188.90 Min: 0 Median: 2.0988 Max: 14566 Percentiles: P50: 2.10 P75: 3.29 P99: 16.38 P99.9: 1893.47 P99.99: 3181.65 ------------------------------------------------------ [ 0, 1 ] 7767 1.780% 1.780% ( 1, 2 ] 199910 45.809% 47.589% ######### ( 2, 3 ] 106493 24.403% 71.991% ##### ( 3, 4 ] 46034 10.549% 82.540% ## ( 4, 6 ] 56169 12.871% 95.411% ### ( 6, 10 ] 12344 2.829% 98.240% # ( 10, 15 ] 3261 0.747% 98.987% ( 15, 22 ] 289 0.066% 99.053% ( 22, 34 ] 28 0.006% 99.060% ( 34, 51 ] 13 0.003% 99.063% ( 51, 76 ] 19 0.004% 99.067% ( 76, 110 ] 58 0.013% 99.080% ( 110, 170 ] 154 0.035% 99.115% ( 170, 250 ] 235 0.054% 99.169% ( 250, 380 ] 418 0.096% 99.265% ( 380, 580 ] 737 0.169% 99.434% ( 580, 870 ] 913 0.209% 99.643% ( 870, 1300 ] 721 0.165% 99.808% ( 1300, 1900 ] 404 0.093% 99.901% ( 1900, 2900 ] 311 0.071% 99.972% ( 2900, 4400 ] 412 0.094% 100.067% ( 4400, 6600 ] 150 0.034% 100.101% ( 6600, 9900 ] 26 0.006% 100.107% ( 9900, 14000 ] 2 0.000% 100.107% ( 14000, 22000 ] 1 0.000% 100.108% ** Level 5 read latency histogram (micros): Count: 320 Average: 1474.0187 StdDev: 1593.52 Min: 84 Median: 725.0000 Max: 9617 Percentiles: P50: 725.00 P75: 2433.33 P99: 6568.57 P99.9: 9548.00 P99.99: 9617.00 ------------------------------------------------------ ( 76, 110 ] 15 4.688% 4.688% # ( 110, 170 ] 16 5.000% 9.688% # ( 170, 250 ] 24 7.500% 17.188% ## ( 250, 380 ] 45 14.062% 31.250% ### ( 380, 580 ] 41 12.812% 44.062% ### ( 580, 870 ] 38 11.875% 55.938% ## ( 870, 1300 ] 20 6.250% 62.188% # ( 1300, 1900 ] 25 7.812% 70.000% ## ( 1900, 2900 ] 30 9.375% 79.375% ## ( 2900, 4400 ] 49 15.312% 94.688% ### ( 4400, 6600 ] 14 4.375% 99.062% # ( 6600, 9900 ] 3 0.938% 100.000% ** DB Stats ** Uptime(secs): 58.5 total, 13.5 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 168.35 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:31.090 H:M:S, 53.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 73.06 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:10.273 H:M:S, 76.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 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.696 micros/op 175559 ops/sec 60.145 seconds 10558999 operations; 170.1 MB/s Microseconds per write: Count: 10558999 Average: 5.6957 StdDev: 572.42 Min: 0 Median: 1.7297 Max: 957668 Percentiles: P50: 1.73 P75: 2.67 P99: 8.90 P99.9: 1105.36 P99.99: 2689.78 ------------------------------------------------------ [ 0, 1 ] 1492749 14.137% 14.137% ### ( 1, 2 ] 5189672 49.149% 63.287% ########## ( 2, 3 ] 1847427 17.496% 80.783% ### ( 3, 4 ] 1361470 12.894% 93.677% ### ( 4, 6 ] 477375 4.521% 98.198% # ( 6, 10 ] 116963 1.108% 99.305% ( 10, 15 ] 35312 0.334% 99.640% ( 15, 22 ] 7534 0.071% 99.711% ( 22, 34 ] 1432 0.014% 99.725% ( 34, 51 ] 195 0.002% 99.727% ( 51, 76 ] 30 0.000% 99.727% ( 76, 110 ] 7987 0.076% 99.803% ( 110, 170 ] 2324 0.022% 99.825% ( 170, 250 ] 253 0.002% 99.827% ( 250, 380 ] 153 0.001% 99.828% ( 380, 580 ] 22 0.000% 99.829% ( 580, 870 ] 23 0.000% 99.829% ( 870, 1300 ] 13737 0.130% 99.959% ( 1300, 1900 ] 62 0.001% 99.959% ( 1900, 2900 ] 4081 0.039% 99.998% ( 2900, 4400 ] 131 0.001% 99.999% ( 4400, 6600 ] 20 0.000% 100.000% ( 6600, 9900 ] 10 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 6 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 33000, 50000 ] 3 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 16 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 380000, 570000 ] 2 0.000% 100.000% ( 570000, 860000 ] 3 0.000% 100.000% ( 860000, 1200000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 261243 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 : 10558999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10896886968 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 : 677 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31515329 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 : 35843664122 rocksdb.compact.write.bytes COUNT : 35576996015 rocksdb.flush.write.bytes COUNT : 10833185988 rocksdb.compact.read.marked.bytes COUNT : 0 rocksdb.compact.read.periodic.bytes COUNT : 0 rocksdb.compact.read.ttl.bytes COUNT : 0 rocksdb.compact.write.marked.bytes COUNT : 0 rocksdb.compact.write.periodic.bytes COUNT : 0 rocksdb.compact.write.ttl.bytes COUNT : 0 rocksdb.number.direct.load.table.properties COUNT : 79 rocksdb.number.superversion_acquires COUNT : 0 rocksdb.number.superversion_releases COUNT : 0 rocksdb.number.superversion_cleanups COUNT : 0 rocksdb.number.block.compressed COUNT : 0 rocksdb.number.block.decompressed COUNT : 0 rocksdb.number.block.not_compressed COUNT : 0 rocksdb.merge.operation.time.nanos COUNT : 0 rocksdb.filter.operation.time.nanos COUNT : 0 rocksdb.row.cache.hit COUNT : 0 rocksdb.row.cache.miss COUNT : 0 rocksdb.read.amp.estimate.useful.bytes COUNT : 0 rocksdb.read.amp.total.read.bytes COUNT : 0 rocksdb.number.rate_limiter.drains COUNT : 0 rocksdb.number.iter.skip COUNT : 0 rocksdb.blobdb.num.put COUNT : 0 rocksdb.blobdb.num.write COUNT : 0 rocksdb.blobdb.num.get COUNT : 0 rocksdb.blobdb.num.multiget COUNT : 0 rocksdb.blobdb.num.seek COUNT : 0 rocksdb.blobdb.num.next COUNT : 0 rocksdb.blobdb.num.prev COUNT : 0 rocksdb.blobdb.num.keys.written COUNT : 0 rocksdb.blobdb.num.keys.read COUNT : 0 rocksdb.blobdb.bytes.written COUNT : 0 rocksdb.blobdb.bytes.read COUNT : 0 rocksdb.blobdb.write.inlined COUNT : 0 rocksdb.blobdb.write.inlined.ttl COUNT : 0 rocksdb.blobdb.write.blob COUNT : 0 rocksdb.blobdb.write.blob.ttl COUNT : 0 rocksdb.blobdb.blob.file.bytes.written COUNT : 0 rocksdb.blobdb.blob.file.bytes.read COUNT : 0 rocksdb.blobdb.blob.file.synced COUNT : 0 rocksdb.blobdb.blob.index.expired.count COUNT : 0 rocksdb.blobdb.blob.index.expired.size COUNT : 0 rocksdb.blobdb.blob.index.evicted.count COUNT : 0 rocksdb.blobdb.blob.index.evicted.size COUNT : 0 rocksdb.blobdb.gc.num.files COUNT : 0 rocksdb.blobdb.gc.num.new.files COUNT : 0 rocksdb.blobdb.gc.failures COUNT : 0 rocksdb.blobdb.gc.num.keys.relocated COUNT : 0 rocksdb.blobdb.gc.bytes.relocated COUNT : 0 rocksdb.blobdb.fifo.num.files.evicted COUNT : 0 rocksdb.blobdb.fifo.num.keys.evicted COUNT : 0 rocksdb.blobdb.fifo.bytes.evicted COUNT : 0 rocksdb.txn.overhead.mutex.prepare COUNT : 0 rocksdb.txn.overhead.mutex.old.commit.map COUNT : 0 rocksdb.txn.overhead.duplicate.key COUNT : 0 rocksdb.txn.overhead.mutex.snapshot COUNT : 0 rocksdb.txn.get.tryagain COUNT : 0 rocksdb.number.multiget.keys.found COUNT : 0 rocksdb.num.iterator.created COUNT : 0 rocksdb.num.iterator.deleted COUNT : 0 rocksdb.block.cache.compression.dict.miss COUNT : 0 rocksdb.block.cache.compression.dict.hit COUNT : 0 rocksdb.block.cache.compression.dict.add COUNT : 0 rocksdb.block.cache.compression.dict.bytes.insert COUNT : 0 rocksdb.block.cache.add.redundant COUNT : 0 rocksdb.block.cache.index.add.redundant COUNT : 0 rocksdb.block.cache.filter.add.redundant COUNT : 0 rocksdb.block.cache.data.add.redundant COUNT : 0 rocksdb.block.cache.compression.dict.add.redundant COUNT : 0 rocksdb.files.marked.trash COUNT : 0 rocksdb.files.deleted.immediately COUNT : 305 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 : 10746052608 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4367360 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 : 35953540670 rocksdb.non.last.level.read.count COUNT : 8684836 rocksdb.block.checksum.compute.count COUNT : 8683561 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.375613 P95 : 3.828670 P99 : 7.258066 P100 : 957665.000000 COUNT : 10558999 SUM : 55299568 rocksdb.compaction.times.micros P50 : 1038292.682927 P95 : 2894444.444444 P99 : 13118000.000000 P100 : 21236690.000000 COUNT : 121 SUM : 172411762 rocksdb.compaction.times.cpu_micros P50 : 864250.000000 P95 : 1897666.666667 P99 : 13118000.000000 P100 : 19535970.000000 COUNT : 121 SUM : 137085580 rocksdb.subcompaction.setup.times.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.table.sync.micros P50 : 708.481013 P95 : 5390.000000 P99 : 42860.000000 P100 : 121921.000000 COUNT : 142 SUM : 318040 rocksdb.compaction.outfile.sync.micros P50 : 1212.783019 P95 : 106562.500000 P99 : 190000.000000 P100 : 283760.000000 COUNT : 475 SUM : 9891836 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 : 129.756098 P95 : 2640.909091 P99 : 4966.500000 P100 : 6580.000000 COUNT : 297 SUM : 145240 rocksdb.table.open.io.micros P50 : 1644.117647 P95 : 9681.964286 P99 : 19845.714286 P100 : 22803.000000 COUNT : 677 SUM : 1757513 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.737234 P95 : 8.456100 P99 : 12.284349 P100 : 17997.000000 COUNT : 8681524 SUM : 59818594 rocksdb.read.block.get.micros P50 : 495.151515 P95 : 4142.567568 P99 : 6571.714286 P100 : 9764.000000 COUNT : 1354 SUM : 1408729 rocksdb.write.raw.block.micros P50 : 0.513723 P95 : 0.976074 P99 : 2.891832 P100 : 22383.000000 COUNT : 11241241 SUM : 25110578 rocksdb.numfiles.in.singlecompaction P50 : 3.064935 P95 : 5.620000 P99 : 20.180000 P100 : 35.000000 COUNT : 178 SUM : 644 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.560517 P95 : 1170.793390 P99 : 2522.695245 P100 : 957495.000000 COUNT : 167348 SUM : 31532735 rocksdb.sst.read.micros P50 : 1.693464 P95 : 5.214634 P99 : 9.092123 P100 : 17994.000000 COUNT : 8684980 SUM : 42358832 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 : 10558999 SUM : 10896886968 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 : 213404.255319 P95 : 517750.000000 P99 : 958600.000000 P100 : 1114749.000000 COUNT : 142 SUM : 33386956 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 : 445 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