Hi all,
Recently my zabbix is sending notification so late (as my attachment), not only email but also problems, triggers on web UI, graph data is not up to date too, but it still updating (but late), like I'm monitoring the past :lol: I don't know why, maybe syncer history process (always more than 75%)
I've tuning MySQL, zabbix_server.conf but still problem
Zabbix server was installed on Hyper V machine (2 cores processor, dynamic 2-8G RAM)
Please help! Thank you all!
my.cnf
zabbix_server.cnf
Recently my zabbix is sending notification so late (as my attachment), not only email but also problems, triggers on web UI, graph data is not up to date too, but it still updating (but late), like I'm monitoring the past :lol: I don't know why, maybe syncer history process (always more than 75%)
I've tuning MySQL, zabbix_server.conf but still problem
Zabbix server was installed on Hyper V machine (2 cores processor, dynamic 2-8G RAM)
Please help! Thank you all!
my.cnf
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
[mysqld]
max_connections = 1000
query_cache_type = 1
innodb_flush_log_at_trx_commit = 2
optimizer_switch = index_condition_pushdown=off
max_heap_table_size = 256M
innodb_log_buffer_size = 256M
read_buffer_size = 256k
query_cache_limit = 1048576
read_rnd_buffer_size = 256k
innodb_buffer_pool_size = 2G
query_cache_size = 256M
tmp_table_size = 256M
slow-query-log
long_query_time = 20
slow_query_log_file = /var/log/mysql/slow-query.log
log_timestamps = SYSTEM
wait_timeout=300
interactive_timeout=60
!includedir /etc/mysql/mysql.conf.d/
[mysqld]
max_connections = 1000
query_cache_type = 1
innodb_flush_log_at_trx_commit = 2
optimizer_switch = index_condition_pushdown=off
max_heap_table_size = 256M
innodb_log_buffer_size = 256M
read_buffer_size = 256k
query_cache_limit = 1048576
read_rnd_buffer_size = 256k
innodb_buffer_pool_size = 2G
query_cache_size = 256M
tmp_table_size = 256M
slow-query-log
long_query_time = 20
slow_query_log_file = /var/log/mysql/slow-query.log
log_timestamps = SYSTEM
wait_timeout=300
interactive_timeout=60
StartPollers=350
StartPollersUnreachable=40
StartTrappers=80
StartPingers=30
HousekeepingFrequency=8
MaxHousekeeperDelete=500
CacheSize=512M
StartDBSyncers=10
HistoryCacheSize=512M
HistoryIndexCacheSize=512M
TrendCacheSize=512M
ValueCacheSize=512M
Timeout=15
LogSlowQueries=1000
StartPollersUnreachable=40
StartTrappers=80
StartPingers=30
HousekeepingFrequency=8
MaxHousekeeperDelete=500
CacheSize=512M
StartDBSyncers=10
HistoryCacheSize=512M
HistoryIndexCacheSize=512M
TrendCacheSize=512M
ValueCacheSize=512M
Timeout=15
LogSlowQueries=1000
)





Comment