#
# The Percona Server 5.7 configuration file.
#
#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#   Please make any edits and changes to the appropriate sectional files
#   included below.
#
!includedir /etc/my.cnf.d/
!includedir /etc/percona-server.conf.d/


[mysqld]

query_cache_limit               = 148M
thread_cache_size               = 16M
max-allowed-packet              = 16M
max-connect-errors              = 1000000
innodb_buffer_pool_size         = 2G
slow_query_log                  = 1
slow_query_log_file             = /var/lib/mysql/mysql-slow.log
long_query_time                 = 5

datadir                         =/var/lib/mysql
socket                          =/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Recommended in standard MySQL setup
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysqld_safe]
log-error                       =/var/lib/mysql/mysqld.log
pid-file                        =/var/run/mysqld/mysqld.pid

# MyISAM #
key_buffer_size                 = 32M
myisam_recover                  = FORCE,BACKUP

# # SAFETY #
max_allowed_packet              = 16M
max_connect_errors              = 1000000

# # BINARY LOGGING #
binlog_format                   = ROW
log_bin                         = /var/lib/mysql/mysql-bin
expire_logs_days                = 14
sync_binlog                     = 1