Debian Codegraph @

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

raw
1 select * from performance_schema.setup_actors;
2 HOST USER ROLE ENABLED HISTORY
3 % % % YES YES
4 truncate table performance_schema.setup_actors;
5 insert into performance_schema.setup_actors
6 values ('localhost', 'user1', '%', 'YES', 'YES');
7 insert into performance_schema.setup_actors
8 values ('localhost', 'user2', '%', 'YES', 'NO');
9 insert into performance_schema.setup_actors
10 values ('localhost', 'user3', '%', 'NO', 'YES');
11 insert into performance_schema.setup_actors
12 values ('localhost', 'user4', '%', 'NO', 'NO');
13 create user user1@localhost;
14 create user user2@localhost;
15 create user user3@localhost;
16 create user user4@localhost;
17 grant ALL on *.* to user1@localhost;
18 grant ALL on *.* to user2@localhost;
19 grant ALL on *.* to user3@localhost;
20 grant ALL on *.* to user4@localhost;
21 flush privileges;
22 # Switch to (con1, localhost, user1, , )
23 connect con1, localhost, user1, , ;
24 select NAME, TYPE, INSTRUMENTED, HISTORY, PROCESSLIST_USER, PROCESSLIST_HOST
25 from performance_schema.threads
26 where PROCESSLIST_ID = connection_id();
27 NAME TYPE INSTRUMENTED HISTORY PROCESSLIST_USER PROCESSLIST_HOST
28 thread/sql/one_connection FOREGROUND YES YES user1 localhost
29 # Switch to (con2, localhost, user2, , )
30 connect con2, localhost, user2, , ;
31 select NAME, TYPE, INSTRUMENTED, HISTORY, PROCESSLIST_USER, PROCESSLIST_HOST
32 from performance_schema.threads
33 where PROCESSLIST_ID = connection_id();
34 NAME TYPE INSTRUMENTED HISTORY PROCESSLIST_USER PROCESSLIST_HOST
35 thread/sql/one_connection FOREGROUND YES NO user2 localhost
36 # Switch to (con3, localhost, user3, , )
37 connect con3, localhost, user3, , ;
38 select NAME, TYPE, INSTRUMENTED, HISTORY, PROCESSLIST_USER, PROCESSLIST_HOST
39 from performance_schema.threads
40 where PROCESSLIST_ID = connection_id();
41 NAME TYPE INSTRUMENTED HISTORY PROCESSLIST_USER PROCESSLIST_HOST
42 thread/sql/one_connection FOREGROUND NO YES user3 localhost
43 # Switch to (con4, localhost, user4, , )
44 connect con4, localhost, user4, , ;
45 select NAME, TYPE, INSTRUMENTED, HISTORY, PROCESSLIST_USER, PROCESSLIST_HOST
46 from performance_schema.threads
47 where PROCESSLIST_ID = connection_id();
48 NAME TYPE INSTRUMENTED HISTORY PROCESSLIST_USER PROCESSLIST_HOST
49 thread/sql/one_connection FOREGROUND NO NO user4 localhost
50 # Switch to connection default
51 connection default;
52 update performance_schema.setup_actors
53 set HISTORY='NO' where USER in ('user1', 'user3');
54 update performance_schema.setup_actors
55 set HISTORY='YES' where USER in ('user2', 'user4');
56 # Switch to connection con1
57 connection con1;
58 select NAME, TYPE, INSTRUMENTED, HISTORY, PROCESSLIST_USER, PROCESSLIST_HOST
59 from performance_schema.threads
60 where PROCESSLIST_ID = connection_id();
61 NAME TYPE INSTRUMENTED HISTORY PROCESSLIST_USER PROCESSLIST_HOST
62 thread/sql/one_connection FOREGROUND YES YES user1 localhost
63 # Switch to connection con2
64 connection con2;
65 select NAME, TYPE, INSTRUMENTED, HISTORY, PROCESSLIST_USER, PROCESSLIST_HOST
66 from performance_schema.threads
67 where PROCESSLIST_ID = connection_id();
68 NAME TYPE INSTRUMENTED HISTORY PROCESSLIST_USER PROCESSLIST_HOST
69 thread/sql/one_connection FOREGROUND YES NO user2 localhost
70 # Switch to connection con3
71 connection con3;
72 select NAME, TYPE, INSTRUMENTED, HISTORY, PROCESSLIST_USER, PROCESSLIST_HOST
73 from performance_schema.threads
74 where PROCESSLIST_ID = connection_id();
75 NAME TYPE INSTRUMENTED HISTORY PROCESSLIST_USER PROCESSLIST_HOST
76 thread/sql/one_connection FOREGROUND NO YES user3 localhost
77 # Switch to connection con4
78 connection con4;
79 select NAME, TYPE, INSTRUMENTED, HISTORY, PROCESSLIST_USER, PROCESSLIST_HOST
80 from performance_schema.threads
81 where PROCESSLIST_ID = connection_id();
82 NAME TYPE INSTRUMENTED HISTORY PROCESSLIST_USER PROCESSLIST_HOST
83 thread/sql/one_connection FOREGROUND NO NO user4 localhost
84 # Disconnect all con
85 disconnect con1;
86 disconnect con2;
87 disconnect con3;
88 disconnect con4;
89 # Switch to (con1, localhost, user1, , )
90 connect con1, localhost, user1, , ;
91 select NAME, TYPE, INSTRUMENTED, HISTORY, PROCESSLIST_USER, PROCESSLIST_HOST
92 from performance_schema.threads
93 where PROCESSLIST_ID = connection_id();
94 NAME TYPE INSTRUMENTED HISTORY PROCESSLIST_USER PROCESSLIST_HOST
95 thread/sql/one_connection FOREGROUND YES NO user1 localhost
96 # Switch to (con2 localhost, user2, , )
97 connect con2, localhost, user2, , ;
98 select NAME, TYPE, INSTRUMENTED, HISTORY, PROCESSLIST_USER, PROCESSLIST_HOST
99 from performance_schema.threads
100 where PROCESSLIST_ID = connection_id();
101 NAME TYPE INSTRUMENTED HISTORY PROCESSLIST_USER PROCESSLIST_HOST
102 thread/sql/one_connection FOREGROUND YES YES user2 localhost
103 # Switch to (con3, localhost, user3, , )
104 connect con3, localhost, user3, , ;
105 select NAME, TYPE, INSTRUMENTED, HISTORY, PROCESSLIST_USER, PROCESSLIST_HOST
106 from performance_schema.threads
107 where PROCESSLIST_ID = connection_id();
108 NAME TYPE INSTRUMENTED HISTORY PROCESSLIST_USER PROCESSLIST_HOST
109 thread/sql/one_connection FOREGROUND NO NO user3 localhost
110 # Switch to (con4 localhost, user4, , )
111 connect con4, localhost, user4, , ;
112 select NAME, TYPE, INSTRUMENTED, HISTORY, PROCESSLIST_USER, PROCESSLIST_HOST
113 from performance_schema.threads
114 where PROCESSLIST_ID = connection_id();
115 NAME TYPE INSTRUMENTED HISTORY PROCESSLIST_USER PROCESSLIST_HOST
116 thread/sql/one_connection FOREGROUND NO YES user4 localhost
117 # Disconnect all con
118 disconnect con1;
119 disconnect con2;
120 disconnect con3;
121 disconnect con4;
122 # Switch to connection default
123 connection default;
124 revoke all privileges, grant option from user1@localhost;
125 revoke all privileges, grant option from user2@localhost;
126 revoke all privileges, grant option from user3@localhost;
127 revoke all privileges, grant option from user4@localhost;
128 drop user user1@localhost;
129 drop user user2@localhost;
130 drop user user3@localhost;
131 drop user user4@localhost;
132 flush privileges;
133 truncate table performance_schema.setup_actors;
134 insert into performance_schema.setup_actors
135 values ('%', '%', '%', 'YES', 'YES');
136 select * from performance_schema.setup_actors;
137 HOST USER ROLE ENABLED HISTORY
138 % % % YES YES