[2024-11-06 04:29:28.157234] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 22.11.4 initialization... [2024-11-06 04:29:28.157492] [ 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_pid1250990 ] Set seed to 1730863768150522 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-06 04:29:28.256997] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-06 04:29:28.296517] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-06 04:29:28.296560] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1250990' to capture a snapshot of events at runtime. [2024-11-06 04:29:28.296572] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1250990 for offline analysis/debug. [2024-11-06 04:29:28.296596] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Wed Nov 6 04:29:32 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/06-04:29:35 ... thread 0: (1000000,1000000) ops and (357110.7,357110.7) ops/second in (2.800252,2.800252) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/6 567.01 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 351.3 2.33 2.11 12 0.194 0 0 0.0 0.0 L2 3/2 251.74 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.1 2.0 254.4 254.2 1.49 1.43 2 0.743 383K 216 0.0 0.0 L3 11/0 867.26 MB 0.9 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.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 1183/8 96.94 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.5 99.0 313.5 3.82 3.54 14 0.273 383K 216 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.1 1.5 99.0 313.5 3.82 3.54 14 0.273 383K 216 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.0 0.0 254.4 254.2 1.49 1.43 2 0.743 383K 216 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 351.3 2.33 2.11 12 0.194 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.17 GB write, 397.43 MB/s write, 0.37 GB read, 125.52 MB/s read, 3.8 seconds Interval compaction: 1.17 GB write, 427.01 MB/s write, 0.37 GB read, 134.86 MB/s read, 3.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 103193 Average: 1.8111 StdDev: 15.76 Min: 0 Median: 1.1533 Max: 3115 Percentiles: P50: 1.15 P75: 1.62 P99: 3.76 P99.9: 9.95 P99.99: 308.08 ------------------------------------------------------ [ 0, 1 ] 43089 41.756% 41.756% ######## ( 1, 2 ] 55506 53.789% 95.544% ########### ( 2, 3 ] 2708 2.624% 98.168% # ( 3, 4 ] 1133 1.098% 99.266% ( 4, 6 ] 490 0.475% 99.741% ( 6, 10 ] 166 0.161% 99.902% ( 10, 15 ] 57 0.055% 99.957% ( 15, 22 ] 17 0.016% 99.974% ( 22, 34 ] 1 0.001% 99.975% ( 51, 76 ] 1 0.001% 99.976% ( 76, 110 ] 1 0.001% 99.977% ( 110, 170 ] 7 0.007% 99.984% ( 170, 250 ] 4 0.004% 99.987% ( 250, 380 ] 6 0.006% 99.993% ( 380, 580 ] 1 0.001% 99.994% ( 580, 870 ] 1 0.001% 99.995% ( 870, 1300 ] 1 0.001% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 50655 Average: 2.0758 StdDev: 23.61 Min: 1 Median: 1.2032 Max: 2676 Percentiles: P50: 1.20 P75: 1.66 P99: 5.07 P99.9: 11.44 P99.99: 1271.83 ------------------------------------------------------ [ 0, 1 ] 19738 38.966% 38.966% ######## ( 1, 2 ] 27502 54.293% 93.258% ########### ( 2, 3 ] 1801 3.555% 96.814% # ( 3, 4 ] 844 1.666% 98.480% ( 4, 6 ] 493 0.973% 99.453% ( 6, 10 ] 217 0.428% 99.882% ( 10, 15 ] 36 0.071% 99.953% ( 15, 22 ] 4 0.008% 99.961% ( 22, 34 ] 3 0.006% 99.966% ( 34, 51 ] 2 0.004% 99.970% ( 110, 170 ] 1 0.002% 99.972% ( 250, 380 ] 3 0.006% 99.978% ( 380, 580 ] 3 0.006% 99.984% ( 580, 870 ] 3 0.006% 99.990% ( 870, 1300 ] 1 0.002% 99.992% ( 1300, 1900 ] 1 0.002% 99.994% ( 1900, 2900 ] 4 0.008% 100.002% ** Level 3 read latency histogram (micros): Count: 45 Average: 1714.1111 StdDev: 1258.61 Min: 159 Median: 1180.5556 Max: 4679 Percentiles: P50: 1180.56 P75: 2721.43 P99: 4679.00 P99.9: 4679.00 P99.99: 4679.00 ------------------------------------------------------ ( 110, 170 ] 1 2.222% 2.222% ( 170, 250 ] 1 2.222% 4.444% ( 250, 380 ] 2 4.444% 8.889% # ( 380, 580 ] 3 6.667% 15.556% # ( 580, 870 ] 9 20.000% 35.556% #### ( 870, 1300 ] 9 20.000% 55.556% #### ( 1300, 1900 ] 3 6.667% 62.222% # ( 1900, 2900 ] 7 15.556% 77.778% ### ( 2900, 4400 ] 8 17.778% 95.556% #### ( 4400, 6600 ] 2 4.444% 100.000% # ** Level 4 read latency histogram (micros): Count: 25 Average: 1906.6000 StdDev: 1372.09 Min: 266 Median: 1228.3333 Max: 5050 Percentiles: P50: 1228.33 P75: 2816.67 P99: 5050.00 P99.9: 5050.00 P99.99: 5050.00 ------------------------------------------------------ ( 250, 380 ] 2 8.000% 8.000% ## ( 380, 580 ] 2 8.000% 16.000% ## ( 580, 870 ] 1 4.000% 20.000% # ( 870, 1300 ] 9 36.000% 56.000% ####### ( 1300, 1900 ] 2 8.000% 64.000% ## ( 1900, 2900 ] 3 12.000% 76.000% ## ( 2900, 4400 ] 4 16.000% 92.000% ### ( 4400, 6600 ] 2 8.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 326.84 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.224 H:M:S, 7.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 351.12 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.224 H:M:S, 8.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/06-04:29:38 ... thread 0: (1000000,2000000) ops and (322459.8,338901.8) ops/second in (3.101162,5.901414) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/14 1.17 GB 0.0 0.2 0.0 0.2 2.0 1.8 0.0 1.1 40.8 336.5 6.18 5.60 27 0.229 255K 218 0.0 0.0 L1 1/1 3.19 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 236.4 236.0 1.60 1.56 1 1.599 383K 633 0.0 0.0 L2 2/1 54.16 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 254.4 254.2 1.49 1.43 2 0.743 383K 216 0.0 0.0 L3 21/11 1.19 GB 0.3 0.2 0.2 0.0 0.2 0.2 0.4 1.0 239.2 239.2 1.04 0.98 1 1.043 253K 0 0.0 0.0 L4 174/0 9.75 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 161.6 161.7 1.39 1.01 1 1.389 227K 0 0.0 0.0 L5 1044/0 85.75 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1256/27 97.92 GB 0.0 1.4 1.0 0.4 3.2 2.8 1.1 1.8 126.7 282.9 11.69 10.58 32 0.365 1504K 1067 0.0 0.0 Int 0/0 0.00 KB 0.0 1.4 1.0 0.4 3.2 2.8 1.0 1.8 126.7 282.9 11.69 10.58 32 0.365 1504K 1067 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.4 1.0 0.4 1.4 1.0 0.0 0.0 228.4 228.3 6.49 5.93 6 1.081 1504K 1067 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 350.9 5.21 4.65 26 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 total, 5.9 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.23 GB write, 541.18 MB/s write, 1.45 GB read, 242.46 MB/s read, 11.7 seconds Interval compaction: 3.23 GB write, 560.29 MB/s write, 1.45 GB read, 251.03 MB/s read, 11.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 6, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 6, interval: 6 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 396144 Average: 2.1671 StdDev: 11.52 Min: 0 Median: 1.4599 Max: 3330 Percentiles: P50: 1.46 P75: 1.86 P99: 5.64 P99.9: 9.96 P99.99: 14.55 ------------------------------------------------------ [ 0, 1 ] 84594 21.354% 21.354% #### ( 1, 2 ] 246757 62.290% 83.644% ############ ( 2, 3 ] 35320 8.916% 92.560% ## ( 3, 4 ] 16534 4.174% 96.734% # ( 4, 6 ] 10938 2.761% 99.495% # ( 6, 10 ] 1621 0.409% 99.904% ( 10, 15 ] 375 0.095% 99.999% ( 15, 22 ] 31 0.008% 100.007% ( 22, 34 ] 5 0.001% 100.008% ( 34, 51 ] 3 0.001% 100.009% ( 51, 76 ] 4 0.001% 100.010% ( 76, 110 ] 1 0.000% 100.010% ( 110, 170 ] 12 0.003% 100.013% ( 170, 250 ] 11 0.003% 100.016% ( 250, 380 ] 12 0.003% 100.019% ( 380, 580 ] 2 0.001% 100.019% ( 580, 870 ] 7 0.002% 100.021% ( 870, 1300 ] 2 0.001% 100.021% ( 1300, 1900 ] 4 0.001% 100.022% ( 1900, 2900 ] 2 0.001% 100.023% ( 2900, 4400 ] 2 0.001% 100.023% ** Level 1 read latency histogram (micros): Count: 26 Average: 150.3462 StdDev: 295.55 Min: 1 Median: 1.7778 Max: 1219 Percentiles: P50: 1.78 P75: 210.00 P99: 1219.00 P99.9: 1219.00 P99.99: 1219.00 ------------------------------------------------------ [ 0, 1 ] 6 23.077% 23.077% ##### ( 1, 2 ] 9 34.615% 57.692% ####### ( 2, 3 ] 2 7.692% 65.385% ## ( 4, 6 ] 1 3.846% 69.231% # ( 110, 170 ] 1 3.846% 73.077% # ( 170, 250 ] 1 3.846% 76.923% # ( 250, 380 ] 3 11.538% 88.462% ## ( 380, 580 ] 1 3.846% 92.308% # ( 870, 1300 ] 2 7.692% 100.000% ## ** Level 2 read latency histogram (micros): Count: 95662 Average: 2.1189 StdDev: 17.19 Min: 1 Median: 1.3563 Max: 2676 Percentiles: P50: 1.36 P75: 1.78 P99: 5.65 P99.9: 9.93 P99.99: 542.25 ------------------------------------------------------ [ 0, 1 ] 27779 29.039% 29.039% ###### ( 1, 2 ] 56272 58.824% 87.862% ############ ( 2, 3 ] 5864 6.130% 93.992% # ( 3, 4 ] 3071 3.210% 97.203% # ( 4, 6 ] 2086 2.181% 99.383% ( 6, 10 ] 503 0.526% 99.909% ( 10, 15 ] 59 0.062% 99.971% ( 15, 22 ] 6 0.006% 99.977% ( 22, 34 ] 3 0.003% 99.980% ( 34, 51 ] 3 0.003% 99.983% ( 110, 170 ] 1 0.001% 99.984% ( 250, 380 ] 3 0.003% 99.987% ( 380, 580 ] 3 0.003% 99.991% ( 580, 870 ] 3 0.003% 99.994% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 1 0.001% 99.996% ( 1900, 2900 ] 4 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 177036 Average: 3.3030 StdDev: 37.21 Min: 1 Median: 1.5730 Max: 4679 Percentiles: P50: 1.57 P75: 1.98 P99: 8.78 P99.9: 169.99 P99.99: 715.73 ------------------------------------------------------ [ 0, 1 ] 25577 14.447% 14.447% ### ( 1, 2 ] 109848 62.048% 76.496% ############ ( 2, 3 ] 22397 12.651% 89.147% ### ( 3, 4 ] 8814 4.979% 94.125% # ( 4, 6 ] 6823 3.854% 97.980% # ( 6, 10 ] 2599 1.468% 99.448% ( 10, 15 ] 399 0.225% 99.673% ( 15, 22 ] 92 0.052% 99.725% ( 22, 34 ] 18 0.010% 99.735% ( 34, 51 ] 3 0.002% 99.737% ( 51, 76 ] 1 0.001% 99.737% ( 76, 110 ] 86 0.049% 99.786% ( 110, 170 ] 202 0.114% 99.900% ( 170, 250 ] 63 0.036% 99.936% ( 250, 380 ] 54 0.031% 99.966% ( 380, 580 ] 32 0.018% 99.984% ( 580, 870 ] 22 0.012% 99.997% ( 870, 1300 ] 12 0.007% 100.003% ( 1300, 1900 ] 5 0.003% 100.006% ( 1900, 2900 ] 7 0.004% 100.010% ( 2900, 4400 ] 9 0.005% 100.015% ( 4400, 6600 ] 2 0.001% 100.016% ** Level 4 read latency histogram (micros): Count: 315 Average: 154.2889 StdDev: 643.53 Min: 0 Median: 1.4115 Max: 5050 Percentiles: P50: 1.41 P75: 5.25 P99: 3968.75 P99.9: 5050.00 P99.99: 5050.00 ------------------------------------------------------ [ 0, 1 ] 118 37.460% 37.460% ####### ( 1, 2 ] 96 30.476% 67.937% ###### ( 2, 3 ] 15 4.762% 72.698% # ( 3, 4 ] 1 0.317% 73.016% ( 4, 6 ] 10 3.175% 76.190% # ( 6, 10 ] 33 10.476% 86.667% ## ( 10, 15 ] 16 5.079% 91.746% # ( 22, 34 ] 1 0.317% 92.063% ( 250, 380 ] 2 0.635% 92.698% ( 380, 580 ] 2 0.635% 93.333% ( 580, 870 ] 1 0.317% 93.651% ( 870, 1300 ] 9 2.857% 96.508% # ( 1300, 1900 ] 2 0.635% 97.143% ( 1900, 2900 ] 3 0.952% 98.095% ( 2900, 4400 ] 4 1.270% 99.365% ( 4400, 6600 ] 2 0.635% 100.000% ** DB Stats ** Uptime(secs): 6.1 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 322.03 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.638 H:M:S, 10.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 317.36 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.414 H:M:S, 13.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/11/06-04:29:41 ... thread 0: (1000000,3000000) ops and (304637.6,326654.9) ops/second in (3.282589,9.184003) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/4 1.54 GB 132.1 1.4 0.0 1.4 4.2 2.8 0.0 1.5 105.2 310.8 13.78 12.63 44 0.313 1471K 1603 0.0 0.0 L1 3/0 181.04 MB 18.1 1.0 1.0 0.0 1.0 1.0 0.2 1.0 230.4 229.9 4.39 4.24 2 2.194 1026K 2246 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 254.4 254.2 1.49 1.43 2 0.743 383K 216 0.0 0.0 L3 23/0 942.00 MB 0.9 1.9 0.7 1.2 1.9 0.7 0.4 2.6 221.8 221.4 8.87 8.07 6 1.479 1999K 4134 0.0 0.0 L4 174/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 161.6 161.7 1.39 1.01 1 1.389 227K 0 0.0 0.0 L5 1056/0 86.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1265/4 98.90 GB 0.0 4.9 2.1 2.8 7.7 4.9 3.3 2.8 168.2 262.7 29.91 27.39 55 0.544 5108K 8199 0.0 0.0 Int 0/0 0.00 KB 0.0 4.9 2.1 2.8 7.7 4.9 3.2 2.8 168.2 262.7 29.91 27.39 55 0.544 5108K 8199 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.9 2.1 2.8 4.9 2.1 0.0 0.0 231.2 230.8 21.76 20.22 16 1.360 5108K 8199 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 347.7 8.15 7.17 39 0.209 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.4 total, 9.2 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.67 GB write, 836.32 MB/s write, 4.91 GB read, 535.47 MB/s read, 29.9 seconds Interval compaction: 7.67 GB write, 855.31 MB/s write, 4.91 GB read, 547.63 MB/s read, 29.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: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 14, interval: 14 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 719754 Average: 2.2404 StdDev: 10.22 Min: 0 Median: 1.5001 Max: 3330 Percentiles: P50: 1.50 P75: 1.90 P99: 5.78 P99.9: 9.92 P99.99: 14.17 ------------------------------------------------------ [ 0, 1 ] 135772 18.864% 18.864% #### ( 1, 2 ] 448149 62.264% 81.128% ############ ( 2, 3 ] 70741 9.828% 90.956% ## ( 3, 4 ] 35047 4.869% 95.826% # ( 4, 6 ] 25695 3.570% 99.396% # ( 6, 10 ] 3704 0.515% 99.910% ( 10, 15 ] 689 0.096% 100.006% ( 15, 22 ] 69 0.010% 100.016% ( 22, 34 ] 7 0.001% 100.017% ( 34, 51 ] 5 0.001% 100.017% ( 51, 76 ] 6 0.001% 100.018% ( 76, 110 ] 1 0.000% 100.018% ( 110, 170 ] 14 0.002% 100.020% ( 170, 250 ] 19 0.003% 100.023% ( 250, 380 ] 21 0.003% 100.026% ( 380, 580 ] 6 0.001% 100.027% ( 580, 870 ] 15 0.002% 100.029% ( 870, 1300 ] 7 0.001% 100.030% ( 1300, 1900 ] 4 0.001% 100.030% ( 1900, 2900 ] 4 0.001% 100.031% ( 2900, 4400 ] 2 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 209571 Average: 2.8494 StdDev: 21.78 Min: 1 Median: 1.7349 Max: 7015 Percentiles: P50: 1.73 P75: 2.59 P99: 7.35 P99.9: 11.51 P99.99: 13.79 ------------------------------------------------------ [ 0, 1 ] 14826 7.074% 7.074% # ( 1, 2 ] 122413 58.411% 65.486% ############ ( 2, 3 ] 33881 16.167% 81.653% ### ( 3, 4 ] 17827 8.506% 90.159% ## ( 4, 6 ] 17634 8.414% 98.573% ## ( 6, 10 ] 2655 1.267% 99.840% ( 10, 15 ] 414 0.198% 100.038% ( 15, 22 ] 42 0.020% 100.058% ( 22, 34 ] 1 0.000% 100.058% ( 34, 51 ] 2 0.001% 100.059% ( 51, 76 ] 2 0.001% 100.060% ( 76, 110 ] 9 0.004% 100.064% ( 110, 170 ] 17 0.008% 100.073% ( 170, 250 ] 15 0.007% 100.080% ( 250, 380 ] 16 0.008% 100.087% ( 380, 580 ] 19 0.009% 100.096% ( 580, 870 ] 3 0.001% 100.098% ( 870, 1300 ] 4 0.002% 100.100% ( 1900, 2900 ] 4 0.002% 100.102% ( 2900, 4400 ] 1 0.000% 100.102% ( 6600, 9900 ] 1 0.000% 100.103% ** Level 2 read latency histogram (micros): Count: 124192 Average: 2.9566 StdDev: 33.35 Min: 1 Median: 1.4499 Max: 4294 Percentiles: P50: 1.45 P75: 1.88 P99: 7.21 P99.9: 200.26 P99.99: 2115.07 ------------------------------------------------------ [ 0, 1 ] 29905 24.080% 24.080% ##### ( 1, 2 ] 71546 57.609% 81.689% ############ ( 2, 3 ] 10434 8.402% 90.090% ## ( 3, 4 ] 5897 4.748% 94.839% # ( 4, 6 ] 4803 3.867% 98.706% # ( 6, 10 ] 1206 0.971% 99.677% ( 10, 15 ] 163 0.131% 99.808% ( 15, 22 ] 20 0.016% 99.824% ( 22, 34 ] 9 0.007% 99.832% ( 34, 51 ] 4 0.003% 99.835% ( 76, 110 ] 28 0.023% 99.857% ( 110, 170 ] 46 0.037% 99.895% ( 170, 250 ] 18 0.014% 99.909% ( 250, 380 ] 43 0.035% 99.944% ( 380, 580 ] 24 0.019% 99.963% ( 580, 870 ] 19 0.015% 99.978% ( 870, 1300 ] 9 0.007% 99.986% ( 1300, 1900 ] 3 0.002% 99.988% ( 1900, 2900 ] 12 0.010% 99.998% ( 2900, 4400 ] 3 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 255493 Average: 3.3502 StdDev: 35.00 Min: 0 Median: 1.5887 Max: 4679 Percentiles: P50: 1.59 P75: 2.00 P99: 8.96 P99.9: 210.01 P99.99: 781.86 ------------------------------------------------------ [ 0, 1 ] 35754 13.994% 13.994% ### ( 1, 2 ] 156268 61.163% 75.157% ############ ( 2, 3 ] 32003 12.526% 87.683% ### ( 3, 4 ] 14474 5.665% 93.349% # ( 4, 6 ] 11332 4.435% 97.784% # ( 6, 10 ] 4198 1.643% 99.427% ( 10, 15 ] 605 0.237% 99.664% ( 15, 22 ] 106 0.041% 99.705% ( 22, 34 ] 23 0.009% 99.714% ( 34, 51 ] 4 0.002% 99.716% ( 51, 76 ] 1 0.000% 99.716% ( 76, 110 ] 144 0.056% 99.773% ( 110, 170 ] 273 0.107% 99.879% ( 170, 250 ] 105 0.041% 99.921% ( 250, 380 ] 95 0.037% 99.958% ( 380, 580 ] 56 0.022% 99.980% ( 580, 870 ] 38 0.015% 99.995% ( 870, 1300 ] 15 0.006% 100.000% ( 1300, 1900 ] 6 0.002% 100.003% ( 1900, 2900 ] 10 0.004% 100.007% ( 2900, 4400 ] 11 0.004% 100.011% ( 4400, 6600 ] 2 0.001% 100.012% ** Level 4 read latency histogram (micros): Count: 315 Average: 154.2889 StdDev: 643.53 Min: 0 Median: 1.4115 Max: 5050 Percentiles: P50: 1.41 P75: 5.25 P99: 3968.75 P99.9: 5050.00 P99.99: 5050.00 ------------------------------------------------------ [ 0, 1 ] 118 37.460% 37.460% ####### ( 1, 2 ] 96 30.476% 67.937% ###### ( 2, 3 ] 15 4.762% 72.698% # ( 3, 4 ] 1 0.317% 73.016% ( 4, 6 ] 10 3.175% 76.190% # ( 6, 10 ] 33 10.476% 86.667% ## ( 10, 15 ] 16 5.079% 91.746% # ( 22, 34 ] 1 0.317% 92.063% ( 250, 380 ] 2 0.635% 92.698% ( 380, 580 ] 2 0.635% 93.333% ( 580, 870 ] 1 0.317% 93.651% ( 870, 1300 ] 9 2.857% 96.508% # ( 1300, 1900 ] 2 0.635% 97.143% ( 1900, 2900 ] 3 0.952% 98.095% ( 2900, 4400 ] 4 1.270% 99.365% ( 4400, 6600 ] 2 0.635% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 937.8167 StdDev: 1083.28 Min: 82 Median: 480.0000 Max: 4605 Percentiles: P50: 480.00 P75: 1177.14 P99: 4605.00 P99.9: 4605.00 P99.99: 4605.00 ------------------------------------------------------ ( 76, 110 ] 3 5.000% 5.000% # ( 110, 170 ] 11 18.333% 23.333% #### ( 170, 250 ] 7 11.667% 35.000% ## ( 250, 380 ] 5 8.333% 43.333% ## ( 380, 580 ] 8 13.333% 56.667% ### ( 580, 870 ] 6 10.000% 66.667% ## ( 870, 1300 ] 7 11.667% 78.333% ## ( 1900, 2900 ] 8 13.333% 91.667% ### ( 2900, 4400 ] 4 6.667% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 9.4 total, 3.3 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 314.27 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.202 H:M:S, 12.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 299.82 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.564 H:M:S, 17.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/06-04:29:44 ... thread 0: (1000000,4000000) ops and (335426.1,328804.4) ops/second in (2.981283,12.165286) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/13 2.46 GB 44.1 2.0 0.0 2.0 5.7 3.7 0.0 1.5 108.1 310.6 18.65 17.17 59 0.316 2046K 2222 0.0 0.0 L1 3/3 181.04 MB 0.0 1.0 1.0 0.0 1.0 1.0 0.2 1.0 230.4 229.9 4.39 4.24 2 2.194 1026K 2246 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 254.4 254.2 1.49 1.43 2 0.743 383K 216 0.0 0.0 L3 23/0 942.00 MB 0.9 1.9 0.7 1.2 1.9 0.7 0.4 2.6 221.8 221.4 8.87 8.07 6 1.479 1999K 4134 0.0 0.0 L4 174/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 161.6 161.7 1.39 1.01 1 1.389 227K 0 0.0 0.0 L5 1056/0 86.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1272/16 99.82 GB 0.0 5.5 2.1 3.3 9.1 5.8 3.3 2.5 160.9 269.3 34.79 31.93 70 0.497 5684K 8818 0.0 0.0 Int 0/0 0.00 KB 0.0 5.5 2.1 3.3 9.1 5.8 3.2 2.5 160.9 269.3 34.79 31.93 70 0.497 5684K 8818 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.5 2.1 3.3 5.5 2.1 0.0 0.0 233.6 233.2 23.96 22.38 18 1.331 5684K 8818 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 349.2 10.82 9.54 52 0.208 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.4 total, 12.2 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.15 GB write, 756.96 MB/s write, 5.47 GB read, 452.29 MB/s read, 34.8 seconds Interval compaction: 9.15 GB write, 769.94 MB/s write, 5.47 GB read, 460.04 MB/s read, 34.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: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 16, interval: 16 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1018709 Average: 2.2047 StdDev: 11.03 Min: 0 Median: 1.4731 Max: 3938 Percentiles: P50: 1.47 P75: 1.87 P99: 5.73 P99.9: 9.92 P99.99: 14.60 ------------------------------------------------------ [ 0, 1 ] 206439 20.265% 20.265% #### ( 1, 2 ] 640234 62.848% 83.112% ############# ( 2, 3 ] 91380 8.970% 92.083% ## ( 3, 4 ] 43998 4.319% 96.402% # ( 4, 6 ] 30612 3.005% 99.407% # ( 6, 10 ] 5128 0.503% 99.910% ( 10, 15 ] 887 0.087% 99.997% ( 15, 22 ] 96 0.009% 100.006% ( 22, 34 ] 8 0.001% 100.007% ( 34, 51 ] 7 0.001% 100.008% ( 51, 76 ] 8 0.001% 100.009% ( 76, 110 ] 42 0.004% 100.013% ( 110, 170 ] 67 0.007% 100.019% ( 170, 250 ] 30 0.003% 100.022% ( 250, 380 ] 32 0.003% 100.025% ( 380, 580 ] 18 0.002% 100.027% ( 580, 870 ] 20 0.002% 100.029% ( 870, 1300 ] 9 0.001% 100.030% ( 1300, 1900 ] 6 0.001% 100.031% ( 1900, 2900 ] 6 0.001% 100.031% ( 2900, 4400 ] 4 0.000% 100.032% ** Level 1 read latency histogram (micros): Count: 209572 Average: 2.8494 StdDev: 21.78 Min: 1 Median: 1.7349 Max: 7015 Percentiles: P50: 1.73 P75: 2.59 P99: 7.35 P99.9: 11.51 P99.99: 13.79 ------------------------------------------------------ [ 0, 1 ] 14826 7.074% 7.074% # ( 1, 2 ] 122413 58.411% 65.485% ############ ( 2, 3 ] 33881 16.167% 81.652% ### ( 3, 4 ] 17828 8.507% 90.159% ## ( 4, 6 ] 17634 8.414% 98.573% ## ( 6, 10 ] 2655 1.267% 99.840% ( 10, 15 ] 414 0.198% 100.038% ( 15, 22 ] 42 0.020% 100.058% ( 22, 34 ] 1 0.000% 100.058% ( 34, 51 ] 2 0.001% 100.059% ( 51, 76 ] 2 0.001% 100.060% ( 76, 110 ] 9 0.004% 100.064% ( 110, 170 ] 17 0.008% 100.073% ( 170, 250 ] 15 0.007% 100.080% ( 250, 380 ] 16 0.008% 100.087% ( 380, 580 ] 19 0.009% 100.096% ( 580, 870 ] 3 0.001% 100.098% ( 870, 1300 ] 4 0.002% 100.100% ( 1900, 2900 ] 4 0.002% 100.102% ( 2900, 4400 ] 1 0.000% 100.102% ( 6600, 9900 ] 1 0.000% 100.103% ** Level 2 read latency histogram (micros): Count: 124192 Average: 2.9566 StdDev: 33.35 Min: 1 Median: 1.4499 Max: 4294 Percentiles: P50: 1.45 P75: 1.88 P99: 7.21 P99.9: 200.26 P99.99: 2115.07 ------------------------------------------------------ [ 0, 1 ] 29905 24.080% 24.080% ##### ( 1, 2 ] 71546 57.609% 81.689% ############ ( 2, 3 ] 10434 8.402% 90.090% ## ( 3, 4 ] 5897 4.748% 94.839% # ( 4, 6 ] 4803 3.867% 98.706% # ( 6, 10 ] 1206 0.971% 99.677% ( 10, 15 ] 163 0.131% 99.808% ( 15, 22 ] 20 0.016% 99.824% ( 22, 34 ] 9 0.007% 99.832% ( 34, 51 ] 4 0.003% 99.835% ( 76, 110 ] 28 0.023% 99.857% ( 110, 170 ] 46 0.037% 99.895% ( 170, 250 ] 18 0.014% 99.909% ( 250, 380 ] 43 0.035% 99.944% ( 380, 580 ] 24 0.019% 99.963% ( 580, 870 ] 19 0.015% 99.978% ( 870, 1300 ] 9 0.007% 99.986% ( 1300, 1900 ] 3 0.002% 99.988% ( 1900, 2900 ] 12 0.010% 99.998% ( 2900, 4400 ] 3 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 255493 Average: 3.3502 StdDev: 35.00 Min: 0 Median: 1.5887 Max: 4679 Percentiles: P50: 1.59 P75: 2.00 P99: 8.96 P99.9: 210.01 P99.99: 781.86 ------------------------------------------------------ [ 0, 1 ] 35754 13.994% 13.994% ### ( 1, 2 ] 156268 61.163% 75.157% ############ ( 2, 3 ] 32003 12.526% 87.683% ### ( 3, 4 ] 14474 5.665% 93.349% # ( 4, 6 ] 11332 4.435% 97.784% # ( 6, 10 ] 4198 1.643% 99.427% ( 10, 15 ] 605 0.237% 99.664% ( 15, 22 ] 106 0.041% 99.705% ( 22, 34 ] 23 0.009% 99.714% ( 34, 51 ] 4 0.002% 99.716% ( 51, 76 ] 1 0.000% 99.716% ( 76, 110 ] 144 0.056% 99.773% ( 110, 170 ] 273 0.107% 99.879% ( 170, 250 ] 105 0.041% 99.921% ( 250, 380 ] 95 0.037% 99.958% ( 380, 580 ] 56 0.022% 99.980% ( 580, 870 ] 38 0.015% 99.995% ( 870, 1300 ] 15 0.006% 100.000% ( 1300, 1900 ] 6 0.002% 100.003% ( 1900, 2900 ] 10 0.004% 100.007% ( 2900, 4400 ] 11 0.004% 100.011% ( 4400, 6600 ] 2 0.001% 100.012% ** Level 4 read latency histogram (micros): Count: 315 Average: 154.2889 StdDev: 643.53 Min: 0 Median: 1.4115 Max: 5050 Percentiles: P50: 1.41 P75: 5.25 P99: 3968.75 P99.9: 5050.00 P99.99: 5050.00 ------------------------------------------------------ [ 0, 1 ] 118 37.460% 37.460% ####### ( 1, 2 ] 96 30.476% 67.937% ###### ( 2, 3 ] 15 4.762% 72.698% # ( 3, 4 ] 1 0.317% 73.016% ( 4, 6 ] 10 3.175% 76.190% # ( 6, 10 ] 33 10.476% 86.667% ## ( 10, 15 ] 16 5.079% 91.746% # ( 22, 34 ] 1 0.317% 92.063% ( 250, 380 ] 2 0.635% 92.698% ( 380, 580 ] 2 0.635% 93.333% ( 580, 870 ] 1 0.317% 93.651% ( 870, 1300 ] 9 2.857% 96.508% # ( 1300, 1900 ] 2 0.635% 97.143% ( 1900, 2900 ] 3 0.952% 98.095% ( 2900, 4400 ] 4 1.270% 99.365% ( 4400, 6600 ] 2 0.635% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 937.8167 StdDev: 1083.28 Min: 82 Median: 480.0000 Max: 4605 Percentiles: P50: 480.00 P75: 1177.14 P99: 4605.00 P99.9: 4605.00 P99.99: 4605.00 ------------------------------------------------------ ( 76, 110 ] 3 5.000% 5.000% # ( 110, 170 ] 11 18.333% 23.333% #### ( 170, 250 ] 7 11.667% 35.000% ## ( 250, 380 ] 5 8.333% 43.333% ## ( 380, 580 ] 8 13.333% 56.667% ### ( 580, 870 ] 6 10.000% 66.667% ## ( 870, 1300 ] 7 11.667% 78.333% ## ( 1900, 2900 ] 8 13.333% 91.667% ### ( 2900, 4400 ] 4 6.667% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 12.4 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 318.09 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.596 H:M:S, 12.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 330.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.394 H:M:S, 13.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/06-04:29:48 ... thread 0: (1000000,5000000) ops and (274886.0,316392.5) ops/second in (3.637872,15.803158) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/13 3.44 GB 151.0 3.1 0.0 3.1 7.8 4.7 0.0 1.7 123.7 307.9 25.97 24.12 77 0.337 3262K 3591 0.0 0.0 L1 3/3 181.04 MB 0.0 1.0 1.0 0.0 1.0 1.0 0.2 1.0 230.4 229.9 4.39 4.24 2 2.194 1026K 2246 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 254.4 254.2 1.49 1.43 2 0.743 383K 216 0.0 0.0 L3 23/0 942.00 MB 0.9 1.9 0.7 1.2 1.9 0.7 0.4 2.6 221.8 221.4 8.87 8.07 6 1.479 1999K 4134 0.0 0.0 L4 174/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 161.6 161.7 1.39 1.01 1 1.389 227K 0 0.0 0.0 L5 1056/0 86.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1274/16 100.80 GB 0.0 6.6 2.1 4.5 11.3 6.8 3.3 2.4 161.4 274.8 42.11 38.87 88 0.479 6899K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.6 2.1 4.5 11.3 6.8 3.2 2.4 161.4 274.8 42.11 38.87 88 0.479 6899K 10K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.6 2.1 4.5 6.6 2.1 0.0 0.0 238.7 238.3 28.46 26.80 22 1.294 6899K 10K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 350.9 13.65 12.07 66 0.207 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 16.0 total, 15.8 interval Flush(GB): cumulative 4.675, interval 4.675 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.30 GB write, 722.60 MB/s write, 6.64 GB read, 424.29 MB/s read, 42.1 seconds Interval compaction: 11.30 GB write, 732.13 MB/s write, 6.64 GB read, 429.88 MB/s read, 42.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: 18, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 4, total-stops: 18, interval: 22 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1516034 Average: 2.2013 StdDev: 10.59 Min: 0 Median: 1.4748 Max: 3938 Percentiles: P50: 1.47 P75: 1.86 P99: 5.70 P99.9: 9.81 P99.99: 14.30 ------------------------------------------------------ [ 0, 1 ] 295195 19.472% 19.472% #### ( 1, 2 ] 974872 64.304% 83.776% ############# ( 2, 3 ] 133416 8.800% 92.576% ## ( 3, 4 ] 62365 4.114% 96.690% # ( 4, 6 ] 41160 2.715% 99.405% # ( 6, 10 ] 7886 0.520% 99.925% ( 10, 15 ] 1150 0.076% 100.001% ( 15, 22 ] 123 0.008% 100.009% ( 22, 34 ] 14 0.001% 100.010% ( 34, 51 ] 8 0.001% 100.010% ( 51, 76 ] 12 0.001% 100.011% ( 76, 110 ] 62 0.004% 100.015% ( 110, 170 ] 104 0.007% 100.022% ( 170, 250 ] 63 0.004% 100.026% ( 250, 380 ] 55 0.004% 100.030% ( 380, 580 ] 30 0.002% 100.032% ( 580, 870 ] 31 0.002% 100.034% ( 870, 1300 ] 17 0.001% 100.035% ( 1300, 1900 ] 9 0.001% 100.035% ( 1900, 2900 ] 8 0.001% 100.036% ( 2900, 4400 ] 5 0.000% 100.036% ** Level 1 read latency histogram (micros): Count: 218108 Average: 2.8796 StdDev: 21.70 Min: 1 Median: 1.7268 Max: 7015 Percentiles: P50: 1.73 P75: 2.56 P99: 7.45 P99.9: 12.21 P99.99: 14.55 ------------------------------------------------------ [ 0, 1 ] 15913 7.296% 7.296% # ( 1, 2 ] 128150 58.755% 66.051% ############ ( 2, 3 ] 34765 15.939% 81.991% ### ( 3, 4 ] 18197 8.343% 90.334% ## ( 4, 6 ] 17888 8.201% 98.535% ## ( 6, 10 ] 2791 1.280% 99.815% ( 10, 15 ] 420 0.193% 100.007% ( 15, 22 ] 42 0.019% 100.027% ( 22, 34 ] 1 0.000% 100.027% ( 34, 51 ] 2 0.001% 100.028% ( 51, 76 ] 2 0.001% 100.029% ( 76, 110 ] 25 0.011% 100.040% ( 110, 170 ] 42 0.019% 100.060% ( 170, 250 ] 26 0.012% 100.072% ( 250, 380 ] 22 0.010% 100.082% ( 380, 580 ] 23 0.011% 100.092% ( 580, 870 ] 4 0.002% 100.094% ( 870, 1300 ] 4 0.002% 100.096% ( 1900, 2900 ] 4 0.002% 100.098% ( 2900, 4400 ] 1 0.000% 100.098% ( 6600, 9900 ] 1 0.000% 100.099% ** Level 2 read latency histogram (micros): Count: 124192 Average: 2.9566 StdDev: 33.35 Min: 1 Median: 1.4499 Max: 4294 Percentiles: P50: 1.45 P75: 1.88 P99: 7.21 P99.9: 200.26 P99.99: 2115.07 ------------------------------------------------------ [ 0, 1 ] 29905 24.080% 24.080% ##### ( 1, 2 ] 71546 57.609% 81.689% ############ ( 2, 3 ] 10434 8.402% 90.090% ## ( 3, 4 ] 5897 4.748% 94.839% # ( 4, 6 ] 4803 3.867% 98.706% # ( 6, 10 ] 1206 0.971% 99.677% ( 10, 15 ] 163 0.131% 99.808% ( 15, 22 ] 20 0.016% 99.824% ( 22, 34 ] 9 0.007% 99.832% ( 34, 51 ] 4 0.003% 99.835% ( 76, 110 ] 28 0.023% 99.857% ( 110, 170 ] 46 0.037% 99.895% ( 170, 250 ] 18 0.014% 99.909% ( 250, 380 ] 43 0.035% 99.944% ( 380, 580 ] 24 0.019% 99.963% ( 580, 870 ] 19 0.015% 99.978% ( 870, 1300 ] 9 0.007% 99.986% ( 1300, 1900 ] 3 0.002% 99.988% ( 1900, 2900 ] 12 0.010% 99.998% ( 2900, 4400 ] 3 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 255493 Average: 3.3502 StdDev: 35.00 Min: 0 Median: 1.5887 Max: 4679 Percentiles: P50: 1.59 P75: 2.00 P99: 8.96 P99.9: 210.01 P99.99: 781.86 ------------------------------------------------------ [ 0, 1 ] 35754 13.994% 13.994% ### ( 1, 2 ] 156268 61.163% 75.157% ############ ( 2, 3 ] 32003 12.526% 87.683% ### ( 3, 4 ] 14474 5.665% 93.349% # ( 4, 6 ] 11332 4.435% 97.784% # ( 6, 10 ] 4198 1.643% 99.427% ( 10, 15 ] 605 0.237% 99.664% ( 15, 22 ] 106 0.041% 99.705% ( 22, 34 ] 23 0.009% 99.714% ( 34, 51 ] 4 0.002% 99.716% ( 51, 76 ] 1 0.000% 99.716% ( 76, 110 ] 144 0.056% 99.773% ( 110, 170 ] 273 0.107% 99.879% ( 170, 250 ] 105 0.041% 99.921% ( 250, 380 ] 95 0.037% 99.958% ( 380, 580 ] 56 0.022% 99.980% ( 580, 870 ] 38 0.015% 99.995% ( 870, 1300 ] 15 0.006% 100.000% ( 1300, 1900 ] 6 0.002% 100.003% ( 1900, 2900 ] 10 0.004% 100.007% ( 2900, 4400 ] 11 0.004% 100.011% ( 4400, 6600 ] 2 0.001% 100.012% ** Level 4 read latency histogram (micros): Count: 315 Average: 154.2889 StdDev: 643.53 Min: 0 Median: 1.4115 Max: 5050 Percentiles: P50: 1.41 P75: 5.25 P99: 3968.75 P99.9: 5050.00 P99.99: 5050.00 ------------------------------------------------------ [ 0, 1 ] 118 37.460% 37.460% ####### ( 1, 2 ] 96 30.476% 67.937% ###### ( 2, 3 ] 15 4.762% 72.698% # ( 3, 4 ] 1 0.317% 73.016% ( 4, 6 ] 10 3.175% 76.190% # ( 6, 10 ] 33 10.476% 86.667% ## ( 10, 15 ] 16 5.079% 91.746% # ( 22, 34 ] 1 0.317% 92.063% ( 250, 380 ] 2 0.635% 92.698% ( 380, 580 ] 2 0.635% 93.333% ( 580, 870 ] 1 0.317% 93.651% ( 870, 1300 ] 9 2.857% 96.508% # ( 1300, 1900 ] 2 0.635% 97.143% ( 1900, 2900 ] 3 0.952% 98.095% ( 2900, 4400 ] 4 1.270% 99.365% ( 4400, 6600 ] 2 0.635% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 937.8167 StdDev: 1083.28 Min: 82 Median: 480.0000 Max: 4605 Percentiles: P50: 480.00 P75: 1177.14 P99: 4605.00 P99.9: 4605.00 P99.99: 4605.00 ------------------------------------------------------ ( 76, 110 ] 3 5.000% 5.000% # ( 110, 170 ] 11 18.333% 23.333% #### ( 170, 250 ] 7 11.667% 35.000% ## ( 250, 380 ] 5 8.333% 43.333% ## ( 380, 580 ] 8 13.333% 56.667% ### ( 580, 870 ] 6 10.000% 66.667% ## ( 870, 1300 ] 7 11.667% 78.333% ## ( 1900, 2900 ] 8 13.333% 91.667% ### ( 2900, 4400 ] 4 6.667% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 16.0 total, 3.6 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 307.29 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.618 H:M:S, 16.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 270.55 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.022 H:M:S, 28.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/06-04:29:52 ... thread 0: (1000000,6000000) ops and (246984.7,302236.7) ops/second in (4.048834,19.851992) 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 15/15 2.70 GB 0.0 3.9 0.0 3.9 9.5 5.7 0.0 1.7 125.6 308.9 31.59 29.39 95 0.333 4029K 4365 0.0 0.0 L1 20/20 1.88 GB 0.0 2.9 2.7 0.2 2.9 2.7 0.2 1.1 227.9 226.4 12.96 12.46 3 4.321 2999K 19K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 254.4 254.2 1.49 1.43 2 0.743 383K 216 0.0 0.0 L3 23/0 942.00 MB 0.9 1.9 0.7 1.2 1.9 0.7 0.4 2.6 221.8 221.4 8.87 8.07 6 1.479 1999K 4134 0.0 0.0 L4 174/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 161.6 161.7 1.39 1.01 1 1.389 227K 0 0.0 0.0 L5 1056/0 86.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1288/35 101.77 GB 0.0 9.3 3.8 5.4 14.9 9.5 3.3 2.6 168.6 271.1 56.30 52.37 107 0.526 9640K 28K 0.0 0.0 Int 0/0 0.00 KB 0.0 9.3 3.8 5.4 14.9 9.5 3.2 2.6 168.6 271.1 56.30 52.37 107 0.526 9640K 28K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 9.3 3.8 5.4 9.2 3.8 0.0 0.0 238.2 237.4 39.86 37.79 26 1.533 9640K 28K 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 352.6 16.44 14.58 81 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 20.1 total, 19.9 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 14.90 GB write, 760.65 MB/s write, 9.27 GB read, 473.20 MB/s read, 56.3 seconds Interval compaction: 14.90 GB write, 768.64 MB/s write, 9.27 GB read, 478.17 MB/s read, 56.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 19, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 10, total-stops: 19, interval: 29 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1813573 Average: 2.2165 StdDev: 11.92 Min: 0 Median: 1.4573 Max: 3938 Percentiles: P50: 1.46 P75: 1.85 P99: 5.71 P99.9: 9.98 P99.99: 85.00 ------------------------------------------------------ [ 0, 1 ] 375542 20.707% 20.707% #### ( 1, 2 ] 1161744 64.058% 84.766% ############# ( 2, 3 ] 149980 8.270% 93.035% ## ( 3, 4 ] 69706 3.844% 96.879% # ( 4, 6 ] 44874 2.474% 99.353% ( 6, 10 ] 9957 0.549% 99.902% ( 10, 15 ] 1327 0.073% 99.976% ( 15, 22 ] 164 0.009% 99.985% ( 22, 34 ] 22 0.001% 99.986% ( 34, 51 ] 11 0.001% 99.986% ( 51, 76 ] 13 0.001% 99.987% ( 76, 110 ] 195 0.011% 99.998% ( 110, 170 ] 263 0.015% 100.012% ( 170, 250 ] 109 0.006% 100.018% ( 250, 380 ] 97 0.005% 100.024% ( 380, 580 ] 59 0.003% 100.027% ( 580, 870 ] 48 0.003% 100.030% ( 870, 1300 ] 24 0.001% 100.031% ( 1300, 1900 ] 11 0.001% 100.032% ( 1900, 2900 ] 12 0.001% 100.032% ( 2900, 4400 ] 7 0.000% 100.033% ** Level 1 read latency histogram (micros): Count: 277610 Average: 2.8531 StdDev: 23.05 Min: 1 Median: 1.6453 Max: 7015 Percentiles: P50: 1.65 P75: 2.29 P99: 7.62 P99.9: 13.86 P99.99: 106.43 ------------------------------------------------------ [ 0, 1 ] 32471 11.697% 11.697% ## ( 1, 2 ] 164774 59.354% 71.051% ############ ( 2, 3 ] 37659 13.565% 84.617% ### ( 3, 4 ] 19762 7.119% 91.735% # ( 4, 6 ] 18704 6.738% 98.473% # ( 6, 10 ] 3607 1.299% 99.772% ( 10, 15 ] 460 0.166% 99.938% ( 15, 22 ] 54 0.019% 99.957% ( 22, 34 ] 3 0.001% 99.958% ( 34, 51 ] 3 0.001% 99.959% ( 51, 76 ] 2 0.001% 99.960% ( 76, 110 ] 93 0.034% 99.994% ( 110, 170 ] 84 0.030% 100.024% ( 170, 250 ] 40 0.014% 100.038% ( 250, 380 ] 40 0.014% 100.053% ( 380, 580 ] 39 0.014% 100.067% ( 580, 870 ] 10 0.004% 100.070% ( 870, 1300 ] 10 0.004% 100.074% ( 1300, 1900 ] 2 0.001% 100.075% ( 1900, 2900 ] 5 0.002% 100.076% ( 2900, 4400 ] 2 0.001% 100.077% ( 6600, 9900 ] 1 0.000% 100.077% ** Level 2 read latency histogram (micros): Count: 124192 Average: 2.9566 StdDev: 33.35 Min: 1 Median: 1.4499 Max: 4294 Percentiles: P50: 1.45 P75: 1.88 P99: 7.21 P99.9: 200.26 P99.99: 2115.07 ------------------------------------------------------ [ 0, 1 ] 29905 24.080% 24.080% ##### ( 1, 2 ] 71546 57.609% 81.689% ############ ( 2, 3 ] 10434 8.402% 90.090% ## ( 3, 4 ] 5897 4.748% 94.839% # ( 4, 6 ] 4803 3.867% 98.706% # ( 6, 10 ] 1206 0.971% 99.677% ( 10, 15 ] 163 0.131% 99.808% ( 15, 22 ] 20 0.016% 99.824% ( 22, 34 ] 9 0.007% 99.832% ( 34, 51 ] 4 0.003% 99.835% ( 76, 110 ] 28 0.023% 99.857% ( 110, 170 ] 46 0.037% 99.895% ( 170, 250 ] 18 0.014% 99.909% ( 250, 380 ] 43 0.035% 99.944% ( 380, 580 ] 24 0.019% 99.963% ( 580, 870 ] 19 0.015% 99.978% ( 870, 1300 ] 9 0.007% 99.986% ( 1300, 1900 ] 3 0.002% 99.988% ( 1900, 2900 ] 12 0.010% 99.998% ( 2900, 4400 ] 3 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 255493 Average: 3.3502 StdDev: 35.00 Min: 0 Median: 1.5887 Max: 4679 Percentiles: P50: 1.59 P75: 2.00 P99: 8.96 P99.9: 210.01 P99.99: 781.86 ------------------------------------------------------ [ 0, 1 ] 35754 13.994% 13.994% ### ( 1, 2 ] 156268 61.163% 75.157% ############ ( 2, 3 ] 32003 12.526% 87.683% ### ( 3, 4 ] 14474 5.665% 93.349% # ( 4, 6 ] 11332 4.435% 97.784% # ( 6, 10 ] 4198 1.643% 99.427% ( 10, 15 ] 605 0.237% 99.664% ( 15, 22 ] 106 0.041% 99.705% ( 22, 34 ] 23 0.009% 99.714% ( 34, 51 ] 4 0.002% 99.716% ( 51, 76 ] 1 0.000% 99.716% ( 76, 110 ] 144 0.056% 99.773% ( 110, 170 ] 273 0.107% 99.879% ( 170, 250 ] 105 0.041% 99.921% ( 250, 380 ] 95 0.037% 99.958% ( 380, 580 ] 56 0.022% 99.980% ( 580, 870 ] 38 0.015% 99.995% ( 870, 1300 ] 15 0.006% 100.000% ( 1300, 1900 ] 6 0.002% 100.003% ( 1900, 2900 ] 10 0.004% 100.007% ( 2900, 4400 ] 11 0.004% 100.011% ( 4400, 6600 ] 2 0.001% 100.012% ** Level 4 read latency histogram (micros): Count: 315 Average: 154.2889 StdDev: 643.53 Min: 0 Median: 1.4115 Max: 5050 Percentiles: P50: 1.41 P75: 5.25 P99: 3968.75 P99.9: 5050.00 P99.99: 5050.00 ------------------------------------------------------ [ 0, 1 ] 118 37.460% 37.460% ####### ( 1, 2 ] 96 30.476% 67.937% ###### ( 2, 3 ] 15 4.762% 72.698% # ( 3, 4 ] 1 0.317% 73.016% ( 4, 6 ] 10 3.175% 76.190% # ( 6, 10 ] 33 10.476% 86.667% ## ( 10, 15 ] 16 5.079% 91.746% # ( 22, 34 ] 1 0.317% 92.063% ( 250, 380 ] 2 0.635% 92.698% ( 380, 580 ] 2 0.635% 93.333% ( 580, 870 ] 1 0.317% 93.651% ( 870, 1300 ] 9 2.857% 96.508% # ( 1300, 1900 ] 2 0.635% 97.143% ( 1900, 2900 ] 3 0.952% 98.095% ( 2900, 4400 ] 4 1.270% 99.365% ( 4400, 6600 ] 2 0.635% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 937.8167 StdDev: 1083.28 Min: 82 Median: 480.0000 Max: 4605 Percentiles: P50: 480.00 P75: 1177.14 P99: 4605.00 P99.9: 4605.00 P99.99: 4605.00 ------------------------------------------------------ ( 76, 110 ] 3 5.000% 5.000% # ( 110, 170 ] 11 18.333% 23.333% #### ( 170, 250 ] 7 11.667% 35.000% ## ( 250, 380 ] 5 8.333% 43.333% ## ( 380, 580 ] 8 13.333% 56.667% ### ( 580, 870 ] 6 10.000% 66.667% ## ( 870, 1300 ] 7 11.667% 78.333% ## ( 1900, 2900 ] 8 13.333% 91.667% ### ( 2900, 4400 ] 4 6.667% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 20.1 total, 4.0 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 294.33 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:4.091 H:M:S, 20.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 243.08 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.473 H:M:S, 36.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/06-04:29:55 ... thread 0: (1000000,7000000) ops and (279538.2,298770.9) ops/second in (3.577328,23.429320) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/15 3.69 GB 107.0 4.9 0.0 4.9 11.6 6.6 0.0 1.7 131.0 307.6 38.49 35.88 115 0.335 5117K 5446 0.0 0.0 L1 20/20 1.88 GB 0.0 2.9 2.7 0.2 2.9 2.7 0.2 1.1 227.9 226.4 12.96 12.46 3 4.321 2999K 19K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 254.4 254.2 1.49 1.43 2 0.743 383K 216 0.0 0.0 L3 23/0 942.00 MB 0.9 1.9 0.7 1.2 1.9 0.7 0.4 2.6 221.8 221.4 8.87 8.07 6 1.479 1999K 4134 0.0 0.0 L4 174/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 161.6 161.7 1.39 1.01 1 1.389 227K 0 0.0 0.0 L5 1056/0 86.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1292/35 102.75 GB 0.0 10.3 3.8 6.5 16.9 10.5 3.3 2.5 167.2 274.4 63.20 58.86 127 0.498 10M 29K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.3 3.8 6.5 16.9 10.5 3.2 2.5 167.2 274.4 63.20 58.86 127 0.498 10M 29K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 10.3 3.8 6.5 10.3 3.8 0.0 0.0 240.7 240.0 43.89 41.73 30 1.463 10M 29K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.6 6.6 0.0 0.0 0.0 352.4 19.30 17.13 97 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 23.6 total, 23.4 interval Flush(GB): cumulative 6.644, interval 6.644 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 16.93 GB write, 733.44 MB/s write, 10.32 GB read, 446.90 MB/s read, 63.2 seconds Interval compaction: 16.93 GB write, 739.97 MB/s write, 10.32 GB read, 450.88 MB/s read, 63.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 17, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 17, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 19, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 19, interval: 36 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2196201 Average: 2.2100 StdDev: 11.48 Min: 0 Median: 1.4601 Max: 3938 Percentiles: P50: 1.46 P75: 1.85 P99: 5.70 P99.9: 9.96 P99.99: 79.27 ------------------------------------------------------ [ 0, 1 ] 446181 20.316% 20.316% #### ( 1, 2 ] 1416788 64.511% 84.827% ############# ( 2, 3 ] 182880 8.327% 93.154% ## ( 3, 4 ] 83370 3.796% 96.950% # ( 4, 6 ] 52937 2.410% 99.360% ( 6, 10 ] 11978 0.545% 99.906% ( 10, 15 ] 1595 0.073% 99.979% ( 15, 22 ] 182 0.008% 99.987% ( 22, 34 ] 22 0.001% 99.988% ( 34, 51 ] 12 0.001% 99.988% ( 51, 76 ] 15 0.001% 99.989% ( 76, 110 ] 233 0.011% 100.000% ( 110, 170 ] 284 0.013% 100.013% ( 170, 250 ] 132 0.006% 100.019% ( 250, 380 ] 110 0.005% 100.024% ( 380, 580 ] 68 0.003% 100.027% ( 580, 870 ] 57 0.003% 100.029% ( 870, 1300 ] 30 0.001% 100.031% ( 1300, 1900 ] 12 0.001% 100.031% ( 1900, 2900 ] 14 0.001% 100.032% ( 2900, 4400 ] 7 0.000% 100.032% ** Level 1 read latency histogram (micros): Count: 362746 Average: 2.7902 StdDev: 20.82 Min: 1 Median: 1.6107 Max: 7015 Percentiles: P50: 1.61 P75: 2.09 P99: 7.82 P99.9: 15.88 P99.99: 148.88 ------------------------------------------------------ [ 0, 1 ] 45733 12.607% 12.607% ### ( 1, 2 ] 222123 61.234% 73.841% ############ ( 2, 3 ] 45631 12.579% 86.421% ### ( 3, 4 ] 22754 6.273% 92.693% # ( 4, 6 ] 20618 5.684% 98.377% # ( 6, 10 ] 4965 1.369% 99.746% ( 10, 15 ] 552 0.152% 99.898% ( 15, 22 ] 58 0.016% 99.914% ( 22, 34 ] 3 0.001% 99.915% ( 34, 51 ] 4 0.001% 99.916% ( 51, 76 ] 2 0.001% 99.916% ( 76, 110 ] 176 0.049% 99.965% ( 110, 170 ] 140 0.039% 100.004% ( 170, 250 ] 65 0.018% 100.022% ( 250, 380 ] 49 0.014% 100.035% ( 380, 580 ] 51 0.014% 100.049% ( 580, 870 ] 17 0.005% 100.054% ( 870, 1300 ] 10 0.003% 100.057% ( 1300, 1900 ] 2 0.001% 100.057% ( 1900, 2900 ] 5 0.001% 100.058% ( 2900, 4400 ] 2 0.001% 100.059% ( 6600, 9900 ] 1 0.000% 100.059% ** Level 2 read latency histogram (micros): Count: 124192 Average: 2.9566 StdDev: 33.35 Min: 1 Median: 1.4499 Max: 4294 Percentiles: P50: 1.45 P75: 1.88 P99: 7.21 P99.9: 200.26 P99.99: 2115.07 ------------------------------------------------------ [ 0, 1 ] 29905 24.080% 24.080% ##### ( 1, 2 ] 71546 57.609% 81.689% ############ ( 2, 3 ] 10434 8.402% 90.090% ## ( 3, 4 ] 5897 4.748% 94.839% # ( 4, 6 ] 4803 3.867% 98.706% # ( 6, 10 ] 1206 0.971% 99.677% ( 10, 15 ] 163 0.131% 99.808% ( 15, 22 ] 20 0.016% 99.824% ( 22, 34 ] 9 0.007% 99.832% ( 34, 51 ] 4 0.003% 99.835% ( 76, 110 ] 28 0.023% 99.857% ( 110, 170 ] 46 0.037% 99.895% ( 170, 250 ] 18 0.014% 99.909% ( 250, 380 ] 43 0.035% 99.944% ( 380, 580 ] 24 0.019% 99.963% ( 580, 870 ] 19 0.015% 99.978% ( 870, 1300 ] 9 0.007% 99.986% ( 1300, 1900 ] 3 0.002% 99.988% ( 1900, 2900 ] 12 0.010% 99.998% ( 2900, 4400 ] 3 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 255493 Average: 3.3502 StdDev: 35.00 Min: 0 Median: 1.5887 Max: 4679 Percentiles: P50: 1.59 P75: 2.00 P99: 8.96 P99.9: 210.01 P99.99: 781.86 ------------------------------------------------------ [ 0, 1 ] 35754 13.994% 13.994% ### ( 1, 2 ] 156268 61.163% 75.157% ############ ( 2, 3 ] 32003 12.526% 87.683% ### ( 3, 4 ] 14474 5.665% 93.349% # ( 4, 6 ] 11332 4.435% 97.784% # ( 6, 10 ] 4198 1.643% 99.427% ( 10, 15 ] 605 0.237% 99.664% ( 15, 22 ] 106 0.041% 99.705% ( 22, 34 ] 23 0.009% 99.714% ( 34, 51 ] 4 0.002% 99.716% ( 51, 76 ] 1 0.000% 99.716% ( 76, 110 ] 144 0.056% 99.773% ( 110, 170 ] 273 0.107% 99.879% ( 170, 250 ] 105 0.041% 99.921% ( 250, 380 ] 95 0.037% 99.958% ( 380, 580 ] 56 0.022% 99.980% ( 580, 870 ] 38 0.015% 99.995% ( 870, 1300 ] 15 0.006% 100.000% ( 1300, 1900 ] 6 0.002% 100.003% ( 1900, 2900 ] 10 0.004% 100.007% ( 2900, 4400 ] 11 0.004% 100.011% ( 4400, 6600 ] 2 0.001% 100.012% ** Level 4 read latency histogram (micros): Count: 315 Average: 154.2889 StdDev: 643.53 Min: 0 Median: 1.4115 Max: 5050 Percentiles: P50: 1.41 P75: 5.25 P99: 3968.75 P99.9: 5050.00 P99.99: 5050.00 ------------------------------------------------------ [ 0, 1 ] 118 37.460% 37.460% ####### ( 1, 2 ] 96 30.476% 67.937% ###### ( 2, 3 ] 15 4.762% 72.698% # ( 3, 4 ] 1 0.317% 73.016% ( 4, 6 ] 10 3.175% 76.190% # ( 6, 10 ] 33 10.476% 86.667% ## ( 10, 15 ] 16 5.079% 91.746% # ( 22, 34 ] 1 0.317% 92.063% ( 250, 380 ] 2 0.635% 92.698% ( 380, 580 ] 2 0.635% 93.333% ( 580, 870 ] 1 0.317% 93.651% ( 870, 1300 ] 9 2.857% 96.508% # ( 1300, 1900 ] 2 0.635% 97.143% ( 1900, 2900 ] 3 0.952% 98.095% ( 2900, 4400 ] 4 1.270% 99.365% ( 4400, 6600 ] 2 0.635% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 937.8167 StdDev: 1083.28 Min: 82 Median: 480.0000 Max: 4605 Percentiles: P50: 480.00 P75: 1177.14 P99: 4605.00 P99.9: 4605.00 P99.99: 4605.00 ------------------------------------------------------ ( 76, 110 ] 3 5.000% 5.000% # ( 110, 170 ] 11 18.333% 23.333% #### ( 170, 250 ] 7 11.667% 35.000% ## ( 250, 380 ] 5 8.333% 43.333% ## ( 380, 580 ] 8 13.333% 56.667% ### ( 580, 870 ] 6 10.000% 66.667% ## ( 870, 1300 ] 7 11.667% 78.333% ## ( 1900, 2900 ] 8 13.333% 91.667% ### ( 2900, 4400 ] 4 6.667% 98.333% # ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 23.6 total, 3.6 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 291.42 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:4.988 H:M:S, 21.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 275.12 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.897 H:M:S, 25.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/06-04:30:16 ... thread 0: (1000000,8000000) ops and (47971.5,180688.8) ops/second in (20.845709,44.275029) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/7 2.21 GB 6.3 7.0 0.0 7.0 14.5 7.6 0.0 1.9 143.2 298.9 49.69 45.87 133 0.374 7226K 13K 0.0 0.0 L1 18/18 1.76 GB 0.0 7.2 5.1 2.1 7.1 5.0 0.2 1.4 224.2 221.3 32.72 31.01 4 8.179 7447K 94K 0.0 0.0 L2 1/1 128.78 MB 0.0 0.4 0.2 0.2 0.4 0.2 3.3 2.0 254.4 254.2 1.49 1.43 2 0.743 383K 216 0.0 0.0 L3 23/2 1.11 GB 1.0 5.2 3.1 2.1 5.1 3.0 0.4 1.7 156.0 155.2 33.81 23.47 18 1.878 5358K 28K 0.0 0.0 L4 178/0 9.65 GB 1.0 2.3 2.2 0.1 2.3 2.2 0.8 1.0 141.1 140.8 16.86 11.20 27 0.624 2376K 3245 0.0 0.0 L5 1080/0 88.71 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1308/28 103.56 GB 0.0 22.0 10.6 11.4 29.4 18.0 7.8 3.9 167.1 223.6 134.56 112.98 184 0.731 22M 140K 0.0 0.0 Int 0/0 0.00 KB 0.0 22.0 10.6 11.4 29.4 18.0 7.7 3.9 167.1 223.6 134.56 112.98 184 0.731 22M 140K 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 22.0 10.6 11.4 21.8 10.4 0.0 0.0 201.2 200.0 111.72 93.37 73 1.530 22M 140K 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 339.2 22.84 19.61 111 0.206 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 44.5 total, 44.3 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 29.38 GB write, 676.37 MB/s write, 21.96 GB read, 505.40 MB/s read, 134.6 seconds Interval compaction: 29.38 GB write, 679.56 MB/s write, 21.96 GB read, 507.78 MB/s read, 134.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 23, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 23, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 30, pending-compaction-bytes-delays: 28, pending-compaction-bytes-stops: 0, total-delays: 51, total-stops: 30, interval: 81 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3420171 Average: 2.6220 StdDev: 30.79 Min: 0 Median: 1.4647 Max: 7904 Percentiles: P50: 1.46 P75: 1.86 P99: 6.37 P99.9: 101.44 P99.99: 248.76 ------------------------------------------------------ [ 0, 1 ] 697946 20.407% 20.407% #### ( 1, 2 ] 2178177 63.686% 84.093% ############# ( 2, 3 ] 283749 8.296% 92.389% ## ( 3, 4 ] 129233 3.779% 96.168% # ( 4, 6 ] 94323 2.758% 98.926% # ( 6, 10 ] 27434 0.802% 99.728% ( 10, 15 ] 3462 0.101% 99.829% ( 15, 22 ] 417 0.012% 99.841% ( 22, 34 ] 42 0.001% 99.842% ( 34, 51 ] 24 0.001% 99.843% ( 51, 76 ] 51 0.001% 99.845% ( 76, 110 ] 2531 0.074% 99.919% ( 110, 170 ] 1996 0.058% 99.977% ( 170, 250 ] 452 0.013% 99.990% ( 250, 380 ] 401 0.012% 100.002% ( 380, 580 ] 268 0.008% 100.010% ( 580, 870 ] 191 0.006% 100.015% ( 870, 1300 ] 96 0.003% 100.018% ( 1300, 1900 ] 57 0.002% 100.020% ( 1900, 2900 ] 72 0.002% 100.022% ( 2900, 4400 ] 64 0.002% 100.024% ( 4400, 6600 ] 15 0.000% 100.024% ( 6600, 9900 ] 19 0.001% 100.025% ** Level 1 read latency histogram (micros): Count: 1375852 Average: 5.0673 StdDev: 85.17 Min: 1 Median: 1.6719 Max: 16634 Percentiles: P50: 1.67 P75: 2.50 P99: 9.20 P99.9: 122.38 P99.99: 341.83 ------------------------------------------------------ [ 0, 1 ] 175052 12.723% 12.723% ### ( 1, 2 ] 763292 55.478% 68.201% ########### ( 2, 3 ] 187684 13.641% 81.842% ### ( 3, 4 ] 104788 7.616% 89.458% ## ( 4, 6 ] 108706 7.901% 97.359% ## ( 6, 10 ] 28231 2.052% 99.411% ( 10, 15 ] 4774 0.347% 99.758% ( 15, 22 ] 612 0.044% 99.803% ( 22, 34 ] 42 0.003% 99.806% ( 34, 51 ] 13 0.001% 99.807% ( 51, 76 ] 121 0.009% 99.816% ( 76, 110 ] 986 0.072% 99.887% ( 110, 170 ] 849 0.062% 99.949% ( 170, 250 ] 320 0.023% 99.972% ( 250, 380 ] 346 0.025% 99.997% ( 380, 580 ] 428 0.031% 100.028% ( 580, 870 ] 402 0.029% 100.058% ( 870, 1300 ] 273 0.020% 100.078% ( 1300, 1900 ] 159 0.012% 100.089% ( 1900, 2900 ] 189 0.014% 100.103% ( 2900, 4400 ] 240 0.017% 100.120% ( 4400, 6600 ] 75 0.005% 100.126% ( 6600, 9900 ] 43 0.003% 100.129% ( 9900, 14000 ] 1 0.000% 100.129% ( 14000, 22000 ] 1 0.000% 100.129% ** Level 2 read latency histogram (micros): Count: 124192 Average: 2.9566 StdDev: 33.35 Min: 1 Median: 1.4499 Max: 4294 Percentiles: P50: 1.45 P75: 1.88 P99: 7.21 P99.9: 200.26 P99.99: 2115.07 ------------------------------------------------------ [ 0, 1 ] 29905 24.080% 24.080% ##### ( 1, 2 ] 71546 57.609% 81.689% ############ ( 2, 3 ] 10434 8.402% 90.090% ## ( 3, 4 ] 5897 4.748% 94.839% # ( 4, 6 ] 4803 3.867% 98.706% # ( 6, 10 ] 1206 0.971% 99.677% ( 10, 15 ] 163 0.131% 99.808% ( 15, 22 ] 20 0.016% 99.824% ( 22, 34 ] 9 0.007% 99.832% ( 34, 51 ] 4 0.003% 99.835% ( 76, 110 ] 28 0.023% 99.857% ( 110, 170 ] 46 0.037% 99.895% ( 170, 250 ] 18 0.014% 99.909% ( 250, 380 ] 43 0.035% 99.944% ( 380, 580 ] 24 0.019% 99.963% ( 580, 870 ] 19 0.015% 99.978% ( 870, 1300 ] 9 0.007% 99.986% ( 1300, 1900 ] 3 0.002% 99.988% ( 1900, 2900 ] 12 0.010% 99.998% ( 2900, 4400 ] 3 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 1042648 Average: 5.0051 StdDev: 75.14 Min: 0 Median: 1.8580 Max: 8147 Percentiles: P50: 1.86 P75: 2.95 P99: 9.01 P99.9: 14.98 P99.99: 144.12 ------------------------------------------------------ [ 0, 1 ] 55426 5.316% 5.316% # ( 1, 2 ] 543006 52.080% 57.395% ########## ( 2, 3 ] 193590 18.567% 75.963% #### ( 3, 4 ] 110702 10.617% 86.580% ## ( 4, 6 ] 113458 10.882% 97.462% ## ( 6, 10 ] 21310 2.044% 99.505% ( 10, 15 ] 4130 0.396% 99.902% ( 15, 22 ] 467 0.045% 99.946% ( 22, 34 ] 45 0.004% 99.951% ( 34, 51 ] 20 0.002% 99.953% ( 51, 76 ] 20 0.002% 99.955% ( 76, 110 ] 173 0.017% 99.971% ( 110, 170 ] 346 0.033% 100.004% ( 170, 250 ] 237 0.023% 100.027% ( 250, 380 ] 341 0.033% 100.060% ( 380, 580 ] 328 0.031% 100.091% ( 580, 870 ] 249 0.024% 100.115% ( 870, 1300 ] 196 0.019% 100.134% ( 1300, 1900 ] 112 0.011% 100.145% ( 1900, 2900 ] 129 0.012% 100.157% ( 2900, 4400 ] 191 0.018% 100.175% ( 4400, 6600 ] 40 0.004% 100.179% ( 6600, 9900 ] 15 0.001% 100.181% ** Level 4 read latency histogram (micros): Count: 26204 Average: 91.0027 StdDev: 453.59 Min: 0 Median: 1.9532 Max: 7584 Percentiles: P50: 1.95 P75: 3.37 P99: 2668.36 P99.9: 5639.80 P99.99: 7584.00 ------------------------------------------------------ [ 0, 1 ] 1309 4.995% 4.995% # ( 1, 2 ] 12372 47.214% 52.210% ######### ( 2, 3 ] 4789 18.276% 70.485% #### ( 3, 4 ] 3183 12.147% 82.632% ## ( 4, 6 ] 2022 7.716% 90.349% ## ( 6, 10 ] 548 2.091% 92.440% ( 10, 15 ] 172 0.656% 93.096% ( 15, 22 ] 18 0.069% 93.165% ( 22, 34 ] 10 0.038% 93.203% ( 51, 76 ] 13 0.050% 93.253% ( 76, 110 ] 9 0.034% 93.287% ( 110, 170 ] 30 0.114% 93.402% ( 170, 250 ] 75 0.286% 93.688% ( 250, 380 ] 155 0.592% 94.279% ( 380, 580 ] 261 0.996% 95.276% ( 580, 870 ] 346 1.320% 96.596% ( 870, 1300 ] 348 1.328% 97.924% ( 1300, 1900 ] 179 0.683% 98.607% ( 1900, 2900 ] 134 0.511% 99.118% ( 2900, 4400 ] 180 0.687% 99.805% ( 4400, 6600 ] 44 0.168% 99.973% ( 6600, 9900 ] 8 0.031% 100.004% ** Level 5 read latency histogram (micros): Count: 180 Average: 1368.2611 StdDev: 1436.79 Min: 82 Median: 769.1304 Max: 7837 Percentiles: P50: 769.13 P75: 2270.37 P99: 6930.00 P99.9: 7837.00 P99.99: 7837.00 ------------------------------------------------------ ( 76, 110 ] 4 2.222% 2.222% ( 110, 170 ] 17 9.444% 11.667% ## ( 170, 250 ] 21 11.667% 23.333% ## ( 250, 380 ] 14 7.778% 31.111% ## ( 380, 580 ] 19 10.556% 41.667% ## ( 580, 870 ] 23 12.778% 54.444% ### ( 870, 1300 ] 17 9.444% 63.889% ## ( 1300, 1900 ] 10 5.556% 69.444% # ( 1900, 2900 ] 27 15.000% 84.444% ### ( 2900, 4400 ] 20 11.111% 95.556% ## ( 4400, 6600 ] 6 3.333% 98.889% # ( 6600, 9900 ] 2 1.111% 100.000% ** DB Stats ** Uptime(secs): 44.5 total, 20.8 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 176.99 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.637 H:M:S, 50.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 47.21 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:17.648 H:M:S, 84.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/06-04:30:19 ... thread 0: (1000000,9000000) ops and (318947.8,189832.0) ops/second in (3.135309,47.410338) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/7 3.13 GB 100.7 7.8 0.0 7.8 16.2 8.5 0.0 1.9 142.6 298.5 55.67 51.35 149 0.374 8058K 14K 0.0 0.0 L1 18/18 1.76 GB 0.0 7.2 5.1 2.1 7.1 5.0 0.2 1.4 224.2 221.3 32.72 31.01 4 8.179 7447K 94K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 3.3 2.0 254.4 254.2 1.49 1.43 2 0.743 383K 216 0.0 0.0 L3 21/0 954.50 MB 1.0 5.5 3.2 2.3 5.4 3.1 0.4 1.7 158.2 157.3 35.34 24.80 19 1.860 5678K 30K 0.0 0.0 L4 178/0 9.65 GB 1.0 2.6 2.5 0.1 2.6 2.5 0.8 1.0 144.2 143.9 18.77 12.74 31 0.605 2702K 3654 0.0 0.0 L5 1084/0 89.01 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1313/25 104.48 GB 0.0 23.4 11.0 12.4 31.7 19.3 8.1 3.7 166.3 225.7 143.98 121.33 205 0.702 24M 143K 0.0 0.0 Int 0/0 0.00 KB 0.0 23.4 11.0 12.4 31.7 19.3 8.0 3.7 166.3 225.7 143.98 121.33 205 0.702 24M 143K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 23.4 11.0 12.4 23.2 10.9 0.0 0.0 202.3 201.1 118.35 99.34 81 1.461 24M 143K 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 339.1 25.64 21.99 124 0.207 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 47.6 total, 47.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: 31.73 GB write, 682.35 MB/s write, 23.39 GB read, 502.86 MB/s read, 144.0 seconds Interval compaction: 31.73 GB write, 685.36 MB/s write, 23.39 GB read, 505.07 MB/s read, 144.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 23, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 23, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 35, pending-compaction-bytes-delays: 28, pending-compaction-bytes-stops: 0, total-delays: 51, total-stops: 35, interval: 86 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3745177 Average: 2.6200 StdDev: 30.03 Min: 0 Median: 1.4737 Max: 7904 Percentiles: P50: 1.47 P75: 1.87 P99: 6.41 P99.9: 97.90 P99.99: 237.15 ------------------------------------------------------ [ 0, 1 ] 741628 19.802% 19.802% #### ( 1, 2 ] 2387541 63.750% 83.552% ############# ( 2, 3 ] 321686 8.589% 92.141% ## ( 3, 4 ] 145434 3.883% 96.025% # ( 4, 6 ] 108285 2.891% 98.916% # ( 6, 10 ] 30690 0.819% 99.735% ( 10, 15 ] 3962 0.106% 99.841% ( 15, 22 ] 440 0.012% 99.853% ( 22, 34 ] 48 0.001% 99.854% ( 34, 51 ] 27 0.001% 99.855% ( 51, 76 ] 55 0.001% 99.856% ( 76, 110 ] 2541 0.068% 99.924% ( 110, 170 ] 2056 0.055% 99.979% ( 170, 250 ] 489 0.013% 99.992% ( 250, 380 ] 441 0.012% 100.004% ( 380, 580 ] 286 0.008% 100.012% ( 580, 870 ] 205 0.005% 100.017% ( 870, 1300 ] 111 0.003% 100.020% ( 1300, 1900 ] 61 0.002% 100.022% ( 1900, 2900 ] 78 0.002% 100.024% ( 2900, 4400 ] 68 0.002% 100.025% ( 4400, 6600 ] 15 0.000% 100.026% ( 6600, 9900 ] 19 0.001% 100.026% ** Level 1 read latency histogram (micros): Count: 1439577 Average: 4.9512 StdDev: 83.29 Min: 1 Median: 1.6610 Max: 16634 Percentiles: P50: 1.66 P75: 2.45 P99: 9.17 P99.9: 123.31 P99.99: 343.96 ------------------------------------------------------ [ 0, 1 ] 186500 12.955% 12.955% ### ( 1, 2 ] 806819 56.046% 69.001% ########### ( 2, 3 ] 192345 13.361% 82.362% ### ( 3, 4 ] 106626 7.407% 89.769% # ( 4, 6 ] 109749 7.624% 97.392% ## ( 6, 10 ] 29232 2.031% 99.423% ( 10, 15 ] 4845 0.337% 99.760% ( 15, 22 ] 619 0.043% 99.803% ( 22, 34 ] 42 0.003% 99.805% ( 34, 51 ] 13 0.001% 99.806% ( 51, 76 ] 121 0.008% 99.815% ( 76, 110 ] 1025 0.071% 99.886% ( 110, 170 ] 908 0.063% 99.949% ( 170, 250 ] 331 0.023% 99.972% ( 250, 380 ] 357 0.025% 99.997% ( 380, 580 ] 436 0.030% 100.027% ( 580, 870 ] 402 0.028% 100.055% ( 870, 1300 ] 274 0.019% 100.074% ( 1300, 1900 ] 159 0.011% 100.085% ( 1900, 2900 ] 189 0.013% 100.098% ( 2900, 4400 ] 240 0.017% 100.115% ( 4400, 6600 ] 75 0.005% 100.120% ( 6600, 9900 ] 43 0.003% 100.123% ( 9900, 14000 ] 1 0.000% 100.123% ( 14000, 22000 ] 1 0.000% 100.123% ** Level 2 read latency histogram (micros): Count: 124192 Average: 2.9566 StdDev: 33.35 Min: 1 Median: 1.4499 Max: 4294 Percentiles: P50: 1.45 P75: 1.88 P99: 7.21 P99.9: 200.26 P99.99: 2115.07 ------------------------------------------------------ [ 0, 1 ] 29905 24.080% 24.080% ##### ( 1, 2 ] 71546 57.609% 81.689% ############ ( 2, 3 ] 10434 8.402% 90.090% ## ( 3, 4 ] 5897 4.748% 94.839% # ( 4, 6 ] 4803 3.867% 98.706% # ( 6, 10 ] 1206 0.971% 99.677% ( 10, 15 ] 163 0.131% 99.808% ( 15, 22 ] 20 0.016% 99.824% ( 22, 34 ] 9 0.007% 99.832% ( 34, 51 ] 4 0.003% 99.835% ( 76, 110 ] 28 0.023% 99.857% ( 110, 170 ] 46 0.037% 99.895% ( 170, 250 ] 18 0.014% 99.909% ( 250, 380 ] 43 0.035% 99.944% ( 380, 580 ] 24 0.019% 99.963% ( 580, 870 ] 19 0.015% 99.978% ( 870, 1300 ] 9 0.007% 99.986% ( 1300, 1900 ] 3 0.002% 99.988% ( 1900, 2900 ] 12 0.010% 99.998% ( 2900, 4400 ] 3 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 1136812 Average: 4.8826 StdDev: 72.66 Min: 0 Median: 1.8591 Max: 8147 Percentiles: P50: 1.86 P75: 2.95 P99: 8.99 P99.9: 14.89 P99.99: 134.52 ------------------------------------------------------ [ 0, 1 ] 58069 5.108% 5.108% # ( 1, 2 ] 594038 52.255% 57.363% ########## ( 2, 3 ] 211832 18.634% 75.997% #### ( 3, 4 ] 120699 10.617% 86.614% ## ( 4, 6 ] 123487 10.863% 97.477% ## ( 6, 10 ] 23188 2.040% 99.516% ( 10, 15 ] 4456 0.392% 99.908% ( 15, 22 ] 501 0.044% 99.952% ( 22, 34 ] 46 0.004% 99.956% ( 34, 51 ] 20 0.002% 99.958% ( 51, 76 ] 26 0.002% 99.960% ( 76, 110 ] 190 0.017% 99.977% ( 110, 170 ] 358 0.031% 100.009% ( 170, 250 ] 253 0.022% 100.031% ( 250, 380 ] 348 0.031% 100.061% ( 380, 580 ] 337 0.030% 100.091% ( 580, 870 ] 258 0.023% 100.114% ( 870, 1300 ] 201 0.018% 100.132% ( 1300, 1900 ] 117 0.010% 100.142% ( 1900, 2900 ] 134 0.012% 100.154% ( 2900, 4400 ] 195 0.017% 100.171% ( 4400, 6600 ] 40 0.004% 100.174% ( 6600, 9900 ] 15 0.001% 100.176% ** Level 4 read latency histogram (micros): Count: 30184 Average: 83.4453 StdDev: 427.10 Min: 0 Median: 1.9457 Max: 7584 Percentiles: P50: 1.95 P75: 3.35 P99: 2394.00 P99.9: 5390.80 P99.99: 7584.00 ------------------------------------------------------ [ 0, 1 ] 1505 4.986% 4.986% # ( 1, 2 ] 14367 47.598% 52.584% ########## ( 2, 3 ] 5492 18.195% 70.779% #### ( 3, 4 ] 3608 11.953% 82.733% ## ( 4, 6 ] 2312 7.660% 90.392% ## ( 6, 10 ] 625 2.071% 92.463% ( 10, 15 ] 195 0.646% 93.109% ( 15, 22 ] 22 0.073% 93.182% ( 22, 34 ] 11 0.036% 93.218% ( 51, 76 ] 16 0.053% 93.271% ( 76, 110 ] 18 0.060% 93.331% ( 110, 170 ] 76 0.252% 93.583% ( 170, 250 ] 122 0.404% 93.987% ( 250, 380 ] 193 0.639% 94.626% ( 380, 580 ] 317 1.050% 95.677% ( 580, 870 ] 390 1.292% 96.969% ( 870, 1300 ] 361 1.196% 98.165% ( 1300, 1900 ] 183 0.606% 98.771% ( 1900, 2900 ] 140 0.464% 99.235% ( 2900, 4400 ] 181 0.600% 99.834% ( 4400, 6600 ] 44 0.146% 99.980% ( 6600, 9900 ] 8 0.027% 100.007% ** Level 5 read latency histogram (micros): Count: 200 Average: 1324.4000 StdDev: 1401.20 Min: 82 Median: 747.3077 Max: 7837 Percentiles: P50: 747.31 P75: 2159.26 P99: 6600.00 P99.9: 7837.00 P99.99: 7837.00 ------------------------------------------------------ ( 76, 110 ] 4 2.000% 2.000% ( 110, 170 ] 20 10.000% 12.000% ## ( 170, 250 ] 23 11.500% 23.500% ## ( 250, 380 ] 17 8.500% 32.000% ## ( 380, 580 ] 21 10.500% 42.500% ## ( 580, 870 ] 26 13.000% 55.500% ### ( 870, 1300 ] 19 9.500% 65.000% ## ( 1300, 1900 ] 13 6.500% 71.500% # ( 1900, 2900 ] 27 13.500% 85.000% ### ( 2900, 4400 ] 22 11.000% 96.000% ## ( 4400, 6600 ] 6 3.000% 99.000% # ( 6600, 9900 ] 2 1.000% 100.000% ** DB Stats ** Uptime(secs): 47.6 total, 3.1 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 186.00 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:23.128 H:M:S, 48.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 313.90 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.491 H:M:S, 15.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/06-04:30:32 ... thread 0: (1000000,10000000) ops and (79577.3,166731.3) ops/second in (12.566399,59.976737) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/5 2.34 GB 94.4 9.2 0.0 9.2 18.7 9.5 0.0 2.0 146.2 298.0 64.21 59.46 169 0.380 9529K 16K 0.0 0.0 L1 7/0 836.85 MB 83.7 10.8 6.9 3.8 10.6 6.8 0.2 1.5 218.2 215.4 50.51 46.44 5 10.103 9357K 94K 0.0 0.0 L2 8/6 1.01 GB 2.6 0.4 0.2 0.2 0.4 0.2 6.0 2.0 254.4 254.2 1.49 1.43 2 0.743 383K 216 0.0 0.0 L3 34/10 1.94 GB 1.1 7.5 4.3 3.2 7.5 4.2 1.0 1.7 154.8 153.8 49.73 34.48 30 1.658 7556K 47K 0.0 0.0 L4 179/14 9.68 GB 1.0 3.4 3.2 0.2 3.4 3.2 0.9 1.1 141.6 141.3 24.76 16.44 39 0.635 3482K 4228 0.0 0.0 L5 1092/0 89.69 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1329/35 105.47 GB 0.0 31.2 14.6 16.6 40.6 24.0 12.1 4.3 167.7 217.8 190.70 158.26 245 0.778 30M 163K 0.0 0.0 Int 0/0 0.00 KB 0.0 31.2 14.6 16.6 40.6 24.0 12.0 4.3 167.7 217.8 190.70 158.26 245 0.778 30M 163K 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 31.2 14.6 16.6 31.0 14.4 0.0 0.0 197.4 196.1 162.01 133.55 106 1.528 30M 163K 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 340.4 28.69 24.71 139 0.206 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 60.2 total, 60.0 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: 40.57 GB write, 690.18 MB/s write, 31.24 GB read, 531.45 MB/s read, 190.7 seconds Interval compaction: 40.57 GB write, 692.58 MB/s write, 31.24 GB read, 533.30 MB/s read, 190.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 23, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 23, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 38, pending-compaction-bytes-delays: 58, pending-compaction-bytes-stops: 0, total-delays: 81, total-stops: 38, interval: 119 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4508376 Average: 2.6140 StdDev: 28.89 Min: 0 Median: 1.4846 Max: 8015 Percentiles: P50: 1.48 P75: 1.88 P99: 6.68 P99.9: 92.60 P99.99: 240.08 ------------------------------------------------------ [ 0, 1 ] 867212 19.236% 19.236% #### ( 1, 2 ] 2862006 63.482% 82.718% ############# ( 2, 3 ] 396483 8.794% 91.512% ## ( 3, 4 ] 185992 4.125% 95.637% # ( 4, 6 ] 144734 3.210% 98.848% # ( 6, 10 ] 40211 0.892% 99.740% ( 10, 15 ] 5162 0.114% 99.854% ( 15, 22 ] 568 0.013% 99.867% ( 22, 34 ] 59 0.001% 99.868% ( 34, 51 ] 32 0.001% 99.869% ( 51, 76 ] 65 0.001% 99.870% ( 76, 110 ] 2752 0.061% 99.931% ( 110, 170 ] 2184 0.048% 99.980% ( 170, 250 ] 531 0.012% 99.991% ( 250, 380 ] 477 0.011% 100.002% ( 380, 580 ] 318 0.007% 100.009% ( 580, 870 ] 253 0.006% 100.015% ( 870, 1300 ] 144 0.003% 100.018% ( 1300, 1900 ] 76 0.002% 100.020% ( 1900, 2900 ] 82 0.002% 100.021% ( 2900, 4400 ] 76 0.002% 100.023% ( 4400, 6600 ] 18 0.000% 100.023% ( 6600, 9900 ] 20 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 2276021 Average: 4.8935 StdDev: 78.26 Min: 1 Median: 1.6680 Max: 16634 Percentiles: P50: 1.67 P75: 2.49 P99: 9.14 P99.9: 135.88 P99.99: 454.69 ------------------------------------------------------ [ 0, 1 ] 298413 13.111% 13.111% ### ( 1, 2 ] 1256855 55.222% 68.333% ########### ( 2, 3 ] 308322 13.547% 81.879% ### ( 3, 4 ] 173194 7.610% 89.489% ## ( 4, 6 ] 180264 7.920% 97.409% ## ( 6, 10 ] 46177 2.029% 99.438% ( 10, 15 ] 7243 0.318% 99.756% ( 15, 22 ] 949 0.042% 99.798% ( 22, 34 ] 76 0.003% 99.801% ( 34, 51 ] 22 0.001% 99.802% ( 51, 76 ] 241 0.011% 99.813% ( 76, 110 ] 1399 0.061% 99.874% ( 110, 170 ] 1368 0.060% 99.934% ( 170, 250 ] 471 0.021% 99.955% ( 250, 380 ] 532 0.023% 99.978% ( 380, 580 ] 716 0.031% 100.010% ( 580, 870 ] 761 0.033% 100.043% ( 870, 1300 ] 537 0.024% 100.067% ( 1300, 1900 ] 280 0.012% 100.079% ( 1900, 2900 ] 275 0.012% 100.091% ( 2900, 4400 ] 353 0.016% 100.107% ( 4400, 6600 ] 105 0.005% 100.111% ( 6600, 9900 ] 50 0.002% 100.113% ( 9900, 14000 ] 1 0.000% 100.113% ( 14000, 22000 ] 1 0.000% 100.114% ** Level 2 read latency histogram (micros): Count: 124192 Average: 2.9566 StdDev: 33.35 Min: 1 Median: 1.4499 Max: 4294 Percentiles: P50: 1.45 P75: 1.88 P99: 7.21 P99.9: 200.26 P99.99: 2115.07 ------------------------------------------------------ [ 0, 1 ] 29905 24.080% 24.080% ##### ( 1, 2 ] 71546 57.609% 81.689% ############ ( 2, 3 ] 10434 8.402% 90.090% ## ( 3, 4 ] 5897 4.748% 94.839% # ( 4, 6 ] 4803 3.867% 98.706% # ( 6, 10 ] 1206 0.971% 99.677% ( 10, 15 ] 163 0.131% 99.808% ( 15, 22 ] 20 0.016% 99.824% ( 22, 34 ] 9 0.007% 99.832% ( 34, 51 ] 4 0.003% 99.835% ( 76, 110 ] 28 0.023% 99.857% ( 110, 170 ] 46 0.037% 99.895% ( 170, 250 ] 18 0.014% 99.909% ( 250, 380 ] 43 0.035% 99.944% ( 380, 580 ] 24 0.019% 99.963% ( 580, 870 ] 19 0.015% 99.978% ( 870, 1300 ] 9 0.007% 99.986% ( 1300, 1900 ] 3 0.002% 99.988% ( 1900, 2900 ] 12 0.010% 99.998% ( 2900, 4400 ] 3 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 1617568 Average: 5.1996 StdDev: 74.91 Min: 0 Median: 1.9082 Max: 8420 Percentiles: P50: 1.91 P75: 3.09 P99: 9.11 P99.9: 16.89 P99.99: 197.38 ------------------------------------------------------ [ 0, 1 ] 67849 4.195% 4.195% # ( 1, 2 ] 815806 50.434% 54.629% ########## ( 2, 3 ] 313067 19.354% 73.983% #### ( 3, 4 ] 184208 11.388% 85.371% ## ( 4, 6 ] 193194 11.943% 97.314% ## ( 6, 10 ] 35080 2.169% 99.483% ( 10, 15 ] 6559 0.405% 99.888% ( 15, 22 ] 697 0.043% 99.932% ( 22, 34 ] 70 0.004% 99.936% ( 34, 51 ] 34 0.002% 99.938% ( 51, 76 ] 71 0.004% 99.942% ( 76, 110 ] 214 0.013% 99.956% ( 110, 170 ] 433 0.027% 99.982% ( 170, 250 ] 366 0.023% 100.005% ( 250, 380 ] 527 0.033% 100.038% ( 380, 580 ] 567 0.035% 100.073% ( 580, 870 ] 554 0.034% 100.107% ( 870, 1300 ] 394 0.024% 100.131% ( 1300, 1900 ] 190 0.012% 100.143% ( 1900, 2900 ] 197 0.012% 100.155% ( 2900, 4400 ] 285 0.018% 100.173% ( 4400, 6600 ] 61 0.004% 100.176% ( 6600, 9900 ] 22 0.001% 100.178% ** Level 4 read latency histogram (micros): Count: 80531 Average: 53.1527 StdDev: 331.08 Min: 0 Median: 2.0103 Max: 7640 Percentiles: P50: 2.01 P75: 3.43 P99: 1499.45 P99.9: 4201.39 P99.99: 5710.23 ------------------------------------------------------ [ 0, 1 ] 2576 3.199% 3.199% # ( 1, 2 ] 37526 46.598% 49.797% ######### ( 2, 3 ] 15925 19.775% 69.572% #### ( 3, 4 ] 10071 12.506% 82.078% ### ( 4, 6 ] 8593 10.670% 92.748% ## ( 6, 10 ] 1866 2.317% 95.065% ( 10, 15 ] 508 0.631% 95.696% ( 15, 22 ] 47 0.058% 95.754% ( 22, 34 ] 11 0.014% 95.768% ( 34, 51 ] 2 0.002% 95.771% ( 51, 76 ] 19 0.024% 95.794% ( 76, 110 ] 22 0.027% 95.821% ( 110, 170 ] 102 0.127% 95.948% ( 170, 250 ] 177 0.220% 96.168% ( 250, 380 ] 312 0.387% 96.555% ( 380, 580 ] 540 0.671% 97.226% ( 580, 870 ] 717 0.890% 98.116% ( 870, 1300 ] 600 0.745% 98.861% ( 1300, 1900 ] 336 0.417% 99.279% ( 1900, 2900 ] 248 0.308% 99.586% ( 2900, 4400 ] 291 0.361% 99.948% ( 4400, 6600 ] 57 0.071% 100.019% ( 6600, 9900 ] 10 0.012% 100.031% ** Level 5 read latency histogram (micros): Count: 240 Average: 1376.7042 StdDev: 1422.40 Min: 82 Median: 776.7857 Max: 7837 Percentiles: P50: 776.79 P75: 2282.35 P99: 6502.22 P99.9: 7837.00 P99.99: 7837.00 ------------------------------------------------------ ( 76, 110 ] 4 1.667% 1.667% ( 110, 170 ] 24 10.000% 11.667% ## ( 170, 250 ] 27 11.250% 22.917% ## ( 250, 380 ] 22 9.167% 32.083% ## ( 380, 580 ] 24 10.000% 42.083% ## ( 580, 870 ] 28 11.667% 53.750% ## ( 870, 1300 ] 23 9.583% 63.333% ## ( 1300, 1900 ] 15 6.250% 69.583% # ( 1900, 2900 ] 34 14.167% 83.750% ### ( 2900, 4400 ] 28 11.667% 95.417% ## ( 4400, 6600 ] 9 3.750% 99.167% # ( 6600, 9900 ] 2 0.833% 100.000% ** DB Stats ** Uptime(secs): 60.2 total, 12.6 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 163.52 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:32.617 H:M:S, 54.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 78.32 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:9.490 H:M:S, 75.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 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.995 micros/op 166809 ops/sec 60.003 seconds 10008999 operations; 161.6 MB/s Microseconds per write: Count: 10008999 Average: 5.9949 StdDev: 281.92 Min: 1 Median: 1.7443 Max: 368434 Percentiles: P50: 1.74 P75: 2.75 P99: 8.74 P99.9: 1170.26 P99.99: 2749.54 ------------------------------------------------------ [ 0, 1 ] 1319001 13.178% 13.178% ### ( 1, 2 ] 4951899 49.474% 62.653% ########## ( 2, 3 ] 1647412 16.459% 79.112% ### ( 3, 4 ] 1385111 13.839% 92.951% ### ( 4, 6 ] 535184 5.347% 98.298% # ( 6, 10 ] 102580 1.025% 99.322% ( 10, 15 ] 26157 0.261% 99.584% ( 15, 22 ] 7350 0.073% 99.657% ( 22, 34 ] 1527 0.015% 99.673% ( 34, 51 ] 164 0.002% 99.674% ( 51, 76 ] 27 0.000% 99.674% ( 76, 110 ] 6952 0.069% 99.744% ( 110, 170 ] 2833 0.028% 99.772% ( 170, 250 ] 274 0.003% 99.775% ( 250, 380 ] 131 0.001% 99.776% ( 380, 580 ] 41 0.000% 99.777% ( 580, 870 ] 23 0.000% 99.777% ( 870, 1300 ] 17649 0.176% 99.953% ( 1300, 1900 ] 149 0.001% 99.955% ( 1900, 2900 ] 4160 0.042% 99.996% ( 2900, 4400 ] 273 0.003% 99.999% ( 4400, 6600 ] 65 0.001% 100.000% ( 6600, 9900 ] 15 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 50000, 75000 ] 1 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 14 0.000% 100.000% ( 250000, 380000 ] 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 : 220702 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 : 10008999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10329286968 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 : 604 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 32617391 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 : 35617608403 rocksdb.compact.write.bytes COUNT : 35382081290 rocksdb.flush.write.bytes COUNT : 10238972318 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 : 57 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 : 310 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 : 10156349440 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3886080 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 : 35717249762 rocksdb.non.last.level.read.count COUNT : 8631237 rocksdb.block.checksum.compute.count COUNT : 8630086 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.380042 P95 : 3.876438 P99 : 7.180271 P100 : 368430.000000 COUNT : 10008999 SUM : 55241116 rocksdb.compaction.times.micros P50 : 1010571.428571 P95 : 2868181.818182 P99 : 17720000.000000 P100 : 19754071.000000 COUNT : 107 SUM : 163252845 rocksdb.compaction.times.cpu_micros P50 : 903714.285714 P95 : 2550000.000000 P99 : 17720000.000000 P100 : 18547090.000000 COUNT : 107 SUM : 134333559 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 : 709.065934 P95 : 1268.576923 P99 : 6314.000000 P100 : 7666.000000 COUNT : 139 SUM : 115349 rocksdb.compaction.outfile.sync.micros P50 : 1174.040404 P95 : 124869.565217 P99 : 167234.782609 P100 : 204555.000000 COUNT : 406 SUM : 8142685 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 : 104.253521 P95 : 1632.307692 P99 : 3872.000000 P100 : 4776.000000 COUNT : 276 SUM : 91660 rocksdb.table.open.io.micros P50 : 1486.792453 P95 : 7962.580645 P99 : 12121.454545 P100 : 14422.000000 COUNT : 604 SUM : 1283644 rocksdb.db.multiget.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.read.block.compaction.micros P50 : 3.660714 P95 : 8.225681 P99 : 11.448174 P100 : 16640.000000 COUNT : 8628515 SUM : 54382516 rocksdb.read.block.get.micros P50 : 473.750000 P95 : 3446.774194 P99 : 5432.842105 P100 : 8011.000000 COUNT : 1208 SUM : 1060886 rocksdb.write.raw.block.micros P50 : 0.512565 P95 : 0.973873 P99 : 2.846364 P100 : 23807.000000 COUNT : 11056421 SUM : 21604973 rocksdb.numfiles.in.singlecompaction P50 : 2.729167 P95 : 5.180000 P99 : 17.730000 P100 : 31.000000 COUNT : 161 SUM : 561 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.556659 P95 : 1144.710987 P99 : 2453.992754 P100 : 368212.000000 COUNT : 219947 SUM : 32634313 rocksdb.sst.read.micros P50 : 1.604079 P95 : 5.026040 P99 : 8.655375 P100 : 16634.000000 COUNT : 8631691 SUM : 36605084 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 : 10008999 SUM : 10329286968 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 : 211923.076923 P95 : 356031.250000 P99 : 545300.000000 P100 : 581094.000000 COUNT : 139 SUM : 28688043 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 : 391 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