Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --source include/not_hypergraph.inc # Fails because of bug#34096590.
4
5 CREATE USER user1@localhost;
6 CREATE USER user2@localhost;
7 CREATE USER user3@localhost;
8
9 grant ALL on *.* to user1@localhost;
10 grant ALL on *.* to user2@localhost;
11 grant ALL on *.* to user3@localhost;
12
13 TRUNCATE TABLE performance_schema.accounts;
14
15 FLUSH PRIVILEGES;
16
17 CREATE TABLE test.t_range(a int, b int, PRIMARY KEY(a));
18
19 INSERT INTO test.t_range values (1, 1), (2,2), (3, 3), (4, 4), (5, 5);
20 INSERT INTO test.t_range values (6, 6), (7,7), (8, 8), (9, 9), (10, 10);
21
22 FLUSH STATUS;
23
24 let $initial= `SELECT VARIABLE_VALUE FROM performance_schema.global_status WHERE VARIABLE_NAME = 'Select_range'`;
25
26 # Causes Select_range to increment (+1)
27 SELECT * from test.t_range where (a >= 3) AND (a <= 5);
28
29 SELECT * from performance_schema.session_status
30 WHERE VARIABLE_NAME = 'Select_range';
31
32 --disable_query_log
33 eval SELECT VARIABLE_NAME, (VARIABLE_VALUE - $initial) AS DELTA from performance_schema.global_status WHERE VARIABLE_NAME = 'Select_range';
34 --enable_query_log
35
36 connect(con1, localhost, user1,,);
37 # Causes Select_range to increment (+1)
38 SELECT * from test.t_range where (a >= 3) AND (a <= 5);
39
40 SELECT * from performance_schema.session_status
41 WHERE VARIABLE_NAME = 'Select_range';
42
43 --disable_query_log
44 eval SELECT VARIABLE_NAME, (VARIABLE_VALUE - $initial) AS DELTA from performance_schema.global_status WHERE VARIABLE_NAME = 'Select_range';
45 --enable_query_log
46
47 connect(con2, localhost, user2,,);
48 # Causes Select_range to increment (+2)
49 SELECT * from test.t_range where (a >= 3) AND (a <= 5);
50 SELECT * from test.t_range where (a >= 4) AND (a <= 6);
51
52 SELECT * from performance_schema.session_status
53 WHERE VARIABLE_NAME = 'Select_range';
54
55 --disable_query_log
56 eval SELECT VARIABLE_NAME, (VARIABLE_VALUE - $initial) AS DELTA from performance_schema.global_status WHERE VARIABLE_NAME = 'Select_range';
57 --enable_query_log
58
59 connect(con3, localhost, user3,,);
60 # Causes Select_range to increment (+3)
61 SELECT * from test.t_range where (a >= 3) AND (a <= 5);
62 SELECT * from test.t_range where (a >= 4) AND (a <= 6);
63 SELECT * from test.t_range where (a >= 5) AND (a <= 7);
64
65 SELECT * from performance_schema.session_status
66 WHERE VARIABLE_NAME = 'Select_range';
67
68 --disable_query_log
69 eval SELECT VARIABLE_NAME, (VARIABLE_VALUE - $initial) AS DELTA from performance_schema.global_status WHERE VARIABLE_NAME = 'Select_range';
70 --enable_query_log
71
72 --connection default
73
74 --disable_query_log
75 eval SELECT VARIABLE_NAME, (VARIABLE_VALUE - $initial) AS DELTA from performance_schema.global_status WHERE VARIABLE_NAME = 'Select_range';
76 --enable_query_log
77
78 SELECT `USER`, `HOST`, VARIABLE_NAME, VARIABLE_VALUE
79 FROM performance_schema.status_by_account WHERE VARIABLE_NAME = 'Select_range'
80 AND `USER` LIKE 'user%'
81 ORDER BY `USER`;
82
83 --disconnect con1
84 --disconnect con2
85
86 # Wait till all disconnects are completed
87 let $count_sessions= 2;
88 --source include/wait_until_count_sessions.inc
89
90 --disable_query_log
91 eval SELECT VARIABLE_NAME, (VARIABLE_VALUE - $initial) AS DELTA from performance_schema.global_status WHERE VARIABLE_NAME = 'Select_range';
92 --enable_query_log
93
94 TRUNCATE TABLE performance_schema.accounts;
95
96 --disable_query_log
97 eval SELECT VARIABLE_NAME, (VARIABLE_VALUE - $initial) AS DELTA from performance_schema.global_status WHERE VARIABLE_NAME = 'Select_range';
98 --enable_query_log
99
100 --disconnect con3
101
102 # Wait till all disconnects are completed
103 let $count_sessions= 1;
104 --source include/wait_until_count_sessions.inc
105
106 --disable_query_log
107 eval SELECT VARIABLE_NAME, (VARIABLE_VALUE - $initial) AS DELTA from performance_schema.global_status WHERE VARIABLE_NAME = 'Select_range';
108 --enable_query_log
109
110 # Make sure TRUNCATE on accounts does not add to global_status
111 TRUNCATE TABLE performance_schema.accounts;
112
113 --disable_query_log
114 eval SELECT VARIABLE_NAME, (VARIABLE_VALUE - $initial) AS DELTA from performance_schema.global_status WHERE VARIABLE_NAME = 'Select_range';
115 --enable_query_log
116
117 DROP TABLE test.t_range;
118
119 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user1@localhost;
120 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user2@localhost;
121 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user3@localhost;
122 DROP USER user1@localhost;
123 DROP USER user2@localhost;
124 DROP USER user3@localhost;
125
126 FLUSH PRIVILEGES;
127