Ubuntu size: Difference between revisions

Latest revision as of 09:07, 22 December 2023

df -h

du -sk * | sort -nr | head -10

du -hs directory/*

du -h directory/*

du -ah Directory/*

journalctl --disk-usage

journalctl --vacuum-time=10d

lsof /var/lib/my

mysql -u root -p

SHOW BINARY LOGS;

PURGE BINARY LOGS BEFORE now();

use zabbix

DELETE FROM table ORDER BY the field DESC|ASC limit 100

delete from auditlog limit 100000;

delete from history limit 100000;

delete from history_uint limit 100000;

delete from history_text limit 10000;

@@ Line 9: / Line 9: @@
 du -ah Directory/*
+journalctl --disk-usage
 journalctl --vacuum-time=10d
-lsof /var/lib/mysql/zabbix/*.ibd
+lsof /var/lib/my
-mysql   -u  root   -p
+mysql -u root -p
+ SHOW BINARY LOGS;
+ PURGE BINARY LOGS BEFORE now();
 use zabbix
-delete from auditlog;
-delete from history_text;
+DELETE FROM table ORDER BY the field DESC|ASC limit 100
+delete from auditlog limit 100000;
+delete from history limit 100000;
-delete from history_uint;
+delete from history_uint limit 100000;
-delete from history;
+delete from history_text limit 10000;