[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
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log
symbolic-links = 0
skip-external-locking
sql_mode = ""
performance-schema = false
# CACHES AND LIMITS #
max_allowed_packet = 16M
max-heap-table-size = 32M
tmp_table_size = 32M
query_cache_type = 1
query_cache_size = 32M
thread-cache-size = 50
open-files-limit = 65535
table-definition-cache = 4096
table-open-cache = 4096
thread_cache_size = 4
query_cache_limit = 2M
join_buffer_size = 2M
# INNODB #
innodb-flush-method = O_DIRECT
innodb-log-files-in-group = 2
innodb-log-file-size = 100M
innodb_log_buffer_size = 16M
transaction-isolation = READ-COMMITTED
innodb-file-per-table = 0
innodb_buffer_pool_instances = 2
innodb_buffer_pool_size = 1024M
innodb_flush_log_at_trx_commit = 0
max-connections = 180
max_user_connections = 50
wait_timeout = 10
interactive_timeout = 50
long_query_time = 5
!includedir /etc/mysql/conf.d/
Комментариев нет