Archive old data

[mario.almeida]

Hi All,

How would I archive 5 months old data from db (mysql)?

[nelsonab]

If you're looking for your trend data which is older than 5 months you will do something like the following: (mysql)

select * from trends where clock<UNIXTIME((now() - INTERVAL 5 MONTHS)); That

will should pull all data from the trends table which is older than 5 months. There is a second trends table trends_uint. The history tables should only contain data up to the time set in the item's configuration history retention time.

Hope that helps.

[mario.almeida]

SELECT * from trends where clock<=UNIX_TIMESTAMP(NOW() - INTERVAL 5 MONTH) LIMIT 10;

The query you gave above do not show much data.

Actual disk space utilize by zabbix database is 21GB. I have limited space need to purge some old data in a sql file.

how to find which table is with more space.

[zabbix_zen]

Hi / Olá.

The trends table as the name suggests keeps only the trends(hourly averages of your gathered data).

To easily find the largest tables why don't you try accessing the DB using a GUI tool like HeidiSQL or MySQL-Admin?

Anyways,
the largest ones will be history, history_uint and events.
Remember you shouldn't mess with the DB without being sure what you're doing.
You can also tweak how long Zabbix will keep each items data when creating/configuring them typing your intended
'Keep history (in days)' and
'Keep trends (in days)'