Pruning Zabbix Historical Tables in MySQL/MariaDB to Reclaim Disk Space
Measure storage use in the Zabbix schema Identify which tables consume the most space before pruning. SELECT t.table_name AS tbl, ROUND((t.data_length + t.index_length) / 1024 / 1024, 2) AS size_mb FROM information_schema.tables AS t WHERE t.table_schema = 'zabbix' ORDER BY size_mb DESC; Large footp...