[2024-12-07 16:00:29.990412] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 23.11.0 initialization... [2024-12-07 16:00:29.990554] [ 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_pid713966 ] Set seed to 1733583629986992 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-07 16:00:30.097150] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-07 16:00:30.135972] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-07 16:00:30.136012] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 713966' to capture a snapshot of events at runtime. [2024-12-07 16:00:30.136026] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid713966 for offline analysis/debug. [2024-12-07 16:00:30.136049] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sat Dec 7 16:00:34 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/07-16:00:37 ... thread 0: (1000000,1000000) ops and (348767.1,348767.1) ops/second in (2.867243,2.867243) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/5 504.04 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 345.2 2.37 2.14 12 0.198 0 0 0.0 0.0 L1 3/3 251.76 MB 0.0 0.2 0.2 0.1 0.2 0.2 0.1 1.3 251.0 250.8 1.00 0.98 1 1.004 255K 206 0.0 0.0 L2 1/0 49.09 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 226.5 226.5 0.49 0.46 1 0.493 113K 29 0.0 0.0 L3 18/0 881.37 MB 0.9 0.1 0.1 0.0 0.1 0.1 0.0 1.0 212.8 212.8 0.29 0.25 1 0.294 63K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.75 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1190/8 96.94 GB 0.0 0.4 0.3 0.1 1.2 1.1 0.1 1.5 102.3 299.1 4.16 3.83 15 0.278 432K 235 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.2 1.1 0.1 1.5 102.3 299.1 4.16 3.83 15 0.278 432K 235 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.3 0.1 0.4 0.3 0.0 0.0 238.0 237.9 1.79 1.69 3 0.597 432K 235 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 345.2 2.37 2.14 12 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.1 total, 2.9 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.22 GB write, 400.79 MB/s write, 0.42 GB read, 137.17 MB/s read, 4.2 seconds Interval compaction: 1.22 GB write, 433.88 MB/s write, 0.42 GB read, 148.49 MB/s read, 4.2 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: 99217 Average: 1.7958 StdDev: 15.83 Min: 0 Median: 1.1434 Max: 3349 Percentiles: P50: 1.14 P75: 1.60 P99: 3.31 P99.9: 9.70 P99.99: 350.04 ------------------------------------------------------ [ 0, 1 ] 41832 42.162% 42.162% ######## ( 1, 2 ] 54231 54.659% 96.821% ########### ( 2, 3 ] 1945 1.960% 98.781% ( 3, 4 ] 694 0.699% 99.481% ( 4, 6 ] 279 0.281% 99.762% ( 6, 10 ] 149 0.150% 99.912% ( 10, 15 ] 57 0.057% 99.970% ( 15, 22 ] 6 0.006% 99.976% ( 51, 76 ] 1 0.001% 99.977% ( 110, 170 ] 11 0.011% 99.988% ( 250, 380 ] 4 0.004% 99.992% ( 380, 580 ] 1 0.001% 99.993% ( 580, 870 ] 2 0.002% 99.995% ( 870, 1300 ] 2 0.002% 99.997% ( 1300, 1900 ] 3 0.003% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 1 read latency histogram (micros): Count: 15371 Average: 1.9124 StdDev: 18.52 Min: 0 Median: 1.1536 Max: 1931 Percentiles: P50: 1.15 P75: 1.60 P99: 3.12 P99.9: 9.95 P99.99: 1069.05 ------------------------------------------------------ [ 0, 1 ] 6374 41.468% 41.468% ######## ( 1, 2 ] 8536 55.533% 97.001% ########### ( 2, 3 ] 295 1.919% 98.920% ( 3, 4 ] 104 0.677% 99.597% ( 4, 6 ] 20 0.130% 99.727% ( 6, 10 ] 27 0.176% 99.902% ( 10, 15 ] 9 0.059% 99.961% ( 15, 22 ] 1 0.007% 99.967% ( 250, 380 ] 2 0.013% 99.980% ( 380, 580 ] 1 0.007% 99.987% ( 870, 1300 ] 1 0.007% 99.993% ( 1900, 2900 ] 1 0.007% 100.000% ** Level 2 read latency histogram (micros): Count: 28204 Average: 2.1736 StdDev: 22.55 Min: 1 Median: 1.2014 Max: 3380 Percentiles: P50: 1.20 P75: 1.65 P99: 6.76 P99.9: 92.13 P99.99: 632.08 ------------------------------------------------------ [ 0, 1 ] 10971 38.899% 38.899% ######## ( 1, 2 ] 15548 55.127% 94.026% ########### ( 2, 3 ] 1005 3.563% 97.589% # ( 3, 4 ] 248 0.879% 98.468% ( 4, 6 ] 115 0.408% 98.876% ( 6, 10 ] 183 0.649% 99.525% ( 10, 15 ] 47 0.167% 99.692% ( 15, 22 ] 12 0.043% 99.734% ( 22, 34 ] 2 0.007% 99.741% ( 34, 51 ] 29 0.103% 99.844% ( 51, 76 ] 12 0.043% 99.887% ( 76, 110 ] 8 0.028% 99.915% ( 110, 170 ] 10 0.035% 99.950% ( 170, 250 ] 9 0.032% 99.982% ( 380, 580 ] 2 0.007% 99.989% ( 580, 870 ] 1 0.004% 99.993% ( 870, 1300 ] 1 0.004% 99.996% ( 2900, 4400 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 90 Average: 779.8889 StdDev: 1172.52 Min: 1 Median: 202.0000 Max: 5321 Percentiles: P50: 202.00 P75: 1192.50 P99: 5321.00 P99.9: 5321.00 P99.99: 5321.00 ------------------------------------------------------ [ 0, 1 ] 34 37.778% 37.778% ######## ( 1, 2 ] 4 4.444% 42.222% # ( 76, 110 ] 2 2.222% 44.444% ( 110, 170 ] 3 3.333% 47.778% # ( 170, 250 ] 5 5.556% 53.333% # ( 250, 380 ] 4 4.444% 57.778% # ( 380, 580 ] 5 5.556% 63.333% # ( 580, 870 ] 3 3.333% 66.667% # ( 870, 1300 ] 10 11.111% 77.778% ## ( 1300, 1900 ] 6 6.667% 84.444% # ( 1900, 2900 ] 8 8.889% 93.333% ## ( 2900, 4400 ] 4 4.444% 97.778% # ( 4400, 6600 ] 2 2.222% 100.000% ** Level 4 read latency histogram (micros): Count: 25 Average: 1908.0000 StdDev: 1532.98 Min: 251 Median: 1246.2500 Max: 5868 Percentiles: P50: 1246.25 P75: 2775.00 P99: 5868.00 P99.9: 5868.00 P99.99: 5868.00 ------------------------------------------------------ ( 250, 380 ] 1 4.000% 4.000% # ( 580, 870 ] 8 32.000% 36.000% ###### ( 870, 1300 ] 4 16.000% 52.000% ### ( 1300, 1900 ] 4 16.000% 68.000% ### ( 1900, 2900 ] 2 8.000% 76.000% ## ( 2900, 4400 ] 3 12.000% 88.000% ## ( 4400, 6600 ] 3 12.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.1 total, 2.9 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 316.86 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.204 H:M:S, 6.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 342.92 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.204 H:M:S, 7.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/07-16:00:40 ... thread 0: (1000000,2000000) ops and (324411.7,336148.8) ops/second in (3.082503,5.949746) 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/10 1.17 GB 12.6 0.5 0.0 0.5 2.3 1.8 0.0 1.3 71.0 328.5 7.09 6.55 28 0.253 511K 509 0.0 0.0 L1 6/6 565.48 MB 0.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 242.3 241.9 3.38 3.30 2 1.689 831K 1444 0.0 0.0 L2 1/0 49.09 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 226.5 226.5 0.49 0.46 1 0.493 113K 29 0.0 0.0 L3 18/0 881.37 MB 0.9 0.1 0.1 0.0 0.1 0.1 0.0 1.0 212.8 212.8 0.29 0.25 1 0.294 63K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.75 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1196/16 97.92 GB 0.0 1.5 0.6 0.8 3.2 2.4 0.1 1.8 132.9 295.0 11.26 10.56 32 0.352 1519K 1982 0.0 0.0 Int 0/0 0.00 KB 0.0 1.5 0.6 0.8 3.2 2.4 0.1 1.8 132.9 295.0 11.26 10.56 32 0.352 1519K 1982 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.5 0.6 0.8 1.5 0.6 0.0 0.0 249.7 249.3 5.99 5.81 6 0.999 1519K 1982 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 347.0 5.26 4.75 26 0.202 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.2 total, 6.0 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.24 GB write, 536.76 MB/s write, 1.46 GB read, 241.88 MB/s read, 11.3 seconds Interval compaction: 3.24 GB write, 558.11 MB/s write, 1.46 GB read, 251.50 MB/s read, 11.3 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: 8, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 8, interval: 8 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 322277 Average: 1.9526 StdDev: 15.47 Min: 0 Median: 1.3059 Max: 4289 Percentiles: P50: 1.31 P75: 1.72 P99: 4.85 P99.9: 9.71 P99.99: 24.36 ------------------------------------------------------ [ 0, 1 ] 101520 31.501% 31.501% ###### ( 1, 2 ] 194887 60.472% 91.973% ############ ( 2, 3 ] 15513 4.814% 96.786% # ( 3, 4 ] 5669 1.759% 98.545% ( 4, 6 ] 3441 1.068% 99.613% ( 6, 10 ] 997 0.309% 99.922% ( 10, 15 ] 197 0.061% 99.984% ( 15, 22 ] 20 0.006% 99.990% ( 22, 34 ] 9 0.003% 99.993% ( 34, 51 ] 1 0.000% 99.993% ( 51, 76 ] 1 0.000% 99.993% ( 110, 170 ] 19 0.006% 99.999% ( 170, 250 ] 3 0.001% 100.000% ( 250, 380 ] 12 0.004% 100.004% ( 380, 580 ] 4 0.001% 100.005% ( 580, 870 ] 5 0.002% 100.007% ( 870, 1300 ] 3 0.001% 100.007% ( 1300, 1900 ] 6 0.002% 100.009% ( 2900, 4400 ] 4 0.001% 100.011% ** Level 1 read latency histogram (micros): Count: 85540 Average: 1.9795 StdDev: 10.84 Min: 0 Median: 1.3440 Max: 1931 Percentiles: P50: 1.34 P75: 1.74 P99: 4.81 P99.9: 9.81 P99.99: 409.73 ------------------------------------------------------ [ 0, 1 ] 24269 28.372% 28.372% ###### ( 1, 2 ] 53788 62.881% 91.252% ############# ( 2, 3 ] 4688 5.480% 96.733% # ( 3, 4 ] 1555 1.818% 98.550% ( 4, 6 ] 948 1.108% 99.659% ( 6, 10 ] 217 0.254% 99.912% ( 10, 15 ] 57 0.067% 99.979% ( 15, 22 ] 3 0.004% 99.982% ( 76, 110 ] 1 0.001% 99.984% ( 110, 170 ] 1 0.001% 99.985% ( 250, 380 ] 4 0.005% 99.989% ( 380, 580 ] 3 0.004% 99.993% ( 580, 870 ] 2 0.002% 99.995% ( 870, 1300 ] 2 0.002% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 28204 Average: 2.1736 StdDev: 22.55 Min: 1 Median: 1.2014 Max: 3380 Percentiles: P50: 1.20 P75: 1.65 P99: 6.76 P99.9: 92.13 P99.99: 632.08 ------------------------------------------------------ [ 0, 1 ] 10971 38.899% 38.899% ######## ( 1, 2 ] 15548 55.127% 94.026% ########### ( 2, 3 ] 1005 3.563% 97.589% # ( 3, 4 ] 248 0.879% 98.468% ( 4, 6 ] 115 0.408% 98.876% ( 6, 10 ] 183 0.649% 99.525% ( 10, 15 ] 47 0.167% 99.692% ( 15, 22 ] 12 0.043% 99.734% ( 22, 34 ] 2 0.007% 99.741% ( 34, 51 ] 29 0.103% 99.844% ( 51, 76 ] 12 0.043% 99.887% ( 76, 110 ] 8 0.028% 99.915% ( 110, 170 ] 10 0.035% 99.950% ( 170, 250 ] 9 0.032% 99.982% ( 380, 580 ] 2 0.007% 99.989% ( 580, 870 ] 1 0.004% 99.993% ( 870, 1300 ] 1 0.004% 99.996% ( 2900, 4400 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 90 Average: 779.8889 StdDev: 1172.52 Min: 1 Median: 202.0000 Max: 5321 Percentiles: P50: 202.00 P75: 1192.50 P99: 5321.00 P99.9: 5321.00 P99.99: 5321.00 ------------------------------------------------------ [ 0, 1 ] 34 37.778% 37.778% ######## ( 1, 2 ] 4 4.444% 42.222% # ( 76, 110 ] 2 2.222% 44.444% ( 110, 170 ] 3 3.333% 47.778% # ( 170, 250 ] 5 5.556% 53.333% # ( 250, 380 ] 4 4.444% 57.778% # ( 380, 580 ] 5 5.556% 63.333% # ( 580, 870 ] 3 3.333% 66.667% # ( 870, 1300 ] 10 11.111% 77.778% ## ( 1300, 1900 ] 6 6.667% 84.444% # ( 1900, 2900 ] 8 8.889% 93.333% ## ( 2900, 4400 ] 4 4.444% 97.778% # ( 4400, 6600 ] 2 2.222% 100.000% ** Level 4 read latency histogram (micros): Count: 25 Average: 1908.0000 StdDev: 1532.98 Min: 251 Median: 1246.2500 Max: 5868 Percentiles: P50: 1246.25 P75: 2775.00 P99: 5868.00 P99.9: 5868.00 P99.99: 5868.00 ------------------------------------------------------ ( 250, 380 ] 1 4.000% 4.000% # ( 580, 870 ] 8 32.000% 36.000% ###### ( 870, 1300 ] 4 16.000% 52.000% ### ( 1300, 1900 ] 4 16.000% 68.000% ### ( 1900, 2900 ] 2 8.000% 76.000% ## ( 2900, 4400 ] 3 12.000% 88.000% ## ( 4400, 6600 ] 3 12.000% 100.000% ## ** DB Stats ** Uptime(secs): 6.2 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 318.07 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.589 H:M:S, 9.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.29 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.385 H:M:S, 12.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/07-16:00:43 ... thread 0: (1000000,3000000) ops and (322371.3,331427.3) ops/second in (3.102013,9.051759) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/10 2.15 GB 107.0 1.3 0.0 1.3 4.1 2.8 0.0 1.5 101.5 318.9 13.03 12.13 45 0.290 1343K 1387 0.0 0.0 L1 6/6 565.48 MB 0.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 242.3 241.9 3.38 3.30 2 1.689 831K 1444 0.0 0.0 L2 1/0 49.09 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 226.5 226.5 0.49 0.46 1 0.493 113K 29 0.0 0.0 L3 18/0 881.37 MB 0.9 0.1 0.1 0.0 0.1 0.1 0.0 1.0 212.8 212.8 0.29 0.25 1 0.294 63K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.75 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1201/16 98.90 GB 0.0 2.3 0.6 1.6 5.0 3.4 0.1 1.8 134.7 299.3 17.20 16.14 49 0.351 2351K 2860 0.0 0.0 Int 0/0 0.00 KB 0.0 2.3 0.6 1.6 5.0 3.4 0.1 1.8 134.7 299.3 17.20 16.14 49 0.351 2351K 2860 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 2.3 0.6 1.6 2.3 0.6 0.0 0.0 255.8 255.5 9.05 8.81 9 1.006 2351K 2860 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 348.0 8.15 7.33 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: 5.03 GB write, 554.07 MB/s write, 2.26 GB read, 249.26 MB/s read, 17.2 seconds Interval compaction: 5.03 GB write, 568.57 MB/s write, 2.26 GB read, 255.78 MB/s read, 17.2 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: 10, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 10, interval: 10 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 664695 Average: 2.0420 StdDev: 12.51 Min: 0 Median: 1.3960 Max: 4289 Percentiles: P50: 1.40 P75: 1.79 P99: 5.29 P99.9: 9.63 P99.99: 14.55 ------------------------------------------------------ [ 0, 1 ] 164189 24.701% 24.701% ##### ( 1, 2 ] 424693 63.893% 88.594% ############# ( 2, 3 ] 45518 6.848% 95.442% # ( 3, 4 ] 16614 2.499% 97.942% ( 4, 6 ] 10903 1.640% 99.582% ( 6, 10 ] 2334 0.351% 99.933% ( 10, 15 ] 418 0.063% 99.996% ( 15, 22 ] 32 0.005% 100.001% ( 22, 34 ] 12 0.002% 100.003% ( 34, 51 ] 4 0.001% 100.003% ( 51, 76 ] 1 0.000% 100.003% ( 110, 170 ] 25 0.004% 100.007% ( 170, 250 ] 13 0.002% 100.009% ( 250, 380 ] 20 0.003% 100.012% ( 380, 580 ] 5 0.001% 100.013% ( 580, 870 ] 8 0.001% 100.014% ( 870, 1300 ] 8 0.001% 100.015% ( 1300, 1900 ] 7 0.001% 100.016% ( 1900, 2900 ] 1 0.000% 100.017% ( 2900, 4400 ] 5 0.001% 100.017% ** Level 1 read latency histogram (micros): Count: 160066 Average: 2.0413 StdDev: 7.95 Min: 0 Median: 1.4256 Max: 1931 Percentiles: P50: 1.43 P75: 1.81 P99: 5.17 P99.9: 9.41 P99.99: 21.99 ------------------------------------------------------ [ 0, 1 ] 35145 21.957% 21.957% #### ( 1, 2 ] 105462 65.887% 87.843% ############# ( 2, 3 ] 12306 7.688% 95.531% ## ( 3, 4 ] 4053 2.532% 98.063% # ( 4, 6 ] 2554 1.596% 99.659% ( 6, 10 ] 453 0.283% 99.942% ( 10, 15 ] 72 0.045% 99.987% ( 15, 22 ] 5 0.003% 99.990% ( 22, 34 ] 1 0.001% 99.991% ( 76, 110 ] 1 0.001% 99.991% ( 110, 170 ] 1 0.001% 99.992% ( 250, 380 ] 4 0.002% 99.994% ( 380, 580 ] 3 0.002% 99.996% ( 580, 870 ] 2 0.001% 99.998% ( 870, 1300 ] 2 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 28204 Average: 2.1736 StdDev: 22.55 Min: 1 Median: 1.2014 Max: 3380 Percentiles: P50: 1.20 P75: 1.65 P99: 6.76 P99.9: 92.13 P99.99: 632.08 ------------------------------------------------------ [ 0, 1 ] 10971 38.899% 38.899% ######## ( 1, 2 ] 15548 55.127% 94.026% ########### ( 2, 3 ] 1005 3.563% 97.589% # ( 3, 4 ] 248 0.879% 98.468% ( 4, 6 ] 115 0.408% 98.876% ( 6, 10 ] 183 0.649% 99.525% ( 10, 15 ] 47 0.167% 99.692% ( 15, 22 ] 12 0.043% 99.734% ( 22, 34 ] 2 0.007% 99.741% ( 34, 51 ] 29 0.103% 99.844% ( 51, 76 ] 12 0.043% 99.887% ( 76, 110 ] 8 0.028% 99.915% ( 110, 170 ] 10 0.035% 99.950% ( 170, 250 ] 9 0.032% 99.982% ( 380, 580 ] 2 0.007% 99.989% ( 580, 870 ] 1 0.004% 99.993% ( 870, 1300 ] 1 0.004% 99.996% ( 2900, 4400 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 90 Average: 779.8889 StdDev: 1172.52 Min: 1 Median: 202.0000 Max: 5321 Percentiles: P50: 202.00 P75: 1192.50 P99: 5321.00 P99.9: 5321.00 P99.99: 5321.00 ------------------------------------------------------ [ 0, 1 ] 34 37.778% 37.778% ######## ( 1, 2 ] 4 4.444% 42.222% # ( 76, 110 ] 2 2.222% 44.444% ( 110, 170 ] 3 3.333% 47.778% # ( 170, 250 ] 5 5.556% 53.333% # ( 250, 380 ] 4 4.444% 57.778% # ( 380, 580 ] 5 5.556% 63.333% # ( 580, 870 ] 3 3.333% 66.667% # ( 870, 1300 ] 10 11.111% 77.778% ## ( 1300, 1900 ] 6 6.667% 84.444% # ( 1900, 2900 ] 8 8.889% 93.333% ## ( 2900, 4400 ] 4 4.444% 97.778% # ( 4400, 6600 ] 2 2.222% 100.000% ** Level 4 read latency histogram (micros): Count: 25 Average: 1908.0000 StdDev: 1532.98 Min: 251 Median: 1246.2500 Max: 5868 Percentiles: P50: 1246.25 P75: 2775.00 P99: 5868.00 P99.9: 5868.00 P99.99: 5868.00 ------------------------------------------------------ ( 250, 380 ] 1 4.000% 4.000% # ( 580, 870 ] 8 32.000% 36.000% ###### ( 870, 1300 ] 4 16.000% 52.000% ### ( 1300, 1900 ] 4 16.000% 68.000% ### ( 1900, 2900 ] 2 8.000% 76.000% ## ( 2900, 4400 ] 3 12.000% 88.000% ## ( 4400, 6600 ] 3 12.000% 100.000% ## ** DB Stats ** Uptime(secs): 9.3 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 317.80 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.978 H:M:S, 10.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 317.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.389 H:M:S, 12.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/07-16:00:46 ... thread 0: (1000000,4000000) ops and (319140.5,328267.8) ops/second in (3.133416,12.185175) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/4 2.34 GB 207.7 2.4 0.0 2.4 6.1 3.7 0.0 1.6 121.8 312.1 20.18 18.90 63 0.320 2494K 2652 0.0 0.0 L1 12/0 1.34 GB 137.6 2.2 1.3 0.9 2.1 1.3 0.1 1.7 232.5 231.6 9.47 9.18 3 3.157 2236K 8814 0.0 0.0 L2 1/0 49.09 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 226.5 226.5 0.49 0.46 1 0.493 113K 29 0.0 0.0 L3 18/0 881.37 MB 0.9 0.1 0.1 0.0 0.1 0.1 0.0 1.0 212.8 212.8 0.29 0.25 1 0.294 63K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.75 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1203/4 99.88 GB 0.0 4.7 1.4 3.3 8.5 5.2 0.1 2.3 158.8 284.7 30.43 28.79 68 0.448 4907K 11K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.7 1.4 3.3 8.5 5.2 0.1 2.3 158.8 284.7 30.43 28.79 68 0.448 4907K 11K 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.7 1.4 3.3 4.7 1.4 0.0 0.0 248.7 248.0 19.44 18.90 14 1.388 4907K 11K 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 349.5 10.99 9.89 54 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.4 total, 12.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: 8.46 GB write, 697.40 MB/s write, 4.72 GB read, 389.06 MB/s read, 30.4 seconds Interval compaction: 8.46 GB write, 710.96 MB/s write, 4.72 GB read, 396.62 MB/s read, 30.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 14, interval: 15 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 994899 Average: 2.1043 StdDev: 12.12 Min: 0 Median: 1.4154 Max: 4289 Percentiles: P50: 1.42 P75: 1.80 P99: 5.41 P99.9: 9.96 P99.99: 92.82 ------------------------------------------------------ [ 0, 1 ] 230931 23.212% 23.212% ##### ( 1, 2 ] 641573 64.486% 87.698% ############# ( 2, 3 ] 73131 7.351% 95.048% # ( 3, 4 ] 26581 2.672% 97.720% # ( 4, 6 ] 18068 1.816% 99.536% ( 6, 10 ] 3655 0.367% 99.904% ( 10, 15 ] 727 0.073% 99.977% ( 15, 22 ] 64 0.006% 99.983% ( 22, 34 ] 13 0.001% 99.984% ( 34, 51 ] 6 0.001% 99.985% ( 51, 76 ] 5 0.001% 99.985% ( 76, 110 ] 94 0.009% 99.995% ( 110, 170 ] 78 0.008% 100.003% ( 170, 250 ] 43 0.004% 100.007% ( 250, 380 ] 41 0.004% 100.011% ( 380, 580 ] 30 0.003% 100.014% ( 580, 870 ] 19 0.002% 100.016% ( 870, 1300 ] 12 0.001% 100.017% ( 1300, 1900 ] 10 0.001% 100.018% ( 1900, 2900 ] 2 0.000% 100.018% ( 2900, 4400 ] 6 0.001% 100.019% ** Level 1 read latency histogram (micros): Count: 207591 Average: 2.2150 StdDev: 12.03 Min: 0 Median: 1.4520 Max: 1931 Percentiles: P50: 1.45 P75: 1.83 P99: 5.39 P99.9: 9.94 P99.99: 559.30 ------------------------------------------------------ [ 0, 1 ] 41339 19.914% 19.914% #### ( 1, 2 ] 138166 66.557% 86.471% ############# ( 2, 3 ] 17629 8.492% 94.963% ## ( 3, 4 ] 5726 2.758% 97.721% # ( 4, 6 ] 3818 1.839% 99.560% ( 6, 10 ] 716 0.345% 99.905% ( 10, 15 ] 82 0.040% 99.945% ( 15, 22 ] 7 0.003% 99.948% ( 22, 34 ] 2 0.001% 99.949% ( 34, 51 ] 1 0.000% 99.949% ( 76, 110 ] 16 0.008% 99.957% ( 110, 170 ] 26 0.013% 99.970% ( 170, 250 ] 15 0.007% 99.977% ( 250, 380 ] 12 0.006% 99.983% ( 380, 580 ] 17 0.008% 99.991% ( 580, 870 ] 7 0.003% 99.994% ( 870, 1300 ] 8 0.004% 99.998% ( 1300, 1900 ] 3 0.001% 100.000% ( 1900, 2900 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28204 Average: 2.1736 StdDev: 22.55 Min: 1 Median: 1.2014 Max: 3380 Percentiles: P50: 1.20 P75: 1.65 P99: 6.76 P99.9: 92.13 P99.99: 632.08 ------------------------------------------------------ [ 0, 1 ] 10971 38.899% 38.899% ######## ( 1, 2 ] 15548 55.127% 94.026% ########### ( 2, 3 ] 1005 3.563% 97.589% # ( 3, 4 ] 248 0.879% 98.468% ( 4, 6 ] 115 0.408% 98.876% ( 6, 10 ] 183 0.649% 99.525% ( 10, 15 ] 47 0.167% 99.692% ( 15, 22 ] 12 0.043% 99.734% ( 22, 34 ] 2 0.007% 99.741% ( 34, 51 ] 29 0.103% 99.844% ( 51, 76 ] 12 0.043% 99.887% ( 76, 110 ] 8 0.028% 99.915% ( 110, 170 ] 10 0.035% 99.950% ( 170, 250 ] 9 0.032% 99.982% ( 380, 580 ] 2 0.007% 99.989% ( 580, 870 ] 1 0.004% 99.993% ( 870, 1300 ] 1 0.004% 99.996% ( 2900, 4400 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 90 Average: 779.8889 StdDev: 1172.52 Min: 1 Median: 202.0000 Max: 5321 Percentiles: P50: 202.00 P75: 1192.50 P99: 5321.00 P99.9: 5321.00 P99.99: 5321.00 ------------------------------------------------------ [ 0, 1 ] 34 37.778% 37.778% ######## ( 1, 2 ] 4 4.444% 42.222% # ( 76, 110 ] 2 2.222% 44.444% ( 110, 170 ] 3 3.333% 47.778% # ( 170, 250 ] 5 5.556% 53.333% # ( 250, 380 ] 4 4.444% 57.778% # ( 380, 580 ] 5 5.556% 63.333% # ( 580, 870 ] 3 3.333% 66.667% # ( 870, 1300 ] 10 11.111% 77.778% ## ( 1300, 1900 ] 6 6.667% 84.444% # ( 1900, 2900 ] 8 8.889% 93.333% ## ( 2900, 4400 ] 4 4.444% 97.778% # ( 4400, 6600 ] 2 2.222% 100.000% ** Level 4 read latency histogram (micros): Count: 25 Average: 1908.0000 StdDev: 1532.98 Min: 251 Median: 1246.2500 Max: 5868 Percentiles: P50: 1246.25 P75: 2775.00 P99: 5868.00 P99.9: 5868.00 P99.99: 5868.00 ------------------------------------------------------ ( 250, 380 ] 1 4.000% 4.000% # ( 580, 870 ] 8 32.000% 36.000% ###### ( 870, 1300 ] 4 16.000% 52.000% ### ( 1300, 1900 ] 4 16.000% 68.000% ### ( 1900, 2900 ] 2 8.000% 76.000% ## ( 2900, 4400 ] 3 12.000% 88.000% ## ( 4400, 6600 ] 3 12.000% 100.000% ## ** DB Stats ** Uptime(secs): 12.4 total, 3.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 316.87 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.378 H:M:S, 11.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 314.10 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.400 H:M:S, 12.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/07-16:00:49 ... thread 0: (1000000,5000000) ops and (311763.4,324828.5) ops/second in (3.207561,15.392736) 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.32 GB 50.4 3.2 0.0 3.2 7.9 4.7 0.0 1.7 125.8 312.0 26.04 24.43 80 0.325 3326K 3568 0.0 0.0 L1 12/12 1.34 GB 0.0 2.2 1.3 0.9 2.1 1.3 0.1 1.7 232.5 231.6 9.47 9.18 3 3.157 2236K 8814 0.0 0.0 L2 1/0 49.09 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 226.5 226.5 0.49 0.46 1 0.493 113K 29 0.0 0.0 L3 18/0 881.37 MB 0.9 0.1 0.1 0.0 0.1 0.1 0.0 1.0 212.8 212.8 0.29 0.25 1 0.294 63K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.75 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1208/25 100.86 GB 0.0 5.5 1.4 4.1 10.2 6.1 0.1 2.2 155.7 289.0 36.29 34.32 85 0.427 5739K 12K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.5 1.4 4.1 10.2 6.1 0.1 2.2 155.7 289.0 36.29 34.32 85 0.427 5739K 12K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.5 1.4 4.1 5.5 1.4 0.0 0.0 251.6 251.0 22.47 21.87 17 1.322 5739K 12K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 350.8 13.83 12.45 68 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.6 total, 15.4 interval Flush(GB): cumulative 4.737, interval 4.737 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 10.24 GB write, 671.10 MB/s write, 5.52 GB read, 361.61 MB/s read, 36.3 seconds Interval compaction: 10.24 GB write, 681.42 MB/s write, 5.52 GB read, 367.17 MB/s read, 36.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 2, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 2, 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: 2, total-stops: 16, interval: 18 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1258433 Average: 2.1036 StdDev: 12.38 Min: 0 Median: 1.4012 Max: 4289 Percentiles: P50: 1.40 P75: 1.79 P99: 5.35 P99.9: 10.47 P99.99: 126.35 ------------------------------------------------------ [ 0, 1 ] 305727 24.294% 24.294% ##### ( 1, 2 ] 806302 64.072% 88.366% ############# ( 2, 3 ] 87405 6.946% 95.312% # ( 3, 4 ] 32315 2.568% 97.880% # ( 4, 6 ] 20816 1.654% 99.534% ( 6, 10 ] 4530 0.360% 99.894% ( 10, 15 ] 861 0.068% 99.962% ( 15, 22 ] 81 0.006% 99.969% ( 22, 34 ] 14 0.001% 99.970% ( 34, 51 ] 7 0.001% 99.970% ( 51, 76 ] 8 0.001% 99.971% ( 76, 110 ] 198 0.016% 99.987% ( 110, 170 ] 162 0.013% 99.999% ( 170, 250 ] 71 0.006% 100.005% ( 250, 380 ] 60 0.005% 100.010% ( 380, 580 ] 48 0.004% 100.014% ( 580, 870 ] 26 0.002% 100.016% ( 870, 1300 ] 15 0.001% 100.017% ( 1300, 1900 ] 12 0.001% 100.018% ( 1900, 2900 ] 4 0.000% 100.018% ( 2900, 4400 ] 7 0.001% 100.019% ** Level 1 read latency histogram (micros): Count: 235991 Average: 2.2404 StdDev: 11.63 Min: 0 Median: 1.4503 Max: 1931 Percentiles: P50: 1.45 P75: 1.83 P99: 5.58 P99.9: 13.20 P99.99: 537.66 ------------------------------------------------------ [ 0, 1 ] 47497 20.127% 20.127% #### ( 1, 2 ] 156553 66.339% 86.465% ############# ( 2, 3 ] 19763 8.374% 94.840% ## ( 3, 4 ] 6487 2.749% 97.588% # ( 4, 6 ] 4225 1.790% 99.379% ( 6, 10 ] 1139 0.483% 99.861% ( 10, 15 ] 142 0.060% 99.922% ( 15, 22 ] 12 0.005% 99.927% ( 22, 34 ] 2 0.001% 99.928% ( 34, 51 ] 2 0.001% 99.928% ( 76, 110 ] 16 0.007% 99.935% ( 110, 170 ] 84 0.036% 99.971% ( 170, 250 ] 17 0.007% 99.978% ( 250, 380 ] 15 0.006% 99.984% ( 380, 580 ] 17 0.007% 99.992% ( 580, 870 ] 8 0.003% 99.995% ( 870, 1300 ] 8 0.003% 99.998% ( 1300, 1900 ] 3 0.001% 100.000% ( 1900, 2900 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28204 Average: 2.1736 StdDev: 22.55 Min: 1 Median: 1.2014 Max: 3380 Percentiles: P50: 1.20 P75: 1.65 P99: 6.76 P99.9: 92.13 P99.99: 632.08 ------------------------------------------------------ [ 0, 1 ] 10971 38.899% 38.899% ######## ( 1, 2 ] 15548 55.127% 94.026% ########### ( 2, 3 ] 1005 3.563% 97.589% # ( 3, 4 ] 248 0.879% 98.468% ( 4, 6 ] 115 0.408% 98.876% ( 6, 10 ] 183 0.649% 99.525% ( 10, 15 ] 47 0.167% 99.692% ( 15, 22 ] 12 0.043% 99.734% ( 22, 34 ] 2 0.007% 99.741% ( 34, 51 ] 29 0.103% 99.844% ( 51, 76 ] 12 0.043% 99.887% ( 76, 110 ] 8 0.028% 99.915% ( 110, 170 ] 10 0.035% 99.950% ( 170, 250 ] 9 0.032% 99.982% ( 380, 580 ] 2 0.007% 99.989% ( 580, 870 ] 1 0.004% 99.993% ( 870, 1300 ] 1 0.004% 99.996% ( 2900, 4400 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 90 Average: 779.8889 StdDev: 1172.52 Min: 1 Median: 202.0000 Max: 5321 Percentiles: P50: 202.00 P75: 1192.50 P99: 5321.00 P99.9: 5321.00 P99.99: 5321.00 ------------------------------------------------------ [ 0, 1 ] 34 37.778% 37.778% ######## ( 1, 2 ] 4 4.444% 42.222% # ( 76, 110 ] 2 2.222% 44.444% ( 110, 170 ] 3 3.333% 47.778% # ( 170, 250 ] 5 5.556% 53.333% # ( 250, 380 ] 4 4.444% 57.778% # ( 380, 580 ] 5 5.556% 63.333% # ( 580, 870 ] 3 3.333% 66.667% # ( 870, 1300 ] 10 11.111% 77.778% ## ( 1300, 1900 ] 6 6.667% 84.444% # ( 1900, 2900 ] 8 8.889% 93.333% ## ( 2900, 4400 ] 4 4.444% 97.778% # ( 4400, 6600 ] 2 2.222% 100.000% ** Level 4 read latency histogram (micros): Count: 25 Average: 1908.0000 StdDev: 1532.98 Min: 251 Median: 1246.2500 Max: 5868 Percentiles: P50: 1246.25 P75: 2775.00 P99: 5868.00 P99.9: 5868.00 P99.99: 5868.00 ------------------------------------------------------ ( 250, 380 ] 1 4.000% 4.000% # ( 580, 870 ] 8 32.000% 36.000% ###### ( 870, 1300 ] 4 16.000% 52.000% ### ( 1300, 1900 ] 4 16.000% 68.000% ### ( 1900, 2900 ] 2 8.000% 76.000% ## ( 2900, 4400 ] 3 12.000% 88.000% ## ( 4400, 6600 ] 3 12.000% 100.000% ## ** DB Stats ** Uptime(secs): 15.6 total, 3.2 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 314.81 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.903 H:M:S, 12.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 306.82 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.525 H:M:S, 16.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/07-16:01:08 ... thread 0: (1000000,6000000) ops and (53370.0,175799.2) ops/second in (18.737117,34.129853) 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 3/2 1.41 GB 6.3 5.5 0.0 5.5 11.2 5.6 0.0 2.0 149.8 302.7 37.83 35.65 100 0.378 5755K 11K 0.0 0.0 L1 9/9 1.08 GB 0.0 6.3 4.1 2.2 6.2 4.0 0.1 1.5 220.9 217.9 29.30 27.50 4 7.326 6573K 88K 0.0 0.0 L2 25/5 3.07 GB 25.8 0.1 0.1 0.0 0.1 0.1 3.0 1.8 226.5 226.5 0.49 0.46 1 0.493 113K 29 0.0 0.0 L3 18/11 881.37 MB 0.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 212.8 212.8 0.29 0.25 1 0.294 63K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.75 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1215/27 101.70 GB 0.0 12.0 4.2 7.8 17.6 9.8 3.1 3.1 181.3 265.2 67.92 63.86 106 0.641 12M 100K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.0 4.2 7.8 17.6 9.8 3.1 3.1 181.3 265.2 67.92 63.86 106 0.641 12M 100K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 12.0 4.2 7.8 11.9 4.1 0.0 0.0 239.7 237.8 51.37 48.99 23 2.234 12M 100K 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 350.1 16.55 14.87 83 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 34.4 total, 34.1 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 17.59 GB write, 524.06 MB/s write, 12.03 GB read, 358.35 MB/s read, 67.9 seconds Interval compaction: 17.59 GB write, 527.69 MB/s write, 12.03 GB read, 360.84 MB/s read, 67.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 16, pending-compaction-bytes-delays: 6, pending-compaction-bytes-stops: 0, total-delays: 16, total-stops: 16, interval: 32 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2555935 Average: 2.5421 StdDev: 15.99 Min: 0 Median: 1.4019 Max: 4289 Percentiles: P50: 1.40 P75: 1.79 P99: 6.00 P99.9: 146.32 P99.99: 363.39 ------------------------------------------------------ [ 0, 1 ] 616508 24.121% 24.121% ##### ( 1, 2 ] 1645719 64.388% 88.509% ############# ( 2, 3 ] 165430 6.472% 94.981% # ( 3, 4 ] 64590 2.527% 97.508% # ( 4, 6 ] 38150 1.493% 99.001% ( 6, 10 ] 15422 0.603% 99.604% ( 10, 15 ] 1835 0.072% 99.676% ( 15, 22 ] 325 0.013% 99.689% ( 22, 34 ] 34 0.001% 99.690% ( 34, 51 ] 10 0.000% 99.690% ( 51, 76 ] 37 0.001% 99.692% ( 76, 110 ] 3432 0.134% 99.826% ( 110, 170 ] 3119 0.122% 99.948% ( 170, 250 ] 649 0.025% 99.974% ( 250, 380 ] 482 0.019% 99.992% ( 380, 580 ] 404 0.016% 100.008% ( 580, 870 ] 169 0.007% 100.015% ( 870, 1300 ] 40 0.002% 100.016% ( 1300, 1900 ] 20 0.001% 100.017% ( 1900, 2900 ] 15 0.001% 100.018% ( 2900, 4400 ] 12 0.000% 100.018% ** Level 1 read latency histogram (micros): Count: 574118 Average: 2.6291 StdDev: 17.94 Min: 0 Median: 1.4133 Max: 3793 Percentiles: P50: 1.41 P75: 1.81 P99: 7.75 P99.9: 152.31 P99.99: 820.22 ------------------------------------------------------ [ 0, 1 ] 135746 23.644% 23.644% ##### ( 1, 2 ] 366104 63.768% 87.412% ############# ( 2, 3 ] 39480 6.877% 94.289% # ( 3, 4 ] 15032 2.618% 96.907% # ( 4, 6 ] 9549 1.663% 98.571% ( 6, 10 ] 5650 0.984% 99.555% ( 10, 15 ] 523 0.091% 99.646% ( 15, 22 ] 109 0.019% 99.665% ( 22, 34 ] 8 0.001% 99.666% ( 34, 51 ] 3 0.001% 99.667% ( 51, 76 ] 18 0.003% 99.670% ( 76, 110 ] 801 0.140% 99.809% ( 110, 170 ] 740 0.129% 99.938% ( 170, 250 ] 108 0.019% 99.957% ( 250, 380 ] 74 0.013% 99.970% ( 380, 580 ] 76 0.013% 99.983% ( 580, 870 ] 49 0.009% 99.992% ( 870, 1300 ] 34 0.006% 99.998% ( 1300, 1900 ] 10 0.002% 99.999% ( 1900, 2900 ] 2 0.000% 100.000% ( 2900, 4400 ] 3 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 28218 Average: 2.3706 StdDev: 25.38 Min: 1 Median: 1.2018 Max: 3380 Percentiles: P50: 1.20 P75: 1.66 P99: 7.07 P99.9: 150.53 P99.99: 1123.31 ------------------------------------------------------ [ 0, 1 ] 10971 38.879% 38.879% ######## ( 1, 2 ] 15548 55.100% 93.979% ########### ( 2, 3 ] 1005 3.562% 97.541% # ( 3, 4 ] 248 0.879% 98.419% ( 4, 6 ] 115 0.408% 98.827% ( 6, 10 ] 183 0.649% 99.476% ( 10, 15 ] 47 0.167% 99.642% ( 15, 22 ] 12 0.043% 99.685% ( 22, 34 ] 2 0.007% 99.692% ( 34, 51 ] 29 0.103% 99.794% ( 51, 76 ] 12 0.043% 99.837% ( 76, 110 ] 9 0.032% 99.869% ( 110, 170 ] 13 0.046% 99.915% ( 170, 250 ] 10 0.035% 99.950% ( 250, 380 ] 5 0.018% 99.968% ( 380, 580 ] 4 0.014% 99.982% ( 580, 870 ] 1 0.004% 99.986% ( 870, 1300 ] 2 0.007% 99.993% ( 1300, 1900 ] 1 0.004% 99.996% ( 2900, 4400 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 19130 Average: 9.7977 StdDev: 108.50 Min: 1 Median: 1.5635 Max: 5321 Percentiles: P50: 1.56 P75: 1.95 P99: 159.72 P99.9: 1665.18 P99.99: 4495.59 ------------------------------------------------------ [ 0, 1 ] 2628 13.738% 13.738% ### ( 1, 2 ] 12311 64.354% 78.092% ############# ( 2, 3 ] 1887 9.864% 87.956% ## ( 3, 4 ] 888 4.642% 92.598% # ( 4, 6 ] 753 3.936% 96.534% # ( 6, 10 ] 352 1.840% 98.374% ( 10, 15 ] 56 0.293% 98.667% ( 15, 22 ] 3 0.016% 98.683% ( 76, 110 ] 7 0.037% 98.719% ( 110, 170 ] 66 0.345% 99.064% ( 170, 250 ] 43 0.225% 99.289% ( 250, 380 ] 36 0.188% 99.477% ( 380, 580 ] 30 0.157% 99.634% ( 580, 870 ] 26 0.136% 99.770% ( 870, 1300 ] 21 0.110% 99.880% ( 1300, 1900 ] 8 0.042% 99.922% ( 1900, 2900 ] 10 0.052% 99.974% ( 2900, 4400 ] 4 0.021% 99.995% ( 4400, 6600 ] 2 0.010% 100.005% ** Level 4 read latency histogram (micros): Count: 25 Average: 1908.0000 StdDev: 1532.98 Min: 251 Median: 1246.2500 Max: 5868 Percentiles: P50: 1246.25 P75: 2775.00 P99: 5868.00 P99.9: 5868.00 P99.99: 5868.00 ------------------------------------------------------ ( 250, 380 ] 1 4.000% 4.000% # ( 580, 870 ] 8 32.000% 36.000% ###### ( 870, 1300 ] 4 16.000% 52.000% ### ( 1300, 1900 ] 4 16.000% 68.000% ### ( 1900, 2900 ] 2 8.000% 76.000% ## ( 2900, 4400 ] 3 12.000% 88.000% ## ( 4400, 6600 ] 3 12.000% 100.000% ## ** DB Stats ** Uptime(secs): 34.4 total, 18.7 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 171.82 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:17.169 H:M:S, 50.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 52.53 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:15.266 H:M:S, 81.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/07-16:01:16 ... thread 0: (1000000,7000000) ops and (134954.7,168513.3) ops/second in (7.409893,41.539746) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/6 2.33 GB 63.0 6.0 0.0 6.0 12.6 6.6 0.0 1.9 140.1 292.8 44.06 40.23 115 0.383 6267K 12K 0.0 0.0 L1 9/9 1.08 GB 0.0 6.3 4.1 2.2 6.2 4.0 0.1 1.5 220.9 217.9 29.30 27.50 4 7.326 6573K 88K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 3.0 1.8 226.5 226.5 0.49 0.46 1 0.493 113K 29 0.0 0.0 L3 21/0 942.55 MB 0.9 4.6 3.0 1.6 4.6 3.0 0.1 1.5 134.4 134.3 34.83 21.39 22 1.583 4726K 1273 0.0 0.0 L4 152/0 9.59 GB 1.0 0.1 0.1 0.0 0.1 0.1 2.9 1.0 184.3 184.3 0.47 0.39 1 0.469 86K 0 0.0 0.0 L5 1080/0 88.71 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1272/15 102.62 GB 0.0 17.1 7.3 9.8 23.6 13.7 9.1 3.6 160.5 221.3 109.16 89.97 143 0.763 17M 102K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.1 7.3 9.8 23.6 13.7 9.1 3.6 160.5 221.3 109.16 89.97 143 0.763 17M 102K 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 17.1 7.3 9.8 17.0 7.2 0.0 0.0 197.4 196.3 88.76 72.55 47 1.889 17M 102K 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 330.5 20.40 17.42 96 0.212 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): 41.8 total, 41.5 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: 23.60 GB write, 578.32 MB/s write, 17.11 GB read, 419.46 MB/s read, 109.2 seconds Interval compaction: 23.60 GB write, 581.62 MB/s write, 17.11 GB read, 421.85 MB/s read, 109.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 30, pending-compaction-bytes-delays: 17, pending-compaction-bytes-stops: 0, total-delays: 27, total-stops: 30, interval: 57 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2986933 Average: 2.8274 StdDev: 30.93 Min: 0 Median: 1.4474 Max: 7283 Percentiles: P50: 1.45 P75: 1.84 P99: 7.05 P99.9: 148.14 P99.99: 494.75 ------------------------------------------------------ [ 0, 1 ] 644183 21.567% 21.567% #### ( 1, 2 ] 1898315 63.554% 85.121% ############# ( 2, 3 ] 243680 8.158% 93.279% ## ( 3, 4 ] 93293 3.123% 96.402% # ( 4, 6 ] 71304 2.387% 98.789% ( 6, 10 ] 23925 0.801% 99.590% ( 10, 15 ] 3235 0.108% 99.699% ( 15, 22 ] 474 0.016% 99.715% ( 22, 34 ] 40 0.001% 99.716% ( 34, 51 ] 13 0.000% 99.716% ( 51, 76 ] 40 0.001% 99.718% ( 76, 110 ] 3438 0.115% 99.833% ( 110, 170 ] 3156 0.106% 99.938% ( 170, 250 ] 698 0.023% 99.962% ( 250, 380 ] 554 0.019% 99.980% ( 380, 580 ] 499 0.017% 99.997% ( 580, 870 ] 284 0.010% 100.007% ( 870, 1300 ] 105 0.004% 100.010% ( 1300, 1900 ] 60 0.002% 100.012% ( 1900, 2900 ] 59 0.002% 100.014% ( 2900, 4400 ] 91 0.003% 100.017% ( 4400, 6600 ] 17 0.001% 100.018% ( 6600, 9900 ] 4 0.000% 100.018% ** Level 1 read latency histogram (micros): Count: 1368410 Average: 6.0137 StdDev: 96.04 Min: 0 Median: 1.6768 Max: 8572 Percentiles: P50: 1.68 P75: 2.44 P99: 9.46 P99.9: 154.92 P99.99: 434.03 ------------------------------------------------------ [ 0, 1 ] 157357 11.499% 11.499% ## ( 1, 2 ] 778462 56.888% 68.387% ########### ( 2, 3 ] 203430 14.866% 83.253% ### ( 3, 4 ] 94206 6.884% 90.138% # ( 4, 6 ] 97479 7.124% 97.261% # ( 6, 10 ] 27500 2.010% 99.271% ( 10, 15 ] 5925 0.433% 99.704% ( 15, 22 ] 842 0.062% 99.765% ( 22, 34 ] 87 0.006% 99.772% ( 34, 51 ] 28 0.002% 99.774% ( 51, 76 ] 41 0.003% 99.777% ( 76, 110 ] 894 0.065% 99.842% ( 110, 170 ] 1056 0.077% 99.919% ( 170, 250 ] 428 0.031% 99.951% ( 250, 380 ] 412 0.030% 99.981% ( 380, 580 ] 467 0.034% 100.015% ( 580, 870 ] 424 0.031% 100.046% ( 870, 1300 ] 335 0.024% 100.070% ( 1300, 1900 ] 269 0.020% 100.090% ( 1900, 2900 ] 324 0.024% 100.114% ( 2900, 4400 ] 453 0.033% 100.147% ( 4400, 6600 ] 80 0.006% 100.153% ( 6600, 9900 ] 28 0.002% 100.155% ** Level 2 read latency histogram (micros): Count: 40670 Average: 3.9927 StdDev: 40.31 Min: 1 Median: 1.3732 Max: 3380 Percentiles: P50: 1.37 P75: 1.83 P99: 9.42 P99.9: 584.56 P99.99: 1722.83 ------------------------------------------------------ [ 0, 1 ] 11963 29.415% 29.415% ###### ( 1, 2 ] 22436 55.166% 84.581% ########### ( 2, 3 ] 2990 7.352% 91.933% # ( 3, 4 ] 1255 3.086% 95.018% # ( 4, 6 ] 1178 2.896% 97.915% # ( 6, 10 ] 516 1.269% 99.184% ( 10, 15 ] 107 0.263% 99.447% ( 15, 22 ] 19 0.047% 99.493% ( 22, 34 ] 2 0.005% 99.498% ( 34, 51 ] 29 0.071% 99.570% ( 51, 76 ] 12 0.030% 99.599% ( 76, 110 ] 10 0.025% 99.624% ( 110, 170 ] 24 0.059% 99.683% ( 170, 250 ] 20 0.049% 99.732% ( 250, 380 ] 35 0.086% 99.818% ( 380, 580 ] 33 0.081% 99.899% ( 580, 870 ] 21 0.052% 99.951% ( 870, 1300 ] 11 0.027% 99.978% ( 1300, 1900 ] 7 0.017% 99.995% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 429916 Average: 4.8477 StdDev: 65.56 Min: 0 Median: 1.7560 Max: 6839 Percentiles: P50: 1.76 P75: 2.67 P99: 9.19 P99.9: 241.94 P99.99: 567.99 ------------------------------------------------------ [ 0, 1 ] 30683 7.137% 7.137% # ( 1, 2 ] 243736 56.694% 63.831% ########### ( 2, 3 ] 72195 16.793% 80.624% ### ( 3, 4 ] 35426 8.240% 88.864% ## ( 4, 6 ] 37278 8.671% 97.535% ## ( 6, 10 ] 7896 1.837% 99.372% ( 10, 15 ] 1413 0.329% 99.700% ( 15, 22 ] 134 0.031% 99.731% ( 22, 34 ] 12 0.003% 99.734% ( 34, 51 ] 11 0.003% 99.737% ( 51, 76 ] 9 0.002% 99.739% ( 76, 110 ] 103 0.024% 99.763% ( 110, 170 ] 341 0.079% 99.842% ( 170, 250 ] 277 0.064% 99.906% ( 250, 380 ] 187 0.043% 99.950% ( 380, 580 ] 183 0.043% 99.993% ( 580, 870 ] 142 0.033% 100.026% ( 870, 1300 ] 93 0.022% 100.047% ( 1300, 1900 ] 41 0.010% 100.057% ( 1900, 2900 ] 52 0.012% 100.069% ( 2900, 4400 ] 54 0.013% 100.081% ( 4400, 6600 ] 15 0.003% 100.085% ( 6600, 9900 ] 2 0.000% 100.085% ** Level 4 read latency histogram (micros): Count: 45 Average: 1092.8000 StdDev: 1471.00 Min: 1 Median: 670.6250 Max: 5868 Percentiles: P50: 670.62 P75: 1412.50 P99: 5868.00 P99.9: 5868.00 P99.99: 5868.00 ------------------------------------------------------ [ 0, 1 ] 2 4.444% 4.444% # ( 1, 2 ] 7 15.556% 20.000% ### ( 2, 3 ] 5 11.111% 31.111% ## ( 3, 4 ] 1 2.222% 33.333% ( 4, 6 ] 1 2.222% 35.556% ( 6, 10 ] 1 2.222% 37.778% ( 34, 51 ] 1 2.222% 40.000% ( 250, 380 ] 2 4.444% 44.444% # ( 580, 870 ] 8 17.778% 62.222% #### ( 870, 1300 ] 5 11.111% 73.333% ## ( 1300, 1900 ] 4 8.889% 82.222% ## ( 1900, 2900 ] 2 4.444% 86.667% # ( 2900, 4400 ] 3 6.667% 93.333% # ( 4400, 6600 ] 3 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 180 Average: 1320.1111 StdDev: 1315.49 Min: 88 Median: 732.6316 Max: 5095 Percentiles: P50: 732.63 P75: 2191.67 P99: 5095.00 P99.9: 5095.00 P99.99: 5095.00 ------------------------------------------------------ ( 76, 110 ] 10 5.556% 5.556% # ( 110, 170 ] 10 5.556% 11.111% # ( 170, 250 ] 16 8.889% 20.000% ## ( 250, 380 ] 23 12.778% 32.778% ### ( 380, 580 ] 21 11.667% 44.444% ## ( 580, 870 ] 19 10.556% 55.000% ## ( 870, 1300 ] 17 9.444% 64.444% ## ( 1300, 1900 ] 12 6.667% 71.111% # ( 1900, 2900 ] 24 13.333% 84.444% ### ( 2900, 4400 ] 23 12.778% 97.222% ### ( 4400, 6600 ] 5 2.778% 100.000% # ** DB Stats ** Uptime(secs): 41.8 total, 7.4 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 164.90 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:21.561 H:M:S, 51.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 132.82 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:4.393 H:M:S, 59.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/07-16:01:19 ... thread 0: (1000000,8000000) ops and (320830.1,179144.6) ops/second in (3.116915,44.656661) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/2 3.31 GB 201.4 7.2 0.0 7.2 14.7 7.6 0.0 1.9 142.9 292.8 51.58 47.39 133 0.388 7482K 13K 0.0 0.0 L1 9/9 1.08 GB 0.0 6.3 4.1 2.2 6.2 4.0 0.1 1.5 220.9 217.9 29.30 27.50 4 7.326 6573K 88K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 3.0 1.8 226.5 226.5 0.49 0.46 1 0.493 113K 29 0.0 0.0 L3 21/0 942.55 MB 0.9 4.6 3.0 1.6 4.6 3.0 0.1 1.5 134.4 134.3 34.83 21.39 22 1.583 4726K 1273 0.0 0.0 L4 152/0 9.59 GB 1.0 0.1 0.1 0.0 0.1 0.1 2.9 1.0 184.3 184.3 0.47 0.39 1 0.469 86K 0 0.0 0.0 L5 1080/0 88.71 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1274/11 103.60 GB 0.0 18.3 7.3 11.0 25.7 14.7 9.1 3.4 160.4 226.0 116.68 97.13 161 0.725 18M 103K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.3 7.3 11.0 25.7 14.7 9.1 3.4 160.4 226.0 116.68 97.13 161 0.725 18M 103K 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 18.3 7.3 11.0 18.2 7.2 0.0 0.0 200.4 199.3 93.40 77.10 51 1.831 18M 103K 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 332.8 23.28 20.03 110 0.212 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 44.9 total, 44.7 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: 25.75 GB write, 587.25 MB/s write, 18.28 GB read, 417.00 MB/s read, 116.7 seconds Interval compaction: 25.75 GB write, 590.37 MB/s write, 18.28 GB read, 419.21 MB/s read, 116.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 33, pending-compaction-bytes-delays: 17, pending-compaction-bytes-stops: 0, total-delays: 27, total-stops: 33, interval: 60 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3294931 Average: 2.7749 StdDev: 29.65 Min: 0 Median: 1.4557 Max: 7283 Percentiles: P50: 1.46 P75: 1.85 P99: 6.82 P99.9: 141.11 P99.99: 450.72 ------------------------------------------------------ [ 0, 1 ] 688916 20.908% 20.908% #### ( 1, 2 ] 2103466 63.839% 84.748% ############# ( 2, 3 ] 277716 8.429% 93.176% ## ( 3, 4 ] 105959 3.216% 96.392% # ( 4, 6 ] 80627 2.447% 98.839% ( 6, 10 ] 25778 0.782% 99.622% ( 10, 15 ] 3500 0.106% 99.728% ( 15, 22 ] 499 0.015% 99.743% ( 22, 34 ] 41 0.001% 99.744% ( 34, 51 ] 13 0.000% 99.745% ( 51, 76 ] 42 0.001% 99.746% ( 76, 110 ] 3439 0.104% 99.850% ( 110, 170 ] 3163 0.096% 99.946% ( 170, 250 ] 703 0.021% 99.968% ( 250, 380 ] 562 0.017% 99.985% ( 380, 580 ] 502 0.015% 100.000% ( 580, 870 ] 290 0.009% 100.009% ( 870, 1300 ] 110 0.003% 100.012% ( 1300, 1900 ] 62 0.002% 100.014% ( 1900, 2900 ] 59 0.002% 100.016% ( 2900, 4400 ] 91 0.003% 100.018% ( 4400, 6600 ] 18 0.001% 100.019% ( 6600, 9900 ] 4 0.000% 100.019% ** Level 1 read latency histogram (micros): Count: 1502188 Average: 5.7282 StdDev: 91.75 Min: 0 Median: 1.6669 Max: 8572 Percentiles: P50: 1.67 P75: 2.39 P99: 9.40 P99.9: 155.24 P99.99: 443.37 ------------------------------------------------------ [ 0, 1 ] 171167 11.395% 11.395% ## ( 1, 2 ] 869597 57.889% 69.283% ############ ( 2, 3 ] 220343 14.668% 83.951% ### ( 3, 4 ] 99109 6.598% 90.549% # ( 4, 6 ] 101637 6.766% 97.315% # ( 6, 10 ] 29804 1.984% 99.299% ( 10, 15 ] 6142 0.409% 99.708% ( 15, 22 ] 856 0.057% 99.765% ( 22, 34 ] 90 0.006% 99.771% ( 34, 51 ] 29 0.002% 99.773% ( 51, 76 ] 48 0.003% 99.776% ( 76, 110 ] 968 0.064% 99.840% ( 110, 170 ] 1188 0.079% 99.919% ( 170, 250 ] 470 0.031% 99.951% ( 250, 380 ] 432 0.029% 99.979% ( 380, 580 ] 498 0.033% 100.013% ( 580, 870 ] 434 0.029% 100.042% ( 870, 1300 ] 338 0.023% 100.064% ( 1300, 1900 ] 270 0.018% 100.082% ( 1900, 2900 ] 324 0.022% 100.104% ( 2900, 4400 ] 453 0.030% 100.134% ( 4400, 6600 ] 80 0.005% 100.139% ( 6600, 9900 ] 28 0.002% 100.141% ** Level 2 read latency histogram (micros): Count: 40670 Average: 3.9927 StdDev: 40.31 Min: 1 Median: 1.3732 Max: 3380 Percentiles: P50: 1.37 P75: 1.83 P99: 9.42 P99.9: 584.56 P99.99: 1722.83 ------------------------------------------------------ [ 0, 1 ] 11963 29.415% 29.415% ###### ( 1, 2 ] 22436 55.166% 84.581% ########### ( 2, 3 ] 2990 7.352% 91.933% # ( 3, 4 ] 1255 3.086% 95.018% # ( 4, 6 ] 1178 2.896% 97.915% # ( 6, 10 ] 516 1.269% 99.184% ( 10, 15 ] 107 0.263% 99.447% ( 15, 22 ] 19 0.047% 99.493% ( 22, 34 ] 2 0.005% 99.498% ( 34, 51 ] 29 0.071% 99.570% ( 51, 76 ] 12 0.030% 99.599% ( 76, 110 ] 10 0.025% 99.624% ( 110, 170 ] 24 0.059% 99.683% ( 170, 250 ] 20 0.049% 99.732% ( 250, 380 ] 35 0.086% 99.818% ( 380, 580 ] 33 0.081% 99.899% ( 580, 870 ] 21 0.052% 99.951% ( 870, 1300 ] 11 0.027% 99.978% ( 1300, 1900 ] 7 0.017% 99.995% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 429916 Average: 4.8477 StdDev: 65.56 Min: 0 Median: 1.7560 Max: 6839 Percentiles: P50: 1.76 P75: 2.67 P99: 9.19 P99.9: 241.94 P99.99: 567.99 ------------------------------------------------------ [ 0, 1 ] 30683 7.137% 7.137% # ( 1, 2 ] 243736 56.694% 63.831% ########### ( 2, 3 ] 72195 16.793% 80.624% ### ( 3, 4 ] 35426 8.240% 88.864% ## ( 4, 6 ] 37278 8.671% 97.535% ## ( 6, 10 ] 7896 1.837% 99.372% ( 10, 15 ] 1413 0.329% 99.700% ( 15, 22 ] 134 0.031% 99.731% ( 22, 34 ] 12 0.003% 99.734% ( 34, 51 ] 11 0.003% 99.737% ( 51, 76 ] 9 0.002% 99.739% ( 76, 110 ] 103 0.024% 99.763% ( 110, 170 ] 341 0.079% 99.842% ( 170, 250 ] 277 0.064% 99.906% ( 250, 380 ] 187 0.043% 99.950% ( 380, 580 ] 183 0.043% 99.993% ( 580, 870 ] 142 0.033% 100.026% ( 870, 1300 ] 93 0.022% 100.047% ( 1300, 1900 ] 41 0.010% 100.057% ( 1900, 2900 ] 52 0.012% 100.069% ( 2900, 4400 ] 54 0.013% 100.081% ( 4400, 6600 ] 15 0.003% 100.085% ( 6600, 9900 ] 2 0.000% 100.085% ** Level 4 read latency histogram (micros): Count: 45 Average: 1092.8000 StdDev: 1471.00 Min: 1 Median: 670.6250 Max: 5868 Percentiles: P50: 670.62 P75: 1412.50 P99: 5868.00 P99.9: 5868.00 P99.99: 5868.00 ------------------------------------------------------ [ 0, 1 ] 2 4.444% 4.444% # ( 1, 2 ] 7 15.556% 20.000% ### ( 2, 3 ] 5 11.111% 31.111% ## ( 3, 4 ] 1 2.222% 33.333% ( 4, 6 ] 1 2.222% 35.556% ( 6, 10 ] 1 2.222% 37.778% ( 34, 51 ] 1 2.222% 40.000% ( 250, 380 ] 2 4.444% 44.444% # ( 580, 870 ] 8 17.778% 62.222% #### ( 870, 1300 ] 5 11.111% 73.333% ## ( 1300, 1900 ] 4 8.889% 82.222% ## ( 1900, 2900 ] 2 4.444% 86.667% # ( 2900, 4400 ] 3 6.667% 93.333% # ( 4400, 6600 ] 3 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 180 Average: 1320.1111 StdDev: 1315.49 Min: 88 Median: 732.6316 Max: 5095 Percentiles: P50: 732.63 P75: 2191.67 P99: 5095.00 P99.9: 5095.00 P99.99: 5095.00 ------------------------------------------------------ ( 76, 110 ] 10 5.556% 5.556% # ( 110, 170 ] 10 5.556% 11.111% # ( 170, 250 ] 16 8.889% 20.000% ## ( 250, 380 ] 23 12.778% 32.778% ### ( 380, 580 ] 21 11.667% 44.444% ## ( 580, 870 ] 19 10.556% 55.000% ## ( 870, 1300 ] 17 9.444% 64.444% ## ( 1300, 1900 ] 12 6.667% 71.111% # ( 1900, 2900 ] 24 13.333% 84.444% ### ( 2900, 4400 ] 23 12.778% 97.222% ### ( 4400, 6600 ] 5 2.778% 100.000% # ** DB Stats ** Uptime(secs): 44.9 total, 3.1 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 175.37 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:21.952 H:M:S, 48.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 315.76 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.391 H:M:S, 12.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/07-16:01:22 ... thread 0: (1000000,9000000) ops and (318696.2,188306.4) ops/second in (3.137785,47.794446) 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/8 2.89 GB 239.1 7.8 0.0 7.8 16.2 8.5 0.0 1.9 140.1 293.4 56.63 52.08 148 0.383 8058K 14K 0.0 0.0 L1 23/0 1.91 GB 195.4 8.7 5.5 3.3 8.6 5.4 0.1 1.6 212.3 209.8 42.17 38.33 5 8.434 7972K 88K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 3.5 1.8 226.5 226.5 0.49 0.46 1 0.493 113K 29 0.0 0.0 L3 24/0 993.33 MB 1.0 4.6 3.0 1.6 4.6 3.0 0.6 1.5 134.4 134.3 34.83 21.39 22 1.583 4726K 1273 0.0 0.0 L4 157/0 9.66 GB 1.0 0.1 0.1 0.0 0.1 0.1 3.4 1.0 184.3 184.3 0.47 0.39 1 0.469 86K 0 0.0 0.0 L5 1084/0 89.08 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1305/8 104.51 GB 0.0 21.3 8.6 12.6 29.6 17.0 10.9 3.5 161.7 225.4 134.60 112.65 177 0.760 20M 104K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.3 8.6 12.6 29.6 17.0 10.9 3.5 161.7 225.4 134.60 112.65 177 0.760 20M 104K 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.3 8.6 12.6 21.1 8.5 0.0 0.0 200.6 199.5 108.51 90.15 54 2.010 20M 104K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 0.0 0.0 0.0 333.3 26.08 22.50 123 0.212 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): 48.0 total, 47.8 interval Flush(GB): cumulative 8.490, interval 8.490 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 29.63 GB write, 631.61 MB/s write, 21.26 GB read, 453.16 MB/s read, 134.6 seconds Interval compaction: 29.63 GB write, 634.74 MB/s write, 21.26 GB read, 455.40 MB/s read, 134.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 44, pending-compaction-bytes-delays: 17, pending-compaction-bytes-stops: 0, total-delays: 27, total-stops: 44, interval: 71 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3540081 Average: 2.7270 StdDev: 28.73 Min: 0 Median: 1.4527 Max: 7283 Percentiles: P50: 1.45 P75: 1.84 P99: 6.61 P99.9: 137.17 P99.99: 438.48 ------------------------------------------------------ [ 0, 1 ] 745701 21.065% 21.065% #### ( 1, 2 ] 2262779 63.919% 84.983% ############# ( 2, 3 ] 295616 8.351% 93.334% ## ( 3, 4 ] 112484 3.177% 96.511% # ( 4, 6 ] 84049 2.374% 98.886% ( 6, 10 ] 26743 0.755% 99.641% ( 10, 15 ] 3674 0.104% 99.745% ( 15, 22 ] 511 0.014% 99.759% ( 22, 34 ] 49 0.001% 99.761% ( 34, 51 ] 14 0.000% 99.761% ( 51, 76 ] 43 0.001% 99.762% ( 76, 110 ] 3439 0.097% 99.859% ( 110, 170 ] 3182 0.090% 99.949% ( 170, 250 ] 719 0.020% 99.970% ( 250, 380 ] 576 0.016% 99.986% ( 380, 580 ] 513 0.014% 100.000% ( 580, 870 ] 294 0.008% 100.009% ( 870, 1300 ] 113 0.003% 100.012% ( 1300, 1900 ] 62 0.002% 100.014% ( 1900, 2900 ] 62 0.002% 100.015% ( 2900, 4400 ] 91 0.003% 100.018% ( 4400, 6600 ] 18 0.001% 100.018% ( 6600, 9900 ] 4 0.000% 100.019% ** Level 1 read latency histogram (micros): Count: 1584254 Average: 5.6065 StdDev: 89.62 Min: 0 Median: 1.6584 Max: 8572 Percentiles: P50: 1.66 P75: 2.35 P99: 9.37 P99.9: 158.88 P99.99: 466.43 ------------------------------------------------------ [ 0, 1 ] 182250 11.504% 11.504% ## ( 1, 2 ] 926238 58.465% 69.969% ############ ( 2, 3 ] 228895 14.448% 84.417% ### ( 3, 4 ] 101578 6.412% 90.829% # ( 4, 6 ] 103187 6.513% 97.342% # ( 6, 10 ] 31197 1.969% 99.311% ( 10, 15 ] 6234 0.393% 99.705% ( 15, 22 ] 865 0.055% 99.760% ( 22, 34 ] 94 0.006% 99.765% ( 34, 51 ] 29 0.002% 99.767% ( 51, 76 ] 50 0.003% 99.770% ( 76, 110 ] 1041 0.066% 99.836% ( 110, 170 ] 1242 0.078% 99.915% ( 170, 250 ] 505 0.032% 99.946% ( 250, 380 ] 465 0.029% 99.976% ( 380, 580 ] 522 0.033% 100.009% ( 580, 870 ] 457 0.029% 100.038% ( 870, 1300 ] 360 0.023% 100.060% ( 1300, 1900 ] 275 0.017% 100.078% ( 1900, 2900 ] 325 0.021% 100.098% ( 2900, 4400 ] 454 0.029% 100.127% ( 4400, 6600 ] 80 0.005% 100.132% ( 6600, 9900 ] 28 0.002% 100.134% ** Level 2 read latency histogram (micros): Count: 40670 Average: 3.9927 StdDev: 40.31 Min: 1 Median: 1.3732 Max: 3380 Percentiles: P50: 1.37 P75: 1.83 P99: 9.42 P99.9: 584.56 P99.99: 1722.83 ------------------------------------------------------ [ 0, 1 ] 11963 29.415% 29.415% ###### ( 1, 2 ] 22436 55.166% 84.581% ########### ( 2, 3 ] 2990 7.352% 91.933% # ( 3, 4 ] 1255 3.086% 95.018% # ( 4, 6 ] 1178 2.896% 97.915% # ( 6, 10 ] 516 1.269% 99.184% ( 10, 15 ] 107 0.263% 99.447% ( 15, 22 ] 19 0.047% 99.493% ( 22, 34 ] 2 0.005% 99.498% ( 34, 51 ] 29 0.071% 99.570% ( 51, 76 ] 12 0.030% 99.599% ( 76, 110 ] 10 0.025% 99.624% ( 110, 170 ] 24 0.059% 99.683% ( 170, 250 ] 20 0.049% 99.732% ( 250, 380 ] 35 0.086% 99.818% ( 380, 580 ] 33 0.081% 99.899% ( 580, 870 ] 21 0.052% 99.951% ( 870, 1300 ] 11 0.027% 99.978% ( 1300, 1900 ] 7 0.017% 99.995% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 429916 Average: 4.8477 StdDev: 65.56 Min: 0 Median: 1.7560 Max: 6839 Percentiles: P50: 1.76 P75: 2.67 P99: 9.19 P99.9: 241.94 P99.99: 567.99 ------------------------------------------------------ [ 0, 1 ] 30683 7.137% 7.137% # ( 1, 2 ] 243736 56.694% 63.831% ########### ( 2, 3 ] 72195 16.793% 80.624% ### ( 3, 4 ] 35426 8.240% 88.864% ## ( 4, 6 ] 37278 8.671% 97.535% ## ( 6, 10 ] 7896 1.837% 99.372% ( 10, 15 ] 1413 0.329% 99.700% ( 15, 22 ] 134 0.031% 99.731% ( 22, 34 ] 12 0.003% 99.734% ( 34, 51 ] 11 0.003% 99.737% ( 51, 76 ] 9 0.002% 99.739% ( 76, 110 ] 103 0.024% 99.763% ( 110, 170 ] 341 0.079% 99.842% ( 170, 250 ] 277 0.064% 99.906% ( 250, 380 ] 187 0.043% 99.950% ( 380, 580 ] 183 0.043% 99.993% ( 580, 870 ] 142 0.033% 100.026% ( 870, 1300 ] 93 0.022% 100.047% ( 1300, 1900 ] 41 0.010% 100.057% ( 1900, 2900 ] 52 0.012% 100.069% ( 2900, 4400 ] 54 0.013% 100.081% ( 4400, 6600 ] 15 0.003% 100.085% ( 6600, 9900 ] 2 0.000% 100.085% ** Level 4 read latency histogram (micros): Count: 45 Average: 1092.8000 StdDev: 1471.00 Min: 1 Median: 670.6250 Max: 5868 Percentiles: P50: 670.62 P75: 1412.50 P99: 5868.00 P99.9: 5868.00 P99.99: 5868.00 ------------------------------------------------------ [ 0, 1 ] 2 4.444% 4.444% # ( 1, 2 ] 7 15.556% 20.000% ### ( 2, 3 ] 5 11.111% 31.111% ## ( 3, 4 ] 1 2.222% 33.333% ( 4, 6 ] 1 2.222% 35.556% ( 6, 10 ] 1 2.222% 37.778% ( 34, 51 ] 1 2.222% 40.000% ( 250, 380 ] 2 4.444% 44.444% # ( 580, 870 ] 8 17.778% 62.222% #### ( 870, 1300 ] 5 11.111% 73.333% ## ( 1300, 1900 ] 4 8.889% 82.222% ## ( 1900, 2900 ] 2 4.444% 86.667% # ( 2900, 4400 ] 3 6.667% 93.333% # ( 4400, 6600 ] 3 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 200 Average: 1282.3050 StdDev: 1300.59 Min: 88 Median: 681.5000 Max: 5095 Percentiles: P50: 681.50 P75: 2100.00 P99: 5095.00 P99.9: 5095.00 P99.99: 5095.00 ------------------------------------------------------ ( 76, 110 ] 12 6.000% 6.000% # ( 110, 170 ] 10 5.000% 11.000% # ( 170, 250 ] 20 10.000% 21.000% ## ( 250, 380 ] 26 13.000% 34.000% ### ( 380, 580 ] 25 12.500% 46.500% ### ( 580, 870 ] 20 10.000% 56.500% ## ( 870, 1300 ] 18 9.000% 65.500% ## ( 1300, 1900 ] 14 7.000% 72.500% # ( 1900, 2900 ] 25 12.500% 85.000% ### ( 2900, 4400 ] 25 12.500% 97.500% ### ( 4400, 6600 ] 5 2.500% 100.000% # ** DB Stats ** Uptime(secs): 48.0 total, 3.1 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 184.41 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.384 H:M:S, 46.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 313.66 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.432 H:M:S, 13.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 6.017 micros/op 166206 ops/sec 60.088 seconds 9986999 operations; 161.0 MB/s Microseconds per write: Count: 9986999 Average: 6.0166 StdDev: 274.64 Min: 1 Median: 1.7807 Max: 340410 Percentiles: P50: 1.78 P75: 2.85 P99: 10.64 P99.9: 1155.43 P99.99: 2628.62 ------------------------------------------------------ [ 0, 1 ] 1075372 10.768% 10.768% ## ( 1, 2 ] 5018846 50.254% 61.022% ########## ( 2, 3 ] 1643016 16.452% 77.473% ### ( 3, 4 ] 1406088 14.079% 91.552% ### ( 4, 6 ] 578307 5.791% 97.343% # ( 6, 10 ] 158037 1.582% 98.925% ( 10, 15 ] 57973 0.580% 99.506% ( 15, 22 ] 13524 0.135% 99.641% ( 22, 34 ] 2489 0.025% 99.666% ( 34, 51 ] 298 0.003% 99.669% ( 51, 76 ] 22 0.000% 99.669% ( 76, 110 ] 6831 0.068% 99.738% ( 110, 170 ] 2765 0.028% 99.765% ( 170, 250 ] 262 0.003% 99.768% ( 250, 380 ] 228 0.002% 99.770% ( 380, 580 ] 29 0.000% 99.771% ( 580, 870 ] 13 0.000% 99.771% ( 870, 1300 ] 19452 0.195% 99.965% ( 1300, 1900 ] 65 0.001% 99.966% ( 1900, 2900 ] 3271 0.033% 99.999% ( 2900, 4400 ] 72 0.001% 100.000% ( 4400, 6600 ] 13 0.000% 100.000% ( 6600, 9900 ] 4 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 50000, 75000 ] 1 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 14 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 170118 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 : 9986999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10306582968 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 : 477 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31499229 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 : 27158290628 rocksdb.compact.write.bytes COUNT : 26992590581 rocksdb.flush.write.bytes COUNT : 10304886254 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 : 49 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 : 275 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 : 10221828096 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4002816 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 : 27249091850 rocksdb.non.last.level.read.count COUNT : 6582068 rocksdb.block.checksum.compute.count COUNT : 6581163 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.460509 P95 : 4.045334 P99 : 9.066092 P100 : 340404.000000 COUNT : 9986999 SUM : 55292810 rocksdb.compaction.times.micros P50 : 1243750.000000 P95 : 5455000.000000 P99 : 17280000.000000 P100 : 19832462.000000 COUNT : 59 SUM : 113783403 rocksdb.compaction.times.cpu_micros P50 : 1007631.578947 P95 : 5455000.000000 P99 : 17280000.000000 P100 : 18318319.000000 COUNT : 59 SUM : 95296699 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 : 688.750000 P95 : 1229.527778 P99 : 2510.000000 P100 : 97440.000000 COUNT : 139 SUM : 193336 rocksdb.compaction.outfile.sync.micros P50 : 858.451327 P95 : 143000.000000 P99 : 300700.000000 P100 : 324633.000000 COUNT : 305 SUM : 6298247 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 : 92.055556 P95 : 339.050000 P99 : 2285.000000 P100 : 5587.000000 COUNT : 223 SUM : 36298 rocksdb.table.open.io.micros P50 : 1592.405063 P95 : 7995.625000 P99 : 12282.555556 P100 : 14017.000000 COUNT : 477 SUM : 1059412 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.557544 P95 : 7.181579 P99 : 11.096709 P100 : 11725.000000 COUNT : 6580172 SUM : 36711995 rocksdb.read.block.get.micros P50 : 495.909091 P95 : 3543.269231 P99 : 5494.823529 P100 : 6716.000000 COUNT : 954 SUM : 854503 rocksdb.write.raw.block.micros P50 : 0.511790 P95 : 0.972401 P99 : 2.835520 P100 : 11003.000000 COUNT : 9034124 SUM : 17007571 rocksdb.numfiles.in.singlecompaction P50 : 3.518293 P95 : 8.200000 P99 : 32.920000 P100 : 37.000000 COUNT : 109 SUM : 495 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.559917 P95 : 1137.567572 P99 : 2270.168557 P100 : 340226.000000 COUNT : 214914 SUM : 31523316 rocksdb.sst.read.micros P50 : 1.502591 P95 : 4.123636 P99 : 8.174209 P100 : 8572.000000 COUNT : 6582803 SUM : 23275491 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 : 9986999 SUM : 10306582968 rocksdb.bytes.per.multiget P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.bytes.compressed P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.bytes.decompressed P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.compression.times.nanos P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.decompression.times.nanos P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.read.num.merge_operands P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.key.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.value.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.write.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.get.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.multiget.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.seek.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.next.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.prev.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.blob.file.write.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.blob.file.read.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.blob.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.compression.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.decompression.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.db.flush.micros P50 : 211923.076923 P95 : 349794.117647 P99 : 746900.000000 P100 : 917577.000000 COUNT : 139 SUM : 29340588 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 : 294 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