twarnick
24-09-2004, 11:58
Can i set a new start date for the statistics calculation ?
(I want to skip the "unknown" period).
I'm not sure what you mean. You may delete everything from tables alerts, alarms, history, history_str, service_alarms and trends to get rid of collected information. This will not affect configuration of ZABBIX.
The following steps have to be performed:
Stop ZABBIX
Delete everything from mentioned tables (use MySQL truncate table <table> statement to do it fast)
Start ZABBIX
jhmartin
04-07-2006, 00:06
Note that under InnoDB, a truncate table is implemented the same as a delete, so it is *not* fast, and cancelling it halfway through causes it to roll back, also not fast.