2024-10-18 14:24:20 , Up: 39-19:37:52   .rocksdb/LOG

IntProps
rocksdb.num-immutable-mem-table0
rocksdb.num-immutable-mem-table-flushed0
rocksdb.mem-table-flush-pending0
rocksdb.num-running-flushes0
rocksdb.compaction-pending1
rocksdb.num-running-compactions0
rocksdb.background-errors0
rocksdb.cur-size-active-mem-table382731264
rocksdb.cur-size-all-mem-tables382731264
rocksdb.size-all-mem-tables382731264
rocksdb.num-entries-active-mem-table991281
rocksdb.num-entries-imm-mem-tables0
rocksdb.num-deletes-active-mem-table42080
rocksdb.num-deletes-imm-mem-tables0
rocksdb.estimate-num-keys5185074320
rocksdb.estimate-table-readers-mem93752033873
rocksdb.is-file-deletions-enabled1
rocksdb.num-snapshots6
rocksdb.oldest-snapshot-time1729232660
rocksdb.oldest-snapshot-sequence197540139294
rocksdb.num-live-versions1
rocksdb.current-super-version-number159666
rocksdb.estimate-live-data-size93472670350
rocksdb.min-log-number-to-keep14969081
rocksdb.min-obsolete-sst-number-to-keep18446744073709551615
rocksdb.total-sst-files-size93752435021
rocksdb.live-sst-files-size93752435021
rocksdb.base-level1
rocksdb.estimate-pending-compaction-bytes0
rocksdb.actual-delayed-write-rate0
rocksdb.is-write-stopped0
rocksdb.block-cache-capacity536870912
rocksdb.block-cache-usage88
rocksdb.block-cache-pinned-usage88
rocksdb
cfstats
no
file
histogram
** Compaction Stats [default] ** Run   0 , Wait   1 , MemTable  365.001 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): 3440271.2 total, 3440271.2 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: 229349 last_copies: 1 last_secs: 5.7e-05 secs_since: 9
Block cache entry stats(count,size,portion): Misc(1,0.00 KB,0%)
rocksdb
dbstats
** DB Stats **
Uptime(secs): 3440271.2 total, 16.0 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, 297214375.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: 685 writes, 14K keys, 685 commit groups, 1.0 writes per commit group, ingest: 4.80 MB, 0.30 MB/s
Interval WAL: 685 writes, 0 syncs, 685.00 writes per sync, written: 0.00 GB, 0.30 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

Name♻FileSize(GB)EntriesBZipSize(GB)RawSize(GB)ZipRatio(Zip/Raw)AvgKeyAvgValueZip
Algo		Smallest
SeqNum		Largest
SeqNum		Co
Pr		Smallest KeyLargest KeyFileTimeAvg File
Zip Size		Avg File
Raw Size
ZipRawAllDMRKeyValueK/KTVKeyValueK/KTVKeyValueKTVZipRawZipRawUserKeySeqTUserKeySeqT
L2500.0708640.21620022385600050.0016870.0670022.5%0.0041700.2120301.9%40.5%31.6%31.8%8.120.0321.41017.0FlatZip197532004943197539148051018265:8000000180000419197536442556118265:8000012C8001813B19753825301112024-10-18 14:08:2413.945 MiB44.278 MiB
L3400.0085180.0199746412001520500040.0028480.00566033.5%0.0143320.00564271.8%19.9%100.3%42.6%4.824.09.59.4FlatZip197532004849197539148036018261:8000005F8000000180333ADE197532005894718262:800000F88000000A8035590519753914062112024-10-18 14:08:271.729 MiB5.113 MiB
L41100.1368160.4346813375853000110.0154170.11784511.6%0.0881870.34649520.3%17.5%34.0%30.7%4.928.037.5110.2FlatZip=10
SngFast=1		197532004851197539148066018259:80000107800000058000008C197538740442118290:800000F88000000A803559058000000619753914063612024-10-18 14:08:2311.564 MiB40.465 MiB
L51100.0464040.07274165448315205000110.0025240.0432925.5%0.0152810.05746021.0%16.5%75.3%63.0%4.125.171.094.3FlatZip=5
TooZip=6		0197539148034018257:8000005F197539147227118269:0000000008500F97012024-10-18 13:20:064.121 MiB6.771 MiB
L6968087.051158352.889710517988000700096816.21028268.83156819.1%131.120867221.76884237.2%12.4%31.0%24.1%3.427.214.346.0TooZip0008990:8000000100000000000000010118290:800000FF8000000A800960C98000000E012024-09-13 21:35:4889.962 MiB373.305 MiB
sum999087.313759353.63330651847753993041000099916.23275769.06536719.0%131.242836222.39046937.1%12.4%31.1%24.1%3.427.214.346.1FlatZip=24
SngFast=1
TooZip=974		019753914806608990:8000000100000000000000010118290:800000FF8000000A800960C98000000E012024-09-13 21:35:4887.419 MiB362.483 MiB

url param per_level is 1 but there is no any compacting sst