MySQL Batch write data error: Mysql_query:lost connection to MySQL server during query

Scene:

Error when writing data to MySQL Replace in bulk.

Workaround:

1. Increase the value of Max_allowed_packet in MySQL database configuration

Max_allowed_packet = 1G (default is 1M, maximum 1G only)

2. Check the query timeout parameter set in the MySQL connection function in your code:mysql_opt_read_timeout, you can set a larger point

　　　　

The query time-out is 3 times times the Optvalue. That's 10*3=30s.

If Mysql_opt_reconnect () is set, then mysql_query () can be automatically re-connected.

See also: https://www.cnblogs.com/joeblackzqq/p/5614948.html

MySQL Batch write data error: Mysql_query:lost connection to MySQL server during query