Tune Zabbix MySQL DB

There are many guides for tuning Zabbix and DB.

Here’s what I did in my environment (only DB):

innodb_buffer_pool_size = 2G
innodb_buffer_pool_instances = 8
innodb_flush_log_at_trx_commit = 0
innodb_io_capacity = 500