Zabbix 3.2 events table partitioning

[sperr0w]

Hello!

About month ago, I update my zabbix to 3.2.2 version.
After update, I find problem connected to events table.

I have ia big installation with 7000+ NVPS.
housekeeprer in my installation it is switched of for trend and history data, but I use housekeeper to clean events data.

After update to 3.2 version, I housekeeper is 100% busy. also on my Oracle DB I see that in top of queries I have Insert and delete query to events table.

May be somebody know, what changes in vession 3.2.2?
Also, may be it is possible to create partitions in events table of zabbix database on Oracle?
Right now it is not possible, because of foreint key on this table.

[kloczek]

I have ia big installation with 7000+ NVPS.

Flow of new entries to events table will be affected mainly by factor (number_of_triggers/number_of_items)*NVPS.
Because many of the triggers changes values are affected by more or less well designed triggers dependencies and avg number of issues causing triggers changes you may probably expect not more than few evens/s. In worse case scenario (like "sex in the office" when everything is f*king around) such flow of events can be raised by factor 10-100 or a bit more .. so even with such bigger flow of new events partitioning events table is usually a bit pointless.

In other words: how much is growing your events table ~daily?

[sperr0w]

Could somebody just reply me, how to partitioning Events table in Oracle?

There is problem connected with that fact, that there is no `clock` field in default index. If we rebuild index on this table and include clock in default index, it creates problems while update zabbix server to new version process.

I hope, that somebody alredy faced with this problem.

My housekeeper spend a lot of time with events table cleaning somewhy.

My events table grow about 200000 rows per day.

but query to get count of events table rows for last day spent about 200 sec.

[sperr0w]

May be somebody have sql procedures to create full partitioning on zabbix database 3.2 on Oracle to disable housekeeper totally in zabbix server config?

[13957959920]

hi,the problem is resolevd ?can you share the answer?

[emz]

I am also interested to know whether a partitioning of the events table is possible but for Zabbix v3.0.

[kloczek]

As same as on MySQL it is possible to reuse the procedure to partition history/trends tables to partition events table. In all three cases (history*, trends* and events tables) table will be partitioned on range base using clock row content.
Exactly the same approach can be used on last possible to partition tables audit*.
Nevertheless if someone is thinking that he/she needs to partition events table I'm almost sure in such cases that it means that number of alarms switching state is somehow to big which as consequence means that something is wrong with triggers definitions (mainly lack of dependencies between triggers but lack of defined hysteresis maybe the second issue).

[razielleiizar]

As kloczek notised, high events rate should be assumed as weird. I faced that problem, i have had ~1400\min. I analyze 5 second interval of events table and found, that ~95% of events had source = 2 and object= 3. According to this documentation: https://www.zabbix.com/documentation...e/event/object it was event of host autoregistration. After i turned off all autoregistration actions my events rate droped to 15\min.