nodejs mysql 批量_nodejs写入mysql单次数据量过大的解决方法

今天使用nodejs开发mysql程序时，发现了如下bug提示：{ Error: write EPIPE

at WriteWrap.afterWrite [as oncomplete] (net.js:782:14)

--------------------

at Protocol._enqueue (/root/doctracing/node_modules/mysql/lib/protocol/Protocol.js:144:48)

at PoolConnection.query (/root/doctracing/node_modules/mysql/lib/Connection.js:200:25)

at /root/doctracing/mysql.js:22:22

at Ping.onOperationComplete (/root/doctracing/node_modules/mysql/lib/Pool.js:110:5)

at Ping. (/root/doctracing/node_modules/mysql/lib/Connection.js:502:10)

at Ping._callback (/root/doctracing/node_modules/mysql/lib/Connection.js:468:16)

at Ping.Sequence.end (/root/doctracing/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)

at Ping.Sequence.OkPacket (/root/doctracing/node_modules/mysql/lib/protocol/sequences/Sequence.js:92:8)

at Protocol._parsePacket (/root/doctracing/node_modules/mysql/lib/protocol/Protocol.js:278:23)

at Parser.write (/root/doctracing/node_modules/mysql/lib/protocol/Parser.js:76:12) errno: 'EPIPE', code: 'EPIPE', syscall: 'write', fatal: true }

简单的来说就是访问数据库出问题了，遇到这个问题，解决方式如下：

再my.ini中添加

max_allowed_packet = 1024M

然后重启mysql即可。

文章作者：沃航科技