Debian Codegraph @

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

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