#
# This configuration file targets MySQL 5.7.12
# For advice on how to change settings please see: http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
# Example conf files are in /usr/share/mysql/
# The default mysql conf files are in /var/default-conf/mysql/
#


#
# This group is read by both by the client and the server, use it for options that affect everything.
#
[client-server]


#
# This group is read by the standalone daemon and embedded servers.
#
[server]


#
# This group is only for embedded server.
#

[embedded]


#
# This group is read by the server. 
#
[mysqld]

# Basic configuration
port=3306
server_id=0
#bind-address = 45.63.31.95

#bind-address = 0.0.0.0

datadir=/var/lib/mysql
tmpdir=/var/lib/mysqltmp
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

# Logging
log_error=/var/log/mysqld-error.log
slow_query_log=ON
slow_query_log_file=/var/log/mysqld-slow.log
general_log=OFF
general_log_file=/var/log/mysqld-general.log

slow_query_log = 1
slow_query_log_file = /var/log/mysql/mysql-slow.log
long_query_time = 1


query_cache_type = 1
query_cache_size = 64M
query_cache_limit = 4M

innodb_buffer_pool_size = 512M
innodb_buffer_pool_instances = 8
innodb_log_file_size = 128M
innodb_flush_method = O_DIRECT
tmp_table_size = 64M
max_connections = 50
max_user_connections = 250
key_buffer_size = 16M

# Remove leading # and set to the amount of RAM for the most important data cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. Default is 128M.
#innodb_buffer_pool_size = 128M

# Set the number of open tables. This has a huge effect on memory usage. Default value is 2000.
table_open_cache = 2000
table_definition_cache = 800

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
#log_bin

# Optionally change the SQL mode.
sql_mode = ""

# Remove leading # to set options mainly useful for reporting servers. The server defaults are faster for transactions and fast SELECTs. Adjust sizes as needed, experiment to find the optimal values.
join_buffer_size = 8M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M

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