[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
skip-external-locking
skip-name-resolve
back_log = 384
bind-address = 127.0.0.1
key_buffer_size = 64M
sort_buffer_size = 2M
read_buffer_size = 2M
join_buffer_size = 4M
query_cache_size = 32M
query_cache_limit= 2M
query_cache_type = 1
thread_cache_size= 512
thread_stack = 256K
tmp_table_size = 64M
max_allowed_packet = 16M
max_connect_errors = 10
myisam-recover = BACKUP
myisam_sort_buffer_size = 64M
max_connections = 400
table_cache = 1M
thread_concurrency = 32
interactive_timeout = 25
wait_timeout = 1000
connect_timeout = 10
expire_logs_days = 10
max_binlog_size = 100M
skip-federated
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
key_buffer = 16M
!includedir /etc/mysql/conf.d/