[2024-11-27 17:05:27.048099] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 22.11.4 initialization... [2024-11-27 17:05:27.048212] [ 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_pid3632882 ] Set seed to 1732723527045638 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-27 17:05:27.135044] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-27 17:05:27.175964] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-27 17:05:27.176007] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 3632882' to capture a snapshot of events at runtime. [2024-11-27 17:05:27.176020] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid3632882 for offline analysis/debug. [2024-11-27 17:05:27.176044] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Wed Nov 27 17:05:31 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/27-17:05:34 ... thread 0: (1000000,1000000) ops and (332189.8,332189.8) ops/second in (3.010327,3.010327) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/9 630.00 MB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 347.8 2.54 2.29 12 0.211 0 0 0.0 0.0 L1 3/3 188.86 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.1 1.5 256.7 256.6 0.74 0.71 1 0.736 191K 78 0.0 0.0 L2 1/0 49.01 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 238.1 238.1 0.47 0.44 1 0.468 113K 42 0.0 0.0 L3 18/0 881.39 MB 0.9 0.1 0.1 0.0 0.1 0.1 0.0 1.0 203.2 203.2 0.31 0.26 1 0.307 63K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.75 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 1191/12 97.00 GB 0.0 0.4 0.2 0.1 1.2 1.1 0.2 1.4 89.7 307.5 4.05 3.70 15 0.270 368K 120 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.1 1.2 1.1 0.1 1.4 89.7 307.5 4.05 3.70 15 0.270 368K 120 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.2 0.1 0.4 0.2 0.0 0.0 240.1 240.0 1.51 1.41 3 0.504 368K 120 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 347.8 2.54 2.29 12 0.211 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.2 total, 3.0 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.22 GB write, 383.55 MB/s write, 0.35 GB read, 111.82 MB/s read, 4.0 seconds Interval compaction: 1.22 GB write, 413.29 MB/s write, 0.35 GB read, 120.50 MB/s read, 4.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 113232 Average: 1.8629 StdDev: 22.78 Min: 1 Median: 1.1456 Max: 3525 Percentiles: P50: 1.15 P75: 1.61 P99: 3.71 P99.9: 9.56 P99.99: 304.49 ------------------------------------------------------ [ 0, 1 ] 47764 42.182% 42.182% ######## ( 1, 2 ] 60787 53.684% 95.866% ########### ( 2, 3 ] 2783 2.458% 98.324% ( 3, 4 ] 1080 0.954% 99.278% ( 4, 6 ] 503 0.444% 99.722% ( 6, 10 ] 232 0.205% 99.927% ( 10, 15 ] 50 0.044% 99.971% ( 15, 22 ] 11 0.010% 99.981% ( 22, 34 ] 1 0.001% 99.981% ( 34, 51 ] 2 0.002% 99.983% ( 51, 76 ] 1 0.001% 99.984% ( 110, 170 ] 7 0.006% 99.990% ( 170, 250 ] 3 0.003% 99.993% ( 250, 380 ] 4 0.004% 99.996% ( 380, 580 ] 2 0.002% 99.998% ( 580, 870 ] 1 0.001% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ( 1900, 2900 ] 2 0.002% 100.002% ( 2900, 4400 ] 4 0.004% 100.005% ** Level 1 read latency histogram (micros): Count: 36727 Average: 2.0963 StdDev: 17.34 Min: 0 Median: 1.1612 Max: 1723 Percentiles: P50: 1.16 P75: 1.63 P99: 5.38 P99.9: 63.20 P99.99: 1010.74 ------------------------------------------------------ [ 0, 1 ] 15196 41.376% 41.376% ######## ( 1, 2 ] 19653 53.511% 94.887% ########### ( 2, 3 ] 1058 2.881% 97.767% # ( 3, 4 ] 334 0.909% 98.677% ( 4, 6 ] 172 0.468% 99.145% ( 6, 10 ] 176 0.479% 99.624% ( 10, 15 ] 40 0.109% 99.733% ( 15, 22 ] 22 0.060% 99.793% ( 34, 51 ] 30 0.082% 99.875% ( 51, 76 ] 19 0.052% 99.926% ( 76, 110 ] 3 0.008% 99.935% ( 170, 250 ] 11 0.030% 99.965% ( 250, 380 ] 4 0.011% 99.975% ( 380, 580 ] 3 0.008% 99.984% ( 580, 870 ] 2 0.005% 99.989% ( 870, 1300 ] 1 0.003% 99.992% ( 1300, 1900 ] 3 0.008% 100.000% ** Level 2 read latency histogram (micros): Count: 15865 Average: 1.7051 StdDev: 3.48 Min: 0 Median: 1.1556 Max: 286 Percentiles: P50: 1.16 P75: 1.62 P99: 3.18 P99.9: 8.97 P99.99: 226.54 ------------------------------------------------------ [ 0, 1 ] 6601 41.607% 41.607% ######## ( 1, 2 ] 8557 53.936% 95.544% ########### ( 2, 3 ] 531 3.347% 98.891% # ( 3, 4 ] 96 0.605% 99.496% ( 4, 6 ] 53 0.334% 99.830% ( 6, 10 ] 15 0.095% 99.924% ( 10, 15 ] 5 0.032% 99.956% ( 15, 22 ] 3 0.019% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 2 0.013% 99.994% ( 250, 380 ] 1 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 90 Average: 1088.5222 StdDev: 1449.72 Min: 1 Median: 430.0000 Max: 5178 Percentiles: P50: 430.00 P75: 1600.00 P99: 5178.00 P99.9: 5178.00 P99.99: 5178.00 ------------------------------------------------------ [ 0, 1 ] 18 20.000% 20.000% #### ( 1, 2 ] 16 17.778% 37.778% #### ( 2, 3 ] 2 2.222% 40.000% ( 4, 6 ] 1 1.111% 41.111% ( 51, 76 ] 1 1.111% 42.222% ( 170, 250 ] 3 3.333% 45.556% # ( 250, 380 ] 3 3.333% 48.889% # ( 380, 580 ] 4 4.444% 53.333% # ( 580, 870 ] 8 8.889% 62.222% ## ( 870, 1300 ] 8 8.889% 71.111% ## ( 1300, 1900 ] 7 7.778% 78.889% ## ( 1900, 2900 ] 5 5.556% 84.444% # ( 2900, 4400 ] 10 11.111% 95.556% ## ( 4400, 6600 ] 4 4.444% 100.000% # ** Level 4 read latency histogram (micros): Count: 25 Average: 1800.3600 StdDev: 1308.98 Min: 99 Median: 1219.3750 Max: 4886 Percentiles: P50: 1219.38 P75: 2816.67 P99: 4886.00 P99.9: 4886.00 P99.99: 4886.00 ------------------------------------------------------ ( 76, 110 ] 1 4.000% 4.000% # ( 380, 580 ] 2 8.000% 12.000% ## ( 580, 870 ] 3 12.000% 24.000% ## ( 870, 1300 ] 8 32.000% 56.000% ###### ( 1300, 1900 ] 2 8.000% 64.000% ## ( 1900, 2900 ] 3 12.000% 76.000% ## ( 2900, 4400 ] 5 20.000% 96.000% #### ( 4400, 6600 ] 1 4.000% 100.000% # ** DB Stats ** Uptime(secs): 3.2 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 303.23 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.430 H:M:S, 13.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 326.67 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.430 H:M:S, 14.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/27-17:05:37 ... thread 0: (1000000,2000000) ops and (349755.9,340746.6) ops/second in (2.859137,5.869464) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/4 1.23 GB 100.7 0.9 0.0 0.9 2.6 1.8 0.0 1.5 103.6 318.0 8.52 7.90 29 0.294 895K 997 0.0 0.0 L1 1/0 4.38 MB 0.4 0.7 0.4 0.2 0.7 0.4 0.1 1.6 246.7 246.2 2.81 2.74 2 1.404 703K 1167 0.0 0.0 L2 5/4 547.35 MB 1.1 0.1 0.1 0.0 0.1 0.1 0.5 1.8 238.1 238.1 0.47 0.44 1 0.468 113K 42 0.0 0.0 L3 18/11 881.39 MB 0.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 203.2 203.2 0.31 0.26 1 0.307 63K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.75 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 1193/19 97.92 GB 0.0 1.7 0.6 1.2 3.5 2.3 0.7 2.0 144.5 295.3 12.10 11.34 33 0.367 1775K 2206 0.0 0.0 Int 0/0 0.00 KB 0.0 1.7 0.6 1.2 3.5 2.3 0.6 2.0 144.5 295.3 12.10 11.34 33 0.367 1775K 2206 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.7 0.6 1.2 1.7 0.6 0.0 0.0 254.3 253.9 6.88 6.66 7 0.983 1775K 2206 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 349.8 5.22 4.67 26 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): 6.1 total, 5.9 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.49 GB write, 585.37 MB/s write, 1.71 GB read, 286.47 MB/s read, 12.1 seconds Interval compaction: 3.49 GB write, 608.66 MB/s write, 1.71 GB read, 297.87 MB/s read, 12.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 6, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 6, interval: 6 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 395249 Average: 2.1347 StdDev: 15.99 Min: 1 Median: 1.4098 Max: 4801 Percentiles: P50: 1.41 P75: 1.82 P99: 5.63 P99.9: 9.88 P99.99: 14.50 ------------------------------------------------------ [ 0, 1 ] 98999 25.047% 25.047% ##### ( 1, 2 ] 240690 60.896% 85.943% ############ ( 2, 3 ] 28332 7.168% 93.111% # ( 3, 4 ] 15255 3.860% 96.971% # ( 4, 6 ] 9856 2.494% 99.464% ( 6, 10 ] 1777 0.450% 99.914% ( 10, 15 ] 334 0.085% 99.998% ( 15, 22 ] 24 0.006% 100.005% ( 22, 34 ] 8 0.002% 100.007% ( 34, 51 ] 6 0.002% 100.008% ( 51, 76 ] 3 0.001% 100.009% ( 110, 170 ] 8 0.002% 100.011% ( 170, 250 ] 14 0.004% 100.014% ( 250, 380 ] 8 0.002% 100.016% ( 380, 580 ] 6 0.002% 100.018% ( 580, 870 ] 4 0.001% 100.019% ( 870, 1300 ] 9 0.002% 100.021% ( 1300, 1900 ] 1 0.000% 100.022% ( 1900, 2900 ] 3 0.001% 100.022% ( 2900, 4400 ] 4 0.001% 100.023% ( 4400, 6600 ] 1 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 139941 Average: 2.2907 StdDev: 11.43 Min: 0 Median: 1.4884 Max: 1806 Percentiles: P50: 1.49 P75: 1.88 P99: 5.82 P99.9: 13.82 P99.99: 420.24 ------------------------------------------------------ [ 0, 1 ] 26884 19.211% 19.211% #### ( 1, 2 ] 88217 63.039% 82.250% ############# ( 2, 3 ] 12756 9.115% 91.365% ## ( 3, 4 ] 6396 4.570% 95.935% # ( 4, 6 ] 4714 3.369% 99.304% # ( 6, 10 ] 744 0.532% 99.836% ( 10, 15 ] 118 0.084% 99.920% ( 15, 22 ] 26 0.019% 99.939% ( 22, 34 ] 2 0.001% 99.940% ( 34, 51 ] 30 0.021% 99.961% ( 51, 76 ] 19 0.014% 99.975% ( 76, 110 ] 3 0.002% 99.977% ( 170, 250 ] 11 0.008% 99.985% ( 250, 380 ] 6 0.004% 99.989% ( 380, 580 ] 5 0.004% 99.993% ( 580, 870 ] 3 0.002% 99.995% ( 870, 1300 ] 2 0.001% 99.996% ( 1300, 1900 ] 5 0.004% 100.000% ** Level 2 read latency histogram (micros): Count: 15929 Average: 1.7101 StdDev: 3.48 Min: 0 Median: 1.1589 Max: 286 Percentiles: P50: 1.16 P75: 1.62 P99: 3.24 P99.9: 9.22 P99.99: 226.28 ------------------------------------------------------ [ 0, 1 ] 6601 41.440% 41.440% ######## ( 1, 2 ] 8582 53.877% 95.317% ########### ( 2, 3 ] 563 3.534% 98.851% # ( 3, 4 ] 99 0.622% 99.473% ( 4, 6 ] 56 0.352% 99.824% ( 6, 10 ] 15 0.094% 99.918% ( 10, 15 ] 6 0.038% 99.956% ( 15, 22 ] 3 0.019% 99.975% ( 110, 170 ] 1 0.006% 99.981% ( 170, 250 ] 2 0.013% 99.994% ( 250, 380 ] 1 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 117348 Average: 4.0335 StdDev: 54.01 Min: 1 Median: 1.5995 Max: 5178 Percentiles: P50: 1.60 P75: 2.08 P99: 9.42 P99.9: 334.34 P99.99: 1944.20 ------------------------------------------------------ [ 0, 1 ] 16571 14.121% 14.121% ### ( 1, 2 ] 70231 59.848% 73.970% ############ ( 2, 3 ] 15094 12.863% 86.832% ### ( 3, 4 ] 6992 5.958% 92.791% # ( 4, 6 ] 5513 4.698% 97.489% # ( 6, 10 ] 2076 1.769% 99.258% ( 10, 15 ] 388 0.331% 99.588% ( 15, 22 ] 45 0.038% 99.627% ( 22, 34 ] 7 0.006% 99.633% ( 34, 51 ] 1 0.001% 99.634% ( 51, 76 ] 5 0.004% 99.638% ( 76, 110 ] 76 0.065% 99.703% ( 110, 170 ] 155 0.132% 99.835% ( 170, 250 ] 53 0.045% 99.880% ( 250, 380 ] 38 0.032% 99.912% ( 380, 580 ] 40 0.034% 99.946% ( 580, 870 ] 27 0.023% 99.969% ( 870, 1300 ] 15 0.013% 99.982% ( 1300, 1900 ] 10 0.009% 99.991% ( 1900, 2900 ] 6 0.005% 99.996% ( 2900, 4400 ] 10 0.009% 100.004% ( 4400, 6600 ] 4 0.003% 100.008% ** Level 4 read latency histogram (micros): Count: 25 Average: 1800.3600 StdDev: 1308.98 Min: 99 Median: 1219.3750 Max: 4886 Percentiles: P50: 1219.38 P75: 2816.67 P99: 4886.00 P99.9: 4886.00 P99.99: 4886.00 ------------------------------------------------------ ( 76, 110 ] 1 4.000% 4.000% # ( 380, 580 ] 2 8.000% 12.000% ## ( 580, 870 ] 3 12.000% 24.000% ## ( 870, 1300 ] 8 32.000% 56.000% ###### ( 1300, 1900 ] 2 8.000% 64.000% ## ( 1900, 2900 ] 3 12.000% 76.000% ## ( 2900, 4400 ] 5 20.000% 96.000% #### ( 4400, 6600 ] 1 4.000% 100.000% # ** DB Stats ** Uptime(secs): 6.1 total, 2.9 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 322.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:0.629 H:M:S, 10.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 344.22 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.198 H:M:S, 6.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/27-17:05:40 ... thread 0: (1000000,3000000) ops and (324467.6,335141.8) ops/second in (3.081972,8.951436) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/13 2.21 GB 12.6 1.7 0.0 1.7 4.4 2.8 0.0 1.6 117.6 313.5 14.46 13.47 46 0.314 1727K 1856 0.0 0.0 L1 1/1 4.38 MB 0.0 0.7 0.4 0.2 0.7 0.4 0.1 1.6 246.7 246.2 2.81 2.74 2 1.404 703K 1167 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.5 1.8 238.1 238.1 0.47 0.44 1 0.468 113K 42 0.0 0.0 L3 22/2 1006.85 MB 0.9 1.5 0.6 0.9 1.5 0.6 0.0 2.6 218.8 218.7 7.16 6.31 4 1.791 1579K 759 0.0 0.0 L4 160/0 9.58 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.12 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 1245/16 98.90 GB 0.0 4.0 1.1 2.9 6.7 3.9 1.4 2.4 163.6 277.2 24.90 22.96 53 0.470 4123K 3824 0.0 0.0 Int 0/0 0.00 KB 0.0 4.0 1.1 2.9 6.7 3.9 1.4 2.4 163.6 277.2 24.90 22.96 53 0.470 4123K 3824 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.0 1.1 2.9 4.0 1.1 0.0 0.0 241.7 241.5 16.85 15.77 13 1.296 4123K 3824 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 352.0 8.05 7.20 40 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.2 total, 9.0 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.74 GB write, 751.50 MB/s write, 3.98 GB read, 443.35 MB/s read, 24.9 seconds Interval compaction: 6.74 GB write, 771.11 MB/s write, 3.98 GB read, 454.92 MB/s read, 24.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: 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: 627166 Average: 2.1805 StdDev: 14.31 Min: 1 Median: 1.4337 Max: 4801 Percentiles: P50: 1.43 P75: 1.83 P99: 5.66 P99.9: 10.69 P99.99: 105.92 ------------------------------------------------------ [ 0, 1 ] 143027 22.805% 22.805% ##### ( 1, 2 ] 393258 62.704% 85.509% ############# ( 2, 3 ] 47679 7.602% 93.112% ## ( 3, 4 ] 24367 3.885% 96.997% # ( 4, 6 ] 15107 2.409% 99.406% ( 6, 10 ] 3028 0.483% 99.888% ( 10, 15 ] 546 0.087% 99.975% ( 15, 22 ] 43 0.007% 99.982% ( 22, 34 ] 12 0.002% 99.984% ( 34, 51 ] 7 0.001% 99.985% ( 51, 76 ] 4 0.001% 99.986% ( 76, 110 ] 31 0.005% 99.991% ( 110, 170 ] 50 0.008% 99.999% ( 170, 250 ] 34 0.005% 100.004% ( 250, 380 ] 22 0.004% 100.008% ( 380, 580 ] 20 0.003% 100.011% ( 580, 870 ] 17 0.003% 100.014% ( 870, 1300 ] 11 0.002% 100.015% ( 1300, 1900 ] 3 0.000% 100.016% ( 1900, 2900 ] 4 0.001% 100.017% ( 2900, 4400 ] 4 0.001% 100.017% ( 4400, 6600 ] 1 0.000% 100.017% ** Level 1 read latency histogram (micros): Count: 186831 Average: 2.2728 StdDev: 9.91 Min: 0 Median: 1.5084 Max: 1806 Percentiles: P50: 1.51 P75: 1.90 P99: 5.78 P99.9: 12.38 P99.99: 300.20 ------------------------------------------------------ [ 0, 1 ] 32591 17.444% 17.444% ### ( 1, 2 ] 119637 64.035% 81.479% ############# ( 2, 3 ] 18890 10.111% 91.590% ## ( 3, 4 ] 8422 4.508% 96.098% # ( 4, 6 ] 6090 3.260% 99.357% # ( 6, 10 ] 947 0.507% 99.864% ( 10, 15 ] 141 0.075% 99.940% ( 15, 22 ] 27 0.014% 99.954% ( 22, 34 ] 2 0.001% 99.955% ( 34, 51 ] 30 0.016% 99.971% ( 51, 76 ] 19 0.010% 99.981% ( 76, 110 ] 3 0.002% 99.983% ( 170, 250 ] 11 0.006% 99.989% ( 250, 380 ] 6 0.003% 99.992% ( 380, 580 ] 5 0.003% 99.995% ( 580, 870 ] 3 0.002% 99.996% ( 870, 1300 ] 2 0.001% 99.997% ( 1300, 1900 ] 5 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 28310 Average: 1.9761 StdDev: 5.34 Min: 0 Median: 1.3134 Max: 623 Percentiles: P50: 1.31 P75: 1.74 P99: 5.53 P99.9: 13.20 P99.99: 260.98 ------------------------------------------------------ [ 0, 1 ] 8949 31.611% 31.611% ###### ( 1, 2 ] 16612 58.679% 90.290% ############ ( 2, 3 ] 1605 5.669% 95.959% # ( 3, 4 ] 589 2.081% 98.040% ( 4, 6 ] 356 1.258% 99.297% ( 6, 10 ] 163 0.576% 99.873% ( 10, 15 ] 12 0.042% 99.915% ( 15, 22 ] 3 0.011% 99.926% ( 76, 110 ] 14 0.049% 99.975% ( 110, 170 ] 2 0.007% 99.982% ( 170, 250 ] 2 0.007% 99.989% ( 250, 380 ] 2 0.007% 99.996% ( 580, 870 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 257140 Average: 3.7446 StdDev: 40.86 Min: 0 Median: 1.5322 Max: 5178 Percentiles: P50: 1.53 P75: 1.93 P99: 9.37 P99.9: 331.65 P99.99: 1179.71 ------------------------------------------------------ [ 0, 1 ] 43470 16.905% 16.905% ### ( 1, 2 ] 159917 62.191% 79.096% ############ ( 2, 3 ] 26510 10.310% 89.405% ## ( 3, 4 ] 12505 4.863% 94.268% # ( 4, 6 ] 8861 3.446% 97.714% # ( 6, 10 ] 3923 1.526% 99.240% ( 10, 15 ] 556 0.216% 99.456% ( 15, 22 ] 70 0.027% 99.484% ( 22, 34 ] 50 0.019% 99.503% ( 34, 51 ] 2 0.001% 99.504% ( 51, 76 ] 13 0.005% 99.509% ( 76, 110 ] 210 0.082% 99.590% ( 110, 170 ] 525 0.204% 99.795% ( 170, 250 ] 198 0.077% 99.872% ( 250, 380 ] 116 0.045% 99.917% ( 380, 580 ] 114 0.044% 99.961% ( 580, 870 ] 57 0.022% 99.983% ( 870, 1300 ] 24 0.009% 99.993% ( 1300, 1900 ] 10 0.004% 99.996% ( 1900, 2900 ] 8 0.003% 100.000% ( 2900, 4400 ] 11 0.004% 100.004% ( 4400, 6600 ] 4 0.002% 100.005% ** Level 4 read latency histogram (micros): Count: 25 Average: 1800.3600 StdDev: 1308.98 Min: 99 Median: 1219.3750 Max: 4886 Percentiles: P50: 1219.38 P75: 2816.67 P99: 4886.00 P99.9: 4886.00 P99.99: 4886.00 ------------------------------------------------------ ( 76, 110 ] 1 4.000% 4.000% # ( 380, 580 ] 2 8.000% 12.000% ## ( 580, 870 ] 3 12.000% 24.000% ## ( 870, 1300 ] 8 32.000% 56.000% ###### ( 1300, 1900 ] 2 8.000% 64.000% ## ( 1900, 2900 ] 3 12.000% 76.000% ## ( 2900, 4400 ] 5 20.000% 96.000% #### ( 4400, 6600 ] 1 4.000% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 880.4500 StdDev: 951.07 Min: 86 Median: 380.0000 Max: 3226 Percentiles: P50: 380.00 P75: 1300.00 P99: 3226.00 P99.9: 3226.00 P99.99: 3226.00 ------------------------------------------------------ ( 76, 110 ] 2 10.000% 10.000% ## ( 110, 170 ] 3 15.000% 25.000% ### ( 170, 250 ] 1 5.000% 30.000% # ( 250, 380 ] 4 20.000% 50.000% #### ( 380, 580 ] 3 15.000% 65.000% ### ( 580, 870 ] 1 5.000% 70.000% # ( 870, 1300 ] 1 5.000% 75.000% # ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 9.2 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 321.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:1.026 H:M:S, 11.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.35 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.398 H:M:S, 12.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/27-17:05:43 ... thread 0: (1000000,4000000) ops and (289966.4,322577.8) ops/second in (3.448675,12.400111) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/13 3.26 GB 119.6 2.7 0.0 2.7 6.5 3.8 0.0 1.7 128.7 309.8 21.54 20.16 66 0.326 2814K 2969 0.0 0.0 L1 1/1 4.38 MB 0.0 0.7 0.4 0.2 0.7 0.4 0.1 1.6 246.7 246.2 2.81 2.74 2 1.404 703K 1167 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.5 1.8 238.1 238.1 0.47 0.44 1 0.468 113K 42 0.0 0.0 L3 20/0 923.75 MB 0.9 1.5 0.6 0.9 1.5 0.6 0.0 2.6 218.8 218.7 7.16 6.31 4 1.791 1579K 759 0.0 0.0 L4 170/0 9.66 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.4 1.0 196.6 196.6 0.42 0.36 1 0.423 75K 0 0.0 0.0 L5 1048/0 86.12 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 1257/14 99.95 GB 0.0 5.1 1.2 3.9 8.9 5.0 1.4 2.3 161.3 281.7 32.41 30.01 74 0.438 5286K 4937 0.0 0.0 Int 0/0 0.00 KB 0.0 5.1 1.2 3.9 8.9 5.0 1.4 2.3 161.3 281.7 32.41 30.01 74 0.438 5286K 4937 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.1 1.2 3.9 5.1 1.2 0.0 0.0 245.8 245.6 21.26 20.05 18 1.181 5286K 4937 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 350.6 11.14 9.96 56 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): 12.6 total, 12.4 interval Flush(GB): cumulative 3.814, interval 3.814 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.91 GB write, 722.39 MB/s write, 5.10 GB read, 413.68 MB/s read, 32.4 seconds Interval compaction: 8.91 GB write, 736.00 MB/s write, 5.10 GB read, 421.47 MB/s read, 32.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 4, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 4, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 4, total-stops: 15, interval: 19 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1105042 Average: 2.1688 StdDev: 12.66 Min: 1 Median: 1.4518 Max: 4801 Percentiles: P50: 1.45 P75: 1.84 P99: 5.65 P99.9: 9.90 P99.99: 14.90 ------------------------------------------------------ [ 0, 1 ] 230252 20.836% 20.836% #### ( 1, 2 ] 713294 64.549% 85.386% ############# ( 2, 3 ] 87841 7.949% 93.335% ## ( 3, 4 ] 42137 3.813% 97.148% # ( 4, 6 ] 24836 2.248% 99.395% ( 6, 10 ] 5722 0.518% 99.913% ( 10, 15 ] 868 0.079% 99.992% ( 15, 22 ] 61 0.006% 99.997% ( 22, 34 ] 17 0.002% 99.999% ( 34, 51 ] 10 0.001% 100.000% ( 51, 76 ] 6 0.001% 100.000% ( 76, 110 ] 36 0.003% 100.003% ( 110, 170 ] 63 0.006% 100.009% ( 170, 250 ] 46 0.004% 100.013% ( 250, 380 ] 30 0.003% 100.016% ( 380, 580 ] 27 0.002% 100.018% ( 580, 870 ] 24 0.002% 100.021% ( 870, 1300 ] 16 0.001% 100.022% ( 1300, 1900 ] 4 0.000% 100.022% ( 1900, 2900 ] 7 0.001% 100.023% ( 2900, 4400 ] 6 0.001% 100.024% ( 4400, 6600 ] 1 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 186831 Average: 2.2728 StdDev: 9.91 Min: 0 Median: 1.5084 Max: 1806 Percentiles: P50: 1.51 P75: 1.90 P99: 5.78 P99.9: 12.38 P99.99: 300.20 ------------------------------------------------------ [ 0, 1 ] 32591 17.444% 17.444% ### ( 1, 2 ] 119637 64.035% 81.479% ############# ( 2, 3 ] 18890 10.111% 91.590% ## ( 3, 4 ] 8422 4.508% 96.098% # ( 4, 6 ] 6090 3.260% 99.357% # ( 6, 10 ] 947 0.507% 99.864% ( 10, 15 ] 141 0.075% 99.940% ( 15, 22 ] 27 0.014% 99.954% ( 22, 34 ] 2 0.001% 99.955% ( 34, 51 ] 30 0.016% 99.971% ( 51, 76 ] 19 0.010% 99.981% ( 76, 110 ] 3 0.002% 99.983% ( 170, 250 ] 11 0.006% 99.989% ( 250, 380 ] 6 0.003% 99.992% ( 380, 580 ] 5 0.003% 99.995% ( 580, 870 ] 3 0.002% 99.996% ( 870, 1300 ] 2 0.001% 99.997% ( 1300, 1900 ] 5 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 28310 Average: 1.9761 StdDev: 5.34 Min: 0 Median: 1.3134 Max: 623 Percentiles: P50: 1.31 P75: 1.74 P99: 5.53 P99.9: 13.20 P99.99: 260.98 ------------------------------------------------------ [ 0, 1 ] 8949 31.611% 31.611% ###### ( 1, 2 ] 16612 58.679% 90.290% ############ ( 2, 3 ] 1605 5.669% 95.959% # ( 3, 4 ] 589 2.081% 98.040% ( 4, 6 ] 356 1.258% 99.297% ( 6, 10 ] 163 0.576% 99.873% ( 10, 15 ] 12 0.042% 99.915% ( 15, 22 ] 3 0.011% 99.926% ( 76, 110 ] 14 0.049% 99.975% ( 110, 170 ] 2 0.007% 99.982% ( 170, 250 ] 2 0.007% 99.989% ( 250, 380 ] 2 0.007% 99.996% ( 580, 870 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 264754 Average: 3.7030 StdDev: 40.26 Min: 0 Median: 1.5340 Max: 5178 Percentiles: P50: 1.53 P75: 1.93 P99: 9.30 P99.9: 323.12 P99.99: 1166.07 ------------------------------------------------------ [ 0, 1 ] 44193 16.692% 16.692% ### ( 1, 2 ] 165146 62.377% 79.069% ############ ( 2, 3 ] 27384 10.343% 89.412% ## ( 3, 4 ] 12926 4.882% 94.295% # ( 4, 6 ] 9184 3.469% 97.764% # ( 6, 10 ] 3962 1.496% 99.260% ( 10, 15 ] 560 0.212% 99.472% ( 15, 22 ] 71 0.027% 99.498% ( 22, 34 ] 50 0.019% 99.517% ( 34, 51 ] 2 0.001% 99.518% ( 51, 76 ] 13 0.005% 99.523% ( 76, 110 ] 210 0.079% 99.602% ( 110, 170 ] 525 0.198% 99.801% ( 170, 250 ] 198 0.075% 99.875% ( 250, 380 ] 116 0.044% 99.919% ( 380, 580 ] 114 0.043% 99.962% ( 580, 870 ] 57 0.022% 99.984% ( 870, 1300 ] 24 0.009% 99.993% ( 1300, 1900 ] 10 0.004% 99.997% ( 1900, 2900 ] 8 0.003% 100.000% ( 2900, 4400 ] 11 0.004% 100.004% ( 4400, 6600 ] 4 0.002% 100.005% ** Level 4 read latency histogram (micros): Count: 75 Average: 608.0133 StdDev: 1132.63 Min: 1 Median: 5.5000 Max: 4886 Percentiles: P50: 5.50 P75: 883.44 P99: 4886.00 P99.9: 4886.00 P99.99: 4886.00 ------------------------------------------------------ [ 0, 1 ] 14 18.667% 18.667% #### ( 1, 2 ] 13 17.333% 36.000% ### ( 2, 3 ] 4 5.333% 41.333% # ( 3, 4 ] 2 2.667% 44.000% # ( 4, 6 ] 6 8.000% 52.000% ## ( 10, 15 ] 1 1.333% 53.333% ( 15, 22 ] 2 2.667% 56.000% # ( 22, 34 ] 7 9.333% 65.333% ## ( 76, 110 ] 1 1.333% 66.667% ( 250, 380 ] 1 1.333% 68.000% ( 380, 580 ] 2 2.667% 70.667% # ( 580, 870 ] 3 4.000% 74.667% # ( 870, 1300 ] 8 10.667% 85.333% ## ( 1300, 1900 ] 2 2.667% 88.000% # ( 1900, 2900 ] 3 4.000% 92.000% # ( 2900, 4400 ] 5 6.667% 98.667% # ( 4400, 6600 ] 1 1.333% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 880.4500 StdDev: 951.07 Min: 86 Median: 380.0000 Max: 3226 Percentiles: P50: 380.00 P75: 1300.00 P99: 3226.00 P99.9: 3226.00 P99.99: 3226.00 ------------------------------------------------------ ( 76, 110 ] 2 10.000% 10.000% ## ( 110, 170 ] 3 15.000% 25.000% ### ( 170, 250 ] 1 5.000% 30.000% # ( 250, 380 ] 4 20.000% 50.000% #### ( 380, 580 ] 3 15.000% 65.000% ### ( 580, 870 ] 1 5.000% 70.000% # ( 870, 1300 ] 1 5.000% 75.000% # ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 12.6 total, 3.4 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 311.57 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.773 H:M:S, 14.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 285.38 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.746 H:M:S, 21.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 0 2024/11/27-17:05:49 ... thread 0: (1000000,5000000) ops and (187244.7,281837.5) ops/second in (5.340606,17.740717) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/10 2.27 GB 69.2 3.4 0.0 3.4 8.1 4.7 0.0 1.7 128.9 303.7 27.37 25.21 82 0.334 3582K 3706 0.0 0.0 L1 4/0 331.18 MB 33.1 2.5 2.3 0.3 2.5 2.3 0.1 1.1 236.9 235.3 10.91 10.58 3 3.638 2625K 16K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 2.0 1.8 238.1 238.1 0.47 0.44 1 0.468 113K 42 0.0 0.0 L3 14/1 1022.16 MB 1.0 1.5 0.6 0.9 1.5 0.6 1.5 2.6 218.8 218.7 7.16 6.31 4 1.791 1579K 759 0.0 0.0 L4 173/8 10.08 GB 1.0 0.9 0.7 0.2 0.9 0.7 1.2 1.3 151.1 150.5 6.26 4.36 6 1.043 923K 3033 0.0 0.0 L5 1060/0 87.11 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1264/19 100.79 GB 0.0 8.5 3.6 4.9 13.2 8.3 6.2 2.8 167.5 258.8 52.17 46.90 96 0.543 8824K 24K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.5 3.6 4.9 13.2 8.3 6.2 2.8 167.5 258.8 52.17 46.90 96 0.543 8824K 24K 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.5 3.6 4.9 8.5 3.6 0.0 0.0 230.2 229.6 37.95 34.59 27 1.406 8824K 24K 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 336.7 14.22 12.31 69 0.206 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 18.0 total, 17.7 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 13.18 GB write, 751.00 MB/s write, 8.53 GB read, 486.08 MB/s read, 52.2 seconds Interval compaction: 13.18 GB write, 760.89 MB/s write, 8.53 GB read, 492.48 MB/s read, 52.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, 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: 10, total-stops: 23, interval: 33 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1648569 Average: 2.1951 StdDev: 12.12 Min: 0 Median: 1.4525 Max: 4801 Percentiles: P50: 1.45 P75: 1.84 P99: 5.77 P99.9: 10.56 P99.99: 99.16 ------------------------------------------------------ [ 0, 1 ] 343846 20.857% 20.857% #### ( 1, 2 ] 1061860 64.411% 85.268% ############# ( 2, 3 ] 129524 7.857% 93.125% ## ( 3, 4 ] 62956 3.819% 96.944% # ( 4, 6 ] 38239 2.320% 99.263% ( 6, 10 ] 10349 0.628% 99.891% ( 10, 15 ] 1323 0.080% 99.971% ( 15, 22 ] 151 0.009% 99.981% ( 22, 34 ] 18 0.001% 99.982% ( 34, 51 ] 12 0.001% 99.982% ( 51, 76 ] 12 0.001% 99.983% ( 76, 110 ] 172 0.010% 99.994% ( 110, 170 ] 160 0.010% 100.003% ( 170, 250 ] 96 0.006% 100.009% ( 250, 380 ] 70 0.004% 100.013% ( 380, 580 ] 55 0.003% 100.017% ( 580, 870 ] 35 0.002% 100.019% ( 870, 1300 ] 22 0.001% 100.020% ( 1300, 1900 ] 7 0.000% 100.021% ( 1900, 2900 ] 7 0.000% 100.021% ( 2900, 4400 ] 9 0.001% 100.021% ( 4400, 6600 ] 1 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 350711 Average: 3.1359 StdDev: 28.33 Min: 0 Median: 1.6850 Max: 4331 Percentiles: P50: 1.68 P75: 2.47 P99: 7.70 P99.9: 13.30 P99.99: 39.44 ------------------------------------------------------ [ 0, 1 ] 38206 10.894% 10.894% ## ( 1, 2 ] 200219 57.089% 67.983% ########### ( 2, 3 ] 51993 14.825% 82.808% ### ( 3, 4 ] 27614 7.874% 90.682% ## ( 4, 6 ] 27147 7.741% 98.423% ## ( 6, 10 ] 4768 1.360% 99.782% ( 10, 15 ] 627 0.179% 99.961% ( 15, 22 ] 80 0.023% 99.984% ( 22, 34 ] 12 0.003% 99.987% ( 34, 51 ] 31 0.009% 99.996% ( 51, 76 ] 21 0.006% 100.002% ( 76, 110 ] 27 0.008% 100.010% ( 110, 170 ] 27 0.008% 100.017% ( 170, 250 ] 33 0.009% 100.027% ( 250, 380 ] 52 0.015% 100.042% ( 380, 580 ] 48 0.014% 100.055% ( 580, 870 ] 49 0.014% 100.069% ( 870, 1300 ] 34 0.010% 100.079% ( 1300, 1900 ] 16 0.005% 100.084% ( 1900, 2900 ] 14 0.004% 100.088% ( 2900, 4400 ] 6 0.002% 100.089% ** Level 2 read latency histogram (micros): Count: 28310 Average: 1.9761 StdDev: 5.34 Min: 0 Median: 1.3134 Max: 623 Percentiles: P50: 1.31 P75: 1.74 P99: 5.53 P99.9: 13.20 P99.99: 260.98 ------------------------------------------------------ [ 0, 1 ] 8949 31.611% 31.611% ###### ( 1, 2 ] 16612 58.679% 90.290% ############ ( 2, 3 ] 1605 5.669% 95.959% # ( 3, 4 ] 589 2.081% 98.040% ( 4, 6 ] 356 1.258% 99.297% ( 6, 10 ] 163 0.576% 99.873% ( 10, 15 ] 12 0.042% 99.915% ( 15, 22 ] 3 0.011% 99.926% ( 76, 110 ] 14 0.049% 99.975% ( 110, 170 ] 2 0.007% 99.982% ( 170, 250 ] 2 0.007% 99.989% ( 250, 380 ] 2 0.007% 99.996% ( 580, 870 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 318194 Average: 6.1408 StdDev: 69.44 Min: 0 Median: 1.5793 Max: 7981 Percentiles: P50: 1.58 P75: 1.99 P99: 14.00 P99.9: 718.35 P99.99: 1816.87 ------------------------------------------------------ [ 0, 1 ] 47996 15.084% 15.084% ### ( 1, 2 ] 191784 60.273% 75.357% ############ ( 2, 3 ] 36568 11.492% 86.849% ## ( 3, 4 ] 19441 6.110% 92.959% # ( 4, 6 ] 13294 4.178% 97.137% # ( 6, 10 ] 5260 1.653% 98.790% ( 10, 15 ] 836 0.263% 99.052% ( 15, 22 ] 109 0.034% 99.087% ( 22, 34 ] 59 0.019% 99.105% ( 34, 51 ] 2 0.001% 99.106% ( 51, 76 ] 14 0.004% 99.110% ( 76, 110 ] 257 0.081% 99.191% ( 110, 170 ] 755 0.237% 99.428% ( 170, 250 ] 497 0.156% 99.585% ( 250, 380 ] 437 0.137% 99.722% ( 380, 580 ] 438 0.138% 99.860% ( 580, 870 ] 270 0.085% 99.944% ( 870, 1300 ] 109 0.034% 99.979% ( 1300, 1900 ] 42 0.013% 99.992% ( 1900, 2900 ] 39 0.012% 100.004% ( 2900, 4400 ] 32 0.010% 100.014% ( 4400, 6600 ] 7 0.002% 100.016% ( 6600, 9900 ] 4 0.001% 100.018% ** Level 4 read latency histogram (micros): Count: 3696 Average: 30.5874 StdDev: 207.38 Min: 1 Median: 1.8527 Max: 4886 Percentiles: P50: 1.85 P75: 3.10 P99: 683.04 P99.9: 3591.20 P99.99: 4886.00 ------------------------------------------------------ [ 0, 1 ] 320 8.658% 8.658% ## ( 1, 2 ] 1792 48.485% 57.143% ########## ( 2, 3 ] 616 16.667% 73.810% ### ( 3, 4 ] 435 11.769% 85.579% ## ( 4, 6 ] 228 6.169% 91.748% # ( 6, 10 ] 69 1.867% 93.615% ( 10, 15 ] 18 0.487% 94.102% ( 15, 22 ] 10 0.271% 94.372% ( 22, 34 ] 10 0.271% 94.643% ( 34, 51 ] 4 0.108% 94.751% ( 76, 110 ] 13 0.352% 95.103% ( 110, 170 ] 48 1.299% 96.402% ( 170, 250 ] 24 0.649% 97.051% ( 250, 380 ] 36 0.974% 98.025% ( 380, 580 ] 31 0.839% 98.864% ( 580, 870 ] 17 0.460% 99.324% ( 870, 1300 ] 12 0.325% 99.648% ( 1300, 1900 ] 3 0.081% 99.729% ( 1900, 2900 ] 5 0.135% 99.865% ( 2900, 4400 ] 5 0.135% 100.000% ( 4400, 6600 ] 1 0.027% 100.027% ** Level 5 read latency histogram (micros): Count: 80 Average: 925.3250 StdDev: 1078.00 Min: 79 Median: 367.0000 Max: 4280 Percentiles: P50: 367.00 P75: 1300.00 P99: 4250.00 P99.9: 4280.00 P99.99: 4280.00 ------------------------------------------------------ ( 76, 110 ] 11 13.750% 13.750% ### ( 110, 170 ] 10 12.500% 26.250% ### ( 170, 250 ] 10 12.500% 38.750% ### ( 250, 380 ] 10 12.500% 51.250% ### ( 380, 580 ] 9 11.250% 62.500% ## ( 580, 870 ] 5 6.250% 68.750% # ( 870, 1300 ] 5 6.250% 75.000% # ( 1300, 1900 ] 4 5.000% 80.000% # ( 1900, 2900 ] 8 10.000% 90.000% ## ( 2900, 4400 ] 8 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 18.0 total, 5.3 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 273.75 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:4.424 H:M:S, 24.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 184.28 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.651 H:M:S, 49.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/27-17:05:52 ... thread 0: (1000000,6000000) ops and (313704.5,286691.4) ops/second in (3.187713,20.928430) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/10 3.26 GB 176.2 4.3 0.0 4.3 10.0 5.7 0.0 1.8 130.8 302.6 33.71 31.13 99 0.341 4477K 4713 0.0 0.0 L1 4/0 331.18 MB 33.1 2.5 2.3 0.3 2.5 2.3 0.1 1.1 236.9 235.3 10.91 10.58 3 3.638 2625K 16K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 2.0 1.8 238.1 238.1 0.47 0.44 1 0.468 113K 42 0.0 0.0 L3 13/0 953.79 MB 1.0 1.5 0.6 0.9 1.5 0.6 1.5 2.6 218.8 218.7 7.16 6.31 4 1.791 1579K 759 0.0 0.0 L4 169/0 9.53 GB 1.0 1.7 0.8 0.9 1.7 0.8 1.2 2.1 174.2 173.4 9.80 7.27 7 1.400 993K 3033 0.0 0.0 L5 1068/0 87.72 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1272/10 101.77 GB 0.0 10.1 3.7 6.4 15.8 9.3 6.8 2.8 167.3 260.2 62.06 55.73 114 0.544 9789K 25K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.1 3.7 6.4 15.8 9.3 6.8 2.8 167.3 260.2 62.06 55.73 114 0.544 9789K 25K 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 10.1 3.7 6.4 10.1 3.7 0.0 0.0 230.9 230.2 44.95 40.90 31 1.450 9789K 25K 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 338.8 17.10 14.83 83 0.206 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 21.2 total, 20.9 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: 15.77 GB write, 762.91 MB/s write, 10.14 GB read, 490.51 MB/s read, 62.1 seconds Interval compaction: 15.77 GB write, 771.43 MB/s write, 10.14 GB read, 495.98 MB/s read, 62.1 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: 26, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 26, interval: 37 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2120134 Average: 2.2521 StdDev: 12.99 Min: 0 Median: 1.4784 Max: 7830 Percentiles: P50: 1.48 P75: 1.87 P99: 5.85 P99.9: 10.51 P99.99: 79.81 ------------------------------------------------------ [ 0, 1 ] 405980 19.149% 19.149% #### ( 1, 2 ] 1367188 64.486% 83.635% ############# ( 2, 3 ] 183677 8.663% 92.298% ## ( 3, 4 ] 90004 4.245% 96.543% # ( 4, 6 ] 56246 2.653% 99.196% # ( 6, 10 ] 14736 0.695% 99.891% ( 10, 15 ] 1808 0.085% 99.977% ( 15, 22 ] 206 0.010% 99.986% ( 22, 34 ] 25 0.001% 99.988% ( 34, 51 ] 16 0.001% 99.988% ( 51, 76 ] 14 0.001% 99.989% ( 76, 110 ] 214 0.010% 99.999% ( 110, 170 ] 210 0.010% 100.009% ( 170, 250 ] 139 0.007% 100.016% ( 250, 380 ] 98 0.005% 100.020% ( 380, 580 ] 83 0.004% 100.024% ( 580, 870 ] 43 0.002% 100.026% ( 870, 1300 ] 30 0.001% 100.027% ( 1300, 1900 ] 12 0.001% 100.028% ( 1900, 2900 ] 10 0.000% 100.029% ( 2900, 4400 ] 9 0.000% 100.029% ( 4400, 6600 ] 1 0.000% 100.029% ( 6600, 9900 ] 1 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 350711 Average: 3.1359 StdDev: 28.33 Min: 0 Median: 1.6850 Max: 4331 Percentiles: P50: 1.68 P75: 2.47 P99: 7.70 P99.9: 13.30 P99.99: 39.44 ------------------------------------------------------ [ 0, 1 ] 38206 10.894% 10.894% ## ( 1, 2 ] 200219 57.089% 67.983% ########### ( 2, 3 ] 51993 14.825% 82.808% ### ( 3, 4 ] 27614 7.874% 90.682% ## ( 4, 6 ] 27147 7.741% 98.423% ## ( 6, 10 ] 4768 1.360% 99.782% ( 10, 15 ] 627 0.179% 99.961% ( 15, 22 ] 80 0.023% 99.984% ( 22, 34 ] 12 0.003% 99.987% ( 34, 51 ] 31 0.009% 99.996% ( 51, 76 ] 21 0.006% 100.002% ( 76, 110 ] 27 0.008% 100.010% ( 110, 170 ] 27 0.008% 100.017% ( 170, 250 ] 33 0.009% 100.027% ( 250, 380 ] 52 0.015% 100.042% ( 380, 580 ] 48 0.014% 100.055% ( 580, 870 ] 49 0.014% 100.069% ( 870, 1300 ] 34 0.010% 100.079% ( 1300, 1900 ] 16 0.005% 100.084% ( 1900, 2900 ] 14 0.004% 100.088% ( 2900, 4400 ] 6 0.002% 100.089% ** Level 2 read latency histogram (micros): Count: 28310 Average: 1.9761 StdDev: 5.34 Min: 0 Median: 1.3134 Max: 623 Percentiles: P50: 1.31 P75: 1.74 P99: 5.53 P99.9: 13.20 P99.99: 260.98 ------------------------------------------------------ [ 0, 1 ] 8949 31.611% 31.611% ###### ( 1, 2 ] 16612 58.679% 90.290% ############ ( 2, 3 ] 1605 5.669% 95.959% # ( 3, 4 ] 589 2.081% 98.040% ( 4, 6 ] 356 1.258% 99.297% ( 6, 10 ] 163 0.576% 99.873% ( 10, 15 ] 12 0.042% 99.915% ( 15, 22 ] 3 0.011% 99.926% ( 76, 110 ] 14 0.049% 99.975% ( 110, 170 ] 2 0.007% 99.982% ( 170, 250 ] 2 0.007% 99.989% ( 250, 380 ] 2 0.007% 99.996% ( 580, 870 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 335179 Average: 5.9600 StdDev: 67.73 Min: 0 Median: 1.5791 Max: 7981 Percentiles: P50: 1.58 P75: 1.99 P99: 13.11 P99.9: 702.87 P99.99: 1792.60 ------------------------------------------------------ [ 0, 1 ] 50232 14.987% 14.987% ### ( 1, 2 ] 202671 60.466% 75.453% ############ ( 2, 3 ] 38502 11.487% 86.940% ## ( 3, 4 ] 20402 6.087% 93.027% # ( 4, 6 ] 13926 4.155% 97.182% # ( 6, 10 ] 5555 1.657% 98.839% ( 10, 15 ] 866 0.258% 99.097% ( 15, 22 ] 112 0.033% 99.131% ( 22, 34 ] 59 0.018% 99.149% ( 34, 51 ] 2 0.001% 99.149% ( 51, 76 ] 14 0.004% 99.153% ( 76, 110 ] 257 0.077% 99.230% ( 110, 170 ] 755 0.225% 99.455% ( 170, 250 ] 498 0.149% 99.604% ( 250, 380 ] 440 0.131% 99.735% ( 380, 580 ] 438 0.131% 99.866% ( 580, 870 ] 271 0.081% 99.947% ( 870, 1300 ] 111 0.033% 99.980% ( 1300, 1900 ] 42 0.013% 99.992% ( 1900, 2900 ] 39 0.012% 100.004% ( 2900, 4400 ] 32 0.010% 100.013% ( 4400, 6600 ] 7 0.002% 100.016% ( 6600, 9900 ] 4 0.001% 100.017% ** Level 4 read latency histogram (micros): Count: 114593 Average: 4.1874 StdDev: 44.10 Min: 0 Median: 1.5948 Max: 4886 Percentiles: P50: 1.59 P75: 1.99 P99: 9.36 P99.9: 502.27 P99.99: 1990.12 ------------------------------------------------------ [ 0, 1 ] 14528 12.678% 12.678% ### ( 1, 2 ] 71905 62.748% 75.426% ############# ( 2, 3 ] 12839 11.204% 86.630% ## ( 3, 4 ] 7496 6.541% 93.171% # ( 4, 6 ] 4891 4.268% 97.440% # ( 6, 10 ] 2128 1.857% 99.297% ( 10, 15 ] 248 0.216% 99.513% ( 15, 22 ] 27 0.024% 99.537% ( 22, 34 ] 13 0.011% 99.548% ( 34, 51 ] 4 0.003% 99.551% ( 51, 76 ] 2 0.002% 99.553% ( 76, 110 ] 47 0.041% 99.594% ( 110, 170 ] 144 0.126% 99.720% ( 170, 250 ] 68 0.059% 99.779% ( 250, 380 ] 95 0.083% 99.862% ( 380, 580 ] 71 0.062% 99.924% ( 580, 870 ] 46 0.040% 99.964% ( 870, 1300 ] 22 0.019% 99.983% ( 1300, 1900 ] 7 0.006% 99.990% ( 1900, 2900 ] 6 0.005% 99.995% ( 2900, 4400 ] 5 0.004% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 881.3333 StdDev: 1026.43 Min: 76 Median: 380.0000 Max: 4280 Percentiles: P50: 380.00 P75: 1300.00 P99: 4200.00 P99.9: 4280.00 P99.99: 4280.00 ------------------------------------------------------ ( 51, 76 ] 1 0.833% 0.833% ( 76, 110 ] 14 11.667% 12.500% ## ( 110, 170 ] 15 12.500% 25.000% ### ( 170, 250 ] 15 12.500% 37.500% ### ( 250, 380 ] 15 12.500% 50.000% ### ( 380, 580 ] 16 13.333% 63.333% ### ( 580, 870 ] 8 6.667% 70.000% # ( 870, 1300 ] 6 5.000% 75.000% # ( 1300, 1900 ] 7 5.833% 80.833% # ( 1900, 2900 ] 14 11.667% 92.500% ## ( 2900, 4400 ] 9 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 21.2 total, 3.2 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 279.02 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:4.935 H:M:S, 23.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 308.75 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.511 H:M:S, 16.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/27-17:05:55 ... thread 0: (1000000,7000000) ops and (319453.4,290954.1) ops/second in (3.130347,24.058777) 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.23 GB 69.2 6.4 0.0 6.4 13.0 6.6 0.0 2.0 146.0 297.3 44.87 41.74 118 0.380 6651K 12K 0.0 0.0 L1 4/4 331.18 MB 0.0 2.5 2.3 0.3 2.5 2.3 0.1 1.1 236.9 235.3 10.91 10.58 3 3.638 2625K 16K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 2.0 1.8 238.1 238.1 0.47 0.44 1 0.468 113K 42 0.0 0.0 L3 13/0 953.79 MB 1.0 1.5 0.6 0.9 1.5 0.6 1.5 2.6 218.8 218.7 7.16 6.31 4 1.791 1579K 759 0.0 0.0 L4 169/0 9.53 GB 1.0 1.7 0.8 0.9 1.7 0.8 1.2 2.1 174.2 173.4 9.80 7.27 7 1.400 993K 3033 0.0 0.0 L5 1068/0 87.72 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1273/19 102.74 GB 0.0 12.2 3.7 8.5 18.8 10.3 6.8 2.8 171.0 263.4 73.21 66.34 133 0.550 11M 33K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.2 3.7 8.5 18.8 10.3 6.8 2.8 171.0 263.4 73.21 66.34 133 0.550 11M 33K 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 12.2 3.7 8.5 12.2 3.7 0.0 0.0 235.2 234.5 53.24 48.95 35 1.521 11M 33K 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 340.7 19.97 17.39 98 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): 24.3 total, 24.1 interval Flush(GB): cumulative 6.644, interval 6.644 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 18.83 GB write, 793.87 MB/s write, 12.23 GB read, 515.42 MB/s read, 73.2 seconds Interval compaction: 18.83 GB write, 801.58 MB/s write, 12.23 GB read, 520.42 MB/s read, 73.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 27, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 14, total-stops: 27, interval: 41 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2481722 Average: 2.2616 StdDev: 13.06 Min: 0 Median: 1.4787 Max: 7830 Percentiles: P50: 1.48 P75: 1.87 P99: 5.85 P99.9: 10.75 P99.99: 95.52 ------------------------------------------------------ [ 0, 1 ] 472309 19.032% 19.032% #### ( 1, 2 ] 1605557 64.695% 83.727% ############# ( 2, 3 ] 217013 8.744% 92.471% ## ( 3, 4 ] 102705 4.138% 96.610% # ( 4, 6 ] 64082 2.582% 99.192% # ( 6, 10 ] 17267 0.696% 99.888% ( 10, 15 ] 2066 0.083% 99.971% ( 15, 22 ] 235 0.009% 99.980% ( 22, 34 ] 29 0.001% 99.982% ( 34, 51 ] 17 0.001% 99.982% ( 51, 76 ] 18 0.001% 99.983% ( 76, 110 ] 308 0.012% 99.995% ( 110, 170 ] 327 0.013% 100.009% ( 170, 250 ] 177 0.007% 100.016% ( 250, 380 ] 122 0.005% 100.021% ( 380, 580 ] 100 0.004% 100.025% ( 580, 870 ] 59 0.002% 100.027% ( 870, 1300 ] 36 0.001% 100.028% ( 1300, 1900 ] 15 0.001% 100.029% ( 1900, 2900 ] 11 0.000% 100.029% ( 2900, 4400 ] 11 0.000% 100.030% ( 4400, 6600 ] 1 0.000% 100.030% ( 6600, 9900 ] 1 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 350712 Average: 3.1366 StdDev: 28.34 Min: 0 Median: 1.6850 Max: 4331 Percentiles: P50: 1.68 P75: 2.47 P99: 7.70 P99.9: 13.30 P99.99: 39.99 ------------------------------------------------------ [ 0, 1 ] 38206 10.894% 10.894% ## ( 1, 2 ] 200219 57.089% 67.983% ########### ( 2, 3 ] 51993 14.825% 82.808% ### ( 3, 4 ] 27614 7.874% 90.682% ## ( 4, 6 ] 27147 7.741% 98.422% ## ( 6, 10 ] 4768 1.360% 99.782% ( 10, 15 ] 627 0.179% 99.961% ( 15, 22 ] 80 0.023% 99.983% ( 22, 34 ] 12 0.003% 99.987% ( 34, 51 ] 31 0.009% 99.996% ( 51, 76 ] 21 0.006% 100.002% ( 76, 110 ] 27 0.008% 100.009% ( 110, 170 ] 27 0.008% 100.017% ( 170, 250 ] 33 0.009% 100.027% ( 250, 380 ] 53 0.015% 100.042% ( 380, 580 ] 48 0.014% 100.055% ( 580, 870 ] 49 0.014% 100.069% ( 870, 1300 ] 34 0.010% 100.079% ( 1300, 1900 ] 16 0.005% 100.084% ( 1900, 2900 ] 14 0.004% 100.088% ( 2900, 4400 ] 6 0.002% 100.089% ** Level 2 read latency histogram (micros): Count: 28310 Average: 1.9761 StdDev: 5.34 Min: 0 Median: 1.3134 Max: 623 Percentiles: P50: 1.31 P75: 1.74 P99: 5.53 P99.9: 13.20 P99.99: 260.98 ------------------------------------------------------ [ 0, 1 ] 8949 31.611% 31.611% ###### ( 1, 2 ] 16612 58.679% 90.290% ############ ( 2, 3 ] 1605 5.669% 95.959% # ( 3, 4 ] 589 2.081% 98.040% ( 4, 6 ] 356 1.258% 99.297% ( 6, 10 ] 163 0.576% 99.873% ( 10, 15 ] 12 0.042% 99.915% ( 15, 22 ] 3 0.011% 99.926% ( 76, 110 ] 14 0.049% 99.975% ( 110, 170 ] 2 0.007% 99.982% ( 170, 250 ] 2 0.007% 99.989% ( 250, 380 ] 2 0.007% 99.996% ( 580, 870 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 335179 Average: 5.9600 StdDev: 67.73 Min: 0 Median: 1.5791 Max: 7981 Percentiles: P50: 1.58 P75: 1.99 P99: 13.11 P99.9: 702.87 P99.99: 1792.60 ------------------------------------------------------ [ 0, 1 ] 50232 14.987% 14.987% ### ( 1, 2 ] 202671 60.466% 75.453% ############ ( 2, 3 ] 38502 11.487% 86.940% ## ( 3, 4 ] 20402 6.087% 93.027% # ( 4, 6 ] 13926 4.155% 97.182% # ( 6, 10 ] 5555 1.657% 98.839% ( 10, 15 ] 866 0.258% 99.097% ( 15, 22 ] 112 0.033% 99.131% ( 22, 34 ] 59 0.018% 99.149% ( 34, 51 ] 2 0.001% 99.149% ( 51, 76 ] 14 0.004% 99.153% ( 76, 110 ] 257 0.077% 99.230% ( 110, 170 ] 755 0.225% 99.455% ( 170, 250 ] 498 0.149% 99.604% ( 250, 380 ] 440 0.131% 99.735% ( 380, 580 ] 438 0.131% 99.866% ( 580, 870 ] 271 0.081% 99.947% ( 870, 1300 ] 111 0.033% 99.980% ( 1300, 1900 ] 42 0.013% 99.992% ( 1900, 2900 ] 39 0.012% 100.004% ( 2900, 4400 ] 32 0.010% 100.013% ( 4400, 6600 ] 7 0.002% 100.016% ( 6600, 9900 ] 4 0.001% 100.017% ** Level 4 read latency histogram (micros): Count: 114593 Average: 4.1874 StdDev: 44.10 Min: 0 Median: 1.5948 Max: 4886 Percentiles: P50: 1.59 P75: 1.99 P99: 9.36 P99.9: 502.27 P99.99: 1990.12 ------------------------------------------------------ [ 0, 1 ] 14528 12.678% 12.678% ### ( 1, 2 ] 71905 62.748% 75.426% ############# ( 2, 3 ] 12839 11.204% 86.630% ## ( 3, 4 ] 7496 6.541% 93.171% # ( 4, 6 ] 4891 4.268% 97.440% # ( 6, 10 ] 2128 1.857% 99.297% ( 10, 15 ] 248 0.216% 99.513% ( 15, 22 ] 27 0.024% 99.537% ( 22, 34 ] 13 0.011% 99.548% ( 34, 51 ] 4 0.003% 99.551% ( 51, 76 ] 2 0.002% 99.553% ( 76, 110 ] 47 0.041% 99.594% ( 110, 170 ] 144 0.126% 99.720% ( 170, 250 ] 68 0.059% 99.779% ( 250, 380 ] 95 0.083% 99.862% ( 380, 580 ] 71 0.062% 99.924% ( 580, 870 ] 46 0.040% 99.964% ( 870, 1300 ] 22 0.019% 99.983% ( 1300, 1900 ] 7 0.006% 99.990% ( 1900, 2900 ] 6 0.005% 99.995% ( 2900, 4400 ] 5 0.004% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 881.3333 StdDev: 1026.43 Min: 76 Median: 380.0000 Max: 4280 Percentiles: P50: 380.00 P75: 1300.00 P99: 4200.00 P99.9: 4280.00 P99.99: 4280.00 ------------------------------------------------------ ( 51, 76 ] 1 0.833% 0.833% ( 76, 110 ] 14 11.667% 12.500% ## ( 110, 170 ] 15 12.500% 25.000% ### ( 170, 250 ] 15 12.500% 37.500% ### ( 250, 380 ] 15 12.500% 50.000% ### ( 380, 580 ] 16 13.333% 63.333% ### ( 580, 870 ] 8 6.667% 70.000% # ( 870, 1300 ] 6 5.000% 75.000% # ( 1300, 1900 ] 7 5.833% 80.833% # ( 1900, 2900 ] 14 11.667% 92.500% ## ( 2900, 4400 ] 9 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 24.3 total, 3.1 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 283.58 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.429 H:M:S, 22.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 314.40 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.494 H:M:S, 15.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/27-17:06:05 ... thread 0: (1000000,8000000) ops and (104606.2,237964.6) ops/second in (9.559666,33.618443) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/15 5.15 GB 162.9 8.7 0.0 8.7 16.2 7.5 0.0 2.1 157.3 294.2 56.45 52.65 138 0.409 9016K 21K 0.0 0.0 L1 4/4 331.18 MB 0.0 2.5 2.3 0.3 2.5 2.3 0.1 1.1 236.9 235.3 10.91 10.58 3 3.638 2625K 16K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 2.0 1.8 238.1 238.1 0.47 0.44 1 0.468 113K 42 0.0 0.0 L3 13/0 953.79 MB 1.0 1.5 0.6 0.9 1.5 0.6 1.5 2.6 218.8 218.7 7.16 6.31 4 1.791 1579K 759 0.0 0.0 L4 169/0 9.53 GB 1.0 1.7 0.8 0.9 1.7 0.8 1.2 2.1 174.2 173.4 9.80 7.27 7 1.400 993K 3033 0.0 0.0 L5 1068/0 87.72 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1271/19 103.66 GB 0.0 14.5 3.7 10.8 22.0 11.2 6.8 2.9 175.1 266.0 84.80 77.25 153 0.554 14M 41K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.5 3.7 10.8 22.0 11.2 6.8 2.9 175.1 266.0 84.80 77.25 153 0.554 14M 41K 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 3.7 10.8 14.5 3.7 0.0 0.0 238.9 238.2 62.16 57.49 40 1.554 14M 41K 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 342.4 22.63 19.76 113 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 33.9 total, 33.6 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 22.02 GB write, 666.19 MB/s write, 14.50 GB read, 438.69 MB/s read, 84.8 seconds Interval compaction: 22.02 GB write, 670.82 MB/s write, 14.50 GB read, 441.74 MB/s read, 84.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 24, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 24, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 27, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 24, total-stops: 27, interval: 51 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3569172 Average: 2.4471 StdDev: 14.65 Min: 0 Median: 1.4736 Max: 7830 Percentiles: P50: 1.47 P75: 1.86 P99: 6.13 P99.9: 102.23 P99.99: 198.50 ------------------------------------------------------ [ 0, 1 ] 684917 19.190% 19.190% #### ( 1, 2 ] 2322121 65.060% 84.250% ############# ( 2, 3 ] 304720 8.538% 92.788% ## ( 3, 4 ] 137984 3.866% 96.654% # ( 4, 6 ] 82838 2.321% 98.975% ( 6, 10 ] 28045 0.786% 99.761% ( 10, 15 ] 2827 0.079% 99.840% ( 15, 22 ] 414 0.012% 99.851% ( 22, 34 ] 41 0.001% 99.852% ( 34, 51 ] 19 0.001% 99.853% ( 51, 76 ] 37 0.001% 99.854% ( 76, 110 ] 2127 0.060% 99.914% ( 110, 170 ] 2512 0.070% 99.984% ( 170, 250 ] 601 0.017% 100.001% ( 250, 380 ] 395 0.011% 100.012% ( 380, 580 ] 301 0.008% 100.020% ( 580, 870 ] 164 0.005% 100.025% ( 870, 1300 ] 58 0.002% 100.027% ( 1300, 1900 ] 24 0.001% 100.027% ( 1900, 2900 ] 15 0.000% 100.028% ( 2900, 4400 ] 15 0.000% 100.028% ( 4400, 6600 ] 2 0.000% 100.028% ( 6600, 9900 ] 1 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 350712 Average: 3.1366 StdDev: 28.34 Min: 0 Median: 1.6850 Max: 4331 Percentiles: P50: 1.68 P75: 2.47 P99: 7.70 P99.9: 13.30 P99.99: 39.99 ------------------------------------------------------ [ 0, 1 ] 38206 10.894% 10.894% ## ( 1, 2 ] 200219 57.089% 67.983% ########### ( 2, 3 ] 51993 14.825% 82.808% ### ( 3, 4 ] 27614 7.874% 90.682% ## ( 4, 6 ] 27147 7.741% 98.422% ## ( 6, 10 ] 4768 1.360% 99.782% ( 10, 15 ] 627 0.179% 99.961% ( 15, 22 ] 80 0.023% 99.983% ( 22, 34 ] 12 0.003% 99.987% ( 34, 51 ] 31 0.009% 99.996% ( 51, 76 ] 21 0.006% 100.002% ( 76, 110 ] 27 0.008% 100.009% ( 110, 170 ] 27 0.008% 100.017% ( 170, 250 ] 33 0.009% 100.027% ( 250, 380 ] 53 0.015% 100.042% ( 380, 580 ] 48 0.014% 100.055% ( 580, 870 ] 49 0.014% 100.069% ( 870, 1300 ] 34 0.010% 100.079% ( 1300, 1900 ] 16 0.005% 100.084% ( 1900, 2900 ] 14 0.004% 100.088% ( 2900, 4400 ] 6 0.002% 100.089% ** Level 2 read latency histogram (micros): Count: 28310 Average: 1.9761 StdDev: 5.34 Min: 0 Median: 1.3134 Max: 623 Percentiles: P50: 1.31 P75: 1.74 P99: 5.53 P99.9: 13.20 P99.99: 260.98 ------------------------------------------------------ [ 0, 1 ] 8949 31.611% 31.611% ###### ( 1, 2 ] 16612 58.679% 90.290% ############ ( 2, 3 ] 1605 5.669% 95.959% # ( 3, 4 ] 589 2.081% 98.040% ( 4, 6 ] 356 1.258% 99.297% ( 6, 10 ] 163 0.576% 99.873% ( 10, 15 ] 12 0.042% 99.915% ( 15, 22 ] 3 0.011% 99.926% ( 76, 110 ] 14 0.049% 99.975% ( 110, 170 ] 2 0.007% 99.982% ( 170, 250 ] 2 0.007% 99.989% ( 250, 380 ] 2 0.007% 99.996% ( 580, 870 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 335179 Average: 5.9600 StdDev: 67.73 Min: 0 Median: 1.5791 Max: 7981 Percentiles: P50: 1.58 P75: 1.99 P99: 13.11 P99.9: 702.87 P99.99: 1792.60 ------------------------------------------------------ [ 0, 1 ] 50232 14.987% 14.987% ### ( 1, 2 ] 202671 60.466% 75.453% ############ ( 2, 3 ] 38502 11.487% 86.940% ## ( 3, 4 ] 20402 6.087% 93.027% # ( 4, 6 ] 13926 4.155% 97.182% # ( 6, 10 ] 5555 1.657% 98.839% ( 10, 15 ] 866 0.258% 99.097% ( 15, 22 ] 112 0.033% 99.131% ( 22, 34 ] 59 0.018% 99.149% ( 34, 51 ] 2 0.001% 99.149% ( 51, 76 ] 14 0.004% 99.153% ( 76, 110 ] 257 0.077% 99.230% ( 110, 170 ] 755 0.225% 99.455% ( 170, 250 ] 498 0.149% 99.604% ( 250, 380 ] 440 0.131% 99.735% ( 380, 580 ] 438 0.131% 99.866% ( 580, 870 ] 271 0.081% 99.947% ( 870, 1300 ] 111 0.033% 99.980% ( 1300, 1900 ] 42 0.013% 99.992% ( 1900, 2900 ] 39 0.012% 100.004% ( 2900, 4400 ] 32 0.010% 100.013% ( 4400, 6600 ] 7 0.002% 100.016% ( 6600, 9900 ] 4 0.001% 100.017% ** Level 4 read latency histogram (micros): Count: 114593 Average: 4.1874 StdDev: 44.10 Min: 0 Median: 1.5948 Max: 4886 Percentiles: P50: 1.59 P75: 1.99 P99: 9.36 P99.9: 502.27 P99.99: 1990.12 ------------------------------------------------------ [ 0, 1 ] 14528 12.678% 12.678% ### ( 1, 2 ] 71905 62.748% 75.426% ############# ( 2, 3 ] 12839 11.204% 86.630% ## ( 3, 4 ] 7496 6.541% 93.171% # ( 4, 6 ] 4891 4.268% 97.440% # ( 6, 10 ] 2128 1.857% 99.297% ( 10, 15 ] 248 0.216% 99.513% ( 15, 22 ] 27 0.024% 99.537% ( 22, 34 ] 13 0.011% 99.548% ( 34, 51 ] 4 0.003% 99.551% ( 51, 76 ] 2 0.002% 99.553% ( 76, 110 ] 47 0.041% 99.594% ( 110, 170 ] 144 0.126% 99.720% ( 170, 250 ] 68 0.059% 99.779% ( 250, 380 ] 95 0.083% 99.862% ( 380, 580 ] 71 0.062% 99.924% ( 580, 870 ] 46 0.040% 99.964% ( 870, 1300 ] 22 0.019% 99.983% ( 1300, 1900 ] 7 0.006% 99.990% ( 1900, 2900 ] 6 0.005% 99.995% ( 2900, 4400 ] 5 0.004% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 881.3333 StdDev: 1026.43 Min: 76 Median: 380.0000 Max: 4280 Percentiles: P50: 380.00 P75: 1300.00 P99: 4200.00 P99.9: 4280.00 P99.99: 4280.00 ------------------------------------------------------ ( 51, 76 ] 1 0.833% 0.833% ( 76, 110 ] 14 11.667% 12.500% ## ( 110, 170 ] 15 12.500% 25.000% ### ( 170, 250 ] 15 12.500% 37.500% ### ( 250, 380 ] 15 12.500% 50.000% ### ( 380, 580 ] 16 13.333% 63.333% ### ( 580, 870 ] 8 6.667% 70.000% # ( 870, 1300 ] 6 5.000% 75.000% # ( 1300, 1900 ] 7 5.833% 80.833% # ( 1900, 2900 ] 14 11.667% 92.500% ## ( 2900, 4400 ] 9 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 33.9 total, 9.6 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 232.57 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:12.025 H:M:S, 35.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 102.95 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:6.596 H:M:S, 69.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/27-17:06:14 ... thread 0: (1000000,9000000) ops and (102420.5,207458.8) ops/second in (9.763666,43.382109) 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/7 2.82 GB 6.3 10.2 0.0 10.2 18.7 8.5 0.0 2.2 156.3 286.8 66.89 61.12 156 0.429 10M 24K 0.0 0.0 L1 14/14 1.33 GB 0.0 6.2 5.6 0.6 6.1 5.5 0.1 1.1 224.7 222.0 28.07 26.69 4 7.017 6404K 75K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 4.3 1.8 238.1 238.1 0.47 0.44 1 0.468 113K 42 0.0 0.0 L3 18/1 1.10 GB 1.0 3.6 1.9 1.7 3.6 1.9 2.4 1.9 176.3 175.0 21.11 16.07 10 2.111 3768K 27K 0.0 0.0 L4 168/3 9.60 GB 1.0 4.1 2.8 1.3 4.1 2.8 1.2 1.5 150.4 149.7 28.03 18.83 33 0.849 3532K 14K 0.0 0.0 L5 1092/0 89.69 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1300/25 104.54 GB 0.0 24.2 10.4 13.8 32.6 18.8 12.0 3.8 171.6 231.2 144.57 123.15 204 0.709 24M 141K 0.0 0.0 Int 0/0 0.00 KB 0.0 24.2 10.4 13.8 32.6 18.8 11.9 3.8 171.6 231.2 144.57 123.15 204 0.709 24M 141K 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 24.2 10.4 13.8 24.1 10.3 0.0 0.0 210.1 208.9 118.07 100.77 77 1.533 24M 141K 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 330.4 26.50 22.38 127 0.209 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): 43.6 total, 43.4 interval Flush(GB): cumulative 8.552, interval 8.552 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: 32.64 GB write, 766.22 MB/s write, 24.23 GB read, 568.84 MB/s read, 144.6 seconds Interval compaction: 32.64 GB write, 770.34 MB/s write, 24.23 GB read, 571.90 MB/s read, 144.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 29, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 29, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 39, pending-compaction-bytes-delays: 15, pending-compaction-bytes-stops: 0, total-delays: 44, total-stops: 39, interval: 83 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4294388 Average: 2.5559 StdDev: 20.06 Min: 0 Median: 1.4877 Max: 7830 Percentiles: P50: 1.49 P75: 1.88 P99: 6.83 P99.9: 107.45 P99.99: 232.06 ------------------------------------------------------ [ 0, 1 ] 796790 18.554% 18.554% #### ( 1, 2 ] 2768790 64.475% 83.029% ############# ( 2, 3 ] 386172 8.992% 92.021% ## ( 3, 4 ] 175926 4.097% 96.118% # ( 4, 6 ] 115566 2.691% 98.809% # ( 6, 10 ] 39548 0.921% 99.730% ( 10, 15 ] 4217 0.098% 99.828% ( 15, 22 ] 551 0.013% 99.841% ( 22, 34 ] 59 0.001% 99.842% ( 34, 51 ] 21 0.000% 99.843% ( 51, 76 ] 49 0.001% 99.844% ( 76, 110 ] 2601 0.061% 99.905% ( 110, 170 ] 3080 0.072% 99.976% ( 170, 250 ] 760 0.018% 99.994% ( 250, 380 ] 517 0.012% 100.006% ( 380, 580 ] 407 0.009% 100.016% ( 580, 870 ] 248 0.006% 100.021% ( 870, 1300 ] 107 0.002% 100.024% ( 1300, 1900 ] 42 0.001% 100.025% ( 1900, 2900 ] 36 0.001% 100.026% ( 2900, 4400 ] 29 0.001% 100.026% ( 4400, 6600 ] 9 0.000% 100.026% ( 6600, 9900 ] 6 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 1037329 Average: 3.9451 StdDev: 38.51 Min: 0 Median: 1.7919 Max: 6228 Percentiles: P50: 1.79 P75: 2.83 P99: 9.00 P99.9: 14.32 P99.99: 20.27 ------------------------------------------------------ [ 0, 1 ] 76701 7.394% 7.394% # ( 1, 2 ] 558114 53.803% 61.197% ########### ( 2, 3 ] 172938 16.671% 77.869% ### ( 3, 4 ] 97671 9.416% 87.284% ## ( 4, 6 ] 102886 9.918% 97.203% ## ( 6, 10 ] 24827 2.393% 99.596% ( 10, 15 ] 3652 0.352% 99.948% ( 15, 22 ] 579 0.056% 100.004% ( 22, 34 ] 65 0.006% 100.010% ( 34, 51 ] 37 0.004% 100.014% ( 51, 76 ] 66 0.006% 100.020% ( 76, 110 ] 218 0.021% 100.041% ( 110, 170 ] 254 0.024% 100.065% ( 170, 250 ] 260 0.025% 100.091% ( 250, 380 ] 360 0.035% 100.125% ( 380, 580 ] 405 0.039% 100.164% ( 580, 870 ] 306 0.029% 100.194% ( 870, 1300 ] 163 0.016% 100.209% ( 1300, 1900 ] 87 0.008% 100.218% ( 1900, 2900 ] 55 0.005% 100.223% ( 2900, 4400 ] 32 0.003% 100.226% ( 4400, 6600 ] 6 0.001% 100.227% ** Level 2 read latency histogram (micros): Count: 28310 Average: 1.9761 StdDev: 5.34 Min: 0 Median: 1.3134 Max: 623 Percentiles: P50: 1.31 P75: 1.74 P99: 5.53 P99.9: 13.20 P99.99: 260.98 ------------------------------------------------------ [ 0, 1 ] 8949 31.611% 31.611% ###### ( 1, 2 ] 16612 58.679% 90.290% ############ ( 2, 3 ] 1605 5.669% 95.959% # ( 3, 4 ] 589 2.081% 98.040% ( 4, 6 ] 356 1.258% 99.297% ( 6, 10 ] 163 0.576% 99.873% ( 10, 15 ] 12 0.042% 99.915% ( 15, 22 ] 3 0.011% 99.926% ( 76, 110 ] 14 0.049% 99.975% ( 110, 170 ] 2 0.007% 99.982% ( 170, 250 ] 2 0.007% 99.989% ( 250, 380 ] 2 0.007% 99.996% ( 580, 870 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 881378 Average: 5.9464 StdDev: 79.34 Min: 0 Median: 1.7756 Max: 12937 Percentiles: P50: 1.78 P75: 2.76 P99: 9.09 P99.9: 290.44 P99.99: 468.33 ------------------------------------------------------ [ 0, 1 ] 66554 7.551% 7.551% ## ( 1, 2 ] 482412 54.734% 62.285% ########### ( 2, 3 ] 146589 16.632% 78.917% ### ( 3, 4 ] 86989 9.870% 88.786% ## ( 4, 6 ] 78525 8.909% 97.696% ## ( 6, 10 ] 14894 1.690% 99.386% ( 10, 15 ] 2229 0.253% 99.639% ( 15, 22 ] 233 0.026% 99.665% ( 22, 34 ] 72 0.008% 99.673% ( 34, 51 ] 6 0.001% 99.674% ( 51, 76 ] 17 0.002% 99.676% ( 76, 110 ] 276 0.031% 99.707% ( 110, 170 ] 833 0.095% 99.802% ( 170, 250 ] 662 0.075% 99.877% ( 250, 380 ] 661 0.075% 99.952% ( 380, 580 ] 765 0.087% 100.038% ( 580, 870 ] 620 0.070% 100.109% ( 870, 1300 ] 345 0.039% 100.148% ( 1300, 1900 ] 145 0.016% 100.164% ( 1900, 2900 ] 100 0.011% 100.176% ( 2900, 4400 ] 132 0.015% 100.191% ( 4400, 6600 ] 37 0.004% 100.195% ( 6600, 9900 ] 11 0.001% 100.196% ( 9900, 14000 ] 3 0.000% 100.197% ** Level 4 read latency histogram (micros): Count: 189321 Average: 9.0978 StdDev: 107.67 Min: 0 Median: 1.7030 Max: 7095 Percentiles: P50: 1.70 P75: 2.54 P99: 13.82 P99.9: 1248.64 P99.99: 3100.03 ------------------------------------------------------ [ 0, 1 ] 17515 9.251% 9.251% ## ( 1, 2 ] 109741 57.966% 67.217% ############ ( 2, 3 ] 27228 14.382% 81.599% ### ( 3, 4 ] 15521 8.198% 89.797% ## ( 4, 6 ] 12876 6.801% 96.598% # ( 6, 10 ] 4076 2.153% 98.751% ( 10, 15 ] 617 0.326% 99.077% ( 15, 22 ] 76 0.040% 99.117% ( 22, 34 ] 27 0.014% 99.132% ( 34, 51 ] 7 0.004% 99.135% ( 51, 76 ] 10 0.005% 99.141% ( 76, 110 ] 72 0.038% 99.179% ( 110, 170 ] 225 0.119% 99.297% ( 170, 250 ] 192 0.101% 99.399% ( 250, 380 ] 229 0.121% 99.520% ( 380, 580 ] 265 0.140% 99.660% ( 580, 870 ] 268 0.142% 99.801% ( 870, 1300 ] 212 0.112% 99.913% ( 1300, 1900 ] 90 0.048% 99.961% ( 1900, 2900 ] 48 0.025% 99.986% ( 2900, 4400 ] 53 0.028% 100.014% ( 4400, 6600 ] 16 0.008% 100.023% ( 6600, 9900 ] 2 0.001% 100.024% ** Level 5 read latency histogram (micros): Count: 240 Average: 1131.2792 StdDev: 1325.75 Min: 76 Median: 511.0345 Max: 8679 Percentiles: P50: 511.03 P75: 1700.00 P99: 6086.67 P99.9: 8679.00 P99.99: 8679.00 ------------------------------------------------------ ( 51, 76 ] 1 0.417% 0.417% ( 76, 110 ] 19 7.917% 8.333% ## ( 110, 170 ] 25 10.417% 18.750% ## ( 170, 250 ] 26 10.833% 29.583% ## ( 250, 380 ] 30 12.500% 42.083% ### ( 380, 580 ] 29 12.083% 54.167% ## ( 580, 870 ] 17 7.083% 61.250% # ( 870, 1300 ] 21 8.750% 70.000% ## ( 1300, 1900 ] 18 7.500% 77.500% ## ( 1900, 2900 ] 26 10.833% 88.333% ## ( 2900, 4400 ] 21 8.750% 97.083% ## ( 4400, 6600 ] 6 2.500% 99.583% # ( 6600, 9900 ] 1 0.417% 100.000% ** DB Stats ** Uptime(secs): 43.6 total, 9.8 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 203.08 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:18.582 H:M:S, 42.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 100.80 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:6.556 H:M:S, 67.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/27-17:06:17 ... thread 0: (1000000,10000000) ops and (324531.5,215222.8) ops/second in (3.081365,46.463474) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/7 3.74 GB 113.3 11.1 0.0 11.1 20.6 9.4 0.0 2.2 155.7 287.9 73.20 67.06 172 0.426 11M 25K 0.0 0.0 L1 14/14 1.33 GB 0.0 6.2 5.6 0.6 6.1 5.5 0.1 1.1 224.7 222.0 28.07 26.69 4 7.017 6404K 75K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 4.3 1.8 238.1 238.1 0.47 0.44 1 0.468 113K 42 0.0 0.0 L3 17/0 999.19 MB 1.0 3.6 1.9 1.7 3.6 1.9 2.4 1.9 176.3 175.0 21.11 16.07 10 2.111 3768K 27K 0.0 0.0 L4 169/0 9.73 GB 1.0 4.3 2.9 1.4 4.3 2.9 1.2 1.5 151.5 150.7 29.36 19.84 34 0.864 3768K 17K 0.0 0.0 L5 1092/0 89.69 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1304/21 105.46 GB 0.0 25.4 10.5 14.8 34.7 19.9 12.0 3.7 170.7 233.5 152.22 130.09 221 0.689 25M 145K 0.0 0.0 Int 0/0 0.00 KB 0.0 25.4 10.5 14.8 34.7 19.9 11.9 3.7 170.7 233.5 152.22 130.09 221 0.689 25M 145K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 25.4 10.5 14.8 25.2 10.4 0.0 0.0 211.3 210.1 122.99 105.29 81 1.518 25M 145K 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 332.0 29.23 24.81 140 0.209 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): 46.7 total, 46.5 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: 34.71 GB write, 761.02 MB/s write, 25.38 GB read, 556.52 MB/s read, 152.2 seconds Interval compaction: 34.71 GB write, 764.85 MB/s write, 25.38 GB read, 559.32 MB/s read, 152.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 29, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 29, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 44, pending-compaction-bytes-delays: 15, pending-compaction-bytes-stops: 0, total-delays: 44, total-stops: 44, interval: 88 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4747983 Average: 2.5275 StdDev: 19.17 Min: 0 Median: 1.4920 Max: 7830 Percentiles: P50: 1.49 P75: 1.88 P99: 6.73 P99.9: 99.46 P99.99: 207.66 ------------------------------------------------------ [ 0, 1 ] 862340 18.162% 18.162% #### ( 1, 2 ] 3072180 64.705% 82.867% ############# ( 2, 3 ] 434045 9.142% 92.009% ## ( 3, 4 ] 195585 4.119% 96.128% # ( 4, 6 ] 128416 2.705% 98.833% # ( 6, 10 ] 43497 0.916% 99.749% ( 10, 15 ] 4648 0.098% 99.847% ( 15, 22 ] 584 0.012% 99.859% ( 22, 34 ] 63 0.001% 99.860% ( 34, 51 ] 24 0.001% 99.861% ( 51, 76 ] 53 0.001% 99.862% ( 76, 110 ] 2609 0.055% 99.917% ( 110, 170 ] 3098 0.065% 99.982% ( 170, 250 ] 778 0.016% 99.999% ( 250, 380 ] 527 0.011% 100.010% ( 380, 580 ] 418 0.009% 100.019% ( 580, 870 ] 251 0.005% 100.024% ( 870, 1300 ] 113 0.002% 100.026% ( 1300, 1900 ] 44 0.001% 100.027% ( 1900, 2900 ] 36 0.001% 100.028% ( 2900, 4400 ] 29 0.001% 100.029% ( 4400, 6600 ] 9 0.000% 100.029% ( 6600, 9900 ] 6 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 1042754 Average: 3.9373 StdDev: 38.41 Min: 0 Median: 1.7908 Max: 6228 Percentiles: P50: 1.79 P75: 2.82 P99: 9.00 P99.9: 14.32 P99.99: 20.27 ------------------------------------------------------ [ 0, 1 ] 77161 7.400% 7.400% # ( 1, 2 ] 561719 53.869% 61.269% ########### ( 2, 3 ] 173621 16.650% 77.919% ### ( 3, 4 ] 97996 9.398% 87.317% ## ( 4, 6 ] 103122 9.889% 97.206% ## ( 6, 10 ] 24928 2.391% 99.597% ( 10, 15 ] 3666 0.352% 99.948% ( 15, 22 ] 580 0.056% 100.004% ( 22, 34 ] 65 0.006% 100.010% ( 34, 51 ] 37 0.004% 100.014% ( 51, 76 ] 66 0.006% 100.020% ( 76, 110 ] 218 0.021% 100.041% ( 110, 170 ] 254 0.024% 100.065% ( 170, 250 ] 260 0.025% 100.090% ( 250, 380 ] 360 0.035% 100.125% ( 380, 580 ] 405 0.039% 100.163% ( 580, 870 ] 306 0.029% 100.193% ( 870, 1300 ] 163 0.016% 100.208% ( 1300, 1900 ] 87 0.008% 100.217% ( 1900, 2900 ] 55 0.005% 100.222% ( 2900, 4400 ] 32 0.003% 100.225% ( 4400, 6600 ] 6 0.001% 100.226% ** Level 2 read latency histogram (micros): Count: 28310 Average: 1.9761 StdDev: 5.34 Min: 0 Median: 1.3134 Max: 623 Percentiles: P50: 1.31 P75: 1.74 P99: 5.53 P99.9: 13.20 P99.99: 260.98 ------------------------------------------------------ [ 0, 1 ] 8949 31.611% 31.611% ###### ( 1, 2 ] 16612 58.679% 90.290% ############ ( 2, 3 ] 1605 5.669% 95.959% # ( 3, 4 ] 589 2.081% 98.040% ( 4, 6 ] 356 1.258% 99.297% ( 6, 10 ] 163 0.576% 99.873% ( 10, 15 ] 12 0.042% 99.915% ( 15, 22 ] 3 0.011% 99.926% ( 76, 110 ] 14 0.049% 99.975% ( 110, 170 ] 2 0.007% 99.982% ( 170, 250 ] 2 0.007% 99.989% ( 250, 380 ] 2 0.007% 99.996% ( 580, 870 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 881378 Average: 5.9464 StdDev: 79.34 Min: 0 Median: 1.7756 Max: 12937 Percentiles: P50: 1.78 P75: 2.76 P99: 9.09 P99.9: 290.44 P99.99: 468.33 ------------------------------------------------------ [ 0, 1 ] 66554 7.551% 7.551% ## ( 1, 2 ] 482412 54.734% 62.285% ########### ( 2, 3 ] 146589 16.632% 78.917% ### ( 3, 4 ] 86989 9.870% 88.786% ## ( 4, 6 ] 78525 8.909% 97.696% ## ( 6, 10 ] 14894 1.690% 99.386% ( 10, 15 ] 2229 0.253% 99.639% ( 15, 22 ] 233 0.026% 99.665% ( 22, 34 ] 72 0.008% 99.673% ( 34, 51 ] 6 0.001% 99.674% ( 51, 76 ] 17 0.002% 99.676% ( 76, 110 ] 276 0.031% 99.707% ( 110, 170 ] 833 0.095% 99.802% ( 170, 250 ] 662 0.075% 99.877% ( 250, 380 ] 661 0.075% 99.952% ( 380, 580 ] 765 0.087% 100.038% ( 580, 870 ] 620 0.070% 100.109% ( 870, 1300 ] 345 0.039% 100.148% ( 1300, 1900 ] 145 0.016% 100.164% ( 1900, 2900 ] 100 0.011% 100.176% ( 2900, 4400 ] 132 0.015% 100.191% ( 4400, 6600 ] 37 0.004% 100.195% ( 6600, 9900 ] 11 0.001% 100.196% ( 9900, 14000 ] 3 0.000% 100.197% ** Level 4 read latency histogram (micros): Count: 195379 Average: 8.9070 StdDev: 106.04 Min: 0 Median: 1.6997 Max: 7095 Percentiles: P50: 1.70 P75: 2.52 P99: 13.42 P99.9: 1236.65 P99.99: 3082.89 ------------------------------------------------------ [ 0, 1 ] 18010 9.218% 9.218% ## ( 1, 2 ] 113881 58.287% 67.505% ############ ( 2, 3 ] 27958 14.310% 81.815% ### ( 3, 4 ] 15841 8.108% 89.923% ## ( 4, 6 ] 13120 6.715% 96.638% # ( 6, 10 ] 4184 2.141% 98.779% ( 10, 15 ] 630 0.322% 99.102% ( 15, 22 ] 76 0.039% 99.141% ( 22, 34 ] 27 0.014% 99.154% ( 34, 51 ] 7 0.004% 99.158% ( 51, 76 ] 10 0.005% 99.163% ( 76, 110 ] 72 0.037% 99.200% ( 110, 170 ] 226 0.116% 99.316% ( 170, 250 ] 195 0.100% 99.415% ( 250, 380 ] 230 0.118% 99.533% ( 380, 580 ] 265 0.136% 99.669% ( 580, 870 ] 270 0.138% 99.807% ( 870, 1300 ] 213 0.109% 99.916% ( 1300, 1900 ] 90 0.046% 99.962% ( 1900, 2900 ] 48 0.025% 99.987% ( 2900, 4400 ] 53 0.027% 100.014% ( 4400, 6600 ] 16 0.008% 100.022% ( 6600, 9900 ] 2 0.001% 100.023% ** Level 5 read latency histogram (micros): Count: 240 Average: 1131.2792 StdDev: 1325.75 Min: 76 Median: 511.0345 Max: 8679 Percentiles: P50: 511.03 P75: 1700.00 P99: 6086.67 P99.9: 8679.00 P99.99: 8679.00 ------------------------------------------------------ ( 51, 76 ] 1 0.417% 0.417% ( 76, 110 ] 19 7.917% 8.333% ## ( 110, 170 ] 25 10.417% 18.750% ## ( 170, 250 ] 26 10.833% 29.583% ## ( 250, 380 ] 30 12.500% 42.083% ### ( 380, 580 ] 29 12.083% 54.167% ## ( 580, 870 ] 17 7.083% 61.250% # ( 870, 1300 ] 21 8.750% 70.000% ## ( 1300, 1900 ] 18 7.500% 77.500% ## ( 1900, 2900 ] 26 10.833% 88.333% ## ( 2900, 4400 ] 21 8.750% 97.083% ## ( 4400, 6600 ] 6 2.500% 99.583% # ( 6600, 9900 ] 1 0.417% 100.000% ** DB Stats ** Uptime(secs): 46.7 total, 3.1 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 210.75 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:18.997 H:M:S, 40.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.40 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.416 H:M:S, 13.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.618 micros/op 177988 ops/sec 60.049 seconds 10687999 operations; 172.5 MB/s Microseconds per write: Count: 10687999 Average: 5.6180 StdDev: 326.64 Min: 0 Median: 1.7503 Max: 578049 Percentiles: P50: 1.75 P75: 2.77 P99: 9.55 P99.9: 1125.41 P99.99: 2652.00 ------------------------------------------------------ [ 0, 1 ] 1376621 12.880% 12.880% ### ( 1, 2 ] 5287463 49.471% 62.351% ########## ( 2, 3 ] 1761349 16.480% 78.831% ### ( 3, 4 ] 1453774 13.602% 92.433% ### ( 4, 6 ] 581460 5.440% 97.873% # ( 6, 10 ] 135741 1.270% 99.143% ( 10, 15 ] 46415 0.434% 99.577% ( 15, 22 ] 10856 0.102% 99.679% ( 22, 34 ] 2254 0.021% 99.700% ( 34, 51 ] 262 0.002% 99.702% ( 51, 76 ] 45 0.000% 99.703% ( 76, 110 ] 7181 0.067% 99.770% ( 110, 170 ] 3149 0.029% 99.800% ( 170, 250 ] 327 0.003% 99.803% ( 250, 380 ] 208 0.002% 99.805% ( 380, 580 ] 25 0.000% 99.805% ( 580, 870 ] 20 0.000% 99.805% ( 870, 1300 ] 17107 0.160% 99.965% ( 1300, 1900 ] 66 0.001% 99.966% ( 1900, 2900 ] 3467 0.032% 99.998% ( 2900, 4400 ] 137 0.001% 99.999% ( 4400, 6600 ] 34 0.000% 100.000% ( 6600, 9900 ] 12 0.000% 100.000% ( 9900, 14000 ] 3 0.000% 100.000% ( 14000, 22000 ] 4 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 13 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 380000, 570000 ] 1 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 238505 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 : 10687999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 11030014968 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 : 603 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 30241260 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 : 36537027661 rocksdb.compact.write.bytes COUNT : 36286882016 rocksdb.flush.write.bytes COUNT : 10965634846 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 : 60 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 : 330 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 : 10877020160 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4048896 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 : 36374593863 rocksdb.non.last.level.read.count COUNT : 8788122 rocksdb.block.checksum.compute.count COUNT : 8850981 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.390285 P95 : 3.938846 P99 : 8.160958 P100 : 578046.000000 COUNT : 10687999 SUM : 54903646 rocksdb.compaction.times.micros P50 : 991750.000000 P95 : 5143333.333333 P99 : 17468505.000000 P100 : 17468505.000000 COUNT : 97 SUM : 158749045 rocksdb.compaction.times.cpu_micros P50 : 916666.666667 P95 : 5143333.333333 P99 : 16106620.000000 P100 : 16106620.000000 COUNT : 97 SUM : 135485779 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 : 719.141414 P95 : 1242.289474 P99 : 7408.500000 P100 : 9774.000000 COUNT : 151 SUM : 123664 rocksdb.compaction.outfile.sync.micros P50 : 1100.579710 P95 : 116333.333333 P99 : 169933.333333 P100 : 508654.000000 COUNT : 402 SUM : 9642849 rocksdb.wal.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.manifest.file.sync.micros P50 : 103.666667 P95 : 1006.166667 P99 : 2080.000000 P100 : 3301.000000 COUNT : 282 SUM : 66576 rocksdb.table.open.io.micros P50 : 1377.678571 P95 : 7442.368421 P99 : 12625.133333 P100 : 17055.000000 COUNT : 603 SUM : 1229687 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.623948 P95 : 7.902051 P99 : 11.514422 P100 : 12941.000000 COUNT : 8849493 SUM : 50852590 rocksdb.read.block.get.micros P50 : 456.422764 P95 : 3357.758621 P99 : 5370.444444 P100 : 7879.000000 COUNT : 1206 SUM : 1013851 rocksdb.write.raw.block.micros P50 : 0.512624 P95 : 0.973986 P99 : 2.894435 P100 : 20306.000000 COUNT : 11461154 SUM : 21949103 rocksdb.numfiles.in.singlecompaction P50 : 3.235294 P95 : 6.800000 P99 : 18.173333 P100 : 21.000000 COUNT : 164 SUM : 631 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.558460 P95 : 1140.790917 P99 : 2369.066125 P100 : 577840.000000 COUNT : 199866 SUM : 30262389 rocksdb.sst.read.micros P50 : 1.575712 P95 : 4.766801 P99 : 8.642116 P100 : 12937.000000 COUNT : 8788711 SUM : 32350330 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 : 10687999 SUM : 11030014968 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 : 210707.964602 P95 : 365607.142857 P99 : 550620.000000 P100 : 704180.000000 COUNT : 151 SUM : 31403779 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 : 396 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