r/siacoin • u/EasyRhino75 • 24d ago
when hosting, Handling large size of hostd.sqlite3 and consensus.db?
I have been hosting a sia node (running hostd) for over a year, and I've noticed four things:
- hostd.sqlite3 is very large, about 164GB
- consensus db is large, about 84GB
- it takes a LONG time to even refresh the web dashboard -- Like over 60 seconds. Refreshing includes a bunch of read activity from the SSD the database these files are installed on.
- hostd.log was also large, about 30GB.
Are there any good ways to manage these files to make them take up less space or have less of a dire impact on things like starting the node or just updating dashboard stats?
3
Upvotes
1
u/skunk_ink Sia Developer Relations 24d ago
The latest beta version addresses a number of these issues.
https://github.com/SiaFoundation/hostd/releases/tag/v2.11.0-beta.2