It appears that housekeeper isn't cleaning up as efficiently as needed. We have found lots of history data over a year old, and decided to write a python script that would audit items and clear out their older history, preferably verifying the valid trend data first. As I was going through that process I noticed a discrepancy between the dashboard and the data in the items table.
Here is what the dashboard has to say about us:
Number of hosts (monitored/not monitored/templates) 1467 1132 / 138 / 197
Number of items (monitored/disabled/not supported) 72036 51171 / 19344 / 1521
Number of triggers (enabled/disabled)[problem/unknown/ok] 29068 26017 / 3051 [72 / 1739 / 24206]
Number of users (online) 118 15
Required server performance, new values per second 531.01
then> select DISTINCT status, count(1) from items group by status;
+--------+----------+
| status | count(1) |
+--------+----------+
| 0 | 59852 |
| 1 | 21055 |
| 3 | 1961 |
+--------+----------+
3 rows in set (0.36 sec)
does anyone know why this may be?
Here is what the dashboard has to say about us:
Number of hosts (monitored/not monitored/templates) 1467 1132 / 138 / 197
Number of items (monitored/disabled/not supported) 72036 51171 / 19344 / 1521
Number of triggers (enabled/disabled)[problem/unknown/ok] 29068 26017 / 3051 [72 / 1739 / 24206]
Number of users (online) 118 15
Required server performance, new values per second 531.01
then> select DISTINCT status, count(1) from items group by status;
+--------+----------+
| status | count(1) |
+--------+----------+
| 0 | 59852 |
| 1 | 21055 |
| 3 | 1961 |
+--------+----------+
3 rows in set (0.36 sec)
does anyone know why this may be?