Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
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.