Hi
I had Zabbix 6.2 and everything was ok, recently I upgraded to 6.4.12 and since then I have had multiple problems.
Zabbix server: Utilization of housekeeper processes over 75%
Zabbix server: Utilization of configuration syncer processes over 75%
Zabbix server: Utilization of poller processes over 75%
Zabbix server: Utilization of preprocessing manager processes over 75%
sda: Disk read/write request responses are too high (read > 20 ms for 15m or write > 20 ms for 15m)
Zabbix server: Utilization of history syncer processes over 75%
On Zabbix 6.2 I didn't have any SQL configuration since the upgrade I made some changes
I'm attaching all the settings, do you have some suggestions for me, please?
My server is
8 CPU and 32 GIG RAM
I use Centos 8 with MySQL and Apache
my zabbix config is :
LogFile=/var/log/zabbix/zabbix_server.log
LogFileSize=512
PidFile=/run/zabbix/zabbix_server.pid
SocketDir=/run/zabbix
DBName=zabbix
StartPollers=20
StartIPMIPollers=10
StartPreprocessors=20
StartPollersUnreachable=20
StartHistoryPollers=20
StartTrappers=20
StartPingers=20
StartDiscoverers=20
StartVMwareCollectors=5
VMwarePerfFrequency=60
VMwareCacheSize=256M
VMwareTimeout=10
StartSNMPTrapper=1
HousekeepingFrequency=2
MaxHousekeeperDelete=50000
CacheSize=1G
StartDBSyncers=10
HistoryCacheSize=128M
HistoryIndexCacheSize=64M
ValueCacheSize=1G
Timeout=4
LogSlowQueries=3000
StatsAllowedIP=127.0.0.1
StartODBCPollers=10
my SQL conf is :
[client-server]
!includedir /etc/my.cnf.d
open_files_limit = 16364
max_connections = 500
event_scheduler = 1
wait_timeout = 86400
default_storage_engine = InnoDB
log_error = /var/log/mysql/mysqld-error.log
slow_query_log_file = /var/log/mysql/mysqld-slow.log
general_log_file = /var/log/mysql/mysqld.log
general_log = 0
skip-name-resolve = 1
performance_schema = ON
innodb_buffer_pool_size=23G
innodb_buffer_pool_instances=12
innodb_buffer_pool_dump_at_shutdown=1
innodb_buffer_pool_load_at_startup=1
innodb_log_file_size=512M
innodb_flush_method=O_DIRECT
innodb_flush_log_at_trx_commit=0
query_cache_size=0
thread_cache_size=64
tmp_table_size = 134217728
table_open_cache = 2048
join_buffer_size = 262144
binlog-row-event-max-size = 8192
character_set_server = utf8
collation_server = utf8_bin
expire_logs_days = 1
max_allowed_packet = 32M
query_cache_type = 0
slow-query-log = ON
thread_pool_size = 12
optimizer_switch = 'index_condition_pushdown=off'
innodb_autoinc_lock_mode = 2
innodb_autoextend_increment = 256
innodb_change_buffer_max_size = 50
innodb_concurrency_tickets = 5000
innodb_file_per_table = 1
query_cache_limitinnodb_log_files_in_group = 4
innodb_old_blocks_time = 1000
innodb_open_files = 2048
innodb_stats_on_metadata = OFF
innodb_lock_wait_timeout = 50
innodb_io_capacity = 2000
I had Zabbix 6.2 and everything was ok, recently I upgraded to 6.4.12 and since then I have had multiple problems.
Zabbix server: Utilization of housekeeper processes over 75%
Zabbix server: Utilization of configuration syncer processes over 75%
Zabbix server: Utilization of poller processes over 75%
Zabbix server: Utilization of preprocessing manager processes over 75%
sda: Disk read/write request responses are too high (read > 20 ms for 15m or write > 20 ms for 15m)
Zabbix server: Utilization of history syncer processes over 75%
On Zabbix 6.2 I didn't have any SQL configuration since the upgrade I made some changes
I'm attaching all the settings, do you have some suggestions for me, please?
My server is
8 CPU and 32 GIG RAM
I use Centos 8 with MySQL and Apache
my zabbix config is :
LogFile=/var/log/zabbix/zabbix_server.log
LogFileSize=512
PidFile=/run/zabbix/zabbix_server.pid
SocketDir=/run/zabbix
DBName=zabbix
StartPollers=20
StartIPMIPollers=10
StartPreprocessors=20
StartPollersUnreachable=20
StartHistoryPollers=20
StartTrappers=20
StartPingers=20
StartDiscoverers=20
StartVMwareCollectors=5
VMwarePerfFrequency=60
VMwareCacheSize=256M
VMwareTimeout=10
StartSNMPTrapper=1
HousekeepingFrequency=2
MaxHousekeeperDelete=50000
CacheSize=1G
StartDBSyncers=10
HistoryCacheSize=128M
HistoryIndexCacheSize=64M
ValueCacheSize=1G
Timeout=4
LogSlowQueries=3000
StatsAllowedIP=127.0.0.1
StartODBCPollers=10
my SQL conf is :
[client-server]
!includedir /etc/my.cnf.d
open_files_limit = 16364
max_connections = 500
event_scheduler = 1
wait_timeout = 86400
default_storage_engine = InnoDB
log_error = /var/log/mysql/mysqld-error.log
slow_query_log_file = /var/log/mysql/mysqld-slow.log
general_log_file = /var/log/mysql/mysqld.log
general_log = 0
skip-name-resolve = 1
performance_schema = ON
innodb_buffer_pool_size=23G
innodb_buffer_pool_instances=12
innodb_buffer_pool_dump_at_shutdown=1
innodb_buffer_pool_load_at_startup=1
innodb_log_file_size=512M
innodb_flush_method=O_DIRECT
innodb_flush_log_at_trx_commit=0
query_cache_size=0
thread_cache_size=64
tmp_table_size = 134217728
table_open_cache = 2048
join_buffer_size = 262144
binlog-row-event-max-size = 8192
character_set_server = utf8
collation_server = utf8_bin
expire_logs_days = 1
max_allowed_packet = 32M
query_cache_type = 0
slow-query-log = ON
thread_pool_size = 12
optimizer_switch = 'index_condition_pushdown=off'
innodb_autoinc_lock_mode = 2
innodb_autoextend_increment = 256
innodb_change_buffer_max_size = 50
innodb_concurrency_tickets = 5000
innodb_file_per_table = 1
query_cache_limitinnodb_log_files_in_group = 4
innodb_old_blocks_time = 1000
innodb_open_files = 2048
innodb_stats_on_metadata = OFF
innodb_lock_wait_timeout = 50
innodb_io_capacity = 2000