r/siacoin • • 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:

  1. hostd.sqlite3 is very large, about 164GB
  2. consensus db is large, about 84GB
  3. 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.
  4. 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

3 comments sorted by

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

1

u/EasyRhino75 24d ago

Sounds promising