[2024-07-15 10:57:43.892506] Starting SPDK v24.09-pre git sha1 719d03c6a / DPDK 22.11.4 initialization... [2024-07-15 10:57:43.892830] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=lib.power:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid297773 ] Set seed to 1721033863885220 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-15 10:57:44.014257] app.c: 908:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-15 10:57:44.059092] app.c: 603:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-15 10:57:44.059147] app.c: 604:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 297773' to capture a snapshot of events at runtime. [2024-07-15 10:57:44.059160] app.c: 609:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-15 10:57:44.059177] app.c: 610:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-15 10:57:44.059186] app.c: 611:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid297773 for offline analysis/debug. [2024-07-15 10:57:44.059305] reactor.c: 941:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Mon Jul 15 10:57:45 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/07/15-10:57:53 ... thread 0: (1000000,1000000) ops and (129013.5,129013.5) ops/second in (7.751125,7.751125) 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 566.91 MB 12.6 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 121.0 6.77 2.45 10 0.677 0 0 0.0 0.0 L1 1/1 121.78 MB 0.0 0.5 0.3 0.2 0.5 0.3 0.0 1.9 157.6 157.5 3.24 2.57 3 1.081 519K 245 0.0 0.0 L2 9/3 432.66 MB 2.5 0.6 0.2 0.3 0.6 0.2 0.1 2.5 116.7 116.3 5.04 2.92 4 1.261 575K 961 0.0 0.0 L3 45/11 3.60 GB 2.8 2.9 2.0 0.9 2.9 1.9 0.0 1.4 101.0 99.7 29.37 16.19 12 2.448 2234K 2550 0.0 0.0 L4 201/16 11.77 GB 1.1 3.4 2.0 1.4 3.4 1.9 0.1 1.7 119.8 117.3 29.44 17.29 21 1.402 1498K 258 0.0 0.0 L5 1156/0 90.48 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 1419/37 106.94 GB 0.0 7.4 4.5 2.9 8.1 5.2 0.2 10.1 102.8 112.3 73.87 41.42 50 1.477 4827K 4014 0.0 0.0 Int 0/0 0.00 KB 0.0 7.4 4.5 2.9 8.1 5.2 0.2 10.1 102.8 112.3 73.87 41.42 50 1.477 4827K 4014 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.4 4.5 2.9 7.3 4.4 0.0 0.0 113.2 111.5 67.10 38.97 40 1.678 4827K 4014 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 121.0 6.77 2.45 10 0.677 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.9 total, 7.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: 8.10 GB write, 1047.09 MB/s write, 7.42 GB read, 958.22 MB/s read, 73.9 seconds Interval compaction: 8.10 GB write, 1070.30 MB/s write, 7.42 GB read, 979.45 MB/s read, 73.9 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: 30, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 30, interval: 30 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 86798 Average: 13.8131 StdDev: 195.77 Min: 1 Median: 1.9492 Max: 30516 Percentiles: P50: 1.95 P75: 2.97 P99: 20.20 P99.9: 2950.05 P99.99: 6058.13 ------------------------------------------------------ [ 0, 1 ] 2896 3.336% 3.336% # ( 1, 2 ] 42669 49.159% 52.495% ########## ( 2, 3 ] 20094 23.150% 75.646% ##### ( 3, 4 ] 9269 10.679% 86.325% ## ( 4, 6 ] 9020 10.392% 96.717% ## ( 6, 10 ] 1634 1.883% 98.599% ( 10, 15 ] 323 0.372% 98.971% ( 15, 22 ] 35 0.040% 99.011% ( 22, 34 ] 9 0.010% 99.022% ( 34, 51 ] 2 0.002% 99.024% ( 51, 76 ] 8 0.009% 99.033% ( 76, 110 ] 6 0.007% 99.040% ( 110, 170 ] 6 0.007% 99.047% ( 170, 250 ] 66 0.076% 99.123% ( 250, 380 ] 121 0.139% 99.263% ( 380, 580 ] 219 0.252% 99.515% ( 580, 870 ] 155 0.179% 99.694% ( 870, 1300 ] 77 0.089% 99.782% ( 1300, 1900 ] 37 0.043% 99.825% ( 1900, 2900 ] 64 0.074% 99.899% ( 2900, 4400 ] 66 0.076% 99.975% ( 4400, 6600 ] 19 0.022% 99.997% ( 6600, 9900 ] 2 0.002% 99.999% ( 14000, 22000 ] 1 0.001% 100.000% ( 22000, 33000 ] 1 0.001% 100.001% ** Level 1 read latency histogram (micros): Count: 146408 Average: 9.0075 StdDev: 186.09 Min: 1 Median: 2.0925 Max: 31839 Percentiles: P50: 2.09 P75: 3.24 P99: 9.97 P99.9: 1826.53 P99.99: 4449.39 ------------------------------------------------------ [ 0, 1 ] 3281 2.241% 2.241% ( 1, 2 ] 66619 45.502% 47.743% ######### ( 2, 3 ] 35735 24.408% 72.151% ##### ( 3, 4 ] 17603 12.023% 84.174% ## ( 4, 6 ] 18222 12.446% 96.620% ## ( 6, 10 ] 3508 2.396% 99.016% ( 10, 15 ] 801 0.547% 99.564% ( 15, 22 ] 126 0.086% 99.650% ( 22, 34 ] 36 0.025% 99.674% ( 34, 51 ] 22 0.015% 99.689% ( 51, 76 ] 30 0.020% 99.710% ( 76, 110 ] 15 0.010% 99.720% ( 110, 170 ] 13 0.009% 99.729% ( 170, 250 ] 15 0.010% 99.739% ( 250, 380 ] 38 0.026% 99.765% ( 380, 580 ] 63 0.043% 99.808% ( 580, 870 ] 57 0.039% 99.847% ( 870, 1300 ] 46 0.031% 99.878% ( 1300, 1900 ] 36 0.025% 99.903% ( 1900, 2900 ] 51 0.035% 99.938% ( 2900, 4400 ] 76 0.052% 99.990% ( 4400, 6600 ] 16 0.011% 100.001% ( 6600, 9900 ] 13 0.009% 100.010% ( 9900, 14000 ] 1 0.001% 100.010% ( 22000, 33000 ] 3 0.002% 100.012% ** Level 2 read latency histogram (micros): Count: 530374 Average: 14.6489 StdDev: 311.38 Min: 1 Median: 2.1579 Max: 60337 Percentiles: P50: 2.16 P75: 3.36 P99: 12.08 P99.9: 1237.92 P99.99: 2747.85 ------------------------------------------------------ [ 0, 1 ] 9550 1.801% 1.801% ( 1, 2 ] 235180 44.342% 46.143% ######### ( 2, 3 ] 129530 24.422% 70.565% ##### ( 3, 4 ] 66144 12.471% 83.036% ## ( 4, 6 ] 65663 12.381% 95.417% ## ( 6, 10 ] 17282 3.258% 98.675% # ( 10, 15 ] 4140 0.781% 99.456% ( 15, 22 ] 640 0.121% 99.577% ( 22, 34 ] 138 0.026% 99.603% ( 34, 51 ] 90 0.017% 99.620% ( 51, 76 ] 113 0.021% 99.641% ( 76, 110 ] 54 0.010% 99.651% ( 110, 170 ] 52 0.010% 99.661% ( 170, 250 ] 121 0.023% 99.684% ( 250, 380 ] 235 0.044% 99.728% ( 380, 580 ] 378 0.071% 99.799% ( 580, 870 ] 324 0.061% 99.860% ( 870, 1300 ] 245 0.046% 99.907% ( 1300, 1900 ] 191 0.036% 99.943% ( 1900, 2900 ] 296 0.056% 99.998% ( 2900, 4400 ] 451 0.085% 100.084% ( 4400, 6600 ] 154 0.029% 100.113% ( 6600, 9900 ] 69 0.013% 100.126% ( 9900, 14000 ] 11 0.002% 100.128% ( 14000, 22000 ] 27 0.005% 100.133% ( 22000, 33000 ] 17 0.003% 100.136% ( 33000, 50000 ] 7 0.001% 100.137% ( 50000, 75000 ] 1 0.000% 100.137% ** Level 3 read latency histogram (micros): Count: 708439 Average: 10.1972 StdDev: 197.64 Min: 1 Median: 2.0674 Max: 47093 Percentiles: P50: 2.07 P75: 3.14 P99: 9.78 P99.9: 594.76 P99.99: 974.65 ------------------------------------------------------ [ 0, 1 ] 10621 1.499% 1.499% ( 1, 2 ] 331625 46.811% 48.310% ######### ( 2, 3 ] 177635 25.074% 73.384% ##### ( 3, 4 ] 80413 11.351% 84.735% ## ( 4, 6 ] 84698 11.956% 96.690% ## ( 6, 10 ] 17330 2.446% 99.137% ( 10, 15 ] 3275 0.462% 99.599% ( 15, 22 ] 425 0.060% 99.659% ( 22, 34 ] 81 0.011% 99.670% ( 34, 51 ] 140 0.020% 99.690% ( 51, 76 ] 145 0.020% 99.710% ( 76, 110 ] 68 0.010% 99.720% ( 110, 170 ] 73 0.010% 99.730% ( 170, 250 ] 174 0.025% 99.755% ( 250, 380 ] 372 0.053% 99.807% ( 380, 580 ] 626 0.088% 99.896% ( 580, 870 ] 581 0.082% 99.978% ( 870, 1300 ] 354 0.050% 100.028% ( 1300, 1900 ] 187 0.026% 100.054% ( 1900, 2900 ] 283 0.040% 100.094% ( 2900, 4400 ] 391 0.055% 100.149% ( 4400, 6600 ] 107 0.015% 100.164% ( 6600, 9900 ] 44 0.006% 100.171% ( 9900, 14000 ] 4 0.001% 100.171% ( 14000, 22000 ] 11 0.002% 100.173% ( 22000, 33000 ] 7 0.001% 100.174% ( 33000, 50000 ] 3 0.000% 100.174% ** Level 4 read latency histogram (micros): Count: 456525 Average: 21.4288 StdDev: 349.92 Min: 1 Median: 2.0614 Max: 64982 Percentiles: P50: 2.06 P75: 3.18 P99: 338.04 P99.9: 2709.65 P99.99: 3782.34 ------------------------------------------------------ [ 0, 1 ] 7575 1.659% 1.659% ( 1, 2 ] 213839 46.841% 48.500% ######### ( 2, 3 ] 111547 24.434% 72.934% ##### ( 3, 4 ] 51211 11.218% 84.151% ## ( 4, 6 ] 51637 11.311% 95.462% ## ( 6, 10 ] 12241 2.681% 98.144% # ( 10, 15 ] 2285 0.501% 98.644% ( 15, 22 ] 301 0.066% 98.710% ( 22, 34 ] 60 0.013% 98.723% ( 34, 51 ] 107 0.023% 98.747% ( 51, 76 ] 110 0.024% 98.771% ( 76, 110 ] 39 0.009% 98.779% ( 110, 170 ] 92 0.020% 98.799% ( 170, 250 ] 378 0.083% 98.882% ( 250, 380 ] 797 0.175% 99.057% ( 380, 580 ] 1250 0.274% 99.331% ( 580, 870 ] 1215 0.266% 99.597% ( 870, 1300 ] 736 0.161% 99.758% ( 1300, 1900 ] 359 0.079% 99.837% ( 1900, 2900 ] 360 0.079% 99.915% ( 2900, 4400 ] 582 0.127% 100.043% ( 4400, 6600 ] 191 0.042% 100.085% ( 6600, 9900 ] 34 0.007% 100.092% ( 9900, 14000 ] 7 0.002% 100.094% ( 14000, 22000 ] 15 0.003% 100.097% ( 22000, 33000 ] 13 0.003% 100.100% ( 33000, 50000 ] 5 0.001% 100.101% ( 50000, 75000 ] 4 0.001% 100.102% ** Level 5 read latency histogram (micros): Count: 16738 Average: 1295.5774 StdDev: 2641.54 Min: 90 Median: 684.4513 Max: 108271 Percentiles: P50: 684.45 P75: 1289.08 P99: 6594.42 P99.9: 43262.00 P99.99: 90472.33 ------------------------------------------------------ ( 76, 110 ] 16 0.096% 0.096% ( 110, 170 ] 205 1.225% 1.320% ( 170, 250 ] 833 4.977% 6.297% # ( 250, 380 ] 2318 13.849% 20.146% ### ( 380, 580 ] 3776 22.559% 42.705% ##### ( 580, 870 ] 3390 20.253% 62.959% #### ( 870, 1300 ] 2068 12.355% 75.314% ## ( 1300, 1900 ] 1113 6.650% 81.963% # ( 1900, 2900 ] 908 5.425% 87.388% # ( 2900, 4400 ] 1401 8.370% 95.758% ## ( 4400, 6600 ] 544 3.250% 99.008% # ( 6600, 9900 ] 118 0.705% 99.713% ( 9900, 14000 ] 6 0.036% 99.749% ( 14000, 22000 ] 9 0.054% 99.803% ( 22000, 33000 ] 6 0.036% 99.839% ( 33000, 50000 ] 17 0.102% 99.940% ( 50000, 75000 ] 7 0.042% 99.982% ( 75000, 110000 ] 3 0.018% 100.000% ** DB Stats ** Uptime(secs): 7.9 total, 7.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 124.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:2.398 H:M:S, 30.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 126.92 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.398 H:M:S, 30.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/07/15-10:58:00 ... thread 0: (1000000,2000000) ops and (142826.8,135569.2) ops/second in (7.001487,14.752612) 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/4 1.11 GB 31.5 0.7 0.0 0.7 2.5 1.8 0.0 1.4 38.2 138.7 18.16 8.42 25 0.726 703K 878 0.0 0.0 L1 3/3 149.89 MB 0.0 1.0 0.7 0.3 1.0 0.7 0.0 1.5 143.0 142.8 7.51 5.27 4 1.877 1090K 1623 0.0 0.0 L2 2/2 257.54 MB 0.0 0.7 0.3 0.4 0.7 0.3 0.4 2.2 123.0 122.6 6.04 3.63 5 1.209 732K 1234 0.0 0.0 L3 22/6 1.46 GB 1.0 4.8 2.5 2.2 4.7 2.5 0.0 1.9 109.0 107.7 44.96 25.58 23 1.955 3605K 4758 0.0 0.0 L4 180/4 9.88 GB 1.0 8.5 4.3 4.2 8.3 4.1 0.5 1.9 122.2 119.7 71.16 42.11 45 1.581 3419K 595 0.0 0.0 L5 1212/0 94.97 GB 1.0 0.0 0.0 0.0 0.0 0.0 4.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1427/19 107.81 GB 0.0 15.7 7.9 7.8 17.3 9.4 5.4 9.7 108.9 119.7 147.84 85.00 102 1.449 9551K 9088 0.0 0.0 Int 0/0 0.00 KB 0.0 15.7 7.9 7.8 17.3 9.4 5.4 9.7 108.9 119.7 147.84 85.00 102 1.449 9551K 9088 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 15.7 7.9 7.8 15.5 7.7 0.0 0.0 120.4 118.6 133.79 79.51 79 1.694 9551K 9088 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 130.1 14.05 5.48 23 0.611 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): 14.9 total, 14.8 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 17.28 GB write, 1185.37 MB/s write, 15.73 GB read, 1078.96 MB/s read, 147.8 seconds Interval compaction: 17.28 GB write, 1199.17 MB/s write, 15.73 GB read, 1091.52 MB/s read, 147.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 56, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 56, interval: 56 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 393750 Average: 12.2614 StdDev: 162.95 Min: 1 Median: 1.9376 Max: 30516 Percentiles: P50: 1.94 P75: 2.93 P99: 13.93 P99.9: 2640.68 P99.99: 4851.54 ------------------------------------------------------ [ 0, 1 ] 13025 3.308% 3.308% # ( 1, 2 ] 196077 49.797% 53.105% ########## ( 2, 3 ] 92379 23.461% 76.567% ##### ( 3, 4 ] 39921 10.139% 86.705% ## ( 4, 6 ] 38776 9.848% 96.553% ## ( 6, 10 ] 8353 2.121% 98.675% ( 10, 15 ] 1630 0.414% 99.089% ( 15, 22 ] 223 0.057% 99.145% ( 22, 34 ] 16 0.004% 99.149% ( 34, 51 ] 27 0.007% 99.156% ( 51, 76 ] 43 0.011% 99.167% ( 76, 110 ] 10 0.003% 99.170% ( 110, 170 ] 31 0.008% 99.177% ( 170, 250 ] 217 0.055% 99.233% ( 250, 380 ] 489 0.124% 99.357% ( 380, 580 ] 820 0.208% 99.565% ( 580, 870 ] 703 0.179% 99.743% ( 870, 1300 ] 361 0.092% 99.835% ( 1300, 1900 ] 137 0.035% 99.870% ( 1900, 2900 ] 161 0.041% 99.911% ( 2900, 4400 ] 296 0.075% 99.986% ( 4400, 6600 ] 81 0.021% 100.007% ( 6600, 9900 ] 12 0.003% 100.010% ( 9900, 14000 ] 1 0.000% 100.010% ( 14000, 22000 ] 2 0.001% 100.010% ( 22000, 33000 ] 1 0.000% 100.011% ** Level 1 read latency histogram (micros): Count: 290049 Average: 9.1851 StdDev: 166.35 Min: 1 Median: 2.0754 Max: 31839 Percentiles: P50: 2.08 P75: 3.16 P99: 10.55 P99.9: 1565.29 P99.99: 4209.81 ------------------------------------------------------ [ 0, 1 ] 5098 1.758% 1.758% ( 1, 2 ] 134438 46.350% 48.108% ######### ( 2, 3 ] 72828 25.109% 73.217% ##### ( 3, 4 ] 33171 11.436% 84.653% ## ( 4, 6 ] 34053 11.740% 96.393% ## ( 6, 10 ] 7404 2.553% 98.946% # ( 10, 15 ] 1435 0.495% 99.441% ( 15, 22 ] 199 0.069% 99.509% ( 22, 34 ] 52 0.018% 99.527% ( 34, 51 ] 85 0.029% 99.557% ( 51, 76 ] 68 0.023% 99.580% ( 76, 110 ] 23 0.008% 99.588% ( 110, 170 ] 26 0.009% 99.597% ( 170, 250 ] 75 0.026% 99.623% ( 250, 380 ] 187 0.064% 99.687% ( 380, 580 ] 267 0.092% 99.779% ( 580, 870 ] 204 0.070% 99.850% ( 870, 1300 ] 116 0.040% 99.890% ( 1300, 1900 ] 70 0.024% 99.914% ( 1900, 2900 ] 98 0.034% 99.948% ( 2900, 4400 ] 142 0.049% 99.997% ( 4400, 6600 ] 31 0.011% 100.007% ( 6600, 9900 ] 20 0.007% 100.014% ( 9900, 14000 ] 1 0.000% 100.014% ( 14000, 22000 ] 1 0.000% 100.015% ( 22000, 33000 ] 4 0.001% 100.016% ** Level 2 read latency histogram (micros): Count: 650569 Average: 14.0912 StdDev: 288.81 Min: 1 Median: 2.1542 Max: 60337 Percentiles: P50: 2.15 P75: 3.32 P99: 12.13 P99.9: 1385.36 P99.99: 2981.00 ------------------------------------------------------ [ 0, 1 ] 10650 1.637% 1.637% ( 1, 2 ] 289663 44.525% 46.162% ######### ( 2, 3 ] 161927 24.890% 71.052% ##### ( 3, 4 ] 79839 12.272% 83.324% ## ( 4, 6 ] 79598 12.235% 95.559% ## ( 6, 10 ] 20347 3.128% 98.687% # ( 10, 15 ] 4781 0.735% 99.421% ( 15, 22 ] 706 0.109% 99.530% ( 22, 34 ] 149 0.023% 99.553% ( 34, 51 ] 118 0.018% 99.571% ( 51, 76 ] 140 0.022% 99.593% ( 76, 110 ] 59 0.009% 99.602% ( 110, 170 ] 60 0.009% 99.611% ( 170, 250 ] 144 0.022% 99.633% ( 250, 380 ] 319 0.049% 99.682% ( 380, 580 ] 556 0.085% 99.767% ( 580, 870 ] 513 0.079% 99.846% ( 870, 1300 ] 316 0.049% 99.895% ( 1300, 1900 ] 235 0.036% 99.931% ( 1900, 2900 ] 355 0.055% 99.986% ( 2900, 4400 ] 536 0.082% 100.068% ( 4400, 6600 ] 179 0.028% 100.095% ( 6600, 9900 ] 77 0.012% 100.107% ( 9900, 14000 ] 11 0.002% 100.109% ( 14000, 22000 ] 27 0.004% 100.113% ( 22000, 33000 ] 17 0.003% 100.116% ( 33000, 50000 ] 7 0.001% 100.117% ( 50000, 75000 ] 1 0.000% 100.117% ** Level 3 read latency histogram (micros): Count: 1615829 Average: 10.3247 StdDev: 175.61 Min: 1 Median: 2.0877 Max: 47093 Percentiles: P50: 2.09 P75: 3.14 P99: 9.90 P99.9: 601.96 P99.99: 960.46 ------------------------------------------------------ [ 0, 1 ] 20426 1.264% 1.264% ( 1, 2 ] 751165 46.488% 47.752% ######### ( 2, 3 ] 414407 25.647% 73.399% ##### ( 3, 4 ] 182155 11.273% 84.672% ## ( 4, 6 ] 190185 11.770% 96.442% ## ( 6, 10 ] 42388 2.623% 99.065% # ( 10, 15 ] 8261 0.511% 99.577% ( 15, 22 ] 1070 0.066% 99.643% ( 22, 34 ] 156 0.010% 99.652% ( 34, 51 ] 342 0.021% 99.674% ( 51, 76 ] 378 0.023% 99.697% ( 76, 110 ] 133 0.008% 99.705% ( 110, 170 ] 148 0.009% 99.714% ( 170, 250 ] 383 0.024% 99.738% ( 250, 380 ] 937 0.058% 99.796% ( 380, 580 ] 1573 0.097% 99.893% ( 580, 870 ] 1402 0.087% 99.980% ( 870, 1300 ] 753 0.047% 100.027% ( 1300, 1900 ] 417 0.026% 100.053% ( 1900, 2900 ] 655 0.041% 100.093% ( 2900, 4400 ] 999 0.062% 100.155% ( 4400, 6600 ] 296 0.018% 100.173% ( 6600, 9900 ] 103 0.006% 100.180% ( 9900, 14000 ] 7 0.000% 100.180% ( 14000, 22000 ] 17 0.001% 100.181% ( 22000, 33000 ] 7 0.000% 100.182% ( 33000, 50000 ] 3 0.000% 100.182% ** Level 4 read latency histogram (micros): Count: 1103229 Average: 18.1196 StdDev: 266.32 Min: 1 Median: 2.0838 Max: 64982 Percentiles: P50: 2.08 P75: 3.18 P99: 240.21 P99.9: 2084.39 P99.99: 3359.16 ------------------------------------------------------ [ 0, 1 ] 15518 1.407% 1.407% ( 1, 2 ] 512866 46.488% 47.894% ######### ( 2, 3 ] 277108 25.118% 73.012% ##### ( 3, 4 ] 122929 11.143% 84.155% ## ( 4, 6 ] 125420 11.368% 95.523% ## ( 6, 10 ] 30269 2.744% 98.267% # ( 10, 15 ] 5680 0.515% 98.782% ( 15, 22 ] 743 0.067% 98.849% ( 22, 34 ] 121 0.011% 98.860% ( 34, 51 ] 251 0.023% 98.883% ( 51, 76 ] 282 0.026% 98.908% ( 76, 110 ] 92 0.008% 98.917% ( 110, 170 ] 192 0.017% 98.934% ( 170, 250 ] 828 0.075% 99.009% ( 250, 380 ] 1834 0.166% 99.176% ( 380, 580 ] 3060 0.277% 99.453% ( 580, 870 ] 2722 0.247% 99.700% ( 870, 1300 ] 1420 0.129% 99.828% ( 1300, 1900 ] 652 0.059% 99.887% ( 1900, 2900 ] 758 0.069% 99.956% ( 2900, 4400 ] 1224 0.111% 100.067% ( 4400, 6600 ] 387 0.035% 100.102% ( 6600, 9900 ] 80 0.007% 100.109% ( 9900, 14000 ] 10 0.001% 100.110% ( 14000, 22000 ] 17 0.002% 100.112% ( 22000, 33000 ] 13 0.001% 100.113% ( 33000, 50000 ] 5 0.000% 100.113% ( 50000, 75000 ] 4 0.000% 100.114% ** Level 5 read latency histogram (micros): Count: 38318 Average: 1113.7017 StdDev: 1966.90 Min: 90 Median: 599.0110 Max: 108271 Percentiles: P50: 599.01 P75: 1096.57 P99: 6341.17 P99.9: 19532.57 P99.99: 72029.29 ------------------------------------------------------ ( 76, 110 ] 37 0.097% 0.097% ( 110, 170 ] 525 1.370% 1.467% ( 170, 250 ] 2221 5.796% 7.263% # ( 250, 380 ] 5990 15.632% 22.895% ### ( 380, 580 ] 9863 25.740% 48.635% ##### ( 580, 870 ] 7978 20.821% 69.456% #### ( 870, 1300 ] 4032 10.522% 79.978% ## ( 1300, 1900 ] 1873 4.888% 84.866% # ( 1900, 2900 ] 1733 4.523% 89.389% # ( 2900, 4400 ] 2789 7.279% 96.667% # ( 4400, 6600 ] 1013 2.644% 99.311% # ( 6600, 9900 ] 205 0.535% 99.846% ( 9900, 14000 ] 11 0.029% 99.875% ( 14000, 22000 ] 14 0.037% 99.911% ( 22000, 33000 ] 7 0.018% 99.930% ( 33000, 50000 ] 17 0.044% 99.974% ( 50000, 75000 ] 7 0.018% 99.992% ( 75000, 110000 ] 3 0.008% 100.000% ** DB Stats ** Uptime(secs): 14.9 total, 7.0 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 131.87 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:4.269 H:M:S, 28.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 140.57 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.871 H:M:S, 26.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 2024/07/15-10:58:04 ... thread 0: (1000000,3000000) ops and (228013.4,156753.6) ops/second in (4.385707,19.138319) 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/8 2.15 GB 113.3 1.5 0.0 1.5 4.3 2.8 0.0 1.5 58.9 171.7 25.67 14.64 44 0.583 1535K 1702 0.0 0.0 L1 3/3 149.89 MB 0.0 1.0 0.7 0.3 1.0 0.7 0.0 1.5 143.0 142.8 7.51 5.27 4 1.877 1090K 1623 0.0 0.0 L2 0/0 0.00 KB 0.0 0.7 0.3 0.4 0.7 0.3 0.4 2.2 123.0 122.6 6.04 3.63 5 1.209 732K 1234 0.0 0.0 L3 18/0 978.87 MB 1.0 5.4 2.8 2.6 5.3 2.7 0.0 1.9 111.8 110.6 49.24 28.45 25 1.969 3955K 4758 0.0 0.0 L4 184/0 9.70 GB 1.0 10.2 5.0 5.2 10.0 4.8 0.5 2.0 126.6 123.7 82.62 50.16 56 1.475 4138K 595 0.0 0.0 L5 1222/0 95.84 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1442/11 108.79 GB 0.0 18.8 8.8 10.0 21.4 11.4 6.3 7.6 112.8 127.9 171.08 102.16 134 1.277 11M 9912 0.0 0.0 Int 0/0 0.00 KB 0.0 18.8 8.8 10.0 21.4 11.4 6.3 7.6 112.8 127.9 171.08 102.16 134 1.277 11M 9912 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.8 10.0 18.5 8.5 0.0 0.0 126.0 124.1 153.08 93.67 95 1.611 11M 9912 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 161.0 17.99 8.49 39 0.461 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): 19.3 total, 19.1 interval Flush(GB): cumulative 2.830, interval 2.830 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.37 GB write, 1133.38 MB/s write, 18.84 GB read, 998.96 MB/s read, 171.1 seconds Interval compaction: 21.37 GB write, 1143.55 MB/s write, 18.84 GB read, 1007.93 MB/s read, 171.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: 57, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 57, interval: 57 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 830557 Average: 9.1120 StdDev: 119.13 Min: 1 Median: 1.7547 Max: 30516 Percentiles: P50: 1.75 P75: 2.60 P99: 132.37 P99.9: 922.39 P99.99: 3063.38 ------------------------------------------------------ [ 0, 1 ] 68018 8.189% 8.189% ## ( 1, 2 ] 460133 55.401% 63.590% ########### ( 2, 3 ] 156959 18.898% 82.488% #### ( 3, 4 ] 64121 7.720% 90.208% ## ( 4, 6 ] 55992 6.741% 96.950% # ( 6, 10 ] 13358 1.608% 98.558% ( 10, 15 ] 2149 0.259% 98.817% ( 15, 22 ] 300 0.036% 98.853% ( 22, 34 ] 31 0.004% 98.857% ( 34, 51 ] 57 0.007% 98.864% ( 51, 76 ] 61 0.007% 98.871% ( 76, 110 ] 256 0.031% 98.902% ( 110, 170 ] 2195 0.264% 99.166% ( 170, 250 ] 2514 0.303% 99.469% ( 250, 380 ] 1351 0.163% 99.631% ( 380, 580 ] 1307 0.157% 99.789% ( 580, 870 ] 876 0.105% 99.894% ( 870, 1300 ] 414 0.050% 99.944% ( 1300, 1900 ] 152 0.018% 99.962% ( 1900, 2900 ] 196 0.024% 99.986% ( 2900, 4400 ] 330 0.040% 100.026% ( 4400, 6600 ] 86 0.010% 100.036% ( 6600, 9900 ] 12 0.001% 100.037% ( 9900, 14000 ] 1 0.000% 100.038% ( 14000, 22000 ] 2 0.000% 100.038% ( 22000, 33000 ] 1 0.000% 100.038% ** Level 1 read latency histogram (micros): Count: 320240 Average: 8.8521 StdDev: 158.74 Min: 1 Median: 2.0529 Max: 31839 Percentiles: P50: 2.05 P75: 3.11 P99: 11.05 P99.9: 1315.09 P99.99: 4168.98 ------------------------------------------------------ [ 0, 1 ] 5914 1.847% 1.847% ( 1, 2 ] 149945 46.823% 48.669% ######### ( 2, 3 ] 80494 25.136% 73.805% ##### ( 3, 4 ] 35741 11.161% 84.966% ## ( 4, 6 ] 36534 11.408% 96.374% ## ( 6, 10 ] 8086 2.525% 98.899% # ( 10, 15 ] 1542 0.482% 99.380% ( 15, 22 ] 216 0.067% 99.448% ( 22, 34 ] 55 0.017% 99.465% ( 34, 51 ] 91 0.028% 99.494% ( 51, 76 ] 70 0.022% 99.515% ( 76, 110 ] 37 0.012% 99.527% ( 110, 170 ] 131 0.041% 99.568% ( 170, 250 ] 191 0.060% 99.627% ( 250, 380 ] 242 0.076% 99.703% ( 380, 580 ] 296 0.092% 99.795% ( 580, 870 ] 215 0.067% 99.863% ( 870, 1300 ] 118 0.037% 99.899% ( 1300, 1900 ] 70 0.022% 99.921% ( 1900, 2900 ] 99 0.031% 99.952% ( 2900, 4400 ] 143 0.045% 99.997% ( 4400, 6600 ] 31 0.010% 100.007% ( 6600, 9900 ] 20 0.006% 100.013% ( 9900, 14000 ] 1 0.000% 100.013% ( 14000, 22000 ] 1 0.000% 100.013% ( 22000, 33000 ] 4 0.001% 100.015% ** Level 2 read latency histogram (micros): Count: 650569 Average: 14.0912 StdDev: 288.81 Min: 1 Median: 2.1542 Max: 60337 Percentiles: P50: 2.15 P75: 3.32 P99: 12.13 P99.9: 1385.36 P99.99: 2981.00 ------------------------------------------------------ [ 0, 1 ] 10650 1.637% 1.637% ( 1, 2 ] 289663 44.525% 46.162% ######### ( 2, 3 ] 161927 24.890% 71.052% ##### ( 3, 4 ] 79839 12.272% 83.324% ## ( 4, 6 ] 79598 12.235% 95.559% ## ( 6, 10 ] 20347 3.128% 98.687% # ( 10, 15 ] 4781 0.735% 99.421% ( 15, 22 ] 706 0.109% 99.530% ( 22, 34 ] 149 0.023% 99.553% ( 34, 51 ] 118 0.018% 99.571% ( 51, 76 ] 140 0.022% 99.593% ( 76, 110 ] 59 0.009% 99.602% ( 110, 170 ] 60 0.009% 99.611% ( 170, 250 ] 144 0.022% 99.633% ( 250, 380 ] 319 0.049% 99.682% ( 380, 580 ] 556 0.085% 99.767% ( 580, 870 ] 513 0.079% 99.846% ( 870, 1300 ] 316 0.049% 99.895% ( 1300, 1900 ] 235 0.036% 99.931% ( 1900, 2900 ] 355 0.055% 99.986% ( 2900, 4400 ] 536 0.082% 100.068% ( 4400, 6600 ] 179 0.028% 100.095% ( 6600, 9900 ] 77 0.012% 100.107% ( 9900, 14000 ] 11 0.002% 100.109% ( 14000, 22000 ] 27 0.004% 100.113% ( 22000, 33000 ] 17 0.003% 100.116% ( 33000, 50000 ] 7 0.001% 100.117% ( 50000, 75000 ] 1 0.000% 100.117% ** Level 3 read latency histogram (micros): Count: 1801286 Average: 9.8266 StdDev: 167.52 Min: 1 Median: 2.0585 Max: 47093 Percentiles: P50: 2.06 P75: 3.10 P99: 9.89 P99.9: 567.09 P99.99: 896.87 ------------------------------------------------------ [ 0, 1 ] 24054 1.335% 1.335% ( 1, 2 ] 849849 47.180% 48.516% ######### ( 2, 3 ] 457389 25.392% 73.908% ##### ( 3, 4 ] 199870 11.096% 85.004% ## ( 4, 6 ] 207439 11.516% 96.520% ## ( 6, 10 ] 45949 2.551% 99.071% # ( 10, 15 ] 8671 0.481% 99.552% ( 15, 22 ] 1110 0.062% 99.614% ( 22, 34 ] 160 0.009% 99.623% ( 34, 51 ] 382 0.021% 99.644% ( 51, 76 ] 388 0.022% 99.666% ( 76, 110 ] 176 0.010% 99.675% ( 110, 170 ] 514 0.029% 99.704% ( 170, 250 ] 800 0.044% 99.748% ( 250, 380 ] 1106 0.061% 99.810% ( 380, 580 ] 1740 0.097% 99.906% ( 580, 870 ] 1461 0.081% 99.987% ( 870, 1300 ] 766 0.043% 100.030% ( 1300, 1900 ] 423 0.023% 100.053% ( 1900, 2900 ] 668 0.037% 100.090% ( 2900, 4400 ] 1028 0.057% 100.148% ( 4400, 6600 ] 298 0.017% 100.164% ( 6600, 9900 ] 104 0.006% 100.170% ( 9900, 14000 ] 7 0.000% 100.170% ( 14000, 22000 ] 17 0.001% 100.171% ( 22000, 33000 ] 7 0.000% 100.172% ( 33000, 50000 ] 3 0.000% 100.172% ** Level 4 read latency histogram (micros): Count: 1347688 Average: 17.4319 StdDev: 246.52 Min: 1 Median: 2.0552 Max: 64982 Percentiles: P50: 2.06 P75: 3.15 P99: 246.10 P99.9: 1715.65 P99.99: 3072.65 ------------------------------------------------------ [ 0, 1 ] 19211 1.425% 1.425% ( 1, 2 ] 636279 47.213% 48.638% ######### ( 2, 3 ] 332704 24.687% 73.325% ##### ( 3, 4 ] 146768 10.890% 84.215% ## ( 4, 6 ] 148925 11.050% 95.266% ## ( 6, 10 ] 36331 2.696% 97.962% # ( 10, 15 ] 6324 0.469% 98.431% ( 15, 22 ] 802 0.060% 98.490% ( 22, 34 ] 134 0.010% 98.500% ( 34, 51 ] 294 0.022% 98.522% ( 51, 76 ] 301 0.022% 98.545% ( 76, 110 ] 338 0.025% 98.570% ( 110, 170 ] 2385 0.177% 98.747% ( 170, 250 ] 3590 0.266% 99.013% ( 250, 380 ] 3024 0.224% 99.237% ( 380, 580 ] 3844 0.285% 99.523% ( 580, 870 ] 3080 0.229% 99.751% ( 870, 1300 ] 1520 0.113% 99.864% ( 1300, 1900 ] 702 0.052% 99.916% ( 1900, 2900 ] 843 0.063% 99.979% ( 2900, 4400 ] 1340 0.099% 100.078% ( 4400, 6600 ] 401 0.030% 100.108% ( 6600, 9900 ] 87 0.006% 100.114% ( 9900, 14000 ] 10 0.001% 100.115% ( 14000, 22000 ] 17 0.001% 100.116% ( 22000, 33000 ] 13 0.001% 100.117% ( 33000, 50000 ] 5 0.000% 100.118% ( 50000, 75000 ] 4 0.000% 100.118% ** Level 5 read latency histogram (micros): Count: 80369 Average: 679.4205 StdDev: 1445.41 Min: 84 Median: 331.4950 Max: 108271 Percentiles: P50: 331.50 P75: 642.40 P99: 5458.27 P99.9: 9460.48 P99.99: 44963.10 ------------------------------------------------------ ( 76, 110 ] 1529 1.902% 1.902% ( 110, 170 ] 13505 16.804% 18.706% ### ( 170, 250 ] 17626 21.931% 40.638% #### ( 250, 380 ] 12003 14.935% 55.572% ### ( 380, 580 ] 13602 16.924% 72.497% ### ( 580, 870 ] 9350 11.634% 84.131% ## ( 870, 1300 ] 4417 5.496% 89.627% # ( 1300, 1900 ] 2023 2.517% 92.144% # ( 1900, 2900 ] 2018 2.511% 94.655% # ( 2900, 4400 ] 2993 3.724% 98.379% # ( 4400, 6600 ] 1038 1.292% 99.670% ( 6600, 9900 ] 213 0.265% 99.935% ( 9900, 14000 ] 11 0.014% 99.949% ( 14000, 22000 ] 14 0.017% 99.966% ( 22000, 33000 ] 7 0.009% 99.975% ( 33000, 50000 ] 17 0.021% 99.996% ( 50000, 75000 ] 7 0.009% 100.005% ( 75000, 110000 ] 3 0.004% 100.009% ** DB Stats ** Uptime(secs): 19.3 total, 4.4 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 152.88 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.456 H:M:S, 23.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 224.41 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.187 H:M:S, 4.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 0 2024/07/15-10:58:09 ... thread 0: (1000000,4000000) ops and (244835.9,172245.4) ops/second in (4.084368,23.222687) 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/13 2.21 GB 37.8 2.2 0.0 2.2 5.9 3.7 0.0 1.6 71.4 190.3 31.77 20.02 61 0.521 2302K 2420 0.0 0.0 L1 6/6 528.91 MB 0.0 2.0 1.5 0.5 2.0 1.5 0.0 1.3 153.2 152.8 13.33 9.78 5 2.665 2073K 4991 0.0 0.0 L2 0/0 0.00 KB 0.0 0.7 0.3 0.4 0.7 0.3 0.8 2.2 123.0 122.6 6.04 3.63 5 1.209 732K 1234 0.0 0.0 L3 23/6 1.28 GB 0.9 6.2 3.2 3.0 6.1 3.2 0.0 1.9 119.2 118.0 53.13 32.14 28 1.898 4794K 8325 0.0 0.0 L4 186/20 9.79 GB 0.9 10.4 5.1 5.3 10.2 4.9 0.5 2.0 127.4 124.5 83.78 51.13 58 1.444 4236K 595 0.0 0.0 L5 1222/0 95.84 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1453/45 109.64 GB 0.0 21.5 10.2 11.4 24.9 13.5 6.7 6.8 117.3 135.7 188.05 116.70 157 1.198 14M 17K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.5 10.2 11.4 24.9 13.5 6.7 6.8 117.3 135.7 188.05 116.70 157 1.198 14M 17K 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.5 10.2 11.4 21.2 9.8 0.0 0.0 132.2 130.3 166.82 105.64 104 1.604 14M 17K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 178.0 21.23 11.06 53 0.401 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): 23.4 total, 23.2 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 24.92 GB write, 1090.68 MB/s write, 21.54 GB read, 942.63 MB/s read, 188.1 seconds Interval compaction: 24.92 GB write, 1098.74 MB/s write, 21.54 GB read, 949.61 MB/s read, 188.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: 57, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 57, interval: 57 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1176378 Average: 8.0208 StdDev: 104.80 Min: 1 Median: 1.7133 Max: 30516 Percentiles: P50: 1.71 P75: 2.49 P99: 119.10 P99.9: 772.64 P99.99: 2412.95 ------------------------------------------------------ [ 0, 1 ] 109887 9.341% 9.341% ## ( 1, 2 ] 670533 57.000% 66.341% ########### ( 2, 3 ] 209322 17.794% 84.135% #### ( 3, 4 ] 84109 7.150% 91.285% # ( 4, 6 ] 70609 6.002% 97.287% # ( 6, 10 ] 16237 1.380% 98.667% ( 10, 15 ] 2567 0.218% 98.885% ( 15, 22 ] 363 0.031% 98.916% ( 22, 34 ] 43 0.004% 98.920% ( 34, 51 ] 68 0.006% 98.926% ( 51, 76 ] 62 0.005% 98.931% ( 76, 110 ] 337 0.029% 98.959% ( 110, 170 ] 3161 0.269% 99.228% ( 170, 250 ] 3786 0.322% 99.550% ( 250, 380 ] 1862 0.158% 99.708% ( 380, 580 ] 1598 0.136% 99.844% ( 580, 870 ] 993 0.084% 99.929% ( 870, 1300 ] 451 0.038% 99.967% ( 1300, 1900 ] 161 0.014% 99.981% ( 1900, 2900 ] 221 0.019% 99.999% ( 2900, 4400 ] 370 0.031% 100.031% ( 4400, 6600 ] 91 0.008% 100.039% ( 6600, 9900 ] 12 0.001% 100.040% ( 9900, 14000 ] 1 0.000% 100.040% ( 14000, 22000 ] 2 0.000% 100.040% ( 22000, 33000 ] 1 0.000% 100.040% ** Level 1 read latency histogram (micros): Count: 431672 Average: 7.4868 StdDev: 137.03 Min: 1 Median: 1.9254 Max: 31839 Percentiles: P50: 1.93 P75: 2.90 P99: 9.95 P99.9: 824.71 P99.99: 3580.06 ------------------------------------------------------ [ 0, 1 ] 10724 2.484% 2.484% ( 1, 2 ] 221640 51.345% 53.829% ########## ( 2, 3 ] 101750 23.571% 77.400% ##### ( 3, 4 ] 42225 9.782% 87.182% ## ( 4, 6 ] 40789 9.449% 96.631% ## ( 6, 10 ] 10353 2.398% 99.029% ( 10, 15 ] 1715 0.397% 99.426% ( 15, 22 ] 240 0.056% 99.482% ( 22, 34 ] 63 0.015% 99.497% ( 34, 51 ] 91 0.021% 99.518% ( 51, 76 ] 71 0.016% 99.534% ( 76, 110 ] 46 0.011% 99.545% ( 110, 170 ] 274 0.063% 99.608% ( 170, 250 ] 416 0.096% 99.705% ( 250, 380 ] 319 0.074% 99.779% ( 380, 580 ] 337 0.078% 99.857% ( 580, 870 ] 222 0.051% 99.908% ( 870, 1300 ] 120 0.028% 99.936% ( 1300, 1900 ] 70 0.016% 99.952% ( 1900, 2900 ] 99 0.023% 99.975% ( 2900, 4400 ] 143 0.033% 100.008% ( 4400, 6600 ] 31 0.007% 100.015% ( 6600, 9900 ] 20 0.005% 100.020% ( 9900, 14000 ] 1 0.000% 100.020% ( 14000, 22000 ] 1 0.000% 100.020% ( 22000, 33000 ] 4 0.001% 100.021% ** Level 2 read latency histogram (micros): Count: 650569 Average: 14.0912 StdDev: 288.81 Min: 1 Median: 2.1542 Max: 60337 Percentiles: P50: 2.15 P75: 3.32 P99: 12.13 P99.9: 1385.36 P99.99: 2981.00 ------------------------------------------------------ [ 0, 1 ] 10650 1.637% 1.637% ( 1, 2 ] 289663 44.525% 46.162% ######### ( 2, 3 ] 161927 24.890% 71.052% ##### ( 3, 4 ] 79839 12.272% 83.324% ## ( 4, 6 ] 79598 12.235% 95.559% ## ( 6, 10 ] 20347 3.128% 98.687% # ( 10, 15 ] 4781 0.735% 99.421% ( 15, 22 ] 706 0.109% 99.530% ( 22, 34 ] 149 0.023% 99.553% ( 34, 51 ] 118 0.018% 99.571% ( 51, 76 ] 140 0.022% 99.593% ( 76, 110 ] 59 0.009% 99.602% ( 110, 170 ] 60 0.009% 99.611% ( 170, 250 ] 144 0.022% 99.633% ( 250, 380 ] 319 0.049% 99.682% ( 380, 580 ] 556 0.085% 99.767% ( 580, 870 ] 513 0.079% 99.846% ( 870, 1300 ] 316 0.049% 99.895% ( 1300, 1900 ] 235 0.036% 99.931% ( 1900, 2900 ] 355 0.055% 99.986% ( 2900, 4400 ] 536 0.082% 100.068% ( 4400, 6600 ] 179 0.028% 100.095% ( 6600, 9900 ] 77 0.012% 100.107% ( 9900, 14000 ] 11 0.002% 100.109% ( 14000, 22000 ] 27 0.004% 100.113% ( 22000, 33000 ] 17 0.003% 100.116% ( 33000, 50000 ] 7 0.001% 100.117% ( 50000, 75000 ] 1 0.000% 100.117% ** Level 3 read latency histogram (micros): Count: 1963255 Average: 9.4985 StdDev: 161.35 Min: 1 Median: 2.0113 Max: 47093 Percentiles: P50: 2.01 P75: 3.02 P99: 9.93 P99.9: 558.57 P99.99: 897.11 ------------------------------------------------------ [ 0, 1 ] 30236 1.540% 1.540% ( 1, 2 ] 945819 48.176% 49.716% ########## ( 2, 3 ] 491203 25.020% 74.736% ##### ( 3, 4 ] 211470 10.771% 85.507% ## ( 4, 6 ] 216975 11.052% 96.559% ## ( 6, 10 ] 48777 2.484% 99.044% ( 10, 15 ] 8971 0.457% 99.501% ( 15, 22 ] 1147 0.058% 99.559% ( 22, 34 ] 172 0.009% 99.568% ( 34, 51 ] 398 0.020% 99.588% ( 51, 76 ] 401 0.020% 99.609% ( 76, 110 ] 241 0.012% 99.621% ( 110, 170 ] 982 0.050% 99.671% ( 170, 250 ] 1467 0.075% 99.746% ( 250, 380 ] 1364 0.069% 99.815% ( 380, 580 ] 1869 0.095% 99.910% ( 580, 870 ] 1518 0.077% 99.988% ( 870, 1300 ] 772 0.039% 100.027% ( 1300, 1900 ] 431 0.022% 100.049% ( 1900, 2900 ] 676 0.034% 100.083% ( 2900, 4400 ] 1053 0.054% 100.137% ( 4400, 6600 ] 300 0.015% 100.152% ( 6600, 9900 ] 104 0.005% 100.157% ( 9900, 14000 ] 7 0.000% 100.158% ( 14000, 22000 ] 17 0.001% 100.159% ( 22000, 33000 ] 7 0.000% 100.159% ( 33000, 50000 ] 3 0.000% 100.159% ** Level 4 read latency histogram (micros): Count: 1530958 Average: 17.8048 StdDev: 237.94 Min: 1 Median: 2.0555 Max: 64982 Percentiles: P50: 2.06 P75: 3.16 P99: 268.60 P99.9: 1524.26 P99.99: 2845.82 ------------------------------------------------------ [ 0, 1 ] 21562 1.408% 1.408% ( 1, 2 ] 723038 47.228% 48.636% ######### ( 2, 3 ] 376380 24.585% 73.221% ##### ( 3, 4 ] 165601 10.817% 84.038% ## ( 4, 6 ] 166592 10.882% 94.919% ## ( 6, 10 ] 41001 2.678% 97.597% # ( 10, 15 ] 7144 0.467% 98.064% ( 15, 22 ] 885 0.058% 98.122% ( 22, 34 ] 155 0.010% 98.132% ( 34, 51 ] 346 0.023% 98.154% ( 51, 76 ] 343 0.022% 98.177% ( 76, 110 ] 556 0.036% 98.213% ( 110, 170 ] 4688 0.306% 98.519% ( 170, 250 ] 6725 0.439% 98.959% ( 250, 380 ] 4433 0.290% 99.248% ( 380, 580 ] 4699 0.307% 99.555% ( 580, 870 ] 3373 0.220% 99.776% ( 870, 1300 ] 1618 0.106% 99.881% ( 1300, 1900 ] 776 0.051% 99.932% ( 1900, 2900 ] 943 0.062% 99.993% ( 2900, 4400 ] 1488 0.097% 100.091% ( 4400, 6600 ] 439 0.029% 100.119% ( 6600, 9900 ] 94 0.006% 100.125% ( 9900, 14000 ] 10 0.001% 100.126% ( 14000, 22000 ] 17 0.001% 100.127% ( 22000, 33000 ] 13 0.001% 100.128% ( 33000, 50000 ] 5 0.000% 100.128% ( 50000, 75000 ] 4 0.000% 100.129% ** Level 5 read latency histogram (micros): Count: 122505 Average: 535.3128 StdDev: 1203.37 Min: 84 Median: 244.2912 Max: 108271 Percentiles: P50: 244.29 P75: 497.74 P99: 4619.28 P99.9: 8695.04 P99.99: 31034.93 ------------------------------------------------------ ( 76, 110 ] 2807 2.291% 2.291% ( 110, 170 ] 26569 21.688% 23.979% #### ( 170, 250 ] 34326 28.020% 52.000% ###### ( 250, 380 ] 18274 14.917% 66.916% ### ( 380, 580 ] 16821 13.731% 80.647% ### ( 580, 870 ] 10331 8.433% 89.080% ## ( 870, 1300 ] 4629 3.779% 92.859% # ( 1300, 1900 ] 2104 1.717% 94.577% ( 1900, 2900 ] 2110 1.722% 96.299% ( 2900, 4400 ] 3202 2.614% 98.913% # ( 4400, 6600 ] 1073 0.876% 99.789% ( 6600, 9900 ] 215 0.176% 99.964% ( 9900, 14000 ] 12 0.010% 99.974% ( 14000, 22000 ] 14 0.011% 99.985% ( 22000, 33000 ] 7 0.006% 99.991% ( 33000, 50000 ] 17 0.014% 100.005% ( 50000, 75000 ] 7 0.006% 100.011% ( 75000, 110000 ] 3 0.002% 100.013% ** DB Stats ** Uptime(secs): 23.4 total, 4.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 168.26 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.456 H:M:S, 19.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 240.96 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.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 8 num-running-flushes: 1 2024/07/15-10:58:13 ... thread 0: (1000000,5000000) ops and (207068.8,178240.4) ops/second in (4.829313,28.052000) 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/9 3.26 GB 170.0 3.4 0.0 3.4 8.2 4.7 0.0 1.7 86.3 204.8 40.90 28.16 83 0.493 3582K 3601 0.0 0.0 L1 6/6 528.91 MB 0.0 2.0 1.5 0.5 2.0 1.5 0.0 1.3 153.2 152.8 13.33 9.78 5 2.665 2073K 4991 0.0 0.0 L2 0/0 0.00 KB 0.0 0.7 0.3 0.4 0.7 0.3 0.8 2.2 123.0 122.6 6.04 3.63 5 1.209 732K 1234 0.0 0.0 L3 17/0 934.21 MB 0.9 6.2 3.2 3.0 6.1 3.2 0.0 1.9 119.2 118.0 53.13 32.14 28 1.898 4794K 8325 0.0 0.0 L4 189/0 9.75 GB 1.0 11.9 5.5 6.4 11.6 5.2 0.5 2.1 129.5 126.6 93.92 58.11 64 1.468 5387K 5590 0.0 0.0 L5 1233/0 96.14 GB 1.0 1.3 0.4 0.9 1.2 0.3 5.4 3.3 241.0 225.9 5.56 5.26 3 1.853 849K 31K 0.0 0.0 Sum 1463/15 110.57 GB 0.0 25.5 10.9 14.6 29.9 15.2 6.7 6.3 122.8 143.6 212.89 137.08 188 1.132 17M 55K 0.0 0.0 Int 0/0 0.00 KB 0.0 25.5 10.9 14.6 29.9 15.2 6.7 6.3 122.8 143.6 212.89 137.08 188 1.132 17M 55K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 25.5 10.9 14.6 25.1 10.5 0.0 0.0 139.2 136.9 187.84 122.89 118 1.592 17M 55K 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 193.7 25.04 14.19 70 0.358 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 28.2 total, 28.1 interval Flush(GB): cumulative 4.737, interval 4.737 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 29.85 GB write, 1083.00 MB/s write, 25.54 GB read, 926.50 MB/s read, 212.9 seconds Interval compaction: 29.85 GB write, 1089.63 MB/s write, 25.54 GB read, 932.17 MB/s read, 212.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 4, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 4, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 57, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 4, total-stops: 57, interval: 61 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1496520 Average: 10.4407 StdDev: 104.04 Min: 0 Median: 1.7017 Max: 30516 Percentiles: P50: 1.70 P75: 2.47 P99: 226.20 P99.9: 717.66 P99.99: 1762.48 ------------------------------------------------------ [ 0, 1 ] 147201 9.836% 9.836% ## ( 1, 2 ] 856580 57.238% 67.074% ########### ( 2, 3 ] 252010 16.840% 83.914% ### ( 3, 4 ] 100813 6.736% 90.651% # ( 4, 6 ] 81647 5.456% 96.106% # ( 6, 10 ] 18522 1.238% 97.344% ( 10, 15 ] 2991 0.200% 97.544% ( 15, 22 ] 410 0.027% 97.571% ( 22, 34 ] 51 0.003% 97.575% ( 34, 51 ] 70 0.005% 97.579% ( 51, 76 ] 69 0.005% 97.584% ( 76, 110 ] 1075 0.072% 97.656% ( 110, 170 ] 10577 0.707% 98.363% ( 170, 250 ] 13578 0.907% 99.270% ( 250, 380 ] 5534 0.370% 99.640% ( 380, 580 ] 3239 0.216% 99.856% ( 580, 870 ] 1383 0.092% 99.949% ( 870, 1300 ] 487 0.033% 99.981% ( 1300, 1900 ] 173 0.012% 99.993% ( 1900, 2900 ] 235 0.016% 100.008% ( 2900, 4400 ] 381 0.025% 100.034% ( 4400, 6600 ] 92 0.006% 100.040% ( 6600, 9900 ] 14 0.001% 100.041% ( 9900, 14000 ] 4 0.000% 100.041% ( 14000, 22000 ] 7 0.000% 100.042% ( 22000, 33000 ] 1 0.000% 100.042% ** Level 1 read latency histogram (micros): Count: 442055 Average: 7.8809 StdDev: 138.06 Min: 1 Median: 1.9371 Max: 31839 Percentiles: P50: 1.94 P75: 2.92 P99: 12.21 P99.9: 823.24 P99.99: 3585.36 ------------------------------------------------------ [ 0, 1 ] 10810 2.445% 2.445% ( 1, 2 ] 224325 50.746% 53.191% ########## ( 2, 3 ] 104572 23.656% 76.847% ##### ( 3, 4 ] 43411 9.820% 86.667% ## ( 4, 6 ] 42769 9.675% 96.343% ## ( 6, 10 ] 10937 2.474% 98.817% ( 10, 15 ] 1837 0.416% 99.232% ( 15, 22 ] 308 0.070% 99.302% ( 22, 34 ] 75 0.017% 99.319% ( 34, 51 ] 93 0.021% 99.340% ( 51, 76 ] 71 0.016% 99.356% ( 76, 110 ] 70 0.016% 99.372% ( 110, 170 ] 540 0.122% 99.494% ( 170, 250 ] 749 0.169% 99.663% ( 250, 380 ] 449 0.102% 99.765% ( 380, 580 ] 399 0.090% 99.855% ( 580, 870 ] 236 0.053% 99.909% ( 870, 1300 ] 121 0.027% 99.936% ( 1300, 1900 ] 71 0.016% 99.952% ( 1900, 2900 ] 102 0.023% 99.975% ( 2900, 4400 ] 144 0.033% 100.008% ( 4400, 6600 ] 31 0.007% 100.015% ( 6600, 9900 ] 20 0.005% 100.019% ( 9900, 14000 ] 1 0.000% 100.019% ( 14000, 22000 ] 2 0.000% 100.020% ( 22000, 33000 ] 4 0.001% 100.021% ** Level 2 read latency histogram (micros): Count: 650569 Average: 14.0912 StdDev: 288.81 Min: 1 Median: 2.1542 Max: 60337 Percentiles: P50: 2.15 P75: 3.32 P99: 12.13 P99.9: 1385.36 P99.99: 2981.00 ------------------------------------------------------ [ 0, 1 ] 10650 1.637% 1.637% ( 1, 2 ] 289663 44.525% 46.162% ######### ( 2, 3 ] 161927 24.890% 71.052% ##### ( 3, 4 ] 79839 12.272% 83.324% ## ( 4, 6 ] 79598 12.235% 95.559% ## ( 6, 10 ] 20347 3.128% 98.687% # ( 10, 15 ] 4781 0.735% 99.421% ( 15, 22 ] 706 0.109% 99.530% ( 22, 34 ] 149 0.023% 99.553% ( 34, 51 ] 118 0.018% 99.571% ( 51, 76 ] 140 0.022% 99.593% ( 76, 110 ] 59 0.009% 99.602% ( 110, 170 ] 60 0.009% 99.611% ( 170, 250 ] 144 0.022% 99.633% ( 250, 380 ] 319 0.049% 99.682% ( 380, 580 ] 556 0.085% 99.767% ( 580, 870 ] 513 0.079% 99.846% ( 870, 1300 ] 316 0.049% 99.895% ( 1300, 1900 ] 235 0.036% 99.931% ( 1900, 2900 ] 355 0.055% 99.986% ( 2900, 4400 ] 536 0.082% 100.068% ( 4400, 6600 ] 179 0.028% 100.095% ( 6600, 9900 ] 77 0.012% 100.107% ( 9900, 14000 ] 11 0.002% 100.109% ( 14000, 22000 ] 27 0.004% 100.113% ( 22000, 33000 ] 17 0.003% 100.116% ( 33000, 50000 ] 7 0.001% 100.117% ( 50000, 75000 ] 1 0.000% 100.117% ** Level 3 read latency histogram (micros): Count: 2024170 Average: 9.4543 StdDev: 159.43 Min: 1 Median: 1.9974 Max: 47093 Percentiles: P50: 2.00 P75: 3.00 P99: 9.99 P99.9: 556.47 P99.99: 891.38 ------------------------------------------------------ [ 0, 1 ] 32820 1.621% 1.621% ( 1, 2 ] 981806 48.504% 50.126% ########## ( 2, 3 ] 503210 24.860% 74.986% ##### ( 3, 4 ] 216080 10.675% 85.661% ## ( 4, 6 ] 220835 10.910% 96.570% ## ( 6, 10 ] 49262 2.434% 99.004% ( 10, 15 ] 9034 0.446% 99.450% ( 15, 22 ] 1156 0.057% 99.508% ( 22, 34 ] 173 0.009% 99.516% ( 34, 51 ] 406 0.020% 99.536% ( 51, 76 ] 404 0.020% 99.556% ( 76, 110 ] 278 0.014% 99.570% ( 110, 170 ] 1378 0.068% 99.638% ( 170, 250 ] 1991 0.098% 99.736% ( 250, 380 ] 1564 0.077% 99.814% ( 380, 580 ] 1982 0.098% 99.912% ( 580, 870 ] 1550 0.077% 99.988% ( 870, 1300 ] 776 0.038% 100.026% ( 1300, 1900 ] 431 0.021% 100.048% ( 1900, 2900 ] 678 0.033% 100.081% ( 2900, 4400 ] 1054 0.052% 100.133% ( 4400, 6600 ] 300 0.015% 100.148% ( 6600, 9900 ] 105 0.005% 100.153% ( 9900, 14000 ] 8 0.000% 100.154% ( 14000, 22000 ] 17 0.001% 100.155% ( 22000, 33000 ] 7 0.000% 100.155% ( 33000, 50000 ] 3 0.000% 100.155% ** Level 4 read latency histogram (micros): Count: 1888378 Average: 16.2411 StdDev: 218.70 Min: 1 Median: 1.9673 Max: 64982 Percentiles: P50: 1.97 P75: 3.00 P99: 245.04 P99.9: 1237.95 P99.99: 2587.80 ------------------------------------------------------ [ 0, 1 ] 38003 2.012% 2.012% ( 1, 2 ] 936804 49.609% 51.621% ########## ( 2, 3 ] 442118 23.413% 75.034% ##### ( 3, 4 ] 191763 10.155% 85.189% ## ( 4, 6 ] 184617 9.776% 94.965% ## ( 6, 10 ] 48406 2.563% 97.529% # ( 10, 15 ] 7956 0.421% 97.950% ( 15, 22 ] 980 0.052% 98.002% ( 22, 34 ] 163 0.009% 98.011% ( 34, 51 ] 377 0.020% 98.031% ( 51, 76 ] 367 0.019% 98.050% ( 76, 110 ] 807 0.043% 98.093% ( 110, 170 ] 7293 0.386% 98.479% ( 170, 250 ] 10491 0.556% 99.034% ( 250, 380 ] 5941 0.315% 99.349% ( 380, 580 ] 5433 0.288% 99.637% ( 580, 870 ] 3557 0.188% 99.825% ( 870, 1300 ] 1652 0.087% 99.913% ( 1300, 1900 ] 794 0.042% 99.955% ( 1900, 2900 ] 970 0.051% 100.006% ( 2900, 4400 ] 1520 0.080% 100.087% ( 4400, 6600 ] 442 0.023% 100.110% ( 6600, 9900 ] 95 0.005% 100.115% ( 9900, 14000 ] 12 0.001% 100.116% ( 14000, 22000 ] 25 0.001% 100.117% ( 22000, 33000 ] 13 0.001% 100.118% ( 33000, 50000 ] 5 0.000% 100.118% ( 50000, 75000 ] 4 0.000% 100.118% ** Level 5 read latency histogram (micros): Count: 299476 Average: 260.9717 StdDev: 821.90 Min: 1 Median: 135.5643 Max: 108271 Percentiles: P50: 135.56 P75: 245.06 P99: 3601.48 P99.9: 6331.68 P99.99: 8661.42 ------------------------------------------------------ [ 0, 1 ] 7378 2.464% 2.464% ( 1, 2 ] 80746 26.962% 29.426% ##### ( 2, 3 ] 22553 7.531% 36.957% ## ( 3, 4 ] 8767 2.927% 39.884% # ( 4, 6 ] 5427 1.812% 41.696% ( 6, 10 ] 2660 0.888% 42.585% ( 10, 15 ] 260 0.087% 42.672% ( 15, 22 ] 27 0.009% 42.681% ( 22, 34 ] 4 0.001% 42.682% ( 34, 51 ] 1 0.000% 42.682% ( 51, 76 ] 1 0.000% 42.683% ( 76, 110 ] 4241 1.416% 44.099% ( 110, 170 ] 41479 13.851% 57.949% ### ( 170, 250 ] 54421 18.172% 76.121% #### ( 250, 380 ] 25882 8.642% 84.764% ## ( 380, 580 ] 20598 6.878% 91.642% # ( 580, 870 ] 11343 3.788% 95.429% # ( 870, 1300 ] 4777 1.595% 97.024% ( 1300, 1900 ] 2146 0.717% 97.741% ( 1900, 2900 ] 2234 0.746% 98.487% ( 2900, 4400 ] 3285 1.097% 99.584% ( 4400, 6600 ] 1078 0.360% 99.944% ( 6600, 9900 ] 221 0.074% 100.018% ( 9900, 14000 ] 17 0.006% 100.023% ( 14000, 22000 ] 23 0.008% 100.031% ( 22000, 33000 ] 8 0.003% 100.034% ( 33000, 50000 ] 17 0.006% 100.039% ( 50000, 75000 ] 7 0.002% 100.042% ( 75000, 110000 ] 3 0.001% 100.043% ** DB Stats ** Uptime(secs): 28.2 total, 4.8 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 174.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:5.175 H:M:S, 18.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 203.80 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.719 H:M:S, 14.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/15-10:58:23 ... thread 0: (1000000,6000000) ops and (108908.0,161142.8) ops/second in (9.182064,37.234064) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/13 4.17 GB 238.1 5.7 0.0 5.7 11.4 5.6 0.0 2.0 110.9 220.4 52.81 39.54 102 0.518 5947K 15K 0.0 0.0 L1 6/6 528.91 MB 0.0 2.0 1.5 0.5 2.0 1.5 0.0 1.3 153.2 152.8 13.33 9.78 5 2.665 2073K 4991 0.0 0.0 L2 0/0 0.00 KB 0.0 0.7 0.3 0.4 0.7 0.3 0.8 2.2 123.0 122.6 6.04 3.63 5 1.209 732K 1234 0.0 0.0 L3 17/0 934.21 MB 0.9 6.2 3.2 3.0 6.1 3.2 0.0 1.9 119.2 118.0 53.13 32.14 28 1.898 4794K 8325 0.0 0.0 L4 189/0 9.75 GB 1.0 11.9 5.5 6.4 11.6 5.2 0.5 2.1 129.5 126.6 93.92 58.11 64 1.468 5387K 5590 0.0 0.0 L5 1233/0 96.14 GB 1.0 1.3 0.4 0.9 1.2 0.3 5.4 3.3 241.0 225.9 5.56 5.26 3 1.853 849K 31K 0.0 0.0 Sum 1463/19 111.48 GB 0.0 27.8 10.9 16.9 33.0 16.1 6.7 5.8 126.7 150.5 224.80 148.46 207 1.086 19M 66K 0.0 0.0 Int 0/0 0.00 KB 0.0 27.8 10.9 16.9 33.0 16.1 6.7 5.8 126.7 150.5 224.80 148.46 207 1.086 19M 66K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 27.8 10.9 16.9 27.4 10.5 0.0 0.0 144.7 142.4 196.81 131.64 122 1.613 19M 66K 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 207.1 27.99 16.82 85 0.329 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.4 total, 37.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: 33.04 GB write, 904.40 MB/s write, 27.81 GB read, 761.36 MB/s read, 224.8 seconds Interval compaction: 33.04 GB write, 908.57 MB/s write, 27.81 GB read, 764.87 MB/s read, 224.8 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: 57, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 57, interval: 68 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2191653 Average: 13.0085 StdDev: 91.43 Min: 0 Median: 1.6141 Max: 30516 Percentiles: P50: 1.61 P75: 2.26 P99: 234.94 P99.9: 563.24 P99.99: 942.81 ------------------------------------------------------ [ 0, 1 ] 342778 15.640% 15.640% ### ( 1, 2 ] 1226228 55.950% 71.590% ########### ( 2, 3 ] 291302 13.291% 84.882% ### ( 3, 4 ] 113498 5.179% 90.060% # ( 4, 6 ] 88247 4.027% 94.087% # ( 6, 10 ] 22404 1.022% 95.109% ( 10, 15 ] 3409 0.156% 95.264% ( 15, 22 ] 486 0.022% 95.287% ( 22, 34 ] 71 0.003% 95.290% ( 34, 51 ] 77 0.004% 95.293% ( 51, 76 ] 70 0.003% 95.297% ( 76, 110 ] 5617 0.256% 95.553% ( 110, 170 ] 45540 2.078% 97.631% ( 170, 250 ] 36971 1.687% 99.318% ( 250, 380 ] 8855 0.404% 99.722% ( 380, 580 ] 4267 0.195% 99.916% ( 580, 870 ] 1530 0.070% 99.986% ( 870, 1300 ] 501 0.023% 100.009% ( 1300, 1900 ] 175 0.008% 100.017% ( 1900, 2900 ] 235 0.011% 100.028% ( 2900, 4400 ] 381 0.017% 100.045% ( 4400, 6600 ] 93 0.004% 100.049% ( 6600, 9900 ] 14 0.001% 100.050% ( 9900, 14000 ] 4 0.000% 100.050% ( 14000, 22000 ] 7 0.000% 100.051% ( 22000, 33000 ] 1 0.000% 100.051% ** Level 1 read latency histogram (micros): Count: 464494 Average: 8.4073 StdDev: 135.18 Min: 1 Median: 1.9650 Max: 31839 Percentiles: P50: 1.96 P75: 2.99 P99: 102.13 P99.9: 797.51 P99.99: 3561.99 ------------------------------------------------------ [ 0, 1 ] 11033 2.375% 2.375% ( 1, 2 ] 229246 49.354% 51.729% ########## ( 2, 3 ] 109558 23.587% 75.316% ##### ( 3, 4 ] 47341 10.192% 85.508% ## ( 4, 6 ] 47763 10.283% 95.790% ## ( 6, 10 ] 11938 2.570% 98.361% # ( 10, 15 ] 2076 0.447% 98.808% ( 15, 22 ] 457 0.098% 98.906% ( 22, 34 ] 107 0.023% 98.929% ( 34, 51 ] 98 0.021% 98.950% ( 51, 76 ] 73 0.016% 98.966% ( 76, 110 ] 207 0.045% 99.010% ( 110, 170 ] 1569 0.338% 99.348% ( 170, 250 ] 1409 0.303% 99.651% ( 250, 380 ] 549 0.118% 99.770% ( 380, 580 ] 427 0.092% 99.862% ( 580, 870 ] 238 0.051% 99.913% ( 870, 1300 ] 122 0.026% 99.939% ( 1300, 1900 ] 71 0.015% 99.954% ( 1900, 2900 ] 102 0.022% 99.976% ( 2900, 4400 ] 144 0.031% 100.007% ( 4400, 6600 ] 31 0.007% 100.014% ( 6600, 9900 ] 20 0.004% 100.018% ( 9900, 14000 ] 1 0.000% 100.019% ( 14000, 22000 ] 2 0.000% 100.019% ( 22000, 33000 ] 4 0.001% 100.020% ** Level 2 read latency histogram (micros): Count: 650569 Average: 14.0912 StdDev: 288.81 Min: 1 Median: 2.1542 Max: 60337 Percentiles: P50: 2.15 P75: 3.32 P99: 12.13 P99.9: 1385.36 P99.99: 2981.00 ------------------------------------------------------ [ 0, 1 ] 10650 1.637% 1.637% ( 1, 2 ] 289663 44.525% 46.162% ######### ( 2, 3 ] 161927 24.890% 71.052% ##### ( 3, 4 ] 79839 12.272% 83.324% ## ( 4, 6 ] 79598 12.235% 95.559% ## ( 6, 10 ] 20347 3.128% 98.687% # ( 10, 15 ] 4781 0.735% 99.421% ( 15, 22 ] 706 0.109% 99.530% ( 22, 34 ] 149 0.023% 99.553% ( 34, 51 ] 118 0.018% 99.571% ( 51, 76 ] 140 0.022% 99.593% ( 76, 110 ] 59 0.009% 99.602% ( 110, 170 ] 60 0.009% 99.611% ( 170, 250 ] 144 0.022% 99.633% ( 250, 380 ] 319 0.049% 99.682% ( 380, 580 ] 556 0.085% 99.767% ( 580, 870 ] 513 0.079% 99.846% ( 870, 1300 ] 316 0.049% 99.895% ( 1300, 1900 ] 235 0.036% 99.931% ( 1900, 2900 ] 355 0.055% 99.986% ( 2900, 4400 ] 536 0.082% 100.068% ( 4400, 6600 ] 179 0.028% 100.095% ( 6600, 9900 ] 77 0.012% 100.107% ( 9900, 14000 ] 11 0.002% 100.109% ( 14000, 22000 ] 27 0.004% 100.113% ( 22000, 33000 ] 17 0.003% 100.116% ( 33000, 50000 ] 7 0.001% 100.117% ( 50000, 75000 ] 1 0.000% 100.117% ** Level 3 read latency histogram (micros): Count: 2027503 Average: 9.7199 StdDev: 159.45 Min: 1 Median: 1.9991 Max: 47093 Percentiles: P50: 2.00 P75: 3.01 P99: 11.78 P99.9: 557.04 P99.99: 891.20 ------------------------------------------------------ [ 0, 1 ] 32820 1.619% 1.619% ( 1, 2 ] 981806 48.424% 50.043% ########## ( 2, 3 ] 503210 24.819% 74.862% ##### ( 3, 4 ] 216080 10.657% 85.520% ## ( 4, 6 ] 220835 10.892% 96.412% ## ( 6, 10 ] 49262 2.430% 98.841% ( 10, 15 ] 9034 0.446% 99.287% ( 15, 22 ] 1156 0.057% 99.344% ( 22, 34 ] 173 0.009% 99.353% ( 34, 51 ] 406 0.020% 99.373% ( 51, 76 ] 404 0.020% 99.393% ( 76, 110 ] 528 0.026% 99.419% ( 110, 170 ] 3134 0.155% 99.573% ( 170, 250 ] 3109 0.153% 99.726% ( 250, 380 ] 1726 0.085% 99.812% ( 380, 580 ] 2025 0.100% 99.911% ( 580, 870 ] 1554 0.077% 99.988% ( 870, 1300 ] 776 0.038% 100.026% ( 1300, 1900 ] 431 0.021% 100.048% ( 1900, 2900 ] 678 0.033% 100.081% ( 2900, 4400 ] 1054 0.052% 100.133% ( 4400, 6600 ] 300 0.015% 100.148% ( 6600, 9900 ] 105 0.005% 100.153% ( 9900, 14000 ] 8 0.000% 100.153% ( 14000, 22000 ] 17 0.001% 100.154% ( 22000, 33000 ] 7 0.000% 100.155% ( 33000, 50000 ] 3 0.000% 100.155% ** Level 4 read latency histogram (micros): Count: 1910385 Average: 18.0423 StdDev: 218.18 Min: 1 Median: 1.9790 Max: 64982 Percentiles: P50: 1.98 P75: 3.08 P99: 259.80 P99.9: 1232.43 P99.99: 2585.53 ------------------------------------------------------ [ 0, 1 ] 38003 1.989% 1.989% ( 1, 2 ] 936826 49.039% 51.028% ########## ( 2, 3 ] 442156 23.145% 74.173% ##### ( 3, 4 ] 191792 10.039% 84.212% ## ( 4, 6 ] 184657 9.666% 93.878% ## ( 6, 10 ] 48415 2.534% 96.412% # ( 10, 15 ] 7956 0.416% 96.829% ( 15, 22 ] 980 0.051% 96.880% ( 22, 34 ] 163 0.009% 96.889% ( 34, 51 ] 377 0.020% 96.908% ( 51, 76 ] 367 0.019% 96.928% ( 76, 110 ] 2235 0.117% 97.045% ( 110, 170 ] 18658 0.977% 98.021% ( 170, 250 ] 18172 0.951% 98.973% ( 250, 380 ] 6953 0.364% 99.337% ( 380, 580 ] 5763 0.302% 99.638% ( 580, 870 ] 3605 0.189% 99.827% ( 870, 1300 ] 1657 0.087% 99.914% ( 1300, 1900 ] 794 0.042% 99.955% ( 1900, 2900 ] 970 0.051% 100.006% ( 2900, 4400 ] 1520 0.080% 100.086% ( 4400, 6600 ] 442 0.023% 100.109% ( 6600, 9900 ] 95 0.005% 100.114% ( 9900, 14000 ] 12 0.001% 100.114% ( 14000, 22000 ] 25 0.001% 100.116% ( 22000, 33000 ] 13 0.001% 100.116% ( 33000, 50000 ] 5 0.000% 100.117% ( 50000, 75000 ] 4 0.000% 100.117% ** Level 5 read latency histogram (micros): Count: 424777 Average: 234.3869 StdDev: 692.15 Min: 1 Median: 149.6820 Max: 108271 Percentiles: P50: 149.68 P75: 227.80 P99: 2995.08 P99.9: 5922.90 P99.99: 7354.41 ------------------------------------------------------ [ 0, 1 ] 7378 1.737% 1.737% ( 1, 2 ] 80947 19.056% 20.793% #### ( 2, 3 ] 23025 5.420% 26.214% # ( 3, 4 ] 9001 2.119% 28.333% ( 4, 6 ] 5910 1.391% 29.724% ( 6, 10 ] 2705 0.637% 30.361% ( 10, 15 ] 282 0.066% 30.427% ( 15, 22 ] 32 0.008% 30.435% ( 22, 34 ] 7 0.002% 30.436% ( 34, 51 ] 2 0.000% 30.437% ( 51, 76 ] 1 0.000% 30.437% ( 76, 110 ] 12690 2.987% 33.425% # ( 110, 170 ] 106459 25.062% 58.487% ##### ( 170, 250 ] 97087 22.856% 81.343% ##### ( 250, 380 ] 31633 7.447% 88.790% # ( 380, 580 ] 22418 5.278% 94.067% # ( 580, 870 ] 11572 2.724% 96.792% # ( 870, 1300 ] 4792 1.128% 97.920% ( 1300, 1900 ] 2146 0.505% 98.425% ( 1900, 2900 ] 2234 0.526% 98.951% ( 2900, 4400 ] 3285 0.773% 99.724% ( 4400, 6600 ] 1078 0.254% 99.978% ( 6600, 9900 ] 221 0.052% 100.030% ( 9900, 14000 ] 17 0.004% 100.034% ( 14000, 22000 ] 23 0.005% 100.040% ( 22000, 33000 ] 8 0.002% 100.041% ( 33000, 50000 ] 17 0.004% 100.045% ( 50000, 75000 ] 7 0.002% 100.047% ( 75000, 110000 ] 3 0.001% 100.048% ** DB Stats ** Uptime(secs): 37.4 total, 9.2 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 157.86 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:10.381 H:M:S, 27.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 107.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:5.205 H:M:S, 56.7 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 : 303.023 micros/op 13189 ops/sec 60.124 seconds 792996 operations; 12.8 MB/s (198999 of 198999 found) Microseconds per read: Count: 792996 Average: 303.0283 StdDev: 1004.20 Min: 2 Median: 212.3797 Max: 196943 Percentiles: P50: 212.38 P75: 271.20 P99: 1982.10 P99.9: 11215.41 P99.99: 32484.21 ------------------------------------------------------ ( 1, 2 ] 1 0.000% 0.000% ( 2, 3 ] 24 0.003% 0.003% ( 3, 4 ] 61 0.008% 0.011% ( 4, 6 ] 101 0.013% 0.024% ( 6, 10 ] 288 0.036% 0.060% ( 10, 15 ] 2815 0.355% 0.415% ( 15, 22 ] 2541 0.320% 0.735% ( 22, 34 ] 5772 0.728% 1.463% ( 34, 51 ] 2283 0.288% 1.751% ( 51, 76 ] 373 0.047% 1.798% ( 76, 110 ] 5315 0.670% 2.468% ( 110, 170 ] 174734 22.035% 24.503% #### ( 170, 250 ] 381673 48.131% 72.634% ########## ( 250, 380 ] 115079 14.512% 87.145% ### ( 380, 580 ] 63477 8.005% 95.150% ## ( 580, 870 ] 21224 2.676% 97.827% # ( 870, 1300 ] 6753 0.852% 98.678% ( 1300, 1900 ] 2372 0.299% 98.977% ( 1900, 2900 ] 2193 0.277% 99.254% ( 2900, 4400 ] 3203 0.404% 99.658% ( 4400, 6600 ] 1302 0.164% 99.822% ( 6600, 9900 ] 525 0.066% 99.888% ( 9900, 14000 ] 293 0.037% 99.925% ( 14000, 22000 ] 346 0.044% 99.969% ( 22000, 33000 ] 177 0.022% 99.991% ( 33000, 50000 ] 37 0.005% 99.996% ( 50000, 75000 ] 16 0.002% 99.998% ( 75000, 110000 ] 7 0.001% 99.999% ( 110000, 170000 ] 8 0.001% 100.000% ( 170000, 250000 ] 3 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 13990989 rocksdb.bloom.filter.full.positive COUNT : 928390 rocksdb.bloom.filter.full.true.positive COUNT : 792529 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 : 467 rocksdb.memtable.miss COUNT : 792529 rocksdb.l0.hit COUNT : 31269 rocksdb.l1.hit COUNT : 3925 rocksdb.l2andup.hit COUNT : 757335 rocksdb.compaction.key.drop.new COUNT : 474788 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 : 6851905 rocksdb.number.keys.read COUNT : 792996 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 7071165960 rocksdb.bytes.read COUNT : 792996000 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 : 1893 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 29241187 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 : 34063628592 rocksdb.compact.write.bytes COUNT : 33576047699 rocksdb.flush.write.bytes COUNT : 7068476918 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 : 20 rocksdb.number.superversion_acquires COUNT : 1449 rocksdb.number.superversion_releases COUNT : 1401 rocksdb.number.superversion_cleanups COUNT : 358 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 : 318 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 : 7011187712 rocksdb.memtable.garbage.bytes.at.flush COUNT : 2456576 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 : 37559989054 rocksdb.non.last.level.read.count COUNT : 8935681 rocksdb.block.checksum.compute.count COUNT : 9189904 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 : 211.880318 P95 : 575.749035 P99 : 1980.619308 P100 : 196941.000000 COUNT : 792996 SUM : 239642221 rocksdb.db.write.micros P50 : 1.664577 P95 : 5.369216 P99 : 9.836258 P100 : 736675.000000 COUNT : 6851905 SUM : 50254703 rocksdb.compaction.times.micros P50 : 1260344.827586 P95 : 3751666.666667 P99 : 5801500.000000 P100 : 6136454.000000 COUNT : 127 SUM : 205578233 rocksdb.compaction.times.cpu_micros P50 : 975000.000000 P95 : 2527777.777778 P99 : 5568666.666667 P100 : 5957049.000000 COUNT : 127 SUM : 140219811 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 : 797.500000 P95 : 8250.000000 P99 : 14000.000000 P100 : 16079.000000 COUNT : 100 SUM : 172850 rocksdb.compaction.outfile.sync.micros P50 : 3102.247191 P95 : 9585.714286 P99 : 13590.000000 P100 : 17407.000000 COUNT : 420 SUM : 1533347 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 : 215.555556 P95 : 3920.833333 P99 : 5798.571429 P100 : 6205.000000 COUNT : 255 SUM : 200782 rocksdb.table.open.io.micros P50 : 4995.562130 P95 : 19905.494505 P99 : 31960.322581 P100 : 130982.000000 COUNT : 1893 SUM : 13685949 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.953706 P95 : 9.736764 P99 : 186.485290 P100 : 64987.000000 COUNT : 8250001 SUM : 111038869 rocksdb.read.block.get.micros P50 : 161.696518 P95 : 476.790448 P99 : 1591.850962 P100 : 118309.000000 COUNT : 937990 SUM : 207157396 rocksdb.write.raw.block.micros P50 : 0.532157 P95 : 1.266863 P99 : 3.681928 P100 : 106349.000000 COUNT : 9844509 SUM : 33415950 rocksdb.numfiles.in.singlecompaction P50 : 3.008475 P95 : 5.875000 P99 : 9.633333 P100 : 15.000000 COUNT : 155 SUM : 534 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.568913 P95 : 1188.981896 P99 : 2510.612895 P100 : 736494.000000 COUNT : 160331 SUM : 29257122 rocksdb.sst.read.micros P50 : 1.937405 P95 : 170.465019 P99 : 369.117225 P100 : 108271.000000 COUNT : 8935681 SUM : 291802163 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 : 792996 SUM : 792996000 rocksdb.bytes.per.write P50 : 1032.000000 P95 : 1032.000000 P99 : 1032.000000 P100 : 1032.000000 COUNT : 6851905 SUM : 7071165960 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 : 228823.529412 P95 : 802000.000000 P99 : 1115000.000000 P100 : 1156085.000000 COUNT : 100 SUM : 30868603 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 : 435 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