1SET @start_global_value = @@global.innodb_ft_aux_table; 2SELECT @start_global_value; 3@start_global_value 4NULL 5select @@session.innodb_ft_aux_table; 6ERROR HY000: Variable 'innodb_ft_aux_table' is a GLOBAL variable 7show global variables like 'innodb_ft_aux_table'; 8Variable_name Value 9innodb_ft_aux_table 10show session variables like 'innodb_ft_aux_table'; 11Variable_name Value 12innodb_ft_aux_table 13select * from information_schema.global_variables where variable_name='innodb_ft_aux_table'; 14VARIABLE_NAME VARIABLE_VALUE 15INNODB_FT_AUX_TABLE 16select * from information_schema.session_variables where variable_name='innodb_ft_aux_table'; 17VARIABLE_NAME VARIABLE_VALUE 18INNODB_FT_AUX_TABLE 19set session innodb_ft_aux_table='Salmon'; 20ERROR HY000: Variable 'innodb_ft_aux_table' is a GLOBAL variable and should be set with SET GLOBAL 21set @@session.innodb_ft_aux_table='Salmon'; 22ERROR HY000: Variable 'innodb_ft_aux_table' is a GLOBAL variable and should be set with SET GLOBAL 23set global innodb_ft_aux_table=1.1; 24ERROR 42000: Incorrect argument type to variable 'innodb_ft_aux_table' 25set global innodb_ft_aux_table=1e1; 26ERROR 42000: Incorrect argument type to variable 'innodb_ft_aux_table' 27set global innodb_ft_aux_table='Salmon'; 28ERROR 42000: Variable 'innodb_ft_aux_table' can't be set to the value of 'Salmon' 29SET @@global.innodb_ft_aux_table = @start_global_value; 30SELECT @@global.innodb_ft_aux_table; 31@@global.innodb_ft_aux_table 32NULL 33