diff options
author | Kentoku SHIBA <kentokushiba@gmail.com> | 2019-04-12 23:37:57 +0900 |
---|---|---|
committer | GitHub <noreply@github.com> | 2019-04-12 23:37:57 +0900 |
commit | 1e8279a958d746c67c1b251a49bd858c7d4f1f78 (patch) | |
tree | 65d2ad8c4565acf624088bd5dad7642612ba6100 /storage/spider/mysql-test/spider/bugfix/r/slave_trx_isolation.result | |
parent | 857310c218469dd496d582bbba4690cbb870c272 (diff) | |
download | mariadb-git-1e8279a958d746c67c1b251a49bd858c7d4f1f78.tar.gz |
MDEV-16530 Spider datanodes needs adjusted wait_timeout for long running queries on spider head node (#1258)
Add the following parameters.
- spider_remote_wait_timeout
Set remote wait_timeout at connecting for improvement performance of
connection if you know.
-1,0 : No set.
1 or more : Seconds.
The default value is -1
- spider_wait_timeout
The wait time to remote servers.
-1,0 : No set.
1 or more : Seconds.
The default value is 604800
Diffstat (limited to 'storage/spider/mysql-test/spider/bugfix/r/slave_trx_isolation.result')
-rw-r--r-- | storage/spider/mysql-test/spider/bugfix/r/slave_trx_isolation.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/storage/spider/mysql-test/spider/bugfix/r/slave_trx_isolation.result b/storage/spider/mysql-test/spider/bugfix/r/slave_trx_isolation.result index 06581a604a2..e93eb78417f 100644 --- a/storage/spider/mysql-test/spider/bugfix/r/slave_trx_isolation.result +++ b/storage/spider/mysql-test/spider/bugfix/r/slave_trx_isolation.result @@ -50,7 +50,7 @@ SELECT argument FROM mysql.general_log WHERE argument LIKE '%set %'; argument set session time_zone = '+00:00' SET NAMES utf8 -set session transaction isolation level read committed;set session autocommit = 1;start transaction +set session transaction isolation level read committed;set session autocommit = 1;set session wait_timeout = 604800;start transaction SELECT argument FROM mysql.general_log WHERE argument LIKE '%set %' SELECT pkey FROM tbl_a ORDER BY pkey; pkey |