mysql导入慢设置innodb_flush_log_at_trx_commit

进入/etc/my.cnf

编辑文件内容为：

[mysqld]
skip-name-resolve
datadir=/var/lib/mysql
default-character-set=utf8
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
character-set-server=utf8
collation-server=utf8_general_ci
max_connections = 1000
max_connect_errors=500
max_allowed_packet=20M
innodb_flush_log_at_trx_commit=0
bulk_insert_buffer_size=32M
innodb_log_buffer_size=8M
innodb_buffer_pool_size=32M
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
init_connect='SET autocommit=0'

编辑完重启数据库：

service mysqld stop;

service mysqld start;

查看是否修改成功：

SHOW GLOBAL VARIABLES LIKE 'innodb_flush_log%';