#speicherplatz

$truncate -s 0 -- /var/www/vhosts/example.com/logs/error_log

#plesk bin subscription --info example.com

#mysql -e 'SELECT table_schema, table_name, ROUND((data_length + index_length) / 1024 / 1024, 1) AS mb, table_rows FROM information_schema.tables ORDER BY data_length + index_length DESC LIMIT 20;'

#docker system prune

$df -hT -x tmpfs -x devtmpfs -x squashfs

#lsof -nP +L1

$find /var/www/vhosts/example.com/httpdocs/wp-content/uploads -type f -iname '*.mp4' -printf '%s\n' | awk '{s+=$1; n++} END {printf "%d Dateien, %.1f MB\n", n, s/1048576}'

#mysql -e 'SELECT table_schema AS db, ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) AS mb FROM information_schema.tables GROUP BY table_schema ORDER BY mb DESC;'

$du -xh -d 1 /var/www/vhosts 2>/dev/null | sort -rh | head -20

$wp db size --tables --path=/var/www/vhosts/example.com/httpdocs

#mkdir -p /etc/systemd/journald.conf.d && printf '[Journal]\nSystemMaxUse=500M\n' > /etc/systemd/journald.conf.d/size.conf && systemctl restart systemd-journald

$git rev-list --objects --all | git cat-file --batch-check='%(objecttype) %(objectname) %(objectsize) %(rest)' | awk '$1=="blob"' | sort -k3 -rn | head -n 20

$find /var/www/vhosts -type f -size +500M -exec ls -lh {} + 2>/dev/null | sort -k5 -rh | head -20

#du -ah /var/log 2>/dev/null | sort -rh | head -20

#du -sh /var/cache/apt/archives && apt clean

$df -ih -x tmpfs -x devtmpfs -x squashfs

$dpkg-query -Wf '${Installed-Size}\t${Package}\n' | sort -rn | head -n 20

#logrotate -vf /etc/logrotate.d/nginx

#docker ps -a --size

#journalctl --disk-usage

$ncdu -x /var

#docker system df -v

#du -sh /var/www/vhosts/*/ 2>/dev/null | sort -rh | head -20

#du -sh /var/qmail/mailnames/*/ 2>/dev/null | sort -rh | head -20

#journalctl --vacuum-size=500M

#docker image prune