1SET @start_global_value = @@global.profiling;
2SELECT @start_global_value;
3@start_global_value
40
5select @@global.profiling;
6@@global.profiling
70
8select @@session.profiling;
9@@session.profiling
100
11show global variables like 'profiling';
12Variable_name	Value
13profiling	OFF
14show session variables like 'profiling';
15Variable_name	Value
16profiling	OFF
17select * from information_schema.global_variables where variable_name='profiling';
18VARIABLE_NAME	VARIABLE_VALUE
19PROFILING	OFF
20select * from information_schema.session_variables where variable_name='profiling';
21VARIABLE_NAME	VARIABLE_VALUE
22PROFILING	OFF
23set global profiling=1;
24set session profiling=ON;
25select @@global.profiling;
26@@global.profiling
271
28select @@session.profiling;
29@@session.profiling
301
31show global variables like 'profiling';
32Variable_name	Value
33profiling	ON
34show session variables like 'profiling';
35Variable_name	Value
36profiling	ON
37select * from information_schema.global_variables where variable_name='profiling';
38VARIABLE_NAME	VARIABLE_VALUE
39PROFILING	ON
40select * from information_schema.session_variables where variable_name='profiling';
41VARIABLE_NAME	VARIABLE_VALUE
42PROFILING	ON
43set global profiling=0;
44set session profiling=OFF;
45select @@global.profiling;
46@@global.profiling
470
48select @@session.profiling;
49@@session.profiling
500
51show global variables like 'profiling';
52Variable_name	Value
53profiling	OFF
54show session variables like 'profiling';
55Variable_name	Value
56profiling	OFF
57select * from information_schema.global_variables where variable_name='profiling';
58VARIABLE_NAME	VARIABLE_VALUE
59PROFILING	OFF
60select * from information_schema.session_variables where variable_name='profiling';
61VARIABLE_NAME	VARIABLE_VALUE
62PROFILING	OFF
63set global profiling=1.1;
64ERROR 42000: Incorrect argument type to variable 'profiling'
65set global profiling=1e1;
66ERROR 42000: Incorrect argument type to variable 'profiling'
67set global profiling="foo";
68ERROR 42000: Variable 'profiling' can't be set to the value of 'foo'
69SET @@global.profiling = @start_global_value;
70SELECT @@global.profiling;
71@@global.profiling
720
73