Help on cleaning up the database

[burn1024]

Our database seems to be growing too quick, and so we decided to have some serious cleanup:
1) disable most triggers that come by default (/vmlinuz size, "Configured max number of opened files", etc)
2) set larger update intervals for all items
3) disable all items that are not used in any triggers
4) clear history and trends for all disabled items

The question is - how do I perform 3) and 4) without spending 2 days in Zabbix WebUI?

We're using Zabbix 1.8.1 with Postgresql 8.4.17.

[burn1024]

Just for the record:
1-3) Done manually, it turned out to be quick.

4)

delete FROM alerts where age(to_timestamp(alerts.clock)) > interval '7 days';

delete FROM acknowledges where age(to_timestamp(acknowledges.clock)) > interval '7 days';

delete FROM events where age(to_timestamp(events.clock)) > interval '7 days';

delete FROM history where age(to_timestamp(history.clock)) > interval '7 days';
delete FROM history_uint where age(to_timestamp(history_uint.clock)) > interval '7 days' ;
delete FROM history_str  where age(to_timestamp(history_str.clock)) > interval '7 days' ;
delete FROM history_text where age(to_timestamp(history_text.clock)) > interval '7 days' ;
delete FROM history_log where age(to_timestamp(history_log.clock)) > interval '7 days' ;

delete FROM trends where age(to_timestamp(trends.clock)) > interval '90 days';
delete FROM trends_uint where age(to_timestamp(trends_uint.clock)) > interval '90 days' ;

delete from history where itemid not in (select itemid from items where status='0');
delete from history_uint where itemid not in (select itemid from items where status='0');
delete from history_str where itemid not in (select itemid from items where status='0');
delete from history_text where itemid not in (select itemid from items where status='0');
delete from history_log where itemid not in (select itemid from items where status='0');

delete from trends where itemid not in (select itemid from items where status='0');
delete from trends_uint where itemid not in (select itemid from items where status='0');

and also applied https://github.com/mattiasgeniar/zab...d-data-cleanup

[barbaros]

and also applied https://github.com/mattiasgeniar/zab...d-data-cleanup

Does those scripts work for PostgreSQL?

[burn1024]

Does those scripts work for PostgreSQL?

yes.

P.S. let the admin who configured "your message is too short" for this forum rot in hell.

[barbaros]

Didn't you have any problems with Zabbix after manual data deleting?

[burn1024]

No, why would I?

[barbaros]

Sometimes manual intervention brokes things . Good to know everything went well, I am going to do the same operation on my DB.

[barbaros]

"select itemid from items where status='0'" means disabled items?

[burn1024]

No it means enabled.

[barbaros]

Yes, I've meant enabled, sorry . THX.