[2024-11-19 04:31:12.815120] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 22.11.4 initialization... [2024-11-19 04:31:12.815275] [ 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_pid693315 ] Set seed to 1731987072811487 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-19 04:31:12.906522] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-19 04:31:12.946364] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-19 04:31:12.946415] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 693315' to capture a snapshot of events at runtime. [2024-11-19 04:31:12.946427] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid693315 for offline analysis/debug. [2024-11-19 04:31:12.946451] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Tue Nov 19 04:31:17 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/19-04:31:19 ... thread 0: (1000000,1000000) ops and (353153.6,353153.6) ops/second in (2.831629,2.831629) 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/9 630.03 MB 6.3 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 348.9 2.35 2.12 12 0.196 0 0 0.0 0.0 L2 3/2 237.43 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.0 1.8 253.0 252.9 1.38 1.33 2 0.690 354K 190 0.0 0.0 L3 11/0 944.88 MB 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 L4 116/0 9.60 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.57 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 1180/11 96.94 GB 0.0 0.3 0.2 0.2 1.1 1.0 0.0 1.4 93.7 313.4 3.73 3.44 14 0.266 354K 190 0.0 0.0 Int 0/0 0.00 KB 0.0 0.3 0.2 0.2 1.1 1.0 0.0 1.4 93.7 313.4 3.73 3.44 14 0.266 354K 190 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.3 0.2 0.2 0.3 0.2 0.0 0.0 253.0 252.9 1.38 1.33 2 0.690 354K 190 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 348.9 2.35 2.12 12 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): 3.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.14 GB write, 387.17 MB/s write, 0.34 GB read, 115.76 MB/s read, 3.7 seconds Interval compaction: 1.14 GB write, 412.31 MB/s write, 0.34 GB read, 123.28 MB/s read, 3.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: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 123818 Average: 2.0117 StdDev: 21.05 Min: 1 Median: 1.2910 Max: 4826 Percentiles: P50: 1.29 P75: 1.73 P99: 5.31 P99.9: 9.97 P99.99: 122.14 ------------------------------------------------------ [ 0, 1 ] 41304 33.359% 33.359% ####### ( 1, 2 ] 70804 57.184% 90.543% ########### ( 2, 3 ] 6237 5.037% 95.580% # ( 3, 4 ] 2920 2.358% 97.938% ( 4, 6 ] 2016 1.628% 99.566% ( 6, 10 ] 417 0.337% 99.903% ( 10, 15 ] 91 0.073% 99.977% ( 15, 22 ] 10 0.008% 99.985% ( 22, 34 ] 4 0.003% 99.988% ( 34, 51 ] 2 0.002% 99.990% ( 110, 170 ] 8 0.006% 99.996% ( 170, 250 ] 2 0.002% 99.998% ( 250, 380 ] 7 0.006% 100.003% ( 580, 870 ] 1 0.001% 100.004% ( 870, 1300 ] 2 0.002% 100.006% ( 1900, 2900 ] 2 0.002% 100.007% ( 2900, 4400 ] 1 0.001% 100.008% ( 4400, 6600 ] 1 0.001% 100.009% ** Level 2 read latency histogram (micros): Count: 71130 Average: 2.2390 StdDev: 23.75 Min: 1 Median: 1.3007 Max: 4568 Percentiles: P50: 1.30 P75: 1.74 P99: 5.88 P99.9: 49.63 P99.99: 708.60 ------------------------------------------------------ [ 0, 1 ] 23406 32.906% 32.906% ####### ( 1, 2 ] 40441 56.855% 89.761% ########### ( 2, 3 ] 3666 5.154% 94.915% # ( 3, 4 ] 1717 2.414% 97.329% ( 4, 6 ] 1265 1.778% 99.107% ( 6, 10 ] 455 0.640% 99.747% ( 10, 15 ] 80 0.112% 99.859% ( 15, 22 ] 11 0.015% 99.875% ( 22, 34 ] 6 0.008% 99.883% ( 34, 51 ] 14 0.020% 99.903% ( 51, 76 ] 23 0.032% 99.935% ( 76, 110 ] 5 0.007% 99.942% ( 110, 170 ] 4 0.006% 99.948% ( 170, 250 ] 16 0.022% 99.970% ( 250, 380 ] 9 0.013% 99.983% ( 380, 580 ] 5 0.007% 99.990% ( 580, 870 ] 2 0.003% 99.993% ( 870, 1300 ] 2 0.003% 99.996% ( 1300, 1900 ] 2 0.003% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ( 4400, 6600 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 55 Average: 1912.1818 StdDev: 1793.63 Min: 157 Median: 836.5385 Max: 5787 Percentiles: P50: 836.54 P75: 3509.38 P99: 5787.00 P99.9: 5787.00 P99.99: 5787.00 ------------------------------------------------------ ( 110, 170 ] 1 1.818% 1.818% ( 170, 250 ] 1 1.818% 3.636% ( 250, 380 ] 4 7.273% 10.909% # ( 380, 580 ] 10 18.182% 29.091% #### ( 580, 870 ] 13 23.636% 52.727% ##### ( 870, 1300 ] 4 7.273% 60.000% # ( 1300, 1900 ] 1 1.818% 61.818% ( 1900, 2900 ] 4 7.273% 69.091% # ( 2900, 4400 ] 8 14.545% 83.636% ### ( 4400, 6600 ] 9 16.364% 100.000% ### ** Level 4 read latency histogram (micros): Count: 20 Average: 1976.9500 StdDev: 2145.31 Min: 297 Median: 1085.0000 Max: 7379 Percentiles: P50: 1085.00 P75: 1900.00 P99: 7379.00 P99.9: 7379.00 P99.99: 7379.00 ------------------------------------------------------ ( 250, 380 ] 1 5.000% 5.000% # ( 380, 580 ] 7 35.000% 40.000% ####### ( 580, 870 ] 1 5.000% 45.000% # ( 870, 1300 ] 2 10.000% 55.000% ## ( 1300, 1900 ] 4 20.000% 75.000% #### ( 1900, 2900 ] 1 5.000% 80.000% # ( 4400, 6600 ] 3 15.000% 95.000% ### ( 6600, 9900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 326.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:0.204 H:M:S, 6.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 347.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.204 H:M:S, 7.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/19-04:31:23 ... thread 0: (1000000,2000000) ops and (317288.2,334261.6) ops/second in (3.151709,5.983338) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/4 1.29 GB 107.0 0.8 0.0 0.8 2.6 1.8 0.0 1.4 97.2 313.9 8.43 7.81 29 0.291 831K 899 0.0 0.0 L1 1/0 3.29 MB 0.3 0.3 0.3 0.0 0.3 0.3 0.2 1.0 240.4 240.0 1.31 1.27 1 1.311 319K 454 0.0 0.0 L2 2/1 146.81 MB 1.0 0.3 0.2 0.2 0.3 0.2 0.3 1.8 253.0 252.9 1.38 1.33 2 0.690 354K 190 0.0 0.0 L3 20/11 1.15 GB 0.2 0.2 0.2 0.0 0.2 0.2 0.2 1.0 222.0 222.0 0.84 0.77 1 0.843 189K 0 0.0 0.0 L4 174/0 9.76 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 133.0 133.1 1.26 0.88 1 1.264 170K 0 0.0 0.0 L5 1040/0 85.57 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 1247/16 97.92 GB 0.0 1.8 0.8 1.0 3.6 2.6 0.7 2.0 139.0 277.1 13.22 12.05 34 0.389 1866K 1543 0.0 0.0 Int 0/0 0.00 KB 0.0 1.8 0.8 1.0 3.6 2.6 0.7 2.0 139.0 277.1 13.22 12.05 34 0.389 1866K 1543 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.8 0.8 1.0 1.8 0.8 0.0 0.0 231.1 230.9 7.95 7.34 8 0.994 1866K 1543 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 346.7 5.27 4.71 26 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): 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.58 GB write, 593.93 MB/s write, 1.80 GB read, 298.02 MB/s read, 13.2 seconds Interval compaction: 3.58 GB write, 612.19 MB/s write, 1.80 GB read, 307.18 MB/s read, 13.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: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 9, interval: 9 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 395041 Average: 2.1518 StdDev: 13.20 Min: 1 Median: 1.4452 Max: 4826 Percentiles: P50: 1.45 P75: 1.84 P99: 5.64 P99.9: 10.48 P99.99: 16.42 ------------------------------------------------------ [ 0, 1 ] 86869 21.990% 21.990% #### ( 1, 2 ] 248559 62.920% 84.910% ############# ( 2, 3 ] 32200 8.151% 93.061% ## ( 3, 4 ] 15323 3.879% 96.940% # ( 4, 6 ] 9899 2.506% 99.445% # ( 6, 10 ] 1759 0.445% 99.891% ( 10, 15 ] 384 0.097% 99.988% ( 15, 22 ] 42 0.011% 99.998% ( 22, 34 ] 6 0.002% 100.000% ( 34, 51 ] 2 0.001% 100.001% ( 51, 76 ] 1 0.000% 100.001% ( 110, 170 ] 12 0.003% 100.004% ( 170, 250 ] 9 0.002% 100.006% ( 250, 380 ] 16 0.004% 100.010% ( 380, 580 ] 3 0.001% 100.011% ( 580, 870 ] 5 0.001% 100.012% ( 870, 1300 ] 5 0.001% 100.013% ( 1300, 1900 ] 4 0.001% 100.014% ( 1900, 2900 ] 2 0.001% 100.015% ( 2900, 4400 ] 1 0.000% 100.015% ( 4400, 6600 ] 1 0.000% 100.015% ** Level 1 read latency histogram (micros): Count: 20 Average: 155.5000 StdDev: 303.69 Min: 1 Median: 1.6667 Max: 1281 Percentiles: P50: 1.67 P75: 250.00 P99: 1214.00 P99.9: 1281.00 P99.99: 1281.00 ------------------------------------------------------ [ 0, 1 ] 6 30.000% 30.000% ###### ( 1, 2 ] 6 30.000% 60.000% ###### ( 2, 3 ] 1 5.000% 65.000% # ( 4, 6 ] 1 5.000% 70.000% # ( 170, 250 ] 1 5.000% 75.000% # ( 250, 380 ] 2 10.000% 85.000% ## ( 380, 580 ] 2 10.000% 95.000% ## ( 870, 1300 ] 1 5.000% 100.000% # ** Level 2 read latency histogram (micros): Count: 88519 Average: 2.2528 StdDev: 21.30 Min: 1 Median: 1.3600 Max: 4568 Percentiles: P50: 1.36 P75: 1.79 P99: 5.90 P99.9: 27.97 P99.99: 545.92 ------------------------------------------------------ [ 0, 1 ] 25733 29.071% 29.071% ###### ( 1, 2 ] 51462 58.137% 87.207% ############ ( 2, 3 ] 5785 6.535% 93.743% # ( 3, 4 ] 2690 3.039% 96.781% # ( 4, 6 ] 2065 2.333% 99.114% ( 6, 10 ] 580 0.655% 99.770% ( 10, 15 ] 93 0.105% 99.875% ( 15, 22 ] 19 0.021% 99.896% ( 22, 34 ] 7 0.008% 99.904% ( 34, 51 ] 15 0.017% 99.921% ( 51, 76 ] 23 0.026% 99.947% ( 76, 110 ] 5 0.006% 99.953% ( 110, 170 ] 4 0.005% 99.957% ( 170, 250 ] 16 0.018% 99.975% ( 250, 380 ] 9 0.010% 99.985% ( 380, 580 ] 5 0.006% 99.991% ( 580, 870 ] 2 0.002% 99.993% ( 870, 1300 ] 2 0.002% 99.995% ( 1300, 1900 ] 2 0.002% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 209348 Average: 3.4067 StdDev: 45.40 Min: 1 Median: 1.5837 Max: 5787 Percentiles: P50: 1.58 P75: 1.99 P99: 9.00 P99.9: 162.04 P99.99: 546.94 ------------------------------------------------------ [ 0, 1 ] 29787 14.228% 14.228% ### ( 1, 2 ] 128300 61.286% 75.514% ############ ( 2, 3 ] 28562 13.643% 89.157% ### ( 3, 4 ] 9705 4.636% 93.793% # ( 4, 6 ] 8303 3.966% 97.759% # ( 6, 10 ] 3462 1.654% 99.413% ( 10, 15 ] 550 0.263% 99.676% ( 15, 22 ] 79 0.038% 99.713% ( 22, 34 ] 29 0.014% 99.727% ( 34, 51 ] 7 0.003% 99.731% ( 51, 76 ] 49 0.023% 99.754% ( 76, 110 ] 153 0.073% 99.827% ( 110, 170 ] 176 0.084% 99.911% ( 170, 250 ] 76 0.036% 99.947% ( 250, 380 ] 49 0.023% 99.971% ( 380, 580 ] 48 0.023% 99.994% ( 580, 870 ] 35 0.017% 100.011% ( 870, 1300 ] 8 0.004% 100.014% ( 1300, 1900 ] 5 0.002% 100.017% ( 1900, 2900 ] 4 0.002% 100.019% ( 2900, 4400 ] 9 0.004% 100.023% ( 4400, 6600 ] 9 0.004% 100.027% ** Level 4 read latency histogram (micros): Count: 310 Average: 133.0645 StdDev: 729.11 Min: 1 Median: 2.9744 Max: 7379 Percentiles: P50: 2.97 P75: 6.96 P99: 5060.00 P99.9: 7379.00 P99.99: 7379.00 ------------------------------------------------------ [ 0, 1 ] 12 3.871% 3.871% # ( 1, 2 ] 67 21.613% 25.484% #### ( 2, 3 ] 78 25.161% 50.645% ##### ( 3, 4 ] 49 15.806% 66.452% ### ( 4, 6 ] 21 6.774% 73.226% # ( 6, 10 ] 23 7.419% 80.645% # ( 10, 15 ] 26 8.387% 89.032% ## ( 15, 22 ] 12 3.871% 92.903% # ( 34, 51 ] 1 0.323% 93.226% ( 170, 250 ] 1 0.323% 93.548% ( 250, 380 ] 1 0.323% 93.871% ( 380, 580 ] 7 2.258% 96.129% ( 580, 870 ] 1 0.323% 96.452% ( 870, 1300 ] 2 0.645% 97.097% ( 1300, 1900 ] 4 1.290% 98.387% ( 1900, 2900 ] 1 0.323% 98.710% ( 4400, 6600 ] 3 0.968% 99.677% ( 6600, 9900 ] 1 0.323% 100.000% ** DB Stats ** Uptime(secs): 6.2 total, 3.2 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 319.09 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.619 H:M:S, 10.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 312.27 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.415 H:M:S, 13.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-04:31:26 ... thread 0: (1000000,3000000) ops and (338382.3,335624.0) ops/second in (2.955237,8.938575) 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/11 2.21 GB 69.2 1.6 0.0 1.6 4.3 2.7 0.0 1.6 114.3 307.6 14.33 13.32 46 0.312 1663K 1762 0.0 0.0 L1 1/1 3.29 MB 0.0 0.3 0.3 0.0 0.3 0.3 0.2 1.0 240.4 240.0 1.31 1.27 1 1.311 319K 454 0.0 0.0 L2 1/0 96.40 MB 1.0 0.3 0.2 0.2 0.3 0.2 0.3 1.8 253.0 252.9 1.38 1.33 2 0.690 354K 190 0.0 0.0 L3 21/0 969.75 MB 1.0 1.2 0.2 0.9 1.2 0.2 0.2 5.0 239.0 238.6 4.95 4.57 2 2.474 1200K 1795 0.0 0.0 L4 174/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 133.0 133.1 1.26 0.88 1 1.264 170K 0 0.0 0.0 L5 1044/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1256/12 98.84 GB 0.0 3.6 0.9 2.7 6.3 3.6 1.3 2.3 157.2 276.4 23.23 21.36 52 0.447 3709K 4201 0.0 0.0 Int 0/0 0.00 KB 0.0 3.6 0.9 2.7 6.3 3.6 1.3 2.3 157.2 276.4 23.23 21.36 52 0.447 3709K 4201 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.6 0.9 2.7 3.6 0.9 0.0 0.0 239.0 238.7 15.28 14.27 12 1.274 3709K 4201 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 348.8 7.95 7.08 40 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): 9.1 total, 8.9 interval Flush(GB): cumulative 2.707, interval 2.707 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: 6.27 GB write, 703.68 MB/s write, 3.57 GB read, 400.34 MB/s read, 23.2 seconds Interval compaction: 6.27 GB write, 718.16 MB/s write, 3.57 GB read, 408.58 MB/s read, 23.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: 12, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 12, interval: 12 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 750119 Average: 2.1933 StdDev: 11.72 Min: 1 Median: 1.4785 Max: 4826 Percentiles: P50: 1.48 P75: 1.86 P99: 5.66 P99.9: 9.82 P99.99: 14.20 ------------------------------------------------------ [ 0, 1 ] 142252 18.964% 18.964% #### ( 1, 2 ] 486528 64.860% 83.824% ############# ( 2, 3 ] 66386 8.850% 92.674% ## ( 3, 4 ] 30668 4.088% 96.763% # ( 4, 6 ] 20175 2.690% 99.452% # ( 6, 10 ] 3516 0.469% 99.921% ( 10, 15 ] 619 0.083% 100.003% ( 15, 22 ] 58 0.008% 100.011% ( 22, 34 ] 9 0.001% 100.012% ( 34, 51 ] 7 0.001% 100.013% ( 51, 76 ] 4 0.001% 100.014% ( 76, 110 ] 6 0.001% 100.015% ( 110, 170 ] 18 0.002% 100.017% ( 170, 250 ] 23 0.003% 100.020% ( 250, 380 ] 23 0.003% 100.023% ( 380, 580 ] 5 0.001% 100.024% ( 580, 870 ] 15 0.002% 100.026% ( 870, 1300 ] 10 0.001% 100.027% ( 1300, 1900 ] 7 0.001% 100.028% ( 1900, 2900 ] 4 0.001% 100.029% ( 2900, 4400 ] 1 0.000% 100.029% ( 4400, 6600 ] 1 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 21 Average: 148.2857 StdDev: 298.13 Min: 1 Median: 1.7500 Max: 1281 Percentiles: P50: 1.75 P75: 230.00 P99: 1209.70 P99.9: 1281.00 P99.99: 1281.00 ------------------------------------------------------ [ 0, 1 ] 6 28.571% 28.571% ###### ( 1, 2 ] 6 28.571% 57.143% ###### ( 2, 3 ] 1 4.762% 61.905% # ( 3, 4 ] 1 4.762% 66.667% # ( 4, 6 ] 1 4.762% 71.429% # ( 170, 250 ] 1 4.762% 76.190% # ( 250, 380 ] 2 9.524% 85.714% ## ( 380, 580 ] 2 9.524% 95.238% ## ( 870, 1300 ] 1 4.762% 100.000% # ** Level 2 read latency histogram (micros): Count: 101000 Average: 2.3150 StdDev: 20.69 Min: 1 Median: 1.3835 Max: 4568 Percentiles: P50: 1.38 P75: 1.81 P99: 5.92 P99.9: 49.87 P99.99: 576.67 ------------------------------------------------------ [ 0, 1 ] 27628 27.354% 27.354% ##### ( 1, 2 ] 59634 59.044% 86.398% ############ ( 2, 3 ] 6956 6.887% 93.285% # ( 3, 4 ] 3324 3.291% 96.576% # ( 4, 6 ] 2548 2.523% 99.099% # ( 6, 10 ] 668 0.661% 99.760% ( 10, 15 ] 101 0.100% 99.860% ( 15, 22 ] 19 0.019% 99.879% ( 22, 34 ] 7 0.007% 99.886% ( 34, 51 ] 15 0.015% 99.901% ( 51, 76 ] 23 0.023% 99.924% ( 76, 110 ] 12 0.012% 99.936% ( 110, 170 ] 14 0.014% 99.950% ( 170, 250 ] 23 0.023% 99.972% ( 250, 380 ] 12 0.012% 99.984% ( 380, 580 ] 6 0.006% 99.990% ( 580, 870 ] 3 0.003% 99.993% ( 870, 1300 ] 3 0.003% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 282667 Average: 3.2509 StdDev: 39.85 Min: 1 Median: 1.5477 Max: 5787 Percentiles: P50: 1.55 P75: 1.95 P99: 8.91 P99.9: 168.64 P99.99: 570.39 ------------------------------------------------------ [ 0, 1 ] 45337 16.039% 16.039% ### ( 1, 2 ] 175261 62.003% 78.042% ############ ( 2, 3 ] 33814 11.962% 90.004% ## ( 3, 4 ] 12305 4.353% 94.357% # ( 4, 6 ] 9746 3.448% 97.805% # ( 6, 10 ] 4649 1.645% 99.450% ( 10, 15 ] 620 0.219% 99.669% ( 15, 22 ] 82 0.029% 99.698% ( 22, 34 ] 31 0.011% 99.709% ( 34, 51 ] 8 0.003% 99.712% ( 51, 76 ] 50 0.018% 99.730% ( 76, 110 ] 193 0.068% 99.798% ( 110, 170 ] 295 0.104% 99.902% ( 170, 250 ] 115 0.041% 99.943% ( 250, 380 ] 68 0.024% 99.967% ( 380, 580 ] 68 0.024% 99.991% ( 580, 870 ] 45 0.016% 100.007% ( 870, 1300 ] 10 0.004% 100.011% ( 1300, 1900 ] 5 0.002% 100.012% ( 1900, 2900 ] 4 0.001% 100.014% ( 2900, 4400 ] 9 0.003% 100.017% ( 4400, 6600 ] 9 0.003% 100.020% ** Level 4 read latency histogram (micros): Count: 310 Average: 133.0645 StdDev: 729.11 Min: 1 Median: 2.9744 Max: 7379 Percentiles: P50: 2.97 P75: 6.96 P99: 5060.00 P99.9: 7379.00 P99.99: 7379.00 ------------------------------------------------------ [ 0, 1 ] 12 3.871% 3.871% # ( 1, 2 ] 67 21.613% 25.484% #### ( 2, 3 ] 78 25.161% 50.645% ##### ( 3, 4 ] 49 15.806% 66.452% ### ( 4, 6 ] 21 6.774% 73.226% # ( 6, 10 ] 23 7.419% 80.645% # ( 10, 15 ] 26 8.387% 89.032% ## ( 15, 22 ] 12 3.871% 92.903% # ( 34, 51 ] 1 0.323% 93.226% ( 170, 250 ] 1 0.323% 93.548% ( 250, 380 ] 1 0.323% 93.871% ( 380, 580 ] 7 2.258% 96.129% ( 580, 870 ] 1 0.323% 96.452% ( 870, 1300 ] 2 0.645% 97.097% ( 1300, 1900 ] 4 1.290% 98.387% ( 1900, 2900 ] 1 0.323% 98.710% ( 4400, 6600 ] 3 0.968% 99.677% ( 6600, 9900 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 912.7500 StdDev: 822.18 Min: 112 Median: 530.0000 Max: 2475 Percentiles: P50: 530.00 P75: 1300.00 P99: 2475.00 P99.9: 2475.00 P99.99: 2475.00 ------------------------------------------------------ ( 110, 170 ] 3 15.000% 15.000% ### ( 170, 250 ] 2 10.000% 25.000% ## ( 250, 380 ] 2 10.000% 35.000% ## ( 380, 580 ] 4 20.000% 55.000% #### ( 580, 870 ] 2 10.000% 65.000% ## ( 870, 1300 ] 2 10.000% 75.000% ## ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 4 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 9.1 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 323.60 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.870 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, 333.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.251 H:M:S, 8.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-04:31:29 ... thread 0: (1000000,4000000) ops and (315875.6,330458.9) ops/second in (3.165803,12.104378) 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/9 1.91 GB 6.3 2.6 0.0 2.6 6.3 3.7 0.0 1.7 127.4 305.1 21.26 19.87 64 0.332 2750K 2839 0.0 0.0 L1 11/11 1.29 GB 0.0 1.6 1.6 0.0 1.6 1.6 0.2 1.0 231.8 230.6 7.08 6.84 2 3.538 1665K 7893 0.0 0.0 L2 1/0 96.40 MB 1.0 0.3 0.2 0.2 0.3 0.2 0.3 1.8 253.0 252.9 1.38 1.33 2 0.690 354K 190 0.0 0.0 L3 21/0 969.75 MB 1.0 1.2 0.2 0.9 1.2 0.2 0.2 5.0 239.0 238.6 4.95 4.57 2 2.474 1200K 1795 0.0 0.0 L4 174/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 133.0 133.1 1.26 0.88 1 1.264 170K 0 0.0 0.0 L5 1044/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1261/20 99.82 GB 0.0 5.9 2.2 3.7 9.6 5.9 1.3 2.6 168.4 273.2 35.93 33.49 71 0.506 6142K 12K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.9 2.2 3.7 9.6 5.9 1.3 2.6 168.4 273.2 35.93 33.49 71 0.506 6142K 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.9 2.2 3.7 5.9 2.2 0.0 0.0 240.7 240.2 25.13 23.86 17 1.478 6142K 12K 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 350.2 10.79 9.63 54 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): 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.59 GB write, 798.68 MB/s write, 5.91 GB read, 492.18 MB/s read, 35.9 seconds Interval compaction: 9.59 GB write, 810.81 MB/s write, 5.91 GB read, 499.65 MB/s read, 35.9 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: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 2, total-stops: 14, interval: 16 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1156511 Average: 2.2437 StdDev: 12.16 Min: 0 Median: 1.4804 Max: 4826 Percentiles: P50: 1.48 P75: 1.86 P99: 5.73 P99.9: 10.16 P99.99: 19.41 ------------------------------------------------------ [ 0, 1 ] 213283 18.442% 18.442% #### ( 1, 2 ] 759754 65.694% 84.136% ############# ( 2, 3 ] 101008 8.734% 92.869% ## ( 3, 4 ] 45378 3.924% 96.793% # ( 4, 6 ] 29431 2.545% 99.338% # ( 6, 10 ] 6467 0.559% 99.897% ( 10, 15 ] 1017 0.088% 99.985% ( 15, 22 ] 91 0.008% 99.993% ( 22, 34 ] 16 0.001% 99.994% ( 34, 51 ] 9 0.001% 99.995% ( 51, 76 ] 7 0.001% 99.996% ( 76, 110 ] 53 0.005% 100.000% ( 110, 170 ] 123 0.011% 100.011% ( 170, 250 ] 75 0.006% 100.017% ( 250, 380 ] 57 0.005% 100.022% ( 380, 580 ] 38 0.003% 100.026% ( 580, 870 ] 39 0.003% 100.029% ( 870, 1300 ] 17 0.001% 100.030% ( 1300, 1900 ] 8 0.001% 100.031% ( 1900, 2900 ] 7 0.001% 100.032% ( 2900, 4400 ] 2 0.000% 100.032% ( 4400, 6600 ] 1 0.000% 100.032% ** Level 1 read latency histogram (micros): Count: 5256 Average: 7.8645 StdDev: 64.66 Min: 0 Median: 1.3595 Max: 1695 Percentiles: P50: 1.36 P75: 1.81 P99: 154.84 P99.9: 1138.32 P99.99: 1695.00 ------------------------------------------------------ [ 0, 1 ] 1569 29.852% 29.852% ###### ( 1, 2 ] 2947 56.069% 85.921% ########### ( 2, 3 ] 373 7.097% 93.018% # ( 3, 4 ] 185 3.520% 96.537% # ( 4, 6 ] 42 0.799% 97.336% ( 6, 10 ] 47 0.894% 98.231% ( 10, 15 ] 2 0.038% 98.269% ( 15, 22 ] 1 0.019% 98.288% ( 76, 110 ] 22 0.419% 98.706% ( 110, 170 ] 22 0.419% 99.125% ( 170, 250 ] 12 0.228% 99.353% ( 250, 380 ] 8 0.152% 99.505% ( 380, 580 ] 14 0.266% 99.772% ( 580, 870 ] 4 0.076% 99.848% ( 870, 1300 ] 6 0.114% 99.962% ( 1300, 1900 ] 3 0.057% 100.019% ** Level 2 read latency histogram (micros): Count: 101000 Average: 2.3150 StdDev: 20.69 Min: 1 Median: 1.3835 Max: 4568 Percentiles: P50: 1.38 P75: 1.81 P99: 5.92 P99.9: 49.87 P99.99: 576.67 ------------------------------------------------------ [ 0, 1 ] 27628 27.354% 27.354% ##### ( 1, 2 ] 59634 59.044% 86.398% ############ ( 2, 3 ] 6956 6.887% 93.285% # ( 3, 4 ] 3324 3.291% 96.576% # ( 4, 6 ] 2548 2.523% 99.099% # ( 6, 10 ] 668 0.661% 99.760% ( 10, 15 ] 101 0.100% 99.860% ( 15, 22 ] 19 0.019% 99.879% ( 22, 34 ] 7 0.007% 99.886% ( 34, 51 ] 15 0.015% 99.901% ( 51, 76 ] 23 0.023% 99.924% ( 76, 110 ] 12 0.012% 99.936% ( 110, 170 ] 14 0.014% 99.950% ( 170, 250 ] 23 0.023% 99.972% ( 250, 380 ] 12 0.012% 99.984% ( 380, 580 ] 6 0.006% 99.990% ( 580, 870 ] 3 0.003% 99.993% ( 870, 1300 ] 3 0.003% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 282667 Average: 3.2509 StdDev: 39.85 Min: 1 Median: 1.5477 Max: 5787 Percentiles: P50: 1.55 P75: 1.95 P99: 8.91 P99.9: 168.64 P99.99: 570.39 ------------------------------------------------------ [ 0, 1 ] 45337 16.039% 16.039% ### ( 1, 2 ] 175261 62.003% 78.042% ############ ( 2, 3 ] 33814 11.962% 90.004% ## ( 3, 4 ] 12305 4.353% 94.357% # ( 4, 6 ] 9746 3.448% 97.805% # ( 6, 10 ] 4649 1.645% 99.450% ( 10, 15 ] 620 0.219% 99.669% ( 15, 22 ] 82 0.029% 99.698% ( 22, 34 ] 31 0.011% 99.709% ( 34, 51 ] 8 0.003% 99.712% ( 51, 76 ] 50 0.018% 99.730% ( 76, 110 ] 193 0.068% 99.798% ( 110, 170 ] 295 0.104% 99.902% ( 170, 250 ] 115 0.041% 99.943% ( 250, 380 ] 68 0.024% 99.967% ( 380, 580 ] 68 0.024% 99.991% ( 580, 870 ] 45 0.016% 100.007% ( 870, 1300 ] 10 0.004% 100.011% ( 1300, 1900 ] 5 0.002% 100.012% ( 1900, 2900 ] 4 0.001% 100.014% ( 2900, 4400 ] 9 0.003% 100.017% ( 4400, 6600 ] 9 0.003% 100.020% ** Level 4 read latency histogram (micros): Count: 310 Average: 133.0645 StdDev: 729.11 Min: 1 Median: 2.9744 Max: 7379 Percentiles: P50: 2.97 P75: 6.96 P99: 5060.00 P99.9: 7379.00 P99.99: 7379.00 ------------------------------------------------------ [ 0, 1 ] 12 3.871% 3.871% # ( 1, 2 ] 67 21.613% 25.484% #### ( 2, 3 ] 78 25.161% 50.645% ##### ( 3, 4 ] 49 15.806% 66.452% ### ( 4, 6 ] 21 6.774% 73.226% # ( 6, 10 ] 23 7.419% 80.645% # ( 10, 15 ] 26 8.387% 89.032% ## ( 15, 22 ] 12 3.871% 92.903% # ( 34, 51 ] 1 0.323% 93.226% ( 170, 250 ] 1 0.323% 93.548% ( 250, 380 ] 1 0.323% 93.871% ( 380, 580 ] 7 2.258% 96.129% ( 580, 870 ] 1 0.323% 96.452% ( 870, 1300 ] 2 0.645% 97.097% ( 1300, 1900 ] 4 1.290% 98.387% ( 1900, 2900 ] 1 0.323% 98.710% ( 4400, 6600 ] 3 0.968% 99.677% ( 6600, 9900 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 912.7500 StdDev: 822.18 Min: 112 Median: 530.0000 Max: 2475 Percentiles: P50: 530.00 P75: 1300.00 P99: 2475.00 P99.9: 2475.00 P99.99: 2475.00 ------------------------------------------------------ ( 110, 170 ] 3 15.000% 15.000% ### ( 170, 250 ] 2 10.000% 25.000% ## ( 250, 380 ] 2 10.000% 35.000% ## ( 380, 580 ] 4 20.000% 55.000% #### ( 580, 870 ] 2 10.000% 65.000% ## ( 870, 1300 ] 2 10.000% 75.000% ## ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 4 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 12.3 total, 3.2 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 320.32 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.317 H:M:S, 10.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 310.88 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.447 H:M:S, 14.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/19-04:31:32 ... thread 0: (1000000,5000000) ops and (323807.1,329106.8) ops/second in (3.088258,15.192636) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/13 2.89 GB 81.8 3.2 0.0 3.2 7.9 4.7 0.0 1.7 124.6 306.6 26.29 24.57 80 0.329 3326K 3483 0.0 0.0 L1 11/11 1.29 GB 0.0 1.6 1.6 0.0 1.6 1.6 0.2 1.0 231.8 230.6 7.08 6.84 2 3.538 1665K 7893 0.0 0.0 L2 1/0 96.40 MB 1.0 0.3 0.2 0.2 0.3 0.2 0.3 1.8 253.0 252.9 1.38 1.33 2 0.690 354K 190 0.0 0.0 L3 21/0 969.75 MB 1.0 1.2 0.2 0.9 1.2 0.2 0.2 5.0 239.0 238.6 4.95 4.57 2 2.474 1200K 1795 0.0 0.0 L4 174/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 133.0 133.1 1.26 0.88 1 1.264 170K 0 0.0 0.0 L5 1044/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1269/24 100.80 GB 0.0 6.5 2.2 4.3 11.1 6.8 1.3 2.4 161.5 278.1 40.96 38.18 87 0.471 6717K 13K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.5 2.2 4.3 11.1 6.8 1.3 2.4 161.5 278.1 40.96 38.18 87 0.471 6717K 13K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.5 2.2 4.3 6.4 2.2 0.0 0.0 242.8 242.3 27.25 25.93 19 1.434 6717K 13K 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 349.2 13.71 12.24 68 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): 15.4 total, 15.2 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.12 GB write, 740.65 MB/s write, 6.46 GB read, 430.20 MB/s read, 41.0 seconds Interval compaction: 11.12 GB write, 749.62 MB/s write, 6.46 GB read, 435.41 MB/s read, 41.0 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: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 2, total-stops: 17, interval: 19 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1467175 Average: 2.2314 StdDev: 12.07 Min: 0 Median: 1.4782 Max: 4826 Percentiles: P50: 1.48 P75: 1.86 P99: 5.71 P99.9: 10.15 P99.99: 18.61 ------------------------------------------------------ [ 0, 1 ] 269970 18.401% 18.401% #### ( 1, 2 ] 969594 66.086% 84.486% ############# ( 2, 3 ] 125964 8.585% 93.072% ## ( 3, 4 ] 56240 3.833% 96.905% # ( 4, 6 ] 35984 2.453% 99.358% ( 6, 10 ] 7919 0.540% 99.897% ( 10, 15 ] 1300 0.089% 99.986% ( 15, 22 ] 115 0.008% 99.994% ( 22, 34 ] 18 0.001% 99.995% ( 34, 51 ] 10 0.001% 99.996% ( 51, 76 ] 8 0.001% 99.996% ( 76, 110 ] 53 0.004% 100.000% ( 110, 170 ] 144 0.010% 100.010% ( 170, 250 ] 90 0.006% 100.016% ( 250, 380 ] 68 0.005% 100.021% ( 380, 580 ] 48 0.003% 100.024% ( 580, 870 ] 46 0.003% 100.027% ( 870, 1300 ] 20 0.001% 100.028% ( 1300, 1900 ] 11 0.001% 100.029% ( 1900, 2900 ] 9 0.001% 100.030% ( 2900, 4400 ] 3 0.000% 100.030% ( 4400, 6600 ] 1 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 78676 Average: 2.8650 StdDev: 19.45 Min: 0 Median: 1.4731 Max: 1695 Percentiles: P50: 1.47 P75: 1.85 P99: 8.42 P99.9: 210.72 P99.99: 1000.99 ------------------------------------------------------ [ 0, 1 ] 14438 18.351% 18.351% #### ( 1, 2 ] 52629 66.893% 85.245% ############# ( 2, 3 ] 6139 7.803% 93.047% ## ( 3, 4 ] 2523 3.207% 96.254% # ( 4, 6 ] 1485 1.887% 98.142% ( 6, 10 ] 1114 1.416% 99.558% ( 10, 15 ] 99 0.126% 99.684% ( 15, 22 ] 7 0.009% 99.692% ( 76, 110 ] 61 0.078% 99.770% ( 110, 170 ] 84 0.107% 99.877% ( 170, 250 ] 36 0.046% 99.922% ( 250, 380 ] 20 0.025% 99.948% ( 380, 580 ] 24 0.031% 99.978% ( 580, 870 ] 7 0.009% 99.987% ( 870, 1300 ] 7 0.009% 99.996% ( 1300, 1900 ] 3 0.004% 100.000% ** Level 2 read latency histogram (micros): Count: 101000 Average: 2.3150 StdDev: 20.69 Min: 1 Median: 1.3835 Max: 4568 Percentiles: P50: 1.38 P75: 1.81 P99: 5.92 P99.9: 49.87 P99.99: 576.67 ------------------------------------------------------ [ 0, 1 ] 27628 27.354% 27.354% ##### ( 1, 2 ] 59634 59.044% 86.398% ############ ( 2, 3 ] 6956 6.887% 93.285% # ( 3, 4 ] 3324 3.291% 96.576% # ( 4, 6 ] 2548 2.523% 99.099% # ( 6, 10 ] 668 0.661% 99.760% ( 10, 15 ] 101 0.100% 99.860% ( 15, 22 ] 19 0.019% 99.879% ( 22, 34 ] 7 0.007% 99.886% ( 34, 51 ] 15 0.015% 99.901% ( 51, 76 ] 23 0.023% 99.924% ( 76, 110 ] 12 0.012% 99.936% ( 110, 170 ] 14 0.014% 99.950% ( 170, 250 ] 23 0.023% 99.972% ( 250, 380 ] 12 0.012% 99.984% ( 380, 580 ] 6 0.006% 99.990% ( 580, 870 ] 3 0.003% 99.993% ( 870, 1300 ] 3 0.003% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 282667 Average: 3.2509 StdDev: 39.85 Min: 1 Median: 1.5477 Max: 5787 Percentiles: P50: 1.55 P75: 1.95 P99: 8.91 P99.9: 168.64 P99.99: 570.39 ------------------------------------------------------ [ 0, 1 ] 45337 16.039% 16.039% ### ( 1, 2 ] 175261 62.003% 78.042% ############ ( 2, 3 ] 33814 11.962% 90.004% ## ( 3, 4 ] 12305 4.353% 94.357% # ( 4, 6 ] 9746 3.448% 97.805% # ( 6, 10 ] 4649 1.645% 99.450% ( 10, 15 ] 620 0.219% 99.669% ( 15, 22 ] 82 0.029% 99.698% ( 22, 34 ] 31 0.011% 99.709% ( 34, 51 ] 8 0.003% 99.712% ( 51, 76 ] 50 0.018% 99.730% ( 76, 110 ] 193 0.068% 99.798% ( 110, 170 ] 295 0.104% 99.902% ( 170, 250 ] 115 0.041% 99.943% ( 250, 380 ] 68 0.024% 99.967% ( 380, 580 ] 68 0.024% 99.991% ( 580, 870 ] 45 0.016% 100.007% ( 870, 1300 ] 10 0.004% 100.011% ( 1300, 1900 ] 5 0.002% 100.012% ( 1900, 2900 ] 4 0.001% 100.014% ( 2900, 4400 ] 9 0.003% 100.017% ( 4400, 6600 ] 9 0.003% 100.020% ** Level 4 read latency histogram (micros): Count: 310 Average: 133.0645 StdDev: 729.11 Min: 1 Median: 2.9744 Max: 7379 Percentiles: P50: 2.97 P75: 6.96 P99: 5060.00 P99.9: 7379.00 P99.99: 7379.00 ------------------------------------------------------ [ 0, 1 ] 12 3.871% 3.871% # ( 1, 2 ] 67 21.613% 25.484% #### ( 2, 3 ] 78 25.161% 50.645% ##### ( 3, 4 ] 49 15.806% 66.452% ### ( 4, 6 ] 21 6.774% 73.226% # ( 6, 10 ] 23 7.419% 80.645% # ( 10, 15 ] 26 8.387% 89.032% ## ( 15, 22 ] 12 3.871% 92.903% # ( 34, 51 ] 1 0.323% 93.226% ( 170, 250 ] 1 0.323% 93.548% ( 250, 380 ] 1 0.323% 93.871% ( 380, 580 ] 7 2.258% 96.129% ( 580, 870 ] 1 0.323% 96.452% ( 870, 1300 ] 2 0.645% 97.097% ( 1300, 1900 ] 4 1.290% 98.387% ( 1900, 2900 ] 1 0.323% 98.710% ( 4400, 6600 ] 3 0.968% 99.677% ( 6600, 9900 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 912.7500 StdDev: 822.18 Min: 112 Median: 530.0000 Max: 2475 Percentiles: P50: 530.00 P75: 1300.00 P99: 2475.00 P99.9: 2475.00 P99.99: 2475.00 ------------------------------------------------------ ( 110, 170 ] 3 15.000% 15.000% ### ( 170, 250 ] 2 10.000% 25.000% ## ( 250, 380 ] 2 10.000% 35.000% ## ( 380, 580 ] 4 20.000% 55.000% #### ( 580, 870 ] 2 10.000% 65.000% ## ( 870, 1300 ] 2 10.000% 75.000% ## ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 4 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 15.4 total, 3.1 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 320.00 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.716 H:M:S, 11.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 318.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.398 H:M:S, 12.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-04:31:43 ... thread 0: (1000000,6000000) ops and (93500.3,231769.5) ops/second in (10.695149,25.887785) 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/10 2.09 GB 0.0 4.5 0.0 4.5 10.2 5.7 0.0 1.8 133.8 304.1 34.38 32.23 101 0.340 4669K 4828 0.0 0.0 L1 18/18 2.08 GB 0.0 4.7 3.4 1.3 4.7 3.4 0.2 1.4 231.9 229.5 20.90 20.19 3 6.966 4920K 49K 0.0 0.0 L2 9/5 1.10 GB 5.2 0.3 0.2 0.2 0.3 0.2 1.3 1.8 253.0 252.9 1.38 1.33 2 0.690 354K 190 0.0 0.0 L3 21/8 969.75 MB 0.8 1.2 0.2 0.9 1.2 0.2 0.2 5.0 239.0 238.6 4.95 4.57 2 2.474 1200K 1795 0.0 0.0 L4 174/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 133.0 133.1 1.26 0.88 1 1.264 170K 0 0.0 0.0 L5 1044/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1276/41 101.80 GB 0.0 10.9 4.0 6.9 16.5 9.7 2.3 2.9 177.3 269.6 62.87 59.19 109 0.577 11M 55K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.9 4.0 6.9 16.5 9.7 2.3 2.9 177.3 269.6 62.87 59.19 109 0.577 11M 55K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 10.9 4.0 6.9 10.8 4.0 0.0 0.0 242.2 240.9 46.02 44.14 25 1.841 11M 55K 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 347.8 16.85 15.05 84 0.201 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): 26.1 total, 25.9 interval Flush(GB): cumulative 5.722, interval 5.722 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 16.55 GB write, 649.96 MB/s write, 10.88 GB read, 427.42 MB/s read, 62.9 seconds Interval compaction: 16.55 GB write, 654.57 MB/s write, 10.88 GB read, 430.45 MB/s read, 62.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 9, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 9, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 19, pending-compaction-bytes-delays: 4, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 19, interval: 32 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2109559 Average: 2.2368 StdDev: 12.53 Min: 0 Median: 1.4423 Max: 4826 Percentiles: P50: 1.44 P75: 1.82 P99: 5.72 P99.9: 12.45 P99.99: 161.62 ------------------------------------------------------ [ 0, 1 ] 444334 21.063% 21.063% #### ( 1, 2 ] 1380093 65.421% 86.484% ############# ( 2, 3 ] 156283 7.408% 93.892% # ( 3, 4 ] 69792 3.308% 97.201% # ( 4, 6 ] 44068 2.089% 99.289% ( 6, 10 ] 12014 0.570% 99.859% ( 10, 15 ] 1769 0.084% 99.943% ( 15, 22 ] 236 0.011% 99.954% ( 22, 34 ] 22 0.001% 99.955% ( 34, 51 ] 11 0.001% 99.956% ( 51, 76 ] 17 0.001% 99.956% ( 76, 110 ] 321 0.015% 99.972% ( 110, 170 ] 451 0.021% 99.993% ( 170, 250 ] 222 0.011% 100.004% ( 250, 380 ] 158 0.007% 100.011% ( 380, 580 ] 120 0.006% 100.017% ( 580, 870 ] 99 0.005% 100.021% ( 870, 1300 ] 34 0.002% 100.023% ( 1300, 1900 ] 15 0.001% 100.024% ( 1900, 2900 ] 9 0.000% 100.024% ( 2900, 4400 ] 6 0.000% 100.024% ( 4400, 6600 ] 1 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 347438 Average: 2.5012 StdDev: 15.28 Min: 0 Median: 1.3496 Max: 1695 Percentiles: P50: 1.35 P75: 1.75 P99: 7.91 P99.9: 163.26 P99.99: 726.86 ------------------------------------------------------ [ 0, 1 ] 98466 28.341% 28.341% ###### ( 1, 2 ] 215258 61.956% 90.296% ############ ( 2, 3 ] 16410 4.723% 95.020% # ( 3, 4 ] 7136 2.054% 97.073% ( 4, 6 ] 4715 1.357% 98.431% ( 6, 10 ] 4153 1.195% 99.626% ( 10, 15 ] 295 0.085% 99.711% ( 15, 22 ] 69 0.020% 99.731% ( 22, 34 ] 2 0.001% 99.731% ( 34, 51 ] 1 0.000% 99.731% ( 51, 76 ] 9 0.003% 99.734% ( 76, 110 ] 250 0.072% 99.806% ( 110, 170 ] 369 0.106% 99.912% ( 170, 250 ] 99 0.028% 99.941% ( 250, 380 ] 77 0.022% 99.963% ( 380, 580 ] 75 0.022% 99.984% ( 580, 870 ] 40 0.012% 99.996% ( 870, 1300 ] 13 0.004% 100.000% ( 1300, 1900 ] 3 0.001% 100.001% ** Level 2 read latency histogram (micros): Count: 101000 Average: 2.3150 StdDev: 20.69 Min: 1 Median: 1.3835 Max: 4568 Percentiles: P50: 1.38 P75: 1.81 P99: 5.92 P99.9: 49.87 P99.99: 576.67 ------------------------------------------------------ [ 0, 1 ] 27628 27.354% 27.354% ##### ( 1, 2 ] 59634 59.044% 86.398% ############ ( 2, 3 ] 6956 6.887% 93.285% # ( 3, 4 ] 3324 3.291% 96.576% # ( 4, 6 ] 2548 2.523% 99.099% # ( 6, 10 ] 668 0.661% 99.760% ( 10, 15 ] 101 0.100% 99.860% ( 15, 22 ] 19 0.019% 99.879% ( 22, 34 ] 7 0.007% 99.886% ( 34, 51 ] 15 0.015% 99.901% ( 51, 76 ] 23 0.023% 99.924% ( 76, 110 ] 12 0.012% 99.936% ( 110, 170 ] 14 0.014% 99.950% ( 170, 250 ] 23 0.023% 99.972% ( 250, 380 ] 12 0.012% 99.984% ( 380, 580 ] 6 0.006% 99.990% ( 580, 870 ] 3 0.003% 99.993% ( 870, 1300 ] 3 0.003% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 282668 Average: 3.2523 StdDev: 39.86 Min: 1 Median: 1.5477 Max: 5787 Percentiles: P50: 1.55 P75: 1.95 P99: 8.91 P99.9: 168.85 P99.99: 570.53 ------------------------------------------------------ [ 0, 1 ] 45337 16.039% 16.039% ### ( 1, 2 ] 175261 62.002% 78.041% ############ ( 2, 3 ] 33814 11.962% 90.004% ## ( 3, 4 ] 12305 4.353% 94.357% # ( 4, 6 ] 9746 3.448% 97.805% # ( 6, 10 ] 4649 1.645% 99.450% ( 10, 15 ] 620 0.219% 99.669% ( 15, 22 ] 82 0.029% 99.698% ( 22, 34 ] 31 0.011% 99.709% ( 34, 51 ] 8 0.003% 99.712% ( 51, 76 ] 50 0.018% 99.729% ( 76, 110 ] 193 0.068% 99.798% ( 110, 170 ] 295 0.104% 99.902% ( 170, 250 ] 115 0.041% 99.943% ( 250, 380 ] 68 0.024% 99.967% ( 380, 580 ] 69 0.024% 99.991% ( 580, 870 ] 45 0.016% 100.007% ( 870, 1300 ] 10 0.004% 100.011% ( 1300, 1900 ] 5 0.002% 100.012% ( 1900, 2900 ] 4 0.001% 100.014% ( 2900, 4400 ] 9 0.003% 100.017% ( 4400, 6600 ] 9 0.003% 100.020% ** Level 4 read latency histogram (micros): Count: 310 Average: 133.0645 StdDev: 729.11 Min: 1 Median: 2.9744 Max: 7379 Percentiles: P50: 2.97 P75: 6.96 P99: 5060.00 P99.9: 7379.00 P99.99: 7379.00 ------------------------------------------------------ [ 0, 1 ] 12 3.871% 3.871% # ( 1, 2 ] 67 21.613% 25.484% #### ( 2, 3 ] 78 25.161% 50.645% ##### ( 3, 4 ] 49 15.806% 66.452% ### ( 4, 6 ] 21 6.774% 73.226% # ( 6, 10 ] 23 7.419% 80.645% # ( 10, 15 ] 26 8.387% 89.032% ## ( 15, 22 ] 12 3.871% 92.903% # ( 34, 51 ] 1 0.323% 93.226% ( 170, 250 ] 1 0.323% 93.548% ( 250, 380 ] 1 0.323% 93.871% ( 380, 580 ] 7 2.258% 96.129% ( 580, 870 ] 1 0.323% 96.452% ( 870, 1300 ] 2 0.645% 97.097% ( 1300, 1900 ] 4 1.290% 98.387% ( 1900, 2900 ] 1 0.323% 98.710% ( 4400, 6600 ] 3 0.968% 99.677% ( 6600, 9900 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 912.7500 StdDev: 822.18 Min: 112 Median: 530.0000 Max: 2475 Percentiles: P50: 530.00 P75: 1300.00 P99: 2475.00 P99.9: 2475.00 P99.99: 2475.00 ------------------------------------------------------ ( 110, 170 ] 3 15.000% 15.000% ### ( 170, 250 ] 2 10.000% 25.000% ## ( 250, 380 ] 2 10.000% 35.000% ## ( 380, 580 ] 4 20.000% 55.000% #### ( 580, 870 ] 2 10.000% 65.000% ## ( 870, 1300 ] 2 10.000% 75.000% ## ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 4 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 26.1 total, 10.7 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 226.48 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:9.307 H:M:S, 35.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 92.02 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:7.591 H:M:S, 71.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 0 2024/11/19-04:31:48 ... thread 0: (1000000,7000000) ops and (184250.8,223533.8) ops/second in (5.427386,31.315171) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/14 3.01 GB 69.2 5.0 0.0 5.0 11.7 6.6 0.0 1.8 130.7 302.8 39.52 36.94 117 0.338 5245K 5459 0.0 0.0 L1 18/18 2.08 GB 0.0 4.7 3.4 1.3 4.7 3.4 0.2 1.4 231.9 229.5 20.90 20.19 3 6.966 4920K 49K 0.0 0.0 L2 1/1 128.78 MB 0.0 0.3 0.2 0.2 0.3 0.2 1.3 1.8 253.0 252.9 1.38 1.33 2 0.690 354K 190 0.0 0.0 L3 26/2 1.10 GB 1.0 2.4 1.2 1.2 2.4 1.2 0.2 2.0 224.9 224.4 10.84 9.98 6 1.807 2476K 4853 0.0 0.0 L4 176/0 9.48 GB 1.0 0.3 0.3 0.0 0.3 0.3 1.0 1.0 150.1 150.0 1.87 1.41 3 0.622 284K 205 0.0 0.0 L5 1056/0 86.92 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1295/35 102.72 GB 0.0 12.8 5.1 7.7 19.4 11.7 4.0 2.9 175.5 266.1 74.50 69.85 131 0.569 13M 59K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.8 5.1 7.7 19.4 11.7 4.0 2.9 175.5 266.1 74.50 69.85 131 0.569 13M 59K 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.8 5.1 7.7 12.7 5.0 0.0 0.0 238.7 237.6 54.79 52.33 33 1.660 13M 59K 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 345.2 19.71 17.52 98 0.201 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.5 total, 31.3 interval Flush(GB): cumulative 6.644, interval 6.644 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 19.36 GB write, 629.26 MB/s write, 12.77 GB read, 415.19 MB/s read, 74.5 seconds Interval compaction: 19.36 GB write, 632.96 MB/s write, 12.77 GB read, 417.63 MB/s read, 74.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 22, pending-compaction-bytes-delays: 8, pending-compaction-bytes-stops: 0, total-delays: 19, total-stops: 22, interval: 41 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2513369 Average: 2.2963 StdDev: 12.50 Min: 0 Median: 1.4631 Max: 4826 Percentiles: P50: 1.46 P75: 1.84 P99: 5.85 P99.9: 13.06 P99.99: 179.25 ------------------------------------------------------ [ 0, 1 ] 494749 19.685% 19.685% #### ( 1, 2 ] 1645435 65.467% 85.152% ############# ( 2, 3 ] 201904 8.033% 93.185% ## ( 3, 4 ] 90142 3.587% 96.772% # ( 4, 6 ] 60525 2.408% 99.180% ( 6, 10 ] 16738 0.666% 99.846% ( 10, 15 ] 2230 0.089% 99.935% ( 15, 22 ] 297 0.012% 99.946% ( 22, 34 ] 26 0.001% 99.947% ( 34, 51 ] 11 0.000% 99.948% ( 51, 76 ] 21 0.001% 99.949% ( 76, 110 ] 375 0.015% 99.964% ( 110, 170 ] 629 0.025% 99.989% ( 170, 250 ] 317 0.013% 100.001% ( 250, 380 ] 219 0.009% 100.010% ( 380, 580 ] 165 0.007% 100.016% ( 580, 870 ] 124 0.005% 100.021% ( 870, 1300 ] 44 0.002% 100.023% ( 1300, 1900 ] 18 0.001% 100.024% ( 1900, 2900 ] 9 0.000% 100.024% ( 2900, 4400 ] 7 0.000% 100.025% ( 4400, 6600 ] 1 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 729423 Average: 2.6710 StdDev: 14.56 Min: 0 Median: 1.4826 Max: 2062 Percentiles: P50: 1.48 P75: 1.87 P99: 8.40 P99.9: 150.06 P99.99: 494.17 ------------------------------------------------------ [ 0, 1 ] 138005 18.920% 18.920% #### ( 1, 2 ] 469808 64.408% 83.328% ############# ( 2, 3 ] 62040 8.505% 91.833% ## ( 3, 4 ] 25842 3.543% 95.376% # ( 4, 6 ] 19744 2.707% 98.083% # ( 6, 10 ] 11132 1.526% 99.609% ( 10, 15 ] 1133 0.155% 99.764% ( 15, 22 ] 146 0.020% 99.784% ( 22, 34 ] 10 0.001% 99.786% ( 34, 51 ] 1 0.000% 99.786% ( 51, 76 ] 27 0.004% 99.790% ( 76, 110 ] 417 0.057% 99.847% ( 110, 170 ] 582 0.080% 99.927% ( 170, 250 ] 211 0.029% 99.955% ( 250, 380 ] 171 0.023% 99.979% ( 380, 580 ] 142 0.019% 99.998% ( 580, 870 ] 74 0.010% 100.008% ( 870, 1300 ] 26 0.004% 100.012% ( 1300, 1900 ] 5 0.001% 100.013% ( 1900, 2900 ] 1 0.000% 100.013% ** Level 2 read latency histogram (micros): Count: 101000 Average: 2.3150 StdDev: 20.69 Min: 1 Median: 1.3835 Max: 4568 Percentiles: P50: 1.38 P75: 1.81 P99: 5.92 P99.9: 49.87 P99.99: 576.67 ------------------------------------------------------ [ 0, 1 ] 27628 27.354% 27.354% ##### ( 1, 2 ] 59634 59.044% 86.398% ############ ( 2, 3 ] 6956 6.887% 93.285% # ( 3, 4 ] 3324 3.291% 96.576% # ( 4, 6 ] 2548 2.523% 99.099% # ( 6, 10 ] 668 0.661% 99.760% ( 10, 15 ] 101 0.100% 99.860% ( 15, 22 ] 19 0.019% 99.879% ( 22, 34 ] 7 0.007% 99.886% ( 34, 51 ] 15 0.015% 99.901% ( 51, 76 ] 23 0.023% 99.924% ( 76, 110 ] 12 0.012% 99.936% ( 110, 170 ] 14 0.014% 99.950% ( 170, 250 ] 23 0.023% 99.972% ( 250, 380 ] 12 0.012% 99.984% ( 380, 580 ] 6 0.006% 99.990% ( 580, 870 ] 3 0.003% 99.993% ( 870, 1300 ] 3 0.003% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 379179 Average: 3.3896 StdDev: 36.14 Min: 1 Median: 1.5983 Max: 5787 Percentiles: P50: 1.60 P75: 2.02 P99: 8.87 P99.9: 198.28 P99.99: 499.14 ------------------------------------------------------ [ 0, 1 ] 50027 13.194% 13.194% ### ( 1, 2 ] 233269 61.519% 74.713% ############ ( 2, 3 ] 51253 13.517% 88.230% ### ( 3, 4 ] 19954 5.262% 93.492% # ( 4, 6 ] 16785 4.427% 97.919% # ( 6, 10 ] 5719 1.508% 99.427% ( 10, 15 ] 775 0.204% 99.632% ( 15, 22 ] 105 0.028% 99.659% ( 22, 34 ] 33 0.009% 99.668% ( 34, 51 ] 9 0.002% 99.670% ( 51, 76 ] 52 0.014% 99.684% ( 76, 110 ] 277 0.073% 99.757% ( 110, 170 ] 469 0.124% 99.881% ( 170, 250 ] 206 0.054% 99.935% ( 250, 380 ] 136 0.036% 99.971% ( 380, 580 ] 121 0.032% 100.003% ( 580, 870 ] 64 0.017% 100.020% ( 870, 1300 ] 13 0.003% 100.023% ( 1300, 1900 ] 5 0.001% 100.025% ( 1900, 2900 ] 5 0.001% 100.026% ( 2900, 4400 ] 9 0.002% 100.028% ( 4400, 6600 ] 9 0.002% 100.031% ** Level 4 read latency histogram (micros): Count: 1755 Average: 48.0006 StdDev: 323.09 Min: 1 Median: 1.9554 Max: 7379 Percentiles: P50: 1.96 P75: 3.44 P99: 741.31 P99.9: 6046.33 P99.99: 7379.00 ------------------------------------------------------ [ 0, 1 ] 95 5.413% 5.413% # ( 1, 2 ] 819 46.667% 52.080% ######### ( 2, 3 ] 325 18.519% 70.598% #### ( 3, 4 ] 175 9.972% 80.570% ## ( 4, 6 ] 99 5.641% 86.211% # ( 6, 10 ] 44 2.507% 88.718% # ( 10, 15 ] 32 1.823% 90.541% ( 15, 22 ] 12 0.684% 91.225% ( 34, 51 ] 1 0.057% 91.282% ( 76, 110 ] 12 0.684% 91.966% ( 110, 170 ] 33 1.880% 93.846% ( 170, 250 ] 27 1.538% 95.385% ( 250, 380 ] 21 1.197% 96.581% ( 380, 580 ] 38 2.165% 98.746% ( 580, 870 ] 8 0.456% 99.202% ( 870, 1300 ] 5 0.285% 99.487% ( 1300, 1900 ] 4 0.228% 99.715% ( 1900, 2900 ] 1 0.057% 99.772% ( 4400, 6600 ] 3 0.171% 99.943% ( 6600, 9900 ] 1 0.057% 100.000% ** Level 5 read latency histogram (micros): Count: 80 Average: 760.8750 StdDev: 860.09 Min: 76 Median: 250.0000 Max: 3458 Percentiles: P50: 250.00 P75: 1360.00 P99: 3458.00 P99.9: 3458.00 P99.99: 3458.00 ------------------------------------------------------ ( 51, 76 ] 1 1.250% 1.250% ( 76, 110 ] 9 11.250% 12.500% ## ( 110, 170 ] 23 28.750% 41.250% ###### ( 170, 250 ] 7 8.750% 50.000% ## ( 250, 380 ] 4 5.000% 55.000% # ( 380, 580 ] 7 8.750% 63.750% ## ( 580, 870 ] 5 6.250% 70.000% # ( 870, 1300 ] 3 3.750% 73.750% # ( 1300, 1900 ] 10 12.500% 86.250% ### ( 1900, 2900 ] 9 11.250% 97.500% ## ( 2900, 4400 ] 2 2.500% 100.000% # ** DB Stats ** Uptime(secs): 31.5 total, 5.4 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 218.70 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:11.857 H:M:S, 37.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 181.34 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.550 H:M:S, 47.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/19-04:32:06 ... thread 0: (1000000,8000000) ops and (55646.9,162319.1) ops/second in (17.970456,49.285627) 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.84 GB 12.6 6.0 0.0 6.0 13.6 7.6 0.0 1.8 133.2 300.2 46.36 43.17 136 0.341 6268K 6422 0.0 0.0 L1 13/13 1.49 GB 0.0 8.9 5.5 3.4 8.8 5.4 0.2 1.6 224.9 222.0 40.55 38.35 4 10.136 8632K 49K 0.0 0.0 L2 12/10 1.44 GB 1.9 0.3 0.2 0.2 0.3 0.2 3.9 1.8 253.0 252.9 1.38 1.33 2 0.690 354K 190 0.0 0.0 L3 25/4 1.28 GB 1.0 5.0 2.5 2.5 4.9 2.5 0.2 2.0 180.5 179.6 28.20 22.13 18 1.567 5168K 23K 0.0 0.0 L4 179/3 9.60 GB 1.0 1.4 1.4 0.0 1.4 1.4 1.0 1.0 165.8 165.5 8.76 6.81 18 0.486 1468K 2062 0.0 0.0 L5 1068/0 87.91 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1308/39 103.56 GB 0.0 21.7 9.6 12.1 29.1 17.0 7.6 3.8 177.1 237.8 125.24 111.78 178 0.704 21M 81K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.7 9.6 12.1 29.1 17.0 7.6 3.8 177.1 237.8 125.24 111.78 178 0.704 21M 81K 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.7 9.6 12.1 21.5 9.5 0.0 0.0 216.3 214.9 102.54 91.79 65 1.578 21M 81K 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 341.4 22.70 19.99 113 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 49.5 total, 49.3 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 29.08 GB write, 602.03 MB/s write, 21.66 GB read, 448.41 MB/s read, 125.2 seconds Interval compaction: 29.08 GB write, 604.27 MB/s write, 21.66 GB read, 450.08 MB/s read, 125.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 18, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 18, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 22, pending-compaction-bytes-delays: 30, pending-compaction-bytes-stops: 0, total-delays: 48, total-stops: 22, interval: 70 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3199161 Average: 2.6218 StdDev: 19.54 Min: 0 Median: 1.4665 Max: 4978 Percentiles: P50: 1.47 P75: 1.86 P99: 6.52 P99.9: 124.58 P99.99: 395.42 ------------------------------------------------------ [ 0, 1 ] 639637 19.994% 19.994% #### ( 1, 2 ] 2057588 64.316% 84.310% ############# ( 2, 3 ] 258357 8.076% 92.386% ## ( 3, 4 ] 119647 3.740% 96.126% # ( 4, 6 ] 88687 2.772% 98.898% # ( 6, 10 ] 24854 0.777% 99.675% ( 10, 15 ] 3556 0.111% 99.786% ( 15, 22 ] 509 0.016% 99.802% ( 22, 34 ] 37 0.001% 99.803% ( 34, 51 ] 12 0.000% 99.804% ( 51, 76 ] 48 0.002% 99.805% ( 76, 110 ] 2467 0.077% 99.882% ( 110, 170 ] 2321 0.073% 99.955% ( 170, 250 ] 598 0.019% 99.974% ( 250, 380 ] 489 0.015% 99.989% ( 380, 580 ] 455 0.014% 100.003% ( 580, 870 ] 312 0.010% 100.013% ( 870, 1300 ] 130 0.004% 100.017% ( 1300, 1900 ] 63 0.002% 100.019% ( 1900, 2900 ] 33 0.001% 100.020% ( 2900, 4400 ] 23 0.001% 100.021% ( 4400, 6600 ] 3 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 1648332 Average: 3.4995 StdDev: 39.85 Min: 0 Median: 1.5324 Max: 8563 Percentiles: P50: 1.53 P75: 1.96 P99: 9.07 P99.9: 153.91 P99.99: 467.22 ------------------------------------------------------ [ 0, 1 ] 311564 18.902% 18.902% #### ( 1, 2 ] 962784 58.410% 77.311% ############ ( 2, 3 ] 166200 10.083% 87.394% ## ( 3, 4 ] 87394 5.302% 92.696% # ( 4, 6 ] 81387 4.938% 97.634% # ( 6, 10 ] 29386 1.783% 99.417% ( 10, 15 ] 4500 0.273% 99.690% ( 15, 22 ] 629 0.038% 99.728% ( 22, 34 ] 53 0.003% 99.731% ( 34, 51 ] 8 0.000% 99.731% ( 51, 76 ] 114 0.007% 99.738% ( 76, 110 ] 1539 0.093% 99.832% ( 110, 170 ] 1538 0.093% 99.925% ( 170, 250 ] 399 0.024% 99.949% ( 250, 380 ] 448 0.027% 99.976% ( 380, 580 ] 514 0.031% 100.008% ( 580, 870 ] 437 0.027% 100.034% ( 870, 1300 ] 248 0.015% 100.049% ( 1300, 1900 ] 92 0.006% 100.055% ( 1900, 2900 ] 46 0.003% 100.058% ( 2900, 4400 ] 62 0.004% 100.061% ( 4400, 6600 ] 7 0.000% 100.062% ( 6600, 9900 ] 8 0.000% 100.062% ** Level 2 read latency histogram (micros): Count: 101000 Average: 2.3150 StdDev: 20.69 Min: 1 Median: 1.3835 Max: 4568 Percentiles: P50: 1.38 P75: 1.81 P99: 5.92 P99.9: 49.87 P99.99: 576.67 ------------------------------------------------------ [ 0, 1 ] 27628 27.354% 27.354% ##### ( 1, 2 ] 59634 59.044% 86.398% ############ ( 2, 3 ] 6956 6.887% 93.285% # ( 3, 4 ] 3324 3.291% 96.576% # ( 4, 6 ] 2548 2.523% 99.099% # ( 6, 10 ] 668 0.661% 99.760% ( 10, 15 ] 101 0.100% 99.860% ( 15, 22 ] 19 0.019% 99.879% ( 22, 34 ] 7 0.007% 99.886% ( 34, 51 ] 15 0.015% 99.901% ( 51, 76 ] 23 0.023% 99.924% ( 76, 110 ] 12 0.012% 99.936% ( 110, 170 ] 14 0.014% 99.950% ( 170, 250 ] 23 0.023% 99.972% ( 250, 380 ] 12 0.012% 99.984% ( 380, 580 ] 6 0.006% 99.990% ( 580, 870 ] 3 0.003% 99.993% ( 870, 1300 ] 3 0.003% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 978193 Average: 4.0417 StdDev: 41.55 Min: 1 Median: 1.8021 Max: 5787 Percentiles: P50: 1.80 P75: 2.81 P99: 9.04 P99.9: 97.84 P99.99: 210.80 ------------------------------------------------------ [ 0, 1 ] 65361 6.682% 6.682% # ( 1, 2 ] 528283 54.006% 60.688% ########### ( 2, 3 ] 173263 17.713% 78.400% #### ( 3, 4 ] 91164 9.320% 87.720% ## ( 4, 6 ] 95369 9.750% 97.470% ## ( 6, 10 ] 19706 2.015% 99.484% ( 10, 15 ] 3286 0.336% 99.820% ( 15, 22 ] 392 0.040% 99.860% ( 22, 34 ] 49 0.005% 99.865% ( 34, 51 ] 15 0.002% 99.867% ( 51, 76 ] 112 0.011% 99.878% ( 76, 110 ] 336 0.034% 99.912% ( 110, 170 ] 572 0.058% 99.971% ( 170, 250 ] 369 0.038% 100.009% ( 250, 380 ] 360 0.037% 100.045% ( 380, 580 ] 373 0.038% 100.084% ( 580, 870 ] 305 0.031% 100.115% ( 870, 1300 ] 155 0.016% 100.131% ( 1300, 1900 ] 62 0.006% 100.137% ( 1900, 2900 ] 35 0.004% 100.140% ( 2900, 4400 ] 42 0.004% 100.145% ( 4400, 6600 ] 12 0.001% 100.146% ** Level 4 read latency histogram (micros): Count: 13680 Average: 59.4628 StdDev: 259.39 Min: 1 Median: 2.1295 Max: 7379 Percentiles: P50: 2.13 P75: 3.65 P99: 1108.81 P99.9: 3216.36 P99.99: 5731.73 ------------------------------------------------------ [ 0, 1 ] 498 3.640% 3.640% # ( 1, 2 ] 5984 43.743% 47.383% ######### ( 2, 3 ] 2765 20.212% 67.595% #### ( 3, 4 ] 1561 11.411% 79.006% ## ( 4, 6 ] 1107 8.092% 87.098% ## ( 6, 10 ] 295 2.156% 89.254% ( 10, 15 ] 103 0.753% 90.007% ( 15, 22 ] 16 0.117% 90.124% ( 34, 51 ] 1 0.007% 90.132% ( 76, 110 ] 43 0.314% 90.446% ( 110, 170 ] 150 1.096% 91.542% ( 170, 250 ] 190 1.389% 92.931% ( 250, 380 ] 205 1.499% 94.430% ( 380, 580 ] 328 2.398% 96.827% ( 580, 870 ] 230 1.681% 98.509% ( 870, 1300 ] 121 0.885% 99.393% ( 1300, 1900 ] 41 0.300% 99.693% ( 1900, 2900 ] 26 0.190% 99.883% ( 2900, 4400 ] 11 0.080% 99.963% ( 4400, 6600 ] 6 0.044% 100.007% ( 6600, 9900 ] 1 0.007% 100.015% ** Level 5 read latency histogram (micros): Count: 140 Average: 839.2571 StdDev: 973.87 Min: 76 Median: 345.3333 Max: 5434 Percentiles: P50: 345.33 P75: 1380.00 P99: 4314.29 P99.9: 5434.00 P99.99: 5434.00 ------------------------------------------------------ ( 51, 76 ] 1 0.714% 0.714% ( 76, 110 ] 13 9.286% 10.000% ## ( 110, 170 ] 28 20.000% 30.000% #### ( 170, 250 ] 17 12.143% 42.143% ## ( 250, 380 ] 15 10.714% 52.857% ## ( 380, 580 ] 13 9.286% 62.143% ## ( 580, 870 ] 10 7.143% 69.286% # ( 870, 1300 ] 6 4.286% 73.571% # ( 1300, 1900 ] 15 10.714% 84.286% ## ( 1900, 2900 ] 14 10.000% 94.286% ## ( 2900, 4400 ] 7 5.000% 99.286% # ( 4400, 6600 ] 1 0.714% 100.000% ** DB Stats ** Uptime(secs): 49.5 total, 18.0 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 159.15 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:26.567 H:M:S, 53.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 54.77 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:14.709 H:M:S, 81.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 2024/11/19-04:32:11 ... thread 0: (1000000,9000000) ops and (181154.3,164216.2) ops/second in (5.520157,54.805784) 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/13 2.83 GB 18.9 6.9 0.0 6.9 15.4 8.5 0.0 1.8 132.9 297.6 53.11 49.21 152 0.349 7164K 7398 0.0 0.0 L1 13/13 1.49 GB 0.0 8.9 5.5 3.4 8.8 5.4 0.2 1.6 224.9 222.0 40.55 38.35 4 10.136 8632K 49K 0.0 0.0 L2 1/1 128.78 MB 0.0 0.3 0.2 0.2 0.3 0.2 3.9 1.8 253.0 252.9 1.38 1.33 2 0.690 354K 190 0.0 0.0 L3 23/3 1.08 GB 1.0 6.4 3.8 2.6 6.4 3.8 0.2 1.7 180.7 180.0 36.16 28.61 20 1.808 6638K 27K 0.0 0.0 L4 177/0 9.45 GB 1.0 3.0 2.9 0.1 3.0 2.9 1.0 1.0 155.6 155.3 19.63 14.24 36 0.545 3043K 2062 0.0 0.0 L5 1088/0 89.57 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1317/30 104.53 GB 0.0 25.5 12.4 13.1 33.9 20.8 9.3 4.0 173.1 230.2 150.83 131.74 214 0.705 25M 86K 0.0 0.0 Int 0/0 0.00 KB 0.0 25.5 12.4 13.1 33.9 20.8 9.3 4.0 173.1 230.2 150.83 131.74 214 0.705 25M 86K 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 25.5 12.4 13.1 25.3 12.3 0.0 0.0 209.2 207.9 124.85 109.11 88 1.419 25M 86K 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 337.1 25.98 22.63 126 0.206 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 55.0 total, 54.8 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: 33.90 GB write, 631.27 MB/s write, 25.50 GB read, 474.90 MB/s read, 150.8 seconds Interval compaction: 33.90 GB write, 633.39 MB/s write, 25.50 GB read, 476.49 MB/s read, 150.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 18, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 18, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 34, pending-compaction-bytes-delays: 36, pending-compaction-bytes-stops: 0, total-delays: 54, total-stops: 34, interval: 88 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3663529 Average: 2.6950 StdDev: 21.79 Min: 0 Median: 1.4853 Max: 5061 Percentiles: P50: 1.49 P75: 1.87 P99: 6.73 P99.9: 124.46 P99.99: 423.98 ------------------------------------------------------ [ 0, 1 ] 686707 18.744% 18.744% #### ( 1, 2 ] 2359726 64.411% 83.156% ############# ( 2, 3 ] 317192 8.658% 91.814% ## ( 3, 4 ] 146853 4.009% 95.822% # ( 4, 6 ] 110923 3.028% 98.850% # ( 6, 10 ] 30144 0.823% 99.673% ( 10, 15 ] 4465 0.122% 99.795% ( 15, 22 ] 618 0.017% 99.812% ( 22, 34 ] 45 0.001% 99.813% ( 34, 51 ] 14 0.000% 99.813% ( 51, 76 ] 53 0.001% 99.815% ( 76, 110 ] 2532 0.069% 99.884% ( 110, 170 ] 2467 0.067% 99.951% ( 170, 250 ] 699 0.019% 99.970% ( 250, 380 ] 597 0.016% 99.987% ( 380, 580 ] 585 0.016% 100.002% ( 580, 870 ] 390 0.011% 100.013% ( 870, 1300 ] 180 0.005% 100.018% ( 1300, 1900 ] 83 0.002% 100.020% ( 1900, 2900 ] 48 0.001% 100.022% ( 2900, 4400 ] 34 0.001% 100.023% ( 4400, 6600 ] 7 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 1969281 Average: 3.6693 StdDev: 47.26 Min: 0 Median: 1.5595 Max: 8715 Percentiles: P50: 1.56 P75: 1.98 P99: 9.08 P99.9: 162.03 P99.99: 540.35 ------------------------------------------------------ [ 0, 1 ] 330153 16.765% 16.765% ### ( 1, 2 ] 1169692 59.397% 76.162% ############ ( 2, 3 ] 213465 10.840% 87.002% ## ( 3, 4 ] 108448 5.507% 92.509% # ( 4, 6 ] 100234 5.090% 97.599% # ( 6, 10 ] 35879 1.822% 99.421% ( 10, 15 ] 5412 0.275% 99.695% ( 15, 22 ] 720 0.037% 99.732% ( 22, 34 ] 54 0.003% 99.735% ( 34, 51 ] 8 0.000% 99.735% ( 51, 76 ] 118 0.006% 99.741% ( 76, 110 ] 1652 0.084% 99.825% ( 110, 170 ] 1703 0.086% 99.911% ( 170, 250 ] 503 0.026% 99.937% ( 250, 380 ] 550 0.028% 99.965% ( 380, 580 ] 615 0.031% 99.996% ( 580, 870 ] 497 0.025% 100.021% ( 870, 1300 ] 302 0.015% 100.037% ( 1300, 1900 ] 116 0.006% 100.043% ( 1900, 2900 ] 72 0.004% 100.046% ( 2900, 4400 ] 108 0.005% 100.052% ( 4400, 6600 ] 22 0.001% 100.053% ( 6600, 9900 ] 15 0.001% 100.054% ** Level 2 read latency histogram (micros): Count: 101000 Average: 2.3150 StdDev: 20.69 Min: 1 Median: 1.3835 Max: 4568 Percentiles: P50: 1.38 P75: 1.81 P99: 5.92 P99.9: 49.87 P99.99: 576.67 ------------------------------------------------------ [ 0, 1 ] 27628 27.354% 27.354% ##### ( 1, 2 ] 59634 59.044% 86.398% ############ ( 2, 3 ] 6956 6.887% 93.285% # ( 3, 4 ] 3324 3.291% 96.576% # ( 4, 6 ] 2548 2.523% 99.099% # ( 6, 10 ] 668 0.661% 99.760% ( 10, 15 ] 101 0.100% 99.860% ( 15, 22 ] 19 0.019% 99.879% ( 22, 34 ] 7 0.007% 99.886% ( 34, 51 ] 15 0.015% 99.901% ( 51, 76 ] 23 0.023% 99.924% ( 76, 110 ] 12 0.012% 99.936% ( 110, 170 ] 14 0.014% 99.950% ( 170, 250 ] 23 0.023% 99.972% ( 250, 380 ] 12 0.012% 99.984% ( 380, 580 ] 6 0.006% 99.990% ( 580, 870 ] 3 0.003% 99.993% ( 870, 1300 ] 3 0.003% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1374035 Average: 4.7336 StdDev: 63.40 Min: 1 Median: 1.8395 Max: 8721 Percentiles: P50: 1.84 P75: 2.89 P99: 8.97 P99.9: 20.21 P99.99: 159.60 ------------------------------------------------------ [ 0, 1 ] 73210 5.328% 5.328% # ( 1, 2 ] 731145 53.212% 58.540% ########### ( 2, 3 ] 254361 18.512% 77.052% #### ( 3, 4 ] 137455 10.004% 87.055% ## ( 4, 6 ] 143969 10.478% 97.533% ## ( 6, 10 ] 27143 1.975% 99.509% ( 10, 15 ] 4953 0.360% 99.869% ( 15, 22 ] 571 0.042% 99.911% ( 22, 34 ] 65 0.005% 99.915% ( 34, 51 ] 18 0.001% 99.917% ( 51, 76 ] 122 0.009% 99.926% ( 76, 110 ] 364 0.026% 99.952% ( 110, 170 ] 631 0.046% 99.998% ( 170, 250 ] 453 0.033% 100.031% ( 250, 380 ] 490 0.036% 100.067% ( 380, 580 ] 515 0.037% 100.104% ( 580, 870 ] 466 0.034% 100.138% ( 870, 1300 ] 266 0.019% 100.157% ( 1300, 1900 ] 131 0.010% 100.167% ( 1900, 2900 ] 117 0.009% 100.175% ( 2900, 4400 ] 182 0.013% 100.189% ( 4400, 6600 ] 47 0.003% 100.192% ( 6600, 9900 ] 6 0.000% 100.192% ** Level 4 read latency histogram (micros): Count: 26770 Average: 68.2277 StdDev: 334.84 Min: 1 Median: 2.0801 Max: 7379 Percentiles: P50: 2.08 P75: 3.54 P99: 1355.18 P99.9: 4700.19 P99.99: 6410.02 ------------------------------------------------------ [ 0, 1 ] 914 3.414% 3.414% # ( 1, 2 ] 12034 44.953% 48.368% ######### ( 2, 3 ] 5456 20.381% 68.749% #### ( 3, 4 ] 3113 11.629% 80.377% ## ( 4, 6 ] 2142 8.001% 88.379% ## ( 6, 10 ] 542 2.025% 90.403% ( 10, 15 ] 170 0.635% 91.038% ( 15, 22 ] 22 0.082% 91.121% ( 22, 34 ] 3 0.011% 91.132% ( 34, 51 ] 1 0.004% 91.136% ( 51, 76 ] 2 0.007% 91.143% ( 76, 110 ] 69 0.258% 91.401% ( 110, 170 ] 232 0.867% 92.267% ( 170, 250 ] 289 1.080% 93.347% ( 250, 380 ] 319 1.192% 94.539% ( 380, 580 ] 506 1.890% 96.429% ( 580, 870 ] 425 1.588% 98.016% ( 870, 1300 ] 253 0.945% 98.962% ( 1300, 1900 ] 112 0.418% 99.380% ( 1900, 2900 ] 70 0.261% 99.641% ( 2900, 4400 ] 65 0.243% 99.884% ( 4400, 6600 ] 31 0.116% 100.000% ( 6600, 9900 ] 3 0.011% 100.011% ** Level 5 read latency histogram (micros): Count: 240 Average: 1069.9625 StdDev: 1214.55 Min: 76 Median: 492.0000 Max: 5434 Percentiles: P50: 492.00 P75: 1675.00 P99: 5434.00 P99.9: 5434.00 P99.99: 5434.00 ------------------------------------------------------ ( 51, 76 ] 1 0.417% 0.417% ( 76, 110 ] 19 7.917% 8.333% ## ( 110, 170 ] 41 17.083% 25.417% ### ( 170, 250 ] 19 7.917% 33.333% ## ( 250, 380 ] 26 10.833% 44.167% ## ( 380, 580 ] 25 10.417% 54.583% ## ( 580, 870 ] 21 8.750% 63.333% ## ( 870, 1300 ] 13 5.417% 68.750% # ( 1300, 1900 ] 24 10.000% 78.750% ## ( 1900, 2900 ] 27 11.250% 90.000% ## ( 2900, 4400 ] 18 7.500% 97.500% ## ( 4400, 6600 ] 6 2.500% 100.000% # ** DB Stats ** Uptime(secs): 55.0 total, 5.5 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 161.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:29.216 H:M:S, 53.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 178.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:2.649 H:M:S, 48.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/19-04:32:16 ... thread 0: (1000000,10000000) ops and (223769.2,168706.1) ops/second in (4.468891,59.274675) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/13 3.81 GB 188.5 8.6 0.0 8.6 18.1 9.5 0.0 1.9 140.1 295.1 62.93 58.49 171 0.368 8954K 11K 0.0 0.0 L1 13/13 1.49 GB 0.0 8.9 5.5 3.4 8.8 5.4 0.2 1.6 224.9 222.0 40.55 38.35 4 10.136 8632K 49K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.2 0.2 0.3 0.2 3.9 1.8 253.0 252.9 1.38 1.33 2 0.690 354K 190 0.0 0.0 L3 19/0 969.43 MB 1.0 6.6 4.0 2.7 6.6 3.9 0.2 1.7 180.1 179.4 37.69 29.75 21 1.795 6896K 28K 0.0 0.0 L4 181/0 9.70 GB 1.0 3.2 3.1 0.1 3.2 3.1 1.0 1.0 157.8 157.5 21.02 15.48 39 0.539 3300K 2062 0.0 0.0 L5 1088/0 89.57 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1319/26 105.51 GB 0.0 27.7 12.8 14.9 37.1 22.2 9.3 3.9 173.6 232.3 163.57 143.41 237 0.690 28M 91K 0.0 0.0 Int 0/0 0.00 KB 0.0 27.7 12.8 14.9 37.1 22.2 9.3 3.9 173.6 232.3 163.57 143.41 237 0.690 28M 91K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 27.7 12.8 14.9 27.6 12.6 0.0 0.0 210.9 209.7 134.64 118.21 96 1.403 28M 91K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.5 9.5 0.0 0.0 0.0 337.6 28.92 25.20 141 0.205 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): 59.5 total, 59.3 interval Flush(GB): cumulative 9.536, interval 9.536 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 37.11 GB write, 639.02 MB/s write, 27.73 GB read, 477.54 MB/s read, 163.6 seconds Interval compaction: 37.11 GB write, 641.01 MB/s write, 27.73 GB read, 479.02 MB/s read, 163.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 24, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 24, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 36, pending-compaction-bytes-delays: 36, pending-compaction-bytes-stops: 0, total-delays: 60, total-stops: 36, interval: 96 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4142177 Average: 2.6647 StdDev: 20.84 Min: 0 Median: 1.4931 Max: 5061 Percentiles: P50: 1.49 P75: 1.88 P99: 6.76 P99.9: 112.64 P99.99: 365.15 ------------------------------------------------------ [ 0, 1 ] 751168 18.135% 18.135% #### ( 1, 2 ] 2676850 64.624% 82.759% ############# ( 2, 3 ] 366137 8.839% 91.598% ## ( 3, 4 ] 171159 4.132% 95.730% # ( 4, 6 ] 128751 3.108% 98.838% # ( 6, 10 ] 35338 0.853% 99.692% ( 10, 15 ] 5115 0.123% 99.815% ( 15, 22 ] 671 0.016% 99.831% ( 22, 34 ] 46 0.001% 99.832% ( 34, 51 ] 15 0.000% 99.833% ( 51, 76 ] 56 0.001% 99.834% ( 76, 110 ] 2618 0.063% 99.897% ( 110, 170 ] 2538 0.061% 99.959% ( 170, 250 ] 742 0.018% 99.977% ( 250, 380 ] 632 0.015% 99.992% ( 380, 580 ] 609 0.015% 100.006% ( 580, 870 ] 405 0.010% 100.016% ( 870, 1300 ] 188 0.005% 100.021% ( 1300, 1900 ] 85 0.002% 100.023% ( 1900, 2900 ] 50 0.001% 100.024% ( 2900, 4400 ] 35 0.001% 100.025% ( 4400, 6600 ] 7 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 2157993 Average: 3.5966 StdDev: 45.49 Min: 0 Median: 1.5630 Max: 8715 Percentiles: P50: 1.56 P75: 1.98 P99: 9.04 P99.9: 160.18 P99.99: 545.74 ------------------------------------------------------ [ 0, 1 ] 348609 16.154% 16.154% ### ( 1, 2 ] 1297267 60.115% 76.269% ############ ( 2, 3 ] 235485 10.912% 87.181% ## ( 3, 4 ] 117348 5.438% 92.619% # ( 4, 6 ] 107838 4.997% 97.616% # ( 6, 10 ] 39278 1.820% 99.436% ( 10, 15 ] 5813 0.269% 99.706% ( 15, 22 ] 749 0.035% 99.740% ( 22, 34 ] 55 0.003% 99.743% ( 34, 51 ] 9 0.000% 99.743% ( 51, 76 ] 120 0.006% 99.749% ( 76, 110 ] 1789 0.083% 99.832% ( 110, 170 ] 1765 0.082% 99.913% ( 170, 250 ] 541 0.025% 99.939% ( 250, 380 ] 581 0.027% 99.965% ( 380, 580 ] 641 0.030% 99.995% ( 580, 870 ] 511 0.024% 100.019% ( 870, 1300 ] 310 0.014% 100.033% ( 1300, 1900 ] 120 0.006% 100.039% ( 1900, 2900 ] 77 0.004% 100.042% ( 2900, 4400 ] 108 0.005% 100.047% ( 4400, 6600 ] 22 0.001% 100.048% ( 6600, 9900 ] 15 0.001% 100.049% ** Level 2 read latency histogram (micros): Count: 101000 Average: 2.3150 StdDev: 20.69 Min: 1 Median: 1.3835 Max: 4568 Percentiles: P50: 1.38 P75: 1.81 P99: 5.92 P99.9: 49.87 P99.99: 576.67 ------------------------------------------------------ [ 0, 1 ] 27628 27.354% 27.354% ##### ( 1, 2 ] 59634 59.044% 86.398% ############ ( 2, 3 ] 6956 6.887% 93.285% # ( 3, 4 ] 3324 3.291% 96.576% # ( 4, 6 ] 2548 2.523% 99.099% # ( 6, 10 ] 668 0.661% 99.760% ( 10, 15 ] 101 0.100% 99.860% ( 15, 22 ] 19 0.019% 99.879% ( 22, 34 ] 7 0.007% 99.886% ( 34, 51 ] 15 0.015% 99.901% ( 51, 76 ] 23 0.023% 99.924% ( 76, 110 ] 12 0.012% 99.936% ( 110, 170 ] 14 0.014% 99.950% ( 170, 250 ] 23 0.023% 99.972% ( 250, 380 ] 12 0.012% 99.984% ( 380, 580 ] 6 0.006% 99.990% ( 580, 870 ] 3 0.003% 99.993% ( 870, 1300 ] 3 0.003% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1450164 Average: 4.6382 StdDev: 61.76 Min: 1 Median: 1.8418 Max: 8721 Percentiles: P50: 1.84 P75: 2.89 P99: 8.93 P99.9: 18.29 P99.99: 149.87 ------------------------------------------------------ [ 0, 1 ] 74988 5.171% 5.171% # ( 1, 2 ] 772311 53.257% 58.428% ########### ( 2, 3 ] 271036 18.690% 77.118% #### ( 3, 4 ] 144734 9.981% 87.098% ## ( 4, 6 ] 151695 10.461% 97.559% ## ( 6, 10 ] 28529 1.967% 99.526% ( 10, 15 ] 5142 0.355% 99.881% ( 15, 22 ] 594 0.041% 99.922% ( 22, 34 ] 66 0.005% 99.926% ( 34, 51 ] 18 0.001% 99.928% ( 51, 76 ] 122 0.008% 99.936% ( 76, 110 ] 364 0.025% 99.961% ( 110, 170 ] 632 0.044% 100.005% ( 170, 250 ] 456 0.031% 100.036% ( 250, 380 ] 492 0.034% 100.070% ( 380, 580 ] 515 0.036% 100.106% ( 580, 870 ] 468 0.032% 100.138% ( 870, 1300 ] 266 0.018% 100.156% ( 1300, 1900 ] 131 0.009% 100.165% ( 1900, 2900 ] 118 0.008% 100.173% ( 2900, 4400 ] 182 0.013% 100.186% ( 4400, 6600 ] 47 0.003% 100.189% ( 6600, 9900 ] 6 0.000% 100.189% ** Level 4 read latency histogram (micros): Count: 28986 Average: 66.3158 StdDev: 325.71 Min: 1 Median: 2.0637 Max: 7379 Percentiles: P50: 2.06 P75: 3.52 P99: 1298.60 P99.9: 4542.93 P99.99: 6394.29 ------------------------------------------------------ [ 0, 1 ] 970 3.346% 3.346% # ( 1, 2 ] 13148 45.360% 48.706% ######### ( 2, 3 ] 5888 20.313% 69.020% #### ( 3, 4 ] 3328 11.481% 80.501% ## ( 4, 6 ] 2282 7.873% 88.374% ## ( 6, 10 ] 582 2.008% 90.382% ( 10, 15 ] 185 0.638% 91.020% ( 15, 22 ] 24 0.083% 91.103% ( 22, 34 ] 4 0.014% 91.116% ( 34, 51 ] 1 0.003% 91.120% ( 51, 76 ] 2 0.007% 91.127% ( 76, 110 ] 84 0.290% 91.417% ( 110, 170 ] 269 0.928% 92.345% ( 170, 250 ] 321 1.107% 93.452% ( 250, 380 ] 354 1.221% 94.673% ( 380, 580 ] 543 1.873% 96.547% ( 580, 870 ] 447 1.542% 98.089% ( 870, 1300 ] 265 0.914% 99.003% ( 1300, 1900 ] 120 0.414% 99.417% ( 1900, 2900 ] 73 0.252% 99.669% ( 2900, 4400 ] 65 0.224% 99.893% ( 4400, 6600 ] 31 0.107% 100.000% ( 6600, 9900 ] 3 0.010% 100.010% ** Level 5 read latency histogram (micros): Count: 240 Average: 1069.9625 StdDev: 1214.55 Min: 76 Median: 492.0000 Max: 5434 Percentiles: P50: 492.00 P75: 1675.00 P99: 5434.00 P99.9: 5434.00 P99.99: 5434.00 ------------------------------------------------------ ( 51, 76 ] 1 0.417% 0.417% ( 76, 110 ] 19 7.917% 8.333% ## ( 110, 170 ] 41 17.083% 25.417% ### ( 170, 250 ] 19 7.917% 33.333% ## ( 250, 380 ] 26 10.833% 44.167% ## ( 380, 580 ] 25 10.417% 54.583% ## ( 580, 870 ] 21 8.750% 63.333% ## ( 870, 1300 ] 13 5.417% 68.750% # ( 1300, 1900 ] 24 10.000% 78.750% ## ( 1900, 2900 ] 27 11.250% 90.000% ## ( 2900, 4400 ] 18 7.500% 97.500% ## ( 4400, 6600 ] 6 2.500% 100.000% # ** DB Stats ** Uptime(secs): 59.5 total, 4.5 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 165.52 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:30.896 H:M:S, 52.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 220.23 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.681 H:M:S, 37.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.917 micros/op 169015 ops/sec 60.000 seconds 10140999 operations; 163.8 MB/s Microseconds per write: Count: 10140999 Average: 5.9166 StdDev: 250.56 Min: 1 Median: 1.7867 Max: 228275 Percentiles: P50: 1.79 P75: 2.85 P99: 9.47 P99.9: 1158.79 P99.99: 2678.64 ------------------------------------------------------ [ 0, 1 ] 1113050 10.976% 10.976% ## ( 1, 2 ] 5030320 49.604% 60.580% ########## ( 2, 3 ] 1719784 16.959% 77.538% ### ( 3, 4 ] 1440959 14.209% 91.747% ### ( 4, 6 ] 621836 6.132% 97.879% # ( 6, 10 ] 130910 1.291% 99.170% ( 10, 15 ] 39480 0.389% 99.560% ( 15, 22 ] 9673 0.095% 99.655% ( 22, 34 ] 1986 0.020% 99.675% ( 34, 51 ] 218 0.002% 99.677% ( 51, 76 ] 25 0.000% 99.677% ( 76, 110 ] 6788 0.067% 99.744% ( 110, 170 ] 3029 0.030% 99.774% ( 170, 250 ] 292 0.003% 99.777% ( 250, 380 ] 173 0.002% 99.778% ( 380, 580 ] 28 0.000% 99.779% ( 580, 870 ] 24 0.000% 99.779% ( 870, 1300 ] 18289 0.180% 99.959% ( 1300, 1900 ] 85 0.001% 99.960% ( 1900, 2900 ] 3899 0.038% 99.999% ( 2900, 4400 ] 97 0.001% 99.999% ( 4400, 6600 ] 25 0.000% 100.000% ( 6600, 9900 ] 6 0.000% 100.000% ( 9900, 14000 ] 4 0.000% 100.000% ( 14000, 22000 ] 1 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% ( 170000, 250000 ] 14 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 : 196179 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 : 10140999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10465510968 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 : 568 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31236695 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 : 32946218948 rocksdb.compact.write.bytes COUNT : 32756302336 rocksdb.flush.write.bytes COUNT : 10437189144 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 : 56 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 : 211 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 : 10352888832 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3897344 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 : 33042084305 rocksdb.non.last.level.read.count COUNT : 7984233 rocksdb.block.checksum.compute.count COUNT : 7983153 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.459900 P95 : 3.972963 P99 : 8.198888 P100 : 228270.000000 COUNT : 10140999 SUM : 55178115 rocksdb.compaction.times.micros P50 : 936206.896552 P95 : 3705000.000000 P99 : 14240000.000000 P100 : 19648287.000000 COUNT : 97 SUM : 135584760 rocksdb.compaction.times.cpu_micros P50 : 894000.000000 P95 : 3705000.000000 P99 : 14240000.000000 P100 : 18158917.000000 COUNT : 97 SUM : 119137238 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.391304 P95 : 1294.266667 P99 : 12196.000000 P100 : 23463.000000 COUNT : 144 SUM : 139443 rocksdb.compaction.outfile.sync.micros P50 : 950.098039 P95 : 66500.000000 P99 : 220600.000000 P100 : 269572.000000 COUNT : 394 SUM : 4340657 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 : 107.854369 P95 : 776.785714 P99 : 1705.000000 P100 : 5079.000000 COUNT : 265 SUM : 61169 rocksdb.table.open.io.micros P50 : 1311.538462 P95 : 6741.428571 P99 : 12629.428571 P100 : 18784.000000 COUNT : 568 SUM : 1094764 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.618480 P95 : 7.846822 P99 : 11.324092 P100 : 9472.000000 COUNT : 7981469 SUM : 44577898 rocksdb.read.block.get.micros P50 : 428.062016 P95 : 2954.545455 P99 : 5650.333333 P100 : 7514.000000 COUNT : 1136 SUM : 901225 rocksdb.write.raw.block.micros P50 : 0.513172 P95 : 0.975026 P99 : 2.929272 P100 : 11212.000000 COUNT : 10461269 SUM : 19590319 rocksdb.numfiles.in.singlecompaction P50 : 3.060345 P95 : 7.300000 P99 : 21.055000 P100 : 28.000000 COUNT : 127 SUM : 479 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.561215 P95 : 1153.370423 P99 : 2399.530565 P100 : 228054.000000 COUNT : 206132 SUM : 31256151 rocksdb.sst.read.micros P50 : 1.567921 P95 : 4.730134 P99 : 8.497235 P100 : 8721.000000 COUNT : 7984349 SUM : 28263419 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 : 10140999 SUM : 10465510968 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 : 212393.162393 P95 : 334933.333333 P99 : 433200.000000 P100 : 448918.000000 COUNT : 144 SUM : 29475817 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 : 361 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