Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_rollback_segments_basic.test

raw
1 ############## mysql-test/t/innodb_rollback_segments_basic.test ###############
2 # #
3 # Variable Name: innodb_rollback_segments #
4 # Scope: Global #
5 # Access Type: Static #
6 # Data Type: numeric #
7 # #
8 # #
9 # Creation Date: 2011-07-05 #
10 # Author: Sunny Bains #
11 # Modified: Kevin Lewis 2015-12-15 #
12 # innodb_undo_logs -> innodb_rollback_segments #
13 # #
14 # Description: Read-Write config global variable innodb_rollback_segments #
15 # * Value check #
16 # * Scope check #
17 # #
18 ###############################################################################
19
20
21 SET @start_global_value = @@global.innodb_rollback_segments;
22 SELECT @start_global_value;
23
24 --echo #
25 --echo # Default value is 128 and exists as global only
26 --echo #
27 SELECT @@GLOBAL.innodb_rollback_segments;
28 SELECT @@GLOBAL.innodb_rollback_segments >=0;
29 SELECT @@GLOBAL.innodb_rollback_segments <=128;
30 SELECT COUNT(@@GLOBAL.innodb_rollback_segments);
31 SELECT COUNT(@@innodb_rollback_segments);
32 SHOW GLOBAL variables LIKE 'innodb_rollback_segments';
33 SHOW SESSION variables LIKE 'innodb_rollback_segments';
34
35 --echo # Expected below: error 'Variable is a GLOBAL variable'
36 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
37 SELECT @@SESSION.innodb_rollback_segments;
38 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
39 SELECT COUNT(@@SESSION.innodb_rollback_segments);
40 --Error ER_BAD_FIELD_ERROR
41 SELECT innodb_rollback_segments;
42
43 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
44 SELECT @@LOCAL.innodb_rollback_segments;
45 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
46 SELECT COUNT(@@LOCAL.innodb_rollback_segments);
47 --Error ER_BAD_FIELD_ERROR
48 SELECT innodb_rollback_segments;
49
50 --echo #
51 --echo # Check if accessing variable with and without GLOBAL point to same variable
52 --echo #
53 SELECT @@innodb_rollback_segments = @@GLOBAL.innodb_rollback_segments;
54
55 --echo #
56 --echo # Check if the value in GLOBAL table matches value in performance_schema
57 --echo #
58 --disable_warnings
59 SELECT * FROM performance_schema.global_variables
60 WHERE variable_name='innodb_rollback_segments';
61 SELECT * FROM performance_schema.session_variables
62 WHERE variable_name='innodb_rollback_segments';
63 --enable_warnings
64
65 --echo #
66 --echo # Check if value can be set
67 --echo #
68 SET GLOBAL innodb_rollback_segments=100;
69 SELECT @@global.innodb_rollback_segments;
70
71 --disable_warnings
72 SELECT * FROM performance_schema.global_variables
73 WHERE variable_name='innodb_rollback_segments';
74 SELECT * FROM performance_schema.session_variables
75 WHERE variable_name='innodb_rollback_segments';
76 --enable_warnings
77
78 --error ER_GLOBAL_VARIABLE
79 SET SESSION innodb_rollback_segments=101;
80
81 --echo #
82 --echo # Valid values are 1 - 128
83 --echo #
84 --error ER_WRONG_TYPE_FOR_VAR
85 SET GLOBAL innodb_rollback_segments=1.1;
86 --error ER_WRONG_TYPE_FOR_VAR
87 SET GLOBAL innodb_rollback_segments=1e1;
88 --error ER_WRONG_TYPE_FOR_VAR
89 SET GLOBAL innodb_rollback_segments="foo";
90 SET GLOBAL innodb_rollback_segments=-7;
91 SELECT @@global.innodb_rollback_segments;
92 SET GLOBAL innodb_rollback_segments=0;
93 SELECT @@global.innodb_rollback_segments;
94 SET GLOBAL innodb_rollback_segments=50;
95 SELECT @@global.innodb_rollback_segments;
96 SET GLOBAL innodb_rollback_segments=129;
97 SELECT @@global.innodb_rollback_segments;
98
99 --disable_warnings
100 SELECT * FROM performance_schema.global_variables
101 WHERE variable_name='innodb_rollback_segments';
102 --enable_warnings
103
104 --echo #
105 --echo # cleanup
106 --echo #
107 SET @@global.innodb_rollback_segments = @start_global_value;
108 SELECT @@global.innodb_rollback_segments;