Debian Codegraph @

mysql-test/suite/perfschema/r/misc_global_status.result

raw
1 CREATE USER user1@localhost;
2 CREATE USER user2@localhost;
3 CREATE USER user3@localhost;
4 grant ALL on *.* to user1@localhost;
5 grant ALL on *.* to user2@localhost;
6 grant ALL on *.* to user3@localhost;
7 TRUNCATE TABLE performance_schema.accounts;
8 FLUSH PRIVILEGES;
9 CREATE TABLE test.t_range(a int, b int, PRIMARY KEY(a));
10 INSERT INTO test.t_range values (1, 1), (2,2), (3, 3), (4, 4), (5, 5);
11 INSERT INTO test.t_range values (6, 6), (7,7), (8, 8), (9, 9), (10, 10);
12 FLUSH GLOBAL STATUS;
13 SELECT * from test.t_range where (a >= 3) AND (a <= 5);
14 a b
15 3 3
16 4 4
17 5 5
18 SELECT * from performance_schema.session_status
19 WHERE VARIABLE_NAME = 'Select_range';
20 VARIABLE_NAME VARIABLE_VALUE
21 Select_range 1
22 VARIABLE_NAME DELTA
23 Select_range 1
24 connect con1, localhost, user1,,;
25 SELECT * from test.t_range where (a >= 3) AND (a <= 5);
26 a b
27 3 3
28 4 4
29 5 5
30 SELECT * from performance_schema.session_status
31 WHERE VARIABLE_NAME = 'Select_range';
32 VARIABLE_NAME VARIABLE_VALUE
33 Select_range 1
34 VARIABLE_NAME DELTA
35 Select_range 2
36 connect con2, localhost, user2,,;
37 SELECT * from test.t_range where (a >= 3) AND (a <= 5);
38 a b
39 3 3
40 4 4
41 5 5
42 SELECT * from test.t_range where (a >= 4) AND (a <= 6);
43 a b
44 4 4
45 5 5
46 6 6
47 SELECT * from performance_schema.session_status
48 WHERE VARIABLE_NAME = 'Select_range';
49 VARIABLE_NAME VARIABLE_VALUE
50 Select_range 2
51 VARIABLE_NAME DELTA
52 Select_range 4
53 connect con3, localhost, user3,,;
54 SELECT * from test.t_range where (a >= 3) AND (a <= 5);
55 a b
56 3 3
57 4 4
58 5 5
59 SELECT * from test.t_range where (a >= 4) AND (a <= 6);
60 a b
61 4 4
62 5 5
63 6 6
64 SELECT * from test.t_range where (a >= 5) AND (a <= 7);
65 a b
66 5 5
67 6 6
68 7 7
69 SELECT * from performance_schema.session_status
70 WHERE VARIABLE_NAME = 'Select_range';
71 VARIABLE_NAME VARIABLE_VALUE
72 Select_range 3
73 VARIABLE_NAME DELTA
74 Select_range 7
75 connection default;
76 VARIABLE_NAME DELTA
77 Select_range 7
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 USER HOST VARIABLE_NAME VARIABLE_VALUE
83 user1 localhost Select_range 1
84 user2 localhost Select_range 2
85 user3 localhost Select_range 3
86 disconnect con1;
87 disconnect con2;
88 VARIABLE_NAME DELTA
89 Select_range 7
90 TRUNCATE TABLE performance_schema.accounts;
91 VARIABLE_NAME DELTA
92 Select_range 7
93 disconnect con3;
94 VARIABLE_NAME DELTA
95 Select_range 7
96 TRUNCATE TABLE performance_schema.accounts;
97 VARIABLE_NAME DELTA
98 Select_range 7
99 DROP TABLE test.t_range;
100 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user1@localhost;
101 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user2@localhost;
102 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user3@localhost;
103 DROP USER user1@localhost;
104 DROP USER user2@localhost;
105 DROP USER user3@localhost;
106 FLUSH PRIVILEGES;