mysql - 在单个大插入上丢失与 mysql 的连接

Question

我正在尝试恢复具有定义的表中的数据

CREATE TABLE UserDomainSummaries (
summary_id              INT UNSIGNED,
user_id                 BIGINT UNSIGNED,
domain_id               BIGINT UNSIGNED,
city_id                 INT UNSIGNED,
state_id                INT UNSIGNED,
country_id              INT UNSIGNED,
visitCount              INT UNSIGNED NOT NULL,
pageViewCount           INT UNSIGNED NOT NULL,
totalTimeSpentInSecs    INT UNSIGNED NOT NULL,
ffVisitCount            INT UNSIGNED NOT NULL,
ffPageViewCount         INT UNSIGNED NOT NULL,
ffTotalTimeSpentInSecs  INT UNSIGNED NOT NULL,

PRIMARY KEY(summary_id, user_id, domain_id, country_id, state_id, city_id),
FOREIGN KEY(summary_id) REFERENCES Summaries(id) ON DELETE CASCADE
) ENGINE=INNODB DEFAULT CHARSET=utf8;`

来自一个包含大量行的单个插入文件，总计 200MB。但是，在两者之间弹出一个错误说

ERROR 2013 (HY000): Lost Connection To MySQL Server During Query

我尝试调整

的值

innodb_buffer_pool_size
net_read_timeout
bulk_insert_buffer_size
max_allowed_packet

但无济于事。

为什么会这样？

Answer 1

使用加载数据代替

http://dev.mysql.com/doc/refman/5.0/en/load-data.html