Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Parameter optimization of Zabbix configuration file and database optimization of Zabbix

2025-03-31 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Parameter Optimization of Zabbix configuration File

AlertScriptsPath=/usr/local/zabbix/alertscripts

CacheSize=1024M

CacheUpdateFrequency=300

DebugLevel=3

DBHost=localhost

DBName=zabbix

DBUser=zabbix

DBPassword=zabbix

DBSocket=/var/lib/mysql/mysql.sock

ListenPort=10051

LogFileSize=5

LogType=file

LogFile=/data/logs/zabbix/zabbix_server.log

StartPollers=500

StartIPMIPollers=20

StartPollersUnreachable=80

StartTrappers=20

StartPingers=100

SenderFrequency=60

StartDBSyncers=16

StartDiscoverers=120 # zabbix prompts you to modify this parameter when the process is busy. A maximum of 250 is recommended. A large value consumes more cpu performance.

HistoryCacheSize=1024M

Timeout=30

TrendCacheSize=1024M

TrapperTimeout=120

LogSlowQueries=1000

UnreachablePeriod=30

UnavailableDelay=60

ValueCacheSize=1G

JavaGateway=127.0.0.1

JavaGatewayPort=10052

StartJavaPollers=12

PidFile=/tmp/zabbix_server.pid

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

Production environment zabbix configuration file

AlertScriptsPath=/usr/local/zabbix/alertscripts

CacheSize=1024M

CacheUpdateFrequency=300

DebugLevel=3

DBHost=localhost

DBName=zabbix

DBUser=zabbix

DBPassword=zabbix

DBSocket=/var/lib/mysql/mysql.sock

ListenPort=10051

LogFileSize=5

LogType=file

LogFile=/data/logs/zabbix/zabbix_server.log

StartPollers=500

StartIPMIPollers=20

StartPollersUnreachable=80

StartTrappers=20

StartPingers=100

SenderFrequency=60

StartDBSyncers=16

StartDiscoverers=120

HistoryCacheSize=1024M

Timeout=30

TrendCacheSize=1024M

TrapperTimeout=120

LogSlowQueries=1000

UnreachablePeriod=30

UnavailableDelay=60

ValueCacheSize=1G

JavaGateway=127.0.0.1

JavaGatewayPort=10052

StartJavaPollers=12

PidFile=/tmp/zabbix_server.pid

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 214

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report