[MDEV-28286] mariadb-dump --net-buffer-length Created: 2022-04-11  Updated: 2022-05-10  Resolved: 2022-05-10

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

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


 Description   

This week I learned that --net-buffer-length can help to reduce the size of a line/statement in the dump. This was important to solve an issue with Galera Cluster with too long rows for a schema restore throttling the whole cluster...

Checking the docu: https://mariadb.com/kb/en/mariadb-dumpmysqldump/

"The initial size of the buffer for client/server communication. When creating multiple-row INSERT statements (as with the --extended-insert or --opt option), mysqldump creates rows up to net_buffer_length length. If you increase this variable, you should also ensure that the net_buffer_length variable in the MariaDB server is at least this large."

It is IMHO not too obvious. Something like "net-buffer-length can limit the size of a row in the dump" would make it more clear.


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