Help: Zabbix database server CPU 100%,when i modify low level dicovery rule

[waydeechen]

HI:

My environment：
zabbix NVPS： 20000
zabbix version: 2.2.8
zabbix server:
CPU: Intel(R) Xeon(R) CPU E5-2620 v2 @ 2.10GHz * 24
Mermory: 256G

zabbix database:
percona mysql server 5.6
CPU: Intel(R) Xeon(R) CPU X7550 @ 2.00GHz * 64
Mermory: 256G


there are 10000 hosts in linux template， when i modify the low level discovery rule in template，such as add a trigger prototypes for partition usage， then zabbix database server load became vary high， and too many select in mysql query， at that moment，there is no insert sql ，so zabbix can not collect latest value；

Why ? please help me, thanks

What does zabbix do when I modify low level discovery rule in template ?

[Colttt]

can you please post you mysql config?

maybe you can also run tuning-primer to check if the config OK.. http://www.day32.com/MySQL/

[waydeechen]

thanks for reply; here is mysql configure:
[xtrabackup]
target-dir = /opt/pxc_backup
tmpdir = /opt/pxc_backup/tmpdir
[mysqld]
port = 3306
socket = /opt/mysql/run/mysqld.sock
basedir = /opt/mysql
datadir = /opt/mysql/data
tmpdir = /opt/mysql/tmpdir/
explicit_defaults_for_timestamp = true
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLE S
log-bin=mysql-bin
server-id=10
expire_logs_days = 3
connect_timeout = 60
wait_timeout = 2880000
interactive_timeout = 2880000
max_connections = 8000
max_allowed_packet = 256M
max_connect_errors = 1000
tmp_table_size = 2048M
max_heap_table_size = 2048M
sync_binlog=0
binlog_row_image=FULL
query_cache_type = 0
query_cache_size = 0
read_buffer_size=2M
transaction_isolation = READ-COMMITTED
log_error = /opt/mysql/logs/mysql-error.log
slow_query_log_file = /opt/mysql/logs/slow-query.log
slow_query_log = 1
long_query_time = 20
innodb_data_home_dir = /opt/mysql/data
innodb_data_file_path = ibdata1:128M;ibdata2:128M:autoextend
innodb_file_per_table = 1
innodb_status_file = 1
innodb_buffer_pool_size = 170G
innodb_buffer_pool_instances = 36
innodb_read_io_threads=8
innodb_write_io_threads=8
innodb_use_native_aio=on
innodb_flush_method = O_DIRECT
innodb_io_capacity = 2000
innodb_flush_log_at_trx_commit = 0
innodb_support_xa = 0
innodb_log_file_size = 2G
innodb_log_buffer_size = 128M
innodb_lock_wait_timeout = 50
innodb_old_blocks_time = 1000
event_scheduler = 1
[client]
default-character-set = 'utf8'
port = 3306
socket = /opt/mysql/run/mysqld.sock

[waydeechen]

can you please post you mysql config?

maybe you can also run tuning-primer to check if the config OK.. http://www.day32.com/MySQL/

[xtrabackup]
target-dir = /opt/pxc_backup
tmpdir = /opt/pxc_backup/tmpdir
[mysqld]
port = 3306
socket = /opt/mysql/run/mysqld.sock
basedir = /opt/mysql
datadir = /opt/mysql/data
tmpdir = /opt/mysql/tmpdir/
explicit_defaults_for_timestamp = true
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLE S
log-bin=mysql-bin
server-id=10
expire_logs_days = 3
connect_timeout = 60
wait_timeout = 2880000
interactive_timeout = 2880000
max_connections = 8000
max_allowed_packet = 256M
max_connect_errors = 1000
tmp_table_size = 2048M
max_heap_table_size = 2048M
sync_binlog=0
binlog_row_image=FULL
query_cache_type = 0
query_cache_size = 0
read_buffer_size=2M
transaction_isolation = READ-COMMITTED
log_error = /opt/mysql/logs/mysql-error.log
slow_query_log_file = /opt/mysql/logs/slow-query.log
slow_query_log = 1
long_query_time = 20
innodb_data_home_dir = /opt/mysql/data
innodb_data_file_path = ibdata1:128M;ibdata2:128M:autoextend
innodb_file_per_table = 1
innodb_status_file = 1
innodb_buffer_pool_size = 170G
innodb_buffer_pool_instances = 36
innodb_read_io_threads=8
innodb_write_io_threads=8
innodb_use_native_aio=on
innodb_flush_method = O_DIRECT
innodb_io_capacity = 2000
innodb_flush_log_at_trx_commit = 0
innodb_support_xa = 0
innodb_log_file_size = 2G
innodb_log_buffer_size = 128M
innodb_lock_wait_timeout = 50
innodb_old_blocks_time = 1000
event_scheduler = 1
[client]
default-character-set = 'utf8'
port = 3306
socket = /opt/mysql/run/mysqld.sock

[Colttt]

sorry for the late response.. i think it looks all good..
its a zabbix issue how zabbix handle the updates..

maybe you create an bug report?

https://support.zabbix.com/browse/ZBX

[waydeechen]

sorry for the late response.. i think it looks all good..
its a zabbix issue how zabbix handle the updates..

maybe you create an bug report?
https://support.zabbix.com/browse/ZBX

thanks, i will try

[Colttt]

if you create a ticket, please post the number

[waydeechen]

https://support.zabbix.com/browse/ZBX-9620

[Colttt]

wow.. i see its an old bug..