Modify max_allowed_packet VARIABLE

General Discussions - English
1

Hello,

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.

2

that could be changed only via config https://manticoresearch.gitlab.io/dev/conf_options_reference/searchd_program_configuration_options.html#max-packet-size

3

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.

4

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