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