max_allowed_packet in my.cnf is not reflected in MySql 5.7

2.1k Views Asked by At

We have changed the value of "max_allowed_packet" in my.cnf to

[mysqld]
max_allowed_packet = 200M

but, when we show variables like 'max_allowed_packet';, we get the "max_allowed_packet" as 4194304.

We tried to set global max_allowed_packet=209715200;, but we get "Packet for query is too large (41867758 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable." error.

0

There are 0 best solutions below