[2024-11-20 05:14:05.920188] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 23.11.0 initialization... [2024-11-20 05:14:05.920326] [ 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_pid337032 ] Set seed to 1732076045916603 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-20 05:14:06.027265] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-20 05:14:06.237670] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-20 05:14:06.237714] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 337032' to capture a snapshot of events at runtime. [2024-11-20 05:14:06.237725] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid337032 for offline analysis/debug. [2024-11-20 05:14:06.237753] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Wed Nov 20 05:14:14 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/20-05:14:22 ... thread 0: (1000000,1000000) ops and (130318.6,130318.6) ops/second in (7.673499,7.673499) 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 6/4 566.91 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 119.6 6.85 2.39 9 0.761 0 0 0.0 0.0 L1 2/1 162.68 MB 4.6 0.5 0.3 0.2 0.5 0.3 0.0 1.8 121.3 121.2 4.56 2.54 2 2.279 561K 590 0.0 0.0 L2 5/1 336.53 MB 2.1 0.1 0.1 0.0 0.1 0.1 0.1 1.0 188.5 188.5 0.57 0.47 1 0.572 109K 0 0.0 0.0 L3 42/8 3.66 GB 2.9 3.4 2.1 1.2 3.3 2.1 0.1 1.6 99.7 98.6 34.52 16.15 15 2.302 2546K 4265 0.0 0.0 L4 193/21 11.70 GB 1.1 3.0 1.9 1.1 2.9 1.8 0.1 1.5 113.3 111.0 26.96 14.03 19 1.419 1967K 0 0.0 0.0 L5 1104/0 90.80 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 1352/35 107.20 GB 0.0 7.0 4.4 2.6 7.7 5.1 0.3 9.6 97.4 107.2 73.46 35.60 46 1.597 5184K 4855 0.0 0.0 Int 0/0 0.00 KB 0.0 7.0 4.4 2.6 7.7 5.1 0.3 9.6 97.4 107.2 73.46 35.60 46 1.597 5184K 4855 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 7.0 4.4 2.6 6.9 4.3 0.0 0.0 107.4 105.9 66.62 33.20 37 1.800 5184K 4855 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 119.6 6.85 2.39 9 0.761 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 7.9 total, 7.7 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: 7.69 GB write, 1002.61 MB/s write, 6.99 GB read, 911.04 MB/s read, 73.5 seconds Interval compaction: 7.69 GB write, 1026.03 MB/s write, 6.99 GB read, 932.32 MB/s read, 73.5 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: 31, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 31, interval: 31 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 172670 Average: 8.0237 StdDev: 117.96 Min: 1 Median: 1.8997 Max: 9803 Percentiles: P50: 1.90 P75: 2.90 P99: 9.72 P99.9: 1988.86 P99.99: 5140.63 ------------------------------------------------------ [ 0, 1 ] 6310 3.654% 3.654% # ( 1, 2 ] 88947 51.513% 55.167% ########## ( 2, 3 ] 37958 21.983% 77.150% #### ( 3, 4 ] 16334 9.460% 86.610% ## ( 4, 6 ] 18070 10.465% 97.075% ## ( 6, 10 ] 3576 2.071% 99.146% ( 10, 15 ] 858 0.497% 99.643% ( 15, 22 ] 99 0.057% 99.700% ( 22, 34 ] 11 0.006% 99.706% ( 34, 51 ] 5 0.003% 99.709% ( 51, 76 ] 9 0.005% 99.714% ( 76, 110 ] 1 0.001% 99.715% ( 110, 170 ] 4 0.002% 99.717% ( 170, 250 ] 9 0.005% 99.723% ( 250, 380 ] 16 0.009% 99.732% ( 380, 580 ] 33 0.019% 99.751% ( 580, 870 ] 56 0.032% 99.783% ( 870, 1300 ] 92 0.053% 99.837% ( 1300, 1900 ] 100 0.058% 99.895% ( 1900, 2900 ] 105 0.061% 99.955% ( 2900, 4400 ] 53 0.031% 99.986% ( 4400, 6600 ] 20 0.012% 99.998% ( 6600, 9900 ] 4 0.002% 100.000% ** Level 1 read latency histogram (micros): Count: 100304 Average: 10.3296 StdDev: 152.39 Min: 1 Median: 1.9917 Max: 7109 Percentiles: P50: 1.99 P75: 2.99 P99: 9.80 P99.9: 2598.59 P99.99: 5331.31 ------------------------------------------------------ [ 0, 1 ] 1875 1.869% 1.869% ( 1, 2 ] 48683 48.535% 50.405% ########## ( 2, 3 ] 24914 24.838% 75.243% ##### ( 3, 4 ] 10254 10.223% 85.466% ## ( 4, 6 ] 11622 11.587% 97.053% ## ( 6, 10 ] 2057 2.051% 99.104% ( 10, 15 ] 510 0.508% 99.612% ( 15, 22 ] 51 0.051% 99.663% ( 22, 34 ] 2 0.002% 99.665% ( 51, 76 ] 2 0.002% 99.667% ( 76, 110 ] 2 0.002% 99.669% ( 110, 170 ] 3 0.003% 99.672% ( 170, 250 ] 3 0.003% 99.675% ( 250, 380 ] 11 0.011% 99.686% ( 380, 580 ] 25 0.025% 99.711% ( 580, 870 ] 36 0.036% 99.747% ( 870, 1300 ] 44 0.044% 99.791% ( 1300, 1900 ] 58 0.058% 99.848% ( 1900, 2900 ] 74 0.074% 99.922% ( 2900, 4400 ] 54 0.054% 99.976% ( 4400, 6600 ] 33 0.033% 100.009% ( 6600, 9900 ] 2 0.002% 100.011% ** Level 2 read latency histogram (micros): Count: 468085 Average: 19.7914 StdDev: 236.26 Min: 1 Median: 1.9595 Max: 22004 Percentiles: P50: 1.96 P75: 3.10 P99: 13.46 P99.9: 2499.47 P99.99: 3019.98 ------------------------------------------------------ [ 0, 1 ] 16275 3.477% 3.477% # ( 1, 2 ] 226971 48.489% 51.966% ########## ( 2, 3 ] 102988 22.002% 73.968% #### ( 3, 4 ] 47683 10.187% 84.155% ## ( 4, 6 ] 53352 11.398% 95.553% ## ( 6, 10 ] 13202 2.820% 98.373% # ( 10, 15 ] 4240 0.906% 99.279% ( 15, 22 ] 718 0.153% 99.433% ( 22, 34 ] 71 0.015% 99.448% ( 34, 51 ] 16 0.003% 99.451% ( 51, 76 ] 16 0.003% 99.455% ( 76, 110 ] 6 0.001% 99.456% ( 110, 170 ] 15 0.003% 99.459% ( 170, 250 ] 23 0.005% 99.464% ( 250, 380 ] 85 0.018% 99.482% ( 380, 580 ] 160 0.034% 99.516% ( 580, 870 ] 255 0.054% 99.571% ( 870, 1300 ] 408 0.087% 99.658% ( 1300, 1900 ] 585 0.125% 99.783% ( 1900, 2900 ] 914 0.195% 99.978% ( 2900, 4400 ] 690 0.147% 100.126% ( 4400, 6600 ] 218 0.047% 100.172% ( 6600, 9900 ] 43 0.009% 100.181% ( 9900, 14000 ] 10 0.002% 100.184% ( 14000, 22000 ] 1 0.000% 100.184% ( 22000, 33000 ] 1 0.000% 100.184% ** Level 3 read latency histogram (micros): Count: 697001 Average: 12.5715 StdDev: 180.99 Min: 1 Median: 1.9776 Max: 25655 Percentiles: P50: 1.98 P75: 3.00 P99: 9.92 P99.9: 1252.06 P99.99: 1864.12 ------------------------------------------------------ [ 0, 1 ] 15885 2.279% 2.279% ( 1, 2 ] 340229 48.813% 51.092% ########## ( 2, 3 ] 167474 24.028% 75.120% ##### ( 3, 4 ] 71628 10.277% 85.397% ## ( 4, 6 ] 79414 11.394% 96.790% ## ( 6, 10 ] 15719 2.255% 99.046% ( 10, 15 ] 4079 0.585% 99.631% ( 15, 22 ] 514 0.074% 99.705% ( 22, 34 ] 46 0.007% 99.711% ( 34, 51 ] 26 0.004% 99.715% ( 51, 76 ] 40 0.006% 99.721% ( 76, 110 ] 13 0.002% 99.723% ( 110, 170 ] 31 0.004% 99.727% ( 170, 250 ] 36 0.005% 99.732% ( 250, 380 ] 84 0.012% 99.744% ( 380, 580 ] 199 0.029% 99.773% ( 580, 870 ] 364 0.052% 99.825% ( 870, 1300 ] 592 0.085% 99.910% ( 1300, 1900 ] 597 0.086% 99.996% ( 1900, 2900 ] 609 0.087% 100.083% ( 2900, 4400 ] 511 0.073% 100.156% ( 4400, 6600 ] 197 0.028% 100.185% ( 6600, 9900 ] 36 0.005% 100.190% ( 9900, 14000 ] 7 0.001% 100.191% ( 14000, 22000 ] 1 0.000% 100.191% ( 22000, 33000 ] 3 0.000% 100.191% ** Level 4 read latency histogram (micros): Count: 347165 Average: 27.4920 StdDev: 275.75 Min: 1 Median: 1.9687 Max: 19733 Percentiles: P50: 1.97 P75: 3.04 P99: 568.19 P99.9: 3348.86 P99.99: 4115.92 ------------------------------------------------------ [ 0, 1 ] 8637 2.488% 2.488% ( 1, 2 ] 170272 49.046% 51.534% ########## ( 2, 3 ] 80140 23.084% 74.618% ##### ( 3, 4 ] 34358 9.897% 84.515% ## ( 4, 6 ] 37812 10.892% 95.407% ## ( 6, 10 ] 9398 2.707% 98.114% # ( 10, 15 ] 2320 0.668% 98.782% ( 15, 22 ] 259 0.075% 98.857% ( 22, 34 ] 27 0.008% 98.865% ( 34, 51 ] 13 0.004% 98.868% ( 51, 76 ] 13 0.004% 98.872% ( 76, 110 ] 9 0.003% 98.875% ( 110, 170 ] 24 0.007% 98.882% ( 170, 250 ] 70 0.020% 98.902% ( 250, 380 ] 109 0.031% 98.933% ( 380, 580 ] 248 0.071% 99.005% ( 580, 870 ] 514 0.148% 99.153% ( 870, 1300 ] 773 0.223% 99.375% ( 1300, 1900 ] 824 0.237% 99.613% ( 1900, 2900 ] 816 0.235% 99.848% ( 2900, 4400 ] 611 0.176% 100.024% ( 4400, 6600 ] 257 0.074% 100.098% ( 6600, 9900 ] 42 0.012% 100.110% ( 9900, 14000 ] 4 0.001% 100.111% ( 14000, 22000 ] 2 0.001% 100.111% ** Level 5 read latency histogram (micros): Count: 9205 Average: 2394.4523 StdDev: 1863.92 Min: 94 Median: 1832.0108 Max: 27502 Percentiles: P50: 1832.01 P75: 3478.42 P99: 8987.13 P99.9: 13269.97 P99.99: 27502.00 ------------------------------------------------------ ( 76, 110 ] 3 0.033% 0.033% ( 110, 170 ] 17 0.185% 0.217% ( 170, 250 ] 81 0.880% 1.097% ( 250, 380 ] 227 2.466% 3.563% ( 380, 580 ] 514 5.584% 9.147% # ( 580, 870 ] 978 10.625% 19.772% ## ( 870, 1300 ] 1464 15.904% 35.676% ### ( 1300, 1900 ] 1487 16.154% 51.831% ### ( 1900, 2900 ] 1515 16.458% 68.289% ### ( 2900, 4400 ] 1602 17.404% 85.693% ### ( 4400, 6600 ] 1047 11.374% 97.067% ## ( 6600, 9900 ] 246 2.672% 99.739% # ( 9900, 14000 ] 18 0.196% 99.935% ( 14000, 22000 ] 3 0.033% 99.967% ( 22000, 33000 ] 3 0.033% 100.000% ** DB Stats ** Uptime(secs): 7.9 total, 7.7 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 125.30 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:3.827 H:M:S, 48.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 128.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:3.827 H:M:S, 49.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/11/20-05:14:31 ... thread 0: (1000000,2000000) ops and (113801.9,121501.5) ops/second in (8.787200,16.460699) 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 7/4 944.17 MB 56.6 0.7 0.0 0.7 2.5 1.8 0.0 1.4 36.0 123.0 20.99 9.00 22 0.954 767K 1077 0.0 0.0 L1 4/0 336.70 MB 33.7 1.2 0.9 0.3 1.2 0.9 0.0 1.3 110.8 110.6 11.09 6.37 3 3.695 1247K 1999 0.0 0.0 L2 5/4 445.05 MB 1.3 0.3 0.2 0.1 0.3 0.2 0.4 1.6 134.2 134.1 2.63 1.65 2 1.315 358K 344 0.0 0.0 L3 19/11 1.58 GB 0.5 4.7 2.4 2.2 4.6 2.4 0.1 1.9 95.3 94.2 50.50 24.25 21 2.405 3438K 4920 0.0 0.0 L4 174/4 9.74 GB 1.0 7.8 4.0 3.8 7.6 3.8 0.4 1.9 108.1 105.7 73.92 40.64 40 1.848 3350K 7462 0.0 0.0 L5 1156/0 95.04 GB 1.0 0.0 0.0 0.0 0.0 0.0 4.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1365/23 108.05 GB 0.0 14.8 7.6 7.2 16.3 9.1 5.2 9.2 95.2 105.2 159.13 81.91 88 1.808 9162K 15K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.8 7.6 7.2 16.3 9.1 5.2 9.2 95.2 105.2 159.13 81.91 88 1.808 9162K 15K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 14.8 7.6 7.2 14.6 7.4 0.0 0.0 105.5 103.9 143.48 76.02 68 2.110 9162K 15K 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 116.7 15.65 5.89 20 0.783 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.6 total, 16.5 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: 16.34 GB write, 1005.52 MB/s write, 14.79 GB read, 909.89 MB/s read, 159.1 seconds Interval compaction: 16.34 GB write, 1016.47 MB/s write, 14.79 GB read, 919.80 MB/s read, 159.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 74, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 74, interval: 74 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 485336 Average: 12.6276 StdDev: 584.33 Min: 1 Median: 1.8930 Max: 250326 Percentiles: P50: 1.89 P75: 2.89 P99: 11.21 P99.9: 2367.96 P99.99: 4954.91 ------------------------------------------------------ [ 0, 1 ] 18418 3.795% 3.795% # ( 1, 2 ] 251132 51.744% 55.539% ########## ( 2, 3 ] 106535 21.951% 77.490% #### ( 3, 4 ] 44531 9.175% 86.665% ## ( 4, 6 ] 48776 10.050% 96.715% ## ( 6, 10 ] 10457 2.155% 98.869% ( 10, 15 ] 2624 0.541% 99.410% ( 15, 22 ] 257 0.053% 99.463% ( 22, 34 ] 19 0.004% 99.467% ( 34, 51 ] 16 0.003% 99.470% ( 51, 76 ] 33 0.007% 99.477% ( 76, 110 ] 10 0.002% 99.479% ( 110, 170 ] 22 0.005% 99.484% ( 170, 250 ] 52 0.011% 99.494% ( 250, 380 ] 111 0.023% 99.517% ( 380, 580 ] 309 0.064% 99.581% ( 580, 870 ] 495 0.102% 99.683% ( 870, 1300 ] 528 0.109% 99.792% ( 1300, 1900 ] 382 0.079% 99.870% ( 1900, 2900 ] 307 0.063% 99.934% ( 2900, 4400 ] 249 0.051% 99.985% ( 4400, 6600 ] 97 0.020% 100.005% ( 6600, 9900 ] 23 0.005% 100.010% ( 9900, 14000 ] 2 0.000% 100.010% ( 14000, 22000 ] 1 0.000% 100.010% ( 170000, 250000 ] 2 0.000% 100.011% ( 250000, 380000 ] 1 0.000% 100.011% ** Level 1 read latency histogram (micros): Count: 191164 Average: 11.2005 StdDev: 151.46 Min: 1 Median: 1.9863 Max: 8563 Percentiles: P50: 1.99 P75: 2.98 P99: 11.15 P99.9: 2443.54 P99.99: 4619.26 ------------------------------------------------------ [ 0, 1 ] 3486 1.824% 1.824% ( 1, 2 ] 93376 48.846% 50.670% ########## ( 2, 3 ] 47244 24.714% 75.383% ##### ( 3, 4 ] 18903 9.888% 85.272% ## ( 4, 6 ] 21533 11.264% 96.536% ## ( 6, 10 ] 4459 2.333% 98.869% ( 10, 15 ] 1099 0.575% 99.443% ( 15, 22 ] 117 0.061% 99.505% ( 22, 34 ] 14 0.007% 99.512% ( 34, 51 ] 2 0.001% 99.513% ( 51, 76 ] 11 0.006% 99.519% ( 76, 110 ] 7 0.004% 99.522% ( 110, 170 ] 6 0.003% 99.526% ( 170, 250 ] 18 0.009% 99.535% ( 250, 380 ] 51 0.027% 99.562% ( 380, 580 ] 111 0.058% 99.620% ( 580, 870 ] 168 0.088% 99.708% ( 870, 1300 ] 160 0.084% 99.791% ( 1300, 1900 ] 136 0.071% 99.862% ( 1900, 2900 ] 134 0.070% 99.933% ( 2900, 4400 ] 106 0.055% 99.988% ( 4400, 6600 ] 49 0.026% 100.014% ( 6600, 9900 ] 6 0.003% 100.017% ** Level 2 read latency histogram (micros): Count: 598645 Average: 18.8027 StdDev: 698.98 Min: 1 Median: 1.9693 Max: 475982 Percentiles: P50: 1.97 P75: 3.08 P99: 13.10 P99.9: 2478.83 P99.99: 3150.59 ------------------------------------------------------ [ 0, 1 ] 19123 3.194% 3.194% # ( 1, 2 ] 289072 48.288% 51.482% ########## ( 2, 3 ] 135676 22.664% 74.146% ##### ( 3, 4 ] 60592 10.122% 84.267% ## ( 4, 6 ] 68321 11.413% 95.680% ## ( 6, 10 ] 16735 2.795% 98.476% # ( 10, 15 ] 5057 0.845% 99.320% ( 15, 22 ] 827 0.138% 99.458% ( 22, 34 ] 78 0.013% 99.471% ( 34, 51 ] 26 0.004% 99.476% ( 51, 76 ] 39 0.007% 99.482% ( 76, 110 ] 8 0.001% 99.484% ( 110, 170 ] 23 0.004% 99.488% ( 170, 250 ] 35 0.006% 99.493% ( 250, 380 ] 110 0.018% 99.512% ( 380, 580 ] 227 0.038% 99.550% ( 580, 870 ] 360 0.060% 99.610% ( 870, 1300 ] 508 0.085% 99.695% ( 1300, 1900 ] 665 0.111% 99.806% ( 1900, 2900 ] 975 0.163% 99.969% ( 2900, 4400 ] 767 0.128% 100.097% ( 4400, 6600 ] 237 0.040% 100.136% ( 6600, 9900 ] 48 0.008% 100.144% ( 9900, 14000 ] 11 0.002% 100.146% ( 14000, 22000 ] 1 0.000% 100.146% ( 22000, 33000 ] 1 0.000% 100.146% ( 170000, 250000 ] 1 0.000% 100.147% ( 380000, 570000 ] 1 0.000% 100.147% ** Level 3 read latency histogram (micros): Count: 1620793 Average: 13.4588 StdDev: 800.18 Min: 0 Median: 1.9951 Max: 477135 Percentiles: P50: 2.00 P75: 3.01 P99: 10.35 P99.9: 1024.80 P99.99: 1589.69 ------------------------------------------------------ [ 0, 1 ] 31279 1.930% 1.930% ( 1, 2 ] 782973 48.308% 50.238% ########## ( 2, 3 ] 399334 24.638% 74.876% ##### ( 3, 4 ] 163773 10.104% 84.981% ## ( 4, 6 ] 185399 11.439% 96.419% ## ( 6, 10 ] 41073 2.534% 98.953% # ( 10, 15 ] 10831 0.668% 99.622% ( 15, 22 ] 1229 0.076% 99.698% ( 22, 34 ] 96 0.006% 99.703% ( 34, 51 ] 99 0.006% 99.710% ( 51, 76 ] 153 0.009% 99.719% ( 76, 110 ] 39 0.002% 99.721% ( 110, 170 ] 71 0.004% 99.726% ( 170, 250 ] 127 0.008% 99.734% ( 250, 380 ] 287 0.018% 99.751% ( 380, 580 ] 720 0.044% 99.796% ( 580, 870 ] 1180 0.073% 99.869% ( 870, 1300 ] 1420 0.088% 99.956% ( 1300, 1900 ] 1139 0.070% 100.026% ( 1900, 2900 ] 1047 0.065% 100.091% ( 2900, 4400 ] 1057 0.065% 100.156% ( 4400, 6600 ] 401 0.025% 100.181% ( 6600, 9900 ] 77 0.005% 100.186% ( 9900, 14000 ] 15 0.001% 100.187% ( 14000, 22000 ] 3 0.000% 100.187% ( 22000, 33000 ] 3 0.000% 100.187% ( 170000, 250000 ] 6 0.000% 100.187% ( 250000, 380000 ] 3 0.000% 100.188% ( 380000, 570000 ] 2 0.000% 100.188% ** Level 4 read latency histogram (micros): Count: 1019508 Average: 23.3593 StdDev: 1222.92 Min: 1 Median: 1.9853 Max: 717992 Percentiles: P50: 1.99 P75: 3.05 P99: 17.04 P99.9: 2418.01 P99.99: 3225.39 ------------------------------------------------------ [ 0, 1 ] 22714 2.228% 2.228% ( 1, 2 ] 494308 48.485% 50.713% ########## ( 2, 3 ] 242299 23.766% 74.479% ##### ( 3, 4 ] 101930 9.998% 84.477% ## ( 4, 6 ] 112954 11.079% 95.556% ## ( 6, 10 ] 27805 2.727% 98.284% # ( 10, 15 ] 7050 0.692% 98.975% ( 15, 22 ] 866 0.085% 99.060% ( 22, 34 ] 75 0.007% 99.067% ( 34, 51 ] 53 0.005% 99.073% ( 51, 76 ] 90 0.009% 99.082% ( 76, 110 ] 26 0.003% 99.084% ( 110, 170 ] 69 0.007% 99.091% ( 170, 250 ] 259 0.025% 99.116% ( 250, 380 ] 453 0.044% 99.161% ( 380, 580 ] 1109 0.109% 99.269% ( 580, 870 ] 1902 0.187% 99.456% ( 870, 1300 ] 2180 0.214% 99.670% ( 1300, 1900 ] 1642 0.161% 99.831% ( 1900, 2900 ] 1360 0.133% 99.964% ( 2900, 4400 ] 1208 0.118% 100.083% ( 4400, 6600 ] 455 0.045% 100.127% ( 6600, 9900 ] 68 0.007% 100.134% ( 9900, 14000 ] 7 0.001% 100.135% ( 14000, 22000 ] 2 0.000% 100.135% ( 110000, 170000 ] 1 0.000% 100.135% ( 170000, 250000 ] 3 0.000% 100.135% ( 250000, 380000 ] 1 0.000% 100.135% ( 380000, 570000 ] 3 0.000% 100.136% ( 570000, 860000 ] 1 0.000% 100.136% ** Level 5 read latency histogram (micros): Count: 26874 Average: 1841.7211 StdDev: 8078.50 Min: 94 Median: 1130.9086 Max: 480787 Percentiles: P50: 1130.91 P75: 2209.48 P99: 7626.83 P99.9: 13528.66 P99.99: 480787.00 ------------------------------------------------------ ( 76, 110 ] 9 0.033% 0.033% ( 110, 170 ] 131 0.487% 0.521% ( 170, 250 ] 425 1.581% 2.102% ( 250, 380 ] 1329 4.945% 7.048% # ( 380, 580 ] 3100 11.535% 18.583% ## ( 580, 870 ] 5124 19.067% 37.650% #### ( 870, 1300 ] 5470 20.354% 58.004% #### ( 1300, 1900 ] 3709 13.801% 71.805% ### ( 1900, 2900 ] 2774 10.322% 82.128% ## ( 2900, 4400 ] 2935 10.921% 93.049% ## ( 4400, 6600 ] 1500 5.582% 98.631% # ( 6600, 9900 ] 319 1.187% 99.818% ( 9900, 14000 ] 25 0.093% 99.911% ( 14000, 22000 ] 7 0.026% 99.937% ( 22000, 33000 ] 6 0.022% 99.959% ( 250000, 380000 ] 5 0.019% 99.978% ( 380000, 570000 ] 6 0.022% 100.000% ** DB Stats ** Uptime(secs): 16.6 total, 8.8 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 118.28 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:8.779 H:M:S, 52.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 112.00 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:4.952 H:M:S, 56.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 6 num-running-flushes: 1 2024/11/20-05:14:35 ... thread 0: (1000000,3000000) ops and (232640.6,144514.4) ops/second in (4.298475,20.759174) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/9 1.91 GB 44.1 1.6 0.0 1.6 4.4 2.8 0.0 1.6 55.8 152.2 29.37 15.31 40 0.734 1662K 2081 0.0 0.0 L1 4/4 336.70 MB 0.0 1.2 0.9 0.3 1.2 0.9 0.0 1.3 110.8 110.6 11.09 6.37 3 3.695 1247K 1999 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.2 0.1 0.3 0.2 0.4 1.6 134.2 134.1 2.63 1.65 2 1.315 358K 344 0.0 0.0 L3 18/1 1.03 GB 0.9 6.2 2.9 3.3 6.2 2.8 0.1 2.1 104.5 103.5 61.02 31.50 26 2.347 4240K 7125 0.0 0.0 L4 179/7 9.99 GB 1.0 9.7 4.9 4.9 9.5 4.6 0.5 2.0 115.8 113.1 86.01 49.71 52 1.654 4349K 7462 0.0 0.0 L5 1164/0 95.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 4.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1378/21 108.98 GB 0.0 19.1 8.9 10.2 21.6 11.3 6.0 7.8 102.8 116.2 190.12 104.55 123 1.546 11M 19K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.1 8.9 10.2 21.6 11.3 6.0 7.8 102.8 116.2 190.12 104.55 123 1.546 11M 19K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 19.1 8.9 10.2 18.8 8.6 0.0 0.0 114.9 113.2 170.11 95.88 88 1.933 11M 19K 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 141.7 20.01 8.67 35 0.572 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.9 total, 20.8 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: 21.57 GB write, 1055.04 MB/s write, 19.09 GB read, 933.73 MB/s read, 190.1 seconds Interval compaction: 21.57 GB write, 1064.15 MB/s write, 19.09 GB read, 941.79 MB/s read, 190.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 84, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 84, interval: 84 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 834201 Average: 9.4896 StdDev: 447.32 Min: 1 Median: 1.8258 Max: 250326 Percentiles: P50: 1.83 P75: 2.75 P99: 9.93 P99.9: 1581.10 P99.99: 3886.55 ------------------------------------------------------ [ 0, 1 ] 41551 4.981% 4.981% # ( 1, 2 ] 454791 54.518% 59.499% ########### ( 2, 3 ] 172384 20.665% 80.164% #### ( 3, 4 ] 69084 8.281% 88.445% ## ( 4, 6 ] 73138 8.767% 97.213% ## ( 6, 10 ] 15194 1.821% 99.034% ( 10, 15 ] 3570 0.428% 99.462% ( 15, 22 ] 348 0.042% 99.504% ( 22, 34 ] 28 0.003% 99.507% ( 34, 51 ] 22 0.003% 99.510% ( 51, 76 ] 40 0.005% 99.514% ( 76, 110 ] 27 0.003% 99.518% ( 110, 170 ] 295 0.035% 99.553% ( 170, 250 ] 376 0.045% 99.598% ( 250, 380 ] 377 0.045% 99.643% ( 380, 580 ] 577 0.069% 99.712% ( 580, 870 ] 707 0.085% 99.797% ( 870, 1300 ] 655 0.079% 99.876% ( 1300, 1900 ] 435 0.052% 99.928% ( 1900, 2900 ] 342 0.041% 99.969% ( 2900, 4400 ] 270 0.032% 100.001% ( 4400, 6600 ] 104 0.012% 100.014% ( 6600, 9900 ] 25 0.003% 100.017% ( 9900, 14000 ] 2 0.000% 100.017% ( 14000, 22000 ] 1 0.000% 100.017% ( 170000, 250000 ] 2 0.000% 100.017% ( 250000, 380000 ] 1 0.000% 100.017% ** Level 1 read latency histogram (micros): Count: 244145 Average: 10.4951 StdDev: 141.60 Min: 1 Median: 1.9655 Max: 8563 Percentiles: P50: 1.97 P75: 2.95 P99: 11.60 P99.9: 2186.68 P99.99: 4369.31 ------------------------------------------------------ [ 0, 1 ] 4660 1.909% 1.909% ( 1, 2 ] 121602 49.807% 51.716% ########## ( 2, 3 ] 59661 24.437% 76.153% ##### ( 3, 4 ] 23246 9.521% 85.674% ## ( 4, 6 ] 26263 10.757% 96.431% ## ( 6, 10 ] 5821 2.384% 98.815% ( 10, 15 ] 1406 0.576% 99.391% ( 15, 22 ] 162 0.066% 99.458% ( 22, 34 ] 18 0.007% 99.465% ( 34, 51 ] 7 0.003% 99.468% ( 51, 76 ] 12 0.005% 99.473% ( 76, 110 ] 13 0.005% 99.478% ( 110, 170 ] 45 0.018% 99.497% ( 170, 250 ] 78 0.032% 99.529% ( 250, 380 ] 120 0.049% 99.578% ( 380, 580 ] 163 0.067% 99.644% ( 580, 870 ] 235 0.096% 99.741% ( 870, 1300 ] 197 0.081% 99.821% ( 1300, 1900 ] 150 0.061% 99.883% ( 1900, 2900 ] 146 0.060% 99.943% ( 2900, 4400 ] 118 0.048% 99.991% ( 4400, 6600 ] 51 0.021% 100.012% ( 6600, 9900 ] 8 0.003% 100.015% ** Level 2 read latency histogram (micros): Count: 604704 Average: 18.6733 StdDev: 695.51 Min: 1 Median: 1.9697 Max: 475982 Percentiles: P50: 1.97 P75: 3.08 P99: 13.08 P99.9: 2473.92 P99.99: 3149.41 ------------------------------------------------------ [ 0, 1 ] 19199 3.175% 3.175% # ( 1, 2 ] 291998 48.288% 51.463% ########## ( 2, 3 ] 137295 22.704% 74.167% ##### ( 3, 4 ] 61164 10.115% 84.282% ## ( 4, 6 ] 68984 11.408% 95.690% ## ( 6, 10 ] 16879 2.791% 98.481% # ( 10, 15 ] 5097 0.843% 99.324% ( 15, 22 ] 829 0.137% 99.461% ( 22, 34 ] 78 0.013% 99.474% ( 34, 51 ] 27 0.004% 99.478% ( 51, 76 ] 39 0.006% 99.485% ( 76, 110 ] 8 0.001% 99.486% ( 110, 170 ] 23 0.004% 99.490% ( 170, 250 ] 35 0.006% 99.496% ( 250, 380 ] 112 0.019% 99.514% ( 380, 580 ] 230 0.038% 99.552% ( 580, 870 ] 365 0.060% 99.613% ( 870, 1300 ] 509 0.084% 99.697% ( 1300, 1900 ] 667 0.110% 99.807% ( 1900, 2900 ] 978 0.162% 99.969% ( 2900, 4400 ] 767 0.127% 100.096% ( 4400, 6600 ] 237 0.039% 100.135% ( 6600, 9900 ] 48 0.008% 100.143% ( 9900, 14000 ] 11 0.002% 100.145% ( 14000, 22000 ] 1 0.000% 100.145% ( 22000, 33000 ] 1 0.000% 100.145% ( 170000, 250000 ] 1 0.000% 100.145% ( 380000, 570000 ] 1 0.000% 100.145% ** Level 3 read latency histogram (micros): Count: 1935818 Average: 12.3450 StdDev: 733.00 Min: 0 Median: 1.9868 Max: 477135 Percentiles: P50: 1.99 P75: 2.99 P99: 10.04 P99.9: 935.76 P99.99: 1506.14 ------------------------------------------------------ [ 0, 1 ] 37152 1.919% 1.919% ( 1, 2 ] 943162 48.722% 50.641% ########## ( 2, 3 ] 476267 24.603% 75.244% ##### ( 3, 4 ] 193787 10.011% 85.254% ## ( 4, 6 ] 218396 11.282% 96.536% ## ( 6, 10 ] 47604 2.459% 98.995% ( 10, 15 ] 12261 0.633% 99.629% ( 15, 22 ] 1365 0.071% 99.699% ( 22, 34 ] 105 0.005% 99.705% ( 34, 51 ] 118 0.006% 99.711% ( 51, 76 ] 174 0.009% 99.720% ( 76, 110 ] 48 0.002% 99.722% ( 110, 170 ] 179 0.009% 99.731% ( 170, 250 ] 265 0.014% 99.745% ( 250, 380 ] 460 0.024% 99.769% ( 380, 580 ] 922 0.048% 99.816% ( 580, 870 ] 1381 0.071% 99.888% ( 870, 1300 ] 1551 0.080% 99.968% ( 1300, 1900 ] 1247 0.064% 100.032% ( 1900, 2900 ] 1134 0.059% 100.091% ( 2900, 4400 ] 1121 0.058% 100.149% ( 4400, 6600 ] 417 0.022% 100.170% ( 6600, 9900 ] 77 0.004% 100.174% ( 9900, 14000 ] 15 0.001% 100.175% ( 14000, 22000 ] 3 0.000% 100.175% ( 22000, 33000 ] 3 0.000% 100.175% ( 170000, 250000 ] 6 0.000% 100.176% ( 250000, 380000 ] 3 0.000% 100.176% ( 380000, 570000 ] 2 0.000% 100.176% ** Level 4 read latency histogram (micros): Count: 1341561 Average: 21.2634 StdDev: 1068.61 Min: 1 Median: 1.9726 Max: 717992 Percentiles: P50: 1.97 P75: 3.00 P99: 189.41 P99.9: 2226.33 P99.99: 3077.21 ------------------------------------------------------ [ 0, 1 ] 29023 2.163% 2.163% ( 1, 2 ] 659820 49.183% 51.346% ########## ( 2, 3 ] 318471 23.739% 75.085% ##### ( 3, 4 ] 130543 9.731% 84.816% ## ( 4, 6 ] 143342 10.685% 95.501% ## ( 6, 10 ] 35537 2.649% 98.150% # ( 10, 15 ] 8932 0.666% 98.815% ( 15, 22 ] 1028 0.077% 98.892% ( 22, 34 ] 94 0.007% 98.899% ( 34, 51 ] 78 0.006% 98.905% ( 51, 76 ] 128 0.010% 98.914% ( 76, 110 ] 96 0.007% 98.921% ( 110, 170 ] 757 0.056% 98.978% ( 170, 250 ] 1226 0.091% 99.069% ( 250, 380 ] 1195 0.089% 99.158% ( 380, 580 ] 2050 0.153% 99.311% ( 580, 870 ] 2727 0.203% 99.514% ( 870, 1300 ] 2760 0.206% 99.720% ( 1300, 1900 ] 1906 0.142% 99.862% ( 1900, 2900 ] 1555 0.116% 99.978% ( 2900, 4400 ] 1353 0.101% 100.079% ( 4400, 6600 ] 480 0.036% 100.115% ( 6600, 9900 ] 70 0.005% 100.120% ( 9900, 14000 ] 7 0.001% 100.121% ( 14000, 22000 ] 6 0.000% 100.121% ( 22000, 33000 ] 1 0.000% 100.121% ( 110000, 170000 ] 1 0.000% 100.121% ( 170000, 250000 ] 3 0.000% 100.121% ( 250000, 380000 ] 1 0.000% 100.121% ( 380000, 570000 ] 3 0.000% 100.122% ( 570000, 860000 ] 1 0.000% 100.122% ** Level 5 read latency histogram (micros): Count: 49346 Average: 1256.1822 StdDev: 6015.08 Min: 84 Median: 710.4070 Max: 480787 Percentiles: P50: 710.41 P75: 1381.59 P99: 6437.33 P99.9: 10827.26 P99.99: 413737.67 ------------------------------------------------------ ( 76, 110 ] 323 0.655% 0.655% ( 110, 170 ] 3719 7.537% 8.191% ## ( 170, 250 ] 5025 10.183% 18.374% ## ( 250, 380 ] 5078 10.291% 28.665% ## ( 380, 580 ] 6882 13.946% 42.611% ### ( 580, 870 ] 8108 16.431% 59.042% ### ( 870, 1300 ] 7271 14.735% 73.777% ### ( 1300, 1900 ] 4438 8.994% 82.771% ## ( 1900, 2900 ] 3254 6.594% 89.365% # ( 2900, 4400 ] 3296 6.679% 96.044% # ( 4400, 6600 ] 1575 3.192% 99.236% # ( 6600, 9900 ] 322 0.653% 99.889% ( 9900, 14000 ] 25 0.051% 99.939% ( 14000, 22000 ] 11 0.022% 99.961% ( 22000, 33000 ] 8 0.016% 99.978% ( 250000, 380000 ] 5 0.010% 99.988% ( 380000, 570000 ] 6 0.012% 100.000% ** DB Stats ** Uptime(secs): 20.9 total, 4.3 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 141.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:9.346 H:M:S, 44.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 228.96 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.567 H:M:S, 13.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/20-05:14:39 ... thread 0: (1000000,4000000) ops and (289661.5,165210.9) ops/second in (3.452306,24.211480) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/9 2.89 GB 144.8 2.6 0.0 2.6 6.3 3.7 0.0 1.7 72.3 177.2 36.59 21.94 60 0.610 2686K 3023 0.0 0.0 L1 4/4 336.70 MB 0.0 1.2 0.9 0.3 1.2 0.9 0.0 1.3 110.8 110.6 11.09 6.37 3 3.695 1247K 1999 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.2 0.1 0.3 0.2 0.4 1.6 134.2 134.1 2.63 1.65 2 1.315 358K 344 0.0 0.0 L3 17/0 947.08 MB 0.9 6.2 2.9 3.3 6.2 2.8 0.1 2.1 104.5 103.5 61.02 31.50 26 2.347 4240K 7125 0.0 0.0 L4 176/0 9.73 GB 1.0 10.2 5.0 5.2 10.0 4.7 0.5 2.0 117.7 115.0 88.64 51.92 53 1.672 4769K 7462 0.0 0.0 L5 1168/0 96.08 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1382/13 109.95 GB 0.0 20.5 9.0 11.6 24.0 12.4 6.4 6.4 105.2 122.9 199.97 113.38 144 1.389 13M 19K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.5 9.0 11.6 24.0 12.4 6.4 6.4 105.2 122.9 199.97 113.38 144 1.389 13M 19K 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 20.5 9.0 11.6 20.2 8.7 0.0 0.0 119.1 117.4 176.67 101.91 93 1.900 13M 19K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 164.9 23.30 11.48 51 0.457 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 24.4 total, 24.2 interval Flush(GB): cumulative 3.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 24.00 GB write, 1007.64 MB/s write, 20.54 GB read, 862.48 MB/s read, 200.0 seconds Interval compaction: 24.00 GB write, 1015.10 MB/s write, 20.54 GB read, 868.86 MB/s read, 200.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 84, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 84, interval: 84 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1168190 Average: 9.5723 StdDev: 379.09 Min: 1 Median: 1.7315 Max: 250326 Percentiles: P50: 1.73 P75: 2.55 P99: 145.28 P99.9: 1118.06 P99.99: 2754.80 ------------------------------------------------------ [ 0, 1 ] 100489 8.602% 8.602% ## ( 1, 2 ] 661151 56.596% 65.198% ########### ( 2, 3 ] 209028 17.893% 83.092% #### ( 3, 4 ] 80326 6.876% 89.968% # ( 4, 6 ] 81167 6.948% 96.916% # ( 6, 10 ] 17066 1.461% 98.377% ( 10, 15 ] 3949 0.338% 98.715% ( 15, 22 ] 392 0.034% 98.748% ( 22, 34 ] 34 0.003% 98.751% ( 34, 51 ] 25 0.002% 98.753% ( 51, 76 ] 43 0.004% 98.757% ( 76, 110 ] 347 0.030% 98.787% ( 110, 170 ] 4237 0.363% 99.149% ( 170, 250 ] 3978 0.341% 99.490% ( 250, 380 ] 1745 0.149% 99.639% ( 380, 580 ] 1574 0.135% 99.774% ( 580, 870 ] 1052 0.090% 99.864% ( 870, 1300 ] 726 0.062% 99.926% ( 1300, 1900 ] 445 0.038% 99.964% ( 1900, 2900 ] 350 0.030% 99.994% ( 2900, 4400 ] 279 0.024% 100.018% ( 4400, 6600 ] 104 0.009% 100.027% ( 6600, 9900 ] 25 0.002% 100.029% ( 9900, 14000 ] 2 0.000% 100.029% ( 14000, 22000 ] 1 0.000% 100.030% ( 170000, 250000 ] 2 0.000% 100.030% ( 250000, 380000 ] 1 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 270304 Average: 10.1432 StdDev: 135.16 Min: 1 Median: 1.9453 Max: 8563 Percentiles: P50: 1.95 P75: 2.93 P99: 12.52 P99.9: 2007.51 P99.99: 4336.05 ------------------------------------------------------ [ 0, 1 ] 6201 2.294% 2.294% ( 1, 2 ] 136407 50.464% 52.758% ########## ( 2, 3 ] 64671 23.925% 76.684% ##### ( 3, 4 ] 25007 9.251% 85.935% ## ( 4, 6 ] 28054 10.379% 96.314% ## ( 6, 10 ] 6490 2.401% 98.715% ( 10, 15 ] 1527 0.565% 99.280% ( 15, 22 ] 192 0.071% 99.351% ( 22, 34 ] 23 0.009% 99.359% ( 34, 51 ] 8 0.003% 99.362% ( 51, 76 ] 12 0.004% 99.367% ( 76, 110 ] 35 0.013% 99.380% ( 110, 170 ] 185 0.068% 99.448% ( 170, 250 ] 215 0.080% 99.528% ( 250, 380 ] 175 0.065% 99.592% ( 380, 580 ] 208 0.077% 99.669% ( 580, 870 ] 255 0.094% 99.764% ( 870, 1300 ] 200 0.074% 99.838% ( 1300, 1900 ] 153 0.057% 99.894% ( 1900, 2900 ] 146 0.054% 99.948% ( 2900, 4400 ] 118 0.044% 99.992% ( 4400, 6600 ] 51 0.019% 100.011% ( 6600, 9900 ] 8 0.003% 100.014% ** Level 2 read latency histogram (micros): Count: 604704 Average: 18.6733 StdDev: 695.51 Min: 1 Median: 1.9697 Max: 475982 Percentiles: P50: 1.97 P75: 3.08 P99: 13.08 P99.9: 2473.92 P99.99: 3149.41 ------------------------------------------------------ [ 0, 1 ] 19199 3.175% 3.175% # ( 1, 2 ] 291998 48.288% 51.463% ########## ( 2, 3 ] 137295 22.704% 74.167% ##### ( 3, 4 ] 61164 10.115% 84.282% ## ( 4, 6 ] 68984 11.408% 95.690% ## ( 6, 10 ] 16879 2.791% 98.481% # ( 10, 15 ] 5097 0.843% 99.324% ( 15, 22 ] 829 0.137% 99.461% ( 22, 34 ] 78 0.013% 99.474% ( 34, 51 ] 27 0.004% 99.478% ( 51, 76 ] 39 0.006% 99.485% ( 76, 110 ] 8 0.001% 99.486% ( 110, 170 ] 23 0.004% 99.490% ( 170, 250 ] 35 0.006% 99.496% ( 250, 380 ] 112 0.019% 99.514% ( 380, 580 ] 230 0.038% 99.552% ( 580, 870 ] 365 0.060% 99.613% ( 870, 1300 ] 509 0.084% 99.697% ( 1300, 1900 ] 667 0.110% 99.807% ( 1900, 2900 ] 978 0.162% 99.969% ( 2900, 4400 ] 767 0.127% 100.096% ( 4400, 6600 ] 237 0.039% 100.135% ( 6600, 9900 ] 48 0.008% 100.143% ( 9900, 14000 ] 11 0.002% 100.145% ( 14000, 22000 ] 1 0.000% 100.145% ( 22000, 33000 ] 1 0.000% 100.145% ( 170000, 250000 ] 1 0.000% 100.145% ( 380000, 570000 ] 1 0.000% 100.145% ** Level 3 read latency histogram (micros): Count: 1959459 Average: 12.3477 StdDev: 728.60 Min: 0 Median: 1.9830 Max: 477135 Percentiles: P50: 1.98 P75: 2.99 P99: 10.34 P99.9: 932.76 P99.99: 1507.05 ------------------------------------------------------ [ 0, 1 ] 38133 1.946% 1.946% ( 1, 2 ] 957866 48.884% 50.830% ########## ( 2, 3 ] 480638 24.529% 75.359% ##### ( 3, 4 ] 194933 9.948% 85.308% ## ( 4, 6 ] 219439 11.199% 96.507% ## ( 6, 10 ] 48013 2.450% 98.957% ( 10, 15 ] 12333 0.629% 99.586% ( 15, 22 ] 1374 0.070% 99.657% ( 22, 34 ] 106 0.005% 99.662% ( 34, 51 ] 118 0.006% 99.668% ( 51, 76 ] 174 0.009% 99.677% ( 76, 110 ] 76 0.004% 99.681% ( 110, 170 ] 485 0.025% 99.705% ( 170, 250 ] 546 0.028% 99.733% ( 250, 380 ] 587 0.030% 99.763% ( 380, 580 ] 1031 0.053% 99.816% ( 580, 870 ] 1420 0.072% 99.888% ( 870, 1300 ] 1559 0.080% 99.968% ( 1300, 1900 ] 1252 0.064% 100.032% ( 1900, 2900 ] 1135 0.058% 100.090% ( 2900, 4400 ] 1121 0.057% 100.147% ( 4400, 6600 ] 417 0.021% 100.168% ( 6600, 9900 ] 77 0.004% 100.172% ( 9900, 14000 ] 15 0.001% 100.173% ( 14000, 22000 ] 3 0.000% 100.173% ( 22000, 33000 ] 3 0.000% 100.173% ( 170000, 250000 ] 6 0.000% 100.174% ( 250000, 380000 ] 3 0.000% 100.174% ( 380000, 570000 ] 2 0.000% 100.174% ** Level 4 read latency histogram (micros): Count: 1371711 Average: 21.9596 StdDev: 1056.98 Min: 1 Median: 1.9716 Max: 717992 Percentiles: P50: 1.97 P75: 3.00 P99: 285.86 P99.9: 2204.81 P99.99: 3069.31 ------------------------------------------------------ [ 0, 1 ] 30155 2.198% 2.198% ( 1, 2 ] 674882 49.200% 51.398% ########## ( 2, 3 ] 323143 23.558% 74.956% ##### ( 3, 4 ] 131838 9.611% 84.567% ## ( 4, 6 ] 144563 10.539% 95.106% ## ( 6, 10 ] 36009 2.625% 97.731% # ( 10, 15 ] 9019 0.658% 98.389% ( 15, 22 ] 1039 0.076% 98.464% ( 22, 34 ] 94 0.007% 98.471% ( 34, 51 ] 78 0.006% 98.477% ( 51, 76 ] 128 0.009% 98.486% ( 76, 110 ] 339 0.025% 98.511% ( 110, 170 ] 2926 0.213% 98.724% ( 170, 250 ] 3217 0.235% 98.959% ( 250, 380 ] 2044 0.149% 99.108% ( 380, 580 ] 2685 0.196% 99.304% ( 580, 870 ] 2982 0.217% 99.521% ( 870, 1300 ] 2809 0.205% 99.726% ( 1300, 1900 ] 1915 0.140% 99.865% ( 1900, 2900 ] 1556 0.113% 99.979% ( 2900, 4400 ] 1354 0.099% 100.078% ( 4400, 6600 ] 480 0.035% 100.113% ( 6600, 9900 ] 70 0.005% 100.118% ( 9900, 14000 ] 7 0.001% 100.118% ( 14000, 22000 ] 6 0.000% 100.119% ( 22000, 33000 ] 1 0.000% 100.119% ( 110000, 170000 ] 1 0.000% 100.119% ( 170000, 250000 ] 3 0.000% 100.119% ( 250000, 380000 ] 1 0.000% 100.119% ( 380000, 570000 ] 3 0.000% 100.119% ( 570000, 860000 ] 1 0.000% 100.119% ** Level 5 read latency histogram (micros): Count: 85444 Average: 830.7425 StdDev: 4599.60 Min: 80 Median: 354.0051 Max: 480787 Percentiles: P50: 354.01 P75: 846.95 P99: 5934.50 P99.9: 9598.24 P99.99: 339845.60 ------------------------------------------------------ ( 76, 110 ] 1598 1.870% 1.870% ( 110, 170 ] 16638 19.472% 21.343% #### ( 170, 250 ] 16404 19.199% 40.541% #### ( 250, 380 ] 10102 11.823% 52.364% ## ( 380, 580 ] 10503 12.292% 64.656% ## ( 580, 870 ] 9601 11.237% 75.893% ## ( 870, 1300 ] 7576 8.867% 84.760% ## ( 1300, 1900 ] 4489 5.254% 90.013% # ( 1900, 2900 ] 3276 3.834% 93.847% # ( 2900, 4400 ] 3304 3.867% 97.714% # ( 4400, 6600 ] 1575 1.843% 99.558% ( 6600, 9900 ] 322 0.377% 99.934% ( 9900, 14000 ] 25 0.029% 99.964% ( 14000, 22000 ] 11 0.013% 99.977% ( 22000, 33000 ] 8 0.009% 99.986% ( 250000, 380000 ] 5 0.006% 99.992% ( 380000, 570000 ] 6 0.007% 99.999% ** DB Stats ** Uptime(secs): 24.4 total, 3.5 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 161.39 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:9.346 H:M:S, 38.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 285.09 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/20-05:14:43 ... thread 0: (1000000,5000000) ops and (234090.7,175541.3) ops/second in (4.271848,28.483328) 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/5 3.87 GB 270.6 3.8 0.0 3.8 8.5 4.7 0.0 1.8 87.3 195.7 44.72 29.45 81 0.552 3965K 4241 0.0 0.0 L1 4/4 336.70 MB 0.0 1.2 0.9 0.3 1.2 0.9 0.0 1.3 110.8 110.6 11.09 6.37 3 3.695 1247K 1999 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.2 0.1 0.3 0.2 0.4 1.6 134.2 134.1 2.63 1.65 2 1.315 358K 344 0.0 0.0 L3 17/0 947.08 MB 0.9 6.2 2.9 3.3 6.2 2.8 0.1 2.1 104.5 103.5 61.02 31.50 26 2.347 4240K 7125 0.0 0.0 L4 176/0 9.73 GB 1.0 10.2 5.0 5.2 10.0 4.7 0.5 2.0 117.7 115.0 88.64 51.92 53 1.672 4769K 7462 0.0 0.0 L5 1168/0 96.08 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1383/9 110.94 GB 0.0 21.8 9.0 12.8 26.2 13.4 6.4 5.5 107.1 129.0 208.10 120.89 165 1.261 14M 21K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.8 9.0 12.8 26.2 13.4 6.4 5.5 107.1 129.0 208.10 120.89 165 1.261 14M 21K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 21.8 9.0 12.8 21.5 8.7 0.0 0.0 122.8 121.1 181.57 106.70 98 1.853 14M 21K 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 182.8 26.53 14.20 67 0.396 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): 28.7 total, 28.5 interval Flush(GB): cumulative 4.737, interval 4.737 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 26.22 GB write, 936.55 MB/s write, 21.78 GB read, 777.90 MB/s read, 208.1 seconds Interval compaction: 26.22 GB write, 942.44 MB/s write, 21.78 GB read, 782.79 MB/s read, 208.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: 84, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 4, total-stops: 84, interval: 88 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1470768 Average: 11.1684 StdDev: 339.21 Min: 0 Median: 1.6770 Max: 250326 Percentiles: P50: 1.68 P75: 2.42 P99: 216.26 P99.9: 881.62 P99.99: 2188.68 ------------------------------------------------------ [ 0, 1 ] 170943 11.623% 11.623% ## ( 1, 2 ] 833800 56.691% 68.314% ########### ( 2, 3 ] 231663 15.751% 84.065% ### ( 3, 4 ] 88419 6.012% 90.077% # ( 4, 6 ] 86660 5.892% 95.969% # ( 6, 10 ] 18085 1.230% 97.199% ( 10, 15 ] 4246 0.289% 97.488% ( 15, 22 ] 440 0.030% 97.517% ( 22, 34 ] 43 0.003% 97.520% ( 34, 51 ] 27 0.002% 97.522% ( 51, 76 ] 46 0.003% 97.525% ( 76, 110 ] 1199 0.082% 97.607% ( 110, 170 ] 13858 0.942% 98.549% ( 170, 250 ] 11467 0.780% 99.329% ( 250, 380 ] 3890 0.264% 99.593% ( 380, 580 ] 2978 0.202% 99.796% ( 580, 870 ] 1512 0.103% 99.899% ( 870, 1300 ] 786 0.053% 99.952% ( 1300, 1900 ] 455 0.031% 99.983% ( 1900, 2900 ] 360 0.024% 100.007% ( 2900, 4400 ] 283 0.019% 100.027% ( 4400, 6600 ] 104 0.007% 100.034% ( 6600, 9900 ] 25 0.002% 100.035% ( 9900, 14000 ] 2 0.000% 100.036% ( 14000, 22000 ] 1 0.000% 100.036% ( 170000, 250000 ] 2 0.000% 100.036% ( 250000, 380000 ] 1 0.000% 100.036% ** Level 1 read latency histogram (micros): Count: 279805 Average: 10.3382 StdDev: 133.22 Min: 1 Median: 1.9691 Max: 8563 Percentiles: P50: 1.97 P75: 2.98 P99: 14.44 P99.9: 1942.43 P99.99: 4323.98 ------------------------------------------------------ [ 0, 1 ] 6253 2.235% 2.235% ( 1, 2 ] 137916 49.290% 51.525% ########## ( 2, 3 ] 66966 23.933% 75.458% ##### ( 3, 4 ] 27004 9.651% 85.109% ## ( 4, 6 ] 30387 10.860% 95.969% ## ( 6, 10 ] 6981 2.495% 98.464% ( 10, 15 ] 1689 0.604% 99.068% ( 15, 22 ] 271 0.097% 99.164% ( 22, 34 ] 38 0.014% 99.178% ( 34, 51 ] 10 0.004% 99.182% ( 51, 76 ] 12 0.004% 99.186% ( 76, 110 ] 62 0.022% 99.208% ( 110, 170 ] 463 0.165% 99.373% ( 170, 250 ] 383 0.137% 99.510% ( 250, 380 ] 228 0.081% 99.592% ( 380, 580 ] 239 0.085% 99.677% ( 580, 870 ] 263 0.094% 99.771% ( 870, 1300 ] 201 0.072% 99.843% ( 1300, 1900 ] 153 0.055% 99.898% ( 1900, 2900 ] 146 0.052% 99.950% ( 2900, 4400 ] 118 0.042% 99.992% ( 4400, 6600 ] 51 0.018% 100.010% ( 6600, 9900 ] 8 0.003% 100.013% ** Level 2 read latency histogram (micros): Count: 604704 Average: 18.6733 StdDev: 695.51 Min: 1 Median: 1.9697 Max: 475982 Percentiles: P50: 1.97 P75: 3.08 P99: 13.08 P99.9: 2473.92 P99.99: 3149.41 ------------------------------------------------------ [ 0, 1 ] 19199 3.175% 3.175% # ( 1, 2 ] 291998 48.288% 51.463% ########## ( 2, 3 ] 137295 22.704% 74.167% ##### ( 3, 4 ] 61164 10.115% 84.282% ## ( 4, 6 ] 68984 11.408% 95.690% ## ( 6, 10 ] 16879 2.791% 98.481% # ( 10, 15 ] 5097 0.843% 99.324% ( 15, 22 ] 829 0.137% 99.461% ( 22, 34 ] 78 0.013% 99.474% ( 34, 51 ] 27 0.004% 99.478% ( 51, 76 ] 39 0.006% 99.485% ( 76, 110 ] 8 0.001% 99.486% ( 110, 170 ] 23 0.004% 99.490% ( 170, 250 ] 35 0.006% 99.496% ( 250, 380 ] 112 0.019% 99.514% ( 380, 580 ] 230 0.038% 99.552% ( 580, 870 ] 365 0.060% 99.613% ( 870, 1300 ] 509 0.084% 99.697% ( 1300, 1900 ] 667 0.110% 99.807% ( 1900, 2900 ] 978 0.162% 99.969% ( 2900, 4400 ] 767 0.127% 100.096% ( 4400, 6600 ] 237 0.039% 100.135% ( 6600, 9900 ] 48 0.008% 100.143% ( 9900, 14000 ] 11 0.002% 100.145% ( 14000, 22000 ] 1 0.000% 100.145% ( 22000, 33000 ] 1 0.000% 100.145% ( 170000, 250000 ] 1 0.000% 100.145% ( 380000, 570000 ] 1 0.000% 100.145% ** Level 3 read latency histogram (micros): Count: 1960905 Average: 12.4897 StdDev: 728.36 Min: 0 Median: 1.9838 Max: 477135 Percentiles: P50: 1.98 P75: 2.99 P99: 10.92 P99.9: 932.87 P99.99: 1507.46 ------------------------------------------------------ [ 0, 1 ] 38133 1.945% 1.945% ( 1, 2 ] 957866 48.848% 50.793% ########## ( 2, 3 ] 480638 24.511% 75.304% ##### ( 3, 4 ] 194933 9.941% 85.245% ## ( 4, 6 ] 219439 11.191% 96.436% ## ( 6, 10 ] 48013 2.449% 98.884% ( 10, 15 ] 12333 0.629% 99.513% ( 15, 22 ] 1374 0.070% 99.583% ( 22, 34 ] 106 0.005% 99.588% ( 34, 51 ] 118 0.006% 99.594% ( 51, 76 ] 174 0.009% 99.603% ( 76, 110 ] 140 0.007% 99.610% ( 110, 170 ] 1127 0.057% 99.668% ( 170, 250 ] 1031 0.053% 99.721% ( 250, 380 ] 739 0.038% 99.758% ( 380, 580 ] 1113 0.057% 99.815% ( 580, 870 ] 1439 0.073% 99.888% ( 870, 1300 ] 1560 0.080% 99.968% ( 1300, 1900 ] 1252 0.064% 100.032% ( 1900, 2900 ] 1135 0.058% 100.090% ( 2900, 4400 ] 1122 0.057% 100.147% ( 4400, 6600 ] 417 0.021% 100.168% ( 6600, 9900 ] 77 0.004% 100.172% ( 9900, 14000 ] 15 0.001% 100.173% ( 14000, 22000 ] 3 0.000% 100.173% ( 22000, 33000 ] 3 0.000% 100.173% ( 170000, 250000 ] 6 0.000% 100.173% ( 250000, 380000 ] 3 0.000% 100.174% ( 380000, 570000 ] 2 0.000% 100.174% ** Level 4 read latency histogram (micros): Count: 1381059 Average: 23.1801 StdDev: 1053.55 Min: 1 Median: 1.9785 Max: 717992 Percentiles: P50: 1.98 P75: 3.06 P99: 342.75 P99.9: 2200.80 P99.99: 3069.26 ------------------------------------------------------ [ 0, 1 ] 30155 2.183% 2.183% ( 1, 2 ] 674896 48.868% 51.051% ########## ( 2, 3 ] 323226 23.404% 74.456% ##### ( 3, 4 ] 131898 9.550% 84.006% ## ( 4, 6 ] 144649 10.474% 94.480% ## ( 6, 10 ] 36020 2.608% 97.088% # ( 10, 15 ] 9021 0.653% 97.741% ( 15, 22 ] 1039 0.075% 97.817% ( 22, 34 ] 94 0.007% 97.823% ( 34, 51 ] 78 0.006% 97.829% ( 51, 76 ] 128 0.009% 97.838% ( 76, 110 ] 724 0.052% 97.891% ( 110, 170 ] 7081 0.513% 98.403% ( 170, 250 ] 6189 0.448% 98.852% ( 250, 380 ] 2874 0.208% 99.060% ( 380, 580 ] 3229 0.234% 99.293% ( 580, 870 ] 3158 0.229% 99.522% ( 870, 1300 ] 2832 0.205% 99.727% ( 1300, 1900 ] 1918 0.139% 99.866% ( 1900, 2900 ] 1559 0.113% 99.979% ( 2900, 4400 ] 1355 0.098% 100.077% ( 4400, 6600 ] 480 0.035% 100.112% ( 6600, 9900 ] 70 0.005% 100.117% ( 9900, 14000 ] 7 0.001% 100.117% ( 14000, 22000 ] 6 0.000% 100.118% ( 22000, 33000 ] 1 0.000% 100.118% ( 110000, 170000 ] 1 0.000% 100.118% ( 170000, 250000 ] 3 0.000% 100.118% ( 250000, 380000 ] 1 0.000% 100.118% ( 380000, 570000 ] 3 0.000% 100.118% ( 570000, 860000 ] 1 0.000% 100.119% ** Level 5 read latency histogram (micros): Count: 136554 Average: 597.1173 StdDev: 3651.75 Min: 80 Median: 228.8510 Max: 480787 Percentiles: P50: 228.85 P75: 538.90 P99: 5220.58 P99.9: 9074.45 P99.99: 30723.82 ------------------------------------------------------ ( 76, 110 ] 3810 2.790% 2.790% # ( 110, 170 ] 40291 29.506% 32.296% ###### ( 170, 250 ] 32864 24.067% 56.362% ##### ( 250, 380 ] 14692 10.759% 67.121% ## ( 380, 580 ] 13541 9.916% 77.038% ## ( 580, 870 ] 10599 7.762% 84.799% ## ( 870, 1300 ] 7698 5.637% 90.437% # ( 1300, 1900 ] 4505 3.299% 93.736% # ( 1900, 2900 ] 3293 2.412% 96.147% ( 2900, 4400 ] 3308 2.422% 98.570% ( 4400, 6600 ] 1575 1.153% 99.723% ( 6600, 9900 ] 322 0.236% 99.959% ( 9900, 14000 ] 25 0.018% 99.977% ( 14000, 22000 ] 11 0.008% 99.985% ( 22000, 33000 ] 8 0.006% 99.991% ( 250000, 380000 ] 5 0.004% 99.995% ( 380000, 570000 ] 6 0.004% 99.999% ** DB Stats ** Uptime(secs): 28.7 total, 4.3 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 171.68 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:10.161 H:M:S, 35.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 230.39 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.815 H:M:S, 19.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/20-05:14:53 ... thread 0: (1000000,6000000) ops and (96919.8,154634.7) ops/second in (10.317805,38.801133) 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/9 4.78 GB 338.8 6.1 0.0 6.1 11.7 5.6 0.0 2.1 110.3 212.6 56.51 40.64 100 0.565 6331K 15K 0.0 0.0 L1 4/4 336.70 MB 0.0 1.2 0.9 0.3 1.2 0.9 0.0 1.3 110.8 110.6 11.09 6.37 3 3.695 1247K 1999 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.2 0.1 0.3 0.2 0.4 1.6 134.2 134.1 2.63 1.65 2 1.315 358K 344 0.0 0.0 L3 17/0 947.08 MB 0.9 6.2 2.9 3.3 6.2 2.8 0.1 2.1 104.5 103.5 61.02 31.50 26 2.347 4240K 7125 0.0 0.0 L4 176/0 9.73 GB 1.0 10.2 5.0 5.2 10.0 4.7 0.5 2.0 117.7 115.0 88.64 51.92 53 1.672 4769K 7462 0.0 0.0 L5 1168/0 96.08 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1383/13 111.85 GB 0.0 24.0 9.0 15.1 29.4 14.3 6.4 5.2 112.0 136.9 219.89 132.09 184 1.195 16M 32K 0.0 0.0 Int 0/0 0.00 KB 0.0 24.0 9.0 15.1 29.4 14.3 6.4 5.2 112.0 136.9 219.89 132.09 184 1.195 16M 32K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 24.0 9.0 15.1 23.7 8.7 0.0 0.0 129.4 127.8 190.30 115.28 102 1.866 16M 32K 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 195.8 29.60 16.80 82 0.361 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): 39.0 total, 38.8 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: 29.40 GB write, 772.37 MB/s write, 24.05 GB read, 631.76 MB/s read, 219.9 seconds Interval compaction: 29.40 GB write, 775.93 MB/s write, 24.05 GB read, 634.68 MB/s read, 219.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 84, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 14, total-stops: 84, interval: 98 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2174675 Average: 13.8676 StdDev: 281.44 Min: 0 Median: 1.5985 Max: 250326 Percentiles: P50: 1.60 P75: 2.21 P99: 239.24 P99.9: 742.02 P99.99: 1426.12 ------------------------------------------------------ [ 0, 1 ] 360909 16.596% 16.596% ### ( 1, 2 ] 1213750 55.813% 72.409% ########### ( 2, 3 ] 272234 12.518% 84.927% ### ( 3, 4 ] 104317 4.797% 89.724% # ( 4, 6 ] 96254 4.426% 94.150% # ( 6, 10 ] 19732 0.907% 95.058% ( 10, 15 ] 4821 0.222% 95.279% ( 15, 22 ] 549 0.025% 95.305% ( 22, 34 ] 56 0.003% 95.307% ( 34, 51 ] 29 0.001% 95.309% ( 51, 76 ] 54 0.002% 95.311% ( 76, 110 ] 4454 0.205% 95.516% ( 110, 170 ] 47915 2.203% 97.719% ( 170, 250 ] 32185 1.480% 99.199% ( 250, 380 ] 8257 0.380% 99.579% ( 380, 580 ] 5736 0.264% 99.843% ( 580, 870 ] 2238 0.103% 99.946% ( 870, 1300 ] 872 0.040% 99.986% ( 1300, 1900 ] 464 0.021% 100.007% ( 1900, 2900 ] 380 0.017% 100.024% ( 2900, 4400 ] 293 0.013% 100.038% ( 4400, 6600 ] 105 0.005% 100.043% ( 6600, 9900 ] 25 0.001% 100.044% ( 9900, 14000 ] 2 0.000% 100.044% ( 14000, 22000 ] 1 0.000% 100.044% ( 170000, 250000 ] 2 0.000% 100.044% ( 250000, 380000 ] 1 0.000% 100.044% ** Level 1 read latency histogram (micros): Count: 305347 Average: 10.7431 StdDev: 128.51 Min: 1 Median: 2.0633 Max: 8563 Percentiles: P50: 2.06 P75: 3.24 P99: 138.31 P99.9: 1831.97 P99.99: 4291.51 ------------------------------------------------------ [ 0, 1 ] 6409 2.099% 2.099% ( 1, 2 ] 141645 46.388% 48.487% ######### ( 2, 3 ] 73012 23.911% 72.398% ##### ( 3, 4 ] 33244 10.887% 83.286% ## ( 4, 6 ] 36470 11.944% 95.229% ## ( 6, 10 ] 8094 2.651% 97.880% # ( 10, 15 ] 2051 0.672% 98.552% ( 15, 22 ] 516 0.169% 98.721% ( 22, 34 ] 64 0.021% 98.742% ( 34, 51 ] 11 0.004% 98.745% ( 51, 76 ] 12 0.004% 98.749% ( 76, 110 ] 148 0.048% 98.798% ( 110, 170 ] 1309 0.429% 99.226% ( 170, 250 ] 832 0.272% 99.499% ( 250, 380 ] 311 0.102% 99.601% ( 380, 580 ] 295 0.097% 99.697% ( 580, 870 ] 278 0.091% 99.788% ( 870, 1300 ] 205 0.067% 99.856% ( 1300, 1900 ] 153 0.050% 99.906% ( 1900, 2900 ] 148 0.048% 99.954% ( 2900, 4400 ] 118 0.039% 99.993% ( 4400, 6600 ] 51 0.017% 100.009% ( 6600, 9900 ] 8 0.003% 100.012% ** Level 2 read latency histogram (micros): Count: 604704 Average: 18.6733 StdDev: 695.51 Min: 1 Median: 1.9697 Max: 475982 Percentiles: P50: 1.97 P75: 3.08 P99: 13.08 P99.9: 2473.92 P99.99: 3149.41 ------------------------------------------------------ [ 0, 1 ] 19199 3.175% 3.175% # ( 1, 2 ] 291998 48.288% 51.463% ########## ( 2, 3 ] 137295 22.704% 74.167% ##### ( 3, 4 ] 61164 10.115% 84.282% ## ( 4, 6 ] 68984 11.408% 95.690% ## ( 6, 10 ] 16879 2.791% 98.481% # ( 10, 15 ] 5097 0.843% 99.324% ( 15, 22 ] 829 0.137% 99.461% ( 22, 34 ] 78 0.013% 99.474% ( 34, 51 ] 27 0.004% 99.478% ( 51, 76 ] 39 0.006% 99.485% ( 76, 110 ] 8 0.001% 99.486% ( 110, 170 ] 23 0.004% 99.490% ( 170, 250 ] 35 0.006% 99.496% ( 250, 380 ] 112 0.019% 99.514% ( 380, 580 ] 230 0.038% 99.552% ( 580, 870 ] 365 0.060% 99.613% ( 870, 1300 ] 509 0.084% 99.697% ( 1300, 1900 ] 667 0.110% 99.807% ( 1900, 2900 ] 978 0.162% 99.969% ( 2900, 4400 ] 767 0.127% 100.096% ( 4400, 6600 ] 237 0.039% 100.135% ( 6600, 9900 ] 48 0.008% 100.143% ( 9900, 14000 ] 11 0.002% 100.145% ( 14000, 22000 ] 1 0.000% 100.145% ( 22000, 33000 ] 1 0.000% 100.145% ( 170000, 250000 ] 1 0.000% 100.145% ( 380000, 570000 ] 1 0.000% 100.145% ** Level 3 read latency histogram (micros): Count: 1964522 Average: 12.8171 StdDev: 727.75 Min: 0 Median: 1.9857 Max: 477135 Percentiles: P50: 1.99 P75: 2.99 P99: 12.37 P99.9: 933.79 P99.99: 1507.77 ------------------------------------------------------ [ 0, 1 ] 38133 1.941% 1.941% ( 1, 2 ] 957866 48.758% 50.699% ########## ( 2, 3 ] 480638 24.466% 75.165% ##### ( 3, 4 ] 194933 9.923% 85.088% ## ( 4, 6 ] 219439 11.170% 96.258% ## ( 6, 10 ] 48013 2.444% 98.702% ( 10, 15 ] 12333 0.628% 99.330% ( 15, 22 ] 1374 0.070% 99.400% ( 22, 34 ] 106 0.005% 99.405% ( 34, 51 ] 118 0.006% 99.411% ( 51, 76 ] 174 0.009% 99.420% ( 76, 110 ] 295 0.015% 99.435% ( 110, 170 ] 3049 0.155% 99.590% ( 170, 250 ] 2146 0.109% 99.699% ( 250, 380 ] 957 0.049% 99.748% ( 380, 580 ] 1271 0.065% 99.813% ( 580, 870 ] 1480 0.075% 99.888% ( 870, 1300 ] 1567 0.080% 99.968% ( 1300, 1900 ] 1252 0.064% 100.032% ( 1900, 2900 ] 1135 0.058% 100.089% ( 2900, 4400 ] 1123 0.057% 100.147% ( 4400, 6600 ] 417 0.021% 100.168% ( 6600, 9900 ] 77 0.004% 100.172% ( 9900, 14000 ] 15 0.001% 100.173% ( 14000, 22000 ] 3 0.000% 100.173% ( 22000, 33000 ] 3 0.000% 100.173% ( 170000, 250000 ] 6 0.000% 100.173% ( 250000, 380000 ] 3 0.000% 100.173% ( 380000, 570000 ] 2 0.000% 100.173% ** Level 4 read latency histogram (micros): Count: 1404676 Average: 25.9330 StdDev: 1044.95 Min: 1 Median: 1.9960 Max: 717992 Percentiles: P50: 2.00 P75: 3.19 P99: 387.38 P99.9: 2187.20 P99.99: 3067.62 ------------------------------------------------------ [ 0, 1 ] 30155 2.147% 2.147% ( 1, 2 ] 674899 48.047% 50.193% ########## ( 2, 3 ] 323237 23.011% 73.205% ##### ( 3, 4 ] 131906 9.390% 82.595% ## ( 4, 6 ] 144658 10.298% 92.894% ## ( 6, 10 ] 36020 2.564% 95.458% # ( 10, 15 ] 9021 0.642% 96.100% ( 15, 22 ] 1039 0.074% 96.174% ( 22, 34 ] 94 0.007% 96.181% ( 34, 51 ] 78 0.006% 96.186% ( 51, 76 ] 128 0.009% 96.195% ( 76, 110 ] 1946 0.139% 96.334% ( 110, 170 ] 19431 1.383% 97.717% ( 170, 250 ] 13507 0.962% 98.679% ( 250, 380 ] 4356 0.310% 98.989% ( 380, 580 ] 4179 0.298% 99.287% ( 580, 870 ] 3391 0.241% 99.528% ( 870, 1300 ] 2855 0.203% 99.731% ( 1300, 1900 ] 1923 0.137% 99.868% ( 1900, 2900 ] 1561 0.111% 99.979% ( 2900, 4400 ] 1356 0.097% 100.076% ( 4400, 6600 ] 480 0.034% 100.110% ( 6600, 9900 ] 70 0.005% 100.115% ( 9900, 14000 ] 7 0.000% 100.115% ( 14000, 22000 ] 6 0.000% 100.116% ( 22000, 33000 ] 1 0.000% 100.116% ( 110000, 170000 ] 1 0.000% 100.116% ( 170000, 250000 ] 3 0.000% 100.116% ( 250000, 380000 ] 1 0.000% 100.116% ( 380000, 570000 ] 3 0.000% 100.116% ( 570000, 860000 ] 1 0.000% 100.117% ** Level 5 read latency histogram (micros): Count: 268049 Average: 396.2929 StdDev: 2615.53 Min: 80 Median: 185.2374 Max: 480787 Percentiles: P50: 185.24 P75: 293.53 P99: 4068.86 P99.9: 7696.08 P99.99: 14869.16 ------------------------------------------------------ ( 76, 110 ] 10587 3.950% 3.950% # ( 110, 170 ] 109473 40.841% 44.790% ######## ( 170, 250 ] 73317 27.352% 72.142% ##### ( 250, 380 ] 22876 8.534% 80.677% ## ( 380, 580 ] 18717 6.983% 87.659% # ( 580, 870 ] 12076 4.505% 92.164% # ( 870, 1300 ] 7883 2.941% 95.105% # ( 1300, 1900 ] 4533 1.691% 96.796% ( 1900, 2900 ] 3328 1.242% 98.038% ( 2900, 4400 ] 3309 1.234% 99.273% ( 4400, 6600 ] 1575 0.588% 99.860% ( 6600, 9900 ] 322 0.120% 99.980% ( 9900, 14000 ] 25 0.009% 99.990% ( 14000, 22000 ] 11 0.004% 99.994% ( 22000, 33000 ] 8 0.003% 99.997% ( 250000, 380000 ] 5 0.002% 99.999% ( 380000, 570000 ] 6 0.002% 100.001% ** DB Stats ** Uptime(secs): 39.0 total, 10.3 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 151.48 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:16.909 H:M:S, 43.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 95.39 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:6.748 H:M:S, 65.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] readwhilewriting : 324.515 micros/op 12298 ops/sec 60.252 seconds 740996 operations; 11.9 MB/s (191999 of 191999 found) Microseconds per read: Count: 740996 Average: 324.5173 StdDev: 1889.76 Min: 1 Median: 206.8403 Max: 480834 Percentiles: P50: 206.84 P75: 259.65 P99: 2180.72 P99.9: 18537.18 P99.99: 41576.48 ------------------------------------------------------ [ 0, 1 ] 1 0.000% 0.000% ( 1, 2 ] 8 0.001% 0.001% ( 2, 3 ] 24 0.003% 0.004% ( 3, 4 ] 41 0.006% 0.010% ( 4, 6 ] 76 0.010% 0.020% ( 6, 10 ] 313 0.042% 0.062% ( 10, 15 ] 2386 0.322% 0.384% ( 15, 22 ] 2635 0.356% 0.740% ( 22, 34 ] 5482 0.740% 1.480% ( 34, 51 ] 1944 0.262% 1.742% ( 51, 76 ] 265 0.036% 1.778% ( 76, 110 ] 2261 0.305% 2.083% ( 110, 170 ] 203017 27.398% 29.481% ##### ( 170, 250 ] 330171 44.558% 74.039% ######### ( 250, 380 ] 95908 12.943% 86.982% ### ( 380, 580 ] 50329 6.792% 93.774% # ( 580, 870 ] 21788 2.940% 96.714% # ( 870, 1300 ] 10875 1.468% 98.182% ( 1300, 1900 ] 5173 0.698% 98.880% ( 1900, 2900 ] 3167 0.427% 99.307% ( 2900, 4400 ] 2644 0.357% 99.664% ( 4400, 6600 ] 990 0.134% 99.798% ( 6600, 9900 ] 187 0.025% 99.823% ( 9900, 14000 ] 211 0.028% 99.852% ( 14000, 22000 ] 633 0.085% 99.937% ( 22000, 33000 ] 348 0.047% 99.984% ( 33000, 50000 ] 89 0.012% 99.996% ( 50000, 75000 ] 16 0.002% 99.998% ( 75000, 110000 ] 2 0.000% 99.998% ( 250000, 380000 ] 5 0.001% 99.999% ( 380000, 570000 ] 7 0.001% 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 : 13142727 rocksdb.bloom.filter.full.positive COUNT : 868624 rocksdb.bloom.filter.full.true.positive COUNT : 740586 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 : 410 rocksdb.memtable.miss COUNT : 740586 rocksdb.l0.hit COUNT : 29929 rocksdb.l1.hit COUNT : 5585 rocksdb.l2andup.hit COUNT : 705072 rocksdb.compaction.key.drop.new COUNT : 338435 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 : 6400043 rocksdb.number.keys.read COUNT : 740996 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 6604844376 rocksdb.bytes.read COUNT : 740996000 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 : 1744 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 36562472 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 : 28443791707 rocksdb.compact.write.bytes COUNT : 28088364006 rocksdb.flush.write.bytes COUNT : 6605810956 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 : 22 rocksdb.number.superversion_acquires COUNT : 1273 rocksdb.number.superversion_releases COUNT : 1242 rocksdb.number.superversion_cleanups COUNT : 319 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 : 355 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 : 6552522752 rocksdb.memtable.garbage.bytes.at.flush COUNT : 2527232 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 : 31683460642 rocksdb.non.last.level.read.count COUNT : 7509815 rocksdb.block.checksum.compute.count COUNT : 7766563 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 : 205.924375 P95 : 699.486792 P99 : 2178.721923 P100 : 480832.000000 COUNT : 740996 SUM : 239771672 rocksdb.db.write.micros P50 : 1.533791 P95 : 3.999789 P99 : 7.611875 P100 : 1826343.000000 COUNT : 6400043 SUM : 52277238 rocksdb.compaction.times.micros P50 : 1550000.000000 P95 : 4712500.000000 P99 : 9635000.000000 P100 : 28619942.000000 COUNT : 105 SUM : 220883158 rocksdb.compaction.times.cpu_micros P50 : 964193.548387 P95 : 2618750.000000 P99 : 6390000.000000 P100 : 11540005.000000 COUNT : 105 SUM : 128757823 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 : 944.782609 P95 : 30250.000000 P99 : 63750.000000 P100 : 69543.000000 COUNT : 90 SUM : 502766 rocksdb.compaction.outfile.sync.micros P50 : 25666.666667 P95 : 174000.000000 P99 : 370250.000000 P100 : 812905.000000 COUNT : 330 SUM : 17623059 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 : 325.000000 P95 : 5335.000000 P99 : 9207.000000 P100 : 257071.000000 COUNT : 221 SUM : 539898 rocksdb.table.open.io.micros P50 : 11653.404255 P95 : 21815.151515 P99 : 30793.888889 P100 : 33613.000000 COUNT : 1744 SUM : 19620003 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.925761 P95 : 9.874578 P99 : 202.516103 P100 : 717995.000000 COUNT : 6886925 SUM : 111814739 rocksdb.read.block.get.micros P50 : 158.016533 P95 : 555.212170 P99 : 2108.391150 P100 : 480793.000000 COUNT : 877908 SUM : 207329794 rocksdb.write.raw.block.micros P50 : 0.530463 P95 : 1.200360 P99 : 3.633857 P100 : 720132.000000 COUNT : 8403107 SUM : 31029278 rocksdb.numfiles.in.singlecompaction P50 : 2.907407 P95 : 5.890000 P99 : 9.752000 P100 : 26.000000 COUNT : 131 SUM : 459 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.565184 P95 : 1224.471154 P99 : 2625.906062 P100 : 1826176.000000 COUNT : 170750 SUM : 36575086 rocksdb.sst.read.micros P50 : 1.968212 P95 : 178.778266 P99 : 507.988457 P100 : 717992.000000 COUNT : 7509866 SUM : 300518240 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 : 1000.000000 P95 : 1000.000000 P99 : 1000.000000 P100 : 1000.000000 COUNT : 740996 SUM : 740996000 rocksdb.bytes.per.write P50 : 1032.000000 P95 : 1032.000000 P99 : 1032.000000 P100 : 1032.000000 COUNT : 6400043 SUM : 6604844376 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 : 229016.393443 P95 : 1001666.666667 P99 : 2000000.000000 P100 : 2084537.000000 COUNT : 90 SUM : 31256409 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 : 355 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