[BlueOnyx:24923] Re: MariaDB - max_allowed_packet
Michael Stauber
mstauber at blueonyx.it
Wed Apr 21 13:38:00 -05 2021
Hi Colin,
> 5209R
>
> Is this just a default?
>
> MariaDB [(none)]> SHOW VARIABLES WHERE variable_name = 'max_allowed_packet';
>
> +--------------------+---------+
>
> | Variable_name | Value |
>
> +--------------------+---------+
>
> | max_allowed_packet | 1048576 |
Correct. That's the default:
https://mariadb.com/docs/reference/mdb/system-variables/max_allowed_packet/
> Can I add a line into my.cnf to increase it if needed?
Yes, you can either add it to /etc/my.cnf or (better) add it to the
respective config file in the directory /etc/my.cnf.d/. I believe the
correct place for it ought to be /etc/my.cnf.d/server.cnf
--
With best regards
Michael Stauber
More information about the Blueonyx
mailing list