Zabbix 2.2 mysql tuning

Share This:

Bits needs tuning,

My environment ~500 devices, 5x15K 600GB SAS, 32GB of RAM, 2x Xeon E5 CPU

/etc/my.cnf

[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock

datadir = /var/lib/mysql

connect_timeout = 60
wait_timeout = 28800
max_connections = 2048
max_allowed_packet = 64M
max_connect_errors = 1000

tmp_table_size = 512M
max_heap_table_size = 64M
table_cache = 512

# innodb
innodb_data_home_dir = /var/lib/mysql
innodb_file_per_table = 1
innodb_status_file = 1
innodb_additional_mem_pool_size = 128M
innodb_buffer_pool_size = 14G
innodb_flush_method = O_DIRECT
innodb_io_capacity = 2000

event_scheduler = 1
query_cache_type = 0

Leave a comment

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.