[2024-07-14 05:28:47.745610] Starting SPDK v24.05.1-pre git sha1 5fa2f5086 / DPDK 23.11.0 initialization... [2024-07-14 05:28:47.745859] [ 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_pid3307980 ] Set seed to 1720927727739225 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-14 05:28:47.854103] app.c: 909:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-14 05:28:47.892026] app.c: 604:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-14 05:28:47.892075] app.c: 605:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 3307980' to capture a snapshot of events at runtime. [2024-07-14 05:28:47.892085] app.c: 610:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-14 05:28:47.892095] app.c: 611:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-14 05:28:47.892102] app.c: 612:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid3307980 for offline analysis/debug. [2024-07-14 05:28:47.892185] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sun Jul 14 05:28:52 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/07/14-05:28:59 ... thread 0: (1000000,1000000) ops and (132305.7,132305.7) ops/second in (7.558252,7.558252) 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 9/9 818.85 MB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 121.0 6.77 2.42 9 0.752 0 0 0.0 0.0 L1 1/1 74.48 MB 0.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 81.2 81.2 0.99 0.35 1 0.992 81K 15 0.0 0.0 L2 3/0 263.38 MB 2.6 0.3 0.0 0.3 0.3 0.0 0.0 43.8 101.9 101.8 2.59 1.18 1 2.587 267K 208 0.0 0.0 L3 45/10 3.73 GB 2.9 2.7 1.8 0.9 2.7 1.8 0.0 1.5 96.5 95.0 28.70 13.18 13 2.207 1849K 2125 0.0 0.0 L4 192/17 12.21 GB 1.2 3.2 2.5 0.8 3.2 2.4 0.1 1.3 114.5 113.6 29.02 15.19 24 1.209 1977K 0 0.0 0.0 L5 1088/0 89.51 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 1338/37 106.57 GB 0.0 6.3 4.4 1.9 7.0 5.1 0.1 8.8 94.6 105.6 68.06 32.32 48 1.418 4177K 2348 0.0 0.0 Int 0/0 0.00 KB 0.0 6.3 4.4 1.9 7.0 5.1 0.1 8.8 94.6 105.6 68.06 32.32 48 1.418 4177K 2348 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.4 1.9 6.2 4.3 0.0 0.0 105.0 103.9 61.30 29.89 39 1.572 4177K 2348 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.42 9 0.752 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.7 total, 7.6 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.02 GB write, 929.09 MB/s write, 6.28 GB read, 831.91 MB/s read, 68.1 seconds Interval compaction: 7.02 GB write, 950.72 MB/s write, 6.28 GB read, 851.28 MB/s read, 68.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: 34, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 34, interval: 34 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 113954 Average: 15.5255 StdDev: 179.25 Min: 1 Median: 1.8771 Max: 11256 Percentiles: P50: 1.88 P75: 2.86 P99: 14.14 P99.9: 3103.84 P99.99: 5940.36 ------------------------------------------------------ [ 0, 1 ] 4643 4.074% 4.074% # ( 1, 2 ] 59670 52.363% 56.438% ########## ( 2, 3 ] 24677 21.655% 78.093% #### ( 3, 4 ] 10270 9.012% 87.105% ## ( 4, 6 ] 10521 9.233% 96.338% ## ( 6, 10 ] 2602 2.283% 98.621% ( 10, 15 ] 525 0.461% 99.082% ( 15, 22 ] 51 0.045% 99.127% ( 22, 34 ] 12 0.011% 99.137% ( 34, 51 ] 3 0.003% 99.140% ( 51, 76 ] 1 0.001% 99.141% ( 110, 170 ] 7 0.006% 99.147% ( 170, 250 ] 32 0.028% 99.175% ( 250, 380 ] 55 0.048% 99.223% ( 380, 580 ] 117 0.103% 99.326% ( 580, 870 ] 170 0.149% 99.475% ( 870, 1300 ] 215 0.189% 99.664% ( 1300, 1900 ] 154 0.135% 99.799% ( 1900, 2900 ] 105 0.092% 99.891% ( 2900, 4400 ] 96 0.084% 99.975% ( 4400, 6600 ] 28 0.025% 100.000% ( 6600, 9900 ] 3 0.003% 100.003% ( 9900, 14000 ] 2 0.002% 100.004% ** Level 1 read latency histogram (micros): Count: 18481 Average: 16.2954 StdDev: 163.92 Min: 1 Median: 1.8988 Max: 5182 Percentiles: P50: 1.90 P75: 2.89 P99: 344.62 P99.9: 2807.44 P99.99: 4320.49 ------------------------------------------------------ [ 0, 1 ] 638 3.452% 3.452% # ( 1, 2 ] 9571 51.788% 55.241% ########## ( 2, 3 ] 4108 22.228% 77.469% #### ( 3, 4 ] 1714 9.274% 86.743% ## ( 4, 6 ] 1698 9.188% 95.931% ## ( 6, 10 ] 450 2.435% 98.366% ( 10, 15 ] 87 0.471% 98.837% ( 15, 22 ] 12 0.065% 98.902% ( 22, 34 ] 1 0.005% 98.907% ( 51, 76 ] 2 0.011% 98.918% ( 170, 250 ] 5 0.027% 98.945% ( 250, 380 ] 14 0.076% 99.021% ( 380, 580 ] 31 0.168% 99.188% ( 580, 870 ] 46 0.249% 99.437% ( 870, 1300 ] 41 0.222% 99.659% ( 1300, 1900 ] 30 0.162% 99.821% ( 1900, 2900 ] 16 0.087% 99.908% ( 2900, 4400 ] 16 0.087% 99.995% ( 4400, 6600 ] 1 0.005% 100.000% ** Level 2 read latency histogram (micros): Count: 468128 Average: 14.2070 StdDev: 224.61 Min: 0 Median: 1.9694 Max: 36638 Percentiles: P50: 1.97 P75: 3.03 P99: 12.75 P99.9: 1497.12 P99.99: 2221.64 ------------------------------------------------------ [ 0, 1 ] 13329 2.847% 2.847% # ( 1, 2 ] 227706 48.642% 51.489% ########## ( 2, 3 ] 108379 23.152% 74.641% ##### ( 3, 4 ] 49851 10.649% 85.290% ## ( 4, 6 ] 49596 10.595% 95.884% ## ( 6, 10 ] 12792 2.733% 98.617% # ( 10, 15 ] 3257 0.696% 99.313% ( 15, 22 ] 489 0.104% 99.417% ( 22, 34 ] 90 0.019% 99.436% ( 34, 51 ] 50 0.011% 99.447% ( 51, 76 ] 32 0.007% 99.454% ( 76, 110 ] 21 0.004% 99.458% ( 110, 170 ] 57 0.012% 99.470% ( 170, 250 ] 106 0.023% 99.493% ( 250, 380 ] 227 0.048% 99.542% ( 380, 580 ] 414 0.088% 99.630% ( 580, 870 ] 564 0.120% 99.750% ( 870, 1300 ] 554 0.118% 99.869% ( 1300, 1900 ] 444 0.095% 99.964% ( 1900, 2900 ] 383 0.082% 100.046% ( 2900, 4400 ] 329 0.070% 100.116% ( 4400, 6600 ] 96 0.021% 100.136% ( 6600, 9900 ] 28 0.006% 100.142% ( 9900, 14000 ] 6 0.001% 100.144% ( 14000, 22000 ] 12 0.003% 100.146% ( 22000, 33000 ] 6 0.001% 100.147% ( 33000, 50000 ] 2 0.000% 100.148% ** Level 3 read latency histogram (micros): Count: 849763 Average: 10.4205 StdDev: 138.46 Min: 1 Median: 1.9507 Max: 19504 Percentiles: P50: 1.95 P75: 2.96 P99: 9.88 P99.9: 835.04 P99.99: 1188.73 ------------------------------------------------------ [ 0, 1 ] 17781 2.092% 2.092% ( 1, 2 ] 428227 50.394% 52.486% ########## ( 2, 3 ] 198858 23.402% 75.888% ##### ( 3, 4 ] 88477 10.412% 86.300% ## ( 4, 6 ] 87931 10.348% 96.647% ## ( 6, 10 ] 20621 2.427% 99.074% ( 10, 15 ] 4344 0.511% 99.585% ( 15, 22 ] 555 0.065% 99.651% ( 22, 34 ] 63 0.007% 99.658% ( 34, 51 ] 30 0.004% 99.662% ( 51, 76 ] 63 0.007% 99.669% ( 76, 110 ] 38 0.004% 99.673% ( 110, 170 ] 78 0.009% 99.683% ( 170, 250 ] 123 0.014% 99.697% ( 250, 380 ] 297 0.035% 99.732% ( 380, 580 ] 613 0.072% 99.804% ( 580, 870 ] 927 0.109% 99.913% ( 870, 1300 ] 881 0.104% 100.017% ( 1300, 1900 ] 596 0.070% 100.087% ( 1900, 2900 ] 434 0.051% 100.138% ( 2900, 4400 ] 449 0.053% 100.191% ( 4400, 6600 ] 114 0.013% 100.204% ( 6600, 9900 ] 13 0.002% 100.206% ( 9900, 14000 ] 4 0.000% 100.206% ( 14000, 22000 ] 2 0.000% 100.207% ** Level 4 read latency histogram (micros): Count: 311844 Average: 25.6059 StdDev: 245.59 Min: 1 Median: 1.9682 Max: 30441 Percentiles: P50: 1.97 P75: 3.04 P99: 674.24 P99.9: 2880.21 P99.99: 3819.83 ------------------------------------------------------ [ 0, 1 ] 6079 1.949% 1.949% ( 1, 2 ] 154765 49.629% 51.578% ########## ( 2, 3 ] 71837 23.036% 74.615% ##### ( 3, 4 ] 32945 10.565% 85.179% ## ( 4, 6 ] 32294 10.356% 95.535% ## ( 6, 10 ] 7424 2.381% 97.916% ( 10, 15 ] 1633 0.524% 98.439% ( 15, 22 ] 180 0.058% 98.497% ( 22, 34 ] 20 0.006% 98.503% ( 34, 51 ] 17 0.005% 98.509% ( 51, 76 ] 37 0.012% 98.521% ( 76, 110 ] 15 0.005% 98.526% ( 110, 170 ] 56 0.018% 98.544% ( 170, 250 ] 185 0.059% 98.603% ( 250, 380 ] 278 0.089% 98.692% ( 380, 580 ] 660 0.212% 98.904% ( 580, 870 ] 928 0.298% 99.201% ( 870, 1300 ] 960 0.308% 99.509% ( 1300, 1900 ] 683 0.219% 99.728% ( 1900, 2900 ] 548 0.176% 99.904% ( 2900, 4400 ] 440 0.141% 100.045% ( 4400, 6600 ] 142 0.046% 100.090% ( 6600, 9900 ] 26 0.008% 100.099% ( 9900, 14000 ] 7 0.002% 100.101% ( 22000, 33000 ] 1 0.000% 100.101% ** Level 5 read latency histogram (micros): Count: 13640 Average: 1607.3968 StdDev: 1623.51 Min: 77 Median: 1092.3845 Max: 61966 Percentiles: P50: 1092.38 P75: 2142.42 P99: 6500.86 P99.9: 13016.00 P99.99: 32199.20 ------------------------------------------------------ ( 76, 110 ] 28 0.205% 0.205% ( 110, 170 ] 134 0.982% 1.188% ( 170, 250 ] 297 2.177% 3.365% ( 250, 380 ] 823 6.034% 9.399% # ( 380, 580 ] 1605 11.767% 21.166% ## ( 580, 870 ] 2623 19.230% 40.396% #### ( 870, 1300 ] 2533 18.570% 58.966% #### ( 1300, 1900 ] 1819 13.336% 72.302% ### ( 1900, 2900 ] 1518 11.129% 83.431% ## ( 2900, 4400 ] 1543 11.312% 94.743% ## ( 4400, 6600 ] 608 4.457% 99.201% # ( 6600, 9900 ] 87 0.638% 99.839% ( 9900, 14000 ] 11 0.081% 99.919% ( 14000, 22000 ] 5 0.037% 99.956% ( 22000, 33000 ] 5 0.037% 99.993% ( 33000, 50000 ] 1 0.007% 100.000% ( 50000, 75000 ] 1 0.007% 100.007% ** DB Stats ** Uptime(secs): 7.7 total, 7.6 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 127.22 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.582 H:M:S, 46.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 130.17 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.582 H:M:S, 47.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/07/14-05:29:05 ... thread 0: (1000000,2000000) ops and (162781.7,145970.0) ops/second in (6.143196,13.701448) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/8 1.35 GB 25.2 0.7 0.0 0.7 2.5 1.8 0.0 1.4 40.1 145.9 17.27 7.96 24 0.719 703K 852 0.0 0.0 L1 1/1 33.14 MB 0.0 0.6 0.5 0.1 0.6 0.5 0.0 1.1 119.9 119.7 4.97 2.74 2 2.485 605K 1138 0.0 0.0 L2 3/3 356.73 MB 0.0 0.3 0.0 0.3 0.3 0.0 0.5 43.8 101.9 101.8 2.59 1.18 1 2.587 267K 208 0.0 0.0 L3 21/8 1.66 GB 0.9 4.1 2.2 1.9 4.0 2.1 0.0 1.8 104.9 103.7 39.74 19.63 17 2.338 2741K 3439 0.0 0.0 L4 171/0 9.64 GB 1.0 7.7 4.5 3.1 7.6 4.4 0.4 1.7 119.2 117.6 65.92 35.87 43 1.533 3261K 4458 0.0 0.0 L5 1148/0 94.43 GB 1.0 0.0 0.0 0.0 0.0 0.0 4.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1355/20 107.47 GB 0.0 13.3 7.2 6.0 14.9 8.9 5.8 8.3 104.1 116.9 130.49 67.39 87 1.500 7579K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.3 7.2 6.0 14.9 8.9 5.8 8.3 104.1 116.9 130.49 67.39 87 1.500 7579K 10K 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 13.3 7.2 6.0 13.1 7.1 0.0 0.0 115.7 114.3 117.40 62.22 65 1.806 7579K 10K 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 139.6 13.08 5.16 22 0.595 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): 13.9 total, 13.7 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: 14.89 GB write, 1098.76 MB/s write, 13.26 GB read, 978.41 MB/s read, 130.5 seconds Interval compaction: 14.89 GB write, 1112.87 MB/s write, 13.26 GB read, 990.97 MB/s read, 130.5 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: 53, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 53, interval: 53 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 453624 Average: 9.7382 StdDev: 131.38 Min: 1 Median: 1.8493 Max: 11256 Percentiles: P50: 1.85 P75: 2.82 P99: 9.86 P99.9: 1839.53 P99.99: 4157.51 ------------------------------------------------------ [ 0, 1 ] 18958 4.179% 4.179% # ( 1, 2 ] 244734 53.951% 58.130% ########### ( 2, 3 ] 93627 20.640% 78.770% #### ( 3, 4 ] 41494 9.147% 87.917% ## ( 4, 6 ] 41915 9.240% 97.157% ## ( 6, 10 ] 8657 1.908% 99.066% ( 10, 15 ] 1757 0.387% 99.453% ( 15, 22 ] 180 0.040% 99.493% ( 22, 34 ] 31 0.007% 99.499% ( 34, 51 ] 13 0.003% 99.502% ( 51, 76 ] 22 0.005% 99.507% ( 76, 110 ] 6 0.001% 99.508% ( 110, 170 ] 24 0.005% 99.514% ( 170, 250 ] 68 0.015% 99.529% ( 250, 380 ] 156 0.034% 99.563% ( 380, 580 ] 323 0.071% 99.634% ( 580, 870 ] 464 0.102% 99.737% ( 870, 1300 ] 488 0.108% 99.844% ( 1300, 1900 ] 284 0.063% 99.907% ( 1900, 2900 ] 217 0.048% 99.955% ( 2900, 4400 ] 194 0.043% 99.997% ( 4400, 6600 ] 62 0.014% 100.011% ( 6600, 9900 ] 9 0.002% 100.013% ( 9900, 14000 ] 3 0.001% 100.014% ** Level 1 read latency histogram (micros): Count: 85417 Average: 15.3603 StdDev: 163.20 Min: 1 Median: 1.9485 Max: 8721 Percentiles: P50: 1.95 P75: 2.92 P99: 252.56 P99.9: 2585.89 P99.99: 4385.74 ------------------------------------------------------ [ 0, 1 ] 1602 1.876% 1.876% ( 1, 2 ] 43337 50.736% 52.611% ########## ( 2, 3 ] 20740 24.281% 76.892% ##### ( 3, 4 ] 8046 9.420% 86.312% ## ( 4, 6 ] 8188 9.586% 95.898% ## ( 6, 10 ] 2046 2.395% 98.293% ( 10, 15 ] 446 0.522% 98.815% ( 15, 22 ] 45 0.053% 98.868% ( 22, 34 ] 3 0.004% 98.871% ( 34, 51 ] 18 0.021% 98.892% ( 51, 76 ] 10 0.012% 98.904% ( 76, 110 ] 3 0.004% 98.908% ( 110, 170 ] 24 0.028% 98.936% ( 170, 250 ] 53 0.062% 98.998% ( 250, 380 ] 93 0.109% 99.107% ( 380, 580 ] 146 0.171% 99.278% ( 580, 870 ] 215 0.252% 99.529% ( 870, 1300 ] 173 0.203% 99.732% ( 1300, 1900 ] 99 0.116% 99.848% ( 1900, 2900 ] 65 0.076% 99.924% ( 2900, 4400 ] 57 0.067% 99.991% ( 4400, 6600 ] 13 0.015% 100.006% ( 6600, 9900 ] 4 0.005% 100.011% ** Level 2 read latency histogram (micros): Count: 535058 Average: 13.8366 StdDev: 216.05 Min: 0 Median: 1.9696 Max: 36638 Percentiles: P50: 1.97 P75: 3.02 P99: 12.63 P99.9: 1562.35 P99.99: 2379.20 ------------------------------------------------------ [ 0, 1 ] 14018 2.620% 2.620% # ( 1, 2 ] 261466 48.867% 51.487% ########## ( 2, 3 ] 124821 23.328% 74.815% ##### ( 3, 4 ] 56753 10.607% 85.422% ## ( 4, 6 ] 56389 10.539% 95.961% ## ( 6, 10 ] 14368 2.685% 98.646% # ( 10, 15 ] 3596 0.672% 99.318% ( 15, 22 ] 521 0.097% 99.416% ( 22, 34 ] 92 0.017% 99.433% ( 34, 51 ] 53 0.010% 99.443% ( 51, 76 ] 38 0.007% 99.450% ( 76, 110 ] 22 0.004% 99.454% ( 110, 170 ] 61 0.011% 99.465% ( 170, 250 ] 115 0.021% 99.487% ( 250, 380 ] 246 0.046% 99.533% ( 380, 580 ] 467 0.087% 99.620% ( 580, 870 ] 661 0.124% 99.744% ( 870, 1300 ] 623 0.116% 99.860% ( 1300, 1900 ] 487 0.091% 99.951% ( 1900, 2900 ] 433 0.081% 100.032% ( 2900, 4400 ] 361 0.067% 100.100% ( 4400, 6600 ] 109 0.020% 100.120% ( 6600, 9900 ] 28 0.005% 100.125% ( 9900, 14000 ] 6 0.001% 100.126% ( 14000, 22000 ] 12 0.002% 100.129% ( 22000, 33000 ] 6 0.001% 100.130% ( 33000, 50000 ] 2 0.000% 100.130% ** Level 3 read latency histogram (micros): Count: 1639377 Average: 10.7182 StdDev: 140.15 Min: 1 Median: 1.9590 Max: 19504 Percentiles: P50: 1.96 P75: 2.97 P99: 9.96 P99.9: 942.64 P99.99: 1346.92 ------------------------------------------------------ [ 0, 1 ] 29173 1.780% 1.780% ( 1, 2 ] 824279 50.280% 52.060% ########## ( 2, 3 ] 388838 23.719% 75.778% ##### ( 3, 4 ] 169024 10.310% 86.088% ## ( 4, 6 ] 171366 10.453% 96.542% ## ( 6, 10 ] 40738 2.485% 99.027% ( 10, 15 ] 8559 0.522% 99.549% ( 15, 22 ] 996 0.061% 99.609% ( 22, 34 ] 107 0.007% 99.616% ( 34, 51 ] 99 0.006% 99.622% ( 51, 76 ] 141 0.009% 99.631% ( 76, 110 ] 60 0.004% 99.634% ( 110, 170 ] 123 0.008% 99.642% ( 170, 250 ] 247 0.015% 99.657% ( 250, 380 ] 622 0.038% 99.695% ( 380, 580 ] 1255 0.077% 99.771% ( 580, 870 ] 1831 0.112% 99.883% ( 870, 1300 ] 1667 0.102% 99.985% ( 1300, 1900 ] 1139 0.069% 100.054% ( 1900, 2900 ] 899 0.055% 100.109% ( 2900, 4400 ] 935 0.057% 100.166% ( 4400, 6600 ] 237 0.014% 100.180% ( 6600, 9900 ] 31 0.002% 100.182% ( 9900, 14000 ] 4 0.000% 100.183% ( 14000, 22000 ] 2 0.000% 100.183% ** Level 4 read latency histogram (micros): Count: 804368 Average: 20.0799 StdDev: 205.41 Min: 0 Median: 1.9783 Max: 30441 Percentiles: P50: 1.98 P75: 3.05 P99: 381.60 P99.9: 2371.54 P99.99: 3207.87 ------------------------------------------------------ [ 0, 1 ] 14190 1.764% 1.764% ( 1, 2 ] 396582 49.304% 51.068% ########## ( 2, 3 ] 188444 23.428% 74.495% ##### ( 3, 4 ] 84754 10.537% 85.032% ## ( 4, 6 ] 86022 10.694% 95.726% ## ( 6, 10 ] 20157 2.506% 98.232% # ( 10, 15 ] 4339 0.539% 98.772% ( 15, 22 ] 488 0.061% 98.832% ( 22, 34 ] 51 0.006% 98.839% ( 34, 51 ] 59 0.007% 98.846% ( 51, 76 ] 91 0.011% 98.857% ( 76, 110 ] 31 0.004% 98.861% ( 110, 170 ] 102 0.013% 98.874% ( 170, 250 ] 369 0.046% 98.920% ( 250, 380 ] 634 0.079% 98.999% ( 380, 580 ] 1418 0.176% 99.175% ( 580, 870 ] 2024 0.252% 99.427% ( 870, 1300 ] 2047 0.254% 99.681% ( 1300, 1900 ] 1275 0.159% 99.840% ( 1900, 2900 ] 1032 0.128% 99.968% ( 2900, 4400 ] 870 0.108% 100.076% ( 4400, 6600 ] 250 0.031% 100.107% ( 6600, 9900 ] 40 0.005% 100.112% ( 9900, 14000 ] 8 0.001% 100.113% ( 22000, 33000 ] 1 0.000% 100.113% ** Level 5 read latency histogram (micros): Count: 29223 Average: 1382.0001 StdDev: 1364.40 Min: 77 Median: 937.3858 Max: 61966 Percentiles: P50: 937.39 P75: 1727.32 P99: 6195.96 P99.9: 9685.26 P99.99: 26570.94 ------------------------------------------------------ ( 76, 110 ] 43 0.147% 0.147% ( 110, 170 ] 314 1.074% 1.222% ( 170, 250 ] 784 2.683% 3.904% # ( 250, 380 ] 2059 7.046% 10.950% # ( 380, 580 ] 4248 14.536% 25.487% ### ( 580, 870 ] 6262 21.428% 46.915% #### ( 870, 1300 ] 5759 19.707% 66.622% #### ( 1300, 1900 ] 3439 11.768% 78.390% ## ( 1900, 2900 ] 2702 9.246% 87.636% ## ( 2900, 4400 ] 2614 8.945% 96.581% ## ( 4400, 6600 ] 867 2.967% 99.548% # ( 6600, 9900 ] 111 0.380% 99.928% ( 9900, 14000 ] 12 0.041% 99.969% ( 14000, 22000 ] 5 0.017% 99.986% ( 22000, 33000 ] 5 0.017% 100.003% ( 33000, 50000 ] 1 0.003% 100.007% ( 50000, 75000 ] 1 0.003% 100.010% ** DB Stats ** Uptime(secs): 13.9 total, 6.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 141.82 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:5.970 H:M:S, 43.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 160.21 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.388 H:M:S, 38.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 6 num-running-flushes: 1 2024/07/14-05:29:10 ... thread 0: (1000000,3000000) ops and (205498.7,161571.2) ops/second in (4.866212,18.567660) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/10 1.48 GB 31.5 1.5 0.0 1.5 4.2 2.8 0.0 1.5 59.0 169.7 25.61 14.15 41 0.625 1535K 1702 0.0 0.0 L1 11/11 911.10 MB 0.0 1.5 1.4 0.1 1.5 1.4 0.0 1.1 147.1 146.6 10.27 6.97 3 3.423 1533K 4000 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.0 0.3 0.3 0.0 0.5 43.8 101.9 101.8 2.59 1.18 1 2.587 267K 208 0.0 0.0 L3 17/1 1.03 GB 0.9 5.2 2.5 2.7 5.2 2.5 0.0 2.1 113.0 112.0 47.46 25.17 20 2.373 3172K 3439 0.0 0.0 L4 182/8 9.83 GB 1.0 9.8 5.5 4.3 9.6 5.4 0.4 1.7 125.3 123.2 79.85 45.64 58 1.377 4661K 10K 0.0 0.0 L5 1156/0 95.17 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 1378/30 108.39 GB 0.0 18.2 9.4 8.8 20.8 12.0 6.6 7.5 112.5 128.3 165.77 93.10 123 1.348 11M 20K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.2 9.4 8.8 20.8 12.0 6.6 7.5 112.5 128.3 165.77 93.10 123 1.348 11M 20K 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.2 9.4 8.8 18.0 9.2 0.0 0.0 126.1 124.6 147.95 85.06 87 1.701 11M 20K 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 159.1 17.82 8.05 36 0.495 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 18.7 total, 18.6 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: 20.77 GB write, 1134.57 MB/s write, 18.22 GB read, 995.17 MB/s read, 165.8 seconds Interval compaction: 20.77 GB write, 1145.32 MB/s write, 18.22 GB read, 1004.61 MB/s read, 165.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: 65, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 65, interval: 65 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 808753 Average: 8.6166 StdDev: 119.22 Min: 1 Median: 1.8190 Max: 22060 Percentiles: P50: 1.82 P75: 2.74 P99: 9.91 P99.9: 1272.68 P99.99: 3115.03 ------------------------------------------------------ [ 0, 1 ] 39660 4.904% 4.904% # ( 1, 2 ] 445326 55.063% 59.967% ########### ( 2, 3 ] 163994 20.277% 80.245% #### ( 3, 4 ] 69489 8.592% 88.837% ## ( 4, 6 ] 68548 8.476% 97.312% ## ( 6, 10 ] 13974 1.728% 99.040% ( 10, 15 ] 2827 0.350% 99.390% ( 15, 22 ] 271 0.034% 99.423% ( 22, 34 ] 38 0.005% 99.428% ( 34, 51 ] 19 0.002% 99.430% ( 51, 76 ] 42 0.005% 99.436% ( 76, 110 ] 76 0.009% 99.445% ( 110, 170 ] 372 0.046% 99.491% ( 170, 250 ] 465 0.057% 99.548% ( 250, 380 ] 589 0.073% 99.621% ( 380, 580 ] 763 0.094% 99.716% ( 580, 870 ] 803 0.099% 99.815% ( 870, 1300 ] 736 0.091% 99.906% ( 1300, 1900 ] 376 0.046% 99.952% ( 1900, 2900 ] 269 0.033% 99.986% ( 2900, 4400 ] 252 0.031% 100.017% ( 4400, 6600 ] 75 0.009% 100.026% ( 6600, 9900 ] 12 0.001% 100.028% ( 9900, 14000 ] 5 0.001% 100.028% ( 14000, 22000 ] 2 0.000% 100.028% ( 22000, 33000 ] 1 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 191293 Average: 11.8276 StdDev: 145.15 Min: 1 Median: 1.8984 Max: 10549 Percentiles: P50: 1.90 P75: 2.84 P99: 14.38 P99.9: 2138.54 P99.99: 4466.05 ------------------------------------------------------ [ 0, 1 ] 4129 2.158% 2.158% ( 1, 2 ] 101867 53.252% 55.410% ########### ( 2, 3 ] 44820 23.430% 78.840% ##### ( 3, 4 ] 16546 8.650% 87.490% ## ( 4, 6 ] 16709 8.735% 96.225% ## ( 6, 10 ] 4497 2.351% 98.575% ( 10, 15 ] 927 0.485% 99.060% ( 15, 22 ] 88 0.046% 99.106% ( 22, 34 ] 4 0.002% 99.108% ( 34, 51 ] 22 0.012% 99.120% ( 51, 76 ] 25 0.013% 99.133% ( 76, 110 ] 18 0.009% 99.142% ( 110, 170 ] 129 0.067% 99.210% ( 170, 250 ] 172 0.090% 99.300% ( 250, 380 ] 206 0.108% 99.407% ( 380, 580 ] 257 0.134% 99.542% ( 580, 870 ] 305 0.159% 99.701% ( 870, 1300 ] 231 0.121% 99.822% ( 1300, 1900 ] 128 0.067% 99.889% ( 1900, 2900 ] 91 0.048% 99.936% ( 2900, 4400 ] 102 0.053% 99.990% ( 4400, 6600 ] 29 0.015% 100.005% ( 6600, 9900 ] 9 0.005% 100.009% ( 9900, 14000 ] 1 0.001% 100.010% ** Level 2 read latency histogram (micros): Count: 535058 Average: 13.8366 StdDev: 216.05 Min: 0 Median: 1.9696 Max: 36638 Percentiles: P50: 1.97 P75: 3.02 P99: 12.63 P99.9: 1562.35 P99.99: 2379.20 ------------------------------------------------------ [ 0, 1 ] 14018 2.620% 2.620% # ( 1, 2 ] 261466 48.867% 51.487% ########## ( 2, 3 ] 124821 23.328% 74.815% ##### ( 3, 4 ] 56753 10.607% 85.422% ## ( 4, 6 ] 56389 10.539% 95.961% ## ( 6, 10 ] 14368 2.685% 98.646% # ( 10, 15 ] 3596 0.672% 99.318% ( 15, 22 ] 521 0.097% 99.416% ( 22, 34 ] 92 0.017% 99.433% ( 34, 51 ] 53 0.010% 99.443% ( 51, 76 ] 38 0.007% 99.450% ( 76, 110 ] 22 0.004% 99.454% ( 110, 170 ] 61 0.011% 99.465% ( 170, 250 ] 115 0.021% 99.487% ( 250, 380 ] 246 0.046% 99.533% ( 380, 580 ] 467 0.087% 99.620% ( 580, 870 ] 661 0.124% 99.744% ( 870, 1300 ] 623 0.116% 99.860% ( 1300, 1900 ] 487 0.091% 99.951% ( 1900, 2900 ] 433 0.081% 100.032% ( 2900, 4400 ] 361 0.067% 100.100% ( 4400, 6600 ] 109 0.020% 100.120% ( 6600, 9900 ] 28 0.005% 100.125% ( 9900, 14000 ] 6 0.001% 100.126% ( 14000, 22000 ] 12 0.002% 100.129% ( 22000, 33000 ] 6 0.001% 100.130% ( 33000, 50000 ] 2 0.000% 100.130% ** Level 3 read latency histogram (micros): Count: 2013382 Average: 10.0385 StdDev: 137.55 Min: 1 Median: 1.9560 Max: 23276 Percentiles: P50: 1.96 P75: 2.96 P99: 9.87 P99.9: 860.15 P99.99: 1284.24 ------------------------------------------------------ [ 0, 1 ] 35559 1.766% 1.766% ( 1, 2 ] 1015870 50.456% 52.222% ########## ( 2, 3 ] 478054 23.744% 75.966% ##### ( 3, 4 ] 206904 10.276% 86.242% ## ( 4, 6 ] 210236 10.442% 96.684% ## ( 6, 10 ] 48245 2.396% 99.080% ( 10, 15 ] 10052 0.499% 99.580% ( 15, 22 ] 1139 0.057% 99.636% ( 22, 34 ] 114 0.006% 99.642% ( 34, 51 ] 112 0.006% 99.648% ( 51, 76 ] 188 0.009% 99.657% ( 76, 110 ] 94 0.005% 99.662% ( 110, 170 ] 250 0.012% 99.674% ( 170, 250 ] 399 0.020% 99.694% ( 250, 380 ] 797 0.040% 99.733% ( 380, 580 ] 1410 0.070% 99.803% ( 580, 870 ] 2014 0.100% 99.903% ( 870, 1300 ] 1810 0.090% 99.993% ( 1300, 1900 ] 1240 0.062% 100.055% ( 1900, 2900 ] 973 0.048% 100.103% ( 2900, 4400 ] 1039 0.052% 100.155% ( 4400, 6600 ] 273 0.014% 100.168% ( 6600, 9900 ] 43 0.002% 100.171% ( 9900, 14000 ] 5 0.000% 100.171% ( 14000, 22000 ] 4 0.000% 100.171% ( 22000, 33000 ] 2 0.000% 100.171% ** Level 4 read latency histogram (micros): Count: 1185521 Average: 18.4904 StdDev: 196.04 Min: 0 Median: 1.9534 Max: 30441 Percentiles: P50: 1.95 P75: 2.98 P99: 297.09 P99.9: 2069.73 P99.99: 2944.57 ------------------------------------------------------ [ 0, 1 ] 22440 1.893% 1.893% ( 1, 2 ] 598208 50.460% 52.352% ########## ( 2, 3 ] 274562 23.160% 75.512% ##### ( 3, 4 ] 118734 10.015% 85.527% ## ( 4, 6 ] 120292 10.147% 95.674% ## ( 6, 10 ] 29179 2.461% 98.135% ( 10, 15 ] 6230 0.526% 98.661% ( 15, 22 ] 660 0.056% 98.717% ( 22, 34 ] 64 0.005% 98.722% ( 34, 51 ] 85 0.007% 98.729% ( 51, 76 ] 138 0.012% 98.741% ( 76, 110 ] 191 0.016% 98.757% ( 110, 170 ] 1009 0.085% 98.842% ( 170, 250 ] 1321 0.111% 98.953% ( 250, 380 ] 1526 0.129% 99.082% ( 380, 580 ] 2401 0.203% 99.285% ( 580, 870 ] 2908 0.245% 99.530% ( 870, 1300 ] 2639 0.223% 99.753% ( 1300, 1900 ] 1537 0.130% 99.882% ( 1900, 2900 ] 1246 0.105% 99.987% ( 2900, 4400 ] 1092 0.092% 100.079% ( 4400, 6600 ] 327 0.028% 100.107% ( 6600, 9900 ] 57 0.005% 100.112% ( 9900, 14000 ] 10 0.001% 100.113% ( 14000, 22000 ] 4 0.000% 100.113% ( 22000, 33000 ] 2 0.000% 100.113% ** Level 5 read latency histogram (micros): Count: 52162 Average: 1042.9239 StdDev: 1270.99 Min: 76 Median: 664.8003 Max: 61966 Percentiles: P50: 664.80 P75: 1223.05 P99: 5858.26 P99.9: 9553.82 P99.99: 29952.72 ------------------------------------------------------ ( 51, 76 ] 1 0.002% 0.002% ( 76, 110 ] 782 1.499% 1.501% ( 110, 170 ] 3925 7.525% 9.026% ## ( 170, 250 ] 4645 8.905% 17.931% ## ( 250, 380 ] 5787 11.094% 29.025% ## ( 380, 580 ] 8173 15.668% 44.693% ### ( 580, 870 ] 9466 18.147% 62.841% #### ( 870, 1300 ] 7725 14.810% 77.650% ### ( 1300, 1900 ] 4209 8.069% 85.719% ## ( 1900, 2900 ] 3183 6.102% 91.822% # ( 2900, 4400 ] 3059 5.864% 97.686% # ( 4400, 6600 ] 1034 1.982% 99.668% ( 6600, 9900 ] 135 0.259% 99.927% ( 9900, 14000 ] 19 0.036% 99.964% ( 14000, 22000 ] 8 0.015% 99.979% ( 22000, 33000 ] 8 0.015% 99.994% ( 33000, 50000 ] 4 0.008% 100.002% ( 50000, 75000 ] 1 0.002% 100.004% ** DB Stats ** Uptime(secs): 18.7 total, 4.9 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 157.51 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:6.990 H:M:S, 37.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 202.25 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.020 H:M:S, 21.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/14-05:29:14 ... thread 0: (1000000,4000000) ops and (287370.2,181426.5) ops/second in (3.479832,22.047492) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/10 2.46 GB 132.2 2.5 0.0 2.5 6.2 3.7 0.0 1.7 77.1 194.6 32.68 20.64 61 0.536 2558K 2722 0.0 0.0 L1 11/11 911.10 MB 0.0 1.5 1.4 0.1 1.5 1.4 0.0 1.1 147.1 146.6 10.27 6.97 3 3.423 1533K 4000 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.0 0.3 0.3 0.0 0.5 43.8 101.9 101.8 2.59 1.18 1 2.587 267K 208 0.0 0.0 L3 16/0 935.20 MB 0.9 5.2 2.5 2.7 5.2 2.5 0.0 2.1 113.0 112.0 47.46 25.17 20 2.373 3172K 3439 0.0 0.0 L4 178/0 9.69 GB 1.0 10.2 5.6 4.6 10.1 5.5 0.4 1.8 126.9 124.8 82.66 47.84 59 1.401 5094K 10K 0.0 0.0 L5 1160/0 95.42 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1381/21 109.37 GB 0.0 19.7 9.5 10.1 23.2 13.1 6.8 6.2 114.7 135.3 175.65 101.80 144 1.220 12M 21K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.7 9.5 10.1 23.2 13.1 6.8 6.2 114.7 135.3 175.65 101.80 144 1.220 12M 21K 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 19.7 9.5 10.1 19.5 9.3 0.0 0.0 130.3 128.8 154.66 91.05 92 1.681 12M 21K 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 183.1 20.99 10.75 52 0.404 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 22.2 total, 22.0 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: 23.20 GB write, 1069.08 MB/s write, 19.67 GB read, 906.41 MB/s read, 175.7 seconds Interval compaction: 23.20 GB write, 1077.61 MB/s write, 19.67 GB read, 913.65 MB/s read, 175.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 65, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 65, interval: 65 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1095825 Average: 9.8018 StdDev: 107.24 Min: 0 Median: 1.7185 Max: 22060 Percentiles: P50: 1.72 P75: 2.55 P99: 166.93 P99.9: 1037.08 P99.99: 2268.03 ------------------------------------------------------ [ 0, 1 ] 111443 10.170% 10.170% ## ( 1, 2 ] 607459 55.434% 65.604% ########### ( 2, 3 ] 188501 17.202% 82.805% ### ( 3, 4 ] 77515 7.074% 89.879% # ( 4, 6 ] 72846 6.648% 96.527% # ( 6, 10 ] 14952 1.364% 97.891% ( 10, 15 ] 3109 0.284% 98.175% ( 15, 22 ] 320 0.029% 98.204% ( 22, 34 ] 43 0.004% 98.208% ( 34, 51 ] 23 0.002% 98.210% ( 51, 76 ] 45 0.004% 98.214% ( 76, 110 ] 1923 0.175% 98.390% ( 110, 170 ] 7050 0.643% 99.033% ( 170, 250 ] 4028 0.368% 99.401% ( 250, 380 ] 2041 0.186% 99.587% ( 380, 580 ] 1940 0.177% 99.764% ( 580, 870 ] 1179 0.108% 99.872% ( 870, 1300 ] 806 0.074% 99.945% ( 1300, 1900 ] 390 0.036% 99.981% ( 1900, 2900 ] 281 0.026% 100.006% ( 2900, 4400 ] 263 0.024% 100.030% ( 4400, 6600 ] 75 0.007% 100.037% ( 6600, 9900 ] 12 0.001% 100.038% ( 9900, 14000 ] 5 0.000% 100.039% ( 14000, 22000 ] 2 0.000% 100.039% ( 22000, 33000 ] 1 0.000% 100.039% ** Level 1 read latency histogram (micros): Count: 213072 Average: 11.8756 StdDev: 138.56 Min: 1 Median: 1.9378 Max: 10549 Percentiles: P50: 1.94 P75: 2.92 P99: 144.92 P99.9: 1910.09 P99.99: 4380.78 ------------------------------------------------------ [ 0, 1 ] 4591 2.155% 2.155% ( 1, 2 ] 108706 51.018% 53.173% ########## ( 2, 3 ] 50294 23.604% 76.777% ##### ( 3, 4 ] 19668 9.231% 86.008% ## ( 4, 6 ] 20330 9.541% 95.549% ## ( 6, 10 ] 5421 2.544% 98.094% # ( 10, 15 ] 1174 0.551% 98.645% ( 15, 22 ] 213 0.100% 98.745% ( 22, 34 ] 19 0.009% 98.753% ( 34, 51 ] 24 0.011% 98.765% ( 51, 76 ] 25 0.012% 98.776% ( 76, 110 ] 144 0.068% 98.844% ( 110, 170 ] 571 0.268% 99.112% ( 170, 250 ] 384 0.180% 99.292% ( 250, 380 ] 294 0.138% 99.430% ( 380, 580 ] 310 0.145% 99.576% ( 580, 870 ] 324 0.152% 99.728% ( 870, 1300 ] 238 0.112% 99.839% ( 1300, 1900 ] 128 0.060% 99.900% ( 1900, 2900 ] 92 0.043% 99.943% ( 2900, 4400 ] 102 0.048% 99.991% ( 4400, 6600 ] 29 0.014% 100.004% ( 6600, 9900 ] 9 0.004% 100.008% ( 9900, 14000 ] 1 0.000% 100.009% ** Level 2 read latency histogram (micros): Count: 535058 Average: 13.8366 StdDev: 216.05 Min: 0 Median: 1.9696 Max: 36638 Percentiles: P50: 1.97 P75: 3.02 P99: 12.63 P99.9: 1562.35 P99.99: 2379.20 ------------------------------------------------------ [ 0, 1 ] 14018 2.620% 2.620% # ( 1, 2 ] 261466 48.867% 51.487% ########## ( 2, 3 ] 124821 23.328% 74.815% ##### ( 3, 4 ] 56753 10.607% 85.422% ## ( 4, 6 ] 56389 10.539% 95.961% ## ( 6, 10 ] 14368 2.685% 98.646% # ( 10, 15 ] 3596 0.672% 99.318% ( 15, 22 ] 521 0.097% 99.416% ( 22, 34 ] 92 0.017% 99.433% ( 34, 51 ] 53 0.010% 99.443% ( 51, 76 ] 38 0.007% 99.450% ( 76, 110 ] 22 0.004% 99.454% ( 110, 170 ] 61 0.011% 99.465% ( 170, 250 ] 115 0.021% 99.487% ( 250, 380 ] 246 0.046% 99.533% ( 380, 580 ] 467 0.087% 99.620% ( 580, 870 ] 661 0.124% 99.744% ( 870, 1300 ] 623 0.116% 99.860% ( 1300, 1900 ] 487 0.091% 99.951% ( 1900, 2900 ] 433 0.081% 100.032% ( 2900, 4400 ] 361 0.067% 100.100% ( 4400, 6600 ] 109 0.020% 100.120% ( 6600, 9900 ] 28 0.005% 100.125% ( 9900, 14000 ] 6 0.001% 100.126% ( 14000, 22000 ] 12 0.002% 100.129% ( 22000, 33000 ] 6 0.001% 100.130% ( 33000, 50000 ] 2 0.000% 100.130% ** Level 3 read latency histogram (micros): Count: 2020811 Average: 10.1150 StdDev: 137.41 Min: 1 Median: 1.9554 Max: 23276 Percentiles: P50: 1.96 P75: 2.96 P99: 9.95 P99.9: 860.23 P99.99: 1284.35 ------------------------------------------------------ [ 0, 1 ] 36049 1.784% 1.784% ( 1, 2 ] 1019816 50.466% 52.250% ########## ( 2, 3 ] 479219 23.714% 75.964% ##### ( 3, 4 ] 207244 10.255% 86.219% ## ( 4, 6 ] 210535 10.418% 96.638% ## ( 6, 10 ] 48379 2.394% 99.032% ( 10, 15 ] 10068 0.498% 99.530% ( 15, 22 ] 1141 0.056% 99.586% ( 22, 34 ] 114 0.006% 99.592% ( 34, 51 ] 112 0.006% 99.597% ( 51, 76 ] 188 0.009% 99.607% ( 76, 110 ] 212 0.010% 99.617% ( 110, 170 ] 742 0.037% 99.654% ( 170, 250 ] 635 0.031% 99.685% ( 250, 380 ] 886 0.044% 99.729% ( 380, 580 ] 1477 0.073% 99.802% ( 580, 870 ] 2042 0.101% 99.903% ( 870, 1300 ] 1816 0.090% 99.993% ( 1300, 1900 ] 1240 0.061% 100.055% ( 1900, 2900 ] 974 0.048% 100.103% ( 2900, 4400 ] 1039 0.051% 100.154% ( 4400, 6600 ] 273 0.014% 100.168% ( 6600, 9900 ] 43 0.002% 100.170% ( 9900, 14000 ] 5 0.000% 100.170% ( 14000, 22000 ] 4 0.000% 100.170% ( 22000, 33000 ] 2 0.000% 100.170% ** Level 4 read latency histogram (micros): Count: 1198845 Average: 19.5350 StdDev: 195.90 Min: 0 Median: 1.9582 Max: 30441 Percentiles: P50: 1.96 P75: 3.00 P99: 359.25 P99.9: 2061.72 P99.99: 2942.66 ------------------------------------------------------ [ 0, 1 ] 22858 1.907% 1.907% ( 1, 2 ] 601685 50.189% 52.095% ########## ( 2, 3 ] 275857 23.010% 75.106% ##### ( 3, 4 ] 119153 9.939% 85.045% ## ( 4, 6 ] 120765 10.073% 95.118% ## ( 6, 10 ] 29323 2.446% 97.564% ( 10, 15 ] 6244 0.521% 98.085% ( 15, 22 ] 665 0.055% 98.140% ( 22, 34 ] 65 0.005% 98.146% ( 34, 51 ] 85 0.007% 98.153% ( 51, 76 ] 138 0.012% 98.164% ( 76, 110 ] 1081 0.090% 98.254% ( 110, 170 ] 4293 0.358% 98.613% ( 170, 250 ] 2805 0.234% 98.847% ( 250, 380 ] 2189 0.183% 99.029% ( 380, 580 ] 2937 0.245% 99.274% ( 580, 870 ] 3086 0.257% 99.532% ( 870, 1300 ] 2670 0.223% 99.754% ( 1300, 1900 ] 1545 0.129% 99.883% ( 1900, 2900 ] 1250 0.104% 99.987% ( 2900, 4400 ] 1094 0.091% 100.079% ( 4400, 6600 ] 327 0.027% 100.106% ( 6600, 9900 ] 57 0.005% 100.111% ( 9900, 14000 ] 10 0.001% 100.112% ( 14000, 22000 ] 4 0.000% 100.112% ( 22000, 33000 ] 2 0.000% 100.112% ** Level 5 read latency histogram (micros): Count: 94088 Average: 670.5724 StdDev: 1039.09 Min: 74 Median: 302.6493 Max: 61966 Percentiles: P50: 302.65 P75: 762.84 P99: 4949.19 P99.9: 8333.40 P99.99: 15591.20 ------------------------------------------------------ ( 51, 76 ] 4 0.004% 0.004% ( 76, 110 ] 6309 6.705% 6.710% # ( 110, 170 ] 23228 24.688% 31.397% ##### ( 170, 250 ] 13611 14.466% 45.863% ### ( 250, 380 ] 9610 10.214% 56.077% ## ( 380, 580 ] 11201 11.905% 67.982% ## ( 580, 870 ] 10473 11.131% 79.113% ## ( 870, 1300 ] 7930 8.428% 87.541% ## ( 1300, 1900 ] 4243 4.510% 92.051% # ( 1900, 2900 ] 3208 3.410% 95.461% # ( 2900, 4400 ] 3072 3.265% 98.726% # ( 4400, 6600 ] 1034 1.099% 99.825% ( 6600, 9900 ] 135 0.143% 99.968% ( 9900, 14000 ] 19 0.020% 99.988% ( 14000, 22000 ] 8 0.009% 99.997% ( 22000, 33000 ] 8 0.009% 100.005% ( 33000, 50000 ] 4 0.004% 100.010% ( 50000, 75000 ] 1 0.001% 100.011% ** DB Stats ** Uptime(secs): 22.2 total, 3.5 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 177.13 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:6.990 H:M:S, 31.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 282.83 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: 2 num-running-flushes: 1 2024/07/14-05:29:19 ... thread 0: (1000000,5000000) ops and (204055.1,185541.6) ops/second in (4.900637,26.948129) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/13 3.44 GB 100.7 3.7 0.0 3.7 8.4 4.7 0.0 1.8 93.3 213.0 40.50 27.97 82 0.494 3838K 3916 0.0 0.0 L1 11/11 911.10 MB 0.0 1.5 1.4 0.1 1.5 1.4 0.0 1.1 147.1 146.6 10.27 6.97 3 3.423 1533K 4000 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.0 0.3 0.3 0.0 0.5 43.8 101.9 101.8 2.59 1.18 1 2.587 267K 208 0.0 0.0 L3 16/0 935.20 MB 0.9 5.2 2.5 2.7 5.2 2.5 0.0 2.1 113.0 112.0 47.46 25.17 20 2.373 3172K 3439 0.0 0.0 L4 178/0 9.69 GB 1.0 10.2 5.6 4.6 10.1 5.5 0.4 1.8 126.9 124.8 82.66 47.84 59 1.401 5094K 10K 0.0 0.0 L5 1160/0 95.42 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1382/24 110.35 GB 0.0 20.9 9.5 11.4 25.4 14.1 6.8 5.4 116.7 141.9 183.47 109.13 165 1.112 13M 22K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.9 9.5 11.4 25.4 14.1 6.8 5.4 116.7 141.9 183.47 109.13 165 1.112 13M 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 20.9 9.5 11.4 20.7 9.3 0.0 0.0 134.3 132.9 159.38 95.67 97 1.643 13M 22K 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 201.3 24.09 13.45 68 0.354 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): 27.1 total, 26.9 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: 25.42 GB write, 959.50 MB/s write, 20.90 GB read, 789.11 MB/s read, 183.5 seconds Interval compaction: 25.42 GB write, 965.77 MB/s write, 20.90 GB read, 794.26 MB/s read, 183.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 5, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 5, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 65, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 5, total-stops: 65, interval: 70 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1433523 Average: 11.3465 StdDev: 98.72 Min: 0 Median: 1.6495 Max: 22060 Percentiles: P50: 1.65 P75: 2.39 P99: 213.03 P99.9: 845.10 P99.99: 1746.82 ------------------------------------------------------ [ 0, 1 ] 205770 14.354% 14.354% ### ( 1, 2 ] 786751 54.882% 69.236% ########### ( 2, 3 ] 211334 14.742% 83.979% ### ( 3, 4 ] 86016 6.000% 89.979% # ( 4, 6 ] 78238 5.458% 95.437% # ( 6, 10 ] 15886 1.108% 96.545% ( 10, 15 ] 3318 0.231% 96.776% ( 15, 22 ] 346 0.024% 96.801% ( 22, 34 ] 44 0.003% 96.804% ( 34, 51 ] 23 0.002% 96.805% ( 51, 76 ] 50 0.003% 96.809% ( 76, 110 ] 5801 0.405% 97.213% ( 110, 170 ] 20637 1.440% 98.653% ( 170, 250 ] 9250 0.645% 99.298% ( 250, 380 ] 3790 0.264% 99.563% ( 380, 580 ] 3404 0.237% 99.800% ( 580, 870 ] 1567 0.109% 99.909% ( 870, 1300 ] 860 0.060% 99.969% ( 1300, 1900 ] 397 0.028% 99.997% ( 1900, 2900 ] 297 0.021% 100.018% ( 2900, 4400 ] 272 0.019% 100.037% ( 4400, 6600 ] 75 0.005% 100.042% ( 6600, 9900 ] 12 0.001% 100.043% ( 9900, 14000 ] 5 0.000% 100.043% ( 14000, 22000 ] 2 0.000% 100.043% ( 22000, 33000 ] 1 0.000% 100.043% ** Level 1 read latency histogram (micros): Count: 234957 Average: 12.4232 StdDev: 133.19 Min: 1 Median: 1.9911 Max: 10549 Percentiles: P50: 1.99 P75: 3.16 P99: 178.40 P99.9: 1802.53 P99.99: 4333.89 ------------------------------------------------------ [ 0, 1 ] 4945 2.105% 2.105% ( 1, 2 ] 113548 48.327% 50.432% ########## ( 2, 3 ] 54073 23.014% 73.446% ##### ( 3, 4 ] 23412 9.964% 83.410% ## ( 4, 6 ] 26234 11.165% 94.576% ## ( 6, 10 ] 6543 2.785% 97.360% # ( 10, 15 ] 1435 0.611% 97.971% ( 15, 22 ] 398 0.169% 98.141% ( 22, 34 ] 39 0.017% 98.157% ( 34, 51 ] 27 0.011% 98.169% ( 51, 76 ] 25 0.011% 98.179% ( 76, 110 ] 395 0.168% 98.347% ( 110, 170 ] 1461 0.622% 98.969% ( 170, 250 ] 690 0.294% 99.263% ( 250, 380 ] 409 0.174% 99.437% ( 380, 580 ] 389 0.166% 99.602% ( 580, 870 ] 350 0.149% 99.751% ( 870, 1300 ] 241 0.103% 99.854% ( 1300, 1900 ] 129 0.055% 99.909% ( 1900, 2900 ] 93 0.040% 99.949% ( 2900, 4400 ] 102 0.043% 99.992% ( 4400, 6600 ] 29 0.012% 100.004% ( 6600, 9900 ] 9 0.004% 100.008% ( 9900, 14000 ] 1 0.000% 100.009% ** Level 2 read latency histogram (micros): Count: 535058 Average: 13.8366 StdDev: 216.05 Min: 0 Median: 1.9696 Max: 36638 Percentiles: P50: 1.97 P75: 3.02 P99: 12.63 P99.9: 1562.35 P99.99: 2379.20 ------------------------------------------------------ [ 0, 1 ] 14018 2.620% 2.620% # ( 1, 2 ] 261466 48.867% 51.487% ########## ( 2, 3 ] 124821 23.328% 74.815% ##### ( 3, 4 ] 56753 10.607% 85.422% ## ( 4, 6 ] 56389 10.539% 95.961% ## ( 6, 10 ] 14368 2.685% 98.646% # ( 10, 15 ] 3596 0.672% 99.318% ( 15, 22 ] 521 0.097% 99.416% ( 22, 34 ] 92 0.017% 99.433% ( 34, 51 ] 53 0.010% 99.443% ( 51, 76 ] 38 0.007% 99.450% ( 76, 110 ] 22 0.004% 99.454% ( 110, 170 ] 61 0.011% 99.465% ( 170, 250 ] 115 0.021% 99.487% ( 250, 380 ] 246 0.046% 99.533% ( 380, 580 ] 467 0.087% 99.620% ( 580, 870 ] 661 0.124% 99.744% ( 870, 1300 ] 623 0.116% 99.860% ( 1300, 1900 ] 487 0.091% 99.951% ( 1900, 2900 ] 433 0.081% 100.032% ( 2900, 4400 ] 361 0.067% 100.100% ( 4400, 6600 ] 109 0.020% 100.120% ( 6600, 9900 ] 28 0.005% 100.125% ( 9900, 14000 ] 6 0.001% 100.126% ( 14000, 22000 ] 12 0.002% 100.129% ( 22000, 33000 ] 6 0.001% 100.130% ( 33000, 50000 ] 2 0.000% 100.130% ** Level 3 read latency histogram (micros): Count: 2022378 Average: 10.2457 StdDev: 137.48 Min: 1 Median: 1.9562 Max: 23276 Percentiles: P50: 1.96 P75: 2.96 P99: 10.45 P99.9: 860.69 P99.99: 1284.58 ------------------------------------------------------ [ 0, 1 ] 36049 1.783% 1.783% ( 1, 2 ] 1019816 50.427% 52.209% ########## ( 2, 3 ] 479219 23.696% 75.905% ##### ( 3, 4 ] 207244 10.248% 86.152% ## ( 4, 6 ] 210535 10.410% 96.563% ## ( 6, 10 ] 48379 2.392% 98.955% ( 10, 15 ] 10068 0.498% 99.453% ( 15, 22 ] 1141 0.056% 99.509% ( 22, 34 ] 114 0.006% 99.515% ( 34, 51 ] 112 0.006% 99.520% ( 51, 76 ] 188 0.009% 99.530% ( 76, 110 ] 465 0.023% 99.553% ( 110, 170 ] 1587 0.078% 99.631% ( 170, 250 ] 922 0.046% 99.677% ( 250, 380 ] 966 0.048% 99.724% ( 380, 580 ] 1550 0.077% 99.801% ( 580, 870 ] 2067 0.102% 99.903% ( 870, 1300 ] 1819 0.090% 99.993% ( 1300, 1900 ] 1241 0.061% 100.055% ( 1900, 2900 ] 974 0.048% 100.103% ( 2900, 4400 ] 1039 0.051% 100.154% ( 4400, 6600 ] 273 0.013% 100.168% ( 6600, 9900 ] 43 0.002% 100.170% ( 9900, 14000 ] 5 0.000% 100.170% ( 14000, 22000 ] 4 0.000% 100.170% ( 22000, 33000 ] 2 0.000% 100.170% ** Level 4 read latency histogram (micros): Count: 1211249 Average: 21.1088 StdDev: 195.95 Min: 0 Median: 1.9685 Max: 30441 Percentiles: P50: 1.97 P75: 3.07 P99: 397.09 P99.9: 2055.85 P99.99: 2940.92 ------------------------------------------------------ [ 0, 1 ] 22858 1.887% 1.887% ( 1, 2 ] 601741 49.679% 51.567% ########## ( 2, 3 ] 276005 22.787% 74.353% ##### ( 3, 4 ] 119271 9.847% 84.200% ## ( 4, 6 ] 120931 9.984% 94.184% ## ( 6, 10 ] 29339 2.422% 96.606% ( 10, 15 ] 6252 0.516% 97.123% ( 15, 22 ] 665 0.055% 97.178% ( 22, 34 ] 65 0.005% 97.183% ( 34, 51 ] 85 0.007% 97.190% ( 51, 76 ] 138 0.011% 97.201% ( 76, 110 ] 2994 0.247% 97.449% ( 110, 170 ] 10665 0.880% 98.329% ( 170, 250 ] 4910 0.405% 98.734% ( 250, 380 ] 2917 0.241% 98.975% ( 380, 580 ] 3517 0.290% 99.266% ( 580, 870 ] 3247 0.268% 99.534% ( 870, 1300 ] 2690 0.222% 99.756% ( 1300, 1900 ] 1552 0.128% 99.884% ( 1900, 2900 ] 1256 0.104% 99.988% ( 2900, 4400 ] 1095 0.090% 100.078% ( 4400, 6600 ] 327 0.027% 100.105% ( 6600, 9900 ] 57 0.005% 100.110% ( 9900, 14000 ] 10 0.001% 100.110% ( 14000, 22000 ] 4 0.000% 100.111% ( 22000, 33000 ] 2 0.000% 100.111% ** Level 5 read latency histogram (micros): Count: 159171 Average: 470.7434 StdDev: 838.12 Min: 74 Median: 186.7224 Max: 61966 Percentiles: P50: 186.72 P75: 461.92 P99: 4201.18 P99.9: 6580.49 P99.99: 9877.58 ------------------------------------------------------ ( 51, 76 ] 8 0.005% 0.005% ( 76, 110 ] 16703 10.494% 10.499% ## ( 110, 170 ] 57557 36.160% 46.659% ####### ( 170, 250 ] 25439 15.982% 62.641% ### ( 250, 380 ] 13713 8.615% 71.257% ## ( 380, 580 ] 14547 9.139% 80.396% ## ( 580, 870 ] 11387 7.154% 87.550% # ( 870, 1300 ] 8054 5.060% 92.610% # ( 1300, 1900 ] 4266 2.680% 95.290% # ( 1900, 2900 ] 3237 2.034% 97.324% ( 2900, 4400 ] 3076 1.933% 99.256% ( 4400, 6600 ] 1034 0.650% 99.906% ( 6600, 9900 ] 135 0.085% 99.991% ( 9900, 14000 ] 19 0.012% 100.003% ( 14000, 22000 ] 8 0.005% 100.008% ( 22000, 33000 ] 8 0.005% 100.013% ( 33000, 50000 ] 4 0.003% 100.015% ( 50000, 75000 ] 1 0.001% 100.016% ** DB Stats ** Uptime(secs): 27.1 total, 4.9 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 181.41 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:8.381 H:M:S, 30.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 200.83 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.391 H:M:S, 28.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/14-05:29:27 ... thread 0: (1000000,6000000) ops and (122214.3,170791.9) ops/second in (8.182349,35.130478) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/6 4.35 GB 351.4 6.0 0.0 6.0 11.6 5.6 0.0 2.1 117.3 228.3 52.08 39.03 101 0.516 6203K 15K 0.0 0.0 L1 11/11 911.10 MB 0.0 1.5 1.4 0.1 1.5 1.4 0.0 1.1 147.1 146.6 10.27 6.97 3 3.423 1533K 4000 0.0 0.0 L2 0/0 0.00 KB 0.0 0.3 0.0 0.3 0.3 0.0 0.5 43.8 101.9 101.8 2.59 1.18 1 2.587 267K 208 0.0 0.0 L3 16/0 935.20 MB 0.9 5.2 2.5 2.7 5.2 2.5 0.0 2.1 113.0 112.0 47.46 25.17 20 2.373 3172K 3439 0.0 0.0 L4 178/0 9.69 GB 1.0 10.2 5.6 4.6 10.1 5.5 0.4 1.8 126.9 124.8 82.66 47.84 59 1.401 5094K 10K 0.0 0.0 L5 1160/0 95.42 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1382/17 111.26 GB 0.0 23.2 9.5 13.6 28.6 15.0 6.8 5.1 121.7 150.2 195.05 120.18 184 1.060 16M 33K 0.0 0.0 Int 0/0 0.00 KB 0.0 23.2 9.5 13.6 28.6 15.0 6.8 5.1 121.7 150.2 195.05 120.18 184 1.060 16M 33K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 23.2 9.5 13.6 22.9 9.3 0.0 0.0 141.3 139.9 167.99 104.15 101 1.663 16M 33K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 214.2 27.06 16.04 83 0.326 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 35.3 total, 35.1 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 28.60 GB write, 829.56 MB/s write, 23.18 GB read, 672.22 MB/s read, 195.1 seconds Interval compaction: 28.60 GB write, 833.72 MB/s write, 23.18 GB read, 675.58 MB/s read, 195.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 65, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 12, total-stops: 65, interval: 77 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2095302 Average: 12.8141 StdDev: 88.35 Min: 0 Median: 1.5724 Max: 22060 Percentiles: P50: 1.57 P75: 2.15 P99: 229.04 P99.9: 723.16 P99.99: 1204.56 ------------------------------------------------------ [ 0, 1 ] 395628 18.882% 18.882% #### ( 1, 2 ] 1139008 54.360% 73.242% ########### ( 2, 3 ] 253997 12.122% 85.364% ## ( 3, 4 ] 100795 4.811% 90.174% # ( 4, 6 ] 86283 4.118% 94.292% # ( 6, 10 ] 17306 0.826% 95.118% ( 10, 15 ] 3627 0.173% 95.291% ( 15, 22 ] 385 0.018% 95.310% ( 22, 34 ] 46 0.002% 95.312% ( 34, 51 ] 25 0.001% 95.313% ( 51, 76 ] 61 0.003% 95.316% ( 76, 110 ] 14499 0.692% 96.008% ( 110, 170 ] 48782 2.328% 98.336% ( 170, 250 ] 18845 0.899% 99.236% ( 250, 380 ] 6985 0.333% 99.569% ( 380, 580 ] 5820 0.278% 99.847% ( 580, 870 ] 2260 0.108% 99.955% ( 870, 1300 ] 953 0.045% 100.000% ( 1300, 1900 ] 407 0.019% 100.020% ( 1900, 2900 ] 321 0.015% 100.035% ( 2900, 4400 ] 278 0.013% 100.048% ( 4400, 6600 ] 77 0.004% 100.052% ( 6600, 9900 ] 12 0.001% 100.052% ( 9900, 14000 ] 5 0.000% 100.053% ( 14000, 22000 ] 2 0.000% 100.053% ( 22000, 33000 ] 1 0.000% 100.053% ** Level 1 read latency histogram (micros): Count: 274178 Average: 12.9309 StdDev: 125.23 Min: 1 Median: 2.1667 Max: 10549 Percentiles: P50: 2.17 P75: 3.44 P99: 203.06 P99.9: 1622.26 P99.99: 4276.21 ------------------------------------------------------ [ 0, 1 ] 5132 1.872% 1.872% ( 1, 2 ] 120771 44.048% 45.920% ######### ( 2, 3 ] 67095 24.471% 70.391% ##### ( 3, 4 ] 28891 10.537% 80.929% ## ( 4, 6 ] 34451 12.565% 93.494% ### ( 6, 10 ] 8178 2.983% 96.477% # ( 10, 15 ] 1932 0.705% 97.181% ( 15, 22 ] 642 0.234% 97.416% ( 22, 34 ] 63 0.023% 97.439% ( 34, 51 ] 30 0.011% 97.449% ( 51, 76 ] 25 0.009% 97.459% ( 76, 110 ] 794 0.290% 97.748% ( 110, 170 ] 2952 1.077% 98.825% ( 170, 250 ] 1162 0.424% 99.249% ( 250, 380 ] 580 0.212% 99.460% ( 380, 580 ] 494 0.180% 99.640% ( 580, 870 ] 398 0.145% 99.786% ( 870, 1300 ] 244 0.089% 99.875% ( 1300, 1900 ] 130 0.047% 99.922% ( 1900, 2900 ] 93 0.034% 99.956% ( 2900, 4400 ] 102 0.037% 99.993% ( 4400, 6600 ] 30 0.011% 100.004% ( 6600, 9900 ] 9 0.003% 100.007% ( 9900, 14000 ] 1 0.000% 100.008% ** Level 2 read latency histogram (micros): Count: 535058 Average: 13.8366 StdDev: 216.05 Min: 0 Median: 1.9696 Max: 36638 Percentiles: P50: 1.97 P75: 3.02 P99: 12.63 P99.9: 1562.35 P99.99: 2379.20 ------------------------------------------------------ [ 0, 1 ] 14018 2.620% 2.620% # ( 1, 2 ] 261466 48.867% 51.487% ########## ( 2, 3 ] 124821 23.328% 74.815% ##### ( 3, 4 ] 56753 10.607% 85.422% ## ( 4, 6 ] 56389 10.539% 95.961% ## ( 6, 10 ] 14368 2.685% 98.646% # ( 10, 15 ] 3596 0.672% 99.318% ( 15, 22 ] 521 0.097% 99.416% ( 22, 34 ] 92 0.017% 99.433% ( 34, 51 ] 53 0.010% 99.443% ( 51, 76 ] 38 0.007% 99.450% ( 76, 110 ] 22 0.004% 99.454% ( 110, 170 ] 61 0.011% 99.465% ( 170, 250 ] 115 0.021% 99.487% ( 250, 380 ] 246 0.046% 99.533% ( 380, 580 ] 467 0.087% 99.620% ( 580, 870 ] 661 0.124% 99.744% ( 870, 1300 ] 623 0.116% 99.860% ( 1300, 1900 ] 487 0.091% 99.951% ( 1900, 2900 ] 433 0.081% 100.032% ( 2900, 4400 ] 361 0.067% 100.100% ( 4400, 6600 ] 109 0.020% 100.120% ( 6600, 9900 ] 28 0.005% 100.125% ( 9900, 14000 ] 6 0.001% 100.126% ( 14000, 22000 ] 12 0.002% 100.129% ( 22000, 33000 ] 6 0.001% 100.130% ( 33000, 50000 ] 2 0.000% 100.130% ** Level 3 read latency histogram (micros): Count: 2025147 Average: 10.4701 StdDev: 137.58 Min: 1 Median: 1.9575 Max: 23276 Percentiles: P50: 1.96 P75: 2.97 P99: 11.81 P99.9: 861.55 P99.99: 1285.03 ------------------------------------------------------ [ 0, 1 ] 36049 1.780% 1.780% ( 1, 2 ] 1019816 50.358% 52.138% ########## ( 2, 3 ] 479219 23.663% 75.801% ##### ( 3, 4 ] 207244 10.234% 86.035% ## ( 4, 6 ] 210535 10.396% 96.431% ## ( 6, 10 ] 48379 2.389% 98.820% ( 10, 15 ] 10068 0.497% 99.317% ( 15, 22 ] 1141 0.056% 99.373% ( 22, 34 ] 114 0.006% 99.379% ( 34, 51 ] 112 0.006% 99.384% ( 51, 76 ] 188 0.009% 99.394% ( 76, 110 ] 927 0.046% 99.439% ( 110, 170 ] 3063 0.151% 99.591% ( 170, 250 ] 1444 0.071% 99.662% ( 250, 380 ] 1140 0.056% 99.718% ( 380, 580 ] 1646 0.081% 99.799% ( 580, 870 ] 2098 0.104% 99.903% ( 870, 1300 ] 1825 0.090% 99.993% ( 1300, 1900 ] 1243 0.061% 100.055% ( 1900, 2900 ] 974 0.048% 100.103% ( 2900, 4400 ] 1039 0.051% 100.154% ( 4400, 6600 ] 273 0.013% 100.167% ( 6600, 9900 ] 43 0.002% 100.170% ( 9900, 14000 ] 5 0.000% 100.170% ( 14000, 22000 ] 4 0.000% 100.170% ( 22000, 33000 ] 2 0.000% 100.170% ** Level 4 read latency histogram (micros): Count: 1232233 Average: 23.7302 StdDev: 195.88 Min: 0 Median: 1.9859 Max: 30441 Percentiles: P50: 1.99 P75: 3.20 P99: 438.16 P99.9: 2043.35 P99.99: 2939.42 ------------------------------------------------------ [ 0, 1 ] 22858 1.855% 1.855% ( 1, 2 ] 601743 48.834% 50.689% ########## ( 2, 3 ] 276026 22.400% 73.089% #### ( 3, 4 ] 119279 9.680% 82.769% ## ( 4, 6 ] 120955 9.816% 92.585% ## ( 6, 10 ] 29341 2.381% 94.966% ( 10, 15 ] 6252 0.507% 95.473% ( 15, 22 ] 665 0.054% 95.527% ( 22, 34 ] 65 0.005% 95.533% ( 34, 51 ] 85 0.007% 95.539% ( 51, 76 ] 142 0.012% 95.551% ( 76, 110 ] 6525 0.530% 96.081% ( 110, 170 ] 21904 1.778% 97.858% ( 170, 250 ] 8638 0.701% 98.559% ( 250, 380 ] 4139 0.336% 98.895% ( 380, 580 ] 4449 0.361% 99.256% ( 580, 870 ] 3477 0.282% 99.538% ( 870, 1300 ] 2722 0.221% 99.759% ( 1300, 1900 ] 1555 0.126% 99.885% ( 1900, 2900 ] 1261 0.102% 99.988% ( 2900, 4400 ] 1095 0.089% 100.077% ( 4400, 6600 ] 328 0.027% 100.103% ( 6600, 9900 ] 57 0.005% 100.108% ( 9900, 14000 ] 10 0.001% 100.109% ( 14000, 22000 ] 4 0.000% 100.109% ( 22000, 33000 ] 2 0.000% 100.109% ** Level 5 read latency histogram (micros): Count: 268196 Average: 350.7049 StdDev: 665.64 Min: 74 Median: 161.0967 Max: 61966 Percentiles: P50: 161.10 P75: 282.36 P99: 3662.20 P99.9: 6312.63 P99.99: 9195.52 ------------------------------------------------------ ( 51, 76 ] 12 0.004% 0.004% ( 76, 110 ] 34599 12.901% 12.905% ### ( 110, 170 ] 116822 43.558% 56.464% ######### ( 170, 250 ] 44720 16.674% 73.138% ### ( 250, 380 ] 20065 7.481% 80.619% # ( 380, 580 ] 19282 7.190% 87.809% # ( 580, 870 ] 12682 4.729% 92.538% # ( 870, 1300 ] 8222 3.066% 95.603% # ( 1300, 1900 ] 4284 1.597% 97.201% ( 1900, 2900 ] 3262 1.216% 98.417% ( 2900, 4400 ] 3078 1.148% 99.564% ( 4400, 6600 ] 1035 0.386% 99.950% ( 6600, 9900 ] 135 0.050% 100.001% ( 9900, 14000 ] 19 0.007% 100.008% ( 14000, 22000 ] 8 0.003% 100.011% ( 22000, 33000 ] 8 0.003% 100.014% ( 33000, 50000 ] 4 0.001% 100.015% ( 50000, 75000 ] 1 0.000% 100.016% ** DB Stats ** Uptime(secs): 35.3 total, 8.2 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 167.25 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:12.996 H:M:S, 36.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 120.28 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:4.615 H:M:S, 56.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 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 : 283.370 micros/op 14097 ops/sec 60.151 seconds 847996 operations; 13.7 MB/s (210999 of 210999 found) Microseconds per read: Count: 847996 Average: 283.3716 StdDev: 806.85 Min: 2 Median: 182.5799 Max: 150369 Percentiles: P50: 182.58 P75: 246.10 P99: 1964.98 P99.9: 11900.83 P99.99: 29446.19 ------------------------------------------------------ ( 1, 2 ] 3 0.000% 0.000% ( 2, 3 ] 23 0.003% 0.003% ( 3, 4 ] 58 0.007% 0.010% ( 4, 6 ] 89 0.010% 0.020% ( 6, 10 ] 327 0.039% 0.059% ( 10, 15 ] 3203 0.378% 0.437% ( 15, 22 ] 2952 0.348% 0.785% ( 22, 34 ] 5960 0.703% 1.488% ( 34, 51 ] 1596 0.188% 1.676% ( 51, 76 ] 244 0.029% 1.705% ( 76, 110 ] 16249 1.916% 3.621% ( 110, 170 ] 351309 41.428% 45.049% ######## ( 170, 250 ] 266998 31.486% 76.535% ###### ( 250, 380 ] 102653 12.105% 88.640% ## ( 380, 580 ] 48684 5.741% 94.381% # ( 580, 870 ] 22739 2.681% 97.063% # ( 870, 1300 ] 11284 1.331% 98.393% ( 1300, 1900 ] 4926 0.581% 98.974% ( 1900, 2900 ] 3371 0.398% 99.372% ( 2900, 4400 ] 2882 0.340% 99.712% ( 4400, 6600 ] 961 0.113% 99.825% ( 6600, 9900 ] 393 0.046% 99.871% ( 9900, 14000 ] 500 0.059% 99.930% ( 14000, 22000 ] 428 0.050% 99.981% ( 22000, 33000 ] 117 0.014% 99.994% ( 33000, 50000 ] 31 0.004% 99.998% ( 50000, 75000 ] 12 0.001% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 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 : 13992909 rocksdb.bloom.filter.full.positive COUNT : 984078 rocksdb.bloom.filter.full.true.positive COUNT : 847522 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 : 474 rocksdb.memtable.miss COUNT : 847522 rocksdb.l0.hit COUNT : 34100 rocksdb.l1.hit COUNT : 7674 rocksdb.l2andup.hit COUNT : 805748 rocksdb.compaction.key.drop.new COUNT : 265562 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 : 6407236 rocksdb.number.keys.read COUNT : 847996 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 6612267552 rocksdb.bytes.read COUNT : 847996000 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 : 1742 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 35453501 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 : 28860698164 rocksdb.compact.write.bytes COUNT : 28578726321 rocksdb.flush.write.bytes COUNT : 6605931322 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 : 19 rocksdb.number.superversion_acquires COUNT : 1272 rocksdb.number.superversion_releases COUNT : 1228 rocksdb.number.superversion_cleanups COUNT : 317 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 : 360 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 : 6552493056 rocksdb.memtable.garbage.bytes.at.flush COUNT : 2382848 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 : 32723036152 rocksdb.non.last.level.read.count COUNT : 7762583 rocksdb.block.checksum.compute.count COUNT : 7982760 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 : 181.220748 P95 : 645.590029 P99 : 1964.087808 P100 : 150366.000000 COUNT : 847996 SUM : 239625449 rocksdb.db.write.micros P50 : 1.543695 P95 : 4.352069 P99 : 9.335926 P100 : 933985.000000 COUNT : 6407236 SUM : 51568748 rocksdb.compaction.times.micros P50 : 1412500.000000 P95 : 4241666.666667 P99 : 6472500.000000 P100 : 40563498.000000 COUNT : 105 SUM : 215314296 rocksdb.compaction.times.cpu_micros P50 : 904074.074074 P95 : 2816666.666667 P99 : 6445000.000000 P100 : 15650893.000000 COUNT : 105 SUM : 126466479 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 : 833.750000 P95 : 123500.000000 P99 : 397100.000000 P100 : 426365.000000 COUNT : 91 SUM : 1680863 rocksdb.compaction.outfile.sync.micros P50 : 26452.380952 P95 : 242222.222222 P99 : 514187.500000 P100 : 721909.000000 COUNT : 335 SUM : 21911334 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 : 234.347826 P95 : 3842.187500 P99 : 5945.500000 P100 : 7577.000000 COUNT : 219 SUM : 200505 rocksdb.table.open.io.micros P50 : 8013.384321 P95 : 18737.724551 P99 : 23241.428571 P100 : 109872.000000 COUNT : 1742 SUM : 14317131 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.901542 P95 : 9.904471 P99 : 168.828254 P100 : 36643.000000 COUNT : 6987490 SUM : 96544941 rocksdb.read.block.get.micros P50 : 144.257383 P95 : 532.126498 P99 : 1803.414577 P100 : 62099.000000 COUNT : 993562 SUM : 208366582 rocksdb.write.raw.block.micros P50 : 0.529230 P95 : 1.143031 P99 : 3.453077 P100 : 35267.000000 COUNT : 8521961 SUM : 24696683 rocksdb.numfiles.in.singlecompaction P50 : 3.061404 P95 : 5.820000 P99 : 19.970000 P100 : 27.000000 COUNT : 129 SUM : 470 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.569418 P95 : 1179.026188 P99 : 2449.375911 P100 : 933801.000000 COUNT : 187367 SUM : 35473038 rocksdb.sst.read.micros P50 : 1.943813 P95 : 161.307120 P99 : 501.486735 P100 : 61966.000000 COUNT : 7762667 SUM : 284605793 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 : 847996 SUM : 847996000 rocksdb.bytes.per.write P50 : 1032.000000 P95 : 1032.000000 P99 : 1032.000000 P100 : 1032.000000 COUNT : 6407236 SUM : 6612267552 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 : 227419.354839 P95 : 979000.000000 P99 : 1155800.000000 P100 : 1192341.000000 COUNT : 91 SUM : 28743037 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 : 360 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