My company was delivered a 20 + GB.sql file in response to a request for data from the government. I do not have many options for receiving data in a different format, so I need options for importing it in a reasonable amount of time. I run it on a high-performance server (Win 2008 64bit, MySQL 5.1) using the Navicat batch execution tool. He worked for 14 hours and found no signs of nearing completion.
Does anyone know of any higher speeds for such a transaction? Or is this what I should expect, given the large file size?
thank
, , mysqldump , CREATE TABLE INSERT.
mysqldump
CREATE TABLE
INSERT
(, , SQL script , , , .. , .)
, , , :
: SET FOREIGN_KEY_CHECKS=0 ( ). : SET UNIQUE_CHECKS=0
SET FOREIGN_KEY_CHECKS=0
SET UNIQUE_CHECKS=0
, key_buffer_size , MyISAM. - 8 , - 4 . 1 .
key_buffer_size
: http://lists.mysql.com/mysql/206866
, innodb_buffer_pool_size , InnoDB. - 8 , - 4 . 1 .
innodb_buffer_pool_size
innodb_flush_log_at_trx_commit = 2 , InnoDB.
innodb_flush_log_at_trx_commit = 2
@Mark B . :
ALTER TABLE <table-name> DISABLE KEYS; ...run your restore... ALTER TABLE <table-name> ENABLE KEYS;
. . , , , , .
, SQL script, , , . . , sed SQL script, mysql.
sed
mysqldump Percona Server - innodb-optimize-keys.
BULK Import MySQL.
.csv. .
, GUI Navicat . 48GB *.sql 6 8 .
() : , " SQL", , " ", , , . , MySQL, / .
"" sql query builder, , RAM .
Macintosh OS Navicat, , , , RHEL, Ubuntu Server, Debian Windows Server .
, " SQL", , " ", , , .
, MySQL, / .