MYSQL : Loading data into MySQL in quicker way
Disabling key checks can help speed up the import.
Whenever we load data into a MySQL database the following settings can help speed up the import.
innodb_flush_log_at_trx_commit = 0
innodb_support_xa = 0
If the server doesn’t have replication configured and if the log-bin is enabled, disable it using SET SQL_LOG_BIN=0 or manually comment log-bin parameter in my.cnf. Similiarly we can disable other logs will also help. These parameters help in reducing frequent syncs to disk…