[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