Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.innodb_rollback_segments;
2 SELECT @start_global_value;
3 @start_global_value
4 128
5 #
6 # Default value is 128 and exists as global only
7 #
8 SELECT @@GLOBAL.innodb_rollback_segments;
9 @@GLOBAL.innodb_rollback_segments
10 128
11 SELECT @@GLOBAL.innodb_rollback_segments >=0;
12 @@GLOBAL.innodb_rollback_segments >=0
13 1
14 SELECT @@GLOBAL.innodb_rollback_segments <=128;
15 @@GLOBAL.innodb_rollback_segments <=128
16 1
17 SELECT COUNT(@@GLOBAL.innodb_rollback_segments);
18 COUNT(@@GLOBAL.innodb_rollback_segments)
19 1
20 SELECT COUNT(@@innodb_rollback_segments);
21 COUNT(@@innodb_rollback_segments)
22 1
23 SHOW GLOBAL variables LIKE 'innodb_rollback_segments';
24 Variable_name Value
25 innodb_rollback_segments 128
26 SHOW SESSION variables LIKE 'innodb_rollback_segments';
27 Variable_name Value
28 innodb_rollback_segments 128
29 # Expected below: error 'Variable is a GLOBAL variable'
30 SELECT @@SESSION.innodb_rollback_segments;
31 ERROR HY000: Variable 'innodb_rollback_segments' is a GLOBAL variable
32 SELECT COUNT(@@SESSION.innodb_rollback_segments);
33 ERROR HY000: Variable 'innodb_rollback_segments' is a GLOBAL variable
34 SELECT innodb_rollback_segments;
35 ERROR 42S22: Unknown column 'innodb_rollback_segments' in 'field list'
36 SELECT @@LOCAL.innodb_rollback_segments;
37 ERROR HY000: Variable 'innodb_rollback_segments' is a GLOBAL variable
38 SELECT COUNT(@@LOCAL.innodb_rollback_segments);
39 ERROR HY000: Variable 'innodb_rollback_segments' is a GLOBAL variable
40 SELECT innodb_rollback_segments;
41 ERROR 42S22: Unknown column 'innodb_rollback_segments' in 'field list'
42 #
43 # Check if accessing variable with and without GLOBAL point to same variable
44 #
45 SELECT @@innodb_rollback_segments = @@GLOBAL.innodb_rollback_segments;
46 @@innodb_rollback_segments = @@GLOBAL.innodb_rollback_segments
47 1
48 #
49 # Check if the value in GLOBAL table matches value in performance_schema
50 #
51 SELECT * FROM performance_schema.global_variables
52 WHERE variable_name='innodb_rollback_segments';
53 VARIABLE_NAME VARIABLE_VALUE
54 innodb_rollback_segments 128
55 SELECT * FROM performance_schema.session_variables
56 WHERE variable_name='innodb_rollback_segments';
57 VARIABLE_NAME VARIABLE_VALUE
58 innodb_rollback_segments 128
59 #
60 # Check if value can be set
61 #
62 SET GLOBAL innodb_rollback_segments=100;
63 SELECT @@global.innodb_rollback_segments;
64 @@global.innodb_rollback_segments
65 100
66 SELECT * FROM performance_schema.global_variables
67 WHERE variable_name='innodb_rollback_segments';
68 VARIABLE_NAME VARIABLE_VALUE
69 innodb_rollback_segments 100
70 SELECT * FROM performance_schema.session_variables
71 WHERE variable_name='innodb_rollback_segments';
72 VARIABLE_NAME VARIABLE_VALUE
73 innodb_rollback_segments 100
74 SET SESSION innodb_rollback_segments=101;
75 ERROR HY000: Variable 'innodb_rollback_segments' is a GLOBAL variable and should be set with SET GLOBAL
76 #
77 # Valid values are 1 - 128
78 #
79 SET GLOBAL innodb_rollback_segments=1.1;
80 ERROR 42000: Incorrect argument type to variable 'innodb_rollback_segments'
81 SET GLOBAL innodb_rollback_segments=1e1;
82 ERROR 42000: Incorrect argument type to variable 'innodb_rollback_segments'
83 SET GLOBAL innodb_rollback_segments="foo";
84 ERROR 42000: Incorrect argument type to variable 'innodb_rollback_segments'
85 SET GLOBAL innodb_rollback_segments=-7;
86 Warnings:
87 Warning 1292 Truncated incorrect innodb_rollback_segments value: '-7'
88 SELECT @@global.innodb_rollback_segments;
89 @@global.innodb_rollback_segments
90 1
91 SET GLOBAL innodb_rollback_segments=0;
92 Warnings:
93 Warning 1292 Truncated incorrect innodb_rollback_segments value: '0'
94 SELECT @@global.innodb_rollback_segments;
95 @@global.innodb_rollback_segments
96 1
97 SET GLOBAL innodb_rollback_segments=50;
98 SELECT @@global.innodb_rollback_segments;
99 @@global.innodb_rollback_segments
100 50
101 SET GLOBAL innodb_rollback_segments=129;
102 Warnings:
103 Warning 1292 Truncated incorrect innodb_rollback_segments value: '129'
104 SELECT @@global.innodb_rollback_segments;
105 @@global.innodb_rollback_segments
106 128
107 SELECT * FROM performance_schema.global_variables
108 WHERE variable_name='innodb_rollback_segments';
109 VARIABLE_NAME VARIABLE_VALUE
110 innodb_rollback_segments 128
111 #
112 # cleanup
113 #
114 SET @@global.innodb_rollback_segments = @start_global_value;
115 SELECT @@global.innodb_rollback_segments;
116 @@global.innodb_rollback_segments
117 128