Mysql's longblob field insertion data problem solved

  • 2020-06-07 05:27:25
  • OfStack

One problem with mysql is the optimization of mysql, where the longblob field was default to 1M in version 5.5.

To change this problem, a few points need to be noted:

com.mysql.jdbc.PacketTooBigException: Packet for query is too large (2054817 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.

Reason: myslq default configuration minimum change required: in ES15en.ini configuration parameters (max_allowed_packet=1024M);

But adding parameters to the [client] and [mysql] sections has no effect and appears to be a client-read parameter. So pay attention to that.

Related articles: