[2024-12-15 16:00:44.843743] Starting SPDK v24.09.1-pre git sha1 b18e1bd62 / DPDK 23.11.0 initialization... [2024-12-15 16:00:44.844006] [ 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_pid1472063 ] Set seed to 1734274844836956 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-15 16:00:44.954449] app.c: 917:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-15 16:00:44.995986] app.c: 610:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-15 16:00:44.996035] app.c: 611:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1472063' to capture a snapshot of events at runtime. [2024-12-15 16:00:44.996046] app.c: 616:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-15 16:00:44.996056] app.c: 617:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-15 16:00:44.996064] app.c: 618:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1472063 for offline analysis/debug. [2024-12-15 16:00:44.996151] reactor.c: 990:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sun Dec 15 16:00:49 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/15-16:00:56 ... thread 0: (1000000,1000000) ops and (132417.7,132417.7) ops/second in (7.551863,7.551863) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/11 2.10 GB 44.0 0.4 0.0 0.4 1.2 0.9 0.0 1.4 36.8 122.5 10.28 4.31 11 0.934 383K 534 0.0 0.0 L1 8/8 898.60 MB 0.0 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 L2 1/0 73.16 MB 0.7 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 L3 28/4 1.22 GB 1.0 1.6 0.9 0.7 1.5 0.8 0.0 1.8 97.4 96.5 16.31 7.68 12 1.359 373K 0 0.0 0.0 L4 167/7 9.86 GB 1.0 4.5 2.6 1.9 4.4 2.6 0.0 1.7 107.9 106.4 42.79 21.94 31 1.380 1414K 0 0.0 0.0 L5 1121/0 92.58 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1338/30 106.70 GB 0.0 6.4 3.5 3.0 7.2 4.3 2.4 8.4 94.9 106.4 69.38 33.93 54 1.285 2171K 534 0.0 0.0 Int 0/0 0.00 KB 0.0 6.4 3.5 3.0 7.2 4.3 2.4 8.4 94.9 106.4 69.38 33.93 54 1.285 2171K 534 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.4 3.5 3.0 6.3 3.4 0.0 0.0 105.7 104.4 62.27 31.30 44 1.415 2171K 534 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 124.1 7.10 2.62 10 0.710 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.861, interval 0.861 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.21 GB write, 956.78 MB/s write, 6.43 GB read, 852.97 MB/s read, 69.4 seconds Interval compaction: 7.21 GB write, 977.50 MB/s write, 6.43 GB read, 871.44 MB/s read, 69.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 36, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 36, interval: 36 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 260821 Average: 19.3734 StdDev: 219.61 Min: 1 Median: 1.8946 Max: 39822 Percentiles: P50: 1.89 P75: 2.94 P99: 503.29 P99.9: 2888.34 P99.99: 5263.93 ------------------------------------------------------ [ 0, 1 ] 10920 4.187% 4.187% # ( 1, 2 ] 133572 51.212% 55.399% ########## ( 2, 3 ] 54517 20.902% 76.301% #### ( 3, 4 ] 25072 9.613% 85.914% ## ( 4, 6 ] 25389 9.734% 95.648% ## ( 6, 10 ] 6293 2.413% 98.061% ( 10, 15 ] 1118 0.429% 98.489% ( 15, 22 ] 153 0.059% 98.548% ( 22, 34 ] 24 0.009% 98.557% ( 34, 51 ] 4 0.002% 98.559% ( 51, 76 ] 7 0.003% 98.561% ( 76, 110 ] 13 0.005% 98.566% ( 110, 170 ] 102 0.039% 98.606% ( 170, 250 ] 212 0.081% 98.687% ( 250, 380 ] 407 0.156% 98.843% ( 380, 580 ] 668 0.256% 99.099% ( 580, 870 ] 810 0.311% 99.410% ( 870, 1300 ] 647 0.248% 99.658% ( 1300, 1900 ] 395 0.151% 99.809% ( 1900, 2900 ] 242 0.093% 99.902% ( 2900, 4400 ] 206 0.079% 99.981% ( 4400, 6600 ] 66 0.025% 100.006% ( 6600, 9900 ] 16 0.006% 100.012% ( 9900, 14000 ] 5 0.002% 100.014% ( 14000, 22000 ] 3 0.001% 100.015% ( 22000, 33000 ] 1 0.000% 100.016% ( 33000, 50000 ] 1 0.000% 100.016% ** Level 1 read latency histogram (micros): Count: 18747 Average: 29.1663 StdDev: 429.18 Min: 1 Median: 2.0264 Max: 38719 Percentiles: P50: 2.03 P75: 3.13 P99: 637.27 P99.9: 4312.65 P99.99: 18501.20 ------------------------------------------------------ [ 0, 1 ] 323 1.723% 1.723% ( 1, 2 ] 8930 47.634% 49.357% ########## ( 2, 3 ] 4563 24.340% 73.697% ##### ( 3, 4 ] 1934 10.316% 84.013% ## ( 4, 6 ] 2095 11.175% 95.189% ## ( 6, 10 ] 541 2.886% 98.074% # ( 10, 15 ] 85 0.453% 98.528% ( 15, 22 ] 12 0.064% 98.592% ( 34, 51 ] 1 0.005% 98.597% ( 51, 76 ] 4 0.021% 98.618% ( 76, 110 ] 3 0.016% 98.634% ( 110, 170 ] 3 0.016% 98.650% ( 170, 250 ] 12 0.064% 98.714% ( 250, 380 ] 13 0.069% 98.784% ( 380, 580 ] 35 0.187% 98.971% ( 580, 870 ] 28 0.149% 99.120% ( 870, 1300 ] 59 0.315% 99.435% ( 1300, 1900 ] 37 0.197% 99.632% ( 1900, 2900 ] 22 0.117% 99.749% ( 2900, 4400 ] 30 0.160% 99.909% ( 4400, 6600 ] 8 0.043% 99.952% ( 6600, 9900 ] 3 0.016% 99.968% ( 9900, 14000 ] 3 0.016% 99.984% ( 14000, 22000 ] 2 0.011% 99.995% ( 33000, 50000 ] 1 0.005% 100.000% ** Level 2 read latency histogram (micros): Count: 93273 Average: 11.2401 StdDev: 279.55 Min: 1 Median: 1.9383 Max: 56950 Percentiles: P50: 1.94 P75: 2.97 P99: 11.87 P99.9: 1714.39 P99.99: 4045.45 ------------------------------------------------------ [ 0, 1 ] 3153 3.380% 3.380% # ( 1, 2 ] 46343 49.685% 53.066% ########## ( 2, 3 ] 21157 22.683% 75.749% ##### ( 3, 4 ] 9197 9.860% 85.609% ## ( 4, 6 ] 9603 10.296% 95.904% ## ( 6, 10 ] 2702 2.897% 98.801% # ( 10, 15 ] 496 0.532% 99.333% ( 15, 22 ] 70 0.075% 99.408% ( 22, 34 ] 19 0.020% 99.429% ( 34, 51 ] 5 0.005% 99.434% ( 51, 76 ] 4 0.004% 99.438% ( 76, 110 ] 3 0.003% 99.441% ( 110, 170 ] 12 0.013% 99.454% ( 170, 250 ] 28 0.030% 99.484% ( 250, 380 ] 43 0.046% 99.530% ( 380, 580 ] 82 0.088% 99.618% ( 580, 870 ] 111 0.119% 99.737% ( 870, 1300 ] 102 0.109% 99.847% ( 1300, 1900 ] 72 0.077% 99.924% ( 1900, 2900 ] 38 0.041% 99.965% ( 2900, 4400 ] 31 0.033% 99.998% ( 4400, 6600 ] 8 0.009% 100.006% ( 6600, 9900 ] 4 0.004% 100.011% ( 9900, 14000 ] 2 0.002% 100.013% ( 22000, 33000 ] 1 0.001% 100.014% ( 33000, 50000 ] 1 0.001% 100.015% ( 50000, 75000 ] 1 0.001% 100.016% ** Level 3 read latency histogram (micros): Count: 801826 Average: 12.8647 StdDev: 210.91 Min: 1 Median: 1.9732 Max: 60887 Percentiles: P50: 1.97 P75: 2.99 P99: 9.99 P99.9: 1130.85 P99.99: 1615.81 ------------------------------------------------------ [ 0, 1 ] 17418 2.172% 2.172% ( 1, 2 ] 394061 49.145% 51.318% ########## ( 2, 3 ] 192414 23.997% 75.315% ##### ( 3, 4 ] 83002 10.352% 85.666% ## ( 4, 6 ] 85169 10.622% 96.288% ## ( 6, 10 ] 21777 2.716% 99.004% # ( 10, 15 ] 3995 0.498% 99.502% ( 15, 22 ] 582 0.073% 99.575% ( 22, 34 ] 76 0.009% 99.584% ( 34, 51 ] 39 0.005% 99.589% ( 51, 76 ] 34 0.004% 99.594% ( 76, 110 ] 35 0.004% 99.598% ( 110, 170 ] 65 0.008% 99.606% ( 170, 250 ] 135 0.017% 99.623% ( 250, 380 ] 294 0.037% 99.660% ( 380, 580 ] 534 0.067% 99.726% ( 580, 870 ] 830 0.104% 99.830% ( 870, 1300 ] 930 0.116% 99.946% ( 1300, 1900 ] 676 0.084% 100.030% ( 1900, 2900 ] 564 0.070% 100.100% ( 2900, 4400 ] 547 0.068% 100.168% ( 4400, 6600 ] 134 0.017% 100.185% ( 6600, 9900 ] 44 0.005% 100.191% ( 9900, 14000 ] 7 0.001% 100.192% ( 14000, 22000 ] 16 0.002% 100.194% ( 22000, 33000 ] 4 0.000% 100.194% ( 33000, 50000 ] 3 0.000% 100.194% ( 50000, 75000 ] 1 0.000% 100.195% ** Level 4 read latency histogram (micros): Count: 551844 Average: 19.1937 StdDev: 244.36 Min: 0 Median: 1.9641 Max: 60970 Percentiles: P50: 1.96 P75: 2.99 P99: 19.08 P99.9: 1867.65 P99.99: 2528.95 ------------------------------------------------------ [ 0, 1 ] 11863 2.150% 2.150% ( 1, 2 ] 273883 49.631% 51.780% ########## ( 2, 3 ] 129671 23.498% 75.278% ##### ( 3, 4 ] 57456 10.412% 85.690% ## ( 4, 6 ] 56373 10.215% 95.905% ## ( 6, 10 ] 14358 2.602% 98.507% # ( 10, 15 ] 2522 0.457% 98.964% ( 15, 22 ] 344 0.062% 99.026% ( 22, 34 ] 32 0.006% 99.032% ( 34, 51 ] 29 0.005% 99.037% ( 51, 76 ] 32 0.006% 99.043% ( 76, 110 ] 24 0.004% 99.047% ( 110, 170 ] 97 0.018% 99.065% ( 170, 250 ] 226 0.041% 99.106% ( 250, 380 ] 381 0.069% 99.175% ( 380, 580 ] 776 0.141% 99.316% ( 580, 870 ] 1151 0.209% 99.524% ( 870, 1300 ] 1218 0.221% 99.745% ( 1300, 1900 ] 906 0.164% 99.909% ( 1900, 2900 ] 712 0.129% 100.038% ( 2900, 4400 ] 485 0.088% 100.126% ( 4400, 6600 ] 155 0.028% 100.154% ( 6600, 9900 ] 36 0.007% 100.161% ( 9900, 14000 ] 7 0.001% 100.162% ( 14000, 22000 ] 10 0.002% 100.164% ( 22000, 33000 ] 4 0.001% 100.164% ( 33000, 50000 ] 2 0.000% 100.165% ( 50000, 75000 ] 1 0.000% 100.165% ** Level 5 read latency histogram (micros): Count: 13225 Average: 1631.1781 StdDev: 2106.12 Min: 80 Median: 1059.3105 Max: 61372 Percentiles: P50: 1059.31 P75: 2127.40 P99: 6589.00 P99.9: 34196.18 P99.99: 61372.00 ------------------------------------------------------ ( 76, 110 ] 23 0.174% 0.174% ( 110, 170 ] 175 1.323% 1.497% ( 170, 250 ] 406 3.070% 4.567% # ( 250, 380 ] 916 6.926% 11.493% # ( 380, 580 ] 1657 12.529% 24.023% ### ( 580, 870 ] 2408 18.208% 42.231% #### ( 870, 1300 ] 2335 17.656% 59.887% #### ( 1300, 1900 ] 1685 12.741% 72.628% ### ( 1900, 2900 ] 1383 10.457% 83.085% ## ( 2900, 4400 ] 1457 11.017% 94.102% ## ( 4400, 6600 ] 652 4.930% 99.032% # ( 6600, 9900 ] 103 0.779% 99.811% ( 9900, 14000 ] 4 0.030% 99.841% ( 14000, 22000 ] 2 0.015% 99.856% ( 22000, 33000 ] 6 0.045% 99.902% ( 33000, 50000 ] 11 0.083% 99.985% ( 50000, 75000 ] 3 0.023% 100.008% ** 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.53 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.555 H:M:S, 46.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 130.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:3.555 H:M:S, 47.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 2024/12/15-16:01:00 ... thread 0: (1000000,2000000) ops and (290649.8,181943.4) ops/second in (3.440567,10.992430) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/11 3.14 GB 163.6 1.5 0.0 1.5 3.3 1.8 0.0 1.8 83.7 188.2 18.06 11.38 31 0.583 1535K 1784 0.0 0.0 L1 8/8 898.60 MB 0.0 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 L2 1/0 73.16 MB 0.7 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 L3 24/0 992.04 MB 1.0 1.6 0.9 0.7 1.5 0.8 0.0 1.8 97.4 96.5 16.31 7.68 12 1.359 373K 0 0.0 0.0 L4 162/0 9.48 GB 1.0 5.1 2.9 2.2 5.0 2.8 0.0 1.8 112.1 110.5 46.57 24.59 34 1.370 1732K 0 0.0 0.0 L5 1129/0 93.20 GB 1.0 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1342/19 107.73 GB 0.0 8.1 3.7 4.4 9.9 5.5 3.0 5.4 102.8 125.0 80.94 43.65 77 1.051 3640K 1784 0.0 0.0 Int 0/0 0.00 KB 0.0 8.1 3.7 4.4 9.9 5.5 3.0 5.4 102.8 125.0 80.94 43.65 77 1.051 3640K 1784 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 8.1 3.7 4.4 8.0 3.6 0.0 0.0 117.8 116.5 70.63 38.28 51 1.385 3640K 1784 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 183.3 10.31 5.37 26 0.397 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): 11.2 total, 11.0 interval Flush(GB): cumulative 1.846, interval 1.846 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.88 GB write, 906.90 MB/s write, 8.13 GB read, 745.80 MB/s read, 80.9 seconds Interval compaction: 9.88 GB write, 920.40 MB/s write, 8.13 GB read, 756.90 MB/s read, 80.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 36, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 36, interval: 36 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 579419 Average: 17.2161 StdDev: 155.36 Min: 0 Median: 1.6473 Max: 39822 Percentiles: P50: 1.65 P75: 2.41 P99: 344.38 P99.9: 1492.61 P99.99: 2830.73 ------------------------------------------------------ [ 0, 1 ] 85145 14.695% 14.695% ### ( 1, 2 ] 316009 54.539% 69.234% ########### ( 2, 3 ] 81533 14.072% 83.305% ### ( 3, 4 ] 33571 5.794% 89.099% # ( 4, 6 ] 30158 5.205% 94.304% # ( 6, 10 ] 7697 1.328% 95.633% ( 10, 15 ] 1498 0.259% 95.891% ( 15, 22 ] 213 0.037% 95.928% ( 22, 34 ] 28 0.005% 95.933% ( 34, 51 ] 4 0.001% 95.933% ( 51, 76 ] 15 0.003% 95.936% ( 76, 110 ] 2319 0.400% 96.336% ( 110, 170 ] 8868 1.530% 97.867% ( 170, 250 ] 4747 0.819% 98.686% ( 250, 380 ] 2508 0.433% 99.119% ( 380, 580 ] 2268 0.391% 99.510% ( 580, 870 ] 1368 0.236% 99.746% ( 870, 1300 ] 759 0.131% 99.877% ( 1300, 1900 ] 413 0.071% 99.949% ( 1900, 2900 ] 259 0.045% 99.993% ( 2900, 4400 ] 208 0.036% 100.029% ( 4400, 6600 ] 66 0.011% 100.041% ( 6600, 9900 ] 16 0.003% 100.043% ( 9900, 14000 ] 5 0.001% 100.044% ( 14000, 22000 ] 3 0.001% 100.045% ( 22000, 33000 ] 1 0.000% 100.045% ( 33000, 50000 ] 1 0.000% 100.045% ** Level 1 read latency histogram (micros): Count: 19218 Average: 33.5384 StdDev: 425.40 Min: 1 Median: 2.0780 Max: 38719 Percentiles: P50: 2.08 P75: 3.31 P99: 700.18 P99.9: 4289.10 P99.99: 18312.80 ------------------------------------------------------ [ 0, 1 ] 323 1.681% 1.681% ( 1, 2 ] 8930 46.467% 48.148% ######### ( 2, 3 ] 4563 23.743% 71.891% ##### ( 3, 4 ] 1934 10.063% 81.954% ## ( 4, 6 ] 2096 10.906% 92.861% ## ( 6, 10 ] 541 2.815% 95.676% # ( 10, 15 ] 85 0.442% 96.118% ( 15, 22 ] 12 0.062% 96.181% ( 34, 51 ] 1 0.005% 96.186% ( 51, 76 ] 4 0.021% 96.207% ( 76, 110 ] 72 0.375% 96.581% ( 110, 170 ] 206 1.072% 97.653% ( 170, 250 ] 113 0.588% 98.241% ( 250, 380 ] 55 0.286% 98.527% ( 380, 580 ] 73 0.380% 98.907% ( 580, 870 ] 43 0.224% 99.131% ( 870, 1300 ] 61 0.317% 99.448% ( 1300, 1900 ] 37 0.193% 99.641% ( 1900, 2900 ] 22 0.114% 99.755% ( 2900, 4400 ] 30 0.156% 99.912% ( 4400, 6600 ] 8 0.042% 99.953% ( 6600, 9900 ] 3 0.016% 99.969% ( 9900, 14000 ] 3 0.016% 99.984% ( 14000, 22000 ] 2 0.010% 99.995% ( 33000, 50000 ] 1 0.005% 100.000% ** Level 2 read latency histogram (micros): Count: 93371 Average: 11.4444 StdDev: 279.53 Min: 1 Median: 1.9394 Max: 56950 Percentiles: P50: 1.94 P75: 2.97 P99: 12.85 P99.9: 1713.58 P99.99: 4044.98 ------------------------------------------------------ [ 0, 1 ] 3153 3.377% 3.377% # ( 1, 2 ] 46343 49.633% 53.010% ########## ( 2, 3 ] 21157 22.659% 75.669% ##### ( 3, 4 ] 9197 9.850% 85.519% ## ( 4, 6 ] 9603 10.285% 95.804% ## ( 6, 10 ] 2702 2.894% 98.698% # ( 10, 15 ] 496 0.531% 99.229% ( 15, 22 ] 70 0.075% 99.304% ( 22, 34 ] 19 0.020% 99.324% ( 34, 51 ] 5 0.005% 99.330% ( 51, 76 ] 4 0.004% 99.334% ( 76, 110 ] 15 0.016% 99.350% ( 110, 170 ] 63 0.067% 99.417% ( 170, 250 ] 48 0.051% 99.469% ( 250, 380 ] 48 0.051% 99.520% ( 380, 580 ] 88 0.094% 99.614% ( 580, 870 ] 114 0.122% 99.737% ( 870, 1300 ] 103 0.110% 99.847% ( 1300, 1900 ] 72 0.077% 99.924% ( 1900, 2900 ] 38 0.041% 99.965% ( 2900, 4400 ] 31 0.033% 99.998% ( 4400, 6600 ] 8 0.009% 100.006% ( 6600, 9900 ] 4 0.004% 100.011% ( 9900, 14000 ] 2 0.002% 100.013% ( 22000, 33000 ] 1 0.001% 100.014% ( 33000, 50000 ] 1 0.001% 100.015% ( 50000, 75000 ] 1 0.001% 100.016% ** Level 3 read latency histogram (micros): Count: 819189 Average: 12.8277 StdDev: 208.81 Min: 1 Median: 1.9660 Max: 60887 Percentiles: P50: 1.97 P75: 2.98 P99: 10.63 P99.9: 1124.42 P99.99: 1614.70 ------------------------------------------------------ [ 0, 1 ] 18454 2.253% 2.253% ( 1, 2 ] 404892 49.426% 51.679% ########## ( 2, 3 ] 195617 23.879% 75.558% ##### ( 3, 4 ] 83863 10.237% 85.795% ## ( 4, 6 ] 85776 10.471% 96.266% ## ( 6, 10 ] 21891 2.672% 98.938% # ( 10, 15 ] 4005 0.489% 99.427% ( 15, 22 ] 584 0.071% 99.499% ( 22, 34 ] 76 0.009% 99.508% ( 34, 51 ] 39 0.005% 99.513% ( 51, 76 ] 34 0.004% 99.517% ( 76, 110 ] 121 0.015% 99.532% ( 110, 170 ] 345 0.042% 99.574% ( 170, 250 ] 309 0.038% 99.611% ( 250, 380 ] 369 0.045% 99.656% ( 380, 580 ] 592 0.072% 99.729% ( 580, 870 ] 849 0.104% 99.832% ( 870, 1300 ] 936 0.114% 99.947% ( 1300, 1900 ] 677 0.083% 100.029% ( 1900, 2900 ] 564 0.069% 100.098% ( 2900, 4400 ] 547 0.067% 100.165% ( 4400, 6600 ] 134 0.016% 100.181% ( 6600, 9900 ] 44 0.005% 100.187% ( 9900, 14000 ] 7 0.001% 100.188% ( 14000, 22000 ] 16 0.002% 100.189% ( 22000, 33000 ] 4 0.000% 100.190% ( 33000, 50000 ] 3 0.000% 100.190% ( 50000, 75000 ] 1 0.000% 100.190% ** Level 4 read latency histogram (micros): Count: 588264 Average: 20.0269 StdDev: 237.93 Min: 0 Median: 1.9559 Max: 60970 Percentiles: P50: 1.96 P75: 2.99 P99: 274.25 P99.9: 1842.06 P99.99: 2516.16 ------------------------------------------------------ [ 0, 1 ] 13238 2.250% 2.250% ( 1, 2 ] 293851 49.952% 52.203% ########## ( 2, 3 ] 135912 23.104% 75.306% ##### ( 3, 4 ] 59193 10.062% 85.369% ## ( 4, 6 ] 57881 9.839% 95.208% ## ( 6, 10 ] 14778 2.512% 97.720% # ( 10, 15 ] 2558 0.435% 98.155% ( 15, 22 ] 351 0.060% 98.215% ( 22, 34 ] 33 0.006% 98.220% ( 34, 51 ] 29 0.005% 98.225% ( 51, 76 ] 33 0.006% 98.231% ( 76, 110 ] 609 0.104% 98.334% ( 110, 170 ] 2334 0.397% 98.731% ( 170, 250 ] 1412 0.240% 98.971% ( 250, 380 ] 908 0.154% 99.126% ( 380, 580 ] 1211 0.206% 99.331% ( 580, 870 ] 1278 0.217% 99.549% ( 870, 1300 ] 1241 0.211% 99.760% ( 1300, 1900 ] 914 0.155% 99.915% ( 1900, 2900 ] 716 0.122% 100.037% ( 2900, 4400 ] 486 0.083% 100.119% ( 4400, 6600 ] 155 0.026% 100.146% ( 6600, 9900 ] 36 0.006% 100.152% ( 9900, 14000 ] 7 0.001% 100.153% ( 14000, 22000 ] 10 0.002% 100.155% ( 22000, 33000 ] 4 0.001% 100.155% ( 33000, 50000 ] 2 0.000% 100.156% ( 50000, 75000 ] 1 0.000% 100.156% ** Level 5 read latency histogram (micros): Count: 53743 Average: 565.4635 StdDev: 1217.39 Min: 74 Median: 207.0267 Max: 61372 Percentiles: P50: 207.03 P75: 502.08 P99: 5201.62 P99.9: 8818.91 P99.99: 37057.90 ------------------------------------------------------ ( 51, 76 ] 3 0.006% 0.006% ( 76, 110 ] 4513 8.397% 8.403% ## ( 110, 170 ] 17835 33.186% 41.589% ####### ( 170, 250 ] 9767 18.174% 59.762% #### ( 250, 380 ] 5154 9.590% 69.352% ## ( 380, 580 ] 4974 9.255% 78.607% ## ( 580, 870 ] 3558 6.620% 85.228% # ( 870, 1300 ] 2569 4.780% 90.008% # ( 1300, 1900 ] 1728 3.215% 93.223% # ( 1900, 2900 ] 1406 2.616% 95.839% # ( 2900, 4400 ] 1462 2.720% 98.560% # ( 4400, 6600 ] 652 1.213% 99.773% ( 6600, 9900 ] 103 0.192% 99.965% ( 9900, 14000 ] 4 0.007% 99.972% ( 14000, 22000 ] 2 0.004% 99.976% ( 22000, 33000 ] 6 0.011% 99.987% ( 33000, 50000 ] 11 0.020% 100.007% ( 50000, 75000 ] 3 0.006% 100.013% ** DB Stats ** Uptime(secs): 11.2 total, 3.4 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 176.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:3.555 H:M:S, 31.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 286.06 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/12/15-16:01:06 ... thread 0: (1000000,3000000) ops and (158191.7,173271.4) ops/second in (6.321445,17.313875) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/14 4.06 GB 125.8 2.7 0.0 2.7 5.5 2.8 0.0 2.0 107.2 219.1 25.86 18.68 52 0.497 2814K 3025 0.0 0.0 L1 8/8 898.60 MB 0.0 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 L2 1/0 73.16 MB 0.7 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 L3 24/0 992.04 MB 1.0 1.6 0.9 0.7 1.5 0.8 0.0 1.8 97.4 96.5 16.31 7.68 12 1.359 373K 0 0.0 0.0 L4 162/0 9.48 GB 1.0 5.1 2.9 2.2 5.0 2.8 0.0 1.8 112.1 110.5 46.57 24.59 34 1.370 1732K 0 0.0 0.0 L5 1129/0 93.20 GB 1.0 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1342/22 108.65 GB 0.0 9.4 3.7 5.6 12.1 6.5 3.0 4.3 108.0 139.6 88.74 50.95 98 0.905 4920K 3025 0.0 0.0 Int 0/0 0.00 KB 0.0 9.4 3.7 5.6 12.1 6.5 3.0 4.3 108.0 139.6 88.74 50.95 98 0.905 4920K 3025 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 9.4 3.7 5.6 9.3 3.6 0.0 0.0 127.2 125.9 75.33 42.90 56 1.345 4920K 3025 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 216.1 13.41 8.05 42 0.319 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 17.5 total, 17.3 interval Flush(GB): cumulative 2.830, interval 2.830 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 12.10 GB write, 708.59 MB/s write, 9.36 GB read, 548.16 MB/s read, 88.7 seconds Interval compaction: 12.10 GB write, 715.28 MB/s write, 9.36 GB read, 553.34 MB/s read, 88.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 8, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 8, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 36, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 8, total-stops: 36, interval: 44 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1091329 Average: 16.9105 StdDev: 120.49 Min: 0 Median: 1.5381 Max: 39822 Percentiles: P50: 1.54 P75: 2.01 P99: 290.25 P99.9: 924.50 P99.99: 1677.28 ------------------------------------------------------ [ 0, 1 ] 229076 20.991% 20.991% #### ( 1, 2 ] 588348 53.911% 74.902% ########### ( 2, 3 ] 114527 10.494% 85.396% ## ( 3, 4 ] 46077 4.222% 89.618% # ( 4, 6 ] 36607 3.354% 92.972% # ( 6, 10 ] 8876 0.813% 93.786% ( 10, 15 ] 1842 0.169% 93.955% ( 15, 22 ] 270 0.025% 93.979% ( 22, 34 ] 30 0.003% 93.982% ( 34, 51 ] 9 0.001% 93.983% ( 51, 76 ] 36 0.003% 93.986% ( 76, 110 ] 9251 0.848% 94.834% ( 110, 170 ] 31213 2.860% 97.694% # ( 170, 250 ] 12682 1.162% 98.856% ( 250, 380 ] 5076 0.465% 99.321% ( 380, 580 ] 4317 0.396% 99.717% ( 580, 870 ] 1897 0.174% 99.891% ( 870, 1300 ] 818 0.075% 99.965% ( 1300, 1900 ] 426 0.039% 100.004% ( 1900, 2900 ] 279 0.026% 100.030% ( 2900, 4400 ] 210 0.019% 100.049% ( 4400, 6600 ] 66 0.006% 100.055% ( 6600, 9900 ] 16 0.001% 100.057% ( 9900, 14000 ] 5 0.000% 100.057% ( 14000, 22000 ] 3 0.000% 100.058% ( 22000, 33000 ] 1 0.000% 100.058% ( 33000, 50000 ] 1 0.000% 100.058% ** Level 1 read latency histogram (micros): Count: 20244 Average: 40.5917 StdDev: 416.30 Min: 1 Median: 2.1904 Max: 38719 Percentiles: P50: 2.19 P75: 3.71 P99: 685.04 P99.9: 4237.80 P99.99: 17902.40 ------------------------------------------------------ [ 0, 1 ] 323 1.596% 1.596% ( 1, 2 ] 8930 44.112% 45.707% ######### ( 2, 3 ] 4563 22.540% 68.247% ##### ( 3, 4 ] 1934 9.553% 77.801% ## ( 4, 6 ] 2096 10.354% 88.155% ## ( 6, 10 ] 541 2.672% 90.827% # ( 10, 15 ] 85 0.420% 91.247% ( 15, 22 ] 12 0.059% 91.306% ( 34, 51 ] 1 0.005% 91.311% ( 51, 76 ] 5 0.025% 91.336% ( 76, 110 ] 271 1.339% 92.674% ( 110, 170 ] 738 3.646% 96.320% # ( 170, 250 ] 289 1.428% 97.747% ( 250, 380 ] 117 0.578% 98.325% ( 380, 580 ] 117 0.578% 98.903% ( 580, 870 ] 54 0.267% 99.170% ( 870, 1300 ] 61 0.301% 99.471% ( 1300, 1900 ] 38 0.188% 99.659% ( 1900, 2900 ] 22 0.109% 99.768% ( 2900, 4400 ] 30 0.148% 99.916% ( 4400, 6600 ] 8 0.040% 99.956% ( 6600, 9900 ] 3 0.015% 99.970% ( 9900, 14000 ] 3 0.015% 99.985% ( 14000, 22000 ] 2 0.010% 99.995% ( 33000, 50000 ] 1 0.005% 100.000% ** Level 2 read latency histogram (micros): Count: 93555 Average: 11.7804 StdDev: 279.42 Min: 1 Median: 1.9413 Max: 56950 Percentiles: P50: 1.94 P75: 2.98 P99: 14.68 P99.9: 1712.04 P99.99: 4044.09 ------------------------------------------------------ [ 0, 1 ] 3153 3.370% 3.370% # ( 1, 2 ] 46343 49.536% 52.906% ########## ( 2, 3 ] 21157 22.615% 75.520% ##### ( 3, 4 ] 9197 9.831% 85.351% ## ( 4, 6 ] 9603 10.265% 95.615% ## ( 6, 10 ] 2702 2.888% 98.504% # ( 10, 15 ] 496 0.530% 99.034% ( 15, 22 ] 70 0.075% 99.109% ( 22, 34 ] 19 0.020% 99.129% ( 34, 51 ] 5 0.005% 99.134% ( 51, 76 ] 4 0.004% 99.138% ( 76, 110 ] 53 0.057% 99.195% ( 110, 170 ] 156 0.167% 99.362% ( 170, 250 ] 77 0.082% 99.444% ( 250, 380 ] 56 0.060% 99.504% ( 380, 580 ] 100 0.107% 99.611% ( 580, 870 ] 117 0.125% 99.736% ( 870, 1300 ] 104 0.111% 99.847% ( 1300, 1900 ] 72 0.077% 99.924% ( 1900, 2900 ] 38 0.041% 99.965% ( 2900, 4400 ] 31 0.033% 99.998% ( 4400, 6600 ] 8 0.009% 100.006% ( 6600, 9900 ] 4 0.004% 100.011% ( 9900, 14000 ] 2 0.002% 100.013% ( 22000, 33000 ] 1 0.001% 100.014% ( 33000, 50000 ] 1 0.001% 100.015% ( 50000, 75000 ] 1 0.001% 100.016% ** Level 3 read latency histogram (micros): Count: 820600 Average: 13.1175 StdDev: 208.81 Min: 1 Median: 1.9678 Max: 60887 Percentiles: P50: 1.97 P75: 2.98 P99: 12.37 P99.9: 1124.42 P99.99: 1615.46 ------------------------------------------------------ [ 0, 1 ] 18454 2.249% 2.249% ( 1, 2 ] 404892 49.341% 51.590% ########## ( 2, 3 ] 195617 23.838% 75.428% ##### ( 3, 4 ] 83863 10.220% 85.648% ## ( 4, 6 ] 85776 10.453% 96.101% ## ( 6, 10 ] 21891 2.668% 98.768% # ( 10, 15 ] 4005 0.488% 99.256% ( 15, 22 ] 584 0.071% 99.328% ( 22, 34 ] 76 0.009% 99.337% ( 34, 51 ] 39 0.005% 99.342% ( 51, 76 ] 34 0.004% 99.346% ( 76, 110 ] 342 0.042% 99.387% ( 110, 170 ] 1082 0.132% 99.519% ( 170, 250 ] 578 0.070% 99.590% ( 250, 380 ] 461 0.056% 99.646% ( 380, 580 ] 661 0.081% 99.726% ( 580, 870 ] 870 0.106% 99.832% ( 870, 1300 ] 937 0.114% 99.947% ( 1300, 1900 ] 677 0.083% 100.029% ( 1900, 2900 ] 565 0.069% 100.098% ( 2900, 4400 ] 547 0.067% 100.165% ( 4400, 6600 ] 134 0.016% 100.181% ( 6600, 9900 ] 44 0.005% 100.186% ( 9900, 14000 ] 7 0.001% 100.187% ( 14000, 22000 ] 16 0.002% 100.189% ( 22000, 33000 ] 4 0.000% 100.190% ( 33000, 50000 ] 3 0.000% 100.190% ( 50000, 75000 ] 1 0.000% 100.190% ** Level 4 read latency histogram (micros): Count: 601707 Average: 23.2445 StdDev: 236.94 Min: 0 Median: 1.9784 Max: 60970 Percentiles: P50: 1.98 P75: 3.13 P99: 371.15 P99.9: 1835.42 P99.99: 2516.75 ------------------------------------------------------ [ 0, 1 ] 13238 2.200% 2.200% ( 1, 2 ] 293964 48.855% 51.055% ########## ( 2, 3 ] 136232 22.641% 73.696% ##### ( 3, 4 ] 59499 9.888% 83.584% ## ( 4, 6 ] 58223 9.676% 93.261% ## ( 6, 10 ] 14809 2.461% 95.722% ( 10, 15 ] 2574 0.428% 96.150% ( 15, 22 ] 354 0.059% 96.208% ( 22, 34 ] 33 0.005% 96.214% ( 34, 51 ] 29 0.005% 96.219% ( 51, 76 ] 34 0.006% 96.224% ( 76, 110 ] 2460 0.409% 96.633% ( 110, 170 ] 9050 1.504% 98.137% ( 170, 250 ] 3684 0.612% 98.750% ( 250, 380 ] 1617 0.269% 99.018% ( 380, 580 ] 1781 0.296% 99.314% ( 580, 870 ] 1439 0.239% 99.553% ( 870, 1300 ] 1267 0.211% 99.764% ( 1300, 1900 ] 917 0.152% 99.916% ( 1900, 2900 ] 718 0.119% 100.036% ( 2900, 4400 ] 488 0.081% 100.117% ( 4400, 6600 ] 155 0.026% 100.143% ( 6600, 9900 ] 36 0.006% 100.149% ( 9900, 14000 ] 7 0.001% 100.150% ( 14000, 22000 ] 10 0.002% 100.151% ( 22000, 33000 ] 4 0.001% 100.152% ( 33000, 50000 ] 2 0.000% 100.152% ( 50000, 75000 ] 1 0.000% 100.153% ** Level 5 read latency histogram (micros): Count: 141762 Average: 325.2557 StdDev: 778.07 Min: 74 Median: 158.2902 Max: 61372 Percentiles: P50: 158.29 P75: 240.62 P99: 3739.53 P99.9: 6529.94 P99.99: 13819.39 ------------------------------------------------------ ( 51, 76 ] 9 0.006% 0.006% ( 76, 110 ] 18321 12.924% 12.930% ### ( 110, 170 ] 65294 46.059% 58.989% ######### ( 170, 250 ] 25712 18.137% 77.126% #### ( 250, 380 ] 10444 7.367% 84.494% # ( 380, 580 ] 9176 6.473% 90.967% # ( 580, 870 ] 4698 3.314% 94.281% # ( 870, 1300 ] 2696 1.902% 96.182% ( 1300, 1900 ] 1750 1.234% 97.417% ( 1900, 2900 ] 1425 1.005% 98.422% ( 2900, 4400 ] 1464 1.033% 99.455% ( 4400, 6600 ] 652 0.460% 99.915% ( 6600, 9900 ] 103 0.073% 99.987% ( 9900, 14000 ] 4 0.003% 99.990% ( 14000, 22000 ] 2 0.001% 99.992% ( 22000, 33000 ] 6 0.004% 99.996% ( 33000, 50000 ] 11 0.008% 100.004% ( 50000, 75000 ] 3 0.002% 100.006% ** DB Stats ** Uptime(secs): 17.5 total, 6.3 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 168.92 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.239 H:M:S, 35.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 155.69 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.684 H:M:S, 42.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] readwhilewriting : 217.689 micros/op 18355 ops/sec 60.146 seconds 1103996 operations; 17.8 MB/s (285999 of 285999 found) Microseconds per read: Count: 1103996 Average: 217.6904 StdDev: 666.82 Min: 2 Median: 166.8070 Max: 109883 Percentiles: P50: 166.81 P75: 224.23 P99: 795.87 P99.9: 9942.86 P99.99: 28890.59 ------------------------------------------------------ ( 1, 2 ] 3 0.000% 0.000% ( 2, 3 ] 33 0.003% 0.003% ( 3, 4 ] 47 0.004% 0.008% ( 4, 6 ] 74 0.007% 0.014% ( 6, 10 ] 629 0.057% 0.071% ( 10, 15 ] 4758 0.431% 0.502% ( 15, 22 ] 3167 0.287% 0.789% ( 22, 34 ] 12675 1.148% 1.937% ( 34, 51 ] 2588 0.234% 2.172% ( 51, 76 ] 344 0.031% 2.203% ( 76, 110 ] 27464 2.488% 4.690% ( 110, 170 ] 528332 47.856% 52.547% ########## ( 170, 250 ] 365689 33.124% 85.671% ####### ( 250, 380 ] 102904 9.321% 94.992% ## ( 380, 580 ] 35592 3.224% 98.216% # ( 580, 870 ] 11630 1.053% 99.269% ( 870, 1300 ] 3671 0.333% 99.602% ( 1300, 1900 ] 1347 0.122% 99.724% ( 1900, 2900 ] 893 0.081% 99.805% ( 2900, 4400 ] 628 0.057% 99.862% ( 4400, 6600 ] 247 0.022% 99.884% ( 6600, 9900 ] 173 0.016% 99.900% ( 9900, 14000 ] 383 0.035% 99.934% ( 14000, 22000 ] 515 0.047% 99.981% ( 22000, 33000 ] 159 0.014% 99.995% ( 33000, 50000 ] 33 0.003% 99.998% ( 50000, 75000 ] 14 0.001% 100.000% ( 75000, 110000 ] 4 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 : 15482094 rocksdb.bloom.filter.full.positive COUNT : 1255317 rocksdb.bloom.filter.full.true.positive COUNT : 1103583 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 : 413 rocksdb.memtable.miss COUNT : 1103583 rocksdb.l0.hit COUNT : 42516 rocksdb.l1.hit COUNT : 14367 rocksdb.l2andup.hit COUNT : 1046700 rocksdb.compaction.key.drop.new COUNT : 135743 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 : 3285732 rocksdb.number.keys.read COUNT : 1103996 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 3390875424 rocksdb.bytes.read COUNT : 1103996000 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 : 1533 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 46781369 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 : 14923831440 rocksdb.compact.write.bytes COUNT : 14779163814 rocksdb.flush.write.bytes COUNT : 3368932011 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 : 22 rocksdb.number.superversion_acquires COUNT : 673 rocksdb.number.superversion_releases COUNT : 649 rocksdb.number.superversion_cleanups COUNT : 168 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 : 181 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 : 3341766656 rocksdb.memtable.garbage.bytes.at.flush COUNT : 1306624 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 : 19845975915 rocksdb.non.last.level.read.count COUNT : 4650119 rocksdb.block.checksum.compute.count COUNT : 4880394 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 : 165.883705 P95 : 379.603521 P99 : 794.832521 P100 : 109881.000000 COUNT : 1103996 SUM : 239321406 rocksdb.db.write.micros P50 : 1.588205 P95 : 5.390650 P99 : 79.482626 P100 : 812725.000000 COUNT : 3285732 SUM : 55643634 rocksdb.compaction.times.micros P50 : 1321153.846154 P95 : 2970000.000000 P99 : 39560000.000000 P100 : 44313294.000000 COUNT : 59 SUM : 126462858 rocksdb.compaction.times.cpu_micros P50 : 756428.571429 P95 : 1678333.333333 P99 : 11522000.000000 P100 : 13679662.000000 COUNT : 59 SUM : 63272303 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 : 800.652174 P95 : 123000.000000 P99 : 153982.000000 P100 : 153982.000000 COUNT : 47 SUM : 566394 rocksdb.compaction.outfile.sync.micros P50 : 48866.666667 P95 : 222500.000000 P99 : 334500.000000 P100 : 1074744.000000 COUNT : 170 SUM : 12958820 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 : 634.375000 P95 : 5238.750000 P99 : 6547.750000 P100 : 7995.000000 COUNT : 119 SUM : 179939 rocksdb.table.open.io.micros P50 : 9659.629630 P95 : 20379.607843 P99 : 27598.421053 P100 : 68663.000000 COUNT : 1533 SUM : 15123122 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.892800 P95 : 125.257331 P99 : 225.357835 P100 : 60890.000000 COUNT : 3613186 SUM : 76613955 rocksdb.read.block.get.micros P50 : 138.700286 P95 : 262.306869 P99 : 716.775447 P100 : 61409.000000 COUNT : 1265677 SUM : 202193590 rocksdb.write.raw.block.micros P50 : 0.529881 P95 : 1.174259 P99 : 3.744886 P100 : 126830.000000 COUNT : 4395666 SUM : 13164639 rocksdb.numfiles.in.singlecompaction P50 : 2.400000 P95 : 3.975000 P99 : 35.000000 P100 : 35.000000 COUNT : 72 SUM : 255 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.573738 P95 : 1290.922948 P99 : 2693.540117 P100 : 812557.000000 COUNT : 231206 SUM : 46803890 rocksdb.sst.read.micros P50 : 2.474785 P95 : 179.883215 P99 : 451.778240 P100 : 61372.000000 COUNT : 4650153 SUM : 266050773 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 : 1103996 SUM : 1103996000 rocksdb.bytes.per.write P50 : 1032.000000 P95 : 1032.000000 P99 : 1032.000000 P100 : 1032.000000 COUNT : 3285732 SUM : 3390875424 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 : 219473.684211 P95 : 1000250.000000 P99 : 1070351.000000 P100 : 1070351.000000 COUNT : 47 SUM : 14461089 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 : 184 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