Lines Matching refs:max_binlog_stmt_cache_size

3 # Variable Name: max_binlog_stmt_cache_size                                   #
18 #              max_binlog_stmt_cache_size that checks                         #
33 #           START OF max_binlog_stmt_cache_size TESTS                    #
38 # Saving initial value of max_binlog_stmt_cache_size in a temporary variable #
41 SET @start_value = @@global.max_binlog_stmt_cache_size;
42 --replace_result 18446744073709547520 max_binlog_stmt_cache_size 4294963200 max_binlog_stmt_cache_s…
48 #       Display the DEFAULT value of max_binlog_stmt_cache_size        #
51 SET @@global.max_binlog_stmt_cache_size = 5000;
52 SET @@global.max_binlog_stmt_cache_size = DEFAULT;
53 --replace_result 18446744073709547520 max_binlog_stmt_cache_size 4294963200 max_binlog_stmt_cache_s…
54 SELECT @@global.max_binlog_stmt_cache_size;
62 SET @@global.max_binlog_stmt_cache_size = @start_value;
63 SELECT @@global.max_binlog_stmt_cache_size = 4294967295;
67 #   Change the value of max_binlog_stmt_cache_size to a valid value    #
70 SET @@global.max_binlog_stmt_cache_size = 4096;
71 SELECT @@global.max_binlog_stmt_cache_size;
72 SET @@global.max_binlog_stmt_cache_size = 4294967295;
73 SELECT @@global.max_binlog_stmt_cache_size;
74 SET @@global.max_binlog_stmt_cache_size = 4294967294;
75 SELECT @@global.max_binlog_stmt_cache_size;
76 SET @@global.max_binlog_stmt_cache_size = 4097;
77 SELECT @@global.max_binlog_stmt_cache_size;
78 SET @@global.max_binlog_stmt_cache_size = 65535;
79 SELECT @@global.max_binlog_stmt_cache_size;
84 #     Change the value of max_binlog_stmt_cache_size to invalid value     #
87 SET @@global.max_binlog_stmt_cache_size = -1;
88 SELECT @@global.max_binlog_stmt_cache_size;
89 SET @@global.max_binlog_stmt_cache_size = 100000000000;
90 --replace_result 99999997952 max_binlog_stmt_cache_size 4294963200 max_binlog_stmt_cache_size
91 SELECT @@global.max_binlog_stmt_cache_size;
92 SET @@global.max_binlog_stmt_cache_size = 1024*1024;
94 SET @@global.max_binlog_stmt_cache_size = 10000.01;
95 SELECT @@global.max_binlog_stmt_cache_size;
96 SET @@global.max_binlog_stmt_cache_size = -1024;
97 SELECT @@global.max_binlog_stmt_cache_size;
98 SET @@global.max_binlog_stmt_cache_size = 1024;
99 SELECT @@global.max_binlog_stmt_cache_size;
101 SET @@global.max_binlog_stmt_cache_size = 4294967296;
103 --replace_result 4294963200 max_binlog_stmt_cache_size 4294967296 max_binlog_stmt_cache_size
104 SELECT @@global.max_binlog_stmt_cache_size;
105 SET @@global.max_binlog_stmt_cache_size = 4095;
106 SELECT @@global.max_binlog_stmt_cache_size;
109 SET @@global.max_binlog_stmt_cache_size = ON;
110 SELECT @@global.max_binlog_stmt_cache_size;
112 SET @@global.max_binlog_stmt_cache_size = 'test';
113 SELECT @@global.max_binlog_stmt_cache_size;
118 #    Test if accessing session max_binlog_stmt_cache_size gives error     #
122 SET @@session.max_binlog_stmt_cache_size = 4096;
124 SELECT @@session.max_binlog_stmt_cache_size;
132 SELECT @@global.max_binlog_stmt_cache_size = VARIABLE_VALUE 
134 WHERE VARIABLE_NAME='max_binlog_stmt_cache_size';
136 SELECT @@max_binlog_stmt_cache_size = VARIABLE_VALUE 
138 WHERE VARIABLE_NAME='max_binlog_stmt_cache_size';
146 SET @@global.max_binlog_stmt_cache_size = TRUE;
147 SELECT @@global.max_binlog_stmt_cache_size;
148 SET @@global.max_binlog_stmt_cache_size = FALSE;
149 SELECT @@global.max_binlog_stmt_cache_size;
157 SET @@global.max_binlog_stmt_cache_size = 5000;
158 SELECT @@max_binlog_stmt_cache_size = @@global.max_binlog_stmt_cache_size;
163 # Check if max_binlog_stmt_cache_size can be accessed with and without @@ sign #
167 SET max_binlog_stmt_cache_size = 6000;
168 SELECT @@max_binlog_stmt_cache_size;
170 SELECT local.max_binlog_stmt_cache_size;
172 SELECT global.max_binlog_stmt_cache_size;
174 SELECT max_binlog_stmt_cache_size = @@session.max_binlog_stmt_cache_size;
181 SET @@global.max_binlog_stmt_cache_size = @start_value;
182 --replace_result 4294963200 max_binlog_stmt_cache_size 18446744073709547520 max_binlog_stmt_cache_s…
183 SELECT @@global.max_binlog_stmt_cache_size;
187 #           END OF max_binlog_stmt_cache_size TESTS                    #