[MDEV-28287] Missmatch between docu and MariaDB defaults Created: 2022-04-11  Updated: 2022-05-11  Resolved: 2022-05-11

Status: Closed
Project: MariaDB Server
Component/s: Documentation, Server
Fix Version/s: N/A

Type: Task Priority: Minor
Reporter: Oli Sennhauser Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None


 Description   

On one side MariaDB documentations states for:

max_allowed_packet (server): "If this value is changed, it should be changed on the client side as well."

net_buffer_size (mariadb-dump): "If you increase this variable, you should also ensure that the net_buffer_length variable in the MariaDB server is at least this large."

On the other hand the defaults are:

SQL> SHOW GLOBAL VARIABLES LIKE ...
----------------------------+

Variable_name Value

----------------------------+

max_allowed_packet 16777216 -> conflict with docu
net_buffer_length 16384 -> conflict with docu
----------------------------+

mariadb-dump --help | grep -e buffer -e allow
max-allowed-packet 25165824 -> conflict with docu
net-buffer-length 1046528 -> conflict with docu

mariadb --help | grep -e buffer -e allow
max-allowed-packet 16777216 -> OK
net-buffer-length 16384 -> OK

So make the docu fitting the defaults or the other way around...

Sources:
https://mariadb.com/kb/en/server-system-variables/#max_allowed_packet
https://mariadb.com/kb/en/mariadb-dumpmysqldump/


Generated at Thu Feb 08 09:59:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.