Why is my housekeeper table empty? 3.0 zabbix
I've set a limit of 5000 delete but it's deleting more than that. If the limit is for housekeeper table, then mine is empty.
Once in a week or so I lose all history except for that day (that too for upto last few hours). Trends are available when I check for 7 days or above and it shows till date.
Current settings, 7 days item history and 365 days trends. So it should delete history older than 7 days?
Every hour housekeeper deletes 11000 rows.
Here's this one deleting 20k rows.
20160911:143833 executing housekeeper
20160911:143837 slow query: 3 sec, "select itemid,min(clock) from history_str group by itemid" -> 900 rows
20160911:143848 slow query: 11 sec, "select itemid,min(clock) from history_uint group by itemid" -> 6000 rows
20160911:143952 slow query: 62 sec, "select itemid,min(clock) from trends group by itemid" -> 3000 rows
20160911:144153 slow query: 120 sec, "select itemid,min(clock) from trends_uint group by itemid" -> 10k rows
20160911:144227 housekeeper [deleted 20573 hist/trends, 0 items, 0 events, 0 sessions, 0 alarms, 0 audit items in 233.621476 sec, idle for 1
20160911:144714 slow query: 5 sec, "commit;"
# The table "housekeeper" contains "tasks" for housekeeping procedure in the format:
# [housekeeperid], [tablename], [field], [value].
# No more than 'MaxHousekeeperDelete' rows (corresponding to [tablename], [field], [value])
# will be deleted per one task in one housekeeping cycle.
Happens once a while, all of a sudden history vanishes.
History
Trends
I've set a limit of 5000 delete but it's deleting more than that. If the limit is for housekeeper table, then mine is empty.
Once in a week or so I lose all history except for that day (that too for upto last few hours). Trends are available when I check for 7 days or above and it shows till date.
Current settings, 7 days item history and 365 days trends. So it should delete history older than 7 days?
Every hour housekeeper deletes 11000 rows.
Here's this one deleting 20k rows.
20160911:143833 executing housekeeper
20160911:143837 slow query: 3 sec, "select itemid,min(clock) from history_str group by itemid" -> 900 rows
20160911:143848 slow query: 11 sec, "select itemid,min(clock) from history_uint group by itemid" -> 6000 rows
20160911:143952 slow query: 62 sec, "select itemid,min(clock) from trends group by itemid" -> 3000 rows
20160911:144153 slow query: 120 sec, "select itemid,min(clock) from trends_uint group by itemid" -> 10k rows
20160911:144227 housekeeper [deleted 20573 hist/trends, 0 items, 0 events, 0 sessions, 0 alarms, 0 audit items in 233.621476 sec, idle for 1
20160911:144714 slow query: 5 sec, "commit;"
# The table "housekeeper" contains "tasks" for housekeeping procedure in the format:
# [housekeeperid], [tablename], [field], [value].
# No more than 'MaxHousekeeperDelete' rows (corresponding to [tablename], [field], [value])
# will be deleted per one task in one housekeeping cycle.
Happens once a while, all of a sudden history vanishes.
History
Trends
Comment