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

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d


[mysqld]


log_error = /var/log/mysql.log
pid-file = /var/lib/mysql/mysql_run.pid

performance-schema=0
local-infile=0
innodb_file_per_table=1
#default-storage-engine=MyISAM
sql_mode=""
#skip-name-resolve

interactive_timeout=101
connect_timeout=50
max_connections=300
max_user_connections=200

wait_timeout=120
max_allowed_packet=256M
open_files_limit=500000

tmp_table_size=32M
max_heap_table_size=32M
table_definition_cache=500

#read_buffer_size=5M
#join_buffer_size=1M
#sort_buffer_size=1M
key_buffer_size=64M

#query_cache_type = 0
#query_cache_size = 0

table_open_cache = 512
low_priority_updates = 1 # MyISAM only, but no harm

#deprecated soon
thread_cache_size=128

# theses variables can be tweaked to improve innodb performance, for 4GB+
#innodb_log_buffer_size = 256M
#innodb_buffer_pool_size = 4G
#innodb_buffer_pool_instances=4
#innodb_log_file_size = 384M
#innodb_buffer_pool_dump_pct=50
#innodb_flush_log_at_trx_commit = 2
#innodb_flush_method = O_DIRECT