Closed jpraynaud closed 6 days ago
The WAL files produced by SQLite are constantly growing whereas the should be truncated automatically:
Example file size on release-mainnet:
release-mainnet
174604288 aggregator.sqlite3 327680 aggregator.sqlite3-shm 163390992 aggregator.sqlite3-wal
Example file size on testing-mainnet:
testing-mainnet
31645708288 cardano-transaction.sqlite3 425984 cardano-transaction.sqlite3-shm 30943029312 cardano-transaction.sqlite3-wal
Make the WAL files automatically truncated.
For signer & aggregator add a (repeating?) task that:
PRAGMA wal_checkpoint(SQLITE_CHECKPOINT_TRUNCATE);
Why
The WAL files produced by SQLite are constantly growing whereas the should be truncated automatically:
Example file size on
release-mainnet
:Example file size on
testing-mainnet
:What
Make the WAL files automatically truncated.
How
For signer & aggregator add a (repeating?) task that:
PRAGMA wal_checkpoint(SQLITE_CHECKPOINT_TRUNCATE);