Optimize the speed of importing data to MARIADB, Mysql (InnoDB)

Key configuration: Turn off Binlog

Environment: 8G SQL file, more than 300 InnoDB data sheets,( with mysqlworkbench exported data, with Heidisql import, because the formal environment is MySQL, can be used mysqlworkbench, and MARIADB can not use the export, to use Heidisql, directly with the mysqldump, the source command is also possible ). Export takes 6 minutes, import takes 55 minutes (need to improve, follow up)

Version: MariaDB 10

1. Note "Log-bin=mysql-bin", "binlog_format=mixed"

2. "innodb_flush_log_at_trx_commit" is set to "2"

3. After the import is complete, be sure to remember to set the original

Export command with Mysqlworkbench generated

18:24:07 Dumping XXXXXX (all tables)
Running:mysqldump.exe--defaults-extra-file= "c:\users\admini~1\appdata\ Local\temp\2\tmpo4jjp3.cnf " --user=root--max_allowed_packet=1g--host=localhost--port=3306-- Default-character-set=utf8--routines " XXXXXX "
18:30:11 Export of D:\ xxxxxx  . sql Has finished