Zabbix history syncer process high load

[fpaternot]

The error you are getting is mysql related. Did you try to run that query on the mysql console? How did it go? Same error?

Try stopping the zabbix_server and then run the query. If it works, you definally needs to tune the mysql. If it dosent, try tuning and see if it does.

That size seems too small. I think im using about 16G and i have only 500nvps.

[harmonica]

The error you are getting is mysql related. Did you try to run that query on the mysql console? How did it go? Same error?

Try stopping the zabbix_server and then run the query. If it works, you definally needs to tune the mysql. If it dosent, try tuning and see if it does.

That size seems too small. I think im using about 16G and i have only 500nvps.

Hi fpaternot,

Zabbix is stable since last saturday after I changed the variable innodb_lock_wait_timeou to 500 and set 43200 sec for Update interval on all SNMP Discovery rules.
Maybe my my.cnf is not properly configured. It was generated by Percona Configuration Wizard, search on Google and MySQL website. Please advise for correct values.

Our server has 8192 MB and Intel(R) Xeon(R) CPU E5405 @ 2.00GHz

# MySQL server
[mysqld]
user = mysql
socket = /var/lib/mysql/mysql.sock
default_storage_engine = InnoDB
myisam_recover = FORCE,BACKUP
skip_name_resolve
sql_mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_S UBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL _GROUP_BY
sysdate_is_now = 1
innodb = FORCE
symbolic-links = 0

# Paths
#tmpdir = /tmp/mysqltmp
datadir = /var/lib/mysql

# Buffer
myisam_sort_buffer_size = 8M
sort_buffer_size = 512K
join_buffer_size = 1M
net_buffer_length = 8K
read_buffer_size = 512K
read_rnd_buffer_size = 512K
key_buffer_size = 32M

# Cache
thread_cache_size = 64
table_open_cache = 256
query_cache_size = 64M
query_cache_limit = 1M
query_cache_type = 1
tmp_table_size = 32M
max_heap_table_size = 32M
open_files_limit = 768
table_definition_cache = 4096

# Network
max_connections = 256
max_allowed_packet = 16M
max_connect_errors = 100
connect_timeout = 10

# InnoDB tables
innodb_flush_method = O_DIRECT
innodb_log_files_in_group = 2
innodb_log_file_size = 16M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 2
innodb_buffer_pool_size = 4G
innodb_additional_mem_pool_size = 4M
innodb_data_home_dir = /var/lib/mysql
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql
innodb_thread_concurrency = 8
innodb_lock_wait_timeout = 500
innodb_fast_shutdown = 1

# Logging
slow_query_log_file = /var/log/mysql-slow.log
slow_query_log = 1

[mysqld_safe]
log-error = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid

[mysqldump]
socket = /var/lib/mysql/mysql.sock
quick
max_allowed_packet = 16M

[mysql]
port = 3306
socket = /var/lib/mysql/mysql.sock
no-auto-rehash

[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
default_character_set = utf8

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

Regards

[harmonica]

Hi,

Now I understand this message. This is the snmp item ifInOctets and ifOutOctets description for the Network Interfaces discovery rule.

30179:20140118:200410.463 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update items set description='The total number of octets transmitted out of the
interface, including framing characters. This object is a 32-bit version.' where itemid=199425;

[harmonica]

Hi,

Upgrading from MySQL 5.1 to 5.6 solved our problems.

Regards