← Back to branch summary

~michaeleguo/ubuntu/trusty/percona-xtradb-cluster-5.5/arm64fix

« back to all changes in this revision

Viewing changes to mysql-test/suite/innodb/r/percona_innodb_kill_idle_trx_locks.result

  • Committer: Package Import Robot
  • Author(s): James Page
  • Date: 2014-02-10 14:44:23 UTC
  • Revision ID: package-import@ubuntu.com-20140210144423-f2134l2gxuvq2m6l
Tags: upstream-5.5.34-25.9+dfsg
Import upstream version 5.5.34-25.9+dfsg

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/innodb/r/percona_innodb_kill_idle_trx_locks.result
 
1
DROP TABLE IF EXISTS t1;
 
2
SET autocommit=0;
 
3
CREATE TABLE t1 (a INT) ENGINE=InnoDB;
 
4
SHOW GLOBAL VARIABLES LIKE 'innodb_kill_idle_transaction';
 
5
Variable_name   Value
 
6
innodb_kill_idle_transaction    0
 
7
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='innodb_kill_idle_transaction';
 
8
VARIABLE_NAME   VARIABLE_VALUE
 
9
INNODB_KILL_IDLE_TRANSACTION    0
 
10
SET GLOBAL innodb_kill_idle_transaction=5;
 
11
SHOW GLOBAL VARIABLES LIKE 'innodb_kill_idle_transaction';
 
12
Variable_name   Value
 
13
innodb_kill_idle_transaction    5
 
14
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='innodb_kill_idle_transaction';
 
15
VARIABLE_NAME   VARIABLE_VALUE
 
16
INNODB_KILL_IDLE_TRANSACTION    5
 
17
BEGIN;
 
18
INSERT INTO t1 VALUES (1),(2),(3);
 
19
COMMIT;
 
20
SELECT * FROM t1;
 
21
a
 
22
1
 
23
2
 
24
3
 
25
### Locking rows. Lock should be released when idle trx is killed.
 
26
BEGIN;
 
27
SELECT * FROM t1 FOR UPDATE;
 
28
a
 
29
1
 
30
2
 
31
3
 
32
UPDATE t1 set a=4;
 
33
SELECT * FROM t1;
 
34
a
 
35
4
 
36
4
 
37
4
 
38
DROP TABLE t1;
 
39
SET GLOBAL innodb_kill_idle_transaction=0;
 
40
SHOW GLOBAL VARIABLES LIKE 'innodb_kill_idle_transaction';
 
41
Variable_name   Value
 
42
innodb_kill_idle_transaction    0
 
43
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='innodb_kill_idle_transaction';
 
44
VARIABLE_NAME   VARIABLE_VALUE
 
45
INNODB_KILL_IDLE_TRANSACTION    0