Hi, I have a massive DB that needs pruning. I've already gone through all hosts on the template level and reduced history and trends down, along with increasing intervals, so that the DB is no longer growing much anymore.
However I want to remove the 120 odd GB of history stored mostly in the history and history_uint tables. So is it safe to just go ahead and truncate them? Will it break anything?
DB = MyDQL, innodb single ibdata1 file
Zabbix = 2.0.12
+-----------------------+------------+
| Tables | Size in MB |
+-----------------------+------------+
| history_uint | 103806.27 |
| history | 24841.17 |
| trends | 7309.44 |
| history_text | 6047.63 |
| trends_uint | 5430.64 |
| history_str | 2426.39 |
Thanks in advance!
However I want to remove the 120 odd GB of history stored mostly in the history and history_uint tables. So is it safe to just go ahead and truncate them? Will it break anything?
DB = MyDQL, innodb single ibdata1 file
Zabbix = 2.0.12
+-----------------------+------------+
| Tables | Size in MB |
+-----------------------+------------+
| history_uint | 103806.27 |
| history | 24841.17 |
| trends | 7309.44 |
| history_text | 6047.63 |
| trends_uint | 5430.64 |
| history_str | 2426.39 |
Thanks in advance!