2024-11-23 19:44:22 , Up: 1-05:30:08   .rocksdb/LOG

rocksdb
cfstats
no
file
histogram
** Compaction Stats [default] ** Run   7 , Wait   1 , MemTable    4.751 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      315.3     315.3       0.0   1.0      0.0   1778.4      181.57            159.49        631    0.288       0      0         0.0         0.0
  L1     16/7     211.62 MB  209.63 MB    0.1     315.6    315.6       0.0      139.3     139.3       0.0   0.4    933.5    411.9      346.25            574.56        632    0.548    906M   229M         0.0         0.0
  L2      0/0       0.00 KB    0.00 KB    0.0     139.1    139.1       0.0      125.2     125.1       0.0   0.9     53.1     47.8     2681.80            929.08      10369    0.259    676M    12K         0.0         0.0
  L3     70/0       2.45 GB    7.46 GB    1.0    1697.5    125.2    1572.3     1586.1      13.8       0.0  12.7     14.3     13.4   121496.57          43777.74      11267   10.783     27G   282M         0.0         0.0
  L4    468/0      15.80 GB   52.14 GB    1.0      30.5     12.1      18.4       27.1       8.7       1.7   2.2     12.4     11.1     2508.66           1092.24       1163    2.157    915M    66M         0.0         0.0
  L5    365/0      10.56 GB   28.07 GB    0.1       8.4      8.3       0.1        7.9       7.8       2.8   1.0     17.0     15.9      507.52            144.41        263    1.930    122M      0         0.0         0.0
  L6     21/0     545.65 MB    1.43 GB    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
 Sum    940/7      29.55 GB   89.30 GB    0.0    2191.2    600.3    1590.9     2201.0     610.1       4.5   7.0     17.6     17.6   127722.38          46677.53      24325    5.251     29G   578M         0.0         0.0
 Int      0/0       0.00 KB    0.00 KB    0.0    2191.2    600.3    1590.9     2201.0     610.1       4.5   7.0     17.6     17.6   127722.38          46677.53      24325    5.251     29G   578M         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    2191.2    600.3    1590.9     1885.6     294.8       0.0   0.0     17.6     15.1   127540.80          46518.04      23694    5.383     29G   578M         0.0         0.0
High      0/0       0.00 KB    0.00 KB    0.0       0.0      0.0       0.0      315.3     315.3       0.0   0.0      0.0   1778.4      181.57            159.49        631    0.288       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): 106208.2 total, 106208.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 315.346, interval 315.346
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:    2.149373 TB write,   21.22 MB/s write,    2.139814 TB read,   21.13 MB/s read, 127722.4 seconds
Interval   compaction: 2200.957520 GB write,   21.22 MB/s write, 2191.169716 GB read,   21.13 MB/s read, 127722.4 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@0x423b7800#1630268 capacity: 4.00 GB seed: 1080093140 usage: 0.09 KB table_size: 1024 occupancy: 1 collections: 7080 last_copies: 1 last_secs: 5.8e-05 secs_since: 11
Block cache entry stats(count,size,portion): Misc(1,0.00 KB,0%)
rocksdb
dbstats
** DB Stats **
Uptime(secs): 106208.2 total, 321.0 interval
Cumulative writes: 88M writes, 950M keys, 88M commit groups, 1.0 writes per commit group, ingest: 602.03 GB, 5.80 MB/s
Cumulative WAL: 88M writes, 0 syncs, 88168116.00 writes per sync, written: 303.82 GB, 2.93 MB/s
Cumulative stall: 00:00:0.000 H:M:S, 0.0 percent
Interval writes: 245K writes, 2620K keys, 245K commit groups, 1.0 writes per commit group, ingest: 1711.34 MB, 5.33 MB/s
Interval WAL: 245K writes, 0 syncs, 245694.00 writes per sync, written: 0.84 GB, 2.69 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# 25785, file count = 940, total size = 29.554 GiB, avg size = 0.031 GiB      per_level=0   per_level=1   per_level=2

