Parameter optimization of Zabbix configuration files and Zabbix database optimization

Parameter optimization for Zabbix configuration files

Startpollers=60

Startpollersunreacheable=80

Starttrappers=20

startpingers=100

startdiscoverers=120 #zabbix提示进程繁忙时修改此参数, Max 250, recommended 100 or so, high CPU performance

cachesize=1024m

Startdbsyncers=16

historycachesize=1024m

trendcachesize=1024m

historytextcachesize=512m

logslowqueries=1000

Database optimization of Zabbix

Egrep-v "(^#|^$)"/etc/my.cnf

[Client]

port=3306

Socket=/var/lib/mysql/mysql.sock

[Mysqld]

port=3306

Socket=/var/lib/mysql/mysql.sock

Skip-external-locking

Character-set-server=utf8

Slow_query_log

Slow_query_log_file=/var/log/mysql/slowquery.log

long_query_time=2

Log-error=/var/log/mysql/log-error.log

Skip-name-resolve

max_connections=5000

back_log=300

table-cache=4096

max_allowed_packet=32m

max-heap-table-size=128m

key_buffer_size=128m

sort-buffer-size=16m

join-buffer-size=16m

net_buffer_length=8k

read_buffer_size=256k

read_rnd_buffer_size=512k

Myisam_sort_buffer_size=8m

Thread-cache-size=16

Thread-concurrency=24

query-cache-size=4096m

query-cache-limit=4m

tmp-table-size=128m

Log_warnings

Innodb_file_per_table=1

Innodb_file_io_threads=4

innodb_open_files=2048

innodb_buffer_pool_size=10g

innodb_additional_mem_pool=16m

Innodb_thread_concurrency=16

Innodb_max_dirty_pages_pct=90

Log-bin=mysql-bin

Binlog_format=mixed

Server-id=1

[Mysqldump]

Quick

max_allowed_packet=16m

[MySQL]

No-auto-rehash

[Myisamchk]

key_buffer_size=20m

sort_buffer_size=20m

Read_buffer=2m

Write_buffer=2m

[Mysqlhotcopy]

Interactive-timeout

This article is from "YHT's operations Notes" blog, please make sure to keep this source http://yht1990.blog.51cto.com/9014030/1911778

Parameter optimization of Zabbix configuration files and Zabbix database optimization