Debian Codegraph @

mysql-test/suite/perfschema/t/statement_program_concurrency.test

raw
1 #----------------------------------------------------------
2 # Concurrency check for instrumentation of stored programs
3 #----------------------------------------------------------
4
5
6 --source include/big_test.inc
7 # Test requires: sp-protocol/ps-protocol/view-protocol/cursor-protocol disabled
8 --source include/no_protocol.inc
9
10 TRUNCATE TABLE performance_schema.events_statements_summary_by_program;
11 TRUNCATE TABLE performance_schema.events_statements_history;
12
13 --echo # concurrency check through multi connections
14
15 # Save the initial number of concurrent sessions
16 --source include/count_sessions.inc
17
18 CREATE DATABASE db1;
19 CREATE DATABASE db2;
20 CREATE DATABASE db3;
21
22 # connection 1
23 connect (con1,localhost,root,,db1);
24
25 USE db1;
26
27 CREATE TABLE t1(
28 i INT NOT NULL
29 );
30
31 LOAD DATA INFILE '../../std_data/wl5766_data.txt' INTO TABLE t1;
32
33 DELIMITER |;
34 CREATE PROCEDURE proc()
35 BEGIN
36 INSERT INTO t1 SELECT * FROM t1;
37 END|
38 DELIMITER ;|
39
40 --send CALL proc();
41
42 # connection 2
43 connect (con2,localhost,root,,db2);
44
45 USE db2;
46
47 CREATE TABLE t2(
48 i INT NOT NULL
49 );
50
51 LOAD DATA INFILE '../../std_data/wl5766_data.txt' INTO TABLE t2;
52 DELIMITER |;
53 CREATE FUNCTION addition(x INT, y INT) RETURNS INT
54 BEGIN
55 INSERT INTO t2 SELECT * FROM t2;
56 RETURN x+y;
57 END|
58 DELIMITER ;|
59
60 --send SELECT addition(1234,9876);
61
62 # connection 3
63 connect (con3,localhost,root,,db3);
64
65 USE db3;
66
67 CREATE TABLE t(
68 i INT NOT NULL,
69 j INT
70 );
71
72 CREATE TABLE t3(
73 i INT NOT NULL
74 );
75
76 LOAD DATA INFILE '../../std_data/wl5766_data.txt' INTO TABLE t3;
77 INSERT INTO t VALUES ( 10,1000 );
78 CREATE TRIGGER trg AFTER INSERT ON t FOR EACH ROW
79 INSERT INTO t3 SELECT * FROM t3;
80
81 --send INSERT INTO t VALUES ( 20,2000);
82
83 connection con1;
84 --reap;
85
86 connection con2;
87 --reap;
88
89 connection con3;
90 --reap;
91
92 connection default;
93 --source include/wait_until_connected_again.inc
94
95 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, COUNT_STAR, COUNT_STATEMENTS
96 FROM performance_schema.events_statements_summary_by_program
97 WHERE OBJECT_SCHEMA='db1' OR OBJECT_SCHEMA='db2' OR OBJECT_SCHEMA='db3'
98 ORDER BY OBJECT_SCHEMA, OBJECT_NAME;
99
100 SELECT EVENT_NAME, SQL_TEXT, CURRENT_SCHEMA, OBJECT_TYPE, OBJECT_SCHEMA,
101 OBJECT_NAME, NESTING_EVENT_TYPE, NESTING_EVENT_LEVEL FROM
102 performance_schema.events_statements_history WHERE CURRENT_SCHEMA='db1'
103 OR CURRENT_SCHEMA='db2' OR CURRENT_SCHEMA='db3'
104 ORDER BY CURRENT_SCHEMA, OBJECT_NAME, EVENT_ID;
105
106 TRUNCATE TABLE performance_schema.events_statements_summary_by_program;
107 TRUNCATE TABLE performance_schema.events_statements_history;
108
109 --echo # Clean-up
110
111 DROP PROCEDURE db1.proc;
112 DROP FUNCTION db2.addition;
113 DROP TRIGGER db3.trg;
114
115 DROP TABLE db1.t1;
116 DROP TABLE db2.t2;
117 DROP TABLE db3.t3;
118 DROP TABLE db3.t;
119
120 DROP DATABASE db1;
121 DROP DATABASE db2;
122 DROP DATABASE db3;
123
124 disconnect con1;
125 disconnect con2;
126 disconnect con3;
127
128 # Wait till all disconnects are completed
129 --source include/wait_until_count_sessions.inc