[2024-07-13 19:15:38.155012] Starting SPDK v24.01.1-pre git sha1 4b94202c6 / DPDK 23.11.0 initialization... [2024-07-13 19:15:38.155155] [ 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_pid235653 ] Set seed to 1720890938151693 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-13 19:15:38.255640] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-13 19:15:38.293257] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-13 19:15:38.293305] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 235653' to capture a snapshot of events at runtime. [2024-07-13 19:15:38.293316] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid235653 for offline analysis/debug. [2024-07-13 19:15:38.293338] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sat Jul 13 19:15:42 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/07/13-19:15:45 ... thread 0: (1000000,1000000) ops and (362324.1,362324.1) ops/second in (2.759960,2.759960) 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 355.0 2.31 2.09 12 0.192 0 0 0.0 0.0 L2 3/2 251.77 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.1 2.0 249.9 249.7 1.51 1.46 2 0.756 383K 202 0.0 0.0 L3 11/0 930.42 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 1040/0 85.69 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 1179/8 96.94 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.5 99.0 313.3 3.82 3.55 14 0.273 383K 202 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.3 3.82 3.55 14 0.273 383K 202 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 249.9 249.7 1.51 1.46 2 0.756 383K 202 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 355.0 2.31 2.09 12 0.192 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): 2.9 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, 408.53 MB/s write, 0.37 GB read, 129.03 MB/s read, 3.8 seconds Interval compaction: 1.17 GB write, 433.35 MB/s write, 0.37 GB read, 136.87 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: 1, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 1, interval: 1 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 99510 Average: 1.8134 StdDev: 12.01 Min: 0 Median: 1.1877 Max: 2858 Percentiles: P50: 1.19 P75: 1.64 P99: 3.91 P99.9: 9.87 P99.99: 294.39 ------------------------------------------------------ [ 0, 1 ] 39420 39.614% 39.614% ######## ( 1, 2 ] 55073 55.344% 94.958% ########### ( 2, 3 ] 2951 2.966% 97.924% # ( 3, 4 ] 1172 1.178% 99.102% ( 4, 6 ] 563 0.566% 99.667% ( 6, 10 ] 240 0.241% 99.909% ( 10, 15 ] 51 0.051% 99.960% ( 15, 22 ] 17 0.017% 99.977% ( 110, 170 ] 11 0.011% 99.988% ( 170, 250 ] 1 0.001% 99.989% ( 250, 380 ] 6 0.006% 99.995% ( 580, 870 ] 2 0.002% 99.997% ( 870, 1300 ] 2 0.002% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ( 1900, 2900 ] 1 0.001% 100.001% ** Level 2 read latency histogram (micros): Count: 50339 Average: 1.9325 StdDev: 19.16 Min: 0 Median: 1.2033 Max: 3144 Percentiles: P50: 1.20 P75: 1.65 P99: 4.33 P99.9: 9.36 P99.99: 860.17 ------------------------------------------------------ [ 0, 1 ] 19434 38.606% 38.606% ######## ( 1, 2 ] 28211 56.042% 94.648% ########### ( 2, 3 ] 1414 2.809% 97.457% # ( 3, 4 ] 706 1.402% 98.860% ( 4, 6 ] 423 0.840% 99.700% ( 6, 10 ] 120 0.238% 99.938% ( 10, 15 ] 15 0.030% 99.968% ( 15, 22 ] 5 0.010% 99.978% ( 250, 380 ] 3 0.006% 99.984% ( 380, 580 ] 2 0.004% 99.988% ( 580, 870 ] 1 0.002% 99.990% ( 870, 1300 ] 3 0.006% 99.996% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 50 Average: 1772.4600 StdDev: 1579.02 Min: 75 Median: 1013.3333 Max: 5775 Percentiles: P50: 1013.33 P75: 2837.50 P99: 5775.00 P99.9: 5775.00 P99.99: 5775.00 ------------------------------------------------------ ( 51, 76 ] 1 2.000% 2.000% ( 170, 250 ] 5 10.000% 12.000% ## ( 250, 380 ] 6 12.000% 24.000% ## ( 380, 580 ] 3 6.000% 30.000% # ( 580, 870 ] 9 18.000% 48.000% #### ( 870, 1300 ] 3 6.000% 54.000% # ( 1300, 1900 ] 3 6.000% 60.000% # ( 1900, 2900 ] 8 16.000% 76.000% ### ( 2900, 4400 ] 8 16.000% 92.000% ### ( 4400, 6600 ] 4 8.000% 100.000% ## ** Level 4 read latency histogram (micros): Count: 25 Average: 1512.8000 StdDev: 1280.59 Min: 88 Median: 1350.0000 Max: 4352 Percentiles: P50: 1350.00 P75: 2150.00 P99: 4306.25 P99.9: 4352.00 P99.99: 4352.00 ------------------------------------------------------ ( 76, 110 ] 1 4.000% 4.000% # ( 110, 170 ] 2 8.000% 12.000% ## ( 250, 380 ] 3 12.000% 24.000% ## ( 380, 580 ] 2 8.000% 32.000% ## ( 580, 870 ] 3 12.000% 44.000% ## ( 870, 1300 ] 1 4.000% 48.000% # ( 1300, 1900 ] 6 24.000% 72.000% ##### ( 1900, 2900 ] 3 12.000% 84.000% ## ( 2900, 4400 ] 4 16.000% 100.000% ### ** DB Stats ** Uptime(secs): 2.9 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 335.94 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.219 H:M:S, 7.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 356.30 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.219 H:M:S, 7.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/13-19:15:48 ... thread 0: (1000000,2000000) ops and (327460.0,344011.0) ops/second in (3.053808,5.813768) 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 11/9 1.17 GB 31.5 0.5 0.0 0.5 2.3 1.8 0.0 1.3 71.6 331.2 7.04 6.45 28 0.251 511K 502 0.0 0.0 L1 1/1 3.61 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 237.8 237.4 1.59 1.53 1 1.590 383K 614 0.0 0.0 L2 2/1 54.50 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 249.9 249.7 1.51 1.46 2 0.756 383K 202 0.0 0.0 L3 21/11 1.25 GB 0.3 0.2 0.2 0.0 0.2 0.2 0.4 1.0 231.3 231.3 1.08 1.02 1 1.078 253K 0 0.0 0.0 L4 173/0 9.75 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 150.0 150.1 1.50 1.12 1 1.496 227K 0 0.0 0.0 L5 1040/0 85.69 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 1248/22 97.92 GB 0.0 1.7 1.0 0.7 3.5 2.8 1.1 1.9 136.4 280.0 12.71 11.58 33 0.385 1760K 1318 0.0 0.0 Int 0/0 0.00 KB 0.0 1.7 1.0 0.7 3.5 2.8 1.0 1.9 136.4 280.0 12.71 11.58 33 0.385 1760K 1318 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.7 1.0 0.7 1.7 1.0 0.0 0.0 227.3 227.1 7.63 7.04 7 1.090 1760K 1318 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 359.4 5.08 4.54 26 0.196 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.0 total, 5.8 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.48 GB write, 594.89 MB/s write, 1.69 GB read, 289.77 MB/s read, 12.7 seconds Interval compaction: 3.48 GB write, 612.05 MB/s write, 1.69 GB read, 298.13 MB/s read, 12.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: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 427133 Average: 2.2236 StdDev: 9.01 Min: 0 Median: 1.4900 Max: 2858 Percentiles: P50: 1.49 P75: 1.89 P99: 5.85 P99.9: 11.82 P99.99: 14.97 ------------------------------------------------------ [ 0, 1 ] 82693 19.360% 19.360% #### ( 1, 2 ] 267080 62.529% 81.889% ############# ( 2, 3 ] 40260 9.426% 91.314% ## ( 3, 4 ] 19065 4.463% 95.778% # ( 4, 6 ] 14853 3.477% 99.255% # ( 6, 10 ] 2535 0.593% 99.849% ( 10, 15 ] 610 0.143% 99.991% ( 15, 22 ] 71 0.017% 100.008% ( 22, 34 ] 6 0.001% 100.009% ( 34, 51 ] 4 0.001% 100.010% ( 51, 76 ] 4 0.001% 100.011% ( 110, 170 ] 17 0.004% 100.015% ( 170, 250 ] 6 0.001% 100.017% ( 250, 380 ] 13 0.003% 100.020% ( 380, 580 ] 2 0.000% 100.020% ( 580, 870 ] 8 0.002% 100.022% ( 870, 1300 ] 5 0.001% 100.023% ( 1300, 1900 ] 2 0.000% 100.024% ( 1900, 2900 ] 3 0.001% 100.024% ** Level 1 read latency histogram (micros): Count: 26 Average: 188.1923 StdDev: 395.20 Min: 1 Median: 1.8571 Max: 1776 Percentiles: P50: 1.86 P75: 210.00 P99: 1744.00 P99.9: 1776.00 P99.99: 1776.00 ------------------------------------------------------ [ 0, 1 ] 7 26.923% 26.923% ##### ( 1, 2 ] 7 26.923% 53.846% ##### ( 2, 3 ] 3 11.538% 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 ] 1 3.846% 80.769% # ( 380, 580 ] 3 11.538% 92.308% ## ( 870, 1300 ] 1 3.846% 96.154% # ( 1300, 1900 ] 1 3.846% 100.000% # ** Level 2 read latency histogram (micros): Count: 95623 Average: 2.0482 StdDev: 13.92 Min: 0 Median: 1.3598 Max: 3144 Percentiles: P50: 1.36 P75: 1.77 P99: 5.48 P99.9: 10.09 P99.99: 312.30 ------------------------------------------------------ [ 0, 1 ] 27013 28.249% 28.249% ###### ( 1, 2 ] 57803 60.449% 88.698% ############ ( 2, 3 ] 5319 5.562% 94.261% # ( 3, 4 ] 3055 3.195% 97.456% # ( 4, 6 ] 1994 2.085% 99.541% ( 6, 10 ] 342 0.358% 99.899% ( 10, 15 ] 75 0.078% 99.977% ( 15, 22 ] 10 0.010% 99.987% ( 22, 34 ] 1 0.001% 99.988% ( 250, 380 ] 3 0.003% 99.992% ( 380, 580 ] 2 0.002% 99.994% ( 580, 870 ] 1 0.001% 99.995% ( 870, 1300 ] 3 0.003% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 179422 Average: 3.5267 StdDev: 43.26 Min: 1 Median: 1.6433 Max: 5775 Percentiles: P50: 1.64 P75: 2.24 P99: 8.99 P99.9: 152.72 P99.99: 390.04 ------------------------------------------------------ [ 0, 1 ] 20346 11.340% 11.340% ## ( 1, 2 ] 107832 60.100% 71.439% ############ ( 2, 3 ] 27166 15.141% 86.580% ### ( 3, 4 ] 10524 5.866% 92.446% # ( 4, 6 ] 9459 5.272% 97.718% # ( 6, 10 ] 3080 1.717% 99.434% ( 10, 15 ] 500 0.279% 99.713% ( 15, 22 ] 99 0.055% 99.768% ( 22, 34 ] 23 0.013% 99.781% ( 34, 51 ] 6 0.003% 99.784% ( 51, 76 ] 4 0.002% 99.787% ( 76, 110 ] 70 0.039% 99.826% ( 110, 170 ] 189 0.105% 99.931% ( 170, 250 ] 57 0.032% 99.963% ( 250, 380 ] 48 0.027% 99.989% ( 380, 580 ] 41 0.023% 100.012% ( 580, 870 ] 24 0.013% 100.026% ( 870, 1300 ] 11 0.006% 100.032% ( 1300, 1900 ] 5 0.003% 100.035% ( 1900, 2900 ] 10 0.006% 100.040% ( 2900, 4400 ] 8 0.004% 100.045% ( 4400, 6600 ] 4 0.002% 100.047% ** Level 4 read latency histogram (micros): Count: 310 Average: 128.0419 StdDev: 548.35 Min: 1 Median: 2.5366 Max: 4352 Percentiles: P50: 2.54 P75: 6.82 P99: 3237.50 P99.9: 4283.75 P99.99: 4352.00 ------------------------------------------------------ [ 0, 1 ] 41 13.226% 13.226% ### ( 1, 2 ] 92 29.677% 42.903% ###### ( 2, 3 ] 41 13.226% 56.129% ### ( 3, 4 ] 23 7.419% 63.548% # ( 4, 6 ] 32 10.323% 73.871% ## ( 6, 10 ] 17 5.484% 79.355% # ( 10, 15 ] 17 5.484% 84.839% # ( 15, 22 ] 8 2.581% 87.419% # ( 22, 34 ] 10 3.226% 90.645% # ( 34, 51 ] 1 0.323% 90.968% ( 76, 110 ] 1 0.323% 91.290% ( 110, 170 ] 5 1.613% 92.903% ( 250, 380 ] 3 0.968% 93.871% ( 380, 580 ] 2 0.645% 94.516% ( 580, 870 ] 3 0.968% 95.484% ( 870, 1300 ] 1 0.323% 95.806% ( 1300, 1900 ] 6 1.935% 97.742% ( 1900, 2900 ] 3 0.968% 98.710% ( 2900, 4400 ] 4 1.290% 100.000% ** DB Stats ** Uptime(secs): 6.0 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 328.97 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.613 H:M:S, 10.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 322.28 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.394 H:M:S, 12.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/13-19:15:51 ... thread 0: (1000000,3000000) ops and (304561.3,329772.6) ops/second in (3.283411,9.097179) 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.60 GB 0.0 1.0 0.0 1.0 3.8 2.8 0.0 1.4 86.0 313.4 12.46 11.18 44 0.283 1087K 1086 0.0 0.0 L1 3/3 151.95 MB 0.0 0.9 0.9 0.0 0.9 0.9 0.2 1.0 233.2 232.7 4.07 3.93 2 2.034 962K 1889 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.8 2.0 249.9 249.7 1.51 1.46 2 0.756 383K 202 0.0 0.0 L3 23/0 971.64 MB 1.0 2.0 0.7 1.2 1.9 0.7 0.4 2.8 219.6 219.2 9.10 8.16 6 1.516 2029K 4178 0.0 0.0 L4 173/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 150.0 150.1 1.50 1.12 1 1.496 227K 0 0.0 0.0 L5 1052/0 86.68 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/17 98.90 GB 0.0 4.5 2.0 2.5 7.3 4.8 3.2 2.6 161.3 260.1 28.63 25.86 55 0.521 4691K 7355 0.0 0.0 Int 0/0 0.00 KB 0.0 4.5 2.0 2.5 7.3 4.8 3.1 2.6 161.3 260.1 28.63 25.86 55 0.521 4691K 7355 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.5 2.0 2.5 4.5 2.0 0.0 0.0 225.5 225.2 20.48 18.77 15 1.365 4691K 7355 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.9 8.15 7.09 40 0.204 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.3 total, 9.1 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.27 GB write, 803.63 MB/s write, 4.51 GB read, 498.52 MB/s read, 28.6 seconds Interval compaction: 7.27 GB write, 818.46 MB/s write, 4.51 GB read, 507.71 MB/s read, 28.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 11, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 738801 Average: 2.3068 StdDev: 13.56 Min: 0 Median: 1.5172 Max: 4015 Percentiles: P50: 1.52 P75: 1.92 P99: 5.90 P99.9: 11.51 P99.99: 15.00 ------------------------------------------------------ [ 0, 1 ] 131134 17.750% 17.750% #### ( 1, 2 ] 460666 62.353% 80.103% ############ ( 2, 3 ] 74479 10.081% 90.184% ## ( 3, 4 ] 36830 4.985% 95.169% # ( 4, 6 ] 29797 4.033% 99.202% # ( 6, 10 ] 4870 0.659% 99.861% ( 10, 15 ] 954 0.129% 99.990% ( 15, 22 ] 113 0.015% 100.006% ( 22, 34 ] 7 0.001% 100.007% ( 34, 51 ] 5 0.001% 100.007% ( 51, 76 ] 7 0.001% 100.008% ( 76, 110 ] 10 0.001% 100.010% ( 110, 170 ] 26 0.004% 100.013% ( 170, 250 ] 18 0.002% 100.016% ( 250, 380 ] 20 0.003% 100.018% ( 380, 580 ] 6 0.001% 100.019% ( 580, 870 ] 12 0.002% 100.021% ( 870, 1300 ] 9 0.001% 100.022% ( 1300, 1900 ] 4 0.001% 100.022% ( 1900, 2900 ] 6 0.001% 100.023% ( 2900, 4400 ] 5 0.001% 100.024% ** Level 1 read latency histogram (micros): Count: 201092 Average: 2.9842 StdDev: 21.78 Min: 1 Median: 1.8026 Max: 4015 Percentiles: P50: 1.80 P75: 2.82 P99: 7.73 P99.9: 10.81 P99.99: 13.14 ------------------------------------------------------ [ 0, 1 ] 11716 5.826% 5.826% # ( 1, 2 ] 110681 55.040% 60.866% ########### ( 2, 3 ] 34557 17.185% 78.051% ### ( 3, 4 ] 20040 9.966% 88.016% ## ( 4, 6 ] 20760 10.324% 98.340% ## ( 6, 10 ] 3074 1.529% 99.869% ( 10, 15 ] 388 0.193% 100.062% ( 15, 22 ] 43 0.021% 100.083% ( 22, 34 ] 5 0.002% 100.086% ( 34, 51 ] 1 0.000% 100.086% ( 51, 76 ] 1 0.000% 100.087% ( 76, 110 ] 7 0.003% 100.090% ( 110, 170 ] 18 0.009% 100.099% ( 170, 250 ] 17 0.008% 100.107% ( 250, 380 ] 12 0.006% 100.113% ( 380, 580 ] 8 0.004% 100.117% ( 580, 870 ] 2 0.001% 100.118% ( 870, 1300 ] 4 0.002% 100.120% ( 1300, 1900 ] 3 0.001% 100.122% ( 1900, 2900 ] 1 0.000% 100.122% ( 2900, 4400 ] 5 0.002% 100.125% ** Level 2 read latency histogram (micros): Count: 124245 Average: 2.3579 StdDev: 15.59 Min: 0 Median: 1.4001 Max: 3144 Percentiles: P50: 1.40 P75: 1.81 P99: 5.94 P99.9: 99.24 P99.99: 683.69 ------------------------------------------------------ [ 0, 1 ] 31769 25.570% 25.570% ##### ( 1, 2 ] 75871 61.066% 86.635% ############ ( 2, 3 ] 7920 6.375% 93.010% # ( 3, 4 ] 4521 3.639% 96.649% # ( 4, 6 ] 3015 2.427% 99.075% ( 6, 10 ] 852 0.686% 99.761% ( 10, 15 ] 128 0.103% 99.864% ( 15, 22 ] 11 0.009% 99.873% ( 22, 34 ] 1 0.001% 99.874% ( 51, 76 ] 2 0.002% 99.875% ( 76, 110 ] 45 0.036% 99.911% ( 110, 170 ] 43 0.035% 99.946% ( 170, 250 ] 9 0.007% 99.953% ( 250, 380 ] 27 0.022% 99.975% ( 380, 580 ] 15 0.012% 99.987% ( 580, 870 ] 10 0.008% 99.995% ( 870, 1300 ] 4 0.003% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 271368 Average: 3.7676 StdDev: 44.18 Min: 0 Median: 1.6642 Max: 5775 Percentiles: P50: 1.66 P75: 2.35 P99: 9.23 P99.9: 206.65 P99.99: 579.69 ------------------------------------------------------ [ 0, 1 ] 29788 10.977% 10.977% ## ( 1, 2 ] 159432 58.751% 69.728% ############ ( 2, 3 ] 40330 14.862% 84.590% ### ( 3, 4 ] 18601 6.855% 91.444% # ( 4, 6 ] 16375 6.034% 97.479% # ( 6, 10 ] 5117 1.886% 99.364% ( 10, 15 ] 817 0.301% 99.665% ( 15, 22 ] 125 0.046% 99.711% ( 22, 34 ] 28 0.010% 99.722% ( 34, 51 ] 6 0.002% 99.724% ( 51, 76 ] 5 0.002% 99.726% ( 76, 110 ] 112 0.041% 99.767% ( 110, 170 ] 302 0.111% 99.878% ( 170, 250 ] 128 0.047% 99.926% ( 250, 380 ] 87 0.032% 99.958% ( 380, 580 ] 88 0.032% 99.990% ( 580, 870 ] 45 0.017% 100.007% ( 870, 1300 ] 25 0.009% 100.016% ( 1300, 1900 ] 10 0.004% 100.020% ( 1900, 2900 ] 19 0.007% 100.027% ( 2900, 4400 ] 11 0.004% 100.031% ( 4400, 6600 ] 6 0.002% 100.033% ** Level 4 read latency histogram (micros): Count: 310 Average: 128.0419 StdDev: 548.35 Min: 1 Median: 2.5366 Max: 4352 Percentiles: P50: 2.54 P75: 6.82 P99: 3237.50 P99.9: 4283.75 P99.99: 4352.00 ------------------------------------------------------ [ 0, 1 ] 41 13.226% 13.226% ### ( 1, 2 ] 92 29.677% 42.903% ###### ( 2, 3 ] 41 13.226% 56.129% ### ( 3, 4 ] 23 7.419% 63.548% # ( 4, 6 ] 32 10.323% 73.871% ## ( 6, 10 ] 17 5.484% 79.355% # ( 10, 15 ] 17 5.484% 84.839% # ( 15, 22 ] 8 2.581% 87.419% # ( 22, 34 ] 10 3.226% 90.645% # ( 34, 51 ] 1 0.323% 90.968% ( 76, 110 ] 1 0.323% 91.290% ( 110, 170 ] 5 1.613% 92.903% ( 250, 380 ] 3 0.968% 93.871% ( 380, 580 ] 2 0.645% 94.516% ( 580, 870 ] 3 0.968% 95.484% ( 870, 1300 ] 1 0.323% 95.806% ( 1300, 1900 ] 6 1.935% 97.742% ( 1900, 2900 ] 3 0.968% 98.710% ( 2900, 4400 ] 4 1.290% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 819.1333 StdDev: 1042.03 Min: 77 Median: 341.0000 Max: 5171 Percentiles: P50: 341.00 P75: 1013.33 P99: 5171.00 P99.9: 5171.00 P99.99: 5171.00 ------------------------------------------------------ ( 76, 110 ] 7 11.667% 11.667% ## ( 110, 170 ] 14 23.333% 35.000% ##### ( 170, 250 ] 2 3.333% 38.333% # ( 250, 380 ] 10 16.667% 55.000% ### ( 380, 580 ] 8 13.333% 68.333% ### ( 580, 870 ] 3 5.000% 73.333% # ( 870, 1300 ] 3 5.000% 78.333% # ( 1300, 1900 ] 3 5.000% 83.333% # ( 1900, 2900 ] 8 13.333% 96.667% ### ( 2900, 4400 ] 1 1.667% 98.333% ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 9.3 total, 3.3 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 318.61 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.228 H:M:S, 13.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 299.75 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.615 H:M:S, 18.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/13-19:15:54 ... thread 0: (1000000,4000000) ops and (332957.9,330563.2) ops/second in (3.003383,12.100562) 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/10 2.52 GB 125.9 2.2 0.0 2.2 5.8 3.7 0.0 1.6 113.7 308.6 19.39 17.74 61 0.318 2238K 2281 0.0 0.0 L1 3/3 151.95 MB 0.0 0.9 0.9 0.0 0.9 0.9 0.2 1.0 233.2 232.7 4.07 3.93 2 2.034 962K 1889 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.8 2.0 249.9 249.7 1.51 1.46 2 0.756 383K 202 0.0 0.0 L3 23/0 971.64 MB 1.0 2.0 0.7 1.2 1.9 0.7 0.4 2.8 219.6 219.2 9.10 8.16 6 1.516 2029K 4178 0.0 0.0 L4 173/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 150.0 150.1 1.50 1.12 1 1.496 227K 0 0.0 0.0 L5 1052/0 86.68 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 1266/13 99.82 GB 0.0 5.6 2.0 3.6 9.3 5.7 3.2 2.5 161.8 267.9 35.56 32.41 72 0.494 5842K 8550 0.0 0.0 Int 0/0 0.00 KB 0.0 5.6 2.0 3.6 9.3 5.7 3.1 2.5 161.8 267.9 35.56 32.41 72 0.494 5842K 8550 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.6 2.0 3.6 5.6 2.0 0.0 0.0 232.4 232.1 24.75 22.94 19 1.303 5842K 8550 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.8 10.81 9.47 53 0.204 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.3 total, 12.1 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.30 GB write, 776.25 MB/s write, 5.62 GB read, 468.91 MB/s read, 35.6 seconds Interval compaction: 9.30 GB write, 787.02 MB/s write, 5.62 GB read, 475.41 MB/s read, 35.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 1121152 Average: 2.2859 StdDev: 12.62 Min: 0 Median: 1.5100 Max: 4015 Percentiles: P50: 1.51 P75: 1.90 P99: 5.88 P99.9: 11.31 P99.99: 14.80 ------------------------------------------------------ [ 0, 1 ] 194719 17.368% 17.368% ### ( 1, 2 ] 717351 63.983% 81.351% ############# ( 2, 3 ] 108904 9.714% 91.065% ## ( 3, 4 ] 51870 4.626% 95.691% # ( 4, 6 ] 39484 3.522% 99.213% # ( 6, 10 ] 7327 0.654% 99.866% ( 10, 15 ] 1445 0.129% 99.995% ( 15, 22 ] 135 0.012% 100.007% ( 22, 34 ] 11 0.001% 100.008% ( 34, 51 ] 7 0.001% 100.009% ( 51, 76 ] 9 0.001% 100.010% ( 76, 110 ] 49 0.004% 100.014% ( 110, 170 ] 58 0.005% 100.019% ( 170, 250 ] 39 0.003% 100.023% ( 250, 380 ] 30 0.003% 100.026% ( 380, 580 ] 17 0.002% 100.027% ( 580, 870 ] 19 0.002% 100.029% ( 870, 1300 ] 17 0.002% 100.030% ( 1300, 1900 ] 5 0.000% 100.031% ( 1900, 2900 ] 8 0.001% 100.031% ( 2900, 4400 ] 6 0.001% 100.032% ** Level 1 read latency histogram (micros): Count: 228339 Average: 3.0102 StdDev: 21.34 Min: 1 Median: 1.7624 Max: 4015 Percentiles: P50: 1.76 P75: 2.72 P99: 7.92 P99.9: 12.46 P99.99: 14.82 ------------------------------------------------------ [ 0, 1 ] 16092 7.047% 7.047% # ( 1, 2 ] 128638 56.336% 63.384% ########### ( 2, 3 ] 37094 16.245% 79.629% ### ( 3, 4 ] 21024 9.207% 88.836% ## ( 4, 6 ] 21510 9.420% 98.257% ## ( 6, 10 ] 3538 1.549% 99.806% ( 10, 15 ] 436 0.191% 99.997% ( 15, 22 ] 47 0.021% 100.018% ( 22, 34 ] 5 0.002% 100.020% ( 34, 51 ] 1 0.000% 100.020% ( 51, 76 ] 1 0.000% 100.021% ( 76, 110 ] 23 0.010% 100.031% ( 110, 170 ] 78 0.034% 100.065% ( 170, 250 ] 41 0.018% 100.083% ( 250, 380 ] 23 0.010% 100.093% ( 380, 580 ] 17 0.007% 100.100% ( 580, 870 ] 9 0.004% 100.104% ( 870, 1300 ] 4 0.002% 100.106% ( 1300, 1900 ] 3 0.001% 100.107% ( 1900, 2900 ] 1 0.000% 100.108% ( 2900, 4400 ] 5 0.002% 100.110% ** Level 2 read latency histogram (micros): Count: 124245 Average: 2.3579 StdDev: 15.59 Min: 0 Median: 1.4001 Max: 3144 Percentiles: P50: 1.40 P75: 1.81 P99: 5.94 P99.9: 99.24 P99.99: 683.69 ------------------------------------------------------ [ 0, 1 ] 31769 25.570% 25.570% ##### ( 1, 2 ] 75871 61.066% 86.635% ############ ( 2, 3 ] 7920 6.375% 93.010% # ( 3, 4 ] 4521 3.639% 96.649% # ( 4, 6 ] 3015 2.427% 99.075% ( 6, 10 ] 852 0.686% 99.761% ( 10, 15 ] 128 0.103% 99.864% ( 15, 22 ] 11 0.009% 99.873% ( 22, 34 ] 1 0.001% 99.874% ( 51, 76 ] 2 0.002% 99.875% ( 76, 110 ] 45 0.036% 99.911% ( 110, 170 ] 43 0.035% 99.946% ( 170, 250 ] 9 0.007% 99.953% ( 250, 380 ] 27 0.022% 99.975% ( 380, 580 ] 15 0.012% 99.987% ( 580, 870 ] 10 0.008% 99.995% ( 870, 1300 ] 4 0.003% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 271368 Average: 3.7676 StdDev: 44.18 Min: 0 Median: 1.6642 Max: 5775 Percentiles: P50: 1.66 P75: 2.35 P99: 9.23 P99.9: 206.65 P99.99: 579.69 ------------------------------------------------------ [ 0, 1 ] 29788 10.977% 10.977% ## ( 1, 2 ] 159432 58.751% 69.728% ############ ( 2, 3 ] 40330 14.862% 84.590% ### ( 3, 4 ] 18601 6.855% 91.444% # ( 4, 6 ] 16375 6.034% 97.479% # ( 6, 10 ] 5117 1.886% 99.364% ( 10, 15 ] 817 0.301% 99.665% ( 15, 22 ] 125 0.046% 99.711% ( 22, 34 ] 28 0.010% 99.722% ( 34, 51 ] 6 0.002% 99.724% ( 51, 76 ] 5 0.002% 99.726% ( 76, 110 ] 112 0.041% 99.767% ( 110, 170 ] 302 0.111% 99.878% ( 170, 250 ] 128 0.047% 99.926% ( 250, 380 ] 87 0.032% 99.958% ( 380, 580 ] 88 0.032% 99.990% ( 580, 870 ] 45 0.017% 100.007% ( 870, 1300 ] 25 0.009% 100.016% ( 1300, 1900 ] 10 0.004% 100.020% ( 1900, 2900 ] 19 0.007% 100.027% ( 2900, 4400 ] 11 0.004% 100.031% ( 4400, 6600 ] 6 0.002% 100.033% ** Level 4 read latency histogram (micros): Count: 310 Average: 128.0419 StdDev: 548.35 Min: 1 Median: 2.5366 Max: 4352 Percentiles: P50: 2.54 P75: 6.82 P99: 3237.50 P99.9: 4283.75 P99.99: 4352.00 ------------------------------------------------------ [ 0, 1 ] 41 13.226% 13.226% ### ( 1, 2 ] 92 29.677% 42.903% ###### ( 2, 3 ] 41 13.226% 56.129% ### ( 3, 4 ] 23 7.419% 63.548% # ( 4, 6 ] 32 10.323% 73.871% ## ( 6, 10 ] 17 5.484% 79.355% # ( 10, 15 ] 17 5.484% 84.839% # ( 15, 22 ] 8 2.581% 87.419% # ( 22, 34 ] 10 3.226% 90.645% # ( 34, 51 ] 1 0.323% 90.968% ( 76, 110 ] 1 0.323% 91.290% ( 110, 170 ] 5 1.613% 92.903% ( 250, 380 ] 3 0.968% 93.871% ( 380, 580 ] 2 0.645% 94.516% ( 580, 870 ] 3 0.968% 95.484% ( 870, 1300 ] 1 0.323% 95.806% ( 1300, 1900 ] 6 1.935% 97.742% ( 1900, 2900 ] 3 0.968% 98.710% ( 2900, 4400 ] 4 1.290% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 819.1333 StdDev: 1042.03 Min: 77 Median: 341.0000 Max: 5171 Percentiles: P50: 341.00 P75: 1013.33 P99: 5171.00 P99.9: 5171.00 P99.99: 5171.00 ------------------------------------------------------ ( 76, 110 ] 7 11.667% 11.667% ## ( 110, 170 ] 14 23.333% 35.000% ##### ( 170, 250 ] 2 3.333% 38.333% # ( 250, 380 ] 10 16.667% 55.000% ### ( 380, 580 ] 8 13.333% 68.333% ### ( 580, 870 ] 3 5.000% 73.333% # ( 870, 1300 ] 3 5.000% 78.333% # ( 1300, 1900 ] 3 5.000% 83.333% # ( 1900, 2900 ] 8 13.333% 96.667% ### ( 2900, 4400 ] 1 1.667% 98.333% ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 12.3 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 320.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:1.638 H:M:S, 13.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 327.69 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.410 H:M:S, 13.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/13-19:15:57 ... thread 0: (1000000,5000000) ops and (335334.5,331506.5) ops/second in (2.982097,15.082659) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/13 2.46 GB 44.1 2.6 0.0 2.6 7.3 4.7 0.0 1.6 112.8 312.0 24.02 22.05 77 0.312 2750K 2790 0.0 0.0 L1 11/11 1.19 GB 0.0 2.1 2.0 0.2 2.1 2.0 0.2 1.1 231.0 230.1 9.39 9.04 3 3.132 2203K 8138 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.8 2.0 249.9 249.7 1.51 1.46 2 0.756 383K 202 0.0 0.0 L3 23/0 971.64 MB 1.0 2.0 0.7 1.2 1.9 0.7 0.4 2.8 219.6 219.2 9.10 8.16 6 1.516 2029K 4178 0.0 0.0 L4 173/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 150.0 150.1 1.50 1.12 1 1.496 227K 0 0.0 0.0 L5 1052/0 86.68 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 1276/24 100.80 GB 0.0 7.3 3.1 4.2 12.0 7.7 3.2 2.6 164.3 269.2 45.52 41.83 89 0.511 7595K 15K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.3 3.1 4.2 12.0 7.7 3.1 2.6 164.3 269.2 45.52 41.83 89 0.511 7595K 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 7.3 3.1 4.2 7.3 3.1 0.0 0.0 234.4 233.9 31.92 29.86 22 1.451 7595K 15K 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 352.0 13.60 11.98 67 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): 15.3 total, 15.1 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.96 GB write, 803.27 MB/s write, 7.30 GB read, 490.39 MB/s read, 45.5 seconds Interval compaction: 11.96 GB write, 812.21 MB/s write, 7.30 GB read, 495.85 MB/s read, 45.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: 19, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 19, interval: 19 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1383027 Average: 2.2555 StdDev: 12.76 Min: 0 Median: 1.4921 Max: 4015 Percentiles: P50: 1.49 P75: 1.88 P99: 5.82 P99.9: 11.13 P99.99: 14.96 ------------------------------------------------------ [ 0, 1 ] 252123 18.230% 18.230% #### ( 1, 2 ] 892908 64.562% 82.792% ############# ( 2, 3 ] 125903 9.103% 91.895% ## ( 3, 4 ] 58953 4.263% 96.158% # ( 4, 6 ] 43183 3.122% 99.280% # ( 6, 10 ] 8207 0.593% 99.873% ( 10, 15 ] 1625 0.117% 99.991% ( 15, 22 ] 147 0.011% 100.002% ( 22, 34 ] 12 0.001% 100.002% ( 34, 51 ] 9 0.001% 100.003% ( 51, 76 ] 10 0.001% 100.004% ( 76, 110 ] 66 0.005% 100.009% ( 110, 170 ] 84 0.006% 100.015% ( 170, 250 ] 54 0.004% 100.019% ( 250, 380 ] 43 0.003% 100.022% ( 380, 580 ] 28 0.002% 100.024% ( 580, 870 ] 30 0.002% 100.026% ( 870, 1300 ] 21 0.002% 100.027% ( 1300, 1900 ] 6 0.000% 100.028% ( 1900, 2900 ] 9 0.001% 100.028% ( 2900, 4400 ] 8 0.001% 100.029% ** Level 1 read latency histogram (micros): Count: 286912 Average: 2.9615 StdDev: 21.17 Min: 0 Median: 1.6883 Max: 4015 Percentiles: P50: 1.69 P75: 2.47 P99: 7.99 P99.9: 13.90 P99.99: 120.76 ------------------------------------------------------ [ 0, 1 ] 28026 9.768% 9.768% ## ( 1, 2 ] 167706 58.452% 68.220% ############ ( 2, 3 ] 41181 14.353% 82.573% ### ( 3, 4 ] 22570 7.867% 90.440% ## ( 4, 6 ] 22380 7.800% 98.240% ## ( 6, 10 ] 4389 1.530% 99.770% ( 10, 15 ] 480 0.167% 99.937% ( 15, 22 ] 51 0.018% 99.955% ( 22, 34 ] 5 0.002% 99.957% ( 34, 51 ] 1 0.000% 99.957% ( 51, 76 ] 1 0.000% 99.957% ( 76, 110 ] 71 0.025% 99.982% ( 110, 170 ] 130 0.045% 100.028% ( 170, 250 ] 70 0.024% 100.052% ( 250, 380 ] 43 0.015% 100.067% ( 380, 580 ] 25 0.009% 100.076% ( 580, 870 ] 14 0.005% 100.081% ( 870, 1300 ] 8 0.003% 100.083% ( 1300, 1900 ] 6 0.002% 100.085% ( 1900, 2900 ] 2 0.001% 100.086% ( 2900, 4400 ] 5 0.002% 100.088% ** Level 2 read latency histogram (micros): Count: 124245 Average: 2.3579 StdDev: 15.59 Min: 0 Median: 1.4001 Max: 3144 Percentiles: P50: 1.40 P75: 1.81 P99: 5.94 P99.9: 99.24 P99.99: 683.69 ------------------------------------------------------ [ 0, 1 ] 31769 25.570% 25.570% ##### ( 1, 2 ] 75871 61.066% 86.635% ############ ( 2, 3 ] 7920 6.375% 93.010% # ( 3, 4 ] 4521 3.639% 96.649% # ( 4, 6 ] 3015 2.427% 99.075% ( 6, 10 ] 852 0.686% 99.761% ( 10, 15 ] 128 0.103% 99.864% ( 15, 22 ] 11 0.009% 99.873% ( 22, 34 ] 1 0.001% 99.874% ( 51, 76 ] 2 0.002% 99.875% ( 76, 110 ] 45 0.036% 99.911% ( 110, 170 ] 43 0.035% 99.946% ( 170, 250 ] 9 0.007% 99.953% ( 250, 380 ] 27 0.022% 99.975% ( 380, 580 ] 15 0.012% 99.987% ( 580, 870 ] 10 0.008% 99.995% ( 870, 1300 ] 4 0.003% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 271368 Average: 3.7676 StdDev: 44.18 Min: 0 Median: 1.6642 Max: 5775 Percentiles: P50: 1.66 P75: 2.35 P99: 9.23 P99.9: 206.65 P99.99: 579.69 ------------------------------------------------------ [ 0, 1 ] 29788 10.977% 10.977% ## ( 1, 2 ] 159432 58.751% 69.728% ############ ( 2, 3 ] 40330 14.862% 84.590% ### ( 3, 4 ] 18601 6.855% 91.444% # ( 4, 6 ] 16375 6.034% 97.479% # ( 6, 10 ] 5117 1.886% 99.364% ( 10, 15 ] 817 0.301% 99.665% ( 15, 22 ] 125 0.046% 99.711% ( 22, 34 ] 28 0.010% 99.722% ( 34, 51 ] 6 0.002% 99.724% ( 51, 76 ] 5 0.002% 99.726% ( 76, 110 ] 112 0.041% 99.767% ( 110, 170 ] 302 0.111% 99.878% ( 170, 250 ] 128 0.047% 99.926% ( 250, 380 ] 87 0.032% 99.958% ( 380, 580 ] 88 0.032% 99.990% ( 580, 870 ] 45 0.017% 100.007% ( 870, 1300 ] 25 0.009% 100.016% ( 1300, 1900 ] 10 0.004% 100.020% ( 1900, 2900 ] 19 0.007% 100.027% ( 2900, 4400 ] 11 0.004% 100.031% ( 4400, 6600 ] 6 0.002% 100.033% ** Level 4 read latency histogram (micros): Count: 310 Average: 128.0419 StdDev: 548.35 Min: 1 Median: 2.5366 Max: 4352 Percentiles: P50: 2.54 P75: 6.82 P99: 3237.50 P99.9: 4283.75 P99.99: 4352.00 ------------------------------------------------------ [ 0, 1 ] 41 13.226% 13.226% ### ( 1, 2 ] 92 29.677% 42.903% ###### ( 2, 3 ] 41 13.226% 56.129% ### ( 3, 4 ] 23 7.419% 63.548% # ( 4, 6 ] 32 10.323% 73.871% ## ( 6, 10 ] 17 5.484% 79.355% # ( 10, 15 ] 17 5.484% 84.839% # ( 15, 22 ] 8 2.581% 87.419% # ( 22, 34 ] 10 3.226% 90.645% # ( 34, 51 ] 1 0.323% 90.968% ( 76, 110 ] 1 0.323% 91.290% ( 110, 170 ] 5 1.613% 92.903% ( 250, 380 ] 3 0.968% 93.871% ( 380, 580 ] 2 0.645% 94.516% ( 580, 870 ] 3 0.968% 95.484% ( 870, 1300 ] 1 0.323% 95.806% ( 1300, 1900 ] 6 1.935% 97.742% ( 1900, 2900 ] 3 0.968% 98.710% ( 2900, 4400 ] 4 1.290% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 819.1333 StdDev: 1042.03 Min: 77 Median: 341.0000 Max: 5171 Percentiles: P50: 341.00 P75: 1013.33 P99: 5171.00 P99.9: 5171.00 P99.99: 5171.00 ------------------------------------------------------ ( 76, 110 ] 7 11.667% 11.667% ## ( 110, 170 ] 14 23.333% 35.000% ##### ( 170, 250 ] 2 3.333% 38.333% # ( 250, 380 ] 10 16.667% 55.000% ### ( 380, 580 ] 8 13.333% 68.333% ### ( 580, 870 ] 3 5.000% 73.333% # ( 870, 1300 ] 3 5.000% 78.333% # ( 1300, 1900 ] 3 5.000% 83.333% # ( 1900, 2900 ] 8 13.333% 96.667% ### ( 2900, 4400 ] 1 1.667% 98.333% ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 15.3 total, 3.0 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 322.63 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.069 H:M:S, 13.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 330.03 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.431 H:M:S, 14.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/13-19:16:01 ... thread 0: (1000000,6000000) ops and (277632.8,321121.1) ops/second in (3.601880,18.684539) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/13 3.44 GB 151.0 3.8 0.0 3.8 9.4 5.7 0.0 1.7 123.4 309.3 31.15 28.81 95 0.328 3901K 4033 0.0 0.0 L1 11/11 1.19 GB 0.0 2.1 2.0 0.2 2.1 2.0 0.2 1.1 231.0 230.1 9.39 9.04 3 3.132 2203K 8138 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.8 2.0 249.9 249.7 1.51 1.46 2 0.756 383K 202 0.0 0.0 L3 23/0 971.64 MB 1.0 2.0 0.7 1.2 1.9 0.7 0.4 2.8 219.6 219.2 9.10 8.16 6 1.516 2029K 4178 0.0 0.0 L4 173/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 150.0 150.1 1.50 1.12 1 1.496 227K 0 0.0 0.0 L5 1052/0 86.68 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 1278/24 101.78 GB 0.0 8.4 3.1 5.3 14.1 8.7 3.2 2.5 163.6 273.3 52.65 48.59 107 0.492 8746K 16K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.4 3.1 5.3 14.1 8.7 3.1 2.5 163.6 273.3 52.65 48.59 107 0.492 8746K 16K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 8.4 3.1 5.3 8.4 3.1 0.0 0.0 237.9 237.4 36.21 34.05 26 1.393 8746K 16K 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.4 16.45 14.55 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): 18.9 total, 18.7 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.05 GB write, 763.35 MB/s write, 8.41 GB read, 456.85 MB/s read, 52.7 seconds Interval compaction: 14.05 GB write, 770.20 MB/s write, 8.41 GB read, 460.96 MB/s read, 52.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 3, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 3, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 21, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 21, interval: 24 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1759791 Average: 2.2622 StdDev: 12.42 Min: 0 Median: 1.4901 Max: 4015 Percentiles: P50: 1.49 P75: 1.87 P99: 5.81 P99.9: 11.43 P99.99: 20.01 ------------------------------------------------------ [ 0, 1 ] 318619 18.106% 18.106% #### ( 1, 2 ] 1145136 65.072% 83.178% ############# ( 2, 3 ] 158892 9.029% 92.207% ## ( 3, 4 ] 72686 4.130% 96.337% # ( 4, 6 ] 51682 2.937% 99.274% # ( 6, 10 ] 10441 0.593% 99.867% ( 10, 15 ] 2025 0.115% 99.982% ( 15, 22 ] 190 0.011% 99.993% ( 22, 34 ] 19 0.001% 99.994% ( 34, 51 ] 9 0.001% 99.995% ( 51, 76 ] 12 0.001% 99.995% ( 76, 110 ] 120 0.007% 100.002% ( 110, 170 ] 190 0.011% 100.013% ( 170, 250 ] 96 0.005% 100.019% ( 250, 380 ] 71 0.004% 100.023% ( 380, 580 ] 52 0.003% 100.026% ( 580, 870 ] 41 0.002% 100.028% ( 870, 1300 ] 26 0.001% 100.029% ( 1300, 1900 ] 8 0.000% 100.030% ( 1900, 2900 ] 9 0.001% 100.030% ( 2900, 4400 ] 10 0.001% 100.031% ** Level 1 read latency histogram (micros): Count: 362533 Average: 2.8662 StdDev: 19.75 Min: 0 Median: 1.6446 Max: 4015 Percentiles: P50: 1.64 P75: 2.27 P99: 8.06 P99.9: 14.67 P99.99: 144.97 ------------------------------------------------------ [ 0, 1 ] 40189 11.086% 11.086% ## ( 1, 2 ] 218875 60.374% 71.459% ############ ( 2, 3 ] 47819 13.190% 84.650% ### ( 3, 4 ] 25083 6.919% 91.568% # ( 4, 6 ] 24057 6.636% 98.204% # ( 6, 10 ] 5597 1.544% 99.748% ( 10, 15 ] 589 0.162% 99.911% ( 15, 22 ] 65 0.018% 99.929% ( 22, 34 ] 5 0.001% 99.930% ( 34, 51 ] 1 0.000% 99.930% ( 51, 76 ] 2 0.001% 99.931% ( 76, 110 ] 111 0.031% 99.961% ( 110, 170 ] 178 0.049% 100.010% ( 170, 250 ] 89 0.025% 100.035% ( 250, 380 ] 53 0.015% 100.050% ( 380, 580 ] 32 0.009% 100.058% ( 580, 870 ] 17 0.005% 100.063% ( 870, 1300 ] 8 0.002% 100.065% ( 1300, 1900 ] 6 0.002% 100.067% ( 1900, 2900 ] 3 0.001% 100.068% ( 2900, 4400 ] 5 0.001% 100.069% ** Level 2 read latency histogram (micros): Count: 124245 Average: 2.3579 StdDev: 15.59 Min: 0 Median: 1.4001 Max: 3144 Percentiles: P50: 1.40 P75: 1.81 P99: 5.94 P99.9: 99.24 P99.99: 683.69 ------------------------------------------------------ [ 0, 1 ] 31769 25.570% 25.570% ##### ( 1, 2 ] 75871 61.066% 86.635% ############ ( 2, 3 ] 7920 6.375% 93.010% # ( 3, 4 ] 4521 3.639% 96.649% # ( 4, 6 ] 3015 2.427% 99.075% ( 6, 10 ] 852 0.686% 99.761% ( 10, 15 ] 128 0.103% 99.864% ( 15, 22 ] 11 0.009% 99.873% ( 22, 34 ] 1 0.001% 99.874% ( 51, 76 ] 2 0.002% 99.875% ( 76, 110 ] 45 0.036% 99.911% ( 110, 170 ] 43 0.035% 99.946% ( 170, 250 ] 9 0.007% 99.953% ( 250, 380 ] 27 0.022% 99.975% ( 380, 580 ] 15 0.012% 99.987% ( 580, 870 ] 10 0.008% 99.995% ( 870, 1300 ] 4 0.003% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 271368 Average: 3.7676 StdDev: 44.18 Min: 0 Median: 1.6642 Max: 5775 Percentiles: P50: 1.66 P75: 2.35 P99: 9.23 P99.9: 206.65 P99.99: 579.69 ------------------------------------------------------ [ 0, 1 ] 29788 10.977% 10.977% ## ( 1, 2 ] 159432 58.751% 69.728% ############ ( 2, 3 ] 40330 14.862% 84.590% ### ( 3, 4 ] 18601 6.855% 91.444% # ( 4, 6 ] 16375 6.034% 97.479% # ( 6, 10 ] 5117 1.886% 99.364% ( 10, 15 ] 817 0.301% 99.665% ( 15, 22 ] 125 0.046% 99.711% ( 22, 34 ] 28 0.010% 99.722% ( 34, 51 ] 6 0.002% 99.724% ( 51, 76 ] 5 0.002% 99.726% ( 76, 110 ] 112 0.041% 99.767% ( 110, 170 ] 302 0.111% 99.878% ( 170, 250 ] 128 0.047% 99.926% ( 250, 380 ] 87 0.032% 99.958% ( 380, 580 ] 88 0.032% 99.990% ( 580, 870 ] 45 0.017% 100.007% ( 870, 1300 ] 25 0.009% 100.016% ( 1300, 1900 ] 10 0.004% 100.020% ( 1900, 2900 ] 19 0.007% 100.027% ( 2900, 4400 ] 11 0.004% 100.031% ( 4400, 6600 ] 6 0.002% 100.033% ** Level 4 read latency histogram (micros): Count: 310 Average: 128.0419 StdDev: 548.35 Min: 1 Median: 2.5366 Max: 4352 Percentiles: P50: 2.54 P75: 6.82 P99: 3237.50 P99.9: 4283.75 P99.99: 4352.00 ------------------------------------------------------ [ 0, 1 ] 41 13.226% 13.226% ### ( 1, 2 ] 92 29.677% 42.903% ###### ( 2, 3 ] 41 13.226% 56.129% ### ( 3, 4 ] 23 7.419% 63.548% # ( 4, 6 ] 32 10.323% 73.871% ## ( 6, 10 ] 17 5.484% 79.355% # ( 10, 15 ] 17 5.484% 84.839% # ( 15, 22 ] 8 2.581% 87.419% # ( 22, 34 ] 10 3.226% 90.645% # ( 34, 51 ] 1 0.323% 90.968% ( 76, 110 ] 1 0.323% 91.290% ( 110, 170 ] 5 1.613% 92.903% ( 250, 380 ] 3 0.968% 93.871% ( 380, 580 ] 2 0.645% 94.516% ( 580, 870 ] 3 0.968% 95.484% ( 870, 1300 ] 1 0.323% 95.806% ( 1300, 1900 ] 6 1.935% 97.742% ( 1900, 2900 ] 3 0.968% 98.710% ( 2900, 4400 ] 4 1.290% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 819.1333 StdDev: 1042.03 Min: 77 Median: 341.0000 Max: 5171 Percentiles: P50: 341.00 P75: 1013.33 P99: 5171.00 P99.9: 5171.00 P99.99: 5171.00 ------------------------------------------------------ ( 76, 110 ] 7 11.667% 11.667% ## ( 110, 170 ] 14 23.333% 35.000% ##### ( 170, 250 ] 2 3.333% 38.333% # ( 250, 380 ] 10 16.667% 55.000% ### ( 380, 580 ] 8 13.333% 68.333% ### ( 580, 870 ] 3 5.000% 73.333% # ( 870, 1300 ] 3 5.000% 78.333% # ( 1300, 1900 ] 3 5.000% 83.333% # ( 1900, 2900 ] 8 13.333% 96.667% ### ( 2900, 4400 ] 1 1.667% 98.333% ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 18.9 total, 3.6 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 313.20 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.043 H:M:S, 16.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 273.25 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.975 H:M:S, 27.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/13-19:16:10 ... thread 0: (1000000,7000000) ops and (107364.5,250012.5) ops/second in (9.314063,27.998602) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/9 2.64 GB 0.0 5.7 0.0 5.7 12.2 6.6 0.0 1.9 141.0 304.8 41.09 38.30 115 0.357 5884K 8689 0.0 0.0 L1 25/25 2.07 GB 0.0 5.0 3.7 1.3 5.0 3.6 0.2 1.4 227.9 226.0 22.59 21.61 4 5.647 5227K 43K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 1.6 2.0 249.9 249.7 1.51 1.46 2 0.756 383K 202 0.0 0.0 L3 35/9 1.59 GB 1.1 3.0 1.5 1.5 3.0 1.5 0.4 2.0 216.8 215.9 14.29 12.96 10 1.429 3145K 12K 0.0 0.0 L4 176/9 9.68 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.9 1.0 150.0 150.1 1.50 1.12 1 1.496 227K 0 0.0 0.0 L5 1052/0 86.68 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 1297/52 102.66 GB 0.0 14.3 5.6 8.7 20.8 12.1 4.2 3.2 180.8 263.3 80.98 75.45 132 0.613 14M 64K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.3 5.6 8.7 20.8 12.1 4.1 3.2 180.8 263.3 80.98 75.45 132 0.613 14M 64K 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.3 5.6 8.7 14.2 5.5 0.0 0.0 237.0 235.9 61.79 58.47 36 1.716 14M 64K 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 351.3 19.19 16.98 96 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): 28.2 total, 28.0 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 20.82 GB write, 756.82 MB/s write, 14.30 GB read, 519.85 MB/s read, 81.0 seconds Interval compaction: 20.82 GB write, 761.36 MB/s write, 14.30 GB read, 522.97 MB/s read, 81.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 21, pending-compaction-bytes-delays: 8, pending-compaction-bytes-stops: 0, total-delays: 20, total-stops: 21, interval: 41 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2539219 Average: 2.3694 StdDev: 17.06 Min: 0 Median: 1.4817 Max: 11243 Percentiles: P50: 1.48 P75: 1.86 P99: 5.90 P99.9: 13.32 P99.99: 166.46 ------------------------------------------------------ [ 0, 1 ] 469669 18.497% 18.497% #### ( 1, 2 ] 1660630 65.399% 83.896% ############# ( 2, 3 ] 216529 8.527% 92.423% ## ( 3, 4 ] 100745 3.968% 96.391% # ( 4, 6 ] 69661 2.743% 99.134% # ( 6, 10 ] 17572 0.692% 99.826% ( 10, 15 ] 2824 0.111% 99.937% ( 15, 22 ] 276 0.011% 99.948% ( 22, 34 ] 26 0.001% 99.949% ( 34, 51 ] 10 0.000% 99.950% ( 51, 76 ] 19 0.001% 99.950% ( 76, 110 ] 433 0.017% 99.968% ( 110, 170 ] 608 0.024% 99.991% ( 170, 250 ] 261 0.010% 100.002% ( 250, 380 ] 200 0.008% 100.010% ( 380, 580 ] 188 0.007% 100.017% ( 580, 870 ] 133 0.005% 100.022% ( 870, 1300 ] 72 0.003% 100.025% ( 1300, 1900 ] 18 0.001% 100.026% ( 1900, 2900 ] 15 0.001% 100.026% ( 2900, 4400 ] 16 0.001% 100.027% ( 4400, 6600 ] 1 0.000% 100.027% ( 9900, 14000 ] 1 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 756522 Average: 3.0114 StdDev: 20.19 Min: 0 Median: 1.6269 Max: 4015 Percentiles: P50: 1.63 P75: 2.15 P99: 8.48 P99.9: 94.25 P99.99: 168.24 ------------------------------------------------------ [ 0, 1 ] 84950 11.229% 11.229% ## ( 1, 2 ] 467849 61.842% 73.071% ############ ( 2, 3 ] 94174 12.448% 85.519% ## ( 3, 4 ] 49229 6.507% 92.027% # ( 4, 6 ] 44819 5.924% 97.951% # ( 6, 10 ] 12777 1.689% 99.640% ( 10, 15 ] 1576 0.208% 99.848% ( 15, 22 ] 179 0.024% 99.872% ( 22, 34 ] 13 0.002% 99.874% ( 34, 51 ] 2 0.000% 99.874% ( 51, 76 ] 8 0.001% 99.875% ( 76, 110 ] 353 0.047% 99.922% ( 110, 170 ] 533 0.070% 99.992% ( 170, 250 ] 220 0.029% 100.021% ( 250, 380 ] 173 0.023% 100.044% ( 380, 580 ] 154 0.020% 100.064% ( 580, 870 ] 69 0.009% 100.073% ( 870, 1300 ] 27 0.004% 100.077% ( 1300, 1900 ] 19 0.003% 100.080% ( 1900, 2900 ] 8 0.001% 100.081% ( 2900, 4400 ] 6 0.001% 100.081% ** Level 2 read latency histogram (micros): Count: 124245 Average: 2.3579 StdDev: 15.59 Min: 0 Median: 1.4001 Max: 3144 Percentiles: P50: 1.40 P75: 1.81 P99: 5.94 P99.9: 99.24 P99.99: 683.69 ------------------------------------------------------ [ 0, 1 ] 31769 25.570% 25.570% ##### ( 1, 2 ] 75871 61.066% 86.635% ############ ( 2, 3 ] 7920 6.375% 93.010% # ( 3, 4 ] 4521 3.639% 96.649% # ( 4, 6 ] 3015 2.427% 99.075% ( 6, 10 ] 852 0.686% 99.761% ( 10, 15 ] 128 0.103% 99.864% ( 15, 22 ] 11 0.009% 99.873% ( 22, 34 ] 1 0.001% 99.874% ( 51, 76 ] 2 0.002% 99.875% ( 76, 110 ] 45 0.036% 99.911% ( 110, 170 ] 43 0.035% 99.946% ( 170, 250 ] 9 0.007% 99.953% ( 250, 380 ] 27 0.022% 99.975% ( 380, 580 ] 15 0.012% 99.987% ( 580, 870 ] 10 0.008% 99.995% ( 870, 1300 ] 4 0.003% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 461018 Average: 3.9538 StdDev: 50.32 Min: 0 Median: 1.7523 Max: 8015 Percentiles: P50: 1.75 P75: 2.66 P99: 8.95 P99.9: 104.15 P99.99: 188.21 ------------------------------------------------------ [ 0, 1 ] 36635 7.947% 7.947% ## ( 1, 2 ] 257707 55.900% 63.846% ########### ( 2, 3 ] 77355 16.779% 80.625% ### ( 3, 4 ] 39811 8.635% 89.261% ## ( 4, 6 ] 38493 8.350% 97.610% ## ( 6, 10 ] 8703 1.888% 99.498% ( 10, 15 ] 1517 0.329% 99.827% ( 15, 22 ] 189 0.041% 99.868% ( 22, 34 ] 30 0.007% 99.875% ( 34, 51 ] 7 0.002% 99.876% ( 51, 76 ] 6 0.001% 99.877% ( 76, 110 ] 128 0.028% 99.905% ( 110, 170 ] 346 0.075% 99.980% ( 170, 250 ] 206 0.045% 100.025% ( 250, 380 ] 153 0.033% 100.058% ( 380, 580 ] 149 0.032% 100.090% ( 580, 870 ] 75 0.016% 100.107% ( 870, 1300 ] 37 0.008% 100.115% ( 1300, 1900 ] 12 0.003% 100.117% ( 1900, 2900 ] 22 0.005% 100.122% ( 2900, 4400 ] 43 0.009% 100.131% ( 4400, 6600 ] 6 0.001% 100.133% ( 6600, 9900 ] 1 0.000% 100.133% ** Level 4 read latency histogram (micros): Count: 8418 Average: 50.6181 StdDev: 297.30 Min: 1 Median: 1.9831 Max: 6150 Percentiles: P50: 1.98 P75: 3.50 P99: 1044.15 P99.9: 4516.40 P99.99: 6031.64 ------------------------------------------------------ [ 0, 1 ] 381 4.526% 4.526% # ( 1, 2 ] 3894 46.258% 50.784% ######### ( 2, 3 ] 1534 18.223% 69.007% #### ( 3, 4 ] 1019 12.105% 81.112% ## ( 4, 6 ] 705 8.375% 89.487% ## ( 6, 10 ] 176 2.091% 91.578% ( 10, 15 ] 80 0.950% 92.528% ( 15, 22 ] 15 0.178% 92.706% ( 22, 34 ] 10 0.119% 92.825% ( 34, 51 ] 1 0.012% 92.837% ( 76, 110 ] 25 0.297% 93.134% ( 110, 170 ] 82 0.974% 94.108% ( 170, 250 ] 90 1.069% 95.177% ( 250, 380 ] 109 1.295% 96.472% ( 380, 580 ] 106 1.259% 97.731% ( 580, 870 ] 89 1.057% 98.788% ( 870, 1300 ] 44 0.523% 99.311% ( 1300, 1900 ] 21 0.249% 99.560% ( 1900, 2900 ] 12 0.143% 99.703% ( 2900, 4400 ] 16 0.190% 99.893% ( 4400, 6600 ] 11 0.131% 100.024% ** Level 5 read latency histogram (micros): Count: 60 Average: 819.1333 StdDev: 1042.03 Min: 77 Median: 341.0000 Max: 5171 Percentiles: P50: 341.00 P75: 1013.33 P99: 5171.00 P99.9: 5171.00 P99.99: 5171.00 ------------------------------------------------------ ( 76, 110 ] 7 11.667% 11.667% ## ( 110, 170 ] 14 23.333% 35.000% ##### ( 170, 250 ] 2 3.333% 38.333% # ( 250, 380 ] 10 16.667% 55.000% ### ( 380, 580 ] 8 13.333% 68.333% ### ( 580, 870 ] 3 5.000% 73.333% # ( 870, 1300 ] 3 5.000% 78.333% # ( 1300, 1900 ] 3 5.000% 83.333% # ( 1900, 2900 ] 8 13.333% 96.667% ### ( 2900, 4400 ] 1 1.667% 98.333% ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 28.2 total, 9.3 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 244.58 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:9.345 H:M:S, 33.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 105.67 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:6.302 H:M:S, 67.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/07/13-19:16:13 ... thread 0: (1000000,8000000) ops and (326160.5,257528.1) ops/second in (3.065975,31.064577) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/13 3.62 GB 75.5 6.3 0.0 6.3 13.8 7.6 0.0 1.8 138.0 304.1 46.57 43.13 131 0.356 6523K 9384 0.0 0.0 L1 25/25 2.07 GB 0.0 5.0 3.7 1.3 5.0 3.6 0.2 1.4 227.9 226.0 22.59 21.61 4 5.647 5227K 43K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 1.6 2.0 249.9 249.7 1.51 1.46 2 0.756 383K 202 0.0 0.0 L3 24/0 991.35 MB 1.0 3.0 1.5 1.5 3.0 1.5 0.4 2.0 216.8 215.9 14.29 12.96 10 1.429 3145K 12K 0.0 0.0 L4 179/0 9.62 GB 1.0 0.9 0.8 0.0 0.9 0.8 0.9 1.0 139.5 139.3 6.48 4.22 12 0.540 918K 1641 0.0 0.0 L5 1060/0 87.35 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1305/38 103.64 GB 0.0 15.6 6.2 9.4 23.1 13.7 4.9 3.1 174.5 258.4 91.45 83.38 159 0.575 16M 67K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.6 6.2 9.4 23.1 13.7 4.8 3.1 174.5 258.4 91.45 83.38 159 0.575 16M 67K 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 15.6 6.2 9.4 15.5 6.2 0.0 0.0 230.7 229.7 69.14 63.87 49 1.411 16M 67K 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 347.4 22.30 19.51 110 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): 31.2 total, 31.1 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: 23.08 GB write, 756.67 MB/s write, 15.58 GB read, 510.76 MB/s read, 91.4 seconds Interval compaction: 23.08 GB write, 760.76 MB/s write, 15.58 GB read, 513.52 MB/s read, 91.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 30, pending-compaction-bytes-delays: 8, pending-compaction-bytes-stops: 0, total-delays: 20, total-stops: 30, interval: 50 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2889823 Average: 2.3520 StdDev: 16.42 Min: 0 Median: 1.4827 Max: 11243 Percentiles: P50: 1.48 P75: 1.86 P99: 5.91 P99.9: 12.94 P99.99: 155.67 ------------------------------------------------------ [ 0, 1 ] 530384 18.354% 18.354% #### ( 1, 2 ] 1894430 65.555% 83.909% ############# ( 2, 3 ] 247540 8.566% 92.475% ## ( 3, 4 ] 113806 3.938% 96.413% # ( 4, 6 ] 78415 2.713% 99.126% # ( 6, 10 ] 20495 0.709% 99.836% ( 10, 15 ] 3170 0.110% 99.945% ( 15, 22 ] 312 0.011% 99.956% ( 22, 34 ] 27 0.001% 99.957% ( 34, 51 ] 13 0.000% 99.957% ( 51, 76 ] 20 0.001% 99.958% ( 76, 110 ] 443 0.015% 99.973% ( 110, 170 ] 632 0.022% 99.995% ( 170, 250 ] 272 0.009% 100.005% ( 250, 380 ] 215 0.007% 100.012% ( 380, 580 ] 197 0.007% 100.019% ( 580, 870 ] 142 0.005% 100.024% ( 870, 1300 ] 74 0.003% 100.026% ( 1300, 1900 ] 19 0.001% 100.027% ( 1900, 2900 ] 15 0.001% 100.028% ( 2900, 4400 ] 18 0.001% 100.028% ( 4400, 6600 ] 1 0.000% 100.028% ( 9900, 14000 ] 1 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 768040 Average: 3.0164 StdDev: 20.10 Min: 0 Median: 1.6275 Max: 4015 Percentiles: P50: 1.63 P75: 2.16 P99: 8.51 P99.9: 98.57 P99.99: 169.19 ------------------------------------------------------ [ 0, 1 ] 85742 11.164% 11.164% ## ( 1, 2 ] 475321 61.888% 73.051% ############ ( 2, 3 ] 95860 12.481% 85.532% ## ( 3, 4 ] 49885 6.495% 92.027% # ( 4, 6 ] 45398 5.911% 97.938% # ( 6, 10 ] 12999 1.692% 99.631% ( 10, 15 ] 1617 0.211% 99.841% ( 15, 22 ] 186 0.024% 99.866% ( 22, 34 ] 13 0.002% 99.867% ( 34, 51 ] 2 0.000% 99.868% ( 51, 76 ] 8 0.001% 99.869% ( 76, 110 ] 363 0.047% 99.916% ( 110, 170 ] 577 0.075% 99.991% ( 170, 250 ] 225 0.029% 100.020% ( 250, 380 ] 174 0.023% 100.043% ( 380, 580 ] 157 0.020% 100.063% ( 580, 870 ] 69 0.009% 100.072% ( 870, 1300 ] 27 0.004% 100.076% ( 1300, 1900 ] 19 0.002% 100.078% ( 1900, 2900 ] 8 0.001% 100.079% ( 2900, 4400 ] 6 0.001% 100.080% ** Level 2 read latency histogram (micros): Count: 124245 Average: 2.3579 StdDev: 15.59 Min: 0 Median: 1.4001 Max: 3144 Percentiles: P50: 1.40 P75: 1.81 P99: 5.94 P99.9: 99.24 P99.99: 683.69 ------------------------------------------------------ [ 0, 1 ] 31769 25.570% 25.570% ##### ( 1, 2 ] 75871 61.066% 86.635% ############ ( 2, 3 ] 7920 6.375% 93.010% # ( 3, 4 ] 4521 3.639% 96.649% # ( 4, 6 ] 3015 2.427% 99.075% ( 6, 10 ] 852 0.686% 99.761% ( 10, 15 ] 128 0.103% 99.864% ( 15, 22 ] 11 0.009% 99.873% ( 22, 34 ] 1 0.001% 99.874% ( 51, 76 ] 2 0.002% 99.875% ( 76, 110 ] 45 0.036% 99.911% ( 110, 170 ] 43 0.035% 99.946% ( 170, 250 ] 9 0.007% 99.953% ( 250, 380 ] 27 0.022% 99.975% ( 380, 580 ] 15 0.012% 99.987% ( 580, 870 ] 10 0.008% 99.995% ( 870, 1300 ] 4 0.003% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 502234 Average: 3.8470 StdDev: 48.97 Min: 0 Median: 1.7440 Max: 8015 Percentiles: P50: 1.74 P75: 2.63 P99: 8.82 P99.9: 86.30 P99.99: 176.52 ------------------------------------------------------ [ 0, 1 ] 38869 7.739% 7.739% ## ( 1, 2 ] 285288 56.804% 64.543% ########### ( 2, 3 ] 83893 16.704% 81.247% ### ( 3, 4 ] 42135 8.390% 89.637% ## ( 4, 6 ] 40707 8.105% 97.742% ## ( 6, 10 ] 8976 1.787% 99.529% ( 10, 15 ] 1588 0.316% 99.845% ( 15, 22 ] 194 0.039% 99.884% ( 22, 34 ] 30 0.006% 99.890% ( 34, 51 ] 7 0.001% 99.891% ( 51, 76 ] 6 0.001% 99.892% ( 76, 110 ] 128 0.025% 99.918% ( 110, 170 ] 346 0.069% 99.987% ( 170, 250 ] 206 0.041% 100.028% ( 250, 380 ] 153 0.030% 100.058% ( 380, 580 ] 149 0.030% 100.088% ( 580, 870 ] 75 0.015% 100.103% ( 870, 1300 ] 37 0.007% 100.110% ( 1300, 1900 ] 12 0.002% 100.112% ( 1900, 2900 ] 22 0.004% 100.117% ( 2900, 4400 ] 44 0.009% 100.126% ( 4400, 6600 ] 7 0.001% 100.127% ( 6600, 9900 ] 1 0.000% 100.127% ** Level 4 read latency histogram (micros): Count: 11336 Average: 45.3854 StdDev: 268.81 Min: 1 Median: 1.8774 Max: 6150 Percentiles: P50: 1.88 P75: 3.21 P99: 975.08 P99.9: 4193.88 P99.99: 5973.28 ------------------------------------------------------ [ 0, 1 ] 728 6.422% 6.422% # ( 1, 2 ] 5630 49.665% 56.087% ########## ( 2, 3 ] 1890 16.673% 72.759% ### ( 3, 4 ] 1189 10.489% 83.248% ## ( 4, 6 ] 800 7.057% 90.305% # ( 6, 10 ] 228 2.011% 92.317% ( 10, 15 ] 89 0.785% 93.102% ( 15, 22 ] 17 0.150% 93.252% ( 22, 34 ] 10 0.088% 93.340% ( 34, 51 ] 1 0.009% 93.349% ( 76, 110 ] 36 0.318% 93.666% ( 110, 170 ] 96 0.847% 94.513% ( 170, 250 ] 107 0.944% 95.457% ( 250, 380 ] 131 1.156% 96.613% ( 380, 580 ] 144 1.270% 97.883% ( 580, 870 ] 111 0.979% 98.862% ( 870, 1300 ] 64 0.565% 99.427% ( 1300, 1900 ] 26 0.229% 99.656% ( 1900, 2900 ] 13 0.115% 99.771% ( 2900, 4400 ] 17 0.150% 99.921% ( 4400, 6600 ] 11 0.097% 100.018% ** Level 5 read latency histogram (micros): Count: 100 Average: 779.9000 StdDev: 975.06 Min: 77 Median: 315.0000 Max: 5171 Percentiles: P50: 315.00 P75: 1061.11 P99: 4400.00 P99.9: 5171.00 P99.99: 5171.00 ------------------------------------------------------ ( 76, 110 ] 13 13.000% 13.000% ### ( 110, 170 ] 22 22.000% 35.000% #### ( 170, 250 ] 8 8.000% 43.000% ## ( 250, 380 ] 14 14.000% 57.000% ### ( 380, 580 ] 10 10.000% 67.000% ## ( 580, 870 ] 4 4.000% 71.000% # ( 870, 1300 ] 9 9.000% 80.000% ## ( 1300, 1900 ] 6 6.000% 86.000% # ( 1900, 2900 ] 10 10.000% 96.000% ## ( 2900, 4400 ] 3 3.000% 99.000% # ( 4400, 6600 ] 1 1.000% 100.000% ** DB Stats ** Uptime(secs): 31.2 total, 3.1 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 252.08 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:9.829 H:M:S, 31.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.99 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.483 H:M:S, 15.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/13-19:16:40 ... thread 0: (1000000,9000000) ops and (37130.0,155180.6) ops/second in (26.932382,57.996959) 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/6 1.96 GB 31.5 8.4 0.0 8.4 16.9 8.5 0.0 2.0 141.5 286.0 60.52 53.75 147 0.412 8697K 16K 0.0 0.0 L1 7/7 856.83 MB 0.0 9.7 6.3 3.4 9.6 6.2 0.2 1.5 223.3 220.4 44.65 41.48 5 8.929 9141K 43K 0.0 0.0 L2 1/1 128.78 MB 0.0 0.4 0.2 0.2 0.4 0.2 5.4 2.0 249.9 249.7 1.51 1.46 2 0.756 383K 202 0.0 0.0 L3 25/3 1.20 GB 1.0 8.5 5.0 3.5 8.5 5.0 0.5 1.7 152.1 151.2 57.54 39.14 31 1.856 7972K 43K 0.0 0.0 L4 174/2 9.74 GB 1.0 4.4 4.2 0.2 4.4 4.2 0.9 1.0 126.0 125.7 35.74 20.99 47 0.760 4450K 2661 0.0 0.0 L5 1100/0 90.61 GB 0.9 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 1314/19 104.48 GB 0.0 31.4 15.8 15.6 39.8 24.1 12.1 4.6 160.9 203.6 199.96 156.81 232 0.862 30M 107K 0.0 0.0 Int 0/0 0.00 KB 0.0 31.4 15.8 15.6 39.8 24.1 11.9 4.6 160.9 203.6 199.96 156.81 232 0.862 30M 107K 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.4 15.8 15.6 31.2 15.6 0.0 0.0 186.9 185.6 172.16 134.59 110 1.565 30M 107K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 315.0 27.80 22.21 122 0.228 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 58.2 total, 58.0 interval Flush(GB): cumulative 8.551, interval 8.551 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: 39.76 GB write, 699.99 MB/s write, 31.42 GB read, 553.06 MB/s read, 200.0 seconds Interval compaction: 39.76 GB write, 702.02 MB/s write, 31.42 GB read, 554.66 MB/s read, 200.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 60, pending-compaction-bytes-delays: 39, pending-compaction-bytes-stops: 0, total-delays: 51, total-stops: 60, interval: 111 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4170945 Average: 3.1729 StdDev: 44.09 Min: 0 Median: 1.4978 Max: 11243 Percentiles: P50: 1.50 P75: 1.89 P99: 7.71 P99.9: 145.57 P99.99: 573.08 ------------------------------------------------------ [ 0, 1 ] 768827 18.433% 18.433% #### ( 1, 2 ] 2645075 63.417% 81.850% ############# ( 2, 3 ] 379453 9.098% 90.947% ## ( 3, 4 ] 173704 4.165% 95.112% # ( 4, 6 ] 145409 3.486% 98.598% # ( 6, 10 ] 39336 0.943% 99.541% ( 10, 15 ] 7267 0.174% 99.715% ( 15, 22 ] 913 0.022% 99.737% ( 22, 34 ] 59 0.001% 99.739% ( 34, 51 ] 18 0.000% 99.739% ( 51, 76 ] 114 0.003% 99.742% ( 76, 110 ] 4395 0.105% 99.847% ( 110, 170 ] 3718 0.089% 99.936% ( 170, 250 ] 852 0.020% 99.957% ( 250, 380 ] 716 0.017% 99.974% ( 380, 580 ] 696 0.017% 99.991% ( 580, 870 ] 442 0.011% 100.001% ( 870, 1300 ] 252 0.006% 100.007% ( 1300, 1900 ] 147 0.004% 100.011% ( 1900, 2900 ] 174 0.004% 100.015% ( 2900, 4400 ] 230 0.006% 100.020% ( 4400, 6600 ] 64 0.002% 100.022% ( 6600, 9900 ] 19 0.000% 100.022% ( 9900, 14000 ] 1 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 2231712 Average: 5.1106 StdDev: 78.93 Min: 0 Median: 1.6798 Max: 10377 Percentiles: P50: 1.68 P75: 2.52 P99: 9.40 P99.9: 131.37 P99.99: 266.67 ------------------------------------------------------ [ 0, 1 ] 269517 12.077% 12.077% ## ( 1, 2 ] 1245074 55.790% 67.867% ########### ( 2, 3 ] 308412 13.820% 81.686% ### ( 3, 4 ] 170709 7.649% 89.336% ## ( 4, 6 ] 176930 7.928% 97.264% ## ( 6, 10 ] 45593 2.043% 99.306% ( 10, 15 ] 9132 0.409% 99.716% ( 15, 22 ] 1143 0.051% 99.767% ( 22, 34 ] 72 0.003% 99.770% ( 34, 51 ] 36 0.002% 99.772% ( 51, 76 ] 177 0.008% 99.780% ( 76, 110 ] 1919 0.086% 99.866% ( 110, 170 ] 2154 0.097% 99.962% ( 170, 250 ] 549 0.025% 99.987% ( 250, 380 ] 568 0.025% 100.012% ( 380, 580 ] 757 0.034% 100.046% ( 580, 870 ] 684 0.031% 100.077% ( 870, 1300 ] 446 0.020% 100.097% ( 1300, 1900 ] 274 0.012% 100.109% ( 1900, 2900 ] 338 0.015% 100.124% ( 2900, 4400 ] 438 0.020% 100.144% ( 4400, 6600 ] 116 0.005% 100.149% ( 6600, 9900 ] 21 0.001% 100.150% ( 9900, 14000 ] 1 0.000% 100.150% ** Level 2 read latency histogram (micros): Count: 124245 Average: 2.3579 StdDev: 15.59 Min: 0 Median: 1.4001 Max: 3144 Percentiles: P50: 1.40 P75: 1.81 P99: 5.94 P99.9: 99.24 P99.99: 683.69 ------------------------------------------------------ [ 0, 1 ] 31769 25.570% 25.570% ##### ( 1, 2 ] 75871 61.066% 86.635% ############ ( 2, 3 ] 7920 6.375% 93.010% # ( 3, 4 ] 4521 3.639% 96.649% # ( 4, 6 ] 3015 2.427% 99.075% ( 6, 10 ] 852 0.686% 99.761% ( 10, 15 ] 128 0.103% 99.864% ( 15, 22 ] 11 0.009% 99.873% ( 22, 34 ] 1 0.001% 99.874% ( 51, 76 ] 2 0.002% 99.875% ( 76, 110 ] 45 0.036% 99.911% ( 110, 170 ] 43 0.035% 99.946% ( 170, 250 ] 9 0.007% 99.953% ( 250, 380 ] 27 0.022% 99.975% ( 380, 580 ] 15 0.012% 99.987% ( 580, 870 ] 10 0.008% 99.995% ( 870, 1300 ] 4 0.003% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1918505 Average: 7.7231 StdDev: 114.80 Min: 0 Median: 1.9160 Max: 13103 Percentiles: P50: 1.92 P75: 3.06 P99: 9.64 P99.9: 160.86 P99.99: 468.13 ------------------------------------------------------ [ 0, 1 ] 67449 3.516% 3.516% # ( 1, 2 ] 973580 50.747% 54.263% ########## ( 2, 3 ] 385297 20.083% 74.346% #### ( 3, 4 ] 209680 10.929% 85.275% ## ( 4, 6 ] 222616 11.604% 96.879% ## ( 6, 10 ] 44762 2.333% 99.212% ( 10, 15 ] 11211 0.584% 99.796% ( 15, 22 ] 1207 0.063% 99.859% ( 22, 34 ] 91 0.005% 99.864% ( 34, 51 ] 35 0.002% 99.866% ( 51, 76 ] 39 0.002% 99.868% ( 76, 110 ] 167 0.009% 99.876% ( 110, 170 ] 535 0.028% 99.904% ( 170, 250 ] 492 0.026% 99.930% ( 250, 380 ] 720 0.038% 99.967% ( 380, 580 ] 983 0.051% 100.019% ( 580, 870 ] 1121 0.058% 100.077% ( 870, 1300 ] 834 0.043% 100.121% ( 1300, 1900 ] 601 0.031% 100.152% ( 1900, 2900 ] 667 0.035% 100.187% ( 2900, 4400 ] 761 0.040% 100.226% ( 4400, 6600 ] 184 0.010% 100.236% ( 6600, 9900 ] 58 0.003% 100.239% ( 9900, 14000 ] 4 0.000% 100.239% ** Level 4 read latency histogram (micros): Count: 48579 Average: 90.6765 StdDev: 456.77 Min: 1 Median: 1.9897 Max: 9464 Percentiles: P50: 1.99 P75: 3.39 P99: 2659.22 P99.9: 5425.56 P99.99: 6482.56 ------------------------------------------------------ [ 0, 1 ] 1931 3.975% 3.975% # ( 1, 2 ] 22591 46.504% 50.479% ######### ( 2, 3 ] 9718 20.005% 70.483% #### ( 3, 4 ] 5622 11.573% 82.056% ## ( 4, 6 ] 3978 8.189% 90.245% ## ( 6, 10 ] 1030 2.120% 92.365% ( 10, 15 ] 321 0.661% 93.026% ( 15, 22 ] 45 0.093% 93.118% ( 22, 34 ] 12 0.025% 93.143% ( 34, 51 ] 7 0.014% 93.158% ( 51, 76 ] 1 0.002% 93.160% ( 76, 110 ] 38 0.078% 93.238% ( 110, 170 ] 154 0.317% 93.555% ( 170, 250 ] 208 0.428% 93.983% ( 250, 380 ] 281 0.578% 94.561% ( 380, 580 ] 467 0.961% 95.523% ( 580, 870 ] 596 1.227% 96.750% ( 870, 1300 ] 506 1.042% 97.791% ( 1300, 1900 ] 364 0.749% 98.541% ( 1900, 2900 ] 294 0.605% 99.146% ( 2900, 4400 ] 324 0.667% 99.813% ( 4400, 6600 ] 91 0.187% 100.000% ( 6600, 9900 ] 7 0.014% 100.014% ** Level 5 read latency histogram (micros): Count: 300 Average: 1284.7167 StdDev: 1373.13 Min: 77 Median: 693.4783 Max: 7451 Percentiles: P50: 693.48 P75: 1957.14 P99: 6160.00 P99.9: 7451.00 P99.99: 7451.00 ------------------------------------------------------ ( 76, 110 ] 13 4.333% 4.333% # ( 110, 170 ] 33 11.000% 15.333% ## ( 170, 250 ] 19 6.333% 21.667% # ( 250, 380 ] 43 14.333% 36.000% ### ( 380, 580 ] 33 11.000% 47.000% ## ( 580, 870 ] 23 7.667% 54.667% ## ( 870, 1300 ] 34 11.333% 66.000% ## ( 1300, 1900 ] 25 8.333% 74.333% ## ( 1900, 2900 ] 35 11.667% 86.000% ## ( 2900, 4400 ] 31 10.333% 96.333% ## ( 4400, 6600 ] 10 3.333% 99.667% # ( 6600, 9900 ] 1 0.333% 100.000% ** DB Stats ** Uptime(secs): 58.2 total, 26.9 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 152.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:33.709 H:M:S, 58.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 36.54 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:23.880 H:M:S, 88.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 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 : 6.226 micros/op 160625 ops/sec 60.003 seconds 9637999 operations; 155.6 MB/s Microseconds per write: Count: 9637999 Average: 6.2257 StdDev: 520.52 Min: 0 Median: 1.7283 Max: 822344 Percentiles: P50: 1.73 P75: 2.67 P99: 8.28 P99.9: 1207.03 P99.99: 2803.35 ------------------------------------------------------ [ 0, 1 ] 1372064 14.236% 14.236% ### ( 1, 2 ] 4732628 49.104% 63.340% ########## ( 2, 3 ] 1678838 17.419% 80.759% ### ( 3, 4 ] 1267017 13.146% 93.905% ### ( 4, 6 ] 444155 4.608% 98.513% # ( 6, 10 ] 82148 0.852% 99.366% ( 10, 15 ] 23000 0.239% 99.604% ( 15, 22 ] 6902 0.072% 99.676% ( 22, 34 ] 1849 0.019% 99.695% ( 34, 51 ] 162 0.002% 99.697% ( 51, 76 ] 22 0.000% 99.697% ( 76, 110 ] 6804 0.071% 99.767% ( 110, 170 ] 2586 0.027% 99.794% ( 170, 250 ] 278 0.003% 99.797% ( 250, 380 ] 92 0.001% 99.798% ( 380, 580 ] 23 0.000% 99.798% ( 580, 870 ] 27 0.000% 99.799% ( 870, 1300 ] 12460 0.129% 99.928% ( 1300, 1900 ] 75 0.001% 99.929% ( 1900, 2900 ] 6537 0.068% 99.997% ( 2900, 4400 ] 246 0.003% 99.999% ( 4400, 6600 ] 46 0.000% 100.000% ( 6600, 9900 ] 11 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 4 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 13 0.000% 100.000% ( 250000, 380000 ] 2 0.000% 100.000% ( 570000, 860000 ] 3 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 : 218779 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 : 9637999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 9946414968 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 : 634 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 34011886 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 : 36819195052 rocksdb.compact.write.bytes COUNT : 36597901507 rocksdb.flush.write.bytes COUNT : 9776406967 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 : 77 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 : 244 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 : 9697671168 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3848192 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 : 36921794910 rocksdb.non.last.level.read.count COUNT : 8920774 rocksdb.block.checksum.compute.count COUNT : 8919583 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.367933 P95 : 3.795094 P99 : 6.461945 P100 : 822341.000000 COUNT : 9637999 SUM : 55593623 rocksdb.compaction.times.micros P50 : 1042142.857143 P95 : 3436666.666667 P99 : 13286000.000000 P100 : 22058756.000000 COUNT : 117 SUM : 178420455 rocksdb.compaction.times.cpu_micros P50 : 865666.666667 P95 : 3005000.000000 P99 : 13286000.000000 P100 : 19870744.000000 COUNT : 117 SUM : 140224057 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 : 712.916667 P95 : 3650.000000 P99 : 44900.000000 P100 : 55541.000000 COUNT : 130 SUM : 219341 rocksdb.compaction.outfile.sync.micros P50 : 1186.460674 P95 : 121062.500000 P99 : 222457.142857 P100 : 264652.000000 COUNT : 441 SUM : 9600914 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 : 106.600000 P95 : 1874.285714 P99 : 4245.714286 P100 : 5471.000000 COUNT : 272 SUM : 124874 rocksdb.table.open.io.micros P50 : 1549.152542 P95 : 7999.655172 P99 : 12631.230769 P100 : 14647.000000 COUNT : 634 SUM : 1440717 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.670291 P95 : 8.432285 P99 : 12.798653 P100 : 13107.000000 COUNT : 8917725 SUM : 64319435 rocksdb.read.block.get.micros P50 : 492.676056 P95 : 3762.962963 P99 : 5682.285714 P100 : 7535.000000 COUNT : 1268 SUM : 1195281 rocksdb.write.raw.block.micros P50 : 0.513595 P95 : 0.975831 P99 : 2.846032 P100 : 24935.000000 COUNT : 11245733 SUM : 23664384 rocksdb.numfiles.in.singlecompaction P50 : 2.613636 P95 : 5.180000 P99 : 17.730000 P100 : 34.000000 COUNT : 161 SUM : 554 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.555567 P95 : 1202.392903 P99 : 2644.426556 P100 : 822148.000000 COUNT : 193585 SUM : 34023577 rocksdb.sst.read.micros P50 : 1.632368 P95 : 5.177914 P99 : 9.292509 P100 : 13103.000000 COUNT : 8920914 SUM : 46045473 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 : 9637999 SUM : 9946414968 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 : 211411.764706 P95 : 459166.666667 P99 : 948848.000000 P100 : 948848.000000 COUNT : 130 SUM : 29534664 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 : 405 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