Pages

Tuesday, July 5, 2011

MYSQL : Loading data into MySQL in quicker way


MYSQL : Loading data into MySQL in quicker way
Disabling key checks can help speed up the import.
SET UNIQUE_CHECKS=0;
SET FOREIGN_KEY_CHECKS=0;
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
skip-innodb_doublewrite
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…
Cheers!!!!

No comments: