fail2ban.sqlite3 занимает много места

find / -type f -size +10000k -exec ls -lh {} \; | awk '{print $5 ": " $NF}'f | sort -n

1.1G: /var/lib/fail2ban/fail2ban.sqlite3

Оказалось что база весит больше 1Гб.

Трём записи:

sqlite3 /var/lib/fail2ban/fail2ban.sqlite3 "DELETE FROM bans WHERE DATE(timeofban, 'unixepoch') < '2022-03-23'; VACUUM;"

Заняла операция примерно 30 секунд. Довольно сильно грузила процессор. Но теперь база весит очень мало.

Обратная связь

    The average number of adverse effects was 3. T max is 23 minutes in females and 32 minutes in males. What other drugs will affect doxercalciferol Viagra natural sin receta. Archived from the original on 2009-08-14.

    Talk to your doctor before using this form of cefadroxil if you have diabetes. What should I tell my healthcare team before starting CABLIVI? There is no FDA guidance on the use of Tetracycline (oral) with respect to specific gender populations https://www.apotheke-rezeptfreie.com/. Opper K, Uder S, Song K Development of Heterogeneous and Homogeneous Platforms for Rapid Analysis of DNA-Protein Interactions.