1SET @start_value = @@global.innodb_max_bitmap_file_size;
2SELECT @start_value;
3@start_value
4104857600
5SET @@global.innodb_max_bitmap_file_size = 5000;
6SET @@global.innodb_max_bitmap_file_size = DEFAULT;
7SELECT @@global.innodb_max_bitmap_file_size;
8@@global.innodb_max_bitmap_file_size
9104857600
10SET @@global.innodb_max_bitmap_file_size = 4096;
11SELECT @@global.innodb_max_bitmap_file_size;
12@@global.innodb_max_bitmap_file_size
134096
14SET @@global.innodb_max_bitmap_file_size = 4097;
15SELECT @@global.innodb_max_bitmap_file_size;
16@@global.innodb_max_bitmap_file_size
174097
18SET @@global.innodb_max_bitmap_file_size = 18446744073709551614;
19SELECT @@global.innodb_max_bitmap_file_size;
20@@global.innodb_max_bitmap_file_size
2118446744073709551614
22SET @@global.innodb_max_bitmap_file_size = 18446744073709551615;
23SELECT @@global.innodb_max_bitmap_file_size;
24@@global.innodb_max_bitmap_file_size
2518446744073709551615
26SET @@global.innodb_max_bitmap_file_size = 4095;
27Warnings:
28Warning	1292	Truncated incorrect innodb_max_bitmap_file_size value: '4095'
29SELECT @@global.innodb_max_bitmap_file_size;
30@@global.innodb_max_bitmap_file_size
314096
32SET @@global.innodb_max_bitmap_file_size = 18446744073709551616;
33ERROR 42000: Incorrect argument type to variable 'innodb_max_bitmap_file_size'
34SELECT @@global.innodb_max_bitmap_file_size;
35@@global.innodb_max_bitmap_file_size
364096
37SET @@global.innodb_max_bitmap_file_size = 18446744073709551617;
38ERROR 42000: Incorrect argument type to variable 'innodb_max_bitmap_file_size'
39SELECT @@global.innodb_max_bitmap_file_size;
40@@global.innodb_max_bitmap_file_size
414096
42SET @@global.innodb_max_bitmap_file_size = 105.54;
43ERROR 42000: Incorrect argument type to variable 'innodb_max_bitmap_file_size'
44SELECT @@global.innodb_max_bitmap_file_size;
45@@global.innodb_max_bitmap_file_size
464096
47SET @@global.innodb_max_bitmap_file_size = -200;
48Warnings:
49Warning	1292	Truncated incorrect innodb_max_bitmap_file_size value: '-200'
50SELECT @@global.innodb_max_bitmap_file_size;
51@@global.innodb_max_bitmap_file_size
524096
53SET @@global.innodb_max_bitmap_file_size = ON;
54ERROR 42000: Incorrect argument type to variable 'innodb_max_bitmap_file_size'
55SELECT @@global.innodb_max_bitmap_file_size;
56@@global.innodb_max_bitmap_file_size
574096
58SET @@global.innodb_max_bitmap_file_size = 'foo';
59ERROR 42000: Incorrect argument type to variable 'innodb_max_bitmap_file_size'
60SELECT @@global.innodb_max_bitmap_file_size;
61@@global.innodb_max_bitmap_file_size
624096
63SET @@session.innodb_max_bitmap_file_size = 4096;
64ERROR HY000: Variable 'innodb_max_bitmap_file_size' is a GLOBAL variable and should be set with SET GLOBAL
65SELECT @@session.innodb_max_bitmap_file_size;
66ERROR HY000: Variable 'innodb_max_bitmap_file_size' is a GLOBAL variable
67SELECT @@global.innodb_max_bitmap_file_size = VARIABLE_VALUE
68FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
69WHERE VARIABLE_NAME='innodb_max_bitmap_file_size';
70@@global.innodb_max_bitmap_file_size = VARIABLE_VALUE
711
72Warnings:
73Warning	1287	'INFORMATION_SCHEMA.GLOBAL_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.global_variables instead
74SELECT @@global.innodb_max_bitmap_file_size = VARIABLE_VALUE
75FROM INFORMATION_SCHEMA.SESSION_VARIABLES
76WHERE VARIABLE_NAME='innodb_max_bitmap_file_size';
77@@global.innodb_max_bitmap_file_size = VARIABLE_VALUE
781
79Warnings:
80Warning	1287	'INFORMATION_SCHEMA.SESSION_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.session_variables instead
81SET @@global.innodb_max_bitmap_file_size=6789;
82SELECT @@global.innodb_max_bitmap_file_size=@@innodb_max_bitmap_file_size;
83@@global.innodb_max_bitmap_file_size=@@innodb_max_bitmap_file_size
841
85SET @@global.innodb_max_bitmap_file_size=@start_value;
86SELECT @@global.innodb_max_bitmap_file_size;
87@@global.innodb_max_bitmap_file_size
88104857600
89