0

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.

halfer
  • 19,824
  • 17
  • 99
  • 186
Ghadeer
  • 608
  • 2
  • 7
  • 21
  • is your server running on a vm ? – guigoz Mar 15 '18 at 14:08
  • No. It is on Mac machine – Ghadeer Mar 15 '18 at 14:08
  • Please read [Under what circumstances may I add “urgent” or other similar phrases to my question, in order to obtain faster answers?](//meta.stackoverflow.com/q/326569) - the summary is that this is not an ideal way to address volunteers, and is probably counterproductive to obtaining answers. Please refrain from adding this to your questions. – halfer Mar 17 '18 at 00:39
  • @ghadeer What is the result displayed when you SHOW GLOBAL VARIABLES LIKE 'max_allowed_packet'; ? This is different than SHOW VARIABLE LIKE 'max_allowed_packet'; that will display the 'session' value for the variable. – Wilson Hauck Apr 02 '18 at 19:31

0 Answers0