diff options
| author | Mike Griffin <mg@webmail.us> | 2022-07-29 16:07:42 +1000 |
|---|---|---|
| committer | Daniel Black <daniel@mariadb.org> | 2022-08-02 20:31:08 +1000 |
| commit | 53c4e4d054cb5ac895535abc9815e70378dbf1b5 (patch) | |
| tree | d483afede383efe63772d54b7055cb6a15c786f1 /man | |
| parent | 5ac528a91f2d8a3b84e83b434b08fa9dc428f80c (diff) | |
| download | mariadb-git-53c4e4d054cb5ac895535abc9815e70378dbf1b5.tar.gz | |
MDEV-18702 mysqldump: add variable 'max-statement-time'
With a global non-default max-statement-time of a time interval that exceed
the query time mysqldump queries when doing a backup.
To solve both, add a max-statement-time option, defaulting to 0 (unlimited time).
Also like mariabackup, set the session wait_timeout=DEFAULT (28800). The
time/processing between mysqldump times isn't expected to get that
close ever, but let's adopt the standard of mariabackup as no-one has
challenged it has having a detrimental effect.
Reviewer and test case author Daniel Black
Diffstat (limited to 'man')
| -rw-r--r-- | man/mysqldump.1 | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/man/mysqldump.1 b/man/mysqldump.1 index ae6d76f24c3..140bc45c7c6 100644 --- a/man/mysqldump.1 +++ b/man/mysqldump.1 @@ -1361,6 +1361,21 @@ Sets the maximum packet length to send to or receive from server\&. .sp -1 .IP \(bu 2.3 .\} +.\" mysqldump: max-statement-time option +.\" max-statement-time option: mysqldump +\fB\-\-max\-statement\-time=\fR\fB\fIseconds\fR\fR +.sp +Sets the maximum time any statement can run before being timed out by the server. (Default value is 0 (no limit))\& +.RE +.sp +.RS 4 +.ie n \{\ +\h'-04'\(bu\h'+03'\c +.\} +.el \{\ +.sp -1 +.IP \(bu 2.3 +.\} .\" mysqldump: net-buffer-length option .\" net-buffer-length option: mysqldump \fB\-\-net\-buffer\-length=\fR\fB\fIlength\fR\fR @@ -2619,6 +2634,21 @@ The maximum size of the buffer for client/server communication\&. The maximum is .sp -1 .IP \(bu 2.3 .\} +max_statement_time +.sp +A query that has taken more than max_statement_time seconds will be aborted and the backup will +fail\&. The argument will be treated as a decimal value with microsecond precision\&. A value +of 0 (default) means no timeout\&. The maximum timeout is 31536000 seconds\&. +.RE +.sp +.RS 4 +.ie n \{\ +\h'-04'\(bu\h'+03'\c +.\} +.el \{\ +.sp -1 +.IP \(bu 2.3 +.\} net_buffer_length .sp The initial size of the buffer for client/server communication\&. When creating multiple\-row |