社内イスコン

my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

character-set-server=utf8mb4

max_allowed_packet=300M

innodb_log_file_size=512M
innodb_log_buffer_size=32M
innodb_buffer_pool_size=2G

skip_innodb_doublewrite
innodb_flush_log_at_trx_commit=2

slow_query_log=0
slow_query_log_file=/var/lib/mysql/mysqld-slow.log
long_query_time=0.2
log-queries-not-using-indexes=0

[mysql]
default-character-set=utf8

[client]
default-character-set=utf8