Tuning Zabbix Server Part II

Server on VM with spesification : 4vcpu and 4GB RAM 30 GB data

Edit in /etc/zabbix/zabbix_server.conf

DebugLevel=2

StartPollers=30
StartIPMIPollers=2
StartPreprocessors=20
StartPollersUnreachable=10
StartTrappers=5
StartPingers=10
StartDiscoverers=2
StartHTTPPollers=10
StartTimers=3
StartAlerters=2
StartJavaPollers=2
StartVMwareCollectors=2

VMwareFrequency=21600
VMwarePerfFrequency=21600
VMwareCacheSize=512M
VMwareTimeout=10

StartSNMPTrapper=1

HousekeepingFrequency=2

CacheSize=1G
CacheUpdateFrequency=60
StartDBSyncers=4
HistoryCacheSize=256M
HistoryIndexCacheSize=256M
TrendCacheSize=256M
ValueCacheSize=512M
Timeout=10
TrapperTimeout=30
LogSlowQueries=3000
StartProxyPollers=0
DBName=xxxxxx
DBUser=xxxxxx
DBPassword=xxxxxx


JavaGateway=127.0.0.1
JavaGatewayPort=10052

LogType=file
LogFileSize=1
LogFile=/var/log/zabbix/zabbix_server.log
PidFile=/run/zabbix/zabbix_server.pid
SocketDir=/run/zabbix

FpingLocation=/usr/bin/fping
Fping6Location=/usr/bin/fping6

StatsAllowedIP=127.0.0.1
EnableGlobalScripts=0

Edit mariadb : /etc/mysql/mariadb.conf.d/50-server.cnf

[server]

[mysqld]
innodb_buffer_pool_size = 2G
innodb_buffer_pool_instances = 2
innodb_log_file_size = 512M
innodb_flush_log_at_trx_commit = 2
innodb_file_per_table = 1
innodb_flush_method = O_DIRECT
innodb_log_buffer_size = 64M
innodb_io_capacity = 500
innodb_io_capacity_max = 1000

max_connections = 200
table_open_cache = 4096
thread_cache_size = 100
query_cache_type = 0
query_cache_size = 0
join_buffer_size = 128M
sort_buffer_size = 4M
tmp_table_size = 64M
max_heap_table_size = 64M

slow_query_log = 1
slow_query_log_file = /var/log/mysql/slow.log
long_query_time = 2
log_queries_not_using_indexes = 1

key_buffer_size = 16M
max_allowed_packet = 16M
read_buffer_size = 2M
read_rnd_buffer_size = 8M

wait_timeout = 600
interactive_timeout = 600
connect_timeout = 10

open_files_limit   = 16364

pid-file                = /run/mysqld/mysqld.pid
basedir                 = /usr
bind-address            = 127.0.0.1

character-set-server  = utf8mb4
collation-server      = utf8mb4_general_ci

[embedded]
[mariadb]

[mariadb-10.6]

Restart Service

systemctl restart mariadb zabbix-server