MySQL dump恢复数据加快

#先查看现在参数情况
mysql> show variables like 'sync_binlog';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| sync_binlog   | 0     |
+---------------+-------+
1 row in set (0.00 sec)

mysql> show variables like 'innodb_flush_log_at_trx_commit';
+--------------------------------+-------+
| Variable_name                  | Value |
+--------------------------------+-------+
| innodb_flush_log_at_trx_commit | 1     |
+--------------------------------+-------+
1 row in set (0.00 sec)

#临时修改
set global sync_binlog = 2000;
set global innodb_flush_log_at_trx_commit = 2;

mysqldump -uroot -pxxxxx  database  < database.sql

mysql> source /root/databse.sql;

set global sync_binlog = 0;
set global innodb_flush_log_at_trx_commit = 1;