-
Type:
Incident report
-
Resolution: Won't fix
-
Priority:
Blocker
-
None
-
Affects Version/s: None
-
Component/s: Server (S)
-
None
Hi,
We have a Zabbix software monitoring tool in our environment, and the main problem is the large size of tables of Zabbix sever database.
Zabbix Server machine:
zabbix-web-mysql-3.0.2-1.el7.noarch
zabbix-release-3.0-1.el7.noarch
zabbix-web-3.0.2-1.el7.noarch
zabbix-agent-3.0.2-1.el7.x86_64
zabbix-server-mysql-3.0.2-1.el7.x86_64
zabbix-java-gateway-3.0.2-1.el7.x86_64
Zabbix sever database(PROBLEM):
Mysql Ver 14.14 Distrib 5.6.29, for linux-glibc2.5 (x86_64) using EditLine wrapper
zabbix-release-3.0-1.el7.noarch
zabbix-2.4.3-1.el7.x86_64
zabbix-agent-2.4.3-1.el7.x86_64
The main problem is the size of these tables.
rw-r---- 1 mysql mysql 5,3G ago 19 12:30 trends.ibd
rw-r---- 1 mysql mysql 2,1G ago 19 12:40 events.ibd
rw-r---- 1 mysql mysql 6,6G ago 19 12:40 trends_uint.ibd
rw-r---- 1 mysql mysql 5,1G ago 19 12:40 history_str.ibd
rw-r---- 1 mysql mysql 47G ago 19 12:40 history.ibd
rw-r---- 1 mysql mysql 124G ago 19 12:40 history_uint.ibd
Now we are saving for each item:
History storage period (in days) : 15
Trend storage period (in days) : 365
Attach screenshot of Housekeeping configuration.
Attach configs Server Zabbix.
Attach zabbix_server.log
We need to clean or reduce this space as soon as possible.
Could you help us to solve this problem?
Our Zabbix infrastructure:
Zabbix Server
Hostname = zabbix(Server Service)
IP Address = 172.X.X.161
OS = CentOS 7.x
CPU = 8 vCPUs
Memory = 8 Gb
HD = 50 Gb
Database Server
Hostname = zabbixdb
IP Address = 172.X.X.162
OS = CentOS 7.x
CPU = 12 vCPUs
Memory = 32 Gb
HD = 220 Gb
Proxies Servers (5 servers)
Hostname = proxyzabbix01-05
IP Address = 172.X.X.X (.184, .185, .186, .187, .188)
OS = CentOS 7.x
CPU = 8 vCPUs
Memory = 8Gb
HD = 50Gb
If you need more information, we will send it to you.
Regards