[2024-10-17 16:43:40.216390] Starting SPDK v25.01-pre git sha1 36b1ba373 / DPDK 24.03.0 initialization... [2024-10-17 16:43:40.216696] [ 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_pid1017442 ] Set seed to 1729176220209215 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-10-17 16:43:40.358186] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-10-17 16:43:40.464811] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-10-17 16:43:40.464857] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1017442' to capture a snapshot of events at runtime. [2024-10-17 16:43:40.464876] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-10-17 16:43:40.464894] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-10-17 16:43:40.464909] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1017442 for offline analysis/debug. [2024-10-17 16:43:40.466147] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Thu Oct 17 16:43:43 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/10/17-16:43:50 ... thread 0: (1000000,1000000) ops and (138066.2,138066.2) ops/second in (7.242901,7.242901) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/8 817.23 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 122.8 6.66 2.65 10 0.666 0 0 0.0 0.0 L1 3/3 166.50 MB 0.0 0.3 0.2 0.0 0.3 0.2 0.0 1.2 119.5 118.8 2.26 1.24 1 2.264 274K 1481 0.0 0.0 L2 2/0 102.46 MB 1.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 125.3 125.3 0.82 0.48 1 0.818 104K 0 0.0 0.0 L3 37/8 1.95 GB 1.5 2.8 1.9 0.9 2.7 1.8 0.0 1.4 108.5 103.9 26.44 14.28 11 2.404 1982K 7431 0.0 0.0 L4 162/21 11.63 GB 1.0 3.0 1.8 1.2 2.8 1.6 0.3 1.6 112.4 106.3 26.93 16.61 13 2.072 669K 537 0.0 0.0 L5 120/0 9.47 GB 0.1 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 334/40 24.12 GB 0.0 6.1 4.0 2.1 6.6 4.5 0.3 8.3 99.3 107.7 63.12 35.27 36 1.753 3030K 9449 0.0 0.0 Int 0/0 0.00 KB 0.0 6.1 4.0 2.1 6.6 4.5 0.3 8.3 99.3 107.7 63.12 35.27 36 1.753 3030K 9449 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.1 4.0 2.1 5.8 3.7 0.0 0.0 111.0 106.0 56.46 32.61 26 2.171 3030K 9449 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 122.8 6.66 2.65 10 0.666 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 7.3 total, 7.2 interval Flush(GB): cumulative 0.798, interval 0.798 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.64 GB write, 930.05 MB/s write, 6.12 GB read, 857.34 MB/s read, 63.1 seconds Interval compaction: 6.64 GB write, 938.58 MB/s write, 6.12 GB read, 865.20 MB/s read, 63.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: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 16, interval: 16 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 99265 Average: 74.2082 StdDev: 796.61 Min: 1 Median: 2.1083 Max: 59950 Percentiles: P50: 2.11 P75: 3.28 P99: 1559.79 P99.9: 5990.36 P99.99: 31536.75 ------------------------------------------------------ [ 0, 1 ] 2541 2.560% 2.560% # ( 1, 2 ] 44402 44.731% 47.291% ######### ( 2, 3 ] 24827 25.011% 72.301% ##### ( 3, 4 ] 9519 9.589% 81.891% ## ( 4, 6 ] 9797 9.870% 91.760% ## ( 6, 10 ] 2520 2.539% 94.299% # ( 10, 15 ] 595 0.599% 94.899% ( 15, 22 ] 74 0.075% 94.973% ( 22, 34 ] 7 0.007% 94.980% ( 34, 51 ] 12 0.012% 94.992% ( 51, 76 ] 11 0.011% 95.003% ( 76, 110 ] 5 0.005% 95.008% ( 110, 170 ] 30 0.030% 95.039% ( 170, 250 ] 177 0.178% 95.217% ( 250, 380 ] 567 0.571% 95.788% ( 380, 580 ] 1187 1.196% 96.984% ( 580, 870 ] 1284 1.294% 98.277% ( 870, 1300 ] 613 0.618% 98.895% ( 1300, 1900 ] 241 0.243% 99.138% ( 1900, 2900 ] 287 0.289% 99.427% ( 2900, 4400 ] 396 0.399% 99.826% ( 4400, 6600 ] 102 0.103% 99.928% ( 6600, 9900 ] 21 0.021% 99.950% ( 9900, 14000 ] 4 0.004% 99.954% ( 14000, 22000 ] 17 0.017% 99.971% ( 22000, 33000 ] 22 0.022% 99.993% ( 33000, 50000 ] 13 0.013% 100.006% ( 50000, 75000 ] 2 0.002% 100.008% ** Level 1 read latency histogram (micros): Count: 37614 Average: 20.0010 StdDev: 435.68 Min: 1 Median: 2.1675 Max: 57427 Percentiles: P50: 2.17 P75: 3.03 P99: 312.75 P99.9: 3602.26 P99.99: 23312.30 ------------------------------------------------------ [ 0, 1 ] 345 0.917% 0.917% ( 1, 2 ] 16598 44.127% 45.044% ######### ( 2, 3 ] 11127 29.582% 74.626% ###### ( 3, 4 ] 4043 10.749% 85.375% ## ( 4, 6 ] 3930 10.448% 95.823% ## ( 6, 10 ] 964 2.563% 98.386% # ( 10, 15 ] 152 0.404% 98.790% ( 15, 22 ] 10 0.027% 98.817% ( 22, 34 ] 4 0.011% 98.828% ( 34, 51 ] 20 0.053% 98.881% ( 51, 76 ] 5 0.013% 98.894% ( 76, 110 ] 1 0.003% 98.897% ( 110, 170 ] 4 0.011% 98.907% ( 170, 250 ] 17 0.045% 98.953% ( 250, 380 ] 37 0.098% 99.051% ( 380, 580 ] 107 0.284% 99.335% ( 580, 870 ] 81 0.215% 99.551% ( 870, 1300 ] 68 0.181% 99.731% ( 1300, 1900 ] 21 0.056% 99.787% ( 1900, 2900 ] 26 0.069% 99.856% ( 2900, 4400 ] 35 0.093% 99.949% ( 4400, 6600 ] 13 0.035% 99.984% ( 6600, 9900 ] 2 0.005% 99.989% ( 22000, 33000 ] 2 0.005% 99.995% ( 33000, 50000 ] 1 0.003% 99.997% ( 50000, 75000 ] 1 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 440725 Average: 15.4162 StdDev: 229.36 Min: 1 Median: 2.1980 Max: 36229 Percentiles: P50: 2.20 P75: 3.18 P99: 13.35 P99.9: 1738.93 P99.99: 2791.11 ------------------------------------------------------ [ 0, 1 ] 4885 1.108% 1.108% ( 1, 2 ] 190461 43.215% 44.324% ######### ( 2, 3 ] 126377 28.675% 72.999% ###### ( 3, 4 ] 49335 11.194% 84.193% ## ( 4, 6 ] 50957 11.562% 95.755% ## ( 6, 10 ] 12280 2.786% 98.541% # ( 10, 15 ] 3015 0.684% 99.225% ( 15, 22 ] 526 0.119% 99.344% ( 22, 34 ] 89 0.020% 99.365% ( 34, 51 ] 126 0.029% 99.393% ( 51, 76 ] 76 0.017% 99.411% ( 76, 110 ] 23 0.005% 99.416% ( 110, 170 ] 23 0.005% 99.421% ( 170, 250 ] 62 0.014% 99.435% ( 250, 380 ] 280 0.064% 99.499% ( 380, 580 ] 630 0.143% 99.641% ( 580, 870 ] 579 0.131% 99.773% ( 870, 1300 ] 373 0.085% 99.858% ( 1300, 1900 ] 256 0.058% 99.916% ( 1900, 2900 ] 368 0.083% 99.999% ( 2900, 4400 ] 410 0.093% 100.092% ( 4400, 6600 ] 146 0.033% 100.125% ( 6600, 9900 ] 40 0.009% 100.134% ( 9900, 14000 ] 10 0.002% 100.137% ( 14000, 22000 ] 8 0.002% 100.138% ( 22000, 33000 ] 4 0.001% 100.139% ( 33000, 50000 ] 1 0.000% 100.140% ** Level 3 read latency histogram (micros): Count: 666580 Average: 20.1866 StdDev: 407.81 Min: 1 Median: 2.2379 Max: 50960 Percentiles: P50: 2.24 P75: 3.20 P99: 14.31 P99.9: 1326.92 P99.99: 2408.83 ------------------------------------------------------ [ 0, 1 ] 7315 1.097% 1.097% ( 1, 2 ] 278787 41.823% 42.921% ######## ( 2, 3 ] 198371 29.760% 72.680% ###### ( 3, 4 ] 75514 11.329% 84.009% ## ( 4, 6 ] 78129 11.721% 95.730% ## ( 6, 10 ] 18784 2.818% 98.548% # ( 10, 15 ] 3494 0.524% 99.072% ( 15, 22 ] 443 0.066% 99.138% ( 22, 34 ] 115 0.017% 99.156% ( 34, 51 ] 171 0.026% 99.181% ( 51, 76 ] 141 0.021% 99.202% ( 76, 110 ] 47 0.007% 99.210% ( 110, 170 ] 85 0.013% 99.222% ( 170, 250 ] 203 0.030% 99.253% ( 250, 380 ] 646 0.097% 99.350% ( 380, 580 ] 1434 0.215% 99.565% ( 580, 870 ] 1448 0.217% 99.782% ( 870, 1300 ] 770 0.116% 99.898% ( 1300, 1900 ] 366 0.055% 99.952% ( 1900, 2900 ] 492 0.074% 100.026% ( 2900, 4400 ] 562 0.084% 100.111% ( 4400, 6600 ] 154 0.023% 100.134% ( 6600, 9900 ] 62 0.009% 100.143% ( 9900, 14000 ] 25 0.004% 100.147% ( 14000, 22000 ] 65 0.010% 100.156% ( 22000, 33000 ] 59 0.009% 100.165% ( 33000, 50000 ] 16 0.002% 100.168% ( 50000, 75000 ] 1 0.000% 100.168% ** Level 4 read latency histogram (micros): Count: 492211 Average: 39.5521 StdDev: 621.47 Min: 1 Median: 2.2772 Max: 66368 Percentiles: P50: 2.28 P75: 3.33 P99: 584.52 P99.9: 1635.91 P99.99: 2161.31 ------------------------------------------------------ [ 0, 1 ] 5935 1.206% 1.206% ( 1, 2 ] 200154 40.664% 41.870% ######## ( 2, 3 ] 144343 29.325% 71.195% ###### ( 3, 4 ] 56977 11.576% 82.771% ## ( 4, 6 ] 58581 11.902% 94.673% ## ( 6, 10 ] 13575 2.758% 97.431% # ( 10, 15 ] 2604 0.529% 97.960% ( 15, 22 ] 303 0.062% 98.021% ( 22, 34 ] 90 0.018% 98.040% ( 34, 51 ] 155 0.031% 98.071% ( 51, 76 ] 143 0.029% 98.100% ( 76, 110 ] 51 0.010% 98.111% ( 110, 170 ] 106 0.022% 98.132% ( 170, 250 ] 355 0.072% 98.204% ( 250, 380 ] 1208 0.245% 98.450% ( 380, 580 ] 2666 0.542% 98.991% ( 580, 870 ] 2754 0.560% 99.551% ( 870, 1300 ] 1384 0.281% 99.832% ( 1300, 1900 ] 598 0.121% 99.953% ( 1900, 2900 ] 688 0.140% 100.093% ( 2900, 4400 ] 872 0.177% 100.270% ( 4400, 6600 ] 249 0.051% 100.321% ( 6600, 9900 ] 75 0.015% 100.336% ( 9900, 14000 ] 35 0.007% 100.343% ( 14000, 22000 ] 72 0.015% 100.358% ( 22000, 33000 ] 71 0.014% 100.372% ( 33000, 50000 ] 35 0.007% 100.380% ( 50000, 75000 ] 7 0.001% 100.381% ** Level 5 read latency histogram (micros): Count: 7735 Average: 1257.8544 StdDev: 2629.05 Min: 97 Median: 684.1115 Max: 54026 Percentiles: P50: 684.11 P75: 1142.40 P99: 6516.85 P99.9: 43500.33 P99.99: 54026.00 ------------------------------------------------------ ( 76, 110 ] 3 0.039% 0.039% ( 110, 170 ] 50 0.646% 0.685% ( 170, 250 ] 266 3.439% 4.124% # ( 250, 380 ] 860 11.118% 15.242% ## ( 380, 580 ] 1945 25.145% 40.388% ##### ( 580, 870 ] 2071 26.774% 67.162% ##### ( 870, 1300 ] 957 12.372% 79.535% ## ( 1300, 1900 ] 353 4.564% 84.098% # ( 1900, 2900 ] 424 5.482% 89.580% # ( 2900, 4400 ] 567 7.330% 96.910% # ( 4400, 6600 ] 168 2.172% 99.082% ( 6600, 9900 ] 27 0.349% 99.431% ( 9900, 14000 ] 4 0.052% 99.483% ( 14000, 22000 ] 7 0.090% 99.573% ( 22000, 33000 ] 16 0.207% 99.780% ( 33000, 50000 ] 15 0.194% 99.974% ( 50000, 75000 ] 2 0.026% 100.000% ** DB Stats ** Uptime(secs): 7.3 total, 7.2 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 134.61 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.246 H:M:S, 30.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 135.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:2.246 H:M:S, 31.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/10/17-16:43:56 ... thread 0: (1000000,2000000) ops and (176591.8,154970.6) ops/second in (5.662776,12.905677) 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 14/12 1.53 GB 68.7 0.7 0.0 0.7 2.5 1.8 0.0 1.4 35.7 133.0 19.35 8.94 26 0.744 702K 4483 0.0 0.0 L1 3/0 173.79 MB 17.4 0.7 0.5 0.2 0.7 0.5 0.0 1.4 71.1 70.5 10.57 3.96 2 5.285 763K 5999 0.0 0.0 L2 2/1 160.88 MB 0.8 0.1 0.1 0.0 0.1 0.1 0.3 1.0 125.3 125.3 0.82 0.48 1 0.818 104K 0 0.0 0.0 L3 22/4 1.08 GB 0.9 3.0 2.1 1.0 2.9 2.0 0.1 1.4 111.4 107.1 27.93 15.49 13 2.149 2230K 9081 0.0 0.0 L4 154/0 9.65 GB 1.0 8.6 2.8 5.7 7.5 1.7 0.4 2.7 131.0 114.1 66.91 41.06 32 2.091 1758K 537 0.0 0.0 L5 151/0 11.63 GB 0.1 0.0 0.0 0.0 0.0 0.0 2.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 346/17 24.21 GB 0.0 13.1 5.5 7.6 13.7 6.1 3.0 7.4 106.9 111.9 125.58 69.93 74 1.697 5557K 20K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.1 5.5 7.6 13.7 6.1 3.0 7.4 106.9 111.9 125.58 69.93 74 1.697 5557K 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 13.1 5.5 7.6 11.9 4.3 0.0 0.0 118.5 107.4 113.29 64.17 50 2.266 5557K 20K 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 153.4 12.29 5.76 24 0.512 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.0 total, 12.9 interval Flush(GB): cumulative 1.842, interval 1.842 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 13.72 GB write, 1082.86 MB/s write, 13.11 GB read, 1034.42 MB/s read, 125.6 seconds Interval compaction: 13.72 GB write, 1088.44 MB/s write, 13.11 GB read, 1039.75 MB/s read, 125.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 31, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 31, interval: 31 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 396807 Average: 43.8048 StdDev: 469.36 Min: 1 Median: 1.9704 Max: 59950 Percentiles: P50: 1.97 P75: 2.97 P99: 849.51 P99.9: 3874.98 P99.99: 5312.77 ------------------------------------------------------ [ 0, 1 ] 13844 3.489% 3.489% # ( 1, 2 ] 190189 47.930% 51.419% ########## ( 2, 3 ] 96775 24.388% 75.807% ##### ( 3, 4 ] 34811 8.773% 84.580% ## ( 4, 6 ] 32140 8.100% 92.680% ## ( 6, 10 ] 8730 2.200% 94.880% ( 10, 15 ] 1728 0.435% 95.315% ( 15, 22 ] 181 0.046% 95.361% ( 22, 34 ] 26 0.007% 95.367% ( 34, 51 ] 50 0.013% 95.380% ( 51, 76 ] 38 0.010% 95.389% ( 76, 110 ] 22 0.006% 95.395% ( 110, 170 ] 603 0.152% 95.547% ( 170, 250 ] 2793 0.704% 96.251% ( 250, 380 ] 3451 0.870% 97.121% ( 380, 580 ] 4092 1.031% 98.152% ( 580, 870 ] 3624 0.913% 99.065% ( 870, 1300 ] 1605 0.404% 99.470% ( 1300, 1900 ] 560 0.141% 99.611% ( 1900, 2900 ] 638 0.161% 99.771% ( 2900, 4400 ] 788 0.199% 99.970% ( 4400, 6600 ] 196 0.049% 100.019% ( 6600, 9900 ] 30 0.008% 100.027% ( 9900, 14000 ] 5 0.001% 100.028% ( 14000, 22000 ] 20 0.005% 100.033% ( 22000, 33000 ] 28 0.007% 100.040% ( 33000, 50000 ] 16 0.004% 100.044% ( 50000, 75000 ] 2 0.001% 100.045% ** Level 1 read latency histogram (micros): Count: 134633 Average: 12.0520 StdDev: 257.78 Min: 1 Median: 2.1560 Max: 57427 Percentiles: P50: 2.16 P75: 2.99 P99: 49.72 P99.9: 1265.97 P99.99: 3886.37 ------------------------------------------------------ [ 0, 1 ] 1462 1.086% 1.086% ( 1, 2 ] 59579 44.253% 45.339% ######### ( 2, 3 ] 40237 29.886% 75.225% ###### ( 3, 4 ] 13786 10.240% 85.465% ## ( 4, 6 ] 13548 10.063% 95.528% ## ( 6, 10 ] 3872 2.876% 98.404% # ( 10, 15 ] 639 0.475% 98.878% ( 15, 22 ] 80 0.059% 98.938% ( 22, 34 ] 18 0.013% 98.951% ( 34, 51 ] 71 0.053% 99.004% ( 51, 76 ] 14 0.010% 99.014% ( 76, 110 ] 8 0.006% 99.020% ( 110, 170 ] 47 0.035% 99.055% ( 170, 250 ] 207 0.154% 99.209% ( 250, 380 ] 268 0.199% 99.408% ( 380, 580 ] 300 0.223% 99.631% ( 580, 870 ] 227 0.169% 99.799% ( 870, 1300 ] 147 0.109% 99.909% ( 1300, 1900 ] 40 0.030% 99.938% ( 1900, 2900 ] 36 0.027% 99.965% ( 2900, 4400 ] 51 0.038% 100.003% ( 4400, 6600 ] 15 0.011% 100.014% ( 6600, 9900 ] 2 0.001% 100.016% ( 14000, 22000 ] 2 0.001% 100.017% ( 22000, 33000 ] 3 0.002% 100.019% ( 33000, 50000 ] 1 0.001% 100.020% ( 50000, 75000 ] 1 0.001% 100.021% ** Level 2 read latency histogram (micros): Count: 466965 Average: 15.2649 StdDev: 226.32 Min: 1 Median: 2.1877 Max: 36229 Percentiles: P50: 2.19 P75: 3.15 P99: 13.60 P99.9: 1743.85 P99.99: 2822.06 ------------------------------------------------------ [ 0, 1 ] 5235 1.121% 1.121% ( 1, 2 ] 203111 43.496% 44.617% ######### ( 2, 3 ] 133887 28.672% 73.289% ###### ( 3, 4 ] 51748 11.082% 84.371% ## ( 4, 6 ] 53082 11.367% 95.738% ## ( 6, 10 ] 12972 2.778% 98.516% # ( 10, 15 ] 3140 0.672% 99.188% ( 15, 22 ] 539 0.115% 99.304% ( 22, 34 ] 90 0.019% 99.323% ( 34, 51 ] 127 0.027% 99.350% ( 51, 76 ] 76 0.016% 99.367% ( 76, 110 ] 23 0.005% 99.371% ( 110, 170 ] 27 0.006% 99.377% ( 170, 250 ] 129 0.028% 99.405% ( 250, 380 ] 385 0.082% 99.487% ( 380, 580 ] 695 0.149% 99.636% ( 580, 870 ] 645 0.138% 99.774% ( 870, 1300 ] 391 0.084% 99.858% ( 1300, 1900 ] 265 0.057% 99.915% ( 1900, 2900 ] 381 0.082% 99.996% ( 2900, 4400 ] 420 0.090% 100.086% ( 4400, 6600 ] 149 0.032% 100.118% ( 6600, 9900 ] 40 0.009% 100.127% ( 9900, 14000 ] 10 0.002% 100.129% ( 14000, 22000 ] 9 0.002% 100.131% ( 22000, 33000 ] 4 0.001% 100.132% ( 33000, 50000 ] 1 0.000% 100.132% ** Level 3 read latency histogram (micros): Count: 917120 Average: 19.1695 StdDev: 366.26 Min: 1 Median: 2.2270 Max: 50960 Percentiles: P50: 2.23 P75: 3.19 P99: 39.85 P99.9: 1438.15 P99.99: 2551.14 ------------------------------------------------------ [ 0, 1 ] 10512 1.146% 1.146% ( 1, 2 ] 386483 42.141% 43.287% ######## ( 2, 3 ] 271183 29.569% 72.856% ###### ( 3, 4 ] 102847 11.214% 84.070% ## ( 4, 6 ] 105432 11.496% 95.566% ## ( 6, 10 ] 25914 2.826% 98.392% # ( 10, 15 ] 4755 0.518% 98.910% ( 15, 22 ] 591 0.064% 98.975% ( 22, 34 ] 151 0.016% 98.991% ( 34, 51 ] 235 0.026% 99.017% ( 51, 76 ] 191 0.021% 99.038% ( 76, 110 ] 65 0.007% 99.045% ( 110, 170 ] 204 0.022% 99.067% ( 170, 250 ] 650 0.071% 99.138% ( 250, 380 ] 1180 0.129% 99.267% ( 380, 580 ] 2186 0.238% 99.505% ( 580, 870 ] 2317 0.253% 99.758% ( 870, 1300 ] 1186 0.129% 99.887% ( 1300, 1900 ] 525 0.057% 99.944% ( 1900, 2900 ] 647 0.071% 100.015% ( 2900, 4400 ] 729 0.079% 100.094% ( 4400, 6600 ] 194 0.021% 100.115% ( 6600, 9900 ] 65 0.007% 100.122% ( 9900, 14000 ] 30 0.003% 100.126% ( 14000, 22000 ] 67 0.007% 100.133% ( 22000, 33000 ] 61 0.007% 100.140% ( 33000, 50000 ] 19 0.002% 100.142% ( 50000, 75000 ] 1 0.000% 100.142% ** Level 4 read latency histogram (micros): Count: 1492526 Average: 26.1372 StdDev: 405.14 Min: 1 Median: 2.2617 Max: 66368 Percentiles: P50: 2.26 P75: 3.29 P99: 352.71 P99.9: 876.13 P99.99: 1070.02 ------------------------------------------------------ [ 0, 1 ] 15929 1.067% 1.067% ( 1, 2 ] 616180 41.284% 42.352% ######## ( 2, 3 ] 436186 29.225% 71.576% ###### ( 3, 4 ] 175210 11.739% 83.315% ## ( 4, 6 ] 174092 11.664% 94.980% ## ( 6, 10 ] 41389 2.773% 97.753% # ( 10, 15 ] 8759 0.587% 98.340% ( 15, 22 ] 1066 0.071% 98.411% ( 22, 34 ] 197 0.013% 98.424% ( 34, 51 ] 406 0.027% 98.451% ( 51, 76 ] 395 0.026% 98.478% ( 76, 110 ] 161 0.011% 98.489% ( 110, 170 ] 880 0.059% 98.548% ( 170, 250 ] 3245 0.217% 98.765% ( 250, 380 ] 4437 0.297% 99.062% ( 380, 580 ] 6326 0.424% 99.486% ( 580, 870 ] 6133 0.411% 99.897% ( 870, 1300 ] 2979 0.200% 100.097% ( 1300, 1900 ] 1304 0.087% 100.184% ( 1900, 2900 ] 1558 0.104% 100.289% ( 2900, 4400 ] 1820 0.122% 100.410% ( 4400, 6600 ] 490 0.033% 100.443% ( 6600, 9900 ] 124 0.008% 100.452% ( 9900, 14000 ] 42 0.003% 100.454% ( 14000, 22000 ] 91 0.006% 100.460% ( 22000, 33000 ] 88 0.006% 100.466% ( 33000, 50000 ] 38 0.003% 100.469% ( 50000, 75000 ] 7 0.000% 100.469% ** Level 5 read latency histogram (micros): Count: 18315 Average: 918.2226 StdDev: 1934.32 Min: 97 Median: 526.7919 Max: 54026 Percentiles: P50: 526.79 P75: 842.27 P99: 5761.42 P99.9: 34591.39 P99.99: 52106.25 ------------------------------------------------------ ( 76, 110 ] 15 0.082% 0.082% ( 110, 170 ] 550 3.003% 3.085% # ( 170, 250 ] 2496 13.628% 16.713% ### ( 250, 380 ] 3088 16.860% 33.574% ### ( 380, 580 ] 4099 22.381% 55.954% #### ( 580, 870 ] 3857 21.059% 77.013% #### ( 870, 1300 ] 1719 9.386% 86.399% ## ( 1300, 1900 ] 595 3.249% 89.648% # ( 1900, 2900 ] 673 3.675% 93.322% # ( 2900, 4400 ] 887 4.843% 98.165% # ( 4400, 6600 ] 247 1.349% 99.514% ( 6600, 9900 ] 37 0.202% 99.716% ( 9900, 14000 ] 5 0.027% 99.743% ( 14000, 22000 ] 10 0.055% 99.798% ( 22000, 33000 ] 17 0.093% 99.891% ( 33000, 50000 ] 18 0.098% 99.989% ( 50000, 75000 ] 2 0.011% 100.000% ** DB Stats ** Uptime(secs): 13.0 total, 5.7 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 151.72 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.633 H:M:S, 28.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 173.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:1.387 H:M:S, 24.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/10/17-16:44:00 ... thread 0: (1000000,3000000) ops and (266738.2,180129.6) ops/second in (3.748994,16.654671) 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 14/4 2.44 GB 225.2 2.0 0.0 2.0 4.8 2.8 0.0 1.7 68.3 161.2 30.36 17.15 46 0.660 2107K 11K 0.0 0.0 L1 3/0 173.79 MB 17.4 0.7 0.5 0.2 0.7 0.5 0.0 1.4 71.1 70.5 10.57 3.96 2 5.285 763K 5999 0.0 0.0 L2 1/0 79.69 MB 0.8 0.1 0.1 0.0 0.1 0.1 0.3 1.0 125.3 125.3 0.82 0.48 1 0.818 104K 0 0.0 0.0 L3 18/0 918.73 MB 0.9 3.3 2.2 1.1 3.2 2.0 0.1 1.5 114.8 110.5 29.43 16.75 14 2.102 2500K 14K 0.0 0.0 L4 154/0 9.65 GB 1.0 8.9 2.9 6.0 7.8 1.8 0.5 2.7 132.9 116.4 68.62 42.65 33 2.079 2117K 6697 0.0 0.0 L5 155/0 11.87 GB 0.1 0.0 0.0 0.0 0.0 0.0 2.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 345/4 25.12 GB 0.0 15.1 5.7 9.3 16.6 7.2 3.3 6.0 110.3 121.5 139.79 80.98 96 1.456 7593K 38K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.1 5.7 9.3 16.6 7.2 3.3 6.0 110.3 121.5 139.79 80.98 96 1.456 7593K 38K 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.1 5.7 9.3 13.8 4.5 0.0 0.0 123.9 113.6 124.52 72.57 57 2.185 7593K 38K 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 185.3 15.27 8.41 39 0.392 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): 16.7 total, 16.7 interval Flush(GB): cumulative 2.764, interval 2.764 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 16.58 GB write, 1015.27 MB/s write, 15.06 GB read, 922.36 MB/s read, 139.8 seconds Interval compaction: 16.58 GB write, 1019.32 MB/s write, 15.06 GB read, 926.04 MB/s read, 139.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: 31, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 31, interval: 31 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 743983 Average: 26.8425 StdDev: 344.17 Min: 1 Median: 1.7461 Max: 59950 Percentiles: P50: 1.75 P75: 2.58 P99: 570.83 P99.9: 2853.00 P99.99: 4117.52 ------------------------------------------------------ [ 0, 1 ] 66775 8.975% 8.975% ## ( 1, 2 ] 409078 54.985% 63.960% ########### ( 2, 3 ] 140750 18.918% 82.879% #### ( 3, 4 ] 46988 6.316% 89.194% # ( 4, 6 ] 40100 5.390% 94.584% # ( 6, 10 ] 11401 1.532% 96.117% ( 10, 15 ] 2014 0.271% 96.387% ( 15, 22 ] 216 0.029% 96.416% ( 22, 34 ] 42 0.006% 96.422% ( 34, 51 ] 50 0.007% 96.429% ( 51, 76 ] 41 0.006% 96.434% ( 76, 110 ] 125 0.017% 96.451% ( 110, 170 ] 2798 0.376% 96.827% ( 170, 250 ] 7084 0.952% 97.779% ( 250, 380 ] 4780 0.642% 98.422% ( 380, 580 ] 4510 0.606% 99.028% ( 580, 870 ] 3704 0.498% 99.526% ( 870, 1300 ] 1616 0.217% 99.743% ( 1300, 1900 ] 561 0.075% 99.819% ( 1900, 2900 ] 638 0.086% 99.904% ( 2900, 4400 ] 788 0.106% 100.010% ( 4400, 6600 ] 196 0.026% 100.037% ( 6600, 9900 ] 30 0.004% 100.041% ( 9900, 14000 ] 5 0.001% 100.041% ( 14000, 22000 ] 20 0.003% 100.044% ( 22000, 33000 ] 28 0.004% 100.048% ( 33000, 50000 ] 16 0.002% 100.050% ( 50000, 75000 ] 2 0.000% 100.050% ** Level 1 read latency histogram (micros): Count: 137922 Average: 13.1602 StdDev: 255.36 Min: 1 Median: 2.1541 Max: 57427 Percentiles: P50: 2.15 P75: 3.00 P99: 232.31 P99.9: 1259.55 P99.99: 3876.70 ------------------------------------------------------ [ 0, 1 ] 1597 1.158% 1.158% ( 1, 2 ] 61082 44.287% 45.445% ######### ( 2, 3 ] 40777 29.565% 75.011% ###### ( 3, 4 ] 13893 10.073% 85.084% ## ( 4, 6 ] 13650 9.897% 94.980% ## ( 6, 10 ] 3911 2.836% 97.816% # ( 10, 15 ] 646 0.468% 98.285% ( 15, 22 ] 81 0.059% 98.343% ( 22, 34 ] 18 0.013% 98.356% ( 34, 51 ] 71 0.051% 98.408% ( 51, 76 ] 14 0.010% 98.418% ( 76, 110 ] 18 0.013% 98.431% ( 110, 170 ] 291 0.211% 98.642% ( 170, 250 ] 634 0.460% 99.102% ( 250, 380 ] 392 0.284% 99.386% ( 380, 580 ] 340 0.247% 99.632% ( 580, 870 ] 235 0.170% 99.803% ( 870, 1300 ] 148 0.107% 99.910% ( 1300, 1900 ] 40 0.029% 99.939% ( 1900, 2900 ] 37 0.027% 99.966% ( 2900, 4400 ] 51 0.037% 100.003% ( 4400, 6600 ] 15 0.011% 100.014% ( 6600, 9900 ] 2 0.001% 100.015% ( 14000, 22000 ] 2 0.001% 100.017% ( 22000, 33000 ] 3 0.002% 100.019% ( 33000, 50000 ] 1 0.001% 100.020% ( 50000, 75000 ] 1 0.001% 100.020% ** Level 2 read latency histogram (micros): Count: 466965 Average: 15.2649 StdDev: 226.32 Min: 1 Median: 2.1877 Max: 36229 Percentiles: P50: 2.19 P75: 3.15 P99: 13.60 P99.9: 1743.85 P99.99: 2822.06 ------------------------------------------------------ [ 0, 1 ] 5235 1.121% 1.121% ( 1, 2 ] 203111 43.496% 44.617% ######### ( 2, 3 ] 133887 28.672% 73.289% ###### ( 3, 4 ] 51748 11.082% 84.371% ## ( 4, 6 ] 53082 11.367% 95.738% ## ( 6, 10 ] 12972 2.778% 98.516% # ( 10, 15 ] 3140 0.672% 99.188% ( 15, 22 ] 539 0.115% 99.304% ( 22, 34 ] 90 0.019% 99.323% ( 34, 51 ] 127 0.027% 99.350% ( 51, 76 ] 76 0.016% 99.367% ( 76, 110 ] 23 0.005% 99.371% ( 110, 170 ] 27 0.006% 99.377% ( 170, 250 ] 129 0.028% 99.405% ( 250, 380 ] 385 0.082% 99.487% ( 380, 580 ] 695 0.149% 99.636% ( 580, 870 ] 645 0.138% 99.774% ( 870, 1300 ] 391 0.084% 99.858% ( 1300, 1900 ] 265 0.057% 99.915% ( 1900, 2900 ] 381 0.082% 99.996% ( 2900, 4400 ] 420 0.090% 100.086% ( 4400, 6600 ] 149 0.032% 100.118% ( 6600, 9900 ] 40 0.009% 100.127% ( 9900, 14000 ] 10 0.002% 100.129% ( 14000, 22000 ] 9 0.002% 100.131% ( 22000, 33000 ] 4 0.001% 100.132% ( 33000, 50000 ] 1 0.000% 100.132% ** Level 3 read latency histogram (micros): Count: 992396 Average: 18.7183 StdDev: 352.38 Min: 1 Median: 2.1775 Max: 50960 Percentiles: P50: 2.18 P75: 3.11 P99: 209.75 P99.9: 1340.69 P99.99: 2524.05 ------------------------------------------------------ [ 0, 1 ] 13606 1.371% 1.371% ( 1, 2 ] 431680 43.499% 44.870% ######### ( 2, 3 ] 286893 28.909% 73.779% ###### ( 3, 4 ] 106474 10.729% 84.508% ## ( 4, 6 ] 107845 10.867% 95.375% ## ( 6, 10 ] 27243 2.745% 98.120% # ( 10, 15 ] 4861 0.490% 98.610% ( 15, 22 ] 612 0.062% 98.672% ( 22, 34 ] 154 0.016% 98.687% ( 34, 51 ] 237 0.024% 98.711% ( 51, 76 ] 191 0.019% 98.730% ( 76, 110 ] 124 0.012% 98.743% ( 110, 170 ] 1278 0.129% 98.872% ( 170, 250 ] 2564 0.258% 99.130% ( 250, 380 ] 1718 0.173% 99.303% ( 380, 580 ] 2347 0.236% 99.540% ( 580, 870 ] 2352 0.237% 99.777% ( 870, 1300 ] 1189 0.120% 99.896% ( 1300, 1900 ] 525 0.053% 99.949% ( 1900, 2900 ] 647 0.065% 100.015% ( 2900, 4400 ] 729 0.073% 100.088% ( 4400, 6600 ] 194 0.020% 100.108% ( 6600, 9900 ] 65 0.007% 100.114% ( 9900, 14000 ] 30 0.003% 100.117% ( 14000, 22000 ] 67 0.007% 100.124% ( 22000, 33000 ] 61 0.006% 100.130% ( 33000, 50000 ] 19 0.002% 100.132% ( 50000, 75000 ] 1 0.000% 100.132% ** Level 4 read latency histogram (micros): Count: 1555202 Average: 28.9059 StdDev: 397.84 Min: 1 Median: 2.2799 Max: 66368 Percentiles: P50: 2.28 P75: 3.38 P99: 378.70 P99.9: 869.12 P99.99: 1067.93 ------------------------------------------------------ [ 0, 1 ] 16524 1.062% 1.062% ( 1, 2 ] 636364 40.918% 41.981% ######## ( 2, 3 ] 445553 28.649% 70.630% ###### ( 3, 4 ] 177551 11.417% 82.047% ## ( 4, 6 ] 175942 11.313% 93.360% ## ( 6, 10 ] 42113 2.708% 96.068% # ( 10, 15 ] 8842 0.569% 96.636% ( 15, 22 ] 1082 0.070% 96.706% ( 22, 34 ] 205 0.013% 96.719% ( 34, 51 ] 407 0.026% 96.745% ( 51, 76 ] 395 0.025% 96.771% ( 76, 110 ] 599 0.039% 96.809% ( 110, 170 ] 8992 0.578% 97.387% ( 170, 250 ] 17181 1.105% 98.492% ( 250, 380 ] 7980 0.513% 99.005% ( 380, 580 ] 7605 0.489% 99.494% ( 580, 870 ] 6331 0.407% 99.901% ( 870, 1300 ] 2999 0.193% 100.094% ( 1300, 1900 ] 1305 0.084% 100.178% ( 1900, 2900 ] 1560 0.100% 100.278% ( 2900, 4400 ] 1820 0.117% 100.395% ( 4400, 6600 ] 490 0.032% 100.427% ( 6600, 9900 ] 124 0.008% 100.435% ( 9900, 14000 ] 42 0.003% 100.437% ( 14000, 22000 ] 91 0.006% 100.443% ( 22000, 33000 ] 88 0.006% 100.449% ( 33000, 50000 ] 38 0.002% 100.451% ( 50000, 75000 ] 7 0.000% 100.452% ** Level 5 read latency histogram (micros): Count: 38222 Average: 550.3255 StdDev: 1386.17 Min: 94 Median: 248.4910 Max: 54026 Percentiles: P50: 248.49 P75: 526.37 P99: 4321.84 P99.9: 21022.40 P99.99: 48279.03 ------------------------------------------------------ ( 76, 110 ] 337 0.882% 0.882% ( 110, 170 ] 6446 16.865% 17.746% ### ( 170, 250 ] 12565 32.874% 50.620% ####### ( 250, 380 ] 5665 14.821% 65.441% ### ( 380, 580 ] 4992 13.061% 78.502% ### ( 580, 870 ] 3992 10.444% 88.946% ## ( 870, 1300 ] 1731 4.529% 93.475% # ( 1300, 1900 ] 597 1.562% 95.037% ( 1900, 2900 ] 674 1.763% 96.800% ( 2900, 4400 ] 887 2.321% 99.121% ( 4400, 6600 ] 247 0.646% 99.767% ( 6600, 9900 ] 37 0.097% 99.864% ( 9900, 14000 ] 5 0.013% 99.877% ( 14000, 22000 ] 10 0.026% 99.903% ( 22000, 33000 ] 17 0.044% 99.948% ( 33000, 50000 ] 18 0.047% 99.995% ( 50000, 75000 ] 2 0.005% 100.000% ** DB Stats ** Uptime(secs): 16.7 total, 3.7 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 176.56 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.633 H:M:S, 21.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 262.53 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: 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: 20000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 19378.7 MB (estimated) FileSize: 19378.7 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 : 484.098 micros/op 8246 ops/sec 20.250 seconds 166996 operations; 8.0 MB/s (41999 of 41999 found) Microseconds per read: Count: 166996 Average: 484.1120 StdDev: 1521.77 Min: 2 Median: 244.5235 Max: 115836 Percentiles: P50: 244.52 P75: 423.58 P99: 4159.78 P99.9: 24487.34 P99.99: 55156.87 ------------------------------------------------------ ( 1, 2 ] 2 0.001% 0.001% ( 2, 3 ] 36 0.022% 0.023% ( 3, 4 ] 61 0.037% 0.059% ( 4, 6 ] 151 0.090% 0.150% ( 6, 10 ] 297 0.178% 0.328% ( 10, 15 ] 644 0.386% 0.713% ( 15, 22 ] 2505 1.500% 2.213% ( 22, 34 ] 3481 2.084% 4.298% ( 34, 51 ] 2189 1.311% 5.609% ( 51, 76 ] 369 0.221% 5.829% ( 76, 110 ] 86 0.051% 5.881% ( 110, 170 ] 12142 7.271% 13.152% # ( 170, 250 ] 66057 39.556% 52.708% ######## ( 250, 380 ] 32772 19.624% 72.332% #### ( 380, 580 ] 20444 12.242% 84.574% ## ( 580, 870 ] 12753 7.637% 92.211% ## ( 870, 1300 ] 5763 3.451% 95.662% # ( 1300, 1900 ] 2106 1.261% 96.923% ( 1900, 2900 ] 1659 0.993% 97.917% ( 2900, 4400 ] 2154 1.290% 99.207% ( 4400, 6600 ] 662 0.396% 99.603% ( 6600, 9900 ] 239 0.143% 99.746% ( 9900, 14000 ] 83 0.050% 99.796% ( 14000, 22000 ] 148 0.089% 99.884% ( 22000, 33000 ] 115 0.069% 99.953% ( 33000, 50000 ] 58 0.035% 99.988% ( 50000, 75000 ] 16 0.010% 99.998% ( 75000, 110000 ] 3 0.002% 99.999% ( 110000, 170000 ] 1 0.001% 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 : 2213090 rocksdb.bloom.filter.full.positive COUNT : 187438 rocksdb.bloom.filter.full.true.positive COUNT : 166140 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 : 856 rocksdb.memtable.miss COUNT : 166140 rocksdb.l0.hit COUNT : 16562 rocksdb.l1.hit COUNT : 1371 rocksdb.l2andup.hit COUNT : 148207 rocksdb.compaction.key.drop.new COUNT : 1301661 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 : 3985923 rocksdb.number.keys.read COUNT : 166996 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 4113472536 rocksdb.bytes.read COUNT : 166996000 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 : 570 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 3633317 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 : 17438528691 rocksdb.compact.write.bytes COUNT : 16097123186 rocksdb.flush.write.bytes COUNT : 4022780837 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 : 28 rocksdb.number.superversion_acquires COUNT : 789 rocksdb.number.superversion_releases COUNT : 757 rocksdb.number.superversion_cleanups COUNT : 194 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 : 217 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 : 3997002752 rocksdb.memtable.garbage.bytes.at.flush COUNT : 7670784 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 : 17784636529 rocksdb.non.last.level.read.count COUNT : 4270139 rocksdb.block.checksum.compute.count COUNT : 4415052 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 : 243.709845 P95 : 1216.663651 P99 : 4159.553903 P100 : 115834.000000 COUNT : 166996 SUM : 80676310 rocksdb.db.write.micros P50 : 1.603045 P95 : 5.080080 P99 : 7.030387 P100 : 811456.000000 COUNT : 3985923 SUM : 14812095 rocksdb.compaction.times.micros P50 : 2196875.000000 P95 : 3890000.000000 P99 : 7787000.000000 P100 : 8306391.000000 COUNT : 61 SUM : 128451857 rocksdb.compaction.times.cpu_micros P50 : 1330000.000000 P95 : 1879000.000000 P99 : 2595000.000000 P100 : 2724065.000000 COUNT : 61 SUM : 76393792 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 : 1102.916667 P95 : 9075.000000 P99 : 17600.000000 P100 : 21680.000000 COUNT : 55 SUM : 134071 rocksdb.compaction.outfile.sync.micros P50 : 3106.521739 P95 : 8345.526316 P99 : 9867.000000 P100 : 45749.000000 COUNT : 219 SUM : 784001 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 : 233.076923 P95 : 2378.571429 P99 : 5874.000000 P100 : 25416.000000 COUNT : 133 SUM : 89252 rocksdb.table.open.io.micros P50 : 5265.168539 P95 : 18842.105263 P99 : 22660.000000 P100 : 55470.000000 COUNT : 570 SUM : 3691133 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 : 4.360101 P95 : 9.471250 P99 : 20.139781 P100 : 59957.000000 COUNT : 4224740 SUM : 66900522 rocksdb.read.block.get.micros P50 : 213.390250 P95 : 1074.940841 P99 : 3833.773311 P100 : 66374.000000 COUNT : 189787 SUM : 73114172 rocksdb.write.raw.block.micros P50 : 0.534514 P95 : 1.348976 P99 : 3.965455 P100 : 94705.000000 COUNT : 4879466 SUM : 19417465 rocksdb.numfiles.in.singlecompaction P50 : 3.205128 P95 : 5.171429 P99 : 6.880000 P100 : 7.000000 COUNT : 78 SUM : 276 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 : 170000.000000 P95 : 802000.000000 P99 : 811285.000000 P100 : 811285.000000 COUNT : 12 SUM : 3633317 rocksdb.sst.read.micros P50 : 2.061766 P95 : 13.412160 P99 : 552.117954 P100 : 66368.000000 COUNT : 4270258 SUM : 126055125 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 : 166996 SUM : 166996000 rocksdb.bytes.per.write P50 : 1032.000000 P95 : 1032.000000 P99 : 1032.000000 P100 : 1032.000000 COUNT : 3985923 SUM : 4113472536 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 : 230571.428571 P95 : 902500.000000 P99 : 1205745.000000 P100 : 1205745.000000 COUNT : 55 SUM : 18250214 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 : 221 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