5
5
set @my_max_connect_errors =@@global.max_connect_errors;
6
6
set @my_max_heap_table_size =@@global.max_heap_table_size;
7
7
set @my_max_join_size =@@global.max_join_size;
8
set @my_drizzle_protocol_buffer_length =@@global.drizzle_protocol_buffer_length;
8
set @my_mysql_protocol_buffer_length =@@global.mysql_protocol_buffer_length;
9
9
set @my_server_id =@@global.server_id;
10
10
set @my_storage_engine =@@global.storage_engine;
11
11
set @my_myisam_sort_buffer_size =@@global.myisam_sort_buffer_size;
183
183
select * from data_dictionary.global_variables where variable_name like 'myisam_max_sort_file_size';
184
184
VARIABLE_NAME VARIABLE_VALUE
185
185
myisam_max_sort_file_size 2147483647
186
set global drizzle_protocol_buffer_length=1024;
187
show global variables like 'drizzle_protocol_buffer_%';
189
drizzle_protocol_buffer_length 1024
190
select * from data_dictionary.global_variables where variable_name like 'drizzle_protocol_buffer_%';
191
VARIABLE_NAME VARIABLE_VALUE
192
drizzle_protocol_buffer_length 1024
193
show global variables like 'drizzle_protocol_buffer_%';
195
drizzle_protocol_buffer_length 1024
196
select * from data_dictionary.global_variables where variable_name like 'drizzle_protocol_buffer_%';
197
VARIABLE_NAME VARIABLE_VALUE
198
drizzle_protocol_buffer_length 1024
199
set global drizzle_protocol_buffer_length=1;
186
set global mysql_protocol_buffer_length=1024;
187
show global variables like 'mysql_protocol_buffer_%';
189
mysql_protocol_buffer_length 1024
190
select * from data_dictionary.global_variables where variable_name like 'mysql_protocol_buffer_%';
191
VARIABLE_NAME VARIABLE_VALUE
192
mysql_protocol_buffer_length 1024
193
show global variables like 'mysql_protocol_buffer_%';
195
mysql_protocol_buffer_length 1024
196
select * from data_dictionary.global_variables where variable_name like 'mysql_protocol_buffer_%';
197
VARIABLE_NAME VARIABLE_VALUE
198
mysql_protocol_buffer_length 1024
199
set global mysql_protocol_buffer_length=1;
201
201
Error 1292 Truncated incorrect buffer_length value: '1'
202
show variables like 'drizzle_protocol_buffer_length';
202
show variables like 'mysql_protocol_buffer_length';
203
203
Variable_name Value
204
drizzle_protocol_buffer_length 1024
205
set global drizzle_protocol_buffer_length=2000000000;
204
mysql_protocol_buffer_length 1024
205
set global mysql_protocol_buffer_length=2000000000;
207
207
Error 1292 Truncated incorrect buffer_length value: '2000000000'
208
show variables like 'drizzle_protocol_buffer_length';
208
show variables like 'mysql_protocol_buffer_length';
209
209
Variable_name Value
210
drizzle_protocol_buffer_length 1048576
210
mysql_protocol_buffer_length 1048576
211
211
show variables like '%alloc%';
212
212
Variable_name Value
213
213
innodb_use_sys_malloc ON
298
298
set global myisam_sort_buffer_size=100;
300
300
Error 1292 Truncated incorrect sort_buffer_size value: '100'
301
set global drizzle_protocol_buffer_length=100;
301
set global mysql_protocol_buffer_length=100;
303
303
Error 1292 Truncated incorrect buffer_length value: '100'
304
304
set read_buffer_size=100;
581
581
set global max_write_lock_count =default;
582
582
set global myisam_data_pointer_size =@my_myisam_data_pointer_size;
583
583
ERROR 42000: Incorrect argument type to variable 'myisam_data_pointer_size'
584
set global drizzle_protocol_buffer_length= @my_drizzle_protocol_buffer_length;
584
set global mysql_protocol_buffer_length= @my_mysql_protocol_buffer_length;
585
585
set global server_id =@my_server_id;
586
586
set global storage_engine =@my_storage_engine;
587
587
set global thread_cache_size =@my_thread_cache_size;