# MariaDB/Percona/Oracle MySQL programs look for option files in a set of locations which depend on the deployment platform. You can copy this option file to one of those locations. For information about these locations, see: http://dev.mysql.com/doc/mysql/en/option-files.html

# For detailed definition of settings, see: http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html

# Below is the starting base configuration. You can copy this file as my.cnf under /etc to set global options. It should work on most, if not all, hardware platforms that span from the less powerful desktop to enterprise servers with a lot of horsepower. It should also work with MariaDB, Percona, Oracle, and other MySQL packages.

# For additional customization and optimization, please visit http://kb.askmonty.org/v/sample-mycnf-files for more samples. We'd also like to hear what works best for you. So if you have input that you'd like to share, please feel free to edit/comment on that article. As server tuning is a complex topic, and there is a lot of information to wade through on the web, some of it is actually wrong, you may find it beneficial to consult with industry experts for optimization.

# The following options will be passed to all MySQL clients
[client]
port = @MYSQL_TCP_PORT@
socket = @MYSQL_UNIX_ADDR@
# Default is Latin1, if you need UTF-8 set this (also in server section)
#default-character-set  = utf8 


# The MySQL server
[mysqld]
port = @MYSQL_TCP_PORT@
socket = @MYSQL_UNIX_ADDR@
user = mysql

skip-name-resolve

log-bin = mysql-bin
log-slow-queries
sync_binlog = 1
expire_logs_days = 10

wait_timeout = 30

max_allowed_packet = 16M

#server-id = last octet of IP address
#character-set-server = utf8

[mysqldump]
max_allowed_packet = 16M