[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. |