[2024-11-28 07:38:14.735031] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 22.11.4 initialization... [2024-11-28 07:38:14.735184] [ 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_pid4063518 ] Set seed to 1732775894731568 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-28 07:38:14.819913] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-28 07:38:14.859773] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-28 07:38:14.859821] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 4063518' to capture a snapshot of events at runtime. [2024-11-28 07:38:14.859834] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid4063518 for offline analysis/debug. [2024-11-28 07:38:14.859862] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Thu Nov 28 07:38:19 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/28-07:38:21 ... thread 0: (1000000,1000000) ops and (353146.3,353146.3) ops/second in (2.831688,2.831688) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/8 504.02 MB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 354.6 2.31 2.10 12 0.192 0 0 0.0 0.0 L1 3/3 188.89 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 262.5 262.4 0.72 0.70 1 0.720 191K 72 0.0 0.0 L2 2/1 125.97 MB 0.0 0.1 0.1 0.1 0.1 0.1 0.1 2.0 229.3 229.2 0.55 0.53 1 0.549 127K 34 0.0 0.0 L3 9/0 741.53 MB 0.7 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.47 GB 1.0 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 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1182/12 96.94 GB 0.0 0.3 0.2 0.1 1.1 1.0 1.0 1.4 88.0 316.8 3.58 3.32 14 0.256 319K 106 0.0 0.0 Int 0/0 0.00 KB 0.0 0.3 0.2 0.1 1.1 1.0 0.6 1.4 88.0 316.8 3.58 3.32 14 0.256 319K 106 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.1 0.3 0.2 0.0 0.0 248.2 248.1 1.27 1.22 2 0.635 319K 106 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 354.6 2.31 2.10 12 0.192 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 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.11 GB write, 373.48 MB/s write, 0.31 GB read, 103.75 MB/s read, 3.6 seconds Interval compaction: 1.11 GB write, 400.10 MB/s write, 0.31 GB read, 111.14 MB/s read, 3.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 1, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 1, interval: 1 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 120396 Average: 1.8414 StdDev: 16.86 Min: 1 Median: 1.1607 Max: 3103 Percentiles: P50: 1.16 P75: 1.63 P99: 4.47 P99.9: 9.60 P99.99: 139.70 ------------------------------------------------------ [ 0, 1 ] 49984 41.516% 41.516% ######## ( 1, 2 ] 63549 52.783% 94.300% ########### ( 2, 3 ] 3670 3.048% 97.348% # ( 3, 4 ] 1768 1.468% 98.816% ( 4, 6 ] 959 0.797% 99.613% ( 6, 10 ] 386 0.321% 99.934% ( 10, 15 ] 47 0.039% 99.973% ( 15, 22 ] 15 0.012% 99.985% ( 22, 34 ] 2 0.002% 99.987% ( 51, 76 ] 2 0.002% 99.988% ( 110, 170 ] 8 0.007% 99.995% ( 170, 250 ] 4 0.003% 99.998% ( 250, 380 ] 4 0.003% 100.002% ( 380, 580 ] 1 0.001% 100.002% ( 580, 870 ] 1 0.001% 100.003% ( 870, 1300 ] 2 0.002% 100.005% ( 1300, 1900 ] 1 0.001% 100.006% ( 2900, 4400 ] 3 0.002% 100.008% ** Level 1 read latency histogram (micros): Count: 23325 Average: 1.7919 StdDev: 6.68 Min: 1 Median: 1.2027 Max: 804 Percentiles: P50: 1.20 P75: 1.66 P99: 3.97 P99.9: 8.58 P99.99: 358.39 ------------------------------------------------------ [ 0, 1 ] 9055 38.821% 38.821% ######## ( 1, 2 ] 12867 55.164% 93.985% ########### ( 2, 3 ] 841 3.606% 97.591% # ( 3, 4 ] 338 1.449% 99.040% ( 4, 6 ] 171 0.733% 99.773% ( 6, 10 ] 46 0.197% 99.970% ( 10, 15 ] 3 0.013% 99.983% ( 250, 380 ] 2 0.009% 99.991% ( 380, 580 ] 1 0.004% 99.996% ( 580, 870 ] 1 0.004% 100.000% ** Level 2 read latency histogram (micros): Count: 9516 Average: 3.3553 StdDev: 41.13 Min: 1 Median: 1.4912 Max: 2282 Percentiles: P50: 1.49 P75: 1.90 P99: 6.70 P99.9: 281.40 P99.99: 2282.00 ------------------------------------------------------ [ 0, 1 ] 1931 20.292% 20.292% #### ( 1, 2 ] 5755 60.477% 80.769% ############ ( 2, 3 ] 797 8.375% 89.145% ## ( 3, 4 ] 598 6.284% 95.429% # ( 4, 6 ] 325 3.415% 98.844% # ( 6, 10 ] 91 0.956% 99.800% ( 10, 15 ] 6 0.063% 99.863% ( 15, 22 ] 1 0.011% 99.874% ( 22, 34 ] 1 0.011% 99.884% ( 110, 170 ] 1 0.011% 99.895% ( 170, 250 ] 1 0.011% 99.905% ( 250, 380 ] 2 0.021% 99.926% ( 580, 870 ] 3 0.032% 99.958% ( 870, 1300 ] 2 0.021% 99.979% ( 1300, 1900 ] 1 0.011% 99.989% ( 1900, 2900 ] 2 0.021% 100.011% ** Level 3 read latency histogram (micros): Count: 55 Average: 1525.2545 StdDev: 1092.73 Min: 131 Median: 1235.5000 Max: 4850 Percentiles: P50: 1235.50 P75: 2254.17 P99: 4850.00 P99.9: 4850.00 P99.99: 4850.00 ------------------------------------------------------ ( 110, 170 ] 1 1.818% 1.818% ( 170, 250 ] 1 1.818% 3.636% ( 250, 380 ] 2 3.636% 7.273% # ( 380, 580 ] 7 12.727% 20.000% ### ( 580, 870 ] 8 14.545% 34.545% ### ( 870, 1300 ] 10 18.182% 52.727% #### ( 1300, 1900 ] 8 14.545% 67.273% ### ( 1900, 2900 ] 12 21.818% 89.091% #### ( 2900, 4400 ] 4 7.273% 96.364% # ( 4400, 6600 ] 2 3.636% 100.000% # ** Level 4 read latency histogram (micros): Count: 15 Average: 1680.6667 StdDev: 1212.59 Min: 312 Median: 1228.3333 Max: 4018 Percentiles: P50: 1228.33 P75: 2525.00 P99: 4018.00 P99.9: 4018.00 P99.99: 4018.00 ------------------------------------------------------ ( 250, 380 ] 1 6.667% 6.667% # ( 380, 580 ] 2 13.333% 20.000% ### ( 580, 870 ] 2 13.333% 33.333% ### ( 870, 1300 ] 3 20.000% 53.333% #### ( 1300, 1900 ] 2 13.333% 66.667% ### ( 1900, 2900 ] 2 13.333% 80.000% ### ( 2900, 4400 ] 3 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 20 Average: 572.9500 StdDev: 680.53 Min: 44 Median: 150.0000 Max: 2008 Percentiles: P50: 150.00 P75: 1085.00 P99: 2008.00 P99.9: 2008.00 P99.99: 2008.00 ------------------------------------------------------ ( 34, 51 ] 2 10.000% 10.000% ## ( 51, 76 ] 1 5.000% 15.000% # ( 76, 110 ] 3 15.000% 30.000% ### ( 110, 170 ] 6 30.000% 60.000% ###### ( 380, 580 ] 2 10.000% 70.000% ## ( 870, 1300 ] 2 10.000% 80.000% ## ( 1300, 1900 ] 2 10.000% 90.000% ## ( 1900, 2900 ] 2 10.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, 324.16 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.209 H:M:S, 6.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 347.21 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.209 H:M:S, 7.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/28-07:38:25 ... thread 0: (1000000,2000000) ops and (325160.2,338575.9) ops/second in (3.075407,5.907095) 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 98.5 325.8 8.31 7.73 30 0.277 831K 836 0.0 0.0 L1 1/0 3.22 MB 0.3 0.6 0.4 0.2 0.6 0.4 0.1 1.4 247.6 247.2 2.54 2.47 2 1.272 639K 807 0.0 0.0 L2 5/3 437.87 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.5 2.0 229.3 229.2 0.55 0.53 1 0.549 127K 34 0.0 0.0 L3 17/1 866.52 MB 0.8 0.1 0.1 0.0 0.1 0.1 0.1 1.0 219.1 219.1 0.57 0.51 1 0.571 126K 0 0.0 0.0 L4 116/0 9.47 GB 1.0 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 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1193/8 97.98 GB 0.0 1.7 0.6 1.0 3.5 2.5 1.4 1.9 141.9 299.6 11.98 11.24 34 0.352 1725K 1677 0.0 0.0 Int 0/0 0.00 KB 0.0 1.7 0.6 1.0 3.5 2.5 1.0 1.9 141.9 299.6 11.98 11.24 34 0.352 1725K 1677 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.7 0.6 1.0 1.7 0.6 0.0 0.0 253.3 253.1 6.71 6.50 7 0.959 1725K 1677 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 358.8 5.27 4.74 27 0.195 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 total, 5.9 interval Flush(GB): cumulative 1.846, interval 1.846 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.50 GB write, 587.12 MB/s write, 1.66 GB read, 278.15 MB/s read, 12.0 seconds Interval compaction: 3.50 GB write, 607.18 MB/s write, 1.66 GB read, 287.66 MB/s read, 12.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 404475 Average: 1.9857 StdDev: 11.94 Min: 1 Median: 1.3372 Max: 3103 Percentiles: P50: 1.34 P75: 1.75 P99: 5.24 P99.9: 9.61 P99.99: 16.87 ------------------------------------------------------ [ 0, 1 ] 120552 29.805% 29.805% ###### ( 1, 2 ] 242263 59.896% 89.700% ############ ( 2, 3 ] 22615 5.591% 95.291% # ( 3, 4 ] 11222 2.774% 98.066% # ( 4, 6 ] 6106 1.510% 99.575% ( 6, 10 ] 1453 0.359% 99.935% ( 10, 15 ] 215 0.053% 99.988% ( 15, 22 ] 32 0.008% 99.996% ( 22, 34 ] 5 0.001% 99.997% ( 34, 51 ] 1 0.000% 99.997% ( 51, 76 ] 3 0.001% 99.998% ( 110, 170 ] 15 0.004% 100.002% ( 170, 250 ] 11 0.003% 100.004% ( 250, 380 ] 8 0.002% 100.006% ( 380, 580 ] 4 0.001% 100.007% ( 580, 870 ] 7 0.002% 100.009% ( 870, 1300 ] 8 0.002% 100.011% ( 1300, 1900 ] 2 0.000% 100.012% ( 1900, 2900 ] 2 0.000% 100.012% ( 2900, 4400 ] 3 0.001% 100.013% ** Level 1 read latency histogram (micros): Count: 106895 Average: 2.1137 StdDev: 6.77 Min: 0 Median: 1.4554 Max: 1159 Percentiles: P50: 1.46 P75: 1.84 P99: 5.54 P99.9: 9.73 P99.99: 256.73 ------------------------------------------------------ [ 0, 1 ] 22047 20.625% 20.625% #### ( 1, 2 ] 68945 64.498% 85.123% ############# ( 2, 3 ] 9266 8.668% 93.791% ## ( 3, 4 ] 3762 3.519% 97.310% # ( 4, 6 ] 2348 2.197% 99.507% ( 6, 10 ] 450 0.421% 99.928% ( 10, 15 ] 51 0.048% 99.976% ( 15, 22 ] 11 0.010% 99.986% ( 22, 34 ] 1 0.001% 99.987% ( 51, 76 ] 2 0.002% 99.989% ( 110, 170 ] 1 0.001% 99.990% ( 250, 380 ] 6 0.006% 99.995% ( 380, 580 ] 1 0.001% 99.996% ( 580, 870 ] 1 0.001% 99.997% ( 870, 1300 ] 3 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 31749 Average: 2.5310 StdDev: 22.54 Min: 1 Median: 1.5052 Max: 2282 Percentiles: P50: 1.51 P75: 1.91 P99: 5.89 P99.9: 10.63 P99.99: 1262.40 ------------------------------------------------------ [ 0, 1 ] 5927 18.668% 18.668% #### ( 1, 2 ] 19691 62.021% 80.689% ############ ( 2, 3 ] 3015 9.496% 90.186% ## ( 3, 4 ] 1749 5.509% 95.694% # ( 4, 6 ] 1112 3.502% 99.197% # ( 6, 10 ] 221 0.696% 99.893% ( 10, 15 ] 18 0.057% 99.950% ( 15, 22 ] 2 0.006% 99.956% ( 22, 34 ] 2 0.006% 99.962% ( 110, 170 ] 1 0.003% 99.965% ( 170, 250 ] 1 0.003% 99.969% ( 250, 380 ] 2 0.006% 99.975% ( 580, 870 ] 3 0.009% 99.984% ( 870, 1300 ] 2 0.006% 99.991% ( 1300, 1900 ] 1 0.003% 99.994% ( 1900, 2900 ] 2 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 16969 Average: 7.1532 StdDev: 106.88 Min: 1 Median: 1.5108 Max: 4850 Percentiles: P50: 1.51 P75: 1.89 P99: 5.91 P99.9: 1985.92 P99.99: 4733.41 ------------------------------------------------------ [ 0, 1 ] 2794 16.465% 16.465% ### ( 1, 2 ] 11140 65.649% 82.114% ############# ( 2, 3 ] 1723 10.154% 92.268% ## ( 3, 4 ] 733 4.320% 96.588% # ( 4, 6 ] 428 2.522% 99.110% # ( 6, 10 ] 86 0.507% 99.617% ( 10, 15 ] 6 0.035% 99.652% ( 15, 22 ] 2 0.012% 99.664% ( 110, 170 ] 1 0.006% 99.670% ( 170, 250 ] 1 0.006% 99.676% ( 250, 380 ] 2 0.012% 99.688% ( 380, 580 ] 8 0.047% 99.735% ( 580, 870 ] 8 0.047% 99.782% ( 870, 1300 ] 11 0.065% 99.847% ( 1300, 1900 ] 8 0.047% 99.894% ( 1900, 2900 ] 12 0.071% 99.965% ( 2900, 4400 ] 4 0.024% 99.988% ( 4400, 6600 ] 2 0.012% 100.000% ** Level 4 read latency histogram (micros): Count: 15 Average: 1680.6667 StdDev: 1212.59 Min: 312 Median: 1228.3333 Max: 4018 Percentiles: P50: 1228.33 P75: 2525.00 P99: 4018.00 P99.9: 4018.00 P99.99: 4018.00 ------------------------------------------------------ ( 250, 380 ] 1 6.667% 6.667% # ( 380, 580 ] 2 13.333% 20.000% ### ( 580, 870 ] 2 13.333% 33.333% ### ( 870, 1300 ] 3 20.000% 53.333% #### ( 1300, 1900 ] 2 13.333% 66.667% ### ( 1900, 2900 ] 2 13.333% 80.000% ### ( 2900, 4400 ] 3 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 20 Average: 572.9500 StdDev: 680.53 Min: 44 Median: 150.0000 Max: 2008 Percentiles: P50: 150.00 P75: 1085.00 P99: 2008.00 P99.9: 2008.00 P99.99: 2008.00 ------------------------------------------------------ ( 34, 51 ] 2 10.000% 10.000% ## ( 51, 76 ] 1 5.000% 15.000% # ( 76, 110 ] 3 15.000% 30.000% ### ( 110, 170 ] 6 30.000% 60.000% ###### ( 380, 580 ] 2 10.000% 70.000% ## ( 870, 1300 ] 2 10.000% 80.000% ## ( 1300, 1900 ] 2 10.000% 90.000% ## ( 1900, 2900 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 6.1 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 322.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:0.621 H:M:S, 10.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.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.412 H:M:S, 13.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/28-07:38:27 ... thread 0: (1000000,3000000) ops and (354803.8,343817.7) ops/second in (2.818459,8.725554) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/11 2.21 GB 6.3 1.8 0.0 1.8 4.6 2.8 0.0 1.7 127.0 317.4 14.88 13.95 48 0.310 1919K 1940 0.0 0.0 L1 1/1 3.22 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 247.6 247.2 2.54 2.47 2 1.272 639K 807 0.0 0.0 L2 2/0 51.58 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.5 2.0 229.3 229.2 0.55 0.53 1 0.549 127K 34 0.0 0.0 L3 41/0 968.18 MB 1.0 0.6 0.5 0.1 0.6 0.5 0.1 1.2 197.4 197.3 3.16 2.72 2 1.579 633K 471 0.0 0.0 L4 148/0 9.75 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1248/12 98.90 GB 0.0 3.2 1.0 2.2 6.0 3.8 1.7 2.2 154.7 288.7 21.13 19.67 53 0.399 3319K 3252 0.0 0.0 Int 0/0 0.00 KB 0.0 3.2 1.0 2.2 6.0 3.8 1.3 2.2 154.7 288.7 21.13 19.67 53 0.399 3319K 3252 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.2 1.0 2.2 3.2 1.0 0.0 0.0 245.9 245.6 13.30 12.63 12 1.108 3319K 3252 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 361.9 7.83 7.04 41 0.191 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): 8.9 total, 8.7 interval Flush(GB): cumulative 2.769, interval 2.769 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.96 GB write, 683.24 MB/s write, 3.19 GB read, 366.14 MB/s read, 21.1 seconds Interval compaction: 5.96 GB write, 699.05 MB/s write, 3.19 GB read, 374.62 MB/s read, 21.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 6, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 6, interval: 6 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 638424 Average: 1.9708 StdDev: 12.16 Min: 1 Median: 1.3342 Max: 4331 Percentiles: P50: 1.33 P75: 1.75 P99: 5.09 P99.9: 9.53 P99.99: 17.49 ------------------------------------------------------ [ 0, 1 ] 189946 29.752% 29.752% ###### ( 1, 2 ] 386806 60.588% 90.340% ############ ( 2, 3 ] 34194 5.356% 95.696% # ( 3, 4 ] 16425 2.573% 98.269% # ( 4, 6 ] 8598 1.347% 99.615% ( 6, 10 ] 2062 0.323% 99.938% ( 10, 15 ] 312 0.049% 99.987% ( 15, 22 ] 51 0.008% 99.995% ( 22, 34 ] 7 0.001% 99.996% ( 34, 51 ] 1 0.000% 99.997% ( 51, 76 ] 4 0.001% 99.997% ( 110, 170 ] 21 0.003% 100.000% ( 170, 250 ] 19 0.003% 100.003% ( 250, 380 ] 16 0.003% 100.006% ( 380, 580 ] 7 0.001% 100.007% ( 580, 870 ] 12 0.002% 100.009% ( 870, 1300 ] 10 0.002% 100.010% ( 1300, 1900 ] 4 0.001% 100.011% ( 1900, 2900 ] 3 0.000% 100.012% ( 2900, 4400 ] 4 0.001% 100.012% ** Level 1 read latency histogram (micros): Count: 146066 Average: 2.1199 StdDev: 5.81 Min: 0 Median: 1.4744 Max: 1159 Percentiles: P50: 1.47 P75: 1.86 P99: 5.51 P99.9: 9.64 P99.99: 26.72 ------------------------------------------------------ [ 0, 1 ] 27601 18.896% 18.896% #### ( 1, 2 ] 95769 65.566% 84.462% ############# ( 2, 3 ] 13599 9.310% 93.772% ## ( 3, 4 ] 5147 3.524% 97.296% # ( 4, 6 ] 3290 2.252% 99.548% ( 6, 10 ] 565 0.387% 99.935% ( 10, 15 ] 68 0.047% 99.982% ( 15, 22 ] 12 0.008% 99.990% ( 22, 34 ] 1 0.001% 99.990% ( 51, 76 ] 2 0.001% 99.992% ( 110, 170 ] 1 0.001% 99.992% ( 250, 380 ] 6 0.004% 99.997% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 1 0.001% 99.998% ( 870, 1300 ] 3 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 31749 Average: 2.5310 StdDev: 22.54 Min: 1 Median: 1.5052 Max: 2282 Percentiles: P50: 1.51 P75: 1.91 P99: 5.89 P99.9: 10.63 P99.99: 1262.40 ------------------------------------------------------ [ 0, 1 ] 5927 18.668% 18.668% #### ( 1, 2 ] 19691 62.021% 80.689% ############ ( 2, 3 ] 3015 9.496% 90.186% ## ( 3, 4 ] 1749 5.509% 95.694% # ( 4, 6 ] 1112 3.502% 99.197% # ( 6, 10 ] 221 0.696% 99.893% ( 10, 15 ] 18 0.057% 99.950% ( 15, 22 ] 2 0.006% 99.956% ( 22, 34 ] 2 0.006% 99.962% ( 110, 170 ] 1 0.003% 99.965% ( 170, 250 ] 1 0.003% 99.969% ( 250, 380 ] 2 0.006% 99.975% ( 580, 870 ] 3 0.009% 99.984% ( 870, 1300 ] 2 0.006% 99.991% ( 1300, 1900 ] 1 0.003% 99.994% ( 1900, 2900 ] 2 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 28906 Average: 5.2333 StdDev: 82.21 Min: 0 Median: 1.5094 Max: 4850 Percentiles: P50: 1.51 P75: 1.89 P99: 5.91 P99.9: 1186.40 P99.99: 4066.02 ------------------------------------------------------ [ 0, 1 ] 4719 16.325% 16.325% ### ( 1, 2 ] 19108 66.104% 82.429% ############# ( 2, 3 ] 2931 10.140% 92.569% ## ( 3, 4 ] 1188 4.110% 96.679% # ( 4, 6 ] 701 2.425% 99.104% ( 6, 10 ] 124 0.429% 99.533% ( 10, 15 ] 11 0.038% 99.571% ( 15, 22 ] 4 0.014% 99.585% ( 22, 34 ] 45 0.156% 99.741% ( 34, 51 ] 9 0.031% 99.772% ( 110, 170 ] 2 0.007% 99.779% ( 170, 250 ] 4 0.014% 99.792% ( 250, 380 ] 3 0.010% 99.803% ( 380, 580 ] 11 0.038% 99.841% ( 580, 870 ] 9 0.031% 99.872% ( 870, 1300 ] 11 0.038% 99.910% ( 1300, 1900 ] 8 0.028% 99.938% ( 1900, 2900 ] 12 0.042% 99.979% ( 2900, 4400 ] 4 0.014% 99.993% ( 4400, 6600 ] 2 0.007% 100.000% ** Level 4 read latency histogram (micros): Count: 15 Average: 1680.6667 StdDev: 1212.59 Min: 312 Median: 1228.3333 Max: 4018 Percentiles: P50: 1228.33 P75: 2525.00 P99: 4018.00 P99.9: 4018.00 P99.99: 4018.00 ------------------------------------------------------ ( 250, 380 ] 1 6.667% 6.667% # ( 380, 580 ] 2 13.333% 20.000% ### ( 580, 870 ] 2 13.333% 33.333% ### ( 870, 1300 ] 3 20.000% 53.333% #### ( 1300, 1900 ] 2 13.333% 66.667% ### ( 1900, 2900 ] 2 13.333% 80.000% ### ( 2900, 4400 ] 3 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 20 Average: 572.9500 StdDev: 680.53 Min: 44 Median: 150.0000 Max: 2008 Percentiles: P50: 150.00 P75: 1085.00 P99: 2008.00 P99.9: 2008.00 P99.99: 2008.00 ------------------------------------------------------ ( 34, 51 ] 2 10.000% 10.000% ## ( 51, 76 ] 1 5.000% 15.000% # ( 76, 110 ] 3 15.000% 30.000% ### ( 110, 170 ] 6 30.000% 60.000% ###### ( 380, 580 ] 2 10.000% 70.000% ## ( 870, 1300 ] 2 10.000% 80.000% ## ( 1300, 1900 ] 2 10.000% 90.000% ## ( 1900, 2900 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 8.9 total, 2.8 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 330.64 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.810 H:M:S, 9.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 349.19 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.189 H:M:S, 6.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/28-07:38:31 ... thread 0: (1000000,4000000) ops and (270552.8,322017.4) ops/second in (3.696136,12.421690) 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/15 3.26 GB 88.1 2.7 0.0 2.7 6.5 3.8 0.0 1.7 130.8 315.0 21.19 19.86 66 0.321 2814K 2903 0.0 0.0 L1 1/1 3.22 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 247.6 247.2 2.54 2.47 2 1.272 639K 807 0.0 0.0 L2 2/0 51.58 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.5 2.0 229.3 229.2 0.55 0.53 1 0.549 127K 34 0.0 0.0 L3 41/0 968.18 MB 1.0 0.6 0.5 0.1 0.6 0.5 0.1 1.2 197.4 197.3 3.16 2.72 2 1.579 633K 471 0.0 0.0 L4 148/0 9.75 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1254/16 99.95 GB 0.0 4.1 1.0 3.1 7.9 4.8 1.7 2.1 151.3 293.4 27.44 25.58 71 0.387 4215K 4215 0.0 0.0 Int 0/0 0.00 KB 0.0 4.1 1.0 3.1 7.9 4.8 1.3 2.1 151.3 293.4 27.44 25.58 71 0.387 4215K 4215 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.1 1.0 3.1 4.0 1.0 0.0 0.0 250.4 250.1 16.58 15.85 15 1.105 4215K 4215 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 359.5 10.87 9.73 56 0.194 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.6 total, 12.4 interval Flush(GB): cumulative 3.814, interval 3.814 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.86 GB write, 637.82 MB/s write, 4.05 GB read, 328.81 MB/s read, 27.4 seconds Interval compaction: 7.86 GB write, 648.19 MB/s write, 4.05 GB read, 334.16 MB/s read, 27.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 3, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 3, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 10, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 10, interval: 13 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1102749 Average: 2.0229 StdDev: 11.49 Min: 1 Median: 1.3801 Max: 4331 Percentiles: P50: 1.38 P75: 1.78 P99: 5.18 P99.9: 9.51 P99.99: 14.45 ------------------------------------------------------ [ 0, 1 ] 286550 25.985% 25.985% ##### ( 1, 2 ] 696724 63.181% 89.166% ############# ( 2, 3 ] 67340 6.107% 95.272% # ( 3, 4 ] 31817 2.885% 98.158% # ( 4, 6 ] 15796 1.432% 99.590% ( 6, 10 ] 3895 0.353% 99.943% ( 10, 15 ] 580 0.053% 99.996% ( 15, 22 ] 81 0.007% 100.003% ( 22, 34 ] 11 0.001% 100.004% ( 34, 51 ] 4 0.000% 100.004% ( 51, 76 ] 10 0.001% 100.005% ( 76, 110 ] 11 0.001% 100.006% ( 110, 170 ] 59 0.005% 100.012% ( 170, 250 ] 41 0.004% 100.015% ( 250, 380 ] 24 0.002% 100.018% ( 380, 580 ] 18 0.002% 100.019% ( 580, 870 ] 19 0.002% 100.021% ( 870, 1300 ] 13 0.001% 100.022% ( 1300, 1900 ] 6 0.001% 100.023% ( 1900, 2900 ] 4 0.000% 100.023% ( 2900, 4400 ] 6 0.001% 100.024% ** Level 1 read latency histogram (micros): Count: 146066 Average: 2.1199 StdDev: 5.81 Min: 0 Median: 1.4744 Max: 1159 Percentiles: P50: 1.47 P75: 1.86 P99: 5.51 P99.9: 9.64 P99.99: 26.72 ------------------------------------------------------ [ 0, 1 ] 27601 18.896% 18.896% #### ( 1, 2 ] 95769 65.566% 84.462% ############# ( 2, 3 ] 13599 9.310% 93.772% ## ( 3, 4 ] 5147 3.524% 97.296% # ( 4, 6 ] 3290 2.252% 99.548% ( 6, 10 ] 565 0.387% 99.935% ( 10, 15 ] 68 0.047% 99.982% ( 15, 22 ] 12 0.008% 99.990% ( 22, 34 ] 1 0.001% 99.990% ( 51, 76 ] 2 0.001% 99.992% ( 110, 170 ] 1 0.001% 99.992% ( 250, 380 ] 6 0.004% 99.997% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 1 0.001% 99.998% ( 870, 1300 ] 3 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 31749 Average: 2.5310 StdDev: 22.54 Min: 1 Median: 1.5052 Max: 2282 Percentiles: P50: 1.51 P75: 1.91 P99: 5.89 P99.9: 10.63 P99.99: 1262.40 ------------------------------------------------------ [ 0, 1 ] 5927 18.668% 18.668% #### ( 1, 2 ] 19691 62.021% 80.689% ############ ( 2, 3 ] 3015 9.496% 90.186% ## ( 3, 4 ] 1749 5.509% 95.694% # ( 4, 6 ] 1112 3.502% 99.197% # ( 6, 10 ] 221 0.696% 99.893% ( 10, 15 ] 18 0.057% 99.950% ( 15, 22 ] 2 0.006% 99.956% ( 22, 34 ] 2 0.006% 99.962% ( 110, 170 ] 1 0.003% 99.965% ( 170, 250 ] 1 0.003% 99.969% ( 250, 380 ] 2 0.006% 99.975% ( 580, 870 ] 3 0.009% 99.984% ( 870, 1300 ] 2 0.006% 99.991% ( 1300, 1900 ] 1 0.003% 99.994% ( 1900, 2900 ] 2 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 28906 Average: 5.2333 StdDev: 82.21 Min: 0 Median: 1.5094 Max: 4850 Percentiles: P50: 1.51 P75: 1.89 P99: 5.91 P99.9: 1186.40 P99.99: 4066.02 ------------------------------------------------------ [ 0, 1 ] 4719 16.325% 16.325% ### ( 1, 2 ] 19108 66.104% 82.429% ############# ( 2, 3 ] 2931 10.140% 92.569% ## ( 3, 4 ] 1188 4.110% 96.679% # ( 4, 6 ] 701 2.425% 99.104% ( 6, 10 ] 124 0.429% 99.533% ( 10, 15 ] 11 0.038% 99.571% ( 15, 22 ] 4 0.014% 99.585% ( 22, 34 ] 45 0.156% 99.741% ( 34, 51 ] 9 0.031% 99.772% ( 110, 170 ] 2 0.007% 99.779% ( 170, 250 ] 4 0.014% 99.792% ( 250, 380 ] 3 0.010% 99.803% ( 380, 580 ] 11 0.038% 99.841% ( 580, 870 ] 9 0.031% 99.872% ( 870, 1300 ] 11 0.038% 99.910% ( 1300, 1900 ] 8 0.028% 99.938% ( 1900, 2900 ] 12 0.042% 99.979% ( 2900, 4400 ] 4 0.014% 99.993% ( 4400, 6600 ] 2 0.007% 100.000% ** Level 4 read latency histogram (micros): Count: 15 Average: 1680.6667 StdDev: 1212.59 Min: 312 Median: 1228.3333 Max: 4018 Percentiles: P50: 1228.33 P75: 2525.00 P99: 4018.00 P99.9: 4018.00 P99.99: 4018.00 ------------------------------------------------------ ( 250, 380 ] 1 6.667% 6.667% # ( 380, 580 ] 2 13.333% 20.000% ### ( 580, 870 ] 2 13.333% 33.333% ### ( 870, 1300 ] 3 20.000% 53.333% #### ( 1300, 1900 ] 2 13.333% 66.667% ### ( 1900, 2900 ] 2 13.333% 80.000% ### ( 2900, 4400 ] 3 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 20 Average: 572.9500 StdDev: 680.53 Min: 44 Median: 150.0000 Max: 2008 Percentiles: P50: 150.00 P75: 1085.00 P99: 2008.00 P99.9: 2008.00 P99.99: 2008.00 ------------------------------------------------------ ( 34, 51 ] 2 10.000% 10.000% ## ( 51, 76 ] 1 5.000% 15.000% # ( 76, 110 ] 3 15.000% 30.000% ### ( 110, 170 ] 6 30.000% 60.000% ###### ( 380, 580 ] 2 10.000% 70.000% ## ( 870, 1300 ] 2 10.000% 80.000% ## ( 1300, 1900 ] 2 10.000% 90.000% ## ( 1900, 2900 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 12.6 total, 3.7 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 311.80 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.815 H:M:S, 14.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 266.28 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.004 H:M:S, 27.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 0 2024/11/28-07:38:37 ... thread 0: (1000000,5000000) ops and (161843.7,268810.1) ops/second in (6.178802,18.600492) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/8 1.97 GB 94.4 3.4 0.0 3.4 8.1 4.7 0.0 1.7 132.5 312.2 26.62 24.85 83 0.321 3582K 3615 0.0 0.0 L1 6/0 638.48 MB 63.8 2.8 2.6 0.2 2.7 2.6 0.1 1.1 237.1 235.2 11.96 11.57 3 3.986 2879K 22K 0.0 0.0 L2 6/4 566.68 MB 2.6 0.1 0.1 0.1 0.1 0.1 2.0 2.0 229.3 229.2 0.55 0.53 1 0.549 127K 34 0.0 0.0 L3 33/26 1.81 GB 0.9 0.6 0.5 0.1 0.6 0.5 1.1 1.2 197.4 197.3 3.16 2.72 2 1.579 633K 471 0.0 0.0 L4 160/4 9.58 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1265/42 100.79 GB 0.0 6.9 3.1 3.8 11.6 7.8 4.6 2.5 168.2 280.8 42.29 39.67 89 0.475 7223K 26K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.9 3.1 3.8 11.6 7.8 4.2 2.5 168.2 280.8 42.29 39.67 89 0.475 7223K 26K 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.9 3.1 3.8 6.9 3.1 0.0 0.0 247.3 246.3 28.77 27.69 19 1.514 7223K 26K 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 354.1 13.52 11.98 70 0.193 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 18.8 total, 18.6 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.60 GB write, 631.45 MB/s write, 6.95 GB read, 378.30 MB/s read, 42.3 seconds Interval compaction: 11.60 GB write, 638.30 MB/s write, 6.95 GB read, 382.40 MB/s read, 42.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 10, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 10, total-stops: 10, interval: 20 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1821623 Average: 2.0797 StdDev: 10.64 Min: 1 Median: 1.4019 Max: 4331 Percentiles: P50: 1.40 P75: 1.79 P99: 5.47 P99.9: 9.78 P99.99: 21.10 ------------------------------------------------------ [ 0, 1 ] 441725 24.249% 24.249% ##### ( 1, 2 ] 1167162 64.073% 88.322% ############# ( 2, 3 ] 115927 6.364% 94.686% # ( 3, 4 ] 56611 3.108% 97.793% # ( 4, 6 ] 29886 1.641% 99.434% ( 6, 10 ] 8996 0.494% 99.928% ( 10, 15 ] 1019 0.056% 99.984% ( 15, 22 ] 134 0.007% 99.991% ( 22, 34 ] 19 0.001% 99.992% ( 34, 51 ] 6 0.000% 99.992% ( 51, 76 ] 14 0.001% 99.993% ( 76, 110 ] 116 0.006% 100.000% ( 110, 170 ] 189 0.010% 100.010% ( 170, 250 ] 81 0.004% 100.014% ( 250, 380 ] 66 0.004% 100.018% ( 380, 580 ] 50 0.003% 100.021% ( 580, 870 ] 45 0.002% 100.023% ( 870, 1300 ] 17 0.001% 100.024% ( 1300, 1900 ] 8 0.000% 100.025% ( 1900, 2900 ] 8 0.000% 100.025% ( 2900, 4400 ] 6 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 226666 Average: 2.6461 StdDev: 15.69 Min: 0 Median: 1.5915 Max: 3053 Percentiles: P50: 1.59 P75: 2.00 P99: 6.11 P99.9: 13.33 P99.99: 155.12 ------------------------------------------------------ [ 0, 1 ] 31169 13.751% 13.751% ### ( 1, 2 ] 138900 61.280% 75.031% ############ ( 2, 3 ] 29150 12.860% 87.891% ### ( 3, 4 ] 13643 6.019% 93.910% # ( 4, 6 ] 11488 5.068% 98.978% # ( 6, 10 ] 1896 0.836% 99.815% ( 10, 15 ] 292 0.129% 99.944% ( 15, 22 ] 32 0.014% 99.958% ( 22, 34 ] 4 0.002% 99.959% ( 51, 76 ] 7 0.003% 99.962% ( 76, 110 ] 31 0.014% 99.976% ( 110, 170 ] 43 0.019% 99.995% ( 170, 250 ] 24 0.011% 100.006% ( 250, 380 ] 27 0.012% 100.018% ( 380, 580 ] 18 0.008% 100.026% ( 580, 870 ] 13 0.006% 100.031% ( 870, 1300 ] 22 0.010% 100.041% ( 1300, 1900 ] 2 0.001% 100.042% ( 2900, 4400 ] 1 0.000% 100.042% ** Level 2 read latency histogram (micros): Count: 31791 Average: 3.5489 StdDev: 47.46 Min: 1 Median: 1.5062 Max: 3383 Percentiles: P50: 1.51 P75: 1.91 P99: 5.96 P99.9: 365.31 P99.99: 2664.18 ------------------------------------------------------ [ 0, 1 ] 5927 18.644% 18.644% #### ( 1, 2 ] 19691 61.939% 80.583% ############ ( 2, 3 ] 3015 9.484% 90.066% ## ( 3, 4 ] 1749 5.502% 95.568% # ( 4, 6 ] 1112 3.498% 99.066% # ( 6, 10 ] 221 0.695% 99.761% ( 10, 15 ] 18 0.057% 99.818% ( 15, 22 ] 2 0.006% 99.824% ( 22, 34 ] 2 0.006% 99.830% ( 110, 170 ] 7 0.022% 99.852% ( 170, 250 ] 9 0.028% 99.880% ( 250, 380 ] 7 0.022% 99.902% ( 380, 580 ] 7 0.022% 99.925% ( 580, 870 ] 9 0.028% 99.953% ( 870, 1300 ] 4 0.013% 99.965% ( 1300, 1900 ] 4 0.013% 99.978% ( 1900, 2900 ] 5 0.016% 99.994% ( 2900, 4400 ] 2 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 80818 Average: 11.5343 StdDev: 119.00 Min: 0 Median: 1.6719 Max: 4931 Percentiles: P50: 1.67 P75: 2.44 P99: 169.62 P99.9: 1578.18 P99.99: 2595.73 ------------------------------------------------------ [ 0, 1 ] 8917 11.033% 11.033% ## ( 1, 2 ] 46870 57.995% 69.028% ############ ( 2, 3 ] 10939 13.535% 82.563% ### ( 3, 4 ] 6550 8.105% 90.668% ## ( 4, 6 ] 4770 5.902% 96.570% # ( 6, 10 ] 1305 1.615% 98.185% ( 10, 15 ] 285 0.353% 98.537% ( 15, 22 ] 37 0.046% 98.583% ( 22, 34 ] 46 0.057% 98.640% ( 34, 51 ] 12 0.015% 98.655% ( 51, 76 ] 3 0.004% 98.659% ( 76, 110 ] 91 0.113% 98.771% ( 110, 170 ] 186 0.230% 99.001% ( 170, 250 ] 135 0.167% 99.169% ( 250, 380 ] 154 0.191% 99.359% ( 380, 580 ] 224 0.277% 99.636% ( 580, 870 ] 115 0.142% 99.779% ( 870, 1300 ] 75 0.093% 99.871% ( 1300, 1900 ] 50 0.062% 99.933% ( 1900, 2900 ] 66 0.082% 100.015% ( 2900, 4400 ] 29 0.036% 100.051% ( 4400, 6600 ] 4 0.005% 100.056% ** Level 4 read latency histogram (micros): Count: 15 Average: 1680.6667 StdDev: 1212.59 Min: 312 Median: 1228.3333 Max: 4018 Percentiles: P50: 1228.33 P75: 2525.00 P99: 4018.00 P99.9: 4018.00 P99.99: 4018.00 ------------------------------------------------------ ( 250, 380 ] 1 6.667% 6.667% # ( 380, 580 ] 2 13.333% 20.000% ### ( 580, 870 ] 2 13.333% 33.333% ### ( 870, 1300 ] 3 20.000% 53.333% #### ( 1300, 1900 ] 2 13.333% 66.667% ### ( 1900, 2900 ] 2 13.333% 80.000% ### ( 2900, 4400 ] 3 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 40 Average: 913.6250 StdDev: 1134.78 Min: 44 Median: 380.0000 Max: 4268 Percentiles: P50: 380.00 P75: 1300.00 P99: 4250.00 P99.9: 4268.00 P99.99: 4268.00 ------------------------------------------------------ ( 34, 51 ] 2 5.000% 5.000% # ( 51, 76 ] 1 2.500% 7.500% # ( 76, 110 ] 3 7.500% 15.000% ## ( 110, 170 ] 6 15.000% 30.000% ### ( 170, 250 ] 2 5.000% 35.000% # ( 250, 380 ] 6 15.000% 50.000% ### ( 380, 580 ] 5 12.500% 62.500% ### ( 580, 870 ] 2 5.000% 67.500% # ( 870, 1300 ] 3 7.500% 75.000% ## ( 1300, 1900 ] 3 7.500% 82.500% ## ( 1900, 2900 ] 3 7.500% 90.000% ## ( 2900, 4400 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 18.8 total, 6.2 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 261.66 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:5.112 H:M:S, 27.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 159.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:3.297 H:M:S, 53.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 7 num-running-flushes: 1 2024/11/28-07:38:41 ... thread 0: (1000000,6000000) ops and (280170.3,270639.0) ops/second in (3.569258,22.169750) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/11 2.95 GB 63.0 4.7 0.0 4.7 10.4 5.7 0.0 1.8 139.3 305.6 34.81 32.34 99 0.352 4924K 6537 0.0 0.0 L1 6/6 638.48 MB 0.0 2.8 2.6 0.2 2.7 2.6 0.1 1.1 237.1 235.2 11.96 11.57 3 3.986 2879K 22K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 2.0 2.0 229.3 229.2 0.55 0.53 1 0.549 127K 34 0.0 0.0 L3 15/0 947.88 MB 0.9 2.1 1.1 1.0 2.1 1.1 1.1 2.0 194.1 193.8 10.95 8.96 8 1.369 2086K 1534 0.0 0.0 L4 169/0 9.73 GB 1.0 0.7 0.6 0.1 0.7 0.6 1.6 1.2 171.2 170.5 4.16 3.26 7 0.595 723K 2602 0.0 0.0 L5 1064/0 87.54 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1270/17 101.76 GB 0.0 10.4 4.3 6.1 16.0 9.9 6.8 2.8 170.6 262.8 62.44 56.66 118 0.529 10M 33K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.4 4.3 6.1 16.0 9.9 6.4 2.8 170.6 262.8 62.44 56.66 118 0.529 10M 33K 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.4 4.3 6.1 10.4 4.2 0.0 0.0 232.8 232.1 45.74 42.10 35 1.307 10M 33K 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.1 16.70 14.56 83 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): 22.4 total, 22.2 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 16.03 GB write, 733.47 MB/s write, 10.40 GB read, 476.01 MB/s read, 62.4 seconds Interval compaction: 16.03 GB write, 740.15 MB/s write, 10.40 GB read, 480.34 MB/s read, 62.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 23, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 10, total-stops: 23, interval: 33 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2155888 Average: 2.1642 StdDev: 12.41 Min: 1 Median: 1.4315 Max: 5497 Percentiles: P50: 1.43 P75: 1.82 P99: 5.69 P99.9: 9.92 P99.99: 86.01 ------------------------------------------------------ [ 0, 1 ] 483183 22.412% 22.412% #### ( 1, 2 ] 1378202 63.927% 86.340% ############# ( 2, 3 ] 156450 7.257% 93.596% # ( 3, 4 ] 77593 3.599% 97.196% # ( 4, 6 ] 46148 2.141% 99.336% ( 6, 10 ] 12402 0.575% 99.911% ( 10, 15 ] 1416 0.066% 99.977% ( 15, 22 ] 182 0.008% 99.986% ( 22, 34 ] 21 0.001% 99.987% ( 34, 51 ] 10 0.000% 99.987% ( 51, 76 ] 20 0.001% 99.988% ( 76, 110 ] 161 0.007% 99.995% ( 110, 170 ] 258 0.012% 100.007% ( 170, 250 ] 126 0.006% 100.013% ( 250, 380 ] 95 0.004% 100.018% ( 380, 580 ] 75 0.003% 100.021% ( 580, 870 ] 56 0.003% 100.024% ( 870, 1300 ] 24 0.001% 100.025% ( 1300, 1900 ] 12 0.001% 100.025% ( 1900, 2900 ] 12 0.001% 100.026% ( 2900, 4400 ] 9 0.000% 100.026% ( 4400, 6600 ] 1 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 355666 Average: 2.9358 StdDev: 28.33 Min: 0 Median: 1.6582 Max: 5496 Percentiles: P50: 1.66 P75: 2.30 P99: 7.37 P99.9: 14.07 P99.99: 179.45 ------------------------------------------------------ [ 0, 1 ] 37005 10.404% 10.404% ## ( 1, 2 ] 213975 60.162% 70.566% ############ ( 2, 3 ] 52845 14.858% 85.424% ### ( 3, 4 ] 24776 6.966% 92.390% # ( 4, 6 ] 22121 6.220% 98.610% # ( 6, 10 ] 4057 1.141% 99.751% ( 10, 15 ] 653 0.184% 99.934% ( 15, 22 ] 77 0.022% 99.956% ( 22, 34 ] 5 0.001% 99.957% ( 34, 51 ] 1 0.000% 99.958% ( 51, 76 ] 8 0.002% 99.960% ( 76, 110 ] 40 0.011% 99.971% ( 110, 170 ] 62 0.017% 99.988% ( 170, 250 ] 46 0.013% 100.001% ( 250, 380 ] 43 0.012% 100.013% ( 380, 580 ] 32 0.009% 100.022% ( 580, 870 ] 25 0.007% 100.030% ( 870, 1300 ] 27 0.008% 100.037% ( 1300, 1900 ] 5 0.001% 100.039% ( 1900, 2900 ] 7 0.002% 100.040% ( 2900, 4400 ] 10 0.003% 100.043% ( 4400, 6600 ] 1 0.000% 100.044% ** Level 2 read latency histogram (micros): Count: 60336 Average: 3.4565 StdDev: 38.11 Min: 1 Median: 1.4841 Max: 3383 Percentiles: P50: 1.48 P75: 1.88 P99: 7.97 P99.9: 377.70 P99.99: 2093.28 ------------------------------------------------------ [ 0, 1 ] 11825 19.599% 19.599% #### ( 1, 2 ] 37891 62.800% 82.399% ############# ( 2, 3 ] 5146 8.529% 90.927% ## ( 3, 4 ] 2861 4.742% 95.669% # ( 4, 6 ] 1671 2.769% 98.439% # ( 6, 10 ] 687 1.139% 99.577% ( 10, 15 ] 46 0.076% 99.654% ( 15, 22 ] 3 0.005% 99.659% ( 22, 34 ] 2 0.003% 99.662% ( 76, 110 ] 38 0.063% 99.725% ( 110, 170 ] 64 0.106% 99.831% ( 170, 250 ] 23 0.038% 99.869% ( 250, 380 ] 19 0.031% 99.901% ( 380, 580 ] 24 0.040% 99.940% ( 580, 870 ] 17 0.028% 99.969% ( 870, 1300 ] 7 0.012% 99.980% ( 1300, 1900 ] 5 0.008% 99.988% ( 1900, 2900 ] 5 0.008% 99.997% ( 2900, 4400 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 352827 Average: 6.7048 StdDev: 74.94 Min: 0 Median: 1.7280 Max: 4931 Percentiles: P50: 1.73 P75: 2.60 P99: 9.93 P99.9: 556.62 P99.99: 831.45 ------------------------------------------------------ [ 0, 1 ] 28679 8.128% 8.128% ## ( 1, 2 ] 202934 57.517% 65.645% ############ ( 2, 3 ] 54681 15.498% 81.143% ### ( 3, 4 ] 31123 8.821% 89.964% ## ( 4, 6 ] 25846 7.325% 97.289% # ( 6, 10 ] 6141 1.741% 99.030% ( 10, 15 ] 1033 0.293% 99.323% ( 15, 22 ] 106 0.030% 99.353% ( 22, 34 ] 58 0.016% 99.369% ( 34, 51 ] 17 0.005% 99.374% ( 51, 76 ] 5 0.001% 99.375% ( 76, 110 ] 205 0.058% 99.433% ( 110, 170 ] 461 0.131% 99.564% ( 170, 250 ] 396 0.112% 99.676% ( 250, 380 ] 375 0.106% 99.783% ( 380, 580 ] 469 0.133% 99.916% ( 580, 870 ] 303 0.086% 100.001% ( 870, 1300 ] 156 0.044% 100.046% ( 1300, 1900 ] 85 0.024% 100.070% ( 1900, 2900 ] 102 0.029% 100.099% ( 2900, 4400 ] 52 0.015% 100.113% ( 4400, 6600 ] 4 0.001% 100.115% ** Level 4 read latency histogram (micros): Count: 130 Average: 278.7231 StdDev: 691.13 Min: 1 Median: 2.5833 Max: 4018 Percentiles: P50: 2.58 P75: 156.00 P99: 3750.00 P99.9: 4018.00 P99.99: 4018.00 ------------------------------------------------------ [ 0, 1 ] 26 20.000% 20.000% #### ( 1, 2 ] 32 24.615% 44.615% ##### ( 2, 3 ] 12 9.231% 53.846% ## ( 3, 4 ] 4 3.077% 56.923% # ( 4, 6 ] 4 3.077% 60.000% # ( 6, 10 ] 3 2.308% 62.308% ( 15, 22 ] 1 0.769% 63.077% ( 22, 34 ] 1 0.769% 63.846% ( 34, 51 ] 3 2.308% 66.154% ( 110, 170 ] 15 11.538% 77.692% ## ( 170, 250 ] 3 2.308% 80.000% ( 250, 380 ] 3 2.308% 82.308% ( 380, 580 ] 4 3.077% 85.385% # ( 580, 870 ] 6 4.615% 90.000% # ( 870, 1300 ] 5 3.846% 93.846% # ( 1300, 1900 ] 3 2.308% 96.154% ( 1900, 2900 ] 2 1.538% 97.692% ( 2900, 4400 ] 3 2.308% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 1046.4417 StdDev: 1243.58 Min: 44 Median: 503.0769 Max: 5521 Percentiles: P50: 503.08 P75: 1375.00 P99: 5521.00 P99.9: 5521.00 P99.99: 5521.00 ------------------------------------------------------ ( 34, 51 ] 2 1.667% 1.667% ( 51, 76 ] 1 0.833% 2.500% ( 76, 110 ] 9 7.500% 10.000% ## ( 110, 170 ] 12 10.000% 20.000% ## ( 170, 250 ] 8 6.667% 26.667% # ( 250, 380 ] 20 16.667% 43.333% ### ( 380, 580 ] 13 10.833% 54.167% ## ( 580, 870 ] 13 10.833% 65.000% ## ( 870, 1300 ] 11 9.167% 74.167% ## ( 1300, 1900 ] 8 6.667% 80.833% # ( 1900, 2900 ] 9 7.500% 88.333% ## ( 2900, 4400 ] 11 9.167% 97.500% ## ( 4400, 6600 ] 3 2.500% 100.000% # ** DB Stats ** Uptime(secs): 22.4 total, 3.6 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 263.93 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:5.862 H:M:S, 26.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 275.90 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.750 H:M:S, 21.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/28-07:38:44 ... thread 0: (1000000,7000000) ops and (306141.4,275198.2) ops/second in (3.266464,25.436214) 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/11 3.93 GB 157.3 5.8 0.0 5.8 12.5 6.6 0.0 1.9 142.6 304.5 41.97 39.10 117 0.359 6076K 7787 0.0 0.0 L1 6/6 638.48 MB 0.0 2.8 2.6 0.2 2.7 2.6 0.1 1.1 237.1 235.2 11.96 11.57 3 3.986 2879K 22K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 2.0 2.0 229.3 229.2 0.55 0.53 1 0.549 127K 34 0.0 0.0 L3 15/0 947.88 MB 0.9 2.1 1.1 1.0 2.1 1.1 1.1 2.0 194.1 193.8 10.95 8.96 8 1.369 2086K 1534 0.0 0.0 L4 169/0 9.73 GB 1.0 0.7 0.6 0.1 0.7 0.6 1.6 1.2 171.2 170.5 4.16 3.26 7 0.595 723K 2602 0.0 0.0 L5 1064/0 87.54 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1272/17 102.75 GB 0.0 11.5 4.3 7.2 18.1 10.9 6.8 2.7 169.3 266.6 69.59 63.42 136 0.512 11M 34K 0.0 0.0 Int 0/0 0.00 KB 0.0 11.5 4.3 7.2 18.1 10.9 6.4 2.7 169.3 266.6 69.59 63.42 136 0.512 11M 34K 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 11.5 4.3 7.2 11.5 4.2 0.0 0.0 235.7 234.9 50.01 46.29 39 1.282 11M 34K 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 347.4 19.58 17.13 97 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): 25.6 total, 25.4 interval Flush(GB): cumulative 6.644, interval 6.644 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 18.12 GB write, 723.52 MB/s write, 11.51 GB read, 459.59 MB/s read, 69.6 seconds Interval compaction: 18.12 GB write, 729.26 MB/s write, 11.51 GB read, 463.24 MB/s read, 69.6 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: 28, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 28, interval: 39 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2600305 Average: 2.1802 StdDev: 12.12 Min: 1 Median: 1.4393 Max: 5497 Percentiles: P50: 1.44 P75: 1.83 P99: 5.72 P99.9: 9.93 P99.99: 89.76 ------------------------------------------------------ [ 0, 1 ] 563085 21.655% 21.655% #### ( 1, 2 ] 1677951 64.529% 86.184% ############# ( 2, 3 ] 192907 7.419% 93.602% # ( 3, 4 ] 93489 3.595% 97.198% # ( 4, 6 ] 54604 2.100% 99.297% ( 6, 10 ] 15963 0.614% 99.911% ( 10, 15 ] 1691 0.065% 99.976% ( 15, 22 ] 198 0.008% 99.984% ( 22, 34 ] 23 0.001% 99.985% ( 34, 51 ] 12 0.000% 99.985% ( 51, 76 ] 20 0.001% 99.986% ( 76, 110 ] 252 0.010% 99.996% ( 110, 170 ] 358 0.014% 100.010% ( 170, 250 ] 170 0.007% 100.016% ( 250, 380 ] 129 0.005% 100.021% ( 380, 580 ] 99 0.004% 100.025% ( 580, 870 ] 67 0.003% 100.027% ( 870, 1300 ] 34 0.001% 100.029% ( 1300, 1900 ] 12 0.000% 100.029% ( 1900, 2900 ] 13 0.000% 100.030% ( 2900, 4400 ] 10 0.000% 100.030% ( 4400, 6600 ] 1 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 355666 Average: 2.9358 StdDev: 28.33 Min: 0 Median: 1.6582 Max: 5496 Percentiles: P50: 1.66 P75: 2.30 P99: 7.37 P99.9: 14.07 P99.99: 179.45 ------------------------------------------------------ [ 0, 1 ] 37005 10.404% 10.404% ## ( 1, 2 ] 213975 60.162% 70.566% ############ ( 2, 3 ] 52845 14.858% 85.424% ### ( 3, 4 ] 24776 6.966% 92.390% # ( 4, 6 ] 22121 6.220% 98.610% # ( 6, 10 ] 4057 1.141% 99.751% ( 10, 15 ] 653 0.184% 99.934% ( 15, 22 ] 77 0.022% 99.956% ( 22, 34 ] 5 0.001% 99.957% ( 34, 51 ] 1 0.000% 99.958% ( 51, 76 ] 8 0.002% 99.960% ( 76, 110 ] 40 0.011% 99.971% ( 110, 170 ] 62 0.017% 99.988% ( 170, 250 ] 46 0.013% 100.001% ( 250, 380 ] 43 0.012% 100.013% ( 380, 580 ] 32 0.009% 100.022% ( 580, 870 ] 25 0.007% 100.030% ( 870, 1300 ] 27 0.008% 100.037% ( 1300, 1900 ] 5 0.001% 100.039% ( 1900, 2900 ] 7 0.002% 100.040% ( 2900, 4400 ] 10 0.003% 100.043% ( 4400, 6600 ] 1 0.000% 100.044% ** Level 2 read latency histogram (micros): Count: 60336 Average: 3.4565 StdDev: 38.11 Min: 1 Median: 1.4841 Max: 3383 Percentiles: P50: 1.48 P75: 1.88 P99: 7.97 P99.9: 377.70 P99.99: 2093.28 ------------------------------------------------------ [ 0, 1 ] 11825 19.599% 19.599% #### ( 1, 2 ] 37891 62.800% 82.399% ############# ( 2, 3 ] 5146 8.529% 90.927% ## ( 3, 4 ] 2861 4.742% 95.669% # ( 4, 6 ] 1671 2.769% 98.439% # ( 6, 10 ] 687 1.139% 99.577% ( 10, 15 ] 46 0.076% 99.654% ( 15, 22 ] 3 0.005% 99.659% ( 22, 34 ] 2 0.003% 99.662% ( 76, 110 ] 38 0.063% 99.725% ( 110, 170 ] 64 0.106% 99.831% ( 170, 250 ] 23 0.038% 99.869% ( 250, 380 ] 19 0.031% 99.901% ( 380, 580 ] 24 0.040% 99.940% ( 580, 870 ] 17 0.028% 99.969% ( 870, 1300 ] 7 0.012% 99.980% ( 1300, 1900 ] 5 0.008% 99.988% ( 1900, 2900 ] 5 0.008% 99.997% ( 2900, 4400 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 352827 Average: 6.7048 StdDev: 74.94 Min: 0 Median: 1.7280 Max: 4931 Percentiles: P50: 1.73 P75: 2.60 P99: 9.93 P99.9: 556.62 P99.99: 831.45 ------------------------------------------------------ [ 0, 1 ] 28679 8.128% 8.128% ## ( 1, 2 ] 202934 57.517% 65.645% ############ ( 2, 3 ] 54681 15.498% 81.143% ### ( 3, 4 ] 31123 8.821% 89.964% ## ( 4, 6 ] 25846 7.325% 97.289% # ( 6, 10 ] 6141 1.741% 99.030% ( 10, 15 ] 1033 0.293% 99.323% ( 15, 22 ] 106 0.030% 99.353% ( 22, 34 ] 58 0.016% 99.369% ( 34, 51 ] 17 0.005% 99.374% ( 51, 76 ] 5 0.001% 99.375% ( 76, 110 ] 205 0.058% 99.433% ( 110, 170 ] 461 0.131% 99.564% ( 170, 250 ] 396 0.112% 99.676% ( 250, 380 ] 375 0.106% 99.783% ( 380, 580 ] 469 0.133% 99.916% ( 580, 870 ] 303 0.086% 100.001% ( 870, 1300 ] 156 0.044% 100.046% ( 1300, 1900 ] 85 0.024% 100.070% ( 1900, 2900 ] 102 0.029% 100.099% ( 2900, 4400 ] 52 0.015% 100.113% ( 4400, 6600 ] 4 0.001% 100.115% ** Level 4 read latency histogram (micros): Count: 130 Average: 278.7231 StdDev: 691.13 Min: 1 Median: 2.5833 Max: 4018 Percentiles: P50: 2.58 P75: 156.00 P99: 3750.00 P99.9: 4018.00 P99.99: 4018.00 ------------------------------------------------------ [ 0, 1 ] 26 20.000% 20.000% #### ( 1, 2 ] 32 24.615% 44.615% ##### ( 2, 3 ] 12 9.231% 53.846% ## ( 3, 4 ] 4 3.077% 56.923% # ( 4, 6 ] 4 3.077% 60.000% # ( 6, 10 ] 3 2.308% 62.308% ( 15, 22 ] 1 0.769% 63.077% ( 22, 34 ] 1 0.769% 63.846% ( 34, 51 ] 3 2.308% 66.154% ( 110, 170 ] 15 11.538% 77.692% ## ( 170, 250 ] 3 2.308% 80.000% ( 250, 380 ] 3 2.308% 82.308% ( 380, 580 ] 4 3.077% 85.385% # ( 580, 870 ] 6 4.615% 90.000% # ( 870, 1300 ] 5 3.846% 93.846% # ( 1300, 1900 ] 3 2.308% 96.154% ( 1900, 2900 ] 2 1.538% 97.692% ( 2900, 4400 ] 3 2.308% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 1046.4417 StdDev: 1243.58 Min: 44 Median: 503.0769 Max: 5521 Percentiles: P50: 503.08 P75: 1375.00 P99: 5521.00 P99.9: 5521.00 P99.99: 5521.00 ------------------------------------------------------ ( 34, 51 ] 2 1.667% 1.667% ( 51, 76 ] 1 0.833% 2.500% ( 76, 110 ] 9 7.500% 10.000% ## ( 110, 170 ] 12 10.000% 20.000% ## ( 170, 250 ] 8 6.667% 26.667% # ( 250, 380 ] 20 16.667% 43.333% ### ( 380, 580 ] 13 10.833% 54.167% ## ( 580, 870 ] 13 10.833% 65.000% ## ( 870, 1300 ] 11 9.167% 74.167% ## ( 1300, 1900 ] 8 6.667% 80.833% # ( 1900, 2900 ] 9 7.500% 88.333% ## ( 2900, 4400 ] 11 9.167% 97.500% ## ( 4400, 6600 ] 3 2.500% 100.000% # ** DB Stats ** Uptime(secs): 25.6 total, 3.3 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 268.69 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:6.444 H:M:S, 25.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 301.30 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.582 H:M:S, 17.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/28-07:38:54 ... thread 0: (1000000,8000000) ops and (105479.4,229116.5) ops/second in (9.480522,34.916736) 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/11 2.76 GB 0.0 7.7 0.0 7.7 15.2 7.6 0.0 2.0 152.2 301.7 51.74 48.43 137 0.378 7994K 11K 0.0 0.0 L1 15/15 1.67 GB 0.0 5.5 4.7 0.8 5.4 4.6 0.1 1.2 231.6 229.3 24.24 23.32 4 6.059 5698K 55K 0.0 0.0 L2 2/2 257.55 MB 0.0 0.1 0.1 0.1 0.1 0.1 3.0 2.0 229.3 229.2 0.55 0.53 1 0.549 127K 34 0.0 0.0 L3 30/8 1.45 GB 1.0 3.8 1.8 2.0 3.7 1.8 1.1 2.1 205.0 204.2 18.79 16.29 14 1.342 3840K 12K 0.0 0.0 L4 171/0 9.58 GB 1.0 0.9 0.8 0.1 0.9 0.8 1.6 1.2 176.3 175.6 5.48 4.43 11 0.498 972K 3388 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 1297/36 103.62 GB 0.0 18.0 7.3 10.7 25.5 14.8 8.2 3.4 182.8 258.9 100.80 93.00 167 0.604 18M 82K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.0 7.3 10.7 25.5 14.8 7.8 3.4 182.8 258.9 100.80 93.00 167 0.604 18M 82K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 18.0 7.3 10.7 17.9 7.3 0.0 0.0 234.7 233.6 78.53 73.48 55 1.428 18M 82K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.6 7.6 0.0 0.0 0.0 347.9 22.27 19.51 112 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): 35.1 total, 34.9 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 25.48 GB write, 742.97 MB/s write, 18.00 GB read, 524.76 MB/s read, 100.8 seconds Interval compaction: 25.48 GB write, 747.27 MB/s write, 18.00 GB read, 527.79 MB/s read, 100.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 20, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 20, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 28, pending-compaction-bytes-delays: 11, pending-compaction-bytes-stops: 0, total-delays: 31, total-stops: 28, interval: 59 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3360415 Average: 2.2349 StdDev: 12.52 Min: 1 Median: 1.4479 Max: 5497 Percentiles: P50: 1.45 P75: 1.83 P99: 5.80 P99.9: 11.01 P99.99: 141.13 ------------------------------------------------------ [ 0, 1 ] 704317 20.959% 20.959% #### ( 1, 2 ] 2179003 64.843% 85.802% ############# ( 2, 3 ] 253076 7.531% 93.334% ## ( 3, 4 ] 124478 3.704% 97.038% # ( 4, 6 ] 73383 2.184% 99.222% ( 6, 10 ] 22302 0.664% 99.885% ( 10, 15 ] 2452 0.073% 99.958% ( 15, 22 ] 262 0.008% 99.966% ( 22, 34 ] 29 0.001% 99.967% ( 34, 51 ] 14 0.000% 99.967% ( 51, 76 ] 28 0.001% 99.968% ( 76, 110 ] 434 0.013% 99.981% ( 110, 170 ] 580 0.017% 99.998% ( 170, 250 ] 309 0.009% 100.007% ( 250, 380 ] 236 0.007% 100.015% ( 380, 580 ] 186 0.006% 100.020% ( 580, 870 ] 130 0.004% 100.024% ( 870, 1300 ] 49 0.001% 100.025% ( 1300, 1900 ] 21 0.001% 100.026% ( 1900, 2900 ] 16 0.000% 100.026% ( 2900, 4400 ] 12 0.000% 100.027% ( 4400, 6600 ] 1 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 929478 Average: 3.0443 StdDev: 23.65 Min: 0 Median: 1.6346 Max: 5496 Percentiles: P50: 1.63 P75: 2.17 P99: 8.22 P99.9: 19.59 P99.99: 170.75 ------------------------------------------------------ [ 0, 1 ] 97727 10.514% 10.514% ## ( 1, 2 ] 578348 62.223% 72.737% ############ ( 2, 3 ] 122219 13.149% 85.886% ### ( 3, 4 ] 62621 6.737% 92.623% # ( 4, 6 ] 51215 5.510% 98.134% # ( 6, 10 ] 14492 1.559% 99.693% ( 10, 15 ] 1800 0.194% 99.886% ( 15, 22 ] 193 0.021% 99.907% ( 22, 34 ] 8 0.001% 99.908% ( 34, 51 ] 2 0.000% 99.908% ( 51, 76 ] 34 0.004% 99.912% ( 76, 110 ] 289 0.031% 99.943% ( 110, 170 ] 435 0.047% 99.990% ( 170, 250 ] 220 0.024% 100.013% ( 250, 380 ] 199 0.021% 100.035% ( 380, 580 ] 235 0.025% 100.060% ( 580, 870 ] 102 0.011% 100.071% ( 870, 1300 ] 61 0.007% 100.078% ( 1300, 1900 ] 21 0.002% 100.080% ( 1900, 2900 ] 13 0.001% 100.081% ( 2900, 4400 ] 11 0.001% 100.083% ( 4400, 6600 ] 1 0.000% 100.083% ** Level 2 read latency histogram (micros): Count: 60336 Average: 3.4565 StdDev: 38.11 Min: 1 Median: 1.4841 Max: 3383 Percentiles: P50: 1.48 P75: 1.88 P99: 7.97 P99.9: 377.70 P99.99: 2093.28 ------------------------------------------------------ [ 0, 1 ] 11825 19.599% 19.599% #### ( 1, 2 ] 37891 62.800% 82.399% ############# ( 2, 3 ] 5146 8.529% 90.927% ## ( 3, 4 ] 2861 4.742% 95.669% # ( 4, 6 ] 1671 2.769% 98.439% # ( 6, 10 ] 687 1.139% 99.577% ( 10, 15 ] 46 0.076% 99.654% ( 15, 22 ] 3 0.005% 99.659% ( 22, 34 ] 2 0.003% 99.662% ( 76, 110 ] 38 0.063% 99.725% ( 110, 170 ] 64 0.106% 99.831% ( 170, 250 ] 23 0.038% 99.869% ( 250, 380 ] 19 0.031% 99.901% ( 380, 580 ] 24 0.040% 99.940% ( 580, 870 ] 17 0.028% 99.969% ( 870, 1300 ] 7 0.012% 99.980% ( 1300, 1900 ] 5 0.008% 99.988% ( 1900, 2900 ] 5 0.008% 99.997% ( 2900, 4400 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 510653 Average: 5.5982 StdDev: 63.06 Min: 0 Median: 1.7257 Max: 4931 Percentiles: P50: 1.73 P75: 2.58 P99: 9.33 P99.9: 390.10 P99.99: 573.20 ------------------------------------------------------ [ 0, 1 ] 38405 7.521% 7.521% ## ( 1, 2 ] 298929 58.539% 66.059% ############ ( 2, 3 ] 78740 15.419% 81.479% ### ( 3, 4 ] 45111 8.834% 90.313% ## ( 4, 6 ] 37623 7.368% 97.680% # ( 6, 10 ] 8091 1.584% 99.265% ( 10, 15 ] 1301 0.255% 99.520% ( 15, 22 ] 141 0.028% 99.547% ( 22, 34 ] 64 0.013% 99.560% ( 34, 51 ] 17 0.003% 99.563% ( 51, 76 ] 6 0.001% 99.564% ( 76, 110 ] 289 0.057% 99.621% ( 110, 170 ] 546 0.107% 99.728% ( 170, 250 ] 449 0.088% 99.816% ( 250, 380 ] 405 0.079% 99.895% ( 380, 580 ] 502 0.098% 99.993% ( 580, 870 ] 322 0.063% 100.056% ( 870, 1300 ] 162 0.032% 100.088% ( 1300, 1900 ] 88 0.017% 100.105% ( 1900, 2900 ] 104 0.020% 100.126% ( 2900, 4400 ] 52 0.010% 100.136% ( 4400, 6600 ] 4 0.001% 100.137% ** Level 4 read latency histogram (micros): Count: 175 Average: 221.0971 StdDev: 608.90 Min: 1 Median: 2.4412 Max: 4018 Percentiles: P50: 2.44 P75: 135.00 P99: 3525.00 P99.9: 4018.00 P99.99: 4018.00 ------------------------------------------------------ [ 0, 1 ] 40 22.857% 22.857% ##### ( 1, 2 ] 40 22.857% 45.714% ##### ( 2, 3 ] 17 9.714% 55.429% ## ( 3, 4 ] 7 4.000% 59.429% # ( 4, 6 ] 5 2.857% 62.286% # ( 6, 10 ] 4 2.286% 64.571% ( 10, 15 ] 1 0.571% 65.143% ( 15, 22 ] 3 1.714% 66.857% ( 22, 34 ] 5 2.857% 69.714% # ( 34, 51 ] 3 1.714% 71.429% ( 110, 170 ] 15 8.571% 80.000% ## ( 170, 250 ] 6 3.429% 83.429% # ( 250, 380 ] 4 2.286% 85.714% ( 380, 580 ] 5 2.857% 88.571% # ( 580, 870 ] 6 3.429% 92.000% # ( 870, 1300 ] 6 3.429% 95.429% # ( 1300, 1900 ] 3 1.714% 97.143% ( 1900, 2900 ] 2 1.143% 98.286% ( 2900, 4400 ] 3 1.714% 100.000% ** Level 5 read latency histogram (micros): Count: 140 Average: 1029.5429 StdDev: 1207.62 Min: 44 Median: 508.5714 Max: 5521 Percentiles: P50: 508.57 P75: 1366.67 P99: 5521.00 P99.9: 5521.00 P99.99: 5521.00 ------------------------------------------------------ ( 34, 51 ] 2 1.429% 1.429% ( 51, 76 ] 1 0.714% 2.143% ( 76, 110 ] 10 7.143% 9.286% # ( 110, 170 ] 18 12.857% 22.143% ### ( 170, 250 ] 8 5.714% 27.857% # ( 250, 380 ] 22 15.714% 43.571% ### ( 380, 580 ] 14 10.000% 53.571% ## ( 580, 870 ] 15 10.714% 64.286% ## ( 870, 1300 ] 14 10.000% 74.286% ## ( 1300, 1900 ] 9 6.429% 80.714% # ( 1900, 2900 ] 12 8.571% 89.286% ## ( 2900, 4400 ] 12 8.571% 97.857% ## ( 4400, 6600 ] 3 2.143% 100.000% ** DB Stats ** Uptime(secs): 35.1 total, 9.5 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 224.18 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:12.947 H:M:S, 36.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 103.81 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:6.502 H:M:S, 68.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/28-07:38:58 ... thread 0: (1000000,9000000) ops and (235351.8,229792.9) ops/second in (4.248959,39.165695) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/11 3.75 GB 100.7 8.5 0.0 8.5 17.1 8.6 0.0 2.0 148.6 299.2 58.49 54.31 156 0.375 8826K 12K 0.0 0.0 L1 15/15 1.67 GB 0.0 5.5 4.7 0.8 5.4 4.6 0.1 1.2 231.6 229.3 24.24 23.32 4 6.059 5698K 55K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 3.0 2.0 229.3 229.2 0.55 0.53 1 0.549 127K 34 0.0 0.0 L3 21/0 934.27 MB 0.9 4.5 2.1 2.4 4.5 2.0 1.1 2.2 206.6 205.7 22.31 19.58 16 1.395 4609K 18K 0.0 0.0 L4 174/0 9.74 GB 1.0 1.8 1.6 0.3 1.8 1.6 1.6 1.2 160.2 159.5 11.68 8.56 23 0.508 1892K 8053 0.0 0.0 L5 1076/0 88.52 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1303/26 104.59 GB 0.0 20.4 8.4 12.1 28.9 16.9 8.8 3.4 178.3 252.7 117.27 106.30 200 0.586 21M 94K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.4 8.4 12.1 28.9 16.9 8.4 3.4 178.3 252.7 117.27 106.30 200 0.586 21M 94K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 20.4 8.4 12.1 20.3 8.3 0.0 0.0 228.3 227.3 91.58 84.00 72 1.272 21M 94K 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 343.3 25.69 22.30 128 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): 39.4 total, 39.2 interval Flush(GB): cumulative 8.613, interval 8.613 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: 28.94 GB write, 752.74 MB/s write, 20.42 GB read, 531.16 MB/s read, 117.3 seconds Interval compaction: 28.94 GB write, 756.62 MB/s write, 20.42 GB read, 533.90 MB/s read, 117.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 23, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 23, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 31, pending-compaction-bytes-delays: 14, pending-compaction-bytes-stops: 0, total-delays: 37, total-stops: 31, interval: 68 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3793115 Average: 2.2809 StdDev: 15.92 Min: 1 Median: 1.4599 Max: 9041 Percentiles: P50: 1.46 P75: 1.85 P99: 5.88 P99.9: 11.55 P99.99: 139.35 ------------------------------------------------------ [ 0, 1 ] 768414 20.258% 20.258% #### ( 1, 2 ] 2452824 64.665% 84.923% ############# ( 2, 3 ] 299659 7.900% 92.823% ## ( 3, 4 ] 147765 3.896% 96.719% # ( 4, 6 ] 92125 2.429% 99.148% ( 6, 10 ] 27569 0.727% 99.875% ( 10, 15 ] 3122 0.082% 99.957% ( 15, 22 ] 320 0.008% 99.965% ( 22, 34 ] 36 0.001% 99.966% ( 34, 51 ] 15 0.000% 99.967% ( 51, 76 ] 39 0.001% 99.968% ( 76, 110 ] 520 0.014% 99.981% ( 110, 170 ] 672 0.018% 99.999% ( 170, 250 ] 354 0.009% 100.008% ( 250, 380 ] 282 0.007% 100.016% ( 380, 580 ] 217 0.006% 100.022% ( 580, 870 ] 144 0.004% 100.025% ( 870, 1300 ] 57 0.002% 100.027% ( 1300, 1900 ] 21 0.001% 100.027% ( 1900, 2900 ] 21 0.001% 100.028% ( 2900, 4400 ] 16 0.000% 100.028% ( 4400, 6600 ] 3 0.000% 100.028% ( 6600, 9900 ] 4 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 974290 Average: 3.0143 StdDev: 23.10 Min: 0 Median: 1.6330 Max: 5496 Percentiles: P50: 1.63 P75: 2.16 P99: 8.22 P99.9: 17.88 P99.99: 169.11 ------------------------------------------------------ [ 0, 1 ] 102265 10.496% 10.496% ## ( 1, 2 ] 608065 62.411% 72.907% ############ ( 2, 3 ] 127626 13.099% 86.007% ### ( 3, 4 ] 65082 6.680% 92.687% # ( 4, 6 ] 53009 5.441% 98.128% # ( 6, 10 ] 15304 1.571% 99.698% ( 10, 15 ] 1884 0.193% 99.892% ( 15, 22 ] 196 0.020% 99.912% ( 22, 34 ] 8 0.001% 99.913% ( 34, 51 ] 2 0.000% 99.913% ( 51, 76 ] 34 0.003% 99.916% ( 76, 110 ] 289 0.030% 99.946% ( 110, 170 ] 435 0.045% 99.991% ( 170, 250 ] 220 0.023% 100.013% ( 250, 380 ] 199 0.020% 100.034% ( 380, 580 ] 235 0.024% 100.058% ( 580, 870 ] 102 0.010% 100.068% ( 870, 1300 ] 61 0.006% 100.075% ( 1300, 1900 ] 21 0.002% 100.077% ( 1900, 2900 ] 13 0.001% 100.078% ( 2900, 4400 ] 11 0.001% 100.079% ( 4400, 6600 ] 1 0.000% 100.079% ** Level 2 read latency histogram (micros): Count: 60336 Average: 3.4565 StdDev: 38.11 Min: 1 Median: 1.4841 Max: 3383 Percentiles: P50: 1.48 P75: 1.88 P99: 7.97 P99.9: 377.70 P99.99: 2093.28 ------------------------------------------------------ [ 0, 1 ] 11825 19.599% 19.599% #### ( 1, 2 ] 37891 62.800% 82.399% ############# ( 2, 3 ] 5146 8.529% 90.927% ## ( 3, 4 ] 2861 4.742% 95.669% # ( 4, 6 ] 1671 2.769% 98.439% # ( 6, 10 ] 687 1.139% 99.577% ( 10, 15 ] 46 0.076% 99.654% ( 15, 22 ] 3 0.005% 99.659% ( 22, 34 ] 2 0.003% 99.662% ( 76, 110 ] 38 0.063% 99.725% ( 110, 170 ] 64 0.106% 99.831% ( 170, 250 ] 23 0.038% 99.869% ( 250, 380 ] 19 0.031% 99.901% ( 380, 580 ] 24 0.040% 99.940% ( 580, 870 ] 17 0.028% 99.969% ( 870, 1300 ] 7 0.012% 99.980% ( 1300, 1900 ] 5 0.008% 99.988% ( 1900, 2900 ] 5 0.008% 99.997% ( 2900, 4400 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 817636 Average: 5.3238 StdDev: 67.32 Min: 0 Median: 1.7610 Max: 8241 Percentiles: P50: 1.76 P75: 2.69 P99: 8.89 P99.9: 247.25 P99.99: 435.59 ------------------------------------------------------ [ 0, 1 ] 52890 6.469% 6.469% # ( 1, 2 ] 467737 57.206% 63.675% ########### ( 2, 3 ] 134029 16.392% 80.067% ### ( 3, 4 ] 77533 9.483% 89.550% ## ( 4, 6 ] 68140 8.334% 97.883% ## ( 6, 10 ] 12629 1.545% 99.428% ( 10, 15 ] 1997 0.244% 99.672% ( 15, 22 ] 200 0.024% 99.697% ( 22, 34 ] 68 0.008% 99.705% ( 34, 51 ] 22 0.003% 99.708% ( 51, 76 ] 17 0.002% 99.710% ( 76, 110 ] 334 0.041% 99.751% ( 110, 170 ] 671 0.082% 99.833% ( 170, 250 ] 571 0.070% 99.902% ( 250, 380 ] 530 0.065% 99.967% ( 380, 580 ] 670 0.082% 100.049% ( 580, 870 ] 436 0.053% 100.102% ( 870, 1300 ] 213 0.026% 100.129% ( 1300, 1900 ] 102 0.012% 100.141% ( 1900, 2900 ] 130 0.016% 100.157% ( 2900, 4400 ] 96 0.012% 100.169% ( 4400, 6600 ] 8 0.001% 100.170% ( 6600, 9900 ] 11 0.001% 100.171% ** Level 4 read latency histogram (micros): Count: 660 Average: 239.2455 StdDev: 829.77 Min: 0 Median: 2.7477 Max: 10169 Percentiles: P50: 2.75 P75: 16.56 P99: 4576.00 P99.9: 10169.00 P99.99: 10169.00 ------------------------------------------------------ [ 0, 1 ] 74 11.212% 11.212% ## ( 1, 2 ] 176 26.667% 37.879% ##### ( 2, 3 ] 107 16.212% 54.091% ### ( 3, 4 ] 59 8.939% 63.030% ## ( 4, 6 ] 45 6.818% 69.848% # ( 6, 10 ] 25 3.788% 73.636% # ( 10, 15 ] 7 1.061% 74.697% ( 15, 22 ] 9 1.364% 76.061% ( 22, 34 ] 9 1.364% 77.424% ( 34, 51 ] 5 0.758% 78.182% ( 51, 76 ] 2 0.303% 78.485% ( 76, 110 ] 1 0.152% 78.636% ( 110, 170 ] 15 2.273% 80.909% ( 170, 250 ] 19 2.879% 83.788% # ( 250, 380 ] 16 2.424% 86.212% ( 380, 580 ] 28 4.242% 90.455% # ( 580, 870 ] 16 2.424% 92.879% ( 870, 1300 ] 17 2.576% 95.455% # ( 1300, 1900 ] 8 1.212% 96.667% ( 1900, 2900 ] 6 0.909% 97.576% ( 2900, 4400 ] 9 1.364% 98.939% ( 4400, 6600 ] 5 0.758% 99.697% ( 6600, 9900 ] 1 0.152% 99.848% ( 9900, 14000 ] 1 0.152% 100.000% ** Level 5 read latency histogram (micros): Count: 180 Average: 1025.9556 StdDev: 1177.47 Min: 44 Median: 510.0000 Max: 5521 Percentiles: P50: 510.00 P75: 1438.46 P99: 5280.00 P99.9: 5521.00 P99.99: 5521.00 ------------------------------------------------------ ( 34, 51 ] 2 1.111% 1.111% ( 51, 76 ] 1 0.556% 1.667% ( 76, 110 ] 15 8.333% 10.000% ## ( 110, 170 ] 21 11.667% 21.667% ## ( 170, 250 ] 11 6.111% 27.778% # ( 250, 380 ] 27 15.000% 42.778% ### ( 380, 580 ] 20 11.111% 53.889% ## ( 580, 870 ] 20 11.111% 65.000% ## ( 870, 1300 ] 15 8.333% 73.333% ## ( 1300, 1900 ] 13 7.222% 80.556% # ( 1900, 2900 ] 17 9.444% 90.000% ## ( 2900, 4400 ] 15 8.333% 98.333% ## ( 4400, 6600 ] 3 1.667% 100.000% ** DB Stats ** Uptime(secs): 39.4 total, 4.2 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 224.99 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:14.381 H:M:S, 36.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 231.63 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.434 H:M:S, 33.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/28-07:39:18 ... thread 0: (1000000,10000000) ops and (48740.5,167553.3) ops/second in (20.516802,59.682497) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/12 1.91 GB 6.3 9.0 0.0 9.0 18.4 9.5 0.0 1.9 141.4 290.5 65.02 58.53 170 0.382 9337K 12K 0.0 0.0 L1 9/9 1.02 GB 0.0 9.9 7.4 2.5 9.8 7.3 0.1 1.3 223.7 220.6 45.40 42.23 5 9.081 10M 55K 0.0 0.0 L2 2/0 82.63 MB 0.8 0.1 0.1 0.1 0.1 0.1 6.3 2.0 229.3 229.2 0.55 0.53 1 0.549 127K 34 0.0 0.0 L3 29/7 1.67 GB 1.1 6.7 3.3 3.5 6.7 3.2 3.2 2.0 174.0 172.9 39.56 30.08 26 1.521 6918K 41K 0.0 0.0 L4 193/18 11.82 GB 1.1 5.1 4.1 1.1 5.1 4.0 1.6 1.3 134.0 133.0 39.31 24.16 47 0.836 5315K 36K 0.0 0.0 L5 1080/0 88.89 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1326/46 105.38 GB 0.0 30.9 14.8 16.1 40.1 24.1 14.5 4.2 166.6 216.5 189.84 155.54 249 0.762 31M 145K 0.0 0.0 Int 0/0 0.00 KB 0.0 30.9 14.8 16.1 40.1 24.1 14.1 4.2 166.6 216.5 189.84 155.54 249 0.762 31M 145K 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 30.9 14.8 16.1 30.7 14.6 0.0 0.0 198.3 196.8 159.50 130.85 109 1.463 31M 145K 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 319.8 30.34 24.69 140 0.217 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.9 total, 59.7 interval Flush(GB): cumulative 9.474, interval 9.474 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 40.13 GB write, 686.23 MB/s write, 30.89 GB read, 528.15 MB/s read, 189.8 seconds Interval compaction: 40.13 GB write, 688.55 MB/s write, 30.89 GB read, 529.94 MB/s read, 189.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 27, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 27, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 44, pending-compaction-bytes-delays: 32, pending-compaction-bytes-stops: 0, total-delays: 59, total-stops: 44, interval: 103 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4517327 Average: 2.7459 StdDev: 28.11 Min: 0 Median: 1.4615 Max: 9041 Percentiles: P50: 1.46 P75: 1.85 P99: 6.82 P99.9: 126.24 P99.99: 366.87 ------------------------------------------------------ [ 0, 1 ] 932166 20.635% 20.635% #### ( 1, 2 ] 2874490 63.633% 84.268% ############# ( 2, 3 ] 356692 7.896% 92.164% ## ( 3, 4 ] 179429 3.972% 96.136% # ( 4, 6 ] 121775 2.696% 98.832% # ( 6, 10 ] 37156 0.823% 99.654% ( 10, 15 ] 4492 0.099% 99.754% ( 15, 22 ] 573 0.013% 99.766% ( 22, 34 ] 54 0.001% 99.768% ( 34, 51 ] 22 0.000% 99.768% ( 51, 76 ] 254 0.006% 99.774% ( 76, 110 ] 4779 0.106% 99.879% ( 110, 170 ] 3434 0.076% 99.955% ( 170, 250 ] 905 0.020% 99.976% ( 250, 380 ] 730 0.016% 99.992% ( 380, 580 ] 644 0.014% 100.006% ( 580, 870 ] 400 0.009% 100.015% ( 870, 1300 ] 216 0.005% 100.020% ( 1300, 1900 ] 108 0.002% 100.022% ( 1900, 2900 ] 72 0.002% 100.024% ( 2900, 4400 ] 76 0.002% 100.025% ( 4400, 6600 ] 29 0.001% 100.026% ( 6600, 9900 ] 5 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 1984455 Average: 4.6398 StdDev: 80.10 Min: 0 Median: 1.6152 Max: 14467 Percentiles: P50: 1.62 P75: 2.24 P99: 9.08 P99.9: 152.69 P99.99: 527.94 ------------------------------------------------------ [ 0, 1 ] 294872 14.859% 14.859% ### ( 1, 2 ] 1133548 57.121% 71.980% ########### ( 2, 3 ] 249774 12.587% 84.567% ### ( 3, 4 ] 135217 6.814% 91.381% # ( 4, 6 ] 123824 6.240% 97.621% # ( 6, 10 ] 35552 1.792% 99.412% ( 10, 15 ] 5830 0.294% 99.706% ( 15, 22 ] 826 0.042% 99.747% ( 22, 34 ] 57 0.003% 99.750% ( 34, 51 ] 12 0.001% 99.751% ( 51, 76 ] 206 0.010% 99.761% ( 76, 110 ] 1600 0.081% 99.842% ( 110, 170 ] 1620 0.082% 99.924% ( 170, 250 ] 397 0.020% 99.944% ( 250, 380 ] 477 0.024% 99.968% ( 380, 580 ] 601 0.030% 99.998% ( 580, 870 ] 510 0.026% 100.024% ( 870, 1300 ] 345 0.017% 100.041% ( 1300, 1900 ] 186 0.009% 100.050% ( 1900, 2900 ] 200 0.010% 100.060% ( 2900, 4400 ] 261 0.013% 100.074% ( 4400, 6600 ] 125 0.006% 100.080% ( 6600, 9900 ] 31 0.002% 100.081% ( 9900, 14000 ] 10 0.001% 100.082% ( 14000, 22000 ] 1 0.000% 100.082% ** Level 2 read latency histogram (micros): Count: 60336 Average: 3.4565 StdDev: 38.11 Min: 1 Median: 1.4841 Max: 3383 Percentiles: P50: 1.48 P75: 1.88 P99: 7.97 P99.9: 377.70 P99.99: 2093.28 ------------------------------------------------------ [ 0, 1 ] 11825 19.599% 19.599% #### ( 1, 2 ] 37891 62.800% 82.399% ############# ( 2, 3 ] 5146 8.529% 90.927% ## ( 3, 4 ] 2861 4.742% 95.669% # ( 4, 6 ] 1671 2.769% 98.439% # ( 6, 10 ] 687 1.139% 99.577% ( 10, 15 ] 46 0.076% 99.654% ( 15, 22 ] 3 0.005% 99.659% ( 22, 34 ] 2 0.003% 99.662% ( 76, 110 ] 38 0.063% 99.725% ( 110, 170 ] 64 0.106% 99.831% ( 170, 250 ] 23 0.038% 99.869% ( 250, 380 ] 19 0.031% 99.901% ( 380, 580 ] 24 0.040% 99.940% ( 580, 870 ] 17 0.028% 99.969% ( 870, 1300 ] 7 0.012% 99.980% ( 1300, 1900 ] 5 0.008% 99.988% ( 1900, 2900 ] 5 0.008% 99.997% ( 2900, 4400 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 1551956 Average: 6.6416 StdDev: 94.10 Min: 0 Median: 1.8228 Max: 16012 Percentiles: P50: 1.82 P75: 2.86 P99: 9.26 P99.9: 379.13 P99.99: 612.65 ------------------------------------------------------ [ 0, 1 ] 79927 5.150% 5.150% # ( 1, 2 ] 845974 54.510% 59.660% ########### ( 2, 3 ] 275355 17.742% 77.403% #### ( 3, 4 ] 159666 10.288% 87.691% ## ( 4, 6 ] 151837 9.784% 97.474% ## ( 6, 10 ] 29024 1.870% 99.345% ( 10, 15 ] 5029 0.324% 99.669% ( 15, 22 ] 586 0.038% 99.706% ( 22, 34 ] 104 0.007% 99.713% ( 34, 51 ] 43 0.003% 99.716% ( 51, 76 ] 42 0.003% 99.718% ( 76, 110 ] 375 0.024% 99.743% ( 110, 170 ] 765 0.049% 99.792% ( 170, 250 ] 798 0.051% 99.843% ( 250, 380 ] 885 0.057% 99.900% ( 380, 580 ] 1270 0.082% 99.982% ( 580, 870 ] 1073 0.069% 100.051% ( 870, 1300 ] 679 0.044% 100.095% ( 1300, 1900 ] 314 0.020% 100.115% ( 1900, 2900 ] 349 0.022% 100.138% ( 2900, 4400 ] 373 0.024% 100.162% ( 4400, 6600 ] 93 0.006% 100.168% ( 6600, 9900 ] 20 0.001% 100.169% ( 9900, 14000 ] 3 0.000% 100.169% ( 14000, 22000 ] 2 0.000% 100.169% ** Level 4 read latency histogram (micros): Count: 185387 Average: 17.4442 StdDev: 217.24 Min: 0 Median: 1.9128 Max: 23576 Percentiles: P50: 1.91 P75: 3.08 P99: 14.64 P99.9: 3100.55 P99.99: 4270.06 ------------------------------------------------------ [ 0, 1 ] 6957 3.753% 3.753% # ( 1, 2 ] 93927 50.665% 54.418% ########## ( 2, 3 ] 36525 19.702% 74.120% #### ( 3, 4 ] 20076 10.829% 84.949% ## ( 4, 6 ] 20654 11.141% 96.090% ## ( 6, 10 ] 4452 2.401% 98.492% ( 10, 15 ] 1017 0.549% 99.040% ( 15, 22 ] 137 0.074% 99.114% ( 22, 34 ] 20 0.011% 99.125% ( 34, 51 ] 16 0.009% 99.134% ( 51, 76 ] 5 0.003% 99.136% ( 76, 110 ] 6 0.003% 99.140% ( 110, 170 ] 34 0.018% 99.158% ( 170, 250 ] 83 0.045% 99.203% ( 250, 380 ] 131 0.071% 99.273% ( 380, 580 ] 255 0.138% 99.411% ( 580, 870 ] 299 0.161% 99.572% ( 870, 1300 ] 270 0.146% 99.718% ( 1300, 1900 ] 152 0.082% 99.800% ( 1900, 2900 ] 158 0.085% 99.885% ( 2900, 4400 ] 214 0.115% 100.001% ( 4400, 6600 ] 90 0.049% 100.049% ( 6600, 9900 ] 15 0.008% 100.057% ( 9900, 14000 ] 4 0.002% 100.059% ( 22000, 33000 ] 1 0.001% 100.060% ** Level 5 read latency histogram (micros): Count: 200 Average: 1143.7300 StdDev: 1333.51 Min: 44 Median: 580.0000 Max: 7612 Percentiles: P50: 580.00 P75: 1617.65 P99: 6160.00 P99.9: 7612.00 P99.99: 7612.00 ------------------------------------------------------ ( 34, 51 ] 2 1.000% 1.000% ( 51, 76 ] 1 0.500% 1.500% ( 76, 110 ] 15 7.500% 9.000% ## ( 110, 170 ] 21 10.500% 19.500% ## ( 170, 250 ] 11 5.500% 25.000% # ( 250, 380 ] 28 14.000% 39.000% ### ( 380, 580 ] 22 11.000% 50.000% ## ( 580, 870 ] 24 12.000% 62.000% ## ( 870, 1300 ] 17 8.500% 70.500% ## ( 1300, 1900 ] 17 8.500% 79.000% ## ( 1900, 2900 ] 18 9.000% 88.000% ## ( 2900, 4400 ] 18 9.000% 97.000% ## ( 4400, 6600 ] 5 2.500% 99.500% # ( 6600, 9900 ] 1 0.500% 100.000% ** DB Stats ** Uptime(secs): 59.9 total, 20.5 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 164.34 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:31.319 H:M:S, 52.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 47.97 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:16.938 H:M:S, 82.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.985 micros/op 167098 ops/sec 60.126 seconds 10046999 operations; 161.9 MB/s Microseconds per write: Count: 10046999 Average: 5.9839 StdDev: 445.27 Min: 1 Median: 1.7769 Max: 840147 Percentiles: P50: 1.78 P75: 2.81 P99: 9.69 P99.9: 1144.75 P99.99: 2626.24 ------------------------------------------------------ [ 0, 1 ] 1129291 11.240% 11.240% ## ( 1, 2 ] 5012453 49.890% 61.130% ########## ( 2, 3 ] 1716104 17.081% 78.211% ### ( 3, 4 ] 1392554 13.860% 92.071% ### ( 4, 6 ] 566581 5.639% 97.711% # ( 6, 10 ] 140543 1.399% 99.109% ( 10, 15 ] 45558 0.453% 99.563% ( 15, 22 ] 9509 0.095% 99.658% ( 22, 34 ] 1862 0.019% 99.676% ( 34, 51 ] 269 0.003% 99.679% ( 51, 76 ] 63 0.001% 99.679% ( 76, 110 ] 7005 0.070% 99.749% ( 110, 170 ] 2767 0.028% 99.777% ( 170, 250 ] 278 0.003% 99.779% ( 250, 380 ] 217 0.002% 99.782% ( 380, 580 ] 25 0.000% 99.782% ( 580, 870 ] 21 0.000% 99.782% ( 870, 1300 ] 18549 0.185% 99.967% ( 1300, 1900 ] 62 0.001% 99.967% ( 1900, 2900 ] 3144 0.031% 99.999% ( 2900, 4400 ] 97 0.001% 100.000% ( 4400, 6600 ] 19 0.000% 100.000% ( 6600, 9900 ] 5 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 50000, 75000 ] 1 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 12 0.000% 100.000% ( 250000, 380000 ] 2 0.000% 100.000% ( 570000, 860000 ] 2 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 : 246660 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 : 10046999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10368502968 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 : 619 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31603227 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 : 34870858560 rocksdb.compact.write.bytes COUNT : 34613567698 rocksdb.flush.write.bytes COUNT : 10239207403 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 : 62 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 : 297 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 : 10156364800 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3680256 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 : 34972145830 rocksdb.non.last.level.read.count COUNT : 8449733 rocksdb.block.checksum.compute.count COUNT : 8448558 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.426178 P95 : 3.962573 P99 : 8.394232 P100 : 840144.000000 COUNT : 10046999 SUM : 55166953 rocksdb.compaction.times.micros P50 : 1030000.000000 P95 : 3110000.000000 P99 : 13538000.000000 P100 : 21169291.000000 COUNT : 111 SUM : 161184143 rocksdb.compaction.times.cpu_micros P50 : 880238.095238 P95 : 2625000.000000 P99 : 13538000.000000 P100 : 18914983.000000 COUNT : 111 SUM : 131805431 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 : 716.944444 P95 : 6545.000000 P99 : 15250.000000 P100 : 15250.000000 COUNT : 141 SUM : 193086 rocksdb.compaction.outfile.sync.micros P50 : 1070.069444 P95 : 133400.000000 P99 : 270020.000000 P100 : 335322.000000 COUNT : 423 SUM : 8659015 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.369048 P95 : 1872.500000 P99 : 4172.500000 P100 : 5770.000000 COUNT : 291 SUM : 118043 rocksdb.table.open.io.micros P50 : 1340.909091 P95 : 7776.290323 P99 : 12717.285714 P100 : 25275.000000 COUNT : 619 SUM : 1316820 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.603563 P95 : 7.916679 P99 : 11.701066 P100 : 23581.000000 COUNT : 8447107 SUM : 54674526 rocksdb.read.block.get.micros P50 : 402.222222 P95 : 3545.535714 P99 : 5950.560000 P100 : 7710.000000 COUNT : 1238 SUM : 1054966 rocksdb.write.raw.block.micros P50 : 0.513550 P95 : 0.975745 P99 : 2.946606 P100 : 32155.000000 COUNT : 10866509 SUM : 22940831 rocksdb.numfiles.in.singlecompaction P50 : 3.117978 P95 : 5.180000 P99 : 16.330000 P100 : 26.000000 COUNT : 181 SUM : 652 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.562878 P95 : 1147.478652 P99 : 2299.635083 P100 : 839949.000000 COUNT : 196754 SUM : 31623865 rocksdb.sst.read.micros P50 : 1.572418 P95 : 4.799724 P99 : 8.681950 P100 : 23576.000000 COUNT : 8450466 SUM : 37489386 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 : 10046999 SUM : 10368502968 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 : 208279.569892 P95 : 432928.571429 P99 : 960300.000000 P100 : 969235.000000 COUNT : 141 SUM : 30836270 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 : 398 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