mysql-test/main/profiling.result

7 profiling	OFF
9 select @@profiling;
10 @@profiling
16 profiling	OFF
18 set session profiling = ON;
22 profiling	ON
24 select @@profiling;
25 @@profiling
77 3	#	select @@profiling
117 select * from information_schema.profiling;
118 select query_id, state, duration from information_schema.profiling;
119 select query_id, sum(duration) from information_schema.profiling group by query_id;
120 select query_id, count(*) from information_schema.profiling group by query_id;
121 select sum(duration) from information_schema.profiling;
122 select query_id, count(*), sum(duration) from information_schema.profiling group by query_id;
123 …e_faults_minor, Swaps, Source_function, Source_file, Source_line from information_schema.profiling;
151 25	#	select * from information_schema.profiling
152 26	#	select query_id, state, duration from information_schema.profiling
153 27	#	select query_id, sum(duration) from information_schema.profiling group by query_id
154 28	#	select query_id, count(*) from information_schema.profiling group by query_id
155 29	#	select sum(duration) from information_schema.profiling
156 30	#	select query_id, count(*), sum(duration) from information_schema.profiling group by query_id
157 …ge_faults_minor, Swaps, Source_function, Source_file, Source_line from information_schema.profiling
187 25	#	select * from information_schema.profiling
188 26	#	select query_id, state, duration from information_schema.profiling
189 27	#	select query_id, sum(duration) from information_schema.profiling group by query_id
190 28	#	select query_id, count(*) from information_schema.profiling group by query_id
191 29	#	select sum(duration) from information_schema.profiling
192 30	#	select query_id, count(*), sum(duration) from information_schema.profiling group by query_id
193 …ge_faults_minor, Swaps, Source_function, Source_file, Source_line from information_schema.profiling
227 25	#	select * from information_schema.profiling
228 26	#	select query_id, state, duration from information_schema.profiling
229 27	#	select query_id, sum(duration) from information_schema.profiling group by query_id
230 28	#	select query_id, count(*) from information_schema.profiling group by query_id
231 29	#	select sum(duration) from information_schema.profiling
232 30	#	select query_id, count(*), sum(duration) from information_schema.profiling group by query_id
233 …ge_faults_minor, Swaps, Source_function, Source_file, Source_line from information_schema.profiling
247 set session profiling = OFF;
263 25	#	select * from information_schema.profiling
264 26	#	select query_id, state, duration from information_schema.profiling
265 27	#	select query_id, sum(duration) from information_schema.profiling group by query_id
266 28	#	select query_id, count(*) from information_schema.profiling group by query_id
267 29	#	select sum(duration) from information_schema.profiling
268 30	#	select query_id, count(*), sum(duration) from information_schema.profiling group by query_id
269 …ge_faults_minor, Swaps, Source_function, Source_file, Source_line from information_schema.profiling
283 set session profiling = ON;
284 select @@profiling;
285 @@profiling
288 select @@profiling;
289 @@profiling
306 select @@profiling;
307 @@profiling
309 set session profiling = OFF;
320 set profiling = ON;
321 select 'This p1 should show up in profiling';
322 insert into profile_log select count(*) from information_schema.profiling;
327 set profiling = ON;
329 select 'This p2 should show up in profiling';
334 set profiling = ON;
335 select 'This p3 should show up in profiling';
347 set session profiling = OFF;
349 set session profiling = OFF;
356 set session profiling = ON;
360 select @@profiling;
361 @@profiling
364 select @@profiling;
365 @@profiling
367 set session profiling = ON;
371 select @@profiling;
372 @@profiling
375 select @@profiling;
376 @@profiling
379 select @@profiling;
380 @@profiling
383 select @@profiling;
384 @@profiling
387 select @@profiling, @@autocommit;
388 @@profiling	@@autocommit
391 select @@profiling;
392 @@profiling
398 select @@profiling;
399 @@profiling
403 select @@profiling;
404 @@profiling
408 select @@profiling;
409 @@profiling
412 select @@profiling;
413 @@profiling
420 set session profiling = OFF;