[2024-07-11 05:23:16.180264] Starting SPDK v24.01.1-pre git sha1 4b94202c6 / DPDK 23.11.0 initialization... [2024-07-11 05:23:16.180419] [ 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_pid3230375 ] Set seed to 1720668196176748 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-11 05:23:16.326689] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-11 05:23:16.372440] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-11 05:23:16.372493] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 3230375' to capture a snapshot of events at runtime. [2024-07-11 05:23:16.372511] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid3230375 for offline analysis/debug. [2024-07-11 05:23:16.372550] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Thu Jul 11 05:23:20 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/07/11-05:23:24 ... thread 0: (1000000,1000000) ops and (265544.6,265544.6) ops/second in (3.765846,3.765846) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/8 630.01 MB 12.6 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 318.3 2.77 2.47 14 0.198 0 0 0.0 0.0 L1 3/3 188.86 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 188.2 188.1 1.00 0.97 1 1.004 191K 120 0.0 0.0 L2 1/0 49.02 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 181.5 181.4 0.61 0.59 1 0.614 113K 30 0.0 0.0 L3 18/0 944.35 MB 0.9 0.1 0.1 0.0 0.1 0.1 0.0 1.0 140.0 140.0 0.45 0.39 1 0.446 63K 0 0.0 0.0 L4 116/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1076/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 1224/11 97.00 GB 0.0 0.4 0.3 0.0 1.2 1.2 0.1 1.4 75.1 257.4 4.84 4.43 17 0.284 368K 150 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.0 1.2 1.2 0.1 1.4 75.1 257.4 4.84 4.43 17 0.284 368K 150 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.3 0.0 0.4 0.3 0.0 0.0 175.8 175.7 2.06 1.95 3 0.688 368K 150 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 318.3 2.77 2.47 14 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 4.0 total, 3.8 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, 309.28 MB/s write, 0.35 GB read, 90.17 MB/s read, 4.8 seconds Interval compaction: 1.22 GB write, 330.33 MB/s write, 0.35 GB read, 96.31 MB/s read, 4.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 0, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 0, ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 140872 Average: 2.6091 StdDev: 9.50 Min: 1 Median: 1.7908 Max: 2942 Percentiles: P50: 1.79 P75: 2.40 P99: 6.64 P99.9: 11.36 P99.99: 189.13 ------------------------------------------------------ [ 0, 1 ] 314 0.223% 0.223% ( 1, 2 ] 88677 62.949% 63.172% ############# ( 2, 3 ] 41772 29.652% 92.824% ###### ( 3, 4 ] 4130 2.932% 95.756% # ( 4, 6 ] 4340 3.081% 98.837% # ( 6, 10 ] 1464 1.039% 99.876% ( 10, 15 ] 137 0.097% 99.973% ( 15, 22 ] 8 0.006% 99.979% ( 22, 34 ] 7 0.005% 99.984% ( 34, 51 ] 2 0.001% 99.985% ( 51, 76 ] 2 0.001% 99.987% ( 110, 170 ] 6 0.004% 99.991% ( 170, 250 ] 8 0.006% 99.996% ( 250, 380 ] 8 0.006% 100.002% ( 380, 580 ] 4 0.003% 100.005% ( 1300, 1900 ] 1 0.001% 100.006% ( 2900, 4400 ] 1 0.001% 100.006% ** Level 1 read latency histogram (micros): Count: 30511 Average: 2.6180 StdDev: 5.40 Min: 1 Median: 1.8287 Max: 738 Percentiles: P50: 1.83 P75: 2.46 P99: 6.21 P99.9: 9.93 P99.99: 245.91 ------------------------------------------------------ [ 0, 1 ] 80 0.262% 0.262% ( 1, 2 ] 18313 60.021% 60.283% ############ ( 2, 3 ] 9716 31.844% 92.127% ###### ( 3, 4 ] 1016 3.330% 95.457% # ( 4, 6 ] 1065 3.491% 98.948% # ( 6, 10 ] 296 0.970% 99.918% ( 10, 15 ] 18 0.059% 99.977% ( 15, 22 ] 2 0.007% 99.984% ( 22, 34 ] 1 0.003% 99.987% ( 170, 250 ] 1 0.003% 99.990% ( 250, 380 ] 1 0.003% 99.993% ( 380, 580 ] 1 0.003% 99.997% ( 580, 870 ] 1 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 28176 Average: 3.5273 StdDev: 24.38 Min: 1 Median: 2.0769 Max: 2767 Percentiles: P50: 2.08 P75: 2.78 P99: 9.97 P99.9: 96.50 P99.99: 948.43 ------------------------------------------------------ [ 0, 1 ] 29 0.103% 0.103% ( 1, 2 ] 13293 47.178% 47.281% ######### ( 2, 3 ] 9956 35.335% 82.616% ####### ( 3, 4 ] 2136 7.581% 90.197% ## ( 4, 6 ] 1661 5.895% 96.092% # ( 6, 10 ] 826 2.932% 99.024% # ( 10, 15 ] 160 0.568% 99.592% ( 15, 22 ] 30 0.106% 99.698% ( 22, 34 ] 10 0.035% 99.734% ( 34, 51 ] 2 0.007% 99.741% ( 51, 76 ] 40 0.142% 99.883% ( 76, 110 ] 8 0.028% 99.911% ( 110, 170 ] 7 0.025% 99.936% ( 170, 250 ] 6 0.021% 99.957% ( 250, 380 ] 3 0.011% 99.968% ( 380, 580 ] 3 0.011% 99.979% ( 580, 870 ] 3 0.011% 99.989% ( 870, 1300 ] 1 0.004% 99.993% ( 1900, 2900 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 90 Average: 1057.9222 StdDev: 1347.95 Min: 2 Median: 580.0000 Max: 5622 Percentiles: P50: 580.00 P75: 1525.00 P99: 5610.00 P99.9: 5622.00 P99.99: 5622.00 ------------------------------------------------------ ( 1, 2 ] 8 8.889% 8.889% ## ( 2, 3 ] 16 17.778% 26.667% #### ( 3, 4 ] 6 6.667% 33.333% # ( 4, 6 ] 4 4.444% 37.778% # ( 6, 10 ] 1 1.111% 38.889% ( 15, 22 ] 1 1.111% 40.000% ( 170, 250 ] 2 2.222% 42.222% ( 250, 380 ] 3 3.333% 45.556% # ( 380, 580 ] 4 4.444% 50.000% # ( 580, 870 ] 8 8.889% 58.889% ## ( 870, 1300 ] 13 14.444% 73.333% ### ( 1300, 1900 ] 4 4.444% 77.778% # ( 1900, 2900 ] 8 8.889% 86.667% ## ( 2900, 4400 ] 10 11.111% 97.778% ## ( 4400, 6600 ] 2 2.222% 100.000% ** Level 4 read latency histogram (micros): Count: 25 Average: 2519.9600 StdDev: 2055.40 Min: 391 Median: 1750.0000 Max: 6859 Percentiles: P50: 1750.00 P75: 4025.00 P99: 6859.00 P99.9: 6859.00 P99.99: 6859.00 ------------------------------------------------------ ( 380, 580 ] 1 4.000% 4.000% # ( 580, 870 ] 2 8.000% 12.000% ## ( 870, 1300 ] 8 32.000% 44.000% ###### ( 1300, 1900 ] 2 8.000% 52.000% ## ( 1900, 2900 ] 5 20.000% 72.000% #### ( 2900, 4400 ] 1 4.000% 76.000% # ( 4400, 6600 ] 5 20.000% 96.000% #### ( 6600, 9900 ] 1 4.000% 100.000% # ** DB Stats ** Uptime(secs): 4.0 total, 3.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 244.51 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.000 H:M:S, 0.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 261.11 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/11-05:23:28 ... thread 0: (1000000,2000000) ops and (262514.8,264021.0) ops/second in (3.809309,7.575155) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/4 1.35 GB 113.3 1.0 0.0 1.0 2.8 1.8 0.0 1.5 82.6 237.4 12.20 11.35 34 0.359 1023K 986 0.0 0.0 L1 1/0 4.12 MB 0.4 0.6 0.4 0.2 0.6 0.4 0.1 1.4 180.5 180.3 3.49 3.40 2 1.744 639K 835 0.0 0.0 L2 5/3 484.99 MB 1.0 0.1 0.1 0.0 0.1 0.1 0.4 1.8 181.5 181.4 0.61 0.59 1 0.614 113K 30 0.0 0.0 L3 18/1 944.35 MB 0.9 0.1 0.1 0.0 0.1 0.1 0.0 1.0 140.0 140.0 0.45 0.39 1 0.446 63K 0 0.0 0.0 L4 116/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1076/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 1226/8 97.98 GB 0.0 1.8 0.6 1.2 3.6 2.4 0.5 2.0 108.1 220.8 16.75 15.72 38 0.441 1839K 1851 0.0 0.0 Int 0/0 0.00 KB 0.0 1.8 0.6 1.2 3.6 2.4 0.5 2.0 108.1 220.8 16.75 15.72 38 0.441 1839K 1851 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.8 0.6 1.2 1.8 0.6 0.0 0.0 173.5 173.3 10.44 10.12 8 1.306 1839K 1851 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 299.6 6.31 5.60 30 0.210 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): 7.8 total, 7.6 interval Flush(GB): cumulative 1.846, interval 1.846 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.61 GB write, 472.27 MB/s write, 1.77 GB read, 231.27 MB/s read, 16.8 seconds Interval compaction: 3.61 GB write, 488.26 MB/s write, 1.77 GB read, 239.10 MB/s read, 16.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 0, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 0, ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 419487 Average: 3.0455 StdDev: 12.86 Min: 1 Median: 1.9585 Max: 3989 Percentiles: P50: 1.96 P75: 2.93 P99: 9.18 P99.9: 13.89 P99.99: 16.41 ------------------------------------------------------ [ 0, 1 ] 18551 4.422% 4.422% # ( 1, 2 ] 199471 47.551% 51.973% ########## ( 2, 3 ] 104021 24.797% 76.771% ##### ( 3, 4 ] 44901 10.704% 87.474% ## ( 4, 6 ] 38030 9.066% 96.540% ## ( 6, 10 ] 12966 3.091% 99.631% # ( 10, 15 ] 1451 0.346% 99.977% ( 15, 22 ] 274 0.065% 100.042% ( 22, 34 ] 41 0.010% 100.052% ( 34, 51 ] 10 0.002% 100.055% ( 51, 76 ] 4 0.001% 100.056% ( 76, 110 ] 2 0.000% 100.056% ( 110, 170 ] 8 0.002% 100.058% ( 170, 250 ] 24 0.006% 100.064% ( 250, 380 ] 12 0.003% 100.067% ( 380, 580 ] 5 0.001% 100.068% ( 580, 870 ] 6 0.001% 100.069% ( 870, 1300 ] 5 0.001% 100.070% ( 1300, 1900 ] 4 0.001% 100.071% ( 1900, 2900 ] 2 0.000% 100.072% ( 2900, 4400 ] 3 0.001% 100.072% ** Level 1 read latency histogram (micros): Count: 126013 Average: 3.0445 StdDev: 7.25 Min: 1 Median: 2.2698 Max: 1703 Percentiles: P50: 2.27 P75: 2.81 P99: 8.70 P99.9: 13.66 P99.99: 45.89 ------------------------------------------------------ [ 0, 1 ] 110 0.087% 0.087% ( 1, 2 ] 47242 37.490% 37.577% ####### ( 2, 3 ] 58029 46.050% 83.627% ######### ( 3, 4 ] 9314 7.391% 91.018% # ( 4, 6 ] 8057 6.394% 97.412% # ( 6, 10 ] 2961 2.350% 99.762% ( 10, 15 ] 238 0.189% 99.951% ( 15, 22 ] 41 0.033% 99.983% ( 22, 34 ] 7 0.006% 99.989% ( 34, 51 ] 2 0.002% 99.990% ( 170, 250 ] 2 0.002% 99.992% ( 250, 380 ] 1 0.001% 99.993% ( 380, 580 ] 4 0.003% 99.996% ( 580, 870 ] 3 0.002% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 28176 Average: 3.5273 StdDev: 24.38 Min: 1 Median: 2.0769 Max: 2767 Percentiles: P50: 2.08 P75: 2.78 P99: 9.97 P99.9: 96.50 P99.99: 948.43 ------------------------------------------------------ [ 0, 1 ] 29 0.103% 0.103% ( 1, 2 ] 13293 47.178% 47.281% ######### ( 2, 3 ] 9956 35.335% 82.616% ####### ( 3, 4 ] 2136 7.581% 90.197% ## ( 4, 6 ] 1661 5.895% 96.092% # ( 6, 10 ] 826 2.932% 99.024% # ( 10, 15 ] 160 0.568% 99.592% ( 15, 22 ] 30 0.106% 99.698% ( 22, 34 ] 10 0.035% 99.734% ( 34, 51 ] 2 0.007% 99.741% ( 51, 76 ] 40 0.142% 99.883% ( 76, 110 ] 8 0.028% 99.911% ( 110, 170 ] 7 0.025% 99.936% ( 170, 250 ] 6 0.021% 99.957% ( 250, 380 ] 3 0.011% 99.968% ( 380, 580 ] 3 0.011% 99.979% ( 580, 870 ] 3 0.011% 99.989% ( 870, 1300 ] 1 0.004% 99.993% ( 1900, 2900 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 11270 Average: 11.5469 StdDev: 152.73 Min: 2 Median: 2.3863 Max: 5622 Percentiles: P50: 2.39 P75: 2.90 P99: 9.65 P99.9: 3009.50 P99.99: 5360.30 ------------------------------------------------------ ( 1, 2 ] 3512 31.162% 31.162% ###### ( 2, 3 ] 5496 48.767% 79.929% ########## ( 3, 4 ] 987 8.758% 88.687% ## ( 4, 6 ] 866 7.684% 96.371% ## ( 6, 10 ] 325 2.884% 99.255% # ( 10, 15 ] 27 0.240% 99.494% ( 15, 22 ] 3 0.027% 99.521% ( 170, 250 ] 2 0.018% 99.539% ( 250, 380 ] 3 0.027% 99.565% ( 380, 580 ] 4 0.035% 99.601% ( 580, 870 ] 8 0.071% 99.672% ( 870, 1300 ] 13 0.115% 99.787% ( 1300, 1900 ] 4 0.035% 99.823% ( 1900, 2900 ] 8 0.071% 99.894% ( 2900, 4400 ] 10 0.089% 99.982% ( 4400, 6600 ] 2 0.018% 100.000% ** Level 4 read latency histogram (micros): Count: 25 Average: 2519.9600 StdDev: 2055.40 Min: 391 Median: 1750.0000 Max: 6859 Percentiles: P50: 1750.00 P75: 4025.00 P99: 6859.00 P99.9: 6859.00 P99.99: 6859.00 ------------------------------------------------------ ( 380, 580 ] 1 4.000% 4.000% # ( 580, 870 ] 2 8.000% 12.000% ## ( 870, 1300 ] 8 32.000% 44.000% ###### ( 1300, 1900 ] 2 8.000% 52.000% ## ( 1900, 2900 ] 5 20.000% 72.000% #### ( 2900, 4400 ] 1 4.000% 76.000% # ( 4400, 6600 ] 5 20.000% 96.000% #### ( 6600, 9900 ] 1 4.000% 100.000% # ** DB Stats ** Uptime(secs): 7.8 total, 3.8 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 251.25 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.000 H:M:S, 0.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 258.37 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.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/11-05:23:32 ... thread 0: (1000000,3000000) ops and (264861.2,264300.5) ops/second in (3.775563,11.350718) 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/4 2.27 GB 207.7 2.0 0.0 2.0 4.7 2.8 0.0 1.7 95.2 228.9 21.18 19.88 53 0.400 2046K 1931 0.0 0.0 L1 1/0 4.12 MB 0.4 0.6 0.4 0.2 0.6 0.4 0.1 1.4 180.5 180.3 3.49 3.40 2 1.744 639K 835 0.0 0.0 L2 2/0 98.70 MB 1.0 0.1 0.1 0.0 0.1 0.1 0.4 1.8 181.5 181.4 0.61 0.59 1 0.614 113K 30 0.0 0.0 L3 30/0 979.22 MB 1.0 0.5 0.4 0.1 0.5 0.4 0.0 1.1 140.3 140.2 3.60 3.09 2 1.800 512K 239 0.0 0.0 L4 156/0 9.51 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1080/0 86.06 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1282/4 98.90 GB 0.0 3.2 0.9 2.3 6.0 3.7 1.1 2.1 112.9 211.0 28.88 26.95 58 0.498 3312K 3035 0.0 0.0 Int 0/0 0.00 KB 0.0 3.2 0.9 2.3 6.0 3.7 1.1 2.1 112.9 211.0 28.88 26.95 58 0.498 3312K 3035 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.2 0.9 2.3 3.2 0.9 0.0 0.0 168.9 168.8 19.31 18.43 13 1.485 3312K 3035 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 296.2 9.57 8.52 45 0.213 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): 11.6 total, 11.4 interval Flush(GB): cumulative 2.769, interval 2.769 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.95 GB write, 524.92 MB/s write, 3.19 GB read, 281.00 MB/s read, 28.9 seconds Interval compaction: 5.95 GB write, 536.78 MB/s write, 3.19 GB read, 287.35 MB/s read, 28.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: 0, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 0, ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 663475 Average: 3.1364 StdDev: 12.83 Min: 1 Median: 2.0633 Max: 3989 Percentiles: P50: 2.06 P75: 3.13 P99: 9.22 P99.9: 13.81 P99.99: 15.46 ------------------------------------------------------ [ 0, 1 ] 25549 3.851% 3.851% # ( 1, 2 ] 295771 44.579% 48.430% ######### ( 2, 3 ] 164520 24.797% 73.227% ##### ( 3, 4 ] 89010 13.416% 86.642% ### ( 4, 6 ] 64715 9.754% 96.396% ## ( 6, 10 ] 21432 3.230% 99.627% # ( 10, 15 ] 2385 0.359% 99.986% ( 15, 22 ] 418 0.063% 100.049% ( 22, 34 ] 54 0.008% 100.057% ( 34, 51 ] 15 0.002% 100.059% ( 51, 76 ] 8 0.001% 100.061% ( 76, 110 ] 3 0.000% 100.061% ( 110, 170 ] 8 0.001% 100.062% ( 170, 250 ] 39 0.006% 100.068% ( 250, 380 ] 18 0.003% 100.071% ( 380, 580 ] 8 0.001% 100.072% ( 580, 870 ] 12 0.002% 100.074% ( 870, 1300 ] 7 0.001% 100.075% ( 1300, 1900 ] 7 0.001% 100.076% ( 1900, 2900 ] 3 0.000% 100.076% ( 2900, 4400 ] 5 0.001% 100.077% ** Level 1 read latency histogram (micros): Count: 146057 Average: 3.0257 StdDev: 6.75 Min: 1 Median: 2.2716 Max: 1703 Percentiles: P50: 2.27 P75: 2.81 P99: 8.60 P99.9: 13.53 P99.99: 32.96 ------------------------------------------------------ [ 0, 1 ] 112 0.077% 0.077% ( 1, 2 ] 54347 37.209% 37.286% ####### ( 2, 3 ] 68371 46.811% 84.097% ######### ( 3, 4 ] 10629 7.277% 91.375% # ( 4, 6 ] 9038 6.188% 97.563% # ( 6, 10 ] 3229 2.211% 99.773% ( 10, 15 ] 262 0.179% 99.953% ( 15, 22 ] 48 0.033% 99.986% ( 22, 34 ] 7 0.005% 99.990% ( 34, 51 ] 2 0.001% 99.992% ( 170, 250 ] 2 0.001% 99.993% ( 250, 380 ] 1 0.001% 99.994% ( 380, 580 ] 4 0.003% 99.997% ( 580, 870 ] 3 0.002% 99.999% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 28176 Average: 3.5273 StdDev: 24.38 Min: 1 Median: 2.0769 Max: 2767 Percentiles: P50: 2.08 P75: 2.78 P99: 9.97 P99.9: 96.50 P99.99: 948.43 ------------------------------------------------------ [ 0, 1 ] 29 0.103% 0.103% ( 1, 2 ] 13293 47.178% 47.281% ######### ( 2, 3 ] 9956 35.335% 82.616% ####### ( 3, 4 ] 2136 7.581% 90.197% ## ( 4, 6 ] 1661 5.895% 96.092% # ( 6, 10 ] 826 2.932% 99.024% # ( 10, 15 ] 160 0.568% 99.592% ( 15, 22 ] 30 0.106% 99.698% ( 22, 34 ] 10 0.035% 99.734% ( 34, 51 ] 2 0.007% 99.741% ( 51, 76 ] 40 0.142% 99.883% ( 76, 110 ] 8 0.028% 99.911% ( 110, 170 ] 7 0.025% 99.936% ( 170, 250 ] 6 0.021% 99.957% ( 250, 380 ] 3 0.011% 99.968% ( 380, 580 ] 3 0.011% 99.979% ( 580, 870 ] 3 0.011% 99.989% ( 870, 1300 ] 1 0.004% 99.993% ( 1900, 2900 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 14637 Average: 9.8496 StdDev: 134.16 Min: 1 Median: 2.3591 Max: 5622 Percentiles: P50: 2.36 P75: 2.88 P99: 12.39 P99.9: 2570.38 P99.99: 4989.93 ------------------------------------------------------ [ 0, 1 ] 16 0.109% 0.109% ( 1, 2 ] 4775 32.623% 32.732% ####### ( 2, 3 ] 7038 48.084% 80.816% ########## ( 3, 4 ] 1213 8.287% 89.103% ## ( 4, 6 ] 1032 7.051% 96.154% # ( 6, 10 ] 397 2.712% 98.866% # ( 10, 15 ] 41 0.280% 99.146% ( 15, 22 ] 8 0.055% 99.201% ( 22, 34 ] 14 0.096% 99.296% ( 34, 51 ] 24 0.164% 99.460% ( 51, 76 ] 14 0.096% 99.556% ( 110, 170 ] 5 0.034% 99.590% ( 170, 250 ] 8 0.055% 99.645% ( 250, 380 ] 3 0.020% 99.665% ( 380, 580 ] 4 0.027% 99.693% ( 580, 870 ] 8 0.055% 99.747% ( 870, 1300 ] 13 0.089% 99.836% ( 1300, 1900 ] 4 0.027% 99.863% ( 1900, 2900 ] 8 0.055% 99.918% ( 2900, 4400 ] 10 0.068% 99.986% ( 4400, 6600 ] 2 0.014% 100.000% ** Level 4 read latency histogram (micros): Count: 25 Average: 2519.9600 StdDev: 2055.40 Min: 391 Median: 1750.0000 Max: 6859 Percentiles: P50: 1750.00 P75: 4025.00 P99: 6859.00 P99.9: 6859.00 P99.99: 6859.00 ------------------------------------------------------ ( 380, 580 ] 1 4.000% 4.000% # ( 580, 870 ] 2 8.000% 12.000% ## ( 870, 1300 ] 8 32.000% 44.000% ###### ( 1300, 1900 ] 2 8.000% 52.000% ## ( 1900, 2900 ] 5 20.000% 72.000% #### ( 2900, 4400 ] 1 4.000% 76.000% # ( 4400, 6600 ] 5 20.000% 96.000% #### ( 6600, 9900 ] 1 4.000% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 611.5000 StdDev: 744.16 Min: 96 Median: 170.0000 Max: 2383 Percentiles: P50: 170.00 P75: 580.00 P99: 2383.00 P99.9: 2383.00 P99.99: 2383.00 ------------------------------------------------------ ( 76, 110 ] 3 15.000% 15.000% ### ( 110, 170 ] 7 35.000% 50.000% ####### ( 170, 250 ] 2 10.000% 60.000% ## ( 380, 580 ] 3 15.000% 75.000% ### ( 870, 1300 ] 1 5.000% 80.000% # ( 1300, 1900 ] 1 5.000% 85.000% # ( 1900, 2900 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 11.6 total, 3.8 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 254.31 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.000 H:M:S, 0.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 260.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.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/11-05:23:36 ... thread 0: (1000000,4000000) ops and (209842.5,248197.5) ops/second in (4.765479,16.116197) 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/13 3.26 GB 63.0 3.0 0.0 3.0 6.7 3.7 0.0 1.8 103.0 233.8 29.36 27.58 73 0.402 3070K 2903 0.0 0.0 L1 1/1 4.12 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 180.5 180.3 3.49 3.40 2 1.744 639K 835 0.0 0.0 L2 2/0 98.70 MB 1.0 0.1 0.1 0.0 0.1 0.1 0.4 1.8 181.5 181.4 0.61 0.59 1 0.614 113K 30 0.0 0.0 L3 30/0 979.22 MB 1.0 0.5 0.4 0.1 0.5 0.4 0.0 1.1 140.3 140.2 3.60 3.09 2 1.800 512K 239 0.0 0.0 L4 156/0 9.51 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1080/0 86.06 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1286/14 99.89 GB 0.0 4.2 0.9 3.2 7.9 4.7 1.1 2.1 115.2 218.8 37.06 34.66 78 0.475 4335K 4007 0.0 0.0 Int 0/0 0.00 KB 0.0 4.2 0.9 3.2 7.9 4.7 1.1 2.1 115.2 218.8 37.06 34.66 78 0.475 4335K 4007 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.2 0.9 3.2 4.2 0.9 0.0 0.0 177.8 177.6 24.01 23.04 17 1.413 4335K 4007 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 294.5 13.05 11.62 61 0.214 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 16.4 total, 16.1 interval Flush(GB): cumulative 3.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.92 GB write, 495.21 MB/s write, 4.17 GB read, 260.78 MB/s read, 37.1 seconds Interval compaction: 7.92 GB write, 503.10 MB/s write, 4.17 GB read, 264.94 MB/s read, 37.1 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: 0, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 4, total-stops: 0, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1038974 Average: 2.9665 StdDev: 11.98 Min: 1 Median: 1.9751 Max: 3989 Percentiles: P50: 1.98 P75: 2.82 P99: 8.81 P99.9: 13.73 P99.99: 17.50 ------------------------------------------------------ [ 0, 1 ] 46939 4.518% 4.518% # ( 1, 2 ] 484593 46.641% 51.159% ######### ( 2, 3 ] 301879 29.055% 80.215% ###### ( 3, 4 ] 101336 9.753% 89.968% ## ( 4, 6 ] 77024 7.413% 97.382% # ( 6, 10 ] 23928 2.303% 99.685% ( 10, 15 ] 2998 0.289% 99.973% ( 15, 22 ] 484 0.047% 100.020% ( 22, 34 ] 64 0.006% 100.026% ( 34, 51 ] 18 0.002% 100.028% ( 51, 76 ] 14 0.001% 100.029% ( 76, 110 ] 61 0.006% 100.035% ( 110, 170 ] 41 0.004% 100.039% ( 170, 250 ] 63 0.006% 100.045% ( 250, 380 ] 32 0.003% 100.048% ( 380, 580 ] 17 0.002% 100.050% ( 580, 870 ] 21 0.002% 100.052% ( 870, 1300 ] 13 0.001% 100.053% ( 1300, 1900 ] 8 0.001% 100.054% ( 1900, 2900 ] 5 0.000% 100.054% ( 2900, 4400 ] 6 0.001% 100.055% ** Level 1 read latency histogram (micros): Count: 146058 Average: 3.0257 StdDev: 6.75 Min: 1 Median: 2.2716 Max: 1703 Percentiles: P50: 2.27 P75: 2.81 P99: 8.60 P99.9: 13.53 P99.99: 32.96 ------------------------------------------------------ [ 0, 1 ] 112 0.077% 0.077% ( 1, 2 ] 54347 37.209% 37.286% ####### ( 2, 3 ] 68372 46.812% 84.097% ######### ( 3, 4 ] 10629 7.277% 91.375% # ( 4, 6 ] 9038 6.188% 97.563% # ( 6, 10 ] 3229 2.211% 99.773% ( 10, 15 ] 262 0.179% 99.953% ( 15, 22 ] 48 0.033% 99.986% ( 22, 34 ] 7 0.005% 99.990% ( 34, 51 ] 2 0.001% 99.992% ( 170, 250 ] 2 0.001% 99.993% ( 250, 380 ] 1 0.001% 99.994% ( 380, 580 ] 4 0.003% 99.997% ( 580, 870 ] 3 0.002% 99.999% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 28176 Average: 3.5273 StdDev: 24.38 Min: 1 Median: 2.0769 Max: 2767 Percentiles: P50: 2.08 P75: 2.78 P99: 9.97 P99.9: 96.50 P99.99: 948.43 ------------------------------------------------------ [ 0, 1 ] 29 0.103% 0.103% ( 1, 2 ] 13293 47.178% 47.281% ######### ( 2, 3 ] 9956 35.335% 82.616% ####### ( 3, 4 ] 2136 7.581% 90.197% ## ( 4, 6 ] 1661 5.895% 96.092% # ( 6, 10 ] 826 2.932% 99.024% # ( 10, 15 ] 160 0.568% 99.592% ( 15, 22 ] 30 0.106% 99.698% ( 22, 34 ] 10 0.035% 99.734% ( 34, 51 ] 2 0.007% 99.741% ( 51, 76 ] 40 0.142% 99.883% ( 76, 110 ] 8 0.028% 99.911% ( 110, 170 ] 7 0.025% 99.936% ( 170, 250 ] 6 0.021% 99.957% ( 250, 380 ] 3 0.011% 99.968% ( 380, 580 ] 3 0.011% 99.979% ( 580, 870 ] 3 0.011% 99.989% ( 870, 1300 ] 1 0.004% 99.993% ( 1900, 2900 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 14637 Average: 9.8496 StdDev: 134.16 Min: 1 Median: 2.3591 Max: 5622 Percentiles: P50: 2.36 P75: 2.88 P99: 12.39 P99.9: 2570.38 P99.99: 4989.93 ------------------------------------------------------ [ 0, 1 ] 16 0.109% 0.109% ( 1, 2 ] 4775 32.623% 32.732% ####### ( 2, 3 ] 7038 48.084% 80.816% ########## ( 3, 4 ] 1213 8.287% 89.103% ## ( 4, 6 ] 1032 7.051% 96.154% # ( 6, 10 ] 397 2.712% 98.866% # ( 10, 15 ] 41 0.280% 99.146% ( 15, 22 ] 8 0.055% 99.201% ( 22, 34 ] 14 0.096% 99.296% ( 34, 51 ] 24 0.164% 99.460% ( 51, 76 ] 14 0.096% 99.556% ( 110, 170 ] 5 0.034% 99.590% ( 170, 250 ] 8 0.055% 99.645% ( 250, 380 ] 3 0.020% 99.665% ( 380, 580 ] 4 0.027% 99.693% ( 580, 870 ] 8 0.055% 99.747% ( 870, 1300 ] 13 0.089% 99.836% ( 1300, 1900 ] 4 0.027% 99.863% ( 1900, 2900 ] 8 0.055% 99.918% ( 2900, 4400 ] 10 0.068% 99.986% ( 4400, 6600 ] 2 0.014% 100.000% ** Level 4 read latency histogram (micros): Count: 25 Average: 2519.9600 StdDev: 2055.40 Min: 391 Median: 1750.0000 Max: 6859 Percentiles: P50: 1750.00 P75: 4025.00 P99: 6859.00 P99.9: 6859.00 P99.99: 6859.00 ------------------------------------------------------ ( 380, 580 ] 1 4.000% 4.000% # ( 580, 870 ] 2 8.000% 12.000% ## ( 870, 1300 ] 8 32.000% 44.000% ###### ( 1300, 1900 ] 2 8.000% 52.000% ## ( 1900, 2900 ] 5 20.000% 72.000% #### ( 2900, 4400 ] 1 4.000% 76.000% # ( 4400, 6600 ] 5 20.000% 96.000% #### ( 6600, 9900 ] 1 4.000% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 611.5000 StdDev: 744.16 Min: 96 Median: 170.0000 Max: 2383 Percentiles: P50: 170.00 P75: 580.00 P99: 2383.00 P99.9: 2383.00 P99.99: 2383.00 ------------------------------------------------------ ( 76, 110 ] 3 15.000% 15.000% ### ( 110, 170 ] 7 35.000% 50.000% ####### ( 170, 250 ] 2 10.000% 60.000% ## ( 380, 580 ] 3 15.000% 75.000% ### ( 870, 1300 ] 1 5.000% 80.000% # ( 1300, 1900 ] 1 5.000% 85.000% # ( 1900, 2900 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 16.4 total, 4.8 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 240.41 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.959 H:M:S, 5.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 206.52 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.959 H:M:S, 20.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/11-05:23:46 ... thread 0: (1000000,5000000) ops and (108249.8,197206.9) ops/second in (9.237889,25.354086) 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/17 4.24 GB 81.6 4.7 0.0 4.7 9.5 4.7 0.0 2.0 116.3 232.4 41.72 39.45 94 0.444 4924K 6337 0.0 0.0 L1 1/1 4.12 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 180.5 180.3 3.49 3.40 2 1.744 639K 835 0.0 0.0 L2 2/0 98.70 MB 1.0 0.1 0.1 0.0 0.1 0.1 0.4 1.8 181.5 181.4 0.61 0.59 1 0.614 113K 30 0.0 0.0 L3 30/0 979.22 MB 1.0 0.5 0.4 0.1 0.5 0.4 0.0 1.1 140.3 140.2 3.60 3.09 2 1.800 512K 239 0.0 0.0 L4 156/0 9.51 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1080/0 86.06 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1287/18 100.87 GB 0.0 6.0 0.9 5.0 10.7 5.7 1.1 2.3 123.3 221.3 49.43 46.53 99 0.499 6190K 7441 0.0 0.0 Int 0/0 0.00 KB 0.0 6.0 0.9 5.0 10.7 5.7 1.1 2.3 123.3 221.3 49.43 46.53 99 0.499 6190K 7441 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.0 0.9 5.0 5.9 0.9 0.0 0.0 184.7 184.5 33.00 31.91 22 1.500 6190K 7441 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 295.4 16.42 14.62 77 0.213 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): 25.6 total, 25.4 interval Flush(GB): cumulative 4.737, interval 4.737 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 10.68 GB write, 427.12 MB/s write, 5.95 GB read, 238.03 MB/s read, 49.4 seconds Interval compaction: 10.68 GB write, 431.45 MB/s write, 5.95 GB read, 240.44 MB/s read, 49.4 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: 0, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 14, total-stops: 0, interval: 14 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1917275 Average: 2.9710 StdDev: 11.56 Min: 1 Median: 1.9912 Max: 4033 Percentiles: P50: 1.99 P75: 2.78 P99: 8.75 P99.9: 13.40 P99.99: 14.84 ------------------------------------------------------ [ 0, 1 ] 86302 4.501% 4.501% # ( 1, 2 ] 880052 45.901% 50.402% ######### ( 2, 3 ] 604731 31.541% 81.944% ###### ( 3, 4 ] 158785 8.282% 90.225% ## ( 4, 6 ] 139238 7.262% 97.488% # ( 6, 10 ] 42172 2.200% 99.687% ( 10, 15 ] 5997 0.313% 100.000% ( 15, 22 ] 714 0.037% 100.037% ( 22, 34 ] 82 0.004% 100.042% ( 34, 51 ] 22 0.001% 100.043% ( 51, 76 ] 18 0.001% 100.044% ( 76, 110 ] 168 0.009% 100.052% ( 110, 170 ] 304 0.016% 100.068% ( 170, 250 ] 154 0.008% 100.076% ( 250, 380 ] 84 0.004% 100.081% ( 380, 580 ] 37 0.002% 100.083% ( 580, 870 ] 35 0.002% 100.084% ( 870, 1300 ] 24 0.001% 100.086% ( 1300, 1900 ] 11 0.001% 100.086% ( 1900, 2900 ] 7 0.000% 100.087% ( 2900, 4400 ] 10 0.001% 100.087% ** Level 1 read latency histogram (micros): Count: 146058 Average: 3.0257 StdDev: 6.75 Min: 1 Median: 2.2716 Max: 1703 Percentiles: P50: 2.27 P75: 2.81 P99: 8.60 P99.9: 13.53 P99.99: 32.96 ------------------------------------------------------ [ 0, 1 ] 112 0.077% 0.077% ( 1, 2 ] 54347 37.209% 37.286% ####### ( 2, 3 ] 68372 46.812% 84.097% ######### ( 3, 4 ] 10629 7.277% 91.375% # ( 4, 6 ] 9038 6.188% 97.563% # ( 6, 10 ] 3229 2.211% 99.773% ( 10, 15 ] 262 0.179% 99.953% ( 15, 22 ] 48 0.033% 99.986% ( 22, 34 ] 7 0.005% 99.990% ( 34, 51 ] 2 0.001% 99.992% ( 170, 250 ] 2 0.001% 99.993% ( 250, 380 ] 1 0.001% 99.994% ( 380, 580 ] 4 0.003% 99.997% ( 580, 870 ] 3 0.002% 99.999% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 28176 Average: 3.5273 StdDev: 24.38 Min: 1 Median: 2.0769 Max: 2767 Percentiles: P50: 2.08 P75: 2.78 P99: 9.97 P99.9: 96.50 P99.99: 948.43 ------------------------------------------------------ [ 0, 1 ] 29 0.103% 0.103% ( 1, 2 ] 13293 47.178% 47.281% ######### ( 2, 3 ] 9956 35.335% 82.616% ####### ( 3, 4 ] 2136 7.581% 90.197% ## ( 4, 6 ] 1661 5.895% 96.092% # ( 6, 10 ] 826 2.932% 99.024% # ( 10, 15 ] 160 0.568% 99.592% ( 15, 22 ] 30 0.106% 99.698% ( 22, 34 ] 10 0.035% 99.734% ( 34, 51 ] 2 0.007% 99.741% ( 51, 76 ] 40 0.142% 99.883% ( 76, 110 ] 8 0.028% 99.911% ( 110, 170 ] 7 0.025% 99.936% ( 170, 250 ] 6 0.021% 99.957% ( 250, 380 ] 3 0.011% 99.968% ( 380, 580 ] 3 0.011% 99.979% ( 580, 870 ] 3 0.011% 99.989% ( 870, 1300 ] 1 0.004% 99.993% ( 1900, 2900 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 14637 Average: 9.8496 StdDev: 134.16 Min: 1 Median: 2.3591 Max: 5622 Percentiles: P50: 2.36 P75: 2.88 P99: 12.39 P99.9: 2570.38 P99.99: 4989.93 ------------------------------------------------------ [ 0, 1 ] 16 0.109% 0.109% ( 1, 2 ] 4775 32.623% 32.732% ####### ( 2, 3 ] 7038 48.084% 80.816% ########## ( 3, 4 ] 1213 8.287% 89.103% ## ( 4, 6 ] 1032 7.051% 96.154% # ( 6, 10 ] 397 2.712% 98.866% # ( 10, 15 ] 41 0.280% 99.146% ( 15, 22 ] 8 0.055% 99.201% ( 22, 34 ] 14 0.096% 99.296% ( 34, 51 ] 24 0.164% 99.460% ( 51, 76 ] 14 0.096% 99.556% ( 110, 170 ] 5 0.034% 99.590% ( 170, 250 ] 8 0.055% 99.645% ( 250, 380 ] 3 0.020% 99.665% ( 380, 580 ] 4 0.027% 99.693% ( 580, 870 ] 8 0.055% 99.747% ( 870, 1300 ] 13 0.089% 99.836% ( 1300, 1900 ] 4 0.027% 99.863% ( 1900, 2900 ] 8 0.055% 99.918% ( 2900, 4400 ] 10 0.068% 99.986% ( 4400, 6600 ] 2 0.014% 100.000% ** Level 4 read latency histogram (micros): Count: 25 Average: 2519.9600 StdDev: 2055.40 Min: 391 Median: 1750.0000 Max: 6859 Percentiles: P50: 1750.00 P75: 4025.00 P99: 6859.00 P99.9: 6859.00 P99.99: 6859.00 ------------------------------------------------------ ( 380, 580 ] 1 4.000% 4.000% # ( 580, 870 ] 2 8.000% 12.000% ## ( 870, 1300 ] 8 32.000% 44.000% ###### ( 1300, 1900 ] 2 8.000% 52.000% ## ( 1900, 2900 ] 5 20.000% 72.000% #### ( 2900, 4400 ] 1 4.000% 76.000% # ( 4400, 6600 ] 5 20.000% 96.000% #### ( 6600, 9900 ] 1 4.000% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 611.5000 StdDev: 744.16 Min: 96 Median: 170.0000 Max: 2383 Percentiles: P50: 170.00 P75: 580.00 P99: 2383.00 P99.9: 2383.00 P99.99: 2383.00 ------------------------------------------------------ ( 76, 110 ] 3 15.000% 15.000% ### ( 110, 170 ] 7 35.000% 50.000% ####### ( 170, 250 ] 2 10.000% 60.000% ## ( 380, 580 ] 3 15.000% 75.000% ### ( 870, 1300 ] 1 5.000% 80.000% # ( 1300, 1900 ] 1 5.000% 85.000% # ( 1900, 2900 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 25.6 total, 9.2 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 192.12 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:6.208 H:M:S, 24.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 106.54 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:5.249 H:M:S, 56.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/11-05:23:54 ... thread 0: (1000000,6000000) ops and (126025.1,180239.6) ops/second in (7.934929,33.289015) 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/9 2.52 GB 44.1 5.8 0.0 5.8 11.5 5.7 0.0 2.0 114.9 226.1 52.06 48.13 109 0.478 6075K 9170 0.0 0.0 L1 6/6 615.40 MB 0.0 3.3 3.1 0.2 3.2 3.0 0.1 1.0 171.6 169.8 19.46 18.81 3 6.488 3391K 35K 0.0 0.0 L2 1/1 49.02 MB 0.0 0.1 0.1 0.0 0.1 0.1 2.4 1.8 181.5 181.4 0.61 0.59 1 0.614 113K 30 0.0 0.0 L3 26/10 1.80 GB 1.0 0.9 0.7 0.2 0.9 0.7 1.8 1.2 121.9 121.8 7.53 5.49 5 1.506 913K 340 0.0 0.0 L4 165/0 9.73 GB 1.0 1.4 1.1 0.3 1.4 1.1 0.4 1.2 102.7 102.3 14.21 9.03 10 1.421 1449K 4377 0.0 0.0 L5 1092/0 87.05 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1302/26 101.75 GB 0.0 11.5 5.0 6.5 17.1 10.6 6.0 3.0 125.8 187.0 93.88 82.05 128 0.733 11M 49K 0.0 0.0 Int 0/0 0.00 KB 0.0 11.5 5.0 6.5 17.1 10.6 6.0 3.0 125.8 187.0 93.88 82.05 128 0.733 11M 49K 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 11.5 5.0 6.5 11.5 5.0 0.0 0.0 161.7 161.0 73.03 64.41 38 1.922 11M 49K 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 278.0 20.85 17.64 90 0.232 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.5 total, 33.3 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: 17.15 GB write, 523.33 MB/s write, 11.54 GB read, 352.10 MB/s read, 93.9 seconds Interval compaction: 17.15 GB write, 527.37 MB/s write, 11.54 GB read, 354.81 MB/s read, 93.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, 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: 16, total-stops: 12, interval: 28 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2518279 Average: 3.2108 StdDev: 23.73 Min: 1 Median: 2.0514 Max: 12153 Percentiles: P50: 2.05 P75: 2.80 P99: 9.16 P99.9: 14.58 P99.99: 32.66 ------------------------------------------------------ [ 0, 1 ] 94494 3.752% 3.752% # ( 1, 2 ] 1121391 44.530% 48.282% ######### ( 2, 3 ] 842042 33.437% 81.720% ####### ( 3, 4 ] 193362 7.678% 89.398% ## ( 4, 6 ] 191326 7.597% 96.995% ## ( 6, 10 ] 63810 2.534% 99.529% # ( 10, 15 ] 10195 0.405% 99.934% ( 15, 22 ] 1282 0.051% 99.985% ( 22, 34 ] 142 0.006% 99.991% ( 34, 51 ] 32 0.001% 99.992% ( 51, 76 ] 20 0.001% 99.993% ( 76, 110 ] 337 0.013% 100.006% ( 110, 170 ] 843 0.033% 100.040% ( 170, 250 ] 300 0.012% 100.052% ( 250, 380 ] 186 0.007% 100.059% ( 380, 580 ] 128 0.005% 100.064% ( 580, 870 ] 111 0.004% 100.068% ( 870, 1300 ] 73 0.003% 100.071% ( 1300, 1900 ] 31 0.001% 100.073% ( 1900, 2900 ] 22 0.001% 100.073% ( 2900, 4400 ] 36 0.001% 100.075% ( 4400, 6600 ] 6 0.000% 100.075% ( 6600, 9900 ] 3 0.000% 100.075% ( 9900, 14000 ] 1 0.000% 100.075% ** Level 1 read latency histogram (micros): Count: 484730 Average: 6.2044 StdDev: 103.86 Min: 1 Median: 2.6273 Max: 20981 Percentiles: P50: 2.63 P75: 3.85 P99: 11.56 P99.9: 18.78 P99.99: 21.56 ------------------------------------------------------ [ 0, 1 ] 926 0.191% 0.191% ( 1, 2 ] 109949 22.683% 22.874% ##### ( 2, 3 ] 209626 43.246% 66.119% ######### ( 3, 4 ] 50611 10.441% 76.561% ## ( 4, 6 ] 71669 14.785% 91.346% ### ( 6, 10 ] 35394 7.302% 98.648% # ( 10, 15 ] 5478 1.130% 99.778% ( 15, 22 ] 1098 0.227% 100.004% ( 22, 34 ] 165 0.034% 100.038% ( 34, 51 ] 17 0.004% 100.042% ( 51, 76 ] 7 0.001% 100.043% ( 76, 110 ] 15 0.003% 100.046% ( 110, 170 ] 122 0.025% 100.072% ( 170, 250 ] 92 0.019% 100.091% ( 250, 380 ] 75 0.015% 100.106% ( 380, 580 ] 82 0.017% 100.123% ( 580, 870 ] 87 0.018% 100.141% ( 870, 1300 ] 57 0.012% 100.153% ( 1300, 1900 ] 39 0.008% 100.161% ( 1900, 2900 ] 60 0.012% 100.173% ( 2900, 4400 ] 90 0.019% 100.192% ( 4400, 6600 ] 42 0.009% 100.200% ( 6600, 9900 ] 22 0.005% 100.205% ( 9900, 14000 ] 4 0.001% 100.206% ( 14000, 22000 ] 1 0.000% 100.206% ** Level 2 read latency histogram (micros): Count: 28260 Average: 5.9563 StdDev: 90.01 Min: 1 Median: 2.0812 Max: 7867 Percentiles: P50: 2.08 P75: 2.79 P99: 11.79 P99.9: 774.97 P99.99: 5260.93 ------------------------------------------------------ [ 0, 1 ] 29 0.103% 0.103% ( 1, 2 ] 13293 47.038% 47.141% ######### ( 2, 3 ] 9956 35.230% 82.371% ####### ( 3, 4 ] 2136 7.558% 89.929% ## ( 4, 6 ] 1676 5.931% 95.860% # ( 6, 10 ] 830 2.937% 98.797% # ( 10, 15 ] 160 0.566% 99.363% ( 15, 22 ] 31 0.110% 99.473% ( 22, 34 ] 10 0.035% 99.508% ( 34, 51 ] 2 0.007% 99.515% ( 51, 76 ] 40 0.142% 99.657% ( 76, 110 ] 8 0.028% 99.685% ( 110, 170 ] 9 0.032% 99.717% ( 170, 250 ] 16 0.057% 99.774% ( 250, 380 ] 17 0.060% 99.834% ( 380, 580 ] 10 0.035% 99.869% ( 580, 870 ] 13 0.046% 99.915% ( 870, 1300 ] 10 0.035% 99.950% ( 1300, 1900 ] 3 0.011% 99.961% ( 1900, 2900 ] 5 0.018% 99.979% ( 2900, 4400 ] 2 0.007% 99.986% ( 4400, 6600 ] 3 0.011% 99.996% ( 6600, 9900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 274590 Average: 17.0781 StdDev: 185.16 Min: 1 Median: 2.8272 Max: 10843 Percentiles: P50: 2.83 P75: 4.56 P99: 192.40 P99.9: 1766.57 P99.99: 3157.78 ------------------------------------------------------ [ 0, 1 ] 1515 0.552% 0.552% ( 1, 2 ] 59782 21.771% 22.323% #### ( 2, 3 ] 91876 33.459% 55.782% ####### ( 3, 4 ] 38102 13.876% 69.658% ### ( 4, 6 ] 52380 19.076% 88.734% #### ( 6, 10 ] 22431 8.169% 96.903% ## ( 10, 15 ] 3926 1.430% 98.333% ( 15, 22 ] 1227 0.447% 98.780% ( 22, 34 ] 139 0.051% 98.830% ( 34, 51 ] 34 0.012% 98.843% ( 51, 76 ] 19 0.007% 98.850% ( 76, 110 ] 34 0.012% 98.862% ( 110, 170 ] 251 0.091% 98.953% ( 170, 250 ] 461 0.168% 99.121% ( 250, 380 ] 461 0.168% 99.289% ( 380, 580 ] 582 0.212% 99.501% ( 580, 870 ] 533 0.194% 99.695% ( 870, 1300 ] 397 0.145% 99.840% ( 1300, 1900 ] 214 0.078% 99.918% ( 1900, 2900 ] 154 0.056% 99.974% ( 2900, 4400 ] 265 0.097% 100.070% ( 4400, 6600 ] 88 0.032% 100.102% ( 6600, 9900 ] 20 0.007% 100.110% ( 9900, 14000 ] 2 0.001% 100.110% ** Level 4 read latency histogram (micros): Count: 8764 Average: 14.5881 StdDev: 187.76 Min: 1 Median: 2.6119 Max: 6859 Percentiles: P50: 2.61 P75: 3.42 P99: 31.54 P99.9: 2790.86 P99.99: 6859.00 ------------------------------------------------------ [ 0, 1 ] 14 0.160% 0.160% ( 1, 2 ] 1525 17.401% 17.560% ### ( 2, 3 ] 4646 53.012% 70.573% ########### ( 3, 4 ] 916 10.452% 81.025% ## ( 4, 6 ] 1084 12.369% 93.393% ## ( 6, 10 ] 448 5.112% 98.505% # ( 10, 15 ] 27 0.308% 98.813% ( 15, 22 ] 10 0.114% 98.927% ( 22, 34 ] 8 0.091% 99.019% ( 34, 51 ] 1 0.011% 99.030% ( 76, 110 ] 3 0.034% 99.064% ( 110, 170 ] 9 0.103% 99.167% ( 170, 250 ] 18 0.205% 99.372% ( 250, 380 ] 8 0.091% 99.464% ( 380, 580 ] 6 0.068% 99.532% ( 580, 870 ] 7 0.080% 99.612% ( 870, 1300 ] 14 0.160% 99.772% ( 1300, 1900 ] 5 0.057% 99.829% ( 1900, 2900 ] 7 0.080% 99.909% ( 2900, 4400 ] 2 0.023% 99.932% ( 4400, 6600 ] 5 0.057% 99.989% ( 6600, 9900 ] 1 0.011% 100.000% ** Level 5 read latency histogram (micros): Count: 80 Average: 1035.0625 StdDev: 1196.57 Min: 96 Median: 480.0000 Max: 6056 Percentiles: P50: 480.00 P75: 1500.00 P99: 5720.00 P99.9: 6056.00 P99.99: 6056.00 ------------------------------------------------------ ( 76, 110 ] 3 3.750% 3.750% # ( 110, 170 ] 12 15.000% 18.750% ### ( 170, 250 ] 6 7.500% 26.250% ## ( 250, 380 ] 14 17.500% 43.750% #### ( 380, 580 ] 10 12.500% 56.250% ### ( 580, 870 ] 7 8.750% 65.000% ## ( 870, 1300 ] 7 8.750% 73.750% ## ( 1300, 1900 ] 3 3.750% 77.500% # ( 1900, 2900 ] 12 15.000% 92.500% ### ( 2900, 4400 ] 4 5.000% 97.500% # ( 4400, 6600 ] 2 2.500% 100.000% # ** DB Stats ** Uptime(secs): 33.5 total, 7.9 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 176.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:9.697 H:M:S, 28.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 124.03 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:3.489 H:M:S, 44.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/11-05:23:57 ... thread 0: (1000000,7000000) ops and (258782.7,188408.8) ops/second in (3.864246,37.153261) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/9 3.50 GB 151.0 6.9 0.0 6.9 13.5 6.6 0.0 2.0 114.9 225.5 61.40 56.87 129 0.476 7162K 10K 0.0 0.0 L1 6/6 615.40 MB 0.0 3.3 3.1 0.2 3.2 3.0 0.1 1.0 171.6 169.8 19.46 18.81 3 6.488 3391K 35K 0.0 0.0 L2 1/1 49.02 MB 0.0 0.1 0.1 0.0 0.1 0.1 2.4 1.8 181.5 181.4 0.61 0.59 1 0.614 113K 30 0.0 0.0 L3 26/10 1.80 GB 1.0 0.9 0.7 0.2 0.9 0.7 1.8 1.2 121.9 121.8 7.53 5.49 5 1.506 913K 340 0.0 0.0 L4 165/0 9.73 GB 1.0 1.4 1.1 0.3 1.4 1.1 0.4 1.2 102.7 102.3 14.21 9.03 10 1.421 1449K 4377 0.0 0.0 L5 1092/0 87.05 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1306/26 102.73 GB 0.0 12.6 5.0 7.6 19.2 11.6 6.0 2.9 124.8 190.2 103.21 90.79 148 0.697 13M 50K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.6 5.0 7.6 19.2 11.6 6.0 2.9 124.8 190.2 103.21 90.79 148 0.697 13M 50K 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.6 5.0 7.6 12.5 5.0 0.0 0.0 163.6 162.9 78.77 69.99 42 1.876 13M 50K 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 278.4 24.44 20.80 106 0.231 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 37.4 total, 37.2 interval Flush(GB): cumulative 6.645, interval 6.645 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 19.17 GB write, 524.82 MB/s write, 12.58 GB read, 344.36 MB/s read, 103.2 seconds Interval compaction: 19.17 GB write, 528.44 MB/s write, 12.58 GB read, 346.74 MB/s read, 103.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, 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: 16, total-stops: 12, interval: 28 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2987420 Average: 3.2044 StdDev: 22.09 Min: 1 Median: 2.0741 Max: 12153 Percentiles: P50: 2.07 P75: 2.81 P99: 9.17 P99.9: 14.27 P99.99: 19.95 ------------------------------------------------------ [ 0, 1 ] 109612 3.669% 3.669% # ( 1, 2 ] 1309130 43.821% 47.491% ######### ( 2, 3 ] 1011287 33.852% 81.342% ####### ( 3, 4 ] 227067 7.601% 88.943% ## ( 4, 6 ] 235392 7.879% 96.822% ## ( 6, 10 ] 82119 2.749% 99.571% # ( 10, 15 ] 11502 0.385% 99.956% ( 15, 22 ] 1435 0.048% 100.004% ( 22, 34 ] 147 0.005% 100.009% ( 34, 51 ] 36 0.001% 100.010% ( 51, 76 ] 22 0.001% 100.011% ( 76, 110 ] 350 0.012% 100.023% ( 110, 170 ] 876 0.029% 100.052% ( 170, 250 ] 350 0.012% 100.064% ( 250, 380 ] 213 0.007% 100.071% ( 380, 580 ] 144 0.005% 100.076% ( 580, 870 ] 125 0.004% 100.080% ( 870, 1300 ] 81 0.003% 100.083% ( 1300, 1900 ] 33 0.001% 100.084% ( 1900, 2900 ] 24 0.001% 100.085% ( 2900, 4400 ] 36 0.001% 100.086% ( 4400, 6600 ] 6 0.000% 100.086% ( 6600, 9900 ] 3 0.000% 100.086% ( 9900, 14000 ] 1 0.000% 100.086% ** Level 1 read latency histogram (micros): Count: 491750 Average: 6.1897 StdDev: 103.15 Min: 1 Median: 2.6263 Max: 20981 Percentiles: P50: 2.63 P75: 3.84 P99: 11.64 P99.9: 19.17 P99.99: 21.97 ------------------------------------------------------ [ 0, 1 ] 926 0.188% 0.188% ( 1, 2 ] 111328 22.639% 22.827% ##### ( 2, 3 ] 213347 43.385% 66.213% ######### ( 3, 4 ] 51279 10.428% 76.641% ## ( 4, 6 ] 72364 14.716% 91.356% ### ( 6, 10 ] 35751 7.270% 98.626% # ( 10, 15 ] 5606 1.140% 99.766% ( 15, 22 ] 1104 0.225% 99.991% ( 22, 34 ] 168 0.034% 100.025% ( 34, 51 ] 17 0.003% 100.028% ( 51, 76 ] 7 0.001% 100.030% ( 76, 110 ] 44 0.009% 100.039% ( 110, 170 ] 140 0.028% 100.067% ( 170, 250 ] 96 0.020% 100.087% ( 250, 380 ] 81 0.016% 100.103% ( 380, 580 ] 85 0.017% 100.121% ( 580, 870 ] 90 0.018% 100.139% ( 870, 1300 ] 57 0.012% 100.150% ( 1300, 1900 ] 39 0.008% 100.158% ( 1900, 2900 ] 60 0.012% 100.171% ( 2900, 4400 ] 90 0.018% 100.189% ( 4400, 6600 ] 42 0.009% 100.197% ( 6600, 9900 ] 22 0.004% 100.202% ( 9900, 14000 ] 4 0.001% 100.203% ( 14000, 22000 ] 1 0.000% 100.203% ** Level 2 read latency histogram (micros): Count: 40435 Average: 6.1302 StdDev: 76.51 Min: 1 Median: 2.6924 Max: 7867 Percentiles: P50: 2.69 P75: 4.36 P99: 15.90 P99.9: 590.22 P99.99: 4367.30 ------------------------------------------------------ [ 0, 1 ] 29 0.072% 0.072% ( 1, 2 ] 13293 32.875% 32.947% ####### ( 2, 3 ] 9960 24.632% 57.579% ##### ( 3, 4 ] 5702 14.102% 71.680% ### ( 4, 6 ] 7416 18.341% 90.021% #### ( 6, 10 ] 3167 7.832% 97.853% ## ( 10, 15 ] 434 1.073% 98.927% ( 15, 22 ] 239 0.591% 99.518% ( 22, 34 ] 35 0.087% 99.604% ( 34, 51 ] 2 0.005% 99.609% ( 51, 76 ] 40 0.099% 99.708% ( 76, 110 ] 8 0.020% 99.728% ( 110, 170 ] 14 0.035% 99.763% ( 170, 250 ] 24 0.059% 99.822% ( 250, 380 ] 18 0.045% 99.866% ( 380, 580 ] 14 0.035% 99.901% ( 580, 870 ] 16 0.040% 99.941% ( 870, 1300 ] 10 0.025% 99.965% ( 1300, 1900 ] 3 0.007% 99.973% ( 1900, 2900 ] 6 0.015% 99.988% ( 2900, 4400 ] 2 0.005% 99.993% ( 4400, 6600 ] 3 0.007% 100.000% ( 6600, 9900 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 365336 Average: 14.4337 StdDev: 160.78 Min: 1 Median: 3.4485 Max: 10843 Percentiles: P50: 3.45 P75: 5.18 P99: 25.75 P99.9: 1512.14 P99.99: 3106.41 ------------------------------------------------------ [ 0, 1 ] 1515 0.415% 0.415% ( 1, 2 ] 59782 16.364% 16.778% ### ( 2, 3 ] 91931 25.163% 41.942% ##### ( 3, 4 ] 65644 17.968% 59.910% #### ( 4, 6 ] 93622 25.626% 85.536% ##### ( 6, 10 ] 40139 10.987% 96.523% ## ( 10, 15 ] 6214 1.701% 98.224% ( 15, 22 ] 2729 0.747% 98.971% ( 22, 34 ] 341 0.093% 99.064% ( 34, 51 ] 46 0.013% 99.077% ( 51, 76 ] 19 0.005% 99.082% ( 76, 110 ] 52 0.014% 99.096% ( 110, 170 ] 306 0.084% 99.180% ( 170, 250 ] 516 0.141% 99.321% ( 250, 380 ] 486 0.133% 99.454% ( 380, 580 ] 605 0.166% 99.620% ( 580, 870 ] 546 0.149% 99.769% ( 870, 1300 ] 402 0.110% 99.879% ( 1300, 1900 ] 214 0.059% 99.938% ( 1900, 2900 ] 154 0.042% 99.980% ( 2900, 4400 ] 265 0.073% 100.053% ( 4400, 6600 ] 88 0.024% 100.077% ( 6600, 9900 ] 20 0.005% 100.082% ( 9900, 14000 ] 2 0.001% 100.083% ** Level 4 read latency histogram (micros): Count: 8764 Average: 14.5881 StdDev: 187.76 Min: 1 Median: 2.6119 Max: 6859 Percentiles: P50: 2.61 P75: 3.42 P99: 31.54 P99.9: 2790.86 P99.99: 6859.00 ------------------------------------------------------ [ 0, 1 ] 14 0.160% 0.160% ( 1, 2 ] 1525 17.401% 17.560% ### ( 2, 3 ] 4646 53.012% 70.573% ########### ( 3, 4 ] 916 10.452% 81.025% ## ( 4, 6 ] 1084 12.369% 93.393% ## ( 6, 10 ] 448 5.112% 98.505% # ( 10, 15 ] 27 0.308% 98.813% ( 15, 22 ] 10 0.114% 98.927% ( 22, 34 ] 8 0.091% 99.019% ( 34, 51 ] 1 0.011% 99.030% ( 76, 110 ] 3 0.034% 99.064% ( 110, 170 ] 9 0.103% 99.167% ( 170, 250 ] 18 0.205% 99.372% ( 250, 380 ] 8 0.091% 99.464% ( 380, 580 ] 6 0.068% 99.532% ( 580, 870 ] 7 0.080% 99.612% ( 870, 1300 ] 14 0.160% 99.772% ( 1300, 1900 ] 5 0.057% 99.829% ( 1900, 2900 ] 7 0.080% 99.909% ( 2900, 4400 ] 2 0.023% 99.932% ( 4400, 6600 ] 5 0.057% 99.989% ( 6600, 9900 ] 1 0.011% 100.000% ** Level 5 read latency histogram (micros): Count: 80 Average: 1035.0625 StdDev: 1196.57 Min: 96 Median: 480.0000 Max: 6056 Percentiles: P50: 480.00 P75: 1500.00 P99: 5720.00 P99.9: 6056.00 P99.99: 6056.00 ------------------------------------------------------ ( 76, 110 ] 3 3.750% 3.750% # ( 110, 170 ] 12 15.000% 18.750% ### ( 170, 250 ] 6 7.500% 26.250% ## ( 250, 380 ] 14 17.500% 43.750% #### ( 380, 580 ] 10 12.500% 56.250% ### ( 580, 870 ] 7 8.750% 65.000% ## ( 870, 1300 ] 7 8.750% 73.750% ## ( 1300, 1900 ] 3 3.750% 77.500% # ( 1900, 2900 ] 12 15.000% 92.500% ### ( 2900, 4400 ] 4 5.000% 97.500% # ( 4400, 6600 ] 2 2.500% 100.000% # ** DB Stats ** Uptime(secs): 37.4 total, 3.9 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 184.15 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:9.697 H:M:S, 25.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 254.69 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/11-05:24:03 ... thread 0: (1000000,8000000) ops and (197573.6,189507.6) ops/second in (5.061404,42.214665) 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/12 4.48 GB 119.6 8.1 0.0 8.1 15.7 7.6 0.0 2.1 115.9 224.5 71.76 66.70 150 0.478 8442K 11K 0.0 0.0 L1 6/6 615.40 MB 0.0 3.3 3.1 0.2 3.2 3.0 0.1 1.0 171.6 169.8 19.46 18.81 3 6.488 3391K 35K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 2.4 1.8 181.5 181.4 0.61 0.59 1 0.614 113K 30 0.0 0.0 L3 16/0 964.65 MB 1.0 1.8 0.8 1.0 1.8 0.8 1.8 2.3 116.7 116.6 15.85 12.43 6 2.642 1858K 883 0.0 0.0 L4 168/0 9.66 GB 1.0 1.4 1.1 0.3 1.4 1.1 1.3 1.2 102.7 102.3 14.21 9.03 10 1.421 1449K 4377 0.0 0.0 L5 1104/0 88.03 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1311/18 103.71 GB 0.0 14.7 5.1 9.7 22.3 12.6 7.9 2.9 123.7 187.3 121.90 107.56 170 0.717 15M 52K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.7 5.1 9.7 22.3 12.6 7.9 2.9 123.7 187.3 121.90 107.56 170 0.717 15M 52K 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.7 5.1 9.7 14.7 5.0 0.0 0.0 160.5 159.9 93.91 83.61 48 1.956 15M 52K 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 279.1 27.99 23.95 122 0.229 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): 42.5 total, 42.2 interval Flush(GB): cumulative 7.629, interval 7.629 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.30 GB write, 537.55 MB/s write, 14.72 GB read, 354.91 MB/s read, 121.9 seconds Interval compaction: 22.30 GB write, 540.82 MB/s write, 14.72 GB read, 357.06 MB/s read, 121.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 20, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 20, 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: 20, total-stops: 12, interval: 32 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3372518 Average: 3.2114 StdDev: 21.19 Min: 1 Median: 2.0828 Max: 12153 Percentiles: P50: 2.08 P75: 2.84 P99: 9.20 P99.9: 14.22 P99.99: 18.96 ------------------------------------------------------ [ 0, 1 ] 130473 3.869% 3.869% # ( 1, 2 ] 1463133 43.384% 47.253% ######### ( 2, 3 ] 1119585 33.197% 80.450% ####### ( 3, 4 ] 269130 7.980% 88.430% ## ( 4, 6 ] 280396 8.314% 96.744% ## ( 6, 10 ] 95009 2.817% 99.561% # ( 10, 15 ] 13524 0.401% 99.962% ( 15, 22 ] 1649 0.049% 100.011% ( 22, 34 ] 156 0.005% 100.016% ( 34, 51 ] 39 0.001% 100.017% ( 51, 76 ] 24 0.001% 100.018% ( 76, 110 ] 389 0.012% 100.029% ( 110, 170 ] 951 0.028% 100.058% ( 170, 250 ] 402 0.012% 100.069% ( 250, 380 ] 236 0.007% 100.076% ( 380, 580 ] 164 0.005% 100.081% ( 580, 870 ] 142 0.004% 100.086% ( 870, 1300 ] 87 0.003% 100.088% ( 1300, 1900 ] 36 0.001% 100.089% ( 1900, 2900 ] 24 0.001% 100.090% ( 2900, 4400 ] 38 0.001% 100.091% ( 4400, 6600 ] 6 0.000% 100.091% ( 6600, 9900 ] 3 0.000% 100.091% ( 9900, 14000 ] 1 0.000% 100.091% ** Level 1 read latency histogram (micros): Count: 621113 Average: 5.6129 StdDev: 91.90 Min: 1 Median: 2.5513 Max: 20981 Percentiles: P50: 2.55 P75: 3.52 P99: 11.60 P99.9: 20.10 P99.99: 91.96 ------------------------------------------------------ [ 0, 1 ] 948 0.153% 0.153% ( 1, 2 ] 156510 25.198% 25.351% ##### ( 2, 3 ] 277716 44.713% 70.064% ######### ( 3, 4 ] 58955 9.492% 79.555% ## ( 4, 6 ] 79644 12.823% 92.378% ### ( 6, 10 ] 38886 6.261% 98.639% # ( 10, 15 ] 6990 1.125% 99.764% ( 15, 22 ] 1156 0.186% 99.950% ( 22, 34 ] 171 0.028% 99.978% ( 34, 51 ] 19 0.003% 99.981% ( 51, 76 ] 8 0.001% 99.982% ( 76, 110 ] 102 0.016% 99.999% ( 110, 170 ] 261 0.042% 100.041% ( 170, 250 ] 138 0.022% 100.063% ( 250, 380 ] 98 0.016% 100.079% ( 380, 580 ] 98 0.016% 100.095% ( 580, 870 ] 95 0.015% 100.110% ( 870, 1300 ] 58 0.009% 100.119% ( 1300, 1900 ] 39 0.006% 100.125% ( 1900, 2900 ] 60 0.010% 100.135% ( 2900, 4400 ] 90 0.014% 100.150% ( 4400, 6600 ] 42 0.007% 100.156% ( 6600, 9900 ] 22 0.004% 100.160% ( 9900, 14000 ] 4 0.001% 100.161% ( 14000, 22000 ] 1 0.000% 100.161% ** Level 2 read latency histogram (micros): Count: 40624 Average: 6.1268 StdDev: 76.33 Min: 1 Median: 2.7018 Max: 7867 Percentiles: P50: 2.70 P75: 4.38 P99: 15.94 P99.9: 586.82 P99.99: 4353.20 ------------------------------------------------------ [ 0, 1 ] 29 0.071% 0.071% ( 1, 2 ] 13293 32.722% 32.793% ####### ( 2, 3 ] 9960 24.518% 57.311% ##### ( 3, 4 ] 5766 14.194% 71.505% ### ( 4, 6 ] 7513 18.494% 89.999% #### ( 6, 10 ] 3189 7.850% 97.849% ## ( 10, 15 ] 435 1.071% 98.919% ( 15, 22 ] 243 0.598% 99.518% ( 22, 34 ] 35 0.086% 99.604% ( 34, 51 ] 2 0.005% 99.609% ( 51, 76 ] 40 0.098% 99.707% ( 76, 110 ] 8 0.020% 99.727% ( 110, 170 ] 14 0.034% 99.761% ( 170, 250 ] 24 0.059% 99.820% ( 250, 380 ] 18 0.044% 99.865% ( 380, 580 ] 14 0.034% 99.899% ( 580, 870 ] 16 0.039% 99.938% ( 870, 1300 ] 10 0.025% 99.963% ( 1300, 1900 ] 3 0.007% 99.970% ( 1900, 2900 ] 6 0.015% 99.985% ( 2900, 4400 ] 2 0.005% 99.990% ( 4400, 6600 ] 3 0.007% 99.998% ( 6600, 9900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 365411 Average: 14.4831 StdDev: 160.87 Min: 1 Median: 3.4487 Max: 10843 Percentiles: P50: 3.45 P75: 5.18 P99: 26.98 P99.9: 1513.74 P99.99: 3106.37 ------------------------------------------------------ [ 0, 1 ] 1515 0.415% 0.415% ( 1, 2 ] 59782 16.360% 16.775% ### ( 2, 3 ] 91948 25.163% 41.938% ##### ( 3, 4 ] 65658 17.968% 59.906% #### ( 4, 6 ] 93630 25.623% 85.529% ##### ( 6, 10 ] 40139 10.985% 96.514% ## ( 10, 15 ] 6214 1.701% 98.214% ( 15, 22 ] 2729 0.747% 98.961% ( 22, 34 ] 342 0.094% 99.055% ( 34, 51 ] 46 0.013% 99.067% ( 51, 76 ] 19 0.005% 99.073% ( 76, 110 ] 52 0.014% 99.087% ( 110, 170 ] 309 0.085% 99.171% ( 170, 250 ] 518 0.142% 99.313% ( 250, 380 ] 488 0.134% 99.447% ( 380, 580 ] 622 0.170% 99.617% ( 580, 870 ] 553 0.151% 99.768% ( 870, 1300 ] 405 0.111% 99.879% ( 1300, 1900 ] 215 0.059% 99.938% ( 1900, 2900 ] 154 0.042% 99.980% ( 2900, 4400 ] 265 0.073% 100.053% ( 4400, 6600 ] 88 0.024% 100.077% ( 6600, 9900 ] 20 0.005% 100.082% ( 9900, 14000 ] 2 0.001% 100.083% ** Level 4 read latency histogram (micros): Count: 8764 Average: 14.5881 StdDev: 187.76 Min: 1 Median: 2.6119 Max: 6859 Percentiles: P50: 2.61 P75: 3.42 P99: 31.54 P99.9: 2790.86 P99.99: 6859.00 ------------------------------------------------------ [ 0, 1 ] 14 0.160% 0.160% ( 1, 2 ] 1525 17.401% 17.560% ### ( 2, 3 ] 4646 53.012% 70.573% ########### ( 3, 4 ] 916 10.452% 81.025% ## ( 4, 6 ] 1084 12.369% 93.393% ## ( 6, 10 ] 448 5.112% 98.505% # ( 10, 15 ] 27 0.308% 98.813% ( 15, 22 ] 10 0.114% 98.927% ( 22, 34 ] 8 0.091% 99.019% ( 34, 51 ] 1 0.011% 99.030% ( 76, 110 ] 3 0.034% 99.064% ( 110, 170 ] 9 0.103% 99.167% ( 170, 250 ] 18 0.205% 99.372% ( 250, 380 ] 8 0.091% 99.464% ( 380, 580 ] 6 0.068% 99.532% ( 580, 870 ] 7 0.080% 99.612% ( 870, 1300 ] 14 0.160% 99.772% ( 1300, 1900 ] 5 0.057% 99.829% ( 1900, 2900 ] 7 0.080% 99.909% ( 2900, 4400 ] 2 0.023% 99.932% ( 4400, 6600 ] 5 0.057% 99.989% ( 6600, 9900 ] 1 0.011% 100.000% ** Level 5 read latency histogram (micros): Count: 140 Average: 912.5000 StdDev: 1051.75 Min: 90 Median: 450.5882 Max: 6056 Percentiles: P50: 450.59 P75: 1260.91 P99: 5060.00 P99.9: 6056.00 P99.99: 6056.00 ------------------------------------------------------ ( 76, 110 ] 10 7.143% 7.143% # ( 110, 170 ] 28 20.000% 27.143% #### ( 170, 250 ] 10 7.143% 34.286% # ( 250, 380 ] 16 11.429% 45.714% ## ( 380, 580 ] 17 12.143% 57.857% ## ( 580, 870 ] 14 10.000% 67.857% ## ( 870, 1300 ] 11 7.857% 75.714% ## ( 1300, 1900 ] 6 4.286% 80.000% # ( 1900, 2900 ] 22 15.714% 95.714% ### ( 2900, 4400 ] 4 2.857% 98.571% # ( 4400, 6600 ] 2 1.429% 100.000% ** DB Stats ** Uptime(secs): 42.5 total, 5.1 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 185.37 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:10.952 H:M:S, 25.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 194.45 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.255 H:M:S, 24.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/11-05:24:10 ... thread 0: (1000000,9000000) ops and (139576.9,182263.1) ops/second in (7.164507,49.379172) 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/11 3.56 GB 182.5 8.7 0.0 8.7 17.2 8.5 0.0 2.0 110.9 219.4 80.07 72.49 165 0.485 9017K 12K 0.0 0.0 L1 9/0 1017.51 MB 101.8 5.6 4.9 0.8 5.6 4.8 0.1 1.2 175.4 173.7 32.92 31.41 4 8.231 5763K 35K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 3.8 1.8 181.5 181.4 0.61 0.59 1 0.614 113K 30 0.0 0.0 L3 22/0 917.55 MB 0.9 4.0 2.0 2.1 4.0 1.9 1.9 2.0 111.8 111.3 36.90 27.05 15 2.460 4171K 17K 0.0 0.0 L4 167/0 9.69 GB 1.0 3.1 2.5 0.6 3.1 2.5 1.3 1.2 113.4 112.9 28.43 19.32 30 0.948 3244K 14K 0.0 0.0 L5 1120/0 89.38 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1337/11 104.53 GB 0.0 21.6 9.4 12.2 30.0 17.8 10.8 3.5 123.6 171.6 178.93 150.86 215 0.832 22M 79K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.6 9.4 12.2 30.0 17.8 10.8 3.5 123.6 171.6 178.93 150.86 215 0.832 22M 79K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 21.6 9.4 12.2 21.5 9.3 0.0 0.0 151.5 150.8 145.99 124.09 80 1.825 22M 79K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 0.0 0.0 0.0 263.9 32.94 26.77 135 0.244 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): 49.6 total, 49.4 interval Flush(GB): cumulative 8.490, interval 8.490 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 29.99 GB write, 618.70 MB/s write, 21.60 GB read, 445.64 MB/s read, 178.9 seconds Interval compaction: 29.99 GB write, 621.92 MB/s write, 21.60 GB read, 447.95 MB/s read, 178.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 28, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 28, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 11, pending-compaction-bytes-stops: 0, total-delays: 39, total-stops: 17, interval: 56 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3868165 Average: 3.3951 StdDev: 27.06 Min: 1 Median: 2.1637 Max: 12153 Percentiles: P50: 2.16 P75: 2.91 P99: 9.51 P99.9: 14.57 P99.99: 20.28 ------------------------------------------------------ [ 0, 1 ] 135212 3.496% 3.496% # ( 1, 2 ] 1585718 40.994% 44.490% ######## ( 2, 3 ] 1302378 33.669% 78.159% ####### ( 3, 4 ] 323878 8.373% 86.532% ## ( 4, 6 ] 363353 9.393% 95.925% ## ( 6, 10 ] 135526 3.504% 99.429% # ( 10, 15 ] 19955 0.516% 99.945% ( 15, 22 ] 2333 0.060% 100.005% ( 22, 34 ] 201 0.005% 100.010% ( 34, 51 ] 45 0.001% 100.011% ( 51, 76 ] 29 0.001% 100.012% ( 76, 110 ] 403 0.010% 100.022% ( 110, 170 ] 1059 0.027% 100.050% ( 170, 250 ] 499 0.013% 100.063% ( 250, 380 ] 310 0.008% 100.071% ( 380, 580 ] 237 0.006% 100.077% ( 580, 870 ] 197 0.005% 100.082% ( 870, 1300 ] 107 0.003% 100.085% ( 1300, 1900 ] 45 0.001% 100.086% ( 1900, 2900 ] 30 0.001% 100.087% ( 2900, 4400 ] 82 0.002% 100.089% ( 4400, 6600 ] 15 0.000% 100.089% ( 6600, 9900 ] 5 0.000% 100.089% ( 9900, 14000 ] 2 0.000% 100.089% ** Level 1 read latency histogram (micros): Count: 1139164 Average: 7.2104 StdDev: 121.79 Min: 1 Median: 2.6950 Max: 25103 Percentiles: P50: 2.69 P75: 4.23 P99: 12.72 P99.9: 18.49 P99.99: 20.74 ------------------------------------------------------ [ 0, 1 ] 2514 0.221% 0.221% ( 1, 2 ] 240206 21.086% 21.307% #### ( 2, 3 ] 470327 41.287% 62.594% ######## ( 3, 4 ] 120138 10.546% 73.140% ## ( 4, 6 ] 184289 16.178% 89.318% ### ( 6, 10 ] 99968 8.776% 98.093% ## ( 10, 15 ] 19000 1.668% 99.761% ( 15, 22 ] 3179 0.279% 100.040% ( 22, 34 ] 461 0.040% 100.081% ( 34, 51 ] 62 0.005% 100.086% ( 51, 76 ] 54 0.005% 100.091% ( 76, 110 ] 155 0.014% 100.104% ( 110, 170 ] 329 0.029% 100.133% ( 170, 250 ] 204 0.018% 100.151% ( 250, 380 ] 238 0.021% 100.172% ( 380, 580 ] 273 0.024% 100.196% ( 580, 870 ] 273 0.024% 100.220% ( 870, 1300 ] 172 0.015% 100.235% ( 1300, 1900 ] 115 0.010% 100.245% ( 1900, 2900 ] 137 0.012% 100.257% ( 2900, 4400 ] 355 0.031% 100.288% ( 4400, 6600 ] 103 0.009% 100.297% ( 6600, 9900 ] 73 0.006% 100.304% ( 9900, 14000 ] 9 0.001% 100.305% ( 14000, 22000 ] 3 0.000% 100.305% ( 22000, 33000 ] 2 0.000% 100.305% ** Level 2 read latency histogram (micros): Count: 40624 Average: 6.1268 StdDev: 76.33 Min: 1 Median: 2.7018 Max: 7867 Percentiles: P50: 2.70 P75: 4.38 P99: 15.94 P99.9: 586.82 P99.99: 4353.20 ------------------------------------------------------ [ 0, 1 ] 29 0.071% 0.071% ( 1, 2 ] 13293 32.722% 32.793% ####### ( 2, 3 ] 9960 24.518% 57.311% ##### ( 3, 4 ] 5766 14.194% 71.505% ### ( 4, 6 ] 7513 18.494% 89.999% #### ( 6, 10 ] 3189 7.850% 97.849% ## ( 10, 15 ] 435 1.071% 98.919% ( 15, 22 ] 243 0.598% 99.518% ( 22, 34 ] 35 0.086% 99.604% ( 34, 51 ] 2 0.005% 99.609% ( 51, 76 ] 40 0.098% 99.707% ( 76, 110 ] 8 0.020% 99.727% ( 110, 170 ] 14 0.034% 99.761% ( 170, 250 ] 24 0.059% 99.820% ( 250, 380 ] 18 0.044% 99.865% ( 380, 580 ] 14 0.034% 99.899% ( 580, 870 ] 16 0.039% 99.938% ( 870, 1300 ] 10 0.025% 99.963% ( 1300, 1900 ] 3 0.007% 99.970% ( 1900, 2900 ] 6 0.015% 99.985% ( 2900, 4400 ] 2 0.005% 99.990% ( 4400, 6600 ] 3 0.007% 99.998% ( 6600, 9900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 829512 Average: 10.2997 StdDev: 127.09 Min: 1 Median: 2.9555 Max: 11250 Percentiles: P50: 2.96 P75: 4.83 P99: 14.62 P99.9: 508.32 P99.99: 742.00 ------------------------------------------------------ [ 0, 1 ] 4004 0.483% 0.483% ( 1, 2 ] 158163 19.067% 19.550% #### ( 2, 3 ] 264363 31.870% 51.419% ###### ( 3, 4 ] 120040 14.471% 65.891% ### ( 4, 6 ] 181593 21.892% 87.782% #### ( 6, 10 ] 82851 9.988% 97.770% ## ( 10, 15 ] 11039 1.331% 99.101% ( 15, 22 ] 3488 0.420% 99.521% ( 22, 34 ] 400 0.048% 99.570% ( 34, 51 ] 55 0.007% 99.576% ( 51, 76 ] 69 0.008% 99.584% ( 76, 110 ] 129 0.016% 99.600% ( 110, 170 ] 469 0.057% 99.657% ( 170, 250 ] 733 0.088% 99.745% ( 250, 380 ] 727 0.088% 99.833% ( 380, 580 ] 872 0.105% 99.938% ( 580, 870 ] 777 0.094% 100.031% ( 870, 1300 ] 540 0.065% 100.096% ( 1300, 1900 ] 272 0.033% 100.129% ( 1900, 2900 ] 207 0.025% 100.154% ( 2900, 4400 ] 386 0.047% 100.201% ( 4400, 6600 ] 112 0.014% 100.214% ( 6600, 9900 ] 29 0.003% 100.218% ( 9900, 14000 ] 5 0.001% 100.218% ** Level 4 read latency histogram (micros): Count: 66490 Average: 17.7226 StdDev: 187.66 Min: 1 Median: 2.7268 Max: 8616 Percentiles: P50: 2.73 P75: 4.26 P99: 317.14 P99.9: 2572.19 P99.99: 4658.61 ------------------------------------------------------ [ 0, 1 ] 265 0.399% 0.399% ( 1, 2 ] 12517 18.825% 19.224% #### ( 2, 3 ] 28154 42.343% 61.567% ######## ( 3, 4 ] 7542 11.343% 72.910% ## ( 4, 6 ] 10889 16.377% 89.287% ### ( 6, 10 ] 4787 7.200% 96.487% # ( 10, 15 ] 1006 1.513% 98.000% ( 15, 22 ] 142 0.214% 98.213% ( 22, 34 ] 18 0.027% 98.240% ( 34, 51 ] 9 0.014% 98.254% ( 51, 76 ] 3 0.005% 98.258% ( 76, 110 ] 31 0.047% 98.305% ( 110, 170 ] 161 0.242% 98.547% ( 170, 250 ] 188 0.283% 98.830% ( 250, 380 ] 219 0.329% 99.159% ( 380, 580 ] 169 0.254% 99.413% ( 580, 870 ] 171 0.257% 99.671% ( 870, 1300 ] 95 0.143% 99.814% ( 1300, 1900 ] 36 0.054% 99.868% ( 1900, 2900 ] 32 0.048% 99.916% ( 2900, 4400 ] 47 0.071% 99.986% ( 4400, 6600 ] 20 0.030% 100.017% ( 6600, 9900 ] 11 0.017% 100.033% ** Level 5 read latency histogram (micros): Count: 220 Average: 1005.2955 StdDev: 1134.74 Min: 90 Median: 468.8889 Max: 6056 Percentiles: P50: 468.89 P75: 1600.00 P99: 4986.67 P99.9: 6056.00 P99.99: 6056.00 ------------------------------------------------------ ( 76, 110 ] 11 5.000% 5.000% # ( 110, 170 ] 44 20.000% 25.000% #### ( 170, 250 ] 16 7.273% 32.273% # ( 250, 380 ] 27 12.273% 44.545% ## ( 380, 580 ] 27 12.273% 56.818% ## ( 580, 870 ] 19 8.636% 65.455% ## ( 870, 1300 ] 16 7.273% 72.727% # ( 1300, 1900 ] 10 4.545% 77.273% # ( 1900, 2900 ] 31 14.091% 91.364% ### ( 2900, 4400 ] 16 7.273% 98.636% # ( 4400, 6600 ] 3 1.364% 100.000% ** DB Stats ** Uptime(secs): 49.6 total, 7.2 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 178.45 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:13.769 H:M:S, 27.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 137.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:2.818 H:M:S, 39.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/11-05:24:15 ... thread 0: (1000000,10000000) ops and (189750.9,182985.2) ops/second in (5.270067,54.649239) 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/16 4.60 GB 44.0 11.1 0.0 11.1 20.6 9.5 0.0 2.2 115.3 214.3 98.33 89.47 183 0.537 11M 23K 0.0 0.0 L1 9/9 1017.51 MB 0.0 5.6 4.9 0.8 5.6 4.8 0.1 1.2 175.4 173.7 32.92 31.41 4 8.231 5763K 35K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 3.8 1.8 181.5 181.4 0.61 0.59 1 0.614 113K 30 0.0 0.0 L3 22/0 917.55 MB 0.9 4.0 2.0 2.1 4.0 1.9 1.9 2.0 111.8 111.3 36.90 27.05 15 2.460 4171K 17K 0.0 0.0 L4 167/0 9.69 GB 1.0 3.1 2.5 0.6 3.1 2.5 1.3 1.2 113.4 112.9 28.43 19.32 30 0.948 3244K 14K 0.0 0.0 L5 1120/0 89.38 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1336/25 105.56 GB 0.0 24.0 9.4 14.6 33.4 18.8 10.8 3.5 124.6 173.6 197.20 167.84 233 0.846 24M 91K 0.0 0.0 Int 0/0 0.00 KB 0.0 24.0 9.4 14.6 33.4 18.8 10.8 3.5 124.6 173.6 197.20 167.84 233 0.846 24M 91K 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.0 9.4 14.6 23.9 9.3 0.0 0.0 153.1 152.3 160.56 137.74 84 1.911 24M 91K 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 266.5 36.64 30.10 149 0.246 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 54.9 total, 54.7 interval Flush(GB): cumulative 9.536, interval 9.536 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 33.42 GB write, 623.33 MB/s write, 24.00 GB read, 447.58 MB/s read, 197.2 seconds Interval compaction: 33.42 GB write, 626.25 MB/s write, 24.00 GB read, 449.68 MB/s read, 197.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 34, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 34, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 21, pending-compaction-bytes-delays: 11, pending-compaction-bytes-stops: 0, total-delays: 45, total-stops: 21, interval: 66 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4267342 Average: 3.4662 StdDev: 26.73 Min: 1 Median: 2.2090 Max: 12153 Percentiles: P50: 2.21 P75: 2.95 P99: 9.57 P99.9: 14.75 P99.99: 20.59 ------------------------------------------------------ [ 0, 1 ] 135347 3.172% 3.172% # ( 1, 2 ] 1698811 39.810% 42.981% ######## ( 2, 3 ] 1433115 33.583% 76.565% ####### ( 3, 4 ] 381418 8.938% 85.503% ## ( 4, 6 ] 435784 10.212% 95.715% ## ( 6, 10 ] 157265 3.685% 99.400% # ( 10, 15 ] 22471 0.527% 99.927% ( 15, 22 ] 3390 0.079% 100.006% ( 22, 34 ] 277 0.006% 100.013% ( 34, 51 ] 53 0.001% 100.014% ( 51, 76 ] 34 0.001% 100.015% ( 76, 110 ] 407 0.010% 100.024% ( 110, 170 ] 1175 0.028% 100.052% ( 170, 250 ] 604 0.014% 100.066% ( 250, 380 ] 413 0.010% 100.076% ( 380, 580 ] 317 0.007% 100.083% ( 580, 870 ] 250 0.006% 100.089% ( 870, 1300 ] 127 0.003% 100.092% ( 1300, 1900 ] 58 0.001% 100.093% ( 1900, 2900 ] 32 0.001% 100.094% ( 2900, 4400 ] 86 0.002% 100.096% ( 4400, 6600 ] 16 0.000% 100.096% ( 6600, 9900 ] 5 0.000% 100.096% ( 9900, 14000 ] 2 0.000% 100.096% ** Level 1 read latency histogram (micros): Count: 1139165 Average: 7.2107 StdDev: 121.79 Min: 1 Median: 2.6950 Max: 25103 Percentiles: P50: 2.69 P75: 4.23 P99: 12.72 P99.9: 18.49 P99.99: 20.75 ------------------------------------------------------ [ 0, 1 ] 2514 0.221% 0.221% ( 1, 2 ] 240206 21.086% 21.307% #### ( 2, 3 ] 470327 41.287% 62.594% ######## ( 3, 4 ] 120138 10.546% 73.140% ## ( 4, 6 ] 184289 16.178% 89.318% ### ( 6, 10 ] 99968 8.776% 98.093% ## ( 10, 15 ] 19000 1.668% 99.761% ( 15, 22 ] 3179 0.279% 100.040% ( 22, 34 ] 461 0.040% 100.080% ( 34, 51 ] 62 0.005% 100.086% ( 51, 76 ] 54 0.005% 100.091% ( 76, 110 ] 155 0.014% 100.104% ( 110, 170 ] 329 0.029% 100.133% ( 170, 250 ] 204 0.018% 100.151% ( 250, 380 ] 239 0.021% 100.172% ( 380, 580 ] 273 0.024% 100.196% ( 580, 870 ] 273 0.024% 100.220% ( 870, 1300 ] 172 0.015% 100.235% ( 1300, 1900 ] 115 0.010% 100.245% ( 1900, 2900 ] 137 0.012% 100.257% ( 2900, 4400 ] 355 0.031% 100.288% ( 4400, 6600 ] 103 0.009% 100.297% ( 6600, 9900 ] 73 0.006% 100.304% ( 9900, 14000 ] 9 0.001% 100.305% ( 14000, 22000 ] 3 0.000% 100.305% ( 22000, 33000 ] 2 0.000% 100.305% ** Level 2 read latency histogram (micros): Count: 40624 Average: 6.1268 StdDev: 76.33 Min: 1 Median: 2.7018 Max: 7867 Percentiles: P50: 2.70 P75: 4.38 P99: 15.94 P99.9: 586.82 P99.99: 4353.20 ------------------------------------------------------ [ 0, 1 ] 29 0.071% 0.071% ( 1, 2 ] 13293 32.722% 32.793% ####### ( 2, 3 ] 9960 24.518% 57.311% ##### ( 3, 4 ] 5766 14.194% 71.505% ### ( 4, 6 ] 7513 18.494% 89.999% #### ( 6, 10 ] 3189 7.850% 97.849% ## ( 10, 15 ] 435 1.071% 98.919% ( 15, 22 ] 243 0.598% 99.518% ( 22, 34 ] 35 0.086% 99.604% ( 34, 51 ] 2 0.005% 99.609% ( 51, 76 ] 40 0.098% 99.707% ( 76, 110 ] 8 0.020% 99.727% ( 110, 170 ] 14 0.034% 99.761% ( 170, 250 ] 24 0.059% 99.820% ( 250, 380 ] 18 0.044% 99.865% ( 380, 580 ] 14 0.034% 99.899% ( 580, 870 ] 16 0.039% 99.938% ( 870, 1300 ] 10 0.025% 99.963% ( 1300, 1900 ] 3 0.007% 99.970% ( 1900, 2900 ] 6 0.015% 99.985% ( 2900, 4400 ] 2 0.005% 99.990% ( 4400, 6600 ] 3 0.007% 99.998% ( 6600, 9900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 829512 Average: 10.2997 StdDev: 127.09 Min: 1 Median: 2.9555 Max: 11250 Percentiles: P50: 2.96 P75: 4.83 P99: 14.62 P99.9: 508.32 P99.99: 742.00 ------------------------------------------------------ [ 0, 1 ] 4004 0.483% 0.483% ( 1, 2 ] 158163 19.067% 19.550% #### ( 2, 3 ] 264363 31.870% 51.419% ###### ( 3, 4 ] 120040 14.471% 65.891% ### ( 4, 6 ] 181593 21.892% 87.782% #### ( 6, 10 ] 82851 9.988% 97.770% ## ( 10, 15 ] 11039 1.331% 99.101% ( 15, 22 ] 3488 0.420% 99.521% ( 22, 34 ] 400 0.048% 99.570% ( 34, 51 ] 55 0.007% 99.576% ( 51, 76 ] 69 0.008% 99.584% ( 76, 110 ] 129 0.016% 99.600% ( 110, 170 ] 469 0.057% 99.657% ( 170, 250 ] 733 0.088% 99.745% ( 250, 380 ] 727 0.088% 99.833% ( 380, 580 ] 872 0.105% 99.938% ( 580, 870 ] 777 0.094% 100.031% ( 870, 1300 ] 540 0.065% 100.096% ( 1300, 1900 ] 272 0.033% 100.129% ( 1900, 2900 ] 207 0.025% 100.154% ( 2900, 4400 ] 386 0.047% 100.201% ( 4400, 6600 ] 112 0.014% 100.214% ( 6600, 9900 ] 29 0.003% 100.218% ( 9900, 14000 ] 5 0.001% 100.218% ** Level 4 read latency histogram (micros): Count: 66490 Average: 17.7226 StdDev: 187.66 Min: 1 Median: 2.7268 Max: 8616 Percentiles: P50: 2.73 P75: 4.26 P99: 317.14 P99.9: 2572.19 P99.99: 4658.61 ------------------------------------------------------ [ 0, 1 ] 265 0.399% 0.399% ( 1, 2 ] 12517 18.825% 19.224% #### ( 2, 3 ] 28154 42.343% 61.567% ######## ( 3, 4 ] 7542 11.343% 72.910% ## ( 4, 6 ] 10889 16.377% 89.287% ### ( 6, 10 ] 4787 7.200% 96.487% # ( 10, 15 ] 1006 1.513% 98.000% ( 15, 22 ] 142 0.214% 98.213% ( 22, 34 ] 18 0.027% 98.240% ( 34, 51 ] 9 0.014% 98.254% ( 51, 76 ] 3 0.005% 98.258% ( 76, 110 ] 31 0.047% 98.305% ( 110, 170 ] 161 0.242% 98.547% ( 170, 250 ] 188 0.283% 98.830% ( 250, 380 ] 219 0.329% 99.159% ( 380, 580 ] 169 0.254% 99.413% ( 580, 870 ] 171 0.257% 99.671% ( 870, 1300 ] 95 0.143% 99.814% ( 1300, 1900 ] 36 0.054% 99.868% ( 1900, 2900 ] 32 0.048% 99.916% ( 2900, 4400 ] 47 0.071% 99.986% ( 4400, 6600 ] 20 0.030% 100.017% ( 6600, 9900 ] 11 0.017% 100.033% ** Level 5 read latency histogram (micros): Count: 220 Average: 1005.2955 StdDev: 1134.74 Min: 90 Median: 468.8889 Max: 6056 Percentiles: P50: 468.89 P75: 1600.00 P99: 4986.67 P99.9: 6056.00 P99.99: 6056.00 ------------------------------------------------------ ( 76, 110 ] 11 5.000% 5.000% # ( 110, 170 ] 44 20.000% 25.000% #### ( 170, 250 ] 16 7.273% 32.273% # ( 250, 380 ] 27 12.273% 44.545% ## ( 380, 580 ] 27 12.273% 56.818% ## ( 580, 870 ] 19 8.636% 65.455% ## ( 870, 1300 ] 16 7.273% 72.727% # ( 1300, 1900 ] 10 4.545% 77.273% # ( 1900, 2900 ] 31 14.091% 91.364% ### ( 2900, 4400 ] 16 7.273% 98.636% # ( 4400, 6600 ] 3 1.364% 100.000% ** DB Stats ** Uptime(secs): 54.9 total, 5.3 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 179.24 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:16.543 H:M:S, 30.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 186.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:2.774 H:M:S, 52.6 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.862 micros/op 170594 ops/sec 60.049 seconds 10243999 operations; 165.3 MB/s Microseconds per write: Count: 10243999 Average: 5.8619 StdDev: 325.68 Min: 1 Median: 2.6460 Max: 745254 Percentiles: P50: 2.65 P75: 3.91 P99: 9.93 P99.9: 1036.67 P99.99: 2650.18 ------------------------------------------------------ [ 0, 1 ] 258575 2.524% 2.524% # ( 1, 2 ] 2288778 22.343% 24.867% #### ( 2, 3 ] 3985591 38.907% 63.773% ######## ( 3, 4 ] 1267744 12.375% 76.149% ## ( 4, 6 ] 1912425 18.669% 94.818% #### ( 6, 10 ] 436055 4.257% 99.074% # ( 10, 15 ] 57364 0.560% 99.634% ( 15, 22 ] 8893 0.087% 99.721% ( 22, 34 ] 2977 0.029% 99.750% ( 34, 51 ] 485 0.005% 99.755% ( 51, 76 ] 118 0.001% 99.756% ( 76, 110 ] 1056 0.010% 99.766% ( 110, 170 ] 8201 0.080% 99.846% ( 170, 250 ] 867 0.008% 99.855% ( 250, 380 ] 309 0.003% 99.858% ( 380, 580 ] 59 0.001% 99.858% ( 580, 870 ] 32 0.000% 99.859% ( 870, 1300 ] 10903 0.106% 99.965% ( 1300, 1900 ] 73 0.001% 99.966% ( 1900, 2900 ] 3292 0.032% 99.998% ( 2900, 4400 ] 161 0.002% 100.000% ( 4400, 6600 ] 21 0.000% 100.000% ( 6600, 9900 ] 8 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 50000, 75000 ] 2 0.000% 100.000% ( 170000, 250000 ] 1 0.000% 100.000% ( 250000, 380000 ] 4 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 : 128970 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 : 10243999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10571806968 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 : 521 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 21282135 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 : 27302875197 rocksdb.compact.write.bytes COUNT : 27170119083 rocksdb.flush.write.bytes COUNT : 10569653938 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 : 53 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 : 318 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 : 10483957760 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3666944 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 : 27397260847 rocksdb.non.last.level.read.count COUNT : 6614273 rocksdb.block.checksum.compute.count COUNT : 6613284 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.924189 P95 : 5.617458 P99 : 9.277304 P100 : 745243.000000 COUNT : 10243999 SUM : 53082685 rocksdb.compaction.times.micros P50 : 1467647.058824 P95 : 4195000.000000 P99 : 15120000.000000 P100 : 15975192.000000 COUNT : 86 SUM : 163859044 rocksdb.compaction.times.cpu_micros P50 : 1200000.000000 P95 : 4090000.000000 P99 : 15120000.000000 P100 : 15409827.000000 COUNT : 86 SUM : 140962752 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 : 781.129032 P95 : 1415.714286 P99 : 2370.000000 P100 : 11194.000000 COUNT : 153 SUM : 137024 rocksdb.compaction.outfile.sync.micros P50 : 1113.841463 P95 : 8308.928571 P99 : 13897.500000 P100 : 15756.000000 COUNT : 315 SUM : 666639 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 : 146.285714 P95 : 559.285714 P99 : 2210.000000 P100 : 3656.000000 COUNT : 269 SUM : 61422 rocksdb.table.open.io.micros P50 : 1246.882353 P95 : 7249.000000 P99 : 12672.230769 P100 : 14689.000000 COUNT : 521 SUM : 1078805 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 : 5.265142 P95 : 10.517820 P99 : 16.317130 P100 : 25110.000000 COUNT : 6611702 SUM : 53849636 rocksdb.read.block.get.micros P50 : 378.964143 P95 : 3152.439024 P99 : 5682.769231 P100 : 9285.000000 COUNT : 1042 SUM : 862728 rocksdb.write.raw.block.micros P50 : 0.578214 P95 : 1.811559 P99 : 4.297138 P100 : 53572.000000 COUNT : 9140050 SUM : 25234356 rocksdb.numfiles.in.singlecompaction P50 : 3.337662 P95 : 6.533333 P99 : 14.466667 P100 : 21.000000 COUNT : 132 SUM : 513 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.559896 P95 : 1168.891809 P99 : 2512.923780 P100 : 744994.000000 COUNT : 134561 SUM : 21293328 rocksdb.sst.read.micros P50 : 2.434760 P95 : 7.237185 P99 : 11.403414 P100 : 25103.000000 COUNT : 6614333 SUM : 34366785 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 : 10243999 SUM : 10571806968 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 : 214961.240310 P95 : 481650.000000 P99 : 783150.000000 P100 : 1159564.000000 COUNT : 153 SUM : 37748085 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 : 330 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