Hello all,
I have the following environment:
Zabbix Server + mySQL DataBase + Zabbix FrontEnd = 8 GB RAM, 8 CPU Cores --> All in the same Virtual Server.
Hosts: ~70
PROBLEM:
I am facing a High CPU Utilization for Zabbix Server and we figured out the mySQL is running sometimes on 150%... 180%.... This is causing Performance Issues on the Front End, sometimes the DashBoard doesn't load or it takes many minutes... sometimes Front End goes down and return back alone after some hours.... It's random. I've already applied Housekeeper for 30 days only. No sucessful.
Then, I searched around and changed the "/etc/my.cnf.d" and put the following commands to improve DB Performance:
# === InnoDB Settings ===
default_storage_engine=InnoDB
innodb_buffer_pool_instances= 4
innodb_buffer_pool_size= 4G
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=0
innodb_flush_method=O_DIRECT
innodb_log_buffer_size=16M
innodb_log_file_size=1G
innodb_stats_on_metadata=0
innodb_read_io_threads=64
innodb_write_io_threads=64
tmpdir=/tmp
# === Buffer Settings ===
innodb_sort_buffer_size=2M
join_buffer_size=4M
read_buffer_size=3M
read_rnd_buffer_size=4M
sort_buffer_size=4M
-------------------------------------------------------------------------
Even applying settings above for DB performance, no sucessful. Then I started searching for some improving on "/etc/zabbix/zabbix_server.conf" then I figured out the lines below maybe could help me, but I have NO idea what to insert.
Could some Expert help me to fill out the lines below the better value for my environment? I really don't know what else I can do. THANKS A LOT!
# StartTrappers=
# StartPingers=
# StartDiscoverers=
# StartHTTPPollers=
# StartTimers=
# StartEscalators=
# StartAlerters=
# StartJavaPollers=
# StartVMwareCollectors=
# VMwareFrequency=
# VMwarePerfFrequency=
# VMwareCacheSize=
# VMwareTimeout=
# SNMPTrapperFile=/var/log/snmptrap/snmptrap.log
# StartSNMPTrapper=
# HousekeepingFrequency=
# MaxHousekeeperDelete=
CacheSize=32M
# CacheUpdateFrequency=
# StartDBSyncers=
# HistoryCacheSize=
# HistoryIndexCacheSize=
# TrendCacheSize=
# ValueCacheSize=
Timeout=4
# TrapperTimeout=
# UnreachablePeriod=
# UnavailableDelay=
# UnreachableDelay=
LogSlowQueries=3000
# StartProxyPollers=
# ProxyConfigFrequency=
# ProxyDataFrequency=
# StartLLDProcessors=
StatsAllowedIP=127.0.0.1
I have the following environment:
Zabbix Server + mySQL DataBase + Zabbix FrontEnd = 8 GB RAM, 8 CPU Cores --> All in the same Virtual Server.
Hosts: ~70
PROBLEM:
I am facing a High CPU Utilization for Zabbix Server and we figured out the mySQL is running sometimes on 150%... 180%.... This is causing Performance Issues on the Front End, sometimes the DashBoard doesn't load or it takes many minutes... sometimes Front End goes down and return back alone after some hours.... It's random. I've already applied Housekeeper for 30 days only. No sucessful.
Then, I searched around and changed the "/etc/my.cnf.d" and put the following commands to improve DB Performance:
# === InnoDB Settings ===
default_storage_engine=InnoDB
innodb_buffer_pool_instances= 4
innodb_buffer_pool_size= 4G
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=0
innodb_flush_method=O_DIRECT
innodb_log_buffer_size=16M
innodb_log_file_size=1G
innodb_stats_on_metadata=0
innodb_read_io_threads=64
innodb_write_io_threads=64
tmpdir=/tmp
# === Buffer Settings ===
innodb_sort_buffer_size=2M
join_buffer_size=4M
read_buffer_size=3M
read_rnd_buffer_size=4M
sort_buffer_size=4M
-------------------------------------------------------------------------
Even applying settings above for DB performance, no sucessful. Then I started searching for some improving on "/etc/zabbix/zabbix_server.conf" then I figured out the lines below maybe could help me, but I have NO idea what to insert.
Could some Expert help me to fill out the lines below the better value for my environment? I really don't know what else I can do. THANKS A LOT!
# StartTrappers=
# StartPingers=
# StartDiscoverers=
# StartHTTPPollers=
# StartTimers=
# StartEscalators=
# StartAlerters=
# StartJavaPollers=
# StartVMwareCollectors=
# VMwareFrequency=
# VMwarePerfFrequency=
# VMwareCacheSize=
# VMwareTimeout=
# SNMPTrapperFile=/var/log/snmptrap/snmptrap.log
# StartSNMPTrapper=
# HousekeepingFrequency=
# MaxHousekeeperDelete=
CacheSize=32M
# CacheUpdateFrequency=
# StartDBSyncers=
# HistoryCacheSize=
# HistoryIndexCacheSize=
# TrendCacheSize=
# ValueCacheSize=
Timeout=4
# TrapperTimeout=
# UnreachablePeriod=
# UnavailableDelay=
# UnreachableDelay=
LogSlowQueries=3000
# StartProxyPollers=
# ProxyConfigFrequency=
# ProxyDataFrequency=
# StartLLDProcessors=
StatsAllowedIP=127.0.0.1
Comment