Lines Matching refs:max_binlog_stmt_cache_size

1 SET @start_max_binlog_stmt_cache_size = @@global.max_binlog_stmt_cache_size;
10 SET @@global.max_binlog_stmt_cache_size = 5000;
12 Warning	1292	Truncated incorrect max_binlog_stmt_cache_size value: '5000'
13 …e (32768) is greater than max_binlog_stmt_cache_size (4096); setting binlog_stmt_cache_size equal …
14 SET @@global.max_binlog_stmt_cache_size = DEFAULT;
15 SELECT @@global.max_binlog_stmt_cache_size;
16 @@global.max_binlog_stmt_cache_size
19 SET @@global.max_binlog_stmt_cache_size = @start_max_binlog_stmt_cache_size;
20 SELECT @@global.max_binlog_stmt_cache_size = 4294967295;
21 @@global.max_binlog_stmt_cache_size = 4294967295
24 SET @@global.max_binlog_stmt_cache_size = 4096;
25 SELECT @@global.max_binlog_stmt_cache_size;
26 @@global.max_binlog_stmt_cache_size
28 SET @@global.max_binlog_stmt_cache_size = 4294967295;
30 Warning	1292	Truncated incorrect max_binlog_stmt_cache_size value: '4294967295'
31 SELECT @@global.max_binlog_stmt_cache_size;
32 @@global.max_binlog_stmt_cache_size
34 SET @@global.max_binlog_stmt_cache_size = 4294967294;
36 Warning	1292	Truncated incorrect max_binlog_stmt_cache_size value: '4294967294'
37 SELECT @@global.max_binlog_stmt_cache_size;
38 @@global.max_binlog_stmt_cache_size
40 SET @@global.max_binlog_stmt_cache_size = 4097;
42 Warning	1292	Truncated incorrect max_binlog_stmt_cache_size value: '4097'
43 SELECT @@global.max_binlog_stmt_cache_size;
44 @@global.max_binlog_stmt_cache_size
46 SET @@global.max_binlog_stmt_cache_size = 65535;
48 Warning	1292	Truncated incorrect max_binlog_stmt_cache_size value: '65535'
49 SELECT @@global.max_binlog_stmt_cache_size;
50 @@global.max_binlog_stmt_cache_size
53 SET @@global.max_binlog_stmt_cache_size = -1;
55 Warning	1292	Truncated incorrect max_binlog_stmt_cache_size value: '-1'
56 SELECT @@global.max_binlog_stmt_cache_size;
57 @@global.max_binlog_stmt_cache_size
59 SET @@global.max_binlog_stmt_cache_size = 100000000000;
61 Warning	1292	Truncated incorrect max_binlog_stmt_cache_size value: '100000000000'
62 SELECT @@global.max_binlog_stmt_cache_size;
63 @@global.max_binlog_stmt_cache_size
65 SET @@global.max_binlog_stmt_cache_size = 10000.01;
66 ERROR 42000: Incorrect argument type to variable 'max_binlog_stmt_cache_size'
67 SELECT @@global.max_binlog_stmt_cache_size;
68 @@global.max_binlog_stmt_cache_size
70 SET @@global.max_binlog_stmt_cache_size = -1024;
72 Warning	1292	Truncated incorrect max_binlog_stmt_cache_size value: '-1024'
73 SELECT @@global.max_binlog_stmt_cache_size;
74 @@global.max_binlog_stmt_cache_size
76 SET @@global.max_binlog_stmt_cache_size = 1024;
78 Warning	1292	Truncated incorrect max_binlog_stmt_cache_size value: '1024'
79 SELECT @@global.max_binlog_stmt_cache_size;
80 @@global.max_binlog_stmt_cache_size
82 SET @@global.max_binlog_stmt_cache_size = 4294967296;
83 SELECT @@global.max_binlog_stmt_cache_size;
84 @@global.max_binlog_stmt_cache_size
86 SET @@global.max_binlog_stmt_cache_size = 4095;
88 Warning	1292	Truncated incorrect max_binlog_stmt_cache_size value: '4095'
89 SELECT @@global.max_binlog_stmt_cache_size;
90 @@global.max_binlog_stmt_cache_size
92 SET @@global.max_binlog_stmt_cache_size = ON;
93 ERROR 42000: Incorrect argument type to variable 'max_binlog_stmt_cache_size'
94 SELECT @@global.max_binlog_stmt_cache_size;
95 @@global.max_binlog_stmt_cache_size
97 SET @@global.max_binlog_stmt_cache_size = 'test';
98 ERROR 42000: Incorrect argument type to variable 'max_binlog_stmt_cache_size'
99 SELECT @@global.max_binlog_stmt_cache_size;
100 @@global.max_binlog_stmt_cache_size
103 SET @@session.max_binlog_stmt_cache_size = 4096;
104 ERROR HY000: Variable 'max_binlog_stmt_cache_size' is a GLOBAL variable and should be set with SET …
105 SELECT @@session.max_binlog_stmt_cache_size;
106 ERROR HY000: Variable 'max_binlog_stmt_cache_size' is a GLOBAL variable
108 SELECT @@global.max_binlog_stmt_cache_size = VARIABLE_VALUE 
110 WHERE VARIABLE_NAME='max_binlog_stmt_cache_size';
111 @@global.max_binlog_stmt_cache_size = VARIABLE_VALUE
113 SELECT @@max_binlog_stmt_cache_size = VARIABLE_VALUE 
115 WHERE VARIABLE_NAME='max_binlog_stmt_cache_size';
116 @@max_binlog_stmt_cache_size = VARIABLE_VALUE
119 SET @@global.max_binlog_stmt_cache_size = TRUE;
121 Warning	1292	Truncated incorrect max_binlog_stmt_cache_size value: '1'
122 SELECT @@global.max_binlog_stmt_cache_size;
123 @@global.max_binlog_stmt_cache_size
125 SET @@global.max_binlog_stmt_cache_size = FALSE;
127 Warning	1292	Truncated incorrect max_binlog_stmt_cache_size value: '0'
128 SELECT @@global.max_binlog_stmt_cache_size;
129 @@global.max_binlog_stmt_cache_size
132 SET @@global.max_binlog_stmt_cache_size = 5000;
134 Warning	1292	Truncated incorrect max_binlog_stmt_cache_size value: '5000'
135 SELECT @@max_binlog_stmt_cache_size = @@global.max_binlog_stmt_cache_size;
136 @@max_binlog_stmt_cache_size = @@global.max_binlog_stmt_cache_size
139 SET max_binlog_stmt_cache_size = 6000;
140 ERROR HY000: Variable 'max_binlog_stmt_cache_size' is a GLOBAL variable and should be set with SET …
141 SELECT @@max_binlog_stmt_cache_size;
142 @@max_binlog_stmt_cache_size
144 SET local.max_binlog_stmt_cache_size = 7000;
145 …r MySQL server version for the right syntax to use near 'local.max_binlog_stmt_cache_size = 7000' …
146 SELECT local.max_binlog_stmt_cache_size;
148 SET global.max_binlog_stmt_cache_size = 8000;
149 … MySQL server version for the right syntax to use near 'global.max_binlog_stmt_cache_size = 8000' …
150 SELECT global.max_binlog_stmt_cache_size;
152 SELECT max_binlog_stmt_cache_size = @@session.max_binlog_stmt_cache_size;
153 ERROR 42S22: Unknown column 'max_binlog_stmt_cache_size' in 'field list'
154 SET @@global.max_binlog_stmt_cache_size = @start_max_binlog_stmt_cache_size;
155 SELECT @@global.max_binlog_stmt_cache_size;
156 @@global.max_binlog_stmt_cache_size