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.
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.