Win1064位下mysql插入百万行数据耗时问题

performance - Inserting 1 Million records is taking too much time MYSQL - Stack Overflow
https://stackoverflow.com/questions/33820331/inserting-1-million-records-is-taking-too-much-time-mysql

mysql插入1百万行记录，表结构简单，16G，8核，耗时：6到 7小时。

 

Ask TOM "How to Update millions or records in a table"
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:6407993912330

Inserting about a billion rows in one table in about 4 hours
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b1476847-7897-465d-b392-bf5ca67f8ffb/inserting-about-a-billion-rows-in-one-table-in-about-4-hours

从s ... |中一次插入/选择一百万行 Oracle社区
https://community.oracle.com/thread/2460632

 

Windows10 4core 25GHz 16G

插入花了超过4小时，

在Centos上花了约20分钟

可能存在如下的坑：

max_binlog_stmt_cache_size

如果一个事务中的非事务性的语句需要大于这个数量的更多的内存，服务器会产生报错。最低值是4096 ，在32位平台最大和默认值是4GB。在64位平台最大和默认值是416EB（艾字节）。

Note

Prior to MySQL 5.6.7, 64-bit Windows platforms truncated the stored value for this variable to 4G, even when it was set to a greater value (Bug #13961678).

转载于:https://www.cnblogs.com/rgqancy/p/10276232.html