[2024-12-08 15:11:02.768278] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 23.11.0 initialization... [2024-12-08 15:11:02.768399] [ 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_pid2600122 ] Set seed to 1733667062765905 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-08 15:11:02.871794] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-08 15:11:03.077574] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-08 15:11:03.077619] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 2600122' to capture a snapshot of events at runtime. [2024-12-08 15:11:03.077630] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid2600122 for offline analysis/debug. [2024-12-08 15:11:03.077654] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sun Dec 8 15:11:11 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/08-15:11:18 ... thread 0: (1000000,1000000) ops and (141525.7,141525.7) ops/second in (7.065852,7.065852) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 6/4 818.32 MB 18.9 0.4 0.0 0.4 1.2 0.8 0.0 1.5 43.5 137.7 8.69 4.00 10 0.869 383K 510 0.0 0.0 L1 3/3 140.27 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.0 1.5 114.0 113.7 5.11 2.72 1 5.113 591K 1396 0.0 0.0 L2 4/2 350.58 MB 2.4 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 L3 34/19 2.70 GB 1.2 1.6 0.8 0.8 1.6 0.8 0.2 1.9 103.3 102.2 15.56 7.63 7 2.223 891K 0 0.0 0.0 L4 199/13 13.00 GB 1.3 3.8 3.3 0.5 3.8 3.2 0.0 1.2 101.8 101.1 38.03 18.36 32 1.189 1673K 0 0.0 0.0 L5 1068/0 87.85 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1314/41 104.82 GB 0.0 6.3 4.5 1.8 7.0 5.2 0.7 8.8 95.5 107.0 67.39 32.71 50 1.348 3540K 1906 0.0 0.0 Int 0/0 0.00 KB 0.0 6.3 4.5 1.8 7.0 5.2 0.7 8.8 95.5 107.0 67.39 32.71 50 1.348 3540K 1906 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.3 4.5 1.8 6.2 4.4 0.0 0.0 105.8 105.1 60.87 30.31 41 1.485 3540K 1906 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 125.4 6.53 2.39 9 0.725 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 7.3 total, 7.1 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.04 GB write, 990.69 MB/s write, 6.29 GB read, 884.29 MB/s read, 67.4 seconds Interval compaction: 7.04 GB write, 1020.54 MB/s write, 6.29 GB read, 910.93 MB/s read, 67.4 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: 33, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 33, interval: 33 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 227176 Average: 12.7715 StdDev: 205.76 Min: 0 Median: 1.8911 Max: 34216 Percentiles: P50: 1.89 P75: 2.92 P99: 10.68 P99.9: 2646.03 P99.99: 5086.15 ------------------------------------------------------ [ 0, 1 ] 9087 4.000% 4.000% # ( 1, 2 ] 117276 51.623% 55.623% ########## ( 2, 3 ] 48068 21.159% 76.782% #### ( 3, 4 ] 20372 8.967% 85.750% ## ( 4, 6 ] 24948 10.982% 96.732% ## ( 6, 10 ] 4993 2.198% 98.929% ( 10, 15 ] 1182 0.520% 99.450% ( 15, 22 ] 136 0.060% 99.510% ( 22, 34 ] 10 0.004% 99.514% ( 34, 51 ] 8 0.004% 99.518% ( 51, 76 ] 7 0.003% 99.521% ( 110, 170 ] 6 0.003% 99.523% ( 170, 250 ] 18 0.008% 99.531% ( 250, 380 ] 28 0.012% 99.544% ( 380, 580 ] 70 0.031% 99.574% ( 580, 870 ] 112 0.049% 99.624% ( 870, 1300 ] 192 0.085% 99.708% ( 1300, 1900 ] 263 0.116% 99.824% ( 1900, 2900 ] 233 0.103% 99.926% ( 2900, 4400 ] 130 0.057% 99.984% ( 4400, 6600 ] 49 0.022% 100.005% ( 6600, 9900 ] 10 0.004% 100.010% ( 9900, 14000 ] 2 0.001% 100.011% ( 14000, 22000 ] 3 0.001% 100.012% ( 22000, 33000 ] 2 0.001% 100.013% ( 33000, 50000 ] 1 0.000% 100.013% ** Level 1 read latency histogram (micros): Count: 64911 Average: 14.9971 StdDev: 179.67 Min: 1 Median: 1.9325 Max: 7675 Percentiles: P50: 1.93 P75: 2.98 P99: 13.03 P99.9: 3112.87 P99.99: 6009.20 ------------------------------------------------------ [ 0, 1 ] 2146 3.306% 3.306% # ( 1, 2 ] 32503 50.073% 53.379% ########## ( 2, 3 ] 14324 22.067% 75.446% #### ( 3, 4 ] 5828 8.978% 84.425% ## ( 4, 6 ] 7433 11.451% 95.876% ## ( 6, 10 ] 1751 2.698% 98.573% # ( 10, 15 ] 457 0.704% 99.277% ( 15, 22 ] 45 0.069% 99.347% ( 22, 34 ] 4 0.006% 99.353% ( 51, 76 ] 3 0.005% 99.358% ( 110, 170 ] 3 0.005% 99.362% ( 170, 250 ] 4 0.006% 99.368% ( 250, 380 ] 15 0.023% 99.391% ( 380, 580 ] 28 0.043% 99.435% ( 580, 870 ] 44 0.068% 99.502% ( 870, 1300 ] 77 0.119% 99.621% ( 1300, 1900 ] 74 0.114% 99.735% ( 1900, 2900 ] 99 0.153% 99.888% ( 2900, 4400 ] 57 0.088% 99.975% ( 4400, 6600 ] 13 0.020% 99.995% ( 6600, 9900 ] 4 0.006% 100.002% ** Level 2 read latency histogram (micros): Count: 209275 Average: 19.5749 StdDev: 222.60 Min: 1 Median: 1.9888 Max: 8876 Percentiles: P50: 1.99 P75: 3.10 P99: 13.95 P99.9: 2874.94 P99.99: 3872.93 ------------------------------------------------------ [ 0, 1 ] 5921 2.829% 2.829% # ( 1, 2 ] 99834 47.705% 50.534% ########## ( 2, 3 ] 49136 23.479% 74.013% ##### ( 3, 4 ] 20223 9.663% 83.677% ## ( 4, 6 ] 24790 11.846% 95.522% ## ( 6, 10 ] 5783 2.763% 98.286% # ( 10, 15 ] 1895 0.906% 99.191% ( 15, 22 ] 325 0.155% 99.346% ( 22, 34 ] 22 0.011% 99.357% ( 34, 51 ] 7 0.003% 99.360% ( 51, 76 ] 5 0.002% 99.363% ( 76, 110 ] 3 0.001% 99.364% ( 110, 170 ] 2 0.001% 99.365% ( 170, 250 ] 3 0.001% 99.366% ( 250, 380 ] 23 0.011% 99.377% ( 380, 580 ] 47 0.022% 99.400% ( 580, 870 ] 80 0.038% 99.438% ( 870, 1300 ] 188 0.090% 99.528% ( 1300, 1900 ] 340 0.162% 99.690% ( 1900, 2900 ] 450 0.215% 99.905% ( 2900, 4400 ] 273 0.130% 100.036% ( 4400, 6600 ] 102 0.049% 100.085% ( 6600, 9900 ] 12 0.006% 100.090% ** Level 3 read latency histogram (micros): Count: 971005 Average: 17.2657 StdDev: 229.93 Min: 1 Median: 2.0233 Max: 42870 Percentiles: P50: 2.02 P75: 3.04 P99: 11.89 P99.9: 1787.02 P99.99: 2275.89 ------------------------------------------------------ [ 0, 1 ] 20328 2.094% 2.094% ( 1, 2 ] 459486 47.321% 49.414% ######### ( 2, 3 ] 244576 25.188% 74.602% ##### ( 3, 4 ] 96901 9.979% 84.582% ## ( 4, 6 ] 113906 11.731% 96.312% ## ( 6, 10 ] 23540 2.424% 98.737% ( 10, 15 ] 6776 0.698% 99.434% ( 15, 22 ] 897 0.092% 99.527% ( 22, 34 ] 63 0.006% 99.533% ( 34, 51 ] 40 0.004% 99.537% ( 51, 76 ] 34 0.004% 99.541% ( 76, 110 ] 16 0.002% 99.543% ( 110, 170 ] 29 0.003% 99.546% ( 170, 250 ] 39 0.004% 99.550% ( 250, 380 ] 119 0.012% 99.562% ( 380, 580 ] 277 0.029% 99.590% ( 580, 870 ] 615 0.063% 99.654% ( 870, 1300 ] 1172 0.121% 99.774% ( 1300, 1900 ] 1503 0.155% 99.929% ( 1900, 2900 ] 1572 0.162% 100.091% ( 2900, 4400 ] 992 0.102% 100.193% ( 4400, 6600 ] 282 0.029% 100.222% ( 6600, 9900 ] 41 0.004% 100.226% ( 9900, 14000 ] 7 0.001% 100.227% ( 14000, 22000 ] 14 0.001% 100.229% ( 22000, 33000 ] 8 0.001% 100.229% ( 33000, 50000 ] 3 0.000% 100.230% ** Level 4 read latency histogram (micros): Count: 180764 Average: 47.6390 StdDev: 418.42 Min: 1 Median: 1.9973 Max: 74229 Percentiles: P50: 2.00 P75: 3.09 P99: 1667.89 P99.9: 4221.98 P99.99: 5645.73 ------------------------------------------------------ [ 0, 1 ] 4577 2.532% 2.532% # ( 1, 2 ] 86034 47.595% 50.127% ########## ( 2, 3 ] 43385 24.001% 74.128% ##### ( 3, 4 ] 17759 9.824% 83.952% ## ( 4, 6 ] 18998 10.510% 94.462% ## ( 6, 10 ] 4539 2.511% 96.973% # ( 10, 15 ] 1127 0.623% 97.596% ( 15, 22 ] 122 0.067% 97.664% ( 22, 34 ] 9 0.005% 97.669% ( 34, 51 ] 6 0.003% 97.672% ( 51, 76 ] 8 0.004% 97.677% ( 76, 110 ] 5 0.003% 97.679% ( 110, 170 ] 28 0.015% 97.695% ( 170, 250 ] 81 0.045% 97.740% ( 250, 380 ] 101 0.056% 97.795% ( 380, 580 ] 233 0.129% 97.924% ( 580, 870 ] 510 0.282% 98.207% ( 870, 1300 ] 858 0.475% 98.681% ( 1300, 1900 ] 940 0.520% 99.201% ( 1900, 2900 ] 812 0.449% 99.650% ( 2900, 4400 ] 512 0.283% 99.934% ( 4400, 6600 ] 180 0.100% 100.033% ( 6600, 9900 ] 33 0.018% 100.051% ( 9900, 14000 ] 1 0.001% 100.052% ( 14000, 22000 ] 1 0.001% 100.053% ( 22000, 33000 ] 3 0.002% 100.054% ( 33000, 50000 ] 2 0.001% 100.055% ( 50000, 75000 ] 1 0.001% 100.056% ** Level 5 read latency histogram (micros): Count: 8253 Average: 2399.5596 StdDev: 2066.60 Min: 97 Median: 1859.8521 Max: 75936 Percentiles: P50: 1859.85 P75: 3366.78 P99: 8916.01 P99.9: 18996.00 P99.99: 75936.00 ------------------------------------------------------ ( 76, 110 ] 2 0.024% 0.024% ( 110, 170 ] 14 0.170% 0.194% ( 170, 250 ] 48 0.582% 0.775% ( 250, 380 ] 170 2.060% 2.835% ( 380, 580 ] 373 4.520% 7.355% # ( 580, 870 ] 838 10.154% 17.509% ## ( 870, 1300 ] 1294 15.679% 33.188% ### ( 1300, 1900 ] 1487 18.018% 51.206% #### ( 1900, 2900 ] 1534 18.587% 69.793% #### ( 2900, 4400 ] 1381 16.733% 86.526% ### ( 4400, 6600 ] 887 10.748% 97.274% ## ( 6600, 9900 ] 203 2.460% 99.733% ( 9900, 14000 ] 10 0.121% 99.855% ( 14000, 22000 ] 6 0.073% 99.927% ( 22000, 33000 ] 3 0.036% 99.964% ( 33000, 50000 ] 2 0.024% 99.988% ( 75000, 110000 ] 1 0.012% 100.000% ** DB Stats ** Uptime(secs): 7.3 total, 7.1 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 135.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:3.327 H:M:S, 45.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 139.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.327 H:M:S, 47.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/12/08-15:11:23 ... thread 0: (1000000,2000000) ops and (205234.1,167527.5) ops/second in (4.872484,11.938336) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 7/6 1.17 GB 6.3 1.3 0.0 1.3 3.1 1.8 0.0 1.7 75.0 178.5 17.63 10.63 27 0.653 1343K 1732 0.0 0.0 L1 3/3 315.33 MB 0.0 1.3 1.0 0.3 1.3 1.0 0.0 1.3 133.7 133.3 10.11 6.30 2 5.057 1373K 3576 0.0 0.0 L2 4/2 307.88 MB 1.4 0.0 0.0 0.0 0.0 0.0 0.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 33/11 2.13 GB 1.4 3.7 1.2 2.5 3.7 1.2 0.3 3.0 128.1 127.2 29.95 18.05 12 2.496 1560K 291 0.0 0.0 L4 162/9 9.72 GB 1.0 5.2 4.1 1.1 5.1 4.0 0.3 1.3 106.0 105.1 49.89 24.96 40 1.247 2108K 3442 0.0 0.0 L5 1120/0 92.15 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1329/31 105.77 GB 0.0 11.5 6.3 5.2 13.2 8.0 5.7 7.4 109.7 125.9 107.59 59.94 81 1.328 6384K 9041 0.0 0.0 Int 0/0 0.00 KB 0.0 11.5 6.3 5.2 13.2 8.0 5.7 7.4 109.7 125.9 107.59 59.94 81 1.328 6384K 9041 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 6.3 5.2 11.4 6.2 0.0 0.0 122.6 121.8 96.26 54.79 58 1.660 6384K 9041 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 161.3 11.33 5.15 23 0.493 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.2 total, 11.9 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 13.23 GB write, 1114.70 MB/s write, 11.52 GB read, 970.72 MB/s read, 107.6 seconds Interval compaction: 13.23 GB write, 1134.58 MB/s write, 11.52 GB read, 988.04 MB/s read, 107.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: 50, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 50, interval: 50 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 598114 Average: 9.3087 StdDev: 149.46 Min: 0 Median: 1.8646 Max: 34216 Percentiles: P50: 1.86 P75: 2.84 P99: 9.83 P99.9: 1722.16 P99.99: 3589.92 ------------------------------------------------------ [ 0, 1 ] 25355 4.239% 4.239% # ( 1, 2 ] 316552 52.925% 57.164% ########### ( 2, 3 ] 127400 21.300% 78.464% #### ( 3, 4 ] 51249 8.568% 87.033% ## ( 4, 6 ] 60564 10.126% 97.159% ## ( 6, 10 ] 11499 1.923% 99.081% ( 10, 15 ] 2540 0.425% 99.506% ( 15, 22 ] 281 0.047% 99.553% ( 22, 34 ] 18 0.003% 99.556% ( 34, 51 ] 26 0.004% 99.560% ( 51, 76 ] 29 0.005% 99.565% ( 76, 110 ] 6 0.001% 99.566% ( 110, 170 ] 55 0.009% 99.575% ( 170, 250 ] 155 0.026% 99.601% ( 250, 380 ] 226 0.038% 99.639% ( 380, 580 ] 383 0.064% 99.703% ( 580, 870 ] 456 0.076% 99.779% ( 870, 1300 ] 451 0.075% 99.855% ( 1300, 1900 ] 385 0.064% 99.919% ( 1900, 2900 ] 323 0.054% 99.973% ( 2900, 4400 ] 220 0.037% 100.010% ( 4400, 6600 ] 64 0.011% 100.021% ( 6600, 9900 ] 11 0.002% 100.022% ( 9900, 14000 ] 6 0.001% 100.023% ( 14000, 22000 ] 4 0.001% 100.024% ( 22000, 33000 ] 2 0.000% 100.024% ( 33000, 50000 ] 1 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 232692 Average: 10.5716 StdDev: 138.69 Min: 1 Median: 1.9738 Max: 15999 Percentiles: P50: 1.97 P75: 2.96 P99: 12.19 P99.9: 2009.63 P99.99: 3820.16 ------------------------------------------------------ [ 0, 1 ] 5136 2.207% 2.207% ( 1, 2 ] 114205 49.080% 51.287% ########## ( 2, 3 ] 57734 24.811% 76.098% ##### ( 3, 4 ] 21221 9.120% 85.218% ## ( 4, 6 ] 25702 11.046% 96.264% ## ( 6, 10 ] 5750 2.471% 98.735% ( 10, 15 ] 1408 0.605% 99.340% ( 15, 22 ] 160 0.069% 99.409% ( 22, 34 ] 13 0.006% 99.414% ( 34, 51 ] 17 0.007% 99.422% ( 51, 76 ] 34 0.015% 99.436% ( 76, 110 ] 6 0.003% 99.439% ( 110, 170 ] 20 0.009% 99.447% ( 170, 250 ] 60 0.026% 99.473% ( 250, 380 ] 127 0.055% 99.528% ( 380, 580 ] 190 0.082% 99.609% ( 580, 870 ] 245 0.105% 99.715% ( 870, 1300 ] 238 0.102% 99.817% ( 1300, 1900 ] 175 0.075% 99.892% ( 1900, 2900 ] 167 0.072% 99.964% ( 2900, 4400 ] 99 0.043% 100.006% ( 4400, 6600 ] 16 0.007% 100.013% ( 6600, 9900 ] 5 0.002% 100.015% ( 9900, 14000 ] 2 0.001% 100.016% ( 14000, 22000 ] 2 0.001% 100.017% ** Level 2 read latency histogram (micros): Count: 241990 Average: 18.7549 StdDev: 217.41 Min: 1 Median: 1.9906 Max: 13201 Percentiles: P50: 1.99 P75: 3.08 P99: 13.78 P99.9: 2870.98 P99.99: 3939.80 ------------------------------------------------------ [ 0, 1 ] 6511 2.691% 2.691% # ( 1, 2 ] 115572 47.759% 50.450% ########## ( 2, 3 ] 57479 23.753% 74.202% ##### ( 3, 4 ] 23198 9.586% 83.789% ## ( 4, 6 ] 28535 11.792% 95.580% ## ( 6, 10 ] 6679 2.760% 98.340% # ( 10, 15 ] 2112 0.873% 99.213% ( 15, 22 ] 351 0.145% 99.358% ( 22, 34 ] 24 0.010% 99.368% ( 34, 51 ] 9 0.004% 99.372% ( 51, 76 ] 5 0.002% 99.374% ( 76, 110 ] 4 0.002% 99.376% ( 110, 170 ] 2 0.001% 99.376% ( 170, 250 ] 3 0.001% 99.378% ( 250, 380 ] 28 0.012% 99.389% ( 380, 580 ] 61 0.025% 99.414% ( 580, 870 ] 98 0.040% 99.455% ( 870, 1300 ] 214 0.088% 99.543% ( 1300, 1900 ] 395 0.163% 99.707% ( 1900, 2900 ] 482 0.199% 99.906% ( 2900, 4400 ] 294 0.121% 100.027% ( 4400, 6600 ] 108 0.045% 100.072% ( 6600, 9900 ] 14 0.006% 100.078% ( 9900, 14000 ] 1 0.000% 100.078% ** Level 3 read latency histogram (micros): Count: 1591279 Average: 13.8936 StdDev: 195.63 Min: 1 Median: 2.0290 Max: 42870 Percentiles: P50: 2.03 P75: 3.01 P99: 11.44 P99.9: 1480.42 P99.99: 2010.80 ------------------------------------------------------ [ 0, 1 ] 27868 1.751% 1.751% ( 1, 2 ] 755932 47.505% 49.256% ########## ( 2, 3 ] 408133 25.648% 74.904% ##### ( 3, 4 ] 156956 9.864% 84.768% ## ( 4, 6 ] 183874 11.555% 96.323% ## ( 6, 10 ] 39479 2.481% 98.804% ( 10, 15 ] 10844 0.681% 99.485% ( 15, 22 ] 1276 0.080% 99.565% ( 22, 34 ] 96 0.006% 99.571% ( 34, 51 ] 133 0.008% 99.580% ( 51, 76 ] 135 0.008% 99.588% ( 76, 110 ] 39 0.002% 99.591% ( 110, 170 ] 103 0.006% 99.597% ( 170, 250 ] 260 0.016% 99.613% ( 250, 380 ] 477 0.030% 99.643% ( 380, 580 ] 762 0.048% 99.691% ( 580, 870 ] 1190 0.075% 99.766% ( 870, 1300 ] 1603 0.101% 99.867% ( 1300, 1900 ] 1755 0.110% 99.977% ( 1900, 2900 ] 1849 0.116% 100.093% ( 2900, 4400 ] 1216 0.076% 100.170% ( 4400, 6600 ] 320 0.020% 100.190% ( 6600, 9900 ] 44 0.003% 100.193% ( 9900, 14000 ] 9 0.001% 100.193% ( 14000, 22000 ] 21 0.001% 100.194% ( 22000, 33000 ] 8 0.001% 100.195% ( 33000, 50000 ] 3 0.000% 100.195% ** Level 4 read latency histogram (micros): Count: 291887 Average: 41.5889 StdDev: 360.60 Min: 1 Median: 2.0121 Max: 74229 Percentiles: P50: 2.01 P75: 3.14 P99: 1320.30 P99.9: 3937.01 P99.99: 4950.64 ------------------------------------------------------ [ 0, 1 ] 6871 2.354% 2.354% ( 1, 2 ] 138229 47.357% 49.711% ######### ( 2, 3 ] 69763 23.901% 73.612% ##### ( 3, 4 ] 28633 9.810% 83.421% ## ( 4, 6 ] 31447 10.774% 94.195% ## ( 6, 10 ] 7462 2.556% 96.751% # ( 10, 15 ] 1868 0.640% 97.391% ( 15, 22 ] 211 0.072% 97.464% ( 22, 34 ] 21 0.007% 97.471% ( 34, 51 ] 18 0.006% 97.477% ( 51, 76 ] 33 0.011% 97.488% ( 76, 110 ] 11 0.004% 97.492% ( 110, 170 ] 112 0.038% 97.531% ( 170, 250 ] 304 0.104% 97.635% ( 250, 380 ] 483 0.165% 97.800% ( 380, 580 ] 865 0.296% 98.097% ( 580, 870 ] 1200 0.411% 98.508% ( 870, 1300 ] 1398 0.479% 98.987% ( 1300, 1900 ] 1186 0.406% 99.393% ( 1900, 2900 ] 1011 0.346% 99.739% ( 2900, 4400 ] 680 0.233% 99.972% ( 4400, 6600 ] 211 0.072% 100.045% ( 6600, 9900 ] 38 0.013% 100.058% ( 9900, 14000 ] 2 0.001% 100.058% ( 14000, 22000 ] 2 0.001% 100.059% ( 22000, 33000 ] 3 0.001% 100.060% ( 33000, 50000 ] 2 0.001% 100.061% ( 50000, 75000 ] 1 0.000% 100.061% ** Level 5 read latency histogram (micros): Count: 23453 Average: 1463.8310 StdDev: 1649.49 Min: 95 Median: 904.4491 Max: 75936 Percentiles: P50: 904.45 P75: 1868.56 P99: 6950.46 P99.9: 13602.85 P99.99: 38564.95 ------------------------------------------------------ ( 76, 110 ] 29 0.124% 0.124% ( 110, 170 ] 576 2.456% 2.580% ( 170, 250 ] 1210 5.159% 7.739% # ( 250, 380 ] 2170 9.253% 16.991% ## ( 380, 580 ] 3362 14.335% 31.326% ### ( 580, 870 ] 4085 17.418% 48.744% ### ( 870, 1300 ] 3676 15.674% 64.418% ### ( 1300, 1900 ] 2619 11.167% 75.585% ## ( 1900, 2900 ] 2366 10.088% 85.673% ## ( 2900, 4400 ] 2058 8.775% 94.448% ## ( 4400, 6600 ] 1044 4.451% 98.900% # ( 6600, 9900 ] 221 0.942% 99.842% ( 9900, 14000 ] 15 0.064% 99.906% ( 14000, 22000 ] 14 0.060% 99.966% ( 22000, 33000 ] 5 0.021% 99.987% ( 33000, 50000 ] 2 0.009% 99.996% ( 75000, 110000 ] 1 0.004% 100.000% ** DB Stats ** Uptime(secs): 12.2 total, 4.9 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 161.95 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:4.362 H:M:S, 35.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 201.99 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.035 H:M:S, 21.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/12/08-15:11:28 ... thread 0: (1000000,3000000) ops and (196987.9,176317.2) ops/second in (5.076453,17.014789) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/10 2.15 GB 81.8 1.8 0.0 1.8 4.6 2.8 0.0 1.7 75.7 189.2 24.96 15.59 43 0.581 1918K 2340 0.0 0.0 L1 3/3 315.33 MB 0.0 1.3 1.0 0.3 1.3 1.0 0.0 1.3 133.7 133.3 10.11 6.30 2 5.057 1373K 3576 0.0 0.0 L3 19/1 1.10 GB 1.0 4.6 1.5 3.0 4.5 1.5 0.3 3.0 130.8 129.9 35.72 21.94 16 2.232 2261K 2654 0.0 0.0 L4 164/6 10.00 GB 1.0 8.4 5.4 3.0 8.3 5.3 0.3 1.5 115.6 114.2 74.29 40.08 57 1.303 4757K 9493 0.0 0.0 L5 1132/0 93.14 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1333/20 106.70 GB 0.0 16.1 7.9 8.2 18.7 10.6 5.9 6.8 113.7 132.3 145.08 83.91 118 1.229 10M 18K 0.0 0.0 Int 0/0 0.00 KB 0.0 16.1 7.9 8.2 18.7 10.6 5.9 6.8 113.7 132.3 145.08 83.91 118 1.229 10M 18K 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 16.1 7.9 8.2 16.0 7.8 0.0 0.0 128.1 127.0 128.81 76.00 81 1.590 10M 18K 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 174.2 16.27 7.91 37 0.440 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): 17.2 total, 17.0 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 18.74 GB write, 1113.91 MB/s write, 16.11 GB read, 957.54 MB/s read, 145.1 seconds Interval compaction: 18.74 GB write, 1127.85 MB/s write, 16.11 GB read, 969.53 MB/s read, 145.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: 62, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 62, interval: 62 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 848587 Average: 12.3848 StdDev: 150.00 Min: 0 Median: 1.8394 Max: 34216 Percentiles: P50: 1.84 P75: 2.80 P99: 186.97 P99.9: 1820.25 P99.99: 3640.20 ------------------------------------------------------ [ 0, 1 ] 44675 5.265% 5.265% # ( 1, 2 ] 452271 53.297% 58.562% ########### ( 2, 3 ] 173980 20.502% 79.064% #### ( 3, 4 ] 68595 8.083% 87.147% ## ( 4, 6 ] 80151 9.445% 96.593% ## ( 6, 10 ] 14673 1.729% 98.322% ( 10, 15 ] 3265 0.385% 98.706% ( 15, 22 ] 354 0.042% 98.748% ( 22, 34 ] 30 0.004% 98.752% ( 34, 51 ] 38 0.004% 98.756% ( 51, 76 ] 38 0.004% 98.761% ( 76, 110 ] 116 0.014% 98.774% ( 110, 170 ] 1461 0.172% 98.946% ( 170, 250 ] 2141 0.252% 99.199% ( 250, 380 ] 1420 0.167% 99.366% ( 380, 580 ] 1481 0.175% 99.541% ( 580, 870 ] 1391 0.164% 99.705% ( 870, 1300 ] 1087 0.128% 99.833% ( 1300, 1900 ] 659 0.078% 99.910% ( 1900, 2900 ] 498 0.059% 99.969% ( 2900, 4400 ] 361 0.043% 100.012% ( 4400, 6600 ] 87 0.010% 100.022% ( 6600, 9900 ] 12 0.001% 100.023% ( 9900, 14000 ] 7 0.001% 100.024% ( 14000, 22000 ] 4 0.000% 100.025% ( 22000, 33000 ] 2 0.000% 100.025% ( 33000, 50000 ] 1 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 308618 Average: 10.7187 StdDev: 139.51 Min: 1 Median: 2.0175 Max: 15999 Percentiles: P50: 2.02 P75: 3.01 P99: 12.61 P99.9: 2080.59 P99.99: 4058.62 ------------------------------------------------------ [ 0, 1 ] 6112 1.980% 1.980% ( 1, 2 ] 146823 47.574% 49.555% ########## ( 2, 3 ] 78362 25.391% 74.946% ##### ( 3, 4 ] 29322 9.501% 84.447% ## ( 4, 6 ] 35966 11.654% 96.101% ## ( 6, 10 ] 7902 2.560% 98.661% # ( 10, 15 ] 2001 0.648% 99.310% ( 15, 22 ] 223 0.072% 99.382% ( 22, 34 ] 18 0.006% 99.388% ( 34, 51 ] 18 0.006% 99.394% ( 51, 76 ] 46 0.015% 99.409% ( 76, 110 ] 12 0.004% 99.413% ( 110, 170 ] 59 0.019% 99.432% ( 170, 250 ] 111 0.036% 99.468% ( 250, 380 ] 174 0.056% 99.524% ( 380, 580 ] 251 0.081% 99.605% ( 580, 870 ] 331 0.107% 99.713% ( 870, 1300 ] 320 0.104% 99.816% ( 1300, 1900 ] 221 0.072% 99.888% ( 1900, 2900 ] 207 0.067% 99.955% ( 2900, 4400 ] 140 0.045% 100.000% ( 4400, 6600 ] 30 0.010% 100.010% ( 6600, 9900 ] 6 0.002% 100.012% ( 9900, 14000 ] 3 0.001% 100.013% ( 14000, 22000 ] 2 0.001% 100.014% ** Level 2 read latency histogram (micros): Count: 241990 Average: 18.7549 StdDev: 217.41 Min: 1 Median: 1.9906 Max: 13201 Percentiles: P50: 1.99 P75: 3.08 P99: 13.78 P99.9: 2870.98 P99.99: 3939.80 ------------------------------------------------------ [ 0, 1 ] 6511 2.691% 2.691% # ( 1, 2 ] 115572 47.759% 50.450% ########## ( 2, 3 ] 57479 23.753% 74.202% ##### ( 3, 4 ] 23198 9.586% 83.789% ## ( 4, 6 ] 28535 11.792% 95.580% ## ( 6, 10 ] 6679 2.760% 98.340% # ( 10, 15 ] 2112 0.873% 99.213% ( 15, 22 ] 351 0.145% 99.358% ( 22, 34 ] 24 0.010% 99.368% ( 34, 51 ] 9 0.004% 99.372% ( 51, 76 ] 5 0.002% 99.374% ( 76, 110 ] 4 0.002% 99.376% ( 110, 170 ] 2 0.001% 99.376% ( 170, 250 ] 3 0.001% 99.378% ( 250, 380 ] 28 0.012% 99.389% ( 380, 580 ] 61 0.025% 99.414% ( 580, 870 ] 98 0.040% 99.455% ( 870, 1300 ] 214 0.088% 99.543% ( 1300, 1900 ] 395 0.163% 99.707% ( 1900, 2900 ] 482 0.199% 99.906% ( 2900, 4400 ] 294 0.121% 100.027% ( 4400, 6600 ] 108 0.045% 100.072% ( 6600, 9900 ] 14 0.006% 100.078% ( 9900, 14000 ] 1 0.000% 100.078% ** Level 3 read latency histogram (micros): Count: 1982544 Average: 12.7017 StdDev: 181.84 Min: 1 Median: 2.0240 Max: 42870 Percentiles: P50: 2.02 P75: 3.00 P99: 11.02 P99.9: 1342.53 P99.99: 1904.45 ------------------------------------------------------ [ 0, 1 ] 34901 1.760% 1.760% ( 1, 2 ] 944206 47.626% 49.386% ########## ( 2, 3 ] 507774 25.612% 74.999% ##### ( 3, 4 ] 194409 9.806% 84.805% ## ( 4, 6 ] 230399 11.621% 96.426% ## ( 6, 10 ] 48408 2.442% 98.868% ( 10, 15 ] 12802 0.646% 99.514% ( 15, 22 ] 1433 0.072% 99.586% ( 22, 34 ] 103 0.005% 99.591% ( 34, 51 ] 185 0.009% 99.600% ( 51, 76 ] 193 0.010% 99.610% ( 76, 110 ] 60 0.003% 99.613% ( 110, 170 ] 186 0.009% 99.622% ( 170, 250 ] 374 0.019% 99.641% ( 250, 380 ] 605 0.031% 99.672% ( 380, 580 ] 1000 0.050% 99.722% ( 580, 870 ] 1489 0.075% 99.797% ( 870, 1300 ] 1899 0.096% 99.893% ( 1300, 1900 ] 1911 0.096% 99.990% ( 1900, 2900 ] 1964 0.099% 100.089% ( 2900, 4400 ] 1332 0.067% 100.156% ( 4400, 6600 ] 354 0.018% 100.174% ( 6600, 9900 ] 52 0.003% 100.176% ( 9900, 14000 ] 10 0.001% 100.177% ( 14000, 22000 ] 21 0.001% 100.178% ( 22000, 33000 ] 8 0.000% 100.178% ( 33000, 50000 ] 3 0.000% 100.178% ** Level 4 read latency histogram (micros): Count: 841843 Average: 25.6153 StdDev: 259.98 Min: 1 Median: 2.0208 Max: 74229 Percentiles: P50: 2.02 P75: 3.06 P99: 613.72 P99.9: 2690.15 P99.99: 3477.48 ------------------------------------------------------ [ 0, 1 ] 16598 1.972% 1.972% ( 1, 2 ] 399957 47.510% 49.481% ########## ( 2, 3 ] 209890 24.932% 74.414% ##### ( 3, 4 ] 79630 9.459% 83.873% ## ( 4, 6 ] 93439 11.099% 94.972% ## ( 6, 10 ] 21720 2.580% 97.552% # ( 10, 15 ] 6055 0.719% 98.271% ( 15, 22 ] 630 0.075% 98.346% ( 22, 34 ] 46 0.005% 98.351% ( 34, 51 ] 50 0.006% 98.357% ( 51, 76 ] 116 0.014% 98.371% ( 76, 110 ] 74 0.009% 98.380% ( 110, 170 ] 751 0.089% 98.469% ( 170, 250 ] 1169 0.139% 98.608% ( 250, 380 ] 1216 0.144% 98.752% ( 380, 580 ] 1806 0.215% 98.967% ( 580, 870 ] 2387 0.284% 99.251% ( 870, 1300 ] 2441 0.290% 99.541% ( 1300, 1900 ] 1852 0.220% 99.761% ( 1900, 2900 ] 1486 0.177% 99.937% ( 2900, 4400 ] 1158 0.138% 100.075% ( 4400, 6600 ] 355 0.042% 100.117% ( 6600, 9900 ] 65 0.008% 100.124% ( 9900, 14000 ] 10 0.001% 100.126% ( 14000, 22000 ] 2 0.000% 100.126% ( 22000, 33000 ] 3 0.000% 100.126% ( 33000, 50000 ] 2 0.000% 100.127% ( 50000, 75000 ] 1 0.000% 100.127% ** Level 5 read latency histogram (micros): Count: 45261 Average: 1085.7143 StdDev: 1389.17 Min: 87 Median: 629.3374 Max: 75936 Percentiles: P50: 629.34 P75: 1269.53 P99: 6321.92 P99.9: 9819.61 P99.99: 27442.58 ------------------------------------------------------ ( 76, 110 ] 310 0.685% 0.685% ( 110, 170 ] 4083 9.021% 9.706% ## ( 170, 250 ] 5548 12.258% 21.964% ## ( 250, 380 ] 5142 11.361% 33.324% ## ( 380, 580 ] 6360 14.052% 47.376% ### ( 580, 870 ] 6980 15.422% 62.798% ### ( 870, 1300 ] 5944 13.133% 75.931% ### ( 1300, 1900 ] 3719 8.217% 84.148% ## ( 1900, 2900 ] 2984 6.593% 90.740% # ( 2900, 4400 ] 2656 5.868% 96.609% # ( 4400, 6600 ] 1239 2.737% 99.346% # ( 6600, 9900 ] 257 0.568% 99.914% ( 9900, 14000 ] 18 0.040% 99.954% ( 14000, 22000 ] 14 0.031% 99.985% ( 22000, 33000 ] 5 0.011% 99.996% ( 33000, 50000 ] 2 0.004% 100.000% ( 75000, 110000 ] 1 0.002% 100.002% ** DB Stats ** Uptime(secs): 17.2 total, 5.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 171.36 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.680 H:M:S, 33.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 193.87 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.317 H:M:S, 25.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/08-15:11:32 ... thread 0: (1000000,4000000) ops and (283379.4,194707.6) ops/second in (3.528838,20.543627) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/10 3.13 GB 182.5 2.8 0.0 2.8 6.6 3.7 0.0 1.8 90.0 209.1 32.21 22.26 63 0.511 2942K 3297 0.0 0.0 L1 3/3 315.33 MB 0.0 1.3 1.0 0.3 1.3 1.0 0.0 1.3 133.7 133.3 10.11 6.30 2 5.057 1373K 3576 0.0 0.0 L3 18/0 997.48 MB 1.0 4.6 1.5 3.0 4.5 1.5 0.3 3.0 130.8 129.9 35.72 21.94 16 2.232 2261K 2654 0.0 0.0 L4 162/0 9.75 GB 1.0 8.8 5.5 3.3 8.7 5.4 0.3 1.6 118.0 116.6 76.72 42.14 58 1.323 5228K 12K 0.0 0.0 L5 1136/0 93.51 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1338/13 107.68 GB 0.0 17.5 8.0 9.5 21.2 11.7 6.2 5.6 116.1 140.0 154.76 92.65 139 1.113 11M 22K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.5 8.0 9.5 21.2 11.7 6.2 5.6 116.1 140.0 154.76 92.65 139 1.113 11M 22K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 17.5 8.0 9.5 17.4 7.9 0.0 0.0 133.0 131.9 135.11 81.85 86 1.571 11M 22K 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 195.5 19.66 10.80 53 0.371 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 20.8 total, 20.5 interval Flush(GB): cumulative 3.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 21.16 GB write, 1043.79 MB/s write, 17.55 GB read, 865.65 MB/s read, 154.8 seconds Interval compaction: 21.16 GB write, 1054.61 MB/s write, 17.55 GB read, 874.62 MB/s read, 154.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 62, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 62, interval: 63 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1131121 Average: 13.3907 StdDev: 134.44 Min: 0 Median: 1.7431 Max: 34216 Percentiles: P50: 1.74 P75: 2.63 P99: 245.99 P99.9: 1415.76 P99.99: 2837.16 ------------------------------------------------------ [ 0, 1 ] 105883 9.361% 9.361% ## ( 1, 2 ] 618582 54.688% 64.048% ########### ( 2, 3 ] 197413 17.453% 81.501% ### ( 3, 4 ] 76008 6.720% 88.221% # ( 4, 6 ] 85458 7.555% 95.776% ## ( 6, 10 ] 15615 1.380% 97.157% ( 10, 15 ] 3516 0.311% 97.467% ( 15, 22 ] 406 0.036% 97.503% ( 22, 34 ] 32 0.003% 97.506% ( 34, 51 ] 39 0.003% 97.510% ( 51, 76 ] 40 0.004% 97.513% ( 76, 110 ] 786 0.069% 97.583% ( 110, 170 ] 8356 0.739% 98.321% ( 170, 250 ] 8082 0.715% 99.036% ( 250, 380 ] 3632 0.321% 99.357% ( 380, 580 ] 2973 0.263% 99.620% ( 580, 870 ] 1868 0.165% 99.785% ( 870, 1300 ] 1173 0.104% 99.889% ( 1300, 1900 ] 668 0.059% 99.948% ( 1900, 2900 ] 511 0.045% 99.993% ( 2900, 4400 ] 368 0.033% 100.025% ( 4400, 6600 ] 87 0.008% 100.033% ( 6600, 9900 ] 12 0.001% 100.034% ( 9900, 14000 ] 7 0.001% 100.035% ( 14000, 22000 ] 4 0.000% 100.035% ( 22000, 33000 ] 2 0.000% 100.035% ( 33000, 50000 ] 1 0.000% 100.035% ** Level 1 read latency histogram (micros): Count: 316783 Average: 10.8805 StdDev: 138.07 Min: 1 Median: 2.0451 Max: 15999 Percentiles: P50: 2.05 P75: 3.08 P99: 13.84 P99.9: 2041.14 P99.99: 4049.88 ------------------------------------------------------ [ 0, 1 ] 6201 1.957% 1.957% ( 1, 2 ] 148567 46.899% 48.856% ######### ( 2, 3 ] 80288 25.345% 74.201% ##### ( 3, 4 ] 30798 9.722% 83.923% ## ( 4, 6 ] 37748 11.916% 95.839% ## ( 6, 10 ] 8367 2.641% 98.480% # ( 10, 15 ] 2141 0.676% 99.156% ( 15, 22 ] 291 0.092% 99.248% ( 22, 34 ] 30 0.009% 99.258% ( 34, 51 ] 19 0.006% 99.264% ( 51, 76 ] 46 0.015% 99.278% ( 76, 110 ] 23 0.007% 99.285% ( 110, 170 ] 236 0.074% 99.360% ( 170, 250 ] 267 0.084% 99.444% ( 250, 380 ] 236 0.074% 99.519% ( 380, 580 ] 290 0.092% 99.610% ( 580, 870 ] 345 0.109% 99.719% ( 870, 1300 ] 323 0.102% 99.821% ( 1300, 1900 ] 221 0.070% 99.891% ( 1900, 2900 ] 207 0.065% 99.956% ( 2900, 4400 ] 140 0.044% 100.000% ( 4400, 6600 ] 30 0.009% 100.010% ( 6600, 9900 ] 6 0.002% 100.012% ( 9900, 14000 ] 3 0.001% 100.013% ( 14000, 22000 ] 2 0.001% 100.013% ** Level 2 read latency histogram (micros): Count: 241990 Average: 18.7549 StdDev: 217.41 Min: 1 Median: 1.9906 Max: 13201 Percentiles: P50: 1.99 P75: 3.08 P99: 13.78 P99.9: 2870.98 P99.99: 3939.80 ------------------------------------------------------ [ 0, 1 ] 6511 2.691% 2.691% # ( 1, 2 ] 115572 47.759% 50.450% ########## ( 2, 3 ] 57479 23.753% 74.202% ##### ( 3, 4 ] 23198 9.586% 83.789% ## ( 4, 6 ] 28535 11.792% 95.580% ## ( 6, 10 ] 6679 2.760% 98.340% # ( 10, 15 ] 2112 0.873% 99.213% ( 15, 22 ] 351 0.145% 99.358% ( 22, 34 ] 24 0.010% 99.368% ( 34, 51 ] 9 0.004% 99.372% ( 51, 76 ] 5 0.002% 99.374% ( 76, 110 ] 4 0.002% 99.376% ( 110, 170 ] 2 0.001% 99.376% ( 170, 250 ] 3 0.001% 99.378% ( 250, 380 ] 28 0.012% 99.389% ( 380, 580 ] 61 0.025% 99.414% ( 580, 870 ] 98 0.040% 99.455% ( 870, 1300 ] 214 0.088% 99.543% ( 1300, 1900 ] 395 0.163% 99.707% ( 1900, 2900 ] 482 0.199% 99.906% ( 2900, 4400 ] 294 0.121% 100.027% ( 4400, 6600 ] 108 0.045% 100.072% ( 6600, 9900 ] 14 0.006% 100.078% ( 9900, 14000 ] 1 0.000% 100.078% ** Level 3 read latency histogram (micros): Count: 2001412 Average: 12.6875 StdDev: 181.05 Min: 1 Median: 2.0170 Max: 42870 Percentiles: P50: 2.02 P75: 3.00 P99: 11.24 P99.9: 1336.90 P99.99: 1903.49 ------------------------------------------------------ [ 0, 1 ] 35937 1.796% 1.796% ( 1, 2 ] 956082 47.770% 49.566% ########## ( 2, 3 ] 511310 25.547% 75.113% ##### ( 3, 4 ] 195138 9.750% 84.863% ## ( 4, 6 ] 231023 11.543% 96.406% ## ( 6, 10 ] 48718 2.434% 98.841% ( 10, 15 ] 12839 0.641% 99.482% ( 15, 22 ] 1436 0.072% 99.554% ( 22, 34 ] 103 0.005% 99.559% ( 34, 51 ] 185 0.009% 99.568% ( 51, 76 ] 193 0.010% 99.578% ( 76, 110 ] 82 0.004% 99.582% ( 110, 170 ] 485 0.024% 99.606% ( 170, 250 ] 592 0.030% 99.636% ( 250, 380 ] 695 0.035% 99.671% ( 380, 580 ] 1062 0.053% 99.724% ( 580, 870 ] 1506 0.075% 99.799% ( 870, 1300 ] 1907 0.095% 99.894% ( 1300, 1900 ] 1912 0.096% 99.990% ( 1900, 2900 ] 1964 0.098% 100.088% ( 2900, 4400 ] 1332 0.067% 100.154% ( 4400, 6600 ] 354 0.018% 100.172% ( 6600, 9900 ] 52 0.003% 100.175% ( 9900, 14000 ] 10 0.000% 100.175% ( 14000, 22000 ] 21 0.001% 100.176% ( 22000, 33000 ] 8 0.000% 100.177% ( 33000, 50000 ] 3 0.000% 100.177% ** Level 4 read latency histogram (micros): Count: 856258 Average: 26.8757 StdDev: 258.68 Min: 1 Median: 2.0307 Max: 74229 Percentiles: P50: 2.03 P75: 3.11 P99: 615.93 P99.9: 2681.03 P99.99: 3475.12 ------------------------------------------------------ [ 0, 1 ] 16909 1.975% 1.975% ( 1, 2 ] 404716 47.266% 49.240% ######### ( 2, 3 ] 211686 24.722% 73.963% ##### ( 3, 4 ] 80065 9.351% 83.313% ## ( 4, 6 ] 94005 10.979% 94.292% ## ( 6, 10 ] 21874 2.555% 96.846% # ( 10, 15 ] 6088 0.711% 97.557% ( 15, 22 ] 633 0.074% 97.631% ( 22, 34 ] 46 0.005% 97.637% ( 34, 51 ] 50 0.006% 97.643% ( 51, 76 ] 116 0.014% 97.656% ( 76, 110 ] 301 0.035% 97.691% ( 110, 170 ] 3296 0.385% 98.076% ( 170, 250 ] 3321 0.388% 98.464% ( 250, 380 ] 1949 0.228% 98.692% ( 380, 580 ] 2326 0.272% 98.963% ( 580, 870 ] 2538 0.296% 99.260% ( 870, 1300 ] 2464 0.288% 99.547% ( 1300, 1900 ] 1855 0.217% 99.764% ( 1900, 2900 ] 1490 0.174% 99.938% ( 2900, 4400 ] 1159 0.135% 100.073% ( 4400, 6600 ] 355 0.041% 100.115% ( 6600, 9900 ] 65 0.008% 100.123% ( 9900, 14000 ] 10 0.001% 100.124% ( 14000, 22000 ] 2 0.000% 100.124% ( 22000, 33000 ] 3 0.000% 100.124% ( 33000, 50000 ] 2 0.000% 100.124% ( 50000, 75000 ] 1 0.000% 100.125% ** Level 5 read latency histogram (micros): Count: 83747 Average: 691.6169 StdDev: 1111.81 Min: 82 Median: 283.3005 Max: 75936 Percentiles: P50: 283.30 P75: 731.74 P99: 5638.55 P99.9: 9325.43 P99.99: 21214.46 ------------------------------------------------------ ( 76, 110 ] 1708 2.039% 2.039% ( 110, 170 ] 19446 23.220% 25.259% ##### ( 170, 250 ] 18234 21.773% 47.032% #### ( 250, 380 ] 9703 11.586% 58.618% ## ( 380, 580 ] 9479 11.319% 69.937% ## ( 580, 870 ] 8104 9.677% 79.614% ## ( 870, 1300 ] 6130 7.320% 86.933% # ( 1300, 1900 ] 3743 4.469% 91.403% # ( 1900, 2900 ] 3007 3.591% 94.993% # ( 2900, 4400 ] 2658 3.174% 98.167% # ( 4400, 6600 ] 1239 1.479% 99.647% ( 6600, 9900 ] 257 0.307% 99.953% ( 9900, 14000 ] 18 0.021% 99.975% ( 14000, 22000 ] 14 0.017% 99.992% ( 22000, 33000 ] 5 0.006% 99.998% ( 33000, 50000 ] 2 0.002% 100.000% ( 75000, 110000 ] 1 0.001% 100.001% ** DB Stats ** Uptime(secs): 20.8 total, 3.5 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 189.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:5.793 H:M:S, 27.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 278.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.114 H:M:S, 3.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/08-15:11:41 ... thread 0: (1000000,5000000) ops and (106006.1,166794.3) ops/second in (9.433420,29.977047) 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 21/12 4.18 GB 163.7 4.1 0.0 4.1 8.9 4.8 0.0 1.8 103.2 225.1 40.27 29.73 85 0.474 4221K 4504 0.0 0.0 L1 3/3 315.33 MB 0.0 1.3 1.0 0.3 1.3 1.0 0.0 1.3 133.7 133.3 10.11 6.30 2 5.057 1373K 3576 0.0 0.0 L3 18/0 997.48 MB 1.0 4.6 1.5 3.0 4.5 1.5 0.3 3.0 130.8 129.9 35.72 21.94 16 2.232 2261K 2654 0.0 0.0 L4 162/0 9.75 GB 1.0 8.8 5.5 3.3 8.7 5.4 0.3 1.6 118.0 116.6 76.72 42.14 58 1.323 5228K 12K 0.0 0.0 L5 1136/0 93.51 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1340/15 108.72 GB 0.0 18.8 8.0 10.7 23.4 12.7 6.2 4.9 118.1 147.4 162.82 100.11 161 1.011 13M 23K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.8 8.0 10.7 23.4 12.7 6.2 4.9 118.1 147.4 162.82 100.11 161 1.011 13M 23K 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.8 8.0 10.7 18.6 7.9 0.0 0.0 137.5 136.5 139.84 86.50 91 1.537 13M 23K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.8 4.8 0.0 0.0 0.0 213.9 22.98 13.62 70 0.328 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): 30.2 total, 30.0 interval Flush(GB): cumulative 4.799, interval 4.799 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 23.44 GB write, 794.82 MB/s write, 18.78 GB read, 636.91 MB/s read, 162.8 seconds Interval compaction: 23.44 GB write, 800.47 MB/s write, 18.78 GB read, 641.43 MB/s read, 162.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 62, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 15, total-stops: 62, interval: 77 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1834557 Average: 14.9049 StdDev: 113.04 Min: 0 Median: 1.6305 Max: 34216 Percentiles: P50: 1.63 P75: 2.35 P99: 249.42 P99.9: 961.52 P99.99: 1865.07 ------------------------------------------------------ [ 0, 1 ] 281725 15.357% 15.357% ### ( 1, 2 ] 1008083 54.950% 70.306% ########### ( 2, 3 ] 247661 13.500% 83.806% ### ( 3, 4 ] 94515 5.152% 88.958% # ( 4, 6 ] 97353 5.307% 94.265% # ( 6, 10 ] 17704 0.965% 95.230% ( 10, 15 ] 3994 0.218% 95.447% ( 15, 22 ] 503 0.027% 95.475% ( 22, 34 ] 44 0.002% 95.477% ( 34, 51 ] 41 0.002% 95.479% ( 51, 76 ] 41 0.002% 95.482% ( 76, 110 ] 3330 0.182% 95.663% ( 110, 170 ] 35595 1.940% 97.603% ( 170, 250 ] 25816 1.407% 99.011% ( 250, 380 ] 7786 0.424% 99.435% ( 380, 580 ] 5618 0.306% 99.741% ( 580, 870 ] 2649 0.144% 99.886% ( 870, 1300 ] 1266 0.069% 99.955% ( 1300, 1900 ] 695 0.038% 99.992% ( 1900, 2900 ] 543 0.030% 100.022% ( 2900, 4400 ] 387 0.021% 100.043% ( 4400, 6600 ] 87 0.005% 100.048% ( 6600, 9900 ] 12 0.001% 100.049% ( 9900, 14000 ] 7 0.000% 100.049% ( 14000, 22000 ] 4 0.000% 100.049% ( 22000, 33000 ] 2 0.000% 100.049% ( 33000, 50000 ] 1 0.000% 100.049% ** Level 1 read latency histogram (micros): Count: 344055 Average: 11.1320 StdDev: 133.27 Min: 1 Median: 2.1251 Max: 15999 Percentiles: P50: 2.13 P75: 3.28 P99: 121.99 P99.9: 1914.16 P99.99: 4020.66 ------------------------------------------------------ [ 0, 1 ] 6558 1.906% 1.906% ( 1, 2 ] 154613 44.938% 46.845% ######### ( 2, 3 ] 86757 25.216% 72.061% ##### ( 3, 4 ] 36152 10.508% 82.568% ## ( 4, 6 ] 43588 12.669% 95.237% ### ( 6, 10 ] 9534 2.771% 98.008% # ( 10, 15 ] 2509 0.729% 98.737% ( 15, 22 ] 483 0.140% 98.878% ( 22, 34 ] 62 0.018% 98.896% ( 34, 51 ] 22 0.006% 98.902% ( 51, 76 ] 47 0.014% 98.916% ( 76, 110 ] 98 0.028% 98.944% ( 110, 170 ] 963 0.280% 99.224% ( 170, 250 ] 731 0.212% 99.437% ( 250, 380 ] 311 0.090% 99.527% ( 380, 580 ] 364 0.106% 99.633% ( 580, 870 ] 370 0.108% 99.740% ( 870, 1300 ] 326 0.095% 99.835% ( 1300, 1900 ] 221 0.064% 99.899% ( 1900, 2900 ] 208 0.060% 99.960% ( 2900, 4400 ] 140 0.041% 100.001% ( 4400, 6600 ] 30 0.009% 100.009% ( 6600, 9900 ] 6 0.002% 100.011% ( 9900, 14000 ] 3 0.001% 100.012% ( 14000, 22000 ] 2 0.001% 100.012% ** Level 2 read latency histogram (micros): Count: 241990 Average: 18.7549 StdDev: 217.41 Min: 1 Median: 1.9906 Max: 13201 Percentiles: P50: 1.99 P75: 3.08 P99: 13.78 P99.9: 2870.98 P99.99: 3939.80 ------------------------------------------------------ [ 0, 1 ] 6511 2.691% 2.691% # ( 1, 2 ] 115572 47.759% 50.450% ########## ( 2, 3 ] 57479 23.753% 74.202% ##### ( 3, 4 ] 23198 9.586% 83.789% ## ( 4, 6 ] 28535 11.792% 95.580% ## ( 6, 10 ] 6679 2.760% 98.340% # ( 10, 15 ] 2112 0.873% 99.213% ( 15, 22 ] 351 0.145% 99.358% ( 22, 34 ] 24 0.010% 99.368% ( 34, 51 ] 9 0.004% 99.372% ( 51, 76 ] 5 0.002% 99.374% ( 76, 110 ] 4 0.002% 99.376% ( 110, 170 ] 2 0.001% 99.376% ( 170, 250 ] 3 0.001% 99.378% ( 250, 380 ] 28 0.012% 99.389% ( 380, 580 ] 61 0.025% 99.414% ( 580, 870 ] 98 0.040% 99.455% ( 870, 1300 ] 214 0.088% 99.543% ( 1300, 1900 ] 395 0.163% 99.707% ( 1900, 2900 ] 482 0.199% 99.906% ( 2900, 4400 ] 294 0.121% 100.027% ( 4400, 6600 ] 108 0.045% 100.072% ( 6600, 9900 ] 14 0.006% 100.078% ( 9900, 14000 ] 1 0.000% 100.078% ** Level 3 read latency histogram (micros): Count: 2003974 Average: 12.9139 StdDev: 181.09 Min: 1 Median: 2.0195 Max: 42870 Percentiles: P50: 2.02 P75: 3.00 P99: 12.22 P99.9: 1336.10 P99.99: 1903.36 ------------------------------------------------------ [ 0, 1 ] 35937 1.793% 1.793% ( 1, 2 ] 956083 47.709% 49.503% ########## ( 2, 3 ] 511319 25.515% 75.018% ##### ( 3, 4 ] 195141 9.738% 84.756% ## ( 4, 6 ] 231028 11.528% 96.284% ## ( 6, 10 ] 48719 2.431% 98.715% ( 10, 15 ] 12839 0.641% 99.356% ( 15, 22 ] 1436 0.072% 99.428% ( 22, 34 ] 103 0.005% 99.433% ( 34, 51 ] 185 0.009% 99.442% ( 51, 76 ] 193 0.010% 99.452% ( 76, 110 ] 206 0.010% 99.462% ( 110, 170 ] 1781 0.089% 99.551% ( 170, 250 ] 1376 0.069% 99.619% ( 250, 380 ] 888 0.044% 99.664% ( 380, 580 ] 1177 0.059% 99.722% ( 580, 870 ] 1531 0.076% 99.799% ( 870, 1300 ] 1913 0.095% 99.894% ( 1300, 1900 ] 1912 0.095% 99.990% ( 1900, 2900 ] 1964 0.098% 100.088% ( 2900, 4400 ] 1332 0.066% 100.154% ( 4400, 6600 ] 354 0.018% 100.172% ( 6600, 9900 ] 52 0.003% 100.174% ( 9900, 14000 ] 10 0.000% 100.175% ( 14000, 22000 ] 21 0.001% 100.176% ( 22000, 33000 ] 8 0.000% 100.176% ( 33000, 50000 ] 3 0.000% 100.176% ** Level 4 read latency histogram (micros): Count: 878932 Average: 30.9482 StdDev: 257.31 Min: 1 Median: 2.0838 Max: 74229 Percentiles: P50: 2.08 P75: 3.32 P99: 624.23 P99.9: 2667.38 P99.99: 3471.69 ------------------------------------------------------ [ 0, 1 ] 16909 1.924% 1.924% ( 1, 2 ] 404790 46.055% 47.979% ######### ( 2, 3 ] 212110 24.133% 72.111% ##### ( 3, 4 ] 80271 9.133% 81.244% ## ( 4, 6 ] 94330 10.732% 91.976% ## ( 6, 10 ] 21921 2.494% 94.470% ( 10, 15 ] 6102 0.694% 95.165% ( 15, 22 ] 633 0.072% 95.237% ( 22, 34 ] 46 0.005% 95.242% ( 34, 51 ] 50 0.006% 95.248% ( 51, 76 ] 116 0.013% 95.261% ( 76, 110 ] 1470 0.167% 95.428% ( 110, 170 ] 14207 1.616% 97.044% ( 170, 250 ] 9993 1.137% 98.181% ( 250, 380 ] 3411 0.388% 98.570% ( 380, 580 ] 3354 0.382% 98.951% ( 580, 870 ] 2817 0.321% 99.272% ( 870, 1300 ] 2512 0.286% 99.557% ( 1300, 1900 ] 1860 0.212% 99.769% ( 1900, 2900 ] 1500 0.171% 99.940% ( 2900, 4400 ] 1160 0.132% 100.072% ( 4400, 6600 ] 355 0.040% 100.112% ( 6600, 9900 ] 65 0.007% 100.119% ( 9900, 14000 ] 10 0.001% 100.121% ( 14000, 22000 ] 2 0.000% 100.121% ( 22000, 33000 ] 3 0.000% 100.121% ( 33000, 50000 ] 2 0.000% 100.121% ( 50000, 75000 ] 1 0.000% 100.122% ** Level 5 read latency histogram (micros): Count: 204877 Average: 396.7251 StdDev: 757.31 Min: 81 Median: 188.6997 Max: 75936 Percentiles: P50: 188.70 P75: 314.29 P99: 4110.59 P99.9: 7757.22 P99.99: 13888.91 ------------------------------------------------------ ( 76, 110 ] 8110 3.958% 3.958% # ( 110, 170 ] 81422 39.742% 43.700% ######## ( 170, 250 ] 55216 26.951% 70.651% ##### ( 250, 380 ] 18017 8.794% 79.445% ## ( 380, 580 ] 15033 7.338% 86.783% # ( 580, 870 ] 9679 4.724% 91.507% # ( 870, 1300 ] 6370 3.109% 94.616% # ( 1300, 1900 ] 3784 1.847% 96.463% ( 1900, 2900 ] 3044 1.486% 97.949% ( 2900, 4400 ] 2668 1.302% 99.251% ( 4400, 6600 ] 1239 0.605% 99.856% ( 6600, 9900 ] 257 0.125% 99.981% ( 9900, 14000 ] 18 0.009% 99.990% ( 14000, 22000 ] 14 0.007% 99.997% ( 22000, 33000 ] 5 0.002% 100.000% ( 33000, 50000 ] 2 0.001% 100.000% ( 75000, 110000 ] 1 0.000% 100.001% ** DB Stats ** Uptime(secs): 30.2 total, 9.4 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 162.98 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:11.566 H:M:S, 38.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 104.32 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:5.773 H:M:S, 61.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 0 2024/12/08-15:11:48 ... thread 0: (1000000,6000000) ops and (141458.1,161959.6) ops/second in (7.069229,37.046276) 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 5.03 GB 294.8 6.5 0.0 6.5 12.2 5.6 0.0 2.1 127.3 237.5 52.46 41.36 104 0.504 6779K 15K 0.0 0.0 L1 3/3 315.33 MB 0.0 1.3 1.0 0.3 1.3 1.0 0.0 1.3 133.7 133.3 10.11 6.30 2 5.057 1373K 3576 0.0 0.0 L3 18/0 997.48 MB 1.0 4.6 1.5 3.0 4.5 1.5 0.3 3.0 130.8 129.9 35.72 21.94 16 2.232 2261K 2654 0.0 0.0 L4 162/0 9.75 GB 1.0 8.8 5.5 3.3 8.7 5.4 0.3 1.6 118.0 116.6 76.72 42.14 58 1.323 5228K 12K 0.0 0.0 L5 1136/0 93.51 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1337/14 109.57 GB 0.0 21.2 8.0 13.2 26.7 13.6 6.2 4.7 124.3 156.5 175.00 111.75 180 0.972 15M 34K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.2 8.0 13.2 26.7 13.6 6.2 4.7 124.3 156.5 175.00 111.75 180 0.972 15M 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 21.2 8.0 13.2 21.1 7.9 0.0 0.0 145.7 144.7 149.24 95.77 96 1.555 15M 34K 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 225.0 25.76 15.98 84 0.307 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): 37.3 total, 37.0 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: 26.75 GB write, 735.01 MB/s write, 21.24 GB read, 583.67 MB/s read, 175.0 seconds Interval compaction: 26.75 GB write, 739.23 MB/s write, 21.24 GB read, 587.03 MB/s read, 175.0 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: 62, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 23, total-stops: 62, interval: 85 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2377173 Average: 15.5306 StdDev: 104.20 Min: 0 Median: 1.5968 Max: 34216 Percentiles: P50: 1.60 P75: 2.22 P99: 254.92 P99.9: 817.22 P99.99: 1452.15 ------------------------------------------------------ [ 0, 1 ] 403853 16.989% 16.989% ### ( 1, 2 ] 1314819 55.310% 72.299% ########### ( 2, 3 ] 290423 12.217% 84.516% ## ( 3, 4 ] 110538 4.650% 89.166% # ( 4, 6 ] 107668 4.529% 93.695% # ( 6, 10 ] 19622 0.825% 94.521% ( 10, 15 ] 4420 0.186% 94.707% ( 15, 22 ] 598 0.025% 94.732% ( 22, 34 ] 60 0.003% 94.734% ( 34, 51 ] 43 0.002% 94.736% ( 51, 76 ] 60 0.003% 94.739% ( 76, 110 ] 5401 0.227% 94.966% ( 110, 170 ] 56014 2.356% 97.322% ( 170, 250 ] 39460 1.660% 98.982% ( 250, 380 ] 11243 0.473% 99.455% ( 380, 580 ] 7875 0.331% 99.786% ( 580, 870 ] 3303 0.139% 99.925% ( 870, 1300 ] 1359 0.057% 99.983% ( 1300, 1900 ] 707 0.030% 100.012% ( 1900, 2900 ] 567 0.024% 100.036% ( 2900, 4400 ] 398 0.017% 100.053% ( 4400, 6600 ] 88 0.004% 100.057% ( 6600, 9900 ] 12 0.001% 100.057% ( 9900, 14000 ] 7 0.000% 100.057% ( 14000, 22000 ] 4 0.000% 100.058% ( 22000, 33000 ] 2 0.000% 100.058% ( 33000, 50000 ] 1 0.000% 100.058% ** Level 1 read latency histogram (micros): Count: 362596 Average: 11.2177 StdDev: 130.27 Min: 1 Median: 2.1434 Max: 15999 Percentiles: P50: 2.14 P75: 3.31 P99: 146.95 P99.9: 1857.66 P99.99: 4000.79 ------------------------------------------------------ [ 0, 1 ] 7339 2.024% 2.024% ( 1, 2 ] 160793 44.345% 46.369% ######### ( 2, 3 ] 91835 25.327% 71.696% ##### ( 3, 4 ] 38634 10.655% 82.351% ## ( 4, 6 ] 45837 12.641% 94.992% ### ( 6, 10 ] 10126 2.793% 97.785% # ( 10, 15 ] 2681 0.739% 98.524% ( 15, 22 ] 541 0.149% 98.673% ( 22, 34 ] 74 0.020% 98.694% ( 34, 51 ] 22 0.006% 98.700% ( 51, 76 ] 47 0.013% 98.713% ( 76, 110 ] 150 0.041% 98.754% ( 110, 170 ] 1447 0.399% 99.153% ( 170, 250 ] 1016 0.280% 99.434% ( 250, 380 ] 367 0.101% 99.535% ( 380, 580 ] 406 0.112% 99.647% ( 580, 870 ] 387 0.107% 99.753% ( 870, 1300 ] 326 0.090% 99.843% ( 1300, 1900 ] 221 0.061% 99.904% ( 1900, 2900 ] 208 0.057% 99.962% ( 2900, 4400 ] 140 0.039% 100.000% ( 4400, 6600 ] 30 0.008% 100.009% ( 6600, 9900 ] 6 0.002% 100.010% ( 9900, 14000 ] 3 0.001% 100.011% ( 14000, 22000 ] 2 0.001% 100.012% ** Level 2 read latency histogram (micros): Count: 241990 Average: 18.7549 StdDev: 217.41 Min: 1 Median: 1.9906 Max: 13201 Percentiles: P50: 1.99 P75: 3.08 P99: 13.78 P99.9: 2870.98 P99.99: 3939.80 ------------------------------------------------------ [ 0, 1 ] 6511 2.691% 2.691% # ( 1, 2 ] 115572 47.759% 50.450% ########## ( 2, 3 ] 57479 23.753% 74.202% ##### ( 3, 4 ] 23198 9.586% 83.789% ## ( 4, 6 ] 28535 11.792% 95.580% ## ( 6, 10 ] 6679 2.760% 98.340% # ( 10, 15 ] 2112 0.873% 99.213% ( 15, 22 ] 351 0.145% 99.358% ( 22, 34 ] 24 0.010% 99.368% ( 34, 51 ] 9 0.004% 99.372% ( 51, 76 ] 5 0.002% 99.374% ( 76, 110 ] 4 0.002% 99.376% ( 110, 170 ] 2 0.001% 99.376% ( 170, 250 ] 3 0.001% 99.378% ( 250, 380 ] 28 0.012% 99.389% ( 380, 580 ] 61 0.025% 99.414% ( 580, 870 ] 98 0.040% 99.455% ( 870, 1300 ] 214 0.088% 99.543% ( 1300, 1900 ] 395 0.163% 99.707% ( 1900, 2900 ] 482 0.199% 99.906% ( 2900, 4400 ] 294 0.121% 100.027% ( 4400, 6600 ] 108 0.045% 100.072% ( 6600, 9900 ] 14 0.006% 100.078% ( 9900, 14000 ] 1 0.000% 100.078% ** Level 3 read latency histogram (micros): Count: 2005810 Average: 13.0828 StdDev: 181.14 Min: 1 Median: 2.0213 Max: 42870 Percentiles: P50: 2.02 P75: 3.01 P99: 12.93 P99.9: 1336.15 P99.99: 1904.28 ------------------------------------------------------ [ 0, 1 ] 35937 1.792% 1.792% ( 1, 2 ] 956083 47.666% 49.457% ########## ( 2, 3 ] 511319 25.492% 74.949% ##### ( 3, 4 ] 195141 9.729% 84.678% ## ( 4, 6 ] 231028 11.518% 96.196% ## ( 6, 10 ] 48719 2.429% 98.625% ( 10, 15 ] 12839 0.640% 99.265% ( 15, 22 ] 1436 0.072% 99.337% ( 22, 34 ] 103 0.005% 99.342% ( 34, 51 ] 185 0.009% 99.351% ( 51, 76 ] 193 0.010% 99.361% ( 76, 110 ] 277 0.014% 99.374% ( 110, 170 ] 2695 0.134% 99.509% ( 170, 250 ] 1973 0.098% 99.607% ( 250, 380 ] 1027 0.051% 99.658% ( 380, 580 ] 1266 0.063% 99.721% ( 580, 870 ] 1550 0.077% 99.799% ( 870, 1300 ] 1918 0.096% 99.894% ( 1300, 1900 ] 1912 0.095% 99.990% ( 1900, 2900 ] 1965 0.098% 100.088% ( 2900, 4400 ] 1333 0.066% 100.154% ( 4400, 6600 ] 354 0.018% 100.172% ( 6600, 9900 ] 52 0.003% 100.174% ( 9900, 14000 ] 10 0.000% 100.175% ( 14000, 22000 ] 21 0.001% 100.176% ( 22000, 33000 ] 8 0.000% 100.176% ( 33000, 50000 ] 3 0.000% 100.176% ** Level 4 read latency histogram (micros): Count: 895174 Average: 33.9092 StdDev: 256.37 Min: 1 Median: 2.1220 Max: 74229 Percentiles: P50: 2.12 P75: 3.47 P99: 630.25 P99.9: 2657.70 P99.99: 3470.39 ------------------------------------------------------ [ 0, 1 ] 16909 1.889% 1.889% ( 1, 2 ] 404799 45.220% 47.109% ######### ( 2, 3 ] 212138 23.698% 70.807% ##### ( 3, 4 ] 80288 8.969% 79.776% ## ( 4, 6 ] 94355 10.540% 90.316% ## ( 6, 10 ] 21927 2.449% 92.766% ( 10, 15 ] 6102 0.682% 93.448% ( 15, 22 ] 633 0.071% 93.518% ( 22, 34 ] 46 0.005% 93.523% ( 34, 51 ] 50 0.006% 93.529% ( 51, 76 ] 116 0.013% 93.542% ( 76, 110 ] 2339 0.261% 93.803% ( 110, 170 ] 22251 2.486% 96.289% ( 170, 250 ] 14962 1.671% 97.960% ( 250, 380 ] 4628 0.517% 98.477% ( 380, 580 ] 4152 0.464% 98.941% ( 580, 870 ] 3043 0.340% 99.281% ( 870, 1300 ] 2539 0.284% 99.565% ( 1300, 1900 ] 1863 0.208% 99.773% ( 1900, 2900 ] 1503 0.168% 99.941% ( 2900, 4400 ] 1161 0.130% 100.070% ( 4400, 6600 ] 355 0.040% 100.110% ( 6600, 9900 ] 65 0.007% 100.117% ( 9900, 14000 ] 10 0.001% 100.118% ( 14000, 22000 ] 2 0.000% 100.119% ( 22000, 33000 ] 3 0.000% 100.119% ( 33000, 50000 ] 2 0.000% 100.119% ( 50000, 75000 ] 1 0.000% 100.119% ** Level 5 read latency histogram (micros): Count: 291529 Average: 337.0138 StdDev: 644.79 Min: 81 Median: 178.2017 Max: 75936 Percentiles: P50: 178.20 P75: 249.43 P99: 3625.16 P99.9: 6644.57 P99.99: 11915.17 ------------------------------------------------------ ( 76, 110 ] 12427 4.263% 4.263% # ( 110, 170 ] 124945 42.859% 47.121% ######### ( 170, 250 ] 81861 28.080% 75.201% ###### ( 250, 380 ] 24410 8.373% 83.574% ## ( 380, 580 ] 19335 6.632% 90.206% # ( 580, 870 ] 10959 3.759% 93.966% # ( 870, 1300 ] 6510 2.233% 96.199% ( 1300, 1900 ] 3798 1.303% 97.501% ( 1900, 2900 ] 3076 1.055% 98.557% ( 2900, 4400 ] 2674 0.917% 99.474% ( 4400, 6600 ] 1239 0.425% 99.899% ( 6600, 9900 ] 257 0.088% 99.987% ( 9900, 14000 ] 18 0.006% 99.993% ( 14000, 22000 ] 14 0.005% 99.998% ( 22000, 33000 ] 5 0.002% 100.000% ( 33000, 50000 ] 2 0.001% 100.000% ( 75000, 110000 ] 1 0.000% 100.001% ** DB Stats ** Uptime(secs): 37.3 total, 7.1 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 158.48 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:14.968 H:M:S, 40.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 139.24 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.402 H:M:S, 48.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] readwhilewriting : 294.054 micros/op 13578 ops/sec 60.170 seconds 816996 operations; 13.2 MB/s (207999 of 207999 found) Microseconds per read: Count: 816996 Average: 294.0568 StdDev: 952.77 Min: 2 Median: 202.6436 Max: 124319 Percentiles: P50: 202.64 P75: 248.18 P99: 1695.63 P99.9: 17061.63 P99.99: 32940.84 ------------------------------------------------------ ( 1, 2 ] 7 0.001% 0.001% ( 2, 3 ] 35 0.004% 0.005% ( 3, 4 ] 47 0.006% 0.011% ( 4, 6 ] 75 0.009% 0.020% ( 6, 10 ] 316 0.039% 0.059% ( 10, 15 ] 3526 0.432% 0.490% ( 15, 22 ] 4134 0.506% 0.996% ( 22, 34 ] 7296 0.893% 1.889% ( 34, 51 ] 2198 0.269% 2.158% ( 51, 76 ] 358 0.044% 2.202% ( 76, 110 ] 3281 0.402% 2.604% ( 110, 170 ] 240817 29.476% 32.080% ###### ( 170, 250 ] 358804 43.917% 75.997% ######### ( 250, 380 ] 100878 12.347% 88.345% ## ( 380, 580 ] 52865 6.471% 94.815% # ( 580, 870 ] 21873 2.677% 97.493% # ( 870, 1300 ] 9631 1.179% 98.671% ( 1300, 1900 ] 4072 0.498% 99.170% ( 1900, 2900 ] 2723 0.333% 99.503% ( 2900, 4400 ] 2034 0.249% 99.752% ( 4400, 6600 ] 611 0.075% 99.827% ( 6600, 9900 ] 150 0.018% 99.845% ( 9900, 14000 ] 187 0.023% 99.868% ( 14000, 22000 ] 682 0.083% 99.952% ( 22000, 33000 ] 316 0.039% 99.990% ( 33000, 50000 ] 55 0.007% 99.997% ( 50000, 75000 ] 22 0.003% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 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 : 13735792 rocksdb.bloom.filter.full.positive COUNT : 950104 rocksdb.bloom.filter.full.true.positive COUNT : 816600 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 : 396 rocksdb.memtable.miss COUNT : 816600 rocksdb.l0.hit COUNT : 34033 rocksdb.l1.hit COUNT : 6384 rocksdb.l2andup.hit COUNT : 776183 rocksdb.compaction.key.drop.new COUNT : 183896 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 : 6201365 rocksdb.number.keys.read COUNT : 816996 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 6399808680 rocksdb.bytes.read COUNT : 816996000 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 : 1677 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 36689268 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 : 26035194437 rocksdb.compact.write.bytes COUNT : 25841549190 rocksdb.flush.write.bytes COUNT : 6341705269 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 : 31 rocksdb.number.superversion_acquires COUNT : 1205 rocksdb.number.superversion_releases COUNT : 1174 rocksdb.number.superversion_cleanups COUNT : 309 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 : 337 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 : 6290395136 rocksdb.memtable.garbage.bytes.at.flush COUNT : 2283520 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 : 29925025640 rocksdb.non.last.level.read.count COUNT : 7088177 rocksdb.block.checksum.compute.count COUNT : 7264951 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 : 201.768105 P95 : 598.176798 P99 : 1694.536585 P100 : 124317.000000 COUNT : 816996 SUM : 239545558 rocksdb.db.write.micros P50 : 1.531352 P95 : 4.372472 P99 : 9.206771 P100 : 827739.000000 COUNT : 6201365 SUM : 52170642 rocksdb.compaction.times.micros P50 : 1253846.153846 P95 : 4355000.000000 P99 : 22220000.000000 P100 : 31453501.000000 COUNT : 98 SUM : 184783730 rocksdb.compaction.times.cpu_micros P50 : 845500.000000 P95 : 2946666.666667 P99 : 9884000.000000 P100 : 10074537.000000 COUNT : 98 SUM : 109875534 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 : 1054.285714 P95 : 13672.000000 P99 : 79200.000000 P100 : 80330.000000 COUNT : 88 SUM : 331127 rocksdb.compaction.outfile.sync.micros P50 : 7150.000000 P95 : 79593.750000 P99 : 175600.000000 P100 : 209854.000000 COUNT : 279 SUM : 5219251 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 : 315.000000 P95 : 4650.000000 P99 : 6370.000000 P100 : 38999.000000 COUNT : 215 SUM : 261014 rocksdb.table.open.io.micros P50 : 11604.990215 P95 : 21539.669421 P99 : 30461.372549 P100 : 118488.000000 COUNT : 1677 SUM : 18894045 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.917136 P95 : 10.184812 P99 : 221.141645 P100 : 42873.000000 COUNT : 6304012 SUM : 105937209 rocksdb.read.block.get.micros P50 : 157.237599 P95 : 496.378348 P99 : 1669.291513 P100 : 76009.000000 COUNT : 959305 SUM : 206559779 rocksdb.write.raw.block.micros P50 : 0.529931 P95 : 1.175220 P99 : 3.467804 P100 : 53703.000000 COUNT : 7794690 SUM : 23890392 rocksdb.numfiles.in.singlecompaction P50 : 2.886364 P95 : 5.871429 P99 : 13.550000 P100 : 23.000000 COUNT : 129 SUM : 449 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.568720 P95 : 1230.959319 P99 : 2628.153417 P100 : 827578.000000 COUNT : 186945 SUM : 36708163 rocksdb.sst.read.micros P50 : 1.983115 P95 : 192.910092 P99 : 520.011825 P100 : 75936.000000 COUNT : 7088295 SUM : 295575098 rocksdb.num.subcompactions.scheduled P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.bytes.per.read P50 : 1000.000000 P95 : 1000.000000 P99 : 1000.000000 P100 : 1000.000000 COUNT : 816996 SUM : 816996000 rocksdb.bytes.per.write P50 : 1032.000000 P95 : 1032.000000 P99 : 1032.000000 P100 : 1032.000000 COUNT : 6201365 SUM : 6399808680 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 : 225873.015873 P95 : 792333.333333 P99 : 1054725.000000 P100 : 1054725.000000 COUNT : 88 SUM : 26611622 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 : 337 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