Name♻FileSize(GiB)EntriesBZipSize(GiB)RawSize(GiB)ZipRatio(Zip/Raw)AvgKeyAvgValueZip
Algo		Smallest
SeqNum		Largest
SeqNum		Co
Pr		Smallest KeyLargest KeyFileTimeAvg File
Zip Size		Avg File
Raw Size
ZipRawAllDMRKeyValueK/KTVKeyValueK/KTVKeyValueKTVZipRawZipRawUserKeySeqTUserKeySeqT
L11670.2066590.20472110460815810400160.0273720.17927413.2%0.0256250.17909712.5%106.8%100.1%100.9%28.126.3184.0183.8SngFast422224791442237469030469:8000008942237467491480:8000012A8000000A0180000BB880036E9D422262126112024-11-23 19:44:2112.727 MiB13.102 MiB
L37002.4538087.4570384500992687693000700.2242442.1686269.4%1.1361386.32090015.2%19.7%34.3%32.1%5.327.151.7150.8FlatZip=68
TooZip=2		042222479110469:8000008942222473901480:8000012A8000000A0180000BB8800350BA421501449512024-11-23 14:15:5732.922 MiB109.086 MiB
L4468015.79917252.1387012374537911065712004680.74447514.5910864.9%5.92597146.21273011.4%12.6%31.6%29.4%3.426.866.0209.0FlatZip=55
TooZip=413		042207386470469:8000001932737006471480:8000012A8000000A0180000BB88000BF51405390569212024-11-22 13:03:4732.863 MiB114.081 MiB
L5365010.56119128.0748522069755640003650.30801010.0527123.0%5.06777923.00707318.1%6.1%43.7%36.9%1.626.352.2119.4TooZip000468:1DB91EB51E331C47091DB91C8F1C7A1C7A09020B1D321C8F00000601475:800000F080000007800049B680000007012024-11-22 13:01:4029.067 MiB78.763 MiB
L62100.5328651.42610027000000000210.3015610.23120056.6%1.1995810.22651984.1%25.1%102.1%37.4%12.047.79.29.0TooZip000478:8000000180000001011C471C601D771CAA091C471C601D771CAA091C471C601D771CAA08011C471EFF1E0C1EFF091CAA1E711CAA1D18091C461E330000000004800000DF01480:8000012C8000000A0180000BB8800004BB012024-11-22 13:26:2925.978 MiB69.539 MiB
sum940729.55369589.3014115174853622000746009401.60566227.2228985.6%13.35509375.94631815.0%12.0%35.8%32.3%3.327.756.5157.6FlatZip=123
SngFast=16
TooZip=801		042237469030468:1DB91EB51E331C47091DB91C8F1C7A1C7A09020B1D321C8F00000601480:8000012C8000000A0180000BB8800004BB012024-11-22 13:01:4030.897 MiB97.282 MiB

level = 1, file count = 16, total zip = 0.207 GiB, raw = 0.205 GiB

Name♻FileSize(GiB)EntriesBZipSize(GiB)RawSize(GiB)ZipRatio(Zip/Raw)AvgKeyAvgValueZip
Algo		Smallest
SeqNum		Largest
SeqNum		Co
Pr		Smallest KeyLargest KeyFileTime
ZipRawAllDMRKeyValueK/KTVKeyValueK/KTVKeyValueKTVZipRawZipRawUserKeySeqTUserKeySeqT
277746💡0.0310350.03121423320400010.0059010.02513319.0%0.0060810.02513319.5%97.0%100.0%99.4%27.228.0115.7115.7SngFast422224794842237467466475:80000089800000098001CA348000000642232435181475:8000012A8000000180036FE98000000F422357464112024-11-23 19:44:21
277754💡0.0310350.03121123280600010.0058940.02514119.0%0.0060710.02514119.5%97.1%100.0%99.4%27.228.0116.0116.0SngFast4222247925422374690311475:8000012A8000000180036FEA8000000142235750191475:8000012A8000000A80036D3D8000000C422231202112024-11-23 19:44:21
277755💡0.0019300.0018651410300010.0004310.00149722.4%0.0003680.00149719.7%117.3%100.0%103.4%32.828.0114.0114.0SngFast4222313129422374514214475:8000012A8000000A80036D3E8000000142223131291475:8000012A8000000A800372D580000007422374514212024-11-23 19:44:22
277756💡0.0312230.0308213191400010.0009950.0302273.2%0.0005940.0302271.9%167.4%100.0%101.3%33.520.01017.01017.0SngFast422224799742237466856477:800000018000D25D42227523141477:80000128800005F5422340125412024-11-23 19:44:22
277757💡0.0312220.0308353192900010.0009810.0302413.1%0.0005950.0302411.9%165.0%100.0%101.3%33.020.01017.01017.0SngFast422224794242237468837477:80000128800005F642234844101477:8000012A8000297C422360546912024-11-23 19:44:22
277758💡0.0297590.0294163045900010.0009090.0288493.1%0.0005670.0288491.9%160.3%100.0%101.2%32.120.01017.01017.0SngFast422224796642237468927477:8000012A8000297D42236561151477:8000012C80013824422231759012024-11-23 19:44:22
277759💡0.0023680.00226192481290520010.0022810.00008696.4%0.0022610.000000100.0%100.8%inf%104.7%26.526.31.00.0SngFast422224791542237468796479:8000008980000001008001C7EC42222480707479:8000012A8000000A018000000A800317E9422372908312024-11-23 19:44:22
sum70.2066590.20472110460815810400160.0273720.17927413.2%0.0256250.17909712.5%106.8%100.1%100.9%28.126.3184.0183.8SngFast422224791442237469030469:8000008942237467491480:8000012A8000000A0180000BB880036E9D422262126112024-11-23 19:44:21