Modify max_allowed_packet VARIABLE


How is the way to change de max_allowed_packet variable?
I can see it with SHOW GLOBAL VARIABLES;
but SET GLOBAL max_allowed_packet=9999999; shows:
ERROR 1064 (42000): Unknown system variable ‘max_allowed_packet’

I’m trying to insert a huge text with a mysql sentence and throws a ’ MySQL server has gone away’ message.

Thanks in advance.

that could be changed only via config

Thanks for your reply,
Now I have to find where is the path of the configuration file (linux debian).
That part is missing in the documentation.
Thanks again.

I answer myself, /etc/sphinxsearch/sphinx.conf :slight_smile: