client
port=3306
socket=/var/run/mysqld/mysqld.sock

mysqld_safe
socket=/var/run/mysqld/mysqld.sock

mysqld
user=mysql
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/run/mysqld/mysqld.sock
port=3306
basedir=/usr:/home/admin/web
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log
local-infile=1


symbolic-links=0

skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 512M

sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M

thread_cache_size = 8
query_cache_size= 32M
query_cache_type=1
query_cache_limit=4M
thread_concurrency = 8

innodb_buffer_pool_size= 12

max_heap_table_size = 300M
tmp_table_size = 300M
table_open_cache = 15000

#innodb_use_native_aio = 0
innodb_file_per_table

wait_timeout=300
connect_timeout=300
max_connect_errors=10

max_connections=200
max_user_connections=50
interactive_timeout=5000
long_query_time = 2

!includedir /etc/mysql/conf.d/