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 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 SELECT * from test.t_range where (a >= 3) AND (a <= 5);
25 a b
26 3 3
27 4 4
28 5 5
29 SELECT * from performance_schema.session_status
30 WHERE VARIABLE_NAME = 'Select_range';
31 VARIABLE_NAME VARIABLE_VALUE
32 Select_range 1
33 VARIABLE_NAME DELTA
34 Select_range 2
35 SELECT * from test.t_range where (a >= 3) AND (a <= 5);
36 a b
37 3 3
38 4 4
39 5 5
40 SELECT * from test.t_range where (a >= 4) AND (a <= 6);
41 a b
42 4 4
43 5 5
44 6 6
45 SELECT * from performance_schema.session_status
46 WHERE VARIABLE_NAME = 'Select_range';
47 VARIABLE_NAME VARIABLE_VALUE
48 Select_range 2
49 VARIABLE_NAME DELTA
50 Select_range 4
51 SELECT * from test.t_range where (a >= 3) AND (a <= 5);
52 a b
53 3 3
54 4 4
55 5 5
56 SELECT * from test.t_range where (a >= 4) AND (a <= 6);
57 a b
58 4 4
59 5 5
60 6 6
61 SELECT * from test.t_range where (a >= 5) AND (a <= 7);
62 a b
63 5 5
64 6 6
65 7 7
66 SELECT * from performance_schema.session_status
67 WHERE VARIABLE_NAME = 'Select_range';
68 VARIABLE_NAME VARIABLE_VALUE
69 Select_range 3
70 VARIABLE_NAME DELTA
71 Select_range 7
72 VARIABLE_NAME DELTA
73 Select_range 7
74 SELECT `USER`, `HOST`, VARIABLE_NAME, VARIABLE_VALUE
75 FROM performance_schema.status_by_account WHERE VARIABLE_NAME = 'Select_range'
76 AND `USER` LIKE 'user%'
77 ORDER BY `USER`;
78 USER HOST VARIABLE_NAME VARIABLE_VALUE
79 user1 localhost Select_range 1
80 user2 localhost Select_range 2
81 user3 localhost Select_range 3
82 VARIABLE_NAME DELTA
83 Select_range 7
84 TRUNCATE TABLE performance_schema.accounts;
85 VARIABLE_NAME DELTA
86 Select_range 7
87 VARIABLE_NAME DELTA
88 Select_range 7
89 TRUNCATE TABLE performance_schema.accounts;
90 VARIABLE_NAME DELTA
91 Select_range 7
92 DROP TABLE test.t_range;
93 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user1@localhost;
94 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user2@localhost;
95 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user3@localhost;
96 DROP USER user1@localhost;
97 DROP USER user2@localhost;
98 DROP USER user3@localhost;
99 FLUSH PRIVILEGES;