1
by brian
clean slate |
1 |
set global general_log= OFF; |
2 |
truncate table mysql.general_log; |
|
3 |
truncate table mysql.slow_log; |
|
4 |
show global variables |
|
5 |
where Variable_name = 'log' or Variable_name = 'log_slow_queries' or |
|
6 |
Variable_name = 'general_log' or Variable_name = 'slow_query_log'; |
|
7 |
Variable_name Value |
|
8 |
general_log OFF |
|
9 |
log OFF |
|
10 |
log_slow_queries OFF |
|
11 |
slow_query_log OFF |
|
12 |
flush logs; |
|
13 |
set global general_log= ON; |
|
14 |
create table t1(f1 int); |
|
15 |
select * from mysql.general_log; |
|
16 |
event_time user_host thread_id server_id command_type argument |
|
17 |
TIMESTAMP USER_HOST # 1 Query create table t1(f1 int) |
|
18 |
TIMESTAMP USER_HOST # 1 Query select * from mysql.general_log |
|
19 |
set global general_log= OFF; |
|
20 |
drop table t1; |
|
21 |
select * from mysql.general_log; |
|
22 |
event_time user_host thread_id server_id command_type argument |
|
23 |
TIMESTAMP USER_HOST # 1 Query create table t1(f1 int) |
|
24 |
TIMESTAMP USER_HOST # 1 Query select * from mysql.general_log |
|
25 |
TIMESTAMP USER_HOST # 1 Query set global general_log= OFF |
|
26 |
set global general_log= ON; |
|
27 |
flush logs; |
|
28 |
show global variables |
|
29 |
where Variable_name = 'log' or Variable_name = 'log_slow_queries' or |
|
30 |
Variable_name = 'general_log' or Variable_name = 'slow_query_log'; |
|
31 |
Variable_name Value |
|
32 |
general_log ON |
|
33 |
log ON |
|
34 |
log_slow_queries OFF |
|
35 |
slow_query_log OFF |
|
36 |
set session long_query_time=1; |
|
37 |
select sleep(2); |
|
38 |
sleep(2) |
|
39 |
0
|
|
40 |
select * from mysql.slow_log where sql_text NOT LIKE '%slow_log%'; |
|
41 |
start_time user_host query_time lock_time rows_sent rows_examined db last_insert_id insert_id server_id sql_text |
|
42 |
set global slow_query_log= ON; |
|
43 |
set session long_query_time=1; |
|
44 |
select sleep(2); |
|
45 |
sleep(2) |
|
46 |
0
|
|
47 |
select * from mysql.slow_log where sql_text NOT LIKE '%slow_log%'; |
|
48 |
start_time user_host query_time lock_time rows_sent rows_examined db last_insert_id insert_id server_id sql_text |
|
49 |
TIMESTAMP USER_HOST QUERY_TIME 00:00:00 1 0 test 0 0 1 select sleep(2) |
|
50 |
show global variables |
|
51 |
where Variable_name = 'log' or Variable_name = 'log_slow_queries' or |
|
52 |
Variable_name = 'general_log' or Variable_name = 'slow_query_log'; |
|
53 |
Variable_name Value |
|
54 |
general_log ON |
|
55 |
log ON |
|
56 |
log_slow_queries ON |
|
57 |
slow_query_log ON |
|
58 |
set global general_log= ON; |
|
59 |
set global general_log= OFF; |
|
60 |
set global general_log= OFF; |
|
61 |
set global slow_query_log= ON; |
|
62 |
set global slow_query_log= OFF; |
|
63 |
set global slow_query_log= OFF; |
|
64 |
set global general_log= ON; |
|
65 |
truncate table mysql.general_log; |
|
66 |
create table t1(f1 int); |
|
67 |
drop table t1; |
|
68 |
select * from mysql.general_log; |
|
69 |
event_time user_host thread_id server_id command_type argument |
|
70 |
TIMESTAMP USER_HOST # 1 Query create table t1(f1 int) |
|
71 |
TIMESTAMP USER_HOST # 1 Query drop table t1 |
|
72 |
TIMESTAMP USER_HOST # 1 Query select * from mysql.general_log |
|
73 |
set global general_log= OFF; |
|
74 |
truncate table mysql.general_log; |
|
75 |
select * from mysql.general_log; |
|
76 |
event_time user_host thread_id server_id command_type argument |
|
77 |
set global general_log= ON; |
|
78 |
show global variables |
|
79 |
where Variable_name = 'log' or Variable_name = 'log_slow_queries' or |
|
80 |
Variable_name = 'general_log' or Variable_name = 'slow_query_log'; |
|
81 |
Variable_name Value |
|
82 |
general_log ON |
|
83 |
log ON |
|
84 |
log_slow_queries OFF |
|
85 |
slow_query_log OFF |
|
86 |
show variables like 'general_log_file'; |
|
87 |
Variable_name Value |
|
88 |
general_log_file # |
|
89 |
show variables like 'slow_query_log_file'; |
|
90 |
Variable_name Value |
|
91 |
slow_query_log_file # |
|
92 |
show variables like 'log_output'; |
|
93 |
Variable_name Value |
|
94 |
log_output FILE,TABLE |
|
95 |
set global general_log_file='/not exiting path/log.master'; |
|
96 |
ERROR 42000: Variable 'general_log_file' can't be set to the value of '/not exiting path/log.master' |
|
97 |
set global general_log_file='MYSQLTEST_VARDIR'; |
|
98 |
ERROR 42000: Variable 'general_log_file' can't be set to the value of 'MYSQLTEST_VARDIR' |
|
99 |
set global general_log_file=''; |
|
100 |
ERROR 42000: Variable 'general_log_file' can't be set to the value of '' |
|
101 |
show variables like 'general_log_file'; |
|
102 |
Variable_name Value |
|
103 |
general_log_file # |
|
104 |
set global general_log= OFF; |
|
105 |
set global general_log_file='MYSQLTEST_VARDIR/tmp/log.master'; |
|
106 |
set global general_log= ON; |
|
107 |
create table t1(f1 int); |
|
108 |
drop table t1; |
|
109 |
set global general_log= OFF; |
|
110 |
set global general_log_file=default; |
|
111 |
set global general_log= ON; |
|
112 |
create table t1(f1 int); |
|
113 |
drop table t1; |
|
114 |
show variables like 'general_log_file'; |
|
115 |
Variable_name Value |
|
116 |
general_log_file # |
|
117 |
show variables like 'slow_query_log_file'; |
|
118 |
Variable_name Value |
|
119 |
slow_query_log_file # |
|
120 |
set global general_log= default; |
|
121 |
set global slow_query_log= default; |
|
122 |
set global general_log_file= default; |
|
123 |
set global slow_query_log_file= default; |
|
124 |
show variables like 'general_log'; |
|
125 |
Variable_name Value |
|
126 |
general_log OFF |
|
127 |
show variables like 'slow_query_log'; |
|
128 |
Variable_name Value |
|
129 |
slow_query_log OFF |
|
130 |
set global general_log=ON; |
|
131 |
set global log_output=default; |
|
132 |
show variables like 'log_output'; |
|
133 |
Variable_name Value |
|
134 |
log_output FILE |
|
135 |
set global general_log=OFF; |
|
136 |
set global log_output=FILE; |
|
137 |
truncate table mysql.general_log; |
|
138 |
show variables like 'log_output'; |
|
139 |
Variable_name Value |
|
140 |
log_output FILE |
|
141 |
set global general_log=ON; |
|
142 |
create table t1(f1 int); |
|
143 |
select * from mysql.general_log; |
|
144 |
event_time user_host thread_id server_id command_type argument |
|
145 |
set global general_log=OFF; |
|
146 |
set global log_output="FILE,TABLE"; |
|
147 |
show variables like 'log_output'; |
|
148 |
Variable_name Value |
|
149 |
log_output FILE,TABLE |
|
150 |
set global general_log=ON; |
|
151 |
drop table t1; |
|
152 |
select * from mysql.general_log; |
|
153 |
event_time user_host thread_id server_id command_type argument |
|
154 |
TIMESTAMP USER_HOST # 1 Query drop table t1 |
|
155 |
TIMESTAMP USER_HOST # 1 Query select * from mysql.general_log |
|
156 |
SET @old_general_log_state = @@global.general_log; |
|
157 |
SET @old_slow_log_state = @@global.slow_query_log; |
|
158 |
SET GLOBAL general_log = ON; |
|
159 |
SET GLOBAL slow_query_log = ON; |
|
160 |
FLUSH TABLES WITH READ LOCK; |
|
161 |
SET GLOBAL general_log = OFF; |
|
162 |
SET GLOBAL slow_query_log = OFF; |
|
163 |
UNLOCK TABLES; |
|
164 |
FLUSH TABLES WITH READ LOCK; |
|
165 |
SET GLOBAL general_log = ON; |
|
166 |
SET GLOBAL slow_query_log = ON; |
|
167 |
UNLOCK TABLES; |
|
168 |
SET GLOBAL READ_ONLY = ON; |
|
169 |
SET GLOBAL general_log = OFF; |
|
170 |
SET GLOBAL slow_query_log = OFF; |
|
171 |
SET GLOBAL READ_ONLY = OFF; |
|
172 |
SET GLOBAL READ_ONLY = ON; |
|
173 |
SET GLOBAL general_log = ON; |
|
174 |
SET GLOBAL slow_query_log = ON; |
|
175 |
SET GLOBAL READ_ONLY = OFF; |
|
176 |
SET GLOBAL general_log = @old_general_log_state; |
|
177 |
SET GLOBAL slow_query_log = @old_slow_log_state; |
|
178 |
SET @old_general_log_state = @@global.general_log; |
|
179 |
SET @old_slow_log_state = @@global.slow_query_log; |
|
180 |
SHOW VARIABLES LIKE 'general_log'; |
|
181 |
Variable_name Value |
|
182 |
general_log ON |
|
183 |
SHOW VARIABLES LIKE 'log'; |
|
184 |
Variable_name Value |
|
185 |
log ON |
|
186 |
SELECT @@general_log, @@log; |
|
187 |
@@general_log @@log |
|
188 |
1 1 |
|
189 |
SET GLOBAL log = 0; |
|
190 |
SHOW VARIABLES LIKE 'general_log'; |
|
191 |
Variable_name Value |
|
192 |
general_log OFF |
|
193 |
SHOW VARIABLES LIKE 'log'; |
|
194 |
Variable_name Value |
|
195 |
log OFF |
|
196 |
SELECT @@general_log, @@log; |
|
197 |
@@general_log @@log |
|
198 |
0 0 |
|
199 |
SET GLOBAL general_log = 1; |
|
200 |
SHOW VARIABLES LIKE 'general_log'; |
|
201 |
Variable_name Value |
|
202 |
general_log ON |
|
203 |
SHOW VARIABLES LIKE 'log'; |
|
204 |
Variable_name Value |
|
205 |
log ON |
|
206 |
SELECT @@general_log, @@log; |
|
207 |
@@general_log @@log |
|
208 |
1 1 |
|
209 |
SHOW VARIABLES LIKE 'slow_query_log'; |
|
210 |
Variable_name Value |
|
211 |
slow_query_log OFF |
|
212 |
SHOW VARIABLES LIKE 'log_slow_queries'; |
|
213 |
Variable_name Value |
|
214 |
log_slow_queries OFF |
|
215 |
SELECT @@slow_query_log, @@log_slow_queries; |
|
216 |
@@slow_query_log @@log_slow_queries |
|
217 |
0 0 |
|
218 |
SET GLOBAL log_slow_queries = 0; |
|
219 |
SHOW VARIABLES LIKE 'slow_query_log'; |
|
220 |
Variable_name Value |
|
221 |
slow_query_log OFF |
|
222 |
SHOW VARIABLES LIKE 'log_slow_queries'; |
|
223 |
Variable_name Value |
|
224 |
log_slow_queries OFF |
|
225 |
SELECT @@slow_query_log, @@log_slow_queries; |
|
226 |
@@slow_query_log @@log_slow_queries |
|
227 |
0 0 |
|
228 |
SET GLOBAL slow_query_log = 1; |
|
229 |
SHOW VARIABLES LIKE 'slow_query_log'; |
|
230 |
Variable_name Value |
|
231 |
slow_query_log ON |
|
232 |
SHOW VARIABLES LIKE 'log_slow_queries'; |
|
233 |
Variable_name Value |
|
234 |
log_slow_queries ON |
|
235 |
SELECT @@slow_query_log, @@log_slow_queries; |
|
236 |
@@slow_query_log @@log_slow_queries |
|
237 |
1 1 |
|
238 |
SET GLOBAL general_log = @old_general_log_state; |
|
239 |
SET GLOBAL slow_query_log = @old_slow_log_state; |
|
240 |
set @old_general_log_file= @@global.general_log_file; |
|
241 |
set @old_slow_query_log_file= @@global.slow_query_log_file; |
|
242 |
set global general_log_file= concat('/not exiting path/log.maste', 'r'); |
|
243 |
ERROR 42000: Variable 'general_log_file' can't be set to the value of '/not exiting path/log.master' |
|
244 |
set global general_log_file= NULL; |
|
245 |
ERROR 42000: Variable 'general_log_file' can't be set to the value of 'NULL' |
|
246 |
set global slow_query_log_file= concat('/not exiting path/log.maste', 'r'); |
|
247 |
ERROR 42000: Variable 'slow_query_log_file' can't be set to the value of '/not exiting path/log.master' |
|
248 |
set global slow_query_log_file= NULL; |
|
249 |
ERROR 42000: Variable 'slow_query_log_file' can't be set to the value of 'NULL' |
|
250 |
set global general_log_file= @old_general_log_file; |
|
251 |
set global slow_query_log_file= @old_slow_query_log_file; |
|
252 |
||
253 |
# --
|
|
254 |
# -- Bug#32748: Inconsistent handling of assignments to
|
|
255 |
# -- general_log_file/slow_query_log_file.
|
|
256 |
# --
|
|
257 |
||
258 |
SET @general_log_file_saved = @@global.general_log_file; |
|
259 |
SET @slow_query_log_file_saved = @@global.slow_query_log_file; |
|
260 |
||
261 |
SET GLOBAL general_log_file = 'bug32748.query.log'; |
|
262 |
SET GLOBAL slow_query_log_file = 'bug32748.slow.log'; |
|
263 |
||
264 |
SHOW VARIABLES LIKE '%log_file'; |
|
265 |
Variable_name Value |
|
266 |
general_log_file bug32748.query.log |
|
267 |
slow_query_log_file bug32748.slow.log |
|
268 |
||
269 |
SET GLOBAL general_log_file = @general_log_file_saved; |
|
270 |
SET GLOBAL slow_query_log_file = @slow_query_log_file_saved; |
|
271 |
||
272 |
# -- End of Bug#32748.
|
|
273 |
End of 5.1 tests |