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