[root@dca-zabbix ~]# cat /etc/zabbix/zabbix_server.conf
#Logging
LogFile=/var/log/zabbix/zabbix_server.log
LogFileSize=0
LogSlowQueries=3000
PidFile=/var/run/zabbix/zabbix_server.pid
SocketDir=/var/run/zabbix
AlertScriptsPath=/usr/lib/zabbix/alertscripts
ExternalScripts=/usr/lib/zabbix/externalscripts

DebugLevel=3

SNMPTrapperFile=/tmp/zabbix_traps.tmp
StartSNMPTrapper=1
StatsAllowedIP=127.0.0.1

FpingLocation=/sbin/fping
Fping6Location=/sbin/fping

#MySQL
DBName=zabbix
DBUser=zabbix
DBPassword=XXXXXXXXXXXXXXXXX

#Perf
StartPollers=180
StartPollersUnreachable=30
StartTrappers=40
StartPingers=20
StartDiscoverers=33
StartHTTPPollers=15
StartTimers=10

StartEscalators=1
MaxHousekeeperDelete=50000
CacheSize=256M
StartDBSyncers=4
HistoryCacheSize=64M
HistoryIndexCacheSize=64M
TrendCacheSize=64M
ValueCacheSize=128M
Timeout=30
UnreachablePeriod=600
UnavailableDelay=10
UnreachableDelay=10

#Java - Not in Use
#JavaGateway=127.0.0.1
#JavaGatewayPort=10052
#StartJavaPollers=0

#VMWare
StartVMwareCollectors=15
VMwareFrequency=120
VMwarePerfFrequency=120
VMwareCacheSize=128M
VMwareTimeout=10




[root@dca-zabbix ~]# cat /etc/my.cnf.d/server.cnf
[mysqld]
lc_messages_dir         = /usr/share/mysql
lc_messages             = en_US
skip-external-locking
skip-name-resolve       = 1
bind-address            = 0.0.0.0
max_connections         = 500
connect_timeout         = 600
wait_timeout            = 600
max_allowed_packet      = 256M
thread_cache_size       = 128
sort_buffer_size        = 4M
bulk_insert_buffer_size = 16M
tmp_table_size          = 32M
max_heap_table_size     = 32M
table_open_cache        = 400
concurrent_insert       = 2
read_buffer_size        = 2M
read_rnd_buffer_size    = 1M

# No longer required/recommended
#query_cache_limit               = 128K
#query_cache_size                = 64M
#query_cache_type                = OFF

#MYISAM -  Deprecated
#key_buffer_size         = 128M
#myisam_recover_options = BACKUP
#myisam_sort_buffer_size = 512M

#Logging
log_warnings            = 2
slow_query_log=1
slow_query_log_file     = /var/log/mysql/mariadb-slow.log
long_query_time = 10
log_slow_verbosity      = query_plan
server-id               = 1
log_bin                 = /var/log/mysql/mariadb-bin
log_bin_index           = /var/log/mysql/mariadb-bin.index
expire_logs_days        = 1
max_binlog_size         = 100M
binlog_format           = row
relay_log               = /var/log/mysql/relay-bin
relay_log_index = /var/log/mysql/relay-bin.index
relay_log_info_file     = /var/log/mysql/relay-bin.info

# Required for 6.0 Upgrade
log_bin_trust_function_creators = 1

#InnoDB
default_storage_engine  = InnoDB
innodb_log_file_size    = 1G
#innodb_buffer_pool_size = 48G
innodb_buffer_pool_size = 50G
innodb_log_buffer_size  = 8M
innodb_file_per_table   = 1
innodb_open_files       = 400
innodb_io_capacity      = 400
innodb_flush_method     = O_DIRECT

performance_schema      = ON
proxy-protocol-networks=::1, 10.39.2.0/23,localhost