My current MySQL conf file my.cnf


[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
max_allowed_packet = 100M
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
skip-networking


skip-bdb


set-variable = innodb_buffer_pool_size=1G
set-variable = innodb_additional_mem_pool_size=20M
set-variable = innodb_log_file_size=250M
set-variable = innodb_log_buffer_size=8M
set-variable = innodb_thread_concurrency=4
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


skip-bdb


set-variable = innodb_buffer_pool_size=1G
set-variable = innodb_additional_mem_pool_size=20M
set-variable = innodb_log_file_size=250M
set-variable = innodb_log_buffer_size=8M
set-variable = innodb_thread_concurrency=4

May 29, 2018