MySQL 5.7 has gone away

I think that you need to increase max_allowed_packet because the largest possible packet that can be transmitted 1GB

https://dev.mysql.com/doc/refman/5.5/en/packet-too-large.html

Thanks @tomopongrac It is set to 1073741824 by default and I think it is considered as 1 GB as it is suggested here https://prnt.sc/p9q1xu

I didn't find on the web on how to change brew installed MySQL config. Any tips will be appreciated.

In terminal type this command to find where is my.cnf file is

mysql --verbose --help | grep my.cnf

Then in my.cnf file add this to change max_allowed_packet

max_allowed_packet = ???

and then you need to restart mysql

Thanks @tomopongrac There were many locations, the one that took effect was ~/.my.cnf Thanks!

Setting max_allowed_packet to a lower value (500 MB) didn't resolve the issue. So it still persists. Anyone having the same issue?

I belive @tomopongrac suggested that you increse it instead of lowering it. But instead I would suggest you use something like laravel telescope to inspect the queries run. If you are only running smaller queries on a small database, you shouldnt hit 1 GB

@resin The issue was suspected to be Packet Too Large if max_allowed_packet is more than 1GB. So lowering the value could resolve it if it was the issue. However, it was not. If MySQL goes away, I am afraid, Telescope could hardly be of any help.

Oh sorry, I misunderstood :) Does your logs reveal anything?

I ended up installing MySQL 8 with Homebrew and switching to it. It seems it has resolved the issue. Thanks everyone for input!