Re: [Zabbix-users] How to shrink history tables

[Javi L. <ja...@le...>]

Hi there.

More details regarding my items:

+----------+
| count(*) |
+----------+
|     5373 |
+----------+

And its frequency:

+-------+----------+
| delay | count(*) |
+-------+----------+
|    60 |        6 |
|   300 |     3776 |
|   600 |       19 |
|  3600 |     1572 |
+-------+----------+

Regards.

Javier Legido

On 10 April 2014 11:46, Javi Legido <ja...@le...> wrote:
> Hi there.
>
> I have huge history tables, and apparently housekeeper should be able
> to delete old values. I think is not hitting 'MaxHousekeeperDelete'
> limit, but maybe there's something else that I missing.
>
> Details below. Any help will be appreciated.
>
> Thanks.
>
> Zabbix version: 2.2.3
> Database: MySQL (mysql-server 5.5.29-0ubuntu0.12.10.1)
>
> a) Big history tables
>
> +-----------------------+------------+
> | Tables                | Size in MB |
> +-----------------------+------------+
> | history_uint          |   26414.03 |
> | history_text          |    8242.33 |
> | history_str           |    7800.95 |
> | history               |     943.95 |
> | trends_uint           |     741.89 |
> | trends                |      96.69 |
> | events                |      36.61 |
> | alerts                |       6.52 |
> | items                 |       5.41 |
> | housekeeper           |       2.02 |
> | images                |       1.53 |
>
> b) Housekeeper is enabled, running on a hourly basis, and removing
> 770K rows per hour on average:
>
>  25523:20140410:071819.202 housekeeper [deleted 793674 hist/trends,
> 1058500 items, 0 event
> s, 0 sessions, 0 alarms, 0 audit items in 1471.965338 sec, idle 1 hour(s)]
>  25523:20140410:081819.202 executing housekeeper
>  25523:20140410:084252.341 housekeeper [deleted 793043 hist/trends,
> 1058500 items, 0 event
> s, 0 sessions, 0 alarms, 0 audit items in 1473.132870 sec, idle 1 hour(s)]
>  25523:20140410:094252.342 executing housekeeper
>  25523:20140410:100804.955 housekeeper [deleted 770397 hist/trends,
> 1058500 items, 0 events, 0 sessions, 0 alarms, 0 audit items in
> 1512.607778 sec, idle 1 hour(s)]
>
> c) Housekeeper config (server)
>
> None, all of them commented out, so assuming zabbix is taking default values
>
> d) Housekeeper config (GUI > Administration > General > Housekeeping)
>
> Checked only below settings:
>
> History
> Enable internal housekeeping
>
> e) All items history should be kept just for 7 days
>
> +---------+----------+
> | history | count(*) |
> +---------+----------+
> |       7 |     5373 |
> +---------+----------+
>
> Javier Legido