Debian Codegraph @

mysql-test/suite/sys_vars/r/profiling_basic.result

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