Ubuntu size: Difference between revisions

From wiki karavi
Jump to navigation Jump to search
No edit summary
No edit summary
 
(One intermediate revision by the same user not shown)
Line 16: Line 16:


lsof /var/lib/my
lsof /var/lib/my
mysql -u root -p
SHOW BINARY LOGS;
PURGE BINARY LOGS BEFORE now();
use zabbix
use zabbix


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

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;