2024-10-18 14:24:04 , Up: 39-19:37:36 .rocksdb/LOG
IntProps |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
rocksdb cfstats no file histogram | ** Compaction Stats [default] ** Run 0 , Wait 1 , MemTable 360.251 MiB ** compact flush flushall Level Files Size RawKV 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 0/0 0.00 KB 0.00 KB 0.0 0.0 0.0 0.0 2164.9 2164.9 0.0 1.0 0.0 2829.2 783.55 589.55 4384 0.179 0 0 0.0 0.0 L1 0/0 0.00 KB 0.00 KB 0.0 2199.7 2165.4 34.3 964.9 930.5 0.0 0.4 1044.6 458.2 2156.25 4668.82 3459 0.623 6295M 1552M 0.0 0.0 L2 5/0 72.56 MB 221.39 MB 0.1 2064.9 606.9 1457.9 1594.4 136.5 323.9 2.6 15.4 11.9 136915.77 49894.53 27216 5.031 34G 212M 0.0 0.0 L3 4/0 8.72 MB 20.45 MB 0.0 1298.6 331.1 967.5 1085.2 117.7 129.4 3.3 17.6 14.7 75551.24 26272.03 18067 4.182 20G 348M 0.0 0.0 L4 11/0 140.10 MB 445.11 MB 0.0 686.8 214.6 472.1 565.4 93.3 33.7 2.6 16.3 13.4 43125.94 17194.54 10142 4.252 14G 710M 0.0 0.0 L5 11/0 47.52 MB 74.49 MB 0.0 194.8 127.0 67.8 158.3 90.4 5.4 1.2 15.3 12.4 13076.44 5116.85 11032 1.185 5060M 186M 0.0 0.0 L6 968/0 87.05 GB 352.89 GB 0.0 1186.3 104.0 1082.2 1129.5 47.3 0.0 10.9 12.7 12.1 95729.42 51676.12 254 376.887 77G 1212M 0.0 0.0 Sum 999/0 87.31 GB 353.63 GB 0.0 7631.0 3549.1 4081.9 7662.5 3580.6 492.3 3.5 21.3 21.4 367338.61 155412.45 74554 4.927 158G 4222M 0.0 0.0 Int 0/0 0.00 KB 0.00 KB 0.0 7631.0 3549.1 4081.9 7662.5 3580.6 492.3 3.5 21.3 21.4 367338.61 155412.45 74554 4.927 158G 4222M 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size RawKV 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.00 KB 0.0 7631.0 3549.1 4081.9 5497.6 1415.7 0.0 0.0 21.3 15.4 366555.06 154822.90 70170 5.224 158G 4222M 0.0 0.0 High 0/0 0.00 KB 0.00 KB 0.0 0.0 0.0 0.0 2164.6 2164.6 0.0 0.0 0.0 2831.7 782.76 589.55 4383 0.179 0 0 0.0 0.0 User 0/0 0.00 KB 0.00 KB 0.0 0.0 0.0 0.0 0.3 0.3 0.0 0.0 0.0 353.2 0.78 0.00 1 0.784 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 noint=0 noint=0&sst=1 noint=0&sst=2 noint=0&nozero=1 noint=0&nozero=1&sst=1 noint=0&nozero=1&sst=2 Uptime(secs): 3440254.5 total, 3440254.5 interval noint=1 noint=1&sst=1 noint=1&sst=2 noint=1&nozero=1 noint=1&nozero=1&sst=1 noint=1&nozero=1&sst=2 Flush(GB): cumulative 2164.876, interval 2164.876 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.482922 TB write, 2.28 MB/s write, 7.452119 TB read, 2.27 MB/s read, 367338.6 seconds Interval compaction: 7662.511854 GB write, 2.28 MB/s write, 7630.969606 GB read, 2.27 MB/s read, 367338.6 seconds Write Stall (count): cf-l0-file-count-limit-with-ongoing-compaction: delays 0, stops 0 | l0-file-count-limit: delays 0, stops 0 | memtable-limit: delays 0, stops 0 | pending-compaction-bytes: delays 0, stops 0 | total: delays 0, stops 0 Block cache LRUCache@0x4d50cd0#2520255 capacity: 512.00 MB seed: 1080093140 usage: 0.09 KB table_size: 1024 occupancy: 1 collections: 229348 last_copies: 1 last_secs: 4.2e-05 secs_since: 8 Block cache entry stats(count,size,portion): Misc(1,0.00 KB,0%) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rocksdb dbstats | ** DB Stats ** Uptime(secs): 3440254.5 total, 128.1 interval Cumulative writes: 297M writes, 6085M keys, 297M commit groups, 1.0 writes per commit group, ingest: 2000.75 GB, 0.60 MB/s Cumulative WAL: 297M writes, 0 syncs, 297213660.00 writes per sync, written: 2000.75 GB, 0.60 MB/s Cumulative stall: 00:00:0.000 H:M:S, 0.0 percent Interval writes: 6091 writes, 128K keys, 6091 commit groups, 1.0 writes per commit group, ingest: 42.65 MB, 0.33 MB/s Interval WAL: 6091 writes, 0 syncs, 6091.00 writes per sync, written: 0.04 GB, 0.33 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: delays 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rocksdb sstables | all levels summary: version# 120404, file count = 999, total size = 87.314 GB, avg size = 0.087 GB per_level=0 per_level=1 per_level=2
url param per_level is 1 but there is no any compacting sst |