Server Running Out of Space - Urgent

[mcnealjs]

Hello Everyone,

I am totally new to Zabbix and I have a server that is running out of space in a virtual environment. I have tried to increase the drive space but it is not letting me. I was wondering if there is anyway I could do some tuning so the Database doesn't keep growing all the time. I am using Ubuntu 12.04 and Zabbix 2.02. Any help would be much appreciated as I only have 727m left on the drive.

Thanks,
Jeff
[email protected]

[ingus.vilnis]

Hello and welcome!

It would be great to know also the status of your Zabbix environment (The first section of your monitoring dashboard) and the database engine you are using (MySQL or Postgre or else) so that we could give you more appropriate clues on what would be the best solution in your situation.

Zabbix has its own Housekeeping process which removes old data from database. It can be configured in Administration -> General -> Housekeeping (top right dropdown menu)
Make sure Housekeeper is enabled and set the data storage period to some reasonable time you want to keep the history. You can read more info about it in documentation here: https://www.zabbix.com/documentation...ration/general

Housekeeper process will run then every hour by default but you can check that in Zabbix server configuration file. On your system it could be located in /etc/zabbix/zabbix_server.conf

Take a look at the following parameters there:

HousekeepingFrequency=1
MaxHousekeeperDelete=500

Frequency set to 1 means that it will run once every hour.
MaxHousekeeperDelete sets amount of lines deleted by every run.

(!) Please use these settings with caution if these are your first steps in Zabbix.

If you change anything in the config file, make sure you restart your zabbix server process to apply the changes.

service zabbix-server restart

Hope this helps!
Best Regards,
Ingus

[mcnealjs]

Update

Thanks for the information and I have turned the housekeeper service on but it still seems as my space is going down. I am using MySQL. The zabbix environment is we have a central server and then I have about 30 proxies reporting back to the main server. Everything seemed to be running fine and then it is like things have gone crazy with space issues. I just turned on the housekeeper service last evening but it does seem like it is working.

[jan.garaj]

Note about MySql:
When housekeeper removes rows, they are just marked as deleted on disk but space will be consumed by InnoDB files which can be re-used later when you insert/update more rows but it will never shrink.
Check http://www.mysqlperformanceblog.com/...r_table-is-on/ how to release unused InnoDB file space.