12
12
set @my_max_connect_errors =@@global.max_connect_errors;
13
13
set @my_max_heap_table_size =@@global.max_heap_table_size;
14
14
set @my_max_join_size =@@global.max_join_size;
15
set @my_oldlibdrizzle_buffer_length =@@global.oldlibdrizzle_buffer_length;
15
set @my_drizzle_protocol_buffer_length =@@global.drizzle_protocol_buffer_length;
16
16
set @my_server_id =@@global.server_id;
17
17
set @my_storage_engine =@@global.storage_engine;
18
18
set @my_myisam_sort_buffer_size =@@global.myisam_sort_buffer_size;
113
113
--replace_result 9223372036853727232 FILE_SIZE 2146435072 FILE_SIZE
114
114
select * from information_schema.global_variables where variable_name like 'myisam_max_sort_file_size';
116
set global oldlibdrizzle_buffer_length=1024;
117
show global variables like 'oldlibdrizzle_buffer_%';
118
select * from information_schema.global_variables where variable_name like 'oldlibdrizzle_buffer_%' order by 1;
119
show global variables like 'oldlibdrizzle_buffer_%';
120
select * from information_schema.global_variables where variable_name like 'oldlibdrizzle_buffer_%' order by 1;
121
set global oldlibdrizzle_buffer_length=1;
122
show variables like 'oldlibdrizzle_buffer_length';
116
set global drizzle_protocol_buffer_length=1024;
117
show global variables like 'drizzle_protocol_buffer_%';
118
select * from information_schema.global_variables where variable_name like 'drizzle_protocol_buffer_%' order by 1;
119
show global variables like 'drizzle_protocol_buffer_%';
120
select * from information_schema.global_variables where variable_name like 'drizzle_protocol_buffer_%' order by 1;
121
set global drizzle_protocol_buffer_length=1;
122
show variables like 'drizzle_protocol_buffer_length';
124
set global oldlibdrizzle_buffer_length=2000000000;
125
show variables like 'oldlibdrizzle_buffer_length';
124
set global drizzle_protocol_buffer_length=2000000000;
125
show variables like 'drizzle_protocol_buffer_length';
127
127
show variables like '%alloc%';
128
128
select * from information_schema.session_variables where variable_name like '%alloc%' order by 1;
182
182
set max_sort_length=100;
183
183
set global max_write_lock_count=100;
184
184
set global myisam_sort_buffer_size=100;
185
set global oldlibdrizzle_buffer_length=100;
185
set global drizzle_protocol_buffer_length=100;
186
186
set read_buffer_size=100;
187
187
set read_rnd_buffer_size=100;
188
188
set global server_id=100;
550
550
set global max_write_lock_count =default;
552
552
set global myisam_data_pointer_size =@my_myisam_data_pointer_size;
553
set global oldlibdrizzle_buffer_length= @my_oldlibdrizzle_buffer_length;
553
set global drizzle_protocol_buffer_length= @my_drizzle_protocol_buffer_length;
554
554
set global server_id =@my_server_id;
555
555
set global storage_engine =@my_storage_engine;
added
removed
tests/t/variables.test
