Hi everyone!
I use zabbix 3.4.4 with 10 proxies and 150 hosts , 15.000 items in summary. Zabbix-server and db(MariaDB) are on different servers.
Several days ago I stopped zabbix-server, created exact copy of stopped DB on another server with rsync, and today I started zbx-server and new db server, but on the majority of proxies there are huge queues and no updates at all. Several proxies have 0 count in queues, but last check on all items under that proxy has a lag in 3-4 hours and its not catching up!
All help will be appreciated, thanks in advance!
My configs:
/etc/zabbix/zabbix-server.conf
ListenPort=10051
LogFile=/var/log/zabbix/zabbix_server.log
LogFileSize=0
PidFile=/var/run/zabbix/zabbix_server.pid
SocketDir=/var/run/zabbix
DBHost=10.0.0.65
DBName=zabbix
DBUser=zabbix
DBPassword=zabbix
DBPort=3306
StartPollers=100
StartPreprocessors=100
StartPollersUnreachable=100
StartTrappers=100
SNMPTrapperFile=/var/log/snmptrap/snmptrap.log
HousekeepingFrequency=1
CacheSize=512M
ValueCacheSize=32M
Timeout=30
AlertScriptsPath=/usr/lib/zabbix/alertscripts
ExternalScripts=/usr/lib/zabbix/externalscripts
LogSlowQueries=3000
/etc/my.conf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
innodb_file_per_table=1
innodb_flush_method=O_DIRECT
table_cache = 2048
innodb_buffer_pool_size = 32G
innodb_data_file_path=ibdata1:10M:autoextend
query_cache_limit = 10M
query_cache_size = 2048M
default_storage_engine = InnoDB
innodb_open_files = 12000
innodb_io_capacity = 400
innodb_flush_method = O_DIRECT
innodb_lock_wait_timeout = 50
innodb_flush_log_at_trx_commit = 2
innodb_read_io_threads = 4
innodb_write_io_threads = 2
max_connections = 2000
skip-external-locking
skip-name-resolve
slow_query_log_file = /var/log/mariadb/mysql-slow.log
slow_query_log = 1
long_query_time = 10
log_queries_not_using_indexes
innodb_buffer_pool_size=100M
max_allowed_packet=1024M
net_read_timeout=31536000
net_write_timeout=31536000
general_log_file = /var/log/mariadb/general.log
general_log = 0
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
I use zabbix 3.4.4 with 10 proxies and 150 hosts , 15.000 items in summary. Zabbix-server and db(MariaDB) are on different servers.
Several days ago I stopped zabbix-server, created exact copy of stopped DB on another server with rsync, and today I started zbx-server and new db server, but on the majority of proxies there are huge queues and no updates at all. Several proxies have 0 count in queues, but last check on all items under that proxy has a lag in 3-4 hours and its not catching up!
All help will be appreciated, thanks in advance!
My configs:
/etc/zabbix/zabbix-server.conf
ListenPort=10051
LogFile=/var/log/zabbix/zabbix_server.log
LogFileSize=0
PidFile=/var/run/zabbix/zabbix_server.pid
SocketDir=/var/run/zabbix
DBHost=10.0.0.65
DBName=zabbix
DBUser=zabbix
DBPassword=zabbix
DBPort=3306
StartPollers=100
StartPreprocessors=100
StartPollersUnreachable=100
StartTrappers=100
SNMPTrapperFile=/var/log/snmptrap/snmptrap.log
HousekeepingFrequency=1
CacheSize=512M
ValueCacheSize=32M
Timeout=30
AlertScriptsPath=/usr/lib/zabbix/alertscripts
ExternalScripts=/usr/lib/zabbix/externalscripts
LogSlowQueries=3000
/etc/my.conf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
innodb_file_per_table=1
innodb_flush_method=O_DIRECT
table_cache = 2048
innodb_buffer_pool_size = 32G
innodb_data_file_path=ibdata1:10M:autoextend
query_cache_limit = 10M
query_cache_size = 2048M
default_storage_engine = InnoDB
innodb_open_files = 12000
innodb_io_capacity = 400
innodb_flush_method = O_DIRECT
innodb_lock_wait_timeout = 50
innodb_flush_log_at_trx_commit = 2
innodb_read_io_threads = 4
innodb_write_io_threads = 2
max_connections = 2000
skip-external-locking
skip-name-resolve
slow_query_log_file = /var/log/mariadb/mysql-slow.log
slow_query_log = 1
long_query_time = 10
log_queries_not_using_indexes
innodb_buffer_pool_size=100M
max_allowed_packet=1024M
net_read_timeout=31536000
net_write_timeout=31536000
general_log_file = /var/log/mariadb/general.log
general_log = 0
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log