1SET @start_global_value = @@global.profiling;
2Warnings:
3Warning	1287	'@@profiling' is deprecated and will be removed in a future release.
4SELECT @start_global_value;
5@start_global_value
60
7select @@global.profiling;
8@@global.profiling
90
10Warnings:
11Warning	1287	'@@profiling' is deprecated and will be removed in a future release.
12select @@session.profiling;
13@@session.profiling
140
15Warnings:
16Warning	1287	'@@profiling' is deprecated and will be removed in a future release.
17show global variables like 'profiling';
18Variable_name	Value
19profiling	OFF
20show session variables like 'profiling';
21Variable_name	Value
22profiling	OFF
23select * from information_schema.global_variables where variable_name='profiling';
24VARIABLE_NAME	VARIABLE_VALUE
25PROFILING	OFF
26select * from information_schema.session_variables where variable_name='profiling';
27VARIABLE_NAME	VARIABLE_VALUE
28PROFILING	OFF
29set global profiling=1;
30Warnings:
31Warning	1287	'@@profiling' is deprecated and will be removed in a future release.
32set session profiling=ON;
33Warnings:
34Warning	1287	'@@profiling' is deprecated and will be removed in a future release.
35select @@global.profiling;
36@@global.profiling
371
38Warnings:
39Warning	1287	'@@profiling' is deprecated and will be removed in a future release.
40select @@session.profiling;
41@@session.profiling
421
43Warnings:
44Warning	1287	'@@profiling' is deprecated and will be removed in a future release.
45show global variables like 'profiling';
46Variable_name	Value
47profiling	ON
48show session variables like 'profiling';
49Variable_name	Value
50profiling	ON
51select * from information_schema.global_variables where variable_name='profiling';
52VARIABLE_NAME	VARIABLE_VALUE
53PROFILING	ON
54select * from information_schema.session_variables where variable_name='profiling';
55VARIABLE_NAME	VARIABLE_VALUE
56PROFILING	ON
57set global profiling=0;
58Warnings:
59Warning	1287	'@@profiling' is deprecated and will be removed in a future release.
60set session profiling=OFF;
61Warnings:
62Warning	1287	'@@profiling' is deprecated and will be removed in a future release.
63select @@global.profiling;
64@@global.profiling
650
66Warnings:
67Warning	1287	'@@profiling' is deprecated and will be removed in a future release.
68select @@session.profiling;
69@@session.profiling
700
71Warnings:
72Warning	1287	'@@profiling' is deprecated and will be removed in a future release.
73show global variables like 'profiling';
74Variable_name	Value
75profiling	OFF
76show session variables like 'profiling';
77Variable_name	Value
78profiling	OFF
79select * from information_schema.global_variables where variable_name='profiling';
80VARIABLE_NAME	VARIABLE_VALUE
81PROFILING	OFF
82select * from information_schema.session_variables where variable_name='profiling';
83VARIABLE_NAME	VARIABLE_VALUE
84PROFILING	OFF
85set global profiling=1.1;
86ERROR 42000: Incorrect argument type to variable 'profiling'
87set global profiling=1e1;
88ERROR 42000: Incorrect argument type to variable 'profiling'
89set global profiling="foo";
90ERROR 42000: Variable 'profiling' can't be set to the value of 'foo'
91SET @@global.profiling = @start_global_value;
92Warnings:
93Warning	1287	'@@profiling' is deprecated and will be removed in a future release.
94SELECT @@global.profiling;
95@@global.profiling
960
97Warnings:
98Warning	1287	'@@profiling' is deprecated and will be removed in a future release.
99